{"current_page":1,"data":[{"id":8430112,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","dot_number":"1517331","report_state":"IA","report_number":"000P14WSDB","insp_date":"2025-04-19 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"IA 3 WB 143 MM","county_code_state":"IA","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"16454","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-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1357194","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-24T10:03:06.000000Z","updated_at":"2025-04-26T10:24:35.000000Z","inspection_violations":[{"id":13307994,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","insp_violation_id":"265740368","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206415676","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:26:31.000000Z","updated_at":"2025-04-25T10:41:44.000000Z","normalized_code":"39617C"},{"id":13307995,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","insp_violation_id":"265740369","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"206415677","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-24T10:26:31.000000Z","updated_at":"2025-04-25T10:41:44.000000Z","normalized_code":"39375A3TAOL"},{"id":13307996,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","insp_violation_id":"265740370","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"206415676","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:26:31.000000Z","updated_at":"2025-04-25T10:41:44.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":13689326,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","insp_unit_id":"206415676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21","insp_unit_license":"KG1794","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:56:11.000000Z","updated_at":"2025-04-25T09:59:56.000000Z"},{"id":13689327,"change_date":"2025-04-21 21:40:00","inspection_id":"84456678","insp_unit_id":"206415677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"3","insp_unit_license":"KG1795","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:56:11.000000Z","updated_at":"2025-04-25T09:59:56.000000Z"}]},{"id":6165513,"change_date":"2024-07-08 21:43:00","inspection_id":"82060625","dot_number":"1517331","report_state":"IA","report_number":"000P10RB2Q","insp_date":"2024-07-04 00:00:00","insp_start_time":"0956","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"115 AVE AND 130 ST","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AG PROCESSING INC","shipping_paper_number":"109590","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-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"149700","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":"1319628","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2024-07-08 21:43:00","snet_input_date":"2024-07-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:59.000000Z","updated_at":"2025-03-17T20:24:59.000000Z","inspection_violations":[{"id":9569793,"change_date":"2024-07-08 21:43:00","inspection_id":"82060625","insp_violation_id":"260509614","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":"3DAV24070410144","created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9931844,"change_date":"2024-07-08 21:43:00","inspection_id":"82060625","insp_unit_id":"201772811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"JY1530","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGED58GSHS0742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:56.000000Z","updated_at":"2025-03-17T23:25:56.000000Z"},{"id":9931845,"change_date":"2024-07-08 21:43:00","inspection_id":"82060625","insp_unit_id":"201772812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"01","insp_unit_license":"GY3686","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSABB348KN091155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:56.000000Z","updated_at":"2025-03-17T23:25:56.000000Z"}]},{"id":5410359,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","dot_number":"1517331","report_state":"IA","report_number":"000P16D788","insp_date":"2024-03-30 00:00:00","insp_start_time":"1204","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 NB","county_code_state":"IA","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"09965","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-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","viol_total":"7","oos_total":"1","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1307734","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-03-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[{"id":8350055,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682493","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":"9CUR24033012461","created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8350056,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682494","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8350057,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682495","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9CUR24033012482","created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8350058,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682496","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8350059,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682497","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200179211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3939A"},{"id":8350060,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682498","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200179212","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3939A"},{"id":8350061,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_violation_id":"258682499","seq_no":"7","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"200179211","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":8713939,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_unit_id":"200179211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21","insp_unit_license":"KG1794","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"},{"id":8713940,"change_date":"2024-04-01 21:40:00","inspection_id":"81240841","insp_unit_id":"200179212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER","insp_unit_company":null,"insp_unit_license":"KG1795","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":4725773,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","dot_number":"1517331","report_state":"IA","report_number":"000P16985G","insp_date":"2023-12-26 00:00:00","insp_start_time":"0753","insp_end_time":"0819","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 30 EB\/HWY 17","county_code_state":"IA","county_code":"197","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":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1298367","transaction_code":"A","transaction_date":"2023-12-28 00:00:00","upload_date":"2023-12-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:31.000000Z","updated_at":"2025-03-17T19:56:31.000000Z","inspection_violations":[{"id":7296441,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","insp_violation_id":"257099345","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:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"3922"},{"id":7296442,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","insp_violation_id":"257099346","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198723036","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39617C"},{"id":7296443,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","insp_violation_id":"257099347","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198723037","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:13.000000Z","updated_at":"2025-03-17T21:41:13.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7601690,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","insp_unit_id":"198723036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"94","insp_unit_license":"KG1794","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"},{"id":7601691,"change_date":"2023-12-28 21:45:00","inspection_id":"80493449","insp_unit_id":"198723037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"95","insp_unit_license":"KG1795","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:58.000000Z","updated_at":"2025-03-17T23:03:58.000000Z"}]},{"id":4472796,"change_date":"2023-11-21 21:40:00","inspection_id":"80216043","dot_number":"1517331","report_state":"IA","report_number":"000P11SFFC","insp_date":"2023-11-20 00:00:00","insp_start_time":"0918","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 AND 180TH AVE","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"107497","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"1294281","transaction_code":"A","transaction_date":"2023-11-20 00:00:00","upload_date":"2023-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:26.000000Z","updated_at":"2025-03-17T19:51:26.000000Z","inspection_violations":[{"id":6923372,"change_date":"2023-11-21 21:40:00","inspection_id":"80216043","insp_violation_id":"256511874","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"198165226","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7193337,"change_date":"2023-11-21 21:40:00","inspection_id":"80216043","insp_unit_id":"198165225","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"7","insp_unit_license":"JY1530","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGED58GSHS0742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:24.000000Z","updated_at":"2025-03-17T23:00:24.000000Z"},{"id":7193338,"change_date":"2023-11-21 21:40:00","inspection_id":"80216043","insp_unit_id":"198165226","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"1","insp_unit_license":"GY3686","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSABB348KN091155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:24.000000Z","updated_at":"2025-03-17T23:00:24.000000Z"}]},{"id":4537877,"change_date":"2023-12-01 21:42:00","inspection_id":"80287589","dot_number":"1517331","report_state":"IA","report_number":"000TT6D6SK","insp_date":"2023-11-02 00:00:00","insp_start_time":"1118","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 NB","county_code_state":"IA","county_code":"091","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ERPELDING AND SONS","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":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"153000","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":"1295231","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:37.000000Z","updated_at":"2025-03-17T19:52:37.000000Z","inspection_violations":[{"id":7021012,"change_date":"2023-12-01 21:42:00","inspection_id":"80287589","insp_violation_id":"256664356","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:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7298141,"change_date":"2023-12-01 21:42:00","inspection_id":"80287589","insp_unit_id":"198305655","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"EY7951","insp_unit_license":"EY7951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR48C690386","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"},{"id":7298142,"change_date":"2023-12-01 21:42:00","inspection_id":"80287589","insp_unit_id":"198305656","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER","insp_unit_company":"GY3686","insp_unit_license":"GY3686","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSABB348KN091155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"}]},{"id":3879187,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","dot_number":"1517331","report_state":"IA","report_number":"000P1313N1","insp_date":"2023-08-30 00:00:00","insp_start_time":"0709","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"IA 17 & 130TH ST SB","county_code_state":"IA","county_code":"091","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-08-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"146700","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1287287","transaction_code":"A","transaction_date":"2023-08-31 00:00:00","upload_date":"2023-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-08-31 21:42:00","snet_input_date":"2023-08-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-31 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:25.000000Z","updated_at":"2025-03-17T19:39:25.000000Z","inspection_violations":[{"id":5994391,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","insp_violation_id":"255019640","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:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"},{"id":5994392,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","insp_violation_id":"255019641","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196842719","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"},{"id":5994393,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","insp_violation_id":"255019642","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196842720","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:00.000000Z","updated_at":"2025-03-17T21:35:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6236523,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","insp_unit_id":"196842719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21","insp_unit_license":"HB3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:24.000000Z","updated_at":"2025-03-17T22:52:24.000000Z"},{"id":6236524,"change_date":"2023-08-31 21:42:00","inspection_id":"79558409","insp_unit_id":"196842720","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"3","insp_unit_license":"GF4402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:24.000000Z","updated_at":"2025-03-17T22:52:24.000000Z"}]},{"id":3534045,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","dot_number":"1517331","report_state":"IA","report_number":"000TT6P10D","insp_date":"2023-07-17 00:00:00","insp_start_time":"0855","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 AND 570TH","county_code_state":"IA","county_code":"147","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"CRUDE OIL","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-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"138700","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":"1281427","transaction_code":"A","transaction_date":"2023-07-18 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-07-18 21:42:00","snet_input_date":"2023-07-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-18 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:50.000000Z","updated_at":"2025-03-17T19:32:50.000000Z","inspection_violations":[{"id":5448167,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","insp_violation_id":"254122868","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:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"3922"},{"id":5448168,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","insp_violation_id":"254122869","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4HAN23071709110","created_at":"2025-03-17T21:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"39216A"},{"id":5448169,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","insp_violation_id":"254122870","seq_no":"3","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4HAN23071709144","created_at":"2025-03-17T21:32:17.000000Z","updated_at":"2025-03-17T21:32:17.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":5682216,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","insp_unit_id":"196056408","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"JY1530","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGED58GSHS0742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"},{"id":5682217,"change_date":"2023-07-18 21:42:00","inspection_id":"79172168","insp_unit_id":"196056409","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALK","insp_unit_company":"9","insp_unit_license":"GY3686","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSABB348KN091155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"}]},{"id":2851825,"change_date":"2023-04-20 21:42:00","inspection_id":"78402924","dot_number":"1517331","report_state":"IA","report_number":"000TT6NG9N","insp_date":"2023-04-18 00:00:00","insp_start_time":"0915","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 ED","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"292093","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-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","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":"1271572","transaction_code":"A","transaction_date":"2023-04-20 00:00:00","upload_date":"2023-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-04-20 21:42:00","snet_input_date":"2023-04-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:17.000000Z","updated_at":"2025-03-17T19:19:17.000000Z","inspection_violations":[{"id":4375376,"change_date":"2023-04-20 21:42:00","inspection_id":"78402924","insp_violation_id":"252341125","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:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4588967,"change_date":"2023-04-20 21:42:00","inspection_id":"78402924","insp_unit_id":"194496557","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"JY1530","insp_unit_license":"JY1530","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGED58GSHS0742","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:10.000000Z","updated_at":"2025-03-17T22:39:10.000000Z"},{"id":4588968,"change_date":"2023-04-20 21:42:00","inspection_id":"78402924","insp_unit_id":"194496558","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER","insp_unit_company":"GY3698","insp_unit_license":"GY3686","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSABB348KN091155","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:10.000000Z","updated_at":"2025-03-17T22:39:10.000000Z"}]},{"id":2576433,"change_date":"2023-03-14 21:42:00","inspection_id":"78089885","dot_number":"1517331","report_state":"IA","report_number":"000TT6NG58","insp_date":"2023-03-07 00:00:00","insp_start_time":"0830","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 SB","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","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":"2023-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1265860","transaction_code":"A","transaction_date":"2023-03-14 00:00:00","upload_date":"2023-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2023-03-14 21:42:00","snet_input_date":"2023-03-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-14 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:07.000000Z","updated_at":"2025-03-17T19:14:07.000000Z","inspection_violations":[{"id":3964047,"change_date":"2023-03-14 21:42:00","inspection_id":"78089885","insp_violation_id":"251656346","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:25:37.000000Z","updated_at":"2025-03-17T21:25:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4146562,"change_date":"2023-03-14 21:42:00","inspection_id":"78089885","insp_unit_id":"193865943","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5266","insp_unit_license":"HB3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"},{"id":4146563,"change_date":"2023-03-14 21:42:00","inspection_id":"78089885","insp_unit_id":"193865944","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WALKER","insp_unit_company":"3","insp_unit_license":"GF4402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:44.000000Z","updated_at":"2025-03-17T22:35:44.000000Z"}]},{"id":1770598,"change_date":"2022-11-18 21:38:00","inspection_id":"77169404","dot_number":"1517331","report_state":"IA","report_number":"000TT6CWXH","insp_date":"2022-11-17 00:00:00","insp_start_time":"1027","insp_end_time":"1101","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 EB\/GOLDFIELD","county_code_state":"IA","county_code":"197","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1251787","transaction_code":"A","transaction_date":"2022-11-18 00:00:00","upload_date":"2022-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2022-11-18 21:38:00","snet_input_date":"2022-11-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-18 21:38:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:18.000000Z","updated_at":"2025-03-17T18:59:18.000000Z","inspection_violations":[{"id":2771431,"change_date":"2022-11-18 21:38:00","inspection_id":"77169404","insp_violation_id":"249677724","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192026416","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T22522111710424","created_at":"2025-03-17T21:20:01.000000Z","updated_at":"2025-03-17T21:20:01.000000Z","normalized_code":"39617C"},{"id":2771432,"change_date":"2022-11-18 21:38:00","inspection_id":"77169404","insp_violation_id":"249677725","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"192026417","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:01.000000Z","updated_at":"2025-03-17T21:20:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2848432,"change_date":"2022-11-18 21:38:00","inspection_id":"77169404","insp_unit_id":"192026416","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"55","insp_unit_license":"HB3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:29.000000Z","updated_at":"2025-03-17T22:26:29.000000Z"},{"id":2848433,"change_date":"2022-11-18 21:38:00","inspection_id":"77169404","insp_unit_id":"192026417","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"02","insp_unit_license":"GF4402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:29.000000Z","updated_at":"2025-03-17T22:26:29.000000Z"}]},{"id":202479,"change_date":"2022-04-19 21:42:00","inspection_id":"75334405","dot_number":"1517331","report_state":"IA","report_number":"000TT83KK1","insp_date":"2022-04-18 00:00:00","insp_start_time":"0801","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 NB N OF CORWITH","county_code_state":"IA","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AGP","shipping_paper_number":"471904","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":"2022-04-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1220707","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2022-04-19 21:42:00","snet_input_date":"2022-04-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-19 21:42:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:11.000000Z","updated_at":"2025-03-17T18:31:11.000000Z","inspection_violations":[{"id":309250,"change_date":"2022-04-19 21:42:00","inspection_id":"75334405","insp_violation_id":"245231675","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:08:28.000000Z","updated_at":"2025-03-17T21:08:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":328017,"change_date":"2022-04-19 21:42:00","inspection_id":"75334405","insp_unit_id":"188217690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"21","insp_unit_license":"HB3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:09.000000Z","updated_at":"2025-03-17T22:10:09.000000Z"},{"id":328018,"change_date":"2022-04-19 21:42:00","inspection_id":"75334405","insp_unit_id":"188217691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"3","insp_unit_license":"GF4402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:09.000000Z","updated_at":"2025-03-17T22:10:09.000000Z"}]},{"id":185247,"change_date":"2022-04-15 21:37:00","inspection_id":"75313941","dot_number":"1517331","report_state":"IA","report_number":"000TT6CWHN","insp_date":"2022-04-14 00:00:00","insp_start_time":"0751","insp_end_time":"0811","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 17 NB\/160TH ST","county_code_state":"IA","county_code":"197","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"SOYBEAN OIL","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-04-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1220264","transaction_code":"A","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01517331","upload_search_indicator":"M","census_search_date":"2022-04-15 21:37:00","snet_input_date":"2022-04-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-15 21:37:00","insp_carrier_name":"ERPELDING & SONS","insp_carrier_street":"207 WOODLYN WAY","insp_carrier_city":"ALGONA","insp_carrier_state":"IA","insp_carrier_zip_code":"50511","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:50.000000Z","updated_at":"2025-03-17T18:30:50.000000Z","inspection_violations":[{"id":282186,"change_date":"2022-04-15 21:37:00","inspection_id":"75313941","insp_violation_id":"245185138","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:08:22.000000Z","updated_at":"2025-03-17T21:08:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":299964,"change_date":"2022-04-15 21:37:00","inspection_id":"75313941","insp_unit_id":"188176316","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"HB3255","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKNGLDR0DSFF5266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:59.000000Z","updated_at":"2025-03-17T22:09:59.000000Z"},{"id":299965,"change_date":"2022-04-15 21:37:00","inspection_id":"75313941","insp_unit_id":"188176317","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUSM","insp_unit_company":"02","insp_unit_license":"GF4402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5WSAA5331HN049110","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:59.000000Z","updated_at":"2025-03-17T22:09:59.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1517331\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1517331\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1517331\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1517331\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}