{"current_page":1,"data":[{"id":11969663,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","dot_number":"1814523","report_state":"MD","report_number":"0226C00836","insp_date":"2026-05-18 00:00:00","insp_start_time":"1154","insp_end_time":"1217","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"PARKTON MD","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"GUERRA","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-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3366088","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-05-20 21:40:00","snet_input_date":"2026-05-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-20 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-23T09:42:49.000000Z","updated_at":"2026-06-01T09:30:23.000000Z","inspection_violations":[{"id":20822693,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","insp_violation_id":"274386150","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213658479","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-23T10:05:46.000000Z","updated_at":"2026-06-01T09:40:37.000000Z","normalized_code":"39378AWS"},{"id":20822694,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","insp_violation_id":"274386151","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"213658479","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-23T10:05:46.000000Z","updated_at":"2026-06-01T09:40:37.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":20822695,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","insp_violation_id":"274386152","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213658479","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-23T10:05:46.000000Z","updated_at":"2026-06-01T09:40:37.000000Z","normalized_code":"39395A1"},{"id":20822696,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","insp_violation_id":"274386153","seq_no":"4","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"213658479","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2026-05-23T10:05:46.000000Z","updated_at":"2026-06-01T09:40:37.000000Z","normalized_code":"3939AHLLH"}],"inspection_per_units":[{"id":20811194,"change_date":"2026-05-20 21:40:00","inspection_id":"87906338","insp_unit_id":"213658479","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"UD","insp_unit_company":"006","insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-23T09:20:12.000000Z","updated_at":"2026-06-01T09:02:09.000000Z"}]},{"id":11462923,"change_date":"2026-03-24 21:40:00","inspection_id":"87381032","dot_number":"1814523","report_state":"MD","report_number":"0327C00841","insp_date":"2026-03-18 00:00:00","insp_start_time":"1730","insp_end_time":"1804","registration_date":null,"region":"ED","ci_status_code":"C","location":"002021","location_desc":"FREDERICK MD","county_code_state":"MD","county_code":"021","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3060353","transaction_code":"A","transaction_date":"2026-03-24 00:00:00","upload_date":"2026-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-03-24 21:40:00","snet_input_date":"2026-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-24 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-27T09:45:22.000000Z","updated_at":"2026-04-04T09:30:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19634117,"change_date":"2026-03-24 21:40:00","inspection_id":"87381032","insp_unit_id":"212304883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NISSAN DIE","insp_unit_company":"006","insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"Y","insp_unit_decal_number":"36007681","created_at":"2026-03-27T09:22:58.000000Z","updated_at":"2026-04-04T09:04:18.000000Z"}]},{"id":11415721,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","dot_number":"1814523","report_state":"PA","report_number":"H304607737","insp_date":"2026-03-18 00:00:00","insp_start_time":"1307","insp_end_time":"1330","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SHIPPENSBURG TOWNSHIP PA","county_code_state":"PA","county_code":"041","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3026022","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-03-19 21:38:00","snet_input_date":"2026-03-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-19 21:38:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"MD","created_at":"2026-03-22T09:50:44.000000Z","updated_at":"2026-03-30T09:31:40.000000Z","inspection_violations":[{"id":19253851,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497156","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1656479-6","created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"3922SLLIRP"},{"id":19253852,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497157","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1656480-0","created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"39617CPI"},{"id":19253853,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497158","seq_no":"3","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"3922SLLUCR"},{"id":19253854,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497159","seq_no":"4","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"3939ALFTSI"},{"id":19253855,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497160","seq_no":"5","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"39395A4EEUS"},{"id":19253856,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_violation_id":"272497161","seq_no":"6","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"212217154","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"TA1656481-1","created_at":"2026-03-22T10:16:49.000000Z","updated_at":"2026-03-30T09:53:30.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":19554154,"change_date":"2026-03-19 21:38:00","inspection_id":"87331347","insp_unit_id":"212217154","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NISSAN DIE","insp_unit_company":"5","insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:27.000000Z","updated_at":"2026-03-30T09:05:55.000000Z"}]},{"id":11119547,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","dot_number":"1814523","report_state":"PA","report_number":"XL00095943","insp_date":"2026-02-11 00:00:00","insp_start_time":"0808","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"STRASBURG PK AT HERITAGE RD","county_code_state":"PA","county_code":"071","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":"2026-02-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2573825","transaction_code":"A","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-02-12 21:41:00","snet_input_date":"2026-02-11 00:00:00","source_office":"1PAS001","mcmis_add_date":"2026-02-12 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-02-15T10:38:48.000000Z","updated_at":"2026-02-23T10:31:01.000000Z","inspection_violations":[{"id":18622366,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_violation_id":"271765566","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"211595695","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0032079-5","created_at":"2026-02-15T10:55:22.000000Z","updated_at":"2026-02-23T10:39:46.000000Z","normalized_code":"3922SLLSR"},{"id":18622367,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_violation_id":"271765567","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"211595695","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0032080-6","created_at":"2026-02-15T10:55:22.000000Z","updated_at":"2026-02-23T10:39:46.000000Z","normalized_code":"39617CPI"},{"id":18622368,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_violation_id":"271765568","seq_no":"3","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"1","insp_unit_id":"211595695","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:22.000000Z","updated_at":"2026-02-23T10:39:46.000000Z","normalized_code":"3922SLLSIV"},{"id":18622369,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_violation_id":"271765569","seq_no":"4","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"211595695","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:22.000000Z","updated_at":"2026-02-23T10:39:46.000000Z","normalized_code":"3969D2FTF"},{"id":18622370,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_violation_id":"271765570","seq_no":"5","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211595695","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:22.000000Z","updated_at":"2026-02-23T10:39:46.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":18965168,"change_date":"2026-02-12 21:41:00","inspection_id":"87032538","insp_unit_id":"211595695","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":"5","insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:10.000000Z","updated_at":"2026-02-23T10:03:29.000000Z"}]},{"id":10831753,"change_date":"2026-01-22 21:38:00","inspection_id":"86859860","dot_number":"1814523","report_state":"MD","report_number":"2408C00336","insp_date":"2026-01-21 00:00:00","insp_start_time":"0805","insp_end_time":"0835","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"BALTIMORE 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":"2026-01-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2799805","transaction_code":"A","transaction_date":"2026-01-22 00:00:00","upload_date":"2026-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-01-22 21:38:00","snet_input_date":"2026-01-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-22 21:38:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-25T10:36:44.000000Z","updated_at":"2026-02-02T10:30:16.000000Z","inspection_violations":[{"id":18109008,"change_date":"2026-01-22 21:38:00","inspection_id":"86859860","insp_violation_id":"271352151","seq_no":"1","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"211224930","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"SERO S0QY90B7","created_at":"2026-01-25T10:42:22.000000Z","updated_at":"2026-02-02T10:36:13.000000Z","normalized_code":"3939ALHWS"},{"id":18109009,"change_date":"2026-01-22 21:38:00","inspection_id":"86859860","insp_violation_id":"271352152","seq_no":"2","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"211224930","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"SERO S0QY90B7","created_at":"2026-01-25T10:42:22.000000Z","updated_at":"2026-02-02T10:36:13.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":18193358,"change_date":"2026-01-22 21:38:00","inspection_id":"86859860","insp_unit_id":"211224930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"UD","insp_unit_company":null,"insp_unit_license":"4ET8079","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H36AN55773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-25T10:09:10.000000Z","updated_at":"2026-02-02T10:02:28.000000Z"}]},{"id":10787586,"change_date":"2026-01-16 21:39:00","inspection_id":"86813552","dot_number":"1814523","report_state":"MD","report_number":"0290C00579","insp_date":"2026-01-15 00:00:00","insp_start_time":"0751","insp_end_time":"0806","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MANCHESTER MD","county_code_state":"MD","county_code":"013","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":"2026-01-16 21:39: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":"2776565","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:53.000000Z","updated_at":"2026-01-27T10:30:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18111605,"change_date":"2026-01-16 21:39:00","inspection_id":"86813552","insp_unit_id":"211128013","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NISSAN DIE","insp_unit_company":"006","insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:23.000000Z","updated_at":"2026-01-27T10:00:28.000000Z"}]},{"id":10360491,"change_date":"2025-12-05 21:42:00","inspection_id":"86488859","dot_number":"1814523","report_state":"PA","report_number":"C140000285","insp_date":"2025-12-04 00:00:00","insp_start_time":"0835","insp_end_time":"0920","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MOUNT HOLLY SPRINGS PA","county_code_state":"PA","county_code":"041","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":"2025-12-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2621795","transaction_code":"A","transaction_date":"2025-12-05 00:00:00","upload_date":"2025-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-12-05 21:42:00","snet_input_date":"2025-12-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-05 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-08T10:31:56.000000Z","updated_at":"2025-12-09T10:30:52.000000Z","inspection_violations":[{"id":17347942,"change_date":"2025-12-05 21:42:00","inspection_id":"86488859","insp_violation_id":"270489590","seq_no":"1","part_no":"391","part_no_section":"41A-MCPC","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-12-08T10:32:48.000000Z","updated_at":"2025-12-09T10:31:35.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":17316493,"change_date":"2025-12-05 21:42:00","inspection_id":"86488859","insp_unit_id":"210438512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"UD","insp_unit_company":"5","insp_unit_license":"PFC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-08T10:02:03.000000Z","updated_at":"2025-12-09T10:01:01.000000Z"}]},{"id":9896290,"change_date":"2025-10-09 21:40:00","inspection_id":"86000486","dot_number":"1814523","report_state":"DC","report_number":"3995003682","insp_date":"2025-10-08 00:00:00","insp_start_time":"2141","insp_end_time":"2202","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":"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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2386569","transaction_code":"A","transaction_date":"2025-10-09 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:52.000000Z","updated_at":"2025-10-13T10:00:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16421296,"change_date":"2025-10-09 21:40:00","inspection_id":"86000486","insp_unit_id":"209379885","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"UD","insp_unit_company":"6","insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:16.000000Z","updated_at":"2025-10-13T09:45:47.000000Z"}]},{"id":9762356,"change_date":"2025-09-24 21:41:00","inspection_id":"85859816","dot_number":"1814523","report_state":"MD","report_number":"3203C00405","insp_date":"2025-09-16 00:00:00","insp_start_time":"1500","insp_end_time":"1523","registration_date":null,"region":"ED","ci_status_code":"C","location":"073510","location_desc":"BALTIMORE MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2316249","transaction_code":"A","transaction_date":"2025-09-23 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-09-24 21:41:00","snet_input_date":"2025-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-24 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:06.000000Z","updated_at":"2025-09-28T10:00:09.000000Z","inspection_violations":[{"id":16044768,"change_date":"2025-09-24 21:41:00","inspection_id":"85859816","insp_violation_id":"268883734","seq_no":"1","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"209111635","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:15.000000Z","normalized_code":"3939ALTSI"},{"id":16044769,"change_date":"2025-09-24 21:41:00","inspection_id":"85859816","insp_violation_id":"268883735","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"209111635","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:15.000000Z","normalized_code":"39378AWS"},{"id":16044770,"change_date":"2025-09-24 21:41:00","inspection_id":"85859816","insp_violation_id":"268883736","seq_no":"3","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"209111635","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-27T10:16:50.000000Z","updated_at":"2025-09-28T10:15:15.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":16172449,"change_date":"2025-09-24 21:41:00","inspection_id":"85859816","insp_unit_id":"209111635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"1GJ5081","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1FVACWDT3GHHU0633","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:17.000000Z","updated_at":"2025-09-29T09:45:08.000000Z"}]},{"id":9071484,"change_date":"2025-07-07 21:39:00","inspection_id":"85133978","dot_number":"1814523","report_state":"MD","report_number":"0278C00118","insp_date":"2025-06-28 00:00:00","insp_start_time":"1433","insp_end_time":"1457","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"SILVER SPRING MD","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1958533","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-07-07 21:39:00","snet_input_date":"2025-06-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-07 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:28.000000Z","updated_at":"2025-07-11T10:44:28.000000Z","inspection_violations":[{"id":14604527,"change_date":"2025-07-07 21:39:00","inspection_id":"85133978","insp_violation_id":"267224048","seq_no":"1","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"207717917","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-07-10T10:42:25.000000Z","updated_at":"2025-07-11T10:45:14.000000Z","normalized_code":"3939ALSLI"},{"id":14604528,"change_date":"2025-07-07 21:39:00","inspection_id":"85133978","insp_violation_id":"267224049","seq_no":"2","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":"WARNING","created_at":"2025-07-10T10:42:25.000000Z","updated_at":"2025-07-11T10:45:14.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14886123,"change_date":"2025-07-07 21:39:00","inspection_id":"85133978","insp_unit_id":"207717917","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"1GN8246","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H97AR60876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:18.000000Z","updated_at":"2025-07-11T09:45:18.000000Z"}]},{"id":8565153,"change_date":"2025-05-07 21:43:00","inspection_id":"84598940","dot_number":"1814523","report_state":"MD","report_number":"0246C00130","insp_date":"2025-05-07 00:00:00","insp_start_time":"0829","insp_end_time":"0846","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WHITE MARSH MD","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST BUY","shipping_paper_number":"106616705","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-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"1694560","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:18.000000Z","updated_at":"2025-05-11T10:11:24.000000Z","inspection_violations":[{"id":13582652,"change_date":"2025-05-07 21:43:00","inspection_id":"84598940","insp_violation_id":"266048834","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206677373","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-05-09T11:09:35.000000Z","updated_at":"2025-05-10T11:21:05.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":13936417,"change_date":"2025-05-07 21:43:00","inspection_id":"84598940","insp_unit_id":"206677373","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"5GJ9264","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBND8JT151S10200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:13:49.000000Z","updated_at":"2025-05-11T02:50:07.000000Z"}]},{"id":8402776,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","dot_number":"1814523","report_state":"MD","report_number":"9513000589","insp_date":"2025-04-16 00:00:00","insp_start_time":"1600","insp_end_time":"1634","registration_date":null,"region":"ET","ci_status_code":"C","location":"043","location_desc":"CHARLES COUNTY","county_code_state":"MD","county_code":"017","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":"2025-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2791241","transaction_code":"A","transaction_date":"2025-04-16 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-16 00:00:00","source_office":"1MDS001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:59.000000Z","updated_at":"2025-04-21T10:22:40.000000Z","inspection_violations":[{"id":13255059,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","insp_violation_id":"265681547","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"206363402","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-20T10:56:36.000000Z","updated_at":"2025-04-20T11:03:37.000000Z","normalized_code":"39341BNPB"},{"id":13255060,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","insp_violation_id":"265681548","seq_no":"2","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"206363402","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:56:36.000000Z","updated_at":"2025-04-20T11:03:37.000000Z","normalized_code":"3939ALCL"},{"id":13255061,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","insp_violation_id":"265681549","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"206363402","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:56:36.000000Z","updated_at":"2025-04-20T11:03:37.000000Z","normalized_code":"3939ALIL"},{"id":13255062,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","insp_violation_id":"265681550","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206363402","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T10:56:36.000000Z","updated_at":"2025-04-20T11:03:37.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13640549,"change_date":"2025-04-17 21:41:00","inspection_id":"84427803","insp_unit_id":"206363402","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":"006","insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-20T10:12:22.000000Z","updated_at":"2025-04-21T09:58:11.000000Z"}]},{"id":8376597,"change_date":"2025-04-15 21:40:00","inspection_id":"84400175","dot_number":"1814523","report_state":"MD","report_number":"0277C00005","insp_date":"2025-04-15 00:00:00","insp_start_time":"0704","insp_end_time":"0746","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WEST FRIENDSHIP MD","county_code_state":"MD","county_code":"027","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1594831","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:37.000000Z","updated_at":"2025-04-19T10:14:25.000000Z","inspection_violations":[{"id":13202374,"change_date":"2025-04-15 21:40:00","inspection_id":"84400175","insp_violation_id":"265621280","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"206313388","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"WARNING","created_at":"2025-04-18T10:51:08.000000Z","updated_at":"2025-04-18T10:55:16.000000Z","normalized_code":"39375A3TAOL"},{"id":13202375,"change_date":"2025-04-15 21:40:00","inspection_id":"84400175","insp_violation_id":"265621281","seq_no":"2","part_no":"393","part_no_section":"11A1-LRR","insp_viol_unit":"1","insp_unit_id":"206313388","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-04-18T10:51:08.000000Z","updated_at":"2025-04-18T10:55:16.000000Z","normalized_code":"39311A1LRR"},{"id":13202376,"change_date":"2025-04-15 21:40:00","inspection_id":"84400175","insp_violation_id":"265621282","seq_no":"3","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-04-18T10:51:08.000000Z","updated_at":"2025-04-18T10:55:16.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":13594641,"change_date":"2025-04-15 21:40:00","inspection_id":"84400175","insp_unit_id":"206313388","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"5GJ9264","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBND8JT151S10200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:06:29.000000Z","updated_at":"2025-04-19T09:50:19.000000Z"}]},{"id":8371025,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","dot_number":"1814523","report_state":"PA","report_number":"XL00074279","insp_date":"2025-04-12 00:00:00","insp_start_time":"0802","insp_end_time":"0930","registration_date":null,"region":"ET","ci_status_code":"C","location":"999","location_desc":"ON N MAIN ST AT ITS INTERSECTI","county_code_state":"PA","county_code":"133","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","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":"Y","pen_cen_match":null,"final_status_date":"2025-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2507918","transaction_code":"A","transaction_date":"2025-04-12 00:00:00","upload_date":"2025-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-04-14 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-17T10:05:37.000000Z","updated_at":"2025-04-18T10:23:31.000000Z","inspection_violations":[{"id":13192215,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_violation_id":"265609863","seq_no":"1","part_no":"392","part_no_section":"16","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-04-17T10:27:46.000000Z","updated_at":"2025-04-18T10:45:36.000000Z","normalized_code":"39216"},{"id":13192216,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_violation_id":"265609864","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206303481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0008155-0","created_at":"2025-04-17T10:27:46.000000Z","updated_at":"2025-04-18T10:45:36.000000Z","normalized_code":"3939"},{"id":13192217,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_violation_id":"265609865","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206303481","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:27:46.000000Z","updated_at":"2025-04-18T10:45:36.000000Z","normalized_code":"3939"},{"id":13192218,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_violation_id":"265609866","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206303481","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E0008156-1","created_at":"2025-04-17T10:27:46.000000Z","updated_at":"2025-04-18T10:45:36.000000Z","normalized_code":"39617C"},{"id":13192219,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_violation_id":"265609867","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"206303481","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-17T10:27:46.000000Z","updated_at":"2025-04-18T10:45:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":13585502,"change_date":"2025-04-14 21:41:00","inspection_id":"84394374","insp_unit_id":"206303481","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":"5","insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-17T09:57:17.000000Z","updated_at":"2025-04-18T10:02:33.000000Z"}]},{"id":8291781,"change_date":"2025-04-04 21:40:00","inspection_id":"84310786","dot_number":"1814523","report_state":"MD","report_number":"2448C00003","insp_date":"2025-04-03 00:00:00","insp_start_time":"1146","insp_end_time":"1208","registration_date":null,"region":"ED","ci_status_code":"C","location":"077025","location_desc":"DARLINGTON MD","county_code_state":"MD","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","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":"2025-04-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","viol_total":"1","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":"1551486","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-04-04 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-04 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-07T10:21:47.000000Z","updated_at":"2025-04-08T10:08:23.000000Z","inspection_violations":[{"id":13037555,"change_date":"2025-04-04 21:40:00","inspection_id":"84310786","insp_violation_id":"265434508","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":"WARNING","created_at":"2025-04-07T10:43:46.000000Z","updated_at":"2025-04-07T10:48:46.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":13443869,"change_date":"2025-04-04 21:40:00","inspection_id":"84310786","insp_unit_id":"206149825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"5GJ9264","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBND8JT151S10200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:04:23.000000Z","updated_at":"2025-04-08T09:50:20.000000Z"}]},{"id":8223202,"change_date":"2025-03-27 21:41:00","inspection_id":"84238684","dot_number":"1814523","report_state":"MD","report_number":"3245005522","insp_date":"2025-03-27 00:00:00","insp_start_time":"1020","insp_end_time":"1042","registration_date":null,"region":"ET","ci_status_code":"C","location":"024","location_desc":"RT 50 W\/B BAY BRIDGE TOLL FAC","county_code_state":"MD","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","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-03-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2789764","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-27 00:00:00","source_office":"1MDS001","mcmis_add_date":"2025-03-27 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-30T10:38:21.000000Z","updated_at":"2025-03-31T10:29:09.000000Z","inspection_violations":[{"id":12904955,"change_date":"2025-03-27 21:41:00","inspection_id":"84238684","insp_violation_id":"265284791","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"206017935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:48:53.000000Z","updated_at":"2025-03-31T10:47:49.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":13302128,"change_date":"2025-03-27 21:41:00","inspection_id":"84238684","insp_unit_id":"206017935","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:19:43.000000Z","updated_at":"2025-03-31T09:57:46.000000Z"}]},{"id":7447784,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","dot_number":"1814523","report_state":"MD","report_number":"0316000060","insp_date":"2024-12-18 00:00:00","insp_start_time":"0920","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"002","location_desc":"I-70 NEW MARKET SCALE HOUSE","county_code_state":"MD","county_code":"021","insp_level_id":"1","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":"Y","pen_cen_match":null,"final_status_date":"2024-12-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2769352","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-18 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-12-18 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:32.000000Z","updated_at":"2025-03-17T20:51:32.000000Z","inspection_violations":[{"id":11638666,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_violation_id":"263541114","seq_no":"4","part_no":"391","part_no_section":"41A-MCPC","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-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"39141AMCPC"},{"id":11638667,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_violation_id":"263541115","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"204450769","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3922SLLSR"},{"id":11638668,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_violation_id":"263541116","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"204450769","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3939ALFTSI"},{"id":11638669,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_violation_id":"263541117","seq_no":"2","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204450769","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3939ALHLI"},{"id":11638670,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_violation_id":"263541118","seq_no":"3","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"204450769","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3939ALHWS"}],"inspection_per_units":[{"id":12014979,"change_date":"2024-12-18 21:40:00","inspection_id":"83423911","insp_unit_id":"204450769","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:37.000000Z","updated_at":"2025-03-17T23:47:37.000000Z"}]},{"id":7437836,"change_date":"2025-10-22 21:39:00","inspection_id":"83413474","dot_number":"1814523","report_state":"MD","report_number":"2402000099","insp_date":"2024-12-17 00:00:00","insp_start_time":"0804","insp_end_time":"0820","registration_date":null,"region":"ES","ci_status_code":"C","location":"001","location_desc":"MD","county_code_state":"MD","county_code":"510","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BRG","shipping_paper_number":"1124339316922","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"259006","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":"2425129","transaction_code":"C","transaction_date":"2025-10-22 00:00:00","upload_date":"2025-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":"2025-10-17 21:38:00","snet_input_date":"2024-12-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-12-17 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:11.000000Z","updated_at":"2025-10-26T10:00:16.000000Z","inspection_violations":[{"id":16533326,"change_date":"2025-10-22 21:39:00","inspection_id":"83413474","insp_violation_id":"269444494","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209594425","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CWR0J7R","created_at":"2025-10-25T10:17:02.000000Z","updated_at":"2025-10-26T10:15:21.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16613262,"change_date":"2025-10-22 21:39:00","inspection_id":"83413474","insp_unit_id":"209594425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CUSTOM SCO","insp_unit_company":"N\/A","insp_unit_license":"9GJ5386","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"1HTMMAAL6CH148165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-25T09:46:39.000000Z","updated_at":"2025-10-26T09:45:18.000000Z"}]},{"id":7344154,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","dot_number":"1814523","report_state":"MD","report_number":"2018005486","insp_date":"2024-12-05 00:00:00","insp_start_time":"1245","insp_end_time":"1317","registration_date":null,"region":"ET","ci_status_code":"C","location":"038","location_desc":"BALTIMORE COUNTY","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST BUY","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":"2024-12-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2766553","transaction_code":"A","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-05 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-12-05 21:37:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:49:22.000000Z","updated_at":"2025-03-17T20:49:22.000000Z","inspection_violations":[{"id":11479814,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250325","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"CLQ0BJK","created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"39216AD"},{"id":11479815,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250326","seq_no":"2","part_no":"392","part_no_section":"16B-DPASS","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:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"39216BDPASS"},{"id":11479816,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250327","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"204198233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939ALCL"},{"id":11479817,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250328","seq_no":"4","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204198233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939ALIL"},{"id":11479818,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250329","seq_no":"5","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"204198233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939ALHLI"},{"id":11479819,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250330","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204198233","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"39617CPI"},{"id":11479820,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_violation_id":"263250331","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"204198233","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:49.000000Z","updated_at":"2025-03-17T22:01:49.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":11847011,"change_date":"2024-12-05 21:37:00","inspection_id":"83314964","insp_unit_id":"204198233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"5FJ7900","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H27AR61058","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:49.000000Z","updated_at":"2025-03-17T23:45:49.000000Z"}]},{"id":6920595,"change_date":"2024-10-09 21:41:00","inspection_id":"82866398","dot_number":"1814523","report_state":"MD","report_number":"3259003334","insp_date":"2024-10-08 00:00:00","insp_start_time":"1630","insp_end_time":"1655","registration_date":null,"region":"ET","ci_status_code":"C","location":"072","location_desc":"SOUTHBOUND ON 895}TOLL FACILIT","county_code_state":"MD","county_code":"510","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":"2024-10-09 21:41: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":"2752475","transaction_code":"A","transaction_date":"2024-10-08 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-10-08 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-10-09 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:40:35.000000Z","updated_at":"2025-03-17T20:40:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11161594,"change_date":"2024-10-09 21:41:00","inspection_id":"82866398","insp_unit_id":"203333476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"3FH2578","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H97AR60876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:36.000000Z","updated_at":"2025-03-17T23:38:36.000000Z"}]},{"id":6815480,"change_date":"2024-09-25 21:41:00","inspection_id":"82754792","dot_number":"1814523","report_state":"MD","report_number":"5784000323","insp_date":"2024-09-25 00:00:00","insp_start_time":"0950","insp_end_time":"1020","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":"SELF","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":"2024-09-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2749995","transaction_code":"A","transaction_date":"2024-09-25 00:00:00","upload_date":"2024-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-25 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:14.000000Z","updated_at":"2025-03-17T20:38:14.000000Z","inspection_violations":[{"id":10614063,"change_date":"2024-09-25 21:41:00","inspection_id":"82754792","insp_violation_id":"262025257","seq_no":"1","part_no":"392","part_no_section":"16(a)","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-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39216A"},{"id":10614064,"change_date":"2024-09-25 21:41:00","inspection_id":"82754792","insp_violation_id":"262025258","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203121944","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"3939A"},{"id":10614065,"change_date":"2024-09-25 21:41:00","inspection_id":"82754792","insp_violation_id":"262025259","seq_no":"3","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:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":10990666,"change_date":"2024-09-25 21:41:00","inspection_id":"82754792","insp_unit_id":"203121944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":"1","insp_unit_license":"3FH2578","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H97AR60876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:51.000000Z","updated_at":"2025-03-17T23:36:51.000000Z"}]},{"id":5848939,"change_date":"2024-05-28 21:42:00","inspection_id":"81718343","dot_number":"1814523","report_state":"MD","report_number":"0302004748","insp_date":"2024-05-28 00:00:00","insp_start_time":"0843","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"QUEEN ANNES COUNTY","county_code_state":"MD","county_code":"035","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"ELECTRONIC","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2721308","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-28 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:40.000000Z","updated_at":"2025-03-17T20:18:40.000000Z","inspection_violations":[{"id":9066641,"change_date":"2024-05-28 21:42:00","inspection_id":"81718343","insp_violation_id":"259746145","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"201098143","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:50.000000Z","updated_at":"2025-03-17T21:49:50.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":9420218,"change_date":"2024-05-28 21:42:00","inspection_id":"81718343","insp_unit_id":"201098143","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"6FF3522","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:46.000000Z","updated_at":"2025-03-17T23:20:46.000000Z"}]},{"id":5473247,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","dot_number":"1814523","report_state":"PA","report_number":"XL00063910","insp_date":"2024-04-08 00:00:00","insp_start_time":"0840","insp_end_time":"0945","registration_date":"2024-04-22 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"LINDEN ST MEASURING 64 FEET EA","county_code_state":"PA","county_code":"071","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","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":"Y","pen_cen_match":null,"final_status_date":"2024-04-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2431857","transaction_code":"C","transaction_date":"2024-04-08 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-04-08 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-04-09 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"624 5TH AVE","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:11.000000Z","updated_at":"2025-03-17T20:11:11.000000Z","inspection_violations":[{"id":8450669,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084895","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"39617C"},{"id":8450670,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084896","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"39378"},{"id":8450671,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084897","seq_no":"3","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"39216A"},{"id":8450672,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084898","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"3939A"},{"id":8450673,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084899","seq_no":"5","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"39330"},{"id":8450674,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_violation_id":"259084900","seq_no":"6","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"200532693","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"E0002904-6","created_at":"2025-03-17T21:46:55.000000Z","updated_at":"2025-03-17T21:46:55.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":8816348,"change_date":"2024-04-23 21:41:00","inspection_id":"81309784","insp_unit_id":"200532693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"4ET8077","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBFE2JS921S10379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:01.000000Z","updated_at":"2025-03-17T23:15:01.000000Z"}]},{"id":5140567,"change_date":"2024-02-27 21:38:00","inspection_id":"80946966","dot_number":"1814523","report_state":"MD","report_number":"0226006429","insp_date":"2024-02-27 00:00:00","insp_start_time":"1437","insp_end_time":"1446","registration_date":null,"region":"ET","ci_status_code":"C","location":"037","location_desc":"BALTIMORE CITY","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2700986","transaction_code":"A","transaction_date":"2024-02-27 00:00:00","upload_date":"2024-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-27 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-02-27 21:38:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:30.000000Z","updated_at":"2025-03-17T20:04:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8276945,"change_date":"2024-02-27 21:38:00","inspection_id":"80946966","insp_unit_id":"199611075","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"6FF3522","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:00.000000Z","updated_at":"2025-03-17T23:10:00.000000Z"}]},{"id":4811833,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","dot_number":"1814523","report_state":"MD","report_number":"2325001209","insp_date":"2024-01-11 00:00:00","insp_start_time":"1025","insp_end_time":"1056","registration_date":null,"region":"ET","ci_status_code":"C","location":"037","location_desc":"BALTIMORE CITY","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEST BUY","shipping_paper_number":"1","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-01-11 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2689543","transaction_code":"A","transaction_date":"2024-01-11 00:00:00","upload_date":"2024-01-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-01-11 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:02.000000Z","updated_at":"2025-03-17T19:58:02.000000Z","inspection_violations":[{"id":7422336,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_violation_id":"257295430","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198917235","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"39395A"},{"id":7422337,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_violation_id":"257295431","seq_no":"2","part_no":"393","part_no_section":"55(b)","insp_viol_unit":"1","insp_unit_id":"198917235","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"54N0V1T","created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"39355B"},{"id":7422338,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_violation_id":"257295432","seq_no":"3","part_no":"393","part_no_section":"100(c)","insp_viol_unit":"1","insp_unit_id":"198917235","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"393100C"},{"id":7422339,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_violation_id":"257295433","seq_no":"4","part_no":"393","part_no_section":"67(c)(7)(v)","insp_viol_unit":"1","insp_unit_id":"198917235","insp_violation_category_id":"18","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"39367C7V"},{"id":7422340,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_violation_id":"257295434","seq_no":"5","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":"54P0V1T","created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7741829,"change_date":"2024-01-11 21:46:00","inspection_id":"80587507","insp_unit_id":"198917235","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:12.000000Z","updated_at":"2025-03-17T23:05:12.000000Z"}]},{"id":4370193,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","dot_number":"1814523","report_state":"MD","report_number":"3211004236","insp_date":"2023-11-07 00:00:00","insp_start_time":"0720","insp_end_time":"0801","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"RT 50 E\/B BAY BRIDGE TOLL FAC","county_code_state":"MD","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","shipping_paper_number":"5246500","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2674870","transaction_code":"A","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-07 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:32.000000Z","updated_at":"2025-03-17T19:49:32.000000Z","inspection_violations":[{"id":6761406,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_violation_id":"256255882","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197939441","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3SM0AZ9","created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3922"},{"id":6761407,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_violation_id":"256255883","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197939441","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3939A"},{"id":6761408,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_violation_id":"256255884","seq_no":"3","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"197939441","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"39341"},{"id":6761409,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_violation_id":"256255885","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197939441","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3939A"},{"id":6761410,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_violation_id":"256255886","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197939441","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:34.000000Z","updated_at":"2025-03-17T21:38:34.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7028624,"change_date":"2023-11-07 21:40:00","inspection_id":"80102534","insp_unit_id":"197939441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"6FF3522","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":4320692,"change_date":"2024-01-19 21:43:00","inspection_id":"80048039","dot_number":"1814523","report_state":"MD","report_number":"2348003470","insp_date":"2023-10-31 00:00:00","insp_start_time":"0949","insp_end_time":"1008","registration_date":"2024-01-19 00:00:00","region":"ET","ci_status_code":"C","location":"048","location_desc":"HOWARD COUNTY","county_code_state":"MD","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT FREIGHT SERVICES","shipping_paper_number":"722","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-31 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2673165","transaction_code":"C","transaction_date":"2024-01-04 00:00:00","upload_date":"2024-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-31 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-10-31 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:41.000000Z","updated_at":"2025-03-17T19:48:41.000000Z","inspection_violations":[{"id":6682967,"change_date":"2024-01-19 21:43:00","inspection_id":"80048039","insp_violation_id":"257410990","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199026798","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6949037,"change_date":"2024-01-19 21:43:00","inspection_id":"80048039","insp_unit_id":"199026798","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"4ET8077","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBFE2JS921S10379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:19.000000Z","updated_at":"2025-03-17T22:58:19.000000Z"}]},{"id":3909257,"change_date":"2023-09-06 21:42:00","inspection_id":"79591881","dot_number":"1814523","report_state":"MD","report_number":"2319002964","insp_date":"2023-09-05 00:00:00","insp_start_time":"1604","insp_end_time":"1622","registration_date":null,"region":"ET","ci_status_code":"C","location":"002","location_desc":"I-70 NEW MARKET SCALE HOUSE","county_code_state":"MD","county_code":"021","insp_level_id":"1","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-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2659104","transaction_code":"A","transaction_date":"2023-09-05 00:00:00","upload_date":"2023-09-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-05 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-09-06 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:05.000000Z","updated_at":"2025-03-17T19:40:05.000000Z","inspection_violations":[{"id":6041407,"change_date":"2023-09-06 21:42:00","inspection_id":"79591881","insp_violation_id":"255096340","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196910382","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:16.000000Z","updated_at":"2025-03-17T21:35:16.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6285651,"change_date":"2023-09-06 21:42:00","inspection_id":"79591881","insp_unit_id":"196910382","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"6FF3522","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:49.000000Z","updated_at":"2025-03-17T22:52:49.000000Z"}]},{"id":3339074,"change_date":"2023-06-22 21:41:00","inspection_id":"78953251","dot_number":"1814523","report_state":"MD","report_number":"3211003794","insp_date":"2023-06-22 00:00:00","insp_start_time":"0738","insp_end_time":"0812","registration_date":null,"region":"ET","ci_status_code":"C","location":"023","location_desc":"RT 50 E\/B BAY BRIDGE TOLL FAC","county_code_state":"MD","county_code":"003","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEST BUY","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":"2023-06-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2642327","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-22 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-06-22 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:58.000000Z","updated_at":"2025-03-17T19:28:58.000000Z","inspection_violations":[{"id":5149089,"change_date":"2023-06-22 21:41:00","inspection_id":"78953251","insp_violation_id":"253634122","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195616107","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"39360C"},{"id":5149090,"change_date":"2023-06-22 21:41:00","inspection_id":"78953251","insp_violation_id":"253634123","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195616107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"},{"id":5149091,"change_date":"2023-06-22 21:41:00","inspection_id":"78953251","insp_violation_id":"253634124","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195616107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:54.000000Z","updated_at":"2025-03-17T21:30:54.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5368210,"change_date":"2023-06-22 21:41:00","inspection_id":"78953251","insp_unit_id":"195616107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":"5","insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:20.000000Z","updated_at":"2025-03-17T22:45:20.000000Z"}]},{"id":3322039,"change_date":"2023-06-20 21:41:00","inspection_id":"78934234","dot_number":"1814523","report_state":"TN","report_number":"MDAE000437","insp_date":"2023-06-19 00:00:00","insp_start_time":"0845","insp_end_time":"0906","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"TN","county_code":"041","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"GUERRA TRANSPORTATION","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":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1654144","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-20 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:52.000000Z","updated_at":"2025-03-17T19:28:52.000000Z","inspection_violations":[{"id":5123967,"change_date":"2023-06-20 21:41:00","inspection_id":"78934234","insp_violation_id":"253596108","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3922"},{"id":5123968,"change_date":"2023-06-20 21:41:00","inspection_id":"78934234","insp_violation_id":"253596109","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195578667","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:49.000000Z","updated_at":"2025-03-17T21:30:49.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5340127,"change_date":"2023-06-20 21:41:00","inspection_id":"78934234","insp_unit_id":"195578667","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"H453777","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5PVNJ8JV1J4S67525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":3098312,"change_date":"2023-05-19 21:44:00","inspection_id":"78681502","dot_number":"1814523","report_state":"PA","report_number":"M410500042","insp_date":"2023-05-18 00:00:00","insp_start_time":"1000","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"224 AT MARTIN KELLY SPEAR","county_code_state":"PA","county_code":"073","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":"I","final_status_date":"2023-05-19 21:44: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":"2349213","transaction_code":"A","transaction_date":"2023-05-18 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-18 00:00:00","source_office":"1PAS001","mcmis_add_date":"2023-05-19 21:44:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:14.000000Z","updated_at":"2025-03-17T19:24:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4983934,"change_date":"2023-05-19 21:44:00","inspection_id":"78681502","insp_unit_id":"195048471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"001","insp_unit_license":"9FC2115","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H97AS60100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:17.000000Z","updated_at":"2025-03-17T22:42:17.000000Z"}]},{"id":2641248,"change_date":"2023-03-23 21:42:00","inspection_id":"78163210","dot_number":"1814523","report_state":"MD","report_number":"3242001437","insp_date":"2023-03-22 00:00:00","insp_start_time":"1636","insp_end_time":"1659","registration_date":null,"region":"ET","ci_status_code":"C","location":"065","location_desc":"I-695 E\/B FSK BRIDGE TOLL FACI","county_code_state":"MD","county_code":"005","insp_level_id":"1","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-03-23 21:42: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":"2619119","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-22 00:00:00","source_office":"1MDS001","mcmis_add_date":"2023-03-23 21:42:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:29.000000Z","updated_at":"2025-03-17T19:15:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4252011,"change_date":"2023-03-23 21:42:00","inspection_id":"78163210","insp_unit_id":"194018458","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:30.000000Z","updated_at":"2025-03-17T22:36:30.000000Z"}]},{"id":2042377,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","dot_number":"1814523","report_state":"MD","report_number":"2064005731","insp_date":"2022-12-29 00:00:00","insp_start_time":"1507","insp_end_time":"1525","registration_date":null,"region":"ET","ci_status_code":"C","location":"038","location_desc":"BALTIMORE COUNTY","county_code_state":"MD","county_code":"005","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-30 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2598900","transaction_code":"A","transaction_date":"2022-12-29 00:00:00","upload_date":"2022-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-29 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-12-30 21:36:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:20.000000Z","updated_at":"2025-03-17T19:04:20.000000Z","inspection_violations":[{"id":3164889,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","insp_violation_id":"250327291","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:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39216A"},{"id":3164890,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","insp_violation_id":"250327292","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"3922"},{"id":3164891,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","insp_violation_id":"250327293","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192641879","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"39395A"},{"id":3164892,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","insp_violation_id":"250327294","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192641879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:00.000000Z","updated_at":"2025-03-17T21:22:00.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3285519,"change_date":"2022-12-30 21:36:00","inspection_id":"77480274","insp_unit_id":"192641879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"9FC1738","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAPA80H87AN60422","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:32.000000Z","updated_at":"2025-03-17T22:29:32.000000Z"}]},{"id":1991896,"change_date":"2022-12-21 21:39:00","inspection_id":"77422834","dot_number":"1814523","report_state":"MD","report_number":"2388000051","insp_date":"2022-12-21 00:00:00","insp_start_time":"0710","insp_end_time":"0721","registration_date":null,"region":"ET","ci_status_code":"C","location":"013","location_desc":"I-95 @ I-495 (PARK AND RIDE)","county_code_state":"MD","county_code":"033","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"NA","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":"19500","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":"2597835","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":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-21 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-12-21 21:39:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","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":[],"inspection_per_units":[{"id":3204717,"change_date":"2022-12-21 21:39:00","inspection_id":"77422834","insp_unit_id":"192528542","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"1DL8733","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","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":1992097,"change_date":"2022-12-21 21:39:00","inspection_id":"77423054","dot_number":"1814523","report_state":"MD","report_number":"2366000457","insp_date":"2022-12-21 00:00:00","insp_start_time":"0742","insp_end_time":"0748","registration_date":null,"region":"ET","ci_status_code":"C","location":"040","location_desc":"CAROLINE COUNTY","county_code_state":"MD","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","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":"2022-12-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2597846","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":"01814523","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":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","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":[],"inspection_per_units":[{"id":3204968,"change_date":"2022-12-21 21:39:00","inspection_id":"77423054","insp_unit_id":"192528835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"4ET8077","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBFE2JS921S10379","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":1724740,"change_date":"2022-11-14 21:41:00","inspection_id":"77116838","dot_number":"1814523","report_state":"VA","report_number":"9138000616","insp_date":"2022-11-10 00:00:00","insp_start_time":"0739","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":"DUMSCS","location_desc":"DUMFRIES SCALES SOUTH","county_code_state":"VA","county_code":"153","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"BEST BUY","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-11-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"848092","transaction_code":"A","transaction_date":"2022-11-14 00:00:00","upload_date":"2022-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-14 00:00:00","source_office":"1VAS001","mcmis_add_date":"2022-11-14 21:41:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:32.000000Z","updated_at":"2025-03-17T18:58:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2774386,"change_date":"2022-11-14 21:41:00","inspection_id":"77116838","insp_unit_id":"191921196","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"8ET9823","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JHBFE2JR7Y2S10509","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:58.000000Z","updated_at":"2025-03-17T22:25:58.000000Z"}]},{"id":1383548,"change_date":"2022-09-28 21:40:00","inspection_id":"76723470","dot_number":"1814523","report_state":"MD","report_number":"2348002356","insp_date":"2022-09-28 00:00:00","insp_start_time":"0656","insp_end_time":"0718","registration_date":null,"region":"ET","ci_status_code":"C","location":"048","location_desc":"HOWARD COUNTY","county_code_state":"MD","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME AS CARRIER","shipping_paper_number":"8913713","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-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2576267","transaction_code":"A","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-09-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-28 00:00:00","source_office":"1MDS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[{"id":2186983,"change_date":"2022-09-28 21:40:00","inspection_id":"76723470","insp_violation_id":"248685817","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191135166","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2227937,"change_date":"2022-09-28 21:40:00","inspection_id":"76723470","insp_unit_id":"191135166","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"NDMC","insp_unit_company":null,"insp_unit_license":"1DL8733","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"JNAMB33H21AN60132","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:15.000000Z","updated_at":"2025-03-17T22:22:15.000000Z"}]},{"id":39895,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","dot_number":"1814523","report_state":"DC","report_number":"2739220480","insp_date":"2022-03-23 00:00:00","insp_start_time":"0707","insp_end_time":"0745","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"700 BLK L STREET NW","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":"BEST BUY","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":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"98403","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01814523","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-25 00:00:00","source_office":"1DCS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"GUERRA TRANSPORTATION LLC","insp_carrier_street":"224 GREEN FERN WAY","insp_carrier_city":"HALETHORPE","insp_carrier_state":"MD","insp_carrier_zip_code":"21227","insp_colonia":null,"docket_number":"782846","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:09.000000Z","updated_at":"2025-03-17T18:28:09.000000Z","inspection_violations":[{"id":57148,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","insp_violation_id":"244773263","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"187815193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7916798713","created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39021B"},{"id":57149,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","insp_violation_id":"244773264","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"187815193","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"39378"},{"id":57150,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","insp_violation_id":"244773265","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187815193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"},{"id":57151,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","insp_violation_id":"244773266","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"187815193","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:21.000000Z","updated_at":"2025-03-17T21:07:21.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":64431,"change_date":"2022-03-25 21:31:00","inspection_id":"75136230","insp_unit_id":"187815193","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"856","insp_unit_license":"1EZ2934","insp_unit_license_state":"MD","insp_unit_vehicle_id_number":"5PVNV8JT5B4S51865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:39.000000Z","updated_at":"2025-03-17T22:08:39.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1814523\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1814523\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1814523\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/1814523\/inspections","per_page":100,"prev_page_url":null,"to":38,"total":38}