{"current_page":1,"data":[{"id":7681925,"change_date":"2025-01-29 21:40:00","inspection_id":"83669816","dot_number":"3605377","report_state":"OR","report_number":"AW43690053","insp_date":"2025-01-22 00:00:00","insp_start_time":"1150","insp_end_time":"1203","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HYUNDAI MERCHANT MARINE COMPANY LLC","shipping_paper_number":"DALA05639600","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1276520","transaction_code":"C","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:51.000000Z","updated_at":"2025-03-17T20:57:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12395838,"change_date":"2025-01-29 21:40:00","inspection_id":"83669816","insp_unit_id":"205057954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"204","insp_unit_license":"YAKA451","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:49.000000Z","updated_at":"2025-03-17T23:51:49.000000Z"}]},{"id":7623838,"change_date":"2025-01-15 21:41:00","inspection_id":"83608807","dot_number":"3605377","report_state":"OR","report_number":"AW43320092","insp_date":"2025-01-15 00:00:00","insp_start_time":"0625","insp_end_time":"0720","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NHHAY INC","shipping_paper_number":"EBKG11420009","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1250517","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2025-01-15 21:41:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-15 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:30.000000Z","updated_at":"2025-03-17T20:56:30.000000Z","inspection_violations":[{"id":11917017,"change_date":"2025-01-15 21:41:00","inspection_id":"83608807","insp_violation_id":"264011003","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204843117","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"39617CPI"},{"id":11917018,"change_date":"2025-01-15 21:41:00","inspection_id":"83608807","insp_violation_id":"264011004","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:02.000000Z","updated_at":"2025-03-17T22:04:02.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12301551,"change_date":"2025-01-15 21:41:00","inspection_id":"83608807","insp_unit_id":"204843116","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:47.000000Z","updated_at":"2025-03-17T23:50:47.000000Z"},{"id":12301552,"change_date":"2025-01-15 21:41:00","inspection_id":"83608807","insp_unit_id":"204843117","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CALLAHAN E","insp_unit_company":"NULLNULL","insp_unit_license":"HU44687","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:50:47.000000Z","updated_at":"2025-03-17T23:50:47.000000Z"}]},{"id":7131700,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","dot_number":"3605377","report_state":"OR","report_number":"AP43030229","insp_date":"2024-11-06 00:00:00","insp_start_time":"1235","insp_end_time":"1302","registration_date":null,"region":"PS","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","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-11-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1026502","transaction_code":"A","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-11-06 21:39:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-06 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:41.000000Z","updated_at":"2025-03-17T20:44:41.000000Z","inspection_violations":[{"id":11141267,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","insp_violation_id":"262753862","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203756706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLSR"},{"id":11141268,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","insp_violation_id":"262753863","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"203756706","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"39395A1"},{"id":11141269,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","insp_violation_id":"262753864","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"203756706","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":11502642,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","insp_unit_id":"203756706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"},{"id":11502643,"change_date":"2024-11-06 21:39:00","inspection_id":"83090506","insp_unit_id":"203756707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEHAUF","insp_unit_company":"23T","insp_unit_license":"HQ67594","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1H2P04838TW021823","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:10.000000Z","updated_at":"2025-03-17T23:42:10.000000Z"}]},{"id":7034901,"change_date":"2024-10-24 21:41:00","inspection_id":"82987844","dot_number":"3605377","report_state":"OR","report_number":"AW43710076","insp_date":"2024-10-24 00:00:00","insp_start_time":"1148","insp_end_time":"1210","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","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-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"150000","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":"981499","transaction_code":"A","transaction_date":"2024-10-24 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:40.000000Z","updated_at":"2025-03-17T20:42:40.000000Z","inspection_violations":[{"id":10979988,"change_date":"2024-10-24 21:41:00","inspection_id":"82987844","insp_violation_id":"262533615","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"203565340","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:12.000000Z","updated_at":"2025-03-17T21:59:12.000000Z","normalized_code":"39355EB"},{"id":10979989,"change_date":"2024-10-24 21:41:00","inspection_id":"82987844","insp_violation_id":"262533616","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"203565339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:12.000000Z","updated_at":"2025-03-17T21:59:12.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":11345944,"change_date":"2024-10-24 21:41:00","inspection_id":"82987844","insp_unit_id":"203565339","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"204","insp_unit_license":"YAKA451","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:30.000000Z","updated_at":"2025-03-17T23:40:30.000000Z"},{"id":11345945,"change_date":"2024-10-24 21:41:00","inspection_id":"82987844","insp_unit_id":"203565340","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"HYUNDAI","insp_unit_company":null,"insp_unit_license":"HV81292","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"00000000000000000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:30.000000Z","updated_at":"2025-03-17T23:40:30.000000Z"}]},{"id":6995498,"change_date":"2024-10-20 21:33:00","inspection_id":"82946047","dot_number":"3605377","report_state":"WA","report_number":"2102001376","insp_date":"2024-10-18 00:00:00","insp_start_time":"1005","insp_end_time":"1021","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"127200","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":"963667","transaction_code":"A","transaction_date":"2024-10-20 00:00:00","upload_date":"2024-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-10-20 21:33:00","snet_input_date":"2024-10-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-20 21:33:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:50.000000Z","updated_at":"2025-03-17T20:41:50.000000Z","inspection_violations":[{"id":10915208,"change_date":"2024-10-20 21:33:00","inspection_id":"82946047","insp_violation_id":"262441190","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"203485512","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:55.000000Z","updated_at":"2025-03-17T21:58:55.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":11283351,"change_date":"2024-10-20 21:33:00","inspection_id":"82946047","insp_unit_id":"203485512","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"},{"id":11283352,"change_date":"2024-10-20 21:33:00","inspection_id":"82946047","insp_unit_id":"203485513","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HV90033","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1P9CP5643AB343266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"}]},{"id":6995690,"change_date":"2024-10-21 21:40:00","inspection_id":"82946253","dot_number":"3605377","report_state":"WA","report_number":"2102001377","insp_date":"2024-10-18 00:00:00","insp_start_time":"1023","insp_end_time":"1031","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"126350","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":"964267","transaction_code":"C","transaction_date":"2024-10-20 00:00:00","upload_date":"2024-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-10-20 21:33:00","snet_input_date":"2024-10-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-20 21:33:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:50.000000Z","updated_at":"2025-03-17T20:41:50.000000Z","inspection_violations":[{"id":10915547,"change_date":"2024-10-21 21:40:00","inspection_id":"82946253","insp_violation_id":"262446451","seq_no":"1","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:55.000000Z","updated_at":"2025-03-17T21:58:55.000000Z","normalized_code":"3922SLLSIV"},{"id":10915548,"change_date":"2024-10-21 21:40:00","inspection_id":"82946253","insp_violation_id":"262446452","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"203490017","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:55.000000Z","updated_at":"2025-03-17T21:58:55.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":11283674,"change_date":"2024-10-21 21:40:00","inspection_id":"82946253","insp_unit_id":"203490017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YAKE630","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLD5XFLGG7759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"},{"id":11283675,"change_date":"2024-10-21 21:40:00","inspection_id":"82946253","insp_unit_id":"203490018","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HU44687","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"WA94CSC3A168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"}]},{"id":6959658,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","dot_number":"3605377","report_state":"OR","report_number":"AP08000089","insp_date":"2024-10-15 00:00:00","insp_start_time":"1118","insp_end_time":"1257","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"9","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":"947857","transaction_code":"A","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-10-15 21:42:00","snet_input_date":"2024-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-15 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:04.000000Z","updated_at":"2025-03-17T20:41:04.000000Z","inspection_violations":[{"id":10851696,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351374","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"203411187","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"39345D"},{"id":10851697,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351375","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922"},{"id":10851698,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351376","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203411186","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3922"},{"id":10851699,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351377","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203411186","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3963A1"},{"id":10851700,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351378","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"203411187","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"393207A"},{"id":10851701,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351379","seq_no":"2","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"203411187","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"393207A"},{"id":10851702,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351380","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"203411187","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3939A"},{"id":10851703,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351381","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203411186","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"3963A1"},{"id":10851704,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_violation_id":"262351382","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"203411186","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":11225234,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_unit_id":"203411186","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:14.000000Z","updated_at":"2025-03-17T23:39:14.000000Z"},{"id":11225235,"change_date":"2024-10-15 21:42:00","inspection_id":"82907920","insp_unit_id":"203411187","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"NULLNULL","insp_unit_license":"HR49163","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"NONE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:14.000000Z","updated_at":"2025-03-17T23:39:14.000000Z"}]},{"id":6907584,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","dot_number":"3605377","report_state":"OR","report_number":"AP08000073","insp_date":"2024-10-07 00:00:00","insp_start_time":"1458","insp_end_time":"1625","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"RALPH AND SONS","shipping_paper_number":"T18-1007-52821","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"129000","viol_total":"13","oos_total":"6","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"921844","transaction_code":"A","transaction_date":"2024-10-07 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-10-08 21:40:00","snet_input_date":"2024-10-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-08 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:13.000000Z","updated_at":"2025-03-17T20:40:13.000000Z","inspection_violations":[{"id":10763468,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232790","seq_no":"1","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203307486","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39353B"},{"id":10763469,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232791","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203307486","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10763470,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232792","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10763471,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232793","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39353B"},{"id":10763472,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232794","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10763473,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232795","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10763474,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232796","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"203307486","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39345D"},{"id":10763475,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232797","seq_no":"8","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39345D"},{"id":10763476,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232798","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203307486","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3963A1"},{"id":10763477,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232799","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"39347E"},{"id":10763478,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232800","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3963A1"},{"id":10763479,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232801","seq_no":"12","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3958A1"},{"id":10763480,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_violation_id":"262232802","seq_no":"13","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"203307487","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:09.000000Z","updated_at":"2025-03-17T21:58:09.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11140325,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_unit_id":"203307486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"},{"id":11140326,"change_date":"2024-10-08 21:40:00","inspection_id":"82852555","insp_unit_id":"203307487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEHAUF","insp_unit_company":null,"insp_unit_license":"HV26430","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1H2P04834TW021818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:24.000000Z","updated_at":"2025-03-17T23:38:24.000000Z"}]},{"id":6848463,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","dot_number":"3605377","report_state":"OR","report_number":"AW43710065","insp_date":"2024-09-30 00:00:00","insp_start_time":"0615","insp_end_time":"0658","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-08","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SM LINE CORPORATION","shipping_paper_number":"3701970","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"899457","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-09-30 21:40:00","snet_input_date":"2024-09-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-30 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:00.000000Z","updated_at":"2025-03-17T20:39:00.000000Z","inspection_violations":[{"id":10667401,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095282","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"203186136","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"39375A3"},{"id":10667402,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095283","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"203186135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"39345D"},{"id":10667403,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095284","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203186135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3963A1"},{"id":10667404,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095285","seq_no":"4","part_no":"382","part_no_section":"501(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:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"382501A"},{"id":10667405,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095286","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203186135","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3939A"},{"id":10667406,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_violation_id":"262095287","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203186135","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":11044413,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_unit_id":"203186135","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"25","insp_unit_license":"YAKE633","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X2GJ128753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:21.000000Z","updated_at":"2025-03-17T23:37:21.000000Z"},{"id":11044414,"change_date":"2024-09-30 21:40:00","inspection_id":"82789725","insp_unit_id":"203186136","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"13860","insp_unit_license":"HV90033","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1P9CP5643AB343266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:21.000000Z","updated_at":"2025-03-17T23:37:21.000000Z"}]},{"id":6803949,"change_date":"2024-09-24 21:41:00","inspection_id":"82742542","dot_number":"3605377","report_state":"OR","report_number":"AW43710059","insp_date":"2024-09-23 00:00:00","insp_start_time":"1157","insp_end_time":"1204","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-02","location_desc":"HUBBARD OR","county_code_state":"OR","county_code":"047","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"880123","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-09-24 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:10.000000Z","updated_at":"2025-03-17T20:38:10.000000Z","inspection_violations":[{"id":10595791,"change_date":"2024-09-24 21:41:00","inspection_id":"82742542","insp_violation_id":"261998809","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203097981","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:17.000000Z","updated_at":"2025-03-17T21:57:17.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10971925,"change_date":"2024-09-24 21:41:00","inspection_id":"82742542","insp_unit_id":"203097981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"}]},{"id":6763665,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","dot_number":"3605377","report_state":"WA","report_number":"2133000170","insp_date":"2024-09-17 00:00:00","insp_start_time":"1311","insp_end_time":"1345","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC26","location_desc":"FEDERAL WAY WA","county_code_state":"WA","county_code":"033","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","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":"861128","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"8765 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:18.000000Z","updated_at":"2025-03-17T20:37:18.000000Z","inspection_violations":[{"id":10532932,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910159","seq_no":"1","part_no":"395","part_no_section":"30(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39530B2"},{"id":10532933,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910160","seq_no":"2","part_no":"395","part_no_section":"30(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39530B2"},{"id":10532934,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910161","seq_no":"3","part_no":"395","part_no_section":"30(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39530B2"},{"id":10532935,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910162","seq_no":"4","part_no":"395","part_no_section":"30(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39530B2"},{"id":10532936,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910163","seq_no":"5","part_no":"395","part_no_section":"30(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39530B2"},{"id":10532937,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_violation_id":"261910164","seq_no":"6","part_no":"395","part_no_section":"22(h)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:00.000000Z","updated_at":"2025-03-17T21:57:00.000000Z","normalized_code":"39522H1"}],"inspection_per_units":[{"id":10906679,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_unit_id":"203017910","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"22","insp_unit_license":"YAKE630","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLD5XFLGG7759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:59.000000Z","updated_at":"2025-03-17T23:35:59.000000Z"},{"id":10906680,"change_date":"2024-09-19 21:41:00","inspection_id":"82699273","insp_unit_id":"203017911","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HQ67596","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1H2P04834TW021818","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:59.000000Z","updated_at":"2025-03-17T23:35:59.000000Z"}]},{"id":6569966,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","dot_number":"3605377","report_state":"OR","report_number":"AP07240027","insp_date":"2024-08-26 00:00:00","insp_start_time":"1059","insp_end_time":"1134","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","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-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"129000","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"787428","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-08-27 21:41:00","snet_input_date":"2024-08-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-27 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:11.000000Z","updated_at":"2025-03-17T20:33:11.000000Z","inspection_violations":[{"id":10210868,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425150","seq_no":"1","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"1","insp_unit_id":"202598763","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"393207A"},{"id":10210869,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425151","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39347E"},{"id":10210870,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425152","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39347E"},{"id":10210871,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425153","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39347E"},{"id":10210872,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425154","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3963A1"},{"id":10210873,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425155","seq_no":"6","part_no":"393","part_no_section":"11(b)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39311B"},{"id":10210874,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425156","seq_no":"7","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:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39141A"},{"id":10210875,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425157","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39347E"},{"id":10210876,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425158","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"202598764","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39353B"},{"id":10210877,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_violation_id":"261425159","seq_no":"10","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3953A2"}],"inspection_per_units":[{"id":10592055,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_unit_id":"202598763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"22","insp_unit_license":"YAKE630","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLD5XFLGG7759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:44.000000Z","updated_at":"2025-03-17T23:32:44.000000Z"},{"id":10592056,"change_date":"2024-08-27 21:41:00","inspection_id":"82493080","insp_unit_id":"202598764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FRUEH","insp_unit_company":"NONE","insp_unit_license":"HQ67591","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1H12PO48327102162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:44.000000Z","updated_at":"2025-03-17T23:32:44.000000Z"}]},{"id":6079909,"change_date":"2024-06-26 21:43:00","inspection_id":"81968594","dot_number":"3605377","report_state":"WA","report_number":"2105003834","insp_date":"2024-06-18 00:00:00","insp_start_time":"1445","insp_end_time":"1531","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GRAIN MILLERS INC","shipping_paper_number":"S195876","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":"U","pen_cen_match":"I","final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"603216","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:02.000000Z","updated_at":"2025-03-17T20:23:02.000000Z","inspection_violations":[{"id":9435835,"change_date":"2024-06-26 21:43:00","inspection_id":"81968594","insp_violation_id":"260318916","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3958A1"},{"id":9435836,"change_date":"2024-06-26 21:43:00","inspection_id":"81968594","insp_violation_id":"260318917","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201597483","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9792796,"change_date":"2024-06-26 21:43:00","inspection_id":"81968594","insp_unit_id":"201597483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:25.000000Z","updated_at":"2025-03-17T23:24:25.000000Z"},{"id":9792797,"change_date":"2024-06-26 21:43:00","inspection_id":"81968594","insp_unit_id":"201597484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"293972","insp_unit_license":"PC63679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K9RS209236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:25.000000Z","updated_at":"2025-03-17T23:24:25.000000Z"}]},{"id":6079891,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","dot_number":"3605377","report_state":"WA","report_number":"2103000385","insp_date":"2024-06-17 00:00:00","insp_start_time":"1446","insp_end_time":"1645","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NORWESCO","shipping_paper_number":"W631723","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":"U","pen_cen_match":"I","final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"20","oos_total":"3","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"603168","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:02.000000Z","updated_at":"2025-03-17T20:23:02.000000Z","inspection_violations":[{"id":9435800,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318881","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435801,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318882","seq_no":"2","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39378A"},{"id":9435802,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318883","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435803,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318884","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39345B2"},{"id":9435804,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318885","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3965B"},{"id":9435805,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318886","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3963A1"},{"id":9435806,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318887","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39348A"},{"id":9435807,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318888","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435808,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318889","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435809,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318890","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435810,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318891","seq_no":"11","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"201597450","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39395A1"},{"id":9435811,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318892","seq_no":"12","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39375A3"},{"id":9435812,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318893","seq_no":"13","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3965B"},{"id":9435813,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318894","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3939A"},{"id":9435814,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318895","seq_no":"15","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39355E"},{"id":9435815,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318896","seq_no":"16","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3965B"},{"id":9435816,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318897","seq_no":"17","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3965B"},{"id":9435817,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318898","seq_no":"18","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"201597451","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"39345B2"},{"id":9435818,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318899","seq_no":"19","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"38323A2"},{"id":9435819,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_violation_id":"260318900","seq_no":"20","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:38.000000Z","updated_at":"2025-03-17T21:51:38.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":9792767,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_unit_id":"201597450","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:25.000000Z","updated_at":"2025-03-17T23:24:25.000000Z"},{"id":9792768,"change_date":"2024-06-26 21:43:00","inspection_id":"81968575","insp_unit_id":"201597451","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"5","insp_unit_license":"HV50492","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1JJV532W85L962912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:25.000000Z","updated_at":"2025-03-17T23:24:25.000000Z"}]},{"id":5916187,"change_date":"2024-06-05 21:41:00","inspection_id":"81791421","dot_number":"3605377","report_state":"OR","report_number":"AP43030037","insp_date":"2024-06-05 00:00:00","insp_start_time":"1022","insp_end_time":"1046","registration_date":null,"region":"PD","ci_status_code":"C","location":"24-09","location_desc":"WOODBURN OR","county_code_state":"OR","county_code":"047","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-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"543440","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:52.000000Z","updated_at":"2025-03-17T20:19:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9529049,"change_date":"2024-06-05 21:41:00","inspection_id":"81791421","insp_unit_id":"201240683","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"},{"id":9529050,"change_date":"2024-06-05 21:41:00","inspection_id":"81791421","insp_unit_id":"201240684","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"52","insp_unit_license":"HR49196","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"0R66894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:49.000000Z","updated_at":"2025-03-17T23:21:49.000000Z"}]},{"id":5604211,"change_date":"2024-04-26 21:39:00","inspection_id":"81452488","dot_number":"3605377","report_state":"WA","report_number":"2116000378","insp_date":"2024-04-24 00:00:00","insp_start_time":"2150","insp_end_time":"2240","registration_date":null,"region":"PD","ci_status_code":"C","location":"X861","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ORIENT OVERSEAS CONTAINER LINE","shipping_paper_number":"2735398230","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":"U","pen_cen_match":"I","final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"430922","transaction_code":"A","transaction_date":"2024-04-26 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:51.000000Z","updated_at":"2025-03-17T20:13:51.000000Z","inspection_violations":[{"id":8664978,"change_date":"2024-04-26 21:39:00","inspection_id":"81452488","insp_violation_id":"259159193","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4A0395523","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"},{"id":8664979,"change_date":"2024-04-26 21:39:00","inspection_id":"81452488","insp_violation_id":"259159194","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200590706","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9027172,"change_date":"2024-04-26 21:39:00","inspection_id":"81452488","insp_unit_id":"200590706","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"},{"id":9027173,"change_date":"2024-04-26 21:39:00","inspection_id":"81452488","insp_unit_id":"200590707","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"13860","insp_unit_license":"HV90033","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1P9CP5643AB343266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"}]},{"id":5552181,"change_date":"2024-04-19 21:39:00","inspection_id":"81396008","dot_number":"3605377","report_state":"OR","report_number":"AASS008487","insp_date":"2024-04-18 00:00:00","insp_start_time":"1452","insp_end_time":"1516","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","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":"2024-04-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246982","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-04-19 21:39:00","snet_input_date":"2024-04-19 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-04-19 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T20:12:46.000000Z","updated_at":"2025-03-17T20:12:46.000000Z","inspection_violations":[{"id":8579927,"change_date":"2024-04-19 21:39:00","inspection_id":"81396008","insp_violation_id":"259029734","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200483310","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8943251,"change_date":"2024-04-19 21:39:00","inspection_id":"81396008","insp_unit_id":"200483310","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"204","insp_unit_license":"YAKA451","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:13.000000Z","updated_at":"2025-03-17T23:16:13.000000Z"},{"id":8943252,"change_date":"2024-04-19 21:39:00","inspection_id":"81396008","insp_unit_id":"200483311","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CALL","insp_unit_company":null,"insp_unit_license":"HU44687","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"WA94CSC3A168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:13.000000Z","updated_at":"2025-03-17T23:16:13.000000Z"}]},{"id":5386756,"change_date":"2024-03-28 21:40:00","inspection_id":"81215020","dot_number":"3605377","report_state":"WA","report_number":"2102000542","insp_date":"2024-03-28 00:00:00","insp_start_time":"0729","insp_end_time":"0754","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NHHAY INC","shipping_paper_number":"3700880","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":"U","pen_cen_match":"I","final_status_date":"2024-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132348","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":"353642","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-03-28 21:40:00","snet_input_date":"2024-03-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-28 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:26.000000Z","updated_at":"2025-03-17T20:09:26.000000Z","inspection_violations":[{"id":8313896,"change_date":"2024-03-28 21:40:00","inspection_id":"81215020","insp_violation_id":"258628834","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4A0276192","created_at":"2025-03-17T21:46:13.000000Z","updated_at":"2025-03-17T21:46:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8675577,"change_date":"2024-03-28 21:40:00","inspection_id":"81215020","insp_unit_id":"200129127","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:42.000000Z","updated_at":"2025-03-17T23:13:42.000000Z"},{"id":8675578,"change_date":"2024-03-28 21:40:00","inspection_id":"81215020","insp_unit_id":"200129128","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE TRAILE","insp_unit_company":null,"insp_unit_license":"HU39455","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1A9332691V0074996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:42.000000Z","updated_at":"2025-03-17T23:13:42.000000Z"}]},{"id":5300755,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","dot_number":"3605377","report_state":"WA","report_number":"X848005951","insp_date":"2024-03-14 00:00:00","insp_start_time":"0910","insp_end_time":"1034","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC72","location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2024-03-16 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","viol_total":"12","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":"321332","transaction_code":"A","transaction_date":"2024-03-15 00:00:00","upload_date":"2024-03-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-03-16 21:32:00","snet_input_date":"2024-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-16 21:32:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:51.000000Z","updated_at":"2025-03-17T20:07:51.000000Z","inspection_violations":[{"id":8175320,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420281","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39345DB"},{"id":8175321,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420282","seq_no":"2","part_no":"393","part_no_section":"203E-CBP","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"393203ECBP"},{"id":8175322,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420283","seq_no":"3","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39353BB"},{"id":8175323,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420284","seq_no":"4","part_no":"396","part_no_section":"5A-L","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3965AL"},{"id":8175324,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420285","seq_no":"5","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39330B"},{"id":8175325,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420286","seq_no":"6","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"393203BCBP"},{"id":8175326,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420287","seq_no":"7","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"2","insp_unit_id":"199945807","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3965BL"},{"id":8175327,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420288","seq_no":"8","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"199945807","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39345DB"},{"id":8175328,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420289","seq_no":"9","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39360C"},{"id":8175329,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420290","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"39347E"},{"id":8175330,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420291","seq_no":"11","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3922SLLUCR"},{"id":8175331,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_violation_id":"258420292","seq_no":"12","part_no":"396","part_no_section":"3A1-TFCV","insp_viol_unit":"1","insp_unit_id":"199945806","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:29.000000Z","updated_at":"2025-03-17T21:45:29.000000Z","normalized_code":"3963A1TFCV"}],"inspection_per_units":[{"id":8536402,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_unit_id":"199945806","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"21","insp_unit_license":"YAKE629","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:22.000000Z","updated_at":"2025-03-17T23:12:22.000000Z"},{"id":8536403,"change_date":"2024-03-16 21:32:00","inspection_id":"81121461","insp_unit_id":"199945807","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HU71505","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1D9SC5149DG512431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:22.000000Z","updated_at":"2025-03-17T23:12:22.000000Z"}]},{"id":5148601,"change_date":"2024-02-28 21:41:00","inspection_id":"80955707","dot_number":"3605377","report_state":"WA","report_number":"2085001262","insp_date":"2024-02-27 00:00:00","insp_start_time":"1059","insp_end_time":"1133","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NH HAY INC","shipping_paper_number":"2-26-24","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"274582","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-02-28 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-28 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:33.000000Z","updated_at":"2025-03-17T20:04:33.000000Z","inspection_violations":[{"id":7942028,"change_date":"2024-02-28 21:41:00","inspection_id":"80955707","insp_violation_id":"258074598","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:24.000000Z","updated_at":"2025-03-17T21:44:24.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8289874,"change_date":"2024-02-28 21:41:00","inspection_id":"80955707","insp_unit_id":"199629960","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"YAKE629","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"},{"id":8289875,"change_date":"2024-02-28 21:41:00","inspection_id":"80955707","insp_unit_id":"199629961","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HR49163","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"OR65965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:06.000000Z","updated_at":"2025-03-17T23:10:06.000000Z"}]},{"id":5155019,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","dot_number":"3605377","report_state":"OR","report_number":"AABB002711","insp_date":"2024-02-27 00:00:00","insp_start_time":"1159","insp_end_time":"1400","registration_date":null,"region":"PT","ci_status_code":"C","location":"2499","location_desc":"MARION COUNTY TERMINAL","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"RALPH & SONS TRANSPORTATION LLC","shipping_paper_number":"N\/A","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-02-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"98000","viol_total":"12","oos_total":"10","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243263","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-02-28 21:42:00","snet_input_date":"2024-02-28 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-02-28 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"156951","created_at":"2025-03-17T20:04:35.000000Z","updated_at":"2025-03-17T20:04:35.000000Z","inspection_violations":[{"id":7951381,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088613","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"38323A2"},{"id":7951382,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088614","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3963A1"},{"id":7951383,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088615","seq_no":"3","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393205C"},{"id":7951384,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088616","seq_no":"4","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393205C"},{"id":7951385,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088617","seq_no":"5","part_no":"393","part_no_section":"106(b)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393106B"},{"id":7951386,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088618","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199643657","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3922"},{"id":7951387,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088619","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7951388,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088620","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7951389,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088621","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7951390,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088622","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"3939A"},{"id":7951391,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088623","seq_no":"11","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"199643657","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"39021TA"},{"id":7951392,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_violation_id":"258088624","seq_no":"12","part_no":"393","part_no_section":"106(d)","insp_viol_unit":"2","insp_unit_id":"199643658","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:44:25.000000Z","updated_at":"2025-03-17T21:44:25.000000Z","normalized_code":"393106D"}],"inspection_per_units":[{"id":8300482,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_unit_id":"199643657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":null,"insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XPCDR8X4SD369865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"},{"id":8300483,"change_date":"2024-02-28 21:42:00","inspection_id":"80962738","insp_unit_id":"199643658","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"FRHT","insp_unit_company":"TOWED VEH.","insp_unit_license":"UNKNOWN","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:10:14.000000Z","updated_at":"2025-03-17T23:10:14.000000Z"}]},{"id":5010600,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","dot_number":"3605377","report_state":"OR","report_number":"AAMD000839","insp_date":"2024-02-05 00:00:00","insp_start_time":"1630","insp_end_time":"1707","registration_date":null,"region":"PT","ci_status_code":"C","location":"2077","location_desc":"LANE COUNTY ROADSIDE","county_code_state":"OR","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SELF","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":"2024-02-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1242176","transaction_code":"A","transaction_date":"2024-02-07 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-02-08 21:43:00","snet_input_date":"2024-02-08 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-02-08 21:43:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"156951","created_at":"2025-03-17T20:02:02.000000Z","updated_at":"2025-03-17T20:02:02.000000Z","inspection_violations":[{"id":7718359,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_violation_id":"257741436","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199338631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3922"},{"id":7718360,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_violation_id":"257741437","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199338631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"39021TB"},{"id":7718361,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_violation_id":"257741438","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199338631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3922"},{"id":7718362,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_violation_id":"257741439","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199338631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3922"},{"id":7718363,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_violation_id":"257741440","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199338631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:16.000000Z","updated_at":"2025-03-17T21:43:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8064810,"change_date":"2024-02-08 21:43:00","inspection_id":"80805012","insp_unit_id":"199338631","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YARW587","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP0DR8X4SD369865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:04.000000Z","updated_at":"2025-03-17T23:08:04.000000Z"}]},{"id":4978100,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","dot_number":"3605377","report_state":"OR","report_number":"AAXD006763","insp_date":"2024-02-02 00:00:00","insp_start_time":"1039","insp_end_time":"1306","registration_date":null,"region":"PT","ci_status_code":"C","location":"2408","location_desc":"WOODBURN NB - 2 MI N WOODBURN","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NH-HAY INC","shipping_paper_number":"NAM6697960","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-02-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52350","viol_total":"11","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241895","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-02-05 21:40:00","snet_input_date":"2024-02-05 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-02-05 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T20:01:16.000000Z","updated_at":"2025-03-17T20:01:16.000000Z","inspection_violations":[{"id":7668033,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668099","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39141A1"},{"id":7668034,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668100","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"38323A2"},{"id":7668035,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668101","seq_no":"3","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"37611D1"},{"id":7668036,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668102","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"3922"},{"id":7668037,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668103","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39617C"},{"id":7668038,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668104","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199271121","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39617C"},{"id":7668039,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668105","seq_no":"7","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39360C"},{"id":7668040,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668106","seq_no":"8","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39351"},{"id":7668041,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668107","seq_no":"9","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39381"},{"id":7668042,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668108","seq_no":"10","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39311"},{"id":7668043,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_violation_id":"257668109","seq_no":"11","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"199271120","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:02.000000Z","updated_at":"2025-03-17T21:43:02.000000Z","normalized_code":"39328"}],"inspection_per_units":[{"id":8012108,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_unit_id":"199271120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"YAKF319","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJHHDRXJSHU5729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:38.000000Z","updated_at":"2025-03-17T23:07:38.000000Z"},{"id":8012109,"change_date":"2024-02-05 21:40:00","inspection_id":"80769428","insp_unit_id":"199271121","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"5124","insp_unit_license":"HU65043","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1D9SC5134CG512391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:38.000000Z","updated_at":"2025-03-17T23:07:38.000000Z"}]},{"id":4933628,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","dot_number":"3605377","report_state":"OR","report_number":"AASS008356","insp_date":"2024-01-29 00:00:00","insp_start_time":"1009","insp_end_time":"1042","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","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":"2024-01-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1241448","transaction_code":"A","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-01-30 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-30 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T20:00:29.000000Z","updated_at":"2025-03-17T20:00:29.000000Z","inspection_violations":[{"id":7597854,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","insp_violation_id":"257563610","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199176566","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39360C"},{"id":7597855,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","insp_violation_id":"257563611","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199176566","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"3939A"},{"id":7597856,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","insp_violation_id":"257563612","seq_no":"3","part_no":"393","part_no_section":"70(b)(1)(i)","insp_viol_unit":"1","insp_unit_id":"199176566","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:39.000000Z","updated_at":"2025-03-17T21:42:39.000000Z","normalized_code":"39370B1I"}],"inspection_per_units":[{"id":7939495,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","insp_unit_id":"199176566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"204","insp_unit_license":"YAKA451","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:57.000000Z","updated_at":"2025-03-17T23:06:57.000000Z"},{"id":7939496,"change_date":"2024-01-30 21:42:00","inspection_id":"80720558","insp_unit_id":"199176567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CALL","insp_unit_company":"5111","insp_unit_license":"HU48601","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"WA94CSC3A172","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:57.000000Z","updated_at":"2025-03-17T23:06:57.000000Z"}]},{"id":4895649,"change_date":"2024-01-24 21:45:00","inspection_id":"80679104","dot_number":"3605377","report_state":"OR","report_number":"AASN005590","insp_date":"2024-01-23 00:00:00","insp_start_time":"1154","insp_end_time":"1212","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","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-24 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","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":"1241149","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2024-01-24 21:45:00","snet_input_date":"2024-01-24 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-01-24 21:45:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T19:59:39.000000Z","updated_at":"2025-03-17T19:59:39.000000Z","inspection_violations":[{"id":7542853,"change_date":"2024-01-24 21:45:00","inspection_id":"80679104","insp_violation_id":"257478290","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199094887","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:24.000000Z","updated_at":"2025-03-17T21:42:24.000000Z","normalized_code":"3939A"},{"id":7542854,"change_date":"2024-01-24 21:45:00","inspection_id":"80679104","insp_violation_id":"257478291","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199094888","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:24.000000Z","updated_at":"2025-03-17T21:42:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7877445,"change_date":"2024-01-24 21:45:00","inspection_id":"80679104","insp_unit_id":"199094887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23","insp_unit_license":"YAKE631","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD59FSFP7012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:24.000000Z","updated_at":"2025-03-17T23:06:24.000000Z"},{"id":7877446,"change_date":"2024-01-24 21:45:00","inspection_id":"80679104","insp_unit_id":"199094888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"5127","insp_unit_license":"HU71505","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:06:24.000000Z","updated_at":"2025-03-17T23:06:24.000000Z"}]},{"id":4719123,"change_date":"2023-12-28 21:44:00","inspection_id":"80486199","dot_number":"3605377","report_state":"WA","report_number":"X819005890","insp_date":"2023-12-28 00:00:00","insp_start_time":"1237","insp_end_time":"1309","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2023-12-28 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"80200","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"148296","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-12-28 21:44:00","snet_input_date":"2023-12-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-28 21:44:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:13.000000Z","updated_at":"2025-03-17T19:56:13.000000Z","inspection_violations":[{"id":7289438,"change_date":"2023-12-28 21:44:00","inspection_id":"80486199","insp_violation_id":"257085379","seq_no":"1","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"198700687","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"3939ALSLIWR"},{"id":7289439,"change_date":"2023-12-28 21:44:00","inspection_id":"80486199","insp_violation_id":"257085380","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"198700687","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:12.000000Z","updated_at":"2025-03-17T21:41:12.000000Z","normalized_code":"39375CTAOTDLT1\/32"}],"inspection_per_units":[{"id":7590630,"change_date":"2023-12-28 21:44:00","inspection_id":"80486199","insp_unit_id":"198700686","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"22","insp_unit_license":"YAKE630","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLD5XFLGG7759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:52.000000Z","updated_at":"2025-03-17T23:03:52.000000Z"},{"id":7590631,"change_date":"2023-12-28 21:44:00","inspection_id":"80486199","insp_unit_id":"198700687","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HU39455","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1A9332691V0074996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:52.000000Z","updated_at":"2025-03-17T23:03:52.000000Z"}]},{"id":4437705,"change_date":"2023-11-16 21:42:00","inspection_id":"80177388","dot_number":"3605377","report_state":"WA","report_number":"2085000980","insp_date":"2023-11-03 00:00:00","insp_start_time":"0859","insp_end_time":"0930","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC07","location_desc":"DU PONT WA","county_code_state":"WA","county_code":"053","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NHHAY","shipping_paper_number":"11\/2\/23","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-11-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"99681","transaction_code":"A","transaction_date":"2023-11-16 00:00:00","upload_date":"2023-11-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-11-16 21:42:00","snet_input_date":"2023-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-16 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:45.000000Z","updated_at":"2025-03-17T19:50:45.000000Z","inspection_violations":[{"id":6868481,"change_date":"2023-11-16 21:42:00","inspection_id":"80177388","insp_violation_id":"256425229","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"198086569","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:06.000000Z","updated_at":"2025-03-17T21:39:06.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":7136527,"change_date":"2023-11-16 21:42:00","inspection_id":"80177388","insp_unit_id":"198086569","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"TEMPORARY","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X2GJ128753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"},{"id":7136528,"change_date":"2023-11-16 21:42:00","inspection_id":"80177388","insp_unit_id":"198086570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HR49196","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"0R66894","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:56.000000Z","updated_at":"2025-03-17T22:59:56.000000Z"}]},{"id":3889899,"change_date":"2023-09-01 21:39:00","inspection_id":"79570451","dot_number":"3605377","report_state":"OR","report_number":"AASS008123","insp_date":"2023-08-31 00:00:00","insp_start_time":"1008","insp_end_time":"1025","registration_date":null,"region":"PT","ci_status_code":"C","location":"2409","location_desc":"WOODBURN POE","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NH-HAY INC","shipping_paper_number":"PHX3A9430700","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-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","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":"1232458","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-09-01 21:39:00","snet_input_date":"2023-09-01 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-01 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T19:39:43.000000Z","updated_at":"2025-03-17T19:39:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6254048,"change_date":"2023-09-01 21:39:00","inspection_id":"79570451","insp_unit_id":"196867949","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"204","insp_unit_license":"YAKA451","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"},{"id":6254049,"change_date":"2023-09-01 21:39:00","inspection_id":"79570451","insp_unit_id":"196867950","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"YZY 242","insp_unit_license":"HU39455","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1A9332691V0054996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:32.000000Z","updated_at":"2025-03-17T22:52:32.000000Z"}]},{"id":3516810,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","dot_number":"3605377","report_state":"WA","report_number":"X829006408","insp_date":"2023-07-11 00:00:00","insp_start_time":"0655","insp_end_time":"0804","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"KELSOWA","county_code_state":"WA","county_code":"015","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"YAMASA CORPORATION USA","shipping_paper_number":"ORD024107","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-07-15 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"118351","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"30993","transaction_code":"A","transaction_date":"2023-07-15 00:00:00","upload_date":"2023-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-07-15 21:30:00","snet_input_date":"2023-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-07-15 21:30:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:30.000000Z","updated_at":"2025-03-17T19:32:30.000000Z","inspection_violations":[{"id":5422798,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_violation_id":"254082354","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3958A1HOSP"},{"id":5422799,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_violation_id":"254082355","seq_no":"2","part_no":"395","part_no_section":"8K2-HOSRC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3958K2HOSRC"},{"id":5422800,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_violation_id":"254082356","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"196018655","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"3922SLLUCR"},{"id":5422801,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_violation_id":"254082357","seq_no":"4","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0447625","created_at":"2025-03-17T21:32:12.000000Z","updated_at":"2025-03-17T21:32:12.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":5654866,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_unit_id":"196018655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"YAKA453","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"},{"id":5654867,"change_date":"2023-07-15 21:30:00","inspection_id":"79152917","insp_unit_id":"196018656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALLOY TRAI","insp_unit_company":null,"insp_unit_license":"HQ61410","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1ALSD0284VS970196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:37.000000Z","updated_at":"2025-03-17T22:47:37.000000Z"}]},{"id":3298260,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","dot_number":"3605377","report_state":"WA","report_number":"W819005278","insp_date":"2023-06-08 00:00:00","insp_start_time":"0425","insp_end_time":"0510","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"TUMWATER","county_code_state":"WA","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"AF NURSERIES.","shipping_paper_number":"060823","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"118351","viol_total":"7","oos_total":"3","driver_viol_total":"4","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2577073","transaction_code":"A","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-06-15 21:43:00","snet_input_date":"2023-06-15 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-06-15 21:43:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:11.000000Z","updated_at":"2025-03-17T19:28:11.000000Z","inspection_violations":[{"id":5086656,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539173","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"38323A2"},{"id":5086657,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539174","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3922"},{"id":5086658,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539175","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3922"},{"id":5086659,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539176","seq_no":"4","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3958A1"},{"id":5086660,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539177","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195528590","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"39345D"},{"id":5086661,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539178","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195528591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3939A"},{"id":5086662,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_violation_id":"253539179","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195528591","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:39.000000Z","updated_at":"2025-03-17T21:30:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5303065,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_unit_id":"195528590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"50317","insp_unit_license":"YAKA453","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:50.000000Z","updated_at":"2025-03-17T22:44:50.000000Z"},{"id":5303066,"change_date":"2023-06-15 21:43:00","inspection_id":"78907475","insp_unit_id":"195528591","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"0174","insp_unit_license":"200B533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25385U670816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:50.000000Z","updated_at":"2025-03-17T22:44:50.000000Z"}]},{"id":3242284,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","dot_number":"3605377","report_state":"WA","report_number":"W531004740","insp_date":"2023-06-07 00:00:00","insp_start_time":"1812","insp_end_time":"2010","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"AF NURSERY LLC","shipping_paper_number":"740","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118351","viol_total":"8","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2575727","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-06-08 21:41:00","snet_input_date":"2023-06-08 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-06-08 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:18.000000Z","updated_at":"2025-03-17T19:27:18.000000Z","inspection_violations":[{"id":4998438,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391924","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"38323A2"},{"id":4998439,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391925","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39141A1"},{"id":4998440,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391926","seq_no":"3","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3958"},{"id":4998441,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391927","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"195402900","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39345D"},{"id":4998442,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391928","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195402900","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39378"},{"id":4998443,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391929","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"195402901","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"39345D"},{"id":4998444,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391930","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"195402901","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3965B"},{"id":4998445,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_violation_id":"253391931","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"195402901","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:13.000000Z","updated_at":"2025-03-17T21:30:13.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":5214948,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_unit_id":"195402900","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"50317","insp_unit_license":"YAKA453","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"},{"id":5214949,"change_date":"2023-06-08 21:41:00","inspection_id":"78844053","insp_unit_id":"195402901","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"0174","insp_unit_license":"200B533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25385U670816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:05.000000Z","updated_at":"2025-03-17T22:44:05.000000Z"}]},{"id":3232277,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","dot_number":"3605377","report_state":"WA","report_number":"W538000640","insp_date":"2023-06-05 00:00:00","insp_start_time":"1336","insp_end_time":"1515","registration_date":null,"region":"PT","ci_status_code":"C","location":"50699","location_desc":"I-5 N","county_code_state":"WA","county_code":"011","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"BREW DR KOMBUCHA","shipping_paper_number":"52096816LN","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-06-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115351","viol_total":"12","oos_total":"3","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2575173","transaction_code":"C","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-06-06 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:55.000000Z","updated_at":"2025-03-17T19:26:55.000000Z","inspection_violations":[{"id":4981908,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480897","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195478099","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"},{"id":4981909,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480898","seq_no":"7","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"195478099","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39355E"},{"id":4981910,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480899","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195478098","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"},{"id":4981911,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480900","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195478098","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"},{"id":4981912,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480901","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195478098","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"},{"id":4981913,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480902","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"195478098","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39617C"},{"id":4981914,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480903","seq_no":"12","part_no":"395","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3958"},{"id":4981915,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480904","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"38323A2"},{"id":4981916,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480905","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0393287","created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"},{"id":4981917,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480906","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3A0393287","created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"},{"id":4981918,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480907","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195478098","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"},{"id":4981919,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_violation_id":"253480908","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195478099","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5198474,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_unit_id":"195478098","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"50317","insp_unit_license":"YAKA453","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"},{"id":5198475,"change_date":"2023-06-13 21:42:00","inspection_id":"78832818","insp_unit_id":"195478099","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"200B533","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UYVS25385U670816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:57.000000Z","updated_at":"2025-03-17T22:43:57.000000Z"}]},{"id":2901317,"change_date":"2023-04-26 21:42:00","inspection_id":"78459269","dot_number":"3605377","report_state":"WA","report_number":"W523003299","insp_date":"2023-04-25 00:00:00","insp_start_time":"1102","insp_end_time":"1109","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"SEATTLE-TACOMA BOX COMPANY","shipping_paper_number":"198528","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-04-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2567141","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-04-26 21:42:00","snet_input_date":"2023-04-26 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-04-26 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:23.000000Z","updated_at":"2025-03-17T19:20:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4667843,"change_date":"2023-04-26 21:42:00","inspection_id":"78459269","insp_unit_id":"194606803","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"Q04","insp_unit_license":"YAKA453","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:49.000000Z","updated_at":"2025-03-17T22:39:49.000000Z"},{"id":4667844,"change_date":"2023-04-26 21:42:00","inspection_id":"78459269","insp_unit_id":"194606804","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"7048","insp_unit_license":"HV50492","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1JJV532W85L962912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:49.000000Z","updated_at":"2025-03-17T22:39:49.000000Z"}]},{"id":2750663,"change_date":"2024-01-09 21:43:00","inspection_id":"78288650","dot_number":"3605377","report_state":"OR","report_number":"AABD003883","insp_date":"2023-04-05 00:00:00","insp_start_time":"1047","insp_end_time":"1131","registration_date":"2024-01-09 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":"EMPTY","shipping_paper_number":"N\/A","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-04-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142160","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":"1221993","transaction_code":"C","transaction_date":"2023-04-05 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-04-06 21:40:00","snet_input_date":"2023-04-06 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-04-06 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T19:17:21.000000Z","updated_at":"2025-03-17T19:17:21.000000Z","inspection_violations":[{"id":4222023,"change_date":"2024-01-09 21:43:00","inspection_id":"78288650","insp_violation_id":"257259588","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198883824","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"39617C"},{"id":4222024,"change_date":"2024-01-09 21:43:00","inspection_id":"78288650","insp_violation_id":"257259589","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198883825","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:45.000000Z","updated_at":"2025-03-17T21:26:45.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4427320,"change_date":"2024-01-09 21:43:00","inspection_id":"78288650","insp_unit_id":"198883824","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"Q02","insp_unit_license":"YCDG479","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X2GJ128753","insp_unit_decal":"Y","insp_unit_decal_number":"32706118","created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"},{"id":4427321,"change_date":"2024-01-09 21:43:00","inspection_id":"78288650","insp_unit_id":"198883825","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"YZY 242","insp_unit_license":"HU71505","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":null,"insp_unit_decal":"Y","insp_unit_decal_number":"32706119","created_at":"2025-03-17T22:37:52.000000Z","updated_at":"2025-03-17T22:37:52.000000Z"}]},{"id":2731960,"change_date":"2023-04-04 21:42:00","inspection_id":"78267487","dot_number":"3605377","report_state":"CA","report_number":"N91G003930","insp_date":"2023-03-28 00:00:00","insp_start_time":"1018","insp_end_time":"1032","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FRAGILE PAK","shipping_paper_number":"T230323-00177","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-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14843576","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-04-04 21:42:00","snet_input_date":"2023-03-28 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-04-04 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:59.000000Z","updated_at":"2025-03-17T19:16:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4397930,"change_date":"2023-04-04 21:42:00","inspection_id":"78267487","insp_unit_id":"194225113","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"008\/RED","insp_unit_license":"YCDH291","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD58FSFK4480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"},{"id":4397931,"change_date":"2023-04-04 21:42:00","inspection_id":"78267487","insp_unit_id":"194225114","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"WHI","insp_unit_license":"HV50491","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5V8VC5328CM204773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:37.000000Z","updated_at":"2025-03-17T22:37:37.000000Z"}]},{"id":2649963,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","dot_number":"3605377","report_state":"CA","report_number":"N91G003922","insp_date":"2023-03-23 00:00:00","insp_start_time":"0610","insp_end_time":"0710","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MEGACORP","shipping_paper_number":"1555130","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-03-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"14831002","transaction_code":"A","transaction_date":"2023-03-23 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-03-23 21:43:00","snet_input_date":"2023-03-23 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-23 21:43:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:32.000000Z","updated_at":"2025-03-17T19:15:32.000000Z","inspection_violations":[{"id":4074318,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_violation_id":"251844839","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"194040691","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39347E"},{"id":4074319,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_violation_id":"251844840","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"194040691","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39353B"},{"id":4074320,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_violation_id":"251844841","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"194040691","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"39348A"},{"id":4074321,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_violation_id":"251844842","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"194040691","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:26:04.000000Z","updated_at":"2025-03-17T21:26:04.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4266533,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_unit_id":"194040690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09\/WHI","insp_unit_license":"TEMP","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD53ESFW8014","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"},{"id":4266534,"change_date":"2023-03-23 21:43:00","inspection_id":"78173210","insp_unit_id":"194040691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"HT2504\/WHI","insp_unit_license":"HV50936","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1DW1A5324BS245039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:37.000000Z","updated_at":"2025-03-17T22:36:37.000000Z"}]},{"id":2545380,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","dot_number":"3605377","report_state":"OR","report_number":"AASW003288","insp_date":"2023-03-08 00:00:00","insp_start_time":"1008","insp_end_time":"1029","registration_date":"2024-01-09 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":"POLYMERPAK LLC","shipping_paper_number":"128228","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50351","viol_total":"3","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220394","transaction_code":"C","transaction_date":"2023-03-08 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-03-09 21:42:00","snet_input_date":"2023-03-09 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T19:13:41.000000Z","updated_at":"2025-03-17T19:13:41.000000Z","inspection_violations":[{"id":3914902,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","insp_violation_id":"257259619","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3958A1"},{"id":3914903,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","insp_violation_id":"257259620","seq_no":"2","part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3958K2"},{"id":3914904,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","insp_violation_id":"257259621","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"198883851","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4097076,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","insp_unit_id":"198883851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"Q04","insp_unit_license":"YCDH515","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:22.000000Z","updated_at":"2025-03-17T22:35:22.000000Z"},{"id":4097077,"change_date":"2024-01-09 21:43:00","inspection_id":"78054303","insp_unit_id":"198883852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"700937","insp_unit_license":"862366ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":null,"insp_unit_decal":"Y","insp_unit_decal_number":"32342186","created_at":"2025-03-17T22:35:22.000000Z","updated_at":"2025-03-17T22:35:22.000000Z"}]},{"id":2534023,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","dot_number":"3605377","report_state":"WA","report_number":"W539000273","insp_date":"2023-03-07 00:00:00","insp_start_time":"0405","insp_end_time":"0430","registration_date":null,"region":"PT","ci_status_code":"C","location":"SC72","location_desc":"SC72   RIDGEFIELD (POE)","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"DEL MONTE FOODS INC.","shipping_paper_number":"81446297","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-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2556893","transaction_code":"A","transaction_date":"2023-03-07 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-07 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"19118 CASE RD NE","insp_carrier_city":"AURORA","insp_carrier_state":"OR","insp_carrier_zip_code":"97002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[{"id":3895222,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","insp_violation_id":"251545813","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3895223,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","insp_violation_id":"251545814","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193771674","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"},{"id":3895224,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","insp_violation_id":"251545815","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193771674","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4078883,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","insp_unit_id":"193771674","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"008","insp_unit_license":"YCDH291","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJGLD58FSFK4480","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:13.000000Z","updated_at":"2025-03-17T22:35:13.000000Z"},{"id":4078884,"change_date":"2023-03-08 21:41:00","inspection_id":"78041417","insp_unit_id":"193771675","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"6558","insp_unit_license":"HV50491","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"5V8VC5328CM204773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:13.000000Z","updated_at":"2025-03-17T22:35:13.000000Z"}]},{"id":2505775,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","dot_number":"3605377","report_state":"CA","report_number":"NEL1000657","insp_date":"2023-03-03 00:00:00","insp_start_time":"0918","insp_end_time":"0950","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD IF","county_code_state":"CA","county_code":"103","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VIZIO","shipping_paper_number":"681881","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-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"14806021","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-03 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND RD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3854423,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","insp_violation_id":"251478799","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193707434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3922"},{"id":3854424,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","insp_violation_id":"251478800","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193707434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3963A1"},{"id":3854425,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","insp_violation_id":"251478801","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193707434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:25:05.000000Z","updated_at":"2025-03-17T21:25:05.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":4032441,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","insp_unit_id":"193707434","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"204\/BLU","insp_unit_license":"YCDF191","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJGLDV3DSBT7527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"},{"id":4032442,"change_date":"2023-03-03 21:41:00","inspection_id":"78009341","insp_unit_id":"193707435","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"69\/WHT","insp_unit_license":"HV05705","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1GRAA06223T001041","insp_unit_decal":"Y","insp_unit_decal_number":"32126437","created_at":"2025-03-17T22:34:54.000000Z","updated_at":"2025-03-17T22:34:54.000000Z"}]},{"id":1459869,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","dot_number":"3605377","report_state":"OR","report_number":"AANA000502","insp_date":"2022-10-05 00:00:00","insp_start_time":"0900","insp_end_time":"1004","registration_date":"2022-10-28 00:00:00","region":"PT","ci_status_code":"C","location":"2451","location_desc":"MARION COUNTY PORTABLE","county_code_state":"OR","county_code":"047","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"11","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1211523","transaction_code":"C","transaction_date":"2022-10-05 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2022-10-06 21:40:00","snet_input_date":"2022-10-06 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-10-06 21:40:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND ROAD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T18:53:29.000000Z","updated_at":"2025-03-17T18:53:29.000000Z","inspection_violations":[{"id":2298756,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372458","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"191751163","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39021TB"},{"id":2298757,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372459","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191751163","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2298758,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372460","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191751163","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39353B"},{"id":2298759,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372461","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191751163","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3963A1"},{"id":2298760,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372462","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2298761,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372463","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39353B"},{"id":2298762,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372464","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2298763,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372465","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2298764,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372466","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"39347E"},{"id":2298765,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372467","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191751163","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3963A1"},{"id":2298766,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_violation_id":"249372468","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"191751164","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:30.000000Z","updated_at":"2025-03-17T21:17:30.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2350258,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_unit_id":"191751163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4","insp_unit_license":"YCDG481","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:07.000000Z","updated_at":"2025-03-17T22:23:07.000000Z"},{"id":2350259,"change_date":"2022-11-01 21:40:00","inspection_id":"76812253","insp_unit_id":"191751164","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"DIAS","insp_unit_company":null,"insp_unit_license":"HU71505","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1D9SC5149DG512431","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:07.000000Z","updated_at":"2025-03-17T22:23:07.000000Z"}]},{"id":1008945,"change_date":"2024-01-09 21:43:00","inspection_id":"76287975","dot_number":"3605377","report_state":"OR","report_number":"AAXD006470","insp_date":"2022-08-09 00:00:00","insp_start_time":"0953","insp_end_time":"1032","registration_date":"2024-01-09 00:00:00","region":"PT","ci_status_code":"C","location":"2408","location_desc":"WOODBURN NB - 2 MI N WOODBURN","county_code_state":"OR","county_code":"047","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"NH HAY INC","shipping_paper_number":"2204W","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1207531","transaction_code":"C","transaction_date":"2022-08-09 00:00:00","upload_date":"2024-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2022-08-10 21:39:00","snet_input_date":"2022-08-10 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND ROAD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"156951","created_at":"2025-03-17T18:45:26.000000Z","updated_at":"2025-03-17T18:45:26.000000Z","inspection_violations":[{"id":1588305,"change_date":"2024-01-09 21:43:00","inspection_id":"76287975","insp_violation_id":"257259750","seq_no":"1","part_no":"387","part_no_section":"301(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"387301A"},{"id":1588306,"change_date":"2024-01-09 21:43:00","inspection_id":"76287975","insp_violation_id":"257259751","seq_no":"2","part_no":"387","part_no_section":"303(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"387303B4"}],"inspection_per_units":[{"id":1623175,"change_date":"2024-01-09 21:43:00","inspection_id":"76287975","insp_unit_id":"198884009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"01","insp_unit_license":"YCDF101","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKYP40X5FJ437647","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"},{"id":1623176,"change_date":"2024-01-09 21:43:00","inspection_id":"76287975","insp_unit_id":"198884010","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DIAS","insp_unit_company":"5304","insp_unit_license":"HU35234","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:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"}]},{"id":484000,"change_date":"2022-06-27 21:41:00","inspection_id":"75670305","dot_number":"3605377","report_state":"OR","report_number":"AASZ008061","insp_date":"2022-05-24 00:00:00","insp_start_time":"1502","insp_end_time":"1542","registration_date":"2022-06-27 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":"NONE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"135351","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1203656","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03605377","upload_search_indicator":null,"census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-25 00:00:00","source_office":"4ORS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"RALPH & SONS TRANSPORTATION LLC","insp_carrier_street":"6512 PORTLAND ROAD NE","insp_carrier_city":"SALEM","insp_carrier_state":"OR","insp_carrier_zip_code":"97305","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"156951","created_at":"2025-03-17T18:36:18.000000Z","updated_at":"2025-03-17T18:36:18.000000Z","inspection_violations":[{"id":766449,"change_date":"2022-06-27 21:41:00","inspection_id":"75670305","insp_violation_id":"246734943","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"189478069","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":778417,"change_date":"2022-06-27 21:41:00","inspection_id":"75670305","insp_unit_id":"189478069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"3","insp_unit_license":"YCDG481","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"4V4NC9EH4CN536395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:59.000000Z","updated_at":"2025-03-17T22:12:59.000000Z"},{"id":778418,"change_date":"2022-06-27 21:41:00","inspection_id":"75670305","insp_unit_id":"189478070","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"YZY 242","insp_unit_license":"HU71593","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1D9SC5141EG512537","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:59.000000Z","updated_at":"2025-03-17T22:12:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3605377\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3605377\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3605377\/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\/3605377\/inspections","per_page":100,"prev_page_url":null,"to":42,"total":42}