Skip to content

STCs that may be installed · 270

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 = '302207C' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '51729') 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 = '302207C'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '51729')
    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 = '302207C'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '51729')
  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 · Mcdonnell Douglas DC-9-33F

STC SA2451SWInstallation of Marathon Battery Co. part 85-0050, or 85-0060 six cell magnesium emergency light pack.Marathon Power Tech Co STC SA1672GLInstallation of Bendix/King EFS-10 electronic flight info sys(EFIS) comprised of 4 display units P/N 3614309-1006, 3 symbol generators P/N 3614335-2015, 3 Navigation concentrators P/N 3614331-2003, 2 EFIS control panels P/N 3614277-1060, 1CRS/HDG/CRS control panel setting control P/N 3605867-0501 and P/N 3614330-1002, and 1 RADALT/DH Collins FGS-80 flight guidance sys.ABX Air Incorporated STC SA8810SWInstallation of Loral/Fairchild model F1000 digital flight data recorder.Aircraft Systems & Mfg STC SA1574GLInstallation of Norton Radome Kit No. 4165X-36 or Norton Radome Kit No. 4165X-37.Norton Company STC ST89CHInstallation of Fairchild Model F800 or F1000 digital flight data recorder.ABX Air Incorporated STC ST00250ATInstallation of two drawer tray P/N 2397-502, and three drawer tray carrier, P/N 2396-502.BFE Services · Lists DC-9 Series STC SA1670GLInstallation of Bendix/King KLN-88 Loran.ABX Air Incorporated STC ST00232ATInstallation of tray carriers.BFE Services · Lists DC-9 Series STC SA5937NMReplacement of existing waste water drain valves with Rogerson waste water drain valves.Rogerson ATS · Lists DC-9 Series STC SA2129CEInstallation of lavatory smoke detection and an automatic fire extinguishing systemAdvanced Aircraft Extinguishers Ltd STC SA1318SOInstallation of non-metallic passenger compartment floor panels.Advanced Technology & Research, Inc · Lists DC-9 Series STC SA1671GLInstallation of Bendix/King RDR-4A Weather radar.ABX Air Incorporated STC SA1226GLInstallation of Norton radome Kit No. 4165X or 4165X-33.Norton Company Performance Plactics STC SA5011NMInstallation of emergency vision assurance system (EVAS).Vision Safe Corporation · Lists DC-9 Series STC SA1497GLInstall a dual Collins FD-108 flight director system.ABX Air Incorporated STC SA1246GLInstall a 'tail cone missing' visual advisory system.Northwest Airlines Inc.STC SA1414GLInstallation of Bendix/King Dual KNS-660 VLF/Omega Navigation System Ferry Kit, consisting of two KNC-667 computers, two KCU-568 control display units and two KA-679 antennas.ABX Air Incorporated · Lists DC-9 Series STC SA2396SOInstallation of a Tailcone Missing Warning System.Jetaire Services, Inc · Lists DC-9 Series STC SA2781NMInstallation of AMI Model 1100 ( ) pilot and/or copilot seat.AMI Industries Inc STC ST626SORemoval of complete passenger accommodations. Installation of cargo interior.Crestview Aerospace Corporation STC SA2045NMInstallation of pilot and co- pilot seats.IPECO, Inc STC SA1970WEInstallation of 88 x 108-inch cargo pallet P/N 24545-51, -52, or -53 with net P/N 24550-51, -52, or -53 and 88 x 54-inch cargo pallet P/N 24546-51, -52, or -53 with net P/N 24551-51 or -52.AAR STC SA2172CEInstallation of Luminescent Systems floor proximity emergency escape path marking system.Ozark Airlines, Inc STC SA2728WEIncorporation of Holcombe Industries HI-LITE SYSTEM P/N 50-1001 for emergency evacuation slide lighting. (707 AIRPLANES EQUIPPED WITH BOEING P/N 65-11685 AND 65-68862 FORWARD THRUST REVERSER DOORS)Maravia Corp of Idaho · Lists DC-9 Series STC SA697EAInstallation of (4) Aerojet- General Corp. 15 KS-1000-A1 or Bristol Aerospace (1968) Ltd. 15 KS-1000-A1(B) rocket engines and fairings.DeVore Aviation Corporation STC SA1545SOModify the wing fuel quantity system to install a new compensator and modify an existing probe.Republic Airlines, Inc STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)Miller Stuart R · Lists DC-9 Series STC SA1691NMInstallation of a class dividerR & B Company STC SA4739SWInstallation of Dual Tracor 7800 Omega/VLF navigation system with dual B&D TAS computers.Tracor, Inc STC SA4565SWInstallation of sunvisor assembly windshield and inner pane accoustic cabin window.Madeira Air Supply, Inc STC SA3115WEInstallation of Collins ground proximity warning system.Hawaiian Airlines STC SA862EAAddition of airspeed select function to speed command/ autothrottle system.Safe Flight Instrument Corp STC SA1193EAInstallation of ceiling panel kits.Atlantic Aviation Corporation STC SA3623WEInstallation of stretcher carrier P/N 2003.Air Medic, Inc · Lists DC-9 Series STC SA2021WEInstallation of various cargo pallets and nets (per Tridair Loading Instructions Drawing No. 40414).Brooks & Perkins, Inc STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSundstrand Data Control Inc STC SA1003SWModification of 721B galley to 721B-1 galley and installation.Ward Intl Aircraft Services Inc STC SA2541WEInstallation of tail cone slide cover.Intl Inflatables Co · Lists DC-9 Series STC SA829CEInstall Butler National Corporation flight recorder/communications interface unit.Trans World Airlines Inc · Lists DC-9 Series STC SA2330WEInstallation of battery-powered emergency exit lighting in tail- cone.Intl Inflatables Co · Lists DC-9 Series STC SA2092WEInstallation of Heath 54 x 88-inch cargo pallet AC-10528-1 and net AC-10657-101.Heath Tecna Corporation STC SA2152WEInstallation of Heath 88 x 108 inch cargo pallet AC-10527-1 and net AC-10196-1.Heath Tecna Corporation STC ST627SOInstallation of cargo accommodations.Overseas National Airways · Lists DC-9 Series STC SA1784WEInstallation of underseat baggage restraint system.Air Logistics Corporation · Lists DC-9 Series STC SA1797WEInstallation of underseat baggage restraint system.Air Logistics Corporation · Lists DC-9 Series STC SA333SOBeverage bar.Delta Airlines Inc · Lists DC-9 Series STC SA457CELockheed Aircraft service 109D flight recorder relocated.Trans World Airlines Inc · Lists DC-9 Series STC SA508CEInstallation of Safe Flight P/N 1300-33 SCAT computer in lieu of P/N 1300-32.Trans World Airlines Inc · Lists DC-9 Series STC SA520CEInstallation of airborne engine vibration monitoring system.Trans World Airlines Inc · Lists DC-9 Series STC SA580EAInstallation of Collins Radio CLC Type 560F-3 area navigation system.Eastern Airlines Inc · Lists DC-9 Series