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