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.

N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420N8216PBobbitt Aviation LLC · Edenton, NCBuilt 1960 · S/N 24-2219N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349N82172Wadekamper Leo V · Helena, MTBuilt 1979 · S/N 18-7909064N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335N8218Kornegay Patrick C · San Benito, TXBuilt 1982 · S/N 18-8209005N82188Kubecka Daniel P · Edna, TXBuilt 1979 · S/N 18-7909068N8218CStargazer Aviation LLC · Clearwater, FLBuilt 1975 · S/N 28-7615081N8218NLee David · Palm Springs, CAS/N 28-25548N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320N82196Flying W Ranch Jv · Cooperstown, NDBuilt 1979 · S/N 18-7909070N8219WA18 Missions LLC · Clinton, MOBuilt 1965 · S/N 28-2352N821BERas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816398N821BFDehn Timothy E · Braham, MNBuilt 2004 · S/N 90793N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247N821KCIreland Robert D Jr · Gulf Breeze, FLBuilt 1972 · S/N AA5-0121N821LLindrooth Steven A · Perkasie, PABuilt 1976 · S/N AA5B0333N821PCJones Clark L · Cave Creek, AZS/N 18-8031N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485N821SHAero Leasing Inc · Brookings, ORBuilt 2005 · S/N 3774N82209Pearl Darwyn L · Bend, ORBuilt 1978 · S/N 18-7809153N82213Anderson Stephen A · Yuba City, CABuilt 1979 · S/N 18-8009031N8221NFedchenko Vitaliy · Cumming, GABuilt 1969 · S/N 28-25425N82221Hahn Dave · Brooklyn Park, MNBuilt 1980 · S/N 28-8090323N82225Dow Clifford G II · Falmouth, MEBuilt 1979 · S/N 18-7909072N82226Plane & Pilot News · Ravenna, OHBuilt 1980 · S/N 28-8090324N8222DPaphos Airways LLC · Farmingdale, NYBuilt 1980 · S/N 28-8016337N8222FJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8016338N8222HBartek Matthew S · Wylie, TXBuilt 1980 · S/N 28-8016339N8222JShvetsov Vitaly S · La Canada Flintrid, CABuilt 1980 · S/N 28-8016340N8222WMitzel Aaron · China Spring, TXBuilt 1965 · S/N 28-2355N8222YMorale Line Aviation LLC · Albuquerque, NMBuilt 1980 · S/N 28-8090322N82236Ingle Nicholas A · Cora, WYBuilt 1979 · S/N 18-7909079N8223NEvans Jay M · Arrington, TNBuilt 1969 · S/N 28-25427N8223TTrident Aircraft Leasing LLC · Easton, MDBuilt 1982 · S/N 28-8216170N82241Naranjo Navarro Jose N · Las Vegas, NVS/N 28-8390018N8224KPelayes Tristan · Temecula, CABuilt 1982 · S/N 28-8216171N8224NDc Aviation LLC · Appleton, WIBuilt 1969 · S/N 28-25429N8224WDavis William M · Chattanooga, TNBuilt 1965 · S/N 28-2357N82253Dirt Strip Dirtbags LLC · Whitefish, MTS/N 18-7909082N82259Pedersen Eric D · Mccall, IDBuilt 1979 · S/N 18-7909084N8225UNagy John F · Whittier, CABuilt 1982 · S/N 28-8290143N8225VRunge Thomas A · Sterling, VABuilt 1982 · S/N 28-8290144N8225WLewis Devin H · Lacey, NJBuilt 1965 · S/N 28-2359N8226HForward Jeffrey C · Oakes, NDS/N 28-8090114N8226VParchman Travis R · Philadelphia, PABuilt 1980 · S/N 28-8016344N82274Harris James M · Bemidji, MNBuilt 1979 · S/N 18-7909087
Back to AD 79-10-03 R2