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 DALA2026011500358Seat Track · corrodedCORROSION SEAT TRACK +Y1292, FR 16 LT SIDE FWD GALLEY AREA. REPLACED SEAT TRACK Y1292 FR 12 TO FR 24 IAW SRM 51-42-11 AND SRM 51-72-11, AND DWG D53110920, ISSUE E00, DWG D53110984 ISSUE C00 TOOK MEASURES OF CORROSION ARE: L= 0.916 INCHW= 0.390 INCH D= 0.039SDR DALA2026011500357Floor Support · corrodedCORRODED FLOOR SUPPORT +Y1292, FR 66 LT SIDE AFT GALLEY AREA. REPLACED THE FLOOR SUPPORT Y1292, AND FASTENERS FR 64 TO FR 66 IAW SRM 51-42-11, SRM 51-72- 11,AND DWG 10N01048, REV A, APPROVED DATE 21/AUG/14 TOOK MEASURE OF CORROSION ARE: L: 2.589 INCHES W:0SDR DALA2026011500356Receptacle · corrodedENGINE NR 1 PYLON SPIGOT RECPTACLE AND SPIGOT BALL JOINT WITH CORROSION. REPLACED LOWER SPIGOT FITTING OF PYLON NR 1 IAW SRM TASK 54- 51-12-300-001, REV 155, AND REPLACED PYLON SPIGOT BALL JOINT IAW AMM TASK 54-51-41-000-001-A, PARAG 4C, AND TASK 54-51-41-400SDR DALA2026011500355Floor Support · corrodedUPPER FUSELAGE PAX CABIN, AFT ENTRY AREA FR68 -Y1200 FLOOR SUPPORT ANGLE WITH CORROSION. REPLACED FLOOR SUPPORT ANGLE (BEAM - LONGITUDINAL) AND COUPLING (SECTION - CONNECTING) AT FR68 -Y1200 IAW SRM 51-72-11-911-001 REV: 155, AND DRAWINGS D534 72780 ISSUE D ASDR DALA2026011500354Web · corrodedAFT FUSELAGE INTERNAL FLOOR STRUCTURE BETWEEN FR 68 AND FR 69 AT STGR 23R, WEB WITH CORROSION. REPLACED WEB (SHEET SHEAR) LOCATED BETWEEN FR68 AND FR69 STGR 23 IAW SRM 51-72-11-911-001 REV 155, AND DRAWINGS D53474250, ISSUE L, AND D53480505 ISSUE EU. (LP: 13SDR DALA2026011500353Seat Track · corrodedUPPER FUSELAGE, PAX CABIN, LT SIDE FR16 Y1292 SEAT TRACK WITH CORROSION. REPLACED SEAT TRACK UPPER FUSELAGE LT FR 16 Y1292 IAW SRM 51-72-11-911-001 REV 155, AND DRAWING D53112812 ISSUE E, D53918122, ISSUE A, D53110920 ISSUE E00 AND D531 10984 ISSUE B. (LP: 1SDR AALA202601157256Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: FUSELAGE SKIN HAS CORROSION BENEATH THE LAVATORY SERVICE PAN. COMPLETED FUSELAGE REPAIR AND LAV SERVICE PAN REPLACEMENT. IAW EA 370720 AND NR 75.SDR GTIA2026011539245Megaphone · inoperativeAFT MEGAPHONE INOPERATIVE. R & R AFT MEGAPHONE IAW CMM 25-60-01.SDR AALA202601154834Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 4 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #4 RH ON HORIZONTAL STABILIZER IAW A320 AMM 55-16-42-000-001-A AND A320 AMM 55-16-42-400-001-A.SDR AALA202601150809Power Supply · faultyAIRCRAFT WAS NOT GROUNDED: DURING OPS CHECK OF EMERGENCY LIGHTING SYSTEM FOUND AFT LT UNIT FAULT. MAINTENANCE REPLACED AFT L EMERGENCY POWER SUPPLY UNIT IAW AMM 33-51-38.SDR JJBA20260115025Engine · failedON CLIMBOUT HEARD A BIG BANG FROM NR 1 ENGINE AND NR 1 ENGINE SHUTDOWN. ALL INDICATORS WERE IN THE NORMAL ON TAKE OFF. DID ATTEMPT ANOTHER ENGINE RESTART IN FLIGHT WITH NO SUCCESS. NOISE OCCURRED AT 9000 AND THEY LEVELED OFF AT 11000. PERFORMED BORESCOPE INSPESDR CALA2026011512971Window Frame · crackedR3 WINDOW FRAME CUTOUT EDGE MARGIN OUT OF LIMITS IAW EA 5310- 08195, REV C. PERFORMED REPAIR TO THE R3 WINDOW FRAME E-F POST IAW EC/RA 5310-08770.SDR CALA2026011412967Nozzle · faultedAT 11 OCLOCK POSITION IN AFT SECTION OF NR 2 ENG A PIECE OF LINE R APPEARS TO BE MISSING. DIMENSIONS OF DAMAGED AREA ARE ROUGHLY 10"X8". REMOVED & REPLACED NR 2 ENGINE COMMON NOZZLE ASSEMBLY IAW AMM TASK 78-11-11-400-010-A. ALL CHECKS GOOD.SDR CALA2026011412966Skin · crackedRIGHT STAB LOWER SKIN NR 1, CRACK INDICATION FOUND, HSS 138.70 INBD OF INBD ROW OF FASTENERS, 24 INCHES AFT OF FWD SPAR. .800"L. . ALL WORK ACCOMPLISHED ON AAR NR9289208.SDR CALA2026011412965Skin · crackedRIGHT STAB LOWER SKIN NR 2, CRACK INDICATION FOUND, HSS 138.70 INBD OF INBD ROW OF FASTENERS, 8.5" FWD OF AFT SPAR. .400"L. REPAIRED IAW SRM 55-10-01-2R-11 REPAIR 11.SDR DXTA2026011506522Door Seal · leakingREPEAT WRITEUP. MAIN CABIN DOOR BEGINS TO WHISTLE AT 2.3 PSI TIL 2.0 PSI DURING EVERY DESCENT. SEE ATTACHED VIDEO. CORRECTIVE ACTION: REMOVED PRIMARY DOOR SEAL P/N 9914814-1. INSTALLED NEW PRIMARY SEAL P/N 9914814-1 W/ RETAINERS. SANDED DOWN CRACKS ON MED SMOOSDR AALA202601151210Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE AT BS 663.5, RBL 12. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202601157093Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE AT BS 663.5, RBL 37. REPLACED ANGLE PER AARD 51-00-05-1.SDR SWAA2026011460459Battery Pack · inoperativeAFT ENTRY DOOR HAS MULTIPLE EMERGENCY LIGHTS OUT. REMOVED AND REPLACED M1673 POWER SUPPLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026011460526Battery Pack · inoperativeEMERGENCY LIGHTS AT R1 DOOR INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-802.SDR SWAA2026011460506Power Supply · inoperativeFO AFT EMERGENCY EXIT INTERIOR/EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-802.SDR SWAA2026011460904Flashlight · inoperativeFWD GALLEY EMERGENCY FLASHLIGHT SEAL IS BROKEN AND FLASHLIGHT IS DEAD. R & R FWD GALLEY EMERGENCY FLASHLIGHT SEAL AND SECURED THE FLASHLIGHT IAW AMM 25-64-00; OPS CHECKED GOOD.SDR SWAA2026011460607Flashlight · inoperativeFLASHLIGHT AFT GALLEY F/O SIDE INBOARD INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY FLASHLIGHT IAW AMM 25-64-00.SDR SWAA2026011460615Flashlight · no testRIGHT AFT FA FLASHLIGHT WILL NOT TEST. SECURED RT AFT F/A FLASHLIGHT, OPS CHECK GOOD IAW AMM 25-64-00SDR 2026FA0000023Battery Cable · brokenNEGATIVE BATTERY CABLE TERMINAL END BROKENSDR AALA202601149177Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE SKIN BELOW LAVATORY SERVICE PAN LOCATED FROM BS 847 TO BS 867 FROM S24L TO S26L. ACCOMPLISHED DOUBLER REPAIR PER 370720.SDR ASAA2026011263752Lamp · inoperativeMULTIPLE EMERGENCY EXIT SIGNS IN THE CABIN HAVE INOP BULBS. GROUNDED - YES. TRANSFERRED DISCREPANCY TO AAR MIG-5 W/O: 1023813 9600-0003 S/N: OK455561 RELAMPED AND OPS CHECK EMERGENCY EXIT DOOR EMERGENCY LIGHTS IAW B737-800 AMM 33-51-01-960-801 STEP 2.SDR DALA2026011400342Slide · warning messageON FINAL APPROACH, WING SLIDE CAUTION COME ON INTERMITTENTLY. DOORS PAGE SHOWED LEFT SLIDE YELLOW DOOR INDICATION IN AFT. INTERMITTENT INDICATION CONTINUED ON THE GROUND. REMOVED AND REPLACED L/H OVERWING SLIDE IN REF. WITH AMDS W/C # 2563-4002. OK FOR SVC. RISDR DALA2026011400341Oil Cooler · leakingATB/FUMES - RETURNED TO MSP DUE TO FUMES IN THE FLIGHT DECK AND CABIN. PERFORMED HIGH POWER ENGINE RUNS WITH NO ODORS FOUND. P-TRACK DATA INDICATED APU AS LIKELY SOURCE OF ODOR. APU INSPECTION IN WORK. FOUND #2 ENGINE AIR/OIL COOLER CRACKED. SAME REPLACED. (SDR DALA2026011400339Light · burned outC/B FWD MAINT LT POWER 1 TRIPPED. T/S FOUND BREAKER CDC3-4-10 POPPING FOUND OXYGEN MAINT LIGHT BURNED OUT AND CHARRED. R/R OXYGEN MAINT LIGHT PER A220 AMP 33-32 -15. PERFORMED OPS CHECK. OPS CHECK NORMAL AT THIS TIME. (LP# 8195376)SDR JJBA20260114035Floor Support · gougedGOUGE FOUND ON LH OMEGA BEAM AT FR 20 WHERE CROSSFRAME ATTACHES, DAMAGE IS ON THE LOWER OMEGA BEAM DOUBLER. REMOVED AND REPLACED OMEGA BEAM REPAIR PARTS.SDR JJBA20260114034Frame · corrodedPOST GUSSET REMOVAL, FOUND CORROSION AT FRAME 22 AND OMEGA BEAM RIGHT SIDE. COMPLIED WITH REPAIR TO RH OMEGA BEAM AT FR22.SDR JJBA20260114032Mount · corrodedWHILE REMOVING #2 RADIO ALTIMETER AFT ANTENNA, RIVET HEADS PULLED FORM ANTENNA MOUNT AND SHOWS SIGNS OF CORROSION. REMOVED AND REPLACED #2 RADIO ALTIMETER EXTERNAL AND INTERNAL MOUNT BRACKETSSDR JJBA20260114030Attach Angle · scratchedLH VENTRAL TANK TO WING FAIRING HAS MULTIPLE SCRATCHES AROUND FASTENER HOLE. REMOVED AND REPLACED BRACKET ON LH VENTRAL TANK TO WING FAIRING.SDR UIEA2026011200009Wire · shortedNUMBER 4 ENGINE FIRE INDICATION ON ENG SHUTDOWN. PERFORMED ENG FIRE ON GROUND QRH.DISCHARGED BTH FIRE BOTTLES PER QRH INDICATION EXTINGUISHED AFTER SECOND BOTTLE. C/W FIM 26-11 TASK 808, NO FIRE CONDITION, FOUND T5683 LP A SHORT TO GROUND AND LOOP B BROKEN WSDR CALA2026011412947Door · unknownPILOT REPORTED L2 DOOR OPENED WHILE ESCAPE DOOR GIRT ENGAGED, DOOR POPPED IN ABOUT 1-2 INCHES, PERFORMED INSP ON L2 DOOR ESCAPE SLIDE, FOUND NO GIRT MATERIAL CAME OUT, LATCH ASSY DIDN'T BREAK. CLOSED DOOR AND RESTOWED GIRT BAR IN GIRT RETAINER. OPERATED DOOR CSDR CALA2026011412946Warning Light · false activationFWD ENTRY ANNUNCIATOR ILLUMINATED AT 150 KTS, CONTINUED TKF AND LIGHT WENT OUT AFTER 1 MIN PERFORMED ENTRY DOOR INDICATION SENSOR TEST IAW AMM 52-71-11-710-801. OPS TESTED NORMAL.SDR CALA2026011412945Target · looseFLIGHT DECK DOOR LOCK SENSOR IMPEDES DOOR CLOSURE. FOUND TARGET LOOSE. ADJUSTED TARGET ON DOOR AND SECURED IAW AMM 52-52-01-000-801. VERIFIED OPS CHECK OF DOOR ACCEPT/DENIAL AND AFTER 30 SECONDS LOCKED/UNLOCKED TEST OK REF AMM 52-52-01-700-801-C3A.SDR CALA2026011412942Unknown · odorON DEPARTURE FWD GALLEY REPORTED STRONG ODOR. ACPD CONDITIONAL INSPECTION IAW DMC-B787-A-05-51-99-99A-282A-A, NO ABNORMALITY FOUND. OK FOR SERVICE.SDR DALA2026011400326Oven · smokeAFT GALLEY OVEN GENERATING SMOKE WHEN IN OPERATION. OVEN FWD TO NEF THEN REPLACED OVEN. OK FOR SERVICE. (1398296)SDR DXTA2026011406525Handle · faultyMAIN CABIN DOOR HANDLE HARD TO CLOSE. WHEN WE FINALLY GOT THE DOOR HANDLE STOWED AND DOOR CLOSED, COULD NOT RE-OPEN DOOR. ARRIVED AND GAINED ACCESS TO AC. VERIFIED DISCREPANCY. PERFORMED GVI OF MAIN CABIN DOOR HANDLE AND FOUND "PUSH" BUTTON LOCKING PIN WAS MSDR DALA2026011300325Attach Fitting · corrodedSHIP 6820 LT MLG O/B ATTACH POINT FOR REACTION LINK HAS CORROSION ON UPPER AND LOWER SURFACE ALONG THE SLEEVE. CORRECTIVE ACTION: SUMMARY SEE NR FOR ADDITIONAL INFORMATION 006-0003:3210-9901-LT/010 00027 REMOVED AND REPLACED LT MLG O/B REACTION LINK ATTACH FITSDR DALA2026011300324Bolt · looseSHIP 6714 UPON ARRIVAL, GATE AGENT REPORTED LOUD POP OPENING L2 DOOR. NOW UNABLE TO CLOSE DOOR. CORRECTIVE ACTION: FOUND GUIDE ARM BOLTS LOOSE, RESECURED PER B757 AMM 52-11-04. FOUND CAM LATCH FITTINGS DAMAGED AND WITHIN TOLERANCES PER B757 AMM 52-11-37 AND C/SDR DALA2026011300320Girt Bar · fodL4 SLIDE LIGHT NOT ILLUMINATING. FOUND DERBIS AT GIRT BAR SEAT REMOVED DERBIS AND OPS CK DOOR PER B757 AMM 52-11. OPS CK GOOD. (8046292)SDR DALA2026011300317Sign · inoperativeRT AFT OVERWING EXIT SIGN INOP. R&R RT AFT OVRWING EXIT SIGN PER B767 AMM 33-51. OP CHECK GOOD. (8058630)SDR DALA2026011300319Indicator · faultedR1 DOOR ARMED LIGHT AT THE 1L FLIGHT ATT PNL INOP. REMOVED 1R DOOR IND PER B767 AMM 33-10. (1398784)SDR AALA202601135906Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 6 ELEVATOR ON RT HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM NR 6 RT ON HORIZONTAL STABILIZER IAW FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.SDR AALA202601139709Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 1 ELEVATOR ON RT HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM NR 1 RT ON HORIZONTAL STABILIZER IAW FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.SDR AALA202601130497Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 5 ELEVATOR ON RT HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM NR 5 RT ON HORIZONTAL STABILIZER IAW FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.SDR AALA202601138069Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM NR 3 ELEVATOR ON RT HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM NR 3 RT ON HORIZONTAL STABILIZER IAW A320 FAM AMM 55-16-42-000-001-A AND FAM AMM 55-16-42-400-001-A.