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.
191-13820-029-EFPaint Mask190-15023-033-EFPaint Mask191-13820-061-EFPaint Mask171-08882-901-EFPlacard191-13819-003-EFPaint Mask190-15023-011-EFPaint Mask190-14499-001-EFPaint Mask51166-04AC Motor Pump51166-04AC Motor PumpAR4895-1Cockpit Door Lock Control UnitAR4897-1Reinforced Cockpit Door LatchAR4898-1Cabin Crew PanelAR4896-1Electro-Mechanical Door Latch24777WDPort Plate170-55786-403BELLOWS, LH EMERGENCY170-55787-403BELLOWS, RH EMERGENCY1001050-4-014AMS Controller Processor Board1001050-3-014AMS Controller Processor Board1001050-1-014AMS Controller Processor Board1001050-2-014AMS Controller Processor Board700082-4Piston/Shoe Assembly700082-1Piston/Shoe Assembly170-89921-401Duct Structure Assy - Air Distribution9-884879-11Plate Backing170-46925-401Duct Structure Assy-Air Distribution9-3182175-1Diaphragm Assembly9-49C09Spring, Retaining700082-3Piston/Shoe Assembly700082-2Piston/Shoe Assembly170-95499-401Duct Structure Instl Kit-Air Distribution1500-2850-003HGS Overhead Unit1500-2860-006HGS Combiner Right side1500-2840-002HGS Computer5000-7891-003Combiner Sun Visor1500-2860-005HGS Combiner Left sideSP2510-00-7014Vent Valve AssemblySP2510-00-6031PlungerSP2510-00-5070Socket, RelaySP2510-00-5070Socket, RelaySP2510-00-7016Packing, PreformedSP2510-00-11004FittingSP2510-00-10010Thermal SwitchSP2510-00-2153FastenerSP2510-00-2630Standoff, Thermal SwitchSP2570-00-5140HeaterSP2510-00-7031Low Water SensorSP2510-08-12045PlungerSP2510-00-7050Heater CartridgeSP2510-00-2082Brew Head BushingSP2510-00-5005Relay
Back to Embraer ERJ 170-100 STD