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

United States Department of Transportation

General

Search this site:

Advanced Search

Resources

Database Directory

Upcoming Releases

Data Release History

Data Tools

Aviation Support Tables : Carrier Decode
Data Tables Table Contents
Download Instructions		Filter Geography	Filter Year	Filter Period

Select all fields % Missing in table Documentation Terms

Field Name	Description	% Missing	Support Table
AirlineID	An 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.	<0.005
Carrier	Code 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.	<0.005
CarrierEntity	Carrier Entity	<0.005
CarrierName	Carrier Name	<0.005
UniqueCarrier	Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years.	<0.005
UniqCarrierEntity	Unique Entity for a Carrier's Operation Region.	<0.005
UniqueCarrierName	Unique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1).	<0.005
WAC	World Area Code	<0.005	Get Lookup Table
CarrierGroup	Carrier Group Code. Used in Legacy Analysis	<0.005	Get Lookup Table
CarrierGroupNew	Carrier Group New	<0.005	Get Lookup Table
Region	Carrier's Operation Region. Carriers Report Data by Operation Region	<0.005
StartDate	Starting Date of Carrier Code	<0.005
EndDate	Ending Date of Carrier Code (Active = NULL)	19.47