OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N828CCoriolis Inc · Brooklyn, NYBuilt 2002 · S/N 0396N828DSOhlsson Kenneth S Trustee · Sedona, AZBuilt 1976 · S/N E-847N828DTTspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1648N828ECPrescient Aviation LLC · Los Angeles, CAS/N 1200N828KASvehla Gustav Jr · Flower Mound, TXBuilt 1990 · S/N CE-1512N828KMSjr Holdings LLC · Raleigh, NCBuilt 2001 · S/N TH-1999N828KPKapa International · Santa Monica, CABuilt 2005 · S/N 1456N828PMRobinson Shannon D · Fair Oaks Ranch, TXBuilt 1987 · S/N 4608057N828RJNielsen Ron E · Lindon, UTS/N 21063836N828SBEa Aircraft Lease LLC · Dayton, MNS/N EA-111N828TFryar Arliss E · Pollock, LABuilt 1976 · S/N E-941N828TATravelaire Service Inc · Wilmington, DEBuilt 1973 · S/N 18502245N828TMTaylor Aero LLC · Lewes, DEBuilt 2004 · S/N 0943N828TTLoud LLC · Carthage, NCBuilt 1994 · S/N TH-1729N828VJames David O · Overland Park, KSBuilt 1976 · S/N E-883N82903Nms Air Services LLC · Chelmsford, MABuilt 1993 · S/N CE-1740N8290EWb Aviation LLC · Belmont, MIBuilt 1993 · S/N E-2805N8290RHunt George Richard · Bakersfield, CABuilt 1972 · S/N 30481N8290ULets Fly LLC · Fortson, GABuilt 1993 · S/N TH-1688N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8292QFitzgerald John A Jr · Ester, AKS/N 18503643N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N82964Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1761N82966Big Bend Community College · Moses Lake, WABuilt 1993 · S/N CE-1757N8296GKiehl Austin J · Winnett, MTBuilt 1973 · S/N 18801293N8298HC & L Leasing LLC · Cody, WYBuilt 1993 · S/N CE-1741N8299GHoughtaling Richard P · Harwich, MABuilt 1993 · S/N CE-1749N8299RAde Doug · Frederick, OKBuilt 1972 · S/N 30457N8299ZCoachair Inc · Groveland, CABuilt 1993 · S/N EA-545N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N829CGRegistered aircraftBuilt 1986 · S/N 4608029N829EDiaz Maria · Kansas City, MOS/N 401A0014N829GWin Win Aviation Inc · Wake Forest, NCBuilt 1967 · S/N TE-379N829MJHaldopoulos Aviation LLC · Zephyr Cove, NVBuilt 2018 · S/N E-4126N829MRC&R Systems Inc · Bryan, TXBuilt 2008 · S/N TH-2237N829RRaby Ron A · Portsmouth, NHBuilt 2005 · S/N ES-163N829TN829t LLC · Ellenton, FLBuilt 1964 · S/N CD-821N829WBlue Sky Transport LLC · Deland, FLBuilt 2005 · S/N 1407N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064N82BVetted Air LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2663N82BFMorrison James M III · Terry, MSBuilt 1981 · S/N E-1937N82BTTonner Brian P · Fernandina Beach, FLBuilt 2004 · S/N 97153N82CFKehler Kelly · Saint Xavier, MTBuilt 1975 · S/N TE-1061N82CKBloxham Thomas L · Pleasant Hill, CABuilt 1997 · S/N E3096N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463N82HCVan Buskirk Steven · Denver, COBuilt 1974 · S/N D-9584N82HRHarris Farms Inc · Coalinga, CABuilt 2020 · S/N E-4141N82JGTotal Aircraft Management Inc · Acworth, GABuilt 1968 · S/N TE-626N82JTRegistered aircraftBuilt 1964 · S/N D-7581N82LBLakeland Aircraft Maintenance LLC · Lakeland, FLBuilt 1978 · S/N TH-910
Back to AD 86-13-04 R3