transtats logo
 
Advanced Search
Resources
Data Tools
Aviation Support Tables : Master Coordinate
   Data Tables   Table Contents
Download Instructions  
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
AirportSeqIDAn 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. 
AirportIDAn 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. 
AirportA 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. 
AirportNameAirport Name 
AirportCityNameAirport City Name with either U.S. State or Country 
AirportWacSeqID2Unique 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. 
AirportWacWorld Area Code for the Physical Location of the AirportGet Lookup Table
AirportCountryNameCountry Name for the Physical Location of the Airport 
AirportCountryCodeISOTwo-character ISO Country Code for the Physical Location of the Airport 
AirportStateNameState Name for the Physical Location of the Airport  
AirportStateCodeState Abbreviation for the Physical Location of the Airport 
AirportStateFipsFIPS (Federal Information Processing Standard) State Code for the Physical Location of the Airport 
CityMarketSeqIDAn 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
CityMarketIDAn 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
CityMarketNameCity Market Name with either U.S. State or Country 
CityMarketWacSeqID2Unique Identifier for a World Area Code (WAC) at a given point of time for the City Market. See World Area Codes support table. 
CityMarketWacWorld Area Code for the City MarketGet Lookup Table
LatDegreesLatitude, Degrees 
LatHemisphereLatitude, Hemisphere 
LatMinutesLatitude, Minutes 
LatSecondsLatitude, Seconds 
LatitudeLatitude 
LonDegreesLongitude, Degrees 
LonHemisphereLongitude, Hemisphere 
LonMinutesLongitude, Minutes 
LonSecondsLongitude, Seconds 
LongitudeLongitude 
UTCLocalTimeVariationTime Zone at the Airport 
AirportStartDateStart Date of Airport Attributes 
AirportEndDateEnd Date of Airport Attributes (Active = NULL) 
AirportIsClosedIndicates if the airport is closed (1 = Yes). If yes, the airport is closed is on the AirportEndDate.Get Lookup Table
AirportIsLatestIndicates if this row contains the latest attributes for the Airport (1 = Yes)Get Lookup Table