N987AK

STCs that may be installed · 328

Approved for this aircraft’s airframe or engine model. The registry doesn’t record which STCs an aircraft has; its records do. In force first, then newest.

Query with SQL
duckdb -csv -c "SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
  FROM (
    SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
    FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '3022087')
    GROUP BY stc_number
  ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
  ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_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.

Airframe · Mcdonnell Douglas DC-9-87

STC SA3698SWInstallation of Plumly airborne floor proximity lighting system.Intl Aircraft Certification ServiceSTC SA3921SW-DInstallation of modified galley units.American Airlines IncSTC SA2172CEInstallation of Luminescent Systems floor proximity emergency escape path marking system.Ozark Airlines, IncSTC SA2728WEIncorporation of Holcombe Industries HI-LITE SYSTEM P/N 50-1001 for emergency evacuation slide lighting. (707 AIRPLANES EQUIPPED WITH BOEING P/N 65-11685 AND 65-68862 FORWARD THRUST REVERSER DOORS)Maravia Corp of Idaho · Lists DC-9 SeriesSTC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)Miller Stuart R · Lists DC-9 SeriesSTC SA1691NMInstallation of a class dividerR & B CompanySTC SA4739SWInstallation of Dual Tracor 7800 Omega/VLF navigation system with dual B&D TAS computers.Tracor, IncSTC SA4565SWInstallation of sunvisor assembly windshield and inner pane accoustic cabin window.Madeira Air Supply, IncSTC SA3623WEInstallation of stretcher carrier P/N 2003.Air Medic, Inc · Lists DC-9 SeriesSTC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSundstrand Data Control IncSTC SA1003SWModification of 721B galley to 721B-1 galley and installation.Ward Intl Aircraft Services IncSTC SA2541WEInstallation of tail cone slide cover.Intl Inflatables Co · Lists DC-9 SeriesSTC SA829CEInstall Butler National Corporation flight recorder/communications interface unit.Trans World Airlines Inc · Lists DC-9 SeriesSTC SA2330WEInstallation of battery-powered emergency exit lighting in tail- cone.Intl Inflatables Co · Lists DC-9 SeriesSTC ST627SOInstallation of cargo accommodations.Overseas National Airways · Lists DC-9 SeriesSTC SA1784WEInstallation of underseat baggage restraint system.Air Logistics Corporation · Lists DC-9 SeriesSTC SA1797WEInstallation of underseat baggage restraint system.Air Logistics Corporation · Lists DC-9 SeriesSTC SA333SOBeverage bar.Delta Airlines Inc · Lists DC-9 SeriesSTC SA457CELockheed Aircraft service 109D flight recorder relocated.Trans World Airlines Inc · Lists DC-9 SeriesSTC SA508CEInstallation of Safe Flight P/N 1300-33 SCAT computer in lieu of P/N 1300-32.Trans World Airlines Inc · Lists DC-9 SeriesSTC SA520CEInstallation of airborne engine vibration monitoring system.Trans World Airlines Inc · Lists DC-9 SeriesSTC SA580EAInstallation of Collins Radio CLC Type 560F-3 area navigation system.Eastern Airlines Inc · Lists DC-9 SeriesSTC SA730CEInstall altitude alerting system.Trans World Airlines Inc · Lists DC-9 SeriesSTC SA752CEInstall Bendix gyro horizon, P/N1978130-2, and Bendix inverter, P/N 1964771-2.Trans World Airlines Inc · Lists DC-9 SeriesSTC ST399SOAddition of underseat luggage restraint.Southern Airways Inc · Lists DC-9 SeriesSTC SA7053NMInstallation of lavatory smoke detection system.Hollingsead InternationalSTC ST01685LAInstallation of Collins Communications Management Unit and VHF Data Radio Transceiver (ACARS/VDR)Hollingsead InternationalSTC SA3317NMInstallation of management control unit.Honeywell International Inc.
Back to N987AK