AD 80-25-07 R1
Registered aircraft · 25,369
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.
N7881GSmith John T · Greenfield, INN7882VSlepian Isaac J · El Dorado Hills, CAN78830Frederick Wayne Schultz · Bradley, ILN78834Barron Ted L · Hoover, ALN7883VFranks Gary E · Ponder, TXN78842Helice Sarcelle LLC · San Antonio, TXN78846Aero Investors Lc · Jackson, MIN78850Karpik Richard Paul · Grand Rapids, MNN78856Bedwell Christopher A · Paso Robles, CAN78857Hunt Thornton Trevon · Aurora, CON78865Gingras Carl A · Avondale, CON78869Zullo Thomas L · Lindenhurst, NYN7886GArctic Barnabas Ministries Inc · Kenai, AKN7886VLowenhaupt Michael J · Metairie, LAN78871Rosenfeld Kristina M · Eureka, CAN78873Mesner Steven M · Tomah, WIN78874Rabe Robert Michael · Elk Grove, CAN78875Janssen Christopher R · Ankeny, IAN7887GLandrum Erik · Austin, TXN78880Coma Aviation LLC · Buckhannon, WVN78882Triplat Bonnie E · Rosamond, CAN78884Cooke Daniel S · Kanarraville, UTN78888Woodard Ben C · Truckee, CAN78890Edmondson Donald M · Harvest, ALN78891Registered aircraftN78892Rathbun Robert E · Maywood, MON78893King Eugene A · Rch Palos Vrd, CAN78894Gonzalez Francisco C · Biloxi, MSN78897Knox Phillip A · Snellville, GAN78898Clawson Michael · Allentown, NJN7889GFricker Mark W · Avon, INFirst renewal noticeN7889PWalker Zachary R · Burlington, NDN7889VPoorman Christopher · Burleson, TXN788ABSouthwind Ventures Inc · Madison, WIN788BTPowers Elbie L · Roseboro, NCFirst renewal noticeN788BWNelson Thomas H Jr · Chatham, MSN788MCRoberts James A · Edina, MNN788XDonahue Patrick J · Carriere, MSN7890GAltus Aircraft LLC · Taylor, TXN7890VDoherty Kevin R · Silver Spring, MDN78911Watt Charles D · Marietta, OHN78912Mid America Plumbing LLC · Moscow, TNN78913Ambrose Gary L · Camden, NCN78914Collins Camden B · Millersport, OHN78915Hendryx Alec B · Coffeyville, KSN78918Pearlman Fredric M · Southfield, MIN7891GSam Aviation LLC · Long Beach, CAN78920Duncan Mark T · Orange Grove, TXN78923Rodriguez Julian P · New York, NYN78925Sale Reported · Winthrop, MESale reported
Back to AD 80-25-07 R1