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.
N26795Horan Roger · Plainview, TXN26796Rivers Robert W · Savannah, GAN26799Barton Steve K · Canon City, CON2679FR & K Explorations Inc · Bonners Ferry, IDN2679RSchultz Charles D · Webster, WIN2679ZRonalter John M · Norristown, PAN267AAWings Over Texas Holdings LLC · Denton, TXN267AGSimply Living LLC · Fort Myers, FLN267AWExecutive Helicopters Inc · Myrtle Beach, SCN267CAHyannis Air Service Inc DBA · Hyannis, MAN267CMRegistered aircraftN267DHInternational Air Services Inc Trustee · Carson City, NVN267DPCarrasco Mario G · Glendora, CAN267GSArnold Airplane LLC · North Branch, MNN267HPFlorida Highway Patrol · Tampa, FLN267JMomentum Foundation Inc · Tullahoma, TNN267LMAviation Trust Co LLC Trustee · Oklahoma City, OKN267MSweetman Gary S · Wolcott, CTN267MCKitchen Blaine III · Rochester, MAN267MECape Aero LLC · Cape Girardeau, MON267MGGeorgia Aviation Authority · Eastman, GAN267MTPlane Fun Inc Tr Trustee · Snellville, GAN267NDPlane Nonsense Inc · Middletown, DEN267PDWhite Hat Repair LLC · Greenleaf, IDN267RHPxw Services · Bristow, VAN267RWKoelzer Galen G · Othello, WAN267SNorth Carolina Soaring Association · Zebulon, NCN267WSErvin Andrew · Centennial, CON26800Registration Pending · Peyton, CORegistration pendingN26805Barry Robert J · Gresham, ORN2680FWatkins Jeffrey M · Auburn, CAN2680GTodd Larry D · Wasilla, AKN2680MRed Arrow Aviation LLC · Santa Teresa, NMN2680TAviyon Aviation LLC · Orlando, FLN2680WNielson Michael James · Spanish Fork, UTN2680XN2680x LLC · Mountain Home, ARN2680YReid Brian M · Boise, IDN2680ZEaston Christopher J · Burlington, MAN26813Weingart Matthew S · Port Charlotte, FLN26814Desert Cat Aviation LLC · Tempe, AZN2681CBlack Deberah L Trustee · Las Vegas, NVN2681GRhea Higher Education And Aviation LLC · Prescott, AZN2681MHebrink Jason R · Grand Rapids, MNN2681PFlitner Colten · Greybull, WYN2681WAb Mooney LLC · Durham, NCN2681XZimmer Roy E Jr · Winter Park, FLN2681ZOchsenbauer Thomas G · Forest Lake, MNN26821Rhoden Nathan · Prattville, ALN26822Terrier Douglas A · Southlake, TXN26825Redline Aerospace LLC · Kalispell, MT
Back to AD 2007-04-19 R1