{"current_page":1,"data":[{"id":11697368,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","dot_number":"1709227","report_state":"MI","report_number":"WASCC01337","insp_date":"2026-04-17 00:00:00","insp_start_time":"1210","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"STAGE AVE NW NEAR 7 MILE RD NW","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"11150","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":"1266828","transaction_code":"A","transaction_date":"2026-04-17 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2026-04-20 21:38:00","snet_input_date":"2026-04-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-20 21:38:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-04-27T09:36:01.000000Z","updated_at":"2026-05-01T09:31:01.000000Z","inspection_violations":[{"id":20324626,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","insp_violation_id":"273721217","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","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-04-27T09:51:54.000000Z","updated_at":"2026-05-01T09:42:29.000000Z","normalized_code":"3922SLLTCD"},{"id":20324627,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","insp_violation_id":"273721218","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4677875","created_at":"2026-04-27T09:51:54.000000Z","updated_at":"2026-05-01T09:42:29.000000Z","normalized_code":"39141APC"},{"id":20324628,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","insp_violation_id":"273721219","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:54.000000Z","updated_at":"2026-05-01T09:42:29.000000Z","normalized_code":"3922SLLSR"},{"id":20324629,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","insp_violation_id":"273721220","seq_no":"4","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:51:54.000000Z","updated_at":"2026-05-01T09:42:29.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":20357095,"change_date":"2026-04-20 21:38:00","inspection_id":"87623754","insp_unit_id":"213115363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"DG24276","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4KNEY6SF342284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:28.000000Z","updated_at":"2026-05-01T09:04:02.000000Z"}]},{"id":7774174,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","dot_number":"1709227","report_state":"MI","report_number":"AKERT00451","insp_date":"2025-01-31 00:00:00","insp_start_time":"1537","insp_end_time":"1634","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M37 & ALPINE AVE","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1208552","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2025-02-03 21:39:00","snet_input_date":"2025-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-03 21:39:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:33.000000Z","updated_at":"2025-03-17T20:59:33.000000Z","inspection_violations":[{"id":12147368,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309901","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":"X4475691","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"38323A2LCDLN"},{"id":12147369,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309902","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39141AMCPC"},{"id":12147370,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309903","seq_no":"3","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"205132966","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3939ALLPL"},{"id":12147371,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309904","seq_no":"4","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"205132967","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4475691","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39343DBMA"},{"id":12147372,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309905","seq_no":"5","part_no":"393","part_no_section":"104F3-C","insp_viol_unit":"2","insp_unit_id":"205132967","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"393104F3C"},{"id":12147373,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309906","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205132967","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39617CPI"},{"id":12147374,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309907","seq_no":"7","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"205132967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3939ALIL"},{"id":12147375,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_violation_id":"264309908","seq_no":"8","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"2","insp_unit_id":"205132967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":12546557,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_unit_id":"205132966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"BD94470","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3C7WRNBL2EG165302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"},{"id":12546558,"change_date":"2025-02-03 21:39:00","inspection_id":"83766825","insp_unit_id":"205132967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ROAD","insp_unit_company":null,"insp_unit_license":"E213184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2221L1221931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:35.000000Z","updated_at":"2025-03-17T23:53:35.000000Z"}]},{"id":5985870,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","dot_number":"1709227","report_state":"MI","report_number":"ROBEJ00425","insp_date":"2024-06-12 00:00:00","insp_start_time":"0815","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 N\/B AT MORLEY REST AREA","county_code_state":"MI","county_code":"117","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"27060","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1182374","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2024-06-13 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-13 21:42:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:27.000000Z","updated_at":"2025-03-17T20:21:27.000000Z","inspection_violations":[{"id":9286014,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072619","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39617C"},{"id":9286015,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072620","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39378"},{"id":9286016,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072621","seq_no":"3","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3929A"},{"id":9286017,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072622","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39347E"},{"id":9286018,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072623","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39353B"},{"id":9286019,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072624","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"3963A1"},{"id":9286020,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072625","seq_no":"7","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"393209E"},{"id":9286021,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_violation_id":"260072626","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201383466","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:56.000000Z","updated_at":"2025-03-17T21:50:56.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":9641650,"change_date":"2024-06-13 21:42:00","inspection_id":"81867171","insp_unit_id":"201383466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"6","insp_unit_license":"BB44774","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GDM7H1C9XJ512022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:56.000000Z","updated_at":"2025-03-17T23:22:56.000000Z"}]},{"id":4955155,"change_date":"2024-02-01 21:43:00","inspection_id":"80744285","dot_number":"1709227","report_state":"MI","report_number":"ROBEJ00320","insp_date":"2024-01-31 00:00:00","insp_start_time":"0845","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WOODBRIDGE AND 18 MILE RD","county_code_state":"MI","county_code":"123","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-01 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"15000","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":"1162731","transaction_code":"A","transaction_date":"2024-01-31 00:00:00","upload_date":"2024-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2024-02-01 21:43:00","snet_input_date":"2024-01-31 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-01 21:43:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:00:52.000000Z","updated_at":"2025-03-17T20:00:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7974676,"change_date":"2024-02-01 21:43:00","inspection_id":"80744285","insp_unit_id":"199222206","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"GREEN","insp_unit_license":"ZT2846","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF70J7TVA17676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:16.000000Z","updated_at":"2025-03-17T23:07:16.000000Z"}]},{"id":4876338,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","dot_number":"1709227","report_state":"MI","report_number":"ROBEJ00315","insp_date":"2024-01-19 00:00:00","insp_start_time":"1005","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWAYGO RD AT HALL RD","county_code_state":"MI","county_code":"121","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-22 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"8","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1161205","transaction_code":"A","transaction_date":"2024-01-19 00:00:00","upload_date":"2024-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2024-01-22 21:44:00","snet_input_date":"2024-01-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-22 21:44:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:16.000000Z","updated_at":"2025-03-17T19:59:16.000000Z","inspection_violations":[{"id":7513444,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434588","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"38323A2"},{"id":7513445,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434589","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4323779","created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39141A"},{"id":7513446,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434590","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199052790","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39617C"},{"id":7513447,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434591","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"199052790","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39395F"},{"id":7513448,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434592","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199052791","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3922"},{"id":7513449,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434593","seq_no":"8","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"199052791","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39343"},{"id":7513450,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434594","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199052790","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"3939A"},{"id":7513451,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_violation_id":"257434595","seq_no":"6","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"199052790","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:42:14.000000Z","updated_at":"2025-03-17T21:42:14.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":7845868,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_unit_id":"199052790","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"18","insp_unit_license":"BA89441","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD8X3HT3GEC96526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"},{"id":7845869,"change_date":"2024-01-22 21:44:00","inspection_id":"80658034","insp_unit_id":"199052791","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DIAC","insp_unit_company":"BLACK","insp_unit_license":"E213184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2221L1221931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:08.000000Z","updated_at":"2025-03-17T23:06:08.000000Z"}]},{"id":3686166,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","dot_number":"1709227","report_state":"MI","report_number":"OWENP01110","insp_date":"2023-08-04 00:00:00","insp_start_time":"1049","insp_end_time":"1133","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"M6 WB @ BROADMOOR","county_code_state":"MI","county_code":"081","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"39500","viol_total":"12","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1138636","transaction_code":"C","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2023-08-07 21:42:00","snet_input_date":"2023-08-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[{"id":5683343,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987237","seq_no":"1","part_no":"393","part_no_section":"112","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"393112"},{"id":5683344,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987238","seq_no":"2","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"393104F3"},{"id":5683345,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987239","seq_no":"3","part_no":"393","part_no_section":"110","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"393110"},{"id":5683346,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987240","seq_no":"4","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"39343"},{"id":5683347,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987241","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3922"},{"id":5683348,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987242","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"39617C"},{"id":5683349,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987243","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196815859","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3939A"},{"id":5683350,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987244","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"196815858","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"3963A1"},{"id":5683351,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987245","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"196815858","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"39617C"},{"id":5683352,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987246","seq_no":"10","part_no":"390","part_no_section":"19(b)(2)","insp_viol_unit":"1","insp_unit_id":"196815858","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"39019B2"},{"id":5683353,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987247","seq_no":"11","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4240196","created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"38323A2"},{"id":5683354,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_violation_id":"254987248","seq_no":"12","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:21.000000Z","updated_at":"2025-03-17T21:33:21.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":5926565,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_unit_id":"196815858","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"21","insp_unit_license":"BC52923","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDUF5HT0LEC52877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"},{"id":5926566,"change_date":"2023-08-30 21:45:00","inspection_id":"79343127","insp_unit_id":"196815859","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DIAC","insp_unit_company":null,"insp_unit_license":"E213184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2221L1221931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"}]},{"id":2234822,"change_date":"2023-01-26 21:42:00","inspection_id":"77700774","dot_number":"1709227","report_state":"MI","report_number":"MYERZ00070","insp_date":"2023-01-25 00:00:00","insp_start_time":"0829","insp_end_time":"0914","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ALPINE AVE @ 4 MILE RD","county_code_state":"MI","county_code":"081","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25300","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":"1110961","transaction_code":"A","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01709227","upload_search_indicator":null,"census_search_date":"2023-01-26 21:42:00","snet_input_date":"2023-01-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-26 21:42:00","insp_carrier_name":"WAHLFIELD DRILLING CO INC","insp_carrier_street":"4449 WESTSHIRE DR NW","insp_carrier_city":"COMSTOCK PARK","insp_carrier_state":"MI","insp_carrier_zip_code":"49321","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:46.000000Z","updated_at":"2025-03-17T19:07:46.000000Z","inspection_violations":[{"id":3452334,"change_date":"2023-01-26 21:42:00","inspection_id":"77700774","insp_violation_id":"250798450","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":3597200,"change_date":"2023-01-26 21:42:00","inspection_id":"77700774","insp_unit_id":"193084018","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"0395","insp_unit_license":"BB57325","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FD8X3BT3JEB81036","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:48.000000Z","updated_at":"2025-03-17T22:31:48.000000Z"},{"id":3597201,"change_date":"2023-01-26 21:42:00","inspection_id":"77700774","insp_unit_id":"193084019","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DIAS","insp_unit_company":"-","insp_unit_license":"E213184","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"46UFU2221L1221931","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:48.000000Z","updated_at":"2025-03-17T22:31:48.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1709227\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1709227\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1709227\/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\/1709227\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}