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.

N99VK421 Golden Eagle LLC · Cheyenne, WYBuilt 1969 · S/N 421A0091N99VMDaniel M Skotte Do Pc · Sunriver, ORBuilt 1980 · S/N EA-140N99WGWilson Norman · Mount Pleasant, TXBuilt 1978 · S/N 210-62618N99WPMarco Investments · Ripley, MSBuilt 1978 · S/N TH-958N99YFAspire Partners LLC · Evansville, INBuilt 1968 · S/N U2060940N99YSAirspeed And Money LLC · Coweta, OKBuilt 1968 · S/N E-82N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608N99ZXCecil Geoffrey · Punta Gorda, FLBuilt 1973 · S/N D-9530N9ABFirst Alarm Aviation LLC · Fosters, ALBuilt 1978 · S/N D-10175N9APWellsville Flying Service Inc · Wellsville, NYS/N 27-7305129N9AYProclaim Aviation Ministries · Worthington, MNBuilt 1980 · S/N 421C0844N9BMMahanor Joseph P · Spring City, PABuilt 1955 · S/N BG-117N9BNBrookfield Bonanza Corp · Menomonee Falls, WIBuilt 1982 · S/N E-2046N9DNMaxs Airplane LLC · Plano, TXBuilt 1973 · S/N D-9550N9DVNorwood Ronald Steven · Raleigh, NCBuilt 1981 · S/N EA-193N9DWJauch Robert J · Lyndonville, VTBuilt 1973 · S/N D-9436N9EDTaylor Monty · Cornelius, NCBuilt 1972 · S/N 21059612N9EJDk Air LLC · Brookings, ORBuilt 1956 · S/N BG168N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378N9FQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 18502855N9GFApruda Andri Trustee · Nashville, TNBuilt 1988 · S/N 4608127N9HGPoage Matthew L · Yukon, OKBuilt 1979 · S/N D-10244N9JBRgpe Consulting LLC · Wilmington, DEBuilt 1999 · S/N 29-0199N9JFMontgomery David N · Knoxville, TNBuilt 1972 · S/N E-362N9JPEcho Air Inc · Woodstock, GABuilt 1973 · S/N 210-59926N9LCValiair Ltd Co Trustee · Casper, WYBuilt 1968 · S/N TE-553N9LDGreat Atlantic Aeroplane Co Inc · Sebring, FLS/N 310R1256N9LTRegistered aircraftBuilt 2001 · S/N TH-1989N9MPYen Albert S · Hermosa Beach, CABuilt 2002 · S/N E-3471N9NCEmpresas Marex Inc · Mayaguez, PRBuilt 1978 · S/N 414A0202N9NSTs&L Aircraft LLC · Alexandria, MNBuilt 1979 · S/N TJ-238N9RRN9rr Enterprises LLC · Lewes, DEBuilt 1994 · S/N CE-1785N9RYDpr Capital LLC · Farmington, UTS/N 340A0211N9SDResort Aviation LLC · Surfside Beach, SCS/N 421B0888N9SHSenza Limiti LLC · Park City, UTBuilt 1980 · S/N EA-52N9SZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1232N9TCSouthwestern Aviation LLC · Pueblo, COBuilt 1976 · S/N E-923N9TFBender Glenn Steven · Lovell, MEBuilt 1948 · S/N NAV-4-1396N9TRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 21059846N9WJWsw Rental Of Sarasota LLC · Longboat Key, FLBuilt 1973 · S/N 340-0185N9XNRodman T Allin · Waco, TXS/N 21063616N9YRMiller John F · Granby, COBuilt 1975 · S/N TE-1055N9YTYarberry Timothy C · Anderson, INBuilt 1997 · S/N E-3125N9ZPRoth Vicki · Bristow, OKBuilt 2004 · S/N L2K-106N9ZTValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 0088
Back to AD 86-13-04 R3