AD 87-10-06 R1

Registered aircraft · 72,010

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.

N739XVAmaro Mark S · Mi Wuk Village, CABuilt 1978 · S/N 17270897N739XWWhole Life Wellness Center · Alpine, TXS/N 17270898N739YESundance Air Services Inc · Alameda, CABuilt 1978 · S/N 17270906N739YHMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270909N739YMHeritage Aviation LLC · Ankeny, IABuilt 1978 · S/N 17270913N739YRF&O Flight LLC · Calhoun, GABuilt 1978 · S/N 17270917N739YURrrr Aviation LLC · Bryan, TXBuilt 1978 · S/N 17270920N739YWPettit Toby B · Morehead, KYBuilt 1978 · S/N 17270922N739YZSocal Aviation Inc · Chino, CABuilt 1978 · S/N 17270925N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZRJw Horton Aviation LLC · Rogers, ARS/N R18201021N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73AXJensen Steven · Port Angeles, WABuilt 1990 · S/N 11024N73BCVnk Sky Inc · Dover, DEBuilt 1973 · S/N 28-7305263N73BWBravo Whiskey Holdings LLC · Lewis Center, OHBuilt 1977 · S/N 28-7816102N73CMMau Christine A · Niceville, FLBuilt 1997 · S/N 21891N73CPQuality Concrete LLC · Brentwood, TNBuilt 2003 · S/N 3232004N73CZBm Air LLC · Anaconda, MTBuilt 1980 · S/N 31-8052177N73DYoseph Barry L · Olympia, WABuilt 1973 · S/N 1BLN73DNMurdoc Aviation LLC · Destin, FLBuilt 1973 · S/N 73-32-110N73DXAj Airlift LLC · Arlington, MAS/N 2868N73ECBronisevsky Robert · Old Bridge, NJBuilt 1990 · S/N 1187N73FQAlaska Island Air Inc · Togiak, AKBuilt 1981 · S/N 32-8206007N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73FTBerecz Kevin · Parrish, FLBuilt 1978 · S/N AA5A-0662N73GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 14515N73GBBotsford Glenn J · Cudahy, WIBuilt 2004 · S/N 70740N73GSHill Gregory A · Romeo, MIBuilt 1973 · S/N 28-7305573N73HYDenniston Tom · Sherwood, ARBuilt 2000 · S/N 2063N73JGMeyer Gordon W · Huber Heights, OHBuilt 1973 · S/N 122-74N73JTRegistered aircraftBuilt 1989 · S/N 2059N73KLTanych Tyler · Inverness, FLS/N 28-7125169N73LKMoore David E · Stuart, FLBuilt 1979 · S/N 31-7912123N73LMKrueger Carl R · Put In Bay, OHS/N 40.209N73LNHelzer Jarrod · Antioch, CABuilt 1973 · S/N 28-7305481N73MDReed Henry J · Jacksonville, NCS/N MB-226N73MMPuddle Jumper Aviation LLC · Brighton, COBuilt 2003 · S/N 51N73MSJohnson Kevin N · Bethpage, NYBuilt 1977 · S/N 17268932N73PAJones Brandon B · Saint Francisville, LABuilt 1973 · S/N 79-73N73PDToribio LLC · San Antonio, TXS/N 001N73PFSinor Delbert · Ozark, MOBuilt 1981 · S/N 28-8216092
Back to AD 87-10-06 R1