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.
J612102-101Floor Carpet InstallationJ619002-105Placard InstallationJ614002-101Overhead Bin InstallationJ619002-103Placard InstallationJ614302-101Cabin Temperature Duct InstallationJ616002-105ECS Duct ModificationD445101-109Seat Track Cover InstallationD449101-111PSU InstallationD449101-103PSU InstallationJ616102-105PSU InstallationJ611002-107Interior Installations and ModificationsJ614502-103Ceiling Instl, Main CabinJ612402-109Pax Seat InstallationD447101-103Placard InstallationJ611002-105Interior Installations and ModificationsD443401-101Passenger Sign Panel ModificationD441001-125Interior InstallationJ616102-101PSU InstallationD448401-101FWD Ceiling Electrical Sign ModificationJ614502-105Ceiling Instl, Main CabinJ612202-103Proximity
Light InstallationJ612402-101Pax Seat InstallationD445401-101Proximity Light InstallationJ612402-103Pax Seat InstallationJ616102-109PSU InstallationD445101-117Seat Track Cover InstallationD442902-101Cabin Divider InstallationD443301-109Electrical Sign ModificationJ616102-107PSU InstallationD444101-113Pax Seat InstallationD445501-103Carpet Installation537NT000-1Top Kit Collector ISPSD443301-101Electrical Sign ModificationD442501-107RH Stowage ModificationD444101-103Pax Seat InstallationJ612402-111Pax Seat InstallationD442301-105LH Windscreen ModificationJ612202-101Proximity
Light InstallationD441001-115Interior InstallationD443401-101Passenger Sign Panel ModificationA141747-101AFT Cargo Compartment Nets InstallationD966300-101Overhead Bin ModificationD965200-101Floor Carpet ModificationE847201-103PSU Duct Structure ModificationD962001-101Ceiling Panel InstallationE845401-101RH Stowage ModificationE842001-103Floor Panel InstallationD961001-103Interior InstallationD963001-103RH Wardrobe Installation ModificationD445301-103Floor Carpet Installation
Back to Embraer ERJ 170-100SU