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.

N212SCDavies Charles C · Lovettsville, VABuilt 1967 · S/N 680111N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214N212WDFoghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N 680066N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372N2131ESchuman William C II · Poplar Grove, ILBuilt 1997 · S/N 24-3401N2131QImhoff Donald W · Baton Rouge, LABuilt 1974 · S/N 177RG0531N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931N2132QHawk Aviation Inc · Chesapeake Beach, MDBuilt 1974 · S/N 177RG0532N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933N2134QLuft Aviation Inc · Wilmington, DEBuilt 1974 · S/N 177RG0534N2134SC Squared Inc · Stevensville, MDBuilt 1979 · S/N R18201307N2134UDean Steel Buildings Inc · Fort Myers, FLBuilt 1982 · S/N 21064775N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934N21360Weede Roger H · Dubois, WYS/N 17263935N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646N213AMNorton Cole R · Marion, IAS/N 559-73N213ANCalifornia In Nice Inc DBA · San Jose, CAS/N 17272380N213CRJuarez Justin · Garden City, IDBuilt 1992 · S/N 690-92N213CSAeromarine Airways Inc · Miami, FLBuilt 1978 · S/N 24-0529N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540N2141QNeuman Allen D · Sanger, TXS/N 177RG0541N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542N2143CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 423-74N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546N2146XGalloway Robert L III · Cypress, TXBuilt 1997 · S/N 24-3413N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956N2148CLarsen Timothy · Marietta, GABuilt 1997 · S/N 24-3405N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548N21492Puryear Rodney K · Pampa, TXS/N P21000641N2149QRegistered aircraftBuilt 1974 · S/N 177RG0549N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000N214ANCalifornia In Nice Inc · San Jose, CAS/N 17267499N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78N214EFMaupin Dean C · Davenport, IABuilt 2013 · S/N 1126-2013N214ERLima-001 LLC · Muscatine, IAS/N 17263480
Back to AD 80-25-07 R1