OpenAirDocs.org
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.

N59GRTkaczyk Gary J · Canton, MIBuilt 1981 · S/N 32-8106093N59GTMarianas Mission Aviation Inc · Tamuning, GUBuilt 1975 · S/N AA5B-0028N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017N59HYRitter Mark C · Austin, TXBuilt 2001 · S/N 2159N59JAHare Michael R · Nye, MTBuilt 2001 · S/N 80819N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181N59JHFlying Circus Pictures · Los Angeles, CAS/N 70048N59KBBond Kent F · Woods Cross, UTBuilt 2019 · S/N BONDI-1N59KCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 2018N59KKWhite Pitts Inc · Wilmington, DEBuilt 1991 · S/N 5214N59LAAlphin Lewis Jackson · Mount Olive, NCBuilt 1999 · S/N 430-99N59LGWillig Louis · Penn Valley, PABuilt 2011 · S/N 11406N59LHSpillman Robert L DBA · Port Orange, FLBuilt 2003 · S/N 81202N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043N59LPHalkett Blair Ross · Knoxville, TNBuilt 1999 · S/N 001N59LVGreek John W · Tustin, CABuilt 1959 · S/N 24-1229N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59PHSeider Jason · Dallas, TXBuilt 1968 · S/N 680116N59PMPyland Jack · Seagoville, TXBuilt 2007 · S/N 075N59PPJohnson Monte W · La Porte, INBuilt 1960 · S/N 1646N59RBRegistered aircraftBuilt 1994 · S/N B-3N59RHSmith Mikeal A · Acton, CABuilt 1959 · S/N 24-1006N59RVNghiem Daniel · Westminster, CABuilt 1995 · S/N RV21635N59SMChandler Ronald J S · Tucson, AZBuilt 1997 · S/N 21734N59SRRaeder James · Caldwell, IDS/N 001N59SWLg Services LLC · Chino, CABuilt 1966 · S/N 32-753N59TPeters Willie W · Brownfield, TXBuilt 1990 · S/N 20225N59TDDavison Terry W · Melba, IDBuilt 2010 · S/N 72688N59TPRegistered aircraftBuilt 2012 · S/N 82534N59TXThacker Jackie W · Hineston, LABuilt 1978 · S/N 32R-7887105N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WBWhiskey Bravo LLC · Scottsdale, AZBuilt 1990 · S/N 1571N59WDHorner Michael W · Manakin Sabot, VABuilt 2007 · S/N 1423-2007N59WLHerrmann Mark D · Dillingham, AKS/N 269-70N59WMHudson River Wings LLC · Montclair, NJBuilt 1991 · S/N 10037N59YYBay Richard P · West Jordan, UTBuilt 1960 · S/N 56429N5AASimanski Charles J · Onley, VABuilt 1973 · S/N 28-7325670N5ADCraig Philip A Jr · West Richland, WABuilt 1992 · S/N 20954N5ARCraig William O · Holland, MIBuilt 1978 · S/N 7211CN5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-7725239N5BHixon Carl J · Clayton, NCBuilt 2003 · S/N 5061N5BJLinrud Michael A · Velva, NDBuilt 1969 · S/N 187N5BKRegistered aircraftBuilt 1961 · S/N 24-2677N5BMDja Enterprises LLC · Los Angeles, CABuilt 1979 · S/N 28-8090181N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105N5CMBramall Buster I · Waxahachie, TXBuilt 1973 · S/N 17262655N5CQDlc Aviation LLC · Lakeland, GABuilt 1973 · S/N 31-7400977N5DDSeghetti Brant C · San Tan Valley, AZBuilt 1974 · S/N AF17448714N5DPN5dp LLC · Ann Arbor, MIBuilt 1973 · S/N 28-7405033
Back to AD 87-10-06 R1