USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of TransportationU.S. Department of Transportation IconUnited States Department of TransportationUnited States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Tools
: Master Coordinate
   Database Profile   Data Tables   Table Profile
All Rows Shown
Field NameDescription
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 Airport 
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. 
CityMarketIDAn identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. 
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 Market 
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. 
AirportIsLatestIndicates if this row contains the latest attributes for the Airport (1 = Yes) 
All Rows Shown