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.
N20704Atpce LLC · Wilmington, DEN20707Atpce LLC · Wilmington, DEN20711Atpce LLC · Wilmington, DEN20727Atpce LLC · Wilmington, DEN20747Above And Beyond Aviation LLC · Austin, TXN20773Smtm Holdings Inc · Wilmington, DEN207CACivil Air Patrol · Maxwell Afb, ALN207SFTextron Aviation Inc · Wichita, KSN20818N20818 LLC · Wilmington, DEN2081JWings Over Texas Holdings LLC · Denton, TXN2081SPlane Nonsense Inc · Middletown, DEN20830Atpce LLC · Wilmington, DEN2083FDetroit Public Schools Community District · Detroit, MIN20884Atpce LLC · Wilmington, DEN208CPChristiansen Aviation LLC · Wilmington, DEN20910Atpce LLC · Wilmington, DEN20913Atpce LLC · Wilmington, DEN20957Mustang Sally Aviation LLC · Camden, SCN2097GMountain Air Aviation LLC · Fruit Heights, UTN2097TPatriot Aviation Inc · Greenville, DEN2098AAtp Aircraft 1 LLC · Wilmington, DEN2099DRollins Dale G · Covington, LAN209JSCrystal Coast Training LLC · Kinston, NCN209KFf22 LLC · Scottsdale, AZN20BQAb Prop Plane II LLC · Metairie, LAN20EPEpic Aviation Inc · New Smyrna Beach, FLN20MVElizabeth City State University · Elizabeth City, NCN20SUOhio State University · Columbus, OHN2100SBietsch Aviation LLC · Dumfries, VAN21019Svetfur Aviation LLC · Camden, SCN21022Ameriflyers Of Texas Inc · Addison, TXN2102PZima Aviation LLC · Huntington Beach, CAN2103TIasco Flight Training Inc · Redding, CAN2104HGrenier Chad · Moorpark, CAN21056N21056 LLC · Wayne, PAN2105XAb Prop Plane II LLC · Metairie, LAN2107UFlight World Inc · San Juan, PRN2108LSoutheast Aircraft Leasing LLC · Jacksonville, FLN2108ZPinnacle Aviation Services Inc · Encinitas, CAN2109LCaban-Loperena Jumil · Moca, PRN210HFHeritage Asset Leasing LLC · Ronkonkoma, NYN210SUOhio State University · Columbus, OHN2114QJet Air Inc · Iowa City, IAN2114UBravo Zulu Aviation LLC · Torrance, CAN21180L&W Leasing LLC · Murfreesboro, TNN2118LIasco Flight Training Inc · Redding, CAN2119EMid-Island Air Service Inc · Ronkonkoma, NYN2119QMustang Sally Aviation LLC · Camden, SCN211FTUniversity Of The South · Sewanee, TNN211TDChristiansen Aviation LLC · Wilmington, DE
Back to AD 2012-22-01