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.
CDPL566-27-12-EFPlacardCDPL566-17-8-EFPlacardCDPL566-62-28-EFPlacard1001050-6-016AMS Processor Card with Software BL 14CDPL566-47-21-EFPlacardCDPL566-33-15-EFPlacardCDPL566-22-10-EFPlacardCDPL566-57-26-EFPlacardCDPL566-35-15-EFPlacardCDPL566-4-2-EFDecal1001050-5-016AMS Processor Card with Software BL 14CDPL566-42-20-EFPlacardCDPL566-75-34-EFPlacardCDPL566-44-20-EFPlacardCDPL566-17-7-EFPlacard1001050-7-016AMS Processor Card with Software BL 14CDPL566-26-11-EFPlacardCDPL566-63-28-EFPlacardCDPL566-8-4-EFDecalCDPL566-7-3-EFPaint maskCDPL566-19-9-EFPlacardCDPL566-13-6-EFPlacardCDPL566-6-3-EFDecalCDPL566-98-44-EFPlacardSP2510-00-8A080Plate Assembly (L)SP2510-00-8A105Polyester SpringSP2510-00-8A095ProbeSP2510-00-8A075Plate Assembly (R)SP2510-00-2152ScreenSP2510-00-2097JDouble Probe GuardAPMR1610300-005Visor AssemblySP2510-00-7075BWater JetCDPL903-79-EFPlacardCDPL666-402-EFPlacardCDPL903-69-EFPlacardCDPL479-98-44-EFPlacardCDPL479-28-13-EFPlacardCDPL666-414-EFPlacardCDPL562-93-EFPlacardCDPL903-75-EFPlacardCDPL568-183-EFPlacard170-98166-901-EFPlacardCDPL821-47-EFPlacardCDPL903-77-EFPlacardCDPL479-30-13-EFPlacardCDPL536-3-EFPlacardCDPL562-95-EFPlacardCDPL903-37-EFPlacardCDPL903-31-EFPlacardCDPL903-39-EFPlacard
Back to Embraer ERJ 170-100 STD