AD 80-25-07 R1
Registered aircraft · 25,364
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N10CHGulf Coast Rail Service Inc · Victoria, TXN10CRCarlile Aviation LLC · Peculiar, MON10DJNovak Todd · Lumberton, NJN10EXDrachen Air LLC · Stafford, VAN10GRamsey Wayne · Abilene, TXN10GLMakulu Adventures LLC · Fort Pierce, FLN10HNMcaleer John J · Bermuda Dunes, CAN10HVRegistered aircraftN10HXIjh Farm Inc · Seminole, TXN10JZDhz LLC · Cincinnati, OHN10TTHays John J Jr · Denton, TXN10TUAction Aviation LLC · Idaho Falls, IDN10VFAce Aircraft Leasing Inc · Nazareth, PAN10WNSimpson Dale · Coppell, TXN10XCMontgomery Jerry J Jr · Charlotte, NCN10ZTVliegtuig LLC · Plattsmouth, NEN1100UThomas Jennifer G · Dayton, OHN1101CHampton Brock W · Wichita, KSN1101GRegistered aircraftN11022Tailwheel Solutions LLC · Wilmington, DEN11023Kyser Donald J · St Paul, MNN11025Edmunds Brenda L · Tallahassee, FLN11026Allen David L · Surfside Beach, SCN11028Rush Casey K · Troy, KSN11029Benner James M · Great Falls, MTN1102CWakefield Aviation LLC · Mahopac, NYN1102ELee Robert J Trustee · Denver, NCN1102MEls Dennis J · Centralia, ILN11031Griffin Brian · Nashville, GAN11033Keller Lee J · Minot, NDN1103EPhantom Flyer LLC · Yelm, WAN1103MFlying M Enterprises · Loomis, NEN11041Quad Aviation LLC · Branchville, NJN11042Hogsten-Anderson Niklas Erik · Jupiter, FLN11049Pancake C William Jr · Keyser, WVN1104MCarrolls Auto & Aircraft LLC · Muncie, INN11050Roll With It LLC · West Jordan, UTN11052Prather Carl Lynn · Gilroy, CAN11053Skaggs Zachery · Bono, ARN11055Graham Bruce Edwin · Coto De Caza, CAN11059Lakes Area Aviation LLC · Little Falls, MNN1105BAgaliotis Paul E · San Martin, CAN1105CLandon Jeff · Lancaster, CAN11061Naber Cattle Co · Halsey, NEN11062Sullivan Lynford M · Hernando, MSN11063Blanchard Robert W · Elverta, CAN11065Bishop Dean D · Dexter, MON11066Stick N Rudder LLC · Cartersville, GAN11067Teel Glen A · Hays, KSN11068Toftness David R · Clear Lake, WI
Back to AD 80-25-07 R1