N828PC
STCs that may be installed · 60
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 = '7090401'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52043')
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 = '7090401'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52043')
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 · Pilatus PC-7
STC SA02153LA-DInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) SystemSTC SA02717NYInstallation of VoiceFlight Systems LLC VFS101 Speech Recognition ModuleSTC SA02153LAInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) System.STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation System
Engine · Pratt & Whitney Canada PT6A-60A
STC SE01624WIConversion of Pratt & Whitney Canada, Model PT6A-60A to a North Star Aviation PT6A-60AG turboprop engine.
Data required:
1. A copy of this certificate
2. North Star Aviation document, NSA No. 1200, Turboprop Engine Conversion of PT6A-60A Model to PT6A-60AG Configuration per FAA Approved STC , dated March 15, 2011, or later FAA approved revision
3. The ICA supplement for North Star Aviation PT6A-60AG models, Instructions for Continued Airworthiness, NSA No. 1200-ICA, Rev NC, dated March 9, 2011 or later applicable revision.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 SE01805NYInstallation of Fuel Nozzle Adapters using studs and nuts.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.