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.

N236GDimartino Richard · Port Jefferson, NYBuilt 2005 · S/N E-3638N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399N236JPLauderdale Thomas J · Bates City, MOBuilt 1970 · S/N E-211N236LLaux Air LLC · Missoula, MTBuilt 2004 · S/N 0810N236LLFrenjc LLC · Sedona, AZBuilt 2002 · S/N L2K-158N236MCameron Mark D · Alpine, WYBuilt 1965 · S/N 292N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020N236WBt1 Air LLC · Grover Beach, CABuilt 2002 · S/N E-3432N23714Dyk Aviation LLC · Williston, NDBuilt 1978 · S/N E-1206N23717Advanced Helicopter Services · Woodland, CABuilt 1978 · S/N E-1208N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N23724Zhang Harvest Land · Moraga, CABuilt 1978 · S/N E-1211N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N23752Talton David S · Tupelo, MSBuilt 1978 · S/N E-1215N23753Lifestyle Aviation LLC · Dallas, TXBuilt 1978 · S/N CE-762N23757Walinchus Robert E · Pooler, GAS/N CE-731N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257N2377CCooper Capital Specialty Salvage LLC · Old Saybrook, CTBuilt 2024 · S/N E-4156N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577N237MArdizzone Mark R · Mckinney, TXBuilt 1965 · S/N 293N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581N23822Platt James Wesley · Bushnell, FLBuilt 1977 · S/N E-1089N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587N238ARN238ar LLC · Hickory, NCBuilt 2002 · S/N 0346N238CDHerega Mark Allen Sr · Brick, NJBuilt 2002 · S/N 0359N238DSRegistration Pending · Plainwell, MIRegistration pendingBuilt 1987 · S/N CE-1146N238SAJmm Capital LLC · Fort Worth, TXBuilt 2000 · S/N E-3321N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596N2398FHorizon Flying LLC · Wilmington, DEBuilt 1965 · S/N 21058598N2399FJordan Danny L · Medford, ORBuilt 1965 · S/N 21058599N239AJBb239aj LLC · Greenville, MIBuilt 2016 · S/N E-4090N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808N239MWatkins Douglas · Yuba City, CABuilt 1965 · S/N 294N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834N23AZNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 18502499N23CCMadrid Jorge M · Tucson, AZBuilt 1967 · S/N 185-1236N23CFYr-Aircraft Leasing LLC · Bethel, AKBuilt 1974 · S/N 20700276N23CLRsr Medical Inc · Wilmington, DEBuilt 1995 · S/N E-2969
Back to AD 86-13-04 R3