{"current_page":1,"data":[{"id":12603238,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","dot_number":"335458","report_state":"MI","report_number":"STREJ01887","insp_date":"2026-07-31 00:00:00","insp_start_time":"0809","insp_end_time":"1025","registration_date":null,"region":"ED","ci_status_code":"C","location":"212","location_desc":"MI","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","viol_total":"7","oos_total":"3","driver_viol_total":"5","driver_oos_total":"2","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"6","hazmat_oos_total":"2","snet_sequence_id":"3880946","transaction_code":"A","transaction_date":"2026-07-31 00:00:00","upload_date":"2026-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2026-07-31 21:41:00","snet_input_date":"2026-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-31 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423-4022","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-03T09:41:17.000000Z","updated_at":"2026-08-08T09:36:20.000000Z","inspection_violations":[{"id":21941780,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853866","seq_no":"1","part_no":"172","part_no_section":"519D3-HMPMC","insp_viol_unit":"2","insp_unit_id":"214921100","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172519D3HMPMC"},{"id":21941781,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853867","seq_no":"2","part_no":"172","part_no_section":"506A-HMPMC","insp_viol_unit":"2","insp_unit_id":"214921100","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172506AHMPMC"},{"id":21941782,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853868","seq_no":"3","part_no":"172","part_no_section":"200A-HMSPS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172200AHMSPS"},{"id":21941783,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853869","seq_no":"4","part_no":"172","part_no_section":"202A1-HMSPS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172202A1HMSPS"},{"id":21941784,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853870","seq_no":"5","part_no":"172","part_no_section":"202A3-HMSPS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172202A3HMSPS"},{"id":21941785,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853871","seq_no":"6","part_no":"172","part_no_section":"202A4-HMSPS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"172202A4HMSPS"},{"id":21941786,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_violation_id":"275853872","seq_no":"7","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-03T10:01:38.000000Z","updated_at":"2026-08-08T09:51:27.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":21880451,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_unit_id":"214921099","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"411","insp_unit_license":"RC25981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR7PL877411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:21:23.000000Z","updated_at":"2026-08-08T09:11:43.000000Z"},{"id":21880452,"change_date":"2026-07-31 21:41:00","inspection_id":"88572889","insp_unit_id":"214921100","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"81","insp_unit_license":"E317118","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5324HB725381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-03T09:21:23.000000Z","updated_at":"2026-08-08T09:11:43.000000Z"}]},{"id":12078560,"change_date":"2026-06-02 21:41:00","inspection_id":"88021177","dot_number":"335458","report_state":"MI","report_number":"WASCC01371","insp_date":"2026-06-02 00:00:00","insp_start_time":"1125","insp_end_time":"1147","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"057","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MULT","shipping_paper_number":"MULT","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1","hazmat_oos_total":"0","snet_sequence_id":"3450228","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2026-06-02 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-02 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423-4022","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-06T09:40:29.000000Z","updated_at":"2026-06-13T09:31:40.000000Z","inspection_violations":[{"id":21017105,"change_date":"2026-06-02 21:41:00","inspection_id":"88021177","insp_violation_id":"274647128","seq_no":"1","part_no":"177","part_no_section":"823A-HMPMCNP-L6-1","insp_viol_unit":"2","insp_unit_id":"213874112","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:23.000000Z","updated_at":"2026-06-13T09:43:51.000000Z","normalized_code":"177823AHMPMCNPL61"}],"inspection_per_units":[{"id":20989474,"change_date":"2026-06-02 21:41:00","inspection_id":"88021177","insp_unit_id":"213874111","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC25981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR7PL877411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:26.000000Z","updated_at":"2026-06-13T09:02:48.000000Z"},{"id":20989475,"change_date":"2026-06-02 21:41:00","inspection_id":"88021177","insp_unit_id":"213874112","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E856137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:26.000000Z","updated_at":"2026-06-13T09:02:48.000000Z"}]},{"id":11370413,"change_date":"2026-03-13 21:37:00","inspection_id":"87284033","dot_number":"335458","report_state":"MI","report_number":"DAWDD04422","insp_date":"2026-03-11 00:00:00","insp_start_time":"0821","insp_end_time":"0842","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR BRANDS","shipping_paper_number":"0424139","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-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1262210","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:16.000000Z","updated_at":"2026-03-24T09:31:04.000000Z","inspection_violations":[{"id":19160731,"change_date":"2026-03-13 21:37:00","inspection_id":"87284033","insp_violation_id":"272391808","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-16T10:01:19.000000Z","updated_at":"2026-03-24T09:44:21.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":19469302,"change_date":"2026-03-13 21:37:00","inspection_id":"87284033","insp_unit_id":"212124668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"870","insp_unit_license":"RC06648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVHC5DV4DDFD6870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-16T09:16:58.000000Z","updated_at":"2026-03-24T09:04:36.000000Z"}]},{"id":10847237,"change_date":"2026-01-23 21:39:00","inspection_id":"86876040","dot_number":"335458","report_state":"MI","report_number":"LAUEJ02146","insp_date":"2026-01-22 00:00:00","insp_start_time":"1510","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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":"2026-01-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1257111","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2026-01-23 21:39:00","snet_input_date":"2026-01-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-23 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-26T10:37:32.000000Z","updated_at":"2026-02-03T10:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18225434,"change_date":"2026-01-23 21:39:00","inspection_id":"86876040","insp_unit_id":"211262022","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC58246","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDZAPR5RN131048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:56.000000Z","updated_at":"2026-02-03T10:02:59.000000Z"},{"id":18225435,"change_date":"2026-01-23 21:39:00","inspection_id":"86876040","insp_unit_id":"211262023","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E856137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-26T10:09:56.000000Z","updated_at":"2026-02-03T10:02:59.000000Z"}]},{"id":9986743,"change_date":"2025-10-20 21:39:00","inspection_id":"86096297","dot_number":"335458","report_state":"MI","report_number":"LOEDP03495","insp_date":"2025-10-20 00:00:00","insp_start_time":"0810","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"CCN612157","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"1246737","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:42.000000Z","updated_at":"2025-10-24T10:01:01.000000Z","inspection_violations":[{"id":16500500,"change_date":"2025-10-20 21:39:00","inspection_id":"86096297","insp_violation_id":"269401126","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209557552","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:59.000000Z","updated_at":"2025-10-24T10:16:36.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16583644,"change_date":"2025-10-20 21:39:00","inspection_id":"86096297","insp_unit_id":"209557551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:45.000000Z","updated_at":"2025-10-24T09:46:15.000000Z"},{"id":16583645,"change_date":"2025-10-20 21:39:00","inspection_id":"86096297","insp_unit_id":"209557552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"01","insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:45.000000Z","updated_at":"2025-10-24T09:46:15.000000Z"}]},{"id":9792812,"change_date":"2025-09-26 21:40:00","inspection_id":"85891807","dot_number":"335458","report_state":"MI","report_number":"ROLLJ02883","insp_date":"2025-09-25 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NW M115 @ N25 RD","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"1243293","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:10.000000Z","updated_at":"2025-09-30T10:01:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16229392,"change_date":"2025-09-26 21:40:00","inspection_id":"85891807","insp_unit_id":"209173902","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"411","insp_unit_license":"RC25981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR7PL877411","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:52.000000Z"},{"id":16229393,"change_date":"2025-09-26 21:40:00","inspection_id":"85891807","insp_unit_id":"209173903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:52.000000Z"}]},{"id":9645174,"change_date":"2025-09-10 21:40:00","inspection_id":"85736988","dot_number":"335458","report_state":"MI","report_number":"BRADD01492","insp_date":"2025-09-09 00:00:00","insp_start_time":"1440","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCKFORD RA","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAJOR BRANDS","shipping_paper_number":"418190","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"1240380","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:39.000000Z","updated_at":"2025-09-13T10:47:39.000000Z","inspection_violations":[{"id":15786990,"change_date":"2025-09-10 21:40:00","inspection_id":"85736988","insp_violation_id":"268584769","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208854026","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:43.000000Z","updated_at":"2025-09-14T11:56:09.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15936353,"change_date":"2025-09-10 21:40:00","inspection_id":"85736988","insp_unit_id":"208854026","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC55149","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDZAPR9PL877426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"},{"id":15936354,"change_date":"2025-09-10 21:40:00","inspection_id":"85736988","insp_unit_id":"208854027","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E317118","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5324HB725381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"}]},{"id":9155627,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","dot_number":"335458","report_state":"MI","report_number":"AKERT00567","insp_date":"2025-07-14 00:00:00","insp_start_time":"1200","insp_end_time":"1245","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"840 INTERCHANGE DR","county_code_state":"MI","county_code":"005","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","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-07-15 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"120350","viol_total":"18","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":"1230467","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:05.000000Z","updated_at":"2025-07-19T10:42:09.000000Z","inspection_violations":[{"id":14772866,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420261","seq_no":"1","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39383H"},{"id":14772867,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420262","seq_no":"2","part_no":"393","part_no_section":"65C-FNS","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39365CFNS"},{"id":14772868,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420263","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39360C"},{"id":14772869,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420264","seq_no":"5","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3965BL"},{"id":14772870,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420265","seq_no":"6","part_no":"396","part_no_section":"3A1-DLDSDST","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3963A1DLDSDST"},{"id":14772871,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420266","seq_no":"7","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3939ALHLI"},{"id":14772872,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420267","seq_no":"8","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3939ALFTSI"},{"id":14772873,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420268","seq_no":"9","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3939ALFTSI"},{"id":14772874,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420269","seq_no":"10","part_no":"393","part_no_section":"70B1I-CDFWFMI-LT20","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39370B1ICDFWFMILT20"},{"id":14772875,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420270","seq_no":"11","part_no":"393","part_no_section":"70B1I-CDFAM","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39370B1ICDFAM"},{"id":14772876,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420271","seq_no":"12","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"393203CCBP"},{"id":14772877,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420272","seq_no":"13","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39348ABISA"},{"id":14772878,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420273","seq_no":"14","part_no":"393","part_no_section":"48A-BI-SA","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"39348ABISA"},{"id":14772879,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420274","seq_no":"15","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3965HL"},{"id":14772880,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420275","seq_no":"16","part_no":"393","part_no_section":"207F-SDAS","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"393207FSDAS"},{"id":14772881,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420276","seq_no":"17","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3963A1BOS"},{"id":14772882,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420277","seq_no":"18","part_no":"173","part_no_section":"24B1-HMNBP","insp_viol_unit":"2","insp_unit_id":"207884086","insp_violation_category_id":"37","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"17324B1HMNBP"},{"id":14772883,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_violation_id":"267420278","seq_no":"4","part_no":"396","part_no_section":"3A1-TAOCV","insp_viol_unit":"1","insp_unit_id":"207884085","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3963A1TAOCV"}],"inspection_per_units":[{"id":15037489,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_unit_id":"207884085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RB92148","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR2FN118387","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:54.000000Z"},{"id":15037490,"change_date":"2025-07-15 21:40:00","inspection_id":"85222512","insp_unit_id":"207884086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"F125197","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532K4RJ443001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:54.000000Z"}]},{"id":9155665,"change_date":"2025-07-15 21:40:00","inspection_id":"85222553","dot_number":"335458","report_state":"MI","report_number":"HUGHB03142","insp_date":"2025-07-14 00:00:00","insp_start_time":"1130","insp_end_time":"1159","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US 31 & 13 MM","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2157","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1230312","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:05.000000Z","updated_at":"2025-07-19T10:42:10.000000Z","inspection_violations":[{"id":14772956,"change_date":"2025-07-15 21:40:00","inspection_id":"85222553","insp_violation_id":"267420361","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:20.000000Z","updated_at":"2025-07-18T10:48:20.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":15037543,"change_date":"2025-07-15 21:40:00","inspection_id":"85222553","insp_unit_id":"207884151","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:54.000000Z"},{"id":15037544,"change_date":"2025-07-15 21:40:00","inspection_id":"85222553","insp_unit_id":"207884152","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:54.000000Z"}]},{"id":9051989,"change_date":"2025-07-02 21:40:00","inspection_id":"85113403","dot_number":"335458","report_state":"MI","report_number":"LITTJ05502","insp_date":"2025-07-01 00:00:00","insp_start_time":"1215","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1228141","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"611 OTTAWA AVE","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:24.000000Z","updated_at":"2025-07-07T10:07:24.000000Z","inspection_violations":[{"id":14562736,"change_date":"2025-07-02 21:40:00","inspection_id":"85113403","insp_violation_id":"267176703","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"207680372","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:42.000000Z","updated_at":"2025-07-06T10:17:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":14850997,"change_date":"2025-07-02 21:40:00","inspection_id":"85113403","insp_unit_id":"207680372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"259","insp_unit_license":"BC62192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX32C6EM010259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:11.000000Z","updated_at":"2025-07-06T09:45:57.000000Z"}]},{"id":8534398,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","dot_number":"335458","report_state":"MI","report_number":"BACZM02693","insp_date":"2025-05-02 00:00:00","insp_start_time":"0957","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I69 EB @ M13","county_code_state":"MI","county_code":"155","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":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","viol_total":"12","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220078","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-05-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-05T10:16:07.000000Z","updated_at":"2025-05-06T10:06:19.000000Z","inspection_violations":[{"id":13516558,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976754","seq_no":"10","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39348ABIHE"},{"id":13516559,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976755","seq_no":"11","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39348ABIHE"},{"id":13516560,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976756","seq_no":"12","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"3963A1BOS"},{"id":13516561,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976757","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39141AMCPC"},{"id":13516562,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976758","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"38323A2LCDLN"},{"id":13516563,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976759","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206617514","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"3939ALRLI"},{"id":13516564,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976760","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206617514","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39617CPI"},{"id":13516565,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976761","seq_no":"5","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39343DBMA"},{"id":13516566,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976762","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"3939ALRLI"},{"id":13516567,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976763","seq_no":"7","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39311A1LRR"},{"id":13516568,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976764","seq_no":"8","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39348ABIHE"},{"id":13516569,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_violation_id":"265976765","seq_no":"9","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"206617515","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:53:57.000000Z","updated_at":"2025-05-06T10:32:11.000000Z","normalized_code":"39348ABIHE"}],"inspection_per_units":[{"id":13877103,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_unit_id":"206617514","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BB22336","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5GT4EEA15328","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:05:46.000000Z","updated_at":"2025-05-07T10:03:33.000000Z"},{"id":13877104,"change_date":"2025-05-02 21:41:00","inspection_id":"84566553","insp_unit_id":"206617515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"E933631","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5BKUF2021AT409992","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:05:46.000000Z","updated_at":"2025-05-07T10:03:33.000000Z"}]},{"id":8513162,"change_date":"2025-04-30 21:52:00","inspection_id":"84544240","dot_number":"335458","report_state":"MI","report_number":"BEAMW04289","insp_date":"2025-04-29 00:00:00","insp_start_time":"1220","insp_end_time":"1235","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 N @ MAPLE","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1219706","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:51:09.000000Z","updated_at":"2025-05-04T10:40:22.000000Z","inspection_violations":[{"id":13475897,"change_date":"2025-04-30 21:52:00","inspection_id":"84544240","insp_violation_id":"265930130","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:42:17.000000Z","updated_at":"2025-05-03T11:17:49.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":13839219,"change_date":"2025-04-30 21:52:00","inspection_id":"84544240","insp_unit_id":"206576326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"BC62192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1M2AX32C6EM010259","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:25:12.000000Z","updated_at":"2025-05-04T10:13:12.000000Z"}]},{"id":8311628,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","dot_number":"335458","report_state":"MI","report_number":"LOEDP03139","insp_date":"2025-04-07 00:00:00","insp_start_time":"0740","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MERGE TO EB I-94","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"132878","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1216427","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:23.000000Z","updated_at":"2025-04-11T10:11:23.000000Z","inspection_violations":[{"id":13076539,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","insp_violation_id":"265478547","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206187620","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:27:31.000000Z","updated_at":"2025-04-11T10:32:12.000000Z","normalized_code":"39617CPI"},{"id":13076540,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","insp_violation_id":"265478548","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"206187620","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:27:31.000000Z","updated_at":"2025-04-11T10:32:12.000000Z","normalized_code":"39360C"},{"id":13076541,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","insp_violation_id":"265478549","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"206187621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:27:31.000000Z","updated_at":"2025-04-11T10:32:12.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13478782,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","insp_unit_id":"206187620","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:51.000000Z","updated_at":"2025-04-11T09:58:56.000000Z"},{"id":13478783,"change_date":"2025-04-07 21:40:00","inspection_id":"84331830","insp_unit_id":"206187621","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:55:51.000000Z","updated_at":"2025-04-11T09:58:56.000000Z"}]},{"id":7739401,"change_date":"2025-01-29 21:41:00","inspection_id":"83729985","dot_number":"335458","report_state":"MI","report_number":"MOREM05665","insp_date":"2025-01-28 00:00:00","insp_start_time":"0841","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MILLETT HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR BRANDS","shipping_paper_number":"0410016","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-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1208119","transaction_code":"A","transaction_date":"2025-01-28 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[{"id":12092006,"change_date":"2025-01-29 21:41:00","inspection_id":"83729985","insp_violation_id":"264237608","seq_no":"1","part_no":"392","part_no_section":"2-SLL","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-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12489446,"change_date":"2025-01-29 21:41:00","inspection_id":"83729985","insp_unit_id":"205065494","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"781","insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12489447,"change_date":"2025-01-29 21:41:00","inspection_id":"83729985","insp_unit_id":"205065495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILCO","insp_unit_company":"24","insp_unit_license":"E615128","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"AT470","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7703016,"change_date":"2025-01-24 21:40:00","inspection_id":"83691846","dot_number":"335458","report_state":"MI","report_number":"GUTHG02689","insp_date":"2025-01-23 00:00:00","insp_start_time":"1525","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"E109202","cargo_tank":"OTH","hazmat_placard_req":"Y","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-01-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64990","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":"1207513","transaction_code":"A","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2025-01-24 21:40:00","snet_input_date":"2025-01-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-24 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:16.000000Z","updated_at":"2025-03-17T20:58:16.000000Z","inspection_violations":[{"id":12034576,"change_date":"2025-01-24 21:40:00","inspection_id":"83691846","insp_violation_id":"264162367","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"204994515","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"39311A1CSLRR"},{"id":12034577,"change_date":"2025-01-24 21:40:00","inspection_id":"83691846","insp_violation_id":"264162368","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"204994516","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:39.000000Z","updated_at":"2025-03-17T22:04:39.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":12430129,"change_date":"2025-01-24 21:40:00","inspection_id":"83691846","insp_unit_id":"204994515","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"93","insp_unit_license":"RC42099","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDJAPRXHL506493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:11.000000Z","updated_at":"2025-03-17T23:52:11.000000Z"},{"id":12430130,"change_date":"2025-01-24 21:40:00","inspection_id":"83691846","insp_unit_id":"204994516","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"NONE","insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:11.000000Z","updated_at":"2025-03-17T23:52:11.000000Z"}]},{"id":7340390,"change_date":"2024-12-04 21:41:00","inspection_id":"83311038","dot_number":"335458","report_state":"MI","report_number":"WHEES02936","insp_date":"2024-12-03 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR BRAND OIL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1203312","transaction_code":"A","transaction_date":"2024-12-03 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:21.000000Z","updated_at":"2025-03-17T20:49:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11841098,"change_date":"2024-12-04 21:41:00","inspection_id":"83311038","insp_unit_id":"204182346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"44","insp_unit_license":"RB19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGED50FSGP9617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"},{"id":11841099,"change_date":"2024-12-04 21:41:00","inspection_id":"83311038","insp_unit_id":"204182347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"01","insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:46.000000Z","updated_at":"2025-03-17T23:45:46.000000Z"}]},{"id":7174580,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","dot_number":"335458","report_state":"MI","report_number":"WASCC00760","insp_date":"2024-11-12 00:00:00","insp_start_time":"0733","insp_end_time":"0807","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"OFF RAMP","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","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-11-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1200980","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-11-12 21:42:00","snet_input_date":"2024-11-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-11-12 21:42:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:36.000000Z","updated_at":"2025-03-17T20:45:36.000000Z","inspection_violations":[{"id":11208840,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","insp_violation_id":"262848747","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"3922SLLFC"},{"id":11208841,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","insp_violation_id":"262848748","seq_no":"2","part_no":"393","part_no_section":"13C3-CSURR","insp_viol_unit":"2","insp_unit_id":"203841960","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"39313C3CSURR"},{"id":11208842,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","insp_violation_id":"262848749","seq_no":"3","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"2","insp_unit_id":"203841960","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:24.000000Z","updated_at":"2025-03-17T22:00:24.000000Z","normalized_code":"393106BC"}],"inspection_per_units":[{"id":11572361,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","insp_unit_id":"203841959","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"},{"id":11572362,"change_date":"2024-11-12 21:42:00","inspection_id":"83135973","insp_unit_id":"203841960","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"6001","insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:55.000000Z","updated_at":"2025-03-17T23:42:55.000000Z"}]},{"id":7003656,"change_date":"2024-10-22 21:41:00","inspection_id":"82954786","dot_number":"335458","report_state":"MI","report_number":"BARTC02732","insp_date":"2024-10-18 00:00:00","insp_start_time":"0935","insp_end_time":"0959","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M55 @ MERRITT","county_code_state":"MI","county_code":"113","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"E106965","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1198766","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-10-21 21:41:00","snet_input_date":"2024-10-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-21 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:14.000000Z","updated_at":"2025-03-17T20:42:14.000000Z","inspection_violations":[{"id":10928043,"change_date":"2024-10-22 21:41:00","inspection_id":"82954786","insp_violation_id":"262484815","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"203524809","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"3939ALHLI"},{"id":10928044,"change_date":"2024-10-22 21:41:00","inspection_id":"82954786","insp_violation_id":"262484816","seq_no":"2","part_no":"172","part_no_section":"201A1-HMSPS","insp_viol_unit":"1","insp_unit_id":"203524809","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:01.000000Z","updated_at":"2025-03-17T21:59:01.000000Z","normalized_code":"172201A1HMSPS"}],"inspection_per_units":[{"id":11296648,"change_date":"2024-10-22 21:41:00","inspection_id":"82954786","insp_unit_id":"203524809","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"},{"id":11296649,"change_date":"2024-10-22 21:41:00","inspection_id":"82954786","insp_unit_id":"203524810","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:58.000000Z","updated_at":"2025-03-17T23:39:58.000000Z"}]},{"id":6708972,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","dot_number":"335458","report_state":"IN","report_number":"9288005830","insp_date":"2024-09-06 00:00:00","insp_start_time":"1212","insp_end_time":"1319","registration_date":null,"region":"CD","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CENTRAL SUPPLY","shipping_paper_number":"79370","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"839694","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-09-12 21:41:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-12 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423-4022","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:06.000000Z","updated_at":"2025-03-17T20:36:06.000000Z","inspection_violations":[{"id":10444023,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759877","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202887459","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"3922"},{"id":10444024,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759878","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202887460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39347E"},{"id":10444025,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759879","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202887459","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39347E"},{"id":10444026,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759880","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202887460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39347E"},{"id":10444027,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759881","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202887460","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39347E"},{"id":10444028,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759882","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202887459","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39347E"},{"id":10444029,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759883","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202887459","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39353B"},{"id":10444030,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759884","seq_no":"8","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39524"},{"id":10444031,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759885","seq_no":"9","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"202887460","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"393100B"},{"id":10444032,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_violation_id":"261759886","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202887459","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10818072,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_unit_id":"202887459","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"93","insp_unit_license":"RC42099","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HCDJAPRXHL506493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:59.000000Z","updated_at":"2025-03-17T23:34:59.000000Z"},{"id":10818073,"change_date":"2024-09-12 21:41:00","inspection_id":"82641130","insp_unit_id":"202887460","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEHAUF C","insp_unit_company":"7901","insp_unit_license":"E399060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04221KL007901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:59.000000Z","updated_at":"2025-03-17T23:34:59.000000Z"}]},{"id":6103534,"change_date":"2024-06-28 21:39:00","inspection_id":"81993942","dot_number":"335458","report_state":"MI","report_number":"ROLLJ02512","insp_date":"2024-06-28 00:00:00","insp_start_time":"0757","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US131 @ S COUNTY LINE","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184166","transaction_code":"A","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9830794,"change_date":"2024-06-28 21:39:00","inspection_id":"81993942","insp_unit_id":"201646381","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"692392","insp_unit_license":"3450208","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXPN329287","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9830795,"change_date":"2024-06-28 21:39:00","inspection_id":"81993942","insp_unit_id":"201646382","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E856137","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":5995603,"change_date":"2024-06-14 21:40:00","inspection_id":"81877666","dot_number":"335458","report_state":"MI","report_number":"CINIM01888","insp_date":"2024-06-13 00:00:00","insp_start_time":"0940","insp_end_time":"1020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 96 EB @ SARANAC REST AREA","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAJOR BRANDS CO","shipping_paper_number":"E104319","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-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1182492","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-06-14 21:40:00","snet_input_date":"2024-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-14 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:30.000000Z","updated_at":"2025-03-17T20:21:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9656796,"change_date":"2024-06-14 21:40:00","inspection_id":"81877666","insp_unit_id":"201402449","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"Y","insp_unit_decal_number":"33974955","created_at":"2025-03-17T23:23:05.000000Z","updated_at":"2025-03-17T23:23:05.000000Z"},{"id":9656797,"change_date":"2024-06-14 21:40:00","inspection_id":"81877666","insp_unit_id":"201402450","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"147014","insp_unit_license":"P517319","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2538GG737822","insp_unit_decal":"Y","insp_unit_decal_number":"33974956","created_at":"2025-03-17T23:23:05.000000Z","updated_at":"2025-03-17T23:23:05.000000Z"}]},{"id":5885592,"change_date":"2024-05-31 21:39:00","inspection_id":"81757886","dot_number":"335458","report_state":"MI","report_number":"KELLC02091","insp_date":"2024-05-30 00:00:00","insp_start_time":"1245","insp_end_time":"1257","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131SB @ BOON RD","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"E104016","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1180666","transaction_code":"A","transaction_date":"2024-05-30 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9479422,"change_date":"2024-05-31 21:39:00","inspection_id":"81757886","insp_unit_id":"201175011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"26","insp_unit_license":"BC44696","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEFG0JLJR7326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"},{"id":9479423,"change_date":"2024-05-31 21:39:00","inspection_id":"81757886","insp_unit_id":"201175012","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"81","insp_unit_license":"E317118","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5324HB725381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:19.000000Z","updated_at":"2025-03-17T23:21:19.000000Z"}]},{"id":5868153,"change_date":"2024-05-29 21:41:00","inspection_id":"81739016","dot_number":"335458","report_state":"MI","report_number":"SILKS04021","insp_date":"2024-05-28 00:00:00","insp_start_time":"1359","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2","hazmat_oos_total":"1","snet_sequence_id":"1180327","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:04.000000Z","updated_at":"2025-03-17T20:19:04.000000Z","inspection_violations":[{"id":9098473,"change_date":"2024-05-29 21:41:00","inspection_id":"81739016","insp_violation_id":"259792343","seq_no":"1","part_no":"173","part_no_section":"24(b)(1)","insp_viol_unit":"2","insp_unit_id":"201137656","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4362295","created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"17324B1"},{"id":9098474,"change_date":"2024-05-29 21:41:00","inspection_id":"81739016","insp_violation_id":"259792344","seq_no":"2","part_no":"177","part_no_section":"801","insp_viol_unit":"2","insp_unit_id":"201137656","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"177801"}],"inspection_per_units":[{"id":9451232,"change_date":"2024-05-29 21:41:00","inspection_id":"81739016","insp_unit_id":"201137655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:03.000000Z","updated_at":"2025-03-17T23:21:03.000000Z"},{"id":9451233,"change_date":"2024-05-29 21:41:00","inspection_id":"81739016","insp_unit_id":"201137656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:03.000000Z","updated_at":"2025-03-17T23:21:03.000000Z"}]},{"id":5482554,"change_date":"2024-04-10 21:42:00","inspection_id":"81320130","dot_number":"335458","report_state":"MI","report_number":"BOSSL00462","insp_date":"2024-04-09 00:00:00","insp_start_time":"1330","insp_end_time":"1406","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB M6 @ I-196","county_code_state":"MI","county_code":"139","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"CCN612157","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1172869","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:29.000000Z","updated_at":"2025-03-17T20:11:29.000000Z","inspection_violations":[{"id":8466112,"change_date":"2024-04-10 21:42:00","inspection_id":"81320130","insp_violation_id":"258858723","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3922"},{"id":8466113,"change_date":"2024-04-10 21:42:00","inspection_id":"81320130","insp_violation_id":"258858724","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200336255","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:47:01.000000Z","updated_at":"2025-03-17T21:47:01.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":8831582,"change_date":"2024-04-10 21:42:00","inspection_id":"81320130","insp_unit_id":"200336254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","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":8831583,"change_date":"2024-04-10 21:42:00","inspection_id":"81320130","insp_unit_id":"200336255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"6001","insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","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":4966122,"change_date":"2024-02-02 21:42:00","inspection_id":"80756313","dot_number":"335458","report_state":"MI","report_number":"SCIBA02343","insp_date":"2024-02-01 00:00:00","insp_start_time":"0900","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MONROE","county_code_state":"MI","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1162821","transaction_code":"A","transaction_date":"2024-02-01 00:00:00","upload_date":"2024-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2024-02-02 21:42:00","snet_input_date":"2024-02-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-02 21:42:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:12.000000Z","updated_at":"2025-03-17T20:01:12.000000Z","inspection_violations":[{"id":7648695,"change_date":"2024-02-02 21:42:00","inspection_id":"80756313","insp_violation_id":"257638996","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:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7648696,"change_date":"2024-02-02 21:42:00","inspection_id":"80756313","insp_violation_id":"257638997","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199245656","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7992514,"change_date":"2024-02-02 21:42:00","inspection_id":"80756313","insp_unit_id":"199245655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"781","insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"},{"id":7992515,"change_date":"2024-02-02 21:42:00","inspection_id":"80756313","insp_unit_id":"199245656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"}]},{"id":4601916,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","dot_number":"335458","report_state":"MI","report_number":"OWENP01208","insp_date":"2023-12-08 00:00:00","insp_start_time":"0911","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M6 EB @ WILSON AVE","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAJOR BRANDS OIL","shipping_paper_number":"CCN612157","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1156760","transaction_code":"A","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-12-11 21:41:00","snet_input_date":"2023-12-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-11 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:09.000000Z","updated_at":"2025-03-17T19:54:09.000000Z","inspection_violations":[{"id":7115229,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_violation_id":"256817364","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198445257","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"39360C"},{"id":7115230,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_violation_id":"256817365","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"198445257","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"39345B2"},{"id":7115231,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_violation_id":"256817366","seq_no":"3","part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"198445257","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"172502A1"},{"id":7115232,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_violation_id":"256817367","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198445258","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:21.000000Z","updated_at":"2025-03-17T21:40:21.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":7401693,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_unit_id":"198445257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"},{"id":7401694,"change_date":"2023-12-11 21:41:00","inspection_id":"80358036","insp_unit_id":"198445258","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"E615127","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532W27L029171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"}]},{"id":4590384,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","dot_number":"335458","report_state":"MI","report_number":"POWEL03416","insp_date":"2023-12-07 00:00:00","insp_start_time":"1325","insp_end_time":"1403","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RIVER ROUGE LUBE PLANT","shipping_paper_number":"35614","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1156626","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:47.000000Z","updated_at":"2025-03-17T19:53:47.000000Z","inspection_violations":[{"id":7099202,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_violation_id":"256793161","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:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"3922"},{"id":7099203,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_violation_id":"256793162","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198421738","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"3939A"},{"id":7099204,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_violation_id":"256793163","seq_no":"3","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"198421739","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"393207F"},{"id":7099205,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_violation_id":"256793164","seq_no":"4","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"198421739","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:16.000000Z","updated_at":"2025-03-17T21:40:16.000000Z","normalized_code":"393207F"}],"inspection_per_units":[{"id":7383093,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_unit_id":"198421738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"},{"id":7383094,"change_date":"2023-12-08 21:41:00","inspection_id":"80345341","insp_unit_id":"198421739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"7909","insp_unit_license":"E399060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04221KL007901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"}]},{"id":4217615,"change_date":"2023-10-17 21:41:00","inspection_id":"79934036","dot_number":"335458","report_state":"MI","report_number":"KIRKB04347","insp_date":"2023-10-16 00:00:00","insp_start_time":"1445","insp_end_time":"1545","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SHELL OIL COMPANY","shipping_paper_number":"53164","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"109000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149755","transaction_code":"A","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-10-17 21:41:00","snet_input_date":"2023-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:17.000000Z","updated_at":"2025-03-17T19:46:17.000000Z","inspection_violations":[{"id":6528964,"change_date":"2023-10-17 21:41:00","inspection_id":"79934036","insp_violation_id":"255884322","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"197600568","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":6782793,"change_date":"2023-10-17 21:41:00","inspection_id":"79934036","insp_unit_id":"197600567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"},{"id":6782794,"change_date":"2023-10-17 21:41:00","inspection_id":"79934036","insp_unit_id":"197600568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"7901","insp_unit_license":"E399060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04221KL007901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:51.000000Z","updated_at":"2025-03-17T22:56:51.000000Z"}]},{"id":4184569,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","dot_number":"335458","report_state":"MI","report_number":"BRACG00961","insp_date":"2023-10-11 00:00:00","insp_start_time":"0840","insp_end_time":"0909","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1149232","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:50.000000Z","updated_at":"2025-03-17T19:45:50.000000Z","inspection_violations":[{"id":6478142,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_violation_id":"255803121","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"197527594","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39347E"},{"id":6478143,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_violation_id":"255803122","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"197527594","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"39353B"},{"id":6478144,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_violation_id":"255803123","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197527594","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"},{"id":6478145,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_violation_id":"255803124","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197527594","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"},{"id":6478146,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_violation_id":"255803125","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197527595","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6729386,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_unit_id":"197527594","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6729387,"change_date":"2023-10-12 21:41:00","inspection_id":"79897578","insp_unit_id":"197527595","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUE","insp_unit_company":"2","insp_unit_license":"E399060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1H4T04221KL007901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":3944074,"change_date":"2023-09-11 21:40:00","inspection_id":"79630794","dot_number":"335458","report_state":"MI","report_number":"WATTR03556","insp_date":"2023-09-08 00:00:00","insp_start_time":"1109","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WOODWARD AVE","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"CCN612157","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1145262","transaction_code":"A","transaction_date":"2023-09-08 00:00:00","upload_date":"2023-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-09-11 21:40:00","snet_input_date":"2023-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-11 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:47.000000Z","updated_at":"2025-03-17T19:40:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6341695,"change_date":"2023-09-11 21:40:00","inspection_id":"79630794","insp_unit_id":"196989993","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"67","insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:17.000000Z","updated_at":"2025-03-17T22:53:17.000000Z"},{"id":6341696,"change_date":"2023-09-11 21:40:00","inspection_id":"79630794","insp_unit_id":"196989994","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"71","insp_unit_license":"E615127","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532W27L029171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:17.000000Z","updated_at":"2025-03-17T22:53:17.000000Z"}]},{"id":3777132,"change_date":"2023-08-30 21:44:00","inspection_id":"79444332","dot_number":"335458","report_state":"MI","report_number":"KIRKB04267","insp_date":"2023-08-17 00:00:00","insp_start_time":"1620","insp_end_time":"1705","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B I-96 & LATSON","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"612157","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"1140905","transaction_code":"C","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-08-18 21:41:00","snet_input_date":"2023-08-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-18 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:19.000000Z","updated_at":"2025-03-17T19:37:19.000000Z","inspection_violations":[{"id":5826264,"change_date":"2023-08-30 21:44:00","inspection_id":"79444332","insp_violation_id":"254986180","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:34:03.000000Z","updated_at":"2025-03-17T21:34:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6072904,"change_date":"2023-08-30 21:44:00","inspection_id":"79444332","insp_unit_id":"196814948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"71","insp_unit_license":"E615127","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532W27L029171","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:02.000000Z","updated_at":"2025-03-17T22:51:02.000000Z"},{"id":6072905,"change_date":"2023-08-30 21:44:00","inspection_id":"79444332","insp_unit_id":"196814949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"44","insp_unit_license":"RC19126","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HSDJAPR7FN658544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:02.000000Z","updated_at":"2025-03-17T22:51:02.000000Z"}]},{"id":3723478,"change_date":"2023-08-30 21:45:00","inspection_id":"79384600","dot_number":"335458","report_state":"MI","report_number":"WERNR01241","insp_date":"2023-08-10 00:00:00","insp_start_time":"1312","insp_end_time":"1401","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MBA TOLLS","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1139586","transaction_code":"C","transaction_date":"2023-08-10 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5987074,"change_date":"2023-08-30 21:45:00","inspection_id":"79384600","insp_unit_id":"196817813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"Y","insp_unit_decal_number":"0","created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5987075,"change_date":"2023-08-30 21:45:00","inspection_id":"79384600","insp_unit_id":"196817814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E707063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V402C8CT176001","insp_unit_decal":"Y","insp_unit_decal_number":"00","created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3545848,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","dot_number":"335458","report_state":"MI","report_number":"FOXMA01089","insp_date":"2023-07-19 00:00:00","insp_start_time":"0830","insp_end_time":"0950","registration_date":null,"region":"ET","ci_status_code":"C","location":"641","location_desc":"EB IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DANA CONTAINER","shipping_paper_number":"MB30773","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-07-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1136241","transaction_code":"C","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-07-19 21:43:00","snet_input_date":"2023-07-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-19 21:43:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:08.000000Z","updated_at":"2025-03-17T19:33:08.000000Z","inspection_violations":[{"id":5465813,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238044","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196159160","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3939A"},{"id":5465814,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238045","seq_no":"8","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"2","insp_unit_id":"196159160","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"393201A"},{"id":5465815,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238046","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196159160","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"393207A"},{"id":5465816,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238047","seq_no":"10","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196159160","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"393207A"},{"id":5465817,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238048","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196159159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39347E"},{"id":5465818,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238049","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196159159","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39353B"},{"id":5465819,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238050","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196159160","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3963A1"},{"id":5465820,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238051","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196159159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39347E"},{"id":5465821,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238052","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196159159","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"39345B2"},{"id":5465822,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_violation_id":"254238053","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196159159","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4251404","created_at":"2025-03-17T21:32:23.000000Z","updated_at":"2025-03-17T21:32:23.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5701360,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_unit_id":"196159159","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC18203","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:00.000000Z","updated_at":"2025-03-17T22:48:00.000000Z"},{"id":5701361,"change_date":"2023-07-24 21:42:00","inspection_id":"79185521","insp_unit_id":"196159160","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E367225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA96475B708103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:00.000000Z","updated_at":"2025-03-17T22:48:00.000000Z"}]},{"id":3323396,"change_date":"2023-06-20 21:41:00","inspection_id":"78935788","dot_number":"335458","report_state":"MI","report_number":"MCGEJ02861","insp_date":"2023-06-16 00:00:00","insp_start_time":"1035","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US131 SB @ SHIPPY RD","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1131099","transaction_code":"A","transaction_date":"2023-06-16 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-06-20 21:41:00","snet_input_date":"2023-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:53.000000Z","updated_at":"2025-03-17T19:28:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5342474,"change_date":"2023-06-20 21:41:00","inspection_id":"78935788","insp_unit_id":"195582707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"26","insp_unit_license":"E317118","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGEFG0JLJR7326","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"},{"id":5342475,"change_date":"2023-06-20 21:41:00","inspection_id":"78935788","insp_unit_id":"195582708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"81","insp_unit_license":"E317118","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5324HB725381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":2767583,"change_date":"2023-04-11 12:04:00","inspection_id":"78307719","dot_number":"335458","report_state":"MI","report_number":"BURGM05215","insp_date":"2023-04-06 00:00:00","insp_start_time":"1420","insp_end_time":"1444","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAGINAW HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"54300","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":"1121145","transaction_code":"A","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-04-11 12:04:00","snet_input_date":"2023-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4246240,"change_date":"2023-04-11 12:04:00","inspection_id":"78307719","insp_violation_id":"252129179","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4454487,"change_date":"2023-04-11 12:04:00","inspection_id":"78307719","insp_unit_id":"194304254","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"94","insp_unit_license":"RB97701","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYCYXGDHJ6794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"}]},{"id":2656615,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","dot_number":"335458","report_state":"MI","report_number":"LARSE03102","insp_date":"2023-03-24 00:00:00","insp_start_time":"1035","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MM120","county_code_state":"MI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1119269","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:34.000000Z","updated_at":"2025-03-17T19:15:34.000000Z","inspection_violations":[{"id":4082728,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","insp_violation_id":"251858508","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3922"},{"id":4082729,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","insp_violation_id":"251858509","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194055089","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39378"},{"id":4082730,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","insp_violation_id":"251858510","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"194055090","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4277068,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","insp_unit_id":"194055089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"781","insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4277069,"change_date":"2023-03-24 21:41:00","inspection_id":"78180716","insp_unit_id":"194055090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D410096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":1497937,"change_date":"2022-10-12 21:42:00","inspection_id":"76856385","dot_number":"335458","report_state":"MI","report_number":"NEGUB02127","insp_date":"2022-10-11 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"145","location_desc":"CAMBRIDGE SCALES","county_code_state":"MI","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"0373844","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1098147","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-10-12 21:42:00","snet_input_date":"2022-10-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-12 21:42:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:11.000000Z","updated_at":"2025-03-17T18:54:11.000000Z","inspection_violations":[{"id":2356412,"change_date":"2022-10-12 21:42:00","inspection_id":"76856385","insp_violation_id":"248981693","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:47.000000Z","updated_at":"2025-03-17T21:17:47.000000Z","normalized_code":"172602C1"}],"inspection_per_units":[{"id":2410885,"change_date":"2022-10-12 21:42:00","inspection_id":"76856385","insp_unit_id":"191402125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"781","insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"},{"id":2410886,"change_date":"2022-10-12 21:42:00","inspection_id":"76856385","insp_unit_id":"191402126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D410096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:32.000000Z","updated_at":"2025-03-17T22:23:32.000000Z"}]},{"id":1466813,"change_date":"2022-10-07 21:39:00","inspection_id":"76820254","dot_number":"335458","report_state":"MI","report_number":"OSHEE01919","insp_date":"2022-10-06 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 @ GRACE RD","county_code_state":"MI","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTIPLE","shipping_paper_number":"737686","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1097637","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310077,"change_date":"2022-10-07 21:39:00","inspection_id":"76820254","insp_violation_id":"248899898","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191329536","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2361454,"change_date":"2022-10-07 21:39:00","inspection_id":"76820254","insp_unit_id":"191329535","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB66470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPVDP9X7DD182781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"},{"id":2361455,"change_date":"2022-10-07 21:39:00","inspection_id":"76820254","insp_unit_id":"191329536","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D410096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1304138,"change_date":"2022-09-16 21:40:00","inspection_id":"76631497","dot_number":"335458","report_state":"MI","report_number":"POWEL02798","insp_date":"2022-09-15 00:00:00","insp_start_time":"0900","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"0372449","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1095088","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:49.000000Z","updated_at":"2025-03-17T18:50:49.000000Z","inspection_violations":[{"id":2063234,"change_date":"2022-09-16 21:40:00","inspection_id":"76631497","insp_violation_id":"248469421","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190945648","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"39021TB"},{"id":2063235,"change_date":"2022-09-16 21:40:00","inspection_id":"76631497","insp_violation_id":"248469422","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190945648","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:28.000000Z","updated_at":"2025-03-17T21:16:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2098999,"change_date":"2022-09-16 21:40:00","inspection_id":"76631497","insp_unit_id":"190945648","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RB97701","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYCYXGDHJ6794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"}]},{"id":933963,"change_date":"2022-08-01 21:39:00","inspection_id":"76200590","dot_number":"335458","report_state":"MI","report_number":"MCGEJ02504","insp_date":"2022-07-28 00:00:00","insp_start_time":"1623","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"US131 SB @ SHIPPY RD","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"369710","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1086490","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-08-01 21:39:00","snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1473451,"change_date":"2022-08-01 21:39:00","inspection_id":"76200590","insp_violation_id":"247430739","seq_no":"1","part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"190063258","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"172502A1"}],"inspection_per_units":[{"id":1503354,"change_date":"2022-08-01 21:39:00","inspection_id":"76200590","insp_unit_id":"190063258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"94","insp_unit_license":"RB97701","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYCYXGDHJ6794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":539847,"change_date":"2022-06-09 21:43:00","inspection_id":"75736713","dot_number":"335458","report_state":"MI","report_number":"WERNR01127","insp_date":"2022-06-02 00:00:00","insp_start_time":"1330","insp_end_time":"1344","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MBA TOLLS","county_code_state":"MI","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1078264","transaction_code":"C","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-06-03 21:40:00","snet_input_date":"2022-06-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-03 21:40:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:06.000000Z","updated_at":"2025-03-17T18:37:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":868762,"change_date":"2022-06-09 21:43:00","inspection_id":"75736713","insp_unit_id":"189154458","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RB92148","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DE67HX48979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"},{"id":868763,"change_date":"2022-06-09 21:43:00","inspection_id":"75736713","insp_unit_id":"189154459","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"C663984","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"MI8557R263R071221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:33.000000Z","updated_at":"2025-03-17T22:13:33.000000Z"}]},{"id":445241,"change_date":"2022-06-09 21:42:00","inspection_id":"75623856","dot_number":"335458","report_state":"MI","report_number":"PRIED01804","insp_date":"2022-05-18 00:00:00","insp_start_time":"1243","insp_end_time":"1259","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 @ 12 MILE","county_code_state":"MI","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1076116","transaction_code":"C","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:36.000000Z","updated_at":"2025-03-17T18:35:36.000000Z","inspection_violations":[{"id":702870,"change_date":"2022-06-09 21:42:00","inspection_id":"75623856","insp_violation_id":"246340504","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:10:21.000000Z","updated_at":"2025-03-17T21:10:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":717563,"change_date":"2022-06-09 21:42:00","inspection_id":"75623856","insp_unit_id":"189151566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA78192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"},{"id":717564,"change_date":"2022-06-09 21:42:00","inspection_id":"75623856","insp_unit_id":"189151567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"D410096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"}]},{"id":88470,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","dot_number":"335458","report_state":"MI","report_number":"COLLD02421","insp_date":"2022-03-31 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB US 131 NEAR MORLEY R\/A","county_code_state":"MI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S.A.C.","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"3","hazmat_oos_total":"0","snet_sequence_id":"1070095","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00335458","upload_search_indicator":null,"census_search_date":"2022-04-01 21:39:00","snet_input_date":"2022-03-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-01 21:39:00","insp_carrier_name":"MAJOR BRANDS OIL COMPANY INC","insp_carrier_street":"462 W 23RD ST","insp_carrier_city":"HOLLAND","insp_carrier_state":"MI","insp_carrier_zip_code":"49423","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:08.000000Z","updated_at":"2025-03-17T18:29:08.000000Z","inspection_violations":[{"id":131265,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_violation_id":"244911535","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"187939301","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"172602C1"},{"id":131266,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_violation_id":"244911536","seq_no":"2","part_no":"177","part_no_section":"817(e)","insp_viol_unit":"1","insp_unit_id":"187939301","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"177817E"},{"id":131267,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_violation_id":"244911537","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"187939302","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"3939A"},{"id":131268,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_violation_id":"244911538","seq_no":"4","part_no":"172","part_no_section":"331","insp_viol_unit":"2","insp_unit_id":"187939302","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"172331"}],"inspection_per_units":[{"id":143635,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_unit_id":"187939301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BA78192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJC5DV5BDAW8767","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:05.000000Z","updated_at":"2025-03-17T22:09:05.000000Z"},{"id":143636,"change_date":"2022-04-01 21:39:00","inspection_id":"75196369","insp_unit_id":"187939302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"E410096","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GRAA0625BD439075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:05.000000Z","updated_at":"2025-03-17T22:09:05.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/335458\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/335458\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/335458\/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\/335458\/inspections","per_page":100,"prev_page_url":null,"to":43,"total":43}