5
.
A
i
r
l
i
n
e
t
a
b
l
e
s
t
r
u
c
t
u
r
e
a
n
d
r
e
l
a
t
i
o
n
s
h
i
p
s

A review of the airline table was done based on the “Airline Coding Directory” published by IATA (2002). Some links were corrected, added or deleted. The content of the table is shown in Table 23.
Table 23: Table IATA_ICAO_AIRLINES.

Col #  Column Name  Data Type  Data Description 
1  IATA_AIRLINE_CODE  VARCHAR2(5)  Code of the airline as given by IATA 
2  ICAO_AIRLINE_CODE  VARCHAR2(5)  Code of the airline as given by ICAO 
3  AIRLINE_NAME  VARCHAR2(100)  Name of the airline 
4  COUNTRY_NAME  VARCHAR2(50)  Origin of the airline 
5  AIRLINE_CALLSIGN  VARCHAR2(30)  Abbreviation for airline name 

6
.
A
i
r
c
r
a
f
t
t
y
p
e
s
t
a
b
l
e
a
n
d
r
e
l
a
t
i
o
n
s
h
i
p
s

The use of schedule data without any information on the trajectory led to the use of an existing trajectory or the creation of a trajectory. Both cases, which are described further in Phase 2 Paragraphs 9.2 and 9.3, required the production of fleet tables. The use of an existing trajectory required being able to identify the aircraft type in the scheduled flights database and to match it with the aircraft type present in the existing data. For example, the same aircraft is mentioned as “727” in Back Aviation and as “B727” in AMOC. This led to the production of a table matching aircraft codes. The creation of a trajectory for each aircraft type taking into account every aircraft specification was out of the purpose of the project. Then in order to take into account the variety of aircrafts available in the world, a grouping system of aircrafts was established. A table was produced listing aircraft types extracted from ETMS, AMOC and Back Aviation data existing in the weekly sample. To this list was added aircrafts from BADA (Nuic, 2000) and JP airline-fleet database published by BUCHair UK Ltd (2002). In this table (Table 24), aircraft types were assigned an equivalent BADA aircraft if known or filled with:
.
The mention HELI for a helicopter.

.
The mention AMPH for an amphibian.

.
The mention SEA for a seaplane.

.
The mention MIL for a military aircraft.

.
The weight class type if no equivalent aircraft type could be guessed.

.
NONE if no information was known.

The grouping system used is listed in Table 72 in the Appendix. The weight type class was extracted from FAA and the code (i.e. L1P/Lt) was made of the aircraft type associated to the number of engines, type of engines and the weight class as explained in Table 25.
Table 24: Table AIRCRAFT_EQUIVALENT.

Col #  Column Name  Data Type  Data Description 
1  TYPE  VARCHAR2(4)  Aircraft type 
2  NAME  VARCHAR2(48)  Name of the aircraft 
3  EQUIV_TYPE  VARCHAR2(6)  Equivalent aircraft type allocated 

Table 25: Explanation of codes.
Code  Type 
L  Land based aircraft 
1 to 8  Number of engines 
P  Piston 
T  Turboprop 
J  Jet 
Lt  Light – ICAO designated aircraft of 15,500lbs or less, for 
　
中國航空網 m.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(23)