{"current_page":1,"data":[{"id":12192560,"change_date":"2026-06-15 21:41:00","inspection_id":"88148585","dot_number":"473726","report_state":"DE","report_number":"1206001305","insp_date":"2026-06-15 00:00:00","insp_start_time":"1344","insp_end_time":"1351","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"NEWARK DE","county_code_state":"DE","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121000","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":"3548869","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2026-06-15 21:41:00","snet_input_date":"2026-06-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-15 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-18T09:41:02.000000Z","updated_at":"2026-06-26T09:31:13.000000Z","inspection_violations":[{"id":21218271,"change_date":"2026-06-15 21:41:00","inspection_id":"88148585","insp_violation_id":"274919122","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":null,"created_at":"2026-06-18T10:00:59.000000Z","updated_at":"2026-06-26T09:42:52.000000Z","normalized_code":"3922SLLTR"}],"inspection_per_units":[{"id":21177215,"change_date":"2026-06-15 21:41:00","inspection_id":"88148585","insp_unit_id":"214111096","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3117686","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR7NSMZ5241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:55.000000Z","updated_at":"2026-06-26T09:02:33.000000Z"},{"id":21177216,"change_date":"2026-06-15 21:41:00","inspection_id":"88148585","insp_unit_id":"214111097","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":null,"insp_unit_license":"852370TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7525901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-18T09:17:55.000000Z","updated_at":"2026-06-26T09:02:33.000000Z"}]},{"id":12125200,"change_date":"2026-06-10 21:44:00","inspection_id":"88070940","dot_number":"473726","report_state":"NC","report_number":"0006882931","insp_date":"2026-06-08 00:00:00","insp_start_time":"1005","insp_end_time":"1047","registration_date":null,"region":"ED","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON NC","county_code_state":"NC","county_code":"155","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B & F CERAMICS","shipping_paper_number":"C26060523539","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-09 10:49:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3491033","transaction_code":"C","transaction_date":"2026-06-10 00:00:00","upload_date":"2026-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2026-06-09 10:49:00","snet_input_date":"2026-06-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-09 10:49:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-12T09:39:43.000000Z","updated_at":"2026-06-21T09:30:09.000000Z","inspection_violations":[{"id":21102713,"change_date":"2026-06-10 21:44:00","inspection_id":"88070940","insp_violation_id":"274807654","seq_no":"1","part_no":"395","part_no_section":"3A3II","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":"2026-06-12T09:58:06.000000Z","updated_at":"2026-06-21T09:44:19.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":21066474,"change_date":"2026-06-10 21:44:00","inspection_id":"88070940","insp_unit_id":"214008403","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3525234","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR5RSVF9973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:05.000000Z","updated_at":"2026-06-21T09:00:57.000000Z"},{"id":21066475,"change_date":"2026-06-10 21:44:00","inspection_id":"88070940","insp_unit_id":"214008404","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC62773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9629RB544972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-12T09:15:05.000000Z","updated_at":"2026-06-21T09:00:57.000000Z"}]},{"id":11840153,"change_date":"2026-05-06 21:41:00","inspection_id":"87775674","dot_number":"473726","report_state":"NC","report_number":"0006872351","insp_date":"2026-05-05 00:00:00","insp_start_time":"1135","insp_end_time":"1153","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS DESIGN SHOWR","shipping_paper_number":"919965","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-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2402853","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2026-05-06 21:41:00","snet_input_date":"2026-05-06 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-05-06 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-09T09:40:18.000000Z","updated_at":"2026-05-16T13:24:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20590906,"change_date":"2026-05-06 21:41:00","inspection_id":"87775674","insp_unit_id":"213413768","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407775","insp_unit_license":"3527455","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR3RSVF9972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:26.000000Z","updated_at":"2026-05-16T12:31:55.000000Z"},{"id":20590907,"change_date":"2026-05-06 21:41:00","inspection_id":"87775674","insp_unit_id":"213413769","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410428","insp_unit_license":"PC62680","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A962XRB621154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-09T09:18:26.000000Z","updated_at":"2026-05-16T12:31:55.000000Z"}]},{"id":11642467,"change_date":"2026-04-14 21:39:00","inspection_id":"87571702","dot_number":"473726","report_state":"NC","report_number":"0006864322","insp_date":"2026-04-10 00:00:00","insp_start_time":"1247","insp_end_time":"1322","registration_date":null,"region":"ET","ci_status_code":"C","location":"STATES","location_desc":"STATESVILLE WEIGH STATION, I-4","county_code_state":"NC","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS","shipping_paper_number":"A1009735","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2394852","transaction_code":"A","transaction_date":"2026-04-10 00:00:00","upload_date":"2026-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2026-04-14 21:39:00","snet_input_date":"2026-04-13 00:00:00","source_office":"2NCS001","mcmis_add_date":"2026-04-14 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-25T09:30:53.000000Z","updated_at":"2026-04-25T09:30:53.000000Z","inspection_violations":[{"id":20214060,"change_date":"2026-04-14 21:39:00","inspection_id":"87571702","insp_violation_id":"273591293","seq_no":"1","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"213006986","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3320755","created_at":"2026-04-25T09:42:10.000000Z","updated_at":"2026-04-25T09:42:10.000000Z","normalized_code":"39375A"},{"id":20214061,"change_date":"2026-04-14 21:39:00","inspection_id":"87571702","insp_violation_id":"273591294","seq_no":"2","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3320755","created_at":"2026-04-25T09:42:10.000000Z","updated_at":"2026-04-25T09:42:10.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":20251839,"change_date":"2026-04-14 21:39:00","inspection_id":"87571702","insp_unit_id":"213006986","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:31.000000Z","updated_at":"2026-04-25T09:03:31.000000Z"},{"id":20251840,"change_date":"2026-04-14 21:39:00","inspection_id":"87571702","insp_unit_id":"213006987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC62679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9628RB621153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:03:31.000000Z","updated_at":"2026-04-25T09:03:31.000000Z"}]},{"id":10350698,"change_date":"2025-12-12 21:41:00","inspection_id":"86478606","dot_number":"473726","report_state":"KY","report_number":"S228000048","insp_date":"2025-12-03 00:00:00","insp_start_time":"1624","insp_end_time":"1724","registration_date":"2025-12-12 00:00:00","region":"CT","ci_status_code":"C","location":"9813","location_desc":"KUTTAWA","county_code_state":"KY","county_code":"143","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMIC DESIGN SHOWROOM","shipping_paper_number":"C25120163923","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-12-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2320240","transaction_code":"C","transaction_date":"2025-12-04 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2025-12-04 21:38:00","snet_input_date":"2025-12-04 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-12-04 21:38:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-07T10:31:43.000000Z","updated_at":"2025-12-23T10:30:40.000000Z","inspection_violations":[{"id":17469404,"change_date":"2025-12-12 21:41:00","inspection_id":"86478606","insp_violation_id":"270652305","seq_no":"1","part_no":"395","part_no_section":"3A3II","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-15T10:33:42.000000Z","updated_at":"2025-12-23T10:31:18.000000Z","normalized_code":"3953A3II"},{"id":17469405,"change_date":"2025-12-12 21:41:00","inspection_id":"86478606","insp_violation_id":"270652306","seq_no":"2","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-12-15T10:33:42.000000Z","updated_at":"2025-12-23T10:31:18.000000Z","normalized_code":"3953A1HOSPD"}],"inspection_per_units":[{"id":17427119,"change_date":"2025-12-12 21:41:00","inspection_id":"86478606","insp_unit_id":"210577618","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"222493","insp_unit_license":"3399410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDRXRSUK6923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:41.000000Z","updated_at":"2025-12-23T10:00:47.000000Z"},{"id":17427120,"change_date":"2025-12-12 21:41:00","inspection_id":"86478606","insp_unit_id":"210577619","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"400115","insp_unit_license":"852369TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7526501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:41.000000Z","updated_at":"2025-12-23T10:00:47.000000Z"}]},{"id":10301879,"change_date":"2025-11-27 21:34:00","inspection_id":"86427657","dot_number":"473726","report_state":"NC","report_number":"0006823733","insp_date":"2025-11-26 00:00:00","insp_start_time":"1050","insp_end_time":"1110","registration_date":null,"region":"ET","ci_status_code":"C","location":"EXIT 3","location_desc":"EXIT 3 OFF RAMP EB","county_code_state":"NC","county_code":"115","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-27 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2354468","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-11-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-11-27 21:34:00","snet_input_date":"2025-11-27 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-11-27 21:34:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-30T10:31:17.000000Z","updated_at":"2025-12-01T10:30:26.000000Z","inspection_violations":[{"id":17231179,"change_date":"2025-11-27 21:34:00","inspection_id":"86427657","insp_violation_id":"270330590","seq_no":"1","part_no":"392","part_no_section":"2LV","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-11-30T10:32:03.000000Z","updated_at":"2025-12-01T10:30:38.000000Z","normalized_code":"3922LV"}],"inspection_per_units":[{"id":17202388,"change_date":"2025-11-27 21:34:00","inspection_id":"86427657","insp_unit_id":"210295006","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3529471","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHLDV9RSVF9975","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-30T10:01:28.000000Z","updated_at":"2025-12-01T10:00:27.000000Z"},{"id":17202389,"change_date":"2025-11-27 21:34:00","inspection_id":"86427657","insp_unit_id":"210295007","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC62678","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9626RB621152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-30T10:01:28.000000Z","updated_at":"2025-12-01T10:00:27.000000Z"}]},{"id":10229230,"change_date":"2025-11-18 21:38:00","inspection_id":"86351362","dot_number":"473726","report_state":"NC","report_number":"0006819909","insp_date":"2025-11-17 00:00:00","insp_start_time":"1425","insp_end_time":"1440","registration_date":null,"region":"ET","ci_status_code":"C","location":"I140 N","location_desc":"I140 NEAR US 74","county_code_state":"NC","county_code":"019","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2349777","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2025-11-18 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-11-18 21:38:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-21T10:31:46.000000Z","updated_at":"2025-11-23T10:30:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17044767,"change_date":"2025-11-18 21:38:00","inspection_id":"86351362","insp_unit_id":"210098875","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3775341","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3HSDZTZR5PN274006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:54.000000Z","updated_at":"2025-11-23T10:00:56.000000Z"},{"id":17044768,"change_date":"2025-11-18 21:38:00","inspection_id":"86351362","insp_unit_id":"210098876","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"852385","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2486N7743001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-21T10:01:54.000000Z","updated_at":"2025-11-23T10:00:56.000000Z"}]},{"id":9899080,"change_date":"2025-10-09 21:41:00","inspection_id":"86003426","dot_number":"473726","report_state":"NC","report_number":"0006805305","insp_date":"2025-10-07 00:00:00","insp_start_time":"0750","insp_end_time":"0804","registration_date":null,"region":"ET","ci_status_code":"C","location":"ORANGE","location_desc":"ORANGE COUNTY","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F","shipping_paper_number":"C1014737","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-10-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2334575","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-10-09 21:41:00","snet_input_date":"2025-10-07 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-10-09 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:02:01.000000Z","updated_at":"2025-10-13T10:01:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16426812,"change_date":"2025-10-09 21:41:00","inspection_id":"86003426","insp_unit_id":"209386232","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407775","insp_unit_license":"3527455","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR3RSVF9972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:22.000000Z","updated_at":"2025-10-13T09:46:20.000000Z"},{"id":16426813,"change_date":"2025-10-09 21:41:00","inspection_id":"86003426","insp_unit_id":"209386233","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410428","insp_unit_license":"PC62680","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A962XRB621154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:22.000000Z","updated_at":"2025-10-13T09:46:20.000000Z"}]},{"id":9643709,"change_date":"2025-09-10 21:40:00","inspection_id":"85735423","dot_number":"473726","report_state":"NC","report_number":"0006796622","insp_date":"2025-09-09 00:00:00","insp_start_time":"1708","insp_end_time":"1725","registration_date":null,"region":"ET","ci_status_code":"C","location":"WARREN","location_desc":"WARREN COUNTY, I-85, N","county_code_state":"NC","county_code":"185","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"STRAIGHT BILL","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-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2326968","transaction_code":"A","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-09-10 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-09-10 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:36.000000Z","updated_at":"2025-09-13T10:47:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15933808,"change_date":"2025-09-10 21:40:00","inspection_id":"85735423","insp_unit_id":"208851198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400179","insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"},{"id":15933809,"change_date":"2025-09-10 21:40:00","inspection_id":"85735423","insp_unit_id":"208851199","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410427","insp_unit_license":"PC62679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9628RB621153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:24.000000Z","updated_at":"2025-09-13T10:00:24.000000Z"}]},{"id":9215910,"change_date":"2025-07-22 21:42:00","inspection_id":"85285817","dot_number":"473726","report_state":"NC","report_number":"0006778507","insp_date":"2025-07-21 00:00:00","insp_start_time":"0813","insp_end_time":"0827","registration_date":null,"region":"ET","ci_status_code":"C","location":"ORANGE","location_desc":"ORANGE COUNTY","county_code_state":"NC","county_code":"135","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS","shipping_paper_number":"B1006596","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2310084","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-22 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:59.000000Z","updated_at":"2025-07-27T10:40:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15156424,"change_date":"2025-07-22 21:42:00","inspection_id":"85285817","insp_unit_id":"208011963","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407775","insp_unit_license":"3527455","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR3RSVF9972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:42.000000Z","updated_at":"2025-07-26T09:46:00.000000Z"},{"id":15156425,"change_date":"2025-07-22 21:42:00","inspection_id":"85285817","insp_unit_id":"208011964","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410428","insp_unit_license":"PC62680","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A962XRB621154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:42.000000Z","updated_at":"2025-07-26T09:46:00.000000Z"}]},{"id":9212711,"change_date":"2025-07-22 21:41:00","inspection_id":"85282471","dot_number":"473726","report_state":"MD","report_number":"3281C00103","insp_date":"2025-07-16 00:00:00","insp_start_time":"1102","insp_end_time":"1143","registration_date":null,"region":"ED","ci_status_code":"C","location":"011015","location_desc":"PERRYVILLE MD","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"B & F CERAMIC DESIGNS","shipping_paper_number":"874642","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-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2025129","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-07-22 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:46.000000Z","updated_at":"2025-07-27T10:40:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15147817,"change_date":"2025-07-22 21:41:00","inspection_id":"85282471","insp_unit_id":"208001035","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"400178","insp_unit_license":"3117686","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR7NSMZ5241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:37.000000Z","updated_at":"2025-07-26T09:45:31.000000Z"},{"id":15147818,"change_date":"2025-07-22 21:41:00","inspection_id":"85282471","insp_unit_id":"208001036","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"400116","insp_unit_license":"852370TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7525901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:37.000000Z","updated_at":"2025-07-26T09:45:31.000000Z"}]},{"id":8724357,"change_date":"2025-05-23 21:39:00","inspection_id":"84766654","dot_number":"473726","report_state":"NC","report_number":"0006759462","insp_date":"2025-05-22 00:00:00","insp_start_time":"1038","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION, I-","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B AND F","shipping_paper_number":"A1008688","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"2290592","transaction_code":"A","transaction_date":"2025-05-22 00:00:00","upload_date":"2025-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-23 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:25.000000Z","updated_at":"2025-05-27T10:03:28.000000Z","inspection_violations":[{"id":13919380,"change_date":"2025-05-23 21:39:00","inspection_id":"84766654","insp_violation_id":"266446128","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"207040840","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-26T10:28:54.000000Z","updated_at":"2025-05-27T10:25:39.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":14262332,"change_date":"2025-05-23 21:39:00","inspection_id":"84766654","insp_unit_id":"207040841","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"852385TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:00.000000Z","updated_at":"2025-05-27T09:50:59.000000Z"},{"id":14262331,"change_date":"2025-05-23 21:39:00","inspection_id":"84766654","insp_unit_id":"207040840","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3127776","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR5NSNS1061","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-26T09:50:00.000000Z","updated_at":"2025-05-27T09:50:59.000000Z"}]},{"id":8403559,"change_date":"2025-04-17 21:42:00","inspection_id":"84428630","dot_number":"473726","report_state":"KY","report_number":"CV43404059","insp_date":"2025-04-17 00:00:00","insp_start_time":"1116","insp_end_time":"1132","registration_date":null,"region":"ET","ci_status_code":"C","location":"9801","location_desc":"WADDY","county_code_state":"KY","county_code":"211","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMIC DESIGN","shipping_paper_number":"4008967","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-04-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2279309","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2025-04-17 21:42:00","snet_input_date":"2025-04-17 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-04-17 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:28:29.000000Z","updated_at":"2025-04-21T10:23:17.000000Z","inspection_violations":[{"id":13258019,"change_date":"2025-04-17 21:42:00","inspection_id":"84428630","insp_violation_id":"265683135","seq_no":"1","part_no":"392","part_no_section":"2IN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:58:21.000000Z","updated_at":"2025-04-20T11:06:19.000000Z","normalized_code":"3922IN"}],"inspection_per_units":[{"id":13642917,"change_date":"2025-04-17 21:42:00","inspection_id":"84428630","insp_unit_id":"206364986","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"222493","insp_unit_license":"3399410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDRXRSUK6923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:13:52.000000Z","updated_at":"2025-04-21T10:00:54.000000Z"},{"id":13642918,"change_date":"2025-04-17 21:42:00","inspection_id":"84428630","insp_unit_id":"206364987","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"400115","insp_unit_license":"852369TL","insp_unit_license_state":"VI","insp_unit_vehicle_id_number":"1UYVS2484N7526501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:13:52.000000Z","updated_at":"2025-04-21T10:00:54.000000Z"}]},{"id":8225839,"change_date":"2025-03-27 21:41:00","inspection_id":"84241431","dot_number":"473726","report_state":"NC","report_number":"0006741623","insp_date":"2025-03-25 00:00:00","insp_start_time":"0915","insp_end_time":"0935","registration_date":null,"region":"ET","ci_status_code":"C","location":"GRANVI","location_desc":"GRANVILLE COUNTY, I-85, N","county_code_state":"NC","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2274950","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-03-27 21:41:00","snet_input_date":"2025-03-27 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:30.000000Z","updated_at":"2025-03-31T10:29:52.000000Z","inspection_violations":[{"id":12907224,"change_date":"2025-03-27 21:41:00","inspection_id":"84241431","insp_violation_id":"265288265","seq_no":"1","part_no":"395","part_no_section":"22G","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-29T10:49:54.000000Z","updated_at":"2025-03-31T10:49:43.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":13306135,"change_date":"2025-03-27 21:41:00","inspection_id":"84241431","insp_unit_id":"206022879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410427","insp_unit_license":"PC62679","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9628RB621153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:22:47.000000Z","updated_at":"2025-03-31T10:02:05.000000Z"},{"id":13306136,"change_date":"2025-03-27 21:41:00","inspection_id":"84241431","insp_unit_id":"206022880","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400179","insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:22:47.000000Z","updated_at":"2025-03-31T10:02:05.000000Z"}]},{"id":8132512,"change_date":"2025-03-17 21:40:00","inspection_id":"84143266","dot_number":"473726","report_state":"VA","report_number":"6243000140","insp_date":"2025-03-14 00:00:00","insp_start_time":"1038","insp_end_time":"1101","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BEALETON VA","county_code_state":"VA","county_code":"061","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS DESIGN SHOWROOM INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1481026","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-03-17 21:40:00","snet_input_date":"2025-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-17 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:19:28.000000Z","updated_at":"2025-03-21T10:19:28.000000Z","inspection_violations":[{"id":12723026,"change_date":"2025-03-17 21:40:00","inspection_id":"84143266","insp_violation_id":"265075435","seq_no":"1","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":null,"created_at":"2025-03-21T10:43:13.000000Z","updated_at":"2025-03-21T10:50:43.000000Z","normalized_code":"3922SLL"},{"id":12723027,"change_date":"2025-03-17 21:40:00","inspection_id":"84143266","insp_violation_id":"265075436","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205832726","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-21T10:43:13.000000Z","updated_at":"2025-03-21T10:50:43.000000Z","normalized_code":"39021TB1MC"}],"inspection_per_units":[{"id":13133124,"change_date":"2025-03-17 21:40:00","inspection_id":"84143266","insp_unit_id":"205832726","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"441662","insp_unit_license":"3200279","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR0NSNP6467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:53:06.000000Z","updated_at":"2025-03-21T10:01:56.000000Z"},{"id":13133125,"change_date":"2025-03-17 21:40:00","inspection_id":"84143266","insp_unit_id":"205832727","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"377786","insp_unit_license":"852336TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2483M7352001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T09:53:06.000000Z","updated_at":"2025-03-21T10:01:56.000000Z"}]},{"id":8090777,"change_date":"2025-03-12 21:40:00","inspection_id":"84099237","dot_number":"473726","report_state":"GA","report_number":"0174000283","insp_date":"2025-03-05 00:00:00","insp_start_time":"1202","insp_end_time":"1228","registration_date":null,"region":"ES","ci_status_code":"C","location":"280","location_desc":"PEMBROKE GA","county_code_state":"GA","county_code":"029","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"NO NUMBER","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"1458583","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-03-12 21:40:00","snet_input_date":"2025-03-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-12 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:17.000000Z","updated_at":"2025-03-17T21:06:17.000000Z","inspection_violations":[{"id":12647560,"change_date":"2025-03-12 21:40:00","inspection_id":"84099237","insp_violation_id":"264965586","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA2","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-17T22:07:56.000000Z","updated_at":"2025-03-17T22:07:56.000000Z","normalized_code":"3922SLLEWA2"}],"inspection_per_units":[{"id":13063085,"change_date":"2025-03-12 21:40:00","inspection_id":"84099237","insp_unit_id":"205748870","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"407776","insp_unit_license":"3525234","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR5RSVF9973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"},{"id":13063086,"change_date":"2025-03-12 21:40:00","inspection_id":"84099237","insp_unit_id":"205748871","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"410425","insp_unit_license":"PC62773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9629RB544972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:24.000000Z","updated_at":"2025-03-17T23:59:24.000000Z"}]},{"id":8042586,"change_date":"2025-03-06 21:39:00","inspection_id":"84048517","dot_number":"473726","report_state":"TN","report_number":"I3A0831762","insp_date":"2025-03-04 00:00:00","insp_start_time":"1332","insp_end_time":"1353","registration_date":null,"region":"ES","ci_status_code":"C","location":"GRENS","location_desc":"MOHAWK TN","county_code_state":"TN","county_code":"059","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F","shipping_paper_number":"VARIOUS","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-03-06 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120220","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":"1436902","transaction_code":"A","transaction_date":"2025-03-06 00:00:00","upload_date":"2025-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-03-06 21:39:00","snet_input_date":"2025-03-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-06 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:22.000000Z","updated_at":"2025-03-17T21:05:22.000000Z","inspection_violations":[{"id":12569364,"change_date":"2025-03-06 21:39:00","inspection_id":"84048517","insp_violation_id":"264865702","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"205656596","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:07:27.000000Z","updated_at":"2025-03-17T22:07:27.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":12984500,"change_date":"2025-03-06 21:39:00","inspection_id":"84048517","insp_unit_id":"205656596","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3399410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDRXRSUK6923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:25.000000Z","updated_at":"2025-03-17T23:58:25.000000Z"},{"id":12984501,"change_date":"2025-03-06 21:39:00","inspection_id":"84048517","insp_unit_id":"205656597","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"852369TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7526501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:25.000000Z","updated_at":"2025-03-17T23:58:25.000000Z"}]},{"id":7992431,"change_date":"2025-02-28 21:41:00","inspection_id":"83995797","dot_number":"473726","report_state":"NC","report_number":"0006733231","insp_date":"2025-02-28 00:00:00","insp_start_time":"0850","insp_end_time":"0920","registration_date":null,"region":"ET","ci_status_code":"C","location":"MCLEAN","location_desc":"MCLEAN FLOOR PVA","county_code_state":"NC","county_code":"193","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS","shipping_paper_number":"A1008501","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2264719","transaction_code":"A","transaction_date":"2025-02-28 00:00:00","upload_date":"2025-02-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-02-28 21:41:00","snet_input_date":"2025-02-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-02-28 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWA Y","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"224061211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:04:06.000000Z","updated_at":"2025-03-17T21:04:06.000000Z","inspection_violations":[{"id":12488506,"change_date":"2025-02-28 21:41:00","inspection_id":"83995797","insp_violation_id":"264763813","seq_no":"1","part_no":"395","part_no_section":"3A3II","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:07:02.000000Z","updated_at":"2025-03-17T22:07:02.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":12902776,"change_date":"2025-02-28 21:41:00","inspection_id":"83995797","insp_unit_id":"205561357","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407776","insp_unit_license":"3525234","insp_unit_license_state":"PA","insp_unit_vehicle_id_number":"3AKJHHDR5RSVF9973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:31.000000Z","updated_at":"2025-03-17T23:57:31.000000Z"},{"id":12902777,"change_date":"2025-02-28 21:41:00","inspection_id":"83995797","insp_unit_id":"205561358","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC62773","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9629RB544972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:31.000000Z","updated_at":"2025-03-17T23:57:31.000000Z"}]},{"id":7814872,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","dot_number":"473726","report_state":"NC","report_number":"0006725461","insp_date":"2025-02-05 00:00:00","insp_start_time":"1635","insp_end_time":"1740","registration_date":null,"region":"ET","ci_status_code":"C","location":"STATES","location_desc":"STATESVILLE WEIGH STATION, I-4","county_code_state":"NC","county_code":"097","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS","shipping_paper_number":"C25020436086","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2257641","transaction_code":"A","transaction_date":"2025-02-06 00:00:00","upload_date":"2025-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-06 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:22.000000Z","updated_at":"2025-03-17T21:00:22.000000Z","inspection_violations":[{"id":12212394,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","insp_violation_id":"264400186","seq_no":"1","part_no":"395","part_no_section":"3A2-PROP","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-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3953A2PROP"},{"id":12212395,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","insp_violation_id":"264400187","seq_no":"2","part_no":"395","part_no_section":"3A3-PROP","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-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3953A3PROP"},{"id":12212396,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","insp_violation_id":"264400188","seq_no":"3","part_no":"395","part_no_section":"3A2-PROP","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-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3953A2PROP"}],"inspection_per_units":[{"id":12611791,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","insp_unit_id":"205214267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"},{"id":12611792,"change_date":"2025-02-07 21:40:00","inspection_id":"83809541","insp_unit_id":"205214268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"852370","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7525901","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:20.000000Z","updated_at":"2025-03-17T23:54:20.000000Z"}]},{"id":7778316,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","dot_number":"473726","report_state":"SC","report_number":"0364000217","insp_date":"2025-02-03 00:00:00","insp_start_time":"1528","insp_end_time":"1630","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MARIETTA SC","county_code_state":"SC","county_code":"045","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"BF CERAMICS","shipping_paper_number":"C25013322238","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-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"4","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":"1319875","transaction_code":"A","transaction_date":"2025-02-03 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:35.000000Z","updated_at":"2025-03-17T20:59:35.000000Z","inspection_violations":[{"id":12154100,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_violation_id":"264319571","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLS1"},{"id":12154101,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_violation_id":"264319572","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-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"39522GELDMFV"},{"id":12154102,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_violation_id":"264319573","seq_no":"3","part_no":"390","part_no_section":"3E-DAC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"WA73984","created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3903EDAC"},{"id":12154103,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_violation_id":"264319574","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"205141389","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:16.000000Z","updated_at":"2025-03-17T22:05:16.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":12553163,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_unit_id":"205141389","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLVO","insp_unit_company":null,"insp_unit_license":"3545483","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EH0RN635899","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"},{"id":12553164,"change_date":"2025-02-04 21:39:00","inspection_id":"83771126","insp_unit_id":"205141390","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"441663","insp_unit_license":"852385TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2486N7743001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:38.000000Z","updated_at":"2025-03-17T23:53:38.000000Z"}]},{"id":7645920,"change_date":"2025-01-17 21:39:00","inspection_id":"83631870","dot_number":"473726","report_state":"VA","report_number":"5443000865","insp_date":"2025-01-16 00:00:00","insp_start_time":"1000","insp_end_time":"1021","registration_date":null,"region":"ES","ci_status_code":"C","location":"MMBT","location_desc":"SUFFOLK VA","county_code_state":"VA","county_code":"800","insp_level_id":"3","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-01-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1257323","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2025-01-17 21:39:00","snet_input_date":"2025-01-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-17 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:00.000000Z","updated_at":"2025-03-17T20:57:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12337024,"change_date":"2025-01-17 21:39:00","inspection_id":"83631870","insp_unit_id":"204884741","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"202639","insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:09.000000Z","updated_at":"2025-03-17T23:51:09.000000Z"},{"id":12337025,"change_date":"2025-01-17 21:39:00","inspection_id":"83631870","insp_unit_id":"204884742","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY TR","insp_unit_company":null,"insp_unit_license":"696723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248XH7147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:09.000000Z","updated_at":"2025-03-17T23:51:09.000000Z"}]},{"id":7402941,"change_date":"2024-12-12 21:41:00","inspection_id":"83376794","dot_number":"473726","report_state":"MD","report_number":"3013004916","insp_date":"2024-12-12 00:00:00","insp_start_time":"1220","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"011","location_desc":"I-95 NORTHBOUND SCALE FACILITY","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"B & F CERAMICS","shipping_paper_number":"B & F CERAMICS","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2767931","transaction_code":"A","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2024-12-12 21:41:00","snet_input_date":"2024-12-12 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-12-12 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:43.000000Z","updated_at":"2025-03-17T20:50:43.000000Z","inspection_violations":[{"id":11568165,"change_date":"2024-12-12 21:41:00","inspection_id":"83376794","insp_violation_id":"263416152","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"204343607","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:19.000000Z","updated_at":"2025-03-17T22:02:19.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":11942458,"change_date":"2024-12-12 21:41:00","inspection_id":"83376794","insp_unit_id":"204343606","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"400178","insp_unit_license":"3117686","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR7NSMZ5241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"},{"id":11942459,"change_date":"2024-12-12 21:41:00","inspection_id":"83376794","insp_unit_id":"204343607","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"202640","insp_unit_license":"6962723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248XH7147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:51.000000Z","updated_at":"2025-03-17T23:46:51.000000Z"}]},{"id":7081373,"change_date":"2024-10-30 21:40:00","inspection_id":"83037123","dot_number":"473726","report_state":"NC","report_number":"0006695988","insp_date":"2024-10-30 00:00:00","insp_start_time":"1015","insp_end_time":"1035","registration_date":null,"region":"ET","ci_status_code":"C","location":"GRANVI","location_desc":"GRANVILLE COUNTY, I-85, S","county_code_state":"NC","county_code":"077","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS","shipping_paper_number":"B1006071","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-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2228491","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:49.000000Z","updated_at":"2025-03-17T20:43:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11420511,"change_date":"2024-10-30 21:40:00","inspection_id":"83037123","insp_unit_id":"203656557","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"202639","insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:16.000000Z","updated_at":"2025-03-17T23:41:16.000000Z"},{"id":11420512,"change_date":"2024-10-30 21:40:00","inspection_id":"83037123","insp_unit_id":"203656558","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"410426","insp_unit_license":"PC62678","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1GR1A9626RB621152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:16.000000Z","updated_at":"2025-03-17T23:41:16.000000Z"}]},{"id":6747970,"change_date":"2024-09-17 21:44:00","inspection_id":"82682504","dot_number":"473726","report_state":"NC","report_number":"0006685661","insp_date":"2024-09-13 00:00:00","insp_start_time":"1027","insp_end_time":"1043","registration_date":null,"region":"ET","ci_status_code":"C","location":"MT. AI","location_desc":"MT. AIRY WEIGH STATION N","county_code_state":"NC","county_code":"171","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS","shipping_paper_number":"A1007941","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-09-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"121220","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":"2218161","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2024-09-17 21:44:00","snet_input_date":"2024-09-17 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-09-17 21:44:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:55.000000Z","updated_at":"2025-03-17T20:36:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10880996,"change_date":"2024-09-17 21:44:00","inspection_id":"82682504","insp_unit_id":"202969373","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"},{"id":10880997,"change_date":"2024-09-17 21:44:00","inspection_id":"82682504","insp_unit_id":"202969374","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"PC62678","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:43.000000Z","updated_at":"2025-03-17T23:35:43.000000Z"}]},{"id":6652348,"change_date":"2024-09-05 21:42:00","inspection_id":"82580902","dot_number":"473726","report_state":"TN","report_number":"I3A1110284","insp_date":"2024-09-03 00:00:00","insp_start_time":"1201","insp_end_time":"1224","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOHAWK TN","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B & F CERAMICS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-09-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"816786","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-09-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:52.000000Z","updated_at":"2025-03-17T20:34:52.000000Z","inspection_violations":[{"id":10351972,"change_date":"2024-09-05 21:42:00","inspection_id":"82580902","insp_violation_id":"261624268","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202768426","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10725495,"change_date":"2024-09-05 21:42:00","inspection_id":"82580902","insp_unit_id":"202768425","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"222493","insp_unit_license":"3399410","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDRXRSUK6923","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:05.000000Z","updated_at":"2025-03-17T23:34:05.000000Z"},{"id":10725496,"change_date":"2024-09-05 21:42:00","inspection_id":"82580902","insp_unit_id":"202768426","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTILITY","insp_unit_company":"400115","insp_unit_license":"852369TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484N7526501","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:05.000000Z","updated_at":"2025-03-17T23:34:05.000000Z"}]},{"id":5225484,"change_date":"2024-03-06 21:40:00","inspection_id":"81039110","dot_number":"473726","report_state":"NC","report_number":"0006629201","insp_date":"2024-03-05 00:00:00","insp_start_time":"1425","insp_end_time":"1448","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 17N","location_desc":"US 17N\/COUNTY WAY RD","county_code_state":"NC","county_code":"019","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B & F CERAMICS DESIGN SHO","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2162791","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2024-03-06 21:40:00","snet_input_date":"2024-03-06 00:00:00","source_office":"2NCS001","mcmis_add_date":"2024-03-06 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:12.000000Z","updated_at":"2025-03-17T20:06:12.000000Z","inspection_violations":[{"id":8055534,"change_date":"2024-03-06 21:40:00","inspection_id":"81039110","insp_violation_id":"258235043","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:44:54.000000Z","updated_at":"2025-03-17T21:44:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8414621,"change_date":"2024-03-06 21:40:00","inspection_id":"81039110","insp_unit_id":"199783566","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"407776","insp_unit_license":"3525234","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR5RSVF9973","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:14.000000Z","updated_at":"2025-03-17T23:11:14.000000Z"},{"id":8414622,"change_date":"2024-03-06 21:40:00","inspection_id":"81039110","insp_unit_id":"199783567","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"202485","insp_unit_license":null,"insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1UYVS2484K7493401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:14.000000Z","updated_at":"2025-03-17T23:11:14.000000Z"}]},{"id":5209426,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","dot_number":"473726","report_state":"IN","report_number":"7791000732","insp_date":"2024-02-28 00:00:00","insp_start_time":"1141","insp_end_time":"1215","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WARSAW IN","county_code_state":"IN","county_code":"085","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS","shipping_paper_number":"40005654","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-03-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"84840","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"291977","transaction_code":"A","transaction_date":"2024-03-05 00:00:00","upload_date":"2024-03-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2024-03-05 21:40:00","snet_input_date":"2024-02-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-03-05 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:45.000000Z","updated_at":"2025-03-17T20:05:45.000000Z","inspection_violations":[{"id":8028083,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","insp_violation_id":"258196929","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:48.000000Z","updated_at":"2025-03-17T21:44:48.000000Z","normalized_code":"3958EHOSPD"},{"id":8028084,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","insp_violation_id":"258196930","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:48.000000Z","updated_at":"2025-03-17T21:44:48.000000Z","normalized_code":"3922SLLLR"},{"id":8028085,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","insp_violation_id":"258196931","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:48.000000Z","updated_at":"2025-03-17T21:44:48.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8388233,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","insp_unit_id":"199750692","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"400179","insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:59.000000Z","updated_at":"2025-03-17T23:10:59.000000Z"},{"id":8388234,"change_date":"2024-03-05 21:40:00","inspection_id":"81021615","insp_unit_id":"199750693","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GREAT DANE","insp_unit_company":"222494","insp_unit_license":"7032PE","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1GR1A9625PB450181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:59.000000Z","updated_at":"2025-03-17T23:10:59.000000Z"}]},{"id":4425046,"change_date":"2023-11-14 21:42:00","inspection_id":"80163564","dot_number":"473726","report_state":"PA","report_number":"K309331724","insp_date":"2023-11-13 00:00:00","insp_start_time":"0737","insp_end_time":"0807","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I76 W\/B AT MILE MARKER 339.","county_code_state":"PA","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2396940","transaction_code":"A","transaction_date":"2023-11-13 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-13 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:41.000000Z","updated_at":"2025-03-17T19:50:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7116499,"change_date":"2023-11-14 21:42:00","inspection_id":"80163564","insp_unit_id":"198061108","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"00179","insp_unit_license":"3117687","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR9NSMZ5242","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:45.000000Z","updated_at":"2025-03-17T22:59:45.000000Z"},{"id":7116500,"change_date":"2023-11-14 21:42:00","inspection_id":"80163564","insp_unit_id":"198061109","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NOTL","insp_unit_company":"441663","insp_unit_license":"852385TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2486N7743001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:45.000000Z","updated_at":"2025-03-17T22:59:45.000000Z"}]},{"id":4171965,"change_date":"2023-10-11 21:40:00","inspection_id":"79883638","dot_number":"473726","report_state":"NC","report_number":"0006583300","insp_date":"2023-10-10 00:00:00","insp_start_time":"1758","insp_end_time":"1834","registration_date":null,"region":"ET","ci_status_code":"C","location":"I140","location_desc":"I140","county_code_state":"NC","county_code":"129","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"2116606","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-11 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:29.000000Z","updated_at":"2025-03-17T19:45:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6708636,"change_date":"2023-10-11 21:40:00","inspection_id":"79883638","insp_unit_id":"197498067","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:15.000000Z","updated_at":"2025-03-17T22:56:15.000000Z"},{"id":6708637,"change_date":"2023-10-11 21:40:00","inspection_id":"79883638","insp_unit_id":"197498068","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"696723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248X47147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:15.000000Z","updated_at":"2025-03-17T22:56:15.000000Z"}]},{"id":3618832,"change_date":"2023-07-28 21:41:00","inspection_id":"79267419","dot_number":"473726","report_state":"TN","report_number":"TERC004932","insp_date":"2023-07-27 00:00:00","insp_start_time":"0815","insp_end_time":"0854","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"I-24","county_code_state":"TN","county_code":"031","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"B & F CERAMICS","shipping_paper_number":"40003813","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-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"1664102","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2023-07-28 21:41:00","snet_input_date":"2023-07-28 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:16.000000Z","updated_at":"2025-03-17T19:34:16.000000Z","inspection_violations":[{"id":5580449,"change_date":"2023-07-28 21:41:00","inspection_id":"79267419","insp_violation_id":"254339679","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"196248234","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:54.000000Z","updated_at":"2025-03-17T21:32:54.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":5818164,"change_date":"2023-07-28 21:41:00","inspection_id":"79267419","insp_unit_id":"196248234","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"367897","insp_unit_license":"3186558","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDV1LLME4657","insp_unit_decal":"Y","insp_unit_decal_number":"33101907","created_at":"2025-03-17T22:48:56.000000Z","updated_at":"2025-03-17T22:48:56.000000Z"},{"id":5818165,"change_date":"2023-07-28 21:41:00","inspection_id":"79267419","insp_unit_id":"196248235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"222494","insp_unit_license":"7032PE","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1GR1A9625PB450181","insp_unit_decal":"Y","insp_unit_decal_number":"33101908","created_at":"2025-03-17T22:48:56.000000Z","updated_at":"2025-03-17T22:48:56.000000Z"}]},{"id":3486463,"change_date":"2023-07-12 21:40:00","inspection_id":"79119086","dot_number":"473726","report_state":"NC","report_number":"0006555503","insp_date":"2023-07-11 00:00:00","insp_start_time":"1700","insp_end_time":"1720","registration_date":null,"region":"ET","ci_status_code":"C","location":"US 17","location_desc":"US 17 NEAR NC 130","county_code_state":"NC","county_code":"019","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2088951","transaction_code":"A","transaction_date":"2023-07-12 00:00:00","upload_date":"2023-07-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2023-07-12 21:40:00","snet_input_date":"2023-07-12 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-07-12 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:03.000000Z","updated_at":"2025-03-17T19:32:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5606213,"change_date":"2023-07-12 21:40:00","inspection_id":"79119086","insp_unit_id":"195951632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2941478","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDRXJSKA3898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:16.000000Z","updated_at":"2025-03-17T22:47:16.000000Z"},{"id":5606214,"change_date":"2023-07-12 21:40:00","inspection_id":"79119086","insp_unit_id":"195951633","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"696754TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484K7493401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:16.000000Z","updated_at":"2025-03-17T22:47:16.000000Z"}]},{"id":3442583,"change_date":"2023-07-06 21:42:00","inspection_id":"79069271","dot_number":"473726","report_state":"VA","report_number":"5876004934","insp_date":"2023-07-06 00:00:00","insp_start_time":"0843","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I85 SB SCALE","county_code_state":"VA","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"B&F CERAMICS","shipping_paper_number":"A1006419","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-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"869402","transaction_code":"A","transaction_date":"2023-07-06 00:00:00","upload_date":"2023-07-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2023-07-06 21:42:00","snet_input_date":"2023-07-06 00:00:00","source_office":"1VAS001","mcmis_add_date":"2023-07-06 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:17.000000Z","updated_at":"2025-03-17T19:31:17.000000Z","inspection_violations":[{"id":5307447,"change_date":"2023-07-06 21:42:00","inspection_id":"79069271","insp_violation_id":"253889781","seq_no":"1","part_no":"395","part_no_section":"22(h)(2)","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:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39522H2"},{"id":5307448,"change_date":"2023-07-06 21:42:00","inspection_id":"79069271","insp_violation_id":"253889782","seq_no":"2","part_no":"395","part_no_section":"22(g)","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:31:39.000000Z","updated_at":"2025-03-17T21:31:39.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":5535514,"change_date":"2023-07-06 21:42:00","inspection_id":"79069271","insp_unit_id":"195847189","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"202639","insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:43.000000Z","updated_at":"2025-03-17T22:46:43.000000Z"},{"id":5535515,"change_date":"2023-07-06 21:42:00","inspection_id":"79069271","insp_unit_id":"195847190","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"202640","insp_unit_license":"696723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248747147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:43.000000Z","updated_at":"2025-03-17T22:46:43.000000Z"}]},{"id":3133701,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","dot_number":"473726","report_state":"PA","report_number":"H114314314","insp_date":"2023-05-23 00:00:00","insp_start_time":"0931","insp_end_time":"1003","registration_date":"2023-06-01 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"I81 S MM 63.8","county_code_state":"PA","county_code":"041","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"B&F CERAMICS DESIGN SHOWROOM","shipping_paper_number":"C1010589","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117500","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2351350","transaction_code":"C","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4823961,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","insp_violation_id":"253244298","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:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3922"},{"id":4823962,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","insp_violation_id":"253244299","seq_no":"2","part_no":"395","part_no_section":"22(g)","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:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39522G"},{"id":4823963,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","insp_violation_id":"253244300","seq_no":"3","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39522H4"}],"inspection_per_units":[{"id":5040387,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","insp_unit_id":"195286027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"331751","insp_unit_license":"2768415","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"4V4NC9EHXKN214021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5040388,"change_date":"2023-06-02 21:42:00","inspection_id":"78721374","insp_unit_id":"195286028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"NOTL","insp_unit_company":"441663","insp_unit_license":"852385TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2486N7743001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":3012557,"change_date":"2023-05-10 21:42:00","inspection_id":"78584751","dot_number":"473726","report_state":"NC","report_number":"0006533386","insp_date":"2023-05-10 00:00:00","insp_start_time":"0650","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":"LUMBER","location_desc":"LUMBERTON WEIGH STATION, I-95,","county_code_state":"NC","county_code":"155","insp_level_id":"2","service_center":"SH","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-05-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"121300","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":"2067418","transaction_code":"A","transaction_date":"2023-05-10 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2023-05-10 21:42:00","snet_input_date":"2023-05-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2023-05-10 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:38.000000Z","updated_at":"2025-03-17T19:22:38.000000Z","inspection_violations":[{"id":4627113,"change_date":"2023-05-10 21:42:00","inspection_id":"78584751","insp_violation_id":"252746536","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194856296","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"3939A"},{"id":4627114,"change_date":"2023-05-10 21:42:00","inspection_id":"78584751","insp_violation_id":"252746537","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194856296","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:34.000000Z","updated_at":"2025-03-17T21:28:34.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":4846789,"change_date":"2023-05-10 21:42:00","inspection_id":"78584751","insp_unit_id":"194856296","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"367897","insp_unit_license":"3186558","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJHHDV1LLME4657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"},{"id":4846790,"change_date":"2023-05-10 21:42:00","inspection_id":"78584751","insp_unit_id":"194856297","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"7032PE","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1GR1A9625PB450181","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"}]},{"id":2477888,"change_date":"2023-03-03 21:40:00","inspection_id":"77977699","dot_number":"473726","report_state":"GA","report_number":"1377001599","insp_date":"2023-02-28 00:00:00","insp_start_time":"1251","insp_end_time":"1312","registration_date":"2023-03-02 00:00:00","region":"ET","ci_status_code":"C","location":"HCC","location_desc":"HIGH CRASH CORRIDOR","county_code_state":"GA","county_code":"051","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"40002604","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1956855","transaction_code":"C","transaction_date":"2023-02-28 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2023-03-01 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"2GAS001","mcmis_add_date":"2023-03-01 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:12:11.000000Z","updated_at":"2025-03-17T19:12:11.000000Z","inspection_violations":[{"id":3814147,"change_date":"2023-03-03 21:40:00","inspection_id":"77977699","insp_violation_id":"251458761","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:55.000000Z","updated_at":"2025-03-17T21:24:55.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":3986979,"change_date":"2023-03-03 21:40:00","inspection_id":"77977699","insp_unit_id":"193688533","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"441662","insp_unit_license":"3200279","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR0NSNP6467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:34.000000Z","updated_at":"2025-03-17T22:34:34.000000Z"},{"id":3986980,"change_date":"2023-03-03 21:40:00","inspection_id":"77977699","insp_unit_id":"193688534","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"377786","insp_unit_license":"852336TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2483M7352001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:34.000000Z","updated_at":"2025-03-17T22:34:34.000000Z"}]},{"id":2224932,"change_date":"2023-01-25 21:42:00","inspection_id":"77689476","dot_number":"473726","report_state":"TN","report_number":"TNTB005567","insp_date":"2023-01-24 00:00:00","insp_start_time":"1225","insp_end_time":"1256","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 5 I-81 GREENE SCALES","county_code_state":"TN","county_code":"059","insp_level_id":"2","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-01-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1625326","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":null,"census_search_date":"2023-01-25 21:42:00","snet_input_date":"2023-01-25 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-01-25 21:42:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:43.000000Z","updated_at":"2025-03-17T19:07:43.000000Z","inspection_violations":[{"id":3435990,"change_date":"2023-01-25 21:42:00","inspection_id":"77689476","insp_violation_id":"250769863","seq_no":"1","part_no":"390","part_no_section":"21T(e)","insp_viol_unit":"1","insp_unit_id":"193057825","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:14.000000Z","updated_at":"2025-03-17T21:23:14.000000Z","normalized_code":"39021TE"},{"id":3435991,"change_date":"2023-01-25 21:42:00","inspection_id":"77689476","insp_violation_id":"250769864","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"193057826","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:14.000000Z","updated_at":"2025-03-17T21:23:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3580807,"change_date":"2023-01-25 21:42:00","inspection_id":"77689476","insp_unit_id":"193057825","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"316198","insp_unit_license":"2602809","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJHHDR1JSJR1297","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"},{"id":3580808,"change_date":"2023-01-25 21:42:00","inspection_id":"77689476","insp_unit_id":"193057826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"377786","insp_unit_license":"852336TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2483M7352001","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:41.000000Z","updated_at":"2025-03-17T22:31:41.000000Z"}]},{"id":1705991,"change_date":"2022-11-09 21:40:00","inspection_id":"77095366","dot_number":"473726","report_state":"NC","report_number":"0006473342","insp_date":"2022-11-09 00:00:00","insp_start_time":"1051","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":"40 W","location_desc":"40 W","county_code_state":"NC","county_code":"067","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"B&F CERAMICS","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"2006888","transaction_code":"A","transaction_date":"2022-11-09 00:00:00","upload_date":"2022-11-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2022-11-09 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-11-09 21:40:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:11.000000Z","updated_at":"2025-03-17T18:58:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2744296,"change_date":"2022-11-09 21:40:00","inspection_id":"77095366","insp_unit_id":"191879468","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"202639","insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:46.000000Z","updated_at":"2025-03-17T22:25:46.000000Z"},{"id":2744297,"change_date":"2022-11-09 21:40:00","inspection_id":"77095366","insp_unit_id":"191879469","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"202640","insp_unit_license":"696723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248X47147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:46.000000Z","updated_at":"2025-03-17T22:25:46.000000Z"}]},{"id":1111267,"change_date":"2022-08-23 21:41:00","inspection_id":"76407451","dot_number":"473726","report_state":"NC","report_number":"0006449984","insp_date":"2022-08-22 00:00:00","insp_start_time":"1405","insp_end_time":"1420","registration_date":null,"region":"ET","ci_status_code":"C","location":"I26 WE","location_desc":"I26 WEST NEAR 63MM","county_code_state":"NC","county_code":"149","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1983703","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2022-08-23 21:41:00","snet_input_date":"2022-08-23 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:15.000000Z","updated_at":"2025-03-17T18:47:15.000000Z","inspection_violations":[{"id":1751495,"change_date":"2022-08-23 21:41:00","inspection_id":"76407451","insp_violation_id":"247921471","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:15:09.000000Z","updated_at":"2025-03-17T21:15:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1786940,"change_date":"2022-08-23 21:41:00","inspection_id":"76407451","insp_unit_id":"190485549","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"2941478","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDRXJSKA3898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"},{"id":1786941,"change_date":"2022-08-23 21:41:00","inspection_id":"76407451","insp_unit_id":"190485550","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":null,"insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS2484K7493401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:17.000000Z","updated_at":"2025-03-17T22:19:17.000000Z"}]},{"id":727909,"change_date":"2022-06-30 21:41:00","inspection_id":"75959435","dot_number":"473726","report_state":"NC","report_number":"0006433109","insp_date":"2022-06-30 00:00:00","insp_start_time":"1220","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"HILLSB","location_desc":"HILLSBOROUGH WEIGH STATION I-4","county_code_state":"NC","county_code":"135","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"B AND F CERAMICS DESIGN S","shipping_paper_number":"A1005147","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-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118220","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":"1966437","transaction_code":"A","transaction_date":"2022-06-30 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2022-06-30 21:41:00","snet_input_date":"2022-06-30 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-06-30 21:41:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:31.000000Z","updated_at":"2025-03-17T18:40:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1169950,"change_date":"2022-06-30 21:41:00","inspection_id":"75959435","insp_unit_id":"189546346","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"202639","insp_unit_license":"3298661","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FUJGLDR2HLJF2418","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:22.000000Z","updated_at":"2025-03-17T22:15:22.000000Z"},{"id":1169951,"change_date":"2022-06-30 21:41:00","inspection_id":"75959435","insp_unit_id":"189546347","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":"202640","insp_unit_license":"696723TL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":"1UYVS248X47147801","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:22.000000Z","updated_at":"2025-03-17T22:15:22.000000Z"}]},{"id":308661,"change_date":"2022-05-04 21:41:00","inspection_id":"75461463","dot_number":"473726","report_state":"NC","report_number":"0006415240","insp_date":"2022-05-03 00:00:00","insp_start_time":"0820","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":"I-40","location_desc":"I-40","county_code_state":"NC","county_code":"001","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"123000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1949017","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00473726","upload_search_indicator":"M","census_search_date":"2022-05-03 21:39:00","snet_input_date":"2022-05-03 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-05-03 21:39:00","insp_carrier_name":"B&F CERAMICS DESIGN SHOWROOM INC","insp_carrier_street":"2005 INTERNATIONAL PARKWAY","insp_carrier_city":"FREDERICKSBURG","insp_carrier_state":"VA","insp_carrier_zip_code":"22406-1211","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:56.000000Z","updated_at":"2025-03-17T18:32:56.000000Z","inspection_violations":[{"id":479741,"change_date":"2022-05-04 21:41:00","inspection_id":"75461463","insp_violation_id":"245567656","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"3294947","created_at":"2025-03-17T21:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"39111B4"},{"id":479742,"change_date":"2022-05-04 21:41:00","inspection_id":"75461463","insp_violation_id":"245567657","seq_no":"2","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:09:16.000000Z","updated_at":"2025-03-17T21:09:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":499301,"change_date":"2022-05-04 21:41:00","inspection_id":"75461463","insp_unit_id":"188499187","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"202484","insp_unit_license":"2628619","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3AKJGLDRXJSKA3898","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"},{"id":499302,"change_date":"2022-05-04 21:41:00","inspection_id":"75461463","insp_unit_id":"188499188","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UTIL","insp_unit_company":null,"insp_unit_license":"696754IL","insp_unit_license_state":"VA","insp_unit_vehicle_id_number":null,"insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:15.000000Z","updated_at":"2025-03-17T22:11:15.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/473726\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/473726\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/473726\/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\/473726\/inspections","per_page":100,"prev_page_url":null,"to":40,"total":40}