N569SW, cancelled Feb 2, 2016
Service difficulty reports · 104
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 = 'N569SW' AND deregistration_id = 'N569SW-2016-02-02' 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 = 'N569SW' AND deregistration_id = 'N569SW-2016-02-02' 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 SWIA972171Connector · contaminatedIN FLIGHT AT FLIGHT LEVEL 230 ELEVATOR TRIM BECAME VERY ERRATIC. DISCONNECTED TRIM AND AUTOPILOT. TRIM WHEEL BECAME VERY HARD TO TURN. REMOVED MOISTURE FROM LEFT AND RIGHT ELEVATOR TRIM ACTUATORS. CYCLED ELEVATOR TRIM FULL TRAVEL. OPS CHECK GOOD.SDR SWIA971936Strut · dischargedGEAR DOOR NOT RETRACT NORMALLY, MUST USE DOWNLOCK RELEASE. SERVICED NOSE STRUT ASSEMBLY WITH NITROGEN IAW MM 12-13-04. OPS CHECKS GOOD.SDR SWIA971848Light · inoperativeLINE RIGHT FORWARD EMERGENCY LIGHT INOP, FOUND CENTER ELBP LOW VOLTAGE. REMOVED AND REPLACED CENTER ELBP, OPS CHECK GOOD P/N ON D36604001, S/N 104, S/N OFF 178.SDR SWIA971361Door · not latchedRETURNED TO LAS DUE TO SERVICE DOOR LIGHT. FOUND FUEL DOOR NOT LATCHED PROPERLY. FUELER LATCHED DOOR, CHECKS GOOD. MEL 52-70-1. INSPECTED ALL SERVICE DOORS AND LATCHES. ALL FOUND GOOD. SERVICE DOOR LIGHT SYSTEM FOUND TO BE WORKING NORMAL.
Back to N569SW, cancelled Feb 2, 2016