N858FT
STCs that may be installed · 475
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 = '1384873'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52050')
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 = '1384873'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52050')
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 · Boeing 747-123
STC SA503EA-D1) Add additional first class passenger seats and class divider. 2) Add two additional coat closets in Zone CSTC SA2117WEModify 747-100 Series Aircraft by the installation of 747 Lower Deck Modular and Unitized Baggage/Cargo Containers.STC SA3547WEInstallation of cargo container P/N 025-45571STC SA490GLInstallation of a Telephonics P/N 547-000-1 central switching unit.STC SA702CEInstallation of Bendix standby horizon indicator and inverter.STC SA748NEInstallation of Iacobucci Corp. meal trolleys P/N IM16-00 and IM-16-01.STC ST00989LA-DInstallation of Rockwell Collins FPI-920 LCD EHSI/TAWS Display.STC ST00110LA-DInstallation of wing pylon electrical disconnect panels.STC ST00111LA-DInstallation of a cargo handling system.STC ST00752LA-DInstallation of Rockwell Collins alternate part number SVHS Video Tape players.STC SA4215NM-DReconfiguration of interior seating.STC SA4221NM-DInterior modification.STC SA3074WEInstallation of 96 x 125 inch animal containers.STC SA4149NMInterior reconfiguration including installation of seats, stowage units, and galleysSTC SA2715NMInstallation of a Zone A center- piece stowage unit assembly.
Engine · Pratt & Whitney JT9D-3A
STC SE00024ENInstallation of oil tank filler neck check valve.STC SE01543CHReplace Hamilton Sundstrand P/N 778839-13, 778839-14, 778839-19, 778839-20, 778839-37, 778839-38, 816682-1, 840618-2, 880724 carbon bushings with Cook Airtomic P/N AIR22947 Slotted Entry Busing in the High Pressure Shutoff Valve.STC SE00402NYInstallation of corrosion resistant steel replacement Chip Detectors.STC SE497NEInstallation of oil tank filler neck check valve assembly.STC SE00047AT-DModification of turbine exhaust case to provide increased wall thickness for the purpose of improved blade containment.STC SE00046AT-DState 1 LPC Stator: Provide a seamless one piece rubber airflow surface at the inner shroud.STC SE593NEInstallation of a Select Controls Inc. Engine Oil Shuttle Valve, P/N 2057-1-001. (See Eligibility List)STC SE435NEInstallation of an oil tank filler opening shuttle valve.STC SA2227SOInstallation of wiring and associated components for utilization of the Rolls Royce, Inc., ARINC, interface/readers UT1317 or UT1317/1, for the purpose of acquisition, recording, and analysis in real time of engine/aircraft/ systems. (767 SERIES POWERED BY RR RB-11-524 SERIESSTC SE11CEInstallation of aircraft integrated data system components on engine.