Service difficulty reports · 251

Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.

Query with SQL

duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
  FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
  WHERE n_number = 'N503SW' AND deregistration_id = 'N503SW-2012-07-16'
  ORDER BY difficulty_date DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
WHERE n_number = 'N503SW' AND deregistration_id = 'N503SW-2012-07-16'
ORDER BY difficulty_date DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

SDR SWAA950185Uplock Sensor · malfunctionAFTER TAKEOFF, LEFT MAIN GEAR RED LIGHT REMAINED ILLUMINATED. RECYCLED GEAR AND LIGHT EXTINGUISHED. AIRCRAFT LANDED WITHOUT INCIDENT. INSPECTED, TIGHTENED RED LIGHT BASE, AND OPERATION CHECKED PER BOEING M/M. ON NEXT FLIGHT EXPERIENCED RED LIGHT FLICKERINGFeb 17, 1995 · N503SW · Boeing 7375H4 · Landing Gear Position and Warning

Back to N503SW, cancelled Jul 16, 2012