N509SW, cancelled Mar 27, 2018

Service difficulty reports · 270

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 = 'N509SW' AND deregistration_id = 'N509SW-2018-03-27'
  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 SWAA2012050103623Skin · delaminatedLT WING NR 3 SLAT DELAMINATED ON OUTBOARD END UPPER SURFACE. REPAIRED NR3 SLAT IAW SRM.Mar 24, 2012 · N509SW · Boeing 7375H4 · Leading Edge DevicesSDR SWAA2012041603136Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 20L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 24, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012041102997Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 24, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012040902862Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 24, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012050103617Structure · corrodedCHORD CORRODED AT BS 227.8 BETWEEN LBL 7 TO RBL 12. REPAIRED CHORD IAW EO AND EA.Mar 23, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012041102996Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 23, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012050703729Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 294.5, LBL 56. REPAIRED WEB IAW EO AND EA.Mar 22, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012050703727Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 294.5, LBL 56. REPAIRED CHORD IAW EO AND EA.Mar 22, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012042703518Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 26L. REPAIRED CLIP IAW EA.Mar 22, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012050703726Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, LBL 53.5. REPAIRED BEAM IAW EO AND EA.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012050203637Skin · crackedSKIN CRACKED AT BS 698, RBL 6.50. REPAIRED SKIN IAW SRM.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA2012042703511Frame · corrodedFRAME CORRODED AT BS 827, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, FrameSDR SWAA2012042603463Frame · crackedSTUB FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME IAW EO AND EA.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, FrameSDR SWAA2012042603431Frame · crackedFRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW EA AND EO.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, FrameSDR SWAA2012042003281Angle · crackedCRACK ON ANGLE AT AFT CUTOUT OF L1 DOOR. REMOVED AND REPLACED ANGLE PER SRM & BAC DRAWING.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012041703174Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STR 10L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012040302805Angle · corrodedZ-ANGLE CORRODED BETWEEN BS 947.5 TO BS 986.5, STR 17R. REMOVED AND REPLACED Z-ANGLE IAW SRM AND DWG.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012040302804Fitting · crackedCLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012040302803Fitting · crackedCLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 21, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012050703728Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 672.5, RBL 24.5. REPAIRED BEAM IAW EA AND EO.Mar 20, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012041603134Tie Clip · crackedTIE CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Mar 20, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012032902703Skin · crackedLT WING NR 1 SLAT CRACKED ON LOWER SURFACE LOCATED AT STA 531. REPAIRED SKIN IAW SRM.Mar 20, 2012 · N509SW · Boeing 7375H4 · Leading Edge DevicesSDR SWAA2012050203636Skin · crackedL2 DOOR FUSELAGE SKIN CRACKED AT BS 951+10, STR 17L. REPAIRED SKIN PER MT.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA2012050103616Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD IAW EA.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012050103615Skin · crackedSKIN CRACKED AT BS 482B + 16, STR 18R. REPAIRED SKIN IAW EO AND EA.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA2012043003599Floorbeam · crackedFLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 713, RBL 24.5. REPAIRED WEB IAW EA AND EO.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012042703510Web · crackedWEB CRACKED BETWEEN BS 706 TO BS 711, LBL 24.5. REPAIRED WEB IAW EA AND EO.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Miscellaneous StructureSDR SWAA2012042703509Floorbeam · crackedFLOORBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM IAW EA AND EO.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012040703508Floorbeam · crackedFLOORBEAM CRACKED AT BS 727B, LBL 24.5. REPAIRED BEAM IAW RO AND EO.Mar 19, 2012 · N509SW · Boeing 7375H4 · Fuselage Main, Floor BeamSDR SWAA2012042503410Skin · crackedL2 DOOR SKIN CRACKED AT BS 986.5 + 2.5, STR 7L. REPAIRED SKIN IAW SRM.Mar 19, 2012 · N509SW · Boeing 7375H4 · Passenger/Crew DoorsSDR SWAA2012042503409Skin · crackedL2 DOOR SKIN CRACKED BETWEEN BS 967+3 TO BS 992.8+7 BETWEEN STR 9L TO STR 5L. REPAIRED SKIN IAW SRM.Mar 19, 2012 · N509SW · Boeing 7375H4 · Passenger/Crew DoorsSDR SWAA1201114Skin · delaminatedRIGHT WING I/B AFT FLAP O/B CORNER DELAMINATED FROM BOTH SURFACES. REMOVED AND REPLACED FLAP PER MM. (SUBMITTED AS A SUPPLEMENT, COULDN`T FIND ORIGINAL CONTROL NUMBER.)Feb 1, 2012 · N509SW · Boeing 7375H4 · Trailing Edge FlapsSDR SWAA117498Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 803, STR 21L. REPAIRED SKIN IAW ER AND EA.Oct 27, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA117497Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 764, STR 21L. REPAIRED SKIN IAW ER AND EA.Oct 27, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA117422Flap · delaminatedDURING SCHEDULED OTS CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.Oct 25, 2011 · N509SW · Boeing 7375H4 · Trailing Edge FlapsSDR SWAA115715Indicator · faultyAIR TURNBACK - INTERMITTENT RADAR PAINTS WEATHER EVERY OTHER SWEEP AND ERASES WEATHER EVERY OTHER SWEEP. REMOVED AND REPLACED WEATHER RADAR INDICATOR.Aug 9, 2011 · N509SW · Boeing 7375H4 · Weather Radar SystemSDR SWAA115543Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.Jul 31, 2011 · N509SW · Boeing 7375H4 · Emergency LightingSDR SWAA115143Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 6. RELAMPED LIGHT PER MM.Jul 16, 2011 · N509SW · Boeing 7375H4 · Emergency LightingSDR SWAA115142Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 1. RELAMPED LIGHT PER MM.Jul 16, 2011 · N509SW · Boeing 7375H4 · Emergency LightingSDR SWAA115012Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 867+14, STR 23R. REPAIRED SKIN PER EA.Jul 11, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA115014Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 945, STR 24R. REPAIRED SKIN PER SRM.Jul 10, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Plate/SkinSDR SWAA115013Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.Jul 10, 2011 · N509SW · Boeing 7375H4 · Trailing Edge FlapsSDR SWAA112983Connector · looseFWD EMERGENCY EXIT LIGHT INOP. SECURED CONNECTOR ON BATTERY PACK PER MM.Apr 23, 2011 · N509SW · Boeing 7375H4 · Light System WiringSDR SWAA112845Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 1. RELAMPED LIGHT PER MM.Apr 14, 2011 · N509SW · Boeing 7375H4 · Emergency LightingSDR SWAA112790Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10R. REMOVED AND REPLACED CLIP PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Attach FittingsSDR SWAA112789Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 787, STR 8R. REMOVED AND REPLACED STRINGER PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Longeron/StringerSDR SWAA112788Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED STRINGER PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Longeron/StringerSDR SWAA112787Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED STRINGER PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Longeron/StringerSDR SWAA112786Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727C, STR 9R. REMOVED AND REPLACED STRINGER PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Longeron/StringerSDR SWAA112785Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED STRINGER PER SI.Apr 14, 2011 · N509SW · Boeing 7375H4 · Fuselage Main, Longeron/Stringer
Back to N509SW, cancelled Mar 27, 2018