STCs that may be installed · 292

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

STC SA2353CEInstallation of fuel vent anti-icing fairingsCentral Air Charter STC SA2113CEInstallation of single Gill G-247 24-volt battery as a replacement for original dual 12-volt batteries.Central Airlines Inc STC SA2240CEReplacement of dual 50-amp generator system with dual 50-amp Prestolite alternator system.Central 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 SA812NWModification consists of moving the mounting of the roll-servo from fuselage station 71.0 to 180.5 and moving the mounting of the pitch servo from station 85.40 to station 233American Avionics Inc STC SA2386SWInstallation of S.A.F.E., EGT, CHT Systems.Avicon Development Corporation STC SA111RMModify exhaust stacks by installing straight slip joint.Heliarc Welding Service Inc.STC SA447SOInstallation of Bendix Model FCS810 flight control system, including manual electric trim and flight director indicator DH 841( ).Bendix Corporation Avionics Div STC SA321EAInstall wheels P/N 301174, P/N's2-993 and/or 2-1107.BF Goodrich Aerospace STC SA92EAInstall wheels P/N's 3-1112 and/or311-58 and P/N's 2-878 and/or2-971 and/or 2-1087.BF Goodrich Aerospace STC SA630WEInstallation of oil filter assemblies. (NAVION A AND B with optional engine)Nelson Filter STC SA135EAInstallation of engine exhaust combustion monitor.Rosemount Engineering Co 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 SA1138SWInstallation of fiberglass tail cone.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 STC SA258SWCamera and camera view finder opening in main cabin floor of 30-inch x 39-inch maximum dimension.Reading Avn Svc Inc · Lists 500 Series STC SA1064SWInstallation of Wild RC-8 aerial survey camera.Kerr Avn Svcs, Inc STC SA1122SWInstallation of dual cameras and navigation sightA D Howard Jr STC SA1971WEInstallation of Model ARB-3 Automatic Downed Aircraft Marker('ADAM').Burton Instrumentation, Inc STC SA1072SWInstallation of Universal camera.A D Howard Jr STC SA527EAInstallation of Collier Model 1AC internally mounted ADF sense antenna.Collier Aero Products Co STC SA396SWInstallation of Mitchell Automatic pilot AK118Mitchell Industries Inc STC SA1-555ANC-3A computer and ANC-C2 or ANC-D2 controller.Dynavia Corporation · Lists 500 Series STC SA1-64Federal F-400 autopilot.Aircraft Components Inc · Lists 500 Series STC SA3-52537R-2 antenna.Collins Radio Company · Lists 500 Series STC SA30CE210405 governor.Woodward Governor Co · Lists 500 Series STC SA4-1309L-2C autopilot.Bendix Corp · Lists 500 Series STC SA4-777Aerofilter 30409A-12 or full flow filter 30409A with element 1A0235.Winslow Aerofilter Corp · Lists 500 Series STC SA459EAConversion to Model 500B.Southern Ohio Avn Sales Co · Lists 500 Series STC SA70CEFederal F-500 automatic pilot.Aircraft Components Inc · Lists 500 Series STC SA802SWBendix M4-B/C autopilot flight control system.Bendix Corporation Avionics Div STC SA973SWAuxiliary outboard wing tanks.Kerr Avn Svcs Inc STC SA00765DE PAGE 1Installation of Automatic Dependent Surveillance Broadcast (ADS-B) Out functionality using the BendixKing KT74 Transponder and qualified position sensorPeregrine STC SA02019SE-D PAGE 2Installation of Garmin GTN 6XX/7XX Navigation SystemGarmin International Inc STC SA02153LA-DInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) SystemGarmin International Inc STC SA01435DEInstallation of engines, modified with a Firewall Forward Technologies.Centri-Lube Technologies LLC STC ST01085LAInstallation of the VNS 1000 Voice Navigation System.VNS Incorporated

Back to N147F