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.
TAE0528-1Par 36 Lamp Cool SpotF0419363LAHeadrest AssyA483-()AM () represents three digits that designate the color code.Assembly Toilet SeatA483-()AM () represents three digits that designate the color code.Assembly Toilet SeatFG323000-42Gasket - Fuel Access Door, Embraer 170FG323000-08Gasket - Fuel Access Door, Embraer 170FG323000-44Gasket - Fuel Access Door, Embraer 170FG323000-12Gasket - Fuel Access Door, Embraer 170FG323000-13Gasket - Fuel Access Door, Embraer 170FG323000-10Gasket - Fuel Access Door, Embraer 170FG323000-09Gasket - Fuel Access Door, Embraer 170FG323000-07Gasket - Fuel Access Door, Embraer 170FG323000-43Gasket - Fuel Access Door, Embraer 170FG323000-11Gasket - Fuel Access Door, Embraer 170751299WEGear-Spur738438WEGear-Spur821166-1WEAir Filter Assy751298WEGear-SpurSP2510-00-1020DCup Assy, BrewSP2510-00-1025FCup, Brew (Upper)SP2510-00-1020ECup Assy, BrewSP2510-00-1020CCup Assy, BrewSP2510-00-1020DCup Assy, BrewSP2510-00-1025CCup, Brew (Lower)SP2510-00-1025FCup, Brew (Upper)SP2510-00-1025FCup, Brew (Upper)SP2510-00-1025DCup, Brew (Upper)SP2510-00-1020CCup Assy, BrewSP2510-00-1020DCup Assy, BrewSP2510-08-1020ACup Assy, BrewSP2510-00-1025ECup, Brew (Upper)SP2510-00-1025CCup, Brew (Lower)SP2510-00-1025CCup, Brew (Lower)SP2510-00-1020CCup Assy, BrewSP2510-00-1025ECup, Brew (Upper)SP2510-00-1025DCup, Brew (Upper)SP2510-00-1020FCup Assy, BrewSP2510-00-1020ECup Assy, BrewSP2510-00-1025DCup, Brew (Upper)SP2510-00-1020ECup Assy, BrewSP2510-00-1025ECup, Brew (Upper)SP2510-00-1020FCup Assy, BrewSP2510-00-1020FCup Assy, BrewEAI-2010Faucet170-3452-01-0001ADS-B Out Installation KitM25W2003-2Sunshade AssemblyM25W2003-1Sunshade Assembly5912157-1WEScrewSK3601Radome Boot738429WERetainer-Roller Bearing
Back to Embraer ERJ 170-100 STD