AIRWAY DATA BASE RECORD LAYOUT (AWY-FILE) INFORMATION EFFECTIVE DATE: 6/17/2021 RECORD FORMAT: FIXED LOGICAL RECORD LENGTH: 314 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, 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 AN 0006 00057 NONE SEGMENT MAGNETIC COURSE FORMAT: NNN.NN OR BLANKS R AN 0006 00063 NONE SEGMENT MAGNETIC COURSE - OPPOSITE DIRECTION FORMAT: NNN.NN OR BLANKS R AN 0006 00069 NONE DISTANCE TO NEXT POINT IN SEGMENT IN NAUTICAL MILES. FORMAT: NNN.NN OR BLANKS R N 0005 00075 AR7 POINT TO POINT MINIMUM ENROUTE ALTITUDE(MEA) FORMAT: NNNNN EX: 05000, 04000 L AN 0006 00080 AR7 POINT TO POINT MINIMUM ENROUTE DIRECTION(MEA) FORMAT: AAAAAAA EX : E BND, SE BND R AN 0005 00086 AR7 POINT TO POINT MINIMUM ENROUTE ALTITUDE(MEA- OPPOSITE DIRECTION) FORMAT: NNNNN OR BLANKS EX : 12000 L AN 0006 00091 AR7 POINT TO POINT MINIMUM ENROUTE DIRECTION(MEA- OPPOSITE DIRECTION) FORMAT: AAAAA EX: W BND, SW BND R AN 0005 00097 AR8 POINT TO POINT MAXIMUM AUTHORIZED ALTITUDE EX: 45000 OR BLANKS L AN 0005 00102 AR9 POINT TO POINT MINIMUM OBSTRUCTION CLEARANCE ALTITUDE(MOCA) EX: 07500 OR BLANKS L AN 0001 00107 AR11 AIRWAY GAP FLAG INDICATOR 'X' ENTERED WHEN AIRWAY DISCONTINUED R N 0003 00108 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 00111 AR13 MINIMUM CROSSING ALTITUDE FORMAT: NNNNN EX: 11600 L AN 0007 00116 AR13 DIRECTION OF CROSSING FORMAT: AAAAAAA EX: SE BND R N 0005 00123 AR13 MINIMUM CROSSING ALTITUDE - OPPOSITE DIRECTION FORMAT: NNNNN EX: 12000 L AN 0007 00128 AR13 DIRECTION OF CROSSING - OPPOSITE DIRECTION FORMAT: AAAAAAA EX: E BND L AN 0001 00135 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 00136 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 00137 N45 NAVAID MAGNETIC VARIATION EX: 08E - LEADING BLANKS L AN 0003 00142 N94 NAVAID/FIX ARTCC - - - EX: ZTL L AN 0033 00145 NONE RESERVED(TO POINT-PART95) L AN 0040 00178 NONE RESERVED(NEXT MEA POINT-PART95) R N 0005 00218 NONE POINT TO POINT GNSS MINIMUM ENROUTE ALTITUDE (GLOBAL NAVIGATION SATELLITE SYSTEM MEA) FORMAT: NNNNN EX: 05000, 04000 L AN 0006 00223 NONE POINT TO POINT GNSS MINIMUM ENROUTE DIRECTION (GLOBAL NAVIGATION SATELLITE SYSTEM MEA) FORMAT: AAAAAA EX : E BND, SE BND R AN 0005 00229 NONE POINT TO POINT GNSS MINIMUM ENROUTE ALTITUDE (GLOBAL NAVIGATION SATELLITE SYSTEM MEA- OPPOSITE DIRECTION) FORMAT: NNNNN OR BLANKS EX : 12000 L AN 0006 00234 NONE POINT TO POINT GNSS MINIMUM ENROUTE DIRECTION (GLOBAL NAVIGATION SATELLITE SYSTEM MEA- OPPOSITE DIRECTION) FORMAT: AAAAAA EX: W BND, SW BND L AN 0040 00240 NONE MINIMUM CROSSING ALTITUDE (MCA) POINT R N 0005 00280 NONE POINT TO POINT DME/DME/IRU MINIMUM ENROUTE ALTITUDE (MEA) FORMAT: NNNNN EX: 05000, 04000 L AN 0006 00285 NONE POINT TO POINT DME/DME/IRU MINIMUM ENROUTE DIRECTION (MEA) FORMAT: AAAAAA EX : E BND, SE BND R AN 0005 00291 NONE POINT TO POINT DME/DME/IRU MINIMUM ENROUTE ALTITUDE (MEA- OPPOSITE DIRECTION) FORMAT: NNNNN OR BLANKS EX : 12000 L AN 0006 00296 NONE POINT TO POINT DME/DME/IRU MINIMUM ENROUTE DIRECTION (MEA- OPPOSITE DIRECTION) FORMAT: AAAAAA EX: W BND, SW BND L AN 0001 00302 NONE DOGLEG(Y/N) (A TURN POINT NOT AT A NAVAID - NOTE: GPS RNAV ROUTES [Q, T, TK] WILL HAVE DOGLEG=Y AT FIRST POINT, END POINT, AND ALL TURN POINTS INBETWEEN) R N 0005 00303 NONE RNP FORMAT XX.XX R N 0007 00308 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 0002 00082 N/A ICAO REGION CODE - FOR FIX L AN 0014 00084 N/A NAVAID FACILITY/FIX LATITUDE L AN 0014 00098 N/A NAVAID FACILITY/FIX LONGITUDE L AN 0005 00112 FX93 FIX MINIMUM RECEPTION ALTITUDE(MRA) FORMAT: NNNNN OR BLANKS EX: 13000 L AN 0004 00117 NONE NAVAID IDENTIFIER EX: STS, HVR L AN 0040 00121 NONE RESERVED(FROM POINT-PART95) L AN 0147 00161 N/A BLANKS R N 0007 00308 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 0213 00095 N/A BLANKS R N 0007 00308 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 0090 00218 N/A BLANKS R N 0007 00308 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 0090 00218 N/A BLANKS R N 0007 00308 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 0220 00020 N/A REMARKS TEXT L AN 0068 00240 N/A BLANKS R N 0007 00308 N/A RECORD SORT SEQUENCE NUMBER