{"current_page":1,"data":[{"id":12353927,"change_date":"2026-07-03 21:37:00","inspection_id":"88315081","dot_number":"2080966","report_state":"MI","report_number":"BENNK01187","insp_date":"2026-07-03 00:00:00","insp_start_time":"0824","insp_end_time":"0830","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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-07-03 21:37: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":"3678100","transaction_code":"A","transaction_date":"2026-07-03 00:00:00","upload_date":"2026-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":"2026-07-03 21:37:00","snet_input_date":"2026-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-03 21:37:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-06T09:43:22.000000Z","updated_at":"2026-07-14T09:32:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21453576,"change_date":"2026-07-03 21:37:00","inspection_id":"88315081","insp_unit_id":"214438312","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD59937","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML3JL230925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-06T09:21:38.000000Z","updated_at":"2026-07-14T09:04:22.000000Z"}]},{"id":12345454,"change_date":"2026-07-02 21:40:00","inspection_id":"88305156","dot_number":"2080966","report_state":"MI","report_number":"ROLLJ03131","insp_date":"2026-07-02 00:00:00","insp_start_time":"1450","insp_end_time":"1503","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","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":"2026-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3673866","transaction_code":"A","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":"2026-07-02 21:40:00","snet_input_date":"2026-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-02 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-05T09:42:16.000000Z","updated_at":"2026-07-14T09:31:01.000000Z","inspection_violations":[{"id":21488032,"change_date":"2026-07-02 21:40:00","inspection_id":"88305156","insp_violation_id":"275274734","seq_no":"1","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4722263","created_at":"2026-07-05T10:05:41.000000Z","updated_at":"2026-07-14T09:42:44.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":21439347,"change_date":"2026-07-02 21:40:00","inspection_id":"88305156","insp_unit_id":"214419677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD59937","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML3JL230925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:45.000000Z","updated_at":"2026-07-14T09:02:21.000000Z"}]},{"id":11884083,"change_date":"2026-05-12 21:39:00","inspection_id":"87821866","dot_number":"2080966","report_state":"MI","report_number":"MCKEN00379","insp_date":"2026-05-12 00:00:00","insp_start_time":"0940","insp_end_time":"0955","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"3304728","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-14T12:39:27.000000Z","updated_at":"2026-05-23T09:30:45.000000Z","inspection_violations":[{"id":20669916,"change_date":"2026-05-12 21:39:00","inspection_id":"87821866","insp_violation_id":"274194783","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":"2026-05-14T12:58:52.000000Z","updated_at":"2026-05-23T09:44:22.000000Z","normalized_code":"3922SLLSR"},{"id":20669917,"change_date":"2026-05-12 21:39:00","inspection_id":"87821866","insp_violation_id":"274194784","seq_no":"2","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-14T12:58:52.000000Z","updated_at":"2026-05-23T09:44:22.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":20662773,"change_date":"2026-05-12 21:39:00","inspection_id":"87821866","insp_unit_id":"213501008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD59937","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML3JL230925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:27.000000Z","updated_at":"2026-05-23T09:03:22.000000Z"}]},{"id":11665538,"change_date":"2026-04-16 21:41:00","inspection_id":"87595866","dot_number":"2080966","report_state":"MI","report_number":"OSHEE02834","insp_date":"2026-04-16 00:00:00","insp_start_time":"1111","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ CADILLAC REST AREA","county_code_state":"MI","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1266452","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-04-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:31:36.000000Z","updated_at":"2026-04-27T09:31:36.000000Z","inspection_violations":[{"id":20262011,"change_date":"2026-04-16 21:41:00","inspection_id":"87595866","insp_violation_id":"273649486","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":"X4679260","created_at":"2026-04-27T09:44:56.000000Z","updated_at":"2026-04-27T09:44:56.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":20292554,"change_date":"2026-04-16 21:41:00","inspection_id":"87595866","insp_unit_id":"213054082","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9013","insp_unit_license":"BD59937","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML3JL230925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:38.000000Z","updated_at":"2026-04-27T09:04:38.000000Z"}]},{"id":9878405,"change_date":"2025-10-07 21:41:00","inspection_id":"85981773","dot_number":"2080966","report_state":"MI","report_number":"WASCC01155","insp_date":"2025-10-06 00:00:00","insp_start_time":"0930","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"112TH AVE OFF RAMP","county_code_state":"MI","county_code":"139","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA 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-10-07 21:41: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":"1245044","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-07 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-10T10:02:27.000000Z","updated_at":"2025-10-11T10:01:05.000000Z","inspection_violations":[{"id":16283399,"change_date":"2025-10-07 21:41:00","inspection_id":"85981773","insp_violation_id":"269154040","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-10-10T10:18:40.000000Z","updated_at":"2025-10-11T10:16:59.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":16388430,"change_date":"2025-10-07 21:41:00","inspection_id":"85981773","insp_unit_id":"209345557","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BE43191","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACWFC6TDWJ0145","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-10T09:47:49.000000Z","updated_at":"2025-10-11T09:46:26.000000Z"}]},{"id":9499642,"change_date":"2025-08-25 21:40:00","inspection_id":"85584373","dot_number":"2080966","report_state":"MI","report_number":"KELLC02334","insp_date":"2025-08-22 00:00:00","insp_start_time":"0814","insp_end_time":"0820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32EB @ HAAS RD","county_code_state":"MI","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-25 21:40: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":"1237617","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-25 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-29T10:42:44.000000Z","updated_at":"2025-08-29T10:42:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15673649,"change_date":"2025-08-25 21:40:00","inspection_id":"85584373","insp_unit_id":"208569582","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9016","insp_unit_license":"BD93110","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML0JH349991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:36.000000Z","updated_at":"2025-08-29T09:46:02.000000Z"}]},{"id":9450668,"change_date":"2025-08-19 21:40:00","inspection_id":"85532843","dot_number":"2080966","report_state":"MI","report_number":"LITTJ05581","insp_date":"2025-08-18 00:00:00","insp_start_time":"0840","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-94 W\/B @ RAWSONVILLE","county_code_state":"MI","county_code":"163","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1236999","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:30.000000Z","updated_at":"2025-08-23T10:46:30.000000Z","inspection_violations":[{"id":15390065,"change_date":"2025-08-19 21:40:00","inspection_id":"85532843","insp_violation_id":"268118527","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":"X4566050","created_at":"2025-08-22T10:45:00.000000Z","updated_at":"2025-08-23T10:48:20.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":15583675,"change_date":"2025-08-19 21:40:00","inspection_id":"85532843","insp_unit_id":"208472470","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9013","insp_unit_license":"BD59937","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAMMMML3JL230925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:07.000000Z"}]},{"id":9439808,"change_date":"2025-08-18 21:39:00","inspection_id":"85521490","dot_number":"2080966","report_state":"MI","report_number":"RICKE00769","insp_date":"2025-08-14 00:00:00","insp_start_time":"1245","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"E\/B M-32 & HALLENIUS RD","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1236749","transaction_code":"A","transaction_date":"2025-08-14 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:45:58.000000Z","updated_at":"2025-08-23T10:45:58.000000Z","inspection_violations":[{"id":15366317,"change_date":"2025-08-18 21:39:00","inspection_id":"85521490","insp_violation_id":"268092268","seq_no":"1","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3929ADFSL"},{"id":15366318,"change_date":"2025-08-18 21:39:00","inspection_id":"85521490","insp_violation_id":"268092269","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","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-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"39021TELCMVINFO"},{"id":15366319,"change_date":"2025-08-18 21:39:00","inspection_id":"85521490","insp_violation_id":"268092270","seq_no":"3","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":null,"created_at":"2025-08-21T10:42:32.000000Z","updated_at":"2025-08-22T10:43:57.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15563895,"change_date":"2025-08-18 21:39:00","inspection_id":"85521490","insp_unit_id":"208451324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"BE43232","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5PVNJ7DV4T5T52474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:43.000000Z","updated_at":"2025-08-22T09:46:04.000000Z"}]},{"id":9177235,"change_date":"2025-07-17 21:42:00","inspection_id":"85245175","dot_number":"2080966","report_state":"MI","report_number":"KELLC02272","insp_date":"2025-07-16 00:00:00","insp_start_time":"1120","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M55 @ ITHACA RD","county_code_state":"MI","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","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-07-17 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":"1231011","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:18.000000Z","updated_at":"2025-07-21T10:43:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15080843,"change_date":"2025-07-17 21:42:00","inspection_id":"85245175","insp_unit_id":"207930378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"PNF6341","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMML5SL503725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:31.000000Z","updated_at":"2025-07-21T09:46:04.000000Z"}]},{"id":9077494,"change_date":"2025-07-07 21:40:00","inspection_id":"85140379","dot_number":"2080966","report_state":"MI","report_number":"MCGEJ03574","insp_date":"2025-07-03 00:00:00","insp_start_time":"0640","insp_end_time":"0655","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I75 NB @ MM 227","county_code_state":"MI","county_code":"143","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1229023","transaction_code":"A","transaction_date":"2025-07-03 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-07 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:34.000000Z","updated_at":"2025-07-11T10:44:34.000000Z","inspection_violations":[{"id":14614909,"change_date":"2025-07-07 21:40:00","inspection_id":"85140379","insp_violation_id":"267237304","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207729853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-10T10:42:38.000000Z","updated_at":"2025-07-11T10:45:57.000000Z","normalized_code":"3939ALHLI"},{"id":14614910,"change_date":"2025-07-07 21:40:00","inspection_id":"85140379","insp_violation_id":"267237305","seq_no":"2","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"207729853","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:38.000000Z","updated_at":"2025-07-11T10:45:57.000000Z","normalized_code":"39021TELCMVINFO"}],"inspection_per_units":[{"id":14896229,"change_date":"2025-07-07 21:40:00","inspection_id":"85140379","insp_unit_id":"207729853","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"PNF6342","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3HAEUMML5SL503725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:52.000000Z"}]},{"id":8702297,"change_date":"2025-05-21 21:42:00","inspection_id":"84743263","dot_number":"2080966","report_state":"MI","report_number":"PENNJ01124","insp_date":"2025-05-19 00:00:00","insp_start_time":"1410","insp_end_time":"1445","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-10 @ WILDWOOD CRST","county_code_state":"MI","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOME DEPOT","shipping_paper_number":"2505367493","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-21 21:42: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":"1222077","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:24.000000Z","updated_at":"2025-05-25T10:06:32.000000Z","inspection_violations":[{"id":13870319,"change_date":"2025-05-21 21:42:00","inspection_id":"84743263","insp_violation_id":"266381132","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":"X4523606","created_at":"2025-05-24T10:27:54.000000Z","updated_at":"2025-05-25T10:24:50.000000Z","normalized_code":"39141APC"},{"id":13870320,"change_date":"2025-05-21 21:42:00","inspection_id":"84743263","insp_violation_id":"266381133","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":null,"created_at":"2025-05-24T10:27:54.000000Z","updated_at":"2025-05-25T10:24:50.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":14220686,"change_date":"2025-05-21 21:42:00","inspection_id":"84743263","insp_unit_id":"206992386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD52418","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML0RL658404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:10.000000Z"}]},{"id":8660999,"change_date":"2026-02-04 21:39:00","inspection_id":"84699632","dot_number":"2080966","report_state":"MI","report_number":"HINCA00679","insp_date":"2025-05-16 00:00:00","insp_start_time":"0715","insp_end_time":"0730","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B M-32 @ MEIJER","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT GAYLORD","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":"2026-02-03 21:39: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":"1221813","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":"M","census_search_date":"2026-02-03 21:39:00","snet_input_date":"2025-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-16 21:43:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:27.000000Z","updated_at":"2026-02-15T10:30:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18368649,"change_date":"2026-02-04 21:39:00","inspection_id":"84699632","insp_unit_id":"211440655","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49192","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML0RL826820","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:58.000000Z","updated_at":"2026-02-15T10:04:50.000000Z"}]},{"id":7405729,"change_date":"2024-12-12 21:41:00","inspection_id":"83379721","dot_number":"2080966","report_state":"MI","report_number":"WERNR01352","insp_date":"2024-12-10 00:00:00","insp_start_time":"1350","insp_end_time":"1404","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MBA","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1204084","transaction_code":"A","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:44.000000Z","updated_at":"2025-03-17T20:50:44.000000Z","inspection_violations":[{"id":11572253,"change_date":"2024-12-12 21:41:00","inspection_id":"83379721","insp_violation_id":"263421734","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-17T22:02:20.000000Z","updated_at":"2025-03-17T22:02:20.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":11946959,"change_date":"2024-12-12 21:41:00","inspection_id":"83379721","insp_unit_id":"204349324","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4RL826819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:54.000000Z","updated_at":"2025-03-17T23:46:54.000000Z"}]},{"id":7372473,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","dot_number":"2080966","report_state":"MI","report_number":"RICKE00361","insp_date":"2024-12-09 00:00:00","insp_start_time":"0815","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B M-66 & M-55 (NORTH)","county_code_state":"MI","county_code":"113","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1203750","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:49.000000Z","updated_at":"2025-03-17T20:49:49.000000Z","inspection_violations":[{"id":11520005,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","insp_violation_id":"263331878","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":"WARNING","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLS3"},{"id":11520006,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","insp_violation_id":"263331879","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":"N","defect_verification_id":"3","citation_number":"X4466951","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"39141AMCPC"},{"id":11520007,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","insp_violation_id":"263331880","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":"X4467037","created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLSR"},{"id":11520008,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","insp_violation_id":"263331881","seq_no":"4","part_no":"392","part_no_section":"2-SLLDL","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-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"3922SLLDL"}],"inspection_per_units":[{"id":11893231,"change_date":"2024-12-09 21:41:00","inspection_id":"83344908","insp_unit_id":"204271564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9016","insp_unit_license":"BD93110","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTMMMML0JH349991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:19.000000Z","updated_at":"2025-03-17T23:46:19.000000Z"}]},{"id":6923561,"change_date":"2024-10-09 21:42:00","inspection_id":"82869534","dot_number":"2080966","report_state":"MI","report_number":"BROWP02169","insp_date":"2024-10-08 00:00:00","insp_start_time":"1205","insp_end_time":"1220","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M-129 N\/B & 7 MILE ROAD","county_code_state":"MI","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"THE HOME DEPOT","shipping_paper_number":"WM84089699","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1197580","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:36.000000Z","updated_at":"2025-03-17T20:40:36.000000Z","inspection_violations":[{"id":10789923,"change_date":"2024-10-09 21:42:00","inspection_id":"82869534","insp_violation_id":"262268351","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"3922"},{"id":10789924,"change_date":"2024-10-09 21:42:00","inspection_id":"82869534","insp_violation_id":"262268352","seq_no":"2","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"203339262","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:15.000000Z","updated_at":"2025-03-17T21:58:15.000000Z","normalized_code":"3929AA1"}],"inspection_per_units":[{"id":11166185,"change_date":"2024-10-09 21:42:00","inspection_id":"82869534","insp_unit_id":"203339262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4RL826819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6680374,"change_date":"2024-09-17 21:45:00","inspection_id":"82610854","dot_number":"2080966","report_state":"MI","report_number":"MALOJ01820","insp_date":"2024-09-05 00:00:00","insp_start_time":"0820","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HOME DEPOT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"1194061","transaction_code":"C","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:37.000000Z","updated_at":"2025-03-17T20:35:37.000000Z","inspection_violations":[{"id":10396748,"change_date":"2024-09-17 21:45:00","inspection_id":"82610854","insp_violation_id":"261868270","seq_no":"1","part_no":"390","part_no_section":"21T(e)","insp_viol_unit":"1","insp_unit_id":"202982229","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"39021TE"},{"id":10396749,"change_date":"2024-09-17 21:45:00","inspection_id":"82610854","insp_violation_id":"261868271","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202982229","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10771044,"change_date":"2024-09-17 21:45:00","inspection_id":"82610854","insp_unit_id":"202982229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4RL4RL826","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6274269,"change_date":"2024-09-17 21:45:00","inspection_id":"82177436","dot_number":"2080966","report_state":"MI","report_number":"KELLC02120","insp_date":"2024-07-22 00:00:00","insp_start_time":"0728","insp_end_time":"0737","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32EB @ YOUNGS RD","county_code_state":"MI","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-22 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":"1186927","transaction_code":"C","transaction_date":"2024-07-22 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-22 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:02.000000Z","updated_at":"2025-03-17T20:27:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10109059,"change_date":"2024-09-17 21:45:00","inspection_id":"82177436","insp_unit_id":"202980293","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BD49152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4RL826819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:44.000000Z","updated_at":"2025-03-17T23:27:44.000000Z"}]},{"id":5929954,"change_date":"2024-06-06 21:41:00","inspection_id":"81806423","dot_number":"2080966","report_state":"MI","report_number":"HAMIZ01075","insp_date":"2024-06-05 00:00:00","insp_start_time":"1442","insp_end_time":"1451","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32WB @ DOUGLAS LAKE RD","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1181082","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":9195767,"change_date":"2024-06-06 21:41:00","inspection_id":"81806423","insp_violation_id":"259943434","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9551314,"change_date":"2024-06-06 21:41:00","inspection_id":"81806423","insp_unit_id":"201268983","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BD49152","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML4RL826819","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:04.000000Z","updated_at":"2025-03-17T23:22:04.000000Z"}]},{"id":5607911,"change_date":"2024-04-26 21:39:00","inspection_id":"81456568","dot_number":"2080966","report_state":"MI","report_number":"JURKV02571","insp_date":"2024-04-24 00:00:00","insp_start_time":"0655","insp_end_time":"0719","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1175664","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8670197,"change_date":"2024-04-26 21:39:00","inspection_id":"81456568","insp_violation_id":"259167674","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9033191,"change_date":"2024-04-26 21:39:00","inspection_id":"81456568","insp_unit_id":"200598689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BC62735","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMMLXNL290677","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5608201,"change_date":"2024-04-26 21:39:00","inspection_id":"81456897","dot_number":"2080966","report_state":"MI","report_number":"RICKE00023","insp_date":"2024-04-24 00:00:00","insp_start_time":"1400","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"N\/B BUS 127 NEAR US-127","county_code_state":"MI","county_code":"035","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1175488","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:52.000000Z","updated_at":"2025-03-17T20:13:52.000000Z","inspection_violations":[{"id":8670790,"change_date":"2024-04-26 21:39:00","inspection_id":"81456897","insp_violation_id":"259168463","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4367574","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39216A"},{"id":8670791,"change_date":"2024-04-26 21:39:00","inspection_id":"81456897","insp_violation_id":"259168464","seq_no":"2","part_no":"396","part_no_section":"17(c)","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-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9033694,"change_date":"2024-04-26 21:39:00","inspection_id":"81456897","insp_unit_id":"200599272","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9012","insp_unit_license":"BD49160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML5RL180383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:03.000000Z","updated_at":"2025-03-17T23:17:03.000000Z"}]},{"id":5370911,"change_date":"2024-03-26 21:43:00","inspection_id":"81197908","dot_number":"2080966","report_state":"MI","report_number":"FRIZS02956","insp_date":"2024-03-25 00:00:00","insp_start_time":"1123","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E. PICKARD RD @ E. COUNTYLINE","county_code_state":"MI","county_code":"073","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ 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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1170506","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-26 21:43:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:04.000000Z","updated_at":"2025-03-17T20:09:04.000000Z","inspection_violations":[{"id":8288088,"change_date":"2024-03-26 21:43:00","inspection_id":"81197908","insp_violation_id":"258587968","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","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:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"39141A1"},{"id":8288089,"change_date":"2024-03-26 21:43:00","inspection_id":"81197908","insp_violation_id":"258587969","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"C","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:07.000000Z","updated_at":"2025-03-17T21:46:07.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":8649891,"change_date":"2024-03-26 21:43:00","inspection_id":"81197908","insp_unit_id":"200092975","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"7V23N3","insp_unit_license":"BC60130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML2NL138084","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:26.000000Z","updated_at":"2025-03-17T23:13:26.000000Z"}]},{"id":5286999,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","dot_number":"2080966","report_state":"MI","report_number":"WATTR03796","insp_date":"2024-03-14 00:00:00","insp_start_time":"0901","insp_end_time":"1009","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"JOY RD","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","shipping_paper_number":"108099583","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1169068","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-14 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:28.000000Z","updated_at":"2025-03-17T20:07:28.000000Z","inspection_violations":[{"id":8152277,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383771","seq_no":"1","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:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39141A"},{"id":8152278,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383772","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199914295","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4330222","created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3922"},{"id":8152279,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383773","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199914295","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4330222","created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3922"},{"id":8152280,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383774","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199914295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"},{"id":8152281,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383775","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199914295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"},{"id":8152282,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_violation_id":"258383776","seq_no":"6","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4326247","created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"39111B5"}],"inspection_per_units":[{"id":8513936,"change_date":"2024-03-14 21:41:00","inspection_id":"81106444","insp_unit_id":"199914295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3561","insp_unit_license":"BC27549","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDC36HW55092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:09.000000Z","updated_at":"2025-03-17T23:12:09.000000Z"}]},{"id":5052776,"change_date":"2024-02-14 21:42:00","inspection_id":"80851078","dot_number":"2080966","report_state":"MI","report_number":"ELDEH00383","insp_date":"2024-02-13 00:00:00","insp_start_time":"0715","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75NB @ MAPLE RD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/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":"2024-02-14 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":"1164663","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8133317,"change_date":"2024-02-14 21:42:00","inspection_id":"80851078","insp_unit_id":"199425915","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"NONE","insp_unit_license":"BD28088","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML8PL260404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:41.000000Z","updated_at":"2025-03-17T23:08:41.000000Z"}]},{"id":4802968,"change_date":"2024-01-10 21:44:00","inspection_id":"80577775","dot_number":"2080966","report_state":"MI","report_number":"LAUEJ01531","insp_date":"2024-01-09 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"831","location_desc":"MACKINAC BRIDGE","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-10 21:44: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":"1160029","transaction_code":"A","transaction_date":"2024-01-09 00:00:00","upload_date":"2024-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-10 21:44:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":7408635,"change_date":"2024-01-10 21:44:00","inspection_id":"80577775","insp_violation_id":"257274105","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:41:46.000000Z","updated_at":"2025-03-17T21:41:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7727560,"change_date":"2024-01-10 21:44:00","inspection_id":"80577775","insp_unit_id":"198898524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD56707","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML8NL060863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:03.000000Z","updated_at":"2025-03-17T23:05:03.000000Z"}]},{"id":4374495,"change_date":"2023-11-07 21:41:00","inspection_id":"80107796","dot_number":"2080966","report_state":"MI","report_number":"MANIJ01484","insp_date":"2023-11-06 00:00:00","insp_start_time":"1055","insp_end_time":"1133","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"017","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1152515","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-07 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:33.000000Z","updated_at":"2025-03-17T19:49:33.000000Z","inspection_violations":[{"id":6766715,"change_date":"2023-11-07 21:41:00","inspection_id":"80107796","insp_violation_id":"256267361","seq_no":"1","part_no":"392","part_no_section":"82(a)(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":"X4295827","created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39282A1"},{"id":6766716,"change_date":"2023-11-07 21:41:00","inspection_id":"80107796","insp_violation_id":"256267362","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4295827","created_at":"2025-03-17T21:38:35.000000Z","updated_at":"2025-03-17T21:38:35.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":7035389,"change_date":"2023-11-07 21:41:00","inspection_id":"80107796","insp_unit_id":"197950080","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML5RL180383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:04.000000Z","updated_at":"2025-03-17T22:59:04.000000Z"}]},{"id":3858842,"change_date":"2023-08-29 21:42:00","inspection_id":"79535840","dot_number":"2080966","report_state":"MI","report_number":"BACZM02057","insp_date":"2023-08-29 00:00:00","insp_start_time":"0903","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I75 NB @ WILSON RD","county_code_state":"MI","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOME DEPOT","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1143368","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5960245,"change_date":"2023-08-29 21:42:00","inspection_id":"79535840","insp_violation_id":"254954077","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:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"3922"},{"id":5960246,"change_date":"2023-08-29 21:42:00","inspection_id":"79535840","insp_violation_id":"254954078","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:53.000000Z","updated_at":"2025-03-17T21:34:53.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":6203858,"change_date":"2023-08-29 21:42:00","inspection_id":"79535840","insp_unit_id":"196789174","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"75","insp_unit_license":"BD53221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDJ7C1356F433258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3674464,"change_date":"2023-08-29 21:42:00","inspection_id":"79330083","dot_number":"2080966","report_state":"MI","report_number":"ZASTM01625","insp_date":"2023-08-03 00:00:00","insp_start_time":"1112","insp_end_time":"1120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ EXIT 352","county_code_state":"MI","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-04 21:41: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":"1138529","transaction_code":"C","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:19.000000Z","updated_at":"2025-03-17T19:35:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5907675,"change_date":"2023-08-29 21:42:00","inspection_id":"79330083","insp_unit_id":"196790340","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"9008","insp_unit_license":"BC95367","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML8NL060863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:40.000000Z","updated_at":"2025-03-17T22:49:40.000000Z"}]},{"id":3375392,"change_date":"2023-06-27 21:40:00","inspection_id":"78993974","dot_number":"2080966","report_state":"MI","report_number":"DOWEM02448","insp_date":"2023-06-27 00:00:00","insp_start_time":"0720","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M55 NEAR CROOKED RD","county_code_state":"MI","county_code":"143","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1132373","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:48.000000Z","updated_at":"2025-03-17T19:29:48.000000Z","inspection_violations":[{"id":5204629,"change_date":"2023-06-27 21:40:00","inspection_id":"78993974","insp_violation_id":"253724296","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4236465","created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"39145B"},{"id":5204630,"change_date":"2023-06-27 21:40:00","inspection_id":"78993974","insp_violation_id":"253724297","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":null,"created_at":"2025-03-17T21:31:10.000000Z","updated_at":"2025-03-17T21:31:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5426106,"change_date":"2023-06-27 21:40:00","inspection_id":"78993974","insp_unit_id":"195696849","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"BD49160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML5RL180383","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:49.000000Z","updated_at":"2025-03-17T22:45:49.000000Z"}]},{"id":2614000,"change_date":"2023-03-20 21:41:00","inspection_id":"78132606","dot_number":"2080966","report_state":"MI","report_number":"BENNK00218","insp_date":"2023-03-17 00:00:00","insp_start_time":"1235","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M32 @ WISCONSIN AVE","county_code_state":"MI","county_code":"137","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"1118342","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:52.000000Z","updated_at":"2025-03-17T19:14:52.000000Z","inspection_violations":[{"id":4019984,"change_date":"2023-03-20 21:41:00","inspection_id":"78132606","insp_violation_id":"251755493","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":4207891,"change_date":"2023-03-20 21:41:00","inspection_id":"78132606","insp_unit_id":"193956713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"0591","insp_unit_license":"BC95367","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3HAEUMML8NL060863","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"}]},{"id":2543669,"change_date":"2023-03-09 21:42:00","inspection_id":"78052357","dot_number":"2080966","report_state":"MI","report_number":"GRAHA00124","insp_date":"2023-03-08 00:00:00","insp_start_time":"1525","insp_end_time":"1610","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 69 EB @ M53","county_code_state":"MI","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1116703","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[{"id":3911848,"change_date":"2023-03-09 21:42:00","inspection_id":"78052357","insp_violation_id":"251571811","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"},{"id":3911849,"change_date":"2023-03-09 21:42:00","inspection_id":"78052357","insp_violation_id":"251571812","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4176547","created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"39141A"},{"id":3911850,"change_date":"2023-03-09 21:42:00","inspection_id":"78052357","insp_violation_id":"251571813","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4176547","created_at":"2025-03-17T21:25:21.000000Z","updated_at":"2025-03-17T21:25:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4094156,"change_date":"2023-03-09 21:42:00","inspection_id":"78052357","insp_unit_id":"193792755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"3564","insp_unit_license":"BB46957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDK7C1C97F900350","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":1046122,"change_date":"2022-08-16 21:38:00","inspection_id":"76331128","dot_number":"2080966","report_state":"MI","report_number":"PRIED01952","insp_date":"2022-08-15 00:00:00","insp_start_time":"1359","insp_end_time":"1414","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"REMUS @ WYMAN","county_code_state":"MI","county_code":"073","insp_level_id":"2","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-08-16 21:38: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":"1089483","transaction_code":"A","transaction_date":"2022-08-15 00:00:00","upload_date":"2022-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-16 21:38:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:10.000000Z","updated_at":"2025-03-17T18:46:10.000000Z","inspection_violations":[{"id":1647292,"change_date":"2022-08-16 21:38:00","inspection_id":"76331128","insp_violation_id":"247738700","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4098894","created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1683210,"change_date":"2022-08-16 21:38:00","inspection_id":"76331128","insp_unit_id":"190330798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC60459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT4FHG57899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:36.000000Z","updated_at":"2025-03-17T22:18:36.000000Z"}]},{"id":914612,"change_date":"2022-07-28 21:40:00","inspection_id":"76177291","dot_number":"2080966","report_state":"OH","report_number":"0215000167","insp_date":"2022-07-28 00:00:00","insp_start_time":"0705","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"025","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HOME DEPOT","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":"I","final_status_date":"2022-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"83298","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":"1608905","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-28 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:44.000000Z","updated_at":"2025-03-17T18:43:44.000000Z","inspection_violations":[{"id":1441974,"change_date":"2022-07-28 21:40:00","inspection_id":"76177291","insp_violation_id":"247373073","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:51.000000Z","updated_at":"2025-03-17T21:13:51.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1472265,"change_date":"2022-07-28 21:40:00","inspection_id":"76177291","insp_unit_id":"190016105","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"122561","insp_unit_license":"2318601","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEDV1GSGS7897","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:15.000000Z","updated_at":"2025-03-17T22:17:15.000000Z"},{"id":1472266,"change_date":"2022-07-28 21:40:00","inspection_id":"76177291","insp_unit_id":"190016106","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"60387B","insp_unit_license":"U682506","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1GRDM732HH732193","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:15.000000Z","updated_at":"2025-03-17T22:17:15.000000Z"}]},{"id":243190,"change_date":"2022-06-09 21:42:00","inspection_id":"75383046","dot_number":"2080966","report_state":"MI","report_number":"MANIJ01077","insp_date":"2022-04-22 00:00:00","insp_start_time":"0953","insp_end_time":"1004","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"YES","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1072688","transaction_code":"C","transaction_date":"2022-04-22 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:51.000000Z","updated_at":"2025-03-17T18:31:51.000000Z","inspection_violations":[{"id":373616,"change_date":"2022-06-09 21:42:00","inspection_id":"75383046","insp_violation_id":"246338272","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"3922"},{"id":373617,"change_date":"2022-06-09 21:42:00","inspection_id":"75383046","insp_violation_id":"246338273","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":394399,"change_date":"2022-06-09 21:42:00","inspection_id":"75383046","insp_unit_id":"189149373","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC60459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT4FHGS7899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:37.000000Z","updated_at":"2025-03-17T22:10:37.000000Z"}]},{"id":71887,"change_date":"2022-03-30 21:40:00","inspection_id":"75176026","dot_number":"2080966","report_state":"MI","report_number":"MANIJ01057","insp_date":"2022-03-29 00:00:00","insp_start_time":"0740","insp_end_time":"0759","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"129","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-30 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":"1069815","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02080966","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-30 21:40:00","insp_carrier_name":"REALDEAL TRANSPORT LLC","insp_carrier_street":"10525 WAYBURN","insp_carrier_city":"DETROIT","insp_carrier_state":"MI","insp_carrier_zip_code":"48224","insp_colonia":null,"docket_number":"726523","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:48.000000Z","updated_at":"2025-03-17T18:28:48.000000Z","inspection_violations":[{"id":105001,"change_date":"2022-03-30 21:40:00","inspection_id":"75176026","insp_violation_id":"244861996","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:35.000000Z","updated_at":"2025-03-17T21:07:35.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":116715,"change_date":"2022-03-30 21:40:00","inspection_id":"75176026","insp_unit_id":"187897418","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"BC60459","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWDT4FHGS7899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:56.000000Z","updated_at":"2025-03-17T22:08:56.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2080966\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2080966\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2080966\/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\/2080966\/inspections","per_page":100,"prev_page_url":null,"to":34,"total":34}