{"current_page":1,"data":[{"id":11908747,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","dot_number":"75786","report_state":"MI","report_number":"GRAHA01306","insp_date":"2026-05-14 00:00:00","insp_start_time":"1001","insp_end_time":"1128","registration_date":null,"region":"ES","ci_status_code":"C","location":"REST","location_desc":"MI","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HORROCKS FARM MARKET INC","shipping_paper_number":"598238","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","viol_total":"10","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3323800","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2026-05-14 21:42:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-14 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-16T13:32:54.000000Z","updated_at":"2026-05-25T09:31:23.000000Z","inspection_violations":[{"id":20715722,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257649","seq_no":"1","part_no":"395","part_no_section":"8F12-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"3958F12HOSM"},{"id":20715723,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257650","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"213551884","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"3929A2C"},{"id":20715724,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257651","seq_no":"3","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"393106BC"},{"id":20715725,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257652","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39345B2BAIR"},{"id":20715726,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257653","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39345B2BAIR"},{"id":20715727,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257654","seq_no":"6","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39348ABMBCBD"},{"id":20715729,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257656","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39347E"},{"id":20715730,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257657","seq_no":"9","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39353BB"},{"id":20715731,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257658","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"3963A1BOS"},{"id":20715728,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_violation_id":"274257655","seq_no":"7","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"213551885","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:08.000000Z","updated_at":"2026-05-25T09:43:35.000000Z","normalized_code":"39348ABMBCBD"}],"inspection_per_units":[{"id":20702928,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_unit_id":"213551884","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"3766309","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4BC9EH2SN688001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:50.000000Z","updated_at":"2026-05-25T09:03:54.000000Z"},{"id":20702929,"change_date":"2026-05-14 21:42:00","inspection_id":"87847911","insp_unit_id":"213551885","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"F329095","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2531GM488460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:50.000000Z","updated_at":"2026-05-25T09:03:54.000000Z"}]},{"id":10382642,"change_date":"2025-12-09 21:38:00","inspection_id":"86512033","dot_number":"75786","report_state":"IN","report_number":"7310002241","insp_date":"2025-12-05 00:00:00","insp_start_time":"0837","insp_end_time":"0915","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BUNKER HILL IN","county_code_state":"IN","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BURNETTE FOODS INC.","shipping_paper_number":"233105 \/ 223354","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":"2025-12-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2631077","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-12-09 21:38:00","snet_input_date":"2025-12-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-09 21:38:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:26.000000Z","updated_at":"2025-12-13T10:30:10.000000Z","inspection_violations":[{"id":17390820,"change_date":"2025-12-09 21:38:00","inspection_id":"86512033","insp_violation_id":"270544424","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:25.000000Z","updated_at":"2025-12-13T10:30:17.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":17356922,"change_date":"2025-12-09 21:38:00","inspection_id":"86512033","insp_unit_id":"210487848","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"492101","insp_unit_license":"3766308","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4BC9EH0SN688000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:22.000000Z","updated_at":"2025-12-13T10:00:09.000000Z"},{"id":17356923,"change_date":"2025-12-09 21:38:00","inspection_id":"86512033","insp_unit_id":"210487849","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"1547","insp_unit_license":"F025360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2537GM488544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:22.000000Z","updated_at":"2025-12-13T10:00:09.000000Z"}]},{"id":9645104,"change_date":"2025-09-10 21:40:00","inspection_id":"85736917","dot_number":"75786","report_state":"MI","report_number":"BESSJ01335","insp_date":"2025-09-10 00:00:00","insp_start_time":"1030","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 @ PINCKNEY RD","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"260474","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1240588","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:39.000000Z","updated_at":"2025-09-13T10:47:39.000000Z","inspection_violations":[{"id":15786842,"change_date":"2025-09-10 21:40:00","inspection_id":"85736917","insp_violation_id":"268584614","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":"X4586842","created_at":"2025-09-13T10:50:43.000000Z","updated_at":"2025-09-14T11:56:07.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15936231,"change_date":"2025-09-10 21:40:00","inspection_id":"85736917","insp_unit_id":"208853895","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"364094","insp_unit_license":"2942524","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"},{"id":15936232,"change_date":"2025-09-10 21:40:00","inspection_id":"85736917","insp_unit_id":"208853896","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1540","insp_unit_license":"E820086","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B6DL754622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"}]},{"id":9077774,"change_date":"2025-07-07 21:40:00","inspection_id":"85140676","dot_number":"75786","report_state":"MI","report_number":"BURGM06774","insp_date":"2025-07-02 00:00:00","insp_start_time":"1345","insp_end_time":"1404","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UPTON RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DC5441","shipping_paper_number":"556406","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52065","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":"1228809","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-07-07 21:40:00","snet_input_date":"2025-07-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:34.000000Z","updated_at":"2025-07-11T10:44:34.000000Z","inspection_violations":[{"id":14615428,"change_date":"2025-07-07 21:40:00","inspection_id":"85140676","insp_violation_id":"267237887","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:39.000000Z","updated_at":"2025-07-11T10:45:59.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14896694,"change_date":"2025-07-07 21:40:00","inspection_id":"85140676","insp_unit_id":"207730366","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"310301","insp_unit_license":"3572699","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHTDV6SSVR1552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:54.000000Z"},{"id":14896695,"change_date":"2025-07-07 21:40:00","inspection_id":"85140676","insp_unit_id":"207730367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1548","insp_unit_license":"F025361","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2531GM488460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:54.000000Z"}]},{"id":8415687,"change_date":"2025-04-18 21:40:00","inspection_id":"84441370","dot_number":"75786","report_state":"MI","report_number":"BURGM06645","insp_date":"2025-04-17 00:00:00","insp_start_time":"1315","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UPTON RD","county_code_state":"MI","county_code":"037","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218162","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:12.000000Z","updated_at":"2025-04-23T10:03:21.000000Z","inspection_violations":[{"id":13278531,"change_date":"2025-04-18 21:40:00","inspection_id":"84441370","insp_violation_id":"265707298","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:02.000000Z","updated_at":"2025-04-22T10:30:37.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":13663959,"change_date":"2025-04-18 21:40:00","inspection_id":"84441370","insp_unit_id":"206388236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352466","insp_unit_license":"3411220","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN879158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:16.000000Z"},{"id":13663960,"change_date":"2025-04-18 21:40:00","inspection_id":"84441370","insp_unit_id":"206388237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1547","insp_unit_license":"F025360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2537GM488544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:16.000000Z"}]},{"id":7832877,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","dot_number":"75786","report_state":"MI","report_number":"BRADD01299","insp_date":"2025-02-07 00:00:00","insp_start_time":"1140","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID AMERICAN SALT","shipping_paper_number":"59015","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-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1209491","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-02-10 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:47.000000Z","updated_at":"2025-03-17T21:00:47.000000Z","inspection_violations":[{"id":12239185,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_violation_id":"264439219","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"205252092","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3922SLLEWA1"},{"id":12239186,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_violation_id":"264439220","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205252093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3939ALRLI"},{"id":12239187,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_violation_id":"264439221","seq_no":"3","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"2","insp_unit_id":"205252093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3939ALSLI"},{"id":12239188,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_violation_id":"264439222","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"2","insp_unit_id":"205252093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3939ALFTSI"},{"id":12239189,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_violation_id":"264439223","seq_no":"5","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"2","insp_unit_id":"205252093","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:41.000000Z","updated_at":"2025-03-17T22:05:41.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":12641514,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_unit_id":"205252092","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":null,"insp_unit_license":"2821856","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN879159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"},{"id":12641515,"change_date":"2025-02-10 21:40:00","inspection_id":"83828546","insp_unit_id":"205252093","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"E820083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B2DL738241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]},{"id":7658491,"change_date":"2025-01-18 21:33:00","inspection_id":"83645171","dot_number":"75786","report_state":"OH","report_number":"1339000227","insp_date":"2025-01-15 00:00:00","insp_start_time":"1212","insp_end_time":"1243","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GRAND RAPIDS OH","county_code_state":"OH","county_code":"095","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-18 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1263727","transaction_code":"A","transaction_date":"2025-01-18 00:00:00","upload_date":"2025-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2025-01-18 21:33:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-18 21:33:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:04.000000Z","updated_at":"2025-03-17T20:57:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12357703,"change_date":"2025-01-18 21:33:00","inspection_id":"83645171","insp_unit_id":"204909391","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"692449","insp_unit_license":"3268402","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH7PN329344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"},{"id":12357704,"change_date":"2025-01-18 21:33:00","inspection_id":"83645171","insp_unit_id":"204909392","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"1549","insp_unit_license":"F105861","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VC532XLM010102","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"}]},{"id":7174830,"change_date":"2024-11-12 21:42:00","inspection_id":"83136244","dot_number":"75786","report_state":"MI","report_number":"WORDN05188","insp_date":"2024-11-08 00:00:00","insp_start_time":"1538","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","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-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1201228","transaction_code":"A","transaction_date":"2024-11-08 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11209373,"change_date":"2024-11-12 21:42:00","inspection_id":"83136244","insp_violation_id":"262849363","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4460817","created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":11572779,"change_date":"2024-11-12 21:42:00","inspection_id":"83136244","insp_unit_id":"203842420","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364094","insp_unit_license":"2942524","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11572780,"change_date":"2024-11-12 21:42:00","inspection_id":"83136244","insp_unit_id":"203842421","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1540","insp_unit_license":"E820086","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B6DL754622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":7003689,"change_date":"2024-10-21 21:41:00","inspection_id":"82954822","dot_number":"75786","report_state":"MI","report_number":"HAMIZ01155","insp_date":"2024-10-17 00:00:00","insp_start_time":"1134","insp_end_time":"1227","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 & MM 274","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1198693","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-10-21 21:41:00","snet_input_date":"2024-10-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":10928094,"change_date":"2024-10-21 21:41:00","inspection_id":"82954822","insp_violation_id":"262460850","seq_no":"1","part_no":"392","part_no_section":"2-DMOVE","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3922DMOVE"}],"inspection_per_units":[{"id":11296701,"change_date":"2024-10-21 21:41:00","inspection_id":"82954822","insp_unit_id":"203503582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352471","insp_unit_license":"3005491","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN879163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"},{"id":11296702,"change_date":"2024-10-21 21:41:00","inspection_id":"82954822","insp_unit_id":"203503583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1546","insp_unit_license":"F025359","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2535GM488414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"}]},{"id":6818464,"change_date":"2024-09-25 21:41:00","inspection_id":"82757984","dot_number":"75786","report_state":"MI","report_number":"MATTJ01580","insp_date":"2024-09-24 00:00:00","insp_start_time":"1220","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"516614","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-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1196080","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10617833,"change_date":"2024-09-25 21:41:00","inspection_id":"82757984","insp_violation_id":"262030970","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"203128350","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10995447,"change_date":"2024-09-25 21:41:00","inspection_id":"82757984","insp_unit_id":"203128349","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"364096","insp_unit_license":"3195945","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN604389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"},{"id":10995448,"change_date":"2024-09-25 21:41:00","inspection_id":"82757984","insp_unit_id":"203128350","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1538","insp_unit_license":"E820084","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B1DL738246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6575245,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","dot_number":"75786","report_state":"MI","report_number":"DOWEM02836","insp_date":"2024-08-27 00:00:00","insp_start_time":"1155","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 BL @ MARATHON GAS STATION","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"SO22305861","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-08-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1191895","transaction_code":"C","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-08-27 21:42:00","snet_input_date":"2024-08-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-27 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10219383,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_violation_id":"261861693","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:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3922"},{"id":10219384,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_violation_id":"261861694","seq_no":"2","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:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3922"},{"id":10219385,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_violation_id":"261861695","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202977532","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"},{"id":10219386,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_violation_id":"261861696","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202977532","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10600229,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_unit_id":"202977531","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"364093","insp_unit_license":"2894203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604289","insp_unit_decal":"Y","insp_unit_decal_number":"34302285","created_at":"2025-03-17T23:32:49.000000Z","updated_at":"2025-03-17T23:32:49.000000Z"},{"id":10600230,"change_date":"2024-09-17 21:45:00","inspection_id":"82498748","insp_unit_id":"202977532","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1292","insp_unit_license":"E956499","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532W85L910163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:49.000000Z","updated_at":"2025-03-17T23:32:49.000000Z"}]},{"id":6084188,"change_date":"2024-06-26 21:43:00","inspection_id":"81973211","dot_number":"75786","report_state":"MI","report_number":"DETGT04761","insp_date":"2024-06-26 00:00:00","insp_start_time":"1130","insp_end_time":"1208","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I94 @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1183668","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9441911,"change_date":"2024-06-26 21:43:00","inspection_id":"81973211","insp_violation_id":"260329169","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9799572,"change_date":"2024-06-26 21:43:00","inspection_id":"81973211","insp_unit_id":"201607076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":null,"insp_unit_license":"2821856","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN879159","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"},{"id":9799573,"change_date":"2024-06-26 21:43:00","inspection_id":"81973211","insp_unit_id":"201607077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"F025360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2537GM488544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":5985557,"change_date":"2024-06-13 21:42:00","inspection_id":"81866829","dot_number":"75786","report_state":"MI","report_number":"LITTJ05106","insp_date":"2024-06-12 00:00:00","insp_start_time":"0850","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 E\/B @ MIDDLEBELT","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1182127","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9285350,"change_date":"2024-06-13 21:42:00","inspection_id":"81866829","insp_violation_id":"260071835","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:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9641118,"change_date":"2024-06-13 21:42:00","inspection_id":"81866829","insp_unit_id":"201382857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"352471","insp_unit_license":"3005491","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN879163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"},{"id":9641119,"change_date":"2024-06-13 21:42:00","inspection_id":"81866829","insp_unit_id":"201382858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1541","insp_unit_license":"E911720","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2538CM269005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":5828368,"change_date":"2024-05-23 21:41:00","inspection_id":"81696199","dot_number":"75786","report_state":"MI","report_number":"MOREM05282","insp_date":"2024-05-23 00:00:00","insp_start_time":"1002","insp_end_time":"1024","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MILLETT HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ALTRIA GROUP","shipping_paper_number":"34598676","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-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1179726","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:16.000000Z","updated_at":"2025-03-17T20:18:16.000000Z","inspection_violations":[{"id":9030447,"change_date":"2024-05-23 21:41:00","inspection_id":"81696199","insp_violation_id":"259695926","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:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9386827,"change_date":"2024-05-23 21:41:00","inspection_id":"81696199","insp_unit_id":"201056250","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364096","insp_unit_license":"3195945","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN604389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:27.000000Z","updated_at":"2025-03-17T23:20:27.000000Z"},{"id":9386828,"change_date":"2024-05-23 21:41:00","inspection_id":"81696199","insp_unit_id":"201056251","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1539T","insp_unit_license":"E820085","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B7DL738249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:27.000000Z","updated_at":"2025-03-17T23:20:27.000000Z"}]},{"id":4528056,"change_date":"2023-11-30 21:38:00","inspection_id":"80276791","dot_number":"75786","report_state":"MI","report_number":"BURGM05734","insp_date":"2023-11-29 00:00:00","insp_start_time":"1415","insp_end_time":"1437","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UPTON RD","county_code_state":"MI","county_code":"037","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":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1155211","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7006089,"change_date":"2023-11-30 21:38:00","inspection_id":"80276791","insp_violation_id":"256641331","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3922"},{"id":7006090,"change_date":"2023-11-30 21:38:00","inspection_id":"80276791","insp_violation_id":"256641332","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198284925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7282435,"change_date":"2023-11-30 21:38:00","inspection_id":"80276791","insp_unit_id":"198284925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364096","insp_unit_license":"3195945","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN604389","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"},{"id":7282436,"change_date":"2023-11-30 21:38:00","inspection_id":"80276791","insp_unit_id":"198284926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1541","insp_unit_license":"E911720","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2538CM269005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":3974206,"change_date":"2023-09-14 21:41:00","inspection_id":"79664186","dot_number":"75786","report_state":"MI","report_number":"MYERD00900","insp_date":"2023-09-14 00:00:00","insp_start_time":"1335","insp_end_time":"1352","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 WB @ 127 MM","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"248470","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1146197","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-09-14 21:41:00","snet_input_date":"2023-09-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-14 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:14.000000Z","updated_at":"2025-03-17T19:41:14.000000Z","inspection_violations":[{"id":6146284,"change_date":"2023-09-14 21:41:00","inspection_id":"79664186","insp_violation_id":"255270129","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":"X4257254","created_at":"2025-03-17T21:35:43.000000Z","updated_at":"2025-03-17T21:35:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6390376,"change_date":"2023-09-14 21:41:00","inspection_id":"79664186","insp_unit_id":"197057317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2894203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"},{"id":6390377,"change_date":"2023-09-14 21:41:00","inspection_id":"79664186","insp_unit_id":"197057318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TODC","insp_unit_company":null,"insp_unit_license":"E911720","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2538CM269005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:41.000000Z","updated_at":"2025-03-17T22:53:41.000000Z"}]},{"id":3511830,"change_date":"2023-07-14 21:41:00","inspection_id":"79147411","dot_number":"75786","report_state":"MI","report_number":"PEASS02622","insp_date":"2023-07-14 00:00:00","insp_start_time":"0640","insp_end_time":"0720","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ SAFE ENFORCEMENT SIT","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MENARDS","shipping_paper_number":"4916035","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1135389","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-07-14 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:28.000000Z","updated_at":"2025-03-17T19:32:28.000000Z","inspection_violations":[{"id":5414471,"change_date":"2023-07-14 21:41:00","inspection_id":"79147411","insp_violation_id":"254069525","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":"X4253085","created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3922"},{"id":5414472,"change_date":"2023-07-14 21:41:00","inspection_id":"79147411","insp_violation_id":"254069526","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":5646864,"change_date":"2023-07-14 21:41:00","inspection_id":"79147411","insp_unit_id":"196008203","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364093","insp_unit_license":"2894203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"},{"id":5646865,"change_date":"2023-07-14 21:41:00","inspection_id":"79147411","insp_unit_id":"196008204","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1540","insp_unit_license":"E820086","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B6DL754622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":2767928,"change_date":"2023-04-11 12:04:00","inspection_id":"78308112","dot_number":"75786","report_state":"MI","report_number":"MYERZ00116","insp_date":"2023-04-10 00:00:00","insp_start_time":"1339","insp_end_time":"1419","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 WB @ I-196","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1121205","transaction_code":"A","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-04-11 12:04:00","snet_input_date":"2023-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4246901,"change_date":"2023-04-11 12:04:00","inspection_id":"78308112","insp_violation_id":"252130037","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194304948","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"3939A"},{"id":4246902,"change_date":"2023-04-11 12:04:00","inspection_id":"78308112","insp_violation_id":"252130038","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194304948","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4455064,"change_date":"2023-04-11 12:04:00","inspection_id":"78308112","insp_unit_id":"194304947","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"IHC","insp_unit_company":"605","insp_unit_license":"3005491","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN879163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"},{"id":4455065,"change_date":"2023-04-11 12:04:00","inspection_id":"78308112","insp_unit_id":"194304948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1520","insp_unit_license":"E337640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C4DT064019","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"}]},{"id":2285988,"change_date":"2023-02-02 21:42:00","inspection_id":"77758948","dot_number":"75786","report_state":"MI","report_number":"LULAN01641","insp_date":"2023-02-01 00:00:00","insp_start_time":"0950","insp_end_time":"1018","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 @ GRANDRIVER","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1111829","transaction_code":"A","transaction_date":"2023-02-01 00:00:00","upload_date":"2023-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-02-02 21:42:00","snet_input_date":"2023-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-02 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:51.000000Z","updated_at":"2025-03-17T19:08:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3679100,"change_date":"2023-02-02 21:42:00","inspection_id":"77758948","insp_unit_id":"193200900","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"2942525","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN604388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"},{"id":3679101,"change_date":"2023-02-02 21:42:00","inspection_id":"77758948","insp_unit_id":"193200901","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"E121097","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2530EM944235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:21.000000Z","updated_at":"2025-03-17T22:32:21.000000Z"}]},{"id":2131983,"change_date":"2023-01-12 21:42:00","inspection_id":"77582997","dot_number":"75786","report_state":"MI","report_number":"LINEM00396","insp_date":"2023-01-12 00:00:00","insp_start_time":"1050","insp_end_time":"1141","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RENEWABLE ENERGY SUPPLIERS","shipping_paper_number":"RES58238","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-01-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1108953","transaction_code":"A","transaction_date":"2023-01-12 00:00:00","upload_date":"2023-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-01-12 21:42:00","snet_input_date":"2023-01-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-12 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:53.000000Z","updated_at":"2025-03-17T19:05:53.000000Z","inspection_violations":[{"id":3297760,"change_date":"2023-01-12 21:42:00","inspection_id":"77582997","insp_violation_id":"250545594","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:22:35.000000Z","updated_at":"2025-03-17T21:22:35.000000Z","normalized_code":"3922"},{"id":3297761,"change_date":"2023-01-12 21:42:00","inspection_id":"77582997","insp_violation_id":"250545595","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:35.000000Z","updated_at":"2025-03-17T21:22:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3430936,"change_date":"2023-01-12 21:42:00","inspection_id":"77582997","insp_unit_id":"192848043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"364093","insp_unit_license":"2894203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604289","insp_unit_decal":"Y","insp_unit_decal_number":"32322443","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"},{"id":3430937,"change_date":"2023-01-12 21:42:00","inspection_id":"77582997","insp_unit_id":"192848044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"1538","insp_unit_license":"E820084","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532B1DL738246","insp_unit_decal":"Y","insp_unit_decal_number":"32322444","created_at":"2025-03-17T22:30:36.000000Z","updated_at":"2025-03-17T22:30:36.000000Z"}]},{"id":2084762,"change_date":"2023-01-06 21:39:00","inspection_id":"77528800","dot_number":"75786","report_state":"MI","report_number":"DEJOS00199","insp_date":"2023-01-06 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ SARGENT RD","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AMERICAN INTERNATIONAL","shipping_paper_number":"715792","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-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1107983","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2023-01-06 21:39:00","snet_input_date":"2023-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:06.000000Z","updated_at":"2025-03-17T19:05:06.000000Z","inspection_violations":[{"id":3225684,"change_date":"2023-01-06 21:39:00","inspection_id":"77528800","insp_violation_id":"250428472","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192738612","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3354039,"change_date":"2023-01-06 21:39:00","inspection_id":"77528800","insp_unit_id":"192738611","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352470","insp_unit_license":"2850147","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN879162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:00.000000Z","updated_at":"2025-03-17T22:30:00.000000Z"},{"id":3354040,"change_date":"2023-01-06 21:39:00","inspection_id":"77528800","insp_unit_id":"192738612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"1300","insp_unit_license":"D162063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA06297W703667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:00.000000Z","updated_at":"2025-03-17T22:30:00.000000Z"}]},{"id":1869538,"change_date":"2022-12-05 21:40:00","inspection_id":"77282805","dot_number":"75786","report_state":"MI","report_number":"LARSE02991","insp_date":"2022-12-02 00:00:00","insp_start_time":"1115","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MID-AMERICAN SALT","shipping_paper_number":"49499","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-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1104381","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-12-05 21:40:00","snet_input_date":"2022-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:06.000000Z","updated_at":"2025-03-17T19:01:06.000000Z","inspection_violations":[{"id":2910535,"change_date":"2022-12-05 21:40:00","inspection_id":"77282805","insp_violation_id":"249913865","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192255778","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3922"},{"id":2910536,"change_date":"2022-12-05 21:40:00","inspection_id":"77282805","insp_violation_id":"249913866","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"192255779","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4148408","created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3008787,"change_date":"2022-12-05 21:40:00","inspection_id":"77282805","insp_unit_id":"192255778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352468","insp_unit_license":"2850145","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR1LN879160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:35.000000Z","updated_at":"2025-03-17T22:27:35.000000Z"},{"id":3008788,"change_date":"2022-12-05 21:40:00","inspection_id":"77282805","insp_unit_id":"192255779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538476","insp_unit_license":"E655648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1HT351002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:35.000000Z","updated_at":"2025-03-17T22:27:35.000000Z"}]},{"id":1707677,"change_date":"2022-11-09 21:40:00","inspection_id":"77097316","dot_number":"75786","report_state":"MI","report_number":"GRAHA00022","insp_date":"2022-11-07 00:00:00","insp_start_time":"1026","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NLAKEPLEASANT RD@IMLAY CITY RD","county_code_state":"MI","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"COLUMBIAN LOGISTICS NETWORK","shipping_paper_number":"0211883","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"1101537","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675783,"change_date":"2022-11-09 21:40:00","inspection_id":"77097316","insp_violation_id":"249518888","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:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2747191,"change_date":"2022-11-09 21:40:00","inspection_id":"77097316","insp_unit_id":"191883482","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"367170","insp_unit_license":"2941804","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN550008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2747192,"change_date":"2022-11-09 21:40:00","inspection_id":"77097316","insp_unit_id":"191883483","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1488","insp_unit_license":"E188678","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2538DM625809","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1592915,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","dot_number":"75786","report_state":"MI","report_number":"LARSE02956","insp_date":"2022-10-24 00:00:00","insp_start_time":"1350","insp_end_time":"1435","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CERTAINTEED LLC","shipping_paper_number":"83343673","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-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1099474","transaction_code":"C","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-10-25 21:40:00","snet_input_date":"2022-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-25 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:57.000000Z","updated_at":"2025-03-17T18:55:57.000000Z","inspection_violations":[{"id":2502420,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014272","seq_no":"1","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"39524D"},{"id":2502421,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014273","seq_no":"2","part_no":"395","part_no_section":"22(b)(2)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"39522B2II"},{"id":2502422,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014274","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195957076","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"39395A"},{"id":2502423,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014275","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195957076","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"3922"},{"id":2502424,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014276","seq_no":"5","part_no":"393","part_no_section":"102(a)(1)(ii)","insp_viol_unit":"2","insp_unit_id":"195957077","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"393102A1II"},{"id":2502425,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_violation_id":"254014277","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"195957077","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4133214","created_at":"2025-03-17T21:18:46.000000Z","updated_at":"2025-03-17T21:18:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2563014,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_unit_id":"195957076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352471","insp_unit_license":"2850148","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR7LN879163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:34.000000Z","updated_at":"2025-03-17T22:24:34.000000Z"},{"id":2563015,"change_date":"2023-07-12 21:41:00","inspection_id":"76965686","insp_unit_id":"195957077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"1522","insp_unit_license":"E337641","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1DT064026","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:34.000000Z","updated_at":"2025-03-17T22:24:34.000000Z"}]},{"id":1158890,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","dot_number":"75786","report_state":"MI","report_number":"LARSE02869","insp_date":"2022-08-26 00:00:00","insp_start_time":"1425","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CERTAINTEED LLC","shipping_paper_number":"CS0002658739","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-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1091772","transaction_code":"A","transaction_date":"2022-08-26 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-08-29 21:42:00","snet_input_date":"2022-08-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1836036,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","insp_violation_id":"248064066","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","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":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3958A1"},{"id":1836037,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","insp_violation_id":"248064067","seq_no":"2","part_no":"393","part_no_section":"102(a)(1)(ii)","insp_viol_unit":"2","insp_unit_id":"190596798","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"393102A1II"},{"id":1836038,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","insp_violation_id":"248064068","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190596798","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4108803","created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1863270,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","insp_unit_id":"190596798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"537733","insp_unit_license":"E564314","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K9NS329015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"},{"id":1863271,"change_date":"2022-08-29 21:42:00","inspection_id":"76463094","insp_unit_id":"190596799","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352466","insp_unit_license":"2850144","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN879158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":1097852,"change_date":"2022-08-22 21:42:00","inspection_id":"76392090","dot_number":"75786","report_state":"MI","report_number":"MANIJ01167","insp_date":"2022-08-19 00:00:00","insp_start_time":"1045","insp_end_time":"1057","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MENARDS","shipping_paper_number":"331292259","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1090651","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:57.000000Z","updated_at":"2025-03-17T18:46:57.000000Z","inspection_violations":[{"id":1728193,"change_date":"2022-08-22 21:42:00","inspection_id":"76392090","insp_violation_id":"247882460","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1765738,"change_date":"2022-08-22 21:42:00","inspection_id":"76392090","insp_unit_id":"190454396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"367170","insp_unit_license":"2941804","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN550008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"},{"id":1765739,"change_date":"2022-08-22 21:42:00","inspection_id":"76392090","insp_unit_id":"190454397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"535898","insp_unit_license":"E529106","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C7FT120005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:09.000000Z","updated_at":"2025-03-17T22:19:09.000000Z"}]},{"id":697540,"change_date":"2022-06-27 21:40:00","inspection_id":"75923689","dot_number":"75786","report_state":"MI","report_number":"KIRKB03517","insp_date":"2022-06-24 00:00:00","insp_start_time":"1120","insp_end_time":"1150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 & LATSON","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1081497","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1094574,"change_date":"2022-06-27 21:40:00","inspection_id":"75923689","insp_violation_id":"246727177","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1120619,"change_date":"2022-06-27 21:40:00","inspection_id":"75923689","insp_unit_id":"189471575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364093","insp_unit_license":"2894203","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"},{"id":1120620,"change_date":"2022-06-27 21:40:00","inspection_id":"75923689","insp_unit_id":"189471576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"537733","insp_unit_license":"E564314","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K9NS329015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:06.000000Z","updated_at":"2025-03-17T22:15:06.000000Z"}]},{"id":573401,"change_date":"2022-06-09 21:42:00","inspection_id":"75776122","dot_number":"75786","report_state":"MI","report_number":"LARSE02758","insp_date":"2022-06-08 00:00:00","insp_start_time":"1510","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CEDAR SPRINGS AVE","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078634","transaction_code":"A","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-06-09 21:42:00","snet_input_date":"2022-06-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-09 21:42:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:47.000000Z","updated_at":"2025-03-17T18:37:47.000000Z","inspection_violations":[{"id":896921,"change_date":"2022-06-09 21:42:00","inspection_id":"75776122","insp_violation_id":"246327180","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4069082","created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":922110,"change_date":"2022-06-09 21:42:00","inspection_id":"75776122","insp_unit_id":"189140466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"352469","insp_unit_license":"2850146","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN879161","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"},{"id":922111,"change_date":"2022-06-09 21:42:00","inspection_id":"75776122","insp_unit_id":"189140467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D162063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA06297W703667","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"}]},{"id":539795,"change_date":"2022-06-09 21:42:00","inspection_id":"75736655","dot_number":"75786","report_state":"MI","report_number":"COLLD02463","insp_date":"2022-06-02 00:00:00","insp_start_time":"0855","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US 131 NEAR MM 122","county_code_state":"MI","county_code":"117","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GNT","shipping_paper_number":"SOR22-108077","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1078353","transaction_code":"C","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":null,"census_search_date":"2022-06-03 21:40:00","snet_input_date":"2022-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-03 21:40:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:06.000000Z","updated_at":"2025-03-17T18:37:06.000000Z","inspection_violations":[{"id":852436,"change_date":"2022-06-09 21:42:00","inspection_id":"75736655","insp_violation_id":"246331985","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189144363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:02.000000Z","updated_at":"2025-03-17T21:11:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":868673,"change_date":"2022-06-09 21:42:00","inspection_id":"75736655","insp_unit_id":"189144362","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"367170","insp_unit_license":"2941804","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR5LN550008","insp_unit_decal":"Y","insp_unit_decal_number":"31294189","created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"},{"id":868674,"change_date":"2022-06-09 21:42:00","inspection_id":"75736655","insp_unit_id":"189144363","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"1488","insp_unit_license":"E188678","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2538DM625809","insp_unit_decal":"Y","insp_unit_decal_number":"31294190","created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":242567,"change_date":"2022-04-25 21:41:00","inspection_id":"75382326","dot_number":"75786","report_state":"IN","report_number":"9015004016","insp_date":"2022-04-22 00:00:00","insp_start_time":"0925","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":"1394E","location_desc":"#13  I-94 EB  PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"NATIONAL GYPSUM","shipping_paper_number":"6101142153","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2125902","transaction_code":"A","transaction_date":"2022-04-25 00:00:00","upload_date":"2022-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00075786","upload_search_indicator":"M","census_search_date":"2022-04-25 21:41:00","snet_input_date":"2022-04-25 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"COLUMBIAN DISTRIBUTION SERVICES INC","insp_carrier_street":"900 HALL STREET SW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49503","insp_colonia":null,"docket_number":"52580","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:51.000000Z","updated_at":"2025-03-17T18:31:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":393315,"change_date":"2022-04-25 21:41:00","inspection_id":"75382326","insp_unit_id":"188314938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"364094","insp_unit_license":"2942524","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDWTZR3LN604387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"},{"id":393316,"change_date":"2022-04-25 21:41:00","inspection_id":"75382326","insp_unit_id":"188314939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"539573","insp_unit_license":"D768361","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9JT401005","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/75786\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/75786\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/75786\/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\/75786\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}