{"current_page":1,"data":[{"id":11227689,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","dot_number":"2044993","report_state":"MI","report_number":"DUBOL00381","insp_date":"2026-02-24 00:00:00","insp_start_time":"1825","insp_end_time":"1905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M59@M59 CROSSOVER","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1260471","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:36.000000Z","inspection_violations":[{"id":19022111,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","insp_violation_id":"272251134","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"39617CPI"},{"id":19022112,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","insp_violation_id":"272251135","seq_no":"2","part_no":"392","part_no_section":"2-SLLIRP","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":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3922SLLIRP"},{"id":19022113,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","insp_violation_id":"272251136","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"212013817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"3939ALRLI"},{"id":19022114,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","insp_violation_id":"272251137","seq_no":"4","part_no":"393","part_no_section":"11A1-LCL","insp_viol_unit":"1","insp_unit_id":"212013817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:27.000000Z","updated_at":"2026-03-17T09:39:31.000000Z","normalized_code":"39311A1LCL"}],"inspection_per_units":[{"id":19343546,"change_date":"2026-03-06 21:42:00","inspection_id":"87139761","insp_unit_id":"212013817","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3202","insp_unit_license":"BC30881","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT6CHBS0384","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:21.000000Z","updated_at":"2026-03-17T09:02:46.000000Z"}]},{"id":10449436,"change_date":"2025-12-16 21:38:00","inspection_id":"86581897","dot_number":"2044993","report_state":"MI","report_number":"NESBA02506","insp_date":"2025-12-15 00:00:00","insp_start_time":"1720","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@MLK BLVD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1253822","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-16 21:38:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-19T10:31:54.000000Z","updated_at":"2025-12-27T10:30:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17485789,"change_date":"2025-12-16 21:38:00","inspection_id":"86581897","insp_unit_id":"210640049","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"3203","insp_unit_license":"BD72339","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV7K4S74190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-19T10:02:01.000000Z","updated_at":"2025-12-27T10:01:01.000000Z"}]},{"id":10200882,"change_date":"2025-12-04 21:38:00","inspection_id":"86321739","dot_number":"2044993","report_state":"MI","report_number":"NESBA02461","insp_date":"2025-11-13 00:00:00","insp_start_time":"1820","insp_end_time":"1835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@ADAMS RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1250495","transaction_code":"C","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:29.000000Z","updated_at":"2025-12-08T10:30:33.000000Z","inspection_violations":[{"id":17320327,"change_date":"2025-12-04 21:38:00","inspection_id":"86321739","insp_violation_id":"270463328","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:32:06.000000Z","updated_at":"2025-12-08T10:30:59.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17290412,"change_date":"2025-12-04 21:38:00","inspection_id":"86321739","insp_unit_id":"210415438","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3204","insp_unit_license":"BC37139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDD66HW47173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:26.000000Z","updated_at":"2025-12-08T10:00:41.000000Z"}]},{"id":10045817,"change_date":"2025-10-27 21:39:00","inspection_id":"86158370","dot_number":"2044993","report_state":"MI","report_number":"ESCOT03107","insp_date":"2025-10-25 00:00:00","insp_start_time":"1345","insp_end_time":"1410","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W I-96@8 MILE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1247895","transaction_code":"A","transaction_date":"2025-10-25 00:00:00","upload_date":"2025-10-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-27 21:39:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-30T10:00:46.000000Z","updated_at":"2025-11-01T10:01:03.000000Z","inspection_violations":[{"id":16622211,"change_date":"2025-10-27 21:39:00","inspection_id":"86158370","insp_violation_id":"269539734","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-10-30T10:15:59.000000Z","updated_at":"2025-10-31T10:16:39.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16692233,"change_date":"2025-10-27 21:39:00","inspection_id":"86158370","insp_unit_id":"209675432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"3206","insp_unit_license":"BE01305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV6R5T56622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-30T09:45:52.000000Z","updated_at":"2025-10-31T09:46:16.000000Z"}]},{"id":10019245,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","dot_number":"2044993","report_state":"MI","report_number":"DUBOL00268","insp_date":"2025-10-21 00:00:00","insp_start_time":"1750","insp_end_time":"1835","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I696 @ M5","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"US POST OFFICE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247043","transaction_code":"C","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:54.000000Z","updated_at":"2025-11-16T10:30:47.000000Z","inspection_violations":[{"id":16900787,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","insp_violation_id":"269895782","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","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-11-15T10:30:59.000000Z","updated_at":"2025-11-16T10:31:20.000000Z","normalized_code":"3922SLLSR"},{"id":16900788,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","insp_violation_id":"269895783","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:59.000000Z","updated_at":"2025-11-16T10:31:20.000000Z","normalized_code":"39617CPI"},{"id":16900789,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","insp_violation_id":"269895784","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209979675","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:59.000000Z","updated_at":"2025-11-16T10:31:20.000000Z","normalized_code":"3939ALIL"},{"id":16900790,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","insp_violation_id":"269895785","seq_no":"4","part_no":"393","part_no_section":"95A4-EENA","insp_viol_unit":"1","insp_unit_id":"209979675","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:59.000000Z","updated_at":"2025-11-16T10:31:20.000000Z","normalized_code":"39395A4EENA"}],"inspection_per_units":[{"id":16948957,"change_date":"2025-11-12 21:41:00","inspection_id":"86130401","insp_unit_id":"209979675","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"0","insp_unit_license":"BE01305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV6R5T56622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:34.000000Z","updated_at":"2025-11-16T10:00:55.000000Z"}]},{"id":9730515,"change_date":"2025-09-19 21:39:00","inspection_id":"85826651","dot_number":"2044993","report_state":"MI","report_number":"COPEK03450","insp_date":"2025-09-18 00:00:00","insp_start_time":"0825","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB M59 @ SQUIRREL RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A\/C","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1242188","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-19 21:39:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:45.000000Z","updated_at":"2025-09-23T10:02:45.000000Z","inspection_violations":[{"id":15976591,"change_date":"2025-09-19 21:39:00","inspection_id":"85826651","insp_violation_id":"268809519","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4589646","created_at":"2025-09-22T10:18:30.000000Z","updated_at":"2025-09-23T10:16:34.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":16113782,"change_date":"2025-09-19 21:39:00","inspection_id":"85826651","insp_unit_id":"209049770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3204","insp_unit_license":"BC37139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDD66HW47173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:06.000000Z","updated_at":"2025-09-23T09:46:09.000000Z"}]},{"id":9633884,"change_date":"2025-09-09 21:41:00","inspection_id":"85725080","dot_number":"2044993","report_state":"MI","report_number":"NESBA02322","insp_date":"2025-09-08 00:00:00","insp_start_time":"1855","insp_end_time":"1950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240013","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:07.000000Z","inspection_violations":[{"id":15762029,"change_date":"2025-09-09 21:41:00","inspection_id":"85725080","insp_violation_id":"268555782","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4568922","created_at":"2025-09-12T10:51:31.000000Z","updated_at":"2025-09-13T10:49:42.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":15916046,"change_date":"2025-09-09 21:41:00","inspection_id":"85725080","insp_unit_id":"208831569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV8S5T57289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:54.000000Z"}]},{"id":9250109,"change_date":"2025-07-25 21:40:00","inspection_id":"85321879","dot_number":"2044993","report_state":"MI","report_number":"SAHIW02881","insp_date":"2025-07-24 00:00:00","insp_start_time":"1750","insp_end_time":"1810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB-M59 @ SQUIRREL RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","pen_cen_match":null,"final_status_date":"2025-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1232397","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:22.000000Z","updated_at":"2025-07-30T10:01:22.000000Z","inspection_violations":[{"id":14979896,"change_date":"2025-07-25 21:40:00","inspection_id":"85321879","insp_violation_id":"267656860","seq_no":"1","part_no":"392","part_no_section":"16AD","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-07-28T10:49:46.000000Z","updated_at":"2025-07-29T10:43:33.000000Z","normalized_code":"39216AD"},{"id":14979897,"change_date":"2025-07-25 21:40:00","inspection_id":"85321879","insp_violation_id":"267656861","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:46.000000Z","updated_at":"2025-07-29T10:43:33.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":15223255,"change_date":"2025-07-25 21:40:00","inspection_id":"85321879","insp_unit_id":"208084289","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"3230","insp_unit_license":"BD72339","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV7K4S74190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:36.000000Z","updated_at":"2025-07-29T09:45:59.000000Z"}]},{"id":8796644,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","dot_number":"2044993","report_state":"MI","report_number":"CORBJ00069","insp_date":"2025-05-30 00:00:00","insp_start_time":"2015","insp_end_time":"2045","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-94WB @ OAKWOOD RD","county_code_state":"MI","county_code":"163","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":"N","pen_cen_match":null,"final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1223691","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:30.000000Z","updated_at":"2025-06-06T10:00:37.000000Z","inspection_violations":[{"id":14065417,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","insp_violation_id":"266613341","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"207184587","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:42.000000Z","updated_at":"2025-06-06T10:15:56.000000Z","normalized_code":"39617CPI"},{"id":14065418,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","insp_violation_id":"266613342","seq_no":"3","part_no":"392","part_no_section":"82DUMT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:42.000000Z","updated_at":"2025-06-06T10:15:56.000000Z","normalized_code":"39282DUMT"},{"id":14065419,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","insp_violation_id":"266613343","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207184587","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-05T10:15:42.000000Z","updated_at":"2025-06-06T10:15:56.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":14394692,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","insp_unit_id":"207184587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3211","insp_unit_license":"RB17641","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUBA5CG67LY54276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:28.000000Z","updated_at":"2025-06-06T09:45:58.000000Z"},{"id":14394693,"change_date":"2025-06-02 21:39:00","inspection_id":"84843115","insp_unit_id":"207184588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"W80351","insp_unit_license":"426992Y","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1JJV532D7KL148955","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:28.000000Z","updated_at":"2025-06-06T09:45:58.000000Z"}]},{"id":8415719,"change_date":"2025-04-18 21:40:00","inspection_id":"84441402","dot_number":"2044993","report_state":"MI","report_number":"DAWDD03949","insp_date":"2025-04-18 00:00:00","insp_start_time":"0634","insp_end_time":"0654","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"USPS","shipping_paper_number":"04182025","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1218152","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:12.000000Z","updated_at":"2025-04-23T10:03:21.000000Z","inspection_violations":[{"id":13278591,"change_date":"2025-04-18 21:40:00","inspection_id":"84441402","insp_violation_id":"265707362","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:14:27.000000Z","updated_at":"2025-04-22T10:30:57.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":13664018,"change_date":"2025-04-18 21:40:00","inspection_id":"84441402","insp_unit_id":"206388298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"NONE","insp_unit_license":"BD07956","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV7N5T50841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:15:55.000000Z","updated_at":"2025-04-22T10:02:17.000000Z"}]},{"id":8136778,"change_date":"2025-03-17 21:40:00","inspection_id":"84147882","dot_number":"2044993","report_state":"MI","report_number":"ESCOT02552","insp_date":"2025-03-15 00:00:00","insp_start_time":"0640","insp_end_time":"0705","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W I-96@NOVI RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213443","transaction_code":"A","transaction_date":"2025-03-15 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:22:52.000000Z","updated_at":"2025-03-21T10:22:52.000000Z","inspection_violations":[{"id":12728998,"change_date":"2025-03-17 21:40:00","inspection_id":"84147882","insp_violation_id":"265084026","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:36.000000Z","normalized_code":"3922SLLS2"},{"id":12728999,"change_date":"2025-03-17 21:40:00","inspection_id":"84147882","insp_violation_id":"265084027","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":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:36.000000Z","normalized_code":"3922SLLSIV"},{"id":12729000,"change_date":"2025-03-17 21:40:00","inspection_id":"84147882","insp_violation_id":"265084028","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4498530","created_at":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:36.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13139877,"change_date":"2025-03-17 21:40:00","inspection_id":"84147882","insp_unit_id":"205841178","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BE01305","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV6R5T56622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:57:00.000000Z","updated_at":"2025-03-21T10:07:07.000000Z"}]},{"id":8136748,"change_date":"2025-03-17 21:40:00","inspection_id":"84147851","dot_number":"2044993","report_state":"MI","report_number":"ESCOT02545","insp_date":"2025-03-14 00:00:00","insp_start_time":"0740","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E I-96@8 MILE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1213446","transaction_code":"A","transaction_date":"2025-03-14 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:22:52.000000Z","updated_at":"2025-03-21T10:22:52.000000Z","inspection_violations":[{"id":12728927,"change_date":"2025-03-17 21:40:00","inspection_id":"84147851","insp_violation_id":"265083950","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:35.000000Z","normalized_code":"3922SLLLR"},{"id":12728928,"change_date":"2025-03-17 21:40:00","inspection_id":"84147851","insp_violation_id":"265083951","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205841130","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:35.000000Z","normalized_code":"39360C"},{"id":12728929,"change_date":"2025-03-17 21:40:00","inspection_id":"84147851","insp_violation_id":"265083952","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"205841130","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:46:43.000000Z","updated_at":"2025-03-21T10:55:35.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":13139830,"change_date":"2025-03-17 21:40:00","inspection_id":"84147851","insp_unit_id":"205841130","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"3205","insp_unit_license":"BD07956","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV7N5T50841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:57:00.000000Z","updated_at":"2025-03-21T10:07:06.000000Z"}]},{"id":7652340,"change_date":"2025-01-17 21:40:00","inspection_id":"83638708","dot_number":"2044993","report_state":"MI","report_number":"ESCOT02383","insp_date":"2025-01-16 00:00:00","insp_start_time":"1505","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E M-59@ROCHESTER RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S-C","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":"N","pen_cen_match":null,"final_status_date":"2025-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1207013","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:02.000000Z","updated_at":"2025-03-17T20:57:02.000000Z","inspection_violations":[{"id":11955108,"change_date":"2025-01-17 21:40:00","inspection_id":"83638708","insp_violation_id":"264060157","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204897321","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:13.000000Z","updated_at":"2025-03-17T22:04:13.000000Z","normalized_code":"3939ALHLI"},{"id":11955109,"change_date":"2025-01-17 21:40:00","inspection_id":"83638708","insp_violation_id":"264060158","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"204897321","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:13.000000Z","updated_at":"2025-03-17T22:04:13.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":12347659,"change_date":"2025-01-17 21:40:00","inspection_id":"83638708","insp_unit_id":"204897321","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BC51581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV4L4S76660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"}]},{"id":5565380,"change_date":"2024-04-22 21:40:00","inspection_id":"81410333","dot_number":"2044993","report_state":"MI","report_number":"NESBA01294","insp_date":"2024-04-19 00:00:00","insp_start_time":"0805","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@SQUIRREL RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1174751","transaction_code":"A","transaction_date":"2024-04-19 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-22 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:07.000000Z","updated_at":"2025-03-17T20:13:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8964741,"change_date":"2024-04-22 21:40:00","inspection_id":"81410333","insp_unit_id":"200508967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BC51581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV4L4S76660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:24.000000Z","updated_at":"2025-03-17T23:16:24.000000Z"}]},{"id":5181107,"change_date":"2024-02-29 21:48:00","inspection_id":"80990774","dot_number":"2044993","report_state":"MI","report_number":"BESSJ00383","insp_date":"2024-02-28 00:00:00","insp_start_time":"0650","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ MM-155","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-29 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1167120","transaction_code":"A","transaction_date":"2024-02-28 00:00:00","upload_date":"2024-02-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-29 21:48:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:19.000000Z","updated_at":"2025-03-17T20:05:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8342221,"change_date":"2024-02-29 21:48:00","inspection_id":"80990774","insp_unit_id":"199692904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"3203","insp_unit_license":"BD07956","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7AV7N5T5084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:35.000000Z","updated_at":"2025-03-17T23:10:35.000000Z"}]},{"id":4849341,"change_date":"2024-01-17 21:44:00","inspection_id":"80628428","dot_number":"2044993","report_state":"MI","report_number":"POWED04531","insp_date":"2024-01-16 00:00:00","insp_start_time":"1450","insp_end_time":"1520","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1160825","transaction_code":"A","transaction_date":"2024-01-16 00:00:00","upload_date":"2024-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-17 21:44:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:50.000000Z","updated_at":"2025-03-17T19:58:50.000000Z","inspection_violations":[{"id":7476117,"change_date":"2024-01-17 21:44:00","inspection_id":"80628428","insp_violation_id":"257377229","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198995677","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:02.000000Z","updated_at":"2025-03-17T21:42:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7802407,"change_date":"2024-01-17 21:44:00","inspection_id":"80628428","insp_unit_id":"198995677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"N\/A","insp_unit_license":"BD72339","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV7K4S74190","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:44.000000Z","updated_at":"2025-03-17T23:05:44.000000Z"}]},{"id":1869629,"change_date":"2022-12-05 21:40:00","inspection_id":"77282908","dot_number":"2044993","report_state":"MI","report_number":"STOCC03899","insp_date":"2022-12-02 00:00:00","insp_start_time":"0950","insp_end_time":"1030","registration_date":null,"region":"ET","ci_status_code":"C","location":"RUN","location_desc":"E\/B I94","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RIVIAN","shipping_paper_number":"2044993","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1104304","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-05 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:06.000000Z","updated_at":"2025-03-17T19:01:06.000000Z","inspection_violations":[{"id":2910717,"change_date":"2022-12-05 21:40:00","inspection_id":"77282908","insp_violation_id":"249914085","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4151506","created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3922"},{"id":2910718,"change_date":"2022-12-05 21:40:00","inspection_id":"77282908","insp_violation_id":"249914086","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"3958A1"},{"id":2910719,"change_date":"2022-12-05 21:40:00","inspection_id":"77282908","insp_violation_id":"249914087","seq_no":"3","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:53.000000Z","updated_at":"2025-03-17T21:20:53.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":3008946,"change_date":"2022-12-05 21:40:00","inspection_id":"77282908","insp_unit_id":"192255968","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC77225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML9NL337018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:35.000000Z","updated_at":"2025-03-17T22:27:35.000000Z"}]},{"id":1831221,"change_date":"2022-11-29 21:40:00","inspection_id":"77238970","dot_number":"2044993","report_state":"AL","report_number":"1836000535","insp_date":"2022-11-22 00:00:00","insp_start_time":"1005","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":"28","location_desc":"ROADSIDE","county_code_state":"AL","county_code":"049","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"932873","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-29 00:00:00","source_office":"2ALS001","mcmis_add_date":"2022-11-29 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"2201 TIMBERRIDGE DR","insp_carrier_city":"WEST BLOOMFIELD","insp_carrier_state":"MI","insp_carrier_zip_code":"48324","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:22.000000Z","updated_at":"2025-03-17T19:00:22.000000Z","inspection_violations":[{"id":2859425,"change_date":"2022-11-29 21:40:00","inspection_id":"77238970","insp_violation_id":"249823300","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U2131442","created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3922"},{"id":2859426,"change_date":"2022-11-29 21:40:00","inspection_id":"77238970","insp_violation_id":"249823301","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"U2131443","created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"3958A1"},{"id":2859427,"change_date":"2022-11-29 21:40:00","inspection_id":"77238970","insp_violation_id":"249823302","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"192164343","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:31.000000Z","updated_at":"2025-03-17T21:20:31.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":2946006,"change_date":"2022-11-29 21:40:00","inspection_id":"77238970","insp_unit_id":"192164343","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC46398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML2ML100319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:10.000000Z","updated_at":"2025-03-17T22:27:10.000000Z"}]},{"id":1707286,"change_date":"2022-11-09 21:40:00","inspection_id":"77096855","dot_number":"2044993","report_state":"IA","report_number":"000TT6CCRV","insp_date":"2022-11-08 00:00:00","insp_start_time":"1713","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TMCO, INC","shipping_paper_number":"7437630","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1250437","transaction_code":"A","transaction_date":"2022-11-08 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"482191715","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[{"id":2675358,"change_date":"2022-11-09 21:40:00","inspection_id":"77096855","insp_violation_id":"249517718","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"191882332","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:34.000000Z","updated_at":"2025-03-17T21:19:34.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":2746536,"change_date":"2022-11-09 21:40:00","inspection_id":"77096855","insp_unit_id":"191882332","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"310","insp_unit_license":"BC60140","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML8NL138090","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:48.000000Z","updated_at":"2025-03-17T22:25:48.000000Z"}]},{"id":1557051,"change_date":"2022-10-20 21:40:00","inspection_id":"76924380","dot_number":"2044993","report_state":"MD","report_number":"0158001484","insp_date":"2022-10-20 00:00:00","insp_start_time":"1452","insp_end_time":"1514","registration_date":null,"region":"ET","ci_status_code":"C","location":"057","location_desc":"WICOMICO COUNTY","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COOPERAGES 1912","shipping_paper_number":"URIQ-44295\/W27","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2582401","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-20 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-10-20 21:40:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:15.000000Z","updated_at":"2025-03-17T18:55:15.000000Z","inspection_violations":[{"id":2448664,"change_date":"2022-10-20 21:40:00","inspection_id":"76924380","insp_violation_id":"249137633","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3922"},{"id":2448665,"change_date":"2022-10-20 21:40:00","inspection_id":"76924380","insp_violation_id":"249137634","seq_no":"2","part_no":"395","part_no_section":"8(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:27.000000Z","updated_at":"2025-03-17T21:18:27.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":2505495,"change_date":"2022-10-20 21:40:00","inspection_id":"76924380","insp_unit_id":"191539120","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"100","insp_unit_license":"BC77225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML9NL337018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:11.000000Z","updated_at":"2025-03-17T22:24:11.000000Z"}]},{"id":1119336,"change_date":"2022-08-24 21:39:00","inspection_id":"76416916","dot_number":"2044993","report_state":"TX","report_number":"6DMK0JFP3D","insp_date":"2022-08-19 00:00:00","insp_start_time":"2030","insp_end_time":"2056","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A204","location_desc":"IH 20 WESTBOUND TYLER","county_code_state":"TX","county_code":"423","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GANDER OUTDOORS BREAUX BRIDGE","shipping_paper_number":"50772155","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"8752035","transaction_code":"C","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219-1715","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":"1035284","created_at":"2025-03-17T18:47:17.000000Z","updated_at":"2025-03-17T18:47:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1800620,"change_date":"2022-08-24 21:39:00","inspection_id":"76416916","insp_unit_id":"190523061","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC46398","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML2ML100319","insp_unit_decal":"Y","insp_unit_decal_number":"31579861","created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":573510,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","dot_number":"2044993","report_state":"MI","report_number":"MCSPA00138","insp_date":"2022-06-07 00:00:00","insp_start_time":"0819","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"HALL RD\/DENEWETH","county_code_state":"MI","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078655","transaction_code":"A","transaction_date":"2022-06-07 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-09 21:42:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:47.000000Z","updated_at":"2025-03-17T18:37:47.000000Z","inspection_violations":[{"id":897080,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","insp_violation_id":"246327369","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189140680","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"39617C"},{"id":897081,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","insp_violation_id":"246327370","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"M336021","created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"3922"},{"id":897082,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","insp_violation_id":"246327371","seq_no":"3","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"3927A"},{"id":897083,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","insp_violation_id":"246327372","seq_no":"4","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:12.000000Z","updated_at":"2025-03-17T21:11:12.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":922301,"change_date":"2022-06-09 21:42:00","inspection_id":"75776238","insp_unit_id":"189140680","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"102010","insp_unit_license":"BC51581","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ8JV4L4S76660","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:53.000000Z","updated_at":"2025-03-17T22:13:53.000000Z"}]},{"id":413692,"change_date":"2022-05-18 21:43:00","inspection_id":"75586384","dot_number":"2044993","report_state":"ME","report_number":"0242001645","insp_date":"2022-05-18 00:00:00","insp_start_time":"2019","insp_end_time":"2055","registration_date":null,"region":"ET","ci_status_code":"C","location":"000295","location_desc":"KITTERY","county_code_state":"ME","county_code":"031","insp_level_id":"3","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":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"347115","transaction_code":"A","transaction_date":"2022-05-18 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:48.000000Z","updated_at":"2025-03-17T18:34:48.000000Z","inspection_violations":[{"id":647483,"change_date":"2022-05-18 21:43:00","inspection_id":"75586384","insp_violation_id":"245864197","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3922"},{"id":647484,"change_date":"2022-05-18 21:43:00","inspection_id":"75586384","insp_violation_id":"245864198","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:03.000000Z","updated_at":"2025-03-17T21:10:03.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":667742,"change_date":"2022-05-18 21:43:00","inspection_id":"75586384","insp_unit_id":"188745311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC77225","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML9NL337018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:18.000000Z","updated_at":"2025-03-17T22:12:18.000000Z"}]},{"id":231821,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","dot_number":"2044993","report_state":"NY","report_number":"SPC0240824","insp_date":"2022-04-21 00:00:00","insp_start_time":"0831","insp_end_time":"0932","registration_date":null,"region":"ET","ci_status_code":"C","location":"60585A","location_desc":"NICHOLS (EB)","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"51338 ROMEO RIM","shipping_paper_number":"B22223447604","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"7","oos_total":"4","driver_viol_total":"5","driver_oos_total":"4","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2697899","transaction_code":"A","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02044993","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-22 21:41:00","insp_carrier_name":"ANDREWS DELIVERY SERVICE INC","insp_carrier_street":"19490 BERG ROAD","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48219-1715","insp_colonia":null,"docket_number":"716887","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:34.000000Z","updated_at":"2025-03-17T18:31:34.000000Z","inspection_violations":[{"id":356402,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314412","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3922"},{"id":356403,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314413","seq_no":"2","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"39115A"},{"id":356404,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314414","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3958E1"},{"id":356405,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314415","seq_no":"4","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3953A2"},{"id":356406,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314416","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"3958A1"},{"id":356407,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314417","seq_no":"6","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"188288301","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"39381"},{"id":356408,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_violation_id":"245314418","seq_no":"7","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"188288301","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7FCDTGR","created_at":"2025-03-17T21:08:44.000000Z","updated_at":"2025-03-17T21:08:44.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":375665,"change_date":"2022-04-22 21:41:00","inspection_id":"75369373","insp_unit_id":"188288301","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC83963","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACWFC5NDNK5509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:31.000000Z","updated_at":"2025-03-17T22:10:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2044993\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2044993\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2044993\/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\/2044993\/inspections","per_page":100,"prev_page_url":null,"to":24,"total":24}