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.
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_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
STC SA1691NMInstallation of a class dividerSTC SA4739SWInstallation of Dual Tracor 7800 Omega/VLF navigation system with dual B&D TAS computers.STC SA4565SWInstallation of sunvisor assembly windshield and inner pane accoustic cabin window.STC SA779SOInstallation of accommodations for 12 first class and 108 tourist class passengers.STC SA3115WEInstallation of Collins ground proximity warning system.STC SA3455WEInstallation of tourist and first class interiors.STC SA3800WEInstallation of a 130 passenger seating arrangement, two galleys, and associated water drain mast.STC SA3660WEInstallation of Carrier Aircraft coat closet Model EAL951-1.STC SA3623WEInstallation of stretcher carrier P/N 2003.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC SA1003SWModification of 721B galley to 721B-1 galley and installation.STC SA2541WEInstallation of tail cone slide cover.STC SA829CEInstall Butler National Corporation flight recorder/communications interface unit.STC SA2330WEInstallation of battery-powered emergency exit lighting in tail- cone.STC ST627SOInstallation of cargo accommodations.STC SA1784WEInstallation of underseat baggage restraint system.STC SA1797WEInstallation of underseat baggage restraint system.STC SA333SOBeverage bar.STC SA457CELockheed Aircraft service 109D flight recorder relocated.STC SA508CEInstallation of Safe Flight P/N 1300-33 SCAT computer in lieu of P/N 1300-32.STC SA520CEInstallation of airborne engine vibration monitoring system.STC SA580EAInstallation of Collins Radio CLC Type 560F-3 area navigation system.STC SA730CEInstall altitude alerting system.STC SA752CEInstall Bendix gyro horizon, P/N1978130-2, and Bendix inverter, P/N 1964771-2.STC ST399SOAddition of underseat luggage restraint.STC ST00050LA-DInstallation of Burns aerospace corp flight attendent seat.STC ST00052LA-DProvisions for GTE airfone in Weber Model seatbacks.STC ST00434LA-DInstallation of a Hamilton Standard Digital cabin pressure control system.STC SA8026NMInstallation of video entertainment system.
Back to Mcdonnell Douglas DC-9-51