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.
N416RKWindyfork LLC · Black Mountain, NCN416RPMiller Aircraft Services Inc · Crookston, MNN416RVRegistered aircraftN416SCribbie Ronald J Trustee · Hernando, FLN416SDTailwheel Adventures LLC · Celebration, FLN416SHLa Calosa Ranch LLC · Falfurrias, TXN416SSChristie Ian A H · Limon, CON416TKehoe Keith J · Marion, TXN416TSSutton Nathan M · Houma, LAN416TXVolo 2020 LLC · New Britain, CTN416USClepper Francis D Jr · Bennington, NEN416WREagle Flying Club Of Embry-Riddle Aero Univ Inc · Daytona Beach, FLN416WTHigh Desert Flight Instruction LLC · Albuquerque, NMN417Mckinney Lloyd M · Boise, IDN4170Nogle Charles J · Champaign, ILN41700Craven Mark C · Salome, AZN41703Sweeny Daniel L · Parrish, FLN4170JMoscrip Mark D · La Vernia, TXN4170LOsborn Allan R Trustee · Springfield, VAN4170MMn Helicopters Inc · Minneapolis, MNN4170PIfa Aviation Inc · Wilmington, DEN4170TVwfusco Aircraft Management LLC · Stratford, CTN4170YCraig Jerome A III · Plantation, FLN41714Nunn Ethan Edwin · Melba, IDN41718Baker Thomas David · Noble, ILN4171HHanson Zane · Danville, INN4171JAlyeska Helicopters LLC · Girdwood, AKN4171QN4171q LLC · Newport Beach, CAN4171SSteffey Kevan J · Bullhead City, AZFirst renewal noticeN4171XGailing Jessica L · Costa Mesa, CAN41723Sale Reported · Greensboro, NCSale reportedN4172DChristiansen Aviation LLC · Wilmington, DEN4172JAscension Enterprises Inc · Saint Augustine, FLN4172SWharton Roofing Services LLC · Gulf Breeze, FLN4172ZMathew Priya Trustee · Utica, NYN41731Novak Michael · Chicago, ILN41738Dadson Aviation LLC · Lowell, INN41739Triple Nickel Inc · Muleshoe, TXN4173BBeck Nicholas G · Ione, CAN4173DCw Flyers Ltd · Wilmington, DEN4173ZHelmericks Aaron W · Wasilla, AKN4174AGutwein Harvey R · Francesville, INN4174CZierhut Kurt P · Camarillo, CAN4174GCaldwell Farms Inc · Garnett, KSN4174JNorth Creek Flying Club Inc · Continental, OHFirst renewal noticeN4174LCst & Sons LLC · South Barrington, ILN4174TAverett University · Danville, VAN41756N41756 LLC · Upper Marlboro, MDN4175CSalciccioli Christopher · Joshua Tree, CAN4175PAero Specialty Finance LLC · Chesterfield, MO
Back to AD 2007-04-19 R1