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 GTIA2025080439032Megaphone · no testDURING WALKAROUND, FOUND FWD F/A STATION MEGAPHONE NOT TESTING AND LEAKING WATER. R & R FWD F/A MEGAPHONE IAW SPIRIT NKS DRAWINGS A320 EMER EQUIP REV 7. PERFORMED OPS TEST IAW AMM 25-65-51-710-002-A. OPS TEST GOOD AT THIS TIME.SDR DALA2025080405847Frame · damagedSHIP 3416 FRAME 57.4 R/H. TOOLING MARKS ON AFT SIDE OF FRAME. CORRECTIVE ACTION: REPAIRED PER ERA 628206-14 REV. ORIG. (1122120)SDR DALA2025080405846Frame · damagedSHIP 3416 FRAME 57.4 RT BETWEEN STRINGER 4-5 AT CROWN. NOTED TOOLING DAMAGE ON FRAME SPLICE. CORRECTIVE ACTION: REPLACED FRAME PER A330 SRM 53-11. (1123224)SDR DALA2025080405844Frame · damagedSHIP 3416 TOOLING DAMAGE ON FRAME UPPER AFT EDGE BACKSIDE FRAME 60 @ 1L. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV A. (1122580)SDR IPXA2025080476560Lever · malfunctionedMAIN ENTRY DOOR - YELLOW PUSH TO, SECURE LEVER WILL NOT ENGAGE TO THE LOCK/SECURE POSITION WITH THE ENTRY DOOR CLOSED. PERFORMED ADJUSTMENT OPS CHECK OF ENTRY/SERVICE DOOR INTERLOCK PAWL. OPS CHECK GOOD AT THIS TIME REF AMM 52-11-26-710-801SDR DALA2025080405840A/C Pack · odorSHIP 3161 STRONG ODOR WITH APU ON THE GROUND. SEEMS TO DISSIPATE WITH PACK 1 TURNED OFF. CORRECTIVE ACTION: PERFORMED WC 4900-2001, SLIGHT OIL RESIDUE IN APU BLEED DUCT, WIPED CLEAN. (6997762).SDR DALA2025080405835Fitting · corrodedSHIP 3146 LOWER FUSELAGE FWD CARGO COMPARTMENT DOOR CUTOUT LATCH FITTING WITH CORROSION AT FR27. CORRECTIVE ACTION: REPLACED LATCH FITTING IAW A319 SRM 51-72-11 -911-001. (1122732).SDR DALA2025080405829Ecs · contaminatedAIRCRAFT 5005, FA REPORTED DIRTY SOCK SMELL ON DESCENT TO LAND FROM 18000' TO 10000'. CORRECTIVE ACTION: FOUND EVIDENCE OF OIL BEHIND NUM 2 SPINNER. REPLACED SEAL. RAN ENGINE. OPS CHK ALSO PERFORMED A321 NEO AMM 21-00-00-615-803-. DECONTAMINATION OF THE ECS & SDR DALA2025080405828Power Supply · inoperativeAIRCRAFT 3094, DURING WAKE UP FOUND MID CABIN EMER LIGHT INOP. CORRECTIVE ACTION: REPLACED EPSU 11WL. (LP 8172854)SDR DALA2025080405823Oil System · lostSHIP 666 -ATB/DE- AIR TURN BACK DUE TO #2 ENGINE LOSS OF OIL QUANTITY AND PRESSURE AROUND 10,000 FEET. ENGINE PULLED BACK TO IDLE BUT NOT SHUT DOWN UNTIL AFTER LANDING. CORRECTIVE ACTION: ENGINE REPLACED DUE TO OPERATED AT 0.0 PSI FOR APPROXIMATELY 1 MIN.SDR DALA2025080405818Intercostal · crackedSHIP 6716 L2 DOOR SILL FORWARD INTERCOSTAL IS CRACKED @ STA 686 & S-11L. CORRECTIVE ACTION: REMOVED AND REPLACED INTERCOSTAL IN UPPER CABIN STA 686 S-11L IAW B757-200 SRM 51-40-02. (1122634)SDR AALA202508042454Landing Gear · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT THE LANDING GEAR WOULD NOT COME DOWN WITH MULTIPLE RECYCLE ATTEMPTS. AFTER A GO AROUND AND ANOTHER ATTEMPT, IT FINALLY CAME DOWN. THE AIRCRAFT LANDED SAFELYSDR AALA202508049621Warning Message · false activationAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO BOS DUE TO THE FLIGHT CREW REPORTING THAT DURING FLIGHT AN FLIGHT CONTROL ELAC 1 AND 2 PITCH FAULT ECAM DISPLAYED AND THE AIRCRAFT ENTERED INTO ALTERNATE LAW. THE FLIGHT CREW ACCOMPLISHED ECAM PSDR SIMA20250803001Battery · no testEMERGENCY LIGHT POWER PACK 2 FAILED "15 MIN. ON" FNC. RAR #2 EMERGENCY LIGHT POWER UNIT. OPS TEST OK. REF. E175 AMM 33-50-01. FUNCTION TEST PASSES REF. E175 AMM 33-50-01-720-801A.SDR YENA2025080400799Fmu · failedFLT#2077, MCO-PUJ. (AN EMERGENCY WAS DECLARED AND AC PERFORMED AN AIR RETURN TO MCO) "AFTER VR #1 ENGINE FAILURE. GENTLE ROLLBACK NO NOISES; PERFORMED INSPECTION PER TSM ON LP 4318574, 4318573, 4318572, 4318570 AND FOUND FMU AT FAULT. REPLACED #1 ENG FMU PER ASDR AALA202508040608Girt Bar · out of adjustAIRCRAFT IN BASE MAINTENANCE: R1 PASS/CREW DOOR IS SHOWING DISARMED ON FLIGHT ATTENDANTS PANEL WHEN THE EMERGENCY HANDLE IS IN THE ARMED POSITION. MAINTENANCE ADJUSTED GIRT ASSEMBLY FOLD TO CORRECT POSITION PER AMM 25-62-44. R1 DOOR ARM HANDLE OPERATES NORMAL SDR AALA202508046257Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: **DR5 L/H EMERGENCY POWER BATTERY CAPACITY LOW**. MAINTENANCE REPLACED POWER BATTERY AND TEST NORMAL AS PERAMM 33-51-06.SDR AALA202508045742Bottle · reads lowAIRCRAFT WAS NOT GROUNDED: L4 DOOR SLIDE BOTTLE SHOWING LOW PRESSURE. CHARGED THE L4 CYLINDER BOTTLE PER AMM 52-10-00. OPS CHECK GOOD.SDR AALA202508045563Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR EPSU FAILED TO TEST OK. MAINETNANCE REPLACED L1 DOOR EMERGENCY POWER SUPPLY UNIT (EPSU) IAWE AMM 33-51-38.SDR DALA2025080405814Seat · unsecure(LOG 7469168) SEATS LOOSE IN TRACK 17ABC, 21DEF, 26ABC. SECURED SEATS IN TRACK REF B737 AMM 25-22.SDR AALA202508047984Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE AT 0 PSI. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202508047196Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508040260Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: MID LAVATORY SMOKE ALARM VISUAL/LIGHT ON BUT NO AUDIO. MAINTENANCE ACCOMPLISHED INTERFACE AND POWER UP TEST OF THE CIDS PER AMM 23-73-00 WITH NO ISSUES NOTED. MAINTENANCE ACCOMPLISHED BITE TEST OF THE SMOKE DETECTION FUNCTION PER AMMSDR AALA202508047551Lock · stuckAIRCRAFT WAS NOT GROUNDED: MID LAVATORY DOOR LOCK JAMMED WITH PASSENGER INSIDE. THE LAVATORY DOOR HAD TO BE REMOVED FROM PART OF THE TRACK TO GET THE PASSENGER OUT. MAINTENANCE ADJUSTED AND LUBRICATED MID LAVATORY DOOR LOCK MECHANISM PER AMM 25-40-00, A SATISFSDR AALA202508046538Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 16WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR MASA2025080300063Bleed Air Sys · failedBLEED 2 FAILSDR JR2R20250803054Doubler · corrodedFLOOR GUSSET (TEXAS DOUBLER) AT FR90, RBL24, IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20250803053Sill Drain · corrodedRH MOP SILL, FROM FR88-FR90 IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20250803057Splice · corrodedOUTBOARD SPLICE DOUBLER AT RH SHEAR PANEL BETWEEN FR87-FR88 AT RBL 36 IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20250803908Skin · chafedLEFT HAND WING LEADING EDGE PANEL, ABOVE PYLON, HAS A PREVIOUS REPAIR CHAFED OUT OF LIMITS. REPAIREDSDR JR2R20250803916Skin · chafedRIGHT WING LEADING EDGE PANEL, ABOVE PYLON, HAS A PREVIOUS REPAIR CHAFED OUT OF LIMITS. REPAIRED.SDR IXXA20250803004Pressure Web · corrodedCORROSION RT WHEEL WELL HORIZ PRESSURE DECK WEB BS 1100-1107 RBL 53.96 - 70.50SDR IXXA20250803003Web · corrodedCORROSION IN RWW UPPER WEB STA 1108, RBL10SDR IXXA20250803002Skin · corrodedCORROSION ON UPPER SURFACE LEFT WING STA 205.50SDR IXXA20250803001Skin · corrodedTWO AREAS OF CORRSION ON LEFT WING UPPER SURFACE AT WING STA 451.50,SDR HALA2026090300193Stringer · corrodedDURING INSPECTION DURING HMV AS PER MPD TASK REFERENCE 534144-01-1, SIAEP FOUND CORROSION ON THE INTERNAL SIDE OF THE TOILET SERVICE PANEL REINFORCEMENT PLATE, FOUND ALONG FRAME 65 AND STRINGER 39R. UPON EVALUATION, THERE ARE NO APPLICABLE ADL AND REPAIRS IAW SDR HALA2026090300195Stringer · corrodedDURING INSPECTION DURING HMV AS PER MPD TASK REFERENCE 534144-01-1, SIAEP FOUND CORROSION ON THE INTERNAL SIDE OF THE TOILET SERVICE PANEL REINFORCEMENT PLATE, FOUND ALONG FRAME 65 AND STRINGER 39R. UPON EVALUATION, THERE ARE NO APPLICABLE ADL AND REPAIRS AS PSDR SWIA2025080275134Intercostal · corrodedCORROSION ON INTERCOSTAL STGR24L BETWEEN FS881.00 TO FS897.00 AS MARKED (C-CHECK RO 02/01/2026)CORROSION ON INTERCOSTAL, STRG24L BETWEEN FS881.00 TO FS897.00 IS FOUND TO BE IN A NO ALLOWABLE DAMAGE AREA THEREFORE FOUND TO BE OUT OF LIMITS REF CRJ-900 SRM 53-5SDR SWIA2025080275133Intercostal · corrodedCORROSION ON INTERCOSTAL, STRG24L BETWEEN FS865 -FS881 (C-CHECK RO 02/01/2026)CORROSION ON INTERCOSTAL, STRG24L BETWEEN FS865 -FS881 IS FOUND TO BE IN A NO ALLOWABLE DAMAGE AREA THEREFORE FOUND TO BE OUT OF LIMITS REF CRJ-900 SRM 53-51-03-101-003-A04REMOVED ASDR KCSA2025080268Access Door · out of adjustUPPER DECK ACCESS DOOR LATCHES WILL NOT LOCK. ADJUSTED AND ALIGNED UPPER DECK ACCESS DOOR LATCHES IAW AMM 20-00-00SDR KCSA202512080268Latch · out of adjustUPPER DECK ACCESS DOOR LATCHES WILL NOT LOCK. ADJUSTED AND ALIGNED UPPER DECK ACCESS DOOR LATCHES IAW B747-400 AMM 20-00-00SDR SWIA2025102000802Landing · corrodedINDICATIONS NOTED AT LH WING ACCESS HOLE LANDING COMMON TO PANEL 550DB APPROX. 70% FULL SCREEN HEIGHT, FAILING NDT. INDICATION AREA MARKED ON A/C. (C-CHECK RO 10/19/2025)REMOVED CORROSION FROM 550DB LANDING IAW REO 601R-57-21-030 REV. L, DATED 2014-02-05 ANSDR VNAA20251016004Stringer · corrodedCORROSION ON STGR 26RH BTW STA FS349.00 TO FS364.00 BILGE ÁREA E/ E COMPARTMENT. CORROSION ON STGR 26RH BTW STA FS349.00 TO FS364.00 BILGE ÁREA E/ E COMPARTMENT WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01, WAS EVALUTED,THEREFORE IT IS OUT OFF LIMITS PERSDR SWIA20251002802Skin · dentedRH LEADING EDGE 620JL HAS DENT (4.5" X 2.5" X 5/32") ON NOSE @ APPROX. WS.96.34. (FILED CLOSED)REMOVED AND REPLACED THE RH WING LEADING EDGE SKIN FROM WS 86.450 TO WS 139.54 IN REFERENCE WITH THE SRM 51-42-06, SRM 51-40-11 AND SRM 57-41-31. COMPLIED WITH TASSDR VNAA202509250003Hinge Fitting · excess playDURING INSPECTION OF TASK CARD :55-30-203-JIC GVI OF THE VERTICAL STABILIZER INTERNAL AREA AROUND RUDDER POWER CONTROL UNIT WAS FOUND FREEPLAY ON BEARING OF LOWER HINGE FITTING AT REAR SPAR OF VERTICAL STABILIZER. HINGE FITTING #3 (P/N: AV670-21081-013 ) WAS SDR VNAA202509250002Hinge · corrodedCORROSION ON HINGES (2EAS) AT ACCESS PANEL 832ET. HINGES (2EAS AT ACCESS PANEL 832ET WERE REPLACED PER CRJ700 SRM 51-42-06-001-A01 AND CRJ 700 SRM 51-41-02-001-001-A01SDR SWAA2025091097742Floorbeam · crackedCRACK BRAKE PANEL ASSY LOCATED BS540 BETWEEN BL 0 TO LBL 24.75 AT PASSENGER CABIN. EVALUATED CRACK ON BRAKE PANEL LOCATED BS540 BETWEEN BL 0 TO LBL 24.75 AT PASSENGER CABIN; SRM 51-10-02-0G-0 ITEM 9 MEASURED OF CRACK IS L: 0.880 INCHES. BRAKE PANEL MUST BE RSDR SWAA2025091097741Angle · crackedCRACK ANGLE LOCATED BS 695 AND BL 0 AT PASSENGER CABIN. REPLACED ANGLE LOCATED BS 695 AND BL 0 AT PASSENGER CABIN IAW B737-800 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DWG 273A9110 SHEET 6 REV A .SDR SWAA2025091097736Support Angle · corrodedCORRODED SUPPORT ANGLE, BS 500I, STRINGERS 26L - 26R IN FWD CARGO BAY. REPLACED THE SUPPORT ANGLE AND NEW FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 143A9481, SHEET 17, REV -, & DWG 143A7902, SHEET 257, REV B.SDR SWAA2025090997737Support · corrodedCORROSION SUPPORT ZEE ON FLOOR STRUCTURE LOCATED BS 500C - 500I, STRINGER 26R IN FWD CARGO BAY. REPLACED THE SUPPORT ZEE, BS 500A - 500I, S26R & THE DAMAGE WAS REPAIRED IAW SRM 53-00-53-2R-5, REPAIR 5, EA M-22-153-01550, SRM 51-40-02, DWG 143A7500, SHE