{"current_page":1,"data":[{"id":12237972,"change_date":"2026-06-20 21:34:00","inspection_id":"88195757","dot_number":"172153","report_state":"NE","report_number":"T271000089","insp_date":"2026-06-19 00:00:00","insp_start_time":"1850","insp_end_time":"1910","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SOUTH BEND NE","county_code_state":"NE","county_code":"153","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE MERRILL COMPANY\/ ARNOLD MOTOR","shipping_paper_number":"BR60","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-20 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"589","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3582973","transaction_code":"A","transaction_date":"2026-06-20 00:00:00","upload_date":"2026-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":null,"census_search_date":"2026-06-20 21:34:00","snet_input_date":"2026-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-20 21:34:00","insp_carrier_name":"MERRIL COMPANY","insp_carrier_street":"601 1ST AVE","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-23T09:40:41.000000Z","updated_at":"2026-07-02T09:30:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21252899,"change_date":"2026-06-20 21:34:00","inspection_id":"88195757","insp_unit_id":"214200550","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"483934","insp_unit_license":"ATZ209","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"3ALACWFC4RDVJ5723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-23T09:16:55.000000Z","updated_at":"2026-07-01T09:00:49.000000Z"}]},{"id":12181198,"change_date":"2026-06-13 21:35:00","inspection_id":"88136525","dot_number":"172153","report_state":"IA","report_number":"205S000073","insp_date":"2026-06-12 00:00:00","insp_start_time":"1846","insp_end_time":"1905","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"IA","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"BR05","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-13 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3536079","transaction_code":"A","transaction_date":"2026-06-13 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":null,"census_search_date":"2026-06-13 21:35:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-13 21:35:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:49.000000Z","updated_at":"2026-06-24T09:30:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21158198,"change_date":"2026-06-13 21:35:00","inspection_id":"88136525","insp_unit_id":"214089147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"3035","insp_unit_license":"LE1442","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDZSZR7SN172029","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"},{"id":21158199,"change_date":"2026-06-13 21:35:00","inspection_id":"88136525","insp_unit_id":"214089148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"3021","insp_unit_license":"KN9892","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0627RB526370","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:21:04.000000Z","updated_at":"2026-06-24T09:01:32.000000Z"}]},{"id":11849119,"change_date":"2026-05-07 21:40:00","inspection_id":"87785108","dot_number":"172153","report_state":"NE","report_number":"T157000101","insp_date":"2026-05-07 00:00:00","insp_start_time":"1050","insp_end_time":"1125","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"GREENWOOD NE","county_code_state":"NE","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MCCOOK ARNOLD MOTOR SUPPLY","shipping_paper_number":"60T1133251","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3279324","transaction_code":"A","transaction_date":"2026-05-07 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:34.000000Z","updated_at":"2026-05-18T09:30:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20605789,"change_date":"2026-05-07 21:40:00","inspection_id":"87785108","insp_unit_id":"213431340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"483934","insp_unit_license":"ATZ209","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"3ALACWFC4RDVJ5723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-10T09:18:50.000000Z","updated_at":"2026-05-18T09:03:19.000000Z"}]},{"id":11719166,"change_date":"2026-04-22 21:39:00","inspection_id":"87646573","dot_number":"172153","report_state":"NE","report_number":"T390001630","insp_date":"2026-04-22 00:00:00","insp_start_time":"1117","insp_end_time":"1230","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WAVERLY NE","county_code_state":"NE","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3196361","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":null,"census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:21.000000Z","updated_at":"2026-05-03T09:30:47.000000Z","inspection_violations":[{"id":20373579,"change_date":"2026-04-22 21:39:00","inspection_id":"87646573","insp_violation_id":"273775338","seq_no":"1","part_no":"396","part_no_section":"3A1-BALAC","insp_viol_unit":"1","insp_unit_id":"213157143","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:58:06.000000Z","updated_at":"2026-05-03T09:42:15.000000Z","normalized_code":"3963A1BALAC"},{"id":20373580,"change_date":"2026-04-22 21:39:00","inspection_id":"87646573","insp_violation_id":"273775339","seq_no":"2","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"213157143","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"ET5005947","created_at":"2026-04-27T09:58:06.000000Z","updated_at":"2026-05-03T09:42:15.000000Z","normalized_code":"3963A1BOS"},{"id":20373581,"change_date":"2026-04-22 21:39:00","inspection_id":"87646573","insp_violation_id":"273775340","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"213157143","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:58:06.000000Z","updated_at":"2026-05-03T09:42:15.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":20392874,"change_date":"2026-04-22 21:39:00","inspection_id":"87646573","insp_unit_id":"213157143","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"320356","insp_unit_license":"3829827","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMML7KH584826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:16:38.000000Z","updated_at":"2026-05-03T09:03:32.000000Z"}]},{"id":11721852,"change_date":"2026-04-22 21:39:00","inspection_id":"87649425","dot_number":"172153","report_state":"IA","report_number":"000P13B23R","insp_date":"2026-04-21 00:00:00","insp_start_time":"0726","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22940","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1398252","transaction_code":"A","transaction_date":"2026-04-22 00:00:00","upload_date":"2026-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2026-04-22 21:39:00","snet_input_date":"2026-04-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:39:44.000000Z","updated_at":"2026-05-03T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20397193,"change_date":"2026-04-22 21:39:00","inspection_id":"87649425","insp_unit_id":"213162512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"5102","insp_unit_license":"PNN628","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVM4RH647458","insp_unit_decal":"Y","insp_unit_decal_number":"36425691","created_at":"2026-04-27T09:17:15.000000Z","updated_at":"2026-05-03T09:04:07.000000Z"}]},{"id":11227999,"change_date":"2026-02-25 21:49:00","inspection_id":"87140086","dot_number":"172153","report_state":"NE","report_number":"T370003097","insp_date":"2026-02-24 00:00:00","insp_start_time":"2328","insp_end_time":"2342","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 81, 2228 FEET NORTH","county_code_state":"NE","county_code":"169","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPECIALTY SALES","shipping_paper_number":"60T1098671","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-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"835170","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2026-02-25 21:49:00","snet_input_date":"2026-02-25 00:00:00","source_office":"3NES001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:30.000000Z","updated_at":"2026-03-08T09:32:16.000000Z","inspection_violations":[{"id":18850415,"change_date":"2026-02-25 21:49:00","inspection_id":"87140086","insp_violation_id":"272034294","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:57:03.000000Z","updated_at":"2026-03-08T09:50:00.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":19193088,"change_date":"2026-02-25 21:49:00","inspection_id":"87140086","insp_unit_id":"211834584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"ATZ209","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"3ALACWFC4RDVJ5723","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:22.000000Z","updated_at":"2026-03-08T09:07:09.000000Z"}]},{"id":10378131,"change_date":"2025-12-08 21:38:00","inspection_id":"86507346","dot_number":"172153","report_state":"IA","report_number":"000P15MN4M","insp_date":"2025-11-15 00:00:00","insp_start_time":"0710","insp_end_time":"0730","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1383249","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-12-08 21:38:00","snet_input_date":"2025-11-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-08 21:38:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-11T10:30:33.000000Z","updated_at":"2025-12-12T10:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17347855,"change_date":"2025-12-08 21:38:00","inspection_id":"86507346","insp_unit_id":"210478675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"3","insp_unit_license":"PNN628","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVM4RH647458","insp_unit_decal":"Y","insp_unit_decal_number":"35813004","created_at":"2025-12-11T10:00:32.000000Z","updated_at":"2025-12-12T10:00:51.000000Z"}]},{"id":9566697,"change_date":"2025-09-02 21:39:00","inspection_id":"85655220","dot_number":"172153","report_state":"IA","report_number":"000P12HZQP","insp_date":"2025-08-29 00:00:00","insp_start_time":"1834","insp_end_time":"1903","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"BR30","cargo_tank":null,"hazmat_placard_req":"Y","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-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1372862","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-09-02 21:39:00","snet_input_date":"2025-08-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:02.000000Z","updated_at":"2025-09-06T10:43:02.000000Z","inspection_violations":[{"id":15623755,"change_date":"2025-09-02 21:39:00","inspection_id":"85655220","insp_violation_id":"268395932","seq_no":"1","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"208697790","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:22.000000Z","updated_at":"2025-09-06T10:47:22.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":15791300,"change_date":"2025-09-02 21:39:00","inspection_id":"85655220","insp_unit_id":"208697790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3022","insp_unit_license":"LE1460","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDZAPR7SN799021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:15.000000Z","updated_at":"2025-09-09T09:47:15.000000Z"},{"id":15791301,"change_date":"2025-09-02 21:39:00","inspection_id":"85655220","insp_unit_id":"208697791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"3023","insp_unit_license":"HX9647","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0622NB416417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:15.000000Z","updated_at":"2025-09-09T09:47:15.000000Z"}]},{"id":8369953,"change_date":"2025-04-14 21:41:00","inspection_id":"84393254","dot_number":"172153","report_state":"IA","report_number":"000P1271SH","insp_date":"2025-04-10 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1356162","transaction_code":"A","transaction_date":"2025-04-14 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-04-14 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:34.000000Z","updated_at":"2025-04-18T10:23:07.000000Z","inspection_violations":[{"id":13189749,"change_date":"2025-04-14 21:41:00","inspection_id":"84393254","insp_violation_id":"265606669","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206301141","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1CLA25041009193","created_at":"2025-04-17T10:26:14.000000Z","updated_at":"2025-04-18T10:43:29.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13583601,"change_date":"2025-04-14 21:41:00","inspection_id":"84393254","insp_unit_id":"206301141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3005","insp_unit_license":"OYJ092","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT9MED56092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:56:12.000000Z","updated_at":"2025-04-18T10:00:42.000000Z"}]},{"id":8276764,"change_date":"2025-04-02 21:41:00","inspection_id":"84295156","dot_number":"172153","report_state":"IA","report_number":"000P15PH4J","insp_date":"2025-03-28 00:00:00","insp_start_time":"0924","insp_end_time":"0951","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"48T0005311","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1354962","transaction_code":"A","transaction_date":"2025-04-01 00:00:00","upload_date":"2025-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-04-02 21:41:00","snet_input_date":"2025-03-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:53.000000Z","updated_at":"2025-04-06T10:23:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13397707,"change_date":"2025-04-02 21:41:00","inspection_id":"84295156","insp_unit_id":"206121134","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"3007","insp_unit_license":"PKB654","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNDL4RG229729","insp_unit_decal":"Y","insp_unit_decal_number":"34984805","created_at":"2025-04-05T10:12:24.000000Z","updated_at":"2025-04-06T10:00:01.000000Z"}]},{"id":7844599,"change_date":"2025-02-11 21:40:00","inspection_id":"83840825","dot_number":"172153","report_state":"IA","report_number":"000P16859P","insp_date":"2025-02-08 00:00:00","insp_start_time":"0943","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"THE MERILL COMPANY","shipping_paper_number":"48T000544","cargo_tank":null,"hazmat_placard_req":"Y","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-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"2","hazmat_oos_total":"0","snet_sequence_id":"1349085","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:09.000000Z","updated_at":"2025-03-17T21:01:09.000000Z","inspection_violations":[{"id":12257813,"change_date":"2025-02-11 21:40:00","inspection_id":"83840825","insp_violation_id":"264463421","seq_no":"1","part_no":"177","part_no_section":"817E","insp_viol_unit":"1","insp_unit_id":"205274554","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"177817E"},{"id":12257814,"change_date":"2025-02-11 21:40:00","inspection_id":"83840825","insp_violation_id":"264463422","seq_no":"2","part_no":"172","part_no_section":"602A","insp_viol_unit":"1","insp_unit_id":"205274554","insp_violation_category_id":"38","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8ROD25020810172","created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"172602A"},{"id":12257815,"change_date":"2025-02-11 21:40:00","inspection_id":"83840825","insp_violation_id":"264463423","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"205274554","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":12660504,"change_date":"2025-02-11 21:40:00","inspection_id":"83840825","insp_unit_id":"205274554","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"8605","insp_unit_license":"OSE235","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNDL3RG228605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7805076,"change_date":"2025-02-06 21:41:00","inspection_id":"83799268","dot_number":"172153","report_state":"IA","report_number":"000P15MMKX","insp_date":"2025-02-03 00:00:00","insp_start_time":"1215","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1348264","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-02-06 21:41:00","snet_input_date":"2025-02-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-06 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:19.000000Z","updated_at":"2025-03-17T21:00:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12596110,"change_date":"2025-02-06 21:41:00","inspection_id":"83799268","insp_unit_id":"205193943","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"3","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"Y","insp_unit_decal_number":"34983503","created_at":"2025-03-17T23:54:09.000000Z","updated_at":"2025-03-17T23:54:09.000000Z"}]},{"id":7616307,"change_date":"2025-01-14 21:55:00","inspection_id":"83600964","dot_number":"172153","report_state":"IA","report_number":"000P12HZ44","insp_date":"2025-01-13 00:00:00","insp_start_time":"1913","insp_end_time":"1937","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD SUPPLY","shipping_paper_number":"30T1556028","cargo_tank":null,"hazmat_placard_req":"Y","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-01-14 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1345684","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:10.000000Z","updated_at":"2025-03-17T20:56:10.000000Z","inspection_violations":[{"id":11905413,"change_date":"2025-01-14 21:55:00","inspection_id":"83600964","insp_violation_id":"263992964","seq_no":"1","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204826069","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939T"}],"inspection_per_units":[{"id":12289204,"change_date":"2025-01-14 21:55:00","inspection_id":"83600964","insp_unit_id":"204826069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"31","insp_unit_license":"LE1442","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HCDZAPR9KL580746","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:37.000000Z","updated_at":"2025-03-17T23:50:37.000000Z"},{"id":12289205,"change_date":"2025-01-14 21:55:00","inspection_id":"83600964","insp_unit_id":"204826070","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"3029","insp_unit_license":"LE1451","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0626LK157038","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:37.000000Z","updated_at":"2025-03-17T23:50:37.000000Z"}]},{"id":7508464,"change_date":"2024-12-27 21:38:00","inspection_id":"83487678","dot_number":"172153","report_state":"IA","report_number":"000P15MMJB","insp_date":"2024-12-24 00:00:00","insp_start_time":"0730","insp_end_time":"0750","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80E-MM122","county_code_state":"IA","county_code":"049","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":"2024-12-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1343314","transaction_code":"A","transaction_date":"2024-12-27 00:00:00","upload_date":"2024-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-12-27 21:38:00","snet_input_date":"2024-12-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:41.000000Z","updated_at":"2025-03-17T20:52:41.000000Z","inspection_violations":[{"id":11733733,"change_date":"2024-12-27 21:38:00","inspection_id":"83487678","insp_violation_id":"263670574","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:09.000000Z","updated_at":"2025-03-17T22:03:09.000000Z","normalized_code":"3922SLLSWZ"},{"id":11733734,"change_date":"2024-12-27 21:38:00","inspection_id":"83487678","insp_violation_id":"263670575","seq_no":"2","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8MAC24122407420","created_at":"2025-03-17T22:03:09.000000Z","updated_at":"2025-03-17T22:03:09.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":12112929,"change_date":"2024-12-27 21:38:00","inspection_id":"83487678","insp_unit_id":"204571509","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:43.000000Z","updated_at":"2025-03-17T23:48:43.000000Z"}]},{"id":7219546,"change_date":"2024-11-18 21:41:00","inspection_id":"83183592","dot_number":"172153","report_state":"IA","report_number":"000P11301T","insp_date":"2024-11-16 00:00:00","insp_start_time":"0705","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","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":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1337882","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:30.000000Z","updated_at":"2025-03-17T20:46:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11645023,"change_date":"2024-11-18 21:41:00","inspection_id":"83183592","insp_unit_id":"203932815","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"3","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"Y","insp_unit_decal_number":"34679614","created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":6630859,"change_date":"2024-09-03 21:41:00","inspection_id":"82558192","dot_number":"172153","report_state":"IA","report_number":"000P156NDQ","insp_date":"2024-08-30 00:00:00","insp_start_time":"1429","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CORNHUSKER ARNOLD MOTOR SUPPLY","shipping_paper_number":"9","cargo_tank":null,"hazmat_placard_req":"N","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-09-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1327683","transaction_code":"A","transaction_date":"2024-09-03 00:00:00","upload_date":"2024-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-09-03 21:41:00","snet_input_date":"2024-08-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-03 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:27.000000Z","updated_at":"2025-03-17T20:34:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10690460,"change_date":"2024-09-03 21:41:00","inspection_id":"82558192","insp_unit_id":"202724646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"605","insp_unit_license":"OSE235","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNDL3RG228605","insp_unit_decal":"Y","insp_unit_decal_number":"34353222","created_at":"2025-03-17T23:33:43.000000Z","updated_at":"2025-03-17T23:33:43.000000Z"}]},{"id":6538596,"change_date":"2024-08-22 21:42:00","inspection_id":"82459664","dot_number":"172153","report_state":"IA","report_number":"000P14ZMDJ","insp_date":"2024-08-21 00:00:00","insp_start_time":"1846","insp_end_time":"1910","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"THE MERRILL CO","shipping_paper_number":"GENERAL FREIGHT","cargo_tank":null,"hazmat_placard_req":"Y","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"65000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1326297","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:24.000000Z","updated_at":"2025-03-17T20:32:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10540652,"change_date":"2024-08-22 21:42:00","inspection_id":"82459664","insp_unit_id":"202534724","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3026","insp_unit_license":"GY0926","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HCDZAPR6LL857113","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"},{"id":10540653,"change_date":"2024-08-22 21:42:00","inspection_id":"82459664","insp_unit_id":"202534725","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"3023","insp_unit_license":"HX9647","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0622NB416417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6288420,"change_date":"2024-07-23 21:42:00","inspection_id":"82192469","dot_number":"172153","report_state":"IA","report_number":"000P13X56C","insp_date":"2024-07-19 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"CT","ci_status_code":"C","location":"44","location_desc":"44 - JCT HWY 71\/20 EARLY","county_code_state":"IA","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MERRIL CO","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":"2024-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","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":"1321765","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-07-23 21:42:00","snet_input_date":"2024-07-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-23 21:42:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:23.000000Z","updated_at":"2025-03-17T20:27:23.000000Z","inspection_violations":[{"id":9767225,"change_date":"2024-07-23 21:42:00","inspection_id":"82192469","insp_violation_id":"260797370","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202027332","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:15.000000Z","updated_at":"2025-03-17T21:53:15.000000Z","normalized_code":"39395A"},{"id":9767226,"change_date":"2024-07-23 21:42:00","inspection_id":"82192469","insp_violation_id":"260797371","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202027332","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:15.000000Z","updated_at":"2025-03-17T21:53:15.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10132461,"change_date":"2024-07-23 21:42:00","inspection_id":"82192469","insp_unit_id":"202027332","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"NUE787","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF4GT7EEB25039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"}]},{"id":6090928,"change_date":"2024-06-27 21:40:00","inspection_id":"81980488","dot_number":"172153","report_state":"US","report_number":"1683000206","insp_date":"2024-06-27 00:00:00","insp_start_time":"1330","insp_end_time":"1352","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ADEL IA","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"BR60","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"607552","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":null,"census_search_date":"2024-06-27 21:40:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:23.000000Z","updated_at":"2025-03-17T20:23:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9810498,"change_date":"2024-06-27 21:40:00","inspection_id":"81980488","insp_unit_id":"201620635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"3","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:39.000000Z","updated_at":"2025-03-17T23:24:39.000000Z"}]},{"id":6028780,"change_date":"2024-06-19 21:37:00","inspection_id":"81913516","dot_number":"172153","report_state":"IA","report_number":"000P156NBC","insp_date":"2024-06-18 00:00:00","insp_start_time":"1410","insp_end_time":"1450","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MERRILL","shipping_paper_number":"AUTO PARTS","cargo_tank":null,"hazmat_placard_req":"N","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-06-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1317499","transaction_code":"A","transaction_date":"2024-06-19 00:00:00","upload_date":"2024-06-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-06-19 21:37:00","snet_input_date":"2024-06-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-19 21:37:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:15.000000Z","updated_at":"2025-03-17T20:22:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9710445,"change_date":"2024-06-19 21:37:00","inspection_id":"81913516","insp_unit_id":"201489200","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3007","insp_unit_license":"MGM414","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT2NDA15995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:38.000000Z","updated_at":"2025-03-17T23:23:38.000000Z"}]},{"id":5598429,"change_date":"2024-04-25 21:43:00","inspection_id":"81446251","dot_number":"172153","report_state":"IA","report_number":"000P112ZCD","insp_date":"2024-04-24 00:00:00","insp_start_time":"0720","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR CO","shipping_paper_number":"BATTERY CORES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-25 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1310611","transaction_code":"A","transaction_date":"2024-04-25 00:00:00","upload_date":"2024-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-04-25 21:43:00","snet_input_date":"2024-04-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-25 21:43:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:33.000000Z","updated_at":"2025-03-17T20:13:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9017744,"change_date":"2024-04-25 21:43:00","inspection_id":"81446251","insp_unit_id":"200578536","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"Y","insp_unit_decal_number":"34053134","created_at":"2025-03-17T23:16:54.000000Z","updated_at":"2025-03-17T23:16:54.000000Z"}]},{"id":5410438,"change_date":"2024-04-01 21:40:00","inspection_id":"81240929","dot_number":"172153","report_state":"IA","report_number":"000TT45Q4C","insp_date":"2024-03-30 00:00:00","insp_start_time":"0636","insp_end_time":"0710","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"1","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":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1307610","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2024-04-01 21:40:00","snet_input_date":"2024-03-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:52.000000Z","updated_at":"2025-03-17T20:09:52.000000Z","inspection_violations":[{"id":8350280,"change_date":"2024-04-01 21:40:00","inspection_id":"81240929","insp_violation_id":"258682767","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200179381","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8714091,"change_date":"2024-04-01 21:40:00","inspection_id":"81240929","insp_unit_id":"200179381","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"3","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:02.000000Z","updated_at":"2025-03-17T23:14:02.000000Z"}]},{"id":4538328,"change_date":"2023-12-01 21:42:00","inspection_id":"80288118","dot_number":"172153","report_state":"IA","report_number":"000TT27163","insp_date":"2023-11-17 00:00:00","insp_start_time":"1400","insp_end_time":"1416","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLDS","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":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1295589","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-11-17 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7298961,"change_date":"2023-12-01 21:42:00","inspection_id":"80288118","insp_unit_id":"198306635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"5995","insp_unit_license":"MGM414","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT2NDA15995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"}]},{"id":4152704,"change_date":"2023-10-09 21:36:00","inspection_id":"79862500","dot_number":"172153","report_state":"IA","report_number":"000P136NLC","insp_date":"2023-10-06 00:00:00","insp_start_time":"1306","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"K64 JUST NORTH OF HWY 60 JUNCT","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-09 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1291128","transaction_code":"A","transaction_date":"2023-10-09 00:00:00","upload_date":"2023-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2023-10-09 21:36:00","snet_input_date":"2023-10-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-09 21:36:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:57.000000Z","updated_at":"2025-03-17T19:44:57.000000Z","inspection_violations":[{"id":6427271,"change_date":"2023-10-09 21:36:00","inspection_id":"79862500","insp_violation_id":"255721720","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:00.000000Z","updated_at":"2025-03-17T21:37:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6677259,"change_date":"2023-10-09 21:36:00","inspection_id":"79862500","insp_unit_id":"197455576","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3007","insp_unit_license":"MGM414","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT2NDA15995","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:00.000000Z","updated_at":"2025-03-17T22:56:00.000000Z"}]},{"id":3619179,"change_date":"2023-07-28 21:41:00","inspection_id":"79267849","dot_number":"172153","report_state":"IA","report_number":"000TT6V6SS","insp_date":"2023-07-26 00:00:00","insp_start_time":"0900","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AUTO PARTS","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":"2023-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1282394","transaction_code":"A","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2023-07-28 21:41:00","snet_input_date":"2023-07-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:16.000000Z","updated_at":"2025-03-17T19:34:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5818775,"change_date":"2023-07-28 21:41:00","inspection_id":"79267849","insp_unit_id":"196249051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"3","insp_unit_license":"NLW496","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HTKHPVK2MH363642","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:56.000000Z","updated_at":"2025-03-17T22:48:56.000000Z"}]},{"id":2511742,"change_date":"2023-03-06 21:40:00","inspection_id":"78016139","dot_number":"172153","report_state":"IA","report_number":"000TT82GL8","insp_date":"2023-03-01 00:00:00","insp_start_time":"1415","insp_end_time":"1434","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ARNOLD MOTOR SUPPLY","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":"2023-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1264592","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":"00172153","upload_search_indicator":"M","census_search_date":"2023-03-06 21:40:00","snet_input_date":"2023-03-01 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-06 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","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":3862072,"change_date":"2023-03-06 21:40:00","inspection_id":"78016139","insp_violation_id":"251491391","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"193720915","insp_violation_category_id":"23","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":"39375B"}],"inspection_per_units":[{"id":4042472,"change_date":"2023-03-06 21:40:00","inspection_id":"78016139","insp_unit_id":"193720915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3008","insp_unit_license":"LGN634","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT9MED56092","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":2316184,"change_date":"2023-02-07 21:41:00","inspection_id":"77793061","dot_number":"172153","report_state":"IA","report_number":"000TT6P0NC","insp_date":"2023-02-03 00:00:00","insp_start_time":"1403","insp_end_time":"1432","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"THE MERRILL CO","shipping_paper_number":"GAS 22","cargo_tank":null,"hazmat_placard_req":"Y","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-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261275","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2023-02-07 21:41:00","snet_input_date":"2023-02-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3727868,"change_date":"2023-02-07 21:41:00","inspection_id":"77793061","insp_unit_id":"193273451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3008","insp_unit_license":"LGN634","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FDUF5GT9MED56092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":110343,"change_date":"2022-04-05 21:40:00","inspection_id":"75222804","dot_number":"172153","report_state":"IA","report_number":"000TTDB198","insp_date":"2022-04-04 00:00:00","insp_start_time":"1922","insp_end_time":"1938","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 71\/196 SB","county_code_state":"IA","county_code":"161","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ARNOLD MOTOR SUPPLY","shipping_paper_number":"BR30","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1218426","transaction_code":"A","transaction_date":"2022-04-05 00:00:00","upload_date":"2022-04-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00172153","upload_search_indicator":"M","census_search_date":"2022-04-05 21:40:00","snet_input_date":"2022-04-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-05 21:40:00","insp_carrier_name":"THE MERRILL COMPANY","insp_carrier_street":"601 1ST  AVE  SW","insp_carrier_city":"SPENCER","insp_carrier_state":"IA","insp_carrier_zip_code":"51301","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:29.000000Z","updated_at":"2025-03-17T18:29:29.000000Z","inspection_violations":[{"id":161412,"change_date":"2022-04-05 21:40:00","inspection_id":"75222804","insp_violation_id":"244966699","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:51.000000Z","updated_at":"2025-03-17T21:07:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":178541,"change_date":"2022-04-05 21:40:00","inspection_id":"75222804","insp_unit_id":"187991146","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"0702","insp_unit_license":"GG0702","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSDZAPR9MN218637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:17.000000Z","updated_at":"2025-03-17T22:09:17.000000Z"},{"id":178542,"change_date":"2022-04-05 21:40:00","inspection_id":"75222804","insp_unit_id":"187991147","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"9647","insp_unit_license":"HX9647","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1GR1A0622NB416417","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:17.000000Z","updated_at":"2025-03-17T22:09:17.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/172153\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/172153\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/172153\/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\/172153\/inspections","per_page":100,"prev_page_url":null,"to":28,"total":28}