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 Finder
By Mode
By Subject
Data Profile: Aviation Support Tables
Data Tables
Aviation Support Tables
   Overview
The Aviation Support Tables provide comprehensive information about U.S. and foreign air carriers, carrier entities, worldwide airport locations, and other geographic data. These data also include information on various aircraft types, their manufacturer and model names. This information is developed and maintained by the Office of Airline Information, Bureau of Transportation Statistics, and is updated on an on-going basis.
   Coverage
Data include U.S. Carriers and foreign carriers with at least one point of service in the United States or one of its territories.
   Availability
 
 
First Year
Last Year
FrequencyOn-going
 
   Data Tables
View tables in this database ...
AircraftTypes
This table identifies the different types of aircraft being reported to the DOT, by DOT assigned aircraft type codes. The information includes the DOT assigned aircraft code, the aircraft manufacturer, and the aircraft model names.
Carrier Decode
This table contains historical (time-based) information on air carriers used throughout the aviation databases. It provides a list of domestic and foreign air carrier codes, by T-100 and OAG designations, charter carrier codes, carrier descriptions, entity codes, service region, and beginning and ending dates of service.
Master Coordinate
This 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.
World Area Codes
This table contains historical (time-based) information on world area codes used throughout the aviation databases. It provides a list of domestic and international world area codes and their associated world area code name, country information, and state information (if applicable).
   Summary Tables
 
   National Transportation Statistics
 
Air Carrier Profile
General Aviation Profile
 
   Related Links
 
Air Carrier Financial Reports
Large Air Carrier Statistics
 
   Terms and Definitions
Airline IDAn identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. Use this field for analysis across a range of years.
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.
Carrier CodeCode assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique.
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.
Unique CarrierUnique Carrier Code. It is the Carrier Code most recently used by a carrier. A numeric suffix is used to distinguish duplicate codes, for example, PA, PA (1), PA (2). Use this field to perform analysis of data reported by one and only one carrier.
Unique Carrier EntityUnique Carrier Entity. This field distinguishes entities used by two or more carriers with a numeric suffix, for example, 06038 and 06038 (1).
Unique Carrier NameUnique Carrier Name. It is the name most recently used by a carrier. If two or more carriers have the same most recent name, a numeric suffix is used to distinguish them, for example, Air Caribbean, Air Caribbean (1).
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.
 
   Data Source and Contacts
 
Data Provider AgencyOST_R/BTS
Data Provider OfficeOffice of Airline Information
BTS ContactTranStats Customer Support
Phone:(800) 853-1351
Email: answers@dot.gov