STCs that may be installed · 113

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 = '1154160') 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 = '1154160')
    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 = '1154160')
  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 · Beech 1900

STC SA00775ATInstallation of a Bendix/King KLN90B Global Positioning System.Piedmont Avn Services, Inc STC SA00776ATInstallation of a Dual Bendix/King Mode S Transponder, Traffic Alert and Collision Avoidance System and Sundstrand Mark VI Ground Proximity Warning SystemPiedmont Avn Services, Inc STC SA5656NMInstallation of burglar alarm system.Thompson Harold S STC SA187CHInstallation of a Flight Visions FV-2000/KA head- up display.Flight Visions, Inc STC SA1626NM PAGE 1Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)Electronics International STC SA1278CEInstallation of Avcon Industries stretchers with P/N4001-103 or 4001-104 installed.Med-Flite of Midamerica, Inc STC SA1834CEConsole installation (structural approval only).Med-Flite of Midamerica, Inc STC SA707NEInstallation of Safeway Model 6893 deicer boot.Safeway Products, Inc STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.Electronics International STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.Electronics International STC SA192GLInstallation of Norton radome kit No. 2090XS.Norton Company Performance Plactics STC SA00281BO PAGE 2Installation of Avidyne Corporation MLX770 MultiLink Broadcast Transceiver P/N 700-00163-( ), Sensor Systems Inc. Antenna P/N S67-1575-109, or equivalent, and optional Avidyne Mounting Tray P/N 700-00165-000Avidyne Corporation STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation SystemGarmin AT Inc.

Back to N125BA