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.

N9745MJones Joseph D · Bixby, OKBuilt 1967 · S/N 670039N9745WMadi Mohammed Nashat Ibrahim · Charlotte, NCBuilt 1967 · S/N 28-23227N97465Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276194N9746BRegistration Pending · Middletown, DERegistration pendingBuilt 1981 · S/N 172RG1009N9746DLong Verl L · Lewiston, IDBuilt 1959 · S/N 22-6659N9746JJet Air Inc · Iowa City, IABuilt 1967 · S/N 28-3942N9746WRegistered aircraftBuilt 1967 · S/N 28-23229N9747DBender Roger J · Overgaard, AZBuilt 1959 · S/N 22-6660N9747JThomas Daniel S · Willow, AKBuilt 1967 · S/N 28-3943N9747UHenrie Edwin A · Benton, KSBuilt 1976 · S/N AA5A0147N9747WAustin Christopher W · Dayton, NVBuilt 1967 · S/N 28-23230N97489Neron II LLC · Lewes, DES/N 17276197N9748JReynolds John J · Howell, MIBuilt 1967 · S/N 28-3946N9748QSchwanke Timothy Michael · Enid, OKBuilt 1971 · S/N MB-522N9748UQuiet Birdmen LLC · Lanoka Harbor, NJBuilt 1976 · S/N AA5A-0148N9748WWest David · Astoria, ORBuilt 1967 · S/N 28-23231N9749DCaldwell Joel A · Kenai, AKS/N 22-6662N9749JNoth Christopher A · Seminole, FLBuilt 1967 · S/N 28-3935N9749QKyle Edwards LLC · Seneca, SCBuilt 1971 · S/N M-1363N9749UBowman Jason C · Bellbrook, OHBuilt 1976 · S/N AA5A-0149N974ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916126N974BDSchwanke Donald D · Springfield, ILBuilt 1996 · S/N 16N974CAFranks Gary W · Bolivar, MOS/N 17264459N974JSKleen Chris W · Davenport, FLBuilt 1995 · S/N 22974N9750JBaltz Aviation Services LLC · Mercer, WIBuilt 1967 · S/N 28-3897N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789N9751JR&A Aviation LLC · Flower Mound, TXBuilt 1967 · S/N 28-3944N9751MSchott Milbert F · Richland Center, WIBuilt 1967 · S/N 670045N9751UCox Glenn E · Denton, NEBuilt 1976 · S/N AA5A-0151N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524N9752UBg Aero Ltd Co · Coyle, OKBuilt 1976 · S/N AA5A-0152N9753UJ&M Aviation LLC · Atkinson, NEBuilt 1976 · S/N AA5A-0153N9753WSeppala Matthew T · Hortonville, WIS/N 28-23236N9754DLaney Charles A · Maiden, NCS/N 22-6668N9754MZiaja Rebecca · Virginia Beach, VABuilt 1967 · S/N 670048N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9755JDesroches John · Scottsdale, AZS/N 28-3947N9755WAncheta Kai A · Anchorage, AKBuilt 1967 · S/N 28-23239N9756JJackson Robert L · Leesburg, VABuilt 1967 · S/N 28-3948N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9757UFairchild James C · Pinson, TNS/N AA5A-0157N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758DEvans Michael K · Nome, AKS/N 22-6672N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951
Back to AD 80-04-03 R2