{"current_page":1,"data":[{"id":12529616,"change_date":"2026-07-23 21:41:00","inspection_id":"88495546","dot_number":"3707111","report_state":"CA","report_number":"UFYK001655","insp_date":"2026-07-22 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","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":"U","pen_cen_match":"I","final_status_date":"2026-07-23 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":"3819324","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"661564","created_at":"2026-07-26T09:42:24.000000Z","updated_at":"2026-08-03T09:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21758618,"change_date":"2026-07-23 21:41:00","inspection_id":"88495546","insp_unit_id":"214780819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI #2021","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"Y","insp_unit_decal_number":"36522221","created_at":"2026-07-26T09:20:12.000000Z","updated_at":"2026-08-03T09:05:10.000000Z"},{"id":21758619,"change_date":"2026-07-23 21:41:00","inspection_id":"88495546","insp_unit_id":"214780820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"2X WHI VAN","insp_unit_license":"5451819","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR3622SL047047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:12.000000Z","updated_at":"2026-08-03T09:05:10.000000Z"}]},{"id":12486970,"change_date":"2026-07-18 21:34:00","inspection_id":"88450040","dot_number":"3707111","report_state":"CA","report_number":"NC7K011187","insp_date":"2026-07-17 00:00:00","insp_start_time":"0600","insp_end_time":"0645","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","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":"U","pen_cen_match":"I","final_status_date":"2026-07-18 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"3785728","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":"03707111","upload_search_indicator":null,"census_search_date":"2026-07-18 21:34:00","snet_input_date":"2026-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-18 21:34:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-21T09:42:48.000000Z","updated_at":"2026-07-29T09:30:12.000000Z","inspection_violations":[{"id":21738518,"change_date":"2026-07-18 21:34:00","inspection_id":"88450040","insp_violation_id":"275591462","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"214694640","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-21T10:05:41.000000Z","updated_at":"2026-07-29T09:40:34.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":21687496,"change_date":"2026-07-18 21:34:00","inspection_id":"88450040","insp_unit_id":"214694640","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2021\/WHT 3X","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-21T09:20:20.000000Z","updated_at":"2026-07-29T09:01:12.000000Z"},{"id":21687497,"change_date":"2026-07-18 21:34:00","inspection_id":"88450040","insp_unit_id":"214694641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"7005\/RFR 2X","insp_unit_license":"2832153","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2361H2966404","insp_unit_decal":"Y","insp_unit_decal_number":"36522179","created_at":"2026-07-21T09:20:20.000000Z","updated_at":"2026-07-29T09:01:12.000000Z"}]},{"id":11734787,"change_date":"2026-04-23 21:39:00","inspection_id":"87663208","dot_number":"3707111","report_state":"CA","report_number":"UCU1001246","insp_date":"2026-04-22 00:00:00","insp_start_time":"0731","insp_end_time":"0801","registration_date":null,"region":"ET","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":"2026-04-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"16260184","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:41:46.000000Z","updated_at":"2026-05-04T09:31:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20418664,"change_date":"2026-04-23 21:39:00","inspection_id":"87663208","insp_unit_id":"213189703","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X WHT","insp_unit_license":"5504336","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS253XT2635025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:24.000000Z","updated_at":"2026-05-04T09:04:41.000000Z"},{"id":20418663,"change_date":"2026-04-23 21:39:00","inspection_id":"87663208","insp_unit_id":"213189702","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X WHT","insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:24.000000Z","updated_at":"2026-05-04T09:04:41.000000Z"}]},{"id":11700661,"change_date":"2026-04-20 21:39:00","inspection_id":"87627145","dot_number":"3707111","report_state":"CA","report_number":"NC7K010931","insp_date":"2026-04-17 00:00:00","insp_start_time":"0703","insp_end_time":"0743","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":"2026-04-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"16252868","transaction_code":"A","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2026-04-20 21:39:00","snet_input_date":"2026-04-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-20 21:39:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:36:27.000000Z","updated_at":"2026-05-01T09:31:24.000000Z","inspection_violations":[{"id":20333591,"change_date":"2026-04-20 21:39:00","inspection_id":"87627145","insp_violation_id":"273731080","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213121623","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA733094","created_at":"2026-04-27T09:53:00.000000Z","updated_at":"2026-05-01T09:43:33.000000Z","normalized_code":"3939ALFTSI"},{"id":20333592,"change_date":"2026-04-20 21:39:00","inspection_id":"87627145","insp_violation_id":"273731081","seq_no":"2","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"213121623","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:53:00.000000Z","updated_at":"2026-05-01T09:43:33.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":20362653,"change_date":"2026-04-20 21:39:00","inspection_id":"87627145","insp_unit_id":"213121624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"6251\/RFR 2X","insp_unit_license":"5504327","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2539T2635016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:14.000000Z","updated_at":"2026-05-01T09:04:39.000000Z"},{"id":20362652,"change_date":"2026-04-20 21:39:00","inspection_id":"87627145","insp_unit_id":"213121623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"2020\/WHT 3X","insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:14.000000Z","updated_at":"2026-05-01T09:04:39.000000Z"}]},{"id":11600092,"change_date":"2026-04-08 21:38:00","inspection_id":"87526945","dot_number":"3707111","report_state":"CA","report_number":"UEAO006127","insp_date":"2026-04-07 00:00:00","insp_start_time":"0648","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","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":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"16239214","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:45.000000Z","updated_at":"2026-04-19T09:33:49.000000Z","inspection_violations":[{"id":19618500,"change_date":"2026-04-08 21:38:00","inspection_id":"87526945","insp_violation_id":"272947938","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"212614542","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA733380","created_at":"2026-04-11T10:03:38.000000Z","updated_at":"2026-04-18T10:49:45.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":19883367,"change_date":"2026-04-08 21:38:00","inspection_id":"87526945","insp_unit_id":"212614542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XWHT","insp_unit_license":"ZP73305","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6JSHG9442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:48.000000Z","updated_at":"2026-04-18T09:39:40.000000Z"},{"id":19883368,"change_date":"2026-04-08 21:38:00","inspection_id":"87526945","insp_unit_id":"212614543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X","insp_unit_license":"5482628","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2534T2580703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:48.000000Z","updated_at":"2026-04-18T09:39:40.000000Z"}]},{"id":10560751,"change_date":"2026-01-02 21:35:00","inspection_id":"86698052","dot_number":"3707111","report_state":"CA","report_number":"NC7K010614","insp_date":"2025-12-30 00:00:00","insp_start_time":"0610","insp_end_time":"0640","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":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","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":"16113774","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:40.000000Z","updated_at":"2026-01-13T10:30:42.000000Z","inspection_violations":[{"id":17738494,"change_date":"2026-01-02 21:35:00","inspection_id":"86698052","insp_violation_id":"270995926","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210894366","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:21.000000Z","updated_at":"2026-01-13T10:31:37.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":17693078,"change_date":"2026-01-02 21:35:00","inspection_id":"86698052","insp_unit_id":"210894366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2024\/WHT 3X","insp_unit_license":"ZP73305","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR6JSHG9442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:58.000000Z"},{"id":17693079,"change_date":"2026-01-02 21:35:00","inspection_id":"86698052","insp_unit_id":"210894367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"RFR 2X","insp_unit_license":"4TM9010","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2532N2659807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:10.000000Z","updated_at":"2026-01-13T10:00:59.000000Z"}]},{"id":8887780,"change_date":"2025-06-12 21:41:00","inspection_id":"84939686","dot_number":"3707111","report_state":"CA","report_number":"NDN6009520","insp_date":"2025-06-11 00:00:00","insp_start_time":"0800","insp_end_time":"0834","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALES","county_code_state":"CA","county_code":"001","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":"2025-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15859949","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2025-06-12 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-12 21:41:00","insp_carrier_name":"ANDRADE & SON'S INC","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95241","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-15T10:01:13.000000Z","updated_at":"2025-06-16T10:00:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14559353,"change_date":"2025-06-12 21:41:00","inspection_id":"84939686","insp_unit_id":"207364217","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9G98380","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR4MSMS3539","insp_unit_decal":"Y","insp_unit_decal_number":"35062331","created_at":"2025-06-15T09:46:34.000000Z","updated_at":"2025-06-16T09:46:21.000000Z"},{"id":14559354,"change_date":"2025-06-12 21:41:00","inspection_id":"84939686","insp_unit_id":"207364218","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"2X FB","insp_unit_license":"4NG4254","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4WW5482AXF6622494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-15T09:46:34.000000Z","updated_at":"2025-06-16T09:46:21.000000Z"}]},{"id":8289891,"change_date":"2025-04-03 21:42:00","inspection_id":"84308843","dot_number":"3707111","report_state":"CA","report_number":"NC7K009714","insp_date":"2025-03-28 00:00:00","insp_start_time":"0710","insp_end_time":"0735","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":"2025-04-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"15765402","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2025-04-03 21:42:00","snet_input_date":"2025-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-03 21:42:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-06T10:25:15.000000Z","updated_at":"2025-04-07T10:21:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13438554,"change_date":"2025-04-03 21:42:00","inspection_id":"84308843","insp_unit_id":"206146392","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"VAN 2X","insp_unit_license":"2552074","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4823GL006808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:15:37.000000Z","updated_at":"2025-04-07T10:06:38.000000Z"},{"id":13438553,"change_date":"2025-04-03 21:42:00","inspection_id":"84308843","insp_unit_id":"206146391","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2021\/WHT 3X","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:15:37.000000Z","updated_at":"2025-04-07T10:06:38.000000Z"}]},{"id":8014820,"change_date":"2025-03-03 21:39:00","inspection_id":"84019282","dot_number":"3707111","report_state":"CA","report_number":"UE2C005292","insp_date":"2025-02-28 00:00:00","insp_start_time":"1700","insp_end_time":"1730","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"W\/B LIVERMORE PLATFORM SCALE","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":"2025-03-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15723420","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2025-03-03 21:39:00","snet_input_date":"2025-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-03 21:39:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:32.000000Z","updated_at":"2025-03-17T21:04:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12939505,"change_date":"2025-03-03 21:39:00","inspection_id":"84019282","insp_unit_id":"205603857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:54.000000Z","updated_at":"2025-03-17T23:57:54.000000Z"},{"id":12939506,"change_date":"2025-03-03 21:39:00","inspection_id":"84019282","insp_unit_id":"205603858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X REF","insp_unit_license":"2454136","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2480FU410103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:54.000000Z","updated_at":"2025-03-17T23:57:54.000000Z"}]},{"id":7576958,"change_date":"2025-01-08 21:40:00","inspection_id":"83559579","dot_number":"3707111","report_state":"CA","report_number":"UD5V000408","insp_date":"2025-01-04 00:00:00","insp_start_time":"2013","insp_end_time":"2040","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B LIVERMORE SCALE","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":"2025-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15653358","transaction_code":"A","transaction_date":"2025-01-04 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2025-01-08 21:40:00","snet_input_date":"2025-01-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-08 21:40:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"593909","created_at":"2025-03-17T20:55:19.000000Z","updated_at":"2025-03-17T20:55:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12225236,"change_date":"2025-01-08 21:40:00","inspection_id":"83559579","insp_unit_id":"204716172","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G98380","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR4MSMS3539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:58.000000Z","updated_at":"2025-03-17T23:49:58.000000Z"},{"id":12225237,"change_date":"2025-01-08 21:40:00","inspection_id":"83559579","insp_unit_id":"204716173","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"2X WHT VAN","insp_unit_license":"2454142","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1UYVS2481FU410109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:58.000000Z","updated_at":"2025-03-17T23:49:58.000000Z"}]},{"id":7242830,"change_date":"2024-11-20 21:41:00","inspection_id":"83208041","dot_number":"3707111","report_state":"CA","report_number":"UEAO004658","insp_date":"2024-11-17 00:00:00","insp_start_time":"2003","insp_end_time":"2016","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"E\/B 580 LIVERMORE SCALES","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116999","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":"15600942","transaction_code":"A","transaction_date":"2024-11-17 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2024-11-20 21:41:00","snet_input_date":"2024-11-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-20 21:41:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:14.000000Z","updated_at":"2025-03-17T20:47:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11682479,"change_date":"2024-11-20 21:41:00","inspection_id":"83208041","insp_unit_id":"203978083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:05.000000Z","updated_at":"2025-03-17T23:44:05.000000Z"},{"id":11682480,"change_date":"2024-11-20 21:41:00","inspection_id":"83208041","insp_unit_id":"203978084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"2X","insp_unit_license":"25S2066","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"627SR4829B1026800","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:05.000000Z","updated_at":"2025-03-17T23:44:05.000000Z"}]},{"id":7223698,"change_date":"2024-11-18 21:41:00","inspection_id":"83187909","dot_number":"3707111","report_state":"CA","report_number":"UDJB004049","insp_date":"2024-11-15 00:00:00","insp_start_time":"1320","insp_end_time":"1350","registration_date":null,"region":"PT","ci_status_code":"C","location":"9401","location_desc":"N\/B SANTA NELLA PLATFORM SCALE","county_code_state":"CA","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ASV WINES INC","shipping_paper_number":"019862","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-11-18 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":"15596164","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[{"id":11291621,"change_date":"2024-11-18 21:41:00","inspection_id":"83187909","insp_violation_id":"262964286","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"1","insp_unit_id":"203941314","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RK83516","created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":11651954,"change_date":"2024-11-18 21:41:00","inspection_id":"83187909","insp_unit_id":"203941314","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2022","insp_unit_license":"9G98380","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR4MSMS3539","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"},{"id":11651955,"change_date":"2024-11-18 21:41:00","inspection_id":"83187909","insp_unit_id":"203941315","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"2834097","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4824HL011923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":7119502,"change_date":"2024-11-04 21:41:00","inspection_id":"83077589","dot_number":"3707111","report_state":"CA","report_number":"NFDT000164","insp_date":"2024-10-31 00:00:00","insp_start_time":"0705","insp_end_time":"0735","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-04 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":"15579961","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-10-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:20.000000Z","updated_at":"2025-03-17T20:44:20.000000Z","inspection_violations":[{"id":11119139,"change_date":"2024-11-04 21:41:00","inspection_id":"83077589","insp_violation_id":"262725207","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203733300","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:55.000000Z","updated_at":"2025-03-17T21:59:55.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11482886,"change_date":"2024-11-04 21:41:00","inspection_id":"83077589","insp_unit_id":"203733300","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHITE","insp_unit_license":"9G98307","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHHDR7MSMN1139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"},{"id":11482887,"change_date":"2024-11-04 21:41:00","inspection_id":"83077589","insp_unit_id":"203733301","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2X VAN","insp_unit_license":"247818F","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA7225CB708509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:58.000000Z","updated_at":"2025-03-17T23:41:58.000000Z"}]},{"id":4416162,"change_date":"2023-11-13 21:43:00","inspection_id":"80153690","dot_number":"3707111","report_state":"CA","report_number":"UF0F001855","insp_date":"2023-11-09 00:00:00","insp_start_time":"1022","insp_end_time":"1046","registration_date":null,"region":"PT","ci_status_code":"C","location":"461","location_desc":"SANTA NELLA SCALES","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":"2023-11-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15132594","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2023-11-13 21:43:00","snet_input_date":"2023-11-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-13 21:43:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:20.000000Z","updated_at":"2025-03-17T19:50:20.000000Z","inspection_violations":[{"id":6833413,"change_date":"2023-11-13 21:43:00","inspection_id":"80153690","insp_violation_id":"256370365","seq_no":"1","part_no":"392","part_no_section":"9(a)(1)","insp_viol_unit":"3","insp_unit_id":"198039803","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:53.000000Z","updated_at":"2025-03-17T21:38:53.000000Z","normalized_code":"3929A1"}],"inspection_per_units":[{"id":7102314,"change_date":"2023-11-13 21:43:00","inspection_id":"80153690","insp_unit_id":"198039801","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"},{"id":7102315,"change_date":"2023-11-13 21:43:00","inspection_id":"80153690","insp_unit_id":"198039802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"VU6153","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7L35886016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"},{"id":7102316,"change_date":"2023-11-13 21:43:00","inspection_id":"80153690","insp_unit_id":"198039803","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"VU6154","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"7L35887018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:38.000000Z","updated_at":"2025-03-17T22:59:38.000000Z"}]},{"id":3658489,"change_date":"2023-08-02 21:42:00","inspection_id":"79311739","dot_number":"3707111","report_state":"CA","report_number":"UEX8003236","insp_date":"2023-07-29 00:00:00","insp_start_time":"1730","insp_end_time":"1755","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"WB LIVERMORE SCALE","county_code_state":"CA","county_code":"005","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-02 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":"15005279","transaction_code":"A","transaction_date":"2023-07-29 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2023-08-02 21:42:00","snet_input_date":"2023-07-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-02 21:42:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:59.000000Z","updated_at":"2025-03-17T19:34:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5882572,"change_date":"2023-08-02 21:42:00","inspection_id":"79311739","insp_unit_id":"196337260","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"},{"id":5882573,"change_date":"2023-08-02 21:42:00","inspection_id":"79311739","insp_unit_id":"196337261","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":null,"insp_unit_license":"2552067","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4820GL006801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:27.000000Z","updated_at":"2025-03-17T22:49:27.000000Z"}]},{"id":2487124,"change_date":"2023-03-01 21:42:00","inspection_id":"77988136","dot_number":"3707111","report_state":"CA","report_number":"UEX8002755","insp_date":"2023-02-11 00:00:00","insp_start_time":"1857","insp_end_time":"1915","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE SCALE","county_code_state":"CA","county_code":"005","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-01 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":"14802951","transaction_code":"A","transaction_date":"2023-02-11 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-02-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:31.000000Z","updated_at":"2025-03-17T19:12:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4002372,"change_date":"2023-03-01 21:42:00","inspection_id":"77988136","insp_unit_id":"193663537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:40.000000Z","updated_at":"2025-03-17T22:34:40.000000Z"},{"id":4002373,"change_date":"2023-03-01 21:42:00","inspection_id":"77988136","insp_unit_id":"193663538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"2452485","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GRAA062XFW704695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:40.000000Z","updated_at":"2025-03-17T22:34:40.000000Z"}]},{"id":1907710,"change_date":"2022-12-08 21:41:00","inspection_id":"77326138","dot_number":"3707111","report_state":"CA","report_number":"UC2Q001689","insp_date":"2022-12-04 00:00:00","insp_start_time":"1250","insp_end_time":"1313","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"EASTBOUND","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-12-08 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":"14701301","transaction_code":"A","transaction_date":"2022-12-04 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03707111","upload_search_indicator":null,"census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"JOSE AGUSTIN ANDRADE MARTINEZ","insp_carrier_street":"1828 DOVE CT","insp_carrier_city":"LODI","insp_carrier_state":"CA","insp_carrier_zip_code":"95240","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"593909","created_at":"2025-03-17T19:01:51.000000Z","updated_at":"2025-03-17T19:01:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3070391,"change_date":"2022-12-08 21:41:00","inspection_id":"77326138","insp_unit_id":"192340353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3X WHT","insp_unit_license":"9G39002","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3HSDJAPR8HN462843","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:02.000000Z","updated_at":"2025-03-17T22:28:02.000000Z"},{"id":3070392,"change_date":"2022-12-08 21:41:00","inspection_id":"77326138","insp_unit_id":"192340354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"2X VN WHT","insp_unit_license":"2552044","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"527SR4829GL006778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:02.000000Z","updated_at":"2025-03-17T22:28:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3707111\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3707111\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3707111\/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\/3707111\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}