{"current_page":1,"data":[{"id":12094924,"change_date":"2026-06-04 21:45:00","inspection_id":"88039038","dot_number":"438238","report_state":"DC","report_number":"2597001830","insp_date":"2026-06-03 00:00:00","insp_start_time":"0847","insp_end_time":"0905","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WASHINGTON DC","county_code_state":"DC","county_code":null,"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-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3464974","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:48.000000Z","updated_at":"2026-06-11T09:35:47.000000Z","inspection_violations":[{"id":21048825,"change_date":"2026-06-04 21:45:00","inspection_id":"88039038","insp_violation_id":"274689494","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-07T10:00:47.000000Z","updated_at":"2026-06-11T09:49:55.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":21016275,"change_date":"2026-06-04 21:45:00","inspection_id":"88039038","insp_unit_id":"213908696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"49504","insp_unit_license":"1DH6259","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDRF3G64HEF32475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:17:53.000000Z","updated_at":"2026-06-11T09:09:13.000000Z"}]},{"id":11816583,"change_date":"2026-05-04 21:38:00","inspection_id":"87750832","dot_number":"438238","report_state":"MD","report_number":"0304C00713","insp_date":"2026-04-29 00:00:00","insp_start_time":"1050","insp_end_time":"1108","registration_date":null,"region":"ED","ci_status_code":"C","location":"013033","location_desc":"COLLEGE PARK MD","county_code_state":"MD","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-04 21:38: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":"3254512","transaction_code":"A","transaction_date":"2026-05-04 00:00:00","upload_date":"2026-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2026-05-04 21:38:00","snet_input_date":"2026-04-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-04 21:38:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:38:57.000000Z","updated_at":"2026-05-14T12:30:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20553034,"change_date":"2026-05-04 21:38:00","inspection_id":"87750832","insp_unit_id":"213361151","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":"578","insp_unit_license":"343ED41","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5KKSAXFM4PPNY3567","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:30.000000Z","updated_at":"2026-05-14T11:48:07.000000Z"}]},{"id":11561300,"change_date":"2026-04-03 21:37:00","inspection_id":"87484633","dot_number":"438238","report_state":"DC","report_number":"3051002003","insp_date":"2026-04-02 00:00:00","insp_start_time":"0422","insp_end_time":"0441","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WASHINGTON DC","county_code_state":"DC","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-03 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3110483","transaction_code":"A","transaction_date":"2026-04-03 00:00:00","upload_date":"2026-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2026-04-03 21:37:00","snet_input_date":"2026-04-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-03 21:37:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-06T09:50:30.000000Z","updated_at":"2026-04-14T09:30:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19813615,"change_date":"2026-04-03 21:37:00","inspection_id":"87484633","insp_unit_id":"212526229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"1DH6259","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDRF3G64HEF32475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:22.000000Z","updated_at":"2026-04-14T09:03:18.000000Z"}]},{"id":11214197,"change_date":"2026-02-24 21:39:00","inspection_id":"87125595","dot_number":"438238","report_state":"DC","report_number":"4988001635","insp_date":"2026-02-24 00:00:00","insp_start_time":"0830","insp_end_time":"0900","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WASHINGTON DC","county_code_state":"DC","county_code":"001","insp_level_id":"1","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-02-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2927380","transaction_code":"A","transaction_date":"2026-02-24 00:00:00","upload_date":"2026-02-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2026-02-24 21:39:00","snet_input_date":"2026-02-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-24 21:39:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-27T10:37:42.000000Z","updated_at":"2026-03-07T10:30:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19150154,"change_date":"2026-02-24 21:39:00","inspection_id":"87125595","insp_unit_id":"211786264","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"530-04","insp_unit_license":"9EW5188","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDFR3GN0NEC57576","insp_unit_decal":"Y","insp_unit_decal_number":"36120093","created_at":"2026-02-27T10:13:17.000000Z","updated_at":"2026-03-07T10:02:55.000000Z"}]},{"id":8434695,"change_date":"2025-04-29 21:47:00","inspection_id":"84461449","dot_number":"438238","report_state":"MD","report_number":"2064C00039","insp_date":"2025-04-22 00:00:00","insp_start_time":"0725","insp_end_time":"0740","registration_date":"2025-04-29 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"ROSEDALE MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"1625548","transaction_code":"C","transaction_date":"2025-04-22 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2025-04-22 21:40:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-22 21:40:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:26:22.000000Z","updated_at":"2025-05-02T13:45:58.000000Z","inspection_violations":[{"id":13409014,"change_date":"2025-04-29 21:47:00","inspection_id":"84461449","insp_violation_id":"265860355","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206517171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-02T10:43:18.000000Z","updated_at":"2025-05-02T10:53:32.000000Z","normalized_code":"3939ALIL"},{"id":13409015,"change_date":"2025-04-29 21:47:00","inspection_id":"84461449","insp_violation_id":"265860356","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"206517171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-02T10:43:18.000000Z","updated_at":"2025-05-02T10:53:32.000000Z","normalized_code":"3939ALSML"},{"id":13409016,"change_date":"2025-04-29 21:47:00","inspection_id":"84461449","insp_violation_id":"265860357","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206517171","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-02T10:43:18.000000Z","updated_at":"2025-05-02T10:53:32.000000Z","normalized_code":"3939ALCL"}],"inspection_per_units":[{"id":13779488,"change_date":"2025-04-29 21:47:00","inspection_id":"84461449","insp_unit_id":"206517171","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"6DD5373","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FD0W5HTXHED88228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T09:58:28.000000Z","updated_at":"2025-05-03T09:49:21.000000Z"}]},{"id":7224991,"change_date":"2024-11-19 21:40:00","inspection_id":"83189256","dot_number":"438238","report_state":"DC","report_number":"3051001476","insp_date":"2024-11-18 00:00:00","insp_start_time":"0942","insp_end_time":"1010","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"WASHINGTON DC","county_code_state":"DC","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"1066658","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2024-11-19 21:40:00","snet_input_date":"2024-11-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-19 21:40:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:48.000000Z","updated_at":"2025-03-17T20:46:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11653936,"change_date":"2024-11-19 21:40:00","inspection_id":"83189256","insp_unit_id":"203943665","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KENWORTH","insp_unit_company":"358","insp_unit_license":"963F75","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1XKDD49X1DJ336323","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:45.000000Z","updated_at":"2025-03-17T23:43:45.000000Z"}]},{"id":4289959,"change_date":"2023-10-26 21:41:00","inspection_id":"80014051","dot_number":"438238","report_state":"MD","report_number":"0278005161","insp_date":"2023-10-25 00:00:00","insp_start_time":"1550","insp_end_time":"1600","registration_date":null,"region":"ET","ci_status_code":"C","location":"050","location_desc":"MONTGOMERY COUNTY","county_code_state":"MD","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2672191","transaction_code":"A","transaction_date":"2023-10-25 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-25 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:52.000000Z","updated_at":"2025-03-17T19:47:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6899375,"change_date":"2023-10-26 21:41:00","inspection_id":"80014051","insp_unit_id":"197757175","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"5DP8534","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDRF3G62KEC13180","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:50.000000Z","updated_at":"2025-03-17T22:57:50.000000Z"}]},{"id":4223407,"change_date":"2023-10-24 21:39:00","inspection_id":"79940317","dot_number":"438238","report_state":"MD","report_number":"2310004817","insp_date":"2023-10-18 00:00:00","insp_start_time":"0647","insp_end_time":"0704","registration_date":"2023-10-24 00:00:00","region":"ET","ci_status_code":"C","location":"051","location_desc":"PRINCE GEORGES COUNTY","county_code_state":"MD","county_code":"033","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2670094","transaction_code":"C","transaction_date":"2023-10-18 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2023-10-18 21:40:00","snet_input_date":"2023-10-18 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-10-18 21:40:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:35.000000Z","updated_at":"2025-03-17T19:46:35.000000Z","inspection_violations":[{"id":6539074,"change_date":"2023-10-24 21:39:00","inspection_id":"79940317","insp_violation_id":"256004512","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39141A1"},{"id":6539075,"change_date":"2023-10-24 21:39:00","inspection_id":"79940317","insp_violation_id":"256004513","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197711952","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6792052,"change_date":"2023-10-24 21:39:00","inspection_id":"79940317","insp_unit_id":"197711952","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"495","insp_unit_license":"1DH6259","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDRF3G64HEF32475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:56.000000Z","updated_at":"2025-03-17T22:56:56.000000Z"}]},{"id":3895538,"change_date":"2023-09-05 21:40:00","inspection_id":"79576636","dot_number":"438238","report_state":"MD","report_number":"2043005451","insp_date":"2023-09-04 00:00:00","insp_start_time":"0725","insp_end_time":"0741","registration_date":null,"region":"ET","ci_status_code":"C","location":"036","location_desc":"ANNE ARUNDEL COUNTY","county_code_state":"MD","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2658657","transaction_code":"A","transaction_date":"2023-09-04 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2023-09-05 21:40:00","snet_input_date":"2023-09-04 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-09-05 21:40:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:39:45.000000Z","updated_at":"2025-03-17T19:39:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6263200,"change_date":"2023-09-05 21:40:00","inspection_id":"79576636","insp_unit_id":"196881009","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"507","insp_unit_license":"457E36","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FVHC5DE46HW16554","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:37.000000Z","updated_at":"2025-03-17T22:52:37.000000Z"}]},{"id":3637808,"change_date":"2023-08-01 21:41:00","inspection_id":"79288660","dot_number":"438238","report_state":"DC","report_number":"2995000630","insp_date":"2023-08-01 00:00:00","insp_start_time":"1011","insp_end_time":"1043","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WASHINGTONDC","county_code_state":"DC","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2023-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"36478","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2023-08-01 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:37.000000Z","updated_at":"2025-03-17T19:34:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5849145,"change_date":"2023-08-01 21:41:00","inspection_id":"79288660","insp_unit_id":"196290959","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WESTERN ST","insp_unit_company":null,"insp_unit_license":"431E93","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5KKSAXFMXMPML8805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:10.000000Z","updated_at":"2025-03-17T22:49:10.000000Z"}]},{"id":3280426,"change_date":"2023-12-07 21:40:00","inspection_id":"78887076","dot_number":"438238","report_state":"MD","report_number":"2310004746","insp_date":"2023-06-14 00:00:00","insp_start_time":"0746","insp_end_time":"0800","registration_date":"2023-12-07 00:00:00","region":"ET","ci_status_code":"C","location":"051","location_desc":"PRINCE GEORGES COUNTY","county_code_state":"MD","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56650","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":"2640429","transaction_code":"C","transaction_date":"2023-06-14 00:00:00","upload_date":"2023-12-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2023-06-14 21:41:00","snet_input_date":"2023-06-14 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-06-14 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:06.000000Z","updated_at":"2025-03-17T19:28:06.000000Z","inspection_violations":[{"id":5059314,"change_date":"2023-12-07 21:40:00","inspection_id":"78887076","insp_violation_id":"256760841","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198389722","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:30:30.000000Z","updated_at":"2025-03-17T21:30:30.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5274532,"change_date":"2023-12-07 21:40:00","inspection_id":"78887076","insp_unit_id":"198389721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"4FH6469","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDNF6DC2MDF08265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"},{"id":5274533,"change_date":"2023-12-07 21:40:00","inspection_id":"78887076","insp_unit_id":"198389722","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"037285X","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5JPBU3123DP032331","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:34.000000Z","updated_at":"2025-03-17T22:44:34.000000Z"}]},{"id":1992084,"change_date":"2022-12-21 21:39:00","inspection_id":"77423040","dot_number":"438238","report_state":"MD","report_number":"0103003398","insp_date":"2022-12-21 00:00:00","insp_start_time":"1022","insp_end_time":"1041","registration_date":null,"region":"ET","ci_status_code":"C","location":"047","location_desc":"HARFORD COUNTY","county_code_state":"MD","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"2597917","transaction_code":"A","transaction_date":"2022-12-21 00:00:00","upload_date":"2022-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-12-21 21:39:00","snet_input_date":"2022-12-21 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:20.000000Z","updated_at":"2025-03-17T19:03:20.000000Z","inspection_violations":[{"id":3092691,"change_date":"2022-12-21 21:39:00","inspection_id":"77423040","insp_violation_id":"250210634","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192528814","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39395A"},{"id":3092692,"change_date":"2022-12-21 21:39:00","inspection_id":"77423040","insp_violation_id":"250210635","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192528814","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:40.000000Z","updated_at":"2025-03-17T21:21:40.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3204950,"change_date":"2022-12-21 21:39:00","inspection_id":"77423040","insp_unit_id":"192528814","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"KENW","insp_unit_company":"290","insp_unit_license":"423E51","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1NKDXUEX27J199467","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:56.000000Z","updated_at":"2025-03-17T22:28:56.000000Z"}]},{"id":1921391,"change_date":"2022-12-12 21:43:00","inspection_id":"77342212","dot_number":"438238","report_state":"MD","report_number":"5549000216","insp_date":"2022-12-12 00:00:00","insp_start_time":"1036","insp_end_time":"1048","registration_date":null,"region":"ET","ci_status_code":"C","location":"034","location_desc":"PRINCE GEORGES COUNTY P.D.","county_code_state":"MD","county_code":"033","insp_level_id":"1","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":"N","pen_cen_match":null,"final_status_date":"2022-12-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2595408","transaction_code":"A","transaction_date":"2022-12-12 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-12-12 21:43:00","snet_input_date":"2022-12-12 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-12-12 21:43:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:10.000000Z","updated_at":"2025-03-17T19:02:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3091522,"change_date":"2022-12-12 21:43:00","inspection_id":"77342212","insp_unit_id":"192369261","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3EM5109","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDNF6DC2MDF08265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:11.000000Z","updated_at":"2025-03-17T22:28:11.000000Z"}]},{"id":1492600,"change_date":"2022-10-12 21:41:00","inspection_id":"76850184","dot_number":"438238","report_state":"DC","report_number":"2995230006","insp_date":"2022-10-11 00:00:00","insp_start_time":"0803","insp_end_time":"0831","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"1000 RHODE ISLAND AVE NE","county_code_state":"DC","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"100868","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-10-12 21:41:00","snet_input_date":"2022-10-12 00:00:00","source_office":"1DCS001","mcmis_add_date":"2022-10-12 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:09.000000Z","updated_at":"2025-03-17T18:54:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2402213,"change_date":"2022-10-12 21:41:00","inspection_id":"76850184","insp_unit_id":"191388425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"489","insp_unit_license":"6DD5373","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FD0W5HTXHED88228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:27.000000Z","updated_at":"2025-03-17T22:23:27.000000Z"}]},{"id":1210850,"change_date":"2022-09-06 21:41:00","inspection_id":"76523178","dot_number":"438238","report_state":"DC","report_number":"4412220936","insp_date":"2022-09-03 00:00:00","insp_start_time":"0715","insp_end_time":"0735","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"2800 BLADENSBURG RD. NE","county_code_state":"DC","county_code":"001","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-09-06 21:41: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":"100516","transaction_code":"A","transaction_date":"2022-09-03 00:00:00","upload_date":"2022-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-09-06 21:41:00","snet_input_date":"2022-09-06 00:00:00","source_office":"1DCS001","mcmis_add_date":"2022-09-06 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:59.000000Z","updated_at":"2025-03-17T18:48:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1947571,"change_date":"2022-09-06 21:41:00","inspection_id":"76523178","insp_unit_id":"190720668","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"530","insp_unit_license":"431E93","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5KKSAXFMXMPML8805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:23.000000Z","updated_at":"2025-03-17T22:20:23.000000Z"}]},{"id":1107524,"change_date":"2022-08-23 21:41:00","inspection_id":"76403013","dot_number":"438238","report_state":"DC","report_number":"2995220665","insp_date":"2022-08-20 00:00:00","insp_start_time":"0640","insp_end_time":"0709","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"600 NEW YORK AVE  NW","county_code_state":"DC","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-08-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"100232","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-08-23 21:41:00","snet_input_date":"2022-08-23 00:00:00","source_office":"1DCS001","mcmis_add_date":"2022-08-23 21:41:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:14.000000Z","updated_at":"2025-03-17T18:47:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1781613,"change_date":"2022-08-23 21:41:00","inspection_id":"76403013","insp_unit_id":"190476510","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"495-04","insp_unit_license":"1DH6259","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDRF3G64HEF32475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:15.000000Z","updated_at":"2025-03-17T22:19:15.000000Z"}]},{"id":546795,"change_date":"2022-06-06 21:40:00","inspection_id":"75744736","dot_number":"438238","report_state":"DC","report_number":"3051220377","insp_date":"2022-06-02 00:00:00","insp_start_time":"0801","insp_end_time":"0823","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"295 OVERLOOK SW","county_code_state":"DC","county_code":"001","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"99104","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-06-06 21:40:00","snet_input_date":"2022-06-06 00:00:00","source_office":"1DCS001","mcmis_add_date":"2022-06-06 21:40:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017-2359","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:25.000000Z","updated_at":"2025-03-17T18:37:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":879668,"change_date":"2022-06-06 21:40:00","inspection_id":"75744736","insp_unit_id":"189072387","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"530","insp_unit_license":"431E93","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5KKSAXFMXMPML8805","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:36.000000Z","updated_at":"2025-03-17T22:13:36.000000Z"}]},{"id":365080,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","dot_number":"438238","report_state":"MD","report_number":"2355002059","insp_date":"2022-05-11 00:00:00","insp_start_time":"1511","insp_end_time":"1528","registration_date":null,"region":"ET","ci_status_code":"C","location":"051","location_desc":"PRINCE GEORGES COUNTY","county_code_state":"MD","county_code":"033","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"17000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2541078","transaction_code":"A","transaction_date":"2022-05-11 00:00:00","upload_date":"2022-05-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00438238","upload_search_indicator":null,"census_search_date":"2022-05-11 21:39:00","snet_input_date":"2022-05-11 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-05-11 21:39:00","insp_carrier_name":"MAGNOLIA PLUMBING INC","insp_carrier_street":"600 GALLATIN ST NE","insp_carrier_city":"WASHINGTON","insp_carrier_state":"DC","insp_carrier_zip_code":"20017","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:58.000000Z","updated_at":"2025-03-17T18:33:58.000000Z","inspection_violations":[{"id":572699,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","insp_violation_id":"245718090","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:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"3922"},{"id":572700,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","insp_violation_id":"245718091","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"39141A"},{"id":572701,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","insp_violation_id":"245718092","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"188621366","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:43.000000Z","updated_at":"2025-03-17T21:09:43.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":590330,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","insp_unit_id":"188621366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"9BZ5462","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FDBF2A69FED73177","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:49.000000Z","updated_at":"2025-03-17T22:11:49.000000Z"},{"id":590331,"change_date":"2022-05-11 21:39:00","inspection_id":"75528133","insp_unit_id":"188621367","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"USJE","insp_unit_company":null,"insp_unit_license":"200664X","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1U9FS1318CA044869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:49.000000Z","updated_at":"2025-03-17T22:11:49.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/438238\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/438238\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/438238\/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\/438238\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}