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.
Source: http://www.transtats.bts.gov/Tables.asp?DB_ID=595
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.
Source: http://www.transtats.bts.gov/Fields.asp?Table_ID=300
ac_typeid - Aircraft type identification number. This number is related to the aircraft group number and falls within the range of a group number.
ac_group - Aircraft type group. This number gives the group or classification of aircraft engine and type of aircraft.
ssd_name - Aircraft name.
manufacturer - Manufacturing company name.
long_name - Complete name of the aircraft.
short_name - Abbreviated name of the aircraft.
begin_date - The date when the aircraft was added to the database.
end_date - The date through which aircraft type remains in effect.
"691",6,"A300-600/R/CF/RCF","AIRBUS INDUSTRIE","AIRBUS INDUSTRIE A300-600/R/CF/RCF","A300-6",1990-01-01,This table 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.
Source: http://www.transtats.bts.gov/Fields.asp?Table_ID=304
airline_id - 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.
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.
carrier_entity
carrier_name
unique_carrier - 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.
unique_carrier_entity - Unique entity for a carrier’s operation region.
unique_carrier_name - 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).
wac - World Area Code.
carrier_group - Carrier group code. Used in legacy analysis.
carrier_group_new - Carrier group new.
region - Carrier’s operation region. Carriers report data by operation region.
start_date_source - Starting date of carrier code.
thru_date_source - Ending date of carrier code (active = NULL).
This table contains a list of domestic and foreign airport codes and their associated city codes, world area codes, city or airport names, state or country names, and latitude and longitude information.
Source: http://www.transtats.bts.gov/Fields.asp?Table_ID=288
airport - Airport code.
tr_airport_name - Airport name with country/state information.
tr_city_name - City name with country/state information.
tr_state_name - State name.
tr_country_name - Country name.
tr_wac - World Area Code.
begin_date_source - Starting date of airport code.
end_date - Ending date of airport code (active = NULL).
airport_region - Airport region.
lat_degrees - Latitude, degrees.
lat_minutes - Latitude, minutes.
lat_seconds - Latitude, seconds.
lat_hemisphere - Latitude, hemisphere.
latitude - Latitude (decimal).
lon_degrees - Longitude, degrees.
lon_minutes - Longitude, minutes.
lon_seconds - Longitude, seconds.
lon_hemisphere - Longitude, hemisphere.
longitude - Longitude.
airport_id - Unique airport numeric value.
Some entries in the wac column are zero! This is an invalid value according to the DOT World Area Code lookup table.
The region column is very inconsistent (e.g., Wisconsin, Wis, Wis.) and is basically a duplication of the information in the state column.
The coordinates are stored in two formats: minutes-degrees-seconds and decimal degrees.