Embraer ERJ 170-100SU
PMA parts · 2,591
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 SU'])) > 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 SU'])) > 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.
CDKEMB170-293Retrofit Kit Cd Player171-60066-601Bustle Assy Aft Pax Door171-60075-601Fwd Service Bustle Retrofit KitCDKEMB170-300Retrofit Kit Cd Player171-60061-601Bustle Assy Fwd Service DoorCDKEMB170-310Retrofit Kit Cd PlayerCDKEMB170-309Retrofit Kit Cd PlayerCDKEMB170-299Retrofit Kit Cd Player171-60067-601Bustle Assy Aft Pax Door171-60077-601Aft Service Bustle Retrofit KitCDKEMB170-470Service Bulletin KitCDKEMB170-311Retrofit Kit Cd Player1008570-100ThinAir Falcon K Rx Antenna1009010-100ThinAir Falcon Ka Tx AntennaJ612302-101Seat Track Cover InstallationJ616002-101ECS Duct ModificationJ614202-105Curtain Divider InstallationJ614402-103Cabin Lighting InstallationJ614002-103Overhead Bin InstallationJ612402-105Pax Seat InstallationD442301-107LH WindscreenModificationJ611002-111Interior Installations and Modifications537NT000-1Top Kit Collector ISPSD442601-107RH AFT Bulkhead ModificationD442902-107Class Divider InstallationJ614402-101Cabin Lighting InstallationJ611002-101Interior Installations and ModificationsD447101-103Placard InstallationD443601-101Galley G3 ModificationD445401-101Proximity Light InstallationJ616002-103ECS Duct ModificationD445501-109Carpet InstallationJ619002-101Placard InstallationD443301-101Electrical Sign ModificationJ611002-109Interior Installations and ModificationsD442501-105RH Stowage ModificationD443501-101Galley G1 ModificationD443201-103Lavatory ModificationD448501-111ECS Duct ModificationJ616102-103PSU InstallationD443201-101Lavatory ModificationJ612402-107Pax Seat InstallationD448401-101FWD Ceiling Electrical Sign ModificationJ614102-101Bin Support Structure InstallationJ614502-101Ceiling Instl, Main CabinD442701-107LH AFT Bulkhead ModificationD448501-103ECS Duct ModificationJ611002-103Interior Installations and ModificationsJ614202-103Curtain Divider InstallationJ614202-101Curtain Divider Installation
Back to Embraer ERJ 170-100SU