N298SW, cancelled Jan 17, 2018
Service difficulty reports · 86
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 = 'N298SW' AND deregistration_id = 'N298SW-2018-01-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 = 'N298SW' AND deregistration_id = 'N298SW-2018-01-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 SWIA200516037Smoke Detector · false activationLAVATORY SMOKE DETECTOR SOUNDED INFLIGHT THREE TIMES. REPLACED LAVATORY SMOKE DETECTOR. OPERATIONAL CHECK GOOD.SDR SWIA200514935Battery · dischargedLAV SMOKE DETECTOR WILL NOT SILENCE. NO VISIBLE SMOKE. REPLACED LAV SMOKE DETECTOR BATTERY. OPERATIONAL CHECK GOOD.SDR SWIA200514488Smoke Detector · malfunctionedSMOKE ALARM IN LAV GOES OFF INTERMITTENTLY. NO SMOKE OR FIRE NOTED. REPLACED SMOKE ALARM WITH SERVICEABLE UNIT. OPERATIONAL CHECK GOOD.SDR SWIA200414321Sign · brokenEXIT SIGN TO LOWER RIGHT OF F/A SEAT BROKEN. REPLACED LIGHT RECEPTACLE FOR EMERGENCY LIGHT AT F/A SEAT. OPERATIONAL CHECK GOOD.SDR SWIA200413675Trim Switch · malfunctionedRECEIVED ORAL (TRIM FAIL) FOLLOWED BY AP DISCONNECT. REMOVED AND REPLACED PILOTS TRIM SWITCH IAW MM 22-10-10, OPERATIONAL CHECK GOOD.SDR SWIA200413367Smoke · detectedDURING CRUISE, AFTER SETTING CRUISE POWER AND PACKS TO NORM CABIN FILLED WITH SMOKE. LAV SMOKE ALARM ACTIVATED. RAN RIGHT PACK ON GROUND FOR SEVERAL MINUTES, PACK OPERATES NORMAL. COULD NOT DUPLICATE DISCREPANCY.SDR SWIA200413091Computer · malfunctionedRIGHT AFTER TAKEOFF TRIM FAIL LIGHT ILLUMINATED ON MAP AND TRIM LIGHT ON FCP AND SINGLE CHIME. ALL LIGHTS WENT OUT WHEN AUTOPILOT WAS SWITCHED TO FIRST OFFICER'S SIDE. ALL ILLUMINATED AGAIN WHEN SWITCHED BACK TO CAPTAIN'S SIDE. REMOVED AND REPLACED APC NR 1SDR SWIA200412771Hydraulic System · lowLEFT (GREEN) HYDRAULIC SYSTEM LOW LEVEL LIGHT ILLUMINATED. QUANTITY GAUGE READ ZERO. (MADE EMERGENCY LANDING DEN) SERVICED HYDRAULIC SYSTEMS. RAN ENGINES, SWUNG GEAR AND OPERATED ALL GREEN HYDRAULIC SYSTEM COMPONENTS. OPS CHECKS GOOD.SDR SWIA200312644Computer · malfunctionedCAPTAINS FLIGHT DIRECTOR COMMAND BARS PITCH UP ABRUPTLY IN FLIGHT TO 20 DEGREES AND NOSE UP AND 20 DEGREES LEFT AND RIGHT TURN. INSTALLED SERVICEABLE AUTOPILOT COMPUTER ON CAPTS SIDE. OPS CHECK GOOD.SDR SWIA200312405Frame · crackedRT FRAME 9 CRACKED BY FO'S O2 STORAGE BOX, UPPER RADIUS. (DISCOVERED DURING C-CHECK INSPECTION) COMPLIED WITH SERVICE BULLETIN NR 120-53-0073 IAW EMB SRM 51-40-00 THRU 51-40-08.SDR SWIA200312404Channel · crackedBLUE HYDRAULIC PACK LOWER SUPPORT CHANNEL CRACKED IB EDGE. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED LOWER SUPPORT CHANNEL WITH SERVICEABLE UNIT FOR BLUE HYDRAULIC PACK.SDR SWIA200312403Bracket · crackedCRACKED BRACKET AT CAPTAIN'S DV WINDOW AFT FRAME. (DISCOVERED DURING C-CHECK INSPECTION)REMOVED AND REPLACED CAPTAIN'S DV WINDOW AFT FRAME BRACKET WITH A SERVICEABLE UNIT IAW EMB SRM 51-10-02.SDR SWIA200312402Clip · crackedRIGHT OUTBOARD WING, STATION 15, LOWER WING CLIP (FWD OF MIDDLE CLIP) CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED LOWER WING SUPPORT CLIP (FWD OF MIDDLE CLIP) OF RIGHT OUTBOARD WING RIB 15 PER MM 28-10-00.SDR SWIA200312401Clip · crackedRIGHT OUTBOARD WING, STATION 15, LOWER WING CLIP (MIDDLE) CRACKED AT FWD END. (DISCOVERED DURING C-CHECK INSPECTION)REMOVED AND REPLACED RIGHT OUTBOARD WING, STATION 15, LOWER WING MIDDLE CLIP WITH A SERVICEABLE UNIT IAW EMB SRM 51-40-01 & 51-40-02.SDR SWIA200312235Battery Pack · dischargedFORWARD EMERGENCY LIGHTS INOP. REMOVED AND REPLACED FWD EMERGENCY BATTERY PACK IAW 33-50-02. OPS CHECKS GOOD.SDR SWIA200311771Wire · shortedFDAU AND DFDR LIGHTS CAME ON IN FLIGHT. CIRCUIT BREAKER FOR FDAU FOUND POPPED AND SMELLED SMOKE AT THE SAME TIME. FOUND W501-0018-22 SHORTING TO GROUND FROM LEFT AILERON RIVET INSIDE WHEEL WELL. REPAIRED WIRE IAW WM 20-00-00. OPS CHECK OF FDAU AND DFDR GOOSDR SWIA200311712Pressure Switch · malfunctionedMIDDLE RIGHT WING DEICE BOOT LIGHT CAME ON INFLIGHT, BOTH TIMERS. RETURNED TO SLC. REMOVED AND REPLACED THE PRESSURE SWITCH FOR THE RIGHT MIDDLE WING DEICER. RAN THE ENGINES AT ALL POWER SETTINGS. NO FAULTS NOTED AT THIS TIME. P/N OFF: 211C117-183, S/N OSDR SWIA200211602Wire Harness · malfunctionedON CLIMBOUT THE RT ENGINE TQ STARTED TO FLUCTUATE 5 PERCENT TO 20 PERCENT. PERFORMED PRECAUTIONARY ENGINE SHUTDOWN AND RETURNED TO THE FIELD. REPLACED RIGHT ENGINE EEC ELECTRICAL WIRING HARNESS IAW PW MM 22-01-10. ALL OPS CHECKS GOOD. P/N: 3115911-01 SN OFSDR SWIA200211010Relay · failedNR 1 INVERTER FAILED DURING CLIMBOUT. FOLLOWED QRH PROCEDURE BUT INVERTER WOULD NOT RESET. RETURNED TO SLC. REMOVED AND REPLACED RELAY K0001 IAW WM 24-20-00. OPS CHECKS GOOD.SDR SWIA200210770Oil System · lowAFTER TAKEOFF, AT ABOUT 1500 AGL, THE LEFT ENGINE OIL AURAL WARNING CAME ON. CONCURRENTLY HEARD RCCB'S CLICKING AND THE OIL NEEDLE FLUCTUATED. RETURNED TO DEN. ADDED 4 QUARTS OF OIL AND COMPLIED WITH ST72-344. NO DEFECTS NOTED. LEAK CHECK GOOD.SDR SWIA200210738Switch · out of adjustFORWARD DOOR RED LIGHT ON OVERHEAD PANEL CAME ON AT START OF TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO THE GATE. ADJUSTED MICROSWITCHES ON FORWARD DOOR AS NEEDED. OPS CHECK GOOD.SDR SWIA200110410Pressure Switch · failedRIGHT SIDE ENGINE AIR INLET DEICE BOOT FAILED, AMBER LIGHT. RE-ATTEMPTS AT DIFFERENT POWER SETTINGS, ALL FAILED. RETURNED TO DENVER. INSTALLED SERVICEABLE RT ENGINE AIR INLET PRESSURE SWITCH. OPS CHECK GOOD.SDR SWIA200110385Actuator · failedRIGHT NACELLE FLAP WOULD NOT RETRACT AFTER LANDING. REPLACED RIGHT NACELLE FLAP ACTUATOR. OPS CHECK GOOD.SDR SWIA972502Venturi · blownINFLIGHT, WHEN PACKS (A/C) ARE SELECTED TO NORM, A BURNING PACK ODOR OCCURS. INSPECTED A/C PACKS. FOUND RIGHT VENTURI BLOWN OUT. REPLACED WITH SERVICEABLE UNIT. RAN BOTH PACKS. NO DISCREPANCIES NOTED AT THIS TIME.SDR SWIA972447Door Seal · unsecureAFTER DEPARTURE FROM BOI CLIMBING THROUGH 20,000 FEET LOST PRESSURIZATION. FLIGHT ATTENDANT HEARD LOUD NOISE COMING FROM CARGO AREA. RETURNED TO BOI. FOUND CARGO DOOR SEAL NOT SECURED. INSTALLED SEAL IAW MM 52-30-01. PRESSURIZATION CHECK OK. OK FOR SERVISDR SWIA972360Actuator · jammedAT FL250 WITH AUTOPILOT ENGAGED THE YELLOW TRIM LIGHT ON AUTOPILOT PANEL ILLUMINATED. DISCONNECTED THE AUTOPILOT AND MANUALLY MOVED THE TRIM WHEEL AND FOUND IT TO BE JAMMED. TRANSFERRED AUTOPILOT TO CAPTAIN SIDE AND THE SAME OCCURRED. DISCONNECTED AUTOPILOTSDR SWIA972193Regulator · failedLEADING EDGE ICE PROTECTION TIMER 1 FAILED IN FLIGHT BOTH LIGHT AND HEAVY. RETURNED TO SBA. INSTALLED SERVICEABLE 18 PSI REGULATOR FOR NUMBER TWO SIDE IAW 30-1-00. RAN ENGINE ON GROUND FOR 20 MINUTES. OPS CHECK GOOD. SN ON B2423SDR SWIA972157Regulator · failedTHREE MINUTES AFTER TAKE OFF, LEFT DUCT LEAK LIGHT ILLUMINATED. FOLLOWED QRH PROCEDURE 6:39 LIGHT REMAINED ILLUMINATED. AFTER 3 MINUTES, SHUT DOWN ENGINE (LEFT). LIGHT EXTINGUISHED AT THAT TIME. RESTARTED LEFT ENGINE WITH LEFT BLEED/PACK OFF. RETURNED TO LSDR SWIA972078Engine · lack of lubeOIL PRESS ''ONE'' LIGHT CAME ON WITH AURAL WARNING AT 70 KNOTS. ABORTED TAKEOFF. INSPECTED LEFT ENGINE AND FOUND TO BE ONE AND ONE HALF QUARTS LOW ON OIL. ADDED OIL AND GROUND RAN ENGINE. OIL PRESSURE OK. NO WARNING LIGHT OR AURAL WARNING. RETURN TO SERVSDR SWIA972018Fan · failedAN ELECTRICAL SMELL WAS PRESENT AT SEATS 2A AND 3A WHEN THE GASPER FANS EYEBALLS WERE TURNED OPEN. DEFERRED THE GASPER FAN. MEL 21-24-1 PRI ''C'' DUE:10/19/00 SMOKE (SMALL DEGREE) IN CABIN. LAVATORY ALARM WAS ACTIVATED AND FLIGHT ATTENDANT NOTICED NO SMOKESDR SWIA971980Warning System · activatedAFTER STATIC TAKEOFF PASSING THROUGH 70 KNOTS, TRIPLE CHIME AND AURAL ''OIL'' HEARD AT APPROXIMATELY 40 PSI. ABORTED TAKEOFF AND OIL PRESSURE RETURNED TO GREEN RANGE (60 + PSI). DISCONNECTED CANNON PLUGS P0943 AND P0308, INSPECTED AND MEGGED WIRING ASSOCIATESDR SWIA971932Warning System · activatedUPON ROTATION, LEFT ENGINE AURAL ''OIL'' OCCURRED WITH NO CORRESPONDING LOW OIL PRESSURE INDICATION. APPROXIMATELY 10 SECONDS LATER, OIL PRESSURE BEGAN FLUCTUATING WITHIN THE GREEN ARC WITH NO FURTHER AURAL WARNINGS. RETURNED TO SBP. OIL LEVELS SATISFACTORY.SDR SWIA971887Nut · looseRIGHT ENGINE HUB RETAINING NUTS LOOSE, FOUND DURING INSPECTION. REPLACED RT ENG PROP WITH SERVICEABLE UNIT. RII 61-301PN ON: RFC11M16A SN: 857876 SN OFF: 885659 PN ON: RFC11M16A SN: 8880996A SN OFF: 888144 PN ON: RFC11M16A SN: 887900 SN OSDR SWIA971846Light · damagedEMERGENCY LIGHT EXIT SIGN AT ROW NINE SMASHED AND TWO EXIT ROW SIGNS AT ROW NINE ARE INOP. REPLACED LOWER EXIT SIGN AT ROW 9BC AND PERFORMED OPS CHECK OF ALL LIGHTS. OPS CHECKS GOOD.SDR SWIA971551Control Handle · malfunctionedAFTER TAKEOFF, WHEN FLAPS SELECTED UP, INBOARD FLAP PAIRS IN DISAGREEMENT WITH OUTBOARD AND NACELLE. QUICK REFERENCE HANDBOOK PROCEDURE INEFFECTIVE. OPERATES NORMAL ON GROUND AFTER RETURNING TO SJC. REPLACED FLAP CONTROL HANDLE AND RERACKED FLAP CONTROL UNISDR SWIA971312Fcu · malfunctionedAFTER TAKEOFF AND FLAP RETRACTION, FLAP DISAGREEMENT COULD NOT FIX. RETURNED TO SFO. REPLACED FCU, OPS CHECKS GOOD.
Back to N298SW, cancelled Jan 17, 2018