Bombardier DHC-8-402
STCs that may be installed · 65
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 ('1390042')
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 ('1390042')
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 ST03318NYInstallation of Apple iPad Class 2 EFBSTC ST01643WIInstallation of Concorde RG-380E/44 (42AH) or RG-380E/60L (48AH) Series Valve Regulated Sealed Lead-Acid (VRSLA) batteriesSTC ST03262NYInstallation of Quality Aircraft Interiors Oxygen Cylinder Restraint System (OCRS), P/N OCRS-1730-QAI, Models A & DSTC ST03143NYStructural provisions for the installation of a Latitude Iridium/GPS antenna, P/N S5GIR1516RR-A2P-XTT-1 and Latitude Iridium/GPS/WiFi antenna, P/N 5G151624RRL-A2P-XTTT-1STC ST02240SEInstallation of Precise Flight, Inc. (PFI) LED Position LightsSTC ST03069NYInterior passenger reconfigurationSTC ST03070NYInterior passenger reconfigurationSTC ST03026NYInstallation of the Cockpit Door Hold Open LatchSTC SA3665SW: Installation of Floor Proximity Lighting System in accordance with Vista Manufacturing, Inc., Drawing List DH-8-1000, Revision D, Dated December 02, 1986 or later FAA approved revisionSTC ST03016NYTemporary removal of aircraft auxiliary power unit (APU).STC ST02864NYInstallation of Universal Avionics 1408-00-1/-2 Solid State Data Transfer Unit in accordance with Field Aviation East Limited Master and Data List No. DDL-1198, Revision IR, dated October 21, 2009, or later Transport Canada approved revision.STC ST02548NYConfiguration A: Seasonal Bin Fixed Physical Provisions Only
Installation of seasonal bin fixed provisions in accordance with Voyageur Airways Limited Design Change Summary DCS 07-001, Rev N/C dated June 27, 2007 or later Transport Canada approved revisions.
Instructions for Continued Airworthiness are contained in Voyageur Airways Limited MMS 07-0001, Rev B, dated January 28, 2008 or later Transport Canada accepted revisions.
Configuration B: Seasonal Bin Installation
Installation of seasonal bin shall in accordance with Voyageur Airways Limited Design Change Summary DCS 07-001, Rev B dated October 16 2007 or later Transport Canada approved revisions.
Operation must be in accordance with Voyageur Airways Limited Flight Manual Supplement AFMS 07-0001, Rev A, dated May 1, 2008 or later Transport Canada approved revisions.
Instructions for Continued Airworthiness are contained in Voyageur Airways Limited MMS 07-0001, Rev B, dated January 28, 2008 or later Transport Canada accepted revisions.STC ST01839NYInstallation of Sierracin/Sylmar Corporation P/N 802600-09/-10 Windshield AssemblySTC ST00733SEInstallation of Precise Flight Pulselite SystemSTC ST09347SCInstallation of Coltech ATSCALL system.
Back to Bombardier DHC-8-402