| 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 | | | |
