{"current_page":1,"data":[{"id":10434305,"change_date":"2025-12-15 21:39:00","inspection_id":"86566108","dot_number":"465013","report_state":"MO","report_number":"0779000329","insp_date":"2025-12-10 00:00:00","insp_start_time":"0623","insp_end_time":"0649","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MONTREAL MO","county_code_state":"MO","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2115124","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":"2025-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"103000","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":"2659393","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2025-12-15 21:39:00","snet_input_date":"2025-12-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-15 21:39:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-18T10:30:37.000000Z","updated_at":"2025-12-26T10:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17455823,"change_date":"2025-12-15 21:39:00","inspection_id":"86566108","insp_unit_id":"210603971","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"2005","insp_unit_license":"62M7HP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3H3V402K5RJ482231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:31.000000Z","updated_at":"2025-12-26T10:00:36.000000Z"},{"id":17455822,"change_date":"2025-12-15 21:39:00","inspection_id":"86566108","insp_unit_id":"210603970","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2106","insp_unit_license":"90J8SV","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKBCYFE7RDUW1873","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-18T10:00:31.000000Z","updated_at":"2025-12-26T10:00:36.000000Z"}]},{"id":8419255,"change_date":"2025-04-19 21:33:00","inspection_id":"84445076","dot_number":"465013","report_state":"MO","report_number":"0838000315","insp_date":"2025-04-14 00:00:00","insp_start_time":"0651","insp_end_time":"0702","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROLLA MO","county_code_state":"MO","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-19 21:33: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":"1617471","transaction_code":"A","transaction_date":"2025-04-19 00:00:00","upload_date":"2025-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2025-04-19 21:33:00","snet_input_date":"2025-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-19 21:33:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-23T10:02:44.000000Z","updated_at":"2025-04-23T10:03:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13669930,"change_date":"2025-04-19 21:33:00","inspection_id":"84445076","insp_unit_id":"206394815","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"05J3XG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKJHTFM7SSVX5929","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-22T10:04:17.000000Z","updated_at":"2025-04-23T09:49:12.000000Z"},{"id":13669931,"change_date":"2025-04-19 21:33:00","inspection_id":"84445076","insp_unit_id":"206394816","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"18L8VE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA9620JB700708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-22T10:04:17.000000Z","updated_at":"2025-04-23T09:49:12.000000Z"}]},{"id":7401779,"change_date":"2024-12-12 21:41:00","inspection_id":"83375559","dot_number":"465013","report_state":"MO","report_number":"1253000436","insp_date":"2024-12-12 00:00:00","insp_start_time":"1012","insp_end_time":"1038","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"VIENNA MO","county_code_state":"MO","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1149456","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:43.000000Z","updated_at":"2025-03-17T20:50:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11940518,"change_date":"2024-12-12 21:41:00","inspection_id":"83375559","insp_unit_id":"204341444","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2217","insp_unit_license":"50J2SG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN3ML381733","insp_unit_decal":"Y","insp_unit_decal_number":"34674524","created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"}]},{"id":7354619,"change_date":"2024-12-06 21:43:00","inspection_id":"83326076","dot_number":"465013","report_state":"MO","report_number":"FW04000325","insp_date":"2024-12-06 00:00:00","insp_start_time":"1240","insp_end_time":"1302","registration_date":null,"region":"CS","ci_status_code":"C","location":"FLWNG","location_desc":"FORT LEONARD WOOD MO","county_code_state":"MO","county_code":"169","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSICOLA BOTTLING CO","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":"2024-12-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1127015","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2024-12-06 21:43:00","snet_input_date":"2024-12-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-06 21:43:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:25.000000Z","updated_at":"2025-03-17T20:49:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11863918,"change_date":"2024-12-06 21:43:00","inspection_id":"83326076","insp_unit_id":"204227357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"2221","insp_unit_license":"97J2RZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKBCYFEXLDLX8445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:58.000000Z","updated_at":"2025-03-17T23:45:58.000000Z"},{"id":11863919,"change_date":"2024-12-06 21:43:00","inspection_id":"83326076","insp_unit_id":"204227358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"2148","insp_unit_license":"7620PE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25374P141421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:58.000000Z","updated_at":"2025-03-17T23:45:58.000000Z"}]},{"id":6896203,"change_date":"2024-10-05 21:33:00","inspection_id":"82840403","dot_number":"465013","report_state":"MO","report_number":"0838000226","insp_date":"2024-10-04 00:00:00","insp_start_time":"0913","insp_end_time":"0934","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VICHY MO","county_code_state":"MO","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":"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":"U","pen_cen_match":"I","final_status_date":"2024-10-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","viol_total":"1","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":"916673","transaction_code":"A","transaction_date":"2024-10-05 00:00:00","upload_date":"2024-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2024-10-05 21:33:00","snet_input_date":"2024-10-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-05 21:33:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:51.000000Z","updated_at":"2025-03-17T20:39:51.000000Z","inspection_violations":[{"id":10744646,"change_date":"2024-10-05 21:33:00","inspection_id":"82840403","insp_violation_id":"262205074","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203283752","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:03.000000Z","updated_at":"2025-03-17T21:58:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11121893,"change_date":"2024-10-05 21:33:00","inspection_id":"82840403","insp_unit_id":"203283752","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"2225","insp_unit_license":"39J9SU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN7PL069998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:12.000000Z","updated_at":"2025-03-17T23:38:12.000000Z"},{"id":11121894,"change_date":"2024-10-05 21:33:00","inspection_id":"82840403","insp_unit_id":"203283753","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"07L0YW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA0629DB703011","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:12.000000Z","updated_at":"2025-03-17T23:38:12.000000Z"}]},{"id":4756688,"change_date":"2024-01-03 21:44:00","inspection_id":"80527115","dot_number":"465013","report_state":"MO","report_number":"FW05000131","insp_date":"2024-01-03 00:00:00","insp_start_time":"0624","insp_end_time":"0648","registration_date":null,"region":"CT","ci_status_code":"C","location":"FLW","location_desc":"FORT LEONARD WOOD","county_code_state":"MO","county_code":"169","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-01-03 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","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":"2092385","transaction_code":"A","transaction_date":"2024-01-03 00:00:00","upload_date":"2024-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2024-01-03 21:44:00","snet_input_date":"2024-01-03 00:00:00","source_office":"3MOS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[{"id":7339970,"change_date":"2024-01-03 21:44:00","inspection_id":"80527115","insp_violation_id":"257167537","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198796171","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:24.000000Z","updated_at":"2025-03-17T21:41:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7652220,"change_date":"2024-01-03 21:44:00","inspection_id":"80527115","insp_unit_id":"198796171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"221","insp_unit_license":"97J2RZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3AKBCYFEXLDLX8445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"},{"id":7652221,"change_date":"2024-01-03 21:44:00","inspection_id":"80527115","insp_unit_id":"198796172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"651781","insp_unit_license":"07L1YW","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA0627DB703010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4157316,"change_date":"2023-10-10 21:41:00","inspection_id":"79867446","dot_number":"465013","report_state":"MO","report_number":"0838000006","insp_date":"2023-10-10 00:00:00","insp_start_time":"1022","insp_end_time":"1038","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VICHY MO","county_code_state":"MO","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"66178","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"101 HICKORY ST","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:59.000000Z","updated_at":"2025-03-17T19:44:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6684720,"change_date":"2023-10-10 21:41:00","inspection_id":"79867446","insp_unit_id":"197465679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"39J9SU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN7PL069998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"},{"id":6684721,"change_date":"2023-10-10 21:41:00","inspection_id":"79867446","insp_unit_id":"197465680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":null,"insp_unit_license":"6189PD","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"526113718B1000405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:02.000000Z","updated_at":"2025-03-17T22:56:02.000000Z"}]},{"id":3834138,"change_date":"2023-08-25 21:41:00","inspection_id":"79508225","dot_number":"465013","report_state":"MO","report_number":"IT03003811","insp_date":"2023-08-24 00:00:00","insp_start_time":"0701","insp_end_time":"0718","registration_date":null,"region":"CT","ci_status_code":"C","location":"I63","location_desc":"ROLLA","county_code_state":"MO","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-25 21:41: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":"2089426","transaction_code":"A","transaction_date":"2023-08-25 00:00:00","upload_date":"2023-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":"M","census_search_date":"2023-08-25 21:41:00","snet_input_date":"2023-08-25 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-08-25 21:41:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:33.000000Z","updated_at":"2025-03-17T19:38:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6164578,"change_date":"2023-08-25 21:41:00","inspection_id":"79508225","insp_unit_id":"196736195","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97J3RZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSEUTAN0MH067346","insp_unit_decal":"Y","insp_unit_decal_number":"33047389","created_at":"2025-03-17T22:51:46.000000Z","updated_at":"2025-03-17T22:51:46.000000Z"}]},{"id":3579524,"change_date":"2023-07-24 21:42:00","inspection_id":"79223489","dot_number":"465013","report_state":"MO","report_number":"FW05000081","insp_date":"2023-07-21 00:00:00","insp_start_time":"0815","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":"FLW","location_desc":"FORT LEONARD WOOD","county_code_state":"MO","county_code":"169","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","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":"2085060","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:36.000000Z","updated_at":"2025-03-17T19:33:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5755608,"change_date":"2023-07-24 21:42:00","inspection_id":"79223489","insp_unit_id":"196160570","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"NAVI","insp_unit_company":null,"insp_unit_license":"97J3RZ","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSEUTAN0MH067346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"},{"id":5755609,"change_date":"2023-07-24 21:42:00","inspection_id":"79223489","insp_unit_id":"196160571","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"7620PE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25374P141421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"}]},{"id":2412689,"change_date":"2023-02-21 21:41:00","inspection_id":"77903630","dot_number":"465013","report_state":"MO","report_number":"IT03003617","insp_date":"2023-02-08 00:00:00","insp_start_time":"0716","insp_end_time":"0726","registration_date":null,"region":"CT","ci_status_code":"C","location":"I44","location_desc":"ROLLA","county_code_state":"MO","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"2058543","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":null,"census_search_date":"2023-02-21 21:41:00","snet_input_date":"2023-02-21 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-21 21:41:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:05.000000Z","updated_at":"2025-03-17T19:11:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3882263,"change_date":"2023-02-21 21:41:00","inspection_id":"77903630","insp_unit_id":"193495225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"39J9SU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN7PL069998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:48.000000Z","updated_at":"2025-03-17T22:33:48.000000Z"},{"id":3882264,"change_date":"2023-02-21 21:41:00","inspection_id":"77903630","insp_unit_id":"193495226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HESS","insp_unit_company":null,"insp_unit_license":"PJ9298","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1H9RA1210PK008655","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:48.000000Z","updated_at":"2025-03-17T22:33:48.000000Z"}]},{"id":1159623,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","dot_number":"465013","report_state":"MO","report_number":"0384001402","insp_date":"2022-08-26 00:00:00","insp_start_time":"1025","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"C54","location_desc":"US 54 @ LOUISIANA","county_code_state":"MO","county_code":"163","insp_level_id":"1","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":"2022-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","viol_total":"8","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2029224","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":"M","census_search_date":"2022-08-29 21:42:00","snet_input_date":"2022-08-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1837705,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066382","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190598339","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"3922"},{"id":1837706,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066383","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190598339","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39347E"},{"id":1837707,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066384","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190598339","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39353B"},{"id":1837708,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066385","seq_no":"7","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"2","insp_unit_id":"190598339","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39347A"},{"id":1837709,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066386","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"190598339","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"3963A1"},{"id":1837710,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066387","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190598338","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39617C"},{"id":1837711,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066388","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:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"3922"},{"id":1837712,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_violation_id":"248066389","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190598338","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:30.000000Z","updated_at":"2025-03-17T21:15:30.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":1864474,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_unit_id":"190598338","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3310","insp_unit_license":"76J2SH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN3LL358435","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"},{"id":1864475,"change_date":"2022-08-29 21:42:00","inspection_id":"76463963","insp_unit_id":"190598339","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"121T","insp_unit_license":"62K1WU","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA9629BT555759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":369251,"change_date":"2022-05-11 21:40:00","inspection_id":"75533108","dot_number":"465013","report_state":"MO","report_number":"0485000832","insp_date":"2022-05-10 00:00:00","insp_start_time":"0620","insp_end_time":"0633","registration_date":null,"region":"CT","ci_status_code":"C","location":"I44","location_desc":"DOOLITTLE","county_code_state":"MO","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-05-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"97000","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":"2010485","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":"M","census_search_date":"2022-05-11 21:40:00","snet_input_date":"2022-05-11 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-05-11 21:40:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:00.000000Z","updated_at":"2025-03-17T18:34:00.000000Z","inspection_violations":[{"id":578838,"change_date":"2022-05-11 21:40:00","inspection_id":"75533108","insp_violation_id":"245729012","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"188631297","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":597252,"change_date":"2022-05-11 21:40:00","inspection_id":"75533108","insp_unit_id":"188631296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"50J2SG","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"3HCEUTAN3ML381733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:51.000000Z","updated_at":"2025-03-17T22:11:51.000000Z"},{"id":597253,"change_date":"2022-05-11 21:40:00","inspection_id":"75533108","insp_unit_id":"188631297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"7620PE","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1UYVS25374P141421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:51.000000Z","updated_at":"2025-03-17T22:11:51.000000Z"}]},{"id":62473,"change_date":"2022-03-29 21:42:00","inspection_id":"75164770","dot_number":"465013","report_state":"MO","report_number":"0485000766","insp_date":"2022-03-28 00:00:00","insp_start_time":"0630","insp_end_time":"0642","registration_date":null,"region":"CT","ci_status_code":"C","location":"I72","location_desc":"ROLLA","county_code_state":"MO","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"2002884","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00465013","upload_search_indicator":"M","census_search_date":"2022-03-29 21:42:00","snet_input_date":"2022-03-29 00:00:00","source_office":"3MOS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"PEPSI-COLA BOTTLING COMPANY OF NEW HAVEN INC","insp_carrier_street":"P O  BOX 77","insp_carrier_city":"NEW HAVEN","insp_carrier_state":"MO","insp_carrier_zip_code":"63068","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[{"id":89902,"change_date":"2022-03-29 21:42:00","inspection_id":"75164770","insp_violation_id":"244835121","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"187873702","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":101472,"change_date":"2022-03-29 21:42:00","inspection_id":"75164770","insp_unit_id":"187873701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"50J4SC","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1HSMKTANXJH418292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":101473,"change_date":"2022-03-29 21:42:00","inspection_id":"75164770","insp_unit_id":"187873702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"3879PH","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1GRAA96227T541080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/465013\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/465013\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/465013\/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\/465013\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}