STCs that may be installed · 79

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

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 = '5150002') 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

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 = '5150002')
    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 = '5150002')
  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

Run 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 · Lancair LC42-550FG

STC SA01838SEInstallation of sunvisor assembly part number 1381000Rosen Sunvisor Systems LLC STC SA01597SEManufacture of replacement seatsOregon Aero Inc STC SA02825NY PAGE 1Installation of Aerospace Logic Aircraft InstrumentsAerospace Logic Inc.STC SA01692SEInstallation of a Garmin GMX 200 Multi-Function DisplayGarmin International Inc STC SA03150CHInstallation of oil cooler door kitKelly Aerospace Thermal Systems LLC STC SA03147CHRemoval of air conditioning scoopKelly Aerospace Thermal Systems LLC STC SA03148CHModification of exhaust tail pipesKelly Aerospace Thermal Systems LLC STC SA5156NMFabrication and installation of Pulsar-MOSFET Landing Light Flasher SystemAvTek STC SA01487SE-DInstallation of a GDL 69 or GDL 69A XM Satellite ReceiverGarmin International Inc STC SA00281BOInstallation 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-000Avidyne Corporation STC SA00243BOInstallation of Centurion Consulting, Inc. GPS Steering Assist Module (SAM) with roll steering (p/n 0025-5100), or without roll steering (p/n 0025-5200).Icarus Avionics, LLC STC SA00290BOInstallation of Avidyne Corporation Part Number 700-00167-XXX Multi-Function Display and Mounting Tray Assembly Part Number 700-00168-XXXAvidyne Corporation STC SA02260CHInstallation of Thermawing de-icing system.Kelly Aerospace Thermal Systems LLC STC SA02741CHReplacement of factory installed engine driven air conditioning system compressor and alternator with electrically driven air conditioning system compressor and 100 ampere alternator and associated componentsKelly Aerospace Thermal Systems LLC STC SA01390WIInstallation of McCauley Propeller Model D3A34C444/78MLA-0 and E-7819 spinner.McCauley Propeller Systems STC SA01060SEInstallation of a semi-portable oxygen system.Precise Flight Inc STC SA02003CHInstallation of propeller de-icing system.Kelly Aerospace Thermal Systems LLC STC SA01695SEInstallation of an antennaGarmin AT Inc.STC SA01487SEInstallation of a GDL 69 or GDL 69A XM Satellite Receiver in accordance with Garmin Supplemental Type Certificate Master Data List, P/N 005-C0217-00, Revision A, dated December 20, 2004, or later FAA approved revision.Garmin AT Inc.STC SA00161BOInstallation of Avidyne Corporation FlightMax 700-00007-( ) EX500 Multi-Function Display.Avidyne Corporation STC SA01157LAInstallation of Electronics International Model FP-5 or FP-5L fuel flow/fuel pressure instrument as a replacement instrument.Electronics International Inc.STC SA00918SEPrecise Flight Inc. speed brake system. Manufactured in accordance with Precise Flight Engineering Drawing List 010S0000, Revision W, or later FAA approved revision. Installed in accordance with Precise Flight Engineering Drawing List 300S0000, Revision J, or later FAA approved revision. Maintained in accordance with Precise Flight Instructions for Continued Airworthiness, contained in Airplane Flight Manual Supplement Document 300SMAN0001, latest FAA approved revision. NOTE: This approval is limited to airplanes which have had speed brake provisions installed in the wing at the Lancair factory during the manufacture of the airplane.Precise Flight Inc STC SA00177BOInstallation of Avidyne Corporation Model 700-00006-1XX-( ) Primary Flight Display and Magnetometer/OAT sensor, part number 700-00011-000.Avidyne Corporation STC SA00178BOInstallation of Avidyne Corporation engine instrument sensor interface unit.Avidyne Corporation STC SA02153LA-DInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) SystemGarmin International Inc STC SA02717NYInstallation of VoiceFlight Systems LLC VFS101 Speech Recognition ModuleVoiceFlight Systems LLC STC SA00281BO PAGE 1Installation 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-000Avidyne Corporation STC SA02153LAInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) System.Garmin AT Inc.STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation SystemGarmin AT Inc.

Back to N166DS