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.
190-95137-401Aft Facing Forward Left Hand Attendant Seat Installation Kit170-41312-401Ceiling Instl Kit Fwd Pax Cabin171-49054-403Bulkhead Assy Lh Cockpit170-40037-415Bulkhead Kit AFT Cargo Comp.170-41792-401Ceiling Instl Kit Aft Pax Cabin170-47712-403Insulation Instl AFT Pax Door190-95078-401Fwd Flight Attendant Seat Instl Kit171-41653-403Ceiling Instl - Main Cabin190-43309-409Lavatory Instl KitFwd Lh170-41814-411Lining Assy- Aft Service Door170-41816-407Lining Assy - Fwd Service Surround171-43243-401Galley Kit G1170-45413-405Psu Panel Assy - 12 Min 3 Mask Rhs170-91689-401Proximity Lighting Instl170-41785-403Ceiling Instl Kit Aft Pax Cabin191-40340-403First Class Divider Instl Kit Lh171-47752-413Lavatory Instl Kit Aft Lh171-42840-401AFT Divider Instl LHS171-41690-401Air Supply Instl FWD Pax Cabin170-40017-417Liner Kit FWD Cargo Comp.170-40038-411Finishing Kit Aft Cargo Compt171-47253-401Placard Kit Non Electrical Exit Signs170-45488-401Psu Panel 12 Min 2 Mask Lhs170-47707-411Insulation Instl CTL II Upper171-49031-401Cockpit Bulkhead Instl Kit171-44460-401Galley Instl G2170-40005-415Door Lining Instl FWD Cargo Comp.170-41812-421Lining Instl FWD Service Door170-40025-415Door Lining Instl AFT Cargo Comp.170-45114-401Attd Seat Assy Kit AFT AFT Facing RHS170-47703-417Installation Kit Fwd II Upper170-40016-409Finishing Kit Fwd Cargo Compt170-40017-417Liner Kit Fwd Cargo Compt171-51170-401Galley Installation Kit G3170-47710-405Insulation Instl CTL III Lower170-45205-401Pax Seat Instl Kit170-41812-411Lining Assy- Fwd Service Door171-47750-421Lavatory Instl KitFwd Lh170-41811-411Lining Assy- Fwd Pax Door170-41813-411Lining Assy- Aft Pax Door170-40073-403Finishing Kit Fwd Cargo Compt171-49624-401Overhead Bin Instl Kit171-47752-425Lavatory Instl Kit Aft Lh171-50350-403Galley Installation Kit G2170-44673-419Potable Water Assy Basic Conf 1b171-43300-401Galley Kit G1171-49190-413Lh Windscreen Instl Kit19000-305-1Control Cable Assy170-45740-401Psu Kit 67 Pax Virgin Nigeria170-40016-411Finishing Kit FWD Cargo Comp.
Back to Embraer ERJ 170-100 STD