SELECT DISTINCT m.PartNumber FROM bmnew.mapping m INNER JOIN dpbrands.partslifecycle pl ON m.partNumber = pl.PartNumber and (pl.Status<>'8') WHERE m.PartNumber != '' AND MainCat = 'Differential Covers' AND SubCat1 = 'AAM 10.5' ORDER BY m.Rank ASC,m.PartNumber ASC LIMIT 0,15
Differential Cover, AAM 10.5, Extra Capacity, A356.0-T6 Cast Aluminum, Black Anodized, Drain/Fill ports, Magnetic Drain Plug....more details
Part #: 11316
Price: $241.53
Qty: