{"current_page":1,"data":[{"id":9341963,"change_date":"2025-08-06 21:40:00","inspection_id":"85418448","dot_number":"1065177","report_state":"OR","report_number":"AP40270537","insp_date":"2025-08-06 00:00:00","insp_start_time":"0840","insp_end_time":"0918","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KINDER MORGAN","shipping_paper_number":"00004514448","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2093188","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:18.000000Z","updated_at":"2025-08-12T10:42:18.000000Z","inspection_violations":[{"id":15167421,"change_date":"2025-08-06 21:40:00","inspection_id":"85418448","insp_violation_id":"267867186","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"208261920","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:14.000000Z","updated_at":"2025-08-10T10:43:42.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":15388310,"change_date":"2025-08-06 21:40:00","inspection_id":"85418448","insp_unit_id":"208261919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"31","insp_unit_license":"YASI711","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3BKDX40X8NF129975","insp_unit_decal":"Y","insp_unit_decal_number":"35493389","created_at":"2025-08-09T09:46:18.000000Z","updated_at":"2025-08-10T09:45:43.000000Z"},{"id":15388311,"change_date":"2025-08-06 21:40:00","inspection_id":"85418448","insp_unit_id":"208261920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"311","insp_unit_license":"HV50576","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5MATA3241RP074522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:18.000000Z","updated_at":"2025-08-10T09:45:43.000000Z"}]},{"id":8869686,"change_date":"2025-06-11 21:41:00","inspection_id":"84920620","dot_number":"1065177","report_state":"OR","report_number":"AP08040061","insp_date":"2025-06-11 00:00:00","insp_start_time":"0909","insp_end_time":"0942","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"753393","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128219","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":"1851239","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2025-06-11 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-11 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:55.000000Z","updated_at":"2025-06-15T10:00:23.000000Z","inspection_violations":[{"id":14210181,"change_date":"2025-06-11 21:41:00","inspection_id":"84920620","insp_violation_id":"266777952","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"207327693","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:26.000000Z","updated_at":"2025-06-17T10:17:12.000000Z","normalized_code":"3963A1BALAC"}],"inspection_per_units":[{"id":14526315,"change_date":"2025-06-11 21:41:00","inspection_id":"84920620","insp_unit_id":"207327693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"29","insp_unit_license":"YAJD189","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXLR403242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:06.000000Z","updated_at":"2025-06-15T09:45:30.000000Z"},{"id":14526316,"change_date":"2025-06-11 21:41:00","inspection_id":"84920620","insp_unit_id":"207327694","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL TRAN","insp_unit_company":"291","insp_unit_license":"HV31888","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"10BBAA421LP220329","insp_unit_decal":"Y","insp_unit_decal_number":"35220930","created_at":"2025-06-14T09:46:06.000000Z","updated_at":"2025-06-15T09:45:30.000000Z"}]},{"id":8870714,"change_date":"2025-06-11 21:41:00","inspection_id":"84921753","dot_number":"1065177","report_state":"OR","report_number":"AP36700500","insp_date":"2025-06-11 00:00:00","insp_start_time":"1022","insp_end_time":"1044","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KINDER MORGAN WILLBRIDGE","shipping_paper_number":"445541","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"1852339","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2025-06-11 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-11 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:56.000000Z","updated_at":"2025-06-15T10:00:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14527936,"change_date":"2025-06-11 21:41:00","inspection_id":"84921753","insp_unit_id":"207329640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"27","insp_unit_license":"YAIB614","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKZX40X7GJ480970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:07.000000Z","updated_at":"2025-06-15T09:45:36.000000Z"},{"id":14527937,"change_date":"2025-06-11 21:41:00","inspection_id":"84921753","insp_unit_id":"207329641","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"281","insp_unit_license":"HV11338","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"10BEA7424JP003869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:07.000000Z","updated_at":"2025-06-15T09:45:36.000000Z"}]},{"id":8295532,"change_date":"2025-04-04 21:40:00","inspection_id":"84314794","dot_number":"1065177","report_state":"US","report_number":"1983000041","insp_date":"2025-04-01 00:00:00","insp_start_time":"0943","insp_end_time":"1002","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"KINDER MORGAN WILLBRIDGE","shipping_paper_number":"0000437394","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"169000","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":"1555547","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:22:01.000000Z","updated_at":"2025-04-08T10:09:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13449959,"change_date":"2025-04-04 21:40:00","inspection_id":"84314794","insp_unit_id":"206156590","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YASI711","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3BKDX40X8NF129975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:08:58.000000Z","updated_at":"2025-04-08T09:56:05.000000Z"},{"id":13449960,"change_date":"2025-04-04 21:40:00","inspection_id":"84314794","insp_unit_id":"206156591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":null,"insp_unit_license":"HV50576","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5MATA3241RP074522","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:08:58.000000Z","updated_at":"2025-04-08T09:56:05.000000Z"}]},{"id":6284183,"change_date":"2024-10-21 21:40:00","inspection_id":"82187923","dot_number":"1065177","report_state":"OR","report_number":"AP43080063","insp_date":"2024-07-23 00:00:00","insp_start_time":"1203","insp_end_time":"1230","registration_date":null,"region":"PD","ci_status_code":"C","location":"30-05","location_desc":"EMIGRANT HILL OR","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TSO LOGISTICS OPERATIONS LLC","shipping_paper_number":"493023332","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127370","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":"678873","transaction_code":"C","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-07-23 21:41:00","snet_input_date":"2024-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-23 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:22.000000Z","updated_at":"2025-03-17T20:27:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10125468,"change_date":"2024-10-21 21:40:00","inspection_id":"82187923","insp_unit_id":"203495865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"23","insp_unit_license":"YARU412","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40X7BJ292775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:55.000000Z","updated_at":"2025-03-17T23:27:55.000000Z"},{"id":10125469,"change_date":"2024-10-21 21:40:00","inspection_id":"82187923","insp_unit_id":"203495866","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"231","insp_unit_license":"HU61668","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"UNKNOWN","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:55.000000Z","updated_at":"2025-03-17T23:27:55.000000Z"}]},{"id":6280947,"change_date":"2024-07-23 21:41:00","inspection_id":"82184413","dot_number":"1065177","report_state":"OR","report_number":"AP43240090","insp_date":"2024-07-22 00:00:00","insp_start_time":"1144","insp_end_time":"1215","registration_date":null,"region":"PD","ci_status_code":"C","location":"30-05","location_desc":"EMIGRANT HILL OR","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TSO LGSTCS OPERATIONS","shipping_paper_number":"493023267","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"64220","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":"675185","transaction_code":"A","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-07-23 21:41:00","snet_input_date":"2024-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-23 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:21.000000Z","updated_at":"2025-03-17T20:27:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10120107,"change_date":"2024-07-23 21:41:00","inspection_id":"82184413","insp_unit_id":"202011381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"27","insp_unit_license":"YAIB614","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKZX40X7GJ480970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:52.000000Z","updated_at":"2025-03-17T23:27:52.000000Z"},{"id":10120108,"change_date":"2024-07-23 21:41:00","inspection_id":"82184413","insp_unit_id":"202011382","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":null,"insp_unit_license":"HV11338","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"10BEA7424JP003869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:52.000000Z","updated_at":"2025-03-17T23:27:52.000000Z"}]},{"id":5893993,"change_date":"2024-07-23 21:41:00","inspection_id":"81767006","dot_number":"1065177","report_state":"OR","report_number":"AP40270011","insp_date":"2024-05-31 00:00:00","insp_start_time":"0944","insp_end_time":"1002","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KINDER MORGAN","shipping_paper_number":"0000404226","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"107220","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":"534584","transaction_code":"C","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-06-03 21:41:00","snet_input_date":"2024-05-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-03 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9493473,"change_date":"2024-07-23 21:41:00","inspection_id":"81767006","insp_unit_id":"202015267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"31","insp_unit_license":"YASI711","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3BKDX40X8NF129975","insp_unit_decal":"Y","insp_unit_decal_number":"34026407","created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"},{"id":9493474,"change_date":"2024-07-23 21:41:00","inspection_id":"81767006","insp_unit_id":"202015268","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"311","insp_unit_license":"HV50576","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5MATA3241NP070139","insp_unit_decal":"Y","insp_unit_decal_number":"34026408","created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":5893994,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","dot_number":"1065177","report_state":"OR","report_number":"AP40270009","insp_date":"2024-05-31 00:00:00","insp_start_time":"0740","insp_end_time":"0830","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KINDER MORGAN","shipping_paper_number":"0000404207","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122220","viol_total":"10","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"534586","transaction_code":"C","transaction_date":"2024-06-03 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-06-03 21:41:00","snet_input_date":"2024-05-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-03 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:29.000000Z","updated_at":"2025-03-17T20:19:29.000000Z","inspection_violations":[{"id":9138512,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162586","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201460584","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3963A1"},{"id":9138513,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162587","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39348A"},{"id":9138514,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162588","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39347E"},{"id":9138515,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162589","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39347E"},{"id":9138516,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162590","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39345B2"},{"id":9138517,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162591","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201460584","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39345B2"},{"id":9138518,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162592","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39347E"},{"id":9138519,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162593","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39353B"},{"id":9138520,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162594","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"39345B2"},{"id":9138521,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_violation_id":"260162595","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201460585","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:08.000000Z","updated_at":"2025-03-17T21:50:08.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9493475,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_unit_id":"201460584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YARX052","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40X4AJ271591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"},{"id":9493476,"change_date":"2024-06-18 21:42:00","inspection_id":"81767008","insp_unit_id":"201460585","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEALL, INC","insp_unit_company":"211","insp_unit_license":"HU61667","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1BN1T3242BP001683","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:28.000000Z","updated_at":"2025-03-17T23:21:28.000000Z"}]},{"id":5848630,"change_date":"2024-06-18 21:42:00","inspection_id":"81718014","dot_number":"1065177","report_state":"OR","report_number":"AP40270007","insp_date":"2024-05-28 00:00:00","insp_start_time":"1244","insp_end_time":"1318","registration_date":null,"region":"PD","ci_status_code":"C","location":"14-04","location_desc":"CASCADE LOCKS OR","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"KINDER MORGAN","shipping_paper_number":"0000403892","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128220","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":"520977","transaction_code":"C","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:40.000000Z","updated_at":"2025-03-17T20:18:40.000000Z","inspection_violations":[{"id":9066162,"change_date":"2024-06-18 21:42:00","inspection_id":"81718014","insp_violation_id":"260163145","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201460998","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:49:50.000000Z","updated_at":"2025-03-17T21:49:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9419745,"change_date":"2024-06-18 21:42:00","inspection_id":"81718014","insp_unit_id":"201460998","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"29","insp_unit_license":"YAJD189","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXLR403242","insp_unit_decal":"Y","insp_unit_decal_number":"34026391","created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"},{"id":9419746,"change_date":"2024-06-18 21:42:00","inspection_id":"81718014","insp_unit_id":"201460999","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL TRAN","insp_unit_company":"291","insp_unit_license":"HV31888","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"10BBAA421LP220329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:44.000000Z","updated_at":"2025-03-17T23:20:44.000000Z"}]},{"id":5865058,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","dot_number":"1065177","report_state":"WA","report_number":"0813000466","insp_date":"2024-05-23 00:00:00","insp_start_time":"1035","insp_end_time":"1125","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"WALLULA WA","county_code_state":"WA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TSO LGSTCS OPERATIONS","shipping_paper_number":"493020075","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"7","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":"523852","transaction_code":"A","transaction_date":"2024-05-29 00:00:00","upload_date":"2024-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":"2024-05-29 21:41:00","snet_input_date":"2024-05-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-29 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"201 W 1ST","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:03.000000Z","updated_at":"2025-03-17T20:19:03.000000Z","inspection_violations":[{"id":9093504,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783990","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"201130852","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39375C"},{"id":9093505,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783991","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"201130851","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39360D"},{"id":9093506,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783992","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201130851","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"3939A"},{"id":9093507,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783993","seq_no":"4","part_no":"172","part_no_section":"602(c)","insp_viol_unit":"2","insp_unit_id":"201130852","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"172602C"},{"id":9093508,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783994","seq_no":"5","part_no":"178","part_no_section":"345-14(c)","insp_viol_unit":"2","insp_unit_id":"201130852","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"17834514C"},{"id":9093509,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783995","seq_no":"6","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201130852","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39348A"},{"id":9093510,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_violation_id":"259783996","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201130852","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:56.000000Z","updated_at":"2025-03-17T21:49:56.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":9446328,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_unit_id":"201130851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"23","insp_unit_license":"YARU412","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40X7BJ292775","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:00.000000Z","updated_at":"2025-03-17T23:21:00.000000Z"},{"id":9446329,"change_date":"2024-05-29 21:41:00","inspection_id":"81735651","insp_unit_id":"201130852","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEALL TRAN","insp_unit_company":null,"insp_unit_license":"HU61668","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1BN1T3248BP001638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:00.000000Z","updated_at":"2025-03-17T23:21:00.000000Z"}]},{"id":4826324,"change_date":"2024-01-18 21:45:00","inspection_id":"80603294","dot_number":"1065177","report_state":"OR","report_number":"AADF001496","insp_date":"2024-01-11 00:00:00","insp_start_time":"1220","insp_end_time":"1258","registration_date":"2024-01-18 00:00:00","region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"KINDER MORGAN WILLBRIDGE","shipping_paper_number":"0000389347","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":"2024-01-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"64220","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240820","transaction_code":"C","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:58:25.000000Z","updated_at":"2025-03-17T19:58:25.000000Z","inspection_violations":[{"id":7441366,"change_date":"2024-01-18 21:45:00","inspection_id":"80603294","insp_violation_id":"257398261","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"39115A"}],"inspection_per_units":[{"id":7765114,"change_date":"2024-01-18 21:45:00","inspection_id":"80603294","insp_unit_id":"199016786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"YAJD189","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXLR403242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"},{"id":7765115,"change_date":"2024-01-18 21:45:00","inspection_id":"80603294","insp_unit_id":"199016787","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"291","insp_unit_license":"HV31888","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":4063697,"change_date":"2023-09-26 21:43:00","inspection_id":"79763646","dot_number":"1065177","report_state":"OR","report_number":"AASG008627","insp_date":"2023-09-25 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SEAPORT MIDSTREAM PARTNERS","shipping_paper_number":"0225737","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"61200","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":"1234110","transaction_code":"A","transaction_date":"2023-09-25 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-26 21:43:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:43:10.000000Z","updated_at":"2025-03-17T19:43:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6533936,"change_date":"2023-09-26 21:43:00","inspection_id":"79763646","insp_unit_id":"197254784","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"YASI711","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3BKDX40X8NF129975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:49.000000Z","updated_at":"2025-03-17T22:54:49.000000Z"},{"id":6533937,"change_date":"2023-09-26 21:43:00","inspection_id":"79763646","insp_unit_id":"197254785","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"311","insp_unit_license":"HV50576","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:49.000000Z","updated_at":"2025-03-17T22:54:49.000000Z"}]},{"id":4004503,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","dot_number":"1065177","report_state":"OR","report_number":"AADS004083","insp_date":"2023-09-18 00:00:00","insp_start_time":"0738","insp_end_time":"0824","registration_date":"2023-09-25 00:00:00","region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NUSTAR","shipping_paper_number":"93322","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"57370","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233507","transaction_code":"C","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-19 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-19 21:40:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:42:00.000000Z","updated_at":"2025-03-17T19:42:00.000000Z","inspection_violations":[{"id":6195016,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461941","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197220972","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3963A1"},{"id":6195017,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461942","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197220972","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3963A1"},{"id":6195018,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461943","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"197220973","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3963A1"},{"id":6195019,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461944","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"197220973","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"3965B"},{"id":6195020,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461945","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"197220973","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"39347E"},{"id":6195021,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_violation_id":"255461946","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"197220973","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:54.000000Z","updated_at":"2025-03-17T21:35:54.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":6439288,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_unit_id":"197220972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"YASJ808","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXDJ346783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:03.000000Z","updated_at":"2025-03-17T22:54:03.000000Z"},{"id":6439289,"change_date":"2023-09-25 21:41:00","inspection_id":"79697779","insp_unit_id":"197220973","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"241","insp_unit_license":"HU86141","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:03.000000Z","updated_at":"2025-03-17T22:54:03.000000Z"}]},{"id":3985292,"change_date":"2023-09-15 21:40:00","inspection_id":"79676441","dot_number":"1065177","report_state":"OR","report_number":"AADW003665","insp_date":"2023-09-14 00:00:00","insp_start_time":"1310","insp_end_time":"1324","registration_date":null,"region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"BP PRODUCTS NORTH AMERICA","shipping_paper_number":"0007309","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64220","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":"1233256","transaction_code":"A","transaction_date":"2023-09-14 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-15 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6408198,"change_date":"2023-09-15 21:40:00","inspection_id":"79676441","insp_unit_id":"197083457","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"27","insp_unit_license":"YAIB614","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKZX40X7GJ480970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"},{"id":6408199,"change_date":"2023-09-15 21:40:00","inspection_id":"79676441","insp_unit_id":"197083458","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"281","insp_unit_license":"HV11338","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3305703,"change_date":"2023-06-16 21:41:00","inspection_id":"78915984","dot_number":"1065177","report_state":"OR","report_number":"AASE010507","insp_date":"2023-06-15 00:00:00","insp_start_time":"0941","insp_end_time":"0958","registration_date":null,"region":"PT","ci_status_code":"C","location":"2407","location_desc":"HUBBARD NB - 1 MI N HUBBARD","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"66125","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"57370","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":"1227324","transaction_code":"A","transaction_date":"2023-06-15 00:00:00","upload_date":"2023-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-16 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-06-16 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:28:30.000000Z","updated_at":"2025-03-17T19:28:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5314696,"change_date":"2023-06-16 21:41:00","inspection_id":"78915984","insp_unit_id":"195544315","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"24","insp_unit_license":"YASJ808","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXDJ346783","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"},{"id":5314697,"change_date":"2023-06-16 21:41:00","inspection_id":"78915984","insp_unit_id":"195544316","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"241","insp_unit_license":"HU86141","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:54.000000Z","updated_at":"2025-03-17T22:44:54.000000Z"}]},{"id":2788994,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","dot_number":"1065177","report_state":"OR","report_number":"AADW003491","insp_date":"2023-04-11 00:00:00","insp_start_time":"1421","insp_end_time":"1507","registration_date":"2023-04-18 00:00:00","region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"PHILLIPS 66 COMPANY","shipping_paper_number":"654007","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58220","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":"1222343","transaction_code":"C","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-04-12 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:18:04.000000Z","updated_at":"2025-03-17T19:18:04.000000Z","inspection_violations":[{"id":4279102,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_violation_id":"252289502","seq_no":"2","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"194450070","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39348A"},{"id":4279103,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_violation_id":"252289503","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194450071","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39348A"},{"id":4279104,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_violation_id":"252289504","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194450071","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39347E"},{"id":4279105,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_violation_id":"252289505","seq_no":"6","part_no":"393","part_no_section":"70","insp_viol_unit":"2","insp_unit_id":"194450071","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:26:58.000000Z","updated_at":"2025-03-17T21:26:58.000000Z","normalized_code":"39370"}],"inspection_per_units":[{"id":4489108,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_unit_id":"194450070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"21","insp_unit_license":"YARX052","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40X4AJ271591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"},{"id":4489109,"change_date":"2023-04-18 21:42:00","inspection_id":"78331802","insp_unit_id":"194450071","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"211","insp_unit_license":"H61667","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:23.000000Z","updated_at":"2025-03-17T22:38:23.000000Z"}]},{"id":2424548,"change_date":"2023-02-22 21:40:00","inspection_id":"77917236","dot_number":"1065177","report_state":"OR","report_number":"AADW003434","insp_date":"2023-02-21 00:00:00","insp_start_time":"0910","insp_end_time":"0931","registration_date":null,"region":"PT","ci_status_code":"C","location":"1404","location_desc":"CASCADE LOCKS POE","county_code_state":"OR","county_code":"027","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"MARATHON PETROLEUM COMPANY  LP","shipping_paper_number":"354498","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64220","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":"1219098","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-22 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3902421,"change_date":"2023-02-22 21:40:00","inspection_id":"77917236","insp_unit_id":"193523747","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"YASJ565","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXER411859","insp_unit_decal":"Y","insp_unit_decal_number":"32342444","created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"},{"id":3902422,"change_date":"2023-02-22 21:40:00","inspection_id":"77917236","insp_unit_id":"193523748","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"261","insp_unit_license":"HU73373","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"Y","insp_unit_decal_number":"32342445","created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"}]},{"id":1904907,"change_date":"2022-12-08 21:41:00","inspection_id":"77323026","dot_number":"1065177","report_state":"OR","report_number":"AANV000154","insp_date":"2022-12-07 00:00:00","insp_start_time":"1417","insp_end_time":"1430","registration_date":null,"region":"PT","ci_status_code":"C","location":"2451","location_desc":"HW 22 MP 23","county_code_state":"OR","county_code":"047","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"104000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1215081","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-08 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T19:01:50.000000Z","updated_at":"2025-03-17T19:01:50.000000Z","inspection_violations":[{"id":2962897,"change_date":"2022-12-08 21:41:00","inspection_id":"77323026","insp_violation_id":"250000083","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3065777,"change_date":"2022-12-08 21:41:00","inspection_id":"77323026","insp_unit_id":"192334628","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"YASJ565","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXER411859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"},{"id":3065778,"change_date":"2022-12-08 21:41:00","inspection_id":"77323026","insp_unit_id":"192334629","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEAT","insp_unit_company":null,"insp_unit_license":"HU73373","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"}]},{"id":1605796,"change_date":"2022-10-26 21:39:00","inspection_id":"76980422","dot_number":"1065177","report_state":"WA","report_number":"W326003840","insp_date":"2022-10-25 00:00:00","insp_start_time":"0535","insp_end_time":"0615","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"E\/B 12","county_code_state":"WA","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SINCLAIR OIL COMPANY","shipping_paper_number":"98006","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-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"2530255","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-26 00:00:00","source_office":"4WAS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:17.000000Z","updated_at":"2025-03-17T18:56:17.000000Z","inspection_violations":[{"id":2524152,"change_date":"2022-10-26 21:39:00","inspection_id":"76980422","insp_violation_id":"249266327","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"191654240","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39345D"},{"id":2524153,"change_date":"2022-10-26 21:39:00","inspection_id":"76980422","insp_violation_id":"249266328","seq_no":"2","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"2","insp_unit_id":"191654241","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":2584088,"change_date":"2022-10-26 21:39:00","inspection_id":"76980422","insp_unit_id":"191654240","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"YAJI639","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKZX40X7LJ385156","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"},{"id":2584089,"change_date":"2022-10-26 21:39:00","inspection_id":"76980422","insp_unit_id":"191654241","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAL","insp_unit_company":"301","insp_unit_license":"HV62855","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"10BBAA210MP232158","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"}]},{"id":490613,"change_date":"2022-05-26 21:42:00","inspection_id":"75678304","dot_number":"1065177","report_state":"OR","report_number":"AAHT008481","insp_date":"2022-05-24 00:00:00","insp_start_time":"1210","insp_end_time":"1226","registration_date":null,"region":"PT","ci_status_code":"C","location":"1603","location_desc":"JUNIPER BUTTE NB","county_code_state":"OR","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SEAPORT MIDSTREAM","shipping_paper_number":"0174259","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-26 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":"1203702","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01065177","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-26 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"HATTENHAUER TRANSPORTATION LLC","insp_carrier_street":"PO BOX 1397","insp_carrier_city":"THE DALLES","insp_carrier_state":"OR","insp_carrier_zip_code":"97058","insp_colonia":null,"docket_number":"449011","insp_interstate":"Y","insp_carrier_state_id":"297300","created_at":"2025-03-17T18:36:20.000000Z","updated_at":"2025-03-17T18:36:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":788980,"change_date":"2022-05-26 21:42:00","inspection_id":"75678304","insp_unit_id":"188932754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"YASJ565","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1NKDX40XXER411859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"},{"id":788981,"change_date":"2022-05-26 21:42:00","inspection_id":"75678304","insp_unit_id":"188932755","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BEAT","insp_unit_company":"261","insp_unit_license":"HU73373","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"}]}],"first_page_url":"https:\/\/www.searchcarriers.com\/company\/1065177\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/www.searchcarriers.com\/company\/1065177\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/www.searchcarriers.com\/company\/1065177\/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\/1065177\/inspections","per_page":100,"prev_page_url":null,"to":20,"total":20}