{"current_page":1,"data":[{"id":12434779,"change_date":"2026-07-13 21:39:00","inspection_id":"88393985","dot_number":"2837540","report_state":"MI","report_number":"SAMOK01974","insp_date":"2026-07-13 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"ED","ci_status_code":"C","location":"131","location_desc":"MI","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"STONECO","shipping_paper_number":"88273154","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":"U","pen_cen_match":"I","final_status_date":"2026-07-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"939220","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":"3741474","transaction_code":"A","transaction_date":"2026-07-13 00:00:00","upload_date":"2026-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":"2026-07-13 21:39:00","snet_input_date":"2026-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-13 21:39:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-16T09:40:33.000000Z","updated_at":"2026-07-24T09:30:57.000000Z","inspection_violations":[{"id":21647382,"change_date":"2026-07-13 21:39:00","inspection_id":"88393985","insp_violation_id":"275468714","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-16T10:00:24.000000Z","updated_at":"2026-07-24T09:44:18.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":21600430,"change_date":"2026-07-13 21:39:00","inspection_id":"88393985","insp_unit_id":"214585582","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC53791","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X3SR160055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:17:08.000000Z","updated_at":"2026-07-24T09:02:23.000000Z"},{"id":21600431,"change_date":"2026-07-13 21:39:00","inspection_id":"88393985","insp_unit_id":"214585583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E493560","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3157NC060818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:17:08.000000Z","updated_at":"2026-07-24T09:02:23.000000Z"},{"id":21600432,"change_date":"2026-07-13 21:39:00","inspection_id":"88393985","insp_unit_id":"214585584","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E493561","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2036NC060819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-16T09:17:08.000000Z","updated_at":"2026-07-24T09:02:23.000000Z"}]},{"id":12150949,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","dot_number":"2837540","report_state":"MI","report_number":"GENTC03346","insp_date":"2026-06-10 00:00:00","insp_start_time":"1155","insp_end_time":"1248","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-10 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3512672","transaction_code":"A","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":"2026-06-10 21:45:00","snet_input_date":"2026-06-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-10 21:45:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-13T09:41:32.000000Z","updated_at":"2026-06-21T09:31:32.000000Z","inspection_violations":[{"id":21147632,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_violation_id":"274820940","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"214019686","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:46.000000Z","updated_at":"2026-06-21T09:45:57.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":21147633,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_violation_id":"274820941","seq_no":"2","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"3","insp_unit_id":"214019687","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:46.000000Z","updated_at":"2026-06-21T09:45:57.000000Z","normalized_code":"39348ABIBD"},{"id":21147634,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_violation_id":"274820942","seq_no":"3","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"3","insp_unit_id":"214019687","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-13T10:02:46.000000Z","updated_at":"2026-06-21T09:45:57.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":21107925,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_unit_id":"214019685","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"208","insp_unit_license":"RC52799","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X47J199352","insp_unit_decal":"Y","insp_unit_decal_number":"36059245","created_at":"2026-06-13T09:18:00.000000Z","updated_at":"2026-06-21T09:02:45.000000Z"},{"id":21107926,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_unit_id":"214019686","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"72A","insp_unit_license":"E516060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWM684207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:00.000000Z","updated_at":"2026-06-21T09:02:45.000000Z"},{"id":21107927,"change_date":"2026-06-10 21:45:00","inspection_id":"88100119","insp_unit_id":"214019687","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"72B","insp_unit_license":"D506631","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02267EF044529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-13T09:18:00.000000Z","updated_at":"2026-06-21T09:02:45.000000Z"}]},{"id":12133241,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","dot_number":"2837540","report_state":"MI","report_number":"MALOK00692","insp_date":"2026-06-08 00:00:00","insp_start_time":"2300","insp_end_time":"2319","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CLIFF","shipping_paper_number":"130655","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":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"182000","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":"3496940","transaction_code":"A","transaction_date":"2026-06-09 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":"2026-06-09 21:41:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:41:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:56.000000Z","updated_at":"2026-06-20T09:32:13.000000Z","inspection_violations":[{"id":21118551,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","insp_violation_id":"274779861","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4710209","created_at":"2026-06-12T09:58:56.000000Z","updated_at":"2026-06-19T09:46:27.000000Z","normalized_code":"3922SLLEWA1"},{"id":21118552,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","insp_violation_id":"274779862","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":"X4710209","created_at":"2026-06-12T09:58:56.000000Z","updated_at":"2026-06-19T09:46:27.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":21080003,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","insp_unit_id":"213982428","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC63427","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X2JR992985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:42.000000Z","updated_at":"2026-06-20T09:03:57.000000Z"},{"id":21080004,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","insp_unit_id":"213982429","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E925470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N489ARD44910","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:42.000000Z","updated_at":"2026-06-20T09:03:57.000000Z"},{"id":21080005,"change_date":"2026-06-09 21:41:00","inspection_id":"88079428","insp_unit_id":"213982430","insp_unit_type_id":"7","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E925471","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N287ARD44911","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:42.000000Z","updated_at":"2026-06-20T09:03:57.000000Z"}]},{"id":11995815,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","dot_number":"2837540","report_state":"MI","report_number":"DAWDD04548","insp_date":"2026-05-22 00:00:00","insp_start_time":"1341","insp_end_time":"1359","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DETROIT BULK STORAGE","shipping_paper_number":"52961","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"152000","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":"3386495","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:15.000000Z","updated_at":"2026-06-02T09:32:25.000000Z","inspection_violations":[{"id":20869861,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","insp_violation_id":"274447779","seq_no":"2","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:48.000000Z","updated_at":"2026-06-02T09:44:27.000000Z","normalized_code":"3922SLLS1"},{"id":20869860,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","insp_violation_id":"274447778","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:02:48.000000Z","updated_at":"2026-06-02T09:44:27.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20853565,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","insp_unit_id":"213708715","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"225","insp_unit_license":"RC53791","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKWD40X3SR160055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:22.000000Z","updated_at":"2026-06-02T09:05:37.000000Z"},{"id":20853566,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","insp_unit_id":"213708716","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"NONE","insp_unit_license":"F179557","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3158LC051929","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:22.000000Z","updated_at":"2026-06-02T09:05:37.000000Z"},{"id":20853567,"change_date":"2026-05-22 21:38:00","inspection_id":"87934004","insp_unit_id":"213708717","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"NONE","insp_unit_license":"F179556","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2022LC051930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:22.000000Z","updated_at":"2026-06-02T09:05:37.000000Z"}]},{"id":9633675,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","dot_number":"2837540","report_state":"MI","report_number":"DELMT02167","insp_date":"2025-09-04 00:00:00","insp_start_time":"1930","insp_end_time":"2000","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"KERKSTRA PRECAST","shipping_paper_number":"88249278","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-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240148","transaction_code":"A","transaction_date":"2025-09-04 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:07.000000Z","inspection_violations":[{"id":15761643,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_violation_id":"268555321","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:40.000000Z","normalized_code":"3922SLLEWA1"},{"id":15761644,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_violation_id":"268555322","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":"X4591418","created_at":"2025-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:40.000000Z","normalized_code":"3922SLLEWA2"},{"id":15761645,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_violation_id":"268555323","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208831170","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:40.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":15915695,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_unit_id":"208831170","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:53.000000Z"},{"id":15915696,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_unit_id":"208831171","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"E516060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWM684207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:53.000000Z"},{"id":15915697,"change_date":"2025-09-09 21:41:00","inspection_id":"85724853","insp_unit_id":"208831172","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"D506631","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4D02267EF044529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:53.000000Z"}]},{"id":8607121,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","dot_number":"2837540","report_state":"MI","report_number":"DELMT01924","insp_date":"2025-05-08 00:00:00","insp_start_time":"1200","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MOSCOW MDOT PIT","shipping_paper_number":"88234610","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-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"12","oos_total":"7","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"7","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220687","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:14.000000Z","updated_at":"2025-05-17T10:05:48.000000Z","inspection_violations":[{"id":13676355,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165008","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"206809874","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676356,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165009","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BAIR"},{"id":13676357,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165010","seq_no":"5","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676358,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165011","seq_no":"6","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676359,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165012","seq_no":"7","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676360,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165013","seq_no":"8","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676361,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165014","seq_no":"9","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"206809875","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345DB"},{"id":13676362,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165015","seq_no":"10","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"3","insp_unit_id":"206809876","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BAIR"},{"id":13676363,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165016","seq_no":"11","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"3","insp_unit_id":"206809876","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676364,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165017","seq_no":"12","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"3","insp_unit_id":"206809876","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4524339","created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"39345B2BHTD"},{"id":13676365,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165018","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":"X4524339","created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"3922SLLEWA2"},{"id":13676366,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_violation_id":"266165019","seq_no":"2","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"206809874","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:21:03.000000Z","updated_at":"2025-05-16T10:27:29.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":14050812,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_unit_id":"206809874","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC16655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X2HD413793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:18.000000Z","updated_at":"2025-05-16T09:51:08.000000Z"},{"id":14050814,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_unit_id":"206809876","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F179556","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2022LC051930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:18.000000Z","updated_at":"2025-05-16T09:51:09.000000Z"},{"id":14050813,"change_date":"2025-05-12 21:40:00","inspection_id":"84643078","insp_unit_id":"206809875","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"F179557","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3158LC051929","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:18.000000Z","updated_at":"2025-05-16T09:51:08.000000Z"}]},{"id":8168617,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","dot_number":"2837540","report_state":"MI","report_number":"JURKV02942","insp_date":"2025-03-19 00:00:00","insp_start_time":"0710","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SPEEDWAY","county_code_state":"MI","county_code":"145","insp_level_id":"1","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-03-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"59000","viol_total":"10","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1214039","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-20 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-23T10:52:26.000000Z","updated_at":"2025-03-24T10:26:11.000000Z","inspection_violations":[{"id":12797297,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161648","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"3922SLLLR"},{"id":12797298,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161649","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205908790","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797299,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161650","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205908790","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797300,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161651","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205908790","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797301,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161652","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"205908790","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797302,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161653","seq_no":"6","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"205908790","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4491668","created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"3963A1BOS"},{"id":12797303,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161654","seq_no":"7","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"205908791","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39348ABIAD"},{"id":12797304,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161655","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"3","insp_unit_id":"205908792","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797305,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161656","seq_no":"9","part_no":"393","part_no_section":"47E","insp_viol_unit":"3","insp_unit_id":"205908792","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347E"},{"id":12797306,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_violation_id":"265161657","seq_no":"10","part_no":"393","part_no_section":"47D2-BLTBD","insp_viol_unit":"3","insp_unit_id":"205908792","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T11:08:50.000000Z","updated_at":"2025-03-23T11:41:24.000000Z","normalized_code":"39347D2BLTBD"}],"inspection_per_units":[{"id":13202306,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_unit_id":"205908790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:16:28.000000Z","updated_at":"2025-03-24T10:05:18.000000Z"},{"id":13202307,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_unit_id":"205908791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"5050","insp_unit_license":"E835577","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1K38XRRF15050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:16:28.000000Z","updated_at":"2025-03-24T10:05:18.000000Z"},{"id":13202308,"change_date":"2025-03-20 21:42:00","inspection_id":"84181204","insp_unit_id":"205908792","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"15051","insp_unit_license":"E835576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H580RRF15051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-23T10:16:28.000000Z","updated_at":"2025-03-24T10:05:18.000000Z"}]},{"id":8097218,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","dot_number":"2837540","report_state":"MI","report_number":"BARTT04808","insp_date":"2025-03-11 00:00:00","insp_start_time":"0900","insp_end_time":"0929","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/BI75@CARPENTER","county_code_state":"MI","county_code":"049","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-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212910","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-17T21:06:19.000000Z","inspection_violations":[{"id":12658098,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_violation_id":"264979457","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:57.000000Z","updated_at":"2025-03-17T22:07:57.000000Z","normalized_code":"3922SLLS2"},{"id":12658099,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_violation_id":"264979458","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:57.000000Z","updated_at":"2025-03-17T22:07:57.000000Z","normalized_code":"39141AMCPC"},{"id":12658100,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_violation_id":"264979459","seq_no":"3","part_no":"383","part_no_section":"51A-LCDLRSWD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4493329","created_at":"2025-03-17T22:07:57.000000Z","updated_at":"2025-03-17T22:07:57.000000Z","normalized_code":"38351ALCDLRSWD"}],"inspection_per_units":[{"id":13073499,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_unit_id":"205761521","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"},{"id":13073500,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_unit_id":"205761522","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NONE","insp_unit_license":"C434376","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1K38XRRF15050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"},{"id":13073501,"change_date":"2025-03-12 21:40:00","inspection_id":"84106058","insp_unit_id":"205761523","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"NONE","insp_unit_license":"E835576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W1H580RRF15051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:31.000000Z","updated_at":"2025-03-17T23:59:31.000000Z"}]},{"id":6539189,"change_date":"2024-09-17 21:45:00","inspection_id":"82460325","dot_number":"2837540","report_state":"MI","report_number":"BESSJ00770","insp_date":"2024-08-20 00:00:00","insp_start_time":"0605","insp_end_time":"0630","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ ZEEB RD","county_code_state":"MI","county_code":"161","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":"2024-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1191159","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":10158388,"change_date":"2024-09-17 21:45:00","inspection_id":"82460325","insp_violation_id":"261858419","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:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10541626,"change_date":"2024-09-17 21:45:00","inspection_id":"82460325","insp_unit_id":"202974737","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"},{"id":10541627,"change_date":"2024-09-17 21:45:00","inspection_id":"82460325","insp_unit_id":"202974738","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"N\/A","insp_unit_license":"E431218","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3152NC057339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"},{"id":10541628,"change_date":"2024-09-17 21:45:00","inspection_id":"82460325","insp_unit_id":"202974739","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"N\/A","insp_unit_license":"E431219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2138NC057340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6490358,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","dot_number":"2837540","report_state":"MI","report_number":"PRESR02514","insp_date":"2024-08-15 00:00:00","insp_start_time":"1310","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"US-23 WELCOME CENTER","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"1190146","transaction_code":"C","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:35.000000Z","updated_at":"2025-03-17T20:31:35.000000Z","inspection_violations":[{"id":10077419,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","insp_violation_id":"261871549","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:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3922"},{"id":10077420,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","insp_violation_id":"261871550","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202985296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10462146,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","insp_unit_id":"202985296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"208","insp_unit_license":"RC02876","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EJ8EN172004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"},{"id":10462147,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","insp_unit_id":"202985297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"D45","insp_unit_license":"E925470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N489ARD44910","insp_unit_decal":"Y","insp_unit_decal_number":"00000001","created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"},{"id":10462148,"change_date":"2024-09-17 21:45:00","inspection_id":"82408489","insp_unit_id":"202985298","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"D46","insp_unit_license":"E925471","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N287ARD44911","insp_unit_decal":"Y","insp_unit_decal_number":"00000002","created_at":"2025-03-17T23:31:24.000000Z","updated_at":"2025-03-17T23:31:24.000000Z"}]},{"id":4494413,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","dot_number":"2837540","report_state":"MI","report_number":"KOCHJ01390","insp_date":"2023-11-22 00:00:00","insp_start_time":"1345","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-25 @ BRADLEYVILLE RD","county_code_state":"MI","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1154629","transaction_code":"A","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-27 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:50.000000Z","updated_at":"2025-03-17T19:51:50.000000Z","inspection_violations":[{"id":6954106,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_violation_id":"256563195","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:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6954107,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_violation_id":"256563196","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198214898","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4300970","created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39360C"},{"id":6954108,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_violation_id":"256563197","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198214898","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4300970","created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"},{"id":6954109,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_violation_id":"256563198","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198214898","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7228258,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_unit_id":"198214898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:43.000000Z","updated_at":"2025-03-17T23:00:43.000000Z"},{"id":7228259,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_unit_id":"198214899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"5","insp_unit_license":"E431218","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3152NC057339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:43.000000Z","updated_at":"2025-03-17T23:00:43.000000Z"},{"id":7228260,"change_date":"2023-11-27 21:42:00","inspection_id":"80239836","insp_unit_id":"198214900","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":"3","insp_unit_license":"E431219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2138NC057340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:43.000000Z","updated_at":"2025-03-17T23:00:43.000000Z"}]},{"id":4302547,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","dot_number":"2837540","report_state":"MI","report_number":"WILLD02999","insp_date":"2023-10-26 00:00:00","insp_start_time":"1335","insp_end_time":"1405","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 N\/B & SPRINGWELL","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1151167","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:19.000000Z","updated_at":"2025-03-17T19:48:19.000000Z","inspection_violations":[{"id":6655917,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_violation_id":"256090681","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:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3922"},{"id":6655918,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_violation_id":"256090682","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":"X4268707","created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3922"},{"id":6655919,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_violation_id":"256090683","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197787994","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6919675,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_unit_id":"197787994","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWO","insp_unit_company":null,"insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6919676,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_unit_id":"197787995","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"E431218","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3152NC057339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6919677,"change_date":"2023-10-27 21:43:00","inspection_id":"80028115","insp_unit_id":"197787996","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"E431219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2138NC057340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"}]},{"id":3755969,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","dot_number":"2837540","report_state":"MI","report_number":"DELMT00706","insp_date":"2023-08-15 00:00:00","insp_start_time":"1525","insp_end_time":"1615","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":"SULTAN CEMENT","shipping_paper_number":"6839012","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1140465","transaction_code":"C","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:56.000000Z","updated_at":"2025-03-17T19:36:56.000000Z","inspection_violations":[{"id":5791846,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_violation_id":"254983011","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196812867","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39360C"},{"id":5791847,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_violation_id":"254983012","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196812867","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39345B2"},{"id":5791848,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_violation_id":"254983013","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"196812869","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3922"},{"id":5791849,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_violation_id":"254983014","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196812868","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6039373,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_unit_id":"196812867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RC22021","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:45.000000Z","updated_at":"2025-03-17T22:50:45.000000Z"},{"id":6039374,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_unit_id":"196812868","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"5","insp_unit_license":"E431218","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3152NC057339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:45.000000Z","updated_at":"2025-03-17T22:50:45.000000Z"},{"id":6039375,"change_date":"2023-08-30 21:44:00","inspection_id":"79420642","insp_unit_id":"196812869","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":"3","insp_unit_license":"E431219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2138NC057340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:45.000000Z","updated_at":"2025-03-17T22:50:45.000000Z"}]},{"id":3674440,"change_date":"2023-08-29 21:42:00","inspection_id":"79330058","dot_number":"2837540","report_state":"MI","report_number":"BOHNE01486","insp_date":"2023-08-03 00:00:00","insp_start_time":"1414","insp_end_time":"1443","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB M54 @ HILL RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREAT LAKES BOAT HAULERS","shipping_paper_number":"2372","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1138381","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[{"id":5663758,"change_date":"2023-08-29 21:42:00","inspection_id":"79330058","insp_violation_id":"254954556","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196789576","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:16.000000Z","updated_at":"2025-03-17T21:33:16.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5907632,"change_date":"2023-08-29 21:42:00","inspection_id":"79330058","insp_unit_id":"196789576","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"NONE","insp_unit_license":"RC13704","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C63RRJL9LG296627","insp_unit_decal":"Y","insp_unit_decal_number":"33028761","created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"},{"id":5907633,"change_date":"2023-08-29 21:42:00","inspection_id":"79330058","insp_unit_id":"196789577","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TORI","insp_unit_company":"NONE","insp_unit_license":"E810972","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"121BA4031HM017752","insp_unit_decal":"Y","insp_unit_decal_number":"33028762","created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3142011,"change_date":"2023-05-25 21:42:00","inspection_id":"78730722","dot_number":"2837540","report_state":"MI","report_number":"CHAPP03845","insp_date":"2023-05-24 00:00:00","insp_start_time":"1824","insp_end_time":"1905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LASALLE TWP","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DTE","shipping_paper_number":"80914","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"214000","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":"1127674","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:19.000000Z","updated_at":"2025-03-17T19:25:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5053546,"change_date":"2023-05-25 21:42:00","inspection_id":"78730722","insp_unit_id":"195144979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC16655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD49X2HD413793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"},{"id":5053547,"change_date":"2023-05-25 21:42:00","inspection_id":"78730722","insp_unit_id":"195144980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"E807231","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3155KC044774","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"},{"id":5053548,"change_date":"2023-05-25 21:42:00","inspection_id":"78730722","insp_unit_id":"195144981","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"E807232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2025KC044775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:50.000000Z","updated_at":"2025-03-17T22:42:50.000000Z"}]},{"id":3043665,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","dot_number":"2837540","report_state":"MI","report_number":"STRAL02029","insp_date":"2023-05-12 00:00:00","insp_start_time":"1200","insp_end_time":"1242","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GRAND ISLE MARINA","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1125993","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[{"id":4675126,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_violation_id":"252828479","seq_no":"1","part_no":"383","part_no_section":"71(h)","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:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"38371H"},{"id":4675127,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_violation_id":"252828480","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194928355","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39021TB"},{"id":4675128,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_violation_id":"252828481","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194928355","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39617C"},{"id":4675129,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_violation_id":"252828482","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"194928356","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:46.000000Z","updated_at":"2025-03-17T21:28:46.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4896396,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_unit_id":"194928355","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"RC13704","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C63RRJL9LG296627","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:36.000000Z","updated_at":"2025-03-17T22:41:36.000000Z"},{"id":4896397,"change_date":"2023-05-15 21:42:00","inspection_id":"78620027","insp_unit_id":"194928356","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TORI","insp_unit_company":null,"insp_unit_license":"E810972","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"121BA4031HM017752","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:36.000000Z","updated_at":"2025-03-17T22:41:36.000000Z"}]},{"id":2577886,"change_date":"2023-03-14 21:42:00","inspection_id":"78091570","dot_number":"2837540","report_state":"MI","report_number":"PEASS02556","insp_date":"2023-03-13 00:00:00","insp_start_time":"0900","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"930 N WAGNER RD","county_code_state":"MI","county_code":"017","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":"2023-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"59220","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":"1117378","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-14 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:07.000000Z","updated_at":"2025-03-17T19:14:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4149147,"change_date":"2023-03-14 21:42:00","inspection_id":"78091570","insp_unit_id":"193872256","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"208","insp_unit_license":"RC02876","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X47J199352","insp_unit_decal":"Y","insp_unit_decal_number":"32323436","created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"}]},{"id":1861387,"change_date":"2022-12-02 21:41:00","inspection_id":"77273526","dot_number":"2837540","report_state":"MI","report_number":"NESBA00047","insp_date":"2022-12-01 00:00:00","insp_start_time":"1750","insp_end_time":"1815","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1104146","transaction_code":"A","transaction_date":"2022-12-01 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2899747,"change_date":"2022-12-02 21:41:00","inspection_id":"77273526","insp_violation_id":"249893219","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192235617","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2995516,"change_date":"2022-12-02 21:41:00","inspection_id":"77273526","insp_unit_id":"192235617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"208","insp_unit_license":"RC02876","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X47J199352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"},{"id":2995517,"change_date":"2022-12-02 21:41:00","inspection_id":"77273526","insp_unit_id":"192235618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"483190","insp_unit_license":"E382902","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS24856G856908","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"}]},{"id":997149,"change_date":"2022-08-09 21:41:00","inspection_id":"76274178","dot_number":"2837540","report_state":"MI","report_number":"MCGEJ02525","insp_date":"2022-08-08 00:00:00","insp_start_time":"1335","insp_end_time":"1354","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ MM 222","county_code_state":"MI","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"59200","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":"1088113","transaction_code":"A","transaction_date":"2022-08-08 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-09 21:41:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:08.000000Z","updated_at":"2025-03-17T18:45:08.000000Z","inspection_violations":[{"id":1571135,"change_date":"2022-08-09 21:41:00","inspection_id":"76274178","insp_violation_id":"247603362","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":"WARNING","created_at":"2025-03-17T21:14:23.000000Z","updated_at":"2025-03-17T21:14:23.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1604619,"change_date":"2022-08-09 21:41:00","inspection_id":"76274178","insp_unit_id":"190213291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"112","insp_unit_license":"BC60853","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDP0X9CJ336082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:06.000000Z","updated_at":"2025-03-17T22:18:06.000000Z"},{"id":1604620,"change_date":"2022-08-09 21:41:00","inspection_id":"76274178","insp_unit_id":"190213292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"C269212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2434XC002413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:06.000000Z","updated_at":"2025-03-17T22:18:06.000000Z"},{"id":1604621,"change_date":"2022-08-09 21:41:00","inspection_id":"76274178","insp_unit_id":"190213293","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":null,"insp_unit_license":"D590929","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADS2057XC002414","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:06.000000Z","updated_at":"2025-03-17T22:18:06.000000Z"}]},{"id":957119,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","dot_number":"2837540","report_state":"MI","report_number":"MCGEJ02508","insp_date":"2022-08-01 00:00:00","insp_start_time":"1540","insp_end_time":"1613","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 SB @ 4 MILE RD","county_code_state":"MI","county_code":"039","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ST MARY'S CEMENT","shipping_paper_number":"8089281228","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-08-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"59200","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":"1086983","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02837540","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-03 21:42:00","insp_carrier_name":"MACFARLANE TRANSPORT LLC","insp_carrier_street":"930 N WAGNER RD","insp_carrier_city":"ESSEXVILLE","insp_carrier_state":"MI","insp_carrier_zip_code":"48732","insp_colonia":null,"docket_number":"949682","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:27.000000Z","updated_at":"2025-03-17T18:44:27.000000Z","inspection_violations":[{"id":1508135,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","insp_violation_id":"247492754","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4093375","created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"39141A"},{"id":1508136,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","insp_violation_id":"247492755","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190117556","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:14:08.000000Z","updated_at":"2025-03-17T21:14:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1540130,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","insp_unit_id":"190117556","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"211","insp_unit_license":"RB94745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X5BJ948969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"},{"id":1540131,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","insp_unit_id":"190117557","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E431218","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA3152NC057339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"},{"id":1540132,"change_date":"2022-08-03 21:42:00","inspection_id":"76227595","insp_unit_id":"190117558","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"E431219","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MADA2138NC057340","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:42.000000Z","updated_at":"2025-03-17T22:17:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2837540\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2837540\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2837540\/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\/2837540\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}