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 SWAA2025062785442Battery Pack · inoperativeFWD FA FLASHLIGHT IS INOP FWD FLIGHT ATTENDANT FLASH LIGHT IS INOP<[01] REMOVED AND REPLACED BATTERY PER AMM 25-64-00.SDR SWAA2025062785338Flashlight · inoperativeAFT EMERGENCY FLASHLIGHT INOP. OK TO CONTINUE PER MEL 25-12-01; SP1B; AUTHORIZAT AFT EMERGENCY FLASHLIGHT INOP. OK TO CONTINUE PER MEL 25-12-01 SP1B AUTHORIZATION #<[01] PERFORMED AFT EMERGENCY FLASH LIGHT OPERATIONAL CHECK IAW AMM 25-64-00.OPS CHECK NORMALSDR SWAA2025062785487Flashlight · inoperativeONE AFT GALLEY FLASHLIGHT INOP<[01] R/R AFT GALLEY FLASHLIGHT UNDER RH FA SEAT INBD . REF AMM 25-64-00SDR SWAA2025062785450Girt Bar · out of adjustFWD SVC DOOR GIRT BAR NEEDS ADJUSTMENT.<[01] PERFORMED ESCAPE SLIDE PACK CHECK. REF AMM 25-66-01. OPS CHECK NORMAL.SDR SWAA2025062785269Retainer · missingFWD SERVICE DOOR SLIDE RIGHT HAND GIRT BAR RETAINER CLIP IS MISSING A FASTENER.<[01] REPLACED MISSING FASTENER ON FWD SERVICE DOOR ESCAPE SLIDE RH GIRT BAR RETAINER CLIP PER SRM 51-40-02.SDR SWAA2025062785458Skirt · out of positionAFT ENTRY DOOR SLIDE EXCESSIVE FABRIC<[01] REPOSITIONED AFT ENTRY SKIRT SLIDE PER AMM 25-66-01 AND TASK MT 725-61-06.SDR SWAA2025062785273Battery Pack · inoperativeR1 ESCAPE SLIDE EMERG LIGHT INOP<[01] 01 - REMOVED AND REPLACED PER [AMM 33-51-06-960-805-NG (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT)]SDR SWAA2025062785436Lamp · inoperativeLEFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT INOP<[01] RELAMPED IAW AMM 33-51-03SDR SWAA2025062785710Sign · detachedEMERGENCY EXIT SIGN FELL OFF CEILING AT OVERWING; EXIT ROW.<[01] RESECURED OVERWING CEILING EMERGENCY EXIT SIGN; OPS CK GOOD REF M/M 33-51-01SDR SWAA2025062785439Lamp · inoperativeL/H OVER WING EMERGENCY EXIT SIGN AREA LIGHTS INOP<[01] REVAMPED L/H OVER WING EMERGENCY EXIT SIGN AREA LIGHTS & OPS CHECK GOOD REF AMM 33-51-01.SDR G1IA20250625093Motor · faultedDURING OUR CLIMB, PILOT NOTED THAT THE AIR CONDITIONING HAD NOT ACTIVATED AT ALL.SDR DXTA2025062704042Trim System · out of adjustELEVATOR TRIM IS NOT WITHIN NORMAL FLIGHT RANGE AND UNABLE TO INPUT ENOUGH NOSE DOWN TRIM TO NEUTRALZE CONTROL FORCE. FULL FORWARD NOSE DOWN TRIM AND AIRCRAFT STILL HAS NOSE UP TENDENCY. ADJUSTED POSITION OF CONTROL WHEEL/TRIM INDICATOR TO COINCIDE WITH THE PSDR DXTA2025062704046G Switch · failedUPON COMPLETION OF LAST FLIGHT OF DAY & POST FLIGHT SHUTDOWN AND INSPECTION, DISCOVERED EMERGENCY LIGHTS IN AFT OF PLANE ON & COULD NOT EXTINGUISH (EXIT SIGN ABOVE TOILET, EMER LIGHT ABOVE TOILET, FLOOR LIGHT BELOW TOILET, & EXIT SIGN ON BULKHEAD ABOVE SEAT 7)SDR YENA2025062700657Transmitter · failedFLT#2220, LHR-JFK. NR 2 ENG OIL QTY SENSOR INOP; REMOVED AND REPLACED #2 ENG OIL QTY SENSOR IAW AMM 79-31-21-400-801A.FAULT CLEARED. OK FOR SERVICE.SDR AALA202506275900Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R DOOR GERT BAR DOES NOT RETAIN THE SLIDE BAR. READJUSTED GIRT BAR. PER AMM 25-66-01.SDR AALA202506271795Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE NEEDS REPLACEMENT. REPLACED AFT MEGAPHONE.SDR JJBA20250627021Light · misinstalledRH OVERWING EXTERNAL EMERGENCY LIGHT INSTALLED UPSIDE DOWN. INSTALLED RH OVERWING EXTERNAL EMERGENCY LIGHT CORRECTLY.SDR JJBA20250627020Charger · inoperativeAISLE AFT EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING. OPS CHECK FAILED. REMOVED AND REPLACED #4 EMERGENCY LIGHT BATTERY CHARGER ASSEMBLY. OPS CHECK SAT.SDR JJBA20250627019Battery Pack · no testMULTIPLE EXTERIOR AND INTERIOR EMERGENCY LIGHT INOPERATIVE. SUSPECT BAD BATTERY. REMOVED AND REPLACED EMERGENCY BATTERY 3. OPS CHECK SAT.SDR DALA2025062704809Battery Pack · no testSHIP 193 LT O/W SLIDE SQUIB LIGHT NOT ILLUMINATED DURING SQUIB TEST 1. CORRECTIVE ACTION: T/S PER B767 FIM 25-65-00. FOUND BAD LT O/W SLIDE BATTERY. R/R LT O/W SLIDE BATTERY PER B767-300 AMM 25-65-17. LT O/W SLIDE SQUIB TEST CKS GOOD. P/N ON AD2013-1A. (731745SDR HYIA20250627002Rib · crackedDURING SCHEDULED INSPECTION, A CRACK WAS VISUALLY IDENTIFIED ON THE RIGHT HAND CLOSEOUT RIB LOCATED AT RWS 106.79. THIS CRACK IS LOCATED IN THE FORWARD VERTICAL ROW OF FASTENERS COMMON TO THE AFT TRUNNION SUPPORT. IT TRAVELS IN AN UP AND DOWN DIRECTION BETWEENSDR CALA2025062706011Director · faultedSTBY ATTITUDE INDIC OSCILLATING BETWEEN 10 DEGREES AND 30 DEGREE NOSE UP AND30 DEGREES REMOVED ISFD UNIT REFMM 34-24-02 FOR IDENTIFICATION,PULLED 3 TOTAL CBS 2 ON P6-3 AND 1 ON ISFD BATTERY IN E & E COMPARTMENT PER MM 34-24-02 REPLACED ISFD AMM 34-24-02, ALL FSDR CALA2025062706010Fire Loop · damaged1 ENG OVERHEAT ILLUM AND EXTINGUISHED FOR APPROX 5-10 SECONDS ON INITIAL CLIMB TOMC LOCKS LOG PAGE AFTER DUAL AIR RETURN WHILE PERFORMING INSPECTION WHEN REMOVING LEFT CORE HARNESS DETECTOR CERAMIC SHIELDING CRACKED AND BROKE APART ALSO FOUND RIGHT SIDE GROUNDSDR CALA2025062706003Battery · inoperativeR1 DOOR M33094 EMERGENCY POWER SUPPLY BATTERY PACK FOUND MALFUNCTION. PERFORMED BY EMP V903218, IDT BY EMP V905467. REPLACE R1 DOOR M33094 EMERGENCY POWER SUPPLY BATTERY PACK AND C/O NEW BATTERY PACK INSTALLATION TEST. THE RESULT FOUND NORMAL AS PER AMM 33-51 SDR CALA2025062706002Web · corrodedAFT CARGO COMPARTMENT, SILL PLATE INNER WEB HAS EXFOLIATED CORROSION. REMOVED AND REPLACED AFT CARGO COMP SILL PLATE, LOCATED AND DRILLED, IAW B737-800 SRM 51-40-02, 51-40-05.SDR CALA2025062706001Stiffener · crackedFR1 PRESSURE BULKHEAD L/H SIDE 2ND STIFFENER FROM THE TOP FOUND TO BE CRACKED. REMOVED AND REPLACED STIFFENER AT FR1 PRESSURE BULKHEAD IAW A320 SRM 51-72-11-911-001.SDR CALA2025062706000Skin · damagedREMOVE DAMAGED DOUBLER, MAP OUT DAMAGE OF SKIN PANEL. REMOVED DAMAGED DOUBLER IAW SRM 51-42-11/001 FABRICATED NEW REPAIR DOUBLER AS DIRECTED BY RFTS 60004 PG2 A319 SRM 53-21-11- 300-093. INSTALLED REPAIR DOUBLER IAW A319 SRM 51-42-11/001.SDR CALA2025062705999Panel · corrodedBULK CARGO FR 63-65 RSTR38 PROFILE PANEL HAS CORROSION. REMOVED AND REPLACED PROFILE PNL IN BULK CARGO FR63-65 RSTR 63 I NSTALLED NEW IAW SRM 51-42-11/001.SDR CALA2025062705998Panel · corrodedAFT CARGO FR 58-59 LSTR32 PROFILE PANEL HAS EVIDENCE OF CORROSIO N AND IS LOOSE. REMOVED DAMAGED (FOUND WITH EVIDENCE OF CORROSION AND LOOSE FIT) INSTALLED NEW PROFILE PANEL AT FR58-59 LSTR32 IAW SRM 51-42-11/ 001.SDR CALA2025062705997Panel · corrodedAFT CARGO FR 56 LSTR38-RSTR41 PROFILE PANEL IS CORRODED AND LOOSE. REMOVED AND REPLACED PROFILE PNL AT FR56 LSTR38-RSTR41 IN AFT CA RGO IAW SRM 51-72-11-911-002 / SRM 51-42-11/001.SDR CALA2025062705996Lamp · burned outDOOR 2 R EMER LIGHT NEEDS RELAMP. RELAMP DOOR 2 RH EMER EXIT LIGHT REF AMM 33-51-01. OPS CHECK GOOD.SDR CALA2025062705995Seat Track · corrodedY-1292 SEAT TRACK FR 24-35 CORRODED OUT OF LIMITS. REMOVED AND REPLACED DISCREPANT SEAT TRACK AT Y-1292 FR24-35 IAW A319 SRM 51-42-11-001.SDR CALA2025062705994Floor Support · corrodedAFT FLOOR SUPPORT Y 765 AT FR 64-65 HAS CORROSION AT HARD POINT. REMOVED AND REPLACED 1EA FLOOR BEAM (Y765) AT AFT FUSELAGE L/H S IDE IAW A319 SRM 51-47-11/001 AND A319 SRM 51-72-11-911-001.SDR CALA2025062705993Frame · dentedAFT CARGO COMP, LH SIDE, LOWER FRAME STA 1 500, HAS A DENT. SDR REPORTING ONLY PERFORMED REPAIR I.A.W. EA#757-5360-13-A3954. RII VERIFIED REPAIR PERFORMED.SDR CALA2025062705992Floor Support · corrodedAFT FLOOR SUPPORT Y 1292 AT FR 64-65 HAS CORROSION AT HARD POINT. REMOVED AND REPLACED 1EA FLOOR BEAM *Y1292) AT AFT FUSELAGE L/H SIDE IAW A319 SRM 51-42-11/001 AND A319 SRM 51-72-11-911-001.SDR CALA2025062705991Access Panel · missingRIGHT WING LEADING EDGE PANEL 621DB IDENTIFIED AS AN OUTBOARD LE SLAT MECHANISM LUBRICATION ACCESS DOOR/PANEL. DISCREPANCY PLACED ON CDL 57F LOG 5326724SDR CALA2025062705989Oven · contaminatedAFT GALLEY OVENS 707/708 CAUSED HAZE AND ELEC ODOR FROM VENT BEH IND SPOKE WITH CREW ON INBOUND, OVEN 707 WAS THE ISSUE - REAR FAN VENT OF OVEN IS SCORCHED WITH BURNT FOOD AND FAN LOOKS TO BE BURNT TOO. REQUIRES REPLACEMENT. OVEN 708 OPS OK, NO SMELL WHEN SWITSDR CALA2025062705986Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK AT M1694 FAILS 15 MIN CAPACITY. REMOVED AND REPLACED EMERGENCY BATTERY PACK M1694 IAW AMM 33-52-06-960-805.PARTS USED: 99-3351-3-0015, QTY :1SDR CALA2025062705981Clamp · no discrepancy1L/1R GIRT BAR CLAMP LOOSE PER FA PERFORMED ESCAPE SLIDE CHECK AMM25-66-01-200-802, INSPECTED BOTH 1L/1R GIRT BAR & J-HOOK , NO DISCREPANCIES FOUND, OPS CHECK GOOD.SDR CALA2025062705980Slide · no discrepancyDOOR 1R SLIDE HAS YELLOW RAFT MATERIAL PROTRUDING FROM BOTTOM. NO DEFECTS NOTED REFERENCE AMM 25-66-00.SDR DALA2025062604804Rib · gougedSHIP 3135 GOUGE OB FLAP ON INBOARD RIB LOWER AREA AT INTERCONNECTING STRUT ARE ON RH WING. CORRECTIVE ACTION: COMPLIED WITH ER/A 626573-14. (1045570).SDR DALA2025062604803Crossbeam · crackedSHIP 3135 CRACK INDICATION WAS FOUND AT HOLE #2 AND #16 OF CROSSBEAM JUNCTION AREA OF FR16RH. CORRECTIVE ACTION: COMPLIED WITH ER/A 626548-14AD. (1045556).SDR DALA2025062604802Bulkhead · crackedSHIP 3135 CRACK WAS FOUND AROUND A FASTENER HOLE COMMON TO THE BULKHEAD AT FR35 AND STGR 30 LH LEVEL. CORRECTIVE ACTION: COMPLIED WITH ER/A 575262-14AD. (1042906).SDR DALA2025062604801Bulkhead · crackedSHIP 3135 FOUND CRACK AT HOLE #1, #3 AND #8 COMMON TO THE BULKHEAD AT FR35 AAND STGR 30 LH LEVEL. CORRECTIVE ACTION: COMPLIED WITH ER/A 575262-14AD. (1045874).SDR DALA2025062604800Structure · crackedSHIP 3135 CRACK WAS FOUND AROUND A FASTENER HOLE COMMON TO THE BULKHEAD AT FR35 AND STGR 30 LH LEVEL. CORRECTIVE ACTION: COMPLIED WITH ER/A 575262-14AD. (1045830).SDR DALA2025062604799Frame · crackedSHIP 3135 FOUND CRACK AT HOLE W1, W3 IN FRAME35 WEB & HOLE #2 IN FRAME FLANGE. CORRECTIVE ACTION: COMPLIED WITH ER/A 575262-14AD. (1045802).SDR DALA2025062604798Stiffener · crackedSHIP 3135 CRACK INDICATION ON HORIZONTAL UPPER STIFFENER OF LATERAL WINDOW FRAME 4 LH SIDE. CORRECTIVE ACTION: COMPLIED WITH ER/A 575007-14AD. (1045582).SDR DALA2025062604797Skin · chafedSHIP 3135 CHAFING MARK ON EXTERNAL FUSELAGE SKIN AT FRAME 34 BETWEEN STRINGER 43 LH AND RH. CORRECTIVE ACTION: COMPLIED WITH ER/A 575113-14AD. (1045547).SDR DALA2025062604796Spar Cap · crackedSHIP 9584 CRACKS FOUND DURING INSPECTION OF LH WING REAR SPAR LOWER CAP AFT LEG. CORRECTIVE ACTION: COMPLIED WITH 627199-14 REV A LH WING REAR SPAR LOWER CAP CRACK REPAIR. (1045285)SDR DALA2025062604795Skin · crackedSHIP 9574 FUSELAGE SKIN. VISUAL INDICATION OF CRACK. LOCATED ABOVE #1 PYLON AT STA 1022. CORRECTIVE ACTION: REPAIRED PER E/RA 624873-14 REV. ORIG. (1045993)