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 SWIA200413298Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 ATTACH ANGLE CRACKED. DISCOVERED DURING C-CHECK INSPECTION. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-23-00, 51-21-11SDR SWIA200412929Control Unit · malfunctionedSPOILERON FAULT STATUS MESSAGE. REMOVED AND REPLACED NR 1 SECU IAW CRJ MM 27-61-05 AND LEFT INBOARD SPOILERON PCU IAW CRJ MM 27-62-01. OPS CHECK GOOD. PCU P/N: 27000-7, S/N OFF: MAL-4191.SDR SWIA200312703Selector Valve · malfunctionedUPON GEAR RETRACTION, RECEIVED GEAR DISAGREE AND NOSE DOOR OPEN WARNING MESSAGES. FOLLOWED QRH. GEAR EXTENDED NORMALLY. RETURNED TO AIRPORT. REMOVED AND REPLACED NLG SELECTOR VALVE IAW 32-33-10. OPS CHECK GOOD IAW 32-33-10.SDR SWIA200312536Rod End · excess playRUDDER PEDAL VIBRATION FELT IN LEFT AND RIGHT INPUTS DURING CLIMB TO FL200 AND IN ROUGH AIR. ALSO FELT IN SMOOTH AIR BELOW FL200. FOUND NR 1 RUDDER ACTUATOR ROD END WITH EXCESSIVE PLAY. REPLACED NR 1 ACTUATOR ROD END BOLT AND BUSHING IAW MM 27-24-01. OPS CSDR SWIA200312272Actuator · failedPITCH FEEL CB POP OUT IN FLIGHT CH NR 1. REMOVED AND REPLACED NR 1 ACTUATOR-LINEAR IAW MM 27-31-23. OPS CHECKS GOOD.SDR SWIA200312199Handle · defectiveCOCKPIT EMERGENCY EXIT HATCH EXTENSION HANDLE WILL NOT STOW. REMOVED AND REPLACED FLIGHT DECK EMERGENCY HATCH EXTENSION HANDLE ASSEMBLY IAW CMM 52-22-03.SDR SWIA200312145Control Unit · malfunctionedCH 1 STAB TRIM DOES NOT TEST. STAB AND MACH TRIM DISENGAGE WITH NO MOVEMENT OF TRIM. REMOVED AND REPLACED MOTOR CONTROL UNIT & HORIZONTAL STAB ACTUATOR. OPS CHECKS GOOD IAW MM 27-40-00. ACT P/N: 8396-3, S/N ON: 569, S/N OFF: 494.SDR SWIA200211448Switch · malfunctionedON CLIMB OUT OF SLC, RECEIVED STAB TRIM & MACH TRIM CAUTION MESSAGES . RAN QRH, COULD NOT GET TRIM ENGAGED. AFTER REPEATED ATTEMPTS, GOT CH 2 ENGAGED. RETURNED TO SLC. REMOVED FO'S DISCONNECT SWITCH, CLEANED AND REINSTALLED PER MM 27-41-30. OPS CHECK SYSTSDR SWIA200211436Circuit Board · malfunctionedSTAB TRIM CHANNELS 1 AND 2 WILL NOT ENGAGE.REMOVED AND REPLACED NR 1 FCC CARD IAW 22-10-14. OPS CHECK GOOD.PN OFF/ON 622-9815-704 SN OFF 4X1A SN ON337.SDR SWIA200211431Firewall · crackedLT PYLON LOWER FIRE BOX PANEL (412 DB) HAS A CRACK IN ITS FORWARD DIVIDER. FOUND DURING C CHECK INSPECTION. REPLACED DIVIDER IAW CRJ SRM 51-42-06.SDR SWIA200211430Clip · crackedFS 484.0 LBL 27.0 INTERCOSTAL CLIP CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALLED NEW CLIP IAW CRJ REO 601R-53-41-059 REV. ''A''.P/N: 601R-31171-17SDR SWIA200211429Floor Panel · crackedELECTRICAL BAY FLOOR FS 193.00 RT CRACKED. FOUND DURING C CHECK INSPECTION. REPAIRED DAMAGE IAW CRJ REO 601R-53-11-245 REV. ''NC''. HFEC INSPECTION C/O ON CUTOUT AS REQUIRED IAW REO 601R-53-11-245. NO CRACKS FOUND.SDR SWIA200211428Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM ANGLES IB & OB CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALL NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21. P/N: 601R31113-58SDR SWIA200211427Floorbeam · crackedFS 280 LBL 9.0 FLOORBEAM IB ANGLE CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALLED NEW ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21.SDR SWIA200211426Fitting · crackedFS 718 LT AND RT PYLON FITTING TIE ANGLES CRACKED. FOUND DURING C CHECK INSPECTION. NEW TIE ANGLE FIT AND INSTALLED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21.P/N: 600-36030-31SDR SWIA200211425Floor Support · crackedFS 621 (LT AND RT) FLOOR SUPPORT ANGLES CRACKED. FOUND DURING C CHECK INSPECTION. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-117 REV ''A''.ANGLE P/N: 601453-61-117-3 FLOOR ANGLE P/N: 601R53-61-117-1SDR SWIA200211424Intercostal · crackedFS 625.0 STR 14 INTERCOSTAL ANGLES (L&R) CRACKED. FOUND DURING C CHECK INSPECTION.FIT AND INSTALLED NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-06.SDR SWIA200211155Oil Cooler · faultyAPU OIL TEMP INDICATION ILLUMINATED IN FLIGHT (20,000). RETURNED TO PHX. REPLACED APU OIL COOLER. OPS & LEAK CHECK GOOD.SDR SWIA200211031Selector Valve · malfunctionedNOSE GEAR DID NOT GO DOWN & LOCKED AFTER EXTENDING GEAR. ALSO RECEIVED GEAR DISAGREE WARNING MESSAGE. RECYCLED ONCE AND IT EXTENDED NORMALLY. REMOVED AND REPLACED NOSE LANDING GEAR SELECTOR VALVE IAW CRJ MM 32-33-10. OPS AND LEAK CHECK GOOD.SDR SWIA200210841Switch · faultySTAB TRIM NR 1 & NR 2 WILL NOT REMAIN ENGAGED IN FLIGHT. MACH TRIM INOP. A/C RETURNED TO SLC FOR LANDING. REMOVED AND REPLACED NR 1 STAB TRIM DISCONNECT SWITCH.SDR SWIA200210711Switch · looseCAPTAIN'S SIDE POST MAP LIGHT WAS SPARKING WITH AN ASSOCIATED ELECTRICAL FIRE SMELL WHEN LIGHT WAS MANIPULATED. IF THE LIGHT CASING WAS NOT MOVED, NO NOTED ABNORMALITIES. FOUND SWITCH TO BE LOOSE AND TIGHTENED THE JAM NUT ON THE SWITCH TO RESTORE IT TO NORMASDR SWIA200210595Adc · malfunctionedAIR DATA COMPUTER ON FIRST OFFICER'S SIDE FAILED WHILE EN ROUTE. ONCE ON THE GROUND PROBLEM SEEMED TO CLEAR. SUSPECT MOISTURE IN THE PITOT STATIC SYSTEM. REMOVED AND REPLACED NR 2 ADC. OPS CHECKS GOOD IAW 34-13-00.SDR SWIA200110466Autopilot Sys · malfunctionedAIRCRAFT DISPLAYED DUTCH ROLL TENDENCIES AT FL330 AT .77 MACH. OSCILLATED 1-2 DEGREES LEFT AND RIGHT WITH 3-4 SECONDS INTERVALS, SKID INDICATOR MOVED APPROXIMATELY 1/8 LENGTH LEFT AND RIGHT. TROUBLESHOT THE SYSTEM IAW MM 22-22-01 AND 22-22-04. EVERYTHING CHSDR SWIA200110429Controller · failedAFTER TAKEOFF L-PITOT HEAT CAUTION MESSAGE. RETURNED TO SLC. REMOVED AND REPLACED LEFT AIR DATA SENSOR HEATER CONTROLLER IAW 30-41-00. LEFT PITOT HEAT OPS CHECK GOOD.
Back to N720SW, cancelled Jan 22, 2014