N697SW, cancelled Oct 5, 2019
Service difficulty reports · 430
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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 SWAA042718Skin · corrodedDURING SPV, FOUND FUSELAGE SKIN AT BS 727D, RBL 1, WL 148, CORRODED. REPAIRED SKIN PER ER.SDR SWAA042520Frame · crackedDURING SPV, FOUND FRAME AT LEFT BS 188, WL 207, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA042519Bulkhead · crackedDURING SPV, FOUND BULKHEAD WEB AT BS 178, RBL 10, WL, 234, CRACKED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA041148Lens · looseDURING SCHEDULED C3 CHECK, FOUND RT EMERGENCY EXIT DOOR LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA040136Wedge · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING NR 2 SLAT OUTBOARD T/E WEDGE DELAMINATED. REPAIRED SLAT WEDGE PER SA-M 604.SDR SWAA040127Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA040126Skin · crackedDURING SCHEDULED C2 CHECK, FOUND SKIN CRACKED AT BS 737, STRINGER 19R. REPAIRED SKIN CRACK PER SRM.SDR SWAA032651Controller · faultyR1 COCKPIT WINDOW BURNED AND CRACKED. REMOVED AND REPLACED R1 COCKPIT WINDOW ASSY AND HEAT CONTROLLER.SDR SWAA032164Line · crackedDECLARED EMERGENCY, ENGINE NR 1 'A' HYD LOW PRESS LIGHT ILLUMINATED AND PUMP WAS TURNED OFF. FOUND 'A' SYSTEM PRESS LINE IN PYLON CRACKED. REMOVED AND REPLACED HYD LINE PER MM.SDR SWAA031493Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT INBD T/E FOREFLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED LT INBD T/E FOREFLAP PER MM.SDR SWAA031492Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 3 L/E SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 3 L/E SLAT PER MM.SDR SWAA031489Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 6 L/E SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 6 L/E SLAT PER MM.SDR SWAA031491Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031490Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031220Relay · faultyNOSE GEAR UNSAFE LIGHT IS ILLUMINATED WHEN GEAR IS RETRACTED. REMOVED AND REPLACED NOSE GEAR LATCHING RELAY AND M983 GEAR RED LIGHT CARD PER MM.SDR SWAA030694Bushing · wornDURING SCHEDULED C3 CHECK, SWA SI 11139-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR INBD TAB HINGE HARDWARE AND BUSHING PER MM.SDR SWAA023027Flashlight · inoperativeEMERGENCY FLASHLIGHT AT AFT CABIN STATION INOP. REMOVED AND REPLACED EMERGENCY FLASHLIGHT PER MM.SDR SWAA022968Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR INBD AND OUTBOARD FRAMES CRACKED. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA022484Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 773, RBL 10 TO LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA022439Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, BETWEEN STR 16R AND STR 17R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA021214Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF THE CONTAINER INADVERTENTLY. REINSTALLED SLIDE PER MM.SDR SWAA021196Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 180, WL 181.5 AND RBL 5.7. REPAIRED WEB PER SRM.SDR SWAA021000Slide · out of positionDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020998Bolt · wornDURING SCHEDULED C4 CHECK, FOUND LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB PUSH ROD BOLT PER MM.SDR SWAA020997Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT T/E OUTBOARD AFT FLAP DELAMINATED AT INBOARD T/E CORNER. REMOVED AND REPLACED RT T/E OUTBOARD AFT FLAP PER MM.SDR SWAA020775Sensor · out of adjustNOSE GEAR RED LIGHT DID NOT EXTINGUISH ON TAKEOFF. RECYCLE HANDLE, NO HELP. PULLED AND RESET AIR/GRD RELAY CB AND LIGHT WENT OUT. ADJUSTED NOSE GEAR LOCK SENSOR PER MM.SDR SWAA020297Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED GIRT ASSY PER MM.SDR SWAA012815Pmc · erraticAIR TURNBACK, DURING CLIMBOUT PASSING 10,000 FT, NR 1 ENG SURGED TO 107.9 PERCENT N1, EGT CLIMBED TO 930 DEGREES, ENG STABILIZED AT RETARDED THROTTLE, PMC LIGHT ON. BORESCOPE ACCOMPLISHED, NO DEFECTS NOTED PER MM. REMOVED AND REPLACED NR 1 ENG PMC PER MM.SDR SWAA012772Engine · overheatedNR 1 ENGINE OVERHEAT LIGHT ILLUMINATED DURING CRUISE. REDUCED THROTTLE TO IDLE AND LIGHT WENT OUT. ON THE GROUND EGT WAS 680 AND OIL PRESS WAS 18 - 20 PSI. SHUT NR 1 ENGINE DOWN. REMOVED AND REPLACED NR 1 ENGINE PER MM.SDR SWAA011201Skin · crackedDURING SCHEDULED C4 CHECK, FOUND NR 6 L/E SLAT SKIN CRACKED AT AFT ROW OF FASTENERS, 4 FROM OUTBD END. REPAIRED SLAT PER SRM.SDR SWAA002754Sign · missingLEFT MID CABIN EMERGENCY EXIT SIGN MISSING LENS CAP. INSTALLED LENS AND SECURED SIGN PER MM.SDR SWAA002189Slide · dislodgedDURING SCHEDULED RON , FOUND FWD SVC DOOR GIRT BAR FELL FROM SLIDE COVER UPON DOOR OPERATION. RE-STOWED GIRT BAR PER MM.SDR SWAA001892Indicator · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000910Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 1 AND NR 4 L/E SLATS LOWER SKIN CRACKED AROUND ACTUATOR CUTOUT. REPAIRED SKIN PER BOEING DRAWING AND TI-657-012.SDR SWAA000900Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD LT SIDE CHORD CRACKED, WL 207. REPAIRED CHORD SECTION PER SRM.SDR SWAA000896Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 733 FLOORBEAM CORRODED, RBL 8. REPAIRED BEAM PER SWA RA NR1-353-2021.SDR SWAA000462Keel Beam · corrodedDURING SCHEDULED SERVICE CHECK, FOUND KEEL BEAM CORRODED, BS 520 RT SIDE. REPAIRED BEAM PER SWA RA NR 1-353-2233.SDR SWAA000446Girt Bar · looseDURING SCHEDULED C4 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE GIRT EXTENDED PAST LIMITS. REINSTALLED SLIDE ASSY PER MM.SDR SWAA991778Battery · dischargedLT FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA991579Connector · looseFWD ENTRY EXTERIOR EMERGENCY ESCAPE LIGHT BEZEL LOOSE AND INOP. RESEATED CONNECTOR ON M1132 BATTERY PACK PER MM. OPS CK GOOD.SDR SWAA991104Light · inoperativeEMERGENCY ESCAPE FLOOR LIGHT INOP ON AFT SECTION. REMOVED AND REPLACED FLOOR LIGHT PER MM.SDR SWAA990980Cover · brokenDURING SCHEDULED C1 CHECK, FOUND EMERGENCY ESCAPE FLOOR TRACK LIGHT COVER BROKEN BETWEEN ROWS 8 AND 21. REMOVED AND REPLACED COVER PER MM.SDR SWAA990924Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND EMERGENCY ESCAPE FLOOR TRACK LIGHTS INOP AT ROWS 1 THRU 6. REPAIRED WIRING PER MM.SDR SWAA990283Air Dist · odorDURING CRUISE, CREW NOTICED FAINT ELECTRICAL ODOR. ALL ELECTRICAL INDICATIONS NORMAL EXCEPT NR 1 GENERATOR DRIVE RISE INDICATED 25 TO 30 DEGREE CELSIUS. DURING APU START HAD APU FIRE WARNING INDICATION, APU EGT 380 DEGREE CELSIUS. PULLED APU FIRE HANDLE ANDSDR SWAA990281Bulb · failedDURING SCHEDULED C4 CHECK, FOUND 2 EGRESS LIGHTS INOP AND HAVE MISSING LENSES. REPLACED LENSES AND RELAMPED EGRESS LIGHTING PER MM.SDR SWAA990233Battery · dischargedALL EMERGENCY EXIT FLOOR TRACK LIGHTS FWD OF THE OVERWING EXIT ARE INOP. REMOVED AND REPLACED BATTERY AND BASE PER MM, OPS CHECKS GOOD.SDR SWAA990221Fire Loop · failedEN ROUTE TO MDW, CREW STARTED APU AT FL250; APU FIRE LIGHT ILLUMINATED FOR APPROX 5-10 SECONDS. FIRE LIGHT EXTINGUISHED WITH NO CREW ACTION, ACCOMPLISHED QRH FOR APU FIRE. FIRE HANDLE PULLED; BOTTLE NOT DISCHARGED. INSPECTED APU FIRE LOOPS, NO DEFECTS NOTEDSDR SWAA983149Bulb · failedDURING PREFLIGHT, FOUND EMERGENCY FLOOR TRACK HAS TWO LIGHTS INOP. RELAMPED AND OPS CKS GOOD PER M/M.SDR SWAA982722Lamp · failedDURING SCHEDULED SERVICE CHECK, FOUND FWD CARGO LIGHT INOPERATIVE. REMOVED AND REPLACED NEW LAMP PER BOEING MM.SDR SWAA982652Bulb · failedDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT RED ROW LIGHT INOP. RELAMPED PER BOEING M/M.
Back to N697SW, cancelled Oct 5, 2019