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 IPXA2025080655454Support · corrodedAFT CARGO FR 54 CENTER HORIZONTAL CEILING SUPPORT IS CORRODED AT ATTACHING POINT. INSTALLED EXTRUSION SUPPORT STRUCTURE AT THE FR54 IN THE AFT CARGO PIT IAW SRM 51-40-21-001. REVIEWEDSDR IPXA2025080755399Angle · crackedAFT CARGO FR 54 VERTICAL SUPPORT AT Y-953 IS CRACKED. INSTALED NEW PART IAW SRM 51-40-21.SDR SWAA2025080791718Track · crackedCRACK ON LT HORIZONTAL STAB UPPER SHARK FIN FWD SLIDE TRACK. REMOVED AND REPLACED LT HORIZONTAL STAB UPPER SHARK FIN FWD SLIDE TRACK IAW SOPM 20-50-01 AND AMM 20-50-11-910-801.SDR IPXA2025080154641Skin · crackedLH WING SLAT TRACK #10 LE TRACK CUT OUT HAS A CRACK AT RADIUS.040-19, ATA-51-00. ACCOMPLISH REPAIR PER SRM 57-40-02-2R-7 REPAIR 7 REV 71. INSTALLED REPAIR FILLER AND DOUBLER AT L/H WING SLAT TRACK #10 LE TRACK CUT OUT PER MD11 SRM 57-40-02-2R-7 REPAIR 7 FIG. SDR AALA202508064176Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 807 TO BS 827 AT S26L. BLENDED CORROSION PER SRM 53-00-53-1A-2.SDR AALA202508053631Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE HAS EVIDENCE OF SURFACE RUST. REMOVED AND REPLACED LEFT HORIZONTAL STABILIZER ELEVATOR TAB CONTROL MECHANISM SPRINGS LOWER HARDWARE AND PERFORMED SATSDR R61A2025080500330Stringer · damagedTAIL STRIKE DAMAGE BETWEEN STR 28L TO 28R AND FRAME 99 TO FRAME 100.REPAIRED STRINGERS AND FRAME IAW AERNNOVA TI-170-25-149 AND ETD2025-170-924890 REV A AND ETD2025-170-925103 REV A. ALSO REF EAMS WO # 10104 FOR WORK ACCOMPLISHED.SDR IPXA2025072846633Floor Panel · brokenFAULT: STR. Z200 MCDECK FLOOR PANEL#232SH CORNER IS CRACKED DOT#58-1813 DARRYL FORD 91102506.FABRICATED FLOOR PANEL 232SH, I.A.W. SREO-40552-REQ001, USING P/N: 5024N400001SS-G BATCH: 0004373299 (QTY 1), P/N: EPOCAST 1638 A/B BATCH:0004410968 (QTY 1), P/SDR IPXA2025072850847Floor Panel · brokenFAULT: INT-200- MCC FLOORBOARD 251FJ IS BROKEN.FABRICATED FLOOR PANEL 251FJ, I.A.W. SREO-40552-REQ001, USING P/N: 5024N400001SS-G BATCH: 0004373299 (QTY 1), P/N: EPOCAST 1638 A/B BATCH:0004410968 (QTY 1), P/N: G2002B-3S BATCH:0004392380 (QTY 29), P/N: G2001B-SDR IPXA2025072850891Floor Panel · brokenFAULT: INT-200- MCC FLOORBOARD 251UJ IS BROKEN.FABRICATED FLOOR PANEL 251UJ, I.A.W. SREO-40552-REQ001, USING P/N: 5024N400001SS-G BATCH: 0004373299 (QTY 1), P/N: EPOCAST 1638 A/B BATCH:0004410968 (QTY 1), P/N: G2002B-3S BATCH:0004392380.VERIFIED FABRICATION OSDR AALA202508049110Lens · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT INOP AT DOOR 1R. MAINENANCE INSTALLED NEW LENS ON THE FLOOR PROXIMITYLIGHT IN FRONT R1 DOOR IAW CMM 25-02-42.SDR CALA2025080407228Skin · dentedDENT L/P 8898920 REQUESTING TO REPAIR PER SRM AT FUSELAGE ST A 799 BTW 25L AND 26L (REF. AAR NR 1000045588) ESFR-SDR SUBMITTED PERFORMED PERMANENT REPAIR OF DENT AT FUSELAGE STA 799, BETWEEN S-25L AND S-26L IAW SRM 53-00-01-2R-3.SDR R61A2025073100325Beam · mislocatedAFT SERVICE DOOR LOWER BEAM HAD 2 HOLES MIS-DRILLED, INSTALLED HAT BUSHINGS.SDR NACA2025071600002Packing · leakingFOUND APU OIL QUANTITY MTR PACKING LEAK. REMOVED AND REPLACED THE APU OIL QTY TRANSMITTER PACKING AS PER B767-300 AMM 49-49-04 REV 145SDR JJBA20250731124Floor Support · corrodedRH OMEGA BEAM LOWER IB FLANGE HAS CORROSION FULL LENGTH. REMOVED CORROSION FROM RH OMEGA BEAM LOWER FLANGE FULL LENGTH AT FR 23 - FR 29.8. REMOVED DAMAGE BEAM LOCATED, DRILLED, AND INSTALLED NEW BEAMSDR JJBA20250731121Floor Support · corrodedLEFT OMEGA BEAM LOWER FLANGE HAS CORROSION FULL LENGTH. REMOVED CORROSION FOUND THE LT OMEGA BEAM LOWER FLANGE SECTION FROM FRAME 23 FOUND TO BE IN LIMITS. TREATED, PRIMED AND PAINTED. FOUND BEAMS FROM FR23 TO FR52 OUT OF LIMITS. REMOVED DAMAGE BEAM. LOCATED, SDR JJBA20250730116Floor Support · crackedLH OMEGA BEAM AT FR 59-61 FOUND CRACKED AT 2 ANCHOR NUT LOCATION. LH OMEGA BEAM AT FR 59-61 CUTOUT AT 2 ANCHOR NUT LOCATION. LH OMEGA BEAM BTW FR 59-61 REPAIREDSDR JJBA20250728103Stringer · corrodedSTR 20 RH AT FR 58 FOUND CORRODED. STR 20R CORROSION FOUND ON STRINGER AT FR 59 ALSO. STR 20R, BLENDED AND FOUND OUT OF LIMIT. STR 20R BTW FR 57-60 REMOVED AND REPLACEDSDR JJBA20250728092Profile · corrodedCF2 RH T PROFILE BTW FR 28 CORRODED. AT CF2 RH T PROFILE BTW FR 28 CORROSION OUT OF LIMIT. AT CF2 RH T PROFILE BTW FR 28, 9 RIVETS REMOVED ON SILL FOR ACCESS. AT CF2 RH T PROFILE BTW FR 28 REMOVED AND INSTALLED.SDR U5QA202507160156Windshield · fracturedL COCKPIT WINDSHIELD FRACTURE. MX C/A: REMOVED FRACTURED LH FRONT WINDSHIELD AND INSTALLED A NEW FRONT WINDSHIELD. PN OFF/ON: 1159SCB102-13, SN OFF: 17150H7350, SN ON: 25184H9590, WINDSHIELD PROVIDED BY GULFSTREAM AEROSPACE CORPORATION, AUTHORIZATION NO: ODA-SDR SWAA2025072491948Baffle · crackedFORWARD CARGO BS 500B TO 500C, LBL 25 BAFFLE WAS CRACKED. REMOVED AND REPLACED THE BAFFLE BS 500B - 500C, LBL 25 IAW SRM 51-40-02-0G-0 & DWG 143A7505 REV-.SDR AALA202507221082Fitting · missingAIRCRAFT IN BASE MAINTENANCE, L1 SLIDE GIRT BAR MISSING SPRING CLIP. REMOVED AND REPLACED L1 SLIDE GIRT BAR SPRING CLIP IAW AMM 25-66-01.SDR AALA202507229494Spring Assy · wornAIRCRAFT IN BASE MAINTENANCE: R1 GIRT BAR SPRING CLIP WORN. REMOVED AND REPLACED R1 GIRT BAR SPRING CLIP. PER AMM 25-66-01.SDR DALA2025072205491Power Supply · no testSHIP 1604 DURING SERVICE CHECK FOUND SECTION OF PATHWAY EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: R/R EMERGENCY LIGHT POWER SUPPLY PER B767 AMM 33-51. OPS CHECK NORMAL. OK FOR SERVICE. (7071701)SDR AALA202507216168Fitting · wornAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE H2 ON ANGLE FITTING LOC ON EXTERNAL SKIN FR35 RH SIDE A ND STRG 30R LOWER FUSELAGE L= 0.068 IN. MAINTENANCE REPLACED ANGLE FITTING LOC ON EXTERNAL SKIN FR35 RH SIDE AND STRG 30R IAW EA 292392B.SDR SWAA2025072192180Floor Panel · damagedHOLE DISCOVERED ON THE AFT CARGO FLOOR.<[01] FOUND CRACK 2.5 INCH IN LENGTH ON TWO PLACES; PLACED A PATCH IAW AMM 25-52-01. A/C OK TO CONTINUE FLIGHT.SDR JJBA20250721077Shear Tie · crackedIN REAR FUSELAGE COMPARTMENT AT BULKHEAD 80, RH SHEAR CLIP CRACKED BETWEEN STRINGER 5 AND STRINGER 7. IN REAR FUSELAGE COMPARTMENT, AT BULKHEAD 80, RH SHEAR CLIP BTW STR 5 AND STR 7 REMOVED AND REPLACEDSDR DALA2025072105466Light · malfunctioned(LOG 7444944) SIDEWALL LIGHT NEAR LEFT OVERWING EXIT FLICKERING. REMOVED AND REPLACED OVER WING EXIT SIDEWALL LIGHT AT 21ABC PER B737 AMM 33-21. OPS CHECK GOOD.SDR DALA2025072105457Plate · corroded(LOG 1085934) CORROSION ON RH SIDE PLATE FROM STA 727 TO STA 767, AND CORROSION ON RH SIDE PLATE UPPER AND LOWER SURFACE BTW STA 767 AND STA 793 AT AFT CARGO COMPARTMENT. RH SIDEPLATE BTW STA 727-793 AT AFT CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40SDR DALA2025072105469Window Frame · cracked(LOG 1086793) LH NO. 3 FLIGHT COMPARTMENT WINDOW FRAME LOWER FWD CORNER CRACKED. REPAIRED PER ERA 627247-14AD.SDR DALA2025072105445Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT FR20 RBL 43. REMOVED AND REPLACED SEAT TRACK AT RBL 43 BTW FR20 AND FR30 IAW A220 ASRP BD500-A-J51-42-21-00AAA-078A-A AND DWG BOMBARDIER PL C02312600 REV-E. (LP# 1090119)SDR AALA202507219110Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT INOP AT DOOR 1R. (OPEN)SDR DXTA2025072104275Wire · damagedDOOR PAX CAS ILLUMINATED THREE TIMES IN FLIGHT. FIRST FOR ABOUT 20 SECONDS EXTINGUISHED BEFORE LEVELING OFF AND BEING ABLE TO ACCOMPLISH QRH. ILLUMINATED 2 MORE TIMES FOR ABOUT 5 SECONDS. NO ILLUMINATION BELOW 15,000 FEET. CORRECTIVE ACTION: REPAIRED WIRE. OPSSDR DXTA2025072104273Proximity Sensor · out of adjustLEVEL FLIGHT AT FL 450 THE PASSENGER DOOR CAS MESSAGE CAME ON. ALSO YELLOW PAX DOOR SHOWED OPEN ON STATUS PAGE. ON DESCENT ALL MESSAGES WENT OUT AT FL320. NO FAULT CODE MESSAGES TO PULL UP. ADJUSTED AFT PASSENGER DOOR PROXIMITY SENSOR. OPS CHECK GOOD. IAW BOSDR DXTA2025072104270Control Unit · faultedBRK FAIL YELLOW CLASS DISPLAYED UPON SETTING THE PARKING BRAKE WHILE HOLDING SHORT OF THE RUNWAY. REMOVED FAULTY BCM AND INSTALLED INSPECTED/TESTED. BCM COMPLETED OPS CHECKS OF THE HYD SYS WITH A ROBO MULE, COMPLETED A FUNCTIONAL TEST OF THE BRAKE SYSTEM ALLSDR CALA2025072106793Warning Light · false activationFWD SERVICE DOOR LIGHT INTERMITEN ON LAST 15 MINUTES OF FLIGHT. FWD SERVICE DOOR(1R) DOOR INDICATION INTERMITTANT. PLACING ON MEL 5203F. COMPLIED WITH VERIFIED FWD SERVICE DOOR CLOSED AND LOCKED OPENED AND CLOSED FWD SERVICE DOOR MULTIPLE TIMES. FWD SERVICE LSDR CALA2025072106791Actuator · faultedDOOR FLIGHT LOCK 3L EICAS STATUS #3 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. DB PSEU 2 (R2) DB PSEU 2 (L2) 3L PASSENGER ENTRY DOOR FLIGHT LOCK SYSTEM(S) INOPERATIVE. REQ MEL 5211E TOMC APPROVES MEL 5211E FLIGHT DOOR LOCK ASDR CALA2025072106790Actuator · faultedDOOR FLIGHT LOCK 4L EICAS STATUS #4 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. DB PSEU 2 (R2) DB PSEU 2 (L2) COMPLIED WITH MEL DR OPENS FROM INSIDE ADD FAULT: 5200 TOMC APPROVES MEL 5211E FLIGHT LOCK AT DOOR 4L INOP PLACED SDR CALA2025072106789Girt Bar · no discrepancyFA PEPORTS GIRT BAR AT 1L VERY DIFFICULT TO INSTALL AND REMOVE FROM BRACKET ADJ FWD ENTRY DOOR 1L BRACKET CLIP . OPS TEST GOOD . REF AMM 25-66-01.SDR CALA2025072106770Drain · leakingE1 ESN 900325 EXPERIENCED AN INCREASE IN OIL CONSUMPTION. PLEASE ACCOMPLISH A SNIFF CHECK OF THE OIL FOR FUEL SMELL IN THE OIL S YSTEM, REF. AMM 12-13-01-200-003-002. ACCOMPLISH FIM 71-05 TASK 805 STEPS D.(1) TO D.(3). FOUND NO FUEL ODOR AT THE FILL PORT OF SDR DALA2025071805435Radome · damagedSHIP 3327 RADOME NEED TO BE REPLACED DUE TO HAIL DAMAGE. REMOVED AND REPLACED RADOME AS PER A330 AMM 53-15-11-400-801-A. (7050215).SDR DALA2025071805434Engine · failedSHIP 3305 #1 ENG FAIL AT FL380 MACH 0.82 SMOOTH AIR. CHANGED ENGINE #1 IAW A330 AMDS JIC 7100-9901-01. (7314738).SDR HYIA20250718001Pump · leakingPILOT REPORTED A SMELL OF GAS IN THE CABIN DURING FLIGHT. MAINTENANCE INSPECTED AND REPLACED THE RIGHT PRIMARY FUEL BOOT PUMP WITH NO ADDITIONAL FAULTS FOUND.SDR AALA202507187401Unknown · odorAIRCRAFT WAS GROUNDED: STRONG FISH LIKE ODOR AROUND THE MIDDLE OF CABIN. ALSO PREVALENTAS WHEN YOU APPROACH AIRCRAFT FROM JETBRIDGE. PERFORMED CLEANING AND DISINFECTION OF AIRCRAFT INTERIOR. PER AMM 20-12-13.SDR AALA202507180509Uplock Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER RAISING THE GEAR HANDLE, RIGHT MAIN GEAR LIGHT STAYED RED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. PERFORMED TASK FOR RIGHT MAIN GEAR UPLOCK SENSOR FAULT, PER FIM 32-61-00. NO FSDR AALA202507180950Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507189252Battery · no testAIRCRAFT IN BASE MAINTENANCE: WHILE PERFORMING EMERGENCY LIGHT TEST, FAULT "EPSU BATTERY MID R" WAS DISPLAYED ON THE PTP PANEL. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR WX0A2025071832503Slide · out of adjust(AIRCRAFT NOT GROUNDED) R1 DOOR NOT SHOWING SLIDE ARMED IN FLIGHT /CRUISE DURING CHECK. / ADJUSTED FWD R/H DOOR ESCAPE SLIDE ASSEMBLY IAW AMM 25-62-44-400-803-A. OPS CHECK GOOD. DOOR ESCAPE SLIDE SHOWS ARMED WHEN STOWED."SDR DALA2025071805423Lens · out of positionSHIP 5642 2L EXIT SIGN ABOVE DOOR LOOSE HITS TOP OF DOOR. CORRECTIVE ACTION: REPLACED EXIT SIGN LENSE ASSY REF B757 AMM 33-51-01. (7344756)SDR N6WA2025071801Skin · crackedFWD FUSELAGE SKIN IS CRACKED BELOW THE LH FWD EQUIPMENT BAY AT FS193 AND STGR16L. PERFORMED REPAIR ON FWD FUSELAGE SKIN BELOW THE LH FWD EQUIPMENT BAY AT FS193 AND STGR16L IAW GOJET EO-C550-53MR-074