Embraer ERJ 170-100SU
PMA parts · 2,591
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 SU'])) > 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 SU'])) > 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.
GGO39-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.10975254-4KTValve, Check, Return3575-1480-07-VAImmersion Stick Heater Assy3520-0551-01-VAImmersion Stick Heater AssyNo part number3575-1251-01-VAImmersion Stick Heater Assy440-0150-3-VAImmersion Stick Heater AssyNo part number440-0150-1-VAImmersion Stick Heater AssyNo part number3575-1480-01-VAImmersion Stick Heater Assy440-0150-5-VAImmersion Stick Heater Assy3575-1251-07-VAImmersion Stick Heater AssyK13114-30317KIT, DOCUMENT, ESA OAE INSTALLATION, EMBRAER ERJ 170 AIRCRAFT5010891ABSpacer, Heat Shield5002742ABPlate, Instruction90000644-2ABPiston Sleeve170-33492-902WESeal, FWD, Center Fairing, Silicone170-33491-902WESeal170-33491-901WESeal170-33493-902WESeal170-33493-901WESeal170-33492-901WESeal, FWD, Center Fairing, SiliconeM35071634-1Pressure Switch, Temperature CompensatedK13114-30217KIT, DOCUMENT, ESA CABININSTALLATION, EMBRAER ERJ170 AIRCRAFTK19114-30217KIT, DOCUMENT, ATG / ATG4REMOVAL, EMBRAER ERJ 170SERIES AIRCRAFT170-39850-901CTXRod AssyHEM-1750-5ASTOWAGE BIN LATCH ASSY
Back to Embraer ERJ 170-100SU