| Natural ID | varchar(30) | Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation) | History | Foreign | Aircraft | Natural ID |
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) | History | Primary/Foreign | Aircraft | Aircraft ID |
| C/N | varchar(16) | Construction/Line Number | History | | | |
| MSN | varchar(16) | Manufacturer Serial Number | History | | | |
| Hexcode | char(6) | ICAO 24-bit address/Mode-S hexcode | | | | |
| Production Line | varchar(255) | Production Line designation (i.e. A320) | History | | | |
| Aircraft Family | varchar(255) | Aircraft Family designation (i.e. A320N) | History | | | |
| Aircraft | varchar(16) | Aircraft designation (i.e. A321) | History | | | |
| Aircraft Type | varchar(16) | Aircraft Type designation (i.e. A321-200) | History | | | |
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | History | | | |
| Operator | varchar(255) | Operator name (if Operator is "Multiple Operators", aircraft's multiple operators for a given period can be found in Aircraft Histories Multiple Operators table by matching on Aircraft ID and Date From Full) | History | | | |
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters (if Operator ch-a Code is MLT, aircraft's multiple operators for a given period can be found in Aircraft Histories Multiple Operators table by matching on Aircraft ID and Date From Full) | History | Foreign | Airlines | Airline ch-a Code |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | History | | | |
| Date From | Varchar(10) | From date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Date To | varchar(10) | To date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Date In | varchar(10) | Date the aircraft was delivered to the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Date Out | varchar(10) | Date the aircraft left the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Roll-Out | varchar(10) | Date the aircraft was rolled out (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Registration Date | varchar(10) | Date the aircraft was first registered (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| First Flight | varchar(10) | Date the aircraft has first flown (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Delivery Date | varchar(10) | Actual Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| First Sighting | varchar(10) | Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| End of Life | varchar(10) | Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) | History | | | |
| Engine Manufacturer | varchar(255) | Engine manufacturer name | History | | | |
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | History | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | History | | | |
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | History | | | |
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | History | | | |
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | History | | | |
| Number of Engines | int(11) | Number of engines installed on the aircraft | History | | | |
| Date From Full | date | From date with current operator, registration and variant, in full date format (YYYY-MM-DD) | History | Primary | | |
