AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13')
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:2007-19-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13') 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.
N772BCBoeing Aircraft Holding Company · Renton, WAN772ETAlta 777 LLC · Salt Lake City, UTN772UAUnited Airlines Inc · Chicago, ILN773ANAmerican Airlines Inc · Fort Worth, TXN773AXCargo Aircraft Management Inc · Wilmington, OHN773UAUnited Airlines Inc · Chicago, ILN774ANAmerican Airlines Inc · Fort Worth, TXN774AXCargo Aircraft Management Inc · Wilmington, OHN774CLIagcas LLC · Miami, FLFirst renewal noticeN774UAUnited Airlines Inc · Chicago, ILN77510United Airlines Inc · Chicago, ILN77518United Airlines Inc · Chicago, ILN77520United Airlines Inc · Chicago, ILN77525United Airlines Inc · Chicago, ILN77530United Airlines Inc · Chicago, ILN77535United Airlines Inc · Chicago, ILN77536United Airlines Inc · Chicago, ILN77537United Airlines Inc · Chicago, ILN77538United Airlines Inc · Chicago, ILN77539United Airlines Inc · Chicago, ILN77542United Airlines Inc · Chicago, ILN775ANAmerican Airlines Inc · Fort Worth, TXN775DBTvpx Ars Inc Trustee · North Salt Lake, UTN775JBJetblue Airways Corp · Long Island City, NYN775LGLogistic Air Inc · Reno, NVN775UAUnited Airlines Inc · Chicago, ILN776ANAmerican Airlines Inc · Fort Worth, TXN776LGLogistic Air Inc · Reno, NVN776UAUnited Airlines Inc · Chicago, ILN777ANAmerican Airlines Inc · Fort Worth, TXN777AZWilmington Trust Company Trustee · Wilmington, DEN777LALogistic Air Inc · Reno, NVN777UAUnited Airlines Inc · Chicago, ILN778ANAmerican Airlines Inc · Fort Worth, TXN778LGLogistic Air Inc · Reno, NVN778MAUmb Bank Na Trustee · Salt Lake City, UTN778UAUnited Airlines Inc · Chicago, ILN779ANAmerican Airlines Inc · Fort Worth, TXN779JBJetblue Airways Corp · Long Island City, NYN779UAUnited Airlines Inc · Chicago, ILN78001United Airlines Inc · Chicago, ILN78002United Airlines Inc · Chicago, ILN78003United Airlines Inc · Chicago, ILN78004United Airlines Inc · Chicago, ILN78005United Airlines Inc · Chicago, ILN78008United Airlines Inc · Chicago, ILN78009United Airlines Inc · Chicago, ILN78013United Airlines Inc · Chicago, ILN78017United Airlines Inc · Chicago, ILN780ANAmerican Airlines Inc · Fort Worth, TX
Back to AD 2007-19-13