{"current_page":1,"data":[{"id":11215218,"change_date":"2026-02-24 21:40:00","inspection_id":"87126662","dot_number":"415459","report_state":"SD","report_number":"5430002444","insp_date":"2026-02-24 00:00:00","insp_start_time":"0901","insp_end_time":"0930","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"BERESFORD SD","county_code_state":"SD","county_code":"127","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-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22360","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":"2926891","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2026-02-24 21:40:00","snet_input_date":"2026-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-24 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 HWY 7","insp_carrier_city":"SAINT LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:38:04.000000Z","updated_at":"2026-03-07T10:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19157043,"change_date":"2026-02-24 21:40:00","inspection_id":"87126662","insp_unit_id":"211788239","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:21.000000Z","updated_at":"2026-03-07T10:03:24.000000Z"}]},{"id":10650113,"change_date":"2026-01-14 21:40:00","inspection_id":"86791954","dot_number":"415459","report_state":"IA","report_number":"000P13X6CK","insp_date":"2026-01-13 00:00:00","insp_start_time":"1110","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1387275","transaction_code":"A","transaction_date":"2026-01-14 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-01-14 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 HWY 7","insp_carrier_city":"SAINT LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-17T10:36:33.000000Z","updated_at":"2026-01-25T10:30:54.000000Z","inspection_violations":[{"id":17919717,"change_date":"2026-01-14 21:40:00","inspection_id":"86791954","insp_violation_id":"271203028","seq_no":"1","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"211086019","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-17T10:43:42.000000Z","updated_at":"2026-01-25T10:31:19.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":17867687,"change_date":"2026-01-14 21:40:00","inspection_id":"86791954","insp_unit_id":"211086019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-17T10:09:09.000000Z","updated_at":"2026-01-25T10:01:04.000000Z"}]},{"id":10567443,"change_date":"2026-01-05 21:37:00","inspection_id":"86705118","dot_number":"415459","report_state":"SD","report_number":"5280002377","insp_date":"2026-01-05 00:00:00","insp_start_time":"0909","insp_end_time":"0948","registration_date":null,"region":"CS","ci_status_code":"C","location":"MM 102","location_desc":"DELL RAPIDS SD","county_code_state":"SD","county_code":"101","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOWELLS FAB","shipping_paper_number":"NA","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-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"2724545","transaction_code":"A","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2026-01-05 21:37:00","snet_input_date":"2026-01-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 HWY 7","insp_carrier_city":"SAINT LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-08T10:34:18.000000Z","updated_at":"2026-01-16T10:30:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17706784,"change_date":"2026-01-05 21:37:00","inspection_id":"86705118","insp_unit_id":"210907888","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"NA","insp_unit_license":"43X676","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1S9FG2624BW334D19","insp_unit_decal":"Y","insp_unit_decal_number":"35816021","created_at":"2026-01-08T10:05:40.000000Z","updated_at":"2026-01-16T10:00:27.000000Z"},{"id":17706783,"change_date":"2026-01-05 21:37:00","inspection_id":"86705118","insp_unit_id":"210907887","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"NA","insp_unit_license":"43460D","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1GC0YLE72RF308037","insp_unit_decal":"Y","insp_unit_decal_number":"35816017","created_at":"2026-01-08T10:05:40.000000Z","updated_at":"2026-01-16T10:00:27.000000Z"}]},{"id":10460311,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","dot_number":"415459","report_state":"KS","report_number":"HP93426352","insp_date":"2025-12-15 00:00:00","insp_start_time":"0729","insp_end_time":"0815","registration_date":"2025-12-22 00:00:00","region":"CS","ci_status_code":"C","location":"#24W","location_desc":"KS","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"S5069448","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2689070","transaction_code":"C","transaction_date":"2025-12-22 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 HWY 7","insp_carrier_city":"SAINT LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:45.000000Z","updated_at":"2026-01-02T10:30:09.000000Z","inspection_violations":[{"id":17607940,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","insp_violation_id":"270833925","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"210746516","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:25.000000Z","updated_at":"2026-01-02T10:30:22.000000Z","normalized_code":"39617CPI"},{"id":17607941,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","insp_violation_id":"270833926","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"210746516","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:25.000000Z","updated_at":"2026-01-02T10:30:22.000000Z","normalized_code":"39021TB1MC"},{"id":17607942,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","insp_violation_id":"270833927","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-25T10:42:25.000000Z","updated_at":"2026-01-02T10:30:22.000000Z","normalized_code":"3922SLLEWA3"},{"id":17607943,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","insp_violation_id":"270833928","seq_no":"2","part_no":"391","part_no_section":"41APC","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-12-25T10:42:25.000000Z","updated_at":"2026-01-02T10:30:22.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17565870,"change_date":"2025-12-22 21:38:00","inspection_id":"86593233","insp_unit_id":"210746516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"00J7SM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALHG3FM8RDVG0590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-25T10:08:35.000000Z","updated_at":"2026-01-02T10:00:13.000000Z"}]},{"id":10073008,"change_date":"2025-10-30 21:41:00","inspection_id":"86186838","dot_number":"415459","report_state":"MN","report_number":"0188000058","insp_date":"2025-10-23 00:00:00","insp_start_time":"1008","insp_end_time":"1031","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAPLE GROVE MN","county_code_state":"MN","county_code":"053","insp_level_id":"1","service_center":"MW","census_source_id":"5","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":"U","pen_cen_match":"I","final_status_date":"2025-10-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","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":"2475357","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-10-30 21:41:00","snet_input_date":"2025-10-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 HWY 7","insp_carrier_city":"SAINT LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:01:51.000000Z","updated_at":"2025-11-03T11:00:07.000000Z","inspection_violations":[{"id":16681345,"change_date":"2025-10-30 21:41:00","inspection_id":"86186838","insp_violation_id":"269607444","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-11-02T11:17:39.000000Z","updated_at":"2025-11-03T11:15:14.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":16743071,"change_date":"2025-10-30 21:41:00","inspection_id":"86186838","insp_unit_id":"209730666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"8888","insp_unit_license":"YCG0823","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDNF7DE7SDF03888","insp_unit_decal":"Y","insp_unit_decal_number":"35791330","created_at":"2025-11-02T10:47:17.000000Z","updated_at":"2025-11-03T10:45:10.000000Z"}]},{"id":9795827,"change_date":"2025-09-27 21:33:00","inspection_id":"85894955","dot_number":"415459","report_state":"WI","report_number":"2259009379","insp_date":"2025-09-24 00:00:00","insp_start_time":"0827","insp_end_time":"0849","registration_date":null,"region":"CD","ci_status_code":"C","location":"S35","location_desc":"NEWTON WI","county_code_state":"WI","county_code":"071","insp_level_id":"2","service_center":"MW","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":"2025-09-27 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"1","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":"2334503","transaction_code":"A","transaction_date":"2025-09-26 00:00:00","upload_date":"2025-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-09-27 21:33:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-27 21:33:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:13.000000Z","updated_at":"2025-10-01T10:00:06.000000Z","inspection_violations":[{"id":16110159,"change_date":"2025-09-27 21:33:00","inspection_id":"85894955","insp_violation_id":"268958883","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209179500","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:59.000000Z","updated_at":"2025-10-01T10:15:09.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16234342,"change_date":"2025-09-27 21:33:00","inspection_id":"85894955","insp_unit_id":"209179500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"2","insp_unit_license":"95032Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"5KKMAXDV3GLHE6560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-30T09:46:03.000000Z","updated_at":"2025-10-01T09:45:06.000000Z"}]},{"id":9696336,"change_date":"2025-09-16 21:40:00","inspection_id":"85790697","dot_number":"415459","report_state":"NE","report_number":"T025002180","insp_date":"2025-09-16 00:00:00","insp_start_time":"0630","insp_end_time":"0650","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOWELLS FAB","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"825142","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-09-16 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:01.000000Z","updated_at":"2025-09-23T10:01:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16051082,"change_date":"2025-09-16 21:40:00","inspection_id":"85790697","insp_unit_id":"208981770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:32.000000Z"}]},{"id":9521808,"change_date":"2025-08-27 21:40:00","inspection_id":"85607608","dot_number":"415459","report_state":"NE","report_number":"T498000466","insp_date":"2025-08-27 00:00:00","insp_start_time":"0940","insp_end_time":"0953","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"823507","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-27 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:21.000000Z","updated_at":"2025-09-06T10:41:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15714828,"change_date":"2025-08-27 21:40:00","inspection_id":"85607608","insp_unit_id":"208613148","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:39.000000Z","updated_at":"2025-09-09T09:45:57.000000Z"}]},{"id":9531280,"change_date":"2025-08-28 21:41:00","inspection_id":"85617601","dot_number":"415459","report_state":"ND","report_number":"TR60002301","insp_date":"2025-08-27 00:00:00","insp_start_time":"0902","insp_end_time":"0927","registration_date":null,"region":"CD","ci_status_code":"C","location":"HAGUE","location_desc":"HAGUE ND","county_code_state":"ND","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SPS","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":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2190923","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:12.000000Z","updated_at":"2025-09-06T10:42:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15731834,"change_date":"2025-08-28 21:41:00","inspection_id":"85617601","insp_unit_id":"208631090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"123ECE","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"1FDNF7DC3RDF00897","insp_unit_decal":"Y","insp_unit_decal_number":"35529180","created_at":"2025-09-09T09:46:34.000000Z","updated_at":"2025-09-09T09:46:34.000000Z"}]},{"id":9237546,"change_date":"2025-07-24 21:41:00","inspection_id":"85308616","dot_number":"415459","report_state":"KS","report_number":"HP93012077","insp_date":"2025-07-23 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"#23W","location_desc":"OLATHE NORTH M.C.I.S. #23W","county_code_state":"KS","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1369136","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15200515,"change_date":"2025-07-24 21:41:00","inspection_id":"85308616","insp_unit_id":"208059499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"00J7SM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALHG3FM8RDVG0590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:31.000000Z","updated_at":"2025-07-28T09:46:02.000000Z"}]},{"id":9177433,"change_date":"2025-07-17 21:42:00","inspection_id":"85245384","dot_number":"415459","report_state":"NE","report_number":"T476000467","insp_date":"2025-07-17 00:00:00","insp_start_time":"0640","insp_end_time":"0658","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 30, 115 FEET WEST OF","county_code_state":"NE","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOWELLS FAB","shipping_paper_number":"071725","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-17 21:42: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":"820216","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-17 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:18.000000Z","updated_at":"2025-07-21T10:43:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15081187,"change_date":"2025-07-17 21:42:00","inspection_id":"85245384","insp_unit_id":"207930751","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:31.000000Z","updated_at":"2025-07-21T09:46:05.000000Z"}]},{"id":9152015,"change_date":"2025-07-15 21:40:00","inspection_id":"85218712","dot_number":"415459","report_state":"SD","report_number":"5410001670","insp_date":"2025-07-15 00:00:00","insp_start_time":"1221","insp_end_time":"1242","registration_date":null,"region":"CD","ci_status_code":"C","location":"BERESF","location_desc":"BERESFORD SD","county_code_state":"SD","county_code":"127","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"1994929","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:02.000000Z","updated_at":"2025-07-19T10:41:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15031625,"change_date":"2025-07-15 21:40:00","inspection_id":"85218712","insp_unit_id":"207876875","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:37.000000Z","updated_at":"2025-07-19T09:45:35.000000Z"}]},{"id":9165446,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","dot_number":"415459","report_state":"IA","report_number":"000P120DZ3","insp_date":"2025-07-15 00:00:00","insp_start_time":"0915","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PIPE FABRICATORS","shipping_paper_number":"T1403507001","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24300","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1367636","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:41.000000Z","updated_at":"2025-07-21T10:42:35.000000Z","inspection_violations":[{"id":14795477,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_violation_id":"267445651","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207904388","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:50.000000Z","updated_at":"2025-07-21T10:44:47.000000Z","normalized_code":"39395A"},{"id":14795478,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_violation_id":"267445652","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207904388","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:50.000000Z","updated_at":"2025-07-21T10:44:47.000000Z","normalized_code":"39395F"},{"id":14795479,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_violation_id":"267445653","seq_no":"3","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"207904389","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"3KOO25071509402","created_at":"2025-07-18T10:48:50.000000Z","updated_at":"2025-07-21T10:44:47.000000Z","normalized_code":"39343D"},{"id":14795480,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_violation_id":"267445654","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207904388","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:50.000000Z","updated_at":"2025-07-21T10:44:47.000000Z","normalized_code":"39617C"},{"id":14795481,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_violation_id":"267445655","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"207904389","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:50.000000Z","updated_at":"2025-07-21T10:44:47.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":15057006,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_unit_id":"207904388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"5802","insp_unit_license":"GIB695","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FTRF3B63HEB45802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:19.000000Z","updated_at":"2025-07-20T09:45:57.000000Z"},{"id":15057007,"change_date":"2025-07-16 21:41:00","inspection_id":"85232769","insp_unit_id":"207904389","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"3702","insp_unit_license":"EL0345","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"16VFX2024H2043702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-19T09:46:19.000000Z","updated_at":"2025-07-20T09:45:57.000000Z"}]},{"id":8963539,"change_date":"2025-06-23 21:41:00","inspection_id":"85020396","dot_number":"415459","report_state":"NE","report_number":"T557001621","insp_date":"2025-06-23 00:00:00","insp_start_time":"0615","insp_end_time":"0633","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOWELLS FAB","shipping_paper_number":"S5102894","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-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"818188","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-23 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14693995,"change_date":"2025-06-23 21:41:00","inspection_id":"85020396","insp_unit_id":"207511279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"}]},{"id":8863256,"change_date":"2025-06-10 21:40:00","inspection_id":"84913794","dot_number":"415459","report_state":"NE","report_number":"T025001960","insp_date":"2025-06-09 00:00:00","insp_start_time":"0555","insp_end_time":"0615","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOWELLS FAB","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"816885","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-09 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:46.000000Z","updated_at":"2025-06-14T10:00:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14514407,"change_date":"2025-06-10 21:40:00","inspection_id":"84913794","insp_unit_id":"207314644","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:44.000000Z","updated_at":"2025-06-14T09:45:45.000000Z"}]},{"id":8853398,"change_date":"2025-06-24 21:40:00","inspection_id":"84903319","dot_number":"415459","report_state":"KS","report_number":"HP00701765","insp_date":"2025-06-06 00:00:00","insp_start_time":"0800","insp_end_time":"0825","registration_date":"2025-06-24 00:00:00","region":"CT","ci_status_code":"C","location":"JO","location_desc":"JOHNSON COUNTY - 091","county_code_state":"KS","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","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-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"1363657","transaction_code":"C","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:33.000000Z","updated_at":"2025-06-28T10:00:42.000000Z","inspection_violations":[{"id":14404965,"change_date":"2025-06-24 21:40:00","inspection_id":"84903319","insp_violation_id":"267014459","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207530002","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:04.000000Z","updated_at":"2025-06-28T10:16:42.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14698975,"change_date":"2025-06-24 21:40:00","inspection_id":"84903319","insp_unit_id":"207530002","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"37","insp_unit_license":"99H1XL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FDUF5HT1FEA74224","insp_unit_decal":"Y","insp_unit_decal_number":"35236544","created_at":"2025-06-27T09:46:29.000000Z","updated_at":"2025-06-28T09:45:06.000000Z"}]},{"id":8685665,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","dot_number":"415459","report_state":"RI","report_number":"0058000786","insp_date":"2025-05-14 00:00:00","insp_start_time":"0918","insp_end_time":"1035","registration_date":"2025-05-14 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"EXETER RI","county_code_state":"RI","county_code":"009","insp_level_id":"1","service_center":"EA","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":"Y","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":"2025-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1754337","transaction_code":"C","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-05-20 21:40:00","snet_input_date":"2025-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-20 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-23T10:03:32.000000Z","updated_at":"2025-06-07T10:00:10.000000Z","inspection_violations":[{"id":14074513,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631445","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39378AWS"},{"id":14074514,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631446","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39347E"},{"id":14074515,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631447","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39021TB1MC"},{"id":14074516,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631448","seq_no":"4","part_no":"393","part_no_section":"47B-BMBCBD-SA","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39347BBMBCBDSA"},{"id":14074517,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631449","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39347E"},{"id":14074518,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631450","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"3939ALLPL"},{"id":14074519,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631451","seq_no":"7","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39353BB"},{"id":14074520,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631452","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"3963A1BOS"},{"id":14074521,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631453","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"39347E"},{"id":14074522,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_violation_id":"266631454","seq_no":"10","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207199124","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:45.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":14402519,"change_date":"2025-06-03 21:40:00","inspection_id":"84725679","insp_unit_id":"207199124","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2","insp_unit_license":"Y63093","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPGDU9XX5N843125","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:22.000000Z","updated_at":"2025-06-07T09:45:09.000000Z"}]},{"id":7874212,"change_date":"2025-02-14 21:40:00","inspection_id":"83871802","dot_number":"415459","report_state":"NE","report_number":"T025001666","insp_date":"2025-02-14 00:00:00","insp_start_time":"0715","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"808242","transaction_code":"A","transaction_date":"2025-02-14 00:00:00","upload_date":"2025-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-02-14 21:40:00","snet_input_date":"2025-02-14 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-02-14 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:35.000000Z","updated_at":"2025-03-17T21:01:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12709167,"change_date":"2025-02-14 21:40:00","inspection_id":"83871802","insp_unit_id":"205333082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:21.000000Z","updated_at":"2025-03-17T23:55:21.000000Z"}]},{"id":7811665,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","dot_number":"415459","report_state":"MN","report_number":"0191000141","insp_date":"2025-01-31 00:00:00","insp_start_time":"1300","insp_end_time":"1345","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ST. CLOUD MN","county_code_state":"MN","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"5","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"8","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1336271","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-01-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:21.000000Z","updated_at":"2025-03-17T21:00:21.000000Z","inspection_violations":[{"id":12208372,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394981","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39141AMCPC"},{"id":12208373,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394982","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALBL"},{"id":12208374,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394983","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALLPL"},{"id":12208375,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394984","seq_no":"4","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALHWS"},{"id":12208376,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394985","seq_no":"5","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALRLI"},{"id":12208377,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394986","seq_no":"6","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALSLI"},{"id":12208378,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394987","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3939ALTSI"},{"id":12208379,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_violation_id":"264394988","seq_no":"8","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"205208471","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":12606827,"change_date":"2025-02-07 21:40:00","inspection_id":"83806215","insp_unit_id":"205208471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCF7996","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC2GDA01591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:16.000000Z","updated_at":"2025-03-17T23:54:16.000000Z"}]},{"id":7497355,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","dot_number":"415459","report_state":"MN","report_number":"0351000419","insp_date":"2024-12-18 00:00:00","insp_start_time":"1313","insp_end_time":"1352","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ONAMIA MN","county_code_state":"MN","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S5030379.001","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-25 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","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":"1192148","transaction_code":"C","transaction_date":"2024-12-25 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-12-25 21:32:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-25 21:32:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:22.000000Z","updated_at":"2025-03-17T20:52:22.000000Z","inspection_violations":[{"id":11719152,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","insp_violation_id":"263948611","seq_no":"1","part_no":"392","part_no_section":"2-SLL","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-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLL"},{"id":11719153,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","insp_violation_id":"263948612","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204802832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3939ALIL"},{"id":11719154,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","insp_violation_id":"263948613","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"204802832","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3922SLLMF"},{"id":11719155,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","insp_violation_id":"263948614","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204802832","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:03.000000Z","updated_at":"2025-03-17T22:03:03.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":12095000,"change_date":"2025-01-14 21:53:00","inspection_id":"83476035","insp_unit_id":"204802832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"YCE1641","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HTMMMML7GH402842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:31.000000Z","updated_at":"2025-03-17T23:48:31.000000Z"}]},{"id":7280824,"change_date":"2024-11-26 21:40:00","inspection_id":"83248195","dot_number":"415459","report_state":"MN","report_number":"0191000066","insp_date":"2024-11-19 00:00:00","insp_start_time":"1319","insp_end_time":"1339","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PRINCETON MN","county_code_state":"MN","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","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":"1094006","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-11-26 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-26 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:06.000000Z","updated_at":"2025-03-17T20:48:06.000000Z","inspection_violations":[{"id":11382599,"change_date":"2024-11-26 21:40:00","inspection_id":"83248195","insp_violation_id":"263092076","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:01:18.000000Z","updated_at":"2025-03-17T22:01:18.000000Z","normalized_code":"3922SLL"},{"id":11382600,"change_date":"2024-11-26 21:40:00","inspection_id":"83248195","insp_violation_id":"263092077","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:01:18.000000Z","updated_at":"2025-03-17T22:01:18.000000Z","normalized_code":"3922SLL"},{"id":11382601,"change_date":"2024-11-26 21:40:00","inspection_id":"83248195","insp_violation_id":"263092078","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204057024","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:01:18.000000Z","updated_at":"2025-03-17T22:01:18.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11744254,"change_date":"2024-11-26 21:40:00","inspection_id":"83248195","insp_unit_id":"204057024","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCD0261","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC2GDA01591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":6632385,"change_date":"2024-09-03 21:42:00","inspection_id":"82559806","dot_number":"415459","report_state":"NE","report_number":"T216000022","insp_date":"2024-09-03 00:00:00","insp_start_time":"1016","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"796194","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-03 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10693036,"change_date":"2024-09-03 21:42:00","inspection_id":"82559806","insp_unit_id":"202727515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6673125,"change_date":"2024-09-08 21:32:00","inspection_id":"82603062","dot_number":"415459","report_state":"MO","report_number":"W110000191","insp_date":"2024-09-03 00:00:00","insp_start_time":"0740","insp_end_time":"0758","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MAYVIEW MO","county_code_state":"MO","county_code":"107","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"29492","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":"2024-09-08 21:32: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":"825558","transaction_code":"A","transaction_date":"2024-09-08 00:00:00","upload_date":"2024-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-09-08 21:32:00","snet_input_date":"2024-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-08 21:32:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:15.000000Z","updated_at":"2025-03-17T20:35:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10759281,"change_date":"2024-09-08 21:32:00","inspection_id":"82603062","insp_unit_id":"202812719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"00J7SM","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3ALHG3FM8RDVG0590","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":6651156,"change_date":"2024-09-05 21:42:00","inspection_id":"82579634","dot_number":"415459","report_state":"MN","report_number":"0134000085","insp_date":"2024-08-29 00:00:00","insp_start_time":"0902","insp_end_time":"0930","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NICOLLET MN","county_code_state":"MN","county_code":"103","insp_level_id":"1","service_center":"MW","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":"2024-09-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"815471","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:51.000000Z","updated_at":"2025-03-17T20:34:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10723462,"change_date":"2024-09-05 21:42:00","inspection_id":"82579634","insp_unit_id":"202766199","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YBX7250","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT5GDFY6142","insp_unit_decal":"Y","insp_unit_decal_number":"34363812","created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"}]},{"id":6365180,"change_date":"2024-08-01 21:40:00","inspection_id":"82274478","dot_number":"415459","report_state":"MN","report_number":"0078000117","insp_date":"2024-07-26 00:00:00","insp_start_time":"0746","insp_end_time":"0758","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WINTHROP MN","county_code_state":"MN","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"M J MECHANICAL","shipping_paper_number":"S4973480","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-08-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","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":"707694","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-08-01 21:40:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-01 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:04.000000Z","updated_at":"2025-03-17T20:29:04.000000Z","inspection_violations":[{"id":9882096,"change_date":"2024-08-01 21:40:00","inspection_id":"82274478","insp_violation_id":"260959520","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NONE","created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10257308,"change_date":"2024-08-01 21:40:00","inspection_id":"82274478","insp_unit_id":"202183843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCA8414","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC7NDF01288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:15.000000Z","updated_at":"2025-03-17T23:29:15.000000Z"}]},{"id":5995446,"change_date":"2024-06-25 21:42:00","inspection_id":"81877492","dot_number":"415459","report_state":"KS","report_number":"HP03017102","insp_date":"2024-06-13 00:00:00","insp_start_time":"1155","insp_end_time":"1216","registration_date":"2024-06-25 00:00:00","region":"CT","ci_status_code":"C","location":"JO","location_desc":"JOHNSON COUNTY - 091","county_code_state":"KS","county_code":"091","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","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":"1327872","transaction_code":"C","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-13 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:30.000000Z","updated_at":"2025-03-17T20:21:30.000000Z","inspection_violations":[{"id":9300448,"change_date":"2024-06-25 21:42:00","inspection_id":"81877492","insp_violation_id":"260298235","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:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"3922"},{"id":9300449,"change_date":"2024-06-25 21:42:00","inspection_id":"81877492","insp_violation_id":"260298236","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9656530,"change_date":"2024-06-25 21:42:00","inspection_id":"81877492","insp_unit_id":"201582010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"99H1XL","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FDUF5HT1FEA74224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:05.000000Z","updated_at":"2025-03-17T23:23:05.000000Z"}]},{"id":5944294,"change_date":"2024-06-10 21:42:00","inspection_id":"81821874","dot_number":"415459","report_state":"MN","report_number":"0134000027","insp_date":"2024-06-04 00:00:00","insp_start_time":"1445","insp_end_time":"1453","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MANKATO MN","county_code_state":"MN","county_code":"013","insp_level_id":"3","service_center":"MW","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":"2024-06-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"553638","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-06-10 21:42:00","snet_input_date":"2024-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-10 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:38.000000Z","updated_at":"2025-03-17T20:20:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9574690,"change_date":"2024-06-10 21:42:00","inspection_id":"81821874","insp_unit_id":"201298180","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YBX7250","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT5GDFY6142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:16.000000Z","updated_at":"2025-03-17T23:22:16.000000Z"}]},{"id":5707222,"change_date":"2024-05-09 21:42:00","inspection_id":"81564679","dot_number":"415459","report_state":"SD","report_number":"5410001196","insp_date":"2024-05-09 00:00:00","insp_start_time":"1027","insp_end_time":"1045","registration_date":null,"region":"CD","ci_status_code":"C","location":"BERESF","location_desc":"BERESFORD SD","county_code_state":"SD","county_code":"127","insp_level_id":"2","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"468939","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:53.000000Z","updated_at":"2025-03-17T20:15:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9192527,"change_date":"2024-05-09 21:42:00","inspection_id":"81564679","insp_unit_id":"200806138","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:33.000000Z","updated_at":"2025-03-17T23:18:33.000000Z"}]},{"id":4608895,"change_date":"2023-12-12 21:41:00","inspection_id":"80365567","dot_number":"415459","report_state":"SD","report_number":"0470000013","insp_date":"2023-12-12 00:00:00","insp_start_time":"0915","insp_end_time":"0923","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WORTHING SD","county_code_state":"SD","county_code":"137","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-12 21:41: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":"126982","transaction_code":"A","transaction_date":"2023-12-12 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":"2023-12-12 21:41:00","snet_input_date":"2023-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-12 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:11.000000Z","updated_at":"2025-03-17T19:54:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7413351,"change_date":"2023-12-12 21:41:00","inspection_id":"80365567","insp_unit_id":"198459946","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:18.000000Z","updated_at":"2025-03-17T23:02:18.000000Z"}]},{"id":4561204,"change_date":"2023-12-05 21:43:00","inspection_id":"80313355","dot_number":"415459","report_state":"MN","report_number":"00XE004222","insp_date":"2023-12-05 00:00:00","insp_start_time":"1150","insp_end_time":"1208","registration_date":null,"region":"CT","ci_status_code":"C","location":"MNTCL","location_desc":"MONTICELLO","county_code_state":"MN","county_code":"171","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S4880312","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1424102","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-05 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:21.000000Z","updated_at":"2025-03-17T19:53:21.000000Z","inspection_violations":[{"id":7053973,"change_date":"2023-12-05 21:43:00","inspection_id":"80313355","insp_violation_id":"256718956","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:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3922"},{"id":7053974,"change_date":"2023-12-05 21:43:00","inspection_id":"80313355","insp_violation_id":"256718957","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198356547","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7335893,"change_date":"2023-12-05 21:43:00","inspection_id":"80313355","insp_unit_id":"198356547","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCD0261","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC2GDA01591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4423558,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","dot_number":"415459","report_state":"MN","report_number":"00ZE003798","insp_date":"2023-11-14 00:00:00","insp_start_time":"0941","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"MNKTO","location_desc":"MANKATO","county_code_state":"MN","county_code":"013","insp_level_id":"1","service_center":"MW","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":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1421004","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[{"id":6844757,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_violation_id":"256390156","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198057426","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39311"},{"id":6844758,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_violation_id":"256390157","seq_no":"2","part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"198057426","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"172502A1"},{"id":6844759,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_violation_id":"256390158","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198057426","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39347E"},{"id":6844760,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_violation_id":"256390159","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"198057426","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"39353B"},{"id":6844761,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_violation_id":"256390160","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198057426","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:59.000000Z","updated_at":"2025-03-17T21:38:59.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7113906,"change_date":"2023-11-14 21:42:00","inspection_id":"80161890","insp_unit_id":"198057426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YBX7250","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT5GDFY6142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:43.000000Z","updated_at":"2025-03-17T22:59:43.000000Z"}]},{"id":3955404,"change_date":"2023-09-12 21:40:00","inspection_id":"79643294","dot_number":"415459","report_state":"MN","report_number":"0AGB000059","insp_date":"2023-09-12 00:00:00","insp_start_time":"1137","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"STCRX","location_desc":"ST. CROIX WEIGH STATION","county_code_state":"MN","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"SPS COMPANIES INC.","shipping_paper_number":"624003","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-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1409437","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-12 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[{"id":6115720,"change_date":"2023-09-12 21:40:00","inspection_id":"79643294","insp_violation_id":"255219634","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"197014180","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":6359984,"change_date":"2023-09-12 21:40:00","inspection_id":"79643294","insp_unit_id":"197014180","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCE1717","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDNF7DC1RDF00896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3900529,"change_date":"2023-09-05 21:40:00","inspection_id":"79582254","dot_number":"415459","report_state":"IA","report_number":"000TT4S279","insp_date":"2023-09-01 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 NB","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1287613","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:02.000000Z","updated_at":"2025-03-17T19:40:02.000000Z","inspection_violations":[{"id":6027229,"change_date":"2023-09-05 21:40:00","inspection_id":"79582254","insp_violation_id":"255075072","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196891908","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9DAN23090107515","created_at":"2025-03-17T21:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"3922"},{"id":6027230,"change_date":"2023-09-05 21:40:00","inspection_id":"79582254","insp_violation_id":"255075073","seq_no":"2","part_no":"383","part_no_section":"95(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"9DAN23090107582","created_at":"2025-03-17T21:35:11.000000Z","updated_at":"2025-03-17T21:35:11.000000Z","normalized_code":"38395A"}],"inspection_per_units":[{"id":6271327,"change_date":"2023-09-05 21:40:00","inspection_id":"79582254","insp_unit_id":"196891908","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"NONE","insp_unit_license":"YCA5186","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5KKMAXDV5MPMU8176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:42.000000Z","updated_at":"2025-03-17T22:52:42.000000Z"}]},{"id":3846932,"change_date":"2023-08-28 21:42:00","inspection_id":"79522610","dot_number":"415459","report_state":"ND","report_number":"TR95000897","insp_date":"2023-08-23 00:00:00","insp_start_time":"1523","insp_end_time":"1539","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"APPLE CREEK REST AREA","county_code_state":"ND","county_code":"015","insp_level_id":"1","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":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"374613","transaction_code":"A","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-25 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:55.000000Z","updated_at":"2025-03-17T19:38:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6185265,"change_date":"2023-08-28 21:42:00","inspection_id":"79522610","insp_unit_id":"196763959","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"607","insp_unit_license":"10888P","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"3HAEUMML6NL114922","insp_unit_decal":"Y","insp_unit_decal_number":"33114383","created_at":"2025-03-17T22:51:59.000000Z","updated_at":"2025-03-17T22:51:59.000000Z"}]},{"id":3642031,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","dot_number":"415459","report_state":"MN","report_number":"00ZM006313","insp_date":"2023-08-01 00:00:00","insp_start_time":"0704","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":"RDRVR","location_desc":"RED RIVER WEIGH STATION","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1401310","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-01 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:53.000000Z","updated_at":"2025-03-17T19:34:53.000000Z","inspection_violations":[{"id":5615348,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","insp_violation_id":"254396769","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196300412","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3939A"},{"id":5615349,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","insp_violation_id":"254396770","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196300412","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3939A"},{"id":5615350,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","insp_violation_id":"254396771","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196300412","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"39345B2"},{"id":5615351,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","insp_violation_id":"254396772","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196300412","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5855883,"change_date":"2023-08-01 21:41:00","inspection_id":"79293466","insp_unit_id":"196300412","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"10889P","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"1HTMMMML7GH402842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:15.000000Z","updated_at":"2025-03-17T22:49:15.000000Z"}]},{"id":3414737,"change_date":"2023-06-30 21:40:00","inspection_id":"79038322","dot_number":"415459","report_state":"ND","report_number":"FT52000324","insp_date":"2023-06-29 00:00:00","insp_start_time":"1527","insp_end_time":"1544","registration_date":null,"region":"CT","ci_status_code":"C","location":"1","location_desc":"BERTHOLD","county_code_state":"ND","county_code":"101","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":"2023-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"373309","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-29 00:00:00","source_office":"4NDS001","mcmis_add_date":"2023-06-30 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:36.000000Z","updated_at":"2025-03-17T19:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5490309,"change_date":"2023-06-30 21:40:00","inspection_id":"79038322","insp_unit_id":"195785337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"10889P","insp_unit_license_state":"ND","insp_unit_vehicle_id_number":"1HTMMMML7GH402842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":2578061,"change_date":"2023-03-14 21:42:00","inspection_id":"78091771","dot_number":"415459","report_state":"MN","report_number":"0ADH001661","insp_date":"2023-03-14 00:00:00","insp_start_time":"1033","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"STPL","location_desc":"ST. PAUL","county_code_state":"MN","county_code":"123","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":"N","pen_cen_match":"I","final_status_date":"2023-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1376263","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-03-14 21:42:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:08.000000Z","updated_at":"2025-03-17T19:14:08.000000Z","inspection_violations":[{"id":3966474,"change_date":"2023-03-14 21:42:00","inspection_id":"78091771","insp_violation_id":"251662941","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:25:37.000000Z","updated_at":"2025-03-17T21:25:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4149425,"change_date":"2023-03-14 21:42:00","inspection_id":"78091771","insp_unit_id":"193872607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YBP9709","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC3GDA02457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"}]},{"id":2168866,"change_date":"2023-01-24 21:43:00","inspection_id":"77625679","dot_number":"415459","report_state":"SD","report_number":"0031005644","insp_date":"2023-01-11 00:00:00","insp_start_time":"1159","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BERESFORD TRUCK CHECK","county_code_state":"SD","county_code":"127","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":"2023-01-18 21:40: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":"634458","transaction_code":"C","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-18 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3354547,"change_date":"2023-01-24 21:43:00","inspection_id":"77625679","insp_violation_id":"250749419","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193039611","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3491040,"change_date":"2023-01-24 21:43:00","inspection_id":"77625679","insp_unit_id":"193039611","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:02.000000Z","updated_at":"2025-03-17T22:31:02.000000Z"}]},{"id":2038295,"change_date":"2023-01-03 21:41:00","inspection_id":"77475651","dot_number":"415459","report_state":"MN","report_number":"00XE003777","insp_date":"2022-12-29 00:00:00","insp_start_time":"0940","insp_end_time":"1004","registration_date":null,"region":"CT","ci_status_code":"C","location":"CDSPG","location_desc":"COLD SPRING","county_code_state":"MN","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"4315","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-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1366583","transaction_code":"C","transaction_date":"2023-01-03 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-29 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:04.000000Z","updated_at":"2025-03-17T19:04:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3278912,"change_date":"2023-01-03 21:41:00","inspection_id":"77475651","insp_unit_id":"192674159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCC4508","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDUF5HY3GEA28407","insp_unit_decal":"Y","insp_unit_decal_number":"32016971","created_at":"2025-03-17T22:29:28.000000Z","updated_at":"2025-03-17T22:29:28.000000Z"}]},{"id":1581056,"change_date":"2022-10-24 21:40:00","inspection_id":"76952115","dot_number":"415459","report_state":"MN","report_number":"0ACX001650","insp_date":"2022-10-21 00:00:00","insp_start_time":"1100","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"BRHM","location_desc":"BRAHAM","county_code_state":"MN","county_code":"059","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":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1357443","transaction_code":"A","transaction_date":"2022-10-21 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-24 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-10-24 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:53.000000Z","updated_at":"2025-03-17T18:55:53.000000Z","inspection_violations":[{"id":2484292,"change_date":"2022-10-24 21:40:00","inspection_id":"76952115","insp_violation_id":"249200132","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191596869","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2544480,"change_date":"2022-10-24 21:40:00","inspection_id":"76952115","insp_unit_id":"191596869","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YBP9761","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDWF7DC2GDA01591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:26.000000Z","updated_at":"2025-03-17T22:24:26.000000Z"}]},{"id":1146702,"change_date":"2022-08-26 21:40:00","inspection_id":"76448911","dot_number":"415459","report_state":"MN","report_number":"00XD003248","insp_date":"2022-08-26 00:00:00","insp_start_time":"1150","insp_end_time":"1215","registration_date":null,"region":"CT","ci_status_code":"C","location":"GLMAN","location_desc":"GILMAN","county_code_state":"MN","county_code":"009","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"S4685685-001","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-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1347414","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-26 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-08-26 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:54.000000Z","updated_at":"2025-03-17T18:47:54.000000Z","inspection_violations":[{"id":1815222,"change_date":"2022-08-26 21:40:00","inspection_id":"76448911","insp_violation_id":"248029403","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190568048","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:25.000000Z","updated_at":"2025-03-17T21:15:25.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":1843311,"change_date":"2022-08-26 21:40:00","inspection_id":"76448911","insp_unit_id":"190568048","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"YCC4508","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FDUF5HY3GEA28407","insp_unit_decal":"Y","insp_unit_decal_number":"31702831","created_at":"2025-03-17T22:19:42.000000Z","updated_at":"2025-03-17T22:19:42.000000Z"}]},{"id":348121,"change_date":"2022-05-09 21:41:00","inspection_id":"75508416","dot_number":"415459","report_state":"MN","report_number":"00ZE002990","insp_date":"2022-05-09 00:00:00","insp_start_time":"1006","insp_end_time":"1009","registration_date":null,"region":"CT","ci_status_code":"C","location":"BLRTH","location_desc":"BLUE EARTH","county_code_state":"MN","county_code":"043","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":"N","pen_cen_match":"I","final_status_date":"2022-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1327420","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-09 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-09 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:39.000000Z","updated_at":"2025-03-17T18:33:39.000000Z","inspection_violations":[{"id":546019,"change_date":"2022-05-09 21:41:00","inspection_id":"75508416","insp_violation_id":"245669656","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:09:37.000000Z","updated_at":"2025-03-17T21:09:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":562939,"change_date":"2022-05-09 21:41:00","inspection_id":"75508416","insp_unit_id":"188579358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YBN0110","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP2HM6X9GM317942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"}]},{"id":225291,"change_date":"2022-04-21 21:41:00","inspection_id":"75361802","dot_number":"415459","report_state":"MN","report_number":"0ADO002791","insp_date":"2022-04-21 00:00:00","insp_start_time":"0657","insp_end_time":"0759","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HOWELLS FAB","shipping_paper_number":"S4626151001","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-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1324835","transaction_code":"A","transaction_date":"2022-04-21 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-21 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-04-21 21:41:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:32.000000Z","updated_at":"2025-03-17T18:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":365300,"change_date":"2022-04-21 21:41:00","inspection_id":"75361802","insp_unit_id":"188273442","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"209694","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"1XPBDP9X4GD325435","insp_unit_decal":"Y","insp_unit_decal_number":"31347634","created_at":"2025-03-17T22:10:28.000000Z","updated_at":"2025-03-17T22:10:28.000000Z"}]},{"id":100843,"change_date":"2022-09-23 21:38:00","inspection_id":"75211376","dot_number":"415459","report_state":"MN","report_number":"0ACF001663","insp_date":"2022-03-29 00:00:00","insp_start_time":"0905","insp_end_time":"0921","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ST PETER","county_code_state":"MN","county_code":"103","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":"N","pen_cen_match":"I","final_status_date":"2022-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1321789","transaction_code":"C","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00415459","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-04 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-04-04 21:40:00","insp_carrier_name":"S P S COMPANIES INC","insp_carrier_street":"6363 STATE HIGHWAY 7","insp_carrier_city":"ST LOUIS PARK","insp_carrier_state":"MN","insp_carrier_zip_code":"55416","insp_colonia":null,"docket_number":"539069","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:25.000000Z","updated_at":"2025-03-17T18:29:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":163249,"change_date":"2022-09-23 21:38:00","inspection_id":"75211376","insp_unit_id":"191067956","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"YBX7250","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3ALACWDT5GDFY6142","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:12.000000Z","updated_at":"2025-03-17T22:09:12.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/415459\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/415459\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/415459\/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\/415459\/inspections","per_page":100,"prev_page_url":null,"to":44,"total":44}