N786SW, cancelled Oct 1, 2025
Service difficulty reports · 257
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 = 'N786SW' AND deregistration_id = 'N786SW-2025-10-01' 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 = 'N786SW' AND deregistration_id = 'N786SW-2025-10-01' 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 SWAA2018111926831Support · corrodedFORWARD CARGO BAY BILGE ON FLOOR TO SIDEWALL SUPPORT FORWARD "SHIELD" CORRODED BETWEEN BS 420 TO BS 440, RBL 22. R&R SUPPORT IAW DWG AND SRM.SDR SWAA2018111526786Support · corrodedFORWARD CARGO BAY LT FLOOR TO SIDEWALL SUPPORT CORRODED BETWEEN BS 500 TO BS 500D, LBL 25. R&R SUPPORT IAW SRM & DWG.SDR SWAA2018111326696Stringer Clip · corrodedFORWARD CARGO BAY BILGE ON STRINGER TO FRAME CLIP CORRODED AT BS 500B, RBL 6. R&R STRINGER CLIP IAW SRM AND DWG.SDR SWAA2018111326681Floor Support · corrodedFORWARD CARGO BAY BULKHEAD TO FLOOR SUPPORT CORRODED AT BS 500D, BETWEEN RBL 21 TO LBL 21. R&R SUPPORT IAW SRM AND DWG.SDR SWAA2022022419083Bracket · corroded***CORROSION*** ON FWD ENTRY DOOR SURROUND JUST FORWARD OF THE LOWER FORWARD DOOR LATCH ON THE FORWARD EDGE OF A BRACKET AT STA 303.9+3 WL191 STR 15 (MARKED) / REMOVED; FABRICATED; & INSTALLED NEW FWD ENTRY DOOR BRACKET AT STATION 303. 9+3 WL 191. STR 15. PER SDR SWAA2022022419084Mount · corroded***CORROSION*** ON HARD POINT MOUNT AT STA 344 LBL 59 WL 208 / REMOVED AND INSTALLED NEW HARD POINT MOUNT AT STA 344; LBL 59; WL 208 ITEM #141A5220-2 IAW AIPC 53-42-00-29; SRM 51-40-02-0G-0SDR SWAA2022022419085Intercostal · crackedCRACK ON CABIN FLOOR SUPPORT INTERCOSTAL AT STA 312+10 LBL 45 / REMOVED AND REPLACED CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 312 TO BS 328 LBL45; P/N 141A5410-12. IAW SRM 51-20-01-0G-0 AND DWG 141A5400SDR SWAA2022022419074Drain · corroded***CORROSION*** MULTIPLE AREAS AT AFT SERVICE DOOR MOP SILL / MULTIPLE CORROSION AREAS AT ASD MOPSILL FROM BS947 TO 987 FOUND TO BE OUT OF LIMITS DUE TO 100% MATERIAL LOSS IAW SRM 53-70-15-1A-1. REMOVED AND REPLACED NEW ASD MOPSILL PN# 147A8540118: PO#703038 ISDR SWAA2018112026942Floorbeam · corrodedBEAM CORRODED AT BS 986, BETWEEN LBL 43 TO RBL 43. REPAIRED BEAM PER EA.SDR SWAA2018111926886Pressure Panel · crackedRT VERTICAL PRESSURE WEB CRACKED AT BS 663, EXTERIOR SIDE OUTBOARD OF DRAIN VALVE AREA. REPAIRED WEB PER SRM.SDR SWAA2018111926830Intercostal · crackedFLOOR SUPPORT INTERCOSTAL CRACKED AT BS 277+8, BL 0. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018111926829Floor Support · crackedCABIN FLOOR SUPPORT CRACKED AT BS 269+3, LBL 30. R&R SUPPORT IAW DWG AND SRM.SDR SWAA2018111926828Intercostal · crackedFLOOR SUPPORT INTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, RBL 13. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2018111926827Intercostal · crackedCABIN FLOOR SUPPORT INTERCOSTAL CRACKED BETWEEN BS 344 TO BS 360, BL 0. R&R INTERCOSTAL IAW SRM & DWG.SDR SWAA2018111926826Support Angle · corrodedFORWARD ENTRY WAY SCUFF PLATE SUPPORT ANGLE CORRODED BETWEEN BS 312 TO BS 328, LBL 63. R&R ANGLE IAW SRM & DWG.SDR SWAA2018111926825Door Sill · corrodedR1 DOOR MOP SILL CORRODED BETWEEN BS 291.5 TO BS 360. R&R MOP SILL IAW SRM & DWG.SDR SWAA2018111926823Door Sill · corrodedL2 DOOR MOP SILL WEB CORRODED BETWEEN BS 1006 TO BS 1016, LBL 39. R&R WEB IAW SRM AND DWG.SDR SWAA2018111526785Support Angle · corrodedFORWARD ENTRY WAY SCUFF PLATE SUPPORT ANGLE CORRODED BETWEEN BS 312 TO BS 328, LBL 60. R&R ANGLE IAW SRM AND DWG.SDR SWAA2018111526784Door Sill · corrodedL1 DOOR MOP SILL CORRODED BETWEEN BS 294 TO BS 360, LBL 60. R&R MOP SILL IAW SRM AND DWG.SDR SWAA2018111426759Intercostal · crackedCABIN FLOOR SUPPORT INTERCOSTAL CRACKED AT BS 328+8, LBL 46. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018111426758Intercostal · crackedCABIN FLOOR SUPPORT INTERCOSTAL CRACKED BETWEEN BS 312 TO BS 328, RBL 30. R&R INTERCOSTAL IAW SRM AND DWG.SDR SWAA2018111426757Door Sill · corrodedL2 DOOR MOP SILL CORRODED BETWEEN BS 947 TO BS 986, WL 208. REPAIRED MOP SILL PER SRM AND DWG.SDR SWAA2018111326695Support Angle · corrodedFORWARD SERVICE WAY SCUFF PLATE SUPPORT ANGLE CORRODED AT BS 312+13, RBL 59. R&R ANGLE IAW DWG AND SRM.SDR SWAA2018111326694Door Sill · corrodedR2 DOOR MOP SILL WEB CORRODED AT BS 1006, RBL 40. R&R WEB IAW SRM AND DWG.SDR SWAA2022022419069Scuff Plate · crackedACB AFT CORNER SCUFF PLATE IS CRACKED / REPAIRED ACB AFT CORNER SCUFF PLATE IAW EA 1-A53-2076 REV 11SDR SWAA2022022419070Scuff Plate · crackedFCB FWD SCUFF PLATE IS CRACKED / REPAIRED FCB FWD SCUFT PLATE IAW EA 1-A53-2076 REV 11SDR SWAA2022022419071Scuff Plate · crackedFCB AFT SCUFF PLATE IS CRACKED / REPAIRED FCB AFT SCUFF PLATE IAW EA 1-A53-2076 REV 11SDR SWAA2022022319044Floor Panel · brokenAFT CABIN FLOOR PANEL 242SF AFT O/B CORNER BROKEN / DUE TO THE EXTENT OF DAMAGE TO THE AFT O/B CORNER; REPLACED AFT CABIN FLOOR PANEL 242SF WITH NEW PANEL IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-21-00-26 ITEM 17. 57066U 10/23/18SDR SWAA2022022319055Floor Panel · brokenAFT CABIN FLOOR PANEL 242XF IS BROKEN / DUE TO THE EXTENT OF DAMAGE REPLACED AFT CABIN FLOOR PANEL 242XF WITH NEW PANEL IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-21-00-26 ITEM 220. 57066U 10/22/18SDR SWAA2022022419040Support · crackedLT WING BULB SEAL SUPPORT ABOVE #1 PYLON AFT TIP IS CRACKED / REMOVED & REPLACED SEAL SUPPORT IAW SRM 51-40-02 & IPC 57-50-00-25SDR SWAA2022022419041Web · crackedRT WING UPPER T/E PANEL ABOVE PYLON AFT TIP LOWER BULB SEAL SUPPORT WEB IS CRACKED ON FWD FLANGE / REMOVED & REPLACED BULB SEAL SUPPORT WEB IAW SRM 51-40-02 & IPC 57-50-00-25; RH WING UPPER T/E PANEL ABOVE PYLON AFT TIPSDR SWAA2018111326706Former · crackedRT WING FIXED LEADING EDGE INBOARD FAIRING SUPPORT FORMER CRACKED ON UPPER END. REPAIRED FORMER IAW SRM & DWG.SDR SWAA2018111326689Web · crackedLT WING TRAILING EDGE UPPER PANEL ABOVE PYLON AFT TIP TRANSVERSE WEB CRACKED ON OUTBOARD UPPER FLANGE. R&R TRANSVERSE WEB IAW SRM & DWG.SDR SWAA2022022319035Beam · crackedDURING COMPLETION OF CCN: 14079 FOUND FORWARD SERVICE DOOR #5 (UPPER) BEAM TO BE CRACKED ON THE INBD SIDE AT THE RADIUS COMMON TO THE FORWARD MOST ATTACH POINT FOR THE HANDLE BOX ASSEMBLY. / FORWARD SERVICE DOOR #5 (UPPER) BEAM WAS REMOVED & REPLACED ON WORK OSDR SWAA2018112026941Beam · crackedR1 DOOR NR 4 LOWER BEAM CRACKED ON THE INBOARD SIDE AT THE RADIUS COMMON TO THE FORWARD MOST ATTACH POINT FOR THE HANDLE BOX ASSEMBLY. R&R BEAM PER AMM.SDR SWAA2018112026940Support Angle · crackedUPPER SUPPORT ANGLE CRACKED AT BS 663, LBL 10. REPAIRED ANGLE PER EA AND ER.SDR SWAA2018111526783Skin · crackedLT WING NR 3 SLAT SKIN CRACKED AT LOWER SURFACE OF SLAT NOSE SKIN AT ACTUATOR ATTACH POINT. REPAIRED SKIN IAW SRM.SDR SWAA2022021518881Retainer Seal · crackedAFT FIXED T/E SEAL RETAINER ANGLE CRACKED JUST I/B OF FLAP PROGRAMING TRACK / R/R ANGLE IAW SRM 51-40-02.SDR SWAA2018041621232Battery Pack · dischargedL1 DOOR EMERGENCY GROUND ILLUMINATION LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018041621215Charger · inoperativeL1 DOOR EMERGENCY GROUND ILLUMINATION LIGHT INOP. R&R CHARGER PER AMM.SDR SWAA2022021318872Fairing · elongatedRIGHT MAIN WHEEL WELL LOWER FAIRING PANEL 193 AR HAS PULLED FASTENERS / E41398-BRADSHAW; GARY - 04/12/2018 04:31 WIP: REPAIRED FASTENER HOLES PER S.RM. 51-70-04 -2R-9. REINSTALLED THE PANEL PER THE SRM 51-40-02.SDR SWAA2018010318822Slide · looseR2 DOOR ESCAPE SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA2022020718806Panel · delaminated#2 ENGINE INBOARD PYLON HAS DELAMINATED AREA JUST AFT OF PANEL 444 AL; AT APPROX. NAC STA. 314. FOUND DELAM. AREA TO MEASURE 2.25' LONG BY 1.75' WIDE MOD / REMOVED #2 ENG. AFT I/B PYLON PANEL 444BL IAW SRM 51-40-02-0G-0 FIG 10 & 11 56586C 22OCT18 INSTALLED #2 SDR SWAA2017092716685Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R&R SIGN IAW AMM.SDR SWAA2017092116518Slide · looseR1 DOOR EMERGENCY ESCAPE SLIDE LOOSE. SECURED SLIDE FLAPS IAW MT.SDR SWAA2022020118870Door · crackedAFT GALLEY SERVICE DOOR; LOWER PAN AFT ATTACH ANGLE IS CRACKED. / REMOVED AND REPLACED PAN ASSY. PER M/M 20-50-11.SDR SWAA2017082815942Battery Pack · no testRIGHT OVERWING EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815941Battery Pack · no testLEFT OVERWING EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017082815938Battery Pack · no testRT FORWARD EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW AMM.SDR SWAA2017081415639Bulb · inoperativeLEFT PASSENGER CABIN STOW BIN EMERGENCY LIGHT INOPERATIVE AT ROW 20. R & R THE BULB IAW AMM.
Back to N786SW, cancelled Oct 1, 2025