{"current_page":1,"data":[{"id":12119838,"change_date":"2026-06-07 21:34:00","inspection_id":"88065266","dot_number":"3326192","report_state":"HI","report_number":"BP16003614","insp_date":"2026-06-05 00:00:00","insp_start_time":"1026","insp_end_time":"1044","registration_date":null,"region":"HS","ci_status_code":"C","location":"16","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"3486029","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-10T09:39:59.000000Z","updated_at":"2026-06-12T09:38:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21056719,"change_date":"2026-06-07 21:34:00","inspection_id":"88065266","insp_unit_id":"213955961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"138TWG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKDDB0X07R142518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:48.000000Z","updated_at":"2026-06-12T09:13:52.000000Z"}]},{"id":10903891,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","dot_number":"3326192","report_state":"HI","report_number":"BY39002950","insp_date":"2026-01-30 00:00:00","insp_start_time":"0907","insp_end_time":"1015","registration_date":"2026-02-16 00:00:00","region":"HS","ci_status_code":"C","location":"105","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"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-02-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2837599","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2026-02-02 21:38:00","snet_input_date":"2026-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-02 21:38:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-05T10:35:40.000000Z","updated_at":"2026-04-03T09:30:29.000000Z","inspection_violations":[{"id":19315016,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551877","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"3922SLLSR"},{"id":19315017,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551878","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"39345DB"},{"id":19315018,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551879","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"39345DB"},{"id":19315019,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551880","seq_no":"4","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":19315020,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551881","seq_no":"5","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"3939AHLLH"},{"id":19315021,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551882","seq_no":"6","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"3939ALLPL"},{"id":19315022,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551883","seq_no":"7","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"3922SLLSR"},{"id":19315023,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_violation_id":"272551884","seq_no":"8","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"1","insp_unit_id":"212264578","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:47.000000Z","updated_at":"2026-04-03T09:47:14.000000Z","normalized_code":"393201AFRCLS"}],"inspection_per_units":[{"id":19596878,"change_date":"2026-03-23 21:50:00","inspection_id":"86935476","insp_unit_id":"212264578","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"31","insp_unit_license":"652TWT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX1LR410303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:32.000000Z","updated_at":"2026-04-03T09:03:52.000000Z"}]},{"id":10304013,"change_date":"2025-11-28 21:33:00","inspection_id":"86429920","dot_number":"3326192","report_state":"HI","report_number":"BP16003477","insp_date":"2025-11-25 00:00:00","insp_start_time":"1358","insp_end_time":"1409","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":"MATU3710090","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-28 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"158300","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":"2596897","transaction_code":"A","transaction_date":"2025-11-27 00:00:00","upload_date":"2025-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2025-11-28 21:33:00","snet_input_date":"2025-11-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-28 21:33:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-01T10:30:31.000000Z","updated_at":"2025-12-02T10:30:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17206010,"change_date":"2025-11-28 21:33:00","inspection_id":"86429920","insp_unit_id":"210298822","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"35","insp_unit_license":"557TYJ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKZP4TX0TJ215948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-01T10:00:33.000000Z","updated_at":"2025-12-02T10:00:22.000000Z"},{"id":17206011,"change_date":"2025-11-28 21:33:00","inspection_id":"86429920","insp_unit_id":"210298823","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"MATZ912744","insp_unit_license":"TR649E","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"3H3C402KXRJ095410","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-01T10:00:33.000000Z","updated_at":"2025-12-02T10:00:22.000000Z"}]},{"id":9331976,"change_date":"2025-08-05 21:38:00","inspection_id":"85407927","dot_number":"3326192","report_state":"HI","report_number":"CK46002358","insp_date":"2025-08-04 00:00:00","insp_start_time":"0846","insp_end_time":"0910","registration_date":null,"region":"HS","ci_status_code":"C","location":"16","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-05 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"2087813","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2025-08-05 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-05 21:38:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-08T10:01:16.000000Z","updated_at":"2025-08-12T10:41:28.000000Z","inspection_violations":[{"id":15146160,"change_date":"2025-08-05 21:38:00","inspection_id":"85407927","insp_violation_id":"267844547","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"208242010","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:47.000000Z","updated_at":"2025-08-09T10:44:13.000000Z","normalized_code":"3939AHLLH"},{"id":15146161,"change_date":"2025-08-05 21:38:00","inspection_id":"85407927","insp_violation_id":"267844548","seq_no":"2","part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"208242010","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-08T10:44:47.000000Z","updated_at":"2025-08-09T10:44:13.000000Z","normalized_code":"3939ALBL"}],"inspection_per_units":[{"id":15369220,"change_date":"2025-08-05 21:38:00","inspection_id":"85407927","insp_unit_id":"208242010","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"138TWG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKDDB0X07R142518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-08T09:46:31.000000Z","updated_at":"2025-08-09T09:45:35.000000Z"}]},{"id":8486279,"change_date":"2025-07-21 21:40:00","inspection_id":"84515565","dot_number":"3326192","report_state":"HI","report_number":"CP19001152","insp_date":"2025-04-24 00:00:00","insp_start_time":"0839","insp_end_time":"0921","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":"2025-04-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"88751","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":"1642986","transaction_code":"C","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:26.000000Z","updated_at":"2025-07-25T10:45:09.000000Z","inspection_violations":[{"id":14860832,"change_date":"2025-07-21 21:40:00","inspection_id":"84515565","insp_violation_id":"267528205","seq_no":"1","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"207976001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:30.000000Z","updated_at":"2025-07-25T10:46:30.000000Z","normalized_code":"39311A1LRR"},{"id":14860833,"change_date":"2025-07-21 21:40:00","inspection_id":"84515565","insp_violation_id":"267528206","seq_no":"2","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"207976001","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:30.000000Z","updated_at":"2025-07-25T10:46:30.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":15117863,"change_date":"2025-07-21 21:40:00","inspection_id":"84515565","insp_unit_id":"207976001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"29","insp_unit_license":"010TYG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX8KR285623","insp_unit_decal":"Y","insp_unit_decal_number":"35282865","created_at":"2025-07-24T09:45:21.000000Z","updated_at":"2025-07-25T09:45:08.000000Z"}]},{"id":8485856,"change_date":"2025-04-29 21:48:00","inspection_id":"84515127","dot_number":"3326192","report_state":"HI","report_number":"CK46002255","insp_date":"2025-04-21 00:00:00","insp_start_time":"1240","insp_end_time":"1317","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":"CONSIGNEE: B&C TRUCKING CO LTD","shipping_paper_number":"1638963","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-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","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":"1642424","transaction_code":"A","transaction_date":"2025-04-25 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2025-04-29 21:48:00","snet_input_date":"2025-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-29 21:48:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T10:26:26.000000Z","updated_at":"2025-05-02T13:48:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13791394,"change_date":"2025-04-29 21:48:00","inspection_id":"84515127","insp_unit_id":"206523675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"31","insp_unit_license":"652TWT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX1LR410303","insp_unit_decal":"Y","insp_unit_decal_number":"35282848","created_at":"2025-05-02T10:07:42.000000Z","updated_at":"2025-05-03T09:58:22.000000Z"}]},{"id":7735366,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","dot_number":"3326192","report_state":"HI","report_number":"CT31000916","insp_date":"2025-01-28 00:00:00","insp_start_time":"0930","insp_end_time":"1009","registration_date":"2025-02-04 00:00:00","region":"HS","ci_status_code":"C","location":"109","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"IDEAL INNOVATIONS","shipping_paper_number":"1625843","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-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"90500","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":"1300114","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2025-01-29 21:40:00","snet_input_date":"2025-01-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-29 21:40:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:44.000000Z","updated_at":"2025-10-08T10:01:23.000000Z","inspection_violations":[{"id":16229583,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","insp_violation_id":"269094099","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"209295438","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"3965BL"},{"id":16229584,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","insp_violation_id":"269094100","seq_no":"2","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"209295438","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"39345DB"},{"id":16229585,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","insp_violation_id":"269094101","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209295438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"3939ALIL"},{"id":16229586,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","insp_violation_id":"269094102","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"209295438","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:27.000000Z","updated_at":"2025-10-08T10:17:27.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":16341597,"change_date":"2025-10-04 21:33:00","inspection_id":"83725748","insp_unit_id":"209295438","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"24","insp_unit_license":"069TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TXXGR495177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:42.000000Z","updated_at":"2025-10-08T09:46:42.000000Z"}]},{"id":6725509,"change_date":"2024-09-14 21:32:00","inspection_id":"82658682","dot_number":"3326192","report_state":"HI","report_number":"CQ41000404","insp_date":"2024-09-13 00:00:00","insp_start_time":"0932","insp_end_time":"1018","registration_date":null,"region":"HS","ci_status_code":"C","location":"13","location_desc":"WAIPAHU HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-14 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"155800","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"845065","transaction_code":"A","transaction_date":"2024-09-14 00:00:00","upload_date":"2024-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2024-09-14 21:32:00","snet_input_date":"2024-09-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-14 21:32:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:30.000000Z","updated_at":"2025-03-17T20:36:30.000000Z","inspection_violations":[{"id":10471289,"change_date":"2024-09-14 21:32:00","inspection_id":"82658682","insp_violation_id":"261800223","seq_no":"1","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"202921999","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39395A1"},{"id":10471290,"change_date":"2024-09-14 21:32:00","inspection_id":"82658682","insp_violation_id":"261800224","seq_no":"2","part_no":"393","part_no_section":"87(a)","insp_viol_unit":"2","insp_unit_id":"202922000","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39387A"}],"inspection_per_units":[{"id":10844657,"change_date":"2024-09-14 21:32:00","inspection_id":"82658682","insp_unit_id":"202921999","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"138TWG","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1XKDDB0X07R142518","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"},{"id":10844658,"change_date":"2024-09-14 21:32:00","inspection_id":"82658682","insp_unit_id":"202922000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"052WEC","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1TKA04824WM064120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:16.000000Z","updated_at":"2025-03-17T23:35:16.000000Z"}]},{"id":6559332,"change_date":"2024-08-26 21:41:00","inspection_id":"82481824","dot_number":"3326192","report_state":"HI","report_number":"CS27000770","insp_date":"2024-08-23 00:00:00","insp_start_time":"1241","insp_end_time":"1253","registration_date":null,"region":"HS","ci_status_code":"C","location":"108","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":"2024-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"784555","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-08-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:50.000000Z","updated_at":"2025-03-17T20:32:50.000000Z","inspection_violations":[{"id":10192533,"change_date":"2024-08-26 21:41:00","inspection_id":"82481824","insp_violation_id":"261398897","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10574640,"change_date":"2024-08-26 21:41:00","inspection_id":"82481824","insp_unit_id":"202577009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"22","insp_unit_license":"340TWV","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1FDUF4GT5LDA02570","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"}]},{"id":5707204,"change_date":"2024-05-09 21:42:00","inspection_id":"81564659","dot_number":"3326192","report_state":"HI","report_number":"CU42000398","insp_date":"2024-05-08 00:00:00","insp_start_time":"1315","insp_end_time":"1326","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-05-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"90500","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":"468894","transaction_code":"A","transaction_date":"2024-05-09 00:00:00","upload_date":"2024-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2024-05-09 21:42:00","snet_input_date":"2024-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-09 21:42:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:53.000000Z","updated_at":"2025-03-17T20:15:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9192504,"change_date":"2024-05-09 21:42:00","inspection_id":"81564659","insp_unit_id":"200806107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"24","insp_unit_license":"069TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TXXGR495177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:33.000000Z","updated_at":"2025-03-17T23:18:33.000000Z"}]},{"id":4821044,"change_date":"2024-01-12 21:42:00","inspection_id":"80597487","dot_number":"3326192","report_state":"HI","report_number":"BY39002352","insp_date":"2024-01-11 00:00:00","insp_start_time":"1054","insp_end_time":"1111","registration_date":null,"region":"HS","ci_status_code":"C","location":"108","location_desc":"KAPOLEI HI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":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-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"88751","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":"173712","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2024-01-12 21:42:00","snet_input_date":"2024-01-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-01-12 21:42:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"1730 KITTY HAWK STREET","insp_carrier_city":"KAPOLEI","insp_carrier_state":"HI","insp_carrier_zip_code":"96707","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:24.000000Z","updated_at":"2025-03-17T19:58:24.000000Z","inspection_violations":[{"id":7434443,"change_date":"2024-01-12 21:42:00","inspection_id":"80597487","insp_violation_id":"257313998","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"198936302","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:52.000000Z","updated_at":"2025-03-17T21:41:52.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":7756604,"change_date":"2024-01-12 21:42:00","inspection_id":"80597487","insp_unit_id":"198936302","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"29","insp_unit_license":"481TWE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX8KR285623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:20.000000Z","updated_at":"2025-03-17T23:05:20.000000Z"}]},{"id":3935053,"change_date":"2023-09-08 21:41:00","inspection_id":"79620748","dot_number":"3326192","report_state":"HI","report_number":"00CK001809","insp_date":"2023-09-06 00:00:00","insp_start_time":"0838","insp_end_time":"0901","registration_date":null,"region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"88790","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":"134843","transaction_code":"A","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2023-09-08 21:41:00","snet_input_date":"2023-09-08 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6327382,"change_date":"2023-09-08 21:41:00","inspection_id":"79620748","insp_unit_id":"196970354","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"907TVY","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX3HJ174940","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3869454,"change_date":"2023-08-30 21:45:00","inspection_id":"79547672","dot_number":"3326192","report_state":"HI","report_number":"CT31000498","insp_date":"2023-08-29 00:00:00","insp_start_time":"1232","insp_end_time":"1244","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-30 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"90500","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":"134748","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2023-08-30 21:45:00","snet_input_date":"2023-08-30 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-08-30 21:45:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:22.000000Z","updated_at":"2025-03-17T19:39:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6220871,"change_date":"2023-08-30 21:45:00","inspection_id":"79547672","insp_unit_id":"196821364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"069TXZ","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TXXGR495177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:16.000000Z","updated_at":"2025-03-17T22:52:16.000000Z"}]},{"id":3757376,"change_date":"2023-08-16 21:39:00","inspection_id":"79422236","dot_number":"3326192","report_state":"HI","report_number":"CT31000475","insp_date":"2023-08-15 00:00:00","insp_start_time":"1007","insp_end_time":"1017","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":"88000","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":"134591","transaction_code":"A","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","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":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","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":6041762,"change_date":"2023-08-16 21:39:00","inspection_id":"79422236","insp_unit_id":"196563990","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"654TWT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX3LR410304","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":3757367,"change_date":"2023-08-16 21:39:00","inspection_id":"79422227","dot_number":"3326192","report_state":"HI","report_number":"CT31000466","insp_date":"2023-08-08 00:00:00","insp_start_time":"1317","insp_end_time":"1339","registration_date":null,"region":"HT","ci_status_code":"C","location":"03","location_desc":"SAND ISLAND - F","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"88000","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":"134583","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","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":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","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":6041750,"change_date":"2023-08-16 21:39:00","inspection_id":"79422227","insp_unit_id":"196563978","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"653TWT","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TXXLR410302","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":3132624,"change_date":"2023-06-09 21:40:00","inspection_id":"78720175","dot_number":"3326192","report_state":"HI","report_number":"CP19000605","insp_date":"2023-05-23 00:00:00","insp_start_time":"1304","insp_end_time":"1334","registration_date":"2023-05-26 00:00:00","region":"HT","ci_status_code":"C","location":"02","location_desc":"CAMPBELL IND PARK & KAPOLEI","county_code_state":"HI","county_code":"003","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"88740","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":"134023","transaction_code":"C","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2023-05-24 21:40:00","snet_input_date":"2023-05-24 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-05-24 21:40:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4822093,"change_date":"2023-06-09 21:40:00","inspection_id":"78720175","insp_violation_id":"253411239","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195419110","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"},{"id":4822094,"change_date":"2023-06-09 21:40:00","inspection_id":"78720175","insp_violation_id":"253411240","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195419110","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39311"},{"id":4822095,"change_date":"2023-06-09 21:40:00","inspection_id":"78720175","insp_violation_id":"253411241","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"195419110","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":5038558,"change_date":"2023-06-09 21:40:00","inspection_id":"78720175","insp_unit_id":"195419110","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"25","insp_unit_license":"906TVY","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4X7HJ174939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:43.000000Z","updated_at":"2025-03-17T22:42:43.000000Z"}]},{"id":2267028,"change_date":"2023-06-09 21:40:00","inspection_id":"77737403","dot_number":"3326192","report_state":"HI","report_number":"00CK001634","insp_date":"2023-01-30 00:00:00","insp_start_time":"0851","insp_end_time":"0900","registration_date":"2023-05-26 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":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"88751","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":"133350","transaction_code":"C","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03326192","upload_search_indicator":null,"census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-31 00:00:00","source_office":"4HIS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"IDEAL INNOVATION LLC","insp_carrier_street":"P O BOX 1137","insp_carrier_city":"PEARL CITY","insp_carrier_state":"HI","insp_carrier_zip_code":"96782","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3497925,"change_date":"2023-06-09 21:40:00","inspection_id":"77737403","insp_violation_id":"253411211","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195419090","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3922"},{"id":3497926,"change_date":"2023-06-09 21:40:00","inspection_id":"77737403","insp_violation_id":"253411212","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195419090","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":3649314,"change_date":"2023-06-09 21:40:00","inspection_id":"77737403","insp_unit_id":"195419090","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"481TWE","insp_unit_license_state":"HI","insp_unit_vehicle_id_number":"1NKDX4TX8KR285623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:09.000000Z","updated_at":"2025-03-17T22:32:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3326192\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3326192\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3326192\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/3326192\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}