| OID |
OID (database unique ID) - numeric datatype A single column containing a database-unique identifier. It is this identifier which is actually used to link all the records in all the tables to the same Occurrence. |
| ID |
ID (Instance ID) This is the instance ID in this table. |
| A21 |
Manufacturer/model |
| A28 |
ICAO information |
| A29 |
Current traffic type |
| A32 |
Aircraft category |
| A35 |
Airworthiness cert. |
| A36 |
Impact angle |
| A37 |
Immersion suits avail |
| A38 |
Immersion suits worn |
| A39 |
Approval icing cond. |
| A40 |
Approval prec appr |
| A42 |
Approach RVR status |
| A43 |
Approach stabilized |
| A44 |
Person at controls |
| A47 |
ATS route type |
| A48 |
Recording quality |
| A49 |
Auto bank call |
| A50 |
Auto altitude call |
| A51 |
Automatic landing |
| A52 |
Availability ARFS |
| A55 |
Chute/slide ops |
| A56 |
Chute/slide inst |
| A57 |
Clearance validity |
| A64 |
Controlling agency |
| A71 |
Co-pilot altim type |
| A72 |
Co-pilot restraint system |
| A73 |
Charts available |
| A74 |
Altitude contours |
| A76 |
Terrain contours |
| A77 |
Crew call-out done |
| A79 |
Current flight rules |
| A80 |
CVR recovery |
| A81 |
Data recovery |
| A82 |
Data usefulness |
| A83 |
Descent rate |
| A89 |
ARFS effective |
| A90 |
EFIS |
| A91 |
ELB-A, ELT status |
| A94 |
Resulting state |
| A95 |
Floatation inflation |
| A96 |
Floatation installed |
| A97 |
Functioning |
| A99 |
Ext agent type |
| A116 |
FDR recovery |
| A117 |
Filed flight rules |
| A118 |
Filed traffic type |
| A121 |
Flight phase |
| A122 |
Floatation time |
| A123 |
Weather info phase |
| A124 |
Fuel source |
| A125 |
Recommended type |
| A126 |
Type used |
| A128 |
GNSS installed |
| A130 |
GPWS installed |
| A131 |
GPWS operated |
| A132 |
GPWS required |
| A134 |
GPWS warning given |
| A137 |
HUD installed |
| A138 |
HUD used |
| A141 |
Hot microphone" |
| A142 |
Icing intensity |
| A143 |
Ignition sourcet |
| A144 |
Initial location |
| A163 |
Installation |
| A164 |
Instr. land. proc. |
| A165 |
Instr. appr. operations |
| A166 |
Landing gear type |
| A167 |
Last departure point |
| A169 |
FDR location |
| A170 |
Wreckage location |
| A171 |
CVR location |
| A172 |
Landing location |
| A173 |
Locating method |
| A174 |
Maintenance docs |
| A178 |
Microburst |
| A179 |
Minima call-out made |
| A189 |
Mountain wave intens |
| A213 |
Occ. on ground |
| A214 |
Operation type |
| A215 |
Operator |
| A216 |
Operator type |
| A217 |
Pax restraint system |
| A219 |
Charts available |
| A228 |
Planned destination |
| A281 |
State of registry |
| A649 |
Pilot advised of birds |
| A21_T |
Extension to Aircraft make/model/series, text |
| A167_T |
Extension to Last departure point, text |
| A215_T |
Extension to The name of the operator, text |
| A228_T |
Extension to Planned destination, text |
| A21_1 |
Extension to Aircraft make/model/series, part 1 |
| A21_2 |
Extension to Aircraft make/model/series, part 2 |
| A21_3 |
Extension to Aircraft make/model/series, part 3 |
| A21_4 |
Extension to Aircraft make/model/series, part 4 |
| A28_1 |
Extension to Additional operational information of interest to ICAO |
| A29_1 |
Extension to Current traffic type |
| A32_1 |
Extension to Aircraft category, part 1 |
| A32_2 |
Extension to Aircraft category, part 2 |
| A32_3 |
Extension to Aircraft category, part 3 |
| A32_4 |
Extension to Aircraft category, part 4 |
| A35_1 |
Extension to Airworthiness certificate |
| A36_1 |
Extension to Impact angle |
| A37_1 |
Extension to Helicopter anti-exposure/immersion suits available |
| A38_1 |
Extension to Helicopter anti-exposure/immersion suits worn |
| A39_1 |
Extension to Aircraft approved for icing conditions |
| A40_1 |
Extension to Aircraft approved for precision approach |
| A42_1 |
Extension to Approach runway visual range status |
| A43_1 |
Extension to Approach stabilized |
| A44_1 |
Extension to Person at controls at the first event |
| A47_1 |
Extension to ATS route type |
| A48_1 |
Extension to CVR - recording quality |
| A49_1 |
Extension to Auto bank call provided |
| A50_1 |
Extension to Auto altitude call provided |
| A51_1 |
Extension to Automatic landing |
| A52_1 |
Extension to Aerodrome rescue fire service (ARFS) availability |
| A55_1 |
Extension to Chutes/slides operation |
| A56_1 |
Extension to Chutes/slides installed |
| A57_1 |
Extension to Clearance validity |
| A64_1 |
Extension to Controlling agency |
| A71_1 |
Extension to Co-pilot altimeter type |
| A72_1 |
Extension to Co-pilot restraint system |
| A73_1 |
Extension to Co-pilot charts available |
| A74_1 |
Extension to Co-pilot charts minimum altitude contours |
| A76_1 |
Extension to Co-pilot charts terrain contours |
| A77_1 |
Extension to Crew call-out done |
| A79_1 |
Extension to Current flight rules |
| A80_1 |
Extension to Cockpit voice recorder - recovery |
| A81_1 |
Extension to FDR - data recovery |
| A82_1 |
Extension to FDR - data usefulness |
| A83_1 |
Extension to Descent rate at ground impact |
| A89_1 |
Extension to Aerodrome fire fighting effectiveness |
| A90_1 |
Extension to Electronic Flight Instrument System (EFIS) |
| A91_1 |
Extension to Emergency Location Beacon Aircraft - Emergency Locator Transmitter [ELB-A, ELT] status |
| A94_1 |
Extension to Helicopter emergency floatation equipment effectiveness |
| A95_1 |
Extension to Helicopter emergency floatation system inflation |
| A96_1 |
Extension to Helicopter emergency floatation system installed |
| A97_1 |
Extension to Emergency lighting aircraft functioning |
| A99_1 |
Extension to Aerodrome RFS extinguishing agent type |
| A116_1 |
Extension to Flight data recorder - recovery |
| A117_1 |
Extension to Filed flight rules |
| A118_1 |
Extension to Filed traffic type |
| A121_1 |
Extension to The flight phase in which the occurrence took place |
| A122_1 |
Extension to Floatation time aircraft |
| A123_1 |
Extension to Weather information phase of flight |
| A124_1 |
Extension to Fire fuel source |
| A125_1 |
Extension to Recommended fuel type, part 1 |
| A125_2 |
Extension to Recommended fuel type, part 2 |
| A126_1 |
Extension to Type of fuel used, part 1 |
| A126_2 |
Extension to Type of fuel used, part 2 |
| A128_1 |
Extension to Global Navigation Satellite System installed |
| A130_1 |
Extension to Ground Proximity Warning System installed |
| A131_1 |
Extension to Ground Proximity Warning System operated |
| A132_1 |
Extension to Ground Proximity Warning System required |
| A134_1 |
Extension to Ground Proximity Warning System warning given |
| A137_1 |
Extension to Heads up display installed |
| A138_1 |
Extension to Heads up display used |
| A141_1 |
Extension to CVR - hot microphone installed |
| A142_1 |
Extension to Icing intensity |
| A143_1 |
Extension to Ignition source of the fire |
| A144_1 |
Extension to Initial location of the fire/smoke/fumes |
| A163_1 |
Extension to Emergency lighting installed on the aircraft |
| A164_1 |
Extension to Instrument landing procedure |
| A165_1 |
Extension to Instrument approach operations |
| A166_1 |
Extension to Landing gear type, part 1 |
| A166_2 |
Extension to Landing gear type, part 2 |
| A167_1 |
Extension to Last departure point, part 1 |
| A167_2 |
Extension to Last departure point, part 2 |
| A169_1 |
Extension to Flight data recorder - location |
| A170_1 |
Extension to Wreckage location related to aerodrome |
| A171_1 |
Extension to Cockpit voice recorder - location |
| A172_1 |
Extension to Location of the landing |
| A173_1 |
Extension to Wreckage site locating method |
| A174_1 |
Extension to Maintenance documents status |
| A178_1 |
Extension to Microburst |
| A179_1 |
Extension to Minima call-out made |
| A189_1 |
Extension to Mountain wave intensity |
| A213_1 |
Extension to Occurrence on ground |
| A214_1 |
Extension to Operation type, part 1 |
| A214_2 |
Extension to Operation type, part 2 |
| A214_3 |
Extension to Operation type, part 3 |
| A215_1 |
Extension to The name of the operator, part 1 |
| A215_2 |
Extension to The name of the operator, part 2 |
| A215_3 |
Extension to The name of the operator, part 3 |
| A216_1 |
Extension to Operator type (general aviation) |
| A217_1 |
Extension to Passenger restraint system |
| A219_1 |
Extension to Pilot-in-command charts available |
| A228_1 |
Extension to Planned destination, part 1 |
| A228_2 |
Extension to Planned destination, part 2 |
| A281_1 |
Extension to Aircraft State of registry, part 1 |
| A281_2 |
Extension to Aircraft State of registry, part 2 |
| A649_1 |
Extension to Pilot advised of birds |
| A21_1_Translate |
Translation of the code-value in A21_1 column. |
| A21_2_Translate |
Translation of the code-value in A21_2 column. |
| A21_3_Translate |
Translation of the code-value in A21_3 column. |
| A21_Translate |
Translation of the code-value in A21 column. |
| A21_4_Translate |
Translation of the code-value in A21_4 column. |
| A28_1_Translate |
Translation of the code-value in A28_1 column. |
| A28_Translate |
Translation of the code-value in A28 column. |
| A29_1_Translate |
Translation of the code-value in A29_1 column. |
| A29_Translate |
Translation of the code-value in A29 column. |
| A32_1_Translate |
Translation of the code-value in A32_1 column. |
| A32_2_Translate |
Translation of the code-value in A32_2 column. |
| A32_3_Translate |
Translation of the code-value in A32_3 column. |
| A32_4_Translate |
Translation of the code-value in A32_4 column. |
| A32_Translate |
Translation of the code-value in A32 column. |
| A35_1_Translate |
Translation of the code-value in A35_1 column. |
| A35_Translate |
Translation of the code-value in A35 column. |
| A36_1_Translate |
Translation of the code-value in A36_1 column. |
| A36_Translate |
Translation of the code-value in A36 column. |
| A37_1_Translate |
Translation of the code-value in A37_1 column. |
| A37_Translate |
Translation of the code-value in A37 column. |
| A38_1_Translate |
Translation of the code-value in A38_1 column. |
| A38_Translate |
Translation of the code-value in A38 column. |
| A39_1_Translate |
Translation of the code-value in A39_1 column. |
| A39_Translate |
Translation of the code-value in A39 column. |
| A40_1_Translate |
Translation of the code-value in A40_1 column. |
| A40_Translate |
Translation of the code-value in A40 column. |
| A42_1_Translate |
Translation of the code-value in A42_1 column. |
| A42_Translate |
Translation of the code-value in A42 column. |
| A43_1_Translate |
Translation of the code-value in A43_1 column. |
| A43_Translate |
Translation of the code-value in A43 column. |
| A44_1_Translate |
Translation of the code-value in A44_1 column. |
| A44_Translate |
Translation of the code-value in A44 column. |
| A47_1_Translate |
Translation of the code-value in A47_1 column. |
| A47_Translate |
Translation of the code-value in A47 column. |
| A48_1_Translate |
Translation of the code-value in A48_1 column. |
| A48_Translate |
Translation of the code-value in A48 column. |
| A49_1_Translate |
Translation of the code-value in A49_1 column. |
| A49_Translate |
Translation of the code-value in A49 column. |
| A50_1_Translate |
Translation of the code-value in A50_1 column. |
| A50_Translate |
Translation of the code-value in A50 column. |
| A51_1_Translate |
Translation of the code-value in A51_1 column. |
| A51_Translate |
Translation of the code-value in A51 column. |
| A52_1_Translate |
Translation of the code-value in A52_1 column. |
| A52_Translate |
Translation of the code-value in A52 column. |
| A55_1_Translate |
Translation of the code-value in A55_1 column. |
| A55_Translate |
Translation of the code-value in A55 column. |
| A56_1_Translate |
Translation of the code-value in A56_1 column. |
| A56_Translate |
Translation of the code-value in A56 column. |
| A57_1_Translate |
Translation of the code-value in A57_1 column. |
| A57_Translate |
Translation of the code-value in A57 column. |
| A64_1_Translate |
Translation of the code-value in A64_1 column. |
| A64_Translate |
Translation of the code-value in A64 column. |
| A71_1_Translate |
Translation of the code-value in A71_1 column. |
| A71_Translate |
Translation of the code-value in A71 column. |
| A72_1_Translate |
Translation of the code-value in A72_1 column. |
| A72_Translate |
Translation of the code-value in A72 column. |
| A73_1_Translate |
Translation of the code-value in A73_1 column. |
| A73_Translate |
Translation of the code-value in A73 column. |
| A74_1_Translate |
Translation of the code-value in A74_1 column. |
| A74_Translate |
Translation of the code-value in A74 column. |
| A76_1_Translate |
Translation of the code-value in A76_1 column. |
| A76_Translate |
Translation of the code-value in A76 column. |
| A77_1_Translate |
Translation of the code-value in A77_1 column. |
| A77_Translate |
Translation of the code-value in A77 column. |
| A79_1_Translate |
Translation of the code-value in A79_1 column. |
| A79_Translate |
Translation of the code-value in A79 column. |
| A80_1_Translate |
Translation of the code-value in A80_1 column. |
| A80_Translate |
Translation of the code-value in A80 column. |
| A81_1_Translate |
Translation of the code-value in A81_1 column. |
| A81_Translate |
Translation of the code-value in A81 column. |
| A82_1_Translate |
Translation of the code-value in A82_1 column. |
| A82_Translate |
Translation of the code-value in A82 column. |
| A83_1_Translate |
Translation of the code-value in A83_1 column. |
| A83_Translate |
Translation of the code-value in A83 column. |
| A89_1_Translate |
Translation of the code-value in A89_1 column. |
| A89_Translate |
Translation of the code-value in A89 column. |
| A90_1_Translate |
Translation of the code-value in A90_1 column. |
| A90_Translate |
Translation of the code-value in A90 column. |
| A91_1_Translate |
Translation of the code-value in A91_1 column. |
| A91_Translate |
Translation of the code-value in A91 column. |
| A94_1_Translate |
Translation of the code-value in A94_1 column. |
| A94_Translate |
Translation of the code-value in A94 column. |
| A95_1_Translate |
Translation of the code-value in A95_1 column. |
| A95_Translate |
Translation of the code-value in A95 column. |
| A96_1_Translate |
Translation of the code-value in A96_1 column. |
| A96_Translate |
Translation of the code-value in A96 column. |
| A97_1_Translate |
Translation of the code-value in A97_1 column. |
| A97_Translate |
Translation of the code-value in A97 column. |
| A99_1_Translate |
Translation of the code-value in A99_1 column. |
| A99_Translate |
Translation of the code-value in A99 column. |
| A116_1_Translate |
Translation of the code-value in A116_1 column. |
| A116_Translate |
Translation of the code-value in A116 column. |
| A117_1_Translate |
Translation of the code-value in A117_1 column. |
| A117_Translate |
Translation of the code-value in A117 column. |
| A118_1_Translate |
Translation of the code-value in A118_1 column. |
| A118_Translate |
Translation of the code-value in A118 column. |
| A121_1_Translate |
Translation of the code-value in A121_1 column. |
| A121_Translate |
Translation of the code-value in A121 column. |
| A122_1_Translate |
Translation of the code-value in A122_1 column. |
| A122_Translate |
Translation of the code-value in A122 column. |
| A123_1_Translate |
Translation of the code-value in A123_1 column. |
| A123_Translate |
Translation of the code-value in A123 column. |
| A124_1_Translate |
Translation of the code-value in A124_1 column. |
| A124_Translate |
Translation of the code-value in A124 column. |
| A125_1_Translate |
Translation of the code-value in A125_1 column. |
| A125_2_Translate |
Translation of the code-value in A125_2 column. |
| A125_Translate |
Translation of the code-value in A125 column. |
| A126_1_Translate |
Translation of the code-value in A126_1 column. |
| A126_2_Translate |
Translation of the code-value in A126_2 column. |
| A126_Translate |
Translation of the code-value in A126 column. |
| A128_1_Translate |
Translation of the code-value in A128_1 column. |
| A128_Translate |
Translation of the code-value in A128 column. |
| A130_1_Translate |
Translation of the code-value in A130_1 column. |
| A130_Translate |
Translation of the code-value in A130 column. |
| A131_1_Translate |
Translation of the code-value in A131_1 column. |
| A131_Translate |
Translation of the code-value in A131 column. |
| A132_1_Translate |
Translation of the code-value in A132_1 column. |
| A132_Translate |
Translation of the code-value in A132 column. |
| A134_1_Translate |
Translation of the code-value in A134_1 column. |
| A134_Translate |
Translation of the code-value in A134 column. |
| A137_1_Translate |
Translation of the code-value in A137_1 column. |
| A137_Translate |
Translation of the code-value in A137 column. |
| A138_1_Translate |
Translation of the code-value in A138_1 column. |
| A138_Translate |
Translation of the code-value in A138 column. |
| A141_1_Translate |
Translation of the code-value in A141_1 column. |
| A141_Translate |
Translation of the code-value in A141 column. |
| A142_1_Translate |
Translation of the code-value in A142_1 column. |
| A142_Translate |
Translation of the code-value in A142 column. |
| A143_1_Translate |
Translation of the code-value in A143_1 column. |
| A143_Translate |
Translation of the code-value in A143 column. |
| A144_1_Translate |
Translation of the code-value in A144_1 column. |
| A144_Translate |
Translation of the code-value in A144 column. |
| A163_1_Translate |
Translation of the code-value in A163_1 column. |
| A163_Translate |
Translation of the code-value in A163 column. |
| A164_1_Translate |
Translation of the code-value in A164_1 column. |
| A164_Translate |
Translation of the code-value in A164 column. |
| A165_1_Translate |
Translation of the code-value in A165_1 column. |
| A165_2_Translate |
Translation of the code-value in A165_2 column. |
| A165_Translate |
Translation of the code-value in A165 column. |
| A166_1_Translate |
Translation of the code-value in A166_1 column. |
| A166_2_Translate |
Translation of the code-value in A166_2 column. |
| A166_Translate |
Translation of the code-value in A166 column. |
| A167_1_Translate |
Translation of the code-value in A167_1 column. |
| A167_2_Translate |
Translation of the code-value in A167_2 column. |
| A167_Translate |
Translation of the code-value in A167 column. |
| A169_1_Translate |
Translation of the code-value in A169_1 column. |
| A169_Translate |
Translation of the code-value in A169 column. |
| A170_1_Translate |
Translation of the code-value in A170_1 column. |
| A170_Translate |
Translation of the code-value in A170 column. |
| A171_1_Translate |
Translation of the code-value in A171_1 column. |
| A171_Translate |
Translation of the code-value in A171 column. |
| A172_1_Translate |
Translation of the code-value in A172_1 column. |
| A172_Translate |
Translation of the code-value in A172 column. |
| A173_1_Translate |
Translation of the code-value in A173_1 column. |
| A173_Translate |
Translation of the code-value in A173 column. |
| A174_1_Translate |
Translation of the code-value in A174_1 column. |
| A174_Translate |
Translation of the code-value in A174 column. |
| A178_1_Translate |
Translation of the code-value in A178_1 column. |
| A178_Translate |
Translation of the code-value in A178 column. |
| A179_1_Translate |
Translation of the code-value in A179_1 column. |
| A179_Translate |
Translation of the code-value in A179 column. |
| A189_1_Translate |
Translation of the code-value in A189_1 column. |
| A189_Translate |
Translation of the code-value in A189 column. |
| A213_1_Translate |
Translation of the code-value in A213_1 column. |
| A213_Translate |
Translation of the code-value in A213 column. |
| A214_1_Translate |
Translation of the code-value in A214_1 column. |
| A214_2_Translate |
Translation of the code-value in A214_2 column. |
| A214_3_Translate |
Translation of the code-value in A214_3 column. |
| A214_Translate |
Translation of the code-value in A214 column. |
| A215_1_Translate |
Translation of the code-value in A215_1 column. |
| A215_2_Translate |
Translation of the code-value in A215_2 column. |
| A215_Translate |
Translation of the code-value in A215 column. |
| A216_1_Translate |
Translation of the code-value in A216_1 column. |
| A216_Translate |
Translation of the code-value in A216 column. |
| A217_1_Translate |
Translation of the code-value in A217_1 column. |
| A217_Translate |
Translation of the code-value in A217 column. |
| A219_1_Translate |
Translation of the code-value in A219_1 column. |
| A219_Translate |
Translation of the code-value in A219 column. |
| A228_1_Translate |
Translation of the code-value in A228_1 column. |
| A228_2_Translate |
Translation of the code-value in A228_2 column. |
| A228_Translate |
Translation of the code-value in A228 column. |
| A281_1_Translate |
Translation of the code-value in A281_1 column. |
| A281_Translate |
Translation of the code-value in A281 column. |
| A649_1_Translate |
Translation of the code-value in A649_1 column. |
| A649_Translate |
Translation of the code-value in A649 column. |
| A21_T_Translate |
Translation of the code-value in A21_T column. |
| A167_T_Translate |
Translation of the code-value in A167_T column. |
| A215_T_Translate |
Translation of the code-value in A215_T column. |
| A228_T_Translate |
Translation of the code-value in A228_T column. |