{"current_page":1,"data":[{"id":12030538,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","dot_number":"1867917","report_state":"IA","report_number":"000P156P29","insp_date":"2026-05-26 00:00:00","insp_start_time":"0944","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SB HWY 59 - 620TH ST","county_code_state":"IA","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MINNESOTA SPYBEAN PROCESSORS","shipping_paper_number":"50304437","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":"2026-05-27 21:40: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":"1402581","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-05-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-27 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-30T09:39:36.000000Z","updated_at":"2026-06-07T09:31:18.000000Z","inspection_violations":[{"id":20933797,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","insp_violation_id":"274533076","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":"2026-05-30T09:57:58.000000Z","updated_at":"2026-06-07T09:43:16.000000Z","normalized_code":"3922SLLS2"},{"id":20933795,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","insp_violation_id":"274533074","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"213778507","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:57:58.000000Z","updated_at":"2026-06-07T09:43:16.000000Z","normalized_code":"39617C"},{"id":20933796,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","insp_violation_id":"274533075","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"213778508","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-30T09:57:58.000000Z","updated_at":"2026-06-07T09:43:16.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":20910898,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","insp_unit_id":"213778507","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"720","insp_unit_license":"FW2770","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300008126158NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:43.000000Z","updated_at":"2026-06-07T09:03:09.000000Z"},{"id":20910899,"change_date":"2026-05-27 21:40:00","inspection_id":"87970669","insp_unit_id":"213778508","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"100","insp_unit_license":"KM0951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K8523XR2277980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-30T09:17:43.000000Z","updated_at":"2026-06-07T09:03:09.000000Z"}]},{"id":11771012,"change_date":"2026-04-28 21:39:00","inspection_id":"87701800","dot_number":"1867917","report_state":"IA","report_number":"000P10GGSW","insp_date":"2026-04-27 00:00:00","insp_start_time":"1730","insp_end_time":"1752","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 141\/ TIMBER AVE COON RAPID","county_code_state":"IA","county_code":"027","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1398847","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:30.000000Z","updated_at":"2026-05-09T09:31:07.000000Z","inspection_violations":[{"id":20466780,"change_date":"2026-04-28 21:39:00","inspection_id":"87701800","insp_violation_id":"273908046","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":"2026-05-01T10:02:12.000000Z","updated_at":"2026-05-09T09:42:18.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20478280,"change_date":"2026-04-28 21:39:00","inspection_id":"87701800","insp_unit_id":"213270525","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:47.000000Z","updated_at":"2026-05-09T09:03:40.000000Z"},{"id":20478281,"change_date":"2026-04-28 21:39:00","inspection_id":"87701800","insp_unit_id":"213270526","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"330","insp_unit_license":"MJ9643","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65335T5572415","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:47.000000Z","updated_at":"2026-05-09T09:03:40.000000Z"}]},{"id":11711246,"change_date":"2026-04-21 21:39:00","inspection_id":"87638252","dot_number":"1867917","report_state":"IA","report_number":"000P16DM8F","insp_date":"2026-04-10 00:00:00","insp_start_time":"1810","insp_end_time":"1825","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"WB HWY 20, DIKE","county_code_state":"IA","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OWN","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-04-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"1396889","transaction_code":"A","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":null,"census_search_date":"2026-04-21 21:39:00","snet_input_date":"2026-04-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-21 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:38:08.000000Z","updated_at":"2026-05-02T09:31:07.000000Z","inspection_violations":[{"id":20354162,"change_date":"2026-04-21 21:39:00","inspection_id":"87638252","insp_violation_id":"273753618","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"213141420","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:55:42.000000Z","updated_at":"2026-05-02T09:43:26.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20379912,"change_date":"2026-04-21 21:39:00","inspection_id":"87638252","insp_unit_id":"213141419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"740","insp_unit_license":"FX7202","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300008130254NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:33.000000Z","updated_at":"2026-05-02T09:03:40.000000Z"},{"id":20379913,"change_date":"2026-04-21 21:39:00","inspection_id":"87638252","insp_unit_id":"213141420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:14:33.000000Z","updated_at":"2026-05-02T09:03:40.000000Z"}]},{"id":11334720,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","dot_number":"1867917","report_state":"IA","report_number":"000P16D9WC","insp_date":"2026-03-09 00:00:00","insp_start_time":"1458","insp_end_time":"1520","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 7 W","county_code_state":"IA","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BNBROKENRAGE","shipping_paper_number":"7036499","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":"2026-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","viol_total":"5","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1393104","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-03-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-03-10 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:54.000000Z","updated_at":"2026-03-21T09:31:27.000000Z","inspection_violations":[{"id":19083243,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_violation_id":"272311444","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9CUR26030915043","created_at":"2026-03-13T10:05:06.000000Z","updated_at":"2026-03-21T09:49:25.000000Z","normalized_code":"3922SLLEWG2"},{"id":19083244,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_violation_id":"272311445","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9CUR26030915052","created_at":"2026-03-13T10:05:06.000000Z","updated_at":"2026-03-21T09:49:25.000000Z","normalized_code":"3922SLLEWA3"},{"id":19083245,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_violation_id":"272311446","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA2","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":"2026-03-13T10:05:06.000000Z","updated_at":"2026-03-21T09:49:25.000000Z","normalized_code":"3922SLLEWA2"},{"id":19083246,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_violation_id":"272311447","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":null,"created_at":"2026-03-13T10:05:06.000000Z","updated_at":"2026-03-21T09:49:25.000000Z","normalized_code":"3922SLLEWA1"},{"id":19083247,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_violation_id":"272311448","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212064672","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:05:06.000000Z","updated_at":"2026-03-21T09:49:25.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19396582,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_unit_id":"212064672","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"TRAC","insp_unit_company":"720","insp_unit_license":"FW2770","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300008126158NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:25.000000Z","updated_at":"2026-03-21T09:11:32.000000Z"},{"id":19396583,"change_date":"2026-03-10 21:39:00","inspection_id":"87252009","insp_unit_id":"212064673","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":null,"insp_unit_license":"KM0951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K8523XR2277980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:25.000000Z","updated_at":"2026-03-21T09:11:32.000000Z"}]},{"id":10557167,"change_date":"2026-01-02 21:35:00","inspection_id":"86694334","dot_number":"1867917","report_state":"NE","report_number":"T074000298","insp_date":"2026-01-02 00:00:00","insp_start_time":"0939","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":"12","location_desc":"WAVERLY WEST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MASHOFF","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":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"138200","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":"832727","transaction_code":"A","transaction_date":"2026-01-02 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-02 00:00:00","source_office":"3NES001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:37.000000Z","updated_at":"2026-01-13T10:30:26.000000Z","inspection_violations":[{"id":17731273,"change_date":"2026-01-02 21:35:00","inspection_id":"86694334","insp_violation_id":"270986418","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"ET1002248","created_at":"2026-01-05T10:37:06.000000Z","updated_at":"2026-01-13T10:30:55.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":17687164,"change_date":"2026-01-02 21:35:00","inspection_id":"86694334","insp_unit_id":"210887063","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"310","insp_unit_license":"FV7949","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300001093390NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:07.000000Z","updated_at":"2026-01-13T10:00:36.000000Z"},{"id":17687165,"change_date":"2026-01-02 21:35:00","inspection_id":"86694334","insp_unit_id":"210887064","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"320","insp_unit_license":"KM1023","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65335R5566977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:07.000000Z","updated_at":"2026-01-13T10:00:36.000000Z"}]},{"id":10217675,"change_date":"2025-11-17 21:39:00","inspection_id":"86339322","dot_number":"1867917","report_state":"IA","report_number":"000P120F9M","insp_date":"2025-11-14 00:00:00","insp_start_time":"0714","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3 WB \/ SINCLAIR AVE","county_code_state":"IA","county_code":"023","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"IOWA SELECT FARMS","shipping_paper_number":"I150026","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-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144480","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":"1381056","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:33.000000Z","updated_at":"2025-11-21T10:30:48.000000Z","inspection_violations":[{"id":16979812,"change_date":"2025-11-17 21:39:00","inspection_id":"86339322","insp_violation_id":"270003410","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-11-20T10:30:54.000000Z","updated_at":"2025-11-21T10:31:15.000000Z","normalized_code":"3922SLLS2"},{"id":16979813,"change_date":"2025-11-17 21:39:00","inspection_id":"86339322","insp_violation_id":"270003411","seq_no":"2","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"210070021","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:30:54.000000Z","updated_at":"2025-11-21T10:31:15.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":17022125,"change_date":"2025-11-17 21:39:00","inspection_id":"86339322","insp_unit_id":"210070021","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:35.000000Z","updated_at":"2025-11-21T10:00:55.000000Z"},{"id":17022126,"change_date":"2025-11-17 21:39:00","inspection_id":"86339322","insp_unit_id":"210070022","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:35.000000Z","updated_at":"2025-11-21T10:00:55.000000Z"}]},{"id":8072223,"change_date":"2025-03-10 21:39:00","inspection_id":"84079832","dot_number":"1867917","report_state":"IA","report_number":"000P15CTNK","insp_date":"2025-03-07 00:00:00","insp_start_time":"1152","insp_end_time":"1207","registration_date":null,"region":"CT","ci_status_code":"C","location":"16","location_desc":"16 - I380 SB MM 53 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"IOWA SELECT","shipping_paper_number":"I37824","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-03-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"144480","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":"1352181","transaction_code":"A","transaction_date":"2025-03-10 00:00:00","upload_date":"2025-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-10 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:52.000000Z","updated_at":"2025-03-17T21:05:52.000000Z","inspection_violations":[{"id":12616258,"change_date":"2025-03-10 21:39:00","inspection_id":"84079832","insp_violation_id":"264925005","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"205713726","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"39021TB"},{"id":12616259,"change_date":"2025-03-10 21:39:00","inspection_id":"84079832","insp_violation_id":"264925006","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205713726","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:43.000000Z","updated_at":"2025-03-17T22:07:43.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":13033526,"change_date":"2025-03-10 21:39:00","inspection_id":"84079832","insp_unit_id":"205713726","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:01.000000Z","updated_at":"2025-03-17T23:59:01.000000Z"},{"id":13033527,"change_date":"2025-03-10 21:39:00","inspection_id":"84079832","insp_unit_id":"205713727","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:01.000000Z","updated_at":"2025-03-17T23:59:01.000000Z"}]},{"id":7864742,"change_date":"2025-02-13 21:40:00","inspection_id":"83861877","dot_number":"1867917","report_state":"IA","report_number":"000P1271PB","insp_date":"2025-02-12 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"120TH AVE & EXPANSION BLVD","county_code_state":"IA","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BIG STONE","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":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1349443","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12289784,"change_date":"2025-02-13 21:40:00","inspection_id":"83861877","insp_violation_id":"264505693","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":"1CLA25021209500","created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"39216"},{"id":12289785,"change_date":"2025-02-13 21:40:00","inspection_id":"83861877","insp_violation_id":"264505694","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"205313730","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":12693655,"change_date":"2025-02-13 21:40:00","inspection_id":"83861877","insp_unit_id":"205313729","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"700","insp_unit_license":"FT4914","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9X46N888591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"},{"id":12693656,"change_date":"2025-02-13 21:40:00","inspection_id":"83861877","insp_unit_id":"205313730","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"180","insp_unit_license":"JU1825","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A2H5552136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"}]},{"id":7356860,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","dot_number":"1867917","report_state":"IA","report_number":"000P14ZMGW","insp_date":"2024-11-26 00:00:00","insp_start_time":"0659","insp_end_time":"0720","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 E OF CORRECTIONVILLE","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOEFLING TRUCKING","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":"2024-12-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1340912","transaction_code":"A","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-11-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-06 21:43:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:26.000000Z","updated_at":"2025-03-17T20:49:26.000000Z","inspection_violations":[{"id":11497033,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_violation_id":"263288596","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":"4HAN24112607063","created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922SLLS2"},{"id":11497034,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_violation_id":"263288597","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204232319","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922RG"},{"id":11497035,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_violation_id":"263288598","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204232320","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922RG"},{"id":11497036,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_violation_id":"263288599","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"204232320","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"3922RG"},{"id":11497037,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_violation_id":"263288600","seq_no":"5","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204232319","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:56.000000Z","updated_at":"2025-03-17T22:01:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":11867377,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_unit_id":"204232319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"TRAC","insp_unit_company":"720","insp_unit_license":"FW2770","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300008126158NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:01.000000Z","updated_at":"2025-03-17T23:46:01.000000Z"},{"id":11867378,"change_date":"2024-12-06 21:43:00","inspection_id":"83328433","insp_unit_id":"204232320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"100","insp_unit_license":"KM0951","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K8523XR2277980","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:01.000000Z","updated_at":"2025-03-17T23:46:01.000000Z"}]},{"id":6165806,"change_date":"2024-07-08 21:43:00","inspection_id":"82060952","dot_number":"1867917","report_state":"IA","report_number":"000P1698QX","insp_date":"2024-07-02 00:00:00","insp_start_time":"1141","insp_end_time":"1201","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/180TH ST","county_code_state":"IA","county_code":"187","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":"2024-07-08 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","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":"1319500","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":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-08 21:43:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:59.000000Z","updated_at":"2025-03-17T20:24:59.000000Z","inspection_violations":[{"id":9570404,"change_date":"2024-07-08 21:43:00","inspection_id":"82060952","insp_violation_id":"260510450","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"3922"},{"id":9570405,"change_date":"2024-07-08 21:43:00","inspection_id":"82060952","insp_violation_id":"260510451","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"201773422","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:19.000000Z","updated_at":"2025-03-17T21:52:19.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":9932367,"change_date":"2024-07-08 21:43:00","inspection_id":"82060952","insp_unit_id":"201773422","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","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":9932368,"change_date":"2024-07-08 21:43:00","inspection_id":"82060952","insp_unit_id":"201773423","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","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":5233638,"change_date":"2024-03-07 21:38:00","inspection_id":"81048360","dot_number":"1867917","report_state":"IA","report_number":"000P13RP9G","insp_date":"2024-03-06 00:00:00","insp_start_time":"1931","insp_end_time":"1945","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB HWY 30","county_code_state":"IA","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOEFLING TRUCKING LLC","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-03-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"138000","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":"1305228","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-03-07 21:38:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:14.000000Z","updated_at":"2025-03-17T20:06:14.000000Z","inspection_violations":[{"id":8069718,"change_date":"2024-03-07 21:38:00","inspection_id":"81048360","insp_violation_id":"258260204","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:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8427431,"change_date":"2024-03-07 21:38:00","inspection_id":"81048360","insp_unit_id":"199802342","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"},{"id":8427432,"change_date":"2024-03-07 21:38:00","inspection_id":"81048360","insp_unit_id":"199802343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILSON","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":5114747,"change_date":"2024-02-22 21:43:00","inspection_id":"80918696","dot_number":"1867917","report_state":"NE","report_number":"T137001086","insp_date":"2024-02-20 00:00:00","insp_start_time":"0817","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"12","location_desc":"WAVERLY WEST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EAGLE","shipping_paper_number":"TM220984","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-02-22 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"144580","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":"782155","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":null,"census_search_date":"2024-02-22 21:43:00","snet_input_date":"2024-02-22 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-02-22 21:43:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:51.000000Z","updated_at":"2025-03-17T20:03:51.000000Z","inspection_violations":[{"id":7887200,"change_date":"2024-02-22 21:43:00","inspection_id":"80918696","insp_violation_id":"257986217","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":"EB4003925","created_at":"2025-03-17T21:44:07.000000Z","updated_at":"2025-03-17T21:44:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8234621,"change_date":"2024-02-22 21:43:00","inspection_id":"80918696","insp_unit_id":"199555243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"},{"id":8234622,"change_date":"2024-02-22 21:43:00","inspection_id":"80918696","insp_unit_id":"199555244","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILS","insp_unit_company":"310","insp_unit_license":"JX7232","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65336R5565918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:37.000000Z","updated_at":"2025-03-17T23:09:37.000000Z"}]},{"id":4373516,"change_date":"2023-11-07 21:40:00","inspection_id":"80106664","dot_number":"1867917","report_state":"IA","report_number":"000TT6D6SP","insp_date":"2023-11-06 00:00:00","insp_start_time":"1145","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOEFLING","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"143000","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":"1293254","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-11-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:33.000000Z","updated_at":"2025-03-17T19:49:33.000000Z","inspection_violations":[{"id":6765594,"change_date":"2023-11-07 21:40:00","inspection_id":"80106664","insp_violation_id":"256265163","seq_no":"1","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":"9CUR23110611551","created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39216A"},{"id":6765595,"change_date":"2023-11-07 21:40:00","inspection_id":"80106664","insp_violation_id":"256265164","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"197947456","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":7033665,"change_date":"2023-11-07 21:40:00","inspection_id":"80106664","insp_unit_id":"197947456","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"690","insp_unit_license":"FS7638","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X3LD629130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:02.000000Z","updated_at":"2025-03-17T22:59:02.000000Z"},{"id":7033666,"change_date":"2023-11-07 21:40:00","inspection_id":"80106664","insp_unit_id":"197947457","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"300","insp_unit_license":"JF8902","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65332P5563905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:02.000000Z","updated_at":"2025-03-17T22:59:02.000000Z"}]},{"id":3577918,"change_date":"2023-07-24 21:42:00","inspection_id":"79221619","dot_number":"1867917","report_state":"IA","report_number":"000TT6CXMH","insp_date":"2023-07-19 00:00:00","insp_start_time":"0729","insp_end_time":"0821","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB","county_code_state":"IA","county_code":"187","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-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281773","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[{"id":5516155,"change_date":"2023-07-24 21:42:00","inspection_id":"79221619","insp_violation_id":"254235053","seq_no":"1","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":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39216A"},{"id":5516156,"change_date":"2023-07-24 21:42:00","inspection_id":"79221619","insp_violation_id":"254235054","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1WIN23071907455","created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":5752814,"change_date":"2023-07-24 21:42:00","inspection_id":"79221619","insp_unit_id":"196156352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"700","insp_unit_license":"FT4914","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9X46N888591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"},{"id":5752815,"change_date":"2023-07-24 21:42:00","inspection_id":"79221619","insp_unit_id":"196156353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"120","insp_unit_license":"0959EK","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A2E5544808","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":3179619,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","dot_number":"1867917","report_state":"IA","report_number":"000TT6NGFQ","insp_date":"2023-05-23 00:00:00","insp_start_time":"1751","insp_end_time":"1815","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 4 NB","county_code_state":"IA","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOEFLING","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-05-31 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1277188","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-31 21:42:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:47.000000Z","updated_at":"2025-03-17T19:25:47.000000Z","inspection_violations":[{"id":4899977,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","insp_violation_id":"253182224","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:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"3922"},{"id":4899978,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","insp_violation_id":"253182225","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195229629","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"3922"},{"id":4899979,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","insp_violation_id":"253182226","seq_no":"3","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:46.000000Z","updated_at":"2025-03-17T21:29:46.000000Z","normalized_code":"39019B2"}],"inspection_per_units":[{"id":5114346,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","insp_unit_id":"195229629","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"TRAC","insp_unit_company":"720","insp_unit_license":"FV9369","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"0V2300008126158NE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:18.000000Z","updated_at":"2025-03-17T22:43:18.000000Z"},{"id":5114347,"change_date":"2023-05-31 21:42:00","inspection_id":"78773295","insp_unit_id":"195229630","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"90","insp_unit_license":"JA2953","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W18523A4J2270509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:18.000000Z","updated_at":"2025-03-17T22:43:18.000000Z"}]},{"id":2851638,"change_date":"2023-04-20 21:42:00","inspection_id":"78402693","dot_number":"1867917","report_state":"IA","report_number":"000TT6PQSB","insp_date":"2023-04-18 00:00:00","insp_start_time":"1300","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 30WB\/MONTEREY DR","county_code_state":"IA","county_code":"027","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LOUIS DREYFUS","shipping_paper_number":"82158","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":"114000","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":"1271401","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":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-20 21:42:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:17.000000Z","updated_at":"2025-03-17T19:19:17.000000Z","inspection_violations":[{"id":4374915,"change_date":"2023-04-20 21:42:00","inspection_id":"78402693","insp_violation_id":"252340550","seq_no":"1","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":null,"created_at":"2025-03-17T21:27:25.000000Z","updated_at":"2025-03-17T21:27:25.000000Z","normalized_code":"39216A"},{"id":4374916,"change_date":"2023-04-20 21:42:00","inspection_id":"78402693","insp_violation_id":"252340551","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"194496143","insp_violation_category_id":"30","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":4588643,"change_date":"2023-04-20 21:42:00","inspection_id":"78402693","insp_unit_id":"194496142","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"700","insp_unit_license":"FT4914","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9X46N888591","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":4588644,"change_date":"2023-04-20 21:42:00","inspection_id":"78402693","insp_unit_id":"194496143","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"90","insp_unit_license":"JA2953","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W18523A4J2270509","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":2765884,"change_date":"2023-04-12 21:40:00","inspection_id":"78305727","dot_number":"1867917","report_state":"IA","report_number":"000TT66VHD","insp_date":"2023-04-06 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 NB 166 MM RAMP LATIMER","county_code_state":"IA","county_code":"069","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MASCHHOFF FARMS","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":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1269897","transaction_code":"C","transaction_date":"2023-04-11 00:00:00","upload_date":"2023-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4243623,"change_date":"2023-04-12 21:40:00","inspection_id":"78305727","insp_violation_id":"252174617","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"194345946","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":4451517,"change_date":"2023-04-12 21:40:00","inspection_id":"78305727","insp_unit_id":"194345946","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"660","insp_unit_license":"VC2825","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG00D390329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"},{"id":4451518,"change_date":"2023-04-12 21:40:00","inspection_id":"78305727","insp_unit_id":"194345947","insp_unit_type_id":"11","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"240","insp_unit_license":"HS3692","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65339M5560317","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:03.000000Z","updated_at":"2025-03-17T22:38:03.000000Z"}]},{"id":2602024,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","dot_number":"1867917","report_state":"IA","report_number":"000TT87STC","insp_date":"2023-03-14 00:00:00","insp_start_time":"1039","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"INTERSTATE 29 NB","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":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-03-17 21:42: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":"1266177","transaction_code":"A","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-17 21:42:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:48.000000Z","updated_at":"2025-03-17T19:14:48.000000Z","inspection_violations":[{"id":4002613,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","insp_violation_id":"251729696","seq_no":"1","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":"T10823031410525","created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"39216A"},{"id":4002614,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","insp_violation_id":"251729697","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193931749","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"},{"id":4002615,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","insp_violation_id":"251729698","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193931750","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:47.000000Z","updated_at":"2025-03-17T21:25:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4188304,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","insp_unit_id":"193931749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"700","insp_unit_license":"FT4914","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XP5DB9X46N888591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"},{"id":4188305,"change_date":"2023-03-17 21:42:00","inspection_id":"78119165","insp_unit_id":"193931750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"90","insp_unit_license":"JA2953","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W18523A4J2270509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:01.000000Z","updated_at":"2025-03-17T22:36:01.000000Z"}]},{"id":2511740,"change_date":"2023-03-06 21:40:00","inspection_id":"78016137","dot_number":"1867917","report_state":"IA","report_number":"000TT82GL6","insp_date":"2023-02-28 00:00:00","insp_start_time":"1715","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB & TIMBER AVE","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MACHOFFS","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-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"1264289","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:56.000000Z","updated_at":"2025-03-17T19:12:56.000000Z","inspection_violations":[{"id":3862065,"change_date":"2023-03-06 21:40:00","inspection_id":"78016137","insp_violation_id":"251491384","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193720912","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4042468,"change_date":"2023-03-06 21:40:00","inspection_id":"78016137","insp_unit_id":"193720911","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"600","insp_unit_license":"SF6514","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X0AD798583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"},{"id":4042469,"change_date":"2023-03-06 21:40:00","inspection_id":"78016137","insp_unit_id":"193720912","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"170","insp_unit_license":"JF8901","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533AXH5551428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"}]},{"id":2511978,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","dot_number":"1867917","report_state":"IA","report_number":"000TT6NG4P","insp_date":"2023-02-24 00:00:00","insp_start_time":"1115","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOEFLING","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1265253","transaction_code":"A","transaction_date":"2023-03-06 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:56.000000Z","updated_at":"2025-03-17T19:12:56.000000Z","inspection_violations":[{"id":3862557,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492079","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3922"},{"id":3862558,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492080","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39311"},{"id":3862559,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492081","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39395A"},{"id":3862560,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492082","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"},{"id":3862561,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492083","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"3939A"},{"id":3862562,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492084","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39378"},{"id":3862563,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_violation_id":"251492085","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193721437","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:10.000000Z","updated_at":"2025-03-17T21:25:10.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4042893,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_unit_id":"193721437","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"690","insp_unit_license":"FS7638","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X3LD629130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"},{"id":4042894,"change_date":"2023-03-06 21:40:00","inspection_id":"78016424","insp_unit_id":"193721438","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"300","insp_unit_license":"JF8902","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65332P5563905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:58.000000Z","updated_at":"2025-03-17T22:34:58.000000Z"}]},{"id":2435041,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","dot_number":"1867917","report_state":"IA","report_number":"000TT8C4XC","insp_date":"2023-02-20 00:00:00","insp_start_time":"2250","insp_end_time":"2330","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I35 SB MM 90 ANKENY","county_code_state":"IA","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE MASCHHOFFS","shipping_paper_number":"229985","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":"2023-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1263506","transaction_code":"A","transaction_date":"2023-02-23 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[{"id":3748736,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_violation_id":"251299368","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"193546374","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"39021TB"},{"id":3748737,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_violation_id":"251299369","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193546374","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"},{"id":3748738,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_violation_id":"251299370","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":"T14923022023221","created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"},{"id":3748739,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_violation_id":"251299371","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:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3918739,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_unit_id":"193546374","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"600","insp_unit_license":"SF6514","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X0AD798583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"},{"id":3918740,"change_date":"2023-02-23 21:40:00","inspection_id":"77929096","insp_unit_id":"193546375","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"1T","insp_unit_license":"JF8901","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533AXH5551428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:03.000000Z","updated_at":"2025-03-17T22:34:03.000000Z"}]},{"id":2324991,"change_date":"2023-02-08 21:39:00","inspection_id":"77803011","dot_number":"1867917","report_state":"IA","report_number":"000TT82GJD","insp_date":"2023-02-07 00:00:00","insp_start_time":"1600","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"M43 SB & HWY 20","county_code_state":"IA","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"JACOBS","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-02-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"125350","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":"1261708","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-08 21:39:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:36.000000Z","updated_at":"2025-03-17T19:09:36.000000Z","inspection_violations":[{"id":3579783,"change_date":"2023-02-08 21:39:00","inspection_id":"77803011","insp_violation_id":"251015088","seq_no":"1","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":"T42423020716084","created_at":"2025-03-17T21:23:52.000000Z","updated_at":"2025-03-17T21:23:52.000000Z","normalized_code":"39216A"},{"id":3579784,"change_date":"2023-02-08 21:39:00","inspection_id":"77803011","insp_violation_id":"251015089","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193292955","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:52.000000Z","updated_at":"2025-03-17T21:23:52.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3741703,"change_date":"2023-02-08 21:39:00","inspection_id":"77803011","insp_unit_id":"193292954","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"690","insp_unit_license":"FS7638","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X3LD629130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"},{"id":3741704,"change_date":"2023-02-08 21:39:00","inspection_id":"77803011","insp_unit_id":"193292955","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"300","insp_unit_license":"JF8902","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65332P5563905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:48.000000Z","updated_at":"2025-03-17T22:32:48.000000Z"}]},{"id":1228853,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","dot_number":"1867917","report_state":"IA","report_number":"000TT6FBVV","insp_date":"2022-09-05 00:00:00","insp_start_time":"1720","insp_end_time":"1810","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 W.B.","county_code_state":"IA","county_code":"079","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240918","transaction_code":"A","transaction_date":"2022-09-07 00:00:00","upload_date":"2022-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-07 21:40:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:20.000000Z","updated_at":"2025-03-17T18:49:20.000000Z","inspection_violations":[{"id":1945726,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","insp_violation_id":"248255109","seq_no":"3","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"38351A"},{"id":1945727,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","insp_violation_id":"248255110","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:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"3922"},{"id":1945728,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","insp_violation_id":"248255111","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T45422090517545","created_at":"2025-03-17T21:15:59.000000Z","updated_at":"2025-03-17T21:15:59.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1977365,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","insp_unit_id":"190762759","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"600","insp_unit_license":"SF6514","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X0AD798583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:36.000000Z","updated_at":"2025-03-17T22:20:36.000000Z"},{"id":1977366,"change_date":"2022-09-07 21:40:00","inspection_id":"76543989","insp_unit_id":"190762760","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"170","insp_unit_license":"JF8902","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533AXH5551428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:36.000000Z","updated_at":"2025-03-17T22:20:36.000000Z"}]},{"id":376837,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","dot_number":"1867917","report_state":"IA","report_number":"000TT66V22","insp_date":"2022-05-11 00:00:00","insp_start_time":"1208","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1224582","transaction_code":"A","transaction_date":"2022-05-12 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:02.000000Z","updated_at":"2025-03-17T18:34:02.000000Z","inspection_violations":[{"id":590083,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_violation_id":"245750769","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188650041","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"39617C"},{"id":590084,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_violation_id":"245750770","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"3922"},{"id":590085,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_violation_id":"245750771","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188650042","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"39617C"},{"id":590086,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_violation_id":"245750772","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":null,"created_at":"2025-03-17T21:09:48.000000Z","updated_at":"2025-03-17T21:09:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":609287,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_unit_id":"188650041","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"690","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X3LD629130","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:55.000000Z","updated_at":"2025-03-17T22:11:55.000000Z"},{"id":609288,"change_date":"2022-05-12 21:41:00","inspection_id":"75542328","insp_unit_id":"188650042","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"170","insp_unit_license":"AN2640","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W16533A2H5552136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:55.000000Z","updated_at":"2025-03-17T22:11:55.000000Z"}]},{"id":329249,"change_date":"2022-05-05 21:41:00","inspection_id":"75485729","dot_number":"1867917","report_state":"NE","report_number":"00XN003709","insp_date":"2022-05-05 00:00:00","insp_start_time":"0743","insp_end_time":"0819","registration_date":null,"region":"CT","ci_status_code":"C","location":"WWB","location_desc":"WAVERLY WEST BOUND","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"IDA #2","shipping_paper_number":"TM173226","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"94000","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":"731015","transaction_code":"A","transaction_date":"2022-05-05 00:00:00","upload_date":"2022-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-05 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-05-05 21:41:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:19.000000Z","updated_at":"2025-03-17T18:33:19.000000Z","inspection_violations":[{"id":513864,"change_date":"2022-05-05 21:41:00","inspection_id":"75485729","insp_violation_id":"245602537","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":"EB4002130","created_at":"2025-03-17T21:09:27.000000Z","updated_at":"2025-03-17T21:09:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":532612,"change_date":"2022-05-05 21:41:00","inspection_id":"75485729","insp_unit_id":"188528883","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"660","insp_unit_license":"VC2825","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NPXGGGG00D390329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:28.000000Z","updated_at":"2025-03-17T22:11:28.000000Z"},{"id":532613,"change_date":"2022-05-05 21:41:00","inspection_id":"75485729","insp_unit_id":"188528884","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"240","insp_unit_license":"HS3692","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K655339M556031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:28.000000Z","updated_at":"2025-03-17T22:11:28.000000Z"}]},{"id":61679,"change_date":"2022-03-29 21:42:00","inspection_id":"75163828","dot_number":"1867917","report_state":"IA","report_number":"000TT7FM5H","insp_date":"2022-03-25 00:00:00","insp_start_time":"0649","insp_end_time":"0702","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 140 SB KINGSLEY","county_code_state":"IA","county_code":"193","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NEW ERA","shipping_paper_number":"SWINE 176","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-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1217497","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01867917","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"HOEFLING TRUCKING LLC","insp_carrier_street":"1645 325TH ST","insp_carrier_city":"ODEBOLT","insp_carrier_state":"IA","insp_carrier_zip_code":"51458","insp_colonia":null,"docket_number":"675150","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[{"id":88488,"change_date":"2022-03-29 21:42:00","inspection_id":"75163828","insp_violation_id":"244832829","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:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3922"},{"id":88489,"change_date":"2022-03-29 21:42:00","inspection_id":"75163828","insp_violation_id":"244832830","seq_no":"2","part_no":"390","part_no_section":"21T(a)","insp_viol_unit":"1","insp_unit_id":"187871721","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"39021TA"}],"inspection_per_units":[{"id":100128,"change_date":"2022-03-29 21:42:00","inspection_id":"75163828","insp_unit_id":"187871721","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"680","insp_unit_license":"VE8847","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1NKWGGGG30J254053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100129,"change_date":"2022-03-29 21:42:00","inspection_id":"75163828","insp_unit_id":"187871722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"250","insp_unit_license":"HW5833","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1W1K65339N5561968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1867917\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1867917\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1867917\/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\/1867917\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}