{"current_page":1,"data":[{"id":8155453,"change_date":"2025-03-19 21:41:00","inspection_id":"84167344","dot_number":"1983657","report_state":"MI","report_number":"EVANT02800","insp_date":"2025-03-18 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ ELDER RD","county_code_state":"MI","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","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-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"23500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213903","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-22T10:34:12.000000Z","updated_at":"2025-03-23T10:48:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13175466,"change_date":"2025-03-19 21:41:00","inspection_id":"84167344","insp_unit_id":"205879537","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"30","insp_unit_license":"EGA4023","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2GC2KREG8K1212147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:55.000000Z","updated_at":"2025-03-23T10:01:50.000000Z"},{"id":13175467,"change_date":"2025-03-19 21:41:00","inspection_id":"84167344","insp_unit_id":"205879538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":null,"insp_unit_license":"E730057","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW1U2025P1376665","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:05:55.000000Z","updated_at":"2025-03-23T10:01:50.000000Z"}]},{"id":8121723,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","dot_number":"1983657","report_state":"MI","report_number":"HINCA00617","insp_date":"2025-03-13 00:00:00","insp_start_time":"1610","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US-23 @ HURON AVE","county_code_state":"MI","county_code":"031","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34130","viol_total":"7","oos_total":"3","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213190","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2025-03-14 21:41:00","snet_input_date":"2025-03-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-14 21:41:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:07:03.000000Z","updated_at":"2025-03-17T21:07:03.000000Z","inspection_violations":[{"id":12699830,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051006","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4496312","created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"38323A2LCDL"},{"id":12699831,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051007","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39141A"},{"id":12699832,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051008","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"205812192","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39395A1"},{"id":12699833,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051009","seq_no":"4","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"205812192","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"39395F"},{"id":12699834,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051010","seq_no":"5","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205812193","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3939ALRLI"},{"id":12699835,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051011","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205812193","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"3939ALIL"},{"id":12699836,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_violation_id":"265051012","seq_no":"7","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"205812193","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4496312","created_at":"2025-03-17T22:08:10.000000Z","updated_at":"2025-03-17T22:08:10.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":13113313,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_unit_id":"205812192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"04","insp_unit_license":"DRR2137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GT12REGXHF137352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:58.000000Z","updated_at":"2025-03-17T23:59:58.000000Z"},{"id":13113314,"change_date":"2025-03-14 21:41:00","inspection_id":"84131840","insp_unit_id":"205812193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"F183508","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2822JL163118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:58.000000Z","updated_at":"2025-03-17T23:59:58.000000Z"}]},{"id":7805345,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","dot_number":"1983657","report_state":"MI","report_number":"BARTC02773","insp_date":"2025-02-05 00:00:00","insp_start_time":"1130","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ CROFTON","county_code_state":"MI","county_code":"079","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54999","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1209112","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2025-02-06 21:41:00","snet_input_date":"2025-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-06 21:41:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:19.000000Z","updated_at":"2025-03-17T21:00:19.000000Z","inspection_violations":[{"id":12197707,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378827","seq_no":"5","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205194574","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3939ALRLI"},{"id":12197708,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378828","seq_no":"6","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"205194574","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3939ALSLI"},{"id":12197709,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378829","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"205194574","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3939ALTSI"},{"id":12197710,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378830","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"205194573","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4467441","created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"39617CPI"},{"id":12197711,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378831","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205194573","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3939ALHLI"},{"id":12197712,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378832","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205194574","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"39617CPI"},{"id":12197713,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_violation_id":"264378833","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205194574","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12596571,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_unit_id":"205194573","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"41","insp_unit_license":"BD99972","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML2FL040296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:09.000000Z","updated_at":"2025-03-17T23:54:09.000000Z"},{"id":12596572,"change_date":"2025-02-06 21:41:00","inspection_id":"83799559","insp_unit_id":"205194574","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E919134","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF282XPL160458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:09.000000Z","updated_at":"2025-03-17T23:54:09.000000Z"}]},{"id":5447839,"change_date":"2024-04-05 21:40:00","inspection_id":"81281824","dot_number":"1983657","report_state":"MI","report_number":"KELLC02040","insp_date":"2024-04-04 00:00:00","insp_start_time":"0913","insp_end_time":"0919","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TORCH LAKE DR @ ALDEN HWY","county_code_state":"MI","county_code":"009","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1172249","transaction_code":"A","transaction_date":"2024-04-04 00:00:00","upload_date":"2024-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2024-04-05 21:40:00","snet_input_date":"2024-04-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-05 21:40:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:41.000000Z","updated_at":"2025-03-17T20:10:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8775072,"change_date":"2024-04-05 21:40:00","inspection_id":"81281824","insp_unit_id":"200263008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"41","insp_unit_license":"BC78639","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML2FL040296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:38.000000Z","updated_at":"2025-03-17T23:14:38.000000Z"}]},{"id":4134509,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","dot_number":"1983657","report_state":"MI","report_number":"HINCK00037","insp_date":"2023-10-04 00:00:00","insp_start_time":"1145","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BRAYTON RD NEAR LONG LAKE RD","county_code_state":"MI","county_code":"055","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-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"31810","viol_total":"7","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148621","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-10-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:29.000000Z","updated_at":"2025-03-17T19:44:29.000000Z","inspection_violations":[{"id":6399279,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679138","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3922"},{"id":6399280,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679139","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4271995","created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"38323A2"},{"id":6399281,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679140","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"197416910","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"39343"},{"id":6399282,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679141","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197416910","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3939A"},{"id":6399283,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679142","seq_no":"5","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"2","insp_unit_id":"197416910","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3969D2"},{"id":6399284,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679143","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197416910","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3963A1"},{"id":6399285,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_violation_id":"255679144","seq_no":"7","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"197416910","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4271995","created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":6647916,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_unit_id":"197416909","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"C8056313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GT49SE73RF217867","insp_unit_decal":"Y","insp_unit_decal_number":"33396660","created_at":"2025-03-17T22:55:46.000000Z","updated_at":"2025-03-17T22:55:46.000000Z"},{"id":6647917,"change_date":"2023-10-05 21:40:00","inspection_id":"79842330","insp_unit_id":"197416910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"T-14D","insp_unit_license":"E638421","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2428ML161951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:46.000000Z","updated_at":"2025-03-17T22:55:46.000000Z"}]},{"id":3811951,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","dot_number":"1983657","report_state":"MI","report_number":"ROLLJ02274","insp_date":"2023-08-22 00:00:00","insp_start_time":"1448","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB M37 @ CARL ST","county_code_state":"MI","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"82870","viol_total":"11","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1142036","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2023-08-23 21:40:00","snet_input_date":"2023-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:04.000000Z","updated_at":"2025-03-17T19:38:04.000000Z","inspection_violations":[{"id":5881853,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988645","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"393100B"},{"id":5881854,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988646","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"3939A"},{"id":5881855,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988647","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39345D"},{"id":5881856,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988648","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39347E"},{"id":5881857,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988649","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39353B"},{"id":5881858,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988650","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39347E"},{"id":5881859,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988651","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196816924","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4265358","created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"3963A1"},{"id":5881860,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988652","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196816925","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"39617C"},{"id":5881861,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988653","seq_no":"9","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"196816925","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"393100B"},{"id":5881862,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988654","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196816925","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"3939A"},{"id":5881863,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_violation_id":"254988655","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196816925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:24.000000Z","updated_at":"2025-03-17T21:34:24.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6128889,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_unit_id":"196816924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"10","insp_unit_license":"BB92033","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTHCATR01H351426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"},{"id":6128890,"change_date":"2023-08-30 21:45:00","inspection_id":"79483319","insp_unit_id":"196816925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E156346","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNFT2320JL160185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"}]},{"id":3706132,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","dot_number":"1983657","report_state":"MI","report_number":"OSHEE02084","insp_date":"2023-08-09 00:00:00","insp_start_time":"0854","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 @ SULLIVAN RD","county_code_state":"MI","county_code":"055","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"49999","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139179","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2023-08-09 21:42:00","snet_input_date":"2023-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-09 21:42:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5714057,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986697","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196815400","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3939A"},{"id":5714058,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986698","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196815400","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39617C"},{"id":5714059,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986699","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196815400","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3922"},{"id":5714060,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986700","seq_no":"4","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39343"},{"id":5714061,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986701","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3939A"},{"id":5714062,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986702","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39311"},{"id":5714063,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986703","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3939A"},{"id":5714064,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986704","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3922"},{"id":5714065,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986705","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39617C"},{"id":5714066,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_violation_id":"254986706","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196815401","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5958880,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_unit_id":"196815400","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC78639","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML2FL040296","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:04.000000Z","updated_at":"2025-03-17T22:50:04.000000Z"},{"id":5958881,"change_date":"2023-08-30 21:45:00","inspection_id":"79365345","insp_unit_id":"196815401","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTDE2322C1039561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:04.000000Z","updated_at":"2025-03-17T22:50:04.000000Z"}]},{"id":2909940,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","dot_number":"1983657","report_state":"MI","report_number":"FRIZS02706","insp_date":"2023-04-27 00:00:00","insp_start_time":"0935","insp_end_time":"1004","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"68TH ST @ M-37","county_code_state":"MI","county_code":"085","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-04-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"30835","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1123697","transaction_code":"A","transaction_date":"2023-04-27 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2023-04-27 21:43:00","snet_input_date":"2023-04-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-27 21:43:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:26.000000Z","updated_at":"2025-03-17T19:20:26.000000Z","inspection_violations":[{"id":4464172,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_violation_id":"252483511","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"38323A2"},{"id":4464173,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_violation_id":"252483512","seq_no":"2","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":"X4193449","created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"39141A1"},{"id":4464174,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_violation_id":"252483513","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194626540","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"39395A"},{"id":4464175,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_violation_id":"252483514","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194626541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:50.000000Z","updated_at":"2025-03-17T21:27:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4681524,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_unit_id":"194626540","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"DB77143","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC5KZCG2DZ225471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"},{"id":4681525,"change_date":"2023-04-27 21:43:00","inspection_id":"78468964","insp_unit_id":"194626541","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E638421","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2428ML161951","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:55.000000Z","updated_at":"2025-03-17T22:39:55.000000Z"}]},{"id":2316602,"change_date":"2023-02-07 21:41:00","inspection_id":"77793548","dot_number":"1983657","report_state":"MI","report_number":"ROLLJ02043","insp_date":"2023-02-07 00:00:00","insp_start_time":"0703","insp_end_time":"0716","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB M37 @ M55","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112577","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3568196,"change_date":"2023-02-07 21:41:00","inspection_id":"77793548","insp_violation_id":"250995792","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4167528","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3728607,"change_date":"2023-02-07 21:41:00","inspection_id":"77793548","insp_unit_id":"193274385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BB92033","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTHCATR01H351426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":309375,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","dot_number":"1983657","report_state":"MI","report_number":"BARTC01903","insp_date":"2022-05-02 00:00:00","insp_start_time":"1025","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ LARSON","county_code_state":"MI","county_code":"079","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"11200","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1074244","transaction_code":"C","transaction_date":"2022-05-03 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:57.000000Z","updated_at":"2025-03-17T18:32:57.000000Z","inspection_violations":[{"id":480523,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328695","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39141A"},{"id":480524,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328696","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141768","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"},{"id":480525,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328697","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141768","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4048370","created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"},{"id":480526,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328698","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141768","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"3939A"},{"id":480527,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328699","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189141768","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39617C"},{"id":480528,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_violation_id":"246328700","seq_no":"6","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189141768","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:21.000000Z","updated_at":"2025-03-17T21:09:21.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":500517,"change_date":"2022-06-09 21:42:00","inspection_id":"75462322","insp_unit_id":"189141768","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC88562","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDWF36LXYED61788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:17.000000Z","updated_at":"2025-03-17T22:11:17.000000Z"}]},{"id":43839,"change_date":"2022-03-25 21:31:00","inspection_id":"75141343","dot_number":"1983657","report_state":"MI","report_number":"DOWEM02029","insp_date":"2022-03-24 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ARBOR ST NEAR CEDAR","county_code_state":"MI","county_code":"079","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":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"50580","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1069121","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01983657","upload_search_indicator":null,"census_search_date":"2022-03-25 21:31:00","snet_input_date":"2022-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"DOUG'S UNDERGROUND SERVICE INC","insp_carrier_street":"2204 M-37 S","insp_carrier_city":"TRAVERSE CITY","insp_carrier_state":"MI","insp_carrier_zip_code":"49685","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[{"id":61700,"change_date":"2022-03-25 21:31:00","inspection_id":"75141343","insp_violation_id":"244782259","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"187825028","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":70694,"change_date":"2022-03-25 21:31:00","inspection_id":"75141343","insp_unit_id":"187825027","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BD02843","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDJ7C1316F431765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"},{"id":70695,"change_date":"2022-03-25 21:31:00","inspection_id":"75141343","insp_unit_id":"187825028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"D960029","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2822JL163118","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1983657\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1983657\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1983657\/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\/1983657\/inspections","per_page":100,"prev_page_url":null,"to":11,"total":11}