For each ASCII attribute file a corresponding dBase format attribute file is supplied. Due to the requirement for the file name extension 'dbf', the Attribute file number is included in the file name prefix (AIRPORT.T02 contains the same attributes as AIRPORT2.DBF).
In all attribute files, a number of the attributes contain 'blank' in addition to the values enumerated in the domain.
In attribute file two (AIRPORT.T02), the National Emergency Status field (NAT_EMER_STAT) contains values not enumerated in the domain. It is a composite field that may contain multiple values separated by '/'. The non-enumerated values include: 3, X, N, 8/N, and 'blank'.
Although some records were modified, the data provider supplied no modification date(s), nor any change code in the REVISION field.
In particular, in attribute file AIRPORT.T02 (NFDC), a blank in an attribute field for a particular landing facility could signify either that an entry is not applicable or that the data is missing. Only in some cases will the user of the data be able to determine which case applies. In attribute files AIRPORT.T01 (ACAIS), AIRPORT.T03 (NPIAS), and AIRPORT.T04 (TAF), a blank in an attribute field for a particular landing facility always indicates, unless otherwise noted, that the landing facility is not included in the particular database and that, therefore, there should not be any data on that attribute for that particular landing facility.
When compared with the NTAD STATES database, approximately 120 airports appear to lie off-shore or not within the state boundary based upon the STFIPS Code attribute
Five facilities are identified as requiring additional review to properly locate the facilities. The facilities in question are: POINTID FEATURID STFIPS DESCRIPT 2498 ADW 24 Andrews AFB 3253 DC13 11 Walter Reed Forest Glen 5077 NK29 36 Southampton Village 5170 NY93 36 Charles Poletti 6492 WA65 53 Washington National Guard - Sinclai
For example, the Charles Poletti facility is coded as existing in New York state. The coordinates place it in Pennsylvania.
The airport points should carry the same longitude and latitude values as the airway segment endpoints (carrying the LOCID as FEATURID to match the points and nodes). In most cases they do. The longitude and latitude value for Denver International Airport (DEN) does not match the value for the associated node. Airport longitude, latitude point = -104.667002, 39.858408 Airway node longitude, latitude = -104.879755, 39.774292
Field Field Field Field Beg End Field Number Name Type Width Pos Pos Description 1 RECTYPE C 1 1 1 Record Type: Always 'P' 2 VERSION C 2 2 3 File Version Number 3 REVISION C 2 4 5 Record revision number 4 MODDATE I 8 6 13 Modification date for the point entity 5 POINTID I 10 14 23 Sequential Unique Point Identification 6 FEATURID C 10 24 33 Unique Identifier for the airport - LOCID 7 LONGITUD I 10 34 43 Longitude (6 implied decimal places) 8 LATITUDE I 10 44 53 Latitude (6 implied decimal places) 9 DESCRIPT C 35 54 88 Name or identification of the airport 10 STFIPS C 2 89 90 State FIPS Code
Field Field Field Beg End Field Field Number Name Width Pos Pos Type Description 1 RECTYPE 1 1 1 C Record Type: Always 'T' 2 VERSION 2 2 3 C File Version Number 3 REVISION 2 4 5 C Record revision number 4 MODDATE 8 6 13 I Modification date for the Attribute 5 FEATURID 10 14 23 C Unique Identifier for the airport - LOCID 6 POINTID 10 24 33 I Sequential Unique Point Identification 7 ACAIS_AP 1 34 34 C ACAIS Airport 8 LCAC_ENP 8 35 42 I Large Certified Air Carrier Enplanements 9 COMM_ENP 8 43 50 I Commuter Enplanements 10 AT_ENP 8 51 58 I Air Taxi Enplanements 11 FFAC_ENP 8 59 66 I Foreign Flag Air Carrier Enplanements 12 IT_ENP 8 67 74 I In-transit Enplanements 13 TOT_ENP 8 75 82 I Total Enplanements 14 ENP_SAN 1 83 83 C Sanitized Enplanement Data 15 HUB_TYPE 1 84 84 C Hub Airport Type 16 SVC_LVL 2 85 86 C Facility Service Level
Entity_Attribute_Information:
Field Field Field Field Beg End Field Number Name Type Width Pos Pos Description 1 RECTYPE C 1 1 1 Record Type: Always 'T' 2 VERSION C 2 2 3 File Version Number 3 REVISION C 2 4 5 Record Revision Number 4 MODDATE I 8 6 13 Record Modification Date 5 FEATURID C 10 14 23 Unique Identifier for the airport - LOCID 6 POINTID I 10 24 33 Sequential Unique Point Identification 7 SITE_NUM C 11 34 44 Site Number 8 FAC_TYPE C 1 45 45 Facility Type 9 FAC_NAME C 42 46 87 Facility Name 10 CITY C 26 88 113 City location of the facility 11 COUNTY C 21 114 134 County location of the facility 12 STATE C 2 135 136 State Postal Code abbreviation for the facility 13 STFIPS C 2 137 138 State FIPS Code for the facility 14 CTY_FIPS C 3 139 141 County FIPS Code for the facility 15 FAA_REG C 3 142 144 FAA Region 16 FAC_USE C 2 145 146 Facility Use, public or private 17 OWN_TYPE C 2 147 148 Type of owner 18 OWN_NAME C 30 149 178 Name of owner 19 ELEVATION I 6 179 184 Elevation in feet 20 CBD_DIST I 3 185 187 Distance from the central business district 21 CERT_TYPE C 3 188 190 Type of certification 22 CERT_DATE C 5 191 195 Date of facility certification 23 CUST_INTL C 1 196 196 Customs International Airport 24 C_LDG_RTS C 1 197 197 Customs Landing Rights Airport 25 JOINT_USE C 1 198 198 Joint Use 26 MIL_RTS C 1 199 199 Military Landing Rights 27 NAT_EMER C 18 200 217 National Emergency Status 28 MIL_EMER C 6 218 223 Military Emergency Interest 29 B_MIL_AC I 2 224 225 Number of operational military aircraft based at the facility 30 RUN_NUM I 2 226 227 Number of runways at the facility 31 PAD_NUM I 2 228 229 Number of helicopter pads at the facility
Field Field Field Field Beg End Field Number Name Type Width Pos Pos Description 1 RECTYPE C 1 1 1 Record Type: Always 'T' 2 VERSION C 2 2 3 File Version Number 3 REVISION C 2 4 5 Record Revision Number 4 MODDATE I 8 6 13 Attribute modification date 5 FEATURID C 10 14 23 Unique Identifier for the airport - LOCID 6 POINTID I 10 24 33 Sequential Unique Point Identification 7 NPIAS_AP C 1 34 34 NPIAS airport 8 VFRHRCAP I 4 35 38 Visual Flight Rule hourly capacity 9 IFRHRCAP I 4 39 42 Instrument Flight Rule hourly capacity 10 CONG_LVL C 1 43 43 Congestion Level 11 LNG_FLT C 1 44 44 Long Flight Category 12 AC_TYPE C 2 45 46 Aircraft Type 13 FED_LDG C 4 47 50 Federal Landing Interest
Entity_Attribute_Information:
Field Field Field Field Beg End Field Number Name Type Width Pos Pos Description 1 RECTYPE C 1 1 1 Record Type: Always 'T' 2 VERSION C 2 2 3 File Version Number 3 REVISION C 2 4 5 Record Revision Number 4 MODDATE I 8 6 13 Record modification date 5 FEATURID C 10 14 23 Unique Identifier for the airport - LOCID 6 POINTID I 10 24 33 Sequential Unique Point Identification 7 TAF_AP C 1 34 34 Terminal Area Forecast (TAF) Airport 8 AT_TYPE C 1 35 35 Air Tower Type 9 AC_IO I 8 36 43 Air Carrier Itinerant Operations 10 AT_IO I 8 44 51 Air Taxi Itinerant Operations 11 GA_IO I 8 52 59 General Aviation Itinerant Operations 12 MIL_IO I 8 60 67 Military Itinerant Operations 13 TOT_IO I 8 68 75 Total Itinerant Operations 14 GA_LOC_O I 8 76 83 Total local general aviation operations 15 MIL_LOC_O I 8 84 91 Total local military operations 16 TOT_LOC_O I 8 92 99 Total local operations 17 TOT_O I 8 100 107 Total operations