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.
CDPL817-2-1-EFPlacardCDPL666-406-EFPlacardCDPL903-55-EFPlacardCDPL568-13-EFPlacardCDPL568-181-EFPlacardCDPL666-405-EFPlacardCDPL666-401-EFPlacardCDPL903-33-EFPlacardCDPL821-193-EFPlacardCDPL627-23-EFPlacardCDPL903-35-EFPlacardCDPL821-81-EFPlacardB21507-03CylinderAPM170-96137-403Hinge Upper, AssemblyAD-5583-23-1Handset FrontAD-5583-24-1Handset Rear821196-1WERingSD028-234WEO SealJA5911269-6Seal, LipJA5911269-3Seal, Lip6025-25-001-01Phone Cord AssemblyPE 5483-23-09Front HousingPE 5483 CSR-01Cradle Strain ReliefPE 5483 RSR-01Receiver Strain ReliefPE 5483-24-09Rear HousingCDPL672-24-11-EFPLACARDCDPL672-4-2-EFPLACARDCDPL479-4-2-EFPLACARDCDPL473-30-14-EFPLACARDCDPL568-91-EFPLACARDCDPL479-17-8-EFPLACARDCDPL723-213-EFPLACARDCDPL479-33-15-EFPLACARDCDPL479-8-4-EFPLACARDCDPL479-21-10-EFPLACARDCDPL479-22-10-EFPLACARDCDPL817-11-5-EFPLACARDCDPL473-55-25-EFPLACARDCDPL672-25-11-EFPLACARDCDPL479-39-18-EFPLACARDCDPL672-17-8-EFPLACARDCDPL473-99-45-EFPLACARDCDPL672-16-7-EFPLACARDCDPL479-5-2-EFPLACARDCDPL479-13-6-EFPLACARDCDPL817-132-60-EFPLACARDCDPL821-79-EFPLACARDCDPL817-98-45-EFPLACARDCDPL566-10-5-EFPLACARDCDPL666-430-EFPLACARD
Back to Embraer ERJ 170-100 STD