{"current_page":1,"data":[{"id":12654110,"change_date":"2026-08-06 21:42:00","inspection_id":"88626505","dot_number":"3845968","report_state":"CA","report_number":"NC7K011235","insp_date":"2026-08-05 00:00:00","insp_start_time":"1031","insp_end_time":"1111","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-08-06 21:42: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":"3922253","transaction_code":"A","transaction_date":"2026-08-06 00:00:00","upload_date":"2026-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-08-06 21:42:00","snet_input_date":"2026-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-06 21:42:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-08-09T09:42:21.000000Z","updated_at":"2026-08-17T09:31:06.000000Z","inspection_violations":[{"id":22030835,"change_date":"2026-08-06 21:42:00","inspection_id":"88626505","insp_violation_id":"275972454","seq_no":"1","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"215019899","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:34.000000Z","updated_at":"2026-08-17T09:42:07.000000Z","normalized_code":"39355D2B"},{"id":22030836,"change_date":"2026-08-06 21:42:00","inspection_id":"88626505","insp_violation_id":"275972455","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"215019900","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-09T10:03:34.000000Z","updated_at":"2026-08-17T09:42:07.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":21964729,"change_date":"2026-08-06 21:42:00","inspection_id":"88626505","insp_unit_id":"215019900","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"9177\/VAN 2X","insp_unit_license":"4TA3426","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C1LR457374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-09T09:20:41.000000Z","updated_at":"2026-08-17T09:02:30.000000Z"},{"id":21964728,"change_date":"2026-08-06 21:42:00","inspection_id":"88626505","insp_unit_id":"215019899","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/WHT 3X","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-09T09:20:41.000000Z","updated_at":"2026-08-17T09:02:30.000000Z"}]},{"id":12244755,"change_date":"2026-06-21 21:33:00","inspection_id":"88202871","dot_number":"3845968","report_state":"CA","report_number":"UESQ006089","insp_date":"2026-06-21 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"PS","ci_status_code":"C","location":"9265","location_desc":"CA","county_code_state":"CA","county_code":"077","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":"U","pen_cen_match":"I","final_status_date":"2026-06-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"3589759","transaction_code":"A","transaction_date":"2026-06-21 00:00:00","upload_date":"2026-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-06-21 21:33:00","snet_input_date":"2026-06-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-21 21:33:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-24T09:39:58.000000Z","updated_at":"2026-07-02T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21264281,"change_date":"2026-06-21 21:33:00","inspection_id":"88202871","insp_unit_id":"214212966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-24T09:17:11.000000Z","updated_at":"2026-07-02T09:01:25.000000Z"}]},{"id":11973208,"change_date":"2026-05-20 21:41:00","inspection_id":"87910098","dot_number":"3845968","report_state":"CA","report_number":"UEX8005389","insp_date":"2026-05-16 00:00:00","insp_start_time":"0637","insp_end_time":"0700","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-20 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":"3369057","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:55.000000Z","updated_at":"2026-06-01T09:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20816829,"change_date":"2026-05-20 21:41:00","inspection_id":"87910098","insp_unit_id":"213664919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X WHT","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:26.000000Z","updated_at":"2026-06-01T09:02:52.000000Z"},{"id":20816830,"change_date":"2026-05-20 21:41:00","inspection_id":"87910098","insp_unit_id":"213664920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4TA3864","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C6MR228044","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:26.000000Z","updated_at":"2026-06-01T09:02:52.000000Z"}]},{"id":11974158,"change_date":"2026-05-20 21:41:00","inspection_id":"87911111","dot_number":"3845968","report_state":"CA","report_number":"NC7K011018","insp_date":"2026-05-08 00:00:00","insp_start_time":"1017","insp_end_time":"1052","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41: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":"3369965","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-05-20 21:41:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:41:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:57.000000Z","updated_at":"2026-06-01T09:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20818324,"change_date":"2026-05-20 21:41:00","inspection_id":"87911111","insp_unit_id":"213666687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"9847\/VAN 2X","insp_unit_license":"4VP9207","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K5RJ168058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:29.000000Z","updated_at":"2026-06-01T09:03:17.000000Z"},{"id":20818323,"change_date":"2026-05-20 21:41:00","inspection_id":"87911111","insp_unit_id":"213666686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/WHT 3X","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:29.000000Z","updated_at":"2026-06-01T09:03:17.000000Z"}]},{"id":11703748,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","dot_number":"3845968","report_state":"CA","report_number":"UGAU000319","insp_date":"2026-04-17 00:00:00","insp_start_time":"0710","insp_end_time":"0750","registration_date":null,"region":"PT","ci_status_code":"C","location":"888","location_desc":"I-5 S\/B SANTA NELLA SCALE","county_code_state":"CA","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"COSTCO WHOLESALE","shipping_paper_number":"17953578","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-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16254688","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":"03845968","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'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:36:59.000000Z","updated_at":"2026-05-01T09:31:47.000000Z","inspection_violations":[{"id":20336965,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734664","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ST 55124","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"3922SLLEWA1"},{"id":20336967,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734666","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213126852","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"39395A4EEUS"},{"id":20336968,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734667","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213126852","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"3922SLLSR"},{"id":20336969,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734668","seq_no":"5","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"213126852","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"393209ESPSLA"},{"id":20336970,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734669","seq_no":"6","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"213126852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"39311A1CSURR"},{"id":20336966,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_violation_id":"273734665","seq_no":"2","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"213126852","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2026-04-27T09:53:28.000000Z","updated_at":"2026-05-01T09:44:00.000000Z","normalized_code":"39343BBATV"}],"inspection_per_units":[{"id":20367567,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_unit_id":"213126852","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06\/WHT","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:49.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"},{"id":20367568,"change_date":"2026-04-20 21:39:00","inspection_id":"87630293","insp_unit_id":"213126853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"CW179113\/WH","insp_unit_license":"4SW3259","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3VS32C8LR457310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:12:49.000000Z","updated_at":"2026-05-01T09:05:17.000000Z"}]},{"id":11557346,"change_date":"2026-04-02 21:39:00","inspection_id":"87480547","dot_number":"3845968","report_state":"CA","report_number":"UESQ005872","insp_date":"2026-04-02 00:00:00","insp_start_time":"0535","insp_end_time":"0545","registration_date":null,"region":"PT","ci_status_code":"C","location":"9252","location_desc":"GRANTLINE ON TO NB SR-99","county_code_state":"CA","county_code":"067","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-02 21:39: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":"16232509","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2026-04-05T09:57:04.000000Z","updated_at":"2026-04-13T09:31:39.000000Z","inspection_violations":[{"id":19533799,"change_date":"2026-04-02 21:39:00","inspection_id":"87480547","insp_violation_id":"272843232","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:59.000000Z","updated_at":"2026-04-12T10:18:44.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":19806113,"change_date":"2026-04-02 21:39:00","inspection_id":"87480547","insp_unit_id":"212519278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:23.000000Z","updated_at":"2026-04-13T09:05:00.000000Z"},{"id":19806114,"change_date":"2026-04-02 21:39:00","inspection_id":"87480547","insp_unit_id":"212519279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:23.000000Z","updated_at":"2026-04-13T09:05:00.000000Z"}]},{"id":11547122,"change_date":"2026-04-01 21:40:00","inspection_id":"87469792","dot_number":"3845968","report_state":"CA","report_number":"UD89003605","insp_date":"2026-03-24 00:00:00","insp_start_time":"0720","insp_end_time":"0758","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"W\/B I-80 CORDELIA I.F.","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"16230008","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2026-04-04T09:43:36.000000Z","updated_at":"2026-04-12T09:32:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19786118,"change_date":"2026-04-01 21:40:00","inspection_id":"87469792","insp_unit_id":"212489281","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:51.000000Z","updated_at":"2026-04-12T09:12:03.000000Z"},{"id":19786119,"change_date":"2026-04-01 21:40:00","inspection_id":"87469792","insp_unit_id":"212489282","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:51.000000Z","updated_at":"2026-04-12T09:12:03.000000Z"}]},{"id":11547924,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","dot_number":"3845968","report_state":"CA","report_number":"NDUP008142","insp_date":"2026-03-24 00:00:00","insp_start_time":"0638","insp_end_time":"0702","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"3950 E\/B INTERSTATE 80","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":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16230004","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2026-04-04T09:43:38.000000Z","updated_at":"2026-04-12T09:33:07.000000Z","inspection_violations":[{"id":19512254,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810731","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"39347E"},{"id":19512255,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810732","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"39353BB"},{"id":19512256,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810733","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"39347E"},{"id":19512257,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810734","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"3963A1BOS"},{"id":19512258,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810735","seq_no":"5","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"39311A1LCL"},{"id":19512259,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_violation_id":"272810736","seq_no":"6","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"212490663","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:46.000000Z","updated_at":"2026-04-11T09:49:57.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":19787392,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_unit_id":"212490662","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"#06 3XWHT","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:52.000000Z","updated_at":"2026-04-12T09:12:14.000000Z"},{"id":19787393,"change_date":"2026-04-01 21:40:00","inspection_id":"87470624","insp_unit_id":"212490663","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"#482 2X","insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:52.000000Z","updated_at":"2026-04-12T09:12:14.000000Z"}]},{"id":9991372,"change_date":"2025-10-20 21:40:00","inspection_id":"86101042","dot_number":"3845968","report_state":"CA","report_number":"UDKP002695","insp_date":"2025-10-19 00:00:00","insp_start_time":"0750","insp_end_time":"0825","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"E\/B ANTELOPE SCALES","county_code_state":"CA","county_code":"067","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":"2025-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","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":"16023640","transaction_code":"A","transaction_date":"2025-10-19 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2025-10-20 21:40:00","snet_input_date":"2025-10-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-20 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2025-10-23T10:00:48.000000Z","updated_at":"2025-10-24T10:01:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16591556,"change_date":"2025-10-20 21:40:00","inspection_id":"86101042","insp_unit_id":"209566604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"Y","insp_unit_decal_number":"35612795","created_at":"2025-10-23T09:46:03.000000Z","updated_at":"2025-10-24T09:46:50.000000Z"},{"id":16591557,"change_date":"2025-10-20 21:40:00","inspection_id":"86101042","insp_unit_id":"209566605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4WM5863","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K0SJ102099","insp_unit_decal":"Y","insp_unit_decal_number":"35612796","created_at":"2025-10-23T09:46:03.000000Z","updated_at":"2025-10-24T09:46:50.000000Z"}]},{"id":9503287,"change_date":"2025-08-25 21:40:00","inspection_id":"85588214","dot_number":"3845968","report_state":"CA","report_number":"UF73003064","insp_date":"2025-08-14 00:00:00","insp_start_time":"0757","insp_end_time":"0853","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":"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-08-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15951189","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2025-08-29T10:42:48.000000Z","updated_at":"2025-08-29T10:42:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18740609,"change_date":null,"inspection_id":"85588214","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18824413,"change_date":null,"inspection_id":"85588214","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"4NR2964","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532CXFT503047","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8037640,"change_date":"2025-03-05 21:40:00","inspection_id":"84043325","dot_number":"3845968","report_state":"CA","report_number":"NDZ5005401","insp_date":"2025-02-28 00:00:00","insp_start_time":"1755","insp_end_time":"1838","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":"2025-03-05 21:40: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":"15728287","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-02-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2025-03-17T21:04:59.000000Z","updated_at":"2025-03-17T21:04:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12976297,"change_date":"2025-03-05 21:40:00","inspection_id":"84043325","insp_unit_id":"205647559","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"9G91194","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJHPDV7KLKG7766","insp_unit_decal":"Y","insp_unit_decal_number":"34773990","created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"},{"id":12976298,"change_date":"2025-03-05 21:40:00","inspection_id":"84043325","insp_unit_id":"205647560","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"103","insp_unit_license":"4LH8693","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C31T097136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:21.000000Z","updated_at":"2025-03-17T23:58:21.000000Z"}]},{"id":7538788,"change_date":"2025-01-02 21:39:00","inspection_id":"83519448","dot_number":"3845968","report_state":"CA","report_number":"UCUF004029","insp_date":"2024-12-30 00:00:00","insp_start_time":"1237","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 W\/B 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":"NIAGARA BOTTLING LLC","shipping_paper_number":"37504549","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15646897","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2025-03-17T20:53:14.000000Z","updated_at":"2025-03-17T20:53:14.000000Z","inspection_violations":[{"id":11783452,"change_date":"2025-01-02 21:39:00","inspection_id":"83519448","insp_violation_id":"263736497","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"204632148","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"RJ 76225","created_at":"2025-03-17T22:03:26.000000Z","updated_at":"2025-03-17T22:03:26.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":12162877,"change_date":"2025-01-02 21:39:00","inspection_id":"83519448","insp_unit_id":"204632147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GRN #05","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"},{"id":12162878,"change_date":"2025-01-02 21:39:00","inspection_id":"83519448","insp_unit_id":"204632148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"482","insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"}]},{"id":7538994,"change_date":"2025-01-02 21:39:00","inspection_id":"83519655","dot_number":"3845968","report_state":"CA","report_number":"UE03003681","insp_date":"2024-12-28 00:00:00","insp_start_time":"1320","insp_end_time":"1349","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"LIVERMORE","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"15646780","transaction_code":"A","transaction_date":"2024-12-28 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2025-01-02 21:39:00","snet_input_date":"2024-12-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-02 21:39:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:14.000000Z","updated_at":"2025-03-17T20:53:14.000000Z","inspection_violations":[{"id":11783766,"change_date":"2025-01-02 21:39:00","inspection_id":"83519655","insp_violation_id":"263736818","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"2","insp_unit_id":"204632519","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922SLLEWA1"},{"id":11783767,"change_date":"2025-01-02 21:39:00","inspection_id":"83519655","insp_violation_id":"263736819","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"204632519","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA517744","created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"39375CTAOTDLT1\/32"}],"inspection_per_units":[{"id":12163234,"change_date":"2025-01-02 21:39:00","inspection_id":"83519655","insp_unit_id":"204632518","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3AX GRN","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"},{"id":12163235,"change_date":"2025-01-02 21:39:00","inspection_id":"83519655","insp_unit_id":"204632519","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"2AX","insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:16.000000Z","updated_at":"2025-03-17T23:49:16.000000Z"}]},{"id":7511287,"change_date":"2024-12-27 21:38:00","inspection_id":"83490604","dot_number":"3845968","report_state":"CA","report_number":"NATH004322","insp_date":"2024-12-26 00:00:00","insp_start_time":"1035","insp_end_time":"1059","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":"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":"2024-12-27 21:38: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":"15643429","transaction_code":"A","transaction_date":"2024-12-26 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2024-12-27 21:38:00","snet_input_date":"2024-12-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"607409","created_at":"2025-03-17T20:52:42.000000Z","updated_at":"2025-03-17T20:52:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12117806,"change_date":"2024-12-27 21:38:00","inspection_id":"83490604","insp_unit_id":"204577132","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:47.000000Z","updated_at":"2025-03-17T23:48:47.000000Z"},{"id":12117807,"change_date":"2024-12-27 21:38:00","inspection_id":"83490604","insp_unit_id":"204577133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRATD","insp_unit_company":null,"insp_unit_license":"4LL3449","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA9620XB180809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:47.000000Z","updated_at":"2025-03-17T23:48:47.000000Z"}]},{"id":7305085,"change_date":"2024-11-30 21:32:00","inspection_id":"83273967","dot_number":"3845968","report_state":"CA","report_number":"NDKW007213","insp_date":"2024-11-25 00:00:00","insp_start_time":"1615","insp_end_time":"1645","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":"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":"2024-11-30 21:32: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":"15608184","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2024-11-30 21:32:00","snet_input_date":"2024-11-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:32:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"607409","created_at":"2025-03-17T20:48:33.000000Z","updated_at":"2025-03-17T20:48:33.000000Z","inspection_violations":[{"id":11422352,"change_date":"2024-11-30 21:32:00","inspection_id":"83273967","insp_violation_id":"263149496","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"204108376","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ33434","created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"3922SLLSR"},{"id":11422353,"change_date":"2024-11-30 21:32:00","inspection_id":"83273967","insp_violation_id":"263149497","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"204108376","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:33.000000Z","updated_at":"2025-03-17T22:01:33.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":11784195,"change_date":"2024-11-30 21:32:00","inspection_id":"83273967","insp_unit_id":"204108375","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05 \/ GRN","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:07.000000Z","updated_at":"2025-03-17T23:45:07.000000Z"},{"id":11784196,"change_date":"2024-11-30 21:32:00","inspection_id":"83273967","insp_unit_id":"204108376","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"MAT003\/ WHT","insp_unit_license":"4UC8245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y8WL428005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:07.000000Z","updated_at":"2025-03-17T23:45:07.000000Z"}]},{"id":6661314,"change_date":"2024-09-05 21:43:00","inspection_id":"82590457","dot_number":"3845968","report_state":"CA","report_number":"UCOM000221","insp_date":"2024-09-02 00:00:00","insp_start_time":"0850","insp_end_time":"0930","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":"2024-09-05 21:43: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":"15511625","transaction_code":"A","transaction_date":"2024-09-02 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:11.000000Z","updated_at":"2025-03-17T20:35:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10739953,"change_date":"2024-09-05 21:43:00","inspection_id":"82590457","insp_unit_id":"202788469","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"},{"id":10739954,"change_date":"2024-09-05 21:43:00","inspection_id":"82590457","insp_unit_id":"202788470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2X","insp_unit_license":"4UC8245","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532Y8WL428005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:11.000000Z","updated_at":"2025-03-17T23:34:11.000000Z"}]},{"id":4038615,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","dot_number":"3845968","report_state":"CA","report_number":"NEDJ001858","insp_date":"2023-09-20 00:00:00","insp_start_time":"2318","insp_end_time":"2355","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TRINITY FRUIT -PACA","shipping_paper_number":"408952","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15071138","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2023-09-22 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-22 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"607409","created_at":"2025-03-17T19:42:27.000000Z","updated_at":"2025-03-17T19:42:27.000000Z","inspection_violations":[{"id":6252369,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","insp_violation_id":"255439521","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197199125","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"KR 31697","created_at":"2025-03-17T21:36:10.000000Z","updated_at":"2025-03-17T21:36:10.000000Z","normalized_code":"3922"},{"id":6252370,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","insp_violation_id":"255439522","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"197199125","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:36:10.000000Z","updated_at":"2025-03-17T21:36:10.000000Z","normalized_code":"39375A3"},{"id":6252371,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","insp_violation_id":"255439523","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197199124","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:36:10.000000Z","updated_at":"2025-03-17T21:36:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6493403,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","insp_unit_id":"197199124","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:30.000000Z","updated_at":"2025-03-17T22:54:30.000000Z"},{"id":6493404,"change_date":"2023-09-22 21:40:00","inspection_id":"79735652","insp_unit_id":"197199125","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1995","insp_unit_license":"CF49R56","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536HM752516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:30.000000Z","updated_at":"2025-03-17T22:54:30.000000Z"}]},{"id":3751221,"change_date":"2023-08-15 21:44:00","inspection_id":"79415315","dot_number":"3845968","report_state":"CA","report_number":"NCEB005869","insp_date":"2023-08-08 00:00:00","insp_start_time":"2010","insp_end_time":"2037","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-08-15 21:44: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":"15021784","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2023-08-15 21:44:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-15 21:44:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:55.000000Z","updated_at":"2025-03-17T19:36:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6031801,"change_date":"2023-08-15 21:44:00","inspection_id":"79415315","insp_unit_id":"196550336","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05 GREEN","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"Y","insp_unit_decal_number":"32916964","created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"},{"id":6031802,"change_date":"2023-08-15 21:44:00","inspection_id":"79415315","insp_unit_id":"196550337","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"CW179398","insp_unit_license":"4PV5996","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1HL035432","insp_unit_decal":"Y","insp_unit_decal_number":"32916965","created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":2880843,"change_date":"2023-04-24 21:42:00","inspection_id":"78435637","dot_number":"3845968","report_state":"CA","report_number":"UEAO003453","insp_date":"2023-04-20 00:00:00","insp_start_time":"0930","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-24 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":"14870128","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2023-04-24 21:42:00","snet_input_date":"2023-04-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-24 21:42:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:01.000000Z","updated_at":"2025-03-17T19:20:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4635299,"change_date":"2023-04-24 21:42:00","inspection_id":"78435637","insp_unit_id":"194560499","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3XGRN","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"Y","insp_unit_decal_number":"32468287","created_at":"2025-03-17T22:39:34.000000Z","updated_at":"2025-03-17T22:39:34.000000Z"}]},{"id":2670150,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","dot_number":"3845968","report_state":"CA","report_number":"NDN6006980","insp_date":"2023-03-23 00:00:00","insp_start_time":"1024","insp_end_time":"1059","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":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14833900","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03845968","upload_search_indicator":null,"census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"ANDRADE'S EXPRESS LLC","insp_carrier_street":"825 CALIFORNIA ST","insp_carrier_city":"ESCALON","insp_carrier_state":"CA","insp_carrier_zip_code":"95320","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4104591,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_violation_id":"251890863","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194085037","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"DA308858","created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39345D"},{"id":4104592,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_violation_id":"251890864","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194085037","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39345D"},{"id":4104593,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_violation_id":"251890865","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194085037","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3963A1"},{"id":4104594,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_violation_id":"251890866","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194085037","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39345B2"},{"id":4104595,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_violation_id":"251890867","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194085037","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4299488,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_unit_id":"194085037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3X GREEN","insp_unit_license":"9F47186","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FUJGBDV7BLAW4695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"},{"id":4299489,"change_date":"2023-03-27 21:40:00","inspection_id":"78195909","insp_unit_id":"194085038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"2X VAN","insp_unit_license":"4TB4806","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532C9MR228085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3845968\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3845968\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3845968\/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\/3845968\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}