{"current_page":1,"data":[{"id":11986162,"change_date":"2026-05-22 08:07:00","inspection_id":"87923692","dot_number":"369592","report_state":"MI","report_number":"BRADD01702","insp_date":"2026-05-21 00:00:00","insp_start_time":"0945","insp_end_time":"1030","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LEONARDS","shipping_paper_number":"3855","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-05-22 08:07:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"3379081","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2026-05-22 08:07:00","snet_input_date":"2026-05-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 08:07:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:02.000000Z","updated_at":"2026-06-02T09:31:12.000000Z","inspection_violations":[{"id":20851271,"change_date":"2026-05-22 08:07:00","inspection_id":"87923692","insp_violation_id":"274423259","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:01:57.000000Z","updated_at":"2026-06-02T09:41:51.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":20837840,"change_date":"2026-05-22 08:07:00","inspection_id":"87923692","insp_unit_id":"213689624","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"BD55995","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JALC4W168R7016179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:18:47.000000Z","updated_at":"2026-06-02T09:03:38.000000Z"}]},{"id":11793883,"change_date":"2026-04-30 21:41:00","inspection_id":"87726694","dot_number":"369592","report_state":"MI","report_number":"FROSR00933","insp_date":"2026-04-30 00:00:00","insp_start_time":"0645","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SWAN CREEK @ MERRILL RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1268192","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":"00369592","upload_search_indicator":null,"census_search_date":"2026-04-30 21:41:00","snet_input_date":"2026-04-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:58.000000Z","updated_at":"2026-05-11T09:31:25.000000Z","inspection_violations":[{"id":20507930,"change_date":"2026-04-30 21:41:00","inspection_id":"87726694","insp_violation_id":"273965069","seq_no":"1","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:55.000000Z","updated_at":"2026-05-11T09:42:25.000000Z","normalized_code":"39282DUMT"},{"id":20507931,"change_date":"2026-04-30 21:41:00","inspection_id":"87726694","insp_violation_id":"273965070","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:55.000000Z","updated_at":"2026-05-11T09:42:25.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20515944,"change_date":"2026-04-30 21:41:00","inspection_id":"87726694","insp_unit_id":"213317494","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BB71240","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H5KK001324","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:57.000000Z","updated_at":"2026-05-11T09:03:57.000000Z"}]},{"id":11597240,"change_date":"2026-04-08 21:38:00","inspection_id":"87523519","dot_number":"369592","report_state":"NM","report_number":"1614Q2PGH8","insp_date":"2026-04-07 00:00:00","insp_start_time":"1302","insp_end_time":"1317","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON PETE V DOMENICI INTERNATION","county_code_state":"NM","county_code":"013","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"000000","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2289433","transaction_code":"A","transaction_date":"2026-04-07 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-08 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:41.000000Z","updated_at":"2026-04-19T09:32:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19878515,"change_date":"2026-04-08 21:38:00","inspection_id":"87523519","insp_unit_id":"212607498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"UNIT316","insp_unit_license":"86EP6W","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"2HSCUAPR4AC172013","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-11T09:19:44.000000Z","updated_at":"2026-04-18T09:37:12.000000Z"}]},{"id":9770386,"change_date":"2025-10-02 21:42:00","inspection_id":"85868277","dot_number":"369592","report_state":"MI","report_number":"ESCOT03046","insp_date":"2025-09-23 00:00:00","insp_start_time":"1310","insp_end_time":"1325","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E I-696@DRAKE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","shipping_paper_number":"092320256P","cargo_tank":"331","hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"1242815","transaction_code":"C","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:16.000000Z","updated_at":"2025-10-05T10:01:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16306417,"change_date":"2025-10-02 21:42:00","inspection_id":"85868277","insp_unit_id":"209264411","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC62","insp_unit_license":"BC76850","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC2RHVF9652","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:52.000000Z","updated_at":"2025-10-05T09:46:52.000000Z"}]},{"id":9645003,"change_date":"2025-09-10 21:40:00","inspection_id":"85736809","dot_number":"369592","report_state":"MI","report_number":"HERLK02644","insp_date":"2025-09-10 00:00:00","insp_start_time":"1254","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MESSER","shipping_paper_number":"258143148","cargo_tank":"331","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"1240538","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:38.000000Z","updated_at":"2025-09-13T10:47:38.000000Z","inspection_violations":[{"id":15786691,"change_date":"2025-09-10 21:40:00","inspection_id":"85736809","insp_violation_id":"268584427","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208853700","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-13T10:50:43.000000Z","updated_at":"2025-09-14T11:56:07.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":15936048,"change_date":"2025-09-10 21:40:00","inspection_id":"85736809","insp_unit_id":"208853700","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC19000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJHHDR2LLLW8941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"},{"id":15936049,"change_date":"2025-09-10 21:40:00","inspection_id":"85736809","insp_unit_id":"208853701","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WESTM","insp_unit_company":null,"insp_unit_license":"E693877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA4424NM350300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:26.000000Z","updated_at":"2025-09-13T10:00:26.000000Z"}]},{"id":9633397,"change_date":"2025-09-09 21:41:00","inspection_id":"85724556","dot_number":"369592","report_state":"MI","report_number":"BESSJ01329","insp_date":"2025-09-05 00:00:00","insp_start_time":"0556","insp_end_time":"0610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB M-14 @ PONTIAC TRAIL","county_code_state":"MI","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"92000","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":"1240005","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2025-09-09 21:41:00","snet_input_date":"2025-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:05.000000Z","inspection_violations":[{"id":15761077,"change_date":"2025-09-09 21:41:00","inspection_id":"85724556","insp_violation_id":"268554671","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:29.000000Z","updated_at":"2025-09-13T10:49:37.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15915224,"change_date":"2025-09-09 21:41:00","inspection_id":"85724556","insp_unit_id":"208830641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"79","insp_unit_license":"RC09704","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGED57ESFX2854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:51.000000Z"},{"id":15915225,"change_date":"2025-09-09 21:41:00","inspection_id":"85724556","insp_unit_id":"208830642","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EVAN","insp_unit_company":"1","insp_unit_license":"D008426","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NNG04326CL061098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:51.000000Z"}]},{"id":7450448,"change_date":"2024-12-18 21:41:00","inspection_id":"83426717","dot_number":"369592","report_state":"MI","report_number":"FOXMA01504","insp_date":"2024-12-16 00:00:00","insp_start_time":"1340","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB 131 AT 10 MILE","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1204506","transaction_code":"A","transaction_date":"2024-12-16 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2024-12-18 21:41:00","snet_input_date":"2024-12-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:33.000000Z","updated_at":"2025-03-17T20:51:33.000000Z","inspection_violations":[{"id":11642160,"change_date":"2024-12-18 21:41:00","inspection_id":"83426717","insp_violation_id":"263546432","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204456628","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:43.000000Z","updated_at":"2025-03-17T22:02:43.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":12019356,"change_date":"2024-12-18 21:41:00","inspection_id":"83426717","insp_unit_id":"204456628","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"GN117","insp_unit_license":"BD55994","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JALC4W166R7016200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:40.000000Z","updated_at":"2025-03-17T23:47:40.000000Z"}]},{"id":6680310,"change_date":"2024-09-17 21:45:00","inspection_id":"82610787","dot_number":"369592","report_state":"MI","report_number":"KAATZ00288","insp_date":"2024-09-05 00:00:00","insp_start_time":"1527","insp_end_time":"1551","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B I 75 CAPRENTER RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"240821130503","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-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1193875","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[{"id":10396647,"change_date":"2024-09-17 21:45:00","inspection_id":"82610787","insp_violation_id":"261865475","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4437480","created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":10770935,"change_date":"2024-09-17 21:45:00","inspection_id":"82610787","insp_unit_id":"202980193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC104","insp_unit_license":"BD57583","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT7FDGP9474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6220377,"change_date":"2024-09-16 21:43:00","inspection_id":"82119547","dot_number":"369592","report_state":"MI","report_number":"BOLLJ00656","insp_date":"2024-07-11 00:00:00","insp_start_time":"1001","insp_end_time":"1058","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NO NUMBER","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-15 21:41: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":"1185419","transaction_code":"C","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:09.000000Z","updated_at":"2025-03-17T20:26:09.000000Z","inspection_violations":[{"id":9661351,"change_date":"2024-09-16 21:43:00","inspection_id":"82119547","insp_violation_id":"261825495","seq_no":"1","part_no":"172","part_no_section":"600(c)","insp_viol_unit":"1","insp_unit_id":"202945301","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"172600C"},{"id":9661352,"change_date":"2024-09-16 21:43:00","inspection_id":"82119547","insp_violation_id":"261825496","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202945301","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:47.000000Z","updated_at":"2025-03-17T21:52:47.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10021855,"change_date":"2024-09-16 21:43:00","inspection_id":"82119547","insp_unit_id":"202945301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BB93258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT8CDBF5585","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:51.000000Z","updated_at":"2025-03-17T23:26:51.000000Z"}]},{"id":5189619,"change_date":"2024-03-01 21:40:00","inspection_id":"81000008","dot_number":"369592","report_state":"MI","report_number":"HERLK02044","insp_date":"2024-02-29 00:00:00","insp_start_time":"0932","insp_end_time":"0953","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":"331","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-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1167382","transaction_code":"A","transaction_date":"2024-02-29 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7997929,"change_date":"2024-03-01 21:40:00","inspection_id":"81000008","insp_violation_id":"258153950","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199711141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39311"},{"id":7997930,"change_date":"2024-03-01 21:40:00","inspection_id":"81000008","insp_violation_id":"258153951","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199711141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":8356129,"change_date":"2024-03-01 21:40:00","inspection_id":"81000008","insp_unit_id":"199711141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC75","insp_unit_license":"RC19000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJHHDR2LLLW8941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"},{"id":8356130,"change_date":"2024-03-01 21:40:00","inspection_id":"81000008","insp_unit_id":"199711142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRL","insp_unit_company":"T3","insp_unit_license":"E693877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA4424NM350300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":5137133,"change_date":"2024-02-26 21:42:00","inspection_id":"80943234","dot_number":"369592","report_state":"MI","report_number":"BOHNE01625","insp_date":"2024-02-23 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75 @ MCNICHOLS","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"17842","cargo_tank":"331","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1166470","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2024-02-26 21:42:00","snet_input_date":"2024-02-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8271027,"change_date":"2024-02-26 21:42:00","inspection_id":"80943234","insp_unit_id":"199602930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC103","insp_unit_license":"BD23954","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT5FDGP9473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":4867197,"change_date":"2024-01-19 21:44:00","inspection_id":"80648098","dot_number":"369592","report_state":"MI","report_number":"PARLM02282","insp_date":"2024-01-18 00:00:00","insp_start_time":"1105","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MISSION & BROOMFIELD","county_code_state":"MI","county_code":"073","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"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-01-19 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1161063","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":"00369592","upload_search_indicator":null,"census_search_date":"2024-01-19 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-19 21:44:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:13.000000Z","updated_at":"2025-03-17T19:59:13.000000Z","inspection_violations":[{"id":7501199,"change_date":"2024-01-19 21:44:00","inspection_id":"80648098","insp_violation_id":"257416958","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199034237","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"39360C"},{"id":7501200,"change_date":"2024-01-19 21:44:00","inspection_id":"80648098","insp_violation_id":"257416959","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199034237","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:13.000000Z","updated_at":"2025-03-17T21:42:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7831142,"change_date":"2024-01-19 21:44:00","inspection_id":"80648098","insp_unit_id":"199034237","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"SN27","insp_unit_license":"BB71211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H1KK001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:59.000000Z","updated_at":"2025-03-17T23:05:59.000000Z"}]},{"id":4205518,"change_date":"2023-10-16 21:43:00","inspection_id":"79920764","dot_number":"369592","report_state":"MI","report_number":"NEGUB02512","insp_date":"2023-10-16 00:00:00","insp_start_time":"0805","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-12 @ BROOKLYN HWY","county_code_state":"MI","county_code":"091","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"10162023","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1149659","transaction_code":"A","transaction_date":"2023-10-16 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:13.000000Z","updated_at":"2025-03-17T19:46:13.000000Z","inspection_violations":[{"id":6511932,"change_date":"2023-10-16 21:43:00","inspection_id":"79920764","insp_violation_id":"255857762","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6763050,"change_date":"2023-10-16 21:43:00","inspection_id":"79920764","insp_unit_id":"197574586","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC103","insp_unit_license":"BD23954","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT5FDGP9473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"}]},{"id":4163484,"change_date":"2023-10-10 21:42:00","inspection_id":"79874335","dot_number":"369592","report_state":"OH","report_number":"1339004204","insp_date":"2023-10-03 00:00:00","insp_start_time":"0841","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MATHESON TRI-GAS INC.","shipping_paper_number":"7811850","cargo_tank":"331","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":"I","final_status_date":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1682553","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:26.000000Z","updated_at":"2025-03-17T19:45:26.000000Z","inspection_violations":[{"id":6443597,"change_date":"2023-10-10 21:42:00","inspection_id":"79874335","insp_violation_id":"255747501","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"197479034","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:05.000000Z","updated_at":"2025-03-17T21:37:05.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":6694690,"change_date":"2023-10-10 21:42:00","inspection_id":"79874335","insp_unit_id":"197479033","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC75","insp_unit_license":"RC19000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJHHDR2LLLW8941","insp_unit_decal":"Y","insp_unit_decal_number":"03332807","created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"},{"id":6694691,"change_date":"2023-10-10 21:42:00","inspection_id":"79874335","insp_unit_id":"197479034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T3","insp_unit_license":"E693877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA4424NM350300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:07.000000Z","updated_at":"2025-03-17T22:56:07.000000Z"}]},{"id":3808288,"change_date":"2023-08-23 21:39:00","inspection_id":"79479148","dot_number":"369592","report_state":"US","report_number":"1518000035","insp_date":"2023-08-23 00:00:00","insp_start_time":"1236","insp_end_time":"1250","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CLIOMI","county_code_state":"MI","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-08-23 21:39: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":"44447","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-08-23 21:39:00","snet_input_date":"2023-08-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-08-23 21:39:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:03.000000Z","updated_at":"2025-03-17T19:38:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6123270,"change_date":"2023-08-23 21:39:00","inspection_id":"79479148","insp_unit_id":"196677183","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BB71211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H1KK001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:26.000000Z","updated_at":"2025-03-17T22:51:26.000000Z"}]},{"id":3803728,"change_date":"2023-08-31 21:42:00","inspection_id":"79474146","dot_number":"369592","report_state":"OH","report_number":"3205402073","insp_date":"2023-08-22 00:00:00","insp_start_time":"1025","insp_end_time":"1115","registration_date":"2023-08-30 00:00:00","region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MATHESON TRI-GAS INC","shipping_paper_number":"7811852","cargo_tank":"331","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":"I","final_status_date":"2023-08-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118500","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":"1674037","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-08-22 21:43:00","snet_input_date":"2023-08-22 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-22 21:43:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:02.000000Z","updated_at":"2025-03-17T19:38:02.000000Z","inspection_violations":[{"id":5867241,"change_date":"2023-08-31 21:42:00","inspection_id":"79474146","insp_violation_id":"255024264","seq_no":"1","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"2","insp_unit_id":"196846399","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:17.000000Z","updated_at":"2025-03-17T21:34:17.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":6115938,"change_date":"2023-08-31 21:42:00","inspection_id":"79474146","insp_unit_id":"196846398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DC75","insp_unit_license":"RC19000","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJHHDR2LLLW8941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:24.000000Z","updated_at":"2025-03-17T22:51:24.000000Z"},{"id":6115939,"change_date":"2023-08-31 21:42:00","inspection_id":"79474146","insp_unit_id":"196846399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T-3","insp_unit_license":"E693877","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA4424NM350300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:24.000000Z","updated_at":"2025-03-17T22:51:24.000000Z"}]},{"id":3789640,"change_date":"2023-08-30 21:45:00","inspection_id":"79458351","dot_number":"369592","report_state":"MI","report_number":"ZYLSJ01374","insp_date":"2023-08-18 00:00:00","insp_start_time":"1459","insp_end_time":"1535","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HALL ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"8-18-23","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1141201","transaction_code":"C","transaction_date":"2023-08-18 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:37:41.000000Z","updated_at":"2025-03-17T19:37:41.000000Z","inspection_violations":[{"id":5844632,"change_date":"2023-08-30 21:45:00","inspection_id":"79458351","insp_violation_id":"254990475","seq_no":"1","part_no":"172","part_no_section":"400(a)","insp_viol_unit":"1","insp_unit_id":"196818334","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:10.000000Z","updated_at":"2025-03-17T21:34:10.000000Z","normalized_code":"172400A"}],"inspection_per_units":[{"id":6093069,"change_date":"2023-08-30 21:45:00","inspection_id":"79458351","insp_unit_id":"196818334","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"102","insp_unit_license":"BC49093","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXD22MDMN4803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:11.000000Z","updated_at":"2025-03-17T22:51:11.000000Z"}]},{"id":3023515,"change_date":"2023-05-15 21:42:00","inspection_id":"78597312","dot_number":"369592","report_state":"MI","report_number":"LINEM00418","insp_date":"2023-05-09 00:00:00","insp_start_time":"1330","insp_end_time":"1424","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","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-05-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1125535","transaction_code":"C","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-05-11 21:42:00","snet_input_date":"2023-05-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-11 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:58.000000Z","updated_at":"2025-03-17T19:22:58.000000Z","inspection_violations":[{"id":4643477,"change_date":"2023-05-15 21:42:00","inspection_id":"78597312","insp_violation_id":"252828392","seq_no":"1","part_no":"172","part_no_section":"519","insp_viol_unit":"1","insp_unit_id":"194928272","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:39.000000Z","updated_at":"2025-03-17T21:28:39.000000Z","normalized_code":"172519"}],"inspection_per_units":[{"id":4864232,"change_date":"2023-05-15 21:42:00","inspection_id":"78597312","insp_unit_id":"194928272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"37","insp_unit_license":"BC03216","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H2LK001461","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:19.000000Z","updated_at":"2025-03-17T22:41:19.000000Z"}]},{"id":2988801,"change_date":"2023-05-08 21:42:00","inspection_id":"78558107","dot_number":"369592","report_state":"MI","report_number":"COPEK02076","insp_date":"2023-05-05 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"1125137","transaction_code":"A","transaction_date":"2023-05-05 00:00:00","upload_date":"2023-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-05-08 21:42:00","snet_input_date":"2023-05-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-08 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:15.000000Z","updated_at":"2025-03-17T19:22:15.000000Z","inspection_violations":[{"id":4587646,"change_date":"2023-05-08 21:42:00","inspection_id":"78558107","insp_violation_id":"252684702","seq_no":"1","part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"194803818","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:23.000000Z","updated_at":"2025-03-17T21:28:23.000000Z","normalized_code":"172502A1"},{"id":4587647,"change_date":"2023-05-08 21:42:00","inspection_id":"78558107","insp_violation_id":"252684703","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194803818","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:23.000000Z","updated_at":"2025-03-17T21:28:23.000000Z","normalized_code":"3939A"},{"id":4587648,"change_date":"2023-05-08 21:42:00","inspection_id":"78558107","insp_violation_id":"252684704","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194803818","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:23.000000Z","updated_at":"2025-03-17T21:28:23.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4808470,"change_date":"2023-05-08 21:42:00","inspection_id":"78558107","insp_unit_id":"194803818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"DW56","insp_unit_license":"BB00600","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTSDAAR6XH225554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:52.000000Z","updated_at":"2025-03-17T22:40:52.000000Z"}]},{"id":2075651,"change_date":"2023-01-05 21:40:00","inspection_id":"77518212","dot_number":"369592","report_state":"MI","report_number":"PARLM01912","insp_date":"2023-01-05 00:00:00","insp_start_time":"0745","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"641","location_desc":"IONIA SCALE E\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LEONARD'S FOUNTAIN SPECIALTIES 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-01-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1107663","transaction_code":"A","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2023-01-05 21:40:00","snet_input_date":"2023-01-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-05 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:47.000000Z","updated_at":"2025-03-17T19:04:47.000000Z","inspection_violations":[{"id":3212377,"change_date":"2023-01-05 21:40:00","inspection_id":"77518212","insp_violation_id":"250405414","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192717852","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3339543,"change_date":"2023-01-05 21:40:00","inspection_id":"77518212","insp_unit_id":"192717852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"GN23","insp_unit_license":"BB71205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H6KK001316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:54.000000Z","updated_at":"2025-03-17T22:29:54.000000Z"}]},{"id":1636589,"change_date":"2022-10-31 21:41:00","inspection_id":"77015870","dot_number":"369592","report_state":"MI","report_number":"PEASS02501","insp_date":"2022-10-31 00:00:00","insp_start_time":"0910","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"2187","cargo_tank":"331","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34700","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":"1100456","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-10-31 21:41:00","snet_input_date":"2022-10-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:43.000000Z","updated_at":"2025-03-17T18:56:43.000000Z","inspection_violations":[{"id":2567218,"change_date":"2022-10-31 21:41:00","inspection_id":"77015870","insp_violation_id":"249340393","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191723726","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2632702,"change_date":"2022-10-31 21:41:00","inspection_id":"77015870","insp_unit_id":"191723726","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"101","insp_unit_license":"BC13179","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBCYBS2CHBW0671","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:03.000000Z","updated_at":"2025-03-17T22:25:03.000000Z"}]},{"id":1625012,"change_date":"2022-10-28 21:39:00","inspection_id":"77002572","dot_number":"369592","report_state":"MI","report_number":"POWED03885","insp_date":"2022-10-26 00:00:00","insp_start_time":"1240","insp_end_time":"1301","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-28 21:39: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":"1099839","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-10-28 21:39:00","snet_input_date":"2022-10-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-28 21:39:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:39.000000Z","updated_at":"2025-03-17T18:56:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2614338,"change_date":"2022-10-28 21:39:00","inspection_id":"77002572","insp_unit_id":"191697170","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"DW52","insp_unit_license":"BB93258","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT8CDBF5575","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:54.000000Z","updated_at":"2025-03-17T22:24:54.000000Z"}]},{"id":1466895,"change_date":"2022-10-07 21:39:00","inspection_id":"76820345","dot_number":"369592","report_state":"MI","report_number":"KOCHJ00937","insp_date":"2022-10-06 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75SB\/CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"1097723","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-10-07 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-07 21:39:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:46.000000Z","updated_at":"2025-03-17T18:53:46.000000Z","inspection_violations":[{"id":2310312,"change_date":"2022-10-07 21:39:00","inspection_id":"76820345","insp_violation_id":"248900160","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191329701","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:17:36.000000Z","updated_at":"2025-03-17T21:17:36.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2361599,"change_date":"2022-10-07 21:39:00","inspection_id":"76820345","insp_unit_id":"191329701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"SN27","insp_unit_license":"BB71211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H1KK001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:11.000000Z","updated_at":"2025-03-17T22:23:11.000000Z"}]},{"id":1295019,"change_date":"2022-09-15 21:40:00","inspection_id":"76620527","dot_number":"369592","report_state":"US","report_number":"1690000160","insp_date":"2022-09-12 00:00:00","insp_start_time":"1218","insp_end_time":"1246","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","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":"I","final_status_date":"2022-09-15 21:40: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":"3420","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-09-15 21:40:00","snet_input_date":"2022-09-15 00:00:00","source_office":"3MID001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2084447,"change_date":"2022-09-15 21:40:00","inspection_id":"76620527","insp_unit_id":"190922153","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"GN23","insp_unit_license":"BB71205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"JHHTDM1H6KK001316","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":1239324,"change_date":"2022-09-08 21:38:00","inspection_id":"76556084","dot_number":"369592","report_state":"MI","report_number":"HICKG01830","insp_date":"2022-09-07 00:00:00","insp_start_time":"1400","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BISHOP RD @ WAVERLY RD","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MICHIGAN BEVERAGE CO","shipping_paper_number":"E-17","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1093780","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-09-08 21:38:00","snet_input_date":"2022-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-09-08 21:38:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:23.000000Z","updated_at":"2025-03-17T18:49:23.000000Z","inspection_violations":[{"id":1962051,"change_date":"2022-09-08 21:38:00","inspection_id":"76556084","insp_violation_id":"248283500","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:03.000000Z","updated_at":"2025-03-17T21:16:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1994383,"change_date":"2022-09-08 21:38:00","inspection_id":"76556084","insp_unit_id":"190788106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"GC102","insp_unit_license":"BC49093","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXD22MDMN4803","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:42.000000Z","updated_at":"2025-03-17T22:20:42.000000Z"}]},{"id":1016448,"change_date":"2022-08-11 21:38:00","inspection_id":"76296669","dot_number":"369592","report_state":"MI","report_number":"PARLM01818","insp_date":"2022-08-10 00:00:00","insp_start_time":"0725","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LEONARD FOUNTAIN SPECIALTIES 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":"2022-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54700","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":"1","hazmat_oos_total":"1","snet_sequence_id":"1088700","transaction_code":"A","transaction_date":"2022-08-10 00:00:00","upload_date":"2022-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-08-11 21:38:00","snet_input_date":"2022-08-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-11 21:38:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:28.000000Z","updated_at":"2025-03-17T18:45:28.000000Z","inspection_violations":[{"id":1600349,"change_date":"2022-08-11 21:38:00","inspection_id":"76296669","insp_violation_id":"247655819","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4093136","created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"3922"},{"id":1600350,"change_date":"2022-08-11 21:38:00","inspection_id":"76296669","insp_violation_id":"247655820","seq_no":"2","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"1","insp_unit_id":"190259767","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:14:33.000000Z","updated_at":"2025-03-17T21:14:33.000000Z","normalized_code":"172504A"}],"inspection_per_units":[{"id":1635392,"change_date":"2022-08-11 21:38:00","inspection_id":"76296669","insp_unit_id":"190259767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"DW56","insp_unit_license":"BB00600","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTSDAAR6XH225554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:18.000000Z","updated_at":"2025-03-17T22:18:18.000000Z"}]},{"id":627833,"change_date":"2022-08-05 21:40:00","inspection_id":"75841338","dot_number":"369592","report_state":"MI","report_number":"WALKB01868","insp_date":"2022-06-13 00:00:00","insp_start_time":"1640","insp_end_time":"1711","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MATHESON","shipping_paper_number":"7322518","cargo_tank":"331","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":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1080065","transaction_code":"C","transaction_date":"2022-08-04 00:00:00","upload_date":"2022-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-06-16 21:43:00","snet_input_date":"2022-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1009075,"change_date":"2022-08-05 21:40:00","inspection_id":"75841338","insp_unit_id":"190157703","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGED57ESFX2854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:24.000000Z","updated_at":"2025-03-17T22:14:24.000000Z"},{"id":1009076,"change_date":"2022-08-05 21:40:00","inspection_id":"75841338","insp_unit_id":"190157704","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WEST","insp_unit_company":null,"insp_unit_license":"D819510","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA41266M350269","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:24.000000Z","updated_at":"2025-03-17T22:14:24.000000Z"}]},{"id":489421,"change_date":"2022-05-26 21:42:00","inspection_id":"75676780","dot_number":"369592","report_state":"US","report_number":"1244000413","insp_date":"2022-05-24 00:00:00","insp_start_time":"1243","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"1","location_desc":"GRASS LAKES SCALES WB","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"LEONARDS FOUNTAIN SYRUP","shipping_paper_number":null,"cargo_tank":"331","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":"I","final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"77900","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":"3400","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"3MID001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:20.000000Z","updated_at":"2025-03-17T18:36:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":787043,"change_date":"2022-05-26 21:42:00","inspection_id":"75676780","insp_unit_id":"188929452","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"79","insp_unit_license":"RC09704","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGED57ESFX2854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"},{"id":787044,"change_date":"2022-05-26 21:42:00","inspection_id":"75676780","insp_unit_id":"188929453","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"D819510","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1W9PA41266M350260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"}]},{"id":385809,"change_date":"2022-06-09 21:42:00","inspection_id":"75552970","dot_number":"369592","report_state":"MI","report_number":"LECHR02654","insp_date":"2022-05-12 00:00:00","insp_start_time":"1335","insp_end_time":"1351","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"HOWELL ST NEAR MAIN ST","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1075512","transaction_code":"C","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00369592","upload_search_indicator":null,"census_search_date":"2022-05-13 21:40:00","snet_input_date":"2022-05-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-13 21:40:00","insp_carrier_name":"LEONARD FOUNTAIN SPECIALTIES INC","insp_carrier_street":"4601 NANCY","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:24.000000Z","updated_at":"2025-03-17T18:34:24.000000Z","inspection_violations":[{"id":603563,"change_date":"2022-06-09 21:42:00","inspection_id":"75552970","insp_violation_id":"246336842","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"3922"},{"id":603564,"change_date":"2022-06-09 21:42:00","inspection_id":"75552970","insp_violation_id":"246336843","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":623642,"change_date":"2022-06-09 21:42:00","inspection_id":"75552970","insp_unit_id":"189147971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC46553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACXDT6DDFG8603","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:01.000000Z","updated_at":"2025-03-17T22:12:01.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/369592\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/369592\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/369592\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/369592\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}