Embraer ERJ 170-100 STD
PMA parts · 3,621
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A56NM')
AND len(list_intersect(tcds_models, ['ERJ 170-100 STD'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"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 drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A56NM')
AND len(list_intersect(tcds_models, ['ERJ 170-100 STD'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun 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.
AG843000-17Gasket - UHF/VHF Antenna17-012-334KLED Lights766520WECoupling-Splined904807-03Dual Detector AssemblySP3558-51-1450Gasket, Dilution170-55085-405Cabin Supply Duct170-55499-405Cabin Supply Duct170-55762-403Cabin FWD Gasper Riser Connector170-55061-405Cabin Rear Distribution Duct Manifold InterfaceHT3935-7FR-*XXX-A *(WIDTH IN INCHES X 100 (EX. 150 = 1.5)HI-TAK TUFSEAL FLAME-RETARDANTHT3000FR-*XXX-A *(WIDTH IN INCHES X 100 (EX. 150 = 1.5)HI-TAK TUFSEAL FLAME-RETARDANTIFE6462164621 LED LampIFE6462164621 LED LampIFE6462164621 LED Lamp9EL408685-22SMILens Assembly9EL408685-22SMILens AssemblyAG843000-15Gasket - VHF Antenna9EL408685-22SMILens Assembly72552950-001Light AssemblySJ8665 FP-405Radome Boot15800-995A-201Revolution Toilet Assy15800-995A-202Revolution Toilet Assy41031133-501MITClamp - Strap AssyAG247000-04Gasket - L-Band AntennaAPMR1610300-005Visor AssemblyAG822000-08Gasket - TCAS AntennaAG477000-01Gasket - GPS AntennaAG723000-27Gasket - Radio Altimeter Antenna170-55791-401Display Cooling Duct170-55499-405Cabin Supply Duct738399WERace-Bearing-Inner RollerAPMR1610300-005Visor AssemblyAPMR1610300-005Visor AssemblyA483-( )AMAssembly, Toilet SeatVA-2540-T01Water Tank Welded AssyVA-2530-H01Immersion Stick Heater AssyVA-2530-T01Water Tank Welded Assy800-009269-1INSC ILLUM ASSY800-009717-1INSC ILLUM ASSY800-009270-1INSC ILLUM ASSYICE PROTECTION800-010051-1PANEL, ASSY800-009268-1INSC.ILLUM.ASSYF874801-537BGCover Assy, Seat BeltF874201-539BGBack Cover AssyF874103-537BGUpholstery Cover Assembly, BottomF874501-523BGHeadrest Cover AssyF874303-571BGBack Wrap Cover AssyF874701-537BGLiterature Pocket AssyF874303-569BGBack Wrap Cover Assy738466WEPump-Rotor
Back to Embraer ERJ 170-100 STD