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.

N94SBBernatz Gerald F · Highland, ILBuilt 1994 · S/N 22194N94SJMoe Alan D · North Bend, ORBuilt 1988 · S/N 01N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814N94VFPenhorwood Joshua M · Shubuta, MSBuilt 1994 · S/N 809N94WDRegistration Pending · Sugar Grove, ILRegistration pendingS/N 1849N94WGAltruda Thomas Joseph · Las Vegas, NVBuilt 2005 · S/N 4273N94XTaylor Samuel R · Kenai, AKBuilt 1962 · S/N 18-7858N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775N9500DFlight Club LLC · Anchorage, AKBuilt 1958 · S/N 22-6415N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620N9500LAtlantic Aero Club Inc · Newark, DEBuilt 1972 · S/N AA5-0100N9500WRachel Calvin · Kimberly, ALS/N 28-22921N9501DBelof Joshua · Franklin, NCBuilt 1958 · S/N 22-6416N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182N9502WHellevang Ryan K · Duvall, WAS/N 28-22924N9503DHardison Allan · Castle Rock, COS/N 22-6418N9503WLoya Armando · Whittier, CAS/N 28-22925N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783N9504DWilliams Jimmy Z · Sherman, TXBuilt 1958 · S/N 22-6419N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788N9505DJutzi Curtis E · Ridgefield, WABuilt 1958 · S/N 22-6420N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626N9505LClark Gabrial Scott · Humble, TXBuilt 1972 · S/N AA5-0105N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798N9507DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6422N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508DLewis Stephen A III · Fleming, GABuilt 1958 · S/N 22-6423N9508JGandas Aero Inc · Eagan, MNS/N 28-3629N9509DMorrison Jim · Grandview, TXBuilt 1958 · S/N 22-6424N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633
Back to AD 80-04-03 R2