N403SW, cancelled Jul 17, 2013
Service difficulty reports · 156
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 = 'N403SW' AND deregistration_id = 'N403SW-2013-07-17' 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 = 'N403SW' AND deregistration_id = 'N403SW-2013-07-17' 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 SWIA200413738Angle · crackedFS 280.00 FWD AND O/B OF RBL 9 VERTICAL J-ANGLE CRACKED P/N 600-34017-514. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW FABRICATED J-ANGLE IAW CRJ 200 SRM 51-42-06 AND 51-42-13.SDR SWIA200413737Threshold · corrodedDOUBLER AT FS 312 FORWARD OF FRONT SERVICE DOOR LOWER THRESHOLD IS CORRODED BEYOND LIMITS. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED NEW DOUBLER P/N 601R38669-49. ALL WORK IAW CRJ 200 SRM 51-23-00, 51-25-21, 51-42-06, 51-25-16.SDR SWIA200413736Bracket · crackedJOINT BRACKET LOWER SILL AT FS 319.70 P/N 601R38335-1 FWD OF RVC DOOR LOWER THRESHOLD IS CORRODED BEYOND LIMITS. ITEM FOUND AT C-CHECK INSPECTION. REPLACED CORRODED BRACKET WITH NEW, P/N 601R38-335-1 IAW CRJ SRM 51-42-21.SDR SWIA200413735Angle · crackedANGLE AT STRINGER 3L APPROXIMATELY 2 INCHES AFT OF FS 280 BULKHEAD IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLE AT STRINGER 3L STA FS 280 IAW CRJ SRM REF 52-42-06.SDR SWIA200413398Window · crackedRIGHT WINDOW CRACKED DURING PUSHBACK. REPLACED RIGHT WINDOW IAW 56-00-00, 56-12-01 AND RII56-402. P/N OFF NP-139322-6, S/N OFF 03169H6693.SDR SWIA200413278Actuator · malfunctionedSTAB TRIM CH 1 INOP. WOULD NOT RE-ENGAGE. REMOVED AND REPLACED MOTOR CONTROL UNIT AND HORIZONTAL STAB ACTUATOR IAW AMM 27-40-00, 27-42-05. OPS CHECK OK. MCU P/N: 7062-3 S/N OFF: 942SDR SWIA200312578Transducer · malfunctionedSTALL FAIL CAUTION MESSAGE IN FLIGHT. REMOVED AND REPLACED LEFT MACH TRANSDUCER IAW CRJ MM 27-35-25. OPS CHECK GOOD.SDR SWIA200312491Pdu · malfunctionedFLAPS HALF SPEED STATUS MESSAGE ILLUMINATED. REPLACED FLAP PDU WITH SERVICEABLE UNIT IAW CRJ MM 27-52-01. OPS CHECK NORMAL. S/N OFF: 109.SDR SWIA200312141Pcu · malfunctionedON TAXI OUT RECEIVED A SPOILERON (RIGHT) MESSAGE, WAS UNABLE TO CLEAR. REMOVED AND REPLACED RIGHT INBOARD SPOILERON PCU IAW 27-60-00. OPS CHECK GOOD. NO LEAKS NOTED.SDR SWIA200311819Wire · brokenAISLE FLOOR EMERGENCY LIGHT SEGMENT INOP. EMERGENCY EXIT LIGHT, OVERWING (R) SIDE LOWER, INOP. REPAIRED BROKEN WIRE CONNECTOR TO FLOOR SEGMENT OF TRACK LIGHTING. OPS CHECK GOOD.SDR SWIA200311789Control Unit · malfunctionedBOTH STAB TRIM & MACH TRIM DISCONNECT IN FLIGHT, HARD TO RESET. ON LANDING, BOTH STAB AND MACH TRIM DISCONNECTED AGAIN. REMOVED AND REPLACED HSTCU IAW MM 27-41-01. OPS CHECK GOOD.SDR SWIA200211608Actuator · malfunctionedYAW DAMPER NR 1 INOP (STATUS MESSAGE), WOULD NOT STAY ENGAGED. REMOVED AND REPLACED NR 1 YAW DAMPER ACTUATOR IAW CRJ MM 22-22-01. OPS CHECK GOOD.SDR SWIA200211474Bulkhead · cracked5 CRACKS FOUND TO BE RADIATING FROM PARK BRAKE CABLE CUTOUT ON LEFT SIDE OF THE FORWARD PRESSURE BULKHEAD. REPAIRS IN PROGRESS. SUPPLEMENTAL REPORT FORTHCOMING.SDR SWIA200211592Bulkhead · cracked5 CRACKS FOUND RADIATING OUT FROM PARK BRAKE BULKHEAD FITTING, LEFT FORWARD PRESSURE BULKHEAD. FOUND DURING C CHECK INSPECTION. NDT-HFEC CARRIED OUT IAW CLIENT REQUEST. FIVE (5) CRACKS FOUND TO BE RADIATING FROM PARK BRAKE BULKHEAD THROUGH FITTING CUTOUTSDR SWIA200211591Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM INBOARD AND OUTBOARD ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. REPLACED INBOARD AND OUTBOARD ANGLES IAW CRJ SRM 51-40-11, 51-42-21, 51-42-13, 51-42-06 AND REO 601R-53-11-171 REV NC.SDR SWIA200211590Floorbeam · crackedFS 280 LBL 9.0 FLOORBEAM INBOARD AND OUTBOARD ANGLES ARE CRACKED. FOUND DURING C-CHECK INSPECTION. FIT AND INSTALLED NEW CLIPS (ANGLES) IAW CRJ REO 601R-53-11-171.SDR SWIA200211589Frame · crackedFS 718.0 RT PYLON FAIRING ATTACH POINT FRAME CRACKED. FOUND DURING C-CHECK INSPECTION. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-61-193 REV A. NDT-HFEC CARRIED OUT IAW CLIENT REQUEST. NO CRACKS NOTED.SDR SWIA200211421Proximity Sensor · looseUPON ROTATION WE RECEIVED A SERVICE DOOR CAUTION MESSAGE. RETURNED TO SLC. ON THE DOWNWIND, THE LIGHT DID EXTINGUISH WHEN THE POWER WAS RETARDED. FOUND INNER DOOR WITH PROX SENSOR LOOSE. SECURED HANDLE. OPS CHECK GOOD AT THIS TIME.SDR SWIA200211284Pitot Tube · corrodedRIGHT SIDE PITOT/STATIC TUBE CORRODED. REMOVED AND REPLACED RIGHT PITOT/STATIC TUBE IAW 34-11-01. PERFORMED PITOT/STATIC SYSTEM LEAK CHECK IAW MM 30-31-00. ALSO HEAT CHECKS GOOD IAW MM 34-11-00.SDR SWIA200211205Switch · dirtyRIGHT THRUST REVERSER DEPLOY MSG ON TO ROLL. ABORTED, CLEANED RIGHT THRUST REVERSER MICROSWITCHES, CLEANED & LUBED THRUST REVERSER TRACKS & ACTUATORS. CYCLES THRUST REVERSER NUMEROUS TIMES WITH NO FAULTS. OPS CHECK GOOD PER MM 78-30-00.SDR SWIA200211071Jackscrew · brokenCAPTAIN'S RUDDER PEDALS WILL NOT ADJUST BACK. REMOVED AND REPLACED BROKEN JACKSCREW ON CAPTAIN'S SIDE PEDAL ADJUST MECHANISM IAW CRJ MM 27-21-05. OPS CHECK GOOD.SDR SWIA200211035Idg · malfunctionedRECEIVED A GEN 1 OFF CAUTION DURING T/O ROLL. ABORTED T/O. REMOVED AND REPLACED IDG ON LT ENGINE. OPS CHECK GOOD AT THIS TIME.SDR SWIA200211036Handle · looseINTERMITTENT SERVICE DOOR CAUTIONS FOR FIRST 15 MINUTES OF FLIGHT. CABIN PRESSURE AND DOOR LATCH INDICATORS NORMAL. TIGHTENED INNER HANDLE ON SERVICE DOOR. SERVICE DOOR IND, OPS CHECK GOOD.SDR SWIA200210966Control Unit · malfunctionedSTABILIZER TRIM CHANNEL 1 POPPED THE CIRCUIT BREAKER. REMOVED AND REPLACED MOTOR CONTROL UNIT IAW 27-41-00. OPS CHECK GOOD.SDR SWIA200210787Screw · looseRECEIVED A SERVICE DOOR CAUTION MESSAGE DURING CLIMBOUT. FOLLOWED QRH AND RETURNED TO LAX. FOUND THE 4 SCREWS HOLDING THE SERVICE DOOR INNER HANDLE TO BE LOOSE. TIGHTENED THE SCREWS AND CHECKED THE GAP FOR THE SERVICE DOOR PROXIMITY SWITCH. ALL CHECKS GOODSDR SWIA200210662Pcu · malfunctionedRIGHT SPOILERON FAILS WHEN NR 3 HYDRAULIC IS TURNED ON BEFORE NR 2. REMOVED AND REPLACED RIGHT OUTBOARD SPOILERON PCU IAW 27-63-00. OPS CHECK AND LEAK CHECK GOOD.SDR SWIA200210607Connector · contaminatedFWD EMERGENCY TRACK LIGHTING ON FLOOR IS INOP. FOUND MOISTURE IN FLOOR TRACK LIGHTING STRIP PINS. REMOVED MOISTURE. OPS CHECKS GOOD.SDR SWIA200210551Shaft · galledRIGHT MLG SIDE BRACE SHAFT FITTING IS GALLED AND CORRODED. REMOVED AND REPLACED RIGHT MLG SIDE BRACE SHAFT IAW 57-21-28. OPS CHECK GOOD.SDR SWIA200110432Battery Pack · dischargedFLOOR EMERGENCY LIGHTS (FRONT HALF) DIM, 1 SECTION OUT NEAR EMERGENCY EXIT. REMOVED FORWARD EMERGENCY LIGHTING BATTERY PACK (ELBP) IN CABIN CEILING AND REPLACED WITH SERVICEABLE ELBP. FOUND ONE FLOOR LIGHT SECTION UNPLUGGED. REPLUGGED THAT SECTION. OPS CHESDR SWIA972564Actuator · defectiveLEFT THRUST REVERSER UNLOCK CAUTION MESSAGE AT 1000 FEET AGL AFTER TAKEOFF. NO AUTO LEVER RETARD AND NO BUFFET. RETURNED TO FIELD. LEFT REV UNLOCK LIGHT CAME ON AT TOP OF DESCENT AND STAYED ON UNTIL ENGINE SHUT DOWN. INSPECTED THE LEFT THRUST REVERSER FOUNSDR SWIA972088Flap · icedRECEIVED A FLAPS FAIL MESSAGE WHEN RETRACTING THE FLAPS AFTER TAKEOFF. RETURNED TO SLC. MAINTENANCE PROCEDURE COMPLIED WITH AND REMOVED SNOW AND ICE FROM FLAP AREAS. OPS CHECKS GOOD.SDR SWIA972010Warning Light · illuminatedCARGO DOOR CAUTION MESSAGE CAME ON AFTER TAKEOFF. FOLLOWED QRH PROCEDURES, RETURNED AND LANDED AT PSC. INSPECTED CARGO DOOR HANDLE IAW MM 52-31-02. OPS CHECKS GOOD AT THIS TIME. UNABLE TO DUPLICATE DISCREPANCY.SDR SWIA972011Ifs · malfunctionedWITH AUTOPILOT SELECTED TO CAPTAINS SIDE AIRCRAFT STARTS A DESCENT AND AUTOPILOT DISCONNECTS ALONG WITH CAPTAINS. DED AHRS GOES BLANK. CAT II REMOVED AND REPLACED NUMBER ONE (CAPTAINS) AHRS S/N ON: 1684 S/N OFF: 2315. TESTED IAW 34-21-01. REMOVED NUMBER ONSDR SWIA972000Computer · failedYAW DAMPER FAILED INFLIGHT. REPLACED FCC NR 1 (P/N 622-9815-404) (S/N 432) OFF, (S/N 337) ON. CHECKS NORMAL IAW MM 22-12-14.SDR SWIA972001Switch · malfunctionedELEVATOR TRIM MOVES NOSE DOWN WITHOUT PILOT INPUT. REPLACED DEFECTIVE TRIM SWITCH IAW MM 27-1-05. OPS CHECKS GOOD.SDR SWIA971910Indicator · malfunctionedSTAB TRIM CAUTION MSG APPEARED AFTER TAKEOFF. TWO ATTEMPTS BEFORE STAB TRIM CAUTION CAME ON AGAIN. REMOVED AND REPLACED HSTU AND PERFORMED FUNCTIONAL TEST MM 27-41-01, CAT II.SDR SWIA971866Light · inoperativeEMERGENCY LIGHT IS INOP ABOVE SEATS 10AB, 10CD. REMOVED AND REPLACED LAMP, OPS CHECKS GOOD.SDR SWIA971599unknownEN ROUTE CLIMB THROUGH FL340 N2 VIB ICON CAME ON. WOULD NOT GO OUT UNTIL N1 REDUCED TO 80 PERCENT. ON DESCENT, N2 ICON AGAIN CAME ON AT FL300. REDUCED N1 TO 79 PERCENT. N2 VIB ICON OUT. RETURNED TO SLC. REPLACED ENGINE VIBRATION TRANSDUCER RIGHT ENGINE ASDR SWIA971591Engine · low powerCLIMBING THROUGH 33,000 N2 VIB WARNING ON N2 GAUGE ILLUMINATED (NR 2 ENGINE). REDUCED POWER UNTIL VIB WARNING CLEARED (84 PERCENT N1). DESCENDED TO 27,000 TO MAINTAIN FLYABLE AIRSPEED. ADVANCED NR 2 ENGINE POWER AND VIB WARNING CAME ON AGAIN AT 80 PERCENT N1SDR SWIA971539Seal · leakingUPON DEPARTURE, NOSE GEAR INDICATION DOWN AND LOCKED AFTER SELECTING GEAR UP. COMPLIED WITH CHECK LIST AND LOWERED GEAR. RETURNED TO FAT, MEL 32-30-1. REMOVED AND REPLACED NOSE GEAR STRUT TEE SEAL AND SERVICED NOSE STRUT. LEAK CHECKS OK IAW 32-21-00. SWUSDR SWIA971473Window · crackedLEFT SIDE WINDOW CRACKED IN FLIGHT. DIVERTED FROM ABQ TO FMN. NO LOSS OF PRESSURIZATION OR OTHER DIFFICULTIES ENCOUNTERED. REMOVED AND REPLACED LEFT SIDE WINDOW IAW MM 56-12-01. OPS CHECKS GOOD.SDR SWIA971466Bracket · damagedNOSE GEAR FAILED TO RETRACT AFTER TAKEOFF. NOSE GEAR DOORS OPEN AND NOSE GEAR LIGHT REMAINED GREEN. FOUND BRACKET FOR NOSE GEAR TARGET WAS DAMAGED. REPLACED BRACKET AND SET GAP PER MM 32-64-05. OPS CHECK SHOWS ALL INDICATIONS NORMAL.SDR SWIA971293Control Unit · malfunctionedTHE L 14TH DUCT WARNING MESSAGE ON IN FLIGHT. LEFT ENGINE PRECAUTIONARY SHUT DOWN ACCOMPLISHED. REMOVED AND REPLACED LEFT BLEED AIR CONTROL UNIT, IAW CRJ MM 36-21-10.SDR SWIA971256Light · illuminatedAFTER TAKEOFF, CARGO DOOR LIGHT ILLUMINATED. RETURNED TO GATE. OPERATIONAL CHECK OF CARGO DOOR CHECKS GOOD.SDR SWIA971269Sensor · failedFLAPS FAILS MESSAGE AT LEVEL OFF EN ROUTE SLC/BOI. RETURNED TO SLC. REPLACED LEFT FLAP BRAKE POSITION SENSOR.SDR SWIA971268Retract Mech · malfunctionedWHILE DESCENDING INTO TUC FLAPS FAIL MESSAGE CAME ON. COMPLIED WITH CHECKLIST AND LANDED IN TUC WITH 0 FLAPS. POWERED DOWN AIRCRAFT FLAPS SYSTEM AND RESET SYSTEM. CHECKS NORMAL.SDR SWIA971223Tire · failedHEARD LOUD BANG AT ROTATION ON TAKEOFF ON RUNWAY 34L. HAD TOWER CHECK FOR DEBRIS ON RUNWAY AND TOWER CONFIRMED TIRE DEBRIS ON RUNWAY SURFACE. RETURNED FOR LANDING WHICH WAS UNEVENTFUL. POST FLIGHT SHOWED A THROWN CAP ON RIGHT NOSE GEAR. INSPECTED AIRCRAFT SDR SWIA971099Switch · dirtyDEPARTING SLC AND OUT OF ABOUT 1500 AGL, THE AMBER CARGO DOOR MESSAGE CAME ON. RETURNED TO SLC. CLEANED AND LUBED THE CARGO DOOR HANDLE MICROSWITCH, OPS CHECKS GOOD.SDR SWIA97945Floorbeam · corrodedLBL 9.00 FLOORBEAM HAS CORROSION EXTENDING THROUGH BEAM BETWEEN FS 310.0 AND 333.0. REMOVED CORRODED AREA OF EDGE OF LBL 9.00 BETWEEN FS 310.0 AND FS 333.0 AND INSTALLED DOUBLER REPAIR IAW ON1R-53-21-092.SDR SWIA97899Bulkhead · crackedDISCOVERED CRACK IN PRESSURE BULKHEAD (P/N 601R3208-123), JUST FORWARD OF WING LEADING EDGE FS 409+128.
Back to N403SW, cancelled Jul 17, 2013