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.
41391650Paper2007610-003Paper41389401Paper62000665-1PaperA2017588Paper41391800Paper41389312Paper41391510Paper41391651Paper2007610-001Paper41391410Paper41389313Paper41391450PaperM713225-111Paper Roll2381H000-001Switch, Temperature2352H000-002Filter, Case Drain2346H000-007Filter Manifold2353H000-003Reservoir, Hydraulic2377H000-002Reservoir, Hydraulic2342H000-001Reservoir, Hydraulic2341H000-003Reservoir, Hydraulic8851C000-001Heat Exchanger2344H000-001Valve, Bypass, Heat2343H000-001Switch, Pressure2345H000-003Filter ManifoldTAE0728-1Par 64 Lamp Cool SpotTAE0528-2WPar 36 Lamp Warm WideTAE0528-1WPar 36 Lamp Warm SpotTAE0528-2Par 36 Lamp Cool WideTAE0528-1Par 36 Lamp Cool SpotTAE0528-1XPar 36 Lamp Cool Spot Hi Intensity751-1003-001Hoffman Performance Lighting Paradigm(tm) PAR64 LED Landing Light751-1004-001Hoffman Performance Lighting Paradigm(tm) PAR64 LED Landing Light1001235-2NETurbine End Shaft1001236-1WEFan-Cooling4260-0018-5Thrust Control Quadrant14330-095-1JASwitch (Close Position)VA-2530-R01Electro-Mechanical Relay14330-063JASwitch and Harness Assy3205-20-1JAGrommetVA-2530-T03Water Tank Welded Assy14330-095-2JASwitch (Open Position)14330-067JABracket, Switch MountSP3558-51-1500O-RingAG627000-02Gasket - Marker Beacon AntennaAG477000-17Gasket - GPS Antenna1001228-1WERod-TieJA51722Barrel, CylinderM4900397-3Bearing69494J12WEPacking, Preformed
Back to Embraer ERJ 170-100 STD