{"current_page":1,"data":[{"id":11963697,"change_date":"2026-05-19 21:40:00","inspection_id":"87900017","dot_number":"571797","report_state":"HI","report_number":"BY39003054","insp_date":"2026-05-18 00:00:00","insp_start_time":"1005","insp_end_time":"1042","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","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":"2026-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","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":"3363873","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2026-05-19 21:40:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-19 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"91-139 HANUA STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:14.000000Z","updated_at":"2026-05-30T09:30:57.000000Z","inspection_violations":[{"id":20809776,"change_date":"2026-05-19 21:40:00","inspection_id":"87900017","insp_violation_id":"274368595","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213646233","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:36.000000Z","updated_at":"2026-05-30T09:41:27.000000Z","normalized_code":"3922SLLSR"},{"id":20809777,"change_date":"2026-05-19 21:40:00","inspection_id":"87900017","insp_violation_id":"274368596","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"213646233","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:36.000000Z","updated_at":"2026-05-30T09:41:27.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":20801309,"change_date":"2026-05-19 21:40:00","inspection_id":"87900017","insp_unit_id":"213646233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"2","insp_unit_license":"145TSS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"2NPLHZ7X07M737542","insp_unit_decal":"Y","insp_unit_decal_number":"36451897","created_at":"2026-05-22T09:21:49.000000Z","updated_at":"2026-05-30T09:03:15.000000Z"}]},{"id":11788893,"change_date":"2026-04-30 21:40:00","inspection_id":"87720586","dot_number":"571797","report_state":"HI","report_number":"CK46002564","insp_date":"2026-04-29 00:00:00","insp_start_time":"1021","insp_end_time":"1050","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: COSTCO WHOLESALE IWILEI","shipping_paper_number":"1452060804","cargo_tank":"406","hazmat_placard_req":"Y","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"111350","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":"3234881","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2026-04-30 21:40:00","snet_input_date":"2026-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-30 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"91-139 HANUA STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:49.000000Z","updated_at":"2026-05-11T09:30:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20507504,"change_date":"2026-04-30 21:40:00","inspection_id":"87720586","insp_unit_id":"213305226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19263","insp_unit_license":"FJ317","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZCP8X9TJ193714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:34.000000Z","updated_at":"2026-05-11T09:02:44.000000Z"},{"id":20507505,"change_date":"2026-04-30 21:40:00","inspection_id":"87720586","insp_unit_id":"213305227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19351","insp_unit_license":"138WFH","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTSA4324S7176050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:34.000000Z","updated_at":"2026-05-11T09:02:44.000000Z"}]},{"id":11553201,"change_date":"2026-04-23 21:39:00","inspection_id":"87476202","dot_number":"571797","report_state":"HI","report_number":"CT31001072","insp_date":"2026-04-01 00:00:00","insp_start_time":"1234","insp_end_time":"1323","registration_date":"2026-04-02 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"404767","cargo_tank":"406","hazmat_placard_req":"Y","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-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"111350","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":"3106592","transaction_code":"C","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"91-139 HANUA STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:40:17.000000Z","updated_at":"2026-05-04T09:30:06.000000Z","inspection_violations":[{"id":19525297,"change_date":"2026-04-23 21:39:00","inspection_id":"87476202","insp_violation_id":"273799902","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"213177288","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T10:01:52.000000Z","updated_at":"2026-05-04T09:42:46.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":19799165,"change_date":"2026-04-23 21:39:00","inspection_id":"87476202","insp_unit_id":"213177287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19260","insp_unit_license":"653TYG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZCP8X7SJ172911","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:10.000000Z","updated_at":"2026-05-04T09:02:18.000000Z"},{"id":19799166,"change_date":"2026-04-23 21:39:00","inspection_id":"87476202","insp_unit_id":"213177288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19350","insp_unit_license":"282WFE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTSA4321S7175082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:18:10.000000Z","updated_at":"2026-05-04T09:02:18.000000Z"}]},{"id":11248901,"change_date":"2026-02-27 21:41:00","inspection_id":"87162031","dot_number":"571797","report_state":"HI","report_number":"CK46002507","insp_date":"2026-02-26 00:00:00","insp_start_time":"0847","insp_end_time":"0915","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: SHELL MCCULLY","shipping_paper_number":"402477","cargo_tank":"406","hazmat_placard_req":"Y","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-27 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":"2943288","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2026-02-27 21:41:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-27 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"91-139 HANUA STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-02T10:39:34.000000Z","updated_at":"2026-03-10T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19230476,"change_date":"2026-02-27 21:41:00","inspection_id":"87162031","insp_unit_id":"211877445","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:23.000000Z","updated_at":"2026-03-10T09:05:36.000000Z"},{"id":19230477,"change_date":"2026-02-27 21:41:00","inspection_id":"87162031","insp_unit_id":"211877446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:23.000000Z","updated_at":"2026-03-10T09:05:36.000000Z"}]},{"id":9182352,"change_date":"2025-10-07 21:40:00","inspection_id":"85250534","dot_number":"571797","report_state":"HI","report_number":"CQ41000545","insp_date":"2025-07-16 00:00:00","insp_start_time":"0915","insp_end_time":"1016","registration_date":"2025-07-23 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI 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":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"94600","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2006503","transaction_code":"C","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-07-18 21:39:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-18 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"91139 HANUA STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:28.000000Z","updated_at":"2025-10-11T10:00:05.000000Z","inspection_violations":[{"id":16267279,"change_date":"2025-10-07 21:40:00","inspection_id":"85250534","insp_violation_id":"269136902","seq_no":"1","part_no":"177","part_no_section":"817A-HMSP","insp_viol_unit":"1","insp_unit_id":"209332008","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-10T10:18:07.000000Z","updated_at":"2025-10-11T10:15:11.000000Z","normalized_code":"177817AHMSP"}],"inspection_per_units":[{"id":16375467,"change_date":"2025-10-07 21:40:00","inspection_id":"85250534","insp_unit_id":"209332008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","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":16375468,"change_date":"2025-10-07 21:40:00","inspection_id":"85250534","insp_unit_id":"209332009","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"19320","insp_unit_license":"861WFP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1PMA22528A5009047","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":8106042,"change_date":"2025-07-17 21:41:00","inspection_id":"84115314","dot_number":"571797","report_state":"HI","report_number":"BP16003307","insp_date":"2025-03-12 00:00:00","insp_start_time":"0921","insp_end_time":"0947","registration_date":null,"region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM, LTD.","shipping_paper_number":"381119","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"1467023","transaction_code":"C","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-03-13 21:43:00","snet_input_date":"2025-03-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-13 21:43:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:51.000000Z","updated_at":"2025-07-21T10:42:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15064557,"change_date":"2025-07-17 21:41:00","inspection_id":"84115314","insp_unit_id":"207922880","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19259","insp_unit_license":"030TYE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X4RJ363088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:21.000000Z","updated_at":"2025-07-21T09:45:06.000000Z"}]},{"id":7903763,"change_date":"2025-02-19 21:40:00","inspection_id":"83902849","dot_number":"571797","report_state":"HI","report_number":"BP16003303","insp_date":"2025-02-18 00:00:00","insp_start_time":"1247","insp_end_time":"1319","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM, LTD.","shipping_paper_number":"379718","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1377167","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:21.000000Z","updated_at":"2025-03-17T21:02:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12758129,"change_date":"2025-02-19 21:40:00","inspection_id":"83902849","insp_unit_id":"205389035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"},{"id":12758130,"change_date":"2025-02-19 21:40:00","inspection_id":"83902849","insp_unit_id":"205389036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"}]},{"id":7904404,"change_date":"2025-02-19 21:40:00","inspection_id":"83903504","dot_number":"571797","report_state":"HI","report_number":"CB44001780","insp_date":"2025-02-18 00:00:00","insp_start_time":"1244","insp_end_time":"1315","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE:  COSTCO IWILEI","shipping_paper_number":"379719","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"1377925","transaction_code":"A","transaction_date":"2025-02-19 00:00:00","upload_date":"2025-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-02-19 21:40:00","snet_input_date":"2025-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-19 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:21.000000Z","updated_at":"2025-03-17T21:02:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12759176,"change_date":"2025-02-19 21:40:00","inspection_id":"83903504","insp_unit_id":"205390196","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19261","insp_unit_license":"643TYF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZCP8X9SJ172912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"},{"id":12759177,"change_date":"2025-02-19 21:40:00","inspection_id":"83903504","insp_unit_id":"205390197","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19340","insp_unit_license":"184WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:57.000000Z","updated_at":"2025-03-17T23:55:57.000000Z"}]},{"id":7792252,"change_date":"2025-02-05 21:39:00","inspection_id":"83785791","dot_number":"571797","report_state":"HI","report_number":"CB44001774","insp_date":"2025-02-04 00:00:00","insp_start_time":"1026","insp_end_time":"1056","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"C&C OF HONOLULU","shipping_paper_number":"378837","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"1327323","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-02-05 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-05 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:56.000000Z","updated_at":"2025-03-17T20:59:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12575405,"change_date":"2025-02-05 21:39:00","inspection_id":"83785791","insp_unit_id":"205168369","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:56.000000Z","updated_at":"2025-03-17T23:53:56.000000Z"}]},{"id":7771641,"change_date":"2025-10-21 21:39:00","inspection_id":"83764168","dot_number":"571797","report_state":"HI","report_number":"CQ41000466","insp_date":"2025-01-31 00:00:00","insp_start_time":"1247","insp_end_time":"1326","registration_date":"2025-02-02 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"378626","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"111350","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":"1319156","transaction_code":"C","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-10-25T10:00:17.000000Z","inspection_violations":[{"id":16514750,"change_date":"2025-10-21 21:39:00","inspection_id":"83764168","insp_violation_id":"269420091","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209573323","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:17:43.000000Z","updated_at":"2025-10-25T10:15:27.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16596374,"change_date":"2025-10-21 21:39:00","inspection_id":"83764168","insp_unit_id":"209573322","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19260","insp_unit_license":"653TYG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZCP8X7SJ172911","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:01.000000Z","updated_at":"2025-10-25T09:45:19.000000Z"},{"id":16596375,"change_date":"2025-10-21 21:39:00","inspection_id":"83764168","insp_unit_id":"209573323","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19350","insp_unit_license":"282WFE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTSA4321S7175082","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:01.000000Z","updated_at":"2025-10-25T09:45:19.000000Z"}]},{"id":7735266,"change_date":"2025-01-29 21:40:00","inspection_id":"83725640","dot_number":"571797","report_state":"HI","report_number":"CS27000891","insp_date":"2025-01-28 00:00:00","insp_start_time":"0904","insp_end_time":"0935","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI 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":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"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":"1299999","transaction_code":"A","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:44.000000Z","updated_at":"2025-03-17T20:58:44.000000Z","inspection_violations":[{"id":12087110,"change_date":"2025-01-29 21:40:00","inspection_id":"83725640","insp_violation_id":"264230778","seq_no":"1","part_no":"172","part_no_section":"516C6-HMPMC","insp_viol_unit":"1","insp_unit_id":"205057387","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"172516C6HMPMC"}],"inspection_per_units":[{"id":12482795,"change_date":"2025-01-29 21:40:00","inspection_id":"83725640","insp_unit_id":"205057387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:43.000000Z","updated_at":"2025-03-17T23:52:43.000000Z"},{"id":12482796,"change_date":"2025-01-29 21:40:00","inspection_id":"83725640","insp_unit_id":"205057388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:43.000000Z","updated_at":"2025-03-17T23:52:43.000000Z"}]},{"id":7478797,"change_date":"2025-10-04 21:33:00","inspection_id":"83456516","dot_number":"571797","report_state":"HI","report_number":"CP19001060","insp_date":"2024-12-20 00:00:00","insp_start_time":"1017","insp_end_time":"1051","registration_date":"2025-01-03 00:00:00","region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"376018","cargo_tank":"406","hazmat_placard_req":"Y","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-22 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"94320","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":"1183010","transaction_code":"C","transaction_date":"2024-12-21 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-12-22 21:33:00","snet_input_date":"2024-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-22 21:33:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:00.000000Z","updated_at":"2025-10-08T10:01:23.000000Z","inspection_violations":[{"id":16229552,"change_date":"2025-10-04 21:33:00","inspection_id":"83456516","insp_violation_id":"269093946","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209295315","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":16341581,"change_date":"2025-10-04 21:33:00","inspection_id":"83456516","insp_unit_id":"209295314","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK TRUCK","insp_unit_company":"19235","insp_unit_license":"310TVT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M2AW21C3GM076690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:42.000000Z","updated_at":"2025-10-08T09:46:42.000000Z"},{"id":16341582,"change_date":"2025-10-04 21:33:00","inspection_id":"83456516","insp_unit_id":"209295315","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19316","insp_unit_license":"429WED","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM252887D73478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:42.000000Z","updated_at":"2025-10-08T09:46:42.000000Z"}]},{"id":7011373,"change_date":"2025-10-06 21:40:00","inspection_id":"82962907","dot_number":"571797","report_state":"HI","report_number":"CP19001009","insp_date":"2024-10-18 00:00:00","insp_start_time":"0905","insp_end_time":"1007","registration_date":"2024-10-19 00:00:00","region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: COSTCO WHOLESALE WAIPIO","shipping_paper_number":"372167","cargo_tank":"406","hazmat_placard_req":"Y","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"971195","transaction_code":"C","transaction_date":"2024-10-22 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:16.000000Z","updated_at":"2025-10-10T10:00:22.000000Z","inspection_violations":[{"id":16244652,"change_date":"2025-10-06 21:40:00","inspection_id":"82962907","insp_violation_id":"269113126","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"209310887","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:15:49.000000Z","updated_at":"2025-10-10T10:15:39.000000Z","normalized_code":"39355EB"},{"id":16244653,"change_date":"2025-10-06 21:40:00","inspection_id":"82962907","insp_violation_id":"269113127","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209310886","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:15:49.000000Z","updated_at":"2025-10-10T10:15:39.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16354591,"change_date":"2025-10-06 21:40:00","inspection_id":"82962907","insp_unit_id":"209310886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:35.000000Z","updated_at":"2025-10-10T09:45:27.000000Z"},{"id":16354592,"change_date":"2025-10-06 21:40:00","inspection_id":"82962907","insp_unit_id":"209310887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:35.000000Z","updated_at":"2025-10-10T09:45:27.000000Z"}]},{"id":6950603,"change_date":"2024-10-14 21:37:00","inspection_id":"82898360","dot_number":"571797","report_state":"HI","report_number":"CK46002099","insp_date":"2024-10-11 00:00:00","insp_start_time":"0937","insp_end_time":"1005","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: DFASNAVAL STATION FORD ISLAND","shipping_paper_number":"371726","cargo_tank":"406","hazmat_placard_req":"Y","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-14 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"944083","transaction_code":"A","transaction_date":"2024-10-14 00:00:00","upload_date":"2024-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-10-14 21:37:00","snet_input_date":"2024-10-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-14 21:37:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:01.000000Z","updated_at":"2025-03-17T20:41:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11210752,"change_date":"2024-10-14 21:37:00","inspection_id":"82898360","insp_unit_id":"203393288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"19242","insp_unit_license":"712TXB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPCLP9X0LD667153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:05.000000Z","updated_at":"2025-03-17T23:39:05.000000Z"}]},{"id":6929562,"change_date":"2024-10-10 21:41:00","inspection_id":"82875892","dot_number":"571797","report_state":"HI","report_number":"CS27000822","insp_date":"2024-10-09 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI 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":"371584","cargo_tank":"406","hazmat_placard_req":"Y","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"94600","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":"932967","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-10-10 21:41:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-10 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:38.000000Z","updated_at":"2025-03-17T20:40:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11175867,"change_date":"2024-10-10 21:41:00","inspection_id":"82875892","insp_unit_id":"203350888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:44.000000Z","updated_at":"2025-03-17T23:38:44.000000Z"},{"id":11175868,"change_date":"2024-10-10 21:41:00","inspection_id":"82875892","insp_unit_id":"203350889","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"POLAR MFG.","insp_unit_company":"19320","insp_unit_license":"861WFP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1PMA22528A5009047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:44.000000Z","updated_at":"2025-03-17T23:38:44.000000Z"}]},{"id":6929563,"change_date":"2024-10-10 21:41:00","inspection_id":"82875893","dot_number":"571797","report_state":"HI","report_number":"CS27000821","insp_date":"2024-10-09 00:00:00","insp_start_time":"0902","insp_end_time":"0935","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI 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":"371583","cargo_tank":"406","hazmat_placard_req":"Y","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"932964","transaction_code":"A","transaction_date":"2024-10-10 00:00:00","upload_date":"2024-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-10-10 21:41:00","snet_input_date":"2024-10-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-10 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:38.000000Z","updated_at":"2025-03-17T20:40:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11175869,"change_date":"2024-10-10 21:41:00","inspection_id":"82875893","insp_unit_id":"203350890","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19261","insp_unit_license":"643TYF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZCP8X9SJ172912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:44.000000Z","updated_at":"2025-03-17T23:38:44.000000Z"},{"id":11175870,"change_date":"2024-10-10 21:41:00","inspection_id":"82875893","insp_unit_id":"203350891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19340","insp_unit_license":"184WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:44.000000Z","updated_at":"2025-03-17T23:38:44.000000Z"}]},{"id":6523060,"change_date":"2024-08-21 21:42:00","inspection_id":"82443218","dot_number":"571797","report_state":"HI","report_number":"BP16003151","insp_date":"2024-08-20 00:00:00","insp_start_time":"1246","insp_end_time":"1304","registration_date":null,"region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM, LTD.","shipping_paper_number":"368489","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54599","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":"767692","transaction_code":"A","transaction_date":"2024-08-21 00:00:00","upload_date":"2024-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-08-21 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-21 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:19.000000Z","updated_at":"2025-03-17T20:32:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10515650,"change_date":"2024-08-21 21:42:00","inspection_id":"82443218","insp_unit_id":"202503217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:56.000000Z","updated_at":"2025-03-17T23:31:56.000000Z"}]},{"id":6463249,"change_date":"2024-08-14 21:38:00","inspection_id":"82379411","dot_number":"571797","report_state":"HI","report_number":"CP19000952","insp_date":"2024-08-13 00:00:00","insp_start_time":"0916","insp_end_time":"0949","registration_date":null,"region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI 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":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-14 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"744461","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-08-14 21:38:00","snet_input_date":"2024-08-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-14 21:38:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:05.000000Z","updated_at":"2025-03-17T20:31:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10417650,"change_date":"2024-08-14 21:38:00","inspection_id":"82379411","insp_unit_id":"202383245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19259","insp_unit_license":"030TYE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X4RJ363088","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"}]},{"id":6439748,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","dot_number":"571797","report_state":"HI","report_number":"CB44001668","insp_date":"2024-08-09 00:00:00","insp_start_time":"0909","insp_end_time":"0945","registration_date":"2024-08-14 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"367855","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"737663","transaction_code":"C","transaction_date":"2024-08-12 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:21.000000Z","updated_at":"2025-10-13T10:00:08.000000Z","inspection_violations":[{"id":16314856,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","insp_violation_id":"269203634","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209384196","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:07.000000Z","normalized_code":"3939ALIL"},{"id":16314857,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","insp_violation_id":"269203635","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209384196","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:07.000000Z","normalized_code":"3939ALCL"},{"id":16314858,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","insp_violation_id":"269203636","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209384196","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:07.000000Z","normalized_code":"3922SLLSR"},{"id":16314859,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","insp_violation_id":"269203637","seq_no":"4","part_no":"172","part_no_section":"516C6-HMPMC","insp_viol_unit":"1","insp_unit_id":"209384196","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:07.000000Z","normalized_code":"172516C6HMPMC"}],"inspection_per_units":[{"id":16414006,"change_date":"2025-10-09 21:40:00","inspection_id":"82354384","insp_unit_id":"209384196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"19242","insp_unit_license":"712TXB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPCLP9X0LD667153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:04.000000Z","updated_at":"2025-10-13T09:45:07.000000Z"}]},{"id":6399969,"change_date":"2024-08-06 21:43:00","inspection_id":"82311764","dot_number":"571797","report_state":"HI","report_number":"CS27000751","insp_date":"2024-08-02 00:00:00","insp_start_time":"0859","insp_end_time":"0929","registration_date":null,"region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI 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":"367412","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"722226","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-08-06 21:43:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:33.000000Z","updated_at":"2025-03-17T20:29:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10314083,"change_date":"2024-08-06 21:43:00","inspection_id":"82311764","insp_unit_id":"202253659","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:53.000000Z","updated_at":"2025-03-17T23:29:53.000000Z"}]},{"id":6387899,"change_date":"2024-08-05 21:42:00","inspection_id":"82298908","dot_number":"571797","report_state":"HI","report_number":"CB44001667","insp_date":"2024-08-01 00:00:00","insp_start_time":"1245","insp_end_time":"1315","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM LTD.","shipping_paper_number":"367360","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"718771","transaction_code":"A","transaction_date":"2024-08-05 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-08-05 21:42:00","snet_input_date":"2024-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-05 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:29.000000Z","updated_at":"2025-03-17T20:29:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10294547,"change_date":"2024-08-05 21:42:00","inspection_id":"82298908","insp_unit_id":"202229405","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:37.000000Z","updated_at":"2025-03-17T23:29:37.000000Z"},{"id":10294548,"change_date":"2024-08-05 21:42:00","inspection_id":"82298908","insp_unit_id":"202229406","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:37.000000Z","updated_at":"2025-03-17T23:29:37.000000Z"}]},{"id":6292175,"change_date":"2025-10-10 21:39:00","inspection_id":"82196470","dot_number":"571797","report_state":"HI","report_number":"CU42000467","insp_date":"2024-07-19 00:00:00","insp_start_time":"1334","insp_end_time":"1410","registration_date":"2024-07-25 00:00:00","region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM LTD.","shipping_paper_number":"366579","cargo_tank":"406","hazmat_placard_req":"Y","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-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"679205","transaction_code":"C","transaction_date":"2024-07-23 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:24.000000Z","updated_at":"2025-10-14T10:00:04.000000Z","inspection_violations":[{"id":16338807,"change_date":"2025-10-10 21:39:00","inspection_id":"82196470","insp_violation_id":"269216837","seq_no":"1","part_no":"172","part_no_section":"519D1-HMPMC","insp_viol_unit":"1","insp_unit_id":"209396486","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-13T10:17:48.000000Z","updated_at":"2025-10-14T10:15:05.000000Z","normalized_code":"172519D1HMPMC"}],"inspection_per_units":[{"id":16435493,"change_date":"2025-10-10 21:39:00","inspection_id":"82196470","insp_unit_id":"209396486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19239","insp_unit_license":"365TVZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M1AW22Y6HM082726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:16.000000Z","updated_at":"2025-10-14T09:45:05.000000Z"},{"id":16435494,"change_date":"2025-10-10 21:39:00","inspection_id":"82196470","insp_unit_id":"209396487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19340","insp_unit_license":"184WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-13T09:47:16.000000Z","updated_at":"2025-10-14T09:45:05.000000Z"}]},{"id":6124472,"change_date":"2024-07-02 21:41:00","inspection_id":"82016357","dot_number":"571797","report_state":"HI","report_number":"CB44001639","insp_date":"2024-06-27 00:00:00","insp_start_time":"1128","insp_end_time":"1200","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":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"618238","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:10.000000Z","updated_at":"2025-03-17T20:24:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9864981,"change_date":"2024-07-02 21:41:00","inspection_id":"82016357","insp_unit_id":"201690048","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19236","insp_unit_license":"001TVU","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M2AW21C5GM076691","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:12.000000Z","updated_at":"2025-03-17T23:25:12.000000Z"}]},{"id":5893490,"change_date":"2025-11-06 21:39:00","inspection_id":"81766462","dot_number":"571797","report_state":"HI","report_number":"CK46001993","insp_date":"2024-05-31 00:00:00","insp_start_time":"1251","insp_end_time":"1323","registration_date":"2024-06-10 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: COSTCO WHOLESALE IWILEI","shipping_paper_number":"363645","cargo_tank":"406","hazmat_placard_req":"Y","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-03 21:41: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":"535756","transaction_code":"C","transaction_date":"2024-06-03 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-06-03 21:41:00","snet_input_date":"2024-05-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-03 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-11-10T10:30:05.000000Z","inspection_violations":[{"id":16805321,"change_date":"2025-11-06 21:39:00","inspection_id":"81766462","insp_violation_id":"269774131","seq_no":"1","part_no":"393","part_no_section":"95A3","insp_viol_unit":"1","insp_unit_id":"209875818","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:28.000000Z","updated_at":"2025-11-10T10:30:06.000000Z","normalized_code":"39395A3"}],"inspection_per_units":[{"id":16862142,"change_date":"2025-11-06 21:39:00","inspection_id":"81766462","insp_unit_id":"209875818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:45.000000Z","updated_at":"2025-11-10T10:00:05.000000Z"},{"id":16862143,"change_date":"2025-11-06 21:39:00","inspection_id":"81766462","insp_unit_id":"209875819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:45.000000Z","updated_at":"2025-11-10T10:00:05.000000Z"}]},{"id":5775143,"change_date":"2024-05-17 21:39:00","inspection_id":"81638264","dot_number":"571797","report_state":"HI","report_number":"CT31000729","insp_date":"2024-05-15 00:00:00","insp_start_time":"1252","insp_end_time":"1355","registration_date":null,"region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI - OPAKAPAKA STREET","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"362740","cargo_tank":"406","hazmat_placard_req":"Y","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"490373","transaction_code":"A","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-05-17 21:39:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-17 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:08.000000Z","updated_at":"2025-03-17T20:17:08.000000Z","inspection_violations":[{"id":8941732,"change_date":"2024-05-17 21:39:00","inspection_id":"81638264","insp_violation_id":"259566617","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200946395","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":9301888,"change_date":"2024-05-17 21:39:00","inspection_id":"81638264","insp_unit_id":"200946394","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"Y","insp_unit_decal_number":"34087564","created_at":"2025-03-17T23:19:36.000000Z","updated_at":"2025-03-17T23:19:36.000000Z"},{"id":9301889,"change_date":"2024-05-17 21:39:00","inspection_id":"81638264","insp_unit_id":"200946395","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:36.000000Z","updated_at":"2025-03-17T23:19:36.000000Z"}]},{"id":5775087,"change_date":"2025-11-06 21:40:00","inspection_id":"81638201","dot_number":"571797","report_state":"HI","report_number":"CK46001988","insp_date":"2024-05-15 00:00:00","insp_start_time":"0856","insp_end_time":"0930","registration_date":"2024-05-20 00:00:00","region":"HS","ci_status_code":"C","location":"103","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: IMM WAHIAWA","shipping_paper_number":"362731","cargo_tank":"406","hazmat_placard_req":"Y","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"490364","transaction_code":"C","transaction_date":"2024-05-17 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-05-17 21:39:00","snet_input_date":"2024-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-17 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:07.000000Z","updated_at":"2025-11-10T10:30:31.000000Z","inspection_violations":[{"id":16814098,"change_date":"2025-11-06 21:40:00","inspection_id":"81638201","insp_violation_id":"269778541","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209879238","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:42.000000Z","updated_at":"2025-11-10T10:30:55.000000Z","normalized_code":"39021TB2DOT"},{"id":16814099,"change_date":"2025-11-06 21:40:00","inspection_id":"81638201","insp_violation_id":"269778542","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209879238","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:42.000000Z","updated_at":"2025-11-10T10:30:55.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":16868877,"change_date":"2025-11-06 21:40:00","inspection_id":"81638201","insp_unit_id":"209879238","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19240","insp_unit_license":"364TWA","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M1AW22Y8HM082727","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:50.000000Z","updated_at":"2025-11-10T10:00:40.000000Z"},{"id":16868878,"change_date":"2025-11-06 21:40:00","inspection_id":"81638201","insp_unit_id":"209879239","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEILITE TR","insp_unit_company":"19340","insp_unit_license":"184WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:50.000000Z","updated_at":"2025-11-10T10:00:40.000000Z"}]},{"id":5583136,"change_date":"2025-10-01 21:39:00","inspection_id":"81429610","dot_number":"571797","report_state":"HI","report_number":"CT31000704","insp_date":"2024-04-23 00:00:00","insp_start_time":"0940","insp_end_time":"1012","registration_date":"2025-04-24 00:00:00","region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"361440","cargo_tank":"406","hazmat_placard_req":"Y","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"424730","transaction_code":"C","transaction_date":"2024-04-24 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:28.000000Z","updated_at":"2025-10-05T10:00:06.000000Z","inspection_violations":[{"id":16163649,"change_date":"2025-10-01 21:39:00","inspection_id":"81429610","insp_violation_id":"269029432","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209238958","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:33.000000Z","updated_at":"2025-10-05T10:15:09.000000Z","normalized_code":"3939ALIL"},{"id":16163650,"change_date":"2025-10-01 21:39:00","inspection_id":"81429610","insp_violation_id":"269029433","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"209238957","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-04T10:17:33.000000Z","updated_at":"2025-10-05T10:15:09.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":16281604,"change_date":"2025-10-01 21:39:00","inspection_id":"81429610","insp_unit_id":"209238957","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:46:55.000000Z","updated_at":"2025-10-05T09:45:07.000000Z"},{"id":16281605,"change_date":"2025-10-01 21:39:00","inspection_id":"81429610","insp_unit_id":"209238958","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL CO.,","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-04T09:46:55.000000Z","updated_at":"2025-10-05T09:45:07.000000Z"}]},{"id":5081126,"change_date":"2024-02-20 21:41:00","inspection_id":"80882075","dot_number":"571797","report_state":"HI","report_number":"CK46001922","insp_date":"2024-02-13 00:00:00","insp_start_time":"0843","insp_end_time":"0915","registration_date":null,"region":"HS","ci_status_code":"C","location":"104","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: DFASNAVFAC HAWAII","shipping_paper_number":"357235","cargo_tank":"406","hazmat_placard_req":"Y","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-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"94598","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":"255211","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:25.000000Z","updated_at":"2025-03-17T20:03:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8180250,"change_date":"2024-02-20 21:41:00","inspection_id":"80882075","insp_unit_id":"199486128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:10.000000Z","updated_at":"2025-03-17T23:09:10.000000Z"},{"id":8180251,"change_date":"2024-02-20 21:41:00","inspection_id":"80882075","insp_unit_id":"199486129","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"19315","insp_unit_license":"082WEC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1BN1T25225P031033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:10.000000Z","updated_at":"2025-03-17T23:09:10.000000Z"}]},{"id":4509672,"change_date":"2023-11-28 21:41:00","inspection_id":"80256548","dot_number":"571797","report_state":"HI","report_number":"CS27000580","insp_date":"2023-11-28 00:00:00","insp_start_time":"0909","insp_end_time":"0943","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"353072","cargo_tank":"406","hazmat_placard_req":"Y","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"135522","transaction_code":"A","transaction_date":"2023-11-28 00:00:00","upload_date":"2023-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-11-28 21:41:00","snet_input_date":"2023-11-28 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-11-28 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:12.000000Z","updated_at":"2025-03-17T19:52:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7253184,"change_date":"2023-11-28 21:41:00","inspection_id":"80256548","insp_unit_id":"198246485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19244","insp_unit_license":"058TXG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDVXMLML3675","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:55.000000Z","updated_at":"2025-03-17T23:00:55.000000Z"},{"id":7253185,"change_date":"2023-11-28 21:41:00","inspection_id":"80256548","insp_unit_id":"198246486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"19337","insp_unit_license":"219HZF","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66628","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:55.000000Z","updated_at":"2025-03-17T23:00:55.000000Z"}]},{"id":3889643,"change_date":"2023-09-01 21:39:00","inspection_id":"79570169","dot_number":"571797","report_state":"HI","report_number":"CQ41000110","insp_date":"2023-08-30 00:00:00","insp_start_time":"1043","insp_end_time":"1110","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":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"34786","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"134789","transaction_code":"A","transaction_date":"2023-08-30 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6253613,"change_date":"2023-09-01 21:39:00","inspection_id":"79570169","insp_unit_id":"196867291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"}]},{"id":3724167,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","dot_number":"571797","report_state":"HI","report_number":"00CK001792","insp_date":"2023-08-09 00:00:00","insp_start_time":"0901","insp_end_time":"0952","registration_date":"2023-09-05 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CONSIGNEE: IMM WAIPIO GENTRY","shipping_paper_number":"346427","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134519","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5743102,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_violation_id":"255167243","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196970334","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"},{"id":5743103,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_violation_id":"255167244","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196970334","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3922"},{"id":5743104,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_violation_id":"255167245","seq_no":"3","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"196970334","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39021TC"},{"id":5743105,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_violation_id":"255167246","seq_no":"4","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"196970334","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39395B"},{"id":5743106,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_violation_id":"255167247","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196970334","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5988246,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_unit_id":"196970334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19239","insp_unit_license":"365TVZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M1AW22Y6HM082726","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5988247,"change_date":"2023-09-08 21:41:00","inspection_id":"79385375","insp_unit_id":"196970335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"19340","insp_unit_license":"184WEV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM442X27H66631","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3724168,"change_date":"2023-08-11 21:39:00","inspection_id":"79385376","dot_number":"571797","report_state":"HI","report_number":"00CK001793","insp_date":"2023-08-09 00:00:00","insp_start_time":"1022","insp_end_time":"1047","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CONSIGNEE: DFAS-NAVFAC HAWAII","shipping_paper_number":"346424","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"94600","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":"134538","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5988248,"change_date":"2023-08-11 21:39:00","inspection_id":"79385376","insp_unit_id":"196489979","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"19256","insp_unit_license":"852TXV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKZLP9X6PJ262888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5988249,"change_date":"2023-08-11 21:39:00","inspection_id":"79385376","insp_unit_id":"196489980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"19315","insp_unit_license":"082WEC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1BN1T25225P031033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3724169,"change_date":"2023-08-11 21:39:00","inspection_id":"79385377","dot_number":"571797","report_state":"HI","report_number":"00CK001794","insp_date":"2023-08-09 00:00:00","insp_start_time":"1337","insp_end_time":"1349","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"CONSIGNEE: AEKO KUA INC","shipping_paper_number":"346442","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"134539","transaction_code":"A","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5988250,"change_date":"2023-08-11 21:39:00","inspection_id":"79385377","insp_unit_id":"196489981","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19242","insp_unit_license":"712TXB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPCLP9X0LD667153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3724184,"change_date":"2023-08-22 21:43:00","inspection_id":"79385392","dot_number":"571797","report_state":"HI","report_number":"CU42000107","insp_date":"2023-08-09 00:00:00","insp_start_time":"0851","insp_end_time":"0948","registration_date":"2023-08-16 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","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":"346416","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"134546","transaction_code":"C","transaction_date":"2023-08-09 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-08-11 21:39:00","snet_input_date":"2023-08-11 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-11 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:28.000000Z","updated_at":"2025-03-17T19:36:28.000000Z","inspection_violations":[{"id":5743126,"change_date":"2023-08-22 21:43:00","inspection_id":"79385392","insp_violation_id":"254807792","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196668202","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39347E"},{"id":5743127,"change_date":"2023-08-22 21:43:00","inspection_id":"79385392","insp_violation_id":"254807793","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196668202","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:37.000000Z","updated_at":"2025-03-17T21:33:37.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":5988267,"change_date":"2023-08-22 21:43:00","inspection_id":"79385392","insp_unit_id":"196668202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"},{"id":5988268,"change_date":"2023-08-22 21:43:00","inspection_id":"79385392","insp_unit_id":"196668203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:19.000000Z","updated_at":"2025-03-17T22:50:19.000000Z"}]},{"id":3757339,"change_date":"2023-08-22 21:43:00","inspection_id":"79422197","dot_number":"571797","report_state":"HI","report_number":"CQ41000079","insp_date":"2023-08-03 00:00:00","insp_start_time":"0916","insp_end_time":"1018","registration_date":"2023-08-16 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM, LTD.","shipping_paper_number":"346030","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"134567","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-08-16 21:39:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[{"id":5794430,"change_date":"2023-08-22 21:43:00","inspection_id":"79422197","insp_violation_id":"254807735","seq_no":"1","part_no":"393","part_no_section":"201(b)","insp_viol_unit":"1","insp_unit_id":"196668169","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"393201B"},{"id":5794431,"change_date":"2023-08-22 21:43:00","inspection_id":"79422197","insp_violation_id":"254807736","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"196668169","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39395B"},{"id":5794432,"change_date":"2023-08-22 21:43:00","inspection_id":"79422197","insp_violation_id":"254807737","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196668169","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":6041721,"change_date":"2023-08-22 21:43:00","inspection_id":"79422197","insp_unit_id":"196668169","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"19235","insp_unit_license":"310TVT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M2AW21C3GM076690","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3297108,"change_date":"2023-06-15 21:42:00","inspection_id":"78906157","dot_number":"571797","report_state":"HI","report_number":"00CK001746","insp_date":"2023-06-13 00:00:00","insp_start_time":"0849","insp_end_time":"0930","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"342870","cargo_tank":"406","hazmat_placard_req":"Y","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-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"1","hazmat_oos_total":"0","snet_sequence_id":"134123","transaction_code":"A","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[{"id":5084951,"change_date":"2023-06-15 21:42:00","inspection_id":"78906157","insp_violation_id":"253536406","seq_no":"1","part_no":"172","part_no_section":"602(c)(1)","insp_viol_unit":"1","insp_unit_id":"195525827","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"172602C1"}],"inspection_per_units":[{"id":5300993,"change_date":"2023-06-15 21:42:00","inspection_id":"78906157","insp_unit_id":"195525827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19220","insp_unit_license":"724TXP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPTLU9X5BD118688","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:49.000000Z","updated_at":"2025-03-17T22:44:49.000000Z"}]},{"id":1799113,"change_date":"2022-11-22 21:41:00","inspection_id":"77202269","dot_number":"571797","report_state":"HI","report_number":"00BY002153","insp_date":"2022-11-17 00:00:00","insp_start_time":"1046","insp_end_time":"1110","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":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"132922","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-11-22 21:41:00","snet_input_date":"2022-11-22 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:42.000000Z","updated_at":"2025-03-17T18:59:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2893987,"change_date":"2022-11-22 21:41:00","inspection_id":"77202269","insp_unit_id":"192091813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19242","insp_unit_license":"712TXB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPCLP9X0LD667153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:48.000000Z","updated_at":"2025-03-17T22:26:48.000000Z"}]},{"id":1626148,"change_date":"2022-10-28 21:40:00","inspection_id":"77003883","dot_number":"571797","report_state":"HI","report_number":"CP19000484","insp_date":"2022-10-27 00:00:00","insp_start_time":"0846","insp_end_time":"0922","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"132766","transaction_code":"A","transaction_date":"2022-10-27 00:00:00","upload_date":"2022-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-10-28 21:40:00","snet_input_date":"2022-10-28 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-28 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:39.000000Z","updated_at":"2025-03-17T18:56:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2616224,"change_date":"2022-10-28 21:40:00","inspection_id":"77003883","insp_unit_id":"191699685","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19242","insp_unit_license":"712TXB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPCLP9X0LD667153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:56.000000Z","updated_at":"2025-03-17T22:24:56.000000Z"}]},{"id":1518614,"change_date":"2022-10-19 21:41:00","inspection_id":"76880181","dot_number":"571797","report_state":"HI","report_number":"00BP002555","insp_date":"2022-10-13 00:00:00","insp_start_time":"0958","insp_end_time":"1029","registration_date":"2022-10-17 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM LTD","shipping_paper_number":"328767","cargo_tank":"406","hazmat_placard_req":"Y","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-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"132636","transaction_code":"C","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:32.000000Z","updated_at":"2025-03-17T18:54:32.000000Z","inspection_violations":[{"id":2391868,"change_date":"2022-10-19 21:41:00","inspection_id":"76880181","insp_violation_id":"249124957","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191526799","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"3922"},{"id":2391869,"change_date":"2022-10-19 21:41:00","inspection_id":"76880181","insp_violation_id":"249124958","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191526799","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2443975,"change_date":"2022-10-19 21:41:00","inspection_id":"76880181","insp_unit_id":"191526798","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"},{"id":2443976,"change_date":"2022-10-19 21:41:00","inspection_id":"76880181","insp_unit_id":"191526799","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"}]},{"id":483622,"change_date":"2022-06-01 21:50:00","inspection_id":"75669841","dot_number":"571797","report_state":"HI","report_number":"CS27000108","insp_date":"2022-05-24 00:00:00","insp_start_time":"0850","insp_end_time":"1017","registration_date":"2022-05-27 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","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":"320394","cargo_tank":"406","hazmat_placard_req":"Y","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-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"131837","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-25 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:18.000000Z","updated_at":"2025-03-17T18:36:18.000000Z","inspection_violations":[{"id":766043,"change_date":"2022-06-01 21:50:00","inspection_id":"75669841","insp_violation_id":"246194223","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189019862","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39347E"},{"id":766044,"change_date":"2022-06-01 21:50:00","inspection_id":"75669841","insp_violation_id":"246194224","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189019862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39353B"},{"id":766045,"change_date":"2022-06-01 21:50:00","inspection_id":"75669841","insp_violation_id":"246194225","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"189019862","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":777741,"change_date":"2022-06-01 21:50:00","inspection_id":"75669841","insp_unit_id":"189019862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19219","insp_unit_license":"296TWS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPHL49X0AD795877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:58.000000Z","updated_at":"2025-03-17T22:12:58.000000Z"}]},{"id":396367,"change_date":"2022-05-18 21:44:00","inspection_id":"75566153","dot_number":"571797","report_state":"HI","report_number":"CT31000095","insp_date":"2022-05-12 00:00:00","insp_start_time":"0832","insp_end_time":"0918","registration_date":"2022-05-13 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"319708","cargo_tank":"406","hazmat_placard_req":"Y","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-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"131747","transaction_code":"C","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-05-16 21:43:00","snet_input_date":"2022-05-16 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:27.000000Z","updated_at":"2025-03-17T18:34:27.000000Z","inspection_violations":[{"id":618946,"change_date":"2022-05-18 21:44:00","inspection_id":"75566153","insp_violation_id":"245889749","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"188765243","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39347E"},{"id":618947,"change_date":"2022-05-18 21:44:00","inspection_id":"75566153","insp_violation_id":"245889750","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"188765243","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":640434,"change_date":"2022-05-18 21:44:00","inspection_id":"75566153","insp_unit_id":"188765243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"19243","insp_unit_license":"976TWZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUGHLDV8MLML3674","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"},{"id":640435,"change_date":"2022-05-18 21:44:00","inspection_id":"75566153","insp_unit_id":"188765244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"19342","insp_unit_license":"012WFB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5HTAM4322G7H81987","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:08.000000Z","updated_at":"2025-03-17T22:12:08.000000Z"}]},{"id":359474,"change_date":"2022-05-17 21:43:00","inspection_id":"75521683","dot_number":"571797","report_state":"HI","report_number":"CT31000091","insp_date":"2022-05-09 00:00:00","insp_start_time":"1002","insp_end_time":"1100","registration_date":"2022-05-13 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"319519","cargo_tank":"406","hazmat_placard_req":"Y","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-05-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"131728","transaction_code":"C","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:42.000000Z","updated_at":"2025-03-17T18:33:42.000000Z","inspection_violations":[{"id":563142,"change_date":"2022-05-17 21:43:00","inspection_id":"75521683","insp_violation_id":"245840701","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188728300","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:42.000000Z","updated_at":"2025-03-17T21:09:42.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":581371,"change_date":"2022-05-17 21:43:00","inspection_id":"75521683","insp_unit_id":"188728300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19233","insp_unit_license":"990TVD","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPTL49X5ED245610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]},{"id":359476,"change_date":"2022-05-10 21:40:00","inspection_id":"75521685","dot_number":"571797","report_state":"HI","report_number":"00CB001240","insp_date":"2022-05-09 00:00:00","insp_start_time":"1030","insp_end_time":"1102","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM, LTD.","shipping_paper_number":"319524","cargo_tank":"406","hazmat_placard_req":"Y","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-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"131718","transaction_code":"A","transaction_date":"2022-05-09 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-10 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:42.000000Z","updated_at":"2025-03-17T18:33:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":581372,"change_date":"2022-05-10 21:40:00","inspection_id":"75521685","insp_unit_id":"188607450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"19314","insp_unit_license":"081WEC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1BN1T25205P031032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]},{"id":195204,"change_date":"2022-04-18 21:42:00","inspection_id":"75325841","dot_number":"571797","report_state":"HI","report_number":"00CK001404","insp_date":"2022-04-14 00:00:00","insp_start_time":"1041","insp_end_time":"1051","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"64180","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":"131585","transaction_code":"A","transaction_date":"2022-04-14 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-04-18 21:42:00","snet_input_date":"2022-04-18 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-04-18 21:42:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:53.000000Z","updated_at":"2025-03-17T18:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":316330,"change_date":"2022-04-18 21:42:00","inspection_id":"75325841","insp_unit_id":"188200452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"3","insp_unit_license":"090TWB","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1M2AX04C6HM036358","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:06.000000Z","updated_at":"2025-03-17T22:10:06.000000Z"}]},{"id":82623,"change_date":"2022-03-31 21:41:00","inspection_id":"75189216","dot_number":"571797","report_state":"HI","report_number":"00CB001207","insp_date":"2022-03-30 00:00:00","insp_start_time":"0903","insp_end_time":"0938","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA PETROLEUM","shipping_paper_number":"19233","cargo_tank":"406","hazmat_placard_req":"Y","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-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54320","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":"131449","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-03-31 21:41:00","snet_input_date":"2022-03-31 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":134055,"change_date":"2022-03-31 21:41:00","inspection_id":"75189216","insp_unit_id":"187923443","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19233","insp_unit_license":"990TVD","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPTL49X5ED245610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]},{"id":29586,"change_date":"2022-03-30 21:40:00","inspection_id":"75122559","dot_number":"571797","report_state":"HI","report_number":"CP19000332","insp_date":"2022-03-22 00:00:00","insp_start_time":"0941","insp_end_time":"1026","registration_date":"2022-03-24 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","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-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"94320","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":"131412","transaction_code":"C","transaction_date":"2022-03-22 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00571797","upload_search_indicator":null,"census_search_date":"2022-03-23 21:32:00","snet_input_date":"2022-03-23 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"ALOHA PETROLEUM LTD","insp_carrier_street":"1132 BISHOP STREET SUITE 1700","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96813","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:06.000000Z","updated_at":"2025-03-17T18:28:06.000000Z","inspection_violations":[{"id":42590,"change_date":"2022-03-30 21:40:00","inspection_id":"75122559","insp_violation_id":"244865268","seq_no":"1","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"187900155","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":47720,"change_date":"2022-03-30 21:40:00","inspection_id":"75122559","insp_unit_id":"187900155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"19219","insp_unit_license":"296TWS","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NPHL49X0AD795877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"},{"id":47721,"change_date":"2022-03-30 21:40:00","inspection_id":"75122559","insp_unit_id":"187900156","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"19319","insp_unit_license":"129WEJ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1PMA2252XA5008692","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/571797\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/571797\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/571797\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/www.searchcarriers.com\/company\/571797\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}