{"current_page":1,"data":[{"id":8304856,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","dot_number":"3947223","report_state":"MT","report_number":"U689800715","insp_date":"2025-04-02 00:00:00","insp_start_time":"1325","insp_end_time":"1452","registration_date":null,"region":"MD","ci_status_code":"C","location":"BUTTE","location_desc":"BUTTE MT","county_code_state":"MT","county_code":"093","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GALLJATIN GROWN FARMS","shipping_paper_number":"2059","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":"U","pen_cen_match":"I","final_status_date":"2025-04-06 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"125200","viol_total":"7","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":"1560206","transaction_code":"A","transaction_date":"2025-04-06 00:00:00","upload_date":"2025-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2025-04-06 21:33:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-06 21:33:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-09T10:01:01.000000Z","updated_at":"2025-04-11T10:09:59.000000Z","inspection_violations":[{"id":13060503,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461806","seq_no":"1","part_no":"392","part_no_section":"15","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-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"39215"},{"id":13060504,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461807","seq_no":"2","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"530 A189154 M","created_at":"2025-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"39216AD"},{"id":13060505,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461808","seq_no":"3","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"206174143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"3939AHLLH"},{"id":13060506,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461809","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"206174143","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"39345DB"},{"id":13060507,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461810","seq_no":"5","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"206174144","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"3939ALSLIWR"},{"id":13060508,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461811","seq_no":"6","part_no":"383","part_no_section":"21","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-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"38321"},{"id":13060509,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_violation_id":"265461812","seq_no":"7","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"206174143","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"530 A189163 M","created_at":"2025-04-09T10:19:26.000000Z","updated_at":"2025-04-10T10:21:35.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":13465651,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_unit_id":"206174143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"534","insp_unit_license":"YAJX954","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CK34LM82994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-09T09:50:21.000000Z","updated_at":"2025-04-10T09:51:37.000000Z"},{"id":13465652,"change_date":"2025-04-06 21:33:00","inspection_id":"84324652","insp_unit_id":"206174144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"422","insp_unit_license":"HV97842","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5349SB656291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-09T09:50:21.000000Z","updated_at":"2025-04-10T09:51:37.000000Z"}]},{"id":8149236,"change_date":"2025-03-19 21:40:00","inspection_id":"84160771","dot_number":"3947223","report_state":"WA","report_number":"X805006859","insp_date":"2025-03-17 00:00:00","insp_start_time":"1428","insp_end_time":"1455","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"STARKEL SEED POTATOES , LLC","shipping_paper_number":"6374","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":"2025-03-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1487441","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2025-03-19 21:40:00","snet_input_date":"2025-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-19 21:40:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-22T10:27:51.000000Z","updated_at":"2025-03-23T10:40:16.000000Z","inspection_violations":[{"id":12755547,"change_date":"2025-03-19 21:40:00","inspection_id":"84160771","insp_violation_id":"265113260","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"5A0348181","created_at":"2025-03-22T10:42:29.000000Z","updated_at":"2025-03-22T10:54:35.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":13164220,"change_date":"2025-03-19 21:40:00","inspection_id":"84160771","insp_unit_id":"205867120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"539","insp_unit_license":"YAKC938","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X0WN447816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T09:59:11.000000Z","updated_at":"2025-03-23T09:51:50.000000Z"},{"id":13164221,"change_date":"2025-03-19 21:40:00","inspection_id":"84160771","insp_unit_id":"205867121","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"416","insp_unit_license":"HV95477","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC534X2B656218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T09:59:11.000000Z","updated_at":"2025-03-23T09:51:50.000000Z"}]},{"id":7468816,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","dot_number":"3947223","report_state":"WA","report_number":"X843000478","insp_date":"2024-12-18 00:00:00","insp_start_time":"0956","insp_end_time":"1120","registration_date":null,"region":"PS","ci_status_code":"C","location":null,"location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALFORD CUSTOM AG","shipping_paper_number":"92739","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"137000","viol_total":"20","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":"1178984","transaction_code":"C","transaction_date":"2024-12-20 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-12-20 21:39:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-20 21:39:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:56.000000Z","updated_at":"2025-03-17T20:51:56.000000Z","inspection_violations":[{"id":11674761,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932436","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3939ALSLI"},{"id":11674762,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932437","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3922SLLSR"},{"id":11674763,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932438","seq_no":"3","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674764,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932439","seq_no":"4","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674765,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932440","seq_no":"5","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674766,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932441","seq_no":"6","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674767,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932442","seq_no":"7","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674768,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932443","seq_no":"8","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674769,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932444","seq_no":"9","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674770,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932445","seq_no":"11","part_no":"392","part_no_section":"2-SLLDL","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:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3922SLLDL"},{"id":11674771,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932446","seq_no":"12","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"204796196","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4A0661271","created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"393100BC"},{"id":11674772,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932447","seq_no":"10","part_no":"395","part_no_section":"8A","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-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3958A"},{"id":11674773,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932448","seq_no":"13","part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39375BTFV"},{"id":11674774,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932449","seq_no":"14","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39381H"},{"id":11674775,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932450","seq_no":"15","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"204796196","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"3939ALSLIWR"},{"id":11674776,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932451","seq_no":"16","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39378AWS"},{"id":11674777,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932452","seq_no":"17","part_no":"393","part_no_section":"203A-CBP","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"393203ACBP"},{"id":11674778,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932453","seq_no":"18","part_no":"393","part_no_section":"51C-BNVLAWD","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39351CBNVLAWD"},{"id":11674779,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932454","seq_no":"19","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39311A1CSLRR"},{"id":11674780,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_violation_id":"263932455","seq_no":"20","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"204796195","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:49.000000Z","updated_at":"2025-03-17T22:02:49.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":12049315,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_unit_id":"204796195","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"539","insp_unit_license":"YAKC938","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X0WN447816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:03.000000Z","updated_at":"2025-03-17T23:48:03.000000Z"},{"id":12049316,"change_date":"2025-01-14 21:53:00","inspection_id":"83445966","insp_unit_id":"204796196","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":null,"insp_unit_license":"HV97842","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5349SB656291","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:03.000000Z","updated_at":"2025-03-17T23:48:03.000000Z"}]},{"id":6944920,"change_date":"2024-10-12 21:33:00","inspection_id":"82892284","dot_number":"3947223","report_state":"WA","report_number":"2109006767","insp_date":"2024-10-10 00:00:00","insp_start_time":"1115","insp_end_time":"1140","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC55","location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-12 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"939418","transaction_code":"A","transaction_date":"2024-10-12 00:00:00","upload_date":"2024-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-10-12 21:33:00","snet_input_date":"2024-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-12 21:33:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:59.000000Z","updated_at":"2025-03-17T20:40:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11201114,"change_date":"2024-10-12 21:33:00","inspection_id":"82892284","insp_unit_id":"203381738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"533","insp_unit_license":"YAKC937","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DR9X7XD470512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:59.000000Z","updated_at":"2025-03-17T23:38:59.000000Z"},{"id":11201115,"change_date":"2024-10-12 21:33:00","inspection_id":"82892284","insp_unit_id":"203381739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"HV89313","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC53427B656186","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:59.000000Z","updated_at":"2025-03-17T23:38:59.000000Z"}]},{"id":6815287,"change_date":"2024-09-25 21:41:00","inspection_id":"82754594","dot_number":"3947223","report_state":"WA","report_number":"2129000324","insp_date":"2024-09-24 00:00:00","insp_start_time":"1545","insp_end_time":"1615","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":"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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"884438","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[{"id":10613813,"change_date":"2024-09-25 21:41:00","inspection_id":"82754594","insp_violation_id":"262024791","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203121534","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":10990376,"change_date":"2024-09-25 21:41:00","inspection_id":"82754594","insp_unit_id":"203121534","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YAKI951","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CG03LK67213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"},{"id":10990377,"change_date":"2024-09-25 21:41:00","inspection_id":"82754594","insp_unit_id":"203121535","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"137","insp_unit_license":"HV24619","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS2530AM806317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"}]},{"id":6616754,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","dot_number":"3947223","report_state":"WA","report_number":"X761000726","insp_date":"2024-08-30 00:00:00","insp_start_time":"1525","insp_end_time":"1615","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC77","location_desc":"KELSO WA","county_code_state":"WA","county_code":"015","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-31 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"801563","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-08-31 21:33:00","snet_input_date":"2024-08-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-31 21:33:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:06.000000Z","updated_at":"2025-03-17T20:34:06.000000Z","inspection_violations":[{"id":10289270,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538274","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39347E"},{"id":10289271,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538275","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39353B"},{"id":10289272,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538276","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3939A"},{"id":10289273,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538277","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3939A"},{"id":10289274,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538278","seq_no":"5","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39378A"},{"id":10289275,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538279","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39345B2"},{"id":10289276,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538280","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3939A"},{"id":10289277,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_violation_id":"261538281","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202696171","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10667863,"change_date":"2024-08-31 21:33:00","inspection_id":"82543035","insp_unit_id":"202696171","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"529","insp_unit_license":"YAKG848","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X25N837413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:28.000000Z","updated_at":"2025-03-17T23:33:28.000000Z"}]},{"id":6593056,"change_date":"2024-08-29 21:42:00","inspection_id":"82517620","dot_number":"3947223","report_state":"WA","report_number":"0714002588","insp_date":"2024-08-22 00:00:00","insp_start_time":"1421","insp_end_time":"1437","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"RIDGEFIELD WA","county_code_state":"WA","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"796473","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10629455,"change_date":"2024-08-29 21:42:00","inspection_id":"82517620","insp_unit_id":"202646558","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"YAKI951","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CG03LK67213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"},{"id":10629456,"change_date":"2024-08-29 21:42:00","inspection_id":"82517620","insp_unit_id":"202646559","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"HV24619","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1UYVS2530AM806317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:04.000000Z","updated_at":"2025-03-17T23:33:04.000000Z"}]},{"id":6499691,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","dot_number":"3947223","report_state":"OR","report_number":"AP07480087","insp_date":"2024-08-19 00:00:00","insp_start_time":"0749","insp_end_time":"0822","registration_date":"2024-10-29 00:00:00","region":"PD","ci_status_code":"C","location":"30-06","location_desc":"UMATILLA OR","county_code_state":"OR","county_code":"059","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-08-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"757318","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-08-19 21:41:00","snet_input_date":"2024-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-19 21:41:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:38.000000Z","updated_at":"2026-04-03T09:30:30.000000Z","inspection_violations":[{"id":19301411,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_violation_id":"272552709","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"212265192","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:15.000000Z","updated_at":"2026-04-03T09:47:08.000000Z","normalized_code":"39353BB"},{"id":19301412,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_violation_id":"272552710","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212265192","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:15.000000Z","updated_at":"2026-04-03T09:47:08.000000Z","normalized_code":"39347E"},{"id":19301413,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_violation_id":"272552711","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"212265192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-26T10:01:15.000000Z","updated_at":"2026-04-03T09:47:08.000000Z","normalized_code":"39345B2BHTD"},{"id":19301414,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_violation_id":"272552712","seq_no":"4","part_no":"393","part_no_section":"51C-BLPW","insp_viol_unit":"1","insp_unit_id":"212265192","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-26T10:01:15.000000Z","updated_at":"2026-04-03T09:47:08.000000Z","normalized_code":"39351CBLPW"},{"id":19301415,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_violation_id":"272552713","seq_no":"5","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"212265192","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:01:15.000000Z","updated_at":"2026-04-03T09:47:08.000000Z","normalized_code":"39381H"}],"inspection_per_units":[{"id":19596984,"change_date":"2026-03-23 21:50:00","inspection_id":"82418362","insp_unit_id":"212265192","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"540","insp_unit_license":"YAKC976","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XKWDB9X1YJ838204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:32.000000Z","updated_at":"2026-04-03T09:03:54.000000Z"}]},{"id":6172160,"change_date":"2024-07-09 21:42:00","inspection_id":"82067803","dot_number":"3947223","report_state":"ID","report_number":"3512003626","insp_date":"2024-07-03 00:00:00","insp_start_time":"0806","insp_end_time":"0840","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"CALDWELL ID","county_code_state":"ID","county_code":"027","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMALGAMATED SUGAR COMPANY","shipping_paper_number":"388039","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":"U","pen_cen_match":"I","final_status_date":"2024-07-09 21:42: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":"635584","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[{"id":9584181,"change_date":"2024-07-09 21:42:00","inspection_id":"82067803","insp_violation_id":"260528803","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3922"},{"id":9584182,"change_date":"2024-07-09 21:42:00","inspection_id":"82067803","insp_violation_id":"260528804","seq_no":"2","part_no":"395","part_no_section":"8(a)","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:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":9943019,"change_date":"2024-07-09 21:42:00","inspection_id":"82067803","insp_unit_id":"201786254","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"529","insp_unit_license":"YAKG848","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X25N837413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"},{"id":9943020,"change_date":"2024-07-09 21:42:00","inspection_id":"82067803","insp_unit_id":"201786255","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"416","insp_unit_license":"HS59202","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC534X2B656218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:02.000000Z","updated_at":"2025-03-17T23:26:02.000000Z"}]},{"id":5981571,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","dot_number":"3947223","report_state":"WA","report_number":"0813000502","insp_date":"2024-06-12 00:00:00","insp_start_time":"1740","insp_end_time":"1815","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"KENNEWICK WA","county_code_state":"WA","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LINEAGE","shipping_paper_number":"FB10467","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":"U","pen_cen_match":"I","final_status_date":"2024-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130200","viol_total":"4","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":"568761","transaction_code":"A","transaction_date":"2024-06-13 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-06-13 21:41:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-13 21:41:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:25.000000Z","updated_at":"2025-03-17T20:21:25.000000Z","inspection_violations":[{"id":9279843,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_violation_id":"260063780","seq_no":"1","part_no":"393","part_no_section":"78(a)","insp_viol_unit":"1","insp_unit_id":"201374500","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:52.000000Z","updated_at":"2025-03-17T21:50:52.000000Z","normalized_code":"39378A"},{"id":9279844,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_violation_id":"260063781","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201374500","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:52.000000Z","updated_at":"2025-03-17T21:50:52.000000Z","normalized_code":"3922"},{"id":9279845,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_violation_id":"260063782","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"201374501","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:52.000000Z","updated_at":"2025-03-17T21:50:52.000000Z","normalized_code":"39355E"},{"id":9279846,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_violation_id":"260063783","seq_no":"4","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"201374501","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:52.000000Z","updated_at":"2025-03-17T21:50:52.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":9634632,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_unit_id":"201374500","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"536","insp_unit_license":"YAKG847","insp_unit_license_state":"WA","insp_unit_vehicle_id_number":"1XKYP49X9LJ414385","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:51.000000Z","updated_at":"2025-03-17T23:22:51.000000Z"},{"id":9634633,"change_date":"2024-06-13 21:41:00","inspection_id":"81862469","insp_unit_id":"201374501","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":null,"insp_unit_license":"HV67015","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1F9SE5037VB114089","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:51.000000Z","updated_at":"2025-03-17T23:22:51.000000Z"}]},{"id":5727596,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","dot_number":"3947223","report_state":"WA","report_number":"2110006078","insp_date":"2024-05-10 00:00:00","insp_start_time":"0958","insp_end_time":"1050","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC55","location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"M&M POTATO","shipping_paper_number":"73589","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-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123500","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"476300","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:17.000000Z","updated_at":"2025-03-17T20:16:17.000000Z","inspection_violations":[{"id":8863988,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455834","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200850038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"3939A"},{"id":8863989,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455835","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200850038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"3939A"},{"id":8863990,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455836","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200850038","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"39360C"},{"id":8863991,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455837","seq_no":"4","part_no":"393","part_no_section":"95(a)(4)","insp_viol_unit":"1","insp_unit_id":"200850038","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"39395A4"},{"id":8863992,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455838","seq_no":"5","part_no":"393","part_no_section":"83(e)","insp_viol_unit":"1","insp_unit_id":"200850038","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"39383E"},{"id":8863993,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455839","seq_no":"6","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":"4A0366230","created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"3922"},{"id":8863994,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_violation_id":"259455840","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200850039","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:55.000000Z","updated_at":"2025-03-17T21:48:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9225379,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_unit_id":"200850038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"541","insp_unit_license":"YAKD575","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CK96PV89544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"},{"id":9225380,"change_date":"2024-05-13 21:41:00","inspection_id":"81586804","insp_unit_id":"200850039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":"33","insp_unit_license":"HU82033","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5036EB656250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:52.000000Z","updated_at":"2025-03-17T23:18:52.000000Z"}]},{"id":5478881,"change_date":"2024-04-10 21:42:00","inspection_id":"81315854","dot_number":"3947223","report_state":"WA","report_number":"X805006085","insp_date":"2024-04-08 00:00:00","insp_start_time":"2012","insp_end_time":"2057","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GALLATIN GROWN LLC","shipping_paper_number":"1951","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-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"384390","transaction_code":"A","transaction_date":"2024-04-09 00:00:00","upload_date":"2024-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2024-04-10 21:42:00","snet_input_date":"2024-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-10 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:13.000000Z","updated_at":"2025-03-17T20:11:13.000000Z","inspection_violations":[{"id":8460796,"change_date":"2024-04-10 21:42:00","inspection_id":"81315854","insp_violation_id":"258850109","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":"4A0344595","created_at":"2025-03-17T21:47:00.000000Z","updated_at":"2025-03-17T21:47:00.000000Z","normalized_code":"3922"},{"id":8460797,"change_date":"2024-04-10 21:42:00","inspection_id":"81315854","insp_violation_id":"258850110","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200327888","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:00.000000Z","updated_at":"2025-03-17T21:47:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8825542,"change_date":"2024-04-10 21:42:00","inspection_id":"81315854","insp_unit_id":"200327888","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"535","insp_unit_license":"YAKA615","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"2HSCNAPR77C409969","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:06.000000Z","updated_at":"2025-03-17T23:15:06.000000Z"},{"id":8825543,"change_date":"2024-04-10 21:42:00","inspection_id":"81315854","insp_unit_id":"200327889","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"415","insp_unit_license":"HV31726","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SE53411B114085","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:06.000000Z","updated_at":"2025-03-17T23:15:06.000000Z"}]},{"id":4533689,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","dot_number":"3947223","report_state":"WA","report_number":"0813000038","insp_date":"2023-11-30 00:00:00","insp_start_time":"1250","insp_end_time":"1410","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC55","location_desc":"PASCO WA","county_code_state":"WA","county_code":"021","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"12","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":"113831","transaction_code":"A","transaction_date":"2023-12-01 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:36.000000Z","updated_at":"2025-03-17T19:52:36.000000Z","inspection_violations":[{"id":7015405,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654590","seq_no":"1","part_no":"385","part_no_section":"337B-OOSO","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"385337BOOSO"},{"id":7015406,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654591","seq_no":"2","part_no":"393","part_no_section":"201D-FR","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"393201DFR"},{"id":7015407,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654592","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"198296378","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39617CPI"},{"id":7015408,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654593","seq_no":"4","part_no":"396","part_no_section":"5-HL","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3965HL"},{"id":7015409,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654594","seq_no":"5","part_no":"393","part_no_section":"83(e)","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39383E"},{"id":7015410,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654595","seq_no":"6","part_no":"393","part_no_section":"201D-FR","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"393201DFR"},{"id":7015411,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654596","seq_no":"7","part_no":"393","part_no_section":"30-B","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39330B"},{"id":7015412,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654597","seq_no":"8","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39348ABIBD"},{"id":7015413,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654598","seq_no":"9","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39381H"},{"id":7015414,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654599","seq_no":"10","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3922SLLSR"},{"id":7015415,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654600","seq_no":"11","part_no":"393","part_no_section":"55D1-B","insp_viol_unit":"1","insp_unit_id":"198296377","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39355D1B"},{"id":7015416,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_violation_id":"256654601","seq_no":"12","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"198296378","insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":7291668,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_unit_id":"198296377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YAKC975","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9XX7N690289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"},{"id":7291669,"change_date":"2023-12-01 21:42:00","inspection_id":"80282911","insp_unit_id":"198296378","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRINITY PR","insp_unit_company":null,"insp_unit_license":"HU98686","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346GB656224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:15.000000Z","updated_at":"2025-03-17T23:01:15.000000Z"}]},{"id":3916468,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","dot_number":"3947223","report_state":"OR","report_number":"AAMN000313","insp_date":"2023-09-03 00:00:00","insp_start_time":"1524","insp_end_time":"1603","registration_date":"2023-09-08 00:00:00","region":"PT","ci_status_code":"C","location":"0366","location_desc":"CLACKAMAS COUNTY MCSAP","county_code_state":"OR","county_code":"005","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-09-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"5","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1232512","transaction_code":"C","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-09-06 21:43:00","snet_input_date":"2023-09-06 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-09-06 21:43:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:40:07.000000Z","updated_at":"2025-03-17T19:40:07.000000Z","inspection_violations":[{"id":6051811,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_violation_id":"255752635","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"26100955","created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3922"},{"id":6051812,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_violation_id":"255752636","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197483759","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39378"},{"id":6051813,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_violation_id":"255752637","seq_no":"3","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197483759","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"39360D"},{"id":6051814,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_violation_id":"255752638","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"197483760","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3922"},{"id":6051815,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_violation_id":"255752639","seq_no":"5","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:35:17.000000Z","updated_at":"2025-03-17T21:35:17.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":6297619,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_unit_id":"197483759","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"533","insp_unit_license":"YAKC937","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DR9X7XD470512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:54.000000Z","updated_at":"2025-03-17T22:52:54.000000Z"},{"id":6297620,"change_date":"2023-10-10 21:42:00","inspection_id":"79600059","insp_unit_id":"197483760","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"HU46128","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1F9SE483XRB114320","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:54.000000Z","updated_at":"2025-03-17T22:52:54.000000Z"}]},{"id":3825561,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","dot_number":"3947223","report_state":"OR","report_number":"AADD000758","insp_date":"2023-08-23 00:00:00","insp_start_time":"1457","insp_end_time":"1610","registration_date":"2023-08-31 00:00:00","region":"PT","ci_status_code":"C","location":"3103","location_desc":"LA GRANDE - 2 MI W LA GRANDE","county_code_state":"OR","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-08-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"12","oos_total":"5","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231950","transaction_code":"C","transaction_date":"2023-08-24 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-24 21:41:00","snet_input_date":"2023-08-24 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:38:30.000000Z","updated_at":"2025-03-17T19:38:30.000000Z","inspection_violations":[{"id":5906690,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028782","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196850207","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3963A1"},{"id":5906691,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028783","seq_no":"2","part_no":"393","part_no_section":"24(a)","insp_viol_unit":"1","insp_unit_id":"196850207","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39324A"},{"id":5906692,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028784","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39395A"},{"id":5906693,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028785","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393207A"},{"id":5906694,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028786","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393207A"},{"id":5906695,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028787","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3939A"},{"id":5906696,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028788","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3939A"},{"id":5906697,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028789","seq_no":"8","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393207A"},{"id":5906698,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028790","seq_no":"9","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"393207A"},{"id":5906699,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028791","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3939A"},{"id":5906700,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028792","seq_no":"11","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196850208","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"39617C"},{"id":5906701,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_violation_id":"255028793","seq_no":"12","part_no":"392","part_no_section":"7(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:34:32.000000Z","updated_at":"2025-03-17T21:34:32.000000Z","normalized_code":"3927A"}],"inspection_per_units":[{"id":6150948,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_unit_id":"196850207","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"530","insp_unit_license":"YAKC974","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5D49X66D871308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"},{"id":6150949,"change_date":"2023-08-31 21:43:00","inspection_id":"79498514","insp_unit_id":"196850208","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STTT","insp_unit_company":"7322","insp_unit_license":"HV02050","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1S9J534062S026464","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:41.000000Z","updated_at":"2025-03-17T22:51:41.000000Z"}]},{"id":3737681,"change_date":"2023-08-14 21:42:00","inspection_id":"79400493","dot_number":"3947223","report_state":"OR","report_number":"AAF2006314","insp_date":"2023-08-13 00:00:00","insp_start_time":"1245","insp_end_time":"1257","registration_date":null,"region":"MT","ci_status_code":"C","location":"2306","location_desc":"FAREWELL BEND POE","county_code_state":"OR","county_code":"045","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"BOBTAIL ONLY","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-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"1230829","transaction_code":"A","transaction_date":"2023-08-13 00:00:00","upload_date":"2023-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-14 21:42:00","snet_input_date":"2023-08-14 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:36:33.000000Z","updated_at":"2025-03-17T19:36:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6010058,"change_date":"2023-08-14 21:42:00","inspection_id":"79400493","insp_unit_id":"196519640","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"533","insp_unit_license":"YAKC937","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DR9X7XD470512","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:31.000000Z","updated_at":"2025-03-17T22:50:31.000000Z"}]},{"id":3707646,"change_date":"2023-08-31 21:43:00","inspection_id":"79367069","dot_number":"3947223","report_state":"OR","report_number":"AAYL003571","insp_date":"2023-08-08 00:00:00","insp_start_time":"1602","insp_end_time":"1644","registration_date":"2023-08-31 00:00:00","region":"PT","ci_status_code":"C","location":"3004","location_desc":"COLD SPRINGS - JCT US730\/OR37","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"GREENRIDGE FARMING, INC","shipping_paper_number":"24640","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"1230612","transaction_code":"C","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-09 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5717042,"change_date":"2023-08-31 21:43:00","inspection_id":"79367069","insp_violation_id":"255028760","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"196850185","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39395F"},{"id":5717043,"change_date":"2023-08-31 21:43:00","inspection_id":"79367069","insp_violation_id":"255028761","seq_no":"2","part_no":"393","part_no_section":"30","insp_viol_unit":"2","insp_unit_id":"196850186","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39330"}],"inspection_per_units":[{"id":5961475,"change_date":"2023-08-31 21:43:00","inspection_id":"79367069","insp_unit_id":"196850185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"530","insp_unit_license":"YAKC974","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5D49X66D871308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5961476,"change_date":"2023-08-31 21:43:00","inspection_id":"79367069","insp_unit_id":"196850186","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"400","insp_unit_license":"HU92686","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:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3707670,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","dot_number":"3947223","report_state":"OR","report_number":"AADH004502","insp_date":"2023-08-08 00:00:00","insp_start_time":"1224","insp_end_time":"1349","registration_date":"2023-08-31 00:00:00","region":"PT","ci_status_code":"C","location":"3006","location_desc":"UMATILLA POE","county_code_state":"OR","county_code":"059","insp_level_id":"1","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"N\/A","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-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230638","transaction_code":"C","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-09 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5717099,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028835","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196850247","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3939A"},{"id":5717100,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028836","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196850247","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39375A3"},{"id":5717101,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028837","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"196850247","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39355D3"},{"id":5717102,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028838","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39355E"},{"id":5717103,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028839","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3963A1"},{"id":5717104,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028840","seq_no":"6","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39311"},{"id":5717105,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028841","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39345D"},{"id":5717106,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028842","seq_no":"9","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39353B"},{"id":5717107,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028843","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39347E"},{"id":5717108,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028844","seq_no":"11","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39347E"},{"id":5717109,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028845","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39347E"},{"id":5717110,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_violation_id":"255028846","seq_no":"13","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196850248","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":5961521,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_unit_id":"196850247","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"534","insp_unit_license":"YAJX954","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUJA6CK34LM82994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5961522,"change_date":"2023-08-31 21:43:00","inspection_id":"79367098","insp_unit_id":"196850248","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"416","insp_unit_license":"HS59202","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:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3707987,"change_date":"2023-08-09 21:43:00","inspection_id":"79367458","dot_number":"3947223","report_state":"WA","report_number":"F306000023","insp_date":"2023-08-07 00:00:00","insp_start_time":"2309","insp_end_time":"2322","registration_date":null,"region":"PT","ci_status_code":"C","location":null,"location_desc":"SR 730 MP1","county_code_state":"WA","county_code":"071","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":"SAME","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":"2023-08-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2585579","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-09 21:43:00","snet_input_date":"2023-08-08 00:00:00","source_office":"4WAS001","mcmis_add_date":"2023-08-09 21:43:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:06.000000Z","updated_at":"2025-03-17T19:36:06.000000Z","inspection_violations":[{"id":5717596,"change_date":"2023-08-09 21:43:00","inspection_id":"79367458","insp_violation_id":"254562762","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:27.000000Z","updated_at":"2025-03-17T21:33:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5962062,"change_date":"2023-08-09 21:43:00","inspection_id":"79367458","insp_unit_id":"196450486","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"530","insp_unit_license":"YAKC974","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5D49X66D871308","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"},{"id":5962063,"change_date":"2023-08-09 21:43:00","inspection_id":"79367458","insp_unit_id":"196450487","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":null,"insp_unit_license":"HU98686","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1T9SC5346GB656224","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:07.000000Z","updated_at":"2025-03-17T22:50:07.000000Z"}]},{"id":3643837,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","dot_number":"3947223","report_state":"OR","report_number":"AAYL003569","insp_date":"2023-07-31 00:00:00","insp_start_time":"2315","insp_end_time":"2351","registration_date":"2023-08-31 00:00:00","region":"PT","ci_status_code":"C","location":"3004","location_desc":"COLD SPRINGS - JCT US730\/OR37","county_code_state":"OR","county_code":"059","insp_level_id":"2","service_center":"WE","census_source_id":"4","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":"N","pen_cen_match":"I","final_status_date":"2023-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1230107","transaction_code":"C","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":null,"census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-08-01 00:00:00","source_office":"4ORS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"009818","created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[{"id":5618060,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_violation_id":"255028756","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196850183","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3939A"},{"id":5618061,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_violation_id":"255028757","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196850183","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"3939A"},{"id":5618062,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_violation_id":"255028758","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"2","insp_unit_id":"196850184","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"39330"},{"id":5618063,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_violation_id":"255028759","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"196850183","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:01.000000Z","updated_at":"2025-03-17T21:33:01.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5859032,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_unit_id":"196850183","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"538","insp_unit_license":"YAKC910","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1FUNA6CK87PU55428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:15.000000Z","updated_at":"2025-03-17T22:49:15.000000Z"},{"id":5859033,"change_date":"2023-08-31 21:43:00","inspection_id":"79295477","insp_unit_id":"196850184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRIN","insp_unit_company":"93","insp_unit_license":"HU66603","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:49:15.000000Z","updated_at":"2025-03-17T22:49:15.000000Z"}]},{"id":2757512,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","dot_number":"3947223","report_state":"ID","report_number":"1500004191","insp_date":"2023-04-07 00:00:00","insp_start_time":"0759","insp_end_time":"0828","registration_date":null,"region":"PT","ci_status_code":"C","location":"HUETT","location_desc":"HUETTER PORT OF ENTRY","county_code_state":"ID","county_code":"055","insp_level_id":"2","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"265185","transaction_code":"C","transaction_date":"2023-04-08 00:00:00","upload_date":"2023-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03947223","upload_search_indicator":"M","census_search_date":"2023-04-07 21:38:00","snet_input_date":"2023-04-07 00:00:00","source_office":"4IDS001","mcmis_add_date":"2023-04-07 21:38:00","insp_carrier_name":"LOS CARNALES TRUCKING LLC","insp_carrier_street":"200 E PUNKIN CENTER RD","insp_carrier_city":"HERMISTON","insp_carrier_state":"OR","insp_carrier_zip_code":"97838","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:23.000000Z","updated_at":"2025-03-17T19:17:23.000000Z","inspection_violations":[{"id":4232735,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_violation_id":"252112609","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194289084","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39311"},{"id":4232736,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_violation_id":"252112610","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194289084","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3922"},{"id":4232737,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_violation_id":"252112611","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"194289085","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"39345D"},{"id":4232738,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_violation_id":"252112612","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194289085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:46.000000Z","updated_at":"2025-03-17T21:26:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4438234,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_unit_id":"194289084","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"YAKA118","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"1XP5DB9X25N837413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"},{"id":4438235,"change_date":"2023-04-09 21:30:00","inspection_id":"78296265","insp_unit_id":"194289085","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"HU98615","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:37:56.000000Z","updated_at":"2025-03-17T22:37:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3947223\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3947223\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3947223\/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\/3947223\/inspections","per_page":100,"prev_page_url":null,"to":21,"total":21}