# README for Air Travel Consumer Report: May 2000 [supporting dataset]  
Office of Aviation Enforcement and Proceedings/Office of Aviation Consumer Protection. Office of the Secretary of Transportation, U.S. Department of Transportation (USDOT)  
2024-07-25  
## Links to Dataset  
Dataset Archive Link: <https://doi.org/10.21949/1530623>  
Series Archive Link: <https://doi.org/10.21949/1530604>  

## Summary of Dataset  

The Air Travel Consumer Report is a monthly product of the Department of Transportation's Office of Aviation Enforcement and Proceedings. The report is designed to assist consumers with information on the quality of services provided by the airlines. The report is divided into four sections. These sections deal with flight delays, mishandled baggage, oversales and consumer complaints. Each section of the report is preceded by a brief explanation of how to read and understand the information provided.  

>  Data Coverage  
>  Flight Delays: March 2000/12 Months Ending March 2000  
>  Mishandled Baggage: March 2000/January - March 2000  
>  Oversales: 4th Quarter 1999/January - December 1999  
>  Consumer Complaints: March 2000, January - March 2000    

## Table of Contents  
A. [General Information](#a-general-information)  
B. [Sharing/Access & Policies Information](#b-sharingaccess-and-policies-information)  
C. [Data and Related Files Overview](#c-data-and-related-files-overview)  
D. [Methodological Information](#d-methodological-information)  
E. [Data-Specific Information for: Air Travel Consumer Report: May 2000 [supporting dataset]](#e-data-specific-information)  
F. [Update Log](#f-update-log) 

**Title of Dataset:**  Air Travel Consumer Report: May 2000 [supporting dataset]  

**Description of the Dataset:** The Air Travel Consumer Report is a monthly product of the Department of Transportation's Office of Aviation Enforcement and Proceedings. The report is designed to assist consumers with information on the quality of services provided by the airlines. The report is divided into four sections. These sections deal with flight delays, mishandled baggage, oversales and consumer complaints. Each section of the report is preceded by a brief explanation of how to read and understand the information provided.  

**Dataset Archive Link:** <https://doi.org/10.21949/1530623>

**Authorship Information:**  

>  *Principal Data Creator Contact Information*   
>  Institution: Office of Aviation Consumer Protection. Department of Transportation ([ROR ID: https://ror.org/02xfw2e90](https://ror.org/02xfw2e90))  
>  Address: 1200 New Jersey Ave SE, Washington, DC 20590  
>  Phone: (202) 366-2220  

>  *Data Distributor Contact Information*  
>  Institution: National Transportation Library ([ROR ID: https://ror.org/00snbrd52](https://ror.org/00snbrd52))   
>  Address: 1200 New Jersey Ave SE, Washington, DC 20590  
>  Email: <ntldatacurator@dot.gov> and ([National Transportation Library's Ask A Librarian](https://transportation.libanswers.com/))  

>  *Organizational Contact Information*  
>  Institution: Office of Aviation Consumer Protection. Department of Transportation ([ROR ID: https://ror.org/02xfw2e90](https://ror.org/02xfw2e90))  
>  Address: 1200 New Jersey Ave SE, Washington, DC 20590  
>  Phone: (202) 366-2220  

**Date of data collection and update interval:**  
Flight Delays: March 2000/12 Months Ending March 2000  
Mishandled Baggage: March 2000/January - March 2000  
Oversales: 4th Quarter 1999/January - December 1999  
Consumer Complaints: March 2000, January - March 2000    

**Geographic location of data collection:** United States [(GeoNames URI: http://sws.geonames.org/6252001/)](http://sws.geonames.org/6252001/)   

**Information about funding sources that supported the collection of the data:** The Office of Aviation Consumer Protection is an office under the Office of the Secretary of Transportation, which is funded and overseen by the Department of Transportation.    

## B. Sharing/Access and Policies Information  

**Recommended citation for the data:**  

>  Office of Aviation Consumer Protection. Department of Transportation. *Air Travel Consumer Report: May 2000* [supporting dataset]. (2000). <https://doi.org/10.21949/1530623>  

**Licenses/restrictions placed on the data:** This document is disseminated under the sponsorship of the U.S. Department of Transportation in the interest of information exchange. The United States Government assumes no liability for the contents thereof.  

**Was data derived from another source?:** No  

This document was created to meet the requirements enumerated in the U.S. Department of Transportation's [Plan to Increase Public Access to the Results of Federally-Funded Scientific Research Version 1.1](https://doi.org/10.21949/1520559) and [Guidelines Suggested by the DOT Public Access website](https://doi.org/10.21949/1503647), in effect and current as of December 03, 2020.  

 
## C. Data and Related Files Overview  

File List for the ATCR_2000_May.zip  

>  1. Filename: Air Travel Consumer Report January 1999 through December 1999 and January 1998 through December 1998 Passengers denied Boarding By U.S. Airlines.xlsx  
>  Short Description:  Table of U.S. Airlines and how many passengers were enplaned and how many were denied boarding voluntarily and involuntary by Airline company.   

>  2. Filename: Air Travel Consumer Report January through March 2000 and January through March 1999 Complaint Categories.xlsx  
>  Short Description:  Table of total complaints by category. Complaint categories and their complete definition are found at the end of the document.   

>  3. Filename: Air Travel Consumer Report January through March 2000 and January through March 1999 Consumer Complaints Summary.xlsx   
>  Short Description:  This table gives a summary of the number of complaints, opinions, compliments, and information requests received by groups in the airlines industry.  

>  4. Filename: Air Travel Consumer Report January through March 2000 and January through March 1999 Mishandled Baggage Reports Filed By Passengers.xlsx  
>  Short Description:  This section gives the rate of mishandled-baggage reports per 1,000 passengers by carrier and for the industry.  

>  5. Filename: Air Travel Consumer Report January through March 2000 Companies Other Than U.S. Airlines By Complaint Category.xlsx  
>  Short Description:  Table of reported problems by complaint category against non-U.S. Airlines.   

>  6. Filename: Air Travel Consumer Report January through March 2000 Complaints Against U.S. Airlines By Complaint Category.xlsx   
>  Short Description:   Table of reported problems by complaint category against non-U.S. Airlines.  

>  7. Filename: Air Travel Consumer Report January through March 2000 Consumer Complaints Rankings U.S. Airlines.xlsx  
>  Short Description:  Table of complaints by U.S. Airlines ranked from highest to lowest.  

>  8. Filename: Air Travel Consumer Report March 2000 and March 1999 Complaint Categories.xlsx  
>  Short Description:  Table of total complaints by category. Complaint categories and their complete definition are found at the end of the document.  

>  9. Filename: Air Travel Consumer Report March 2000 and March 1999 Consumer Complaints Summary.xlsx  
>  Short Description:  This table gives a summary of the number of complaints, opinions, compliments, and information requests received by groups in the airlines industry.   

>  10. Filename: Air Travel Consumer Report March 2000 and March 1999 Mishandled Baggage Reports Filed By Passengers.xlsx  
>  Short Description:  This section gives the rate of mishandled-baggage reports per 1,000 passengers by carrier and for the industry.  

>  11. Filename: Air Travel Consumer Report March 2000 Companies Other Than U.S. Airlines By Complaint Category.xlsx  
>  Short Description:  Table of reported problems by complaint category against non-U.S. Airlines.  

>  12. Filename: Air Travel Consumer Report March 2000 Complaints Against U.S. Airlines By Incident Date.xlsx  
>  Short Description:  Table of reported problems by complaint category against non-U.S. Airlines.  

>  13. Filename: Air Travel Consumer Report October 1999 through December 1999 and October 1998 through December 1998 Passengers denied Boarding By U.S. Airlines.xlsx  
>  Short Description:  Table of U.S. Airlines and how many passengers were enplaned and how many were denied boarding voluntarily and involuntary by Airline company.  

>  14. Filename: Air Travel Consumer Report March 2000 Consumer Complaints Rankings U.S. Airlines.xlsx  
>  Short Description:  Table of complaints by U.S. Airlines ranked from highest to lowest.  

>  16. Filename: Air Travel Consumer Report March 2000 Table 1 Overall Percentage of Reported Flight Operations Arriving on Time By Carrier.xlsx  
>  Short Description:  This is a table of the number of flights arriving on time by Carrier with percentage of arrivals on time.  

>  17. Filename: Air Travel Consumer Report March 2000 Table 1A. Overall Percentage of Reported Flight Operations.xlsx  
>  Short Description:  This table has the overall percentage of flights arriving on time by quarter, month, and year.  

>  18. Filename: Air Travel Consumer Report March 2000 Table 2 Number Of Reported Flight Arrivals And Percentage Arriving On Time D.xlsx  
>  Short Description:  This table is the number of arrivals on time by carrier and airport broken down by airport.  

>  19. Filename: Air Travel Consumer Report March 2000 Table 3 Percentage Of All Carriers' Reported Flight Operations Arriving OnTime D By.xlsx  
>  Short Description:  This table is the percentage of all carriers' arriving on time by airport and time of day.  

>  20. Filename: Air Travel Consumer Report March 2000 Table 4 Percentage of All Carriers' Reported Flight operations Departing On Time.xlsx  
>  Short Description:  This table is the percentage of all carriers' departing on time by airport and time of day.   

>  21. Filename: Air Travel Consumer Report March 2000 Table 5 List Of Regularly Scheduled Flights I Arriving Late 80% Of The Time Or More.xlsx  
>  Short Description:  This is a table of the flights arriving late more than 80% of the time with percentage of how many arrive 15 minutes late or more.   

>  22. Filename: Air Travel Consumer Report March 2000 Table 6 Number And Percentage Of Regularly Schedule Flights I Arriving Late 70% Of The Time Or More.xlsx  
>  Short Description:  This is the number and percentage of scheduled flights arriving late more than 70% of the time or more.  

>  23. Filename: Air Travel Consumer Report March 2000 Table 7 On-Time Arrival And Departure Percentage By Airport.xlsx  
>  Short Description:  This table contains all of the percentage of arrivals and departures are on time by airport.  

>  24. Filename: Air Travel Consumer Report March 2000 Table 8. Overall Number and Percentage of Flight Cancellations By Carrier.xlsx  
>  Short Description:  

## D. Methodological Information  

**Description of methods used for collection/generation of data:** The sections dealing with flight delays, mishandled baggage, wheelchairs, scooters, and oversales are based on data collected by the Department of Transportation. The section that deals with consumer complaints is based on data compiled by the Office of Aviation Consumer Protection (OACP). The OACP gathers and analyzes complaints submitted by passengers, addressing issues such as customer service, refunds, and other concerns.  

**Instrument or software-specific information needed to interpret the data:** These data tables were originally only available in PDF form. They have been extracted using ABBYY FineReader PDF Software and cleaned in Microsoft Excel. Both Excel and CSV versions of this data are available in this data package. Due to the merged columns and table structure, they are best viewed in XLSX form, but can be viewed in CSV form. If you do not have access to Microsoft Excel, please use an open-source alternative, such as OpenRefine or Notepad ++.  

## E. Data-Specific Information  

Because of the innumerate amount of data tables created for the Air Travel Consumer Report for May 2000, counting the number of rows and columns is too extraneous for this project. Additionally, because these data tables are summaries of the data and not the raw data itself, there are no variables to define, so there is no data dictionary. In the case of null or blank data, this means that the data was either not reported, not applicable, or as reported depending on the question. For these data tables, each null or blank value is explained with footnotes and in the reports.  

## F. Update Log  

This README.md file was originally created on 2024-07-25 by Peyton Tvrdy ([0000-0002-9720-4725](https://orcid.org/0000-0002-9720-4725)), Data Management and Data Curation Fellow, National Transportation Library <peyton.tvrdy.ctr@dot.gov>  
 
2024-07-25: Original file created  
