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.

N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579N1921Koons Zachary K · Clinton, ILBuilt 1993 · S/N 20580N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819N1922PNey N Marshall · Kapaau, HIS/N 22-2673N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169N1924YHull Thomas · Midland, TXS/N 219N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017N1926PHoudek Dennis E · Roseburg, ORBuilt 1955 · S/N 22-2677N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019N192ACByrd Ronald D · Farwell, TXBuilt 1994 · S/N 1203-95N192ARDj Whelan Corp · Sag Harbor, NYBuilt 1978 · S/N 17272016N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374N192MHHolland James Michael · Fort Collins, COBuilt 2005 · S/N 90556N192RDisarro Wayne · Ketchikan, AKBuilt 2003 · S/N RK 100 1N192RKWeber Martin Trustee · Marthasville, MOBuilt 1992 · S/N 1854N192VDefenbaugh Matthew J · Biggsville, ILBuilt 1999 · S/N 22107N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828N1930TWing John · Fort Worth, TXS/N 28-7125442N1930UGazzano Leonard S Trustee · Yerington, NVBuilt 1999 · S/N 1930N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798N1931TFordham Scott · Sag Harbor, NYBuilt 1975 · S/N AA50744N1931VRegistered aircraftBuilt 1974 · S/N 17263799N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589N1932VFarmland Aviation LLC · Glenwood, IABuilt 2005 · S/N 84232N1932ZSpencer David E · Woodville, ALBuilt 2015 · S/N 001N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023N1933HBlock Andrea · Chandler, AZS/N 28-7725170N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151N1933WHanson Garrick D · Clayton, NCS/N MB-597N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065N1934PProulx Michael G · Westhampton, MABuilt 1955 · S/N 22-2685
Back to AD 79-10-03 R2