{"current_page":1,"data":[{"id":12296127,"change_date":"2026-06-27 21:41:00","inspection_id":"88252937","dot_number":"3576734","report_state":"OR","report_number":"AP08170816","insp_date":"2026-06-25 00:00:00","insp_start_time":"1545","insp_end_time":"1606","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAFEWAY","shipping_paper_number":"47208","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3628777","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:06.000000Z","updated_at":"2026-07-02T09:38:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21357604,"change_date":"2026-06-27 21:41:00","inspection_id":"88252937","insp_unit_id":"214315219","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:19.000000Z","updated_at":"2026-07-02T09:13:48.000000Z"},{"id":21357605,"change_date":"2026-06-27 21:41:00","inspection_id":"88252937","insp_unit_id":"214315220","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B102","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:19.000000Z","updated_at":"2026-07-02T09:13:48.000000Z"}]},{"id":12176003,"change_date":"2026-06-12 21:42:00","inspection_id":"88130911","dot_number":"3576734","report_state":"CA","report_number":"UDAJ003512","insp_date":"2026-06-12 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"PS","ci_status_code":"C","location":"135","location_desc":"CA","county_code_state":"CA","county_code":"089","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3531753","transaction_code":"A","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-06-12 21:42:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:40.000000Z","updated_at":"2026-06-23T09:31:24.000000Z","inspection_violations":[{"id":21190016,"change_date":"2026-06-12 21:42:00","inspection_id":"88130911","insp_violation_id":"274881818","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214077999","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:06:24.000000Z","updated_at":"2026-06-23T09:43:16.000000Z","normalized_code":"3922SLLSR"},{"id":21190017,"change_date":"2026-06-12 21:42:00","inspection_id":"88130911","insp_violation_id":"274881819","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214077999","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:06:24.000000Z","updated_at":"2026-06-23T09:43:16.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":21149383,"change_date":"2026-06-12 21:42:00","inspection_id":"88130911","insp_unit_id":"214077999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"EP22350","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1HTMMMML2KH604092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:48.000000Z","updated_at":"2026-06-23T09:03:18.000000Z"}]},{"id":11951832,"change_date":"2026-05-18 21:39:00","inspection_id":"87887555","dot_number":"3576734","report_state":"CA","report_number":"UEA3001480","insp_date":"2026-05-14 00:00:00","insp_start_time":"2020","insp_end_time":"2041","registration_date":null,"region":"PS","ci_status_code":"C","location":"131","location_desc":"CA","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"WILDWOOD TRADING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3354197","transaction_code":"A","transaction_date":"2026-05-18 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-05-18 21:39:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-18 21:39:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-21T09:41:09.000000Z","updated_at":"2026-05-29T09:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20782057,"change_date":"2026-05-18 21:39:00","inspection_id":"87887555","insp_unit_id":"213622509","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"Y","insp_unit_decal_number":"36167577","created_at":"2026-05-21T09:20:34.000000Z","updated_at":"2026-05-29T09:03:06.000000Z"},{"id":20782056,"change_date":"2026-05-18 21:39:00","inspection_id":"87887555","insp_unit_id":"213622508","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"Y","insp_unit_decal_number":"36167576","created_at":"2026-05-21T09:20:34.000000Z","updated_at":"2026-05-29T09:03:06.000000Z"}]},{"id":11641499,"change_date":"2026-04-14 21:39:00","inspection_id":"87570668","dot_number":"3576734","report_state":"OR","report_number":"AP43051002","insp_date":"2026-04-14 00:00:00","insp_start_time":"1321","insp_end_time":"1346","registration_date":null,"region":"PD","ci_status_code":"C","location":"15-07","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KRAFT HEINZ COMPANY","shipping_paper_number":"0161393","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3156107","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-04-14 21:39:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-14 21:39:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-25T09:30:44.000000Z","updated_at":"2026-04-25T09:30:44.000000Z","inspection_violations":[{"id":20212583,"change_date":"2026-04-14 21:39:00","inspection_id":"87570668","insp_violation_id":"273589275","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPDELDT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:41:58.000000Z","updated_at":"2026-04-25T09:41:58.000000Z","normalized_code":"3958EHOSPDELDT"}],"inspection_per_units":[{"id":20250327,"change_date":"2026-04-14 21:39:00","inspection_id":"87570668","insp_unit_id":"213005116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:20.000000Z","updated_at":"2026-04-25T09:03:20.000000Z"},{"id":20250328,"change_date":"2026-04-14 21:39:00","inspection_id":"87570668","insp_unit_id":"213005117","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B102","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:20.000000Z","updated_at":"2026-04-25T09:03:20.000000Z"}]},{"id":11548324,"change_date":"2026-04-01 21:40:00","inspection_id":"87471049","dot_number":"3576734","report_state":"CA","report_number":"UEGH000998","insp_date":"2026-03-31 00:00:00","insp_start_time":"0915","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KRAFT","shipping_paper_number":"2102630820","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16230331","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-04T09:43:39.000000Z","updated_at":"2026-04-12T09:33:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19788023,"change_date":"2026-04-01 21:40:00","inspection_id":"87471049","insp_unit_id":"212491359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111\/MAR","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:53.000000Z","updated_at":"2026-04-12T09:12:19.000000Z"},{"id":19788024,"change_date":"2026-04-01 21:40:00","inspection_id":"87471049","insp_unit_id":"212491360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102\/WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:53.000000Z","updated_at":"2026-04-12T09:12:19.000000Z"}]},{"id":11256713,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","dot_number":"3576734","report_state":"WA","report_number":"2101000702","insp_date":"2026-02-23 00:00:00","insp_start_time":"1101","insp_end_time":"1145","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC77","location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HAMPTON LUMBER SALES","shipping_paper_number":"2096127","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-28 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2946492","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2026-02-28 21:34:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-28 21:34:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-03T10:39:20.000000Z","updated_at":"2026-03-11T09:30:14.000000Z","inspection_violations":[{"id":18915287,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","insp_violation_id":"272113066","seq_no":"1","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"2","insp_unit_id":"211897281","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-03T10:57:03.000000Z","updated_at":"2026-03-11T09:38:48.000000Z","normalized_code":"39375GTAOW"},{"id":18915288,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","insp_violation_id":"272113067","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-03T10:57:03.000000Z","updated_at":"2026-03-11T09:38:48.000000Z","normalized_code":"3922SLLEWA3"},{"id":18915289,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","insp_violation_id":"272113068","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T00015057","created_at":"2026-03-03T10:57:03.000000Z","updated_at":"2026-03-11T09:38:48.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":19247797,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","insp_unit_id":"211897280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"110","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:13.000000Z"},{"id":19247798,"change_date":"2026-02-28 21:34:00","inspection_id":"87170236","insp_unit_id":"211897281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-03T10:15:29.000000Z","updated_at":"2026-03-11T09:02:13.000000Z"}]},{"id":10308783,"change_date":"2025-11-30 21:33:00","inspection_id":"86434981","dot_number":"3576734","report_state":"WA","report_number":"2105004750","insp_date":"2025-11-25 00:00:00","insp_start_time":"1903","insp_end_time":"1925","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SENSIO INC","shipping_paper_number":"071566340020946","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2601016","transaction_code":"A","transaction_date":"2025-11-30 00:00:00","upload_date":"2025-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-11-30 21:33:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-30 21:33:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-03T10:30:22.000000Z","updated_at":"2025-12-04T10:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17214407,"change_date":"2025-11-30 21:33:00","inspection_id":"86434981","insp_unit_id":"210307861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:25.000000Z","updated_at":"2025-12-04T10:00:16.000000Z"},{"id":17214408,"change_date":"2025-11-30 21:33:00","inspection_id":"86434981","insp_unit_id":"210307862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B102","insp_unit_license":"94732AD","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-03T10:00:25.000000Z","updated_at":"2025-12-04T10:00:16.000000Z"}]},{"id":10086341,"change_date":"2025-10-30 21:43:00","inspection_id":"86201155","dot_number":"3576734","report_state":"CA","report_number":"NEKW003940","insp_date":"2025-10-30 00:00:00","insp_start_time":"0932","insp_end_time":"0952","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KRAFT HEINZ","shipping_paper_number":"2099245320","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16040693","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-10-30 21:43:00","snet_input_date":"2025-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-30 21:43:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:26.000000Z","updated_at":"2025-11-03T11:04:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16766820,"change_date":"2025-10-30 21:43:00","inspection_id":"86201155","insp_unit_id":"209757577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHITE","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"Y","insp_unit_decal_number":"35606969","created_at":"2025-11-02T10:47:44.000000Z","updated_at":"2025-11-03T10:47:04.000000Z"},{"id":16766821,"change_date":"2025-10-30 21:43:00","inspection_id":"86201155","insp_unit_id":"209757578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHITE","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:44.000000Z","updated_at":"2025-11-03T10:47:04.000000Z"}]},{"id":9924114,"change_date":"2025-10-13 21:37:00","inspection_id":"86029758","dot_number":"3576734","report_state":"OR","report_number":"AP90170413","insp_date":"2025-10-13 00:00:00","insp_start_time":"1014","insp_end_time":"1054","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COLUMBIA RIVER CARBONATES","shipping_paper_number":"706479","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2403327","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-10-13 21:37:00","snet_input_date":"2025-10-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-13 21:37:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:36.000000Z","updated_at":"2025-10-17T10:00:32.000000Z","inspection_violations":[{"id":16378391,"change_date":"2025-10-13 21:37:00","inspection_id":"86029758","insp_violation_id":"269260782","seq_no":"1","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"209434398","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-16T10:15:54.000000Z","updated_at":"2025-10-17T10:15:56.000000Z","normalized_code":"39021TE2IVD"}],"inspection_per_units":[{"id":16471323,"change_date":"2025-10-13 21:37:00","inspection_id":"86029758","insp_unit_id":"209434398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:46.000000Z","updated_at":"2025-10-17T09:45:41.000000Z"},{"id":16471324,"change_date":"2025-10-13 21:37:00","inspection_id":"86029758","insp_unit_id":"209434399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B102","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-16T09:45:46.000000Z","updated_at":"2025-10-17T09:45:41.000000Z"}]},{"id":9660653,"change_date":"2025-09-12 21:50:00","inspection_id":"85753084","dot_number":"3576734","report_state":"CA","report_number":"UEIK000501","insp_date":"2025-09-10 00:00:00","insp_start_time":"0922","insp_end_time":"0932","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARGO NUT COMPANY","shipping_paper_number":"023395","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15976281","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-09-11 21:42:00","snet_input_date":"2025-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:48:09.000000Z","updated_at":"2025-09-16T10:48:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16002142,"change_date":"2025-09-12 21:50:00","inspection_id":"85753084","insp_unit_id":"208926763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111\/BERG","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:36.000000Z"},{"id":16002143,"change_date":"2025-09-12 21:50:00","inspection_id":"85753084","insp_unit_id":"208926764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102\/WHI","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:54:04.000000Z","updated_at":"2025-09-16T09:56:36.000000Z"}]},{"id":9347035,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","dot_number":"3576734","report_state":"CA","report_number":"NFDX001058","insp_date":"2025-08-05 00:00:00","insp_start_time":"1726","insp_end_time":"1948","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KRAFT HEINZ FOODS CO","shipping_paper_number":"2097191830","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15927117","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"4202 N MARUYAMA AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"581707","created_at":"2025-08-12T10:42:24.000000Z","updated_at":"2025-08-12T10:42:24.000000Z","inspection_violations":[{"id":15176288,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_violation_id":"267878840","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208271704","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-09T10:45:26.000000Z","updated_at":"2025-08-10T10:44:21.000000Z","normalized_code":"3963A1BOS"},{"id":15176289,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_violation_id":"267878841","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208271704","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA251019","created_at":"2025-08-09T10:45:26.000000Z","updated_at":"2025-08-10T10:44:21.000000Z","normalized_code":"39347E"},{"id":15176290,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_violation_id":"267878842","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"208271704","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:26.000000Z","updated_at":"2025-08-10T10:44:21.000000Z","normalized_code":"39353BB"},{"id":15176291,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_violation_id":"267878843","seq_no":"4","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"208271704","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA251019","created_at":"2025-08-09T10:45:26.000000Z","updated_at":"2025-08-10T10:44:21.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":15396578,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_unit_id":"208271704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"RED\/111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:24.000000Z","updated_at":"2025-08-10T09:46:12.000000Z"},{"id":15396579,"change_date":"2025-08-06 21:40:00","inspection_id":"85423906","insp_unit_id":"208271705","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHT\/B102","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"Y","insp_unit_decal_number":"35350146","created_at":"2025-08-09T09:46:24.000000Z","updated_at":"2025-08-10T09:46:12.000000Z"}]},{"id":8048657,"change_date":"2025-03-06 21:40:00","inspection_id":"84054829","dot_number":"3576734","report_state":"CA","report_number":"NCT2006787","insp_date":"2025-02-28 00:00:00","insp_start_time":"1637","insp_end_time":"1651","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ERI","shipping_paper_number":"R318942","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15729904","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-03-06 21:40:00","snet_input_date":"2025-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-06 21:40:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:24.000000Z","updated_at":"2025-03-17T21:05:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12994339,"change_date":"2025-03-06 21:40:00","inspection_id":"84054829","insp_unit_id":"205669168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:32.000000Z","updated_at":"2025-03-17T23:58:32.000000Z"},{"id":12994340,"change_date":"2025-03-06 21:40:00","inspection_id":"84054829","insp_unit_id":"205669169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:32.000000Z","updated_at":"2025-03-17T23:58:32.000000Z"}]},{"id":7985704,"change_date":"2025-02-27 21:42:00","inspection_id":"83988675","dot_number":"3576734","report_state":"CA","report_number":"NCT2006783","insp_date":"2025-02-24 00:00:00","insp_start_time":"1848","insp_end_time":"1904","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"INTERFOR","shipping_paper_number":"2282837","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15720101","transaction_code":"A","transaction_date":"2025-02-24 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-02-27 21:42:00","snet_input_date":"2025-02-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-27 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:03.000000Z","updated_at":"2025-03-17T21:04:03.000000Z","inspection_violations":[{"id":12478010,"change_date":"2025-02-27 21:42:00","inspection_id":"83988675","insp_violation_id":"264750175","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205548479","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:56.000000Z","updated_at":"2025-03-17T22:06:56.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":12891828,"change_date":"2025-02-27 21:42:00","inspection_id":"83988675","insp_unit_id":"205548479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"},{"id":12891829,"change_date":"2025-02-27 21:42:00","inspection_id":"83988675","insp_unit_id":"205548480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"Y","insp_unit_decal_number":"34757848","created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"}]},{"id":7839878,"change_date":"2025-02-19 21:40:00","inspection_id":"83835893","dot_number":"3576734","report_state":"OR","report_number":"AP42930350","insp_date":"2025-02-11 00:00:00","insp_start_time":"1205","insp_end_time":"1228","registration_date":null,"region":"PS","ci_status_code":"C","location":"15-07","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MONTERY","shipping_paper_number":"257099","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1350233","transaction_code":"C","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-02-11 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-11 21:39:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:49.000000Z","updated_at":"2025-03-17T21:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12652817,"change_date":"2025-02-19 21:40:00","inspection_id":"83835893","insp_unit_id":"205391270","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"110","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"},{"id":12652818,"change_date":"2025-02-19 21:40:00","inspection_id":"83835893","insp_unit_id":"205391271","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B101","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:45.000000Z","updated_at":"2025-03-17T23:54:45.000000Z"}]},{"id":7611125,"change_date":"2025-01-14 21:53:00","inspection_id":"83595521","dot_number":"3576734","report_state":"OR","report_number":"AW34240130","insp_date":"2025-01-13 00:00:00","insp_start_time":"1527","insp_end_time":"1557","registration_date":null,"region":"PS","ci_status_code":"C","location":"10-07","location_desc":"MYRTLE CREEK OR","county_code_state":"OR","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RELIABLE PRODUCTS","shipping_paper_number":"2184321","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-14 21:53:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243708","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2025-01-14 21:53:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:53:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:08.000000Z","updated_at":"2025-03-17T20:56:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12281043,"change_date":"2025-01-14 21:53:00","inspection_id":"83595521","insp_unit_id":"204791773","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"},{"id":12281044,"change_date":"2025-01-14 21:53:00","inspection_id":"83595521","insp_unit_id":"204791774","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B102","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7086940,"change_date":"2024-10-31 21:41:00","inspection_id":"83042996","dot_number":"3576734","report_state":"OR","report_number":"AP01040103","insp_date":"2024-10-30 00:00:00","insp_start_time":"1830","insp_end_time":"1851","registration_date":null,"region":"PD","ci_status_code":"C","location":"10-07","location_desc":"MYRTLE CREEK OR","county_code_state":"OR","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ERI","shipping_paper_number":"R313377","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1002429","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2024-10-31 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-31 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:51.000000Z","updated_at":"2025-03-17T20:43:51.000000Z","inspection_violations":[{"id":11065233,"change_date":"2024-10-31 21:41:00","inspection_id":"83042996","insp_violation_id":"262650358","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:43.000000Z","updated_at":"2025-03-17T21:59:43.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":11429656,"change_date":"2024-10-31 21:41:00","inspection_id":"83042996","insp_unit_id":"203668100","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"110","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:20.000000Z","updated_at":"2025-03-17T23:41:20.000000Z"},{"id":11429657,"change_date":"2024-10-31 21:41:00","inspection_id":"83042996","insp_unit_id":"203668101","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B101","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:20.000000Z","updated_at":"2025-03-17T23:41:20.000000Z"}]},{"id":6935698,"change_date":"2024-10-10 21:42:00","inspection_id":"82882464","dot_number":"3576734","report_state":"CA","report_number":"NEKW002670","insp_date":"2024-10-10 00:00:00","insp_start_time":"0903","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARO NUT COMPANY","shipping_paper_number":"BOL021173","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15552006","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2024-10-10 21:42:00","snet_input_date":"2024-10-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-10 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:40.000000Z","updated_at":"2025-03-17T20:40:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11186013,"change_date":"2024-10-10 21:42:00","inspection_id":"82882464","insp_unit_id":"203363650","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"Y","insp_unit_decal_number":"34457545","created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"},{"id":11186014,"change_date":"2024-10-10 21:42:00","inspection_id":"82882464","insp_unit_id":"203363651","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:50.000000Z","updated_at":"2025-03-17T23:38:50.000000Z"}]},{"id":6295028,"change_date":"2024-07-24 21:41:00","inspection_id":"82199558","dot_number":"3576734","report_state":"OR","report_number":"AW43320029","insp_date":"2024-07-24 00:00:00","insp_start_time":"1023","insp_end_time":"1052","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALPHIA","shipping_paper_number":"BOL110623","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"682480","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:25.000000Z","updated_at":"2025-03-17T20:27:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10143239,"change_date":"2024-07-24 21:41:00","inspection_id":"82199558","insp_unit_id":"202041086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"110","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:04.000000Z","updated_at":"2025-03-17T23:28:04.000000Z"},{"id":10143240,"change_date":"2024-07-24 21:41:00","inspection_id":"82199558","insp_unit_id":"202041087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"B101","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:04.000000Z","updated_at":"2025-03-17T23:28:04.000000Z"}]},{"id":6160960,"change_date":"2024-07-08 21:42:00","inspection_id":"82055649","dot_number":"3576734","report_state":"WA","report_number":"X819006580","insp_date":"2024-07-04 00:00:00","insp_start_time":"2059","insp_end_time":"2127","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"TUMWATER WA","county_code_state":"WA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"STARBUCKS","shipping_paper_number":"2302165","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"633123","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2024-07-08 21:42:00","snet_input_date":"2024-07-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:58.000000Z","updated_at":"2025-03-17T20:24:58.000000Z","inspection_violations":[{"id":9563059,"change_date":"2024-07-08 21:42:00","inspection_id":"82055649","insp_violation_id":"260499937","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201763721","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3939A"},{"id":9563060,"change_date":"2024-07-08 21:42:00","inspection_id":"82055649","insp_violation_id":"260499938","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":9924576,"change_date":"2024-07-08 21:42:00","inspection_id":"82055649","insp_unit_id":"201763720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:51.000000Z","updated_at":"2025-03-17T23:25:51.000000Z"},{"id":9924577,"change_date":"2024-07-08 21:42:00","inspection_id":"82055649","insp_unit_id":"201763721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":null,"insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:51.000000Z","updated_at":"2025-03-17T23:25:51.000000Z"}]},{"id":5899850,"change_date":"2024-06-03 21:43:00","inspection_id":"81773684","dot_number":"3576734","report_state":"CA","report_number":"ND5A006803","insp_date":"2024-06-02 00:00:00","insp_start_time":"1027","insp_end_time":"1044","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OLAM FOODS","shipping_paper_number":"2000029430","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15388198","transaction_code":"A","transaction_date":"2024-06-02 00:00:00","upload_date":"2024-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2024-06-03 21:43:00","snet_input_date":"2024-06-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-03 21:43:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:31.000000Z","updated_at":"2025-03-17T20:19:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9502749,"change_date":"2024-06-03 21:43:00","inspection_id":"81773684","insp_unit_id":"201206833","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111\/RED","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"Y","insp_unit_decal_number":"33794767","created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"},{"id":9502750,"change_date":"2024-06-03 21:43:00","inspection_id":"81773684","insp_unit_id":"201206834","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102\/WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:35.000000Z","updated_at":"2025-03-17T23:21:35.000000Z"}]},{"id":4395164,"change_date":"2023-11-09 21:41:00","inspection_id":"80130628","dot_number":"3576734","report_state":"CA","report_number":"N9PH003842","insp_date":"2023-11-02 00:00:00","insp_start_time":"1713","insp_end_time":"1727","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ERI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15128855","transaction_code":"A","transaction_date":"2023-11-08 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-11-09 21:41:00","snet_input_date":"2023-11-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-09 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:54.000000Z","updated_at":"2025-03-17T19:49:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7068691,"change_date":"2023-11-09 21:41:00","inspection_id":"80130628","insp_unit_id":"197995428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"Y","insp_unit_decal_number":"33196202","created_at":"2025-03-17T22:59:20.000000Z","updated_at":"2025-03-17T22:59:20.000000Z"},{"id":7068692,"change_date":"2023-11-09 21:41:00","inspection_id":"80130628","insp_unit_id":"197995429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:20.000000Z","updated_at":"2025-03-17T22:59:20.000000Z"}]},{"id":3979699,"change_date":"2023-09-14 21:42:00","inspection_id":"79670199","dot_number":"3576734","report_state":"CA","report_number":"UFAW001507","insp_date":"2023-08-19 00:00:00","insp_start_time":"1022","insp_end_time":"1037","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ERI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15061709","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-09-14 21:42:00","snet_input_date":"2023-08-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-14 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:16.000000Z","updated_at":"2025-03-17T19:41:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6399332,"change_date":"2023-09-14 21:42:00","inspection_id":"79670199","insp_unit_id":"197069649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"Y","insp_unit_decal_number":"32834196","created_at":"2025-03-17T22:53:43.000000Z","updated_at":"2025-03-17T22:53:43.000000Z"}]},{"id":3968641,"change_date":"2023-09-13 21:41:00","inspection_id":"79657956","dot_number":"3576734","report_state":"CA","report_number":"NELC000881","insp_date":"2023-08-18 00:00:00","insp_start_time":"1903","insp_end_time":"1934","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ERI","shipping_paper_number":"2369116","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15060125","transaction_code":"A","transaction_date":"2023-09-13 00:00:00","upload_date":"2023-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-09-13 21:41:00","snet_input_date":"2023-08-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-13 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:12.000000Z","updated_at":"2025-03-17T19:41:12.000000Z","inspection_violations":[{"id":6137534,"change_date":"2023-09-13 21:41:00","inspection_id":"79657956","insp_violation_id":"255254358","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197043577","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA302805","created_at":"2025-03-17T21:35:38.000000Z","updated_at":"2025-03-17T21:35:38.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6381586,"change_date":"2023-09-13 21:41:00","inspection_id":"79657956","insp_unit_id":"197043577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111\/RED","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:36.000000Z","updated_at":"2025-03-17T22:53:36.000000Z"},{"id":6381587,"change_date":"2023-09-13 21:41:00","inspection_id":"79657956","insp_unit_id":"197043578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102\/WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"Y","insp_unit_decal_number":"32837001","created_at":"2025-03-17T22:53:36.000000Z","updated_at":"2025-03-17T22:53:36.000000Z"}]},{"id":3773041,"change_date":"2023-08-17 21:44:00","inspection_id":"79439692","dot_number":"3576734","report_state":"CA","report_number":"ND94004831","insp_date":"2023-08-17 00:00:00","insp_start_time":"1115","insp_end_time":"1133","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COSTCO","shipping_paper_number":"18169","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15026135","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[{"id":5819772,"change_date":"2023-08-17 21:44:00","inspection_id":"79439692","insp_violation_id":"254731143","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196599404","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW682966","created_at":"2025-03-17T21:33:57.000000Z","updated_at":"2025-03-17T21:33:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6066248,"change_date":"2023-08-17 21:44:00","inspection_id":"79439692","insp_unit_id":"196599404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"},{"id":6066249,"change_date":"2023-08-17 21:44:00","inspection_id":"79439692","insp_unit_id":"196599405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"WHITE","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:59.000000Z","updated_at":"2025-03-17T22:50:59.000000Z"}]},{"id":3506127,"change_date":"2023-07-13 21:43:00","inspection_id":"79141013","dot_number":"3576734","report_state":"CA","report_number":"NCT2004788","insp_date":"2023-06-19 00:00:00","insp_start_time":"1909","insp_end_time":"1925","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"INTERFOR SALES & MARKETING LTD","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14979816","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-07-13 21:43:00","snet_input_date":"2023-06-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-13 21:43:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5367 N VALENTINE AVE APT 148","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93711","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:27.000000Z","updated_at":"2025-03-17T19:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5637877,"change_date":"2023-07-13 21:43:00","inspection_id":"79141013","insp_unit_id":"195995743","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"},{"id":5637878,"change_date":"2023-07-13 21:43:00","inspection_id":"79141013","insp_unit_id":"195995744","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:30.000000Z","updated_at":"2025-03-17T22:47:30.000000Z"}]},{"id":3089963,"change_date":"2023-05-18 21:44:00","inspection_id":"78672089","dot_number":"3576734","report_state":"CA","report_number":"UD7O001622","insp_date":"2023-05-17 00:00:00","insp_start_time":"2050","insp_end_time":"2056","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN MAID GROWERS","shipping_paper_number":"707360","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14907316","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-05-18 21:44:00","snet_input_date":"2023-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-18 21:44:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"7123 WEST TWAIN AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"581707","created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4970476,"change_date":"2023-05-18 21:44:00","inspection_id":"78672089","insp_unit_id":"195029623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHI","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"},{"id":4970477,"change_date":"2023-05-18 21:44:00","inspection_id":"78672089","insp_unit_id":"195029624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHI","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":2579349,"change_date":"2023-03-14 21:42:00","inspection_id":"78093235","dot_number":"3576734","report_state":"WA","report_number":"W513006078","insp_date":"2023-03-09 00:00:00","insp_start_time":"1105","insp_end_time":"1140","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"SOUTHBOUND","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"2212680","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2558499","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-03-14 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-03-14 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"7123 W TWAIN AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:08.000000Z","updated_at":"2025-03-17T19:14:08.000000Z","inspection_violations":[{"id":3968491,"change_date":"2023-03-14 21:42:00","inspection_id":"78093235","insp_violation_id":"251666335","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:37.000000Z","updated_at":"2025-03-17T21:25:37.000000Z","normalized_code":"3922"},{"id":3968492,"change_date":"2023-03-14 21:42:00","inspection_id":"78093235","insp_violation_id":"251666336","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:37.000000Z","updated_at":"2025-03-17T21:25:37.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4151694,"change_date":"2023-03-14 21:42:00","inspection_id":"78093235","insp_unit_id":"193875964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:46.000000Z","updated_at":"2025-03-17T22:35:46.000000Z"},{"id":4151695,"change_date":"2023-03-14 21:42:00","inspection_id":"78093235","insp_unit_id":"193875965","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:46.000000Z","updated_at":"2025-03-17T22:35:46.000000Z"}]},{"id":2463214,"change_date":"2023-02-27 21:42:00","inspection_id":"77960941","dot_number":"3576734","report_state":"CA","report_number":"ND7N006091","insp_date":"2023-02-25 00:00:00","insp_start_time":"1158","insp_end_time":"1217","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14800212","transaction_code":"A","transaction_date":"2023-02-25 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"7123 WEST TWAIN AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3964458,"change_date":"2023-02-27 21:42:00","inspection_id":"77960941","insp_unit_id":"193609524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111 RED","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"Y","insp_unit_decal_number":"32167244","created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"},{"id":3964459,"change_date":"2023-02-27 21:42:00","inspection_id":"77960941","insp_unit_id":"193609525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102 WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"Y","insp_unit_decal_number":"32167245","created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2352366,"change_date":"2023-02-10 21:41:00","inspection_id":"77834453","dot_number":"3576734","report_state":"CA","report_number":"NCT2004357","insp_date":"2023-01-27 00:00:00","insp_start_time":"1837","insp_end_time":"1856","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"1938086","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14778925","transaction_code":"A","transaction_date":"2023-01-27 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2023-02-10 21:41:00","snet_input_date":"2023-01-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-10 21:41:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"7123 WEST TWAIN AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:59.000000Z","updated_at":"2025-03-17T19:09:59.000000Z","inspection_violations":[{"id":3623625,"change_date":"2023-02-10 21:41:00","inspection_id":"77834453","insp_violation_id":"251085211","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193354474","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:06.000000Z","updated_at":"2025-03-17T21:24:06.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":3785866,"change_date":"2023-02-10 21:41:00","inspection_id":"77834453","insp_unit_id":"193354474","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111\/BRGY","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"},{"id":3785867,"change_date":"2023-02-10 21:41:00","inspection_id":"77834453","insp_unit_id":"193354475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102\/WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:07.000000Z","updated_at":"2025-03-17T22:33:07.000000Z"}]},{"id":1672519,"change_date":"2022-11-03 21:42:00","inspection_id":"77056972","dot_number":"3576734","report_state":"CA","report_number":"ND7N005572","insp_date":"2022-11-01 00:00:00","insp_start_time":"1538","insp_end_time":"1546","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14661785","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2022-11-03 21:42:00","snet_input_date":"2022-11-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5350 N BRAWLEY AVE APT 114","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:26.000000Z","updated_at":"2025-03-17T18:57:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2690595,"change_date":"2022-11-03 21:42:00","inspection_id":"77056972","insp_unit_id":"191805004","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111 MAROON","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"},{"id":2690596,"change_date":"2022-11-03 21:42:00","inspection_id":"77056972","insp_unit_id":"191805005","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B102 WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:27.000000Z","updated_at":"2025-03-17T22:25:27.000000Z"}]},{"id":1120210,"change_date":"2022-08-23 21:42:00","inspection_id":"76417883","dot_number":"3576734","report_state":"CA","report_number":"UDDI000573","insp_date":"2022-08-23 00:00:00","insp_start_time":"0901","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"155","location_desc":"99W AT STRUCKMEYER","county_code_state":"CA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUNMAID","shipping_paper_number":"682403","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14562324","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2022-08-23 21:42:00","snet_input_date":"2022-08-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5350 N BRAWLEY AVE APT 114","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"581707","created_at":"2025-03-17T18:47:31.000000Z","updated_at":"2025-03-17T18:47:31.000000Z","inspection_violations":[{"id":1769843,"change_date":"2022-08-23 21:42:00","inspection_id":"76417883","insp_violation_id":"247949162","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1801958,"change_date":"2022-08-23 21:42:00","inspection_id":"76417883","insp_unit_id":"190506199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"},{"id":1801959,"change_date":"2022-08-23 21:42:00","inspection_id":"76417883","insp_unit_id":"190506200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":411695,"change_date":"2022-05-17 21:43:00","inspection_id":"75584081","dot_number":"3576734","report_state":"CA","report_number":"ND7N004852","insp_date":"2022-05-16 00:00:00","insp_start_time":"1730","insp_end_time":"1744","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14430375","transaction_code":"A","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5350 N BRAWLEY AVE APT 114","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":664907,"change_date":"2022-05-17 21:43:00","inspection_id":"75584081","insp_unit_id":"188741428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111 BURG","insp_unit_license":"YP04849","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR2JSJT7328","insp_unit_decal":"Y","insp_unit_decal_number":"31129930","created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"},{"id":664908,"change_date":"2022-05-17 21:43:00","inspection_id":"75584081","insp_unit_id":"188741429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2X WHT","insp_unit_license":"94732AG","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1JJV532D8PL380651","insp_unit_decal":"Y","insp_unit_decal_number":"31129931","created_at":"2025-03-17T22:12:16.000000Z","updated_at":"2025-03-17T22:12:16.000000Z"}]},{"id":31918,"change_date":"2022-03-23 21:33:00","inspection_id":"75126338","dot_number":"3576734","report_state":"CA","report_number":"UCL5002823","insp_date":"2022-03-23 00:00:00","insp_start_time":"0849","insp_end_time":"0902","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOLD- PAK","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14356245","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03576734","upload_search_indicator":null,"census_search_date":"2022-03-23 21:33:00","snet_input_date":"2022-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-23 21:33:00","insp_carrier_name":"BHAM 07 TRANSPORT INC","insp_carrier_street":"5350 N BRAWLEY AVE APT 114","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93722","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:06.000000Z","updated_at":"2025-03-17T18:28:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":51413,"change_date":"2022-03-23 21:33:00","inspection_id":"75126338","insp_unit_id":"187794681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110\/WHT","insp_unit_license":"XP78819","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7JSHA2106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"},{"id":51414,"change_date":"2022-03-23 21:33:00","inspection_id":"75126338","insp_unit_id":"187794682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"B101\/WHT","insp_unit_license":"4TG3992","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8NL287075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:35.000000Z","updated_at":"2025-03-17T22:08:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3576734\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3576734\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3576734\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3576734\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}