{"current_page":1,"data":[{"id":6671279,"change_date":"2024-09-07 21:32:00","inspection_id":"82601064","dot_number":"3474590","report_state":"TN","report_number":"I033AL0901","insp_date":"2024-09-05 00:00:00","insp_start_time":"1425","insp_end_time":"1525","registration_date":null,"region":"CD","ci_status_code":"C","location":"SHELBY","location_desc":"MEMPHIS TN","county_code_state":"TN","county_code":"157","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IPPOLITO INTERNATIONAL","shipping_paper_number":"1179740","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":"U","pen_cen_match":"I","final_status_date":"2024-09-07 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"823209","transaction_code":"A","transaction_date":"2024-09-07 00:00:00","upload_date":"2024-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2024-09-07 21:32:00","snet_input_date":"2024-09-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-07 21:32:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:14.000000Z","updated_at":"2025-03-17T20:35:14.000000Z","inspection_violations":[{"id":10382028,"change_date":"2024-09-07 21:32:00","inspection_id":"82601064","insp_violation_id":"261669976","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:56:18.000000Z","updated_at":"2025-03-17T21:56:18.000000Z","normalized_code":"3922"},{"id":10382029,"change_date":"2024-09-07 21:32:00","inspection_id":"82601064","insp_violation_id":"261669977","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:56:18.000000Z","updated_at":"2025-03-17T21:56:18.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10756239,"change_date":"2024-09-07 21:32:00","inspection_id":"82601064","insp_unit_id":"202809096","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"111","insp_unit_license":"ZP05328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDRXGSGZ3193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:23.000000Z","updated_at":"2025-03-17T23:34:23.000000Z"},{"id":10756240,"change_date":"2024-09-07 21:32:00","inspection_id":"82601064","insp_unit_id":"202809097","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:23.000000Z","updated_at":"2025-03-17T23:34:23.000000Z"}]},{"id":5580576,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","dot_number":"3474590","report_state":"TN","report_number":"I5Z1910170","insp_date":"2024-04-18 00:00:00","insp_start_time":"0800","insp_end_time":"0845","registration_date":null,"region":"ED","ci_status_code":"C","location":"GRENS","location_desc":"MOHAWK TN","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"BOSTON SWORD & TUNA","shipping_paper_number":"396244","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":"U","pen_cen_match":"I","final_status_date":"2024-04-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"422312","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2024-04-24 21:40:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-24 21:40:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:27.000000Z","updated_at":"2025-03-17T20:13:27.000000Z","inspection_violations":[{"id":8626824,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_violation_id":"259095048","seq_no":"1","part_no":"392","part_no_section":"2","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:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3922"},{"id":8626825,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_violation_id":"259095049","seq_no":"2","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:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3922"},{"id":8626826,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_violation_id":"259095050","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3958E1"},{"id":8626827,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_violation_id":"259095051","seq_no":"4","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":8989278,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_unit_id":"200539786","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"007","insp_unit_license":"RP07899","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:37.000000Z","updated_at":"2025-03-17T23:16:37.000000Z"},{"id":8989279,"change_date":"2024-04-24 21:40:00","inspection_id":"81426815","insp_unit_id":"200539787","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:37.000000Z","updated_at":"2025-03-17T23:16:37.000000Z"}]},{"id":4507325,"change_date":"2023-11-28 21:41:00","inspection_id":"80253919","dot_number":"3474590","report_state":"TN","report_number":"TFBU000194","insp_date":"2023-11-27 00:00:00","insp_start_time":"2206","insp_end_time":"2223","registration_date":null,"region":"CT","ci_status_code":"C","location":"95","location_desc":"ROADSIDE","county_code_state":"TN","county_code":"189","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"B192860","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"1691958","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-28 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"PO BOX 1362","insp_carrier_city":"RIPON","insp_carrier_state":"CA","insp_carrier_zip_code":"95366","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:11.000000Z","updated_at":"2025-03-17T19:52:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7249114,"change_date":"2023-11-28 21:41:00","inspection_id":"80253919","insp_unit_id":"198241566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"ZP05328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDRXGSGZ3193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:52.000000Z","updated_at":"2025-03-17T23:00:52.000000Z"},{"id":7249115,"change_date":"2023-11-28 21:41:00","inspection_id":"80253919","insp_unit_id":"198241567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5015","insp_unit_license":"4UL6612","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0620GW703444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:52.000000Z","updated_at":"2025-03-17T23:00:52.000000Z"}]},{"id":4447768,"change_date":"2023-11-16 21:44:00","inspection_id":"80188431","dot_number":"3474590","report_state":"CA","report_number":"UE5Z006271","insp_date":"2023-11-16 00:00:00","insp_start_time":"0550","insp_end_time":"0610","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"210 EB EO SUNLAND BLVD","county_code_state":"CA","county_code":"037","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-11-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15136841","transaction_code":"A","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-11-16 21:44:00","snet_input_date":"2023-11-16 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-11-16 21:44:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:03.000000Z","updated_at":"2025-03-17T19:51:03.000000Z","inspection_violations":[{"id":6884746,"change_date":"2023-11-16 21:44:00","inspection_id":"80188431","insp_violation_id":"256453301","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:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"3922"},{"id":6884747,"change_date":"2023-11-16 21:44:00","inspection_id":"80188431","insp_violation_id":"256453302","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"49","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:13.000000Z","updated_at":"2025-03-17T21:39:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7153025,"change_date":"2023-11-16 21:44:00","inspection_id":"80188431","insp_unit_id":"198112293","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111","insp_unit_license":"ZP05328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDRXGSGZ3193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:03.000000Z","updated_at":"2025-03-17T23:00:03.000000Z"},{"id":7153026,"change_date":"2023-11-16 21:44:00","inspection_id":"80188431","insp_unit_id":"198112294","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1888","insp_unit_license":"4UE5192","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3H3V532K0NS018167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:03.000000Z","updated_at":"2025-03-17T23:00:03.000000Z"}]},{"id":4024788,"change_date":"2023-09-21 21:41:00","inspection_id":"79720283","dot_number":"3474590","report_state":"UT","report_number":"23JE000614","insp_date":"2023-09-20 00:00:00","insp_start_time":"1630","insp_end_time":"1700","registration_date":null,"region":"MT","ci_status_code":"C","location":"POE S","location_desc":"ST GEORGE PORT OF ENTRY SB","county_code_state":"UT","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SCHREIBER","shipping_paper_number":"716361","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-21 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":"896298","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-09-21 21:41:00","snet_input_date":"2023-09-20 00:00:00","source_office":"4UTS001","mcmis_add_date":"2023-09-21 21:41:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:23.000000Z","updated_at":"2025-03-17T19:42:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6471635,"change_date":"2023-09-21 21:41:00","inspection_id":"79720283","insp_unit_id":"197169689","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"111","insp_unit_license":"ZP05328","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJGLDRXGXGSGZ31","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:19.000000Z","updated_at":"2025-03-17T22:54:19.000000Z"},{"id":6471636,"change_date":"2023-09-21 21:41:00","inspection_id":"79720283","insp_unit_id":"197169690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"5015","insp_unit_license":"4UL6612","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1GRAA0620GW703444","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:19.000000Z","updated_at":"2025-03-17T22:54:19.000000Z"}]},{"id":3816540,"change_date":"2023-08-23 21:41:00","inspection_id":"79488354","dot_number":"3474590","report_state":"CA","report_number":"NELC000864","insp_date":"2023-08-13 00:00:00","insp_start_time":"1259","insp_end_time":"1315","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOAM RECOVERY LLC","shipping_paper_number":"3168","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15032698","transaction_code":"A","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-08-23 21:41:00","snet_input_date":"2023-08-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-23 21:41:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:06.000000Z","updated_at":"2025-03-17T19:38:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6136545,"change_date":"2023-08-23 21:41:00","inspection_id":"79488354","insp_unit_id":"196696502","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLU","insp_unit_license":"RP07899","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"Y","insp_unit_decal_number":"32836970","created_at":"2025-03-17T22:51:34.000000Z","updated_at":"2025-03-17T22:51:34.000000Z"},{"id":6136546,"change_date":"2023-08-23 21:41:00","inspection_id":"79488354","insp_unit_id":"196696503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"334263\/WHT","insp_unit_license":"063495T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3H3V532C5LR121176","insp_unit_decal":"Y","insp_unit_decal_number":"32836971","created_at":"2025-03-17T22:51:34.000000Z","updated_at":"2025-03-17T22:51:34.000000Z"}]},{"id":3709455,"change_date":"2023-08-09 21:43:00","inspection_id":"79369040","dot_number":"3474590","report_state":"CA","report_number":"NC0J004762","insp_date":"2023-07-28 00:00:00","insp_start_time":"1736","insp_end_time":"1752","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRANCISCO RIOS","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-09 21:43: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":"15014510","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-07-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:07.000000Z","updated_at":"2025-03-17T19:36:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5964350,"change_date":"2023-08-09 21:43:00","inspection_id":"79369040","insp_unit_id":"196455776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLUE","insp_unit_license":"RP07899","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"Y","insp_unit_decal_number":"32836402","created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5964351,"change_date":"2023-08-09 21:43:00","inspection_id":"79369040","insp_unit_id":"196455777","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"V23032\/WHT","insp_unit_license":"97L8XS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GR1P0623PJ448767","insp_unit_decal":"Y","insp_unit_decal_number":"32836403","created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3579548,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","dot_number":"3474590","report_state":"MO","report_number":"GT02002303","insp_date":"2023-07-21 00:00:00","insp_start_time":"1334","insp_end_time":"1409","registration_date":null,"region":"CT","ci_status_code":"C","location":"G60","location_desc":"US 60 WEST OF RT AM","county_code_state":"MO","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BRUCE PACKING COMPANY","shipping_paper_number":"289039","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2085176","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"PO BOX 8017","insp_carrier_city":"COVINGTON","insp_carrier_state":"WA","insp_carrier_zip_code":"98042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:36.000000Z","updated_at":"2025-03-17T19:33:36.000000Z","inspection_violations":[{"id":5518996,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_violation_id":"254240125","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","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:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3958A1"},{"id":5518997,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_violation_id":"254240126","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196160622","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39021TB"},{"id":5518998,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_violation_id":"254240127","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196160622","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"},{"id":5518999,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_violation_id":"254240128","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":5755655,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_unit_id":"196160622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"94960RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLDRXGSGZ3193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"},{"id":5755656,"change_date":"2023-07-24 21:42:00","inspection_id":"79223516","insp_unit_id":"196160623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"}]},{"id":3782041,"change_date":"2023-08-18 21:42:00","inspection_id":"79449790","dot_number":"3474590","report_state":"CA","report_number":"NDZX001606","insp_date":"2023-07-20 00:00:00","insp_start_time":"1801","insp_end_time":"1819","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ARDAGH GLASS","shipping_paper_number":"7887479","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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15027360","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-08-18 21:42:00","snet_input_date":"2023-07-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-18 21:42:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:38.000000Z","updated_at":"2025-03-17T19:37:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6081142,"change_date":"2023-08-18 21:42:00","inspection_id":"79449790","insp_unit_id":"196619734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"502\/BLU","insp_unit_license":"RP07899","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"Y","insp_unit_decal_number":"32835302","created_at":"2025-03-17T22:51:06.000000Z","updated_at":"2025-03-17T22:51:06.000000Z"},{"id":6081143,"change_date":"2023-08-18 21:42:00","inspection_id":"79449790","insp_unit_id":"196619735","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"WHT","insp_unit_license":"97L8XS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GR1P0623PJ448767","insp_unit_decal":"Y","insp_unit_decal_number":"32835303","created_at":"2025-03-17T22:51:06.000000Z","updated_at":"2025-03-17T22:51:06.000000Z"}]},{"id":3513228,"change_date":"2023-07-14 21:41:00","inspection_id":"79148990","dot_number":"3474590","report_state":"WA","report_number":"A401000627","insp_date":"2023-07-13 00:00:00","insp_start_time":"1241","insp_end_time":"1311","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"SPOKANE VALLEY","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2581642","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"PO BOX 8017","insp_carrier_city":"COVINGTON","insp_carrier_state":"WA","insp_carrier_zip_code":"98042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:29.000000Z","updated_at":"2025-03-17T19:32:29.000000Z","inspection_violations":[{"id":5417008,"change_date":"2023-07-14 21:41:00","inspection_id":"79148990","insp_violation_id":"254073116","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":"3A0112820","created_at":"2025-03-17T21:32:08.000000Z","updated_at":"2025-03-17T21:32:08.000000Z","normalized_code":"3922"},{"id":5417009,"change_date":"2023-07-14 21:41:00","inspection_id":"79148990","insp_violation_id":"254073117","seq_no":"2","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:08.000000Z","updated_at":"2025-03-17T21:32:08.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":5649246,"change_date":"2023-07-14 21:41:00","inspection_id":"79148990","insp_unit_id":"196011319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"94969RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"3AKJGLDRXGSGZ3193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"},{"id":5649247,"change_date":"2023-07-14 21:41:00","inspection_id":"79148990","insp_unit_id":"196011320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3540094,"change_date":"2023-07-18 21:43:00","inspection_id":"79179021","dot_number":"3474590","report_state":"CA","report_number":"NELC000766","insp_date":"2023-07-13 00:00:00","insp_start_time":"1401","insp_end_time":"1435","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOAM RECOVERY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14988038","transaction_code":"A","transaction_date":"2023-07-13 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-07-18 21:43:00","snet_input_date":"2023-07-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-07-18 21:43:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"29228 123RD PL SE","insp_carrier_city":"AUBURN","insp_carrier_state":"WA","insp_carrier_zip_code":"98092","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:06.000000Z","updated_at":"2025-03-17T19:33:06.000000Z","inspection_violations":[{"id":5458218,"change_date":"2023-07-18 21:43:00","inspection_id":"79179021","insp_violation_id":"254140061","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196070868","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:18.000000Z","updated_at":"2025-03-17T21:32:18.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":5692186,"change_date":"2023-07-18 21:43:00","inspection_id":"79179021","insp_unit_id":"196070868","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLU","insp_unit_license":"RP07899","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"},{"id":5692187,"change_date":"2023-07-18 21:43:00","inspection_id":"79179021","insp_unit_id":"196070869","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"23032\/WHT","insp_unit_license":"97L8XS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GR1P0623PJ448767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:55.000000Z","updated_at":"2025-03-17T22:47:55.000000Z"}]},{"id":2750559,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","dot_number":"3474590","report_state":"ND","report_number":"TR82001129","insp_date":"2023-04-05 00:00:00","insp_start_time":"1203","insp_end_time":"1242","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE- CUMMINGS, ND","county_code_state":"ND","county_code":"097","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NONE","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":"I","final_status_date":"2023-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"369407","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":"M","census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-05 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"PO BOX 8017","insp_carrier_city":"COVINGTON","insp_carrier_state":"WA","insp_carrier_zip_code":"98042","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[{"id":4221924,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","insp_violation_id":"252088513","seq_no":"1","part_no":"395","part_no_section":"26(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"39526B"},{"id":4221925,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","insp_violation_id":"252088514","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"3922"},{"id":4221926,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","insp_violation_id":"252088515","seq_no":"3","part_no":"392","part_no_section":"14","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:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"39214"}],"inspection_per_units":[{"id":4427159,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","insp_unit_id":"194265526","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:51.000000Z","updated_at":"2025-03-17T22:37:51.000000Z"},{"id":4427160,"change_date":"2023-04-06 21:40:00","inspection_id":"78288538","insp_unit_id":"194265527","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"348947","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1JJV532W17L026892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:51.000000Z","updated_at":"2025-03-17T22:37:51.000000Z"}]},{"id":2154395,"change_date":"2023-01-17 21:42:00","inspection_id":"77609110","dot_number":"3474590","report_state":"TN","report_number":"TCME000444","insp_date":"2023-01-16 00:00:00","insp_start_time":"0100","insp_end_time":"0145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-81","county_code_state":"TN","county_code":"163","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CALIFORNIA FAMILY FOODS","shipping_paper_number":"0228511","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":"Y","pen_cen_match":"I","final_status_date":"2023-01-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1623275","transaction_code":"A","transaction_date":"2023-01-16 00:00:00","upload_date":"2023-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2023-01-17 21:42:00","snet_input_date":"2023-01-16 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-01-17 21:42:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:17.000000Z","updated_at":"2025-03-17T19:06:17.000000Z","inspection_violations":[{"id":3329883,"change_date":"2023-01-17 21:42:00","inspection_id":"77609110","insp_violation_id":"250599055","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":"WRITTEN WARNING","created_at":"2025-03-17T21:22:45.000000Z","updated_at":"2025-03-17T21:22:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3466567,"change_date":"2023-01-17 21:42:00","inspection_id":"77609110","insp_unit_id":"192897630","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007","insp_unit_license":"85799RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"},{"id":3466568,"change_date":"2023-01-17 21:42:00","inspection_id":"77609110","insp_unit_id":"192897631","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"V23032","insp_unit_license":"97L8XS","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GR1P0623PJ448767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:52.000000Z","updated_at":"2025-03-17T22:30:52.000000Z"}]},{"id":1890456,"change_date":"2022-12-07 21:40:00","inspection_id":"77306803","dot_number":"3474590","report_state":"MO","report_number":"00SB008820","insp_date":"2022-12-06 00:00:00","insp_start_time":"0955","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"C55","location_desc":"I 55 SB\/ S BROADWAY","county_code_state":"MO","county_code":"510","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","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":"Y","pen_cen_match":"I","final_status_date":"2022-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"2047376","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":"M","census_search_date":"2022-12-07 21:40:00","snet_input_date":"2022-12-07 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-12-07 21:40:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:30.000000Z","updated_at":"2025-03-17T19:01:30.000000Z","inspection_violations":[{"id":2940722,"change_date":"2022-12-07 21:40:00","inspection_id":"77306803","insp_violation_id":"249967366","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:21:02.000000Z","updated_at":"2025-03-17T21:21:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3042507,"change_date":"2022-12-07 21:40:00","inspection_id":"77306803","insp_unit_id":"192303933","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"008","insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:50.000000Z","updated_at":"2025-03-17T22:27:50.000000Z"}]},{"id":1713527,"change_date":"2022-11-10 21:38:00","inspection_id":"77103920","dot_number":"3474590","report_state":"AR","report_number":"C574004289","insp_date":"2022-11-10 00:00:00","insp_start_time":"0245","insp_end_time":"0335","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"GRIMMWATY FARMS","shipping_paper_number":"45557381","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":"I","final_status_date":"2022-11-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1428871","transaction_code":"A","transaction_date":"2022-11-10 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":"M","census_search_date":"2022-11-10 21:38:00","snet_input_date":"2022-11-10 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-11-10 21:38:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:13.000000Z","updated_at":"2025-03-17T18:58:13.000000Z","inspection_violations":[{"id":2686231,"change_date":"2022-11-10 21:38:00","inspection_id":"77103920","insp_violation_id":"249536873","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":"400A371917","created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"3922"},{"id":2686232,"change_date":"2022-11-10 21:38:00","inspection_id":"77103920","insp_violation_id":"249536874","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191897050","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:39.000000Z","updated_at":"2025-03-17T21:19:39.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":2756513,"change_date":"2022-11-10 21:38:00","inspection_id":"77103920","insp_unit_id":"191897050","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"008","insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:52.000000Z","updated_at":"2025-03-17T22:25:52.000000Z"},{"id":2756514,"change_date":"2022-11-10 21:38:00","inspection_id":"77103920","insp_unit_id":"191897051","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:52.000000Z","updated_at":"2025-03-17T22:25:52.000000Z"}]},{"id":1099991,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","dot_number":"3474590","report_state":"MT","report_number":"H669000476","insp_date":"2022-08-20 00:00:00","insp_start_time":"1255","insp_end_time":"1519","registration_date":null,"region":"MT","ci_status_code":"C","location":"0669","location_desc":"BILLINGS WB INSPECTION FACILIT","county_code_state":"MT","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MOUNTAIRE FARMS OF SILER CITY","shipping_paper_number":"1971569","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"967806","transaction_code":"A","transaction_date":"2022-08-20 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-22 00:00:00","source_office":"4MTS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1732263,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888883","seq_no":"10","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3929A2"},{"id":1732264,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888884","seq_no":"1","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3953A2"},{"id":1732265,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888885","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"530A159122M","created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3958E1"},{"id":1732266,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888886","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190459363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3939A"},{"id":1732267,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888887","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39347E"},{"id":1732268,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888888","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39353B"},{"id":1732269,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888889","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3963A1"},{"id":1732270,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888890","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39348A"},{"id":1732271,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888891","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"39348A"},{"id":1732272,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_violation_id":"247888892","seq_no":"9","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"2","insp_unit_id":"190459364","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":1769300,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_unit_id":"190459363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLU","insp_unit_license":"85799RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1769301,"change_date":"2022-08-22 21:42:00","inspection_id":"76394572","insp_unit_id":"190459364","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":698878,"change_date":"2022-06-27 21:40:00","inspection_id":"75925365","dot_number":"3474590","report_state":"AZ","report_number":"0262004268","insp_date":"2022-06-24 00:00:00","insp_start_time":"0935","insp_end_time":"1050","registration_date":null,"region":"MT","ci_status_code":"C","location":"SR87","location_desc":"STATE ROUTE 87","county_code_state":"AZ","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"I","final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1755527","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-27 00:00:00","source_office":"4AZS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:53.000000Z","updated_at":"2025-03-17T18:39:53.000000Z","inspection_violations":[{"id":1097441,"change_date":"2022-06-27 21:40:00","inspection_id":"75925365","insp_violation_id":"246731763","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3958E1"},{"id":1097442,"change_date":"2022-06-27 21:40:00","inspection_id":"75925365","insp_violation_id":"246731764","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189474961","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":1122983,"change_date":"2022-06-27 21:40:00","inspection_id":"75925365","insp_unit_id":"189474961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"008","insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1122984,"change_date":"2022-06-27 21:40:00","inspection_id":"75925365","insp_unit_id":"189474962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":371016,"change_date":"2022-05-11 21:40:00","inspection_id":"75535275","dot_number":"3474590","report_state":"WA","report_number":"W109011815","insp_date":"2022-05-10 00:00:00","insp_start_time":"1132","insp_end_time":"1158","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"24TH ST TO SB RAMP","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SAPUTO CHEESE USA INC","shipping_paper_number":"2850414410","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":"I","final_status_date":"2022-05-11 21:40: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":"2493961","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":"03474590","upload_search_indicator":null,"census_search_date":"2022-05-11 21:40:00","snet_input_date":"2022-05-11 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:00.000000Z","updated_at":"2025-03-17T18:34:00.000000Z","inspection_violations":[{"id":581535,"change_date":"2022-05-11 21:40:00","inspection_id":"75535275","insp_violation_id":"245733899","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188635952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"3922"},{"id":581536,"change_date":"2022-05-11 21:40:00","inspection_id":"75535275","insp_violation_id":"245733900","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"188635952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:47.000000Z","updated_at":"2025-03-17T21:09:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":600310,"change_date":"2022-05-11 21:40:00","inspection_id":"75535275","insp_unit_id":"188635951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLU","insp_unit_license":"85799RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"},{"id":600311,"change_date":"2022-05-11 21:40:00","inspection_id":"75535275","insp_unit_id":"188635952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2520\/WHT","insp_unit_license":"348947TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1JJV532W17L026892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:53.000000Z","updated_at":"2025-03-17T22:11:53.000000Z"}]},{"id":361949,"change_date":"2022-05-10 21:41:00","inspection_id":"75524577","dot_number":"3474590","report_state":"TX","report_number":"6ALA9DEPJY","insp_date":"2022-05-02 00:00:00","insp_start_time":"1015","insp_end_time":"1045","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"500 S COTTON ST","county_code_state":"TX","county_code":"141","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SANDHU TRANSPORT SERVICE","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":"Y","pen_cen_match":null,"final_status_date":"2022-05-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8649949","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":"M","census_search_date":"2022-05-10 21:41:00","snet_input_date":"2022-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-10 21:41:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026713","created_at":"2025-03-17T18:33:57.000000Z","updated_at":"2025-03-17T18:33:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":585535,"change_date":"2022-05-10 21:41:00","inspection_id":"75524577","insp_unit_id":"188615554","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"008","insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"},{"id":585536,"change_date":"2022-05-10 21:41:00","inspection_id":"75524577","insp_unit_id":"188615555","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:48.000000Z","updated_at":"2025-03-17T22:11:48.000000Z"}]},{"id":181838,"change_date":"2022-04-14 21:43:00","inspection_id":"75309941","dot_number":"3474590","report_state":"CA","report_number":"NBTJ003161","insp_date":"2022-04-13 00:00:00","insp_start_time":"1655","insp_end_time":"1703","registration_date":null,"region":"PT","ci_status_code":"C","location":"147","location_desc":"DUNSMUIR GRADE IF","county_code_state":"CA","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HALFON CANDY","shipping_paper_number":"20441979","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14386957","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2022-04-14 21:43:00","snet_input_date":"2022-04-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2022-04-14 21:43:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:49.000000Z","updated_at":"2025-03-17T18:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":294852,"change_date":"2022-04-14 21:43:00","inspection_id":"75309941","insp_unit_id":"188169400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"007\/BLU","insp_unit_license":"85799RP","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"4V4NC9EH3JN999402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:58.000000Z","updated_at":"2025-03-17T22:09:58.000000Z"},{"id":294853,"change_date":"2022-04-14 21:43:00","inspection_id":"75309941","insp_unit_id":"188169401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2520\/WHT","insp_unit_license":"348947TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1JJV532W17L026892","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:58.000000Z","updated_at":"2025-03-17T22:09:58.000000Z"}]},{"id":12638,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","dot_number":"3474590","report_state":"WA","report_number":"W739000042","insp_date":"2022-03-17 00:00:00","insp_start_time":"1605","insp_end_time":"1635","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC54","location_desc":"SC54   PLYMOUTH (POE)","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"C AND L FARMS","shipping_paper_number":"94430","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":"I","final_status_date":"2022-03-21 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2481130","transaction_code":"A","transaction_date":"2022-03-20 00:00:00","upload_date":"2022-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03474590","upload_search_indicator":null,"census_search_date":"2022-03-21 21:32:00","snet_input_date":"2022-03-21 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-03-21 21:32:00","insp_carrier_name":"SANDHU TRANSPORT SERVICE INC","insp_carrier_street":"12310 S 254TH STREET","insp_carrier_city":"KENT","insp_carrier_state":"WA","insp_carrier_zip_code":"98030","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:46.000000Z","updated_at":"2025-03-17T18:27:46.000000Z","inspection_violations":[{"id":17300,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_violation_id":"244679540","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187733252","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"3922"},{"id":17301,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_violation_id":"244679541","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187733252","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"3939A"},{"id":17302,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_violation_id":"244679542","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"187733253","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"3939A"},{"id":17303,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_violation_id":"244679543","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"187733253","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"39375A1"},{"id":17304,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_violation_id":"244679544","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"187733253","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":20628,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_unit_id":"187733252","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"008","insp_unit_license":"XP54421","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"4V4NC9EH6KN899196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:23.000000Z","updated_at":"2025-03-17T22:08:23.000000Z"},{"id":20629,"change_date":"2022-03-21 21:32:00","inspection_id":"75096097","insp_unit_id":"187733253","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"146","insp_unit_license":"4SE5310","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1UYVS2536DU494315","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:23.000000Z","updated_at":"2025-03-17T22:08:23.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3474590\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3474590\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3474590\/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\/3474590\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}