{"current_page":1,"data":[{"id":12775216,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","dot_number":"2845665","report_state":"MI","report_number":"MDTBB02658","insp_date":"2026-08-20 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"5","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":"2026-08-20 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4036321","transaction_code":"A","transaction_date":"2026-08-20 00:00:00","upload_date":"2026-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-08-20 21:49:00","snet_input_date":"2026-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-20 21:49:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427-9420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"823","created_at":"2026-08-23T09:39:15.000000Z","updated_at":"2026-08-25T09:36:32.000000Z","inspection_violations":[{"id":22238850,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_violation_id":"276233238","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"215245976","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-23T09:54:56.000000Z","updated_at":"2026-08-25T09:48:59.000000Z","normalized_code":"3922SLLSIV"},{"id":22238851,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_violation_id":"276233239","seq_no":"3","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"215245976","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-23T09:54:56.000000Z","updated_at":"2026-08-25T09:48:59.000000Z","normalized_code":"3929AA1"},{"id":22238852,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_violation_id":"276233240","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"215245976","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-23T09:54:56.000000Z","updated_at":"2026-08-25T09:48:59.000000Z","normalized_code":"39360C"},{"id":22238853,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_violation_id":"276233241","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"215245976","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-23T09:54:56.000000Z","updated_at":"2026-08-25T09:48:59.000000Z","normalized_code":"3965BL"},{"id":22238849,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_violation_id":"276233237","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"215245976","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-23T09:54:56.000000Z","updated_at":"2026-08-25T09:48:59.000000Z","normalized_code":"393207ASAPPAS"}],"inspection_per_units":[{"id":22173736,"change_date":"2026-08-20 21:49:00","inspection_id":"88747966","insp_unit_id":"215245976","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"DE63946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAIFW067185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-23T09:15:19.000000Z","updated_at":"2026-08-25T09:11:38.000000Z"}]},{"id":12717432,"change_date":"2026-08-13 21:43:00","inspection_id":"88692802","dot_number":"2845665","report_state":"MI","report_number":"PEASS03143","insp_date":"2026-08-13 00:00:00","insp_start_time":"1130","insp_end_time":"1210","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-08-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3976499","transaction_code":"A","transaction_date":"2026-08-13 00:00:00","upload_date":"2026-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-08-13 21:43:00","snet_input_date":"2026-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-13 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427-9420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-16T09:41:06.000000Z","updated_at":"2026-08-24T09:31:22.000000Z","inspection_violations":[{"id":22140518,"change_date":"2026-08-13 21:43:00","inspection_id":"88692802","insp_violation_id":"276112517","seq_no":"2","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4713734","created_at":"2026-08-16T10:00:49.000000Z","updated_at":"2026-08-24T09:41:46.000000Z","normalized_code":"39141AMCPVI"},{"id":22140517,"change_date":"2026-08-13 21:43:00","inspection_id":"88692802","insp_violation_id":"276112516","seq_no":"1","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4713734","created_at":"2026-08-16T10:00:49.000000Z","updated_at":"2026-08-24T09:41:46.000000Z","normalized_code":"3922SLLSOA"},{"id":22140519,"change_date":"2026-08-13 21:43:00","inspection_id":"88692802","insp_violation_id":"276112518","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4713734","created_at":"2026-08-16T10:00:49.000000Z","updated_at":"2026-08-24T09:41:46.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":22070309,"change_date":"2026-08-13 21:43:00","inspection_id":"88692802","insp_unit_id":"215141737","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"DE63946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"36680701","created_at":"2026-08-16T09:20:16.000000Z","updated_at":"2026-08-24T09:03:20.000000Z"}]},{"id":11465971,"change_date":"2026-03-24 21:40:00","inspection_id":"87384292","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02878","insp_date":"2026-03-24 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34220","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":"1263702","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19638950,"change_date":"2026-03-24 21:40:00","inspection_id":"87384292","insp_unit_id":"212311461","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"222","insp_unit_license":"DE64080","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4DRBWAAR59A664064","insp_unit_decal":"Y","insp_unit_decal_number":"36056675","created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:58.000000Z"}]},{"id":11465972,"change_date":"2026-03-24 21:40:00","inspection_id":"87384293","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02879","insp_date":"2026-03-24 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"34220","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":"1263774","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19638951,"change_date":"2026-03-24 21:40:00","inspection_id":"87384293","insp_unit_id":"212311462","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"220","insp_unit_license":"DE64082","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4DRBWAAR39A664046","insp_unit_decal":"Y","insp_unit_decal_number":"36056676","created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:58.000000Z"}]},{"id":11466028,"change_date":"2026-03-24 21:40:00","inspection_id":"87384355","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02880","insp_date":"2026-03-24 00:00:00","insp_start_time":"1130","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1263798","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19639043,"change_date":"2026-03-24 21:40:00","inspection_id":"87384355","insp_unit_id":"212311581","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"THMS","insp_unit_company":"2120","insp_unit_license":"DD94459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T7YT402681294589","insp_unit_decal":"Y","insp_unit_decal_number":"36056677","created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:59.000000Z"}]},{"id":11466033,"change_date":"2026-03-24 21:40:00","inspection_id":"87384360","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02881","insp_date":"2026-03-24 00:00:00","insp_start_time":"1230","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1263830","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:26.000000Z","updated_at":"2026-04-04T09:31:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19639051,"change_date":"2026-03-24 21:40:00","inspection_id":"87384360","insp_unit_id":"212311589","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"THMS","insp_unit_company":"214","insp_unit_license":"DD94471","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T7YT402481294588","insp_unit_decal":"Y","insp_unit_decal_number":"36056678","created_at":"2026-03-27T09:23:03.000000Z","updated_at":"2026-04-04T09:04:59.000000Z"}]},{"id":11227819,"change_date":"2026-03-06 21:42:00","inspection_id":"87139898","dot_number":"2845665","report_state":"MI","report_number":"MDTRL99842","insp_date":"2025-11-10 00:00:00","insp_start_time":"1320","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-02-25 21:49: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":"1260502","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2025-11-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343753,"change_date":"2026-03-06 21:42:00","inspection_id":"87139898","insp_unit_id":"212013806","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2204","insp_unit_license":"DE63981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"Y","insp_unit_decal_number":"35766737","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":11227820,"change_date":"2026-03-06 21:42:00","inspection_id":"87139899","dot_number":"2845665","report_state":"MI","report_number":"MDTRL99843","insp_date":"2025-11-10 00:00:00","insp_start_time":"1000","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-02-25 21:49: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":"1260379","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2026-02-25 21:49:00","snet_input_date":"2025-11-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19343754,"change_date":"2026-03-06 21:42:00","inspection_id":"87139899","insp_unit_id":"212013807","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2256","insp_unit_license":"DE63954","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAXFW067184","insp_unit_decal":"Y","insp_unit_decal_number":"35766736","created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:47.000000Z"}]},{"id":10138385,"change_date":"2025-11-06 21:40:00","inspection_id":"86255920","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02843","insp_date":"2025-11-04 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249414","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:43.000000Z","updated_at":"2025-11-10T10:31:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16876651,"change_date":"2025-11-06 21:40:00","inspection_id":"86255920","insp_unit_id":"209884647","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"DE63946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"35766731","created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:31.000000Z"}]},{"id":9730474,"change_date":"2025-09-19 21:39:00","inspection_id":"85826608","dot_number":"2845665","report_state":"MI","report_number":"PEASS02991","insp_date":"2025-09-18 00:00:00","insp_start_time":"1230","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BEAUBIEN ST @ DIVISION ST","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-09-19 21:39: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":"1241898","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-09-19 21:39:00","snet_input_date":"2025-09-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:45.000000Z","updated_at":"2025-09-23T10:02:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16113714,"change_date":"2025-09-19 21:39:00","inspection_id":"85826608","insp_unit_id":"209049695","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"2303","insp_unit_license":"DE63952","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA9AW065519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:06.000000Z","updated_at":"2025-09-23T09:46:09.000000Z"}]},{"id":9473006,"change_date":"2025-08-21 21:41:00","inspection_id":"85556337","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02774","insp_date":"2025-08-20 00:00:00","insp_start_time":"1050","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-08-21 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":"1237346","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15624840,"change_date":"2025-08-21 21:41:00","inspection_id":"85556337","insp_unit_id":"208516557","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2303","insp_unit_license":"DE63952","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA9AW065519","insp_unit_decal":"Y","insp_unit_decal_number":"35454024","created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:07.000000Z"}]},{"id":9473007,"change_date":"2025-08-21 21:41:00","inspection_id":"85556338","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02775","insp_date":"2025-08-20 00:00:00","insp_start_time":"1130","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-08-21 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":"1237433","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15624841,"change_date":"2025-08-21 21:41:00","inspection_id":"85556338","insp_unit_id":"208516558","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2304","insp_unit_license":"DE61331","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA3AW065516","insp_unit_decal":"Y","insp_unit_decal_number":"35454025","created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:07.000000Z"}]},{"id":9473025,"change_date":"2025-08-21 21:41:00","inspection_id":"85556359","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02776","insp_date":"2025-08-20 00:00:00","insp_start_time":"1210","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CRRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1237483","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15624871,"change_date":"2025-08-21 21:41:00","inspection_id":"85556359","insp_unit_id":"208516593","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"231","insp_unit_license":"DE61295","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBKA75P224991","insp_unit_decal":"Y","insp_unit_decal_number":"35454026","created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:07.000000Z"}]},{"id":9473026,"change_date":"2025-08-21 21:41:00","inspection_id":"85556360","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02777","insp_date":"2025-08-20 00:00:00","insp_start_time":"1320","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-08-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1237290","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:42:55.000000Z","updated_at":"2025-08-25T10:42:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15624872,"change_date":"2025-08-21 21:41:00","inspection_id":"85556360","insp_unit_id":"208516594","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"241","insp_unit_license":"DE61296","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBXA34P213882","insp_unit_decal":"Y","insp_unit_decal_number":"35454027","created_at":"2025-08-24T09:46:43.000000Z","updated_at":"2025-08-25T09:46:07.000000Z"}]},{"id":9165981,"change_date":"2025-07-16 21:41:00","inspection_id":"85233337","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02721","insp_date":"2025-07-15 00:00:00","insp_start_time":"1040","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2025-07-16 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":"1230579","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-07-16 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:41.000000Z","updated_at":"2025-07-21T10:42:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15057923,"change_date":"2025-07-16 21:41:00","inspection_id":"85233337","insp_unit_id":"207905504","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2255","insp_unit_license":"DE63949","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGDLW910PW105545","insp_unit_decal":"Y","insp_unit_decal_number":"35454140","created_at":"2025-07-19T09:46:19.000000Z","updated_at":"2025-07-20T09:46:00.000000Z"}]},{"id":9014375,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","dot_number":"2845665","report_state":"MI","report_number":"BALLB05146","insp_date":"2025-06-26 00:00:00","insp_start_time":"1215","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SD @ M1","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUPERIOR ELECTRIC","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"7","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1227665","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:24.000000Z","updated_at":"2025-07-03T10:00:45.000000Z","inspection_violations":[{"id":14489193,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095034","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4529385","created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:57.000000Z","normalized_code":"3922SLLSIV"},{"id":14489194,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095035","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4529385","created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"3922SLLSOA"},{"id":14489195,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095036","seq_no":"3","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4529386","created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"39141AMCPVI"},{"id":14489196,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095037","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207608857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"3939ALFTSI"},{"id":14489197,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095038","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207608857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"3939ALIL"},{"id":14489198,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095039","seq_no":"6","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207608857","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"3965BL"},{"id":14489199,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_violation_id":"267095040","seq_no":"7","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207608857","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:45.000000Z","updated_at":"2025-07-02T10:15:58.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":14784257,"change_date":"2025-06-27 21:39:00","inspection_id":"85073702","insp_unit_id":"207608857","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:38.000000Z","updated_at":"2025-07-01T09:49:50.000000Z"}]},{"id":8779782,"change_date":"2025-05-30 21:40:00","inspection_id":"84825332","dot_number":"2845665","report_state":"MI","report_number":"BALLB05118","insp_date":"2025-05-29 00:00:00","insp_start_time":"1920","insp_end_time":"2020","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W MONTCALM @ PARK","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SUE EDMONDS","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-05-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223528","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:07.000000Z","updated_at":"2025-06-04T10:01:07.000000Z","inspection_violations":[{"id":14033263,"change_date":"2025-05-30 21:40:00","inspection_id":"84825332","insp_violation_id":"266576544","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","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-06-02T10:17:13.000000Z","updated_at":"2025-06-03T10:17:30.000000Z","normalized_code":"3922SLLUP"},{"id":14033264,"change_date":"2025-05-30 21:40:00","inspection_id":"84825332","insp_violation_id":"266576545","seq_no":"2","part_no":"392","part_no_section":"2-SLLSOA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:13.000000Z","updated_at":"2025-06-03T10:17:30.000000Z","normalized_code":"3922SLLSOA"},{"id":14033265,"change_date":"2025-05-30 21:40:00","inspection_id":"84825332","insp_violation_id":"266576546","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207151816","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:13.000000Z","updated_at":"2025-06-03T10:17:30.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":14364487,"change_date":"2025-05-30 21:40:00","inspection_id":"84825332","insp_unit_id":"207151816","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2304","insp_unit_license":"DE63953","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA3AW065516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:22.000000Z","updated_at":"2025-06-03T09:45:48.000000Z"}]},{"id":8732988,"change_date":"2025-05-25 21:34:00","inspection_id":"84775804","dot_number":"2845665","report_state":"OH","report_number":"1910000063","insp_date":"2025-05-23 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SILVER  SAND COACH","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":"2025-05-25 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","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":"1778498","transaction_code":"A","transaction_date":"2025-05-25 00:00:00","upload_date":"2025-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-05-25 21:34:00","snet_input_date":"2025-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-25 21:34:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427-9420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-28T10:00:26.000000Z","updated_at":"2025-05-29T10:00:17.000000Z","inspection_violations":[{"id":13935236,"change_date":"2025-05-25 21:34:00","inspection_id":"84775804","insp_violation_id":"266464344","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"207057056","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-28T10:15:35.000000Z","updated_at":"2025-05-29T10:15:19.000000Z","normalized_code":"3929AA1"},{"id":13935237,"change_date":"2025-05-25 21:34:00","inspection_id":"84775804","insp_violation_id":"266464345","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"207057056","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-28T10:15:35.000000Z","updated_at":"2025-05-29T10:15:19.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":14277414,"change_date":"2025-05-25 21:34:00","inspection_id":"84775804","insp_unit_id":"207057056","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TWIN COACH","insp_unit_company":null,"insp_unit_license":"DE63947","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M9TRMPA14W062459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-28T09:45:27.000000Z","updated_at":"2025-05-29T09:45:22.000000Z"}]},{"id":8598057,"change_date":"2025-05-11 21:33:00","inspection_id":"84633516","dot_number":"2845665","report_state":"OH","report_number":"9476000027","insp_date":"2025-05-09 00:00:00","insp_start_time":"0940","insp_end_time":"1055","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LAKELAND HIGH SCHOOL","shipping_paper_number":"050925","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-05-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","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":"1711747","transaction_code":"A","transaction_date":"2025-05-11 00:00:00","upload_date":"2025-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-05-11 21:33:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-11 21:33:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427-9420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-14T10:00:56.000000Z","updated_at":"2025-05-15T10:00:29.000000Z","inspection_violations":[{"id":13658964,"change_date":"2025-05-11 21:33:00","inspection_id":"84633516","insp_violation_id":"266145427","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"206792860","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-14T10:17:44.000000Z","updated_at":"2025-05-15T10:17:15.000000Z","normalized_code":"3929AA1"},{"id":13658965,"change_date":"2025-05-11 21:33:00","inspection_id":"84633516","insp_violation_id":"266145428","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"206792860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:17:44.000000Z","updated_at":"2025-05-15T10:17:15.000000Z","normalized_code":"3939ALLPL"},{"id":13658966,"change_date":"2025-05-11 21:33:00","inspection_id":"84633516","insp_violation_id":"266145429","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206792860","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:17:44.000000Z","updated_at":"2025-05-15T10:17:15.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":14034932,"change_date":"2025-05-11 21:33:00","inspection_id":"84633516","insp_unit_id":"206792860","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":"2204","insp_unit_license":"DE63981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"Y","insp_unit_decal_number":"35133304","created_at":"2025-05-14T09:45:59.000000Z","updated_at":"2025-05-15T09:45:29.000000Z"}]},{"id":8598618,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","dot_number":"2845665","report_state":"OH","report_number":"3217000138","insp_date":"2025-05-09 00:00:00","insp_start_time":"0951","insp_end_time":"1042","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SANDUSKY OH","county_code_state":"OH","county_code":"043","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LAKELAND HIGH SCHOOL WHITELAKE, MI","shipping_paper_number":"10655","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-05-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1712240","transaction_code":"A","transaction_date":"2025-05-11 00:00:00","upload_date":"2025-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2025-05-11 21:33:00","snet_input_date":"2025-05-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-11 21:33:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427-9420","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-14T10:00:58.000000Z","updated_at":"2025-05-15T10:00:37.000000Z","inspection_violations":[{"id":13660054,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146657","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206793861","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:41.000000Z","normalized_code":"3939ALCL"},{"id":13660055,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146658","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206793861","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:41.000000Z","normalized_code":"39360C"},{"id":13660056,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146659","seq_no":"4","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"206793861","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:41.000000Z","normalized_code":"39355D1B"},{"id":13660057,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146660","seq_no":"5","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"206793861","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:41.000000Z","normalized_code":"3922SLLEQP"},{"id":13660058,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146661","seq_no":"6","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"206793861","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:42.000000Z","normalized_code":"3929AA1"},{"id":13660053,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_violation_id":"266146656","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-14T10:18:01.000000Z","updated_at":"2025-05-15T10:17:41.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":14035848,"change_date":"2025-05-11 21:33:00","inspection_id":"84634117","insp_unit_id":"206793861","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTOR COAC","insp_unit_company":"1","insp_unit_license":"DE63948","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA5CW066004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-14T09:46:00.000000Z","updated_at":"2025-05-15T09:45:37.000000Z"}]},{"id":6853035,"change_date":"2024-09-30 21:41:00","inspection_id":"82794565","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02420","insp_date":"2024-09-26 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-30 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":"1196290","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11051468,"change_date":"2024-09-30 21:41:00","inspection_id":"82794565","insp_unit_id":"203194726","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2101","insp_unit_license":"DE63948","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA5CW066004","insp_unit_decal":"Y","insp_unit_decal_number":"34302688","created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6853036,"change_date":"2024-09-30 21:41:00","inspection_id":"82794566","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02421","insp_date":"2024-09-26 00:00:00","insp_start_time":"1140","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-30 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":"1196359","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11051469,"change_date":"2024-09-30 21:41:00","inspection_id":"82794566","insp_unit_id":"203194727","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2256","insp_unit_license":"DE63954","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAXFW067184","insp_unit_decal":"Y","insp_unit_decal_number":"34302689","created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6516269,"change_date":"2024-09-17 21:45:00","inspection_id":"82435991","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02368","insp_date":"2024-08-16 00:00:00","insp_start_time":"1215","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-08-20 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":"1190810","transaction_code":"C","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10504576,"change_date":"2024-09-17 21:45:00","inspection_id":"82435991","insp_unit_id":"202983108","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"34302645","created_at":"2025-03-17T23:31:48.000000Z","updated_at":"2025-03-17T23:31:48.000000Z"}]},{"id":6370070,"change_date":"2024-09-17 21:45:00","inspection_id":"82279786","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02336","insp_date":"2024-08-01 00:00:00","insp_start_time":"0920","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-08-01 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":"1188547","transaction_code":"C","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10265306,"change_date":"2024-09-17 21:45:00","inspection_id":"82279786","insp_unit_id":"202983379","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2255","insp_unit_license":"DE63949","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910PW105545","insp_unit_decal":"Y","insp_unit_decal_number":"34302625","created_at":"2025-03-17T23:29:21.000000Z","updated_at":"2025-03-17T23:29:21.000000Z"}]},{"id":6357608,"change_date":"2024-09-17 21:45:00","inspection_id":"82266476","dot_number":"2845665","report_state":"MI","report_number":"DAWDD03639","insp_date":"2024-07-30 00:00:00","insp_start_time":"1150","insp_end_time":"1238","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SD AT JOHN R","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SILVER SAND COACH BUS LLC","shipping_paper_number":"07302024","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-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188407","transaction_code":"C","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-31 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870525,"change_date":"2024-09-17 21:45:00","inspection_id":"82266476","insp_violation_id":"261860207","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202976354","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4399509","created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3922"},{"id":9870526,"change_date":"2024-09-17 21:45:00","inspection_id":"82266476","insp_violation_id":"261860208","seq_no":"2","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"202976354","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":10245353,"change_date":"2024-09-17 21:45:00","inspection_id":"82266476","insp_unit_id":"202976354","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":6250227,"change_date":"2024-09-17 21:45:00","inspection_id":"82151713","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02314","insp_date":"2024-07-17 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186293","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10070730,"change_date":"2024-09-17 21:45:00","inspection_id":"82151713","insp_unit_id":"202982839","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2303","insp_unit_license":"DE63952","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA9AW065519","insp_unit_decal":"Y","insp_unit_decal_number":"34302606","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6250228,"change_date":"2024-09-17 21:45:00","inspection_id":"82151714","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02315","insp_date":"2024-07-17 00:00:00","insp_start_time":"1045","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186704","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10070731,"change_date":"2024-09-17 21:45:00","inspection_id":"82151714","insp_unit_id":"202982871","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2304","insp_unit_license":"DE63953","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA3AW065516","insp_unit_decal":"Y","insp_unit_decal_number":"34302607","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6250229,"change_date":"2024-09-17 21:45:00","inspection_id":"82151715","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02316","insp_date":"2024-07-17 00:00:00","insp_start_time":"1130","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186435","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10070732,"change_date":"2024-09-17 21:45:00","inspection_id":"82151715","insp_unit_id":"202982872","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"Y","insp_unit_decal_number":"34302608","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6250230,"change_date":"2024-09-17 21:45:00","inspection_id":"82151716","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02317","insp_date":"2024-07-17 00:00:00","insp_start_time":"1240","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186547","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10070733,"change_date":"2024-09-17 21:45:00","inspection_id":"82151716","insp_unit_id":"202982873","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2204","insp_unit_license":"DE63981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"Y","insp_unit_decal_number":"34302609","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6250231,"change_date":"2024-09-17 21:45:00","inspection_id":"82151717","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02318","insp_date":"2024-07-17 00:00:00","insp_start_time":"1325","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","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":"1186498","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10070734,"change_date":"2024-09-17 21:45:00","inspection_id":"82151717","insp_unit_id":"202982874","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"212","insp_unit_license":"DD94514","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBG5V1938F409407","insp_unit_decal":"Y","insp_unit_decal_number":"34302610","created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":6103293,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","dot_number":"2845665","report_state":"MI","report_number":"BALLB04741","insp_date":"2024-06-26 00:00:00","insp_start_time":"1410","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"BEAUBIEN @ WINDER","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NICK SALEM","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-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184021","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9472668,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373458","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4396125","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9472669,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373459","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4396125","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9472670,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373460","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4396125","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"},{"id":9472671,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373461","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201645921","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3939A"},{"id":9472672,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373462","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201645921","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3965B"},{"id":9472673,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373463","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201645921","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39345B2"},{"id":9472674,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373464","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201645921","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39345B2"},{"id":9472675,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_violation_id":"260373465","seq_no":"8","part_no":"392","part_no_section":"62(c)(2)","insp_viol_unit":"1","insp_unit_id":"201645921","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"39262C2"}],"inspection_per_units":[{"id":9830405,"change_date":"2024-06-28 21:39:00","inspection_id":"81993683","insp_unit_id":"201645921","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":6586139,"change_date":"2024-08-28 21:42:00","inspection_id":"82510281","dot_number":"2845665","report_state":"MI","report_number":"DAWDD03587","insp_date":"2024-06-22 00:00:00","insp_start_time":"1331","insp_end_time":"1423","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SD AT WOODWARD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SILVER SAND COACH","shipping_paper_number":"06222024","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-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192227","transaction_code":"A","transaction_date":"2024-06-22 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-08-28 21:42:00","snet_input_date":"2024-06-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-28 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:38.000000Z","updated_at":"2025-03-17T20:33:38.000000Z","inspection_violations":[{"id":10239589,"change_date":"2024-08-28 21:42:00","inspection_id":"82510281","insp_violation_id":"261466556","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202632246","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4376328","created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"3922"},{"id":10239590,"change_date":"2024-08-28 21:42:00","inspection_id":"82510281","insp_violation_id":"261466557","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"202632246","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:32.000000Z","updated_at":"2025-03-17T21:55:32.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10618013,"change_date":"2024-08-28 21:42:00","inspection_id":"82510281","insp_unit_id":"202632246","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"2102","insp_unit_license":"DE63947","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M9TRMPA14W062459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:58.000000Z","updated_at":"2025-03-17T23:32:58.000000Z"}]},{"id":5995630,"change_date":"2024-06-14 21:40:00","inspection_id":"81877693","dot_number":"2845665","report_state":"MI","report_number":"BALLB04705","insp_date":"2024-06-13 00:00:00","insp_start_time":"1204","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SD @ BRUSH","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MOBILE BOOGIE","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-06-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1182792","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","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":9300724,"change_date":"2024-06-14 21:40:00","inspection_id":"81877693","insp_violation_id":"260093441","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4393717","created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"3922"},{"id":9300725,"change_date":"2024-06-14 21:40:00","inspection_id":"81877693","insp_violation_id":"260093442","seq_no":"2","part_no":"393","part_no_section":"62(c)","insp_viol_unit":"1","insp_unit_id":"201402502","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:51:02.000000Z","updated_at":"2025-03-17T21:51:02.000000Z","normalized_code":"39362C"}],"inspection_per_units":[{"id":9656843,"change_date":"2024-06-14 21:40:00","inspection_id":"81877693","insp_unit_id":"201402502","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DE63945","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","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":5482504,"change_date":"2024-04-10 21:42:00","inspection_id":"81320077","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02208","insp_date":"2024-04-09 00:00:00","insp_start_time":"0945","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1172898","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8831501,"change_date":"2024-04-10 21:42:00","inspection_id":"81320077","insp_unit_id":"200336161","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"173","insp_unit_license":"DB21807","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BAANBBA9TFO69515","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":5447811,"change_date":"2024-04-05 21:40:00","inspection_id":"81281795","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02205","insp_date":"2024-04-04 00:00:00","insp_start_time":"1000","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1172128","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8775026,"change_date":"2024-04-05 21:40:00","inspection_id":"81281795","insp_unit_id":"200262955","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"175","insp_unit_license":"DC11383","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBKAK5F223401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":5447812,"change_date":"2024-04-05 21:40:00","inspection_id":"81281796","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02206","insp_date":"2024-04-04 00:00:00","insp_start_time":"1130","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"11024","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":"1172167","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8775027,"change_date":"2024-04-05 21:40:00","inspection_id":"81281796","insp_unit_id":"200262956","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"2404","insp_unit_license":"DD51535","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1C4RDHAG8K0769630","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":5435138,"change_date":"2024-04-04 21:42:00","inspection_id":"81268119","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02202","insp_date":"2024-04-02 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1171858","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-04 21:42:00","snet_input_date":"2024-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8754862,"change_date":"2024-04-04 21:42:00","inspection_id":"81268119","insp_unit_id":"200237879","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"217","insp_unit_license":"DD94479","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBXA34P213932","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5435139,"change_date":"2024-04-04 21:42:00","inspection_id":"81268120","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02203","insp_date":"2024-04-02 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1171497","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-04 21:42:00","snet_input_date":"2024-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8754863,"change_date":"2024-04-04 21:42:00","inspection_id":"81268120","insp_unit_id":"200237880","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"231","insp_unit_license":"DE61295","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBKA75P224991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5435140,"change_date":"2024-04-04 21:42:00","inspection_id":"81268121","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02204","insp_date":"2024-04-02 00:00:00","insp_start_time":"1130","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1171675","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-04 21:42:00","snet_input_date":"2024-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8754864,"change_date":"2024-04-04 21:42:00","inspection_id":"81268121","insp_unit_id":"200237881","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"THMS","insp_unit_company":"214","insp_unit_license":"DD94471","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1T7YT402481294588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5410622,"change_date":"2024-04-01 21:40:00","inspection_id":"81241140","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02200","insp_date":"2024-03-29 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1171466","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-03-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8714402,"change_date":"2024-04-01 21:40:00","inspection_id":"81241140","insp_unit_id":"200179779","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"DE63946","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"33686508","created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":5234693,"change_date":"2024-03-07 21:39:00","inspection_id":"81049540","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02164","insp_date":"2024-03-06 00:00:00","insp_start_time":"0900","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1168158","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8429235,"change_date":"2024-03-07 21:39:00","inspection_id":"81049540","insp_unit_id":"199805442","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"216","insp_unit_license":"DD9470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBPA6AP268659","insp_unit_decal":"Y","insp_unit_decal_number":"33686480","created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":5234694,"change_date":"2024-03-07 21:39:00","inspection_id":"81049541","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02165","insp_date":"2024-03-06 00:00:00","insp_start_time":"1010","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"36200","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":"1168177","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8429236,"change_date":"2024-03-07 21:39:00","inspection_id":"81049541","insp_unit_id":"199805443","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"BLUB","insp_unit_company":"215","insp_unit_license":"DD94478","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1BABNBXA84F213939","insp_unit_decal":"Y","insp_unit_decal_number":"33686481","created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":5234700,"change_date":"2024-03-07 21:39:00","inspection_id":"81049550","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02166","insp_date":"2024-03-06 00:00:00","insp_start_time":"1100","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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-03-07 21:39: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":"1168045","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8429246,"change_date":"2024-03-07 21:39:00","inspection_id":"81049550","insp_unit_id":"199805459","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2301","insp_unit_license":"DE63950","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA9JW068494","insp_unit_decal":"Y","insp_unit_decal_number":"33686482","created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":4803028,"change_date":"2024-01-10 21:44:00","inspection_id":"80577838","dot_number":"2845665","report_state":"MI","report_number":"PARLM02271","insp_date":"2024-01-08 00:00:00","insp_start_time":"1100","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SOARING EAGLE CASINO","county_code_state":"MI","county_code":"073","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":"2024-01-10 21:44: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":"1159908","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[{"id":7408729,"change_date":"2024-01-10 21:44:00","inspection_id":"80577838","insp_violation_id":"257274213","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198898636","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7727658,"change_date":"2024-01-10 21:44:00","inspection_id":"80577838","insp_unit_id":"198898636","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"2257","insp_unit_license":"RC29997","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"33686271","created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4803029,"change_date":"2024-01-10 21:44:00","inspection_id":"80577839","dot_number":"2845665","report_state":"MI","report_number":"PARLM02272","insp_date":"2024-01-08 00:00:00","insp_start_time":"1125","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"SOARING EAGLE CASINO","county_code_state":"MI","county_code":"073","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":"2024-01-10 21:44: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":"1159922","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[{"id":7408730,"change_date":"2024-01-10 21:44:00","inspection_id":"80577839","insp_violation_id":"257274214","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"198898637","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39375B"}],"inspection_per_units":[{"id":7727659,"change_date":"2024-01-10 21:44:00","inspection_id":"80577839","insp_unit_id":"198898637","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":"2255","insp_unit_license":"DE46848","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910PW105545","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4803075,"change_date":"2024-01-10 21:44:00","inspection_id":"80577892","dot_number":"2845665","report_state":"MI","report_number":"PARLM02273","insp_date":"2024-01-08 00:00:00","insp_start_time":"1230","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SOARING EAGLE CASINO","county_code_state":"MI","county_code":"073","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":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1160124","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[{"id":7408804,"change_date":"2024-01-10 21:44:00","inspection_id":"80577892","insp_violation_id":"257274320","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"198898732","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39348A"},{"id":7408805,"change_date":"2024-01-10 21:44:00","inspection_id":"80577892","insp_violation_id":"257274321","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198898732","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":7727736,"change_date":"2024-01-10 21:44:00","inspection_id":"80577892","insp_unit_id":"198898732","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"R-252","insp_unit_license":"DE63912","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMEA59W065374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4774732,"change_date":"2024-01-05 21:46:00","inspection_id":"80546873","dot_number":"2845665","report_state":"MI","report_number":"BROWP01767","insp_date":"2024-01-05 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 S\/B & EXIT 310","county_code_state":"MI","county_code":"031","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SOO INDIAN HOCKEY TEAM","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-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1159733","transaction_code":"A","transaction_date":"2024-01-05 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2024-01-05 21:46:00","snet_input_date":"2024-01-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[{"id":7367787,"change_date":"2024-01-05 21:46:00","inspection_id":"80546873","insp_violation_id":"257213206","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198838893","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3922"},{"id":7367788,"change_date":"2024-01-05 21:46:00","inspection_id":"80546873","insp_violation_id":"257213207","seq_no":"2","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:34.000000Z","updated_at":"2025-03-17T21:41:34.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":7681282,"change_date":"2024-01-05 21:46:00","inspection_id":"80546873","insp_unit_id":"198838893","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"18","insp_unit_license":"RC29996","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA9JW068495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"}]},{"id":4528118,"change_date":"2023-11-30 21:38:00","inspection_id":"80276861","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02054","insp_date":"2023-11-29 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-30 21:38: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":"1155214","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7282547,"change_date":"2023-11-30 21:38:00","inspection_id":"80276861","insp_unit_id":"198285054","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DD94515","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"Y","insp_unit_decal_number":"33397461","created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4528119,"change_date":"2023-11-30 21:38:00","inspection_id":"80276862","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02055","insp_date":"2023-11-29 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-30 21:38: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":"1155280","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7282548,"change_date":"2023-11-30 21:38:00","inspection_id":"80276862","insp_unit_id":"198285055","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2204","insp_unit_license":"RC29994","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"Y","insp_unit_decal_number":"33397462","created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4528120,"change_date":"2023-11-30 21:38:00","inspection_id":"80276863","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02056","insp_date":"2023-11-29 00:00:00","insp_start_time":"1230","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"37448","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":"1155143","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7282549,"change_date":"2023-11-30 21:38:00","inspection_id":"80276863","insp_unit_id":"198285056","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"TEMSA","insp_unit_company":"2202","insp_unit_license":"RC29995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NLTRPPX70G1000340","insp_unit_decal":"Y","insp_unit_decal_number":"33397463","created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4333187,"change_date":"2023-11-01 21:43:00","inspection_id":"80061918","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02024","insp_date":"2023-10-31 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-01 21:43: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":"1151694","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6968601,"change_date":"2023-11-01 21:43:00","inspection_id":"80061918","insp_unit_id":"197859174","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2302","insp_unit_license":"DE61332","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA7GW067466","insp_unit_decal":"Y","insp_unit_decal_number":"33397431","created_at":"2025-03-17T22:58:29.000000Z","updated_at":"2025-03-17T22:58:29.000000Z"}]},{"id":4333188,"change_date":"2023-11-01 21:43:00","inspection_id":"80061919","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02025","insp_date":"2023-10-31 00:00:00","insp_start_time":"1100","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-01 21:43: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":"1151779","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6968602,"change_date":"2023-11-01 21:43:00","inspection_id":"80061919","insp_unit_id":"197859175","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2256","insp_unit_license":"D61257","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAXFW067184","insp_unit_decal":"Y","insp_unit_decal_number":"33397432","created_at":"2025-03-17T22:58:29.000000Z","updated_at":"2025-03-17T22:58:29.000000Z"}]},{"id":4333189,"change_date":"2023-11-01 21:43:00","inspection_id":"80061920","dot_number":"2845665","report_state":"MI","report_number":"MDTRL02026","insp_date":"2023-10-31 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-11-01 21:43: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":"1151751","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-11-01 21:43:00","snet_input_date":"2023-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-01 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:45.000000Z","updated_at":"2025-03-17T19:48:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6968603,"change_date":"2023-11-01 21:43:00","inspection_id":"80061920","insp_unit_id":"197859176","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1801","insp_unit_license":"RC20748","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M9TRMPA14W062459","insp_unit_decal":"Y","insp_unit_decal_number":"33397433","created_at":"2025-03-17T22:58:29.000000Z","updated_at":"2025-03-17T22:58:29.000000Z"}]},{"id":3933915,"change_date":"2023-09-08 21:41:00","inspection_id":"79619442","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01946","insp_date":"2023-09-07 00:00:00","insp_start_time":"0930","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-09-08 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":"1144948","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6325542,"change_date":"2023-09-08 21:41:00","inspection_id":"79619442","insp_unit_id":"196968024","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2305","insp_unit_license":"DE63912","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMEA59W065374","insp_unit_decal":"Y","insp_unit_decal_number":"33030234","created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3933916,"change_date":"2023-09-08 21:41:00","inspection_id":"79619443","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01947","insp_date":"2023-09-07 00:00:00","insp_start_time":"1040","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-09-08 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":"1144886","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6325543,"change_date":"2023-09-08 21:41:00","inspection_id":"79619443","insp_unit_id":"196968025","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2306","insp_unit_license":"DE63913","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMEA4BW065727","insp_unit_decal":"Y","insp_unit_decal_number":"33030235","created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3845474,"change_date":"2023-08-30 21:45:00","inspection_id":"79520938","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01943","insp_date":"2023-08-25 00:00:00","insp_start_time":"1030","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-08-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37800","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":"1142796","transaction_code":"C","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6182704,"change_date":"2023-08-30 21:45:00","inspection_id":"79520938","insp_unit_id":"196815568","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2133","insp_unit_license":"DD51532","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M8RCM7A9SP047611","insp_unit_decal":"Y","insp_unit_decal_number":"33030231","created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":3845475,"change_date":"2023-08-30 21:45:00","inspection_id":"79520939","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01944","insp_date":"2023-08-25 00:00:00","insp_start_time":"1130","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-08-28 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":"1142778","transaction_code":"C","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-08-28 21:42:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-28 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:54.000000Z","updated_at":"2025-03-17T19:38:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6182705,"change_date":"2023-08-30 21:45:00","inspection_id":"79520939","insp_unit_id":"196815626","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"200","insp_unit_license":"DD51536","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBJ5V1907F419347","insp_unit_decal":"Y","insp_unit_decal_number":"33030232","created_at":"2025-03-17T22:51:56.000000Z","updated_at":"2025-03-17T22:51:56.000000Z"}]},{"id":3723271,"change_date":"2023-08-30 21:44:00","inspection_id":"79384374","dot_number":"2845665","report_state":"MI","report_number":"FRIZS02799","insp_date":"2023-08-11 00:00:00","insp_start_time":"1230","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W. ISABELLA RD @ COLEMAN RD","county_code_state":"MI","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","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-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1139749","transaction_code":"C","transaction_date":"2023-08-11 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5741178,"change_date":"2023-08-30 21:44:00","inspection_id":"79384374","insp_violation_id":"254984018","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":5986708,"change_date":"2023-08-30 21:44:00","inspection_id":"79384374","insp_unit_id":"196813510","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCI","insp_unit_company":null,"insp_unit_license":"DE61332","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA7GW067466","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3609690,"change_date":"2023-07-27 21:40:00","inspection_id":"79257227","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01902","insp_date":"2023-07-27 00:00:00","insp_start_time":"1030","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136888","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5803727,"change_date":"2023-07-27 21:40:00","inspection_id":"79257227","insp_unit_id":"196228898","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2101","insp_unit_license":"RC20751","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA5CW066004","insp_unit_decal":"Y","insp_unit_decal_number":"33030248","created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3609691,"change_date":"2023-07-27 21:40:00","inspection_id":"79257228","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01903","insp_date":"2023-07-27 00:00:00","insp_start_time":"1120","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136897","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5803728,"change_date":"2023-07-27 21:40:00","inspection_id":"79257228","insp_unit_id":"196228899","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2255","insp_unit_license":"RC20752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGD1W910PW105545","insp_unit_decal":"Y","insp_unit_decal_number":"33030141","created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3621200,"change_date":"2023-07-28 21:41:00","inspection_id":"79270110","dot_number":"2845665","report_state":"MI","report_number":"DAWDD02909","insp_date":"2023-07-27 00:00:00","insp_start_time":"1230","insp_end_time":"1248","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SD AT JOHN R","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SILVER SAND COACH BUS LLC","shipping_paper_number":"07272023","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-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","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":"1137312","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-07-28 21:41:00","snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:31.000000Z","updated_at":"2025-03-17T19:34:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5822149,"change_date":"2023-07-28 21:41:00","inspection_id":"79270110","insp_unit_id":"196254444","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2256","insp_unit_license":"RC20749","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAXFW067184","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:58.000000Z","updated_at":"2025-03-17T22:48:58.000000Z"}]},{"id":3107215,"change_date":"2023-05-22 21:41:00","inspection_id":"78691445","dot_number":"2845665","report_state":"MI","report_number":"GUTHG02362","insp_date":"2023-05-21 00:00:00","insp_start_time":"1046","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"KEWADIN CASINO PARKING","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BEYOND HORIZONS","shipping_paper_number":"BH521231","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1127236","transaction_code":"A","transaction_date":"2023-05-21 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-05-22 21:41:00","snet_input_date":"2023-05-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-22 21:41:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:34.000000Z","updated_at":"2025-03-17T19:24:34.000000Z","inspection_violations":[{"id":4779439,"change_date":"2023-05-22 21:41:00","inspection_id":"78691445","insp_violation_id":"252988755","seq_no":"1","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3958F1"},{"id":4779440,"change_date":"2023-05-22 21:41:00","inspection_id":"78691445","insp_violation_id":"252988756","seq_no":"2","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"1","insp_unit_id":"195067305","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":4997768,"change_date":"2023-05-22 21:41:00","inspection_id":"78691445","insp_unit_id":"195067305","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"NONE","insp_unit_license":"DD94543","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"}]},{"id":3053538,"change_date":"2023-05-16 21:42:00","inspection_id":"78631200","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01810","insp_date":"2023-05-15 00:00:00","insp_start_time":"1100","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-05-16 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":"1126148","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:24.000000Z","updated_at":"2025-03-17T19:23:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4912582,"change_date":"2023-05-16 21:42:00","inspection_id":"78631200","insp_unit_id":"194952458","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2304","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA9AW065516","insp_unit_decal":"Y","insp_unit_decal_number":"32659327","created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":3053539,"change_date":"2023-05-16 21:42:00","inspection_id":"78631201","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01811","insp_date":"2023-05-15 00:00:00","insp_start_time":"1200","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-05-16 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":"1126156","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-05-16 21:42:00","snet_input_date":"2023-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-16 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:24.000000Z","updated_at":"2025-03-17T19:23:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4912583,"change_date":"2023-05-16 21:42:00","inspection_id":"78631201","insp_unit_id":"194952459","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2302","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MGTRMEA3AW065519","insp_unit_decal":"Y","insp_unit_decal_number":"32659328","created_at":"2025-03-17T22:41:44.000000Z","updated_at":"2025-03-17T22:41:44.000000Z"}]},{"id":2976431,"change_date":"2023-05-05 21:42:00","inspection_id":"78544114","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01799","insp_date":"2023-05-04 00:00:00","insp_start_time":"1145","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-05-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":"1124926","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-05-05 21:42:00","snet_input_date":"2023-05-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:54.000000Z","updated_at":"2025-03-17T19:21:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4788648,"change_date":"2023-05-05 21:42:00","inspection_id":"78544114","insp_unit_id":"194775533","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"2212","insp_unit_license":"DD94514","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GBG5V1938F409407","insp_unit_decal":"Y","insp_unit_decal_number":"32659319","created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"}]},{"id":2767791,"change_date":"2023-04-11 12:04:00","inspection_id":"78307951","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01771","insp_date":"2023-04-06 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"37800","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":"1120969","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-04-11 12:04:00","snet_input_date":"2023-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4454844,"change_date":"2023-04-11 12:04:00","inspection_id":"78307951","insp_unit_id":"194304670","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2124","insp_unit_license":"DD51523","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M8RCM7A9SP047672","insp_unit_decal":"Y","insp_unit_decal_number":"32659293","created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"}]},{"id":2594574,"change_date":"2023-03-16 21:43:00","inspection_id":"78110622","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01753","insp_date":"2023-03-16 00:00:00","insp_start_time":"0930","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-03-16 21:43: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":"1118082","transaction_code":"A","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4176057,"change_date":"2023-03-16 21:43:00","inspection_id":"78110622","insp_unit_id":"193913267","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2301","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA9JW068495","insp_unit_decal":"Y","insp_unit_decal_number":"32321804","created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"}]},{"id":2594575,"change_date":"2023-03-16 21:43:00","inspection_id":"78110623","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01754","insp_date":"2023-03-16 00:00:00","insp_start_time":"1020","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2023-03-16 21:43: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":"1117741","transaction_code":"A","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4176058,"change_date":"2023-03-16 21:43:00","inspection_id":"78110623","insp_unit_id":"193913268","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VNHL","insp_unit_company":"2201","insp_unit_license":"DE46819","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"YE2CC1AB7E2048106","insp_unit_decal":"Y","insp_unit_decal_number":"32321805","created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"}]},{"id":1807184,"change_date":"2022-11-23 21:40:00","inspection_id":"77211574","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01625","insp_date":"2022-11-22 00:00:00","insp_start_time":"1055","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102979","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2907019,"change_date":"2022-11-23 21:40:00","inspection_id":"77211574","insp_unit_id":"192111070","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2102","insp_unit_license":"DD94515","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMDAX7W064307","insp_unit_decal":"Y","insp_unit_decal_number":"32003181","created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1807185,"change_date":"2022-11-23 21:40:00","inspection_id":"77211575","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01626","insp_date":"2022-11-22 00:00:00","insp_start_time":"1200","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103007","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2907020,"change_date":"2022-11-23 21:40:00","inspection_id":"77211575","insp_unit_id":"192111071","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2257","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBA1FW067185","insp_unit_decal":"Y","insp_unit_decal_number":"32003182","created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1807186,"change_date":"2022-11-23 21:40:00","inspection_id":"77211576","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01627","insp_date":"2022-11-22 00:00:00","insp_start_time":"1250","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103024","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2907021,"change_date":"2022-11-23 21:40:00","inspection_id":"77211576","insp_unit_id":"192111072","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2204","insp_unit_license":"DD94543","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M93JMEA98W064752","insp_unit_decal":"Y","insp_unit_decal_number":"32003183","created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1572506,"change_date":"2022-10-21 21:39:00","inspection_id":"76942279","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01565","insp_date":"2022-10-20 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2022-10-21 21:39: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":"1099253","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2530753,"change_date":"2022-10-21 21:39:00","inspection_id":"76942279","insp_unit_id":"191575986","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"1801","insp_unit_license":"DC27009","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M9TRMPA14W062459","insp_unit_decal":"Y","insp_unit_decal_number":"32003246","created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1572507,"change_date":"2022-10-21 21:39:00","inspection_id":"76942280","dot_number":"2845665","report_state":"MI","report_number":"MDTRL01566","insp_date":"2022-10-20 00:00:00","insp_start_time":"1045","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CARRIER FACILITY DECKERVILLE","county_code_state":"MI","county_code":"151","insp_level_id":"5","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":"2022-10-21 21:39: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":"1099286","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02845665","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"SILVER SAND COACH BUS LLC","insp_carrier_street":"3680 RANGE LINE RD","insp_carrier_city":"DECKERVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48427","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2530754,"change_date":"2022-10-21 21:39:00","inspection_id":"76942280","insp_unit_id":"191575987","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"2256","insp_unit_license":"DE61257","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2MG3JMBAXFW067184","insp_unit_decal":"Y","insp_unit_decal_number":"32003247","created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2845665\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2845665\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2845665\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/2845665\/inspections","per_page":100,"prev_page_url":null,"to":73,"total":73}