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.
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
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 SWIA2025080375135Slat Track · wornL/H SLAT TRACK 1-3 HAS WEAR MARKINGS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)PERFORMED REPAIR ON L/H SLAT TRACK 1-3 PER REO 690-57-42-1296 REV-- DATED 2025-08-25 SEE CONTINUATION FOR DETAILSCOMPLIED WITH TASK CARD 51-900-1002SDR SWIA2025080375125Slat Track · wornL/H SLAT TRACK 1-1 HAS WEAR MARKINGS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)PERFORMED REPAIR ON L/H SLAT TRACK 1-1 PER REO 690-57-42-1290 REV -- 2025-08-22 SEE CONTINUATION FOR DETAILS.COMPLIED WITH TASK CARD51-900-1002-SKYCOMPLIED WITH TASK SDR SWIA2025080375122Slat Track · damagedL/H SLAT TRACK 1-2 HAS PITTING. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON L/H SLAT TRACK 1-2 IAW CRJ 900 SRM 51-12-00-001-001-A01BLENDS FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE REMOVAL LIMITS IN CRJ900 SRMPERFORMED REPAIR OF L/H SLATSDR JJBA20251111061Antenna · corrodedCORROSION FOUND UNDER VHF 2 ANTENNA AT FRAMES 21-22. BLENDED AREA. APPLIED ALODINE TO THE AIRCRAFT SKIN AT VHF 2 ANTENNA MOUNT POINT AT FRAMES 21-22SDR JJBA20251024073Floor Support · corrodedCORROSION FOUND UNDERNEATH FLOOR BOARDS 262CF AND 262DF. REMOVED AND REPLACED RH AND CENTER GUSSETS UNDER FLOORBOARDS 262CF AND 262DF.SDR VNAA202509250017Drag Angle · crackedCRACK ON FWD AND AFT RH DRAG ANGLE BTW UNION OF VERTICAL STABILIZER AND FUSELAGE (67.5% REAR SPAR DATUM). FWD AND AFT DRAG ANGLE WERE REPAIRED PER CRJ700 SRM 55-31-00-201-001-A01SDR ASAA2025092260979Floor Support · corrodedFWD WET AREA FLOOR SUPPORT HAS CORROSION STA 312 TO 328 RBL 12. GROUNDED - YES. REMOVED AND REPLACED FLOOR SUPPORT AT STA 312TO 328 RBL 12 IAW SRM 51-40-02-0G-0W= 2 O= .080 R= .066 L= 1 D= .014.SDR ASAA2025080360918Floorbeam · crackedPANEL BREAK AT STA 540 BETWEEN BL 0 AND LBL 24 IS CRACKED. GROUNDED - YES. REMOVED AND REPLACED PANEL BREAK I.A.W. B737-800 SRM 51-40-02-0G-0.SDR SWAA2025091098041Support Beam · crackedCRACK SUPPORT BEAM #4 LOCATED FWD GALLEY DOOR. REPLACED SUPPORT BEAM #4 LOCATED FWD GALLEY DOOR IAW SRM 51-40-02; 51-10-02 ITEM 9 AND DWG 141A6516 SHEET 144 REV.-.SDR SWAA2025091097863Intercostal · crackedCRACKED WEB LOCATED BS 277 TO BS 294.5 AND BL 0 FWD GALLEY AND LAV. INSTALLED A NEW WEB INTERCOSTAL IAW SRM 51-40-02-0G AND DRAWING 141A5400 SHEET 20 REV-.SDR SWAA2025091097862Web · crackedCRACKED WEB BS 312 - 328, RBL 31 IN FWD GALLEY AND LAV. REPLACED WEB INTERCOSTAL AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02-0G, AND DRAWING 141A5400, SHEET 39, REV -.SDR DALA2025090806642Window · no discrepancyATB - DUE TO CAPTAINS SLIDING WINDOW APPEARING TO BE OPEN. OPS CHECKED SLIDING WINDOW AND LATCHING MECHANISM. OPS OK. FORWARDED MISSING TRIM TO NEF. (6672929)SDR SWIA2025090200803Rib · crackedRH HORIZONTAL STAB RIB 12 HAS SUSPECTED CRACK ON UPPER SIDE 4TH RIVET FROM THE FRONT BETWEEN FRONT SPAR AND UPPER SKIN STRINGER 2. REMOVED AND REPLACED RH HORIZONTAL STAB RIB 12 REF: SRM 51-40-08 ETD2025-170-926732 (P.O# 325561).SDR AALA202509023798Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE ON RH PYLON, MEASURES ARE L= 4.092 IN; W= 0.652 IN; D= 0.004 IN. MAINTENANCE REPLACED SPIGOT FITTING RECEPTACLE ON RH PYLON IAW A319 SRM 54-51-12-300-001.SDR SWAA2025082698537Skin · damagedFASTENER HOLE COMMON TO THE FUEL TANK AT STA.663 LBL 60 SHOWS INDICATION OF A DEFECT USING HFEC. (M). HFEC HOLE PROBE INSPECTION OF FASTENER HOLE COMMON TO THE REPAIR AREA PER BOEING NDT MANUAL PART 6;51-00-00 PROCEDURE 16 INDICATES DEFECT. FASTENER HOLE RSDR ASAA2025080360128Floor Support · corrodedFWD WET AREA FLOOR SUPPORT HAS CORROSION STA 312 TO 328 RBL 12. GROUNDED - YES. REMOVED AND REPLACED FLOOR SUPPORT AT STA 312TO 328 RBL 12 IAW B737-800 SRM 51-40-02-0G-0W= 2 O= .080 R= .066 L= 1 D= .014.SDR ASAA2025080360129Floorbeam · corrodedAFT WET AREA STA 986 FLOOR BEAM HAS CORROSION LBL 3 TO LBL 55. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS. REPAIRED FLOOR BEAM IAW SRM 53-70-51-2R-6.W= 1" O= .150" L= 2" R= .130" D= .020".SDR ASAA2025080360127Intercostal · corrodedFWD WET AREA MACHINED INTERCOSTAL STA 294 TO 312 RBL 40 HAS CORROSION. GROUNDED - YES. REMOVED CORROSION ON INTERCOSTAL STA 294-312 RBL40 AND FOUND TO BE OUR LIMITS IAW B737-800 SRM 53-10-21-1A-1 AND REMOVED AND REPLACED IAW B737-800 SRM 51-40-02-OG-OW+1" O=.0SDR ASAA2025080360126Floorbeam · corrodedAFT WET AREA 986 FLOORBEAM HAS CORROSION AT RBL 55. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT LIMITS, REPAIRED FLOORBEAM IAW SRM 53-70-51-2R-6.W= 1" O= .150 R= .119 L= 2" D= .031".SDR ASAA2025080360125Web · corrodedAFT WET AREA R/H WEB SUPPORT STA 986 TO 1016 RBL 45 HAS CORROSION. GROUNDED - YES. REMOVED CORROISON FOUND TO BE OUT OF LIMITS , REMOVED & REPLACED WEB IAW B737-800 SRM 51-40-02-0G-0 & 51-40-05-0G-0. W 1, O .050, R .088, L 4, D .012.SDR ASAA2025080360124Web · corrodedAFT WET AREA SHEAR WEB HAS CORROSION AT STA 986 LBL 50. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS REPLACED WEB IAW B737-800 SRM 51-40-02-0G-0 & 51-40-05-0G-0, W 1, O .048, R .039, L 2 D .006.SDR ASAA2025080360122Web · corrodedAFT WET AREA WEB SUPPORT STA 986 TO 1016 LBL 45 HAS CORROSION. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS REMOVED & REPLACED WEB IAW B737-800 SRM 51-40-02-0G-0 & 51-40-05-0G-0. W 1, O .080, R .040, L 4, D.010.SDR SWAA2025081898060Lens · loosePASSENGER CABIN CEILING; OVER WING EXIT ASSEMBLY IS MISSING LENS COVERS. INSTALLED 2X EXIT SIGN ACCESS COVER PLATES TO MID CABIN OVERHEAD EXIT LIGHT ASSY IAW AMM 33-51-01-960-802 STEP: 3. E. (2) (F).SDR SWAA2025081805577Lens · missingPASSENGER CABIN CEILING; OVER WING EXIT ASSEMBLY IS MISSING LENS COVERS. INSTALLED 2X EXIT SIGN ACCESS COVER PLATES TO MID CABIN OVERHEAD EXIT LIGHT ASSY IAW AMM 33-51-01-960-802 STEP: 3. E. (2) (F).SDR AALA202508189864Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB OUT FROM DEN ECAM FOR DOOR LEFT AFT EMERGENCY EXIT DISPLAYED AND THE BLUE CALL LIGHT IN CABIN CAME ON. THE ECAM CYCLED ON AND OFF OVER 10 TIMES AND THEN CLEARED ITSELF. ALL PRESSURE INDICATORS NORMASDR AALA202508188577Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB OUT FROM DEN ECAM FOR DOOR LEFT AFT EMERGENCY EXIT DISPLAYED AND THE BLUE CALL LIGHT IN CABIN CAME ON. THE ECAM CYCLED ON AND OFF OVER 10 TIMES AND THEN CLEARED ITSELF. ALL PRESSURE INDICATORS NORMASDR FDEA202508031488Floor Support · crackedFOUND SUPPORT CRACK AT MDCC FLOOR STRUCTURE FR37~FR38,-Y2465 POS. REPLACED CRACK SUPPORT WITH NEW ONE. AT MDCC FLOOR STRUCTURE FR37~FR38, -Y2465 POS. I.A.W A300-600F SRM 51-72-10-001, PAGE2 AND 51-40-21-001 PARA6 PAGE 7B-23. THIS REPAIR CLASSIFIED AS MINORSDR FDEA202508031487Floor Support · crackedFOUND SUPPORT CRACK AT MDCC FLOOR STRUCTURE FR38.1~FR38.2,-Y2465 POS. REPLACED CRACK SUPPORT WITH NEW ONE. AT MDCC FLOOR STRUCTURE FR38.1~FR38.2, - Y2465 POS. I.A.W A300-600F SRM 51-72-10-001, PAGE2 AND 51-40-21-001 PARA6 PAGE 7B-23. THIS REPAIR CLASSIFIED SDR FDEA202508031486Floor Support · crackedFOUND SUPPORT CRACK AT MDCC FLOOR STRUCTURE FR38.1~FR38.2, Y2465 POS. REPLACED CRACK SUPPORT WITH NEW ONE. AT MDCC FLOOR STRUCTURE FR38.1~FR38.2, Y2465 POS. I.A.W A300-600F SRM 51-72-10-001, PAGE2 AND 51-40-21-001 PARA6 PAGE 7B-23. THIS REPAIR CLASSIFIED SDR FDEA202508031485Floor Support · crackedFOUND SUPPORT CRACK AT MDCC FLOOR STRUCTURE FR38~FR38.1, Y2465 POS REPLACED CRACK SUPPORT WITH NEW ONE. AT MDCC FLOOR STRUCTURE FR38~FR38.1, Y2465 POS. I.A.W A300-600F SRM 51-72-10-001, PAGE2 AND 51-40-21-001 PARA6 PAGE 7B-23. THIS REPAIR CLASSIFIED AS MISDR SWAA2025081398067Slide · out of adjustL2 DOOR SLIDER DRAGS ON THRESHOLD WHEN CLOSING DOOR. REMOVED ADJUSTED AND REINSTALLED SLIDE PACK COVER PER AMM 25-66-01-000-801-NG ESCAPE SLIDE PACK AND COVER REMOVAL - PERMANENT, USING MT 725-61-06 ON SWA ID TTG8Q00Z7VMUSDR SWAA2025081398058Handle · looseL1 DOOR ASSIST HANDLE ON DOOR LOOSE. SECURED LI DOOR LINER ASSIST HANDLE IAW AMM 52-11-31-400-802 SUBTASK 52-11-31-020-011.SDR SWAA2025081398069Handle · looseR1 DOOR ASSIST HANDLE LOOSE ON DOOR LINER. SECURED R1 DOOR ASSIST HANDLE ON DOOR LINER IAW AMM TASK 25-21-31-420-802.SDR SWAA2025081398057Handle · looseR2 DOOR BOTH ASSIST HANDLES LOOSE. SECURED R2 ASSIST HANDLES IAW B737-800 AMM 52-41-31.SDR CALA2025081207628Shear Tie · damagedFORWARD CARGO AT FR 32 SHEAR-TIE BETWEEN STR 39L-40L HAS ELONGAT ED FASTENER HOLES REQUIRES REPLACEMENT. REMOVED AND REPLACED SHEAR TIE AT FWD CARGO FR32 BTW STR 39L-40L IAW A320 SRM 51-42-11 AND 51-72-11.SDR CALA2025081207627Shear Tie · damagedHAS ELONGATED FASTENER HOLES REQUIRES REPLACEMENT. REMOVED AND REPLACED CLEAT AT FWD CARGO FR32 BTW STR 40L-41L IAW A320 SRM 51-42-11 51-72-11.SDR CALA2025081207626Shear Tie · damagedFORWARD CARGO COMPARTMENT AT FR 32 SHEAR TIE BETWEEN STR 41L-42L HAS ELONGATED FASTENER HOLES REQUIRES REPLACEMENT. GENERATED BY V077960 PER HAECO LCQ NR 9296915/30915. ESFR COMPLETED REMOVED AND REPLACED SHEAR TIE AT FWD CARGO FR 32 BTW STR 41L-ST R42L IAW A3SDR DALA2025081105984Power Supply · faultedSHIP 9572 EMERGENCY LIGHT EXTERIOR DON'T TURN ON. CORECTIVE ACTION: OVERWING EMERGENCY EVACUATION BATTERY POWER SUPPLY WAS REPLACED PER B717 AMM 33-51-06. TEST OK.(6377081)SDR CALA2025080807519Seal · debondedCAPT LEFT SIDE WINDOW CONTINUOUS RATTLING NOISE FOUND. L1 WINDOW UPPER HUMP SEAL DISBONDED. APPLIED SPEED TAPE PER TEMPORARY REPAIR REF DMC-B787-A-56-11-00-03A-663A-A.SDR AALA202508088577Indication Sys · abnormalAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB OUT FROM DEN ECAM FOR DOOR LEFT AFT EMERGENCY EXIT DISPLAYED AND THE BLUE CALL LIGHT IN CABIN CAME ON. THE ECAM CYCLED ON AND OFF OVER 10 TIMES AND THEN CLEARED ITSELF. ALL PRESSURE INDICATORS NORMASDR SWAA2025080797866Lens · missingCEILING OVER WING EXIT ASSEMBLY IS MISSING LENS COVERS. REPLACED MISSING CEILING OVER WING EXIT ASSEMBLY LENS COVER IAW AMM 25-21-45-400-801.SDR DALA2025080705926Light · inoperativeDURING SVC CHK, FOUND RIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED OVERWING LIGHT REF A220 AMP 33-55-02, LIGHT ILLUMINATES. A/C OK FOR SVC.SDR DALA2025080705920Sensor · faultedATB DUE TO NR 3 BRAKES HOT INDICATION. PLACED NR 3 BRAKE TEMP INDICATION TO MEL. REPLACED NR 3 BRAKE TEMP SENSOR IAW AMM32-47.SDR CALA2025080707427Aileron Sys · malfunctionedAS PER CAPTAIN: AFTER AIRBORNE, ACFT PULLED VERY STRONG TO THE RT. CAPTAIN ENGAGED AUTOPILOT CAUSING ACFT TO PULL EVEN HARDER TO RT. CAPTAIN DISENGAGED AUTOPILOT. ACFT PULLED TO LT. CAUSING TO ABORT FLT & RETURN TO GATE. PERFORMED MCDP BITE, LAST FLT FASDR SWAA2025080697928Flashlight · no testCOCKPIT EMERGENCY FLASHLIGHT WILL NOT TEST GREEN AND MISSING SEAL. R & R FLASHLIGHT ASSY AND BATTERY. OPS CHECK GOOD. WORK DONE IAW AMM 25-64-00.SDR SWAA2025080698129Flashlight · no testCOCKPIT FLASHLIGHT NOT TESTING. RESTORED FLASHLIGHT PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025080697987Flashlight Assy · failedAFT FLASHLIGHT FO SIDE NOT CHARGING AND WILL NOT ILLUMINATE. REMOVED AND REPLACED AFT O/B EMERGENCY FLASHLIGHT IAW AMM 25-64-00.SDR SWAA2025080697969Slide · no discrepancyFWD SVC DOOR ESCAPESLIDE OVERHANGS A LITTLE BIT. INSPECTED FWD SERVICE DOOR ESCAPE SLIDE REF AMM 25-66-01. FOUND NO SIGNS OF BINDING DAMAGE OR WEAR, DOOR IS ABLE TO OPERATE NORMAL AND SLIDE IS ABLE TO BE ARMED AS NORMAL AS WELL.SDR SWAA2025080697911Lamp · inoperativeSIDEWALL LIGHTS INOP AT ROWS 2DEF ;6DEF 16ABC 22DEF;24DEF;23 ABC SIDEWALL LIGHTS INOP AT ROWS 2DEF 6DEF 16ABC 22DEF24DEF23 ABC. RELAMPED CABIN SIDEWALL LIGHTS IAW 33-21-00 AT ROWS 2DEF ;6DEF 16ABC 22DEF;24DEF;23 ABC. OPS CHECKS GOOD.SDR SWAA2025080697913Battery Pack · inoperativeFOUND FRONT LEFT EMERGENCY LIGHTS OUT. R & R FWD LT BATTERY PACK PER AMM 33-51-06 OPS GOOD.