OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274N13910Coryell James M · Valdez, AKBuilt 1974 · S/N 18-7409055N13911Northern Aeroworks LLC · Eagle River, AKBuilt 1971 · S/N 18-8972N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117N1391UArctic Winds Inc · King Salmon, AKS/N 17267062N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983N1393PSeymour Lori L · Woodstock, GAS/N 23-445N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064N1393VWayne Brett M · Saint George, UTS/N HAY 0001N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045N13943Tell Christopher A · Colville, WAS/N 17263046N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048N1394JFendi Aviation LLC · Petal, MSS/N 394N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392N1395JWard Brian S · Long Beach, CABuilt 1975 · S/N 395N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984N13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1970 · S/N 27-4581N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600N13984Smith Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N 27-4602N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985N1398HMiller Debra L · Anchorage, AKS/N 15AC-449N1398JPrivedenynk Sergey · Springfield, MABuilt 1975 · S/N 398
Back to AD 87-10-06 R1