{"current_page":1,"data":[{"id":11730742,"change_date":"2026-04-23 21:39:00","inspection_id":"87658799","dot_number":"277949","report_state":"HI","report_number":"CK46002556","insp_date":"2026-04-22 00:00:00","insp_start_time":"1015","insp_end_time":"1021","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: HONOLULU SHIP SUPPLY CO","shipping_paper_number":"IN-1523485","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-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3202604","transaction_code":"A","transaction_date":"2026-04-23 00:00:00","upload_date":"2026-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2026-04-23 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-23 21:39:00","insp_carrier_name":"Y HATA & COMPANY LIMITED","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:41:12.000000Z","updated_at":"2026-05-04T09:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20411672,"change_date":"2026-04-23 21:39:00","inspection_id":"87658799","insp_unit_id":"213180251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"598476","insp_unit_license":"T29443","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC4NDNU3702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:19:33.000000Z","updated_at":"2026-05-04T09:03:51.000000Z"}]},{"id":11695111,"change_date":"2026-04-20 21:38:00","inspection_id":"87621372","dot_number":"277949","report_state":"HI","report_number":"CQ41000684","insp_date":"2026-04-16 00:00:00","insp_start_time":"1133","insp_end_time":"1205","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3185539","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"Y HATA & COMPANY LIMITED","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:35:44.000000Z","updated_at":"2026-05-01T09:30:45.000000Z","inspection_violations":[{"id":20321629,"change_date":"2026-04-20 21:38:00","inspection_id":"87621372","insp_violation_id":"273715692","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213109947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:21.000000Z","updated_at":"2026-05-01T09:41:57.000000Z","normalized_code":"3939ALFTSI"},{"id":20321630,"change_date":"2026-04-20 21:38:00","inspection_id":"87621372","insp_violation_id":"273715693","seq_no":"2","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"213109947","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:21.000000Z","updated_at":"2026-05-01T09:41:57.000000Z","normalized_code":"39395A4EEUS"},{"id":20321631,"change_date":"2026-04-20 21:38:00","inspection_id":"87621372","insp_violation_id":"273715694","seq_no":"3","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"213109947","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:21.000000Z","updated_at":"2026-05-01T09:41:57.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":20353434,"change_date":"2026-04-20 21:38:00","inspection_id":"87621372","insp_unit_id":"213109947","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"230043","insp_unit_license":"T30795","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HAEUMMK0RL255062","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:02.000000Z","updated_at":"2026-05-01T09:03:35.000000Z"}]},{"id":11281522,"change_date":"2026-03-04 21:40:00","inspection_id":"87196229","dot_number":"277949","report_state":"HI","report_number":"CU42000860","insp_date":"2026-03-02 00:00:00","insp_start_time":"1127","insp_end_time":"1137","registration_date":null,"region":"HS","ci_status_code":"C","location":"101","location_desc":"KANEOHE HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"IN-1472646","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"2957810","transaction_code":"A","transaction_date":"2026-03-03 00:00:00","upload_date":"2026-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2026-03-04 21:40:00","snet_input_date":"2026-03-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-04 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-03-07T10:38:59.000000Z","updated_at":"2026-03-15T09:30:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19294687,"change_date":"2026-03-04 21:40:00","inspection_id":"87196229","insp_unit_id":"211952574","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"230041","insp_unit_license":"T30787","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HAEUMMK7RL255060","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-07T10:15:39.000000Z","updated_at":"2026-03-15T09:03:33.000000Z"}]},{"id":11045335,"change_date":"2026-02-04 21:39:00","inspection_id":"86954877","dot_number":"277949","report_state":"HI","report_number":"CV21000237","insp_date":"2026-02-03 00:00:00","insp_start_time":"1235","insp_end_time":"1333","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"Y.HATA & COMPANY, LTD","shipping_paper_number":"OTPU6345192","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-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"126200","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":"2844604","transaction_code":"A","transaction_date":"2026-02-04 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-08T10:36:59.000000Z","updated_at":"2026-02-15T10:30:33.000000Z","inspection_violations":[{"id":18299678,"change_date":"2026-02-04 21:39:00","inspection_id":"86954877","insp_violation_id":"271590298","seq_no":"1","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"211434470","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-07T10:45:31.000000Z","updated_at":"2026-02-15T10:39:53.000000Z","normalized_code":"39345B2BAIR"},{"id":18299679,"change_date":"2026-02-04 21:39:00","inspection_id":"86954877","insp_violation_id":"271590299","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211434469","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-25-155437","created_at":"2026-02-07T10:45:31.000000Z","updated_at":"2026-02-15T10:39:53.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":18371924,"change_date":"2026-02-04 21:39:00","inspection_id":"86954877","insp_unit_id":"211434469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"386538","insp_unit_license":"T28372","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV3MSMW0260","insp_unit_decal":"Y","insp_unit_decal_number":"36124716","created_at":"2026-02-07T10:11:00.000000Z","updated_at":"2026-02-15T10:05:07.000000Z"},{"id":18371925,"change_date":"2026-02-04 21:39:00","inspection_id":"86954877","insp_unit_id":"211434470","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"SEAC430979","insp_unit_license":"0826TR","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C412S3ST008950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:11:00.000000Z","updated_at":"2026-02-15T10:05:07.000000Z"}]},{"id":10857160,"change_date":"2026-01-25 21:33:00","inspection_id":"86886549","dot_number":"277949","report_state":"HI","report_number":"CS27001146","insp_date":"2026-01-20 00:00:00","insp_start_time":"1030","insp_end_time":"1101","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2812483","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":"00277949","upload_search_indicator":null,"census_search_date":"2026-01-25 21:33:00","snet_input_date":"2026-01-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-25 21:33:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-28T10:36:23.000000Z","updated_at":"2026-02-05T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18242212,"change_date":"2026-01-25 21:33:00","inspection_id":"86886549","insp_unit_id":"211281650","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225074","insp_unit_license":"T30036","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC4PDUJ2272","insp_unit_decal":"Y","insp_unit_decal_number":"36124587","created_at":"2026-01-28T10:08:23.000000Z","updated_at":"2026-02-05T10:02:16.000000Z"}]},{"id":9947711,"change_date":"2025-10-15 21:39:00","inspection_id":"86055159","dot_number":"277949","report_state":"HI","report_number":"CS27001073","insp_date":"2025-10-07 00:00:00","insp_start_time":"0907","insp_end_time":"0947","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"1316755","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":"33000","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":"2416119","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":"00277949","upload_search_indicator":null,"census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:53.000000Z","updated_at":"2025-10-19T10:00:42.000000Z","inspection_violations":[{"id":16425615,"change_date":"2025-10-15 21:39:00","inspection_id":"86055159","insp_violation_id":"269312395","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209480854","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:58.000000Z","updated_at":"2025-10-19T10:16:15.000000Z","normalized_code":"39021TB1MC"},{"id":16425616,"change_date":"2025-10-15 21:39:00","inspection_id":"86055159","insp_violation_id":"269312396","seq_no":"2","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209480854","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:58.000000Z","updated_at":"2025-10-19T10:16:15.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":16514432,"change_date":"2025-10-15 21:39:00","inspection_id":"86055159","insp_unit_id":"209480854","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"536224","insp_unit_license":"T30580","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFCXRDUZ2700","insp_unit_decal":"Y","insp_unit_decal_number":"35830101","created_at":"2025-10-18T09:47:11.000000Z","updated_at":"2025-10-19T09:45:52.000000Z"}]},{"id":9774539,"change_date":"2025-09-24 21:42:00","inspection_id":"85872551","dot_number":"277949","report_state":"CA","report_number":"UERV005762","insp_date":"2025-09-24 00:00:00","insp_start_time":"0820","insp_end_time":"0845","registration_date":null,"region":"PT","ci_status_code":"C","location":"9530","location_desc":"SOUTH LA","county_code_state":"CA","county_code":"037","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":"N","pen_cen_match":null,"final_status_date":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"15993478","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:20.000000Z","updated_at":"2025-09-28T10:00:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16193127,"change_date":"2025-09-24 21:42:00","inspection_id":"85872551","insp_unit_id":"209134756","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"WHI","insp_unit_license":"9H02272","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3AKJHLDV4RSVL9511","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:27.000000Z","updated_at":"2025-09-29T09:46:29.000000Z"}]},{"id":8671361,"change_date":"2025-05-19 21:39:00","inspection_id":"84710625","dot_number":"277949","report_state":"HI","report_number":"CS27000960","insp_date":"2025-05-16 00:00:00","insp_start_time":"1010","insp_end_time":"1027","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"PGHU401354","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"138150","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":"1746923","transaction_code":"A","transaction_date":"2025-05-18 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-05-19 21:39:00","snet_input_date":"2025-05-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:10.000000Z","updated_at":"2025-05-23T10:03:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14164312,"change_date":"2025-05-19 21:39:00","inspection_id":"84710625","insp_unit_id":"206932388","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YN-05","insp_unit_license":"266TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKNC5DV5NDNN3248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:54.000000Z","updated_at":"2025-05-23T09:48:20.000000Z"},{"id":14164313,"change_date":"2025-05-19 21:39:00","inspection_id":"84710625","insp_unit_id":"206932389","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"BERTOLINI","insp_unit_company":null,"insp_unit_license":"TR097F","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"B36053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:45:54.000000Z","updated_at":"2025-05-23T09:48:20.000000Z"}]},{"id":8284523,"change_date":"2025-04-03 21:41:00","inspection_id":"84303275","dot_number":"277949","report_state":"HI","report_number":"CU42000644","insp_date":"2025-04-02 00:00:00","insp_start_time":"1311","insp_end_time":"1320","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1550459","transaction_code":"A","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-04-03 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-03 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-06T10:24:51.000000Z","updated_at":"2025-04-07T10:18:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13420787,"change_date":"2025-04-03 21:41:00","inspection_id":"84303275","insp_unit_id":"206135747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225074","insp_unit_license":"T30036","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC4PDUJ2272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-06T10:09:22.000000Z","updated_at":"2025-04-07T09:57:12.000000Z"}]},{"id":8262588,"change_date":"2025-04-01 21:40:00","inspection_id":"84280246","dot_number":"277949","report_state":"HI","report_number":"CK46002237","insp_date":"2025-03-28 00:00:00","insp_start_time":"1025","insp_end_time":"1104","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1540043","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-04-01 21:40:00","snet_input_date":"2025-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-01 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-04T10:21:10.000000Z","updated_at":"2025-04-06T10:19:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13372952,"change_date":"2025-04-01 21:40:00","inspection_id":"84280246","insp_unit_id":"206094053","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225678","insp_unit_license":"T29964","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC1PDUJ2276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-04T10:07:07.000000Z","updated_at":"2025-04-05T09:55:32.000000Z"}]},{"id":8176788,"change_date":"2025-03-21 21:40:00","inspection_id":"84189785","dot_number":"277949","report_state":"HI","report_number":"CK46002231","insp_date":"2025-03-20 00:00:00","insp_start_time":"1135","insp_end_time":"1147","registration_date":null,"region":"HS","ci_status_code":"C","location":"107","location_desc":"KAPOLEI 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-03-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"1498961","transaction_code":"A","transaction_date":"2025-03-21 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-03-21 21:40:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-21 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-24T10:27:55.000000Z","updated_at":"2025-03-25T10:10:33.000000Z","inspection_violations":[{"id":12815662,"change_date":"2025-03-21 21:40:00","inspection_id":"84189785","insp_violation_id":"265181006","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205924217","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:37:01.000000Z","updated_at":"2025-03-25T10:28:20.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13217349,"change_date":"2025-03-21 21:40:00","inspection_id":"84189785","insp_unit_id":"205924217","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225678","insp_unit_license":"T29964","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC1PDUJ2276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:14:23.000000Z","updated_at":"2025-03-25T09:55:34.000000Z"}]},{"id":7569897,"change_date":"2025-01-08 21:38:00","inspection_id":"83552169","dot_number":"277949","report_state":"HI","report_number":"CK46002170","insp_date":"2025-01-06 00:00:00","insp_start_time":"1039","insp_end_time":"1125","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: MARRIOTT KOOLINA BCH CLUB","shipping_paper_number":"IN-1039951","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:38:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"1224126","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2025-01-08 21:38:00","snet_input_date":"2025-01-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-08 21:38:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:17.000000Z","updated_at":"2025-03-17T20:55:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12213836,"change_date":"2025-01-08 21:38:00","inspection_id":"83552169","insp_unit_id":"204698256","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"386537","insp_unit_license":"T28363","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKBHSDV9MSMW0259","insp_unit_decal":"Y","insp_unit_decal_number":"35013981","created_at":"2025-03-17T23:49:49.000000Z","updated_at":"2025-03-17T23:49:49.000000Z"},{"id":12213837,"change_date":"2025-01-08 21:38:00","inspection_id":"83552169","insp_unit_id":"204698257","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"TR-33","insp_unit_license":"607WEP","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1UYVS1320EU800303","insp_unit_decal":"Y","insp_unit_decal_number":"35013982","created_at":"2025-03-17T23:49:49.000000Z","updated_at":"2025-03-17T23:49:49.000000Z"}]},{"id":7458740,"change_date":"2024-12-19 21:40:00","inspection_id":"83435414","dot_number":"277949","report_state":"HI","report_number":"BP16003266","insp_date":"2024-12-17 00:00:00","insp_start_time":"1040","insp_end_time":"1051","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175143","transaction_code":"A","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-12-19 21:40:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-19 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS RD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:36.000000Z","updated_at":"2025-03-17T20:51:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12032987,"change_date":"2024-12-19 21:40:00","inspection_id":"83435414","insp_unit_id":"204474400","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"598476","insp_unit_license":"T29443","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC4NDNU3702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:53.000000Z","updated_at":"2025-03-17T23:47:53.000000Z"}]},{"id":7226998,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","dot_number":"277949","report_state":"HI","report_number":"BY39002630","insp_date":"2024-11-18 00:00:00","insp_start_time":"0922","insp_end_time":"1044","registration_date":null,"region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"1068817","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:46:49.000000Z","updated_at":"2025-03-17T20:46:49.000000Z","inspection_violations":[{"id":11296799,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_violation_id":"262970945","seq_no":"1","part_no":"393","part_no_section":"25A-L","insp_viol_unit":"1","insp_unit_id":"203947269","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"39325AL"},{"id":11296800,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_violation_id":"262970946","seq_no":"2","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"203947270","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"39355EB"},{"id":11296801,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_violation_id":"262970947","seq_no":"3","part_no":"390","part_no_section":"19A2","insp_viol_unit":"1","insp_unit_id":"203947269","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"39019A2"},{"id":11296802,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_violation_id":"262970948","seq_no":"4","part_no":"393","part_no_section":"13C3-CSURR","insp_viol_unit":"2","insp_unit_id":"203947270","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"39313C3CSURR"}],"inspection_per_units":[{"id":11657030,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_unit_id":"203947269","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"386537","insp_unit_license":"T28363","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKBHSDV9MSMW0259","insp_unit_decal":"Y","insp_unit_decal_number":"34742795","created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"},{"id":11657031,"change_date":"2024-11-19 21:40:00","inspection_id":"83191373","insp_unit_id":"203947270","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"209734","insp_unit_license":"TR308C","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1UYVS132702186601","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"}]},{"id":6776285,"change_date":"2024-09-20 21:42:00","inspection_id":"82712848","dot_number":"277949","report_state":"HI","report_number":"CP19000975","insp_date":"2024-09-18 00:00:00","insp_start_time":"1228","insp_end_time":"1318","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"867684","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-09-20 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-20 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:37:22.000000Z","updated_at":"2025-03-17T20:37:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10927365,"change_date":"2024-09-20 21:42:00","inspection_id":"82712848","insp_unit_id":"203043188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"598439","insp_unit_license":"T29558","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV2NSNU3700","insp_unit_decal":"Y","insp_unit_decal_number":"34412592","created_at":"2025-03-17T23:36:12.000000Z","updated_at":"2025-03-17T23:36:12.000000Z"},{"id":10927366,"change_date":"2024-09-20 21:42:00","inspection_id":"82712848","insp_unit_id":"203043189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"40044","insp_unit_license":"TR167F","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1UYVS2458S2255201","insp_unit_decal":"Y","insp_unit_decal_number":"34412593","created_at":"2025-03-17T23:36:12.000000Z","updated_at":"2025-03-17T23:36:12.000000Z"}]},{"id":6694251,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","dot_number":"277949","report_state":"HI","report_number":"CP19000969","insp_date":"2024-09-06 00:00:00","insp_start_time":"0936","insp_end_time":"1105","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"Y.HATA & COMPANY LTD","shipping_paper_number":"OTPU6347338","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142800","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":"832919","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-09-11 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-11 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:35:41.000000Z","updated_at":"2025-03-17T20:35:41.000000Z","inspection_violations":[{"id":10420890,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_violation_id":"261728535","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"202858399","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"39311A1"},{"id":10420891,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_violation_id":"261728536","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202858399","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"39345D"},{"id":10420892,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_violation_id":"261728537","seq_no":"3","part_no":"393","part_no_section":"126(b)","insp_viol_unit":"2","insp_unit_id":"202858400","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"393126B"},{"id":10420893,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_violation_id":"261728538","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202858400","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023566","created_at":"2025-03-17T21:56:30.000000Z","updated_at":"2025-03-17T21:56:30.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10793943,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_unit_id":"202858399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YN-06","insp_unit_license":"265TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKNC5DV7NDNN3249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"},{"id":10793944,"change_date":"2024-09-11 21:40:00","inspection_id":"82625494","insp_unit_id":"202858400","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"PHCZ040060","insp_unit_license":"TR3169","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"LJRC41267F1007130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":6665017,"change_date":"2025-12-05 21:42:00","inspection_id":"82594433","dot_number":"277949","report_state":"HI","report_number":"BY39002573","insp_date":"2024-09-04 00:00:00","insp_start_time":"1225","insp_end_time":"1304","registration_date":"2024-09-09 00:00:00","region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"17999","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":"822109","transaction_code":"C","transaction_date":"2024-09-06 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-09-06 21:40:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-06 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:35:12.000000Z","updated_at":"2025-12-09T10:30:12.000000Z","inspection_violations":[{"id":17336068,"change_date":"2025-12-05 21:42:00","inspection_id":"82594433","insp_violation_id":"270482726","seq_no":"1","part_no":"393","part_no_section":"67C11-F","insp_viol_unit":"1","insp_unit_id":"210434103","insp_violation_category_id":"18","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":"39367C11F"}],"inspection_per_units":[{"id":17307188,"change_date":"2025-12-05 21:42:00","inspection_id":"82594433","insp_unit_id":"210434103","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"230040","insp_unit_license":"T30724","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HAEUMMK0RL255059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:01:48.000000Z","updated_at":"2025-12-09T10:00:17.000000Z"}]},{"id":6608235,"change_date":"2025-10-09 21:40:00","inspection_id":"82534026","dot_number":"277949","report_state":"HI","report_number":"BP16003169","insp_date":"2024-08-29 00:00:00","insp_start_time":"1248","insp_end_time":"1341","registration_date":"2024-09-03 00:00:00","region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"Y. HATA & COMPANY, LTD.","shipping_paper_number":"OTPU6352648","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"131550","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":"800973","transaction_code":"C","transaction_date":"2024-08-30 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:34:03.000000Z","updated_at":"2025-10-13T10:00:08.000000Z","inspection_violations":[{"id":16314952,"change_date":"2025-10-09 21:40:00","inspection_id":"82534026","insp_violation_id":"269203925","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"209384392","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-24-023406","created_at":"2025-10-12T10:17:08.000000Z","updated_at":"2025-10-13T10:15:08.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":16414031,"change_date":"2025-10-09 21:40:00","inspection_id":"82534026","insp_unit_id":"209384391","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YN-05","insp_unit_license":"266TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKNC5DV5NDNN3248","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":16414032,"change_date":"2025-10-09 21:40:00","inspection_id":"82534026","insp_unit_id":"209384392","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC VEHIC","insp_unit_company":"FLKZ600881","insp_unit_license":"TR227F","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"LJRC4126661005028","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":6473483,"change_date":"2024-08-15 21:42:00","inspection_id":"82390262","dot_number":"277949","report_state":"HI","report_number":"CT31000799","insp_date":"2024-08-14 00:00:00","insp_start_time":"1313","insp_end_time":"1345","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"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-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"748583","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-08-15 21:42:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-15 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:31:09.000000Z","updated_at":"2025-03-17T20:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10434501,"change_date":"2024-08-15 21:42:00","inspection_id":"82390262","insp_unit_id":"202403251","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"598440","insp_unit_license":"T29559","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV4NSNU3701","insp_unit_decal":"Y","insp_unit_decal_number":"34412637","created_at":"2025-03-17T23:31:06.000000Z","updated_at":"2025-03-17T23:31:06.000000Z"}]},{"id":6139525,"change_date":"2024-07-03 21:39:00","inspection_id":"82032655","dot_number":"277949","report_state":"HI","report_number":"CP19000898","insp_date":"2024-07-02 00:00:00","insp_start_time":"0956","insp_end_time":"1031","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CONSIGNEE: WAIANAE MEAT MARKET","shipping_paper_number":"IN-827119","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":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"624607","transaction_code":"A","transaction_date":"2024-07-03 00:00:00","upload_date":"2024-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-07-03 21:39:00","snet_input_date":"2024-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-03 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:24:15.000000Z","updated_at":"2025-03-17T20:24:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9889297,"change_date":"2024-07-03 21:39:00","inspection_id":"82032655","insp_unit_id":"201721144","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"137997","insp_unit_license":"T27110","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXDT1GDHG3268","insp_unit_decal":"Y","insp_unit_decal_number":"34412578","created_at":"2025-03-17T23:25:28.000000Z","updated_at":"2025-03-17T23:25:28.000000Z"}]},{"id":6124462,"change_date":"2024-07-02 21:41:00","inspection_id":"82016346","dot_number":"277949","report_state":"HI","report_number":"BY39002506","insp_date":"2024-06-27 00:00:00","insp_start_time":"1039","insp_end_time":"1111","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"618233","transaction_code":"A","transaction_date":"2024-07-01 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:24:10.000000Z","updated_at":"2025-03-17T20:24:10.000000Z","inspection_violations":[{"id":9508959,"change_date":"2024-07-02 21:41:00","inspection_id":"82016346","insp_violation_id":"260423584","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201690034","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":9864968,"change_date":"2024-07-02 21:41:00","inspection_id":"82016346","insp_unit_id":"201690034","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225678","insp_unit_license":"T29964","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC1PDUJ2276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:12.000000Z","updated_at":"2025-03-17T23:25:12.000000Z"}]},{"id":5935027,"change_date":"2024-06-07 21:37:00","inspection_id":"81811883","dot_number":"277949","report_state":"HI","report_number":"CS27000697","insp_date":"2024-06-05 00:00:00","insp_start_time":"1249","insp_end_time":"1328","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-07 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"547968","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-06-07 21:37:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-07 21:37:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:20:17.000000Z","updated_at":"2025-03-17T20:20:17.000000Z","inspection_violations":[{"id":9205598,"change_date":"2024-06-07 21:37:00","inspection_id":"81811883","insp_violation_id":"259956869","seq_no":"1","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201279095","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"39021TB1"},{"id":9205599,"change_date":"2024-06-07 21:37:00","inspection_id":"81811883","insp_violation_id":"259956870","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201279095","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:31.000000Z","updated_at":"2025-03-17T21:50:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9559606,"change_date":"2024-06-07 21:37:00","inspection_id":"81811883","insp_unit_id":"201279095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"419652","insp_unit_license":"T29280","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC9NDMZ0091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:07.000000Z","updated_at":"2025-03-17T23:22:07.000000Z"}]},{"id":5913789,"change_date":"2024-06-05 21:41:00","inspection_id":"81788753","dot_number":"277949","report_state":"HI","report_number":"CK46001996","insp_date":"2024-06-03 00:00:00","insp_start_time":"1232","insp_end_time":"1306","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"540714","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:19:51.000000Z","updated_at":"2025-03-17T20:19:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9525166,"change_date":"2024-06-05 21:41:00","inspection_id":"81788753","insp_unit_id":"201235958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"386538","insp_unit_license":"T28372","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV3MSMW0260","insp_unit_decal":"Y","insp_unit_decal_number":"34087512","created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"}]},{"id":5841979,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","dot_number":"277949","report_state":"HI","report_number":"CT31000735","insp_date":"2024-05-24 00:00:00","insp_start_time":"0902","insp_end_time":"1009","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"Y. HATA & COMPANY","shipping_paper_number":"PGHU4025736","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-27 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"129350","viol_total":"3","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":"514030","transaction_code":"A","transaction_date":"2024-05-27 00:00:00","upload_date":"2024-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-05-27 21:34:00","snet_input_date":"2024-05-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-27 21:34:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:18:37.000000Z","updated_at":"2025-03-17T20:18:37.000000Z","inspection_violations":[{"id":9053122,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","insp_violation_id":"259727499","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201083706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9053123,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","insp_violation_id":"259727500","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201083706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9053124,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","insp_violation_id":"259727501","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201083706","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":9408591,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","insp_unit_id":"201083705","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"YN-05","insp_unit_license":"266TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKNC5DV5NDNN3248","insp_unit_decal":"Y","insp_unit_decal_number":"34087565","created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"},{"id":9408592,"change_date":"2024-05-27 21:34:00","inspection_id":"81710807","insp_unit_id":"201083706","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"ARMOR MOBI","insp_unit_company":"TAXZ405010","insp_unit_license":"924WEX","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"5AXCG4024XR135091","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"}]},{"id":5638684,"change_date":"2024-05-01 21:42:00","inspection_id":"81490134","dot_number":"277949","report_state":"HI","report_number":"BY39002463","insp_date":"2024-04-30 00:00:00","insp_start_time":"1235","insp_end_time":"1256","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND SCALE FACILITY","county_code_state":"HI","county_code":"003","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"442626","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-05-01 21:42:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-01 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:14:21.000000Z","updated_at":"2025-03-17T20:14:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9082680,"change_date":"2024-05-01 21:42:00","inspection_id":"81490134","insp_unit_id":"200662456","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225077","insp_unit_license":"T30025","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFCXPDUJ2275","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:30.000000Z","updated_at":"2025-03-17T23:17:30.000000Z"}]},{"id":5420054,"change_date":"2024-04-03 21:40:00","inspection_id":"81251580","dot_number":"277949","report_state":"HI","report_number":"CU42000344","insp_date":"2024-04-01 00:00:00","insp_start_time":"1225","insp_end_time":"1253","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"29999","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":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"365784","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":"00277949","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":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:10:14.000000Z","updated_at":"2025-03-17T20:10:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8730079,"change_date":"2024-04-03 21:40:00","inspection_id":"81251580","insp_unit_id":"200204346","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225077","insp_unit_license":"T30025","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFCXPDUJ2275","insp_unit_decal":"Y","insp_unit_decal_number":"34087605","created_at":"2025-03-17T23:14:13.000000Z","updated_at":"2025-03-17T23:14:13.000000Z"}]},{"id":5186495,"change_date":"2024-03-01 21:39:00","inspection_id":"80996554","dot_number":"277949","report_state":"HI","report_number":"BY39002404","insp_date":"2024-02-29 00:00:00","insp_start_time":"1132","insp_end_time":"1208","registration_date":null,"region":"HS","ci_status_code":"C","location":"32","location_desc":"WAIANAE HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"41365","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","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":"285165","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:05:20.000000Z","updated_at":"2025-03-17T20:05:20.000000Z","inspection_violations":[{"id":7993396,"change_date":"2024-03-01 21:39:00","inspection_id":"80996554","insp_violation_id":"258146371","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"199703897","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3939ALCL"},{"id":7993397,"change_date":"2024-03-01 21:39:00","inspection_id":"80996554","insp_violation_id":"258146372","seq_no":"2","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"1","insp_unit_id":"199703897","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"393201AFRCLS"},{"id":7993398,"change_date":"2024-03-01 21:39:00","inspection_id":"80996554","insp_violation_id":"258146373","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"199703897","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":8350918,"change_date":"2024-03-01 21:39:00","inspection_id":"80996554","insp_unit_id":"199703897","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"137999","insp_unit_license":"T25690","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXDTXGDHG3270","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4914290,"change_date":"2024-01-28 21:31:00","inspection_id":"80699443","dot_number":"277949","report_state":"HI","report_number":"BP16002905","insp_date":"2024-01-25 00:00:00","insp_start_time":"1257","insp_end_time":"1319","registration_date":null,"region":"HS","ci_status_code":"C","location":"03","location_desc":"HONOLULU HI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-01-28 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"199681","transaction_code":"A","transaction_date":"2024-01-28 00:00:00","upload_date":"2024-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","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":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","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:00:04.000000Z","updated_at":"2025-03-17T20:00:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7907990,"change_date":"2024-01-28 21:31:00","inspection_id":"80699443","insp_unit_id":"199135665","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"386539","insp_unit_license":"T28362","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV5MSMW0261","insp_unit_decal":"Y","insp_unit_decal_number":"33787688","created_at":"2025-03-17T23:06:41.000000Z","updated_at":"2025-03-17T23:06:41.000000Z"}]},{"id":3757356,"change_date":"2023-08-16 21:39:00","inspection_id":"79422216","dot_number":"277949","report_state":"HI","report_number":"CS27000472","insp_date":"2023-08-16 00:00:00","insp_start_time":"1242","insp_end_time":"1251","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134604","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-08-16 21:39:00","snet_input_date":"2023-08-16 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-16 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:57.000000Z","updated_at":"2025-03-17T19:36:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6041737,"change_date":"2023-08-16 21:39:00","inspection_id":"79422216","insp_unit_id":"196563965","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"386539","insp_unit_license":"T28362","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV5MSMW0261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:47.000000Z","updated_at":"2025-03-17T22:50:47.000000Z"}]},{"id":3502858,"change_date":"2023-07-13 21:42:00","inspection_id":"79137434","dot_number":"277949","report_state":"HI","report_number":"00CK001755","insp_date":"2023-07-11 00:00:00","insp_start_time":"1319","insp_end_time":"1329","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134284","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-07-13 21:42:00","snet_input_date":"2023-07-13 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-07-13 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:25.000000Z","updated_at":"2025-03-17T19:32:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5632585,"change_date":"2023-07-13 21:42:00","inspection_id":"79137434","insp_unit_id":"195988544","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"386539","insp_unit_license":"T28362","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV5MSMW0261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:27.000000Z","updated_at":"2025-03-17T22:47:27.000000Z"}]},{"id":3406000,"change_date":"2023-06-29 21:43:00","inspection_id":"79028607","dot_number":"277949","report_state":"HI","report_number":"CU42000057","insp_date":"2023-06-29 00:00:00","insp_start_time":"0855","insp_end_time":"0912","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"COSTCO DEPOT 960","shipping_paper_number":"PGHU5102919","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"125900","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":"134199","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-06-29 21:43:00","snet_input_date":"2023-06-29 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-06-29 21:43:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:33.000000Z","updated_at":"2025-03-17T19:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5476221,"change_date":"2023-06-29 21:43:00","inspection_id":"79028607","insp_unit_id":"195766046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"598440","insp_unit_license":"T29559","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV4NSNU3701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:12.000000Z","updated_at":"2025-03-17T22:46:12.000000Z"},{"id":5476222,"change_date":"2023-06-29 21:43:00","inspection_id":"79028607","insp_unit_id":"195766047","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"FLTZ 370137","insp_unit_license":"TR496C","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C452S8WT005314","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:12.000000Z","updated_at":"2025-03-17T22:46:12.000000Z"}]},{"id":3297103,"change_date":"2023-06-15 21:42:00","inspection_id":"78906151","dot_number":"277949","report_state":"HI","report_number":"CS27000403","insp_date":"2023-06-09 00:00:00","insp_start_time":"1238","insp_end_time":"1248","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134129","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-06-15 21:42:00","snet_input_date":"2023-06-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-06-15 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5300986,"change_date":"2023-06-15 21:42:00","inspection_id":"78906151","insp_unit_id":"195525807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"386539","insp_unit_license":"T28362","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV5MSMW0261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:49.000000Z","updated_at":"2025-03-17T22:44:49.000000Z"}]},{"id":3168193,"change_date":"2023-05-30 21:43:00","inspection_id":"78760394","dot_number":"277949","report_state":"HI","report_number":"CP19000607","insp_date":"2023-05-25 00:00:00","insp_start_time":"1219","insp_end_time":"1229","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"PGHU4505123","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"134053","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-05-30 21:43:00","snet_input_date":"2023-05-30 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-05-30 21:43:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5096043,"change_date":"2023-05-30 21:43:00","inspection_id":"78760394","insp_unit_id":"195203398","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"598440","insp_unit_license":"T29559","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV4NSNU3701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:10.000000Z","updated_at":"2025-03-17T22:43:10.000000Z"},{"id":5096044,"change_date":"2023-05-30 21:43:00","inspection_id":"78760394","insp_unit_id":"195203399","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"HRZZ 454115","insp_unit_license":"TR1215","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1JJC48247NLL72927","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:10.000000Z","updated_at":"2025-03-17T22:43:10.000000Z"}]},{"id":3034886,"change_date":"2023-05-12 21:42:00","inspection_id":"78610278","dot_number":"277949","report_state":"HI","report_number":"CU42000019","insp_date":"2023-05-10 00:00:00","insp_start_time":"1310","insp_end_time":"1342","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","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":"133925","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","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":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:02.000000Z","updated_at":"2025-03-17T19:23:02.000000Z","inspection_violations":[{"id":4660786,"change_date":"2023-05-12 21:42:00","inspection_id":"78610278","insp_violation_id":"252804359","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"194908047","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:45.000000Z","updated_at":"2025-03-17T21:28:45.000000Z","normalized_code":"39021TA"},{"id":4660787,"change_date":"2023-05-12 21:42:00","inspection_id":"78610278","insp_violation_id":"252804360","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194908047","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:45.000000Z","updated_at":"2025-03-17T21:28:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4882476,"change_date":"2023-05-12 21:42:00","inspection_id":"78610278","insp_unit_id":"194908047","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"692238","insp_unit_license":"T29441","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3HSDZTZR5PN225839","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":2657518,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","dot_number":"277949","report_state":"HI","report_number":"CS27000358","insp_date":"2023-03-16 00:00:00","insp_start_time":"0850","insp_end_time":"1011","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"FAS104","shipping_paper_number":"PGHU5007315","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-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"131700","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133694","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-24 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[{"id":4084680,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_violation_id":"251861316","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194057135","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39311"},{"id":4084681,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_violation_id":"251861317","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"194057135","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39395B"},{"id":4084682,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_violation_id":"251861318","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194057136","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39355E"},{"id":4084683,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_violation_id":"251861319","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"194057136","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4278601,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_unit_id":"194057135","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"134444","insp_unit_license":"T25526","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJGED51GSHC1323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4278602,"change_date":"2023-03-24 21:41:00","inspection_id":"78181767","insp_unit_id":"194057136","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"FRCZ 137552","insp_unit_license":"4824TR","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C412S6YT067211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":2657519,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","dot_number":"277949","report_state":"HI","report_number":"CS27000361","insp_date":"2023-03-16 00:00:00","insp_start_time":"1343","insp_end_time":"1408","registration_date":"2023-03-28 00:00:00","region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"Y. HATA & COMPANY LTD","shipping_paper_number":"TCNU5144346","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-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"133700","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":"133695","transaction_code":"C","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-03-24 21:41:00","snet_input_date":"2023-03-24 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:35.000000Z","updated_at":"2025-03-17T19:15:35.000000Z","inspection_violations":[{"id":4084684,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_violation_id":"251956914","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194146202","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39021TB"},{"id":4084685,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_violation_id":"251956915","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194146202","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"3922"},{"id":4084686,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_violation_id":"251956916","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"194146203","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39311"},{"id":4084687,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_violation_id":"251956917","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194146203","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:08.000000Z","updated_at":"2025-03-17T21:26:08.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4278603,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_unit_id":"194146202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YN-05","insp_unit_license":"266TXN","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKNC5DV5NDNN3248","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4278604,"change_date":"2023-03-30 21:41:00","inspection_id":"78181768","insp_unit_id":"194146203","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"CXCZ 880039","insp_unit_license":"2017TR","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C412S7YT122622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":2604525,"change_date":"2023-07-19 21:44:00","inspection_id":"78122023","dot_number":"277949","report_state":"HI","report_number":"00BY002227","insp_date":"2023-03-15 00:00:00","insp_start_time":"1224","insp_end_time":"1251","registration_date":"2023-07-14 00:00:00","region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"133640","transaction_code":"C","transaction_date":"2023-03-15 00:00:00","upload_date":"2023-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-03-17 21:42:00","snet_input_date":"2023-03-17 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:49.000000Z","updated_at":"2025-03-17T19:14:49.000000Z","inspection_violations":[{"id":4007698,"change_date":"2023-07-19 21:44:00","inspection_id":"78122023","insp_violation_id":"254158892","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39141A1"},{"id":4007699,"change_date":"2023-07-19 21:44:00","inspection_id":"78122023","insp_violation_id":"254158893","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"1","insp_unit_id":"196089127","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":4192646,"change_date":"2023-07-19 21:44:00","inspection_id":"78122023","insp_unit_id":"196089127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"123673","insp_unit_license":"T25639","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXDT7GDGX3966","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:03.000000Z","updated_at":"2025-03-17T22:36:03.000000Z"}]},{"id":2085778,"change_date":"2023-01-06 21:39:00","inspection_id":"77529991","dot_number":"277949","report_state":"HI","report_number":"00BP002626","insp_date":"2023-01-04 00:00:00","insp_start_time":"1010","insp_end_time":"1018","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127780","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":"133162","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2023-01-06 21:39:00","snet_input_date":"2023-01-06 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-01-06 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:06.000000Z","updated_at":"2025-03-17T19:05:06.000000Z","inspection_violations":[{"id":3227395,"change_date":"2023-01-06 21:39:00","inspection_id":"77529991","insp_violation_id":"250430957","seq_no":"1","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"192740916","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:18.000000Z","updated_at":"2025-03-17T21:22:18.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":3355794,"change_date":"2023-01-06 21:39:00","inspection_id":"77529991","insp_unit_id":"192740916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"128135","insp_unit_license":"T28626","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJGEDV2GSGW5994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:02.000000Z","updated_at":"2025-03-17T22:30:02.000000Z"},{"id":3355795,"change_date":"2023-01-06 21:39:00","inspection_id":"77529991","insp_unit_id":"192740917","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"PHCZ 480009","insp_unit_license":"TR1108","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C492S0RT005187","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:02.000000Z","updated_at":"2025-03-17T22:30:02.000000Z"}]},{"id":1717361,"change_date":"2022-11-10 21:39:00","inspection_id":"77108452","dot_number":"277949","report_state":"HI","report_number":"00BY002141","insp_date":"2022-10-31 00:00:00","insp_start_time":"1242","insp_end_time":"1338","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132840","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","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":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:14.000000Z","updated_at":"2025-03-17T18:58:14.000000Z","inspection_violations":[{"id":2691393,"change_date":"2022-11-10 21:39:00","inspection_id":"77108452","insp_violation_id":"249545988","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191906516","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-22-164004","created_at":"2025-03-17T21:19:40.000000Z","updated_at":"2025-03-17T21:19:40.000000Z","normalized_code":"39617C"},{"id":2691394,"change_date":"2022-11-10 21:39:00","inspection_id":"77108452","insp_violation_id":"249545989","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191906516","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:40.000000Z","updated_at":"2025-03-17T21:19:40.000000Z","normalized_code":"3939A"},{"id":2691395,"change_date":"2022-11-10 21:39:00","inspection_id":"77108452","insp_violation_id":"249545990","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"191906516","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:40.000000Z","updated_at":"2025-03-17T21:19:40.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":2762922,"change_date":"2022-11-10 21:39:00","inspection_id":"77108452","insp_unit_id":"191906516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"137996","insp_unit_license":"T26574","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXDTXGDHG3267","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":1573407,"change_date":"2022-10-27 21:41:00","inspection_id":"76943314","dot_number":"277949","report_state":"HI","report_number":"00CK001533","insp_date":"2022-10-13 00:00:00","insp_start_time":"1251","insp_end_time":"1321","registration_date":"2022-10-18 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":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":"17950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132711","transaction_code":"C","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","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":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:37.000000Z","updated_at":"2025-03-17T18:55:37.000000Z","inspection_violations":[{"id":2474199,"change_date":"2022-10-27 21:41:00","inspection_id":"76943314","insp_violation_id":"249291556","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191676920","insp_violation_category_id":"30","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":"3922"}],"inspection_per_units":[{"id":2532291,"change_date":"2022-10-27 21:41:00","inspection_id":"76943314","insp_unit_id":"191676920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"R14","insp_unit_license":"T27181","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"JALE5W160H7900914","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":1518588,"change_date":"2022-10-14 21:39:00","inspection_id":"76880155","dot_number":"277949","report_state":"HI","report_number":"CS27000233","insp_date":"2022-10-12 00:00:00","insp_start_time":"1205","insp_end_time":"1214","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"3496368","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-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132659","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-14 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:32.000000Z","updated_at":"2025-03-17T18:54:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2443943,"change_date":"2022-10-14 21:39:00","inspection_id":"76880155","insp_unit_id":"191449933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"598477","insp_unit_license":"349TXT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC6NDNU3703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"}]},{"id":1489126,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","dot_number":"277949","report_state":"HI","report_number":"00CK001528","insp_date":"2022-10-10 00:00:00","insp_start_time":"0933","insp_end_time":"1035","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CONSIGENEE: KAHULUI 10\/10\/2022","shipping_paper_number":"3762110355","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"143250","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132613","transaction_code":"C","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-11 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:08.000000Z","updated_at":"2025-03-17T18:54:08.000000Z","inspection_violations":[{"id":2343728,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_violation_id":"249041029","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191449916","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-22-051894","created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"},{"id":2343729,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_violation_id":"249041030","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"191449916","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DTI-22-051895","created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3969D2"},{"id":2343730,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_violation_id":"249041031","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191449916","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3939A"},{"id":2343731,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_violation_id":"249041032","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191449917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3939A"},{"id":2343732,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_violation_id":"249041033","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191449916","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2396562,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_unit_id":"191449916","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"YN04","insp_unit_license":"193TVE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FUNC5DV2FHGE4052","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"},{"id":2396563,"change_date":"2022-10-14 21:39:00","inspection_id":"76846234","insp_unit_id":"191449917","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"PHCZ 450018","insp_unit_license":"TR626A","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"LJRC46273F1007048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:25.000000Z","updated_at":"2025-03-17T22:23:25.000000Z"}]},{"id":1171024,"change_date":"2022-08-30 21:41:00","inspection_id":"76477020","dot_number":"277949","report_state":"HI","report_number":"00CB001312","insp_date":"2022-08-29 00:00:00","insp_start_time":"0852","insp_end_time":"1000","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CONSIGNEE:  Y.HATA & COMPANY, LTD.","shipping_paper_number":"OTPU6346990","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-08-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130450","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":"132369","transaction_code":"A","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-08-30 21:41:00","snet_input_date":"2022-08-30 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-08-30 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1883208,"change_date":"2022-08-30 21:41:00","inspection_id":"76477020","insp_unit_id":"190624827","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"386538","insp_unit_license":"T28372","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV3MSMW0260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"},{"id":1883209,"change_date":"2022-08-30 21:41:00","inspection_id":"76477020","insp_unit_id":"190624828","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMR","insp_unit_company":"PHCZ 400197","insp_unit_license":"TR365B","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"LJRC41261F1007267","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":896066,"change_date":"2022-07-26 21:42:00","inspection_id":"76155847","dot_number":"277949","report_state":"HI","report_number":"00CK001473","insp_date":"2022-07-22 00:00:00","insp_start_time":"0853","insp_end_time":"0931","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CONSIGNEE: Y'HATA & COMPANY","shipping_paper_number":"OTPU6347657","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-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130450","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":"132128","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1412388,"change_date":"2022-07-26 21:42:00","inspection_id":"76155847","insp_violation_id":"247322777","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189972421","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"39311"},{"id":1412389,"change_date":"2022-07-26 21:42:00","inspection_id":"76155847","insp_violation_id":"247322778","seq_no":"2","part_no":"393","part_no_section":"25(a)","insp_viol_unit":"1","insp_unit_id":"189972421","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"39325A"}],"inspection_per_units":[{"id":1442349,"change_date":"2022-07-26 21:42:00","inspection_id":"76155847","insp_unit_id":"189972421","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"386538","insp_unit_license":"T28372","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3AKJHTDV3MSMW0260","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:04.000000Z","updated_at":"2025-03-17T22:17:04.000000Z"},{"id":1442350,"change_date":"2022-07-26 21:42:00","inspection_id":"76155847","insp_unit_id":"189972422","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"PHCZ 400232","insp_unit_license":"TR390C","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"LJRCA126XF1007302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:04.000000Z","updated_at":"2025-03-17T22:17:04.000000Z"}]},{"id":896063,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","dot_number":"277949","report_state":"HI","report_number":"00BY002041","insp_date":"2022-07-13 00:00:00","insp_start_time":"1252","insp_end_time":"1349","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132125","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-26 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1412378,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_violation_id":"247322703","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189972401","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"3965B"},{"id":1412379,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_violation_id":"247322704","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189972401","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"39347E"},{"id":1412380,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_violation_id":"247322705","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189972401","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"39353B"},{"id":1412381,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_violation_id":"247322706","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189972401","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-22-051494","created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"3963A1"},{"id":1412382,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_violation_id":"247322707","seq_no":"5","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"189972401","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-22-051493","created_at":"2025-03-17T21:13:40.000000Z","updated_at":"2025-03-17T21:13:40.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":1442346,"change_date":"2022-07-26 21:42:00","inspection_id":"76155844","insp_unit_id":"189972401","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"103175","insp_unit_license":"T26501","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXDT9FDGE2986","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:04.000000Z","updated_at":"2025-03-17T22:17:04.000000Z"}]},{"id":779082,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","dot_number":"277949","report_state":"HI","report_number":"CT31000141","insp_date":"2022-07-06 00:00:00","insp_start_time":"1325","insp_end_time":"1411","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"ABC STORES","shipping_paper_number":"INV: 3463309","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-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"132056","transaction_code":"A","transaction_date":"2022-07-06 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00277949","upload_search_indicator":null,"census_search_date":"2022-07-08 21:41:00","snet_input_date":"2022-07-08 00:00:00","source_office":"4HIS001","mcmis_add_date":"2022-07-08 21:41:00","insp_carrier_name":"Y HATA & COMPANY LTD","insp_carrier_street":"285 SAND ISLAND ACCESS ROAD","insp_carrier_city":"HONOLULU","insp_carrier_state":"HI","insp_carrier_zip_code":"96819","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:17.000000Z","updated_at":"2025-03-17T18:41:17.000000Z","inspection_violations":[{"id":1231195,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_violation_id":"246977603","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189675517","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39353B"},{"id":1231196,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_violation_id":"246977604","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189675517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39021TB"},{"id":1231197,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_violation_id":"246977605","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189675517","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"},{"id":1231198,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_violation_id":"246977606","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189675517","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1DTI-22-051515","created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3963A1"},{"id":1231199,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_violation_id":"246977607","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189675517","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":1253578,"change_date":"2022-07-08 21:41:00","inspection_id":"76019196","insp_unit_id":"189675517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"187163","insp_unit_license":"T27518","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3ALACXFC7JDJS0798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:53.000000Z","updated_at":"2025-03-17T22:15:53.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/277949\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/277949\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/277949\/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\/277949\/inspections","per_page":100,"prev_page_url":null,"to":46,"total":46}