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.
LA490X190A5005O-RingLA3460X240A20 B6O-RingLA412505SleeveLA220X160A20B6O-RingLA555033DiaphragmLA555070Diaphragm2103001-001AArmcap Assy1001700-4REFRIGERATION PACK, ERJ170 - KIT14330-243JAGearhead Assy14330-062JAMotor Assy15800-155JALabel, Motor ID69494J12WEPacking, Preformed69494J910WEPacking PreformedADV-TNK-04Welded Tank AssemblyADV-TNK-04Welded Tank Assembly31-9172-1EHStrobe Light, Lamp31-8321-1EHFlashtube Lamp170-35163-004SDSeal Lower O/B170-39443-405SDFrame 1 Assy170-39443-406SDFrame 1 Assy170-35161-004SDSeal Lower TR1170-35162-003SDSeal Lower TR2170-35160-003SDSeal Lower I/B170-35163-003SDSeal Lower O/B170-35160-004SDSeal Lower I/B170-35162-004SDSeal Lower TR2170-35161-003SDSeal Lower TR114330-070JAGear Assy, Plate Positioning14330-073JAGear Assy, Switch Actuating1001050-5-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-1-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-6-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-3-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-4-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-2-017AMS PROCESSOR CARD WITH SOFTWARE BL 151001050-7-017AMS PROCESSOR CARD WITH SOFTWARE BL 15JA51721Bearing, Cylinder BarrelJA24759Bearing, IDSNSL1776M B1/2SealantNSL1428 B1/2SealantNSL1776M-B2SealantNSL1428 B2SealantAD-5483-46-1Cradle41391400Paper41391801Paper41391500Paper41391550Paper41391601Paper4093376-1Paper41391600Paper
Back to Embraer ERJ 170-100 STD