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.
171-49117-403Emergency Equipment Installation Kit171-43243-401Galley Instl G1170-41315-401Ceiling Instl Kit Aft Pax Cabin170-40038-413Finishing Kit Aft Cargo Compt170-41811-411Lining Assy- Fwd Pax Door170-44209-411Fire Suppression System Instl Kit170-45106-403Observer Seat Instl170-41296-401Air Supply Instl AFT PAX Cabin Kit170-45133-401Aft Attendant Seat Forward Facing Kit171-41896-401Curtain Installation Kit170-47716-403Insulation Instl AFT Cargo Door171-49638-401Plug Instl Kit-Upper Plenum Overhead Bin171-45050-401Galley Kit G3170-47706-403Insulation Instl CTL I Lower171-49630-401Lamp Instl- Kit170-44449-401Service Panel Kit - Vacuum System170-45615-403OXY Dispensing Unit LAV 12 Min Kit170-41202-401Ceiling Instl Kit FWD Cabin171-47518-405Lavatory Instl Kit Aft Lh171-49117-401Emergency Equipment Instl Kit171-52040-401Bulkhead Instl Kit-Aft Lh170-47705-415Installation Kit CTL I Upper170-91602-405Moveable Class Divider - Assy170-47500-415Installation Kit CTL III Upper171-52080-401Bulkhead Instl Kit-AftRh171-49103-401Emergency Equipment Instl170-45440-403Psu Panel Assy - 22 Min 3 Mask Rhs190-44409-409Tank Assy Waste Vacuum System171-52075-401Bulkhead Instl Kit-Aft Lh171-44460-401Galley Kit170-41295-403Air Supply Installation Aft Pax Cabin Kit171-52436-401Ceiling Instl Main Cabin Kit - JL171-42007-403Lining Installation Kit Fwd Service Surround171-41565-403Surround Instl FWD Pax DoorCDKEMB170-555SB Kit Top Assy Airduct170-44004-403Water Waste System Controller Assy170-40039-417Liner Kit AFT Cargo Comp.170-47713-403Insulation Instl FWD Service Door170-45453-403Psu Panel Assy-12 Min 3 Mask RhsCDKEMB170-561Airduct Structures Electrical Ins.170-89800-401Lens Cover Assy - Air Distribution170-44682-401Potable Water Assy Optional Config 1C171-52404-401Air Supply Duct Assy170-45102-401AFT-Facing FWD LH ATTD Seat Kit170-44209-409Fire Suppression Assy BAG Comp.171-41351-401Support Structure Instl Overhead Bin170-45726-401PSU Instl170-45216-401FwdFacing Aft Lh Att Seat Instl Kit171-50260-403Galley Installation Kit G2170-40025-409Door Lining Kit Aft Cargo Compt
Back to Embraer ERJ 170-100 STD