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.

N944BALatitude 18 Helicopters LLC · Lewes, DES/N 0783N944CBCalifornia Baptist University · Riverside, CABuilt 1973 · S/N 17262402N944CDFlying Easy LLC · Jacksonville, NCBuilt 2009 · S/N 1957N944DPFulton Mark · Elkhorn, NEBuilt 1961 · S/N 1875N944EVSouthlake Aviation LLC · Arden, NCBuilt 2025 · S/N 2881867N944GGraves Charles M · Phoenix, AZBuilt 1987 · S/N 744N944JKRegistered aircraftBuilt 2015 · S/N 001N944KMMartin Rick H · Las Vegas, NVBuilt 2019 · S/N JA1705106N944LC4lc LLC · Mcminnville, ORBuilt 2003 · S/N 10209N944MRegistered aircraftBuilt 1995 · S/N 2843N944MALjmf 17 LLC · Hays, KSBuilt 2002 · S/N 2211N944PCAlba Leasing Services LLC · Phoenix, AZBuilt 2004 · S/N 10292N944RRancifer Rodney M · Lithonia, GABuilt 1970 · S/N 17258933N944RRJaybee Aviation Ltd · Fort Mill, SCS/N 82544N944SJ & J Aviation LLC · Kokomo, INBuilt 2000 · S/N 4636306N944SHA & E Aerial LLC · Nashville, ARBuilt 2005 · S/N 10839N944SJMiller David D · Plainfield, ILS/N 1547N944TDiedrick Michael R · Brooksville, FLBuilt 1960 · S/N TD-400N944VCoastal 944v LLC · Wilmington, NCBuilt 1975 · S/N M-1662N944WMMcinerney James William · Park Ridge, ILBuilt 2015 · S/N 92187N944WTHolt Helicopters Inc · Uvalde, TXS/N 10886N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166N9450PSmh Aviation LLC · Dallas, TXBuilt 1970 · S/N 24-4957N9450WAirwide LLC · Deerwood, MNBuilt 1968 · S/N 28-11169N9451JJackson James E · Denair, CABuilt 1966 · S/N 28-3564N9451NHorus Aviation LLC · Ashburn, VABuilt 1969 · S/N 28R-35166N9452CFarris James R Jr · New Castle, PABuilt 1978 · S/N 32R-7887006N9452EDew Jason L · Krum, TXBuilt 1979 · S/N 17272268N9452HFreeland Thomas W · Early, TXBuilt 1975 · S/N 17266162N9452PRegistered aircraftBuilt 1971 · S/N 24-4959N9452VFriesen Dwayne Phillip · Overton, TXBuilt 1970 · S/N 700052N9452WMarshall Duane C · Rossville, TNS/N 28-11171N9453JStarbard Donald · Crystal Bay, NVBuilt 1966 · S/N 28-3566N9453NBroody George E Jr · Berwick, PABuilt 1969 · S/N 28R-35168N9453PWhitehead Dennis C · Iron Mountain, MIBuilt 1970 · S/N 24-4961N9453VNavflight Inc · Fort Worth, TXBuilt 1969 · S/N 700001N9453WLifetime Aviation Services LLC · Muncie, INBuilt 1969 · S/N 28-11172N9454CPuglia Frank V · El Cajon, CABuilt 1978 · S/N 28-7816477N9454PJohnson Roger D · Fort Meade, FLS/N 24-4962N9454SStoddart Bruce K · Brighton, MIBuilt 2020 · S/N 73627N9455Sessions Richard T · Houston, TXBuilt 2002 · S/N 131N9455NSchreiber Jeffrey H · Mundelein, ILBuilt 1969 · S/N 28R-35170N9456DMajka Marc · San Carlos, CABuilt 1984 · S/N 172RG1171N9456MDickey Brandon · Willow, AKBuilt 2016 · S/N 8180N9456VSnover Darryl A · Cherryville, PABuilt 1970 · S/N 700037N9456WEngwis Douglas R · Rhodes, MIBuilt 1969 · S/N 28-11175N9457DN1705r Inc · Cobb, CAS/N 172RG1172N9457NHermes Aviation Partners LLC · Boca Raton, FLBuilt 1969 · S/N 28R-35172N9457PN84dt LLC · Missoula, MTBuilt 1971 · S/N 24-4965N9457WMast Henry V · Dayton, TXBuilt 1969 · S/N 28-11177
Back to AD 87-10-06 R1