| Column |
Data Type |
Data description |
Package required |
Key |
Data Set |
Join On |
| 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 |
|
|
|
| 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 |
|
|
|
| Airline |
varchar(255) |
Operator name |
History |
|
|
|
| Airline ch-a Code |
varchar(4) |
Operator ch-aviation code (assigned by ch-aviation) |
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 |
Primary |
|
|
| 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 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 |
|
|
|
