AD 2007-04-19 R1
Registered aircraft · 108,434
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-04-19-R1')
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-04-19-R1')
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-04-19-R1') 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-04-19-R1') 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.
N38FRHenry Scott · Kingman, AZN38GCFord Matthew Louis · Odenton, MDN38GEFlorida Captain Services LLC · Punta Gorda, FLN38GFCingari Michael R · Santa Rosa, CAN38GHLagemann Jeffrey P · Cocoa, FLN38GJMonahan Jeffrey L Trustee · Long Beach, CAN38GMNovember Alpha LLC · Dover, DEN38GVVogt Gary J · Spring Valley, MNN38GWAircraft Partner N38gw Dst · BerlinN38HUN38hu LLC · Edwards, CON38HVVandervoort Hendrikus J · Waller, TXN38HYKirkman Todd · Chetek, WIN38JCCrabb Jeffrey A · Madison, ALN38JDSwift Timothy G · Washington, IAN38JMSchindler Dan C · Forney, TXN38JPLaymon Kenneth D · Redlands, CAN38KPAero Equity LLC · Boise, IDN38LAAnderson Larry D · Indianapolis, INN38LBBenson James · Avon, CON38LEWhirlwind Acres Gp · Sharon Springs, KSN38LJCavu Inc · Emmitsburg, MDN38LPN38lp LLC · Jacksonville, FLN38LSLambert Larry W · Plain City, OHN38LTStevens Richard D · Isola, MSN38MBWest Joseph A · Ballston Lake, NYN38MEMerkin William C · Port Orange, FLN38MHWhite Mark A · Agness, ORN38MKThomson Charles · Los Angeles, CAN38NBSailer Christopher J · Loveland, OHN38NERountree Phillip D · Walton, KYN38NTYorkavitz James B · Valley City, OHN38PAMarine Flyer LLC · Eddyville, KYN38PDRichmond Pilots Corp · Linden, NJN38PFSycan Corp DBA · Paso Robles, CAN38PGDuncan Douglas J · Norwalk, WIN38PKDeininger Robert · Apopka, FLN38PVVu Phat T · Buena Park, CAN38PWHerbert Mike O · Valley Mills, TXN38RCharliefoxtrot LLC · Farmington, MON38RAAb Prop Plane II LLC · Metairie, LAN38RGGee Kevin D · Chandler, TXN38RHCummins George · Natchitoches, LAN38RJAircraft Guaranty Corp Trustee · Oklahoma City, OKN38RRClark Martin B · Dayton, OHN38RZGgt Aviation LLC · Saint Paul, MNN38SShepphird John C · Reno, NVN38SBAb Prop Plane II LLC · Metairie, LAN38SRReeves Steve L · Lake City, SCN38SSKane Of The Upstate · Greenville, SCN38TBDrier Properties LLC · Gillett, AR
Back to AD 2007-04-19 R1