Mcdonnell Douglas DC-9-82

STCs that may be installed · 466

In force first, then newest. The registry doesn’t record which STCs an aircraft has.

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

STC 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 ST00389LA-DInstallation of first class seats with GTE Airfone handset.Hollingsead InternationalSTC ST00744LA-DInstallation of provisions for Control Column and Rudder Pedal, Position Sensors for Flight Data Recorder Expanded Parameters.Hollingsead InternationalSTC 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 Mcdonnell Douglas DC-9-82