Field Name Description Support Table
AirportSeqID An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time.
AirportID An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused.
Airport A three character alpha-numeric code issued by the U.S. Department of Transportation which is the official designation of the airport. The airport code is not always unique to a specific airport because airport codes can change or can be reused.
AirportName Airport Name
AirportCityName Airport City Name with either U.S. State or Country
AirportWacSeqID2 Unique Identifier for a World Area Code (WAC) at a given point of time for the Physical Location of the Airport. See World Area Codes support table.
AirportWac World Area Code for the Physical Location of the Airport Get Lookup Table
AirportCountryName Country Name for the Physical Location of the Airport
AirportCountryCodeISO Two-character ISO Country Code for the Physical Location of the Airport
AirportStateName State Name for the Physical Location of the Airport
AirportStateCode State Abbreviation for the Physical Location of the Airport
AirportStateFips FIPS (Federal Information Processing Standard) State Code for the Physical Location of the Airport
CityMarketSeqID An identification number assigned by US DOT to identify a city market at a given point of time. City Market attributes may change over time. For example the country associated with the city market can change over time due to geopolitical changes. Get Lookup Table
CityMarketID An identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. Get Lookup Table
CityMarketName City Market Name with either U.S. State or Country
CityMarketWacSeqID2 Unique Identifier for a World Area Code (WAC) at a given point of time for the City Market. See World Area Codes support table.
CityMarketWac World Area Code for the City Market Get Lookup Table
LatDegrees Latitude, Degrees
LatHemisphere Latitude, Hemisphere
LatMinutes Latitude, Minutes
LatSeconds Latitude, Seconds
Latitude Latitude
LonDegrees Longitude, Degrees
LonHemisphere Longitude, Hemisphere
LonMinutes Longitude, Minutes
LonSeconds Longitude, Seconds
Longitude Longitude
UTCLocalTimeVariation Time Zone at the Airport
AirportStartDate Start Date of Airport Attributes
AirportEndDate End Date of Airport Attributes (Active = NULL)
AirportIsClosed Indicates if the airport is closed (1 = Yes). If yes, the airport is closed is on the AirportEndDate. Get Lookup Table
AirportIsLatest Indicates if this row contains the latest attributes for the Airport (1 = Yes) Get Lookup Table
