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.

N9495VSoccer Goals LLC · Christoval, TXBuilt 1970 · S/N 700067N9496DCavu Clearing LLC · Center Harbor, NHBuilt 1958 · S/N 18-6748N9496VEvans Richard I · Elko, NVS/N 700050N9496WJones Terry · Bells, TNBuilt 1969 · S/N 28-11238N9497JShushnar Gary J · Irvine, CABuilt 1966 · S/N 28-3737N9497PRegistration Pending · Summerville, SCRegistration pendingS/N 24-5015N9498JBrantley Hugh L · Hazlehurst, GAS/N 28-3738N9498KDirksen Caleb A · Garner, IABuilt 1976 · S/N 28R-7635245N9498LRaber Jonathan L · Baltimore, MDBuilt 1972 · S/N AA5-0238N9498NKoehler Scott A · Brighton, ILBuilt 1969 · S/N 28R-35219N9498VMoonshiner Aviation LLC · Austin, TXBuilt 1970 · S/N 700068N9499BWyatt Bradley S · Bishop, CABuilt 2012 · S/N 90631N9499NFlight Niner Niner LLC · Charleston, SCBuilt 1969 · S/N 28R-35220N9499VBerliner Donald D · Medford, NJBuilt 1970 · S/N 700048N9499ZDark Sky Enterprises LLC · Flagstaff, AZBuilt 1998 · S/N 18280292N949BVStout Billy V · Hooker, OKBuilt 2019 · S/N 372-79N949CDDupont Samuel F C · Mount Solon, VABuilt 1978 · S/N 17270883N949GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881225N949MRivera Justin J · Orlando, FLFirst renewal noticeBuilt 2001 · S/N 80540N949MDUnruh Leasing LLC · Blossom, TXBuilt 1973 · S/N 21059889N949PHedgpeth Richard L · Evergreen, NCBuilt 1960 · S/N 24-1851N949PWMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1970 · S/N 121N949RVVan Wagenen Stanley Keith Trustee · Las Vegas, NVBuilt 2003 · S/N 90369N949SMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 172RG0713N949SPN949sp LLC · California, MDBuilt 1999 · S/N 172S8145N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228N949TSSmith Emmet Q · Portola, CABuilt 2018 · S/N 0818N949TTAero Optics Inc · Aguila, AZBuilt 2016 · S/N 6091N949WParrish Shawn J · Great Falls, MTBuilt 2010 · S/N 90467N949WAP S S Air Inc · Middlesboro, KYBuilt 1976 · S/N 31-7612069N949WCCampbell Weldon W · Great Bend, KSBuilt 1997 · S/N 23469N949WRMurley Kent K · Sequim, WABuilt 2000 · S/N 3RX073N94AAPhillabaum Stephen D · Deer Park, WABuilt 2011 · S/N 11424N94ABMiller Paul · El Dorado Springs, MOBuilt 1994 · S/N 21923N94AGSimmons Mark A DBA · Pawcatuck, CTBuilt 1998 · S/N 23052CN94AKWestern Aviation LLC · Bloomfield, MIBuilt 1996 · S/N 32-46043N94AXJudd Howard C · Tehachapi, CABuilt 2003 · S/N G202-016N94BDMcelwain Russell D · Lancaster, KSBuilt 1999 · S/N 80379N94BNRegistered aircraftBuilt 2008 · S/N 91038N94BSMcdonnell John T · Yardley, PABuilt 1989 · S/N 2N94CLEasterbrooks Paul · Chesapeake, VABuilt 1978 · S/N AA5B0742N94CPAhlhorn Travis Wayne · New Braunfels, TXBuilt 1979 · S/N 17273150N94CRGilbert Michael John · Louisville, KYBuilt 1999 · S/N 22297N94DRegistered aircraftBuilt 1982 · S/N 32R-8229050N94DBFox Joseph L · Ocean City, NJBuilt 1983 · S/N 362N94DFBesa Aircraft Corp · Lafayette Hill, PAS/N 61P-0279-062N94DGGreen Daryl K · Grove City, OHBuilt 2005 · S/N 21507N94DLWhiskey November Aviation LLC · Minneapolis, MNBuilt 1973 · S/N 28-7415076N94DTInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 24-4950N94DWTracy David B · West Haven, UTBuilt 2002 · S/N 80636
Back to AD 87-10-06 R1