{"current_page":1,"data":[{"id":9971947,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","dot_number":"1675044","report_state":"MI","report_number":"DUBOL00259","insp_date":"2025-10-16 00:00:00","insp_start_time":"1750","insp_end_time":"1830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DAVISON @ LIVERNOIS","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"144000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246456","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":"01675044","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":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","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:50.000000Z","inspection_violations":[{"id":16472317,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_violation_id":"269368584","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39216D"},{"id":16472318,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_violation_id":"269368585","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209528893","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39617CPI"},{"id":16472319,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_violation_id":"269368586","seq_no":"3","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"209528893","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39330B"},{"id":16472320,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_violation_id":"269368587","seq_no":"4","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"209528894","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39311A1LIL"},{"id":16472321,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_violation_id":"269368588","seq_no":"5","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"209528894","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:59.000000Z","updated_at":"2025-10-21T10:16:29.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":16557475,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_unit_id":"209528893","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TDK07","insp_unit_license":"BD45248","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPTXXHJ173128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"},{"id":16557476,"change_date":"2025-10-17 21:39:00","inspection_id":"86080635","insp_unit_id":"209528894","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":null,"insp_unit_license":"F221017","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3637T1023049","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-20T09:47:06.000000Z","updated_at":"2025-10-21T09:46:09.000000Z"}]},{"id":9792723,"change_date":"2025-09-26 21:40:00","inspection_id":"85891714","dot_number":"1675044","report_state":"MI","report_number":"CORBJ00306","insp_date":"2025-09-25 00:00:00","insp_start_time":"1245","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"LIVERNES AVE WARREN AVE","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-09-26 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":"1243260","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:09.000000Z","updated_at":"2025-09-30T10:01:09.000000Z","inspection_violations":[{"id":16104486,"change_date":"2025-09-26 21:40:00","inspection_id":"85891714","insp_violation_id":"268951944","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-09-30T10:16:51.000000Z","updated_at":"2025-09-30T10:16:51.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":16229234,"change_date":"2025-09-26 21:40:00","inspection_id":"85891714","insp_unit_id":"209173739","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"TSG03","insp_unit_license":"BE37328","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GD39SEY5PF147740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:51.000000Z"},{"id":16229235,"change_date":"2025-09-26 21:40:00","inspection_id":"85891714","insp_unit_id":"209173740","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"TR59","insp_unit_license":"E669105","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH1828N1260807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:51.000000Z"}]},{"id":9323258,"change_date":"2025-08-04 21:39:00","inspection_id":"85398894","dot_number":"1675044","report_state":"MI","report_number":"WILLD03828","insp_date":"2025-08-01 00:00:00","insp_start_time":"0930","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 & TELEGRAPH","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","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":"63500","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":"1233767","transaction_code":"A","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:45.000000Z","inspection_violations":[{"id":15128391,"change_date":"2025-08-04 21:39:00","inspection_id":"85398894","insp_violation_id":"267824616","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":"X","created_at":"2025-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:54.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":15354233,"change_date":"2025-08-04 21:39:00","inspection_id":"85398894","insp_unit_id":"208225942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BD59790","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPTX3MJ453211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:55.000000Z"}]},{"id":9322643,"change_date":"2025-08-04 21:39:00","inspection_id":"85398222","dot_number":"1675044","report_state":"MI","report_number":"DAWDD04089","insp_date":"2025-07-31 00:00:00","insp_start_time":"1133","insp_end_time":"1228","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 AT MEYERS","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR CONTRACTING","shipping_paper_number":"07312025","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-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"102000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233538","transaction_code":"A","transaction_date":"2025-08-01 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","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":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","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":15127127,"change_date":"2025-08-04 21:39:00","inspection_id":"85398222","insp_violation_id":"267823092","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"208224727","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"X4553670","created_at":"2025-08-07T10:45:35.000000Z","updated_at":"2025-08-08T10:43:48.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":15353179,"change_date":"2025-08-04 21:39:00","inspection_id":"85398222","insp_unit_id":"208224726","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TTM-01","insp_unit_license":"BC12288","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1GR4GY9LM014032","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":15353180,"change_date":"2025-08-04 21:39:00","inspection_id":"85398222","insp_unit_id":"208224727","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"NONE","insp_unit_license":"E624074","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DS24C5L1110495","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":9323243,"change_date":"2025-08-04 21:39:00","inspection_id":"85398878","dot_number":"1675044","report_state":"MI","report_number":"NESBA02253","insp_date":"2025-07-30 00:00:00","insp_start_time":"1745","insp_end_time":"1830","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":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","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":"140700","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":"1233948","transaction_code":"A","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2025-08-04 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-04 21:39:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:52.000000Z","updated_at":"2025-08-08T10:00:45.000000Z","inspection_violations":[{"id":15128355,"change_date":"2025-08-04 21:39:00","inspection_id":"85398878","insp_violation_id":"267824575","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"208225913","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4559880","created_at":"2025-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:54.000000Z","normalized_code":"3922SLLUCR"},{"id":15128356,"change_date":"2025-08-04 21:39:00","inspection_id":"85398878","insp_violation_id":"267824576","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"208225914","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:37.000000Z","updated_at":"2025-08-08T10:43:54.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":15354209,"change_date":"2025-08-04 21:39:00","inspection_id":"85398878","insp_unit_id":"208225913","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"TDP-09","insp_unit_license":"BE23059","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCX4EX9TD788370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:55.000000Z"},{"id":15354210,"change_date":"2025-08-04 21:39:00","inspection_id":"85398878","insp_unit_id":"208225914","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELLI","insp_unit_company":"TR-64","insp_unit_license":"E407907","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3633M9004842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:31.000000Z","updated_at":"2025-08-08T09:45:55.000000Z"}]},{"id":8344093,"change_date":"2025-04-10 21:41:00","inspection_id":"84365917","dot_number":"1675044","report_state":"MI","report_number":"POWED05225","insp_date":"2025-04-09 00:00:00","insp_start_time":"1640","insp_end_time":"1710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SCHOOLCRAFT @ TELEGRAPH","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":"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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"1216751","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:26.000000Z","updated_at":"2025-04-14T10:28:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13536272,"change_date":"2025-04-10 21:41:00","inspection_id":"84365917","insp_unit_id":"206250300","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TDF-41","insp_unit_license":"BD87423","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GY2FEA16405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:18:25.000000Z","updated_at":"2025-04-14T10:03:39.000000Z"},{"id":13536273,"change_date":"2025-04-10 21:41:00","inspection_id":"84365917","insp_unit_id":"206250301","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD","insp_unit_company":"TR-58","insp_unit_license":"E669114","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH1824N1263025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:18:25.000000Z","updated_at":"2025-04-14T10:03:39.000000Z"}]},{"id":6404010,"change_date":"2024-09-17 21:45:00","inspection_id":"82316140","dot_number":"1675044","report_state":"MI","report_number":"DIUBJ03238","insp_date":"2024-08-05 00:00:00","insp_start_time":"1720","insp_end_time":"1833","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-23 NB AT MM 5","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR CONTRACTING","shipping_paper_number":"1","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-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"41000","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":"1188899","transaction_code":"C","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2024-08-06 21:43:00","snet_input_date":"2024-08-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:51.000000Z","updated_at":"2025-03-17T20:29:51.000000Z","inspection_violations":[{"id":9940591,"change_date":"2024-09-17 21:45:00","inspection_id":"82316140","insp_violation_id":"261860709","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"38323A2"},{"id":9940592,"change_date":"2024-09-17 21:45:00","inspection_id":"82316140","insp_violation_id":"261860710","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4419525","created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10320523,"change_date":"2024-09-17 21:45:00","inspection_id":"82316140","insp_unit_id":"202976904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TDK-12","insp_unit_license":"BD72143","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXKTX9NJ464654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:58.000000Z","updated_at":"2025-03-17T23:29:58.000000Z"}]},{"id":5929910,"change_date":"2024-06-06 21:41:00","inspection_id":"81806376","dot_number":"1675044","report_state":"MI","report_number":"DAWDD03574","insp_date":"2024-06-04 00:00:00","insp_start_time":"1257","insp_end_time":"1328","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TELEGRAPH AT 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":"MAJOR CONTRACTING","shipping_paper_number":"-6-42024","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1181136","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:15.000000Z","updated_at":"2025-03-17T20:20:15.000000Z","inspection_violations":[{"id":9195691,"change_date":"2024-06-06 21:41:00","inspection_id":"81806376","insp_violation_id":"259943327","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:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9551241,"change_date":"2024-06-06 21:41:00","inspection_id":"81806376","insp_unit_id":"201268896","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TDK-12","insp_unit_license":"BD72143","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXKTX9NJ464654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5089251,"change_date":"2024-02-20 21:42:00","inspection_id":"80890947","dot_number":"1675044","report_state":"MI","report_number":"BESSJ00354","insp_date":"2024-02-16 00:00:00","insp_start_time":"0745","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FORT ST @ I-75","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"1165564","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8193248,"change_date":"2024-02-20 21:42:00","inspection_id":"80890947","insp_unit_id":"199501801","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TTK-06","insp_unit_license":"BC34731","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDP9X1EJ400976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193249,"change_date":"2024-02-20 21:42:00","inspection_id":"80890947","insp_unit_id":"199501802","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"N\/A","insp_unit_license":"D780064","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02744FF045002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4910262,"change_date":"2024-01-26 21:39:00","inspection_id":"80695051","dot_number":"1675044","report_state":"MI","report_number":"HADZM04160","insp_date":"2024-01-25 00:00:00","insp_start_time":"1710","insp_end_time":"1740","registration_date":null,"region":"ET","ci_status_code":"C","location":"211","location_desc":"AMBASSADOR BRIDGE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"154600","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":"1161783","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2024-01-26 21:39:00","snet_input_date":"2024-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-26 21:39:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:02.000000Z","updated_at":"2025-03-17T20:00:02.000000Z","inspection_violations":[{"id":7565311,"change_date":"2024-01-26 21:39:00","inspection_id":"80695051","insp_violation_id":"257515353","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199127592","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":7901526,"change_date":"2024-01-26 21:39:00","inspection_id":"80695051","insp_unit_id":"199127591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"N\/A","insp_unit_license":"E584539","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FWK5045T1014248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"},{"id":7901527,"change_date":"2024-01-26 21:39:00","inspection_id":"80695051","insp_unit_id":"199127592","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TTK02","insp_unit_license":"BC64600","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDU9X35J087671","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"}]},{"id":4184848,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","dot_number":"1675044","report_state":"MI","report_number":"SCHMC04792","insp_date":"2023-10-12 00:00:00","insp_start_time":"0830","insp_end_time":"0904","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWPORT RD @ MEIJER DIST","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"213000","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":"1149391","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-10-12 21:42:00","snet_input_date":"2023-10-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:42:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[{"id":6478763,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_violation_id":"255803851","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197528142","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4287019","created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39617C"},{"id":6478764,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_violation_id":"255803852","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197528143","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39617C"},{"id":6478765,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_violation_id":"255803853","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197528143","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39617C"},{"id":6478766,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_violation_id":"255803854","seq_no":"4","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:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6729844,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_unit_id":"197528142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TTM-01","insp_unit_license":"BC12288","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M1GR4GY9LM014032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6729845,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_unit_id":"197528143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E624074","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DS24C5L1110495","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6729846,"change_date":"2023-10-12 21:42:00","inspection_id":"79897882","insp_unit_id":"197528144","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"TRST","insp_unit_company":null,"insp_unit_license":"E624075","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4T9DS19E1L1110496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":4092694,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","dot_number":"1675044","report_state":"MI","report_number":"SAHIW01105","insp_date":"2023-09-28 00:00:00","insp_start_time":"1855","insp_end_time":"1935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB-I-96 @ CHICAGO ST","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1148084","transaction_code":"A","transaction_date":"2023-09-28 00:00:00","upload_date":"2023-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-09-29 21:39:00","snet_input_date":"2023-09-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-29 21:39:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:39.000000Z","updated_at":"2025-03-17T19:43:39.000000Z","inspection_violations":[{"id":6333154,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","insp_violation_id":"255573689","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4284281","created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"},{"id":6333155,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","insp_violation_id":"255573690","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"39141A1"},{"id":6333156,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","insp_violation_id":"255573691","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197322089","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:32.000000Z","updated_at":"2025-03-17T21:36:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6579883,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","insp_unit_id":"197322089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"TSG-01","insp_unit_license":"BD45026","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GD39SEY7PF147710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:12.000000Z","updated_at":"2025-03-17T22:55:12.000000Z"},{"id":6579884,"change_date":"2023-09-29 21:39:00","inspection_id":"79795954","insp_unit_id":"197322090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BECKS","insp_unit_company":null,"insp_unit_license":"D278597","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"56WBU1422GE006581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:12.000000Z","updated_at":"2025-03-17T22:55:12.000000Z"}]},{"id":3858882,"change_date":"2023-08-29 21:42:00","inspection_id":"79535883","dot_number":"1675044","report_state":"MI","report_number":"NESBA00793","insp_date":"2023-08-29 00:00:00","insp_start_time":"0800","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"N I-75@SASHABAW RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"138700","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":"1143435","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-08-29 21:42:00","snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6203916,"change_date":"2023-08-29 21:42:00","inspection_id":"79535883","insp_unit_id":"196789243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TDK-02","insp_unit_license":"BD22880","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX7EX1FJ465132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"},{"id":6203917,"change_date":"2023-08-29 21:42:00","inspection_id":"79535883","insp_unit_id":"196789244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELL","insp_unit_company":null,"insp_unit_license":"E407907","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5FTCF3633M9004842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3802510,"change_date":"2023-08-30 21:45:00","inspection_id":"79472757","dot_number":"1675044","report_state":"MI","report_number":"WILLD02946","insp_date":"2023-08-21 00:00:00","insp_start_time":"1355","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PONTIAC SCALES","county_code_state":"MI","county_code":"125","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":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"1141445","transaction_code":"C","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-08-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:01.000000Z","updated_at":"2025-03-17T19:38:01.000000Z","inspection_violations":[{"id":5865075,"change_date":"2023-08-30 21:45:00","inspection_id":"79472757","insp_violation_id":"254989805","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"3922"},{"id":5865076,"change_date":"2023-08-30 21:45:00","inspection_id":"79472757","insp_violation_id":"254989806","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"196817731","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":6113825,"change_date":"2023-08-30 21:45:00","inspection_id":"79472757","insp_unit_id":"196817731","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BD19881","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX18C5CM014876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:21.000000Z","updated_at":"2025-03-17T22:51:21.000000Z"}]},{"id":3457297,"change_date":"2023-07-07 21:41:00","inspection_id":"79086334","dot_number":"1675044","report_state":"MI","report_number":"OMILJ04199","insp_date":"2023-07-06 00:00:00","insp_start_time":"1330","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ MM 24","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-07 21:41: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":"1134106","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-07-07 21:41:00","snet_input_date":"2023-07-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5330223,"change_date":"2023-07-07 21:41:00","inspection_id":"79086334","insp_violation_id":"253931873","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5559249,"change_date":"2023-07-07 21:41:00","inspection_id":"79086334","insp_unit_id":"195884334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BC03741","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDXF7DCXKDF06985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":3118646,"change_date":"2023-05-23 21:42:00","inspection_id":"78704580","dot_number":"1675044","report_state":"MI","report_number":"POWED04207","insp_date":"2023-05-22 00:00:00","insp_start_time":"1730","insp_end_time":"1750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ TELEGRAPH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1127285","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-05-23 21:42:00","snet_input_date":"2023-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5016294,"change_date":"2023-05-23 21:42:00","inspection_id":"78704580","insp_unit_id":"195093296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"N\/A","insp_unit_license":"BB70194","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDAF4HR2AEB01229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":3023470,"change_date":"2023-05-11 21:42:00","inspection_id":"78597261","dot_number":"1675044","report_state":"MI","report_number":"DAWDD02698","insp_date":"2023-05-09 00:00:00","insp_start_time":"0834","insp_end_time":"0939","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 AT REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAJOR CONTRACTING GROUP LLC","shipping_paper_number":"05092023","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-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1125501","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4643400,"change_date":"2023-05-11 21:42:00","inspection_id":"78597261","insp_violation_id":"252774603","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":"X4208158","created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"},{"id":4643401,"change_date":"2023-05-11 21:42:00","inspection_id":"78597261","insp_violation_id":"252774604","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194881529","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4864150,"change_date":"2023-05-11 21:42:00","inspection_id":"78597261","insp_unit_id":"194881529","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TSF-11","insp_unit_license":"BB46374","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF7DC9JDF01105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"},{"id":4864151,"change_date":"2023-05-11 21:42:00","inspection_id":"78597261","insp_unit_id":"194881530","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"645","insp_unit_license":"E505186","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4ZECH2021H1136559","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2337539,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","dot_number":"1675044","report_state":"MI","report_number":"SAHIW00256","insp_date":"2023-02-07 00:00:00","insp_start_time":"1450","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LINCOLIN DR @ WOODVILLA PL","county_code_state":"MI","county_code":"125","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112840","transaction_code":"C","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2023-02-09 21:40:00","snet_input_date":"2023-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"MAJOR CONTRACTING GROUP LLC","insp_carrier_street":"12222 GREENFIELD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:40.000000Z","updated_at":"2025-03-17T19:09:40.000000Z","inspection_violations":[{"id":3600722,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","insp_violation_id":"251069941","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:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"39216A"},{"id":3600723,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","insp_violation_id":"251069942","seq_no":"2","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"39282A1"},{"id":3600724,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","insp_violation_id":"251069943","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193341615","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4175719","created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3761264,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","insp_unit_id":"193341614","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"313-TP","insp_unit_license":"BC75810","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCD40X5ND770330","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:57.000000Z","updated_at":"2025-03-17T22:32:57.000000Z"},{"id":3761265,"change_date":"2023-02-10 21:40:00","inspection_id":"77817586","insp_unit_id":"193341615","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ETNY","insp_unit_company":null,"insp_unit_license":"E243094","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9329339ME111124","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:57.000000Z","updated_at":"2025-03-17T22:32:57.000000Z"}]},{"id":1807143,"change_date":"2022-11-23 21:40:00","inspection_id":"77211525","dot_number":"1675044","report_state":"MI","report_number":"COPEK01749","insp_date":"2022-11-22 00:00:00","insp_start_time":"1140","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US24 @ 5 MILE RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","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":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1103055","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"MAJOR CEMENT COMPANY","insp_carrier_street":"15347 DALE ST","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2825755,"change_date":"2022-11-23 21:40:00","inspection_id":"77211525","insp_violation_id":"249768728","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192110986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"},{"id":2825756,"change_date":"2022-11-23 21:40:00","inspection_id":"77211525","insp_violation_id":"249768729","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192110986","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4142513","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2906958,"change_date":"2022-11-23 21:40:00","inspection_id":"77211525","insp_unit_id":"192110986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"TDS-01","insp_unit_license":"BB36551","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2FZXEXYB2YAF61546","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1572608,"change_date":"2022-10-21 21:39:00","inspection_id":"76942397","dot_number":"1675044","report_state":"MI","report_number":"CELMS00077","insp_date":"2022-10-19 00:00:00","insp_start_time":"1851","insp_end_time":"1906","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B SOUTHFIELD @ PLYMOUTH","county_code_state":"MI","county_code":"159","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":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"129000","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":"1098999","transaction_code":"A","transaction_date":"2022-10-19 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"MAJOR CEMENT COMPANY","insp_carrier_street":"15347 DALE ST","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:36.000000Z","updated_at":"2025-03-17T18:55:36.000000Z","inspection_violations":[{"id":2472472,"change_date":"2022-10-21 21:39:00","inspection_id":"76942397","insp_violation_id":"249178408","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:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":2530937,"change_date":"2022-10-21 21:39:00","inspection_id":"76942397","insp_unit_id":"191576211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"NONE","insp_unit_license":"BC60448","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCL40X1MD761507","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"},{"id":2530938,"change_date":"2022-10-21 21:39:00","inspection_id":"76942397","insp_unit_id":"191576212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOWR","insp_unit_company":"NONE","insp_unit_license":"E129293","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNFT1928L162094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1344581,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","dot_number":"1675044","report_state":"MI","report_number":"RUDDJ00240","insp_date":"2022-09-21 00:00:00","insp_start_time":"1100","insp_end_time":"1135","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WOODMERE @ M-85","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":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-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"28500","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1096029","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01675044","upload_search_indicator":null,"census_search_date":"2022-09-22 21:40:00","snet_input_date":"2022-09-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"MAJOR CEMENT COMPANY","insp_carrier_street":"15347 DALE ST","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48223","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2129635,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","insp_violation_id":"248586086","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191043940","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3939A"},{"id":2129636,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","insp_violation_id":"248586087","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"191043940","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"39343"},{"id":2129637,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","insp_violation_id":"248586088","seq_no":"3","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"191043940","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":2164975,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","insp_unit_id":"191043939","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"NONE","insp_unit_license":"BB23969","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF4GTXCED09095","insp_unit_decal":"Y","insp_unit_decal_number":"31656865","created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"},{"id":2164976,"change_date":"2022-09-22 21:40:00","inspection_id":"76678605","insp_unit_id":"191043940","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"SUPER","insp_unit_company":"NONE","insp_unit_license":"A304123","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E9BE16233A283887","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1675044\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1675044\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1675044\/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\/1675044\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}