This is a story related trophy and therefore, cannot be missed. The Scrapyard (known as Earl's Scrapyard) is located in the Rust Commons West. The best way to get this is to simply play out the main story mission. Once you enter Earl's Scrapyard, the trophy will unlock.
Happy Hunting :)