Find the latest Coronavirus-related transportation statistics on the BTS Covid-19 landing page

General

BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Tools
: Master Coordinate
   Database Profile   Data Tables   Table Contents
Property Description
NameMaster Coordinate
DescriptionThis table contains historical (time-based) information on airports used throughout the aviation databases. It provides a list of domestic and foreign airport codes and their associated world area code, country information, state information (if applicable), city name, airport name, city market information, and latitude and longitude information.
Records18,160
Fields32
First Year
Last Year
FrequencyN/A
Latest Available DataN/A
  
TermsDefinitions
Airport CodeA 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.
Airport IDAn 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.
City Market IDAn identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market.
World Area Code (WAC)Numeric codes used to identify geopolitical areas such as countries, states (U.S.), provinces (Canada), and territories or possessions of certain countries. The codes are used within the various data banks maintained by the Office of Airline Information (OAI) and are created by OAI.