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.
170-45609-403Oxygen Dispensing Unit, Lavatory 14 Min Kit170-40012-405Bulkhead Kit FWD Cargo Compt170-40037-411Bulkhead Kit AFT Cargo Comp170-40819-401Dado Panel Instl Kit170-40037-413Bulkhead Kit AFT Cargo Comp170-45850-407FWD RH Divider First Class Installation Kit170-40017-415Liner Kit, FWD Baggage Compt170-44407-601Vacuum Toilet Retrofit Kit171-52729-601Fire Extinguisher
Sb Kit171-54336-605Manifold Kit Three Person Square ODU Rework171-54339-601Placard Kit ODU Rework171-54336-601Manifold Kit Two Person ODU Rework19000-195-3Drain Mast Heated Water System171-54336-603Manifold Kit Three Person Triang ODU Rework171-52729-603Fire Extinguisher
Sb Kit14330-380Valve Flush, Assy - Plastic
- Leading Edge PlusCDKEMB170-555SB Kit Top Assy Airduct170-94428-405Toilet Shroud Assy19000-305-1Control Cable Assy19000-060Control Cable AssyCDKEMB170-560Airduct Structures Electrical Ins.CDKEMB170-554SB Kit Top Assy Airduct171-46834-401Duct Structure Instl Kit Air DistCDKEMB170-561Airduct Structures Electrical Ins.171-60058-601Bustle Assy, Fwd Pax Door171-60056-601Bustle Assy Fwd Pax Door171-60076-601Aft Pax Bustle Retrofit KitCDKEMB170-301Retrofit Kit Cd PlayerCDKEMB170-304Retrofit Kit Cd PlayerCDKEMB170-291Sb Kit Cd Player - TripCDKEMB170-294Retrofit Kit Cd PlayerCDKEMB170-302Retrofit Kit Cd Player171-60072-601Bustle Assy Aft Service DoorCDKEMB170-292Retrofit Kit Cd Player171-60055-601Bustle Assy Fwd Pax DoorCDKEMB170-298Retrofit Kit Cd Player171-60063-601Bustle Assy Fwd Service Door171-60068-601Bustle Assy Aft Pax Door171-60060-601Bustle Assy Fwd Service DoorCDKEMB170-295Retrofit Kit Cd Player171-60062-601Bustle Assy Fwd Service Door171-60070-601Bustle Assy Aft Service Door171-60071-601Bustle Assy Aft Service Door171-60065-601Bustle Assy Aft Service Door171-60074-601Fwd Pax Bustle Retrofit Kit171-60073-601Bustle Assy Aft Service DoorCDKEMB170-303Retrofit Kit Cd Player171-60057-601Bustle Assy Fwd Pax DoorCDKEMB170-297Retrofit Kit Cd PlayerCDKEMB170-305Retrofit Kit Cd Player
Back to Embraer ERJ 170-100SU