{"current_page":1,"data":[{"id":12221839,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","dot_number":"1233293","report_state":"MI","report_number":"BACZM03122","insp_date":"2026-06-18 00:00:00","insp_start_time":"0711","insp_end_time":"0759","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"3571080","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:36.000000Z","updated_at":"2026-06-26T09:35:47.000000Z","inspection_violations":[{"id":21272252,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991268","seq_no":"3","part_no":"393","part_no_section":"47A-BCFSAD","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39347ABCFSAD"},{"id":21272257,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991273","seq_no":"8","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39348ABIHE"},{"id":21272250,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991266","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39343DBMA"},{"id":21272251,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991267","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"3939ALSLIWR"},{"id":21272253,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991269","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"3963A1BOS"},{"id":21272254,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991270","seq_no":"5","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39348ABIHE"},{"id":21272255,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991271","seq_no":"6","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39348ABIHE"},{"id":21272256,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_violation_id":"274991272","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"214171041","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-21T10:04:51.000000Z","updated_at":"2026-06-26T09:51:35.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":21225871,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_unit_id":"214171040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE23111","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE7SDVY3513","insp_unit_decal":"Y","insp_unit_decal_number":"36396173","created_at":"2026-06-21T09:19:26.000000Z","updated_at":"2026-06-27T09:06:49.000000Z"},{"id":21225872,"change_date":"2026-06-18 21:41:00","inspection_id":"88179639","insp_unit_id":"214171041","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HOLE","insp_unit_company":null,"insp_unit_license":"C421714","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"12HTD3023LS103420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:26.000000Z","updated_at":"2026-06-27T09:06:49.000000Z"}]},{"id":12068287,"change_date":"2026-06-01 21:41:00","inspection_id":"88010351","dot_number":"1233293","report_state":"MI","report_number":"BACZM03081","insp_date":"2026-06-01 00:00:00","insp_start_time":"1156","insp_end_time":"1215","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3442505","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-06-01 21:41:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:07.000000Z","updated_at":"2026-06-12T09:31:15.000000Z","inspection_violations":[{"id":20998150,"change_date":"2026-06-01 21:41:00","inspection_id":"88010351","insp_violation_id":"274621800","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:55:49.000000Z","updated_at":"2026-06-12T09:42:20.000000Z","normalized_code":"3922SLLLR"},{"id":20998151,"change_date":"2026-06-01 21:41:00","inspection_id":"88010351","insp_violation_id":"274621801","seq_no":"2","part_no":"391","part_no_section":"41APC","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":"2026-06-05T09:55:49.000000Z","updated_at":"2026-06-12T09:42:20.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20973094,"change_date":"2026-06-01 21:41:00","inspection_id":"88010351","insp_unit_id":"213854121","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BB43848","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDD25HU36180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:40.000000Z","updated_at":"2026-06-12T09:02:47.000000Z"}]},{"id":12064493,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","dot_number":"1233293","report_state":"MI","report_number":"BACZM03079","insp_date":"2026-06-01 00:00:00","insp_start_time":"0727","insp_end_time":"0825","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":"OTH","hazmat_placard_req":"Y","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-06-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"3","hazmat_oos_total":"2","snet_sequence_id":"3440548","transaction_code":"A","transaction_date":"2026-06-01 00:00:00","upload_date":"2026-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-06-01 21:40:00","snet_input_date":"2026-06-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-01 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-05T09:39:00.000000Z","updated_at":"2026-06-12T09:30:40.000000Z","inspection_violations":[{"id":20992340,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_violation_id":"274610513","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:54:56.000000Z","updated_at":"2026-06-12T09:40:55.000000Z","normalized_code":"3958A1HOSP"},{"id":20992344,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_violation_id":"274610517","seq_no":"5","part_no":"172","part_no_section":"600C1-HMER","insp_viol_unit":"1","insp_unit_id":"213844982","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:54:56.000000Z","updated_at":"2026-06-12T09:40:55.000000Z","normalized_code":"172600C1HMER"},{"id":20992342,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_violation_id":"274610515","seq_no":"3","part_no":"177","part_no_section":"823A-HMPMCNP50%","insp_viol_unit":"1","insp_unit_id":"213844982","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-05T09:54:56.000000Z","updated_at":"2026-06-12T09:40:55.000000Z","normalized_code":"177823AHMPMCNP50%"},{"id":20992341,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_violation_id":"274610514","seq_no":"2","part_no":"391","part_no_section":"11B5-LNCDLNVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-05T09:54:56.000000Z","updated_at":"2026-06-12T09:40:55.000000Z","normalized_code":"39111B5LNCDLNVE"},{"id":20992343,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_violation_id":"274610516","seq_no":"4","part_no":"177","part_no_section":"817A-HMSP","insp_viol_unit":"1","insp_unit_id":"213844982","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-05T09:54:56.000000Z","updated_at":"2026-06-12T09:40:55.000000Z","normalized_code":"177817AHMSP"}],"inspection_per_units":[{"id":20967111,"change_date":"2026-06-01 21:40:00","inspection_id":"88006358","insp_unit_id":"213844982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE57232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ9X2TM228882","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-05T09:15:28.000000Z","updated_at":"2026-06-12T09:01:48.000000Z"}]},{"id":11501374,"change_date":"2026-03-27 21:40:00","inspection_id":"87421499","dot_number":"1233293","report_state":"MI","report_number":"BEAMW04776","insp_date":"2026-03-26 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ MAPLE","county_code_state":"MI","county_code":"145","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1264255","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:45.000000Z","updated_at":"2026-04-07T09:32:31.000000Z","inspection_violations":[{"id":19420898,"change_date":"2026-03-27 21:40:00","inspection_id":"87421499","insp_violation_id":"272692878","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:08.000000Z","updated_at":"2026-04-07T09:48:49.000000Z","normalized_code":"3922SLLS2"},{"id":19420899,"change_date":"2026-03-27 21:40:00","inspection_id":"87421499","insp_violation_id":"272692879","seq_no":"2","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:08.000000Z","updated_at":"2026-04-07T09:48:49.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":19703346,"change_date":"2026-03-27 21:40:00","inspection_id":"87421499","insp_unit_id":"212385010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"64","insp_unit_license":"BC06983","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GT2BEA65697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:26.000000Z","updated_at":"2026-04-07T09:08:55.000000Z"}]},{"id":11427720,"change_date":"2026-03-20 21:39:00","inspection_id":"87343845","dot_number":"1233293","report_state":"MI","report_number":"NESBA02632","insp_date":"2026-03-18 00:00:00","insp_start_time":"1745","insp_end_time":"1810","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"S I-75@DAVISBURG RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1263026","transaction_code":"A","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-23T09:46:35.000000Z","updated_at":"2026-03-31T09:31:13.000000Z","inspection_violations":[{"id":19277193,"change_date":"2026-03-20 21:39:00","inspection_id":"87343845","insp_violation_id":"272525220","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212242399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:40.000000Z","updated_at":"2026-03-31T09:49:32.000000Z","normalized_code":"3939ALIL"},{"id":19277194,"change_date":"2026-03-20 21:39:00","inspection_id":"87343845","insp_violation_id":"272525221","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"212242399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:40.000000Z","updated_at":"2026-03-31T09:49:32.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":19576001,"change_date":"2026-03-20 21:39:00","inspection_id":"87343845","insp_unit_id":"212242399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"260","insp_unit_license":"BE41755","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFC9JDJN5542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:03.000000Z","updated_at":"2026-03-31T09:10:42.000000Z"}]},{"id":11173437,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","dot_number":"1233293","report_state":"MI","report_number":"KOCHJ02319","insp_date":"2026-02-19 00:00:00","insp_start_time":"1030","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WADSWORTH RD @ IVANHOE RD","county_code_state":"MI","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259510","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-02-19 21:40:00","snet_input_date":"2026-02-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:38:04.000000Z","updated_at":"2026-03-02T10:31:04.000000Z","inspection_violations":[{"id":18730849,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","insp_violation_id":"271897355","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:33.000000Z","normalized_code":"3922SLLTL"},{"id":18730850,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","insp_violation_id":"271897356","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","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":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:33.000000Z","normalized_code":"3922SLLEWA1"},{"id":18730851,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","insp_violation_id":"271897357","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211713534","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:33.000000Z","normalized_code":"39395A4EEUS"},{"id":18730852,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","insp_violation_id":"271897358","seq_no":"4","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211713534","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:27.000000Z","updated_at":"2026-03-02T10:41:33.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":19068042,"change_date":"2026-02-19 21:40:00","inspection_id":"87089314","insp_unit_id":"211713534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"148","insp_unit_license":"BB83226","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY7EHFV7868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:28.000000Z","updated_at":"2026-03-02T10:03:58.000000Z"}]},{"id":10636048,"change_date":"2026-01-13 21:39:00","inspection_id":"86777200","dot_number":"1233293","report_state":"MI","report_number":"BEAMW04654","insp_date":"2026-01-13 00:00:00","insp_start_time":"1345","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ DODGE RD R\/A","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1256387","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2026-01-13 21:39:00","snet_input_date":"2026-01-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-13 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-16T10:36:01.000000Z","updated_at":"2026-01-24T10:30:38.000000Z","inspection_violations":[{"id":17890933,"change_date":"2026-01-13 21:39:00","inspection_id":"86777200","insp_violation_id":"271168428","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-16T10:42:03.000000Z","updated_at":"2026-01-24T10:31:11.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17839068,"change_date":"2026-01-13 21:39:00","inspection_id":"86777200","insp_unit_id":"211053126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"1","insp_unit_license":"C169713","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DTP86Z25VG051031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:12.000000Z"},{"id":17839067,"change_date":"2026-01-13 21:39:00","inspection_id":"86777200","insp_unit_id":"211053125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146","insp_unit_license":"BC43379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBC5CV97HX85854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-16T10:08:38.000000Z","updated_at":"2026-01-24T10:02:12.000000Z"}]},{"id":10518986,"change_date":"2026-01-05 21:37:00","inspection_id":"86654590","dot_number":"1233293","report_state":"MI","report_number":"BACZM02950","insp_date":"2025-12-23 00:00:00","insp_start_time":"1608","insp_end_time":"1619","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ DODGE RD RA","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"PER225145292602","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"187120","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":"1254781","transaction_code":"C","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-12-26 21:34:00","snet_input_date":"2025-12-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-26 21:34:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-29T10:36:16.000000Z","updated_at":"2026-01-16T10:30:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17705850,"change_date":"2026-01-05 21:37:00","inspection_id":"86654590","insp_unit_id":"210914664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BE14930","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X6SJ151930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:24.000000Z"},{"id":17705851,"change_date":"2026-01-05 21:37:00","inspection_id":"86654590","insp_unit_id":"210914665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"F176145","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FSK5333F1034195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:39.000000Z","updated_at":"2026-01-16T10:00:24.000000Z"}]},{"id":10333364,"change_date":"2025-12-02 21:39:00","inspection_id":"86460536","dot_number":"1233293","report_state":"MI","report_number":"KIRKB05356","insp_date":"2025-12-01 00:00:00","insp_start_time":"1350","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 & SPENCER","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"129270","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":"1252371","transaction_code":"A","transaction_date":"2025-12-01 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-12-02 21:39:00","snet_input_date":"2025-12-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-02 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:33.000000Z","updated_at":"2025-12-06T10:30:50.000000Z","inspection_violations":[{"id":17285887,"change_date":"2025-12-02 21:39:00","inspection_id":"86460536","insp_violation_id":"270404851","seq_no":"1","part_no":"392","part_no_section":"16-D","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-12-05T10:33:23.000000Z","updated_at":"2025-12-06T10:31:21.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":17258318,"change_date":"2025-12-02 21:39:00","inspection_id":"86460536","insp_unit_id":"210364817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"42","insp_unit_license":"BB96850","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FV4TWEB2YHF90776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:54.000000Z","updated_at":"2025-12-06T10:00:52.000000Z"},{"id":17258319,"change_date":"2025-12-02 21:39:00","inspection_id":"86460536","insp_unit_id":"210364818","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"42-TLR","insp_unit_license":"F019614","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC026212B088557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:54.000000Z","updated_at":"2025-12-06T10:00:52.000000Z"}]},{"id":10045836,"change_date":"2025-10-27 21:39:00","inspection_id":"86158390","dot_number":"1233293","report_state":"MI","report_number":"PATTM05269","insp_date":"2025-10-27 00:00:00","insp_start_time":"0755","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"34","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-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247822","transaction_code":"A","transaction_date":"2025-10-27 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-10-27 21:39:00","snet_input_date":"2025-10-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-30T10:00:46.000000Z","updated_at":"2025-11-01T10:01:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16692266,"change_date":"2025-10-27 21:39:00","inspection_id":"86158390","insp_unit_id":"209675466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE17645","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFEXJDJW6325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:52.000000Z","updated_at":"2025-10-31T09:46:16.000000Z"}]},{"id":9792882,"change_date":"2025-09-26 21:40:00","inspection_id":"85891882","dot_number":"1233293","report_state":"MI","report_number":"KOCHJ02161","insp_date":"2025-09-25 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB US-10 @ MACKINAW RD","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50810","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":"1243525","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:10.000000Z","updated_at":"2025-09-30T10:01:10.000000Z","inspection_violations":[{"id":16104789,"change_date":"2025-09-26 21:40:00","inspection_id":"85891882","insp_violation_id":"268952282","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","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-09-30T10:16:51.000000Z","updated_at":"2025-09-30T10:16:51.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":16229512,"change_date":"2025-09-26 21:40:00","inspection_id":"85891882","insp_unit_id":"209174039","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"248","insp_unit_license":"BE23111","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXFE7SDVY3513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:52.000000Z"},{"id":16229513,"change_date":"2025-09-26 21:40:00","inspection_id":"85891882","insp_unit_id":"209174040","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"TRA-20","insp_unit_license":"D960030","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT1623JL60002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:52.000000Z"}]},{"id":9322937,"change_date":"2025-08-04 21:39:00","inspection_id":"85398544","dot_number":"1233293","report_state":"MI","report_number":"MANIJ01943","insp_date":"2025-07-30 00:00:00","insp_start_time":"0838","insp_end_time":"0848","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"1233860","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:51.000000Z","updated_at":"2025-08-08T10:00:44.000000Z","inspection_violations":[{"id":15127754,"change_date":"2025-08-04 21:39:00","inspection_id":"85398544","insp_violation_id":"267823833","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-08-07T10:45:36.000000Z","updated_at":"2025-08-08T10:43:51.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":15353684,"change_date":"2025-08-04 21:39:00","inspection_id":"85398544","insp_unit_id":"208225305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD40595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDTF4GY7FEA42168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:53.000000Z"}]},{"id":9216969,"change_date":"2025-07-22 21:42:00","inspection_id":"85286913","dot_number":"1233293","report_state":"MI","report_number":"POWED05328","insp_date":"2025-07-21 00:00:00","insp_start_time":"1535","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 @ MIDDLEBELT","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"1231478","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:02.000000Z","inspection_violations":[{"id":14907670,"change_date":"2025-07-22 21:42:00","inspection_id":"85286913","insp_violation_id":"267573666","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:50.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":15158159,"change_date":"2025-07-22 21:42:00","inspection_id":"85286913","insp_unit_id":"208014066","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"BD85215","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT9PDA10116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"},{"id":15158160,"change_date":"2025-07-22 21:42:00","inspection_id":"85286913","insp_unit_id":"208014067","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"N\/A","insp_unit_license":"E566101","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH2028K1185264","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:07.000000Z"}]},{"id":9077924,"change_date":"2025-07-07 21:40:00","inspection_id":"85140838","dot_number":"1233293","report_state":"MI","report_number":"BEAMW04390","insp_date":"2025-07-03 00:00:00","insp_start_time":"1050","insp_end_time":"1103","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 S @ DIXIE","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NO BOL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"96000","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":"1228634","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:35.000000Z","updated_at":"2025-07-11T10:44:35.000000Z","inspection_violations":[{"id":14615695,"change_date":"2025-07-07 21:40:00","inspection_id":"85140838","insp_violation_id":"267238204","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4542283","created_at":"2025-07-10T10:42:40.000000Z","updated_at":"2025-07-11T10:46:00.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":14896958,"change_date":"2025-07-07 21:40:00","inspection_id":"85140838","insp_unit_id":"207730663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD70808","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP8LJ0X9RM643873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:55.000000Z"},{"id":14896959,"change_date":"2025-07-07 21:40:00","inspection_id":"85140838","insp_unit_id":"207730664","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PITTS","insp_unit_company":null,"insp_unit_license":"F093012","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JYTA2539RPP48616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:55.000000Z"}]},{"id":8910892,"change_date":"2025-06-16 21:39:00","inspection_id":"84964472","dot_number":"1233293","report_state":"MI","report_number":"MALIK03063","insp_date":"2025-06-16 00:00:00","insp_start_time":"0705","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1225753","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:24.000000Z","updated_at":"2025-06-20T10:00:30.000000Z","inspection_violations":[{"id":14288738,"change_date":"2025-06-16 21:39:00","inspection_id":"84964472","insp_violation_id":"266867615","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-06-19T10:15:34.000000Z","updated_at":"2025-06-20T10:15:52.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14600012,"change_date":"2025-06-16 21:39:00","inspection_id":"84964472","insp_unit_id":"207408593","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"NONE","insp_unit_license":"BE17407","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP2HJ7X1NM775002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:39.000000Z"}]},{"id":8354428,"change_date":"2025-04-11 21:40:00","inspection_id":"84376852","dot_number":"1233293","report_state":"MI","report_number":"MALIK02931","insp_date":"2025-04-10 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 13 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13500","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":"1217191","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:44.000000Z","updated_at":"2025-04-15T10:15:34.000000Z","inspection_violations":[{"id":13158116,"change_date":"2025-04-11 21:40:00","inspection_id":"84376852","insp_violation_id":"265571794","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-13T11:02:19.000000Z","updated_at":"2025-04-15T10:32:35.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13555307,"change_date":"2025-04-11 21:40:00","inspection_id":"84376852","insp_unit_id":"206270809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"110","insp_unit_license":"BC47217","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDE5C1226F428386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-14T10:17:03.000000Z","updated_at":"2025-04-15T10:02:43.000000Z"}]},{"id":8277322,"change_date":"2025-04-02 21:41:00","inspection_id":"84295756","dot_number":"1233293","report_state":"MI","report_number":"NESBA02038","insp_date":"2025-04-01 00:00:00","insp_start_time":"1530","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E M-59@SQUIRRIL RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"1215953","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-04-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:55.000000Z","updated_at":"2025-04-06T10:23:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13398652,"change_date":"2025-04-02 21:41:00","inspection_id":"84295756","insp_unit_id":"206122329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"BA93115","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4UZAAPDU78CZ49249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:13:08.000000Z","updated_at":"2025-04-06T10:00:59.000000Z"}]},{"id":8146538,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","dot_number":"1233293","report_state":"MI","report_number":"LPDAS00080","insp_date":"2025-03-18 00:00:00","insp_start_time":"0954","insp_end_time":"1026","registration_date":null,"region":"ET","ci_status_code":"C","location":"48150","location_desc":"LPD SCALES - 32600 GLENDALE","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"GRAVEL","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":"Y","pen_cen_match":null,"final_status_date":"2025-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213821","transaction_code":"A","transaction_date":"2025-03-18 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:34:39.000000Z","updated_at":"2025-03-22T10:36:31.000000Z","inspection_violations":[{"id":12749735,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","insp_violation_id":"265107934","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"205861619","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:45.000000Z","normalized_code":"393100BC"},{"id":12749736,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","insp_violation_id":"265107935","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"205861619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:45.000000Z","normalized_code":"3939AHLLH"},{"id":12749737,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","insp_violation_id":"265107936","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205861619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:45.000000Z","normalized_code":"3939ALIL"},{"id":12749738,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","insp_violation_id":"265107937","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"205861619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:59:53.000000Z","updated_at":"2025-03-21T11:13:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13158578,"change_date":"2025-03-18 21:40:00","inspection_id":"84157941","insp_unit_id":"205861619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"69","insp_unit_license":"BC56655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHBXAKX2HK14783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:07:01.000000Z","updated_at":"2025-03-22T10:00:01.000000Z"}]},{"id":7584045,"change_date":"2025-01-14 21:55:00","inspection_id":"83567017","dot_number":"1233293","report_state":"MI","report_number":"MALIK02760","insp_date":"2025-01-07 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B MOUND RD @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1206037","transaction_code":"C","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-01-09 21:40:00","snet_input_date":"2025-01-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[{"id":11854910,"change_date":"2025-01-14 21:55:00","inspection_id":"83567017","insp_violation_id":"263995225","seq_no":"1","part_no":"392","part_no_section":"16AD","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-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"39216AD"},{"id":11854911,"change_date":"2025-01-14 21:55:00","inspection_id":"83567017","insp_violation_id":"263995226","seq_no":"2","part_no":"391","part_no_section":"45A-MCEM","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-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"39145AMCEM"}],"inspection_per_units":[{"id":12236900,"change_date":"2025-01-14 21:55:00","inspection_id":"83567017","insp_unit_id":"204828149","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"185","insp_unit_license":"BD23997","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0X4GT5FED17797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7545609,"change_date":"2025-01-14 21:55:00","inspection_id":"83526580","dot_number":"1233293","report_state":"MI","report_number":"KOCHJ01796","insp_date":"2025-01-02 00:00:00","insp_start_time":"0920","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133900","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":"1205665","transaction_code":"C","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2025-01-03 21:39:00","snet_input_date":"2025-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-03 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:52.000000Z","updated_at":"2025-03-17T20:54:52.000000Z","inspection_violations":[{"id":11792301,"change_date":"2025-01-14 21:55:00","inspection_id":"83526580","insp_violation_id":"263996014","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","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-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":12174341,"change_date":"2025-01-14 21:55:00","inspection_id":"83526580","insp_unit_id":"204828796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"148","insp_unit_license":"BB83226","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY7EHFV7868","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:23.000000Z","updated_at":"2025-03-17T23:49:23.000000Z"},{"id":12174342,"change_date":"2025-01-14 21:55:00","inspection_id":"83526580","insp_unit_id":"204828797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"98","insp_unit_license":"E894311","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3721R1014572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:23.000000Z","updated_at":"2025-03-17T23:49:23.000000Z"}]},{"id":7473065,"change_date":"2024-12-20 21:40:00","inspection_id":"83450465","dot_number":"1233293","report_state":"MI","report_number":"MALIK02743","insp_date":"2024-12-19 00:00:00","insp_start_time":"0815","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ I-696","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","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":"1204980","transaction_code":"A","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[{"id":11679899,"change_date":"2024-12-20 21:40:00","inspection_id":"83450465","insp_violation_id":"263603095","seq_no":"1","part_no":"392","part_no_section":"16AD","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-17T22:02:50.000000Z","updated_at":"2025-03-17T22:02:50.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":12056265,"change_date":"2024-12-20 21:40:00","inspection_id":"83450465","insp_unit_id":"204505071","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"82","insp_unit_license":"BC06997","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCXDC26HW03936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"},{"id":12056266,"change_date":"2024-12-20 21:40:00","inspection_id":"83450465","insp_unit_id":"204505072","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HDSN","insp_unit_company":"62","insp_unit_license":"F156251","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"10HHTD1D431000204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:09.000000Z","updated_at":"2025-03-17T23:48:09.000000Z"}]},{"id":7462475,"change_date":"2024-12-19 21:41:00","inspection_id":"83439333","dot_number":"1233293","report_state":"MI","report_number":"MALIK02741","insp_date":"2024-12-18 00:00:00","insp_start_time":"1325","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B MOUND RD @ 15 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53000","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":"1204827","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-12-19 21:41:00","snet_input_date":"2024-12-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-19 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:54.000000Z","updated_at":"2025-03-17T20:51:54.000000Z","inspection_violations":[{"id":11661472,"change_date":"2024-12-19 21:41:00","inspection_id":"83439333","insp_violation_id":"263574629","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:48.000000Z","updated_at":"2025-03-17T22:02:48.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":12038943,"change_date":"2024-12-19 21:41:00","inspection_id":"83439333","insp_unit_id":"204481563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"151","insp_unit_license":"BC46618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXCY7GHHE4733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:56.000000Z","updated_at":"2025-03-17T23:47:56.000000Z"},{"id":12038944,"change_date":"2024-12-19 21:41:00","inspection_id":"83439333","insp_unit_id":"204481564","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRKG","insp_unit_company":"028","insp_unit_license":"A414331","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC024242B088488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:56.000000Z","updated_at":"2025-03-17T23:47:56.000000Z"}]},{"id":7220604,"change_date":"2024-11-18 21:41:00","inspection_id":"83184718","dot_number":"1233293","report_state":"MI","report_number":"NESBA01743","insp_date":"2024-11-15 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@PONTIAC SCALE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"222000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1201710","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[{"id":11284699,"change_date":"2024-11-18 21:41:00","inspection_id":"83184718","insp_violation_id":"262955418","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"3","insp_unit_id":"203935149","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:49.000000Z","updated_at":"2025-03-17T22:00:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11646862,"change_date":"2024-11-18 21:41:00","inspection_id":"83184718","insp_unit_id":"203935147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2021","insp_unit_license":"BD13575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9MJ443655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"},{"id":11646863,"change_date":"2024-11-18 21:41:00","inspection_id":"83184718","insp_unit_id":"203935148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"TR-32","insp_unit_license":"D295484","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2431GC036540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"},{"id":11646864,"change_date":"2024-11-18 21:41:00","inspection_id":"83184718","insp_unit_id":"203935149","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"TR-33","insp_unit_license":"D295485","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2036GC036541","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":7174659,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","dot_number":"1233293","report_state":"MI","report_number":"BALLB04980","insp_date":"2024-11-04 00:00:00","insp_start_time":"1121","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"LIVERNOIS @ JOHN KRONK","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","viol_total":"5","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1200671","transaction_code":"A","transaction_date":"2024-11-04 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11208983,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_violation_id":"262848905","seq_no":"5","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLSIV"},{"id":11208984,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_violation_id":"262848906","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4455517","created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39216AD"},{"id":11208985,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_violation_id":"262848907","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLDL"},{"id":11208986,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_violation_id":"262848908","seq_no":"3","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":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39141AMCPC"},{"id":11208987,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_violation_id":"262848909","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11572488,"change_date":"2024-11-12 21:42:00","inspection_id":"83136055","insp_unit_id":"203842094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"206","insp_unit_license":"BD49889","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF56F7YED40042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":6690464,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","dot_number":"1233293","report_state":"MI","report_number":"MANIJ01727","insp_date":"2024-09-09 00:00:00","insp_start_time":"1418","insp_end_time":"1522","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1194401","transaction_code":"C","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-09-10 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:40.000000Z","updated_at":"2025-03-17T20:35:40.000000Z","inspection_violations":[{"id":10413453,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_violation_id":"261868336","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4426149","created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39282A1"},{"id":10413454,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_violation_id":"261868337","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202982295","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"},{"id":10413455,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_violation_id":"261868338","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"202982296","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"393100B"},{"id":10413456,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_violation_id":"261868339","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"202982296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10787675,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_unit_id":"202982295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"85","insp_unit_license":"BA56436","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCXDC16HW03961","insp_unit_decal":"Y","insp_unit_decal_number":"34301318","created_at":"2025-03-17T23:34:41.000000Z","updated_at":"2025-03-17T23:34:41.000000Z"},{"id":10787676,"change_date":"2024-09-17 21:45:00","inspection_id":"82621519","insp_unit_id":"202982296","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"B968578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC02427KM092555","insp_unit_decal":"Y","insp_unit_decal_number":"34301319","created_at":"2025-03-17T23:34:41.000000Z","updated_at":"2025-03-17T23:34:41.000000Z"}]},{"id":6632207,"change_date":"2024-09-17 21:45:00","inspection_id":"82559621","dot_number":"1233293","report_state":"MI","report_number":"MALOJ01814","insp_date":"2024-08-29 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1193277","transaction_code":"C","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10316028,"change_date":"2024-09-17 21:45:00","inspection_id":"82559621","insp_violation_id":"261868250","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"202982216","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":10692729,"change_date":"2024-09-17 21:45:00","inspection_id":"82559621","insp_unit_id":"202982215","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"155","insp_unit_license":"BC52299","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT1DDBZ3516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10692730,"change_date":"2024-09-17 21:45:00","inspection_id":"82559621","insp_unit_id":"202982216","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"D960030","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4NKNUT1623JL60002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":6018644,"change_date":"2024-06-20 21:43:00","inspection_id":"81902542","dot_number":"1233293","report_state":"MI","report_number":"ELDEH00536","insp_date":"2024-06-18 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"3828 PATTERSON RD","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1183125","transaction_code":"C","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-06-18 21:43:00","snet_input_date":"2024-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-18 21:43:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:55.000000Z","updated_at":"2025-03-17T20:21:55.000000Z","inspection_violations":[{"id":9337919,"change_date":"2024-06-20 21:43:00","inspection_id":"81902542","insp_violation_id":"260216620","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4388187","created_at":"2025-03-17T21:51:09.000000Z","updated_at":"2025-03-17T21:51:09.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":9693868,"change_date":"2024-06-20 21:43:00","inspection_id":"81902542","insp_unit_id":"201510968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"144","insp_unit_license":"BC43366","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY1EHFV7901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:27.000000Z","updated_at":"2025-03-17T23:23:27.000000Z"}]},{"id":5523698,"change_date":"2024-04-16 21:41:00","inspection_id":"81364930","dot_number":"1233293","report_state":"MI","report_number":"BEAMW03751","insp_date":"2024-04-16 00:00:00","insp_start_time":"0805","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAGINAW BAY RD @ DELTA RD","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1173833","transaction_code":"A","transaction_date":"2024-04-16 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-04-16 21:41:00","snet_input_date":"2024-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8897671,"change_date":"2024-04-16 21:41:00","inspection_id":"81364930","insp_unit_id":"200422125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"64","insp_unit_license":"BC06983","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GT2BEA65697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":5234550,"change_date":"2024-03-07 21:39:00","inspection_id":"81049382","dot_number":"1233293","report_state":"MI","report_number":"BALLB04543","insp_date":"2024-03-06 00:00:00","insp_start_time":"1115","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S PARKER @ BELL","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"32576484","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":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1168129","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[{"id":8070760,"change_date":"2024-03-07 21:39:00","inspection_id":"81049382","insp_violation_id":"258262452","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"199805155","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":8428980,"change_date":"2024-03-07 21:39:00","inspection_id":"81049382","insp_unit_id":"199805154","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2021","insp_unit_license":"BD13575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9MJ443655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"},{"id":8428981,"change_date":"2024-03-07 21:39:00","inspection_id":"81049382","insp_unit_id":"199805155","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"NONE","insp_unit_license":"E9338821","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2436RC072193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":4803143,"change_date":"2024-01-10 21:44:00","inspection_id":"80577971","dot_number":"1233293","report_state":"MI","report_number":"JURKV02443","insp_date":"2024-01-08 00:00:00","insp_start_time":"1325","insp_end_time":"1341","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"140000","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":"1159925","transaction_code":"A","transaction_date":"2024-01-08 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2024-01-10 21:44:00","snet_input_date":"2024-01-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:00.000000Z","updated_at":"2025-03-17T19:58:00.000000Z","inspection_violations":[{"id":7408952,"change_date":"2024-01-10 21:44:00","inspection_id":"80577971","insp_violation_id":"257274506","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7727855,"change_date":"2024-01-10 21:44:00","inspection_id":"80577971","insp_unit_id":"198898877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2001","insp_unit_license":"BD40960","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X2YJ867201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"},{"id":7727856,"change_date":"2024-01-10 21:44:00","inspection_id":"80577971","insp_unit_id":"198898878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"32","insp_unit_license":"D295848","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2431GC036540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4668744,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","dot_number":"1233293","report_state":"IN","report_number":"9761001780","insp_date":"2023-12-18 00:00:00","insp_start_time":"1143","insp_end_time":"1235","registration_date":null,"region":"ES","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","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":"137811","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-12-20 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-20 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:23.000000Z","updated_at":"2025-03-17T19:55:23.000000Z","inspection_violations":[{"id":7216878,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974301","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"198586678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"39395A1"},{"id":7216879,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974302","seq_no":"6","part_no":"393","part_no_section":"45B2-B","insp_viol_unit":"1","insp_unit_id":"198586678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"39345B2B"},{"id":7216880,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974303","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"198586678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922SLLIRP"},{"id":7216881,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974304","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"198586679","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3939ALIL"},{"id":7216882,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974305","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"198586678","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3922SLLIFTA"},{"id":7216883,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_violation_id":"256974306","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"198586679","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:50.000000Z","updated_at":"2025-03-17T21:40:50.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":7509098,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_unit_id":"198586678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"177","insp_unit_license":"BD03151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPFDT9X27D666763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"},{"id":7509099,"change_date":"2023-12-20 21:41:00","inspection_id":"80431229","insp_unit_id":"198586679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"RTR9550","insp_unit_license":"SP747TSR","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532W38L114876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:07.000000Z","updated_at":"2025-03-17T23:03:07.000000Z"}]},{"id":4408830,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","dot_number":"1233293","report_state":"MI","report_number":"HINCA00067","insp_date":"2023-11-09 00:00:00","insp_start_time":"1450","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B HAMMOND RD @ 3 MILE RD","county_code_state":"MI","county_code":"055","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"126650","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1153000","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:17.000000Z","updated_at":"2025-03-17T19:50:17.000000Z","inspection_violations":[{"id":6821991,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","insp_violation_id":"256353219","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198024627","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"},{"id":6821992,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","insp_violation_id":"256353220","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198024626","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"},{"id":6821993,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","insp_violation_id":"256353221","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198024626","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:52.000000Z","updated_at":"2025-03-17T21:38:52.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7090408,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","insp_unit_id":"198024626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E742210","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF3626LL160198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"},{"id":7090409,"change_date":"2023-11-13 21:42:00","inspection_id":"80145742","insp_unit_id":"198024627","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC96007","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX13C9CM017111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"}]},{"id":4383903,"change_date":"2023-11-08 21:41:00","inspection_id":"80118164","dot_number":"1233293","report_state":"MI","report_number":"LITTJ04692","insp_date":"2023-11-07 00:00:00","insp_start_time":"1620","insp_end_time":"1635","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 S\/B @ BALDWIN","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1152607","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-11-08 21:41:00","snet_input_date":"2023-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:50.000000Z","updated_at":"2025-03-17T19:49:50.000000Z","inspection_violations":[{"id":6781823,"change_date":"2023-11-08 21:41:00","inspection_id":"80118164","insp_violation_id":"256291580","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:40.000000Z","updated_at":"2025-03-17T21:38:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7050391,"change_date":"2023-11-08 21:41:00","inspection_id":"80118164","insp_unit_id":"197970640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"NONE","insp_unit_license":"BD03151","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPFDT9X27D666763","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"},{"id":7050392,"change_date":"2023-11-08 21:41:00","inspection_id":"80118164","insp_unit_id":"197970641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"856R","insp_unit_license":"E789708","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1G41A962XLW170856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":4362571,"change_date":"2023-11-06 21:42:00","inspection_id":"80094230","dot_number":"1233293","report_state":"MI","report_number":"BARTC02439","insp_date":"2023-11-03 00:00:00","insp_start_time":"1200","insp_end_time":"1220","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":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1152316","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-11-06 21:42:00","snet_input_date":"2023-11-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:29.000000Z","updated_at":"2025-03-17T19:49:29.000000Z","inspection_violations":[{"id":6748418,"change_date":"2023-11-06 21:42:00","inspection_id":"80094230","insp_violation_id":"256237634","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"3922"},{"id":6748419,"change_date":"2023-11-06 21:42:00","inspection_id":"80094230","insp_violation_id":"256237635","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4289755","created_at":"2025-03-17T21:38:29.000000Z","updated_at":"2025-03-17T21:38:29.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":7016303,"change_date":"2023-11-06 21:42:00","inspection_id":"80094230","insp_unit_id":"197923674","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"152","insp_unit_license":"BC56654","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDRF3HT4LEC56845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:54.000000Z","updated_at":"2025-03-17T22:58:54.000000Z"},{"id":7016304,"change_date":"2023-11-06 21:42:00","inspection_id":"80094230","insp_unit_id":"197923675","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E566100","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2322ML160263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:54.000000Z","updated_at":"2025-03-17T22:58:54.000000Z"}]},{"id":4003437,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","dot_number":"1233293","report_state":"MI","report_number":"HINCK00004","insp_date":"2023-09-18 00:00:00","insp_start_time":"0930","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B US-131 @ M-72","county_code_state":"MI","county_code":"079","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":"2023-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53820","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1146549","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-09-19 21:40:00","snet_input_date":"2023-09-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-19 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:59.000000Z","updated_at":"2025-03-17T19:41:59.000000Z","inspection_violations":[{"id":6193102,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","insp_violation_id":"255348476","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197123654","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3939A"},{"id":6193103,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","insp_violation_id":"255348477","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197123653","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3939A"},{"id":6193104,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","insp_violation_id":"255348478","seq_no":"3","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"197123653","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4279560","created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":6437474,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","insp_unit_id":"197123653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"TRA44","insp_unit_license":"E356776","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2029EL161160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:03.000000Z","updated_at":"2025-03-17T22:54:03.000000Z"},{"id":6437475,"change_date":"2023-09-19 21:40:00","inspection_id":"79696553","insp_unit_id":"197123654","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TR44","insp_unit_license":"BA43352","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FDXF75R62MA01761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:03.000000Z","updated_at":"2025-03-17T22:54:03.000000Z"}]},{"id":3858914,"change_date":"2023-08-29 21:42:00","inspection_id":"79535922","dot_number":"1233293","report_state":"MI","report_number":"BESSJ00008","insp_date":"2023-08-29 00:00:00","insp_start_time":"1740","insp_end_time":"1820","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32500","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":"1143296","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5960376,"change_date":"2023-08-29 21:42:00","inspection_id":"79535922","insp_violation_id":"254954236","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4249940","created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6203967,"change_date":"2023-08-29 21:42:00","inspection_id":"79535922","insp_unit_id":"196789306","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"94","insp_unit_license":"BA96645","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT7HEC15785","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"},{"id":6203968,"change_date":"2023-08-29 21:42:00","inspection_id":"79535922","insp_unit_id":"196789307","insp_unit_type_id":"7","insp_unit_number":"2","insp_unit_make":"ROADC","insp_unit_company":"N\/A","insp_unit_license":"E674776","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2226N1251557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3789777,"change_date":"2023-08-30 21:45:00","inspection_id":"79458507","dot_number":"1233293","report_state":"MI","report_number":"MANIJ01416","insp_date":"2023-08-21 00:00:00","insp_start_time":"0808","insp_end_time":"0823","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"011","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1141294","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:41.000000Z","updated_at":"2025-03-17T19:37:41.000000Z","inspection_violations":[{"id":5844918,"change_date":"2023-08-30 21:45:00","inspection_id":"79458507","insp_violation_id":"254986648","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":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6093308,"change_date":"2023-08-30 21:45:00","inspection_id":"79458507","insp_unit_id":"196815341","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB43843","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF56P47EA57590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:11.000000Z","updated_at":"2025-03-17T22:51:11.000000Z"}]},{"id":3723477,"change_date":"2023-08-30 21:45:00","inspection_id":"79384599","dot_number":"1233293","report_state":"MI","report_number":"WERNR01240","insp_date":"2023-08-10 00:00:00","insp_start_time":"1105","insp_end_time":"1131","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MBA TOLLS","county_code_state":"MI","county_code":"097","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":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"34820","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139427","transaction_code":"C","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5741723,"change_date":"2023-08-30 21:45:00","inspection_id":"79384599","insp_violation_id":"254989897","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:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39141A"},{"id":5741724,"change_date":"2023-08-30 21:45:00","inspection_id":"79384599","insp_violation_id":"254989898","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"196817811","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":5987072,"change_date":"2023-08-30 21:45:00","inspection_id":"79384599","insp_unit_id":"196817811","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD17119","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRTCL9FG606556","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5987073,"change_date":"2023-08-30 21:45:00","inspection_id":"79384599","insp_unit_id":"196817812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E356776","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2029EL161160","insp_unit_decal":"Y","insp_unit_decal_number":"00","created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3674524,"change_date":"2023-08-29 21:42:00","inspection_id":"79330151","dot_number":"1233293","report_state":"MI","report_number":"BARTC02354","insp_date":"2023-08-03 00:00:00","insp_start_time":"1240","insp_end_time":"1258","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":"3","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":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39780","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":"1138198","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[{"id":5663911,"change_date":"2023-08-29 21:42:00","inspection_id":"79330151","insp_violation_id":"254954625","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:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":5907777,"change_date":"2023-08-29 21:42:00","inspection_id":"79330151","insp_unit_id":"196789654","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD29230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"CS247J154899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"},{"id":5907778,"change_date":"2023-08-29 21:42:00","inspection_id":"79330151","insp_unit_id":"196789655","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E356776","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNUT2029EL161160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3522333,"change_date":"2023-07-17 21:41:00","inspection_id":"79159118","dot_number":"1233293","report_state":"MI","report_number":"KELLC01860","insp_date":"2023-07-17 00:00:00","insp_start_time":"0855","insp_end_time":"0902","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131NB @ BLASKO 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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135757","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5663531,"change_date":"2023-07-17 21:41:00","inspection_id":"79159118","insp_unit_id":"196031941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"43","insp_unit_license":"BA47044","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FDNX65293MB02795","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3420981,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","dot_number":"1233293","report_state":"MI","report_number":"BALLB04228","insp_date":"2023-06-30 00:00:00","insp_start_time":"1515","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"TRI PARK @ DORT","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1133376","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-06-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:54.000000Z","updated_at":"2025-03-17T19:30:54.000000Z","inspection_violations":[{"id":5273257,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","insp_violation_id":"253837265","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"},{"id":5273258,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","insp_violation_id":"253837266","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"},{"id":5273259,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","insp_violation_id":"253837267","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4241641","created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"},{"id":5273260,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","insp_violation_id":"253837268","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5499886,"change_date":"2023-07-03 21:38:00","inspection_id":"79045262","insp_unit_id":"195799645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TR97","insp_unit_license":"BC47215","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZL40X8KJ252156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:23.000000Z","updated_at":"2025-03-17T22:46:23.000000Z"}]},{"id":3365224,"change_date":"2023-06-26 21:41:00","inspection_id":"78982668","dot_number":"1233293","report_state":"MI","report_number":"HADZM03753","insp_date":"2023-06-24 00:00:00","insp_start_time":"0715","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ WOODROOF","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","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":"1132186","transaction_code":"A","transaction_date":"2023-06-24 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-06-26 21:41:00","snet_input_date":"2023-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:44.000000Z","updated_at":"2025-03-17T19:29:44.000000Z","inspection_violations":[{"id":5188653,"change_date":"2023-06-26 21:41:00","inspection_id":"78982668","insp_violation_id":"253699414","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:05.000000Z","updated_at":"2025-03-17T21:31:05.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5409587,"change_date":"2023-06-26 21:41:00","inspection_id":"78982668","insp_unit_id":"195674301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"20165","insp_unit_license":"BD04829","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X0FD261666","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"},{"id":5409588,"change_date":"2023-06-26 21:41:00","inspection_id":"78982668","insp_unit_id":"195674302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"N\/A","insp_unit_license":"E270667","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2848MC052505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"}]},{"id":3118623,"change_date":"2023-05-23 21:42:00","inspection_id":"78704555","dot_number":"1233293","report_state":"MI","report_number":"LITTJ04456","insp_date":"2023-05-22 00:00:00","insp_start_time":"1655","insp_end_time":"1715","registration_date":null,"region":"ET","ci_status_code":"C","location":"210R3","location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"1127455","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-05-23 21:42:00","snet_input_date":"2023-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[{"id":4800600,"change_date":"2023-05-23 21:42:00","inspection_id":"78704555","insp_violation_id":"253022656","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":"X4219856","created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5016253,"change_date":"2023-05-23 21:42:00","inspection_id":"78704555","insp_unit_id":"195093249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2001","insp_unit_license":"BD40960","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X2YJ867201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"},{"id":5016254,"change_date":"2023-05-23 21:42:00","inspection_id":"78704555","insp_unit_id":"195093250","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"NONE","insp_unit_license":"E270667","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2848MC052505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":2749299,"change_date":"2023-04-06 21:40:00","inspection_id":"78287085","dot_number":"1233293","report_state":"MI","report_number":"MALIK01668","insp_date":"2023-04-06 00:00:00","insp_start_time":"0650","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B M-53 @ 28 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1120749","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[{"id":4219548,"change_date":"2023-04-06 21:40:00","inspection_id":"78287085","insp_violation_id":"252084901","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:42.000000Z","updated_at":"2025-03-17T21:26:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4425061,"change_date":"2023-04-06 21:40:00","inspection_id":"78287085","insp_unit_id":"194262697","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"166","insp_unit_license":"BC81223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HTMMAAN18N694323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:51.000000Z","updated_at":"2025-03-17T22:37:51.000000Z"}]},{"id":2594801,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","dot_number":"1233293","report_state":"MI","report_number":"SCSRN00459","insp_date":"2023-03-16 00:00:00","insp_start_time":"1411","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WADHAMS RD \/ RAVENSWOOD RD","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"10959","cargo_tank":null,"hazmat_placard_req":"Y","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-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1118120","transaction_code":"A","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-03-16 21:43:00","snet_input_date":"2023-03-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-16 21:43:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:30.000000Z","updated_at":"2025-03-17T19:14:30.000000Z","inspection_violations":[{"id":3990570,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_violation_id":"251707516","seq_no":"1","part_no":"392","part_no_section":"10(a)(3)","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:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39210A3"},{"id":3990571,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_violation_id":"251707517","seq_no":"2","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"2","insp_unit_id":"193913719","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"177823A"},{"id":3990572,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_violation_id":"251707518","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193913719","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"39617C"},{"id":3990573,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_violation_id":"251707519","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"193913719","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:43.000000Z","updated_at":"2025-03-17T21:25:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4176448,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_unit_id":"193913718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146","insp_unit_license":"BC43379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBC5CV97HX85854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"},{"id":4176449,"change_date":"2023-03-16 21:43:00","inspection_id":"78110872","insp_unit_id":"193913719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"856R","insp_unit_license":"E789708","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1G41A962XLW170856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:57.000000Z","updated_at":"2025-03-17T22:35:57.000000Z"}]},{"id":2585778,"change_date":"2023-03-15 21:42:00","inspection_id":"78100548","dot_number":"1233293","report_state":"MI","report_number":"BALLB04071","insp_date":"2023-03-14 00:00:00","insp_start_time":"1115","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"LAPEER @ WADHAMS","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-15 21:42: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":"1117548","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-03-15 21:42:00","snet_input_date":"2023-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-15 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:27.000000Z","updated_at":"2025-03-17T19:14:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4161932,"change_date":"2023-03-15 21:42:00","inspection_id":"78100548","insp_unit_id":"193890441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"104","insp_unit_license":"BB21348","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRLBL1EG228538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"},{"id":4161933,"change_date":"2023-03-15 21:42:00","inspection_id":"78100548","insp_unit_id":"193890442","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HHTC","insp_unit_company":"NONE","insp_unit_license":"E104544","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JWA11213KN518388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:50.000000Z","updated_at":"2025-03-17T22:35:50.000000Z"}]},{"id":2524474,"change_date":"2023-03-07 21:41:00","inspection_id":"78030584","dot_number":"1233293","report_state":"MI","report_number":"MALIK01611","insp_date":"2023-03-07 00:00:00","insp_start_time":"1040","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ ROCHESTER RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"1116395","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-03-07 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:18.000000Z","updated_at":"2025-03-17T19:13:18.000000Z","inspection_violations":[{"id":3881187,"change_date":"2023-03-07 21:41:00","inspection_id":"78030584","insp_violation_id":"251520919","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:15.000000Z","updated_at":"2025-03-17T21:25:15.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4063241,"change_date":"2023-03-07 21:41:00","inspection_id":"78030584","insp_unit_id":"193748713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"86","insp_unit_license":"BB83242","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVAC3BS19HAE1976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:07.000000Z","updated_at":"2025-03-17T22:35:07.000000Z"},{"id":4063242,"change_date":"2023-03-07 21:41:00","inspection_id":"78030584","insp_unit_id":"193748714","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROAD","insp_unit_company":"NONE","insp_unit_license":"D479617","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5Z0BP3226GP009237","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:07.000000Z","updated_at":"2025-03-17T22:35:07.000000Z"}]},{"id":2559233,"change_date":"2023-04-26 21:41:00","inspection_id":"78070004","dot_number":"1233293","report_state":"FL","report_number":"1647005224","insp_date":"2023-03-06 00:00:00","insp_start_time":"1251","insp_end_time":"1309","registration_date":null,"region":"ET","ci_status_code":"C","location":"105N","location_desc":"I75 WHITE SPRINGS WIM-NORTH","county_code_state":"FL","county_code":"047","insp_level_id":"2","service_center":"SH","census_source_id":"4","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":"I","final_status_date":"2023-03-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2486419","transaction_code":"C","transaction_date":"2023-04-24 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-03-13 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-03-13 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:45.000000Z","updated_at":"2025-03-17T19:13:45.000000Z","inspection_violations":[{"id":3937111,"change_date":"2023-04-26 21:41:00","inspection_id":"78070004","insp_violation_id":"252446053","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194589240","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000728447","created_at":"2025-03-17T21:25:27.000000Z","updated_at":"2025-03-17T21:25:27.000000Z","normalized_code":"3922"},{"id":3937112,"change_date":"2023-04-26 21:41:00","inspection_id":"78070004","insp_violation_id":"252446054","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194589240","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00728447","created_at":"2025-03-17T21:25:27.000000Z","updated_at":"2025-03-17T21:25:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4118946,"change_date":"2023-04-26 21:41:00","inspection_id":"78070004","insp_unit_id":"194589240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1HTMSAAR37H497235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:31.000000Z","updated_at":"2025-03-17T22:35:31.000000Z"}]},{"id":2388731,"change_date":"2023-02-16 21:41:00","inspection_id":"77876229","dot_number":"1233293","report_state":"MI","report_number":"MALIK01585","insp_date":"2023-02-15 00:00:00","insp_start_time":"0735","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 13 MILE RD","county_code_state":"MI","county_code":"099","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":"2023-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114107","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:43.000000Z","updated_at":"2025-03-17T19:10:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3843608,"change_date":"2023-02-16 21:41:00","inspection_id":"77876229","insp_unit_id":"193439630","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"193","insp_unit_license":"BD29090","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDM7H1C2YJ520173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:31.000000Z","updated_at":"2025-03-17T22:33:31.000000Z"}]},{"id":2369459,"change_date":"2023-02-14 21:41:00","inspection_id":"77854048","dot_number":"1233293","report_state":"MI","report_number":"PRIED02124","insp_date":"2023-02-13 00:00:00","insp_start_time":"1000","insp_end_time":"1032","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LEROY RD @ PENESAL RD","county_code_state":"MI","county_code":"133","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40320","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1113952","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3648434,"change_date":"2023-02-14 21:41:00","inspection_id":"77854048","insp_violation_id":"251130185","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":"X4168207","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"38323A2"},{"id":3648435,"change_date":"2023-02-14 21:41:00","inspection_id":"77854048","insp_violation_id":"251130186","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":"X4168207","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":3812833,"change_date":"2023-02-14 21:41:00","inspection_id":"77854048","insp_unit_id":"193394577","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD29230","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT7HED32703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3812834,"change_date":"2023-02-14 21:41:00","inspection_id":"77854048","insp_unit_id":"193394578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"E356776","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2KNUT2029EL161160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2333005,"change_date":"2023-02-09 21:39:00","inspection_id":"77812107","dot_number":"1233293","report_state":"FL","report_number":"2594001253","insp_date":"2023-02-01 00:00:00","insp_start_time":"1530","insp_end_time":"1543","registration_date":null,"region":"ET","ci_status_code":"C","location":"105N","location_desc":"I75 WHITE SPRINGS WIM-NORTH","county_code_state":"FL","county_code":"047","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"2475131","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-02-09 21:39:00","snet_input_date":"2023-02-02 00:00:00","source_office":"2FLS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:39.000000Z","updated_at":"2025-03-17T19:09:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3754019,"change_date":"2023-02-09 21:39:00","inspection_id":"77812107","insp_unit_id":"193310255","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1577","insp_unit_license":"DHZ9728","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1HTMSAZR69H141577","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:53.000000Z","updated_at":"2025-03-17T22:32:53.000000Z"}]},{"id":2193457,"change_date":"2023-01-20 21:41:00","inspection_id":"77653636","dot_number":"1233293","report_state":"MI","report_number":"KOCHJ01041","insp_date":"2023-01-19 00:00:00","insp_start_time":"1810","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-46 @ SHERIDAN RD","county_code_state":"MI","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1110036","transaction_code":"A","transaction_date":"2023-01-19 00:00:00","upload_date":"2023-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2023-01-20 21:41:00","snet_input_date":"2023-01-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-20 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:59.000000Z","updated_at":"2025-03-17T19:06:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3530383,"change_date":"2023-01-20 21:41:00","inspection_id":"77653636","insp_unit_id":"192985468","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"197","insp_unit_license":"BD25533","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDLU9X26R117842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:20.000000Z","updated_at":"2025-03-17T22:31:20.000000Z"}]},{"id":1842946,"change_date":"2022-11-30 21:40:00","inspection_id":"77252315","dot_number":"1233293","report_state":"MI","report_number":"EVANT02060","insp_date":"2022-11-30 00:00:00","insp_start_time":"1050","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 @ M119","county_code_state":"MI","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116700","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103863","transaction_code":"A","transaction_date":"2022-11-30 00:00:00","upload_date":"2022-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-11-30 21:40:00","snet_input_date":"2022-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-30 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:42.000000Z","updated_at":"2025-03-17T19:00:42.000000Z","inspection_violations":[{"id":2874566,"change_date":"2022-11-30 21:40:00","inspection_id":"77252315","insp_violation_id":"249850805","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"192192903","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"39311"},{"id":2874567,"change_date":"2022-11-30 21:40:00","inspection_id":"77252315","insp_violation_id":"249850806","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192192902","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:39.000000Z","updated_at":"2025-03-17T21:20:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2965197,"change_date":"2022-11-30 21:40:00","inspection_id":"77252315","insp_unit_id":"192192902","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"170","insp_unit_license":"BC96007","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX13C9CM017111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"},{"id":2965198,"change_date":"2022-11-30 21:40:00","inspection_id":"77252315","insp_unit_id":"192192903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BELH","insp_unit_company":null,"insp_unit_license":"D154187","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16JF02020W1031216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:18.000000Z","updated_at":"2025-03-17T22:27:18.000000Z"}]},{"id":1707791,"change_date":"2022-11-09 21:40:00","inspection_id":"77097448","dot_number":"1233293","report_state":"MI","report_number":"KIRKB03828","insp_date":"2022-11-08 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B KENSINGTON & I-96","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"60042007","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-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"1101500","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675980,"change_date":"2022-11-09 21:40:00","inspection_id":"77097448","insp_violation_id":"249519132","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":2747379,"change_date":"2022-11-09 21:40:00","inspection_id":"77097448","insp_unit_id":"191883715","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"62","insp_unit_license":"BC66985","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4TX9MJ458752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1658766,"change_date":"2022-11-02 21:40:00","inspection_id":"77041175","dot_number":"1233293","report_state":"MI","report_number":"KELLC01678","insp_date":"2022-11-01 00:00:00","insp_start_time":"1148","insp_end_time":"1201","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131SB @ ELDER ST","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":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1100746","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-11-02 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-02 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:06.000000Z","updated_at":"2025-03-17T18:57:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2668762,"change_date":"2022-11-02 21:40:00","inspection_id":"77041175","insp_unit_id":"191774148","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"152","insp_unit_license":"BC56654","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDRF3HT4LEC56845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"},{"id":2668763,"change_date":"2022-11-02 21:40:00","inspection_id":"77041175","insp_unit_id":"191774149","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"NONE","insp_unit_license":"E566100","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNBF2322ML160263","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"}]},{"id":1179639,"change_date":"2022-08-31 21:42:00","inspection_id":"76487094","dot_number":"1233293","report_state":"MI","report_number":"EVANT01977","insp_date":"2022-08-30 00:00:00","insp_start_time":"1755","insp_end_time":"1810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32 NEAR US 131","county_code_state":"MI","county_code":"009","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"46300","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":"1092323","transaction_code":"A","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-08-31 21:42:00","snet_input_date":"2022-08-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-31 21:42:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:21.000000Z","updated_at":"2025-03-17T18:48:21.000000Z","inspection_violations":[{"id":1871426,"change_date":"2022-08-31 21:42:00","inspection_id":"76487094","insp_violation_id":"248125688","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190647064","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:38.000000Z","updated_at":"2025-03-17T21:15:38.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1897029,"change_date":"2022-08-31 21:42:00","inspection_id":"76487094","insp_unit_id":"190647063","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"TR88","insp_unit_license":"BB00678","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZACHDC76AV59009","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:03.000000Z","updated_at":"2025-03-17T22:20:03.000000Z"},{"id":1897030,"change_date":"2022-08-31 21:42:00","inspection_id":"76487094","insp_unit_id":"190647064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"D022212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16VFX3222D2388787","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:03.000000Z","updated_at":"2025-03-17T22:20:03.000000Z"}]},{"id":979012,"change_date":"2022-08-07 21:31:00","inspection_id":"76253087","dot_number":"1233293","report_state":"MI","report_number":"OSHEE01848","insp_date":"2022-08-05 00:00:00","insp_start_time":"1240","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"131 NB @ THOMAS RD","county_code_state":"MI","county_code":"079","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-07 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"116700","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":"1087960","transaction_code":"A","transaction_date":"2022-08-05 00:00:00","upload_date":"2022-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-08-07 21:31:00","snet_input_date":"2022-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-07 21:31:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:49.000000Z","updated_at":"2025-03-17T18:44:49.000000Z","inspection_violations":[{"id":1544352,"change_date":"2022-08-07 21:31:00","inspection_id":"76253087","insp_violation_id":"247557968","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:17.000000Z","updated_at":"2025-03-17T21:14:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1575425,"change_date":"2022-08-07 21:31:00","inspection_id":"76253087","insp_unit_id":"190170976","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC96007","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX13C9CM017111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:56.000000Z","updated_at":"2025-03-17T22:17:56.000000Z"},{"id":1575426,"change_date":"2022-08-07 21:31:00","inspection_id":"76253087","insp_unit_id":"190170977","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BELH","insp_unit_company":null,"insp_unit_license":"D154187","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16JF02020W1031216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:56.000000Z","updated_at":"2025-03-17T22:17:56.000000Z"}]},{"id":809144,"change_date":"2022-07-13 21:40:00","inspection_id":"76054137","dot_number":"1233293","report_state":"MI","report_number":"FREEJ01659","insp_date":"2022-07-13 00:00:00","insp_start_time":"0755","insp_end_time":"0821","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US10\/STURGEON","county_code_state":"MI","county_code":"111","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1083936","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-07-13 21:40:00","snet_input_date":"2022-07-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-13 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:57.000000Z","updated_at":"2025-03-17T18:41:57.000000Z","inspection_violations":[{"id":1275637,"change_date":"2022-07-13 21:40:00","inspection_id":"76054137","insp_violation_id":"247066229","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1302190,"change_date":"2022-07-13 21:40:00","inspection_id":"76054137","insp_unit_id":"189753955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB43843","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF56P47EA57590","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"}]},{"id":697720,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","dot_number":"1233293","report_state":"MI","report_number":"POWED03724","insp_date":"2022-06-21 00:00:00","insp_start_time":"1133","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MIDDLEBELT RD @ SCHOOLCRAFT","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37500","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1081023","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094844,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_violation_id":"246727571","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189471971","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3939A"},{"id":1094845,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_violation_id":"246727572","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189471972","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39343"},{"id":1094846,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_violation_id":"246727573","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189471972","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4068627","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3939A"},{"id":1094847,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_violation_id":"246727574","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189471972","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3939A"},{"id":1094848,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_violation_id":"246727575","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189471972","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1120940,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_unit_id":"189471971","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"N\/A","insp_unit_license":"BC94920","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKHPVK6KH885364","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120941,"change_date":"2022-06-27 21:40:00","inspection_id":"75923897","insp_unit_id":"189471972","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"N\/A","insp_unit_license":"E565971","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2226N1251557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":348018,"change_date":"2022-06-09 21:42:00","inspection_id":"75508297","dot_number":"1233293","report_state":"MI","report_number":"MANIJ01079","insp_date":"2022-05-05 00:00:00","insp_start_time":"1227","insp_end_time":"1312","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1074660","transaction_code":"C","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-05-09 21:41:00","snet_input_date":"2022-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-09 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:39.000000Z","updated_at":"2025-03-17T18:33:39.000000Z","inspection_violations":[{"id":545818,"change_date":"2022-06-09 21:42:00","inspection_id":"75508297","insp_violation_id":"246338278","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189149375","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:37.000000Z","updated_at":"2025-03-17T21:09:37.000000Z","normalized_code":"3939A"},{"id":545819,"change_date":"2022-06-09 21:42:00","inspection_id":"75508297","insp_violation_id":"246338279","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189149375","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:37.000000Z","updated_at":"2025-03-17T21:09:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":562756,"change_date":"2022-06-09 21:42:00","inspection_id":"75508297","insp_unit_id":"189149375","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA43352","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FDXF75R62MA01761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:39.000000Z","updated_at":"2025-03-17T22:11:39.000000Z"}]},{"id":146193,"change_date":"2022-06-09 21:42:00","inspection_id":"75267261","dot_number":"1233293","report_state":"MI","report_number":"BALLB03555","insp_date":"2022-04-07 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"WADHAMS @ I69","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"36001","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1071194","transaction_code":"C","transaction_date":"2022-04-07 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-04-11 21:41:00","snet_input_date":"2022-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:08.000000Z","updated_at":"2025-03-17T18:30:08.000000Z","inspection_violations":[{"id":216048,"change_date":"2022-06-09 21:42:00","inspection_id":"75267261","insp_violation_id":"246329005","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189141998","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3963A1"},{"id":216049,"change_date":"2022-06-09 21:42:00","inspection_id":"75267261","insp_violation_id":"246329006","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:01.000000Z","updated_at":"2025-03-17T21:08:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":236777,"change_date":"2022-06-09 21:42:00","inspection_id":"75267261","insp_unit_id":"189141997","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"46","insp_unit_license":"BB96866","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3FRNF65R86V269588","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"},{"id":236778,"change_date":"2022-06-09 21:42:00","inspection_id":"75267261","insp_unit_id":"189141998","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HDSN","insp_unit_company":"TDM1","insp_unit_license":"A414327","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"10HHTD1D431000204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:38.000000Z","updated_at":"2025-03-17T22:09:38.000000Z"}]},{"id":128549,"change_date":"2022-04-07 21:39:00","inspection_id":"75246103","dot_number":"1233293","report_state":"MI","report_number":"MALIK00978","insp_date":"2022-04-06 00:00:00","insp_start_time":"0735","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S\/B MOUND RD @ 13 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17500","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":"1070859","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01233293","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"DVM UTILITIES INC","insp_carrier_street":"6045 SIMS DR SUITE 2","insp_carrier_city":"STERLING HEIGHTS","insp_carrier_state":"MI","insp_carrier_zip_code":"48313","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[{"id":190085,"change_date":"2022-04-07 21:39:00","inspection_id":"75246103","insp_violation_id":"245025351","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:07:55.000000Z","updated_at":"2025-03-17T21:07:55.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":208265,"change_date":"2022-04-07 21:39:00","inspection_id":"75246103","insp_unit_id":"188039975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"28","insp_unit_license":"BB43841","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF56F92ED66844","insp_unit_decal":"Y","insp_unit_decal_number":"30966240","created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1233293\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1233293\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1233293\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1233293\/inspections","per_page":100,"prev_page_url":null,"to":62,"total":62}