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.

N4185ZHill Leslie E · Patten, MEBuilt 1966 · S/N 18-8370N41867Stevens Charles O · Columbus, MSBuilt 1974 · S/N 28-7415340N4186ZSturgeon Ronald A · Anchorage, AKBuilt 1966 · S/N 18-8371N4187JPeterson Erik J · Revillo, SDBuilt 1967 · S/N 28-22526N4187ZPickus Norman F · Fairbanks, AKBuilt 1966 · S/N 18-8372N41880Brown Terry K · Eddyville, IABuilt 1974 · S/N 28-7425292N41882Monroe Robert E · Navarre, FLBuilt 1974 · S/N 28-7415345N41888Lanyi Clifford M · Attleboro, MABuilt 1974 · S/N 28-7415348N4188JLaib Aaron B · Emporia, KSS/N 23022N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676N4188ZDanielson Debra · Skillman, NJBuilt 1966 · S/N 18-8373N41896Hoffman Rick · Buckley, WABuilt 1974 · S/N 28-7415349N41897Unlimited Upside LLC · Boggstown, INBuilt 1974 · S/N 28-7415350N4189PAdams Carlos · Hawi, HIS/N 23-1677N418AAAltitude & Anchor LLC · Kalispell, MTS/N 0582N418ALMckeen Alan P · Liverpool, NYBuilt 1997 · S/N 23130N418CCRedfield James A · Simi Valley, CABuilt 1976 · S/N 17702464N418DBNewton Thomas L Jr · Fredericksburg, VABuilt 1974 · S/N 6737N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197N418RLChant Andrew P · San Francisco, CABuilt 2004 · S/N RG002N418SRegistered aircraftBuilt 2001 · S/N 60121N418SLLagergren Steven R · Litchfield, MNFirst renewal noticeBuilt 2011 · S/N 70419N418TJFive Star Family Aviation LLC · Yorkville, ILBuilt 1977 · S/N 28-7890086N418WKMenger Charles C Jr · Wills Point, TXBuilt 2002 · S/N 20735N41901Specht Gilbert E · Downs, KSBuilt 1974 · S/N 28-7405148N41904Gjertsen John W · Quincy, CABuilt 1974 · S/N 28-7425294N41905Rodgers Phillip L · Williford, ARBuilt 1974 · S/N 28-7415353N4190ZWinn Derek H · Joseph, ORBuilt 1966 · S/N 18-8374N4191JVillalba Raymond · Katy, TXBuilt 1966 · S/N 28-22531N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N41927Budziejko David C · Williamsville, NYBuilt 1974 · S/N 28-7415360N4192XYoblinski Robert J · Boone, NCS/N 5192N4192YDragon Grass LLC · Nashua, NHS/N 966-77N4192ZSwanson Amos W · Palmer, AKBuilt 1966 · S/N 18-8379N41937Calumet Aero LLC · Crown Point, INBuilt 1974 · S/N 28-7415365N41940Moughty Matthew · New Haven, VTS/N 28R-7435228N41949Ferg Robert B · New London, WIBuilt 1974 · S/N 28-7425301N41954Up And Up Aviation LLC · Magnolia, TXBuilt 1974 · S/N 28-7415368N41963Schafer Gary L · Greenwood, DEBuilt 1974 · S/N 28-7425302N41966Wray Jimmy Don · White House, TNBuilt 1974 · S/N 28-7425303N41967Krog Steven L · Hartford, WIBuilt 1974 · S/N 28-7415370N41969Lazy 8 Aviation LLC · Arden, NCBuilt 1974 · S/N 28-7415371N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N41973Legacy Aviation LLC · Murfreesboro, TNS/N 28-7405155N41977Augusti Group Enterprises Inc · Clayton, NCBuilt 1974 · S/N 28-7415375N41978Henderson Jason E · Corona, CABuilt 1974 · S/N 28-7415376N4197ZBurns Barry D · Amarillo, TXS/N 18-8389N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157
Back to AD 80-04-03 R2