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.

N400SDLeonard Tyler D · Newbury Park, CABuilt 1996 · S/N 3612N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105N4010BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1418MN4010ZDickey Livestock Inc · Mackay, IDBuilt 1963 · S/N 18-7961N4011EFredericks Harry III Trustee · Woodland, CAS/N 1385N4011PWelke Paul R · Beaver Island, MIBuilt 1958 · S/N 23-1486N4012FNational 967.LLC · Rock Hill, SCBuilt 1976 · S/N 28-7725001N4012TStull Joshua S · Tacoma, WABuilt 1968 · S/N M-1119N4012ZHronkin Jesse G · Palmer, AKBuilt 1963 · S/N 18-7963N4013ERogers Twyla M · Windham, MEBuilt 1977 · S/N 18-7809018N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430N4013XN4013x LLC · Great Falls, MTS/N 5113N4014EMoriarty Gerald Joseph · Anchorage, AKBuilt 1978 · S/N 18-7809019N4014PGriffing Flying Service Inc · Port Clinton, OHBuilt 1958 · S/N 23-1489N4014XFournier Ronald A · San Diego, CAS/N 5114N4015TBauries Brian W · Abilene, TXBuilt 1968 · S/N M-1122N4016ZLong Island Soaring Assoc · Yaphank, NYBuilt 1963 · S/N 18-7966N4017EJelinek Ed · Denton, MTBuilt 1977 · S/N 18-7809021N4017FHansen Drew A · Miami Springs, FLBuilt 1976 · S/N 287715002N4017P17p LLC · Caddo Mills, TXS/N 23-1492N4017ZB4b Co · Ridgeview, SDBuilt 1963 · S/N 18-7968N4018EWilliams Matthew S Trustee · Anchorage, AKBuilt 1977 · S/N 18-7809040N4018TMalfaro William J · Boyertown, PABuilt 1968 · S/N M-1125N4019XBoswell Joey L · Comanche, TXBuilt 1969 · S/N 5119N4019ZPercy Nolan C · Saint Francisville, LAS/N 18-7971N401BJJohnson William L · Union City, INS/N 1N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063CN4020XCox Nathaniel E · Ocala, FLBuilt 1970 · S/N 5149N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972N4022ZKahn Steven H · Port Alsworth, AKBuilt 1963 · S/N 18-7974N40230Harris Dan C · Rockford, TNS/N 1470N40234Mallow David N · Rio, WVS/N 18-7509115N40238Blue Ridge Community College · Weyers Cave, VAS/N 1474N4023FFreese Barry L · Leonardtown, MDBuilt 1976 · S/N 28-7715003N4023XRhodes Stephen · Marion, NCBuilt 1969 · S/N 5123N4023ZLunenschloss Michael L · Anchor Point, AKBuilt 1963 · S/N 18-7975N40246Harper Matthew C · Anchorage, AKBuilt 1975 · S/N 18-7509118N4024JKeleti Laurie · Lakewood, NJBuilt 1975 · S/N 28-7525271N4024XFaussett Thomas J · Greenville, MIS/N 5124N4024ZBrown Timathy S · Wasilla, AKBuilt 1963 · S/N 18-7977
Back to AD 79-10-03 R2