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.
PE 5483 RSR-01Receiver Strain ReliefPE 5483-23-09Front HousingPE 5483 CSR-01Cradle Strain ReliefCDPL463-101B-EFPlacardCDPL577-17-EFPlacardCDPL566-50-22-EFPlacard170-98170-901-EFPlacard171-13276-905-EFPaint MaskCDPL463-101A-EFPlacardCDPL666-314-EFPlacardCDPL568-85-EFPlacard1702885FSlat Actuator OutboardSP2510-00-1020Brew Cup AssemblySP2510-00-1020Brew Cup Assembly1702885GSlat Actuator Midboard1700593ESlat Actuator1700597FSlat Actuator Outboard1713255ASlat Actuator, Type A/ESP2510-00-7010Tank Assembly1001050-3-013AMS PROCESSOR CARD - SOFTWARE BL 111001050-4-013AMS PROCESSOR CARD - SOFTWARE BL 111001050-1-013AMS PROCESSOR CARD - SOFTWARE BL 111001050-2-013AMS PROCESSOR CARD - SOFTWARE BL 1114E0160001Bushing (ER1830P01)14E0904001Duct, Turbine Air (ER1677G01)15E0103003Duct, Stage 6 Engine, Steel (ER2058G02)15E2121001HP-LP Duct, LWR (ER2120G01)14E0227001E-Seal, Bifurcation (ER2853)14E0163003Tube-Anti-Ice (ER2476G02)14E0160009Bushing (ER1830P05)14E0160003Bushing (ER1830P03)15E2146001Tube, Air HPSOV Return (ER2966G01)15E0121001Bracket Bridge (ER2007P01)15E0158001Duct, HP/LP (ER2018G01)14E0228001Tube, Line Sense Variable Stator (ER2987G01)14E0150005Firewall Upper Triangle (ER1909G03)14E0226001Insul Boot (ER2648G01DS)15E2147001Tube, Air PRSOV Return (ER2967G01)14E0222001Bracket (ER2160G01)15E0115006Link, Support (ER1781G29)15E2148001Tube, Air-Sense Line (ER2968G01)14C0710001Anti-Ice Tube, Inlet (ER2417G01)15E2152001Tube, Air-HPSOV Inlet (ER2972G01)15E2151001Tube, Air-Sense Line (ER2971G01)14E0114001Link, Support (ER1818G02)15E2154001Bracket Assy. (ER2975G01)15E2128001Bracket, Support (ER2516G01)15E2149001Tube, Air-Sense Line (ER2969G01)15E2150001Tube, Air-PRSOV Supply (ER2970G01)14E0115016Link, Support (ER1781G19)
Back to Embraer ERJ 170-100 STD