AIRWAY DATA BASE RECORD LAYOUT (AWY-FILE) INFORMATION EFFECTIVE DATE: 05/12/2005 RECORD FORMAT: FIXED LOGICAL RECORD LENGTH: 228 ***************************************************** ***------------------->NOTE<----------------------*** *** DUE TO LATE RECEIPT OF INFORMATION AFTER THE *** *** PUBLISHED CUT-OFF, SOME TURNING-POINTS, ARTCC *** *** BOUNDARY CROSSINGS AND AIRWAY INTERSECTIONS *** *** (DESCRIBED AS UNNAMED NUMERIC POINTS) MAY NOT *** *** APPEAR ON THIS FILE. *** ***_______________________________________________*** ***************************************************** FILE STRUCTURE DESCRIPTION: --------------------------- THERE ARE A VARIABLE NUMBER OF FIXED-LENGTH RECORDS FOR EACH AIRWAY(AWY). THE NUMBER OF RECORDS IS DETERMINED BY THE NUMBER OF POINTS AND THE POINT TO POINT ASSOCIATED INFORMATION DEFINING THE AWY. THE AIRWAY FILE CONSISTS OF INDIVIDUAL POINTS ALONG AN AIRWAY. THESE POINTS MAY BE NAVIGATION FACILITIES, NAMED FIXES, UNNAMED(NUMBERED)AIRWAY CROSSINGS, UNNAMED TURNING POINTS, U.S. BORDERS, OR AIR TRAFFIC CONTROL CENTER(ARTCC) BOUNDARY CROSSING POINTS. DIRECTION OF AIRWAY IS WEST TO EAST AND SOUTH TO NORTH. LAST POINT ON AIRWAY IS THE TERMINATION POINT. EACH OF THE SIX RECORD TYPES IS IDENTIFIED BY A RECORD TYPE INDICATOR (AWY1, AWY2.....AWY5, RMK), AWY DESIGNATION, AWY TYPE, POINT SEQUENCE NUMBER (AWY RECORDS ONLY). ALL POINTS AND POINT TO POINT DATA IS ARRANGED LOGICALLY TO DEFINE THE AIRWAY. GENERAL REMARK ('RMK') DATA FOLLOWS THE DATA FOR THE LAST POINT TO POINT RECORD IN THE ROUTE. THE FILE IS SORTED BY AIRWAY TYPE, AIRWAY DESIGNATION, POINT SEQUENCE NUMBER, AND RECORD SEQUENCE NUMBER(INSURES THAT MULTIPLE RECORDS OF A SPECIFIC TYPE ARE IN POINT/REMARKS ORDER). EACH RECORD ENDS WITH A CARRIAGE RETURN CHARACTER AND LINE FEED CHARACTER (CR/LF). THIS LINE TERMINATOR IS NOT INCLUDED IN THE LOGICAL RECORD LENGTH. DESCRIPTION OF THE RECORD TYPES: -------------------------------- 'AWY1' RECORD TYPE CONTAINS THE BASIC AND MINIMUM ENROUTE ALTITUDE(MEA) DATA FOR EACH AIRWAY POINT/SEGMENT. THERE IS ONE AWY1 RECORD FOR EACH AIRWAY POINT/SEGMENT. 'AWY2' RECORD TYPE CONTAINS THE AIRWAY POINT DESCRIPTION. THERE IS ONE AWY2 RECORD FOR EACH AIRWAY POINT. 'AWY3' RECORD TYPE CONTAINS THE TO CHANGEOVER POINT NAVAID DESCRIPTION (VOR AND JET AIRWAYS ONLY). THERE IS ONE RECORD FOR EACH TO CHANGEOVER POINT NAVAID DESCRIPTION. 'AWY4' RECORD TYPE CONTAINS TEXTUAL INFORMATION REGARDING REMARKS ABOUT THE AWY POINT DATA. EACH AWY4 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE 0 OR MORE AWY4 RECORDS. 'AWY5' RECORD TYPE CONTAINS TEXTUAL INFORMATION REGARDING EXCEPTIONS TO THE STANDARD AWY CHANGEOVER POINT DATA. EACH AWY5 RECORD CONTAINS ONE LINE OF TEXT. THERE CAN BE 0 OR MORE AWY5 RECORDS. 'RMK ' RECORD TYPE CONTAINS TEXTUAL INFORMATION REGARDING REMARKS ABOUT AN ENTIRE ROUTE AND NOT A SPECIFIC AIRWAY POINT. THERE CAN BE 0 OR MORE RMK RECORDS FOR EACH AIRWAY. GENERAL INFORMATION: -------------------- 1. LEFT JUSTIFIED FIELDS HAVE TRAILING BLANKS. 2. RIGHT JUSTIFIED FIELDS HAVE LEADING ZEROS EXCEPT WHEN RIGHT JUSTIFIED ALPHA/NUMERIC(R AN) CONTAINS BLANKS. 3. ELEMENT NUMBER IS FOR INTERNAL REFERENCE ONLY AND NOT IN RECORD. 4. THE UNIQUE RECORD KEY IS MADE UP OF THE AIRWAY DESIGNATION, AIRWAY TYPE, AND THE AIRWAY POINT SEQUENCE NUMBER. IT IS REPEATED ON EACH RECORD. 5. PART95 DESCRIPTION - MINIMUM ENROUTE IFR ALTITUDES OVER BELOW PARTICULAR ROUTES AND INTERSECTIONS (AMENDMENTS PUBLISH EVERY 56 DAYS) (BOOK PUBLISHED SEMI-ANNUALLY) 6. DLID - AIRWAY DESIGNATION BELOW - DESCRIPTION -------------------------------- POSITION ONE(1) ENCODE DECODE ------ ------------------ J = JET ROUTE(J804R) V = VOR AIRWAY(V16, V402 H, V444) A = AMBER COLORED AIRWAY(A16) B = BLUE COLORED AIRWAY(B9) G = GREEN COLORED AIRWAY(G13) R = RED COLORED AIRWAY(R39) Q = GPS RNAV ROUTES (Q102) T = GPS RNAV ROUTES (T238) 7. DLID - AIRWAY TYPE BELOW - DESCRIPTION --------------------------------- POSITION SIX(6) ENCODE DECODE ------ ------------------ A = ALASKA AIRWAY H = HAWAII AIRWAY BLANK = U.S. FEDERAL AIRWAY 8. NAVAID FACILITY TYPE BELOW - DESCRIPTION ------------------------------------ NDB/DME, NDB, VORTAC, VOR, VOR/DME 9. FIX TYPE(FX36) BELOW - DESCRIPTION ------------------------------------------ ARTCC-BDRY, MIL-REP-PT, TURN-PT, AWY-INTXN, REP-PT, COORDN-FIX 10. FIX TYPE PUBLICATION CATEGORY BELOW - GROUP FOR REPORTS AND PUBLICATIONS AS FOLLOW: (USED FOR NAMED FIXES ONLY) DESCRIPTION ---------------------------------------- FIX = (FIX OR MIL) 11. NAVAID FACILITY/FIX STATE P. O. CODE BELOW - 59 = CANADA MX = MEXICO 12. NAVAID FACILITY/FIX LATITUDE/LONGITUDE BELOW - FORMAT VARIABLE, LEFT JUSTIFIED AS FOLLOWS - DEGREES(NNN) - MINUTES(NN) - SECONDS(NN) (.) FRACTION(NNN) & DRTN(A) ---------------------------------------------------------------- 38-05-47.7N 092-33-10.4W 36-13-40.0N 090-02-10.0W J T L S L E N U Y E T O L U S P N A C E M T E G R A M B T T T E E H I N R O T N FIELD DESCRIPTION ********************************************************************* 'AWY1' RECORD TYPE - BASIC AND MINIMUM ENROUTE ALTITUDE (MEA) DATA FOR EACH AIRWAY POINT/SEGMENT ********************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. AWY1: BASIC AND MINIMUM ENROUTE ALTITUDE (MEA) DATA FOR EACH AIRWAY SEGMENT. L AN 0005 00005 DLID AIRWAY DESIGNATION. DESCRIPTION ----------------------- J = JET ROUTE (J804R J802E J800) V = VOR AIRWAY (V16, V402S) A = AMBER COLORED AIRWAY(A16) B = BLUE COLORED AIRWAY(B9) G = GREEN COLORED AIRWAY(G13) R = RED COLORED AIRWAY(R39 ) Q = GPS RNAV ROUTES (Q102) T = GPS RNAV ROUTES (T238) NOTE: R IN THE LAST POSITION INDICATES NAVAID BASED RNAV ROUTE. L AN 0001 00010 DLID AIRWAY TYPE. DESCRIPTION --------------------------- ENCODE DECODE A = ALASKA AIRWAY H = HAWAII VOR AIRWAY BLANK = VOR FEDERAL AIRWAY R N 0005 00011 AR4 AIRWAY POINT SEQUENCE NUMBER L AN 0010 00016 N/A CHART/PUBLICATION EFFECTIVE DATE (MM/DD/YYYY) L AN 0007 00026 AR2 TRACK ANGLE OUTBOUND - RNAV FORMAT: NNN/NNN EX: 095/275 R N 0005 00033 AR2 DISTANCE TO CHANGEOVER POINT - RNAV FORMAT: NNNNN EX: 00030, 00050 L AN 0007 00038 AR3 TRACK ANGLE INBOUND - RNAV FORMAT: NNN/NNN EX: 096/276 R N 0006 00045 AR5 DISTANCE TO NEXT POINT IN NAUTICAL MILES FORMAT: NNN.NN EX: 071.00, 100.00 (RNAV ROUTES) R AN 0006 00051 AR6 BEARING(RESERVED - PRESENTLY 000.00 ENTERED) FORMAT: NNN.NN OR BLANKS EX: 101.00, 000.15, 002.15 R N 0005 00057 AR7 POINT TO POINT MINIMUM ENROUTE ALTITUDE(MEA) FORMAT: NNNNN EX: 05000, 04000 L AN 0006 00062 AR7 POINT TO POINT MINIMUM ENROUTE DIRECTION(MEA) FORMAT: AAAAAAA EX : E BND, SE BND R AN 0005 00068 AR7 POINT TO POINT MINIMUM ENROUTE ALTITUDE(MEA- OPPOSITE DIRECTION) FORMAT: NNNNN OR BLANKS EX : 12000 L AN 0006 00073 AR7 POINT TO POINT MINIMUM ENROUTE DIRECTION(MEA- OPPOSITE DIRECTION) FORMAT: AAAAA EX: W BND, SW BND R AN 0005 00079 AR8 POINT TO POINT MAXIMUM AUTHORIZED ALTITUDE EX: 45000 OR BLANKS L AN 0005 00084 AR9 POINT TO POINT MINIMUM OBSTRUCTION CLEARANCE ALTITUDE(MOCA) EX: 07500 OR BLANKS L AN 0001 00089 AR11 AIRWAY GAP FLAG INDICATOR 'X' ENTERED WHEN AIRWAY DISCONTINUED R N 0003 00090 AR12 DISTANCE FROM THIS POINT TO THE CHANGEOVER POINT FOR THE NEXT NAVAID. (****VOR AIRWAYS & JET ROUTES****) NOTE: THIS FIELD CONTAINS THE DISTANCE IN NAUTICAL MILES OF THE CHANGEOVER POINT BETWEEN THIS NAVAID FACILITY(AWY2 RECORD) AND THE NEXT NAVAID FACILITY(AWY3 RECORD) WHEN THE CHANGE- OVER POINT IS MORE THAN ONE MILE FROM HALF-WAY POINT. FORMAT: NNN EX: 030, 025 R N 0005 00093 AR13 MINIMUM CROSSING ALTITUDE FORMAT: NNNNN EX: 11600 L AN 0007 00098 AR13 DIRECTION OF CROSSING FORMAT: AAAAAAA EX: SE BND R N 0005 00105 AR13 MINIMUM CROSSING ALTITUDE - OPPOSITE DIRECTION FORMAT: NNNNN EX: 12000 L AN 0007 00110 AR13 DIRECTION OF CROSSING - OPPOSITE DIRECTION FORMAT: AAAAAAA EX: E BND L AN 0001 00117 AR15 GAP IN SIGNAL COVERAGE INDICATOR TEXT NOTE ASSOCIATED WITH MEA WHEN CODED 'Y', TEXT OUTPUT FOR PART95 'MEA IS ESTABLISHED WITH A GAP IN NAVIGATION SIGNAL COVERAGE'. L AN 0001 00118 AR16 U.S. AIRSPACE ONLY INDICATOR AIRWAYS CROSSING U.S. BORDERS MUST GO TO FIRST NAVAID IN NEIGHBORING COUNTRY. 'Y' ENTERED INDICATES THAT THE ALTITUDE DATA ONLY AFFECTS U.S. AIRSPACE PORTION OF THAT SEGMENT. TEXT NOTE ASSOCIATED WITH MEA WHEN CODED 'Y', TEXT OUTPUT FOR PART95 'FOR THAT AIRSPACE OVER U.S. TERRITORY'. R A 0005 00119 N45 NAVAID MAGNETIC VARIATION EX: 08E - LEADING BLANKS L AN 0003 00124 N94 NAVAID/FIX ARTCC - - - EX: ZTL L AN 0033 00127 NONE RESERVED(TO POINT-PART95) L AN 0040 00160 NONE RESERVED(NEXT MEA POINT-PART95) R N 0005 00200 AR7 POINT TO POINT GPS MINIMUM ENROUTE ALTITUDE(GPS MEA) FORMAT: NNNNN EX: 05000, 04000 L AN 0006 00205 AR7 POINT TO POINT GPS MINIMUM ENROUTE DIRECTION(GPS MEA) FORMAT: AAAAAAA EX : E BND, SE BND R AN 0005 00211 AR7 POINT TO POINT GPS MINIMUM ENROUTE ALTITUDE(GPS MEA- OPPOSITE DIRECTION) FORMAT: NNNNN OR BLANKS EX : 12000 L AN 0006 00216 AR7 POINT TO POINT GPS MINIMUM ENROUTE DIRECTION(GPS MEA- OPPOSITE DIRECTION) FORMAT: AAAAA EX: W BND, SW BND R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************** 'AWY2' RECORD TYPE - AIRWAY POINT DESCRIPTION ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. AWY2: AIRWAY POINT DESCRIPTION L AN 0005 00005 DLID AIRWAY DESIGNATION. L AN 0001 00010 DLID AIRWAY TYPE. R N 0005 00011 AR4 AIRWAY POINT SEQUENCE NUMBER. L AN 0030 00016 N/A NAVAID FACILITY/FIX NAME L AN 0019 00046 FX36 NAVAID FACILITY/FIX TYPE L AN 0015 00065 FX20 FIX TYPE - PUBLICATION CATEGORY **ENTERED FOR NAMED FIXES ONLY ('FIX' ENTERED)** L AN 0002 00080 N/A NAVAID FACILITY/FIX STATE P. O. CODE L AN 0014 00082 N/A NAVAID FACILITY/FIX LATITUDE L AN 0014 00096 N/A NAVAID FACILITY/FIX LONGITUDE L AN 0005 00110 FX93 FIX MINIMUM RECEPTION ALTITUDE(MRA) FORMAT: NNNNN OR BLANKS EX: 13000 L AN 0004 00115 NONE NAVAID IDENTIFIER EX: STS, HVR L AN 0040 00119 NONE RESERVED(FROM POINT-PART95) L AN 0063 00159 N/A BLANKS R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************** 'AWY3' RECORD TYPE - CHANGEOVER TO POINT DESCRIPTION - (NAVAIDS) (VOR AIRWAYS AND JET ROUTES) (ATO-253 NOTE: AR12) ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. AWY3: CHANGEOVER TO POINT NAVAID L AN 0005 00005 DLID AIRWAY DESIGNATION. L AN 0001 00010 DLID AIRWAY TYPE. R N 0005 00011 AR4 AIRWAY POINT SEQUENCE NUMBER L AN 0030 00016 N/A NAVAID FACILITY NAME L AN 0019 00046 N/A NAVAID FACILITY TYPE L AN 0002 00065 N2 NAVAID FACILITY STATE P. O. CODE L AN 0014 00067 N4 NAVAID FACILITY LATITUDE L AN 0014 00081 N5 NAVAID FACILITY LONGITUDE L AN 0127 00095 N/A BLANKS R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************** 'AWY4' RECORD TYPE - AIRWAY POINT REMARKS TEXT ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. AWY4: AIRWAY REMARKS TEXT L AN 0005 00005 DLID AIRWAY DESIGNATION. L AN 0001 00010 DLID AIRWAY TYPE. R N 0005 00011 AR4 AIRWAY POINT SEQUENCE NUMBER L AN 0202 00016 N/A REMARKS TEXT L AN 0004 00218 N/A BLANKS R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************* 'AWY5' RECORD TYPE - CHANGEOVER POINT EXCEPTION TEXT ******************************************************************* L AN 04 00001 N/A RECORD TYPE INDICATOR. AWY5: CHANGEOVER POINT EXCEPTION TEXT L AN 0005 00005 DLID AIRWAY DESIGNATION. L AN 0001 00010 DLID AIRWAY TYPE. R N 0005 00011 AR4 AIRWAY POINT SEQUENCE NUMBER L N 0202 00016 N/A REMARKS TEXT L AN 0004 00218 N/A BLANKS R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER ******************************************************************* 'RMK ' RECORD TYPE - AIRWAY REMARK TEXT ******************************************************************* L AN 0004 00001 N/A RECORD TYPE INDICATOR. RMK : AIRWAY REMARK TEXT L AN 0005 00005 DLID AIRWAY DESIGNATION. L AN 0001 00010 DLID AIRWAY TYPE. R N 0003 00011 N/A REMARK SEQUENCE NUMBER L AN 0006 00014 N/A REMARK REFERENCE BLANK - GENERAL REMARK DESIG - REMARK REFERENCES AIRWAY DESIGNATION TYPE - REMARK REFERENCES AIRWAY TYPE RNAV - REMARK REFERENCES RNAV INDICATOR L AN 0202 00020 N/A REMARKS TEXT R N 0007 00222 N/A RECORD SORT SEQUENCE NUMBER