How to get meta data from custom category name

I want to get meta data by custom post type category name.

Right now i am getting all meta data but i want specific for each category

$partSql = $wpdb-get_results("SELECT * FROM ".$wpdb-prefix."postmeta WHERE meta_key = 'prd_part_no'", ARRAY_A);