N565SW, cancelled Apr 6, 2018
Service difficulty reports · 116
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 = 'N565SW' AND deregistration_id = 'N565SW-2018-04-06' 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 = 'N565SW' AND deregistration_id = 'N565SW-2018-04-06' 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 SWIA200110347Control Cable · wornRIGHT INBOARD AND OUTBOARD ELEVATOR CABLES IN AFT RIG BAY ARE WORN NEAR LIMITS. REPLACED RIGHT INBOARD AND OUTBOARD AFT ELEVATOR CABLES IAW EMB120 MM 27-00-01.SDR SWIA200110346Control Cable · wornLEFT INBOARD AND OUTBOARD ELEVATOR CABLES IN AFT RIG BAY ARE WORN NEAR LIMITS. REPLACED LEFT INBOARD AND OUTBOARD AFT ELEVATOR CABLES IAW EMB120 MM 27-00-01. P/N: 120-27655-017.SDR SWIA200110345Control Cable · wornRIGHT INBOARD RUDDER CABLE IN AFT RIGGING BAY IS WORN NEAR LIMITS. REPLACED RIGHT INBOARD AFT RUDDER CABLE IAW EMB120 MM 27-00-0.SDR SWIA200110338Control Cable · wornLEFT OUTBOARD RUDDER CABLE IN AFT RIGGING BAY IS WORN NEAR LIMITS. REPLACED LEFT OUTBOARD RUDDER AFT CABLE IAW EMB120 MM 27-00-01.SDR SWIA200110337Control Cable · wornRIGHT RUDDER INBOARD AND OUTBOARD CABLES FORWARD OF THE WING BOX IS WORN NEAR LIMITS. REPLACED RIGHT RUDDER INBOARD AND OUTBOARD CABLES FORWARD OF WING BOX IAW EMB120 MM 27-00-01.SDR SWIA200110336Control Cable · wornLEFT AILERON UPPER AND LOWER CABLES WORN ON WING. REPLACED LEFT UPPER AND LOWER AILERON CABLES IAW EMB120 MM 27-00-01.SDR SWIA200110335Control Cable · wornUPPER AND LOWER AILERON TRIM CABLES WORN ON RIGHT SIDE. REPLACED RIGHT UPPER AND LOWER AILERON TRIM CABLES IAW EMB120 MM 27-00-01.SDR SWIA200110334Control Cable · wornUPPER AND LOWER AILERON CABLES WORN AT INBOARD NACELLE FAIRLEADS, RIGHT SIDE. REPLACED RIGHT UPPER AND LOWER AILERON CABLES IAW EMB120 MM 27-00-01.SDR SWIA200110323Wire · damagedVENT VALVE WIRING LINE INSIDE FUEL TANK NEAR LEFT WING TIP HAS DAMAGE. REPLACED LEFT VENT VALVE WIRING LINE ASSY.SDR SWIA200110006Bleed Valve · malfunctionedSMELLED SMOKE ON TAKEOFF. RETURNED TO LAX. REPLACED LEFT ENGINE HIGH PRESSURE BLEED VALVE. RAN ENGINE. OPS CHECK GOOD. P/N: 979626-4-1, S/N ON: 2461, S/N OFF: 2020.SDR SWIA972508Annunciator · faultyFLAP DISAGREEMENT LIGHT ILLUMINATES AFTER FLAP RETRACTION. RETURNED FLAP HANDLE TO 15 DEGREES SETTING AND THEN SELECTED FLAPS UP. AGAIN DISAGREEMENT LIGHT REMAINED ILLUMINATED. FLAP POSITION INDICATOR DISPLAYS APPROX 2 DEGREES. REPLACED FLAP ANNUNCIATOR UNSDR SWIA972499Battery Pack · dischargedFIRST THREE ROWS OF EMERGENCY LIGHTS DO NOT ILLUMINATE. ALSO FORWARD EXIT SIGNS DO NOT ILLUMINATE. REPLACED FORWARD (NR 1) EMERGENCY LIGHT BATTERY PACK. GROUND CHECK NORMAL. P/N D366-04-001, S/N ON 883, S/N OFF 397.SDR SWIA972398Light · inoperativeLIGHT INSPECTION LEFT SIDE DOES NOT ILLUMINATE. ICING CONDITIONS EXIST AT DESTINATION. RETURNED TO LAX. REPLACED LEFT DEICE INSPECTION LIGHT BULB. OPS CHECK GOOD.SDR SWIA971735Transponder · inoperativeNUMBER ONE AND NUMBER TWO TRANSPONDER INOP. RETURNED TO LAX. PERFORMED OPERATIONAL CHECK ON ATC TRANSPONDER ONE AND TWO, FOUND NO PROBLEMS OR CODES. OPS CHECKS GOOD.SDR SWIA971721Fuel Filter · cloggedLEFT FUEL FILTER ILLUMINATED. RETURNED TO SFO. REPLACED HIGH AND LOW FUEL FILTER, OPS AND LEAK CHECK GOOD.SDR SWIA971216Annunciator · malfunctionedAT CRUISE, FLAP AND ADVANCED SWS MAP LIGHT ILLUMINATED WITH CONTROL FAULT LIGHT ON FLAP PANEL. UNABLE TO RESET. RETURNED TO LAX. REPLACED FLAP ANNUNICATOR, OPS CHECKS GOOD.
Back to N565SW, cancelled Apr 6, 2018