{"current_page":1,"data":[{"id":12338314,"change_date":"2026-07-01 21:42:00","inspection_id":"88297601","dot_number":"1471436","report_state":"IL","report_number":"4243590222","insp_date":"2026-06-30 00:00:00","insp_start_time":"0528","insp_end_time":"0545","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-72 E\/B","county_code_state":"IL","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD METAL STAMPING","shipping_paper_number":"625148","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-07-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2484303","transaction_code":"A","transaction_date":"2026-06-30 00:00:00","upload_date":"2026-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2026-06-30 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-07-01 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-04T09:41:57.000000Z","updated_at":"2026-07-11T09:33:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21427138,"change_date":"2026-07-01 21:42:00","inspection_id":"88297601","insp_unit_id":"214405898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1059","insp_unit_license":"PWE5758","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF008HDHK8737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:17.000000Z","updated_at":"2026-07-11T09:05:29.000000Z"},{"id":21427139,"change_date":"2026-07-01 21:42:00","inspection_id":"88297601","insp_unit_id":"214405899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"TUD2018","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D9VL715316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-05T09:19:17.000000Z","updated_at":"2026-07-11T09:05:29.000000Z"}]},{"id":12261227,"change_date":"2026-06-23 21:39:00","inspection_id":"88220089","dot_number":"1471436","report_state":"TX","report_number":"V262413562","insp_date":"2026-06-16 00:00:00","insp_start_time":"0757","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:33\u00bf\u00bf 09' 29.69N","county_code_state":"TX","county_code":"449","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SAN LUIS DASUNG SA DE CV","shipping_paper_number":"260614003","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":"Y","pen_cen_match":null,"final_status_date":"2026-06-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"116000","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":"10003779","transaction_code":"A","transaction_date":"2026-06-23 00:00:00","upload_date":"2026-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-06-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-23 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":"0819097","created_at":"2026-06-26T09:40:59.000000Z","updated_at":"2026-07-04T09:31:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21291779,"change_date":"2026-06-23 21:39:00","inspection_id":"88220089","insp_unit_id":"214246554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"832042","insp_unit_license":"TRW4813","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5328NSA73069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:29.000000Z","updated_at":"2026-07-05T09:04:52.000000Z"},{"id":21291778,"change_date":"2026-06-23 21:39:00","inspection_id":"88220089","insp_unit_id":"214246553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"101105","insp_unit_license":"RC11932","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKAD48X06J094034","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-26T09:17:29.000000Z","updated_at":"2026-07-05T09:04:52.000000Z"}]},{"id":11791574,"change_date":"2026-05-04 21:39:00","inspection_id":"87723466","dot_number":"1471436","report_state":"KY","report_number":"CV44105681","insp_date":"2026-04-29 00:00:00","insp_start_time":"2239","insp_end_time":"2325","registration_date":"2026-05-04 00:00:00","region":"CT","ci_status_code":"C","location":"9814","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"METALDYNE POWERTRAIN COMPONENTS INC","shipping_paper_number":"TW19767","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-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"2343024","transaction_code":"C","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-04-30 00:00:00","source_office":"2KYS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:53.000000Z","updated_at":"2026-05-14T12:30:15.000000Z","inspection_violations":[{"id":20506139,"change_date":"2026-05-04 21:39:00","inspection_id":"87723466","insp_violation_id":"274029823","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"FH05006","created_at":"2026-05-03T10:01:52.000000Z","updated_at":"2026-05-14T12:42:59.000000Z","normalized_code":"39216AD"}],"inspection_per_units":[{"id":20511886,"change_date":"2026-05-04 21:39:00","inspection_id":"87723466","insp_unit_id":"213370770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"750","insp_unit_license":"PVX8471","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF003JDJS7500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:47.000000Z","updated_at":"2026-05-14T11:47:35.000000Z"},{"id":20511887,"change_date":"2026-05-04 21:39:00","inspection_id":"87723466","insp_unit_id":"213370771","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"TRT8846","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5326NSA69442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:47.000000Z","updated_at":"2026-05-14T11:47:35.000000Z"}]},{"id":10216663,"change_date":"2025-11-17 21:39:00","inspection_id":"86338264","dot_number":"1471436","report_state":"KY","report_number":"CV44900345","insp_date":"2025-11-17 00:00:00","insp_start_time":"1045","insp_end_time":"1129","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"GENERAL MOTORS","shipping_paper_number":"8599","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-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"0","hazmat_oos_total":"0","snet_sequence_id":"2317136","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-17 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-11-17 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:32.000000Z","updated_at":"2025-11-21T10:30:42.000000Z","inspection_violations":[{"id":16978670,"change_date":"2025-11-17 21:39:00","inspection_id":"86338264","insp_violation_id":"270001884","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"210067939","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"FC39672","created_at":"2025-11-20T10:30:53.000000Z","updated_at":"2025-11-21T10:31:09.000000Z","normalized_code":"3922SLL"},{"id":16978671,"change_date":"2025-11-17 21:39:00","inspection_id":"86338264","insp_violation_id":"270001885","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210067940","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"FC39672","created_at":"2025-11-20T10:30:53.000000Z","updated_at":"2025-11-21T10:31:09.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":17020394,"change_date":"2025-11-17 21:39:00","inspection_id":"86338264","insp_unit_id":"210067939","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"202","insp_unit_license":"RC28780","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EHXJN885560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:34.000000Z","updated_at":"2025-11-21T10:00:48.000000Z"},{"id":17020395,"change_date":"2025-11-17 21:39:00","inspection_id":"86338264","insp_unit_id":"210067940","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832024","insp_unit_license":"TRM9538","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D5LL166128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:34.000000Z","updated_at":"2025-11-21T10:00:48.000000Z"}]},{"id":10221195,"change_date":"2025-11-17 21:40:00","inspection_id":"86342977","dot_number":"1471436","report_state":"TX","report_number":"V252111377","insp_date":"2025-11-15 00:00:00","insp_start_time":"0854","insp_end_time":"0904","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"59M IH35 NB","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","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":"Y","pen_cen_match":null,"final_status_date":"2025-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9760982","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":"0819097","created_at":"2025-11-20T10:30:40.000000Z","updated_at":"2025-11-21T10:31:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17028860,"change_date":"2025-11-17 21:40:00","inspection_id":"86342977","insp_unit_id":"210078404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"PWV2816","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF005HDHS9909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:40.000000Z","updated_at":"2025-11-21T10:01:26.000000Z"},{"id":17028861,"change_date":"2025-11-17 21:40:00","inspection_id":"86342977","insp_unit_id":"210078405","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"222C827","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1JJV532D4PL382798","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:40.000000Z","updated_at":"2025-11-21T10:01:26.000000Z"}]},{"id":9320433,"change_date":"2025-08-04 21:38:00","inspection_id":"85395875","dot_number":"1471436","report_state":"MO","report_number":"5253001997","insp_date":"2025-08-01 00:00:00","insp_start_time":"1335","insp_end_time":"1356","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KANSAS CITY MO","county_code_state":"MO","county_code":"047","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"2084007","transaction_code":"A","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:47.000000Z","updated_at":"2025-08-08T10:00:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15349217,"change_date":"2025-08-04 21:38:00","inspection_id":"85395875","insp_unit_id":"208220068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":"1997","insp_unit_license":"99KS0P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ5DN140092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:25.000000Z","updated_at":"2025-08-08T09:45:33.000000Z"},{"id":15349218,"change_date":"2025-08-04 21:38:00","inspection_id":"85395875","insp_unit_id":"208220069","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WABASH NAT","insp_unit_company":"832027","insp_unit_license":"TRR1632","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1JJV532D0LL166103","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:25.000000Z","updated_at":"2025-08-08T09:45:33.000000Z"}]},{"id":8796667,"change_date":"2025-06-02 21:39:00","inspection_id":"84843139","dot_number":"1471436","report_state":"MI","report_number":"STRAL03786","insp_date":"2025-06-01 00:00:00","insp_start_time":"2011","insp_end_time":"2028","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B SCALE","county_code_state":"MI","county_code":"021","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"FORD","shipping_paper_number":"293904","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":"N","pen_cen_match":null,"final_status_date":"2025-06-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1223693","transaction_code":"A","transaction_date":"2025-06-01 00:00:00","upload_date":"2025-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-06-01 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-02 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-05T10:00:30.000000Z","updated_at":"2025-06-06T10:00:38.000000Z","inspection_violations":[{"id":14065468,"change_date":"2025-06-02 21:39:00","inspection_id":"84843139","insp_violation_id":"266613406","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4537827","created_at":"2025-06-05T10:15:42.000000Z","updated_at":"2025-06-06T10:15:56.000000Z","normalized_code":"3922SLLEWA1"}],"inspection_per_units":[{"id":14394730,"change_date":"2025-06-02 21:39:00","inspection_id":"84843139","insp_unit_id":"207184636","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832030","insp_unit_license":"TRR1634","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D0ML166216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:28.000000Z","updated_at":"2025-06-06T09:45:59.000000Z"},{"id":14394731,"change_date":"2025-06-02 21:39:00","inspection_id":"84843139","insp_unit_id":"207184637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"202","insp_unit_license":"RC28780","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4V4NC9EHXJN885560","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-05T09:45:28.000000Z","updated_at":"2025-06-06T09:45:59.000000Z"}]},{"id":8631946,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","dot_number":"1471436","report_state":"MI","report_number":"DUBOL00014","insp_date":"2025-05-13 00:00:00","insp_start_time":"1555","insp_end_time":"1730","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-94 @ SOUTHFIELD RD","county_code_state":"MI","county_code":"163","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD DEARBORN","shipping_paper_number":"780523","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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1220904","transaction_code":"A","transaction_date":"2025-05-13 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-13 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-17T10:05:19.000000Z","updated_at":"2025-05-18T10:06:05.000000Z","inspection_violations":[{"id":13726602,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_violation_id":"266220439","seq_no":"1","part_no":"393","part_no_section":"100C-C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:07.000000Z","updated_at":"2025-05-18T10:33:35.000000Z","normalized_code":"393100CC"},{"id":13726603,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_violation_id":"266220440","seq_no":"2","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"1","insp_unit_id":"206857140","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:07.000000Z","updated_at":"2025-05-18T10:33:35.000000Z","normalized_code":"3939ALRLI"},{"id":13726604,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_violation_id":"266220441","seq_no":"3","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206857140","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:07.000000Z","updated_at":"2025-05-18T10:33:35.000000Z","normalized_code":"3965BL"},{"id":13726605,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_violation_id":"266220442","seq_no":"4","part_no":"393","part_no_section":"205A-WRC","insp_viol_unit":"1","insp_unit_id":"206857140","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-18T10:27:07.000000Z","updated_at":"2025-05-18T10:33:35.000000Z","normalized_code":"393205AWRC"}],"inspection_per_units":[{"id":14095160,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_unit_id":"206857140","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1049","insp_unit_license":"PWC2200","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVXGF000GLGX5649","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:41.000000Z"},{"id":14095161,"change_date":"2025-05-14 21:42:00","inspection_id":"84669089","insp_unit_id":"206857141","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"NONE","insp_unit_license":"TRU7626","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532DXNL323039","insp_unit_decal":"Y","insp_unit_decal_number":"35167860","created_at":"2025-05-17T09:49:17.000000Z","updated_at":"2025-05-18T09:51:41.000000Z"}]},{"id":8045911,"change_date":"2025-03-06 21:39:00","inspection_id":"84051996","dot_number":"1471436","report_state":"MI","report_number":"MOREM05741","insp_date":"2025-03-05 00:00:00","insp_start_time":"1116","insp_end_time":"1148","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WILLOW HWY","county_code_state":"MI","county_code":"045","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MATTRESS FIRM","shipping_paper_number":"MN00142187","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-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118350","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":"1212330","transaction_code":"A","transaction_date":"2025-03-05 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:23.000000Z","updated_at":"2025-03-17T21:05:23.000000Z","inspection_violations":[{"id":12573894,"change_date":"2025-03-06 21:39:00","inspection_id":"84051996","insp_violation_id":"264871938","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":12989814,"change_date":"2025-03-06 21:39:00","inspection_id":"84051996","insp_unit_id":"205663117","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"371","insp_unit_license":"M6553HY","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"4V4NC9EH7KN905474","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:28.000000Z","updated_at":"2025-03-17T23:58:28.000000Z"},{"id":12989815,"change_date":"2025-03-06 21:39:00","inspection_id":"84051996","insp_unit_id":"205663118","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"7771","insp_unit_license":"918387ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532D8HL967918","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:28.000000Z","updated_at":"2025-03-17T23:58:28.000000Z"}]},{"id":7805299,"change_date":"2025-02-06 21:41:00","inspection_id":"83799507","dot_number":"1471436","report_state":"MI","report_number":"WHEES02972","insp_date":"2025-02-05 00:00:00","insp_start_time":"1130","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SB JONESVILLE RAMP","county_code_state":"MI","county_code":"023","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1209046","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":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-02-05 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-06 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:19.000000Z","updated_at":"2025-03-17T21:00:19.000000Z","inspection_violations":[{"id":12197612,"change_date":"2025-02-06 21:41:00","inspection_id":"83799507","insp_violation_id":"264378710","seq_no":"1","part_no":"392","part_no_section":"2-SLLUP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:29.000000Z","updated_at":"2025-03-17T22:05:29.000000Z","normalized_code":"3922SLLUP"}],"inspection_per_units":[{"id":12596494,"change_date":"2025-02-06 21:41:00","inspection_id":"83799507","insp_unit_id":"205194485","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PWF1181","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVXA7CG3CLBD9543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:09.000000Z","updated_at":"2025-03-17T23:54:09.000000Z"},{"id":12596495,"change_date":"2025-02-06 21:41:00","inspection_id":"83799507","insp_unit_id":"205194486","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":null,"insp_unit_license":"TTH9441","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532DXRL420022","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:09.000000Z","updated_at":"2025-03-17T23:54:09.000000Z"}]},{"id":5808256,"change_date":"2024-05-21 21:47:00","inspection_id":"81674100","dot_number":"1471436","report_state":"IL","report_number":"4178530089","insp_date":"2024-05-16 00:00:00","insp_start_time":"1542","insp_end_time":"1608","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-72 E\/B","county_code_state":"IL","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD MOTOR CO","shipping_paper_number":"232130","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-05-21 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2327778","transaction_code":"A","transaction_date":"2024-05-16 00:00:00","upload_date":"2024-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-16 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-05-21 21:47:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:52.000000Z","updated_at":"2025-03-17T20:17:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9354399,"change_date":"2024-05-21 21:47:00","inspection_id":"81674100","insp_unit_id":"201013919","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"101039","insp_unit_license":"RB73467","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYDSZB6YLA86346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:06.000000Z","updated_at":"2025-03-17T23:20:06.000000Z"},{"id":9354400,"change_date":"2024-05-21 21:47:00","inspection_id":"81674100","insp_unit_id":"201013920","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":"832049","insp_unit_license":"TTB7269","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3H3V532K2PS459043","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:06.000000Z","updated_at":"2025-03-17T23:20:06.000000Z"}]},{"id":5268952,"change_date":"2024-03-14 21:41:00","inspection_id":"81086778","dot_number":"1471436","report_state":"OH","report_number":"3288016916","insp_date":"2024-03-11 00:00:00","insp_start_time":"1310","insp_end_time":"1330","registration_date":null,"region":"ET","ci_status_code":"C","location":"16571","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"165","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FORD","shipping_paper_number":"203272","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-03-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1710843","transaction_code":"C","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-12 00:00:00","source_office":"3OHS001","mcmis_add_date":"2024-03-12 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:07:04.000000Z","updated_at":"2025-03-17T20:07:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8484858,"change_date":"2024-03-14 21:41:00","inspection_id":"81086778","insp_unit_id":"199916816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1079","insp_unit_license":"PWF1181","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVXA7CG3CLBD9543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"},{"id":8484859,"change_date":"2024-03-14 21:41:00","inspection_id":"81086778","insp_unit_id":"199916817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"832042","insp_unit_license":"TRW4813","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5328NSA73069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:52.000000Z","updated_at":"2025-03-17T23:11:52.000000Z"}]},{"id":5089511,"change_date":"2024-02-20 21:42:00","inspection_id":"80891239","dot_number":"1471436","report_state":"MI","report_number":"CHAPP04262","insp_date":"2024-02-15 00:00:00","insp_start_time":"2330","insp_end_time":"2355","registration_date":null,"region":"ET","ci_status_code":"C","location":"115","location_desc":"MONROE","county_code_state":"MI","county_code":"115","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GM","shipping_paper_number":"832043","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":"Y","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"1165511","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-15 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:28.000000Z","updated_at":"2025-03-17T20:03:28.000000Z","inspection_violations":[{"id":7845392,"change_date":"2024-02-20 21:42:00","inspection_id":"80891239","insp_violation_id":"257925349","seq_no":"1","part_no":"393","part_no_section":"25(b)","insp_viol_unit":"1","insp_unit_id":"199502328","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:56.000000Z","updated_at":"2025-03-17T21:43:56.000000Z","normalized_code":"39325B"}],"inspection_per_units":[{"id":8193696,"change_date":"2024-02-20 21:42:00","inspection_id":"80891239","insp_unit_id":"199502328","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"PWT7667","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4V4NC9EJ7GN958086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"},{"id":8193697,"change_date":"2024-02-20 21:42:00","inspection_id":"80891239","insp_unit_id":"199502329","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":null,"insp_unit_license":"TRW4814","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5324NSA73070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:15.000000Z","updated_at":"2025-03-17T23:09:15.000000Z"}]},{"id":5061412,"change_date":"2024-02-15 21:42:00","inspection_id":"80860437","dot_number":"1471436","report_state":"KY","report_number":"CV44303945","insp_date":"2024-02-14 00:00:00","insp_start_time":"1712","insp_end_time":"1743","registration_date":null,"region":"CD","ci_status_code":"C","location":"9815","location_desc":"FRANKLIN","county_code_state":"KY","county_code":"213","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"GENERAL MOTORS","shipping_paper_number":"512702","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-02-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"2209794","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-15 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-02-15 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:03.000000Z","updated_at":"2025-03-17T20:03:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8147354,"change_date":"2024-02-15 21:42:00","inspection_id":"80860437","insp_unit_id":"199443172","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"4549","insp_unit_license":"PWT7664","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4V4NC9EJ7GN958086","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:51.000000Z","updated_at":"2025-03-17T23:08:51.000000Z"},{"id":8147355,"change_date":"2024-02-15 21:42:00","inspection_id":"80860437","insp_unit_id":"199443173","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"832043","insp_unit_license":"TRW4814","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5324NSA73070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:51.000000Z","updated_at":"2025-03-17T23:08:51.000000Z"}]},{"id":4602167,"change_date":"2023-12-11 21:41:00","inspection_id":"80358310","dot_number":"1471436","report_state":"MO","report_number":"0360000052","insp_date":"2023-12-08 00:00:00","insp_start_time":"0617","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"F70","location_desc":"I 10 AT MISSOURI 5","county_code_state":"MO","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PERFECTA EXPRESS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"2092218","transaction_code":"A","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-12-11 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-12-11 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"4664 MUIRFIELD AVE","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:54:09.000000Z","updated_at":"2025-03-17T19:54:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7402100,"change_date":"2023-12-11 21:41:00","inspection_id":"80358310","insp_unit_id":"198445728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1997","insp_unit_license":"99KS0P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ5DN140092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"},{"id":7402101,"change_date":"2023-12-11 21:41:00","inspection_id":"80358310","insp_unit_id":"198445729","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832024","insp_unit_license":"TRM9538","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"1JJV532D5LL166128","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:13.000000Z","updated_at":"2025-03-17T23:02:13.000000Z"}]},{"id":4114289,"change_date":"2023-10-03 21:41:00","inspection_id":"79819922","dot_number":"1471436","report_state":"TN","report_number":"TDOV001738","insp_date":"2023-10-02 00:00:00","insp_start_time":"1202","insp_end_time":"1232","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"GILES COUNTY SCALES","county_code_state":"TN","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1678034","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-03 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:04.000000Z","updated_at":"2025-03-17T19:44:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6614882,"change_date":"2023-10-03 21:41:00","inspection_id":"79819922","insp_unit_id":"197370327","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"750","insp_unit_license":"PVX8471","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF003JDJS7500","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:29.000000Z","updated_at":"2025-03-17T22:55:29.000000Z"},{"id":6614883,"change_date":"2023-10-03 21:41:00","inspection_id":"79819922","insp_unit_id":"197370328","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HYTR","insp_unit_company":null,"insp_unit_license":"TTB7268","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3H3V532K9PS459041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:29.000000Z","updated_at":"2025-03-17T22:55:29.000000Z"}]},{"id":3686919,"change_date":"2023-08-07 21:42:00","inspection_id":"79344013","dot_number":"1471436","report_state":"OH","report_number":"3258010008","insp_date":"2023-08-07 00:00:00","insp_start_time":"0830","insp_end_time":"0846","registration_date":null,"region":"ET","ci_status_code":"C","location":"04171","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"041","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"FORD","shipping_paper_number":"602158134","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-08-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"102500","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":"1671165","transaction_code":"A","transaction_date":"2023-08-07 00:00:00","upload_date":"2023-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-08-07 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-07 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:35:40.000000Z","updated_at":"2025-03-17T19:35:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5927887,"change_date":"2023-08-07 21:42:00","inspection_id":"79344013","insp_unit_id":"196403445","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"PWA3252","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FVXGF003FLGJ7551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"},{"id":5927888,"change_date":"2023-08-07 21:42:00","inspection_id":"79344013","insp_unit_id":"196403446","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"832043","insp_unit_license":"TRW4814","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5324NSA73070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:49.000000Z","updated_at":"2025-03-17T22:49:49.000000Z"}]},{"id":3511858,"change_date":"2023-07-14 21:41:00","inspection_id":"79147443","dot_number":"1471436","report_state":"MI","report_number":"LYDEC03336","insp_date":"2023-07-12 00:00:00","insp_start_time":"1951","insp_end_time":"2009","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1135446","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-07-14 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:28.000000Z","updated_at":"2025-03-17T19:32:28.000000Z","inspection_violations":[{"id":5414531,"change_date":"2023-07-14 21:41:00","inspection_id":"79147443","insp_violation_id":"254069597","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:07.000000Z","updated_at":"2025-03-17T21:32:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5646913,"change_date":"2023-07-14 21:41:00","inspection_id":"79147443","insp_unit_id":"196008262","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"101081","insp_unit_license":"RC23671","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FUYDSEB8YLF84845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"},{"id":5646914,"change_date":"2023-07-14 21:41:00","inspection_id":"79147443","insp_unit_id":"196008263","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832041","insp_unit_license":"TRW4782","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D8NL323069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:34.000000Z","updated_at":"2025-03-17T22:47:34.000000Z"}]},{"id":3144791,"change_date":"2023-05-25 21:42:00","inspection_id":"78733856","dot_number":"1471436","report_state":"TX","report_number":"6LA70AKMMC","insp_date":"2023-05-22 00:00:00","insp_start_time":"0657","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH 35 SOUTHBOUND DEVINE","county_code_state":"TX","county_code":"325","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FORD KANSAS CITY ASSEMBLY","shipping_paper_number":"741581","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"8988657","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":"0819097","created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[{"id":4841750,"change_date":"2023-05-25 21:42:00","inspection_id":"78733856","insp_violation_id":"253088914","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195151273","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5058091,"change_date":"2023-05-25 21:42:00","inspection_id":"78733856","insp_unit_id":"195151273","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1997","insp_unit_license":"99KS0P","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ5DN140092","insp_unit_decal":"Y","insp_unit_decal_number":"32609832","created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"},{"id":5058092,"change_date":"2023-05-25 21:42:00","inspection_id":"78733856","insp_unit_id":"195151274","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832014","insp_unit_license":"TQS8919","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D4HL972422","insp_unit_decal":"Y","insp_unit_decal_number":"32609833","created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"}]},{"id":2525826,"change_date":"2023-03-07 21:41:00","inspection_id":"78032166","dot_number":"1471436","report_state":"OH","report_number":"3253016120","insp_date":"2023-03-04 00:00:00","insp_start_time":"1000","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"10371","location_desc":"ROADSIDE....","county_code_state":"OH","county_code":"103","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"1642550","transaction_code":"A","transaction_date":"2023-03-04 00:00:00","upload_date":"2023-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-07 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-03-07 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:19.000000Z","updated_at":"2025-03-17T19:13:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4065625,"change_date":"2023-03-07 21:41:00","inspection_id":"78032166","insp_unit_id":"193752393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"101037","insp_unit_license":"RC08202","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NKWGGGG70J111963","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:08.000000Z","updated_at":"2025-03-17T22:35:08.000000Z"},{"id":4065626,"change_date":"2023-03-07 21:41:00","inspection_id":"78032166","insp_unit_id":"193752394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832039","insp_unit_license":"TRR1633","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532DXML166210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:08.000000Z","updated_at":"2025-03-17T22:35:08.000000Z"}]},{"id":2500655,"change_date":"2023-03-03 21:40:00","inspection_id":"78003613","dot_number":"1471436","report_state":"TN","report_number":"TNTB005701","insp_date":"2023-03-01 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 5 I-81 GREENE SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"3","service_center":"SH","census_source_id":"4","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1632905","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-03 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-03-03 21:40:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:53.000000Z","updated_at":"2025-03-17T19:12:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4023990,"change_date":"2023-03-03 21:40:00","inspection_id":"78003613","insp_unit_id":"193696193","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"P 999640","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVXA7005DLFF2587","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"},{"id":4023991,"change_date":"2023-03-03 21:40:00","inspection_id":"78003613","insp_unit_id":"193696194","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832020","insp_unit_license":"TRJ1709","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1JJV532D0KL147551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:49.000000Z","updated_at":"2025-03-17T22:34:49.000000Z"}]},{"id":2296066,"change_date":"2023-02-03 21:41:00","inspection_id":"77770447","dot_number":"1471436","report_state":"MO","report_number":"00KB008379","insp_date":"2023-02-02 00:00:00","insp_start_time":"1511","insp_end_time":"1533","registration_date":null,"region":"CT","ci_status_code":"C","location":"A35","location_desc":"VIVION RD. AND N. COMPTON","county_code_state":"MO","county_code":"047","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"53250","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":"2056698","transaction_code":"A","transaction_date":"2023-02-02 00:00:00","upload_date":"2023-02-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-02-03 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-02-03 21:41:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:08:54.000000Z","updated_at":"2025-03-17T19:08:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3695541,"change_date":"2023-02-03 21:41:00","inspection_id":"77770447","insp_unit_id":"193224145","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":null,"insp_unit_license":"99KSOP","insp_unit_license_state":"MO","insp_unit_vehicle_id_number":"4V4NC9EJ5DN140092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:29.000000Z","updated_at":"2025-03-17T22:32:29.000000Z"}]},{"id":1671991,"change_date":"2022-11-03 21:42:00","inspection_id":"77056398","dot_number":"1471436","report_state":"TX","report_number":"6FNA0ALSS1","insp_date":"2022-10-31 00:00:00","insp_start_time":"0950","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0035 IN LA SALLE CO. (38-82","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WEBASTO","shipping_paper_number":"1892927","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8817956","transaction_code":"A","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":"0819097","created_at":"2025-03-17T18:57:26.000000Z","updated_at":"2025-03-17T18:57:26.000000Z","inspection_violations":[{"id":2623086,"change_date":"2022-11-03 21:42:00","inspection_id":"77056398","insp_violation_id":"249432803","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"191804140","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:23.000000Z","updated_at":"2025-03-17T21:19:23.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":2689852,"change_date":"2022-11-03 21:42:00","inspection_id":"77056398","insp_unit_id":"191804139","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"6","insp_unit_license":"PMV2816","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF005HDHS9909","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:25.000000Z","updated_at":"2025-03-17T22:25:25.000000Z"},{"id":2689853,"change_date":"2022-11-03 21:42:00","inspection_id":"77056398","insp_unit_id":"191804140","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GRDN","insp_unit_company":"131131","insp_unit_license":"6452KH","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GRAA062XFK242225","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:25.000000Z","updated_at":"2025-03-17T22:25:25.000000Z"}]},{"id":872173,"change_date":"2022-07-22 21:39:00","inspection_id":"76127925","dot_number":"1471436","report_state":"IA","report_number":"000P138Z5W","insp_date":"2022-07-19 00:00:00","insp_start_time":"1250","insp_end_time":"1340","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"308 MM HWY 20 EB","county_code_state":"IA","county_code":"061","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1233960","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-07-19 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-07-22 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:03.000000Z","updated_at":"2025-03-17T18:43:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1404038,"change_date":"2022-07-22 21:39:00","inspection_id":"76127925","insp_unit_id":"189914664","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"77","insp_unit_license":"P 999640","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FVXA7005DLFF2587","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:49.000000Z","updated_at":"2025-03-17T22:16:49.000000Z"},{"id":1404039,"change_date":"2022-07-22 21:39:00","inspection_id":"76127925","insp_unit_id":"189914665","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WANC","insp_unit_company":"832040","insp_unit_license":"TRU7626","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1JJV532DXNL323039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:49.000000Z","updated_at":"2025-03-17T22:16:49.000000Z"}]},{"id":799678,"change_date":"2022-07-12 21:39:00","inspection_id":"76043035","dot_number":"1471436","report_state":"MI","report_number":"DETGT03852","insp_date":"2022-07-11 00:00:00","insp_start_time":"1250","insp_end_time":"1327","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"705485","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1083449","transaction_code":"A","transaction_date":"2022-07-11 00:00:00","upload_date":"2022-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01471436","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-07-11 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-12 21:39:00","insp_carrier_name":"PERFECTA EXPRESS INC","insp_carrier_street":"3864 CENTER RD SUITE A-18","insp_carrier_city":"BRUNSWICK","insp_carrier_state":"OH","insp_carrier_zip_code":"44212","insp_colonia":null,"docket_number":"640922","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:39.000000Z","updated_at":"2025-03-17T18:41:39.000000Z","inspection_violations":[{"id":1261646,"change_date":"2022-07-12 21:39:00","inspection_id":"76043035","insp_violation_id":"247031865","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4076348","created_at":"2025-03-17T21:12:58.000000Z","updated_at":"2025-03-17T21:12:58.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1286866,"change_date":"2022-07-12 21:39:00","inspection_id":"76043035","insp_unit_id":"189725579","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1059","insp_unit_license":"PWE5758","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"3ALXGF008HDHK8737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:05.000000Z","updated_at":"2025-03-17T22:16:05.000000Z"},{"id":1286867,"change_date":"2022-07-12 21:39:00","inspection_id":"76043035","insp_unit_id":"189725580","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STOU","insp_unit_company":"832043","insp_unit_license":"TRW4814","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1DW1A5324NSA73070","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:05.000000Z","updated_at":"2025-03-17T22:16:05.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1471436\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1471436\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1471436\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1471436\/inspections","per_page":100,"prev_page_url":null,"to":25,"total":25}