{"current_page":1,"data":[{"id":11997329,"change_date":"2026-05-22 21:38:00","inspection_id":"87935624","dot_number":"3209572","report_state":"HI","report_number":"BP16003599","insp_date":"2026-05-20 00:00:00","insp_start_time":"0945","insp_end_time":"0955","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3385565","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-25T09:41:17.000000Z","updated_at":"2026-06-02T09:32:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20856017,"change_date":"2026-05-22 21:38:00","inspection_id":"87935624","insp_unit_id":"213711765","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"126","insp_unit_license":"LEK620","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDAF5GT2EEB48527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:28.000000Z","updated_at":"2026-06-02T09:05:52.000000Z"}]},{"id":11873965,"change_date":"2026-05-11 21:38:00","inspection_id":"87811178","dot_number":"3209572","report_state":"HI","report_number":"CK46002572","insp_date":"2026-05-08 00:00:00","insp_start_time":"0924","insp_end_time":"1027","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3299913","transaction_code":"A","transaction_date":"2026-05-11 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2026-05-11 21:38:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-11 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:25.000000Z","updated_at":"2026-05-22T09:30:44.000000Z","inspection_violations":[{"id":20652998,"change_date":"2026-05-11 21:38:00","inspection_id":"87811178","insp_violation_id":"274170259","seq_no":"2","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-26-037252","created_at":"2026-05-13T13:32:47.000000Z","updated_at":"2026-05-22T09:42:26.000000Z","normalized_code":"38323A2LCDLN"},{"id":20652999,"change_date":"2026-05-11 21:38:00","inspection_id":"87811178","insp_violation_id":"274170260","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213480041","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:47.000000Z","updated_at":"2026-05-22T09:42:26.000000Z","normalized_code":"39378"},{"id":20652997,"change_date":"2026-05-11 21:38:00","inspection_id":"87811178","insp_violation_id":"274170258","seq_no":"1","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"213480041","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-13T13:32:47.000000Z","updated_at":"2026-05-22T09:42:26.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":20646098,"change_date":"2026-05-11 21:38:00","inspection_id":"87811178","insp_unit_id":"213480041","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:06.000000Z","updated_at":"2026-05-22T09:03:18.000000Z"}]},{"id":11596915,"change_date":"2026-04-08 21:38:00","inspection_id":"87523161","dot_number":"3209572","report_state":"HI","report_number":"BY39003008","insp_date":"2026-04-07 00:00:00","insp_start_time":"1019","insp_end_time":"1047","registration_date":null,"region":"HS","ci_status_code":"C","location":"10","location_desc":"WAHIAWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3130567","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2026-04-08 21:38:00","snet_input_date":"2026-04-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-08 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-11T09:42:40.000000Z","updated_at":"2026-04-19T09:32:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19877947,"change_date":"2026-04-08 21:38:00","inspection_id":"87523161","insp_unit_id":"212606437","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"51","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"Y","insp_unit_decal_number":"36451884","created_at":"2026-04-11T09:19:44.000000Z","updated_at":"2026-04-18T09:37:07.000000Z"}]},{"id":11342095,"change_date":"2026-03-11 21:38:00","inspection_id":"87259786","dot_number":"3209572","report_state":"HI","report_number":"CQ41000665","insp_date":"2026-03-10 00:00:00","insp_start_time":"1008","insp_end_time":"1042","registration_date":null,"region":"HS","ci_status_code":"C","location":"10","location_desc":"WAHIAWA 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-03-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2992301","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2026-03-11 21:38:00","snet_input_date":"2026-03-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-11 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-14T09:38:15.000000Z","updated_at":"2026-03-22T09:31:33.000000Z","inspection_violations":[{"id":19100724,"change_date":"2026-03-11 21:38:00","inspection_id":"87259786","insp_violation_id":"272331785","seq_no":"1","part_no":"393","part_no_section":"28-WS-6","insp_viol_unit":"1","insp_unit_id":"212079784","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:13.000000Z","updated_at":"2026-03-22T09:52:11.000000Z","normalized_code":"39328WS6"}],"inspection_per_units":[{"id":19409977,"change_date":"2026-03-11 21:38:00","inspection_id":"87259786","insp_unit_id":"212079784","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"126","insp_unit_license":"LEK620","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDAF5GT2EEB48527","insp_unit_decal":"Y","insp_unit_decal_number":"36124683","created_at":"2026-03-14T09:14:53.000000Z","updated_at":"2026-03-22T09:10:25.000000Z"}]},{"id":10786692,"change_date":"2026-01-16 21:39:00","inspection_id":"86812625","dot_number":"3209572","report_state":"HI","report_number":"CQ41000621","insp_date":"2026-01-14 00:00:00","insp_start_time":"0946","insp_end_time":"1005","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2775705","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:53.000000Z","updated_at":"2026-01-27T10:30:21.000000Z","inspection_violations":[{"id":18025214,"change_date":"2026-01-16 21:39:00","inspection_id":"86812625","insp_violation_id":"271247643","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"211126379","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-19T10:43:20.000000Z","updated_at":"2026-01-27T10:30:38.000000Z","normalized_code":"3929BAINACTIVEINTRA"}],"inspection_per_units":[{"id":18110110,"change_date":"2026-01-16 21:39:00","inspection_id":"86812625","insp_unit_id":"211126379","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:22.000000Z","updated_at":"2026-01-27T10:00:23.000000Z"}]},{"id":10143697,"change_date":"2025-11-07 21:39:00","inspection_id":"86261506","dot_number":"3209572","report_state":"HI","report_number":"BY39002891","insp_date":"2025-11-05 00:00:00","insp_start_time":"1137","insp_end_time":"1150","registration_date":null,"region":"HS","ci_status_code":"C","location":"30","location_desc":"HALEIWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"9000","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":"2514580","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-11-07 21:39:00","snet_input_date":"2025-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-07 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-10T10:31:34.000000Z","updated_at":"2025-11-11T10:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16886389,"change_date":"2025-11-07 21:39:00","inspection_id":"86261506","insp_unit_id":"209896142","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T2017","insp_unit_license":"LKF412","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBZX2CG5HKA30770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:08.000000Z","updated_at":"2025-11-11T10:00:38.000000Z"}]},{"id":9968703,"change_date":"2025-10-17 21:39:00","inspection_id":"86077214","dot_number":"3209572","report_state":"HI","report_number":"BP16003458","insp_date":"2025-10-15 00:00:00","insp_start_time":"0829","insp_end_time":"0906","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2424327","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-10-17 21:39:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-17 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:50.000000Z","updated_at":"2025-10-21T10:00:30.000000Z","inspection_violations":[{"id":16467583,"change_date":"2025-10-17 21:39:00","inspection_id":"86077214","insp_violation_id":"269361122","seq_no":"1","part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"1","insp_unit_id":"209522116","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-20T10:17:49.000000Z","updated_at":"2025-10-21T10:15:58.000000Z","normalized_code":"39375A3ATIS"}],"inspection_per_units":[{"id":16552439,"change_date":"2025-10-17 21:39:00","inspection_id":"86077214","insp_unit_id":"209522116","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"Y","insp_unit_decal_number":"35830056","created_at":"2025-10-20T09:47:03.000000Z","updated_at":"2025-10-21T09:45:41.000000Z"}]},{"id":9947947,"change_date":"2025-10-15 21:39:00","inspection_id":"86055403","dot_number":"3209572","report_state":"HI","report_number":"CS27001079","insp_date":"2025-10-14 00:00:00","insp_start_time":"0924","insp_end_time":"0954","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2416325","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:53.000000Z","updated_at":"2025-10-19T10:00:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16514822,"change_date":"2025-10-15 21:39:00","inspection_id":"86055403","insp_unit_id":"209481284","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:45:54.000000Z"}]},{"id":9352106,"change_date":"2025-08-07 21:39:00","inspection_id":"85429247","dot_number":"3209572","report_state":"HI","report_number":"CQ41000560","insp_date":"2025-08-06 00:00:00","insp_start_time":"1000","insp_end_time":"1016","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2098856","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:40.000000Z","updated_at":"2025-08-12T10:42:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15406067,"change_date":"2025-08-07 21:39:00","inspection_id":"85429247","insp_unit_id":"208281583","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:19.000000Z","updated_at":"2025-08-11T09:45:43.000000Z"}]},{"id":9295663,"change_date":"2025-07-31 21:40:00","inspection_id":"85369996","dot_number":"3209572","report_state":"HI","report_number":"CB44001851","insp_date":"2025-07-30 00:00:00","insp_start_time":"0912","insp_end_time":"0945","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2068475","transaction_code":"A","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-07-31 21:40:00","snet_input_date":"2025-07-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-31 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:26.000000Z","updated_at":"2025-08-04T10:01:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15305603,"change_date":"2025-07-31 21:40:00","inspection_id":"85369996","insp_unit_id":"208173151","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"Y","insp_unit_decal_number":"35562653","created_at":"2025-08-03T09:46:21.000000Z","updated_at":"2025-08-04T09:45:38.000000Z"}]},{"id":9182337,"change_date":"2025-10-07 21:40:00","inspection_id":"85250519","dot_number":"3209572","report_state":"HI","report_number":"BY39002789","insp_date":"2025-07-16 00:00:00","insp_start_time":"0810","insp_end_time":"0856","registration_date":"2025-07-22 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"2006516","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":"03209572","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 SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:28.000000Z","updated_at":"2025-10-11T10:00:05.000000Z","inspection_violations":[{"id":16267275,"change_date":"2025-10-07 21:40:00","inspection_id":"85250519","insp_violation_id":"269136880","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209331996","insp_violation_category_id":"23","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":"39375A3TAOL"}],"inspection_per_units":[{"id":16375462,"change_date":"2025-10-07 21:40:00","inspection_id":"85250519","insp_unit_id":"209331996","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","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":9182362,"change_date":"2025-07-18 21:39:00","inspection_id":"85250545","dot_number":"3209572","report_state":"HI","report_number":"CP19001212","insp_date":"2025-07-15 00:00:00","insp_start_time":"1026","insp_end_time":"1036","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2006489","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-07-18 21:39:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-18 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:28.000000Z","updated_at":"2025-07-22T10:44:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15090380,"change_date":"2025-07-18 21:39:00","inspection_id":"85250545","insp_unit_id":"207940395","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BUS301","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:30.000000Z","updated_at":"2025-07-22T09:45:14.000000Z"}]},{"id":9050006,"change_date":"2025-07-02 21:40:00","inspection_id":"85111266","dot_number":"3209572","report_state":"HI","report_number":"CB44001827","insp_date":"2025-07-01 00:00:00","insp_start_time":"1001","insp_end_time":"1031","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1943255","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:22.000000Z","updated_at":"2025-07-07T10:07:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14847746,"change_date":"2025-07-02 21:40:00","inspection_id":"85111266","insp_unit_id":"207676534","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BUS301","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"Y","insp_unit_decal_number":"35562646","created_at":"2025-07-05T09:46:09.000000Z","updated_at":"2025-07-06T09:45:43.000000Z"}]},{"id":9050008,"change_date":"2025-07-02 21:40:00","inspection_id":"85111268","dot_number":"3209572","report_state":"HI","report_number":"CB44001826","insp_date":"2025-07-01 00:00:00","insp_start_time":"0901","insp_end_time":"0937","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1943254","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:22.000000Z","updated_at":"2025-07-07T10:07:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14847749,"change_date":"2025-07-02 21:40:00","inspection_id":"85111268","insp_unit_id":"207676537","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","insp_unit_decal":"Y","insp_unit_decal_number":"35562645","created_at":"2025-07-05T09:46:09.000000Z","updated_at":"2025-07-06T09:45:43.000000Z"}]},{"id":8694713,"change_date":"2025-10-03 21:39:00","inspection_id":"84735158","dot_number":"3209572","report_state":"HI","report_number":"CS27000964","insp_date":"2025-05-20 00:00:00","insp_start_time":"0902","insp_end_time":"0955","registration_date":"2025-05-21 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1757285","transaction_code":"C","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-05-21 21:41:00","snet_input_date":"2025-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-21 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:03:36.000000Z","updated_at":"2025-10-08T10:00:06.000000Z","inspection_violations":[{"id":16209263,"change_date":"2025-10-03 21:39:00","inspection_id":"84735158","insp_violation_id":"269080900","seq_no":"1","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"209284715","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:09.000000Z","normalized_code":"393209ESPSLA"},{"id":16209264,"change_date":"2025-10-03 21:39:00","inspection_id":"84735158","insp_violation_id":"269080901","seq_no":"2","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"209284715","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-25-054612","created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:09.000000Z","normalized_code":"39341BNPB"}],"inspection_per_units":[{"id":16324329,"change_date":"2025-10-03 21:39:00","inspection_id":"84735158","insp_unit_id":"209284715","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:06.000000Z","updated_at":"2025-10-08T09:45:06.000000Z"}]},{"id":8589636,"change_date":"2025-05-09 21:41:00","inspection_id":"84624582","dot_number":"3209572","report_state":"HI","report_number":"CT31000959","insp_date":"2025-05-08 00:00:00","insp_start_time":"1052","insp_end_time":"1111","registration_date":null,"region":"HS","ci_status_code":"C","location":null,"location_desc":"KANEOHE HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1707162","transaction_code":"A","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-05-09 21:41:00","snet_input_date":"2025-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-09 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:02:56.000000Z","updated_at":"2025-05-13T10:02:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14020976,"change_date":"2025-05-09 21:41:00","inspection_id":"84624582","insp_unit_id":"206777216","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:45.000000Z","updated_at":"2025-05-13T09:48:15.000000Z"}]},{"id":8094453,"change_date":"2025-10-21 21:39:00","inspection_id":"84103121","dot_number":"3209572","report_state":"HI","report_number":"CP19001124","insp_date":"2025-02-28 00:00:00","insp_start_time":"0825","insp_end_time":"0855","registration_date":"2025-03-06 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"9000","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":"1462638","transaction_code":"C","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:18.000000Z","updated_at":"2025-10-25T10:00:17.000000Z","inspection_violations":[{"id":16514798,"change_date":"2025-10-21 21:39:00","inspection_id":"84103121","insp_violation_id":"269423098","seq_no":"1","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"209575692","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-24T10:17:44.000000Z","updated_at":"2025-10-25T10:15:27.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":16596399,"change_date":"2025-10-21 21:39:00","inspection_id":"84103121","insp_unit_id":"209575692","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"T2017","insp_unit_license":"LKF412","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBZX2CG5HKA30770","insp_unit_decal":"Y","insp_unit_decal_number":"35014013","created_at":"2025-10-24T09:47:01.000000Z","updated_at":"2025-10-25T09:45:19.000000Z"}]},{"id":7590743,"change_date":"2025-01-10 21:39:00","inspection_id":"83574056","dot_number":"3209572","report_state":"HI","report_number":"BP16003285","insp_date":"2025-01-09 00:00:00","insp_start_time":"0830","insp_end_time":"0857","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234326","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-01-10 21:39:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-10 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:42.000000Z","updated_at":"2025-03-17T20:55:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12247941,"change_date":"2025-01-10 21:39:00","inspection_id":"83574056","insp_unit_id":"204743664","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"Y","insp_unit_decal_number":"35013924","created_at":"2025-03-17T23:50:11.000000Z","updated_at":"2025-03-17T23:50:11.000000Z"}]},{"id":7572234,"change_date":"2025-01-08 21:39:00","inspection_id":"83554655","dot_number":"3209572","report_state":"HI","report_number":"CT31000901","insp_date":"2025-01-07 00:00:00","insp_start_time":"0947","insp_end_time":"1001","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226741","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12217781,"change_date":"2025-01-08 21:39:00","inspection_id":"83554655","insp_unit_id":"204703023","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:52.000000Z","updated_at":"2025-03-17T23:49:52.000000Z"}]},{"id":7554077,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","dot_number":"3209572","report_state":"HI","report_number":"CK46002166","insp_date":"2025-01-03 00:00:00","insp_start_time":"0817","insp_end_time":"0919","registration_date":"2025-01-05 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","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":"1220766","transaction_code":"C","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2025-01-06 21:39:00","snet_input_date":"2025-01-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-10-08T10:01:23.000000Z","inspection_violations":[{"id":16229553,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","insp_violation_id":"269093851","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209295195","insp_violation_category_id":"20","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":"3939ALIL"},{"id":16229554,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","insp_violation_id":"269093852","seq_no":"2","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"209295195","insp_violation_category_id":"20","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":"39311A1LIL"},{"id":16229555,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","insp_violation_id":"269093853","seq_no":"3","part_no":"393","part_no_section":"62-BEI","insp_viol_unit":"1","insp_unit_id":"209295195","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-25-054001","created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"39362BEI"},{"id":16229556,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","insp_violation_id":"269093854","seq_no":"4","part_no":"393","part_no_section":"9A-LPL","insp_viol_unit":"1","insp_unit_id":"209295195","insp_violation_category_id":"20","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":"3939ALPL"}],"inspection_per_units":[{"id":16341583,"change_date":"2025-10-04 21:33:00","inspection_id":"83535530","insp_unit_id":"209295195","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","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":7107298,"change_date":"2024-11-03 21:33:00","inspection_id":"83064708","dot_number":"3209572","report_state":"HI","report_number":"CS27000838","insp_date":"2024-10-31 00:00:00","insp_start_time":"0853","insp_end_time":"0921","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-03 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1014211","transaction_code":"A","transaction_date":"2024-11-02 00:00:00","upload_date":"2024-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-11-03 21:33:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-03 21:33:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11462976,"change_date":"2024-11-03 21:33:00","inspection_id":"83064708","insp_unit_id":"203708004","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BUS301","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"Y","insp_unit_decal_number":"34711993","created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"}]},{"id":7034355,"change_date":"2024-10-24 21:41:00","inspection_id":"82987255","dot_number":"3209572","report_state":"HI","report_number":"CK46002109","insp_date":"2024-10-23 00:00:00","insp_start_time":"0909","insp_end_time":"0925","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"980959","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:40.000000Z","updated_at":"2025-03-17T20:42:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11345006,"change_date":"2024-10-24 21:41:00","inspection_id":"82987255","insp_unit_id":"203564285","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"125","insp_unit_license":"SZJ705","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDGF5GY8GEA75141","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:30.000000Z","updated_at":"2025-03-17T23:40:30.000000Z"}]},{"id":6958323,"change_date":"2025-10-04 21:33:00","inspection_id":"82906472","dot_number":"3209572","report_state":"HI","report_number":"CU42000532","insp_date":"2024-10-14 00:00:00","insp_start_time":"1017","insp_end_time":"1105","registration_date":"2024-10-19 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"946632","transaction_code":"C","transaction_date":"2024-10-15 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:04.000000Z","updated_at":"2025-10-08T10:01:22.000000Z","inspection_violations":[{"id":16229530,"change_date":"2025-10-04 21:33:00","inspection_id":"82906472","insp_violation_id":"269093993","seq_no":"1","part_no":"396","part_no_section":"5A-L","insp_viol_unit":"1","insp_unit_id":"209295365","insp_violation_category_id":"30","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":"3965AL"}],"inspection_per_units":[{"id":16341573,"change_date":"2025-10-04 21:33:00","inspection_id":"82906472","insp_unit_id":"209295365","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","insp_unit_decal":"Y","insp_unit_decal_number":"34712062","created_at":"2025-10-08T09:46:42.000000Z","updated_at":"2025-10-08T09:46:42.000000Z"}]},{"id":6907476,"change_date":"2025-10-06 21:40:00","inspection_id":"82852444","dot_number":"3209572","report_state":"HI","report_number":"CK46002089","insp_date":"2024-10-04 00:00:00","insp_start_time":"0802","insp_end_time":"0900","registration_date":"2024-10-05 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14499","viol_total":"3","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":"921925","transaction_code":"C","transaction_date":"2024-10-07 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-10-08 21:40:00","snet_input_date":"2024-10-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:13.000000Z","updated_at":"2025-10-10T10:00:22.000000Z","inspection_violations":[{"id":16244599,"change_date":"2025-10-06 21:40:00","inspection_id":"82852444","insp_violation_id":"269116567","seq_no":"1","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"209313421","insp_violation_category_id":"27","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:38.000000Z","normalized_code":"39383H"},{"id":16244600,"change_date":"2025-10-06 21:40:00","inspection_id":"82852444","insp_violation_id":"269116568","seq_no":"2","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"209313421","insp_violation_category_id":"19","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:38.000000Z","normalized_code":"393203BCBP"},{"id":16244601,"change_date":"2025-10-06 21:40:00","inspection_id":"82852444","insp_violation_id":"269116569","seq_no":"3","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"209313421","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023608","created_at":"2025-10-09T10:15:49.000000Z","updated_at":"2025-10-10T10:15:38.000000Z","normalized_code":"39362BENM"}],"inspection_per_units":[{"id":16354564,"change_date":"2025-10-06 21:40:00","inspection_id":"82852444","insp_unit_id":"209313421","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","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":6889488,"change_date":"2024-10-04 21:39:00","inspection_id":"82833240","dot_number":"3209572","report_state":"HI","report_number":"CQ41000408","insp_date":"2024-10-02 00:00:00","insp_start_time":"0919","insp_end_time":"0931","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"913952","transaction_code":"A","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-10-04 21:39:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-04 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11111058,"change_date":"2024-10-04 21:39:00","inspection_id":"82833240","insp_unit_id":"203269632","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6889309,"change_date":"2024-10-04 21:39:00","inspection_id":"82833039","dot_number":"3209572","report_state":"HI","report_number":"BP16003201","insp_date":"2024-10-01 00:00:00","insp_start_time":"0847","insp_end_time":"0901","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"913891","transaction_code":"A","transaction_date":"2024-10-04 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-10-04 21:39:00","snet_input_date":"2024-10-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-04 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11110790,"change_date":"2024-10-04 21:39:00","inspection_id":"82833039","insp_unit_id":"203269297","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"Y","insp_unit_decal_number":"34711942","created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6365685,"change_date":"2025-10-10 21:39:00","inspection_id":"82275003","dot_number":"3209572","report_state":"HI","report_number":"BP16003127","insp_date":"2024-07-31 00:00:00","insp_start_time":"0841","insp_end_time":"0911","registration_date":"2024-08-01 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"708367","transaction_code":"C","transaction_date":"2024-08-01 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:04.000000Z","updated_at":"2025-10-14T10:00:04.000000Z","inspection_violations":[{"id":16338814,"change_date":"2025-10-10 21:39:00","inspection_id":"82275003","insp_violation_id":"269217248","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209396691","insp_violation_category_id":"20","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":"3939ALHLI"}],"inspection_per_units":[{"id":16435500,"change_date":"2025-10-10 21:39:00","inspection_id":"82275003","insp_unit_id":"209396691","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","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":6340550,"change_date":"2024-07-30 21:42:00","inspection_id":"82248103","dot_number":"3209572","report_state":"HI","report_number":"CB44001657","insp_date":"2024-07-26 00:00:00","insp_start_time":"1031","insp_end_time":"1101","registration_date":null,"region":"HS","ci_status_code":"C","location":"10","location_desc":"WAHIAWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"696687","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-07-30 21:42:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-30 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:38.000000Z","updated_at":"2025-03-17T20:28:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10217226,"change_date":"2024-07-30 21:42:00","inspection_id":"82248103","insp_unit_id":"202133449","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BUS301","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"Y","insp_unit_decal_number":"34449412","created_at":"2025-03-17T23:28:49.000000Z","updated_at":"2025-03-17T23:28:49.000000Z"}]},{"id":6294930,"change_date":"2025-10-10 21:39:00","inspection_id":"82199445","dot_number":"3209572","report_state":"HI","report_number":"BY39002539","insp_date":"2024-07-23 00:00:00","insp_start_time":"0901","insp_end_time":"0950","registration_date":"2024-07-25 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"682362","transaction_code":"C","transaction_date":"2024-07-24 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-07-24 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-24 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:25.000000Z","updated_at":"2025-10-14T10:00:04.000000Z","inspection_violations":[{"id":16338808,"change_date":"2025-10-10 21:39:00","inspection_id":"82199445","insp_violation_id":"269217107","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"209396612","insp_violation_category_id":"22","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":"393207ASAPPCBLM"},{"id":16338809,"change_date":"2025-10-10 21:39:00","inspection_id":"82199445","insp_violation_id":"269217108","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209396612","insp_violation_category_id":"30","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":"3965BL"}],"inspection_per_units":[{"id":16435495,"change_date":"2025-10-10 21:39:00","inspection_id":"82199445","insp_unit_id":"209396612","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","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":6216412,"change_date":"2025-10-10 21:39:00","inspection_id":"82115239","dot_number":"3209572","report_state":"HI","report_number":"BY39002523","insp_date":"2024-07-12 00:00:00","insp_start_time":"0950","insp_end_time":"1025","registration_date":"2024-07-17 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"654262","transaction_code":"C","transaction_date":"2024-07-15 00:00:00","upload_date":"2025-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-07-15 21:41:00","snet_input_date":"2024-07-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-15 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:49.000000Z","updated_at":"2025-10-14T10:00:04.000000Z","inspection_violations":[{"id":16338781,"change_date":"2025-10-10 21:39:00","inspection_id":"82115239","insp_violation_id":"269216813","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"209396475","insp_violation_category_id":"22","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":"393207ASAPPCBLM"}],"inspection_per_units":[{"id":16435482,"change_date":"2025-10-10 21:39:00","inspection_id":"82115239","insp_unit_id":"209396475","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"BUS 301","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","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":6183531,"change_date":"2024-07-10 21:40:00","inspection_id":"82079977","dot_number":"3209572","report_state":"HI","report_number":"CK46002022","insp_date":"2024-07-09 00:00:00","insp_start_time":"0931","insp_end_time":"0947","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14498","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":"641360","transaction_code":"A","transaction_date":"2024-07-10 00:00:00","upload_date":"2024-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-07-10 21:40:00","snet_input_date":"2024-07-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-10 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:21.000000Z","updated_at":"2025-03-17T20:25:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9961489,"change_date":"2024-07-10 21:40:00","inspection_id":"82079977","insp_unit_id":"201812186","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:13.000000Z","updated_at":"2025-03-17T23:26:13.000000Z"}]},{"id":6139540,"change_date":"2025-10-29 21:40:00","inspection_id":"82032670","dot_number":"3209572","report_state":"HI","report_number":"BY39002508","insp_date":"2024-07-01 00:00:00","insp_start_time":"0829","insp_end_time":"0912","registration_date":"2024-07-03 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"624596","transaction_code":"C","transaction_date":"2024-07-03 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-07-03 21:39:00","snet_input_date":"2024-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-03 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:15.000000Z","updated_at":"2025-11-02T11:00:19.000000Z","inspection_violations":[{"id":16658880,"change_date":"2025-10-29 21:40:00","inspection_id":"82032670","insp_violation_id":"269585671","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPCBLM","insp_viol_unit":"1","insp_unit_id":"209711052","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:38.000000Z","updated_at":"2025-11-02T11:15:25.000000Z","normalized_code":"393207ASAPPCBLM"},{"id":16658881,"change_date":"2025-10-29 21:40:00","inspection_id":"82032670","insp_violation_id":"269585672","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209711052","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:38.000000Z","updated_at":"2025-11-02T11:15:25.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":16722173,"change_date":"2025-10-29 21:40:00","inspection_id":"82032670","insp_unit_id":"209711052","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12C","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:56.000000Z","updated_at":"2025-11-02T10:45:24.000000Z"}]},{"id":6090660,"change_date":"2025-10-29 21:40:00","inspection_id":"81980193","dot_number":"3209572","report_state":"HI","report_number":"BP16003085","insp_date":"2024-06-24 00:00:00","insp_start_time":"0838","insp_end_time":"0921","registration_date":"2024-07-01 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"607260","transaction_code":"C","transaction_date":"2024-06-27 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-06-27 21:40:00","snet_input_date":"2024-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:23.000000Z","updated_at":"2025-11-02T11:00:19.000000Z","inspection_violations":[{"id":16658864,"change_date":"2025-10-29 21:40:00","inspection_id":"81980193","insp_violation_id":"269589936","seq_no":"1","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"209714091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:17:38.000000Z","updated_at":"2025-11-02T11:15:25.000000Z","normalized_code":"3939ALHWS"},{"id":16658865,"change_date":"2025-10-29 21:40:00","inspection_id":"81980193","insp_violation_id":"269589937","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"209714091","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023058","created_at":"2025-11-01T10:17:38.000000Z","updated_at":"2025-11-02T11:15:25.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":16722167,"change_date":"2025-10-29 21:40:00","inspection_id":"81980193","insp_unit_id":"209714091","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"119","insp_unit_license":"SBT380","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5DDB21810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:46:56.000000Z","updated_at":"2025-11-02T10:45:24.000000Z"}]},{"id":6044038,"change_date":"2024-06-21 21:38:00","inspection_id":"81929962","dot_number":"3209572","report_state":"HI","report_number":"CT31000755","insp_date":"2024-06-20 00:00:00","insp_start_time":"1005","insp_end_time":"1017","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14499","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":"589517","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-06-21 21:38:00","snet_input_date":"2024-06-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-21 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:35.000000Z","updated_at":"2025-03-17T20:22:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9734619,"change_date":"2024-06-21 21:38:00","inspection_id":"81929962","insp_unit_id":"201520360","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:50.000000Z","updated_at":"2025-03-17T23:23:50.000000Z"}]},{"id":5738064,"change_date":"2024-05-14 21:41:00","inspection_id":"81598145","dot_number":"3209572","report_state":"HI","report_number":"CT31000722","insp_date":"2024-05-13 00:00:00","insp_start_time":"1054","insp_end_time":"1138","registration_date":null,"region":"HS","ci_status_code":"C","location":"10","location_desc":"WAHIAWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"479837","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-05-14 21:41:00","snet_input_date":"2024-05-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-14 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:21.000000Z","updated_at":"2025-03-17T20:16:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9242125,"change_date":"2024-05-14 21:41:00","inspection_id":"81598145","insp_unit_id":"200871296","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"Y","insp_unit_decal_number":"34087560","created_at":"2025-03-17T23:19:01.000000Z","updated_at":"2025-03-17T23:19:01.000000Z"}]},{"id":5548825,"change_date":"2024-04-19 21:38:00","inspection_id":"81392302","dot_number":"3209572","report_state":"HI","report_number":"BP16003013","insp_date":"2024-04-18 00:00:00","insp_start_time":"0831","insp_end_time":"0900","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"410904","transaction_code":"A","transaction_date":"2024-04-19 00:00:00","upload_date":"2024-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-04-19 21:38:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-19 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:45.000000Z","updated_at":"2025-03-17T20:12:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8938006,"change_date":"2024-04-19 21:38:00","inspection_id":"81392302","insp_unit_id":"200476384","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"Y","insp_unit_decal_number":"34087463","created_at":"2025-03-17T23:16:10.000000Z","updated_at":"2025-03-17T23:16:10.000000Z"}]},{"id":5561083,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","dot_number":"3209572","report_state":"HI","report_number":"CU42000376","insp_date":"2024-04-18 00:00:00","insp_start_time":"1015","insp_end_time":"1122","registration_date":"2025-04-30 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","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":"417369","transaction_code":"C","transaction_date":"2024-04-22 00:00:00","upload_date":"2025-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-04-22 21:40:00","snet_input_date":"2024-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-22 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:05.000000Z","updated_at":"2025-10-05T10:00:06.000000Z","inspection_violations":[{"id":16163632,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","insp_violation_id":"269025681","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"209236128","insp_violation_category_id":"26","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":"39378AWS"},{"id":16163633,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","insp_violation_id":"269025682","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"209236128","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-10-04T10:17:33.000000Z","updated_at":"2025-10-05T10:15:09.000000Z","normalized_code":"3939ALTSI"},{"id":16163634,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","insp_violation_id":"269025683","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209236128","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":"3939ALCL"},{"id":16163635,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","insp_violation_id":"269025684","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209236128","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"}],"inspection_per_units":[{"id":16281595,"change_date":"2025-10-01 21:39:00","inspection_id":"81405619","insp_unit_id":"209236128","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","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":5475858,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","dot_number":"3209572","report_state":"HI","report_number":"CK46001960","insp_date":"2024-04-09 00:00:00","insp_start_time":"0827","insp_end_time":"0927","registration_date":"2024-04-11 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"387482","transaction_code":"C","transaction_date":"2024-04-10 00:00:00","upload_date":"2025-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-04-10 21:41:00","snet_input_date":"2024-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-10 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:12.000000Z","updated_at":"2025-10-08T10:00:05.000000Z","inspection_violations":[{"id":16208920,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","insp_violation_id":"269078751","seq_no":"4","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209283006","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:07.000000Z","normalized_code":"39395A4EEUS"},{"id":16208921,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","insp_violation_id":"269078752","seq_no":"1","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"209283006","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:07.000000Z","normalized_code":"39383H"},{"id":16208922,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","insp_violation_id":"269078753","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209283006","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:07.000000Z","normalized_code":"3939ALIL"},{"id":16208923,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","insp_violation_id":"269078754","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"209283006","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-24-023147","created_at":"2025-10-05T10:17:54.000000Z","updated_at":"2025-10-08T10:15:07.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":16324172,"change_date":"2025-10-03 21:39:00","inspection_id":"81312556","insp_unit_id":"209283006","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:47:06.000000Z","updated_at":"2025-10-08T09:45:06.000000Z"}]},{"id":5420157,"change_date":"2024-04-03 21:40:00","inspection_id":"81251700","dot_number":"3209572","report_state":"HI","report_number":"BY39002427","insp_date":"2024-04-01 00:00:00","insp_start_time":"0844","insp_end_time":"0916","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"365775","transaction_code":"A","transaction_date":"2024-04-03 00:00:00","upload_date":"2024-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-04-03 21:40:00","snet_input_date":"2024-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-03 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:14.000000Z","updated_at":"2025-03-17T20:10:14.000000Z","inspection_violations":[{"id":8368354,"change_date":"2024-04-03 21:40:00","inspection_id":"81251700","insp_violation_id":"258713789","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200204570","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"3922"},{"id":8368355,"change_date":"2024-04-03 21:40:00","inspection_id":"81251700","insp_violation_id":"258713790","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200204570","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:30.000000Z","updated_at":"2025-03-17T21:46:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8730250,"change_date":"2024-04-03 21:40:00","inspection_id":"81251700","insp_unit_id":"200204570","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"Y","insp_unit_decal_number":"34087485","created_at":"2025-03-17T23:14:13.000000Z","updated_at":"2025-03-17T23:14:13.000000Z"}]},{"id":5335876,"change_date":"2024-03-21 21:40:00","inspection_id":"81159827","dot_number":"3209572","report_state":"HI","report_number":"CQ41000265","insp_date":"2024-03-20 00:00:00","insp_start_time":"0900","insp_end_time":"0931","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"336082","transaction_code":"A","transaction_date":"2024-03-21 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-03-21 21:40:00","snet_input_date":"2024-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-21 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:19.000000Z","updated_at":"2025-03-17T20:08:19.000000Z","inspection_violations":[{"id":8233909,"change_date":"2024-03-21 21:40:00","inspection_id":"81159827","insp_violation_id":"258507158","seq_no":"1","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTI-24-023138","created_at":"2025-03-17T21:45:48.000000Z","updated_at":"2025-03-17T21:45:48.000000Z","normalized_code":"39141AMCPVI"}],"inspection_per_units":[{"id":8593277,"change_date":"2024-03-21 21:40:00","inspection_id":"81159827","insp_unit_id":"200019393","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:56.000000Z","updated_at":"2025-03-17T23:12:56.000000Z"}]},{"id":5239057,"change_date":"2024-03-08 21:38:00","inspection_id":"81054215","dot_number":"3209572","report_state":"HI","report_number":"BY39002410","insp_date":"2024-03-06 00:00:00","insp_start_time":"0914","insp_end_time":"0919","registration_date":null,"region":"HS","ci_status_code":"C","location":"22","location_desc":"WAIMANALO HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"301999","transaction_code":"A","transaction_date":"2024-03-08 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-03-08 21:38:00","snet_input_date":"2024-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:16.000000Z","updated_at":"2025-03-17T20:06:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8436206,"change_date":"2024-03-08 21:38:00","inspection_id":"81054215","insp_unit_id":"199813876","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"}]},{"id":5173971,"change_date":"2025-12-05 21:42:00","inspection_id":"80982891","dot_number":"3209572","report_state":"HI","report_number":"BP16002948","insp_date":"2024-02-26 00:00:00","insp_start_time":"0938","insp_end_time":"0955","registration_date":"2024-02-27 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-29 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"10050","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":"273263","transaction_code":"C","transaction_date":"2024-02-27 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-02-29 21:47:00","snet_input_date":"2024-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-29 21:47:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:59.000000Z","updated_at":"2025-12-09T10:30:12.000000Z","inspection_violations":[{"id":17335978,"change_date":"2025-12-05 21:42:00","inspection_id":"80982891","insp_violation_id":"270482780","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"210434137","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:20.000000Z","normalized_code":"39395A4EEUS"},{"id":17335979,"change_date":"2025-12-05 21:42:00","inspection_id":"80982891","insp_violation_id":"270482781","seq_no":"2","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"210434137","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:20.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":17307158,"change_date":"2025-12-05 21:42:00","inspection_id":"80982891","insp_unit_id":"210434137","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"Y","insp_unit_decal_number":"33787788","created_at":"2025-12-08T10:01:48.000000Z","updated_at":"2025-12-09T10:00:16.000000Z"}]},{"id":5069554,"change_date":"2025-12-05 21:42:00","inspection_id":"80869411","dot_number":"3209572","report_state":"HI","report_number":"CU42000302","insp_date":"2024-02-15 00:00:00","insp_start_time":"0902","insp_end_time":"0954","registration_date":"2024-02-16 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"249595","transaction_code":"C","transaction_date":"2024-02-16 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-02-16 21:41:00","snet_input_date":"2024-02-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-16 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:05.000000Z","updated_at":"2025-12-09T10:30:12.000000Z","inspection_violations":[{"id":17335959,"change_date":"2025-12-05 21:42:00","inspection_id":"80869411","insp_violation_id":"270482965","seq_no":"1","part_no":"393","part_no_section":"83H","insp_viol_unit":"1","insp_unit_id":"210434221","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:20.000000Z","normalized_code":"39383H"}],"inspection_per_units":[{"id":17307150,"change_date":"2025-12-05 21:42:00","inspection_id":"80869411","insp_unit_id":"210434221","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:48.000000Z","updated_at":"2025-12-09T10:00:16.000000Z"}]},{"id":4914275,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","dot_number":"3209572","report_state":"HI","report_number":"CS27000623","insp_date":"2024-01-25 00:00:00","insp_start_time":"0823","insp_end_time":"0946","registration_date":"2024-01-27 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-28 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"14499","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"199696","transaction_code":"C","transaction_date":"2024-01-28 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-01-28 21:31:00","snet_input_date":"2024-01-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-28 21:31:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:04.000000Z","updated_at":"2025-12-09T10:30:12.000000Z","inspection_violations":[{"id":17335906,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_violation_id":"270486390","seq_no":"1","part_no":"393","part_no_section":"75A2-TFBB-6","insp_viol_unit":"1","insp_unit_id":"210436194","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:19.000000Z","normalized_code":"39375A2TFBB6"},{"id":17335907,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_violation_id":"270486391","seq_no":"2","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"210436194","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:19.000000Z","normalized_code":"393209ESPSLA"},{"id":17335908,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_violation_id":"270486392","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"210436194","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023015","created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:19.000000Z","normalized_code":"39375A3TAOL"},{"id":17335909,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_violation_id":"270486393","seq_no":"4","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"210436194","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023015","created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:19.000000Z","normalized_code":"393207ASTBW"},{"id":17335910,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_violation_id":"270486394","seq_no":"5","part_no":"393","part_no_section":"83A","insp_viol_unit":"1","insp_unit_id":"210436194","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023015","created_at":"2025-12-08T10:32:28.000000Z","updated_at":"2025-12-09T10:30:19.000000Z","normalized_code":"39383A"}],"inspection_per_units":[{"id":17307131,"change_date":"2025-12-05 21:42:00","inspection_id":"80699426","insp_unit_id":"210436194","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:48.000000Z","updated_at":"2025-12-09T10:00:16.000000Z"}]},{"id":4915236,"change_date":"2025-10-09 21:40:00","inspection_id":"80700464","dot_number":"3209572","report_state":"HI","report_number":"CQ41000205","insp_date":"2024-01-23 00:00:00","insp_start_time":"1329","insp_end_time":"1400","registration_date":"2024-01-28 00:00:00","region":"HS","ci_status_code":"C","location":null,"location_desc":"HALEIWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"199728","transaction_code":"C","transaction_date":"2024-01-28 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-01-29 21:38:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-29 21:38:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:04.000000Z","updated_at":"2025-10-13T10:00:07.000000Z","inspection_violations":[{"id":16314688,"change_date":"2025-10-09 21:40:00","inspection_id":"80700464","insp_violation_id":"269203540","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209384135","insp_violation_category_id":"30","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":"3965BL"}],"inspection_per_units":[{"id":16413940,"change_date":"2025-10-09 21:40:00","inspection_id":"80700464","insp_unit_id":"209384135","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"Y","insp_unit_decal_number":"33787751","created_at":"2025-10-12T09:47:04.000000Z","updated_at":"2025-10-13T09:45:07.000000Z"}]},{"id":4847191,"change_date":"2024-01-17 21:44:00","inspection_id":"80626077","dot_number":"3209572","report_state":"HI","report_number":"CB44001567","insp_date":"2024-01-16 00:00:00","insp_start_time":"1045","insp_end_time":"1059","registration_date":null,"region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"181111","transaction_code":"A","transaction_date":"2024-01-17 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2024-01-17 21:44:00","snet_input_date":"2024-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:49.000000Z","updated_at":"2025-03-17T19:58:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7798858,"change_date":"2024-01-17 21:44:00","inspection_id":"80626077","insp_unit_id":"198990164","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:42.000000Z","updated_at":"2025-03-17T23:05:42.000000Z"}]},{"id":4575582,"change_date":"2023-12-07 21:40:00","inspection_id":"80328974","dot_number":"3209572","report_state":"HI","report_number":"CP19000757","insp_date":"2023-12-06 00:00:00","insp_start_time":"1055","insp_end_time":"1125","registration_date":null,"region":"HS","ci_status_code":"C","location":"10","location_desc":"WAHIAWA 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":"2023-12-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10047","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":"121458","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-12-07 21:40:00","snet_input_date":"2023-12-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-07 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:26.000000Z","updated_at":"2025-03-17T19:53:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7359214,"change_date":"2023-12-07 21:40:00","inspection_id":"80328974","insp_unit_id":"198388121","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:50.000000Z","updated_at":"2025-03-17T23:01:50.000000Z"}]},{"id":4488302,"change_date":"2025-10-09 21:40:00","inspection_id":"80232999","dot_number":"3209572","report_state":"HI","report_number":"CP19000002","insp_date":"2023-11-22 00:00:00","insp_start_time":"0841","insp_end_time":"0940","registration_date":"2023-11-29 00:00:00","region":"HS","ci_status_code":"C","location":"35","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10050","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"107638","transaction_code":"C","transaction_date":"2023-11-27 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-11-27 21:40:00","snet_input_date":"2023-11-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-27 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:48.000000Z","updated_at":"2025-10-13T10:00:07.000000Z","inspection_violations":[{"id":16314515,"change_date":"2025-10-09 21:40:00","inspection_id":"80232999","insp_violation_id":"269203301","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209383979","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:06.000000Z","normalized_code":"39021TB2DOT"},{"id":16314516,"change_date":"2025-10-09 21:40:00","inspection_id":"80232999","insp_violation_id":"269203302","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"209383979","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-23-027691","created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:06.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":16413861,"change_date":"2025-10-09 21:40:00","inspection_id":"80232999","insp_unit_id":"209383979","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"TGS110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDWE3FS7HDC52673","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":4410253,"change_date":"2023-11-13 21:42:00","inspection_id":"80147327","dot_number":"3209572","report_state":"HI","report_number":"CT31000571","insp_date":"2023-11-06 00:00:00","insp_start_time":"0908","insp_end_time":"0917","registration_date":null,"region":"HT","ci_status_code":"C","location":"22","location_desc":"WAIMANALO","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"135417","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-13 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:18.000000Z","updated_at":"2025-03-17T19:50:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7092894,"change_date":"2023-11-13 21:42:00","inspection_id":"80147327","insp_unit_id":"198027639","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"}]},{"id":4410289,"change_date":"2023-11-13 21:42:00","inspection_id":"80147366","dot_number":"3209572","report_state":"HI","report_number":"CP19000748","insp_date":"2023-11-06 00:00:00","insp_start_time":"1150","insp_end_time":"1200","registration_date":null,"region":"HT","ci_status_code":"C","location":"25","location_desc":"WAIKANE","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"135438","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-11-13 21:42:00","snet_input_date":"2023-11-13 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-11-13 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:18.000000Z","updated_at":"2025-03-17T19:50:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7092937,"change_date":"2023-11-13 21:42:00","inspection_id":"80147366","insp_unit_id":"198027700","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"119","insp_unit_license":"SBT380","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5DDB21810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:33.000000Z","updated_at":"2025-03-17T22:59:33.000000Z"}]},{"id":4343092,"change_date":"2023-11-02 21:42:00","inspection_id":"80072785","dot_number":"3209572","report_state":"HI","report_number":"CK46001875","insp_date":"2023-10-31 00:00:00","insp_start_time":"0810","insp_end_time":"0844","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-11-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"135358","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-11-02 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-11-02 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:05.000000Z","updated_at":"2025-03-17T19:49:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6985014,"change_date":"2023-11-02 21:42:00","inspection_id":"80072785","insp_unit_id":"197882318","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:39.000000Z","updated_at":"2025-03-17T22:58:39.000000Z"}]},{"id":4206608,"change_date":"2023-10-30 21:43:00","inspection_id":"79922018","dot_number":"3209572","report_state":"HI","report_number":"00CK001849","insp_date":"2023-10-12 00:00:00","insp_start_time":"0922","insp_end_time":"0939","registration_date":"2023-10-23 00:00:00","region":"HT","ci_status_code":"C","location":"22","location_desc":"WAIMANALO","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"135146","transaction_code":"C","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-10-16 21:43:00","snet_input_date":"2023-10-16 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:14.000000Z","updated_at":"2025-03-17T19:46:14.000000Z","inspection_violations":[{"id":6513895,"change_date":"2023-10-30 21:43:00","inspection_id":"79922018","insp_violation_id":"256120365","seq_no":"1","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"1DTC-23-027108","created_at":"2025-03-17T21:37:23.000000Z","updated_at":"2025-03-17T21:37:23.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":6764989,"change_date":"2023-10-30 21:43:00","inspection_id":"79922018","insp_unit_id":"197817845","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"119","insp_unit_license":"SBT380","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5DDB21810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"}]},{"id":4165123,"change_date":"2023-10-10 21:42:00","inspection_id":"79876173","dot_number":"3209572","report_state":"HI","report_number":"CQ41000130","insp_date":"2023-10-06 00:00:00","insp_start_time":"0914","insp_end_time":"0936","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"135107","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-10-10 21:42:00","snet_input_date":"2023-10-10 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-10 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:27.000000Z","updated_at":"2025-03-17T19:45:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6697602,"change_date":"2023-10-10 21:42:00","inspection_id":"79876173","insp_unit_id":"197482545","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:09.000000Z","updated_at":"2025-03-17T22:56:09.000000Z"}]},{"id":4146415,"change_date":"2023-10-30 21:43:00","inspection_id":"79855570","dot_number":"3209572","report_state":"HI","report_number":"CT31000529","insp_date":"2023-10-04 00:00:00","insp_start_time":"0901","insp_end_time":"0948","registration_date":"2023-10-04 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"135067","transaction_code":"C","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:55.000000Z","updated_at":"2025-03-17T19:44:55.000000Z","inspection_violations":[{"id":6417518,"change_date":"2023-10-30 21:43:00","inspection_id":"79855570","insp_violation_id":"256120283","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197817786","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"3963A1"},{"id":6417519,"change_date":"2023-10-30 21:43:00","inspection_id":"79855570","insp_violation_id":"256120284","seq_no":"2","part_no":"393","part_no_section":"83(c)","insp_viol_unit":"1","insp_unit_id":"197817786","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-23-027585","created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"39383C"}],"inspection_per_units":[{"id":6667068,"change_date":"2023-10-30 21:43:00","inspection_id":"79855570","insp_unit_id":"197817786","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:55.000000Z","updated_at":"2025-03-17T22:55:55.000000Z"}]},{"id":4146430,"change_date":"2023-10-30 21:43:00","inspection_id":"79855585","dot_number":"3209572","report_state":"HI","report_number":"CP19000711","insp_date":"2023-10-04 00:00:00","insp_start_time":"1023","insp_end_time":"1053","registration_date":"2023-10-04 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"135044","transaction_code":"C","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:55.000000Z","updated_at":"2025-03-17T19:44:55.000000Z","inspection_violations":[{"id":6417533,"change_date":"2023-10-30 21:43:00","inspection_id":"79855585","insp_violation_id":"256120359","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197817841","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6667086,"change_date":"2023-10-30 21:43:00","inspection_id":"79855585","insp_unit_id":"197817841","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:55.000000Z","updated_at":"2025-03-17T22:55:55.000000Z"}]},{"id":4146435,"change_date":"2023-10-30 21:43:00","inspection_id":"79855590","dot_number":"3209572","report_state":"HI","report_number":"CT31000528","insp_date":"2023-10-04 00:00:00","insp_start_time":"0819","insp_end_time":"0857","registration_date":"2023-10-04 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"135066","transaction_code":"C","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-10-06 21:41:00","snet_input_date":"2023-10-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-06 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:55.000000Z","updated_at":"2025-03-17T19:44:55.000000Z","inspection_violations":[{"id":6417541,"change_date":"2023-10-30 21:43:00","inspection_id":"79855590","insp_violation_id":"256120282","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197817785","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:55.000000Z","updated_at":"2025-03-17T21:36:55.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6667091,"change_date":"2023-10-30 21:43:00","inspection_id":"79855590","insp_unit_id":"197817785","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:55.000000Z","updated_at":"2025-03-17T22:55:55.000000Z"}]},{"id":3984772,"change_date":"2023-09-15 21:40:00","inspection_id":"79675874","dot_number":"3209572","report_state":"HI","report_number":"00CB001517","insp_date":"2023-09-14 00:00:00","insp_start_time":"0900","insp_end_time":"0911","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134881","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-15 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6407295,"change_date":"2023-09-15 21:40:00","inspection_id":"79675874","insp_unit_id":"197082323","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3984766,"change_date":"2023-09-15 21:40:00","inspection_id":"79675868","dot_number":"3209572","report_state":"HI","report_number":"00CB001515","insp_date":"2023-09-12 00:00:00","insp_start_time":"1005","insp_end_time":"1030","registration_date":null,"region":"HT","ci_status_code":"C","location":"10","location_desc":"DOLE FRESH FRUIT STAND","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"134883","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-15 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6407289,"change_date":"2023-09-15 21:40:00","inspection_id":"79675868","insp_unit_id":"197082317","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3984781,"change_date":"2023-09-15 21:40:00","inspection_id":"79675883","dot_number":"3209572","report_state":"HI","report_number":"00CK001817","insp_date":"2023-09-12 00:00:00","insp_start_time":"0947","insp_end_time":"0957","registration_date":null,"region":"HT","ci_status_code":"C","location":"22","location_desc":"WAIMANALO","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134904","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-09-15 21:40:00","snet_input_date":"2023-09-15 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6407307,"change_date":"2023-09-15 21:40:00","inspection_id":"79675883","insp_unit_id":"197082337","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3813631,"change_date":"2023-08-23 21:40:00","inspection_id":"79485190","dot_number":"3209572","report_state":"HI","report_number":"CP19000665","insp_date":"2023-08-23 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134657","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-08-23 21:40:00","snet_input_date":"2023-08-23 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:05.000000Z","updated_at":"2025-03-17T19:38:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6131716,"change_date":"2023-08-23 21:40:00","inspection_id":"79485190","insp_unit_id":"196689669","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:31.000000Z","updated_at":"2025-03-17T22:51:31.000000Z"}]},{"id":3697362,"change_date":"2023-08-08 21:41:00","inspection_id":"79355592","dot_number":"3209572","report_state":"HI","report_number":"CS27000456","insp_date":"2023-08-07 00:00:00","insp_start_time":"0915","insp_end_time":"0924","registration_date":null,"region":"HT","ci_status_code":"C","location":"22","location_desc":"WAIMANALO","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"134510","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-08-08 21:41:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-08 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5944713,"change_date":"2023-08-08 21:41:00","inspection_id":"79355592","insp_unit_id":"196427621","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:56.000000Z","updated_at":"2025-03-17T22:49:56.000000Z"}]},{"id":3687437,"change_date":"2023-08-07 21:42:00","inspection_id":"79344594","dot_number":"3209572","report_state":"HI","report_number":"00CK001778","insp_date":"2023-08-03 00:00:00","insp_start_time":"0816","insp_end_time":"0847","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134497","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-07 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5928796,"change_date":"2023-08-07 21:42:00","inspection_id":"79344594","insp_unit_id":"196404632","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"}]},{"id":3558172,"change_date":"2023-07-24 21:42:00","inspection_id":"79199394","dot_number":"3209572","report_state":"HI","report_number":"CS27000427","insp_date":"2023-07-20 00:00:00","insp_start_time":"1100","insp_end_time":"1107","registration_date":null,"region":"HT","ci_status_code":"C","location":"25","location_desc":"WAIKANE","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134361","transaction_code":"C","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-20 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:12.000000Z","updated_at":"2025-03-17T19:33:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5721751,"change_date":"2023-07-24 21:42:00","inspection_id":"79199394","insp_unit_id":"196163140","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"}]},{"id":3085436,"change_date":"2023-05-18 21:43:00","inspection_id":"78667084","dot_number":"3209572","report_state":"US","report_number":"1827000120","insp_date":"2023-05-15 00:00:00","insp_start_time":"1526","insp_end_time":"1633","registration_date":null,"region":"HT","ci_status_code":"C","location":null,"location_desc":"DOLE PLANTATION - WAHIAWA","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"ALOHA SUNSHINE TOURS LLC","shipping_paper_number":"PRE ARR TOUR","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"382766","transaction_code":"A","transaction_date":"2023-05-15 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-16 00:00:00","source_office":"4COD001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[{"id":4742642,"change_date":"2023-05-18 21:43:00","inspection_id":"78667084","insp_violation_id":"252932208","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195019833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:07.000000Z","updated_at":"2025-03-17T21:29:07.000000Z","normalized_code":"3939A"},{"id":4742643,"change_date":"2023-05-18 21:43:00","inspection_id":"78667084","insp_violation_id":"252932209","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195019833","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:07.000000Z","updated_at":"2025-03-17T21:29:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4963374,"change_date":"2023-05-18 21:43:00","inspection_id":"78667084","insp_unit_id":"195019833","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":3034883,"change_date":"2023-05-12 21:42:00","inspection_id":"78610275","dot_number":"3209572","report_state":"HI","report_number":"CP19000591","insp_date":"2023-05-11 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","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":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133931","transaction_code":"A","transaction_date":"2023-05-11 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-05-12 21:42:00","snet_input_date":"2023-05-12 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-05-12 21:42:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:02.000000Z","updated_at":"2025-03-17T19:23:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4882473,"change_date":"2023-05-12 21:42:00","inspection_id":"78610275","insp_unit_id":"194908037","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:29.000000Z","updated_at":"2025-03-17T22:41:29.000000Z"}]},{"id":2939163,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","dot_number":"3209572","report_state":"US","report_number":"1821000014","insp_date":"2023-05-01 00:00:00","insp_start_time":"1618","insp_end_time":"1704","registration_date":null,"region":"HS","ci_status_code":"C","location":null,"location_desc":"WAHIAWAHI","county_code_state":"HI","county_code":"001","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":"2023-05-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"11419","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-05-02 21:40:00","snet_input_date":"2023-05-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-05-02 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:58.000000Z","updated_at":"2025-03-17T19:20:58.000000Z","inspection_violations":[{"id":4513342,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","insp_violation_id":"252558692","seq_no":"1","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"194691479","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"39362BENM"},{"id":4513343,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","insp_violation_id":"252558693","seq_no":"2","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"194691479","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"39362BENM"},{"id":4513344,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","insp_violation_id":"252558694","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"194691479","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"3939ALRLI"},{"id":4513345,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","insp_violation_id":"252558695","seq_no":"4","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"194691479","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:01.000000Z","updated_at":"2025-03-17T21:28:01.000000Z","normalized_code":"3939ALSLI"}],"inspection_per_units":[{"id":4729077,"change_date":"2023-05-02 21:40:00","inspection_id":"78501752","insp_unit_id":"194691479","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:17.000000Z","updated_at":"2025-03-17T22:40:17.000000Z"}]},{"id":2447406,"change_date":"2023-02-24 21:40:00","inspection_id":"77942939","dot_number":"3209572","report_state":"HI","report_number":"00CK001666","insp_date":"2023-02-23 00:00:00","insp_start_time":"0906","insp_end_time":"0930","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133520","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-02-24 21:40:00","snet_input_date":"2023-02-24 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:46.000000Z","updated_at":"2025-03-17T19:11:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3938552,"change_date":"2023-02-24 21:40:00","inspection_id":"77942939","insp_unit_id":"193573588","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"}]},{"id":2304988,"change_date":"2023-02-06 21:41:00","inspection_id":"77780611","dot_number":"3209572","report_state":"HI","report_number":"00CK001641","insp_date":"2023-02-03 00:00:00","insp_start_time":"0930","insp_end_time":"0938","registration_date":null,"region":"HT","ci_status_code":"C","location":"22","location_desc":"WAIMANALO","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133382","transaction_code":"A","transaction_date":"2023-02-03 00:00:00","upload_date":"2023-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2023-02-06 21:41:00","snet_input_date":"2023-02-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-02-06 21:41:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:13.000000Z","updated_at":"2025-03-17T19:09:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3710420,"change_date":"2023-02-06 21:41:00","inspection_id":"77780611","insp_unit_id":"193247133","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"124","insp_unit_license":"SFY711","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS6EDB10185","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:35.000000Z","updated_at":"2025-03-17T22:32:35.000000Z"}]},{"id":1956227,"change_date":"2023-01-06 21:39:00","inspection_id":"77382204","dot_number":"3209572","report_state":"HI","report_number":"CT31000278","insp_date":"2022-12-13 00:00:00","insp_start_time":"0930","insp_end_time":"1015","registration_date":"2022-12-23 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"133032","transaction_code":"C","transaction_date":"2022-12-13 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-12-15 21:39:00","snet_input_date":"2022-12-15 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-12-15 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:36.000000Z","updated_at":"2025-03-17T19:02:36.000000Z","inspection_violations":[{"id":3037448,"change_date":"2023-01-06 21:39:00","inspection_id":"77382204","insp_violation_id":"250430943","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192740906","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:26.000000Z","updated_at":"2025-03-17T21:21:26.000000Z","normalized_code":"3963A1"},{"id":3037449,"change_date":"2023-01-06 21:39:00","inspection_id":"77382204","insp_violation_id":"250430944","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"192740906","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:26.000000Z","updated_at":"2025-03-17T21:21:26.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3147635,"change_date":"2023-01-06 21:39:00","inspection_id":"77382204","insp_unit_id":"192740906","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"121","insp_unit_license":"TRS477","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7DDB21811","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:33.000000Z","updated_at":"2025-03-17T22:28:33.000000Z"}]},{"id":1808397,"change_date":"2022-11-23 21:40:00","inspection_id":"77212983","dot_number":"3209572","report_state":"HI","report_number":"00CK001584","insp_date":"2022-11-22 00:00:00","insp_start_time":"0927","insp_end_time":"0937","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"132930","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-23 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:59.000000Z","updated_at":"2025-03-17T18:59:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2909052,"change_date":"2022-11-23 21:40:00","inspection_id":"77212983","insp_unit_id":"192113977","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]},{"id":1717367,"change_date":"2022-11-10 21:39:00","inspection_id":"77108458","dot_number":"3209572","report_state":"HI","report_number":"00BY002138","insp_date":"2022-10-28 00:00:00","insp_start_time":"0919","insp_end_time":"0926","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","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":"132838","transaction_code":"A","transaction_date":"2022-10-28 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-11-10 21:39:00","snet_input_date":"2022-11-10 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-11-10 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"1039 11TH AVE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:14.000000Z","updated_at":"2025-03-17T18:58:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2762932,"change_date":"2022-11-10 21:39:00","inspection_id":"77108458","insp_unit_id":"191906535","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TRANSIT","insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:54.000000Z","updated_at":"2025-03-17T22:25:54.000000Z"}]},{"id":1573416,"change_date":"2022-10-21 21:39:00","inspection_id":"76943323","dot_number":"3209572","report_state":"HI","report_number":"00CK001542","insp_date":"2022-10-20 00:00:00","insp_start_time":"0750","insp_end_time":"0820","registration_date":null,"region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"132700","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-21 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:37.000000Z","updated_at":"2025-03-17T18:55:37.000000Z","inspection_violations":[{"id":2474205,"change_date":"2022-10-21 21:39:00","inspection_id":"76943323","insp_violation_id":"249180765","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191577980","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:35.000000Z","updated_at":"2025-03-17T21:18:35.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":2532302,"change_date":"2022-10-21 21:39:00","inspection_id":"76943323","insp_unit_id":"191577980","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"119","insp_unit_license":"SBT380","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5DDB21810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:21.000000Z","updated_at":"2025-03-17T22:24:21.000000Z"}]},{"id":1459672,"change_date":"2022-10-21 21:39:00","inspection_id":"76812021","dot_number":"3209572","report_state":"HI","report_number":"CP19000464","insp_date":"2022-10-04 00:00:00","insp_start_time":"0842","insp_end_time":"0937","registration_date":"2022-10-18 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","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":"132566","transaction_code":"C","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:29.000000Z","updated_at":"2025-03-17T18:53:29.000000Z","inspection_violations":[{"id":2298485,"change_date":"2022-10-21 21:39:00","inspection_id":"76812021","insp_violation_id":"249180768","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191577982","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3922"},{"id":2298486,"change_date":"2022-10-21 21:39:00","inspection_id":"76812021","insp_violation_id":"249180769","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191577982","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3939A"},{"id":2298487,"change_date":"2022-10-21 21:39:00","inspection_id":"76812021","insp_violation_id":"249180770","seq_no":"3","part_no":"393","part_no_section":"83(c)","insp_viol_unit":"1","insp_unit_id":"191577982","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-22-051837","created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39383C"}],"inspection_per_units":[{"id":2349922,"change_date":"2022-10-21 21:39:00","inspection_id":"76812021","insp_unit_id":"191577982","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"116","insp_unit_license":"RZU143","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDXE4FS8DDA87821","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:05.000000Z","updated_at":"2025-03-17T22:23:05.000000Z"}]},{"id":915150,"change_date":"2022-08-09 21:41:00","inspection_id":"76178581","dot_number":"3209572","report_state":"HI","report_number":"OOAF004305","insp_date":"2022-07-26 00:00:00","insp_start_time":"1010","insp_end_time":"1036","registration_date":"2022-07-27 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132142","transaction_code":"C","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-07-28 21:40:00","snet_input_date":"2022-07-28 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:44.000000Z","updated_at":"2025-03-17T18:43:44.000000Z","inspection_violations":[{"id":1442758,"change_date":"2022-08-09 21:41:00","inspection_id":"76178581","insp_violation_id":"247606131","seq_no":"1","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"190215440","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"39330"},{"id":1442759,"change_date":"2022-08-09 21:41:00","inspection_id":"76178581","insp_violation_id":"247606132","seq_no":"2","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"190215440","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-22-051642","created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"39328"}],"inspection_per_units":[{"id":1473149,"change_date":"2022-08-09 21:41:00","inspection_id":"76178581","insp_unit_id":"190215440","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"120","insp_unit_license":"SBT381","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS3DDB21806","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:15.000000Z","updated_at":"2025-03-17T22:17:15.000000Z"}]},{"id":810039,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","dot_number":"3209572","report_state":"HI","report_number":"00CB001285","insp_date":"2022-07-11 00:00:00","insp_start_time":"0900","insp_end_time":"0955","registration_date":"2022-07-27 00:00:00","region":"HT","ci_status_code":"C","location":"35","location_desc":"PEARL HARBOR","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"10360","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132066","transaction_code":"C","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03209572","upload_search_indicator":null,"census_search_date":"2022-07-13 21:40:00","snet_input_date":"2022-07-13 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-07-13 21:40:00","insp_carrier_name":"ALOHA SUNSHINE TOURS LLC","insp_carrier_street":"PO BOX 283217","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96816","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:57.000000Z","updated_at":"2025-03-17T18:41:57.000000Z","inspection_violations":[{"id":1277072,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","insp_violation_id":"247437354","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190067311","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3922"},{"id":1277073,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","insp_violation_id":"247437355","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190067311","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"39375C"},{"id":1277074,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","insp_violation_id":"247437356","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190067311","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"3963A1"},{"id":1277075,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","insp_violation_id":"247437357","seq_no":"4","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"190067311","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:59.000000Z","updated_at":"2025-03-17T21:12:59.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":1303626,"change_date":"2022-08-01 21:39:00","inspection_id":"76055186","insp_unit_id":"190067311","insp_unit_type_id":"12","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SSG923","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FBVU4XG6FKB22030","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/3209572\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/3209572\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/3209572\/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\/3209572\/inspections","per_page":100,"prev_page_url":null,"to":75,"total":75}