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.

N2117FHelms Stephen · Anchorage, AKBuilt 1964 · S/N U206-0317N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918N2118SAbes Erika · El Paso, TXBuilt 1975 · S/N 21061081N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759N211AA1776 Aviation LLC · Kalispell, MTBuilt 1976 · S/N TE-1078N211ASBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 20700259N211ATGeorge'S Aerial Spraying Service Inc · Sutton, NEBuilt 1971 · S/N 18800834N211AWWeis Aaron · Waban, MABuilt 2005 · S/N 1278N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013N211CMMoneypit Investment Corp · Wilmington, DEBuilt 2005 · S/N 1692N211DGSteel Crazy LLC · Page, AZFirst renewal noticeBuilt 1989 · S/N EA-489N211EBGarrard Mark E · Reno, NVBuilt 1968 · S/N TE-656N211EEV35a Speedsters LLC · Henderson, COBuilt 1968 · S/N D-8888N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364N211MJKeefer Squared LLC · Rockmart, GABuilt 1994 · S/N 29-0019N211MVClark Aviation Inc · Greenville, SCBuilt 1999 · S/N E-3244N211MWGoad Jerry A · Oneida, TNBuilt 1973 · S/N TE-923N211PAPiedmont Air Services LLC · Helena, MTBuilt 1981 · S/N U20606415N211SSherrifs Office Kane County Utah · Kanab, UTBuilt 1985 · S/N U20606916N211SVMatthews Aviation LLC · Greensboro, NCS/N 340A1000N211SWOrion Aviation LLC · Jeffersonville, INBuilt 1977 · S/N 18503327N211TCMayer William P · Anchorage, AKS/N 185-1380N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754N211YRegistered aircraftBuilt 1966 · S/N TE-169N211ZNAllen Michael J · Rescue, CABuilt 1985 · S/N 24-1535N2120FWare Brandie W · Nikiski, AKS/N U206-0320N2120XGolberg Companies Inc · Garfield, MNBuilt 1996 · S/N 29-0103N21218Street Raymond E Jr Trustee · Palmer, AKBuilt 1976 · S/N 18503051N2121SGreat Bay Aviation LLC · Spring Hill, FLBuilt 1997 · S/N 29-0106N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084N2122UAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800672N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207N2123LPanther Air LLC · Alameda, CABuilt 1976 · S/N E-886N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913N2126SGarnet Ridge LLC · Brooksville, FLS/N 29-0133N2127FBrice Adam R · Camas, WAFirst renewal noticeBuilt 1964 · S/N U206-0327N2129FStewart Madison F Co Persona Representative · Broken Arrow, OKBuilt 1965 · S/N U206-0329N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995N212DARegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N U20601901N212DEWerre Joel F · Dunn Center, NDS/N EA-626N212GBSooner Farms LLC · Siloam Springs, ARBuilt 1975 · S/N 21061130N212GWTim D Wilson Investigations Inc · Hempstead, TXS/N TE-494N212HRExport Aviation LLC · Santa Fe, NMS/N T30300239N212KTLanier Howard W · Willis, TXS/N P206-0349N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209N212MMOlver Keith B · Annapolis, MDBuilt 2002 · S/N 0403N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604N212RJBishop Mike · Rifle, COBuilt 1964 · S/N D-7467
Back to AD 86-13-04 R3