{"current_page":1,"data":[{"id":12330754,"change_date":"2026-07-01 21:40:00","inspection_id":"88288967","dot_number":"328922","report_state":"CO","report_number":"1378531768","insp_date":"2026-06-29 00:00:00","insp_start_time":"1141","insp_end_time":"1210","registration_date":null,"region":"MD","ci_status_code":"C","location":"RKYFRD","location_desc":"ROCKY FORD CO","county_code_state":"CO","county_code":"089","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"3659506","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":"2026-07-01 21:40:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-01 21:40:00","insp_carrier_name":"RANDOLPH'S INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-04T09:41:41.000000Z","updated_at":"2026-07-13T09:30:35.000000Z","inspection_violations":[{"id":21462214,"change_date":"2026-07-01 21:40:00","inspection_id":"88288967","insp_violation_id":"275238241","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"214384075","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:01:29.000000Z","updated_at":"2026-07-13T09:40:12.000000Z","normalized_code":"39355EB"},{"id":21462215,"change_date":"2026-07-01 21:40:00","inspection_id":"88288967","insp_violation_id":"275238242","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"214384074","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-04T10:01:29.000000Z","updated_at":"2026-07-13T09:40:12.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":21414734,"change_date":"2026-07-01 21:40:00","inspection_id":"88288967","insp_unit_id":"214384074","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"327","insp_unit_license":"FT7854","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR4PSUJ8426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:55.000000Z","updated_at":"2026-07-13T09:01:48.000000Z"},{"id":21414735,"change_date":"2026-07-01 21:40:00","inspection_id":"88288967","insp_unit_id":"214384075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"127","insp_unit_license":"DB7826","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A5ES703116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:18:55.000000Z","updated_at":"2026-07-13T09:01:48.000000Z"}]},{"id":12215720,"change_date":"2026-06-17 21:41:00","inspection_id":"88173209","dot_number":"328922","report_state":"IL","report_number":"5013530016","insp_date":"2026-06-16 00:00:00","insp_start_time":"1106","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I74","county_code_state":"IL","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2480838","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-06-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-06-17 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"506751437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-20T09:43:49.000000Z","updated_at":"2026-06-28T09:31:28.000000Z","inspection_violations":[{"id":21259392,"change_date":"2026-06-17 21:41:00","inspection_id":"88173209","insp_violation_id":"274975556","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","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-06-19T10:06:07.000000Z","updated_at":"2026-06-28T09:42:14.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":21215684,"change_date":"2026-06-17 21:41:00","inspection_id":"88173209","insp_unit_id":"214159466","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"334","insp_unit_license":"MY2067","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X8TR197610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:14.000000Z","updated_at":"2026-06-28T09:03:04.000000Z"},{"id":21215685,"change_date":"2026-06-17 21:41:00","inspection_id":"88173209","insp_unit_id":"214159467","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"143","insp_unit_license":"MX1486","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-20T09:22:14.000000Z","updated_at":"2026-06-28T09:03:04.000000Z"}]},{"id":11805927,"change_date":"2026-05-01 21:41:00","inspection_id":"87739234","dot_number":"328922","report_state":"IA","report_number":"000P14W2QT","insp_date":"2026-04-30 00:00:00","insp_start_time":"1003","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"28 - I80 WB MM 44 AVOCA","county_code_state":"IA","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLA N PIPELINE COMPANY LP","shipping_paper_number":"2082317","cargo_tank":"406","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":"2026-05-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1399298","transaction_code":"A","transaction_date":"2026-05-01 00:00:00","upload_date":"2026-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-01 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-04T09:41:26.000000Z","updated_at":"2026-05-12T09:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20534876,"change_date":"2026-05-01 21:41:00","inspection_id":"87739234","insp_unit_id":"213339345","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"301","insp_unit_license":"FT2517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB004FDGD1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-04T09:20:12.000000Z","updated_at":"2026-05-12T09:03:43.000000Z"},{"id":20534877,"change_date":"2026-05-01 21:41:00","inspection_id":"87739234","insp_unit_id":"213339346","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"115","insp_unit_license":"FS0853","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442285006605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-04T09:20:12.000000Z","updated_at":"2026-05-12T09:03:43.000000Z"}]},{"id":11476806,"change_date":"2026-03-30 21:39:00","inspection_id":"87395763","dot_number":"328922","report_state":"OK","report_number":"R200162387","insp_date":"2026-03-23 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":"2026-03-30 00:00:00","region":"CT","ci_status_code":"C","location":"62375","location_desc":"ANTLERS, OK.","county_code_state":"OK","county_code":"127","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"73330","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":"815653","transaction_code":"C","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-23 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-03-25 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-28T09:44:48.000000Z","updated_at":"2026-04-10T09:30:35.000000Z","inspection_violations":[{"id":19448226,"change_date":"2026-03-30 21:39:00","inspection_id":"87395763","insp_violation_id":"272740558","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-04-02T10:10:05.000000Z","updated_at":"2026-04-09T09:50:38.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19726607,"change_date":"2026-03-30 21:39:00","inspection_id":"87395763","insp_unit_id":"212428334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"332","insp_unit_license":"MX1338","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5KJJBWDR6TPWS3017","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:36.000000Z","updated_at":"2026-04-10T09:04:54.000000Z"},{"id":19726608,"change_date":"2026-03-30 21:39:00","inspection_id":"87395763","insp_unit_id":"212428335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MUELL","insp_unit_company":"132","insp_unit_license":"DD8337","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:36.000000Z","updated_at":"2026-04-10T09:04:54.000000Z"}]},{"id":10577004,"change_date":"2026-01-06 21:39:00","inspection_id":"86715223","dot_number":"328922","report_state":"IA","report_number":"000P13LHPL","insp_date":"2026-01-05 00:00:00","insp_start_time":"0906","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB 265MM","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHLAND PRODUCTS","shipping_paper_number":"047283","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116350","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":"1386499","transaction_code":"A","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-01-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-01-06 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:29.000000Z","updated_at":"2026-01-17T10:30:38.000000Z","inspection_violations":[{"id":17774556,"change_date":"2026-01-06 21:39:00","inspection_id":"86715223","insp_violation_id":"271033287","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-01-09T10:38:39.000000Z","updated_at":"2026-01-17T10:31:18.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17726681,"change_date":"2026-01-06 21:39:00","inspection_id":"86715223","insp_unit_id":"210929085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"315","insp_unit_license":"DA6869","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49XXJJ219134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:53.000000Z"},{"id":17726682,"change_date":"2026-01-06 21:39:00","inspection_id":"86715223","insp_unit_id":"210929086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MUELLER","insp_unit_company":"132","insp_unit_license":"DD8337","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:53.000000Z"}]},{"id":10363662,"change_date":"2025-12-05 21:43:00","inspection_id":"86492192","dot_number":"328922","report_state":"IA","report_number":"000P131WH8","insp_date":"2025-12-04 00:00:00","insp_start_time":"2016","insp_end_time":"2035","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218","county_code_state":"IA","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HEARTLAND","shipping_paper_number":"5248080019","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"1383060","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-12-05 21:43:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:32:05.000000Z","updated_at":"2025-12-09T10:31:18.000000Z","inspection_violations":[{"id":17353096,"change_date":"2025-12-05 21:43:00","inspection_id":"86492192","insp_violation_id":"270494822","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-12-08T10:32:56.000000Z","updated_at":"2025-12-09T10:32:06.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17322631,"change_date":"2025-12-05 21:43:00","inspection_id":"86492192","insp_unit_id":"210444797","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"324","insp_unit_license":"FV9402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9XXLD665673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:32.000000Z"},{"id":17322632,"change_date":"2025-12-05 21:43:00","inspection_id":"86492192","insp_unit_id":"210444798","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ADAMS","insp_unit_company":"3","insp_unit_license":"ST79593","insp_unit_license_state":"AR","insp_unit_vehicle_id_number":"1M9MK322SX1435111","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:09.000000Z","updated_at":"2025-12-09T10:01:32.000000Z"}]},{"id":9566635,"change_date":"2025-09-02 21:39:00","inspection_id":"85655154","dot_number":"328922","report_state":"IA","report_number":"000P12F021","insp_date":"2025-08-30 00:00:00","insp_start_time":"0858","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB I380 \/ FOREVERGREEN RD","county_code_state":"IA","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SHEL OIL US","shipping_paper_number":"2038326","cargo_tank":"406","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":"Y","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":"122000","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":"1372684","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-02 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":[],"inspection_per_units":[{"id":15791186,"change_date":"2025-09-02 21:39:00","inspection_id":"85655154","insp_unit_id":"208697668","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"301","insp_unit_license":"FT2517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB004FDGD1300","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":15791187,"change_date":"2025-09-02 21:39:00","inspection_id":"85655154","insp_unit_id":"208697669","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"115","insp_unit_license":"FS0853","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442285006605","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":9521297,"change_date":"2025-08-27 21:40:00","inspection_id":"85607072","dot_number":"328922","report_state":"IL","report_number":"4069690587","insp_date":"2025-08-26 00:00:00","insp_start_time":"1324","insp_end_time":"1334","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"INTERSTATE 80","county_code_state":"IL","county_code":"073","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":"2025-08-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"2427866","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"506751437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:20.000000Z","updated_at":"2025-09-06T10:41:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15713997,"change_date":"2025-08-27 21:40:00","inspection_id":"85607072","insp_unit_id":"208612220","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"25","insp_unit_license":"FV5881","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXD49X7JD479777","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:38.000000Z","updated_at":"2025-09-09T09:45:54.000000Z"},{"id":15713998,"change_date":"2025-08-27 21:40:00","inspection_id":"85607072","insp_unit_id":"208612221","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"WDR T05114","insp_unit_license":"TF2789","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1BN2T42267B008875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:38.000000Z","updated_at":"2025-09-09T09:45:54.000000Z"}]},{"id":8985092,"change_date":"2025-06-26 21:40:00","inspection_id":"85043130","dot_number":"328922","report_state":"MN","report_number":"1661000613","insp_date":"2025-06-19 00:00:00","insp_start_time":"1033","insp_end_time":"1047","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"INVER GROVE HEIGHTS MN","county_code_state":"MN","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CONGO LUBE PLANT","shipping_paper_number":"520361169","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1915423","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":"2025-06-26 21:40:00","snet_input_date":"2025-06-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-26 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:00:50.000000Z","updated_at":"2025-06-30T10:00:50.000000Z","inspection_violations":[{"id":14447561,"change_date":"2025-06-26 21:40:00","inspection_id":"85043130","insp_violation_id":"267045944","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-06-29T10:16:25.000000Z","updated_at":"2025-06-30T10:16:54.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14735108,"change_date":"2025-06-26 21:40:00","inspection_id":"85043130","insp_unit_id":"207554749","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"329","insp_unit_license":"FV4971","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR6PSUJ8427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:09.000000Z","updated_at":"2025-07-01T09:46:48.000000Z"},{"id":14735109,"change_date":"2025-06-26 21:40:00","inspection_id":"85043130","insp_unit_id":"207554750","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"137","insp_unit_license":"FR1044","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04327NT003301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:09.000000Z","updated_at":"2025-07-01T09:46:48.000000Z"}]},{"id":8852702,"change_date":"2025-06-09 21:41:00","inspection_id":"84902560","dot_number":"328922","report_state":"IA","report_number":"000P128HQ4","insp_date":"2025-06-05 00:00:00","insp_start_time":"1525","insp_end_time":"1540","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":"RESIDUE","shipping_paper_number":"RESIDUE","cargo_tank":"406","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-06-09 21:41: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":"1363161","transaction_code":"A","transaction_date":"2025-06-09 00:00:00","upload_date":"2025-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-09 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:33.000000Z","updated_at":"2025-06-14T10:00:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14496397,"change_date":"2025-06-09 21:41:00","inspection_id":"84902560","insp_unit_id":"207294396","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"318","insp_unit_license":"FT4075","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X9KD603888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:34.000000Z","updated_at":"2025-06-13T09:45:34.000000Z"},{"id":14496398,"change_date":"2025-06-09 21:41:00","inspection_id":"84902560","insp_unit_id":"207294397","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"125","insp_unit_license":"DA5187","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24423D5011001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:34.000000Z","updated_at":"2025-06-13T09:45:34.000000Z"}]},{"id":8815944,"change_date":"2025-06-04 21:41:00","inspection_id":"84863593","dot_number":"328922","report_state":"IA","report_number":"000P12Q86T","insp_date":"2025-06-03 00:00:00","insp_start_time":"1454","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 AND 300TH AVE EARLVILLE","county_code_state":"IA","county_code":"055","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHWOOD PRODUCTS","shipping_paper_number":"043175","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-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1362926","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:06.000000Z","updated_at":"2025-06-09T10:00:36.000000Z","inspection_violations":[{"id":14108669,"change_date":"2025-06-04 21:41:00","inspection_id":"84863593","insp_violation_id":"266661301","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-06-07T10:16:56.000000Z","updated_at":"2025-06-08T10:17:38.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14431759,"change_date":"2025-06-04 21:41:00","inspection_id":"84863593","insp_unit_id":"207223988","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"315","insp_unit_license":"DA6869","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49XXJJ219134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:16.000000Z","updated_at":"2025-06-08T09:45:51.000000Z"},{"id":14431760,"change_date":"2025-06-04 21:41:00","inspection_id":"84863593","insp_unit_id":"207223989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MUELLER","insp_unit_company":"132","insp_unit_license":"DD8337","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:16.000000Z","updated_at":"2025-06-08T09:45:51.000000Z"}]},{"id":8677078,"change_date":"2025-05-19 21:40:00","inspection_id":"84716659","dot_number":"328922","report_state":"IA","report_number":"000P15VB2L","insp_date":"2025-05-15 00:00:00","insp_start_time":"1400","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"MAIN STREET BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1360608","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:37.000000Z","updated_at":"2025-05-23T10:05:23.000000Z","inspection_violations":[{"id":13816472,"change_date":"2025-05-19 21:40:00","inspection_id":"84716659","insp_violation_id":"266319951","seq_no":"1","part_no":"392","part_no_section":"80A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6BRA25051514051","created_at":"2025-05-22T10:21:10.000000Z","updated_at":"2025-05-23T10:26:02.000000Z","normalized_code":"39280A"},{"id":13816473,"change_date":"2025-05-19 21:40:00","inspection_id":"84716659","insp_violation_id":"266319952","seq_no":"2","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:21:10.000000Z","updated_at":"2025-05-23T10:26:02.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":14175290,"change_date":"2025-05-19 21:40:00","inspection_id":"84716659","insp_unit_id":"206943214","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"329","insp_unit_license":"FV4971","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR6PSUJ8427","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:20.000000Z","updated_at":"2025-05-23T09:50:32.000000Z"},{"id":14175291,"change_date":"2025-05-19 21:40:00","inspection_id":"84716659","insp_unit_id":"206943215","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"137","insp_unit_license":"FR1044","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04327NT003301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:20.000000Z","updated_at":"2025-05-23T09:50:32.000000Z"}]},{"id":8569422,"change_date":"2025-05-07 21:46:00","inspection_id":"84603455","dot_number":"328922","report_state":"IL","report_number":"4038551185","insp_date":"2025-05-05 00:00:00","insp_start_time":"1000","insp_end_time":"1012","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-80","county_code_state":"IL","county_code":"197","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":"2025-05-07 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2402844","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-05 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-05-07 21:46:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"506751437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T11:03:02.000000Z","updated_at":"2025-05-11T10:20:56.000000Z","inspection_violations":[{"id":13607639,"change_date":"2025-05-07 21:46:00","inspection_id":"84603455","insp_violation_id":"266087479","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","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-05-09T11:39:59.000000Z","updated_at":"2025-05-10T11:48:05.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":13985206,"change_date":"2025-05-07 21:46:00","inspection_id":"84603455","insp_unit_id":"206739039","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"315","insp_unit_license":"DA6869","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49XXJJ219134","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T15:28:00.000000Z","updated_at":"2025-05-11T03:55:36.000000Z"},{"id":13985207,"change_date":"2025-05-07 21:46:00","inspection_id":"84603455","insp_unit_id":"206739040","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MULE","insp_unit_company":"132","insp_unit_license":"DD8337","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T15:28:00.000000Z","updated_at":"2025-05-11T03:55:36.000000Z"}]},{"id":8276440,"change_date":"2025-04-02 21:41:00","inspection_id":"84294804","dot_number":"328922","report_state":"IA","report_number":"000P14BC7L","insp_date":"2025-03-30 00:00:00","insp_start_time":"1324","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"EB I-80 MM 300.5","county_code_state":"IA","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2025-04-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116200","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":"1354855","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-02 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:23:51.000000Z","updated_at":"2025-04-06T10:23:51.000000Z","inspection_violations":[{"id":13006911,"change_date":"2025-04-02 21:41:00","inspection_id":"84294804","insp_violation_id":"265400002","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-04-04T11:06:57.000000Z","updated_at":"2025-04-05T10:41:38.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":13397133,"change_date":"2025-04-02 21:41:00","inspection_id":"84294804","insp_unit_id":"206120506","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2298","insp_unit_license":"FP8997","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EJ0NN304978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:00.000000Z","updated_at":"2025-04-06T09:59:38.000000Z"},{"id":13397134,"change_date":"2025-04-02 21:41:00","inspection_id":"84294804","insp_unit_id":"206120507","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"320212","insp_unit_license":"754683ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1UYVS2532M3269802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-05T10:12:00.000000Z","updated_at":"2025-04-06T09:59:38.000000Z"}]},{"id":7851879,"change_date":"2025-02-12 21:38:00","inspection_id":"83848463","dot_number":"328922","report_state":"KY","report_number":"CV44175063","insp_date":"2025-02-11 00:00:00","insp_start_time":"1829","insp_end_time":"1900","registration_date":null,"region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"3","service_center":"SH","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":"2025-02-12 21:38: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":"2268669","transaction_code":"A","transaction_date":"2025-02-12 00:00:00","upload_date":"2025-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-12 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-02-12 21:38:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:12.000000Z","updated_at":"2025-03-17T21:01:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12672374,"change_date":"2025-02-12 21:38:00","inspection_id":"83848463","insp_unit_id":"205288619","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"301","insp_unit_license":"FT2517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB004FDGD1300","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:59.000000Z","updated_at":"2025-03-17T23:54:59.000000Z"},{"id":12672375,"change_date":"2025-02-12 21:38:00","inspection_id":"83848463","insp_unit_id":"205288620","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"114","insp_unit_license":"FY8908","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442085006604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:59.000000Z","updated_at":"2025-03-17T23:54:59.000000Z"}]},{"id":7844570,"change_date":"2025-02-11 21:40:00","inspection_id":"83840796","dot_number":"328922","report_state":"IA","report_number":"000P12HZ6D","insp_date":"2025-02-10 00:00:00","insp_start_time":"1203","insp_end_time":"1219","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 4 NB","county_code_state":"IA","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116300","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":"1349082","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":12257741,"change_date":"2025-02-11 21:40:00","inspection_id":"83840796","insp_violation_id":"264463346","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12660452,"change_date":"2025-02-11 21:40:00","inspection_id":"83840796","insp_unit_id":"205274498","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"2298","insp_unit_license":"FP8997","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4V4NC9EJ0NN304978","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":12660453,"change_date":"2025-02-11 21:40:00","inspection_id":"83840796","insp_unit_id":"205274499","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"3671","insp_unit_license":"692732ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1UYVS253XH7047202","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":7815572,"change_date":"2025-02-07 21:40:00","inspection_id":"83810277","dot_number":"328922","report_state":"IA","report_number":"000P14HXRK","insp_date":"2025-02-04 00:00:00","insp_start_time":"1634","insp_end_time":"1700","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-80 WB 1ST AVE ON RAMP","county_code_state":"IA","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"2004572","cargo_tank":"406","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-07 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"118000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1348642","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-02-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:22.000000Z","updated_at":"2025-03-17T21:00:22.000000Z","inspection_violations":[{"id":12212988,"change_date":"2025-02-07 21:40:00","inspection_id":"83810277","insp_violation_id":"264400905","seq_no":"1","part_no":"393","part_no_section":"70B2","insp_viol_unit":"1","insp_unit_id":"205215505","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39370B2"}],"inspection_per_units":[{"id":12612895,"change_date":"2025-02-07 21:40:00","inspection_id":"83810277","insp_unit_id":"205215505","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"324","insp_unit_license":"FV9402","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9XXLD665673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"},{"id":12612896,"change_date":"2025-02-07 21:40:00","inspection_id":"83810277","insp_unit_id":"205215506","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"142","insp_unit_license":"FW9426","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04325RT002802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"}]},{"id":7556250,"change_date":"2025-01-06 21:39:00","inspection_id":"83537816","dot_number":"328922","report_state":"IA","report_number":"000P13J9PW","insp_date":"2025-01-05 00:00:00","insp_start_time":"0742","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 SB 70MM","county_code_state":"IA","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP","shipping_paper_number":"0000105892","cargo_tank":"406","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1344464","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-06 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:56.000000Z","updated_at":"2025-03-17T20:54:56.000000Z","inspection_violations":[{"id":11810715,"change_date":"2025-01-06 21:39:00","inspection_id":"83537816","insp_violation_id":"263772176","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:33.000000Z","updated_at":"2025-03-17T22:03:33.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":12191984,"change_date":"2025-01-06 21:39:00","inspection_id":"83537816","insp_unit_id":"204667001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"O915","insp_unit_license":"FY0991","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZD49X0HJ172056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:35.000000Z","updated_at":"2025-03-17T23:49:35.000000Z"},{"id":12191985,"change_date":"2025-01-06 21:39:00","inspection_id":"83537816","insp_unit_id":"204667002","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"119","insp_unit_license":"FY3215","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442495008521","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:35.000000Z","updated_at":"2025-03-17T23:49:35.000000Z"}]},{"id":7508246,"change_date":"2024-12-27 21:38:00","inspection_id":"83487443","dot_number":"328922","report_state":"IA","report_number":"000P13LHL7","insp_date":"2024-12-23 00:00:00","insp_start_time":"1103","insp_end_time":"1127","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 20 EB 301MM","county_code_state":"IA","county_code":"061","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":"2024-12-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"1343197","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-12-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-27 21:38:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":[],"inspection_per_units":[{"id":12112540,"change_date":"2024-12-27 21:38:00","inspection_id":"83487443","insp_unit_id":"204571065","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"330","insp_unit_license":"FX9617","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBDP9X3PD877007","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":12112541,"change_date":"2024-12-27 21:38:00","inspection_id":"83487443","insp_unit_id":"204571066","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"141","insp_unit_license":"FW7126","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04323RT002801","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":7025645,"change_date":"2024-10-23 21:42:00","inspection_id":"82978148","dot_number":"328922","report_state":"IA","report_number":"000P14XHSB","insp_date":"2024-10-22 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"SB 61 AND HWY 52","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RANDOLPHS","shipping_paper_number":null,"cargo_tank":"406","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1334087","transaction_code":"A","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10965203,"change_date":"2024-10-23 21:42:00","inspection_id":"82978148","insp_violation_id":"262514280","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":"1DOE24102212132","created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"39216"}],"inspection_per_units":[{"id":11330872,"change_date":"2024-10-23 21:42:00","inspection_id":"82978148","insp_unit_id":"203547969","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"319","insp_unit_license":"FA2799","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKWD49X7KJ295976","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"},{"id":11330873,"change_date":"2024-10-23 21:42:00","inspection_id":"82978148","insp_unit_id":"203547970","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"124","insp_unit_license":"DA5186","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24421D5011000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:21.000000Z","updated_at":"2025-03-17T23:40:21.000000Z"}]},{"id":6765070,"change_date":"2024-09-19 21:41:00","inspection_id":"82700779","dot_number":"328922","report_state":"SD","report_number":"HP17900018","insp_date":"2024-09-17 00:00:00","insp_start_time":"1645","insp_end_time":"1652","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BROOKINGS SD","county_code_state":"SD","county_code":"011","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"510661850","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-19 21:41: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":"862714","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10909055,"change_date":"2024-09-19 21:41:00","inspection_id":"82700779","insp_unit_id":"203020622","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"FT7854","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR4PSUJ8426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:00.000000Z","updated_at":"2025-03-17T23:36:00.000000Z"},{"id":10909056,"change_date":"2024-09-19 21:41:00","inspection_id":"82700779","insp_unit_id":"203020623","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"DB7825","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A3ES703115","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:00.000000Z","updated_at":"2025-03-17T23:36:00.000000Z"}]},{"id":6748913,"change_date":"2024-09-17 21:44:00","inspection_id":"82683493","dot_number":"328922","report_state":"IA","report_number":"000P16DKRK","insp_date":"2024-09-16 00:00:00","insp_start_time":"1410","insp_end_time":"1510","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"0000102886","cargo_tank":"406","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-09-17 21:44: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":"1329834","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-17 21:44:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:55.000000Z","updated_at":"2025-03-17T20:36:55.000000Z","inspection_violations":[{"id":10508495,"change_date":"2024-09-17 21:44:00","inspection_id":"82683493","insp_violation_id":"261855743","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202972784","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:53.000000Z","updated_at":"2025-03-17T21:56:53.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":10882626,"change_date":"2024-09-17 21:44:00","inspection_id":"82683493","insp_unit_id":"202972783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"311","insp_unit_license":"FS2275","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X4GD300637","insp_unit_decal":"Y","insp_unit_decal_number":"34354167","created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"},{"id":10882627,"change_date":"2024-09-17 21:44:00","inspection_id":"82683493","insp_unit_id":"202972784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"117","insp_unit_license":"FA5150","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442685006607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"}]},{"id":6721414,"change_date":"2024-09-13 21:42:00","inspection_id":"82654367","dot_number":"328922","report_state":"IA","report_number":"000P123PGZ","insp_date":"2024-09-12 00:00:00","insp_start_time":"1136","insp_end_time":"1200","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"EMPTY","cargo_tank":"406","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-09-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117200","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":"1329296","transaction_code":"A","transaction_date":"2024-09-13 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:28.000000Z","updated_at":"2025-03-17T20:36:28.000000Z","inspection_violations":[{"id":10463420,"change_date":"2024-09-13 21:42:00","inspection_id":"82654367","insp_violation_id":"261789789","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"202913837","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":10837922,"change_date":"2024-09-13 21:42:00","inspection_id":"82654367","insp_unit_id":"202913836","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"328","insp_unit_license":"FV9286","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X4PD877006","insp_unit_decal":"Y","insp_unit_decal_number":"34353488","created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"},{"id":10837923,"change_date":"2024-09-13 21:42:00","inspection_id":"82654367","insp_unit_id":"202913837","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"139","insp_unit_license":"FR2926","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMKA4420N7105446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":6658039,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","dot_number":"328922","report_state":"IA","report_number":"000TT6CH0L","insp_date":"2024-09-03 00:00:00","insp_start_time":"1316","insp_end_time":"1355","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":"WORLD FUEL SERVICES INC","shipping_paper_number":"0187474","cargo_tank":"406","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-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1328035","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:54.000000Z","updated_at":"2025-03-17T20:34:54.000000Z","inspection_violations":[{"id":10360249,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","insp_violation_id":"261637980","seq_no":"1","part_no":"395","part_no_section":"26(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"39526B"},{"id":10360250,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","insp_violation_id":"261637981","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"},{"id":10360251,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","insp_violation_id":"261637982","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":null,"created_at":"2025-03-17T21:56:13.000000Z","updated_at":"2025-03-17T21:56:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10734597,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","insp_unit_id":"202781353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"302","insp_unit_license":"DD0913","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB000FDGJ6958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"},{"id":10734598,"change_date":"2024-09-05 21:43:00","inspection_id":"82587002","insp_unit_id":"202781354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"99","insp_unit_license":"TB2798","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442545003885","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"}]},{"id":6515493,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","dot_number":"328922","report_state":"IA","report_number":"000P15NCTV","insp_date":"2024-08-16 00:00:00","insp_start_time":"0701","insp_end_time":"0745","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN PIPELINE COMPANY L.P.","shipping_paper_number":"NOT PURGED","cargo_tank":"406","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-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1325660","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10119302,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_violation_id":"261294715","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202487712","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:55.000000Z","updated_at":"2025-03-17T21:54:55.000000Z","normalized_code":"3939A"},{"id":10119303,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_violation_id":"261294716","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202487712","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:55.000000Z","updated_at":"2025-03-17T21:54:55.000000Z","normalized_code":"3939A"},{"id":10119304,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_violation_id":"261294717","seq_no":"3","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"202487712","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:55.000000Z","updated_at":"2025-03-17T21:54:55.000000Z","normalized_code":"39355D2"},{"id":10119305,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_violation_id":"261294718","seq_no":"4","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"202487712","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:55.000000Z","updated_at":"2025-03-17T21:54:55.000000Z","normalized_code":"393207F"},{"id":10119306,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_violation_id":"261294719","seq_no":"5","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"202487712","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:55.000000Z","updated_at":"2025-03-17T21:54:55.000000Z","normalized_code":"107620B"}],"inspection_per_units":[{"id":10503219,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_unit_id":"202487712","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"305","insp_unit_license":"DD3077","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXGS008FDGN9702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:47.000000Z","updated_at":"2025-03-17T23:31:47.000000Z"},{"id":10503220,"change_date":"2024-08-20 21:42:00","inspection_id":"82435152","insp_unit_id":"202487713","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HEIL","insp_unit_company":"106","insp_unit_license":"TE9382","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5HTAM442077H71425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:47.000000Z","updated_at":"2025-03-17T23:31:47.000000Z"}]},{"id":6487502,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","dot_number":"328922","report_state":"IA","report_number":"000P142LN0","insp_date":"2024-08-12 00:00:00","insp_start_time":"1208","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RANDOLPHS INC","shipping_paper_number":"RESIDUE","cargo_tank":"406","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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"0","hazmat_oos_total":"0","snet_sequence_id":"1324899","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10074745,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","insp_violation_id":"261234741","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"202432796","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3963A1"},{"id":10074746,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","insp_violation_id":"261234742","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202432795","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3939A"},{"id":10074747,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","insp_violation_id":"261234743","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202432795","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10457242,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","insp_unit_id":"202432795","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"322","insp_unit_license":"FB5307","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X8LD641792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"},{"id":10457243,"change_date":"2024-08-16 21:39:00","inspection_id":"82405296","insp_unit_id":"202432796","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"125","insp_unit_license":"DA5187","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24423D5011001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"}]},{"id":6084432,"change_date":"2024-06-26 21:43:00","inspection_id":"81973474","dot_number":"328922","report_state":"NE","report_number":"T144000022","insp_date":"2024-06-26 00:00:00","insp_start_time":"1436","insp_end_time":"1457","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ON I- 80, 2318 FEET WEST OF MI","county_code_state":"NE","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"790756","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-26 00:00:00","source_office":"3NES001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9442346,"change_date":"2024-06-26 21:43:00","inspection_id":"81973474","insp_violation_id":"260329744","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:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9799973,"change_date":"2024-06-26 21:43:00","inspection_id":"81973474","insp_unit_id":"201607551","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"325","insp_unit_license":"FP7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"},{"id":9799974,"change_date":"2024-06-26 21:43:00","inspection_id":"81973474","insp_unit_id":"201607552","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PLML","insp_unit_company":"129","insp_unit_license":"DD1973","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703269","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":5410296,"change_date":"2024-04-01 21:40:00","inspection_id":"81240766","dot_number":"328922","report_state":"IA","report_number":"000P13J952","insp_date":"2024-03-30 00:00:00","insp_start_time":"0729","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY218 SB MM67 AINSWORTH","county_code_state":"IA","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP","shipping_paper_number":"0000198660","cargo_tank":"406","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1307746","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":[],"inspection_per_units":[{"id":8713827,"change_date":"2024-04-01 21:40:00","inspection_id":"81240766","insp_unit_id":"200179077","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"301","insp_unit_license":"FT2517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB004FDGD1300","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":8713828,"change_date":"2024-04-01 21:40:00","inspection_id":"81240766","insp_unit_id":"200179078","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"114","insp_unit_license":"FE1556","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442085006604","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":5410182,"change_date":"2024-04-01 21:40:00","inspection_id":"81240630","dot_number":"328922","report_state":"IA","report_number":"000P14HX3K","insp_date":"2024-03-29 00:00:00","insp_start_time":"0729","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US 218 SB AND HWY 92","county_code_state":"IA","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP PRODUCTS OF NORTH AMERICA","shipping_paper_number":"0000198633","cargo_tank":"406","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-04-01 21:40: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":"1307710","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":8349727,"change_date":"2024-04-01 21:40:00","inspection_id":"81240630","insp_violation_id":"258681952","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:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8713627,"change_date":"2024-04-01 21:40:00","inspection_id":"81240630","insp_unit_id":"200178823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"301","insp_unit_license":"FT2517","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXFB004FDGD1300","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":8713628,"change_date":"2024-04-01 21:40:00","inspection_id":"81240630","insp_unit_id":"200178824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"114","insp_unit_license":"FE1556","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442085006604","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":5410279,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","dot_number":"328922","report_state":"IA","report_number":"000P13J94Z","insp_date":"2024-03-29 00:00:00","insp_start_time":"1607","insp_end_time":"1639","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY218 SB MM68 AINSWORTH","county_code_state":"IA","county_code":"183","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT TRAVEL CENTER","shipping_paper_number":"1948697","cargo_tank":"406","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"7","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1307693","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":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-03-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-01 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","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":8349895,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682248","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200179046","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":"39311"},{"id":8349896,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682249","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200179046","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8349897,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682250","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200179046","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":"39311"},{"id":8349898,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682251","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200179046","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3939A"},{"id":8349899,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682252","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200179046","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3939A"},{"id":8349900,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682253","seq_no":"6","part_no":"393","part_no_section":"13(a)","insp_viol_unit":"2","insp_unit_id":"200179047","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":"39313A"},{"id":8349901,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_violation_id":"258682254","seq_no":"7","part_no":"392","part_no_section":"8","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:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":8713799,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_unit_id":"200179046","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"O915","insp_unit_license":"FP1082","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZD49X0HJ172056","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":8713800,"change_date":"2024-04-01 21:40:00","inspection_id":"81240747","insp_unit_id":"200179047","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"117","insp_unit_license":"FA5150","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442685006607","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":4744736,"change_date":"2024-01-02 21:43:00","inspection_id":"80514096","dot_number":"328922","report_state":"IA","report_number":"000P15V8WS","insp_date":"2023-12-28 00:00:00","insp_start_time":"0925","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 8 EB","county_code_state":"IA","county_code":"171","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"3451590","cargo_tank":"406","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43: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":"1298804","transaction_code":"A","transaction_date":"2024-01-01 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7323035,"change_date":"2024-01-02 21:43:00","inspection_id":"80514096","insp_violation_id":"257139738","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7632323,"change_date":"2024-01-02 21:43:00","inspection_id":"80514096","insp_unit_id":"198765647","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"321","insp_unit_license":"FB2567","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJGNFG3LDLF3236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"},{"id":7632324,"change_date":"2024-01-02 21:43:00","inspection_id":"80514096","insp_unit_id":"198765648","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"125","insp_unit_license":"DA5187","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24423D5011001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4684280,"change_date":"2023-12-21 21:39:00","inspection_id":"80448334","dot_number":"328922","report_state":"IA","report_number":"000P15NC94","insp_date":"2023-12-08 00:00:00","insp_start_time":"0850","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 24\/295TH FT ATKINSON","county_code_state":"IA","county_code":"191","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN PIPELINE COMPANY","shipping_paper_number":"9808930","cargo_tank":"406","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"1296946","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-12-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7237855,"change_date":"2023-12-21 21:39:00","inspection_id":"80448334","insp_violation_id":"257009445","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:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7534128,"change_date":"2023-12-21 21:39:00","inspection_id":"80448334","insp_unit_id":"198621690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"330","insp_unit_license":"DB5676","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBDP9X3PD877007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:20.000000Z","updated_at":"2025-03-17T23:03:20.000000Z"},{"id":7534129,"change_date":"2023-12-21 21:39:00","inspection_id":"80448334","insp_unit_id":"198621691","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"138","insp_unit_license":"FR1045","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04329NT003302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:20.000000Z","updated_at":"2025-03-17T23:03:20.000000Z"}]},{"id":4301843,"change_date":"2023-10-27 21:42:00","inspection_id":"80027333","dot_number":"328922","report_state":"IA","report_number":"000TT4WRBP","insp_date":"2023-10-26 00:00:00","insp_start_time":"0940","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"IA 14 NB 116 MM CONRAD","county_code_state":"IA","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP PRODUCTS NORTH AMERICA","shipping_paper_number":"566371","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-27 21:42: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":"1292612","transaction_code":"A","transaction_date":"2023-10-27 00:00:00","upload_date":"2023-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-26 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-27 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:19.000000Z","updated_at":"2025-03-17T19:48:19.000000Z","inspection_violations":[{"id":6654945,"change_date":"2023-10-27 21:42:00","inspection_id":"80027333","insp_violation_id":"256088159","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:38:02.000000Z","updated_at":"2025-03-17T21:38:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6918413,"change_date":"2023-10-27 21:42:00","inspection_id":"80027333","insp_unit_id":"197785387","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"316","insp_unit_license":"FT4074","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZDP9X6JJ196451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"},{"id":6918414,"change_date":"2023-10-27 21:42:00","inspection_id":"80027333","insp_unit_id":"197785388","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BEALL","insp_unit_company":"121","insp_unit_license":"TH5446","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1BN2T42249B010207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:02.000000Z","updated_at":"2025-03-17T22:58:02.000000Z"}]},{"id":4062613,"change_date":"2023-09-26 21:43:00","inspection_id":"79762433","dot_number":"328922","report_state":"WI","report_number":"2486001292","insp_date":"2023-09-13 00:00:00","insp_start_time":"0902","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"07(25)","location_desc":"LINDEN (TOWN)","county_code_state":"WI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FLINT HILLS RESOURCES","shipping_paper_number":"1127263","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":"I","final_status_date":"2023-09-26 21:43: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":"907626","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-09-26 21:43:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:10.000000Z","updated_at":"2025-03-17T19:43:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6532032,"change_date":"2023-09-26 21:43:00","inspection_id":"79762433","insp_unit_id":"197252017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"330","insp_unit_license":"DB5676","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBDP9X3PD877007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:49.000000Z","updated_at":"2025-03-17T22:54:49.000000Z"},{"id":6532033,"change_date":"2023-09-26 21:43:00","inspection_id":"79762433","insp_unit_id":"197252018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"138","insp_unit_license":"FR1045","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04329NT003302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:49.000000Z","updated_at":"2025-03-17T22:54:49.000000Z"}]},{"id":3963990,"change_date":"2023-09-13 21:40:00","inspection_id":"79652825","dot_number":"328922","report_state":"IA","report_number":"000TT3FP46","insp_date":"2023-09-11 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"1915989","cargo_tank":"406","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-09-13 21:40: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":"1288892","transaction_code":"A","transaction_date":"2023-09-12 00:00:00","upload_date":"2023-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-09-13 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:10.000000Z","updated_at":"2025-03-17T19:41:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6373853,"change_date":"2023-09-13 21:40:00","inspection_id":"79652825","insp_unit_id":"197033588","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"311","insp_unit_license":"FS2275","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X4GD300637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:31.000000Z","updated_at":"2025-03-17T22:53:31.000000Z"},{"id":6373854,"change_date":"2023-09-13 21:40:00","inspection_id":"79652825","insp_unit_id":"197033589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"118","insp_unit_license":"FJ9228","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442295008520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:31.000000Z","updated_at":"2025-03-17T22:53:31.000000Z"}]},{"id":3823648,"change_date":"2023-08-24 21:41:00","inspection_id":"79496315","dot_number":"328922","report_state":"IL","report_number":"4070200274","insp_date":"2023-08-23 00:00:00","insp_start_time":"0622","insp_end_time":"0640","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"US RTE 30","county_code_state":"IL","county_code":"195","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":"2023-08-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"2270804","transaction_code":"A","transaction_date":"2023-08-23 00:00:00","upload_date":"2023-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-23 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-08-24 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"506751437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:29.000000Z","updated_at":"2025-03-17T19:38:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6147615,"change_date":"2023-08-24 21:41:00","inspection_id":"79496315","insp_unit_id":"196711414","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"323","insp_unit_license":"FA0440","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X3LD665661","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:38.000000Z","updated_at":"2025-03-17T22:51:38.000000Z"},{"id":6147616,"change_date":"2023-08-24 21:41:00","inspection_id":"79496315","insp_unit_id":"196711415","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"128","insp_unit_license":"DD1972","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A4FS703268","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:38.000000Z","updated_at":"2025-03-17T22:51:38.000000Z"}]},{"id":3467564,"change_date":"2023-07-10 21:42:00","inspection_id":"79097862","dot_number":"328922","report_state":"IA","report_number":"000TT6MVK2","insp_date":"2023-07-07 00:00:00","insp_start_time":"0958","insp_end_time":"1020","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":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN PIPELINE","shipping_paper_number":"842319 RETURN T","cargo_tank":"406","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-07-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"1280310","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-10 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:41.000000Z","updated_at":"2025-03-17T19:31:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5575523,"change_date":"2023-07-10 21:42:00","inspection_id":"79097862","insp_unit_id":"195906555","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"305","insp_unit_license":"DD3077","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3ALXGS008FDGN9702","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:02.000000Z","updated_at":"2025-03-17T22:47:02.000000Z"},{"id":5575524,"change_date":"2023-07-10 21:42:00","inspection_id":"79097862","insp_unit_id":"195906556","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"125","insp_unit_license":"DA5187","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24423D5011001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:02.000000Z","updated_at":"2025-03-17T22:47:02.000000Z"}]},{"id":3119158,"change_date":"2023-05-23 21:42:00","inspection_id":"78705213","dot_number":"328922","report_state":"WI","report_number":"2346008073","insp_date":"2023-05-22 00:00:00","insp_start_time":"0925","insp_end_time":"1005","registration_date":null,"region":"CT","ci_status_code":"C","location":"S11","location_desc":"DICKEYVILLE SWEF","county_code_state":"WI","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MEGELLAN","shipping_paper_number":"306187","cargo_tank":"406","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"895185","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-23 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-05-23 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:38.000000Z","updated_at":"2025-03-17T19:24:38.000000Z","inspection_violations":[{"id":4801602,"change_date":"2023-05-23 21:42:00","inspection_id":"78705213","insp_violation_id":"253024120","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195094352","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"BB126392-0","created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3922"},{"id":4801603,"change_date":"2023-05-23 21:42:00","inspection_id":"78705213","insp_violation_id":"253024121","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195094352","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:22.000000Z","updated_at":"2025-03-17T21:29:22.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5017103,"change_date":"2023-05-23 21:42:00","inspection_id":"78705213","insp_unit_id":"195094352","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"FB2324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJGNFG1LDLF3235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"},{"id":5017104,"change_date":"2023-05-23 21:42:00","inspection_id":"78705213","insp_unit_id":"195094353","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":null,"insp_unit_license":"FA5150","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442685006607","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:33.000000Z","updated_at":"2025-03-17T22:42:33.000000Z"}]},{"id":2954595,"change_date":"2023-05-03 21:41:00","inspection_id":"78519114","dot_number":"328922","report_state":"IA","report_number":"000TT6WZVW","insp_date":"2023-04-30 00:00:00","insp_start_time":"1126","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"28 - I80 WB MM 44 AVOCA","county_code_state":"IA","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GREEN PLAINS","shipping_paper_number":"7045012959","cargo_tank":"406","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-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1273303","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-04-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:24.000000Z","updated_at":"2025-03-17T19:21:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4754140,"change_date":"2023-05-03 21:41:00","inspection_id":"78519114","insp_unit_id":"194725443","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"327","insp_unit_license":"FT7854","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR4PSUJ8426","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"},{"id":4754141,"change_date":"2023-05-03 21:41:00","inspection_id":"78519114","insp_unit_id":"194725444","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"134","insp_unit_license":"DZ0278","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04228JT002203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"}]},{"id":2500796,"change_date":"2023-03-03 21:40:00","inspection_id":"78003780","dot_number":"328922","report_state":"IA","report_number":"000TT6JH9H","insp_date":"2023-02-27 00:00:00","insp_start_time":"1500","insp_end_time":"1510","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":"IPR TWIN CITIES","shipping_paper_number":"916122","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1263968","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-03 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:53.000000Z","updated_at":"2025-03-17T19:12:53.000000Z","inspection_violations":[{"id":3845443,"change_date":"2023-03-03 21:40:00","inspection_id":"78003780","insp_violation_id":"251465204","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":"T31623022715023","created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3922"},{"id":3845444,"change_date":"2023-03-03 21:40:00","inspection_id":"78003780","insp_violation_id":"251465205","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193696562","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4024256,"change_date":"2023-03-03 21:40:00","inspection_id":"78003780","insp_unit_id":"193696561","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"322","insp_unit_license":"FB5307","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X8LD641792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"},{"id":4024257,"change_date":"2023-03-03 21:40:00","inspection_id":"78003780","insp_unit_id":"193696562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"2807","insp_unit_license":"DF0110","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D2GL932807","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"}]},{"id":2445895,"change_date":"2023-02-28 21:40:00","inspection_id":"77941210","dot_number":"328922","report_state":"IA","report_number":"000TT74NXV","insp_date":"2023-02-23 00:00:00","insp_start_time":"1140","insp_end_time":"1205","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":"WASTE MANAGEMENT","shipping_paper_number":"TWC89008","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-02-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1263804","transaction_code":"C","transaction_date":"2023-02-24 00:00:00","upload_date":"2023-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-24 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:46.000000Z","updated_at":"2025-03-17T19:11:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3935973,"change_date":"2023-02-28 21:40:00","inspection_id":"77941210","insp_unit_id":"193620319","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"322","insp_unit_license":"FB5307","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X8LD641792","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"},{"id":3935974,"change_date":"2023-02-28 21:40:00","inspection_id":"77941210","insp_unit_id":"193620320","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"6495","insp_unit_license":"FB9593","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1JJV532D8DL751917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:12.000000Z","updated_at":"2025-03-17T22:34:12.000000Z"}]},{"id":2345069,"change_date":"2023-02-10 21:40:00","inspection_id":"77826125","dot_number":"328922","report_state":"IA","report_number":"000TT6JH7J","insp_date":"2023-02-09 00:00:00","insp_start_time":"1345","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 21 SB","county_code_state":"IA","county_code":"171","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1262095","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:57.000000Z","updated_at":"2025-03-17T19:09:57.000000Z","inspection_violations":[{"id":3610972,"change_date":"2023-02-10 21:40:00","inspection_id":"77826125","insp_violation_id":"251066352","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":"T31623020913492","created_at":"2025-03-17T21:24:01.000000Z","updated_at":"2025-03-17T21:24:01.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3773521,"change_date":"2023-02-10 21:40:00","inspection_id":"77826125","insp_unit_id":"193337775","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"316","insp_unit_license":"FT4074","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKZDP9X6JJ196451","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:01.000000Z","updated_at":"2025-03-17T22:33:01.000000Z"}]},{"id":1860982,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","dot_number":"328922","report_state":"IA","report_number":"000TT7CQLW","insp_date":"2022-11-30 00:00:00","insp_start_time":"1250","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"1870555","cargo_tank":"406","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":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253016","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2899184,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","insp_violation_id":"249892113","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":"T12322113013105","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"},{"id":2899185,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","insp_violation_id":"249892114","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"},{"id":2899186,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","insp_violation_id":"249892115","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":"T12322113013123","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2994807,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","insp_unit_id":"192234514","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"311","insp_unit_license":"FS2275","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X4GD300637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"},{"id":2994808,"change_date":"2022-12-02 21:41:00","inspection_id":"77273029","insp_unit_id":"192234515","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"118","insp_unit_license":"FJ9228","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442295008520","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1860966,"change_date":"2022-12-02 21:41:00","inspection_id":"77273009","dot_number":"328922","report_state":"IA","report_number":"000TT722C4","insp_date":"2022-11-29 00:00:00","insp_start_time":"1445","insp_end_time":"1600","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NORTH LIBERTY, 240TH & NORTH J","county_code_state":"IA","county_code":"103","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BP NORTH AMERICA","shipping_paper_number":"187154","cargo_tank":"406","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":"2022-12-02 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"116000","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":"1252940","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-29 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2994778,"change_date":"2022-12-02 21:41:00","inspection_id":"77273009","insp_unit_id":"192234476","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"324","insp_unit_license":"DB5988","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9XXLD665673","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"},{"id":2994779,"change_date":"2022-12-02 21:41:00","inspection_id":"77273009","insp_unit_id":"192234477","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"129","insp_unit_license":"DD1973","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1P9A442A6FS703269","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1740996,"change_date":"2022-11-15 21:39:00","inspection_id":"77135468","dot_number":"328922","report_state":"IA","report_number":"000TT76Z60","insp_date":"2022-11-14 00:00:00","insp_start_time":"1535","insp_end_time":"1605","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80 EB 117 MM WAUKEE","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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":"2022-11-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"1251123","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-15 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:53.000000Z","updated_at":"2025-03-17T18:58:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2801096,"change_date":"2022-11-15 21:39:00","inspection_id":"77135468","insp_unit_id":"191957807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"320","insp_unit_license":"FB2324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJGNFG1LDLF3235","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:10.000000Z","updated_at":"2025-03-17T22:26:10.000000Z"},{"id":2801097,"change_date":"2022-11-15 21:39:00","inspection_id":"77135468","insp_unit_id":"191957808","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"115","insp_unit_license":"TF8021","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442285006605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:10.000000Z","updated_at":"2025-03-17T22:26:10.000000Z"}]},{"id":1708002,"change_date":"2022-11-09 21:40:00","inspection_id":"77097690","dot_number":"328922","report_state":"MN","report_number":"00VV006363","insp_date":"2022-11-09 00:00:00","insp_start_time":"1354","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"JBS WORTHINGTON","shipping_paper_number":"5812322","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","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":"1360605","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-09 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2747735,"change_date":"2022-11-09 21:40:00","inspection_id":"77097690","insp_unit_id":"191884143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"325","insp_unit_license":"FP7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBD49X8MD764941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"},{"id":2747736,"change_date":"2022-11-09 21:40:00","inspection_id":"77097690","insp_unit_id":"191884144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"8179","insp_unit_license":"FP3906","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMS14321H1048859","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1284324,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","dot_number":"328922","report_state":"IA","report_number":"000TT7CQGZ","insp_date":"2022-09-12 00:00:00","insp_start_time":"1230","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGELLAN","shipping_paper_number":"1853730","cargo_tank":"406","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":"2022-09-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1241616","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-14 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:26.000000Z","updated_at":"2025-03-17T18:50:26.000000Z","inspection_violations":[{"id":2031751,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_violation_id":"248407345","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":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3922"},{"id":2031752,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_violation_id":"248407346","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3922"},{"id":2031753,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_violation_id":"248407347","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":"T12322091213034","created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3922"},{"id":2031754,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_violation_id":"248407348","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190895669","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":2067268,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_unit_id":"190895669","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"311","insp_unit_license":"FS2275","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X4GD300637","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"},{"id":2067269,"change_date":"2022-09-14 21:40:00","inspection_id":"76608032","insp_unit_id":"190895670","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"118","insp_unit_license":"FJ9228","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA2442295008520","insp_unit_decal":"Y","insp_unit_decal_number":"31743376","created_at":"2025-03-17T22:21:11.000000Z","updated_at":"2025-03-17T22:21:11.000000Z"}]},{"id":1216937,"change_date":"2022-09-06 21:42:00","inspection_id":"76530351","dot_number":"328922","report_state":"MN","report_number":"0ADO003014","insp_date":"2022-09-06 00:00:00","insp_start_time":"1017","insp_end_time":"1111","registration_date":null,"region":"CT","ci_status_code":"C","location":"WTHTN","location_desc":"WORTHINGTON SCALE","county_code_state":"MN","county_code":"105","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1348807","transaction_code":"A","transaction_date":"2022-09-06 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-06 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:01.000000Z","updated_at":"2025-03-17T18:49:01.000000Z","inspection_violations":[{"id":1927708,"change_date":"2022-09-06 21:42:00","inspection_id":"76530351","insp_violation_id":"248225142","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190735324","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"3922"},{"id":1927709,"change_date":"2022-09-06 21:42:00","inspection_id":"76530351","insp_violation_id":"248225143","seq_no":"2","part_no":"395","part_no_section":"24(d)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:54.000000Z","updated_at":"2025-03-17T21:15:54.000000Z","normalized_code":"39524D"}],"inspection_per_units":[{"id":1957769,"change_date":"2022-09-06 21:42:00","inspection_id":"76530351","insp_unit_id":"190735324","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"318","insp_unit_license":"PZ1348","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X9KD603888","insp_unit_decal":"Y","insp_unit_decal_number":"31704933","created_at":"2025-03-17T22:20:27.000000Z","updated_at":"2025-03-17T22:20:27.000000Z"}]},{"id":872289,"change_date":"2022-07-22 21:39:00","inspection_id":"76128069","dot_number":"328922","report_state":"IA","report_number":"000TT7CQD4","insp_date":"2022-07-18 00:00:00","insp_start_time":"1335","insp_end_time":"1400","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BUCKEYE","shipping_paper_number":"185196","cargo_tank":"406","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":"2022-07-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"1233859","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:03.000000Z","updated_at":"2025-03-17T18:43:03.000000Z","inspection_violations":[{"id":1373285,"change_date":"2022-07-22 21:39:00","inspection_id":"76128069","insp_violation_id":"247252329","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":null,"created_at":"2025-03-17T21:13:28.000000Z","updated_at":"2025-03-17T21:13:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1404235,"change_date":"2022-07-22 21:39:00","inspection_id":"76128069","insp_unit_id":"189914912","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"314","insp_unit_license":"FS1264","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPXDP9X3JD491796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:49.000000Z","updated_at":"2025-03-17T22:16:49.000000Z"},{"id":1404236,"change_date":"2022-07-22 21:39:00","inspection_id":"76128069","insp_unit_id":"189914913","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"125","insp_unit_license":"DA5187","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1PMA24423D5011001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:49.000000Z","updated_at":"2025-03-17T22:16:49.000000Z"}]},{"id":638530,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","dot_number":"328922","report_state":"IA","report_number":"000TT6F6LZ","insp_date":"2022-06-16 00:00:00","insp_start_time":"1223","insp_end_time":"1421","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 30\/S STORY ST BOONE, IA","county_code_state":"IA","county_code":"015","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"POET BIOFUELS","shipping_paper_number":"58606","cargo_tank":"406","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1229481","transaction_code":"C","transaction_date":"2022-06-23 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-17 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:51.000000Z","updated_at":"2025-03-17T18:38:51.000000Z","inspection_violations":[{"id":1003883,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","insp_violation_id":"246675595","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:43.000000Z","updated_at":"2025-03-17T21:11:43.000000Z","normalized_code":"39111B4"},{"id":1003884,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","insp_violation_id":"246675596","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:43.000000Z","updated_at":"2025-03-17T21:11:43.000000Z","normalized_code":"39145B"},{"id":1003885,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","insp_violation_id":"246675597","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189427064","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:43.000000Z","updated_at":"2025-03-17T21:11:43.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1026139,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","insp_unit_id":"189427064","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"325","insp_unit_license":"FP7822","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XPBD49X8MD764941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:30.000000Z","updated_at":"2025-03-17T22:14:30.000000Z"},{"id":1026140,"change_date":"2022-06-23 21:40:00","inspection_id":"75854043","insp_unit_id":"189427065","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"134","insp_unit_license":"DZ0278","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04228JT002203","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:30.000000Z","updated_at":"2025-03-17T22:14:30.000000Z"}]},{"id":502724,"change_date":"2022-05-27 21:40:00","inspection_id":"75692641","dot_number":"328922","report_state":"IA","report_number":"000TT87FN9","insp_date":"2022-05-25 00:00:00","insp_start_time":"1348","insp_end_time":"1415","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 3\/V AVE FAIRBANK","county_code_state":"IA","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGELLAN","shipping_paper_number":"1833491","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1226997","transaction_code":"A","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00328922","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-25 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-27 21:40:00","insp_carrier_name":"RANDOLPHS INC","insp_carrier_street":"1141 SOUTH MAIN","insp_carrier_city":"TRAER","insp_carrier_state":"IA","insp_carrier_zip_code":"50675-1437","insp_colonia":null,"docket_number":"202563","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:39.000000Z","updated_at":"2025-03-17T18:36:39.000000Z","inspection_violations":[{"id":798198,"change_date":"2022-05-27 21:40:00","inspection_id":"75692641","insp_violation_id":"246134311","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:47.000000Z","updated_at":"2025-03-17T21:10:47.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":808226,"change_date":"2022-05-27 21:40:00","inspection_id":"75692641","insp_unit_id":"188961689","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"307","insp_unit_license":"FR7558","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJGHDV1GSGX2789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"},{"id":808227,"change_date":"2022-05-27 21:40:00","inspection_id":"75692641","insp_unit_id":"188961690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LBT","insp_unit_company":"123","insp_unit_license":"FP0626","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4J8T04223DT001402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:10.000000Z","updated_at":"2025-03-17T22:13:10.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/328922\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/328922\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/328922\/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\/328922\/inspections","per_page":100,"prev_page_url":null,"to":51,"total":51}