OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeBuilt 1982 · S/N 15285582N9400EVan Anda Aviation LLC · Apopka, FLBuilt 1979 · S/N 17272249N9400HRoach John C · Lawrenceburg, KYS/N 17266142N9400LMerino Cesar · Washington, DCBuilt 1986 · S/N 17276550N9401HConstantine Costas T · Newington, CTS/N 17266143N9401VMedin David T · Marion, IABuilt 1969 · S/N 700020N9403VSwift Damian · Livermore, CAS/N 700022N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498N9404HSowell Richard G · San Jose, CABuilt 1975 · S/N 17266145N9405VShoop Robert A Jr · Austin, TXBuilt 1969 · S/N 700021N9406VKuyami Inc · Las Vegas, NVBuilt 1969 · S/N 700034N9407HB2w Corporation · Winona, MNBuilt 1975 · S/N 17266147N9407VWarkentin Lynden K · Russell Springs, KYBuilt 1969 · S/N 700023N9408LMccallum David DBA · Napa, CABuilt 1986 · S/N 17276551N94097Registration Pending · St Simons Island, GARegistration pendingBuilt 1982 · S/N 15285595N9409LLaguna Verde Leasing Inc · Wilmington, DEBuilt 1986 · S/N 17276552N940AMOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 17275286N940FSYogini Modi · Homestead, FLBuilt 1979 · S/N 17272350N940RJLaguna Verde Leasing Inc · Wilmington, DEBuilt 1978 · S/N 15281680N9410VRlangone Inc · Seaford, NYBuilt 1969 · S/N 700036N94112Cooper Robert Jb · Wichita, KSBuilt 1982 · S/N 15285600N94118Unique Educational Experiences · Long Beach, CABuilt 1982 · S/N 15285601N9411LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276553N9411TLopez Geo U · Round Rock, TXBuilt 1978 · S/N 38-78A0099N9412BWilliams Francis · Chester, CTBuilt 1981 · S/N 172RG0815N94138Space Coast Aircraft Co · Merritt Island, FLBuilt 1982 · S/N 15285606N9413HPayne Rachel L · Geneva, FLBuilt 1975 · S/N 17266150N9413VBindl Daniel Leo · Edgewater, FLBuilt 1969 · S/N 700023N94140Ng Calvin · Houston, TXBuilt 1982 · S/N 15285607N9414BAddison Edward T · Matamoras, PAS/N 3286N9414HVandewalle Robert H · East Tawas, MIBuilt 1979 · S/N 17273141N9414VMax Mix Gourmet Spice Blends LLC · Rocky Mount, MOS/N 700025N9415BDulles Aviation Inc · Bristow, VABuilt 1981 · S/N 172RG0816N9415HDungan William T Jr · Marion, VABuilt 1975 · S/N 17266151N9415VViens Gerald J · Belchertown, MABuilt 1969 · S/N 700038N9416VCothren Edward W · Ada, OKS/N 700050N94179Aerophile LLC · Wilmington, DEBuilt 1982 · S/N 15285613N9417LJalomc LLC · Glassport, PABuilt 1986 · S/N 17276555N9417VFraembs David G · Canyon Lake, TXBuilt 1969 · S/N 700039N9418VSmith James · Lawrenceburg, TNS/N 700024N94194Power Flow Systems Inc · Daytona Beach, FLBuilt 1982 · S/N 15285618N941JWMoses Aviation Services LLC · Uvalde, TXBuilt 1978 · S/N R18200719N941SMSchmidt Aaron B · Auburn, ALS/N 172RG0278N941TWHodge Flight Services LLC · Pittsburg, CABuilt 1981 · S/N 17275446N9420EAero Quest LLC · Costa Mesa, CABuilt 1979 · S/N 17272256N9420VAerologic LLC · Yorktown, VABuilt 1969 · S/N 700040N9421DJeff Air Pilot Services LLC · Shelbyville, INBuilt 1984 · S/N 172RG1154N9421EStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N 17272257N9421VKohler Robert · Gilroy, CABuilt 1969 · S/N 700025N9423VLevin Robert G · Roseburg, ORS/N 700041
Back to AD 80-25-07 R1