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.

N2371TThomas Jacob W · Loris, SCS/N 28-7225056N2371WSpaich Brad G · Mcpherson, KSBuilt 1966 · S/N MB-9N2372JSea Serpent Tours Inc · Saint Augustine, FLS/N M-336N2372QBlack Stephen L · Winterset, IABuilt 1963 · S/N M-445N2372SChristensen Robert F · Gillette, WYBuilt 1979 · S/N 18-7909138N2372WHulme Aviation LLC · Gilbert, AZBuilt 1966 · S/N MB-10N2373JHilker David E · Cimarron, KSBuilt 1979 · S/N 18-7909113N2373TNeuharth Randall H · Norfolk, NEBuilt 1971 · S/N 28-7225003N2374TFlying High Investments LLC DBA · Winnemucca, NVBuilt 1971 · S/N 28-7225017N2374ZSale Reported · Fort Worth, TXSale reported, canceledBuilt 1962 · S/N M-98N2375LEdgren Alan J · Punta Gorda, FLBuilt 1963 · S/N M-223N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280N2375PKirsteatter Todd · Kewaunee, WIBuilt 1955 · S/N 22-2766N2375QTaxes Suck LLC · Orlando, FLBuilt 1963 · S/N M-449N2375ZMorrissett Jay Dean · Bumpass, VABuilt 1962 · S/N M-99N2376Moore Charles D · Willow, AKBuilt 1992 · S/N 2062N2376JWinstead Jonathan M · Griffin, GABuilt 1963 · S/N M-339N2376LRbg Aviation LLC · Middleburg, FLBuilt 1963 · S/N M-212N2376PBoyd Paul E · North Pole, AKBuilt 1955 · S/N 22-2767N2376QEisenmann James R · Fort Worth, TXBuilt 1963 · S/N M-450N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256N2377LBarnes Matthew · Cost, TXS/N M-217N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021N2378Suridutch Inc · Englewood, FLBuilt 1992 · S/N 2066N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102N2379KEast Bay Inc · Stanton, MNBuilt 1979 · S/N 18-8009054N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179N237BMarcum William N · Corpus Christi, TXBuilt 2003 · S/N 60070N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230N237HYZeus Flight LLC · Ketchum, IDBuilt 2003 · S/N 2237N237LSSouth Florida Ultralights Inc · Mulberry, FLBuilt 2020 · S/N 21242N237MLN237ml LLC · Glennallen, AKS/N 18-6787N2380Atlantic Rotors LLC · Saint Inigoes, MDBuilt 1992 · S/N 2070N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771N2380TRegistered aircraftS/N 28-7225060N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774N2383WMcclure Miles · Vancouver, WAS/N MB-18N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342N2384PLarsen Steve J · Colton, ORS/N 22-2775N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184
Back to AD 80-04-03 R2