AD 2001-08-15
Registered aircraft · 349
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N13979Delux Public Charter LLC · Dallas, TXN13992Delux Public Charter LLC · Dallas, TXN14105Delux Public Charter LLC · Dallas, TXN14116United Airlines Inc · Chicago, ILN14125United Airlines Inc · Chicago, ILN14143United Airlines Inc · Chicago, ILN14148United Airlines Inc · Chicago, ILN14153United Airlines Inc · Chicago, ILN14158United Airlines Inc · Chicago, ILN14162United Airlines Inc · Chicago, ILN14168United Airlines Inc · Chicago, ILN14173United Airlines Inc · Chicago, ILN14174United Airlines Inc · Chicago, ILN14177United Airlines Inc · Chicago, ILN14179United Airlines Inc · Chicago, ILN14180United Airlines Inc · Chicago, ILN14186United Airlines Inc · Chicago, ILN14188United Airlines Inc · Chicago, ILN14198United Airlines Inc · Chicago, ILN14542Delux Public Charter LLC · Dallas, TXN145DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN14904Delux Public Charter LLC · Dallas, TXN14916Delux Public Charter LLC · Dallas, TXN14933Spectre Air Capital LLC · Horseshoe Bay, TXN15509Corporate Flight Management Inc · Smyrna, TNN15527Corporate Flight Management Inc · Smyrna, TNN157MGValiair Lc Trustee · Casper, WYN15912Delux Public Charter LLC · Dallas, TXN15983Delux Public Charter LLC · Dallas, TXN15VAAdvanced Air LLC · Statesville, NCN16147United Airlines Inc · Chicago, ILN16149United Airlines Inc · Chicago, ILN16151United Airlines Inc · Chicago, ILN16170United Airlines Inc · Chicago, ILN16178United Airlines Inc · Chicago, ILN16183United Airlines Inc · Chicago, ILN16510Corporate Flight Management Inc · Smyrna, TNN16525Corporate Flight Management DBA · Smyrna, TNN16541Delux Public Charter LLC · Dallas, TXN16981Delux Public Charter LLC · Dallas, TXN16987Delux Public Charter LLC · Dallas, TXN17138United Airlines Inc · Chicago, ILN17159United Airlines Inc · Chicago, ILN17169United Airlines Inc · Chicago, ILN17185United Airlines Inc · Chicago, ILN17196United Airlines Inc · Chicago, ILN17513Corporate Flight Management Inc · Smyrna, TNN17984Delux Public Charter LLC · Dallas, TXN18114Enterprise Aircraft Finance LLC · Clayton, MON18120Delux Public Charter LLC · Dallas, TX
Back to AD 2001-08-15