Mcdonnell Douglas DC-9-51

STCs that may be installed · 279

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 ('3022051')
    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 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 SA779SOInstallation of accommodations for 12 first class and 108 tourist class passengers.Eastern Airlines, IncSTC SA3115WEInstallation of Collins ground proximity warning system.Hawaiian AirlinesSTC SA3455WEInstallation of tourist and first class interiors.Eastern Airlines, IncSTC SA3800WEInstallation of a 130 passenger seating arrangement, two galleys, and associated water drain mast.Aerotron Aircraft Radio, IncSTC SA3660WEInstallation of Carrier Aircraft coat closet Model EAL951-1.Carrier Aircraft, 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 ST00050LA-DInstallation of Burns aerospace corp flight attendent seat.Hollingsead InternationalSTC ST00052LA-DProvisions for GTE airfone in Weber Model seatbacks.Hollingsead InternationalSTC ST00434LA-DInstallation of a Hamilton Standard Digital cabin pressure control system.Hollingsead InternationalSTC SA8026NMInstallation of video entertainment system.Hollingsead International
Back to Mcdonnell Douglas DC-9-51