N415BT
STCs that may be installed · 23
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 = '1900321'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52224')
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 = '1900321'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52224')
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 · Canadair CL-215-6B11(CL-215T)
STC ST12461IBInstallation of Cockpit Voice Recorder with optional RIPS UpgradeSTC ST04328NYThe Manufacture and Installation of Exterior Placards, Labels and Signs is to be performed, installedSTC ST03875NYInstallation of interior placards, signs and markingsSTC SA2622NMInstallation of Precise Flight Pulselite Control Unit in landing/taxi system. (767-200 B17) (DHC-8 101)STC ST00164IBManufacture and Installation of Foam Injection SystemSTC ST00045IBInstallation of the NAT N301A Audio PanelSTC ST00040IBInstallation of the NAT N301A-021 Audio PanelSTC ST04490NYInstallation of the Audio SystemSTC ST04689NYInstallation of the Artex Emergency Locator Transmitter (ELT)STC ST04653NYInstallation of the Collins Aerospace Angle of Attack Indicating SystemSTC ST04177ATInstallation of a Talon Aerospace LED Replacement General Purpose LampsSTC ST04603NYInstallation of NAT N301A-021 Audio PanelSTC ST04482NYInstallation of the Avionics ModificationsSTC ST04424NYInstallation of a NAT N301A-021 Audio PanelSTC ST04432NYInstallation of a NAT N301A-021 Audio PanelSTC ST04398NYInstallation of the NAT N301A-021 Audio PanelSTC ST00813DEReplacement of Honeywell (formerly Sperry) ED-800 cathode ray tube (CRT) display, part number 7003110-90 I or 7003110-902, with Esterline CMC Electronics CMA-6800 multi-purpose liquid crystal display (LCD),STC SA00944CHReplace Janitrol combustion heater Model 81D94-X (XX) with C&D Associates combustion heater Model CD25K, CD35K, and CD45KSTC ST01425NYInstallation of a Flight Deck Cooling System.STC ST02248NYInstallation of EMS HSD-64, HSD-128, HSD-HCM, and HSD-XSTC ST01468CHInstallation of various SMR Technologies electrical propeller deicer models.STC ST01101NYInstallation of Sundstrand T-20G-10C3A auxiliary power unit for ground and water use only.