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.

N9210VHarrison Joe · Atlanta, TXS/N 690044N9211MSowers James Dalton · Park City, KYBuilt 1966 · S/N 3435N9211VMorrissey Thomas A · Peachtree City, GABuilt 1969 · S/N 690047N9212CMyers Kenneth O · Niskayuna, NYBuilt 1978 · S/N R18200445N9212VKocher Edward A · Longview, TXBuilt 1969 · S/N 690057N92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYBuilt 1973 · S/N 17261546N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549N9214ATerhune Larry W · Saginaw, TXBuilt 1982 · S/N 38-82A0116N9214VGostomski Michael J · Yacolt, WABuilt 1969 · S/N 690049N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550N9215VGonzalez Cruz · North Las Vegas, NVS/N 690045N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020N9216MLewellen Richard H · Mount Vernon, WABuilt 1966 · S/N 3437N9216TLudwigson Joel · Inver Grove Hts, MNBuilt 1978 · S/N 38-78A0279N9217MMullenbach Arnold D · Tucson, AZBuilt 1966 · S/N 3438N9218CArensmeyer Michael W · Longmont, COBuilt 1978 · S/N R18200448N9218VTerrell Aviation Inc · Terrell, TXBuilt 1969 · S/N 690051N9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021N9219VChen Brian K · Bakersfield, CABuilt 1969 · S/N 690047N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752N921KPCenturion N709jm LLC · Minneapolis, MNBuilt 1978 · S/N R18200298N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9220MBeaty David · Santa Fe, NMBuilt 1966 · S/N 1181N9222RWellman A Ryan · San Jose, CABuilt 1978 · S/N R18200670N9222VSoco Scuba LLC · Austin, TXS/N 690052N9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024N9223VQuick Janice L · Wrightwood, CABuilt 1969 · S/N 690060N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554N92258Mendez Leonel Jr · Corpus Christi, TXBuilt 1978 · S/N 38-79A0014N9225MSmith Carl L · Danville, KYBuilt 1966 · S/N 1184N9225VDuncan Mark E · Marlton, NJBuilt 1969 · S/N 690048N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026N9227MMullis Brent S · Garfield, GABuilt 1966 · S/N 3442N9228MSteubs Mike H · Portland, ORBuilt 1966 · S/N 1185N9228VDuval James A · Lima, OHBuilt 1969 · S/N 690049N9229MMadsen Jan Eric · Lincoln, NEBuilt 1966 · S/N 1186N922AKSanderson David C · Fort Davis, TXBuilt 1978 · S/N 15281807N922DEMichigan Aviation LLC · Commerce Township, MIBuilt 2013 · S/N 1117-2013N922EAButler Ronald A · Cumming, GAS/N 17263921N922TJBowar Gary R · Miranda, SDBuilt 2008 · S/N 503-2008N922WSWerth Jill · Canandaigua, NYBuilt 1973 · S/N 947-73N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558N9230MPernick Kevin · Milford, IABuilt 1966 · S/N 1187N9230RMeyer Bros Ag LLC · Algona, IABuilt 1975 · S/N 18802171T
Back to AD 80-25-07 R1