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.
ADV-3E2534Water Sensor ProbeADV-3E2534Water Sensor ProbeADV-316140Pressure Relief ValveADV-508385Temperature ProbeADV-316140Pressure Relief ValveADV-508385Temperature ProbeNo part numberNo part numberNo part numberNo part number650-0100-05Cellular Module, avCM LTE400-21149G-3-101, 400-21149G-3-103, 400-21149G-3-105, 400-21149G-3-111, 400-21149G-3-113, 400-21149G-3-115, 400-21149G-3-205, 400-21149G-3-215, 400-21149G-3-715, 400-21149G-3-815Assy, LRU Adapter (miniQAR MKIII)804-1250-32avRDC MAX QAR804-2000-00avLAN Adapter802-0100-04Kit, avCM 4G Adapter804-1201, 804-1205, 804-1205-03, 804-1212, 804-1216miniQAR MKIII650-0100-04Cellular Module (avCM 4G), GSM / GRPS 4G, Quad Band, SMA21149GK-1Installation Kit, miniQAR / avRDC QAR804-1250-10avRDC QARALAN-Y-XXXXZZZZ#avLAN Adapter Installation Kit Configuration400-21149G-3-305, 400-21149G-3-315, 400-21149G-3-405, 400-21149G-3-415, 400-21149G-3-505, 400-21149G-3-515, 400-21149G-3-605, 400-21149G-3-615, 400-21149G-3-915Assy, LRU Adapter (avRDC or MAX)14G0472-003CTXPush Rod BumperGGO38-5WWC-0100Release Notes for 802.11ax WIFI 6E CABIN WIRELESS ACCESS POINT(axWAP) for LRU P55255-001, VERSION 0.1.0.16GGO39-LLSU-02A3Release Notes - ARINC 641 TRANSPORT MEDIA INDEX, VERSION 0.0.0.133GGO48-MPGS-0482GOS Software Release Notes, VERSION 4.8.2.2GGO31-1USM-0004Release Notes for ACMU OneWeb Operational Software – VERSION 0.0.4.41GGO36-1USM-0120Release Notes for ACMU OneWeb Operational Software - VERSION 0.0.4.10GGO30-1USA-0009Release Notes for ACMU(ESA) Operating System LSP - VERSION 0.0.5.10GGO41-MPAS-0551MPAS Flyaway Software Release Notes, VERSION 5.5.1.13GGO35-1USM-0011ACMU (ESA) OneWeb Operational Software Release Notes, VERSION 0.0.7.1GGO2E-1USU-0012ACMU (ESA) Operational Software (P25) Release Notes, VERSION 0.0.6.5GGO38-5WWC-0100Release Notes for 802.11ax WIFI 6E CABIN WIRELESS ACCESS POINT (axWAP) for LRU P55255-001, VERSION 0.1.0.16GGO29-4WSU-0120Release Notes for 802.11ac Wireless Access Point (acWAP) Operational Software for LRU P33208GGO34-1USM-0010ACMU (ESA) OneWeb Operational Software Release Notes, VERSION 0.0.6.6GGO2A-5WSU-0100Release Notes for axWAP SW - ArubaInstant_Norma_8.10.0.6_86193, VERSION 1.0.0.13GGO2A-5WSU-0100Release Notes for axWAP SW - ArubaInstant_Norma_8.10.0.6_86193,VERSION 1.0.0.13GGO3C-1USA-0005Release Notes for ACMU (ESA) Operating System LSP - VERSION 0.0.4.3GGO3B-1KSU-0181Kandu 1.8.4 Software Release Notes, LSP DOCUMENT APPROVALS ARE VERSION 1.8.1.2GGO3F-1USA-0006Release Notes for ACMU(ESA) Operating System LSP - VERSION 0.0.4.7GGO24-1USU-0009ACMU (ESA) Operational Software (P25) Release Notes, VERSION 0.0.5.6GGO2A-1USU-0007Release Notes for ACMU Part25 Operational Software LSP – VERSION 0.0.4.9GGO4A-MPGS-0491GOS Software Release Notes, VERSION 4.9.1.7GGO2D-3WSU-0110Release Notes for acWAP SW - ArubaInstant_Norma_8.6.0.19_85031,VERSION 1.1.0.6GGO33-1USM-0006ACMU (ESA) OneWeb Operational Software Release Notes, VERSION 0.0.5.6GGO2B-1USU-0006Release Notes for ACMU Part25 Operational Software LSP – VERSION 0.0.4.3GGO30-1USA-0009Release Notes for ACMU(ESA) Operating System LSP - VERSION 0.0.5.103575-1480-07-VAImmersion Stick Heater Assy3520-0551-01-VAImmersion Stick Heater AssyNo part number3575-1251-01-VAImmersion Stick Heater Assy
Back to Embraer ERJ 170-100 STD