OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N6742WMidnight Flight LLC · Wells, TXS/N 28-20863N6743FHollywood Biplane LLC DBA · Atlanta, GABuilt 1976 · S/N 28-7715176N6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 17265562N6743JStader Noah M · Platteville, WIS/N 28-24459N6743NHollingsworth Michael J · Phoenix, AZBuilt 1968 · S/N 680059N6744UMelia Alexander A · Jacksonville, FLBuilt 1963 · S/N 170N6745JHerget Joshua N · Toulon, ILBuilt 1968 · S/N 28-24462N6745NGonzalez David · Hollywood, FLBuilt 1968 · S/N 680060N6745UBall Aaron J · Pocatello, IDBuilt 1963 · S/N 2467N6746JOn Short Final LLC · Marion, NCBuilt 1968 · S/N 28-24463N6746PCoppola Marc · Waretown, NJBuilt 1960 · S/N 24-1874N6747HAurora Skyhawks · Portland, ORS/N 17265564N6747NBolt Almos L Jr · Montgomery, TXBuilt 1968 · S/N 680061N6747PWindecker David · Englewood, FLS/N 24-1875N6747UDevuyst Richard C · Pampa, TXBuilt 1963 · S/N 2469N6747WBunn Benjamin D · Winchester, VABuilt 1965 · S/N 28-20871N6748HN6748h LLC · Palm Beach Gardens, FLBuilt 1975 · S/N 17265565N6748WCartanian Alfred F · Las Vegas, NVS/N 28-20872N6749BFinke Andy R · North Liberty, INS/N 22-4083N6749JSebesta Roman T · Brazoria, TXBuilt 1968 · S/N 28-24467N6749NFosburgh Kevin J · Las Cruces, NMBuilt 1968 · S/N 680062N674ETTaylor Erik A · Montgomery, ILBuilt 1989 · S/N 1934N674FLBackyard Aero LLC · Rockville, INBuilt 1971 · S/N 28-7125602N674RGTech Heli LLC · Fort Lauderdale, FLBuilt 1998 · S/N 2885N6750HPickett Michael R · Gig Harbor, WABuilt 1975 · S/N 17265566N6750JAmin Kirit · Lansdale, PABuilt 1968 · S/N 28-24469N6750UFischer James C · Falls City, NEBuilt 1963 · S/N 2472N6750WNelson Laura Leigh · Gastonia, NCBuilt 1965 · S/N 28-20874N6751BCook Harry F · Sequim, WABuilt 1956 · S/N 22-4085N6751JJones James L · White Hall, ARBuilt 1968 · S/N 28-24470N6751NParr Matthew R · Wellsville, PABuilt 1968 · S/N 680065N6751PGette Jason D · Kindred, NDS/N 24-1880N6752JHutchins James R · Columbia, SCBuilt 1968 · S/N 28-24474N6752ULucarelli Michael · Surprise, AZBuilt 1963 · S/N 2474N6752ZVector USA LLC · Olive Branch, MSBuilt 1981 · S/N ME-340N6753BThorpe Brandon · Bremerton, WABuilt 1956 · S/N 22-4087N6753JSpieth John W · Ann Arbor, MIBuilt 1968 · S/N 28-24475N6753NHarmon Benjamin P · Olive Branch, MSBuilt 1968 · S/N 680067N6754NCasady David E · Harriman, TNBuilt 1968 · S/N 680068N6755BTwotards Aviation LLC · Moses Lake, WABuilt 1956 · S/N 22-4089N6755JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1968 · S/N 28-24478N6755PHensler Carl P · Watsonville, CABuilt 1960 · S/N 24-1884N6755WAeroqualite Maintenance · Cumberland, WIBuilt 1965 · S/N 28-20879N6756BNortheast State Community College · Blountville, TNBuilt 1980 · S/N M-2276N6756JAmv Aviation LLC · Miami, FLBuilt 1968 · S/N 28-24479N6756UBergland John E · Santa Monica, CABuilt 1963 · S/N 2478N6756WTrollinger Lari D · Wanette, OKBuilt 1965 · S/N 28-20880N6757BStuart Lee L · Smithville, ARBuilt 1956 · S/N 22-4091N6757NCoody John A · Idaho Falls, IDBuilt 1968 · S/N 680071N6757UScherger Mark A · Herndon, VABuilt 1963 · S/N 2479
Back to AD 79-10-03 R2