{"current_page":1,"data":[{"id":11782110,"change_date":"2026-04-29 21:40:00","inspection_id":"87713458","dot_number":"1294873","report_state":"MI","report_number":"FROSR00932","insp_date":"2026-04-28 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DIENER RD @ TITTABAWASSEE RD","county_code_state":"MI","county_code":"145","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1267872","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2026-04-29 21:40:00","snet_input_date":"2026-04-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-29 21:40:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2026-05-02T09:41:05.000000Z","updated_at":"2026-05-10T09:31:05.000000Z","inspection_violations":[{"id":20487945,"change_date":"2026-04-29 21:40:00","inspection_id":"87713458","insp_violation_id":"273936630","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4661419","created_at":"2026-05-02T10:02:48.000000Z","updated_at":"2026-05-10T09:41:41.000000Z","normalized_code":"39141APC"},{"id":20487946,"change_date":"2026-04-29 21:40:00","inspection_id":"87713458","insp_violation_id":"273936631","seq_no":"2","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-02T10:02:48.000000Z","updated_at":"2026-05-10T09:41:41.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":20496590,"change_date":"2026-04-29 21:40:00","inspection_id":"87713458","insp_unit_id":"213292583","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"BC98360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPEX2KJ254984","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:21.000000Z","updated_at":"2026-05-10T09:03:46.000000Z"}]},{"id":9633552,"change_date":"2025-09-09 21:41:00","inspection_id":"85724721","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ02135","insp_date":"2025-09-08 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-15 @ M-46","county_code_state":"MI","county_code":"157","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"149400","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":"1239586","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:06.000000Z","inspection_violations":[{"id":15761404,"change_date":"2025-09-09 21:41:00","inspection_id":"85724721","insp_violation_id":"268555045","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-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:38.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15915471,"change_date":"2025-09-09 21:41:00","inspection_id":"85724721","insp_unit_id":"208830923","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BC84084","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPTD40X6ED224751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:52.000000Z"},{"id":15915472,"change_date":"2025-09-09 21:41:00","inspection_id":"85724721","insp_unit_id":"208830924","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GINCO","insp_unit_company":null,"insp_unit_license":"E516191","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2G9LS5894NB105143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:52.000000Z"}]},{"id":9439699,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ02101","insp_date":"2025-08-14 00:00:00","insp_start_time":"1005","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ CLIO REST AREASB I-7","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"DEPCINSKI","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":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"220600","viol_total":"23","oos_total":"9","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"22","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1236702","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:58.000000Z","updated_at":"2025-08-23T10:45:58.000000Z","inspection_violations":[{"id":15366118,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092041","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4582616","created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3922SLLEWA3"},{"id":15366119,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092042","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"208451118","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4582616","created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3963A1BOS"},{"id":15366120,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092043","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208451118","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965BL"},{"id":15366121,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092044","seq_no":"4","part_no":"393","part_no_section":"43A-TPV","insp_viol_unit":"1","insp_unit_id":"208451118","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343ATPV"},{"id":15366122,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092045","seq_no":"5","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965HL"},{"id":15366123,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092046","seq_no":"6","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965HL"},{"id":15366124,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092047","seq_no":"7","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965HL"},{"id":15366125,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092048","seq_no":"8","part_no":"396","part_no_section":"3A1-BNMH","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3963A1BNMH"},{"id":15366126,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092049","seq_no":"9","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366127,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092050","seq_no":"10","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965HL"},{"id":15366128,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092051","seq_no":"11","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3965HL"},{"id":15366129,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092052","seq_no":"12","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39375GTAOW"},{"id":15366130,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092053","seq_no":"13","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3939ALIL"},{"id":15366131,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092054","seq_no":"14","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366132,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092055","seq_no":"15","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366133,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092056","seq_no":"16","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366134,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092057","seq_no":"17","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"2","insp_unit_id":"208451119","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39345DBAAL"},{"id":15366135,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092058","seq_no":"18","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366136,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092059","seq_no":"19","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366137,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092060","seq_no":"20","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366138,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092061","seq_no":"21","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366139,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092062","seq_no":"22","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"},{"id":15366140,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_violation_id":"268092063","seq_no":"23","part_no":"393","part_no_section":"43D-BIPBS","insp_viol_unit":"3","insp_unit_id":"208451120","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39343DBIPBS"}],"inspection_per_units":[{"id":15563707,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_unit_id":"208451118","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2022","insp_unit_license":"BC84075","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9NJ496521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:43.000000Z","updated_at":"2025-08-22T09:46:03.000000Z"},{"id":15563708,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_unit_id":"208451119","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":"2025-08-21T09:45:43.000000Z","updated_at":"2025-08-22T09:46:03.000000Z"},{"id":15563709,"change_date":"2025-08-18 21:39:00","inspection_id":"85521377","insp_unit_id":"208451120","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":"2025-08-21T09:45:43.000000Z","updated_at":"2025-08-22T09:46:03.000000Z"}]},{"id":8910881,"change_date":"2025-06-16 21:39:00","inspection_id":"84964460","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ02014","insp_date":"2025-06-13 00:00:00","insp_start_time":"1420","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-25 @ M-24","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225643","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:24.000000Z","updated_at":"2025-06-20T10:00:30.000000Z","inspection_violations":[{"id":14288728,"change_date":"2025-06-16 21:39:00","inspection_id":"84964460","insp_violation_id":"266867598","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":"X4546868","created_at":"2025-06-19T10:15:34.000000Z","updated_at":"2025-06-20T10:15:52.000000Z","normalized_code":"3922SLLEWA1"},{"id":14288729,"change_date":"2025-06-16 21:39:00","inspection_id":"84964460","insp_violation_id":"266867599","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"207408573","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-19T10:15:34.000000Z","updated_at":"2025-06-20T10:15:52.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":14599995,"change_date":"2025-06-16 21:39:00","inspection_id":"84964460","insp_unit_id":"207408572","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE16331","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYFXYB2YLF73469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:39.000000Z"},{"id":14599996,"change_date":"2025-06-16 21:39:00","inspection_id":"84964460","insp_unit_id":"207408573","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":null,"insp_unit_license":"F264237","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS644701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:39.000000Z"}]},{"id":8725316,"change_date":"2025-05-23 21:39:00","inspection_id":"84767655","dot_number":"1294873","report_state":"MI","report_number":"MCGEJ03526","insp_date":"2025-05-22 00:00:00","insp_start_time":"0910","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"930 N WAGNER RD @ W CENTER RD","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"159200","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":"1222629","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14264050,"change_date":"2025-05-23 21:39:00","inspection_id":"84767655","insp_unit_id":"207042829","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"807","insp_unit_license":"E289544","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2G9LS5890MB105073","insp_unit_decal":"Y","insp_unit_decal_number":"35168923","created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"},{"id":14264049,"change_date":"2025-05-23 21:39:00","inspection_id":"84767655","insp_unit_id":"207042828","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"BD24433","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X4FD288659","insp_unit_decal":"Y","insp_unit_decal_number":"35168922","created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"}]},{"id":8725317,"change_date":"2025-05-23 21:39:00","inspection_id":"84767656","dot_number":"1294873","report_state":"MI","report_number":"MCGEJ03527","insp_date":"2025-05-22 00:00:00","insp_start_time":"1005","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"930 N WAGNER RD @ W CENTER RD","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"78350","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":"1222676","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[{"id":13920378,"change_date":"2025-05-23 21:39:00","inspection_id":"84767656","insp_violation_id":"266447554","seq_no":"1","part_no":"393","part_no_section":"11A1-LBL","insp_viol_unit":"1","insp_unit_id":"207042830","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:03.000000Z","updated_at":"2025-05-27T10:26:09.000000Z","normalized_code":"39311A1LBL"}],"inspection_per_units":[{"id":14264051,"change_date":"2025-05-23 21:39:00","inspection_id":"84767656","insp_unit_id":"207042830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"191","insp_unit_license":"BC98360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPEX2KJ254984","insp_unit_decal":"Y","insp_unit_decal_number":"35168924","created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"}]},{"id":8725524,"change_date":"2025-05-23 21:39:00","inspection_id":"84767878","dot_number":"1294873","report_state":"MI","report_number":"MCGEJ03524","insp_date":"2025-05-22 00:00:00","insp_start_time":"0800","insp_end_time":"0835","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N WAGNER RD @ W CENTER RD","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60600","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":"1222806","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:29.000000Z","updated_at":"2025-05-27T10:03:45.000000Z","inspection_violations":[{"id":13920754,"change_date":"2025-05-23 21:39:00","inspection_id":"84767878","insp_violation_id":"266448042","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"207043251","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:08.000000Z","updated_at":"2025-05-27T10:26:23.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":14264413,"change_date":"2025-05-23 21:39:00","inspection_id":"84767878","insp_unit_id":"207043251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2022","insp_unit_license":"BC84075","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKZD40X9NJ496521","insp_unit_decal":"Y","insp_unit_decal_number":"35168920","created_at":"2025-05-26T09:50:04.000000Z","updated_at":"2025-05-27T09:51:28.000000Z"}]},{"id":8725315,"change_date":"2025-05-23 21:39:00","inspection_id":"84767654","dot_number":"1294873","report_state":"MI","report_number":"MCGEJ03525","insp_date":"2025-05-22 00:00:00","insp_start_time":"0835","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"930 N WAGNER RD @ W CENTER RD","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60600","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222626","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:28.000000Z","updated_at":"2025-05-27T10:03:43.000000Z","inspection_violations":[{"id":13920376,"change_date":"2025-05-23 21:39:00","inspection_id":"84767654","insp_violation_id":"266447552","seq_no":"1","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"207042827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:03.000000Z","updated_at":"2025-05-27T10:26:09.000000Z","normalized_code":"3939ALBL"},{"id":13920377,"change_date":"2025-05-23 21:39:00","inspection_id":"84767654","insp_violation_id":"266447553","seq_no":"2","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"207042827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:29:03.000000Z","updated_at":"2025-05-27T10:26:09.000000Z","normalized_code":"39311A1CSLRR"}],"inspection_per_units":[{"id":14264048,"change_date":"2025-05-23 21:39:00","inspection_id":"84767654","insp_unit_id":"207042827","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"113","insp_unit_license":"BD63570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40XXDJ349939","insp_unit_decal":"Y","insp_unit_decal_number":"35168921","created_at":"2025-05-26T09:50:03.000000Z","updated_at":"2025-05-27T09:51:24.000000Z"}]},{"id":8661030,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","dot_number":"1294873","report_state":"MI","report_number":"HADZM04717","insp_date":"2025-05-15 00:00:00","insp_start_time":"2030","insp_end_time":"2105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ W GRAND","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"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":"2025-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"200000","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":"1221746","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2025-05-16 21:43:00","snet_input_date":"2025-05-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:27.000000Z","updated_at":"2025-05-20T10:06:24.000000Z","inspection_violations":[{"id":13783154,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_violation_id":"266283561","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4522250","created_at":"2025-05-19T10:37:13.000000Z","updated_at":"2025-05-20T10:28:08.000000Z","normalized_code":"3922SLLSWZ"},{"id":13783155,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_violation_id":"266283562","seq_no":"2","part_no":"392","part_no_section":"2-SLLML","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4522250","created_at":"2025-05-19T10:37:13.000000Z","updated_at":"2025-05-20T10:28:08.000000Z","normalized_code":"3922SLLML"},{"id":13783156,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_violation_id":"266283563","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206913019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4522250","created_at":"2025-05-19T10:37:13.000000Z","updated_at":"2025-05-20T10:28:08.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":14146939,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_unit_id":"206913019","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"113","insp_unit_license":"BD63570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40XXDJ349939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:35.000000Z","updated_at":"2025-05-20T09:51:52.000000Z"},{"id":14146940,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_unit_id":"206913020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"NA","insp_unit_license":"E460598","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2L48XNR078183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:35.000000Z","updated_at":"2025-05-20T09:51:52.000000Z"},{"id":14146941,"change_date":"2025-05-16 21:43:00","inspection_id":"84699666","insp_unit_id":"206913021","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"NA","insp_unit_license":"E460599","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2L48XNR078183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-19T09:50:35.000000Z","updated_at":"2025-05-20T09:51:53.000000Z"}]},{"id":6645031,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","dot_number":"1294873","report_state":"MI","report_number":"ELDEH00636","insp_date":"2024-09-04 00:00:00","insp_start_time":"0500","insp_end_time":"0600","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB @ US-10","county_code_state":"MI","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","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":"1193492","transaction_code":"C","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2024-09-04 21:42:00","snet_input_date":"2024-09-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-04 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:49.000000Z","updated_at":"2025-03-17T20:34:49.000000Z","inspection_violations":[{"id":10338235,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","insp_violation_id":"261861499","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:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3922"},{"id":10338236,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","insp_violation_id":"261861500","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4427452","created_at":"2025-03-17T21:56:03.000000Z","updated_at":"2025-03-17T21:56:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10713416,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","insp_unit_id":"202977402","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"122","insp_unit_license":"BB28092","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYFXYB2YLF73469","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"},{"id":10713417,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","insp_unit_id":"202977403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"550","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-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"},{"id":10713418,"change_date":"2024-09-17 21:45:00","inspection_id":"82573189","insp_unit_id":"202977404","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"551","insp_unit_license":"E835576","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D1K38XRRF15051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:56.000000Z","updated_at":"2025-03-17T23:33:56.000000Z"}]},{"id":6539111,"change_date":"2024-09-17 21:45:00","inspection_id":"82460242","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ01673","insp_date":"2024-08-20 00:00:00","insp_start_time":"1130","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-24 @ M-46","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":"32768828","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-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1191121","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":"01294873","upload_search_indicator":null,"census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[{"id":10158200,"change_date":"2024-09-17 21:45:00","inspection_id":"82460242","insp_violation_id":"261866446","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:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3922"},{"id":10158201,"change_date":"2024-09-17 21:45:00","inspection_id":"82460242","insp_violation_id":"261866447","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202980974","insp_violation_category_id":"20","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":"3939A"}],"inspection_per_units":[{"id":10541491,"change_date":"2024-09-17 21:45:00","inspection_id":"82460242","insp_unit_id":"202980974","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"191","insp_unit_license":"BC98360","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXPEX2KJ254984","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":6008191,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ01604","insp_date":"2024-06-17 00:00:00","insp_start_time":"0815","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-25 @ DICKERSON RD","county_code_state":"MI","county_code":"157","insp_level_id":"1","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":"2024-06-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","viol_total":"10","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1182958","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2024-06-17 21:44:00","snet_input_date":"2024-06-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-17 21:44:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[{"id":9321225,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128404","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201433321","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39378"},{"id":9321226,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128405","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201433321","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3939A"},{"id":9321227,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128406","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201433321","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4390072","created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39617C"},{"id":9321228,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128407","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201433321","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3965B"},{"id":9321229,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128408","seq_no":"5","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"201433321","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39345"},{"id":9321230,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128409","seq_no":"6","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"2","insp_unit_id":"201433322","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4390072","created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393207C"},{"id":9321231,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128410","seq_no":"7","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"3","insp_unit_id":"201433323","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4390072","created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"393100B"},{"id":9321232,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128411","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"201433323","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39347E"},{"id":9321233,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128412","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"201433323","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3963A1"},{"id":9321234,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_violation_id":"260128413","seq_no":"10","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"3","insp_unit_id":"201433323","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9677092,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_unit_id":"201433321","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"114","insp_unit_license":"BA29527","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND17EDFV4744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9677093,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_unit_id":"201433322","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACA","insp_unit_company":"99A","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-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"},{"id":9677094,"change_date":"2024-06-17 21:44:00","inspection_id":"81891367","insp_unit_id":"201433323","insp_unit_type_id":"9","insp_unit_number":"3","insp_unit_make":"MACA","insp_unit_company":"99B","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-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":5482673,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","dot_number":"1294873","report_state":"MI","report_number":"HICKG02513","insp_date":"2024-04-10 00:00:00","insp_start_time":"0800","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 127 @ REST AREA","county_code_state":"MI","county_code":"065","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAEZ TRUCKING","shipping_paper_number":"34005","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"237000","viol_total":"14","oos_total":"3","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1172795","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[{"id":8466315,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858988","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":"X4357641","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"},{"id":8466316,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858989","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200336512","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39345B2"},{"id":8466317,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858990","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200336512","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3939A"},{"id":8466318,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858991","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"200336512","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3963A1"},{"id":8466319,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858992","seq_no":"5","part_no":"393","part_no_section":"70(c)","insp_viol_unit":"2","insp_unit_id":"200336513","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4357641","created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39370C"},{"id":8466320,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858993","seq_no":"6","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"200336513","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393207F"},{"id":8466321,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858994","seq_no":"7","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"200336513","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393207F"},{"id":8466322,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858995","seq_no":"8","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"200336513","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393207F"},{"id":8466323,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858996","seq_no":"9","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"3","insp_unit_id":"200336514","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39345D"},{"id":8466324,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858997","seq_no":"10","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"200336513","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"393207F"},{"id":8466325,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858998","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"200336514","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39348A"},{"id":8466326,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258858999","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"200336514","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39348A"},{"id":8466327,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258859000","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"200336514","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39348A"},{"id":8466328,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_violation_id":"258859001","seq_no":"14","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"200336514","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":8831786,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_unit_id":"200336512","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"113","insp_unit_license":"BD63570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40XXDJ34993","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8831787,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_unit_id":"200336513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E460597","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N484NR078182","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"},{"id":8831788,"change_date":"2024-04-10 21:42:00","inspection_id":"81320267","insp_unit_id":"200336514","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"E460598","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2L48XNR078183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:09.000000Z","updated_at":"2025-03-17T23:15:09.000000Z"}]},{"id":4910132,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ01437","insp_date":"2024-01-25 00:00:00","insp_start_time":"1240","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-24 @ ACKERMAN RD","county_code_state":"MI","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MICHIGAN SUGAR","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":"2024-01-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"219200","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1161843","transaction_code":"A","transaction_date":"2024-01-25 00:00:00","upload_date":"2024-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2024-01-26 21:39:00","snet_input_date":"2024-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-26 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:02.000000Z","updated_at":"2025-03-17T20:00:02.000000Z","inspection_violations":[{"id":7565079,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","insp_violation_id":"257515046","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199127330","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"39395F"},{"id":7565080,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","insp_violation_id":"257515047","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"199127332","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:32.000000Z","updated_at":"2025-03-17T21:42:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7901309,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","insp_unit_id":"199127330","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"115","insp_unit_license":"BD24433","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPXD40X4FD288659","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"},{"id":7901310,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","insp_unit_id":"199127331","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"99C","insp_unit_license":"D365487","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU274F4XS633173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"},{"id":7901311,"change_date":"2024-01-26 21:39:00","inspection_id":"80694904","insp_unit_id":"199127332","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"NONE","insp_unit_license":"D059694","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJU254F2XS633175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:38.000000Z","updated_at":"2025-03-17T23:06:38.000000Z"}]},{"id":3274343,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","dot_number":"1294873","report_state":"MI","report_number":"BALLB04201","insp_date":"2023-06-12 00:00:00","insp_start_time":"1545","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I94 WELCOME CENTER","county_code_state":"MI","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"KOMSA SARL","shipping_paper_number":"542211","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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"208600","viol_total":"7","oos_total":"1","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1130229","transaction_code":"A","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2023-06-13 21:42:00","snet_input_date":"2023-06-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-13 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:45.000000Z","updated_at":"2025-03-17T19:27:45.000000Z","inspection_violations":[{"id":5048478,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475848","seq_no":"5","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"195473646","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3929AA1"},{"id":5048479,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475849","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195473646","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3939A"},{"id":5048480,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475850","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195473646","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4235835","created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"39395A"},{"id":5048481,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475851","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:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"},{"id":5048482,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475852","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"},{"id":5048483,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475853","seq_no":"3","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:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"},{"id":5048484,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_violation_id":"253475854","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:29.000000Z","updated_at":"2025-03-17T21:30:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5264781,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_unit_id":"195473646","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"113","insp_unit_license":"BA55258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40XXDJ349939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5264782,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_unit_id":"195473647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST","insp_unit_company":"23A","insp_unit_license":"E460597","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1D2N484NR078182","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"},{"id":5264783,"change_date":"2023-06-13 21:42:00","inspection_id":"78880204","insp_unit_id":"195473648","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"EAST","insp_unit_company":"23B","insp_unit_license":"E460598","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1E1W2L48XNR078183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:29.000000Z","updated_at":"2025-03-17T22:44:29.000000Z"}]},{"id":3193156,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","dot_number":"1294873","report_state":"MI","report_number":"BACZM01945","insp_date":"2023-05-31 00:00:00","insp_start_time":"0904","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"1","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"224000","viol_total":"15","oos_total":"9","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1128725","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2023-06-01 21:42:00","snet_input_date":"2023-05-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-01 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING 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":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:07.000000Z","updated_at":"2025-03-17T19:26:07.000000Z","inspection_violations":[{"id":4918462,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214081","seq_no":"9","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4220595","created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207C"},{"id":4918463,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214082","seq_no":"10","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207C"},{"id":4918464,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214083","seq_no":"11","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207C"},{"id":4918465,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214084","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39347E"},{"id":4918466,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214085","seq_no":"13","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207A"},{"id":4918467,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214086","seq_no":"14","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207A"},{"id":4918468,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214087","seq_no":"15","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"393207A"},{"id":4918469,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214088","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4918470,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214089","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4918471,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214090","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4918472,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214091","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39347E"},{"id":4918473,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214092","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"3","insp_unit_id":"195260644","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3963A1"},{"id":4918474,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214093","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195260642","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"3939A"},{"id":4918475,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214094","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"},{"id":4918476,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_violation_id":"253214095","seq_no":"3","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"195260643","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:52.000000Z","updated_at":"2025-03-17T21:29:52.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5136018,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_unit_id":"195260642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"114","insp_unit_license":"BA29527","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND17EDFV4744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"},{"id":5136019,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_unit_id":"195260643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"25A","insp_unit_license":"B317706","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"},{"id":5136020,"change_date":"2023-06-01 21:42:00","inspection_id":"78788641","insp_unit_id":"195260644","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"88","insp_unit_license":"D436262","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681002","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:29.000000Z","updated_at":"2025-03-17T22:43:29.000000Z"}]},{"id":2084811,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ01025","insp_date":"2023-01-06 00:00:00","insp_start_time":"1155","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HURON @ 2 MILE","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MI SUGAR","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-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"210000","viol_total":"15","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1107904","transaction_code":"A","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2023-01-06 21:39:00","snet_input_date":"2023-01-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:06.000000Z","updated_at":"2025-03-17T19:05:06.000000Z","inspection_violations":[{"id":3225797,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428589","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39617C"},{"id":3225798,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428590","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3965B"},{"id":3225799,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428591","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3922"},{"id":3225800,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428592","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3922"},{"id":3225801,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428593","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39347E"},{"id":3225802,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428594","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39353B"},{"id":3225803,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428595","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192738700","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4160940","created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3963A1"},{"id":3225804,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428596","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"192738701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225805,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428597","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"192738701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225806,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428598","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"192738701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225807,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428599","seq_no":"11","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"192738701","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225808,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428600","seq_no":"12","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"192738702","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225809,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428601","seq_no":"13","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"3","insp_unit_id":"192738702","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39348A"},{"id":3225810,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428602","seq_no":"14","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"192738702","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4160940","created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3922"},{"id":3225811,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_violation_id":"250428603","seq_no":"15","part_no":"392","part_no_section":"2","insp_viol_unit":"3","insp_unit_id":"192738702","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3354123,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_unit_id":"192738700","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"111","insp_unit_license":"BB32655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X3BJ948744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:00.000000Z","updated_at":"2025-03-17T22:30:00.000000Z"},{"id":3354124,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_unit_id":"192738701","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":"2025-03-17T22:30:00.000000Z","updated_at":"2025-03-17T22:30:00.000000Z"},{"id":3354125,"change_date":"2023-01-06 21:39:00","inspection_id":"77528851","insp_unit_id":"192738702","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":"2025-03-17T22:30:00.000000Z","updated_at":"2025-03-17T22:30:00.000000Z"}]},{"id":1366121,"change_date":"2022-09-26 21:39:00","inspection_id":"76703519","dot_number":"1294873","report_state":"MI","report_number":"OSHEE01910","insp_date":"2022-09-23 00:00:00","insp_start_time":"0800","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ NORTH COUNTY LINE","county_code_state":"MI","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MACFARLANE","shipping_paper_number":"961153","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-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"113848","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":"1096321","transaction_code":"A","transaction_date":"2022-09-23 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2022-09-26 21:39:00","snet_input_date":"2022-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-26 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:57.000000Z","updated_at":"2025-03-17T18:51:57.000000Z","inspection_violations":[{"id":2160466,"change_date":"2022-09-26 21:39:00","inspection_id":"76703519","insp_violation_id":"248641882","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:16:55.000000Z","updated_at":"2025-03-17T21:16:55.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2199875,"change_date":"2022-09-26 21:39:00","inspection_id":"76703519","insp_unit_id":"191095537","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"111","insp_unit_license":"BB32655","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD40X3BJ948744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"},{"id":2199876,"change_date":"2022-09-26 21:39:00","inspection_id":"76703519","insp_unit_id":"191095538","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GINC","insp_unit_company":"808","insp_unit_license":"E516191","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2G9LS5894NB105143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:03.000000Z","updated_at":"2025-03-17T22:22:03.000000Z"}]},{"id":1046099,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","dot_number":"1294873","report_state":"MI","report_number":"EVANT01933","insp_date":"2022-08-16 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 NEAR ROBBINS SIDING RD","county_code_state":"MI","county_code":"029","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"205140","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1089529","transaction_code":"A","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2022-08-16 21:38:00","snet_input_date":"2022-08-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-16 21:38:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","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":1647260,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","insp_violation_id":"247738653","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:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"},{"id":1647261,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","insp_violation_id":"247738654","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190330748","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39617C"},{"id":1647262,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","insp_violation_id":"247738655","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190330748","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":1683174,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","insp_unit_id":"190330748","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"122","insp_unit_license":"BB28092","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYFXYB2YLF73469","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":1683175,"change_date":"2022-08-16 21:38:00","inspection_id":"76331101","insp_unit_id":"190330749","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"806","insp_unit_license":"D404638","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1TKL04586GW041543","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":1007509,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","dot_number":"1294873","report_state":"MI","report_number":"KOCHJ00845","insp_date":"2022-08-09 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LORENZO RD @ SIMPSON 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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"174600","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1088464","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2022-08-10 21:39:00","snet_input_date":"2022-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:25.000000Z","updated_at":"2025-03-17T18:45:25.000000Z","inspection_violations":[{"id":1585867,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","insp_violation_id":"247630834","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":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39141A"},{"id":1585868,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","insp_violation_id":"247630835","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190237830","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4100725","created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"3922"},{"id":1585869,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","insp_violation_id":"247630836","seq_no":"3","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"190237830","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"393130"}],"inspection_per_units":[{"id":1620722,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","insp_unit_id":"190237829","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"119","insp_unit_license":"BC16789","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKDGGGG20R381076","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"},{"id":1620723,"change_date":"2022-08-10 21:39:00","inspection_id":"76286302","insp_unit_id":"190237830","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"NONE","insp_unit_license":"D086256","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FW05137X1018870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"}]},{"id":895089,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","dot_number":"1294873","report_state":"MI","report_number":"EVANT99095","insp_date":"2022-07-25 00:00:00","insp_start_time":"1000","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CR 517 @ CR 612","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ST MARYS CEMENT","shipping_paper_number":"8089147120","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"1085542","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1410086,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","insp_violation_id":"247318973","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189970115","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4087763","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3922"},{"id":1410087,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","insp_violation_id":"247318974","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"189970115","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":1440714,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","insp_unit_id":"189970114","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"BC84701","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYFXZB81LH05459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"},{"id":1440715,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","insp_unit_id":"189970115","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"75A","insp_unit_license":"B317706","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"},{"id":1440716,"change_date":"2022-07-26 21:42:00","inspection_id":"76154718","insp_unit_id":"189970116","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"75B","insp_unit_license":"A111688","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"}]},{"id":873130,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","dot_number":"1294873","report_state":"MI","report_number":"DOWEM02155","insp_date":"2022-07-21 00:00:00","insp_start_time":"1150","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B I-75 4 MILE REST AREA","county_code_state":"MI","county_code":"039","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"8089096204","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"212000","viol_total":"10","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1085371","transaction_code":"A","transaction_date":"2022-07-21 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01294873","upload_search_indicator":null,"census_search_date":"2022-07-22 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-22 21:40:00","insp_carrier_name":"MACFARLANE TRUCKING LLC","insp_carrier_street":"3780 QUANICASSEE RD","insp_carrier_city":"FAIRGROVE","insp_carrier_state":"MI","insp_carrier_zip_code":"48733","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:03.000000Z","updated_at":"2025-03-17T18:43:03.000000Z","inspection_violations":[{"id":1374644,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254712","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189917068","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4074730","created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"},{"id":1374645,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254713","seq_no":"2","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4074730","created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39375G"},{"id":1374646,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254714","seq_no":"3","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39375G"},{"id":1374647,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254715","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189917068","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3963A1"},{"id":1374648,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254716","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189917068","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39347E"},{"id":1374649,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254717","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189917068","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39353B"},{"id":1374650,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254718","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39347E"},{"id":1374651,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254719","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39347E"},{"id":1374652,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254720","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39347E"},{"id":1374653,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_violation_id":"247254721","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"189917069","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1405626,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_unit_id":"189917068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"BC84071","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYFXZB81LH05459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"},{"id":1405627,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_unit_id":"189917069","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"75A","insp_unit_license":"B317706","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681503","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"},{"id":1405628,"change_date":"2022-07-22 21:40:00","inspection_id":"76129091","insp_unit_id":"189917070","insp_unit_type_id":"3","insp_unit_number":"3","insp_unit_make":"FRUE","insp_unit_company":"75B","insp_unit_license":"A111688","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"FWS681003","insp_unit_decal":"Y","insp_unit_decal_number":"31658121","created_at":"2025-03-17T22:16:50.000000Z","updated_at":"2025-03-17T22:16:50.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1294873\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1294873\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1294873\/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\/1294873\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}