N720SW, cancelled Jan 22, 2014
Service difficulty reports · 74
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 = 'N720SW' AND deregistration_id = 'N720SW-2014-01-22' 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 = 'N720SW' AND deregistration_id = 'N720SW-2014-01-22' 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 COMA2009041350115Skin · crackedRT WING PLANK AT WS 148.019 JACKING POINT IS CRACKED. REMOVED DAMAGE AND INSTALLED PERMANENT REPAIR PARTS PER REO 601R-57-21-130 REV H.SDR COMA2009041350114Hinge Fitting · wornRUDDER ATTACH FITTING ON VERTICAL STAB CENTER BOTTOM HINGE BEARING HAS EXCESSIVE PLAY. REMOVED RUDDER CENTER LOWER HINGE FITTING, REMOVED AND REPLACED BEARING AND REINSTALLED FITTING PER EA 10-5531-02567.SDR COMA2009041350113Floorbeam · corrodedFLOORBEAM WEB AT FS 280 BETWEEN LBL 9 AND RBL 9 HAS CORROSION THAT IS OUT OF LIMITS. REMOVED DAMAGE AND INSTALLED A SERVICEABLE REPAIR TO FS 280 FLOORBEAM WEB PER COMAIR EA 10-5310-02557.SDR COMA2009010550053Bpsu · failedDURING APPROACH INTO AIRPORT, RECEIVED FLAPS FAIL CAUTION MSG. EMERGENCY DECLARED, ACFT DIVERTED LANDED SAFELY. REMOVED AND REPLACED LT BPSU.SDR COMA2008122350043Flap · malfunctionedON CLIMBOUT FROM JFK RECEIVED FLAPS FAIL CAUTION MSG, AT 8 DEG. EMERGENCY DECLARED, A/C RETURNED TO JFK LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW UP MAINTENANCE ACTION.SDR COMA0860387Connector · damagedEMERGENCY LIGHTS AFT OF ROW 8 WILL NOT ILLUMINATE. REPLACED LIGHT AFT OF ROW 8 AND REPLACED ASSOCIATED POWER CONNECTOR. NO FURTHER DEFECTS. (K)SDR COMA0860386Connector · malfunctionedEMERGENCY LIGHTS AFT OF ROW 8 WILL NOT ILLUMINATE. REPLACED LIGHT AFT OF ROW 8 AND REPLACED ASSOCIATED POWER CONNECTOR. NO FURTHER DEFECTS. (K)SDR COMA0960384Battery · dischargedFLOOR EMERGENCY LIGHTING AFT OF ROW 9 INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACK NR 4. (K)SDR COMA0860312Fuse · blownFLOOR TRACK EMERGENCY LIGHTING STRIP FROM ROW 9 AFT FAILED TO ILLUMINATE DURING TEST. REPLACED INTERNAL FUSE ON EMERGENCY LIGHT BATTERY CHARGER. (S)SDR COMA0860154Flap · failedFLIGHT 5478 - FLAPS FAIL CAUTION MESSAGE WHEN SELECTING FLAPS TO 8 DEGREES. EMERGENCY DECLARED. AIRCRAFT LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I0002, FLAPS FAIL CAUTION MESSAGE FOLLOW-UP MAINTENANCE ACTION.SDR COMA0860105Priority Valve · faultyFLIGHT 4957 - AFTER SELECTING GEAR UP, RECEIVED GEAR DISAGREE AND DOOR DISAGREE MESSAGES WITH MAIN GEAR UP, NOSE DOWN. REPLACED NOSE GEAR PRIORITY VALVE. NO FURTHER DEFECTS.SDR COMA0860104Selector Valve · faultyFLIGHT 4957 - AFTER SELECTING GEAR DISAGREE AND DOOR DISAGREE MESSAGES WITH MAIN GEAR UP, NOSE DOWN. REPLACED NOSE GEAR SELECTOR VALVE. NO FURTHER DEFECTS.
SDR COMA0760453Light · inoperativeFLIGHT 5523 - EMERGENCY FLOOR LIGHTING INOP BETWEEN SEATS 6 AND 8. REMOVED AND REPLACED EMERGENCY LIGHTING LAMP STRIP.SDR COMA0760346Flap · malfunctionedFLIGHT 5338 - FLAPS FAIL MESSAGE AT 30 DEGREES ON APPROACH, AIRCRAFT LANDED SAFELY. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3, (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGSDR COMA0760317Flap System · failedFLAPS FAIL MSG AT 30 DEGREES. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE (FIRST EVENT) MAINTENANCE ACTION, PARAGRAPH (G) 1,2,3, (A,B,C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.SDR COMA0760294Flap System · unknownFLIGHT 5186 - DURING CLIMBOUT OF CVG RECEIVED A FLAP FAIL MESSAGE, FLIGHT RETURNED TO CVG. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3, (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTIONSDR COMA0760141Flap System · malfunctionedFLIGHT 5304 - DURING DCA APPROACH RECEIVED A FLAP FAIL CAUTION MESSAGE. CREW DECLARED AN EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A, B, C). FLAP SSDR COMA0760086Flap System · malfunctionedFLIGHT 5103 - FLAP FAIL CAUTION MESSAGE AT 20 DEGREE FLAP SETTING. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3, (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.SDR COMA0760055Bpsu · faultyFLIGHT 5117 - FLAP FAIL CAUTION DESCENDING THROUGH FL 19, OAT -10. REPLACED RIGHT WING BPSU. NO FURTHER DEFECTS.SDR COMA0760054Control Handle · malfunctionedFLIGHT 5117 - FLAP FAIL CAUTION DESCENDING THROUGH FL 19, OAT -10. REPLACED FLAP LEVER ASSEMBLY. NO FURTHER DEFECTS.SDR COMA0760053Control Unit · faultyFLIGHT 5117 - FLAP FAIL CAUTION DESCENDING THROUGH FL 10, OAT -10. REPLACED FECU. NO FURTHER DEFECTS.SDR COMA0760037Flap · malfunctionedFLIGHT 5228 - FLAPS FAILED AT 8 DEGREES ON APPROACH. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3, (A, B, C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.SDR COMA0760032Unknown · malfunctionedFLIGHT 5438 - FLAPS FAIL CAUTION MESSAGE AT ZERO DEGREES ON TAXI OUT. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE "FIRST EVENT" MAINTENANCE ACTION, PARAGRAPH (G) 1,2,3, (A,B,C). FLAP SYSTEM WAS RESET WITH NO FURTHER FLAP CAUTION MESSAGES.SDR COMA0660403Spoiler Sys · malfunctionedFLIGHT 5531- ON TAKEOFF ROLL LESS THAN 10 KTS RECEIVED TAKEOFF CONFIG WARNING/SPOILERON FAULT ON LEFT AND RIGHT. RESET SPOILER SYSTEM PER FIM PG 105.SDR COMA0660401Secu · malfunctionedFLIGHT 5040 - SPOILERS FAULT STATUS MSG ON ED2. ABORTED TAKEOFF AND RETURNED TO GATE. RESET SECU 1 AND 2. STATUS MESSAGE CLEARED, SPOILER OPERATION NORMAL.SDR COMA0660398Control Unit · faultyFLIGHT 5726 - ON TAKEOFF ROLL RECEIVED CONFIG SPOILERS WARNING. REMOVED AND REPLACED SECU.SDR COMA0660397Control Unit · faultyFLIGHT 5726 - ON TAKEOFF ROLL, RECEIVED CONFIG SPOILERS WARNING. REMOVED AND REPLACED SECU.SDR COMA0660247Pump · faultyFLIGHT 5158 - EN ROUTE IAD-CVG RECEIVED A NR 1 HYDRAULIC LOW PRESSURE CAUTION MESSAGE, FLIGHT RETURNED TO THE FIELD. REPLACED THE NR 1 ENGINE DRIVEN HYDRAULIC PUMP.SDR SWIA200516193Angle · crackedFS 280 LBL8 BELOW FLOOR JOINING ANGLE CRACKED BETWEEN BEAM AND SUPPORT, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED BRACKET CLIP AT 280 LBL 8 PER REO 601R-53-11-136.SDR SWIA200516192Angle · crackedFS280 RBL 8 BELOW FLOOR JOINING ANGLE CRACKED BETWEEN BEAM AND SUPPORT. (ITEM FOUND AT C-CHECK INSPECTION.) INSTALLED ANGLE PER REO 601R-53-11-136 AT FS 280 RH.SDR SWIA200516191Panel · crackedLEFT MLG; BAT PANEL CRACKED AT BL45.00, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR PARTS IAW REO 601R-57-51-046.SDR SWIA200516190Panel · crackedRIGHT MLG; BAT PNL CRACKED AT BL45.00, ITEM FOUND AT C-CHECK INSPECTION. INSTALLATION OF ANGLE DOUBLER PER REO 601R-57-51-046 REV 'B' SHEET 4 OF 6 RT BAT ANGLE.SDR SWIA200516189Floorbeam · crackedCRACKED ANGLE FS 625 WL80 LBL37, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLE PER CRJ200 SRM 51-42 PG 17 PART FS 625 WL 80 LBL37.SDR SWIA200516188Floorbeam · crackedCRACKED ANGLE FS 625 WL80 RBL37 ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLE PER CRJ200 SRM 51-42-21 PG 19 AND CRJ200 51-74-00 AT FS 625 WL 80 RBL 37.SDR SWIA200516187Intercostal · cracked(2 EA) CRACKED INTERCOSTAL FS 625 WL80 AND WL90 LBL40, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED PER CRJ200 SRM 51-77-00 PG 1 STEPS 1-4; 51-42-06 PG 11; AND 51-42-21 PG 17.SDR SWIA200515588Actuator · malfunctionedSTAB TRIM CH 1 INOP. REPLACED HSTA AND MCU IAW 27-42-01 AND 27-42-05. OPERATIONAL CHECK GOOD, PN 7062-3 SN/OFF 795.SDR SWIA200515531Trim System · malfunctionedSTAB TRIM CHANNEL 1 OCCASIONALLY WILL NOT ENGAGE. REPLACED HSTCU IAW MM 27-41-01. OPERATIONAL CHECK GOOD.SDR SWIA200515337Handle · out of adjustMAIN CABIN DOOR HARD TO OPEN. ADJUSTED PAX DOOR INNER LEVER TO OUTER HANDLE MECHANISM IAW MM 52-11-0. OPERATIONAL CHECK GOOD.SDR SWIA200515191Trim Switch · malfunctionedCAPTAIN'S TRIM SWITCH STICKING. REPLACED CAPTAIN'S TRIM SWITCH IAW MM 27-41-00. OPERATIONAL CHECK GOOD.SDR SWIA200515090Lamp · burned outOVERHEAD EMERGENCY LIGHT IN CABIN INOPERATIVE. RELAMPED OVERHEAD FWD EMERGENCY LAMP. OPERATIONAL CHECK GOOD.SDR SWIA200515045Control Unit · malfunctionedRECEIVED FLAPS HALF SPEED. REPLACED FECU IAW 27-57-05. OPERATIONAL CHECK GOOD. P/N 860D100-18ABCD, S/N OFF 741.SDR SWIA200514614Pcu · malfunctionedSPOILERONS FAULT MESSAGE ON TAXI OUT. REMOVED AND REPLACED LEFT SPOILERON OUTBOARD PCU IAW AMM 27-62-01. OPERATIONAL CHECK IAW AMM 27-64-00 GOOD.SDR SWIA200414066Light · inoperativeTHIRD EMERGENCY FLOOD LIGHT ON CEILING INOPERATIVE. RELAMPED 3RD EMERGENCY FLOOD LIGHT. OPERATIONAL CHECK GOOD.SDR SWIA200413983Switch · stuckCLIMBING OUT OF FCA CO-PILOTS STAB TRIM SWITCH RAN AWAY TO A VALUE OF 1.0 NOSE DOWN WITH NO RESPONSE WHEN TRIMMING TO THE NOSE UP POSITION. REPLACED CO-PILOTS STAB TRIM SWITCH P/N 309-4334. OPERATIONAL CHECK GOOD IAW 27-41-05.SDR SWIA200413451Attach Angle · crackedCARGO PIT TRANSVERSE BEAM TO LANDING PLATE ATTACH CLIP FOR STOP FITTING IS CRACKED, FS 605.00, LBL 43.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIP IAW CRJ SRM 51-40-11, 51-42-06, 51-23-00, 51-42-21, 51-41-02, 51-41-04, 51-21-11 & 51-25-16.SDR SWIA200413450Plate · brokenCARGO PIT STEP PLATE ASSEMBLY SUPPORT IS BROKEN OUT ALONG INBOARD SIDE. DISCOVERED DURING C-CHECK INSPECTION. SUPPORT REPLACED IAW CRJ SRM 51-41-02.SDR SWIA200413302Support Beam · crackedENGINE SUPPORT BEAM LOWER WEB RBL 38 CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED WEB IAW CRJ REO 601R-53-61-366, REV ''D''.SDR SWIA200413301Support Beam · crackedENGINE SUPPORT BEAM UPPER WEB RBL 6.0 CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED UPPER AND LOWER WEBS OF ENGINE SUPPORT BEAM IAW CRJ REO 601R-53-61-345 REV ''C''.SDR SWIA200413300Intercostal · crackedFUSELAGE PULLEY INTERCOSTAL HAS OUTBOARD RETURN FLANGE CRACKED AT FS 484.00 RBL 36.0. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-41-059 REV ''A''.SDR SWIA200413299Intercostal · crackedFUSELAGE PULLEY INTERCOSTAL HAS I/B AND O/B ANGLES CRACKED AT FS 484.00 LBL 27.0 AND 36.0. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-41-059 REV ''A'' .
Back to N720SW, cancelled Jan 22, 2014