Piper PA-22-150
STCs that may be installed · 316
In force first, then newest. The registry doesn’t record which STCs an aircraft has.
Query with SQL
duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('7102210')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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 s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('7102210')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY 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.
STC SA5-30Rear door removed.STC SA5-60Installation of Russ Simpson sea fins.STC SA666WEEdo 88-1650 floats with Harrison oil cooler AP13SJ03-01 or AP12CU03-01, bottom engine cowl assembly 13159-8, side engine cowl 14237, reinforced fuselage12480 and Sensenich M74DM or M76AM-2 propellers.STC SA3-382Manually operated oil cooler shutter assembly.STC SA1-255Dart I-M turn control unit.STC SA1-337Oil-free vacuum pump PA-201.STC SA1-383Lube oil filter PB 55-1.STC SA12290CHInstallation of a heavy duty tailwheel spring or ACME stinger tailwheel suspension assemblySTC SA001410BOInstallation of an AV-30-C Multi-Mode IndicatorSTC SA00765DE PAGE 1Installation of Automatic Dependent Surveillance Broadcast (ADS-B) Out functionality using the BendixKing KT74 Transponder and qualified position sensorSTC SA02019SE-D PAGE 2Installation of Garmin GTN 6XX/7XX Navigation SystemSTC SA02717NYInstallation of VoiceFlight Systems LLC VFS101 Speech Recognition ModuleSTC ST01085LAInstallation of the VNS 1000 Voice Navigation 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.STC SA2350NMInstallation of Electronics International Inc digital carburetor/outside air temperature gauges listed on the attached continuation sheet and the associated accessories.
Back to Piper PA-22-150