{"current_page":1,"data":[{"id":12301767,"change_date":"2026-06-27 21:42:00","inspection_id":"88258881","dot_number":"179862","report_state":"OH","report_number":"9500000042","insp_date":"2026-06-25 00:00:00","insp_start_time":"1010","insp_end_time":"1043","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HARRISON OH","county_code_state":"OH","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND POOL AND SPA","shipping_paper_number":"502131","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:42: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":"3635708","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2026-06-27 21:42:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:20.000000Z","updated_at":"2026-07-08T09:31:11.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":12303957,"change_date":"2026-06-27 21:42:00","inspection_id":"88261162","dot_number":"179862","report_state":"OH","report_number":"3286001423","insp_date":"2026-06-25 00:00:00","insp_start_time":"1250","insp_end_time":"1316","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CONVOY OH","county_code_state":"OH","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND","shipping_paper_number":"277781","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-27 21:42: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":"3634865","transaction_code":"A","transaction_date":"2026-06-26 00:00:00","upload_date":"2026-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2026-06-27 21:42:00","snet_input_date":"2026-06-25 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-27 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-30T09:40:25.000000Z","updated_at":"2026-07-08T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[]},{"id":11365548,"change_date":"2026-03-13 21:37:00","inspection_id":"87278906","dot_number":"179862","report_state":"OH","report_number":"3204000333","insp_date":"2026-03-11 00:00:00","insp_start_time":"0952","insp_end_time":"1018","registration_date":null,"region":"ED","ci_status_code":"C","location":"05","location_desc":"HARRISON OH","county_code_state":"OH","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND POOL AND SPA PRODUCTS","shipping_paper_number":"491539","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-13 21:37: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":"2999083","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2026-03-13 21:37:00","snet_input_date":"2026-03-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:08.000000Z","updated_at":"2026-03-24T09:30:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20332338,"change_date":null,"inspection_id":"87278906","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20335472,"change_date":null,"inspection_id":"87278906","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11370285,"change_date":"2026-03-13 21:37:00","inspection_id":"87283898","dot_number":"179862","report_state":"MI","report_number":"BENNK01104","insp_date":"2026-03-10 00:00:00","insp_start_time":"0910","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CO RD 633 @ BARTLETT RD","county_code_state":"MI","county_code":"055","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-13 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"121250","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":"1262161","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-03-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-03-13 21:37:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-16T09:39:16.000000Z","updated_at":"2026-03-24T09:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20332387,"change_date":null,"inspection_id":"87283898","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3715939","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG0SSVM3513","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"},{"id":20335525,"change_date":null,"inspection_id":"87283898","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D768355","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V482C9JT451001","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11227723,"change_date":"2026-03-06 21:42:00","inspection_id":"87139798","dot_number":"179862","report_state":"MI","report_number":"FALAS00558","insp_date":"2026-02-24 00:00:00","insp_start_time":"1520","insp_end_time":"1532","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ MM 108","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MULTI","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-02-25 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1260479","transaction_code":"C","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-02-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-02-25 21:49:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:39:27.000000Z","updated_at":"2026-03-17T09:30:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19456369,"change_date":null,"inspection_id":"87139798","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"},{"id":19459495,"change_date":null,"inspection_id":"87139798","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"PF30964","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2485S7302701","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-03-16T03:15:23.000000Z","updated_at":"2026-03-16T03:15:23.000000Z"}]},{"id":10776721,"change_date":"2026-01-15 21:41:00","inspection_id":"86802223","dot_number":"179862","report_state":"IN","report_number":"7018000081","insp_date":"2026-01-15 00:00:00","insp_start_time":"0903","insp_end_time":"0940","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GREENTOWN IN","county_code_state":"IN","county_code":"067","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"1066458","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-15 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":"2770456","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-18T10:45:04.000000Z","updated_at":"2026-01-26T10:30:43.000000Z","inspection_violations":[{"id":18745544,"change_date":null,"inspection_id":"86802223","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-23T04:17:42.000000Z","updated_at":"2026-02-23T04:17:42.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":19094408,"change_date":null,"inspection_id":"86802223","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"PF31727","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"},{"id":19090679,"change_date":null,"inspection_id":"86802223","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-23T04:15:17.000000Z","updated_at":"2026-02-23T04:15:17.000000Z"}]},{"id":10457697,"change_date":"2025-12-17 21:39:00","inspection_id":"86590519","dot_number":"179862","report_state":"IN","report_number":"8879004272","insp_date":"2025-12-11 00:00:00","insp_start_time":"1046","insp_end_time":"1146","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MICHIGAN CITY IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"140053","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2670496","transaction_code":"A","transaction_date":"2025-12-17 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-12-17 21:39:00","snet_input_date":"2025-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:42.000000Z","updated_at":"2025-12-28T10:30:40.000000Z","inspection_violations":[{"id":17544914,"change_date":"2025-12-17 21:39:00","inspection_id":"86590519","insp_violation_id":"270735663","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"2","insp_unit_id":"210656164","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-20T10:32:16.000000Z","updated_at":"2025-12-28T10:31:12.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":17501665,"change_date":"2025-12-17 21:39:00","inspection_id":"86590519","insp_unit_id":"210656163","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599909","insp_unit_license":"3420200","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:46.000000Z","updated_at":"2025-12-28T10:00:45.000000Z"},{"id":17501666,"change_date":"2025-12-17 21:39:00","inspection_id":"86590519","insp_unit_id":"210656164","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"200591","insp_unit_license":"P912784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2487L3963901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:46.000000Z","updated_at":"2025-12-28T10:00:45.000000Z"}]},{"id":10173337,"change_date":"2025-11-12 21:40:00","inspection_id":"86292735","dot_number":"179862","report_state":"IL","report_number":"0130000037","insp_date":"2025-11-05 00:00:00","insp_start_time":"1153","insp_end_time":"1259","registration_date":null,"region":"CS","ci_status_code":"C","location":"IDOT32","location_desc":"LITCHFIELD IL","county_code_state":"IL","county_code":"135","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OCCIDENTAL CHEMICAL CORPORATION","shipping_paper_number":"6400060688","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"145000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2528297","transaction_code":"A","transaction_date":"2025-11-11 00:00:00","upload_date":"2025-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-11-12 21:40:00","snet_input_date":"2025-11-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-12 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-15T10:30:32.000000Z","updated_at":"2025-11-16T10:30:20.000000Z","inspection_violations":[{"id":16893433,"change_date":"2025-11-12 21:40:00","inspection_id":"86292735","insp_violation_id":"269875335","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"209962756","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-15T10:30:47.000000Z","updated_at":"2025-11-16T10:30:41.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":16941514,"change_date":"2025-11-12 21:40:00","inspection_id":"86292735","insp_unit_id":"209962755","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:29.000000Z","updated_at":"2025-11-16T10:00:23.000000Z"},{"id":16941515,"change_date":"2025-11-12 21:40:00","inspection_id":"86292735","insp_unit_id":"209962756","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"401081","insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-15T10:00:29.000000Z","updated_at":"2025-11-16T10:00:23.000000Z"}]},{"id":10053760,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","dot_number":"179862","report_state":"IN","report_number":"7257006456","insp_date":"2025-10-27 00:00:00","insp_start_time":"1215","insp_end_time":"1419","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HUNTINGTON IN","county_code_state":"IN","county_code":"069","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND","shipping_paper_number":"483229","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","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":"2469577","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-10-28 21:39:00","snet_input_date":"2025-10-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-28 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-01T10:01:54.000000Z","updated_at":"2025-11-01T10:01:54.000000Z","inspection_violations":[{"id":16641968,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","insp_violation_id":"269562140","seq_no":"1","part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"209692091","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:17:56.000000Z","updated_at":"2025-11-01T10:16:11.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":16641969,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","insp_violation_id":"269562141","seq_no":"2","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:17:56.000000Z","updated_at":"2025-11-01T10:16:11.000000Z","normalized_code":"39524"},{"id":16641970,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","insp_violation_id":"269562142","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"209692091","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:17:56.000000Z","updated_at":"2025-11-01T10:16:11.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":16707780,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","insp_unit_id":"209692091","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"756662","insp_unit_license":"3715939","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG0SSVM3513","insp_unit_decal":"Y","insp_unit_decal_number":"35823705","created_at":"2025-10-31T09:47:07.000000Z","updated_at":"2025-11-01T09:45:48.000000Z"},{"id":16707781,"change_date":"2025-10-28 21:39:00","inspection_id":"86166702","insp_unit_id":"209692092","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"200594","insp_unit_license":"PG77208","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"Y","insp_unit_decal_number":"35823706","created_at":"2025-10-31T09:47:07.000000Z","updated_at":"2025-11-01T09:45:48.000000Z"}]},{"id":9888813,"change_date":"2025-10-08 21:40:00","inspection_id":"85992704","dot_number":"179862","report_state":"MI","report_number":"POWED05471","insp_date":"2025-10-07 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"JAMES NATIONAL","shipping_paper_number":"481834","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245214","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-10-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:49.000000Z","updated_at":"2025-10-12T10:01:07.000000Z","inspection_violations":[{"id":16305157,"change_date":"2025-10-08 21:40:00","inspection_id":"85992704","insp_violation_id":"269179003","seq_no":"1","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"2","insp_unit_id":"209366095","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:07.000000Z","updated_at":"2025-10-12T10:16:23.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":16407345,"change_date":"2025-10-08 21:40:00","inspection_id":"85992704","insp_unit_id":"209366094","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:27.000000Z"},{"id":16407346,"change_date":"2025-10-08 21:40:00","inspection_id":"85992704","insp_unit_id":"209366095","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"PF31727","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:14.000000Z","updated_at":"2025-10-12T09:46:27.000000Z"}]},{"id":9704260,"change_date":"2025-09-17 21:40:00","inspection_id":"85799074","dot_number":"179862","report_state":"US","report_number":"1992000015","insp_date":"2025-09-17 00:00:00","insp_start_time":"1246","insp_end_time":"1323","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LASALLE MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"267477","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53087","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":"2289506","transaction_code":"A","transaction_date":"2025-09-17 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-09-17 21:40:00","snet_input_date":"2025-09-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:43.000000Z","updated_at":"2025-09-23T10:01:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16065462,"change_date":"2025-09-17 21:40:00","inspection_id":"85799074","insp_unit_id":"208996577","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORETRAVEL","insp_unit_company":null,"insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:47.000000Z","updated_at":"2025-09-21T09:45:23.000000Z"},{"id":16065463,"change_date":"2025-09-17 21:40:00","inspection_id":"85799074","insp_unit_id":"208996578","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"PG25116","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:47.000000Z","updated_at":"2025-09-21T09:45:23.000000Z"}]},{"id":9634031,"change_date":"2025-09-10 21:40:00","inspection_id":"85725241","dot_number":"179862","report_state":"MI","report_number":"AKERT00620","insp_date":"2025-09-09 00:00:00","insp_start_time":"1155","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCKFORD REST AREA","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"155172","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1240324","transaction_code":"C","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-09 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:47:13.000000Z","updated_at":"2025-09-13T10:47:31.000000Z","inspection_violations":[{"id":15776995,"change_date":"2025-09-10 21:40:00","inspection_id":"85725241","insp_violation_id":"268584409","seq_no":"1","part_no":"172","part_no_section":"332C-HMM","insp_viol_unit":"2","insp_unit_id":"208853683","insp_violation_category_id":"33","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-13T10:50:27.000000Z","updated_at":"2025-09-14T11:55:21.000000Z","normalized_code":"172332CHMM"}],"inspection_per_units":[{"id":15926895,"change_date":"2025-09-10 21:40:00","inspection_id":"85725241","insp_unit_id":"208853682","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:16.000000Z","updated_at":"2025-09-13T10:00:16.000000Z"},{"id":15926896,"change_date":"2025-09-10 21:40:00","inspection_id":"85725241","insp_unit_id":"208853683","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"E080388","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M5931460L1192210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:16.000000Z","updated_at":"2025-09-13T10:00:16.000000Z"}]},{"id":9583878,"change_date":"2025-09-03 21:40:00","inspection_id":"85672692","dot_number":"179862","report_state":"MI","report_number":"EVANT03037","insp_date":"2025-09-02 00:00:00","insp_start_time":"1105","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 NEAR MANGLOS RD","county_code_state":"MI","county_code":"009","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1239018","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-02 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:43:30.000000Z","updated_at":"2025-09-10T10:44:56.000000Z","inspection_violations":[{"id":15655664,"change_date":"2025-09-03 21:40:00","inspection_id":"85672692","insp_violation_id":"268436200","seq_no":"1","part_no":"172","part_no_section":"506A-HMPMC","insp_viol_unit":"2","insp_unit_id":"208730501","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:11.000000Z","updated_at":"2025-09-06T10:48:11.000000Z","normalized_code":"172506AHMPMC"}],"inspection_per_units":[{"id":15821824,"change_date":"2025-09-03 21:40:00","inspection_id":"85672692","insp_unit_id":"208730500","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"599915","insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"},{"id":15821825,"change_date":"2025-09-03 21:40:00","inspection_id":"85672692","insp_unit_id":"208730501","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"481001","insp_unit_license":"D768355","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V482C9JT451001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:36.000000Z","updated_at":"2025-09-09T09:47:36.000000Z"}]},{"id":9189357,"change_date":"2025-07-18 21:40:00","inspection_id":"85257877","dot_number":"179862","report_state":"MI","report_number":"BARTC02929","insp_date":"2025-07-18 00:00:00","insp_start_time":"0835","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 @ 50 RD","county_code_state":"MI","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TRULY FREE INC","shipping_paper_number":"475414","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-18 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":"1231322","transaction_code":"A","transaction_date":"2025-07-18 00:00:00","upload_date":"2025-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-07-18 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-18 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:36.000000Z","updated_at":"2025-07-22T10:45:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15102229,"change_date":"2025-07-18 21:40:00","inspection_id":"85257877","insp_unit_id":"207953807","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878588","insp_unit_license":"2868797","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFGXKSLH7737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:37.000000Z","updated_at":"2025-07-22T09:45:56.000000Z"},{"id":15102230,"change_date":"2025-07-18 21:40:00","inspection_id":"85257877","insp_unit_id":"207953808","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"PG77208","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-21T09:46:37.000000Z","updated_at":"2025-07-22T09:45:56.000000Z"}]},{"id":8910796,"change_date":"2025-06-16 21:39:00","inspection_id":"84964365","dot_number":"179862","report_state":"MI","report_number":"DAWDD04006","insp_date":"2025-06-13 00:00:00","insp_start_time":"1420","insp_end_time":"1450","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 AT MERRIMAN","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"14500","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1225705","transaction_code":"A","transaction_date":"2025-06-13 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:24.000000Z","updated_at":"2025-06-20T10:00:29.000000Z","inspection_violations":[{"id":14288514,"change_date":"2025-06-16 21:39:00","inspection_id":"84964365","insp_violation_id":"266867346","seq_no":"1","part_no":"392","part_no_section":"2-SLLFC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:34.000000Z","updated_at":"2025-06-20T10:15:52.000000Z","normalized_code":"3922SLLFC"}],"inspection_per_units":[{"id":14599850,"change_date":"2025-06-16 21:39:00","inspection_id":"84964365","insp_unit_id":"207408402","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"590502","insp_unit_license":"3351063","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB4844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:38.000000Z"},{"id":14599851,"change_date":"2025-06-16 21:39:00","inspection_id":"84964365","insp_unit_id":"207408403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200596","insp_unit_license":"P912782","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2486L3963906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:22.000000Z","updated_at":"2025-06-20T09:45:38.000000Z"}]},{"id":8831605,"change_date":"2025-06-06 21:39:00","inspection_id":"84880152","dot_number":"179862","report_state":"OH","report_number":"3204000143","insp_date":"2025-06-04 00:00:00","insp_start_time":"0925","insp_end_time":"0942","registration_date":null,"region":"ED","ci_status_code":"C","location":"7501","location_desc":"MONROE OH","county_code_state":"OH","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND POOL AND SPA PRODUCTS","shipping_paper_number":"464617","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-06 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":"1828460","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-06-06 21:39:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-06 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:11.000000Z","updated_at":"2025-06-10T10:00:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14459417,"change_date":"2025-06-06 21:39:00","inspection_id":"84880152","insp_unit_id":"207254424","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:12.000000Z","updated_at":"2025-06-10T09:45:07.000000Z"},{"id":14459418,"change_date":"2025-06-06 21:39:00","inspection_id":"84880152","insp_unit_id":"207254425","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"401081","insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:12.000000Z","updated_at":"2025-06-10T09:45:07.000000Z"}]},{"id":8632061,"change_date":"2025-05-14 21:42:00","inspection_id":"84669209","dot_number":"179862","report_state":"MI","report_number":"KLEIN03808","insp_date":"2025-05-12 00:00:00","insp_start_time":"1010","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 131 AT SOUTH ST","county_code_state":"MI","county_code":"077","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SA CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1221050","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:19.000000Z","updated_at":"2025-05-18T10:06:07.000000Z","inspection_violations":[{"id":13726936,"change_date":"2025-05-14 21:42:00","inspection_id":"84669209","insp_violation_id":"266220798","seq_no":"1","part_no":"392","part_no_section":"11-RRC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4527621","created_at":"2025-05-18T10:27:10.000000Z","updated_at":"2025-05-18T10:33:40.000000Z","normalized_code":"39211RRC"}],"inspection_per_units":[{"id":14095355,"change_date":"2025-05-14 21:42:00","inspection_id":"84669209","insp_unit_id":"206857354","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3566055","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG5RSUP3534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:42.000000Z"},{"id":14095356,"change_date":"2025-05-14 21:42:00","inspection_id":"84669209","insp_unit_id":"206857355","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:42.000000Z"}]},{"id":8607229,"change_date":"2025-05-12 21:40:00","inspection_id":"84643189","dot_number":"179862","report_state":"MI","report_number":"KOCHJ01968","insp_date":"2025-05-08 00:00:00","insp_start_time":"1325","insp_end_time":"1355","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-75  DODGE RD","county_code_state":"MI","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"71052","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-12 21:40: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":"1220778","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:14.000000Z","updated_at":"2025-05-17T10:05:50.000000Z","inspection_violations":[{"id":13676566,"change_date":"2025-05-12 21:40:00","inspection_id":"84643189","insp_violation_id":"266165237","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":"2025-05-15T10:21:15.000000Z","updated_at":"2025-05-16T10:27:31.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":14051003,"change_date":"2025-05-12 21:40:00","inspection_id":"84643189","insp_unit_id":"206810074","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200597","insp_unit_license":"PG5116","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:18.000000Z","updated_at":"2025-05-16T09:51:10.000000Z"},{"id":14051002,"change_date":"2025-05-12 21:40:00","inspection_id":"84643189","insp_unit_id":"206810073","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"59915","insp_unit_license":"340735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:18.000000Z","updated_at":"2025-05-16T09:51:10.000000Z"}]},{"id":8359229,"change_date":"2025-04-12 21:33:00","inspection_id":"84381838","dot_number":"179862","report_state":"OH","report_number":"3288000572","insp_date":"2025-04-10 00:00:00","insp_start_time":"1135","insp_end_time":"1215","registration_date":null,"region":"ED","ci_status_code":"C","location":"05","location_desc":"HARRISON OH","county_code_state":"OH","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"BALECO INTERNATIONAL","shipping_paper_number":"466775","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-12 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1584451","transaction_code":"A","transaction_date":"2025-04-12 00:00:00","upload_date":"2025-04-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-04-12 21:33:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-12 21:33:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-15T10:14:24.000000Z","updated_at":"2025-04-16T10:00:53.000000Z","inspection_violations":[{"id":13168557,"change_date":"2025-04-12 21:33:00","inspection_id":"84381838","insp_violation_id":"265583782","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206279900","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-15T10:37:58.000000Z","updated_at":"2025-04-16T10:21:21.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":13563591,"change_date":"2025-04-12 21:33:00","inspection_id":"84381838","insp_unit_id":"206279900","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-15T10:07:07.000000Z","updated_at":"2025-04-16T09:51:50.000000Z"},{"id":13563592,"change_date":"2025-04-12 21:33:00","inspection_id":"84381838","insp_unit_id":"206279901","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"401081","insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-15T10:07:07.000000Z","updated_at":"2025-04-16T09:51:50.000000Z"}]},{"id":7986410,"change_date":"2025-02-28 21:40:00","inspection_id":"83989415","dot_number":"179862","report_state":"US","report_number":"1997000047","insp_date":"2025-02-27 00:00:00","insp_start_time":"1315","insp_end_time":"1345","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"CLARKSTON MI","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"263572","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-28 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":"1409852","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2025-02-28 21:40:00","snet_input_date":"2025-02-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-28 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:04.000000Z","updated_at":"2025-03-17T21:04:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12893013,"change_date":"2025-02-28 21:40:00","inspection_id":"83989415","insp_unit_id":"205549898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599911","insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"},{"id":12893014,"change_date":"2025-02-28 21:40:00","inspection_id":"83989415","insp_unit_id":"205549899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"NONE","insp_unit_license":"PG25116","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:24.000000Z","updated_at":"2025-03-17T23:57:24.000000Z"}]},{"id":7931369,"change_date":"2025-02-21 21:40:00","inspection_id":"83931764","dot_number":"179862","report_state":"MI","report_number":"MYERD01265","insp_date":"2025-02-21 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 EB @ 94 MM","county_code_state":"MI","county_code":"045","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"462942","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"155171","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":"1210823","transaction_code":"A","transaction_date":"2025-02-21 00:00:00","upload_date":"2025-02-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-21 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-21 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:51.000000Z","updated_at":"2025-03-17T21:02:51.000000Z","inspection_violations":[{"id":12390720,"change_date":"2025-02-21 21:40:00","inspection_id":"83931764","insp_violation_id":"264636483","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:31.000000Z","updated_at":"2025-03-17T22:06:31.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12803224,"change_date":"2025-02-21 21:40:00","inspection_id":"83931764","insp_unit_id":"205443079","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:26.000000Z","updated_at":"2025-03-17T23:56:26.000000Z"},{"id":12803225,"change_date":"2025-02-21 21:40:00","inspection_id":"83931764","insp_unit_id":"205443080","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"4832","insp_unit_license":"E080389","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M5931462L1192211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:26.000000Z","updated_at":"2025-03-17T23:56:26.000000Z"}]},{"id":7739404,"change_date":"2025-01-29 21:41:00","inspection_id":"83729988","dot_number":"179862","report_state":"MI","report_number":"NESBA01874","insp_date":"2025-01-24 00:00:00","insp_start_time":"1230","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W M-59@CROOKS RD","county_code_state":"MI","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CONNECTION CHEMICAL","shipping_paper_number":"92237","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1207650","transaction_code":"A","transaction_date":"2025-01-24 00:00:00","upload_date":"2025-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-01-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-01-29 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:58:46.000000Z","updated_at":"2025-03-17T20:58:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12489452,"change_date":"2025-01-29 21:41:00","inspection_id":"83729988","insp_unit_id":"205065500","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"590502","insp_unit_license":"3351063","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB4844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"},{"id":12489453,"change_date":"2025-01-29 21:41:00","inspection_id":"83729988","insp_unit_id":"205065501","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200592","insp_unit_license":"P912778","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3963902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:52:46.000000Z","updated_at":"2025-03-17T23:52:46.000000Z"}]},{"id":7481746,"change_date":"2024-12-23 21:38:00","inspection_id":"83459649","dot_number":"179862","report_state":"IN","report_number":"9288006028","insp_date":"2024-12-19 00:00:00","insp_start_time":"1058","insp_end_time":"1130","registration_date":null,"region":"CS","ci_status_code":"C","location":"1394E","location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"GLOBAL CHEMICAL RESOURCES","shipping_paper_number":"240228","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-23 21:38: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":"1185672","transaction_code":"A","transaction_date":"2024-12-23 00:00:00","upload_date":"2024-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2024-12-23 21:38:00","snet_input_date":"2024-12-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-23 21:38:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:17.000000Z","updated_at":"2025-03-17T20:52:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12070272,"change_date":"2024-12-23 21:38:00","inspection_id":"83459649","insp_unit_id":"204521736","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599909","insp_unit_license":"3420200","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:18.000000Z","updated_at":"2025-03-17T23:48:18.000000Z"},{"id":12070273,"change_date":"2024-12-23 21:38:00","inspection_id":"83459649","insp_unit_id":"204521737","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"200591","insp_unit_license":"P912784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2487L3963901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:18.000000Z","updated_at":"2025-03-17T23:48:18.000000Z"}]},{"id":7143470,"change_date":"2024-11-07 21:40:00","inspection_id":"83102945","dot_number":"179862","report_state":"US","report_number":"1713240050","insp_date":"2024-11-07 00:00:00","insp_start_time":"0931","insp_end_time":"1033","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MICHIGAN CITY IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CONNECTION CHEMICAL","shipping_paper_number":"245311","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-07 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":"1030764","transaction_code":"A","transaction_date":"2024-11-07 00:00:00","upload_date":"2024-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:05.000000Z","updated_at":"2025-03-17T20:45:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11521621,"change_date":"2024-11-07 21:40:00","inspection_id":"83102945","insp_unit_id":"203779933","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599909","insp_unit_license":"3420200","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8195","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:23.000000Z","updated_at":"2025-03-17T23:42:23.000000Z"},{"id":11521622,"change_date":"2024-11-07 21:40:00","inspection_id":"83102945","insp_unit_id":"203779934","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"200591","insp_unit_license":"P912784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2487L3963901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:23.000000Z","updated_at":"2025-03-17T23:42:23.000000Z"}]},{"id":7108165,"change_date":"2024-11-03 21:33:00","inspection_id":"83065655","dot_number":"179862","report_state":"OH","report_number":"0428000028","insp_date":"2024-10-31 00:00:00","insp_start_time":"0914","insp_end_time":"0947","registration_date":null,"region":"ED","ci_status_code":"C","location":"08","location_desc":"VAN WERT OH","county_code_state":"OH","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"58548","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-03 21:33: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":"1014701","transaction_code":"A","transaction_date":"2024-11-03 00:00:00","upload_date":"2024-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2024-11-03 21:33:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-03 21:33:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:16.000000Z","updated_at":"2025-03-17T20:44:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11464431,"change_date":"2024-11-03 21:33:00","inspection_id":"83065655","insp_unit_id":"203709642","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599915","insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"},{"id":11464432,"change_date":"2024-11-03 21:33:00","inspection_id":"83065655","insp_unit_id":"203709643","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"401081","insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"}]},{"id":7038812,"change_date":"2024-10-24 21:41:00","inspection_id":"82992040","dot_number":"179862","report_state":"MI","report_number":"HINCA00517","insp_date":"2024-10-22 00:00:00","insp_start_time":"1000","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"W\/B M-32 @ DEVERE DR","county_code_state":"MI","county_code":"007","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ALPENA SUPPLY","shipping_paper_number":"453841","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-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":"1199217","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11352081,"change_date":"2024-10-24 21:41:00","inspection_id":"82992040","insp_unit_id":"203573783","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"599910","insp_unit_license":"3401319","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"},{"id":11352082,"change_date":"2024-10-24 21:41:00","inspection_id":"82992040","insp_unit_id":"203573784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6923575,"change_date":"2024-10-09 21:42:00","inspection_id":"82869548","dot_number":"179862","report_state":"MI","report_number":"HINCA00508","insp_date":"2024-10-08 00:00:00","insp_start_time":"1430","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"S\/B US-131 @ PHELPS RD","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MAGNUM SOLVENT INC","shipping_paper_number":"58278","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-09 21:42: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":"1197628","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:36.000000Z","updated_at":"2025-03-17T20:40:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11166210,"change_date":"2024-10-09 21:42:00","inspection_id":"82869548","insp_unit_id":"203339287","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599910","insp_unit_license":"3401319","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"},{"id":11166211,"change_date":"2024-10-09 21:42:00","inspection_id":"82869548","insp_unit_id":"203339288","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200131","insp_unit_license":"P912789","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3964001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6852951,"change_date":"2024-09-30 21:41:00","inspection_id":"82794476","dot_number":"179862","report_state":"MI","report_number":"ARCHH01177","insp_date":"2024-09-26 00:00:00","insp_start_time":"1120","insp_end_time":"1141","registration_date":null,"region":"ET","ci_status_code":"C","location":"0","location_desc":"M55@I27","county_code_state":"MI","county_code":"143","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-30 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":"1196416","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-26 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-30 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:01.000000Z","updated_at":"2025-03-17T20:39:01.000000Z","inspection_violations":[{"id":10673467,"change_date":"2024-09-30 21:41:00","inspection_id":"82794476","insp_violation_id":"262103760","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:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11051333,"change_date":"2024-09-30 21:41:00","inspection_id":"82794476","insp_unit_id":"203194583","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"756662","insp_unit_license":"3715939","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG0SSVM3513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"},{"id":11051334,"change_date":"2024-09-30 21:41:00","inspection_id":"82794476","insp_unit_id":"203194584","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200594","insp_unit_license":"P912780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:27.000000Z","updated_at":"2025-03-17T23:37:27.000000Z"}]},{"id":6766055,"change_date":"2024-09-19 21:41:00","inspection_id":"82701875","dot_number":"179862","report_state":"US","report_number":"1985000016","insp_date":"2024-09-18 00:00:00","insp_start_time":"0858","insp_end_time":"0930","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PORTLAND MI","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MSU COOLING TOWER","shipping_paper_number":"451126","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-19 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":"863773","transaction_code":"A","transaction_date":"2024-09-19 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2024-09-19 21:41:00","snet_input_date":"2024-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-19 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:19.000000Z","updated_at":"2025-03-17T20:37:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10910655,"change_date":"2024-09-19 21:41:00","inspection_id":"82701875","insp_unit_id":"203022484","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"878386","insp_unit_license":"2816468","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG0KSLH8606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:02.000000Z","updated_at":"2025-03-17T23:36:02.000000Z"},{"id":10910656,"change_date":"2024-09-19 21:41:00","inspection_id":"82701875","insp_unit_id":"203022485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"179","insp_unit_license":"E880961","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"10BAAB237RF441753","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:02.000000Z","updated_at":"2025-03-17T23:36:02.000000Z"}]},{"id":6758312,"change_date":"2024-09-18 21:42:00","inspection_id":"82693572","dot_number":"179862","report_state":"IL","report_number":"3998331719","insp_date":"2024-09-17 00:00:00","insp_start_time":"0801","insp_end_time":"0847","registration_date":null,"region":"CT","ci_status_code":"C","location":"015","location_desc":"015 - PEOTONE - I-57 N\/B","county_code_state":"IL","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ACUITY","shipping_paper_number":"264226","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-18 21:42: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":"2357112","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:59.000000Z","updated_at":"2025-03-17T20:36:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10898000,"change_date":"2024-09-18 21:42:00","inspection_id":"82693572","insp_unit_id":"203006914","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599913","insp_unit_license":"3401322","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFGXPDUB8199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:51.000000Z","updated_at":"2025-03-17T23:35:51.000000Z"},{"id":10898001,"change_date":"2024-09-18 21:42:00","inspection_id":"82693572","insp_unit_id":"203006915","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILIMASTE","insp_unit_company":"731971","insp_unit_license":"PF30964","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2485S7302701","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:51.000000Z","updated_at":"2025-03-17T23:35:51.000000Z"}]},{"id":6250088,"change_date":"2024-09-17 21:45:00","inspection_id":"82151558","dot_number":"179862","report_state":"MI","report_number":"BRADD01205","insp_date":"2024-07-16 00:00:00","insp_start_time":"1640","insp_end_time":"1735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"POST ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND","shipping_paper_number":"8756","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1186517","transaction_code":"C","transaction_date":"2024-07-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-07-18 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:37.000000Z","updated_at":"2025-03-17T20:26:37.000000Z","inspection_violations":[{"id":9709979,"change_date":"2024-09-17 21:45:00","inspection_id":"82151558","insp_violation_id":"261859717","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:59.000000Z","updated_at":"2025-03-17T21:52:59.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10070489,"change_date":"2024-09-17 21:45:00","inspection_id":"82151558","insp_unit_id":"202975904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"756662","insp_unit_license":"3715939","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG0SSVM3513","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"},{"id":10070490,"change_date":"2024-09-17 21:45:00","inspection_id":"82151558","insp_unit_id":"202975905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"481001","insp_unit_license":"D768355","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V482C9JT451001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:22.000000Z","updated_at":"2025-03-17T23:27:22.000000Z"}]},{"id":5951471,"change_date":"2024-06-10 21:43:00","inspection_id":"81829736","dot_number":"179862","report_state":"OH","report_number":"0428000429","insp_date":"2024-06-10 00:00:00","insp_start_time":"1054","insp_end_time":"1137","registration_date":null,"region":"ET","ci_status_code":"C","location":"161224","location_desc":"ROADSIDE - SCALES","county_code_state":"OH","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"442290","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1732463","transaction_code":"A","transaction_date":"2024-06-10 00:00:00","upload_date":"2024-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-10 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-10 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:41.000000Z","updated_at":"2025-03-17T20:20:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9586234,"change_date":"2024-06-10 21:43:00","inspection_id":"81829736","insp_unit_id":"201313384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599915","insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"},{"id":9586235,"change_date":"2024-06-10 21:43:00","inspection_id":"81829736","insp_unit_id":"201313385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"731973","insp_unit_license":"PF30966","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489S7302703","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:24.000000Z","updated_at":"2025-03-17T23:22:24.000000Z"}]},{"id":5623686,"change_date":"2024-04-29 21:43:00","inspection_id":"81473961","dot_number":"179862","report_state":"MI","report_number":"LANES03521","insp_date":"2024-04-29 00:00:00","insp_start_time":"0720","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-69@35MM","county_code_state":"MI","county_code":"025","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/A CARRIER","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1176179","transaction_code":"A","transaction_date":"2024-04-29 00:00:00","upload_date":"2024-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-29 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:14:16.000000Z","updated_at":"2025-03-17T20:14:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9058885,"change_date":"2024-04-29 21:43:00","inspection_id":"81473961","insp_unit_id":"200631939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:17.000000Z","updated_at":"2025-03-17T23:17:17.000000Z"},{"id":9058886,"change_date":"2024-04-29 21:43:00","inspection_id":"81473961","insp_unit_id":"200631940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:17.000000Z","updated_at":"2025-03-17T23:17:17.000000Z"}]},{"id":5576193,"change_date":"2024-04-23 21:41:00","inspection_id":"81422016","dot_number":"179862","report_state":"MI","report_number":"ROLLJ02445","insp_date":"2024-04-23 00:00:00","insp_start_time":"1000","insp_end_time":"1038","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB US131 @ CROFTON RD","county_code_state":"MI","county_code":"079","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"1007648","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1175225","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[{"id":8618473,"change_date":"2024-04-23 21:41:00","inspection_id":"81422016","insp_violation_id":"259082983","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":"X4362775","created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8982266,"change_date":"2024-04-23 21:41:00","inspection_id":"81422016","insp_unit_id":"200530811","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8982267,"change_date":"2024-04-23 21:41:00","inspection_id":"81422016","insp_unit_id":"200530812","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":5215250,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","dot_number":"179862","report_state":"MI","report_number":"OWENP01249","insp_date":"2024-03-04 00:00:00","insp_start_time":"1526","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 NB @ 36TH ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"255246","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1167668","transaction_code":"A","transaction_date":"2024-03-04 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:47.000000Z","updated_at":"2025-03-17T20:05:47.000000Z","inspection_violations":[{"id":8036709,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_violation_id":"258208610","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199762118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3939A"},{"id":8036710,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_violation_id":"258208611","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199762118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3939A"},{"id":8036711,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_violation_id":"258208612","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199762118","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3939A"},{"id":8036712,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_violation_id":"258208613","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"199762118","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:49.000000Z","updated_at":"2025-03-17T21:44:49.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8397686,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_unit_id":"199762117","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"681790","insp_unit_license":"2657054","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG6JLJK0847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:05.000000Z","updated_at":"2025-03-17T23:11:05.000000Z"},{"id":8397687,"change_date":"2024-03-05 21:41:00","inspection_id":"81027971","insp_unit_id":"199762118","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200594","insp_unit_license":"P912780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:05.000000Z","updated_at":"2025-03-17T23:11:05.000000Z"}]},{"id":5240952,"change_date":"2024-03-08 21:39:00","inspection_id":"81056271","dot_number":"179862","report_state":"US","report_number":"1538000260","insp_date":"2024-02-15 00:00:00","insp_start_time":"1234","insp_end_time":"1341","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MICHIGAN CITY IN","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"ROWELL CHEMICAL CORP","shipping_paper_number":"1401263","cargo_tank":"SPE","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-03-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"300410","transaction_code":"A","transaction_date":"2024-03-07 00:00:00","upload_date":"2024-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2024-03-08 21:39:00","snet_input_date":"2024-02-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-08 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:38.000000Z","updated_at":"2025-03-17T20:06:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8439351,"change_date":"2024-03-08 21:39:00","inspection_id":"81056271","insp_unit_id":"199817427","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"400950","insp_unit_license":"3401290","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUC8194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"},{"id":8439352,"change_date":"2024-03-08 21:39:00","inspection_id":"81056271","insp_unit_id":"199817428","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TREASURE C","insp_unit_company":"H176","insp_unit_license":"D803417","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLSL4222HB000375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:27.000000Z","updated_at":"2025-03-17T23:11:27.000000Z"}]},{"id":5089388,"change_date":"2024-02-20 21:42:00","inspection_id":"80891099","dot_number":"179862","report_state":"MI","report_number":"BRADD01081","insp_date":"2024-02-15 00:00:00","insp_start_time":"1935","insp_end_time":"2020","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"76TH ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND POOL AND SPA","shipping_paper_number":"55624","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:42: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":"1165403","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8193483,"change_date":"2024-02-20 21:42:00","inspection_id":"80891099","insp_unit_id":"199502067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193484,"change_date":"2024-02-20 21:42:00","inspection_id":"80891099","insp_unit_id":"199502068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"401081","insp_unit_license":"PC95553","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2539R7998301","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":4774589,"change_date":"2024-01-05 21:46:00","inspection_id":"80546717","dot_number":"179862","report_state":"MI","report_number":"PARLM02268","insp_date":"2024-01-04 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EAST PARIS AVE & 68TH","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIED FINISHING","shipping_paper_number":"255306","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-05 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1159431","transaction_code":"A","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-01-05 21:46:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:17.000000Z","updated_at":"2025-03-17T19:57:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7681038,"change_date":"2024-01-05 21:46:00","inspection_id":"80546717","insp_unit_id":"198838380","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"485075","insp_unit_license":"D014411","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C1ET075075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"},{"id":7681039,"change_date":"2024-01-05 21:46:00","inspection_id":"80546717","insp_unit_id":"198838381","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599912","insp_unit_license":"3401321","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG8PDUB8198","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:40.000000Z","updated_at":"2025-03-17T23:04:40.000000Z"}]},{"id":4648953,"change_date":"2023-12-18 21:41:00","inspection_id":"80409526","dot_number":"179862","report_state":"IN","report_number":"8843004396","insp_date":"2023-12-18 00:00:00","insp_start_time":"0856","insp_end_time":"1045","registration_date":null,"region":"CS","ci_status_code":"C","location":"1365S","location_desc":"LOWELL IN","county_code_state":"IN","county_code":"089","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND PRODUCTS CO","shipping_paper_number":"427479","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-12-18 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":"135944","transaction_code":"A","transaction_date":"2023-12-18 00:00:00","upload_date":"2023-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":"2023-12-18 21:41:00","snet_input_date":"2023-12-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-12-18 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:57.000000Z","updated_at":"2025-03-17T19:54:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7477024,"change_date":"2023-12-18 21:41:00","inspection_id":"80409526","insp_unit_id":"198544657","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:51.000000Z","updated_at":"2025-03-17T23:02:51.000000Z"},{"id":7477025,"change_date":"2023-12-18 21:41:00","inspection_id":"80409526","insp_unit_id":"198544658","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:51.000000Z","updated_at":"2025-03-17T23:02:51.000000Z"}]},{"id":4590375,"change_date":"2023-12-08 21:41:00","inspection_id":"80345331","dot_number":"179862","report_state":"MI","report_number":"FRIZS02891","insp_date":"2023-12-07 00:00:00","insp_start_time":"1457","insp_end_time":"1523","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-131 S\/B @ LAKE MONTCALM","county_code_state":"MI","county_code":"117","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MICHIGAN SUGAR","shipping_paper_number":"256923","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-08 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":"1156611","transaction_code":"A","transaction_date":"2023-12-07 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:47.000000Z","updated_at":"2025-03-17T19:53:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7383079,"change_date":"2023-12-08 21:41:00","inspection_id":"80345331","insp_unit_id":"198421719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599911","insp_unit_license":"3401320","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"},{"id":7383080,"change_date":"2023-12-08 21:41:00","inspection_id":"80345331","insp_unit_id":"198421720","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200597","insp_unit_license":"P912783","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2533L2041408","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:03.000000Z","updated_at":"2025-03-17T23:02:03.000000Z"}]},{"id":4570271,"change_date":"2023-12-06 21:42:00","inspection_id":"80323244","dot_number":"179862","report_state":"MI","report_number":"KILYJ01988","insp_date":"2023-12-05 00:00:00","insp_start_time":"1100","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SA CARRIER","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-06 21:42: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":"1156082","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-06 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:24.000000Z","updated_at":"2025-03-17T19:53:24.000000Z","inspection_violations":[{"id":7069096,"change_date":"2023-12-06 21:42:00","inspection_id":"80323244","insp_violation_id":"256743369","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:09.000000Z","updated_at":"2025-03-17T21:40:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7350639,"change_date":"2023-12-06 21:42:00","inspection_id":"80323244","insp_unit_id":"198376061","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3566055","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG5RSUP3534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"},{"id":7350640,"change_date":"2023-12-06 21:42:00","inspection_id":"80323244","insp_unit_id":"198376062","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:47.000000Z","updated_at":"2025-03-17T23:01:47.000000Z"}]},{"id":4539024,"change_date":"2023-12-01 21:42:00","inspection_id":"80288895","dot_number":"179862","report_state":"MI","report_number":"WORDN04529","insp_date":"2023-11-30 00:00:00","insp_start_time":"1240","insp_end_time":"1320","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"MULTIPLE","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:42: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":"1155483","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7022681,"change_date":"2023-12-01 21:42:00","inspection_id":"80288895","insp_violation_id":"256667488","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4310580","created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7300187,"change_date":"2023-12-01 21:42:00","inspection_id":"80288895","insp_unit_id":"198308727","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"},{"id":7300188,"change_date":"2023-12-01 21:42:00","inspection_id":"80288895","insp_unit_id":"198308728","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"}]},{"id":4539118,"change_date":"2023-12-01 21:43:00","inspection_id":"80289001","dot_number":"179862","report_state":"MI","report_number":"MCCLC02518","insp_date":"2023-11-30 00:00:00","insp_start_time":"1330","insp_end_time":"1346","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"CHICKAMING TWS","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"MULTI","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-01 21:43: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":"1155465","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-12-01 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:38.000000Z","updated_at":"2025-03-17T19:52:38.000000Z","inspection_violations":[{"id":7022826,"change_date":"2023-12-01 21:43:00","inspection_id":"80289001","insp_violation_id":"256667704","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:53.000000Z","updated_at":"2025-03-17T21:39:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7300345,"change_date":"2023-12-01 21:43:00","inspection_id":"80289001","insp_unit_id":"198308909","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"},{"id":7300346,"change_date":"2023-12-01 21:43:00","inspection_id":"80289001","insp_unit_id":"198308910","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:20.000000Z","updated_at":"2025-03-17T23:01:20.000000Z"}]},{"id":4383901,"change_date":"2023-11-08 21:41:00","inspection_id":"80118162","dot_number":"179862","report_state":"MI","report_number":"LITTJ04690","insp_date":"2023-11-07 00:00:00","insp_start_time":"1045","insp_end_time":"1105","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALES","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"257093","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"1","hazmat_oos_total":"1","snet_sequence_id":"1152765","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-07 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:50.000000Z","updated_at":"2025-03-17T19:49:50.000000Z","inspection_violations":[{"id":6781821,"change_date":"2023-11-08 21:41:00","inspection_id":"80118162","insp_violation_id":"256291578","seq_no":"1","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"2","insp_unit_id":"197970638","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:38:40.000000Z","updated_at":"2025-03-17T21:38:40.000000Z","normalized_code":"172504A"}],"inspection_per_units":[{"id":7050388,"change_date":"2023-11-08 21:41:00","inspection_id":"80118162","insp_unit_id":"197970637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"599911","insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"},{"id":7050389,"change_date":"2023-11-08 21:41:00","inspection_id":"80118162","insp_unit_id":"197970638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200597","insp_unit_license":"P912783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:12.000000Z","updated_at":"2025-03-17T22:59:12.000000Z"}]},{"id":4248074,"change_date":"2023-10-20 21:40:00","inspection_id":"79967619","dot_number":"179862","report_state":"MI","report_number":"VANHJ03755","insp_date":"2023-10-19 00:00:00","insp_start_time":"1225","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND","shipping_paper_number":"257289","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1150392","transaction_code":"A","transaction_date":"2023-10-19 00:00:00","upload_date":"2023-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-20 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:03.000000Z","updated_at":"2025-03-17T19:47:03.000000Z","inspection_violations":[{"id":6577347,"change_date":"2023-10-20 21:40:00","inspection_id":"79967619","insp_violation_id":"255964148","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"197668701","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":6831633,"change_date":"2023-10-20 21:40:00","inspection_id":"79967619","insp_unit_id":"197668701","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":"599913","insp_unit_license":"3401322","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFGXPDUB8199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:16.000000Z","updated_at":"2025-03-17T22:57:16.000000Z"},{"id":6831634,"change_date":"2023-10-20 21:40:00","inspection_id":"79967619","insp_unit_id":"197668702","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:16.000000Z","updated_at":"2025-03-17T22:57:16.000000Z"}]},{"id":4261430,"change_date":"2023-10-23 21:42:00","inspection_id":"79982527","dot_number":"179862","report_state":"IL","report_number":"4069880551","insp_date":"2023-09-26 00:00:00","insp_start_time":"0647","insp_end_time":"0717","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57 NB","county_code_state":"IL","county_code":"197","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ACUITY","shipping_paper_number":"256232","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"2287662","transaction_code":"A","transaction_date":"2023-09-26 00:00:00","upload_date":"2023-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-26 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-23 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:24.000000Z","updated_at":"2025-03-17T19:47:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6853250,"change_date":"2023-10-23 21:42:00","inspection_id":"79982527","insp_unit_id":"197696742","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"481539","insp_unit_license":"3566055","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG5RSUP3534","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:27.000000Z","updated_at":"2025-03-17T22:57:27.000000Z"},{"id":6853251,"change_date":"2023-10-23 21:42:00","inspection_id":"79982527","insp_unit_id":"197696743","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:27.000000Z","updated_at":"2025-03-17T22:57:27.000000Z"}]},{"id":3925203,"change_date":"2023-09-07 21:41:00","inspection_id":"79609754","dot_number":"179862","report_state":"MI","report_number":"LULAN02019","insp_date":"2023-09-06 00:00:00","insp_start_time":"1050","insp_end_time":"1106","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I-94 2 RAWSONVILLE","county_code_state":"MI","county_code":"161","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1144613","transaction_code":"A","transaction_date":"2023-09-06 00:00:00","upload_date":"2023-09-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-09-07 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:26.000000Z","updated_at":"2025-03-17T19:40:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6311479,"change_date":"2023-09-07 21:41:00","inspection_id":"79609754","insp_unit_id":"196947245","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRTV","insp_unit_company":null,"insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:02.000000Z","updated_at":"2025-03-17T22:53:02.000000Z"},{"id":6311480,"change_date":"2023-09-07 21:41:00","inspection_id":"79609754","insp_unit_id":"196947246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:02.000000Z","updated_at":"2025-03-17T22:53:02.000000Z"}]},{"id":3858910,"change_date":"2023-08-29 21:42:00","inspection_id":"79535917","dot_number":"179862","report_state":"MI","report_number":"SILKS03702","insp_date":"2023-08-29 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"591","location_desc":"COLDWATER SCALE","county_code_state":"MI","county_code":"023","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1143301","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":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-29 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","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":[],"inspection_per_units":[{"id":6203960,"change_date":"2023-08-29 21:42:00","inspection_id":"79535917","insp_unit_id":"196789298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2868797","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFGXKSLH7737","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":6203961,"change_date":"2023-08-29 21:42:00","inspection_id":"79535917","insp_unit_id":"196789299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E580477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9ET075065","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":3812023,"change_date":"2023-08-30 21:45:00","inspection_id":"79483400","dot_number":"179862","report_state":"MI","report_number":"WALKB02572","insp_date":"2023-08-22 00:00:00","insp_start_time":"1600","insp_end_time":"1640","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I 94 @ MM 145","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"418191","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1141999","transaction_code":"C","transaction_date":"2023-08-22 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-08-23 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:05.000000Z","updated_at":"2025-03-17T19:38:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6129009,"change_date":"2023-08-30 21:45:00","inspection_id":"79483400","insp_unit_id":"196817802","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3401320","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUB8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"},{"id":6129010,"change_date":"2023-08-30 21:45:00","inspection_id":"79483400","insp_unit_id":"196817803","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:29.000000Z","updated_at":"2025-03-17T22:51:29.000000Z"}]},{"id":3632685,"change_date":"2023-08-29 21:42:00","inspection_id":"79283036","dot_number":"179862","report_state":"MI","report_number":"DAWDD02914","insp_date":"2023-07-28 00:00:00","insp_start_time":"1051","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB I-275 AT EUREKA","county_code_state":"MI","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND","shipping_paper_number":"53385","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1137746","transaction_code":"C","transaction_date":"2023-07-28 00:00:00","upload_date":"2023-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-31 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:35.000000Z","updated_at":"2025-03-17T19:34:35.000000Z","inspection_violations":[{"id":5600901,"change_date":"2023-08-29 21:42:00","inspection_id":"79283036","insp_violation_id":"254952770","seq_no":"1","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"2","insp_unit_id":"196788205","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:00.000000Z","updated_at":"2025-03-17T21:33:00.000000Z","normalized_code":"172504A"}],"inspection_per_units":[{"id":5840673,"change_date":"2023-08-29 21:42:00","inspection_id":"79283036","insp_unit_id":"196788204","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:08.000000Z","updated_at":"2025-03-17T22:49:08.000000Z"},{"id":5840674,"change_date":"2023-08-29 21:42:00","inspection_id":"79283036","insp_unit_id":"196788205","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:08.000000Z","updated_at":"2025-03-17T22:49:08.000000Z"}]},{"id":3342997,"change_date":"2023-06-22 21:42:00","inspection_id":"78957702","dot_number":"179862","report_state":"MI","report_number":"MALIK01807","insp_date":"2023-06-22 00:00:00","insp_start_time":"0805","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B M-59 @ M-53","county_code_state":"MI","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"52948","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1131781","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:19.000000Z","updated_at":"2025-03-17T19:29:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5374435,"change_date":"2023-06-22 21:42:00","inspection_id":"78957702","insp_unit_id":"195625816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"590502","insp_unit_license":"3351063","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB4844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"},{"id":5374436,"change_date":"2023-06-22 21:42:00","inspection_id":"78957702","insp_unit_id":"195625817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200592","insp_unit_license":"P912778","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3963902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:23.000000Z","updated_at":"2025-03-17T22:45:23.000000Z"}]},{"id":3000336,"change_date":"2023-05-09 21:42:00","inspection_id":"78571025","dot_number":"179862","report_state":"IN","report_number":"5267012395","insp_date":"2023-05-03 00:00:00","insp_start_time":"1129","insp_end_time":"1215","registration_date":null,"region":"ET","ci_status_code":"C","location":"2269S","location_desc":"#22  I-69  SB  HUNTINGTON","county_code_state":"IN","county_code":"069","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"52324","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-05-09 21:42: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":"2188092","transaction_code":"A","transaction_date":"2023-05-04 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-04 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-05-09 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:34.000000Z","updated_at":"2025-03-17T19:22:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4827266,"change_date":"2023-05-09 21:42:00","inspection_id":"78571025","insp_unit_id":"194828468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"},{"id":4827267,"change_date":"2023-05-09 21:42:00","inspection_id":"78571025","insp_unit_id":"194828469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:02.000000Z","updated_at":"2025-03-17T22:41:02.000000Z"}]},{"id":2800149,"change_date":"2023-04-13 21:43:00","inspection_id":"78344413","dot_number":"179862","report_state":"OH","report_number":"3205401960","insp_date":"2023-04-13 00:00:00","insp_start_time":"0902","insp_end_time":"1009","registration_date":null,"region":"ET","ci_status_code":"C","location":"16130","location_desc":"VAN WERT SCALES","county_code_state":"OH","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"52051","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1650310","transaction_code":"A","transaction_date":"2023-04-13 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-13 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:28.000000Z","updated_at":"2025-03-17T19:18:28.000000Z","inspection_violations":[{"id":4297377,"change_date":"2023-04-13 21:43:00","inspection_id":"78344413","insp_violation_id":"252212361","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"194376980","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:04.000000Z","updated_at":"2025-03-17T21:27:04.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":4506752,"change_date":"2023-04-13 21:43:00","inspection_id":"78344413","insp_unit_id":"194376979","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599915","insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"Y","insp_unit_decal_number":"32625717","created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"},{"id":4506753,"change_date":"2023-04-13 21:43:00","inspection_id":"78344413","insp_unit_id":"194376980","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2799391,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","dot_number":"179862","report_state":"MI","report_number":"OWENP01058","insp_date":"2023-04-12 00:00:00","insp_start_time":"1411","insp_end_time":"1457","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US131 NB @ 36TH ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"406107","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1121754","transaction_code":"A","transaction_date":"2023-04-12 00:00:00","upload_date":"2023-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-13 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:08.000000Z","updated_at":"2025-03-17T19:18:08.000000Z","inspection_violations":[{"id":4295979,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","insp_violation_id":"252210365","seq_no":"1","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"194375394","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39355E"},{"id":4295980,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","insp_violation_id":"252210366","seq_no":"2","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194375394","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"3929A"},{"id":4295981,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","insp_violation_id":"252210367","seq_no":"3","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"1","insp_unit_id":"194375393","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:03.000000Z","updated_at":"2025-03-17T21:27:03.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":4505481,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","insp_unit_id":"194375393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878588","insp_unit_license":"2868797","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFGXKSLH7737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"},{"id":4505482,"change_date":"2023-04-13 21:43:00","inspection_id":"78343522","insp_unit_id":"194375394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"487065","insp_unit_license":"E580477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9ET075065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:32.000000Z","updated_at":"2025-03-17T22:38:32.000000Z"}]},{"id":2767994,"change_date":"2023-04-11 12:04:00","inspection_id":"78308186","dot_number":"179862","report_state":"MI","report_number":"SCIBA02170","insp_date":"2023-04-10 00:00:00","insp_start_time":"0735","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"COLBY RD","county_code_state":"MI","county_code":"121","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:04:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1121256","transaction_code":"A","transaction_date":"2023-04-10 00:00:00","upload_date":"2023-04-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-04-10 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-04-11 12:04:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:40.000000Z","updated_at":"2025-03-17T19:17:40.000000Z","inspection_violations":[{"id":4247020,"change_date":"2023-04-11 12:04:00","inspection_id":"78308186","insp_violation_id":"252130373","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:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39216A"},{"id":4247021,"change_date":"2023-04-11 12:04:00","inspection_id":"78308186","insp_violation_id":"252130374","seq_no":"2","part_no":"393","part_no_section":"25(a)","insp_viol_unit":"2","insp_unit_id":"194305227","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:52.000000Z","updated_at":"2025-03-17T21:26:52.000000Z","normalized_code":"39325A"}],"inspection_per_units":[{"id":4455172,"change_date":"2023-04-11 12:04:00","inspection_id":"78308186","insp_unit_id":"194305226","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599914","insp_unit_license":"3401323","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"},{"id":4455173,"change_date":"2023-04-11 12:04:00","inspection_id":"78308186","insp_unit_id":"194305227","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:05.000000Z","updated_at":"2025-03-17T22:38:05.000000Z"}]},{"id":2369603,"change_date":"2023-02-14 21:41:00","inspection_id":"77854211","dot_number":"179862","report_state":"MI","report_number":"MOREM04630","insp_date":"2023-02-13 00:00:00","insp_start_time":"1108","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"DOW RD","county_code_state":"MI","county_code":"045","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-02-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1113803","transaction_code":"A","transaction_date":"2023-02-13 00:00:00","upload_date":"2023-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-02-14 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:20.000000Z","updated_at":"2025-03-17T19:10:20.000000Z","inspection_violations":[{"id":3648683,"change_date":"2023-02-14 21:41:00","inspection_id":"77854211","insp_violation_id":"251130512","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":"X4181120","created_at":"2025-03-17T21:24:13.000000Z","updated_at":"2025-03-17T21:24:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3813077,"change_date":"2023-02-14 21:41:00","inspection_id":"77854211","insp_unit_id":"193394869","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878386","insp_unit_license":"2816468","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG0KSLH8606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"},{"id":3813078,"change_date":"2023-02-14 21:41:00","inspection_id":"77854211","insp_unit_id":"193394870","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLR","insp_unit_company":"47 0069","insp_unit_license":"D579711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMS3432711024484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:18.000000Z","updated_at":"2025-03-17T22:33:18.000000Z"}]},{"id":2225834,"change_date":"2023-01-30 21:43:00","inspection_id":"77690525","dot_number":"179862","report_state":"IN","report_number":"8322004619","insp_date":"2023-01-25 00:00:00","insp_start_time":"0423","insp_end_time":"0454","registration_date":"2023-01-30 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"NB I-69 342","county_code_state":"IN","county_code":"151","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"243223","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2172550","transaction_code":"C","transaction_date":"2023-01-25 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-25 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:43.000000Z","updated_at":"2025-03-17T19:07:43.000000Z","inspection_violations":[{"id":3437403,"change_date":"2023-01-30 21:43:00","inspection_id":"77690525","insp_violation_id":"250843586","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:23:14.000000Z","updated_at":"2025-03-17T21:23:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3582405,"change_date":"2023-01-30 21:43:00","inspection_id":"77690525","insp_unit_id":"193127213","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"401153","insp_unit_license":"3401292","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG1PDUC8197","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"},{"id":3582406,"change_date":"2023-01-30 21:43:00","inspection_id":"77690525","insp_unit_id":"193127214","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANR","insp_unit_company":"39","insp_unit_license":"D889289","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VC532XHM708913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"}]},{"id":2105675,"change_date":"2023-01-10 21:40:00","inspection_id":"77552814","dot_number":"179862","report_state":"IN","report_number":"6900002308","insp_date":"2023-01-09 00:00:00","insp_start_time":"1005","insp_end_time":"1047","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US 30 AND 200 N.","county_code_state":"IN","county_code":"085","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PVA","shipping_paper_number":"398328","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2169525","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-10 00:00:00","source_office":"3INS001","mcmis_add_date":"2023-01-10 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:05:30.000000Z","updated_at":"2025-03-17T19:05:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3388441,"change_date":"2023-01-10 21:40:00","inspection_id":"77552814","insp_unit_id":"192786128","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"52000","insp_unit_license":"599914","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"},{"id":3388442,"change_date":"2023-01-10 21:40:00","inspection_id":"77552814","insp_unit_id":"192786129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"65000","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:16.000000Z","updated_at":"2025-03-17T22:30:16.000000Z"}]},{"id":2066054,"change_date":"2023-01-04 21:40:00","inspection_id":"77507350","dot_number":"179862","report_state":"MI","report_number":"KILYJ01723","insp_date":"2023-01-04 00:00:00","insp_start_time":"0930","insp_end_time":"1005","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND","shipping_paper_number":"1379487","cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"119000","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":"1107488","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-04 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:44.000000Z","updated_at":"2025-03-17T19:04:44.000000Z","inspection_violations":[{"id":3197737,"change_date":"2023-01-04 21:40:00","inspection_id":"77507350","insp_violation_id":"250381817","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:07.000000Z","updated_at":"2025-03-17T21:22:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3323843,"change_date":"2023-01-04 21:40:00","inspection_id":"77507350","insp_unit_id":"192695823","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878386","insp_unit_license":"2816468","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG0KSLH8606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:47.000000Z","updated_at":"2025-03-17T22:29:47.000000Z"},{"id":3323844,"change_date":"2023-01-04 21:40:00","inspection_id":"77507350","insp_unit_id":"192695824","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TREM","insp_unit_company":"H176","insp_unit_license":"D803417","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLSL4222HB000375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:47.000000Z","updated_at":"2025-03-17T22:29:47.000000Z"}]},{"id":2075650,"change_date":"2023-01-05 21:40:00","inspection_id":"77518211","dot_number":"179862","report_state":"MI","report_number":"PARLM01911","insp_date":"2023-01-04 00:00:00","insp_start_time":"0945","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"642","location_desc":"IONIA SCALE W\/B","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OLIN","shipping_paper_number":"6900350870","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1107877","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-01-04 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-01-05 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:47.000000Z","updated_at":"2025-03-17T19:04:47.000000Z","inspection_violations":[{"id":3212376,"change_date":"2023-01-05 21:40:00","inspection_id":"77518211","insp_violation_id":"250405413","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192717850","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3339541,"change_date":"2023-01-05 21:40:00","inspection_id":"77518211","insp_unit_id":"192717850","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"875628","insp_unit_license":"2833510","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG9KSLE1425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:54.000000Z","updated_at":"2025-03-17T22:29:54.000000Z"},{"id":3339542,"change_date":"2023-01-05 21:40:00","inspection_id":"77518211","insp_unit_id":"192717851","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"D815170","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1S9T74221V0017015","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:54.000000Z","updated_at":"2025-03-17T22:29:54.000000Z"}]},{"id":1984709,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","dot_number":"179862","report_state":"IN","report_number":"7582002288","insp_date":"2022-12-19 00:00:00","insp_start_time":"1535","insp_end_time":"1635","registration_date":"2022-12-30 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"I 74 WB","county_code_state":"IN","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HAVILAND","shipping_paper_number":"249727","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"2","hazmat_oos_total":"2","snet_sequence_id":"2166590","transaction_code":"C","transaction_date":"2022-12-20 00:00:00","upload_date":"2023-01-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-20 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:17.000000Z","updated_at":"2025-03-17T19:03:17.000000Z","inspection_violations":[{"id":3080557,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","insp_violation_id":"250356594","seq_no":"1","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:39.000000Z","updated_at":"2025-03-17T21:21:39.000000Z","normalized_code":"39522H4"},{"id":3080558,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","insp_violation_id":"250356595","seq_no":"2","part_no":"177","part_no_section":"823(a)","insp_viol_unit":"2","insp_unit_id":"192672258","insp_violation_category_id":"32","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:39.000000Z","updated_at":"2025-03-17T21:21:39.000000Z","normalized_code":"177823A"},{"id":3080559,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","insp_violation_id":"250356596","seq_no":"3","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"2","insp_unit_id":"192672258","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:21:39.000000Z","updated_at":"2025-03-17T21:21:39.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":3192863,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","insp_unit_id":"192672257","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3401322","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFGXPDUB8199","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:51.000000Z","updated_at":"2025-03-17T22:28:51.000000Z"},{"id":3192864,"change_date":"2023-01-03 21:41:00","inspection_id":"77414680","insp_unit_id":"192672258","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"481027","insp_unit_license":"C706586","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C5ET181027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:51.000000Z","updated_at":"2025-03-17T22:28:51.000000Z"}]},{"id":1821161,"change_date":"2022-11-28 21:41:00","inspection_id":"77227667","dot_number":"179862","report_state":"MI","report_number":"POWEL02905","insp_date":"2022-11-23 00:00:00","insp_start_time":"0755","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"395417","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1103401","transaction_code":"A","transaction_date":"2022-11-23 00:00:00","upload_date":"2022-11-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-23 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-28 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:00:18.000000Z","updated_at":"2025-03-17T19:00:18.000000Z","inspection_violations":[{"id":2844221,"change_date":"2022-11-28 21:41:00","inspection_id":"77227667","insp_violation_id":"249800143","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:30.000000Z","updated_at":"2025-03-17T21:20:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2929706,"change_date":"2022-11-28 21:41:00","inspection_id":"77227667","insp_unit_id":"192143256","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"599915","insp_unit_license":"3420735","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"},{"id":2929707,"change_date":"2022-11-28 21:41:00","inspection_id":"77227667","insp_unit_id":"192143257","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200597","insp_unit_license":"P912783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:02.000000Z","updated_at":"2025-03-17T22:27:02.000000Z"}]},{"id":1764199,"change_date":"2022-11-17 21:40:00","inspection_id":"77162077","dot_number":"179862","report_state":"US","report_number":"1727000156","insp_date":"2022-11-17 00:00:00","insp_start_time":"1115","insp_end_time":"1148","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-94 EB CHESTERTON","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"PRECISE FINISHING COMPANY INC","shipping_paper_number":"249557","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"136000","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":"5016","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-17 00:00:00","source_office":"3IND001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:16.000000Z","updated_at":"2025-03-17T18:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2838141,"change_date":"2022-11-17 21:40:00","inspection_id":"77162077","insp_unit_id":"192011302","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599909","insp_unit_license":"3420200","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG2PDUB8915","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"},{"id":2838142,"change_date":"2022-11-17 21:40:00","inspection_id":"77162077","insp_unit_id":"192011303","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200591","insp_unit_license":"P912784","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2487L3963901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"}]},{"id":1764323,"change_date":"2022-11-17 21:40:00","inspection_id":"77162228","dot_number":"179862","report_state":"MI","report_number":"RUDDJ00249","insp_date":"2022-11-17 00:00:00","insp_start_time":"0900","insp_end_time":"0921","registration_date":null,"region":"ET","ci_status_code":"C","location":"212","location_desc":"PONTIAC SCALE S\/B","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"UNIVERSAL COATINGS","shipping_paper_number":"249429","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102525","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:16.000000Z","updated_at":"2025-03-17T18:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2838357,"change_date":"2022-11-17 21:40:00","inspection_id":"77162228","insp_unit_id":"192011595","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"590502","insp_unit_license":"3351063","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB4844","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"},{"id":2838358,"change_date":"2022-11-17 21:40:00","inspection_id":"77162228","insp_unit_id":"192011596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200592","insp_unit_license":"P912778","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3963902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"}]},{"id":1436467,"change_date":"2022-10-04 21:41:00","inspection_id":"76785008","dot_number":"179862","report_state":"OH","report_number":"1200003714","insp_date":"2022-10-04 00:00:00","insp_start_time":"0630","insp_end_time":"0703","registration_date":null,"region":"ET","ci_status_code":"C","location":"04380","location_desc":"ROADSIDE 22","county_code_state":"OH","county_code":"043","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-04 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":"1619412","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-10-04 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:53:06.000000Z","updated_at":"2025-03-17T18:53:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2312544,"change_date":"2022-10-04 21:41:00","inspection_id":"76785008","insp_unit_id":"191259242","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:50.000000Z","updated_at":"2025-03-17T22:22:50.000000Z"},{"id":2312545,"change_date":"2022-10-04 21:41:00","inspection_id":"76785008","insp_unit_id":"191259243","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599910","insp_unit_license":"3401319","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8196","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:50.000000Z","updated_at":"2025-03-17T22:22:50.000000Z"}]},{"id":1295020,"change_date":"2022-09-15 21:40:00","inspection_id":"76620528","dot_number":"179862","report_state":"US","report_number":"1690000161","insp_date":"2022-09-12 00:00:00","insp_start_time":"1340","insp_end_time":"1413","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"MULTIPLE","shipping_paper_number":"240147","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-15 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":"3414","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-15 00:00:00","source_office":"3MID001","mcmis_add_date":"2022-09-15 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:30.000000Z","updated_at":"2025-03-17T18:50:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2084448,"change_date":"2022-09-15 21:40:00","inspection_id":"76620528","insp_unit_id":"190922154","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"599910","insp_unit_license":"3401319","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG4PDUB8196","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"},{"id":2084449,"change_date":"2022-09-15 21:40:00","inspection_id":"76620528","insp_unit_id":"190922155","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200595","insp_unit_license":"P912781","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484L3963905","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:21:17.000000Z","updated_at":"2025-03-17T22:21:17.000000Z"}]},{"id":1158830,"change_date":"2022-08-29 21:42:00","inspection_id":"76463027","dot_number":"179862","report_state":"MI","report_number":"BRADD00735","insp_date":"2022-08-25 00:00:00","insp_start_time":"1055","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"FULLER AVE","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND ENTERPRISES","shipping_paper_number":"387767","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1091961","transaction_code":"A","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-29 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:58.000000Z","updated_at":"2025-03-17T18:47:58.000000Z","inspection_violations":[{"id":1835880,"change_date":"2022-08-29 21:42:00","inspection_id":"76463027","insp_violation_id":"248063876","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3922"},{"id":1835881,"change_date":"2022-08-29 21:42:00","inspection_id":"76463027","insp_violation_id":"248063877","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"190596682","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":1863177,"change_date":"2022-08-29 21:42:00","inspection_id":"76463027","insp_unit_id":"190596681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400950","insp_unit_license":"3401290","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLFG6PDUC8194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"},{"id":1863178,"change_date":"2022-08-29 21:42:00","inspection_id":"76463027","insp_unit_id":"190596682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"POLR","insp_unit_company":"H175","insp_unit_license":"D579711","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1PMS3432711024484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:49.000000Z","updated_at":"2025-03-17T22:19:49.000000Z"}]},{"id":1035592,"change_date":"2022-08-29 21:42:00","inspection_id":"76319013","dot_number":"179862","report_state":"MI","report_number":"POWEL02741","insp_date":"2022-08-12 00:00:00","insp_start_time":"0800","insp_end_time":"0821","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"386964","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"1089345","transaction_code":"C","transaction_date":"2022-08-12 00:00:00","upload_date":"2022-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-15 21:38:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:51.000000Z","updated_at":"2025-03-17T18:45:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1666734,"change_date":"2022-08-29 21:42:00","inspection_id":"76319013","insp_unit_id":"190596070","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"547951","insp_unit_license":"2656538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG5ESFW2229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"},{"id":1666735,"change_date":"2022-08-29 21:42:00","inspection_id":"76319013","insp_unit_id":"190596071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912782","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2486L3963906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:30.000000Z","updated_at":"2025-03-17T22:18:30.000000Z"}]},{"id":1007639,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","dot_number":"179862","report_state":"MI","report_number":"HUGHB02169","insp_date":"2022-08-09 00:00:00","insp_start_time":"1525","insp_end_time":"1608","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EVONIK","shipping_paper_number":"294930","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1088440","transaction_code":"A","transaction_date":"2022-08-09 00:00:00","upload_date":"2022-08-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-09 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-10 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:25.000000Z","updated_at":"2025-03-17T18:45:25.000000Z","inspection_violations":[{"id":1586041,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","insp_violation_id":"247631083","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"2","insp_unit_id":"190238116","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39375A"},{"id":1586042,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","insp_violation_id":"247631084","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"190238116","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39347E"},{"id":1586043,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","insp_violation_id":"247631085","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"190238116","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:29.000000Z","updated_at":"2025-03-17T21:14:29.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":1620955,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","insp_unit_id":"190238115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2656537","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG1ESFW2227","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"},{"id":1620956,"change_date":"2022-08-10 21:39:00","inspection_id":"76286456","insp_unit_id":"190238116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"E580477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9ET075065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:13.000000Z","updated_at":"2025-03-17T22:18:13.000000Z"}]},{"id":933816,"change_date":"2022-08-01 21:39:00","inspection_id":"76200411","dot_number":"179862","report_state":"MI","report_number":"ASMUN00531","insp_date":"2022-07-28 00:00:00","insp_start_time":"0725","insp_end_time":"0747","registration_date":null,"region":"ET","ci_status_code":"C","location":"531","location_desc":"NEW BUFFALO SCALE E\/B","county_code_state":"MI","county_code":"021","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"POWDER PROCESSING","shipping_paper_number":"242095","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117300","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":"1086187","transaction_code":"A","transaction_date":"2022-07-28 00:00:00","upload_date":"2022-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-08-01 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:05.000000Z","updated_at":"2025-03-17T18:44:05.000000Z","inspection_violations":[{"id":1473172,"change_date":"2022-08-01 21:39:00","inspection_id":"76200411","insp_violation_id":"247430349","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"190062920","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:58.000000Z","updated_at":"2025-03-17T21:13:58.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":1503082,"change_date":"2022-08-01 21:39:00","inspection_id":"76200411","insp_unit_id":"190062919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3285942","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV4PDNZ5353","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"},{"id":1503083,"change_date":"2022-08-01 21:39:00","inspection_id":"76200411","insp_unit_id":"190062920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"D737757","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V482C7AT055004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:27.000000Z","updated_at":"2025-03-17T22:17:27.000000Z"}]},{"id":790395,"change_date":"2022-08-09 21:41:00","inspection_id":"76032391","dot_number":"179862","report_state":"OH","report_number":"3205401731","insp_date":"2022-07-11 00:00:00","insp_start_time":"1026","insp_end_time":"1131","registration_date":"2022-08-09 00:00:00","region":"ET","ci_status_code":"C","location":"81","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"161","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS COMPANY","shipping_paper_number":"383790","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1606071","transaction_code":"C","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-11 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-07-11 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:36.000000Z","updated_at":"2025-03-17T18:41:36.000000Z","inspection_violations":[{"id":1245974,"change_date":"2022-08-09 21:41:00","inspection_id":"76032391","insp_violation_id":"247604368","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"190214234","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:52.000000Z","updated_at":"2025-03-17T21:12:52.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":1271758,"change_date":"2022-08-09 21:41:00","inspection_id":"76032391","insp_unit_id":"190214233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"517525","insp_unit_license":"3168996","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV5NSNH1048","insp_unit_decal":"Y","insp_unit_decal_number":"31609308","created_at":"2025-03-17T22:16:00.000000Z","updated_at":"2025-03-17T22:16:00.000000Z"},{"id":1271759,"change_date":"2022-08-09 21:41:00","inspection_id":"76032391","insp_unit_id":"190214234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"487065","insp_unit_license":"E580477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9ET075065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:00.000000Z","updated_at":"2025-03-17T22:16:00.000000Z"}]},{"id":627592,"change_date":"2022-06-16 21:43:00","inspection_id":"75841067","dot_number":"179862","report_state":"MI","report_number":"HICKG01710","insp_date":"2022-06-15 00:00:00","insp_start_time":"1400","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"GRAND RIVER AVE @ JONES RD","county_code_state":"MI","county_code":"037","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"239947","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1079705","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[{"id":984007,"change_date":"2022-06-16 21:43:00","inspection_id":"75841067","insp_violation_id":"246515703","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:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"3922"},{"id":984008,"change_date":"2022-06-16 21:43:00","inspection_id":"75841067","insp_violation_id":"246515704","seq_no":"2","part_no":"177","part_no_section":"834(a)","insp_viol_unit":"2","insp_unit_id":"189294596","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4069598","created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"177834A"}],"inspection_per_units":[{"id":1008679,"change_date":"2022-06-16 21:43:00","inspection_id":"75841067","insp_unit_id":"189294595","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":"681790","insp_unit_license":"2657054","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG6JLJK0847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1008680,"change_date":"2022-06-16 21:43:00","inspection_id":"75841067","insp_unit_id":"189294596","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200594","insp_unit_license":"P912780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]},{"id":639309,"change_date":"2022-06-17 21:40:00","inspection_id":"75854972","dot_number":"179862","report_state":"IN","report_number":"9286003355","insp_date":"2022-06-15 00:00:00","insp_start_time":"0715","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"1394W","location_desc":"#13  I-94 WB  PORTER","county_code_state":"IN","county_code":"127","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HAVILAND","shipping_paper_number":"23606712","cargo_tank":"412","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2134182","transaction_code":"A","transaction_date":"2022-06-17 00:00:00","upload_date":"2022-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-17 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-06-17 21:40:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:52.000000Z","updated_at":"2025-03-17T18:38:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1027444,"change_date":"2022-06-17 21:40:00","inspection_id":"75854972","insp_unit_id":"189326129","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878386","insp_unit_license":"2816468","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEFG0KSLH8606","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:31.000000Z","updated_at":"2025-03-17T22:14:31.000000Z"},{"id":1027445,"change_date":"2022-06-17 21:40:00","inspection_id":"75854972","insp_unit_id":"189326130","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"H176","insp_unit_license":"D803417","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2TLSL4222HB000375","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:31.000000Z","updated_at":"2025-03-17T22:14:31.000000Z"}]},{"id":627457,"change_date":"2022-06-16 21:43:00","inspection_id":"75840913","dot_number":"179862","report_state":"MI","report_number":"KIRKB03491","insp_date":"2022-06-13 00:00:00","insp_start_time":"0920","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"121","location_desc":"FOWLERVILLE SCALE E\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"381291","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"1080199","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:48.000000Z","updated_at":"2025-03-17T18:38:48.000000Z","inspection_violations":[{"id":983765,"change_date":"2022-06-16 21:43:00","inspection_id":"75840913","insp_violation_id":"246515386","seq_no":"1","part_no":"172","part_no_section":"504(a)","insp_viol_unit":"2","insp_unit_id":"189294334","insp_violation_category_id":"32","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:37.000000Z","updated_at":"2025-03-17T21:11:37.000000Z","normalized_code":"172504A"}],"inspection_per_units":[{"id":1008471,"change_date":"2022-06-16 21:43:00","inspection_id":"75840913","insp_unit_id":"189294333","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"547952","insp_unit_license":"3273257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG1ESFW2230","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"},{"id":1008472,"change_date":"2022-06-16 21:43:00","inspection_id":"75840913","insp_unit_id":"189294334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200597","insp_unit_license":"P912783","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2488L3963907","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:23.000000Z","updated_at":"2025-03-17T22:14:23.000000Z"}]},{"id":473312,"change_date":"2022-05-24 21:43:00","inspection_id":"75657543","dot_number":"179862","report_state":"OH","report_number":"3205401698","insp_date":"2022-05-24 00:00:00","insp_start_time":"0955","insp_end_time":"1052","registration_date":null,"region":"ET","ci_status_code":"C","location":"02","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"003","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"THE SHEPHERD CHEMICAL COMPANY","shipping_paper_number":"80124119","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-24 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1598613","transaction_code":"A","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-24 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-05-24 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:59.000000Z","updated_at":"2025-03-17T18:35:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":761066,"change_date":"2022-05-24 21:43:00","inspection_id":"75657543","insp_unit_id":"188886200","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"517525","insp_unit_license":"3168996","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV5NSNH1048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"},{"id":761067,"change_date":"2022-05-24 21:43:00","inspection_id":"75657543","insp_unit_id":"188886201","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"487065","insp_unit_license":"E580477","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C9ET075065","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:53.000000Z","updated_at":"2025-03-17T22:12:53.000000Z"}]},{"id":460123,"change_date":"2022-06-09 21:42:00","inspection_id":"75641748","dot_number":"179862","report_state":"MI","report_number":"RODRR01785","insp_date":"2022-05-20 00:00:00","insp_start_time":"1515","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"US-131 NB @ LEONARD ST","county_code_state":"MI","county_code":"081","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"243533\/243532","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1076565","transaction_code":"C","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-23 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:55.000000Z","updated_at":"2025-03-17T18:35:55.000000Z","inspection_violations":[{"id":728583,"change_date":"2022-06-09 21:42:00","inspection_id":"75641748","insp_violation_id":"246341203","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189152227","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"39311"},{"id":728584,"change_date":"2022-06-09 21:42:00","inspection_id":"75641748","insp_violation_id":"246341204","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189152228","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":741246,"change_date":"2022-06-09 21:42:00","inspection_id":"75641748","insp_unit_id":"189152227","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"547951","insp_unit_license":"2656538","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG5ESFW2229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:46.000000Z","updated_at":"2025-03-17T22:12:46.000000Z"},{"id":741247,"change_date":"2022-06-09 21:42:00","inspection_id":"75641748","insp_unit_id":"189152228","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"481001","insp_unit_license":"D768355","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V482C9JT451001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:46.000000Z","updated_at":"2025-03-17T22:12:46.000000Z"}]},{"id":407320,"change_date":"2022-06-09 21:42:00","inspection_id":"75578960","dot_number":"179862","report_state":"MI","report_number":"LECHR02661","insp_date":"2022-05-16 00:00:00","insp_start_time":"0910","insp_end_time":"0956","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I96 EB NEAR EB SCALE","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE SOLUTIONS","shipping_paper_number":"378810","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"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":"124000","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":"1075842","transaction_code":"C","transaction_date":"2022-05-16 00:00:00","upload_date":"2022-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-05-17 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","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":636757,"change_date":"2022-06-09 21:42:00","inspection_id":"75578960","insp_violation_id":"246336889","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","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":657589,"change_date":"2022-06-09 21:42:00","inspection_id":"75578960","insp_unit_id":"189148013","insp_unit_type_id":"3","insp_unit_number":"1","insp_unit_make":"FRT","insp_unit_company":null,"insp_unit_license":"3273257","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG1ESFW2230","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":657590,"change_date":"2022-06-09 21:42:00","inspection_id":"75578960","insp_unit_id":"189148014","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912789","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3964001","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":394899,"change_date":"2022-05-16 21:43:00","inspection_id":"75564303","dot_number":"179862","report_state":"IN","report_number":"7301003019","insp_date":"2022-05-12 00:00:00","insp_start_time":"1040","insp_end_time":"1100","registration_date":"2022-05-16 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"US 31 NB @ SR 26-KOKOMO","county_code_state":"IN","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"ELECTROSPEC","shipping_paper_number":"242882","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2128652","transaction_code":"A","transaction_date":"2022-05-13 00:00:00","upload_date":"2022-05-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-05-13 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-05-16 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:27.000000Z","updated_at":"2025-03-17T18:34:27.000000Z","inspection_violations":[{"id":616524,"change_date":"2022-05-16 21:43:00","inspection_id":"75564303","insp_violation_id":"245802284","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"188696117","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:54.000000Z","updated_at":"2025-03-17T21:09:54.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":637999,"change_date":"2022-05-16 21:43:00","inspection_id":"75564303","insp_unit_id":"188696117","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"547953","insp_unit_license":"2656540","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG3ESFW2231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"},{"id":638000,"change_date":"2022-05-16 21:43:00","inspection_id":"75564303","insp_unit_id":"188696118","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200593","insp_unit_license":"P912779","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2480L3963903","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:06.000000Z","updated_at":"2025-03-17T22:12:06.000000Z"}]},{"id":377326,"change_date":"2022-05-12 21:41:00","inspection_id":"75542925","dot_number":"179862","report_state":"US","report_number":"1690000140","insp_date":"2022-05-04 00:00:00","insp_start_time":"0910","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB FOWLERVILLE SCALE","county_code_state":"MI","county_code":"093","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"MULTIPLE","cargo_tank":"OTH","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-12 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":"3339","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-05-12 00:00:00","source_office":"3MID001","mcmis_add_date":"2022-05-12 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:02.000000Z","updated_at":"2025-03-17T18:34:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":610095,"change_date":"2022-05-12 21:41:00","inspection_id":"75542925","insp_unit_id":"188651348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"681790","insp_unit_license":"2637054","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGEFG6JLK0847","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"},{"id":610096,"change_date":"2022-05-12 21:41:00","inspection_id":"75542925","insp_unit_id":"188651349","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912780","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2482L3963904","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2025-03-17T22:11:57.000000Z","updated_at":"2025-03-17T22:11:57.000000Z"}]},{"id":224641,"change_date":"2022-04-21 21:41:00","inspection_id":"75361027","dot_number":"179862","report_state":"IL","report_number":"0122000043","insp_date":"2022-04-20 00:00:00","insp_start_time":"1221","insp_end_time":"1252","registration_date":null,"region":"CT","ci_status_code":"C","location":"SC06","location_desc":"BOLINGBROOK - I-55 S\/B","county_code_state":"IL","county_code":"197","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"HAVILAND PRODUCTS","shipping_paper_number":"243273","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"2165059","transaction_code":"A","transaction_date":"2022-04-20 00:00:00","upload_date":"2022-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-21 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-04-21 21:41:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:32.000000Z","updated_at":"2025-03-17T18:31:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":364200,"change_date":"2022-04-21 21:41:00","inspection_id":"75361027","insp_unit_id":"188272055","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"547955","insp_unit_license":"2656542","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG7ESFW2233","insp_unit_decal":"Y","insp_unit_decal_number":"31305037","created_at":"2025-03-17T22:10:27.000000Z","updated_at":"2025-03-17T22:10:27.000000Z"},{"id":364201,"change_date":"2022-04-21 21:41:00","inspection_id":"75361027","insp_unit_id":"188272056","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200591","insp_unit_license":"P912784","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1UYVS2487L3963901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:27.000000Z","updated_at":"2025-03-17T22:10:27.000000Z"}]},{"id":203324,"change_date":"2022-04-19 21:43:00","inspection_id":"75335508","dot_number":"179862","report_state":"IL","report_number":"4109480353","insp_date":"2022-04-13 00:00:00","insp_start_time":"1042","insp_end_time":"1046","registration_date":null,"region":"CT","ci_status_code":"C","location":"032","location_desc":"032 - LITCHFIELD - I-55 N\/B","county_code_state":"IL","county_code":"135","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"HAVILAND","shipping_paper_number":"374881","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-19 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2162958","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-13 00:00:00","source_office":"3ILS001","mcmis_add_date":"2022-04-19 21:43:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:11.000000Z","updated_at":"2025-03-17T18:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":329400,"change_date":"2022-04-19 21:43:00","inspection_id":"75335508","insp_unit_id":"188219667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"878588","insp_unit_license":"2868797","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3AKJGEFGXKSLH7737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:09.000000Z","updated_at":"2025-03-17T22:10:09.000000Z"},{"id":329401,"change_date":"2022-04-19 21:43:00","inspection_id":"75335508","insp_unit_id":"188219668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANG","insp_unit_company":"1","insp_unit_license":"D889289","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5V8VC532XHM708913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:09.000000Z","updated_at":"2025-03-17T22:10:09.000000Z"}]},{"id":175784,"change_date":"2022-04-14 21:42:00","inspection_id":"75303060","dot_number":"179862","report_state":"US","report_number":"1444000327","insp_date":"2022-04-12 00:00:00","insp_start_time":"1235","insp_end_time":"1328","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-94 EASTBOUND","county_code_state":"IN","county_code":"029","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PLATING INTERNATIONSL","shipping_paper_number":"4742","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-04-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"4755","transaction_code":"A","transaction_date":"2022-04-12 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-14 00:00:00","source_office":"3IND001","mcmis_add_date":"2022-04-14 21:42:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET NW","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:32.000000Z","updated_at":"2025-03-17T18:30:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":284702,"change_date":"2022-04-14 21:42:00","inspection_id":"75303060","insp_unit_id":"188155044","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"547888","insp_unit_license":"2656536","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBGXESFW2226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:54.000000Z","updated_at":"2025-03-17T22:09:54.000000Z"},{"id":284703,"change_date":"2022-04-14 21:42:00","inspection_id":"75303060","insp_unit_id":"188155045","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"481027","insp_unit_license":"C706586","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"3H3V532C5ET181027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:54.000000Z","updated_at":"2025-03-17T22:09:54.000000Z"}]},{"id":128527,"change_date":"2022-04-07 21:39:00","inspection_id":"75246074","dot_number":"179862","report_state":"MI","report_number":"FRIZS02463","insp_date":"2022-04-06 00:00:00","insp_start_time":"1253","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-96 W\/B IONIA SCALE","county_code_state":"MI","county_code":"067","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S \/ C","shipping_paper_number":"242646","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","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":"1070826","transaction_code":"A","transaction_date":"2022-04-06 00:00:00","upload_date":"2022-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-04-07 21:39:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:49.000000Z","updated_at":"2025-03-17T18:29:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":208225,"change_date":"2022-04-07 21:39:00","inspection_id":"75246074","insp_unit_id":"188039917","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"838566","insp_unit_license":"2788420","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EG3KN212344","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"},{"id":208226,"change_date":"2022-04-07 21:39:00","inspection_id":"75246074","insp_unit_id":"188039918","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"200599","insp_unit_license":"P912782","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2486L3963906","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:28.000000Z","updated_at":"2025-03-17T22:09:28.000000Z"}]},{"id":43884,"change_date":"2022-03-25 21:31:00","inspection_id":"75141402","dot_number":"179862","report_state":"MI","report_number":"LULAN01004","insp_date":"2022-03-24 00:00:00","insp_start_time":"1423","insp_end_time":"1502","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"S\/C","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1069071","transaction_code":"A","transaction_date":"2022-03-24 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00179862","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"HAVILAND PRODUCTS COMPANY","insp_carrier_street":"421 ANN STREET","insp_carrier_city":"GRAND RAPIDS","insp_carrier_state":"MI","insp_carrier_zip_code":"49504","insp_colonia":null,"docket_number":"947679","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:24.000000Z","updated_at":"2025-03-17T18:28:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":70768,"change_date":"2022-03-25 21:31:00","inspection_id":"75141402","insp_unit_id":"187825132","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2656535","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGEBG8ESFW2225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"},{"id":70769,"change_date":"2022-03-25 21:31:00","inspection_id":"75141402","insp_unit_id":"187825133","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"P912778","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2489L3963902","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/179862\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/179862\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/179862\/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\/179862\/inspections","per_page":100,"prev_page_url":null,"to":84,"total":84}