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.
LA69494J342Packing PreformedAD-549-1548-01Cell, StorageAD-549-1548-01Cell, StorageJA753095Bearing - Journal738427WEGear-Planet804-1250-10avRDC QARJA770386-2Bearing - JournalJA768007-1Bearing - JournalJA753314-3Bearing - JournalNP-187301-18Windshield, RHNP-187301-17Windshield, LHJA753311-1Bearing - JournalLA170-96074-401Strap HandleLA170-96074-401Strap Handle24777WDPort PlateLA146403VStop PadB21507-03Cylinder7600005-101Filter ElementFW210702-004ABumper AssemblyFW210301-001BArmcapFW210901-001AEscutcheonFW210702-003ABumper Assembly91673Filter ElementFW210702-001ABumper AssemblyFW210702-002ABumper Assembly2104001-001ASShroud, InnerS810186-14WESeal-LandS810186-15WESeal-Land1001227-21WESeal-LandS810186-16WESeal-Land51725-01WDHangerLA170-62218-003Bushing PlainLA4800-202Guard SwitchLA170-07818-001Profile, Cover FixationLA170-07813-405Cover Seal AssemblyLA4800-202Guard Switch9-3179505-1Diaphragm9-884879-11Plate Backing9-3182175-1Diaphragm AssemblyAPM170-39811-001Bushing, Clamp756469WEPlug763330WEWobbler-Fixed755329WEBall - Slipper Retainer1001070-5AMS Motor Driver Board1001060-5AMS Low Level I/O Board1001050-7-015AMS Processor Card with Software BL4421003-001Altitude SwitchLA170-08021-901SealLA180601-120-2Armrest Command RodLA170-34130-001Bushing
Back to Embraer ERJ 170-100 STD