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.
CDPL666-210-EFPlacardCDPL575-11-EFPlacardCDPL666-202-EFPlacardCDPL479-40-18-EFPlacardCDPL666-303-EFPlacardCDPL666-209-EFPlacardCDPL561-39-EFPlacardCDPL666-205-EFPlacardCDPL666-308-EFPlacardCDPL666-207-EFPlacardCDPL666-311-EFPlacardCDPL666-206-EFPlacard3178215-1WESeal Assy171-03653-001-EFPaint Mask170-29032-901-EFPlacard170-29061-901-EFPlacard170-29044-901-EFPlacardIAP-00001-01-EFPlacardIAP-00002-01-EFPlacard171-00208-901-EFPlacard170-97047-901-EFPlacard170-29033-901-EFPlacardCD2061-EFPlacardM31470900O-RingM53100578-3Shim, .040 inchM53100578-2Shim, .030 inchM53100578-1Shim, .020 inchM33440016-8Rupture DiscM53100578-6Shim, .003 inchM53100578-5Shim, .007 inchJA54144-12Seal-Channel1001246-2BLEED PRESSURE REGULATING AND SHUT OFF VALVE1001246-3BLEED PRESSURE REGULATING AND SHUT OFF VALVE80502-1002Top Level Kit, Installation, EFB ProvisionsCDPL563-109-EFPlacardCDPL670-63-EFPlacardCDPL563-111-EFPlacardCDPL563-113-EFPlacardCDPL822-9-EFPlacardCDPL563-135-EFPlacardCDPL566-23-10-EFPlacardCDPL566-60-28-EFPlacardCDPL563-151-EFPlacardCDPL563-213-EFPlacardCDPL563-193-EFPlacardCDPL566-120-54-EFPlacardCDPL566-37-17-EFPlacardCDPL563-217-EFPlacardCDPL563-215-EFPlacardCDPL563-149-EFPlacard
Back to Embraer ERJ 170-100 STD