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.

N7489JMayer Thomas D · Medford, ORBuilt 1968 · S/N 28R-30849N7489LMills Randall J · Monroe, MIBuilt 1975 · S/N 18-7509076N7489PRegistration Pending · Whitefish, MTRegistration pendingBuilt 1961 · S/N 24-2682N7489WHostetler Kevin · Green Forest, ARBuilt 1963 · S/N 28-1400N748ACSweeet Aviation LLC · Dover, DEBuilt 1999 · S/N 847-99N748AKKatz Andres U · Dallas, TXBuilt 2017 · S/N 81853N748BPNiehaus Michael J · West Burlington, IABuilt 2005 · S/N 10994N748CDuffel Christopher · Bellevue, WABuilt 1985 · S/N 25N748EMMaxwell Edward G · Louisville, KYBuilt 2022 · S/N 71812N748HHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1748N748LLdz Aviation Resources LLC · Sayville, NYBuilt 1976 · S/N 0748N748MSchapler Robert H · Alexandria, VABuilt 2006 · S/N 70048N748NPBelle Island Management LLC · Fort Lauderdale, FLBuilt 1969 · S/N 31474N748PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881190N748PKHaller Kurt L · Pleasanton, CABuilt 2019 · S/N 001N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035N748RSGrady Michael J · Farmington, NMBuilt 1968 · S/N 28-5230N748SBright Skies Sales And Leasing LLC · Hendersonville, TNS/N 1728N748SPBg-Ip LLC · Saratoga, CABuilt 2000 · S/N 172S8682N748WMTruett Michael J · Beavercreek, ORBuilt 2025 · S/N 92314N7490FDodson International Parts Inc · Rantoul, KSS/N 570596N7490PRobinson John W · Ten Mile, TNBuilt 1961 · S/N 24-2683N7490WCome Fly With Me LLC · Columbiana, ALBuilt 1963 · S/N 28-1401N74912Sky Sailing Inc · Warner Springs, CABuilt 1975 · S/N 18-7509094N74913Street Raymond E Jr Trustee · Fort Worth, TXBuilt 1975 · S/N 18-7509095N74914Tachoir Steven E · Marienville, PABuilt 1968 · S/N 67-15442N74919Braden John H · Watseka, ILBuilt 1975 · S/N 18-7509096N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191N7491WWillard Michael W · Boonville, NCS/N 28-1402N74922Sale Reported · Anchorage, AKSale reportedBuilt 1975 · S/N 18-7509097N74924Rs Specialties LLC · Anchorage, AKBuilt 1975 · S/N 18-7509098N74929Shadbolt George Q · Merriman, NES/N 18-7509101N7492JClassic Air Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30852N7492PCache Rentals 401k P.S.P. · Greeley, COS/N 24-2686N7492WN7492w LLC · Spicewood, TXBuilt 1963 · S/N 28-1405N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074N74935Mcevoy Richard D Trustee · Anchorage, AKBuilt 1975 · S/N 18-7509100N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193N7493JRegistered aircraftBuilt 1968 · S/N 28R-30854N7493PBassar Michael · Eagle, MIBuilt 1961 · S/N 24-2687N7493RWalcher James W · Wilmington, ILBuilt 1966 · S/N 28-22047N7493WNonn Lidia G · Appleton, WIBuilt 1965 · S/N 28-2900N74945Wright Sherry L · Buhl, IDBuilt 1975 · S/N 18-7509102N7494PM And P Aviation Inc · Albia, IABuilt 1961 · S/N 24-2689N7494WLandreth Homer W · Peoria, AZBuilt 1963 · S/N 28-1407N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555N74954Willis Andrew B · Wasilla, AKBuilt 1975 · S/N 18-7509103N7495JDreamair LLC · Fargo, NDBuilt 1968 · S/N 28R-30856N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690N74960Smith Wallace B · Fairbanks, AKBuilt 1975 · S/N 18-7509105
Back to AD 87-10-06 R1