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.

N9904QStanford Jay J · Saint Marys, GABuilt 1975 · S/N 17265848N9904RInnis Alfonso R Inc · Wilmington, DES/N TD-374N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553N9904WTraweek Parrish C · San Manuel, AZBuilt 1967 · S/N 28-23424N9905FNew Horizon Aviation Inc · Warwick, RIBuilt 1997 · S/N 17280184N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647N9906UBerger Stanley F · Saint Paul, MNBuilt 1977 · S/N AA5A0306N9906WBelmont Thomas M · Boca Raton, FLBuilt 1967 · S/N 28-23426N9906YMac · Wichita, KSBuilt 1961 · S/N 7GCB-74N9907CBlue Marlin LLC · Kalispell, MTBuilt 1978 · S/N R18200488N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851N9907YIngle Stephen D · Bainbridge, OHBuilt 1961 · S/N 94N9908DJb Aviation · Red Bluff, CABuilt 1959 · S/N 18-6949N9908HKoch Vincent Karl · Canyon Lake, CABuilt 1981 · S/N 18268104N9908KG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7890198N9908UVajdak Ronnie · Wallingford, CTBuilt 1977 · S/N AA5A0308N9908YNickerson William L · Libby, MTBuilt 1962 · S/N 122N9909ESmith C Gary · Gretna, LABuilt 1982 · S/N 24-1346N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853N9909UDibble Robb A · Kirkland, WABuilt 1977 · S/N AA5A0309N9909WVafaie Frederick · Williston, FLBuilt 1967 · S/N 28-23429N990AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881580N990APWood Tyler J · Creston, CAS/N 245N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059N990BCMclaughlin Philip · Bakersfield, CABuilt 2006 · S/N 487-2006N990CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280256N990DGRichmeier Patrick R · Quinter, KSBuilt 1967 · S/N 670039N990DMAerolance LLC · Atlantic Beach, FLBuilt 1977 · S/N 32R-7780357N990DSRegistered aircraftBuilt 2003 · S/N 5331N990FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881649N990GGoebel Greg D · Petaluma, CABuilt 2002 · S/N 893-2002N990JDPaoli Sylvia L · La Mirada, CABuilt 1965 · S/N 655N990PHSanchez Leonides R · Alton, ILBuilt 1965 · S/N 28-2797N990RDSutton Capital LLC · Edmond, OKBuilt 2000 · S/N 1-80827N990SAOn-Site Aviation Inc · Hillsboro, NDBuilt 1974 · S/N 31-74N990SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881877N990TRInvictus Aircraft LLC · Chandler, AZBuilt 2021 · S/N 42218N990VTWang Jinrao · Peachtree City, GABuilt 1969 · S/N 28-25910N990XDl Industries Inc · Claremont, NHBuilt 1968 · S/N 28-5251N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403N9910DMoe Gregor A · Sarasota, FLFirst renewal noticeBuilt 1959 · S/N 18-6951N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854N9910USky West Aviation Inc Trustee · Albuquerque, NMS/N AA5A0310N9910YBaumgartner Larry C · Roseau, MNBuilt 1962 · S/N 7GCB126N9911LRitter Timothy D · Billings, MTBuilt 1966 · S/N 24-4524N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855N9911RMatijas Robert J Jr · Homer, NYBuilt 1960 · S/N TD-390N9911USandlapper Venutures Inc · Walhalla, SCBuilt 1977 · S/N AA5A0311
Back to AD 87-10-06 R1