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.

SDR SWAA2015042739031Stringer Splice · crackedSPLICE STRAP CRACKED AT BS 360, STRINGER 3R. REPAIRED STRAP IAW EA.Mar 10, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Longeron/StringerSDR SWAA2015052740073Channel · corrodedR2 DOOR CREASE BEAM SUPPORT CHORD ANGLE TEE CHANNEL CORRODED BETWEEN BS 986.5 - 1001.5, RBL 41. R & R TEE CHANNEL IAW SRM & DWG.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015051939841Web · corrodedAFT PIT DOOR CUT OUT UPPER SILL BEAM INBD VERTICAL WEB CORRODED AT BS 829, STRINGER 18R. R & R WEB IAW SRM & DWG.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015050539310Support · crackedFORWARD PIT RT SIDE LONGITUDINAL FLOOR TO SIDEWALL SUPPORT CRACKED BETWEEN BS 492 - 500A. R & R SUPPORT IAW SRM & DWG.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015042739030Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, STRINGER 27L. R & R SHEAR IAW SRM & DWG.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Internal Mounting StructureSDR SWAA2015033037981Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 14L. R & R SPLICE IAW SRM & DWG.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Longeron/StringerSDR SWAA2015032037676Crease Beam · crackedRIGHT INNER CREASE BEAM CRACKED AT BS 616. REPAIRED CREASE BEAM IAW SRM & AMM.Mar 9, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, StructureSDR SWAA2015052740072Stringer Clip · crackedAFT CARGO PIT STRINGER CLIP CRACKED AT BS 947L, STRINGER 26L. R & R CLIP IAW DWG & EA.Mar 8, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Attach FittingsSDR SWAA2015040738186Support Fitting · crackedAFT CARGO PIT BULKHEAD SUPPORT CLIP CRACKED AT BS 947, STRINGER 22L. R & R CLIP IAW DWG & SRM.Mar 8, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015051439682Intercostal · corrodedAFT CARGO COMPARTMENT FLOOR FRAME INTERCOSTAL WEB CORRODED AT BS 767, BETWEEN STRINGER 26R - 25R. R & R WEB IAW DWG & SRM.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015051339637Stringer · crackedSTRINGER CRACKED AT BS 1016, STRINGER 5R. R & R STRINGER IAW EA.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Longeron/StringerSDR SWAA2015050839470Support · corrodedAFT CARGO PIT INTERNAL VHF 3 ANTENNA SUPPORT STRUCTURE CORRODED AT BS 727E, BETWEEN STRINGER 27L - 27R. R & R SUPPORT IAW EA.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015050639360Frame · crackedFRAME WEB CRACKED AT BS 344, STRINGER 8R. REPAIRED WEB IAW EA.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015042939126Support · corrodedFORWARD CARGO COMPARTMENT SPLICE SUPPORT CORRODED AT BS 500, BETWEEN STRINGER 24L - 26L. R & R SUPPORT IAW SRM & DWG.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015040938324Beam · corrodedAFT CARGO COMPARTMENT CARGO FLOOR STRUCTURE CORRODED AT BS 796, LBL 8. REPAIRED BEAM IAW SRM.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015032037675Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500, STRINGER 22L. R & R CLIP IAW SRM & DWG.Mar 7, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Attach FittingsSDR SWAA2015051139530Skin · crackedL1 DOOR CUT OUT AFT LOWER THRESHOLD SKIN FASTENER HOLE CRACKED. REPAIRED SKIN IAW EA.Mar 6, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Plate/SkinSDR SWAA2015050539309Plate · corrodedAFT CARGO BAY DOOR THRESHOLD COVER PLATE CORRODED ER HOLES BETWEEN BS 805 - 809, BETWEEN STRINGER 24R - 25R. R & R PLATE IAW DWG.Mar 6, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015060340340Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 967 - 970. REPAIRED CREASE BEAM IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, StructureSDR SWAA2015060340339Stringer · crackedLEFT STRINGER 18A CRACKED AT STATION 727. REPAIRED STRINGER IAW EA.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, Longeron/StringerSDR SWAA2015060240310Strap · crackedLEFT FUSELAGE FRAME STRAP CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015060240298Strap · crackedRIGHT FUSELAGE FRAME STRAP CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015060240297Frame · crackedRIGHT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015060240294Frame · crackedLEFT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015052740071Door Frame · crackedR1 GALLEY DOOR FWD LOWER REVEAL FRAME CRACKED AT BS 295, BETWEEN STRINGER 15R - 17R. R & R FRAME IAW SRM & DWG.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, StructureSDR SWAA2015051839806Crease Beam · corrodedMAIN CABIN COMPARTMENT, R2 LOWER DOOR CUT OUT UPPER CREASE BEAM CORRODED BETWEEN BS 950 - 996, RBL 52. R & R CREASE BEAM IAW SRM & DWG.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, StructureSDR SWAA2015042438887Frame · crackedFORWARD INTERIOR FUSELAGE, AFT SIDE OF FRAME WEB CRACKED AT BS 277, STRINGER 5L. R & R WEB IAW DWG & SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015042438874Angle · crackedFORWARD INTERIOR FUSELAGE AFT SIDE OF FRAME WEB ATTACH CLIP ANGLE CRACKED AT BS 277, STRINGER 5L. R & R CLIP IAW SRM & DWG.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015041638586Frame · crackedFRAME WEB CRACKED BS 294.5, STRINGER 6R. REPAIRED FRAME SECTION IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Main, FrameSDR SWAA2015032337687Seat Track · crackedPASSENGER CABIN FLOOR STRUCTURE, OTBD SEAT TRACK, INBD LOWER FLANGE, UPPER SURFACE CORRODED AT BS 328, RBL 52. R & R SEAT TRACK IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage, Seat/Cargo Attach FittingsSDR SWAA2015031737491Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 326, RBL 32. R & R INTERCOSTAL IAW SRM.Mar 5, 2015 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2015042739029Wedge · delaminatedLEFT WING TE INBD MID FLAP TE WEDGE, 30" OTBD FROM INBD EDGE BOTH SKINS DELAMINATED. REPAIRED WEDGE IAW WO.Mar 4, 2015 · N697SW · Boeing 7373T0 · Trailing Edge FlapsSDR SWAA2015022336822Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.Feb 19, 2015 · N697SW · Boeing 7373T0 · Escape SlideSDR SWAA2015022336821Door Frame · crackedR1 DOOR LOWER EDGE FRAME CRACKED AT LOWER AFT CORNER STOP FITTING. R & R DOOR IAW AMM.Feb 19, 2015 · N697SW · Boeing 7373T0 · Service DoorsSDR SWAA2015022336820Slat · crackedLEFT WING NR 2 SLAT CRACKED. R & R SLAT IAW MM.Feb 19, 2015 · N697SW · Boeing 7373T0 · Leading Edge DevicesSDR SWAA2014093032492Door · looseFIRST OFFICER'S ESCAPE ROPE DOOR LATCH LOOSE. SECURED ESCAPE ROPE DOOR IAW SIP.Sep 25, 2014 · N697SW · Boeing 7373T0 · Emergency EquipmentSDR SWAA2014071630038Strip · dirtyAFT CABIN FLOOR EMER EXIT STRIP DIRTY. CLEANED STRIP IAW AMM.Jul 15, 2014 · N697SW · Boeing 7373T0 · Emergency LightingSDR SWAA2014071630037Light · inoperativeRIGHT CABIN EMER BULLNOSE LIGHT INOPERATIVE AT ROW 19. REPAIRED LIGHT IAW MM.Jul 15, 2014 · N697SW · Boeing 7373T0 · Emergency LightingSDR SWAA2014052728371Light · inoperativeAFT SERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.May 24, 2014 · N697SW · Boeing 7373T0 · Emergency LightingSDR SWAA2014052728370Light · inoperativeAFT ENTRY DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.May 24, 2014 · N697SW · Boeing 7373T0 · Emergency LightingSDR SWAA2014052728369Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 680 TO BS 681, STRINGER 10R. REPAIRED SKIN IAW ER & EA.May 21, 2014 · N697SW · Boeing 7373T0 · Fuselage Main, Plate/SkinSDR SWAA2014032426425Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.Mar 20, 2014 · N697SW · Boeing 7373T0 · Escape SlideSDR SWAA2014021725222Girt Bar · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW MT.Feb 13, 2014 · N697SW · Boeing 7373T0 · Emergency EquipmentSDR SWAA2014021325114Slide · looseR1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.Feb 11, 2014 · N697SW · Boeing 7373T0 · Escape SlideSDR SWAA2014010223677Frame · crackedLT WING NR 1 FAIRING FLAP TRACK FRAME CRACKED. R & R FRAME IAW DRAWING & SRM.Dec 12, 2013 · N697SW · Boeing 7373T0 · Trailing Edge FlapsSDR SWAA2013121823507Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 16L. R & R TIE CLIP IAW SRM & DRAWING.Dec 10, 2013 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2013121923543Channel · crackedRT MAIN WW AREA CHANNEL CRACKED. R & R CHANNEL IAW SRM & DRAWING.Dec 9, 2013 · N697SW · Boeing 7373T0 · Fuselage Miscellaneous StructureSDR SWAA2013121723438Plate · crackedLT WING NR 3 SIDE TRACK FIXED TE PLATE CRACKED. R & R PLATE IAW DRAWING & SRM.Dec 8, 2013 · N697SW · Boeing 7373T0 · Leading Edge DevicesSDR SWAA2013121623383Plate · crackedFWD CARGO COMPARTMENT PLATE CRACKED BETWEEN SIDEWALL PANEL 1321X & FLOOR PANEL 1326X. R & R PLATE IAW SRM & DRAWING.Dec 8, 2013 · N697SW · Boeing 7373T0 · Cargo/Baggage DoorsSDR SWAA2014010223676Frame · crackedFRAME CRACKED AT BS 348.2 STRINGER 15L. R & R FRAME IAW EA.Dec 7, 2013 · N697SW · Boeing 7373T0 · Fuselage Main, Frame
Back to N697SW, cancelled Oct 5, 2019