{"current_page":1,"data":[{"id":12107368,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","dot_number":"960657","report_state":"HI","report_number":"CS27001249","insp_date":"2026-06-03 00:00:00","insp_start_time":"1130","insp_end_time":"1151","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":"2026-06-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3474813","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2026-06-05 21:37:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-05 21:37:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-08T09:41:04.000000Z","updated_at":"2026-06-11T09:37:32.000000Z","inspection_violations":[{"id":21070255,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","insp_violation_id":"274717013","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213932058","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-08T10:01:17.000000Z","updated_at":"2026-06-11T09:53:00.000000Z","normalized_code":"3922SLLSR"},{"id":21070256,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","insp_violation_id":"274717014","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-26-037271","created_at":"2026-06-08T10:01:17.000000Z","updated_at":"2026-06-11T09:53:00.000000Z","normalized_code":"39141APC"},{"id":21070257,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","insp_violation_id":"274717015","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"213932058","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-08T10:01:17.000000Z","updated_at":"2026-06-11T09:53:00.000000Z","normalized_code":"3969D2FTF"},{"id":21070258,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","insp_violation_id":"274717016","seq_no":"4","part_no":"391","part_no_section":"11A-QMC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-08T10:01:17.000000Z","updated_at":"2026-06-11T09:53:00.000000Z","normalized_code":"39111AQMC"}],"inspection_per_units":[{"id":21036279,"change_date":"2026-06-05 21:37:00","inspection_id":"88052032","insp_unit_id":"213932058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"18","insp_unit_license":"555TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167R7901852","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-08T09:18:16.000000Z","updated_at":"2026-06-11T09:11:28.000000Z"}]},{"id":11695097,"change_date":"2026-04-20 21:38:00","inspection_id":"87621357","dot_number":"960657","report_state":"HI","report_number":"CT31001077","insp_date":"2026-04-17 00:00:00","insp_start_time":"1206","insp_end_time":"1245","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":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-20 21:38: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":"3185567","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:44.000000Z","updated_at":"2026-05-01T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20353410,"change_date":"2026-04-20 21:38:00","inspection_id":"87621357","insp_unit_id":"213109919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"50","insp_unit_license":"455TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W161P7901780","insp_unit_decal":"Y","insp_unit_decal_number":"36542007","created_at":"2026-04-27T09:11:02.000000Z","updated_at":"2026-05-01T09:03:35.000000Z"}]},{"id":11695329,"change_date":"2026-04-20 21:38:00","inspection_id":"87621595","dot_number":"960657","report_state":"HI","report_number":"BP16003567","insp_date":"2026-04-16 00:00:00","insp_start_time":"1021","insp_end_time":"1047","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":"2026-04-20 21:38: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":"3185513","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:44.000000Z","updated_at":"2026-05-01T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20353808,"change_date":"2026-04-20 21:38:00","inspection_id":"87621595","insp_unit_id":"213110345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"197618","insp_unit_license":"T29545","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W163P7900288","insp_unit_decal":"Y","insp_unit_decal_number":"36451844","created_at":"2026-04-27T09:11:02.000000Z","updated_at":"2026-05-01T09:03:35.000000Z"}]},{"id":9804793,"change_date":"2025-12-05 21:42:00","inspection_id":"85904455","dot_number":"960657","report_state":"HI","report_number":"BY39002856","insp_date":"2025-09-26 00:00:00","insp_start_time":"1228","insp_end_time":"1255","registration_date":"2025-09-27 00:00:00","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":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-29 21:39: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":"2342194","transaction_code":"C","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-09-29 21:39:00","snet_input_date":"2025-09-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-29 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:20.000000Z","updated_at":"2025-12-09T10:30:16.000000Z","inspection_violations":[{"id":17337462,"change_date":"2025-12-05 21:42:00","inspection_id":"85904455","insp_violation_id":"270488465","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"210437615","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:30.000000Z","updated_at":"2025-12-09T10:30:29.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17307962,"change_date":"2025-12-05 21:42:00","inspection_id":"85904455","insp_unit_id":"210437615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"18","insp_unit_license":"555TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167R7901852","insp_unit_decal":"Y","insp_unit_decal_number":"35562503","created_at":"2025-12-08T10:01:51.000000Z","updated_at":"2025-12-09T10:00:21.000000Z"}]},{"id":9666739,"change_date":"2025-09-12 21:49:00","inspection_id":"85759591","dot_number":"960657","report_state":"HI","report_number":"CT31001045","insp_date":"2025-09-10 00:00:00","insp_start_time":"1221","insp_end_time":"1308","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":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-12 21:49: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":"2268902","transaction_code":"A","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:12.000000Z","updated_at":"2025-09-16T10:48:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15989905,"change_date":"2025-09-12 21:49:00","inspection_id":"85759591","insp_unit_id":"208915066","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"456918","insp_unit_license":"T29553","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W160N7901475","insp_unit_decal":"Y","insp_unit_decal_number":"35562618","created_at":"2025-09-15T09:53:55.000000Z","updated_at":"2025-09-16T09:55:49.000000Z"}]},{"id":9563630,"change_date":"2025-09-02 21:39:00","inspection_id":"85651958","dot_number":"960657","report_state":"HI","report_number":"BP16003423","insp_date":"2025-08-28 00:00:00","insp_start_time":"1239","insp_end_time":"1314","registration_date":null,"region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI 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":"2025-09-02 21:39: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":"2210935","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:59.000000Z","updated_at":"2025-09-06T10:42:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15786365,"change_date":"2025-09-02 21:39:00","inspection_id":"85651958","insp_unit_id":"208691642","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"349819","insp_unit_license":"T28630","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W162L7900695","insp_unit_decal":"Y","insp_unit_decal_number":"35562488","created_at":"2025-09-09T09:47:12.000000Z","updated_at":"2025-09-09T09:47:12.000000Z"}]},{"id":9304298,"change_date":"2025-12-05 21:42:00","inspection_id":"85379053","dot_number":"960657","report_state":"HI","report_number":"CK46002356","insp_date":"2025-07-31 00:00:00","insp_start_time":"0958","insp_end_time":"1037","registration_date":"2025-08-13 00:00:00","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":"2025-08-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"2072058","transaction_code":"C","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-08-01 21:38:00","snet_input_date":"2025-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-01 21:38:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:40.000000Z","updated_at":"2025-12-09T10:30:14.000000Z","inspection_violations":[{"id":17336603,"change_date":"2025-12-05 21:42:00","inspection_id":"85379053","insp_violation_id":"270488371","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-25-054833","created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:23.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17307507,"change_date":"2025-12-05 21:42:00","inspection_id":"85379053","insp_unit_id":"210437535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"197618","insp_unit_license":"T29545","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALESW163P7900288","insp_unit_decal":"Y","insp_unit_decal_number":"35562522","created_at":"2025-12-08T10:01:51.000000Z","updated_at":"2025-12-09T10:00:18.000000Z"}]},{"id":9285643,"change_date":"2025-12-05 21:42:00","inspection_id":"85359285","dot_number":"960657","report_state":"HI","report_number":"BP16003399","insp_date":"2025-07-29 00:00:00","insp_start_time":"1236","insp_end_time":"1315","registration_date":"2025-08-22 00:00:00","region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HAM PRODUCE & SEAFOOD","shipping_paper_number":"581680","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"2063489","transaction_code":"C","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-07-30 21:40:00","snet_input_date":"2025-07-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-30 21:40:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:12.000000Z","updated_at":"2025-12-09T10:30:14.000000Z","inspection_violations":[{"id":17336593,"change_date":"2025-12-05 21:42:00","inspection_id":"85359285","insp_violation_id":"270488538","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-25-054868","created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:23.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":17307502,"change_date":"2025-12-05 21:42:00","inspection_id":"85359285","insp_unit_id":"210437678","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"52","insp_unit_license":"493TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W166R7900126","insp_unit_decal":"Y","insp_unit_decal_number":"35562473","created_at":"2025-12-08T10:01:51.000000Z","updated_at":"2025-12-09T10:00:18.000000Z"}]},{"id":8671276,"change_date":"2025-05-19 21:39:00","inspection_id":"84710532","dot_number":"960657","report_state":"HI","report_number":"CS27000963","insp_date":"2025-05-16 00:00:00","insp_start_time":"1144","insp_end_time":"1155","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":"2025-05-19 21:39: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":"1746926","transaction_code":"A","transaction_date":"2025-05-18 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-05-19 21:39:00","snet_input_date":"2025-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:10.000000Z","updated_at":"2025-05-23T10:03:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14164192,"change_date":"2025-05-19 21:39:00","inspection_id":"84710532","insp_unit_id":"206932192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"15","insp_unit_license":"554TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W16XR7901540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:54.000000Z","updated_at":"2025-05-23T09:48:18.000000Z"}]},{"id":8438171,"change_date":"2025-04-22 21:41:00","inspection_id":"84465151","dot_number":"960657","report_state":"HI","report_number":"BY39002733","insp_date":"2025-04-21 00:00:00","insp_start_time":"1248","insp_end_time":"1320","registration_date":null,"region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI 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":"2025-04-22 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":"1629229","transaction_code":"A","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-04-22 21:41:00","snet_input_date":"2025-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:27:12.000000Z","updated_at":"2025-04-26T10:27:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13704515,"change_date":"2025-04-22 21:41:00","inspection_id":"84465151","insp_unit_id":"206430969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"349819","insp_unit_license":"T28630","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W162L7900695","insp_unit_decal":"Y","insp_unit_decal_number":"35282817","created_at":"2025-04-25T10:09:54.000000Z","updated_at":"2025-04-26T09:59:51.000000Z"}]},{"id":7532802,"change_date":"2025-01-02 21:38:00","inspection_id":"83513166","dot_number":"960657","report_state":"HI","report_number":"CK46002163","insp_date":"2024-12-30 00:00:00","insp_start_time":"0903","insp_end_time":"0937","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":"CONSIGNEE: TRIPLER ARMY MEDICAL CENTER","shipping_paper_number":"497642","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-02 21:38: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":"1210665","transaction_code":"A","transaction_date":"2025-01-02 00:00:00","upload_date":"2025-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2025-01-02 21:38:00","snet_input_date":"2024-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-02 21:38:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:53:12.000000Z","updated_at":"2025-03-17T20:53:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12152834,"change_date":"2025-01-02 21:38:00","inspection_id":"83513166","insp_unit_id":"204619135","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"15","insp_unit_license":"554TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W16XR7901540","insp_unit_decal":"Y","insp_unit_decal_number":"34742835","created_at":"2025-03-17T23:49:10.000000Z","updated_at":"2025-03-17T23:49:10.000000Z"}]},{"id":7190858,"change_date":"2024-11-14 21:40:00","inspection_id":"83153166","dot_number":"960657","report_state":"HI","report_number":"CS27000848","insp_date":"2024-11-13 00:00:00","insp_start_time":"1251","insp_end_time":"1323","registration_date":null,"region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI 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":"479903","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1052690","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-11-14 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-14 21:40:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:01.000000Z","updated_at":"2025-03-17T20:46:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11598700,"change_date":"2024-11-14 21:40:00","inspection_id":"83153166","insp_unit_id":"203874089","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"18","insp_unit_license":"555TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167R7901852","insp_unit_decal":"Y","insp_unit_decal_number":"34711997","created_at":"2025-03-17T23:43:11.000000Z","updated_at":"2025-03-17T23:43:11.000000Z"}]},{"id":6958192,"change_date":"2024-10-15 21:42:00","inspection_id":"82906331","dot_number":"960657","report_state":"HI","report_number":"BP16003223","insp_date":"2024-10-14 00:00:00","insp_start_time":"0943","insp_end_time":"1006","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-10-15 21:42: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":"946623","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:04.000000Z","updated_at":"2025-03-17T20:41:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11222907,"change_date":"2024-10-15 21:42:00","inspection_id":"82906331","insp_unit_id":"203407379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"53","insp_unit_license":"900TYD","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W161P7902010","insp_unit_decal":"Y","insp_unit_decal_number":"34711948","created_at":"2025-03-17T23:39:11.000000Z","updated_at":"2025-03-17T23:39:11.000000Z"}]},{"id":6889302,"change_date":"2024-10-04 21:39:00","inspection_id":"82833032","dot_number":"960657","report_state":"HI","report_number":"CB44001693","insp_date":"2024-10-02 00:00:00","insp_start_time":"1009","insp_end_time":"1023","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-10-04 21:39: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"913921","transaction_code":"A","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-10-04 21:39:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-04 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[{"id":10732853,"change_date":"2024-10-04 21:39:00","inspection_id":"82833032","insp_violation_id":"262187745","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":11110781,"change_date":"2024-10-04 21:39:00","inspection_id":"82833032","insp_unit_id":"203269288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"66","insp_unit_license":"560TTZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W166R7901602","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6857637,"change_date":"2024-10-01 21:41:00","inspection_id":"82799419","dot_number":"960657","report_state":"HI","report_number":"CS27000811","insp_date":"2024-09-27 00:00:00","insp_start_time":"1013","insp_end_time":"1050","registration_date":null,"region":"HS","ci_status_code":"C","location":"31","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-10-01 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":"899974","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-10-01 21:41:00","snet_input_date":"2024-09-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-01 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:02.000000Z","updated_at":"2025-03-17T20:39:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11058780,"change_date":"2024-10-01 21:41:00","inspection_id":"82799419","insp_unit_id":"203204361","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"197616","insp_unit_license":"T29462","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W16XP7900286","insp_unit_decal":"Y","insp_unit_decal_number":"34449435","created_at":"2025-03-17T23:37:31.000000Z","updated_at":"2025-03-17T23:37:31.000000Z"}]},{"id":6765422,"change_date":"2024-09-19 21:41:00","inspection_id":"82701168","dot_number":"960657","report_state":"HI","report_number":"BP16003189","insp_date":"2024-09-17 00:00:00","insp_start_time":"1111","insp_end_time":"1122","registration_date":null,"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":"2024-09-19 21:41: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"863073","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":"00960657","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[{"id":10536236,"change_date":"2024-09-19 21:41:00","inspection_id":"82701168","insp_violation_id":"261914253","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10909678,"change_date":"2024-09-19 21:41:00","inspection_id":"82701168","insp_unit_id":"203021336","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"21","insp_unit_license":"017TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W164N7901284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:00.000000Z","updated_at":"2025-03-17T23:36:00.000000Z"}]},{"id":6765430,"change_date":"2024-09-19 21:41:00","inspection_id":"82701176","dot_number":"960657","report_state":"HI","report_number":"BP16003186","insp_date":"2024-09-17 00:00:00","insp_start_time":"0923","insp_end_time":"0937","registration_date":null,"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":"2024-09-19 21:41: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"863070","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":"00960657","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[{"id":10536246,"change_date":"2024-09-19 21:41:00","inspection_id":"82701176","insp_violation_id":"261914266","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10909687,"change_date":"2024-09-19 21:41:00","inspection_id":"82701176","insp_unit_id":"203021348","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"52","insp_unit_license":"493TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W166R7900126","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:00.000000Z","updated_at":"2025-03-17T23:36:00.000000Z"}]},{"id":6033851,"change_date":"2024-06-20 21:43:00","inspection_id":"81918990","dot_number":"960657","report_state":"HI","report_number":"BP16003080","insp_date":"2024-06-19 00:00:00","insp_start_time":"1221","insp_end_time":"1242","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":"17950","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":"586918","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":"00960657","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":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","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":9360549,"change_date":"2024-06-20 21:43:00","inspection_id":"81918990","insp_violation_id":"260205286","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:19.000000Z","updated_at":"2025-03-17T21:51:19.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":9718483,"change_date":"2024-06-20 21:43:00","inspection_id":"81918990","insp_unit_id":"201500324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"197616","insp_unit_license":"T29462","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W16XP7900286","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":5496162,"change_date":"2024-04-12 21:39:00","inspection_id":"81334877","dot_number":"960657","report_state":"HI","report_number":"BP16003008","insp_date":"2024-04-10 00:00:00","insp_start_time":"1233","insp_end_time":"1243","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-04-12 21:39: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"392310","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-04-12 21:39:00","snet_input_date":"2024-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-12 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:34.000000Z","updated_at":"2025-03-17T20:11:34.000000Z","inspection_violations":[{"id":8489265,"change_date":"2024-04-12 21:39:00","inspection_id":"81334877","insp_violation_id":"258895371","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:47:08.000000Z","updated_at":"2025-03-17T21:47:08.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":8853193,"change_date":"2024-04-12 21:39:00","inspection_id":"81334877","insp_unit_id":"200366067","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"30","insp_unit_license":"454TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167P7900715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:21.000000Z","updated_at":"2025-03-17T23:15:21.000000Z"}]},{"id":5314556,"change_date":"2024-03-19 21:44:00","inspection_id":"81136599","dot_number":"960657","report_state":"HI","report_number":"CT31000681","insp_date":"2024-03-18 00:00:00","insp_start_time":"1036","insp_end_time":"1119","registration_date":null,"region":"HS","ci_status_code":"C","location":"102","location_desc":"KANEOHE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FOODLAND","shipping_paper_number":"383915","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-03-19 21:44: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"329143","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-03-19 21:44:00","snet_input_date":"2024-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-19 21:44:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:55.000000Z","updated_at":"2025-03-17T20:07:55.000000Z","inspection_violations":[{"id":8199715,"change_date":"2024-03-19 21:44:00","inspection_id":"81136599","insp_violation_id":"258454372","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:36.000000Z","updated_at":"2025-03-17T21:45:36.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":8559313,"change_date":"2024-03-19 21:44:00","inspection_id":"81136599","insp_unit_id":"199974680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"456918","insp_unit_license":"T29553","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W160N7901475","insp_unit_decal":"Y","insp_unit_decal_number":"33787860","created_at":"2025-03-17T23:12:34.000000Z","updated_at":"2025-03-17T23:12:34.000000Z"}]},{"id":5069546,"change_date":"2024-02-16 21:41:00","inspection_id":"80869402","dot_number":"960657","report_state":"HI","report_number":"BP16002927","insp_date":"2024-02-15 00:00:00","insp_start_time":"0908","insp_end_time":"0929","registration_date":null,"region":"HS","ci_status_code":"C","location":"13","location_desc":"WAIPAHU 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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-16 21:41: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"249565","transaction_code":"A","transaction_date":"2024-02-16 00:00:00","upload_date":"2024-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2024-02-16 21:41:00","snet_input_date":"2024-02-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-16 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER ST","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:05.000000Z","updated_at":"2025-03-17T20:03:05.000000Z","inspection_violations":[{"id":7813803,"change_date":"2024-02-16 21:41:00","inspection_id":"80869402","insp_violation_id":"257879623","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"199460732","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-24-023043","created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":8160829,"change_date":"2024-02-16 21:41:00","inspection_id":"80869402","insp_unit_id":"199460732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"30","insp_unit_license":"454TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167P7900715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:59.000000Z","updated_at":"2025-03-17T23:08:59.000000Z"}]},{"id":4474234,"change_date":"2023-11-21 21:40:00","inspection_id":"80217632","dot_number":"960657","report_state":"HI","report_number":"CS27000571","insp_date":"2023-11-17 00:00:00","insp_start_time":"1244","insp_end_time":"1315","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":"2023-11-21 21:40: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":"135480","transaction_code":"A","transaction_date":"2023-11-17 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-21 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:27.000000Z","updated_at":"2025-03-17T19:51:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7195844,"change_date":"2023-11-21 21:40:00","inspection_id":"80217632","insp_unit_id":"198168581","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"47","insp_unit_license":"547TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W167P7901783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"}]},{"id":2370272,"change_date":"2023-03-10 21:41:00","inspection_id":"77854945","dot_number":"960657","report_state":"HI","report_number":"CP19000555","insp_date":"2023-02-13 00:00:00","insp_start_time":"1223","insp_end_time":"1247","registration_date":"2023-03-06 00:00:00","region":"HT","ci_status_code":"C","location":"06","location_desc":"KAPAA QUARRY & MOKAPU BLVD","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"234789","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"133442","transaction_code":"C","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2023-02-14 21:41:00","snet_input_date":"2023-02-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3650410,"change_date":"2023-03-10 21:41:00","inspection_id":"77854945","insp_violation_id":"251598688","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":"Y","defect_verification_id":"3","citation_number":"1DTI-23-027167","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39141A1"},{"id":3650411,"change_date":"2023-03-10 21:41:00","inspection_id":"77854945","insp_violation_id":"251598689","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"1","insp_unit_id":"193816777","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-23-027168","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":3814233,"change_date":"2023-03-10 21:41:00","inspection_id":"77854945","insp_unit_id":"193816777","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"154902","insp_unit_license":"T26772","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W161G7901388","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2097103,"change_date":"2023-01-31 21:43:00","inspection_id":"77543005","dot_number":"960657","report_state":"HI","report_number":"00BP002631","insp_date":"2023-01-06 00:00:00","insp_start_time":"1301","insp_end_time":"1329","registration_date":"2023-01-25 00:00:00","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":"2023-01-09 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133186","transaction_code":"C","transaction_date":"2023-01-06 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2023-01-09 21:47:00","snet_input_date":"2023-01-09 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-01-09 21:47:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:10.000000Z","updated_at":"2025-03-17T19:05:10.000000Z","inspection_violations":[{"id":3244992,"change_date":"2023-01-31 21:43:00","inspection_id":"77543005","insp_violation_id":"250873636","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:22:23.000000Z","updated_at":"2025-03-17T21:22:23.000000Z","normalized_code":"39145B"},{"id":3244993,"change_date":"2023-01-31 21:43:00","inspection_id":"77543005","insp_violation_id":"250873637","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193157365","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:23.000000Z","updated_at":"2025-03-17T21:22:23.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3374426,"change_date":"2023-01-31 21:43:00","inspection_id":"77543005","insp_unit_id":"193157365","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"38","insp_unit_license":"726TXS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W168N7901899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:10.000000Z","updated_at":"2025-03-17T22:30:10.000000Z"}]},{"id":1717369,"change_date":"2022-11-10 21:39:00","inspection_id":"77108460","dot_number":"960657","report_state":"HI","report_number":"CP19000492","insp_date":"2022-11-07 00:00:00","insp_start_time":"0840","insp_end_time":"0912","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-11-10 21:39: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":"132833","transaction_code":"A","transaction_date":"2022-11-07 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2022-11-10 21:39:00","snet_input_date":"2022-11-10 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-11-10 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:14.000000Z","updated_at":"2025-03-17T18:58:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2762934,"change_date":"2022-11-10 21:39:00","inspection_id":"77108460","insp_unit_id":"191906539","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"38","insp_unit_license":"726TXS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W168N7901899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:54.000000Z","updated_at":"2025-03-17T22:25:54.000000Z"}]},{"id":1171021,"change_date":"2022-09-09 21:39:00","inspection_id":"76477017","dot_number":"960657","report_state":"HI","report_number":"00BP002516","insp_date":"2022-08-29 00:00:00","insp_start_time":"1231","insp_end_time":"1257","registration_date":"2022-09-06 00:00:00","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":"175757","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-08-30 21:41: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":"132366","transaction_code":"C","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2022-08-30 21:41:00","snet_input_date":"2022-08-30 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-08-30 21:41:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[{"id":1856381,"change_date":"2022-09-09 21:39:00","inspection_id":"76477017","insp_violation_id":"248312817","seq_no":"1","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"190813610","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:34.000000Z","updated_at":"2025-03-17T21:15:34.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":1883205,"change_date":"2022-09-09 21:39:00","inspection_id":"76477017","insp_unit_id":"190813610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"38","insp_unit_license":"726TXS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W168N7901899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":605982,"change_date":"2022-06-20 21:36:00","inspection_id":"75815551","dot_number":"960657","report_state":"HI","report_number":"CS27000123","insp_date":"2022-06-06 00:00:00","insp_start_time":"1314","insp_end_time":"1334","registration_date":"2022-06-16 00:00:00","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","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":"131920","transaction_code":"C","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","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":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","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":[{"id":951289,"change_date":"2022-06-20 21:36:00","inspection_id":"75815551","insp_violation_id":"246585662","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189349421","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3922"},{"id":951290,"change_date":"2022-06-20 21:36:00","inspection_id":"75815551","insp_violation_id":"246585663","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189349421","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:27.000000Z","updated_at":"2025-03-17T21:11:27.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":974242,"change_date":"2022-06-20 21:36:00","inspection_id":"75815551","insp_unit_id":"189349421","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"28","insp_unit_license":"719TWX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W160L7900016","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":433457,"change_date":"2022-06-23 21:40:00","inspection_id":"75610017","dot_number":"960657","report_state":"HI","report_number":"00CB001248","insp_date":"2022-05-18 00:00:00","insp_start_time":"0933","insp_end_time":"1003","registration_date":"2022-06-12 00:00:00","region":"HT","ci_status_code":"C","location":"31","location_desc":"WAIANAE","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"MONKEYPOD KITCHEN BY MERRIMAN","shipping_paper_number":"140558","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-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"131785","transaction_code":"C","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2022-05-19 21:42:00","snet_input_date":"2022-05-19 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-05-19 21:42:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:10.000000Z","updated_at":"2025-03-17T18:35:10.000000Z","inspection_violations":[{"id":680936,"change_date":"2022-06-23 21:40:00","inspection_id":"75610017","insp_violation_id":"246680987","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:10:14.000000Z","updated_at":"2025-03-17T21:10:14.000000Z","normalized_code":"39141A1"},{"id":680937,"change_date":"2022-06-23 21:40:00","inspection_id":"75610017","insp_violation_id":"246680988","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"189431548","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:14.000000Z","updated_at":"2025-03-17T21:10:14.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":698943,"change_date":"2022-06-23 21:40:00","inspection_id":"75610017","insp_unit_id":"189431548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"456918","insp_unit_license":"683TXP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W160N7901475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:29.000000Z","updated_at":"2025-03-17T22:12:29.000000Z"}]},{"id":129339,"change_date":"2022-04-21 21:42:00","inspection_id":"75247097","dot_number":"960657","report_state":"HI","report_number":"00BP002412","insp_date":"2022-04-04 00:00:00","insp_start_time":"0940","insp_end_time":"1000","registration_date":"2022-04-18 00:00:00","region":"HT","ci_status_code":"C","location":"31","location_desc":"WAIANAE","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","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-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"131496","transaction_code":"C","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00960657","upload_search_indicator":null,"census_search_date":"2022-04-07 21:39:00","snet_input_date":"2022-04-07 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"HAM PRODUCE & SEAFOOD INC","insp_carrier_street":"918 BANNISTER","insp_carrier_city":"HONOLU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[{"id":191376,"change_date":"2022-04-21 21:42:00","inspection_id":"75247097","insp_violation_id":"245296461","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39145B"},{"id":191377,"change_date":"2022-04-21 21:42:00","inspection_id":"75247097","insp_violation_id":"245296462","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"1","insp_unit_id":"188274337","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:56.000000Z","updated_at":"2025-03-17T21:07:56.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":209531,"change_date":"2022-04-21 21:42:00","inspection_id":"75247097","insp_unit_id":"188274337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"152633","insp_unit_license":"T27172","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W164G7900493","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/960657\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/960657\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/960657\/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\/960657\/inspections","per_page":100,"prev_page_url":null,"to":29,"total":29}