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.
SG8500SuperSeal Lite Track SleeveSG9422Photoluminescent InsertSG8695End Cap, SuperSeal (36º-45º)SG8502SuperSeal Lite Angled Stop EndSG8851Track Sleeve SSUL CoatedSG8854Assembly: SuperSeal UltraLiteAM1038HFoam, armrest cushion3930-0200-0002MITImpeller I3931-020000-02MITImpeller II170-01180-411AIR COND,KIT (BWT)SG8996Flexible Overcarpet End Cap for SSUL with Tape10-50010-XFCCCSSUL-X11 Lateral Extension Track Assembly10-50024-XFCCCSSUL-X23 Lateral Extension Track Assembly10-50023-XFCCCSSUL-X23 Track Assembly10-50008-XFCCCSSUL-X18 Track AssemblySG8916Filler10-50048-XFCCCSSUL-X36 Track Assembly30-50001Scapa 5169 Filler10-50009-XFCCCSSUL-X18 Lateral Extension Track AssemblySG8995Flexible Overcarpet for SSUL with Tape10-50049-XFCCCSSUL-X36 Lateral Extension Track AssemblySG8858Track SSUL Overcarpet 3-5mm10-50011-XFCCCSSUL-X11 Track AssemblySG8857Track SSUL Overcarpet 1.5-3mmGGO4B-LLSU-0288ARINC 641 Transport Media Index, for CORE, Version 0.0.0.8814F0128-205CTXHold Open Rod Fitting14F0210-201CTXPin, Hold Open RodH212605Nylon Gasket5010768ABSwage, Adjuster1001237-2NERing – Fan Rotor1001238-1NENut - Balancing1001230-1NETurbine End Air Bearing Shaft1001233-1NETie Rod Support1001235-2NEShaft – Fan End Air BearingLA4036BracketLA4036BracketLA5133-25Ring, RetainingLA47886-13Track AssyALAN-Y-XXXXZZZZ#avLAN Adapter Installation Kit Configuration804-2000-00avLAN AdapterGGO25-1MSM-0008 Rev AVSAT Capricorn Modem SW (MBC = 2.0.3.7. OPER = 55.1.13.72) LSP for ACPU2P54400Rev GACPU2 SW conversion bundle from 10.x to OXGGO2B-4WSU-0100 Rev A802.11ac Wireless Access Point (acWAP) Operational Software for LRU P33208GGO4E-TMSM-0006 Rev AARINC 665 Compatible Taurus MODEM SoftwareGGO36-0KSU-0602 Rev AKANDU Software Version 6.0.2GGO3A-4WWC-2000 Rev ALSP for 802.11ac Wireless Access Point (acWAP) Configuration Files for LRU P33208GGO4A-LLSU-3101Rev AARINC 641 TRANSPORT MEDIA INDEX, VERSION 1.0.1GGO52-LSSU-0523 Rev BSACL Software ReleaseGGO42-MPGS-0411 Rev ALSP and USB for GOS 4.1.1 Software for A791 MODMAN ACPU2GGO2A-1MSM-0007 Rev AVSAT Capricorn Modem LSP (SW MBC = 2.0.3.5, OPER = 53.2.23.6)
Back to Embraer ERJ 170-100 STD