N645SW, cancelled Nov 20, 2017

Service difficulty reports · 286

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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20'
  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 SWAA2014071430031Lens · missingRIGHT EEPLS LENS MISSING AT ROW. INSTALLED LENS IAW AMM.Jun 23, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014072130178Frame · crackedFUSELAGE FRAME CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW ER & EA.Jun 21, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014072130177Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW ER & EA.Jun 21, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2014071630030Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD LT CORNER OF AIR CONDITIONER DOOR CUT OUT. REPAIRED CUT OUT IAW SRM.Jun 21, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014052728378Light · inoperativeLEFT EMERGENCY EXIT LIGHTS AT OVERHEAD BULLNOSE BIN INOPERATIVE BETWEEN ROW 6 TO ROW 22. RELAMPED LIGHTS IAW AMM.May 25, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014052728377Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT SIGN OVER RT AFT DOOR INOPERATIVE. RELAMPED SIGN IAW AMM.May 25, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014052728376Sign · inoperativeL2 DOOR EXTERIOR EMERGENCY AFT AISLE EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.May 25, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014052728375Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHTS IAW AMM.May 25, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014051628066Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 460, STRINGER 2R. R & R CLIP IAW DWG.May 14, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA2014051928133Stringer · crackedSTRINGER CRACKED AT BS 532, STRINGER 4R. REPAIRED STRINGER IAW SB.May 11, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2014052728359Buttstrap · crackedBUTT STRAP CRACKED AT BS 360+.5, STRINGER 14R. REPAIRED BUTT STRAP IAW EA.May 5, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014052128194Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.May 5, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014051428012Shear Tie · crackedSHEAR TIE CRACKED AT BS 540, STRINGER 10L. R & R SHEAR TIE IAW SRM & DWG.Apr 26, 2014 · N645SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2014050827812Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827811Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827810Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827809Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827808Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827814Skin · crackedLEFT BS 807+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050827813Skin · crackedLEFT BS 767+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727766Skin · crackedLEFT BS 887+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727765Skin · crackedLEFT BS 827+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727764Skin · crackedLEFT BS 867+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727761Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727747Skin · crackedRIGHT BS 807+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727746Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014050727745Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.Apr 19, 2014 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2014032026276Lens · brokenRIGHT OVERWING EMERGENCY EXIT SIGN LIGHT LENS COVER BROKEN. R & R LIGHT ASSEMBLY IAW AMM.Mar 18, 2014 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2014012324492Skin · crackedLT WING NR 2 SLAT LOWER SURFACE LE CRACKED. REPAIRED NR 2 SLAT IAW SRM.Jan 20, 2014 · N645SW · Boeing 7373H4 · Leading Edge DevicesSDR SWAA2014012224423Fairing · damagedRT WING NR 8 FLAP TRACK AFT FAIRING INBD HINGE RELIEF HOLE DAMAGED. REPAIRED FAIRING IAW EA.Jan 20, 2014 · N645SW · Boeing 7373H4 · Trailing Edge FlapsSDR SWAA2014012224420Flap · delaminatedRT WING OTBD FORE FLAP OTBD END DELAMINATED. R & R FORE FLAP IAW AMM.Jan 20, 2014 · N645SW · Boeing 7373H4 · Trailing Edge FlapsSDR SWAA2014012224419Fairing · crackedLT ELEVATOR TAB UPPER FAIRING CRACKED. R & R FAIRING IAW DRAWING & SRM.Jan 20, 2014 · N645SW · Boeing 7373H4 · Elevator, Tab StructureSDR SWAA2014012224418Skin · delaminatedLT WING NR 0 SPOILER UPPER SURFACE DELAMINATED. R & R NR 0 SPOILER IAW AMM.Jan 20, 2014 · N645SW · Boeing 7373H4 · SpoilersSDR SWAA2013100720803Skin · delaminatedLT WING NR 1 FLIGHT SPOILER TE UPPER SURFACE DELAMINATED. R & R SPOILER IAW MM.Oct 2, 2013 · N645SW · Boeing 7373H4 · SpoilersSDR SWAA2013090519875Flap · delaminatedLT WING OTBD TE FLAP DELAMINATED. R&R AFT FLAP IAW AMM.Sep 4, 2013 · N645SW · Boeing 7373H4 · Trailing Edge FlapsSDR SWAA2013081919340Housing · defectiveLT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 17. R&R LIGHT HOUSING IAW AMM.Aug 17, 2013 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2013080718918Light · inoperativeLT WING AFT EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.Aug 4, 2013 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2013080718917Skin · crackedSKIN CRACKED AT BS 520 + 5, STRINGER 10L. REPAIRED SKIN IAW SRM.Aug 4, 2013 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2013070817985Battery · failedAFT EMERGENCY BATTERY PACK FAILED OPERATIONS TEST. R&R BATTERY IAW AMM.Jul 5, 2013 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2013062717665Shear Tie · crackedSHEAR TIE CRACKED AT BS 211. R&R SHEAR TIE IAW EA & DRAWING.Jun 19, 2013 · N645SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2013070817984Frame · damagedFRAME OTBD T CHORD DAMAGED AT STATION 243, STRINGER 17L. R&R T CHORD IAW SRM & DRAWING.Jun 7, 2013 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2013070117805Crease Beam · missingCREASE BEAM WEB MISSING BETWEEN STA 235 TO STA 243, STR 17L. INSTALLED WEB IAW SRM AND DWG.Jun 7, 2013 · N645SW · Boeing 7373H4 · Fuselage Main, StructureSDR SWAA2013070817983Battery · dischargedFWD OTBD EMERGENCY FLASHLIGHT INOPERATIVE. R&R BATTERY IAW MM.Jun 6, 2013 · N645SW · Boeing 7373H4 · Emergency EquipmentSDR SWAA2013052216330Attach Fitting · brokenLT WING NR 4 GROUND SPOILER ATTACH FITTING BROKEN. R & R SPOILER IAW MM.May 17, 2013 · N645SW · Boeing 7373H4 · SpoilersSDR SWAA2013031513693Fire Detector · faultyAIR TURNBACK / DECLARED EMERGENCY. FWD CARGO COMPARTMENT FIRE WARN ALARM SOUNDED. C/W WITH FWD CARGO COMPT INSPECTION. NO DEFECT FOUND. REMOVED AND REPLACED FIRE WARN NR 1, 2, 3 & 4 DETECTORS PER MM.Mar 15, 2013 · N645SW · Boeing 7373H4 · Fire DetectionSDR SWAA2013010911319Indicator · faultyDECLARED EMERGENCY -- ON APPROACH SELECTING FLAPS 5, INDICATION STOPPED AT FLAPS 2 DEGREE. SELECTED FLAPS 10 DEGREE, INDICATION REMAINED AT FLAPS 2. SELECTED FLAPS 15 DEGREE, INDICATION REMAINED AT FLAPS 2. AFTER 2-3 MINUTES FLAPS INDICATION WENT TO FLAPS Jan 6, 2013 · N645SW · Boeing 7373H4 · Trailing Flap Position Indicating SystemSDR SWAA2012092507954Skin · crackedFUSELAGE CRACKED AT BS 500C+11, STR 10L. REPAIRED SKIN PER EA.Sep 22, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Plate/SkinSDR SWAA2012071205716Engine · failedINFLIGHT SHUTDOWN/DECLARED EMERGENCY. NR 2 ENGINE ROLLED BACK TO 18 PERCENT N1 AT 34K FLT. NO RESTART ATTEMPT MADE DUE TO SUSPECTED SMOKE REPORTED BY PAX. REMOVED AND REPLACED NR 2 ENGINE PER MM.Jul 12, 2012 · N645SW · Boeing 7373H4 · Engine (Turbine/Turboprop)SDR SWAA2012062505269Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.Jun 15, 2012 · N645SW · Boeing 7373H4 · Emergency LightingSDR SWAA2012062505268Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.Jun 15, 2012 · N645SW · Boeing 7373H4 · Emergency Lighting
Back to N645SW, cancelled Nov 20, 2017