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 JJBA20250711024Floorbeam · corrodedAT FRAME 20 IB FLOOR SUPPORT CAP PLATE IS CORRODED. REMOVED CORROSION AT FRAME 20 IB FLOOR SUPPORT CAP PLATE. REMOVED AT FRAME 20 IB FLOOR SUPPORT CAP. LOCATED, DRILLED AND INSTALLED NEW PART.SDR JJBA20250711014Floor Support · corrodedRH RBL 48 FRAME 52 FLOORSILL CORRODED. REMOVED CORROSION RH RBL 48 FRAME 52 FLOORSILL FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED AND INSTALLED NEW SILL.SDR HEEA202507110001Oil Cap · looseWHITE ENG TREND MESSAGE, FOLLOWED BY RED ENG 2 OIL LOW PRESS DISPLAYED IN CRUISE FLIGHT. BROUGHT ENG 2 TO IDLE. ENG 2 OIL LOW PRESS MESSAGED EXTINGUISHED.SDR IPXA2025071043323Rib · crackedMAJOR REPAIR, CRACK - RIB, R/H WING T/E CAVITY, UPPER SIDE, WBL 445 (REPAIR) 1. ACCOMPLISHED REPAIR I.A.W EO-93910-REQ1 REV.1 AND EI F2025A57M-1387 REV.1 2.SDR AALA202507098827Oil System · leakingAIRCRAFT WAS GROUNDED: ODOR IN CABIN AND FLIGHT DECK ON TAXI OUT AND IN CLIMB, MUSTY/DIRTY SOCK SMELL. MAINTENANCE FOUND THE APU LEAKING OIL AND REPLACED IT PER TASK CARD 26L31049003. A DECONTAMINATION OF THE ENVIRONMENTAL CONTROL SYSTEM WAS ACCOMPLISHED PERSDR AALA202507088645Relay · inoperativeAIRCRAFT WAS GROUNDED: LEFT MAIN AFT FUEL PUMP WILL NOT SHUT OFF. REMOVED AND REPALCED GFI RELAY R18. PER AMM 28-22-18. OPERATIONAL CHECK OF RELAY AND LOW PRESSURE SWITCH GOOD. PUMP WORKING PROPERLY. PER AMM 28-42-11.SDR SCNA20250707244Skin · corrodedR/H FUSELAGE FROM STA663 TO AFT PRESSURE BULKHEAD HAS SIGNS OF CORROSION ALONG LAP SEAM. ACCOMPLISHED EA 737-5360-72-B0528 P1, EA 737-5360-72-B0528 REV I/R AND SCA EA 53-0251. 83658 SAA001 27JUN25 CONTINUED ON SUPPLEMENT # 110668, 111233, 111241, 111242, 1112SDR AALA202507069533Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ROW 18 INOP. MAINTENANCE RESECURED C/P UNDER SEAT 18 ABC TO EMERGENCY LIGHT OPS CKD NORMAL AS PER MM 33-50-00.SDR AALA202507043077Skin · erodedAIRCRAFT IN BASE MAINTENANCE: MISSING MATERIAL LOWER SKIN SLAT 2 TRAILING EDGE AREA ON RH WING. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR LOCATED RH WING SLAT 2 TRAILING EDGE BELL END BOTTOM SURFACE IAW EA 365303.SDR ASAA2025062759121Power Supply · intermittentR1 DOOR EMERGENCY LIGHTS INTERMITTENTLY COME ON WITH SYSTEM IN OFF. GROUNDED - YES. REMOVED AND INSTALLED SERVICEABLE R-1 DOOR EMERG LIGHTS POWER SUPPLY S/N 341788, OPS CHECKS GOOD IAW B737-900 AMM 33-51-06-960-806.SDR DXTA2025063004069Trim System · faultedLEFT BASE, FLAPS 20, RECEIVED AMBER AP STAB TRIM FAIL. PER QRH TURNED AUTOPILOT OFF & FLEW APPROACH TO LAND. DID HAVE TROUBLE PUSHING PLANE NOSE DOWN AFTER ADDING FLAPS 30 AND ALL THE WAY TO LANDING. PLANE HAS HAD RECENT WRITE UP FOR PRIMARY FLIGHT CONTROLS ISDR DALA2025070104953Charger · inoperativeSHIP 669 SEAT MOUNTED EMERGENCY LIGHTS FROM 23-26 INOP. REPLACED BATTERY CHARGER AT M10567 PER B757 AMM 33-51, FOUND WIRE AT SEAT 23D PINCHED, REPAIRED PER B757 SWPM 20-10. OPS CHKS GOOD. (6757366)SDR DALA2025070104952Indicator · inoperativeSHIP 6823 4L ESCAPE SLIDE ARMED CONDITION INDICATOR INOP (KNUCKLE KNOCKER). ADJUSTED DOOR 4L LOWER LINING TO CORRECT POSITION, OPS SATIFACTORY PER B757AMM 52-11. (1049765)SDR DALA2025070104951Latch · wrong partSHIP 6706 AUDIT FINDING UNNAPROVED PART INSTALLED R2 UPPER FWD LATCH ASSY. R/R R2 DOOR UPPER FWD LATCH ASSY REF. B757 AMM 52-11. MD LOG C/W (1049980)SDR DALA2025070104944Panel · dentedSHIP 6711 DENTS (2EAS) ON LEADING EDEGE PANEL BTW STAB STA.128 TO 176 AT LH HORIZONTAL STABILIZER. LEADING EDEGE PANEL BTW STAB STA.128 TO 176 AT LH HORIZONTAL STABILIZER WAS REPAIRED PER ER/A NO. 627211 -14 REV. ORIGINAL SECTION I: PERMANENT REPAIR. (105002SDR DALA2025070104896Seat Track · corrodedCORROSION SEAT TRACK @ FR74 TO 2 INCHES AFT OF FR74, LBL43 . WL 151.5. REMOVED AND REPLACED SEAT TRACK ON LBL 43, WL 151.5 BETWEEN FR 61 TO FR 74 IAW A220 ASRP BD500-A-J51-42-21-00AAA-078A-A + DWG. C01342701 REV.G BOMBARDIER. (LP# 1049756)SDR DALA2025070104882Web · corroded(LOG 1050329) CORROSION ON WEB FLOOR SUPPORT STA 986 TO 992 AND 34 TO 35 LBL, AT W2. WEB FLOOR SUPPORT STA 986 TO 992 AND 34 TO 35 LBL, AT W2 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070104881Floorbeam · corroded(LOG 1049586) CORROSION ON Z ANGLE FLOOR SUPPORTS (2 EAS) BTW STA 992 LBL 43 AND RBL 43 AT PAX CABIN. Z ANGLE FLOOR SUPPORTS (2 EAS) BTW STA 992 LBL 43 AND RBL 43 AT PAX CABIN WERE REPLACED AND INSTALLED PER B 737-800 SRM 51-40-02-0G.SDR CALA2025070106120Lens · wrong partPER ESC NEED TO CHECK THE INSTALLED EMERG EXIT SIGNS IN CABIN FOR CORRECT EFFECTIVITY. OVERHEAD CEILING AFT ECONOMY CLASS (JUST BEFORE GALLEY) HAD NON-COMPLIANT GREEN RUNNING MAN, LENS REMOVED AND REPLACED WITH P/N F1000600-1 RED "EXIT" SIGNAGE REF AMM 33-51SDR CALA2025070106107Floorbeam · damagedSTA 947/LBL 4'-11' STA 947/RBL 5' ELONGATED HOLES AND CORROSION. ACCOMPLISHED REPAIR AT STA 947.50 FROM LBL 4 - LBL 11 IAW EC/RA 5370-01181, B737/800 SRM 53-00-51-2R-1.SDR SIMA20250627002Pitot Line · malfunctionedGOT YELLOW ALT FLAG AT FL280. AT FL280 CA ALTIMETER SHOWED 28260, FO ALTIMETER SHOWED 28000, STANDBY SHOWED 28080. SUSPECTED INTEGRATED PITOT/STATIC/AOA SENSOR 1 AT FAULT. RAR INTEGRATED PITOT/STATIC/AOA SENSOR IAW AMM 34-13-01, OPC GOODSDR DALA2025063004872Indicator · inoperativeSHIP 3115 F/O OXYGEN MASK PUSH TO TEST, YELLOW INDICATOR NOT SHOWING. CORRECTIVE ACTION: RESEATED MASK ON THE FO SIDE. PERFOMRED AN OPS PER A319 AMM 35-12. (7172562).SDR DALA2025063004867Door Frame · crackedSHIP 3135 CRACK INDICATION ON FR 20 AT FWD GALLEY AREA, DOUBLE JOGGLE AREA , HOLE 6, RH SIDE, CRACK POSITION AT 10 OCLOCK. CORRECTIVE ACTION: COMPLIED WITH ER/A 626357-14AD. (1049480).SDR ASAA2025062759097Bracket · looseFA REPORTS GIRT BAR HOLDER BRACKET AT BOTTOM OF R1 DOOR IS LOOSE. GROUNDED - YES. GIRT BAR HOLDER BRACKET AT THE BOTTOM OF R1 DOOR IS SECURED AND TIGHT AS REQUIRED. NO OTHER DEFECTS NOTED.SDR HALA20250630036Hydraulic Line · leakingDECLARED EMERGENCY. LEAKING FIN # 5238GA HOSE HYDRAULIC LINE TO LEFT HAND LANDING GEAR DOOR UPLOCK. REMOVED AND REPLACED HYD LINE 5238G IAW IPC 32-31-03-27B SERVICED HYD SYSTEM GREEN IAW AMM 12-12-29 BLEED BRAKES IAW 29-00-00.SDR HALA20250630202Elec Connector · damagedETOPS - ENG #1 EEC CONNECTOR J9 PIN DAMAGED. REMOVED AND REPLACED ENG #1 J9 CONNECTOR PER AMM 70-71-20. ENG RUN OPS CHECK PENDING. ACCOMPLISHED #1 ENG IDLE RUN PER AMM 71-00-00-860-810-A. ALL CHECKS GOOD NO FAULTS NOTEDSDR QXEA2025063000268Door · no discrepancyL1 DOOR (MAIN PASSENGER DOOR) DIFFICULT TO OPEN. REMOVED FROM SERVICE. OPENED AND CLOSED L1 DOOR SEVERAL TIMES. DOOR OPERATES SMOOTHLY. NO DEFECTS NOTED. COULD NOT DUPLICATE. NO PARTS REPLACED. RETURNED TO SERVICE.SDR AALA202506304348Processor · inaccurateAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506304331Float Switch · inaccurateAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506307238Compensator · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506306150Probe · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506302917Probe · fault messageAIRCRAFT WAS GROUNDED: ON TAKEOFF, WITH 2200LBS IN CENTER TANK, WE NOTICED THE CENTER FUEL QUANTITY RAPIDLY DECREASING AS WE PASSED BY 7,000FT, CENTER TANK RAPIDLY FELL TO 0.0 LBS INDICATED. WE RECEIVED A FMS MESSAGE 'VERIFY GROSS WEIGHT AND FUEL' - WITH NO WASDR AALA202506302410Engine · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: EGT OVER TEMP ON THE NUMBER 2 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. ACCOMPLISHED AMM 71-00-00-800-804-F00 AND CONTACTED ENGINE DESK FOUND NUMBER 2 ENGINE EXCEEDANCE IN AREA "B" NO EEC FASDR SWAA2025063086339Shimmy Dampener · vibrationAT ROTATION AIRCRAFT YAWED TO THE LEFT WITH A VIBRATION FELT; AFTER ABEING AIRBORNE NO FLIGHT CONTROL DISCREPANCIES NOTICED; NO ABNORMAL ENGINE PERAMETERS NOTED; RETURNED TO AIRFIELD NORMAL SMOOTH LANDING WITH NO ABNORMAL VIBRATIONS FELT NO OVERWEIGHT LANDING SDR SWAA2025063085795Handle · unsecureINSIDE ASSIST HANDLE NEXT TO AFT SERVICE DOOR NOT SECURE.<[01] SECURED IAW SIP.SDR SWAA2025063086111Floor Panel · crackedFWD CARGO BIN HAS FWD CRACK ON FLOOR<[01] PREFORMED REPAIR OF FWD CARGO AFT FLOOR PANEL (120CF) PER SRM 53-00-53-1A-1 TO BE REINSPECTED EVERY 400 CYCLE MUST REPLACE AT 4;000 CYCLESSDR SWAA2025063086358Flashlight · inoperativeEMERGENCY FLASHLIGHT AT AFT F/A STATION INOP.<[01] REMOVED AND REPLACED FA AFT INBD EMERGENCY FLASHLIGHT ASSEMBLY PER AMM 25-64-00. OPS CHECK GOOD AT THIS TIME.SDR SWAA2025063086125Flashlight · inoperativeFWD FLIGHT ATT. FLASHLIGHT INOP<[01] 01 - REMOVED AND REPLACED PER [AMM 25-64-00-200-801-MAX-01 (FLASHLIGHT CHECK (WITH FLASHING OR PUSH TO TEST - LED INDICATOR) - PERMANENT)]SDR SWAA2025063085963Girt Bar · out of adjustFORWARD ENTRY DOOR GRIT BAR DIFFICULT TO INSERT INTO STOWAGE HOOKS<[01] ADJUSTED FWD ENTRY DOOR GIRT BAR PER AMM 25-66-01SDR SWAA2025063085757Light · malfunctionedWINDOWS LIGHTS CAPTAIN SIDE ROW 27-30 WILL NOT GO DIM WITHIN PLACED TO NIGHT/SLE WINDOWS LIGHTS CAPTAIN SIDE ROW 27-30 WILL NOT GO DIM WITHIN PLACED TO NIGHT/SLEEP MODE 21-JUN-2025 08:02 UTC PERFORMED MX DATA LOAD PHASE II AND CHECKED WINDOWS LIGHT LED NITE/SLSDR SWAA2025063085929Light · inoperativePASSENGER CABIN RIGHT EMERGENCY EXIT LIGHT INOP<[01] R&R CABIN EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-01;[02] INSPECTION C/W R&R CABIN EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-01SDR SWAA2025063085959Lens · missingAFT GALLEY EMERGENCY EXIT LIGHT LENS COVER MISING.<[01] INSTALLED AFT GALLEY EMERGENCY EXIT LIGHT LENS COVER REF. SIP.SDR SWAA2025063085961Floor Panel · crackedAFT CARGO BAY LINERS LOCATED AT FS 787; 767 AND 747 CRACKED<[01] PERFORMED PERMANENT REPAIR ALT 3 PER AMM 50-10-01 OF LISTED CARGO BAY LINERS IN FAULT DESCRIPTION.SDR SWI2025F00769Light · looseFLIGHT ATTENDANT REPORTS MECHANICAL BURNING SMELL FROM INSIDE AND/OR NEAR FIRST CLASS COAT CLOSET. 1ST OFFICER SAYS HE COULD SMELL IT WHILE STANDING NEAR THE CLOSET AND THAT IT SMELLS LIKE BURNING RUBBER. FOUND WIRES WITH DAMAGED OUTER COATING IN THE CLOSET.SDR SWIA202506300027Retainer · bentMCD LOWER SEAL RETAINER BENT NEAR AFT RADIUS. (FILED CLOSED)REMOVED AND REPLACED MCD LOWER CENTER AND LOWER AFT SEAL RETAINERS WITH REFERENCE TO REO 601R-51-11-915, REV. -- DATED 1/04/2006 AND SRM 51-42-06. COMPLETED 51-900-1003-SKY AND M-337. REFERENCE CP 303SDR AALA202506309533Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHTING ROW 18 INOP. (OPEN)SDR AALA202506309126Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FOUND R2 DOOR ASSIST BOTTLE LOW AT 1100 PSI, 80*F. MAINTENANCE SERVICED R2 DOOR ASSIST BOTTLE WITH NITROGEN IAW AMM 52-10-00.SDR YENA2025063000666Servo Control · failedFLT#1177, BOS-LAS. (DIVERSON TO DEN) "HYD Y REVR LO LEVEL; REMOVED AND REPLACED SERVO CONTROL SPOLIER ACTUATOR (31CE3) IAW AMM 27-64-12. LEAKS AND OPS CHECK OK. A/C OK FOR SVC"SDR AALA202506308645Pump · malfunctionedAIRCRAFT WAS GROUNDED: LEFT MAIN AFT FUEL PUMP WILL NOT SHUT OFF. (OPEN).SDR AALA202506305216Handle · excess playAIRCRAFT WAS NOT GROUNDED: EXTERNAL EMERGENCY EXIT RELEASE HANDLE FOR NUMBER 2 COCKPIT WINDOW HAS EXCESSIVE PLAY AND DOES NOT SIT FLUSH TO FUSELAGE SKIN. REMOVE AND REPLACE EXTERNAL EMERGENCY EXIT RELEASE HANDLE FOR NUMBER 2 COCKPIT WINDOW, PER AMM 56-12-11.