{"current_page":1,"data":[{"id":10013872,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","dot_number":"3531967","report_state":"NY","report_number":"SPA3051053","insp_date":"2025-10-16 00:00:00","insp_start_time":"1423","insp_end_time":"1448","registration_date":null,"region":"ED","ci_status_code":"C","location":"50464M","location_desc":"LEWISTON NY","county_code_state":"NY","county_code":"063","insp_level_id":"2","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":"U","pen_cen_match":"I","final_status_date":"2025-10-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"2447010","transaction_code":"A","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-10-23 21:39:00","snet_input_date":"2025-10-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-23 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-26T10:01:47.000000Z","updated_at":"2025-10-27T10:00:25.000000Z","inspection_violations":[{"id":16560881,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_violation_id":"269466713","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"209611900","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-26T10:17:43.000000Z","updated_at":"2025-10-27T10:15:46.000000Z","normalized_code":"39375A3TAOL"},{"id":16560882,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_violation_id":"269466714","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"209611900","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-26T10:17:43.000000Z","updated_at":"2025-10-27T10:15:46.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":16560883,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_violation_id":"269466715","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"209611900","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-26T10:17:43.000000Z","updated_at":"2025-10-27T10:15:46.000000Z","normalized_code":"39375A3TAOL"},{"id":16560884,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_violation_id":"269466716","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209611899","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-26T10:17:43.000000Z","updated_at":"2025-10-27T10:15:46.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16635147,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_unit_id":"209611899","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"P1397792","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FD9W4HT7REC47040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:04.000000Z","updated_at":"2025-10-27T09:45:27.000000Z"},{"id":16635148,"change_date":"2025-10-23 21:39:00","inspection_id":"86124722","insp_unit_id":"209611900","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"5233798","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFW5327NL006596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-26T09:47:04.000000Z","updated_at":"2025-10-27T09:45:27.000000Z"}]},{"id":9948594,"change_date":"2025-10-15 21:39:00","inspection_id":"86056082","dot_number":"3531967","report_state":"MA","report_number":"DF00002739","insp_date":"2025-10-14 00:00:00","insp_start_time":"1604","insp_end_time":"1619","registration_date":null,"region":"ET","ci_status_code":"C","location":"044H","location_desc":"H-BRAINTREE","county_code_state":"MA","county_code":"021","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":"Y","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-10-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","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":"531421","transaction_code":"A","transaction_date":"2025-10-15 00:00:00","upload_date":"2025-10-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":"M","census_search_date":"2025-10-15 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-15 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:55.000000Z","updated_at":"2025-10-19T10:00:48.000000Z","inspection_violations":[{"id":16427417,"change_date":"2025-10-15 21:39:00","inspection_id":"86056082","insp_violation_id":"269315799","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"209483084","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-18T10:18:02.000000Z","updated_at":"2025-10-19T10:16:27.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16515877,"change_date":"2025-10-15 21:39:00","inspection_id":"86056082","insp_unit_id":"209483083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"P1317792","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FD9W4HT7REC47040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:46:00.000000Z"},{"id":16515878,"change_date":"2025-10-15 21:39:00","inspection_id":"86056082","insp_unit_id":"209483084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"5233798","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFW5327NL006596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-18T09:47:12.000000Z","updated_at":"2025-10-19T09:46:00.000000Z"}]},{"id":9886518,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","dot_number":"3531967","report_state":"MO","report_number":"5145000589","insp_date":"2025-10-08 00:00:00","insp_start_time":"1358","insp_end_time":"1515","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":"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":"U","pen_cen_match":"I","final_status_date":"2025-10-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"16","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":"2383130","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:46.000000Z","updated_at":"2025-10-12T10:00:52.000000Z","inspection_violations":[{"id":16302111,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174676","seq_no":"6","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302112,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174677","seq_no":"7","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"39360C"},{"id":16302113,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174678","seq_no":"8","part_no":"387","part_no_section":"301A","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"387301A"},{"id":16302114,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174679","seq_no":"9","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"39021TB1MC"},{"id":16302115,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174680","seq_no":"10","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"39021TB2DOT"},{"id":16302116,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174681","seq_no":"11","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302117,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174682","seq_no":"12","part_no":"390","part_no_section":"21TE2IV-D","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"39021TE2IVD"},{"id":16302118,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174683","seq_no":"13","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"211007969","created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3922SLLSR"},{"id":16302119,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174684","seq_no":"14","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302120,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174685","seq_no":"15","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302121,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174686","seq_no":"16","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302122,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174687","seq_no":"1","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"209361561","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3969D2FTF"},{"id":16302123,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174688","seq_no":"2","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"39522GELDMFV"},{"id":16302124,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174689","seq_no":"3","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302125,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174690","seq_no":"4","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"},{"id":16302126,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_violation_id":"269174691","seq_no":"5","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:01.000000Z","updated_at":"2025-10-12T10:16:08.000000Z","normalized_code":"3958A"}],"inspection_per_units":[{"id":16403653,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_unit_id":"209361561","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"92","insp_unit_license":"PNK3733","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FT8W3DT3REE11917","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:12.000000Z","updated_at":"2025-10-12T09:46:05.000000Z"},{"id":16403654,"change_date":"2025-10-08 21:40:00","inspection_id":"85990282","insp_unit_id":"209361562","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"TTN2761","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"7UZFW5033PL007432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:12.000000Z","updated_at":"2025-10-12T09:46:05.000000Z"}]},{"id":9699516,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","dot_number":"3531967","report_state":"CO","report_number":"1287130163","insp_date":"2025-09-04 00:00:00","insp_start_time":"1438","insp_end_time":"1600","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"GYPSUM CO","county_code_state":"CO","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RPM","shipping_paper_number":"31596-43817","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"9","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":"2285650","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-09-17 21:39:00","snet_input_date":"2025-09-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-17 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:01:29.000000Z","updated_at":"2025-09-23T10:01:29.000000Z","inspection_violations":[{"id":15915627,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740428","seq_no":"1","part_no":"392","part_no_section":"2-SLLTR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6567070","created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"3922SLLTR"},{"id":15915628,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740429","seq_no":"2","part_no":"392","part_no_section":"2SLSNC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6567070","created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"3922SLSNC"},{"id":15915629,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740430","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208987986","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"39395F"},{"id":15915630,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740431","seq_no":"4","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208987986","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"39395A1"},{"id":15915631,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740432","seq_no":"5","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"208987986","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"39378AWS"},{"id":15915632,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740433","seq_no":"6","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6567070","created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"3922SLLTCD"},{"id":15915633,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740434","seq_no":"7","part_no":"390","part_no_section":"35","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-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"39035"},{"id":15915634,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740435","seq_no":"8","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208987986","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"39021TB1MC"},{"id":15915635,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_violation_id":"268740436","seq_no":"9","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-20T10:16:09.000000Z","updated_at":"2025-09-22T10:15:07.000000Z","normalized_code":"38323A2LCDLN"}],"inspection_per_units":[{"id":16056274,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_unit_id":"208987986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"707875E","insp_unit_license_state":"MT","insp_unit_vehicle_id_number":"1FT8W3DT7PEC69004","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:41.000000Z","updated_at":"2025-09-21T09:45:03.000000Z"},{"id":16056275,"change_date":"2025-09-17 21:39:00","inspection_id":"85794004","insp_unit_id":"208987987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAL TRAILE","insp_unit_company":null,"insp_unit_license":"717366E","insp_unit_license_state":"MT","insp_unit_vehicle_id_number":"4C9KC5333PC546425","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-20T09:45:41.000000Z","updated_at":"2025-09-21T09:45:03.000000Z"}]},{"id":9428024,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","dot_number":"3531967","report_state":"CO","report_number":"1287130138","insp_date":"2025-08-14 00:00:00","insp_start_time":"0909","insp_end_time":"1107","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"SILVERTHORNE CO","county_code_state":"CO","county_code":"117","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SAFEEDS TRANSPORT INC","shipping_paper_number":"31028218-ST","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-16 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2136517","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-08-16 21:33:00","snet_input_date":"2025-08-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-16 21:33:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-20T10:44:43.000000Z","updated_at":"2025-08-20T10:44:43.000000Z","inspection_violations":[{"id":15341873,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_violation_id":"268065563","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208428191","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-19T10:45:14.000000Z","updated_at":"2025-08-20T10:44:53.000000Z","normalized_code":"39021TB1MC"},{"id":15341874,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_violation_id":"268065564","seq_no":"2","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"1","insp_unit_id":"208428191","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-19T10:45:14.000000Z","updated_at":"2025-08-20T10:44:53.000000Z","normalized_code":"3963A1HCM"},{"id":15341875,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_violation_id":"268065565","seq_no":"3","part_no":"390","part_no_section":"35","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-08-19T10:45:14.000000Z","updated_at":"2025-08-20T10:44:53.000000Z","normalized_code":"39035"},{"id":15341876,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_violation_id":"268065566","seq_no":"4","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-19T10:45:14.000000Z","updated_at":"2025-08-20T10:44:53.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":15542013,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_unit_id":"208428191","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PNK3730","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FT8W3CT5REC04608","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-19T09:46:12.000000Z","updated_at":"2025-08-20T09:45:06.000000Z"},{"id":15542014,"change_date":"2025-08-16 21:33:00","inspection_id":"85508916","insp_unit_id":"208428192","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"TTN2762","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"7UZFW5030PL001930","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-19T09:46:12.000000Z","updated_at":"2025-08-20T09:45:06.000000Z"}]},{"id":9386450,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","dot_number":"3531967","report_state":"MO","report_number":"3725001466","insp_date":"2025-08-06 00:00:00","insp_start_time":"1017","insp_end_time":"1206","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FENTON MO","county_code_state":"MO","county_code":null,"insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"V-566\/V-567\/V-5","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"22","oos_total":"7","driver_viol_total":"0","driver_oos_total":"3","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2116308","transaction_code":"A","transaction_date":"2025-08-11 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-08-12 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-12 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:39.000000Z","updated_at":"2025-08-16T10:00:19.000000Z","inspection_violations":[{"id":15256987,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966858","seq_no":"1","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"393104BC"},{"id":15256988,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966859","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3929A2C"},{"id":15256989,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966860","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39617CPI"},{"id":15256990,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966861","seq_no":"4","part_no":"393","part_no_section":"9B-LCL","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3939BLCL"},{"id":15256991,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966862","seq_no":"5","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39343DB"},{"id":15256992,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966863","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39617CPI"},{"id":15256993,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966864","seq_no":"7","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15256994,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966865","seq_no":"8","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3922SLLMF"},{"id":15256995,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966866","seq_no":"9","part_no":"393","part_no_section":"128B-CLWV","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"393128BCLWV"},{"id":15256996,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966867","seq_no":"10","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39311A1CSURR"},{"id":15256997,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966868","seq_no":"11","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3922SLLED"},{"id":15256998,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966869","seq_no":"12","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39021TB1MC"},{"id":15256999,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966870","seq_no":"13","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39021TB2DOT"},{"id":15257000,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966871","seq_no":"14","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3958EHOSPD"},{"id":15257001,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966872","seq_no":"15","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3922SLLUCR"},{"id":15257002,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966873","seq_no":"16","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"38323A2LCDLN"},{"id":15257003,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966874","seq_no":"17","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15257004,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966875","seq_no":"18","part_no":"393","part_no_section":"11A1-LCHL","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39311A1LCHL"},{"id":15257005,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966876","seq_no":"19","part_no":"395","part_no_section":"3A3I-HOSPDIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3953A3IHOSPDIT"},{"id":15257006,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966877","seq_no":"20","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3939ALSML"},{"id":15257007,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966878","seq_no":"21","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"208346261","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"3922SLLMF"},{"id":15257008,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_violation_id":"267966879","seq_no":"22","part_no":"393","part_no_section":"87A-FPLR","insp_viol_unit":"2","insp_unit_id":"208346262","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:34.000000Z","updated_at":"2025-08-16T10:43:14.000000Z","normalized_code":"39387AFPLR"}],"inspection_per_units":[{"id":15467048,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_unit_id":"208346261","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"PLY 81","insp_unit_license":"PNU8439","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FT8W3DT4REF55072","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:17.000000Z","updated_at":"2025-08-16T09:45:23.000000Z"},{"id":15467049,"change_date":"2025-08-12 21:39:00","inspection_id":"85465162","insp_unit_id":"208346262","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"SILVERBACK","insp_unit_company":"SB638","insp_unit_license":"540AC355","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"4S9KC5320SH623638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:17.000000Z","updated_at":"2025-08-16T09:45:23.000000Z"}]},{"id":9344090,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","dot_number":"3531967","report_state":"IA","report_number":"000P158HPR","insp_date":"2025-08-02 00:00:00","insp_start_time":"0656","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"RUSS DARROW CHRYSLER","shipping_paper_number":"549380","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-08-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","oos_total":"2","driver_viol_total":"5","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1369632","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":"M","census_search_date":"2025-08-06 21:40:00","snet_input_date":"2025-08-02 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-08-06 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:21.000000Z","updated_at":"2025-08-12T10:42:21.000000Z","inspection_violations":[{"id":15170540,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871331","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8WIT25080208055","created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"3922C"},{"id":15170541,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871332","seq_no":"2","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8WIT25080208061","created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"38323A2"},{"id":15170542,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871333","seq_no":"3","part_no":"391","part_no_section":"41A1-LOC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"39141A1LOC"},{"id":15170543,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871334","seq_no":"4","part_no":"395","part_no_section":"22H4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"39522H4"},{"id":15170544,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871335","seq_no":"5","part_no":"392","part_no_section":"2IRP","insp_viol_unit":"1","insp_unit_id":"208266069","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"3922IRP"},{"id":15170545,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871336","seq_no":"6","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8WIT25080208251","created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"3922SLLIFTA"},{"id":15170546,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871337","seq_no":"7","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208266069","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"39395A"},{"id":15170547,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_violation_id":"267871338","seq_no":"8","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"208266069","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-09T10:45:19.000000Z","updated_at":"2025-08-10T10:43:56.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":15391805,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_unit_id":"208266069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"214709H","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FT8W3DT5PEE12676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:20.000000Z","updated_at":"2025-08-10T09:45:55.000000Z"},{"id":15391806,"change_date":"2025-08-06 21:40:00","inspection_id":"85420719","insp_unit_id":"208266070","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":null,"insp_unit_license":"422AC258","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"7UZFW5031PL007428","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-09T09:46:20.000000Z","updated_at":"2025-08-10T09:45:55.000000Z"}]},{"id":9349965,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","dot_number":"3531967","report_state":"MO","report_number":"W157000773","insp_date":"2025-08-01 00:00:00","insp_start_time":"2000","insp_end_time":"2056","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WILLIAMSBURG MO","county_code_state":"MO","county_code":"027","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"MILLENNIUM MOTORS","shipping_paper_number":"7165041","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-08-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"14","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":"2096859","transaction_code":"A","transaction_date":"2025-08-07 00:00:00","upload_date":"2025-08-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-08-07 21:39:00","snet_input_date":"2025-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-07 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:42:38.000000Z","updated_at":"2025-08-12T10:42:38.000000Z","inspection_violations":[{"id":15183885,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885549","seq_no":"1","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3963A1HCM"},{"id":15183886,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885550","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15183887,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885551","seq_no":"3","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3963A1HCM"},{"id":15183888,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885552","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208277011","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39021TB1MC"},{"id":15183889,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885553","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208277011","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39021TB2DOT"},{"id":15183890,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885554","seq_no":"6","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"208277011","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3922SLLSR"},{"id":15183891,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885555","seq_no":"7","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3939ALLPL"},{"id":15183892,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885556","seq_no":"8","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3922SLLED"},{"id":15183893,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885557","seq_no":"9","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15183894,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885558","seq_no":"10","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15183895,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885559","seq_no":"11","part_no":"393","part_no_section":"87A-FPLA","insp_viol_unit":"2","insp_unit_id":"208277012","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39387AFPLA"},{"id":15183896,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885560","seq_no":"12","part_no":"395","part_no_section":"24","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39524"},{"id":15183897,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885561","seq_no":"13","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"39530B1ELDDFR"},{"id":15183898,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_violation_id":"267885562","seq_no":"14","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"208277011","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-10T10:44:34.000000Z","updated_at":"2025-08-11T10:44:05.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":15402582,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_unit_id":"208277011","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"88094Z","insp_unit_license_state":"WI","insp_unit_vehicle_id_number":"1FT8W3DT7PEE01288","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:17.000000Z","updated_at":"2025-08-11T09:45:30.000000Z"},{"id":15402583,"change_date":"2025-08-07 21:39:00","inspection_id":"85426947","insp_unit_id":"208277012","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAL-TEX TR","insp_unit_company":null,"insp_unit_license":"964178ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"4C9KC5030PC546404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-10T09:46:17.000000Z","updated_at":"2025-08-11T09:45:30.000000Z"}]},{"id":8062544,"change_date":"2025-03-08 21:34:00","inspection_id":"84069457","dot_number":"3531967","report_state":"NM","report_number":"8937P1TBM1","insp_date":"2025-03-06 00:00:00","insp_start_time":"0922","insp_end_time":"0956","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"JACKIE COOPER \/ATS LOPGISTICS","shipping_paper_number":"9186152185","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-03-08 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"2171520","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-03-08 21:34:00","snet_input_date":"2025-03-07 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-03-08 21:34:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5321 WINDING GLEN DR","insp_carrier_city":"LITHONIA","insp_carrier_state":"GA","insp_carrier_zip_code":"300382398","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:49.000000Z","updated_at":"2025-03-17T21:05:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13017616,"change_date":"2025-03-08 21:34:00","inspection_id":"84069457","insp_unit_id":"205695385","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT 2","insp_unit_license":"PXB8810","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD0W5HT3REC92216","insp_unit_decal":"Y","insp_unit_decal_number":"34902752","created_at":"2025-03-17T23:58:49.000000Z","updated_at":"2025-03-17T23:58:49.000000Z"},{"id":13017617,"change_date":"2025-03-08 21:34:00","inspection_id":"84069457","insp_unit_id":"205695386","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"UNIT 2","insp_unit_license":"548891","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U27R1149283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:49.000000Z","updated_at":"2025-03-17T23:58:49.000000Z"}]},{"id":7755656,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","dot_number":"3531967","report_state":"FL","report_number":"4326000882","insp_date":"2025-01-27 00:00:00","insp_start_time":"0955","insp_end_time":"1106","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"HIGH SPRINGS FL","county_code_state":"FL","county_code":"001","insp_level_id":"1","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"31500","viol_total":"3","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":"1308895","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:10.000000Z","updated_at":"2025-03-17T20:59:10.000000Z","inspection_violations":[{"id":12118561,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","insp_violation_id":"264273007","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205096902","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:05.000000Z","updated_at":"2025-03-17T22:05:05.000000Z","normalized_code":"3922SLLSR"},{"id":12118562,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","insp_violation_id":"264273008","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000843259","created_at":"2025-03-17T22:05:05.000000Z","updated_at":"2025-03-17T22:05:05.000000Z","normalized_code":"3922SLLED"},{"id":12118563,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","insp_violation_id":"264273009","seq_no":"3","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"205096903","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:05:05.000000Z","updated_at":"2025-03-17T22:05:05.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":12515959,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","insp_unit_id":"205096902","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PXB8810","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD0W5HT3REC92216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:10.000000Z","updated_at":"2025-03-17T23:53:10.000000Z"},{"id":12515960,"change_date":"2025-01-31 21:40:00","inspection_id":"83747193","insp_unit_id":"205096903","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUCKEYE FL","insp_unit_company":null,"insp_unit_license":"S488328","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4B9CB9U27R1149283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:10.000000Z","updated_at":"2025-03-17T23:53:10.000000Z"}]},{"id":7316213,"change_date":"2025-03-18 21:39:00","inspection_id":"83285561","dot_number":"3531967","report_state":"SC","report_number":"0398000077","insp_date":"2024-12-02 00:00:00","insp_start_time":"0950","insp_end_time":"1115","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BLACKSBURG SC","county_code_state":"SC","county_code":"021","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"COLONIAL FORD","shipping_paper_number":"3995","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-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40999","viol_total":"1","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":"1111551","transaction_code":"C","transaction_date":"2024-12-02 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-12-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:37.000000Z","updated_at":"2025-03-22T10:26:12.000000Z","inspection_violations":[{"id":12735105,"change_date":"2025-03-18 21:39:00","inspection_id":"83285561","insp_violation_id":"265097070","seq_no":"1","part_no":"393","part_no_section":"75G-TAOW","insp_viol_unit":"1","insp_unit_id":"205852207","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WA69561","created_at":"2025-03-21T10:51:11.000000Z","updated_at":"2025-03-21T11:01:14.000000Z","normalized_code":"39375GTAOW"}],"inspection_per_units":[{"id":13145553,"change_date":"2025-03-18 21:39:00","inspection_id":"83285561","insp_unit_id":"205852207","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"010","insp_unit_license":"P1263762","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FD9W4HT4REC35010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:00:32.000000Z","updated_at":"2025-03-22T09:48:53.000000Z"},{"id":13145554,"change_date":"2025-03-18 21:39:00","inspection_id":"83285561","insp_unit_id":"205852208","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUCKEYE FL","insp_unit_company":"9048","insp_unit_license":"5372036","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U28R1149048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:00:32.000000Z","updated_at":"2025-03-22T09:48:53.000000Z"}]},{"id":7314192,"change_date":"2024-12-02 21:39:00","inspection_id":"83283396","dot_number":"3531967","report_state":"IN","report_number":"7809004206","insp_date":"2024-11-27 00:00:00","insp_start_time":"0948","insp_end_time":"1033","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"HAUBSTADT IN","county_code_state":"IN","county_code":"163","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"METRO AUTO AUCTION","shipping_paper_number":"2513140","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-12-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40999","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":"1109189","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-12-02 21:39:00","snet_input_date":"2024-11-27 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-02 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:36.000000Z","updated_at":"2025-03-17T20:48:36.000000Z","inspection_violations":[{"id":11433595,"change_date":"2024-12-02 21:39:00","inspection_id":"83283396","insp_violation_id":"263162023","seq_no":"1","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:34.000000Z","updated_at":"2025-03-17T22:01:34.000000Z","normalized_code":"39522GELDMFV"}],"inspection_per_units":[{"id":11798799,"change_date":"2024-12-02 21:39:00","inspection_id":"83283396","insp_unit_id":"204124109","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"010","insp_unit_license":"P1263762","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"1FD9W4HT4REC35010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:17.000000Z","updated_at":"2025-03-17T23:45:17.000000Z"},{"id":11798800,"change_date":"2024-12-02 21:39:00","inspection_id":"83283396","insp_unit_id":"204124110","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUCKEYE FL","insp_unit_company":"9048","insp_unit_license":"5372036","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U28R1149048","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:17.000000Z","updated_at":"2025-03-17T23:45:17.000000Z"}]},{"id":7227406,"change_date":"2024-12-03 21:39:00","inspection_id":"83191802","dot_number":"3531967","report_state":"OR","report_number":"AP43760247","insp_date":"2024-11-19 00:00:00","insp_start_time":"0745","insp_end_time":"0830","registration_date":null,"region":"PS","ci_status_code":"C","location":"15-07","location_desc":"ASHLAND  OR","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MONTWAY AUTO TRANSPORT","shipping_paper_number":"2502327","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-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","viol_total":"2","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":"1068888","transaction_code":"C","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:49.000000Z","updated_at":"2025-03-17T20:46:49.000000Z","inspection_violations":[{"id":11297528,"change_date":"2024-12-03 21:39:00","inspection_id":"83191802","insp_violation_id":"263187446","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3958A1HOSP"},{"id":11297529,"change_date":"2024-12-03 21:39:00","inspection_id":"83191802","insp_violation_id":"263187447","seq_no":"2","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"677425","created_at":"2025-03-17T22:00:50.000000Z","updated_at":"2025-03-17T22:00:50.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":11657715,"change_date":"2024-12-03 21:39:00","inspection_id":"83191802","insp_unit_id":"204144889","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PXB4648","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD9W4HT7REC47040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"},{"id":11657716,"change_date":"2024-12-03 21:39:00","inspection_id":"83191802","insp_unit_id":"204144890","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"4","insp_unit_license":"5233798","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFW5327NL006596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:49.000000Z","updated_at":"2025-03-17T23:43:49.000000Z"}]},{"id":7105090,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","dot_number":"3531967","report_state":"FL","report_number":"2458003542","insp_date":"2024-10-29 00:00:00","insp_start_time":"1004","insp_end_time":"1046","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"YULEE FL","county_code_state":"FL","county_code":"089","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"AMAZON","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":"U","pen_cen_match":"I","final_status_date":"2024-11-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"35000","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":"1012058","transaction_code":"A","transaction_date":"2024-11-02 00:00:00","upload_date":"2024-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-11-02 21:33:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-02 21:33:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[{"id":11095138,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_violation_id":"262691039","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"3958EHOSPD"},{"id":11095139,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_violation_id":"262691040","seq_no":"2","part_no":"395","part_no_section":"22G-ELDMFV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"39522GELDMFV"},{"id":11095140,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_violation_id":"262691041","seq_no":"3","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"3922SLLTCD"},{"id":11095141,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_violation_id":"262691042","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203703847","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11459215,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_unit_id":"203703847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"040","insp_unit_license":"761118HC","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"1FD9W4HT7REC47040","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"},{"id":11459216,"change_date":"2024-11-02 21:33:00","inspection_id":"83062323","insp_unit_id":"203703848","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"4","insp_unit_license":"5233798","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFW5327NL006596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"}]},{"id":7038070,"change_date":"2024-10-24 21:41:00","inspection_id":"82991244","dot_number":"3531967","report_state":"NM","report_number":"0749O889GR","insp_date":"2024-10-22 00:00:00","insp_start_time":"0831","insp_end_time":"0854","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MULTIPLE SHIPPERS","shipping_paper_number":"1170520","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-10-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40999","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":"2124756","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-10-24 21:41:00","snet_input_date":"2024-10-23 00:00:00","source_office":"2NMS001","mcmis_add_date":"2024-10-24 21:41:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:41.000000Z","updated_at":"2025-03-17T20:42:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11350832,"change_date":"2024-10-24 21:41:00","inspection_id":"82991244","insp_unit_id":"203571660","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT 7316","insp_unit_license":"PXA7909","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD9W4HT0REC47316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"},{"id":11350833,"change_date":"2024-10-24 21:41:00","inspection_id":"82991244","insp_unit_id":"203571661","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUCK","insp_unit_company":"UNIT VIN 9041","insp_unit_license":"5394301","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U22R1149041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:33.000000Z","updated_at":"2025-03-17T23:40:33.000000Z"}]},{"id":6823343,"change_date":"2024-09-26 21:40:00","inspection_id":"82763116","dot_number":"3531967","report_state":"WA","report_number":"0858000517","insp_date":"2024-09-24 00:00:00","insp_start_time":"0727","insp_end_time":"0815","registration_date":null,"region":"PD","ci_status_code":"C","location":"SC68","location_desc":"SPRAGUE WA","county_code_state":"WA","county_code":"001","insp_level_id":"2","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"885314","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:34.000000Z","updated_at":"2025-03-17T20:38:34.000000Z","inspection_violations":[{"id":10627359,"change_date":"2024-09-26 21:40:00","inspection_id":"82763116","insp_violation_id":"262043299","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:28.000000Z","updated_at":"2025-03-17T21:57:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11003414,"change_date":"2024-09-26 21:40:00","inspection_id":"82763116","insp_unit_id":"203137711","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"7316","insp_unit_license":"PXA7909","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD9W4HT0REC47316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"},{"id":11003415,"change_date":"2024-09-26 21:40:00","inspection_id":"82763116","insp_unit_id":"203137712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"5394301","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U22R1149041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:57.000000Z","updated_at":"2025-03-17T23:36:57.000000Z"}]},{"id":6790162,"change_date":"2024-09-24 21:41:00","inspection_id":"82727914","dot_number":"3531967","report_state":"ND","report_number":"FT58000445","insp_date":"2024-09-22 00:00:00","insp_start_time":"0655","insp_end_time":"0717","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"BISMARCK ND","county_code_state":"ND","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NATIONS AUTO TRANSPORT","shipping_paper_number":"SD11998","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-09-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"874179","transaction_code":"C","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-09-23 21:40:00","snet_input_date":"2024-09-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-23 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:45.000000Z","updated_at":"2025-03-17T20:37:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10949901,"change_date":"2024-09-24 21:41:00","inspection_id":"82727914","insp_unit_id":"203099353","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PXA7909","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD9W4HT0REC47316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:25.000000Z","updated_at":"2025-03-17T23:36:25.000000Z"},{"id":10949902,"change_date":"2024-09-24 21:41:00","inspection_id":"82727914","insp_unit_id":"203099354","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"5394301","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4B9CB9U22R1149041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:25.000000Z","updated_at":"2025-03-17T23:36:25.000000Z"}]},{"id":6103278,"change_date":"2024-06-28 21:39:00","inspection_id":"81993665","dot_number":"3531967","report_state":"MI","report_number":"CHAPP04448","insp_date":"2024-06-27 00:00:00","insp_start_time":"1644","insp_end_time":"1750","registration_date":null,"region":"ET","ci_status_code":"C","location":"115","location_desc":"BERLIN TWP","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"FORD","shipping_paper_number":"4 FORD BRONCOS","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-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40999","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":"1184198","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:44.000000Z","updated_at":"2025-03-17T20:23:44.000000Z","inspection_violations":[{"id":9472625,"change_date":"2024-06-28 21:39:00","inspection_id":"81993665","insp_violation_id":"260373392","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4387887","created_at":"2025-03-17T21:51:50.000000Z","updated_at":"2025-03-17T21:51:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9830378,"change_date":"2024-06-28 21:39:00","inspection_id":"81993665","insp_unit_id":"201645887","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PXA7909","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"1FD9W4HT0REC47316","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"},{"id":9830379,"change_date":"2024-06-28 21:39:00","inspection_id":"81993665","insp_unit_id":"201645888","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BUCK","insp_unit_company":null,"insp_unit_license":"R842078","insp_unit_license_state":"OH","insp_unit_vehicle_id_number":"4B9CB9U22R1149041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:51.000000Z","updated_at":"2025-03-17T23:24:51.000000Z"}]},{"id":5235444,"change_date":"2024-03-07 21:39:00","inspection_id":"81050396","dot_number":"3531967","report_state":"OR","report_number":"AAAZ007290","insp_date":"2024-03-06 00:00:00","insp_start_time":"1140","insp_end_time":"1215","registration_date":null,"region":"PT","ci_status_code":"C","location":"1504","location_desc":"ASHLAND NB - 2 MI N ASHLAND","county_code_state":"OR","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"4","insp_facility":"F","shipper_name":"CARGOLEX 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-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1244011","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2024-03-07 21:39:00","snet_input_date":"2024-03-06 00:00:00","source_office":"4ORS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"620 E BROAD ST SUITE Z","insp_carrier_city":"COLUMBUS","insp_carrier_state":"OH","insp_carrier_zip_code":"43215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"036075","created_at":"2025-03-17T20:06:15.000000Z","updated_at":"2025-03-17T20:06:15.000000Z","inspection_violations":[{"id":8072005,"change_date":"2024-03-07 21:39:00","inspection_id":"81050396","insp_violation_id":"258264210","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199807120","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:45:00.000000Z","updated_at":"2025-03-17T21:45:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8430556,"change_date":"2024-03-07 21:39:00","inspection_id":"81050396","insp_unit_id":"199807120","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"11","insp_unit_license":"ZP17726","insp_unit_license_state":"CA","insp_unit_vehicle_id_number":"3C63RRHL2NG407558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:24.000000Z","updated_at":"2025-03-17T23:11:24.000000Z"},{"id":8430557,"change_date":"2024-03-07 21:39:00","inspection_id":"81050396","insp_unit_id":"199807121","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"11T","insp_unit_license":"TEMP","insp_unit_license_state":"NE","insp_unit_vehicle_id_number":"7UZFW5328KB000253","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:24.000000Z","updated_at":"2025-03-17T23:11:24.000000Z"}]},{"id":4757219,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","dot_number":"3531967","report_state":"TX","report_number":"V231203566","insp_date":"2023-12-31 00:00:00","insp_start_time":"0928","insp_end_time":"1011","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10MP 404","county_code_state":"TX","county_code":"435","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"31544-13446","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-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"34000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9164611","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":"M","census_search_date":"2024-12-10 21:41:00","snet_input_date":"2023-12-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-03 21:44:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"5596 STERLING CT","insp_carrier_city":"SOUTH LEBANON","insp_carrier_state":"OH","insp_carrier_zip_code":"45065","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1065029","created_at":"2025-03-17T19:56:56.000000Z","updated_at":"2025-03-17T19:56:56.000000Z","inspection_violations":[{"id":7340984,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367481","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"39311"},{"id":7340985,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367482","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"39311"},{"id":7340986,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367483","seq_no":"3","part_no":"393","part_no_section":"201A","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"393201A"},{"id":7340987,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367484","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"3939"},{"id":7340988,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367485","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"3939"},{"id":7340989,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_violation_id":"263367486","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"204301437","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:28.000000Z","updated_at":"2025-03-17T21:41:28.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7653066,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_unit_id":"204301436","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"P1206724","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3C7WRSCL6MG500881","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"},{"id":7653067,"change_date":"2024-12-10 21:41:00","inspection_id":"80527708","insp_unit_id":"204301437","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"795297ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5VGFW5026ML005281","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:24.000000Z","updated_at":"2025-03-17T23:04:24.000000Z"}]},{"id":4685261,"change_date":"2023-12-21 21:39:00","inspection_id":"80449483","dot_number":"3531967","report_state":"IA","report_number":"000P1684LR","insp_date":"2023-12-18 00:00:00","insp_start_time":"1009","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":"37","location_desc":"37 - I29 SB MM 132 SALIX","county_code_state":"IA","county_code":"193","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1297875","transaction_code":"A","transaction_date":"2023-12-20 00:00:00","upload_date":"2023-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":"M","census_search_date":"2023-12-21 21:39:00","snet_input_date":"2023-12-18 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-21 21:39:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"620 E BROAD ST SUITE Z","insp_carrier_city":"COLUMBUS","insp_carrier_state":"OH","insp_carrier_zip_code":"43215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:45.000000Z","updated_at":"2025-03-17T19:55:45.000000Z","inspection_violations":[{"id":7239840,"change_date":"2023-12-21 21:39:00","inspection_id":"80449483","insp_violation_id":"257012301","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198623852","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"39395A"},{"id":7239841,"change_date":"2023-12-21 21:39:00","inspection_id":"80449483","insp_violation_id":"257012302","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198623853","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:56.000000Z","updated_at":"2025-03-17T21:40:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7535899,"change_date":"2023-12-21 21:39:00","inspection_id":"80449483","insp_unit_id":"198623852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"24","insp_unit_license":"187751H","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3C7WRSCL6MG500881","insp_unit_decal":"Y","insp_unit_decal_number":"33427794","created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"},{"id":7535900,"change_date":"2023-12-21 21:39:00","inspection_id":"80449483","insp_unit_id":"198623853","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFMAN","insp_unit_company":"5281","insp_unit_license":"795297ST","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"5VGFW5026ML005281","insp_unit_decal":"Y","insp_unit_decal_number":"33427795","created_at":"2025-03-17T23:03:23.000000Z","updated_at":"2025-03-17T23:03:23.000000Z"}]},{"id":4346959,"change_date":"2023-11-03 21:40:00","inspection_id":"80076962","dot_number":"3531967","report_state":"MO","report_number":"W035004733","insp_date":"2023-11-02 00:00:00","insp_start_time":"1631","insp_end_time":"1705","registration_date":null,"region":"CD","ci_status_code":"C","location":"E2N","location_desc":"STEELE MO","county_code_state":"MO","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"DES TRANSPORT","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":"U","pen_cen_match":"I","final_status_date":"2023-11-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"85208","transaction_code":"A","transaction_date":"2023-11-02 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":null,"census_search_date":"2023-11-03 21:40:00","snet_input_date":"2023-11-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-11-03 21:40:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"620 E BROAD ST SUITE Z","insp_carrier_city":"COLUMBUS","insp_carrier_state":"OH","insp_carrier_zip_code":"43215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:06.000000Z","updated_at":"2025-03-17T19:49:06.000000Z","inspection_violations":[{"id":6724651,"change_date":"2023-11-03 21:40:00","inspection_id":"80076962","insp_violation_id":"256201572","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"197890393","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922SLLUCR"},{"id":6724652,"change_date":"2023-11-03 21:40:00","inspection_id":"80076962","insp_violation_id":"256201573","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"197890393","insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":6990977,"change_date":"2023-11-03 21:40:00","inspection_id":"80076962","insp_unit_id":"197890393","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"732875","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3C7WRTCL2NG193636","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"},{"id":6990978,"change_date":"2023-11-03 21:40:00","inspection_id":"80076962","insp_unit_id":"197890394","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"29370316","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"7UZFW5038RL001838","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:42.000000Z","updated_at":"2025-03-17T22:58:42.000000Z"}]},{"id":3579531,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","dot_number":"3531967","report_state":"MO","report_number":"W134007314","insp_date":"2023-07-21 00:00:00","insp_start_time":"2111","insp_end_time":"2136","registration_date":null,"region":"CT","ci_status_code":"C","location":"E2N","location_desc":"E2N STEELE, MO","county_code_state":"MO","county_code":"155","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"F","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":"N","pen_cen_match":"I","final_status_date":"2023-07-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"2084992","transaction_code":"C","transaction_date":"2023-08-15 00:00:00","upload_date":"2023-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03531967","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-24 00:00:00","source_office":"3MOS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"BORDENAVE LOGISTIC ALLIANCE LLC","insp_carrier_street":"620 E BROAD ST SUITE Z","insp_carrier_city":"COLUMBUS","insp_carrier_state":"OH","insp_carrier_zip_code":"43215","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:33:36.000000Z","updated_at":"2025-03-17T19:33:36.000000Z","inspection_violations":[{"id":5518976,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_violation_id":"254662629","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196539959","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"},{"id":5518977,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_violation_id":"254662630","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196539959","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"},{"id":5518978,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_violation_id":"254662631","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196539959","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"},{"id":5518979,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_violation_id":"254662632","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"196539959","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:34.000000Z","updated_at":"2025-03-17T21:32:34.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5755622,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_unit_id":"196539959","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"181164C","insp_unit_license_state":"IL","insp_unit_vehicle_id_number":"3C63RRHLXPG596611","insp_unit_decal":"Y","insp_unit_decal_number":"33046532","created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"},{"id":5755623,"change_date":"2023-08-15 21:43:00","inspection_id":"79223496","insp_unit_id":"196539960","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"29253541","insp_unit_license_state":"NC","insp_unit_vehicle_id_number":"7UZFW5033PL007429","insp_unit_decal":"Y","insp_unit_decal_number":"33046533","created_at":"2025-03-17T22:48:26.000000Z","updated_at":"2025-03-17T22:48:26.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3531967\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3531967\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3531967\/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\/3531967\/inspections","per_page":100,"prev_page_url":null,"to":23,"total":23}