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.

N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332N3056ARegistered aircraftBuilt 1953 · S/N 25700N3056ZPopson LLC · Peachtree City, GABuilt 1979 · S/N 28-7990412N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333N30571Spencer Burton D · Mchenry, ILS/N 17701334N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293N3057PMcneil Michael D · Caro, MIS/N 23-969N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093CN30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513N30603Registered aircraftBuilt 1969 · S/N 17701353N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370N30612Wheeler Vincent · Harwinton, CTBuilt 1969 · S/N 17701360N30615Yanichko Robert · Weeki Wachee, FLBuilt 1969 · S/N 17701362N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388N3061ZKell Thomas G · Anchorage, AKS/N 22-7016N30622Money Aerial Media LLC · San Diego, CABuilt 1940 · S/N 5-223N30626Hoese Ray D · San Antonio, TXBuilt 1969 · S/N 17701368N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017N30630Erickson Keith E · Anchorage, AKS/N 17701369N30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeBuilt 1969 · S/N 17701371N30634Beck Alan · Las Vegas, NVBuilt 1969 · S/N 17701372N30636Schub William C · Oakdale, NYBuilt 1969 · S/N 17701373N30637Diamond Paul · Londonderry, NHBuilt 1969 · S/N 17701374N30639Madden Michael A Trustee · De Pere, WIBuilt 1969 · S/N 17701375N3063PWillis William P Trustee · New Palestine, INS/N 23-981N3063ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7018N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150N30647Registration Pending · Diamondhead, MSRegistration pendingBuilt 1978 · S/N 28-7816545N3064ZReichlin Richard S · Traverse City, MIBuilt 1959 · S/N 22-7019N30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILBuilt 1978 · S/N 28-7916089N30654Eagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701386N30656Vance Matthew Austin · Decatur, GABuilt 1969 · S/N 17701387
Back to AD 80-04-03 R2