{"current_page":1,"data":[{"id":10193108,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","dot_number":"204409","report_state":"IA","report_number":"000P14XJ31","insp_date":"2025-11-12 00:00:00","insp_start_time":"1030","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"52 AND TOWNLINE RD","county_code_state":"IA","county_code":"191","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-13 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"57000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1380853","transaction_code":"A","transaction_date":"2025-11-13 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-12 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:57.000000Z","updated_at":"2025-11-17T10:31:01.000000Z","inspection_violations":[{"id":16931690,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934798","seq_no":"1","part_no":"392","part_no_section":"2Y","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"3922Y"},{"id":16931691,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934799","seq_no":"2","part_no":"396","part_no_section":"3A1-LC","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"3963A1LC"},{"id":16931692,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934800","seq_no":"3","part_no":"396","part_no_section":"3A1-LC","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"3963A1LC"},{"id":16931693,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934801","seq_no":"4","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"3963A1BOS"},{"id":16931694,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934802","seq_no":"5","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"393201A"},{"id":16931695,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934803","seq_no":"6","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"39345B2"},{"id":16931696,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934804","seq_no":"7","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"39345B2"},{"id":16931697,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934805","seq_no":"8","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"39345B2"},{"id":16931698,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_violation_id":"269934806","seq_no":"9","part_no":"393","part_no_section":"47C","insp_viol_unit":"1","insp_unit_id":"210012810","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-16T10:33:28.000000Z","updated_at":"2025-11-17T10:31:29.000000Z","normalized_code":"39347C"}],"inspection_per_units":[{"id":16978013,"change_date":"2025-11-13 21:39:00","inspection_id":"86313503","insp_unit_id":"210012810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"61","insp_unit_license":"PS9001","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AM20C71M003725","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-16T10:02:29.000000Z","updated_at":"2025-11-17T10:01:05.000000Z"}]},{"id":9155231,"change_date":"2025-07-15 21:40:00","inspection_id":"85222095","dot_number":"204409","report_state":"IA","report_number":"000P13V91H","insp_date":"2025-07-14 00:00:00","insp_start_time":"1102","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY","county_code_state":"IA","county_code":"065","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING INC","shipping_paper_number":"OWN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"1367420","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-14 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-15 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:46:05.000000Z","updated_at":"2025-07-19T10:42:08.000000Z","inspection_violations":[{"id":14772086,"change_date":"2025-07-15 21:40:00","inspection_id":"85222095","insp_violation_id":"267419289","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:19.000000Z","updated_at":"2025-07-18T10:48:19.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":15036790,"change_date":"2025-07-15 21:40:00","inspection_id":"85222095","insp_unit_id":"207883288","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"79","insp_unit_license":"FP2793","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AX04C7JM038920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:40.000000Z","updated_at":"2025-07-19T09:45:52.000000Z"}]},{"id":8836801,"change_date":"2025-06-06 21:40:00","inspection_id":"84885579","dot_number":"204409","report_state":"IA","report_number":"000P12Q86W","insp_date":"2025-06-04 00:00:00","insp_start_time":"1000","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 150 AND 13TH ST NE INDEPEN","county_code_state":"IA","county_code":"019","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-06 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":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1362991","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:18.000000Z","updated_at":"2025-06-10T10:00:34.000000Z","inspection_violations":[{"id":14148522,"change_date":"2025-06-06 21:40:00","inspection_id":"84885579","insp_violation_id":"266706668","seq_no":"1","part_no":"393","part_no_section":"45D","insp_viol_unit":"1","insp_unit_id":"207263916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"39345D"},{"id":14148523,"change_date":"2025-06-06 21:40:00","inspection_id":"84885579","insp_violation_id":"266706669","seq_no":"2","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"207263916","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:49.000000Z","updated_at":"2025-06-10T10:16:00.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":14468768,"change_date":"2025-06-06 21:40:00","inspection_id":"84885579","insp_unit_id":"207263916","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"78","insp_unit_license":"DZ6324","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AX04C6JM037760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:18.000000Z","updated_at":"2025-06-10T09:45:44.000000Z"}]},{"id":8200590,"change_date":"2025-03-25 12:44:00","inspection_id":"84214915","dot_number":"204409","report_state":"IA","report_number":"000P14PH9T","insp_date":"2025-03-24 00:00:00","insp_start_time":"1118","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 24 NEW HAMPTON","county_code_state":"IA","county_code":"037","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KEITH KNODE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1354020","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:45.000000Z","updated_at":"2025-03-29T10:19:22.000000Z","inspection_violations":[{"id":12859229,"change_date":"2025-03-25 12:44:00","inspection_id":"84214915","insp_violation_id":"265231999","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:03.000000Z","updated_at":"2025-03-28T10:47:37.000000Z","normalized_code":"3922C"},{"id":12859230,"change_date":"2025-03-25 12:44:00","inspection_id":"84214915","insp_violation_id":"265232000","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205969924","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:32:03.000000Z","updated_at":"2025-03-28T10:47:37.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13258236,"change_date":"2025-03-25 12:44:00","inspection_id":"84214915","insp_unit_id":"205969924","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"67","insp_unit_license":"FT5217","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:12.000000Z","updated_at":"2025-03-29T09:56:59.000000Z"},{"id":13258237,"change_date":"2025-03-25 12:44:00","inspection_id":"84214915","insp_unit_id":"205969925","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"167","insp_unit_license":"EJ2489","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4412A9F7710255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:04:12.000000Z","updated_at":"2025-03-29T09:56:59.000000Z"}]},{"id":6711685,"change_date":"2024-09-12 21:42:00","inspection_id":"82644031","dot_number":"204409","report_state":"IA","report_number":"000P16991K","insp_date":"2024-09-11 00:00:00","insp_start_time":"1321","insp_end_time":"1348","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/IOWA CENTRAL","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"ROCKS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","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":"1329228","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:06.000000Z","updated_at":"2025-03-17T20:36:06.000000Z","inspection_violations":[{"id":10447981,"change_date":"2024-09-12 21:42:00","inspection_id":"82644031","insp_violation_id":"261766780","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1WIN24091113365","created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10822300,"change_date":"2024-09-12 21:42:00","inspection_id":"82644031","insp_unit_id":"202893304","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"73","insp_unit_license":"FX7179","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR69C041433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:03.000000Z","updated_at":"2025-03-17T23:35:03.000000Z"}]},{"id":6689986,"change_date":"2024-09-10 21:40:00","inspection_id":"82620995","dot_number":"204409","report_state":"IA","report_number":"000P16990L","insp_date":"2024-09-09 00:00:00","insp_start_time":"1107","insp_end_time":"1129","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 169 SB\/270TH ST","county_code_state":"IA","county_code":"187","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"ROCK","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1328842","transaction_code":"A","transaction_date":"2024-09-10 00:00:00","upload_date":"2024-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-09 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:40.000000Z","updated_at":"2025-03-17T20:35:40.000000Z","inspection_violations":[{"id":10412926,"change_date":"2024-09-10 21:40:00","inspection_id":"82620995","insp_violation_id":"261712553","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:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10786898,"change_date":"2024-09-10 21:40:00","inspection_id":"82620995","insp_unit_id":"202846924","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"73","insp_unit_license":"FX7179","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR69C041433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:41.000000Z","updated_at":"2025-03-17T23:34:41.000000Z"}]},{"id":6403303,"change_date":"2024-08-06 21:43:00","inspection_id":"82315375","dot_number":"204409","report_state":"IA","report_number":"000P14PGTZ","insp_date":"2024-08-05 00:00:00","insp_start_time":"1638","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 LIME SPRINGS","county_code_state":"IA","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1324021","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-05 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:51.000000Z","updated_at":"2025-03-17T20:29:51.000000Z","inspection_violations":[{"id":9939760,"change_date":"2024-08-06 21:43:00","inspection_id":"82315375","insp_violation_id":"261042178","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2WIC24080516494","created_at":"2025-03-17T21:54:02.000000Z","updated_at":"2025-03-17T21:54:02.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":10319320,"change_date":"2024-08-06 21:43:00","inspection_id":"82315375","insp_unit_id":"202261169","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"ACTERRA","insp_unit_license":"ERB932","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FZACFDD04AN43423","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:56.000000Z","updated_at":"2025-03-17T23:29:56.000000Z"}]},{"id":6197696,"change_date":"2024-07-11 21:41:00","inspection_id":"82095173","dot_number":"204409","report_state":"IA","report_number":"000P12Q73M","insp_date":"2024-07-10 00:00:00","insp_start_time":"1110","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"220TH AND HENLEY AVE INDEPENDE","county_code_state":"IA","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"1320600","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:25.000000Z","updated_at":"2025-03-17T20:25:25.000000Z","inspection_violations":[{"id":9624731,"change_date":"2024-07-11 21:41:00","inspection_id":"82095173","insp_violation_id":"260591964","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:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9984401,"change_date":"2024-07-11 21:41:00","inspection_id":"82095173","insp_unit_id":"201841702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"79","insp_unit_license":"FP2793","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AX04C7JM038920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:27.000000Z","updated_at":"2025-03-17T23:26:27.000000Z"}]},{"id":6008044,"change_date":"2024-06-17 21:43:00","inspection_id":"81891207","dot_number":"204409","report_state":"IA","report_number":"000TT6CGS2","insp_date":"2024-06-13 00:00:00","insp_start_time":"1828","insp_end_time":"1840","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB PORTLAND","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1317047","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-06-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-06-17 21:43:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:51.000000Z","updated_at":"2025-03-17T20:21:51.000000Z","inspection_violations":[{"id":9320899,"change_date":"2024-06-17 21:43:00","inspection_id":"81891207","insp_violation_id":"260124677","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:51:07.000000Z","updated_at":"2025-03-17T21:51:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9676852,"change_date":"2024-06-17 21:43:00","inspection_id":"81891207","insp_unit_id":"201429704","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"80","insp_unit_license":"FA6146","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2GR2GC4KM010182","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:18.000000Z","updated_at":"2025-03-17T23:23:18.000000Z"}]},{"id":4351338,"change_date":"2023-11-03 21:41:00","inspection_id":"80081808","dot_number":"204409","report_state":"IA","report_number":"000TT4PGJK","insp_date":"2023-10-30 00:00:00","insp_start_time":"1110","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 CRESCO","county_code_state":"IA","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"57000","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1292880","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-11-03 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:08.000000Z","updated_at":"2025-03-17T19:49:08.000000Z","inspection_violations":[{"id":6730227,"change_date":"2023-11-03 21:41:00","inspection_id":"80081808","insp_violation_id":"256210200","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922"},{"id":6730228,"change_date":"2023-11-03 21:41:00","inspection_id":"80081808","insp_violation_id":"256210201","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197899363","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3939A"},{"id":6730229,"change_date":"2023-11-03 21:41:00","inspection_id":"80081808","insp_violation_id":"256210202","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197899363","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":6997870,"change_date":"2023-11-03 21:41:00","inspection_id":"80081808","insp_unit_id":"197899363","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"60","insp_unit_license":"SE2612","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M1AE07Y71W006054","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:44.000000Z","updated_at":"2025-03-17T22:58:44.000000Z"}]},{"id":4134116,"change_date":"2023-10-05 21:40:00","inspection_id":"79841884","dot_number":"204409","report_state":"IA","report_number":"000TT697W0","insp_date":"2023-10-04 00:00:00","insp_start_time":"0931","insp_end_time":"1001","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 EB\/HWY 169","county_code_state":"IA","county_code":"109","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1290768","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-04 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:29.000000Z","updated_at":"2025-03-17T19:44:29.000000Z","inspection_violations":[{"id":6398533,"change_date":"2023-10-05 21:40:00","inspection_id":"79841884","insp_violation_id":"255677758","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3922"},{"id":6398534,"change_date":"2023-10-05 21:40:00","inspection_id":"79841884","insp_violation_id":"255677759","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197415788","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6647263,"change_date":"2023-10-05 21:40:00","inspection_id":"79841884","insp_unit_id":"197415788","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"73","insp_unit_license":"SG7194","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR69C041433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:46.000000Z","updated_at":"2025-03-17T22:55:46.000000Z"}]},{"id":3857923,"change_date":"2023-08-29 21:42:00","inspection_id":"79534805","dot_number":"204409","report_state":"IA","report_number":"000TT4PGGH","insp_date":"2023-08-28 00:00:00","insp_start_time":"0923","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"US HWY 63 LIME SPRINGS","county_code_state":"IA","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37600","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1286914","transaction_code":"A","transaction_date":"2023-08-29 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:58.000000Z","updated_at":"2025-03-17T19:38:58.000000Z","inspection_violations":[{"id":5958868,"change_date":"2023-08-29 21:42:00","inspection_id":"79534805","insp_violation_id":"254950457","seq_no":"1","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"1","insp_unit_id":"196786030","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:49.000000Z","updated_at":"2025-03-17T21:34:49.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":6202330,"change_date":"2023-08-29 21:42:00","inspection_id":"79534805","insp_unit_id":"196786030","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"STRG","insp_unit_company":"IVJ637","insp_unit_license":"IVJ637","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2FZAATCS75AU95943","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:07.000000Z","updated_at":"2025-03-17T22:52:07.000000Z"}]},{"id":3578318,"change_date":"2023-07-24 21:42:00","inspection_id":"79222117","dot_number":"204409","report_state":"IA","report_number":"000TT8CGK5","insp_date":"2023-07-19 00:00:00","insp_start_time":"0733","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 151\/INDUSTRIAL PARK RD","county_code_state":"IA","county_code":"105","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281713","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-07-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:35.000000Z","updated_at":"2025-03-17T19:33:35.000000Z","inspection_violations":[{"id":5517094,"change_date":"2023-07-24 21:42:00","inspection_id":"79222117","insp_violation_id":"254236440","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5753522,"change_date":"2023-07-24 21:42:00","inspection_id":"79222117","insp_unit_id":"196157270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"73","insp_unit_license":"SG7194","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR69C041433","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:24.000000Z","updated_at":"2025-03-17T22:48:24.000000Z"}]},{"id":3248242,"change_date":"2023-06-09 21:40:00","inspection_id":"78850696","dot_number":"204409","report_state":"IA","report_number":"000TT6ZVT7","insp_date":"2023-06-08 00:00:00","insp_start_time":"0815","insp_end_time":"0835","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218\/9 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHER COOP","shipping_paper_number":"3882","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1278328","transaction_code":"A","transaction_date":"2023-06-09 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-06-08 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:20.000000Z","updated_at":"2025-03-17T19:27:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5224188,"change_date":"2023-06-09 21:40:00","inspection_id":"78850696","insp_unit_id":"195415822","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"72","insp_unit_license":"DD1442","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR67C563105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"},{"id":5224189,"change_date":"2023-06-09 21:40:00","inspection_id":"78850696","insp_unit_id":"195415823","insp_unit_type_id":"8","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"NONE","insp_unit_license":"IH7295","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4432A8F7708167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"}]},{"id":3106378,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","dot_number":"204409","report_state":"IA","report_number":"000TT7D7D5","insp_date":"2023-05-19 00:00:00","insp_start_time":"1400","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63 AND 150TH ST NEW HAMPTO","county_code_state":"IA","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"186660","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1276531","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:34.000000Z","updated_at":"2025-03-17T19:24:34.000000Z","inspection_violations":[{"id":4778304,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986900","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3939A"},{"id":4778305,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986901","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3939A"},{"id":4778306,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986902","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3939A"},{"id":4778307,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986903","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3939A"},{"id":4778308,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986904","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"T11823051914263","created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39345B2"},{"id":4778309,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986905","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195065413","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39345B2"},{"id":4778310,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986906","seq_no":"7","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"195065414","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39311"},{"id":4778311,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_violation_id":"252986907","seq_no":"8","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195065413","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":4996309,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_unit_id":"195065413","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"58","insp_unit_license":"PK2199","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR94C092711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"},{"id":4996310,"change_date":"2023-05-22 21:40:00","inspection_id":"78690492","insp_unit_id":"195065414","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":null,"insp_unit_license":"JR3209","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4U3S0051XDL012970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"}]},{"id":3106410,"change_date":"2023-05-22 21:40:00","inspection_id":"78690530","dot_number":"204409","report_state":"IA","report_number":"000TT7D7D7","insp_date":"2023-05-19 00:00:00","insp_start_time":"1625","insp_end_time":"1635","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63 AND HWY 9 SARASOTA","county_code_state":"IA","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1276508","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-22 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:34.000000Z","updated_at":"2025-03-17T19:24:34.000000Z","inspection_violations":[{"id":4778371,"change_date":"2023-05-22 21:40:00","inspection_id":"78690530","insp_violation_id":"252986978","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4996368,"change_date":"2023-05-22 21:40:00","inspection_id":"78690530","insp_unit_id":"195065484","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"79","insp_unit_license":"FP2793","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1M2AX04C7JM038920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"}]},{"id":2954382,"change_date":"2023-05-03 21:41:00","inspection_id":"78518875","dot_number":"204409","report_state":"IA","report_number":"000TT6ZVR7","insp_date":"2023-05-02 00:00:00","insp_start_time":"0720","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218\/9 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHERN COOP","shipping_paper_number":"3018","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1273574","transaction_code":"A","transaction_date":"2023-05-03 00:00:00","upload_date":"2023-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-05-03 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:21:24.000000Z","updated_at":"2025-03-17T19:21:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4753770,"change_date":"2023-05-03 21:41:00","inspection_id":"78518875","insp_unit_id":"194725017","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"72","insp_unit_license":"DD1442","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR67C563105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"},{"id":4753771,"change_date":"2023-05-03 21:41:00","inspection_id":"78518875","insp_unit_id":"194725018","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"172","insp_unit_license":"IH7295","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4432A8F7708167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:40:28.000000Z","updated_at":"2025-03-17T22:40:28.000000Z"}]},{"id":2655875,"change_date":"2023-03-24 21:41:00","inspection_id":"78179869","dot_number":"204409","report_state":"IA","report_number":"000TT6ZVN1","insp_date":"2023-03-23 00:00:00","insp_start_time":"0800","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9\/218 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1268050","transaction_code":"A","transaction_date":"2023-03-24 00:00:00","upload_date":"2023-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-23 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-03-24 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:34.000000Z","updated_at":"2025-03-17T19:15:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4275784,"change_date":"2023-03-24 21:41:00","inspection_id":"78179869","insp_unit_id":"194053335","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"66","insp_unit_license":"SG8477","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"},{"id":4275785,"change_date":"2023-03-24 21:41:00","inspection_id":"78179869","insp_unit_id":"194053336","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"NONE","insp_unit_license":"HH0430","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WWSAFYA5A5700332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:41.000000Z","updated_at":"2025-03-17T22:36:41.000000Z"}]},{"id":2201395,"change_date":"2023-01-23 21:41:00","inspection_id":"77662680","dot_number":"204409","report_state":"IA","report_number":"000P123CKS","insp_date":"2023-01-20 00:00:00","insp_start_time":"1001","insp_end_time":"1024","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HIGHWAY 18","county_code_state":"IA","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259403","transaction_code":"A","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-01-23 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:19.000000Z","updated_at":"2025-03-17T19:07:19.000000Z","inspection_violations":[{"id":3399419,"change_date":"2023-01-23 21:41:00","inspection_id":"77662680","insp_violation_id":"250710859","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:02.000000Z","updated_at":"2025-03-17T21:23:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3543018,"change_date":"2023-01-23 21:41:00","inspection_id":"77662680","insp_unit_id":"193002871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"66","insp_unit_license":"SG8477","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:24.000000Z","updated_at":"2025-03-17T22:31:24.000000Z"},{"id":3543019,"change_date":"2023-01-23 21:41:00","inspection_id":"77662680","insp_unit_id":"193002872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"166","insp_unit_license":"HH0430","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WWSAFYA5A5700332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:24.000000Z","updated_at":"2025-03-17T22:31:24.000000Z"}]},{"id":1860848,"change_date":"2022-12-02 21:41:00","inspection_id":"77272853","dot_number":"204409","report_state":"IA","report_number":"000TT6ZV98","insp_date":"2022-11-30 00:00:00","insp_start_time":"0745","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 SB OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253011","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2994562,"change_date":"2022-12-02 21:41:00","inspection_id":"77272853","insp_unit_id":"192234191","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"67","insp_unit_license":"FT5217","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329651","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"},{"id":2994563,"change_date":"2022-12-02 21:41:00","inspection_id":"77272853","insp_unit_id":"192234192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"NONE","insp_unit_license":"EJ2489","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4412A9F7710255","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1860942,"change_date":"2022-12-02 21:41:00","inspection_id":"77272981","dot_number":"204409","report_state":"IA","report_number":"000TT6ZV99","insp_date":"2022-11-30 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 WB FROM RICEVILLE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1253100","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2899130,"change_date":"2022-12-02 21:41:00","inspection_id":"77272981","insp_violation_id":"249892016","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T41922113008545","created_at":"2025-03-17T21:20:48.000000Z","updated_at":"2025-03-17T21:20:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2994736,"change_date":"2022-12-02 21:41:00","inspection_id":"77272981","insp_unit_id":"192234425","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"66","insp_unit_license":"SG8477","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"},{"id":2994737,"change_date":"2022-12-02 21:41:00","inspection_id":"77272981","insp_unit_id":"192234426","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"NONE","insp_unit_license":"HH0430","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WWSAFYA5A5700332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:29.000000Z","updated_at":"2025-03-17T22:27:29.000000Z"}]},{"id":1603279,"change_date":"2022-10-26 21:39:00","inspection_id":"76977525","dot_number":"204409","report_state":"IA","report_number":"000TT6ZV67","insp_date":"2022-10-19 00:00:00","insp_start_time":"0720","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218\/9 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1247899","transaction_code":"A","transaction_date":"2022-10-24 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:56:16.000000Z","updated_at":"2025-03-17T18:56:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2579748,"change_date":"2022-10-26 21:39:00","inspection_id":"76977525","insp_unit_id":"191648174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"72","insp_unit_license":"DD1442","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR67C563105","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:40.000000Z","updated_at":"2025-03-17T22:24:40.000000Z"},{"id":2579749,"change_date":"2022-10-26 21:39:00","inspection_id":"76977525","insp_unit_id":"191648175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"172","insp_unit_license":"IH7295","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WW4432A8F7708167","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:40.000000Z","updated_at":"2025-03-17T22:24:40.000000Z"}]},{"id":1344095,"change_date":"2022-09-22 21:40:00","inspection_id":"76678018","dot_number":"204409","report_state":"IA","report_number":"000TT83KW7","insp_date":"2022-09-20 00:00:00","insp_start_time":"1455","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 18 EB WEST OF VENTURA","county_code_state":"IA","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT TILING INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1243133","transaction_code":"A","transaction_date":"2022-09-22 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2128814,"change_date":"2022-09-22 21:40:00","inspection_id":"76678018","insp_violation_id":"248584787","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2164129,"change_date":"2022-09-22 21:40:00","inspection_id":"76678018","insp_unit_id":"191042798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"57","insp_unit_license":"SE2610","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCEAPR34C092722","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:48.000000Z","updated_at":"2025-03-17T22:21:48.000000Z"}]},{"id":550355,"change_date":"2022-06-06 21:40:00","inspection_id":"75749080","dot_number":"204409","report_state":"IA","report_number":"000TT6ZTRN","insp_date":"2022-06-03 00:00:00","insp_start_time":"0820","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 SB AND HWY 9 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1227972","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:27.000000Z","updated_at":"2025-03-17T18:37:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":885385,"change_date":"2022-06-06 21:40:00","inspection_id":"75749080","insp_unit_id":"189081090","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"66","insp_unit_license":"SDSG8477","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"2HSCNAPR37C329617","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"},{"id":885386,"change_date":"2022-06-06 21:40:00","inspection_id":"75749080","insp_unit_id":"189081091","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"166","insp_unit_license":"HH0430","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WWSAFYA5A5700332","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:40.000000Z","updated_at":"2025-03-17T22:13:40.000000Z"}]},{"id":406848,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","dot_number":"204409","report_state":"IA","report_number":"000TT7CQ89","insp_date":"2022-05-16 00:00:00","insp_start_time":"1020","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 AND 63 EB","county_code_state":"IA","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CAT D4 DOZER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-17 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225119","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-16 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:46.000000Z","updated_at":"2025-03-17T18:34:46.000000Z","inspection_violations":[{"id":636076,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_violation_id":"245835518","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"},{"id":636077,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_violation_id":"245835519","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188724016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"39021TB"},{"id":636078,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_violation_id":"245835520","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188724016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"},{"id":636079,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_violation_id":"245835521","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"188724016","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:58.000000Z","updated_at":"2025-03-17T21:09:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":656861,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_unit_id":"188724016","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"29","insp_unit_license":"PY4511","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"1HSRDXZR0HHB12729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"},{"id":656862,"change_date":"2022-05-17 21:43:00","inspection_id":"75578365","insp_unit_id":"188724017","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":"0T","insp_unit_license":"5329EL","insp_unit_license_state":"OT","insp_unit_vehicle_id_number":"4U181DHX8X1X37023","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:14.000000Z","updated_at":"2025-03-17T22:12:14.000000Z"}]},{"id":289018,"change_date":"2022-04-29 21:41:00","inspection_id":"75438139","dot_number":"204409","report_state":"IA","report_number":"000TT6LP9Z","insp_date":"2022-04-28 00:00:00","insp_start_time":"1035","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB HWY 218 OSAGE","county_code_state":"IA","county_code":"131","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MEHMERT","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222779","transaction_code":"A","transaction_date":"2022-04-29 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-04-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:35.000000Z","updated_at":"2025-03-17T18:32:35.000000Z","inspection_violations":[{"id":450701,"change_date":"2022-04-29 21:41:00","inspection_id":"75438139","insp_violation_id":"245479685","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"T32822042810403","created_at":"2025-03-17T21:09:11.000000Z","updated_at":"2025-03-17T21:09:11.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":467632,"change_date":"2022-04-29 21:41:00","inspection_id":"75438139","insp_unit_id":"188425871","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"77","insp_unit_license":"DX3014","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCEAPR34N089379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"},{"id":467633,"change_date":"2022-04-29 21:41:00","inspection_id":"75438139","insp_unit_id":"188425872","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILX","insp_unit_company":"00","insp_unit_license":"IH7296","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4WWSAFYA7A5700333","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"}]},{"id":61661,"change_date":"2022-03-29 21:42:00","inspection_id":"75163803","dot_number":"204409","report_state":"IA","report_number":"000TT85S21","insp_date":"2022-03-28 00:00:00","insp_start_time":"1254","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 9 SARATOGA","county_code_state":"IA","county_code":"089","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"188000","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":"1217529","transaction_code":"A","transaction_date":"2022-03-29 00:00:00","upload_date":"2022-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00204409","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-28 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-03-29 21:42:00","insp_carrier_name":"MEHMERT TILING INC","insp_carrier_street":"8635 HWY 9","insp_carrier_city":"LIME SPRINGS","insp_carrier_state":"IA","insp_carrier_zip_code":"52155","insp_colonia":null,"docket_number":"999472","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:45.000000Z","updated_at":"2025-03-17T18:28:45.000000Z","inspection_violations":[{"id":88441,"change_date":"2022-03-29 21:42:00","inspection_id":"75163803","insp_violation_id":"244832758","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:31.000000Z","updated_at":"2025-03-17T21:07:31.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":100095,"change_date":"2022-03-29 21:42:00","inspection_id":"75163803","insp_unit_id":"187871679","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"81","insp_unit_license":"FE1260","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HSCXAPR3GN379233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"},{"id":100096,"change_date":"2022-03-29 21:42:00","inspection_id":"75163803","insp_unit_id":"187871680","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":"70","insp_unit_license":"5243EL","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"4U3S0051XDL012970","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:51.000000Z","updated_at":"2025-03-17T22:08:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/204409\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/204409\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/204409\/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\/204409\/inspections","per_page":100,"prev_page_url":null,"to":27,"total":27}