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.
2R7218DPrimary Actuation System3R1209BRudder Load Cell3R1208BAileron Load Cell3R1210BElevator Load Cell3R1222ARudder Load Cell2R2208BAirstairs Backup Actuator3E1524BLanding Gear Feedback Position Sensor3510-0039-01Coffee Maker416-0001-9Coffee Maker180-146Liquid Container416-0001-9Coffee Maker180-146Liquid Container11225-1Coffee Maker416-0001-9Coffee Maker416-0001-9Coffee Maker416-0001-9Coffee Maker416-0001-9Coffee Maker11225-1Coffee Maker11225-1Coffee Maker180-146Liquid Container416-0001-9Coffee Maker180-146Liquid Container180-146Liquid Container416-0001-9Coffee Maker180-146Liquid Container180-146Liquid Container170-29055-901-EFPlacard170-29057-901-EFPlacard171-04390-901-EFPlacard170-29052-901-EFPlacard170-29028-901-EFPlacard190-13929-901-EFPlacard170-29064-901-EFPlacard170-29039-901-EFPlacard171-04939-901-EFPlacardCDPL671-24-EFPlacard170-97043-901-EFPlacard171-10296-901-EFPlacard170-29050-901-EFPlacard170-29040-901-EFPlacardCDPL568-87-EFPlacard170-29031-901-EFPlacardCDPL471-46-21-EFPlacard170-29058-901-EFPlacard170-29035-901-EFPlacardCDPL666-105-EFPlacard170-29034-901-EFPlacard171-08317-901-EFPlacard170-97301-901-EFPlacardCDPL473-40-18-EFPlacard
Back to Embraer ERJ 170-100 STD