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.
H158008-600HP-2Hose Assembly158506-601CDNippleH158008-600HP-5Hose AssemblyH158006-600CD-2Hose Assembly158508-601HPNippleH158008-600HP-4Pipe PressureH158006-600CD-1Case Drain Assembly415600-1011Elevator Primary158512-601HRNipple3R1208BAileron Load Cell3R1223AElevator Load Cell2R7218DPrimary Actuation System2R2208BAirstairs Backup Actuator3R1222ARudder Load Cell3R1209BRudder Loud Cell3R1210BElevator Load Cell3E1524BLanding Gear Feedback Position Sensor3R1221AAileron Load CellNSL890RC A2SealantNSL1440RC A1/2SealantNSL1440RC B1/2SealantNSO870 B2SealantNSL870 B1/2SealantNSL890RC B1/2SealantNSL1440RC B2SealantNSL890RC B2SealantNSL1422RC A2SealantNSL1440RC A2Sealant425900-1001Column Command LVDT HannelCM3179383-1Ball Bearing1014023-1PANEL, HEATED FLOOR, FWD GALLEY9-49C09Spring, Retaining1014021-1PANEL, HEATED FLOOR, FWD GALLEY1014022-1PANEL, HEATED FLOOR, FWD GALLEYSP2510-00-5070SocketSP2510-00-5070SocketSP2510-00-5005RelaySP2510-00-5005Relay1716280ADisconnect Sensor Outline, Left Slat1716282ADisconnect Sensor Outline, Right Slat7-45827-1Park Brake Ball Bearing Control 13,45 Meters7-45736-1Park Brake Ball Bearing Control 12,6 Meters7-45736-1Park Brake Ball Bearing Control 12,6 Meters7-45827-1Park Brake Ball Bearing Control 13,45 Meters7-45726-2Emergency Brake Control Handle7-45726-2Emergency Brake Control HandleNP-187301-12Windshield, R/H, HeatedNP-187301-9Windshield, L/HSD028-234SDSealPE 5483-24-09Rear Housing
Back to Embraer ERJ 170-100 STD