{"current_page":1,"data":[{"id":11084077,"change_date":"2026-02-09 21:38:00","inspection_id":"86995388","dot_number":"1786901","report_state":"MI","report_number":"KILYJ02718","insp_date":"2026-02-09 00:00:00","insp_start_time":"1000","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TERMINAL","county_code_state":"MI","county_code":"005","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1258362","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-12T10:37:00.000000Z","updated_at":"2026-02-20T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18900537,"change_date":"2026-02-09 21:38:00","inspection_id":"86995388","insp_unit_id":"211519968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"11","insp_unit_license":"BD28407","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKXAM00XJPJP5768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:38.000000Z","updated_at":"2026-02-20T10:03:53.000000Z"}]},{"id":11084076,"change_date":"2026-02-09 21:38:00","inspection_id":"86995387","dot_number":"1786901","report_state":"MI","report_number":"KILYJ02717","insp_date":"2026-02-09 00:00:00","insp_start_time":"0945","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TERMINAL","county_code_state":"MI","county_code":"005","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1258418","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-12T10:37:00.000000Z","updated_at":"2026-02-20T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18900536,"change_date":"2026-02-09 21:38:00","inspection_id":"86995387","insp_unit_id":"211519967","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9","insp_unit_license":"BD28406","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDGGGG00R113885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:38.000000Z","updated_at":"2026-02-20T10:03:53.000000Z"}]},{"id":11084086,"change_date":"2026-02-09 21:38:00","inspection_id":"86995397","dot_number":"1786901","report_state":"MI","report_number":"KILYJ02719","insp_date":"2026-02-09 00:00:00","insp_start_time":"1015","insp_end_time":"1033","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TERMINAL","county_code_state":"MI","county_code":"005","insp_level_id":"5","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"82600","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":"1258391","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-12T10:37:00.000000Z","updated_at":"2026-02-20T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18900549,"change_date":"2026-02-09 21:38:00","inspection_id":"86995397","insp_unit_id":"211519981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"14","insp_unit_license":"BE13880","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKSBWD18SLVV9353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:38.000000Z","updated_at":"2026-02-20T10:03:53.000000Z"}]},{"id":8963047,"change_date":"2025-06-23 21:41:00","inspection_id":"85019869","dot_number":"1786901","report_state":"MI","report_number":"HARRK01511","insp_date":"2025-06-19 00:00:00","insp_start_time":"1240","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BELLEVILLE RD @ I-94 SERVICE","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GORDON VANLAAN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1226769","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14395923,"change_date":"2025-06-23 21:41:00","inspection_id":"85019869","insp_violation_id":"266988900","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"207510337","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:17:57.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":14693156,"change_date":"2025-06-23 21:41:00","inspection_id":"85019869","insp_unit_id":"207510337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"14","insp_unit_license":"BE13880","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKSBWD18SLVV9353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:11.000000Z"}]},{"id":8806228,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","dot_number":"1786901","report_state":"MI","report_number":"FRIZS03251","insp_date":"2025-06-02 00:00:00","insp_start_time":"1015","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"64TH ST @ BYRON CENTER AVE","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"11","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223774","transaction_code":"A","transaction_date":"2025-06-02 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:07.000000Z","updated_at":"2025-06-07T10:00:39.000000Z","inspection_violations":[{"id":14087589,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637399","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG1","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-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"3922SLLEWG1"},{"id":14087590,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637400","seq_no":"2","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":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"3922SLLEWA2"},{"id":14087591,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637401","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207204399","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39347E"},{"id":14087592,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637402","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"207204399","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39353BB"},{"id":14087593,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637403","seq_no":"5","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"207204399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39311A1CSLRR"},{"id":14087594,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637404","seq_no":"6","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"207204399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"3939ALBL"},{"id":14087595,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637405","seq_no":"7","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"2","insp_unit_id":"207204400","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"393207ASUBL"},{"id":14087596,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637406","seq_no":"8","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"2","insp_unit_id":"207204400","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4522107","created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"393207ASUBL"},{"id":14087597,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637407","seq_no":"9","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"207204400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39345B2BAIR"},{"id":14087598,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637408","seq_no":"10","part_no":"393","part_no_section":"48A-BMBCBD","insp_viol_unit":"2","insp_unit_id":"207204400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39348ABMBCBD"},{"id":14087599,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_violation_id":"266637409","seq_no":"11","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"2","insp_unit_id":"207204400","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:44.000000Z","updated_at":"2025-06-07T10:17:41.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":14413693,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_unit_id":"207204399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC41554","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X14R059204","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-06-06T09:46:50.000000Z","updated_at":"2025-06-07T09:45:50.000000Z"},{"id":14413694,"change_date":"2025-06-03 21:40:00","inspection_id":"84853287","insp_unit_id":"207204400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D538526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F02S790620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:50.000000Z","updated_at":"2025-06-07T09:45:50.000000Z"}]},{"id":6445222,"change_date":"2024-09-17 21:45:00","inspection_id":"82360333","dot_number":"1786901","report_state":"MI","report_number":"LOEDP02757","insp_date":"2024-08-12 00:00:00","insp_start_time":"1115","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"78660","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1189856","transaction_code":"C","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2024-08-12 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:40.000000Z","updated_at":"2025-03-17T20:30:40.000000Z","inspection_violations":[{"id":10008346,"change_date":"2024-09-17 21:45:00","inspection_id":"82360333","insp_violation_id":"261868100","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202982103","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4417019","created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"3922"},{"id":10008347,"change_date":"2024-09-17 21:45:00","inspection_id":"82360333","insp_violation_id":"261868101","seq_no":"2","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"202982103","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:26.000000Z","updated_at":"2025-03-17T21:54:26.000000Z","normalized_code":"393207C"}],"inspection_per_units":[{"id":10388225,"change_date":"2024-09-17 21:45:00","inspection_id":"82360333","insp_unit_id":"202982103","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB09303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDP4EX53J389280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:40.000000Z","updated_at":"2025-03-17T23:30:40.000000Z"}]},{"id":5306672,"change_date":"2024-03-18 21:38:00","inspection_id":"81127957","dot_number":"1786901","report_state":"MI","report_number":"BOSSL00445","insp_date":"2024-03-15 00:00:00","insp_start_time":"0815","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB M6 @ 8 TH AVE","county_code_state":"MI","county_code":"139","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25640","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":"1169310","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2024-03-18 21:38:00","snet_input_date":"2024-03-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-18 21:38:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:53.000000Z","updated_at":"2025-03-17T20:07:53.000000Z","inspection_violations":[{"id":8183552,"change_date":"2024-03-18 21:38:00","inspection_id":"81127957","insp_violation_id":"258432625","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:34.000000Z","updated_at":"2025-03-17T21:45:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8546141,"change_date":"2024-03-18 21:38:00","inspection_id":"81127957","insp_unit_id":"199958378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"LG94C","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C6UR5FL9NG378429","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"},{"id":8546142,"change_date":"2024-03-18 21:38:00","inspection_id":"81127957","insp_unit_id":"199958379","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TOW M","insp_unit_company":null,"insp_unit_license":"C471446","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4KNFT2026CL161669","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:28.000000Z","updated_at":"2025-03-17T23:12:28.000000Z"}]},{"id":5114431,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","dot_number":"1786901","report_state":"MI","report_number":"LOEDP02434","insp_date":"2024-02-21 00:00:00","insp_start_time":"2030","insp_end_time":"2150","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"34100","viol_total":"9","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1165809","transaction_code":"C","transaction_date":"2024-02-22 00:00:00","upload_date":"2024-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[{"id":7886591,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011752","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":"WARNING","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"},{"id":7886592,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011753","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"},{"id":7886593,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011754","seq_no":"3","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:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3958A1"},{"id":7886594,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011755","seq_no":"4","part_no":"392","part_no_section":"9a(a)(2)","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3929AA2"},{"id":7886595,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011756","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4333033","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"},{"id":7886596,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011757","seq_no":"6","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39021TB"},{"id":7886597,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011758","seq_no":"7","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39617C"},{"id":7886598,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011759","seq_no":"8","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39395A"},{"id":7886599,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_violation_id":"258011760","seq_no":"9","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199576993","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":8234071,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_unit_id":"199576993","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"LH07W","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GT49UEY1RF209254","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"},{"id":8234072,"change_date":"2024-02-23 21:41:00","inspection_id":"80918340","insp_unit_id":"199576994","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E577983","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"50HFG3029N1069441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":4977375,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","dot_number":"1786901","report_state":"MI","report_number":"AKERT00090","insp_date":"2024-02-02 00:00:00","insp_start_time":"1217","insp_end_time":"1239","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALGOMA AVE & 14 MILE RD","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1163190","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7666922,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_violation_id":"257666430","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199269550","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3939A"},{"id":7666923,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_violation_id":"257666431","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199269550","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39395A"},{"id":7666924,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_violation_id":"257666432","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199269550","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39395F"},{"id":7666925,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_violation_id":"257666433","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199269551","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3939A"},{"id":7666926,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_violation_id":"257666434","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199269551","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8010907,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_unit_id":"199269550","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"6","insp_unit_license":"BC41554","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X14R059204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"},{"id":8010908,"change_date":"2024-02-05 21:40:00","inspection_id":"80768634","insp_unit_id":"199269551","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D538526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F02S790620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:37.000000Z","updated_at":"2025-03-17T23:07:37.000000Z"}]},{"id":4433189,"change_date":"2023-11-15 21:41:00","inspection_id":"80172486","dot_number":"1786901","report_state":"MI","report_number":"WASCC00461","insp_date":"2023-11-14 00:00:00","insp_start_time":"1700","insp_end_time":"1713","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB 142ND AVE NEAR 12TH ST","county_code_state":"MI","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-15 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":"1153488","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:44.000000Z","updated_at":"2025-03-17T19:50:44.000000Z","inspection_violations":[{"id":6860885,"change_date":"2023-11-15 21:41:00","inspection_id":"80172486","insp_violation_id":"256414776","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:05.000000Z","updated_at":"2025-03-17T21:39:05.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":7129307,"change_date":"2023-11-15 21:41:00","inspection_id":"80172486","insp_unit_id":"198077659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC41554","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X14R059204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:51.000000Z","updated_at":"2025-03-17T22:59:51.000000Z"},{"id":7129308,"change_date":"2023-11-15 21:41:00","inspection_id":"80172486","insp_unit_id":"198077660","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D538526","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU253F02S790620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:51.000000Z","updated_at":"2025-03-17T22:59:51.000000Z"}]},{"id":4153100,"change_date":"2023-10-09 21:36:00","inspection_id":"79862960","dot_number":"1786901","report_state":"MI","report_number":"CAMEJ01335","insp_date":"2023-10-06 00:00:00","insp_start_time":"1414","insp_end_time":"1427","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"H-33 @ M-28","county_code_state":"MI","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1148778","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:57.000000Z","updated_at":"2025-03-17T19:44:57.000000Z","inspection_violations":[{"id":6427957,"change_date":"2023-10-09 21:36:00","inspection_id":"79862960","insp_violation_id":"255722821","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:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6677953,"change_date":"2023-10-09 21:36:00","inspection_id":"79862960","insp_unit_id":"197456504","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BB09303","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDP4EX53J389280","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"}]},{"id":3522322,"change_date":"2023-07-17 21:41:00","inspection_id":"79159102","dot_number":"1786901","report_state":"MI","report_number":"RODRR02241","insp_date":"2023-07-14 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PORTER ST WB @ BURLINGAME AVE","county_code_state":"MI","county_code":"081","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":"Y","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"38500","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":"1135807","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2023-07-17 21:41:00","snet_input_date":"2023-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[{"id":5431174,"change_date":"2023-07-17 21:41:00","inspection_id":"79159102","insp_violation_id":"254097040","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4252050","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39282A1"},{"id":5431175,"change_date":"2023-07-17 21:41:00","inspection_id":"79159102","insp_violation_id":"254097041","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":"X4252050","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5663515,"change_date":"2023-07-17 21:41:00","inspection_id":"79159102","insp_unit_id":"196031911","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD51982","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD0X4HTXPEC03598","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"},{"id":5663516,"change_date":"2023-07-17 21:41:00","inspection_id":"79159102","insp_unit_id":"196031912","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E577983","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"50HFG3029N1069441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":3479144,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","dot_number":"1786901","report_state":"MI","report_number":"ZYLSJ01348","insp_date":"2023-07-10 00:00:00","insp_start_time":"1633","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"RES LIFE CHURCH 44TH ST","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1134648","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2023-07-11 21:42:00","snet_input_date":"2023-07-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-11 21:42:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:45.000000Z","updated_at":"2025-03-17T19:31:45.000000Z","inspection_violations":[{"id":5363799,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","insp_violation_id":"253987342","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195934565","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5363800,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","insp_violation_id":"253987343","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195934565","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39345D"},{"id":5363801,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","insp_violation_id":"253987344","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4250550","created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"},{"id":5363802,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","insp_violation_id":"253987345","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5594484,"change_date":"2023-07-11 21:42:00","inspection_id":"79110856","insp_unit_id":"195934565","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"4","insp_unit_license":"BC48848","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHA6CV55LU89709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"}]},{"id":1046109,"change_date":"2022-08-16 21:38:00","inspection_id":"76331113","dot_number":"1786901","report_state":"MI","report_number":"PARLM01825","insp_date":"2022-08-15 00:00:00","insp_start_time":"1200","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"68TH ST & BROADMOOR AVE","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"1089468","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01786901","upload_search_indicator":null,"census_search_date":"2022-08-16 21:38:00","snet_input_date":"2022-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-16 21:38:00","insp_carrier_name":"GORDON VANLAAN EXCAVATING LLC","insp_carrier_street":"4570 DIVISION","insp_carrier_city":"MOLINE","insp_carrier_state":"MI","insp_carrier_zip_code":"49335","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1647276,"change_date":"2022-08-16 21:38:00","inspection_id":"76331113","insp_violation_id":"247738682","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4093141","created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1683188,"change_date":"2022-08-16 21:38:00","inspection_id":"76331113","insp_unit_id":"190330770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"9","insp_unit_license":"BA53649","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDGGGG00R113885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"},{"id":1683189,"change_date":"2022-08-16 21:38:00","inspection_id":"76331113","insp_unit_id":"190330771","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"MAC","insp_unit_license":"D534634","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2941HC039599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1786901\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1786901\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1786901\/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\/1786901\/inspections","per_page":100,"prev_page_url":null,"to":14,"total":14}