N412SW, cancelled May 30, 2018
Service difficulty reports · 147
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 = 'N412SW' AND deregistration_id = 'N412SW-2018-05-30' 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 = 'N412SW' AND deregistration_id = 'N412SW-2018-05-30' 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 SWIA200413051Beam · crackedCRACK FOUND ON LOWER WEB OF ENGINE SUPPORT BEAM AT RIGHT ACCESS PANEL CUTOUT, OUTBOARD OF RBL 36.2, BETWEEN FS 625.3 AND FS 640.0. CARRIED OUT ENGINE SUPPORT BEAM REPAIR RH SIDE IAW BRAD REO 601R-53-61-366 REV. ESDR SWIA200413050Beam · crackedCRACK FOUND ON LOWER WEB OF ENGINE SUPPORT BEAM AT LEFT ACCESS PANEL CUTOUT, OUTBOARD OF LBL 36.2, BETWEEN FS 625.3 AND FS 640.0. CARRIED OUT ENGINE SUPPORT BEAM REPAIR ON LH SIDE IAW BRAD REO 601R-43-61-366 REV. E.SDR SWIA200413049Support · brokenCARGO PIT; STEP PLATE SUPPORT IS BROKEN OUT ALONG INBOARD SIDE. CARGO PIT STEP PLATE SUPPORT REPLACED IAW CRJ SRM 51-41-02 AND SRM 51-23-00.SDR SWIA200413048Beam · crackedCARGO PIT; FS 589.00 AND 605.00; TRANSVERSE BEAM ATTACH ANGLES FOR LANDING PLATE STOP FITTINGS CRACKED. REPLACED ANGLES (2 OF) IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-21-11, 51-25-16, 51-41-04.SDR SWIA200413047Beam · crackedMAIN FUSELAGE; FS 280.00; LBL-9; UPPER FLANGE CRACKED ON TRANSVERSE BEAM. REPAIRED IAW CRJ REO 601R-53-11-138 REV. NC AND RII53-401.SDR SWIA200413046Beam · crackedMAIN FUSELAGE; FS 280.00, RBL 9.0, LOWER FLANGE CRACKED ON TRANSVERSE BEAM. REPAIRED IAW CRJ REO 601R-53-11-171 REV. NC AND RII53-401.SDR SWIA200413029Angle · crackedDISCOVERED DURING C-CHECK INSPECTION, COCKPIT FLOOR HATCH; AFT CAMLOCK ANGLE IS CRACKED AT FS 280.00; RBL-8.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-21-11, 51-23-00, AND 51-25-16, AND RII53-401.SDR SWIA200413028Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, FS RIGHT SIDE ELECTRICAL BAY FLOOR CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FLOOR DAMAGE IAW CRJ REO 601R-53-11-345 REV. NC AND RII53-401.SDR SWIA200413027Floor Panel · crackedDISCOVERED DURING C-CHECK INSPECTION, FS 193 LEFT SIDE ELECTRICAL BAY FLOOR CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FLOOR IAW CRJ REO 601R-53-11-081 REV. NC AND RII 53-401SDR SWIA200312305Control Unit · malfunctionedSTAB TRIM CH 2 INOPERATIVE, WILL NOT ENGAGE. REPLACED HSTA AND MOTOR CONTROL UNIT AND REMOVED AND REPLACED FO'S DISCONNECT SWITCH IAW 27-40-00. P/N: 8396-3 S/N OFF: 806SDR SWIA200312204Lamp · inoperativeOVERHEAD EMERGENCY LIGHT NEXT TO LAV IS INOP. REMOVED AND REPLACED EMERGENCY LIGHT LAMP. P/N: 1317.SDR SWIA200312007Bulb · inoperativeCENTER STEP BOARDING LIGHT IS INOP. REPLACED LIGHT BULBS IN CENTER STEP BOARDING LIGHT PER MM 33-45-01. OPS CHECK GOOD.SDR SWIA200311846Warning Light · false activationDURING CLIMBOUT CABIN DOOR LATCH CAUTION ON EICAS (PAX DOOR LATCH CAUTION). CABIN WAS HOLDING PRESSURE. OUT OF 25,000 FT PASSENGER DOOR WARNING EICAS MESSAGE APPEARED. RETURNED TO SLC. INSPECTED PASSENGER DOOR, NO DEFECTS NOTED. INTERROGATED PSEU, NO FASDR SWIA200311736Warning Light · illuminatedUPON CLIMBING THROUGH 4000 FT THE PASSENGER DOOR LATCH CAUTION MESSAGE ILLUMINATED, FOLLOWED BY A PASSENGER DOOR WARNING MESSAGE. FOLLOWED QRH. RETURNED TO GTF. INSPECTED DOOR AND CHECKED CABIN PRESSURE. DOOR AND PRESSURE CHECKS OK PER MM 21-31-00.SDR SWIA200311682Dampener · malfunctionedON PUSHBACK YD NR 2 STATUS MESSAGE CAME ON. RESET YAW DAMPER NR 2, MESSAGE REOCCURRED. REPLACED NR 2 YAW DAMPER IAW 22-22-01. OPS CHECK OK.SDR SWIA200211671Proximity Sensor · malfunctionedPASSENGER DOOR LATCH CAUTION MESSAGE AFTER TAKEOFF. FOLLOWED QRH NO PRESSURIZATION PROBLEMS. CONTINUED TO GSO. CLIMBING THROUGH 20,000 PASSENGER DOOR WARNING. STILL NO PRESSURE PROBLEMS. RETURNED TO DFW. AFTER LEVELING AT 11,000 COMING BACK TO DFW, DOOR SDR SWIA200211277Skin · dentedRIGHT WING LEADING EDGE BETWEEN WS 85.5 AND WS 96.13 IS DENTED AND OIL CANNING ON LOWER SIDE OF LEADING EDGE. REPLACED INBOARD RIGHT LEADING EDGE IAW MM 57-41-01.SDR SWIA200211225Rivet · corrodedANCHOR NUTS FOR RT OVERWING EMERGENCY EXIT BOTTOM HINGE FITTINGS HAVE CORRODED RIVETS. DISCOVERED DURING C-CHECK. FITTINGS REMOVED FOR ACCESS. RIVETS INSTALLED IAW CRJ SRM 51-42-16. INSTALLED FITTINGS IAW MM 20-21-00.SDR SWIA200211224Angle · corrodedPAX DOOR LWR SILL VERTICAL FLOOR ANGLE CORRODED. DISCOVERED DURING C-CHECK. FITTED AND INSTALLED NEW ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13.SDR SWIA200210976Door Frame · crackedPASSENGER DOOR FRAME DAMAGED FORWARD AND AFT WHERE DOOR PINS HAVE BENT AND CRACKED THE DOOR SEAL SEAT. REMOVED DAMAGED REPAIR AT STA 310.00 AND 349.00 AND FABRICATED AND INSTALLED NEW PER REO 601R-52-11-008.SDR SWIA200210931Control Unit · malfunctionedSTAB TRIM CH2 WILL NOT ENGAGE. REPLACED HORIZONTAL STAB ACTUATOR IAW 27-42-01 AND REPLACED HORIZONTAL STAB MOTOR CONTROL UNIT IAW 27-42-05. OPS CHECK GOOD IAW MM. OK FOR CAT II OPERATIONS.SDR SWIA200210526Connector · dirtyAFTER TAKEOFF PASSENGER DOOR LATCH CAUTION (AT 1,000 FT) APPEARED FOLLOWED BY PASSENGER DOOR LATCH WARNING AFTER 300 FT GAIN IN ALTITUDE. RETURNED TO THE FIELD. CLEANED AND INSPECTED GAPS ON PS5MB & PS6MB. GAPS CHECKED GOOD. CLEANED PAX DOOR WIRING HARNESSSDR SWIA200210527Pitot Line · contaminatedINFLIGHT, NR 2 ADC FAILED (IAS AMBER FLAG, EFIS COMP MON CAUTION, STALL FAIL). SWITCHED TO ADC 1 BOTH SIDES. NORMAL OPS TO LANDING IN YYC. PERFORMED CONTAMINATION REMOVAL (WATER) PURGING & FUNCTIONAL TEST OF CAPTAIN'S, F/O'S & STANDBY PITOT STATIC SYSTEMS. SDR SWIA200110360Handle · defectiveAT 1500 FT AGL PASSENGER DOOR UNSAFE CAUTION AT 11,000 FT. RED PASSENGER DOOR UNSAFE MESSAGE. RETURNED TO AIRPORT. INSPECTED PASSENGER DOOR FOR LOOSE OR DAMAGED PARTS. REPLACED OUTER HANDLE AND INNER HANDLE DETENT ROLLER (CLEANED). PRESSURIZED TO APPROXIMSDR SWIA200110203Latch · malfunctionedCABIN DOOR DIFFICULT TO OPEN FROM INSIDE OR OUT.REPLACED TRIGGER ON MAIN PASSENGER HANDLE LATCH IAW CMM 52-11-03.SDR SWIA200110128Switch · malfunctioned''DISPLAY COOL'' CAUTION MESSAGE IN FLIGHT WITH FAN SWITCH ''NORM'' AND ''FLT ALTN'' EXTINGUISHED IN STBY MODE. MOVED DISPLAY FAN SWITCH FROM NORMAL TO GND ALT POSITION AND COLLARED CB 1D2.SDR SWIA200110029Windshield · crackedAT 26,000 FEET THE CAPTAINS WINDSHIELD CRACKED.REMOVED AND REPLACED CAPTAIN'S WINDSHIELD. PN ON NP139321-5 SN ON 01113H6149. REF MM 56-11-01. PERFORMED PRESSURIZATION LEAK CHECKS AND OPS CHECKS OF WINDOW HEAT, NO FAULTS NOTED.SDR SWIA200110016Door · openON DEPARTURE AT SPEED ABOVE 280 KNOTS, LOUD HIGH PITCH SOUND FROM FRONT OF AIRCRAFT. RETURNED TO SLC. FOUND SMALL DOOR, FOR NOSE DOOR SWITCH, OPEN. NO DAMAGE NOTED ON DOOR. CLOSED AND LATCHED DOOR.SDR SWIA972595Pcu · out of adjAIRCRAFT DOES NOT FLY LEVEL. THE RIGHT WING IS LOWER THAN LEFT. REQUIRES LEFT AILERON ALL THE TIME. DOES NOT SET LEVEL ON THE GROUND. ALMOST 1/2 BALL OUT ON THE GROUND. ADJUSTED LEFT AILERON PCUS UP PER RIGGING PROCEDURE IN MM 27-11-00 AND SERVICED RIGHT SDR SWIA972556Fcu · failedFLAP FAIL MESSAGE AFTER DEPARTURE. RETURNED TO SMF. REMOVED AND REPLACED FECU IAW RJ MM 27-51-05. REMOVED AND REPLACED BOTH BPSU''S IAW RJ MM 27-51-10. FLAP SYSTEM OPS CHECK GOOD. BPSU LT P/N ON: 855D100-9, S/N ON: 1150, P/N OFF: 601R93105-7, S/N OFF: SDR SWIA972553Flap · malfunctionedFLAPS FAILED AT 3 DEGREES ON RETRACTION. RETURNED TO AIRPORT. CYCLED POWER. C/W AD98-20-01, PARA B. FOUND FLAPS TO OPERATE NORMAL.SDR SWIA972438Warning System · activatedPASSENGER OUTER DOOR LATCH MESSAGE IN FLIGHT OVER DILLON. LANDED IDA. MESSAGE WENT OUT ON ROLLOUT. GROUND CREW IN IDA CLOSE DOOR AND VISUALLY CONFIRM LATCHED AND CONTINUED TO SLC. FLIGHT ATTENDANT CAN''T COMPLETELY CLOSE DOOR. OPERATED PASSENGER DOOR HANDSDR SWIA972372Shutoff Valve · failedAFTER TAKEOFF, PARK BRAKE SOV CAUTION MESSAGE ILLUMINATED. RETURNED TO SLC. REMOVED AND REPLACED PARKING BRAKE SHUTOFF VALVE IAW 32-45-11. OPS AND LEAK CHECK GOOD.SDR SWIA972233Switch · dirtyINFLIGHT THE FIRST OFFICERS STAB TRIM BECAME INOP (MORE DOWN TRIM ONLY) WITH AUTOPILOT ON. THE AUTOPILOT WILL NOT DISENGAGE BY MOVING FIRST OFFICERS TRIM TO NOSE DOWN. REMOVED TRIM SWITCH FROM YOKE (FIRST OFFICERS). SPRAYED CONTACT CLEANER TOP AND BOTTOM OF SDR SWIA972142Computer · failedLEFT TRANSFER EJECTOR PUMP VALVE AFTER NORMAL TRANSFER LEFT TANK FUELED TO 4900 POUNDS RIGHT NORMAL AT 4450+-100 POUNDS. UNABLE TO BALANCE FUEL WEIGHT. RETURNED TO SLC. REMOVED AND REPLACED FUEL SYSTEM COMPUTER IAW AMM 28-41-26. OPS CHECK GOOD. PN ON 736-SDR SWIA971881Warning Light · false indicationPASSENGER DOOR HANDLE CAUTION MESSAGE CAME ON IN FLIGHT. RETURNED TO SLC. MAINTENANCE DEFERRED THE DOOR INDICATION SYSTEM.SDR SWIA971758Stall Warning · activatedOUTBOARD GROUND SPOILER FAULT STATUS MESSAGE WITH ABNORMAL STALL SPEED INDICATION ON AIRSPEED TAPE, INDICATED RED LINE AT 165 KIAS IN THE CLEAN CONFIGURATION. RETURNED TO SLC. INTERROGATED FCC DIAG NOSTICS COMPUTER AND FOUND NO FAULTS IN STALL PROTECTION SYSDR SWIA971695Pin · shearedCABIN WOULD NOT PRESSURIZE. RETURNED TO FAT. FOUND ATTACHING ARM FOR PRESSURE VALVE ASSEMBLY ON PASSENGER DOOR HAD SHEARED ATTACHING PINS. REPAIR IAW REO 601R5211203 PASSENGER DOOR OPS CHECK GOOD AND PRESSURIZATION OPS CHECKS GOOD.SDR SWIA971502Service Panel · not closedON TAKEOFF, ADC NR 2 FAILED. SHORTLY THEREAFTER A LOUD VIBRATION COULD BE HEARD AND FELT IN THE COCKPIT. RETURNED TO SLC. FOUND OXYGEN SERVICE PANEL UNLATCHED CAUSING A DISTURBANCE IN AIRFLOW TO THE NR 2 PITOT TUBE. PERFORMED INSPECTION OF O2 SERVICE PANELSDR SWIA971412Window · failedRIGHT SIDE WINDOW SHATTERED IN FLIGHT. NO APPARENT CONTACT OR LOSS OF PRESSURE. NORMAL LANDING IN FAT. REMOVED AND REPLACED RIGHT SIDE COCKPIT WINDOW IAW MM 56-12-01.SDR SWIA971243Sill · corrodedCORROSION AROUND PASSENGER DOOR SILL AREA ON ANGLES. REMOVED AND REPLACED PASSENGER DOOR SILL AREA ANGLE IAW EMB SRM 51-00-00.SDR SWIA971242Sill · corrodedCORROSION AROUND SERVICE DOOR SILL AREA ON ANGLES. REMOVED AND REPLACED SERVICE DOOR SILL AREA ANGLE IAW CJR SRM 51-00-00.SDR SWIA97960Crossbeam · corrodedFLOORBEAM CROSS MEMBER AT STA 349 BETWEEN LBL 27.00 AND LT FUSELAGE SIDE HAS CORROSION PAST SERVICE LIMITS. REPLACED FLOORBEAM STRAP BETWEEN LBL 27.00 AND FUSELAGE SIDE ON FS 349 IAW SRM 51-40-00.SDR SWIA97959Angle · corrodedFLOOR SUPPORT ANGLE IN PASSENGER DOOR OPENING HAS CORROSION PAST SERVICE LIMITS. REMOVED AND REPLACED THE FLOOR SUPPORT ANGLE IN THE PASSENGER ENTRY WITH NEW. ALL WORK DONE IAW MM 51-40-00.SDR SWIA97884Overtemp Switch · failedDEPARTURE, SMOKE TOILET MESSAGE AND SMOKE REPORTED BY FLIGHT ATTENDANT. RETURNED FOR LANDING SLC. DEF RT PACK PER MM 21-51-1. FOUND RIGHT PACK OVERTEMP SWITCH INOPERATIVE. PARTS ON ORDER 04/15/97 -UPDATE - REPLACED RIGHT PACK OVERTEMP SWITCH, OPS CHECKS GOSDR SWIA95746Oil Press Switch · failedLEFT ENGINE OIL PRESSURE INDICATION DROPPED TO 0 ON CLIMBOUT. OIL TEMPERATURE REMAINED NORMAL AND NO EICAS MESSAGES APPEARED. REPLACED LEFT ENGINE OIL PRESSURE SWITCH, RAN ENGINE. OPS CHECK GOOD, NO LEAKS NOTED.SDR SWIA95743Prox Sensor · out of adjustAFTER LIFT OFF AND GEAR RETRACTION, NOSE GEAR WOULD NOT COME UP. INDICATION REMAINED GREEN. ATTEMPTED TO CYCLE GEAR BUT IT DID NO GOOD. RETURNED TO GATE. REPLACED NOSE GEAR WOW SWITCH BRACKET AND ADJUSTED PROX SENSOR. REFER TO M/M TASK 32-30-00 - 720-901.
Back to N412SW, cancelled May 30, 2018