N225MB
STCs that may be installed · 120
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 = '7104202'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52265')
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 = '7104202'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52265')
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 · Piper PA-42
STC SA1475NMInstallation of an air ambulance interior, stretcher rack/palletized isolett incubator systemSTC SA02019SE-D PAGE 2Installation of Garmin GTN 6XX/7XX Navigation SystemSTC SA02153LA-DInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) SystemSTC SA00281BO PAGE 3Installation of Avidyne Corporation MLX770 MultiLink Broadcast Transceiver P/N 700-00163-( ), Sensor Systems Inc. Antenna P/N S67-1575-109, or equivalent, and optional Avidyne Mounting Tray P/N 700-00165-000STC SA02153LAInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) System.STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation SystemSTC SA01229SEInstallation of CNX80 GPS WAAS Navigator with integrated VHF Navigation and Communication radios.
Engine · Pratt & Whitney Canada PT6A-41
STC SE12225ACThis STC will incorporate P&W 1700 rpm propeller reduction gearbox on P&WC engines to allow 1700 rpm propeller installationSTC SE00001ENEngines will be maintained IAW 'Maintenance or Reliable Engines(MORE) Program,' Rev 2, 8/16/95.STC SE00014ENInstallation of the Pratt & Whitney Engine Services, Inc. CrossCheck Engine Monitor Kit P/N HUMS-K-071-1, Rev. A on the specified PT6A engine models and kit P/N HUMS-K-071-2 on the specified A250 engine models.STC SE00020ENInstallation of the Pratt & Whitney Engine Services, Inc. TrendCheck/ TrendCheck Plus Engine Monitor Kit P/N TREND-K-010-1STC SE2960SOInstallation of an oil filler cap safety adapter.STC SE615GLIncorporation of a fuel flow transducer.STC SE01805NYInstallation of Fuel Nozzle Adapters using studs and nuts.STC SE09413SCInstall modified gas generator module.STC SE00856NYConversion of PT6A-41 engine model to PT6A-42 engine model.STC SE09257SCConvert P&W Engine Models PT6A-15AG, -27, and -28, into PT6A-34 configuration.STC SE659NEInstallation of oil tank filler neck check valve, P/N TSA-76A.STC SE09144SCInstallation of an alternate gas generator case.STC SE4570SWRevise accessory drive spline, P/N 3008181.