Google has indexed your site perfect as expected and rather quickly too as mentioned in comment. Google will always try to return results from other sites if you do not use the site:youdomain.com your-url-or-keyword-here
so at the moment I am seeing pages being returned from your site, if it doesn't pop up then you define the search more, Since Google is treating your search a broad search and often will return results from what it feels is the best result to the person searching.
Using your own search term as an example http://www.ahparts.com/buy-used/1991-Acura-NSX-HOOD-BLACK-60100-SL0-A90ZZ/57923
I search using ahparts.com HOOD BLACK 60100-SL0-A90ZZ
Google Search Webmasters http://www.bybe.net/downloads/google-search-webmasters01.jpg
Now as you can see above you was hoping that the URL of the actual black hood would be returned but instead of has returned the parent page... This is purely because Google believes that the parent page is more valuable to the searcher, this is purely because the actual hood page is being treated as 'thin content', you have some pictures and very little text for Google to go off on... So if you want these pages ranking better it's time to write more content on those pages as the parent pages are giving better siginals to Google and is being preferred by Google. (Using a broad search such as ahparts.com often will only return 1-2 results max of your site).
Now let's try doing this search with site:ahparts.com HOOD BLACK 60100-SL0-A90ZZ
Google Search Webmasters http://www.bybe.net/downloads/google-search-webmasters02.jpg
As you can see both pages are now found this is because Google now knows that you only want results from your domain and it's disgrading what they believe is best for you and just matching everything possible on the site.
Fatter Content
If you want your pages ranking better then its simply the case of beefing up your pages, the parent page in comparision to the hood page that you would think Google would prefer is not because of the thin content, you can have a million pictures and Google will still prefer the text content page since its able to verify the page contents more. So I understand theres so much you can write about a hood but maybe list the things like the metal type, and some other details from the stickers on the back, its not my field so I wouldn't have a clue but for sure beefing up the pages will only increase your rankings.
Page Problems
You also have some major page problems which could be causing Google to rank the pages incorrectly, on the front page for example you have JavaScript before the HTML and HEAD tags, this can cause all types of problems for search engines nevermind the end customers. This problem actually gets worse thoughout the site:
Referring to the example page we used take a look at this:
<html>
<head>
<title>Buy $850 1991 Acura NSX trim(HOOD BLACK 60100-SL0-A90ZZ) Sale # 57923</title>
<LINK REL='SHORTCUT ICON' HREF='http://www.ahparts.com/images/ahparts.ico'>
<meta name='description' content='57923 For sale - Buy 1991 Acura NSX HOOD BLACK 60100-SL0-A90ZZ - Used Category: Hoods - Online OEM Honda & Acura auto wrecker recyclers! We search our scrap yard & pull for free. Computerized dismantlers inventory & WORLDWIDE SHIPPING! From body to mechanical parts, we salvage almost anything. Buy from our junkyard & save big by avoiding dealer pricing!'>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML><HEAD>
<LINK REL='SHORTCUT ICON' HREF='http://www.ahparts.com/images/ahparts.ico'>
<title>Used Honda Acura Parts 877-859-0023 Auto Wreckers Recyclers - Discounted Cheap</title>
<meta name="description" content="Your specialized OEM Honda & Acura auto wrecker recyclers! We search our scrap yard & pull for free. Computerized dismantlers inventory & WORLDWIDE SHIPPING! From body to mechanical parts, we salvage almost anything. Buy discounted & cheap from our junkyard. Save big by avoiding dealer pricing!">
<meta name="keywords" content="specialized, used, OEM, Honda, Acura, auto wreckers, recyclers, scrap yard, dismantlers, inventory, WORLDWIDE SHIPPING, body, mechanical parts, salvage, junkyard, save, avoid dealer pricing">
You should never have more than one head and content must always be wrapped within the HTML tag, also you should take w3c validation very seriously - not only can this help search engines rank your pages easier it ensures that your end customers hardly get any problems. 1-2 errors is generally not a problem depending if they are not major ones which you have but at present you have over 298 errors which you should get resolved.
http://validator.w3.org/check?uri=http%3A%2F%2Fwww.ahparts.com%2Fused-parts.php%3Fid%3D13015&charset=%28detect+automatically%29&doctype=Inline&group=0