Find
My Enquiry  0
select Makes.Make, Vehicles.Model, r5u3z_parts_aliases_model.model_alias, r5u3z_parts_aliases_make.make_alias, ChassisGroups.GroupName, ProductApplications.ProductNr, Products.SupplierCategory2, Products.Description, Products.PRetailsDescription, ProductApplications.PARetailsDescription, ProductApplications.PAFootNote1, ProductApplications.PAFootNote2, ProductApplications.PAFootNote3, ProductApplications.LfdNr, Outcome, GROUP_CONCAT(DISTINCT ProductApplications.Outcome ORDER BY ProductApplications.Outcome SEPARATOR ', ') as OutcomeMerge From ProductApplications inner join Vehicles on Vehicles.VehicleID = ProductApplications.VehicleID INNER join Makes on Makes.ID = Vehicles.MakeID left join r5u3z_parts_aliases_make on Makes.Make = r5u3z_parts_aliases_make.make_parts left join r5u3z_parts_aliases_model on Vehicles.Model = r5u3z_parts_aliases_model.model_parts RIGHT join Products on Products.ProductNr = ProductApplications.ProductNr inner join ChassisGroups on ProductApplications.ChassisGroupID = ChassisGroups.ID where ProductApplications.ProductNr LIKE 'Ab1014r' group by Make, GroupName order by Make, Model, GroupName

AB1014R

Full Airbag Assembly Rear Mercedes-Benz

Product Information

Replaces:

A1643200925, A1643201025, A1643200825, A1663200625, A1663200325, A1643200625, A1643200225, A1643200425, A1643200725

1643200925, 1643201025, 1643200825, 1663200625, 1663200325, 1643200625, 1643200225, 1643200425, 1643200725

Fitment:

  • Sold individually

 

PaymentFooterMobile