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 AALA202507255032Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507255865Connector · dirtyAIRCRAFT WAS GROUNDED: SEAT ROWS 21ABC AND 22ABC SEAT MOUNTED WHITE LENS EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE CLEANED AND RE-SEATED CONNECTOR 7260VC14 PER AMM 33-51-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202507253423Flashlight · no testAIRCRAFT WAS NOT GROUNDED: 3L FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202507254324Lock · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK ENTRY DOOR STICKS IN THE CLOSED/LOCKED POSITION AND IS DIFFICULT TO PHYSICALLY CLOSE TO THE LOCKED POSITION. MAINTENANCE LUBRICATED FLIGHT DECK DOOR LOCKS NO STICKING OR JAMMING OF THE DOOR IS PRESENT AT THIS TIME.SDR AALA202507252631Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: NOSE LANDING GEAR RIGHT HAND AFT DOOR FORWARD HINGE FITTING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-82-32.SDR AALA202507257011Button · misinstalledAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK RIGHT HAND SLIDING WINDOW HANDLE BUTTON NOT FULLY EXTENDED. MAINTENANCE CORRECTLRY INSTALLED BUTTON PER AMM 56-12-12.SDR DALA2025072505607Battery Pack · failed(LOG 7781310) EMERGENCY LIGHT BATTERY PACK NEEDS REPLACED M1676. LIGHTS TURNED OFF AFTER ONE MINUTE. REMOVED AND REPLACED BATTERY PACK AT M1676 PER B737 AMM 33-51. OPS CHECK GOOD.SDR DALA2025072505604Stringer · corroded(LOG 1103663) CORROSION ON STRINGER HAT (2 EAS) S-27L/S-27R AND BTW STA. 500E TO 500F AT FWD CARGO COMPARTMENT. STRINGER HAT (2 EAS) S-27L/S-27R AND BTW STA. 500E TO 500F AT FWD CARGO COMPARTMENT WERE REPAIRED PER B737-800 SRM 53-00-03-2R REP.1.SDR YENA2025072500764Fire Detector · faultedFLT#32, AMS-BOS. (ETOPS) "ENG FIRE LOOP FAULT LOOP B ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ); REF LPS 3504565-1/2 (REPLACED ENG 2 PYLON LOOP B HARNESS 41WD2 IAW AMM 26-12-63. OPS CHKS REQD REF LP 3504569-1 FOR OPS CHKS) AND 3504566-1/2(REPLACED ENG 2 PYLONSDR DALA2025072505593Light · brokenSHIP 3354 SEAT 50 A/B EMERGENCY LIGHT / PATH LIGHT DAMAGED / BROKEN. CORRECTIVE ACTION: R/R SEAT 50 A/B EMERGENCY PATH LIGHT PER A330 AMM 33-51. OPS CHECK GOOD. (7715377)SDR SIMA20250724002Pressure Switch · failedUPON REACHING CRUISE ALTITUDE GOT THE PRKG BRK NOT RELEASED CAUTION MESSAGE. COMPLIED WITH QRH, AND THE MESSAGE DID NOT DISAPPEAR. EMERGENCY DECLARED. PERFORMED FAILURE OF THE EMERGENCY/PARKING BRAKE SYSTEM IAW FIM TASK 32-41-00-810-864-A. CMC FAULT CODE 32400SDR FDEA202507241316Floor Panel · crackedBROKEN MCC FLOOR PANEL 241LFF. MCC FLOOR PANEL 241LFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92, APR 15, 2025.SDR FDEA202507241315Floor Panel · crackedCRACK ON MCC FLOOR PANEL 251AFF. MCC FLOOR PANEL 251AFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2, REV 92 APR 15,2025.SDR FDEA202507241314Floor Panel · crackedCRACK ON MCC FLOOR PANEL 251EFF. MCC FLOOR PANEL 251EFF WAS REPAIRED IAW SRM 53-00-50-2R PAR 4 B, FIG 201, SHEET 2, REV 92, APR 15,2025SDR FDEA202507241313Floor Panel · crackedCRACK ON FLOOR PANEL 251EFF AT MDC SEC 46 FLOOR PANEL 251EFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15/2025SDR AALA202507255409Flashlight · dischargedAIRCRAFT WAS NOT GROUNDED: FORWARD AISLE SIDE BELOW JUMPSEAT FLASHLIGHT NOT CHARGING. MAINTENANCE REPLACED THE FLASHLIGHT IAW DRAWING DFB1081 AND AMM 25-65-00.SDR CALA2025072506906Power Supply · inoperativeEPSU UNIT EMER L FAULT UPDATDED LOG WITH SDR REPORTING DUE TO BEING EMERGENCY LIGHTS SYSTEM REF GMM 04-20-16. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY IAW AMM 33-51-38. OPS CHECK GOOD NO DEFECTS NOTED. NO FAULTS.SDR CALA2025072506905Door · crackedLEFT MAIN LANDING GEAR,MID DOOR FWD LOWER CORNER APPEARS TO BE CRACKED. ACCOMPLISHED REPAIR AT L/H MLG MID DOOR IAW SRM 52-80-02-3R-3 REPAIR 3.SDR CALA2025072506904Fitting · corrodedAPU COMPARTMENT FITTING LOCATED AT LEFT AND UPPER SIDE SHOWS DAMAGE AT THE EDGE.ACCOMPLISHED REPAIR AT LEFT-HAND APU SUPPORT FITTING IN REF TO EC/RA 5342-01151.SDR CALA2025072506903Skin · dentedT-DOCS:B737-06-3-0066-61-20-01. VERTICAL FIN LEADING EDGE LEFT SIDE BETWEEN FIN STA 142.2 TO FIN STA 159.8 HAS DEEP DENT. ACCOMPLISHED REPAIR AT VERTICAL FIN LEADING EDGE BETWEEN STA 166.561 TO 175.938 SRM 55-30-01-2R-1 AND 51- 40-02-0G-0.SDR CALA2025072506902Light · detached12C EMERGENCY PATH LIGHT DETATCHED. RESECURED SEAT MOUNTED EMERGENCY LIGHT AT ROW 12ABC. OPS CHECK OK. REF AMM TASK 33-51-19-400-002-ASDR CALA2025072506901Shaft · brokenAFT JUMP SEAT BROKEN BLOCKING EXIT ITEM FLAGGED FOR SDR REPORTING REINSTALLED, JUMP SEAT, INBOARD SEAT PIVOT HINGE PIN .REFERENCE IFM 25-11-48. OPERATIONALLY CHECKS GOOD.SDR CALA2025072506900Light · faultedEMERGENCY GROUND ILLUMINATION LIGHT INOP AT ROW 25ABC. RELAMPED BULBS. NO HELP. R+R LAMP SOCKET. NO HELP. FOUND PUSH BACK PIN, RESECURE PIN & PERFORM OPS TEST PER AMM 33-51-00-710-801, LIGHT TURNS ONSDR 2025F00164Cabin Pressure · malfunctionedWHILE ENROUTE FROM KLAS TO KSNA CREW EXPERIENCED AN OPEN-DOOR CAS AROUND FL26 AND STARTED TO LOSE CABIN PRESSURIZATION. CREW INITIATED AN EMERGENCY DECENT PER THE QRH AND DECLARED AN EMERGENCY, IN WHICH CABIN PRESSURE STARTED TO MAINTAIN AGAIN AT AROUND 16,00SDR ELYA20250724003Brake Sys · lowNO BRAKE PRESSURE ON LEFT WHEEL BRAKESDR QXEA2025072400279Fan · faultedFLIGHT 2349. AFTER CHECKING THE SAFETY AND POWER UP CHECKLIST REMOTE CB TRIP "FAN 1 EBAY MID". ALONG WITH ELECTRICAL SMELL. REMOVED FROM SERVICE. REMOVED AND REPLACED MID EBAY #1 AVIONICS COOLING FAN IAW AMM TASK 21-26-400-801-A. OPS TEST GOOD. FAN 1 EBAY MID SDR QXEA2025072400280Power Supply · faultedFLIGHT 9995. REAR MOST OVERHEAD CABIN EMERGENCY LIGHT NOT FUNCTIONING. REMOVED FROM SERVICE.REMOVED AND REPLACED THE #4 EMERGENCY LIGHT POWER UNIT. REF E175 AMM 33-50-01-000-801-A AND 33-50-01-400-801-A. OPS CHECK GOOD. NOTE; ALSO REPLACED THE AFT CABIN EMERGESDR 2025F00163Panel · inflt separationDURING TAXI O/B 12 O'CLOCK PANEL 421. FR ON NR 2 ENGINE DEPARTED THE A/CSDR GTIA2025072439014Skin Panel · dentedREF LP 3579196-1 DENT ON LH WING SLAT 2 PERFORMED TEMP REPAIR PER SRM TASK 57-40-00-300-162 SRM TASK 57-40-00-300-162-PERFORMED PERMANENT REPAIR ON NOSE SKIN BTW HOLD DOWN RIB DATUM AND WFX 6721 AT SLAT #2 LH WING IAW EA 57-0085-25 PART #1 AND NEO SRM 57-40-00SDR SWAA2025072494940Sensor · faultyLE FLAPS TRANSIT LIGHT CAME ON AT 170KTS AND FLAPS 5; THEN BECAME INTERMITTENT WITH GEAR DOWN AND FLAPS 15<[01] T/S FAULT COULD 27-81222 IN REF TO FIM 27-88 TASK 805. LEADING EDGE FLAP F4 OUTBOARD SENSOR FAULTY. REMOVED AND REPLACED IN REF TO AMM 27-88-11. OPSSDR SWAA2025072494608Seat · out of adjustEMERGENCY EXIT ROW 14F SEAT BACK RECLINES WHEN RECLINE BUTTON PUSHED. ADJUSTED THE PASSENGER SEAT BACK IAW AMM 25-22-00.SDR SWAA2025072494606Seat · out of adjustEMERGENCY EXIT ROW 14D SEAT BACK RECLINES WHEN RECLINE BUTTON PUSHED. ADJUSTED THE PASSENGER SEAT BACK IAW AMM 25-22-00.SDR SWAA2025072494944Battery · inoperativeF/A FWD EMERGENCY FLASHLIGHT, LEFT SIDE WILL NOT TEST. R & R THE BATTERY IAW AMM 25-64-00.SDR SWAA2025072494936Slide · dislodgedL1 DOOR ESCAPE SLIDE FELL OUT OF THE BOX UPON OPENING DOOR POST FLIGHT. REINSTALLED FWD ENTRY DOOR SLIDE PER MT 725-61-06.SDR SWAA2025072494865Light · inoperativeAFT ENTRY EMER LIGHT INOPERATIVE. REMOVED AND REPLACED IAW AMM 33-51-06-960-804-NG.SDR SWAA2025072494866Battery Pack · inoperativeAFTER EMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK/CHARGER M1672 INOPERATIVE. R & R THE POWER SUPPLY AND BATTERY PACK AT M1672. OPS CKS GOOD IAW AMM 33-51-00.SDR SWAA2025072494896Lamp · inoperativeAFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED IAW AMM 33-51-03.SDR SIMA20250724001Brake · faultedEMERGENCY PARKING BRAKE NOT RELEASED MESSAGE IN FLIGHT. TRIED TO CYCLE BRAKE PER QRH, UNABLE TO GET MESSAGE TO ERASE. EMERGENCY DECLARED. PERFORMED FIM TASK 32-41-00-810-839-A. CLEANED AND RESECURED ELECTRICAL CONNECTOR TO EMERGENCY BRAKE ACCUMULATOR TRANSDUCESDR DALA2025072405556Radome · damagedSHIP 3119 DAMAGE TO NOSE RADOME RIGHT SIDE. CORRECTIVE ACTION: R/R RADOME PER A320 AMM 53-15-11. (1102409)SDR QR9R2025072400002Sensor · failedOVERSPEED FAIL CAUTION ON #2 ENG CAME ON APPROXIMATELY 1 MINUTE AFTER START. DURING TROUBLESHOOTING, FOUND PINS 4 AND 5 OF THE #2 OVERSPEED SENSOR CONNECTOR TO READ OPEN. PINS 2 AND 3 READ CORRECTLY. REMOVED AND REPLACED MAGNETIC SENSOR IAW ENGINE MANUAL TASK SDR CALA2025072406869Light · missing26C WHITE EMERGENCY SEAT MOUNTED PATH LIGHT INOP MISSING. WIRE STOWED. EMERGENCY EXIT ROWS 21 AND 20 ARE 5 ROWS AWAY. ONLY 1 LIGHT MISSING. ALL OTHER PROXIMITY LIGHTS FORE/AFT OPS CHECK GOOD. ACFT OK FOR CONTINUED SERVICE. INSTALLED MISSING SEAT RACESDR QR9R2025072400001Compressor · out of limitsAXIAL COMPRESSOR MODULE 02 ASSY WAS RECEIVED BAD FROM SUPPLY. AFTER RECEIVING PART, MAINTENANCE DETECTED AXIAL COMPRESSOR MOD 2 HAD MOUNTING HOLE OVERSIZED BEYOND ALLOWABLE LIMITS- VERIFIED BY SAFRAN REP.SDR FDEA202507241312Skin · delaminatedDELAMINATION ON LEADING EDGE OF INBOARD MAIN FLAP AT 33" FROM OUTBOARD EDGE, RIGHT WING. LEADING EDGE OF INBOARD MAIN FLAP RT WING WAS REPAIRED IAW SRM 57-53-01-2R FIG 201 SHEET 5 TABLE I AND SRM 51-70-03-0G PAR 5 FIG 5 SHEET 1 REV 92 APR 15/2025SDR FDEA202507241311Skin · corrodedLEFT WING TIP LOWER SKIN STATION XW 998 FOUND CORRODED. REPAIR CARRIED OUT IAW EA 1-5730-T0384251 PART 1 (P1). REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA202507241310Skin · crackedNR 1 AIR CON RAM AIR EXHAUST CUTOUT CORNER DOUBLER FOUND CRACKED AT BS 565. REMOVED AND REPLACED WITH FABRICATED DOUBLER PER MD-11 SRM 51-31-01-G. DOUBLER FABRICATED PER DOUGLAS DRAWING ACA3850 REVISION AA. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR N3XR202507240852Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR JR2R20250724722Skin · scratchedSCRATCH AT BOTTOM OF L2 DOOR. REPAIRSDR JR2R20250724763Beam · corrodedFWD FUSELAGE LONGITUDINAL BEAM IS CORRODED AT RBL 10 BETWEEN FR 12 TO FR 17. REPLACEDSDR REXA2026072901289Membrane · crackedCRACK ON FWD MEMBRANE OF INBD DOOR AT LH MLG FWD MEMBRANE OF INBD DOOR AT LH MLG WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01SDR 2026F00041Engine · damagedUNKNOWN INTERNAL ENGINE COMPONENT CAUSING BURNING OF OIL AFTER ENGINE OVERHAUL AND REPLACEMENT OF ALL 4 TURBINE WHEELS. FIRST OCCURRENCE RECORDED AFTER SMOKE WAS OBSERVED COMING FROM THE EXHAUST WHEN THE AIRCRAFT WAS AT IDLE AND DURING SHUTDOWN AFTER A FLIGHT