{"current_page":1,"data":[{"id":12526838,"change_date":"2026-07-23 21:40:00","inspection_id":"88492609","dot_number":"330753","report_state":"NY","report_number":"SPL5040018","insp_date":"2026-07-16 00:00:00","insp_start_time":"1200","insp_end_time":"1218","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","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":"2026-07-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3816496","transaction_code":"A","transaction_date":"2026-07-22 00:00:00","upload_date":"2026-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-07-23 21:40:00","snet_input_date":"2026-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-23 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-26T09:42:20.000000Z","updated_at":"2026-08-03T09:30:17.000000Z","inspection_violations":[{"id":21807380,"change_date":"2026-07-23 21:40:00","inspection_id":"88492609","insp_violation_id":"275682742","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214775836","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-26T10:04:11.000000Z","updated_at":"2026-08-03T09:41:56.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":21753960,"change_date":"2026-07-23 21:40:00","inspection_id":"88492609","insp_unit_id":"214775836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"70548NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYCY0GHHN0513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-26T09:19:55.000000Z","updated_at":"2026-08-03T09:04:32.000000Z"}]},{"id":12474410,"change_date":"2026-07-17 21:41:00","inspection_id":"88435559","dot_number":"330753","report_state":"NY","report_number":"0L10500184","insp_date":"2026-07-14 00:00:00","insp_start_time":"1016","insp_end_time":"1041","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","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-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3778125","transaction_code":"A","transaction_date":"2026-07-17 00:00:00","upload_date":"2026-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-07-17 21:41:00","snet_input_date":"2026-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-17 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-20T09:42:31.000000Z","updated_at":"2026-07-28T09:30:25.000000Z","inspection_violations":[{"id":21719030,"change_date":"2026-07-17 21:41:00","inspection_id":"88435559","insp_violation_id":"275564234","seq_no":"1","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"214662639","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-20T10:08:03.000000Z","updated_at":"2026-07-28T09:42:03.000000Z","normalized_code":"39311A1LCHL"}],"inspection_per_units":[{"id":21666291,"change_date":"2026-07-17 21:41:00","inspection_id":"88435559","insp_unit_id":"214662639","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"9705","insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-20T09:20:42.000000Z","updated_at":"2026-07-28T09:01:35.000000Z"}]},{"id":12445156,"change_date":"2026-07-14 21:41:00","inspection_id":"88404862","dot_number":"330753","report_state":"NY","report_number":"0L79001229","insp_date":"2026-07-13 00:00:00","insp_start_time":"0842","insp_end_time":"0857","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2026-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3748229","transaction_code":"A","transaction_date":"2026-07-14 00:00:00","upload_date":"2026-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-07-14 21:41:00","snet_input_date":"2026-07-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-14 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-17T09:41:11.000000Z","updated_at":"2026-07-25T09:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21617596,"change_date":"2026-07-14 21:41:00","inspection_id":"88404862","insp_unit_id":"214606388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"48345MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDT8HHJG5154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-17T09:19:14.000000Z","updated_at":"2026-07-25T09:02:40.000000Z"}]},{"id":12453565,"change_date":"2026-07-15 21:42:00","inspection_id":"88413738","dot_number":"330753","report_state":"NY","report_number":"SPL3000409","insp_date":"2026-07-09 00:00:00","insp_start_time":"0811","insp_end_time":"0845","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","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-07-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3755949","transaction_code":"A","transaction_date":"2026-07-15 00:00:00","upload_date":"2026-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-07-15 21:42:00","snet_input_date":"2026-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-15 21:42:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-18T09:40:44.000000Z","updated_at":"2026-07-26T09:30:44.000000Z","inspection_violations":[{"id":21682408,"change_date":"2026-07-15 21:42:00","inspection_id":"88413738","insp_violation_id":"275515988","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"214622698","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-18T10:02:42.000000Z","updated_at":"2026-07-26T09:43:47.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":21631556,"change_date":"2026-07-15 21:42:00","inspection_id":"88413738","insp_unit_id":"214622698","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":null,"insp_unit_license":"34089ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W160J7901566","insp_unit_decal":"Y","insp_unit_decal_number":"36700702","created_at":"2026-07-18T09:20:13.000000Z","updated_at":"2026-07-26T09:02:21.000000Z"}]},{"id":12380848,"change_date":"2026-07-08 21:40:00","inspection_id":"88343744","dot_number":"330753","report_state":"NY","report_number":"SPL4050314","insp_date":"2026-07-02 00:00:00","insp_start_time":"0603","insp_end_time":"0621","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LINDENHURST NY","county_code_state":"NY","county_code":"103","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3706400","transaction_code":"A","transaction_date":"2026-07-08 00:00:00","upload_date":"2026-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-07-08 21:40:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-08 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-11T09:39:29.000000Z","updated_at":"2026-07-19T09:30:35.000000Z","inspection_violations":[{"id":21545515,"change_date":"2026-07-08 21:40:00","inspection_id":"88343744","insp_violation_id":"275350456","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:56:34.000000Z","updated_at":"2026-07-19T09:42:08.000000Z","normalized_code":"39216D"},{"id":21545516,"change_date":"2026-07-08 21:40:00","inspection_id":"88343744","insp_violation_id":"275350457","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214490712","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:56:34.000000Z","updated_at":"2026-07-19T09:42:08.000000Z","normalized_code":"39617CPI"},{"id":21545517,"change_date":"2026-07-08 21:40:00","inspection_id":"88343744","insp_violation_id":"275350458","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"214490712","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-11T09:56:34.000000Z","updated_at":"2026-07-19T09:42:08.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":21498441,"change_date":"2026-07-08 21:40:00","inspection_id":"88343744","insp_unit_id":"214490712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"93722NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALHCYCY4EDGA2248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-11T09:15:24.000000Z","updated_at":"2026-07-19T09:01:44.000000Z"}]},{"id":12026811,"change_date":"2026-05-27 21:40:00","inspection_id":"87966721","dot_number":"330753","report_state":"NY","report_number":"0L78001060","insp_date":"2026-05-22 00:00:00","insp_start_time":"1026","insp_end_time":"1041","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3410929","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:30.000000Z","updated_at":"2026-06-07T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20905056,"change_date":"2026-05-27 21:40:00","inspection_id":"87966721","insp_unit_id":"213771299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"20-3552","insp_unit_license":"83998MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN6LH534538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:33.000000Z","updated_at":"2026-06-07T09:02:12.000000Z"}]},{"id":12028360,"change_date":"2026-05-27 21:40:00","inspection_id":"87968367","dot_number":"330753","report_state":"NY","report_number":"0L78001055","insp_date":"2026-05-22 00:00:00","insp_start_time":"0826","insp_end_time":"0841","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2026-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3409326","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-05-27 21:40:00","snet_input_date":"2026-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:33.000000Z","updated_at":"2026-06-07T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20907549,"change_date":"2026-05-27 21:40:00","inspection_id":"87968367","insp_unit_id":"213774097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"48345MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDT8HHJG5154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:37.000000Z","updated_at":"2026-06-07T09:02:32.000000Z"}]},{"id":11573966,"change_date":"2026-04-06 21:37:00","inspection_id":"87498012","dot_number":"330753","report_state":"NY","report_number":"SPL3030991","insp_date":"2026-03-30 00:00:00","insp_start_time":"1220","insp_end_time":"1235","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"DIX HILLS NY","county_code_state":"NY","county_code":"103","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":"2026-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3118437","transaction_code":"A","transaction_date":"2026-04-05 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-03-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-09T09:49:06.000000Z","updated_at":"2026-04-17T09:35:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19836755,"change_date":"2026-04-06 21:37:00","inspection_id":"87498012","insp_unit_id":"212559042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"85216","insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:56.000000Z","updated_at":"2026-04-18T09:17:37.000000Z"}]},{"id":11413648,"change_date":"2026-03-19 21:38:00","inspection_id":"87329198","dot_number":"330753","report_state":"NY","report_number":"SPT3021687","insp_date":"2026-03-12 00:00:00","insp_start_time":"1435","insp_end_time":"1448","registration_date":null,"region":"ED","ci_status_code":"C","location":"82033","location_desc":"NEW ROCHELLE NY","county_code_state":"NY","county_code":"119","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32500","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":"3023467","transaction_code":"A","transaction_date":"2026-03-18 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-03-19 21:38:00","snet_input_date":"2026-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-19 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-22T09:50:41.000000Z","updated_at":"2026-03-30T09:30:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19550812,"change_date":"2026-03-19 21:38:00","inspection_id":"87329198","insp_unit_id":"212213296","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"13319","insp_unit_license":"21820MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAANX4H601707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:24.000000Z","updated_at":"2026-03-30T09:05:20.000000Z"}]},{"id":11159132,"change_date":"2026-02-18 21:38:00","inspection_id":"87074252","dot_number":"330753","report_state":"NY","report_number":"SPT3021580","insp_date":"2026-02-11 00:00:00","insp_start_time":"1713","insp_end_time":"1728","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"ELMSFORD NY","county_code_state":"NY","county_code":"119","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":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32900","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2899723","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-21T10:37:58.000000Z","updated_at":"2026-03-01T10:30:24.000000Z","inspection_violations":[{"id":18706307,"change_date":"2026-02-18 21:38:00","inspection_id":"87074252","insp_violation_id":"271866462","seq_no":"1","part_no":"393","part_no_section":"55C1-B","insp_viol_unit":"1","insp_unit_id":"211681314","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:35.000000Z","updated_at":"2026-03-01T10:40:00.000000Z","normalized_code":"39355C1B"}],"inspection_per_units":[{"id":19039009,"change_date":"2026-02-18 21:38:00","inspection_id":"87074252","insp_unit_id":"211681314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"13340","insp_unit_license":"53199JR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN24H601832","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:13:58.000000Z","updated_at":"2026-03-01T10:03:04.000000Z"}]},{"id":10504115,"change_date":"2025-12-23 21:38:00","inspection_id":"86639053","dot_number":"330753","report_state":"NY","report_number":"0L95002086","insp_date":"2025-12-18 00:00:00","insp_start_time":"0705","insp_end_time":"0738","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2025-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2692779","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:33.000000Z","updated_at":"2026-01-03T10:30:23.000000Z","inspection_violations":[{"id":17633225,"change_date":"2025-12-23 21:38:00","inspection_id":"86639053","insp_violation_id":"270858490","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"210768928","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:17.000000Z","updated_at":"2026-01-03T10:30:43.000000Z","normalized_code":"39395A1"},{"id":17633226,"change_date":"2025-12-23 21:38:00","inspection_id":"86639053","insp_violation_id":"270858491","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"210768928","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:17.000000Z","updated_at":"2026-01-03T10:30:43.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":17590369,"change_date":"2025-12-23 21:38:00","inspection_id":"86639053","insp_unit_id":"210768928","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"9705","insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:28.000000Z","updated_at":"2026-01-03T10:00:29.000000Z"}]},{"id":9932243,"change_date":"2025-10-14 21:41:00","inspection_id":"86038226","dot_number":"330753","report_state":"NY","report_number":"SPT3021168","insp_date":"2025-10-07 00:00:00","insp_start_time":"1705","insp_end_time":"1723","registration_date":null,"region":"ED","ci_status_code":"C","location":"82033","location_desc":"NEW ROCHELLE NY","county_code_state":"NY","county_code":"119","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-10-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32900","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":"2405200","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-10-14 21:41:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-14 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:29.000000Z","updated_at":"2025-10-18T10:00:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16484840,"change_date":"2025-10-14 21:41:00","inspection_id":"86038226","insp_unit_id":"209449505","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"13319","insp_unit_license":"21820MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAANX4H601707","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:40.000000Z","updated_at":"2025-10-18T09:45:14.000000Z"}]},{"id":9800320,"change_date":"2025-09-28 21:33:00","inspection_id":"85899714","dot_number":"330753","report_state":"NY","report_number":"0L80001781","insp_date":"2025-09-27 00:00:00","insp_start_time":"1041","insp_end_time":"1100","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"123","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-09-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"65920","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":"2338603","transaction_code":"A","transaction_date":"2025-09-28 00:00:00","upload_date":"2025-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-09-28 21:33:00","snet_input_date":"2025-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-28 21:33:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-01T10:00:19.000000Z","updated_at":"2025-10-02T10:00:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16241909,"change_date":"2025-09-28 21:33:00","inspection_id":"85899714","insp_unit_id":"209187669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"49883PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDV1KDKG4913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-01T09:45:19.000000Z","updated_at":"2025-10-02T09:45:11.000000Z"},{"id":16241910,"change_date":"2025-09-28 21:33:00","inspection_id":"85899714","insp_unit_id":"209187670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"3835D9","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9029JB123203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-01T09:45:19.000000Z","updated_at":"2025-10-02T09:45:11.000000Z"}]},{"id":9776363,"change_date":"2025-09-25 21:40:00","inspection_id":"85874487","dot_number":"330753","report_state":"NY","report_number":"SPM5010012","insp_date":"2025-09-18 00:00:00","insp_start_time":"1309","insp_end_time":"1324","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEW YORK NY","county_code_state":"NY","county_code":"061","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-09-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"2324396","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-09-25 21:40:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:00.000000Z","updated_at":"2025-09-30T10:00:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16196218,"change_date":"2025-09-25 21:40:00","inspection_id":"85874487","insp_unit_id":"209138137","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"12516MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYD21LHLY5793","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:46:33.000000Z","updated_at":"2025-09-29T09:46:33.000000Z"}]},{"id":9712924,"change_date":"2025-09-18 21:41:00","inspection_id":"85808358","dot_number":"330753","report_state":"NY","report_number":"SPD3031358","insp_date":"2025-09-11 00:00:00","insp_start_time":"0907","insp_end_time":"0926","registration_date":null,"region":"ED","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSICOLA","shipping_paper_number":"715441","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-09-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"2291613","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-09-18 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:59.000000Z","updated_at":"2025-09-23T10:01:59.000000Z","inspection_violations":[{"id":15941969,"change_date":"2025-09-18 21:41:00","inspection_id":"85808358","insp_violation_id":"268769819","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"209013822","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8D38KRKM7W","created_at":"2025-09-22T10:17:21.000000Z","updated_at":"2025-09-22T10:17:21.000000Z","normalized_code":"39311A1LIL"},{"id":15941970,"change_date":"2025-09-18 21:41:00","inspection_id":"85808358","insp_violation_id":"268769820","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"209013822","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:21.000000Z","updated_at":"2025-09-22T10:17:21.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":16080415,"change_date":"2025-09-18 21:41:00","inspection_id":"85808358","insp_unit_id":"209013822","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"85214","insp_unit_license":"15249ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXFC1JHJX6729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:48.000000Z","updated_at":"2025-09-22T09:45:17.000000Z"}]},{"id":9378040,"change_date":"2025-08-11 21:38:00","inspection_id":"85456396","dot_number":"330753","report_state":"NY","report_number":"0L10700523","insp_date":"2025-08-06 00:00:00","insp_start_time":"0710","insp_end_time":"0726","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MERRICK NY","county_code_state":"NY","county_code":"059","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-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2113879","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:25.000000Z","updated_at":"2025-08-15T10:43:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15451825,"change_date":"2025-08-11 21:38:00","inspection_id":"85456396","insp_unit_id":"208330744","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:30.000000Z","updated_at":"2025-08-15T09:45:38.000000Z"}]},{"id":9337720,"change_date":"2025-08-06 21:39:00","inspection_id":"85413923","dot_number":"330753","report_state":"NY","report_number":"0L96001110","insp_date":"2025-07-30 00:00:00","insp_start_time":"1510","insp_end_time":"1526","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"GARDEN CITY NY","county_code_state":"NY","county_code":"059","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-08-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2088699","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-08-06 21:39:00","snet_input_date":"2025-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-06 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:12.000000Z","updated_at":"2025-08-12T10:42:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15380531,"change_date":"2025-08-06 21:39:00","inspection_id":"85413923","insp_unit_id":"208253602","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:13.000000Z","updated_at":"2025-08-10T09:45:10.000000Z"}]},{"id":9185636,"change_date":"2025-07-18 21:39:00","inspection_id":"85254037","dot_number":"330753","report_state":"NY","report_number":"0L79000958","insp_date":"2025-07-14 00:00:00","insp_start_time":"0932","insp_end_time":"0947","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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-07-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2010621","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-07-18 21:39:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-18 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:31.000000Z","updated_at":"2025-07-22T10:44:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15095719,"change_date":"2025-07-18 21:39:00","inspection_id":"85254037","insp_unit_id":"207946301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"48345MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDT8HHJG5154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:33.000000Z","updated_at":"2025-07-22T09:45:32.000000Z"}]},{"id":9100594,"change_date":"2025-07-09 21:42:00","inspection_id":"85165098","dot_number":"330753","report_state":"NY","report_number":"0L95001611","insp_date":"2025-06-25 00:00:00","insp_start_time":"1420","insp_end_time":"1435","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1938105","transaction_code":"A","transaction_date":"2025-07-01 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-07-09 21:42:00","snet_input_date":"2025-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-09 21:42:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-12T10:45:22.000000Z","updated_at":"2025-07-14T10:46:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14938122,"change_date":"2025-07-09 21:42:00","inspection_id":"85165098","insp_unit_id":"207777042","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"85216","insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:51.000000Z","updated_at":"2025-07-13T09:46:07.000000Z"}]},{"id":8918269,"change_date":"2025-06-17 21:41:00","inspection_id":"84972211","dot_number":"330753","report_state":"NY","report_number":"0L55010442","insp_date":"2025-06-17 00:00:00","insp_start_time":"0839","insp_end_time":"0858","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1874901","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-06-17 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:54.000000Z","updated_at":"2025-06-22T10:00:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14614391,"change_date":"2025-06-17 21:41:00","inspection_id":"84972211","insp_unit_id":"207423209","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"36447NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD26SDVS3196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:03.000000Z","updated_at":"2025-06-22T09:45:38.000000Z"}]},{"id":8765250,"change_date":"2025-05-29 21:41:00","inspection_id":"84809871","dot_number":"330753","report_state":"NY","report_number":"0L10400088","insp_date":"2025-05-27 00:00:00","insp_start_time":"1312","insp_end_time":"1344","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"OLD WESTBURY NY","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI LONG ISLAND","shipping_paper_number":"B2077","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-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1795027","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-05-29 21:41:00","snet_input_date":"2025-05-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-29 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-01T10:01:19.000000Z","updated_at":"2025-06-04T10:00:23.000000Z","inspection_violations":[{"id":14003680,"change_date":"2025-05-29 21:41:00","inspection_id":"84809871","insp_violation_id":"266540112","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"207122357","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SRV2KD5S0P","created_at":"2025-06-01T10:17:28.000000Z","updated_at":"2025-06-02T10:17:11.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":14338975,"change_date":"2025-05-29 21:41:00","inspection_id":"84809871","insp_unit_id":"207122357","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"85216","insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:41.000000Z","updated_at":"2025-06-02T09:45:29.000000Z"}]},{"id":8501285,"change_date":"2025-04-30 21:51:00","inspection_id":"84531524","dot_number":"330753","report_state":"NY","report_number":"SPL3070440","insp_date":"2025-04-23 00:00:00","insp_start_time":"0715","insp_end_time":"0731","registration_date":null,"region":"ED","ci_status_code":"C","location":"00412E","location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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-30 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1657315","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-04-30 21:51:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:51:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:51.000000Z","updated_at":"2025-05-04T10:34:50.000000Z","inspection_violations":[{"id":13450614,"change_date":"2025-04-30 21:51:00","inspection_id":"84531524","insp_violation_id":"265902650","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206552970","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:11:02.000000Z","updated_at":"2025-05-03T10:54:05.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13817161,"change_date":"2025-04-30 21:51:00","inspection_id":"84531524","insp_unit_id":"206552970","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"37811PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDWTZR9RN332016","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:14:09.000000Z","updated_at":"2025-05-04T09:54:35.000000Z"},{"id":13817162,"change_date":"2025-04-30 21:51:00","inspection_id":"84531524","insp_unit_id":"206552971","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"1020D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA90288B707313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:14:09.000000Z","updated_at":"2025-05-04T09:54:35.000000Z"}]},{"id":8053642,"change_date":"2025-03-07 21:38:00","inspection_id":"84060070","dot_number":"330753","report_state":"NY","report_number":"0L55010349","insp_date":"2025-03-06 00:00:00","insp_start_time":"0821","insp_end_time":"0842","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FARMINGDALE NY","county_code_state":"NY","county_code":"059","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1443443","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-03-07 21:38:00","snet_input_date":"2025-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-07 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:26.000000Z","updated_at":"2025-03-17T21:05:26.000000Z","inspection_violations":[{"id":12587103,"change_date":"2025-03-07 21:38:00","inspection_id":"84060070","insp_violation_id":"264889150","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"205678305","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"K160K3DQFW","created_at":"2025-03-17T22:07:36.000000Z","updated_at":"2025-03-17T22:07:36.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":13002599,"change_date":"2025-03-07 21:38:00","inspection_id":"84060070","insp_unit_id":"205678305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"36447NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD26SDVS3196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:39.000000Z","updated_at":"2025-03-17T23:58:39.000000Z"}]},{"id":8040786,"change_date":"2025-03-06 21:39:00","inspection_id":"84046609","dot_number":"330753","report_state":"NY","report_number":"SPL3010439","insp_date":"2025-02-27 00:00:00","insp_start_time":"1044","insp_end_time":"1101","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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-03-06 21:39: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":"1434985","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:21.000000Z","updated_at":"2025-03-17T21:05:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12981484,"change_date":"2025-03-06 21:39:00","inspection_id":"84046609","insp_unit_id":"205653318","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"34326PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDWTZR5PN338179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:25.000000Z","updated_at":"2025-03-17T23:58:25.000000Z"},{"id":12981485,"change_date":"2025-03-06 21:39:00","inspection_id":"84046609","insp_unit_id":"205653319","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"2240","insp_unit_license":"CE64510","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9023PB503579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:25.000000Z","updated_at":"2025-03-17T23:58:25.000000Z"}]},{"id":7792709,"change_date":"2025-02-05 21:39:00","inspection_id":"83786275","dot_number":"330753","report_state":"NY","report_number":"0L10800105","insp_date":"2025-02-04 00:00:00","insp_start_time":"0713","insp_end_time":"0728","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BELLMORE NY","county_code_state":"NY","county_code":"059","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-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"1327862","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-02-05 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-05 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:56.000000Z","updated_at":"2025-03-17T20:59:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12576182,"change_date":"2025-02-05 21:39:00","inspection_id":"83786275","insp_unit_id":"205169343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:56.000000Z","updated_at":"2025-03-17T23:53:56.000000Z"}]},{"id":7732377,"change_date":"2025-01-29 21:40:00","inspection_id":"83722581","dot_number":"330753","report_state":"NY","report_number":"SPL3070275","insp_date":"2025-01-22 00:00:00","insp_start_time":"1553","insp_end_time":"1614","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"2","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":"1296814","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:43.000000Z","updated_at":"2025-03-17T20:58:43.000000Z","inspection_violations":[{"id":12082120,"change_date":"2025-01-29 21:40:00","inspection_id":"83722581","insp_violation_id":"264225046","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"205052170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:57.000000Z","updated_at":"2025-03-17T22:04:57.000000Z","normalized_code":"3939ALRLI"},{"id":12082121,"change_date":"2025-01-29 21:40:00","inspection_id":"83722581","insp_violation_id":"264225047","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"205052170","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:57.000000Z","updated_at":"2025-03-17T22:04:57.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":12478047,"change_date":"2025-01-29 21:40:00","inspection_id":"83722581","insp_unit_id":"205052169","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"33697PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HCDZAPR6KL307635","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12478048,"change_date":"2025-01-29 21:40:00","inspection_id":"83722581","insp_unit_id":"205052170","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"1017D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA90208B707208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":7733451,"change_date":"2025-01-29 21:40:00","inspection_id":"83723719","dot_number":"330753","report_state":"NY","report_number":"SPL3070276","insp_date":"2025-01-22 00:00:00","insp_start_time":"1615","insp_end_time":"1632","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1297875","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:43.000000Z","updated_at":"2025-03-17T20:58:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12479777,"change_date":"2025-01-29 21:40:00","inspection_id":"83723719","insp_unit_id":"205054047","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"84565PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDV9KDKG4903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"},{"id":12479778,"change_date":"2025-01-29 21:40:00","inspection_id":"83723719","insp_unit_id":"205054048","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"CF86885","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GR1A9627RB525384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:40.000000Z","updated_at":"2025-03-17T23:52:40.000000Z"}]},{"id":7624048,"change_date":"2025-01-15 21:41:00","inspection_id":"83609030","dot_number":"330753","report_state":"NY","report_number":"0L10000967","insp_date":"2025-01-15 00:00:00","insp_start_time":"1141","insp_end_time":"1159","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MANHASSET NY","county_code_state":"NY","county_code":"059","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250776","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[{"id":11917268,"change_date":"2025-01-15 21:41:00","inspection_id":"83609030","insp_violation_id":"264011346","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204843522","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"L182JX35K3","created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":12301907,"change_date":"2025-01-15 21:41:00","inspection_id":"83609030","insp_unit_id":"204843522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1312402","insp_unit_license":"36447NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3ALACXD26SDVS3196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:47.000000Z","updated_at":"2025-03-17T23:50:47.000000Z"}]},{"id":7613037,"change_date":"2025-01-14 21:54:00","inspection_id":"83597535","dot_number":"330753","report_state":"NY","report_number":"SPT3020596","insp_date":"2025-01-07 00:00:00","insp_start_time":"0936","insp_end_time":"0951","registration_date":null,"region":"ES","ci_status_code":"C","location":"82033","location_desc":"NEW ROCHELLE NY","county_code_state":"NY","county_code":"119","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-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1245673","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11901122,"change_date":"2025-01-14 21:54:00","inspection_id":"83597535","insp_violation_id":"263973020","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"204814145","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:00.000000Z","updated_at":"2025-03-17T22:04:00.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":12284078,"change_date":"2025-01-14 21:54:00","inspection_id":"83597535","insp_unit_id":"204814145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"1322310","insp_unit_license":"65738NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAEVTARXPL515568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:34.000000Z","updated_at":"2025-03-17T23:50:34.000000Z"}]},{"id":7484220,"change_date":"2024-12-23 21:39:00","inspection_id":"83462261","dot_number":"330753","report_state":"NY","report_number":"D110300672","insp_date":"2024-12-20 00:00:00","insp_start_time":"0748","insp_end_time":"0803","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BRONX NY","county_code_state":"NY","county_code":"005","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":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32900","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":"1188282","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:18.000000Z","updated_at":"2025-03-17T20:52:18.000000Z","inspection_violations":[{"id":11699738,"change_date":"2024-12-23 21:39:00","inspection_id":"83462261","insp_violation_id":"263627619","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204526095","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:57.000000Z","updated_at":"2025-03-17T22:02:57.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":12074255,"change_date":"2024-12-23 21:39:00","inspection_id":"83462261","insp_unit_id":"204526095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"18405PB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN04H601828","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:19.000000Z","updated_at":"2025-03-17T23:48:19.000000Z"}]},{"id":7290343,"change_date":"2024-11-27 21:39:00","inspection_id":"83258255","dot_number":"330753","report_state":"NY","report_number":"0L10000886","insp_date":"2024-11-21 00:00:00","insp_start_time":"0734","insp_end_time":"0750","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","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":"2024-11-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1095774","transaction_code":"A","transaction_date":"2024-11-26 00:00:00","upload_date":"2024-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-11-27 21:39:00","snet_input_date":"2024-11-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-27 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:10.000000Z","updated_at":"2025-03-17T20:48:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11759694,"change_date":"2024-11-27 21:39:00","inspection_id":"83258255","insp_unit_id":"204078902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"20-3552","insp_unit_license":"83998MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTEUMMN6LH534538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:52.000000Z","updated_at":"2025-03-17T23:44:52.000000Z"}]},{"id":7235496,"change_date":"2024-11-20 21:40:00","inspection_id":"83200346","dot_number":"330753","report_state":"NY","report_number":"SPL3030117","insp_date":"2024-11-13 00:00:00","insp_start_time":"0900","insp_end_time":"0915","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","viol_total":"2","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":"1072188","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11310417,"change_date":"2024-11-20 21:40:00","inspection_id":"83200346","insp_violation_id":"262989705","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"203964151","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3939ALFTSI"},{"id":11310418,"change_date":"2024-11-20 21:40:00","inspection_id":"83200346","insp_violation_id":"262989706","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"203964151","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":11670673,"change_date":"2024-11-20 21:40:00","inspection_id":"83200346","insp_unit_id":"203964151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"39017","insp_unit_license":"27936NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYD2XKHKV1976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7018832,"change_date":"2024-10-23 21:41:00","inspection_id":"82970766","dot_number":"330753","report_state":"NY","report_number":"SPL3070086","insp_date":"2024-10-16 00:00:00","insp_start_time":"1203","insp_end_time":"1219","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PLAINVIEW NY","county_code_state":"NY","county_code":"059","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":"2024-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"973205","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-10-23 21:41:00","snet_input_date":"2024-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-23 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:19.000000Z","updated_at":"2025-03-17T20:42:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11320568,"change_date":"2024-10-23 21:41:00","inspection_id":"82970766","insp_unit_id":"203534276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"42815PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHTDV3SSVS3578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:14.000000Z","updated_at":"2025-03-17T23:40:14.000000Z"},{"id":11320569,"change_date":"2024-10-23 21:41:00","inspection_id":"82970766","insp_unit_id":"203534277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":null,"insp_unit_license":"3839D9","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9027JB123202","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:14.000000Z","updated_at":"2025-03-17T23:40:14.000000Z"}]},{"id":6767592,"change_date":"2024-09-19 21:41:00","inspection_id":"82703506","dot_number":"330753","report_state":"NY","report_number":"SPWL011452","insp_date":"2024-09-18 00:00:00","insp_start_time":"1545","insp_end_time":"1618","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW","county_code_state":"NY","county_code":"059","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-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2951375","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10912892,"change_date":"2024-09-19 21:41:00","inspection_id":"82703506","insp_unit_id":"203025231","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1331907","insp_unit_license":"33696PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HCDZAPR0KL307632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"},{"id":10912893,"change_date":"2024-09-19 21:41:00","inspection_id":"82703506","insp_unit_id":"203025232","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"1028D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9028FB708698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:03.000000Z","updated_at":"2025-03-17T23:36:03.000000Z"}]},{"id":6756111,"change_date":"2024-09-18 21:42:00","inspection_id":"82691164","dot_number":"330753","report_state":"NY","report_number":"SPL0135971","insp_date":"2024-09-12 00:00:00","insp_start_time":"1027","insp_end_time":"1043","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2024-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2950957","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:58.000000Z","updated_at":"2025-03-17T20:36:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10894285,"change_date":"2024-09-18 21:42:00","inspection_id":"82691164","insp_unit_id":"203002117","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1332402","insp_unit_license":"42816PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJHTDV5SSVS3579","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:49.000000Z","updated_at":"2025-03-17T23:35:49.000000Z"},{"id":10894286,"change_date":"2024-09-18 21:42:00","inspection_id":"82691164","insp_unit_id":"203002118","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245436","insp_unit_license":"3842D9","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRA9021JB123213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:49.000000Z","updated_at":"2025-03-17T23:35:49.000000Z"}]},{"id":6666112,"change_date":"2024-09-06 21:40:00","inspection_id":"82595623","dot_number":"330753","report_state":"NY","report_number":"SPL0157125","insp_date":"2024-09-04 00:00:00","insp_start_time":"1115","insp_end_time":"1131","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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":"2024-09-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2949237","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-09-06 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-06 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:13.000000Z","updated_at":"2025-03-17T20:35:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10747675,"change_date":"2024-09-06 21:40:00","inspection_id":"82595623","insp_unit_id":"202797725","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:17.000000Z","updated_at":"2025-03-17T23:34:17.000000Z"}]},{"id":6429874,"change_date":"2024-08-09 21:38:00","inspection_id":"82343833","dot_number":"330753","report_state":"NY","report_number":"SPL0183468","insp_date":"2024-08-08 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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-08-09 21:38: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":"2943712","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:18.000000Z","updated_at":"2025-03-17T20:30:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10362700,"change_date":"2024-08-09 21:38:00","inspection_id":"82343833","insp_unit_id":"202315595","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1332315","insp_unit_license":"35591PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HSDWTZR0PN362325","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"},{"id":10362701,"change_date":"2024-08-09 21:38:00","inspection_id":"82343833","insp_unit_id":"202315596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"1059D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9022EB710042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:24.000000Z","updated_at":"2025-03-17T23:30:24.000000Z"}]},{"id":6204835,"change_date":"2024-07-12 21:39:00","inspection_id":"82102802","dot_number":"330753","report_state":"NY","report_number":"SPG0215833","insp_date":"2024-07-09 00:00:00","insp_start_time":"0930","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2024-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2936087","transaction_code":"A","transaction_date":"2024-07-12 00:00:00","upload_date":"2024-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-07-12 21:39:00","snet_input_date":"2024-07-12 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-12 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:45.000000Z","updated_at":"2025-03-17T20:25:45.000000Z","inspection_violations":[{"id":9637428,"change_date":"2024-07-12 21:39:00","inspection_id":"82102802","insp_violation_id":"260609672","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201855718","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:37.000000Z","updated_at":"2025-03-17T21:52:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9995884,"change_date":"2024-07-12 21:39:00","inspection_id":"82102802","insp_unit_id":"201855718","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"48345MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDT8HHJG5154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:36.000000Z","updated_at":"2025-03-17T23:26:36.000000Z"}]},{"id":6081931,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","dot_number":"330753","report_state":"NY","report_number":"SPT0550726","insp_date":"2024-06-25 00:00:00","insp_start_time":"0925","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"82033A","location_desc":"EXIT 17 S\/B RAMP","county_code_state":"NY","county_code":"119","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":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2932926","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:20.000000Z","updated_at":"2025-03-17T20:23:20.000000Z","inspection_violations":[{"id":9438707,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","insp_violation_id":"260323017","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201601212","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3922"},{"id":9438708,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","insp_violation_id":"260323018","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201601212","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3922"},{"id":9438709,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","insp_violation_id":"260323019","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"201601213","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9795824,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","insp_unit_id":"201601212","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"19619BR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2XPMAJ7X5RM688275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:27.000000Z","updated_at":"2025-03-17T23:24:27.000000Z"},{"id":9795825,"change_date":"2024-06-26 21:43:00","inspection_id":"81970767","insp_unit_id":"201601213","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"1071D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA56116B708422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:27.000000Z","updated_at":"2025-03-17T23:24:27.000000Z"}]},{"id":5751035,"change_date":"2024-05-15 21:42:00","inspection_id":"81612241","dot_number":"330753","report_state":"NY","report_number":"0L79000625","insp_date":"2024-05-14 00:00:00","insp_start_time":"0840","insp_end_time":"0859","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2024-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"483734","transaction_code":"A","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-05-15 21:42:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-15 21:42:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9262965,"change_date":"2024-05-15 21:42:00","inspection_id":"81612241","insp_unit_id":"200897206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"48344MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDTXHHJG5155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"}]},{"id":5705678,"change_date":"2024-05-09 21:41:00","inspection_id":"81562996","dot_number":"330753","report_state":"NY","report_number":"0L80001098","insp_date":"2024-05-03 00:00:00","insp_start_time":"0657","insp_end_time":"0704","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","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":"2024-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"467271","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-05-09 21:41:00","snet_input_date":"2024-05-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-09 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:52.000000Z","updated_at":"2025-03-17T20:15:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9190015,"change_date":"2024-05-09 21:41:00","inspection_id":"81562996","insp_unit_id":"200802897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"58006","insp_unit_license":"34089ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALE5W160J7901566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:33.000000Z","updated_at":"2025-03-17T23:18:33.000000Z"}]},{"id":5422134,"change_date":"2024-04-03 21:41:00","inspection_id":"81253856","dot_number":"330753","report_state":"NY","report_number":"0L80001003","insp_date":"2024-04-03 00:00:00","insp_start_time":"0733","insp_end_time":"0738","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WOODBURY NY","county_code_state":"NY","county_code":"059","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":"2024-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"366128","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-04-03 21:41:00","snet_input_date":"2024-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-03 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:15.000000Z","updated_at":"2025-03-17T20:10:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8733496,"change_date":"2024-04-03 21:41:00","inspection_id":"81253856","insp_unit_id":"200208279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"70595NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN74H601678","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:13.000000Z","updated_at":"2025-03-17T23:14:13.000000Z"}]},{"id":5188319,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","dot_number":"330753","report_state":"NY","report_number":"SPK0195676","insp_date":"2024-02-28 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":"80503","location_desc":"MAMARONECK","county_code_state":"NY","county_code":"119","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":"2024-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2909926","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-03-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7996092,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_violation_id":"258150373","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199707589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3963A1"},{"id":7996093,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_violation_id":"258150374","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199707589","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"},{"id":7996094,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_violation_id":"258150375","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199707589","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3939A"},{"id":7996095,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_violation_id":"258150376","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199707589","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3939A"},{"id":7996096,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_violation_id":"258150377","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8353877,"change_date":"2024-03-01 21:39:00","inspection_id":"80998579","insp_unit_id":"199707589","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"12349","insp_unit_license":"29520MB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN0CH116197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4706751,"change_date":"2023-12-27 21:41:00","inspection_id":"80472867","dot_number":"330753","report_state":"NY","report_number":"0L79000081","insp_date":"2023-12-26 00:00:00","insp_start_time":"0930","insp_end_time":"0943","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SYOSSET NY","county_code_state":"NY","county_code":"059","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":"2023-12-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"146437","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2023-12-27 21:41:00","snet_input_date":"2023-12-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-27 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:09.000000Z","updated_at":"2025-03-17T19:56:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7570592,"change_date":"2023-12-27 21:41:00","inspection_id":"80472867","insp_unit_id":"198673261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:41.000000Z","updated_at":"2025-03-17T23:03:41.000000Z"}]},{"id":4808551,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","dot_number":"330753","report_state":"NY","report_number":"0L93000057","insp_date":"2023-12-20 00:00:00","insp_start_time":"1146","insp_end_time":"1222","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FLANDERS NY","county_code_state":"NY","county_code":"103","insp_level_id":"1","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":"2024-01-11 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"140278","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2024-01-11 21:45:00","snet_input_date":"2023-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-11 21:45:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:01.000000Z","updated_at":"2025-03-17T19:58:01.000000Z","inspection_violations":[{"id":7416673,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_violation_id":"257287117","seq_no":"1","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"198910252","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3939ALSML"},{"id":7416674,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_violation_id":"257287118","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"198910252","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3963A1BOS"},{"id":7416675,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_violation_id":"257287119","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"198910252","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39347E"},{"id":7416676,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_violation_id":"257287120","seq_no":"4","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"198910252","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39353BB"},{"id":7416677,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_violation_id":"257287121","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"198910252","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":7736459,"change_date":"2024-01-11 21:45:00","inspection_id":"80583858","insp_unit_id":"198910252","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"48345MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDT8HHJG5154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:09.000000Z","updated_at":"2025-03-17T23:05:09.000000Z"}]},{"id":4387799,"change_date":"2023-11-09 21:40:00","inspection_id":"80122445","dot_number":"330753","report_state":"NY","report_number":"0L95000043","insp_date":"2023-11-09 00:00:00","insp_start_time":"1218","insp_end_time":"1241","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SEAFORD NY","county_code_state":"NY","county_code":"059","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":"2023-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53220","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":"91755","transaction_code":"A","transaction_date":"2023-11-09 00:00:00","upload_date":"2023-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2023-11-09 21:40:00","snet_input_date":"2023-11-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-09 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:52.000000Z","updated_at":"2025-03-17T19:49:52.000000Z","inspection_violations":[{"id":6790095,"change_date":"2023-11-09 21:40:00","inspection_id":"80122445","insp_violation_id":"256303249","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"L182HCWNC1","created_at":"2025-03-17T21:38:41.000000Z","updated_at":"2025-03-17T21:38:41.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":7056867,"change_date":"2023-11-09 21:40:00","inspection_id":"80122445","insp_unit_id":"197978832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"AM320","insp_unit_license":"27940NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVHCYD21KHKV1977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:14.000000Z","updated_at":"2025-03-17T22:59:14.000000Z"}]},{"id":4141125,"change_date":"2023-10-06 21:40:00","inspection_id":"79849587","dot_number":"330753","report_state":"NY","report_number":"SPT0473175","insp_date":"2023-10-05 00:00:00","insp_start_time":"1105","insp_end_time":"1126","registration_date":null,"region":"ET","ci_status_code":"C","location":"82033A","location_desc":"NEW ROCHELLE I-95 S\/B EXIT 17","county_code_state":"NY","county_code":"119","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-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2876210","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-10-06 21:40:00","snet_input_date":"2023-10-06 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[{"id":6410251,"change_date":"2023-10-06 21:40:00","inspection_id":"79849587","insp_violation_id":"255695483","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"197430630","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":6658464,"change_date":"2023-10-06 21:40:00","inspection_id":"79849587","insp_unit_id":"197430629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"072850","insp_unit_license":"25929TC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSMMAAR37H429919","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"},{"id":6658465,"change_date":"2023-10-06 21:40:00","inspection_id":"79849587","insp_unit_id":"197430630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"1071D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA56116B708422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":4212688,"change_date":"2023-10-17 21:41:00","inspection_id":"79928602","dot_number":"330753","report_state":"NY","report_number":"0L88000723","insp_date":"2023-10-03 00:00:00","insp_start_time":"1021","insp_end_time":"1037","registration_date":null,"region":"ET","ci_status_code":"C","location":"3052","location_desc":"LIE EXIT 36","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"2879479","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-10-17 21:41:00","snet_input_date":"2023-10-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-17 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:15.000000Z","updated_at":"2025-03-17T19:46:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6774451,"change_date":"2023-10-17 21:41:00","inspection_id":"79928602","insp_unit_id":"197589286","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"91122NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HA3GSCG4LN009705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:46.000000Z","updated_at":"2025-03-17T22:56:46.000000Z"}]},{"id":4111217,"change_date":"2023-10-03 21:40:00","inspection_id":"79816466","dot_number":"330753","report_state":"NY","report_number":"1021002352","insp_date":"2023-10-02 00:00:00","insp_start_time":"1141","insp_end_time":"1208","registration_date":null,"region":"ET","ci_status_code":"C","location":"00386","location_desc":"LEVITTOWN TRI COUNTY LOT","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2875151","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[{"id":6362013,"change_date":"2023-10-03 21:40:00","inspection_id":"79816466","insp_violation_id":"255618447","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197363505","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3963A1"},{"id":6362014,"change_date":"2023-10-03 21:40:00","inspection_id":"79816466","insp_violation_id":"255618448","seq_no":"2","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"197363505","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"393209E"}],"inspection_per_units":[{"id":6610044,"change_date":"2023-10-03 21:40:00","inspection_id":"79816466","insp_unit_id":"197363505","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"AF693","insp_unit_license":"60138MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN8DH160045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:28.000000Z","updated_at":"2025-03-17T22:55:28.000000Z"}]},{"id":4019430,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","dot_number":"330753","report_state":"NY","report_number":"SPWL081274","insp_date":"2023-09-20 00:00:00","insp_start_time":"1436","insp_end_time":"1509","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"2871012","transaction_code":"A","transaction_date":"2023-09-21 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:05.000000Z","updated_at":"2025-03-17T19:42:05.000000Z","inspection_violations":[{"id":6221699,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","insp_violation_id":"255390932","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197157234","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39378"},{"id":6221700,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","insp_violation_id":"255390933","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"1","insp_unit_id":"197157234","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"39355E"},{"id":6221701,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","insp_violation_id":"255390934","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197157235","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6462768,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","insp_unit_id":"197157234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"67125","insp_unit_license":"78143PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHXSBR77J406617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:15.000000Z","updated_at":"2025-03-17T22:54:15.000000Z"},{"id":6462769,"change_date":"2023-09-21 21:40:00","inspection_id":"79714198","insp_unit_id":"197157235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"1055D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9026FB708702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:15.000000Z","updated_at":"2025-03-17T22:54:15.000000Z"}]},{"id":4010374,"change_date":"2023-09-20 21:39:00","inspection_id":"79704194","dot_number":"330753","report_state":"NY","report_number":"1019008897","insp_date":"2023-09-19 00:00:00","insp_start_time":"0908","insp_end_time":"0923","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634","location_desc":"BELLMORE RAILROAD STATION","county_code_state":"NY","county_code":"059","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2870303","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:02.000000Z","updated_at":"2025-03-17T19:42:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6448417,"change_date":"2023-09-20 21:39:00","inspection_id":"79704194","insp_unit_id":"197138030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"48344MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXDTTXHHJG515","insp_unit_decal":"Y","insp_unit_decal_number":"33074036","created_at":"2025-03-17T22:54:08.000000Z","updated_at":"2025-03-17T22:54:08.000000Z"}]},{"id":3361576,"change_date":"2023-06-26 21:40:00","inspection_id":"78978531","dot_number":"330753","report_state":"NY","report_number":"SPL0135123","insp_date":"2023-06-20 00:00:00","insp_start_time":"1114","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2023-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2841107","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2023-06-26 21:40:00","snet_input_date":"2023-06-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-26 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"113561428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:43.000000Z","updated_at":"2025-03-17T19:29:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5403595,"change_date":"2023-06-26 21:40:00","inspection_id":"78978531","insp_unit_id":"195666693","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1331907","insp_unit_license":"33696PF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HCDZAPR0KL307632","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:37.000000Z","updated_at":"2025-03-17T22:45:37.000000Z"},{"id":5403596,"change_date":"2023-06-26 21:40:00","inspection_id":"78978531","insp_unit_id":"195666694","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245330","insp_unit_license":"1036D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA90276B706912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:37.000000Z","updated_at":"2025-03-17T22:45:37.000000Z"}]},{"id":2405729,"change_date":"2023-02-21 21:40:00","inspection_id":"77895490","dot_number":"330753","report_state":"NY","report_number":"0L13001011","insp_date":"2023-02-13 00:00:00","insp_start_time":"1325","insp_end_time":"1337","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N\/B @14 135 SY","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2800823","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":null,"census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:02.000000Z","updated_at":"2025-03-17T19:11:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3871287,"change_date":"2023-02-21 21:40:00","inspection_id":"77895490","insp_unit_id":"193480071","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:44.000000Z","updated_at":"2025-03-17T22:33:44.000000Z"}]},{"id":2250869,"change_date":"2023-01-30 21:43:00","inspection_id":"77719082","dot_number":"330753","report_state":"NY","report_number":"SPL0191332","insp_date":"2023-01-26 00:00:00","insp_start_time":"0843","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"00096F","location_desc":"YAPHANK (EB)","county_code_state":"NY","county_code":"103","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":"2023-01-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2792917","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2023-01-30 21:43:00","snet_input_date":"2023-01-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-01-30 21:43:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:08.000000Z","updated_at":"2025-03-17T19:08:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3622561,"change_date":"2023-01-30 21:43:00","inspection_id":"77719082","insp_unit_id":"193118440","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"12488MP","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXD24LHLY5797","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:58.000000Z","updated_at":"2025-03-17T22:31:58.000000Z"}]},{"id":1980329,"change_date":"2022-12-20 21:40:00","inspection_id":"77409580","dot_number":"330753","report_state":"NY","report_number":"SPD0224518","insp_date":"2022-12-14 00:00:00","insp_start_time":"0800","insp_end_time":"0819","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PEPSI COLA BOTTLING CO OF NEW YORK","shipping_paper_number":"655458","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-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2781702","transaction_code":"A","transaction_date":"2022-12-20 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-12-20 21:40:00","snet_input_date":"2022-12-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-20 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:16.000000Z","updated_at":"2025-03-17T19:03:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3186034,"change_date":"2022-12-20 21:40:00","inspection_id":"77409580","insp_unit_id":"192500499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"15249ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FVACXFC1JHJX6729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:49.000000Z","updated_at":"2025-03-17T22:28:49.000000Z"}]},{"id":1815420,"change_date":"2022-11-28 21:40:00","inspection_id":"77221002","dot_number":"330753","report_state":"NY","report_number":"SPT0520753","insp_date":"2022-11-25 00:00:00","insp_start_time":"1257","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"80342","location_desc":"TARRYTOWN","county_code_state":"NY","county_code":"119","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":"Y","pen_cen_match":null,"final_status_date":"2022-11-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2774374","transaction_code":"A","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-11-28 21:40:00","snet_input_date":"2022-11-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-28 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:01.000000Z","updated_at":"2025-03-17T19:00:01.000000Z","inspection_violations":[{"id":2837788,"change_date":"2022-11-28 21:40:00","inspection_id":"77221002","insp_violation_id":"249789088","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:20:26.000000Z","updated_at":"2025-03-17T21:20:26.000000Z","normalized_code":"38323A2"},{"id":2837789,"change_date":"2022-11-28 21:40:00","inspection_id":"77221002","insp_violation_id":"249789089","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192129208","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:26.000000Z","updated_at":"2025-03-17T21:20:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2919915,"change_date":"2022-11-28 21:40:00","inspection_id":"77221002","insp_unit_id":"192129208","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"12351","insp_unit_license":"29521MB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMMAAN2CH116203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:58.000000Z","updated_at":"2025-03-17T22:26:58.000000Z"}]},{"id":1631555,"change_date":"2022-10-31 21:40:00","inspection_id":"77009926","dot_number":"330753","report_state":"NY","report_number":"SPL0182149","insp_date":"2022-10-26 00:00:00","insp_start_time":"0925","insp_end_time":"0942","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2022-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764260","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-10-31 21:40:00","snet_input_date":"2022-10-31 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-10-31 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:41.000000Z","updated_at":"2025-03-17T18:56:41.000000Z","inspection_violations":[{"id":2561106,"change_date":"2022-10-31 21:40:00","inspection_id":"77009926","insp_violation_id":"249327068","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191710234","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:06.000000Z","updated_at":"2025-03-17T21:19:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2624463,"change_date":"2022-10-31 21:40:00","inspection_id":"77009926","insp_unit_id":"191710234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"27937NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMSAAR77H535761","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:59.000000Z","updated_at":"2025-03-17T22:24:59.000000Z"}]},{"id":1643094,"change_date":"2022-11-01 21:40:00","inspection_id":"77023223","dot_number":"330753","report_state":"NY","report_number":"SPL0078177","insp_date":"2022-10-12 00:00:00","insp_start_time":"1321","insp_end_time":"1336","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","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":"2022-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2764794","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-11-01 21:40:00","snet_input_date":"2022-11-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-01 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:01.000000Z","updated_at":"2025-03-17T18:57:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2643470,"change_date":"2022-11-01 21:40:00","inspection_id":"77023223","insp_unit_id":"191738408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"69152","insp_unit_license":"84567PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3AKJGEDVXKDKG4909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:07.000000Z","updated_at":"2025-03-17T22:25:07.000000Z"},{"id":2643471,"change_date":"2022-11-01 21:40:00","inspection_id":"77023223","insp_unit_id":"191738409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245396","insp_unit_license":"4918D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA9022GB714739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:07.000000Z","updated_at":"2025-03-17T22:25:07.000000Z"}]},{"id":589872,"change_date":"2022-06-13 21:41:00","inspection_id":"75795559","dot_number":"330753","report_state":"NY","report_number":"SPK0194379","insp_date":"2022-06-08 00:00:00","insp_start_time":"1145","insp_end_time":"1205","registration_date":null,"region":"ET","ci_status_code":"C","location":"80687","location_desc":"POUND RIDGE","county_code_state":"NY","county_code":"119","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-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2715863","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-06-13 21:41:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-13 21:41:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:05.000000Z","updated_at":"2025-03-17T18:38:05.000000Z","inspection_violations":[{"id":925409,"change_date":"2022-06-13 21:41:00","inspection_id":"75795559","insp_violation_id":"246399702","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189195064","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"3922"},{"id":925410,"change_date":"2022-06-13 21:41:00","inspection_id":"75795559","insp_violation_id":"246399703","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189195064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:22.000000Z","updated_at":"2025-03-17T21:11:22.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":947711,"change_date":"2022-06-13 21:41:00","inspection_id":"75795559","insp_unit_id":"189195064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"67118","insp_unit_license":"35810TR","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HSHXAHR27J412391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"},{"id":947712,"change_date":"2022-06-13 21:41:00","inspection_id":"75795559","insp_unit_id":"189195065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"245346","insp_unit_license":"1012D7","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GRAA902X8B707314","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:02.000000Z","updated_at":"2025-03-17T22:14:02.000000Z"}]},{"id":285123,"change_date":"2022-04-29 21:40:00","inspection_id":"75433366","dot_number":"330753","report_state":"NY","report_number":"0L21002669","insp_date":"2022-04-28 00:00:00","insp_start_time":"1440","insp_end_time":"1538","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PATCHOGUE","county_code_state":"NY","county_code":"103","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2700390","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00330753","upload_search_indicator":"M","census_search_date":"2022-04-29 21:40:00","snet_input_date":"2022-04-29 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-29 21:40:00","insp_carrier_name":"PEPSI COLA BOTTLING CO OF NEW YORK INC","insp_carrier_street":"112-02 15TH AVE","insp_carrier_city":"COLLEGE POINT","insp_carrier_state":"NY","insp_carrier_zip_code":"11356-1428","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:34.000000Z","updated_at":"2025-03-17T18:32:34.000000Z","inspection_violations":[{"id":444842,"change_date":"2022-04-29 21:40:00","inspection_id":"75433366","insp_violation_id":"245469660","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188417051","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"H923FD62HT","created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"3922"},{"id":444843,"change_date":"2022-04-29 21:40:00","inspection_id":"75433366","insp_violation_id":"245469661","seq_no":"2","part_no":"393","part_no_section":"207(c)","insp_viol_unit":"1","insp_unit_id":"188417051","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"H923FD61Q9","created_at":"2025-03-17T21:09:10.000000Z","updated_at":"2025-03-17T21:09:10.000000Z","normalized_code":"393207C"}],"inspection_per_units":[{"id":461532,"change_date":"2022-04-29 21:40:00","inspection_id":"75433366","insp_unit_id":"188417051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"84024MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3HAWGSTR1GL210143","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:02.000000Z","updated_at":"2025-03-17T22:11:02.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/330753\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/330753\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/330753\/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\/330753\/inspections","per_page":100,"prev_page_url":null,"to":60,"total":60}