Embraer S A ERJ 190-200 IGW
PMA parts · 2,706
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 ('A57NM')
AND len(list_intersect(tcds_models, ['ERJ 190-200 IGW'])) > 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 ('A57NM')
AND len(list_intersect(tcds_models, ['ERJ 190-200 IGW'])) > 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.
738368WEBlock - Cylinder52-61514314-1Pressure Switch, Parking Brake, SteelEEZZ05-0033-00Leading Edge Bracket Assembly, ACLEEZZ05-0032-00Leading Edge Bracket Assembly, ACLEEZZ05-0021-00Trailing Edge LED Light AssemblySP3832-02-4056POPPET VALVE9143FR-0325Corrosion Prevention Sealing Tape9143FR-0100Corrosion Prevention Sealing Tape9143FR-0315Corrosion Prevention Sealing Tape9143FRCorrosion Prevention Sealing Tape9143FR-0200Corrosion Prevention Sealing TapeL507949-20629ConeL610549-20629ConeL507910-20629CupL610510-20629Cup2805419-1MITImpellerEAI-4312-990-EMBRoller Shade AssemblyEAI-4311-990-EMBRoller Shade Assembly14401-029SMIFilterRD1001233-1Support- Tie RodRD1001237-2Ring, Fan RotorRD1001228-1Rod-TieRD1001222-1Nozzle- Turbine First StageRD1016041-1Nozzle- Turbine Second StageAST17845-1External Power Receptacle ShieldAAP-3502129-1Bearing821170-1WESpring-HelicalJA69494J128Packing, PreformedAAP-778839-47BushingAAP-778839-48Bushing171-54336-605Manifold Kit Three Person Square ODU Rework171-54336-601Manifold Kit Two Person ODU Rework171-54339-601Placard Kit ODU Rework170-44407-601Vacuum Toilet Retrofit Kit19000-195-3Drain Mast Heated Water System171-52729-603Fire Extinguisher
Sb Kit171-52729-601Fire Extinguisher
Sb Kit171-54336-603Manifold Kit Three Person Triang ODU Rework14330-380Valve, Flush, Assy – Plastic
- Leading Edge Plus190-95081-401Pax Seat Instl191-40908-401Floor Mat Instl Kit190-40079-405Finishing Instl FWD Bag Compt190-90410-411Bulkhead Instl Kit Aft Rh190-44409-417Tank Assy Waste Vacuum System170-45412-405Psu Panel Assy - 12 Min 3 Mask Lhs170-41814-423Lining Instl Kit Aft Service Door190-97026-401Placard Kit Plastic170-47714-403Insulation Instl AFT Service Door170-45413-405Psu Panel Assy - 12 Min 3 Mask Rhs191-43240-401Floor Panel Instl
Back to Embraer S A ERJ 190-200 IGW