N579SW, cancelled Mar 3, 2017
Service difficulty reports · 112
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 = 'N579SW' AND deregistration_id = 'N579SW-2017-03-03' 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 = 'N579SW' AND deregistration_id = 'N579SW-2017-03-03' 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 SWIA200921733Light · inoperativeFLOOR EMERGENCY LIGHT AT ROW NINE INOP. (FLT 6316) RELAMPED FLOOR EMERGENCY LIGHT.SDR SWIA200921678Connector · dirtyFLT 6309 - LOSS OF ENGINE TORQUE ON CLIMB. CLEANED AND RESECURED EEC INPUT SENSOR CONNECTOR.SDR SWIA200921082Strut · seizedFLT 5730 - MAIN LANDING GEAR WOULD NOT RETRACT. REPLACED MAIN DRAG AND LOCKING STRUT P/N, 20945-001-03 S/N ON, 631 S/N OFF: B48.SDR SWIA200921081Actuator · failedFLT 5758 - RIGHT MAIN LANDING GEAR WOULD NOT RETRACT. REPLACED UPLOCK ACTUATOR, P/N 20885 S/N OFF: 236.SDR SWIA200921803Support · crackedC-CHECK, SUPPORT FOR FORWARD END OF FLAP ACTUATOR CRACKED. REPLACED PER SRM.SDR SWIA200921801Floorbeam · crackedC-CHECK, CARGO DOOR ENTRANCE FLOORBEAM CRACKED. REPAIRED WEB PER SRM.SDR SWIA200921802Bracket · crackedC-CHECK, FRAME BRACKET UNDER THE FLOORBOARD OF PASSENGER DOOR CRACKED. REPLACED FRAME PER SRM.SDR SWIA200921800Stringer · crackedC-CHECK, LEFT WING STRINGERS CRACKED. REPAIRED PER SRM.SDR SWIA200921799Stringer · crackedDURING C-CHECK, RIGHT INBOARD WING STRINGERS CRACKED. REPAIRED PER SRM.SDR SWIA200920886Target · out of adjustFLT 5591 - FORWARD LEFT DOOR ON RIGHT MAIN GEAR DID NOT CLOSE, RIGHT MAIN GEAR DISAGREEMENT LIGHT ON. ADJUSTED TARGETS.SDR SWIA200820770Door · lack of lubeFLT 5408 - MAIN CABIN DOOR HARD TO OPEN. CLEANED AND LUBED CABIN DOOR.SDR SWIA200819780Fuel Control · odorFUEL SMELL REPORTED IN THE CABIN WHEN APU BLEED IS ON. REPLACED APU FUEL CONTROL UNIT WITH SERVICEABLE UNIT. OPS CHECK GOOD.SDR SWIA200819449Sign · brokenFLT 5478 - EMERGENCY EXIT SIGN AT SEAT 6A IS BROKEN. REPLACED BROKEN SIGN.SDR SWIA200819173Handle · lack of lubeFLT 5753 - MAIN CABIN DOOR IS DIFFICULT TO OPEN. LUBED PAX DOOR HANDLE. OPS CHECK GOOD.
SDR SWIA200819038Connector · odorELECTRICAL BURNING ODOR IN CABIN.REPLACED FORWARD HOT JUG PLUG. OPS CHECK GOOD.
SDR SWIA200718558Connector · looseCREW REPORTS HOT PLASTIC ODOR FROM RIGHT RCCB PANEL. TIGHTENED TERMINAL TO PROP HEAT RCCB CONNECTOR. OPS CHECKS GOOD.SDR SWIA200718436Frame · crackedPAX DOOR CENTER FORWARD FRAME IS CRACKED, DISCOVERED AT C-CHECK. REPLACED CENTER FORWARD FRAME IAW SRM 51-40-02, PN 120-21058-003.SDR SWIA200718435Frame · corrodedPAX DOOR FORWARD UPPER CORNER FRAME IS CORRODED, DISCOVERED AT C-CHECK. REPLACED FORWARD CORNER FRAME WITH NEW PART IAW EMB 120 SRM 51-40-02, P/N 120-26550-001.SDR SWIA200718193Connector · disconnectedFORWARD FLOOR EMERGENCY LIGHTS ARE INOP. RECONNECTED FORWARD EMERGENCY LIGHT STRIP CONNECTOR.SDR SWIA200616659Servo · malfunctionedTRIM LIGHT ON CAPT AUTOPILOT FCP ILLUM IN FLIGHT WHEN AUTOPILOT SELECTED ON CAPT SIDE WITH A RED TRIM FAIL LIGHT AND AURAL WARNING. REPLACED PITCH TRIM SERVO, OPERATIONAL CHECK GOOD IAW EMB 120 22-10-00.SDR SWIA200616585Door · lack of lubeMAIN CARGO DOOR IS VERY HARD TO OPEN AND CLOSE. LUBRICATED CABIN DOOR AND CHECKED OPERATION, CLOSES AND OPENS EASIER.SDR SWIA200616207Servo · malfunctionedFLIGHT DIRECTOR FLAGS BOTH SIDES. REPLACED ELEVATOR PITCH SERVO IAW MM 22-10-05. OPERATIONAL CHECK GOOD IAW MM 22-10-00.SDR SWIA200616185Selector · bindingFLAP SELECTOR LEVER BINDS COMING FROM DOWN TO UP POSITION. REPLACED FLAP HANDLE. OPERATIONAL CHECK GOOD.SDR SWIA200515919Actuator · malfunctionedELEVATOR TRIM WHEEL IS EXTERNALLY DIFFICULT TO MOVE. REPLACED RT ELEVATOR TRIM TAB ACTUATOR IAW EMB 120 MM 27-32-02. OPERATIONAL CHECK GOOD.SDR SWIA200515977Frame · crackedPILOT'S FLOOR PROP CRACKED AT FRAME 13, ITEM FOUND AT C-CHECK INSPECTION. SPLICED IN REPLACEMENT SECTION OF FRAME NR 13 FLOOR SUPPORT COLUMN (PILOT'S SIDE) PER EMB120 SRM 53-10-10 PG 214-220.SDR SWIA200515976Seat Track · corrodedLT AFT SEAT TRACK CORRODED FROM GALLEY TO SEAT 10A, ITEM FOUND AT C-CHECK INSPECTION. REMOVED AND INSTALLED SERVICEABLE LT AFT SEAT TRACK FROM GALLEY TO SEAT 10A.SDR SWIA200514791Rod End · out of adjustMAIN CABIN DOOR VERY HARD TO OPEN & CLOSE. ADJUSTED 2 ROD ENDS AND LUBRICATED ALL MOVING PARTS AS NECESSARY. DOOR NOW OPERATIONALLY CHECKS GOOD.SDR SWIA200414319Odor · detectedAFTER SHUTDOWN, VISIBLE SMOKE COMING FROM F/O'S CONSOLE AREA. OPERATED APU AS REQUIRED WITH ALL ELECTRICAL SYSTEMS AVAILABLE ON APU GENERATOR AND FOUND NO EVIDENCE OF SMOKE. OPERATED BOTH ENGINES AS REQUIRED WITH ALL ELECTRICAL SYSTEMS AVAILABLE WITH MAIN GESDR SWIA200413787Fuse · burned outAFT EMERGENCY LIGHTS INOPERATIVE. REPLACED FUSE FOR EMERGENCY LIGHTS. OPERATIONAL CHECK GOOD.SDR SWIA200413551Control Panel · malfunctionedCOULD NOT CLEAR STALL LIGHT ON SYS 1, IT TOOK NUMEROUS ATTEMPTS TO CLEAR SYS 2. REMOVED AND REPLACED STALL WARNING PANEL. OPERATIONAL CHECK GOOD. P/N 120-34428-505.SDR SWIA200413409Servo · malfunctionedCREW REPORTED ROUGH FEEL IN ELEVATOR CONTROL. REMOVED AND REPLACED ELEVATOR SERVO REF AMM 22-10-05. OPERATIONAL CHECK GOOD.SDR SWIA200413226Fire Loop · inoperativeNR 2 ENGINE DETECTOR INOP. ENGINE WHEEL WELL LIGHT ILLUMINATED. REMOVED NR 2 ENGINE FIRE LOOP AND REPLACED WITH A SERVICEABLE LOOP IAW MM 26-21-01. OPS CHECK GOOD. P/N 3601-75-450/160C.SDR SWIA200413121Servo · faultyRATCHETING NOISE HEARD WITH SLIGHT NOTCH FEELING WHEN YOKE IS MOVED TO FULL AFT POSITION. MOVED YOKE THROUGH TRAVEL WITH A/P ON, SEEMED TO CLEAR PROBLEM. REPLACED AUTOPILOT ELEVATOR SERVO. OPS CHECK GOOD IAW MM 22-10-00.SDR SWIA200412990Sign · brokenEMERGENCY EXIT LIGHTED PLACARD RIGHT FORWARD DOOR IS BROKEN. REMOVED AND REPLACED EXIT SIGN AT FORWARD DOOR. OPS CHECK GOOD.SDR SWIA200412805Computer · malfunctionedON TAXI OUT, SELECTED AP TO F/O. RECEIVED AP FAIL LIGHT ON MAP AND ASSOCIATED AP DIS & AP ON FCP. REPLACED F/O'S AP COMPUTER. OP CHECKS GOOD.SDR SWIA200312755Sign · missingEXIT ROW 6 EXIT LIGHT MISSING. REMOVED AND REPLACED EXIT ROW LIGHT WITH A NEW ASSEMBLY IAW 33-00-00. OPS CHECK GOOD.SDR SWIA200312735Gcu · malfunctionedON LANDING, SMOKE ODOR IN COCKPIT, EVIDENCE OF SMOKE FROM RIGHT DC RELAY BOX. WIRE FROM BUSS TIE 2 CONTACTOR TO RCCB BUS BAR AND BUSS TIE 2 CONTACTOR SHOW SIGNS OF OVERHEATING. REMOVED AND REPLACED NR 2 BUSS TIE CONTACTOR AND CABLE IAW WM 24-35-00. REPLACEDSDR SWIA200312465Battery Pack · malfunctionedEMERGENCY LIGHTS WOULD NOT TEST CORRECTLY IN EKO FROM ROW 9 BACK WOULD NOT LIGHT UP. LET SYSTEM CHARGE 10 MIN AND THEY TESTED OK. FLOOR LEVEL EMERGENCY LIGHTS ON LAST THREE ROWS (9, 10, 11) INTERMITTENT. REMOVED AND REPLACED NR 3 ELBP IAW MM 33-50-02. OPS CHSDR SWIA200312295Connector · dirtySTALL TEST FAILS TEST, NO PUSHER. CLEANED CANNON PLUG ON 'G' SWITCH AND OPS CHECKS GOOD.SDR SWIA200312296Switch · defectiveAUTOPILOT WILL NOT TEST. AMBER 'R' ON PEDISTAL PANEL. REPLACED FIRST OFFICER'S AP DISCONNECT SWITCH AS REQUIRED. SYSTEM OPS CHECK GOOD IAW 22-10-00.SDR SWIA200312176Blade · crackedRT ENGINE NR 3 PROP BLADE HAS APPROX .375 INCH CRACK ON TRAILING EDGE. DISCOVERED DURING LINE INSPECTION. REMOVED AND REPLACED R-3 PROP BLADE IAW MM 61-13-04.SDR SWIA200311981Connector · contaminatedPILOT REPORTS ON TAKE OFF, GEAR WOULD NOT RETRACT UNLESS OVER-RIDDEN, ALSO BOTH FLIGHT - IDLE UNLOCK LIGHT CAME ON AND WOULD GO OUT 3-6 MINS INTO FLIGHT.INSPECTED ALL GEAR PROX SENSORS AND CANNON-PLUG CONNECTIONS, FOUND LT MAIN LANDING GEAR WOW PROX SENSOR CONSDR SWIA200211283Hmu · malfunctionedEXPERIENCED THREE HOT STARTS ON THE LEFT ENGINE. FOLLOWED STARTER/GEN DUTY CYCLE LIMITS. FUEL FLOW PEAKED AT 150 PPH. REPLACED LEFT ENGINE HMU FUEL CONTROL AND FUEL PUMP IAW 73-22-00 & 73-14-00 . LEFT ENGINE OPS & LEAK CHECKS GOOD.SDR SWIA200210928Computer · malfunctionedON CLIMBOUT, RECEIVED FLAP AND DISAGREEMENT CAUTION LIGHTS, OUTBOARD PAIR. QRH PROCEDURE CORRECTED FAULT. REMOVED AND REPLACED THE FLAP CONTROL COMPUTER. OPERATED THE FLAPS. NO FURTHER PROBLEM NOTED AT THIS TIME.SDR SWIA200210851Roller · wornRECEIVED FLAP DISAGREEMENT MESSAGE WHILE CLIMBING OUT OF SUN. USED QRH TO FIX. REMOVED AND REPLACED ALL FLAP ROLLERS ON BOTH INBOARD FLAPS IAW EMB 120 MM 27-50-12. RAN FLAPS UP & DOWN SEVERAL TIMES. OPS CHECKS GOOD.SDR SWIA200210842Annunciator · false indicationFLAPS WOULD NOT FULLY RETRACT IN FLIGHT. DISAGREEMENT BETWEEN OUTBOARD PAIR. CHECKED ON GROUND AND GOT DISAGREEMENT BETWEEN INBOARD PAIR. PERFORMED SEVERAL FLAP CYCLES AND GOT ANNUNCIATOR TO FAIL. REPLACED ANNUNCIATOR WITH SERVICEABLE UNIT. OPERATED FLAPSSDR SWIA200210758Outflow Valve · failedAIRCRAFT WOULD NOT PRESSURIZE AFTER TAKEOFF. REMOVED AND REPLACED ELECTRO PNEUMATIC OUTFLOW VALVE. OPS CHECKS GOOD.SDR SWIA200210715Smoke · detectedSMOKE IN THE COCKPIT, CENTER PILLAR AREA, NOT ASSOCIATED WITH THE FANS. RETURNED INSPECTED ALL EFDS, RADAR DISPLAYS, WINDSHIELD HEAT WIRING, FMS AND ASSOCIATED WIRING. NO DEFECTS NOTED. PERFORMED MAINTENANCE TEST FLIGHT. OPS CHECK GOOD.SDR SWIA200210707Wire · brokenEMERGENCY LIGHT AT SEAT 6A INOP. REPAIRED BROKEN GROUND WIRE IAW WIRING MANUAL 20-00-00. OPS CHECK GOOD.SDR SWIA200210572Control Unit · malfunctionedAFTER TAKEOFF DURING FLAP RETRACTION, FLAP LIGHT ON MAP WITH DISAGREEMENT ON OUTBOARD PAIR. APPLIED QRH PROCEDURE, NO HELP. RETURNED TO SLC. CLEANED GLYCOL FROM ACTUATOR CANNON PLUGS, REPLACED FLAP CONTROL UNIT AND REPLACED RIGHT OUTBOARD FLAP ROLLERS (4).
Back to N579SW, cancelled Mar 3, 2017