OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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.

N97ADCunningham David · Thomasville, NCBuilt 1967 · S/N 28-22666N97BMZawodny Jeremy D · Groveland, CABuilt 1997 · S/N 5342N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475N97DJSilva Ronald C · Rescue, CABuilt 1995 · S/N 23257N97DVWaugh Terry R · Phoenix, AZBuilt 1977 · S/N AA5B0455N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188N97HPPoutre Robert Paul Trustee · Osceola, WIBuilt 2003 · S/N NF0002N97JEJolly Anthony G · Carthage, MSS/N 23194N97KBBelue Kevin D · Madison, ALBuilt 2002 · S/N 25003N97LWAdkins Clinton R · Corvallis, MTBuilt 2007 · S/N 3573N97MRRebel Back Home LLC · Waterford, MIS/N 426-REBN97MSJesnowski J Luke · Atchison, KSBuilt 2003 · S/N 01SN97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946N97NNAviation Business Corp · Saint Louis, MOS/N 23-435N97NTChasteen Coleman C · Keller, TXBuilt 1998 · S/N 001N97PFSoaring Eagles Flying Svc Ltd · Edwards, ILBuilt 1980 · S/N 28-8116068N97PZStoraasli Paul · Torrance, CABuilt 1997 · S/N 581N97RPCombs Jonathan R · Girdwood, AKBuilt 1998 · S/N PR-18-1N97RTDoran John F · Charlestown, RIS/N 974N97RVLindberg Stephen J · Tumwater, WABuilt 1997 · S/N 2431N97SARegistration Pending · Peosta, IARegistration pendingBuilt 1975 · S/N 18-7509117N97WHCox Thomas R · Kirkland, WAS/N 5263N97WKPantas James S · Mount Pleasant, NCBuilt 1999 · S/N 265978369N97XTRobertson Paul L · Knoxville, TNBuilt 2001 · S/N 205N98001Goltsos William · Barrington, RIBuilt 1969 · S/N 28-25991N98009Lebron Renard Luke Jr · Gulfport, MSBuilt 1969 · S/N 28-25994N9800PGrisham Steve DBA · Belzoni, MSBuilt 1976 · S/N 18-7609032N9800UHarvey Mallory · Baxley, GABuilt 1976 · S/N AA5A0200N9800WMrd Aero LLC · Manheim, PABuilt 1967 · S/N 28-23296N98012Registration Pending · West Sacramento, CARegistration pendingBuilt 1969 · S/N 28-25995N98014Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 28-25998N98015Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25999N98017Blakeslee Vernon A Jr · Torrington, CTBuilt 1969 · S/N 28-26000N9801WNorth Little Rock Air Inc · North Little Rock, ARBuilt 1967 · S/N 28-23297N98021Wright Joseph R · Perry, GABuilt 1969 · S/N 28-26001N9802UStoll John E · Summerville, SCBuilt 1976 · S/N AA5A0202N98037Hammer Joseph K · Dike, TXBuilt 1969 · S/N 28-26004N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703N9803DAttitude Aerobatics LLC · Wilmington, DEBuilt 1959 · S/N 22-6690N9803YHubbard Nathan · Butte, MTS/N 38N98041Rosman Patrick R · Creston, WABuilt 1946 · S/N 18188N9804DEngbring Tim · Valmeyer, ILBuilt 1959 · S/N 22-6691N9804WHoyos Luis · Fort Pierce, FLS/N 28-23301N98055Shkvarok Roman · Staten Island, NYS/N 28-26016N98059Airplane LLC · Fort Collins, COBuilt 1969 · S/N 28-26013N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705N9805WNastasi Frank J Jr · Vero Beach, FLBuilt 1967 · S/N 28-23304N98061Heim Edward A · Benton, KSBuilt 1969 · S/N 28-26017N98065Gurke George J · Anchorage, AKBuilt 1969 · S/N 28-26019N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706
Back to AD 80-04-03 R2