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.

N9560VRegistration Pending · Big Spring, TXRegistration pendingBuilt 1974 · S/N 17264362N9561CRak Flight Squad LLC · Bronx, NYBuilt 1978 · S/N 28-7816493N9561DHughey Randal P · Muskegon, MIBuilt 1958 · S/N 22-6478N9561JScarlet Aviation LLC · Jonestown, PAS/N 28-3692N9561LWalter Terrance A · Pinckney, MIBuilt 1974 · S/N AA5-0661N9561MAck & Co LLC · East Helena, MTBuilt 1967 · S/N 670106N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882N9562HL & W Aircraft Investments LLC · Homestead, FLBuilt 1975 · S/N 17266230N9562JPosnett William L III · Lexington Park, MDBuilt 1966 · S/N 28-3697N9562UFoote Peter S · Lockport, NYBuilt 1977 · S/N AA1C0061N9562VWinged Winds LLC · Douglassville, PABuilt 1974 · S/N 17264364N9562WHub City Aviation Academy LLC · Lubbock, TXBuilt 1967 · S/N 28-22999N9563LFite James · Victorville, CABuilt 1974 · S/N AA5-0563N9563PTodd Doug A · De Witt, IAS/N 18-7609155N9563WEastside Development Co Inc · Winfield, KSBuilt 1967 · S/N 28-23000N9564CPowell David K · Edwardsville, ILBuilt 1978 · S/N 28-7890422N9564HLafleur Laurence J · Natick, MABuilt 1975 · S/N 17266232N9564JIrvin Stephanie Michelle · Jacksonville, FLBuilt 1966 · S/N 28-3699N9565JNebeker Kayla Rae · Murrieta, CABuilt 1966 · S/N 28-3700N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885N9566DHerbert Brendan A · Portola, CAS/N 22-6483N9566HGarcia Mario · Yuma, AZBuilt 1975 · S/N 17266233N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578N9566VS D Enterprises Ltd · Brookhaven, NYBuilt 1974 · S/N 17264368N9567DFurois Alex D · Bridger, MTBuilt 1958 · S/N 22-6484N9567HCurley Mark L · Alamosa, COBuilt 1975 · S/N 17266234N9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationBuilt 1974 · S/N 17264369N9567WMiler Aaron L · Chambersburg, PABuilt 1967 · S/N 28-23005N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580N9568URegistration Pending · Bath, PARegistration pendingBuilt 1975 · S/N AA5A-0068N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006N95690Daly Arthur P · El Paso, TXBuilt 2004 · S/N 101N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235N956DCLefthalfplane LLC · Kalispell, MTBuilt 2004 · S/N 752EN956MAAllen William D · Tampa, FLBuilt 1966 · S/N 3431N956MDDigit Aviation LLC · Hampton, NHBuilt 1956 · S/N 18-4884N956TERaw Logistics LLC · Bethel, NCBuilt 2004 · S/N 10235N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707N9570UFranken Todd V · Martindale, TXBuilt 1975 · S/N AA5A-0070N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708N9571KOtter Fly LLC · Maricopa, AZS/N 28-7615213N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890
Back to AD 80-04-03 R2