N9405T
STCs that may be installed · 428
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 = '3022083'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '00000')
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.
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 = '3022083'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '00000')
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_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.
Airframe · Mcdonnell Douglas DC-9-83(MD-83)
STC 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 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 ST00052LA-DProvisions for GTE airfone in Weber Model seatbacks.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 SA8026NMInstallation of video entertainment system.STC SA4183NM-DModification of DC-9 (MD-83) aircraft.STC SA4202NM-DInterior reconfiguration.STC SA4209NM-DInterior reconfiguration.STC SA3317NMInstallation of management control unit.