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.
171-03309-901WEGasket, Knitted-ACS 1171-03310-901WEGasket, Knitted-ACS 5171-03303-901WEGasket, knitted-ACS Door 15, 16, 17171-03307-901WEGasket, Knitted-ACS 12, 13171-03306-901WEGasket, Knitted-ACS 6171-03305-901WEGasket, Knitted-ACS Door 11171-03302-901WEGasket, Knitted-ACS 2, 3APM170-59604-401Waste Flap AssemblyAPM180600-900-2Armcap, Upper-RHAPMF0482854Handle, UnlockingAPMR1610300-005Visor AssemblyAPM62-0132-1Float Assy, Vent ValveAPM171-46053-001Window TransparencyAPMF0453408Cable Unlocking LongitudinalAPM180600-900-1Armcap, Upper-LHAPM170-59604-401Waste Flap AssemblyAPM180600-900-1Armcap, Upper-LHAPMR1610300-005Visor AssemblyAPMF0482854Handle, UnlockingAPM62-0132-1Float Assy, Vent ValveAPM171-46053-001Window TransparencyAPM180600-900-2Armcap, Upper-RHAPMF0453408Cable Unlocking Longitudinal804-1216miniQAR MKIIIPM-99Radome MaskAPM170-62201-005Pressed Flanged, BushingAPM170-83389-403Flap, EQ, SlideAPMB755410-104Rod, 1 AssyAPM170-96130-001Strike, Passive LockAPM10-9126-01BushingAPM170-97640-003ShimAPM170-96139-001BushingAPM171-15482-401Fairing SupportAPM170-96137-403Hinge Upper, Assembly739953WECover - Terminal BlockSG8513SuperSeal Lite Angled Stop EndSG8844SuperSeal Lite Track AssemblySG9900Track SS CoatedSG8504Coloured Insert (14.5mm)SG9999Coloured Insert (30.8mm)SG9903Angled Stop End, 8 - 20 DegreesSG8925PL Insert, Blue EmittingSG9901SuperSeal Stop EndSG9905Angled Stop End, 21 - 30 DegreesSG8512SuperSeal Lite Angled Stop EndSG8501SuperSeal Stop EndSG8845SuperSeal Track AssemblySG8503Photoluminescent InsertSG8642SSL Galley Photoluminescent InsertSG8924Assembly: SuperSeal UltraLite (Blue Emitting)
Back to Embraer ERJ 170-100 STD