{"current_page":1,"data":[{"id":12521264,"change_date":"2026-07-22 21:44:00","inspection_id":"88486549","dot_number":"737814","report_state":"CA","report_number":"UDO7001630","insp_date":"2026-07-20 00:00:00","insp_start_time":"1018","insp_end_time":"1101","registration_date":null,"region":"PD","ci_status_code":"C","location":"656","location_desc":"CA","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING INC","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3813502","transaction_code":"A","transaction_date":"2026-07-22 00:00:00","upload_date":"2026-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-07-22 21:44:00","snet_input_date":"2026-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-22 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-07-25T09:41:43.000000Z","updated_at":"2026-08-02T09:31:26.000000Z","inspection_violations":[{"id":21797564,"change_date":"2026-07-22 21:44:00","inspection_id":"88486549","insp_violation_id":"275668903","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"214763570","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-07-25T10:02:39.000000Z","updated_at":"2026-08-02T09:43:53.000000Z","normalized_code":"3963A1BOS"},{"id":21797565,"change_date":"2026-07-22 21:44:00","inspection_id":"88486549","insp_violation_id":"275668904","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"214763570","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-25T10:02:39.000000Z","updated_at":"2026-08-02T09:43:53.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":21744603,"change_date":"2026-07-22 21:44:00","inspection_id":"88486549","insp_unit_id":"214763570","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U12\/WHT","insp_unit_license":"16795U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":"Y","insp_unit_decal_number":"36556792","created_at":"2026-07-25T09:20:49.000000Z","updated_at":"2026-08-02T09:03:05.000000Z"}]},{"id":12469657,"change_date":"2026-07-16 21:42:00","inspection_id":"88430699","dot_number":"737814","report_state":"CA","report_number":"UFM4000012","insp_date":"2026-07-16 00:00:00","insp_start_time":"1115","insp_end_time":"1145","registration_date":null,"region":"PD","ci_status_code":"C","location":"651","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING INC","shipping_paper_number":"MIS0002334","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3770466","transaction_code":"A","transaction_date":"2026-07-16 00:00:00","upload_date":"2026-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-07-16 21:42:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-16 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-19T09:41:14.000000Z","updated_at":"2026-07-27T09:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21658266,"change_date":"2026-07-16 21:42:00","inspection_id":"88430699","insp_unit_id":"214653801","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U15","insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-19T09:20:38.000000Z","updated_at":"2026-07-27T09:02:57.000000Z"}]},{"id":12442081,"change_date":"2026-07-14 21:40:00","inspection_id":"88401631","dot_number":"737814","report_state":"CA","report_number":"NF35001662","insp_date":"2026-07-13 00:00:00","insp_start_time":"1138","insp_end_time":"1153","registration_date":null,"region":"PD","ci_status_code":"C","location":"651","location_desc":"CA","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"MIS0002334","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":"U","pen_cen_match":"I","final_status_date":"2026-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3744175","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-07-14 21:40:00","snet_input_date":"2026-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-14 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-17T09:41:03.000000Z","updated_at":"2026-07-25T09:30:35.000000Z","inspection_violations":[{"id":21662420,"change_date":"2026-07-14 21:40:00","inspection_id":"88401631","insp_violation_id":"275487450","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"214599633","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-17T10:03:17.000000Z","updated_at":"2026-07-25T09:42:39.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":21612522,"change_date":"2026-07-14 21:40:00","inspection_id":"88401631","insp_unit_id":"214599633","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U-8\/WHT","insp_unit_license":"29673J4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F8SSA03434","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:04.000000Z","updated_at":"2026-07-25T09:01:56.000000Z"}]},{"id":12323609,"change_date":"2026-06-30 21:40:00","inspection_id":"88281675","dot_number":"737814","report_state":"CA","report_number":"UGHP000986","insp_date":"2026-06-30 00:00:00","insp_start_time":"0635","insp_end_time":"0705","registration_date":null,"region":"PD","ci_status_code":"C","location":"9390","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","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":"U","pen_cen_match":"I","final_status_date":"2026-06-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3653664","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-06-30 21:40:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-30 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-03T09:41:23.000000Z","updated_at":"2026-07-11T09:30:47.000000Z","inspection_violations":[{"id":21449064,"change_date":"2026-06-30 21:40:00","inspection_id":"88281675","insp_violation_id":"275221092","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214370349","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"DA730385","created_at":"2026-07-03T10:02:25.000000Z","updated_at":"2026-07-11T09:41:02.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":21403378,"change_date":"2026-06-30 21:40:00","inspection_id":"88281675","insp_unit_id":"214370349","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:17:59.000000Z","updated_at":"2026-07-11T09:01:57.000000Z"}]},{"id":12296501,"change_date":"2026-06-27 21:41:00","inspection_id":"88253319","dot_number":"737814","report_state":"CA","report_number":"ND5A009451","insp_date":"2026-06-25 00:00:00","insp_start_time":"1300","insp_end_time":"1314","registration_date":null,"region":"PD","ci_status_code":"C","location":"131","location_desc":"CA","county_code_state":"CA","county_code":"103","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"7751847","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":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"3629071","transaction_code":"A","transaction_date":"2026-06-27 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:08.000000Z","updated_at":"2026-07-08T09:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21358230,"change_date":"2026-06-27 21:41:00","inspection_id":"88253319","insp_unit_id":"214315866","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U4\/WHT","insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:21.000000Z","updated_at":"2026-07-08T09:01:31.000000Z"}]},{"id":12222106,"change_date":"2026-06-18 21:41:00","inspection_id":"88179920","dot_number":"737814","report_state":"CA","report_number":"ND5A009411","insp_date":"2026-06-18 00:00:00","insp_start_time":"0456","insp_end_time":"0512","registration_date":null,"region":"PS","ci_status_code":"C","location":"131","location_desc":"CA","county_code_state":"CA","county_code":"103","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7746858P","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":"U","pen_cen_match":"I","final_status_date":"2026-06-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"3571266","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:37.000000Z","updated_at":"2026-06-29T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21226257,"change_date":"2026-06-18 21:41:00","inspection_id":"88179920","insp_unit_id":"214171464","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U4\/WHI","insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-21T09:19:26.000000Z","updated_at":"2026-06-29T09:01:48.000000Z"}]},{"id":12202053,"change_date":"2026-06-16 21:40:00","inspection_id":"88158859","dot_number":"737814","report_state":"CA","report_number":"UEGX002891","insp_date":"2026-06-16 00:00:00","insp_start_time":"1130","insp_end_time":"1200","registration_date":null,"region":"PS","ci_status_code":"C","location":"320","location_desc":"CA","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"7749449","cargo_tank":"EXE","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3556668","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-06-19T09:42:41.000000Z","updated_at":"2026-06-27T09:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21193183,"change_date":"2026-06-16 21:40:00","inspection_id":"88158859","insp_unit_id":"214132540","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"24236H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F3SSA02952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:20.000000Z","updated_at":"2026-06-27T09:02:03.000000Z"}]},{"id":12189982,"change_date":"2026-06-15 21:41:00","inspection_id":"88145871","dot_number":"737814","report_state":"CA","report_number":"NDA2008447","insp_date":"2026-06-11 00:00:00","insp_start_time":"0625","insp_end_time":"0704","registration_date":null,"region":"PS","ci_status_code":"C","location":"881","location_desc":"CA","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7737609","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"3545499","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-06-18T09:40:59.000000Z","updated_at":"2026-06-26T09:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21172858,"change_date":"2026-06-15 21:41:00","inspection_id":"88145871","insp_unit_id":"214106314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U6","insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"Y","insp_unit_decal_number":"36179755","created_at":"2026-06-18T09:17:47.000000Z","updated_at":"2026-06-26T09:01:59.000000Z"}]},{"id":11970302,"change_date":"2026-05-20 21:40:00","inspection_id":"87907032","dot_number":"737814","report_state":"CA","report_number":"NCEB009793","insp_date":"2026-05-19 00:00:00","insp_start_time":"0918","insp_end_time":"0946","registration_date":null,"region":"PS","ci_status_code":"C","location":"726","location_desc":"CA","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"773270P","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3366885","transaction_code":"A","transaction_date":"2026-05-20 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:50.000000Z","updated_at":"2026-06-01T09:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20812190,"change_date":"2026-05-20 21:40:00","inspection_id":"87907032","insp_unit_id":"213659592","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U7 WHITE","insp_unit_license":"24236H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F3SSA02952","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:14.000000Z","updated_at":"2026-06-01T09:02:17.000000Z"}]},{"id":11899857,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","dot_number":"737814","report_state":"NM","report_number":"2434Q3ODMH","insp_date":"2026-05-12 00:00:00","insp_start_time":"1058","insp_end_time":"1140","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"MIS 0002334","cargo_tank":"EXE","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":"2026-05-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2303941","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-05-13 21:42:00","snet_input_date":"2026-05-13 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-05-13 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-15T12:26:59.000000Z","updated_at":"2026-05-24T09:31:44.000000Z","inspection_violations":[{"id":20697463,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","insp_violation_id":"274232805","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"213533208","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:30.000000Z","updated_at":"2026-05-24T09:45:38.000000Z","normalized_code":"39347E"},{"id":20697462,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","insp_violation_id":"274232804","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"213533208","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-15T12:59:30.000000Z","updated_at":"2026-05-24T09:45:38.000000Z","normalized_code":"39375A3"},{"id":20697464,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","insp_violation_id":"274232806","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"213533208","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-15T12:59:30.000000Z","updated_at":"2026-05-24T09:45:38.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":20688447,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","insp_unit_id":"213533207","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 401","insp_unit_license":"PAW5318","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR0MSMH8694","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:54.000000Z","updated_at":"2026-05-24T09:05:08.000000Z"},{"id":20688448,"change_date":"2026-05-13 21:42:00","inspection_id":"87838513","insp_unit_id":"213533208","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"UNIT 191135","insp_unit_license":"STB0911","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1W9GJ4327PB355135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-15T12:14:54.000000Z","updated_at":"2026-05-24T09:05:08.000000Z"}]},{"id":11924091,"change_date":"2026-05-15 21:44:00","inspection_id":"87858396","dot_number":"737814","report_state":"CA","report_number":"UGJO000735","insp_date":"2026-05-08 00:00:00","insp_start_time":"0840","insp_end_time":"0900","registration_date":null,"region":"PS","ci_status_code":"C","location":"150","location_desc":"CA","county_code_state":"CA","county_code":"045","insp_level_id":"3","service_center":"WE","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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3330916","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-05-18T09:40:27.000000Z","updated_at":"2026-05-26T09:30:53.000000Z","inspection_violations":[{"id":20741833,"change_date":"2026-05-15 21:44:00","inspection_id":"87858396","insp_violation_id":"274280848","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213571296","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:41.000000Z","updated_at":"2026-05-26T09:43:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20737361,"change_date":"2026-05-15 21:44:00","inspection_id":"87858396","insp_unit_id":"213571296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:36.000000Z","updated_at":"2026-05-26T09:02:57.000000Z"}]},{"id":11924588,"change_date":"2026-05-15 21:44:00","inspection_id":"87858919","dot_number":"737814","report_state":"CA","report_number":"NA5N009431","insp_date":"2026-05-07 00:00:00","insp_start_time":"0545","insp_end_time":"0626","registration_date":null,"region":"PS","ci_status_code":"C","location":"391","location_desc":"CA","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY INC","shipping_paper_number":"MIS0002334","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"3329514","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:27.000000Z","updated_at":"2026-05-26T09:30:57.000000Z","inspection_violations":[{"id":20742532,"change_date":"2026-05-15 21:44:00","inspection_id":"87858919","insp_violation_id":"274281651","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:00:43.000000Z","updated_at":"2026-05-26T09:43:41.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20738154,"change_date":"2026-05-15 21:44:00","inspection_id":"87858919","insp_unit_id":"213572160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"2X WHT","insp_unit_license":"51618S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W169K7K00648","insp_unit_decal":"Y","insp_unit_decal_number":"36188207","created_at":"2026-05-18T09:18:37.000000Z","updated_at":"2026-05-26T09:03:04.000000Z"}]},{"id":11927524,"change_date":"2026-05-15 21:44:00","inspection_id":"87862013","dot_number":"737814","report_state":"CA","report_number":"UDM7005018","insp_date":"2026-05-06 00:00:00","insp_start_time":"1505","insp_end_time":"1532","registration_date":null,"region":"PS","ci_status_code":"C","location":"320","location_desc":"CA","county_code_state":"CA","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"28948","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3334660","transaction_code":"A","transaction_date":"2026-05-15 00:00:00","upload_date":"2026-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-05-15 21:44:00","snet_input_date":"2026-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-15 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-18T09:40:32.000000Z","updated_at":"2026-05-26T09:31:26.000000Z","inspection_violations":[{"id":20747269,"change_date":"2026-05-15 21:44:00","inspection_id":"87862013","insp_violation_id":"274287996","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213577823","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-18T10:01:00.000000Z","updated_at":"2026-05-26T09:44:30.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":20742850,"change_date":"2026-05-15 21:44:00","inspection_id":"87862013","insp_unit_id":"213577823","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-18T09:18:45.000000Z","updated_at":"2026-05-26T09:03:38.000000Z"}]},{"id":11796410,"change_date":"2026-04-30 21:41:00","inspection_id":"87729326","dot_number":"737814","report_state":"CA","report_number":"UEGX002695","insp_date":"2026-04-30 00:00:00","insp_start_time":"0650","insp_end_time":"0720","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"I-80 E\/B JEO CORDELIA SCALES","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAYFLOWER DIST.","shipping_paper_number":"795304","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16269353","transaction_code":"A","transaction_date":"2026-04-30 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-04-30 21:41:00","snet_input_date":"2026-04-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-05-03T09:41:02.000000Z","updated_at":"2026-05-11T09:31:45.000000Z","inspection_violations":[{"id":20513432,"change_date":"2026-04-30 21:41:00","inspection_id":"87729326","insp_violation_id":"273971929","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SN25768","created_at":"2026-05-03T10:02:10.000000Z","updated_at":"2026-05-11T09:43:11.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":20520199,"change_date":"2026-04-30 21:41:00","inspection_id":"87729326","insp_unit_id":"213322288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:18:09.000000Z","updated_at":"2026-05-11T09:04:25.000000Z"}]},{"id":11278904,"change_date":"2026-03-03 21:36:00","inspection_id":"87193508","dot_number":"737814","report_state":"CA","report_number":"NEGR004925","insp_date":"2026-03-02 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"PT","ci_status_code":"C","location":"530","location_desc":"CARSON PLATFORM SCALES","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-03 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"16191455","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-03-03 21:36:00","snet_input_date":"2026-03-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-03 21:36:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-03-06T10:39:45.000000Z","updated_at":"2026-03-14T09:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19289486,"change_date":"2026-03-03 21:36:00","inspection_id":"87193508","insp_unit_id":"211947672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/U15","insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":"Y","insp_unit_decal_number":"35907374","created_at":"2026-03-06T10:17:09.000000Z","updated_at":"2026-03-14T09:03:41.000000Z"}]},{"id":11313440,"change_date":"2026-03-06 21:43:00","inspection_id":"87229695","dot_number":"737814","report_state":"CA","report_number":"NDOG007048","insp_date":"2026-02-27 00:00:00","insp_start_time":"0814","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"U8","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"16197736","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-03-06 21:43:00","snet_input_date":"2026-02-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-06 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-03-09T09:42:52.000000Z","updated_at":"2026-03-17T09:31:32.000000Z","inspection_violations":[{"id":19040830,"change_date":"2026-03-06 21:43:00","inspection_id":"87229695","insp_violation_id":"272265988","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"212023273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:09:06.000000Z","updated_at":"2026-03-17T09:41:43.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19356948,"change_date":"2026-03-06 21:43:00","inspection_id":"87229695","insp_unit_id":"212023273","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U8","insp_unit_license":"29673J4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F8SSA03434","insp_unit_decal":"Y","insp_unit_decal_number":"35898015","created_at":"2026-03-09T09:28:30.000000Z","updated_at":"2026-03-17T09:04:09.000000Z"}]},{"id":11048894,"change_date":"2026-02-04 21:39:00","inspection_id":"86958948","dot_number":"737814","report_state":"CA","report_number":"NAGM011074","insp_date":"2026-02-04 00:00:00","insp_start_time":"1003","insp_end_time":"1028","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","shipping_paper_number":"96747U3","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"16157931","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:02.000000Z","updated_at":"2026-02-15T10:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18378323,"change_date":"2026-02-04 21:39:00","inspection_id":"86958948","insp_unit_id":"211445441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U14\/WHT","insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":"Y","insp_unit_decal_number":"35934446","created_at":"2026-02-07T10:11:03.000000Z","updated_at":"2026-02-15T10:05:39.000000Z"}]},{"id":11048938,"change_date":"2026-02-04 21:39:00","inspection_id":"86958992","dot_number":"737814","report_state":"CA","report_number":"NARW004124","insp_date":"2026-02-03 00:00:00","insp_start_time":"1131","insp_end_time":"1152","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST, CO.","shipping_paper_number":"368457","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"16156677","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-02-08T10:37:02.000000Z","updated_at":"2026-02-15T10:30:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18378391,"change_date":"2026-02-04 21:39:00","inspection_id":"86958992","insp_unit_id":"211445512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U-7 WHT2X","insp_unit_license":"24236H4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F3SSA02952","insp_unit_decal":"Y","insp_unit_decal_number":"35884284","created_at":"2026-02-07T10:11:03.000000Z","updated_at":"2026-02-15T10:05:40.000000Z"}]},{"id":10865157,"change_date":"2026-01-26 21:37:00","inspection_id":"86894878","dot_number":"737814","report_state":"CA","report_number":"UFUH001049","insp_date":"2026-01-26 00:00:00","insp_start_time":"1225","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"616","location_desc":"W\/B PERALTA SCALE","county_code_state":"CA","county_code":"059","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-26 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"16145500","transaction_code":"A","transaction_date":"2026-01-26 00:00:00","upload_date":"2026-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-01-26 21:37:00","snet_input_date":"2026-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-26 21:37:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-01-29T10:36:11.000000Z","updated_at":"2026-02-06T10:30:42.000000Z","inspection_violations":[{"id":18177804,"change_date":"2026-01-26 21:37:00","inspection_id":"86894878","insp_violation_id":"271438625","seq_no":"1","part_no":"177","part_no_section":"817E1-HMHC","insp_viol_unit":"1","insp_unit_id":"211300950","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-29T10:41:33.000000Z","updated_at":"2026-02-06T10:36:41.000000Z","normalized_code":"177817E1HMHC"},{"id":18177805,"change_date":"2026-01-26 21:37:00","inspection_id":"86894878","insp_violation_id":"271438626","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"211300950","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-29T10:41:33.000000Z","updated_at":"2026-02-06T10:36:41.000000Z","normalized_code":"39395A4EEUS"},{"id":18177806,"change_date":"2026-01-26 21:37:00","inspection_id":"86894878","insp_violation_id":"271438627","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"211300950","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-29T10:41:33.000000Z","updated_at":"2026-02-06T10:36:41.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":18257402,"change_date":"2026-01-26 21:37:00","inspection_id":"86894878","insp_unit_id":"211300950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-29T10:07:43.000000Z","updated_at":"2026-02-06T10:03:06.000000Z"}]},{"id":10654713,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","dot_number":"737814","report_state":"CA","report_number":"UFUH001017","insp_date":"2026-01-13 00:00:00","insp_start_time":"1200","insp_end_time":"1300","registration_date":null,"region":"PT","ci_status_code":"C","location":"616","location_desc":"W\/B PERALTA SCALE","county_code_state":"CA","county_code":"059","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"16129340","transaction_code":"A","transaction_date":"2026-01-13 00:00:00","upload_date":"2026-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-01-14 21:41:00","snet_input_date":"2026-01-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-14 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2026-01-17T10:36:37.000000Z","updated_at":"2026-01-25T10:31:18.000000Z","inspection_violations":[{"id":17928327,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_violation_id":"271215369","seq_no":"1","part_no":"172","part_no_section":"504A-HMPS","insp_viol_unit":"1","insp_unit_id":"211096506","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-17T10:43:59.000000Z","updated_at":"2026-01-25T10:32:04.000000Z","normalized_code":"172504AHMPS"},{"id":17928328,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_violation_id":"271215370","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211096506","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-17T10:43:59.000000Z","updated_at":"2026-01-25T10:32:04.000000Z","normalized_code":"39375A3TAOL"},{"id":17928329,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_violation_id":"271215371","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211096506","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"00Q30002S","created_at":"2026-01-17T10:43:59.000000Z","updated_at":"2026-01-25T10:32:04.000000Z","normalized_code":"39347E"},{"id":17928330,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_violation_id":"271215372","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"211096506","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-17T10:43:59.000000Z","updated_at":"2026-01-25T10:32:04.000000Z","normalized_code":"39353BB"},{"id":17928331,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_violation_id":"271215373","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"211096506","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-17T10:43:59.000000Z","updated_at":"2026-01-25T10:32:04.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":17875657,"change_date":"2026-01-14 21:41:00","inspection_id":"86796686","insp_unit_id":"211096506","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"84299D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1FXPSA51055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-17T10:09:13.000000Z","updated_at":"2026-01-25T10:01:31.000000Z"}]},{"id":10802845,"change_date":"2026-01-19 21:34:00","inspection_id":"86829582","dot_number":"737814","report_state":"MN","report_number":"2690000755","insp_date":"2026-01-12 00:00:00","insp_start_time":"1007","insp_end_time":"1110","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"EAGAN MN","county_code_state":"MN","county_code":"037","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"7642850","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":"U","pen_cen_match":"I","final_status_date":"2026-01-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2785825","transaction_code":"A","transaction_date":"2026-01-18 00:00:00","upload_date":"2026-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-01-19 21:34:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-19 21:34:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-22T10:36:00.000000Z","updated_at":"2026-01-30T10:30:05.000000Z","inspection_violations":[{"id":18051804,"change_date":"2026-01-19 21:34:00","inspection_id":"86829582","insp_violation_id":"271282504","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDL","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":"2026-01-22T10:41:56.000000Z","updated_at":"2026-01-30T10:30:08.000000Z","normalized_code":"38323A2LCDL"},{"id":18051805,"change_date":"2026-01-19 21:34:00","inspection_id":"86829582","insp_violation_id":"271282505","seq_no":"2","part_no":"383","part_no_section":"95-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-22T10:41:56.000000Z","updated_at":"2026-01-30T10:30:08.000000Z","normalized_code":"38395LCDL"},{"id":18051806,"change_date":"2026-01-19 21:34:00","inspection_id":"86829582","insp_violation_id":"271282506","seq_no":"3","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882602690024","created_at":"2026-01-22T10:41:56.000000Z","updated_at":"2026-01-30T10:30:08.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":18137698,"change_date":"2026-01-19 21:34:00","inspection_id":"86829582","insp_unit_id":"211159526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"256734","insp_unit_license":"YBW4682","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HTMMMMLXKH356531","insp_unit_decal":"Y","insp_unit_decal_number":"36075153","created_at":"2026-01-24T10:08:08.000000Z","updated_at":"2026-01-30T10:00:06.000000Z"}]},{"id":10601844,"change_date":"2026-01-08 21:40:00","inspection_id":"86741245","dot_number":"737814","report_state":"CA","report_number":"NC9Y006889","insp_date":"2026-01-07 00:00:00","insp_start_time":"1051","insp_end_time":"1116","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"7639077","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16121912","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:47.000000Z","updated_at":"2026-01-19T10:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17773857,"change_date":"2026-01-08 21:40:00","inspection_id":"86741245","insp_unit_id":"210982998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT\/U6","insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"Y","insp_unit_decal_number":"35884356","created_at":"2026-01-11T10:06:15.000000Z","updated_at":"2026-01-19T10:01:08.000000Z"}]},{"id":10592141,"change_date":"2026-01-07 21:39:00","inspection_id":"86730986","dot_number":"737814","report_state":"CA","report_number":"UCW8001206","insp_date":"2026-01-06 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO IF S\/B","county_code_state":"CA","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","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":"2026-01-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"16119399","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-01-07 21:39:00","snet_input_date":"2026-01-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-01-07 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-10T10:34:43.000000Z","updated_at":"2026-01-18T10:32:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17755314,"change_date":"2026-01-07 21:39:00","inspection_id":"86730986","insp_unit_id":"210962797","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"84299D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1FXPSA51055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-10T10:06:13.000000Z","updated_at":"2026-01-18T10:01:45.000000Z"}]},{"id":10443302,"change_date":"2025-12-15 21:40:00","inspection_id":"86575479","dot_number":"737814","report_state":"CA","report_number":"UEW8000489","insp_date":"2025-12-12 00:00:00","insp_start_time":"1232","insp_end_time":"1239","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"3","service_center":"WE","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16094854","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-12-15 21:40:00","snet_input_date":"2025-12-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-15 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:50.000000Z","updated_at":"2025-12-26T10:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17470932,"change_date":"2025-12-15 21:40:00","inspection_id":"86575479","insp_unit_id":"210624386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHT","insp_unit_license":"84299D4","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1FXPSA51055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:41.000000Z","updated_at":"2025-12-26T10:01:39.000000Z"}]},{"id":10424662,"change_date":"2025-12-12 21:41:00","inspection_id":"86556018","dot_number":"737814","report_state":"CA","report_number":"NDE9008358","insp_date":"2025-12-08 00:00:00","insp_start_time":"0905","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"LEBEC","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DC.","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16092413","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-12-15T10:32:16.000000Z","updated_at":"2025-12-23T10:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17436481,"change_date":"2025-12-12 21:41:00","inspection_id":"86556018","insp_unit_id":"210586326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"16795U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:48.000000Z","updated_at":"2025-12-23T10:01:23.000000Z"}]},{"id":10380967,"change_date":"2025-12-08 21:39:00","inspection_id":"86510306","dot_number":"737814","report_state":"CA","report_number":"NCVH007570","insp_date":"2025-12-04 00:00:00","insp_start_time":"0631","insp_end_time":"0659","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"16086343","transaction_code":"A","transaction_date":"2025-12-06 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-12-08 21:39:00","snet_input_date":"2025-12-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-12-08 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-12-11T10:30:38.000000Z","updated_at":"2025-12-12T10:31:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17353215,"change_date":"2025-12-08 21:39:00","inspection_id":"86510306","insp_unit_id":"210484778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U15\/WHITE","insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-11T10:00:38.000000Z","updated_at":"2025-12-12T10:01:12.000000Z"}]},{"id":10183793,"change_date":"2025-11-12 21:41:00","inspection_id":"86303727","dot_number":"737814","report_state":"CA","report_number":"NEAH006082","insp_date":"2025-11-07 00:00:00","insp_start_time":"0928","insp_end_time":"0944","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"16055767","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-07 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-11-15T10:30:54.000000Z","updated_at":"2025-11-16T10:31:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16961442,"change_date":"2025-11-12 21:41:00","inspection_id":"86303727","insp_unit_id":"209990629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U14\/WHT","insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":"Y","insp_unit_decal_number":"35644137","created_at":"2025-11-15T10:00:46.000000Z","updated_at":"2025-11-16T10:02:02.000000Z"}]},{"id":10085932,"change_date":"2025-10-30 21:43:00","inspection_id":"86200726","dot_number":"737814","report_state":"CA","report_number":"UE68000960","insp_date":"2025-10-30 00:00:00","insp_start_time":"0600","insp_end_time":"0645","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"S\/B FORRESTER RD S\/OF MURPHY R","county_code_state":"CA","county_code":"025","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SAFEWAY\/ALBERTSONS","shipping_paper_number":"7598622","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-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16039710","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-10-30 21:43:00","snet_input_date":"2025-10-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-30 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:26.000000Z","updated_at":"2025-11-03T11:04:30.000000Z","inspection_violations":[{"id":16704226,"change_date":"2025-10-30 21:43:00","inspection_id":"86200726","insp_violation_id":"269635520","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RN42390","created_at":"2025-11-02T11:18:17.000000Z","updated_at":"2025-11-03T11:17:18.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":16766200,"change_date":"2025-10-30 21:43:00","inspection_id":"86200726","insp_unit_id":"209756904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"WHITE","insp_unit_license":"16795U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:43.000000Z","updated_at":"2025-11-03T10:47:02.000000Z"}]},{"id":9870201,"change_date":"2025-10-06 21:41:00","inspection_id":"85973163","dot_number":"737814","report_state":"CA","report_number":"N5Y3008206","insp_date":"2025-10-02 00:00:00","insp_start_time":"0605","insp_end_time":"0627","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"16007870","transaction_code":"A","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-10-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-10-09T10:00:58.000000Z","updated_at":"2025-10-10T10:01:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16371870,"change_date":"2025-10-06 21:41:00","inspection_id":"85973163","insp_unit_id":"209328197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U6\/WHI","insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"Y","insp_unit_decal_number":"35642675","created_at":"2025-10-09T09:45:54.000000Z","updated_at":"2025-10-10T09:47:16.000000Z"}]},{"id":9852697,"change_date":"2025-10-03 21:40:00","inspection_id":"85954600","dot_number":"737814","report_state":"CA","report_number":"N5Y3008179","insp_date":"2025-09-29 00:00:00","insp_start_time":"0546","insp_end_time":"0608","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"16005009","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-10-03 21:40:00","snet_input_date":"2025-09-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-10-03 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-10-05T10:02:26.000000Z","updated_at":"2025-10-08T10:01:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16340069,"change_date":"2025-10-03 21:40:00","inspection_id":"85954600","insp_unit_id":"209293601","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U6\/WHI","insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:19.000000Z","updated_at":"2025-10-08T09:46:36.000000Z"}]},{"id":9571348,"change_date":"2025-09-02 21:40:00","inspection_id":"85660100","dot_number":"737814","report_state":"CA","report_number":"NARW003699","insp_date":"2025-08-28 00:00:00","insp_start_time":"0914","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15962385","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-09-02 21:40:00","snet_input_date":"2025-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-09-06T10:43:07.000000Z","updated_at":"2025-09-06T10:43:07.000000Z","inspection_violations":[{"id":15634630,"change_date":"2025-09-02 21:40:00","inspection_id":"85660100","insp_violation_id":"268410969","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"208707134","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:38.000000Z","updated_at":"2025-09-06T10:47:38.000000Z","normalized_code":"3939ALHLI"},{"id":15634631,"change_date":"2025-09-02 21:40:00","inspection_id":"85660100","insp_violation_id":"268410970","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208707134","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:38.000000Z","updated_at":"2025-09-06T10:47:38.000000Z","normalized_code":"3922SLLSR"},{"id":15634632,"change_date":"2025-09-02 21:40:00","inspection_id":"85660100","insp_violation_id":"268410971","seq_no":"3","part_no":"392","part_no_section":"2-SLTFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"RJ01096","created_at":"2025-09-06T10:47:38.000000Z","updated_at":"2025-09-06T10:47:38.000000Z","normalized_code":"3922SLTFC"}],"inspection_per_units":[{"id":15799354,"change_date":"2025-09-02 21:40:00","inspection_id":"85660100","insp_unit_id":"208707134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U6\/WHT2X","insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:20.000000Z","updated_at":"2025-09-09T09:47:20.000000Z"}]},{"id":9659797,"change_date":"2025-09-12 21:50:00","inspection_id":"85752205","dot_number":"737814","report_state":"CA","report_number":"NE2Z005147","insp_date":"2025-08-28 00:00:00","insp_start_time":"1305","insp_end_time":"1355","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"WB PERALTA SCALE","county_code_state":"CA","county_code":"059","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15975064","transaction_code":"C","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-09-11 21:42:00","snet_input_date":"2025-08-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-11 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"386457","created_at":"2025-09-13T10:48:08.000000Z","updated_at":"2025-09-16T10:48:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16000758,"change_date":"2025-09-12 21:50:00","inspection_id":"85752205","insp_unit_id":"208927566","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"01500M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF6AN7NDF10374","insp_unit_decal":"Y","insp_unit_decal_number":"35364212","created_at":"2025-09-15T09:54:02.000000Z","updated_at":"2025-09-16T09:56:30.000000Z"}]},{"id":9346749,"change_date":"2025-08-06 21:40:00","inspection_id":"85423607","dot_number":"737814","report_state":"CA","report_number":"UD40001030","insp_date":"2025-08-05 00:00:00","insp_start_time":"0715","insp_end_time":"0742","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"U.S. 101 S\/B AT CONEJO C.V.E.F","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15927461","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-08-12T10:42:24.000000Z","updated_at":"2025-08-12T10:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15396151,"change_date":"2025-08-06 21:40:00","inspection_id":"85423607","insp_unit_id":"208271241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U9","insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":"Y","insp_unit_decal_number":"35366626","created_at":"2025-08-09T09:46:23.000000Z","updated_at":"2025-08-10T09:46:11.000000Z"}]},{"id":9346751,"change_date":"2025-08-06 21:40:00","inspection_id":"85423609","dot_number":"737814","report_state":"CA","report_number":"UD40001032","insp_date":"2025-08-05 00:00:00","insp_start_time":"0720","insp_end_time":"0750","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"U.S. 101 S\/B AT CONEJO C.V.E.F","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTION","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15927465","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"737814","created_at":"2025-08-12T10:42:24.000000Z","updated_at":"2025-08-12T10:42:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15396153,"change_date":"2025-08-06 21:40:00","inspection_id":"85423609","insp_unit_id":"208271243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U9","insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:23.000000Z","updated_at":"2025-08-10T09:46:11.000000Z"}]},{"id":9287822,"change_date":"2025-07-30 21:40:00","inspection_id":"85361632","dot_number":"737814","report_state":"KS","report_number":"KC82260219","insp_date":"2025-07-28 00:00:00","insp_start_time":"1109","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"SEWARD COUNTY","county_code_state":"KS","county_code":"175","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY","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-07-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132500","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":"1369575","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-28 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:14.000000Z","updated_at":"2025-08-04T10:01:14.000000Z","inspection_violations":[{"id":15057602,"change_date":"2025-07-30 21:40:00","inspection_id":"85361632","insp_violation_id":"267745101","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"208158369","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-02T10:43:40.000000Z","updated_at":"2025-08-03T10:44:08.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15291515,"change_date":"2025-07-30 21:40:00","inspection_id":"85361632","insp_unit_id":"208158368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"422","insp_unit_license":"PZA7665","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR9MSMH8791","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:26.000000Z","updated_at":"2025-08-03T09:45:54.000000Z"},{"id":15291516,"change_date":"2025-07-30 21:40:00","inspection_id":"85361632","insp_unit_id":"208158369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WELDS","insp_unit_company":null,"insp_unit_license":"3568STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1W9GJ43217B355812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:26.000000Z","updated_at":"2025-08-03T09:45:54.000000Z"}]},{"id":11397366,"change_date":"2026-03-17 21:39:00","inspection_id":"87312264","dot_number":"737814","report_state":"NM","report_number":"3064P5PP9D","insp_date":"2025-07-24 00:00:00","insp_start_time":"1839","insp_end_time":"1917","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"IACX HELIUM","shipping_paper_number":"19812","cargo_tank":"OTH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"2272636","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-17 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:34.000000Z","updated_at":"2026-03-28T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19519214,"change_date":"2026-03-17 21:39:00","inspection_id":"87312264","insp_unit_id":"212180216","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 422","insp_unit_license":"PZA7665","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3QAKJHHDR9MSMH879","insp_unit_decal":"Y","insp_unit_decal_number":"35446142","created_at":"2026-03-20T09:19:26.000000Z","updated_at":"2026-03-28T09:05:18.000000Z"},{"id":19519215,"change_date":"2026-03-17 21:39:00","inspection_id":"87312264","insp_unit_id":"212180217","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WELDSHIP","insp_unit_company":"UNIT 00","insp_unit_license":"3568STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1W9GJ43217B355812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:26.000000Z","updated_at":"2026-03-28T09:05:18.000000Z"}]},{"id":9228314,"change_date":"2025-07-23 21:42:00","inspection_id":"85299034","dot_number":"737814","report_state":"CA","report_number":"NF35000861","insp_date":"2025-07-22 00:00:00","insp_start_time":"1313","insp_end_time":"1335","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE NB IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"MIS0002334","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-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15911152","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:39.000000Z","updated_at":"2025-07-27T10:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15183218,"change_date":"2025-07-23 21:42:00","inspection_id":"85299034","insp_unit_id":"208041758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U5\/WHT","insp_unit_license":"51618S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W169K7K00648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-26T09:46:33.000000Z","updated_at":"2025-07-27T09:46:19.000000Z"}]},{"id":9168515,"change_date":"2025-07-16 21:41:00","inspection_id":"85235965","dot_number":"737814","report_state":"CA","report_number":"NAGM010297","insp_date":"2025-07-08 00:00:00","insp_start_time":"0929","insp_end_time":"0957","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15900312","transaction_code":"A","transaction_date":"2025-07-08 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-07-16 21:41:00","snet_input_date":"2025-07-08 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:44.000000Z","updated_at":"2025-07-21T10:42:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15062061,"change_date":"2025-07-16 21:41:00","inspection_id":"85235965","insp_unit_id":"207910781","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U14\/WHT","insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":"Y","insp_unit_decal_number":"35368040","created_at":"2025-07-19T09:46:21.000000Z","updated_at":"2025-07-20T09:46:14.000000Z"}]},{"id":8994922,"change_date":"2025-06-26 21:41:00","inspection_id":"85053596","dot_number":"737814","report_state":"CA","report_number":"NAGM010220","insp_date":"2025-06-23 00:00:00","insp_start_time":"0827","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","shipping_paper_number":"96747U3","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15865179","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-06-26 21:41:00","snet_input_date":"2025-06-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-06-26 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:02.000000Z","updated_at":"2025-06-30T10:01:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14751948,"change_date":"2025-06-26 21:41:00","inspection_id":"85053596","insp_unit_id":"207574747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U14\/WHT","insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:19.000000Z","updated_at":"2025-07-01T09:47:47.000000Z"}]},{"id":8782875,"change_date":"2025-05-30 21:41:00","inspection_id":"84828532","dot_number":"737814","report_state":"CA","report_number":"UFV3004089","insp_date":"2025-05-29 00:00:00","insp_start_time":"0654","insp_end_time":"0715","registration_date":null,"region":"PT","ci_status_code":"C","location":"859","location_desc":"CAJON SCALES","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15842888","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-05-30 21:41:00","snet_input_date":"2025-05-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-05-30 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-06-04T10:01:12.000000Z","updated_at":"2025-06-04T10:01:12.000000Z","inspection_violations":[{"id":14041365,"change_date":"2025-05-30 21:41:00","inspection_id":"84828532","insp_violation_id":"266586042","seq_no":"1","part_no":"172","part_no_section":"516C6-HMPMC","insp_viol_unit":"1","insp_unit_id":"207158074","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:28.000000Z","updated_at":"2025-06-03T10:18:05.000000Z","normalized_code":"172516C6HMPMC"}],"inspection_per_units":[{"id":14370155,"change_date":"2025-05-30 21:41:00","inspection_id":"84828532","insp_unit_id":"207158074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U5\/WHT","insp_unit_license":"51618S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W169K7K00648","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:25.000000Z","updated_at":"2025-06-03T09:46:13.000000Z"}]},{"id":8407712,"change_date":"2025-04-17 21:42:00","inspection_id":"84432987","dot_number":"737814","report_state":"CA","report_number":"ND6D006793","insp_date":"2025-04-17 00:00:00","insp_start_time":"0456","insp_end_time":"0525","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY INC","shipping_paper_number":"01","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15784212","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-17 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-04-20T10:28:47.000000Z","updated_at":"2025-04-21T10:24:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13649666,"change_date":"2025-04-17 21:42:00","inspection_id":"84432987","insp_unit_id":"206373314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"U12","insp_unit_license":"16795U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":"Y","insp_unit_decal_number":"35074709","created_at":"2025-04-20T10:19:54.000000Z","updated_at":"2025-04-21T10:08:40.000000Z"}]},{"id":8346781,"change_date":"2025-04-10 21:42:00","inspection_id":"84368765","dot_number":"737814","report_state":"CA","report_number":"NEAH005005","insp_date":"2025-04-09 00:00:00","insp_start_time":"0737","insp_end_time":"0809","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7407945","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15774463","transaction_code":"A","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-04-10 21:42:00","snet_input_date":"2025-04-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-10 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-04-14T10:28:42.000000Z","updated_at":"2025-04-14T10:28:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18648252,"change_date":null,"inspection_id":"84368765","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":null,"insp_unit_decal_number":"35090221","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8269528,"change_date":"2025-04-01 21:41:00","inspection_id":"84287452","dot_number":"737814","report_state":"CA","report_number":"ND6S008080","insp_date":"2025-03-20 00:00:00","insp_start_time":"1225","insp_end_time":"1251","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"W\/B ANTELOPE SCALES","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15761341","transaction_code":"A","transaction_date":"2025-03-20 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-04-01 21:41:00","snet_input_date":"2025-03-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-04-01 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-04-04T10:21:39.000000Z","updated_at":"2025-04-06T10:22:37.000000Z","inspection_violations":[{"id":18445009,"change_date":null,"inspection_id":"84287452","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18647246,"change_date":null,"inspection_id":"84287452","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"34763101","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7948476,"change_date":"2025-02-24 21:40:00","inspection_id":"83949672","dot_number":"737814","report_state":"CA","report_number":"UDFL000354","insp_date":"2025-02-21 00:00:00","insp_start_time":"0815","insp_end_time":"0850","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"US-101 S\/B CONEJO CVEF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"7368575","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15713496","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-02-24 21:40:00","snet_input_date":"2025-02-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-24 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T21:03:15.000000Z","updated_at":"2025-03-17T21:03:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18643016,"change_date":null,"inspection_id":"83949672","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":null,"insp_unit_decal_number":"34818849","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7933782,"change_date":"2025-02-21 21:41:00","inspection_id":"83934241","dot_number":"737814","report_state":"CA","report_number":"UEED002924","insp_date":"2025-02-20 00:00:00","insp_start_time":"1045","insp_end_time":"1101","registration_date":null,"region":"PT","ci_status_code":"C","location":"301","location_desc":"NB SCALES (WALNUT CREEK)","county_code_state":"CA","county_code":"013","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15711789","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-02-21 21:41:00","snet_input_date":"2025-02-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-21 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:51.000000Z","updated_at":"2025-03-17T21:02:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18720535,"change_date":null,"inspection_id":"83934241","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"34764129","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7913457,"change_date":"2025-02-19 21:41:00","inspection_id":"83912977","dot_number":"737814","report_state":"CA","report_number":"NF35000492","insp_date":"2025-02-18 00:00:00","insp_start_time":"1118","insp_end_time":"1143","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE NB IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER MATERIALS","shipping_paper_number":"MIS0002334","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15708192","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-02-19 21:41:00","snet_input_date":"2025-02-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-19 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:24.000000Z","updated_at":"2025-03-17T21:02:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18642585,"change_date":null,"inspection_id":"83912977","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":null,"insp_unit_decal_number":"34808533","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7741611,"change_date":"2025-01-29 21:41:00","inspection_id":"83732297","dot_number":"737814","report_state":"CA","report_number":"UEGX001287","insp_date":"2025-01-29 00:00:00","insp_start_time":"0410","insp_end_time":"0440","registration_date":null,"region":"PT","ci_status_code":"C","location":"365","location_desc":"I-80 E\/B JEO CORDELIA SCALES","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAYFLOWER","shipping_paper_number":"MIS0002334","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":"Y","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":"16000","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":"15683166","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-01-29 21:41:00","snet_input_date":"2025-01-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:59:06.000000Z","updated_at":"2025-03-17T20:59:06.000000Z","inspection_violations":[{"id":18436429,"change_date":null,"inspection_id":"83732297","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18718079,"change_date":null,"inspection_id":"83732297","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7495663,"change_date":"2024-12-24 21:35:00","inspection_id":"83474250","dot_number":"737814","report_state":"CA","report_number":"UCB4000655","insp_date":"2024-12-23 00:00:00","insp_start_time":"0625","insp_end_time":"0655","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"N\/B US-101 CONEJO IF","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"73173395","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-24 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15640608","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-12-24 21:35:00","snet_input_date":"2024-12-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-24 21:35:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:52:21.000000Z","updated_at":"2025-03-17T20:52:21.000000Z","inspection_violations":[{"id":18432525,"change_date":null,"inspection_id":"83474250","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393201BFR"}],"inspection_per_units":[{"id":18636876,"change_date":null,"inspection_id":"83474250","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7347529,"change_date":"2024-12-05 21:38:00","inspection_id":"83318576","dot_number":"737814","report_state":"CA","report_number":"NCZ2001600","insp_date":"2024-12-05 00:00:00","insp_start_time":"1015","insp_end_time":"1059","registration_date":null,"region":"PT","ci_status_code":"C","location":"250","location_desc":"W\/B ANTELOPE IF","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","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":"2024-12-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15618582","transaction_code":"A","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-12-05 21:38:00","snet_input_date":"2024-12-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-12-05 21:38:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:49:23.000000Z","updated_at":"2025-03-17T20:49:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18712560,"change_date":null,"inspection_id":"83318576","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"34463852","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7309497,"change_date":"2024-11-30 21:33:00","inspection_id":"83278503","dot_number":"737814","report_state":"CA","report_number":"NC7K009412","insp_date":"2024-11-26 00:00:00","insp_start_time":"1027","insp_end_time":"1052","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING CO.","shipping_paper_number":"7324210","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-11-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15612349","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-11-30 21:33:00","snet_input_date":"2024-11-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-11-30 21:33:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:34.000000Z","updated_at":"2025-03-17T20:48:34.000000Z","inspection_violations":[{"id":18429813,"change_date":null,"inspection_id":"83278503","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"201D-HMSPS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172201DHMSPS"}],"inspection_per_units":[{"id":18634372,"change_date":null,"inspection_id":"83278503","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7050694,"change_date":"2024-10-25 21:41:00","inspection_id":"83004678","dot_number":"737814","report_state":"CA","report_number":"UCJN000301","insp_date":"2024-10-24 00:00:00","insp_start_time":"1150","insp_end_time":"1213","registration_date":null,"region":"PT","ci_status_code":"C","location":"891","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY INC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"15571840","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-10-25 21:41:00","snet_input_date":"2024-10-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-25 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:43:02.000000Z","updated_at":"2025-03-17T20:43:02.000000Z","inspection_violations":[{"id":18425407,"change_date":null,"inspection_id":"83004678","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":18630783,"change_date":null,"inspection_id":"83004678","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"16794U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1FXPSA51055","insp_unit_decal":null,"insp_unit_decal_number":"34483601","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7016869,"change_date":"2024-10-22 21:42:00","inspection_id":"82968735","dot_number":"737814","report_state":"CA","report_number":"NCCL006204","insp_date":"2024-10-18 00:00:00","insp_start_time":"1055","insp_end_time":"1115","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY INC","shipping_paper_number":"MAYFLOWER DISTR","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15564872","transaction_code":"A","transaction_date":"2024-10-18 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18707998,"change_date":null,"inspection_id":"82968735","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6855814,"change_date":"2024-09-30 21:41:00","inspection_id":"82797458","dot_number":"737814","report_state":"CA","report_number":"NCEB007287","insp_date":"2024-09-27 00:00:00","insp_start_time":"0801","insp_end_time":"0816","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7290851","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15538918","transaction_code":"A","transaction_date":"2024-09-27 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18705756,"change_date":null,"inspection_id":"82797458","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70798V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S160LSG50203","insp_unit_decal":null,"insp_unit_decal_number":"24204581","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6714795,"change_date":"2024-09-12 21:42:00","inspection_id":"82647318","dot_number":"737814","report_state":"CA","report_number":"NDMK005626","insp_date":"2024-09-10 00:00:00","insp_start_time":"0524","insp_end_time":"0550","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15519800","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:36:07.000000Z","updated_at":"2025-03-17T20:36:07.000000Z","inspection_violations":[{"id":18419316,"change_date":null,"inspection_id":"82647318","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":18626202,"change_date":null,"inspection_id":"82647318","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"34157640","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6650033,"change_date":"2024-09-04 21:43:00","inspection_id":"82578465","dot_number":"737814","report_state":"CA","report_number":"UCYO000599","insp_date":"2024-09-04 00:00:00","insp_start_time":"0900","insp_end_time":"0947","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7281400","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15510173","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-09-04 21:43:00","snet_input_date":"2024-09-04 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-04 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:34:51.000000Z","updated_at":"2025-03-17T20:34:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18625353,"change_date":null,"inspection_id":"82578465","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"91633G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00564","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6638060,"change_date":"2024-09-04 21:43:00","inspection_id":"82565709","dot_number":"737814","report_state":"CA","report_number":"UEGX000810","insp_date":"2024-09-03 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"PT","ci_status_code":"C","location":"320","location_desc":"WALNUT CRK PLTFM SCALES","county_code_state":"CA","county_code":"013","insp_level_id":"3","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-03 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15507259","transaction_code":"C","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-09-03 21:43:00","snet_input_date":"2024-09-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-09-03 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:34:30.000000Z","updated_at":"2025-03-17T20:34:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18625173,"change_date":null,"inspection_id":"82565709","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7842687,"change_date":"2025-11-18 21:38:00","inspection_id":"83838847","dot_number":"737814","report_state":"NM","report_number":"3066O6JGQS","insp_date":"2024-08-22 00:00:00","insp_start_time":"1239","insp_end_time":"1326","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY","shipping_paper_number":"0002334","cargo_tank":"NON","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"2150014","transaction_code":"C","transaction_date":"2025-02-10 00:00:00","upload_date":"2025-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-11 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:09.000000Z","updated_at":"2025-11-23T10:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17033955,"change_date":"2025-11-18 21:38:00","inspection_id":"83838847","insp_unit_id":"210100393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT T401","insp_unit_license":"PZA7664","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR0MSMH8694","insp_unit_decal":"Y","insp_unit_decal_number":"34277384","created_at":"2025-11-21T10:01:47.000000Z","updated_at":"2025-11-23T10:00:05.000000Z"},{"id":17033956,"change_date":"2025-11-18 21:38:00","inspection_id":"83838847","insp_unit_id":"210100394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WELD","insp_unit_company":"UNIT 191135","insp_unit_license":"STB0911","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1W9GJ4327PB355135","insp_unit_decal":"Y","insp_unit_decal_number":"34277383","created_at":"2025-11-21T10:01:47.000000Z","updated_at":"2025-11-23T10:00:05.000000Z"}]},{"id":6541454,"change_date":"2024-08-22 21:43:00","inspection_id":"82462736","dot_number":"737814","report_state":"CA","report_number":"NBH6005866","insp_date":"2024-08-21 00:00:00","insp_start_time":"0524","insp_end_time":"0547","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15492733","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-08-22 21:43:00","snet_input_date":"2024-08-21 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:45.000000Z","updated_at":"2025-03-17T20:32:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18701523,"change_date":null,"inspection_id":"82462736","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6526736,"change_date":"2024-08-21 21:42:00","inspection_id":"82447076","dot_number":"737814","report_state":"NM","report_number":"6592O6HGJ2","insp_date":"2024-08-20 00:00:00","insp_start_time":"1245","insp_end_time":"1325","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON N ROSWELL RELIEF ROUTE 184","county_code_state":"NM","county_code":"005","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"2111086","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-08-21 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-08-21 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:20.000000Z","updated_at":"2025-03-17T20:32:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18701322,"change_date":null,"inspection_id":"82447076","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PZA7665","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR9MSMH8791","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18781650,"change_date":null,"inspection_id":"82447076","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HELIUM TR","insp_unit_company":null,"insp_unit_license":"8183STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"S2DACBTUXP4411367","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6299435,"change_date":"2024-07-24 21:42:00","inspection_id":"82204260","dot_number":"737814","report_state":"KS","report_number":"KC82090420","insp_date":"2024-07-23 00:00:00","insp_start_time":"1220","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"#37","location_desc":"LIBERAL M.C.I.S. #37A","county_code_state":"KS","county_code":"175","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY","shipping_paper_number":"MIS0002334","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-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"112500","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":"1332294","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:27.000000Z","updated_at":"2025-03-17T20:27:27.000000Z","inspection_violations":[{"id":18411458,"change_date":null,"inspection_id":"82204260","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18411459,"change_date":null,"inspection_id":"82204260","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":18698268,"change_date":null,"inspection_id":"82204260","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PZA7664","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR0MSMH8694","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18778316,"change_date":null,"inspection_id":"82204260","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"TEXA","insp_unit_company":null,"insp_unit_license":"3585STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"SW84752PA","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7787256,"change_date":"2025-02-04 21:40:00","inspection_id":"83780595","dot_number":"737814","report_state":"CA","report_number":"NCGL004125","insp_date":"2024-07-15 00:00:00","insp_start_time":"0700","insp_end_time":"0729","registration_date":null,"region":"PT","ci_status_code":"C","location":"881","location_desc":"PERALTA SCALES W\/B","county_code_state":"CA","county_code":"059","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15690600","transaction_code":"A","transaction_date":"2024-07-15 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2025-02-04 21:40:00","snet_input_date":"2024-07-15 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-02-04 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:59:54.000000Z","updated_at":"2025-03-17T20:59:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18640992,"change_date":null,"inspection_id":"83780595","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"167995U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":null,"insp_unit_decal_number":"34191597","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6097918,"change_date":"2024-06-28 21:40:00","inspection_id":"81987941","dot_number":"737814","report_state":"CA","report_number":"UEX8003883","insp_date":"2024-06-24 00:00:00","insp_start_time":"0540","insp_end_time":"0605","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"7239106P","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15422751","transaction_code":"C","transaction_date":"2024-06-24 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-27 21:41:00","snet_input_date":"2024-06-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:25.000000Z","updated_at":"2025-03-17T20:23:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18617854,"change_date":null,"inspection_id":"81987941","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6049807,"change_date":"2024-06-21 21:40:00","inspection_id":"81936114","dot_number":"737814","report_state":"CA","report_number":"UD40000784","insp_date":"2024-06-20 00:00:00","insp_start_time":"0820","insp_end_time":"0834","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO IF","county_code_state":"CA","county_code":"111","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING INC.","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15414332","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-21 21:40:00","snet_input_date":"2024-06-20 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-21 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:22:37.000000Z","updated_at":"2025-03-17T20:22:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18617165,"change_date":null,"inspection_id":"81936114","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"01500M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF6AN7NDF10374","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5978375,"change_date":"2024-06-12 21:43:00","inspection_id":"81858979","dot_number":"737814","report_state":"CA","report_number":"UE48000426","insp_date":"2024-06-12 00:00:00","insp_start_time":"1210","insp_end_time":"1230","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"V15","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15400020","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-12 21:43:00","snet_input_date":"2024-06-12 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18693786,"change_date":null,"inspection_id":"81858979","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96744U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W165P7K02341","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5976976,"change_date":"2024-06-12 21:42:00","inspection_id":"81857503","dot_number":"737814","report_state":"CA","report_number":"NBIJ005430","insp_date":"2024-06-11 00:00:00","insp_start_time":"0525","insp_end_time":"0544","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST.","shipping_paper_number":"7236131","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15398774","transaction_code":"A","transaction_date":"2024-06-11 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:21:07.000000Z","updated_at":"2025-03-17T20:21:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18693755,"change_date":null,"inspection_id":"81857503","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"33817974","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5955871,"change_date":"2024-06-10 21:44:00","inspection_id":"81834345","dot_number":"737814","report_state":"CA","report_number":"UF54000953","insp_date":"2024-06-10 00:00:00","insp_start_time":"0610","insp_end_time":"0650","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-10 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15397041","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-10 21:44:00","snet_input_date":"2024-06-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-10 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:42.000000Z","updated_at":"2025-03-17T20:20:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18693419,"change_date":null,"inspection_id":"81834345","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"51618S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W169K7K00648","insp_unit_decal":null,"insp_unit_decal_number":"33851875","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5988448,"change_date":"2024-07-16 21:44:00","inspection_id":"81869938","dot_number":"737814","report_state":"CA","report_number":"NCAT004271","insp_date":"2024-06-05 00:00:00","insp_start_time":"1441","insp_end_time":"1507","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTION","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15401874","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:21:28.000000Z","updated_at":"2025-03-17T20:21:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18616233,"change_date":null,"inspection_id":"81869938","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"33879683","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5758628,"change_date":"2024-05-15 21:44:00","inspection_id":"81620511","dot_number":"737814","report_state":"CA","report_number":"NCVL006346","insp_date":"2024-05-10 00:00:00","insp_start_time":"0750","insp_end_time":"0840","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY INC","shipping_paper_number":"7205229P","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15363061","transaction_code":"A","transaction_date":"2024-05-10 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-05-15 21:44:00","snet_input_date":"2024-05-10 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-15 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:16:44.000000Z","updated_at":"2025-03-17T20:16:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18690509,"change_date":null,"inspection_id":"81620511","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":null,"insp_unit_decal_number":"33825610","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5691731,"change_date":"2024-05-07 21:43:00","inspection_id":"81547936","dot_number":"737814","report_state":"CA","report_number":"NBBJ005781","insp_date":"2024-05-06 00:00:00","insp_start_time":"1138","insp_end_time":"1159","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY","shipping_paper_number":"7205246","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15350249","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-05-07 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-05-07 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:15:30.000000Z","updated_at":"2025-03-17T20:15:30.000000Z","inspection_violations":[{"id":18399444,"change_date":null,"inspection_id":"81547936","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393207A"},{"id":18399445,"change_date":null,"inspection_id":"81547936","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18399446,"change_date":null,"inspection_id":"81547936","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":18689548,"change_date":null,"inspection_id":"81547936","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5601300,"change_date":"2024-04-25 21:43:00","inspection_id":"81449374","dot_number":"737814","report_state":"CA","report_number":"UE7D002074","insp_date":"2024-04-25 00:00:00","insp_start_time":"0947","insp_end_time":"0959","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"SIERRA COLLEDGE AT OLD AUBURN","county_code_state":"CA","county_code":"061","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15335635","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18688198,"change_date":null,"inspection_id":"81449374","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5602726,"change_date":"2024-04-25 21:43:00","inspection_id":"81450880","dot_number":"737814","report_state":"CA","report_number":"ND6D005626","insp_date":"2024-04-23 00:00:00","insp_start_time":"0810","insp_end_time":"0834","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"412","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15334735","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:13:50.000000Z","updated_at":"2025-03-17T20:13:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18688215,"change_date":null,"inspection_id":"81450880","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"16795U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F1PSA51056","insp_unit_decal":null,"insp_unit_decal_number":"33823500","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5625272,"change_date":"2024-04-29 21:44:00","inspection_id":"81475733","dot_number":"737814","report_state":"CA","report_number":"NARW002264","insp_date":"2024-04-23 00:00:00","insp_start_time":"1120","insp_end_time":"1135","registration_date":null,"region":"PT","ci_status_code":"C","location":"347","location_desc":"NIMITZ IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15339226","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-29 21:44:00","snet_input_date":"2024-04-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-29 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:14:16.000000Z","updated_at":"2025-03-17T20:14:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18610980,"change_date":null,"inspection_id":"81475733","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5570367,"change_date":"2024-04-22 21:41:00","inspection_id":"81415653","dot_number":"737814","report_state":"CA","report_number":"UE1B001009","insp_date":"2024-04-22 00:00:00","insp_start_time":"0550","insp_end_time":"0607","registration_date":null,"region":"PT","ci_status_code":"C","location":"310","location_desc":"N\/B MARIN SCALES","county_code_state":"CA","county_code":"041","insp_level_id":"2","service_center":"WE","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":"2024-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15328568","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-22 21:41:00","snet_input_date":"2024-04-22 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-22 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:13:08.000000Z","updated_at":"2025-03-17T20:13:08.000000Z","inspection_violations":[{"id":18396774,"change_date":null,"inspection_id":"81415653","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18687774,"change_date":null,"inspection_id":"81415653","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5463229,"change_date":"2024-04-08 21:44:00","inspection_id":"81298608","dot_number":"737814","report_state":"CA","report_number":"NAGM008391","insp_date":"2024-04-05 00:00:00","insp_start_time":"0810","insp_end_time":"0832","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CVS","shipping_paper_number":"7198307","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-08 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15309163","transaction_code":"A","transaction_date":"2024-04-05 00:00:00","upload_date":"2024-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-08 21:44:00","snet_input_date":"2024-04-05 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-08 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:08.000000Z","updated_at":"2025-03-17T20:11:08.000000Z","inspection_violations":[{"id":18394608,"change_date":null,"inspection_id":"81298608","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":18686239,"change_date":null,"inspection_id":"81298608","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"33860023","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5439536,"change_date":"2024-04-04 21:43:00","inspection_id":"81272812","dot_number":"737814","report_state":"CA","report_number":"ND6D005546","insp_date":"2024-03-29 00:00:00","insp_start_time":"0913","insp_end_time":"0933","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15304657","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-04-04 21:43:00","snet_input_date":"2024-03-29 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-04-04 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"3368457","created_at":"2025-03-17T20:10:20.000000Z","updated_at":"2025-03-17T20:10:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18685939,"change_date":null,"inspection_id":"81272812","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"01500M3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"1FDNF6AN7NDF10374","insp_unit_decal":null,"insp_unit_decal_number":"33540079","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5270088,"change_date":"2024-03-12 21:39:00","inspection_id":"81087982","dot_number":"737814","report_state":"CA","report_number":"NCNY006603","insp_date":"2024-03-11 00:00:00","insp_start_time":"0908","insp_end_time":"0922","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"15277584","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-03-12 21:39:00","snet_input_date":"2024-03-11 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:07:05.000000Z","updated_at":"2025-03-17T20:07:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18605870,"change_date":null,"inspection_id":"81087982","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"33535010","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5168645,"change_date":"2024-02-28 21:43:00","inspection_id":"80977008","dot_number":"737814","report_state":"CA","report_number":"UFA3001265","insp_date":"2024-02-19 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"PT","ci_status_code":"C","location":"882","location_desc":"WB ANTELPOPE SCALE","county_code_state":"CA","county_code":"067","insp_level_id":"2","service_center":"WE","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":"2024-02-28 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15256095","transaction_code":"A","transaction_date":"2024-02-19 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-02-28 21:43:00","snet_input_date":"2024-02-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:04:57.000000Z","updated_at":"2025-03-17T20:04:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18604411,"change_date":null,"inspection_id":"80977008","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5075296,"change_date":"2024-02-16 21:42:00","inspection_id":"80875747","dot_number":"737814","report_state":"CA","report_number":"NCVH005342","insp_date":"2024-02-13 00:00:00","insp_start_time":"0620","insp_end_time":"0659","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15240233","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-02-16 21:42:00","snet_input_date":"2024-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-16 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:03:07.000000Z","updated_at":"2025-03-17T20:03:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18603102,"change_date":null,"inspection_id":"80875747","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"51618S2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W169K7K00648","insp_unit_decal":null,"insp_unit_decal_number":"33557358","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5094560,"change_date":"2024-02-20 21:43:00","inspection_id":"80896667","dot_number":"737814","report_state":"CA","report_number":"ND6D005414","insp_date":"2024-02-13 00:00:00","insp_start_time":"0837","insp_end_time":"0905","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"V3","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15241136","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-02-20 21:43:00","snet_input_date":"2024-02-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-20 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:03:30.000000Z","updated_at":"2025-03-17T20:03:30.000000Z","inspection_violations":[{"id":18387684,"change_date":null,"inspection_id":"80896667","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39375A3"},{"id":18387685,"change_date":null,"inspection_id":"80896667","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3958"}],"inspection_per_units":[{"id":18603350,"change_date":null,"inspection_id":"80896667","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"91633G3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00564","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4912617,"change_date":"2024-01-26 21:40:00","inspection_id":"80697604","dot_number":"737814","report_state":"CA","report_number":"UCX0001848","insp_date":"2024-01-26 00:00:00","insp_start_time":"1105","insp_end_time":"1138","registration_date":null,"region":"PT","ci_status_code":"C","location":"651","location_desc":"SAN ONOFRE IF","county_code_state":"CA","county_code":"073","insp_level_id":"1","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15214910","transaction_code":"A","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-01-26 21:40:00","snet_input_date":"2024-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-26 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:00:03.000000Z","updated_at":"2025-03-17T20:00:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18600679,"change_date":null,"inspection_id":"80697604","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96746U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S1F3PSA51057","insp_unit_decal":null,"insp_unit_decal_number":"33558650","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5160616,"change_date":"2024-02-28 21:42:00","inspection_id":"80968622","dot_number":"737814","report_state":"CA","report_number":"NBIJ005012","insp_date":"2024-01-26 00:00:00","insp_start_time":"0543","insp_end_time":"0640","registration_date":null,"region":"PT","ci_status_code":"C","location":"366","location_desc":"CORDELIA IF","county_code_state":"CA","county_code":"095","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7141830","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"15251053","transaction_code":"A","transaction_date":"2024-01-26 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-01-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T20:04:55.000000Z","updated_at":"2025-03-17T20:04:55.000000Z","inspection_violations":[{"id":18389033,"change_date":null,"inspection_id":"80968622","insp_violation_id":null,"seq_no":null,"part_no":"397","part_no_section":"3","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3973"}],"inspection_per_units":[{"id":18604301,"change_date":null,"inspection_id":"80968622","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"82179S1","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W166F7K00385","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4879557,"change_date":"2024-01-22 21:44:00","inspection_id":"80661486","dot_number":"737814","report_state":"CA","report_number":"UCZF002496","insp_date":"2024-01-19 00:00:00","insp_start_time":"1145","insp_end_time":"1245","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"ANAHEIM","county_code_state":"CA","county_code":"059","insp_level_id":"2","service_center":"WE","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-01-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"15208885","transaction_code":"A","transaction_date":"2024-01-19 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:17.000000Z","updated_at":"2025-03-17T19:59:17.000000Z","inspection_violations":[{"id":18383645,"change_date":null,"inspection_id":"80661486","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172203A"}],"inspection_per_units":[{"id":18677973,"change_date":null,"inspection_id":"80661486","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PZA7664","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"3AKJHHDR0MSMH8694","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"},{"id":18756009,"change_date":null,"inspection_id":"80661486","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"SCHA","insp_unit_company":null,"insp_unit_license":"8183STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"S2DACBTUXP4411367","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4888328,"change_date":"2024-01-23 21:45:00","inspection_id":"80671120","dot_number":"737814","report_state":"CA","report_number":"ND6D005326","insp_date":"2024-01-19 00:00:00","insp_start_time":"0750","insp_end_time":"0829","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7153049","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-23 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15209694","transaction_code":"A","transaction_date":"2024-01-19 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-01-23 21:45:00","snet_input_date":"2024-01-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-23 21:45:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:59:37.000000Z","updated_at":"2025-03-17T19:59:37.000000Z","inspection_violations":[{"id":18383798,"change_date":null,"inspection_id":"80671120","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18383799,"change_date":null,"inspection_id":"80671120","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"},{"id":18383800,"change_date":null,"inspection_id":"80671120","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3958"},{"id":18383801,"change_date":null,"inspection_id":"80671120","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":18600352,"change_date":null,"inspection_id":"80671120","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"70797V2","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"54DK6S162LSG50204","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4869556,"change_date":"2024-01-19 21:44:00","inspection_id":"80650603","dot_number":"737814","report_state":"CA","report_number":"UDI1001930","insp_date":"2024-01-18 00:00:00","insp_start_time":"0910","insp_end_time":"0940","registration_date":null,"region":"PT","ci_status_code":"C","location":"211","location_desc":"ANTELOPE PLATFORM SCALE WB","county_code_state":"CA","county_code":"067","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"7136224","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-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"15206886","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2024-01-19 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"4CAS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:59:14.000000Z","updated_at":"2025-03-17T19:59:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18677817,"change_date":null,"inspection_id":"80650603","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"96747U3","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"JALC4W164P7K02332","insp_unit_decal":null,"insp_unit_decal_number":"33518482","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":4624386,"change_date":"2023-12-13 21:42:00","inspection_id":"80382677","dot_number":"737814","report_state":"CA","report_number":"NAGM007616","insp_date":"2023-11-27 00:00:00","insp_start_time":"0729","insp_end_time":"0751","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"7120408","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15166150","transaction_code":"A","transaction_date":"2023-11-27 00:00:00","upload_date":"2023-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-12-13 21:42:00","snet_input_date":"2023-11-27 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-12-13 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:54:32.000000Z","updated_at":"2025-03-17T19:54:32.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4723059,"change_date":"2023-12-28 21:45:00","inspection_id":"80490496","dot_number":"737814","report_state":"NM","report_number":"8096N8TMG3","insp_date":"2023-11-13 00:00:00","insp_start_time":"1700","insp_end_time":"1748","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"111323","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-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"58200","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2056476","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-27 00:00:00","source_office":"2NMS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:30.000000Z","updated_at":"2025-03-17T19:56:30.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4305305,"change_date":"2023-10-27 21:43:00","inspection_id":"80031155","dot_number":"737814","report_state":"CA","report_number":"N8OL007808","insp_date":"2023-10-26 00:00:00","insp_start_time":"0900","insp_end_time":"0913","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"0","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15114767","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:48:20.000000Z","updated_at":"2025-03-17T19:48:20.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4307260,"change_date":"2023-10-27 21:43:00","inspection_id":"80033195","dot_number":"737814","report_state":"CA","report_number":"UE03002923","insp_date":"2023-10-23 00:00:00","insp_start_time":"1016","insp_end_time":"1058","registration_date":null,"region":"PT","ci_status_code":"C","location":"391","location_desc":"MISSION GRADE IF","county_code_state":"CA","county_code":"001","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"15112873","transaction_code":"A","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:21.000000Z","updated_at":"2025-03-17T19:48:21.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4222686,"change_date":"2023-10-18 21:40:00","inspection_id":"79939553","dot_number":"737814","report_state":"AZ","report_number":"XE01600109","insp_date":"2023-10-18 00:00:00","insp_start_time":"0955","insp_end_time":"1141","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZPKSW","location_desc":"PARKS AZ","county_code_state":"AZ","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"23-239","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"112000","viol_total":"8","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":"71577","transaction_code":"A","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-18 21:40:00","snet_input_date":"2023-10-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-18 21:40:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:35.000000Z","updated_at":"2025-03-17T19:46:35.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4210158,"change_date":"2023-10-16 21:43:00","inspection_id":"79925846","dot_number":"737814","report_state":"CA","report_number":"UFWF002836","insp_date":"2023-10-14 00:00:00","insp_start_time":"1020","insp_end_time":"1036","registration_date":null,"region":"PT","ci_status_code":"C","location":"875","location_desc":"MT. PASS IF","county_code_state":"CA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"15096769","transaction_code":"A","transaction_date":"2023-10-14 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4155041,"change_date":"2023-10-09 21:36:00","inspection_id":"79865044","dot_number":"737814","report_state":"CA","report_number":"NCVL005704","insp_date":"2023-10-06 00:00:00","insp_start_time":"0734","insp_end_time":"0800","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MAYFLOWER DISTRIBUTING COMPANY","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"15088688","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:44:58.000000Z","updated_at":"2025-03-17T19:44:58.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":4167798,"change_date":"2023-10-10 21:42:00","inspection_id":"79879060","dot_number":"737814","report_state":"CA","report_number":"UHI7000030","insp_date":"2023-10-06 00:00:00","insp_start_time":"0822","insp_end_time":"0842","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15090672","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3739703,"change_date":"2023-08-14 21:43:00","inspection_id":"79402708","dot_number":"737814","report_state":"CA","report_number":"N5Y3004744","insp_date":"2023-07-19 00:00:00","insp_start_time":"0644","insp_end_time":"0702","registration_date":null,"region":"PT","ci_status_code":"C","location":"726","location_desc":"GILROY IF","county_code_state":"CA","county_code":"085","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING INC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"15020418","transaction_code":"A","transaction_date":"2023-07-19 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-08-14 21:43:00","snet_input_date":"2023-07-19 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-08-14 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:33.000000Z","updated_at":"2025-03-17T19:36:33.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3299472,"change_date":"2023-06-15 21:43:00","inspection_id":"78908786","dot_number":"737814","report_state":"CA","report_number":"NBYQ004575","insp_date":"2023-06-14 00:00:00","insp_start_time":"1154","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"771","location_desc":"CONEJO PLATFORM SCALE","county_code_state":"CA","county_code":"111","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING INC","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-06-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"14945933","transaction_code":"A","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-06-15 21:43:00","snet_input_date":"2023-06-14 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-15 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:28:12.000000Z","updated_at":"2025-03-17T19:28:12.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3288552,"change_date":"2023-06-14 21:42:00","inspection_id":"78896277","dot_number":"737814","report_state":"CA","report_number":"ND6D004597","insp_date":"2023-06-13 00:00:00","insp_start_time":"0725","insp_end_time":"0759","registration_date":null,"region":"PT","ci_status_code":"C","location":"424","location_desc":"GRAPEVINE IF","county_code_state":"CA","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DISTRIBUTING","shipping_paper_number":"TRUCK 3","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14944456","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-06-14 21:42:00","snet_input_date":"2023-06-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-06-14 21:42:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:28:08.000000Z","updated_at":"2025-03-17T19:28:08.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":3172141,"change_date":"2023-05-30 21:43:00","inspection_id":"78764783","dot_number":"737814","report_state":"CA","report_number":"NC20005428","insp_date":"2023-05-25 00:00:00","insp_start_time":"0831","insp_end_time":"0857","registration_date":null,"region":"PT","ci_status_code":"C","location":"464","location_desc":"CHOWCHILLA RIVER IF","county_code_state":"CA","county_code":"047","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14920975","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:25:45.000000Z","updated_at":"2025-03-17T19:25:45.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2572039,"change_date":"2023-03-13 21:43:00","inspection_id":"78084884","dot_number":"737814","report_state":"CA","report_number":"UFEK002688","insp_date":"2023-03-13 00:00:00","insp_start_time":"0500","insp_end_time":"0530","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER DIST","shipping_paper_number":"2334","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14815995","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-13 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:06.000000Z","updated_at":"2025-03-17T19:14:06.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2547725,"change_date":"2023-03-09 21:43:00","inspection_id":"78056916","dot_number":"737814","report_state":"CA","report_number":"NDUF003749","insp_date":"2023-03-09 00:00:00","insp_start_time":"0342","insp_end_time":"0406","registration_date":null,"region":"PT","ci_status_code":"C","location":"541","location_desc":"CASTAIC IF","county_code_state":"CA","county_code":"037","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MIS0002334","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14813073","transaction_code":"A","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-03-09 21:43:00","snet_input_date":"2023-03-09 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-09 21:43:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:41.000000Z","updated_at":"2025-03-17T19:13:41.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2505152,"change_date":"2023-03-03 21:41:00","inspection_id":"78008655","dot_number":"737814","report_state":"CA","report_number":"NC2K005783","insp_date":"2023-03-02 00:00:00","insp_start_time":"1107","insp_end_time":"1127","registration_date":null,"region":"PT","ci_status_code":"C","location":"656","location_desc":"DESERT HILLS IF","county_code_state":"CA","county_code":"065","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MAYFLOWER","shipping_paper_number":"5883779","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14805482","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"368457","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":2261689,"change_date":"2023-01-30 21:44:00","inspection_id":"77731284","dot_number":"737814","report_state":"CA","report_number":"UE5Z004914","insp_date":"2023-01-30 00:00:00","insp_start_time":"0530","insp_end_time":"0550","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"SR-14 NB PIT SCALE","county_code_state":"CA","county_code":"037","insp_level_id":"3","service_center":"WE","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"14760370","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00737814","upload_search_indicator":null,"census_search_date":"2023-01-30 21:44:00","snet_input_date":"2023-01-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"MAYFLOWER DISTRIBUTING COMPANY INC","insp_carrier_street":"1155 MEDALLION DRIVE","insp_carrier_city":"MENDOTA HEIGHTS","insp_carrier_state":"MN","insp_carrier_zip_code":"55120","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:27.000000Z","updated_at":"2025-03-17T19:08:27.000000Z","inspection_violations":[],"inspection_per_units":[]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/737814\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/737814\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":109}