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.
N411AVAircol 9 · Wilmington, DEN413CMCargo Aircraft Management Inc · Wilmington, OHN416AVAircol 19 · Wilmington, DEN419AZCargo Aircraft Management Inc · Wilmington, OHN423AXOmni Planes LLC · Tulsa, OKN426AVAircol 10 · Wilmington, DEN426UAUnited Airlines Inc · Chicago, ILN427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeN428UAUnited Airlines Inc · Chicago, ILN429MCAtlas Air Inc · Purchase, NYN429UAUnited Airlines Inc · Chicago, ILN4304Bank Of Utah Trustee · Salt Lake City, UTN430UAUnited Airlines Inc · Chicago, ILN431AZCargo Aircraft Management Inc · Wilmington, OHN431UAUnited Airlines Inc · Chicago, ILN432AXCargo Aircraft Management Inc · Wilmington, OHN432UAUnited Airlines Inc · Chicago, ILN433AZCargo Aircraft Management Inc · Wilmington, OHN433UAUnited Airlines Inc · Chicago, ILN434UAUnited Airlines Inc · Chicago, ILN435GXBank Of Utah Trustee · Salt Lake City, UTN435UAUnited Airlines Inc · Chicago, ILN436UAUnited Airlines Inc · Chicago, ILN437UAUnited Airlines Inc · Chicago, ILN438GTAtlas Air Inc · White Plains, NYN438UAUnited Airlines Inc · Chicago, ILN439GTAtlas Air Inc · White Plains, NYN439UAUnited Airlines Inc · Chicago, ILN440UAUnited Airlines Inc · Chicago, ILN441UAUnited Airlines Inc · Chicago, ILN442UAUnited Airlines Inc · Chicago, ILN443AZCargo Aircraft Management Inc · Wilmington, OHN443UAUnited Airlines Inc · Chicago, ILN444UAUnited Airlines Inc · Chicago, ILN445UAUnited Airlines Inc · Chicago, ILN446AVAircol 11 · Wilmington, DEN446UAUnited Airlines Inc · Chicago, ILN447UAUnited Airlines Inc · Chicago, ILN448UAUnited Airlines Inc · Chicago, ILN449UAUnited Airlines Inc · Chicago, ILN451AVAircol 12 · Wilmington, DEN451PEPa Msn 1451 LLC · Dallas, TXN451UAUnited Airlines Inc · Chicago, ILN452UAUnited Airlines Inc · Chicago, ILN453UAUnited Airlines Inc · Chicago, ILN454AVWilmington Trust Co Trustee · Wilmington, DEN454UAUnited Airlines Inc · Chicago, ILN455ACBank Of Utah Trustee · Salt Lake City, UTN455CMCargo Aircraft Management Inc · Wilmington, OHN455UAUnited Airlines Inc · Chicago, IL
Back to AD 2007-19-13