| ID | int(11) | Unique ch-aviation created aircraft data ID | Fleets | Primary | | |
| Aircraft 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/Foreign | Aircraft Codes | IATA |
| Aircraft ICAO | varchar(32) | Aircraft four character ICAO codes, separated by “/” (since this data is built around IATA codes, there is a one-to-many relationship) | Fleets | | | |
| Manufacturer | varchar(3) | Aircraft Manufacturer ch-aviation code (assigned by ch-aviation) | Fleets | Foreign | Entities | Entity ch-a Code |
| Delivery Location | varchar(255) | Delivery location ch-aviation airport codes, separated by commas | Fleets | Foreign | Airports | Airport ch-a Code |
| Production From | varchar(255) | Production start year | Fleets | | | |
| Production To | varchar(255) | Production end year | Fleets | | | |
| Production Line | varchar(9) | Production Line designation (i.e. A320) | Fleets | | | |
| MTOW (kg) | int(11) | Maximum take-off weight for the highest MTOW variant in kilograms | Fleets | | | |
| MTOW (lb) | int(11) | Maximum take-off weight for the highest MTOW variant in pounds | Fleets | | | |
| Free Text | varchar(255) | Free text remarks | Fleets | | | |
| Fleet Data | tinyint(1) | Indicator if fleet data is available: 1: yes, 0: no | Fleets | | | |
| Fleet Data Incomplete | tinyint(1) | Indicator that fleet data is available but incomplete: 1: incomplete, 0: not applicable | Fleets | | | |
| Avg HR Charter Cost | int(11) | Average hourly charter cost in USD | Fleets | | | |
| Market Group ID | int(11) | Market group ID (assigned by ch-aviation) | Fleets | | | |
| Market Group Name | varchar(255) | Market group (Widebodies, Narrowbodies, Regional Jets, Regional Turboprops, Military Aircraft) | Fleets | | | |
| Engine Number | int(11) | Number of engines | Fleets | | | |
| Maxpax | varchar(255) | Maximum number of passengers | Fleets | | | |
| Speed (km/h) | varchar(255) | Cruising speed in kilometres per hour (km/h) | Fleets | | | |
| Speed (mph) | varchar(255) | Cruising speed in miles per hour (mph) | Fleets | | | |
| Noisecat | char(1) | ICAO Noise Category Stage: 1 / 2 / 3 / 4 / 5 | Fleets | | | |
| First Flight | varchar(255) | First flight date | Fleets | | | |
| Cockpit Crew | varchar(255) | Number of cockpit crew required | Fleets | | | |
