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 AALA202508264045Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SPLICE UPPER OUTBOARD POSITION LOCATED AT FR66 AT LEVEL STRG 23LH SIDE AFT GALLEY AREA MEASURE OF DAMAGE ARE L: 0.744 INCHES ; W: 0.596 INCHES, D: 0.050 INCHES. MAINTENANCE REPLACED SPLICE COUPLING AT FR66 AT LEVEL STSDR COEA2025082502819Skin · dentedWO 270166 NR 26 HAIL DAMAGE/MAJOR REPAIR DISCREPANCY: DENTS ON R/H HORIZONTAL STABILIZER UPPER SURFACE. CORRECTIVE ACTION: REPAIRED PER ATR72 SRM 550000-300-801-A01.SDR R61A2025082500373Seal Rest · corrodedDURING HEAVY CHECK FOUND CORROSION AFT CARGO CUT OUT, AFT UPPER SEAL REST BETWEEN FR 79-80 FOUND CORRODED. REPAIRED IAW ETD 2025-170-926736SDR R61A2025082500372Seal Rest · corrodedDURING HEAVY CHECK FOUND CORROSION CF I FWD CARGO DOOR CUTOUT, AFT LOWER SEAL REST BETWEEN FR 26-27 STGR 26R FOUND CORRODED. REMOVED AND REPLACED AFT LOWER SEAL REST IAW SRM 51-41-01SDR R61A2025082500371Seal Rest · crackedDURING HEAVY CHECK FOUND CORROSION CF I FWD CARGO DOOR CUTOUT MIDDLE LOWER SEAL REST BETWEEN. FR25-26, STGR 26R FOUND CORRODED. REMOVED AND REPLACED MIDDLE LOWER SEAL REST IAW SRM 51-41-01SDR R61A2025082500370Shear Tie · crackedDURING HEAVY CHECK FOUND CORROSION CF III FR 83 STR 27R -28R SHEAR CLIP CORRODED. REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-41-02SDR R61A2025082500369Shear Tie · crackedDURING HEAVY CHECK FOUND CORROSION CF III FR 82 STR 27R - 28R SHEAR CLIP CORRODED. REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-41-02SDR 2025FA0000565Shaft · corrodedCORROSION PITTING REMAINED ON THE SHANK NUT HOLE LOCATION 30 OF ESN 26028 IPC REAR STUB SHAFT AFTER MACHINED TO THE MAXIMUM LIMIT IAW RR EM FRSC383. PART WAS REJECTED BY RR TV255302 (CSN: 2473 SDC) WHICH IS RETIRED BEFORE ITS DECLARED LIFE IN TLM (7123 SDC).SDR AALA202508202298Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 345, LBL 58. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202508193300Bustle · crackedAIRCRAFT IN BASE MAINTENANCE: BRACKET BELOW DOOR OPERATING MECHANISM BASKET CRACKED. INSTALLED R1 SLIDE PACK. PER AMM 25-66-01-400-801.SDR DALA2025081806141Seal · leakingDIRTY SOCK ODOR DETECTED ON SHORT FINAL AGTER ENGINE HAD BEEN AT IDLE/LOW POWER FOR A SIGNIFICANT TIME. REPLACED BOTH ENGINE INLET COVER SEALS AND PERFORMED DUCT BURNOUT LEVEL B DECONTAMINATION A321 NEO AMM 21-00-00-615-803-A & AMM 36-10-00-615-805-A. (LP 73SDR AALA202508182911Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED FORWARD GIRT BAR TIEDOWN AT BS 313, LBL 54. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR DALA2025081606133Life Raft · openAFT OVERHEAD BIN LIFE RAFT OPEN. REPLACED LIFE RAFT AT 32ABC AND INDUCTED INTO AEROCHECK PER A320 AMM 25-66.SDR DALA2025081406103Chiller · noiseCHILLER INOPERATIVE OR DAMAGED - EXCEPT A350, LOCATIONS:410, FRC253302410 CHILLER GOT VERY NOISY AND HAD A BURNING ODOR. TURNED OFF THE CHILLER NR 2 SWITCH TO STOP LOUD NOISE. INTERIOR. R & R ACU AND SERVICED AIRCRAFT IAW AMM 25-31. OPS CHECK GOOD AT THISSDR CALA2025081407764Skin · delaminatedRIGHT WING OUTBOARD AILERON HAS DELAMINATIONDELAMINATED AREA TAP TESTED AND MAPPED. LOWER SURFACE DIMENSIONS OF DELAM MEASURE AT 18" IN LEGNTH BY 9" IN WIDTH. IT HAS AN EDGE DISTANCE 1.5" AND A TRAILING EDGE DISTANCE OF 5" UPPER SURFACE OF AILERON TAP TESTED SDR CALA2025081407761Structure · no discrepancyPERFORM AN INSPECTION PER PART 2 OF THE LATEST REVISION OF ECRA 5311-03385 ON OR BEFORE 29-JULY-2027 REF LP 5753762 FOR INTERIM REPAIR.SDR CALA2025081407729Sensor · faultedSTABILIZER CONTROL CHANNEL (L2) HAS BEEN DEFERRED IN COMPLIANCE WITH MEL CARD 27105. DEACTIVATED THE INOPERATIVE STAB CONTROL CHANNEL AS REQUIRED ON CARD 27105, IAW AMM DDG 27-41-03. INSTALLED INOPERATIVE STICKER ADJACENT TO AFFECTED L2 STAB CUTOUT SWITCH ONSDR 3EJA2025081400009Door · warning messageDESCENDING FROM 39,000 FEET WE GOT AN AMBER DOOR SEAL LIGHT IMMEDIATELY FOLLOWED BY A LOSS OF PRESSURIZATION.SDR DALA2025081306056Shear Tie · crackedCRACKS FR43 RH FRAME FOOT COUPLING. CORRECTIVE ACTION: REPAIRED PER AA WORK CARD 5311-01239-02B AND A319 SRM 53-11.SDR DALA2025081306055Shear Tie · crackedCRACKS FR43 LH, FRAME FOOT COUPLING. C/W AA WORK CARD 5311-01239-02A AND PER A319 SRM 53-11.SDR VNAA2025081311101Sensor · faultedELEVATOR SPLIT CAUTION MSG AND CAS MIS COMP STATUS MSG. REMOVED & REPLACED LH ELEVATOR POSITION SENSOR IAW CRJ 900 AMM 27-34-10-000/400-801-A02; OPS CHECK GOOD.SDR SWAA2025081399953Unknown · odorBAD SMELL AFT GALLEY<[01] PERFORMED ENGINE RUN #1 & #2 SEPARATELY ISOLATING LH AND RH PACKS. NO SMELLS NOTED. OPERATED PACKS WITH APU. NO SMELLS NOTED. PER AMM 71-00-00. GVI OF AFT GALLEY NOTHING WET OR SMELLY. NO SMELLS IN AFT CARGO COMPARTMENT.<BR><BR>134062SDR SWAA2025081399978Flashlight · no testFARE AND AFT FA BATTERY IS NOT TESTING<[01] CHANGED FLASHLIGHT BATTERIES PER AMM 25-64-00. OPS CHECK GOODSDR SWAA2025081303947Battery Pack · no testFARE AND AFT FA BATTERY IS NOT TESTING<[01] CHANGED FLASHLIGHT BATTERIES PER AMM 25-64-00. OPS CHECK GOODSDR SWAA2025081399954Stop · missingFWD ENTRY DOOR GIRT BAR STOP MISSING. INSTALLED FWD ENTRY DOOR SCAPE SLIDE GIRT BAR STOP IAW AMM 25-66-01.SDR SWAA2025081399878Bulb · inoperativeAFT CABIN CENTER OVERHEAD EMERGENCY LIGHT SIGN 1 EA BULB INOP. RELAMPED AFT CABIN CENTER OVERHEAD EMERGENCY LIGHT SIGN AND OPS CHECK GOOD IAW SWA B737-800 AMM 33-51-01-960-801.SDR SWAA2025081399898Battery Pack · inoperativeALL EMERGENCY LIGHT ARE INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER ASSY AT EMEGENCY ROW L/H FWD.SDR SWAA2025081399909Handle · looseAFT SERVICE DOOR INTERIOR DOOR HANDLE LOOSE. RESECURED AFT SVC DOOR INEROR HANDLE; OPS CK GOOD PER AMM 52-41-00.SDR SWAA2025081399761Cover Plate · crackedAFT GALLEY SERVICE DOOR; DOOR HANDLE COVER PLATE CRACKED. REMOVED AND REPLACED AFT GALLEY DOOR; DOOR HANDLE COVER PLATE PER AMM 52-41-31.SDR SWAA2025081300006Light · burnedPAX CABIN 2 EA EMERGENCY LIGHT BURNED AT 11R AND 16R SEATS POSITIONS. REPLACED PAX CABIN 2 EA EMERGENCY LIGHT AT 11R AND 16R SEATS POSITIONS. I.A.W B737-700 AMM 33-51-03-960-802 STEP 2.D.(4) TEST ARE OK.SDR DALA2025081306053Actuator · looseSEAT ROW 30 D + E LOOSE. FOUND SEAT ACTUATORS LOOSE.TIGHTENED HARDWARE. BOTH SEATS 30 D AND E SECURED.SDR DALA2025081306052Intercostal · corrodedCORROSION ON SEVERAL INTERCOSTALS (9 EAS) BTW STA 450 TO STA 500I WAS FOUND AFTER REMOVAL OF LH SIDE PLATE AT FWD CARGO COMPARTMENT. INTERCOSTALS (9 EAS) BTW STA 500 TO STA 500I OF LH SIDE PLATE AT FWD CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0SDR AALA202508135007Hydraulic Line · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE THE FLIGHT CREW REPORTING A GREEEN HYDRAULIC SYSTEM FAILURE CLIMBING THROUGH 8000FT. FLIGHT CREW ACCOMPLISHED THE ECAM AND QRH PROCEDURES ALONG WITH A MANUAL GEAR EXTESDR UIEA2025080901117Engine · vibrationNR 2 ENG EXCESSIVE VIBRATION 4.5 N1. NO CHANGE WHEN THROTTLE REDUCED AT CRUISE LEVEL. VIBRATION FELT THROUGH RUDDER PEDALS. MAX RECORDED 5.0(<P>#2 ENG 2 EACH BALANCE WEIGHT REMOVED, ENG #2 VIB TRIM BALANCE PERFORMED IAW AMM 71-00-00 & AMM 72-31-00. RESULT MAX SDR CALA2025081307688Cap · missingPDA 2 PDA CREATED FOR FUEL CAP MISSING LP#5856941 REFERENCE LP# 5856941 FOR CLEARING OF LOGPGE.SDR AALA202508131714Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 14H EMERGENCY LIGHT FAIL. MAINTENANCE REPLACED EMERGENCY LIGHT AT SEAT 14H IAW AMM 33-51-05.SDR DALA2025081306038Cabin Pressure · malfunctionedATB RETURN TO BOS DUE TO CABIN ALTITUDE WARNING. CORRECTED LANDING ALTITUDE SETTING ON CABIN PRESSURE CONTROL PANEL. BIT CBN AUTO PRESS CONTROLLERS 1 AND 2. NO FAULTS NOTED. PRESSURIZED A/C TO ENSURE NO MAJOR LEAKS. A/C RETURNED TO SERVICE.SDR SIMA20250809002Flashlight Assy · inoperativeCAPTAIN EMERGENCY FLASHLIGHT INOP RAR CAPTAINS EMERGENCY FLASHLIGHT IAW AMM 33-51-01 NO FURTHER DISCREPANCY NOTEDSDR NACA2025080900001Pump · faultedLEFT FWD FUEL PUMP EICAS CAME ON IN-FLIGHT, AND LEFT FWD FUEL PUMP PRESSURE LIGHT ILLUMINATED. RAN THE QRH. PERFORMED FIM 28-22 FAULT TREE 819. BLED L FWD FUEL PUMP PRESSURE SENSE LINE PER AMM 28-22-03, OPS CHECK AND LEAK CHECK GOOD.SDR SWAA2025081299969Tray · broken12F TRAY TABLE BROKEN (EM. EXIT ROW). SECURED 12F T/T PER CMM 25-21-42.SDR DALA2025081206013Shear Tie · damagedSHIP 3415 FR26.1 LH BRACKET FWD SIDE HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPLACED SHEAR TIE PER A330 SRM 53-21-12-29A. (1134641)SDR DALA2025081206011Girt Bar · fodSHIP 3357 CREW REPORTS L2 DOOR WILL NOT ARM. CORRECTIVE ACTION: CLEANED DEBRIS OFF GIRT BAR. OPS CHECK GOOD. (7572978)SDR AALA202508123265Terminal · crossedAIRCRAFT WAS NOT GROUNDED: EMERGENCY CEILING LIGHT ABOVE SEAT ROW 23 IS INOPERATIVE. MAINTENANCE FOUND CROSSED TERMINALS AT CEILING LIGHT ASSEMBLY AND REPOSITIONED TERMINALS TO GROUND AND POSITIVE, A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED PER AMM 33-5SDR AALA202508126563Sleeve · damagedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PYLON LEFT HAND SIDE FORWARD UPPER ATTACH FITTING SLEEVE (PIN) HAS DAMAGED THREADS. REPLACED SLEEVE (PIN) PER TASK CARD 26C42554028.SDR AALA202508128803Landing · damagedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR FRAME AFT CENTERING GUIDE LANDING DAMAGED. REPLACED CENTERING GUIDE LANDING PER DRAWING 141A8160.SDR AALA202508121514Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT ANGLE UPPER SURFACE HAS AT FR 56 BETWEEN LBL 22 AND LBL 26. REPAIRED FLOOR SUPPORT ANGLE PER SRM 51-73-11-801.SDR AALA202508127498Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND FLOOR SUPPORT ANGLE UPPER SURFACE BETWEEN FR 52 AND FR 56 AT LBL 28. REPAIRED SUPPORT ANGLE PER SRM 51-73-11-801.SDR AALA202508123188Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508122348Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508122376Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.