{"current_page":1,"data":[{"id":12628781,"change_date":"2026-08-04 21:39:00","inspection_id":"88599751","dot_number":"707486","report_state":"MI","report_number":"RICKE01306","insp_date":"2026-08-04 00:00:00","insp_start_time":"0810","insp_end_time":"0830","registration_date":null,"region":"ED","ci_status_code":"C","location":"ROAD","location_desc":"MI","county_code_state":"MI","county_code":"055","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":"U","pen_cen_match":"I","final_status_date":"2026-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"3902130","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-08-04 21:39:00","snet_input_date":"2026-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-04 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-07T09:39:42.000000Z","updated_at":"2026-08-15T09:30:48.000000Z","inspection_violations":[{"id":21986825,"change_date":"2026-08-04 21:39:00","inspection_id":"88599751","insp_violation_id":"275912179","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-08-07T09:57:13.000000Z","updated_at":"2026-08-15T09:42:21.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":21923062,"change_date":"2026-08-04 21:39:00","inspection_id":"88599751","insp_unit_id":"214970384","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1183","insp_unit_license":"BC58356","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4MED13294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:25.000000Z","updated_at":"2026-08-15T09:02:00.000000Z"},{"id":21923063,"change_date":"2026-08-04 21:39:00","inspection_id":"88599751","insp_unit_id":"214970385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEHNK","insp_unit_company":null,"insp_unit_license":"F005205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5SC292XRF069332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:25.000000Z","updated_at":"2026-08-15T09:02:00.000000Z"}]},{"id":12533244,"change_date":"2026-07-23 21:41:00","inspection_id":"88499400","dot_number":"707486","report_state":"MI","report_number":"POWED05991","insp_date":"2026-07-23 00:00:00","insp_start_time":"1615","insp_end_time":"1635","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","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":"U","pen_cen_match":"I","final_status_date":"2026-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3823100","transaction_code":"A","transaction_date":"2026-07-23 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-07-23 21:41:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:29.000000Z","updated_at":"2026-08-03T09:31:29.000000Z","inspection_violations":[{"id":21817796,"change_date":"2026-07-23 21:41:00","inspection_id":"88499400","insp_violation_id":"275695399","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-07-26T10:04:40.000000Z","updated_at":"2026-08-03T09:43:26.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":21764522,"change_date":"2026-07-23 21:41:00","inspection_id":"88499400","insp_unit_id":"214787594","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"BE61009","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHCYCY5FHGA6644","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:20:27.000000Z","updated_at":"2026-08-03T09:05:53.000000Z"}]},{"id":12455142,"change_date":"2026-07-15 21:42:00","inspection_id":"88415406","dot_number":"707486","report_state":"MI","report_number":"SAMOK01986","insp_date":"2026-07-15 00:00:00","insp_start_time":"1040","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":"131","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"49999","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3757474","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-07-15 21:42:00","snet_input_date":"2026-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:42:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-18T09:40:49.000000Z","updated_at":"2026-07-26T09:30:57.000000Z","inspection_violations":[{"id":21685237,"change_date":"2026-07-15 21:42:00","inspection_id":"88415406","insp_violation_id":"275521296","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"214626283","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-18T10:03:06.000000Z","updated_at":"2026-07-26T09:44:24.000000Z","normalized_code":"39375A3TAOL"},{"id":21685238,"change_date":"2026-07-15 21:42:00","inspection_id":"88415406","insp_violation_id":"275521297","seq_no":"2","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"214626283","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-07-18T10:03:06.000000Z","updated_at":"2026-07-26T09:44:24.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":21634064,"change_date":"2026-07-15 21:42:00","inspection_id":"88415406","insp_unit_id":"214626282","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC97446","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AN9TDF05156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:20:18.000000Z","updated_at":"2026-07-26T09:02:41.000000Z"},{"id":21634065,"change_date":"2026-07-15 21:42:00","inspection_id":"88415406","insp_unit_id":"214626283","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"A646308","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC02423SM120643","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-18T09:20:18.000000Z","updated_at":"2026-07-26T09:02:41.000000Z"}]},{"id":12383229,"change_date":"2026-07-08 21:41:00","inspection_id":"88346265","dot_number":"707486","report_state":"MI","report_number":"KIRKB05646","insp_date":"2026-07-08 00:00:00","insp_start_time":"0850","insp_end_time":"0920","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","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":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"3707642","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-07-08 21:41:00","snet_input_date":"2026-07-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:36.000000Z","updated_at":"2026-07-19T09:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21502385,"change_date":"2026-07-08 21:41:00","inspection_id":"88346265","insp_unit_id":"214495676","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1126","insp_unit_license":"BE08818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVABTCSX4HM26612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:35.000000Z","updated_at":"2026-07-19T09:02:15.000000Z"},{"id":21502386,"change_date":"2026-07-08 21:41:00","inspection_id":"88346265","insp_unit_id":"214495677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"N\/A","insp_unit_license":"A646303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKC0242XWB091319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:35.000000Z","updated_at":"2026-07-19T09:02:15.000000Z"}]},{"id":12366698,"change_date":"2026-07-06 21:38:00","inspection_id":"88328614","dot_number":"707486","report_state":"MI","report_number":"PATTM05538","insp_date":"2026-07-06 00:00:00","insp_start_time":"1105","insp_end_time":"1128","registration_date":null,"region":"ED","ci_status_code":"C","location":"132","location_desc":"MI","county_code_state":"MI","county_code":"075","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3691376","transaction_code":"A","transaction_date":"2026-07-06 00:00:00","upload_date":"2026-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-07-06 21:38:00","snet_input_date":"2026-07-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-06 21:38:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-09T09:40:22.000000Z","updated_at":"2026-07-17T09:30:40.000000Z","inspection_violations":[{"id":21524288,"change_date":"2026-07-06 21:38:00","inspection_id":"88328614","insp_violation_id":"275320854","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"214462614","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:21.000000Z","updated_at":"2026-07-17T09:42:37.000000Z","normalized_code":"3939ALFTSI"},{"id":21524289,"change_date":"2026-07-06 21:38:00","inspection_id":"88328614","insp_violation_id":"275320855","seq_no":"2","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"214462614","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:21.000000Z","updated_at":"2026-07-17T09:42:37.000000Z","normalized_code":"39311A1LIL"}],"inspection_per_units":[{"id":21474965,"change_date":"2026-07-06 21:38:00","inspection_id":"88328614","insp_unit_id":"214462614","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE61205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVDCXDT0GHGU4347","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:52.000000Z","updated_at":"2026-07-17T09:01:55.000000Z"}]},{"id":12274585,"change_date":"2026-06-25 21:50:00","inspection_id":"88234046","dot_number":"707486","report_state":"MI","report_number":"RICHP00632","insp_date":"2026-06-24 00:00:00","insp_start_time":"1355","insp_end_time":"1409","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","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":"U","pen_cen_match":"I","final_status_date":"2026-06-25 21:50: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":"3613138","transaction_code":"A","transaction_date":"2026-06-25 00:00:00","upload_date":"2026-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-06-25 21:50:00","snet_input_date":"2026-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-25 21:50:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-28T09:39:36.000000Z","updated_at":"2026-07-06T09:31:41.000000Z","inspection_violations":[{"id":21365810,"change_date":"2026-06-25 21:50:00","inspection_id":"88234046","insp_violation_id":"275114512","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":"WARNING","created_at":"2026-06-28T09:56:16.000000Z","updated_at":"2026-07-06T09:46:02.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":21314181,"change_date":"2026-06-25 21:50:00","inspection_id":"88234046","insp_unit_id":"214274161","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC58356","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4MED13294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-28T09:15:05.000000Z","updated_at":"2026-07-06T09:03:24.000000Z"}]},{"id":12076903,"change_date":"2026-06-02 21:41:00","inspection_id":"88019429","dot_number":"707486","report_state":"MI","report_number":"LAUEJ02351","insp_date":"2026-06-02 00:00:00","insp_start_time":"0915","insp_end_time":"0931","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"031","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":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"18500","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":"3448938","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:26.000000Z","updated_at":"2026-06-13T09:31:25.000000Z","inspection_violations":[{"id":21014535,"change_date":"2026-06-02 21:41:00","inspection_id":"88019429","insp_violation_id":"274644036","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":"2026-06-06T10:00:17.000000Z","updated_at":"2026-06-13T09:43:30.000000Z","normalized_code":"3922SLLSR"},{"id":21014536,"change_date":"2026-06-02 21:41:00","inspection_id":"88019429","insp_violation_id":"274644037","seq_no":"2","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":"2026-06-06T10:00:17.000000Z","updated_at":"2026-06-13T09:43:30.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20987031,"change_date":"2026-06-02 21:41:00","inspection_id":"88019429","insp_unit_id":"213871358","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD22913","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8X3B69HEE49077","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:20.000000Z","updated_at":"2026-06-13T09:02:28.000000Z"},{"id":20987032,"change_date":"2026-06-02 21:41:00","inspection_id":"88019429","insp_unit_id":"213871359","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":null,"insp_unit_license":"E742377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5UA2119NF061282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:20.000000Z","updated_at":"2026-06-13T09:02:28.000000Z"}]},{"id":10481271,"change_date":"2025-12-19 21:39:00","inspection_id":"86615264","dot_number":"707486","report_state":"MI","report_number":"NESBA02517","insp_date":"2025-12-18 00:00:00","insp_start_time":"1800","insp_end_time":"1815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@SQUIRREL 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-12-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1254399","transaction_code":"A","transaction_date":"2025-12-18 00:00:00","upload_date":"2025-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-12-19 21:39:00","snet_input_date":"2025-12-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-19 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-22T10:32:07.000000Z","updated_at":"2025-12-30T10:34:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17549383,"change_date":"2025-12-19 21:39:00","inspection_id":"86615264","insp_unit_id":"210724472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BE48357","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT8MDA07334","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-22T10:02:06.000000Z","updated_at":"2025-12-30T10:01:12.000000Z"}]},{"id":10411647,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","dot_number":"707486","report_state":"MI","report_number":"FRIZS03444","insp_date":"2025-12-11 00:00:00","insp_start_time":"0930","insp_end_time":"1011","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 W\/B IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S \/ C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"1253525","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-12-11 21:45:00","snet_input_date":"2025-12-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-11 21:45:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-14T10:31:53.000000Z","updated_at":"2025-12-15T10:31:25.000000Z","inspection_violations":[{"id":17452397,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_violation_id":"270629437","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"210559733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:44.000000Z","updated_at":"2025-12-15T10:32:46.000000Z","normalized_code":"3939ALIL"},{"id":17452398,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_violation_id":"270629438","seq_no":"2","part_no":"396","part_no_section":"3A1-ALATR","insp_viol_unit":"1","insp_unit_id":"210559733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:44.000000Z","updated_at":"2025-12-15T10:32:46.000000Z","normalized_code":"3963A1ALATR"},{"id":17452399,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_violation_id":"270629439","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"210559734","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-14T10:32:44.000000Z","updated_at":"2025-12-15T10:32:46.000000Z","normalized_code":"39343DB"},{"id":17452400,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_violation_id":"270629440","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210559734","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:44.000000Z","updated_at":"2025-12-15T10:32:46.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17413159,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_unit_id":"210559733","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1126","insp_unit_license":"BE08818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVABTCSX4HM26612","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-12-14T10:02:03.000000Z","updated_at":"2025-12-15T10:01:56.000000Z"},{"id":17413160,"change_date":"2025-12-11 21:45:00","inspection_id":"86542408","insp_unit_id":"210559734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HAWK","insp_unit_company":null,"insp_unit_license":"A646313","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4BATS1016XM016547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:03.000000Z","updated_at":"2025-12-15T10:01:56.000000Z"}]},{"id":10262312,"change_date":"2025-12-04 21:38:00","inspection_id":"86386084","dot_number":"707486","report_state":"MI","report_number":"WORDN05874","insp_date":"2025-11-20 00:00:00","insp_start_time":"1552","insp_end_time":"1630","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1251558","transaction_code":"C","transaction_date":"2025-11-20 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-11-21 21:39:00","snet_input_date":"2025-11-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-21 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-24T10:31:48.000000Z","updated_at":"2025-12-08T10:30:41.000000Z","inspection_violations":[{"id":17322534,"change_date":"2025-12-04 21:38:00","inspection_id":"86386084","insp_violation_id":"270464806","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4626122","created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:12.000000Z","normalized_code":"38323A2LCDLN"},{"id":17322535,"change_date":"2025-12-04 21:38:00","inspection_id":"86386084","insp_violation_id":"270464807","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":"X4626122","created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:12.000000Z","normalized_code":"39141APC"},{"id":17322536,"change_date":"2025-12-04 21:38:00","inspection_id":"86386084","insp_violation_id":"270464808","seq_no":"3","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":"WARNING","created_at":"2025-12-07T10:32:10.000000Z","updated_at":"2025-12-08T10:31:12.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":17292137,"change_date":"2025-12-04 21:38:00","inspection_id":"86386084","insp_unit_id":"210416723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1187","insp_unit_license":"BE40648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDU4DHFA4637","insp_unit_decal":"Y","insp_unit_decal_number":"35768456","created_at":"2025-12-07T10:01:27.000000Z","updated_at":"2025-12-08T10:00:49.000000Z"}]},{"id":10138348,"change_date":"2025-11-06 21:40:00","inspection_id":"86255880","dot_number":"707486","report_state":"MI","report_number":"SHEPZ05417","insp_date":"2025-11-05 00:00:00","insp_start_time":"1155","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EVANS ST @ CHICAGO RD","county_code_state":"MI","county_code":"059","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-11-06 21:40: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":"1249371","transaction_code":"A","transaction_date":"2025-11-05 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:43.000000Z","updated_at":"2025-11-10T10:30:59.000000Z","inspection_violations":[{"id":16821902,"change_date":"2025-11-06 21:40:00","inspection_id":"86255880","insp_violation_id":"269783586","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:56.000000Z","updated_at":"2025-11-10T10:31:58.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":16876582,"change_date":"2025-11-06 21:40:00","inspection_id":"86255880","insp_unit_id":"209884493","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1229","insp_unit_license":"BD95460","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDT7CHBK0058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:31.000000Z"}]},{"id":10067576,"change_date":"2025-10-29 21:40:00","inspection_id":"86181245","dot_number":"707486","report_state":"MI","report_number":"POWED05511","insp_date":"2025-10-28 00:00:00","insp_start_time":"1845","insp_end_time":"1905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-275 @ I-96","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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-10-29 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":"1248141","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-10-29 21:40:00","snet_input_date":"2025-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-02T11:01:10.000000Z","inspection_violations":[{"id":16671781,"change_date":"2025-10-29 21:40:00","inspection_id":"86181245","insp_violation_id":"269595759","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-11-01T10:17:59.000000Z","updated_at":"2025-11-02T11:16:47.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":16733872,"change_date":"2025-10-29 21:40:00","inspection_id":"86181245","insp_unit_id":"209720507","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"N\/A","insp_unit_license":"BD28849","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WR9AJ6GG291060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:30.000000Z"},{"id":16733873,"change_date":"2025-10-29 21:40:00","inspection_id":"86181245","insp_unit_id":"209720508","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":"N\/A","insp_unit_license":"F195184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW1U121XS1444952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:30.000000Z"}]},{"id":9972092,"change_date":"2025-10-17 21:39:00","inspection_id":"86080784","dot_number":"707486","report_state":"MI","report_number":"RICKE00869","insp_date":"2025-10-16 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B M-66 & MISSAUKEE HILL DR","county_code_state":"MI","county_code":"113","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-10-17 21:39: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":"1246499","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:55.000000Z","updated_at":"2025-10-21T10:00:51.000000Z","inspection_violations":[{"id":16472621,"change_date":"2025-10-17 21:39:00","inspection_id":"86080784","insp_violation_id":"269368912","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":"WARNING","created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:31.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16557723,"change_date":"2025-10-17 21:39:00","inspection_id":"86080784","insp_unit_id":"209529160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1183","insp_unit_license":"BC58356","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4MED13294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:10.000000Z"}]},{"id":9696150,"change_date":"2025-09-16 21:40:00","inspection_id":"85790496","dot_number":"707486","report_state":"MI","report_number":"ESCOT03022","insp_date":"2025-09-13 00:00:00","insp_start_time":"1145","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W I-96@8 MILE 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":"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-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"97500","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":"1241234","transaction_code":"A","transaction_date":"2025-09-13 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-18T10:01:01.000000Z","updated_at":"2025-09-23T10:01:06.000000Z","inspection_violations":[{"id":15908108,"change_date":"2025-09-16 21:40:00","inspection_id":"85790496","insp_violation_id":"268729910","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"3922SLLTL"},{"id":15908109,"change_date":"2025-09-16 21:40:00","inspection_id":"85790496","insp_violation_id":"268729911","seq_no":"2","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:35.000000Z","updated_at":"2025-09-20T10:15:51.000000Z","normalized_code":"393104F3C"}],"inspection_per_units":[{"id":16050761,"change_date":"2025-09-16 21:40:00","inspection_id":"85790496","insp_unit_id":"208981388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1173","insp_unit_license":"BC46175","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT3KEG55591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"},{"id":16050762,"change_date":"2025-09-16 21:40:00","inspection_id":"85790496","insp_unit_id":"208981389","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"SURE","insp_unit_company":"T-151","insp_unit_license":"F319425","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW1U121XS1466241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:31.000000Z"}]},{"id":9594540,"change_date":"2025-09-04 21:41:00","inspection_id":"85684042","dot_number":"707486","report_state":"MI","report_number":"SAHIW03008","insp_date":"2025-09-03 00:00:00","insp_start_time":"1335","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB-I-75 @ HURON RIVER DR","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29500","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":"1239239","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-09-04 21:41:00","snet_input_date":"2025-09-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-04 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:31.000000Z","updated_at":"2025-09-10T10:45:31.000000Z","inspection_violations":[{"id":15680277,"change_date":"2025-09-04 21:41:00","inspection_id":"85684042","insp_violation_id":"268464809","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-09-09T10:43:05.000000Z","updated_at":"2025-09-10T10:47:45.000000Z","normalized_code":"39282DUMT"},{"id":15680278,"change_date":"2025-09-04 21:41:00","inspection_id":"85684042","insp_violation_id":"268464810","seq_no":"2","part_no":"383","part_no_section":"51A-LCDLRSWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-09T10:43:05.000000Z","updated_at":"2025-09-10T10:47:45.000000Z","normalized_code":"38351ALCDLRSWD"}],"inspection_per_units":[{"id":15841951,"change_date":"2025-09-04 21:41:00","inspection_id":"85684042","insp_unit_id":"208752239","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD63803","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GN7NDA2456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:01.000000Z"},{"id":15841952,"change_date":"2025-09-04 21:41:00","inspection_id":"85684042","insp_unit_id":"208752240","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ASSEM","insp_unit_company":null,"insp_unit_license":"E049196","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI2605A121R032119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:01.000000Z"}]},{"id":9583941,"change_date":"2025-09-03 21:40:00","inspection_id":"85672760","dot_number":"707486","report_state":"MI","report_number":"POWED05405","insp_date":"2025-09-02 00:00:00","insp_start_time":"1535","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB 275 ANN ARBOR RD","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-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1239086","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-09-03 21:40:00","snet_input_date":"2025-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:30.000000Z","updated_at":"2025-09-10T10:44:56.000000Z","inspection_violations":[{"id":15655797,"change_date":"2025-09-03 21:40:00","inspection_id":"85672760","insp_violation_id":"268436343","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-09-06T10:48:11.000000Z","updated_at":"2025-09-06T10:48:11.000000Z","normalized_code":"3922SLLLR"},{"id":15655798,"change_date":"2025-09-03 21:40:00","inspection_id":"85672760","insp_violation_id":"268436344","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":"2025-09-06T10:48:11.000000Z","updated_at":"2025-09-06T10:48:11.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":15821935,"change_date":"2025-09-03 21:40:00","inspection_id":"85672760","insp_unit_id":"208730619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"BD87752","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7DC4RDF08233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"}]},{"id":9499697,"change_date":"2025-08-25 21:40:00","inspection_id":"85584431","dot_number":"707486","report_state":"MI","report_number":"MORRS00797","insp_date":"2025-08-22 00:00:00","insp_start_time":"1015","insp_end_time":"1027","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WESTBOUND","county_code_state":"MI","county_code":"025","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-25 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":"1237797","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-08-25 21:40:00","snet_input_date":"2025-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:44.000000Z","updated_at":"2025-08-29T10:42:44.000000Z","inspection_violations":[{"id":15491667,"change_date":"2025-08-25 21:40:00","inspection_id":"85584431","insp_violation_id":"268233637","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-08-28T10:44:08.000000Z","updated_at":"2025-09-05T10:48:52.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":15673738,"change_date":"2025-08-25 21:40:00","inspection_id":"85584431","insp_unit_id":"208569677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC89653","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDU4DHFA4637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:03.000000Z"}]},{"id":9322576,"change_date":"2025-08-04 21:39:00","inspection_id":"85398149","dot_number":"707486","report_state":"MI","report_number":"SAMOK01402","insp_date":"2025-07-31 00:00:00","insp_start_time":"2005","insp_end_time":"2015","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB","county_code_state":"MI","county_code":"025","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":"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":"1233925","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","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:42.000000Z","inspection_violations":[{"id":15127005,"change_date":"2025-08-04 21:39:00","inspection_id":"85398149","insp_violation_id":"267822957","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:35.000000Z","updated_at":"2025-08-08T10:43:48.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15353058,"change_date":"2025-08-04 21:39:00","inspection_id":"85398149","insp_unit_id":"208224588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD07933","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT3HEB33987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:51.000000Z"},{"id":15353059,"change_date":"2025-08-04 21:39:00","inspection_id":"85398149","insp_unit_id":"208224589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BELH","insp_unit_company":null,"insp_unit_license":"D421349","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"16JF01626S1026341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:51.000000Z"}]},{"id":8837449,"change_date":"2025-06-06 21:40:00","inspection_id":"84886288","dot_number":"707486","report_state":"MI","report_number":"KLEIN03857","insp_date":"2025-06-06 00:00:00","insp_start_time":"0810","insp_end_time":"0857","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"GALESBURG REST AREA","county_code_state":"MI","county_code":"077","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21600","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":"1224413","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-06-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:19.000000Z","updated_at":"2025-06-10T10:00:37.000000Z","inspection_violations":[{"id":14149505,"change_date":"2025-06-06 21:40:00","inspection_id":"84886288","insp_violation_id":"266708245","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"207265430","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:50.000000Z","updated_at":"2025-06-10T10:16:04.000000Z","normalized_code":"3922SLLSR"},{"id":14149506,"change_date":"2025-06-06 21:40:00","inspection_id":"84886288","insp_violation_id":"266708246","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207265429","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:50.000000Z","updated_at":"2025-06-10T10:16:04.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14469867,"change_date":"2025-06-06 21:40:00","inspection_id":"84886288","insp_unit_id":"207265429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD95459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT3RDA38384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:19.000000Z","updated_at":"2025-06-10T09:45:49.000000Z"},{"id":14469868,"change_date":"2025-06-06 21:40:00","inspection_id":"84886288","insp_unit_id":"207265430","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":null,"insp_unit_license":"D910556","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH1820A1075029","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:19.000000Z","updated_at":"2025-06-10T09:45:49.000000Z"}]},{"id":8227488,"change_date":"2025-03-27 21:41:00","inspection_id":"84243153","dot_number":"707486","report_state":"MI","report_number":"ZAPFA00703","insp_date":"2025-03-26 00:00:00","insp_start_time":"1329","insp_end_time":"1346","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HARTFORD TWP\/I-94","county_code_state":"MI","county_code":"159","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41: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":"1215228","transaction_code":"A","transaction_date":"2025-03-26 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:35.000000Z","updated_at":"2025-03-31T10:30:28.000000Z","inspection_violations":[{"id":12908529,"change_date":"2025-03-27 21:41:00","inspection_id":"84243153","insp_violation_id":"265289848","seq_no":"1","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-29T10:50:46.000000Z","updated_at":"2025-03-31T10:51:04.000000Z","normalized_code":"3922SLLDL"},{"id":12908530,"change_date":"2025-03-27 21:41:00","inspection_id":"84243153","insp_violation_id":"265289849","seq_no":"2","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:50:46.000000Z","updated_at":"2025-03-31T10:51:04.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13308734,"change_date":"2025-03-27 21:41:00","inspection_id":"84243153","insp_unit_id":"206025704","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1182","insp_unit_license":"BC23868","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT6MED13295","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:24:41.000000Z","updated_at":"2025-03-31T10:04:38.000000Z"}]},{"id":8146428,"change_date":"2025-03-18 21:40:00","inspection_id":"84157828","dot_number":"707486","report_state":"MI","report_number":"POWED05188","insp_date":"2025-03-17 00:00:00","insp_start_time":"1503","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ BECK RD.","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"29400","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":"1213671","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-03-18 21:40:00","snet_input_date":"2025-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","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:28.000000Z","inspection_violations":[{"id":12749512,"change_date":"2025-03-18 21:40:00","inspection_id":"84157828","insp_violation_id":"265107703","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-03-21T10:59:33.000000Z","updated_at":"2025-03-21T11:13:32.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":13158396,"change_date":"2025-03-18 21:40:00","inspection_id":"84157828","insp_unit_id":"205861432","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NA","insp_unit_license":"BD63803","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GN7NDA2456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:06:48.000000Z","updated_at":"2025-03-22T09:59:57.000000Z"},{"id":13158397,"change_date":"2025-03-18 21:40:00","inspection_id":"84157828","insp_unit_id":"205861433","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"NA","insp_unit_license":"E697262","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW2U1826N1364234","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:06:48.000000Z","updated_at":"2025-03-22T09:59:57.000000Z"}]},{"id":8084209,"change_date":"2025-03-11 21:41:00","inspection_id":"84092389","dot_number":"707486","report_state":"MI","report_number":"EVANT02791","insp_date":"2025-03-10 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ BAUMAN RD","county_code_state":"MI","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43001","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":"1212749","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13052252,"change_date":"2025-03-11 21:41:00","inspection_id":"84092389","insp_unit_id":"205736584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1230","insp_unit_license":"BD95461","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMAAN9CL545672","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13052253,"change_date":"2025-03-11 21:41:00","inspection_id":"84092389","insp_unit_id":"205736585","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"QUALI","insp_unit_company":null,"insp_unit_license":"F162831","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5NDFD20218S000213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":8084330,"change_date":"2025-03-11 21:41:00","inspection_id":"84092511","dot_number":"707486","report_state":"MI","report_number":"HICKG02844","insp_date":"2025-03-10 00:00:00","insp_start_time":"1100","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B US 127 @ REST AREA","county_code_state":"MI","county_code":"065","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"1212666","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-03-11 21:41:00","snet_input_date":"2025-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12633981,"change_date":"2025-03-11 21:41:00","inspection_id":"84092511","insp_violation_id":"264949301","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"205736795","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39345B2BAIR"},{"id":12633982,"change_date":"2025-03-11 21:41:00","inspection_id":"84092511","insp_violation_id":"264949302","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"205736796","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":13052459,"change_date":"2025-03-11 21:41:00","inspection_id":"84092511","insp_unit_id":"205736795","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1126","insp_unit_license":"BE08818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVABTCSX4HM26612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13052460,"change_date":"2025-03-11 21:41:00","inspection_id":"84092511","insp_unit_id":"205736796","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NONE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":7865554,"change_date":"2025-02-13 21:40:00","inspection_id":"83862720","dot_number":"707486","report_state":"MI","report_number":"HINCA00588","insp_date":"2025-02-12 00:00:00","insp_start_time":"1125","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"LOT","location_desc":"N\/B US-31 @ MILL ST","county_code_state":"MI","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","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":"1209994","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12695081,"change_date":"2025-02-13 21:40:00","inspection_id":"83862720","insp_unit_id":"205315899","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1127","insp_unit_license":"BC42355","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVABTCS14HM26613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"},{"id":12695082,"change_date":"2025-02-13 21:40:00","inspection_id":"83862720","insp_unit_id":"205315900","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"QUAL","insp_unit_company":null,"insp_unit_license":"D743208","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5NDFD20218S000213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:15.000000Z","updated_at":"2025-03-17T23:55:15.000000Z"}]},{"id":7194742,"change_date":"2024-11-14 21:41:00","inspection_id":"83157261","dot_number":"707486","report_state":"MI","report_number":"PATTM04870","insp_date":"2024-11-13 00:00:00","insp_start_time":"1100","insp_end_time":"1125","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":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-14 21:41: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":"1201480","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:02.000000Z","updated_at":"2025-03-17T20:46:02.000000Z","inspection_violations":[{"id":11242823,"change_date":"2024-11-14 21:41:00","inspection_id":"83157261","insp_violation_id":"262895749","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-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":11605145,"change_date":"2024-11-14 21:41:00","inspection_id":"83157261","insp_unit_id":"203882415","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC89653","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDU4DHFA4637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:17.000000Z","updated_at":"2025-03-17T23:43:17.000000Z"}]},{"id":6166338,"change_date":"2024-07-08 21:43:00","inspection_id":"82061549","dot_number":"707486","report_state":"MI","report_number":"BALLB04759","insp_date":"2024-07-08 00:00:00","insp_start_time":"0605","insp_end_time":"0625","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I94 E @ CONNER","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-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1185009","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-07-08 21:43:00","snet_input_date":"2024-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:59.000000Z","updated_at":"2025-03-17T20:24:59.000000Z","inspection_violations":[{"id":9571018,"change_date":"2024-07-08 21:43:00","inspection_id":"82061549","insp_violation_id":"260511590","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4398259","created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"},{"id":9571019,"change_date":"2024-07-08 21:43:00","inspection_id":"82061549","insp_violation_id":"260511591","seq_no":"2","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:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39141A"},{"id":9571020,"change_date":"2024-07-08 21:43:00","inspection_id":"82061549","insp_violation_id":"260511592","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9933211,"change_date":"2024-07-08 21:43:00","inspection_id":"82061549","insp_unit_id":"201774472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1197","insp_unit_license":"BD09227","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT1NDA06312","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:57.000000Z","updated_at":"2025-03-17T23:25:57.000000Z"}]},{"id":6084117,"change_date":"2024-06-26 21:43:00","inspection_id":"81973133","dot_number":"707486","report_state":"MI","report_number":"MALIK02424","insp_date":"2024-06-26 00:00:00","insp_start_time":"0910","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ MOUND RD","county_code_state":"MI","county_code":"125","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":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1183575","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9441783,"change_date":"2024-06-26 21:43:00","inspection_id":"81973133","insp_violation_id":"260329006","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"201606926","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"39343"},{"id":9441784,"change_date":"2024-06-26 21:43:00","inspection_id":"81973133","insp_violation_id":"260329007","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9799447,"change_date":"2024-06-26 21:43:00","inspection_id":"81973133","insp_unit_id":"201606925","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1155","insp_unit_license":"BD07934","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GTXJDA01739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"},{"id":9799448,"change_date":"2024-06-26 21:43:00","inspection_id":"81973133","insp_unit_id":"201606926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SURE-","insp_unit_company":"T-137","insp_unit_license":"F040130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5JW1D1426R4412076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":5785814,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","dot_number":"707486","report_state":"VA","report_number":"5910006497","insp_date":"2024-05-16 00:00:00","insp_start_time":"1101","insp_end_time":"1130","registration_date":null,"region":"ED","ci_status_code":"C","location":"BLASCN","location_desc":"BLAND SCALES NORTH","county_code_state":"VA","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS 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":"U","pen_cen_match":"I","final_status_date":"2024-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"493637","transaction_code":"C","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-05-20 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-20 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:29.000000Z","updated_at":"2025-03-17T20:17:29.000000Z","inspection_violations":[{"id":8959451,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_violation_id":"259634472","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201004398","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3963A1"},{"id":8959452,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_violation_id":"259634473","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201004398","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39348A"},{"id":8959453,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_violation_id":"259634474","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201004398","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39348A"},{"id":8959454,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_violation_id":"259634475","seq_no":"4","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201004398","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39348A"},{"id":8959455,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_violation_id":"259634476","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201004398","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9318922,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_unit_id":"201004397","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BC23806","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDC17HZ41427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:45.000000Z","updated_at":"2025-03-17T23:19:45.000000Z"},{"id":9318923,"change_date":"2024-05-21 21:46:00","inspection_id":"81649731","insp_unit_id":"201004398","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"E049196","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2605A181R032119","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:45.000000Z","updated_at":"2025-03-17T23:19:45.000000Z"}]},{"id":5623610,"change_date":"2024-04-29 21:43:00","inspection_id":"81473880","dot_number":"707486","report_state":"MI","report_number":"BEAMW03778","insp_date":"2024-04-26 00:00:00","insp_start_time":"1325","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ TOWNLINE","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-04-29 21:43: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":"1176143","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-04-29 21:43:00","snet_input_date":"2024-04-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:16.000000Z","updated_at":"2025-03-17T20:14:16.000000Z","inspection_violations":[{"id":8696501,"change_date":"2024-04-29 21:43:00","inspection_id":"81473880","insp_violation_id":"259205738","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:04.000000Z","updated_at":"2025-03-17T21:48:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9058756,"change_date":"2024-04-29 21:43:00","inspection_id":"81473880","insp_unit_id":"200631785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD63808","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GN7NDA24564","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:17.000000Z","updated_at":"2025-03-17T23:17:17.000000Z"}]},{"id":5258267,"change_date":"2024-03-11 21:43:00","inspection_id":"81075231","dot_number":"707486","report_state":"MI","report_number":"MALIK02226","insp_date":"2024-03-07 00:00:00","insp_start_time":"1100","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ 23 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":"2024-03-11 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1168257","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-03-11 21:43:00","snet_input_date":"2024-03-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-11 21:43:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:44.000000Z","updated_at":"2025-03-17T20:06:44.000000Z","inspection_violations":[{"id":8108125,"change_date":"2024-03-11 21:43:00","inspection_id":"81075231","insp_violation_id":"258314622","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4335425","created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":8467176,"change_date":"2024-03-11 21:43:00","inspection_id":"81075231","insp_unit_id":"199852394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1152","insp_unit_license":"BB54373","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT8HEB24789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:44.000000Z","updated_at":"2025-03-17T23:11:44.000000Z"}]},{"id":5202468,"change_date":"2024-03-04 21:41:00","inspection_id":"81014035","dot_number":"707486","report_state":"NC","report_number":"0006628390","insp_date":"2024-03-04 00:00:00","insp_start_time":"1025","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"MT. AI","location_desc":"MT. AIRY WEIGH STATION N","county_code_state":"NC","county_code":"171","insp_level_id":"1","service_center":"SH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","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":"2161327","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"331328","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:43.000000Z","updated_at":"2025-03-17T20:05:43.000000Z","inspection_violations":[{"id":8019888,"change_date":"2024-03-04 21:41:00","inspection_id":"81014035","insp_violation_id":"258184326","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199736443","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3922"},{"id":8019889,"change_date":"2024-03-04 21:41:00","inspection_id":"81014035","insp_violation_id":"258184327","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199736443","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":8376765,"change_date":"2024-03-04 21:41:00","inspection_id":"81014035","insp_unit_id":"199736443","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD07932","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT1HEB33986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:53.000000Z","updated_at":"2025-03-17T23:10:53.000000Z"},{"id":8376766,"change_date":"2024-03-04 21:41:00","inspection_id":"81014035","insp_unit_id":"199736444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEHN","insp_unit_company":null,"insp_unit_license":"E742377","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:53.000000Z","updated_at":"2025-03-17T23:10:53.000000Z"}]},{"id":5202619,"change_date":"2024-03-04 21:41:00","inspection_id":"81014197","dot_number":"707486","report_state":"NC","report_number":"0006628368","insp_date":"2024-03-04 00:00:00","insp_start_time":"1002","insp_end_time":"1024","registration_date":null,"region":"ET","ci_status_code":"C","location":"MT. AI","location_desc":"MT. AIRY WEIGH STATION N","county_code_state":"NC","county_code":"171","insp_level_id":"1","service_center":"SH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"43500","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":"2161349","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"331328","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:43.000000Z","updated_at":"2025-03-17T20:05:43.000000Z","inspection_violations":[{"id":8019969,"change_date":"2024-03-04 21:41:00","inspection_id":"81014197","insp_violation_id":"258184424","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199736703","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:43.000000Z","updated_at":"2025-03-17T21:44:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8377002,"change_date":"2024-03-04 21:41:00","inspection_id":"81014197","insp_unit_id":"199736703","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC58356","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4MED13294","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:54.000000Z","updated_at":"2025-03-17T23:10:54.000000Z"},{"id":8377003,"change_date":"2024-03-04 21:41:00","inspection_id":"81014197","insp_unit_id":"199736704","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEHN","insp_unit_company":null,"insp_unit_license":"F005205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"9332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:54.000000Z","updated_at":"2025-03-17T23:10:54.000000Z"}]},{"id":5197031,"change_date":"2024-03-04 21:40:00","inspection_id":"81008129","dot_number":"707486","report_state":"WV","report_number":"PSC1110162","insp_date":"2024-02-27 00:00:00","insp_start_time":"1551","insp_end_time":"1611","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SHARON WV","county_code_state":"WV","county_code":null,"insp_level_id":"3","service_center":"EA","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"290604","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-03-04 21:40:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-04 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:24.000000Z","updated_at":"2025-03-17T20:05:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8368363,"change_date":"2024-03-04 21:40:00","inspection_id":"81008129","insp_unit_id":"199726266","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"BC23866","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDC17HZ41427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:48.000000Z","updated_at":"2025-03-17T23:10:48.000000Z"},{"id":8368364,"change_date":"2024-03-04 21:40:00","inspection_id":"81008129","insp_unit_id":"199726267","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"E001728","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI0509A121R121419","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:48.000000Z","updated_at":"2025-03-17T23:10:48.000000Z"}]},{"id":5009797,"change_date":"2024-02-08 21:43:00","inspection_id":"80804120","dot_number":"707486","report_state":"MI","report_number":"MALIK02181","insp_date":"2024-02-07 00:00:00","insp_start_time":"1050","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 @ 23 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":"2024-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1163774","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:01.000000Z","updated_at":"2025-03-17T20:02:01.000000Z","inspection_violations":[{"id":7717176,"change_date":"2024-02-08 21:43:00","inspection_id":"80804120","insp_violation_id":"257739715","seq_no":"1","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"39375G"},{"id":7717177,"change_date":"2024-02-08 21:43:00","inspection_id":"80804120","insp_violation_id":"257739716","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:43:15.000000Z","updated_at":"2025-03-17T21:43:15.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8063424,"change_date":"2024-02-08 21:43:00","inspection_id":"80804120","insp_unit_id":"199336792","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1152","insp_unit_license":"BB54373","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT8HEB24789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:04.000000Z","updated_at":"2025-03-17T23:08:04.000000Z"}]},{"id":4013259,"change_date":"2023-09-20 21:39:00","inspection_id":"79707452","dot_number":"707486","report_state":"MI","report_number":"MALIK01971","insp_date":"2023-09-19 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ OPDYKE 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-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1146795","transaction_code":"A","transaction_date":"2023-09-19 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:03.000000Z","updated_at":"2025-03-17T19:42:03.000000Z","inspection_violations":[{"id":6209252,"change_date":"2023-09-20 21:39:00","inspection_id":"79707452","insp_violation_id":"255373184","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6453015,"change_date":"2023-09-20 21:39:00","inspection_id":"79707452","insp_unit_id":"197144264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BD45296","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT6PEC03660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3386583,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","dot_number":"707486","report_state":"MI","report_number":"PATTM04306","insp_date":"2023-06-28 00:00:00","insp_start_time":"0650","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"13300","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":"0","hazmat_oos_total":"0","snet_sequence_id":"1132567","transaction_code":"A","transaction_date":"2023-06-28 00:00:00","upload_date":"2023-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2023-06-28 21:42:00","snet_input_date":"2023-06-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-28 21:42:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:09.000000Z","updated_at":"2025-03-17T19:30:09.000000Z","inspection_violations":[{"id":5220777,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","insp_violation_id":"253751847","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:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"39141A"},{"id":5220778,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","insp_violation_id":"253751848","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195722833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5220779,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","insp_violation_id":"253751849","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195722833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3939A"},{"id":5220780,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","insp_violation_id":"253751850","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195722833","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:16.000000Z","updated_at":"2025-03-17T21:31:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5444439,"change_date":"2023-06-28 21:42:00","inspection_id":"79006650","insp_unit_id":"195722833","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC21496","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FT8X3D63BEC64690","insp_unit_decal":"Y","insp_unit_decal_number":"32660368","created_at":"2025-03-17T22:45:56.000000Z","updated_at":"2025-03-17T22:45:56.000000Z"}]},{"id":2613976,"change_date":"2023-03-20 21:41:00","inspection_id":"78132577","dot_number":"707486","report_state":"MI","report_number":"BARTC02200","insp_date":"2023-03-17 00:00:00","insp_start_time":"0740","insp_end_time":"0751","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ BU 131","county_code_state":"MI","county_code":"165","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-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1118196","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2023-03-20 21:41:00","snet_input_date":"2023-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:52.000000Z","updated_at":"2025-03-17T19:14:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4207853,"change_date":"2023-03-20 21:41:00","inspection_id":"78132577","insp_unit_id":"193956664","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1152","insp_unit_license":"BB54373","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4HT8HEB24789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"}]},{"id":2316493,"change_date":"2023-02-07 21:41:00","inspection_id":"77793424","dot_number":"707486","report_state":"MI","report_number":"MOREM04604","insp_date":"2023-02-06 00:00:00","insp_start_time":"0810","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ZIMMER RD","county_code_state":"MI","county_code":"065","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":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24950","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":"1112674","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[{"id":3567993,"change_date":"2023-02-07 21:41:00","inspection_id":"77793424","insp_violation_id":"250995538","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:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"},{"id":3567994,"change_date":"2023-02-07 21:41:00","inspection_id":"77793424","insp_violation_id":"250995539","seq_no":"2","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":"X4173775","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3728416,"change_date":"2023-02-07 21:41:00","inspection_id":"77793424","insp_unit_id":"193274162","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1141","insp_unit_license":"BA62757","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF57PX6ED88350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"},{"id":3728417,"change_date":"2023-02-07 21:41:00","inspection_id":"77793424","insp_unit_id":"193274163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WELL","insp_unit_company":"T-90","insp_unit_license":"A329770","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1WC200E25Y2041367","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":2304224,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","dot_number":"707486","report_state":"MI","report_number":"HICKG02044","insp_date":"2023-02-03 00:00:00","insp_start_time":"1510","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112353","transaction_code":"A","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-02-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:13.000000Z","updated_at":"2025-03-17T19:09:13.000000Z","inspection_violations":[{"id":3550722,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967660","seq_no":"7","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193245315","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39378"},{"id":3550723,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967661","seq_no":"8","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"193245315","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39319"},{"id":3550724,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967662","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:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39216A"},{"id":3550725,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967663","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4174370","created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"38323A2"},{"id":3550726,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967664","seq_no":"3","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":"X4174370","created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39141A1"},{"id":3550727,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967665","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193245315","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"39021TB"},{"id":3550728,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967666","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193245315","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3922"},{"id":3550729,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_violation_id":"250967667","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193245315","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:46.000000Z","updated_at":"2025-03-17T21:23:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3709039,"change_date":"2023-02-06 21:41:00","inspection_id":"77779728","insp_unit_id":"193245315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"BA36884","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDM7H1C7XJ518417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:33.000000Z","updated_at":"2025-03-17T22:32:33.000000Z"}]},{"id":1972856,"change_date":"2022-12-29 21:40:00","inspection_id":"77401227","dot_number":"707486","report_state":"MI","report_number":"DAWDD02291","insp_date":"2022-12-16 00:00:00","insp_start_time":"0930","insp_end_time":"1051","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-696 AT I-75","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNDERGROUND CONTRACTORS INC","shipping_paper_number":"12162022","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-12-19 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"36000","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":"1106361","transaction_code":"C","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2022-12-19 21:40:00","snet_input_date":"2022-12-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-19 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:58.000000Z","updated_at":"2025-03-17T19:02:58.000000Z","inspection_violations":[{"id":3062056,"change_date":"2022-12-29 21:40:00","inspection_id":"77401227","insp_violation_id":"250317369","seq_no":"1","part_no":"393","part_no_section":"104(a)","insp_viol_unit":"2","insp_unit_id":"192632559","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4151433","created_at":"2025-03-17T21:21:34.000000Z","updated_at":"2025-03-17T21:21:34.000000Z","normalized_code":"393104A"}],"inspection_per_units":[{"id":3174099,"change_date":"2022-12-29 21:40:00","inspection_id":"77401227","insp_unit_id":"192632558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1142","insp_unit_license":"BC23866","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDC17HZ41427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:44.000000Z","updated_at":"2025-03-17T22:28:44.000000Z"},{"id":3174100,"change_date":"2022-12-29 21:40:00","inspection_id":"77401227","insp_unit_id":"192632559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T-43","insp_unit_license":"SPME","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"NONE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:44.000000Z","updated_at":"2025-03-17T22:28:44.000000Z"}]},{"id":1580799,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","dot_number":"707486","report_state":"MI","report_number":"CELMS00078","insp_date":"2022-10-21 00:00:00","insp_start_time":"1200","insp_end_time":"1235","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":"2","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":"2022-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099426","transaction_code":"A","transaction_date":"2022-10-21 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2022-10-24 21:40:00","snet_input_date":"2022-10-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-24 21:40:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:53.000000Z","updated_at":"2025-03-17T18:55:53.000000Z","inspection_violations":[{"id":2483704,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199300","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191596352","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"39617C"},{"id":2483705,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199301","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191596353","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"39617C"},{"id":2483706,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199302","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191596353","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"39375C"},{"id":2483707,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199303","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"191596353","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"39375C"},{"id":2483708,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199304","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191596353","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"3922"},{"id":2483709,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_violation_id":"249199305","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191596352","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:40.000000Z","updated_at":"2025-03-17T21:18:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2544062,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_unit_id":"191596352","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1147","insp_unit_license":"BD0793","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT1HEB33986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:25.000000Z","updated_at":"2025-03-17T22:24:25.000000Z"},{"id":2544063,"change_date":"2022-10-24 21:40:00","inspection_id":"76951821","insp_unit_id":"191596353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DELTA","insp_unit_company":"T83","insp_unit_license":"D676350","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4MWBT1623AN025535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:25.000000Z","updated_at":"2025-03-17T22:24:25.000000Z"}]},{"id":785318,"change_date":"2022-07-10 21:31:00","inspection_id":"76026301","dot_number":"707486","report_state":"MI","report_number":"LOEDP01485","insp_date":"2022-07-08 00:00:00","insp_start_time":"1950","insp_end_time":"2010","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MATTAWAN EXIT","county_code_state":"MI","county_code":"159","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2022-07-10 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"44000","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":"1083343","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00707486","upload_search_indicator":null,"census_search_date":"2022-07-10 21:31:00","snet_input_date":"2022-07-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-10 21:31:00","insp_carrier_name":"UNDERGROUND CONTRACTORS INC","insp_carrier_street":"30561 ANDERSEN COURT","insp_carrier_city":"WIXOM","insp_carrier_state":"MI","insp_carrier_zip_code":"48393","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:34.000000Z","updated_at":"2025-03-17T18:41:34.000000Z","inspection_violations":[{"id":1238698,"change_date":"2022-07-10 21:31:00","inspection_id":"76026301","insp_violation_id":"246989970","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189689621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:47.000000Z","updated_at":"2025-03-17T21:12:47.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1263558,"change_date":"2022-07-10 21:31:00","inspection_id":"76026301","insp_unit_id":"189689620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1142","insp_unit_license":"BC23866","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDC17HZ41427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"},{"id":1263559,"change_date":"2022-07-10 21:31:00","inspection_id":"76026301","insp_unit_id":"189689621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HURS","insp_unit_company":null,"insp_unit_license":"D698027","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H9T52224S1057011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:57.000000Z","updated_at":"2025-03-17T22:15:57.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/707486\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/707486\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/707486\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/707486\/inspections","per_page":100,"prev_page_url":null,"to":42,"total":42}