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.

N2698PMajors Nathaniel Ray · Ball, LAS/N 18-4388N26993Gugel Joseph C Jr · Gettysburg, PABuilt 1979 · S/N AA5A0866N26994G & G Aviation LLC · Stedman, NCBuilt 1979 · S/N AA5A0868N26997Niver Rex E · Jenks, OKBuilt 1979 · S/N AA5A0869N269BTorres Ramon A · Mulberry, FLFirst renewal noticeBuilt 1958 · S/N 127N269BJN2893e LLC · Reno, NVS/N 17270380N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269CPCutler Adam Wilson · Kennebunk, MEBuilt 2000 · S/N 80269N269DBDesilva David I · Baton Rouge, LABuilt 1992 · S/N 20816N269JLPeecher Carl J · Sequim, WAS/N 5020N269JTWohlers Glen Nicholas · Granby, MABuilt 2013 · S/N 60381N269MAOrange Wing Aviation Inc · Wilmington, DES/N 1361-2004N269NEOro LLC · Tilden, NES/N 17272505N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269WMRenninger Log Homes · Meeker, COBuilt 1959 · S/N 18-6874N269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606N26ADTango Aviation LLC · Valrico, FLS/N 20264N26AJByford Christopher H · Mc Gregor, TXBuilt 2005 · S/N 90444N26AKLousberg Daniel A · Wasilla, AKBuilt 1974 · S/N 18-7409079N26CLPuckett Lewis R · Ellijay, GABuilt 1973 · S/N CL72N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26CWBarzelatto Brett · Thornton, COS/N 17272496N26DASimons Thomas A · Howes, SDS/N 001N26EAThweatt Andrew C · Riverside, CABuilt 2005 · S/N 716EN26EVN26ev LLC · Pine, COBuilt 1977 · S/N AA5A0405N26FBBluhm Raymond M · Waxhaw, NCBuilt 2001 · S/N 3810N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318N26GBLunt Christopher J · Marco Island, FLBuilt 1982 · S/N 18-8209004N26HVHotel Victor LLC · Bend, ORS/N 1410N26HYFocus Air LLC · Wilmington, DEBuilt 2000 · S/N 2053N26JSWarrick Douglas R · Corvallis, ORBuilt 1981 · S/N 29N26KAOliver Brian · North Attleboro, MABuilt 1964 · S/N 28-20380N26KSMrd Aero LLC · Manheim, PAS/N 24658N26LMClassic Aviation Inc · Pella, IABuilt 1979 · S/N ME-177N26MF2nd Amendment Consulting And Design LLC · Red Bluff, CAS/N 17701425N26MHZorrilla Peter · Charles Town, WVS/N 20422N26MLDay Brittney L · Inola, OKBuilt 1990 · S/N 2093N26RDPacific North Air LLC · Portland, ORS/N 34-7350167N26SROrtega Daniel H · Mccall, IDBuilt 1995 · S/N 92628N26TDTamaco2 LLC · Jackson, MOBuilt 1969 · S/N M-1228N26TFTop Flight Aviation Inc · Corona, CABuilt 1972 · S/N 17261318N26TPGlobal Aerials Inc · Pembroke Pines, FLFirst renewal noticeBuilt 1967 · S/N 17700144N26VHWise Joe · Kilgore, TXBuilt 2004 · S/N 3677N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153N2700CMckeever Jesse · Indio, CABuilt 1954 · S/N 26244N2702DFerguson James L · Junction City, KSBuilt 1954 · S/N T1-16SN2702WMedic Choppers LLC · Springdale, ARS/N 3329N27036Pace William Todd · Palmer, AKS/N 18-3516N2703DBowser William · Burns, KSBuilt 1956 · S/N T1-20SDN2704PBriggs Ralph H · Des Moines, IABuilt 1955 · S/N 22-3010
Back to AD 80-04-03 R2