OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N9698WCas Ltd · Swanton, VTBuilt 1967 · S/N 28-23171N9699JTrevino Alberto O · Vero Beach, FLBuilt 1967 · S/N 28-3888N9699VPiercy Danille Marie · North Bay Village, FLBuilt 1974 · S/N 17264478N969DBBristol David W · Sautee Nacoochee, GABuilt 1969 · S/N 28-26197N969GFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 0486N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547N969RAFox Valley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-317N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850N969SDThompson James R · Warren, OHS/N 28-7225045N969TTSmoketown Flight Center LLC · Smoketown, PABuilt 1973 · S/N 17261635N96ANCostabile Gregg D · Baker, FLBuilt 1996 · S/N 24497N96AWPlanenutz LLC · Deland, FLBuilt 1966 · S/N 3289N96BTAnema Daniel W · Groveland, CABuilt 1996 · S/N 052N96DCVertical Horizon Aviation LLC · Sandown, NHBuilt 1960 · S/N 18-7284N96DTPierson Richard R · Galesville, WIBuilt 1978 · S/N 28-7990230N96ELJimenez-Cruz Juan C · Mayaguez, PRBuilt 1966 · S/N 28-3615N96EZBurk Ross · Casper, WYS/N 1321N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184N96GWStranberg Jonathan E · White Heath, ILBuilt 1996 · S/N 910N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30N96HGHawdon Neil J · Federal Way, WABuilt 2002 · S/N 357RN96JPMclean William E · Daleville, ALBuilt 2002 · S/N 1437N96KMijangos Adrian E · Mary Esther, FLBuilt 1977 · S/N 28-7725269N96LJHiller Alex T · Lake Orion, MIBuilt 1997 · S/N 737N96MKKukulski Michael · Grayslake, ILBuilt 1998 · S/N 1811N96PCMurphy Walter · Sparks, NVBuilt 1999 · S/N GS-5482N96RLLewair Flight Solutions LLC · Brighton, COBuilt 2000 · S/N 22923N96RSTarpley Tim · Dallas, ORBuilt 1999 · S/N 24749N96SCLarson Richard A · Lawndale, CABuilt 1989 · S/N 1809032N96SEHeinlein Stephen · Johns Island, SCBuilt 2000 · S/N 001N96TBBeattie Thomas B · Vacaville, CABuilt 1976 · S/N 28-7690144N96TJJohnson Thomas R · Costa Mesa, CABuilt 2003 · S/N 23657N96UEkstrand Marshall C · Lake Stevens, WABuilt 1974 · S/N S1AN96VAJak Real Estate LLC · Gorham, MEBuilt 1973 · S/N 28-7415052N96VETrost Peter K · San Diego, CABuilt 1996 · S/N 003-1095N96WGMartin David · Albertville, ALBuilt 2003 · S/N 24952N96WHHood William E · Dover, NCBuilt 1996 · S/N 1N9700CCaldwell Stephanie Trustee · New Middletown, OHS/N 25N9700HBrutko Barry J · Lebanon, PABuilt 1975 · S/N 17266323N9700LJet Aviation LLC · Commerce Township, MIBuilt 1971 · S/N MB-506N9700VStencel Lawrence E · Palm Coast, FLBuilt 1974 · S/N 17264479N97019Mccreery Aviation Co Inc · Mcallen, TXBuilt 1984 · S/N 17276146N9701DCharles Benjamin L · Willow, AKBuilt 1959 · S/N 22-6612N9701UStearns Edwin B Jr · Eloy, AZS/N AA5A-0101N9701WGlougie Robert M · Fresno, CABuilt 1967 · S/N 28-23175N9702CToledo Flying Club Inc · Toledo, WABuilt 1978 · S/N 28-7816519N9702DAdams Carl B · Albuquerque, NMBuilt 1959 · S/N 22-6613N9702LFlying Dreams One LLC · Louisville, KYBuilt 1986 · S/N 17276600N9702PHall Charles R · Ennis, MTBuilt 1975 · S/N 18-7509134N9702ULyons William S IV · Castle Rock, COBuilt 1976 · S/N AA5A-0102
Back to AD 79-10-03 R2