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.
15E0816003Pump Hose AssemblyA9660-3Hose AssemblyIFE64621W64621W LED LampIFE64621W64621W LED LampIFE64621W64621W LED LampAVUS1001233-1Support, Tie RodAG846000-31Gasket - VHF AntennaM713225-111Paper Roll6007300MTSensor- Brake TemperatureP18700AACUB SoftwareP13237AACU SoftwareP34700acWAP SoftwareP14135Handset v0.3 & v0.4 SoftwareP14135Cabin Phone w/CLD SoftwareP34800acWAP (A628) SoftwareP24000Compact Flash Memory Card SoftwareP16289SACL SoftwareP17878ATG4000 SoftwareP25000ACPU-2 SoftwareP18571NWAP SoftwareP16289SACL-PF SoftwareP18800ATG4000B SoftwareP14171CWAP SoftwareP30238CFast Memory Card Software18990ACMU SoftwareP13372Handset v0.2 SoftwareP13238CWAP SoftwareP16289Cabin Phone w/CLD SoftwareP13236ACPU Software16972-BELPrecooler Outlet SealSDICDSP5801-1ALWasherSDICDSP5801-2ALWasherM739951Terminal BlockM739953Terminal Block CoverSDICDSP5801-3ALWasherASG170-31408-901Brush170-39321-006SDRail, Aft170-39321-005SDRail, Aft768026-3WEBushing - Threaded1701930WECylinder Block And Piston-Matched Set (Bare Bore)1700214WEBlock-Cylinder (Bare Bore)171-03339-901LASeal, Silicone Slat 4171-03339-902LASeal, Silicone Slat 4, Outbd1001233-1NESupport - Tie RodHA2643-1Folding Strut Assembly121-11866-1( )Acoustic Pane122-11186-1( )Shade1001238-1NENut - Balancing1001237-2NERing - Fan RotorHA261-1-15Latch Assembly, Adj Pressure Relief
Back to Embraer ERJ 170-100 STD