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.

N921PCProppe Karl H · Needham, MABuilt 1992 · S/N 1809058N921SJDavis Brandon Grey · Huntsville, ALBuilt 2010 · S/N 20208N921TCBell Charles S · Fort Payne, ALS/N 23695N921UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3566N921WC7 Corp · Orlando, FLBuilt 1964 · S/N 2878N921XPLengler Aviation LLC · Fort Myers, FLBuilt 1962 · S/N 1905N922Tjk Enterprises LLC · Helena, MTBuilt 1977 · S/N 965-77N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9222SSvendsen James · Center Moriches, NYBuilt 1975 · S/N M-1718N9222VSoco Scuba LLC · Austin, TXS/N 690052N92236Garfoot William K · Verona, WIBuilt 1982 · S/N 0233N9223FMckeeman Kevin · Abilene, KSS/N 14039CN9223HHallock Robert C III · Sag Harbor, NYBuilt 1975 · S/N 17266024N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N92247World Class Aviation Ltd · Bellefontaine, OHS/N 14022CN9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9224VBevington Carl R · Middle Point, OHBuilt 1969 · S/N 690053N92255Kloker Daniel E · Owasso, OKBuilt 1973 · S/N 17261554N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297N9227MMullis Brent S · Garfield, GABuilt 1966 · S/N 3442N9227WMasterman Robert David · Chugiak, AKS/N 11097CN9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288N9228LRegistered aircraftBuilt 1993 · S/N 14024CN9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299N9229SRegistered aircraftBuilt 1975 · S/N M-1724N922CTSweptwing Holdings LLC · Houston, TXS/N 1064N922EAButler Ronald A · Cumming, GAS/N 17263921N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N92318Flitepro Inc · Murrieta, CAS/N 17261561N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562N9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305N9232RRogers Ricky R · Saint Francis, KSS/N 19003CN9232TSannella Joseph J · Missoula, MTS/N 19002CN9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056N9234ACruz Salvador A · Sumter, SCS/N 21001CN9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033C
Back to AD 80-04-03 R2