STCs that may be installed · 757

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

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 = '1385203' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '30114') 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

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 = '1385203'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '30114')
    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 = '1385203'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '30114')
  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

Run 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 767-324

STC ST00108LA-DInstallation of a Hughes Avicom Intl 14-inch video monitor.Hollingsead International STC SA8643SWInstallation of Sky Radio satellite based digital radio broadcast system.Hollingsead International STC ST01046SEInstallation of a Honeywell Solid State Cockpit Voice Recorder.Honeywell International Inc.

Engine · GE CF6-80C2B7F

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.Cook Airtomic STC SE01478CHInstallation of Cook Airtomic alignment joint p/n AIR 22912.Cook Airtomic · Lists CF6-80C2 Series STC SE01471ATReplace right and left side Rohr, Inc. fire detection harness on GE CF6-80C2 engine.Unison Industries · Lists CF6-80C2 Series STC SE00463LAInstall fireproof blankets on the engine fan reverser intermediate fireseal, in lieu of fireproof intumescent coating. This STC is jointly by owned by Hi Temp Insulation and MRA Systems acting through Middle River Aircraft Systems, 103 Chesapeake Park Plaza, Baltimore, MD 21220Hi Temp Insulation Inc

Back to N423AX