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.
LA170-46251-003Window TransparencyLA170-14939-001Hinge PinLA4644-503Latch ToolLA170-40404-401CageLA374129200DiaphragmLA170-30576-901Access Door SealLA170-31460-001BushingLA170-87198-001Spacer41401050-502KTTrim Arm, Hinged41401050-501KTTrim Arm, HingedKTAMA3593-7Tube AssemblyKT3593-7-1Rod End KitCLMA3593-4Lock Assy., CouplexA3593-7Engine Cowl Hold Open Rod Assy.1001050-5-015AMS Controller Processor Board with Black Label 13 Software Uploaded1014023-2HEATED FLOOR PANEL1001050-6-015AMS Controller Processor Board with Black Label 13 Software Uploaded1014021-2HEATED FLOOR PANEL1014022-2HEATED FLOOR PANELFE374105200KTShear Pin738386WDGuide, Retainer3177424-1WDCollar9-310726-4Screw, Adjusting9-858888-3Plate, Diaphragm Retainer9-3236158-1Bushing9-3163812-12Guide, Valve9-3167312-1Gasket9-3164709-2Retainer, Diaphragm9-858887-4Plate, Diaphragm Backing9-3166458-1Retainer, Diaphragm9-3163811-7Valve, Poppet9-3164707-1Retainer, Diaphragm9-3163809-6Retainer, Spring9-3162467-1Shuttle, Valve9-3176646-1Diaphragm, Air9-858886-14Diaphragm Assembly9-3166459-2Retainer, Diaphragm9-3170022-1Cover Assembly9-3182176-1Diaphragm Assembly9-3181650-1Packing56504-01WDTrunnion9-3162467-1Shuttle, Valve9-3166459-2Retainer, Diaphragm9-3164707-1Retainer, Diaphragm9-3163809-6Retainer, Spring9-3167312-1Gasket9-3236158-1Bushing9-3163812-12Guide, Valve9-3166458-1Retainer, Diaphragm9-3163811-7Valve, Poppet
Back to Embraer ERJ 170-100 STD