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