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.
NSL870 B2Sealant170-11717-005SDHalf Hinge170-68651-903SDDeflector170-69451-903SDDeflector4508705SDHingeAECI P/N AEC-3106LINER, SINGLE (BUSHING PTFE)38WS103Water Separator Filter170-50005-417TAIL CONE ASSY170-50005-415TAIL CONE ASSY170-50005-421TAIL CONE ASSY170-50005-429TAIL CONE ASSY170-50005-411TAIL CONE ASSY170-50005-409TAIL CONE ASSY170-50005-427TAIL CONE ASSY170-50005-425TAIL CONE ASSY170-50005-413TAIL CONE ASSY170-50005-405TAIL CONE ASSY170-50005-407TAIL CONE ASSY170-50005-419TAIL CONE ASSY170-50005-423TAIL CONE ASSYA9669-2Hose Assembly1001235-2WEShaft-Fan End1001230-1WEShaft- Turbine End15E0816003Pump Hose AssemblyA9660-3Hose Assembly15E0818003Pump Hose Assembly15E0817005Pump Hose Assembly763614-16WESeal - Spring Ring2950004-304SOV Actuator Assy, 28 VDCPE 5483-23-09Front Housing1701321EControl Unit, Generator1701320CGenerator Auxiliary-115/200 VAC, 400 HZ, 3 Phase, 30/40 KVAPE 5483-24-09Rear HousingPE 5483-46 BG-01Cradle170-70528-001SDWasher, Adjustment170-61250-001SDBushing, Flanged, Frame 9B21507-03CylinderLA170-63280-001Plug HoistLA00200X150A50D5O-Ring1703785BEjection JackLA170-11717-005Half HingeSP2510-00-2088Guide, RightSP2510-00-2087Guide, LeftPE 5483-46 BG-01CradlePE 5483-23-09Front HousingPE 5483-24-09Rear Housing1016041-1WENozzle- Turbine 2nd Stage1001227-1WEPlate-Thrust1001227-11WEPlate713225-111WEPaper
Back to Embraer ERJ 170-100 STD