AD 2017-26-06
Registered aircraft · 665
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:2017-26-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-06')
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:2017-26-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-06') 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.
N12167United Airlines Inc · Chicago, ILN12172United Airlines Inc · Chicago, ILN12175United Airlines Inc · Chicago, ILN12195United Airlines Inc · Chicago, ILN121ATJea Media Luna Surface Lp · Bearden, ARN12201United Airlines Inc · Chicago, ILN12540Dulux Public Charter LLC · Dallas, TXN12552Corporate Flight Management Inc · Smyrna, TNN125DZCitation X Parts LLC · Liberty, NCN125RHAir Siete LLC · Wilmington, DEN125THCitation X Parts LLC · Liberty, NCN12BA3hba LLC · Dallas, TXN12GGLima Golf Investments LLC · Bigfork, MTN13123Delux Public Charter LLC · Dallas, TXN13124United Airlines Inc · Chicago, ILN13132United Airlines Inc · Chicago, ILN13133United Airlines Inc · Chicago, ILN13161United Airlines Inc · Chicago, ILN13202United Airlines Inc · Chicago, ILN135SCBallator Equipment Leasing LLC · Beech Mountain, NCN135SGValiair Lc Trustee · Casper, WYN135SKZed Aerocapital LLC · Dover, DEN135SLZed Aerocapital LLC · Dover, DEN135SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN138DEChampion Air LLC · Mooresville, NCN138SPFixed Gear 2 LLC · Seattle, WAN13975Delux Public Charter LLC · Dallas, TXN13978Delux Public Charter LLC · Dallas, TXN13979Delux Public Charter LLC · Dallas, TXN13988Delux Public Charter LLC · Dallas, TXN13989Delux Public Charter LLC · Dallas, TXN13992Delux Public Charter LLC · Dallas, TXN13SYSy Air LLC · Tampa, FLN14105Delux 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, IL
Back to AD 2017-26-06