Service difficulty reports

1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; general aviation reporting is voluntary.

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'
  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 SWIA2025110676531Fitting · wornCENTER CARGO DOOR FWD UPPER GUIDE FITTING SHOWS SIGN OF WEAR. REPAIRED CENTER CARGO DOOR FORWARD UPPER GUIDE FITTING IAW REO 690-53-31-1100 REV-A. COMPLIED WITH ALL STEPS OF REO 690-53-31-1100 REV-A. COMPLIED WITH TASK CARD 51-900-1002-SKY.Nov 6, 2025 · N813SK · Cndair CL6002D24 · Cargo/Baggage DoorsSDR SWIA2026070676517Landing · crackedPOSSIBLE CRACK ON RT TRU DOOR LANDING AFT LATCH. REMOVED AND INSTALLED NEW RT TRU DOOR LANDING IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, DWG CC670-33040, REV-G AND REO 690-53-11-2106 REV--. COMPLIED WITH ALL STEPS OF REO 690-53-11-2106 REV-. CONov 6, 2025 · N813SK · Cndair CL6002D24 · Fuselage Main, StructureSDR SWIA2025110676493Fitting · gougedCENTER CARGO DOOR FWD LOWER GUIDE FITTING HAS GOUGE. REPAIRED CENTER CARGO DOOR FORWARD LOWER GUIDE FITTING IAW REO 690-53-31-1100 REV-. COMPLIED WITH ALL STEPS OF REO 690-53-31-1100 REV-. COMPLIED WITH TASK CARD 51-900-1002-SKY.Nov 6, 2025 · N813SK · Cndair CL6002D24 · Cargo/Baggage DoorsSDR SWIA2025110676472Fitting · wornFWD CARGO DOOR FWD UPPER GUIDE FITTING SHOWS SIGN OF WEAR. REPAIRED FORWARD CARGO DOOR FORWARD UPPER GUIDE FITTING IAW REO 690-53-31-1100 REV-. COMPLIED WITH ALL STEPS OF REO 690-53-31-1100 REV-. COMPLIED WITH TASK CARD 51-900-1002-SKY.Nov 6, 2025 · N813SK · Cndair CL6002D24 · Cargo/Baggage DoorsSDR VNAA20260511027Door Sill · corrodedGALLEY SERVICE DOOR LOWER SILL ANGLE IS CORRODED. DRILLED UP AND INSTALLED NEW SERVICEABLE GALLEY SERVICE DOOR LOWER SILL ANGLE IAW CRJ700 SRM 51-40-11-001-001-A01 AND 51-42-06-001-001-A01.Nov 6, 2025 · N512AE · Cndair CL6002C10 · Fuselage Main, StructureSDR SWIA2025110675378Bracket · damagedFWD FACE RH FS 280.00 BULKHEAD BRACKET ASSY, FIRE EXT HAS ELONGATED SCREW HOLES AND REQUIRES REPLACEMENT. REMOVED AND REPLACED THE FWD FACE RH FS 280 BULKHEAD BRACKET ASSY, FIRE EXT IAW SRM 51-42-06.Nov 6, 2025 · N609SK · Cndair CL6002C10 · Fuselage Miscellaneous StructureSDR SWIA2026021375263Housing · gougedAFT BAGGAGE BAY DOOR, EXTERNAL HANDLE HOUSING GOUGED. INSTALLED NEW AFT CARGO DOOR HANDLE HOUSING IAW SRM 51-42-21-001-001-A01, & DWG 601R35027, REV AY. LEAK & OPS TESTED GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKY.Nov 6, 2025 · N758EV · Cndair CL6002C10 · Cargo/Baggage DoorsSDR SWIA2025110675250Drag Angle · crackedRIGHT VERTICAL STAB TO FUSELAGE, AFT DRAG ANGLE HAS POSSIBLE CRACK AT THE AFT END. REPAIRED THE CRACKED DRAG ANGLE IAW SRM 55-31-00-201-001-A01. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. NO DEFECTS NOTED.Nov 6, 2025 · N758EV · Cndair CL6002C10 · Fuselage, Stabilizer Attach FittingsSDR AALA202601155831Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500E TO BS 500I AT RBL 24. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.Nov 6, 2025 · N945NN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202601152549Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500H PLUS 16 INCHES, AT LBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.Nov 6, 2025 · N945NN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202512189776Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERNAL SKIN PANEL AT FR 56, BETWEEN S41L AND S42L. REPAIRED SKIN PANEL PER EA 370128.Nov 6, 2025 · N156UW · Airbus A321211 · Fuselage Main, Plate/SkinSDR SWAA2025121532668Floorbeam · corrodedCORRODED FLOORBEAM LOWER FLANGE, BS 986.5, RBL 40, WL 208.5. REPAIRED THE FLOORBEAM IAW EA 25-153-03177-WIP1, EA 25-153-03177, AND SRM 53-70-51-2R-6, REPAIR 6, ALTERNATIVE 4.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Main, Floor BeamSDR SWAA2025121532426Web · crackedCRACK WEB FLOOR STRUCTURE, BETWEEN BS 328 - 344, LBL 45 IN THE FWD GALLEY AND LAVATORY. REPLACED THE WEB & FASTENERS IAW SRM 51-40-02, & DWG 141A5400, SHEET 44, REV -.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121532679Support Beam · crackedCRACK SUPPORT BEAM NR 4, LOCATED FOR THE FWD GALLEY DOOR. REPLACED SUPPORT BEAM NR 4 LOCATED FWD GALLEY DOOR IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 141A6516, SHEET 102, REV B.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121532380Drip Tray · crackedAFT RT DRIP SHIELD IS CRACKED.Nov 6, 2025 · N7868K · Boeing 73779P · Fuselage Main, StructureSDR SWAA2025121532423Floor Support · crackedCRACKED FLOOR SUPPORT BTW BS 344 - 360, BL 0, IN THE FWD GALLEY AND LAV. REPLACED THE FLOOR SUPPORT AND FASTENERS IAW SRM 51-40-02, AND DWG 141A5400, SHEET 32, REV-.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121532422Floor Support · crackedCRACKED FLOOR SUPPPORT BTW BS 277 - 294.5, BL 0, IN THE FWD GALLEY & LAV. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 141A5400, SHEET 20, REV -.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121532424Angle · corrodedCORRODED ZEE ANGLE, BS 312, LBL 55, WL 208.1 IN THE FWD GALLEY AREA. REPLACED THE ZEE ANGLE IAW SRM 51-40-02-0G-0.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121546385Angle · corrodedCORRODED ZEE ANGLE, BS 312, LBL 55, WL 208.1 IN THE FWD GALLEY AREA. REPLACED THE ZEE ANGLE IAW SRM 51-40-02-0G-0.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121532658Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 661CB TRAILING EDGE ON RT WING. REPAIRED THE ACCESS PANEL 661CB TRAILING EDGE IAW SRM 51-70-04-2R-10, REPAIR 10.Nov 6, 2025 · N917WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025121532659Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB ON RT WING. REPAIRED ACCESS PANEL 661AB IAW SRM 51-70-04-2R-10, REPAIR 10.Nov 6, 2025 · N917WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025121532661Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661BB ON RT WING. REPAIRED THE ACCESS PANEL 661BB IAW SRM 51-70-04-2R-10, REPAIR 10.Nov 6, 2025 · N917WN · Boeing 7377H4 · Wing, Plate/SkinSDR SWAA2025121232425Web · crackedCRACKED WEB FLOOR STRUCTURE LOCATED BTW BS 312 - 328, LBL 45. REPLACED THE WEB & FASTENERS IAW SRM 51-40-02, & DWG 141A5400, SHEET 26, REV -.Nov 6, 2025 · N917WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025121232239Girt Bar · deterioratedDETERIORATED ENTRY AND SERVICE DOOR GIRT BAR FITTING HARDWARE AT FWD GALLEY AREA. REPLACED ENTRY AND SERVICE DOOR GIRT BAR FITTING HARDWARE AT FWD GALLEY AREA IAW AMM 25-66-02-400-801.Nov 6, 2025 · N917WN · Boeing 7377H4 · Emergency EquipmentSDR AALA202512053887Attach Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR DOOR FORWARD ACTUATOR ATTACH FITTING HAS CRACKED / ELONGATED HOLES. REPLACED FITTING PER CMM 52-81-18.Nov 6, 2025 · N187US · Airbus A321211 · Fuselage Main, Attach FittingsSDR SIMA20251106010Floorbeam · corrodedSSI /FOUND CORROSION ON RH CENTER FLOORBEAM ON A PREVIOUSLY BLENDED AREA LOCATED FWD OF THE RT LOWER SEAT TRACK FWD END, BETWEEN FR 17 AND FR 18. MAJOR REPAIR. PERFORMED PERMANENT REPAIR ON RT CENTER FLOOR BEAM LOCATED FWD OF THE RT LOWER SEAT TRACK FWD END IANov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Main, Floor BeamSDR SIMA2025120406011Floorbeam · corrodedRIGHT AFT GALLEY FLOORBEAM AT FR 84 CORRODED AROUND RIVET HEAD. MAJOR REPAIR, PERFORMED PERMANENT REPAIR TO RH AFT GALLEY FLOORBEAM AT FR 84 AT 1 RIVET HOLE IAW ERS-EJ-5300-5299.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Main, Floor BeamSDR SWAA2025120332382Battery Pack · no testBATTERY PACK M1670 FAILED TEST. R & R BATTERY PACK M1670 IAW AMM 33-51-06-960-805 & PERFORMED GOOD OPS CHECK.Nov 6, 2025 · N7868K · Boeing 73779P · Emergency LightingSDR SWAA2025120232381Battery Pack · no testBATTERY PACK M1668 FAILED TEST. R & R BATTERY PACK M1668 AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06-960-805.Nov 6, 2025 · N7868K · Boeing 73779P · Emergency LightingSDR SWAA2025120132373Floorbeam · crackedCRACKED FLOORBEAM ANGLE BS 695, LBL24.75. REPLACED FLOORBEAM ANGLE IAW SRM 51-40-02, SRM 51-10-02, AND DWG 273A9110, SHEET 6, REV A.Nov 6, 2025 · N234WN · Boeing 7377H4 · Fuselage Main, Floor BeamSDR SIMA20251106003Floor Splice · corrodedAFT GALLEY FLOOR LH INBOARD SPLICE AT FR 90 CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACED AFT GALLEY FLOOR LH INBOARD SPLICE AT FR 90 IAW ERJ 175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SIMA20251106002Shear Panel · corrodedAFT GALLEY FLOOR CENTER SHEAR PANEL CORRODED IN MULTIPLE AREAS. REMOVED AND REPLACED AFT GALLEY FLOOR CENTER SHEAR PANEL IAW ERJ 175 SRM 51-40-08Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SIMA20251106009Floor Support · corrodedAFT GALLEY FLOOR RT BEAM AT FR 88 TO 89 CORRODED. (LEVEL 2 CORROSION) REMOVED AND REPLACED AFT GALLEY FLOOR RT BEAM AT FR 88 TO 89 IAW ERJ 175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SIMA20251106005Floor Skin · corrodedLH AFT GALLEY FLOOR UPPER SHEET CORRODED AT FR 85 TO 86. (LEVEL 2 CORROSION) REMOVED AND REPLACED LH AFT GALLEY FLOOR UPPER SHEET AT FR 85 TO 86 IAW ERJ 175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Floor PanelSDR SIMA20251106007Floor Splice · corrodedAFT GALLEY FLOOR RH OUTBOARD SPLICE AT FR 90 CORRODED. (LEVEL 2 CORROSION). RAR AFT GALLEY FLOOR RH OUTBOARD SPLICE AT FR 90 IAW ERJ175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SIMA20251106008Floor Support · corrodedAFT GALLEY FLOOR RH BEAM AT FR 89 TO 90 CORRODED RAR AFT GALLEY FLOOR RH BEAM AT FR 89 TO 90 IAW ERJ175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SIMA20251106004Splice · corrodedAFT GALLEY FLOOR RH INBOARD SPLICE AT FR 89 CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACED AFT GALLEY FLOOR RH INBOARD SPLICE AT FR 89 IAW ERJ 175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Main, StructureSDR SIMA20251106006Support Angle · corrodedAFT GALLEY FLOOR LH BEAM AT FR 90 TO 90A CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACED AFT GALLEY LH BEAM AT FR 90 TO 90A IAW ERJ 175 SRM 51-40-08.Nov 6, 2025 · N201NN · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR SWAA2025112832405Support Angle · corrodedCORRODED SUPPORT ANGLE, BS 767 TO 787, RBL 22, WL 156. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, DWG 146A0081, SHEET 43, REV - AND DWG 146A8123, SHEET 16, REV-.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112832411Plate · crackedCRACKED PLATE, BS 907 TO 927, S25R - S27R. REPLACED THE PLATE IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 147A7221; SHEET 28; REV-. MEASURE OF CRACK IS L:0.477.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112832403Support Angle · crackedCRACKED SUPPORT ANGLE, BS 867, S26L. REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 149A8102; SHEET 18; REV-.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112832409Support Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED BS947.5 BTW STR25L TO STR25R AFT CARGO COMPARTMENT. REPLACED ANGLE - SUPPORT LOCATED BS947.5 BTW STR25L TO STR25R AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 149A8117; SHEET 6; REV-.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112832410Angle · crackedCRACK ANGLE LOCATED BS947.5 AND STR25L AT AFT CARGO COMPARTMENT. EVALUATED ANGLE LOCATED BS947.5 AND STR25L AT AFT CARGO COMPARTMENT DUE TO NOT FOUND ALLOWABLE DAMAGE ON SRM B737-700 53-00-53-1A-2 ANGLE MUST BE REPLACE. REPLACED ANGLE IAW B737-700 SRM 51-10Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112832413Access Panel · crackedCRACK ACCESS PANEL 321A ON RIB 8 VERTICAL STABILIZER. REPLACED RIB 8 LOCATED ON PANEL 321A.IAW SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 174A0103 SHEET 1 REV:- MEASURE OF CRACK IS:L=0.133.Nov 6, 2025 · N944WN · Boeing 7377H4 · Vertical Stabilizer, Plate/SkinSDR SWAA2025112632408Web · corrodedCORROSION CHANNEL SUPPORT LOCATED BS847 TO BS867 AND RBL23 WL156 AFT CARGO COMPARTMENT. REPLACED SHIELD WEB LOCATED BS847 TO BS867 AND RBL23 WL156 AFT CARGO COMPARTMENT IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 146A0081, SHEET 43 REV- .Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112632404Support · corrodedCORROSION SUPPORT ZEE LOCATED BS 727B TO BS767 AT LEVEL RBL22 AND WL 156 AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOCATED BETWEEN BS 727+4 TO BS 767, RBL 22, WL 156 IAW 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 146A7500 SHEET 157, REV -.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR SWAA2025112632402Shield · corrodedCORROSION SHIELD WEB LOCATED BETWEEN STA767 TO STA794.3 AND RBL22 WL156 AT AFT CARGO. REPLACED SHIELD WEB AND FASTENERS LOCATED BETWEEN BS 767 TO BS 794.3, RBL22, WL156 AT AFT CARGO IAW SRM 51-40-02 SRM 51-10-02, ITEM 9, AND DWG 146A0081, SHEET 43, REV-.Nov 6, 2025 · N944WN · Boeing 7377H4 · Fuselage Miscellaneous StructureSDR AALA202511265319Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540, RBL 1. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-01.Nov 6, 2025 · N944NN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202511268678Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540, LBL 1. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-01.Nov 6, 2025 · N944NN · Boeing 737823 · Fuselage Main, Floor BeamSDR AALA202511245251Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE ON AFT ENTRY DOOR FUSELAGE CUTOUT FORWARD FRAME-MOUNTED UPPER LATCH TRACK FITTING. REMOVED AND REPLACED AFT ENTRY DOOR FUSELAGE CUTOUT FORWARD FRAME MOUNTED UPPER LATCH TRACK FITTING. PER SRM 51-40-02 AND PERFORMED SATISFACTNov 6, 2025 · N922AN · Boeing 737823 · Fuselage Main, Structure