STCs that may be installed · 466

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 = '8680803' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41562') 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 = '8680803'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41562')
    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 = '8680803'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41562')
  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 · S N I A S AS350D ASTAR

STC SH748NWInstallation of a weighing system.McCallister Engineering Enterprises STC SH4043SWInstallation of patient supplemental oxygen supply.Thales Avionics, Inc.STC SA4556SWInstallation of dual/single fore and aft fixed litter.Thales Avionics, Inc.STC SH1690SOInstallation of Facet Aerospace engine oil scavenge filter kit No. 1741100.Facet Filter Products STC SH1725SOInstallation of an airframe mounted lubrication oil scavenge filter in existing scavenge system.Aircraft Porous Media, Inc STC SH360NEInstallation of advanced vapor cycle air conditioning system.Advanced Flight System, Inc STC SH357NEInstallation of Smith 350T wet line torque-meter.Smith George & Therese Inc STC SH1868CEInstallation of Collins PAC-200 HF antennae.Collins Aviation Service STC SH631GLInstallation of Airborne fuel boost pump, P/N 1C45-2 in place of Aerospatiale fuel boost pump, P/N 350A55-1011-03.Parker Hannifin Corp STC SH4175SWFour-place forward facing divan.Foster-Edwards Aircraft Co Inc STC SH740NWInstallation of model 150-21 electronic weighing system.Measurement Systems Intl STC SH1543CEInstallation of Collins APS-841H helicopter automatic flight control systems.Collins Aviation Service STC SH771NWInstallation of a weighing system.Onboard Weighing Systems STC SH2866SWInstallation of Standard Hourmeter and/or Forest Service Hourmeter.American Eurocopter Corporation STC SH2936SWInstallation of reversible dual bench seat.American Eurocopter Corporation STC SH2937SWInstallation of dual non-stowable litter kit.American Eurocopter Corporation

Back to N3604T