{"current_page":1,"data":[{"id":12313096,"change_date":"2026-06-29 21:42:00","inspection_id":"88270718","dot_number":"1847633","report_state":"NE","report_number":"T557002391","insp_date":"2026-06-29 00:00:00","insp_start_time":"0810","insp_end_time":"0831","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FREMONT NE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"3646342","transaction_code":"A","transaction_date":"2026-06-29 00:00:00","upload_date":"2026-06-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:35.000000Z","updated_at":"2026-07-10T09:31:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21385881,"change_date":"2026-06-29 21:42:00","inspection_id":"88270718","insp_unit_id":"214351076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"08","insp_unit_license":"FZ1233","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NP5D49X97N678396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:33.000000Z","updated_at":"2026-07-10T09:02:28.000000Z"},{"id":21385882,"change_date":"2026-06-29 21:42:00","inspection_id":"88270718","insp_unit_id":"214351077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERRITT EQ","insp_unit_company":null,"insp_unit_license":"MM8608","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:33.000000Z","updated_at":"2026-07-10T09:02:28.000000Z"}]},{"id":12124131,"change_date":"2026-06-09 10:49:00","inspection_id":"88069805","dot_number":"1847633","report_state":"NE","report_number":"T025002716","insp_date":"2026-06-08 00:00:00","insp_start_time":"0630","insp_end_time":"0647","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FREMONT NE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RC FAMILY FARMS","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":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"3489875","transaction_code":"A","transaction_date":"2026-06-08 00:00:00","upload_date":"2026-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:41.000000Z","updated_at":"2026-06-20T09:30:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21064881,"change_date":"2026-06-09 10:49:00","inspection_id":"88069805","insp_unit_id":"213964026","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILSON TRA","insp_unit_company":null,"insp_unit_license":"LP6076","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A0L5557974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:00.000000Z","updated_at":"2026-06-20T09:02:02.000000Z"},{"id":21064880,"change_date":"2026-06-09 10:49:00","inspection_id":"88069805","insp_unit_id":"213964025","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"07","insp_unit_license":"MX1925","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X7DD198759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:00.000000Z","updated_at":"2026-06-20T09:02:02.000000Z"}]},{"id":11489098,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","dot_number":"1847633","report_state":"IA","report_number":"000P1102KV","insp_date":"2026-03-25 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB AT DIPPER","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1395116","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:54:18.000000Z","updated_at":"2026-04-06T09:33:08.000000Z","inspection_violations":[{"id":19397858,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","insp_violation_id":"272664009","seq_no":"3","part_no":"383","part_no_section":"71H","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:30.000000Z","updated_at":"2026-04-06T09:54:17.000000Z","normalized_code":"38371H"},{"id":19397856,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","insp_violation_id":"272664007","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK26032514331","created_at":"2026-03-29T10:23:30.000000Z","updated_at":"2026-04-06T09:54:16.000000Z","normalized_code":"39216"},{"id":19397857,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","insp_violation_id":"272664008","seq_no":"2","part_no":"392","part_no_section":"2-SLLS3","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":"2026-03-29T10:23:30.000000Z","updated_at":"2026-04-06T09:54:16.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19681261,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","insp_unit_id":"212358374","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"08","insp_unit_license":"FZ1233","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NP5D49X97N678396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:02.000000Z","updated_at":"2026-04-06T09:12:46.000000Z"},{"id":19681262,"change_date":"2026-03-26 21:40:00","inspection_id":"87408691","insp_unit_id":"212358375","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":"MM8608","insp_unit_license":"MM8608","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:02.000000Z","updated_at":"2026-04-06T09:12:46.000000Z"}]},{"id":10118983,"change_date":"2025-11-04 21:40:00","inspection_id":"86235440","dot_number":"1847633","report_state":"NE","report_number":"T107000064","insp_date":"2025-11-04 00:00:00","insp_start_time":"0831","insp_end_time":"0846","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 77, 2657 FEET NORTH","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANSCHAU LIVESTOCK","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":null,"final_status_date":"2025-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"828741","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2025-11-04 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:46.000000Z","updated_at":"2025-11-08T10:31:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16837212,"change_date":"2025-11-04 21:40:00","inspection_id":"86235440","insp_unit_id":"209835707","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"FZ1234","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9XX5J108058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:39.000000Z","updated_at":"2025-11-08T10:01:39.000000Z"},{"id":16837213,"change_date":"2025-11-04 21:40:00","inspection_id":"86235440","insp_unit_id":"209835708","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"HU1966","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UCS2K65D529042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:39.000000Z","updated_at":"2025-11-08T10:01:39.000000Z"}]},{"id":8805408,"change_date":"2025-06-03 21:40:00","inspection_id":"84852400","dot_number":"1847633","report_state":"IA","report_number":"000P13P4FB","insp_date":"2025-05-30 00:00:00","insp_start_time":"0835","insp_end_time":"0910","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"57MM","county_code_state":"IA","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ANDERSON FARMS","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1362614","transaction_code":"A","transaction_date":"2025-06-03 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2025-06-03 21:40:00","snet_input_date":"2025-05-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-03 21:40:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-06T10:01:06.000000Z","updated_at":"2025-06-07T10:00:35.000000Z","inspection_violations":[{"id":14085519,"change_date":"2025-06-03 21:40:00","inspection_id":"84852400","insp_violation_id":"266634570","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207202607","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:41.000000Z","updated_at":"2025-06-07T10:17:31.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":14412249,"change_date":"2025-06-03 21:40:00","inspection_id":"84852400","insp_unit_id":"207202607","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"FJ1095","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9X38R22278","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:49.000000Z","updated_at":"2025-06-07T09:45:45.000000Z"},{"id":14412250,"change_date":"2025-06-03 21:40:00","inspection_id":"84852400","insp_unit_id":"207202608","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILSON","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:49.000000Z","updated_at":"2025-06-07T09:45:45.000000Z"}]},{"id":7970273,"change_date":"2025-02-26 21:42:00","inspection_id":"83972542","dot_number":"1847633","report_state":"NE","report_number":"T409000367","insp_date":"2025-02-26 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 75, 2570 FEET SOUTH","county_code_state":"NE","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127500","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":"808925","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-26 00:00:00","source_office":"3NES001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12452770,"change_date":"2025-02-26 21:42:00","inspection_id":"83972542","insp_violation_id":"264717009","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-17T22:06:49.000000Z","updated_at":"2025-03-17T22:06:49.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12866864,"change_date":"2025-02-26 21:42:00","inspection_id":"83972542","insp_unit_id":"205518157","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1319","insp_unit_license":"VE3064","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG20D489735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"},{"id":12866865,"change_date":"2025-02-26 21:42:00","inspection_id":"83972542","insp_unit_id":"205518158","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7372606,"change_date":"2024-12-09 21:41:00","inspection_id":"83345044","dot_number":"1847633","report_state":"NE","report_number":"T616000042","insp_date":"2024-12-09 00:00:00","insp_start_time":"0746","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 77, 539 FEET SOUTH O","county_code_state":"NE","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANSCHAU LIVESTOCK","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127500","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":"803889","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2024-12-09 21:41:00","snet_input_date":"2024-12-09 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11520184,"change_date":"2024-12-09 21:41:00","inspection_id":"83345044","insp_violation_id":"263332080","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","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-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLS2"},{"id":11520185,"change_date":"2024-12-09 21:41:00","inspection_id":"83345044","insp_violation_id":"263332081","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204271810","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ET9005295","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11893457,"change_date":"2024-12-09 21:41:00","inspection_id":"83345044","insp_unit_id":"204271810","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1319","insp_unit_license":"VE3064","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG20D489735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"},{"id":11893458,"change_date":"2024-12-09 21:41:00","inspection_id":"83345044","insp_unit_id":"204271811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":7319467,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","dot_number":"1847633","report_state":"IA","report_number":"000P12JNNT","insp_date":"2024-11-26 00:00:00","insp_start_time":"1355","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"28 - I80 WB MM 44 AVOCA","county_code_state":"IA","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OWN","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":null,"final_status_date":"2024-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1340080","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-11-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:38.000000Z","updated_at":"2025-03-17T20:48:38.000000Z","inspection_violations":[{"id":11441656,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173439","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204134649","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"3922RG"},{"id":11441657,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173440","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204134649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39311TL"},{"id":11441658,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173441","seq_no":"3","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"204134649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39345B2"},{"id":11441659,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173442","seq_no":"4","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"204134649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39355D2"},{"id":11441660,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173443","seq_no":"5","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"204134650","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"39355E"},{"id":11441661,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_violation_id":"263173444","seq_no":"6","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204134649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:40.000000Z","updated_at":"2025-03-17T22:01:40.000000Z","normalized_code":"3939T"}],"inspection_per_units":[{"id":11807358,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_unit_id":"204134649","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"23","insp_unit_license":"FJ1094","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG80D630551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:23.000000Z","updated_at":"2025-03-17T23:45:23.000000Z"},{"id":11807359,"change_date":"2024-12-02 21:39:00","inspection_id":"83289049","insp_unit_id":"204134650","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"6050","insp_unit_license":"JJ3581","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16532A0K5556050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:23.000000Z","updated_at":"2025-03-17T23:45:23.000000Z"}]},{"id":7025712,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","dot_number":"1847633","report_state":"IA","report_number":"000P1271H3","insp_date":"2024-10-21 00:00:00","insp_start_time":"0935","insp_end_time":"1014","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 EB & HWY 59","county_code_state":"IA","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RC FAMILY FARMS","shipping_paper_number":"180H","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":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1334019","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10965379,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_violation_id":"262514498","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203548107","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922RG"},{"id":10965380,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_violation_id":"262514499","seq_no":"2","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1CLA24102110152","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39216"},{"id":10965381,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_violation_id":"262514500","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922SLLEWG1"},{"id":10965382,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_violation_id":"262514501","seq_no":"4","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":"1CLA24102110110","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":11330991,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_unit_id":"203548107","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"08","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NP5D49X97N678396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11330992,"change_date":"2024-10-23 21:42:00","inspection_id":"82978223","insp_unit_id":"203548108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":"23","insp_unit_license":"DN4014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6853427,"change_date":"2024-09-30 21:41:00","inspection_id":"82794986","dot_number":"1847633","report_state":"NE","report_number":"T143000388","insp_date":"2024-09-30 00:00:00","insp_start_time":"0750","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 75, 237 FEET SOUTH O","county_code_state":"NE","county_code":"043","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RC FAMILY FARMS INC","shipping_paper_number":"325","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":null,"final_status_date":"2024-09-30 21:41: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":"798768","transaction_code":"A","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2024-09-30 21:41:00","snet_input_date":"2024-09-30 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[{"id":10674200,"change_date":"2024-09-30 21:41:00","inspection_id":"82794986","insp_violation_id":"262104639","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:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"},{"id":10674201,"change_date":"2024-09-30 21:41:00","inspection_id":"82794986","insp_violation_id":"262104640","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203195481","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11052147,"change_date":"2024-09-30 21:41:00","inspection_id":"82794986","insp_unit_id":"203195481","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"08","insp_unit_license":"FJ1096","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NP5D49X97N678396","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"},{"id":11052148,"change_date":"2024-09-30 21:41:00","inspection_id":"82794986","insp_unit_id":"203195482","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":null,"insp_unit_license":"DN4014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6299917,"change_date":"2024-07-24 21:42:00","inspection_id":"82204782","dot_number":"1847633","report_state":"NE","report_number":"T498000247","insp_date":"2024-07-24 00:00:00","insp_start_time":"1038","insp_end_time":"1053","registration_date":null,"region":"CT","ci_status_code":"C","location":"3","location_desc":"FREMONT SCALE","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"792970","transaction_code":"A","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2024-07-24 21:42:00","snet_input_date":"2024-07-24 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-07-24 21:42:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:27.000000Z","updated_at":"2025-03-17T20:27:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10151092,"change_date":"2024-07-24 21:42:00","inspection_id":"82204782","insp_unit_id":"202050754","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"23","insp_unit_license":"FJ1094","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG80D630551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"},{"id":10151093,"change_date":"2024-07-24 21:42:00","inspection_id":"82204782","insp_unit_id":"202050755","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"JJ3581","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16532A0K5556050","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:10.000000Z","updated_at":"2025-03-17T23:28:10.000000Z"}]},{"id":4302855,"change_date":"2023-10-27 21:43:00","inspection_id":"80028466","dot_number":"1847633","report_state":"NE","report_number":"0111000079","insp_date":"2023-10-26 00:00:00","insp_start_time":"0823","insp_end_time":"0829","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FREMONT SCALES","county_code_state":"NE","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","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":"774350","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":null,"census_search_date":"2023-10-27 21:43:00","snet_input_date":"2023-10-26 00:00:00","source_office":"3NES001","mcmis_add_date":"2023-10-27 21:43:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:20.000000Z","updated_at":"2025-03-17T19:48:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6920175,"change_date":"2023-10-27 21:43:00","inspection_id":"80028466","insp_unit_id":"197788631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"FJ1095","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9X38R222781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:05.000000Z","updated_at":"2025-03-17T22:58:05.000000Z"},{"id":6920176,"change_date":"2023-10-27 21:43:00","inspection_id":"80028466","insp_unit_id":"197788632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":"1","insp_unit_license":"DN4014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:05.000000Z","updated_at":"2025-03-17T22:58:05.000000Z"}]},{"id":4152635,"change_date":"2023-10-09 21:36:00","inspection_id":"79862419","dot_number":"1847633","report_state":"IA","report_number":"000TT3X4JP","insp_date":"2023-10-06 00:00:00","insp_start_time":"0535","insp_end_time":"0549","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 EB","county_code_state":"IA","county_code":"059","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1291121","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:57.000000Z","updated_at":"2025-03-17T19:44:57.000000Z","inspection_violations":[{"id":6427119,"change_date":"2023-10-09 21:36:00","inspection_id":"79862419","insp_violation_id":"255721507","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:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6677130,"change_date":"2023-10-09 21:36:00","inspection_id":"79862419","insp_unit_id":"197455417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FJ1096","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKTDU9XX7J168519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"},{"id":6677131,"change_date":"2023-10-09 21:36:00","inspection_id":"79862419","insp_unit_id":"197455418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"JS2369","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UCS2186D531612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"}]},{"id":3662892,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","dot_number":"1847633","report_state":"IA","report_number":"000P1101RW","insp_date":"2023-08-02 00:00:00","insp_start_time":"0823","insp_end_time":"0850","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"240TH EB AT EAGLE","county_code_state":"IA","county_code":"119","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1283416","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2023-08-03 21:40:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-03 21:40:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:15.000000Z","updated_at":"2025-03-17T19:35:15.000000Z","inspection_violations":[{"id":5646607,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_violation_id":"254447554","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":"1DYK23080208415","created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3922"},{"id":5646608,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_violation_id":"254447555","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"196346982","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"39395A"},{"id":5646609,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_violation_id":"254447556","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196346982","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3922"},{"id":5646610,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_violation_id":"254447557","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196346982","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5889212,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_unit_id":"196346982","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FJ1096","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKTDU9XX7J168519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:30.000000Z","updated_at":"2025-03-17T22:49:30.000000Z"},{"id":5889213,"change_date":"2023-08-03 21:40:00","inspection_id":"79317019","insp_unit_id":"196346983","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"JS2369","insp_unit_license":"JS2369","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UCS2186D531612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:30.000000Z","updated_at":"2025-03-17T22:49:30.000000Z"}]},{"id":3456414,"change_date":"2023-07-07 21:41:00","inspection_id":"79085300","dot_number":"1847633","report_state":"IA","report_number":"000P136NHD","insp_date":"2023-07-03 00:00:00","insp_start_time":"0914","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 75NB FEW S OF MAURICE, IA","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","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":"1279869","transaction_code":"A","transaction_date":"2023-07-07 00:00:00","upload_date":"2023-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2023-07-07 21:41:00","snet_input_date":"2023-07-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-07 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:22.000000Z","updated_at":"2025-03-17T19:31:22.000000Z","inspection_violations":[{"id":5328507,"change_date":"2023-07-07 21:41:00","inspection_id":"79085300","insp_violation_id":"253928549","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":"1HIL23070309224","created_at":"2025-03-17T21:31:44.000000Z","updated_at":"2025-03-17T21:31:44.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5557703,"change_date":"2023-07-07 21:41:00","inspection_id":"79085300","insp_unit_id":"195881520","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"FJ1095","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9X38R222781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"},{"id":5557704,"change_date":"2023-07-07 21:41:00","inspection_id":"79085300","insp_unit_id":"195881521","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":null,"insp_unit_license":"DN4014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:53.000000Z","updated_at":"2025-03-17T22:46:53.000000Z"}]},{"id":2697326,"change_date":"2023-03-30 21:41:00","inspection_id":"78227807","dot_number":"1847633","report_state":"SD","report_number":"HP18800109","insp_date":"2023-03-28 00:00:00","insp_start_time":"1224","insp_end_time":"1249","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"GLENHAM","county_code_state":"SD","county_code":"129","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"200000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"639406","transaction_code":"A","transaction_date":"2023-03-30 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2023-03-30 21:41:00","snet_input_date":"2023-03-30 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-03-30 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:16.000000Z","updated_at":"2025-03-17T19:16:16.000000Z","inspection_violations":[{"id":4142456,"change_date":"2023-03-30 21:41:00","inspection_id":"78227807","insp_violation_id":"251957710","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1040856-HP","created_at":"2025-03-17T21:26:25.000000Z","updated_at":"2025-03-17T21:26:25.000000Z","normalized_code":"3922"},{"id":4142457,"change_date":"2023-03-30 21:41:00","inspection_id":"78227807","insp_violation_id":"251957711","seq_no":"2","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:26:25.000000Z","updated_at":"2025-03-17T21:26:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4342419,"change_date":"2023-03-30 21:41:00","inspection_id":"78227807","insp_unit_id":"194147230","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"07","insp_unit_license":"FJ1093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X7DD198759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:12.000000Z","updated_at":"2025-03-17T22:37:12.000000Z"},{"id":4342420,"change_date":"2023-03-30 21:41:00","inspection_id":"78227807","insp_unit_id":"194147231","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:12.000000Z","updated_at":"2025-03-17T22:37:12.000000Z"}]},{"id":2318331,"change_date":"2023-02-09 21:40:00","inspection_id":"77795518","dot_number":"1847633","report_state":"SD","report_number":"0020086420","insp_date":"2023-02-07 00:00:00","insp_start_time":"0748","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SIOUX FALLS PORT OF ENTRY","county_code_state":"SD","county_code":"099","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"RC FAMILY FARMS","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"635911","transaction_code":"C","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-07 00:00:00","source_office":"4SDS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:18.000000Z","updated_at":"2025-03-17T19:09:18.000000Z","inspection_violations":[{"id":3571353,"change_date":"2023-02-09 21:40:00","inspection_id":"77795518","insp_violation_id":"251053346","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":"B1026892","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"3922"},{"id":3571354,"change_date":"2023-02-09 21:40:00","inspection_id":"77795518","insp_violation_id":"251053347","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193324632","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:23:51.000000Z","updated_at":"2025-03-17T21:23:51.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3731581,"change_date":"2023-02-09 21:40:00","inspection_id":"77795518","insp_unit_id":"193324631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"111","insp_unit_license":"FH8570","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9XX5J108058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:44.000000Z","updated_at":"2025-03-17T22:32:44.000000Z"},{"id":3731582,"change_date":"2023-02-09 21:40:00","inspection_id":"77795518","insp_unit_id":"193324632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"T26","insp_unit_license":"GG5208","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UCS2186D531612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:44.000000Z","updated_at":"2025-03-17T22:32:44.000000Z"}]},{"id":1096607,"change_date":"2022-08-22 21:42:00","inspection_id":"76390635","dot_number":"1847633","report_state":"IA","report_number":"000TT82G83","insp_date":"2022-08-18 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 59 SB & 190 TH","county_code_state":"IA","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANSCHAU","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":null,"final_status_date":"2022-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1238369","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2022-08-22 21:42:00","snet_input_date":"2022-08-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-08-22 21:42:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:56.000000Z","updated_at":"2025-03-17T18:46:56.000000Z","inspection_violations":[{"id":1726599,"change_date":"2022-08-22 21:42:00","inspection_id":"76390635","insp_violation_id":"247879122","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":"T42422081813051","created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3922"},{"id":1726600,"change_date":"2022-08-22 21:42:00","inspection_id":"76390635","insp_violation_id":"247879123","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"190451457","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:03.000000Z","updated_at":"2025-03-17T21:15:03.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1763567,"change_date":"2022-08-22 21:42:00","inspection_id":"76390635","insp_unit_id":"190451456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"FJ1096","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKTDU9XX7J168519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:07.000000Z","updated_at":"2025-03-17T22:19:07.000000Z"},{"id":1763568,"change_date":"2022-08-22 21:42:00","inspection_id":"76390635","insp_unit_id":"190451457","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"PT110","insp_unit_license":"HU1966","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UCS2K65D529042","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:07.000000Z","updated_at":"2025-03-17T22:19:07.000000Z"}]},{"id":551311,"change_date":"2022-06-06 21:41:00","inspection_id":"75750204","dot_number":"1847633","report_state":"MN","report_number":"00VV006181","insp_date":"2022-06-06 00:00:00","insp_start_time":"0919","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"125000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1332302","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":null,"census_search_date":"2022-06-06 21:41:00","snet_input_date":"2022-06-06 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[{"id":867689,"change_date":"2022-06-06 21:41:00","inspection_id":"75750204","insp_violation_id":"246266392","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"189083648","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":886991,"change_date":"2022-06-06 21:41:00","inspection_id":"75750204","insp_unit_id":"189083647","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"},{"id":886992,"change_date":"2022-06-06 21:41:00","inspection_id":"75750204","insp_unit_id":"189083648","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"07","insp_unit_license":"FJ1093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X7DD198759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]},{"id":502819,"change_date":"2022-05-27 21:40:00","inspection_id":"75692753","dot_number":"1847633","report_state":"IA","report_number":"000TT8BDHT","insp_date":"2022-05-26 00:00:00","insp_start_time":"1501","insp_end_time":"1507","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB B30 \/ DOVE AVE","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANSCHAU LIVESTOCK LLC","shipping_paper_number":"EMPTY","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":null,"final_status_date":"2022-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","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":"1227128","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2022-05-27 21:40:00","snet_input_date":"2022-05-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-27 21:40:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:39.000000Z","updated_at":"2025-03-17T18:36:39.000000Z","inspection_violations":[{"id":798402,"change_date":"2022-05-27 21:40:00","inspection_id":"75692753","insp_violation_id":"246134589","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:10:47.000000Z","updated_at":"2025-03-17T21:10:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":808395,"change_date":"2022-05-27 21:40:00","inspection_id":"75692753","insp_unit_id":"188961903","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"07","insp_unit_license":"FJ1093","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X7DD198759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"},{"id":808396,"change_date":"2022-05-27 21:40:00","inspection_id":"75692753","insp_unit_id":"188961904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"13","insp_unit_license":"IT6709","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A6D5543899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"}]},{"id":80987,"change_date":"2022-03-31 21:41:00","inspection_id":"75187218","dot_number":"1847633","report_state":"IA","report_number":"000P1100JB","insp_date":"2022-03-31 00:00:00","insp_start_time":"0632","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 75 SB BYPASS AT HWY 20","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"1","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":null,"final_status_date":"2022-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1217959","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2022-03-31 21:41:00","snet_input_date":"2022-03-31 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-31 21:41:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:06.000000Z","updated_at":"2025-03-17T18:29:06.000000Z","inspection_violations":[{"id":119345,"change_date":"2022-03-31 21:41:00","inspection_id":"75187218","insp_violation_id":"244887404","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":"1DYK22033106504","created_at":"2025-03-17T21:07:37.000000Z","updated_at":"2025-03-17T21:07:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":131291,"change_date":"2022-03-31 21:41:00","inspection_id":"75187218","insp_unit_id":"187919280","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"23","insp_unit_license":"FJ1094","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG80D630551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"},{"id":131292,"change_date":"2022-03-31 21:41:00","inspection_id":"75187218","insp_unit_id":"187919281","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MERI","insp_unit_company":"3","insp_unit_license":"DN4014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1MT2N5322HH025765","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:02.000000Z","updated_at":"2025-03-17T22:09:02.000000Z"}]},{"id":35331,"change_date":"2022-03-24 21:31:00","inspection_id":"75130658","dot_number":"1847633","report_state":"IA","report_number":"000TT6NFDV","insp_date":"2022-03-21 00:00:00","insp_start_time":"1213","insp_end_time":"1224","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 WB","county_code_state":"IA","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANSCHAU","shipping_paper_number":"SELF","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":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"1216764","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01847633","upload_search_indicator":"M","census_search_date":"2022-03-24 21:31:00","snet_input_date":"2022-03-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"RANSCHAU LIVESTOCK LLC","insp_carrier_street":"3567 DOGWOOD AVE","insp_carrier_city":"ROCK VALLEY","insp_carrier_state":"IA","insp_carrier_zip_code":"51247","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:08.000000Z","updated_at":"2025-03-17T18:28:08.000000Z","inspection_violations":[{"id":50302,"change_date":"2022-03-24 21:31:00","inspection_id":"75130658","insp_violation_id":"244759831","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:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":56894,"change_date":"2022-03-24 21:31:00","inspection_id":"75130658","insp_unit_id":"187803190","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"FJ1095","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWDB9X38R222781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"},{"id":56895,"change_date":"2022-03-24 21:31:00","inspection_id":"75130658","insp_unit_id":"187803191","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"9444","insp_unit_license":"HA9444","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1UAS2529D537788","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1847633\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1847633\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1847633\/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\/1847633\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}