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.
1001233-1WPETie Rod Support1001221-1WPETurbine Rotor – 1st StageMISC-3201Server60006848-001ADG LITE ONE AERO (1AEN)02315-0245-0001WEBlade RefillAG627000-13Gasket – Marker BeaconH3482K3937KTFolding StrutAG844000-23Gasket – UHF/VHF AntennaAPM62-0132-1Float Assy, Vent Valve4441411-021Hose, Oxygen - HP Flex738444KTRotor4260-0018-5THROTTLE MODULE ASSEMBLY415200-1017HORIZONTZL STABILIZER ACTUACTOR, ASSY4260-0018-6THROTTLE MODULE ASSEMBLYAPM170-83389-403Flap, EQ, Slide69494J10WEPacking, Preformed60006848-001A717 1AEN69494J13WEPacking, Preformed60006847-001Serial 1AEN69494J8WEPacking, PreformedAG844000-15Gasket – UHF/VHF Antenna1008607-1WESpacer – NonMetallic02015-0276-0001MITGasketAG728000-52Gasket – Satcom AntennaM30903962CartridgeAG627000-23Gasket – Marker BeaconLA170-66567-001WasherLA170-08041-901SealLA170-15891-003HingeLA170-08352-901SealLA170-87198-001SpacerLA374129200DiaphragmLA171-05864-001SpacerLA170-08021-903SealLA170-34052-001BushingLA170-39813-001Bushing ClampLA171-00439-005Seat TrackLA170-06508-403Window ClampLA170-16889-001GasketLA170-68152-001WasherLA170-14939-003Hinge PinLA170-34130-001BushingLA170-55787-401CouplingLA170-09269-001Support FairleadLA170-08021-901SealLA69494J235Packing PreformedLA4644-503Latch ToolLA170-39811-001Bushing ClampLA170-40159-001CageLA170-08559-001Support Fairlead
Back to Embraer ERJ 170-100 STD