transtats logo
 
Advanced Search
Resources
Data Tools
Aviation Support Tables : Carrier Decode
   Data Tables   Table Contents
Download Instructions  
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
AirlineIDAn 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. 
CarrierCode 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. 
CarrierEntityCarrier Entity 
CarrierNameCarrier Name 
UniqueCarrierUnique 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. 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region. 
UniqueCarrierNameUnique 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). 
WACWorld Area CodeGet Lookup Table
CarrierGroupCarrier Group Code. Used in Legacy AnalysisGet Lookup Table
CarrierGroupNewCarrier Group NewGet Lookup Table
RegionCarrier's Operation Region. Carriers Report Data by Operation Region 
StartDateStarting Date of Carrier Code 
EndDateEnding Date of Carrier Code (Active = NULL)