{"current_page":1,"data":[{"id":11866273,"change_date":"2026-05-10 21:34:00","inspection_id":"87803080","dot_number":"3241566","report_state":"TN","report_number":"I038AE0024","insp_date":"2026-05-08 00:00:00","insp_start_time":"1046","insp_end_time":"1056","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NASHVILLE TN","county_code_state":"TN","county_code":"037","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-10 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"3293385","transaction_code":"A","transaction_date":"2026-05-09 00:00:00","upload_date":"2026-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2026-05-10 21:34:00","snet_input_date":"2026-05-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-10 21:34:00","insp_carrier_name":"BORDEAUX TN TRUCKING LLC","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T09:38:36.000000Z","updated_at":"2026-05-21T09:30:13.000000Z","inspection_violations":[{"id":20639769,"change_date":"2026-05-10 21:34:00","inspection_id":"87803080","insp_violation_id":"274153442","seq_no":"1","part_no":"392","part_no_section":"2-SLLCP","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":"2026-05-12T09:58:54.000000Z","updated_at":"2026-05-21T09:41:31.000000Z","normalized_code":"3922SLLCP"}],"inspection_per_units":[{"id":20633626,"change_date":"2026-05-10 21:34:00","inspection_id":"87803080","insp_unit_id":"213465386","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"01","insp_unit_license":"751BQWX","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRHL5TG153311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T09:15:17.000000Z","updated_at":"2026-05-21T09:02:14.000000Z"},{"id":20633627,"change_date":"2026-05-10 21:34:00","inspection_id":"87803080","insp_unit_id":"213465387","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"01","insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T09:15:17.000000Z","updated_at":"2026-05-21T09:02:14.000000Z"}]},{"id":11666689,"change_date":"2026-04-16 21:41:00","inspection_id":"87597070","dot_number":"3241566","report_state":"TX","report_number":"V262312955","insp_date":"2026-04-14 00:00:00","insp_start_time":"0918","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 30","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"STX6646201","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"9921422","transaction_code":"A","transaction_date":"2026-04-16 00:00:00","upload_date":"2026-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":"M","census_search_date":"2026-04-16 21:41:00","snet_input_date":"2026-04-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-16 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0977656","created_at":"2026-04-27T09:31:45.000000Z","updated_at":"2026-04-27T09:31:45.000000Z","inspection_violations":[{"id":20264984,"change_date":"2026-04-16 21:41:00","inspection_id":"87597070","insp_violation_id":"273653123","seq_no":"1","part_no":"393","part_no_section":"75A3-ATIS","insp_viol_unit":"2","insp_unit_id":"213056454","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:45:24.000000Z","updated_at":"2026-04-27T09:45:24.000000Z","normalized_code":"39375A3ATIS"}],"inspection_per_units":[{"id":20294609,"change_date":"2026-04-16 21:41:00","inspection_id":"87597070","insp_unit_id":"213056453","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"01","insp_unit_license":"751BQWX","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRHL5TG153311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:53.000000Z","updated_at":"2026-04-27T09:04:53.000000Z"},{"id":20294610,"change_date":"2026-04-16 21:41:00","inspection_id":"87597070","insp_unit_id":"213056454","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"01","insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:04:53.000000Z","updated_at":"2026-04-27T09:04:53.000000Z"}]},{"id":11875879,"change_date":"2026-05-11 21:39:00","inspection_id":"87813192","dot_number":"3241566","report_state":"MS","report_number":"2012013825","insp_date":"2026-04-08 00:00:00","insp_start_time":"0825","insp_end_time":"0844","registration_date":null,"region":"CT","ci_status_code":"C","location":"47","location_desc":"MARSHALL COUNTY","county_code_state":"MS","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"KING OF FREIGHT","shipping_paper_number":"3170057","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1145055","transaction_code":"A","transaction_date":"2026-04-08 00:00:00","upload_date":"2026-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2026-05-11 21:39:00","snet_input_date":"2026-05-07 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-05-11 21:39:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-13T13:15:28.000000Z","updated_at":"2026-05-22T09:31:00.000000Z","inspection_violations":[{"id":20655432,"change_date":"2026-05-11 21:39:00","inspection_id":"87813192","insp_violation_id":"274174264","seq_no":"1","part_no":"392","part_no_section":"82DUMT","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":"2026-05-13T13:33:00.000000Z","updated_at":"2026-05-22T09:42:55.000000Z","normalized_code":"39282DUMT"}],"inspection_per_units":[{"id":20649187,"change_date":"2026-05-11 21:39:00","inspection_id":"87813192","insp_unit_id":"213484076","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"1","insp_unit_license":"751BQWX","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRHL5TG153311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:13.000000Z","updated_at":"2026-05-22T09:03:41.000000Z"},{"id":20649188,"change_date":"2026-05-11 21:39:00","inspection_id":"87813192","insp_unit_id":"213484077","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"1T","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-13T13:05:13.000000Z","updated_at":"2026-05-22T09:03:41.000000Z"}]},{"id":6556601,"change_date":"2024-08-26 21:41:00","inspection_id":"82478906","dot_number":"3241566","report_state":"TN","report_number":"I037D80828","insp_date":"2024-08-19 00:00:00","insp_start_time":"1044","insp_end_time":"1155","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"NASHVILLE TN","county_code_state":"TN","county_code":"037","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":"2024-08-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"2","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":"781691","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2024-08-26 21:41:00","snet_input_date":"2024-08-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-26 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:50.000000Z","updated_at":"2025-03-17T20:32:50.000000Z","inspection_violations":[{"id":10187371,"change_date":"2024-08-26 21:41:00","inspection_id":"82478906","insp_violation_id":"261392261","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"202571570","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"39375C"},{"id":10187372,"change_date":"2024-08-26 21:41:00","inspection_id":"82478906","insp_violation_id":"261392262","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10570020,"change_date":"2024-08-26 21:41:00","inspection_id":"82478906","insp_unit_id":"202571569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"23","insp_unit_license":"C878HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"},{"id":10570021,"change_date":"2024-08-26 21:41:00","inspection_id":"82478906","insp_unit_id":"202571570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"22GN 304","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:31.000000Z","updated_at":"2025-03-17T23:32:31.000000Z"}]},{"id":5574193,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","dot_number":"3241566","report_state":"AL","report_number":"MLCV009388","insp_date":"2024-04-23 00:00:00","insp_start_time":"0455","insp_end_time":"0525","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I 459 N@IRONDALE","county_code_state":"AL","county_code":"073","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ADS","shipping_paper_number":"8371169","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-04-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35400","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":"1001894","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2024-04-23 21:40:00","snet_input_date":"2024-04-23 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-04-23 21:40:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"101826","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:09.000000Z","updated_at":"2025-03-17T20:13:09.000000Z","inspection_violations":[{"id":8615396,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_violation_id":"259078054","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200526162","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39617C"},{"id":8615397,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_violation_id":"259078055","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200526163","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"39617C"},{"id":8615398,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_violation_id":"259078056","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200526163","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3939A"},{"id":8615399,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_violation_id":"259078057","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"200526163","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:43.000000Z","updated_at":"2025-03-17T21:47:43.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8978862,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_unit_id":"200526162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"23","insp_unit_license":"C878HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:32.000000Z","updated_at":"2025-03-17T23:16:32.000000Z"},{"id":8978863,"change_date":"2024-04-23 21:40:00","inspection_id":"81419829","insp_unit_id":"200526163","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"22T","insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:32.000000Z","updated_at":"2025-03-17T23:16:32.000000Z"}]},{"id":4744338,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","dot_number":"3241566","report_state":"TN","report_number":"TCKL000603","insp_date":"2024-01-01 00:00:00","insp_start_time":"0932","insp_end_time":"1019","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I40 E","county_code_state":"TN","county_code":"035","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"TRANE TECH","shipping_paper_number":"4NA7232763","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-01-02 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"42000","viol_total":"4","oos_total":"2","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1700228","transaction_code":"A","transaction_date":"2024-01-01 00:00:00","upload_date":"2024-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2024-01-02 21:43:00","snet_input_date":"2024-01-02 00:00:00","source_office":"2TNS001","mcmis_add_date":"2024-01-02 21:43:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:52.000000Z","updated_at":"2025-03-17T19:56:52.000000Z","inspection_violations":[{"id":7322499,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_violation_id":"257138986","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"241455325","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3958E1"},{"id":7322500,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_violation_id":"257138987","seq_no":"2","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"241455325","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"3958A1"},{"id":7322501,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_violation_id":"257138988","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"198764780","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"241455325","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39021B"},{"id":7322502,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_violation_id":"257138989","seq_no":"4","part_no":"395","part_no_section":"24(c)(1)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"241455325","created_at":"2025-03-17T21:41:23.000000Z","updated_at":"2025-03-17T21:41:23.000000Z","normalized_code":"39524C1II"}],"inspection_per_units":[{"id":7631613,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_unit_id":"198764780","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"288 RENTAL","insp_unit_license":"H480046","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRHL1PG623114","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"},{"id":7631614,"change_date":"2024-01-02 21:43:00","inspection_id":"80513637","insp_unit_id":"198764781","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"22GN 304","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:14.000000Z","updated_at":"2025-03-17T23:04:14.000000Z"}]},{"id":4598029,"change_date":"2023-12-11 21:41:00","inspection_id":"80353667","dot_number":"3241566","report_state":"AR","report_number":"758C001169","insp_date":"2023-12-10 00:00:00","insp_start_time":"1605","insp_end_time":"1640","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-302","location_desc":"CRAWFORD COUNTY(ALMA WEST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"TRANE TECHNOLOGIES","shipping_paper_number":"BME8613294","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"40000","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":"1489509","transaction_code":"A","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":"M","census_search_date":"2023-12-11 21:41:00","snet_input_date":"2023-12-11 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-12-11 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:50.000000Z","updated_at":"2025-03-17T19:53:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7395278,"change_date":"2023-12-11 21:41:00","inspection_id":"80353667","insp_unit_id":"198437162","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"02","insp_unit_license":"C878HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:11.000000Z","updated_at":"2025-03-17T23:02:11.000000Z"},{"id":7395279,"change_date":"2023-12-11 21:41:00","inspection_id":"80353667","insp_unit_id":"198437163","insp_unit_type_id":"7","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"02","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:11.000000Z","updated_at":"2025-03-17T23:02:11.000000Z"}]},{"id":4493152,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","dot_number":"3241566","report_state":"TN","report_number":"TERH000420","insp_date":"2023-11-22 00:00:00","insp_start_time":"1100","insp_end_time":"1149","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-65 NB","county_code_state":"TN","county_code":"147","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"NONE","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-11-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1690990","transaction_code":"A","transaction_date":"2023-11-22 00:00:00","upload_date":"2023-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-11-27 21:41:00","snet_input_date":"2023-11-27 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-11-27 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:51:50.000000Z","updated_at":"2025-03-17T19:51:50.000000Z","inspection_violations":[{"id":6952951,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_violation_id":"256561378","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"1","insp_unit_id":"198212213","insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3958E1"},{"id":6952952,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_violation_id":"256561379","seq_no":"2","part_no":"395","part_no_section":"3(a)(3)(i)","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-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3953A3I"},{"id":6952953,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_violation_id":"256561380","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198212214","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"39343"},{"id":6952954,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_violation_id":"256561381","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198212213","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:32.000000Z","updated_at":"2025-03-17T21:39:32.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7226098,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_unit_id":"198212213","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"02","insp_unit_license":"C878HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:42.000000Z","updated_at":"2025-03-17T23:00:42.000000Z"},{"id":7226099,"change_date":"2023-11-27 21:41:00","inspection_id":"80238355","insp_unit_id":"198212214","insp_unit_type_id":"7","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"02","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:42.000000Z","updated_at":"2025-03-17T23:00:42.000000Z"}]},{"id":4281817,"change_date":"2023-10-25 21:42:00","inspection_id":"80005040","dot_number":"3241566","report_state":"MS","report_number":"5017101563","insp_date":"2023-10-24 00:00:00","insp_start_time":"1113","insp_end_time":"1200","registration_date":null,"region":"CT","ci_status_code":"C","location":"38","location_desc":"HWY 45 SOUTH","county_code_state":"MS","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TRANE U.S. INC","shipping_paper_number":"BME 8523230","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1050862","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-25 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:49.000000Z","updated_at":"2025-03-17T19:47:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6886133,"change_date":"2023-10-25 21:42:00","inspection_id":"80005040","insp_unit_id":"197740211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"23","insp_unit_license":"C878HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"Y","insp_unit_decal_number":"33318467","created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"},{"id":6886134,"change_date":"2023-10-25 21:42:00","inspection_id":"80005040","insp_unit_id":"197740212","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"003","insp_unit_license":"388605T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16V3F4824P6288304","insp_unit_decal":"Y","insp_unit_decal_number":"33318468","created_at":"2025-03-17T22:57:45.000000Z","updated_at":"2025-03-17T22:57:45.000000Z"}]},{"id":4134031,"change_date":"2023-10-05 21:40:00","inspection_id":"79841790","dot_number":"3241566","report_state":"TN","report_number":"TBWG002708","insp_date":"2023-10-04 00:00:00","insp_start_time":"1144","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"INTERSTATE 65","county_code_state":"TN","county_code":"055","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CUSTOM VINYLS","shipping_paper_number":"623100410318249","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35400","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":"1678711","transaction_code":"A","transaction_date":"2023-10-04 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-10-05 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:29.000000Z","updated_at":"2025-03-17T19:44:29.000000Z","inspection_violations":[{"id":6398373,"change_date":"2023-10-05 21:40:00","inspection_id":"79841790","insp_violation_id":"255677447","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197415516","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"3922"},{"id":6398374,"change_date":"2023-10-05 21:40:00","inspection_id":"79841790","insp_violation_id":"255677448","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197415516","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:36:49.000000Z","updated_at":"2025-03-17T21:36:49.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":6647114,"change_date":"2023-10-05 21:40:00","inspection_id":"79841790","insp_unit_id":"197415516","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"22","insp_unit_license":"C864HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3D73M4CL7BG624638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:46.000000Z","updated_at":"2025-03-17T22:55:46.000000Z"},{"id":6647115,"change_date":"2023-10-05 21:40:00","inspection_id":"79841790","insp_unit_id":"197415517","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:46.000000Z","updated_at":"2025-03-17T22:55:46.000000Z"}]},{"id":4114107,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","dot_number":"3241566","report_state":"SC","report_number":"B315003295","insp_date":"2023-10-03 00:00:00","insp_start_time":"1309","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"102","location_desc":"I-20 WB ROADSIDE","county_code_state":"SC","county_code":"003","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"ST GEORGE WAREHOUSE","shipping_paper_number":"60105989181","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-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"35400","viol_total":"7","oos_total":"0","driver_viol_total":"7","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1108980","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-10-03 00:00:00","source_office":"2SCS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:04.000000Z","updated_at":"2025-03-17T19:44:04.000000Z","inspection_violations":[{"id":6365551,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624651","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","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:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3958E1"},{"id":6365552,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624652","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","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:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3958E1"},{"id":6365553,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624653","seq_no":"3","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3953A3I"},{"id":6365554,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624654","seq_no":"4","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3953A3I"},{"id":6365555,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624655","seq_no":"5","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3953A2"},{"id":6365556,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624656","seq_no":"6","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3953A2"},{"id":6365557,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_violation_id":"255624657","seq_no":"7","part_no":"395","part_no_section":"3(a)(3)(ii)","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:36:42.000000Z","updated_at":"2025-03-17T21:36:42.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":6614551,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_unit_id":"197369785","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"22","insp_unit_license":"C864HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3D73M4CL7BG624638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:29.000000Z","updated_at":"2025-03-17T22:55:29.000000Z"},{"id":6614552,"change_date":"2023-10-03 21:41:00","inspection_id":"79819715","insp_unit_id":"197369786","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"001","insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:29.000000Z","updated_at":"2025-03-17T22:55:29.000000Z"}]},{"id":4022111,"change_date":"2023-09-21 21:40:00","inspection_id":"79717222","dot_number":"3241566","report_state":"TN","report_number":"TEYU000195","insp_date":"2023-09-20 00:00:00","insp_start_time":"1059","insp_end_time":"1126","registration_date":null,"region":"CT","ci_status_code":"C","location":"71","location_desc":"PARKING LOT","county_code_state":"TN","county_code":"141","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-09-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37400","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":"1675136","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-09-21 21:40:00","snet_input_date":"2023-09-21 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-09-21 21:40:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:22.000000Z","updated_at":"2025-03-17T19:42:22.000000Z","inspection_violations":[{"id":6224868,"change_date":"2023-09-21 21:40:00","inspection_id":"79717222","insp_violation_id":"255396318","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"197163068","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:04.000000Z","updated_at":"2025-03-17T21:36:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6467049,"change_date":"2023-09-21 21:40:00","inspection_id":"79717222","insp_unit_id":"197163067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"C864HS","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3D73M4CL7BG624638","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:17.000000Z","updated_at":"2025-03-17T22:54:17.000000Z"},{"id":6467050,"change_date":"2023-09-21 21:40:00","inspection_id":"79717222","insp_unit_id":"197163068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"388604T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:17.000000Z","updated_at":"2025-03-17T22:54:17.000000Z"}]},{"id":2829135,"change_date":"2023-04-18 21:42:00","inspection_id":"78377354","dot_number":"3241566","report_state":"OH","report_number":"3245015377","insp_date":"2023-04-18 00:00:00","insp_start_time":"1350","insp_end_time":"1430","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"REST AREA SB 75 HANCOCK","county_code_state":"OH","county_code":"063","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"KM INTERNATIONAL","shipping_paper_number":"185","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-04-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1651117","transaction_code":"A","transaction_date":"2023-04-18 00:00:00","upload_date":"2023-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-04-18 21:42:00","snet_input_date":"2023-04-18 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-04-18 21:42:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:54.000000Z","updated_at":"2025-03-17T19:18:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4553951,"change_date":"2023-04-18 21:42:00","inspection_id":"78377354","insp_unit_id":"194448305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"001","insp_unit_license":"H470868","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"},{"id":4553952,"change_date":"2023-04-18 21:42:00","inspection_id":"78377354","insp_unit_id":"194448306","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"001","insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:54.000000Z","updated_at":"2025-03-17T22:38:54.000000Z"}]},{"id":2074619,"change_date":"2023-01-05 21:40:00","inspection_id":"77517034","dot_number":"3241566","report_state":"TN","report_number":"TFFA000056","insp_date":"2023-01-04 00:00:00","insp_start_time":"1530","insp_end_time":"1626","registration_date":null,"region":"CT","ci_status_code":"C","location":"75","location_desc":"I24 W","county_code_state":"TN","county_code":"149","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"ENPROTECH INDUSTRIAL TECHNOLOGLES","shipping_paper_number":"18381","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-01-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1620853","transaction_code":"A","transaction_date":"2023-01-04 00:00:00","upload_date":"2023-01-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2023-01-05 21:40:00","snet_input_date":"2023-01-05 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-01-05 21:40:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:47.000000Z","updated_at":"2025-03-17T19:04:47.000000Z","inspection_violations":[{"id":3210837,"change_date":"2023-01-05 21:40:00","inspection_id":"77517034","insp_violation_id":"250403011","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"025596H","created_at":"2025-03-17T21:22:13.000000Z","updated_at":"2025-03-17T21:22:13.000000Z","normalized_code":"38351A"}],"inspection_per_units":[{"id":3337754,"change_date":"2023-01-05 21:40:00","inspection_id":"77517034","insp_unit_id":"192715303","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"001","insp_unit_license":"H470868","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:53.000000Z","updated_at":"2025-03-17T22:29:53.000000Z"},{"id":3337755,"change_date":"2023-01-05 21:40:00","inspection_id":"77517034","insp_unit_id":"192715304","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"001","insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:53.000000Z","updated_at":"2025-03-17T22:29:53.000000Z"}]},{"id":1494872,"change_date":"2022-10-12 21:41:00","inspection_id":"76852781","dot_number":"3241566","report_state":"KY","report_number":"CV42952092","insp_date":"2022-10-11 00:00:00","insp_start_time":"1251","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"BOWLING GREEN","county_code_state":"KY","county_code":"227","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BOWLING GREEN METAL FORMING","shipping_paper_number":"973839","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"2127329","transaction_code":"A","transaction_date":"2022-10-12 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":"M","census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-12 00:00:00","source_office":"2KYS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:10.000000Z","updated_at":"2025-03-17T18:54:10.000000Z","inspection_violations":[{"id":2352972,"change_date":"2022-10-12 21:41:00","inspection_id":"76852781","insp_violation_id":"248975628","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":"ED97509","created_at":"2025-03-17T21:17:46.000000Z","updated_at":"2025-03-17T21:17:46.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2405566,"change_date":"2022-10-12 21:41:00","inspection_id":"76852781","insp_unit_id":"191394217","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"H470868","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:29.000000Z","updated_at":"2025-03-17T22:23:29.000000Z"},{"id":2405567,"change_date":"2022-10-12 21:41:00","inspection_id":"76852781","insp_unit_id":"191394218","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:29.000000Z","updated_at":"2025-03-17T22:23:29.000000Z"}]},{"id":944091,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","dot_number":"3241566","report_state":"OH","report_number":"3288015203","insp_date":"2022-08-01 00:00:00","insp_start_time":"1655","insp_end_time":"1755","registration_date":null,"region":"ET","ci_status_code":"C","location":"16571","location_desc":"ROADSIDE","county_code_state":"OH","county_code":"165","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"PREMIER PUMP","shipping_paper_number":"316554","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":"2022-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"9","oos_total":"2","driver_viol_total":"4","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1609447","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-08-02 00:00:00","source_office":"3OHS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:22.000000Z","updated_at":"2025-03-17T18:44:22.000000Z","inspection_violations":[{"id":1488706,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458688","seq_no":"1","part_no":"383","part_no_section":"51(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"38351A"},{"id":1488707,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458689","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"190087950","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39360D"},{"id":1488708,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458690","seq_no":"3","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"190087950","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3969D2"},{"id":1488709,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458691","seq_no":"4","part_no":"395","part_no_section":"8(e)(1)","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:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3958E1"},{"id":1488710,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458692","seq_no":"5","part_no":"395","part_no_section":"8(e)(1)","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:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3958E1"},{"id":1488711,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458693","seq_no":"6","part_no":"395","part_no_section":"8(e)(1)","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:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3958E1"},{"id":1488712,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458694","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190087950","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3939A"},{"id":1488713,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458695","seq_no":"8","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"190087951","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39343D"},{"id":1488714,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_violation_id":"247458696","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190087951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1520086,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_unit_id":"190087950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"001","insp_unit_license":"H470868","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:35.000000Z","updated_at":"2025-03-17T22:17:35.000000Z"},{"id":1520087,"change_date":"2022-08-02 21:40:00","inspection_id":"76212365","insp_unit_id":"190087951","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"001","insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:35.000000Z","updated_at":"2025-03-17T22:17:35.000000Z"}]},{"id":818532,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","dot_number":"3241566","report_state":"NE","report_number":"PJ00004372","insp_date":"2022-07-14 00:00:00","insp_start_time":"1135","insp_end_time":"1206","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LINCOLN","county_code_state":"NE","county_code":"109","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"BOATMATE TRAILERS, LLC","shipping_paper_number":"0000126934","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":null,"post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"736033","transaction_code":"C","transaction_date":"2022-07-19 00:00:00","upload_date":"2022-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":"M","census_search_date":"2022-07-19 21:40:00","snet_input_date":"2022-07-14 00:00:00","source_office":"3NES001","mcmis_add_date":"2022-07-14 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:00.000000Z","updated_at":"2025-03-17T18:42:00.000000Z","inspection_violations":[{"id":1289695,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_violation_id":"247185323","seq_no":"1","part_no":"393","part_no_section":"52(a)(1)","insp_viol_unit":"2","insp_unit_id":"189857862","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"39352A1"},{"id":1289696,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_violation_id":"247185324","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"189857862","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"EF3404856","created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"39343D"},{"id":1289697,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_violation_id":"247185325","seq_no":"3","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":"EF3404856","created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"3922"},{"id":1289698,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_violation_id":"247185326","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:05.000000Z","updated_at":"2025-03-17T21:13:05.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1316857,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_unit_id":"189857861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"001","insp_unit_license":"H470868","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"},{"id":1316858,"change_date":"2022-07-19 21:40:00","inspection_id":"76065266","insp_unit_id":"189857862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"001","insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:17.000000Z","updated_at":"2025-03-17T22:16:17.000000Z"}]},{"id":288547,"change_date":"2022-04-29 21:41:00","inspection_id":"75437547","dot_number":"3241566","report_state":"TN","report_number":"MDJD001086","insp_date":"2022-04-28 00:00:00","insp_start_time":"0633","insp_end_time":"0700","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"INTERSTATE 40","county_code_state":"TN","county_code":"077","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"A & K LOGISTICS","shipping_paper_number":"186081","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":"2022-04-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","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":"1568934","transaction_code":"A","transaction_date":"2022-04-28 00:00:00","upload_date":"2022-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03241566","upload_search_indicator":null,"census_search_date":"2022-04-29 21:41:00","snet_input_date":"2022-04-29 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-04-29 21:41:00","insp_carrier_name":"BORDEAUX TN TRUCKING","insp_carrier_street":"4080 HAVENDALE RD","insp_carrier_city":"NASHVILLE","insp_carrier_state":"TN","insp_carrier_zip_code":"37207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:35.000000Z","updated_at":"2025-03-17T18:32:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":466797,"change_date":"2022-04-29 21:41:00","inspection_id":"75437547","insp_unit_id":"188424766","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"TEMPTAG","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63RRGL5LG187217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"},{"id":466798,"change_date":"2022-04-29 21:41:00","inspection_id":"75437547","insp_unit_id":"188424767","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"1T","insp_unit_license":"033650T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"16VGX352XK6017561","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:04.000000Z","updated_at":"2025-03-17T22:11:04.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3241566\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3241566\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3241566\/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\/3241566\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}