{"current_page":1,"data":[{"id":12628207,"change_date":"2026-08-04 21:39:00","inspection_id":"88599146","dot_number":"1055587","report_state":"MI","report_number":"DIUBJ04320","insp_date":"2026-08-03 00:00:00","insp_start_time":"1950","insp_end_time":"2011","registration_date":null,"region":"ED","ci_status_code":"C","location":"141","location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS INDUST","shipping_paper_number":"456271","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-08-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3901042","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2026-08-04 21:39:00","snet_input_date":"2026-08-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-04 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-07T09:39:40.000000Z","updated_at":"2026-08-15T09:30:43.000000Z","inspection_violations":[{"id":21986003,"change_date":"2026-08-04 21:39:00","inspection_id":"88599146","insp_violation_id":"275911215","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"214969347","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-07T09:57:11.000000Z","updated_at":"2026-08-15T09:42:16.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":21922107,"change_date":"2026-08-04 21:39:00","inspection_id":"88599146","insp_unit_id":"214969347","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"3","insp_unit_license":"RC51243","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR8KLKF7505","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:21.000000Z","updated_at":"2026-08-15T09:01:52.000000Z"},{"id":21922108,"change_date":"2026-08-04 21:39:00","inspection_id":"88599146","insp_unit_id":"214969348","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"539968","insp_unit_license":"F199612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D9SL519968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:21.000000Z","updated_at":"2026-08-15T09:01:52.000000Z"}]},{"id":12537457,"change_date":"2026-07-24 21:40:00","inspection_id":"88503724","dot_number":"1055587","report_state":"MI","report_number":"DIUBJ04289","insp_date":"2026-07-23 00:00:00","insp_start_time":"2105","insp_end_time":"2121","registration_date":null,"region":"ED","ci_status_code":"C","location":"142","location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS HP","shipping_paper_number":"7","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3826410","transaction_code":"A","transaction_date":"2026-07-24 00:00:00","upload_date":"2026-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2026-07-24 21:40:00","snet_input_date":"2026-07-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-24 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-27T09:41:23.000000Z","updated_at":"2026-08-04T09:30:19.000000Z","inspection_violations":[{"id":21827317,"change_date":"2026-07-24 21:40:00","inspection_id":"88503724","insp_violation_id":"275707305","seq_no":"1","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":"X4732803","created_at":"2026-07-27T10:01:47.000000Z","updated_at":"2026-08-04T09:42:30.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":21771615,"change_date":"2026-07-24 21:40:00","inspection_id":"88503724","insp_unit_id":"214795861","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RC52999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR1KSKL6925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:19:40.000000Z","updated_at":"2026-08-04T09:01:20.000000Z"},{"id":21771616,"change_date":"2026-07-24 21:40:00","inspection_id":"88503724","insp_unit_id":"214795862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531292","insp_unit_license":"F153793","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322JEA01292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-27T09:19:40.000000Z","updated_at":"2026-08-04T09:01:20.000000Z"}]},{"id":12118398,"change_date":"2026-06-07 21:34:00","inspection_id":"88063737","dot_number":"1055587","report_state":"OH","report_number":"3266001246","insp_date":"2026-06-05 00:00:00","insp_start_time":"1029","insp_end_time":"1104","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PIQUA OH","county_code_state":"OH","county_code":"109","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LINN PRODUCTS, INC.","shipping_paper_number":"50965","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3484623","transaction_code":"A","transaction_date":"2026-06-06 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-10T09:39:56.000000Z","updated_at":"2026-06-18T09:30:09.000000Z","inspection_violations":[{"id":21091009,"change_date":"2026-06-07 21:34:00","inspection_id":"88063737","insp_violation_id":"274744632","seq_no":"1","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213953399","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-10T09:58:26.000000Z","updated_at":"2026-06-18T09:41:15.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":21054387,"change_date":"2026-06-07 21:34:00","inspection_id":"88063737","insp_unit_id":"213953399","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"225","insp_unit_license":"RB92015","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDRXNSNS8684","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:43.000000Z","updated_at":"2026-06-18T09:01:11.000000Z"},{"id":21054388,"change_date":"2026-06-07 21:34:00","inspection_id":"88063737","insp_unit_id":"213953400","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"533526","insp_unit_license":"F111212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322SSB93526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:43.000000Z","updated_at":"2026-06-18T09:01:11.000000Z"}]},{"id":11407943,"change_date":"2026-03-18 21:38:00","inspection_id":"87323295","dot_number":"1055587","report_state":"MI","report_number":"CELMS01670","insp_date":"2026-03-17 00:00:00","insp_start_time":"1915","insp_end_time":"1950","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ LAPEER RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"303556","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1262900","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-18 21:38:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-21T09:47:02.000000Z","updated_at":"2026-03-29T09:32:00.000000Z","inspection_violations":[{"id":19236039,"change_date":"2026-03-18 21:38:00","inspection_id":"87323295","insp_violation_id":"272478133","seq_no":"1","part_no":"393","part_no_section":"11A1-CSLRR","insp_viol_unit":"1","insp_unit_id":"212202770","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:42.000000Z","updated_at":"2026-03-29T09:58:02.000000Z","normalized_code":"39311A1CSLRR"},{"id":19236040,"change_date":"2026-03-18 21:38:00","inspection_id":"87323295","insp_violation_id":"272478134","seq_no":"2","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"212202770","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-21T10:12:42.000000Z","updated_at":"2026-03-29T09:58:02.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":19540460,"change_date":"2026-03-18 21:38:00","inspection_id":"87323295","insp_unit_id":"212202770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"TEMP","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEDR1JSJJ0073","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:21.000000Z","updated_at":"2026-03-29T09:18:42.000000Z"},{"id":19540461,"change_date":"2026-03-18 21:38:00","inspection_id":"87323295","insp_unit_id":"212202771","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"303556","insp_unit_license":"5654963","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1DW1A5320SSB93556","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-21T09:33:21.000000Z","updated_at":"2026-03-29T09:18:42.000000Z"}]},{"id":11212945,"change_date":"2026-02-24 21:39:00","inspection_id":"87124255","dot_number":"1055587","report_state":"IN","report_number":"9625000066","insp_date":"2026-02-18 00:00:00","insp_start_time":"1946","insp_end_time":"2040","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CORUNNA IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WEBASTO ROOF SYSTEMS INC","shipping_paper_number":"4032466902","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","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":"2923599","transaction_code":"A","transaction_date":"2026-02-23 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2026-02-24 21:39:00","snet_input_date":"2026-02-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-24 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:37:41.000000Z","updated_at":"2026-03-07T10:30:15.000000Z","inspection_violations":[{"id":18804833,"change_date":"2026-02-24 21:39:00","inspection_id":"87124255","insp_violation_id":"271979193","seq_no":"1","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-27T10:53:38.000000Z","updated_at":"2026-03-07T10:39:49.000000Z","normalized_code":"39530B1ELDDFR"},{"id":18804834,"change_date":"2026-02-24 21:39:00","inspection_id":"87124255","insp_violation_id":"271979194","seq_no":"2","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-27T10:53:38.000000Z","updated_at":"2026-03-07T10:39:49.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":19148096,"change_date":"2026-02-24 21:39:00","inspection_id":"87124255","insp_unit_id":"211783304","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"152","insp_unit_license":"RC52267","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDV3PSUJ5529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:15.000000Z","updated_at":"2026-03-07T10:02:44.000000Z"},{"id":19148097,"change_date":"2026-02-24 21:39:00","inspection_id":"87124255","insp_unit_id":"211783305","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"533586","insp_unit_license":"F228146","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329SSB93586","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-27T10:13:15.000000Z","updated_at":"2026-03-07T10:02:44.000000Z"}]},{"id":10812860,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","dot_number":"1055587","report_state":"MI","report_number":"MATTB07141","insp_date":"2026-01-16 00:00:00","insp_start_time":"1900","insp_end_time":"1920","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS","shipping_paper_number":"447622","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1256737","transaction_code":"C","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-01-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-20 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-23T10:36:26.000000Z","updated_at":"2026-02-15T10:30:20.000000Z","inspection_violations":[{"id":18296571,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","insp_violation_id":"271594480","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"211440175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-07T10:45:25.000000Z","updated_at":"2026-02-15T10:39:30.000000Z","normalized_code":"3939ALCL"},{"id":18296572,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","insp_violation_id":"271594481","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"211440175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-07T10:45:25.000000Z","updated_at":"2026-02-15T10:39:30.000000Z","normalized_code":"3939ALIL"},{"id":18296573,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","insp_violation_id":"271594482","seq_no":"3","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"211440175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-07T10:45:25.000000Z","updated_at":"2026-02-15T10:39:30.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":18369339,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","insp_unit_id":"211440175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"E714315","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D1DL776299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:58.000000Z","updated_at":"2026-02-15T10:04:49.000000Z"},{"id":18369338,"change_date":"2026-02-04 21:39:00","inspection_id":"86840052","insp_unit_id":"211440174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RC52999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR1KSKL6925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-07T10:10:58.000000Z","updated_at":"2026-02-15T10:04:49.000000Z"}]},{"id":10471464,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","dot_number":"1055587","report_state":"MI","report_number":"PEIFM07829","insp_date":"2025-12-17 00:00:00","insp_start_time":"0320","insp_end_time":"0340","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGNA","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1254147","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-18 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-21T10:31:55.000000Z","updated_at":"2025-12-29T10:31:05.000000Z","inspection_violations":[{"id":17569186,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","insp_violation_id":"270778037","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"210696890","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:32.000000Z","updated_at":"2025-12-29T10:31:49.000000Z","normalized_code":"3939ALCL"},{"id":17569187,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","insp_violation_id":"270778038","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"210696890","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:32.000000Z","updated_at":"2025-12-29T10:31:49.000000Z","normalized_code":"3939ALIL"},{"id":17569188,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","insp_violation_id":"270778039","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210696890","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:32.000000Z","updated_at":"2025-12-29T10:31:49.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":17528613,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","insp_unit_id":"210696889","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"RC16488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD5XFSGH5008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:48.000000Z","updated_at":"2025-12-29T10:01:22.000000Z"},{"id":17528614,"change_date":"2025-12-18 21:41:00","inspection_id":"86604934","insp_unit_id":"210696890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538007","insp_unit_license":"E895022","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C8GT328007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:48.000000Z","updated_at":"2025-12-29T10:01:22.000000Z"}]},{"id":10471692,"change_date":"2025-12-18 21:41:00","inspection_id":"86605174","dot_number":"1055587","report_state":"MI","report_number":"WILLD04056","insp_date":"2025-12-16 00:00:00","insp_start_time":"1025","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 S\/B & SPRINGWELL","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":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-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"84000","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":"1253933","transaction_code":"A","transaction_date":"2025-12-16 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-12-18 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-21T10:31:55.000000Z","updated_at":"2025-12-29T10:31:07.000000Z","inspection_violations":[{"id":17569684,"change_date":"2025-12-18 21:41:00","inspection_id":"86605174","insp_violation_id":"270778614","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-21T10:32:33.000000Z","updated_at":"2025-12-29T10:31:52.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":17528993,"change_date":"2025-12-18 21:41:00","inspection_id":"86605174","insp_unit_id":"210697317","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC55798","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK87LY28994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:48.000000Z","updated_at":"2025-12-29T10:01:23.000000Z"},{"id":17528994,"change_date":"2025-12-18 21:41:00","inspection_id":"86605174","insp_unit_id":"210697318","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"F111212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322SSB93526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-21T10:01:48.000000Z","updated_at":"2025-12-29T10:01:23.000000Z"}]},{"id":10178823,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","dot_number":"1055587","report_state":"MI","report_number":"DIUBJ03808","insp_date":"2025-11-10 00:00:00","insp_start_time":"2010","insp_end_time":"2026","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1250179","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-12 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:48.000000Z","updated_at":"2025-11-16T10:31:00.000000Z","inspection_violations":[{"id":16905103,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","insp_violation_id":"269896317","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209980095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:07.000000Z","updated_at":"2025-11-16T10:31:47.000000Z","normalized_code":"3939ALHLI"},{"id":16905104,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","insp_violation_id":"269896318","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209980095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:07.000000Z","updated_at":"2025-11-16T10:31:47.000000Z","normalized_code":"3939ALIL"},{"id":16905105,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","insp_violation_id":"269896319","seq_no":"3","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"209980095","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:31:07.000000Z","updated_at":"2025-11-16T10:31:47.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":16953051,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","insp_unit_id":"209980095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RC52999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR1KSKL6925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:40.000000Z","updated_at":"2025-11-16T10:01:20.000000Z"},{"id":16953052,"change_date":"2025-11-12 21:41:00","inspection_id":"86298582","insp_unit_id":"209980096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"539971","insp_unit_license":"F224694","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D9SL519971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:40.000000Z","updated_at":"2025-11-16T10:01:21.000000Z"}]},{"id":10138303,"change_date":"2025-11-06 21:40:00","inspection_id":"86255834","dot_number":"1055587","report_state":"MI","report_number":"ANDER07833","insp_date":"2025-11-06 00:00:00","insp_start_time":"0535","insp_end_time":"0605","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"-","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-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1249298","transaction_code":"A","transaction_date":"2025-11-06 00:00:00","upload_date":"2025-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-11-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-11-06 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-09T10:31:43.000000Z","updated_at":"2025-11-10T10:30:59.000000Z","inspection_violations":[{"id":16821832,"change_date":"2025-11-06 21:40:00","inspection_id":"86255834","insp_violation_id":"269783479","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"209884384","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-09T10:32:56.000000Z","updated_at":"2025-11-10T10:31:58.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":16876513,"change_date":"2025-11-06 21:40:00","inspection_id":"86255834","insp_unit_id":"209884383","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"RC52965","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEDV8JSJF7867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:31.000000Z"},{"id":16876514,"change_date":"2025-11-06 21:40:00","inspection_id":"86255834","insp_unit_id":"209884384","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"F199648","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D6EL787610","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-09T10:01:55.000000Z","updated_at":"2025-11-10T10:01:31.000000Z"}]},{"id":10123198,"change_date":"2025-11-05 21:40:00","inspection_id":"86239850","dot_number":"1055587","report_state":"OH","report_number":"3291000124","insp_date":"2025-11-03 00:00:00","insp_start_time":"1022","insp_end_time":"1105","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WAPAKONETA OH","county_code_state":"OH","county_code":"011","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LINN PRODUCTS INC.","shipping_paper_number":"50297","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2501459","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2025-11-05 21:40:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-05 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-08T10:31:47.000000Z","updated_at":"2025-11-09T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16846962,"change_date":"2025-11-05 21:40:00","inspection_id":"86239850","insp_unit_id":"209846731","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"127","insp_unit_license":"RC56254","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD52GLGZ6274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:05.000000Z","updated_at":"2025-11-09T10:00:32.000000Z"},{"id":16846963,"change_date":"2025-11-05 21:40:00","inspection_id":"86239850","insp_unit_id":"209846732","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"538381","insp_unit_license":"F060830","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A532XRSB38381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-08T10:02:05.000000Z","updated_at":"2025-11-09T10:00:32.000000Z"}]},{"id":10067701,"change_date":"2025-10-29 21:40:00","inspection_id":"86181376","dot_number":"1055587","report_state":"MI","report_number":"PEIFM07705","insp_date":"2025-10-28 00:00:00","insp_start_time":"2340","insp_end_time":"2355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB AT 7 MM","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORPLAS","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-10-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248176","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-29 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:02:30.000000Z","updated_at":"2025-11-02T11:01:11.000000Z","inspection_violations":[{"id":16672056,"change_date":"2025-10-29 21:40:00","inspection_id":"86181376","insp_violation_id":"269596061","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-01T10:18:00.000000Z","updated_at":"2025-11-02T11:16:48.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":16734087,"change_date":"2025-10-29 21:40:00","inspection_id":"86181376","insp_unit_id":"209720742","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC52999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR1KSKL6925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:31.000000Z"},{"id":16734088,"change_date":"2025-10-29 21:40:00","inspection_id":"86181376","insp_unit_id":"209720743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"539971","insp_unit_license":"F224694","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D9SL519971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-01T09:47:06.000000Z","updated_at":"2025-11-02T10:46:31.000000Z"}]},{"id":10030553,"change_date":"2025-10-24 21:40:00","inspection_id":"86142290","dot_number":"1055587","report_state":"MI","report_number":"CELMS01509","insp_date":"2025-10-24 00:00:00","insp_start_time":"0955","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S I-75 @ MM-9","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"533525","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-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1247631","transaction_code":"A","transaction_date":"2025-10-24 00:00:00","upload_date":"2025-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-24 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-27T10:01:53.000000Z","updated_at":"2025-10-28T10:01:11.000000Z","inspection_violations":[{"id":16591217,"change_date":"2025-10-24 21:40:00","inspection_id":"86142290","insp_violation_id":"269504126","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4613506","created_at":"2025-10-27T10:17:51.000000Z","updated_at":"2025-10-28T10:16:31.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":16664225,"change_date":"2025-10-24 21:40:00","inspection_id":"86142290","insp_unit_id":"209644604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC52268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBZDR6RLUZ1250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:29.000000Z"},{"id":16664226,"change_date":"2025-10-24 21:40:00","inspection_id":"86142290","insp_unit_id":"209644605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"533525","insp_unit_license":"F111211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320SSB93525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-27T09:47:07.000000Z","updated_at":"2025-10-28T09:46:29.000000Z"}]},{"id":10013758,"change_date":"2025-10-23 21:39:00","inspection_id":"86124600","dot_number":"1055587","report_state":"OH","report_number":"1516000581","insp_date":"2025-10-21 00:00:00","insp_start_time":"0845","insp_end_time":"0906","registration_date":null,"region":"ED","ci_status_code":"C","location":"03","location_desc":"FINDLAY OH","county_code_state":"OH","county_code":"063","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":"U","pen_cen_match":"I","final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2446871","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:47.000000Z","updated_at":"2025-10-27T10:00:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16634954,"change_date":"2025-10-23 21:39:00","inspection_id":"86124600","insp_unit_id":"209611684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"157","insp_unit_license":"RC52268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBZDR6RLUZ1250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:04.000000Z","updated_at":"2025-10-27T09:45:26.000000Z"},{"id":16634955,"change_date":"2025-10-23 21:39:00","inspection_id":"86124600","insp_unit_id":"209611685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOUGHTON","insp_unit_company":"533525","insp_unit_license":"F111211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320SSB93525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:04.000000Z","updated_at":"2025-10-27T09:45:26.000000Z"}]},{"id":9817854,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","dot_number":"1055587","report_state":"MI","report_number":"NESBA02359","insp_date":"2025-09-29 00:00:00","insp_start_time":"1645","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SPECTRUM E-COAT INC","shipping_paper_number":"63206","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1244029","transaction_code":"C","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-30 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-03T10:01:52.000000Z","updated_at":"2025-10-05T10:01:47.000000Z","inspection_violations":[{"id":16194874,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_violation_id":"269058366","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209264745","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:31.000000Z","updated_at":"2025-10-05T10:17:31.000000Z","normalized_code":"39378"},{"id":16194875,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_violation_id":"269058367","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"209264745","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:31.000000Z","updated_at":"2025-10-05T10:17:31.000000Z","normalized_code":"39395A1"},{"id":16194876,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_violation_id":"269058368","seq_no":"3","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"209264745","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:31.000000Z","updated_at":"2025-10-05T10:17:31.000000Z","normalized_code":"39311A1CSURR"},{"id":16194877,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_violation_id":"269058369","seq_no":"4","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"209264746","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-05T10:17:31.000000Z","updated_at":"2025-10-05T10:17:31.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":16308180,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_unit_id":"209264745","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1022","insp_unit_license":"BE23130","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD53GLGY6529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:55.000000Z","updated_at":"2025-10-05T09:46:55.000000Z"},{"id":16308181,"change_date":"2025-10-02 21:42:00","inspection_id":"85918106","insp_unit_id":"209264746","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E605324","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5326PSB10798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-05T09:46:55.000000Z","updated_at":"2025-10-05T09:46:55.000000Z"}]},{"id":9669123,"change_date":"2025-09-12 21:49:00","inspection_id":"85762116","dot_number":"1055587","report_state":"MI","report_number":"SEYFE00197","insp_date":"2025-09-11 00:00:00","insp_start_time":"1955","insp_end_time":"2015","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-75 @ LONG LAKE RD.","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SPRAYTEK INC","shipping_paper_number":"23469","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1240990","transaction_code":"A","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:16.000000Z","updated_at":"2025-09-16T10:48:16.000000Z","inspection_violations":[{"id":15845868,"change_date":"2025-09-12 21:49:00","inspection_id":"85762116","insp_violation_id":"268659483","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-09-14T11:58:00.000000Z","updated_at":"2025-09-16T10:51:13.000000Z","normalized_code":"3922SLLML"}],"inspection_per_units":[{"id":15993600,"change_date":"2025-09-12 21:49:00","inspection_id":"85762116","insp_unit_id":"208919933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"154","insp_unit_license":"RC22487","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALHCYFEXPDUK1080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:58.000000Z","updated_at":"2025-09-16T09:56:03.000000Z"}]},{"id":9633631,"change_date":"2025-09-09 21:41:00","inspection_id":"85724808","dot_number":"1055587","report_state":"MI","report_number":"DEJOS01927","insp_date":"2025-09-05 00:00:00","insp_start_time":"1715","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W I 94 @ N ELM RD","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"R.A.M. EXPRESS LLC","shipping_paper_number":"4042395576","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1239730","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:06.000000Z","inspection_violations":[{"id":15761564,"change_date":"2025-09-09 21:41:00","inspection_id":"85724808","insp_violation_id":"268555241","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:39.000000Z","normalized_code":"39216AD"},{"id":15761565,"change_date":"2025-09-09 21:41:00","inspection_id":"85724808","insp_violation_id":"268555242","seq_no":"2","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:30.000000Z","updated_at":"2025-09-13T10:49:39.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":15915616,"change_date":"2025-09-09 21:41:00","inspection_id":"85724808","insp_unit_id":"208831089","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"152","insp_unit_license":"RC52267","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDV3PSUJ5529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:53.000000Z"},{"id":15915617,"change_date":"2025-09-09 21:41:00","inspection_id":"85724808","insp_unit_id":"208831090","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"538382","insp_unit_license":"F060831","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5321RSB38382","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:53.000000Z"}]},{"id":9594632,"change_date":"2025-09-04 21:41:00","inspection_id":"85684139","dot_number":"1055587","report_state":"MI","report_number":"GRAHA01040","insp_date":"2025-09-03 00:00:00","insp_start_time":"1603","insp_end_time":"1629","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"BUSHA WHY @ GRATIOT RD","county_code_state":"MI","county_code":"147","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"USF US FARATHANE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","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":"1239370","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-03 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-04 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:31.000000Z","updated_at":"2025-09-10T10:45:31.000000Z","inspection_violations":[{"id":15680467,"change_date":"2025-09-04 21:41:00","inspection_id":"85684139","insp_violation_id":"268465045","seq_no":"1","part_no":"392","part_no_section":"2SLIMPT","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-09-09T10:43:05.000000Z","updated_at":"2025-09-10T10:47:46.000000Z","normalized_code":"3922SLIMPT"}],"inspection_per_units":[{"id":15842113,"change_date":"2025-09-04 21:41:00","inspection_id":"85684139","insp_unit_id":"208752417","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"BD38998","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJBBCK84LM58020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:02.000000Z"},{"id":15842114,"change_date":"2025-09-04 21:41:00","inspection_id":"85684139","insp_unit_id":"208752418","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539519","insp_unit_license":"E608579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322FB559519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:50.000000Z","updated_at":"2025-09-10T09:46:02.000000Z"}]},{"id":9414840,"change_date":"2025-08-14 21:40:00","inspection_id":"85495035","dot_number":"1055587","report_state":"MI","report_number":"BOHNE01784","insp_date":"2025-08-13 00:00:00","insp_start_time":"1240","insp_end_time":"1312","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50350","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":"1236203","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-14 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:22.000000Z","updated_at":"2025-08-20T10:44:10.000000Z","inspection_violations":[{"id":15314528,"change_date":"2025-08-14 21:40:00","inspection_id":"85495035","insp_violation_id":"268033066","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208402617","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:24.000000Z","updated_at":"2025-08-18T10:44:13.000000Z","normalized_code":"39311A1CSURR"},{"id":15314529,"change_date":"2025-08-14 21:40:00","inspection_id":"85495035","insp_violation_id":"268033067","seq_no":"2","part_no":"393","part_no_section":"47A-BCFSBD","insp_viol_unit":"1","insp_unit_id":"208402617","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-17T10:45:24.000000Z","updated_at":"2025-08-18T10:44:13.000000Z","normalized_code":"39347ABCFSBD"}],"inspection_per_units":[{"id":15518914,"change_date":"2025-08-14 21:40:00","inspection_id":"85495035","insp_unit_id":"208402617","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135","insp_unit_license":"RB62928","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH8FN921219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:28.000000Z","updated_at":"2025-08-18T09:46:04.000000Z"}]},{"id":9380104,"change_date":"2025-08-11 21:38:00","inspection_id":"85458543","dot_number":"1055587","report_state":"MI","report_number":"ROBER00867","insp_date":"2025-08-08 00:00:00","insp_start_time":"1245","insp_end_time":"1314","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS HP","shipping_paper_number":"152276","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-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"121280","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":"1235440","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:28.000000Z","updated_at":"2025-08-15T10:43:12.000000Z","inspection_violations":[{"id":15242407,"change_date":"2025-08-11 21:38:00","inspection_id":"85458543","insp_violation_id":"267952289","seq_no":"1","part_no":"392","part_no_section":"2-INAT","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-14T10:43:14.000000Z","updated_at":"2025-08-15T10:44:47.000000Z","normalized_code":"3922INAT"}],"inspection_per_units":[{"id":15455213,"change_date":"2025-08-11 21:38:00","inspection_id":"85458543","insp_unit_id":"208334593","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4807","insp_unit_license":"RC49578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5JN888253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:33.000000Z","updated_at":"2025-08-15T09:45:49.000000Z"},{"id":15455214,"change_date":"2025-08-11 21:38:00","inspection_id":"85458543","insp_unit_id":"208334594","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530003","insp_unit_license":"F153791","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5325HEA00003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-14T09:45:33.000000Z","updated_at":"2025-08-15T09:45:49.000000Z"}]},{"id":9364545,"change_date":"2025-08-08 21:39:00","inspection_id":"85442282","dot_number":"1055587","report_state":"MI","report_number":"CELMS01373","insp_date":"2025-08-06 00:00:00","insp_start_time":"1500","insp_end_time":"1515","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S I-75 @ MM-9","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234786","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15428474,"change_date":"2025-08-08 21:39:00","inspection_id":"85442282","insp_unit_id":"208305966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RC52999","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLDR1KSKL6925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"},{"id":15428475,"change_date":"2025-08-08 21:39:00","inspection_id":"85442282","insp_unit_id":"208305967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"536369","insp_unit_license":"E536817","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D7CL596369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:45:57.000000Z"}]},{"id":9266759,"change_date":"2025-07-28 21:40:00","inspection_id":"85339378","dot_number":"1055587","report_state":"MI","report_number":"MALOK00229","insp_date":"2025-07-28 00:00:00","insp_start_time":"0438","insp_end_time":"0450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 @ FORT ST","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SC","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":"2025-07-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1232752","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-28 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:37.000000Z","updated_at":"2025-08-01T10:41:39.000000Z","inspection_violations":[{"id":15017105,"change_date":"2025-07-28 21:40:00","inspection_id":"85339378","insp_violation_id":"267693902","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:34.000000Z","updated_at":"2025-08-01T10:43:35.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":15254096,"change_date":"2025-07-28 21:40:00","inspection_id":"85339378","insp_unit_id":"208115483","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"5","insp_unit_license":"RC28047","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD50GSGY1289","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:34.000000Z","updated_at":"2025-08-01T09:45:34.000000Z"},{"id":15254097,"change_date":"2025-07-28 21:40:00","inspection_id":"85339378","insp_unit_id":"208115484","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531292","insp_unit_license":"F153793","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322JEA01292","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:34.000000Z","updated_at":"2025-08-01T09:45:34.000000Z"}]},{"id":9238111,"change_date":"2025-07-24 21:41:00","inspection_id":"85309216","dot_number":"1055587","report_state":"MI","report_number":"MALOK00214","insp_date":"2025-07-23 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 N\/B @ EUREKA RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORPLAS INDUSTRIES INC","shipping_paper_number":"439846","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-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231679","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-24 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:55.000000Z","updated_at":"2025-07-30T10:00:52.000000Z","inspection_violations":[{"id":14956277,"change_date":"2025-07-24 21:41:00","inspection_id":"85309216","insp_violation_id":"267629097","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"3922SLLTL"},{"id":14956278,"change_date":"2025-07-24 21:41:00","inspection_id":"85309216","insp_violation_id":"267629098","seq_no":"2","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-27T10:44:16.000000Z","updated_at":"2025-07-28T10:48:53.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":15201475,"change_date":"2025-07-24 21:41:00","inspection_id":"85309216","insp_unit_id":"208060589","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4807","insp_unit_license":"RC49578","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH5JN888253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"},{"id":15201476,"change_date":"2025-07-24 21:41:00","inspection_id":"85309216","insp_unit_id":"208060590","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530003","insp_unit_license":"F153791","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5325HEA00003","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-27T09:46:32.000000Z","updated_at":"2025-07-28T09:46:05.000000Z"}]},{"id":9205297,"change_date":"2025-07-21 21:41:00","inspection_id":"85274736","dot_number":"1055587","report_state":"MI","report_number":"CELMS01333","insp_date":"2025-07-18 00:00:00","insp_start_time":"1820","insp_end_time":"1840","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"S I-75 @ MM-9","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"38012","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-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1231383","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:31.000000Z","updated_at":"2025-07-25T10:45:31.000000Z","inspection_violations":[{"id":14878203,"change_date":"2025-07-21 21:41:00","inspection_id":"85274736","insp_violation_id":"267539768","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:56.000000Z","updated_at":"2025-07-25T10:46:56.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":15133350,"change_date":"2025-07-21 21:41:00","inspection_id":"85274736","insp_unit_id":"207986973","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC12782","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD56GLHB6876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:36.000000Z","updated_at":"2025-07-25T09:46:05.000000Z"},{"id":15133351,"change_date":"2025-07-21 21:41:00","inspection_id":"85274736","insp_unit_id":"207986974","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538012","insp_unit_license":"E895023","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1GT328012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:36.000000Z","updated_at":"2025-07-25T09:46:05.000000Z"}]},{"id":9150984,"change_date":"2025-07-21 21:40:00","inspection_id":"85217613","dot_number":"1055587","report_state":"OH","report_number":"0700000636","insp_date":"2025-07-14 00:00:00","insp_start_time":"0721","insp_end_time":"0741","registration_date":null,"region":"ED","ci_status_code":"C","location":"MP 139","location_desc":"AMHERST OH","county_code_state":"OH","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AIM DECOMA WARREN","shipping_paper_number":"ROC448034","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1993081","transaction_code":"C","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2025-07-15 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:01.000000Z","updated_at":"2025-07-25T10:45:13.000000Z","inspection_violations":[{"id":14862346,"change_date":"2025-07-21 21:40:00","inspection_id":"85217613","insp_violation_id":"267521483","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-25T10:46:33.000000Z","updated_at":"2025-07-25T10:46:33.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":15119132,"change_date":"2025-07-21 21:40:00","inspection_id":"85217613","insp_unit_id":"207970770","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"158","insp_unit_license":"RC34833","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3RHUZ1527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:23.000000Z","updated_at":"2025-07-25T09:45:12.000000Z"}]},{"id":9123779,"change_date":"2025-07-11 21:39:00","inspection_id":"85189142","dot_number":"1055587","report_state":"MI","report_number":"LYDEC04252","insp_date":"2025-07-09 00:00:00","insp_start_time":"1735","insp_end_time":"1803","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","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":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122350","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1230051","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:04.000000Z","updated_at":"2025-07-16T10:44:45.000000Z","inspection_violations":[{"id":14709296,"change_date":"2025-07-11 21:39:00","inspection_id":"85189142","insp_violation_id":"267347834","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207822038","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-14T10:48:48.000000Z","updated_at":"2025-07-16T10:46:04.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":14979924,"change_date":"2025-07-11 21:39:00","inspection_id":"85189142","insp_unit_id":"207822038","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"159","insp_unit_license":"RC06222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR5SSVR8346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"},{"id":14979925,"change_date":"2025-07-11 21:39:00","inspection_id":"85189142","insp_unit_id":"207822039","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"538381","insp_unit_license":"F060830","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A532XRSB38381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:07.000000Z","updated_at":"2025-07-15T09:45:49.000000Z"}]},{"id":9077789,"change_date":"2025-07-07 21:40:00","inspection_id":"85140691","dot_number":"1055587","report_state":"MI","report_number":"MALIK03110","insp_date":"2025-07-03 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1228872","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":"01055587","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":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","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":14615450,"change_date":"2025-07-07 21:40:00","inspection_id":"85140691","insp_violation_id":"267237909","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"207730393","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:39.000000Z","updated_at":"2025-07-11T10:45:59.000000Z","normalized_code":"39311A1CSURR"},{"id":14615451,"change_date":"2025-07-07 21:40:00","inspection_id":"85140691","insp_violation_id":"267237910","seq_no":"2","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"207730393","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:39.000000Z","updated_at":"2025-07-11T10:45:59.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":14896721,"change_date":"2025-07-07 21:40:00","inspection_id":"85140691","insp_unit_id":"207730393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"NONE","insp_unit_license":"BE17436","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7CG4FDGC8739","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:54.000000Z"},{"id":14896722,"change_date":"2025-07-07 21:40:00","inspection_id":"85140691","insp_unit_id":"207730394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539997","insp_unit_license":"E017268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329LSA29997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:24.000000Z","updated_at":"2025-07-11T09:45:54.000000Z"}]},{"id":8963373,"change_date":"2025-06-23 21:41:00","inspection_id":"85020214","dot_number":"1055587","report_state":"MI","report_number":"BLAKD04619","insp_date":"2025-06-19 00:00:00","insp_start_time":"0605","insp_end_time":"0700","registration_date":null,"region":"ET","ci_status_code":"C","location":"144","location_desc":"MONROE INSP BUILDING","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS INDUSTRIES INC","shipping_paper_number":"438462","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1226821","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-06-28T10:00:37.000000Z","inspection_violations":[{"id":14396644,"change_date":"2025-06-23 21:41:00","inspection_id":"85020214","insp_violation_id":"266989756","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207510944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:18:00.000000Z","normalized_code":"3939ALHLI"},{"id":14396645,"change_date":"2025-06-23 21:41:00","inspection_id":"85020214","insp_violation_id":"266989757","seq_no":"2","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"207510944","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-26T10:16:00.000000Z","updated_at":"2025-06-27T10:18:00.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":14693704,"change_date":"2025-06-23 21:41:00","inspection_id":"85020214","insp_unit_id":"207510944","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9276","insp_unit_license":"RC21060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK25LN89276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"},{"id":14693705,"change_date":"2025-06-23 21:41:00","inspection_id":"85020214","insp_unit_id":"207510945","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"E714314","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532DXDL776298","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:39.000000Z","updated_at":"2025-06-27T09:46:13.000000Z"}]},{"id":8921450,"change_date":"2025-06-17 21:41:00","inspection_id":"84975584","dot_number":"1055587","report_state":"MI","report_number":"NESBA02157","insp_date":"2025-06-16 00:00:00","insp_start_time":"1810","insp_end_time":"1830","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225864","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-17 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:57.000000Z","updated_at":"2025-06-22T10:00:42.000000Z","inspection_violations":[{"id":14311459,"change_date":"2025-06-17 21:41:00","inspection_id":"84975584","insp_violation_id":"266893538","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"207429733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:41.000000Z","updated_at":"2025-06-21T10:17:47.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":14619466,"change_date":"2025-06-17 21:41:00","inspection_id":"84975584","insp_unit_id":"207429732","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"130","insp_unit_license":"RC06223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EG2HN988991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:06.000000Z","updated_at":"2025-06-22T09:45:57.000000Z"},{"id":14619467,"change_date":"2025-06-17 21:41:00","inspection_id":"84975584","insp_unit_id":"207429733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530798","insp_unit_license":"E605324","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5326PSB10798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:06.000000Z","updated_at":"2025-06-22T09:45:57.000000Z"}]},{"id":8873462,"change_date":"2025-06-11 21:42:00","inspection_id":"84924517","dot_number":"1055587","report_state":"MI","report_number":"CORBJ00080","insp_date":"2025-06-10 00:00:00","insp_start_time":"1535","insp_end_time":"1550","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"VAN DYKE @ 12 MILE RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGNA","shipping_paper_number":"20253","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1224636","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:01:01.000000Z","updated_at":"2025-06-15T10:00:41.000000Z","inspection_violations":[{"id":14217798,"change_date":"2025-06-11 21:42:00","inspection_id":"84924517","insp_violation_id":"266785832","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"207334831","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-14T10:16:36.000000Z","updated_at":"2025-06-17T10:17:45.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":14533273,"change_date":"2025-06-11 21:42:00","inspection_id":"84924517","insp_unit_id":"207334830","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"105","insp_unit_license":"RC06223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EG2HN988991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"},{"id":14533274,"change_date":"2025-06-11 21:42:00","inspection_id":"84924517","insp_unit_id":"207334831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530798","insp_unit_license":"E605324","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5326PSB10798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-14T09:46:10.000000Z","updated_at":"2025-06-15T09:45:56.000000Z"}]},{"id":8584545,"change_date":"2025-05-09 21:40:00","inspection_id":"84619172","dot_number":"1055587","report_state":"IN","report_number":"8341001810","insp_date":"2025-05-05 00:00:00","insp_start_time":"1031","insp_end_time":"1125","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SHIPSHEWANA IN","county_code_state":"IN","county_code":"087","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"RRP PERRYSBURG OH","shipping_paper_number":"295997","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1701866","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2025-05-09 21:40:00","snet_input_date":"2025-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-09 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:02:34.000000Z","updated_at":"2025-05-13T10:01:46.000000Z","inspection_violations":[{"id":13636033,"change_date":"2025-05-09 21:40:00","inspection_id":"84619172","insp_violation_id":"266119371","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:24:52.000000Z","updated_at":"2025-05-13T10:18:42.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":14011742,"change_date":"2025-05-09 21:40:00","inspection_id":"84619172","insp_unit_id":"206767802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"146","insp_unit_license":"RB94692","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7003LDLY0634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:15.000000Z","updated_at":"2025-05-13T09:46:46.000000Z"},{"id":14011743,"change_date":"2025-05-09 21:40:00","inspection_id":"84619172","insp_unit_id":"206767803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"539968","insp_unit_license":"F199612","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D9SL519968","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:15.000000Z","updated_at":"2025-05-13T09:46:46.000000Z"}]},{"id":8084535,"change_date":"2025-03-11 21:41:00","inspection_id":"84092725","dot_number":"1055587","report_state":"MI","report_number":"PEIFM07026","insp_date":"2025-03-11 00:00:00","insp_start_time":"0415","insp_end_time":"0440","registration_date":null,"region":"ET","ci_status_code":"C","location":"141","location_desc":"MONROE SCALE N\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"NORPLAS INDSTRIES","shipping_paper_number":"433704","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1212639","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-11 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:15.000000Z","updated_at":"2025-03-17T21:06:15.000000Z","inspection_violations":[{"id":12634417,"change_date":"2025-03-11 21:41:00","inspection_id":"84092725","insp_violation_id":"264949770","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"205737165","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:50.000000Z","updated_at":"2025-03-17T22:07:50.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":13052802,"change_date":"2025-03-11 21:41:00","inspection_id":"84092725","insp_unit_id":"205737165","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"RC44477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK87LY28994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"},{"id":13052803,"change_date":"2025-03-11 21:41:00","inspection_id":"84092725","insp_unit_id":"205737166","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"538007","insp_unit_license":"E895022","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C8GT328007","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:17.000000Z","updated_at":"2025-03-17T23:59:17.000000Z"}]},{"id":7739717,"change_date":"2025-01-29 21:41:00","inspection_id":"83730322","dot_number":"1055587","report_state":"MI","report_number":"KIRKB04875","insp_date":"2025-01-27 00:00:00","insp_start_time":"0945","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAM EXPRESS LLC","shipping_paper_number":"283012","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1207698","transaction_code":"A","transaction_date":"2025-01-27 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[{"id":12092597,"change_date":"2025-01-29 21:41:00","inspection_id":"83730322","insp_violation_id":"264238273","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"205066091","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:58.000000Z","updated_at":"2025-03-17T22:04:58.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":12489995,"change_date":"2025-01-29 21:41:00","inspection_id":"83730322","insp_unit_id":"205066091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1615","insp_unit_license":"BD53172","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7CG4EDFL8400","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12489996,"change_date":"2025-01-29 21:41:00","inspection_id":"83730322","insp_unit_id":"205066092","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539997","insp_unit_license":"E017268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329LSA29997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7584043,"change_date":"2025-01-14 21:55:00","inspection_id":"83567015","dot_number":"1055587","report_state":"MI","report_number":"KIRKB04851","insp_date":"2025-01-07 00:00:00","insp_start_time":"1120","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DANA","shipping_paper_number":"R-6356","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1206111","transaction_code":"C","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-09 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:40.000000Z","updated_at":"2025-03-17T20:55:40.000000Z","inspection_violations":[{"id":11854906,"change_date":"2025-01-14 21:55:00","inspection_id":"83567015","insp_violation_id":"263995749","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"204828544","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"3939ALTSI"},{"id":11854907,"change_date":"2025-01-14 21:55:00","inspection_id":"83567015","insp_violation_id":"263995750","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204828545","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:44.000000Z","updated_at":"2025-03-17T22:03:44.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":12236897,"change_date":"2025-01-14 21:55:00","inspection_id":"83567015","insp_unit_id":"204828544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"536664","insp_unit_license":"E894955","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322RBB56664","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"},{"id":12236898,"change_date":"2025-01-14 21:55:00","inspection_id":"83567015","insp_unit_id":"204828545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"007","insp_unit_license":"RC38245","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD52GSFP7614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:04.000000Z","updated_at":"2025-03-17T23:50:04.000000Z"}]},{"id":7414008,"change_date":"2024-12-13 21:40:00","inspection_id":"83388416","dot_number":"1055587","report_state":"MI","report_number":"NESBA01787","insp_date":"2024-12-12 00:00:00","insp_start_time":"1210","insp_end_time":"1350","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"S I-75@14MILE RD","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAMSUNG SDI BATTERY SYSTEM","shipping_paper_number":"12122024","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1204336","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-13 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:47.000000Z","updated_at":"2025-03-17T20:50:47.000000Z","inspection_violations":[{"id":11584376,"change_date":"2024-12-13 21:40:00","inspection_id":"83388416","insp_violation_id":"263450139","seq_no":"1","part_no":"393","part_no_section":"43D-BSB","insp_viol_unit":"2","insp_unit_id":"204373936","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:26.000000Z","updated_at":"2025-03-17T22:02:26.000000Z","normalized_code":"39343DBSB"}],"inspection_per_units":[{"id":11960527,"change_date":"2024-12-13 21:40:00","inspection_id":"83388416","insp_unit_id":"204373935","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"159","insp_unit_license":"RC06222","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDR5SSVR8346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"},{"id":11960528,"change_date":"2024-12-13 21:40:00","inspection_id":"83388416","insp_unit_id":"204373936","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531810","insp_unit_license":"E392319","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5328EB491810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:03.000000Z","updated_at":"2025-03-17T23:47:03.000000Z"}]},{"id":7372450,"change_date":"2024-12-09 21:41:00","inspection_id":"83344885","dot_number":"1055587","report_state":"MI","report_number":"MATTB06292","insp_date":"2024-12-07 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ 10 MM","county_code_state":"MI","county_code":"115","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":"N","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":"122000","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":"1203681","transaction_code":"A","transaction_date":"2024-12-07 00:00:00","upload_date":"2024-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-12-09 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","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":11519963,"change_date":"2024-12-09 21:41:00","inspection_id":"83344885","insp_violation_id":"263331830","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:02.000000Z","updated_at":"2025-03-17T22:02:02.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":11893190,"change_date":"2024-12-09 21:41:00","inspection_id":"83344885","insp_unit_id":"204271519","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9","insp_unit_license":"RC12782","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD56GLHB6876","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":11893191,"change_date":"2024-12-09 21:41:00","inspection_id":"83344885","insp_unit_id":"204271520","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E536818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5325FS521802","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":7072536,"change_date":"2024-10-29 21:42:00","inspection_id":"83027786","dot_number":"1055587","report_state":"MI","report_number":"FELDW00347","insp_date":"2024-10-28 00:00:00","insp_start_time":"1330","insp_end_time":"1400","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TRW FOWLERVILLE","shipping_paper_number":"286672","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-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1199690","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:27.000000Z","updated_at":"2025-03-17T20:43:27.000000Z","inspection_violations":[{"id":11039527,"change_date":"2024-10-29 21:42:00","inspection_id":"83027786","insp_violation_id":"262615401","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"203639301","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:59:31.000000Z","updated_at":"2025-03-17T21:59:31.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11406319,"change_date":"2024-10-29 21:42:00","inspection_id":"83027786","insp_unit_id":"203639301","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"157","insp_unit_license":"RC15162","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KJJBZDR6RLUZ1250","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"},{"id":11406320,"change_date":"2024-10-29 21:42:00","inspection_id":"83027786","insp_unit_id":"203639302","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"533525","insp_unit_license":"F111211","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320SSB93525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":6516264,"change_date":"2024-09-17 21:45:00","inspection_id":"82435985","dot_number":"1055587","report_state":"MI","report_number":"KIRKB04659","insp_date":"2024-08-16 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-96 & FOWLERVILLE","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1190648","transaction_code":"C","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10120722,"change_date":"2024-09-17 21:45:00","inspection_id":"82435985","insp_violation_id":"261866024","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:55:00.000000Z","updated_at":"2025-03-17T21:55:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10504566,"change_date":"2024-09-17 21:45:00","inspection_id":"82435985","insp_unit_id":"202980710","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"9276","insp_unit_license":"RC21060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK25LN89276","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:48.000000Z","updated_at":"2025-03-17T23:31:48.000000Z"},{"id":10504567,"change_date":"2024-09-17 21:45:00","inspection_id":"82435985","insp_unit_id":"202980711","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"538033","insp_unit_license":"E251640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327MSA48033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:48.000000Z","updated_at":"2025-03-17T23:31:48.000000Z"}]},{"id":6479478,"change_date":"2024-08-15 21:42:00","inspection_id":"82396743","dot_number":"1055587","report_state":"OH","report_number":"3273000560","insp_date":"2024-08-15 00:00:00","insp_start_time":"0658","insp_end_time":"0747","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"WEIGHT STATION FINDLAY","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"WEBASTO ROOF SYSTEMS, INC","shipping_paper_number":"08142024","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":"I","final_status_date":"2024-08-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1748341","transaction_code":"A","transaction_date":"2024-08-15 00:00:00","upload_date":"2024-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-15 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-15 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"PO BOX 210429","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48321","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:11.000000Z","updated_at":"2025-03-17T20:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10444018,"change_date":"2024-08-15 21:42:00","inspection_id":"82396743","insp_unit_id":"202416720","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"127","insp_unit_license":"RC15159","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD52GLGZ6274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:12.000000Z","updated_at":"2025-03-17T23:31:12.000000Z"},{"id":10444019,"change_date":"2024-08-15 21:42:00","inspection_id":"82396743","insp_unit_id":"202416721","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531815","insp_unit_license":"E392320","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327EB491815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:12.000000Z","updated_at":"2025-03-17T23:31:12.000000Z"}]},{"id":6396452,"change_date":"2024-08-08 21:41:00","inspection_id":"82307932","dot_number":"1055587","report_state":"IN","report_number":"8557005353","insp_date":"2024-08-02 00:00:00","insp_start_time":"0822","insp_end_time":"0903","registration_date":null,"region":"ED","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"TREMEC DC","shipping_paper_number":"2822055","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"718954","transaction_code":"C","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2024-08-06 21:42:00","snet_input_date":"2024-08-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-06 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:32.000000Z","updated_at":"2025-03-17T20:29:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10308384,"change_date":"2024-08-08 21:41:00","inspection_id":"82307932","insp_unit_id":"202293653","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"156","insp_unit_license":"RC29263","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC5RHUZ1528","insp_unit_decal":"Y","insp_unit_decal_number":"34401586","created_at":"2025-03-17T23:29:49.000000Z","updated_at":"2025-03-17T23:29:49.000000Z"}]},{"id":6357790,"change_date":"2024-09-17 21:45:00","inspection_id":"82266671","dot_number":"1055587","report_state":"MI","report_number":"NESBA01508","insp_date":"2024-07-30 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M -59@W AUBURN RD","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1188367","transaction_code":"C","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-31 21:43:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:44.000000Z","updated_at":"2025-03-17T20:28:44.000000Z","inspection_violations":[{"id":9870864,"change_date":"2024-09-17 21:45:00","inspection_id":"82266671","insp_violation_id":"261869287","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202983295","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:45.000000Z","updated_at":"2025-03-17T21:53:45.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":10245656,"change_date":"2024-09-17 21:45:00","inspection_id":"82266671","insp_unit_id":"202983295","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"130","insp_unit_license":"RC06223","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EG2HN988991","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:09.000000Z","updated_at":"2025-03-17T23:29:09.000000Z"}]},{"id":6084222,"change_date":"2024-06-26 21:43:00","inspection_id":"81973248","dot_number":"1055587","report_state":"MI","report_number":"ANDER06480","insp_date":"2024-06-26 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB 4 MM","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1183726","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:21.000000Z","updated_at":"2025-03-17T20:23:21.000000Z","inspection_violations":[{"id":9441978,"change_date":"2024-06-26 21:43:00","inspection_id":"81973248","insp_violation_id":"260329256","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":"X4382363","created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"},{"id":9441979,"change_date":"2024-06-26 21:43:00","inspection_id":"81973248","insp_violation_id":"260329257","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:43.000000Z","updated_at":"2025-03-17T21:51:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9799629,"change_date":"2024-06-26 21:43:00","inspection_id":"81973248","insp_unit_id":"201607150","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"158","insp_unit_license":"RC34833","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3RHUZ1527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:28.000000Z","updated_at":"2025-03-17T23:24:28.000000Z"}]},{"id":5587341,"change_date":"2024-04-24 21:41:00","inspection_id":"81434138","dot_number":"1055587","report_state":"OH","report_number":"1796005123","insp_date":"2024-04-23 00:00:00","insp_start_time":"1108","insp_end_time":"1128","registration_date":null,"region":"ET","ci_status_code":"C","location":"10123","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"OWENS CORNING","shipping_paper_number":"8508525501","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":"2024-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1721195","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-24 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"PO BOX 210429","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48321","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:29.000000Z","updated_at":"2025-03-17T20:13:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8999917,"change_date":"2024-04-24 21:41:00","inspection_id":"81434138","insp_unit_id":"200553027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"127","insp_unit_license":"RC15159","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLD52GLGZ6274","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"},{"id":8999918,"change_date":"2024-04-24 21:41:00","inspection_id":"81434138","insp_unit_id":"200553028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"538032","insp_unit_license":"E251639","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5325MSA48032","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:43.000000Z","updated_at":"2025-03-17T23:16:43.000000Z"}]},{"id":5435180,"change_date":"2024-04-04 21:42:00","inspection_id":"81268162","dot_number":"1055587","report_state":"MI","report_number":"NESBA01242","insp_date":"2024-04-02 00:00:00","insp_start_time":"0945","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-04 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1171522","transaction_code":"A","transaction_date":"2024-04-02 00:00:00","upload_date":"2024-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-04 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:10:19.000000Z","updated_at":"2025-03-17T20:10:19.000000Z","inspection_violations":[{"id":8390190,"change_date":"2024-04-04 21:42:00","inspection_id":"81268162","insp_violation_id":"258747971","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200237958","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3922"},{"id":8390191,"change_date":"2024-04-04 21:42:00","inspection_id":"81268162","insp_violation_id":"258747972","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200237958","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:37.000000Z","updated_at":"2025-03-17T21:46:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8754935,"change_date":"2024-04-04 21:42:00","inspection_id":"81268162","insp_unit_id":"200237958","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"RC19595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD52GSFP7614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"},{"id":8754936,"change_date":"2024-04-04 21:42:00","inspection_id":"81268162","insp_unit_id":"200237959","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"530796","insp_unit_license":"E670454","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322PSB10796","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:24.000000Z","updated_at":"2025-03-17T23:14:24.000000Z"}]},{"id":5137153,"change_date":"2024-02-26 21:42:00","inspection_id":"80943256","dot_number":"1055587","report_state":"MI","report_number":"OMILJ04596","insp_date":"2024-02-23 00:00:00","insp_start_time":"0655","insp_end_time":"0710","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 SB @ MM 24","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AKRON","shipping_paper_number":"77222","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1166263","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[{"id":7920489,"change_date":"2024-02-26 21:42:00","inspection_id":"80943256","insp_violation_id":"258038640","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:44:17.000000Z","updated_at":"2025-03-17T21:44:17.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8271056,"change_date":"2024-02-26 21:42:00","inspection_id":"80943256","insp_unit_id":"199602967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC34833","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXFC3RHUZ1527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":5024379,"change_date":"2024-02-10 21:32:00","inspection_id":"80820085","dot_number":"1055587","report_state":"IN","report_number":"6189005040","insp_date":"2024-02-07 00:00:00","insp_start_time":"1121","insp_end_time":"1158","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"LA PORTE IN","county_code_state":"IN","county_code":null,"insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"MAGNA EXTERIORS","shipping_paper_number":"4028800","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":"2024-02-10 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"158000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"233538","transaction_code":"A","transaction_date":"2024-02-10 00:00:00","upload_date":"2024-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":"2024-02-10 21:32:00","snet_input_date":"2024-02-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-02-10 21:32:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:21.000000Z","updated_at":"2025-03-17T20:02:21.000000Z","inspection_violations":[{"id":7741660,"change_date":"2024-02-10 21:32:00","inspection_id":"80820085","insp_violation_id":"257774952","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:43:27.000000Z","updated_at":"2025-03-17T21:43:27.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8087062,"change_date":"2024-02-10 21:32:00","inspection_id":"80820085","insp_unit_id":"199366821","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"141","insp_unit_license":"RC15160","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7002KDKV9222","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:17.000000Z","updated_at":"2025-03-17T23:08:17.000000Z"},{"id":8087063,"change_date":"2024-02-10 21:32:00","inspection_id":"80820085","insp_unit_id":"199366822","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"536369","insp_unit_license":"E536817","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D7CL596369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:17.000000Z","updated_at":"2025-03-17T23:08:17.000000Z"}]},{"id":4745868,"change_date":"2024-01-02 21:43:00","inspection_id":"80515352","dot_number":"1055587","report_state":"MI","report_number":"CELMS00841","insp_date":"2024-01-02 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159006","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7634231,"change_date":"2024-01-02 21:43:00","inspection_id":"80515352","insp_unit_id":"198768200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC06252","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND65FDGJ8339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"},{"id":7634232,"change_date":"2024-01-02 21:43:00","inspection_id":"80515352","insp_unit_id":"198768201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"E894954","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320RBB56663","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4745924,"change_date":"2024-01-02 21:43:00","inspection_id":"80515413","dot_number":"1055587","report_state":"MI","report_number":"KERSD00196","insp_date":"2024-01-02 00:00:00","insp_start_time":"1305","insp_end_time":"1335","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"PONTIAC SCALES","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RAM EXPRESS","shipping_paper_number":"44237","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"123220","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159016","transaction_code":"A","transaction_date":"2024-01-02 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7324258,"change_date":"2024-01-02 21:43:00","inspection_id":"80515413","insp_violation_id":"257142034","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198768316","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7634320,"change_date":"2024-01-02 21:43:00","inspection_id":"80515413","insp_unit_id":"198768316","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"RC09113","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGND6XFDGF2059","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"},{"id":7634321,"change_date":"2024-01-02 21:43:00","inspection_id":"80515413","insp_unit_id":"198768317","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539998","insp_unit_license":"E017269","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5320LSA29998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4082031,"change_date":"2023-09-28 21:41:00","inspection_id":"79784135","dot_number":"1055587","report_state":"MI","report_number":"NESBA00887","insp_date":"2023-09-27 00:00:00","insp_start_time":"1205","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1147883","transaction_code":"A","transaction_date":"2023-09-27 00:00:00","upload_date":"2023-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-28 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:43:35.000000Z","updated_at":"2025-03-17T19:43:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6562960,"change_date":"2023-09-28 21:41:00","inspection_id":"79784135","insp_unit_id":"197297718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"17","insp_unit_license":"BD52977","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK87LX43525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"},{"id":6562961,"change_date":"2023-09-28 21:41:00","inspection_id":"79784135","insp_unit_id":"197297719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539996","insp_unit_license":"E017267","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327LSA29996","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:04.000000Z","updated_at":"2025-03-17T22:55:04.000000Z"}]},{"id":3934134,"change_date":"2023-09-08 21:41:00","inspection_id":"79619694","dot_number":"1055587","report_state":"MI","report_number":"OMILJ04325","insp_date":"2023-09-07 00:00:00","insp_start_time":"1405","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ MM 15","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-08 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":"1145073","transaction_code":"A","transaction_date":"2023-09-07 00:00:00","upload_date":"2023-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-08 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:29.000000Z","updated_at":"2025-03-17T19:40:29.000000Z","inspection_violations":[{"id":6080869,"change_date":"2023-09-08 21:41:00","inspection_id":"79619694","insp_violation_id":"255164625","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:35:25.000000Z","updated_at":"2025-03-17T21:35:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6325904,"change_date":"2023-09-08 21:41:00","inspection_id":"79619694","insp_unit_id":"196968490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"142","insp_unit_license":"RC06221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWFCXLHLR3080","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:09.000000Z","updated_at":"2025-03-17T22:53:09.000000Z"}]},{"id":3735766,"change_date":"2023-08-30 21:44:00","inspection_id":"79398331","dot_number":"1055587","report_state":"MI","report_number":"CELMS00596","insp_date":"2023-08-13 00:00:00","insp_start_time":"1550","insp_end_time":"1620","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"N I-75 @ SQUARE LAKE RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","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":"1140032","transaction_code":"C","transaction_date":"2023-08-13 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-14 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:32.000000Z","updated_at":"2025-03-17T19:36:32.000000Z","inspection_violations":[{"id":5760964,"change_date":"2023-08-30 21:44:00","inspection_id":"79398331","insp_violation_id":"254982307","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:33:43.000000Z","updated_at":"2025-03-17T21:33:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6006704,"change_date":"2023-08-30 21:44:00","inspection_id":"79398331","insp_unit_id":"196812208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC16488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD5XFSGH5008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:29.000000Z","updated_at":"2025-03-17T22:50:29.000000Z"},{"id":6006705,"change_date":"2023-08-30 21:44:00","inspection_id":"79398331","insp_unit_id":"196812209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539516","insp_unit_license":"E608574","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327FB559516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:29.000000Z","updated_at":"2025-03-17T22:50:29.000000Z"}]},{"id":3609342,"change_date":"2023-07-27 21:40:00","inspection_id":"79256829","dot_number":"1055587","report_state":"MI","report_number":"TPDKH00079","insp_date":"2023-07-27 00:00:00","insp_start_time":"1100","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FOURTEEN MILE\/I75","county_code_state":"MI","county_code":"125","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"123300","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1136829","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:13.000000Z","updated_at":"2025-03-17T19:34:13.000000Z","inspection_violations":[{"id":5566129,"change_date":"2023-07-27 21:40:00","inspection_id":"79256829","insp_violation_id":"254318073","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196228220","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:49.000000Z","updated_at":"2025-03-17T21:32:49.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5803165,"change_date":"2023-07-27 21:40:00","inspection_id":"79256829","insp_unit_id":"196228220","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RC16488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD5XFSGH5008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"},{"id":5803166,"change_date":"2023-07-27 21:40:00","inspection_id":"79256829","insp_unit_id":"196228221","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531815","insp_unit_license":"E392320","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327EB491815","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:48.000000Z","updated_at":"2025-03-17T22:48:48.000000Z"}]},{"id":3522295,"change_date":"2023-07-17 21:41:00","inspection_id":"79159074","dot_number":"1055587","report_state":"MI","report_number":"ROBER00715","insp_date":"2023-07-14 00:00:00","insp_start_time":"1330","insp_end_time":"1354","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LINN","shipping_paper_number":"256766","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135492","transaction_code":"A","transaction_date":"2023-07-14 00:00:00","upload_date":"2023-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-14 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-17 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:46.000000Z","updated_at":"2025-03-17T19:32:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5663470,"change_date":"2023-07-17 21:41:00","inspection_id":"79159074","insp_unit_id":"196031857","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"7","insp_unit_license":"RC19595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD52GSFP7614","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"},{"id":5663471,"change_date":"2023-07-17 21:41:00","inspection_id":"79159074","insp_unit_id":"196031858","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"538033","insp_unit_license":"E251640","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327MSA48033","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:41.000000Z","updated_at":"2025-03-17T22:47:41.000000Z"}]},{"id":2467777,"change_date":"2023-02-28 21:41:00","inspection_id":"77966131","dot_number":"1055587","report_state":"MI","report_number":"COPEK01934","insp_date":"2023-02-27 00:00:00","insp_start_time":"0800","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-94 @ OLD SCALES","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INALFA","shipping_paper_number":"23650","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1115261","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-28 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:08.000000Z","updated_at":"2025-03-17T19:12:08.000000Z","inspection_violations":[{"id":3798436,"change_date":"2023-02-28 21:41:00","inspection_id":"77966131","insp_violation_id":"251381613","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193621012","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3939A"},{"id":3798437,"change_date":"2023-02-28 21:41:00","inspection_id":"77966131","insp_violation_id":"251381614","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193621012","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:50.000000Z","updated_at":"2025-03-17T21:24:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3971735,"change_date":"2023-02-28 21:41:00","inspection_id":"77966131","insp_unit_id":"193621012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"001","insp_unit_license":"BC03212","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJGLDR6DLFH0221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:27.000000Z","updated_at":"2025-03-17T22:34:27.000000Z"},{"id":3971736,"change_date":"2023-02-28 21:41:00","inspection_id":"77966131","insp_unit_id":"193621013","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"536714","insp_unit_license":"D934553","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322KBA26714","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:27.000000Z","updated_at":"2025-03-17T22:34:27.000000Z"}]},{"id":2435909,"change_date":"2023-02-23 21:40:00","inspection_id":"77930095","dot_number":"1055587","report_state":"MI","report_number":"BURGM05127","insp_date":"2023-02-22 00:00:00","insp_start_time":"0900","insp_end_time":"0917","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CECDAR ST","county_code_state":"MI","county_code":"065","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1114913","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-23 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:28.000000Z","updated_at":"2025-03-17T19:11:28.000000Z","inspection_violations":[{"id":3750221,"change_date":"2023-02-23 21:40:00","inspection_id":"77930095","insp_violation_id":"251302084","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193548751","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:40.000000Z","updated_at":"2025-03-17T21:24:40.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3920267,"change_date":"2023-02-23 21:40:00","inspection_id":"77930095","insp_unit_id":"193548751","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"777","insp_unit_license":"BC97779","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJBBCK84LM58020","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"},{"id":3920268,"change_date":"2023-02-23 21:40:00","inspection_id":"77930095","insp_unit_id":"193548752","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539997","insp_unit_license":"E017268","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5329LSA29997","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:05.000000Z","updated_at":"2025-03-17T22:34:05.000000Z"}]},{"id":2358044,"change_date":"2023-02-13 21:43:00","inspection_id":"77841011","dot_number":"1055587","report_state":"MI","report_number":"DAWDD02459","insp_date":"2023-02-10 00:00:00","insp_start_time":"1517","insp_end_time":"1539","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-13 21:43: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":"1113478","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-13 21:43:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:01.000000Z","updated_at":"2025-03-17T19:10:01.000000Z","inspection_violations":[{"id":3631544,"change_date":"2023-02-13 21:43:00","inspection_id":"77841011","insp_violation_id":"251101268","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:24:07.000000Z","updated_at":"2025-03-17T21:24:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3794878,"change_date":"2023-02-13 21:43:00","inspection_id":"77841011","insp_unit_id":"193368724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145","insp_unit_license":"RB87302","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALFCYD28LDLX6974","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:10.000000Z","updated_at":"2025-03-17T22:33:10.000000Z"}]},{"id":2316655,"change_date":"2023-02-07 21:41:00","inspection_id":"77793612","dot_number":"1055587","report_state":"MI","report_number":"OMILJ03879","insp_date":"2023-02-06 00:00:00","insp_start_time":"0855","insp_end_time":"0901","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 75 SB @ MM 7","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAMSUNG","shipping_paper_number":"62023","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1112398","transaction_code":"A","transaction_date":"2023-02-06 00:00:00","upload_date":"2023-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-07 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:17.000000Z","updated_at":"2025-03-17T19:09:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3728696,"change_date":"2023-02-07 21:41:00","inspection_id":"77793612","insp_unit_id":"193274494","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"143","insp_unit_license":"RB94692","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7003LDLY0634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"},{"id":3728697,"change_date":"2023-02-07 21:41:00","inspection_id":"77793612","insp_unit_id":"193274495","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531810","insp_unit_license":"E392319","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5328EB491810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:42.000000Z","updated_at":"2025-03-17T22:32:42.000000Z"}]},{"id":1939652,"change_date":"2022-12-13 21:40:00","inspection_id":"77363209","dot_number":"1055587","report_state":"MI","report_number":"PEASS02525","insp_date":"2022-12-13 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 NB @ SAFE ENFORCEMENT SIT","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WEBASTO","shipping_paper_number":"121322-1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1105575","transaction_code":"A","transaction_date":"2022-12-13 00:00:00","upload_date":"2022-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-12-13 21:40:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:16.000000Z","updated_at":"2025-03-17T19:02:16.000000Z","inspection_violations":[{"id":3013966,"change_date":"2022-12-13 21:40:00","inspection_id":"77363209","insp_violation_id":"250082782","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:21:19.000000Z","updated_at":"2025-03-17T21:21:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3121076,"change_date":"2022-12-13 21:40:00","inspection_id":"77363209","insp_unit_id":"192410604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"146","insp_unit_license":"RB94692","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7003LDLY0634","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"},{"id":3121077,"change_date":"2022-12-13 21:40:00","inspection_id":"77363209","insp_unit_id":"192410605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"536725","insp_unit_license":"D934554","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327KBA26725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:23.000000Z","updated_at":"2025-03-17T22:28:23.000000Z"}]},{"id":1715769,"change_date":"2022-11-10 21:39:00","inspection_id":"77106568","dot_number":"1055587","report_state":"IL","report_number":"0825160137","insp_date":"2022-11-09 00:00:00","insp_start_time":"1006","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-90","county_code_state":"IL","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGNA EXTERIOR BELIVIDERE","shipping_paper_number":"230630","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2210592","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-09 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-11-10 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:14.000000Z","updated_at":"2025-03-17T18:58:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2760162,"change_date":"2022-11-10 21:39:00","inspection_id":"77106568","insp_unit_id":"191902838","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"152","insp_unit_license":"RC17916","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHHDV3PSUJ5529","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:54.000000Z","updated_at":"2025-03-17T22:25:54.000000Z"}]},{"id":1604069,"change_date":"2022-10-26 21:39:00","inspection_id":"76978451","dot_number":"1055587","report_state":"MI","report_number":"MALIK01375","insp_date":"2022-10-25 00:00:00","insp_start_time":"0940","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B M-59 @ CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"57558","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1099785","transaction_code":"A","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:16.000000Z","updated_at":"2025-03-17T18:56:16.000000Z","inspection_violations":[{"id":2521425,"change_date":"2022-10-26 21:39:00","inspection_id":"76978451","insp_violation_id":"249262060","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191650012","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:53.000000Z","updated_at":"2025-03-17T21:18:53.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2581114,"change_date":"2022-10-26 21:39:00","inspection_id":"76978451","insp_unit_id":"191650012","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"333","insp_unit_license":"BB69595","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD58FSGH5010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"},{"id":2581115,"change_date":"2022-10-26 21:39:00","inspection_id":"76978451","insp_unit_id":"191650013","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539999","insp_unit_license":"E017270","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322LSA29999","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:42.000000Z","updated_at":"2025-03-17T22:24:42.000000Z"}]},{"id":1112824,"change_date":"2022-09-01 21:41:00","inspection_id":"76409301","dot_number":"1055587","report_state":"IN","report_number":"8632005991","insp_date":"2022-08-22 00:00:00","insp_start_time":"1005","insp_end_time":"1035","registration_date":"2022-08-31 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"I 80\/90 EB 24 MM, PORTAGE","county_code_state":"IN","county_code":"127","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"STELLANTIS","shipping_paper_number":"3884951","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-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"2144615","transaction_code":"C","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-23 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:15.000000Z","updated_at":"2025-03-17T18:47:15.000000Z","inspection_violations":[{"id":1753516,"change_date":"2022-09-01 21:41:00","inspection_id":"76409301","insp_violation_id":"248168854","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:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3922"},{"id":1753517,"change_date":"2022-09-01 21:41:00","inspection_id":"76409301","insp_violation_id":"248168855","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":1789505,"change_date":"2022-09-01 21:41:00","inspection_id":"76409301","insp_unit_id":"190685037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"8","insp_unit_license":"RC16488","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGLD5XFSGH5008","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:18.000000Z","updated_at":"2025-03-17T22:19:18.000000Z"},{"id":1789506,"change_date":"2022-09-01 21:41:00","inspection_id":"76409301","insp_unit_id":"190685038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"536369","insp_unit_license":"E536817","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1JJV532D7CL596369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:18.000000Z","updated_at":"2025-03-17T22:19:18.000000Z"}]},{"id":934304,"change_date":"2022-08-01 21:39:00","inspection_id":"76200983","dot_number":"1055587","report_state":"MI","report_number":"MALIK01215","insp_date":"2022-07-28 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","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":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1086261","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1474070,"change_date":"2022-08-01 21:39:00","inspection_id":"76200983","insp_violation_id":"247431549","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190063981","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"39021TB"},{"id":1474071,"change_date":"2022-08-01 21:39:00","inspection_id":"76200983","insp_violation_id":"247431550","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190063981","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1503940,"change_date":"2022-08-01 21:39:00","inspection_id":"76200983","insp_unit_id":"190063981","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"13","insp_unit_license":"BC89307","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9TH8AN282657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"},{"id":1503941,"change_date":"2022-08-01 21:39:00","inspection_id":"76200983","insp_unit_id":"190063982","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539516","insp_unit_license":"E608574","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5327FB559516","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":551002,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","dot_number":"1055587","report_state":"MI","report_number":"ANDER04657","insp_date":"2022-06-06 00:00:00","insp_start_time":"0345","insp_end_time":"0420","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"-","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1078376","transaction_code":"C","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-06 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[{"id":866979,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","insp_violation_id":"246328514","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":866980,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","insp_violation_id":"246328515","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189141603","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3939A"},{"id":866981,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","insp_violation_id":"246328516","seq_no":"3","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:06.000000Z","updated_at":"2025-03-17T21:11:06.000000Z","normalized_code":"3958F1"}],"inspection_per_units":[{"id":886489,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","insp_unit_id":"189141603","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"150","insp_unit_license":"RC10625","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALXA7CG0FDGM6756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"},{"id":886490,"change_date":"2022-06-09 21:42:00","inspection_id":"75749850","insp_unit_id":"189141604","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"-","insp_unit_license":"E536818","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5325FS521802","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]},{"id":515567,"change_date":"2022-06-09 21:42:00","inspection_id":"75707869","dot_number":"1055587","report_state":"MI","report_number":"SCHMC04176","insp_date":"2022-05-27 00:00:00","insp_start_time":"0740","insp_end_time":"0754","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"AIM DECOMA","shipping_paper_number":"ROC3036","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 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":"1077399","transaction_code":"C","transaction_date":"2022-05-27 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:43.000000Z","updated_at":"2025-03-17T18:36:43.000000Z","inspection_violations":[{"id":817427,"change_date":"2022-06-09 21:42:00","inspection_id":"75707869","insp_violation_id":"246341942","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:52.000000Z","updated_at":"2025-03-17T21:10:52.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":829750,"change_date":"2022-06-09 21:42:00","inspection_id":"75707869","insp_unit_id":"189152740","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"137","insp_unit_license":"RC00106","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALACWFC8KDKE3047","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:19.000000Z","updated_at":"2025-03-17T22:13:19.000000Z"}]},{"id":489080,"change_date":"2022-05-26 21:42:00","inspection_id":"75676384","dot_number":"1055587","report_state":"IN","report_number":"8290012094","insp_date":"2022-05-25 00:00:00","insp_start_time":"0816","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"2269S","location_desc":"#22  I-69 SB  HUNTINGTON","county_code_state":"IN","county_code":"069","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"TREMEC","shipping_paper_number":"260","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":"I","final_status_date":"2022-05-26 21:42: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":"2130938","transaction_code":"A","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-26 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:20.000000Z","updated_at":"2025-03-17T18:36:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":786463,"change_date":"2022-05-26 21:42:00","inspection_id":"75676384","insp_unit_id":"188928387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"142","insp_unit_license":"RC06221","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACWFCXLHLR3080","insp_unit_decal":"Y","insp_unit_decal_number":"31395752","created_at":"2025-03-17T22:13:02.000000Z","updated_at":"2025-03-17T22:13:02.000000Z"}]},{"id":243278,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","dot_number":"1055587","report_state":"MI","report_number":"SCHMC04083","insp_date":"2022-04-20 00:00:00","insp_start_time":"1045","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":"142","location_desc":"MONROE SCALE S\/B","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DANA DRIVESHAFTS","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","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":"42900","viol_total":"4","oos_total":"2","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1073177","transaction_code":"C","transaction_date":"2022-04-20 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-25 21:41:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","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":373738,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","insp_violation_id":"246341181","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4041796","created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"3922"},{"id":373739,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","insp_violation_id":"246341182","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","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":"38323A2"},{"id":373740,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","insp_violation_id":"246341183","seq_no":"3","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":"X4041796","created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"3922"},{"id":373741,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","insp_violation_id":"246341184","seq_no":"4","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"189152211","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:08:49.000000Z","updated_at":"2025-03-17T21:08:49.000000Z","normalized_code":"39375G"}],"inspection_per_units":[{"id":394547,"change_date":"2022-06-09 21:42:00","inspection_id":"75383151","insp_unit_id":"189152211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"145","insp_unit_license":"RB87302","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3ALFCYD28LDLX6974","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":36082,"change_date":"2022-03-24 21:31:00","inspection_id":"75131563","dot_number":"1055587","report_state":"MI","report_number":"WATTR03000","insp_date":"2022-03-23 00:00:00","insp_start_time":"1435","insp_end_time":"1509","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BALDWIN RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LINN PRODUCTS INC","shipping_paper_number":"46126","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-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1068991","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:08.000000Z","updated_at":"2025-03-17T18:28:08.000000Z","inspection_violations":[{"id":51385,"change_date":"2022-03-24 21:31:00","inspection_id":"75131563","insp_violation_id":"244761956","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:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":58181,"change_date":"2022-03-24 21:31:00","inspection_id":"75131563","insp_unit_id":"187805332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"135","insp_unit_license":"RB62928","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EH8FN921219","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"},{"id":58182,"change_date":"2022-03-24 21:31:00","inspection_id":"75131563","insp_unit_id":"187805333","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"531810","insp_unit_license":"E392319","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5328EB491810","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"}]},{"id":10190,"change_date":"2022-03-21 21:31:00","inspection_id":"75092898","dot_number":"1055587","report_state":"MI","report_number":"LITTJ03895","insp_date":"2022-03-18 00:00:00","insp_start_time":"1625","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":"210R3","location_desc":"BELLEVILLE REST AREA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","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":"2022-03-21 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1068378","transaction_code":"A","transaction_date":"2022-03-18 00:00:00","upload_date":"2022-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01055587","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-21 21:31:00","insp_carrier_name":"RAM EXPRESS LLC","insp_carrier_street":"271 COLLIER RD","insp_carrier_city":"AUBURN HILLS","insp_carrier_state":"MI","insp_carrier_zip_code":"48326","insp_colonia":null,"docket_number":"439853","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:27:45.000000Z","updated_at":"2025-03-17T18:27:45.000000Z","inspection_violations":[{"id":13495,"change_date":"2022-03-21 21:31:00","inspection_id":"75092898","insp_violation_id":"244670240","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187724043","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:10.000000Z","updated_at":"2025-03-17T21:07:10.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":16269,"change_date":"2022-03-21 21:31:00","inspection_id":"75092898","insp_unit_id":"187724043","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"117","insp_unit_license":"RB92767","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUJA6CK77LV31229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:22.000000Z","updated_at":"2025-03-17T22:08:22.000000Z"},{"id":16270,"change_date":"2022-03-21 21:31:00","inspection_id":"75092898","insp_unit_id":"187724044","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"539519","insp_unit_license":"E608579","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1DW1A5322FB559519","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:22.000000Z","updated_at":"2025-03-17T22:08:22.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1055587\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1055587\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1055587\/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\/1055587\/inspections","per_page":100,"prev_page_url":null,"to":68,"total":68}