OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780N3480XLorenzi Mark E · Lancaster, OHBuilt 1966 · S/N 1154N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023N3481TEstes Kenneth · Portland, ORS/N 17700781N3481XN3481x LLC · Reno, NVBuilt 1966 · S/N 3421N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782N3482XCollins Dallas · Columbia, SCBuilt 1966 · S/N 3422N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783N3483XDoddy Del · Cincinnati, OHS/N 1155N34843Radler Glenn E · Livingston, NJBuilt 1973 · S/N 17702037N34845Ccf Ventures Inc · Bangor, MES/N 17702039N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041N3484NPietsch Warren A · Minot, NDBuilt 1967 · S/N 680067N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044N34852Pride Electric Enterprises · Prescott Valley, AZBuilt 1973 · S/N 17702046N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049N3485XCdm Flight Club Inc · La Jolla, CABuilt 1966 · S/N 1157N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053N34866Schroeder David C · Norfolk, NEBuilt 1976 · S/N 177RG1015N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056N34869Aviation Advantage LLC · Phoenix, AZBuilt 1976 · S/N 177RG1016N3486NRose Thomas Z · Santa Ana, CABuilt 1967 · S/N 680068N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066N3488NValley Aviation LLC · Fargo, NDBuilt 1967 · S/N 680070N34891White Robert A · Washington, NCBuilt 1976 · S/N 177RG1018N34894Whitney Ron · Indianapolis, INBuilt 1974 · S/N 17702070N34896Kidron Flying Club Pll · Wooster, OHBuilt 1974 · S/N 17702071N34897Loscheider Brian P · Cologne, MNBuilt 1974 · S/N 17702072N3489TBlue Skies Aviation LLC · Belfast, MEBuilt 1968 · S/N 17700789N3489XHanson Jonathan · Palmer, AKS/N 1159N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564N348LADirks Brandon D · Ludell, KSS/N 69-146N348MAWilson Ralph W Trustee · Mentor, OHBuilt 2002 · S/N 1337-2002
Back to AD 80-25-07 R1