OpenAirDocs.org
N7470

STCs that may be installed · 483

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 = '138487A'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52054')
    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.

Airframe · Boeing 747-121

STC ST00393NYInstallation of NNAL 527 Stretcher SystemAvmax Aviation Services IncSTC ST00881WI-DModification of a TCAS II system installation to Change 7.0 or Change 7.1Rockwell Collins IncSTC ST09859ACInstallation of a SkyTender Beverage TrolleyASIG LLCSTC SA7076NMInstallation of Stretcher Carrier.Air Medic LLCSTC SA4558NMInstallation of LTN-92 Inertial Navigation SystemsNorthrop Grumman Systems CorporationSTC ST00504LAModification of Litton LTN-92 and LTN-72 Inertial Navigation Systems (INS) to implement the Area Navigation (RNAV) updating capabilityNorthrop Grumman Systems CorporationSTC ST00714LAInstallation of Triple Litton LTN-92 Inertial Navigation System (INS) with RNAV updatingNorthrop Grumman Systems CorporationSTC ST02540LAInstallation of Telair International LLC light weight P/Ns PMC100 and PAG100 series cargo palletsTelair International LLCSTC SA1036NEInstallation of steerable Power Drive Unit (PDU)Telair International LLCSTC SA1435SWInstallation of refrigerated air cargo container for lower lobeTelair International LLCSTC SA2334SWInstallation of LD-3 Cargo Container, P/N DCT 1250Telair International LLCSTC SA2708WEInstallation of Goodyear Aerospace Corp. lower baggage container P/N 625A100-001-103.Telair International LLCSTC SA2801SWInstallation of Container Baggage/Freight LD-3 TypeTelair International LLCSTC SA2801WEInstallation of main deck cargo restraint systemTelair International LLCSTC SA3424WEInstallation of Transequip, Inc. BMA Main Deck Baggage Container, P/N 302928Telair International LLCSTC SA3604WEInstallation of Transequip, Inc. Auto Transporter Assembly, P/N 303500Telair International LLCSTC SA44NWModification of Boeing 747 by installation of cargo containerTelair International LLCSTC SA692CEInstallation of LD3 Cargo ContainersTelair International LLCSTC SA694CEInstallation of GTAX LD3 Cargo ContainersTelair International LLCSTC SA809EAInstallation of Goodyear Aerospace Corporation Lower Deck Baggage Container, P/N 625A100-001-101Telair International LLCSTC SA835EAInstallation of Goodyear Aerospace Corporation Lower Deck Baggage/Cargo Container, P/N 625A401-001-101Telair International LLCSTC SA842EAInstallation of Goodyear Aerospace Corporation Universal Lower Deck Baggage/Cargo Container P/N 625A402-001-101Telair International LLCSTC ST00058LAInstallation of cargo handling system, lower bayTelair International LLCSTC SA1307GLInstall cargo conveyer system.Telair US LLCSTC SA139GLInstall Brooks & Perkins cargo container, P/N 17701-E-100.Telair US LLCSTC SA1560GLInstall lower deck cargo restraining system.Telair US LLCSTC SA1638GLInstall cargo handling systemTelair US LLCSTC SA1955NMInstallation of Center Guide Assembly, P/N 46675-101, -102, -103, -104, -105Telair US LLCSTC SA2324SOInstallation of a cargo handling system.Telair US LLCSTC SA2446WEInstallation of Brownline single pallet lock assembly no 41852Telair US LLCSTC SA2646WEInstallation of Lock Assembly No. 41853-101, -102, -103, -201, -202, -203, -204, -301, -302, -303, and -304Telair US LLCSTC SA2926WEModification to incorporate cargo restraint system P/N 43830, configuration -101. (747-123)Telair US LLCSTC SA3016WEInstallation of Brownline cargo systems 44297-101 and 44297-102. (747-123)Telair US LLCSTC SA3381WEInstallation of Brownline lower lobe cargo system, No. 45478-101. (747-132)Telair US LLCSTC SA3436WEInstallation of Brownline cargo system 45600-102. (747-128)Telair US LLCSTC SA3446WEInstallation of Browline cargo system 45600-101. (747-132)Telair US LLCSTC SA3491WEInstallation of Brownline cargo system 45747-101. (747SP SERIES -156A) (747-131)Telair US LLCSTC SA3754WEInstallation of forward and aft lower cargo compartment door sill restraint fittings.Telair US LLCSTC SA3813WEInstallation of Brownline side restraint, P/N 44981-101.Telair US LLCSTC SA4040WEInstallation of Brownline lower compartment cargo pallet restraint system, P/N 45478-102 or 45145-102.Telair US LLCSTC SA41GLInstall Brooks & Perkins cargo container P/N 17609-E-100.Telair US LLCSTC SA47GLInstall cargo container P/N17617-E-100.Telair US LLCSTC SA48GLInstall cargo container P/N17630-E-100.Telair US LLCSTC SA689CEInstallation of Brooks & Perkins cargo container, P/N's 17026-100, Type A; 17026-100-1, Type A; and 17083-100, Type A.Telair US LLC · Lists 747 SeriesSTC SA711CEInstallation Brooks & Perkins cargo container.Telair US LLCSTC SA792CEMake and install P/N 17455-100 cargo container.Telair US LLCSTC ST11CHInstall cargo conveyer system.Telair US LLCSTC ST02530LAInstallation of T2CAS with TCAS version 7.1Aircraft Communication & Surveillance SystemsSTC ST01771WIModification of Rockwell Collins, Inc. Tailwind 500/550 Satellite TV SystemsRockwell Collins IncSTC ST02524LAInstallation of TCAS version 7.0Aviation Communication and Surveillance Systems (ACSS) LLC
Back to N7470