{"current_page":1,"data":[{"id":7411964,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","dot_number":"3710856","report_state":"US","report_number":"1671001298","insp_date":"2024-12-10 00:00:00","insp_start_time":"1017","insp_end_time":"1144","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGRIBAR","shipping_paper_number":"AGB24B105","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-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"4","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":"1154524","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-12-13 21:40:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-13 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:46.000000Z","updated_at":"2025-03-17T20:50:46.000000Z","inspection_violations":[{"id":11581780,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_violation_id":"263891896","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"204770765","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:25.000000Z","updated_at":"2025-03-17T22:02:25.000000Z","normalized_code":"3965BL"},{"id":11581781,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_violation_id":"263891897","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"204770766","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:25.000000Z","updated_at":"2025-03-17T22:02:25.000000Z","normalized_code":"39345DB"},{"id":11581782,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_violation_id":"263891898","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204770765","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:25.000000Z","updated_at":"2025-03-17T22:02:25.000000Z","normalized_code":"39395F"},{"id":11581783,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_violation_id":"263891899","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204770765","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CHPDA160923","created_at":"2025-03-17T22:02:25.000000Z","updated_at":"2025-03-17T22:02:25.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":11957194,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_unit_id":"204770765","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"GREY05","insp_unit_license":"AM59295","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3HSDJAPR2EN794952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:00.000000Z","updated_at":"2025-03-17T23:47:00.000000Z"},{"id":11957195,"change_date":"2025-01-13 21:45:00","inspection_id":"83386262","insp_unit_id":"204770766","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"GHA3KY","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:00.000000Z","updated_at":"2025-03-17T23:47:00.000000Z"}]},{"id":6859851,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","dot_number":"3710856","report_state":"US","report_number":"1943000380","insp_date":"2024-09-19 00:00:00","insp_start_time":"1312","insp_end_time":"1403","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGRICOLA BARANZINI S DE RL DE CV","shipping_paper_number":"SCGLAE370412593","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-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"3","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":"902421","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-10-01 21:42:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:03.000000Z","updated_at":"2025-03-17T20:39:03.000000Z","inspection_violations":[{"id":10684331,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","insp_violation_id":"262119484","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"203208697","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39355D1"},{"id":10684332,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","insp_violation_id":"262119485","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"203208697","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39395F"},{"id":10684333,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","insp_violation_id":"262119486","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203208697","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11062412,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","insp_unit_id":"203208697","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"BRN 3X","insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:34.000000Z","updated_at":"2025-03-17T23:37:34.000000Z"},{"id":11062413,"change_date":"2024-10-01 21:42:00","inspection_id":"82801787","insp_unit_id":"203208698","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"2","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"Y","insp_unit_decal_number":"34451010","created_at":"2025-03-17T23:37:34.000000Z","updated_at":"2025-03-17T23:37:34.000000Z"}]},{"id":6305077,"change_date":"2024-07-25 21:43:00","inspection_id":"82210289","dot_number":"3710856","report_state":"US","report_number":"1943000289","insp_date":"2024-07-18 00:00:00","insp_start_time":"1300","insp_end_time":"1347","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGRICOLA BARANZINI S DE RL DE CV","shipping_paper_number":"SCGLAE370409565","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-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"686135","transaction_code":"A","transaction_date":"2024-07-25 00:00:00","upload_date":"2024-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-07-25 21:43:00","snet_input_date":"2024-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-25 21:43:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:49.000000Z","updated_at":"2025-03-17T20:27:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10159316,"change_date":"2024-07-25 21:43:00","inspection_id":"82210289","insp_unit_id":"202060880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"GREY","insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"Y","insp_unit_decal_number":"34450746","created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"},{"id":10159317,"change_date":"2024-07-25 21:43:00","inspection_id":"82210289","insp_unit_id":"202060881","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"03","insp_unit_license":"4TY2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"Y","insp_unit_decal_number":"34450747","created_at":"2025-03-17T23:28:13.000000Z","updated_at":"2025-03-17T23:28:13.000000Z"}]},{"id":5594409,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","dot_number":"3710856","report_state":"US","report_number":"1943000130","insp_date":"2024-04-24 00:00:00","insp_start_time":"1025","insp_end_time":"1140","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"SCGLAE370404467","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-04-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"3","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":"428944","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-04-25 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-25 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:32.000000Z","updated_at":"2025-03-17T20:13:32.000000Z","inspection_violations":[{"id":8649317,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","insp_violation_id":"259134103","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"200569423","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CHPDA272725","created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"393209D"},{"id":8649318,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","insp_violation_id":"259134104","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200569423","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"39345D"},{"id":8649319,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","insp_violation_id":"259134105","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"200569424","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:53.000000Z","updated_at":"2025-03-17T21:47:53.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":9011464,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","insp_unit_id":"200569423","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"BLUE\/ 2","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:51.000000Z","updated_at":"2025-03-17T23:16:51.000000Z"},{"id":9011465,"change_date":"2024-04-25 21:42:00","inspection_id":"81441782","insp_unit_id":"200569424","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"2","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:51.000000Z","updated_at":"2025-03-17T23:16:51.000000Z"}]},{"id":5478887,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","dot_number":"3710856","report_state":"US","report_number":"1945001037","insp_date":"2024-03-28 00:00:00","insp_start_time":"0900","insp_end_time":"1014","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SUN AND SANDS ENTERPRISES LLC","shipping_paper_number":"AGB24-118","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","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":"384386","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:13.000000Z","updated_at":"2025-03-17T20:11:13.000000Z","inspection_violations":[{"id":8460807,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","insp_violation_id":"258850122","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200327903","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:00.000000Z","updated_at":"2025-03-17T21:47:00.000000Z","normalized_code":"3922"},{"id":8460808,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","insp_violation_id":"258850123","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","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:47:00.000000Z","updated_at":"2025-03-17T21:47:00.000000Z","normalized_code":"39530B1"},{"id":8460809,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","insp_violation_id":"258850124","seq_no":"3","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:47:00.000000Z","updated_at":"2025-03-17T21:47:00.000000Z","normalized_code":"3953A3I"}],"inspection_per_units":[{"id":8825553,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","insp_unit_id":"200327903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"GRY\/05","insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"Y","insp_unit_decal_number":"33740845","created_at":"2025-03-17T23:15:06.000000Z","updated_at":"2025-03-17T23:15:06.000000Z"},{"id":8825554,"change_date":"2024-04-10 21:42:00","inspection_id":"81315860","insp_unit_id":"200327904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"Y","insp_unit_decal_number":"33740846","created_at":"2025-03-17T23:15:06.000000Z","updated_at":"2025-03-17T23:15:06.000000Z"}]},{"id":4981774,"change_date":"2024-02-06 21:41:00","inspection_id":"80773320","dot_number":"3710856","report_state":"US","report_number":"1303000811","insp_date":"2024-02-03 00:00:00","insp_start_time":"1152","insp_end_time":"1211","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"CALEXICO CA","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB2415","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-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"221880","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-02-06 21:41:00","snet_input_date":"2024-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-06 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:35.000000Z","updated_at":"2025-03-17T20:01:35.000000Z","inspection_violations":[{"id":7673476,"change_date":"2024-02-06 21:41:00","inspection_id":"80773320","insp_violation_id":"257675119","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"199277892","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:03.000000Z","updated_at":"2025-03-17T21:43:03.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":8017901,"change_date":"2024-02-06 21:41:00","inspection_id":"80773320","insp_unit_id":"199277892","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"5","insp_unit_license":"9F86697","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR2EN794952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:40.000000Z","updated_at":"2025-03-17T23:07:40.000000Z"},{"id":8017902,"change_date":"2024-02-06 21:41:00","inspection_id":"80773320","insp_unit_id":"199277893","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"5","insp_unit_license":"GPA8HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536EU830093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:40.000000Z","updated_at":"2025-03-17T23:07:40.000000Z"}]},{"id":4879845,"change_date":"2024-01-22 21:44:00","inspection_id":"80661788","dot_number":"3710856","report_state":"CA","report_number":"NDRG005219","insp_date":"2024-01-18 00:00:00","insp_start_time":"1410","insp_end_time":"1438","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN AND SANDS ENTERPRISES LLC","shipping_paper_number":"AE370390070","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-01-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15208248","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:17.000000Z","updated_at":"2025-03-17T19:59:17.000000Z","inspection_violations":[{"id":7520095,"change_date":"2024-01-22 21:44:00","inspection_id":"80661788","insp_violation_id":"257444155","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199060505","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA273649","created_at":"2025-03-17T21:42:19.000000Z","updated_at":"2025-03-17T21:42:19.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7851737,"change_date":"2024-01-22 21:44:00","inspection_id":"80661788","insp_unit_id":"199060504","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BRN","insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"},{"id":7851738,"change_date":"2024-01-22 21:44:00","inspection_id":"80661788","insp_unit_id":"199060505","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"GPA7HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2531EU830213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"}]},{"id":4879915,"change_date":"2024-01-22 21:44:00","inspection_id":"80661864","dot_number":"3710856","report_state":"CA","report_number":"UD6B000037","insp_date":"2024-01-18 00:00:00","insp_start_time":"1440","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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":"2024-01-22 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":"15208670","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:17.000000Z","updated_at":"2025-03-17T19:59:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7851847,"change_date":"2024-01-22 21:44:00","inspection_id":"80661864","insp_unit_id":"199060629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"BRN 3X","insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"Y","insp_unit_decal_number":"33554298","created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"},{"id":7851848,"change_date":"2024-01-22 21:44:00","inspection_id":"80661864","insp_unit_id":"199060630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHI 2X","insp_unit_license":"GPA7HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2531EU830213","insp_unit_decal":"Y","insp_unit_decal_number":"33554299","created_at":"2025-03-17T23:06:11.000000Z","updated_at":"2025-03-17T23:06:11.000000Z"}]},{"id":4553821,"change_date":"2023-12-04 21:42:00","inspection_id":"80305147","dot_number":"3710856","report_state":"CA","report_number":"UDIB001411","insp_date":"2023-11-27 00:00:00","insp_start_time":"0900","insp_end_time":"0924","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"EL CENTRO","county_code_state":"CA","county_code":"025","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":"N","pen_cen_match":null,"final_status_date":"2023-12-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"15153104","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-12-04 21:42:00","snet_input_date":"2023-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-04 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:01.000000Z","updated_at":"2025-03-17T19:53:01.000000Z","inspection_violations":[{"id":7044288,"change_date":"2023-12-04 21:42:00","inspection_id":"80305147","insp_violation_id":"256704228","seq_no":"1","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"198341349","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA272746","created_at":"2025-03-17T21:40:01.000000Z","updated_at":"2025-03-17T21:40:01.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":7324217,"change_date":"2023-12-04 21:42:00","inspection_id":"80305147","insp_unit_id":"198341349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:31.000000Z","updated_at":"2025-03-17T23:01:31.000000Z"},{"id":7324218,"change_date":"2023-12-04 21:42:00","inspection_id":"80305147","insp_unit_id":"198341350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:31.000000Z","updated_at":"2025-03-17T23:01:31.000000Z"}]},{"id":3647908,"change_date":"2023-08-02 21:40:00","inspection_id":"79299899","dot_number":"3710856","report_state":"US","report_number":"1303000278","insp_date":"2023-07-27 00:00:00","insp_start_time":"1000","insp_end_time":"1017","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB23V37","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":"2023-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"36836","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-08-02 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-08-02 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:55.000000Z","updated_at":"2025-03-17T19:34:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5865508,"change_date":"2023-08-02 21:40:00","inspection_id":"79299899","insp_unit_id":"196312643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"9F86697","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR2EN794952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:19.000000Z","updated_at":"2025-03-17T22:49:19.000000Z"},{"id":5865509,"change_date":"2023-08-02 21:40:00","inspection_id":"79299899","insp_unit_id":"196312644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"GPA8HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536EU830093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:19.000000Z","updated_at":"2025-03-17T22:49:19.000000Z"}]},{"id":3338858,"change_date":"2023-06-22 21:41:00","inspection_id":"78953007","dot_number":"3710856","report_state":"US","report_number":"1303000167","insp_date":"2023-06-20 00:00:00","insp_start_time":"1143","insp_end_time":"1217","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB23V-20","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":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"2","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":"25187","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-06-22 21:41:00","snet_input_date":"2023-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[{"id":5148789,"change_date":"2023-06-22 21:41:00","inspection_id":"78953007","insp_violation_id":"253633660","seq_no":"1","part_no":"395","part_no_section":"8E1PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":null,"defect_verification_id":null,"citation_number":"0N","created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3958E1PC"},{"id":5148790,"change_date":"2023-06-22 21:41:00","inspection_id":"78953007","insp_violation_id":"253633661","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"195615699","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":5367908,"change_date":"2023-06-22 21:41:00","inspection_id":"78953007","insp_unit_id":"195615699","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"},{"id":5367909,"change_date":"2023-06-22 21:41:00","inspection_id":"78953007","insp_unit_id":"195615700","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":null,"insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"}]},{"id":3135222,"change_date":"2023-05-24 21:41:00","inspection_id":"78723074","dot_number":"3710856","report_state":"CA","report_number":"ND4O003500","insp_date":"2023-05-23 00:00:00","insp_start_time":"1542","insp_end_time":"1619","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AG23V-07","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14915862","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:00.000000Z","updated_at":"2025-03-17T19:25:00.000000Z","inspection_violations":[{"id":4827652,"change_date":"2023-05-24 21:41:00","inspection_id":"78723074","insp_violation_id":"253065286","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195129710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3939A"},{"id":4827653,"change_date":"2023-05-24 21:41:00","inspection_id":"78723074","insp_violation_id":"253065287","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195129710","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5042825,"change_date":"2023-05-24 21:41:00","inspection_id":"78723074","insp_unit_id":"195129710","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/BROWN","insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5042826,"change_date":"2023-05-24 21:41:00","inspection_id":"78723074","insp_unit_id":"195129711","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04\/WHITE","insp_unit_license":"GPA7HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2531EU830213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":3136570,"change_date":"2023-05-25 21:41:00","inspection_id":"78724522","dot_number":"3710856","report_state":"US","report_number":"1303000073","insp_date":"2023-05-22 00:00:00","insp_start_time":"1128","insp_end_time":"1145","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB23V06","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":"2023-05-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"17932","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-05-25 21:41:00","snet_input_date":"2023-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-05-25 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:00.000000Z","updated_at":"2025-03-17T19:25:00.000000Z","inspection_violations":[{"id":4829121,"change_date":"2023-05-25 21:41:00","inspection_id":"78724522","insp_violation_id":"253067195","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"195131953","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":5044755,"change_date":"2023-05-25 21:41:00","inspection_id":"78724522","insp_unit_id":"195131953","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5044756,"change_date":"2023-05-25 21:41:00","inspection_id":"78724522","insp_unit_id":"195131954","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"4TY2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":2903322,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","dot_number":"3710856","report_state":"CA","report_number":"ND4O003419","insp_date":"2023-04-25 00:00:00","insp_start_time":"1627","insp_end_time":"1711","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ELVA FRESH PRODUCE","shipping_paper_number":"8E523135615","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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14875721","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-04-26 21:42:00","snet_input_date":"2023-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-26 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:24.000000Z","updated_at":"2025-03-17T19:20:24.000000Z","inspection_violations":[{"id":4455326,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","insp_violation_id":"252468356","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194610871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:45.000000Z","updated_at":"2025-03-17T21:27:45.000000Z","normalized_code":"3922"},{"id":4455327,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","insp_violation_id":"252468357","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194610871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:45.000000Z","updated_at":"2025-03-17T21:27:45.000000Z","normalized_code":"3922"},{"id":4455328,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","insp_violation_id":"252468358","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"194610871","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:45.000000Z","updated_at":"2025-03-17T21:27:45.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":4670911,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","insp_unit_id":"194610871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"04\/BROWN","insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:51.000000Z","updated_at":"2025-03-17T22:39:51.000000Z"},{"id":4670912,"change_date":"2023-04-26 21:42:00","inspection_id":"78461481","insp_unit_id":"194610872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"04\/WHITE","insp_unit_license":"GPA7HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2531EU830213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:51.000000Z","updated_at":"2025-03-17T22:39:51.000000Z"}]},{"id":2833754,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","dot_number":"3710856","report_state":"CA","report_number":"NDGS007403","insp_date":"2023-04-13 00:00:00","insp_start_time":"1405","insp_end_time":"1435","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"370372433","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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14860853","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-04-18 21:42:00","snet_input_date":"2023-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:56.000000Z","updated_at":"2025-03-17T19:18:56.000000Z","inspection_violations":[{"id":4348166,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","insp_violation_id":"252298069","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"194458462","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"393207A"},{"id":4348167,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","insp_violation_id":"252298070","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194458461","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"JS69409","created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39345D"},{"id":4348168,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","insp_violation_id":"252298071","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"1","insp_unit_id":"194458461","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA448371","created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":4561333,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","insp_unit_id":"194458461","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"GRY#05","insp_unit_license":"9F86697","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR2EN794952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"},{"id":4561334,"change_date":"2023-04-18 21:42:00","inspection_id":"78382484","insp_unit_id":"194458462","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT\/AMID05","insp_unit_license":"GPA8HM","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1UYVS2536EU830093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:59.000000Z","updated_at":"2025-03-17T22:38:59.000000Z"}]},{"id":2784478,"change_date":"2023-04-12 21:40:00","inspection_id":"78326631","dot_number":"3710856","report_state":"US","report_number":"1303000006","insp_date":"2023-04-12 00:00:00","insp_start_time":"0804","insp_end_time":"0804","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CALEXICOCA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRIBAR","shipping_paper_number":"AGB23-123","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":"2023-04-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"7874","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-04-12 21:40:00","snet_input_date":"2023-04-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-04-12 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:03.000000Z","updated_at":"2025-03-17T19:18:03.000000Z","inspection_violations":[{"id":4272767,"change_date":"2023-04-12 21:40:00","inspection_id":"78326631","insp_violation_id":"252169010","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"194340005","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":4481769,"change_date":"2023-04-12 21:40:00","inspection_id":"78326631","insp_unit_id":"194340005","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:20.000000Z","updated_at":"2025-03-17T22:38:20.000000Z"},{"id":4481770,"change_date":"2023-04-12 21:40:00","inspection_id":"78326631","insp_unit_id":"194340006","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"4TY2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:20.000000Z","updated_at":"2025-03-17T22:38:20.000000Z"}]},{"id":2780291,"change_date":"2023-04-11 21:40:00","inspection_id":"78322123","dot_number":"3710856","report_state":"CA","report_number":"N8L2004034","insp_date":"2023-04-03 00:00:00","insp_start_time":"0829","insp_end_time":"0856","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN AND SANDS ENTERPRISES LLC","shipping_paper_number":"AGB23-108","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-04-11 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":"14854942","transaction_code":"A","transaction_date":"2023-04-03 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-04-11 21:40:00","snet_input_date":"2023-04-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-11 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:02.000000Z","updated_at":"2025-03-17T19:18:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4475565,"change_date":"2023-04-11 21:40:00","inspection_id":"78322123","insp_unit_id":"194332963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3\/GRAY","insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"Y","insp_unit_decal_number":"32520478","created_at":"2025-03-17T22:38:17.000000Z","updated_at":"2025-03-17T22:38:17.000000Z"},{"id":4475566,"change_date":"2023-04-11 21:40:00","inspection_id":"78322123","insp_unit_id":"194332964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"03\/WHT","insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"Y","insp_unit_decal_number":"32520479","created_at":"2025-03-17T22:38:17.000000Z","updated_at":"2025-03-17T22:38:17.000000Z"}]},{"id":2687867,"change_date":"2023-03-29 21:42:00","inspection_id":"78216944","dot_number":"3710856","report_state":"AZ","report_number":"0225006881","insp_date":"2023-03-28 00:00:00","insp_start_time":"1101","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"GRUPO AGRICOLA FIGUEROA AVINA","shipping_paper_number":"E00084","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-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"119350","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":"1805553","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-03-29 21:42:00","snet_input_date":"2023-03-29 00:00:00","source_office":"4AZS001","mcmis_add_date":"2023-03-29 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"PO BOX 6052","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85366","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:13.000000Z","updated_at":"2025-03-17T19:16:13.000000Z","inspection_violations":[{"id":4129667,"change_date":"2023-03-29 21:42:00","inspection_id":"78216944","insp_violation_id":"251935508","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194125539","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:20.000000Z","updated_at":"2025-03-17T21:26:20.000000Z","normalized_code":"39347E"},{"id":4129668,"change_date":"2023-03-29 21:42:00","inspection_id":"78216944","insp_violation_id":"251935509","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194125539","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:20.000000Z","updated_at":"2025-03-17T21:26:20.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":4327373,"change_date":"2023-03-29 21:42:00","inspection_id":"78216944","insp_unit_id":"194125539","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:05.000000Z","updated_at":"2025-03-17T22:37:05.000000Z"},{"id":4327374,"change_date":"2023-03-29 21:42:00","inspection_id":"78216944","insp_unit_id":"194125540","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"AMID02","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"Y","insp_unit_decal_number":"32334172","created_at":"2025-03-17T22:37:05.000000Z","updated_at":"2025-03-17T22:37:05.000000Z"}]},{"id":2926836,"change_date":"2023-05-01 10:45:00","inspection_id":"78487981","dot_number":"3710856","report_state":"US","report_number":"0993022562","insp_date":"2023-03-27 00:00:00","insp_start_time":"1146","insp_end_time":"1314","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGROEXPORTACIONES DE SONORA","shipping_paper_number":"264-0788494-4","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-05-01 10:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"435566","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-05-01 10:45:00","snet_input_date":"2023-04-24 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-05-01 10:45:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:54.000000Z","updated_at":"2025-03-17T19:20:54.000000Z","inspection_violations":[{"id":4492006,"change_date":"2023-05-01 10:45:00","inspection_id":"78487981","insp_violation_id":"252525826","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"194663061","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"393209E"},{"id":4492007,"change_date":"2023-05-01 10:45:00","inspection_id":"78487981","insp_violation_id":"252525827","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194663061","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4709041,"change_date":"2023-05-01 10:45:00","inspection_id":"78487981","insp_unit_id":"194663060","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"Y","insp_unit_decal_number":"32358261","created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"},{"id":4709042,"change_date":"2023-05-01 10:45:00","inspection_id":"78487981","insp_unit_id":"194663061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1\/BLUE","insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"}]},{"id":2926652,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","dot_number":"3710856","report_state":"US","report_number":"1229021644","insp_date":"2023-03-22 00:00:00","insp_start_time":"1155","insp_end_time":"1235","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"GRUPO AGRICOLA FIGUEROA AVINA","shipping_paper_number":"SCGL26407882468","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-05-01 10:45:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"435319","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2023-05-01 10:45:00","snet_input_date":"2023-04-14 00:00:00","source_office":"4AZD001","mcmis_add_date":"2023-05-01 10:45:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"302 E LYNWOOD LN","insp_carrier_city":"MESA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85201","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:54.000000Z","updated_at":"2025-03-17T19:20:54.000000Z","inspection_violations":[{"id":4491175,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_violation_id":"252524928","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194662734","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39345D"},{"id":4491176,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_violation_id":"252524929","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194662735","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39375A3"},{"id":4491177,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_violation_id":"252524930","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194662735","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"3963A1"},{"id":4491178,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_violation_id":"252524931","seq_no":"4","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:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39530B1"},{"id":4491179,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_violation_id":"252524932","seq_no":"5","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194662734","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:56.000000Z","updated_at":"2025-03-17T21:27:56.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4708731,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_unit_id":"194662734","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"},{"id":4708732,"change_date":"2023-05-01 10:45:00","inspection_id":"78487792","insp_unit_id":"194662735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:07.000000Z","updated_at":"2025-03-17T22:40:07.000000Z"}]},{"id":2361323,"change_date":"2023-02-13 21:43:00","inspection_id":"77844761","dot_number":"3710856","report_state":"US","report_number":"1303230773","insp_date":"2023-01-30 00:00:00","insp_start_time":"1115","insp_end_time":"1129","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CHP INSPECTION FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB2314","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-02-13 21:43: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":"395811","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"4CAD001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"PO BOX 6052","insp_carrier_city":"YUMA","insp_carrier_state":"AZ","insp_carrier_zip_code":"85366","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:17.000000Z","updated_at":"2025-03-17T19:10:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3800625,"change_date":"2023-02-13 21:43:00","inspection_id":"77844761","insp_unit_id":"193376909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F86699","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR2CSBA3267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"},{"id":3800626,"change_date":"2023-02-13 21:43:00","inspection_id":"77844761","insp_unit_id":"193376910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:14.000000Z","updated_at":"2025-03-17T22:33:14.000000Z"}]},{"id":1650193,"change_date":"2022-11-01 21:41:00","inspection_id":"77031460","dot_number":"3710856","report_state":"US","report_number":"1303230622","insp_date":"2022-10-20 00:00:00","insp_start_time":"1310","insp_end_time":"1324","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CHP INSPECTION FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB22B79","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-11-01 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":"394332","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-01 00:00:00","source_office":"4CAD001","mcmis_add_date":"2022-11-01 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:04.000000Z","updated_at":"2025-03-17T18:57:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2655476,"change_date":"2022-11-01 21:41:00","inspection_id":"77031460","insp_unit_id":"191756199","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"},{"id":2655477,"change_date":"2022-11-01 21:41:00","inspection_id":"77031460","insp_unit_id":"191756200","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"}]},{"id":1545651,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","dot_number":"3710856","report_state":"CA","report_number":"ND3G004027","insp_date":"2022-10-17 00:00:00","insp_start_time":"1336","insp_end_time":"1720","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB22B-74","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-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14638783","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-10-18 21:40:00","snet_input_date":"2022-10-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-10-18 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:11.000000Z","updated_at":"2025-03-17T18:55:11.000000Z","inspection_violations":[{"id":2432637,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","insp_violation_id":"249107818","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191510220","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39345B2"},{"id":2432638,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","insp_violation_id":"249107819","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"1","insp_unit_id":"191510219","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39524D"},{"id":2432639,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","insp_violation_id":"249107820","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191510219","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:19.000000Z","updated_at":"2025-03-17T21:18:19.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":2487550,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","insp_unit_id":"191510219","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1\/BLUE","insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"Y","insp_unit_decal_number":"31865834","created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"},{"id":2487551,"change_date":"2022-10-18 21:40:00","inspection_id":"76911102","insp_unit_id":"191510220","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"01\/WHITE","insp_unit_license":"4TY2037","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"Y","insp_unit_decal_number":"31865835","created_at":"2025-03-17T22:24:03.000000Z","updated_at":"2025-03-17T22:24:03.000000Z"}]},{"id":1409930,"change_date":"2022-09-29 21:41:00","inspection_id":"76754337","dot_number":"3710856","report_state":"CA","report_number":"UDIB000930","insp_date":"2022-09-27 00:00:00","insp_start_time":"0750","insp_end_time":"0820","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO","county_code_state":"CA","county_code":"025","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-09-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"14615043","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-09-29 21:41:00","snet_input_date":"2022-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-29 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:42.000000Z","updated_at":"2025-03-17T18:52:42.000000Z","inspection_violations":[{"id":2222731,"change_date":"2022-09-29 21:41:00","inspection_id":"76754337","insp_violation_id":"248750422","seq_no":"1","part_no":"396","part_no_section":"7","insp_viol_unit":"2","insp_unit_id":"191195964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA270348","created_at":"2025-03-17T21:17:13.000000Z","updated_at":"2025-03-17T21:17:13.000000Z","normalized_code":"3967"},{"id":2222732,"change_date":"2022-09-29 21:41:00","inspection_id":"76754337","insp_violation_id":"248750423","seq_no":"2","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"2","insp_unit_id":"191195964","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KD02410","created_at":"2025-03-17T21:17:13.000000Z","updated_at":"2025-03-17T21:17:13.000000Z","normalized_code":"39360E"}],"inspection_per_units":[{"id":2269975,"change_date":"2022-09-29 21:41:00","inspection_id":"76754337","insp_unit_id":"191195963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:31.000000Z","updated_at":"2025-03-17T22:22:31.000000Z"},{"id":2269976,"change_date":"2022-09-29 21:41:00","inspection_id":"76754337","insp_unit_id":"191195964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":null,"insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:31.000000Z","updated_at":"2025-03-17T22:22:31.000000Z"}]},{"id":1115511,"change_date":"2022-08-23 21:42:00","inspection_id":"76412505","dot_number":"3710856","report_state":"AZ","report_number":"OY4U000410","insp_date":"2022-08-11 00:00:00","insp_start_time":"1056","insp_end_time":"1155","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI S DE RL DE CV","shipping_paper_number":"370350116","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":"Y","pen_cen_match":"I","final_status_date":"2022-08-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1764438","transaction_code":"A","transaction_date":"2022-08-11 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-08-23 21:42:00","snet_input_date":"2022-08-23 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:16.000000Z","updated_at":"2025-03-17T18:47:16.000000Z","inspection_violations":[{"id":1760199,"change_date":"2022-08-23 21:42:00","inspection_id":"76412505","insp_violation_id":"247934030","seq_no":"1","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:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":1794207,"change_date":"2022-08-23 21:42:00","inspection_id":"76412505","insp_unit_id":"190495127","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"Y","insp_unit_decal_number":"31678489","created_at":"2025-03-17T22:19:19.000000Z","updated_at":"2025-03-17T22:19:19.000000Z"},{"id":1794208,"change_date":"2022-08-23 21:42:00","inspection_id":"76412505","insp_unit_id":"190495128","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"Y","insp_unit_decal_number":"31678490","created_at":"2025-03-17T22:19:19.000000Z","updated_at":"2025-03-17T22:19:19.000000Z"}]},{"id":888820,"change_date":"2022-07-25 21:40:00","inspection_id":"76147161","dot_number":"3710856","report_state":"CA","report_number":"UC5Z001147","insp_date":"2022-07-11 00:00:00","insp_start_time":"1000","insp_end_time":"1028","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN AND SANDS ENTER","shipping_paper_number":"SCGLAE370348029","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"90000","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":"14519686","transaction_code":"A","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-07-25 21:40:00","snet_input_date":"2022-07-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:23.000000Z","updated_at":"2025-03-17T18:43:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1431089,"change_date":"2022-07-25 21:40:00","inspection_id":"76147161","insp_unit_id":"189953475","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"},{"id":1431090,"change_date":"2022-07-25 21:40:00","inspection_id":"76147161","insp_unit_id":"189953476","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHT\/2X","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:00.000000Z","updated_at":"2025-03-17T22:17:00.000000Z"}]},{"id":819638,"change_date":"2022-07-14 21:41:00","inspection_id":"76066606","dot_number":"3710856","report_state":"AZ","report_number":"OY4U000383","insp_date":"2022-07-06 00:00:00","insp_start_time":"1025","insp_end_time":"1114","registration_date":null,"region":"MT","ci_status_code":"C","location":"SLPOE2","location_desc":"SAN LUIS PORT OF ENTRY 2","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI S DE RL DE CV","shipping_paper_number":"370347690","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":"Y","pen_cen_match":"I","final_status_date":"2022-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1758643","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-07-14 21:41:00","snet_input_date":"2022-07-14 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[{"id":1292317,"change_date":"2022-07-14 21:41:00","inspection_id":"76066606","insp_violation_id":"247096886","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"189780932","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"39345B2"},{"id":1292318,"change_date":"2022-07-14 21:41:00","inspection_id":"76066606","insp_violation_id":"247096887","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189780931","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:06.000000Z","updated_at":"2025-03-17T21:13:06.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1318744,"change_date":"2022-07-14 21:41:00","inspection_id":"76066606","insp_unit_id":"189780931","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"},{"id":1318745,"change_date":"2022-07-14 21:41:00","inspection_id":"76066606","insp_unit_id":"189780932","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"}]},{"id":750121,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","dot_number":"3710856","report_state":"US","report_number":"1229021058","insp_date":"2022-07-02 00:00:00","insp_start_time":"1055","insp_end_time":"1140","registration_date":"2022-09-26 00:00:00","region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINA S DE RL DE C V","shipping_paper_number":"SCGLAE370347476","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-07-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"427000","transaction_code":"C","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-05 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-07-05 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:54.000000Z","updated_at":"2025-03-17T18:40:54.000000Z","inspection_violations":[{"id":1181361,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_violation_id":"248701544","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149825","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"3963A1"},{"id":1181362,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_violation_id":"248701545","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191149825","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"39347E"},{"id":1181363,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_violation_id":"248701546","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191149825","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"39353B"},{"id":1181364,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_violation_id":"248701547","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"191149826","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"39345D"},{"id":1181365,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_violation_id":"248701548","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:12:32.000000Z","updated_at":"2025-03-17T21:12:32.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":1206306,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_unit_id":"191149825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"},{"id":1206307,"change_date":"2022-09-28 21:40:00","inspection_id":"75985574","insp_unit_id":"191149826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:36.000000Z","updated_at":"2025-03-17T22:15:36.000000Z"}]},{"id":684136,"change_date":"2022-06-23 21:40:00","inspection_id":"75907652","dot_number":"3710856","report_state":"CA","report_number":"NABI004463","insp_date":"2022-06-22 00:00:00","insp_start_time":"1120","insp_end_time":"1142","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB22-212","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-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14480539","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-06-23 21:40:00","snet_input_date":"2022-06-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:48.000000Z","updated_at":"2025-03-17T18:39:48.000000Z","inspection_violations":[{"id":1077730,"change_date":"2022-06-23 21:40:00","inspection_id":"75907652","insp_violation_id":"246691768","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189437819","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:02.000000Z","updated_at":"2025-03-17T21:12:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1099515,"change_date":"2022-06-23 21:40:00","inspection_id":"75907652","insp_unit_id":"189437819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BLUE","insp_unit_license":"YP19398","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49X4CJ312699","insp_unit_decal":"Y","insp_unit_decal_number":"31174165","created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"},{"id":1099516,"change_date":"2022-06-23 21:40:00","inspection_id":"75907652","insp_unit_id":"189437820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"WHT","insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2535FM838316","insp_unit_decal":"Y","insp_unit_decal_number":"31174166","created_at":"2025-03-17T22:14:57.000000Z","updated_at":"2025-03-17T22:14:57.000000Z"}]},{"id":712549,"change_date":"2022-06-28 21:43:00","inspection_id":"75941502","dot_number":"3710856","report_state":"US","report_number":"1303230052","insp_date":"2022-06-20 00:00:00","insp_start_time":"0940","insp_end_time":"1003","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CHP INSPECTION FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"02-H1","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-06-28 21:43: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":"390822","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-28 00:00:00","source_office":"4CAD001","mcmis_add_date":"2022-06-28 21:43:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:12.000000Z","updated_at":"2025-03-17T18:40:12.000000Z","inspection_violations":[{"id":1121662,"change_date":"2022-06-28 21:43:00","inspection_id":"75941502","insp_violation_id":"246779020","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:16.000000Z","updated_at":"2025-03-17T21:12:16.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":1145590,"change_date":"2022-06-28 21:43:00","inspection_id":"75941502","insp_unit_id":"189510443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"},{"id":1145591,"change_date":"2022-06-28 21:43:00","inspection_id":"75941502","insp_unit_id":"189510444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHT\/2X","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:15.000000Z","updated_at":"2025-03-17T22:15:15.000000Z"}]},{"id":720828,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","dot_number":"3710856","report_state":"US","report_number":"0993022027","insp_date":"2022-06-17 00:00:00","insp_start_time":"0938","insp_end_time":"1035","registration_date":"2022-09-26 00:00:00","region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI S DE RL DE CV","shipping_paper_number":"AE370346437","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-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"9","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"426387","transaction_code":"C","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:29.000000Z","updated_at":"2025-03-17T18:40:29.000000Z","inspection_violations":[{"id":1133646,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701232","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39378"},{"id":1133647,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701233","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"393209E"},{"id":1133648,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701234","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133649,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701235","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3939A"},{"id":1133650,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701236","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133651,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701237","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191149714","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133652,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701238","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149713","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133653,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701239","seq_no":"8","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"191149714","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3965B"},{"id":1133654,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_violation_id":"248701240","seq_no":"9","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:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":1158655,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_unit_id":"191149713","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"},{"id":1158656,"change_date":"2022-09-28 21:40:00","inspection_id":"75951191","insp_unit_id":"191149714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHT\/2X","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"}]},{"id":720784,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","dot_number":"3710856","report_state":"US","report_number":"0993022025","insp_date":"2022-06-16 00:00:00","insp_start_time":"1056","insp_end_time":"1143","registration_date":"2022-09-26 00:00:00","region":"MT","ci_status_code":"C","location":"SLUIS","location_desc":"SAN LUIS PORT OF ENTRY","county_code_state":"AZ","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA B. S DE RL CV","shipping_paper_number":"AE370346395","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-06-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"426383","transaction_code":"C","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-29 00:00:00","source_office":"4AZD001","mcmis_add_date":"2022-06-29 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:29.000000Z","updated_at":"2025-03-17T18:40:29.000000Z","inspection_violations":[{"id":1133441,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_violation_id":"248701227","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149711","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133442,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_violation_id":"248701228","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149711","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"3963A1"},{"id":1133443,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_violation_id":"248701229","seq_no":"3","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"191149711","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39375A1"},{"id":1133444,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_violation_id":"248701230","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191149712","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39375C"},{"id":1133445,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_violation_id":"248701231","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191149712","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:17.000000Z","updated_at":"2025-03-17T21:12:17.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":1158577,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_unit_id":"191149711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"},{"id":1158578,"change_date":"2022-09-28 21:40:00","inspection_id":"75951146","insp_unit_id":"191149712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:18.000000Z","updated_at":"2025-03-17T22:15:18.000000Z"}]},{"id":372253,"change_date":"2022-05-11 21:40:00","inspection_id":"75536711","dot_number":"3710856","report_state":"US","report_number":"1303221197","insp_date":"2022-05-09 00:00:00","insp_start_time":"0835","insp_end_time":"0851","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CHP INSPECTION FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB22189","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-05-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"389584","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-11 00:00:00","source_office":"4CAD001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:01.000000Z","updated_at":"2025-03-17T18:34:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":602318,"change_date":"2022-05-11 21:40:00","inspection_id":"75536711","insp_unit_id":"188639034","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"YP19396","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKFD49XXDJ321098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"},{"id":602319,"change_date":"2022-05-11 21:40:00","inspection_id":"75536711","insp_unit_id":"188639035","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3","insp_unit_license":"4TY2036","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2537FU989223","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"}]},{"id":260046,"change_date":"2022-04-26 21:42:00","inspection_id":"75403509","dot_number":"3710856","report_state":"US","report_number":"1303221140","insp_date":"2022-04-20 00:00:00","insp_start_time":"0806","insp_end_time":"0820","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CHP INSPECTION FACILITY","county_code_state":"CA","county_code":"025","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AGRICOLA BARANZINI","shipping_paper_number":"AGB22173","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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"388979","transaction_code":"A","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-26 00:00:00","source_office":"4CAD001","mcmis_add_date":"2022-04-26 21:42:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"1302300","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:11.000000Z","updated_at":"2025-03-17T18:32:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":421282,"change_date":"2022-04-26 21:42:00","inspection_id":"75403509","insp_unit_id":"188356063","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"},{"id":421283,"change_date":"2022-04-26 21:42:00","inspection_id":"75403509","insp_unit_id":"188356064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHT\/2X","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:48.000000Z","updated_at":"2025-03-17T22:10:48.000000Z"}]},{"id":56909,"change_date":"2022-03-28 21:41:00","inspection_id":"75157865","dot_number":"3710856","report_state":"CA","report_number":"N9RG003593","insp_date":"2022-03-25 00:00:00","insp_start_time":"0630","insp_end_time":"0707","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","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-03-28 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":"14361354","transaction_code":"A","transaction_date":"2022-03-25 00:00:00","upload_date":"2022-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-03-28 21:41:00","snet_input_date":"2022-03-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-28 21:41:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:28.000000Z","updated_at":"2025-03-17T18:28:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":92520,"change_date":"2022-03-28 21:41:00","inspection_id":"75157865","insp_unit_id":"187860171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"Y","insp_unit_decal_number":"30828539","created_at":"2025-03-17T22:08:48.000000Z","updated_at":"2025-03-17T22:08:48.000000Z"}]},{"id":47428,"change_date":"2022-03-25 21:32:00","inspection_id":"75146068","dot_number":"3710856","report_state":"CA","report_number":"NA2H004632","insp_date":"2022-03-23 00:00:00","insp_start_time":"0743","insp_end_time":"0808","registration_date":null,"region":"PT","ci_status_code":"C","location":"626","location_desc":"CALEXICO IF","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUN AND SANDS ENTERPRISE","shipping_paper_number":"AGB22-120","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-25 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"14359337","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03710856","upload_search_indicator":null,"census_search_date":"2022-03-25 21:32:00","snet_input_date":"2022-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-03-25 21:32:00","insp_carrier_name":"JESUS ALBERTO SOTO CASTILLO","insp_carrier_street":"280 CAMPILLO ST STE I","insp_carrier_city":"CALEXICO","insp_carrier_state":"CA","insp_carrier_zip_code":"92231","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:25.000000Z","updated_at":"2025-03-17T18:28:25.000000Z","inspection_violations":[{"id":67751,"change_date":"2022-03-25 21:32:00","inspection_id":"75146068","insp_violation_id":"244793938","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"187834360","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA257487","created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"3965B"},{"id":67752,"change_date":"2022-03-25 21:32:00","inspection_id":"75146068","insp_violation_id":"244793939","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"187834361","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"JJ80087","created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":76485,"change_date":"2022-03-25 21:32:00","inspection_id":"75146068","insp_unit_id":"187834360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BLU\/2\/3X","insp_unit_license":"YP19397","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPHD49X8DD210356","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:43.000000Z","updated_at":"2025-03-17T22:08:43.000000Z"},{"id":76486,"change_date":"2022-03-25 21:32:00","inspection_id":"75146068","insp_unit_id":"187834361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHT\/02\/2X","insp_unit_license":"4TY2038","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"527SR5328GL006350","insp_unit_decal":"Y","insp_unit_decal_number":"30828334","created_at":"2025-03-17T22:08:43.000000Z","updated_at":"2025-03-17T22:08:43.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3710856\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3710856\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3710856\/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\/3710856\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}