N2BZ
STCs that may be installed · 266
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 = '7630410'
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 = '7630410'
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_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 · Rockwell International 500-S
STC SA3516WEInstallation of cockpit overhead windows.STC SA00282WIInstallation of BC100-1 sealed lead acid batteriesSTC SA00168WIInstallation of Wing Ice Inspection LightsSTC SA5656NMInstallation of burglar alarm system.STC SA00148WIInstallation of T.K.S. Ice Protection SystemSTC SA00149WIInstallation of Alternate Static SourceSTC SA00035SEInstallation of wing front lower spar cap replacement and reinforcement kit.STC SA00111WINew main landing gear scissor fittings.STC SA5926NMInstallation of manifold pressure instrument.STC SA00051WINew nose landing gear scissor fitting.STC SA1626NM PAGE 1Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)STC SA1626NM PAGE 2Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)STC SA00042WIInstallation of a nacelle mounted electrical fuel boost pump system.STC SA00026WINew nose wheel spacer.STC SA5159NMInstallation of chip detector system.STC SA2844CEInstallation of a plastic cap enclosure over the anti-collision strobe light system.STC SA300CEInstallation of Woodward propeller governors on single and twin engine aircraft. (PA-31-325 modified per Colemill STC SA 970SO)STC SA2573CEInstall wing and tail leading edge anti-icing shoes.STC SA2827CEInstallation of an Aircraft Voice RecorderSTC SA7186SW-DInstallation of S-TEC System 40/50 Single and Two Axis Automatic Flight Guidance Systems, Model ST-104-40/50.STC SA610NEInstallation of Safeway deicer boot.STC SA688NEInstallation of Safeway Model 6900 deicer boot.STC SA7224SW-DInstallation of S-TEC system 60 pitch stabilization system, Model ST-326.STC SA2186CEInstall passenger compartment cargo restraint system and baggage compartment cargo restraint system.STC SA2556CEInstall cargo restraint systemSTC SA2621CEInstallation of induction air filter.STC SA2604CEInstall passenger compartment and baggage compartment cargo restraint system.STC SA7174SW-DInstallation of S-TEC System 60 two axis automatic flight guidance system Model ST-102, with optional autotrim system.STC SA2588CEInstallation of heated windshield plateSTC SA7164SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system, Model ST-101.STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.STC SA3476WEReplacement installation of tail cone assembly.STC SA585SWInstallation of Nose Cone.STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.STC SA2353CEInstallation of fuel vent anti-icing fairingsSTC SA2113CEInstallation of single Gill G-247 24-volt battery as a replacement for original dual 12-volt batteries.STC SA1393SWInstallation of Mitchell automatic flight system FD/AP282-353 consisting of flight director/autopilot with automatic command trim system.STC SA1394SWInstallation of Mitchell automatic flight system Model AK353 consisting of Century III autopilot with optional automatic/command trim, radio coupler, glide slope coupler.STC SA1494SWInstallation of Mitchell flight director remote annunciator Model AK375.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.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.STC SA3392SW-DMitchell automatic flight system AK890 consisting of Century IIB autopilot.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).STC SA4219WEInstallation of DTL-1000, -1001 and/or -1002/3 autopilot adapters for the Edo-Aire Mitchell Century III autopilot.STC SA2386SWInstallation of S.A.F.E., EGT, CHT Systems.STC SA854EAInstallation of Radome Kit No. 4022KX.STC SA447SOInstallation of Bendix Model FCS810 flight control system, including manual electric trim and flight director indicator DH 841( ).STC SA101GLInstallation of Collins AP-107 autopilot.STC SA66GLInstall Collins AP-106 autopilot consisting of Collins 913K-1 two each 334C-9 (662-0964-001, -002), 334C-6 (622-0965-002), 590A-6, 614E-1, 339T-1, 161H-1, 590B-3, and 390B-18 units.STC SA1332SWModification of fuselage for camera and navigation sight installation