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.
N2638XSoftware 2000 Inc · Arroyo Grande, CAN2638ZHowlett Corey W · Wasilla, AKN26390Rucker Roger D · Pembroke Pines, FLN26396Vergona John T · Canton, MIN26398Fenton David W · Kihei, HIN2639CClear And Seven LLC · Santa Teresa, NMN2639FHendershott Kevin J · Vacaville, CAN2639GHusted Dean T · Hicksville, OHN2639WBrown Jeffrey R · Leesburg, FLN263AAWilkey Michael B · Kingston, GAN263ATAirline Transport Professionals Corp Of USA · Wilmington, DEN263BPederstuen Ricky L · Hudson, WIN263BCChambers William M · Elkmont, ALN263BEEngen Burdell M · Viking, MNN263DWWarren David T · Mobile, ALN263EAJdcwac LLC · Blair, NEN263EPEpic Aviation Inc · Denison, TXN263MAMacair Aviation LLC · Xenia, OHN263MGGeorgia Aviation Authority · Eastman, GAN263NDPlane Nonsense Inc · Middletown, DEN263SAColumbia Asset Trust Corp Trustee · Wichita, KSN263SFAb Prop Plane I LLC · Metairie, LAN263WYMarshall Laird Jr · Kemmerer, WYN26401Mann James R · Waikoloa, HIN26406Registration Pending · Valdosta, GARegistration pendingN26407Colvin Daniel A · Dayton, TNN2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN2640MStraight Gary D · Wasilla, AKN2640PCrumley Emily M · Bristol, TNN2640YMarc Aircraft Holding LLC · Soldotna, AKN26410Villanueva Francisco B · Leavenworth, KSN26411Cheetah LLC · Burlington, IAN26412Pelican Fisheries Corp · Mount Pleasant, SCN26414Ambrose Douglas · Indio, CAN26415Khano Maurice S · Kennesaw, GAN2641PChandler David G · Phoenix, AZN2641RHowatt Scott · Hannah, NDN2641WRampini Daniel G · Cleveland, OHN2641ZTfs Air LLC · Loveland, CON26422Cressey Aaron · Silverton, ORN26423Poulnott William · Milledgeville, GAN26424Ormanian Austin · Canton, MIN26427She Runs I Fly LLC · Cincinnati, OHN2642ACronin LLC · Jacksonville, FLN2642CMuniz Elmer · Port Saint Lucie, FLN2642DBurchard Farms LLC · Melber, KYN2642GWillis Andrew B · Wasilla, AKN2642MLons Travis W · King Salmon, AKN2642QLongerbone Danny L · Fishers, INN2642SReich Stephen Barry · Kentfield, CA
Back to AD 2007-04-19 R1