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.
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_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 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 ST00389LA-DInstallation of first class seats with GTE Airfone handset.STC ST00744LA-DInstallation of provisions for Control Column and Rudder Pedal, Position Sensors for Flight Data Recorder Expanded Parameters.STC SA7053NMInstallation of lavatory smoke detection system.STC ST01685LAInstallation of Collins Communications Management Unit and VHF Data Radio Transceiver (ACARS/VDR)STC SA3317NMInstallation of management control unit.
Back to Mcdonnell Douglas DC-9-82