{"current_page":1,"data":[{"id":12309042,"change_date":"2026-06-28 21:34:00","inspection_id":"88266456","dot_number":"3476028","report_state":"NM","report_number":"8588Q4WHWR","insp_date":"2026-06-25 00:00:00","insp_start_time":"0820","insp_end_time":"0837","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"NM","county_code_state":"NM","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"ELP1115Q4MKMF","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-28 21:34: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":"3641863","transaction_code":"A","transaction_date":"2026-06-28 00:00:00","upload_date":"2026-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-06-28 21:34:00","snet_input_date":"2026-06-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-28 21:34:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:39:53.000000Z","updated_at":"2026-07-07T09:33:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21379146,"change_date":"2026-06-28 21:34:00","inspection_id":"88266456","insp_unit_id":"214338409","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"UNIT 1387","insp_unit_license":"TEMP","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR7PSNU8376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-01T09:17:48.000000Z","updated_at":"2026-07-07T09:06:12.000000Z"},{"id":21379147,"change_date":"2026-06-28 21:34:00","inspection_id":"88266456","insp_unit_id":"214338410","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"UNIT V521433","insp_unit_license":"TL7432","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"1GR1A0628LK172799","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-01T09:17:48.000000Z","updated_at":"2026-07-07T09:06:12.000000Z"}]},{"id":12251973,"change_date":"2026-06-22 21:40:00","inspection_id":"88210432","dot_number":"3476028","report_state":"NM","report_number":"8588Q4OHZ2","insp_date":"2026-06-17 00:00:00","insp_start_time":"1416","insp_end_time":"1439","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"OROGRANDE PORT OF ENTRY","county_code_state":"NM","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"ELP11141SQ67S","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-06-22 21:40: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":"2317453","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-06-22 21:40:00","snet_input_date":"2026-06-22 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-06-22 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-25T09:38:59.000000Z","updated_at":"2026-07-03T09:31:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21275888,"change_date":"2026-06-22 21:40:00","inspection_id":"88210432","insp_unit_id":"214227325","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 555","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV3NLNH9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:29.000000Z","updated_at":"2026-07-05T09:02:23.000000Z"},{"id":21275889,"change_date":"2026-06-22 21:40:00","inspection_id":"88210432","insp_unit_id":"214227326","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT HV2602544","insp_unit_license":"PF24565","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K4TS097212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:29.000000Z","updated_at":"2026-07-05T09:02:23.000000Z"}]},{"id":12242446,"change_date":"2026-06-21 21:33:00","inspection_id":"88200444","dot_number":"3476028","report_state":"MO","report_number":"0361000981","insp_date":"2026-06-15 00:00:00","insp_start_time":"1401","insp_end_time":"1431","registration_date":null,"region":"CD","ci_status_code":"C","location":"C5S","location_desc":"ST GENEVIEVE MO","county_code_state":"MO","county_code":"186","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS 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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-21 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"3588344","transaction_code":"A","transaction_date":"2026-06-20 00:00:00","upload_date":"2026-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-06-21 21:33:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-21 21:33:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-24T09:39:53.000000Z","updated_at":"2026-07-02T09:30:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21260373,"change_date":"2026-06-21 21:33:00","inspection_id":"88200444","insp_unit_id":"214208709","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1385","insp_unit_license":"P1350982","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR6PSMV1329","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-24T09:17:01.000000Z","updated_at":"2026-07-02T09:00:50.000000Z"}]},{"id":12186216,"change_date":"2026-06-15 21:41:00","inspection_id":"88141852","dot_number":"3476028","report_state":"NM","report_number":"7068Q4JHTS","insp_date":"2026-06-12 00:00:00","insp_start_time":"1400","insp_end_time":"1435","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"OROGRANDE PORT OF ENTRY","county_code_state":"NM","county_code":"035","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"111LFQ54Y","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-14 21:34: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":"2316623","transaction_code":"C","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-06-14 21:34:00","snet_input_date":"2026-06-13 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-06-14 21:34:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-17T09:41:53.000000Z","updated_at":"2026-06-26T09:30:15.000000Z","inspection_violations":[{"id":21208614,"change_date":"2026-06-15 21:41:00","inspection_id":"88141852","insp_violation_id":"274923961","seq_no":"1","part_no":"392","part_no_section":"2C","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-17T10:02:04.000000Z","updated_at":"2026-06-26T09:43:23.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":21166690,"change_date":"2026-06-15 21:41:00","inspection_id":"88141852","insp_unit_id":"214116136","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 1387","insp_unit_license":"91350984","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3AKJHHDR7PSNU8376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-17T09:19:08.000000Z","updated_at":"2026-06-26T09:01:06.000000Z"},{"id":21166691,"change_date":"2026-06-15 21:41:00","inspection_id":"88141852","insp_unit_id":"214116137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT 2700445","insp_unit_license":"PF85773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K4VS025445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-17T09:19:08.000000Z","updated_at":"2026-06-26T09:01:06.000000Z"}]},{"id":12299608,"change_date":"2026-06-27 21:41:00","inspection_id":"88256579","dot_number":"3476028","report_state":"WV","report_number":"PSC1570854","insp_date":"2026-06-09 00:00:00","insp_start_time":"1447","insp_end_time":"1514","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SHADY SPRING WV","county_code_state":"WV","county_code":"081","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":"Y","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":"2026-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","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":"3630797","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-06-27 21:41:00","snet_input_date":"2026-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:15.000000Z","updated_at":"2026-07-07T09:31:50.000000Z","inspection_violations":[{"id":21407145,"change_date":"2026-06-27 21:41:00","inspection_id":"88256579","insp_violation_id":"275164953","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"202802026002109","created_at":"2026-06-30T09:58:42.000000Z","updated_at":"2026-07-07T09:44:03.000000Z","normalized_code":"3922SLLTCD"},{"id":21407146,"change_date":"2026-06-27 21:41:00","inspection_id":"88256579","insp_violation_id":"275164954","seq_no":"2","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":"202802026002109","created_at":"2026-06-30T09:58:42.000000Z","updated_at":"2026-07-07T09:44:03.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":21363481,"change_date":"2026-06-27 21:41:00","inspection_id":"88256579","insp_unit_id":"214321814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"N\/A","insp_unit_license":"TL3269","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C5LR440870","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:33.000000Z","updated_at":"2026-07-07T09:03:56.000000Z"},{"id":21363480,"change_date":"2026-06-27 21:41:00","inspection_id":"88256579","insp_unit_id":"214321813","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1011","insp_unit_license":"AH73854","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"4V4NC9EH2KN193813","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-30T09:16:33.000000Z","updated_at":"2026-07-07T09:03:56.000000Z"}]},{"id":12042979,"change_date":"2026-05-28 21:42:00","inspection_id":"87983627","dot_number":"3476028","report_state":"NM","report_number":"8588Q42J03","insp_date":"2026-05-26 00:00:00","insp_start_time":"1428","insp_end_time":"1443","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"OROGRANDE PORT OF ENTRY","county_code_state":"NM","county_code":"035","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"ELP1111Z4D39K","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-28 21:42: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":"2306848","transaction_code":"A","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-05-28 21:42:00","snet_input_date":"2026-05-28 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:40:02.000000Z","updated_at":"2026-06-08T09:31:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20931639,"change_date":"2026-05-28 21:42:00","inspection_id":"87983627","insp_unit_id":"213803202","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 555","insp_unit_license":"MX1221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV3NLNH9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:19.000000Z","updated_at":"2026-06-08T09:03:57.000000Z"},{"id":20931640,"change_date":"2026-05-28 21:42:00","inspection_id":"87983627","insp_unit_id":"213803203","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT HV2504177","insp_unit_license":"PD77833","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K1SS075778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:19.000000Z","updated_at":"2026-06-08T09:03:57.000000Z"}]},{"id":11855801,"change_date":"2026-05-08 21:38:00","inspection_id":"87792018","dot_number":"3476028","report_state":"MO","report_number":"W164001583","insp_date":"2026-05-06 00:00:00","insp_start_time":"1247","insp_end_time":"1306","registration_date":null,"region":"CD","ci_status_code":"C","location":"H2S","location_desc":"EAGLEVILLE MO","county_code_state":"MO","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GENERAL MILLS","shipping_paper_number":"89858861","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-05-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"3283853","transaction_code":"A","transaction_date":"2026-05-08 00:00:00","upload_date":"2026-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-05-08 21:38:00","snet_input_date":"2026-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-08 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-11T09:39:58.000000Z","updated_at":"2026-05-19T09:30:33.000000Z","inspection_violations":[{"id":20620729,"change_date":"2026-05-08 21:38:00","inspection_id":"87792018","insp_violation_id":"274126545","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-11T09:59:46.000000Z","updated_at":"2026-05-19T09:41:59.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":20616775,"change_date":"2026-05-08 21:38:00","inspection_id":"87792018","insp_unit_id":"213444513","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"7826","insp_unit_license":"PXE8831","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR7SSWC7826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:20.000000Z","updated_at":"2026-05-19T09:02:40.000000Z"},{"id":20616776,"change_date":"2026-05-08 21:38:00","inspection_id":"87792018","insp_unit_id":"213444514","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"GV2501278","insp_unit_license":"PD97157","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0620SK629801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-11T09:16:20.000000Z","updated_at":"2026-05-19T09:02:40.000000Z"}]},{"id":11822701,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","dot_number":"3476028","report_state":"WA","report_number":"2177000363","insp_date":"2026-04-30 00:00:00","insp_start_time":"0642","insp_end_time":"0722","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON FULFILLMENT","shipping_paper_number":"CVG9-115X768NN","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-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3259646","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:23.000000Z","updated_at":"2026-05-15T12:18:05.000000Z","inspection_violations":[{"id":20559086,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_violation_id":"274040637","seq_no":"1","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"213378470","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-08T10:00:44.000000Z","updated_at":"2026-05-15T12:41:55.000000Z","normalized_code":"39345B2BHTD"},{"id":20559088,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_violation_id":"274040639","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213378470","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:44.000000Z","updated_at":"2026-05-15T12:41:55.000000Z","normalized_code":"3922SLLSR"},{"id":20559087,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_violation_id":"274040638","seq_no":"2","part_no":"392","part_no_section":"2-SLLSIV","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":"2026-05-08T10:00:44.000000Z","updated_at":"2026-05-15T12:41:55.000000Z","normalized_code":"3922SLLSIV"},{"id":20559089,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_violation_id":"274040640","seq_no":"4","part_no":"393","part_no_section":"75A1-TFBMF","insp_viol_unit":"1","insp_unit_id":"213378470","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-05-08T10:00:44.000000Z","updated_at":"2026-05-15T12:41:55.000000Z","normalized_code":"39375A1TFBMF"},{"id":20559090,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_violation_id":"274040641","seq_no":"5","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213378470","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:44.000000Z","updated_at":"2026-05-15T12:41:55.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":20562815,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_unit_id":"213378470","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"FX1912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKF1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:07.000000Z","updated_at":"2026-05-15T11:57:06.000000Z"},{"id":20562816,"change_date":"2026-05-05 21:39:00","inspection_id":"87757270","insp_unit_id":"213378471","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V506137\/BLU","insp_unit_license":"HV42893","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3H3V532C4KR954093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:07.000000Z","updated_at":"2026-05-15T11:57:06.000000Z"}]},{"id":11683509,"change_date":"2026-04-17 21:41:00","inspection_id":"87609047","dot_number":"3476028","report_state":"NM","report_number":"3858Q2XPMS","insp_date":"2026-04-15 00:00:00","insp_start_time":"1931","insp_end_time":"1950","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"GYR3AUS3BAC62B4","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117350","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":"2293864","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-04-17 21:41:00","snet_input_date":"2026-04-17 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-04-17 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:33:43.000000Z","updated_at":"2026-04-28T09:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20314646,"change_date":"2026-04-17 21:41:00","inspection_id":"87609047","insp_unit_id":"213078049","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT1658","insp_unit_license":"PXE9711","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR9SSWB1658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:46.000000Z","updated_at":"2026-04-28T09:04:14.000000Z"},{"id":20314647,"change_date":"2026-04-17 21:41:00","inspection_id":"87609047","insp_unit_id":"213078050","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"UNITWV2500140","insp_unit_license":"PE21011","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D1SL554262","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:07:46.000000Z","updated_at":"2026-04-28T09:04:14.000000Z"}]},{"id":11505265,"change_date":"2026-03-27 21:40:00","inspection_id":"87425517","dot_number":"3476028","report_state":"CA","report_number":"ND7X007856","insp_date":"2026-03-26 00:00:00","insp_start_time":"1522","insp_end_time":"1541","registration_date":null,"region":"PT","ci_status_code":"C","location":"131","location_desc":"COTTONWOOD CVEF","county_code_state":"CA","county_code":"103","insp_level_id":"3","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"16226214","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-26 00:00:00","source_office":"4CAS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:50.000000Z","updated_at":"2026-04-07T09:33:17.000000Z","inspection_violations":[{"id":19429735,"change_date":"2026-03-27 21:40:00","inspection_id":"87425517","insp_violation_id":"272705110","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"2","insp_unit_id":"212393662","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-30T10:20:29.000000Z","updated_at":"2026-04-07T09:50:04.000000Z","normalized_code":"3922SLLED"}],"inspection_per_units":[{"id":19709777,"change_date":"2026-03-27 21:40:00","inspection_id":"87425517","insp_unit_id":"212393662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"801525\/WHT","insp_unit_license":"P855336","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1JJV532D1ML378277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:32.000000Z","updated_at":"2026-04-07T09:09:53.000000Z"},{"id":19709776,"change_date":"2026-03-27 21:40:00","inspection_id":"87425517","insp_unit_id":"212393661","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"WHITE","insp_unit_license":"MX1219","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X4PJ226261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-30T09:33:32.000000Z","updated_at":"2026-04-07T09:09:53.000000Z"}]},{"id":11393043,"change_date":"2026-03-17 21:39:00","inspection_id":"87307656","dot_number":"3476028","report_state":"OH","report_number":"1956000308","insp_date":"2026-03-15 00:00:00","insp_start_time":"1036","insp_end_time":"1103","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RAY OH","county_code_state":"OH","county_code":"079","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WESTROCK CP, LLC","shipping_paper_number":"426950","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-17 21:39: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":"3014413","transaction_code":"A","transaction_date":"2026-03-16 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-03-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-20T09:42:26.000000Z","updated_at":"2026-03-28T09:30:25.000000Z","inspection_violations":[{"id":19207192,"change_date":"2026-03-17 21:39:00","inspection_id":"87307656","insp_violation_id":"272441017","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"212170181","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"261044","created_at":"2026-03-20T10:03:26.000000Z","updated_at":"2026-03-28T09:45:43.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":19511984,"change_date":"2026-03-17 21:39:00","inspection_id":"87307656","insp_unit_id":"212170181","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"500","insp_unit_license":"MX1220","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV2NLNH9939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:19.000000Z","updated_at":"2026-03-28T09:04:12.000000Z"},{"id":19511985,"change_date":"2026-03-17 21:39:00","inspection_id":"87307656","insp_unit_id":"212170182","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"AZNG CV230537","insp_unit_license":"PC90577","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3PEA75325P1001123","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:19.000000Z","updated_at":"2026-03-28T09:04:12.000000Z"}]},{"id":11233346,"change_date":"2026-02-26 21:40:00","inspection_id":"87145692","dot_number":"3476028","report_state":"MO","report_number":"W109005278","insp_date":"2026-02-25 00:00:00","insp_start_time":"0922","insp_end_time":"0952","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"OREGON MO","county_code_state":"MO","county_code":"087","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"US POSTAL SERVICE","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":"U","pen_cen_match":"I","final_status_date":"2026-02-26 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":"2935749","transaction_code":"A","transaction_date":"2026-02-26 00:00:00","upload_date":"2026-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-02-26 21:40:00","snet_input_date":"2026-02-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-26 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-01T10:38:51.000000Z","updated_at":"2026-03-09T09:31:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19202004,"change_date":"2026-02-26 21:40:00","inspection_id":"87145692","insp_unit_id":"211845368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"700","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:38.000000Z","updated_at":"2026-03-09T09:07:12.000000Z"},{"id":19202005,"change_date":"2026-02-26 21:40:00","inspection_id":"87145692","insp_unit_id":"211845369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"932346","insp_unit_license":"P982401","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAA9629HK277170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-01T10:15:38.000000Z","updated_at":"2026-03-09T09:07:12.000000Z"}]},{"id":11224938,"change_date":"2026-02-25 21:47:00","inspection_id":"87136858","dot_number":"3476028","report_state":"LA","report_number":"LANZS00766","insp_date":"2026-02-23 00:00:00","insp_start_time":"0928","insp_end_time":"0951","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CHOUDRANT LA","county_code_state":"LA","county_code":null,"insp_level_id":"1","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-25 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2932547","transaction_code":"A","transaction_date":"2026-02-25 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-02-25 21:47:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-25 21:47:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:38:37.000000Z","updated_at":"2026-03-08T09:31:14.000000Z","inspection_violations":[{"id":18834159,"change_date":"2026-02-25 21:47:00","inspection_id":"87136858","insp_violation_id":"272015831","seq_no":"1","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"211819543","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:22.000000Z","updated_at":"2026-03-08T09:47:53.000000Z","normalized_code":"39353BB"},{"id":18834160,"change_date":"2026-02-25 21:47:00","inspection_id":"87136858","insp_violation_id":"272015832","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"211819543","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:22.000000Z","updated_at":"2026-03-08T09:47:53.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":19177672,"change_date":"2026-02-25 21:47:00","inspection_id":"87136858","insp_unit_id":"211819542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"MX3404","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDV2PSNZ8759","insp_unit_decal":"Y","insp_unit_decal_number":"36045955","created_at":"2026-02-28T10:15:08.000000Z","updated_at":"2026-03-08T09:05:40.000000Z"},{"id":19177673,"change_date":"2026-02-25 21:47:00","inspection_id":"87136858","insp_unit_id":"211819543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V570762","insp_unit_license":"P897341","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C1MR733537","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:08.000000Z","updated_at":"2026-03-08T09:05:40.000000Z"}]},{"id":11079978,"change_date":"2026-02-09 21:38:00","inspection_id":"86991110","dot_number":"3476028","report_state":"SD","report_number":"HP16800394","insp_date":"2026-02-08 00:00:00","insp_start_time":"1629","insp_end_time":"1651","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"WILMOT SD","county_code_state":"SD","county_code":"109","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"FAR1","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":"2026-02-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"2863533","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-02-09 21:38:00","snet_input_date":"2026-02-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-09 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-12T10:36:56.000000Z","updated_at":"2026-02-20T10:30:24.000000Z","inspection_violations":[{"id":18548939,"change_date":"2026-02-09 21:38:00","inspection_id":"86991110","insp_violation_id":"271673532","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"B1422951-HP","created_at":"2026-02-12T10:50:20.000000Z","updated_at":"2026-02-20T10:38:40.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":18893466,"change_date":"2026-02-09 21:38:00","inspection_id":"86991110","insp_unit_id":"211511472","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"700","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:32.000000Z","updated_at":"2026-02-20T10:03:13.000000Z"},{"id":18893467,"change_date":"2026-02-09 21:38:00","inspection_id":"86991110","insp_unit_id":"211511473","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"TT608523","insp_unit_license":"722410T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5V8VC5323TT608523","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-12T10:13:32.000000Z","updated_at":"2026-02-20T10:03:13.000000Z"}]},{"id":11042520,"change_date":"2026-02-04 21:38:00","inspection_id":"86951864","dot_number":"3476028","report_state":"LA","report_number":"LADRS09667","insp_date":"2026-02-02 00:00:00","insp_start_time":"1639","insp_end_time":"1655","registration_date":null,"region":"CS","ci_status_code":"C","location":"025","location_desc":"VINTON LA","county_code_state":"LA","county_code":"019","insp_level_id":"2","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-04 21:38: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":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2841329","transaction_code":"A","transaction_date":"2026-02-03 00:00:00","upload_date":"2026-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-02-04 21:38:00","snet_input_date":"2026-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-04 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:36:44.000000Z","updated_at":"2026-02-15T10:30:05.000000Z","inspection_violations":[{"id":18292152,"change_date":"2026-02-04 21:38:00","inspection_id":"86951864","insp_violation_id":"271583675","seq_no":"1","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"211428665","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-07T10:45:16.000000Z","updated_at":"2026-02-15T10:39:01.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":18364266,"change_date":"2026-02-04 21:38:00","inspection_id":"86951864","insp_unit_id":"211428664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"100","insp_unit_license":"MX1219","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X4PJ226261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:56.000000Z","updated_at":"2026-02-15T10:04:28.000000Z"},{"id":18364267,"change_date":"2026-02-04 21:38:00","inspection_id":"86951864","insp_unit_id":"211428665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LUFKIN","insp_unit_company":"V572382","insp_unit_license":"PB10153","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1L01A532871161620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:56.000000Z","updated_at":"2026-02-15T10:04:28.000000Z"}]},{"id":10607275,"change_date":"2026-01-09 21:38:00","inspection_id":"86746947","dot_number":"3476028","report_state":"SD","report_number":"5880002545","insp_date":"2026-01-08 00:00:00","insp_start_time":"1605","insp_end_time":"1625","registration_date":null,"region":"CS","ci_status_code":"C","location":"JEFFNB","location_desc":"JEFFERSON SD","county_code_state":"SD","county_code":"127","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","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":"U","pen_cen_match":"I","final_status_date":"2026-01-09 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":"2743651","transaction_code":"A","transaction_date":"2026-01-09 00:00:00","upload_date":"2026-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2026-01-09 21:38:00","snet_input_date":"2026-01-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-09 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-12T10:34:42.000000Z","updated_at":"2026-01-20T10:30:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17783711,"change_date":"2026-01-09 21:38:00","inspection_id":"86746947","insp_unit_id":"210993071","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"100","insp_unit_license":"MX1219","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X4PJ226261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:43.000000Z","updated_at":"2026-01-20T10:00:27.000000Z"},{"id":17783712,"change_date":"2026-01-09 21:38:00","inspection_id":"86746947","insp_unit_id":"210993072","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V563799","insp_unit_license":"TL9553","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C5LR444854","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-12T10:11:43.000000Z","updated_at":"2026-01-20T10:00:27.000000Z"}]},{"id":10574875,"change_date":"2026-01-06 21:38:00","inspection_id":"86712995","dot_number":"3476028","report_state":"MO","report_number":"W130001335","insp_date":"2026-01-03 00:00:00","insp_start_time":"1307","insp_end_time":"1416","registration_date":null,"region":"CS","ci_status_code":"C","location":"D4E","location_desc":"JOPLIN MO","county_code_state":"MO","county_code":"145","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON FULFILLMENT","shipping_paper_number":"OKC5-116F82698","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2728762","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":"03476028","upload_search_indicator":null,"census_search_date":"2026-01-06 21:38:00","snet_input_date":"2026-01-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-06 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-09T10:34:23.000000Z","updated_at":"2026-01-17T10:30:25.000000Z","inspection_violations":[{"id":17768148,"change_date":"2026-01-06 21:38:00","inspection_id":"86712995","insp_violation_id":"271028181","seq_no":"1","part_no":"393","part_no_section":"55E-B","insp_viol_unit":"2","insp_unit_id":"210924009","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:26.000000Z","updated_at":"2026-01-17T10:30:47.000000Z","normalized_code":"39355EB"}],"inspection_per_units":[{"id":17721332,"change_date":"2026-01-06 21:38:00","inspection_id":"86712995","insp_unit_id":"210924008","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"555","insp_unit_license":"MX1221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV3NLNH9920","insp_unit_decal":"Y","insp_unit_decal_number":"36099578","created_at":"2026-01-09T10:05:51.000000Z","updated_at":"2026-01-17T10:00:35.000000Z"},{"id":17721333,"change_date":"2026-01-06 21:38:00","inspection_id":"86712995","insp_unit_id":"210924009","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"HV2203583","insp_unit_license":"PA96464","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K8NS887583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:51.000000Z","updated_at":"2026-01-17T10:00:35.000000Z"}]},{"id":10572069,"change_date":"2026-01-05 21:37:00","inspection_id":"86710026","dot_number":"3476028","report_state":"TX","report_number":"V262146307","insp_date":"2026-01-01 00:00:00","insp_start_time":"1755","insp_end_time":"1826","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR122","county_code_state":"TX","county_code":"287","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"Y","pen_cen_match":null,"final_status_date":"2026-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9806129","transaction_code":"A","transaction_date":"2026-01-05 00:00:00","upload_date":"2026-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2026-01-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1103739","created_at":"2026-01-08T10:34:21.000000Z","updated_at":"2026-01-16T10:30:39.000000Z","inspection_violations":[{"id":17760167,"change_date":"2026-01-05 21:37:00","inspection_id":"86710026","insp_violation_id":"271020182","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"210917578","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:24.000000Z","updated_at":"2026-01-16T10:31:16.000000Z","normalized_code":"39360D"},{"id":17760168,"change_date":"2026-01-05 21:37:00","inspection_id":"86710026","insp_violation_id":"271020183","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"210917578","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-08T10:38:24.000000Z","updated_at":"2026-01-16T10:31:16.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":17714476,"change_date":"2026-01-05 21:37:00","inspection_id":"86710026","insp_unit_id":"210917578","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"555","insp_unit_license":"MX1221","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"1FUJHHDV3NLNH9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-08T10:05:45.000000Z","updated_at":"2026-01-16T10:00:51.000000Z"}]},{"id":10524425,"change_date":"2025-12-29 21:37:00","inspection_id":"86660282","dot_number":"3476028","report_state":"AR","report_number":"7500000734","insp_date":"2025-12-24 00:00:00","insp_start_time":"0810","insp_end_time":"0827","registration_date":null,"region":"CS","ci_status_code":"C","location":"403","location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"TFORCE","shipping_paper_number":"123","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":"2025-12-29 21:37: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":"2705243","transaction_code":"A","transaction_date":"2025-12-28 00:00:00","upload_date":"2025-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-12-29 21:37:00","snet_input_date":"2025-12-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-29 21:37:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-01T10:34:31.000000Z","updated_at":"2026-01-09T10:30:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17626860,"change_date":"2025-12-29 21:37:00","inspection_id":"86660282","insp_unit_id":"210815342","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"UPGZ511707","insp_unit_license":"603822TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"3H3V532C2GT437272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:13.000000Z","updated_at":"2026-01-09T10:00:19.000000Z"},{"id":17626861,"change_date":"2025-12-29 21:37:00","inspection_id":"86660282","insp_unit_id":"210815343","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"01","insp_unit_license":"MX3404","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDV2PSNZ8759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-01T10:08:13.000000Z","updated_at":"2026-01-09T10:00:19.000000Z"}]},{"id":10305964,"change_date":"2025-11-29 21:32:00","inspection_id":"86432000","dot_number":"3476028","report_state":"OH","report_number":"3267001119","insp_date":"2025-11-27 00:00:00","insp_start_time":"0809","insp_end_time":"0910","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CANTON OH","county_code_state":"OH","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"11272025","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":"2025-11-29 21:32: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":"2598409","transaction_code":"A","transaction_date":"2025-11-28 00:00:00","upload_date":"2025-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-11-29 21:32:00","snet_input_date":"2025-11-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-29 21:32:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-02T10:30:25.000000Z","updated_at":"2025-12-03T10:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17209451,"change_date":"2025-11-29 21:32:00","inspection_id":"86432000","insp_unit_id":"210302671","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"9920","insp_unit_license":"MX1221","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV3NLNH9920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-02T10:00:31.000000Z","updated_at":"2025-12-03T10:00:11.000000Z"},{"id":17209452,"change_date":"2025-11-29 21:32:00","inspection_id":"86432000","insp_unit_id":"210302672","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"2202860","insp_unit_license":"PB56177","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0629PK436313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-02T10:00:31.000000Z","updated_at":"2025-12-03T10:00:11.000000Z"}]},{"id":10182766,"change_date":"2025-11-14 21:40:00","inspection_id":"86302690","dot_number":"3476028","report_state":"TX","report_number":"V252113451","insp_date":"2025-11-11 00:00:00","insp_start_time":"0940","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:31\u00bf\u00bf 30' 18.72N","county_code_state":"TX","county_code":"347","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","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":"Y","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9756008","transaction_code":"C","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":"M","census_search_date":"2025-11-12 21:41:00","snet_input_date":"2025-11-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1103739","created_at":"2025-11-15T10:30:53.000000Z","updated_at":"2025-11-18T10:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16986470,"change_date":"2025-11-14 21:40:00","inspection_id":"86302690","insp_unit_id":"210036415","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"100","insp_unit_license":"MX1219","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X4PJ226261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:16.000000Z","updated_at":"2025-11-18T10:00:48.000000Z"}]},{"id":9986009,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","dot_number":"3476028","report_state":"IA","report_number":"000P131WCB","insp_date":"2025-10-18 00:00:00","insp_start_time":"1011","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"45","location_desc":"45 - HWY 218 NB MM 29 PILOT GR","county_code_state":"IA","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"PGA1DSM5","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-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"6","oos_total":"0","driver_viol_total":"5","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1378106","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":"M","census_search_date":"2025-10-20 21:39:00","snet_input_date":"2025-10-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-23T10:00:41.000000Z","updated_at":"2025-10-24T10:00:56.000000Z","inspection_violations":[{"id":16499180,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399196","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209555952","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"3922RG"},{"id":16499181,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399197","seq_no":"2","part_no":"395","part_no_section":"22G","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-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"39522G"},{"id":16499182,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399198","seq_no":"3","part_no":"395","part_no_section":"22H4","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-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"39522H4"},{"id":16499183,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399199","seq_no":"4","part_no":"395","part_no_section":"24C1III","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"39524C1III"},{"id":16499184,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399200","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"3922SLLIFTA"},{"id":16499185,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_violation_id":"269399201","seq_no":"6","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:15:56.000000Z","updated_at":"2025-10-24T10:16:27.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":16582347,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_unit_id":"209555952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"500","insp_unit_license":"QQCQQYZ","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FUJHHDV2NLNH9939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:44.000000Z","updated_at":"2025-10-24T09:46:10.000000Z"},{"id":16582348,"change_date":"2025-10-20 21:39:00","inspection_id":"86095497","insp_unit_id":"209555953","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OPERBUS","insp_unit_company":"0V230097","insp_unit_license":"PB64908","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3PEA75325P1000098","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:44.000000Z","updated_at":"2025-10-24T09:46:10.000000Z"}]},{"id":9921814,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","dot_number":"3476028","report_state":"OH","report_number":"0953000141","insp_date":"2025-10-11 00:00:00","insp_start_time":"1334","insp_end_time":"1431","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BERLIN HEIGHTS OH","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-13 21:36:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"3","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":"2401526","transaction_code":"C","transaction_date":"2025-10-12 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-10-13 21:36:00","snet_input_date":"2025-10-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-13 21:36:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-16T10:00:29.000000Z","updated_at":"2025-11-26T10:31:22.000000Z","inspection_violations":[{"id":17154265,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","insp_violation_id":"270234561","seq_no":"1","part_no":"393","part_no_section":"45D-BHDB","insp_viol_unit":"1","insp_unit_id":"210213728","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:33:50.000000Z","updated_at":"2025-11-26T10:37:39.000000Z","normalized_code":"39345DBHDB"},{"id":17154266,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","insp_violation_id":"270234562","seq_no":"2","part_no":"393","part_no_section":"11A1-LHLM","insp_viol_unit":"1","insp_unit_id":"210213728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:50.000000Z","updated_at":"2025-11-26T10:37:39.000000Z","normalized_code":"39311A1LHLM"},{"id":17154267,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","insp_violation_id":"270234563","seq_no":"3","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"210213728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:33:50.000000Z","updated_at":"2025-11-26T10:37:39.000000Z","normalized_code":"39311A1LFTSM"}],"inspection_per_units":[{"id":17133177,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","insp_unit_id":"210213728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"QB9XX2D","insp_unit_license":"TEMPORARY","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X0PJ226239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:34.000000Z","updated_at":"2025-11-26T10:01:42.000000Z"},{"id":17133178,"change_date":"2025-11-22 21:50:00","inspection_id":"86027315","insp_unit_id":"210213729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"HV2202733","insp_unit_license":"PA89606","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K7NS886733","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:34.000000Z","updated_at":"2025-11-26T10:01:42.000000Z"}]},{"id":9900337,"change_date":"2025-10-09 21:41:00","inspection_id":"86004725","dot_number":"3476028","report_state":"NM","report_number":"4396P7SMBR","insp_date":"2025-10-07 00:00:00","insp_start_time":"1726","insp_end_time":"1756","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON I-10 292 FT E OF I10 EB MM","county_code_state":"NM","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"114D758W9","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-10-09 21:41: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":"2222739","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-10-09 21:41:00","snet_input_date":"2025-10-09 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-10-09 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:02:02.000000Z","updated_at":"2025-10-13T10:01:20.000000Z","inspection_violations":[{"id":16330876,"change_date":"2025-10-09 21:41:00","inspection_id":"86004725","insp_violation_id":"269206211","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":"9985675","created_at":"2025-10-12T10:17:35.000000Z","updated_at":"2025-10-13T10:16:57.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16428826,"change_date":"2025-10-09 21:41:00","inspection_id":"86004725","insp_unit_id":"209388524","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"UNIT900","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1XKYDP9X0PJ226239","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:24.000000Z","updated_at":"2025-10-13T09:46:33.000000Z"},{"id":16428827,"change_date":"2025-10-09 21:41:00","inspection_id":"86004725","insp_unit_id":"209388525","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"UNIT2603156","insp_unit_license":"PF26968","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5326TSC17392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:24.000000Z","updated_at":"2025-10-13T09:46:33.000000Z"}]},{"id":9858767,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","dot_number":"3476028","report_state":"VA","report_number":"7155000900","insp_date":"2025-09-22 00:00:00","insp_start_time":"1100","insp_end_time":"1116","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MIDDLETOWN VA","county_code_state":"VA","county_code":"630","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"10CB","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":"2025-10-05 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2368618","transaction_code":"A","transaction_date":"2025-10-05 00:00:00","upload_date":"2025-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-10-05 21:33:00","snet_input_date":"2025-09-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-05 21:33:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-08T10:01:30.000000Z","updated_at":"2025-10-09T10:00:19.000000Z","inspection_violations":[{"id":16238652,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_violation_id":"269104327","seq_no":"1","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"209304494","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-08T10:17:41.000000Z","updated_at":"2025-10-09T10:15:32.000000Z","normalized_code":"39345DBAAL"},{"id":16238653,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_violation_id":"269104328","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"209304494","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:41.000000Z","updated_at":"2025-10-09T10:15:32.000000Z","normalized_code":"39345B2BAIR"},{"id":16238654,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_violation_id":"269104329","seq_no":"3","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"209304494","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:41.000000Z","updated_at":"2025-10-09T10:15:32.000000Z","normalized_code":"39345DB"},{"id":16238655,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_violation_id":"269104330","seq_no":"4","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"209304494","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-08T10:17:41.000000Z","updated_at":"2025-10-09T10:15:32.000000Z","normalized_code":"39348ABIBD"}],"inspection_per_units":[{"id":16350036,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_unit_id":"209304494","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"FX1912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKF1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-08T09:46:52.000000Z","updated_at":"2025-10-09T09:45:26.000000Z"},{"id":16350037,"change_date":"2025-10-05 21:33:00","inspection_id":"85961068","insp_unit_id":"209304495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"PC91467","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K3RS314029","insp_unit_decal":"Y","insp_unit_decal_number":"35449685","created_at":"2025-10-08T09:46:52.000000Z","updated_at":"2025-10-09T09:45:26.000000Z"}]},{"id":9757289,"change_date":"2025-09-23 21:43:00","inspection_id":"85854561","dot_number":"3476028","report_state":"NM","report_number":"0309P7CBLC","insp_date":"2025-09-21 00:00:00","insp_start_time":"0933","insp_end_time":"0955","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"114P7N751","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-09-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"2218702","transaction_code":"A","transaction_date":"2025-09-21 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-09-23 21:43:00","snet_input_date":"2025-09-22 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"4216 W THURSTON AVE","insp_carrier_city":"MILWAUKEE","insp_carrier_state":"WI","insp_carrier_zip_code":"532093957","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:48.000000Z","updated_at":"2025-09-26T10:00:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16162756,"change_date":"2025-09-23 21:43:00","inspection_id":"85854561","insp_unit_id":"209101534","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT500","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV2NLNH9939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:08.000000Z","updated_at":"2025-09-27T09:45:53.000000Z"},{"id":16162757,"change_date":"2025-09-23 21:43:00","inspection_id":"85854561","insp_unit_id":"209101535","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNIT2500412","insp_unit_license":"PD72332","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K6SS073413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:08.000000Z","updated_at":"2025-09-27T09:45:53.000000Z"}]},{"id":9758061,"change_date":"2025-10-15 21:39:00","inspection_id":"85855352","dot_number":"3476028","report_state":"NM","report_number":"2293P7B2RF","insp_date":"2025-09-20 00:00:00","insp_start_time":"0146","insp_end_time":"0250","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ANTHONY PORT OF ENTRY","county_code_state":"NM","county_code":"013","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"RBD5 1125JSB4M","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-09-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2218603","transaction_code":"C","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-22 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"4216 W THURSTON AVE","insp_carrier_city":"MILWAUKEE","insp_carrier_state":"WI","insp_carrier_zip_code":"532093957","insp_colonia":null,"docket_number":"1139275","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:49.000000Z","updated_at":"2025-10-19T10:00:21.000000Z","inspection_violations":[{"id":16419227,"change_date":"2025-10-15 21:39:00","inspection_id":"85855352","insp_violation_id":"269317809","seq_no":"1","part_no":"393","part_no_section":"45DLPC","insp_viol_unit":"1","insp_unit_id":"209486016","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:47.000000Z","updated_at":"2025-10-19T10:15:35.000000Z","normalized_code":"39345DLPC"},{"id":16419228,"change_date":"2025-10-15 21:39:00","inspection_id":"85855352","insp_violation_id":"269317810","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"209486017","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:17:47.000000Z","updated_at":"2025-10-19T10:15:35.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":16509616,"change_date":"2025-10-15 21:39:00","inspection_id":"85855352","insp_unit_id":"209486016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 500","insp_unit_license":"TEMP","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1FUJHHDV2NLNH9939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:08.000000Z","updated_at":"2025-10-19T09:45:25.000000Z"},{"id":16509617,"change_date":"2025-10-15 21:39:00","inspection_id":"85855352","insp_unit_id":"209486017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"UNIT 181345","insp_unit_license":"P658162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GRAP0629JJ119272","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:08.000000Z","updated_at":"2025-10-19T09:45:25.000000Z"}]},{"id":9644317,"change_date":"2025-09-10 21:40:00","inspection_id":"85736073","dot_number":"3476028","report_state":"IA","report_number":"000P15NF70","insp_date":"2025-09-08 00:00:00","insp_start_time":"0817","insp_end_time":"0850","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":"AMAZON","shipping_paper_number":"STP2CLE2","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-09-10 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":"1373857","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":"M","census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:38.000000Z","updated_at":"2025-09-13T10:47:38.000000Z","inspection_violations":[{"id":15785716,"change_date":"2025-09-10 21:40:00","inspection_id":"85736073","insp_violation_id":"268583209","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"208852368","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:41.000000Z","updated_at":"2025-09-14T11:56:02.000000Z","normalized_code":"39021TB"},{"id":15785717,"change_date":"2025-09-10 21:40:00","inspection_id":"85736073","insp_violation_id":"268583210","seq_no":"2","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:41.000000Z","updated_at":"2025-09-14T11:56:02.000000Z","normalized_code":"3958E"}],"inspection_per_units":[{"id":15934878,"change_date":"2025-09-10 21:40:00","inspection_id":"85736073","insp_unit_id":"208852368","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"700","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"},{"id":15934879,"change_date":"2025-09-10 21:40:00","inspection_id":"85736073","insp_unit_id":"208852369","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUN","insp_unit_company":"568127","insp_unit_license":"TN3919","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C2LR334196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"}]},{"id":9520089,"change_date":"2025-08-27 21:40:00","inspection_id":"85605805","dot_number":"3476028","report_state":"MD","report_number":"2170C00738","insp_date":"2025-08-20 00:00:00","insp_start_time":"0910","insp_end_time":"0934","registration_date":null,"region":"ED","ci_status_code":"C","location":"001027","location_desc":"SYKESVILLE MD","county_code_state":"MD","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","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":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"2185638","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-08-27 21:40:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-27 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-05T10:47:19.000000Z","updated_at":"2025-09-06T10:41:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15712097,"change_date":"2025-08-27 21:40:00","inspection_id":"85605805","insp_unit_id":"208609297","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"70","insp_unit_license":"PXC4585","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR0LSLH7394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:37.000000Z","updated_at":"2025-09-09T09:45:48.000000Z"},{"id":15712098,"change_date":"2025-08-27 21:40:00","inspection_id":"85605805","insp_unit_id":"208609298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"SV2601896","insp_unit_license":"PE93162","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1DW1A5323TSC08651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-05T09:46:37.000000Z","updated_at":"2025-09-09T09:45:48.000000Z"}]},{"id":9352070,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","dot_number":"3476028","report_state":"OR","report_number":"BR42990052","insp_date":"2025-08-07 00:00:00","insp_start_time":"1200","insp_end_time":"1339","registration_date":null,"region":"PD","ci_status_code":"C","location":null,"location_desc":"ASHLAND OR","county_code_state":"OR","county_code":"029","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"115VS74SB","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":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"4","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":"2098962","transaction_code":"C","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:40.000000Z","updated_at":"2025-11-23T10:31:31.000000Z","inspection_violations":[{"id":17021121,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_violation_id":"270059554","seq_no":"1","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"002797","created_at":"2025-11-23T10:32:09.000000Z","updated_at":"2025-11-23T10:32:09.000000Z","normalized_code":"3922SLLED"},{"id":17021122,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_violation_id":"270059555","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"002797","created_at":"2025-11-23T10:32:09.000000Z","updated_at":"2025-11-23T10:32:09.000000Z","normalized_code":"3922SLL"},{"id":17021123,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_violation_id":"270059556","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"210119369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-23T10:32:09.000000Z","updated_at":"2025-11-23T10:32:09.000000Z","normalized_code":"3939ALFTSI"},{"id":17021124,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_violation_id":"270059557","seq_no":"4","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"210119369","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-23T10:32:09.000000Z","updated_at":"2025-11-23T10:32:09.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":17062174,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_unit_id":"210119369","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"FX1912","insp_unit_license_state":"OR","insp_unit_vehicle_id_number":"3AKJHHDR6KSKF1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-23T10:01:43.000000Z","updated_at":"2025-11-23T10:01:43.000000Z"},{"id":17062175,"change_date":"2025-11-19 21:39:00","inspection_id":"85429209","insp_unit_id":"210119370","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":null,"insp_unit_license":"P893116","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3H3V532C7MT732802","insp_unit_decal":"Y","insp_unit_decal_number":"35492137","created_at":"2025-11-23T10:01:43.000000Z","updated_at":"2025-11-23T10:01:43.000000Z"}]},{"id":9007799,"change_date":"2025-06-27 21:38:00","inspection_id":"85066867","dot_number":"3476028","report_state":"UT","report_number":"25JM000474","insp_date":"2025-06-24 00:00:00","insp_start_time":"1121","insp_end_time":"1152","registration_date":null,"region":"MD","ci_status_code":"C","location":"UT31","location_desc":"WENDOVER UT","county_code_state":"UT","county_code":"045","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FAIRLIFE, LLC","shipping_paper_number":"50000095097","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":"2025-06-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","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":"1920194","transaction_code":"A","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-06-27 21:38:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-27 21:38:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:16.000000Z","updated_at":"2025-07-03T10:00:08.000000Z","inspection_violations":[{"id":14479362,"change_date":"2025-06-27 21:38:00","inspection_id":"85066867","insp_violation_id":"267084101","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"207596448","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:31.000000Z","updated_at":"2025-07-02T10:15:14.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":14772678,"change_date":"2025-06-27 21:38:00","inspection_id":"85066867","insp_unit_id":"207596448","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"1","insp_unit_license":"FX1912","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDR6KSKF1538","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:32.000000Z","updated_at":"2025-07-01T09:49:05.000000Z"},{"id":14772679,"change_date":"2025-06-27 21:38:00","inspection_id":"85066867","insp_unit_id":"207596449","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"V562455","insp_unit_license":"TL6609","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C1LR443510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:32.000000Z","updated_at":"2025-07-01T09:49:05.000000Z"}]},{"id":8868924,"change_date":"2025-06-11 21:41:00","inspection_id":"84919803","dot_number":"3476028","report_state":"DE","report_number":"1528001602","insp_date":"2025-06-11 00:00:00","insp_start_time":"0957","insp_end_time":"1021","registration_date":null,"region":"ED","ci_status_code":"C","location":"MDDLTN","location_desc":"MIDDLETOWN DE","county_code_state":"DE","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"RIC21133DXYJN","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":"2025-06-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1850306","transaction_code":"A","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-06-11 21:41:00","snet_input_date":"2025-06-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-11 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:54.000000Z","updated_at":"2025-06-15T10:00:20.000000Z","inspection_violations":[{"id":14208761,"change_date":"2025-06-11 21:41:00","inspection_id":"84919803","insp_violation_id":"266776262","seq_no":"1","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:24.000000Z","updated_at":"2025-06-17T10:17:06.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":14525091,"change_date":"2025-06-11 21:41:00","inspection_id":"84919803","insp_unit_id":"207326274","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"700","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:06.000000Z","updated_at":"2025-06-15T09:45:26.000000Z"},{"id":14525092,"change_date":"2025-06-11 21:41:00","inspection_id":"84919803","insp_unit_id":"207326275","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"HV2304365","insp_unit_license":"PE20518","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K4PS063423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:06.000000Z","updated_at":"2025-06-15T09:45:26.000000Z"}]},{"id":8813437,"change_date":"2025-06-04 21:41:00","inspection_id":"84860967","dot_number":"3476028","report_state":"AR","report_number":"7920001039","insp_date":"2025-06-04 00:00:00","insp_start_time":"1225","insp_end_time":"1250","registration_date":null,"region":"CD","ci_status_code":"C","location":"403","location_desc":"HOPE AR","county_code_state":"AR","county_code":"057","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MCKESSON MEDICAL SURGICAL INC","shipping_paper_number":"01060002771798","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":"2025-06-04 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":"1821368","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":"03476028","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:04.000000Z","updated_at":"2025-06-09T10:00:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14427799,"change_date":"2025-06-04 21:41:00","inspection_id":"84860967","insp_unit_id":"207218961","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"813","insp_unit_license":"DF06GW","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1XPBDP9XXND784773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:14.000000Z","updated_at":"2025-06-08T09:45:35.000000Z"},{"id":14427800,"change_date":"2025-06-04 21:41:00","inspection_id":"84860967","insp_unit_id":"207218962","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"HV2302448","insp_unit_license":"PB46641","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532K9PS061506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-07T09:46:14.000000Z","updated_at":"2025-06-08T09:45:35.000000Z"}]},{"id":8821800,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","dot_number":"3476028","report_state":"AZ","report_number":"6575001843","insp_date":"2025-06-03 00:00:00","insp_start_time":"0930","insp_end_time":"1010","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZEREB","location_desc":"EHRENBERG AZ","county_code_state":"AZ","county_code":"012","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON","shipping_paper_number":"1163H7WSN","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":"2025-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1823893","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:00.000000Z","updated_at":"2025-06-09T10:01:00.000000Z","inspection_violations":[{"id":14121246,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","insp_violation_id":"266674318","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207235236","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:47.000000Z","updated_at":"2025-06-09T10:15:31.000000Z","normalized_code":"3965BL"},{"id":14121247,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","insp_violation_id":"266674319","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207235236","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-08T10:16:47.000000Z","updated_at":"2025-06-09T10:15:31.000000Z","normalized_code":"39378AWS"},{"id":14121248,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","insp_violation_id":"266674320","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207235236","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-08T10:16:47.000000Z","updated_at":"2025-06-09T10:15:31.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":14442993,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","insp_unit_id":"207235236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"70","insp_unit_license":"PXC4585","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3AKJHHDR0LSLH7394","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:22.000000Z","updated_at":"2025-06-09T09:45:19.000000Z"},{"id":14442994,"change_date":"2025-06-05 21:41:00","inspection_id":"84869757","insp_unit_id":"207235237","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYUNDAI TR","insp_unit_company":"570157","insp_unit_license":"P893630","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3H3V532C4MR732446","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:22.000000Z","updated_at":"2025-06-09T09:45:19.000000Z"}]},{"id":8340160,"change_date":"2025-04-10 21:41:00","inspection_id":"84361714","dot_number":"3476028","report_state":"SC","report_number":"0387000442","insp_date":"2025-04-09 00:00:00","insp_start_time":"2115","insp_end_time":"2200","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WILLIAMSTON SC","county_code_state":"SC","county_code":"007","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GRAPHOC PACKAGING INTERNATIONAL","shipping_paper_number":"88404162","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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"1578396","transaction_code":"A","transaction_date":"2025-04-10 00:00:00","upload_date":"2025-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-04-10 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-10 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:28:10.000000Z","updated_at":"2025-04-14T10:28:10.000000Z","inspection_violations":[{"id":13131302,"change_date":"2025-04-10 21:41:00","inspection_id":"84361714","insp_violation_id":"265540812","seq_no":"1","part_no":"392","part_no_section":"2-SLLIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"20252421006124","created_at":"2025-04-12T10:53:47.000000Z","updated_at":"2025-04-13T10:44:41.000000Z","normalized_code":"3922SLLIT"}],"inspection_per_units":[{"id":13529763,"change_date":"2025-04-10 21:41:00","inspection_id":"84361714","insp_unit_id":"206242652","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"500","insp_unit_license":"54366PZ","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1FUJHHDR8LLKZ2478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:13:06.000000Z","updated_at":"2025-04-14T09:57:18.000000Z"},{"id":13529764,"change_date":"2025-04-10 21:41:00","inspection_id":"84361714","insp_unit_id":"206242653","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"107366","insp_unit_license":"133523T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5V8VC5324MT107366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-13T10:13:06.000000Z","updated_at":"2025-04-14T09:57:18.000000Z"}]},{"id":8250730,"change_date":"2025-03-31 21:40:00","inspection_id":"84267716","dot_number":"3476028","report_state":"CO","report_number":"1290040036","insp_date":"2025-03-29 00:00:00","insp_start_time":"1056","insp_end_time":"1113","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"COLORADO SPRINGS CO","county_code_state":"CO","county_code":"041","insp_level_id":"3","service_center":"WE","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":"U","pen_cen_match":"I","final_status_date":"2025-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"148000","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":"1533299","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-03-31 21:40:00","snet_input_date":"2025-03-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-31 21:40:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-03T10:04:06.000000Z","updated_at":"2025-04-04T10:16:51.000000Z","inspection_violations":[{"id":12958200,"change_date":"2025-03-31 21:40:00","inspection_id":"84267716","insp_violation_id":"265342486","seq_no":"1","part_no":"392","part_no_section":"2-SLLML","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-03T10:20:19.000000Z","updated_at":"2025-04-04T10:30:24.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":13351886,"change_date":"2025-03-31 21:40:00","inspection_id":"84267716","insp_unit_id":"206070290","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"101","insp_unit_license":"DD68HS","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"1XKYDP9X1NJ474805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:50:49.000000Z","updated_at":"2025-04-04T09:52:01.000000Z"},{"id":13351887,"change_date":"2025-03-31 21:40:00","inspection_id":"84267716","insp_unit_id":"206070291","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"GV2502422","insp_unit_license":"PD96185","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A0628SD627475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:50:49.000000Z","updated_at":"2025-04-04T09:52:01.000000Z"}]},{"id":8156650,"change_date":"2025-07-30 21:40:00","inspection_id":"84168606","dot_number":"3476028","report_state":"PA","report_number":"XL00079964","insp_date":"2025-03-17 00:00:00","insp_start_time":"1200","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"RT 13 @ PA TURNPIKE ENTRANCE","county_code_state":"PA","county_code":"017","insp_level_id":"3","service_center":"EA","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-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2501917","transaction_code":"C","transaction_date":"2025-07-30 00:00:00","upload_date":"2025-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-22T10:35:03.000000Z","updated_at":"2025-08-04T10:01:04.000000Z","inspection_violations":[{"id":15044496,"change_date":"2025-07-30 21:40:00","inspection_id":"84168606","insp_violation_id":"267747639","seq_no":"1","part_no":"392","part_no_section":"2MI","insp_viol_unit":"1","insp_unit_id":"208160408","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0016886-2","created_at":"2025-08-02T10:43:19.000000Z","updated_at":"2025-08-03T10:43:13.000000Z","normalized_code":"3922MI"},{"id":15044497,"change_date":"2025-07-30 21:40:00","inspection_id":"84168606","insp_violation_id":"267747640","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208160408","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0016887-3","created_at":"2025-08-02T10:43:19.000000Z","updated_at":"2025-08-03T10:43:13.000000Z","normalized_code":"3922RG"},{"id":15044498,"change_date":"2025-07-30 21:40:00","inspection_id":"84168606","insp_violation_id":"267747641","seq_no":"3","part_no":"392","part_no_section":"2MI","insp_viol_unit":"1","insp_unit_id":"208160408","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0016888-4","created_at":"2025-08-02T10:43:19.000000Z","updated_at":"2025-08-03T10:43:13.000000Z","normalized_code":"3922MI"}],"inspection_per_units":[{"id":15279414,"change_date":"2025-07-30 21:40:00","inspection_id":"84168606","insp_unit_id":"208160408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"S088373","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1XKYDP9X1NJ474805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-02T09:46:19.000000Z","updated_at":"2025-08-03T09:45:08.000000Z"}]},{"id":8002080,"change_date":"2025-03-02 21:34:00","inspection_id":"84005890","dot_number":"3476028","report_state":"WA","report_number":"2059001346","insp_date":"2025-02-28 00:00:00","insp_start_time":"1444","insp_end_time":"1509","registration_date":null,"region":"PS","ci_status_code":"C","location":"SC64","location_desc":"LIBERTY LAKE WA","county_code_state":"WA","county_code":"063","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"AMAZON FULFILLMENT","shipping_paper_number":"115V7ZGPC","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":"2025-03-02 21:34: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":"1419276","transaction_code":"A","transaction_date":"2025-03-02 00:00:00","upload_date":"2025-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":"2025-03-02 21:34:00","snet_input_date":"2025-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-02 21:34:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:27.000000Z","updated_at":"2025-03-17T21:04:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12918619,"change_date":"2025-03-02 21:34:00","inspection_id":"84005890","insp_unit_id":"205579843","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"720","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:41.000000Z","updated_at":"2025-03-17T23:57:41.000000Z"},{"id":12918620,"change_date":"2025-03-02 21:34:00","inspection_id":"84005890","insp_unit_id":"205579844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VAN GUARD","insp_unit_company":"V531034","insp_unit_license":"TN2655","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"5V8VA5328LT013897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:41.000000Z","updated_at":"2025-03-17T23:57:41.000000Z"}]},{"id":7982283,"change_date":"2025-02-27 21:41:00","inspection_id":"83985131","dot_number":"3476028","report_state":"NM","report_number":"6587P1L7VF","insp_date":"2025-02-26 00:00:00","insp_start_time":"0700","insp_end_time":"0730","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON I-40 EB OFF RAMP 598 FT W O","county_code_state":"NM","county_code":"031","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","shipping_paper_number":"92625973","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-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","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":"2165318","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03476028","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-27 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"MCK'S DELIVERY LLC","insp_carrier_street":"3801 TIVERTON CT UNIT 205","insp_carrier_city":"AMES","insp_carrier_state":"IA","insp_carrier_zip_code":"50010","insp_colonia":null,"docket_number":"1139275","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:02.000000Z","updated_at":"2025-03-17T21:04:02.000000Z","inspection_violations":[{"id":12471730,"change_date":"2025-02-27 21:41:00","inspection_id":"83985131","insp_violation_id":"264741302","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"9844851","created_at":"2025-03-17T22:06:55.000000Z","updated_at":"2025-03-17T22:06:55.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":12886093,"change_date":"2025-02-27 21:41:00","inspection_id":"83985131","insp_unit_id":"205541436","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT700","insp_unit_license":"FZ9503","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3AKJHHDRXKSKH2604","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"},{"id":12886094,"change_date":"2025-02-27 21:41:00","inspection_id":"83985131","insp_unit_id":"205541437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"UNITAZNGV566241","insp_unit_license":"TM4299","insp_unit_license_state":"ID","insp_unit_vehicle_id_number":"3H3V532C5LT381063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:21.000000Z","updated_at":"2025-03-17T23:57:21.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3476028\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3476028\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3476028\/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\/3476028\/inspections","per_page":100,"prev_page_url":null,"to":39,"total":39}