{"current_page":1,"data":[{"id":12398685,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","dot_number":"2057462","report_state":"MI","report_number":"MCKEN00425","insp_date":"2026-07-09 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"117","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2026-07-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"151000","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":"3715184","transaction_code":"A","transaction_date":"2026-07-09 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2026-07-09 21:41:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-09 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-13T09:39:18.000000Z","updated_at":"2026-07-20T09:30:58.000000Z","inspection_violations":[{"id":21574283,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_violation_id":"275374837","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214512265","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:30.000000Z","updated_at":"2026-07-20T09:44:23.000000Z","normalized_code":"3939ALIL"},{"id":21574284,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_violation_id":"275374838","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"214512265","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:30.000000Z","updated_at":"2026-07-20T09:44:23.000000Z","normalized_code":"3939ALLPL"},{"id":21574285,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_violation_id":"275374839","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214512265","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:30.000000Z","updated_at":"2026-07-20T09:44:23.000000Z","normalized_code":"39617CPI"},{"id":21574286,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_violation_id":"275374840","seq_no":"4","part_no":"390","part_no_section":"19A2","insp_viol_unit":"1","insp_unit_id":"214512264","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-13T09:55:30.000000Z","updated_at":"2026-07-20T09:44:23.000000Z","normalized_code":"39019A2"}],"inspection_per_units":[{"id":21539699,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_unit_id":"214512264","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"RED","insp_unit_license":"BE69799","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDTAPT6MN597710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:37.000000Z","updated_at":"2026-07-20T09:02:18.000000Z"},{"id":21539700,"change_date":"2026-07-09 21:41:00","inspection_id":"88355594","insp_unit_id":"214512265","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"28","insp_unit_license":"E367877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02433HF019103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-13T09:16:37.000000Z","updated_at":"2026-07-20T09:02:18.000000Z"}]},{"id":9971954,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","dot_number":"2057462","report_state":"MI","report_number":"ROBEJ00810","insp_date":"2025-10-16 00:00:00","insp_start_time":"0800","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LINCOLN ST AT FIRST ST","county_code_state":"MI","county_code":"117","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":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"34300","viol_total":"27","oos_total":"6","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"26","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246478","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:55.000000Z","updated_at":"2025-10-21T10:00:50.000000Z","inspection_violations":[{"id":16472331,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368598","seq_no":"27","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3963A1BOS"},{"id":16472332,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368599","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-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"38323A2LCDLN"},{"id":16472333,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368600","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39617CPI"},{"id":16472334,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368601","seq_no":"3","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":16472335,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368602","seq_no":"4","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALTSIR"},{"id":16472336,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368603","seq_no":"5","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALTSIR"},{"id":16472337,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368604","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALRLI"},{"id":16472338,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368605","seq_no":"7","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALLPL"},{"id":16472339,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368606","seq_no":"8","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALIL"},{"id":16472340,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368607","seq_no":"9","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39341BNPB"},{"id":16472341,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368608","seq_no":"10","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"209528906","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4598045","created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3922SLLSIV"},{"id":16472342,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368609","seq_no":"11","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39617CPI"},{"id":16472343,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368610","seq_no":"12","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39343DBMA"},{"id":16472344,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368611","seq_no":"13","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"393104F3C"},{"id":16472345,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368612","seq_no":"14","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3922SLLSR"},{"id":16472346,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368613","seq_no":"15","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALLPL"},{"id":16472347,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368614","seq_no":"16","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALTSI"},{"id":16472348,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368615","seq_no":"17","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALTSI"},{"id":16472349,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368616","seq_no":"18","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALSLI"},{"id":16472350,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368617","seq_no":"19","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"3939ALIL"},{"id":16472351,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368618","seq_no":"20","part_no":"393","part_no_section":"205C-WR","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"393205CWR"},{"id":16472352,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368619","seq_no":"21","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"},{"id":16472353,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368620","seq_no":"22","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"},{"id":16472354,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368621","seq_no":"23","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"},{"id":16472355,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368622","seq_no":"24","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"},{"id":16472356,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368623","seq_no":"25","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"},{"id":16472357,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_violation_id":"269368624","seq_no":"26","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"2","insp_unit_id":"209528907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39348ABISA"}],"inspection_per_units":[{"id":16557488,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_unit_id":"209528906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"WHITE","insp_unit_license":"BB01301","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD8W3H60BEB82456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"},{"id":16557489,"change_date":"2025-10-17 21:39:00","inspection_id":"86080642","insp_unit_id":"209528907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"BLACK","insp_unit_license":"E622513","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH2431N1266727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"}]},{"id":9807857,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","dot_number":"2057462","report_state":"MI","report_number":"FLOHC00706","insp_date":"2025-08-25 00:00:00","insp_start_time":"1435","insp_end_time":"1511","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M46 @ M91","county_code_state":"MI","county_code":"117","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":"2025-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1243793","transaction_code":"C","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:23.000000Z","updated_at":"2025-10-05T10:01:45.000000Z","inspection_violations":[{"id":16194272,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","insp_violation_id":"269057458","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209264059","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"3965BL"},{"id":16194273,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","insp_violation_id":"269057459","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209264059","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"3939ALHLI"},{"id":16194274,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","insp_violation_id":"269057460","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209264059","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"39617CPI"},{"id":16194275,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","insp_violation_id":"269057461","seq_no":"4","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"209264059","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:29.000000Z","updated_at":"2025-10-05T10:17:29.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":16307739,"change_date":"2025-10-02 21:42:00","inspection_id":"85907709","insp_unit_id":"209264059","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":null,"insp_unit_license":"BB76943","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZXEECB7YAG52436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:54.000000Z","updated_at":"2025-10-05T09:46:54.000000Z"}]},{"id":8468668,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","dot_number":"2057462","report_state":"MI","report_number":"PENNJ01101","insp_date":"2025-04-24 00:00:00","insp_start_time":"1440","insp_end_time":"1502","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRAVEL RIDGE RD @ DEANER RD","county_code_state":"MI","county_code":"117","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219253","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2025-04-25 21:36:00","snet_input_date":"2025-04-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-25 21:36:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-28T10:14:20.000000Z","updated_at":"2025-04-29T10:02:35.000000Z","inspection_violations":[{"id":13387308,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829226","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4512609","created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"39141AMCPC"},{"id":13387309,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829227","seq_no":"2","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"206490136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"39311A1LIL"},{"id":13387310,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829228","seq_no":"3","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"206490136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"39311A1LLPL"},{"id":13387311,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829229","seq_no":"4","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206490136","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"3939ALHLI"},{"id":13387312,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829230","seq_no":"5","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"206490136","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":13387313,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_violation_id":"265829231","seq_no":"6","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"206490136","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-28T10:36:14.000000Z","updated_at":"2025-04-29T10:24:05.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":13759444,"change_date":"2025-04-25 21:36:00","inspection_id":"84497223","insp_unit_id":"206490136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"BB97547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V5KC9GH66N433317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-28T10:04:44.000000Z","updated_at":"2025-04-29T09:56:32.000000Z"}]},{"id":8405402,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","dot_number":"2057462","report_state":"MI","report_number":"ROBEJ00650","insp_date":"2025-04-16 00:00:00","insp_start_time":"1000","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GOLF PORT AT BOGGIE DR","county_code_state":"MI","county_code":"107","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-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122320","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218010","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:37.000000Z","updated_at":"2025-04-21T10:23:59.000000Z","inspection_violations":[{"id":13260186,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686103","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3939ALHLI"},{"id":13260187,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686104","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3939ALHLI"},{"id":13260188,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686105","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"39378AWS"},{"id":13260189,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686106","seq_no":"4","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3939ALTSIR"},{"id":13260190,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686107","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4501421","created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3939ALSLI"},{"id":13260191,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686108","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"206368753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"39319"},{"id":13260192,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686109","seq_no":"7","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"206368754","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4501421","created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3939ALSLI"},{"id":13260193,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686110","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"206368754","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"3922SLLSR"},{"id":13260194,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_violation_id":"265686111","seq_no":"9","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"206368754","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4501421","created_at":"2025-04-20T11:00:02.000000Z","updated_at":"2025-04-20T11:08:51.000000Z","normalized_code":"393104BC"}],"inspection_per_units":[{"id":13646012,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_unit_id":"206368753","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WHITE","insp_unit_license":"BC32537","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJAEDR8DPFA4060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:15:59.000000Z","updated_at":"2025-04-21T10:04:47.000000Z"},{"id":13646013,"change_date":"2025-04-17 21:42:00","inspection_id":"84430572","insp_unit_id":"206368754","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"R AND","insp_unit_company":"RED","insp_unit_license":"C225477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1R9D24304P0011913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:15:59.000000Z","updated_at":"2025-04-21T10:04:47.000000Z"}]},{"id":7115547,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","dot_number":"2057462","report_state":"MI","report_number":"ROBEJ00553","insp_date":"2024-11-01 00:00:00","insp_start_time":"1315","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"JACKSON RD AT 10TH AVE","county_code_state":"MI","county_code":"107","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-11-04 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"142000","viol_total":"19","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1200497","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2024-11-04 21:40:00","snet_input_date":"2024-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-04 21:40:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:18.000000Z","updated_at":"2025-03-17T20:44:18.000000Z","inspection_violations":[{"id":11111956,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713587","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":11111957,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713588","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39021TB2DOT"},{"id":11111958,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713589","seq_no":"3","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"393203ACBP"},{"id":11111959,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713590","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922SLLIRP"},{"id":11111960,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713591","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39395A1"},{"id":11111961,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713592","seq_no":"6","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3939ALBL"},{"id":11111962,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713593","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347E"},{"id":11111963,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713594","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39353B"},{"id":11111964,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713595","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347E"},{"id":11111965,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713596","seq_no":"10","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347E"},{"id":11111966,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713597","seq_no":"11","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"393207ASUBL"},{"id":11111967,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713598","seq_no":"12","part_no":"396","part_no_section":"5B-HWSL","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3965BHWSL"},{"id":11111968,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713599","seq_no":"13","part_no":"393","part_no_section":"47A-BCFSAD","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347ABCFSAD"},{"id":11111969,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713600","seq_no":"14","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"203724497","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3963A1BOS"},{"id":11111970,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713601","seq_no":"15","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"203724498","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"3922SLLSR"},{"id":11111971,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713602","seq_no":"16","part_no":"393","part_no_section":"75B-TF","insp_viol_unit":"2","insp_unit_id":"203724498","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39375BTF"},{"id":11111972,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713603","seq_no":"17","part_no":"393","part_no_section":"75B-TF","insp_viol_unit":"2","insp_unit_id":"203724498","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39375BTF"},{"id":11111973,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713604","seq_no":"18","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"203724498","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39345DB"},{"id":11111974,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_violation_id":"262713605","seq_no":"19","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"2","insp_unit_id":"203724498","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:54.000000Z","updated_at":"2025-03-17T21:59:54.000000Z","normalized_code":"39347D2BLTBD"}],"inspection_per_units":[{"id":11476389,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_unit_id":"203724497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"BLUE","insp_unit_license":"BC62274","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSXHAET7YJ085819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"},{"id":11476390,"change_date":"2024-11-04 21:40:00","inspection_id":"83073527","insp_unit_id":"203724498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"SLIVER","insp_unit_license":"E367877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02433HF019103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:54.000000Z","updated_at":"2025-03-17T23:41:54.000000Z"}]},{"id":6261454,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","dot_number":"2057462","report_state":"MI","report_number":"FRIZS03051","insp_date":"2024-07-17 00:00:00","insp_start_time":"1255","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W EDGAR RD @ US131 S\/B","county_code_state":"MI","county_code":"117","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-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186563","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":"02057462","upload_search_indicator":null,"census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:58.000000Z","updated_at":"2025-03-17T20:26:58.000000Z","inspection_violations":[{"id":9725749,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863389","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39311"},{"id":9725750,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863390","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3939A"},{"id":9725751,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863391","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3965B"},{"id":9725752,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863392","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9725753,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863393","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39345B2"},{"id":9725754,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863394","seq_no":"6","part_no":"393","part_no_section":"209(c)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"393209C"},{"id":9725755,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863395","seq_no":"7","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"39019B2"},{"id":9725756,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_violation_id":"261863396","seq_no":"8","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"202978650","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3969D2"}],"inspection_per_units":[{"id":10088324,"change_date":"2024-09-17 21:45:00","inspection_id":"82163500","insp_unit_id":"202978650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"69","insp_unit_license":"BB76943","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZXEECB7YAG52436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":4227510,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","dot_number":"2057462","report_state":"MI","report_number":"AKERT00018","insp_date":"2023-10-17 00:00:00","insp_start_time":"1500","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M66 & M46","county_code_state":"MI","county_code":"117","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149815","transaction_code":"C","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2023-10-18 21:41:00","snet_input_date":"2023-10-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-18 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:37.000000Z","updated_at":"2025-03-17T19:46:37.000000Z","inspection_violations":[{"id":6544798,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963753","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197668360","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3939A"},{"id":6544799,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963754","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"197668360","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39395A"},{"id":6544800,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963755","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197668361","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"3922"},{"id":6544801,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963756","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197668361","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39311"},{"id":6544802,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963757","seq_no":"5","part_no":"393","part_no_section":"13(c)(3)","insp_viol_unit":"2","insp_unit_id":"197668361","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39313C3"},{"id":6544803,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_violation_id":"255963758","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"197668361","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:33.000000Z","updated_at":"2025-03-17T21:37:33.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":6798706,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_unit_id":"197668360","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"BLUE","insp_unit_license":"BC62274","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSXHAET7YJ085819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:59.000000Z","updated_at":"2025-03-17T22:56:59.000000Z"},{"id":6798707,"change_date":"2023-10-20 21:40:00","inspection_id":"79944953","insp_unit_id":"197668361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"28","insp_unit_license":"E367877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02433HF019103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:59.000000Z","updated_at":"2025-03-17T22:56:59.000000Z"}]},{"id":4184523,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","dot_number":"2057462","report_state":"MI","report_number":"FRIZS02841","insp_date":"2023-10-10 00:00:00","insp_start_time":"1231","insp_end_time":"1336","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LAKEVIEW RD @ LAKEVIEW BAR","county_code_state":"MI","county_code":"117","insp_level_id":"1","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-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"9","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149121","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[{"id":6478053,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803015","seq_no":"1","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:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3922"},{"id":6478054,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803016","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":"X4279863","created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3922"},{"id":6478055,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803017","seq_no":"3","part_no":"393","part_no_section":"60(e)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39360E"},{"id":6478056,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803018","seq_no":"4","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3969D2"},{"id":6478057,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803019","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3965B"},{"id":6478058,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803020","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39345B2"},{"id":6478059,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803021","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39345D"},{"id":6478060,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803022","seq_no":"8","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4279863","created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39019B2"},{"id":6478061,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_violation_id":"255803023","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197527513","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6729308,"change_date":"2023-10-12 21:41:00","inspection_id":"79897529","insp_unit_id":"197527513","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"69","insp_unit_license":"BB76943","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZXEECB7YAG52436","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":4070994,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","dot_number":"2057462","report_state":"MI","report_number":"ROBEJ00267","insp_date":"2023-09-26 00:00:00","insp_start_time":"0945","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"130TH AVE AT 5 MILE RD","county_code_state":"MI","county_code":"107","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":"2023-09-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122320","viol_total":"20","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"20","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147655","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2023-09-27 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-27 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:12.000000Z","updated_at":"2025-03-17T19:43:12.000000Z","inspection_violations":[{"id":6302330,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521520","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39360C"},{"id":6302331,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521521","seq_no":"2","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39343A"},{"id":6302332,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521522","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39347E"},{"id":6302333,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521523","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39353B"},{"id":6302334,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521524","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3939A"},{"id":6302335,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521525","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3939A"},{"id":6302336,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521526","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3939A"},{"id":6302337,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521527","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3939A"},{"id":6302338,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521528","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197272198","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39617C"},{"id":6302339,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521529","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39347E"},{"id":6302340,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521530","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39353B"},{"id":6302341,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521531","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39347E"},{"id":6302342,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521532","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39347E"},{"id":6302343,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521533","seq_no":"14","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39347E"},{"id":6302344,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521534","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3963A1"},{"id":6302345,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521535","seq_no":"16","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39375C"},{"id":6302346,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521536","seq_no":"17","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4280104","created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39375C"},{"id":6302347,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521537","seq_no":"18","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"39617C"},{"id":6302348,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521538","seq_no":"19","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3922"},{"id":6302349,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_violation_id":"255521539","seq_no":"20","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197272199","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:26.000000Z","updated_at":"2025-03-17T21:36:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6545478,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_unit_id":"197272198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"WHITE","insp_unit_license":"BC32537","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJAEDR8DPFA4060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"},{"id":6545479,"change_date":"2023-09-27 21:41:00","inspection_id":"79771805","insp_unit_id":"197272199","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"R&S","insp_unit_company":"RED","insp_unit_license":"C225477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1R9D24304P0011913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:57.000000Z","updated_at":"2025-03-17T22:54:57.000000Z"}]},{"id":3457292,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","dot_number":"2057462","report_state":"MI","report_number":"FRIZS02742","insp_date":"2023-07-06 00:00:00","insp_start_time":"1258","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N. YOUNGMAN RD @ W. EDGAR RD","county_code_state":"MI","county_code":"117","insp_level_id":"2","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-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1133977","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2023-07-07 21:41:00","snet_input_date":"2023-07-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5330190,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931818","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4248619","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39617C"},{"id":5330191,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931819","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3939A"},{"id":5330192,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931820","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39360C"},{"id":5330193,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931821","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3965B"},{"id":5330194,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931822","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3939A"},{"id":5330195,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931823","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"},{"id":5330196,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_violation_id":"253931824","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195884317","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5559239,"change_date":"2023-07-07 21:41:00","inspection_id":"79086325","insp_unit_id":"195884317","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"69","insp_unit_license":"BB76943","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZXEECB7YAG52436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":2709107,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","dot_number":"2057462","report_state":"MI","report_number":"PRIED02171","insp_date":"2023-03-30 00:00:00","insp_start_time":"0928","insp_end_time":"0939","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"KENDAVILLE @ M91","county_code_state":"MI","county_code":"117","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":"2023-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1119812","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2023-03-31 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-31 21:41:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:36.000000Z","updated_at":"2025-03-17T19:16:36.000000Z","inspection_violations":[{"id":4160968,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","insp_violation_id":"251987939","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:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"39141A1"},{"id":4160969,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","insp_violation_id":"251987940","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194171207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"3939A"},{"id":4160970,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","insp_violation_id":"251987941","seq_no":"3","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"194171207","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:31.000000Z","updated_at":"2025-03-17T21:26:31.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":4359854,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","insp_unit_id":"194171206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC62274","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HSXHAET7YJ085819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"},{"id":4359855,"change_date":"2023-03-31 21:41:00","inspection_id":"78241385","insp_unit_id":"194171207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E367877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02433HF019103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:19.000000Z","updated_at":"2025-03-17T22:37:19.000000Z"}]},{"id":1388418,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","dot_number":"2057462","report_state":"MI","report_number":"FRIZS02557","insp_date":"2022-09-27 00:00:00","insp_start_time":"1021","insp_end_time":"1131","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-46 W\/B @ CATCH 120","county_code_state":"MI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"10","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1096638","transaction_code":"A","transaction_date":"2022-09-27 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2022-09-28 21:40:00","snet_input_date":"2022-09-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:20.000000Z","updated_at":"2025-03-17T18:52:20.000000Z","inspection_violations":[{"id":2193042,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697935","seq_no":"1","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":"X4124838","created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"3922"},{"id":2193043,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697936","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":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"3922"},{"id":2193044,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697937","seq_no":"3","part_no":"390","part_no_section":"19(a)(1)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39019A1"},{"id":2193045,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697938","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39345D"},{"id":2193046,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697939","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39345D"},{"id":2193047,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697940","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"3965B"},{"id":2193048,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697941","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"3965B"},{"id":2193049,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697942","seq_no":"8","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39330"},{"id":2193050,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697943","seq_no":"9","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4124838","created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39375A3"},{"id":2193051,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_violation_id":"248697944","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"191147701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:02.000000Z","updated_at":"2025-03-17T21:17:02.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":2235840,"change_date":"2022-09-28 21:40:00","inspection_id":"76729157","insp_unit_id":"191147701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"BB97547","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V5KC9GH66N433317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:18.000000Z","updated_at":"2025-03-17T22:22:18.000000Z"}]},{"id":524274,"change_date":"2022-06-09 21:42:00","inspection_id":"75718088","dot_number":"2057462","report_state":"MI","report_number":"PRIED01825","insp_date":"2022-05-31 00:00:00","insp_start_time":"0832","insp_end_time":"0916","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"JACKSON @ 10TH","county_code_state":"MI","county_code":"107","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-06-01 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1077739","transaction_code":"C","transaction_date":"2022-05-31 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02057462","upload_search_indicator":null,"census_search_date":"2022-06-01 21:49:00","snet_input_date":"2022-05-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-01 21:49:00","insp_carrier_name":"PITCHER PERFECT EXCAVATING","insp_carrier_street":"10909 WATERWHEEL RD","insp_carrier_city":"LAKEVIEW","insp_carrier_state":"MI","insp_carrier_zip_code":"48850","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:01.000000Z","updated_at":"2025-03-17T18:37:01.000000Z","inspection_violations":[{"id":827761,"change_date":"2022-06-09 21:42:00","inspection_id":"75718088","insp_violation_id":"246340204","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"189151302","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"39323"},{"id":827762,"change_date":"2022-06-09 21:42:00","inspection_id":"75718088","insp_violation_id":"246340205","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189151302","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:56.000000Z","updated_at":"2025-03-17T21:10:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":843806,"change_date":"2022-06-09 21:42:00","inspection_id":"75718088","insp_unit_id":"189151301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BC32537","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJAEDR8DPFA4060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:24.000000Z","updated_at":"2025-03-17T22:13:24.000000Z"},{"id":843807,"change_date":"2022-06-09 21:42:00","inspection_id":"75718088","insp_unit_id":"189151302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"C225477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1R9D24304P0011913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:24.000000Z","updated_at":"2025-03-17T22:13:24.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2057462\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2057462\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2057462\/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\/2057462\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}