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.

N27DWFritschle Derek R · Olney, ILBuilt 1975 · S/N 94N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01N27HCCranston Courtland L · Santa Rosa, CAS/N 1N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359N27JWGaither William W · Shallotte, NCS/N 17701148N27KHume James W · Valley View, TXBuilt 1987 · S/N 1067AN27KKButler Robert Wynne Jr · Boyce, LABuilt 1962 · S/N 28-792N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689N27MHCurry Michael J · Ardmore, TNS/N 198N27NCNames Lock K · Eugene, ORBuilt 1989 · S/N NW-3N27PMMagnuson Peter C · Ocala, FLBuilt 1984 · S/N 1309N27RVWhite John M · Lanett, ALBuilt 2000 · S/N 80548N27STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1958 · S/N 1201N27SWDavis James R · Tulsa, OKBuilt 2000 · S/N 21985N27TXDavis David A · Weatherford, TXBuilt 1969 · S/N 195N27VVEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1972 · S/N 001N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72N28003Jensen Larry R · Palo Alto, CABuilt 1978 · S/N AA5B0935N28006Hellwig Frederic C · Nevada City, CABuilt 1978 · S/N AA5B0938N2800WAzul Aviation Inc · Fort Worth, TXS/N 1029N2800ZRitchie John A Jr · Gold Hill, NCBuilt 1959 · S/N 22-6793N2801EJ4 Aero LLC · Gulf Breeze, FLBuilt 1978 · S/N 17271327N2801PVistad Bruce W · Fergus Falls, MNS/N 008N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134N2802ZPeavler Christopher · Modoc, SCS/N 22-6795N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095N2803TBarron David L · Sun City, AZBuilt 1972 · S/N 28-7225241N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101N2808UCoastal Flight Inc · Half Moon Bay, CAS/N 1056N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498N280MAMcgarity Daniel Scott · Essex, MOBuilt 2004 · S/N 4552004N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230N280SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 11070C
Back to AD 80-04-03 R2