Data Dictionary
This data dictionary lists all columns for each table in this data source.
Aids Data
Table: aids_data
Index: rprt_nbr
| Column Name | Business Name | Definition |
|---|---|---|
| rprt_nbr | REPORT NUMBER | The identification number of the event report. |
| event_lcl_date | EVENT LOCAL DATE | The local date the event occurred. |
| event_lcl_time | EVENT LOCAL TIME | The local time of the event, expressed in 24-hour clock format. |
| loc_city_name | ASIAS STANDARD LOCATION CITY NAME | The standardized name for the closest city/place with a U.S. Postal zip code within the state where the event occurred. |
| loc_state_code | ASIAS STANDARD LOCATION STATE CODE | The standardized code for the state, territory, or foreign location where the event occurred. See Business Rules below for the U.S. code standards and Foreign codes and descriptions. |
| loc_arpt_name | ASIAS STANDARD AIRPORT NAME | The standardized name for the airport associated with the event location. NOTE: The ASIAS standard airport name is taken directly from the National Flight Data Center (NFDC) landing facilities airport name. A value for an airport will appear on the report |
| event_type_code | EVENT TYPE CODE | The type of event and flight operation involved. |
| event_mid_air_code | EVENT MID AIR CODE | Indication of whether or not the event was considered a mid-air |
| acft_dmg_code | AIRCRAFT DAMAGE CODE | The aircraft damage as a result of the event. |
| flt_phase_code | FLIGHT PHASE CODE | The phase of operation of the flight at the time of the event. |
| acft_make | ASIAS AIRCRAFT MAKE STANDARD | ASIAS' standardized name for the make (manufacturer) of the aircraft involved in the event. |
| acft_model | ASIAS MODEL NAME STANDARD | ASIAS' standardized model description of the aircraft involved in the event. |
| oprtr_code | ASIAS STANDARD OPERATOR CODE | The code representing the Operator of the aircraft. |
| fltcndct_code | FLIGHT CONDUCT CODE | The Part of the Federal Aviation Regulations under which the aircraft flight was conducted. |
| regist_nbr | REGISTRATION NUMBER | The unique, official registration number of the airplane. NOTE: For U.S. registered aircraft, the leading "N" is dropped. |
| aboard_total_qty | TOTAL ABOARD QUANTITY | The total number of people aboard the aircraft at the time of the event, including crew, pilots, and passengers. |
| inj_total_invlvd_fatal_qty | TOTAL FATAL INJURIES INVOLVED QUANTITY | The total number of fatal injuries of all involved in the event. |
| inj_total_invlvd_non_fatal_qty | TOTAL INJURIES INVOLVED NON FATAL | The total number of non-fatal injuries of all involved in the event. |
| eng_make_name | ENGINE MAKE NAME | The engine make (manufacturer) of the aircraft involved in the event. |
| eng_model_name | AIRCRAFT ENGINE MODEL NAME | The engine model/series as indicated on the engine installed in the aircraft at the time of the event. |
| eng_grp_mkmd_code | ENGINE GROUP MAKE MODEL CODE | The group code of the engine of the aircraft involved in the event. |
| pic_cert_type_code | PILOT IN COMMAND CERTIFICATION TYPE CODE | The certification that the pilot in command holds. |
| pic_flttime_total_hr_qty | PILOT IN COMMAND FLIGHT TIME TOTAL HOURS QUANTITY | The total flight time, in whole hours, by the pilot in command in all aircraft. |
| pic_flttime_total_mkmd_hr_qty | PILOT IN COMMAND FLIGHT TIME TOTAL MAKE MODEL HOURS | The total pilot time, in whole hours, of the pilot in command in the make and model aircraft involved in the event. |
| pic_flttime_total_l90d_hr_qty | PILOT IN COMMAND FLIGHT TIME LAST 90 DAYS HOURS | The total flight time, in whole hours, of the pilot in command in all aircraft during the last 90 days. |
| rmk_text | REMARKS TEXT | Remarks concerning the event. |