OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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-04-03-R2')
    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-04-03-R2')
  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.

N2553YMacair Aviation LLC · Xenia, OHBuilt 1985 · S/N 28-8516079N25552Region Flyers LLC · Valparaiso, INBuilt 1985 · S/N 28-8516081N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920N2558LHoecher Robert · Anchorage, AKS/N 17255758N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922N2559STrue Altitude LLC · Isola, MSBuilt 1979 · S/N 18-7909160N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268N255LLChandler Elijah J S · Pilot Mountain, NCS/N 082N255PCWinger Michael J · Boulder Junction, WIBuilt 2002 · S/N 5173N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772N255SFKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 1287-2000N255XKnop Courtney Dee · Vernal, UTS/N 20450N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923N2562FMans David A · Gruver, TXBuilt 1965 · S/N 35N2562KPodany John R · Aledo, TXBuilt 1988 · S/N 922N2563UGrande Philip M · Mt Laurel, NJBuilt 1979 · S/N 28-8090057N2565MMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7890257N2565UVintage Flyers Inc · Napa, CABuilt 1979 · S/N 28-8090058N2566PClark William · Easton, MOBuilt 1955 · S/N 22-2929N2566QCarothers Rayburn T · Brevard, NCBuilt 1977 · S/N 28-7725201N2566UHighland Aero LLC · Mcminnville, TNBuilt 1980 · S/N 28-8090059N2567LGolden Valley LLC · Missoula, MTS/N 18-8109014N2567WSullivan Eric V · Santa Barbara, CABuilt 1965 · S/N 3271N2568DPritchett Gregory L · Ozark, ALBuilt 2002 · S/N 5261N2568JState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18-7909131N2568QCasey William · Celina, TXBuilt 1977 · S/N 28-7716113N2568RCraven James J · Pensacola, FLBuilt 1969 · S/N 28-5649N2568WSale Reported · Modesto, CASale reportedBuilt 1965 · S/N 3272N2569MSp Airparts LLC · Moscow, IDBuilt 1946 · S/N 12-940N2569QWatch Ya Head Aviation I LLC · West Haven, UTBuilt 1977 · S/N 28-7790407N256ACAtwood Jerry L · Sweet Home, ORBuilt 1956 · S/N 22-3788N256AMEdwards Bruce D · Georgiana, ALBuilt 2003 · S/N 2256N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067N256BSlayton Michael B · Grand Haven, MIBuilt 1957 · S/N 16N256GDAugust Aero LLC · Kalispell, MTBuilt 2003 · S/N 23639N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958N256SCNovember Alpha LLC · Dover, DEBuilt 2006 · S/N 4007N2570PStaneli Lee A · Kiana, AKBuilt 1956 · S/N 18-4310N2570UJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016036N2571HRiker Walter T · Anchorage, AKBuilt 1979 · S/N 18-7909200N2571MBoston Breeze Aviation LLC · Woburn, MABuilt 1977 · S/N 28-7890258N2571PStrick Steffen G · Mc Grath, AKBuilt 1955 · S/N 18-4311N2571QLubbe Klaus · Bethlehem, NHS/N 28-7790408N2571XRegistration Pending · Augusta, KSRegistration pendingS/N 28-8516037N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485
Back to AD 80-04-03 R2