N331CK
STCs that may be installed · 674
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
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 = '138447P'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '13163')
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 = '138447P'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '13163')
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_numberRun 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 · Boeing 737-300
STC SA5557NM-DInstallation of windscreen modules and partition.STC SA3839SWRemanufacture of AiResearch air conditioning heat exchanger P/N 182820.STC SA8072SWRecore of Boeing 737 precooler heat exchanger.STC ST01427ATInstallation of Tray Carrier.STC ST625CHInstallation of replacement coffee maker over-temperature switch.STC ST00265SEModify in accordance with TRAMCO Engineering Order 28-1-000-001STC ST00251LAInstallation of an Engine Vibration Monitor.STC SA1083NEInstallation of a Rumbold, Inc. Coffee Maker P/N 64769-001-001, -003, -005, -007.STC SA5554NM-DInstallation of class dividers.STC SA5555NM-DInstallation of partitions, stowage module, portfolio module, and wind screen module.STC ST492CHInstallation of replacement coffee maker gaskets.STC ST500CHInstallation of overwing emergency/ ice detection light assemblies.STC ST00158LAInstallation of a Matsushita Avionics Systems digital audio entertainment system.STC ST179CHInstallation of cargo container curtain.STC ST00296ATInstallation of an ARINC 615 data loader system.STC ST00235SEInstallation of Matsushita Avionics Systems passenger audio entertainment system equipmentSTC SA8817SWInstallation of Weed Instrument Model A9806 total air temperature sensor.STC SA5728NMReplacement of forward and/or aft lavatory drain valves with PneuDraulics, Inc. Model 9527 lavatory drain valve.STC ST339CHInstallation of replacement immersion heater.STC ST00185SEFloor and upper tie structural modifications and additions for galley provisions. (737-300 series S/N 24219, 24905)STC SA00056LAInstallation of Weber Coffeemaker, P/N 870130-415.STC ST313CHInstallation of replacement oven fan guard (grid).STC ST00171SEActivation of existing video entertainment system. (737-300 SERIES S/N 27285)STC ST00269NYInstallation of a Rumbold coffee maker.STC ST161CHInstallation of a landing light pulsing system.STC SA8035NMInstallation of In-Flight Phone supplemental ATG rack cooling.STC ST00224NYInstallation of GC200 beverage maker. (757-27B) (737-317) (DHC-8 SERIES ALL SERIES)STC ST00110SEInstallation of a closetSTC SA6081NMInstallation of air-to-ground passenger communication system.STC ST00494ATInstallation of a digital flight data recorder upgrade from 6 to 11 channels.STC ST00101SEIncorporation of avionics modificationsSTC ST00099SEInstallation of Galley G1 and G4B units.STC SA6090NMInstallation of emergency vision assurance system (EVAS).STC SA5185NMInstallation of a dual Mode S (TCAS compatible) ATC transponder system.STC SA2457NMInstallation of partition assembly P/N 805060.STC SA8607SWInstallation of a Claircom air terminal telephone system.STC SA2669SOInstallation of an Aircraft Second Second Battery system.STC ST00268ATInstallation of a Matsushita audio entertainment system.STC ST00269ATInstallation of a Sony video entertainment system.STC ST00253ATInstallation of folding cart assembly, P/N 2498-501, and Atlas tray carrier, P/N 282-502.STC SA6008NMInstallation of 11-parameter Sundstrand flight data recorder.STC SA370NWRemoval of passenger interior, installation of cargo compartment liners and cargo tie down equipment.STC SA5671NMInstallation of a wheelchair stowage unit.STC SA1776GLInstallation of ERDA rotable seat backs, P/Ns 200001 and 200002, onto PTC-920 aircraft seats.STC SA3071SOPassenger interior reconfiguration.STC SA906NEAmendment of STC SA583NE to cover installation of the floor proximity emergency escape marking system.STC SA1577GLInstall a filter in the potable water system.STC SA2589CEInstall Bennetts Seat Converter Stowage Compartment on passenger seat(s).STC SA2668SOInstallation of a Static Inverter.STC SA2670SOInstallation of a Fenwal Model 7213 Smoke Detector System.