transtats logo
 
Advanced Search
Resources
Data Finder
By Mode
By Subject
Database Name: Aviation Support Tables
   Database Profile
All Rows Shown
Table NameDescription
AircraftTypesThis 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.
Table Profile Download
Carrier DecodeThis 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.
Table Profile Download
Master CoordinateThis 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.
Table Profile Download
World Area CodesThis 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).
Table Profile Download
All Rows Shown