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.

N8774DKeeler Michael E · Riverdale, MIS/N 22-5962N8775NPerez Jeremiah · Fort Worth, TXBuilt 1969 · S/N 28-25599N8776DThielen Andrew W · Marion, IABuilt 1958 · S/N 22-5964N8777NDaniel Adam Christopher · Sanford, NCBuilt 1969 · S/N 28-25601N8778MSchroemer Theodore J · High Point, NCBuilt 1963 · S/N M-208N8779NNorth Little Rock Air Inc · North Little Rock, ARBuilt 1969 · S/N 28-25604N877DAWest Prairie Aircraft LLC · Weiner, ARBuilt 1969 · S/N 28-25877N877GTSumner Gary · Knoxville, TNBuilt 1976 · S/N AA5A0267N877MAMason Rory L · Auburn, NEBuilt 1966 · S/N 28-3674N87806Tackett Russell G · Wilder, IDBuilt 1946 · S/N 12-7N8781DRowe David R · Homer, AKBuilt 1958 · S/N 18-6310N8782FDinger Kevin L · Naples, FLBuilt 1962 · S/N 0107N8783NGustafson Randolph W · Wisconsin Rapids, WIBuilt 1969 · S/N 28-25616N87844Baker Brady Brian · South Hero, VTBuilt 1977 · S/N 139N8784NBates James L · Reisterstown, MDBuilt 1969 · S/N 28-25621N87857Qualitair LLC Trustee · MichelstadtS/N 32N8785DSalter Phlip G · Beaumont, TXBuilt 1958 · S/N 18-6322N8785N85n Corp · Oak Hill, VABuilt 1969 · S/N 28-25622N8786Kiloecho Trnsport LLC · Tucson, AZBuilt 1974 · S/N 929N8786C8786c LLC · Cleburne, TXBuilt 1976 · S/N 28-7615129N8786DMikkelsen Timothy O · Wasilla, AKBuilt 1958 · S/N 18-6323N8786ELuv 2 Fly Ada LLC · Ada, OKBuilt 1976 · S/N 28-7615162N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772N8787CBrolan Aviation LLC · Kansas City, MOBuilt 1976 · S/N 28-7690165N8787EMyers Danny A · Saint Charles, MOBuilt 1976 · S/N 28-7615163N8787FLibby Nicholas J · Olympia, WABuilt 1976 · S/N 28-7715289N8788DMartens Edwin L · Ogallala, NEBuilt 1958 · S/N 18-6325N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204N8788RRicher Ned A · Glendale, AZBuilt 2016 · S/N 91895N8789DStrembicke Derek R · Owens Cross Roads, ALS/N 18-6326N878MCHelicopter Leasing LLC · Henderson, NVBuilt 2005 · S/N 3782N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633N8793LVoerman Joseph R Jr · Cambridge, NYBuilt 1974 · S/N 18-7409125N8794GBarrymore Blake · Hailey, IDBuilt 2019 · S/N JA515-12-17N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639N8796DNelson Rohn R · Salmon, IDBuilt 1958 · S/N 18-6341N8796NMitchell Michael R · Swanville, MEBuilt 1969 · S/N 28-25640N8797DDuflo Spray Chemical Inc · Lowville, NYS/N 18-6342N8797EVan Beckum Peter · Farmington, CTBuilt 1976 · S/N 28-7690209N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215N8799DStadman Tyrel W · Eagle River, AKBuilt 1958 · S/N 18-6350N8799FNew England Equip Corp · Auburn, MARevoked, canceledBuilt 1962 · S/N 0126N8799NDuffe William B · Moscow, IABuilt 1969 · S/N 28-25643N879GHollander Ronald Stefan · Woodmere, NYBuilt 1990 · S/N 879N879WHHumphrey Ronald D · Pace, FLBuilt 1976 · S/N 17268487N87AFMetcalf Shane L · Wasilla, AKBuilt 1950 · S/N 18-66N87CZScotese Attilio G · Mammoth Lakes, CABuilt 1988 · S/N 104N87DLBristol David F · Torrance, CABuilt 2000 · S/N 23720
Back to AD 80-04-03 R2