N410SW, cancelled Jun 8, 2017
Service difficulty reports · 141
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 = 'N410SW' AND deregistration_id = 'N410SW-2017-06-08' 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 = 'N410SW' AND deregistration_id = 'N410SW-2017-06-08' 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 SWIA200312063Sill · corrodedSERVICE DOOR SILL PLATE CORRODED. DISCOVERED DURING C-CHECK. DAMAGE FOUND TO BE OUT OF LIMITS. REPLACED SERVICE DOOR SILL PLATE WITH NEW PART IAW CRJ SRM 51-40-11.SDR SWIA200312062Skin · crackedFS 235 FUSELAGE SKIN LBL 6.0 NLG CUTOUT CRACKED. DISCOVERED DURING C-CHECK. DAMAGE REPAIRED IAW CRJ REO 601R-3-11-048 REV B.SDR SWIA200312061Skin · crackedFS 235 FUSELAGE SKIN RBL 6.0 NLG CUTOUT CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-048 REV B.SDR SWIA200312060Floorbeam · crackedFS 280 PILOT'S BULKHEAD LBL 90 AFT FLOOR ANGLE CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-138 NC.SDR SWIA200312059Floor Panel · crackedFS 193 ELECTRICAL BAY RT FLOOR CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGE IAW CRJ REO 601R-53-11-245 REV NC.SDR SWIA200211488Controller · malfunctionedAFTER TAKEOFF WE RECEIVED RIGHT AOA HEAT, R STATIC HEAT, R PITOT HEAT AND TAT PROBE HEAT CAUTION MESSAGES. RETURNED TO SLC. REMOVED AND REPLACED THE RIGHT SIDE AIR DATA SENSOR CONTROLLER. SYSTEM OPS CHECKS GOOD.SDR SWIA200210892Fire Loop · chafedRECEIVED RIGHT 14TH STAGE DUCT LEAK WARNING CLIMBING THROUGH 7000 FT. AS PER QRH, RETARDED RIGHT ENGINE THRUST TO IDLE. AFTER 40 SECONDS STILL HAD THE WARNING. CLOSED THE RIGHT 14TH STAGE BLEED AND WARNING CLEARED. RETURNED TO OMA. FOUND 14TH STAGE LOOP TSDR SWIA200210858Check Valve · malfunctionedLEFT PACK FAILED INFLIGHT. RIGHT PACK DEFERRED. PERFORMED EMERGENCY DESCENT PROCEDURE PER QRH. LEFT PACK HEAT EXCHANGER CHECK VALVE HINGE AND SPRING WORN. REMOVED AND REPLACED CHECK VALVE (FAN BYPASS) PER MM 21-52-07. LEFT PACK OPS OK. P/N: 350023000.SDR SWIA200210772Filter · dirty''DISPLAY COOL'' CAUTION MESSAGE DURING FLIGHT. MESSAGE PERSISTED AFTER 1ST STEP PER QRH. MESSAGE WENT AWAY AFTER SWITCHING TO STBY. RETURNED TO SLC. REMOVED AND REPLACED THE DISPLAY FILTER AS REQUIRED. OPS CHECK GOOD. PN 196305.SDR SWIA200210621Warning System · malfunctionedGEAR DISAGREE ON TAKEOFF. NOSE GEAR WOULD NOT COME UP. INSPECTED NOSE GEAR TORQUE LINKS, PROX SWITCHES AND STEERING. NO DEFECTS NOTED. JACKED A/C NOSE, SWUNG NOSE LANDING GEAR WITH NO DEFECTS NOTED. GEAR OPS CHECK GOOD.SDR SWIA200210594Landing Gear · malfunctionedNOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. CREW NOTED CHUNK OF ICE FELL FROM GEAR WHEN DOORS OPENED. PERFORMED NOSE GEAR RETRACTION TEST PER MM 32-30-00. NO DISCREPANCIES NOTED.SDR SWIA200110416Power Cable · contaminatedCABIN FLOOR EMERGENCY LIGHT FWD SECTION INOP. FOUND ONE LAMP SECTION BAD. REPLACED LAMP. FOUND POWER CABLE FOR FLOOR LIGHT WET AND SHORTING. DRIED FLOOR. DRIED POWER CABLE. OPS CHECKED GOOD.SDR SWIA200110391Warning System · malfunctionedAFTER TAKEOFF DURING GEAR RETRACTION NOSE GEAR FAILED TO RETRACT AND WAS ACCOMPANIED BY GEAR DISAGREE AND NOSE DOOR OPEN MESSAGES WITH GEAR INDICATION SHOWING BOTH MAINS WHITE AND THE NOSE YELLOW. RETURNED TO THE AIRPORT. PERFORMED LANDING GEAR OPERATIONAL CSDR SWIA200110374Socket · faultyEMERGENCY LIGHTS ARE ON WITH THE SWITCH IN ARMED POSITION. REMOVED AND REPLACED EMERGENCY EXIT LIGHT REFLECTOR AND SOCKET ASSEMBLY AFT OF RT OVERWING EMERGENCY EXIT DUE TO FAULTY CONTACTOR IAW MM 33-51-21. EMERGENCY EXIT LIGHTING SYSTEM OPERATIONAL AND FUNCSDR SWIA200110351Beam · crackedENGINE PYLON BOX BEAM UPPER WEB HAS 2 CRACKS AT LBL 8.0 AND RBL 7.5, RADIATING FWD FROM TRAILING EDGE OF BEAM. CARRY OUT REPAIRS TO LOWER BOX BEAM WEB IAW REO 601R-53-61-345 AND 601R-53-61-368. CARRY OUT REPAIRS TO UPPER BOX BEAM WEB IAW REO 601R-53-61-442. SDR SWIA200110350Beam · crackedENGINE PYLON BOX BEAM LOWER WEB CRACKING FROM ANCHOR NUTS AT STRESS PANEL FS 640 LEFT AND RIGHT SIDES. REPAIRS ACCOMPLISHED IAW REO 601R-53-61-366, LEFT AND RIGHT SIDES OF BOX BEAM. HFEC INSPECTION CARRIED OUT IAW REO 53-61-366. NO CRACKS FOUND.SDR SWIA200110349Bolt · corrodedRIGHT WING TRAILING EDGE NEAR AILERON POSITIONING TRANSMITTER HAS 3 CORRODED BOLTS. NEW HARDWARE INSTALLED IAW CRJ MM 27-15-01.SDR SWIA200110200Proximity Switch · out of adjON TAKEOFF, HAD A CARGO DOOR CAUTION MESSAGE. PERFORMED ADJUSTMENT/TEST OF CARGO DOOR PROX SWITCHES PER CRJ MM 52-70-02. OPS CHECK FOUND GOOD.SDR SWIA972632Switch · failedSTAB TRIM CH NR 1 & 2 AND MACH TRIM ALL DISENGAGED SHORTLY AFTER TAKE OFF, RETURNED FOR LANDING. INSTALLED NEW STAB TRIM DISCONNECT SWITCH ON FIRST OFFICER'S SIDE. PN 996-0013. OPS CHECK GOOD, OK FOR CAT II OPERATIONS.SDR SWIA972603Warning System · activatedON TAKEOFF ROLL ABOVE APPROXIMATELY 90 PERCENT N1, HAD A RED WARNING MESSAGE CONFIG AILERON AND CONFIG TRIM WITH AURAL WARNING. TRIM WAS IN THE GREEN. ABORTED TAKEOFF. PERFORMED OPS CHECK IAW AMM 31-41-00. RAN ENGINES ABOVE 70 PERCENT N1 AND HAD (T/O CONFSDR SWIA972552Windshield · crackedLEFT WINDSHIELD CRACKED. REMOVED AND REPLACED LT SIDE WINDOW (WINDSHIELD) IAW CRJ MM 56-12-01. PRESSURIZED AIRCRAFT TO 3.0 PSI. OPS LEAK CHECK OF WINDOW CHECKS GOOD. P/N ON 601R33033-11, S/N ON 0145H9919, S/N OFF 601R33033-3, S/N OFF 95039H2892 NP-139322SDR SWIA972501Control Unit · contaminatedSTAB TRIM CHANNEL 2 WILL NOT ENGAGE. WITH STAB TRIM CHANNEL 1 ENGAGED, THE MACH TRIM WILL NOT ENGAGE. REMOVE AND REPLACE MOTOR CONTROL UNIT (MCU) HORIZONTAL STABILIZER TRIM ACTUATOR IAW 27-42-01. FOUND HORIZONTAL STABILIZER CONTROL UNIT (HSTCU) WET WITH WASDR SWIA972491Adc · failedADC1 FAILURE, MAC TRIM FAILURE, IAS 1 FAIL, FD FAILURE - CAT II. REMOVED AND REPLACED NR 1 ADC 850A AND NR 1 ADC DRAIN ASSEMBLY. OPS CHECK GOOD IAW 34-13-01. CAT II OK FOR CAT II. P/N: 822-0372-140, S/N ON: 2145, S/N OFF: 1102.SDR SWIA972433Reservoir · failedAFTER TAKEOFF SELECTED GEAR UP AND HYDRAULIC NUMBER THREE LOW PRESSURE CAUTION CAME ON, FOLLOWED BY GEAR UP DISAGREE (BOTH MAIN GEAR). ALSO, NOSE DOOR OPEN WARNING MESSAGE CAME ON. NOTED NUMBER THREE HYDRAULIC SYSTEM FAILURE (3A & 3B PUMP PSI 0). RETURNED TSDR SWIA971989Actuator · failedSETTING FLAPS FROM 0 DEGREES TO 8 DEGREES FLAPS FAILED AT 0 DEGREES WITH ATTENDING FLAP FAIL CAUTION MESSAGE. PERFORMED A ''''NO FLAP'''' LANDING. FOUND RIGHT HAND FLAP NUMBER 4 FLEX SHAFT SHEARED AND NUMBER 4 FLAP ACTUATOR BAD ON THE RIGHT SIDE. REPLACED DSDR SWIA971854Drag Brace · damagedNOSE GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO FIELD. REMOVED AND REPLACED NOSE LANDING GEAR DRAG BRACE IAW MM 322105. OPS AND LEAK CHECKS GOOD. P/N ON: 16400105, SN: PCL07094, SN OFF: DCLO7494.SDR SWIA971613Sensor · malfunctionedPITOT BASE OVERHEAT WARNING ILLUMINATED AFTER TAKEOFF. RETURNED TO FIELD. POWERED AIRCRAFT DOWN AND BACK UP. NO DEFECTS NOTED AT THIS TIME. AIRCRAFT GOOD FOR CONTINUED SERVICE. REMOVED AND REPLACED AIR DATA SENSOR CONTROLLER AFTER ARRIVAL IN SLC. OPS CHESDR SWIA971503Overheat Message · malfunctionRIGHT 14TH STAGE DUCT OVERHEAT MESSAGE EN ROUTE. QUICK REFERENCE HANDBOOK PERFORMED AND MESSAGE PERSISTS. SINGLE ENGINE PROCEDURE PERFORMED AND DUCT MESSAGE PERSISTS. LEFT BECAME INTERMITTENT JUST PRIOR TO LANDING. FIRE CREWS REPORTED NO SIGN OF FIRE. REMSDR SWIA971091Fecu · failedFLAP FAIL MSESSAGE DURING FLAP RETRACTION ON CLIMB-OUT. RETURNED FOR LANDING. REMOVED FLAP PDU AND FECU AND REPLACED WITH SERVICEABLE UNITS IAW MM 27-52-01. ALL CHECKS GOOD.SDR SWIA971086Adc · failedON APPROACH TO EUG PFD NR 1 LOST ALL AIR DATA (AIRSPEED, ALTITUDE, ATTITUDE, VSI) ALSO MACH TRIM. REMOVED AND REPLACED IDC 4000 CONVERTER. ALL SYSTEMS CHECKS NORMAL.SDR SWIA971001Fire Loop · malfunctionedLEFT JET PIPE LOOP A FAILED. MEL 26-11-2, INSPECTED LEFT EXHAUST NOZZLE FAIRING FOUND LOOSE HARDWARE. REMOVED AND INSTALLED SERVICEABLE HARDWARE AND SECURED IAW MM 78-11-01. OPS CHECKS OF ENGINE FIRE/OVERHEAT DETECTION GOOD AT THIS TIME IAW MM 26-11-00-710.SDR SWIA97918Web · tornON CLIMBOUT, HEARD A VERY LOUD LOW FREQUENCY VIBRATION. OCCURRED 2 TIMES AND SUBSIDED BOTH TIMES WITHOUT ANY CHANGES BY CREW TO CONFIGURATION. RETURNED TO TUC FOR PRECAUTIONARY LANDING. INSPECTED ENTIRE AIRCRAFT EXTERNALLY. INSPECTED INTERIOR OF BELLY AND SDR SWIA97914Ahrs · malfunctionedAFTER TAKEOFF ATTITUDE AND HEADING BECAME INOP, YAW DAMPER 1 BECAME INOP AND AUTO PILOT INOP. RETURNED TO SLC. REPLACED CAPTAINS AHRS COMPUTER. OPS CHECKS GOOD IAW MM 34-21-01. THIS AIRCRAFT IS CATEGORY II.SDR SWIA97958Angle · corrodedFLOOR SUPPORT ANGLE IN PASSENGER DOOR OPENING HAS CORROSION. REMOVED LOWER FLOOR BOARD SUPPORT ANGLE IN ENTRANCE WAY OF CABIN DOOR AND FABRICATED NEW ANGLE FROM S3992 MATERIAL AND INSTALLED IAW SRM 51-24-16.SDR SWIA97895Downlock Pin · dirtyAIRCRAFT FERRIED TO PSP DUE TO NOSE LANDING GEAR NOT COMING UP AT SFO. RETURNED TO FIELD FOR LANDING. JACKED AIRCRAFT UP AND FOUND DIRT IN GEAR DOWNLOCK PIN. CLEANED AND OPERATED GEAR PER MM 32-30-00, OPS CHECKS GOOD.SDR SWIA95744Drag Brace · failedTAKEOFF BUR, NOSE GEAR WOULD NOT RETRACT. NOSE GEAR REMAINED DOWN WITH NO TRANSIT INDICATION. CYCLED FOUR TIMES TO GET NOSE GEAR UP. REPLACED NOSE GEAR DRAG BRACE IAW CRJ MM 32-21-05 AND SWA RII 32-402.SDR SWIA95732Priority Valve · malfunctionedAFTER DEPARTURE, NOSE GEAR FAILED TO RETRACT. PERFORMED QRH CHECKLIST. RETURNED TO PDX WITH A NORMAL LANDING. REMOVED AND REPLACED MAIN LANDING GEAR PRIORITY VALVE IAW MM 32-32-15, OPS AND LEAK CHECK GOOD.SDR SWIA95730Retract Mech · malfunctionedNOSE GEAR DID NOT RETRACT AFTER TAKEOFF. ATTEMPTED QRH PROCEDURES WITH NO CHANGE. RECEIVED GEAR DISAGREE AND NOSE DOOR OPEN MESSAGE A FEW SECONDS LATER. INSPECTED NOSE GEAR AND COMPONENT, ADJUSTED DOOR PROX SENSOR, SWUNG GEAR PER RJ MM. PERFORMED FUNCTIONASDR SWIA95647Fail Message · activatedFLAP FAIL MESSAGE AFTER TAKEOFF. ALSO, FLAP OVERSPEED AURAL WARNING AT 230 KTS. REVIEWED FLAP FAULTS AT FECU AND RESET FECU. OP CK FLAPS, OP CK GOOD.SDR SWIA95600Fecu · malfunctionedFLAP FAIL MESSAGE AT FLAP RETRACTION AFTER TAKEOFF, FLAPS INOP, COMPLETED FLAPS UP LANDING. RESET FECU ON FLAP CON CHAN 1 AND CHAN 2, OPS CKS NORMAL.SDR SWIA95599Contl Mech · malfunctionedFLAPS FAIL MESSAGE, FLAP FAILED AT 18 DEGREES. CONTACTED SGU MAIN CONTROL. DIVERTED TO MSO. RESET FECU CIRCUIT BREAKER FLAPS FAIL MESSAGE, CLEANED FLAPS, OPS CKS NORMAL.
Back to N410SW, cancelled Jun 8, 2017