{"current_page":1,"data":[{"id":12098357,"change_date":"2026-06-04 21:46:00","inspection_id":"88042643","dot_number":"1653969","report_state":"MI","report_number":"ROLLJ03080","insp_date":"2026-06-04 00:00:00","insp_start_time":"0905","insp_end_time":"0915","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-04 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"3467025","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2026-06-04 21:46:00","snet_input_date":"2026-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:46:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:54.000000Z","updated_at":"2026-06-11T09:36:13.000000Z","inspection_violations":[{"id":21054702,"change_date":"2026-06-04 21:46:00","inspection_id":"88042643","insp_violation_id":"274696462","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4706775","created_at":"2026-06-07T10:01:00.000000Z","updated_at":"2026-06-11T09:50:41.000000Z","normalized_code":"39216D"},{"id":21054703,"change_date":"2026-06-04 21:46:00","inspection_id":"88042643","insp_violation_id":"274696463","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:01:00.000000Z","updated_at":"2026-06-11T09:50:41.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":21021725,"change_date":"2026-06-04 21:46:00","inspection_id":"88042643","insp_unit_id":"213914701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD72968","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WDNFL6CG339958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:03.000000Z","updated_at":"2026-06-11T09:09:49.000000Z"}]},{"id":11817710,"change_date":"2026-05-04 21:39:00","inspection_id":"87752014","dot_number":"1653969","report_state":"MI","report_number":"RICKE01127","insp_date":"2026-05-03 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"ES","ci_status_code":"C","location":"ROAD","location_desc":"MI","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"3255622","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2026-05-04 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-04 21:39:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-07T09:38:59.000000Z","updated_at":"2026-05-14T12:30:43.000000Z","inspection_violations":[{"id":20550940,"change_date":"2026-05-04 21:39:00","inspection_id":"87752014","insp_violation_id":"274019610","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:25.000000Z","updated_at":"2026-05-14T12:41:56.000000Z","normalized_code":"3922SLLS2"},{"id":20550941,"change_date":"2026-05-04 21:39:00","inspection_id":"87752014","insp_violation_id":"274019611","seq_no":"2","part_no":"392","part_no_section":"2-SLL","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":"2026-05-07T09:57:25.000000Z","updated_at":"2026-05-14T12:41:56.000000Z","normalized_code":"3922SLL"},{"id":20550942,"change_date":"2026-05-04 21:39:00","inspection_id":"87752014","insp_violation_id":"274019612","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","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-05-07T09:57:25.000000Z","updated_at":"2026-05-14T12:41:56.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":20554824,"change_date":"2026-05-04 21:39:00","inspection_id":"87752014","insp_unit_id":"213363160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD43795","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D3MX48C46G266233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:33.000000Z","updated_at":"2026-05-14T11:48:34.000000Z"}]},{"id":11119092,"change_date":"2026-03-06 21:42:00","inspection_id":"87032056","dot_number":"1653969","report_state":"MI","report_number":"RICKE01007","insp_date":"2026-02-11 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B MACKINAW TRAIL & BUS 131","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"1258856","transaction_code":"C","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2026-02-12 21:40:00","snet_input_date":"2026-02-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-12 21:40:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:47.000000Z","updated_at":"2026-03-17T09:30:29.000000Z","inspection_violations":[{"id":19034626,"change_date":"2026-03-06 21:42:00","inspection_id":"87032056","insp_violation_id":"272249075","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-03-09T10:08:53.000000Z","updated_at":"2026-03-17T09:40:53.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":19341943,"change_date":"2026-03-06 21:42:00","inspection_id":"87032056","insp_unit_id":"212012084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD43795","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D3MX48C46G266233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:20.000000Z","updated_at":"2026-03-17T09:02:35.000000Z"}]},{"id":11094963,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","dot_number":"1653969","report_state":"MI","report_number":"BEAMW04702","insp_date":"2026-02-09 00:00:00","insp_start_time":"1520","insp_end_time":"1538","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"75 N @ WILSON","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"226150979702","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":"2026-02-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"162000","viol_total":"4","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1258489","transaction_code":"C","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2026-02-10 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-10 21:38:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:52.000000Z","updated_at":"2026-03-17T09:30:26.000000Z","inspection_violations":[{"id":19033647,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_violation_id":"272248027","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:51.000000Z","updated_at":"2026-03-17T09:40:45.000000Z","normalized_code":"3922SLLED"},{"id":19033648,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_violation_id":"272248028","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:51.000000Z","updated_at":"2026-03-17T09:40:45.000000Z","normalized_code":"3922SLLSIV"},{"id":19033649,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_violation_id":"272248029","seq_no":"3","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":"4643391","created_at":"2026-03-09T10:08:51.000000Z","updated_at":"2026-03-17T09:40:45.000000Z","normalized_code":"3922SLLSR"},{"id":19033650,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_violation_id":"272248030","seq_no":"4","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:51.000000Z","updated_at":"2026-03-17T09:40:45.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":19341141,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_unit_id":"212011206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC61718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB9X7PJ597786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:19.000000Z","updated_at":"2026-03-17T09:02:29.000000Z"},{"id":19341142,"change_date":"2026-03-06 21:42:00","inspection_id":"87006778","insp_unit_id":"212011207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"B724000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112SD2489YL054130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:19.000000Z","updated_at":"2026-03-17T09:02:29.000000Z"}]},{"id":10138462,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","dot_number":"1653969","report_state":"MI","report_number":"OSHEE02762","insp_date":"2025-11-04 00:00:00","insp_start_time":"1409","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ TUSTIN REST AREA","county_code_state":"MI","county_code":"133","insp_level_id":"1","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":"Y","traffic_enf":"N","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":"130000","viol_total":"14","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249400","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2025-11-06 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:43.000000Z","updated_at":"2025-11-10T10:31:00.000000Z","inspection_violations":[{"id":16822112,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784093","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4617996","created_at":"2025-11-09T10:32:56.000000Z","updated_at":"2025-11-10T10:32:00.000000Z","normalized_code":"3922SLLEWG3"},{"id":16822113,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784094","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"20","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:32:00.000000Z","normalized_code":"3939ALCL"},{"id":16822114,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784095","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"28","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:32:00.000000Z","normalized_code":"39395A4EEUS"},{"id":16822115,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784096","seq_no":"4","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"20","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:32:00.000000Z","normalized_code":"3939ALBL"},{"id":16822116,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784097","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"30","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:32:00.000000Z","normalized_code":"3965BL"},{"id":16822117,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784098","seq_no":"6","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"16","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:32:00.000000Z","normalized_code":"39345DB"},{"id":16822118,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784099","seq_no":"7","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"20","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:32:00.000000Z","normalized_code":"3939ALTSIR"},{"id":16822119,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784100","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"15","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:32:00.000000Z","normalized_code":"39347E"},{"id":16822120,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784101","seq_no":"9","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"209884923","insp_violation_category_id":"16","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:32:00.000000Z","normalized_code":"39353BB"},{"id":16822121,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784102","seq_no":"10","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"209884924","insp_violation_category_id":"20","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:32:00.000000Z","normalized_code":"39311A1LLPL"},{"id":16822122,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784103","seq_no":"11","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209884924","insp_violation_category_id":"15","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:32:00.000000Z","normalized_code":"39347E"},{"id":16822123,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784104","seq_no":"12","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"209884924","insp_violation_category_id":"16","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:32:00.000000Z","normalized_code":"39353BB"},{"id":16822124,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784105","seq_no":"13","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209884924","insp_violation_category_id":"15","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:32:00.000000Z","normalized_code":"39347E"},{"id":16822125,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_violation_id":"269784106","seq_no":"14","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"209884924","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-09T10:32:56.000000Z","updated_at":"2025-11-10T10:32:00.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":16876773,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_unit_id":"209884923","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"29965","insp_unit_license":"BD83010","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKXAM0067PX5736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:32.000000Z"},{"id":16876774,"change_date":"2025-11-06 21:40:00","inspection_id":"86256004","insp_unit_id":"209884924","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BENS","insp_unit_company":"10635","insp_unit_license":"E874992","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NUDT48F4XMSS0081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:32.000000Z"}]},{"id":8963171,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","dot_number":"1653969","report_state":"MI","report_number":"RICKE00669","insp_date":"2025-06-18 00:00:00","insp_start_time":"0810","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B M-55 & LACHANCE RD","county_code_state":"MI","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"188400","viol_total":"6","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226827","transaction_code":"A","transaction_date":"2025-06-18 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14396232,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989287","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":"WARNING","created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"39216AD"},{"id":14396233,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989288","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4546844","created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"39021TB2DOT"},{"id":14396234,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989289","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"207510567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"3939ALCL"},{"id":14396235,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989290","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207510567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"3939ALIL"},{"id":14396236,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989291","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207510567","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"39378AWS"},{"id":14396237,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_violation_id":"266989292","seq_no":"6","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207510567","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:58.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":14693363,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_unit_id":"207510567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BA68536","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPAD60X7VN436362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:11.000000Z"},{"id":14693364,"change_date":"2025-06-23 21:41:00","inspection_id":"85019999","insp_unit_id":"207510568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":null,"insp_unit_license":"F048618","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKJ050355B119422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:11.000000Z"}]},{"id":8440903,"change_date":"2025-04-22 21:41:00","inspection_id":"84468059","dot_number":"1653969","report_state":"MI","report_number":"RICKE00579","insp_date":"2025-04-21 00:00:00","insp_start_time":"1520","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B BUS 131 & MACKINAW TRAIL","county_code_state":"MI","county_code":"165","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-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"1218547","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:25.000000Z","updated_at":"2025-04-26T10:27:25.000000Z","inspection_violations":[{"id":13331851,"change_date":"2025-04-22 21:41:00","inspection_id":"84468059","insp_violation_id":"265767294","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-04-25T10:53:54.000000Z","updated_at":"2025-04-25T11:04:59.000000Z","normalized_code":"3922SLL"},{"id":13331852,"change_date":"2025-04-22 21:41:00","inspection_id":"84468059","insp_violation_id":"265767295","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4518287","created_at":"2025-04-25T10:53:54.000000Z","updated_at":"2025-04-25T11:04:59.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":13708842,"change_date":"2025-04-22 21:41:00","inspection_id":"84468059","insp_unit_id":"206436887","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD43795","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D3MX48C46G266233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:13:13.000000Z","updated_at":"2025-04-26T10:04:22.000000Z"}]},{"id":7194877,"change_date":"2024-11-14 21:41:00","inspection_id":"83157408","dot_number":"1653969","report_state":"MI","report_number":"RICKE00336","insp_date":"2024-11-14 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B MACKINAW TRAIL & BUS 131","county_code_state":"MI","county_code":"165","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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10001","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":"1201633","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-11-14 21:41:00","snet_input_date":"2024-11-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-14 21:41:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:03.000000Z","updated_at":"2025-03-17T20:46:03.000000Z","inspection_violations":[{"id":11243099,"change_date":"2024-11-14 21:41:00","inspection_id":"83157408","insp_violation_id":"262896105","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4462757","created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLL"},{"id":11243100,"change_date":"2024-11-14 21:41:00","inspection_id":"83157408","insp_violation_id":"262896106","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLSIV"},{"id":11243101,"change_date":"2024-11-14 21:41:00","inspection_id":"83157408","insp_violation_id":"262896107","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:36.000000Z","updated_at":"2025-03-17T22:00:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11605376,"change_date":"2024-11-14 21:41:00","inspection_id":"83157408","insp_unit_id":"203882688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD83009","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D7MU48C53G801038","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":6952203,"change_date":"2024-10-14 21:37:00","inspection_id":"82900077","dot_number":"1653969","report_state":"MI","report_number":"BARTC02725","insp_date":"2024-10-11 00:00:00","insp_start_time":"0915","insp_end_time":"0936","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M115 @ 46 RD","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1198156","transaction_code":"A","transaction_date":"2024-10-11 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:02.000000Z","updated_at":"2025-03-17T20:41:02.000000Z","inspection_violations":[{"id":10838810,"change_date":"2024-10-14 21:37:00","inspection_id":"82900077","insp_violation_id":"262333854","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203396462","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:27.000000Z","updated_at":"2025-03-17T21:58:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11213433,"change_date":"2024-10-14 21:37:00","inspection_id":"82900077","insp_unit_id":"203396462","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC61718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB9X7PJ59778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"},{"id":11213434,"change_date":"2024-10-14 21:37:00","inspection_id":"82900077","insp_unit_id":"203396463","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"B724000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112SD2489YL054130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"}]},{"id":6645028,"change_date":"2024-09-17 21:45:00","inspection_id":"82573186","dot_number":"1653969","report_state":"MI","report_number":"ROLLJ02600","insp_date":"2024-09-03 00:00:00","insp_start_time":"0810","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB MITCHELL ST @ 13TH ST","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12200","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":"1193525","transaction_code":"C","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-09-04 21:42:00","snet_input_date":"2024-09-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-04 21:42:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:49.000000Z","updated_at":"2025-03-17T20:34:49.000000Z","inspection_violations":[{"id":10338230,"change_date":"2024-09-17 21:45:00","inspection_id":"82573186","insp_violation_id":"261870897","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3922"},{"id":10338231,"change_date":"2024-09-17 21:45:00","inspection_id":"82573186","insp_violation_id":"261870898","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:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10713410,"change_date":"2024-09-17 21:45:00","inspection_id":"82573186","insp_unit_id":"202984777","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD4379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D3MX48C46G266233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"}]},{"id":6250262,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","dot_number":"1653969","report_state":"MI","report_number":"RICKE00169","insp_date":"2024-07-16 00:00:00","insp_start_time":"1600","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B MITCHELL ST & 10TH ST","county_code_state":"MI","county_code":"165","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-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"138400","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":"1186391","transaction_code":"C","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-07-18 21:40:00","snet_input_date":"2024-07-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[{"id":9710306,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","insp_violation_id":"261871575","seq_no":"1","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":"X4409943","created_at":"2025-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"},{"id":9710307,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","insp_violation_id":"261871576","seq_no":"2","part_no":"392","part_no_section":"16(a)","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-03-17T21:52:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"39216A"},{"id":9710308,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","insp_violation_id":"261871577","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:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10070787,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","insp_unit_id":"202985315","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"402","insp_unit_license":"BA68536","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPAD60X7VN436362","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10070788,"change_date":"2024-09-17 21:45:00","inspection_id":"82151750","insp_unit_id":"202985316","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":null,"insp_unit_license":"D671203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS28473C006615","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":5482452,"change_date":"2024-04-10 21:42:00","inspection_id":"81320011","dot_number":"1653969","report_state":"MI","report_number":"BENNK00673","insp_date":"2024-04-10 00:00:00","insp_start_time":"1010","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M115 @ E LAKE MITCHELL DR","county_code_state":"MI","county_code":"165","insp_level_id":"2","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":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36002","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":"1172889","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[{"id":8465963,"change_date":"2024-04-10 21:42:00","inspection_id":"81320011","insp_violation_id":"258858478","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":"X4361093","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39141A"},{"id":8465964,"change_date":"2024-04-10 21:42:00","inspection_id":"81320011","insp_violation_id":"258858479","seq_no":"2","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"200336039","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393130B"}],"inspection_per_units":[{"id":8831415,"change_date":"2024-04-10 21:42:00","inspection_id":"81320011","insp_unit_id":"200336038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"BD83010","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKXAM0067PX57360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8831416,"change_date":"2024-04-10 21:42:00","inspection_id":"81320011","insp_unit_id":"200336039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"B724000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"112SD2489YL054130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":5482721,"change_date":"2024-04-10 21:42:00","inspection_id":"81320320","dot_number":"1653969","report_state":"MI","report_number":"HINCA00254","insp_date":"2024-04-10 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/W M-115 @ S 29 RD","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10201","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1173072","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[{"id":8466404,"change_date":"2024-04-10 21:42:00","inspection_id":"81320320","insp_violation_id":"258859091","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200336607","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"},{"id":8466405,"change_date":"2024-04-10 21:42:00","inspection_id":"81320320","insp_violation_id":"258859092","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","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-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393104F3"}],"inspection_per_units":[{"id":8831868,"change_date":"2024-04-10 21:42:00","inspection_id":"81320320","insp_unit_id":"200336607","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BB49186","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3D6WH38A28G216211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8831869,"change_date":"2024-04-10 21:42:00","inspection_id":"81320320","insp_unit_id":"200336608","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":null,"insp_unit_license":"D690036","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNTT18238L160360","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":5491323,"change_date":"2024-04-11 21:41:00","inspection_id":"81329687","dot_number":"1653969","report_state":"MI","report_number":"DOWEM02719","insp_date":"2024-04-10 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S31 RD @ M115","county_code_state":"MI","county_code":"165","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"1173234","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8845564,"change_date":"2024-04-11 21:41:00","inspection_id":"81329687","insp_unit_id":"200356326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BA68540","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD09XX7J164838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":1604073,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","dot_number":"1653969","report_state":"MI","report_number":"ROLLJ01990","insp_date":"2022-10-25 00:00:00","insp_start_time":"1445","insp_end_time":"1603","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M115 SE @ SUNNY SIDE DR","county_code_state":"MI","county_code":"165","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"10","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099793","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:16.000000Z","updated_at":"2025-03-17T18:56:16.000000Z","inspection_violations":[{"id":2521435,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262073","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4133523","created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3922"},{"id":2521436,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262074","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39395F"},{"id":2521437,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262075","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3922"},{"id":2521438,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262076","seq_no":"4","part_no":"393","part_no_section":"47(b)","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39347B"},{"id":2521439,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262077","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3963A1"},{"id":2521440,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262078","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"3963A1"},{"id":2521441,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262079","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191650020","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39347E"},{"id":2521442,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262080","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191650021","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39347E"},{"id":2521443,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262081","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191650021","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39347E"},{"id":2521444,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_violation_id":"249262082","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"191650021","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":2581119,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_unit_id":"191650020","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB27058","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FTZA95W2SVA63936","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"},{"id":2581120,"change_date":"2022-10-26 21:39:00","inspection_id":"76978455","insp_unit_id":"191650021","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E442038","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02438GF087203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"}]},{"id":1284702,"change_date":"2022-09-14 21:40:00","inspection_id":"76608471","dot_number":"1653969","report_state":"MI","report_number":"BARTC02059","insp_date":"2022-09-14 00:00:00","insp_start_time":"0725","insp_end_time":"0802","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ MM 170","county_code_state":"MI","county_code":"133","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1094789","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01653969","upload_search_indicator":null,"census_search_date":"2022-09-14 21:40:00","snet_input_date":"2022-09-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"CJ'S EXCAVATING SEPTIC SERVICE INC","insp_carrier_street":"8450 E M-115","insp_carrier_city":"CADILLAC","insp_carrier_state":"MI","insp_carrier_zip_code":"49601","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[{"id":2032501,"change_date":"2022-09-14 21:40:00","inspection_id":"76608471","insp_violation_id":"248408347","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4115302","created_at":"2025-03-17T21:16:20.000000Z","updated_at":"2025-03-17T21:16:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2067923,"change_date":"2022-09-14 21:40:00","inspection_id":"76608471","insp_unit_id":"190896467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC61718","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB9X7PJ597786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"},{"id":2067924,"change_date":"2022-09-14 21:40:00","inspection_id":"76608471","insp_unit_id":"190896468","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E595158","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02436HK031110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1653969\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1653969\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1653969\/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\/1653969\/inspections","per_page":100,"prev_page_url":null,"to":16,"total":16}