{"current_page":1,"data":[{"id":11683718,"change_date":"2026-04-17 21:41:00","inspection_id":"87609264","dot_number":"1949258","report_state":"MI","report_number":"DISCD02825","insp_date":"2026-04-16 00:00:00","insp_start_time":"1437","insp_end_time":"1452","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOLTON TWP","county_code_state":"MI","county_code":"121","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1266688","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2026-04-17 21:41:00","snet_input_date":"2026-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-17 21:41:00","insp_carrier_name":"RICK MANSFIELD AND SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:33:43.000000Z","updated_at":"2026-04-28T09:31:09.000000Z","inspection_violations":[{"id":20288275,"change_date":"2026-04-17 21:41:00","inspection_id":"87609264","insp_violation_id":"273679119","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":"2026-04-27T09:48:09.000000Z","updated_at":"2026-04-28T09:41:58.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":20314991,"change_date":"2026-04-17 21:41:00","inspection_id":"87609264","insp_unit_id":"213079162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE63426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X01R871092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:51.000000Z","updated_at":"2026-04-28T09:04:17.000000Z"},{"id":20314992,"change_date":"2026-04-17 21:41:00","inspection_id":"87609264","insp_unit_id":"213079163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTT","insp_unit_company":null,"insp_unit_license":"D946812","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JKLBG706KM016983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:51.000000Z","updated_at":"2026-04-28T09:04:17.000000Z"}]},{"id":8973038,"change_date":"2025-06-24 21:41:00","inspection_id":"85030446","dot_number":"1949258","report_state":"MI","report_number":"ROBEJ00722","insp_date":"2025-06-23 00:00:00","insp_start_time":"0810","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"1 MILE RD AT MCCLELLAND","county_code_state":"MI","county_code":"123","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":"2025-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","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":"1227033","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2025-06-24 21:41:00","snet_input_date":"2025-06-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-24 21:41:00","insp_carrier_name":"RICK MANSFIELD AND SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:53.000000Z","updated_at":"2025-06-28T10:00:53.000000Z","inspection_violations":[{"id":14418796,"change_date":"2025-06-24 21:41:00","inspection_id":"85030446","insp_violation_id":"267015117","seq_no":"1","part_no":"393","part_no_section":"87A-FPLA","insp_viol_unit":"2","insp_unit_id":"207530408","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:25.000000Z","updated_at":"2025-06-28T10:17:43.000000Z","normalized_code":"39387AFPLA"}],"inspection_per_units":[{"id":14711536,"change_date":"2025-06-24 21:41:00","inspection_id":"85030446","insp_unit_id":"207530407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHITE","insp_unit_license":"BC57991","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6JD481189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:38.000000Z","updated_at":"2025-06-28T09:45:53.000000Z"},{"id":14711537,"change_date":"2025-06-24 21:41:00","inspection_id":"85030446","insp_unit_id":"207530408","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ITCI","insp_unit_company":"RED","insp_unit_license":"D946812","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JKLBG706KM016983","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:38.000000Z","updated_at":"2025-06-28T09:45:53.000000Z"}]},{"id":8725381,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","dot_number":"1949258","report_state":"MI","report_number":"DISCD02633","insp_date":"2025-05-22 00:00:00","insp_start_time":"0803","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOLTON TWP","county_code_state":"MI","county_code":"121","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"216550","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222745","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"RICK MANSFIELD AND SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[{"id":13920465,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_violation_id":"266447659","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-05-26T10:29:07.000000Z","updated_at":"2025-05-27T10:26:20.000000Z","normalized_code":"3922SLLTL"},{"id":13920466,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_violation_id":"266447660","seq_no":"2","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"207042957","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-26T10:29:07.000000Z","updated_at":"2025-05-27T10:26:20.000000Z","normalized_code":"393130CCHVE"},{"id":13920467,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_violation_id":"266447661","seq_no":"3","part_no":"393","part_no_section":"106D-C","insp_viol_unit":"2","insp_unit_id":"207042957","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-26T10:29:07.000000Z","updated_at":"2025-05-27T10:26:20.000000Z","normalized_code":"393106DC"},{"id":13920468,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_violation_id":"266447662","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"207042956","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:07.000000Z","updated_at":"2025-05-27T10:26:20.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":14264159,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_unit_id":"207042956","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"WHT","insp_unit_license":"BC57991","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X6JD481189","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:25.000000Z"},{"id":14264160,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_unit_id":"207042957","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"BLK","insp_unit_license":"E914221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK5337P1042365","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:25.000000Z"},{"id":14264161,"change_date":"2025-05-23 21:39:00","inspection_id":"84767723","insp_unit_id":"207042958","insp_unit_type_id":"6","insp_unit_number":"3","insp_unit_make":"TALB","insp_unit_company":"BLK","insp_unit_license":"E914221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0510M1041449","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:25.000000Z"}]},{"id":7185292,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","dot_number":"1949258","report_state":"MI","report_number":"ROBEJ00562","insp_date":"2024-11-12 00:00:00","insp_start_time":"1110","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CEDAR ST AT STEWART AVE","county_code_state":"MI","county_code":"123","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28706","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1201370","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2024-11-13 21:40:00","snet_input_date":"2024-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-13 21:40:00","insp_carrier_name":"RICK MANSFIELD AND SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:59.000000Z","updated_at":"2025-03-17T20:45:59.000000Z","inspection_violations":[{"id":11228406,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","insp_violation_id":"262875314","seq_no":"1","part_no":"393","part_no_section":"130C-CHVE","insp_viol_unit":"2","insp_unit_id":"203863143","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"393130CCHVE"},{"id":11228407,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","insp_violation_id":"262875315","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"203863143","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"39343DBMA"},{"id":11228408,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","insp_violation_id":"262875316","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"203863143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:30.000000Z","updated_at":"2025-03-17T22:00:30.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":11589535,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","insp_unit_id":"203863142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"BC87195","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0W5HT9MED98162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"},{"id":11589536,"change_date":"2024-11-13 21:40:00","inspection_id":"83147283","insp_unit_id":"203863143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"BLACK","insp_unit_license":"E597561","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16V1C2728N2152168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:04.000000Z","updated_at":"2025-03-17T23:43:04.000000Z"}]},{"id":3479088,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","dot_number":"1949258","report_state":"MI","report_number":"DISCD02192","insp_date":"2023-07-10 00:00:00","insp_start_time":"1325","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MCCORMICK","county_code_state":"MI","county_code":"121","insp_level_id":"1","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64741","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1134638","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"RICK MANSFIELD & SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:45.000000Z","updated_at":"2025-03-17T19:31:45.000000Z","inspection_violations":[{"id":5363660,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","insp_violation_id":"253987135","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195934444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"},{"id":5363661,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","insp_violation_id":"253987136","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195934444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"},{"id":5363662,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","insp_violation_id":"253987137","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195934444","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3939A"},{"id":5363663,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","insp_violation_id":"253987138","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195934444","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5594396,"change_date":"2023-07-11 21:42:00","inspection_id":"79110789","insp_unit_id":"195934444","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"R1","insp_unit_license":"BC57990","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X8MM757205","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"}]},{"id":278435,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","dot_number":"1949258","report_state":"MI","report_number":"DISCD01927","insp_date":"2022-04-27 00:00:00","insp_start_time":"1312","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DAYTON TWP","county_code_state":"MI","county_code":"123","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","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":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"31620","viol_total":"12","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073674","transaction_code":"C","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01949258","upload_search_indicator":null,"census_search_date":"2022-04-28 21:39:00","snet_input_date":"2022-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"RICK MANSFIELD & SONS EXCAVATING LLC","insp_carrier_street":"5589 S MAPLE ISLAND RD","insp_carrier_city":"HESPERIA","insp_carrier_state":"MI","insp_carrier_zip_code":"49421","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:17.000000Z","updated_at":"2025-03-17T18:32:17.000000Z","inspection_violations":[{"id":431435,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330811","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3922"},{"id":431436,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330812","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"393104F3"},{"id":431437,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330813","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39343"},{"id":431438,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330814","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39617C"},{"id":431439,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330815","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":431440,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330816","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":431441,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330817","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189143552","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3939A"},{"id":431442,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330818","seq_no":"8","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189143551","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39395F"},{"id":431443,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330819","seq_no":"9","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189143551","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39395A"},{"id":431444,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330820","seq_no":"10","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189143551","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39617C"},{"id":431445,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330821","seq_no":"11","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189143551","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39021TB"},{"id":431446,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_violation_id":"246330822","seq_no":"12","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:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":450848,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_unit_id":"189143551","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"G6973G","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8W2BT0LED20138","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"},{"id":450849,"change_date":"2022-06-09 21:42:00","inspection_id":"75425243","insp_unit_id":"189143552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2028HL160165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1949258\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1949258\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1949258\/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\/1949258\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}