{"current_page":1,"data":[{"id":9911524,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","dot_number":"1252876","report_state":"MI","report_number":"WORDN05774","insp_date":"2025-10-09 00:00:00","insp_start_time":"0958","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"375000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245397","transaction_code":"C","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01252876","upload_search_indicator":null,"census_search_date":"2025-10-10 21:40:00","snet_input_date":"2025-10-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-10 21:40:00","insp_carrier_name":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-13T10:02:09.000000Z","updated_at":"2025-10-26T10:00:24.000000Z","inspection_violations":[{"id":16535785,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","insp_violation_id":"269452100","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:37.000000Z","normalized_code":"3922SLLTL"},{"id":16535786,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","insp_violation_id":"269452101","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"209601073","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:37.000000Z","normalized_code":"3922SLLUCR"},{"id":16535787,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","insp_violation_id":"269452102","seq_no":"3","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209601073","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-25T10:17:07.000000Z","updated_at":"2025-10-26T10:15:37.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":16614800,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","insp_unit_id":"209601073","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"GROVE","insp_unit_company":null,"insp_unit_license":"SME","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"W1T6993105V266451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:26.000000Z"},{"id":16614801,"change_date":"2025-10-22 21:39:00","inspection_id":"86016441","insp_unit_id":"209601074","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"NELS","insp_unit_company":null,"insp_unit_license":"SME","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1N9G62A38R1012583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:40.000000Z","updated_at":"2025-10-26T09:45:26.000000Z"}]},{"id":5700211,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","dot_number":"1252876","report_state":"MI","report_number":"BALLB04660","insp_date":"2024-05-07 00:00:00","insp_start_time":"1030","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"GRATIOT @ MICHIGAN","county_code_state":"MI","county_code":"147","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"10","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1177555","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01252876","upload_search_indicator":null,"census_search_date":"2024-05-08 21:42:00","snet_input_date":"2024-05-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-08 21:42:00","insp_carrier_name":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:50.000000Z","updated_at":"2025-03-17T20:15:50.000000Z","inspection_violations":[{"id":8817429,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385636","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39141A"},{"id":8817430,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385637","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":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3922"},{"id":8817431,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385638","seq_no":"3","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39324A"},{"id":8817432,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385639","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3939A"},{"id":8817433,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385640","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39311"},{"id":8817434,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385641","seq_no":"6","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4361669","created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39347B"},{"id":8817435,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385642","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39348A"},{"id":8817436,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385643","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"3963A1"},{"id":8817437,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385644","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39347E"},{"id":8817438,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_violation_id":"259385645","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200792056","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:37.000000Z","updated_at":"2025-03-17T21:48:37.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9181071,"change_date":"2024-05-08 21:42:00","inspection_id":"81557117","insp_unit_id":"200792056","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"44","insp_unit_license":"BC54235","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPADB0X83D802115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:27.000000Z","updated_at":"2025-03-17T23:18:27.000000Z"}]},{"id":4433142,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","dot_number":"1252876","report_state":"MI","report_number":"SCSJB00426","insp_date":"2023-11-14 00:00:00","insp_start_time":"1235","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COUNTY ROAD COMM MARYSVILLE","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","viol_total":"8","oos_total":"0","driver_viol_total":"6","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1153487","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01252876","upload_search_indicator":null,"census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:44.000000Z","updated_at":"2025-03-17T19:50:44.000000Z","inspection_violations":[{"id":6860817,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414685","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860818,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414686","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS04321","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860819,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414687","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS04321","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860820,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414688","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS04321","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860821,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414689","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS04321","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860822,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414690","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"23TS04321","created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860823,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414691","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198077566","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"3922"},{"id":6860824,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_violation_id":"256414692","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198077567","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7129226,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_unit_id":"198077566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD20498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X1DJ36063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:51.000000Z","updated_at":"2025-03-17T22:59:51.000000Z"},{"id":7129227,"change_date":"2023-11-15 21:41:00","inspection_id":"80172434","insp_unit_id":"198077567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E647750","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FS05131J1036285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:51.000000Z","updated_at":"2025-03-17T22:59:51.000000Z"}]},{"id":3621343,"change_date":"2023-07-28 21:41:00","inspection_id":"79270274","dot_number":"1252876","report_state":"MI","report_number":"POWED04300","insp_date":"2023-07-27 00:00:00","insp_start_time":"1250","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"180600","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":"1137430","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":"01252876","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":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","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":5822404,"change_date":"2023-07-28 21:41:00","inspection_id":"79270274","insp_unit_id":"196254761","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"N\/A","insp_unit_license":"BD20498","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X1DJ360635","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":5822405,"change_date":"2023-07-28 21:41:00","inspection_id":"79270274","insp_unit_id":"196254762","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"N\/A","insp_unit_license":"E647750","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FS05131J1036285","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":1254460,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","dot_number":"1252876","report_state":"MI","report_number":"BALLB03829","insp_date":"2022-09-09 00:00:00","insp_start_time":"1425","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"GRATIOT @ MICHIGAN","county_code_state":"MI","county_code":"147","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-11 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1094242","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01252876","upload_search_indicator":null,"census_search_date":"2022-09-11 21:30:00","snet_input_date":"2022-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-11 21:30:00","insp_carrier_name":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[{"id":1986112,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_violation_id":"248325425","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39216A"},{"id":1986113,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_violation_id":"248325426","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"190824193","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39378"},{"id":1986114,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_violation_id":"248325427","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190824193","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39617C"},{"id":1986115,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_violation_id":"248325428","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190824193","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39617C"},{"id":1986116,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_violation_id":"248325429","seq_no":"5","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4112625","created_at":"2025-03-17T21:16:09.000000Z","updated_at":"2025-03-17T21:16:09.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":2019181,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_unit_id":"190824192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E391042","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JWCK2935MP508391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"},{"id":2019182,"change_date":"2022-09-11 21:30:00","inspection_id":"76573434","insp_unit_id":"190824193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BB54611","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDT7H4C8XJ516361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"}]},{"id":265633,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","dot_number":"1252876","report_state":"MI","report_number":"BALLB03588","insp_date":"2022-04-26 00:00:00","insp_start_time":"1315","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD COMMISSION YARD","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","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":"1073577","transaction_code":"C","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01252876","upload_search_indicator":null,"census_search_date":"2022-04-27 21:40:00","snet_input_date":"2022-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-27 21:40:00","insp_carrier_name":"RAYMOND EXCAVATING CO","insp_carrier_street":"800 GRATIOT BLVD","insp_carrier_city":"MARYSVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48040","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:13.000000Z","updated_at":"2025-03-17T18:32:13.000000Z","inspection_violations":[{"id":408436,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","insp_violation_id":"246328762","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4041294","created_at":"2025-03-17T21:09:00.000000Z","updated_at":"2025-03-17T21:09:00.000000Z","normalized_code":"39141A"},{"id":408437,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","insp_violation_id":"246328763","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:00.000000Z","updated_at":"2025-03-17T21:09:00.000000Z","normalized_code":"3922"},{"id":408438,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","insp_violation_id":"246328764","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:00.000000Z","updated_at":"2025-03-17T21:09:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":429876,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","insp_unit_id":"189141819","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"6","insp_unit_license":"BC95544","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPADBTX95N846035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"},{"id":429877,"change_date":"2022-06-09 21:42:00","inspection_id":"75410078","insp_unit_id":"189141820","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"NONE","insp_unit_license":"E018851","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0419Y1018596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:50.000000Z","updated_at":"2025-03-17T22:10:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1252876\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1252876\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1252876\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1252876\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}