Shakia's "Hips Don't Lie" is a fairly example of a hit song with a trumpet. Although that is a sample from a salsa song... Of course there lots current Latin stuff that features horns, especially trumpet and trombone.