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.
170-47711-403Insulation Instl FWD Pax Door170-41811-419Lining Installation Kit Forward Pax Door171-49031-403Cockpit Bulkhead Instl Kit170-44098-405Heating Instl- Water Tank170-94428-405Toilet Shroud Assy170-40005-413Door Lining Instl FWD Cargo Comp.171-47405-401Floor Mat Instl Kit171-47252-401Placard Kit Metallic170-41770-403Ceiling Instl Kit Aft Pax Cabin170-45622-403Oxygen Disp Unit Flight Att Fwd 22 Min - Kit170-46124-401Sidewall Panel Instl Kit170-41814-411Lining Assy- Aft Service Door170-45618-403Oxygen Disp Unit Flight Att Aft Lhs 12 Min - Kit170-44324-403Lamp Assembly Main Cabin170-40822-401Dado Panel Installation Kit170-47184-401Panel Assy-Endblade170-45410-405Psu Panel Assy - 12 Min 2 Mask Lhs170-41814-423Lining Installation Kit Aft Service Door171-47750-415Lavatory Instl KitFwd Lh170-41817-405Lining Assy - Aft Pax Surround170-40005-409Door Lining Kit Fwd Cargo Compt170-95499-401Duct Structure Instl - Air Distrib171-52050-401Bulkhead Instl Kit-AftRh171-45050-401Galley Instl G3170-40017-415Liner Kit Fwd Baggage Compt170-41203-401Ceiling Instl Kit AFT PAX Cabin171-41351-401Support Structure - Kit171-47251-401Placard Kit Plastic171-45740-405Bulkhead Cockpit Instl170-45105-401Attd Seat Assy Kit AFT FWD Facing170-41813-411Lining Assy- Aft Pax Door170-45623-403Oxygen Disp Unit Flight Att Aft 22 Mi171-47752-419Lavatory Instl Kit Aft Lh171-51150-401Galley Kit G3170-40018-409Bulkhead Kit FwdCargo Compt171-48089-401Seat Track Cover Instl170-44002-407Tank Instl - Vacuum System170-91700-403Evacuation Slide Instl171-47750-411Lavatory Installation Kit Forward Left Hand170-40018-409Bulkhead Kit FWD Cargo Comp.170-40074-405Liner Kit Aft Cargo Compt170-44010-411Tank, Water Potable Assembly 110liter Bl171-60057-601Bustle Assy Fwd Pax DoorCDKEMB170-342Ohb Door Edge Trim Sb KitCDKEMB170-304Retrofit Kit Cd PlayerCDKEMB170-301Retrofit Kit Cd PlayerCDKEMB170-305Retrofit Kit Cd PlayerCDKEMB170-303Retrofit Kit Cd PlayerCDKEMB170-339Ohb Door Edge Trim Sb KitCDKEMB170-361Ohb Door Edge Trim Sb Kit
Back to Embraer ERJ 170-100 STD