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 SWAA2012062505267Stiffener · crackedSTIFFENER CRACKED AT BS 663, LBL 24.8. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.Jun 8, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012070305526Strap · corrodedSTRAP CORRODED BETWEEN BS 360 TO BS 380, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED DOUBLER IAW EA.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062805383Frame · crackedFRAME CRACKED AT BS 616, BETWEEN STR 7R TO STR 8R. REPAIRED FRAME IAW EA.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062605308Frame · crackedFRAME CRACKED AT BS 188 AT LEVEL FLOOR AREA IN FLIGHT CREW COMPARTMENT. REPAIRED FRAME IAW SRM & DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505270Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 3R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2012062505266Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2012062105141Tie Clip · crackedTIE CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062105140Tie Clip · crackedTIE CLIP CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM & DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062105129Fitting · crackedCLIP CRACKED AT BS 685+8, LBL 24.75. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062005108Fitting · crackedCLIP CRACKED AT BS 685+8, RBL 24. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Attach FittingsSDR SWAA2012061504990Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061504962Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061504961Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061404939Tie Clip · crackedTIE CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061404938Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061204869Tie Clip · crackedTIE CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061204868Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012061204867Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 7, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062605330Skin · delaminatedLEFT WING NR 2 SLAT SKIN DELAMINATED. REPAIRED SKIN IAW SRM.Jun 6, 2012 · N645SW · Boeing 7373H4 · Leading Edge DevicesSDR SWAA2012062505265Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.Jun 6, 2012 · N645SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2012062505264Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 21R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.Jun 6, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2012062505263Stringer Splice · corrodedSTRINGER SPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 19R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.Jun 6, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2012061404936Fitting · crackedCLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 6, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012070205493Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB IAW EO AND EA.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, BulkheadSDR SWAA2012062805382Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW EA.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062805381Skin · crackedLEFT WING NR 2 SLAT SKIN CRACKED BETWEEN WBL 329.75 TO WBL 355. REPAIRED SKIN IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Leading Edge DevicesSDR SWAA2012062605262Splice · corrodedSPLICE CORRODED BETWEEN BS 887+14 TO BS 907+8, STR 23L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062505261Stringer · corrodedSTRINGER CORRODED BETWEEN BS 967 TO BS 986.5, STR 25L. REPAIRED STRINGER IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Longeron/StringerSDR SWAA2012062505260Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505259Skin · crackedLEFT WING NR 1 SLAT SKIN CRACKED BETWEEN WS 505 TO WS 530. REPAIRED SKIN IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Leading Edge DevicesSDR SWAA2012062505258Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 947.5, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062505257Angle · crackedWEB ANGLE CRACKED AT BS 380, STR 26R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062505256Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 25L. REPAIRED FRAME IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505255Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062105139Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2012062105138Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STR 25L TO STR 24L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Internal Mounting StructureSDR SWAA2012062105137Support Angle · corrodedSUPPORT ANGLE CORRODED AT BS 787, STR 25R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.Jun 5, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012070205492Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED FRAME IAW EO AND EA.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012070205491Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 54. REPAIRED CHORD IAW EA.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, Floor BeamSDR SWAA2012062805380Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW EA AND EO.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062605329Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EA.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062605307Fitting · crackedCLIP CRACKED AT BS 540, RBL 3. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062605306Fitting · crackedCLIP CRACKED AT BS 540, LBL 3. REMOVED AND REPLACED CLIP IAW SRM AND DWG.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062605305Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED STUB FRAME IAW EA.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062605304Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM AND DWG.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505254Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM 68.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505253Tie Clip · corrodedTIE CLIP CORRODED AT BS 793.5, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Miscellaneous StructureSDR SWAA2012062505252Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012062505251Frame · corrodedFRAME CORRODED AT BS 907, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.Jun 4, 2012 · N645SW · Boeing 7373H4 · Fuselage Main, FrameSDR SWAA2012061504960Cable · frayedR2 DOOR EMERGENCY ESCAPE SLIDE LATCH CABLE FRAYED. REMOVED AND REPLACED CABLE IAW AMM.Jun 4, 2012 · N645SW · Boeing 7373H4 · Emergency Equipment
Back to N645SW, cancelled Nov 20, 2017