{"current_page":1,"data":[{"id":11708481,"change_date":"2026-04-21 21:38:00","inspection_id":"87635315","dot_number":"4029150","report_state":"HI","report_number":"CP19001393","insp_date":"2026-04-20 00:00:00","insp_start_time":"0933","insp_end_time":"0943","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-04-21 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":"3190523","transaction_code":"A","transaction_date":"2026-04-21 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2026-04-21 21:38:00","snet_input_date":"2026-04-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-21 21:38:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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-27T09:37:42.000000Z","updated_at":"2026-05-02T09:30:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20375306,"change_date":"2026-04-21 21:38:00","inspection_id":"87635315","insp_unit_id":"213136071","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"4","insp_unit_license":"YBF149","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FD4E45S88DB59255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:13:59.000000Z","updated_at":"2026-05-02T09:03:05.000000Z"}]},{"id":11248858,"change_date":"2026-02-27 21:41:00","inspection_id":"87161987","dot_number":"4029150","report_state":"HI","report_number":"CU42000858","insp_date":"2026-02-26 00:00:00","insp_start_time":"1054","insp_end_time":"1100","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":"2026-02-27 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":"2943279","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2026-02-27 21:41:00","snet_input_date":"2026-02-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-27 21:41:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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-02T10:39:34.000000Z","updated_at":"2026-03-10T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19230404,"change_date":"2026-02-27 21:41:00","inspection_id":"87161987","insp_unit_id":"211877364","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"4","insp_unit_license":"YBF149","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FD4E45S88DB59255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:23.000000Z","updated_at":"2026-03-10T09:05:35.000000Z"}]},{"id":10857169,"change_date":"2026-01-25 21:33:00","inspection_id":"86886558","dot_number":"4029150","report_state":"HI","report_number":"CV21000221","insp_date":"2026-01-16 00:00:00","insp_start_time":"0952","insp_end_time":"1008","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-25 21:33: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":"2812458","transaction_code":"A","transaction_date":"2026-01-24 00:00:00","upload_date":"2026-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2026-01-25 21:33:00","snet_input_date":"2026-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-25 21:33:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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-28T10:36:23.000000Z","updated_at":"2026-02-05T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18242225,"change_date":"2026-01-25 21:33:00","inspection_id":"86886558","insp_unit_id":"211281664","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-28T10:08:23.000000Z","updated_at":"2026-02-05T10:02:16.000000Z"}]},{"id":9947843,"change_date":"2025-10-15 21:39:00","inspection_id":"86055294","dot_number":"4029150","report_state":"HI","report_number":"CK46002405","insp_date":"2025-10-14 00:00:00","insp_start_time":"0958","insp_end_time":"1008","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":"2416269","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":"04029150","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":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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":16514652,"change_date":"2025-10-15 21:39:00","inspection_id":"86055294","insp_unit_id":"209481104","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:45:53.000000Z"}]},{"id":9351944,"change_date":"2025-08-07 21:39:00","inspection_id":"85429071","dot_number":"4029150","report_state":"HI","report_number":"CK46002364","insp_date":"2025-08-06 00:00:00","insp_start_time":"0949","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":"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":"2098863","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":"04029150","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":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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":15405799,"change_date":"2025-08-07 21:39:00","inspection_id":"85429071","insp_unit_id":"208281288","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-1","insp_unit_license":"SRV033","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS9FDA30459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:19.000000Z","updated_at":"2025-08-11T09:45:42.000000Z"}]},{"id":9332422,"change_date":"2025-08-05 21:38:00","inspection_id":"85408408","dot_number":"4029150","report_state":"US","report_number":"1827000122","insp_date":"2025-07-22 00:00:00","insp_start_time":"1526","insp_end_time":"1601","registration_date":null,"region":"HS","ci_status_code":"C","location":null,"location_desc":"WAHIAWA HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RAINBOW TOUR TRANSPORTATION, INC","shipping_paper_number":"PRE-ARRANGED CH","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-05 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":"2088676","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2025-08-05 21:38:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-05 21:38:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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-08T10:01:17.000000Z","updated_at":"2025-08-12T10:41:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15369971,"change_date":"2025-08-05 21:38:00","inspection_id":"85408408","insp_unit_id":"208242857","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-1","insp_unit_license":"SRV033","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS9FDA30459","insp_unit_decal":"Y","insp_unit_decal_number":"35478261","created_at":"2025-08-08T09:46:31.000000Z","updated_at":"2025-08-09T09:45:37.000000Z"}]},{"id":8603361,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","dot_number":"4029150","report_state":"US","report_number":"1827000104","insp_date":"2025-05-06 00:00:00","insp_start_time":"1559","insp_end_time":"1635","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":"RAINBOW TOUR TRANSPORTATION, INC","shipping_paper_number":"PRE-ARRANGED CH","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-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1717202","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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-15T10:01:06.000000Z","updated_at":"2025-05-17T10:04:43.000000Z","inspection_violations":[{"id":13671611,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_violation_id":"266158536","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206803004","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:19:28.000000Z","updated_at":"2025-05-16T10:24:27.000000Z","normalized_code":"3922SLLIRP"},{"id":13671612,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_violation_id":"266158537","seq_no":"2","part_no":"393","part_no_section":"62-BEND","insp_viol_unit":"1","insp_unit_id":"206803004","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:19:28.000000Z","updated_at":"2025-05-16T10:24:27.000000Z","normalized_code":"39362BEND"},{"id":13671613,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_violation_id":"266158538","seq_no":"3","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"206803004","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:19:28.000000Z","updated_at":"2025-05-16T10:24:27.000000Z","normalized_code":"39362BENM"},{"id":13671614,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_violation_id":"266158539","seq_no":"4","part_no":"393","part_no_section":"62-BEO","insp_viol_unit":"1","insp_unit_id":"206803004","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-15T10:19:28.000000Z","updated_at":"2025-05-16T10:24:27.000000Z","normalized_code":"39362BEO"},{"id":13671615,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_violation_id":"266158540","seq_no":"5","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":null,"created_at":"2025-05-15T10:19:28.000000Z","updated_at":"2025-05-16T10:24:27.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":14044981,"change_date":"2025-05-12 21:40:00","inspection_id":"84639139","insp_unit_id":"206803004","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:12.000000Z","updated_at":"2025-05-16T09:49:58.000000Z"}]},{"id":7572289,"change_date":"2025-01-08 21:39:00","inspection_id":"83554714","dot_number":"4029150","report_state":"HI","report_number":"CS27000882","insp_date":"2025-01-07 00:00:00","insp_start_time":"0934","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":"2025-01-08 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":"1226729","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":"04029150","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":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU AVENUE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","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":[{"id":11837861,"change_date":"2025-01-08 21:39:00","inspection_id":"83554714","insp_violation_id":"263812520","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"204703122","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:39.000000Z","updated_at":"2025-03-17T22:03:39.000000Z","normalized_code":"3929BAINACTIVEINTRA"},{"id":11837862,"change_date":"2025-01-08 21:39:00","inspection_id":"83554714","insp_violation_id":"263812521","seq_no":"2","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"204703122","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-25-054124","created_at":"2025-03-17T22:03:39.000000Z","updated_at":"2025-03-17T22:03:39.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":12217869,"change_date":"2025-01-08 21:39:00","inspection_id":"83554714","insp_unit_id":"204703122","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","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":6183539,"change_date":"2024-07-10 21:40:00","inspection_id":"82079988","dot_number":"4029150","report_state":"HI","report_number":"CK46002023","insp_date":"2024-07-09 00:00:00","insp_start_time":"1006","insp_end_time":"1027","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":"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":"641364","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":"04029150","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":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU AVENUE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","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":[{"id":9602084,"change_date":"2024-07-10 21:40:00","inspection_id":"82079988","insp_violation_id":"260558771","seq_no":"1","part_no":"392","part_no_section":"9b(a)","insp_viol_unit":"1","insp_unit_id":"201812207","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:29.000000Z","updated_at":"2025-03-17T21:52:29.000000Z","normalized_code":"3929BA"}],"inspection_per_units":[{"id":9961500,"change_date":"2024-07-10 21:40:00","inspection_id":"82079988","insp_unit_id":"201812207","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","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":6044136,"change_date":"2024-06-21 21:38:00","inspection_id":"81930067","dot_number":"4029150","report_state":"HI","report_number":"BP16003084","insp_date":"2024-06-20 00:00:00","insp_start_time":"0950","insp_end_time":"0959","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":"14300","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":"589523","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":"04029150","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":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU AVENUE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","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":[{"id":9375636,"change_date":"2024-06-21 21:38:00","inspection_id":"81930067","insp_violation_id":"260226800","seq_no":"1","part_no":"392","part_no_section":"9b(a)","insp_viol_unit":"1","insp_unit_id":"201520523","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:20.000000Z","updated_at":"2025-03-17T21:51:20.000000Z","normalized_code":"3929BA"}],"inspection_per_units":[{"id":9734770,"change_date":"2024-06-21 21:38:00","inspection_id":"81930067","insp_unit_id":"201520523","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-3","insp_unit_license":"SPG379","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5FDA23055","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":5240167,"change_date":"2024-03-08 21:39:00","inspection_id":"81055421","dot_number":"4029150","report_state":"HI","report_number":"CK46001941","insp_date":"2024-03-06 00:00:00","insp_start_time":"0935","insp_end_time":"0949","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:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14300","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":"302008","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":"04029150","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU AVENUE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8438003,"change_date":"2024-03-08 21:39:00","inspection_id":"81055421","insp_unit_id":"199815916","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"C-3","insp_unit_license":"SPG379","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5FDA23055","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":5240168,"change_date":"2024-03-08 21:39:00","inspection_id":"81055422","dot_number":"4029150","report_state":"HI","report_number":"CK46001942","insp_date":"2024-03-06 00:00:00","insp_start_time":"0954","insp_end_time":"1010","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: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":"302009","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":"04029150","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU AVENUE","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8438004,"change_date":"2024-03-08 21:39:00","inspection_id":"81055422","insp_unit_id":"199815917","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-2","insp_unit_license":"SRV032","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS7FDA30458","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":4237664,"change_date":"2023-10-19 21:41:00","inspection_id":"79956127","dot_number":"4029150","report_state":"HI","report_number":"CP19000733","insp_date":"2023-10-19 00:00:00","insp_start_time":"1031","insp_end_time":"1041","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-10-19 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":"135235","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2023-10-19 21:41:00","snet_input_date":"2023-10-19 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-19 21:41:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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:40.000000Z","updated_at":"2025-03-17T19:46:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6815259,"change_date":"2023-10-19 21:41:00","inspection_id":"79956127","insp_unit_id":"197646384","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-1","insp_unit_license":"SRV033","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS9FDA30459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:08.000000Z","updated_at":"2025-03-17T22:57:08.000000Z"}]},{"id":4273679,"change_date":"2023-10-24 21:40:00","inspection_id":"79996163","dot_number":"4029150","report_state":"HI","report_number":"CT31000557","insp_date":"2023-10-19 00:00:00","insp_start_time":"1129","insp_end_time":"1138","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-10-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14300","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":"135261","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-24 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6873372,"change_date":"2023-10-24 21:40:00","inspection_id":"79996163","insp_unit_id":"197723656","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-3","insp_unit_license":"SPG379","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS5FDA23055","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:37.000000Z","updated_at":"2025-03-17T22:57:37.000000Z"}]},{"id":2977204,"change_date":"2023-05-05 21:42:00","inspection_id":"78545032","dot_number":"4029150","report_state":"US","report_number":"1821002451","insp_date":"2023-05-01 00:00:00","insp_start_time":"1238","insp_end_time":"1349","registration_date":null,"region":"HT","ci_status_code":"C","location":null,"location_desc":"DOLE PLANTATION","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"RAINBOW TRANSPORTATION INC","shipping_paper_number":"PRE ARR TOUR US","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-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"382715","transaction_code":"A","transaction_date":"2023-05-01 00:00:00","upload_date":"2023-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2023-05-05 21:42:00","snet_input_date":"2023-05-05 00:00:00","source_office":"4COD001","mcmis_add_date":"2023-05-05 21:42:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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:21:54.000000Z","updated_at":"2025-03-17T19:21:54.000000Z","inspection_violations":[{"id":4570090,"change_date":"2023-05-05 21:42:00","inspection_id":"78545032","insp_violation_id":"252654956","seq_no":"1","part_no":"383","part_no_section":"25(a)(5)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"38325A5I"},{"id":4570091,"change_date":"2023-05-05 21:42:00","inspection_id":"78545032","insp_violation_id":"252654957","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194777179","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"39378"},{"id":4570092,"change_date":"2023-05-05 21:42:00","inspection_id":"78545032","insp_violation_id":"252654958","seq_no":"3","part_no":"393","part_no_section":"62(c)","insp_viol_unit":"1","insp_unit_id":"194777179","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:28:18.000000Z","updated_at":"2025-03-17T21:28:18.000000Z","normalized_code":"39362C"}],"inspection_per_units":[{"id":4789896,"change_date":"2023-05-05 21:42:00","inspection_id":"78545032","insp_unit_id":"194777179","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"2","insp_unit_license":"TVS499","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDAF5GY8BEC26722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:44.000000Z","updated_at":"2025-03-17T22:40:44.000000Z"}]},{"id":2891803,"change_date":"2023-04-26 21:40:00","inspection_id":"78448232","dot_number":"4029150","report_state":"US","report_number":"1827000004","insp_date":"2023-04-25 00:00:00","insp_start_time":"1704","insp_end_time":"1752","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-04-26 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":"10174","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2023-04-26 21:40:00","snet_input_date":"2023-04-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-04-26 21:40:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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:05.000000Z","updated_at":"2025-03-17T19:20:05.000000Z","inspection_violations":[{"id":4438729,"change_date":"2023-04-26 21:40:00","inspection_id":"78448232","insp_violation_id":"252439622","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"194584129","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3922SLLSR"},{"id":4438730,"change_date":"2023-04-26 21:40:00","inspection_id":"78448232","insp_violation_id":"252439623","seq_no":"2","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"194584129","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":4652863,"change_date":"2023-04-26 21:40:00","inspection_id":"78448232","insp_unit_id":"194584129","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"SRV033","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS9FDA30459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"}]},{"id":2468624,"change_date":"2023-02-28 21:41:00","inspection_id":"77967100","dot_number":"4029150","report_state":"US","report_number":"1827000077","insp_date":"2023-02-15 00:00:00","insp_start_time":"1701","insp_end_time":"1739","registration_date":null,"region":"HT","ci_status_code":"C","location":null,"location_desc":"DOLE PLANTATION","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"RAINBOW TRANSPORTATION INC","shipping_paper_number":"CHARTER","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-02-28 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":"382575","transaction_code":"A","transaction_date":"2023-02-16 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"04029150","upload_search_indicator":null,"census_search_date":"2023-02-28 21:41:00","snet_input_date":"2023-02-28 00:00:00","source_office":"4COD001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"RAINBOW TRANSPORTATION INC","insp_carrier_street":"1038 KAPAHULU 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:12:08.000000Z","updated_at":"2025-03-17T19:12:08.000000Z","inspection_violations":[{"id":3800122,"change_date":"2023-02-28 21:41:00","inspection_id":"77967100","insp_violation_id":"251387956","seq_no":"1","part_no":"393","part_no_section":"62(c)","insp_viol_unit":"1","insp_unit_id":"193623925","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:53.000000Z","updated_at":"2025-03-17T21:24:53.000000Z","normalized_code":"39362C"},{"id":3800123,"change_date":"2023-02-28 21:41:00","inspection_id":"77967100","insp_violation_id":"251387957","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193623925","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:53.000000Z","updated_at":"2025-03-17T21:24:53.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3973188,"change_date":"2023-02-28 21:41:00","inspection_id":"77967100","insp_unit_id":"193623925","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"C-4","insp_unit_license":"SRV033","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDFE4FS9FDA30459","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:27.000000Z","updated_at":"2025-03-17T22:34:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4029150\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4029150\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4029150\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/4029150\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}