{"current_page":1,"data":[{"id":12551488,"change_date":"2026-07-26 21:34:00","inspection_id":"88518482","dot_number":"819731","report_state":"ND","report_number":"FT26000519","insp_date":"2026-07-24 00:00:00","insp_start_time":"1121","insp_end_time":"1143","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MILNOR ND","county_code_state":"ND","county_code":"081","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARK SAND AND GRAVEL CO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-07-26 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"116642","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":"3838091","transaction_code":"A","transaction_date":"2026-07-25 00:00:00","upload_date":"2026-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2026-07-26 21:34:00","snet_input_date":"2026-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-07-26 21:34:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-29T09:39:54.000000Z","updated_at":"2026-08-01T09:37:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21794891,"change_date":"2026-07-26 21:34:00","inspection_id":"88518482","insp_unit_id":"214822067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"429","insp_unit_license":"YTD8646","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AX07Y2CM012207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-29T09:16:24.000000Z","updated_at":"2026-08-01T09:12:13.000000Z"},{"id":21794892,"change_date":"2026-07-26 21:34:00","inspection_id":"88518482","insp_unit_id":"214822068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONTAINE T","insp_unit_company":null,"insp_unit_license":"6769STW","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13NE54309D3559198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-29T09:16:24.000000Z","updated_at":"2026-08-01T09:12:13.000000Z"}]},{"id":11765403,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","dot_number":"819731","report_state":"MN","report_number":"0574000862","insp_date":"2026-04-21 00:00:00","insp_start_time":"0819","insp_end_time":"0846","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BAUDETTE MN","county_code_state":"MN","county_code":"071","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"80780","viol_total":"4","oos_total":"1","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3222319","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2026-04-28 21:38:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-28 21:38:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:20.000000Z","updated_at":"2026-05-09T09:30:24.000000Z","inspection_violations":[{"id":20457287,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","insp_violation_id":"273893315","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"882605740136","created_at":"2026-05-01T10:01:12.000000Z","updated_at":"2026-05-09T09:40:38.000000Z","normalized_code":"38323A2LCDLN"},{"id":20457288,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","insp_violation_id":"273893316","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:01:12.000000Z","updated_at":"2026-05-09T09:40:38.000000Z","normalized_code":"3922SLL"},{"id":20457289,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","insp_violation_id":"273893317","seq_no":"3","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:01:12.000000Z","updated_at":"2026-05-09T09:40:38.000000Z","normalized_code":"3922SLL"},{"id":20457290,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","insp_violation_id":"273893318","seq_no":"4","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:01:12.000000Z","updated_at":"2026-05-09T09:40:38.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20469113,"change_date":"2026-04-28 21:38:00","inspection_id":"87695892","insp_unit_id":"213258241","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"419","insp_unit_license":"YTD8646","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AX07Y2CM012207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:10.000000Z","updated_at":"2026-05-09T09:02:28.000000Z"}]},{"id":10114232,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","dot_number":"819731","report_state":"MN","report_number":"0568000752","insp_date":"2025-10-28 00:00:00","insp_start_time":"0931","insp_end_time":"1034","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FERGUS FALLS MN","county_code_state":"MN","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-04 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"119000","viol_total":"10","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":"2497241","transaction_code":"C","transaction_date":"2025-11-03 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2025-11-04 21:39:00","snet_input_date":"2025-10-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-04 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:13.000000Z","updated_at":"2026-03-08T09:30:56.000000Z","inspection_violations":[{"id":18827380,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012522","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"39360C"},{"id":18827381,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012523","seq_no":"2","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"3939AHLLH"},{"id":18827382,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012524","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"3939ALCL"},{"id":18827383,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012525","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"3939ALFTSI"},{"id":18827384,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012526","seq_no":"5","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"39380A"},{"id":18827385,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012527","seq_no":"6","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"3939ALIL"},{"id":18827386,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012528","seq_no":"7","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"393203CCBP"},{"id":18827387,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012529","seq_no":"8","part_no":"393","part_no_section":"203B-CBP","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"393203BCBP"},{"id":18827388,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012530","seq_no":"9","part_no":"393","part_no_section":"203E-CBP","insp_viol_unit":"1","insp_unit_id":"211816816","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"393203ECBP"},{"id":18827389,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_violation_id":"272012531","seq_no":"10","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":"PENDING","created_at":"2026-02-28T10:56:03.000000Z","updated_at":"2026-03-08T09:47:10.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":19174136,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_unit_id":"211816816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YTD8637","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AN07Y2CM010169","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:04.000000Z","updated_at":"2026-03-08T09:04:59.000000Z"},{"id":19174137,"change_date":"2026-02-25 21:47:00","inspection_id":"86230385","insp_unit_id":"211816817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RED RIVER","insp_unit_company":null,"insp_unit_license":"1877STY","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4ZYLB4229W1000304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-28T10:15:04.000000Z","updated_at":"2026-03-08T09:04:59.000000Z"}]},{"id":9699924,"change_date":"2025-09-17 21:39:00","inspection_id":"85794443","dot_number":"819731","report_state":"MN","report_number":"0585000860","insp_date":"2025-09-10 00:00:00","insp_start_time":"1108","insp_end_time":"1123","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"VERGAS MN","county_code_state":"MN","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"2284713","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2025-09-17 21:39:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:29.000000Z","updated_at":"2025-09-23T10:01:29.000000Z","inspection_violations":[{"id":15916338,"change_date":"2025-09-17 21:39:00","inspection_id":"85794443","insp_violation_id":"268741263","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLNP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:10.000000Z","normalized_code":"38323A2LCDLNP"},{"id":15916339,"change_date":"2025-09-17 21:39:00","inspection_id":"85794443","insp_violation_id":"268741264","seq_no":"2","part_no":"392","part_no_section":"16-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:10.000000Z","normalized_code":"39216D"}],"inspection_per_units":[{"id":16056894,"change_date":"2025-09-17 21:39:00","inspection_id":"85794443","insp_unit_id":"208988665","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"YCC6862","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NPNHD7X32M585616","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:42.000000Z","updated_at":"2025-09-21T09:45:04.000000Z"}]},{"id":9243205,"change_date":"2025-07-25 21:39:00","inspection_id":"85314518","dot_number":"819731","report_state":"MN","report_number":"0582000571","insp_date":"2025-07-18 00:00:00","insp_start_time":"1258","insp_end_time":"1320","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BARNESVILLE MN","county_code_state":"MN","county_code":"027","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","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":"2039318","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2025-07-25 21:39:00","snet_input_date":"2025-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-25 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:13.000000Z","updated_at":"2025-07-30T10:01:13.000000Z","inspection_violations":[{"id":14968362,"change_date":"2025-07-25 21:39:00","inspection_id":"85314518","insp_violation_id":"267643559","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"208070732","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:30.000000Z","updated_at":"2025-07-29T10:42:44.000000Z","normalized_code":"3939ALCL"},{"id":14968363,"change_date":"2025-07-25 21:39:00","inspection_id":"85314518","insp_violation_id":"267643560","seq_no":"2","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"208070732","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:30.000000Z","updated_at":"2025-07-29T10:42:44.000000Z","normalized_code":"39381H"}],"inspection_per_units":[{"id":15211013,"change_date":"2025-07-25 21:39:00","inspection_id":"85314518","insp_unit_id":"208070732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"84","insp_unit_license":"YCB7575","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HTLDZZPXKH677375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:29.000000Z","updated_at":"2025-07-29T09:45:16.000000Z"}]},{"id":8976302,"change_date":"2025-06-25 21:39:00","inspection_id":"85033908","dot_number":"819731","report_state":"ND","report_number":"HP47000353","insp_date":"2025-06-23 00:00:00","insp_start_time":"1441","insp_end_time":"1503","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FARGO ND","county_code_state":"ND","county_code":"017","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"137998","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":"1909980","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:59.000000Z","updated_at":"2025-06-30T10:00:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14717666,"change_date":"2025-06-25 21:39:00","inspection_id":"85033908","insp_unit_id":"207537246","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"419","insp_unit_license":"YTD8646","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AX07Y2CM012207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:08.000000Z","updated_at":"2025-06-29T09:45:14.000000Z"}]},{"id":7699384,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","dot_number":"819731","report_state":"MN","report_number":"1674000574","insp_date":"2025-01-17 00:00:00","insp_start_time":"0844","insp_end_time":"0959","registration_date":null,"region":"CS","ci_status_code":"C","location":"RDRVR","location_desc":"MOORHEAD MN","county_code_state":"MN","county_code":"027","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"180779","viol_total":"14","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1283216","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2025-01-24 21:39:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-24 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:57.000000Z","updated_at":"2025-03-17T20:57:57.000000Z","inspection_violations":[{"id":12029882,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156041","seq_no":"1","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"204987565","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3963A1BOS"},{"id":12029883,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156042","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLEWA3"},{"id":12029884,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156043","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLEWA3"},{"id":12029885,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156044","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"204987566","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3939ALCL"},{"id":12029886,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156045","seq_no":"5","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":"882516740007","created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLL"},{"id":12029887,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156046","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWA3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLEWA3"},{"id":12029888,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156047","seq_no":"7","part_no":"393","part_no_section":"11A1-LSML","insp_viol_unit":"2","insp_unit_id":"204987566","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39311A1LSML"},{"id":12029889,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156048","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204987565","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39347E"},{"id":12029890,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156049","seq_no":"9","part_no":"393","part_no_section":"48A-BIBD","insp_viol_unit":"1","insp_unit_id":"204987565","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39348ABIBD"},{"id":12029891,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156050","seq_no":"10","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"204987565","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39353BB"},{"id":12029892,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156051","seq_no":"11","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204987566","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39617CPI"},{"id":12029893,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156052","seq_no":"12","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"204987566","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39347E"},{"id":12029894,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156053","seq_no":"13","part_no":"393","part_no_section":"53B-B","insp_viol_unit":"2","insp_unit_id":"204987566","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"39353BB"},{"id":12029895,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_violation_id":"264156054","seq_no":"14","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:38.000000Z","updated_at":"2025-03-17T22:04:38.000000Z","normalized_code":"3922SLLEWG3"}],"inspection_per_units":[{"id":12424297,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_unit_id":"204987565","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"419","insp_unit_license":"YTD8646","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AX07Y2CM012207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"},{"id":12424298,"change_date":"2025-01-24 21:39:00","inspection_id":"83688037","insp_unit_id":"204987566","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHER","insp_unit_company":null,"insp_unit_license":"NO PLATE","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"NONE","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:05.000000Z","updated_at":"2025-03-17T23:52:05.000000Z"}]},{"id":6569774,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","dot_number":"819731","report_state":"MN","report_number":"1786000251","insp_date":"2024-08-20 00:00:00","insp_start_time":"0922","insp_end_time":"1004","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BARRETT MN","county_code_state":"MN","county_code":"051","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"787225","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-08-27 21:41:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-27 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:11.000000Z","updated_at":"2025-03-17T20:33:11.000000Z","inspection_violations":[{"id":10210490,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423872","seq_no":"1","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"172504A"},{"id":10210491,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423873","seq_no":"2","part_no":"107","part_no_section":"620(b)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"107620B"},{"id":10210492,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423874","seq_no":"3","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"39348A"},{"id":10210493,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423875","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"3963A1"},{"id":10210494,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423876","seq_no":"5","part_no":"172","part_no_section":"202(b)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"31","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"172202B"},{"id":10210495,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423877","seq_no":"6","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"177823A"},{"id":10210496,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_violation_id":"261423878","seq_no":"7","part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"202597982","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:26.000000Z","updated_at":"2025-03-17T21:55:26.000000Z","normalized_code":"172516C6"}],"inspection_per_units":[{"id":10591736,"change_date":"2024-08-27 21:41:00","inspection_id":"82492879","insp_unit_id":"202597982","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"87","insp_unit_license":"YCB7587","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1HTSCPLM4NH431623","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:44.000000Z","updated_at":"2025-03-17T23:32:44.000000Z"}]},{"id":6438290,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","dot_number":"819731","report_state":"MN","report_number":"0568000196","insp_date":"2024-08-06 00:00:00","insp_start_time":"0944","insp_end_time":"1057","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FERGUS FALLS MN","county_code_state":"MN","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"75280","viol_total":"10","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":"735826","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-08-12 21:42:00","snet_input_date":"2024-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-12 21:42:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:21.000000Z","updated_at":"2025-03-17T20:30:21.000000Z","inspection_violations":[{"id":9998623,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126029","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202332218","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3939A"},{"id":9998624,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126030","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"882405680166","created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"},{"id":9998625,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126031","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202332218","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39353B"},{"id":9998626,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126032","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202332218","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3963A1"},{"id":9998627,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126033","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"202332218","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3965B"},{"id":9998628,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126034","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"},{"id":9998629,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126035","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"},{"id":9998630,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126036","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202332218","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"39347E"},{"id":9998631,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126037","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"},{"id":9998632,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_violation_id":"261126038","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:20.000000Z","updated_at":"2025-03-17T21:54:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10376685,"change_date":"2024-08-12 21:42:00","inspection_id":"82352790","insp_unit_id":"202332218","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YCA9300","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M2AX03C88M001094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:33.000000Z","updated_at":"2025-03-17T23:30:33.000000Z"}]},{"id":6419276,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","dot_number":"819731","report_state":"MN","report_number":"0568000145","insp_date":"2024-07-02 00:00:00","insp_start_time":"1418","insp_end_time":"1413","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"PELICAN RAPIDS MN","county_code_state":"MN","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-08 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"643637","transaction_code":"C","transaction_date":"2024-07-11 00:00:00","upload_date":"2025-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-08-08 21:41:00","snet_input_date":"2024-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-08 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:56.000000Z","updated_at":"2025-11-26T10:30:29.000000Z","inspection_violations":[{"id":17102891,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174931","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":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"3922SLL"},{"id":17102892,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174932","seq_no":"2","part_no":"393","part_no_section":"207A-STBW","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"393207ASTBW"},{"id":17102893,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174933","seq_no":"3","part_no":"393","part_no_section":"203C-CBP","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"393203CCBP"},{"id":17102894,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174934","seq_no":"4","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"39360C"},{"id":17102895,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174935","seq_no":"5","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"39375A1TEPBM"},{"id":17102896,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174936","seq_no":"6","part_no":"393","part_no_section":"80A","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"39380A"},{"id":17102897,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_violation_id":"270174937","seq_no":"7","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"210196356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-25T10:32:22.000000Z","updated_at":"2025-11-26T10:32:39.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":17119093,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_unit_id":"210196356","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YTD8639","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AN07Y9CM010170","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:21.000000Z","updated_at":"2025-11-26T10:00:35.000000Z"},{"id":17119094,"change_date":"2025-11-22 21:48:00","inspection_id":"82332508","insp_unit_id":"210196357","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAIL KING","insp_unit_company":null,"insp_unit_license":"STA5810","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1TKD04023CW025933","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-25T10:01:21.000000Z","updated_at":"2025-11-26T10:00:35.000000Z"}]},{"id":5823533,"change_date":"2024-05-23 21:40:00","inspection_id":"81690907","dot_number":"819731","report_state":"MN","report_number":"0585000098","insp_date":"2024-05-17 00:00:00","insp_start_time":"0754","insp_end_time":"0824","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FERGUS FALLS MN","county_code_state":"MN","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","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":"507793","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-05-23 21:40:00","snet_input_date":"2024-05-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-23 21:40:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:14.000000Z","updated_at":"2025-03-17T20:18:14.000000Z","inspection_violations":[{"id":9022557,"change_date":"2024-05-23 21:40:00","inspection_id":"81690907","insp_violation_id":"259684193","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":"882405850089","created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3922"},{"id":9022558,"change_date":"2024-05-23 21:40:00","inspection_id":"81690907","insp_violation_id":"259684194","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:39.000000Z","updated_at":"2025-03-17T21:49:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9379014,"change_date":"2024-05-23 21:40:00","inspection_id":"81690907","insp_unit_id":"201046241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YCA9301","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M2AX04C58M001083","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:22.000000Z","updated_at":"2025-03-17T23:20:22.000000Z"}]},{"id":5785993,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","dot_number":"819731","report_state":"MN","report_number":"0568000053","insp_date":"2024-05-14 00:00:00","insp_start_time":"0809","insp_end_time":"1002","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FERGUS FALLS MN","county_code_state":"MN","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"75280","viol_total":"16","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"493943","transaction_code":"A","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-05-20 21:41:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-20 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:29.000000Z","updated_at":"2025-03-17T20:17:29.000000Z","inspection_violations":[{"id":8959931,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592416","seq_no":"11","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3922"},{"id":8959932,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592417","seq_no":"1","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39311A1"},{"id":8959933,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592418","seq_no":"2","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3965B"},{"id":8959934,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592419","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39353B"},{"id":8959935,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592420","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39347E"},{"id":8959936,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592421","seq_no":"5","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39375G"},{"id":8959937,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592422","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3965B"},{"id":8959938,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592423","seq_no":"7","part_no":"393","part_no_section":"11(a)(1)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39311A1"},{"id":8959939,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592424","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39378"},{"id":8959940,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592425","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3922"},{"id":8959941,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592426","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3922"},{"id":8959942,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592427","seq_no":"12","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":"882405680092","created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3922"},{"id":8959943,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592428","seq_no":"13","part_no":"393","part_no_section":"75(g)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"882405680092","created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39375G"},{"id":8959944,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592429","seq_no":"14","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"3922"},{"id":8959945,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592430","seq_no":"15","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39345B2"},{"id":8959946,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_violation_id":"259592431","seq_no":"16","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200968517","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":9319211,"change_date":"2024-05-20 21:41:00","inspection_id":"81649930","insp_unit_id":"200968517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YCA9300","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M2AX03C88M001094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:45.000000Z","updated_at":"2025-03-17T23:19:45.000000Z"}]},{"id":5762341,"change_date":"2024-05-16 21:40:00","inspection_id":"81624435","dot_number":"819731","report_state":"MN","report_number":"0585000086","insp_date":"2024-05-10 00:00:00","insp_start_time":"0745","insp_end_time":"0807","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FERGUS FALLS MN","county_code_state":"MN","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-16 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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"486594","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2024-05-16 21:40:00","snet_input_date":"2024-05-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-16 21:40:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"525 KENNEDY PARK RD","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56537","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:03.000000Z","updated_at":"2025-03-17T20:17:03.000000Z","inspection_violations":[{"id":8919262,"change_date":"2024-05-16 21:40:00","inspection_id":"81624435","insp_violation_id":"259534968","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:49:08.000000Z","updated_at":"2025-03-17T21:49:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9281190,"change_date":"2024-05-16 21:40:00","inspection_id":"81624435","insp_unit_id":"200920125","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YTD8648","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AW07YXFM049139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:24.000000Z","updated_at":"2025-03-17T23:19:24.000000Z"},{"id":9281191,"change_date":"2024-05-16 21:40:00","inspection_id":"81624435","insp_unit_id":"200920126","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOAD KING","insp_unit_company":null,"insp_unit_license":"ST38913","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"5LKB38365W4022352","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:24.000000Z","updated_at":"2025-03-17T23:19:24.000000Z"}]},{"id":3654092,"change_date":"2023-08-02 21:41:00","inspection_id":"79306899","dot_number":"819731","report_state":"MN","report_number":"0ACV000555","insp_date":"2023-08-02 00:00:00","insp_start_time":"0927","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":"FRGFL","location_desc":"FERGUS FALLS","county_code_state":"MN","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1401589","transaction_code":"A","transaction_date":"2023-08-02 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5875518,"change_date":"2023-08-02 21:41:00","inspection_id":"79306899","insp_unit_id":"196326364","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"436","insp_unit_license":"YTD8649","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AW07Y6FM049137","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":3083780,"change_date":"2023-05-18 21:43:00","inspection_id":"78665173","dot_number":"819731","report_state":"MN","report_number":"00ZV006281","insp_date":"2023-05-17 00:00:00","insp_start_time":"1741","insp_end_time":"1749","registration_date":null,"region":"CT","ci_status_code":"C","location":"ERSKN","location_desc":"ERSKINE WEIGH SCALE","county_code_state":"MN","county_code":"119","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"194320","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":"1388438","transaction_code":"A","transaction_date":"2023-05-17 00:00:00","upload_date":"2023-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2023-05-18 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-18 21:43:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:09.000000Z","updated_at":"2025-03-17T19:24:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4960419,"change_date":"2023-05-18 21:43:00","inspection_id":"78665173","insp_unit_id":"195016023","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"418","insp_unit_license":"YTC5401","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DB0X17D698736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"},{"id":4960420,"change_date":"2023-05-18 21:43:00","inspection_id":"78665173","insp_unit_id":"195016024","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"L118","insp_unit_license":"6769STW","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13NE54309D3559198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:08.000000Z","updated_at":"2025-03-17T22:42:08.000000Z"}]},{"id":3034186,"change_date":"2023-05-12 21:42:00","inspection_id":"78609493","dot_number":"819731","report_state":"MN","report_number":"00YN004174","insp_date":"2023-05-10 00:00:00","insp_start_time":"0743","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"DTLKS","location_desc":"DETROIT LAKES","county_code_state":"MN","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-12 21:42: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":"1386992","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2023-05-12 21:42:00","snet_input_date":"2023-05-12 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-05-12 21:42:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:02.000000Z","updated_at":"2025-03-17T19:23:02.000000Z","inspection_violations":[{"id":4659302,"change_date":"2023-05-12 21:42:00","inspection_id":"78609493","insp_violation_id":"252802137","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:28:40.000000Z","updated_at":"2025-03-17T21:28:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4881313,"change_date":"2023-05-12 21:42:00","inspection_id":"78609493","insp_unit_id":"194906382","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"436","insp_unit_license":"YTD8649","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AW07Y6FM049137","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:29.000000Z","updated_at":"2025-03-17T22:41:29.000000Z"},{"id":4881314,"change_date":"2023-05-12 21:42:00","inspection_id":"78609493","insp_unit_id":"194906383","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"L124","insp_unit_license":"STA5812","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1TKD04029BW013168","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:29.000000Z","updated_at":"2025-03-17T22:41:29.000000Z"}]},{"id":2492443,"change_date":"2023-03-02 21:41:00","inspection_id":"77994274","dot_number":"819731","report_state":"MN","report_number":"00YV002813","insp_date":"2023-03-02 00:00:00","insp_start_time":"0949","insp_end_time":"1002","registration_date":null,"region":"CT","ci_status_code":"C","location":"DTLKS","location_desc":"DETROIT LAKES","county_code_state":"MN","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2023-03-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194320","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":"1374442","transaction_code":"A","transaction_date":"2023-03-02 00:00:00","upload_date":"2023-03-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2023-03-02 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"3MNS001","mcmis_add_date":"2023-03-02 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:32.000000Z","updated_at":"2025-03-17T19:12:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4010762,"change_date":"2023-03-02 21:41:00","inspection_id":"77994274","insp_unit_id":"193676082","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"418","insp_unit_license":"YTC5401","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1XP5DB0X17D698736","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:45.000000Z","updated_at":"2025-03-17T22:34:45.000000Z"},{"id":4010763,"change_date":"2023-03-02 21:41:00","inspection_id":"77994274","insp_unit_id":"193676083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"L118","insp_unit_license":"6769STW","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"13NE54309D3559198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:45.000000Z","updated_at":"2025-03-17T22:34:45.000000Z"}]},{"id":1517805,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","dot_number":"819731","report_state":"MN","report_number":"0ACV000476","insp_date":"2022-10-14 00:00:00","insp_start_time":"0854","insp_end_time":"0941","registration_date":null,"region":"CT","ci_status_code":"C","location":"FRGFL","location_desc":"FERGUS FALLS","county_code_state":"MN","county_code":"111","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"47000","viol_total":"5","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1356113","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-14 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:32.000000Z","updated_at":"2025-03-17T18:54:32.000000Z","inspection_violations":[{"id":2390211,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_violation_id":"249038423","seq_no":"1","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"191448149","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"39382"},{"id":2390212,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_violation_id":"249038424","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191448149","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"3939A"},{"id":2390213,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_violation_id":"249038425","seq_no":"3","part_no":"393","part_no_section":"24(c)","insp_viol_unit":"1","insp_unit_id":"191448149","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"39324C"},{"id":2390214,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_violation_id":"249038426","seq_no":"4","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"191448150","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"39343"},{"id":2390215,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_violation_id":"249038427","seq_no":"5","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191448150","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"882205680557","created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"3929A"}],"inspection_per_units":[{"id":2442685,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_unit_id":"191448149","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"94","insp_unit_license":"YU30143","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1FV3HFAC5PL445378","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"},{"id":2442686,"change_date":"2022-10-14 21:39:00","inspection_id":"76879228","insp_unit_id":"191448150","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"CHT7181","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4UGFH2530XD007099","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"}]},{"id":1517858,"change_date":"2022-10-14 21:39:00","inspection_id":"76879293","dot_number":"819731","report_state":"MN","report_number":"00YN003863","insp_date":"2022-10-13 00:00:00","insp_start_time":"0958","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"DTLKS","location_desc":"DETROIT LAKES","county_code_state":"MN","county_code":"005","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-14 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":"1355792","transaction_code":"A","transaction_date":"2022-10-13 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-13 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:32.000000Z","updated_at":"2025-03-17T18:54:32.000000Z","inspection_violations":[{"id":2390322,"change_date":"2022-10-14 21:39:00","inspection_id":"76879293","insp_violation_id":"249038597","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191448266","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:01.000000Z","updated_at":"2025-03-17T21:18:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2442765,"change_date":"2022-10-14 21:39:00","inspection_id":"76879293","insp_unit_id":"191448265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"YTD8651","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AW07Y4FM049136","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"},{"id":2442766,"change_date":"2022-10-14 21:39:00","inspection_id":"76879293","insp_unit_id":"191448266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"0010STV","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"4ZYLB4222W1000306","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:44.000000Z","updated_at":"2025-03-17T22:23:44.000000Z"}]},{"id":1315161,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","dot_number":"819731","report_state":"MN","report_number":"00YV002680","insp_date":"2022-09-19 00:00:00","insp_start_time":"0840","insp_end_time":"0913","registration_date":null,"region":"CT","ci_status_code":"C","location":"DTLKS","location_desc":"DETROIT LAKES","county_code_state":"MN","county_code":"005","insp_level_id":"1","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-09-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"6","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1351230","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2022-09-19 21:39:00","snet_input_date":"2022-09-19 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-09-19 21:39:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:52.000000Z","updated_at":"2025-03-17T18:50:52.000000Z","inspection_violations":[{"id":2080902,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248499995","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"190972834","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"39395F"},{"id":2080903,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248499996","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190972834","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"39021TB"},{"id":2080904,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248499997","seq_no":"5","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"190972835","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"39375C"},{"id":2080905,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248499998","seq_no":"1","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"3928"},{"id":2080906,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248499999","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190972834","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"39395A"},{"id":2080907,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_violation_id":"248500000","seq_no":"6","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"190972835","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:16:33.000000Z","updated_at":"2025-03-17T21:16:33.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":2117365,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_unit_id":"190972834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"55","insp_unit_license":"FCP760","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1GC1KUEG6JF209527","insp_unit_decal":"Y","insp_unit_decal_number":"31703783","created_at":"2025-03-17T22:21:31.000000Z","updated_at":"2025-03-17T22:21:31.000000Z"},{"id":2117366,"change_date":"2022-09-19 21:39:00","inspection_id":"76644393","insp_unit_id":"190972835","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KIEF","insp_unit_company":"L68","insp_unit_license":"5765CTE","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1DVDU18221A007947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:31.000000Z","updated_at":"2025-03-17T22:21:31.000000Z"}]},{"id":489726,"change_date":"2022-05-26 21:42:00","inspection_id":"75677126","dot_number":"819731","report_state":"MN","report_number":"0ACV000403","insp_date":"2022-05-26 00:00:00","insp_start_time":"1019","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":"FRGFL","location_desc":"FERGUS FALLS","county_code_state":"MN","county_code":"111","insp_level_id":"3","service_center":"MW","census_source_id":"4","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":"I","final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"75280","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":"1330857","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":"00819731","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","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":787532,"change_date":"2022-05-26 21:42:00","inspection_id":"75677126","insp_unit_id":"188930077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"364","insp_unit_license":"YCA9300","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M2AX03C88M001094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:03.000000Z","updated_at":"2025-03-17T22:13:03.000000Z"}]},{"id":385896,"change_date":"2022-05-13 21:40:00","inspection_id":"75553065","dot_number":"819731","report_state":"MN","report_number":"00YN003581","insp_date":"2022-05-13 00:00:00","insp_start_time":"0956","insp_end_time":"1032","registration_date":null,"region":"CT","ci_status_code":"C","location":"DTLKS","location_desc":"DETROIT LAKES","county_code_state":"MN","county_code":"005","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1328890","transaction_code":"A","transaction_date":"2022-05-13 00:00:00","upload_date":"2022-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2022-05-13 21:40:00","snet_input_date":"2022-05-13 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-13 21:40:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:24.000000Z","updated_at":"2025-03-17T18:34:24.000000Z","inspection_violations":[{"id":603743,"change_date":"2022-05-13 21:40:00","inspection_id":"75553065","insp_violation_id":"245777936","seq_no":"1","part_no":"383","part_no_section":"93(b)(3)","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:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"38393B3"},{"id":603744,"change_date":"2022-05-13 21:40:00","inspection_id":"75553065","insp_violation_id":"245777937","seq_no":"2","part_no":"390","part_no_section":"21T(e)","insp_viol_unit":"1","insp_unit_id":"188674243","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:53.000000Z","updated_at":"2025-03-17T21:09:53.000000Z","normalized_code":"39021TE"}],"inspection_per_units":[{"id":623787,"change_date":"2022-05-13 21:40:00","inspection_id":"75553065","insp_unit_id":"188674243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"10AK4A","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1FVHCYFC5LHLG8416","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:01.000000Z","updated_at":"2025-03-17T22:12:01.000000Z"}]},{"id":320319,"change_date":"2022-05-04 21:41:00","inspection_id":"75475164","dot_number":"819731","report_state":"MN","report_number":"00YN003538","insp_date":"2022-05-02 00:00:00","insp_start_time":"0935","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":"CLLWY","location_desc":"CALLAWAY","county_code_state":"MN","county_code":"005","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1326510","transaction_code":"A","transaction_date":"2022-05-02 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00819731","upload_search_indicator":null,"census_search_date":"2022-05-04 21:41:00","snet_input_date":"2022-05-04 00:00:00","source_office":"3MNS001","mcmis_add_date":"2022-05-04 21:41:00","insp_carrier_name":"MARK SAND & GRAVEL","insp_carrier_street":"P O BOX 458","insp_carrier_city":"FERGUS FALLS","insp_carrier_state":"MN","insp_carrier_zip_code":"56538","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:17.000000Z","updated_at":"2025-03-17T18:33:17.000000Z","inspection_violations":[{"id":498980,"change_date":"2022-05-04 21:41:00","inspection_id":"75475164","insp_violation_id":"245572711","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"188504643","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:23.000000Z","updated_at":"2025-03-17T21:09:23.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":518187,"change_date":"2022-05-04 21:41:00","inspection_id":"75475164","insp_unit_id":"188504643","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"438","insp_unit_license":"YTD8638","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1M1AN07Y9CM011335","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"},{"id":518188,"change_date":"2022-05-04 21:41:00","inspection_id":"75475164","insp_unit_id":"188504644","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLK","insp_unit_company":"T3613","insp_unit_license":"1295STM","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"1TKD04020EW033961","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:22.000000Z","updated_at":"2025-03-17T22:11:22.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/819731\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/819731\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/819731\/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\/819731\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}