STCs that may be installed · 293

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 = '0141108' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41530') 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 = '0141108'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41530')
    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 = '0141108'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41530')
  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 · Aero Commander 500-U

STC SA8922SWInstallation of replacement Ultimate Engine Oil Filter for Textron Lycoming and Teledyne Continental engines. (411 S/N 000 THRU 0126, S/N 0127 AND UP) (T188C S/N 03474 AND UP) (206 S/N 05030 AND UP) (207 S/N 05227 AND UP) (T207 S/N 05227 AND UP) (P21 0 SERIES S/N 278 AND UP) (180 S/N 53087 AND UP) (210 S/N 63373 - 63375 AND UP) (B19 SPORT)Capehart Industries, Inc STC SA00168WIInstallation of Wing Ice Inspection LightsCentral Airlines Inc STC SA5656NMInstallation of burglar alarm system.Thompson Harold S STC SA00148WIInstallation of T.K.S. Ice Protection SystemCentral Airlines Inc STC SA00149WIInstallation of Alternate Static SourceCentral Airlines Inc STC SA00111WINew main landing gear scissor fittings.Central Airlines Inc STC SA5926NMInstallation of manifold pressure instrument.Electronics International STC SA00051WINew nose landing gear scissor fitting.Central Airlines Inc STC SA1626NM PAGE 1Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)Electronics International STC SA1626NM PAGE 2Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)Electronics International STC SA00042WIInstallation of a nacelle mounted electrical fuel boost pump system.Central Airlines Inc STC SA00026WINew nose wheel spacer.Central Airlines Inc STC SA5159NMInstallation of chip detector system.Northwest Aircraft Inc · Lists 500 Series STC SA2844CEInstallation of a plastic cap enclosure over the anti-collision strobe light system.Air Transport Inc STC SA2573CEInstall wing and tail leading edge anti-icing shoes.Central Airlines Inc STC SA2663CEInstall Central Airlines nose cap assemblyCentral Air Charter STC SA2678CEInstall Central Airlines extended baggage compartmentCentral Airlines Inc STC SA2827CEInstallation of an Aircraft Voice RecorderCentral Airlines Inc STC SA7186SW-DInstallation of S-TEC System 40/50 Single and Two Axis Automatic Flight Guidance Systems, Model ST-104-40/50.S-TEC Corporation STC SA688NEInstallation of Safeway Model 6900 deicer boot.Safeway Products, Inc STC SA7224SW-DInstallation of S-TEC system 60 pitch stabilization system, Model ST-326.S-TEC Corporation STC SA2186CEInstall passenger compartment cargo restraint system and baggage compartment cargo restraint system.Central Airlines Inc STC SA2556CEInstall cargo restraint systemCentral Air Charter STC SA2621CEInstallation of induction air filter.Central Airlines Inc STC SA7174SW-DInstallation of S-TEC System 60 two axis automatic flight guidance system Model ST-102, with optional autotrim system.S-TEC Corporation STC SA2588CEInstallation of heated windshield plateCentral Air Charter STC SA7164SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system, Model ST-101.S-TEC Corporation STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.Electronics International STC SA3476WEReplacement installation of tail cone assembly.Aircenter, Inc STC SA585SWInstallation of Nose Cone.Aircenter, Inc STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.Electronics International STC SA2353CEInstallation of fuel vent anti-icing fairingsCentral Air Charter STC SA1393SWInstallation of Mitchell automatic flight system FD/AP282-353 consisting of flight director/autopilot with automatic command trim system.Century Flight Systems Inc STC SA1394SWInstallation of Mitchell automatic flight system Model AK353 consisting of Century III autopilot with optional automatic/command trim, radio coupler, glide slope coupler.Century Flight Systems Inc STC SA1494SWInstallation of Mitchell flight director remote annunciator Model AK375.Century Flight Systems Inc STC SA838SWInstallation of Mitchell glide slope coupler Model 1C493.Century Flight Systems Inc STC SA680SWInstallation of Mitchell automatic flight system model AK221 consisting of Century III autopilot with optional automatic pitch trim, radio coupler, and glide slope coupler.Century Flight Systems Inc STC SA3142SW-DInstallation of Mitchell Automatic Flight System Model AK600 consisting of Century IV Autopilot or Model AK600FD consisting of Century IV Flight Director Autopilot with Optional Remote Annunciator.Century Flight Systems Inc STC SA3392SW-DMitchell automatic flight system AK890 consisting of Century IIB autopilot.Century Flight Systems Inc STC SA458EAInstallation of nose cap radome kit No. 3066X-R.Norton Company, Performance Plactics STC SA303GLInstall Cleveland conversion kit No. 199-74 on models which use MIL-H-5606 brake fluid (red oil) or install conversion kit No. 199-74A on models which use Skydrol brake fluid (nonpetroleum base).Parker Hannifin Corp STC SA4219WEInstallation of DTL-1000, -1001 and/or -1002/3 autopilot adapters for the Edo-Aire Mitchell Century III autopilot.Kettler Douglas L STC SA2386SWInstallation of S.A.F.E., EGT, CHT Systems.Avicon Development Corporation STC SA447SOInstallation of Bendix Model FCS810 flight control system, including manual electric trim and flight director indicator DH 841( ).Bendix Corporation Avionics Div STC SA1332SWModification of fuselage for camera and navigation sight installationA D Howard Jr STC SA1125SWModification of fuselage for installation of aerial survey camera and navigation sightKerr Avn Svcs, Inc STC SA1135SWModification of fuselage for installation of Bendix ANA-12 doppler antenna.Kerr Avn Svcs, Inc STC SA1182SWInstallation of dual camera and navigation sight.Kerr Avn Svcs, Inc STC SA4-904Installation of mufflers and modification of carburetor heat system.Western Commander, Inc · Lists 500 Series STC SA476WENacelle mounted fuel booster pump.Western Commander, Inc · Lists 500 Series

Back to N67SS