{"current_page":1,"data":[{"id":12509410,"change_date":"2026-07-21 21:40:00","inspection_id":"88473627","dot_number":"2707735","report_state":"CA","report_number":"UDLF004829","insp_date":"2026-07-21 00:00:00","insp_start_time":"1146","insp_end_time":"1202","registration_date":null,"region":"PD","ci_status_code":"C","location":"220","location_desc":"CA","county_code_state":"CA","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"3804056","transaction_code":"A","transaction_date":"2026-07-21 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2026-07-21 21:40:00","snet_input_date":"2026-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:32.000000Z","updated_at":"2026-08-01T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21725030,"change_date":"2026-07-21 21:40:00","inspection_id":"88473627","insp_unit_id":"214737508","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G41774","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X6ND785258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:20:08.000000Z","updated_at":"2026-08-01T09:02:28.000000Z"}]},{"id":12509159,"change_date":"2026-07-21 21:40:00","inspection_id":"88473362","dot_number":"2707735","report_state":"CA","report_number":"UDLF004828","insp_date":"2026-07-21 00:00:00","insp_start_time":"1141","insp_end_time":"1149","registration_date":null,"region":"PD","ci_status_code":"C","location":"220","location_desc":"CA","county_code_state":"CA","county_code":"061","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:40: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":"3803911","transaction_code":"A","transaction_date":"2026-07-21 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2026-07-21 21:40:00","snet_input_date":"2026-07-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:32.000000Z","updated_at":"2026-08-01T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21724621,"change_date":"2026-07-21 21:40:00","inspection_id":"88473362","insp_unit_id":"214737069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G37572","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4KC9EJ4KN903073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:20:07.000000Z","updated_at":"2026-08-01T09:02:24.000000Z"}]},{"id":12516499,"change_date":"2026-07-22 21:43:00","inspection_id":"88481525","dot_number":"2707735","report_state":"CA","report_number":"NA5N009645","insp_date":"2026-07-20 00:00:00","insp_start_time":"1342","insp_end_time":"1427","registration_date":null,"region":"PD","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-07-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"3810011","transaction_code":"A","transaction_date":"2026-07-22 00:00:00","upload_date":"2026-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2026-07-22 21:43:00","snet_input_date":"2026-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-22 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-25T09:41:32.000000Z","updated_at":"2026-08-02T09:30:46.000000Z","inspection_violations":[{"id":21790057,"change_date":"2026-07-22 21:43:00","inspection_id":"88481525","insp_violation_id":"275657631","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"214753502","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN88363","created_at":"2026-07-25T10:02:01.000000Z","updated_at":"2026-08-02T09:42:29.000000Z","normalized_code":"3922SLLEWA1"},{"id":21790058,"change_date":"2026-07-22 21:43:00","inspection_id":"88481525","insp_violation_id":"275657632","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"214753502","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:02:01.000000Z","updated_at":"2026-08-02T09:42:29.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":21736827,"change_date":"2026-07-22 21:43:00","inspection_id":"88481525","insp_unit_id":"214753502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4 X ED WHT","insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-25T09:20:33.000000Z","updated_at":"2026-08-03T09:02:13.000000Z"}]},{"id":11974438,"change_date":"2026-05-20 21:41:00","inspection_id":"87911406","dot_number":"2707735","report_state":"CA","report_number":"UD6V001457","insp_date":"2026-05-19 00:00:00","insp_start_time":"0711","insp_end_time":"0756","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3370158","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":"02707735","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":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","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:31:02.000000Z","inspection_violations":[{"id":20830550,"change_date":"2026-05-20 21:41:00","inspection_id":"87911406","insp_violation_id":"274396321","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"213667156","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-23T10:06:10.000000Z","updated_at":"2026-06-01T09:41:47.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":20818766,"change_date":"2026-05-20 21:41:00","inspection_id":"87911406","insp_unit_id":"213667156","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4X ED WHT","insp_unit_license":"84788U1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3ALHG3CY6FDGN3750","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:31.000000Z","updated_at":"2026-06-01T09:03:20.000000Z"}]},{"id":11974254,"change_date":"2026-05-20 21:41:00","inspection_id":"87911214","dot_number":"2707735","report_state":"CA","report_number":"UD6V001448","insp_date":"2026-05-18 00:00:00","insp_start_time":"0732","insp_end_time":"0806","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","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":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3369994","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":"02707735","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":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","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:31:02.000000Z","inspection_violations":[{"id":20830244,"change_date":"2026-05-20 21:41:00","inspection_id":"87911214","insp_violation_id":"274395978","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"1","insp_unit_id":"213666847","insp_violation_category_id":"47","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-23T10:06:09.000000Z","updated_at":"2026-06-01T09:41:47.000000Z","normalized_code":"3922SLLEWA3"}],"inspection_per_units":[{"id":20818473,"change_date":"2026-05-20 21:41:00","inspection_id":"87911214","insp_unit_id":"213666847","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4AXL ED","insp_unit_license":"42716B2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FVHG3CY5GHHC4394","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":11764491,"change_date":"2026-04-27 21:39:00","inspection_id":"87694957","dot_number":"2707735","report_state":"CA","report_number":"UFYK001323","insp_date":"2026-04-25 00:00:00","insp_start_time":"1111","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 E\/B 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":"2026-04-27 21:39: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":"16262880","transaction_code":"A","transaction_date":"2026-04-25 00:00:00","upload_date":"2026-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2026-04-27 21:39:00","snet_input_date":"2026-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-27 21:39:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2026-04-30T09:39:45.000000Z","updated_at":"2026-05-08T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20467665,"change_date":"2026-04-27 21:39:00","inspection_id":"87694957","insp_unit_id":"213256456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHI","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:59.000000Z","updated_at":"2026-05-08T09:04:44.000000Z"},{"id":20467666,"change_date":"2026-04-27 21:39:00","inspection_id":"87694957","insp_unit_id":"213256457","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALTM","insp_unit_company":"2X ED WHI","insp_unit_license":"4TR3945","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-30T09:18:59.000000Z","updated_at":"2026-05-08T09:04:44.000000Z"}]},{"id":11668301,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","dot_number":"2707735","report_state":"CA","report_number":"NDN6010366","insp_date":"2026-04-14 00:00:00","insp_start_time":"1210","insp_end_time":"1254","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":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16250017","transaction_code":"A","transaction_date":"2026-04-14 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2026-04-27T09:31:58.000000Z","updated_at":"2026-04-27T09:31:58.000000Z","inspection_violations":[{"id":20266691,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_violation_id":"273654994","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"213059085","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA733610","created_at":"2026-04-27T09:45:37.000000Z","updated_at":"2026-04-27T09:45:37.000000Z","normalized_code":"39345B2BHTD"},{"id":20266692,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_violation_id":"273654995","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213059085","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ80526","created_at":"2026-04-27T09:45:37.000000Z","updated_at":"2026-04-27T09:45:37.000000Z","normalized_code":"3922SLLSR"},{"id":20266693,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_violation_id":"273654996","seq_no":"3","part_no":"393","part_no_section":"43B-BATV","insp_viol_unit":"1","insp_unit_id":"213059085","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:37.000000Z","updated_at":"2026-04-27T09:45:37.000000Z","normalized_code":"39343BBATV"},{"id":20266694,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_violation_id":"273654997","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"213059086","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:37.000000Z","updated_at":"2026-04-27T09:45:37.000000Z","normalized_code":"3922SLLSR"},{"id":20266695,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_violation_id":"273654998","seq_no":"5","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"213059086","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"DA733610","created_at":"2026-04-27T09:45:37.000000Z","updated_at":"2026-04-27T09:45:37.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":20297116,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_unit_id":"213059085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHITE","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:12.000000Z","updated_at":"2026-04-27T09:05:12.000000Z"},{"id":20297117,"change_date":"2026-04-16 21:41:00","inspection_id":"87598700","insp_unit_id":"213059086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALTM","insp_unit_company":"2X ED WHITE","insp_unit_license":"4TR3945","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:05:12.000000Z","updated_at":"2026-04-27T09:05:12.000000Z"}]},{"id":10346638,"change_date":"2025-12-04 21:38:00","inspection_id":"86474319","dot_number":"2707735","report_state":"CA","report_number":"UESQ005527","insp_date":"2025-12-03 00:00:00","insp_start_time":"1045","insp_end_time":"1104","registration_date":null,"region":"PT","ci_status_code":"C","location":"9266","location_desc":"CHRISMAN AT ELISSAGARAY","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"16081037","transaction_code":"C","transaction_date":"2025-12-03 00:00:00","upload_date":"2025-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-12-03 21:39:00","snet_input_date":"2025-12-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-03 21:39:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-12-06T10:31:40.000000Z","updated_at":"2025-12-08T10:30:58.000000Z","inspection_violations":[{"id":17325928,"change_date":"2025-12-04 21:38:00","inspection_id":"86474319","insp_violation_id":"270471287","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"210422393","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:15.000000Z","updated_at":"2025-12-08T10:31:34.000000Z","normalized_code":"39311A1LIL"},{"id":17325929,"change_date":"2025-12-04 21:38:00","inspection_id":"86474319","insp_violation_id":"270471288","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210422393","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:15.000000Z","updated_at":"2025-12-08T10:31:34.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":17296434,"change_date":"2025-12-04 21:38:00","inspection_id":"86474319","insp_unit_id":"210422393","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:31.000000Z","updated_at":"2025-12-08T10:01:09.000000Z"}]},{"id":10184537,"change_date":"2025-11-12 21:41:00","inspection_id":"86304499","dot_number":"2707735","report_state":"CA","report_number":"UD3C001359","insp_date":"2025-11-05 00:00:00","insp_start_time":"1035","insp_end_time":"1057","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 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":"16055263","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-11-15T10:30:55.000000Z","updated_at":"2025-11-16T10:31:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16962626,"change_date":"2025-11-12 21:41:00","inspection_id":"86304499","insp_unit_id":"209991894","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2182","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:47.000000Z","updated_at":"2025-11-16T10:02:08.000000Z"},{"id":16962627,"change_date":"2025-11-12 21:41:00","inspection_id":"86304499","insp_unit_id":"209991895","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"195B715","insp_unit_license":"195B715","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"05749144275133916","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:47.000000Z","updated_at":"2025-11-16T10:02:08.000000Z"}]},{"id":9774557,"change_date":"2025-09-24 21:42:00","inspection_id":"85872570","dot_number":"2707735","report_state":"CA","report_number":"UE74003076","insp_date":"2025-09-19 00:00:00","insp_start_time":"1100","insp_end_time":"1124","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":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15993903","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:20.000000Z","updated_at":"2025-09-28T10:00:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16193160,"change_date":"2025-09-24 21:42:00","inspection_id":"85872570","insp_unit_id":"209134792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:29.000000Z"}]},{"id":9587152,"change_date":"2025-09-03 21:40:00","inspection_id":"85676113","dot_number":"2707735","report_state":"CA","report_number":"UEH7006832","insp_date":"2025-09-03 00:00:00","insp_start_time":"1038","insp_end_time":"1054","registration_date":null,"region":"PT","ci_status_code":"C","location":"260","location_desc":"WHITE ROCK RD @ SUNRISE BLVD","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15965945","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:33.000000Z","updated_at":"2025-09-10T10:45:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15827154,"change_date":"2025-09-03 21:40:00","inspection_id":"85676113","insp_unit_id":"208737077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:40.000000Z","updated_at":"2025-09-09T09:47:40.000000Z"}]},{"id":9346656,"change_date":"2025-08-06 21:40:00","inspection_id":"85423513","dot_number":"2707735","report_state":"CA","report_number":"UDLF004208","insp_date":"2025-08-06 00:00:00","insp_start_time":"0754","insp_end_time":"0801","registration_date":null,"region":"PT","ci_status_code":"C","location":"220","location_desc":"AUBURN AREA","county_code_state":"CA","county_code":"061","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"15927856","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:24.000000Z","updated_at":"2025-08-12T10:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15396022,"change_date":"2025-08-06 21:40:00","inspection_id":"85423513","insp_unit_id":"208271105","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"96218E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPTX40X8MD749195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:23.000000Z","updated_at":"2025-08-10T09:46:11.000000Z"}]},{"id":9228634,"change_date":"2025-07-23 21:42:00","inspection_id":"85299368","dot_number":"2707735","report_state":"CA","report_number":"UFCG000347","insp_date":"2025-07-22 00:00:00","insp_start_time":"0650","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"9266","location_desc":"CHRISMAN AT VALPICO","county_code_state":"CA","county_code":"077","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"84740","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":"15910650","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-07-27T10:41:40.000000Z","updated_at":"2025-07-27T10:41:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15183745,"change_date":"2025-07-23 21:42:00","inspection_id":"85299368","insp_unit_id":"208042324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:33.000000Z","updated_at":"2025-07-27T09:46:21.000000Z"}]},{"id":8622554,"change_date":"2025-05-13 21:41:00","inspection_id":"84659417","dot_number":"2707735","report_state":"CA","report_number":"UGHP000199","insp_date":"2025-05-13 00:00:00","insp_start_time":"1055","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"E\/OF SANTA RITA","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-13 21:41: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":"15817620","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-05-13 21:41:00","snet_input_date":"2025-05-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-13 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-17T10:04:25.000000Z","updated_at":"2025-05-17T10:09:53.000000Z","inspection_violations":[{"id":13709175,"change_date":"2025-05-13 21:41:00","inspection_id":"84659417","insp_violation_id":"266201886","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206839999","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CD070612","created_at":"2025-05-16T10:37:01.000000Z","updated_at":"2025-05-18T10:27:18.000000Z","normalized_code":"3922SLLEQP"},{"id":13709176,"change_date":"2025-05-13 21:41:00","inspection_id":"84659417","insp_violation_id":"266201887","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206839999","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CD070612","created_at":"2025-05-16T10:37:01.000000Z","updated_at":"2025-05-18T10:27:18.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14078809,"change_date":"2025-05-13 21:41:00","inspection_id":"84659417","insp_unit_id":"206839999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:55.000000Z","updated_at":"2025-05-17T09:52:01.000000Z"},{"id":14078810,"change_date":"2025-05-13 21:41:00","inspection_id":"84659417","insp_unit_id":"206840000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESC","insp_unit_company":null,"insp_unit_license":"4TT6046","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102825MW172991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-16T09:49:55.000000Z","updated_at":"2025-05-17T09:52:01.000000Z"}]},{"id":8455681,"change_date":"2025-04-23 21:41:00","inspection_id":"84483581","dot_number":"2707735","report_state":"CA","report_number":"UF44006005","insp_date":"2025-04-22 00:00:00","insp_start_time":"1604","insp_end_time":"1613","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB NO MISSION GRADE CVEF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"51200","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15791313","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-04-26T10:28:51.000000Z","updated_at":"2025-04-27T10:33:45.000000Z","inspection_violations":[{"id":13362030,"change_date":"2025-04-23 21:41:00","inspection_id":"84483581","insp_violation_id":"265801886","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV72096","created_at":"2025-04-25T11:15:44.000000Z","updated_at":"2025-04-26T10:58:59.000000Z","normalized_code":"3922SLLTCD"},{"id":13362031,"change_date":"2025-04-23 21:41:00","inspection_id":"84483581","insp_violation_id":"265801887","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206464864","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RV72097","created_at":"2025-04-25T11:15:44.000000Z","updated_at":"2025-04-26T10:58:59.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13734184,"change_date":"2025-04-23 21:41:00","inspection_id":"84483581","insp_unit_id":"206464864","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G20486","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2KJ234578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:20:28.000000Z","updated_at":"2025-04-27T10:12:47.000000Z"}]},{"id":8396509,"change_date":"2025-04-16 21:41:00","inspection_id":"84421107","dot_number":"2707735","report_state":"CA","report_number":"NBH6006686","insp_date":"2025-04-14 00:00:00","insp_start_time":"0742","insp_end_time":"0805","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"15782841","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-04-16 21:41:00","snet_input_date":"2025-04-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-16 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"21171 S TRACY BLVD","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95304","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-04-19T10:19:39.000000Z","updated_at":"2025-04-20T10:27:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13629778,"change_date":"2025-04-16 21:41:00","inspection_id":"84421107","insp_unit_id":"206351633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2173","insp_unit_license":"96218E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPTX40X8MD749195","insp_unit_decal":"Y","insp_unit_decal_number":"35058675","created_at":"2025-04-19T10:12:43.000000Z","updated_at":"2025-04-20T10:05:36.000000Z"}]},{"id":7971992,"change_date":"2025-02-26 21:42:00","inspection_id":"83974336","dot_number":"2707735","report_state":"CA","report_number":"NB7F001434","insp_date":"2025-02-25 00:00:00","insp_start_time":"1112","insp_end_time":"1220","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"15718136","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12457042,"change_date":"2025-02-26 21:42:00","inspection_id":"83974336","insp_violation_id":"264723026","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205521860","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":12869720,"change_date":"2025-02-26 21:42:00","inspection_id":"83974336","insp_unit_id":"205521860","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2155","insp_unit_license":"9G43391","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X9NJ491533","insp_unit_decal":"Y","insp_unit_decal_number":"34761181","created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"},{"id":12869721,"change_date":"2025-02-26 21:42:00","inspection_id":"83974336","insp_unit_id":"205521861","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"G1623","insp_unit_license":"4UZ1455","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0623BT559253","insp_unit_decal":"Y","insp_unit_decal_number":"34761182","created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7971993,"change_date":"2025-02-26 21:42:00","inspection_id":"83974337","dot_number":"2707735","report_state":"CA","report_number":"NB7F001435","insp_date":"2025-02-25 00:00:00","insp_start_time":"1221","insp_end_time":"1241","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"15718137","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12457043,"change_date":"2025-02-26 21:42:00","inspection_id":"83974337","insp_violation_id":"264723027","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"205521862","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":12869722,"change_date":"2025-02-26 21:42:00","inspection_id":"83974337","insp_unit_id":"205521862","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WANC","insp_unit_company":"C1620","insp_unit_license":"4ND3572","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D8FL839157","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7971994,"change_date":"2025-02-26 21:42:00","inspection_id":"83974338","dot_number":"2707735","report_state":"CA","report_number":"NB7F001436","insp_date":"2025-02-25 00:00:00","insp_start_time":"1242","insp_end_time":"1316","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66200","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":"15718138","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12869723,"change_date":"2025-02-26 21:42:00","inspection_id":"83974338","insp_unit_id":"205521863","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2083","insp_unit_license":"69775P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4N99EH2KN904375","insp_unit_decal":"Y","insp_unit_decal_number":"34761183","created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7971995,"change_date":"2025-02-26 21:42:00","inspection_id":"83974339","dot_number":"2707735","report_state":"CA","report_number":"NB7F001437","insp_date":"2025-02-25 00:00:00","insp_start_time":"1317","insp_end_time":"1337","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"15718139","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12869724,"change_date":"2025-02-26 21:42:00","inspection_id":"83974339","insp_unit_id":"205521864","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WANC","insp_unit_company":"1616","insp_unit_license":"4NM8871","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1JJV532D1FL874235","insp_unit_decal":"Y","insp_unit_decal_number":"34761184","created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7972089,"change_date":"2025-02-26 21:42:00","inspection_id":"83974435","dot_number":"2707735","report_state":"CA","report_number":"NB7F001438","insp_date":"2025-02-25 00:00:00","insp_start_time":"1338","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"15718140","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12869861,"change_date":"2025-02-26 21:42:00","inspection_id":"83974435","insp_unit_id":"205522011","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"WESC","insp_unit_company":"ED03","insp_unit_license":"4TT6046","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102825MW172991","insp_unit_decal":"Y","insp_unit_decal_number":"34761185","created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7973457,"change_date":"2025-02-26 21:42:00","inspection_id":"83975846","dot_number":"2707735","report_state":"CA","report_number":"NB7F001432","insp_date":"2025-02-25 00:00:00","insp_start_time":"0922","insp_end_time":"1015","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125350","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":"15718128","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:40.000000Z","updated_at":"2025-03-17T21:03:40.000000Z","inspection_violations":[{"id":12458882,"change_date":"2025-02-26 21:42:00","inspection_id":"83975846","insp_violation_id":"264725090","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205524249","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":12871957,"change_date":"2025-02-26 21:42:00","inspection_id":"83975846","insp_unit_id":"205524249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2182","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"Y","insp_unit_decal_number":"34761177","created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"},{"id":12871958,"change_date":"2025-02-26 21:42:00","inspection_id":"83975846","insp_unit_id":"205524250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALMT","insp_unit_company":"ED02","insp_unit_license":"4TR3944","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A27NA000167","insp_unit_decal":"Y","insp_unit_decal_number":"34761178","created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"}]},{"id":7973458,"change_date":"2025-02-26 21:42:00","inspection_id":"83975847","dot_number":"2707735","report_state":"CA","report_number":"NB7F001433","insp_date":"2025-02-25 00:00:00","insp_start_time":"1016","insp_end_time":"1111","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"21171 S. TRACY BLVD., TRACY","county_code_state":"CA","county_code":"077","insp_level_id":"5","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123200","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":"15718129","transaction_code":"A","transaction_date":"2025-02-25 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T21:03:40.000000Z","updated_at":"2025-03-17T21:03:40.000000Z","inspection_violations":[{"id":12458883,"change_date":"2025-02-26 21:42:00","inspection_id":"83975847","insp_violation_id":"264725091","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"205524251","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":12871959,"change_date":"2025-02-26 21:42:00","inspection_id":"83975847","insp_unit_id":"205524251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2164","insp_unit_license":"9G41774","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X6ND785258","insp_unit_decal":"Y","insp_unit_decal_number":"34761179","created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"},{"id":12871960,"change_date":"2025-02-26 21:42:00","inspection_id":"83975847","insp_unit_id":"205524252","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANCO","insp_unit_company":"ED05","insp_unit_license":"4TR4802","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"591SD3022JR156691","insp_unit_decal":"Y","insp_unit_decal_number":"34761180","created_at":"2025-03-17T23:57:11.000000Z","updated_at":"2025-03-17T23:57:11.000000Z"}]},{"id":7695953,"change_date":"2025-01-23 21:39:00","inspection_id":"83684461","dot_number":"2707735","report_state":"CA","report_number":"UE99005404","insp_date":"2025-01-23 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"PT","ci_status_code":"C","location":"266","location_desc":"CORRAL HOLLOW AT LINNE","county_code_state":"CA","county_code":"077","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66200","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15675636","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2025-01-23 21:39:00","snet_input_date":"2025-01-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-23 21:39:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:56.000000Z","updated_at":"2025-03-17T20:57:56.000000Z","inspection_violations":[{"id":12024816,"change_date":"2025-01-23 21:39:00","inspection_id":"83684461","insp_violation_id":"264149578","seq_no":"1","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":12418725,"change_date":"2025-01-23 21:39:00","inspection_id":"83684461","insp_unit_id":"204981071","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"69775P3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4N99EH2KN904375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:02.000000Z","updated_at":"2025-03-17T23:52:02.000000Z"}]},{"id":7466110,"change_date":"2024-12-19 21:41:00","inspection_id":"83443090","dot_number":"2707735","report_state":"CA","report_number":"UEAO004785","insp_date":"2024-12-18 00:00:00","insp_start_time":"1824","insp_end_time":"1841","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":"2024-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64999","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":"15636098","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2024-12-19 21:41:00","snet_input_date":"2024-12-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-19 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:55.000000Z","updated_at":"2025-03-17T20:51:55.000000Z","inspection_violations":[{"id":11670055,"change_date":"2024-12-19 21:41:00","inspection_id":"83443090","insp_violation_id":"263590902","seq_no":"1","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"204491710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ77431","created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39311A1LHLM"}],"inspection_per_units":[{"id":12044799,"change_date":"2024-12-19 21:41:00","inspection_id":"83443090","insp_unit_id":"204491710","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XWHT","insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:59.000000Z","updated_at":"2025-03-17T23:47:59.000000Z"}]},{"id":7179877,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","dot_number":"2707735","report_state":"CA","report_number":"UEED002737","insp_date":"2024-11-08 00:00:00","insp_start_time":"1515","insp_end_time":"1530","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"JNO INDUSTRIAL WAY","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15589123","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:38.000000Z","updated_at":"2025-03-17T20:45:38.000000Z","inspection_violations":[{"id":11218948,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","insp_violation_id":"262861158","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"3922SLLTCD"},{"id":11218949,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","insp_violation_id":"262861159","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"203851941","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"3922SLLEQP"},{"id":11218950,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","insp_violation_id":"262861160","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203851940","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:25.000000Z","updated_at":"2025-03-17T22:00:25.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11580932,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","insp_unit_id":"203851940","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G43391","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X9NJ491533","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"},{"id":11580933,"change_date":"2024-11-12 21:42:00","inspection_id":"83141495","insp_unit_id":"203851941","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALMT","insp_unit_company":null,"insp_unit_license":"4TR3944","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A27NA000167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:01.000000Z","updated_at":"2025-03-17T23:43:01.000000Z"}]},{"id":7120257,"change_date":"2024-11-04 21:41:00","inspection_id":"83078382","dot_number":"2707735","report_state":"CA","report_number":"UED8000689","insp_date":"2024-11-04 00:00:00","insp_start_time":"0517","insp_end_time":"0535","registration_date":null,"region":"PT","ci_status_code":"C","location":"9320","location_desc":"WB SR-4 AT SR-160","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"15581268","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-11-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T20:44:37.000000Z","updated_at":"2025-03-17T20:44:37.000000Z","inspection_violations":[{"id":11119841,"change_date":"2024-11-04 21:41:00","inspection_id":"83078382","insp_violation_id":"262726032","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:55.000000Z","updated_at":"2025-03-17T21:59:55.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":11484007,"change_date":"2024-11-04 21:41:00","inspection_id":"83078382","insp_unit_id":"203734537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","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":11484008,"change_date":"2024-11-04 21:41:00","inspection_id":"83078382","insp_unit_id":"203734538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESC","insp_unit_company":"2X ED WHI","insp_unit_license":"4TT6046","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102825MN172991","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":6772806,"change_date":"2024-09-19 21:42:00","inspection_id":"82709082","dot_number":"2707735","report_state":"CA","report_number":"UDBL003662","insp_date":"2024-09-16 00:00:00","insp_start_time":"1334","insp_end_time":"1345","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"I-580 EASTBOUND, LIVERMORE","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","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":"15527369","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH STREE #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T20:37:21.000000Z","updated_at":"2025-03-17T20:37:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10921667,"change_date":"2024-09-19 21:42:00","inspection_id":"82709082","insp_unit_id":"203036617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3XWHT","insp_unit_license":"9G37572","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4KC9EJ4KN903073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"},{"id":10921668,"change_date":"2024-09-19 21:42:00","inspection_id":"82709082","insp_unit_id":"203036618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WECO.","insp_unit_company":"2XEDWHT","insp_unit_license":"4RV3759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102824KW172961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:09.000000Z","updated_at":"2025-03-17T23:36:09.000000Z"}]},{"id":5299767,"change_date":"2024-03-15 21:41:00","inspection_id":"81120359","dot_number":"2707735","report_state":"CA","report_number":"UBZU003500","insp_date":"2024-03-13 00:00:00","insp_start_time":"0800","insp_end_time":"0820","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CORDELIA CVEF","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":"2024-03-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"15283093","transaction_code":"A","transaction_date":"2024-03-13 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2024-03-15 21:41:00","snet_input_date":"2024-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-15 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T20:07:32.000000Z","updated_at":"2025-03-17T20:07:32.000000Z","inspection_violations":[{"id":8173646,"change_date":"2024-03-15 21:41:00","inspection_id":"81120359","insp_violation_id":"258418018","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199943893","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"},{"id":8173647,"change_date":"2024-03-15 21:41:00","inspection_id":"81120359","insp_violation_id":"258418019","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199943893","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8534759,"change_date":"2024-03-15 21:41:00","inspection_id":"81120359","insp_unit_id":"199943893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"96218E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPTX40X8MD749195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:20.000000Z","updated_at":"2025-03-17T23:12:20.000000Z"}]},{"id":4155420,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","dot_number":"2707735","report_state":"CA","report_number":"NAGM007296","insp_date":"2023-10-04 00:00:00","insp_start_time":"0916","insp_end_time":"0941","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-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15090425","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:58.000000Z","updated_at":"2025-03-17T19:44:58.000000Z","inspection_violations":[{"id":6432023,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","insp_violation_id":"255730903","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197462451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3939A"},{"id":6432024,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","insp_violation_id":"255730904","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"197462451","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39375C"},{"id":6432025,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","insp_violation_id":"255730905","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197462451","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39347E"},{"id":6432026,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","insp_violation_id":"255730906","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197462451","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6681788,"change_date":"2023-10-09 21:36:00","inspection_id":"79865439","insp_unit_id":"197462451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2038\/WHT","insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"}]},{"id":4017716,"change_date":"2023-09-20 21:40:00","inspection_id":"79712324","dot_number":"2707735","report_state":"CA","report_number":"UDEX004636","insp_date":"2023-09-20 00:00:00","insp_start_time":"0915","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"9295","location_desc":"IONE","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"15068702","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-09-20 21:40:00","snet_input_date":"2023-09-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-09-20 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:04.000000Z","updated_at":"2025-03-17T19:42:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6460145,"change_date":"2023-09-20 21:40:00","inspection_id":"79712324","insp_unit_id":"197153831","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G37572","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4KC9EJ4KN903073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:14.000000Z","updated_at":"2025-03-17T22:54:14.000000Z"},{"id":6460146,"change_date":"2023-09-20 21:40:00","inspection_id":"79712324","insp_unit_id":"197153832","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTS","insp_unit_company":null,"insp_unit_license":"4RS5554","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"5TU244029CS001090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:14.000000Z","updated_at":"2025-03-17T22:54:14.000000Z"}]},{"id":3884070,"change_date":"2023-08-31 21:43:00","inspection_id":"79563862","dot_number":"2707735","report_state":"CA","report_number":"UDM7002633","insp_date":"2023-08-31 00:00:00","insp_start_time":"0735","insp_end_time":"0759","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"LAKE HERMAN RD W\/O RESERVOIR R","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15046003","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-31 21:43:00","snet_input_date":"2023-08-31 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-31 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T19:39:41.000000Z","updated_at":"2025-03-17T19:39:41.000000Z","inspection_violations":[{"id":6003090,"change_date":"2023-08-31 21:43:00","inspection_id":"79563862","insp_violation_id":"255034795","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"},{"id":6003091,"change_date":"2023-08-31 21:43:00","inspection_id":"79563862","insp_violation_id":"255034796","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196855082","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW891467","created_at":"2025-03-17T21:35:05.000000Z","updated_at":"2025-03-17T21:35:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6244668,"change_date":"2023-08-31 21:43:00","inspection_id":"79563862","insp_unit_id":"196855082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:27.000000Z","updated_at":"2025-03-17T22:52:27.000000Z"}]},{"id":3829175,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","dot_number":"2707735","report_state":"CA","report_number":"UE84999209","insp_date":"2023-08-24 00:00:00","insp_start_time":"0950","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"135","location_desc":"WHISKEYTOWN SCALE","county_code_state":"CA","county_code":"089","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15035973","transaction_code":"A","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-24 21:42:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-24 21:42:00","insp_carrier_name":"ADVANCED TRUCKING","insp_carrier_street":"1852 W 11TH ST 243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:31.000000Z","updated_at":"2025-03-17T19:38:31.000000Z","inspection_violations":[{"id":5912810,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","insp_violation_id":"254877832","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196723445","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3922"},{"id":5912811,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","insp_violation_id":"254877833","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196723445","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"JU12225","created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3939A"},{"id":5912812,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","insp_violation_id":"254877834","seq_no":"3","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:33.000000Z","updated_at":"2025-03-17T21:34:33.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":6156503,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","insp_unit_id":"196723444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"9G20486","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X2KJ234578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"},{"id":6156504,"change_date":"2023-08-24 21:42:00","inspection_id":"79502507","insp_unit_id":"196723445","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"WHT DMP","insp_unit_license":"4RV3759","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102824KW172961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:43.000000Z","updated_at":"2025-03-17T22:51:43.000000Z"}]},{"id":3710426,"change_date":"2023-08-09 21:43:00","inspection_id":"79370089","dot_number":"2707735","report_state":"CA","report_number":"UF44004235","insp_date":"2023-08-08 00:00:00","insp_start_time":"1610","insp_end_time":"1619","registration_date":null,"region":"PT","ci_status_code":"C","location":"9390","location_desc":"I-680 NB NO MISSION GRADE CVEF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"84740","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15013548","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T19:36:07.000000Z","updated_at":"2025-03-17T19:36:07.000000Z","inspection_violations":[{"id":5721202,"change_date":"2023-08-09 21:43:00","inspection_id":"79370089","insp_violation_id":"254569642","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MA59742","created_at":"2025-03-17T21:33:31.000000Z","updated_at":"2025-03-17T21:33:31.000000Z","normalized_code":"3922"},{"id":5721203,"change_date":"2023-08-09 21:43:00","inspection_id":"79370089","insp_violation_id":"254569643","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"196457422","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"MA59743","created_at":"2025-03-17T21:33:31.000000Z","updated_at":"2025-03-17T21:33:31.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5965830,"change_date":"2023-08-09 21:43:00","inspection_id":"79370089","insp_unit_id":"196457422","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:09.000000Z","updated_at":"2025-03-17T22:50:09.000000Z"}]},{"id":3750436,"change_date":"2023-08-15 21:43:00","inspection_id":"79414495","dot_number":"2707735","report_state":"CA","report_number":"N8MC007152","insp_date":"2023-08-08 00:00:00","insp_start_time":"1111","insp_end_time":"1146","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"15021741","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":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:54.000000Z","updated_at":"2025-03-17T19:36:54.000000Z","inspection_violations":[{"id":5785230,"change_date":"2023-08-15 21:43:00","inspection_id":"79414495","insp_violation_id":"254675519","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196549053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"3963A1"},{"id":5785231,"change_date":"2023-08-15 21:43:00","inspection_id":"79414495","insp_violation_id":"254675520","seq_no":"2","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"196549053","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"39347D"}],"inspection_per_units":[{"id":6030604,"change_date":"2023-08-15 21:43:00","inspection_id":"79414495","insp_unit_id":"196549053","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146\/WHT","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"},{"id":6030605,"change_date":"2023-08-15 21:43:00","inspection_id":"79414495","insp_unit_id":"196549054","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALTE","insp_unit_company":"END DUMP","insp_unit_license":"4TR3945","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3750297,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","dot_number":"2707735","report_state":"CA","report_number":"N5Y3004793","insp_date":"2023-07-27 00:00:00","insp_start_time":"1247","insp_end_time":"1331","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":"SCQ","shipping_paper_number":"272146","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:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15021850","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-15 21:43:00","snet_input_date":"2023-07-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-15 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:54.000000Z","updated_at":"2025-03-17T19:36:54.000000Z","inspection_violations":[{"id":5785158,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_violation_id":"254675444","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196548843","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"39375A3"},{"id":5785159,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_violation_id":"254675445","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"196548844","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"1","created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"39375A3"},{"id":5785160,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_violation_id":"254675446","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196548843","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"3963A1"},{"id":5785161,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_violation_id":"254675447","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"196548843","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"39345"},{"id":5785162,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_violation_id":"254675448","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196548843","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:48.000000Z","updated_at":"2025-03-17T21:33:48.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6030403,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_unit_id":"196548843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146\/WHI","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"},{"id":6030404,"change_date":"2023-08-15 21:43:00","inspection_id":"79414352","insp_unit_id":"196548844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ARMOR","insp_unit_company":"ED06\/WHI","insp_unit_license":"4TR39745","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3739487,"change_date":"2023-08-14 21:43:00","inspection_id":"79402478","dot_number":"2707735","report_state":"CA","report_number":"N5Y3004746","insp_date":"2023-07-19 00:00:00","insp_start_time":"0742","insp_end_time":"0821","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":"GARNEY CONSTRUCTION","shipping_paper_number":"270432","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-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15019512","transaction_code":"A","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-07-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:33.000000Z","updated_at":"2025-03-17T19:36:33.000000Z","inspection_violations":[{"id":5768964,"change_date":"2023-08-14 21:43:00","inspection_id":"79402478","insp_violation_id":"254646958","seq_no":"1","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"196523871","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"1","created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"39345"},{"id":5768965,"change_date":"2023-08-14 21:43:00","inspection_id":"79402478","insp_violation_id":"254646959","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196523872","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:44.000000Z","updated_at":"2025-03-17T21:33:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6013240,"change_date":"2023-08-14 21:43:00","inspection_id":"79402478","insp_unit_id":"196523871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2155\/WHI","insp_unit_license":"9G43391","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XKZD49X9NJ491533","insp_unit_decal":"Y","insp_unit_decal_number":"32915307","created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"},{"id":6013241,"change_date":"2023-08-14 21:43:00","inspection_id":"79402478","insp_unit_id":"196523872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"202\/WHI","insp_unit_license":"4RK5994","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102823KW172960","insp_unit_decal":"Y","insp_unit_decal_number":"32915306","created_at":"2025-03-17T22:50:32.000000Z","updated_at":"2025-03-17T22:50:32.000000Z"}]},{"id":2878055,"change_date":"2023-04-24 21:42:00","inspection_id":"78432628","dot_number":"2707735","report_state":"CA","report_number":"N9ZT004415","insp_date":"2023-04-18 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":null,"region":"PD","ci_status_code":"C","location":"881","location_desc":"LIVERMORE, 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":"N","pen_cen_match":null,"final_status_date":"2023-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"14872064","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-04-24 21:42:00","snet_input_date":"2023-04-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-24 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:44.000000Z","updated_at":"2025-03-17T19:19:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4631091,"change_date":"2023-04-24 21:42:00","inspection_id":"78432628","insp_unit_id":"194555796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"Y","insp_unit_decal_number":"32467717","created_at":"2025-03-17T22:39:32.000000Z","updated_at":"2025-03-17T22:39:32.000000Z"}]},{"id":2832431,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","dot_number":"2707735","report_state":"CA","report_number":"NAGM006502","insp_date":"2023-04-10 00:00:00","insp_start_time":"0733","insp_end_time":"0757","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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14863813","transaction_code":"A","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-04-18 21:42:00","snet_input_date":"2023-04-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T19:18:55.000000Z","updated_at":"2025-03-17T19:18:55.000000Z","inspection_violations":[{"id":4346871,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","insp_violation_id":"252296548","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194456296","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39347E"},{"id":4346872,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","insp_violation_id":"252296549","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194456296","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"39353B"},{"id":4346873,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","insp_violation_id":"252296550","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194456296","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:19.000000Z","updated_at":"2025-03-17T21:27:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4559429,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","insp_unit_id":"194456296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146\/WHT","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:56.000000Z","updated_at":"2025-03-17T22:38:56.000000Z"},{"id":4559430,"change_date":"2023-04-18 21:42:00","inspection_id":"78381042","insp_unit_id":"194456297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALTE","insp_unit_company":"006","insp_unit_license":"4TR3945","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"Y","insp_unit_decal_number":"32547128","created_at":"2025-03-17T22:38:56.000000Z","updated_at":"2025-03-17T22:38:56.000000Z"}]},{"id":2463009,"change_date":"2023-02-27 21:42:00","inspection_id":"77960722","dot_number":"2707735","report_state":"CA","report_number":"N9PI005721","insp_date":"2023-02-23 00:00:00","insp_start_time":"1354","insp_end_time":"1413","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":"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":"2023-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"14799457","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3792917,"change_date":"2023-02-27 21:42:00","inspection_id":"77960722","insp_violation_id":"251370680","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"193609215","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CW471746","created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":3964176,"change_date":"2023-02-27 21:42:00","inspection_id":"77960722","insp_unit_id":"193609215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"WHT 2038","insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2463124,"change_date":"2023-02-27 21:42:00","inspection_id":"77960845","dot_number":"2707735","report_state":"CA","report_number":"NAGM006224","insp_date":"2023-02-23 00:00:00","insp_start_time":"1236","insp_end_time":"1257","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-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"14799887","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2023-02-27 21:42:00","snet_input_date":"2023-02-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:06.000000Z","updated_at":"2025-03-17T19:12:06.000000Z","inspection_violations":[{"id":3793002,"change_date":"2023-02-27 21:42:00","inspection_id":"77960845","insp_violation_id":"251370767","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193609381","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":3964331,"change_date":"2023-02-27 21:42:00","inspection_id":"77960845","insp_unit_id":"193609381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2038\/WHT","insp_unit_license":"76494J3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V5K99EH3HN987046","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":1736781,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","dot_number":"2707735","report_state":"CA","report_number":"NDN6006340","insp_date":"2022-11-09 00:00:00","insp_start_time":"0800","insp_end_time":"0837","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":"2022-11-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14672375","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-11-14 21:43:00","snet_input_date":"2022-11-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-11-14 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[{"id":2720515,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_violation_id":"249592193","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191948655","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"39375A3"},{"id":2720516,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_violation_id":"249592194","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191948656","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"3963A1"},{"id":2720517,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_violation_id":"249592195","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191948656","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"39347E"},{"id":2720518,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_violation_id":"249592196","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191948656","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:50.000000Z","updated_at":"2025-03-17T21:19:50.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":2794567,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_unit_id":"191948655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3X WHITE","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:07.000000Z","updated_at":"2025-03-17T22:26:07.000000Z"},{"id":2794568,"change_date":"2022-11-14 21:43:00","inspection_id":"77130615","insp_unit_id":"191948656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SEMIR","insp_unit_company":"2X ED","insp_unit_license":"4SR6659","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3S9PHBX27JW092034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:07.000000Z","updated_at":"2025-03-17T22:26:07.000000Z"}]},{"id":1071622,"change_date":"2022-08-17 21:41:00","inspection_id":"76361008","dot_number":"2707735","report_state":"CA","report_number":"UDP0003344","insp_date":"2022-08-17 00:00:00","insp_start_time":"0910","insp_end_time":"0923","registration_date":null,"region":"PT","ci_status_code":"C","location":"9266","location_desc":"TRACY","county_code_state":"CA","county_code":"077","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":"2022-08-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"7000","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":"14554184","transaction_code":"A","transaction_date":"2022-08-17 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-08-17 21:41:00","snet_input_date":"2022-08-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-08-17 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T18:46:32.000000Z","updated_at":"2025-03-17T18:46:32.000000Z","inspection_violations":[{"id":1689310,"change_date":"2022-08-17 21:41:00","inspection_id":"76361008","insp_violation_id":"247809119","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1724271,"change_date":"2022-08-17 21:41:00","inspection_id":"76361008","insp_unit_id":"190390186","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2173\/WHT","insp_unit_license":"96218E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPTX40X8MD749195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:52.000000Z","updated_at":"2025-03-17T22:18:52.000000Z"}]},{"id":797118,"change_date":"2022-07-11 21:42:00","inspection_id":"76040030","dot_number":"2707735","report_state":"CA","report_number":"UD8N001831","insp_date":"2022-07-10 00:00:00","insp_start_time":"0600","insp_end_time":"0700","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"S\/OF PLATFORM SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14500888","transaction_code":"A","transaction_date":"2022-07-10 00:00:00","upload_date":"2022-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-07-11 21:42:00","snet_input_date":"2022-07-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-07-11 21:42:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:38.000000Z","updated_at":"2025-03-17T18:41:38.000000Z","inspection_violations":[{"id":1258200,"change_date":"2022-07-11 21:42:00","inspection_id":"76040030","insp_violation_id":"247024285","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:53.000000Z","updated_at":"2025-03-17T21:12:53.000000Z","normalized_code":"3922"},{"id":1258201,"change_date":"2022-07-11 21:42:00","inspection_id":"76040030","insp_violation_id":"247024286","seq_no":"2","part_no":"393","part_no_section":"25(e)","insp_viol_unit":"2","insp_unit_id":"189718647","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CQ035652","created_at":"2025-03-17T21:12:53.000000Z","updated_at":"2025-03-17T21:12:53.000000Z","normalized_code":"39325E"}],"inspection_per_units":[{"id":1282870,"change_date":"2022-07-11 21:42:00","inspection_id":"76040030","insp_unit_id":"189718646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:04.000000Z","updated_at":"2025-03-17T22:16:04.000000Z"},{"id":1282871,"change_date":"2022-07-11 21:42:00","inspection_id":"76040030","insp_unit_id":"189718647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SEMIR","insp_unit_company":null,"insp_unit_license":"4SR6659","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3S9PHBX27JW092034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:04.000000Z","updated_at":"2025-03-17T22:16:04.000000Z"}]},{"id":612439,"change_date":"2022-06-14 21:43:00","inspection_id":"75822859","dot_number":"2707735","report_state":"CA","report_number":"UD4G001638","insp_date":"2022-06-13 00:00:00","insp_start_time":"0830","insp_end_time":"0900","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14468380","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-06-14 21:43:00","snet_input_date":"2022-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-14 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T18:38:27.000000Z","updated_at":"2025-03-17T18:38:27.000000Z","inspection_violations":[{"id":962552,"change_date":"2022-06-14 21:43:00","inspection_id":"75822859","insp_violation_id":"246471016","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"189255283","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"CW844916","created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"39375A3"},{"id":962553,"change_date":"2022-06-14 21:43:00","inspection_id":"75822859","insp_violation_id":"246471017","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189255284","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:32.000000Z","updated_at":"2025-03-17T21:11:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":985147,"change_date":"2022-06-14 21:43:00","inspection_id":"75822859","insp_unit_id":"189255283","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"},{"id":985148,"change_date":"2022-06-14 21:43:00","inspection_id":"75822859","insp_unit_id":"189255284","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESE","insp_unit_company":"202","insp_unit_license":"4RK5994","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1W9102823KW172960","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:16.000000Z","updated_at":"2025-03-17T22:14:16.000000Z"}]},{"id":566783,"change_date":"2022-06-08 21:41:00","inspection_id":"75768496","dot_number":"2707735","report_state":"CA","report_number":"N5Y3003021","insp_date":"2022-05-25 00:00:00","insp_start_time":"1235","insp_end_time":"1254","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"14460131","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-06-08 21:41:00","snet_input_date":"2022-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-06-08 21:41:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:45.000000Z","updated_at":"2025-03-17T18:37:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":911884,"change_date":"2022-06-08 21:41:00","inspection_id":"75768496","insp_unit_id":"189125308","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2173\/WHI","insp_unit_license":"96218E3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1NPTX40X8MD749195","insp_unit_decal":"Y","insp_unit_decal_number":"31183421","created_at":"2025-03-17T22:13:49.000000Z","updated_at":"2025-03-17T22:13:49.000000Z"}]},{"id":411978,"change_date":"2022-05-17 21:43:00","inspection_id":"75584403","dot_number":"2707735","report_state":"CA","report_number":"UCSZ000882","insp_date":"2022-05-17 00:00:00","insp_start_time":"1003","insp_end_time":"1026","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","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":"14431312","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-05-17 21:43:00","snet_input_date":"2022-05-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[{"id":645235,"change_date":"2022-05-17 21:43:00","inspection_id":"75584403","insp_violation_id":"245860244","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"214","created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":665408,"change_date":"2022-05-17 21:43:00","inspection_id":"75584403","insp_unit_id":"188742017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"2146","insp_unit_license":"9G10273","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1XPCD49X8LD693114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"},{"id":665409,"change_date":"2022-05-17 21:43:00","inspection_id":"75584403","insp_unit_id":"188742018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALTE","insp_unit_company":"ED06","insp_unit_license":"4TR3945","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"56EA75A29NA000168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":372810,"change_date":"2022-05-11 21:40:00","inspection_id":"75537323","dot_number":"2707735","report_state":"CA","report_number":"NBIJ002686","insp_date":"2022-05-10 00:00:00","insp_start_time":"0911","insp_end_time":"0937","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-11 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":"14422774","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02707735","upload_search_indicator":null,"census_search_date":"2022-05-11 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"ADVANCED TRUCKING LLC","insp_carrier_street":"1852 WEST 11TH ST #243","insp_carrier_city":"TRACY","insp_carrier_state":"CA","insp_carrier_zip_code":"95376","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"437498","created_at":"2025-03-17T18:34:01.000000Z","updated_at":"2025-03-17T18:34:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":603147,"change_date":"2022-05-11 21:40:00","inspection_id":"75537323","insp_unit_id":"188640001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2182","insp_unit_license":"9G03463","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH2LN264770","insp_unit_decal":"Y","insp_unit_decal_number":"31096844","created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"},{"id":603148,"change_date":"2022-05-11 21:40:00","inspection_id":"75537323","insp_unit_id":"188640002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SEMIR","insp_unit_company":null,"insp_unit_license":"4SR6659","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3S9PHBX27JW092034","insp_unit_decal":"Y","insp_unit_decal_number":"31096845","created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2707735\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2707735\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2707735\/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\/2707735\/inspections","per_page":100,"prev_page_url":null,"to":48,"total":48}