132
OE
|
fctr_cmplx_rwy_cond_flag_oe
|
1,164 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
133
|
OE
|
fctr_cmplx_rwy_config_flag_oe
|
875 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
134
|
OE
|
fctr_cmplx_spl_event_flag_oe
|
1,181 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
135
|
OE
|
fctr_cmplx_trrn_flag_oe
|
1,196 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
136
|
OE
|
fctr_cmplx_wx_flag_oe
|
1,089 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
137
|
OE
|
fctr_com_err_flag_oe
|
missing
|
116 Y, 569 N, 363 missing on relevant set
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
138
|
OE
|
fctr_com_otr_desc
|
inconsistent with flag
|
Some non-missing values are Y, some are N on fctr_com_err_flag. 63 non-missing values
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
139
|
OE
|
fctr_comptr_entry_flag
|
Missing
|
31 Y, 756 Missing, 261 N on relevant set
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
140
|
OE
|
fctr_comptr_otr_desc
|
inconsistent with flag
|
1039 missing, 9 non-missing. All non-missing are missing on fctr_comptr_entry_flag
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
141
|
OE
|
fctr_coord_flag_oe
|
Missing
|
88 Y, 707 N, 253 Missing on relevant set
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
142
|
OE
|
fctr_coord_gnd_lcl_flag_oe
|
Missing
|
73 Y, 245 N, 730 Missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
143
|
OE
|
fctr_coord_gnd_lcl_otr_desc
|
inconsistent with flag
|
45 non-missing values. 35 are missing on flag, 10 are Y
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
144
|
OE
|
fctr_data_post_flag
|
missing
|
39 Y, 85Missing, 924 N on relevant set
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
145
|
OE
|
fctr_flight_strip_flag
|
Missing
|
38 Y, 762 missing, 248 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
146
|
OE
|
fctr_flight_strip_otr_desc
|
inconsistent with flag
|
16 non-missing values. 13 missing on flag, rest are Y
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
147
|
OE
|
fctr_gnd_opn_flag
|
Missing
|
144 Y, 673 Missing, 231 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
148
|
OE
|
fctr_inapp_disp_flag
|
missing
|
40 Y, 762 Missing, 246 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
149
|
OE
|
fctr_inapp_disp_otr_desc
|
inconsistent with flag
|
9 non-missing values. 2 Y, 7 missing on flag
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
150
|
OE
|
fctr_incdnt_area_flag
|
missing
|
48 Y, 729 Missing, 271 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
151
|
OE
|
fctr_info_exchg_flag_oe
|
missing
|
48 Y, 684 missing, 316 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
152
|
OE
|
fctr_info_exchg_otr_desc
|
missing
|
39 non-missing. 25 missing flag, 1 N, 13 Y
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
153
|
OE
|
fctr_misid_flag
|
missing
|
31 Y, 279 N, 738 Missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
154
|
OE
|
fctr_misid_otr_desc
|
inconsistent with flag
|
9 non-missing. 1 Y on flag, 8 missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
155
|
OE
|
fctr_psn_relf_brfg_flag_oe
|
missing
|
40 Y, 905 N, 103 Missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
156
|
OE
|
fctr_psn_relf_otr_desc
|
inconsistent with flag
|
13 non-missing. 2 Y on flag, rset missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
157
|
OE
|
fctr_radar_disp_flag
|
missing
|
42 Y, 123 Missing, 883 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
158
|
OE
|
fctr_rdbk_flag
|
Missing
|
98 Y, 713 Missing, 237 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
159
|
OE
|
fctr_rdbk_otr_desc
|
inconsistent with flag
|
110 non-missing values. 2 N on flag, 23 Y, rest missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
160
|
OE
|
fctr_trng_flag
|
missing
|
95 Y, 3 missing, 950 N. Likely useable
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
161
|
OE
|
fctr_visl_data_flag
|
missing
|
111 Y, 231 N, 706 Missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
162
|
OE
|
fctr_visl_data_otr_desc
|
inconsistent with flag
|
171 non-missing values. 23 Y on flag, 17 N on flag, rest missing
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
163
|
OE
|
fctr_wx_flag_oe
|
missing
|
41 Y, 4 Missing, 1003 N
|
Factor (non complex) flags are missing relevent other data, are unclear in how they were aggregated, and are poorly laid out on the form. Data will be dropped
|
164
|
OE
|
loc_drctn_deg_qty
|
Missing
|
4 unique vlaues. 27 0s, 1 6, 1 140, 2 180s. Cluster on 0 makes little sense. 1017 missing
|
variable dropped
|
165
|
OE
|
loc_dstc_nm_qty
|
Missing
|
769 missing, 275 0s. 2 1s. 2 2s. Seems like that makes sense for ground incidents
|
variable dropped
|
166
|
OE
|
loc_fix_code
|
missing
|
14 non missing vlaues. Mostly unique (2 instances of KFXE)
|
variable dropped
|
167
|
OE
|
loc_intxn_id_code
|
Inconsistent entires
|
Field needs to be parsed to be useable. Lots of unique entires. Not filled out in conjuntion with rwy and twy code.
|
These three variables are actually quite interesting, but likely too much effort to parse/do much with given the constraints and competing options. Variable dropped
|
168
|
OE
|
loc_rwy_code
|
Inconsistent entires
|
Field needs to be parsed to be useable. Lots of unique entires. See loc_intxn_id_code
|
These three variables are actually quite interesting, but likely too much effort to parse/do much with given the constraints and competing options. Variable dropped
|
169
|
OE
|
loc_twy_code
|
Inconsistent entires
|
Field needs to be parsed to be useable. Lots of unique entires. See loc_intxn_id_code
|
These three variables are actually quite interesting, but likely too much effort to parse/do much with given the constraints and competing options. Variable dropped
|
170
|
OE
|
opn_proc_defic_flag
|
missing
|
3 missing, 984 N, 61 Y. Desc field only filled out for Y values
|
variable uninteresting, dropped
|
171
|
OE
|
opn_proc_spl_desc
|
inconsistent with flag
|
103 non-missing values. 1 on N, rest on Y. 5 missing values have Y for flag
|
variable dropped
|
172
|
OE
|
opn_proc_spl_flag
|
Missing
|
107 Y, 3 Missing, 938 N
|
reocide missing as no
|
173
|
OE
|
opn_psn_comb_code
|
missing
|
1 missing value. Unclear on "N". Interpreted to mean combined, not approved
|
variable dropped
|
174
|
OE
|
opn_sctr_comb_code
|
missing. Unclear coding
|
Coding unclear. No A listed in ATQA dictionary. 174 missing
|
will use the RI database instead, variable dropped
|
175
|
OE
|
opn_sctr_comb_code_oe
|
174 missing values
|
|
will use the RI database instead, variable dropped
|
176
|
OE
|
opn_sctr_comb_code_oe and ctlr_psn_comb_desc_oe
|
inconsistent information
|
These two variables do not always agree
|
will use the RI database instead, variable dropped
|
177
|
OE
|
oprtr_flt_id_nbr_oe
|
Lots of unique entires
|
Will require parsing. 2 missing values
|
drop two missing observations when necessary. Will parse to just operator
|
178
|
OE
|
oprtr_flt_id_nbr_oe
|
3 missing values and inconsistent formatting of string variable
|
Airport callsign- Most begin with 3-character airline code, but not all follow that practice (e.g., "AIRPORT", "BICEP", "AP 525")
|
drop two missing observations when necessary. Will parse to just operator
|
179
|
OE
|
plt_rprt_nmac_code_oe
|
missing
|
16 missing. 164 unknown
|
variable irrelevent, dropped
|
180
|
OE
|
sepn_hrzntl_ft_qty
|
missing
|
289 missing values. Extends up to 13050 which seems high to be in a RI
|
will be for "demographic" purposes only, variable is sufficent for these purposes
|
181
|
OE
|
sepn_hrzntl_min_qty
|
missing
|
all missing (1048)
|
variable dropped
|
182
|
OE
|
sepn_ver_ft_qty
|
missing
|
588 missing.
|
will be for "demographic" purposes only, variable is sufficent for these purposes
|
183
|
OE
|
|
final/prelim status
|
Are the fields taken from the ATQA database final or preliminary? Is it possible that some of the OEs reported are classified as OE preliminarily then later reclassified as PD? How would you tell which those were?
|
FROM FAA: Yes its possible. The final determination should be based on the classification in the RI database.
|
184
|
Ops
|
|
Need to figure out how to get all 3000 days of operations data
|
|
|
185
|
PD
|
acft_alt_ft_qty
|
Missing
|
Dropped variable
|
|
186
|
PD
|
acft_alt_unk_flag
|
Missing, Yes, No values
|
6179 missing
|
|
187
|
PD
|
acft_ctl_arpt_no_twr_flag
|
Missing, Yes, No values
|
6252 missing
|
Treat missing as N.; drop variable
|
188
|
PD
|
acft_ctl_class_a_flag
|
Missing, No values
|
Dropped variable
|
|
189
|
PD
|
acft_ctl_class_b_flag
|
Missing, Yes, No values
|
|
