OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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:79-10-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:79-10-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.

N3059BBay 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 17701387N30658Mcmahan Jerry · Watson, ARBuilt 1940 · S/N 5-228N3065CVenture West LLC · Mesa, AZBuilt 1978 · S/N 28-7990152N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425N30661Feiler Joe · Casper, WYBuilt 1969 · S/N 17701389N30663Kroeker Bryan S · Grant, NEBuilt 1969 · S/N 17701391N30668Elevation Aviation LLC · Mccomb, MSBuilt 1969 · S/N 17701394N3066GAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7990197N3066HLarsen Mark S · Spencer, IABuilt 1978 · S/N 28-7916219N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984N3066YQuiett Aaron Trustee · Hillsboro, ORS/N 28-7990392N30670Brown Thomas E · Trenton, GABuilt 1969 · S/N 17701395N30671Foster Milton F · Dawson, GABuilt 1969 · S/N 17701396N30673Cardinal Flyers Inc · Sault Sainte Marie, MIBuilt 1969 · S/N 17701397N3067DLawson Roger E · Elizabethtown, KYBuilt 1978 · S/N 28-7916159N30680Smith Ronald D · Anderson, INBuilt 1969 · S/N 17701401N30685Blanchette George · Longwood, FLBuilt 1969 · S/N 17701404
Back to AD 79-10-03 R2