{"current_page":1,"data":[{"id":11849104,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","dot_number":"966888","report_state":"HI","report_number":"CT31001085","insp_date":"2026-05-06 00:00:00","insp_start_time":"1217","insp_end_time":"1342","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PEPSICO","shipping_paper_number":"110725266","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-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"100000","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":"3279257","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:33.000000Z","updated_at":"2026-05-18T09:30:57.000000Z","inspection_violations":[{"id":20607431,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","insp_violation_id":"274108895","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213431312","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:44.000000Z","updated_at":"2026-05-18T09:42:09.000000Z","normalized_code":"3922SLLSR"},{"id":20607432,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","insp_violation_id":"274108896","seq_no":"2","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"1","insp_unit_id":"213431312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:44.000000Z","updated_at":"2026-05-18T09:42:09.000000Z","normalized_code":"39311A1LCHL"},{"id":20607433,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","insp_violation_id":"274108897","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"213431313","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-10T09:58:44.000000Z","updated_at":"2026-05-18T09:42:09.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":20605766,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","insp_unit_id":"213431312","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"V21080","insp_unit_license":"466HEP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HCEUTAN9NL184065","insp_unit_decal":"Y","insp_unit_decal_number":"36452012","created_at":"2026-05-10T09:18:50.000000Z","updated_at":"2026-05-18T09:03:19.000000Z"},{"id":20605767,"change_date":"2026-05-07 21:40:00","inspection_id":"87785093","insp_unit_id":"213431313","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"G19320","insp_unit_license":"543WEX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GR1A8025LB185422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:50.000000Z","updated_at":"2026-05-18T09:03:19.000000Z"}]},{"id":11234743,"change_date":"2026-02-26 21:40:00","inspection_id":"87147159","dot_number":"966888","report_state":"HI","report_number":"CU42000855","insp_date":"2026-02-23 00:00:00","insp_start_time":"1136","insp_end_time":"1224","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"101000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2937645","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:52.000000Z","updated_at":"2026-03-09T09:31:25.000000Z","inspection_violations":[{"id":18862744,"change_date":"2026-02-26 21:40:00","inspection_id":"87147159","insp_violation_id":"272050299","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-26-037106","created_at":"2026-03-01T10:56:33.000000Z","updated_at":"2026-03-09T09:43:58.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":19204263,"change_date":"2026-02-26 21:40:00","inspection_id":"87147159","insp_unit_id":"211848176","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"G123291","insp_unit_license":"121WFD","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3V322K1RJ491801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:41.000000Z","updated_at":"2026-03-09T09:07:27.000000Z"},{"id":19204262,"change_date":"2026-02-26 21:40:00","inspection_id":"87147159","insp_unit_id":"211848175","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"V22405","insp_unit_license":"911TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HCEUTANXPL511947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:41.000000Z","updated_at":"2026-03-09T09:07:27.000000Z"}]},{"id":9163737,"change_date":"2025-10-07 21:40:00","inspection_id":"85230981","dot_number":"966888","report_state":"HI","report_number":"CU42000702","insp_date":"2025-07-15 00:00:00","insp_start_time":"0845","insp_end_time":"0856","registration_date":"2025-07-16 00:00:00","region":"HS","ci_status_code":"C","location":"101","location_desc":"KANEOHE HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","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-07-16 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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2000924","transaction_code":"C","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2025-07-16 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-16 21:41:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:39.000000Z","updated_at":"2025-10-11T10:00:05.000000Z","inspection_violations":[{"id":16267189,"change_date":"2025-10-07 21:40:00","inspection_id":"85230981","insp_violation_id":"269136428","seq_no":"1","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"209331787","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:10.000000Z","normalized_code":"3922SLLEQP"},{"id":16267190,"change_date":"2025-10-07 21:40:00","inspection_id":"85230981","insp_violation_id":"269136429","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"2","insp_unit_id":"209331788","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:10.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":16375419,"change_date":"2025-10-07 21:40:00","inspection_id":"85230981","insp_unit_id":"209331787","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"V24032","insp_unit_license":"692TYG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDVXSDVP5181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:35.000000Z","updated_at":"2025-10-11T09:45:08.000000Z"},{"id":16375420,"change_date":"2025-10-07 21:40:00","inspection_id":"85230981","insp_unit_id":"209331788","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"G19180","insp_unit_license":"501WEX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GR1A8028KB169679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:35.000000Z","updated_at":"2025-10-11T09:45:08.000000Z"}]},{"id":7368024,"change_date":"2024-12-09 21:40:00","inspection_id":"83340223","dot_number":"966888","report_state":"HI","report_number":"CM17000928","insp_date":"2024-12-05 00:00:00","insp_start_time":"1136","insp_end_time":"1230","registration_date":null,"region":"HS","ci_status_code":"C","location":null,"location_desc":"WAILUKU HI","county_code_state":"HI","county_code":"009","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BOTTLING GROUP LLC","shipping_paper_number":"579278","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1135975","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2024-12-09 21:40:00","snet_input_date":"2024-12-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-09 21:40:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:48.000000Z","updated_at":"2025-03-17T20:49:48.000000Z","inspection_violations":[{"id":11513973,"change_date":"2024-12-09 21:40:00","inspection_id":"83340223","insp_violation_id":"263322970","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204262206","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:01.000000Z","updated_at":"2025-03-17T22:02:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11886021,"change_date":"2024-12-09 21:40:00","inspection_id":"83340223","insp_unit_id":"204262206","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"V18058","insp_unit_license":"859MDX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUJGBDV4KLKT9966","insp_unit_decal":"Y","insp_unit_decal_number":"34711926","created_at":"2025-03-17T23:46:16.000000Z","updated_at":"2025-03-17T23:46:16.000000Z"},{"id":11886022,"change_date":"2024-12-09 21:40:00","inspection_id":"83340223","insp_unit_id":"204262207","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"F53381","insp_unit_license":"856WEW","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GRAA8029JK133305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:16.000000Z","updated_at":"2025-03-17T23:46:16.000000Z"}]},{"id":7334768,"change_date":"2024-12-04 21:41:00","inspection_id":"83305114","dot_number":"966888","report_state":"HI","report_number":"CQ41000442","insp_date":"2024-12-02 00:00:00","insp_start_time":"1034","insp_end_time":"1049","registration_date":null,"region":"HS","ci_status_code":"C","location":"27","location_desc":"LAIE HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-04 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":"1118181","transaction_code":"A","transaction_date":"2024-12-04 00:00:00","upload_date":"2024-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2024-12-04 21:41:00","snet_input_date":"2024-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-04 21:41:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:00.000000Z","updated_at":"2025-03-17T20:49:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11832304,"change_date":"2024-12-04 21:41:00","inspection_id":"83305114","insp_unit_id":"204171623","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"V18059","insp_unit_license":"814TYC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUJGBDV6KLKT9967","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"},{"id":11832305,"change_date":"2024-12-04 21:41:00","inspection_id":"83305114","insp_unit_id":"204171624","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"G19349","insp_unit_license":"999WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GR1A9620LB185258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:39.000000Z","updated_at":"2025-03-17T23:45:39.000000Z"}]},{"id":6033840,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","dot_number":"966888","report_state":"HI","report_number":"BP16003078","insp_date":"2024-06-19 00:00:00","insp_start_time":"0917","insp_end_time":"1013","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"586913","transaction_code":"A","transaction_date":"2024-06-20 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2024-06-20 21:43:00","snet_input_date":"2024-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:16.000000Z","updated_at":"2025-03-17T20:22:16.000000Z","inspection_violations":[{"id":9360536,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_violation_id":"260205268","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201500302","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"3922"},{"id":9360537,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_violation_id":"260205269","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201500302","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"3922"},{"id":9360538,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_violation_id":"260205270","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"201500302","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"39345D"},{"id":9360539,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_violation_id":"260205271","seq_no":"4","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"201500302","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":9718464,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_unit_id":"201500302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"546706","insp_unit_license":"T28431","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHLDVXMSNB0518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:42.000000Z","updated_at":"2025-03-17T23:23:42.000000Z"},{"id":9718465,"change_date":"2024-06-20 21:43:00","inspection_id":"81918977","insp_unit_id":"201500303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"G19172","insp_unit_license":"503WEX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GR1A8021KB169670","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:42.000000Z","updated_at":"2025-03-17T23:23:42.000000Z"}]},{"id":5638663,"change_date":"2024-05-01 21:42:00","inspection_id":"81490113","dot_number":"966888","report_state":"HI","report_number":"BP16003031","insp_date":"2024-04-30 00:00:00","insp_start_time":"0850","insp_end_time":"0948","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI - KALAELOA BOULEVARD","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"442602","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2024-05-01 21:42:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-01 21:42:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:21.000000Z","updated_at":"2025-03-17T20:14:21.000000Z","inspection_violations":[{"id":8720133,"change_date":"2024-05-01 21:42:00","inspection_id":"81490113","insp_violation_id":"259240150","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"200662426","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39021TB2"},{"id":8720134,"change_date":"2024-05-01 21:42:00","inspection_id":"81490113","insp_violation_id":"259240151","seq_no":"2","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:14.000000Z","updated_at":"2025-03-17T21:48:14.000000Z","normalized_code":"39111B5"}],"inspection_per_units":[{"id":9082661,"change_date":"2024-05-01 21:42:00","inspection_id":"81490113","insp_unit_id":"200662426","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"F90948","insp_unit_license":"431TVN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JHHRDM2H4FK002088","insp_unit_decal":"Y","insp_unit_decal_number":"34087472","created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"}]},{"id":4915220,"change_date":"2024-01-29 21:38:00","inspection_id":"80700447","dot_number":"966888","report_state":"HI","report_number":"CB44001576","insp_date":"2024-01-23 00:00:00","insp_start_time":"1335","insp_end_time":"1345","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"199713","transaction_code":"A","transaction_date":"2024-01-28 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2024-01-29 21:38:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-29 21:38:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:04.000000Z","updated_at":"2025-03-17T20:00:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7909539,"change_date":"2024-01-29 21:38:00","inspection_id":"80700447","insp_unit_id":"199137695","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"18554","insp_unit_license":"529KBT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XPBDK9X7KD630990","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:41.000000Z","updated_at":"2025-03-17T23:06:41.000000Z"}]},{"id":3085498,"change_date":"2023-05-24 21:40:00","inspection_id":"78667150","dot_number":"966888","report_state":"HI","report_number":"CM17000674","insp_date":"2023-05-17 00:00:00","insp_start_time":"0947","insp_end_time":"1010","registration_date":"2023-05-08 00:00:00","region":"HT","ci_status_code":"C","location":"65","location_desc":"KAHULUI","county_code_state":"HI","county_code":"009","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"BOTTLING GROUP LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"133975","transaction_code":"C","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"221 WAKEA AVE UNIT 22-32","insp_carrier_city":"KAHULUI","insp_carrier_state":"HI","insp_carrier_zip_code":"96732","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[{"id":4742739,"change_date":"2023-05-24 21:40:00","inspection_id":"78667150","insp_violation_id":"253055951","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"195123380","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:07.000000Z","updated_at":"2025-03-17T21:29:07.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":4963438,"change_date":"2023-05-24 21:40:00","inspection_id":"78667150","insp_unit_id":"195123380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F47377","insp_unit_license":"693MCZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXF46P44EB05654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":2235931,"change_date":"2023-01-26 21:42:00","inspection_id":"77702041","dot_number":"966888","report_state":"HI","report_number":"00CB001404","insp_date":"2023-01-25 00:00:00","insp_start_time":"1310","insp_end_time":"1320","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133344","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2023-01-26 21:42:00","snet_input_date":"2023-01-26 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-01-26 21:42:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:46.000000Z","updated_at":"2025-03-17T19:07:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3599106,"change_date":"2023-01-26 21:42:00","inspection_id":"77702041","insp_unit_id":"193086586","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"V18056","insp_unit_license":"504TXP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUJGBDV0KLKT9964","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:48.000000Z","updated_at":"2025-03-17T22:31:48.000000Z"}]},{"id":1406195,"change_date":"2022-09-29 21:41:00","inspection_id":"76750113","dot_number":"966888","report_state":"HI","report_number":"00CK001517","insp_date":"2022-09-28 00:00:00","insp_start_time":"1006","insp_end_time":"1036","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CONSIGNEE: HONOLULU COMMUNITY COLLEGE","shipping_paper_number":"9754278","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-09-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132508","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2022-09-29 21:41:00","snet_input_date":"2022-09-29 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-09-29 21:41:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:41.000000Z","updated_at":"2025-03-17T18:52:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2263970,"change_date":"2022-09-29 21:41:00","inspection_id":"76750113","insp_unit_id":"191187626","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"519187","insp_unit_license":"817TXC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"54DC4W1B4KS812747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:29.000000Z","updated_at":"2025-03-17T22:22:29.000000Z"}]},{"id":1250103,"change_date":"2022-09-26 21:39:00","inspection_id":"76568460","dot_number":"966888","report_state":"HI","report_number":"CM17000545","insp_date":"2022-09-07 00:00:00","insp_start_time":"0845","insp_end_time":"0950","registration_date":"2022-09-20 00:00:00","region":"HT","ci_status_code":"C","location":"65","location_desc":"WAILUKU","county_code_state":"HI","county_code":"009","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"BOTTLING GROUP LLC","shipping_paper_number":"30515003","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-09-09 21:39: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":"132418","transaction_code":"C","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2022-09-09 21:39:00","snet_input_date":"2022-09-09 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-09-09 21:39:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"221 S WAKEA AVE","insp_carrier_city":"KAHULUI","insp_carrier_state":"HI","insp_carrier_zip_code":"96732","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:44.000000Z","updated_at":"2025-03-17T18:49:44.000000Z","inspection_violations":[{"id":1979004,"change_date":"2022-09-26 21:39:00","inspection_id":"76568460","insp_violation_id":"248643405","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191096796","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3922"},{"id":1979005,"change_date":"2022-09-26 21:39:00","inspection_id":"76568460","insp_violation_id":"248643406","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191096796","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:04.000000Z","updated_at":"2025-03-17T21:16:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2011898,"change_date":"2022-09-26 21:39:00","inspection_id":"76568460","insp_unit_id":"191096796","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"V18060","insp_unit_license":"267MDR","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUJGBDV8KLKT9968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:50.000000Z","updated_at":"2025-03-17T22:20:50.000000Z"},{"id":2011899,"change_date":"2022-09-26 21:39:00","inspection_id":"76568460","insp_unit_id":"191096797","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"871175","insp_unit_license":"855WEW","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1GRAA8027JK133304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:50.000000Z","updated_at":"2025-03-17T22:20:50.000000Z"}]},{"id":721147,"change_date":"2022-06-29 21:42:00","inspection_id":"75951547","dot_number":"966888","report_state":"HI","report_number":"CM17000494","insp_date":"2022-06-28 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":null,"region":"HT","ci_status_code":"C","location":"66","location_desc":"WAILUKU","county_code_state":"HI","county_code":"009","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"BOTTLING GROUP LLC","shipping_paper_number":"507L3305","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-29 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":"131989","transaction_code":"A","transaction_date":"2022-06-28 00:00:00","upload_date":"2022-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2022-06-29 21:42:00","snet_input_date":"2022-06-29 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-06-29 21:42:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"221 S WAKEA AVE SUITE 222","insp_carrier_city":"KAHULUI","insp_carrier_state":"HI","insp_carrier_zip_code":"96732","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:29.000000Z","updated_at":"2025-03-17T18:40:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1159188,"change_date":"2022-06-29 21:42:00","inspection_id":"75951547","insp_unit_id":"189529816","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"F92548","insp_unit_license":"160MDS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1HTMMMMN5HH478014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:19.000000Z","updated_at":"2025-03-17T22:15:19.000000Z"}]},{"id":605988,"change_date":"2022-06-14 21:42:00","inspection_id":"75815557","dot_number":"966888","report_state":"HI","report_number":"CT31000123","insp_date":"2022-06-09 00:00:00","insp_start_time":"1320","insp_end_time":"1335","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NOAA","shipping_paper_number":"10251816","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-06-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"131914","transaction_code":"A","transaction_date":"2022-06-09 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2022-06-14 21:42:00","snet_input_date":"2022-06-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:25.000000Z","updated_at":"2025-03-17T18:38:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":974251,"change_date":"2022-06-14 21:42:00","inspection_id":"75815557","insp_unit_id":"189238653","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"519187","insp_unit_license":"817TXC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"54DC4W1B4KS812747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:11.000000Z","updated_at":"2025-03-17T22:14:11.000000Z"}]},{"id":559281,"change_date":"2022-06-07 21:38:00","inspection_id":"75759521","dot_number":"966888","report_state":"HI","report_number":"00CK001448","insp_date":"2022-06-06 00:00:00","insp_start_time":"1012","insp_end_time":"1043","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2022-06-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"131895","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00966888","upload_search_indicator":null,"census_search_date":"2022-06-07 21:38:00","snet_input_date":"2022-06-07 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-06-07 21:38:00","insp_carrier_name":"BOTTLING GROUP LLC","insp_carrier_street":"700 ANDERSON HILL RD","insp_carrier_city":"PURCHASE","insp_carrier_state":"NY","insp_carrier_zip_code":"10577","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:29.000000Z","updated_at":"2025-03-17T18:37:29.000000Z","inspection_violations":[{"id":879123,"change_date":"2022-06-07 21:38:00","inspection_id":"75759521","insp_violation_id":"246288604","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39141A1"},{"id":879124,"change_date":"2022-06-07 21:38:00","inspection_id":"75759521","insp_violation_id":"246288605","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"189103618","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39395B"},{"id":879125,"change_date":"2022-06-07 21:38:00","inspection_id":"75759521","insp_violation_id":"246288606","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189103618","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:07.000000Z","updated_at":"2025-03-17T21:11:07.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":899893,"change_date":"2022-06-07 21:38:00","inspection_id":"75759521","insp_unit_id":"189103618","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"519187","insp_unit_license":"817TXC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"54DC4W1B4KS812747","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:44.000000Z","updated_at":"2025-03-17T22:13:44.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/966888\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/966888\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/966888\/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\/966888\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}