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.

N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089N2143AUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 44-7995085N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950N2145FSmith Jeffrey D · Hamilton, GAFirst renewal noticeBuilt 1972 · S/N AA5-0017N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830N214AALewis University · Romeoville, ILS/N 28-4735N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007N214ERLima-001 LLC · Muscatine, IAS/N 17263480N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138N214LHRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2005 · S/N 494-2005N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053N214LPKrasa Paul W · Yorktown, VAFirst renewal noticeBuilt 1999 · S/N 214KRN214NYCabco Enterprises LLC · Springdale, ARS/N 899N214PTNewkirk Peter C · Ellison Bay, WIBuilt 1990 · S/N 2039N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N214RBS And S 1165 Investments LLC · Wimberley, TXBuilt 1992 · S/N 2114N214SANeagle Jason S · Elizabethtown, KYS/N 28-7415482N214YRutigliano Peter J · Harrington Park, NJS/N MB1N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055N2150AAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-1862N2150ELeuer Nicholas J · Emmetsburg, IABuilt 1978 · S/N 17271170
Back to AD 79-10-03 R2