{"current_page":1,"data":[{"id":12489632,"change_date":"2026-07-18 21:35:00","inspection_id":"88452831","dot_number":"3065277","report_state":"CA","report_number":"NDLY010802","insp_date":"2026-07-17 00:00:00","insp_start_time":"0940","insp_end_time":"1004","registration_date":null,"region":"PD","ci_status_code":"C","location":"464","location_desc":"CA","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRANZA","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-18 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"3786754","transaction_code":"A","transaction_date":"2026-07-18 00:00:00","upload_date":"2026-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2026-07-18 21:35:00","snet_input_date":"2026-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-18 21:35:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"1412 S FIRST ST SPC B","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2026-07-21T09:42:52.000000Z","updated_at":"2026-07-28T09:32:31.000000Z","inspection_violations":[{"id":21743171,"change_date":"2026-07-18 21:35:00","inspection_id":"88452831","insp_violation_id":"275596704","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214699465","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-07-21T10:05:50.000000Z","updated_at":"2026-07-28T09:45:55.000000Z","normalized_code":"3922SLLSR"},{"id":21743172,"change_date":"2026-07-18 21:35:00","inspection_id":"88452831","insp_violation_id":"275596705","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"214699466","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA810273","created_at":"2026-07-21T10:05:50.000000Z","updated_at":"2026-07-28T09:45:55.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21692055,"change_date":"2026-07-18 21:35:00","inspection_id":"88452831","insp_unit_id":"214699465","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:34.000000Z","updated_at":"2026-07-28T09:04:52.000000Z"},{"id":21692056,"change_date":"2026-07-18 21:35:00","inspection_id":"88452831","insp_unit_id":"214699466","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02-C\/FB\/GRN","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:34.000000Z","updated_at":"2026-07-28T09:04:52.000000Z"}]},{"id":11637231,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","dot_number":"3065277","report_state":"CA","report_number":"UFZ1000292","insp_date":"2026-04-13 00:00:00","insp_start_time":"0830","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"SANTA CRUZ","county_code_state":"CA","county_code":"087","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GOLDEN STATE LUMBER","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":"2026-04-13 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"11","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16244272","transaction_code":"A","transaction_date":"2026-04-13 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2026-04-13 21:38:00","snet_input_date":"2026-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-13 21:38:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"1412 S FIRST ST SPC B","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2026-04-24T09:31:46.000000Z","updated_at":"2026-04-24T09:31:46.000000Z","inspection_violations":[{"id":20201239,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577789","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"3922SLLED"},{"id":20201240,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577790","seq_no":"2","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"393110B3C"},{"id":20201241,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577791","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39375A3TAOL"},{"id":20201242,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577792","seq_no":"4","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"212996479","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39375A3TAOL"},{"id":20201243,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577793","seq_no":"5","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":20201244,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577794","seq_no":"6","part_no":"393","part_no_section":"11A1-LSLM","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SP49297","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39311A1LSLM"},{"id":20201245,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577795","seq_no":"7","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"2","insp_unit_id":"212996480","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39311A1LCL"},{"id":20201246,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577796","seq_no":"8","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212996479","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"3922SLLEQP"},{"id":20201247,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577797","seq_no":"9","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"212996479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"39311A1LFTSM"},{"id":20201248,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577798","seq_no":"10","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"212996479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"3939AHLLH"},{"id":20201249,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_violation_id":"273577799","seq_no":"11","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"1","insp_unit_id":"212996479","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-24T09:44:42.000000Z","updated_at":"2026-04-24T09:44:42.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":20241111,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_unit_id":"212996480","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:04:39.000000Z","updated_at":"2026-04-24T09:04:39.000000Z"},{"id":20241110,"change_date":"2026-04-13 21:38:00","inspection_id":"87566091","insp_unit_id":"212996479","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-24T09:04:39.000000Z","updated_at":"2026-04-24T09:04:39.000000Z"}]},{"id":9158373,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","dot_number":"3065277","report_state":"CA","report_number":"UDP0006107","insp_date":"2025-07-15 00:00:00","insp_start_time":"0646","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"9265","location_desc":"STOCKTON AREA","county_code_state":"CA","county_code":"077","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":"2025-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"15899367","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2025-07-15 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-15 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"1412 S FIRST ST SPC B","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-07-18T10:46:09.000000Z","updated_at":"2025-07-19T10:42:22.000000Z","inspection_violations":[{"id":14779677,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","insp_violation_id":"267429362","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207889481","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SJ57295","created_at":"2025-07-18T10:48:29.000000Z","updated_at":"2025-07-18T10:48:29.000000Z","normalized_code":"3922SLLSR"},{"id":14779678,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","insp_violation_id":"267429363","seq_no":"2","part_no":"393","part_no_section":"118D-CDL","insp_viol_unit":"2","insp_unit_id":"207889481","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:29.000000Z","updated_at":"2025-07-18T10:48:29.000000Z","normalized_code":"393118DCDL"},{"id":14779679,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","insp_violation_id":"267429364","seq_no":"3","part_no":"393","part_no_section":"110B3-C","insp_viol_unit":"2","insp_unit_id":"207889481","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-18T10:48:29.000000Z","updated_at":"2025-07-18T10:48:29.000000Z","normalized_code":"393110B3C"}],"inspection_per_units":[{"id":15042309,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","insp_unit_id":"207889480","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"DF76A71","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:43.000000Z","updated_at":"2025-07-19T09:46:09.000000Z"},{"id":15042310,"change_date":"2025-07-15 21:41:00","inspection_id":"85225277","insp_unit_id":"207889481","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"JG\/BLK","insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:43.000000Z","updated_at":"2025-07-19T09:46:09.000000Z"}]},{"id":5760950,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","dot_number":"3065277","report_state":"CA","report_number":"UDXH000159","insp_date":"2024-05-15 00:00:00","insp_start_time":"0627","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"335","location_desc":"I-80 W\/B WEST OF TOLL PLAZA","county_code_state":"CA","county_code":"001","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15364838","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T20:17:03.000000Z","updated_at":"2025-03-17T20:17:03.000000Z","inspection_violations":[{"id":8917002,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_violation_id":"259532003","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8917003,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_violation_id":"259532004","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"200917499","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"39360D"},{"id":8917004,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_violation_id":"259532005","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200917499","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LR15669","created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"},{"id":8917005,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_violation_id":"259532006","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200917499","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:07.000000Z","updated_at":"2025-03-17T21:49:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9278976,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_unit_id":"200917499","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7-11","insp_unit_license":"9G85190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV9GDHP2853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"},{"id":9278977,"change_date":"2024-05-15 21:44:00","inspection_id":"81622934","insp_unit_id":"200917500","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:21.000000Z","updated_at":"2025-03-17T23:19:21.000000Z"}]},{"id":5693415,"change_date":"2024-05-07 21:43:00","inspection_id":"81549680","dot_number":"3065277","report_state":"CA","report_number":"UEHM000193","insp_date":"2024-05-07 00:00:00","insp_start_time":"0700","insp_end_time":"0723","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"I 80 E\/B ANTELOPE SCALES","county_code_state":"CA","county_code":"067","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15351786","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-05-07 21:43:00","snet_input_date":"2024-05-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-07 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T20:15:30.000000Z","updated_at":"2025-03-17T20:15:30.000000Z","inspection_violations":[{"id":8806211,"change_date":"2024-05-07 21:43:00","inspection_id":"81549680","insp_violation_id":"259369655","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"200778164","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:36.000000Z","updated_at":"2025-03-17T21:48:36.000000Z","normalized_code":"39311"},{"id":8806212,"change_date":"2024-05-07 21:43:00","inspection_id":"81549680","insp_violation_id":"259369656","seq_no":"2","part_no":"393","part_no_section":"118","insp_viol_unit":"2","insp_unit_id":"200778164","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:48:36.000000Z","updated_at":"2025-03-17T21:48:36.000000Z","normalized_code":"393118"}],"inspection_per_units":[{"id":9170223,"change_date":"2024-05-07 21:43:00","inspection_id":"81549680","insp_unit_id":"200778163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:22.000000Z","updated_at":"2025-03-17T23:18:22.000000Z"},{"id":9170224,"change_date":"2024-05-07 21:43:00","inspection_id":"81549680","insp_unit_id":"200778164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2C","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:22.000000Z","updated_at":"2025-03-17T23:18:22.000000Z"}]},{"id":5364057,"change_date":"2024-03-25 21:42:00","inspection_id":"81190419","dot_number":"3065277","report_state":"CA","report_number":"NDS4005139","insp_date":"2024-03-22 00:00:00","insp_start_time":"1009","insp_end_time":"1037","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15293957","transaction_code":"A","transaction_date":"2024-03-22 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-03-25 21:42:00","snet_input_date":"2024-03-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-25 21:42:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:02.000000Z","updated_at":"2025-03-17T20:09:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8638704,"change_date":"2024-03-25 21:42:00","inspection_id":"81190419","insp_unit_id":"200078536","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"O1\/WHT","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"Y","insp_unit_decal_number":"33536029","created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"},{"id":8638705,"change_date":"2024-03-25 21:42:00","inspection_id":"81190419","insp_unit_id":"200078537","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"01C\/FLTBD","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"Y","insp_unit_decal_number":"33536030","created_at":"2025-03-17T23:13:20.000000Z","updated_at":"2025-03-17T23:13:20.000000Z"}]},{"id":5094542,"change_date":"2024-02-20 21:43:00","inspection_id":"80896649","dot_number":"3065277","report_state":"CA","report_number":"NCNY006502","insp_date":"2024-02-15 00:00:00","insp_start_time":"0916","insp_end_time":"0952","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15242414","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-02-20 21:43:00","snet_input_date":"2024-02-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-20 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:30.000000Z","updated_at":"2025-03-17T20:03:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8202103,"change_date":"2024-02-20 21:43:00","inspection_id":"80896649","insp_unit_id":"199512797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"Y","insp_unit_decal_number":"33534912","created_at":"2025-03-17T23:09:20.000000Z","updated_at":"2025-03-17T23:09:20.000000Z"},{"id":8202104,"change_date":"2024-02-20 21:43:00","inspection_id":"80896649","insp_unit_id":"199512798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X\/FB","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:20.000000Z","updated_at":"2025-03-17T23:09:20.000000Z"}]},{"id":5012413,"change_date":"2024-02-08 21:43:00","inspection_id":"80806984","dot_number":"3065277","report_state":"CA","report_number":"NDN6008128","insp_date":"2024-02-05 00:00:00","insp_start_time":"0938","insp_end_time":"1003","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","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-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15229849","transaction_code":"A","transaction_date":"2024-02-06 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:02.000000Z","updated_at":"2025-03-17T20:02:02.000000Z","inspection_violations":[{"id":7721949,"change_date":"2024-02-08 21:43:00","inspection_id":"80806984","insp_violation_id":"257747617","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA308796","created_at":"2025-03-17T21:43:22.000000Z","updated_at":"2025-03-17T21:43:22.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":8067653,"change_date":"2024-02-08 21:43:00","inspection_id":"80806984","insp_unit_id":"199342596","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9G85190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV9GDHP2853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:06.000000Z","updated_at":"2025-03-17T23:08:06.000000Z"},{"id":8067654,"change_date":"2024-02-08 21:43:00","inspection_id":"80806984","insp_unit_id":"199342597","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X FB","insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:06.000000Z","updated_at":"2025-03-17T23:08:06.000000Z"}]},{"id":4852496,"change_date":"2024-01-17 21:44:00","inspection_id":"80631823","dot_number":"3065277","report_state":"CA","report_number":"UC2Q002632","insp_date":"2024-01-09 00:00:00","insp_start_time":"0910","insp_end_time":"0935","registration_date":null,"region":"PT","ci_status_code":"C","location":"390","location_desc":"EASTBOUND E\/ NORTH LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-17 21:44: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":"15203906","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:58:51.000000Z","updated_at":"2025-03-17T19:58:51.000000Z","inspection_violations":[{"id":7480531,"change_date":"2024-01-17 21:44:00","inspection_id":"80631823","insp_violation_id":"257384558","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"LD59031","created_at":"2025-03-17T21:42:07.000000Z","updated_at":"2025-03-17T21:42:07.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":7807477,"change_date":"2024-01-17 21:44:00","inspection_id":"80631823","insp_unit_id":"199002747","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G85190","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV9GDHP2853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"},{"id":7807478,"change_date":"2024-01-17 21:44:00","inspection_id":"80631823","insp_unit_id":"199002748","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X FB","insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"}]},{"id":4524478,"change_date":"2023-11-29 21:43:00","inspection_id":"80272774","dot_number":"3065277","report_state":"CA","report_number":"UC50000130","insp_date":"2023-11-28 00:00:00","insp_start_time":"0904","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15148688","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-11-29 21:43:00","snet_input_date":"2023-11-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-29 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:52:33.000000Z","updated_at":"2025-03-17T19:52:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7276661,"change_date":"2023-11-29 21:43:00","inspection_id":"80272774","insp_unit_id":"198276802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"Y","insp_unit_decal_number":"33226723","created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"},{"id":7276662,"change_date":"2023-11-29 21:43:00","inspection_id":"80272774","insp_unit_id":"198276803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"Y","insp_unit_decal_number":"33226724","created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4436467,"change_date":"2023-11-15 21:42:00","inspection_id":"80176046","dot_number":"3065277","report_state":"CA","report_number":"NDS4004805","insp_date":"2023-11-14 00:00:00","insp_start_time":"0938","insp_end_time":"1012","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-15 21:42: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":"15135866","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-11-15 21:42:00","snet_input_date":"2023-11-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-15 21:42:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[{"id":6866562,"change_date":"2023-11-15 21:42:00","inspection_id":"80176046","insp_violation_id":"256422697","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"198084184","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":7134539,"change_date":"2023-11-15 21:42:00","inspection_id":"80176046","insp_unit_id":"198084184","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"},{"id":7134540,"change_date":"2023-11-15 21:42:00","inspection_id":"80176046","insp_unit_id":"198084185","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02-C\/FLTBD","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:53.000000Z","updated_at":"2025-03-17T22:59:53.000000Z"}]},{"id":4318217,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","dot_number":"3065277","report_state":"CA","report_number":"NE8I002701","insp_date":"2023-10-26 00:00:00","insp_start_time":"1411","insp_end_time":"1451","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GOLDEN STATE LUMBER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15115616","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-10-30 21:43:00","snet_input_date":"2023-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-30 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:25.000000Z","updated_at":"2025-03-17T19:48:25.000000Z","inspection_violations":[{"id":6679772,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_violation_id":"256128751","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197825077","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39345B2"},{"id":6679773,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_violation_id":"256128752","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197825077","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"39345B2"},{"id":6679774,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_violation_id":"256128753","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197825078","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"3963A1"},{"id":6679775,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_violation_id":"256128754","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197825078","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:07.000000Z","updated_at":"2025-03-17T21:38:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6945197,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_unit_id":"197825077","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:18.000000Z","updated_at":"2025-03-17T22:58:18.000000Z"},{"id":6945198,"change_date":"2023-10-30 21:43:00","inspection_id":"80045338","insp_unit_id":"197825078","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FLATBED","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:18.000000Z","updated_at":"2025-03-17T22:58:18.000000Z"}]},{"id":3884710,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","dot_number":"3065277","report_state":"CA","report_number":"NC20005708","insp_date":"2023-08-30 00:00:00","insp_start_time":"0916","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15045060","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-08-31 21:43:00","snet_input_date":"2023-08-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-31 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:39:41.000000Z","updated_at":"2025-03-17T19:39:41.000000Z","inspection_violations":[{"id":6003769,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","insp_violation_id":"255035605","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"},{"id":6003770,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","insp_violation_id":"255035606","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196856160","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"39345B2"},{"id":6003771,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","insp_violation_id":"255035607","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196856161","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6245648,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","insp_unit_id":"196856160","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"},{"id":6245649,"change_date":"2023-08-31 21:43:00","inspection_id":"79564546","insp_unit_id":"196856161","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02\/FB","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:29.000000Z","updated_at":"2025-03-17T22:52:29.000000Z"}]},{"id":3740475,"change_date":"2023-08-14 21:43:00","inspection_id":"79403539","dot_number":"3065277","report_state":"CA","report_number":"NCNY005875","insp_date":"2023-08-11 00:00:00","insp_start_time":"0920","insp_end_time":"0945","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"15019382","transaction_code":"A","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"303 WAYSIDE DR APT #123","insp_carrier_city":"TURLOCK","insp_carrier_state":"CA","insp_carrier_zip_code":"95380","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:51.000000Z","updated_at":"2025-03-17T19:36:51.000000Z","inspection_violations":[{"id":5769643,"change_date":"2023-08-14 21:43:00","inspection_id":"79403539","insp_violation_id":"254647737","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196525354","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6014556,"change_date":"2023-08-14 21:43:00","inspection_id":"79403539","insp_unit_id":"196525353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7-11\/WHT","insp_unit_license":"N\/A","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGEDV9GDHP2853","insp_unit_decal":"Y","insp_unit_decal_number":"32869314","created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"},{"id":6014557,"change_date":"2023-08-14 21:43:00","inspection_id":"79403539","insp_unit_id":"196525354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X\/FB","insp_unit_license":"4FZ7754","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2451VA114517","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"}]},{"id":3471950,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","dot_number":"3065277","report_state":"CA","report_number":"NAGM006878","insp_date":"2023-06-27 00:00:00","insp_start_time":"0728","insp_end_time":"0811","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14975362","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-07-10 21:43:00","snet_input_date":"2023-06-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-10 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:31:42.000000Z","updated_at":"2025-03-17T19:31:42.000000Z","inspection_violations":[{"id":5354217,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_violation_id":"253970687","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"195918351","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"CW470352","created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"393207A"},{"id":5354218,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_violation_id":"253970688","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195918352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1"},{"id":5354219,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_violation_id":"253970689","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195918352","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1"},{"id":5354220,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_violation_id":"253970690","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195918352","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:50.000000Z","updated_at":"2025-03-17T21:31:50.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5583062,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_unit_id":"195918351","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:04.000000Z","updated_at":"2025-03-17T22:47:04.000000Z"},{"id":5583063,"change_date":"2023-07-10 21:43:00","inspection_id":"79102805","insp_unit_id":"195918352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02C","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:04.000000Z","updated_at":"2025-03-17T22:47:04.000000Z"}]},{"id":3251744,"change_date":"2023-06-09 21:41:00","inspection_id":"78854677","dot_number":"3065277","report_state":"CA","report_number":"NBH0006466","insp_date":"2023-06-01 00:00:00","insp_start_time":"0903","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14937745","transaction_code":"A","transaction_date":"2023-06-01 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-06-09 21:41:00","snet_input_date":"2023-06-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-09 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:27:21.000000Z","updated_at":"2025-03-17T19:27:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5229996,"change_date":"2023-06-09 21:41:00","inspection_id":"78854677","insp_unit_id":"195423467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"Y","insp_unit_decal_number":"32497331","created_at":"2025-03-17T22:44:12.000000Z","updated_at":"2025-03-17T22:44:12.000000Z"},{"id":5229997,"change_date":"2023-06-09 21:41:00","inspection_id":"78854677","insp_unit_id":"195423468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"01","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"Y","insp_unit_decal_number":"32497332","created_at":"2025-03-17T22:44:12.000000Z","updated_at":"2025-03-17T22:44:12.000000Z"}]},{"id":2948223,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","dot_number":"3065277","report_state":"CA","report_number":"NC20005311","insp_date":"2023-05-01 00:00:00","insp_start_time":"1243","insp_end_time":"1335","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14882652","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-05-02 21:41:00","snet_input_date":"2023-05-01 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-02 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:21:22.000000Z","updated_at":"2025-03-17T19:21:22.000000Z","inspection_violations":[{"id":4526312,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","insp_violation_id":"252580479","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194712289","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA299483","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39347E"},{"id":4526313,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","insp_violation_id":"252580480","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194712289","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA299483","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"39345B2"},{"id":4526314,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","insp_violation_id":"252580481","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194712289","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA299483","created_at":"2025-03-17T21:28:06.000000Z","updated_at":"2025-03-17T21:28:06.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4743820,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","insp_unit_id":"194712288","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01\/WHT","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"},{"id":4743821,"change_date":"2023-05-02 21:41:00","inspection_id":"78512000","insp_unit_id":"194712289","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"01-C\/FB","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:23.000000Z","updated_at":"2025-03-17T22:40:23.000000Z"}]},{"id":2136026,"change_date":"2023-01-12 21:42:00","inspection_id":"77587601","dot_number":"3065277","report_state":"CA","report_number":"UE99002938","insp_date":"2023-01-12 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"PT","ci_status_code":"C","location":"265","location_desc":"ARCH RD AT B ST","county_code_state":"CA","county_code":"077","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-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14739279","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:55.000000Z","updated_at":"2025-03-17T19:05:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3437705,"change_date":"2023-01-12 21:42:00","inspection_id":"77587601","insp_unit_id":"192857026","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:38.000000Z","updated_at":"2025-03-17T22:30:38.000000Z"}]},{"id":2030834,"change_date":"2022-12-28 21:40:00","inspection_id":"77466925","dot_number":"3065277","report_state":"CA","report_number":"NCNY004876","insp_date":"2022-12-27 00:00:00","insp_start_time":"0902","insp_end_time":"0912","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"14723964","transaction_code":"A","transaction_date":"2022-12-27 00:00:00","upload_date":"2022-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-12-28 21:40:00","snet_input_date":"2022-12-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-28 21:40:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:01.000000Z","updated_at":"2025-03-17T19:04:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3267633,"change_date":"2022-12-28 21:40:00","inspection_id":"77466925","insp_unit_id":"192616835","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:23.000000Z","updated_at":"2025-03-17T22:29:23.000000Z"},{"id":3267634,"change_date":"2022-12-28 21:40:00","inspection_id":"77466925","insp_unit_id":"192616836","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"02\/FB","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:23.000000Z","updated_at":"2025-03-17T22:29:23.000000Z"}]},{"id":1990683,"change_date":"2022-12-20 21:41:00","inspection_id":"77421476","dot_number":"3065277","report_state":"CA","report_number":"N8MC005941","insp_date":"2022-12-14 00:00:00","insp_start_time":"0750","insp_end_time":"0825","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-20 21:41: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":"14715155","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:19.000000Z","updated_at":"2025-03-17T19:03:19.000000Z","inspection_violations":[{"id":3091141,"change_date":"2022-12-20 21:41:00","inspection_id":"77421476","insp_violation_id":"250208482","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192526408","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3202980,"change_date":"2022-12-20 21:41:00","inspection_id":"77421476","insp_unit_id":"192526407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02\/ RED","insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"},{"id":3202981,"change_date":"2022-12-20 21:41:00","inspection_id":"77421476","insp_unit_id":"192526408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"FB","insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"Y","insp_unit_decal_number":"31883303","created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1990575,"change_date":"2022-12-20 21:41:00","inspection_id":"77421361","dot_number":"3065277","report_state":"CA","report_number":"NAGM005874","insp_date":"2022-12-13 00:00:00","insp_start_time":"0652","insp_end_time":"0723","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","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-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14715661","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T19:03:19.000000Z","updated_at":"2025-03-17T19:03:19.000000Z","inspection_violations":[{"id":3091071,"change_date":"2022-12-20 21:41:00","inspection_id":"77421361","insp_violation_id":"250208405","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"192526262","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3202850,"change_date":"2022-12-20 21:41:00","inspection_id":"77421361","insp_unit_id":"192526261","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1\/WHT","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"Y","insp_unit_decal_number":"31883247","created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"},{"id":3202851,"change_date":"2022-12-20 21:41:00","inspection_id":"77421361","insp_unit_id":"192526262","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":null,"insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1288914,"change_date":"2022-09-14 21:40:00","inspection_id":"76613326","dot_number":"3065277","report_state":"CA","report_number":"UE5U002443","insp_date":"2022-09-14 00:00:00","insp_start_time":"0710","insp_end_time":"0724","registration_date":null,"region":"PT","ci_status_code":"C","location":"888","location_desc":"S\/B I-5 SANTA NELLA SCALES","county_code_state":"CA","county_code":"047","insp_level_id":"3","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14594180","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T18:50:28.000000Z","updated_at":"2025-03-17T18:50:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2074819,"change_date":"2022-09-14 21:40:00","inspection_id":"76613326","insp_unit_id":"190907118","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:13.000000Z","updated_at":"2025-03-17T22:21:13.000000Z"},{"id":2074820,"change_date":"2022-09-14 21:40:00","inspection_id":"76613326","insp_unit_id":"190907119","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:13.000000Z","updated_at":"2025-03-17T22:21:13.000000Z"}]},{"id":1068191,"change_date":"2022-08-17 21:41:00","inspection_id":"76357150","dot_number":"3065277","report_state":"CA","report_number":"ND6S004320","insp_date":"2022-08-15 00:00:00","insp_start_time":"0905","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","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-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"14551032","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T18:46:31.000000Z","updated_at":"2025-03-17T18:46:31.000000Z","inspection_violations":[{"id":1685788,"change_date":"2022-08-17 21:41:00","inspection_id":"76357150","insp_violation_id":"247804733","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"190383857","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"39345D"},{"id":1685789,"change_date":"2022-08-17 21:41:00","inspection_id":"76357150","insp_violation_id":"247804734","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190383858","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1718875,"change_date":"2022-08-17 21:41:00","inspection_id":"76357150","insp_unit_id":"190383857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G32332","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGBDV9ESFU7193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:50.000000Z","updated_at":"2025-03-17T22:18:50.000000Z"},{"id":1718876,"change_date":"2022-08-17 21:41:00","inspection_id":"76357150","insp_unit_id":"190383858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4GE7414","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYFS2453XA921141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:50.000000Z","updated_at":"2025-03-17T22:18:50.000000Z"}]},{"id":877846,"change_date":"2022-07-22 21:40:00","inspection_id":"76134400","dot_number":"3065277","report_state":"CA","report_number":"UCED002380","insp_date":"2022-07-21 00:00:00","insp_start_time":"1014","insp_end_time":"1035","registration_date":null,"region":"PT","ci_status_code":"C","location":"250","location_desc":"NORTH SACRAMENTO AREA","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GOLDEN STATE","shipping_paper_number":"302988","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:40: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":"14516994","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-07-22 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T18:43:05.000000Z","updated_at":"2025-03-17T18:43:05.000000Z","inspection_violations":[{"id":1382633,"change_date":"2022-07-22 21:40:00","inspection_id":"76134400","insp_violation_id":"247267696","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:13:32.000000Z","updated_at":"2025-03-17T21:13:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1413205,"change_date":"2022-07-22 21:40:00","inspection_id":"76134400","insp_unit_id":"189927673","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:52.000000Z","updated_at":"2025-03-17T22:16:52.000000Z"},{"id":1413206,"change_date":"2022-07-22 21:40:00","inspection_id":"76134400","insp_unit_id":"189927674","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"01-C","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:52.000000Z","updated_at":"2025-03-17T22:16:52.000000Z"}]},{"id":665518,"change_date":"2022-06-21 21:43:00","inspection_id":"75885927","dot_number":"3065277","report_state":"CA","report_number":"N8OL005432","insp_date":"2022-06-20 00:00:00","insp_start_time":"1227","insp_end_time":"1259","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"0","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-21 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14477897","transaction_code":"A","transaction_date":"2022-06-20 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-06-21 21:43:00","snet_input_date":"2022-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-21 21:43:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"518278","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1048783,"change_date":"2022-06-21 21:43:00","inspection_id":"75885927","insp_violation_id":"246637620","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189392206","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1069952,"change_date":"2022-06-21 21:43:00","inspection_id":"75885927","insp_unit_id":"189392205","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01\/WHITE","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"},{"id":1069953,"change_date":"2022-06-21 21:43:00","inspection_id":"75885927","insp_unit_id":"189392206","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"O1-C\/BLACK","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":92409,"change_date":"2022-04-01 21:40:00","inspection_id":"75201098","dot_number":"3065277","report_state":"CA","report_number":"UDBL000881","insp_date":"2022-03-29 00:00:00","insp_start_time":"0931","insp_end_time":"0941","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF (E\/B I-580)","county_code_state":"CA","county_code":"001","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-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"141160","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":"14368280","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-04-01 21:40:00","snet_input_date":"2022-03-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-01 21:40:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:09.000000Z","updated_at":"2025-03-17T18:29:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":150058,"change_date":"2022-04-01 21:40:00","inspection_id":"75201098","insp_unit_id":"187948752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"},{"id":150059,"change_date":"2022-04-01 21:40:00","inspection_id":"75201098","insp_unit_id":"187948753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"2X","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"}]},{"id":91855,"change_date":"2022-04-01 21:40:00","inspection_id":"75200441","dot_number":"3065277","report_state":"CA","report_number":"NC7K005652","insp_date":"2022-03-24 00:00:00","insp_start_time":"0943","insp_end_time":"1004","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"141160","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":"14368419","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03065277","upload_search_indicator":null,"census_search_date":"2022-04-01 21:40:00","snet_input_date":"2022-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-01 21:40:00","insp_carrier_name":"CARRANZA & SONS TRUCKING LLC","insp_carrier_street":"16071 SERENITY CT","insp_carrier_city":"DELHI","insp_carrier_state":"CA","insp_carrier_zip_code":"95315","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:09.000000Z","updated_at":"2025-03-17T18:29:09.000000Z","inspection_violations":[{"id":136824,"change_date":"2022-04-01 21:40:00","inspection_id":"75200441","insp_violation_id":"244921516","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"187947694","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":149196,"change_date":"2022-04-01 21:40:00","inspection_id":"75200441","insp_unit_id":"187947693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01\/WHT 3X","insp_unit_license":"9F36060","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGLDR9DLBZ5719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:07.000000Z","updated_at":"2025-03-17T22:09:07.000000Z"},{"id":149197,"change_date":"2022-04-01 21:40:00","inspection_id":"75200441","insp_unit_id":"187947694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILY","insp_unit_company":"01C\/FB 2X","insp_unit_license":"4HU8321","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W1BFB6BXLE304994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:07.000000Z","updated_at":"2025-03-17T22:09:07.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3065277\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3065277\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3065277\/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\/3065277\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}