{"current_page":1,"data":[{"id":11189092,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","dot_number":"2487257","report_state":"NM","report_number":"6488Q1DRWF","insp_date":"2026-02-18 00:00:00","insp_start_time":"2100","insp_end_time":"2200","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON I-40 1868 FT W OF I40 NB OF","county_code_state":"NM","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MASTER EXTRUSION LLC","shipping_paper_number":"141587","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-02-20 21:38:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"7","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":"2265192","transaction_code":"C","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2026-02-20 21:38:00","snet_input_date":"2026-02-20 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-02-20 21:38:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-02-23T10:37:52.000000Z","updated_at":"2026-03-07T10:30:33.000000Z","inspection_violations":[{"id":18811828,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988055","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"39375A3"},{"id":18811829,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988056","seq_no":"2","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"393209D"},{"id":18811830,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988057","seq_no":"3","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"393207A"},{"id":18811831,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988058","seq_no":"4","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"393201A"},{"id":18811832,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988059","seq_no":"5","part_no":"393","part_no_section":"207C","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"393207C"},{"id":18811833,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988060","seq_no":"6","part_no":"393","part_no_section":"203B","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"393203B"},{"id":18811834,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_violation_id":"271988061","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"211794643","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-02-27T10:53:52.000000Z","updated_at":"2026-03-07T10:40:21.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":19154002,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_unit_id":"211794643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"TRU 9557","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:20.000000Z","updated_at":"2026-03-07T10:03:08.000000Z"},{"id":19154003,"change_date":"2026-02-24 21:40:00","inspection_id":"87099304","insp_unit_id":"211794644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"TRA TRA PB84","insp_unit_license":"4VH2828","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0626NE321759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:20.000000Z","updated_at":"2026-03-07T10:03:08.000000Z"}]},{"id":11054993,"change_date":"2026-02-05 21:38:00","inspection_id":"86965250","dot_number":"2487257","report_state":"KY","report_number":"CV44306223","insp_date":"2026-02-05 00:00:00","insp_start_time":"0945","insp_end_time":"1050","registration_date":null,"region":"CD","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"LONE STAR BAKERY, INC.","shipping_paper_number":"SO15371","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-02-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2329122","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-05 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-02-05 21:38:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:18.000000Z","updated_at":"2026-02-16T10:30:39.000000Z","inspection_violations":[{"id":18501822,"change_date":"2026-02-05 21:38:00","inspection_id":"86965250","insp_violation_id":"271615651","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"211456943","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-08T10:50:33.000000Z","updated_at":"2026-02-16T10:39:58.000000Z","normalized_code":"3922SLL"},{"id":18501823,"change_date":"2026-02-05 21:38:00","inspection_id":"86965250","insp_violation_id":"271615652","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"211456944","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-08T10:50:33.000000Z","updated_at":"2026-02-16T10:39:58.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18848011,"change_date":"2026-02-05 21:38:00","inspection_id":"86965250","insp_unit_id":"211456944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1315","insp_unit_license":"5448773","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532B7LL174715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:14.000000Z","updated_at":"2026-02-16T10:03:48.000000Z"},{"id":18848010,"change_date":"2026-02-05 21:38:00","inspection_id":"86965250","insp_unit_id":"211456943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"04","insp_unit_license":"ZP65974","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4NN309825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-08T10:14:14.000000Z","updated_at":"2026-02-16T10:03:48.000000Z"}]},{"id":10117576,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","dot_number":"2487257","report_state":"MS","report_number":"5009012909","insp_date":"2025-11-03 00:00:00","insp_start_time":"1053","insp_end_time":"1133","registration_date":"2025-12-01 00:00:00","region":"CT","ci_status_code":"C","location":"51","location_desc":"NEWTON COUNTY","county_code_state":"MS","county_code":"101","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KYKENKEE","shipping_paper_number":"72-280912","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-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1127666","transaction_code":"C","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-04 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:44.000000Z","updated_at":"2025-12-06T10:30:05.000000Z","inspection_violations":[{"id":17274550,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","insp_violation_id":"270403003","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210361998","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:04.000000Z","updated_at":"2025-12-06T10:30:10.000000Z","normalized_code":"39395A1"},{"id":17274551,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","insp_violation_id":"270403004","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"210361998","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:04.000000Z","updated_at":"2025-12-06T10:30:10.000000Z","normalized_code":"39395F"},{"id":17274552,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","insp_violation_id":"270403005","seq_no":"3","part_no":"393","part_no_section":"25A-L","insp_viol_unit":"2","insp_unit_id":"210361999","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:04.000000Z","updated_at":"2025-12-06T10:30:10.000000Z","normalized_code":"39325AL"}],"inspection_per_units":[{"id":17248050,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","insp_unit_id":"210361998","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:46.000000Z","updated_at":"2025-12-06T10:00:08.000000Z"},{"id":17248051,"change_date":"2025-12-02 21:38:00","inspection_id":"86233967","insp_unit_id":"210361999","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"PB29","insp_unit_license":"4VH7368","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626JW123297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:46.000000Z","updated_at":"2025-12-06T10:00:08.000000Z"}]},{"id":9832133,"change_date":"2025-10-02 21:41:00","inspection_id":"85933040","dot_number":"2487257","report_state":"GA","report_number":"1428001338","insp_date":"2025-09-25 00:00:00","insp_start_time":"2110","insp_end_time":"2140","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BREMEN GA","county_code_state":"GA","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BANDESHA TRANSPORT INC","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2025-10-02 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":"2356104","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2025-10-02 21:41:00","snet_input_date":"2025-09-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-02 21:41:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-05T10:01:29.000000Z","updated_at":"2025-10-05T10:01:29.000000Z","inspection_violations":[{"id":16187083,"change_date":"2025-10-02 21:41:00","inspection_id":"85933040","insp_violation_id":"269044260","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E05751259","created_at":"2025-10-05T10:17:17.000000Z","updated_at":"2025-10-05T10:17:17.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":16301347,"change_date":"2025-10-02 21:41:00","inspection_id":"85933040","insp_unit_id":"209251025","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"03","insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:45.000000Z","updated_at":"2025-10-05T09:46:45.000000Z"},{"id":16301348,"change_date":"2025-10-02 21:41:00","inspection_id":"85933040","insp_unit_id":"209251026","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"PB29","insp_unit_license":"4VH7368","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626JW123297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:45.000000Z","updated_at":"2025-10-05T09:46:45.000000Z"}]},{"id":9677648,"change_date":"2025-09-14 21:33:00","inspection_id":"85771078","dot_number":"2487257","report_state":"GA","report_number":"1464000318","insp_date":"2025-09-07 00:00:00","insp_start_time":"2328","insp_end_time":"0008","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DECATUR GA","county_code_state":"GA","county_code":"089","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","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":"U","pen_cen_match":"I","final_status_date":"2025-09-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2274524","transaction_code":"A","transaction_date":"2025-09-14 00:00:00","upload_date":"2025-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2025-09-14 21:33:00","snet_input_date":"2025-09-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-14 21:33:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-17T10:40:59.000000Z","updated_at":"2025-09-18T10:00:09.000000Z","inspection_violations":[{"id":15864924,"change_date":"2025-09-14 21:33:00","inspection_id":"85771078","insp_violation_id":"268681519","seq_no":"1","part_no":"383","part_no_section":"95-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"W01E922679","created_at":"2025-09-18T10:20:24.000000Z","updated_at":"2025-09-18T10:20:24.000000Z","normalized_code":"38395LCDL"},{"id":15864925,"change_date":"2025-09-14 21:33:00","inspection_id":"85771078","insp_violation_id":"268681520","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"W01E922678","created_at":"2025-09-18T10:20:24.000000Z","updated_at":"2025-09-18T10:20:24.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16015241,"change_date":"2025-09-14 21:33:00","inspection_id":"85771078","insp_unit_id":"208943312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:19.000000Z","updated_at":"2025-09-18T09:45:19.000000Z"},{"id":16015242,"change_date":"2025-09-14 21:33:00","inspection_id":"85771078","insp_unit_id":"208943313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"PB29","insp_unit_license":"4VH7368","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626JW123297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:19.000000Z","updated_at":"2025-09-18T09:45:19.000000Z"}]},{"id":9572300,"change_date":"2025-09-02 21:40:00","inspection_id":"85661068","dot_number":"2487257","report_state":"CA","report_number":"ND6B006480","insp_date":"2025-08-29 00:00:00","insp_start_time":"0507","insp_end_time":"0545","registration_date":null,"region":"PT","ci_status_code":"C","location":"880","location_desc":"CACHE CREEK","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"DAIKIN AMERICA INC","shipping_paper_number":"76603","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-09-02 21:40: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":"15960858","transaction_code":"A","transaction_date":"2025-08-29 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:09.000000Z","updated_at":"2025-09-06T10:43:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15800911,"change_date":"2025-09-02 21:40:00","inspection_id":"85661068","insp_unit_id":"208708748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"Y","insp_unit_decal_number":"35374264","created_at":"2025-09-09T09:47:21.000000Z","updated_at":"2025-09-09T09:47:21.000000Z"},{"id":15800912,"change_date":"2025-09-02 21:40:00","inspection_id":"85661068","insp_unit_id":"208708749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"84","insp_unit_license":"4VH2828","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"11GR1A0626NE32175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:21.000000Z","updated_at":"2025-09-09T09:47:21.000000Z"}]},{"id":8856339,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","dot_number":"2487257","report_state":"CA","report_number":"UDO7001040","insp_date":"2025-06-08 00:00:00","insp_start_time":"1221","insp_end_time":"1312","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PILGRIM'S PRIDE","shipping_paper_number":"8000755700","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-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15853444","transaction_code":"A","transaction_date":"2025-06-08 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-09 21:42:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":"540817","created_at":"2025-06-14T10:00:36.000000Z","updated_at":"2025-06-14T10:00:36.000000Z","inspection_violations":[{"id":14183973,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_violation_id":"266748317","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"207301385","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RP 08904","created_at":"2025-06-12T10:15:59.000000Z","updated_at":"2025-06-13T10:18:03.000000Z","normalized_code":"3939ALTSIR"},{"id":14183974,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_violation_id":"266748318","seq_no":"2","part_no":"393","part_no_section":"47A-BRC","insp_viol_unit":"1","insp_unit_id":"207301385","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA 682484","created_at":"2025-06-12T10:15:59.000000Z","updated_at":"2025-06-13T10:18:03.000000Z","normalized_code":"39347ABRC"},{"id":14183975,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_violation_id":"266748319","seq_no":"3","part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"2","insp_unit_id":"207301386","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-12T10:15:59.000000Z","updated_at":"2025-06-13T10:18:03.000000Z","normalized_code":"393207FSLAS"},{"id":14183976,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_violation_id":"266748320","seq_no":"4","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"2","insp_unit_id":"207301386","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-12T10:15:59.000000Z","updated_at":"2025-06-13T10:18:03.000000Z","normalized_code":"3965BHWSL"}],"inspection_per_units":[{"id":14502372,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_unit_id":"207301385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:38.000000Z","updated_at":"2025-06-13T09:45:38.000000Z"},{"id":14502373,"change_date":"2025-06-09 21:42:00","inspection_id":"84906384","insp_unit_id":"207301386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"R52233","insp_unit_license":"P492833","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2535HU882738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:38.000000Z","updated_at":"2025-06-13T09:45:38.000000Z"}]},{"id":8762668,"change_date":"2025-05-29 21:41:00","inspection_id":"84807093","dot_number":"2487257","report_state":"SC","report_number":"0363002361","insp_date":"2025-05-28 00:00:00","insp_start_time":"1032","insp_end_time":"1105","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ANDERSON SC","county_code_state":"SC","county_code":"007","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"OXCO","shipping_paper_number":"SO079609","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-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","viol_total":"2","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":"1792176","transaction_code":"A","transaction_date":"2025-05-28 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2025-05-29 21:41:00","snet_input_date":"2025-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-29 21:41:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-06-01T10:01:16.000000Z","updated_at":"2025-06-04T10:00:11.000000Z","inspection_violations":[{"id":13999147,"change_date":"2025-05-29 21:41:00","inspection_id":"84807093","insp_violation_id":"266534804","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207117578","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WA82111","created_at":"2025-06-01T10:17:22.000000Z","updated_at":"2025-06-02T10:16:50.000000Z","normalized_code":"39617CPI"},{"id":13999148,"change_date":"2025-05-29 21:41:00","inspection_id":"84807093","insp_violation_id":"266534805","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207117578","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:22.000000Z","updated_at":"2025-06-02T10:16:50.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14334695,"change_date":"2025-05-29 21:41:00","inspection_id":"84807093","insp_unit_id":"207117578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"04","insp_unit_license":"ZP65720","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH4NN309825","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:39.000000Z","updated_at":"2025-06-02T09:45:12.000000Z"},{"id":14334696,"change_date":"2025-05-29 21:41:00","inspection_id":"84807093","insp_unit_id":"207117579","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"5313","insp_unit_license":"26-8845E","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA0625HW705286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:39.000000Z","updated_at":"2025-06-02T09:45:12.000000Z"}]},{"id":6341312,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","dot_number":"2487257","report_state":"AZ","report_number":"1012700696","insp_date":"2024-07-24 00:00:00","insp_start_time":"1121","insp_end_time":"1150","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"BAPCHULE AZ","county_code_state":"AZ","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIMAL PET FOOD","shipping_paper_number":"WS150021","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":"U","pen_cen_match":"I","final_status_date":"2024-07-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"697509","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-17T20:28:38.000000Z","updated_at":"2025-03-17T20:28:38.000000Z","inspection_violations":[{"id":9845220,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_violation_id":"260906876","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"202134914","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"39617C"},{"id":9845221,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_violation_id":"260906877","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3922"},{"id":9845222,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_violation_id":"260906878","seq_no":"5","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"202134914","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3929A2"},{"id":9845223,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_violation_id":"260906879","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202134913","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"39617C"},{"id":9845224,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_violation_id":"260906880","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:39.000000Z","updated_at":"2025-03-17T21:53:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10218478,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_unit_id":"202134913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"03","insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"},{"id":10218479,"change_date":"2024-07-30 21:43:00","inspection_id":"82248927","insp_unit_id":"202134914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B7KL120085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"}]},{"id":5515563,"change_date":"2024-12-31 21:38:00","inspection_id":"81355902","dot_number":"2487257","report_state":"CA","report_number":"UC13003927","insp_date":"2024-04-12 00:00:00","insp_start_time":"0845","insp_end_time":"0930","registration_date":null,"region":"PT","ci_status_code":"C","location":"460","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"15318744","transaction_code":"C","transaction_date":"2024-12-31 00:00:00","upload_date":"2024-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-15 21:42:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":"540817","created_at":"2025-03-17T20:11:58.000000Z","updated_at":"2025-03-17T20:11:58.000000Z","inspection_violations":[{"id":8521653,"change_date":"2024-12-31 21:38:00","inspection_id":"81355902","insp_violation_id":"263712523","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KW79599","created_at":"2025-03-17T21:47:19.000000Z","updated_at":"2025-03-17T21:47:19.000000Z","normalized_code":"3922C"},{"id":8521654,"change_date":"2024-12-31 21:38:00","inspection_id":"81355902","insp_violation_id":"263712524","seq_no":"2","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:19.000000Z","updated_at":"2025-03-17T21:47:19.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":8884533,"change_date":"2024-12-31 21:38:00","inspection_id":"81355902","insp_unit_id":"204609449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"PURP","insp_unit_license":"XP03084","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ1HN964290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:39.000000Z","updated_at":"2025-03-17T23:15:39.000000Z"},{"id":8884534,"change_date":"2024-12-31 21:38:00","inspection_id":"81355902","insp_unit_id":"204609450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4VH7368","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0626JW123297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:39.000000Z","updated_at":"2025-03-17T23:15:39.000000Z"}]},{"id":5142337,"change_date":"2024-02-27 21:39:00","inspection_id":"80948865","dot_number":"2487257","report_state":"AR","report_number":"B749001372","insp_date":"2024-02-27 00:00:00","insp_start_time":"1422","insp_end_time":"1452","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"CONWAY COUNTY","county_code_state":"AR","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"US COLD STORAGE OF CALIFORNIA","shipping_paper_number":"25785","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":"I","final_status_date":"2024-02-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"1501904","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-27 00:00:00","source_office":"2ARS001","mcmis_add_date":"2024-02-27 21:39:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:31.000000Z","updated_at":"2025-03-17T20:04:31.000000Z","inspection_violations":[{"id":7930564,"change_date":"2024-02-27 21:39:00","inspection_id":"80948865","insp_violation_id":"258055955","seq_no":"1","part_no":"395","part_no_section":"24(c)(2)(iii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:18.000000Z","updated_at":"2025-03-17T21:44:18.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":8279470,"change_date":"2024-02-27 21:39:00","inspection_id":"80948865","insp_unit_id":"199615179","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:01.000000Z","updated_at":"2025-03-17T23:10:01.000000Z"},{"id":8279471,"change_date":"2024-02-27 21:39:00","inspection_id":"80948865","insp_unit_id":"199615180","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B7KL120085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:01.000000Z","updated_at":"2025-03-17T23:10:01.000000Z"}]},{"id":4829700,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","dot_number":"2487257","report_state":"AZ","report_number":"7254000012","insp_date":"2024-01-05 00:00:00","insp_start_time":"1220","insp_end_time":"1300","registration_date":null,"region":"MS","ci_status_code":"C","location":null,"location_desc":"TUCSON AZ","county_code_state":"AZ","county_code":"019","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MCILHENNY CO","shipping_paper_number":"39742","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":"U","pen_cen_match":"I","final_status_date":"2024-01-13 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"174686","transaction_code":"A","transaction_date":"2024-01-13 00:00:00","upload_date":"2024-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2024-01-13 21:31:00","snet_input_date":"2024-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-13 21:31:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[{"id":7446990,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332550","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"198953806","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39375A3TAOL"},{"id":7446991,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332551","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"198953805","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39617CPI"},{"id":7446992,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332552","seq_no":"3","part_no":"395","part_no_section":"22H1-ELDNUM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39522H1ELDNUM"},{"id":7446993,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332553","seq_no":"4","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39530B1ELDDFR"},{"id":7446994,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332554","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"198953806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"39617CPI"},{"id":7446995,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_violation_id":"257332555","seq_no":"6","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:41:57.000000Z","updated_at":"2025-03-17T21:41:57.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7770352,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_unit_id":"198953805","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:27.000000Z","updated_at":"2025-03-17T23:05:27.000000Z"},{"id":7770353,"change_date":"2024-01-13 21:31:00","inspection_id":"80606984","insp_unit_id":"198953806","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"4VH2828","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0626NE321759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:27.000000Z","updated_at":"2025-03-17T23:05:27.000000Z"}]},{"id":4742835,"change_date":"2024-01-02 21:43:00","inspection_id":"80511998","dot_number":"2487257","report_state":"AR","report_number":"791C000234","insp_date":"2024-01-02 00:00:00","insp_start_time":"0812","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"US COLD STORAGE OF CALIFORNIA","shipping_paper_number":"56485","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":"I","final_status_date":"2024-01-02 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":"1493305","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-01-02 00:00:00","source_office":"2ARS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:51.000000Z","updated_at":"2025-03-17T19:56:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7629092,"change_date":"2024-01-02 21:43:00","inspection_id":"80511998","insp_unit_id":"198761375","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:11.000000Z","updated_at":"2025-03-17T23:04:11.000000Z"},{"id":7629093,"change_date":"2024-01-02 21:43:00","inspection_id":"80511998","insp_unit_id":"198761376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:11.000000Z","updated_at":"2025-03-17T23:04:11.000000Z"}]},{"id":4651558,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","dot_number":"2487257","report_state":"LA","report_number":"LABQ004923","insp_date":"2023-12-15 00:00:00","insp_start_time":"0436","insp_end_time":"0457","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"053","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1189373","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-18 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-12-18 21:42:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:58.000000Z","updated_at":"2025-03-17T19:54:58.000000Z","inspection_violations":[{"id":7191679,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","insp_violation_id":"256934861","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"3922"},{"id":7191680,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","insp_violation_id":"256934862","seq_no":"2","part_no":"392","part_no_section":"22(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"39222A"},{"id":7191681,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","insp_violation_id":"256934863","seq_no":"3","part_no":"392","part_no_section":"22(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:44.000000Z","updated_at":"2025-03-17T21:40:44.000000Z","normalized_code":"39222B"}],"inspection_per_units":[{"id":7481073,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","insp_unit_id":"198549830","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"YP56781","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKYD49X0NJ170668","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:54.000000Z","updated_at":"2025-03-17T23:02:54.000000Z"},{"id":7481074,"change_date":"2023-12-18 21:42:00","inspection_id":"80412406","insp_unit_id":"198549831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"PB84","insp_unit_license":"4VH2828","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0626NE321759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:54.000000Z","updated_at":"2025-03-17T23:02:54.000000Z"}]},{"id":3543665,"change_date":"2023-07-19 21:43:00","inspection_id":"79183021","dot_number":"2487257","report_state":"MS","report_number":"U023002174","insp_date":"2023-07-18 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"107","location_desc":"E\/B 2 MS 315","county_code_state":"MS","county_code":"107","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-07-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1037408","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-19 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-07-19 21:43:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:07.000000Z","updated_at":"2025-03-17T19:33:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5697646,"change_date":"2023-07-19 21:43:00","inspection_id":"79183021","insp_unit_id":"196078504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"01","insp_unit_license":"XP03084","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ1HN964290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:57.000000Z","updated_at":"2025-03-17T22:47:57.000000Z"},{"id":5697647,"change_date":"2023-07-19 21:43:00","inspection_id":"79183021","insp_unit_id":"196078505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B7KL120085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:57.000000Z","updated_at":"2025-03-17T22:47:57.000000Z"}]},{"id":2558884,"change_date":"2023-03-13 21:41:00","inspection_id":"78069557","dot_number":"2487257","report_state":"AR","report_number":"C730001618","insp_date":"2023-03-12 00:00:00","insp_start_time":"0910","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"17","location_desc":"CRAWFORD COUNTY","county_code_state":"AR","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"DREYERS GRAND ICE CREAM","shipping_paper_number":"59503","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":"I","final_status_date":"2023-03-13 21:41: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":"1448886","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-03-13 21:41:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:45.000000Z","updated_at":"2025-03-17T19:13:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4118370,"change_date":"2023-03-13 21:41:00","inspection_id":"78069557","insp_unit_id":"193827257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"},{"id":4118371,"change_date":"2023-03-13 21:41:00","inspection_id":"78069557","insp_unit_id":"193827258","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"PB84","insp_unit_license":"4VH2828","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GR1A0626NE321759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"}]},{"id":2163429,"change_date":"2023-01-18 21:39:00","inspection_id":"77619423","dot_number":"2487257","report_state":"AR","report_number":"739C001462","insp_date":"2023-01-17 00:00:00","insp_start_time":"2313","insp_end_time":"2339","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"DREYERS GRAND ICE CREAM","shipping_paper_number":"53701","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":"I","final_status_date":"2023-01-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"1441101","transaction_code":"A","transaction_date":"2023-01-18 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-18 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-01-18 21:39:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:35.000000Z","updated_at":"2025-03-17T19:06:35.000000Z","inspection_violations":[{"id":3346416,"change_date":"2023-01-18 21:39:00","inspection_id":"77619423","insp_violation_id":"250623332","seq_no":"1","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3953A3I"}],"inspection_per_units":[{"id":3481624,"change_date":"2023-01-18 21:39:00","inspection_id":"77619423","insp_unit_id":"192917277","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:58.000000Z","updated_at":"2025-03-17T22:30:58.000000Z"},{"id":3481625,"change_date":"2023-01-18 21:39:00","inspection_id":"77619423","insp_unit_id":"192917278","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B7KL120085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:58.000000Z","updated_at":"2025-03-17T22:30:58.000000Z"}]},{"id":1727199,"change_date":"2022-12-03 21:30:00","inspection_id":"77119764","dot_number":"2487257","report_state":"NM","report_number":"7927M8TH14","insp_date":"2022-11-13 00:00:00","insp_start_time":"1326","insp_end_time":"1400","registration_date":"2022-12-02 00:00:00","region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LINEAGE LOGISTICS PFS, LLC","shipping_paper_number":"4268140","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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1953151","transaction_code":"C","transaction_date":"2022-11-13 00:00:00","upload_date":"2022-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":null,"census_search_date":"2022-11-14 21:41:00","snet_input_date":"2022-11-14 00:00:00","source_office":"2NMS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"BANDESHA TRANSPORT INC","insp_carrier_street":"4717 N CASEY 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-17T18:58:33.000000Z","updated_at":"2025-03-17T18:58:33.000000Z","inspection_violations":[{"id":2704359,"change_date":"2022-12-03 21:30:00","inspection_id":"77119764","insp_violation_id":"249901571","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192242861","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:19:45.000000Z","updated_at":"2025-03-17T21:19:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2778457,"change_date":"2022-12-03 21:30:00","inspection_id":"77119764","insp_unit_id":"192242860","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"},{"id":2778458,"change_date":"2022-12-03 21:30:00","inspection_id":"77119764","insp_unit_id":"192242861","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"5362","insp_unit_license":"269674E","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2538N2683612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:00.000000Z","updated_at":"2025-03-17T22:26:00.000000Z"}]},{"id":1451252,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","dot_number":"2487257","report_state":"TX","report_number":"6ES99DJH4L","insp_date":"2022-09-30 00:00:00","insp_start_time":"0936","insp_end_time":"1009","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0020 IN TARRANT CO. (424-45","county_code_state":"TX","county_code":"439","insp_level_id":"2","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":"Y","pen_cen_match":null,"final_status_date":"2022-10-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118320","viol_total":"6","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8791497","transaction_code":"A","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-05 21:41:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":"0915648","created_at":"2025-03-17T18:53:26.000000Z","updated_at":"2025-03-17T18:53:26.000000Z","inspection_violations":[{"id":2286894,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860236","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191293734","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39378"},{"id":2286895,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860237","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191293734","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3922"},{"id":2286896,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860238","seq_no":"3","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39532B"},{"id":2286897,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860239","seq_no":"4","part_no":"395","part_no_section":"32(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39532B"},{"id":2286898,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860240","seq_no":"5","part_no":"395","part_no_section":"30(b)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39530B1"},{"id":2286899,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_violation_id":"248860241","seq_no":"6","part_no":"395","part_no_section":"24(c)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39524C2II"}],"inspection_per_units":[{"id":2336809,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_unit_id":"191293734","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"XP03084","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EJ1HN964290","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:00.000000Z","updated_at":"2025-03-17T22:23:00.000000Z"},{"id":2336810,"change_date":"2022-10-05 21:41:00","inspection_id":"76802171","insp_unit_id":"191293735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":null,"insp_unit_license":"B342724","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GR1A0626NE321759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:00.000000Z","updated_at":"2025-03-17T22:23:00.000000Z"}]},{"id":1084377,"change_date":"2022-08-19 21:35:00","inspection_id":"76376081","dot_number":"2487257","report_state":"AR","report_number":"759C000285","insp_date":"2022-08-19 00:00:00","insp_start_time":"0440","insp_end_time":"0505","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-302","location_desc":"CRAWFORD COUNTY(ALMA WEST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"STORCK USA","shipping_paper_number":"H18229434","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":"I","final_status_date":"2022-08-19 21:35: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":"1417181","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02487257","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-19 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-08-19 21:35:00","insp_carrier_name":"BANDESHA TRANSPORT","insp_carrier_street":"4717 N CASEY AVE","insp_carrier_city":"FRESNO","insp_carrier_state":"CA","insp_carrier_zip_code":"93723","insp_colonia":null,"docket_number":"861178","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:52.000000Z","updated_at":"2025-03-17T18:46:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1743906,"change_date":"2022-08-19 21:35:00","inspection_id":"76376081","insp_unit_id":"190421133","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"XP32991","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR0KSKE9557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:00.000000Z","updated_at":"2025-03-17T22:19:00.000000Z"},{"id":1743907,"change_date":"2022-08-19 21:35:00","inspection_id":"76376081","insp_unit_id":"190421134","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"PB76","insp_unit_license":"4RZ6654","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532B7KL120085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:00.000000Z","updated_at":"2025-03-17T22:19:00.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2487257\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2487257\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2487257\/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\/2487257\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}