AD 2012-22-01
Registered aircraft · 3,852
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:2012-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-01')
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:2012-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-22-01') 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.
N249JSCrystal Coast Training LLC · Kinston, NCN249KFf22 LLC · Scottsdale, AZN24AFAbove & Beyond Aviation LLC · Austin, TXN24BQAb Prop Plane II LLC · Metairie, LAN250AUPeregrine Howard Partners II Lp · New Orleans, LAN250SUOklahoma State University · Stillwater, OKN250YZAtp Aircraft 2 LLC · Wilmington, DEN25110Career Track 4 LLC · Wilmington, DEN25111Career Track 4 LLC · Wilmington, DEN25112Career Track 4 LLC · Wilmington, DEN25113Career Track 4 LLC · Wilmington, DEN25114Career Track 3 LLC · Wilmington, DEN25115Career Track 4 LLC · Wilmington, DEN25116Career Track 3 LLC · Wilmington, DEN25118Career Track 4 LLC · Wilmington, DEN25121Career Track 3 LLC · Wilmington, DEN25122Career Track 3 LLC · Wilmington, DEN25123Career Track 3 LLC · Wilmington, DEN25126Career Track 3 LLC · Wilmington, DEN25129Career Track 3 LLC · Wilmington, DEN25130Career Track 3 LLC · Wilmington, DEN25132Career Track 4 LLC · Wilmington, DEN25135Career Track 4 LLC · Wilmington, DEN25136Career Track 4 LLC · Wilmington, DEN25139Career Track 4 LLC · Wilmington, DEN25141Career Track 4 LLC · Wilmington, DEN25143Career Track 3 LLC · Wilmington, DEN25145Career Track 3 LLC · Wilmington, DEN25150Career Track 4 LLC · Wilmington, DEN25152Career Track 4 LLC · Wilmington, DEN25153Career Track 4 LLC · Wilmington, DEN25157Career Track 4 LLC · Wilmington, DEN25158Career Track 4 LLC · Wilmington, DEN25160Career Track 4 LLC · Wilmington, DEN25161Career Track 4 LLC · Wilmington, DEN25163Career Track 4 LLC · Wilmington, DEN25167Career Track 4 LLC · Wilmington, DEN25170Career Track 5 LLC · Wilmington, DEN25171Career Track 3 LLC · Wilmington, DEN25172Career Track 5 LLC · Wilmington, DEN25173Career Track 3 LLC · Wilmington, DEN25176Career Track 3 LLC · Wilmington, DEN25177Career Track 5 LLC · Wilmington, DEN25180Career Track 5 LLC · Wilmington, DEN25181Career Track 3 LLC · Wilmington, DEN25182Career Track 3 LLC · Wilmington, DEN25184Career Track 5 LLC · Wilmington, DEN25187Career Track 3 LLC · Wilmington, DEN25188Career Track 3 LLC · Wilmington, DEN25189Career Track 5 LLC · Wilmington, DE
Back to AD 2012-22-01