{"current_page":1,"data":[{"id":12238548,"change_date":"2026-06-20 21:35:00","inspection_id":"88196355","dot_number":"1711586","report_state":"PA","report_number":"M744000135","insp_date":"2026-06-18 00:00:00","insp_start_time":"1354","insp_end_time":"1404","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"ABINGTON PA","county_code_state":"PA","county_code":"091","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-20 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"3583542","transaction_code":"A","transaction_date":"2026-06-19 00:00:00","upload_date":"2026-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-20 21:35:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-20 21:35:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-23T09:40:43.000000Z","updated_at":"2026-07-02T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528576,"change_date":null,"inspection_id":"88196355","insp_unit_id":"sms-backfill-793767195-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RC44254","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X3KM615003","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12198757,"change_date":"2026-06-16 21:39:00","inspection_id":"88155396","dot_number":"1711586","report_state":"MI","report_number":"DAUGN04729","insp_date":"2026-06-16 00:00:00","insp_start_time":"0600","insp_end_time":"0620","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"IFL","shipping_paper_number":"71","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3552339","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:37.000000Z","updated_at":"2026-06-27T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21523919,"change_date":null,"inspection_id":"88155396","insp_unit_id":"sms-backfill-793398564-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC46333","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV3SLVN9019","insp_unit_decal":null,"insp_unit_decal_number":"001","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12201047,"change_date":"2026-06-16 21:40:00","inspection_id":"88157804","dot_number":"1711586","report_state":"MI","report_number":"DAUGN04733","insp_date":"2026-06-16 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"406","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3553998","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:40.000000Z","updated_at":"2026-06-27T09:30:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21523925,"change_date":null,"inspection_id":"88157804","insp_unit_id":"sms-backfill-793420236-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC64444","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV3TLWP9470","insp_unit_decal":null,"insp_unit_decal_number":"001","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12199230,"change_date":"2026-06-16 21:39:00","inspection_id":"88155896","dot_number":"1711586","report_state":"MI","report_number":"DAUGN04730","insp_date":"2026-06-16 00:00:00","insp_start_time":"0630","insp_end_time":"0655","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"406","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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3552505","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:37.000000Z","updated_at":"2026-06-27T09:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21524196,"change_date":null,"inspection_id":"88155896","insp_unit_id":"sms-backfill-793403064-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC55325","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV4TLWP9459","insp_unit_decal":null,"insp_unit_decal_number":"01","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12199423,"change_date":"2026-06-16 21:39:00","inspection_id":"88156096","dot_number":"1711586","report_state":"MI","report_number":"DAUGN04731","insp_date":"2026-06-16 00:00:00","insp_start_time":"0700","insp_end_time":"0725","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"406","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-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3552766","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:37.000000Z","updated_at":"2026-06-27T09:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528031,"change_date":null,"inspection_id":"88156096","insp_unit_id":"sms-backfill-793404864-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC59753","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV0TLWP9460","insp_unit_decal":null,"insp_unit_decal_number":"01","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":12199807,"change_date":"2026-06-16 21:39:00","inspection_id":"88156498","dot_number":"1711586","report_state":"MI","report_number":"DAUGN04732","insp_date":"2026-06-16 00:00:00","insp_start_time":"0730","insp_end_time":"0755","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3553237","transaction_code":"A","transaction_date":"2026-06-16 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-06-16 21:39:00","snet_input_date":"2026-06-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-16 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:38.000000Z","updated_at":"2026-06-27T09:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21528034,"change_date":null,"inspection_id":"88156498","insp_unit_id":"sms-backfill-793408482-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC64442","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV5TLWP9471","insp_unit_decal":null,"insp_unit_decal_number":"01","created_at":"2026-07-13T03:28:54.000000Z","updated_at":"2026-07-13T03:28:54.000000Z"}]},{"id":11851045,"change_date":"2026-05-07 21:40:00","inspection_id":"87787139","dot_number":"1711586","report_state":"NC","report_number":"0006872762","insp_date":"2026-05-06 00:00:00","insp_start_time":"1035","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 40","location_desc":"I 40","county_code_state":"NC","county_code":"135","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2403452","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-05-07 21:40:00","snet_input_date":"2026-05-07 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-05-07 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-10T09:39:36.000000Z","updated_at":"2026-05-18T09:31:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340347,"change_date":null,"inspection_id":"87787139","insp_unit_id":"sms-backfill-790084251-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"36404556","created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11821312,"change_date":"2026-05-07 21:40:00","inspection_id":"87755855","dot_number":"1711586","report_state":"KY","report_number":"CV43889507","insp_date":"2026-05-04 00:00:00","insp_start_time":"1040","insp_end_time":"1111","registration_date":"2026-05-07 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"NICHOLASVILLE","county_code_state":"KY","county_code":"113","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IFL INNOVATIVE","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2343642","transaction_code":"C","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2026-05-04 21:39:00","snet_input_date":"2026-05-04 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-05-04 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:39:03.000000Z","updated_at":"2026-05-18T09:30:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21339201,"change_date":null,"inspection_id":"87755855","insp_unit_id":"sms-backfill-789802695-1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC27380","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUL3649","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11838517,"change_date":"2026-05-06 21:41:00","inspection_id":"87773984","dot_number":"1711586","report_state":"IN","report_number":"6449004498","insp_date":"2026-04-30 00:00:00","insp_start_time":"0941","insp_end_time":"1010","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"INDIANAPOLIS IN","county_code_state":"IN","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":"N\/A","cargo_tank":"406","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-05-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3272333","transaction_code":"A","transaction_date":"2026-05-06 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-05-06 21:41:00","snet_input_date":"2026-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:15.000000Z","updated_at":"2026-05-16T13:24:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21340178,"change_date":null,"inspection_id":"87773984","insp_unit_id":"sms-backfill-789965856-1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM233367","insp_unit_decal":null,"insp_unit_decal_number":null,"created_at":"2026-06-29T03:28:42.000000Z","updated_at":"2026-06-29T03:28:42.000000Z"}]},{"id":11318567,"change_date":"2026-03-08 21:33:00","inspection_id":"87235097","dot_number":"1711586","report_state":"TN","report_number":"I01RB80208","insp_date":"2026-03-06 00:00:00","insp_start_time":"0925","insp_end_time":"0958","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"GORDONSVILLE TN","county_code_state":"TN","county_code":"159","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2978624","transaction_code":"A","transaction_date":"2026-03-07 00:00:00","upload_date":"2026-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-03-08 21:33:00","snet_input_date":"2026-03-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-08 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-11T09:38:21.000000Z","updated_at":"2026-03-19T09:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20331288,"change_date":null,"inspection_id":"87235097","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RA28770","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0XXKM615001","insp_unit_decal":null,"insp_unit_decal_number":"36097024","created_at":"2026-04-20T03:15:53.000000Z","updated_at":"2026-04-20T03:15:53.000000Z"}]},{"id":11315293,"change_date":"2026-03-07 21:33:00","inspection_id":"87231617","dot_number":"1711586","report_state":"TN","report_number":"I037H20365","insp_date":"2026-03-05 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"PULASKI TN","county_code_state":"TN","county_code":"055","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-07 21:33:00","post_acc_ind":"Y","gross_comb_veh_wt":"66000","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":"2974472","transaction_code":"A","transaction_date":"2026-03-06 00:00:00","upload_date":"2026-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-03-07 21:33:00","snet_input_date":"2026-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-07 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-10T09:41:34.000000Z","updated_at":"2026-03-18T09:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20331794,"change_date":null,"inspection_id":"87231617","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RC17402","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X6PM856349","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":11222070,"change_date":"2026-02-25 21:46:00","inspection_id":"87133823","dot_number":"1711586","report_state":"TN","report_number":"I033AG2927","insp_date":"2026-02-23 00:00:00","insp_start_time":"1722","insp_end_time":"1739","registration_date":null,"region":"ES","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS, LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-25 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2929430","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-02-25 21:46:00","snet_input_date":"2026-02-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-25 21:46:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-28T10:38:23.000000Z","updated_at":"2026-03-08T09:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19456108,"change_date":null,"inspection_id":"87133823","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","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":11100611,"change_date":"2026-02-11 21:38:00","inspection_id":"87012626","dot_number":"1711586","report_state":"MN","report_number":"0317000811","insp_date":"2026-02-04 00:00:00","insp_start_time":"1024","insp_end_time":"1154","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CAMBRIDGE MN","county_code_state":"MN","county_code":"059","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"406","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-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"10","oos_total":"5","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"9","vehicle_oos_total":"4","hazmat_viol_total":"5","hazmat_oos_total":"2","snet_sequence_id":"2870756","transaction_code":"A","transaction_date":"2026-02-10 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:29.000000Z","updated_at":"2026-02-22T10:30:14.000000Z","inspection_violations":[{"id":19146366,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"602C-HMER","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"172602CHMER"},{"id":19146367,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"173","part_no_section":"24B1-HMBPMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"17324B1HMBPMC"},{"id":19146368,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817E2-HMHC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"177817E2HMHC"},{"id":19146369,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"834J2-HMBPDV","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"177834J2HMBPDV"},{"id":19146370,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"178","part_no_section":"345-6-HMP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"1783456HMP"},{"id":19146371,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"38323A2LCDL"},{"id":19146372,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75A1-TFBMF","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39375A1TFBMF"},{"id":19146373,"change_date":null,"inspection_id":"87012626","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75B-TFV","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-03-16T03:19:05.000000Z","updated_at":"2026-03-16T03:19:05.000000Z","normalized_code":"39375BTFV"}],"inspection_per_units":[{"id":19451768,"change_date":null,"inspection_id":"87012626","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC12981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHAVDV8NPNM8649","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":10880181,"change_date":"2026-01-29 21:37:00","inspection_id":"86910593","dot_number":"1711586","report_state":"NY","report_number":"SPG3041014","insp_date":"2026-01-22 00:00:00","insp_start_time":"1430","insp_end_time":"1436","registration_date":null,"region":"ES","ci_status_code":"C","location":"10697N","location_desc":"QUEENSBURY NY","county_code_state":"NY","county_code":"113","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-29 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2822384","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-01-29 21:37:00","snet_input_date":"2026-01-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-29 21:37:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-01T10:35:41.000000Z","updated_at":"2026-02-10T10:30:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19089355,"change_date":null,"inspection_id":"86910593","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":null,"insp_unit_license":"RC50745","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X9KM312982","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":10619339,"change_date":"2026-01-11 21:33:00","inspection_id":"86759682","dot_number":"1711586","report_state":"MD","report_number":"2170C00961","insp_date":"2026-01-09 00:00:00","insp_start_time":"0903","insp_end_time":"0927","registration_date":null,"region":"ES","ci_status_code":"C","location":"001027","location_desc":"SYKESVILLE MD","county_code_state":"MD","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"64","cargo_tank":"406","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-01-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2749866","transaction_code":"A","transaction_date":"2026-01-10 00:00:00","upload_date":"2026-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2026-01-11 21:33:00","snet_input_date":"2026-01-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-11 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-14T10:34:53.000000Z","updated_at":"2026-01-22T10:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19090196,"change_date":null,"inspection_id":"86759682","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC30188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2RLUL3650","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":10468792,"change_date":"2025-12-18 21:40:00","inspection_id":"86602112","dot_number":"1711586","report_state":"VA","report_number":"5755001052","insp_date":"2025-12-17 00:00:00","insp_start_time":"1033","insp_end_time":"1105","registration_date":null,"region":"ES","ci_status_code":"C","location":"SANSCW","location_desc":"SANDSTON VA","county_code_state":"VA","county_code":"087","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IFL INNOVATIVE FLUIDS LLC","shipping_paper_number":"121725","cargo_tank":"OTH","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":"2025-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2676065","transaction_code":"A","transaction_date":"2025-12-18 00:00:00","upload_date":"2025-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-12-18 21:40:00","snet_input_date":"2025-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-18 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-21T10:31:40.000000Z","updated_at":"2025-12-29T10:30:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18674518,"change_date":null,"inspection_id":"86602112","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC20591","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X9PM250574","insp_unit_decal":null,"insp_unit_decal_number":"35721411","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10490884,"change_date":"2025-12-22 21:38:00","inspection_id":"86625292","dot_number":"1711586","report_state":"NY","report_number":"D103001813","insp_date":"2025-12-15 00:00:00","insp_start_time":"0943","insp_end_time":"1006","registration_date":null,"region":"ES","ci_status_code":"C","location":"90633S","location_desc":"OXFORD NY","county_code_state":"NY","county_code":"017","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IFL   INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2686800","transaction_code":"A","transaction_date":"2025-12-21 00:00:00","upload_date":"2025-12-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-12-22 21:38:00","snet_input_date":"2025-12-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-22 21:38:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-25T10:37:36.000000Z","updated_at":"2026-01-02T10:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18752966,"change_date":null,"inspection_id":"86625292","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC13900","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"2NKHLJ0X7KM312981","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10368430,"change_date":"2025-12-06 21:33:00","inspection_id":"86497155","dot_number":"1711586","report_state":"TN","report_number":"I033970078","insp_date":"2025-12-04 00:00:00","insp_start_time":"2117","insp_end_time":"2134","registration_date":null,"region":"ES","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS, LLC","shipping_paper_number":"120425","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-12-06 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"2624667","transaction_code":"A","transaction_date":"2025-12-06 00:00:00","upload_date":"2025-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-12-06 21:33:00","snet_input_date":"2025-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-06 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-09T10:31:43.000000Z","updated_at":"2025-12-10T10:30:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18751471,"change_date":null,"inspection_id":"86497155","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10277280,"change_date":"2025-11-24 21:39:00","inspection_id":"86401840","dot_number":"1711586","report_state":"NJ","report_number":"SPQZI01758","insp_date":"2025-11-21 00:00:00","insp_start_time":"0740","insp_end_time":"0825","registration_date":null,"region":"ET","ci_status_code":"C","location":"1352","location_desc":"HERBERTSVILLE","county_code_state":"NJ","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1325505","transaction_code":"A","transaction_date":"2025-11-21 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-11-24 21:39:00","snet_input_date":"2025-11-21 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-11-24 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:45.000000Z","updated_at":"2025-11-28T10:30:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18672539,"change_date":null,"inspection_id":"86401840","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC13699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X3NM811947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10300757,"change_date":"2025-11-27 21:34:00","inspection_id":"86426463","dot_number":"1711586","report_state":"MN","report_number":"0317000756","insp_date":"2025-11-20 00:00:00","insp_start_time":"1239","insp_end_time":"1322","registration_date":null,"region":"CS","ci_status_code":"C","location":"FLSCL","location_desc":"FOREST LAKE MN","county_code_state":"MN","county_code":"003","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"N\/A","cargo_tank":"406","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":"U","pen_cen_match":"I","final_status_date":"2025-11-27 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"2592487","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-11-27 21:34:00","snet_input_date":"2025-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-11-27 21:34:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-30T10:31:15.000000Z","updated_at":"2025-12-01T10:30:18.000000Z","inspection_violations":[{"id":18488473,"change_date":null,"inspection_id":"86426463","insp_violation_id":null,"seq_no":null,"part_no":"178","part_no_section":"345-6-HMP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"1783456HMP"},{"id":18488474,"change_date":null,"inspection_id":"86426463","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":18750671,"change_date":null,"inspection_id":"86426463","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC12981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHAVDV8NPNM8649","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10248184,"change_date":"2025-11-21 21:38:00","inspection_id":"86371463","dot_number":"1711586","report_state":"KY","report_number":"CV43684270","insp_date":"2025-11-19 00:00:00","insp_start_time":"1550","insp_end_time":"1630","registration_date":"2025-11-21 00:00:00","region":"ET","ci_status_code":"C","location":"9808","location_desc":"WALTON","county_code_state":"KY","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2317858","transaction_code":"C","transaction_date":"2025-11-20 00:00:00","upload_date":"2025-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2025-11-20 21:40:00","snet_input_date":"2025-11-20 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-11-20 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-23T10:32:07.000000Z","updated_at":"2025-11-25T10:30:08.000000Z","inspection_violations":[{"id":18487437,"change_date":null,"inspection_id":"86371463","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"16AD","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":18672092,"change_date":null,"inspection_id":"86371463","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB95639","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X4GM498745","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10200249,"change_date":"2025-11-14 21:40:00","inspection_id":"86321066","dot_number":"1711586","report_state":"IA","report_number":"000P16BQD1","insp_date":"2025-11-13 00:00:00","insp_start_time":"1148","insp_end_time":"1230","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"61","cargo_tank":"406","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-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1380947","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-17T10:31:27.000000Z","updated_at":"2025-11-18T10:30:48.000000Z","inspection_violations":[{"id":18486675,"change_date":null,"inspection_id":"86321066","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":18671488,"change_date":null,"inspection_id":"86321066","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC26207","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2PLUF8072","insp_unit_decal":null,"insp_unit_decal_number":"35813179","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":10193277,"change_date":"2025-11-13 21:39:00","inspection_id":"86313691","dot_number":"1711586","report_state":"IL","report_number":"5005430419","insp_date":"2025-11-12 00:00:00","insp_start_time":"1300","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":"031","location_desc":"031 - MARYVILLE - I-55\/70 S\/B","county_code_state":"IL","county_code":"119","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS, LLC","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-11-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2442979","transaction_code":"A","transaction_date":"2025-11-12 00:00:00","upload_date":"2025-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-11-13 21:39:00","snet_input_date":"2025-11-12 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-11-13 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-16T10:31:58.000000Z","updated_at":"2025-11-17T10:31:02.000000Z","inspection_violations":[{"id":18486572,"change_date":null,"inspection_id":"86313691","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18671392,"change_date":null,"inspection_id":"86313691","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB65856","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0LM421333","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9967542,"change_date":"2025-10-17 21:38:00","inspection_id":"86075954","dot_number":"1711586","report_state":"OH","report_number":"3219000241","insp_date":"2025-10-15 00:00:00","insp_start_time":"1035","insp_end_time":"1110","registration_date":null,"region":"ED","ci_status_code":"C","location":"321901","location_desc":"BOLIVAR OH","county_code_state":"OH","county_code":"157","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"101525","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2423182","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-10-17 21:38:00","snet_input_date":"2025-10-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-17 21:38:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:41.000000Z","updated_at":"2025-10-21T10:00:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18668607,"change_date":null,"inspection_id":"86075954","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC27379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV4RLUL3648","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9940368,"change_date":"2025-10-14 21:42:00","inspection_id":"86047435","dot_number":"1711586","report_state":"IL","report_number":"5005230203","insp_date":"2025-10-13 00:00:00","insp_start_time":"0903","insp_end_time":"1001","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I 57","county_code_state":"IL","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"25","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-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","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":"2439019","transaction_code":"A","transaction_date":"2025-10-13 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-10-14 21:42:00","snet_input_date":"2025-10-13 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-17T10:01:51.000000Z","updated_at":"2025-10-18T10:01:14.000000Z","inspection_violations":[{"id":18482317,"change_date":null,"inspection_id":"86047435","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"516(c)(6)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172516C6"},{"id":18482318,"change_date":null,"inspection_id":"86047435","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939"},{"id":18482319,"change_date":null,"inspection_id":"86047435","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939T"}],"inspection_per_units":[{"id":18668245,"change_date":null,"inspection_id":"86047435","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB26699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X8GM498747","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9966821,"change_date":"2025-10-17 21:38:00","inspection_id":"86075182","dot_number":"1711586","report_state":"MN","report_number":"0025000638","insp_date":"2025-10-10 00:00:00","insp_start_time":"1117","insp_end_time":"1203","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WHITE BEAR LAKE MN","county_code_state":"MN","county_code":"123","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2422356","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-10-17 21:38:00","snet_input_date":"2025-10-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-17 21:38:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-20T10:01:40.000000Z","updated_at":"2025-10-21T10:00:11.000000Z","inspection_violations":[{"id":18482808,"change_date":null,"inspection_id":"86075182","insp_violation_id":null,"seq_no":null,"part_no":"178","part_no_section":"345-6-HMP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"1783456HMP"}],"inspection_per_units":[{"id":18746426,"change_date":null,"inspection_id":"86075182","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC12981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHAVDV8NPNM8649","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9606775,"change_date":"2025-09-06 21:33:00","inspection_id":"85699301","dot_number":"1711586","report_state":"OH","report_number":"3206000254","insp_date":"2025-09-04 00:00:00","insp_start_time":"1049","insp_end_time":"1124","registration_date":null,"region":"ED","ci_status_code":"C","location":"09","location_desc":"WADSWORTH OH","county_code_state":"OH","county_code":"103","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-06 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2228554","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-09-06 21:33:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-06 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:50.000000Z","updated_at":"2025-09-10T10:45:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18741863,"change_date":null,"inspection_id":"85699301","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB65584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX0JJ208034","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9379054,"change_date":"2025-08-11 21:38:00","inspection_id":"85457460","dot_number":"1711586","report_state":"NC","report_number":"0006785562","insp_date":"2025-08-08 00:00:00","insp_start_time":"1116","insp_end_time":"1129","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-85 S","location_desc":"I-85 SB NEAR MM 70","county_code_state":"NC","county_code":"159","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":"406","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-08-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2316756","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-08-11 21:38:00","snet_input_date":"2025-08-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-08-11 21:38:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:27.000000Z","updated_at":"2025-08-15T10:43:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18739127,"change_date":null,"inspection_id":"85457460","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"35546699","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9338784,"change_date":"2025-08-06 21:39:00","inspection_id":"85415046","dot_number":"1711586","report_state":"OH","report_number":"3276000857","insp_date":"2025-08-04 00:00:00","insp_start_time":"0855","insp_end_time":"0940","registration_date":null,"region":"ED","ci_status_code":"C","location":"SHORE","location_desc":"CLEVELAND OH","county_code_state":"OH","county_code":"035","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"8-4-25","cargo_tank":"406","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-08-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2090107","transaction_code":"A","transaction_date":"2025-08-05 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-08-06 21:39:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-06 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:13.000000Z","updated_at":"2025-08-12T10:42:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18738664,"change_date":null,"inspection_id":"85415046","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC42062","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDVXSLVN9017","insp_unit_decal":null,"insp_unit_decal_number":"35410289","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9374792,"change_date":"2025-08-11 21:37:00","inspection_id":"85452960","dot_number":"1711586","report_state":"MN","report_number":"1661000706","insp_date":"2025-08-04 00:00:00","insp_start_time":"1022","insp_end_time":"1051","registration_date":null,"region":"CD","ci_status_code":"C","location":"STCRX","location_desc":"WEST LAKELAND MN","county_code_state":"MN","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","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":"U","pen_cen_match":"I","final_status_date":"2025-08-11 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2111089","transaction_code":"A","transaction_date":"2025-08-10 00:00:00","upload_date":"2025-08-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-08-11 21:37:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-11 21:37:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:18.000000Z","updated_at":"2025-08-15T10:42:43.000000Z","inspection_violations":[{"id":18464168,"change_date":null,"inspection_id":"85452960","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393201BFR"}],"inspection_per_units":[{"id":18739078,"change_date":null,"inspection_id":"85452960","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC12981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHAVDV8NPNM864","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9235481,"change_date":"2025-07-24 21:40:00","inspection_id":"85306590","dot_number":"1711586","report_state":"NC","report_number":"0006779937","insp_date":"2025-07-23 00:00:00","insp_start_time":"1050","insp_end_time":"1145","registration_date":null,"region":"ET","ci_status_code":"C","location":"I 40 W","location_desc":"I 40 WB","county_code_state":"NC","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS, LLC","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":null,"final_status_date":"2025-07-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2310935","transaction_code":"A","transaction_date":"2025-07-23 00:00:00","upload_date":"2025-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-07-24 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-07-24 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-27T10:41:51.000000Z","updated_at":"2025-07-30T10:00:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18737423,"change_date":null,"inspection_id":"85306590","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9214229,"change_date":"2025-07-22 21:42:00","inspection_id":"85284017","dot_number":"1711586","report_state":"US","report_number":"1915000139","insp_date":"2025-07-22 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","county_code_state":"NY","county_code":"087","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2026247","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:58.000000Z","updated_at":"2025-07-27T10:40:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18737147,"change_date":null,"inspection_id":"85284017","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB70671","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X1KM615002","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9206007,"change_date":"2025-08-19 21:40:00","inspection_id":"85275474","dot_number":"1711586","report_state":"PA","report_number":"P119519888","insp_date":"2025-07-17 00:00:00","insp_start_time":"1030","insp_end_time":"1115","registration_date":"2025-08-19 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON BEAR CREEK BLVD AT ITS INTE","county_code_state":"PA","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE (IFL)","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58150","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2530655","transaction_code":"C","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-08-23T10:46:19.000000Z","inspection_violations":[{"id":18465342,"change_date":null,"inspection_id":"85275474","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS4","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS4"},{"id":18465343,"change_date":null,"inspection_id":"85275474","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18662241,"change_date":null,"inspection_id":"85275474","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB99378","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X5FM253407","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9196991,"change_date":"2025-07-20 21:33:00","inspection_id":"85265901","dot_number":"1711586","report_state":"SC","report_number":"0325002724","insp_date":"2025-07-16 00:00:00","insp_start_time":"1151","insp_end_time":"1215","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HARLEYVILLE SC","county_code_state":"SC","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IFL INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-20 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2016905","transaction_code":"A","transaction_date":"2025-07-19 00:00:00","upload_date":"2025-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-07-20 21:33:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-20 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-23T10:40:40.000000Z","updated_at":"2025-07-25T10:45:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18659283,"change_date":null,"inspection_id":"85265901","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":9161020,"change_date":"2025-07-16 21:40:00","inspection_id":"85228092","dot_number":"1711586","report_state":"TN","report_number":"I038060155","insp_date":"2025-07-14 00:00:00","insp_start_time":"1150","insp_end_time":"1210","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ROCKWOOD TN","county_code_state":"TN","county_code":"035","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":null,"cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1996311","transaction_code":"A","transaction_date":"2025-07-15 00:00:00","upload_date":"2025-07-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-07-16 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-16 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-19T10:42:28.000000Z","updated_at":"2025-07-21T10:42:05.000000Z","inspection_violations":[{"id":18460601,"change_date":null,"inspection_id":"85228092","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939AHLLH"},{"id":18460602,"change_date":null,"inspection_id":"85228092","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18658862,"change_date":null,"inspection_id":"85228092","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8941798,"change_date":"2025-06-20 21:35:00","inspection_id":"84997174","dot_number":"1711586","report_state":"OH","report_number":"1532000562","insp_date":"2025-06-18 00:00:00","insp_start_time":"1110","insp_end_time":"1149","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEWTON FALLS OH","county_code_state":"OH","county_code":"155","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-20 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1889391","transaction_code":"A","transaction_date":"2025-06-19 00:00:00","upload_date":"2025-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-06-20 21:35:00","snet_input_date":"2025-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-20 21:35:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-23T10:00:39.000000Z","updated_at":"2025-06-24T10:00:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18733883,"change_date":null,"inspection_id":"84997174","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RC02710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X1MM708637","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8891381,"change_date":"2025-06-13 21:40:00","inspection_id":"84943505","dot_number":"1711586","report_state":"SC","report_number":"0393000986","insp_date":"2025-06-09 00:00:00","insp_start_time":"1148","insp_end_time":"1235","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"RIDGEVILLE SC","county_code_state":"SC","county_code":"015","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-06-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1859672","transaction_code":"A","transaction_date":"2025-06-12 00:00:00","upload_date":"2025-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-06-13 21:40:00","snet_input_date":"2025-06-09 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-13 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-16T10:01:07.000000Z","updated_at":"2025-06-17T10:00:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18655556,"change_date":null,"inspection_id":"84943505","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8673239,"change_date":"2025-05-19 21:39:00","inspection_id":"84712621","dot_number":"1711586","report_state":"SC","report_number":"0325002618","insp_date":"2025-05-15 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HARLEYVILLE SC","county_code_state":"SC","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IFL INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"406","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-05-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1748919","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-05-19 21:39:00","snet_input_date":"2025-05-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-19 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-22T10:01:16.000000Z","updated_at":"2025-05-23T10:04:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18730383,"change_date":null,"inspection_id":"84712621","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"35279694","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8660240,"change_date":"2025-05-16 21:42:00","inspection_id":"84698818","dot_number":"1711586","report_state":"IL","report_number":"5005130041","insp_date":"2025-05-14 00:00:00","insp_start_time":"0640","insp_end_time":"0710","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-255","county_code_state":"IL","county_code":"119","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"NA","cargo_tank":"406","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":"2025-05-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"2406865","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-05-16 21:42:00","snet_input_date":"2025-05-14 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-05-16 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-19T10:04:18.000000Z","updated_at":"2025-05-20T10:06:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18652428,"change_date":null,"inspection_id":"84698818","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB65856","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0LM421333","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8499053,"change_date":"2025-04-30 21:51:00","inspection_id":"84529123","dot_number":"1711586","report_state":"NY","report_number":"SPC3040148","insp_date":"2025-04-21 00:00:00","insp_start_time":"1004","insp_end_time":"1031","registration_date":null,"region":"ED","ci_status_code":"C","location":"90777E","location_desc":"UNADILLA NY","county_code_state":"NY","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-30 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1654763","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-04-30 21:51:00","snet_input_date":"2025-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-30 21:51:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-02T13:49:44.000000Z","updated_at":"2025-05-04T10:34:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18728044,"change_date":null,"inspection_id":"84529123","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC13900","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X7KM312981","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8388117,"change_date":"2025-04-16 21:40:00","inspection_id":"84412282","dot_number":"1711586","report_state":"MD","report_number":"3277C00011","insp_date":"2025-04-15 00:00:00","insp_start_time":"0844","insp_end_time":"0859","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BALTIMORE MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1599337","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:46.000000Z","updated_at":"2025-04-20T10:23:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726505,"change_date":null,"inspection_id":"84412282","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC30188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2RLUL3650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8376806,"change_date":"2025-04-15 21:40:00","inspection_id":"84400391","dot_number":"1711586","report_state":"GA","report_number":"1227000898","insp_date":"2025-04-08 00:00:00","insp_start_time":"0900","insp_end_time":"0943","registration_date":null,"region":"ED","ci_status_code":"C","location":"267","location_desc":"RINGGOLD GA","county_code_state":"GA","county_code":"047","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"482025","cargo_tank":"406","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1595024","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:40.000000Z","updated_at":"2025-04-19T10:14:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18726413,"change_date":null,"inspection_id":"84400391","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8233685,"change_date":"2025-03-28 21:40:00","inspection_id":"84249619","dot_number":"1711586","report_state":"NY","report_number":"D507500843","insp_date":"2025-03-24 00:00:00","insp_start_time":"0942","insp_end_time":"1005","registration_date":null,"region":"ED","ci_status_code":"C","location":"40714E","location_desc":"CHURCHVILLE NY","county_code_state":"NY","county_code":"055","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS , LLC","shipping_paper_number":null,"cargo_tank":"406","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-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","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":"1522460","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-28 21:40:00","snet_input_date":"2025-03-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-28 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-31T10:32:16.000000Z","updated_at":"2025-04-01T10:12:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18724660,"change_date":null,"inspection_id":"84249619","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB50148","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXP0X7HJ167873","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8186603,"change_date":"2025-03-23 21:33:00","inspection_id":"84200165","dot_number":"1711586","report_state":"TN","report_number":"I033AG1818","insp_date":"2025-03-21 00:00:00","insp_start_time":"1951","insp_end_time":"2012","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IFL INNOVATIVE FLUIDS, LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-23 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1503572","transaction_code":"A","transaction_date":"2025-03-23 00:00:00","upload_date":"2025-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-23 21:33:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-23 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-26T10:00:57.000000Z","updated_at":"2025-03-27T10:00:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18723931,"change_date":null,"inspection_id":"84200165","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8189138,"change_date":"2025-03-24 21:39:00","inspection_id":"84202817","dot_number":"1711586","report_state":"MN","report_number":"1611000564","insp_date":"2025-03-18 00:00:00","insp_start_time":"0715","insp_end_time":"0741","registration_date":null,"region":"CD","ci_status_code":"C","location":"CRLTNN","location_desc":"CLOQUET MN","county_code_state":"MN","county_code":"017","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"310","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":"U","pen_cen_match":"I","final_status_date":"2025-03-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1505841","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-24 21:39:00","snet_input_date":"2025-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-24 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:01.000000Z","updated_at":"2025-03-28T10:12:21.000000Z","inspection_violations":[{"id":18443744,"change_date":null,"inspection_id":"84202817","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":18646228,"change_date":null,"inspection_id":"84202817","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB87237","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4LM650862","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8253049,"change_date":"2025-03-31 21:40:00","inspection_id":"84270182","dot_number":"1711586","report_state":"US","report_number":"2024000029","insp_date":"2025-03-17 00:00:00","insp_start_time":"1130","insp_end_time":"1210","registration_date":null,"region":"ED","ci_status_code":"C","location":"005","location_desc":"HARLEYVILLE SC","county_code_state":"SC","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IFL","shipping_paper_number":"31525","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1535821","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-31 21:40:00","snet_input_date":"2025-03-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-31 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-03T10:04:20.000000Z","updated_at":"2025-04-04T10:17:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18647055,"change_date":null,"inspection_id":"84270182","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8119892,"change_date":"2025-03-14 21:40:00","inspection_id":"84129893","dot_number":"1711586","report_state":"NJ","report_number":"SPMEI01306","insp_date":"2025-03-13 00:00:00","insp_start_time":"0828","insp_end_time":"0900","registration_date":null,"region":"ET","ci_status_code":"C","location":"1103","location_desc":"HAMILTON TOWNSHIP","county_code_state":"NJ","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1273016","transaction_code":"A","transaction_date":"2025-03-13 00:00:00","upload_date":"2025-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-14 21:40:00","snet_input_date":"2025-03-13 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-03-14 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:55.000000Z","updated_at":"2025-03-17T21:06:55.000000Z","inspection_violations":[{"id":18442422,"change_date":null,"inspection_id":"84129893","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLTCD","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":18645203,"change_date":null,"inspection_id":"84129893","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC13699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X3NM811947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8097597,"change_date":"2025-03-24 21:40:00","inspection_id":"84106449","dot_number":"1711586","report_state":"PA","report_number":"E951507011","insp_date":"2025-03-11 00:00:00","insp_start_time":"0817","insp_end_time":"0920","registration_date":"2025-03-24 00:00:00","region":"ET","ci_status_code":"C","location":"090","location_desc":"I90 WB MM 46 NORTH EAST TWP -","county_code_state":"PA","county_code":"049","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS, LLC","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2500851","transaction_code":"C","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-11 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:19.000000Z","updated_at":"2025-03-28T10:13:08.000000Z","inspection_violations":[{"id":18442109,"change_date":null,"inspection_id":"84106449","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DB"},{"id":18442110,"change_date":null,"inspection_id":"84106449","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18442111,"change_date":null,"inspection_id":"84106449","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353BB"},{"id":18442112,"change_date":null,"inspection_id":"84106449","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3965BL"}],"inspection_per_units":[{"id":18722730,"change_date":null,"inspection_id":"84106449","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"RA56403","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X9KM312982","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8077247,"change_date":"2025-03-11 21:40:00","inspection_id":"84085018","dot_number":"1711586","report_state":"NY","report_number":"SPC3010537","insp_date":"2025-03-04 00:00:00","insp_start_time":"0958","insp_end_time":"1020","registration_date":null,"region":"ES","ci_status_code":"C","location":"60585E","location_desc":"NICHOLS NY","county_code_state":"NY","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1454196","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18644692,"change_date":null,"inspection_id":"84085018","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH N","insp_unit_company":null,"insp_unit_license":"RB75363","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0KM312983","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8077216,"change_date":"2025-03-11 21:40:00","inspection_id":"84084986","dot_number":"1711586","report_state":"MN","report_number":"0485000433","insp_date":"2025-03-04 00:00:00","insp_start_time":"0808","insp_end_time":"0937","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"ORONOCO MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"U","pen_cen_match":"I","final_status_date":"2025-03-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1454190","transaction_code":"A","transaction_date":"2025-03-11 00:00:00","upload_date":"2025-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-11 21:40:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-11 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:53.000000Z","updated_at":"2025-03-17T21:05:53.000000Z","inspection_violations":[{"id":18441738,"change_date":null,"inspection_id":"84084986","insp_violation_id":null,"seq_no":null,"part_no":"173","part_no_section":"24B2-HMRAMBP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"17324B2HMRAMBP"}],"inspection_per_units":[{"id":18644691,"change_date":null,"inspection_id":"84084986","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB87237","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4LM650862","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":8032849,"change_date":"2025-03-05 21:40:00","inspection_id":"84038357","dot_number":"1711586","report_state":"NC","report_number":"0006732099","insp_date":"2025-02-26 00:00:00","insp_start_time":"1030","insp_end_time":"1055","registration_date":null,"region":"ET","ci_status_code":"C","location":"NC 87","location_desc":"NC 87 NEAR NC 27","county_code_state":"NC","county_code":"085","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2266570","transaction_code":"A","transaction_date":"2025-03-04 00:00:00","upload_date":"2025-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-03-05 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-03-05 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:58.000000Z","updated_at":"2025-03-17T21:04:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18644132,"change_date":null,"inspection_id":"84038357","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC44957","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7960343,"change_date":"2025-02-26 21:40:00","inspection_id":"83962051","dot_number":"1711586","report_state":"CT","report_number":"3019006112","insp_date":"2025-02-26 00:00:00","insp_start_time":"1039","insp_end_time":"1111","registration_date":null,"region":"ET","ci_status_code":"C","location":"057S","location_desc":"GREENWICH SCALE","county_code_state":"CT","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","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-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2","hazmat_oos_total":"0","snet_sequence_id":"733323","transaction_code":"A","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-02-26 21:40:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-02-26 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:36.000000Z","updated_at":"2025-03-17T21:03:36.000000Z","inspection_violations":[{"id":18439923,"change_date":null,"inspection_id":"83962051","insp_violation_id":null,"seq_no":null,"part_no":"171","part_no_section":"21A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"17121A1"},{"id":18439924,"change_date":null,"inspection_id":"83962051","insp_violation_id":null,"seq_no":null,"part_no":"178","part_no_section":"345-6-HMP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"1783456HMP"}],"inspection_per_units":[{"id":18720882,"change_date":null,"inspection_id":"83962051","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC44254","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X3KM615003","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7975599,"change_date":"2025-05-07 21:44:00","inspection_id":"83978107","dot_number":"1711586","report_state":"TN","report_number":"I01R290612","insp_date":"2025-02-25 00:00:00","insp_start_time":"1845","insp_end_time":"1908","registration_date":null,"region":"ET","ci_status_code":"C","location":"KNXEN","location_desc":"KNOX COUNTY SCALES EB","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"NO #","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1812825","transaction_code":"C","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:41.000000Z","updated_at":"2025-05-11T10:14:34.000000Z","inspection_violations":[{"id":18450226,"change_date":null,"inspection_id":"83978107","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":18728953,"change_date":null,"inspection_id":"83978107","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7890462,"change_date":"2025-02-18 21:39:00","inspection_id":"83888916","dot_number":"1711586","report_state":"GA","report_number":"1382000566","insp_date":"2025-02-11 00:00:00","insp_start_time":"0959","insp_end_time":"1114","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"FORSYTH GA","county_code_state":"GA","county_code":"207","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"2-11-25","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":"U","pen_cen_match":"I","final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1372621","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:59.000000Z","updated_at":"2025-03-17T21:01:59.000000Z","inspection_violations":[{"id":18438961,"change_date":null,"inspection_id":"83888916","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"7A-D","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3927AD"},{"id":18438962,"change_date":null,"inspection_id":"83888916","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393205CWRAWFLMIB"},{"id":18438963,"change_date":null,"inspection_id":"83888916","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"22H4-ELDBRODS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39522H4ELDBRODS"},{"id":18438964,"change_date":null,"inspection_id":"83888916","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1-BARS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3963A1BARS"}],"inspection_per_units":[{"id":18642305,"change_date":null,"inspection_id":"83888916","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB08142","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X0RM358794","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7813312,"change_date":"2025-02-07 21:40:00","inspection_id":"83807926","dot_number":"1711586","report_state":"MD","report_number":"2093008112","insp_date":"2025-02-07 00:00:00","insp_start_time":"1033","insp_end_time":"1053","registration_date":null,"region":"ET","ci_status_code":"C","location":"059","location_desc":"RT 50 @ VIENNA SCALE HOUSE","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2778424","transaction_code":"A","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1MDS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:21.000000Z","updated_at":"2025-03-17T21:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18641356,"change_date":null,"inspection_id":"83807926","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC30188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2RLUL3650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7803588,"change_date":"2025-02-06 21:40:00","inspection_id":"83797702","dot_number":"1711586","report_state":"NJ","report_number":"SPPXI03994","insp_date":"2025-02-05 00:00:00","insp_start_time":"1119","insp_end_time":"1146","registration_date":null,"region":"ET","ci_status_code":"C","location":"1821","location_desc":"WATCHUNG BOROUGH","county_code_state":"NJ","county_code":"035","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"GENERIC","cargo_tank":"NON","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1263580","transaction_code":"A","transaction_date":"2025-02-05 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-02-06 21:40:00","snet_input_date":"2025-02-05 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-02-06 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:18.000000Z","updated_at":"2025-03-17T21:00:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18641221,"change_date":null,"inspection_id":"83797702","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC13699","insp_unit_license_state":"MN","insp_unit_vehicle_id_number":"2NP3LJ0X3NM811947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7669941,"change_date":"2025-01-21 21:39:00","inspection_id":"83657312","dot_number":"1711586","report_state":"NJ","report_number":"SPRLI01540","insp_date":"2025-01-20 00:00:00","insp_start_time":"0938","insp_end_time":"0955","registration_date":null,"region":"ET","ci_status_code":"C","location":"2107","location_desc":"GREENWICH WB SCALE","county_code_state":"NJ","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1259287","transaction_code":"A","transaction_date":"2025-01-20 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-20 00:00:00","source_office":"1NJS001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:27.000000Z","updated_at":"2025-03-17T20:57:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18717111,"change_date":null,"inspection_id":"83657312","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC13699","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X3NM811947","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7672995,"change_date":"2025-01-21 21:40:00","inspection_id":"83660499","dot_number":"1711586","report_state":"PA","report_number":"E940501763","insp_date":"2025-01-17 00:00:00","insp_start_time":"1120","insp_end_time":"1210","registration_date":null,"region":"ET","ci_status_code":"C","location":"127","location_desc":"SR0015 TIOGA TWP - PA WELCOME","county_code_state":"PA","county_code":"117","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"406","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-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2492496","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":18435428,"change_date":null,"inspection_id":"83660499","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18435429,"change_date":null,"inspection_id":"83660499","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53B-B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353BB"}],"inspection_per_units":[{"id":18639461,"change_date":null,"inspection_id":"83660499","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":null,"insp_unit_license":"RB75363","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0KM312983","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7648169,"change_date":"2025-01-17 21:39:00","inspection_id":"83634304","dot_number":"1711586","report_state":"NY","report_number":"D507801131","insp_date":"2025-01-15 00:00:00","insp_start_time":"1357","insp_end_time":"1452","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"406","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-01-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1259924","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-01-17 21:39:00","snet_input_date":"2025-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-17 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:01.000000Z","updated_at":"2025-03-17T20:57:01.000000Z","inspection_violations":[{"id":18435050,"change_date":null,"inspection_id":"83634304","insp_violation_id":null,"seq_no":null,"part_no":"173","part_no_section":"24B2-HMBPMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"17324B2HMBPMC"},{"id":18435051,"change_date":null,"inspection_id":"83634304","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"},{"id":18435052,"change_date":null,"inspection_id":"83634304","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALSLIWR"}],"inspection_per_units":[{"id":18716809,"change_date":null,"inspection_id":"83634304","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB75363","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0KM312983","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7634215,"change_date":"2025-05-07 21:45:00","inspection_id":"83619657","dot_number":"1711586","report_state":"TN","report_number":"I023K21084","insp_date":"2025-01-14 00:00:00","insp_start_time":"0913","insp_end_time":"0941","registration_date":null,"region":"CT","ci_status_code":"C","location":"UNK","location_desc":"INTERSTATE 24","county_code_state":"TN","county_code":"149","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1801279","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2025-01-16 21:40:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-01-16 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:34.000000Z","updated_at":"2025-05-11T10:17:08.000000Z","inspection_violations":[{"id":18450256,"change_date":null,"inspection_id":"83619657","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"80-TEXTING","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39280TEXTING"}],"inspection_per_units":[{"id":18728995,"change_date":null,"inspection_id":"83619657","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RA28770","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"2NP3LJ0XXKM615001","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7565690,"change_date":"2025-01-07 21:40:00","inspection_id":"83547751","dot_number":"1711586","report_state":"IA","report_number":"000P14RQ0V","insp_date":"2025-01-06 00:00:00","insp_start_time":"1400","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 218 ST PAUL","county_code_state":"IA","county_code":"111","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS","shipping_paper_number":"986186","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":"2025-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1344782","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:15.000000Z","updated_at":"2025-03-17T20:55:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18715634,"change_date":null,"inspection_id":"83547751","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC26207","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2PLUF8072","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7473852,"change_date":"2024-12-20 21:40:00","inspection_id":"83451300","dot_number":"1711586","report_state":"PA","report_number":"E927435386","insp_date":"2024-12-18 00:00:00","insp_start_time":"1040","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"EXIT 1 ON RAMP SR 309 SOUTH","county_code_state":"PA","county_code":"079","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"IFL","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58180","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":"2485686","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-12-20 21:40:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-12-20 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:58.000000Z","updated_at":"2025-03-17T20:51:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18714288,"change_date":null,"inspection_id":"83451300","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB12502","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4FM266908","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7491941,"change_date":"2024-12-24 21:34:00","inspection_id":"83470354","dot_number":"1711586","report_state":"NY","report_number":"SPD3070257","insp_date":"2024-12-17 00:00:00","insp_start_time":"1000","insp_end_time":"1021","registration_date":null,"region":"ES","ci_status_code":"C","location":"70877","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-12-24 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1189960","transaction_code":"A","transaction_date":"2024-12-24 00:00:00","upload_date":"2024-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-12-24 21:34:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-24 21:34:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:52:20.000000Z","updated_at":"2025-03-17T20:52:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18714519,"change_date":null,"inspection_id":"83470354","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":null,"insp_unit_license":"RC13900","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X7KM312981","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7445863,"change_date":"2024-12-18 21:40:00","inspection_id":"83421883","dot_number":"1711586","report_state":"VA","report_number":"8031000486","insp_date":"2024-12-13 00:00:00","insp_start_time":"1345","insp_end_time":"1419","registration_date":null,"region":"ES","ci_status_code":"C","location":"037","location_desc":"ROCKVILLE VA","county_code_state":"VA","county_code":"075","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","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-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1169802","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:31.000000Z","updated_at":"2025-03-17T20:51:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18713898,"change_date":null,"inspection_id":"83421883","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC20591","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"2NK5LJ0X9PM250574","insp_unit_decal":null,"insp_unit_decal_number":"34608866","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7444631,"change_date":"2024-12-18 21:40:00","inspection_id":"83420591","dot_number":"1711586","report_state":"GA","report_number":"1213000039","insp_date":"2024-12-11 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"COVINGTON GA","county_code_state":"GA","county_code":"217","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IFL","shipping_paper_number":"MULTI","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":"U","pen_cen_match":"I","final_status_date":"2024-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1168521","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-12-18 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:31.000000Z","updated_at":"2025-03-17T20:51:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18713879,"change_date":null,"inspection_id":"83420591","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB08142","insp_unit_license_state":"GA","insp_unit_vehicle_id_number":"2NK5LJ0X0RM358794","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7216354,"change_date":"2024-11-18 21:40:00","inspection_id":"83180169","dot_number":"1711586","report_state":"SC","report_number":"0352002388","insp_date":"2024-11-18 00:00:00","insp_start_time":"0858","insp_end_time":"0931","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"TIMMONSVILLE SC","county_code_state":"SC","county_code":"041","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IFL","shipping_paper_number":"11182024","cargo_tank":"406","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-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1066218","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:29.000000Z","updated_at":"2025-03-17T20:46:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18633095,"change_date":null,"inspection_id":"83180169","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RC02710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X1MM708637","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7206360,"change_date":"2024-11-15 21:43:00","inspection_id":"83169565","dot_number":"1711586","report_state":"PA","report_number":"XL00069238","insp_date":"2024-11-14 00:00:00","insp_start_time":"1010","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"SR 611 OLD YORK ROAD AT THE FA","county_code_state":"PA","county_code":"091","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2477859","transaction_code":"A","transaction_date":"2024-11-14 00:00:00","upload_date":"2024-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-11-15 21:43:00","snet_input_date":"2024-11-14 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-11-15 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:26.000000Z","updated_at":"2025-03-17T20:46:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18710570,"change_date":null,"inspection_id":"83169565","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB12502","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4FM266908","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7160220,"change_date":"2024-11-09 21:33:00","inspection_id":"83120678","dot_number":"1711586","report_state":"IN","report_number":"6665006235","insp_date":"2024-11-04 00:00:00","insp_start_time":"0745","insp_end_time":"0825","registration_date":null,"region":"ES","ci_status_code":"C","location":"4274W","location_desc":"WEST HARRISON IN","county_code_state":"IN","county_code":"029","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS","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":"U","pen_cen_match":"I","final_status_date":"2024-11-09 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1037253","transaction_code":"A","transaction_date":"2024-11-09 00:00:00","upload_date":"2024-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-11-09 21:33:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-09 21:33:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:31.000000Z","updated_at":"2025-03-17T20:45:31.000000Z","inspection_violations":[{"id":18427338,"change_date":null,"inspection_id":"83120678","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":18632284,"change_date":null,"inspection_id":"83120678","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB95639","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X4GM498745","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7102408,"change_date":"2024-11-01 21:39:00","inspection_id":"83059476","dot_number":"1711586","report_state":"IN","report_number":"9288005956","insp_date":"2024-10-31 00:00:00","insp_start_time":"0835","insp_end_time":"0920","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CHESTERTON IN","county_code_state":"IN","county_code":"127","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2024-11-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1011716","transaction_code":"A","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-11-01 21:39:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-01 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:14.000000Z","updated_at":"2025-03-17T20:44:14.000000Z","inspection_violations":[{"id":18426329,"change_date":null,"inspection_id":"83059476","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817E2-HMHC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817E2HMHC"},{"id":18426330,"change_date":null,"inspection_id":"83059476","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"38323A2LCDL"}],"inspection_per_units":[{"id":18631513,"change_date":null,"inspection_id":"83059476","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC22063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKAD49X6GJ482921","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":7059914,"change_date":"2024-10-28 21:39:00","inspection_id":"83014447","dot_number":"1711586","report_state":"MD","report_number":"2099006464","insp_date":"2024-10-28 00:00:00","insp_start_time":"0813","insp_end_time":"0833","registration_date":null,"region":"ET","ci_status_code":"C","location":"059","location_desc":"RT 50 @ VIENNA SCALE HOUSE","county_code_state":"MD","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":"NON","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":"N","pen_cen_match":null,"final_status_date":"2024-10-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2757050","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-28 21:39:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-10-28 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:05.000000Z","updated_at":"2025-03-17T20:43:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18630896,"change_date":null,"inspection_id":"83014447","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC30188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2RLUL3650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913063,"change_date":"2024-10-08 21:42:00","inspection_id":"82858394","dot_number":"1711586","report_state":"MI","report_number":"MORGZ03325","insp_date":"2024-10-08 00:00:00","insp_start_time":"0755","insp_end_time":"0823","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"RICHARDS BLV NEAR SQUIRES","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1","cargo_tank":"406","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-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1197412","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18706565,"change_date":null,"inspection_id":"82858394","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC42060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZLP0X2SJ137621","insp_unit_decal":null,"insp_unit_decal_number":"33684451","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913064,"change_date":"2024-10-08 21:42:00","inspection_id":"82858395","dot_number":"1711586","report_state":"MI","report_number":"MORGZ03326","insp_date":"2024-10-08 00:00:00","insp_start_time":"0823","insp_end_time":"0843","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"RICHARDS BLV NEAR SQUIRES","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1","cargo_tank":"406","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-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1197472","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18706566,"change_date":null,"inspection_id":"82858395","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC12981","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHAVDV8NPNM864","insp_unit_decal":null,"insp_unit_decal_number":"33123432","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913065,"change_date":"2024-10-08 21:42:00","inspection_id":"82858396","dot_number":"1711586","report_state":"MI","report_number":"MORGZ03327","insp_date":"2024-10-08 00:00:00","insp_start_time":"0843","insp_end_time":"0906","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"RICHARDS BLV NEAR SQUIRES","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1197442","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18628858,"change_date":null,"inspection_id":"82858396","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC22083","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X9PM233371","insp_unit_decal":null,"insp_unit_decal_number":"32680103","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913066,"change_date":"2024-10-08 21:42:00","inspection_id":"82858397","dot_number":"1711586","report_state":"MI","report_number":"MORGZ03328","insp_date":"2024-10-08 00:00:00","insp_start_time":"0904","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"RICHARDS BLV NEAR SQUIRES","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"1","cargo_tank":"406","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-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1197470","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18628859,"change_date":null,"inspection_id":"82858397","insp_unit_id":"1","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC12503","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X6FM266909","insp_unit_decal":null,"insp_unit_decal_number":"34129845","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913190,"change_date":"2024-10-08 21:42:00","inspection_id":"82858528","dot_number":"1711586","report_state":"MI","report_number":"SCHMC05212","insp_date":"2024-10-08 00:00:00","insp_start_time":"0800","insp_end_time":"0824","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 SQUIRES DR","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"GEN","cargo_tank":"406","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-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1197458","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18706569,"change_date":null,"inspection_id":"82858528","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC42062","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDVXSLVN9017","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913191,"change_date":"2024-10-08 21:42:00","inspection_id":"82858529","dot_number":"1711586","report_state":"MI","report_number":"SCHMC05213","insp_date":"2024-10-08 00:00:00","insp_start_time":"0830","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 SQUIRES RD","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"GEN","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1197428","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[{"id":18422848,"change_date":null,"inspection_id":"82858529","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":18706570,"change_date":null,"inspection_id":"82858529","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC42063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZLP0X4SJ137622","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6913192,"change_date":"2024-10-08 21:42:00","inspection_id":"82858530","dot_number":"1711586","report_state":"MI","report_number":"SCHMC05214","insp_date":"2024-10-08 00:00:00","insp_start_time":"0845","insp_end_time":"0913","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 SQUIRES DR","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"GEN","cargo_tank":"NON","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":"N","pen_cen_match":null,"final_status_date":"2024-10-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1197408","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-08 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-08 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:15.000000Z","updated_at":"2025-03-17T20:40:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18628860,"change_date":null,"inspection_id":"82858530","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"TEMP","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"5KKHBPDV6RLUY3354","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6923553,"change_date":"2024-10-09 21:42:00","inspection_id":"82869526","dot_number":"1711586","report_state":"MI","report_number":"SCHMC05215","insp_date":"2024-10-08 00:00:00","insp_start_time":"0915","insp_end_time":"0933","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"415 SQUIRES RD","county_code_state":"MI","county_code":"115","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1197583","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":"01711586","upload_search_indicator":null,"census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","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":18629015,"change_date":null,"inspection_id":"82869526","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RA28771","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FVACXDC45HV55409","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6817691,"change_date":"2024-09-25 21:41:00","inspection_id":"82757161","dot_number":"1711586","report_state":"IA","report_number":"000P13PH7T","insp_date":"2024-09-24 00:00:00","insp_start_time":"1129","insp_end_time":"1155","registration_date":null,"region":"CT","ci_status_code":"C","location":"01","location_desc":"01 - I80 WB MM 151 MITCHELLVIL","county_code_state":"IA","county_code":"099","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"01","cargo_tank":"406","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-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1330910","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-24 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18705269,"change_date":null,"inspection_id":"82757161","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC26207","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2PLUF8072","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6769557,"change_date":"2024-09-19 21:42:00","inspection_id":"82705675","dot_number":"1711586","report_state":"IL","report_number":"5002840046","insp_date":"2024-09-18 00:00:00","insp_start_time":"0855","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-90","county_code_state":"IL","county_code":"201","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"NONE","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2358043","transaction_code":"A","transaction_date":"2024-09-18 00:00:00","upload_date":"2024-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-09-19 21:42:00","snet_input_date":"2024-09-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-19 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:20.000000Z","updated_at":"2025-03-17T20:37:20.000000Z","inspection_violations":[{"id":18420249,"change_date":null,"inspection_id":"82705675","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":18704616,"change_date":null,"inspection_id":"82705675","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC06310","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X2KM312984","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6600662,"change_date":"2024-10-15 21:43:00","inspection_id":"82526051","dot_number":"1711586","report_state":"OH","report_number":"3288017471","insp_date":"2024-08-29 00:00:00","insp_start_time":"1125","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"16571","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"165","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1752532","transaction_code":"C","transaction_date":"2024-10-15 00:00:00","upload_date":"2024-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:01.000000Z","updated_at":"2025-03-17T20:34:01.000000Z","inspection_violations":[{"id":18417221,"change_date":null,"inspection_id":"82526051","insp_violation_id":null,"seq_no":null,"part_no":"173","part_no_section":"24C1I-HMBPSP","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"17324C1IHMBPSP"}],"inspection_per_units":[{"id":18702297,"change_date":null,"inspection_id":"82526051","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC42060","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZLP0X2SJ137621","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6598988,"change_date":"2024-08-29 21:43:00","inspection_id":"82524272","dot_number":"1711586","report_state":"OH","report_number":"3206303976","insp_date":"2024-08-28 00:00:00","insp_start_time":"1147","insp_end_time":"1237","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"035","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":"406","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-08-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1749708","transaction_code":"A","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-08-29 21:43:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-29 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:42.000000Z","updated_at":"2025-03-17T20:33:42.000000Z","inspection_violations":[{"id":18417213,"change_date":null,"inspection_id":"82524272","insp_violation_id":null,"seq_no":null,"part_no":"180","part_no_section":"415(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"180415B"}],"inspection_per_units":[{"id":18624628,"change_date":null,"inspection_id":"82524272","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC27379","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV4RLUL3648","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6445480,"change_date":"2024-08-12 21:43:00","inspection_id":"82360598","dot_number":"1711586","report_state":"OH","report_number":"3237016582","insp_date":"2024-08-12 00:00:00","insp_start_time":"1402","insp_end_time":"1442","registration_date":null,"region":"ET","ci_status_code":"C","location":"089","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"089","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"IFL INNOVATIVE FLUIDS LLC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1746984","transaction_code":"A","transaction_date":"2024-08-12 00:00:00","upload_date":"2024-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-08-12 21:43:00","snet_input_date":"2024-08-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-08-12 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:40.000000Z","updated_at":"2025-03-17T20:30:40.000000Z","inspection_violations":[{"id":18414206,"change_date":null,"inspection_id":"82360598","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":18700245,"change_date":null,"inspection_id":"82360598","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RC42063","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZLP0X4SJ137622","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6399679,"change_date":"2024-08-06 21:43:00","inspection_id":"82311452","dot_number":"1711586","report_state":"MO","report_number":"3698001134","insp_date":"2024-08-06 00:00:00","insp_start_time":"1129","insp_end_time":"1206","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ST. LOUIS MO","county_code_state":"MO","county_code":"510","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NA","cargo_tank":"406","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-06 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"723256","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-08-06 21:43:00","snet_input_date":"2024-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-06 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:33.000000Z","updated_at":"2025-03-17T20:29:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18621929,"change_date":null,"inspection_id":"82311452","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH M","insp_unit_company":null,"insp_unit_license":"RB96775","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0MM451370","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6385642,"change_date":"2024-08-05 21:42:00","inspection_id":"82296474","dot_number":"1711586","report_state":"MO","report_number":"3512000460","insp_date":"2024-07-31 00:00:00","insp_start_time":"1400","insp_end_time":"1459","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FLORISSANT MO","county_code_state":"MO","county_code":null,"insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"LOAD SHEET 07\/3","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-08-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"714330","transaction_code":"A","transaction_date":"2024-08-04 00:00:00","upload_date":"2024-08-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-08-05 21:42:00","snet_input_date":"2024-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-05 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:28.000000Z","updated_at":"2025-03-17T20:29:28.000000Z","inspection_violations":[{"id":18412944,"change_date":null,"inspection_id":"82296474","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"817A-HMPSPMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177817AHMPSPMC"},{"id":18412945,"change_date":null,"inspection_id":"82296474","insp_violation_id":null,"seq_no":null,"part_no":"177","part_no_section":"823A-HMTVMCMID","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"177823AHMTVMCMID"},{"id":18412946,"change_date":null,"inspection_id":"82296474","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"104C-C","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393104CC"},{"id":18412947,"change_date":null,"inspection_id":"82296474","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":18699444,"change_date":null,"inspection_id":"82296474","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB96775","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0MM451370","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6347081,"change_date":"2024-07-30 21:43:00","inspection_id":"82255166","dot_number":"1711586","report_state":"NC","report_number":"0006671019","insp_date":"2024-07-30 00:00:00","insp_start_time":"1115","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-85 S","location_desc":"I-85 S","county_code_state":"NC","county_code":"057","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUID","shipping_paper_number":null,"cargo_tank":"406","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-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"2204570","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:40.000000Z","updated_at":"2025-03-17T20:28:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18698937,"change_date":null,"inspection_id":"82255166","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RC02710","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X1MM708637","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6170660,"change_date":"2024-07-09 21:42:00","inspection_id":"82066146","dot_number":"1711586","report_state":"MN","report_number":"1611000153","insp_date":"2024-07-03 00:00:00","insp_start_time":"0715","insp_end_time":"0739","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"CARLTON MN","county_code_state":"MN","county_code":"017","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"636517","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-07-09 21:42:00","snet_input_date":"2024-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-09 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:25:01.000000Z","updated_at":"2025-03-17T20:25:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18618821,"change_date":null,"inspection_id":"82066146","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB87237","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4LM650862","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6081227,"change_date":"2024-06-26 21:43:00","inspection_id":"81970015","dot_number":"1711586","report_state":"MD","report_number":"2512005954","insp_date":"2024-06-26 00:00:00","insp_start_time":"0951","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"041","location_desc":"CARROLL COUNTY","county_code_state":"MD","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"64","cargo_tank":"406","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":"N","pen_cen_match":null,"final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"2728907","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-26 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:20.000000Z","updated_at":"2025-03-17T20:23:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18617614,"change_date":null,"inspection_id":"81970015","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC30188","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2RLUL3650","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":6080559,"change_date":"2024-06-26 21:43:00","inspection_id":"81969302","dot_number":"1711586","report_state":"WV","report_number":"PSC0700280","insp_date":"2024-06-17 00:00:00","insp_start_time":"1224","insp_end_time":"1249","registration_date":null,"region":"ED","ci_status_code":"C","location":"I077SB","location_desc":"MINERALWELLS WV","county_code_state":"WV","county_code":"107","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"34","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":"U","pen_cen_match":"I","final_status_date":"2024-06-26 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"79200","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":"603685","transaction_code":"A","transaction_date":"2024-06-26 00:00:00","upload_date":"2024-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-06-26 21:43:00","snet_input_date":"2024-06-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-26 21:43:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:20.000000Z","updated_at":"2025-03-17T20:23:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18695303,"change_date":null,"inspection_id":"81969302","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RB65584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX0JJ208034","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5930564,"change_date":"2024-06-06 21:41:00","inspection_id":"81807105","dot_number":"1711586","report_state":"OH","report_number":"3244017574","insp_date":"2024-06-06 00:00:00","insp_start_time":"0820","insp_end_time":"0915","registration_date":null,"region":"ET","ci_status_code":"C","location":"165071","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1731737","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-06 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:16.000000Z","updated_at":"2025-03-17T20:20:16.000000Z","inspection_violations":[{"id":18404416,"change_date":null,"inspection_id":"81807105","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347A"},{"id":18404417,"change_date":null,"inspection_id":"81807105","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39347E"},{"id":18404418,"change_date":null,"inspection_id":"81807105","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":18693051,"change_date":null,"inspection_id":"81807105","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB12503","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X6FM266909","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5969201,"change_date":"2024-06-12 21:41:00","inspection_id":"81848962","dot_number":"1711586","report_state":"MN","report_number":"0254000099","insp_date":"2024-06-06 00:00:00","insp_start_time":"1004","insp_end_time":"1057","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ORONOCO MN","county_code_state":"MN","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"563362","transaction_code":"A","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-06-12 21:41:00","snet_input_date":"2024-06-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-12 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:04.000000Z","updated_at":"2025-03-17T20:21:04.000000Z","inspection_violations":[{"id":18405194,"change_date":null,"inspection_id":"81848962","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"328D-HMM","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172328DHMM"},{"id":18405195,"change_date":null,"inspection_id":"81848962","insp_violation_id":null,"seq_no":null,"part_no":"173","part_no_section":"24B1-HMBPMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"17324B1HMBPMC"},{"id":18405196,"change_date":null,"inspection_id":"81848962","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"201B-FR","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"393201BFR"},{"id":18405197,"change_date":null,"inspection_id":"81848962","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39345DB"}],"inspection_per_units":[{"id":18615891,"change_date":null,"inspection_id":"81848962","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB87237","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X4LM650862","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5885538,"change_date":"2024-05-31 21:39:00","inspection_id":"81757827","dot_number":"1711586","report_state":"IA","report_number":"000P15H5ZV","insp_date":"2024-05-30 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 61 NB @ 63RD ST","county_code_state":"IA","county_code":"097","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":"7454","cargo_tank":"406","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-05-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1315131","transaction_code":"A","transaction_date":"2024-05-31 00:00:00","upload_date":"2024-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2024-05-31 21:39:00","snet_input_date":"2024-05-30 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-05-31 21:39:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:26.000000Z","updated_at":"2025-03-17T20:19:26.000000Z","inspection_violations":[{"id":18403512,"change_date":null,"inspection_id":"81757827","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"502(a)(1)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172502A1"},{"id":18403513,"change_date":null,"inspection_id":"81757827","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":18692420,"change_date":null,"inspection_id":"81757827","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"RC26207","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5KKHBPDV2PLUF8072","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5904667,"change_date":"2024-06-04 21:41:00","inspection_id":"81778812","dot_number":"1711586","report_state":"TN","report_number":"I039080334","insp_date":"2024-05-29 00:00:00","insp_start_time":"1815","insp_end_time":"1835","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"536723","transaction_code":"A","transaction_date":"2024-06-04 00:00:00","upload_date":"2024-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-06-04 21:41:00","snet_input_date":"2024-05-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-06-04 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:49.000000Z","updated_at":"2025-03-17T20:19:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18614948,"change_date":null,"inspection_id":"81778812","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5850006,"change_date":"2024-05-28 21:42:00","inspection_id":"81719516","dot_number":"1711586","report_state":"NY","report_number":"SPA0340944","insp_date":"2024-05-23 00:00:00","insp_start_time":"1011","insp_end_time":"1133","registration_date":null,"region":"ET","ci_status_code":"C","location":"50011","location_desc":"BEMUS POINT REST AREA","county_code_state":"NY","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"INNOVATIVE FLUIDS LLC","shipping_paper_number":null,"cargo_tank":"406","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-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"2926251","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":"M","census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:40.000000Z","updated_at":"2025-03-17T20:18:40.000000Z","inspection_violations":[{"id":18402834,"change_date":null,"inspection_id":"81719516","insp_violation_id":null,"seq_no":null,"part_no":"178","part_no_section":"345-8(d)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"1783458D"}],"inspection_per_units":[{"id":18614232,"change_date":null,"inspection_id":"81719516","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB50148","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZXP0X7HJ167873","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5726346,"change_date":"2024-05-13 21:41:00","inspection_id":"81585439","dot_number":"1711586","report_state":"TN","report_number":"I033C10505","insp_date":"2024-05-07 00:00:00","insp_start_time":"0831","insp_end_time":"0846","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXWS","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"IFL INNOVATIVE","shipping_paper_number":"59","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"474881","transaction_code":"A","transaction_date":"2024-05-13 00:00:00","upload_date":"2024-05-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-05-13 21:41:00","snet_input_date":"2024-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-13 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:17.000000Z","updated_at":"2025-03-17T20:16:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18690039,"change_date":null,"inspection_id":"81585439","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23081","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM250573","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5690687,"change_date":"2024-05-07 21:42:00","inspection_id":"81546783","dot_number":"1711586","report_state":"OH","report_number":"3217301371","insp_date":"2024-05-07 00:00:00","insp_start_time":"0850","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE US 24","county_code_state":"OH","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"46","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-05-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"1","hazmat_oos_total":"0","snet_sequence_id":"1724421","transaction_code":"A","transaction_date":"2024-05-07 00:00:00","upload_date":"2024-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-05-07 21:42:00","snet_input_date":"2024-05-07 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-05-07 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:29.000000Z","updated_at":"2025-03-17T20:15:29.000000Z","inspection_violations":[{"id":18399432,"change_date":null,"inspection_id":"81546783","insp_violation_id":null,"seq_no":null,"part_no":"172","part_no_section":"202(a)(3)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"172202A3"},{"id":18399433,"change_date":null,"inspection_id":"81546783","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":18611962,"change_date":null,"inspection_id":"81546783","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB65856","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NKHLJ0X0LM421333","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5672370,"change_date":"2024-05-06 21:42:00","inspection_id":"81526872","dot_number":"1711586","report_state":"CO","report_number":"1237500170","insp_date":"2024-04-30 00:00:00","insp_start_time":"1220","insp_end_time":"1250","registration_date":null,"region":"MD","ci_status_code":"C","location":"MOPENB","location_desc":"MONUMENT PORT OF ENTRY NB","county_code_state":"CO","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-05-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"456324","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-05-06 21:42:00","snet_input_date":"2024-04-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-06 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:06.000000Z","updated_at":"2025-03-17T20:15:06.000000Z","inspection_violations":[{"id":18399036,"change_date":null,"inspection_id":"81526872","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18611664,"change_date":null,"inspection_id":"81526872","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":null,"insp_unit_license":"RB83229","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPCLP0X6LD660754","insp_unit_decal":null,"insp_unit_decal_number":"34045202","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5616814,"change_date":"2024-04-29 21:42:00","inspection_id":"81466388","dot_number":"1711586","report_state":"IN","report_number":"5805002117","insp_date":"2024-04-24 00:00:00","insp_start_time":"0847","insp_end_time":"0950","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CICERO IN","county_code_state":"IN","county_code":"057","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"KOKOMO AUTO WORLD","shipping_paper_number":"587971","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-04-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"437688","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":"01711586","upload_search_indicator":null,"census_search_date":"2024-04-29 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-04-29 21:42:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:55.000000Z","updated_at":"2025-03-17T20:13:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18688423,"change_date":null,"inspection_id":"81466388","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":null,"insp_unit_license":"RC23570","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NK5LJ0X7PM233367","insp_unit_decal":null,"insp_unit_decal_number":"34076426","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5544230,"change_date":"2024-04-18 21:40:00","inspection_id":"81387295","dot_number":"1711586","report_state":"OH","report_number":"3206303883","insp_date":"2024-04-18 00:00:00","insp_start_time":"1404","insp_end_time":"1446","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"OH","county_code":"153","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"NONE","cargo_tank":"NON","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1719986","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-04-18 21:40:00","snet_input_date":"2024-04-18 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:44.000000Z","updated_at":"2025-03-17T20:12:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18687396,"change_date":null,"inspection_id":"81387295","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"RB65584","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKZX4EX0JJ208034","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]},{"id":5520414,"change_date":"2024-04-16 21:41:00","inspection_id":"81361256","dot_number":"1711586","report_state":"NJ","report_number":"SPOBI02280","insp_date":"2024-04-15 00:00:00","insp_start_time":"0740","insp_end_time":"0750","registration_date":null,"region":"ET","ci_status_code":"C","location":"0119","location_desc":"ATLANTIC CITY EXPRESSWAY","county_code_state":"NJ","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"1206088","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01711586","upload_search_indicator":null,"census_search_date":"2024-04-16 21:41:00","snet_input_date":"2024-04-15 00:00:00","source_office":"1NJS001","mcmis_add_date":"2024-04-16 21:41:00","insp_carrier_name":"INNOVATIVE FLUIDS LLC","insp_carrier_street":"415 SQUIRES DRIVE","insp_carrier_city":"MILAN","insp_carrier_state":"MI","insp_carrier_zip_code":"48160","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:12:18.000000Z","updated_at":"2025-03-17T20:12:18.000000Z","inspection_violations":[{"id":18395754,"change_date":null,"inspection_id":"81361256","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"2-SLLS3","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-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":18609524,"change_date":null,"inspection_id":"81361256","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"RB99378","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2NP3LJ0X5FM253407","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:15:33.000000Z","updated_at":"2026-02-08T05:15:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=1","from":1,"last_page":2,"last_page_url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=2","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=1","label":"1","page":1,"active":true},{"url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=2","label":"2","page":2,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=2","label":"Next »","page":2,"active":false}],"next_page_url":"https:\/\/searchcarriers.com\/company\/1711586\/inspections?page=2","path":"https:\/\/searchcarriers.com\/company\/1711586\/inspections","per_page":100,"prev_page_url":null,"to":100,"total":194}