OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N3636TFortier Stanley · Chico, CAS/N EA-18N363JVRead Andrew R · Milwaukee, WIBuilt 1976 · S/N 18502991N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143N363RMankind Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E-97N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N363SCOcm Aviation LLC · Buckeye, AZBuilt 2004 · S/N 1209N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148N364AU364au LLC · Ames, IABuilt 2014 · S/N E-4031N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BSHusky 89 LLC · Bethany, OKBuilt 2007 · S/N E-3786N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364EMountain Desert Aviation LLC · Lake Havasu City, AZBuilt 2010 · S/N E-3944N364ELFiorini Randy · Turlock, CABuilt 1988 · S/N CE-1268N364EMSafeco Leasing LLC · Port Alsworth, AKBuilt 1968 · S/N E-56N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364MWUpwind Approach LLC · Lisle, ILS/N E-3651N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WPPorter Flying Service · Durham, CAS/N E-1914N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N365ACEvalidate LLC · Birmingham, MIBuilt 1988 · S/N EA-479N365FCRegistration Pending · Kalispell, MTRegistration pendingBuilt 1973 · S/N 18502233N365HStavair LLC · Gulf Breeze, FLBuilt 1965 · S/N TC-843N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N365SBClear Skys LLC · O Fallon, ILBuilt 2013 · S/N E-4010N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1369N366DMSwaggart Paul Blake · Touchet, WABuilt 2005 · S/N 1625N366HPRey Del Cielo LLC · San Antonio, TXBuilt 1974 · S/N E-632N366PSkyway Unlimited Inc · New London, NCBuilt 1997 · S/N E-3099N366PSA-Team Family LLC · Ashland, ORBuilt 1974 · S/N TE-971
Back to AD 86-13-04 R3