Aircraft Codes

Column Data Type Data description Package required Key Data Set Join On
ID int(11) Unique ch-aviation created aircraft code ID Fleets Primary
IATA char(3) Aircraft three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) Fleets Unique
Aircraft Class char(3) Aircraft class three character IATA code (ch-aviation assigns dummy IATA codes to types for which IATA has not designated a code) Fleets
Description varchar(255) Aircraft description Fleets
Short Description varchar(32) Abbreviated aircraft description Fleets
Equipment Type varchar(255) Equipment type description (Helicopter, Jet-engined aircraft, Piston-engined aircraft, Turboprop-engined aircraft) Fleets
Min Cockpit Crew int(11) Minimum cockpit crew Fleets