{"current_page":1,"data":[{"id":12207927,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","dot_number":"306854","report_state":"OH","report_number":"1782001336","insp_date":"2026-06-15 00:00:00","insp_start_time":"1054","insp_end_time":"1136","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MADISON OH","county_code_state":"OH","county_code":"085","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3559328","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2026-06-17 21:40:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-17 21:40:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"204 EAST MAIN ST","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-20T09:43:38.000000Z","updated_at":"2026-06-28T09:30:25.000000Z","inspection_violations":[{"id":21246490,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_violation_id":"274958071","seq_no":"3","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"214144291","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:18.000000Z","updated_at":"2026-06-28T09:40:19.000000Z","normalized_code":"39355D2B"},{"id":21246491,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_violation_id":"274958072","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"214144291","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:18.000000Z","updated_at":"2026-06-28T09:40:19.000000Z","normalized_code":"3922SLLSR"},{"id":21246492,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_violation_id":"274958073","seq_no":"5","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"214144292","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:18.000000Z","updated_at":"2026-06-28T09:40:19.000000Z","normalized_code":"3939ALIL"},{"id":21246493,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_violation_id":"274958074","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"214144292","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:18.000000Z","updated_at":"2026-06-28T09:40:19.000000Z","normalized_code":"3939ALSML"},{"id":21246494,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_violation_id":"274958075","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"214144292","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:05:18.000000Z","updated_at":"2026-06-28T09:40:19.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":21203087,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_unit_id":"214144291","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1002A","insp_unit_license":"PWH8590","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUY3MDB3YMF38088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:21:49.000000Z","updated_at":"2026-06-28T09:01:22.000000Z"},{"id":21203088,"change_date":"2026-06-17 21:40:00","inspection_id":"88164978","insp_unit_id":"214144292","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"950","insp_unit_license":"TSB5037","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5MATA4229EA029006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:21:49.000000Z","updated_at":"2026-06-28T09:01:22.000000Z"}]},{"id":8248232,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","dot_number":"306854","report_state":"OH","report_number":"1782000290","insp_date":"2025-03-28 00:00:00","insp_start_time":"0939","insp_end_time":"1023","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ASHTABULA OH","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FRENCHS' CONCRETE","shipping_paper_number":"158611","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":"2025-03-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"79000","viol_total":"4","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":"1531129","transaction_code":"A","transaction_date":"2025-03-30 00:00:00","upload_date":"2025-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2025-03-30 21:33:00","snet_input_date":"2025-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-30 21:33:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"204 EAST MAIN ST","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-02T10:01:05.000000Z","updated_at":"2025-04-03T10:03:17.000000Z","inspection_violations":[{"id":12951211,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","insp_violation_id":"265337625","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLEWG3"},{"id":12951212,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","insp_violation_id":"265337626","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"OHP981782032820","created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLEWA3"},{"id":12951213,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","insp_violation_id":"265337627","seq_no":"3","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"206065384","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLMF"},{"id":12951214,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","insp_violation_id":"265337628","seq_no":"4","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13345517,"change_date":"2025-03-30 21:33:00","inspection_id":"84265067","insp_unit_id":"206065384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"UNPUBLISHE","insp_unit_company":"924","insp_unit_license":"PVY4635","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1A9TAC6M6W0007828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-02T09:50:58.000000Z","updated_at":"2025-04-03T09:50:11.000000Z"}]},{"id":8248235,"change_date":"2025-03-30 21:33:00","inspection_id":"84265070","dot_number":"306854","report_state":"OH","report_number":"1782000291","insp_date":"2025-03-28 00:00:00","insp_start_time":"1137","insp_end_time":"1222","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ASHTABULA OH","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FRENC","shipping_paper_number":"158619","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":"2025-03-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"3","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":"1531149","transaction_code":"A","transaction_date":"2025-03-30 00:00:00","upload_date":"2025-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2025-03-30 21:33:00","snet_input_date":"2025-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-30 21:33:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"204 EAST MAIN ST","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-02T10:01:05.000000Z","updated_at":"2025-04-03T10:03:17.000000Z","inspection_violations":[{"id":12951215,"change_date":"2025-03-30 21:33:00","inspection_id":"84265070","insp_violation_id":"265337629","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLEWG3"},{"id":12951216,"change_date":"2025-03-30 21:33:00","inspection_id":"84265070","insp_violation_id":"265337630","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"OHP981782032820","created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3922SLLEWA3"},{"id":12951217,"change_date":"2025-03-30 21:33:00","inspection_id":"84265070","insp_violation_id":"265337631","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"206065388","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-02T10:20:14.000000Z","updated_at":"2025-04-03T10:19:50.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":13345521,"change_date":"2025-03-30 21:33:00","inspection_id":"84265070","insp_unit_id":"206065388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"UNPUBLISHE","insp_unit_company":"908","insp_unit_license":"PUV9505","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1A9TAC5M3S0007183","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-02T09:50:58.000000Z","updated_at":"2025-04-03T09:50:11.000000Z"}]},{"id":5523985,"change_date":"2024-04-16 21:41:00","inspection_id":"81365236","dot_number":"306854","report_state":"OH","report_number":"1772004831","insp_date":"2024-04-15 00:00:00","insp_start_time":"1320","insp_end_time":"1403","registration_date":null,"region":"ET","ci_status_code":"C","location":"08590","location_desc":"ROADSIDE(43)","county_code_state":"OH","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BABIC CONCRETE","shipping_paper_number":"152392","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":"I","final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"1719024","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2024-04-16 21:41:00","snet_input_date":"2024-04-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:19.000000Z","updated_at":"2025-03-17T20:12:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8898143,"change_date":"2024-04-16 21:41:00","inspection_id":"81365236","insp_unit_id":"200422647","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"924","insp_unit_license":"PVY4635","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1A9TAC6M6W0007828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:47.000000Z","updated_at":"2025-03-17T23:15:47.000000Z"}]},{"id":5063832,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","dot_number":"306854","report_state":"OH","report_number":"1772004738","insp_date":"2024-02-14 00:00:00","insp_start_time":"1218","insp_end_time":"1310","registration_date":null,"region":"ET","ci_status_code":"C","location":"08590","location_desc":"ROADSIDE(43)","county_code_state":"OH","county_code":"085","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BOOTH FARM","shipping_paper_number":"151651","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":"I","final_status_date":"2024-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1705105","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:03.000000Z","updated_at":"2025-03-17T20:03:03.000000Z","inspection_violations":[{"id":7805161,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867604","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3922"},{"id":7805162,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867605","seq_no":"2","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"393201D"},{"id":7805163,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867606","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3965B"},{"id":7805164,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867607","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3939A"},{"id":7805165,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867608","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"39378"},{"id":7805166,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867609","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3922"},{"id":7805167,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_violation_id":"257867610","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199449372","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:45.000000Z","updated_at":"2025-03-17T21:43:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8151511,"change_date":"2024-02-15 21:43:00","inspection_id":"80863146","insp_unit_id":"199449372","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"932","insp_unit_license":"PWB4551","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5DG8AC6T040009613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"}]},{"id":3925689,"change_date":"2023-09-07 21:41:00","inspection_id":"79610294","dot_number":"306854","report_state":"OH","report_number":"1238006987","insp_date":"2023-09-07 00:00:00","insp_start_time":"1316","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"00711","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"42350","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":"1677128","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-09-07 21:41:00","snet_input_date":"2023-09-07 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-09-07 21:41:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:26.000000Z","updated_at":"2025-03-17T19:40:26.000000Z","inspection_violations":[{"id":6067057,"change_date":"2023-09-07 21:41:00","inspection_id":"79610294","insp_violation_id":"255140118","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:21.000000Z","updated_at":"2025-03-17T21:35:21.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":6312311,"change_date":"2023-09-07 21:41:00","inspection_id":"79610294","insp_unit_id":"196948343","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1002A","insp_unit_license":"PWH8590","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FUY3MDB3YMF38088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:02.000000Z","updated_at":"2025-03-17T22:53:02.000000Z"}]},{"id":3654452,"change_date":"2023-08-22 21:43:00","inspection_id":"79307315","dot_number":"306854","report_state":"OH","report_number":"1238006917","insp_date":"2023-08-02 00:00:00","insp_start_time":"0831","insp_end_time":"0852","registration_date":"2023-08-22 00:00:00","region":"ET","ci_status_code":"C","location":"00732","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SHENANGO VALLEY SAND & GRAVEL","shipping_paper_number":"08779","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1670620","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[{"id":5633977,"change_date":"2023-08-22 21:43:00","inspection_id":"79307315","insp_violation_id":"254806359","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"196667133","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"393201A"},{"id":5633978,"change_date":"2023-08-22 21:43:00","inspection_id":"79307315","insp_violation_id":"254806360","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196667133","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:06.000000Z","updated_at":"2025-03-17T21:33:06.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5876135,"change_date":"2023-08-22 21:43:00","inspection_id":"79307315","insp_unit_id":"196667133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1010","insp_unit_license":"PWP9175","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTXLAHT34J084781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3375971,"change_date":"2023-06-27 21:40:00","inspection_id":"78994650","dot_number":"306854","report_state":"OH","report_number":"1238006817","insp_date":"2023-06-27 00:00:00","insp_start_time":"1129","insp_end_time":"1157","registration_date":null,"region":"ET","ci_status_code":"C","location":"00711","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"1647409","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"1664395","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-27 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:48.000000Z","updated_at":"2025-03-17T19:29:48.000000Z","inspection_violations":[{"id":5205842,"change_date":"2023-06-27 21:40:00","inspection_id":"78994650","insp_violation_id":"253726143","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"231147","created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39216A"},{"id":5205843,"change_date":"2023-06-27 21:40:00","inspection_id":"78994650","insp_violation_id":"253726144","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"231147","created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"},{"id":5205844,"change_date":"2023-06-27 21:40:00","inspection_id":"78994650","insp_violation_id":"253726145","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5427112,"change_date":"2023-06-27 21:40:00","inspection_id":"78994650","insp_unit_id":"195698214","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1010","insp_unit_license":"PWP9175","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTXLAHT34J084781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:49.000000Z","updated_at":"2025-03-17T22:45:49.000000Z"}]},{"id":3069160,"change_date":"2023-05-17 21:43:00","inspection_id":"78648709","dot_number":"306854","report_state":"OH","report_number":"1772004185","insp_date":"2023-05-16 00:00:00","insp_start_time":"1310","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":"08590","location_desc":"ROADSIDE(43)","county_code_state":"OH","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","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":"1656960","transaction_code":"A","transaction_date":"2023-05-16 00:00:00","upload_date":"2023-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-05-17 21:43:00","snet_input_date":"2023-05-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-05-17 21:43:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:46.000000Z","updated_at":"2025-03-17T19:23:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4937402,"change_date":"2023-05-17 21:43:00","inspection_id":"78648709","insp_unit_id":"194985256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"OSHK","insp_unit_company":"929","insp_unit_license":"PWF7375","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"10TDAEC26YS068064","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:55.000000Z","updated_at":"2025-03-17T22:41:55.000000Z"}]},{"id":2918740,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","dot_number":"306854","report_state":"OH","report_number":"1238006686","insp_date":"2023-04-28 00:00:00","insp_start_time":"0954","insp_end_time":"1049","registration_date":null,"region":"ET","ci_status_code":"C","location":"00711","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PINNEY DOCK","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":"N","pen_cen_match":"I","final_status_date":"2023-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1653353","transaction_code":"A","transaction_date":"2023-04-28 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-04-28 21:39:00","snet_input_date":"2023-04-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-04-28 21:39:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:29.000000Z","updated_at":"2025-03-17T19:20:29.000000Z","inspection_violations":[{"id":4479489,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_violation_id":"252507272","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":"70899","created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3922"},{"id":4479490,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_violation_id":"252507273","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3922"},{"id":4479491,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_violation_id":"252507274","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194646206","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3922"},{"id":4479492,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_violation_id":"252507275","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194646206","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:51.000000Z","updated_at":"2025-03-17T21:27:51.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4695981,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_unit_id":"194646205","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1009","insp_unit_license":"PWH5660","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1M1AA12Y41W141792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"},{"id":4695982,"change_date":"2023-04-28 21:39:00","inspection_id":"78479048","insp_unit_id":"194646206","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"TSC1486","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1E1D1M281YRC29035","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:02.000000Z","updated_at":"2025-03-17T22:40:02.000000Z"}]},{"id":2389469,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","dot_number":"306854","report_state":"OH","report_number":"1238006559","insp_date":"2023-02-16 00:00:00","insp_start_time":"0956","insp_end_time":"1042","registration_date":null,"region":"ET","ci_status_code":"C","location":"00711","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"1635081","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1639888","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-02-16 21:42:00","snet_input_date":"2023-02-16 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-02-16 21:42:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:43.000000Z","updated_at":"2025-03-17T19:10:43.000000Z","inspection_violations":[{"id":3678890,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_violation_id":"251184190","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193441370","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"3922"},{"id":3678891,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_violation_id":"251184191","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193441370","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"3922"},{"id":3678892,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_violation_id":"251184192","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193441370","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"3922"},{"id":3678893,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_violation_id":"251184193","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"193441370","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"39345D"},{"id":3678894,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_violation_id":"251184194","seq_no":"5","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"193441370","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:19.000000Z","updated_at":"2025-03-17T21:24:19.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":3844851,"change_date":"2023-02-16 21:42:00","inspection_id":"77877073","insp_unit_id":"193441370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1010","insp_unit_license":"PWP9175","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTXLAHT34J084781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:31.000000Z","updated_at":"2025-03-17T22:33:31.000000Z"}]},{"id":2603843,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","dot_number":"306854","report_state":"OH","report_number":"1772003988","insp_date":"2023-02-10 00:00:00","insp_start_time":"1305","insp_end_time":"1415","registration_date":null,"region":"ET","ci_status_code":"C","location":"08590","location_desc":"ROADSIDE(43)","county_code_state":"OH","county_code":"085","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"KINDER MORGAN","shipping_paper_number":"016334767","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":"I","final_status_date":"2023-03-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1645064","transaction_code":"C","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2023-03-17 21:42:00","snet_input_date":"2023-03-17 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:49.000000Z","updated_at":"2025-03-17T19:14:49.000000Z","inspection_violations":[{"id":4005828,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782191","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3939A"},{"id":4005829,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782192","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"},{"id":4005830,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782193","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39311"},{"id":4005831,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782194","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3939A"},{"id":4005832,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782195","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"},{"id":4005833,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782196","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"},{"id":4005834,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782197","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"},{"id":4005835,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_violation_id":"251782198","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193982394","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1772","created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4191483,"change_date":"2023-03-21 21:41:00","inspection_id":"78121267","insp_unit_id":"193982394","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1010","insp_unit_license":"PWP9175","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTXLAHT34J084781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:03.000000Z","updated_at":"2025-03-17T22:36:03.000000Z"}]},{"id":1940255,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","dot_number":"306854","report_state":"OH","report_number":"1238006434","insp_date":"2022-12-13 00:00:00","insp_start_time":"0757","insp_end_time":"0847","registration_date":"2023-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"00732","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SHENANGO VALLEY SAND AND GRAVEL","shipping_paper_number":"07426","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1630288","transaction_code":"C","transaction_date":"2022-12-13 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2022-12-13 21:40:00","snet_input_date":"2022-12-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:31.000000Z","updated_at":"2025-03-17T19:02:31.000000Z","inspection_violations":[{"id":3014776,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_violation_id":"251523563","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193750967","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"220834","created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014777,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_violation_id":"251523564","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193750967","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014778,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_violation_id":"251523565","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193750967","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014779,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_violation_id":"251523566","seq_no":"4","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"193750967","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"393201A"},{"id":3014780,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_violation_id":"251523567","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193750967","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3122094,"change_date":"2023-03-07 21:41:00","inspection_id":"77363921","insp_unit_id":"193750967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1010","insp_unit_license":"PWP9175","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1HTXLAHT34J084781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"}]},{"id":1940264,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","dot_number":"306854","report_state":"OH","report_number":"1238006435","insp_date":"2022-12-13 00:00:00","insp_start_time":"1007","insp_end_time":"1049","registration_date":"2023-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"00711","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"144614","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1630298","transaction_code":"C","transaction_date":"2022-12-13 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2022-12-13 21:40:00","snet_input_date":"2022-12-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:31.000000Z","updated_at":"2025-03-17T19:02:31.000000Z","inspection_violations":[{"id":3014794,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_violation_id":"251523568","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":"221039","created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014795,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_violation_id":"251523569","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193750968","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014796,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_violation_id":"251523570","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193750968","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"},{"id":3014797,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_violation_id":"251523571","seq_no":"4","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193750968","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39375G"},{"id":3014798,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_violation_id":"251523572","seq_no":"5","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"193750968","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":3122111,"change_date":"2023-03-07 21:41:00","inspection_id":"77363930","insp_unit_id":"193750968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"938","insp_unit_license":"PVU9508","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1A9TAC4S3N0007768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"}]},{"id":1697133,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","dot_number":"306854","report_state":"OH","report_number":"3281022146","insp_date":"2022-11-08 00:00:00","insp_start_time":"1206","insp_end_time":"1303","registration_date":null,"region":"ET","ci_status_code":"C","location":"13376","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FRENCHES 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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1625133","transaction_code":"C","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00306854","upload_search_indicator":null,"census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-08 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"FRENCHS' INC","insp_carrier_street":"P O BOX 1360","insp_carrier_city":"ANDOVER","insp_carrier_state":"OH","insp_carrier_zip_code":"44003-1330","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:48.000000Z","updated_at":"2025-03-17T18:57:48.000000Z","inspection_violations":[{"id":2659883,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_violation_id":"249543819","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191904915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3939A"},{"id":2659884,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_violation_id":"249543820","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191904915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3939A"},{"id":2659885,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_violation_id":"249543821","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191904915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3939A"},{"id":2659886,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_violation_id":"249543822","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191904915","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"3939A"},{"id":2659887,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_violation_id":"249543823","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"191904916","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:30.000000Z","updated_at":"2025-03-17T21:19:30.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2730430,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_unit_id":"191904915","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1009","insp_unit_license":"PWH5660","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1M1AA12Y41W141792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"},{"id":2730431,"change_date":"2022-11-10 21:39:00","inspection_id":"77085137","insp_unit_id":"191904916","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"950","insp_unit_license":"TSB5037","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"5MATA4229EA029006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:42.000000Z","updated_at":"2025-03-17T22:25:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/306854\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/306854\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/306854\/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\/306854\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}