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.
N780BABoeing Aircraft Holding Co · Renton, WAN780UAUnited Airlines Inc · Chicago, ILN781ANAmerican Airlines Inc · Fort Worth, TXN781UAUnited Airlines Inc · Chicago, ILN78285Umb Bank N A Trustee · Salt Lake City, UTN782ANAmerican Airlines Inc · Fort Worth, TXN782UAUnited Airlines Inc · Chicago, ILN783ANAmerican Airlines Inc · Fort Worth, TXN783AXCargo Aircraft Management Inc · Wilmington, OHN783CKKalitta Air LLC · Ypsilanti, MIN783HWSpectre Air Capital LLC · Horseshoe Bay, TXN783UAUnited Airlines Inc · Chicago, ILN784ANUmb Bank Na Trustee · Salt Lake City, UTN784JBJetblue Airways Corp · Long Island City, NYN784UAUnited Airlines Inc · Chicago, ILN78501United Airlines Inc · Chicago, ILN78506United Airlines Inc · Chicago, ILN78509United Airlines Inc · Chicago, ILN78511United Airlines Inc · Chicago, ILN78524United Airlines Inc · Chicago, ILN78540United Airlines Inc · Chicago, ILN785ANAmerican Airlines Inc · Fort Worth, TXN785UAUnited Airlines Inc · Chicago, ILN786ANAmerican Airlines Inc · Fort Worth, TXN786UAUnited Airlines Inc · Chicago, ILN787ALAmerican Airlines Inc · Fort Worth, TXN787CKKalitta Air LLC · Ypsilanti, MIN787UAUnited Airlines Inc · Chicago, ILN788ANAmerican Airlines Inc · Fort Worth, TXN788UAUnited Airlines Inc · Chicago, ILN789ANAmerican Airlines Inc · Fort Worth, TXN789JBJetblue Airways Corp · Long Island, NYN79011United Airlines Inc · Chicago, ILN790ANAmerican Airlines Inc · Fort Worth, TXN791ANAmerican Airlines Inc · Fort Worth, TXN791UAUnited Airlines Inc · Chicago, ILN79279United Airlines Inc · Chicago, ILN792ANAmerican Airlines Inc · Fort Worth, TXN792UAUnited Airlines Inc · Chicago, ILN793ACUmb Bank Na Trustee · Salt Lake City, UTN793ANAmerican Airlines Inc · Fort Worth, TXN793AXAeroacq Partners LLC · Laud By Sea, FLN793JBJetblue Airways Corp · Long Island City, NYN793UAUnited Airlines Inc · Chicago, ILN794ANAmerican Airlines Inc · Fort Worth, TXN794JBJetblue Airways Corp · Long Island City, NYN794UAUnited Airlines Inc · Chicago, ILN79521United Airlines Inc · Chicago, ILN79541United Airlines Inc · Chicago, ILN795ANAmerican Airlines Inc · Fort Worth, TX
Back to AD 2007-19-13