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.
SDI15800-357-2Poppet AssemblySDI15800-359-2SeatCP44346Oxley PAR 64 LED Landing Light170-55019-401UPPER DISTRIBUTION RISERCP44346-ACOxley PAR 64 LED Landing LightCP45324Oxley PAR 64 LED Landing LightAPM170-33181-001SealAPM170-33181-002Seal2805489-4EHHousing Assembly, ScrollJA51725-01Hanger3179383-1KTBearing887986-4JAClip, RetainingAPM10-9126-01Bushing69494J904WEPacking, Preformed69494J6WECont. Packing, Preformed69494J906WEPacking, Preformed69494J908WEPacking, Preformed808574-6WEFilter-Air770391WEWasher-Flat767452WEShaftSG-E170-SSUL-100-BLULiTeMood LED Cabin Lighting SystemSG-E170-SS-100-GRNLiTeMood LED Cabin Lighting SystemSG-E170-SSL-100-GRNLiTeMood LED Cabin Lighting SystemSG-E170-SSUL-100-GRNLiTeMood LED Cabin Lighting SystemAPM14G0659-207Drain Mast SealAPM14G0659-208Drain Mast SealAPM170-34137-001Bushing, StraightRD1001232-1Bearing - Thrust - Fan EndRD1001241-1Bearing - Journal AssemblyRD1001231-1Bearing - Thrust - Turbine EndJ1212P04EHNut Self-LockingJ1212P05EHNut Self-Locking55-2181-7EDCHalogen LampEEZZ05-0011-00Complete Assembly, Trailing Edge, Winglet, 170/190EEHS01-0002-00Harness, Winglet 170/190, Trailing EdgeEEZZ05-0017-00Complete Assembly, Leading Edge, Winglet, 170 LHSEEZZ05-0018-00Complete Assembly, Leading Edge, Winglet, 170 RHSLA419628Block, Locking738300WEGear-SpurLA47886-13Track AssyLA5133-25Ring, RetainingLA4036BracketLA4036Bracket21FA520GHEPA Filter Anti-MicrobialVA-2530-H01Immersion Stick Heater Assy10-9124-01Bushing96073-09Strut Assy, Right, Top APU Isolator96073-15Isolator, APU, Side, RH96073-12Bracket, Attachment, Side96073-11Conebolt, Attachment
Back to Embraer ERJ 170-100 STD