{"current_page":1,"data":[{"id":12505401,"change_date":"2026-07-21 21:39:00","inspection_id":"88469411","dot_number":"1294821","report_state":"NY","report_number":"SPB4060101","insp_date":"2026-07-14 00:00:00","insp_start_time":"1105","insp_end_time":"1121","registration_date":null,"region":"ED","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17500","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":"3798520","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-07-21 21:39:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-21 21:39:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-24T09:42:25.000000Z","updated_at":"2026-08-01T09:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21718483,"change_date":"2026-07-21 21:39:00","inspection_id":"88469411","insp_unit_id":"214729751","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-24T09:19:53.000000Z","updated_at":"2026-08-01T09:01:38.000000Z"}]},{"id":12365441,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","dot_number":"1294821","report_state":"NY","report_number":"SPB3022069","insp_date":"2026-06-30 00:00:00","insp_start_time":"0740","insp_end_time":"0830","registration_date":"2026-07-08 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"MASSENA NY","county_code_state":"NY","county_code":null,"insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3689929","transaction_code":"C","transaction_date":"2026-07-06 00:00:00","upload_date":"2026-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-07-06 21:38:00","snet_input_date":"2026-06-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-06 21:38:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-07-09T09:40:20.000000Z","updated_at":"2026-07-20T09:30:16.000000Z","inspection_violations":[{"id":21522201,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_violation_id":"275365836","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"214504841","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:08.000000Z","updated_at":"2026-07-20T09:43:12.000000Z","normalized_code":"39353BB"},{"id":21522202,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_violation_id":"275365837","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"214504841","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:08.000000Z","updated_at":"2026-07-20T09:43:12.000000Z","normalized_code":"39347E"},{"id":21522200,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_violation_id":"275365835","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"214504841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:08.000000Z","updated_at":"2026-07-20T09:43:12.000000Z","normalized_code":"3965BL"},{"id":21522203,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_violation_id":"275365838","seq_no":"4","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"214504841","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-09T09:58:08.000000Z","updated_at":"2026-07-20T09:43:12.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":21472971,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_unit_id":"214504841","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-78","insp_unit_license":"30391TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2HSCTAPR78C537765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-09T09:15:46.000000Z","updated_at":"2026-07-20T09:01:23.000000Z"},{"id":21472972,"change_date":"2026-07-09 21:41:00","inspection_id":"88327288","insp_unit_id":"214504842","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"50-117","insp_unit_license":"CG73390","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629SB719450","insp_unit_decal":"Y","insp_unit_decal_number":"36371032","created_at":"2026-07-09T09:15:46.000000Z","updated_at":"2026-07-20T09:01:23.000000Z"}]},{"id":12219550,"change_date":"2026-06-18 21:41:00","inspection_id":"88177194","dot_number":"1294821","report_state":"NY","report_number":"SPB3051010","insp_date":"2026-06-11 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"ED","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"OGDENSBURG PEPSI COLA BOTTLERS","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-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3568592","transaction_code":"A","transaction_date":"2026-06-17 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-06-18 21:41:00","snet_input_date":"2026-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:31.000000Z","updated_at":"2026-06-29T09:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21222120,"change_date":"2026-06-18 21:41:00","inspection_id":"88177194","insp_unit_id":"214166952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"56-16","insp_unit_license":"92874MA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKSSWK6LH622134","insp_unit_decal":"Y","insp_unit_decal_number":"36371030","created_at":"2026-06-21T09:19:20.000000Z","updated_at":"2026-06-29T09:01:20.000000Z"}]},{"id":12132761,"change_date":"2026-06-09 21:41:00","inspection_id":"88078918","dot_number":"1294821","report_state":"NY","report_number":"SPB3130507","insp_date":"2026-06-02 00:00:00","insp_start_time":"1127","insp_end_time":"1141","registration_date":"2026-06-03 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA OGDENSBURG BOTTLERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3496477","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-06-09 21:41:00","snet_input_date":"2026-06-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:56.000000Z","updated_at":"2026-06-20T09:32:08.000000Z","inspection_violations":[{"id":21117662,"change_date":"2026-06-09 21:41:00","inspection_id":"88078918","insp_violation_id":"274778878","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-12T09:58:54.000000Z","updated_at":"2026-06-19T09:46:24.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":21079233,"change_date":"2026-06-09 21:41:00","inspection_id":"88078918","insp_unit_id":"213981600","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:40.000000Z","updated_at":"2026-06-20T09:03:49.000000Z"}]},{"id":11775767,"change_date":"2026-04-29 21:39:00","inspection_id":"87706767","dot_number":"1294821","report_state":"NY","report_number":"SPD3061748","insp_date":"2026-04-22 00:00:00","insp_start_time":"1310","insp_end_time":"1325","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"3227600","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-04-29 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-29 21:39:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-02T09:40:55.000000Z","updated_at":"2026-05-10T09:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20486157,"change_date":"2026-04-29 21:39:00","inspection_id":"87706767","insp_unit_id":"213279717","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"20671BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSDJAPR5FH536310","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-02T09:19:03.000000Z","updated_at":"2026-05-10T09:02:24.000000Z"}]},{"id":11693535,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","dot_number":"1294821","report_state":"NY","report_number":"SPB3130382","insp_date":"2026-04-14 00:00:00","insp_start_time":"0724","insp_end_time":"0846","registration_date":"2026-04-15 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"LOUISVILLE NY","county_code_state":"NY","county_code":"089","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA OGDENSBURG BOTTLERS","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-04-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3183895","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:31.000000Z","updated_at":"2026-05-01T09:30:32.000000Z","inspection_violations":[{"id":20318885,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711466","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213106542","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39347E"},{"id":20318886,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711467","seq_no":"2","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"213106542","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39353BB"},{"id":20318887,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711468","seq_no":"3","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213106543","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"3963A1BOS"},{"id":20318888,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711469","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213106542","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39347E"},{"id":20318889,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711470","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"213106542","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"3963A1BOS"},{"id":20318890,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711471","seq_no":"6","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"213106543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39348ABIAD"},{"id":20318891,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711472","seq_no":"7","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"213106543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39348ABIAD"},{"id":20318892,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711473","seq_no":"8","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"213106543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39348ABIAD"},{"id":20318893,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_violation_id":"273711474","seq_no":"9","part_no":"393","part_no_section":"48A-BIAD","insp_viol_unit":"2","insp_unit_id":"213106543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:50:51.000000Z","updated_at":"2026-05-01T09:41:30.000000Z","normalized_code":"39348ABIAD"}],"inspection_per_units":[{"id":20350829,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_unit_id":"213106542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-78","insp_unit_license":"30391TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2HSCTAPR78C537765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:43.000000Z","updated_at":"2026-05-01T09:03:14.000000Z"},{"id":20350830,"change_date":"2026-04-20 21:38:00","inspection_id":"87619689","insp_unit_id":"213106543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"50-117","insp_unit_license":"CG73390","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629SB719450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:10:43.000000Z","updated_at":"2026-05-01T09:03:14.000000Z"}]},{"id":11368896,"change_date":"2026-03-13 21:37:00","inspection_id":"87282436","dot_number":"1294821","report_state":"NY","report_number":"D700500687","insp_date":"2026-03-12 00:00:00","insp_start_time":"0756","insp_end_time":"0825","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MASSENA NY","county_code_state":"NY","county_code":null,"insp_level_id":"1","service_center":"EA","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-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3002659","transaction_code":"A","transaction_date":"2026-03-13 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:13.000000Z","updated_at":"2026-03-24T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19466829,"change_date":"2026-03-13 21:37:00","inspection_id":"87282436","insp_unit_id":"212121675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"Y","insp_unit_decal_number":"36049351","created_at":"2026-03-16T09:16:56.000000Z","updated_at":"2026-03-24T09:04:15.000000Z"}]},{"id":10866837,"change_date":"2026-01-27 21:37:00","inspection_id":"86896646","dot_number":"1294821","report_state":"NY","report_number":"SPB3120052","insp_date":"2026-01-21 00:00:00","insp_start_time":"0721","insp_end_time":"0737","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LOUISVILLE NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA","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-01-27 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"55000","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":"2817231","transaction_code":"A","transaction_date":"2026-01-27 00:00:00","upload_date":"2026-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-01-27 21:37:00","snet_input_date":"2026-01-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-27 21:37:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-30T10:36:26.000000Z","updated_at":"2026-02-08T10:30:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18261879,"change_date":"2026-01-27 21:37:00","inspection_id":"86896646","insp_unit_id":"211304168","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"19417BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HCDGAPN4HL713988","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-30T10:07:50.000000Z","updated_at":"2026-02-07T10:03:59.000000Z"},{"id":18261880,"change_date":"2026-01-27 21:37:00","inspection_id":"86896646","insp_unit_id":"211304169","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CH65312","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2R9CUAZ11RP699278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-30T10:07:50.000000Z","updated_at":"2026-02-07T10:03:59.000000Z"}]},{"id":10858216,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","dot_number":"1294821","report_state":"NY","report_number":"SPB3120051","insp_date":"2026-01-19 00:00:00","insp_start_time":"1210","insp_end_time":"1241","registration_date":"2026-01-23 00:00:00","region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI COLA","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-01-26 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"65350","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2813765","transaction_code":"C","transaction_date":"2026-01-25 00:00:00","upload_date":"2026-01-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-01-26 21:36:00","snet_input_date":"2026-01-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-26 21:36:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-29T10:36:02.000000Z","updated_at":"2026-02-08T10:30:11.000000Z","inspection_violations":[{"id":18180807,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","insp_violation_id":"271439328","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"211301567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"S260190934","created_at":"2026-01-30T10:42:17.000000Z","updated_at":"2026-02-07T10:35:29.000000Z","normalized_code":"3939ALTSIR"},{"id":18180808,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","insp_violation_id":"271439329","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"211301567","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-30T10:42:17.000000Z","updated_at":"2026-02-07T10:35:29.000000Z","normalized_code":"39311A1CSURR"},{"id":18180809,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","insp_violation_id":"271439330","seq_no":"3","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"211301568","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-30T10:42:17.000000Z","updated_at":"2026-02-07T10:35:29.000000Z","normalized_code":"3939ALSML"}],"inspection_per_units":[{"id":18259246,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","insp_unit_id":"211301568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"50-77","insp_unit_license":"BE45726","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113513E1000402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-30T10:07:48.000000Z","updated_at":"2026-02-07T10:03:48.000000Z"},{"id":18259245,"change_date":"2026-01-27 21:37:00","inspection_id":"86887637","insp_unit_id":"211301567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"14883BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSDGAPN0EH014288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-30T10:07:48.000000Z","updated_at":"2026-02-07T10:03:48.000000Z"}]},{"id":10802614,"change_date":"2026-01-19 21:34:00","inspection_id":"86829338","dot_number":"1294821","report_state":"NY","report_number":"SPB3120035","insp_date":"2026-01-12 00:00:00","insp_start_time":"1149","insp_end_time":"1208","registration_date":null,"region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI COLA","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-01-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2785275","transaction_code":"A","transaction_date":"2026-01-18 00:00:00","upload_date":"2026-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2026-01-19 21:34:00","snet_input_date":"2026-01-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-19 21:34:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-22T10:35:59.000000Z","updated_at":"2026-01-30T10:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18137337,"change_date":"2026-01-19 21:34:00","inspection_id":"86829338","insp_unit_id":"211159125","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:08.000000Z","updated_at":"2026-01-30T10:00:05.000000Z"}]},{"id":10517737,"change_date":"2025-12-26 21:33:00","inspection_id":"86653280","dot_number":"1294821","report_state":"NY","report_number":"SPB3120002","insp_date":"2025-12-19 00:00:00","insp_start_time":"0839","insp_end_time":"0902","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MASSENA NY","county_code_state":"NY","county_code":null,"insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","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":"2025-12-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2699250","transaction_code":"A","transaction_date":"2025-12-25 00:00:00","upload_date":"2025-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-12-26 21:33:00","snet_input_date":"2025-12-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-26 21:33:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-29T10:36:12.000000Z","updated_at":"2026-01-06T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17614044,"change_date":"2025-12-26 21:33:00","inspection_id":"86653280","insp_unit_id":"210801525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"50-78","insp_unit_license":"30391TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2HSCTAPR78C537765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:16.000000Z","updated_at":"2026-01-06T10:00:12.000000Z"},{"id":17614045,"change_date":"2025-12-26 21:33:00","inspection_id":"86653280","insp_unit_id":"210801526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"50-117","insp_unit_license":"CG73390","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A0629SB719450","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:16.000000Z","updated_at":"2026-01-06T10:00:12.000000Z"}]},{"id":10396931,"change_date":"2025-12-10 21:38:00","inspection_id":"86527004","dot_number":"1294821","report_state":"NY","report_number":"SPB3050946","insp_date":"2025-12-04 00:00:00","insp_start_time":"0800","insp_end_time":"0810","registration_date":null,"region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI COLA","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":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2638303","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:35.000000Z","updated_at":"2025-12-14T10:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17383879,"change_date":"2025-12-10 21:38:00","inspection_id":"86527004","insp_unit_id":"210520930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:48.000000Z","updated_at":"2025-12-14T10:00:52.000000Z"}]},{"id":9101181,"change_date":"2025-07-09 21:42:00","inspection_id":"85165718","dot_number":"1294821","report_state":"NY","report_number":"D700500216","insp_date":"2025-06-26 00:00:00","insp_start_time":"1132","insp_end_time":"1207","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MASSENA NY","county_code_state":"NY","county_code":null,"insp_level_id":"2","service_center":"EA","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":"2025-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1944530","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-07-09 21:42:00","snet_input_date":"2025-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-09 21:42:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:22.000000Z","updated_at":"2025-07-14T10:46:07.000000Z","inspection_violations":[{"id":14665691,"change_date":"2025-07-09 21:42:00","inspection_id":"85165718","insp_violation_id":"267299185","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"207778147","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:08.000000Z","updated_at":"2025-07-13T10:49:08.000000Z","normalized_code":"3939ALCL"},{"id":14665692,"change_date":"2025-07-09 21:42:00","inspection_id":"85165718","insp_violation_id":"267299186","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207778147","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-13T10:49:08.000000Z","updated_at":"2025-07-13T10:49:08.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":14939071,"change_date":"2025-07-09 21:42:00","inspection_id":"85165718","insp_unit_id":"207778147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"9715NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMAAL7DL296532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:52.000000Z","updated_at":"2025-07-13T09:46:11.000000Z"}]},{"id":8436660,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","dot_number":"1294821","report_state":"NY","report_number":"SPB3040438","insp_date":"2025-04-16 00:00:00","insp_start_time":"0809","insp_end_time":"0827","registration_date":null,"region":"ED","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"73000","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":"1627523","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:03.000000Z","updated_at":"2025-04-26T10:27:03.000000Z","inspection_violations":[{"id":13324459,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_violation_id":"265756045","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206427925","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:48:59.000000Z","updated_at":"2025-04-25T10:57:57.000000Z","normalized_code":"3939ALRLI"},{"id":13324460,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_violation_id":"265756046","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"1","insp_unit_id":"206427925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:48:59.000000Z","updated_at":"2025-04-25T10:57:57.000000Z","normalized_code":"39355EB"},{"id":13324461,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_violation_id":"265756047","seq_no":"3","part_no":"393","part_no_section":"55D2-B","insp_viol_unit":"1","insp_unit_id":"206427925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:48:59.000000Z","updated_at":"2025-04-25T10:57:57.000000Z","normalized_code":"39355D2B"},{"id":13324462,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_violation_id":"265756048","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"206427926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T10:48:59.000000Z","updated_at":"2025-04-25T10:57:57.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":13702145,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_unit_id":"206427925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"19445BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHWAHN18J679393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:08:02.000000Z","updated_at":"2025-04-26T09:56:56.000000Z"},{"id":13702146,"change_date":"2025-04-22 21:41:00","inspection_id":"84463524","insp_unit_id":"206427926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"50-99","insp_unit_license":"CA91083","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113511L1000489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-25T10:08:02.000000Z","updated_at":"2025-04-26T09:56:56.000000Z"}]},{"id":8388915,"change_date":"2025-04-16 21:40:00","inspection_id":"84413147","dot_number":"1294821","report_state":"NY","report_number":"SPB3050381","insp_date":"2025-04-09 00:00:00","insp_start_time":"0828","insp_end_time":"0901","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DE KALB JUNCTION NY","county_code_state":"NY","county_code":null,"insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OGDENSBURG PEPSI COLA BOTTLERS","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":"2025-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"1601128","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:50.000000Z","updated_at":"2025-04-20T10:23:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13616256,"change_date":"2025-04-16 21:40:00","inspection_id":"84413147","insp_unit_id":"206336814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"50-106","insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:03:39.000000Z","updated_at":"2025-04-20T09:52:17.000000Z"}]},{"id":7659237,"change_date":"2025-01-19 21:33:00","inspection_id":"83645962","dot_number":"1294821","report_state":"NY","report_number":"SPB3040283","insp_date":"2025-01-13 00:00:00","insp_start_time":"0655","insp_end_time":"0711","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MASSENA NY","county_code_state":"NY","county_code":null,"insp_level_id":"3","service_center":"EA","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":"2025-01-19 21:33: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":"1265332","transaction_code":"A","transaction_date":"2025-01-19 00:00:00","upload_date":"2025-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-01-19 21:33:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-19 21:33:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:04.000000Z","updated_at":"2025-03-17T20:57:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12358879,"change_date":"2025-01-19 21:33:00","inspection_id":"83645962","insp_unit_id":"204910721","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"18071BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDYAPN4JN630041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"},{"id":12358880,"change_date":"2025-01-19 21:33:00","inspection_id":"83645962","insp_unit_id":"204910722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"CH65312","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2R9CUAZ11RP699278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:22.000000Z","updated_at":"2025-03-17T23:51:22.000000Z"}]},{"id":7663406,"change_date":"2025-01-20 21:34:00","inspection_id":"83650377","dot_number":"1294821","report_state":"NY","report_number":"SPB3050241","insp_date":"2025-01-13 00:00:00","insp_start_time":"1256","insp_end_time":"1306","registration_date":null,"region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI BOTTLERS OF OGDENSBURG","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":"2025-01-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"1268385","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2025-01-20 21:34:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-20 21:34:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:25.000000Z","updated_at":"2025-03-17T20:57:25.000000Z","inspection_violations":[{"id":11972597,"change_date":"2025-01-20 21:34:00","inspection_id":"83650377","insp_violation_id":"264082314","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12365748,"change_date":"2025-01-20 21:34:00","inspection_id":"83650377","insp_unit_id":"204918306","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"50-106","insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:29.000000Z","updated_at":"2025-03-17T23:51:29.000000Z"}]},{"id":7387598,"change_date":"2024-12-11 21:40:00","inspection_id":"83360691","dot_number":"1294821","report_state":"NY","report_number":"SPB3050156","insp_date":"2024-12-04 00:00:00","insp_start_time":"1123","insp_end_time":"1140","registration_date":null,"region":"ES","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"OGDENSBURG PEPSI BOTTLERS","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-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1142786","transaction_code":"A","transaction_date":"2024-12-11 00:00:00","upload_date":"2024-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-12-11 21:40:00","snet_input_date":"2024-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-11 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:17.000000Z","updated_at":"2025-03-17T20:50:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11917384,"change_date":"2024-12-11 21:40:00","inspection_id":"83360691","insp_unit_id":"204313953","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:35.000000Z","updated_at":"2025-03-17T23:46:35.000000Z"}]},{"id":7246307,"change_date":"2024-11-21 21:40:00","inspection_id":"83211702","dot_number":"1294821","report_state":"NY","report_number":"SPB3070147","insp_date":"2024-11-14 00:00:00","insp_start_time":"1030","insp_end_time":"1045","registration_date":null,"region":"ES","ci_status_code":"C","location":"70519E","location_desc":"MASSENA NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSI","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-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1077128","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-11-21 21:40:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-21 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:15.000000Z","updated_at":"2025-03-17T20:47:15.000000Z","inspection_violations":[{"id":11327879,"change_date":"2024-11-21 21:40:00","inspection_id":"83211702","insp_violation_id":"263012383","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:01.000000Z","updated_at":"2025-03-17T22:01:01.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":11688104,"change_date":"2024-11-21 21:40:00","inspection_id":"83211702","insp_unit_id":"203984835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50-120","insp_unit_license":"81507NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEUMML5SL655164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:08.000000Z","updated_at":"2025-03-17T23:44:08.000000Z"}]},{"id":7188233,"change_date":"2024-11-14 21:40:00","inspection_id":"83150342","dot_number":"1294821","report_state":"NY","report_number":"SPB3070145","insp_date":"2024-11-07 00:00:00","insp_start_time":"0947","insp_end_time":"1009","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CRANBERRY LAKE NY","county_code_state":"NY","county_code":null,"insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","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-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"65350","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":"1050272","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-11-14 21:40:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-14 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:00.000000Z","updated_at":"2025-03-17T20:46:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11594325,"change_date":"2024-11-14 21:40:00","inspection_id":"83150342","insp_unit_id":"203869171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"50 115","insp_unit_license":"18072BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDYAPN6JN630042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:08.000000Z","updated_at":"2025-03-17T23:43:08.000000Z"},{"id":11594326,"change_date":"2024-11-14 21:40:00","inspection_id":"83150342","insp_unit_id":"203869172","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACKNEY &","insp_unit_company":"50-77","insp_unit_license":"BE45726","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113513E1000402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:08.000000Z","updated_at":"2025-03-17T23:43:08.000000Z"}]},{"id":7167852,"change_date":"2024-11-12 21:41:00","inspection_id":"83128774","dot_number":"1294821","report_state":"NY","report_number":"SPB3070131","insp_date":"2024-11-06 00:00:00","insp_start_time":"0720","insp_end_time":"0738","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LOUISVILLE NY","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA","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-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"1044430","transaction_code":"A","transaction_date":"2024-11-12 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-11-12 21:41:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-12 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:34.000000Z","updated_at":"2025-03-17T20:45:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11561562,"change_date":"2024-11-12 21:41:00","inspection_id":"83128774","insp_unit_id":"203828639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"70008NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMMMN1FL036693","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:49.000000Z","updated_at":"2025-03-17T23:42:49.000000Z"}]},{"id":6436702,"change_date":"2024-08-11 21:32:00","inspection_id":"82351076","dot_number":"1294821","report_state":"NY","report_number":"M605500044","insp_date":"2024-08-08 00:00:00","insp_start_time":"1028","insp_end_time":"1108","registration_date":null,"region":"ED","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE NY","county_code_state":"NY","county_code":"089","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-11 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"734411","transaction_code":"A","transaction_date":"2024-08-11 00:00:00","upload_date":"2024-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-08-11 21:32:00","snet_input_date":"2024-08-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-11 21:32:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:20.000000Z","updated_at":"2025-03-17T20:30:20.000000Z","inspection_violations":[{"id":9995608,"change_date":"2024-08-11 21:32:00","inspection_id":"82351076","insp_violation_id":"261122366","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202329172","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39341"},{"id":9995609,"change_date":"2024-08-11 21:32:00","inspection_id":"82351076","insp_violation_id":"261122367","seq_no":"2","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"202329172","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39311A1"}],"inspection_per_units":[{"id":10374008,"change_date":"2024-08-11 21:32:00","inspection_id":"82351076","insp_unit_id":"202329172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"50-106","insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:30.000000Z","updated_at":"2025-03-17T23:30:30.000000Z"}]},{"id":6345716,"change_date":"2024-07-30 21:43:00","inspection_id":"82253648","dot_number":"1294821","report_state":"NY","report_number":"SPB0402753","insp_date":"2024-07-29 00:00:00","insp_start_time":"0805","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"70486","location_desc":"LOUISVILLE","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2024-07-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"2941276","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:40.000000Z","updated_at":"2025-03-17T20:28:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10225542,"change_date":"2024-07-30 21:43:00","inspection_id":"82253648","insp_unit_id":"202143211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:57.000000Z","updated_at":"2025-03-17T23:28:57.000000Z"}]},{"id":5765555,"change_date":"2024-05-16 21:41:00","inspection_id":"81627903","dot_number":"1294821","report_state":"NY","report_number":"SPB0257231","insp_date":"2024-05-15 00:00:00","insp_start_time":"0658","insp_end_time":"0727","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE REST AREA","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA OGDENSBURG BOTTLERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"2923746","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2024-05-16 21:41:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-16 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:04.000000Z","updated_at":"2025-03-17T20:17:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9286145,"change_date":"2024-05-16 21:41:00","inspection_id":"81627903","insp_unit_id":"200927002","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"12368TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHWAHN18J679393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:27.000000Z","updated_at":"2025-03-17T23:19:27.000000Z"},{"id":9286146,"change_date":"2024-05-16 21:41:00","inspection_id":"81627903","insp_unit_id":"200927003","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARC","insp_unit_company":null,"insp_unit_license":"AU25243","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2P9SNA6A98G027751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:27.000000Z","updated_at":"2025-03-17T23:19:27.000000Z"}]},{"id":5489292,"change_date":"2024-04-11 21:41:00","inspection_id":"81327458","dot_number":"1294821","report_state":"NY","report_number":"SPB0257131","insp_date":"2024-04-10 00:00:00","insp_start_time":"0645","insp_end_time":"0702","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE REST AREA","county_code_state":"NY","county_code":"089","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"OGDENSBURG PEPSI BOTTLERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"2916585","transaction_code":"A","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-11 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:32.000000Z","updated_at":"2025-03-17T20:11:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8842260,"change_date":"2024-04-11 21:41:00","inspection_id":"81327458","insp_unit_id":"200351271","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"12368TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHWAHN18J679393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"},{"id":8842261,"change_date":"2024-04-11 21:41:00","inspection_id":"81327458","insp_unit_id":"200351272","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PARC","insp_unit_company":null,"insp_unit_license":"AU25243","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2P9SNA6A98G027751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:15.000000Z","updated_at":"2025-03-17T23:15:15.000000Z"}]},{"id":4835851,"change_date":"2024-01-16 21:44:00","inspection_id":"80613792","dot_number":"1294821","report_state":"NY","report_number":"SPB0342564","insp_date":"2024-01-11 00:00:00","insp_start_time":"0905","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"70173","location_desc":"CLIFTON","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-16 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"65350","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":"2900219","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2024-01-16 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-16 21:44:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"PO BOX 708","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:28.000000Z","updated_at":"2025-03-17T19:58:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7780124,"change_date":"2024-01-16 21:44:00","inspection_id":"80613792","insp_unit_id":"198965691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":"50-77","insp_unit_license":"BE45726","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113513E1000402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"},{"id":7780125,"change_date":"2024-01-16 21:44:00","inspection_id":"80613792","insp_unit_id":"198965692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"18072BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDYAPN6JN630042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:33.000000Z","updated_at":"2025-03-17T23:05:33.000000Z"}]},{"id":4159048,"change_date":"2023-10-10 21:41:00","inspection_id":"79869351","dot_number":"1294821","report_state":"NY","report_number":"SPWB061127","insp_date":"2023-10-06 00:00:00","insp_start_time":"0815","insp_end_time":"0834","registration_date":null,"region":"ET","ci_status_code":"C","location":"70863","location_desc":"WADDINGTON EAST ROADSIDE","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA OGDENSBURG BOTTLERS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2876466","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":"01294821","upload_search_indicator":"M","census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","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":[{"id":6437031,"change_date":"2023-10-10 21:41:00","inspection_id":"79869351","insp_violation_id":"255737245","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197468587","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6H88B26","created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3939A"},{"id":6437032,"change_date":"2023-10-10 21:41:00","inspection_id":"79869351","insp_violation_id":"255737246","seq_no":"2","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"197468587","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"6H88B52","created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":6687056,"change_date":"2023-10-10 21:41:00","inspection_id":"79869351","insp_unit_id":"197468587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"30391TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2HSCTAPR78C537765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:05.000000Z","updated_at":"2025-03-17T22:56:05.000000Z"},{"id":6687057,"change_date":"2023-10-10 21:41:00","inspection_id":"79869351","insp_unit_id":"197468588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"BP68280","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9629KT167527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:05.000000Z","updated_at":"2025-03-17T22:56:05.000000Z"}]},{"id":3930832,"change_date":"2023-09-08 21:41:00","inspection_id":"79615939","dot_number":"1294821","report_state":"NY","report_number":"SP2B260007","insp_date":"2023-09-07 00:00:00","insp_start_time":"1224","insp_end_time":"1239","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE ROADSIDE WEST","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"2866174","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:28.000000Z","updated_at":"2025-03-17T19:40:28.000000Z","inspection_violations":[{"id":6075576,"change_date":"2023-09-08 21:41:00","inspection_id":"79615939","insp_violation_id":"255154486","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6H562CF","created_at":"2025-03-17T21:35:22.000000Z","updated_at":"2025-03-17T21:35:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6320366,"change_date":"2023-09-08 21:41:00","inspection_id":"79615939","insp_unit_id":"196959825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:07.000000Z","updated_at":"2025-03-17T22:53:07.000000Z"}]},{"id":2652481,"change_date":"2023-03-24 21:40:00","inspection_id":"78175967","dot_number":"1294821","report_state":"NY","report_number":"SPB0401500","insp_date":"2023-03-23 00:00:00","insp_start_time":"1004","insp_end_time":"1029","registration_date":null,"region":"ET","ci_status_code":"C","location":"70173","location_desc":"CLIFTON","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2809435","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2023-03-24 21:40:00","snet_input_date":"2023-03-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-03-24 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:33.000000Z","updated_at":"2025-03-17T19:15:33.000000Z","inspection_violations":[{"id":4077149,"change_date":"2023-03-24 21:40:00","inspection_id":"78175967","insp_violation_id":"251849224","seq_no":"1","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"194045353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39355D2"},{"id":4077150,"change_date":"2023-03-24 21:40:00","inspection_id":"78175967","insp_violation_id":"251849225","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"1","insp_unit_id":"194045353","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4270200,"change_date":"2023-03-24 21:40:00","inspection_id":"78175967","insp_unit_id":"194045353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"12368TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHWAHN18J679393","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:39.000000Z","updated_at":"2025-03-17T22:36:39.000000Z"},{"id":4270201,"change_date":"2023-03-24 21:40:00","inspection_id":"78175967","insp_unit_id":"194045354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HACK","insp_unit_company":null,"insp_unit_license":"BE45726","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113513E1000402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:39.000000Z","updated_at":"2025-03-17T22:36:39.000000Z"}]},{"id":1750241,"change_date":"2022-11-16 21:40:00","inspection_id":"77145901","dot_number":"1294821","report_state":"NY","report_number":"SPB0401242","insp_date":"2022-11-15 00:00:00","insp_start_time":"0721","insp_end_time":"0741","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","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":"N","pen_cen_match":null,"final_status_date":"2022-11-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2768134","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2022-11-16 21:40:00","snet_input_date":"2022-11-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-16 21:40:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:56.000000Z","updated_at":"2025-03-17T18:58:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2815959,"change_date":"2022-11-16 21:40:00","inspection_id":"77145901","insp_unit_id":"191978260","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"97151NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAMMAAL7DL296532","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:16.000000Z","updated_at":"2025-03-17T22:26:16.000000Z"}]},{"id":1453896,"change_date":"2022-10-06 21:39:00","inspection_id":"76805089","dot_number":"1294821","report_state":"NY","report_number":"SPB0401147","insp_date":"2022-10-05 00:00:00","insp_start_time":"0630","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"70684","location_desc":"POTSDAM ROADSIDE","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"78000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2756339","transaction_code":"A","transaction_date":"2022-10-06 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2022-10-06 21:39:00","snet_input_date":"2022-10-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-06 21:39:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:27.000000Z","updated_at":"2025-03-17T18:53:27.000000Z","inspection_violations":[{"id":2289941,"change_date":"2022-10-06 21:39:00","inspection_id":"76805089","insp_violation_id":"248866776","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191299994","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9FZ6X1M","created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"3939A"},{"id":2289942,"change_date":"2022-10-06 21:39:00","inspection_id":"76805089","insp_violation_id":"248866777","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191299994","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:29.000000Z","updated_at":"2025-03-17T21:17:29.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2340723,"change_date":"2022-10-06 21:39:00","inspection_id":"76805089","insp_unit_id":"191299994","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"50-81","insp_unit_license":"19781TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHWAHN75J039538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"},{"id":2340724,"change_date":"2022-10-06 21:39:00","inspection_id":"76805089","insp_unit_id":"191299995","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"50-99","insp_unit_license":"CA91083","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"526113511L1000489","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:03.000000Z","updated_at":"2025-03-17T22:23:03.000000Z"}]},{"id":1121506,"change_date":"2022-08-24 21:39:00","inspection_id":"76419343","dot_number":"1294821","report_state":"NY","report_number":"SPB0341740","insp_date":"2022-08-19 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"70485A","location_desc":"LOUISVILLE","county_code_state":"NY","county_code":"089","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2743016","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-24 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:31.000000Z","updated_at":"2025-03-17T18:47:31.000000Z","inspection_violations":[{"id":1771424,"change_date":"2022-08-24 21:39:00","inspection_id":"76419343","insp_violation_id":"247951741","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190508681","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3922"},{"id":1771425,"change_date":"2022-08-24 21:39:00","inspection_id":"76419343","insp_violation_id":"247951742","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1803795,"change_date":"2022-08-24 21:39:00","inspection_id":"76419343","insp_unit_id":"190508681","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"50106","insp_unit_license":"47105NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDWE3FSXJDC34139","insp_unit_decal":"Y","insp_unit_decal_number":"31688033","created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":134347,"change_date":"2022-04-08 21:39:00","inspection_id":"75253027","dot_number":"1294821","report_state":"NY","report_number":"SPWB060825","insp_date":"2022-04-07 00:00:00","insp_start_time":"0225","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623A","location_desc":"OSWEGATCHIE RESTAREA","county_code_state":"NY","county_code":"089","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA BOTTLERS","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":"Y","pen_cen_match":null,"final_status_date":"2022-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2693525","transaction_code":"A","transaction_date":"2022-04-08 00:00:00","upload_date":"2022-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01294821","upload_search_indicator":"M","census_search_date":"2022-04-08 21:39:00","snet_input_date":"2022-04-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-08 21:39:00","insp_carrier_name":"PEPSI COLA OGDENSBURG BOTTLERS","insp_carrier_street":"1001 MANSION AVENUE","insp_carrier_city":"OGDENSBURG","insp_carrier_state":"NY","insp_carrier_zip_code":"13669","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:51.000000Z","updated_at":"2025-03-17T18:29:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":217400,"change_date":"2022-04-08 21:39:00","inspection_id":"75253027","insp_unit_id":"188053885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"56279JU","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTSCAAM2XH667335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:31.000000Z","updated_at":"2025-03-17T22:09:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1294821\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1294821\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1294821\/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\/1294821\/inspections","per_page":100,"prev_page_url":null,"to":33,"total":33}