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 HALA20250623190Eec · faultedETOPS - DURING HIGH POWER RUN OF #1 ENG, " ENG 1 HOT AIR LEAK" MESSAGE. EEC BITE SHOWED "EEC INTERNAL FAIL NO GO" AND MULTIPLE PAGES OF FAULTS. REMOVED AND REPLACED #1 EEC PER AMM 73-21-01-400-801-A. IDLE RUN OK. CAT III TEST ACCOMPLISHED ON T/C 321-22-HWI-03.SDR AALA202506233780Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME FASTENER HOLE C AT FR 16 LEFT AND DOOR STOP #5. REPLACED FRAME PER EA 364015.SDR AALA202506231653Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME FASTENER HOLES AT FR 16 RIGHT AND DOOR STOP #5. REPLACED FRAME PER EA 363979.SDR AALA202506239776Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME FASTENER HOLE 6 AT FR 16 LEFT AND DOOR STOP #5. REPLACED UPPER CORNER DOUBLER PER EA 364015.SDR AALA202506232064Doubler · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOT REPAIR BEING ACCOMPLISHED ON FR 16 RIGHT AND DOOR STOP #5 THE UPPER CORNER DOUBLER AT FR 16 RIGHT NEEDS TO BE REPLACED AS OUTLINED IN THE INSTRUCTIONS ON EA 363979. REPLACED UPPER CORNER DOUBLER PER EA 363979.SDR AALA202506231743Cover Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON EXTERNAL SKIN PASSENGER CREW DOOR 841 UPPER COVER PLATE CORNER FORWARD POSITION RIGHT HAND SIDE. REPLACED EXTERNAL SKIN PASSENGER CREW DOOR 841 UPPER COVER PLATE CORNER FORWARD POSITION RRIGHT HAND SIDE PER SRM 51-42-11-8SDR ABXA2025621133Start Valve · defectiveDURING PUSHBACK, #2 ENGINE RIGHT ENGINE STARTER VALVE INOP. AIRCRAFT RETURNED TO BLOCKS. (BTB) . DEFERRED IAW MEL C ABX-80-00-2-1. REPLACED RH ENGINE START VALVE IAW AMM 80-11-02 / 401. DI 63480 REMAINS OPEN DUE OPS CHECK PENDING. RH ENG START VALVE OPS SDR DALA2025062304684Line · faultedSHIP 5816 -PRES- DUE TO CABIN ALT WARNING. CORRECTIVE ACTION: REPLACED LEFT PACK CONDENSER AND SUPPLY LINE. REPLACED AFT CARGO DOOR SEAL AND CABIN PRESSURE CONTROLLERS 1 AND 2 AND COCKPIT CONTROL PANEL.SDR IPXA2025062341000Retainer · brokenFOUND L1 ENTRY DOOR RETAINER BROKEN LOCATION AT FORWARD LOWER SIDE TOTAL: 1EA OKAY TO WORKSDR IPXA2025062352983Cable · out of adjustL ENTRY DOOR WILL NOT CLOSE. ADJUSTED CABLES ON FORWARD AND AFT CABLES OF L1 DOOR IN REF TO MD11 MM 52-11-02-830-801 SUBTASK 52-11-02-830-005. L1 DOOR OPS NORMAL.SDR IPXA2025062146821Duct · blownATB, IN CLIMB CABIN PRESS UNCONTROLLABLE. CABIN EXCEEDED 10,000 AT 13,000 MSL. RETURNED TO KSDF. R & R CPC-1 REF. AMM 21-31-04 FUNCTIONAL TEST & RTS TEST PASSED, NO FAULTS NOTED. R & R ACC-2 REF. AMM 21-62-01 RTS TEST PASSED. DURING OPS TEST, SENSOR READOUT OFSDR IPXA2025062143276Lamp · burned outOPERATIONAL TEST OF THE EMERGENCY POWER-SUPPLY UNITS WITH BITE-CHECK FAILED FOUND MULTIPLE BULBS BEHIND EXIT SIGN LENS INOP. RELAMPED ASSY REF AMM 33-51-13/401, OPS CHECK OF LAMPS & BITE CHECK GOOD AT THIS TIME.SDR UIEA2025062300794Module · unsecureL1 FLIGHT ATTENDANT, EMERGENCY O2 MODULE ASSY NOT SECURED. RESECURED O2 MODULE AT L1 ATTENDANT SEAT REF AMM 35-21-12/201. OPS CHECK GOOD.SDR AALA202506234844Power Supply · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 12WL FAILED SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202506239210Power Supply · no testAIRCRAFT WAS GROUNDED: FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 10WL DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202506230275Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 10WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DALA2025062304675Light · inoperativeSHIP 3403 EMERGENCY ESCAPE PATH WHITE LIGHTS OUT AT 44B AND 54H. CORRECTIVE ACTION: R/R LIGHT ASSYS PER A330 AMM 33-51. OK FOR SERVICE. (7437958)SDR DALA2025062304673Sign · detachedSHIP 5807 EMERGENCY EXIT SIGN FELL OFF IN MID A/C. CORRECTIVE ACTION: RESECURED EMERGENCY EXIT LENSE COVER. (7026496)SDR DALA2025062304672Sign · detachedSHIP 699 OVERHEAD EXIT SIGN TURNED INTO CREW BY PAX. CORRECTIVE ACTION: REATTACH EXIT SIGN AS REQUIRED. (7474760)SDR FDEA202506211023Hydraulic Line · crossedPITCH ENHANCEMENT SYSTEM CHECK (PTU) FAILS. STAB DOES NOT MOVE WITH LEFT AND CENTER HYDRAULICS SHUT DOWN. POWER TRANSFER UNIT CURRENTLY INSTALLED ON A/C 196: MPN 518735 SN MX814569. WHEN A/C PRE-DOCKS WERE ACCOMPLISHED WIC 2902100-00-01 FAILED. FOUND HYDRAUSDR FDEA202506211022Floor Panel · brokenAFT CABIN FLOOR PANEL 251 MWF IS BROKEN AND MISSING CORRECT INSERT. FABRICATED MAIN CABIN FLOOR PANEL 251 MWF ON VTMAE TRAVELER T25/1818647 PER DWG 11864182, MAJOR REPAIR.SDR FDEA202506211021Floor Panel · damagedMAIN CABIN FLOOR PANEL 252 MWF IS BROKEN AND HAS ALL WRONG INSERTS NOT FLUSH WITH THE PANEL ARE INSTALLED ALL THE WAY THROUGH THE PANEL, NEEDS THE VERY SHALLOW INSERTS PER THE BUILD PRINT FOR THE PANEL. DOT 4-139. FABRICATED MAIN CABIN FLOOR PANEL 252 MWF SDR FDEA202506211020Floorboard · damagedMAIN CABIN FLOORBOARD 251MVF IS BROKEN. FABRICATED MAIN CABIN FLOORBOARD 251MVF ON VTMAE TRAVELER T25/1818699 PER DWG 11864182, MAJOR REPAIR.SDR FDEA202506211019Slide · low pressureSERVICE CHECK FOUND PRESSURE OF SLIDE/RAFT OF L1 DOOR IN RED BAND. REMOVED AND REPLACED L1 DOOR ESCAPE SLIDE PACK REF B777 AMM 25-66-01-4. REVERSED MEL 52-11-01-2 10- MAN LIFE RAFT REMOVED AND ROUTED TO MEM STORES.SDR SCNA20250623224Flap System · faultedFLAPS DID NOT DEPLOY POST 10 . RAN QRH 9.34 USED ALTERATE FLAP SWITCH TO LAND WITH FLAPS 15 (DECLARED EMERGECNY) ACCOMPLISHED FSEU BITE IAW FIM 27-51 TASK 801 WITH NO FAULTS FOUND. CARRIED OUT FLAP OPS TEST IAW AMM 27-51-00-710-801 WITH NO DEFECTS FOUND. SDR SCNA20250623222Wire · brokenDEFECT 796449: FOUND SEVERAL EMER LIGHTS INOP WHILE PERFORMING TASK CARD 330100000 - -RESOLUTION: REPAIRED BROKEN WIRE AND REINSERTED WIRE INTO GROUND BLOCK GD08006. R&R BATTERY PACK AND CHARGER ASSY AT ROW 22 AND ROW 7 REF AMM 33-51-06 AND SWPM 20-90-15. OPS SDR CALA2025062305819Door Sill · corrodedFWD CARGO ENTRY DOOR SILL HAS CORROSION. REMOVED AND REPLACED FWD CARGO ENTRY DOOR SILL IAW A320SRM 51-72-11. R & R FWD CARGO ENTRY DOOR SILL IAW SRM 51-72-11 CAT A.SDR CALA2025062305804Battery Pack · dischargedEMERGENCY EXIT SIGNS AT BOTH AFT EMERGENCY EXIT HATCHES INOP. REPLACED BATTERY PACK ON POWER SUPPLY M1695 IAW AMM 33-51-06. OPS CHECK GOOD.SDR CALA2025062305799Filter · cloggedF/A S RPRTED FUMES AND BURNING ODOR RGHT AFTR T/O ALSO HEAT FRM FLR PER FLIGHT CREW, FLIGHT ATTENDANTS REPORT SMELL OF BURNING ODOR FROM DOOR 1 TO DOOR 3 TWO MINUTES AFTER TAKEOFF, NO SMOKE NOTED. FLIGHT CREW THEN TURNED BOTH REC FANS AND IFE OFF, BURNING ODORSDR CALA2025062305797Unknown · odorACRID SMELL IN PILOT CREW REST. SMOKE DETECTOR WENT OFF. PERFORMED SMOKE/ODOR IN THE FLIGHT DECK/CABIN CONDITIONAL INSPECTION IAW AMM 05-51-58-800-801-C3 REV. 104. / NIL FINDINGS. NO SOURCE OF SMOKE/ODOR OR FIRE DETECTED.SDR CALA2025062305792Engine · no discrepancyRIGHT ENG OVERHEAT REF LP 5281291. INTERROGATED #2 ENG EXCEEDANCE PAGE, FOUND EGT OVERTEMPERATURE CONDITION TO BE WITHIN LIMITS REF AMM TASK 72-00-00-290-828-N02. NO MX ACTION IS NECESSARY IN REGARD TO TRANSIENT OVER TEMPERATURE OCCURANCE. REF LP 5281291. PERFSDR AALA202506235494Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AROUND AFT LAVATORY VENT BETWEEN BS 907 AND BS 927, BETWEEN S21L AND S22L. ACCOMPLISHED DOUBLER REPAIR PER EA 365723.SDR DALA2025062204661Skin · ground damageAIRCRAFT 3092, WHILE ON THE LINE IN DCA, MAINTENANCE REPORTS A/C 3230 WING TIP FENCE MADE CONTACT WITH A/C 3092 ON THE NOSE RADOME (P/N: D53132210000) AND RH NOSE FWD FUSELAGE, SKIN PANELS (P/N: D5311007520100 & D5313320020000). THE RH FUSELAGE SKIN PANELS HAVSDR F3LA202506210258Floor Support · corrodedREFERENCE LTPR NR 5001406003-0010 AIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION FOUND CABIN FLOOR SUPPORT Y-254 AT FR 12-24 CORRODED. REQUIRED REPLACEMENT AS PER SRM 51-72-11 REV 44. CABIN FLOOR SUPPORT Y-254 AT FR66-70 REPLACSDR SWI2025F01925Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 1-2 900 RT - COMPLY WITH TASK CARD 27-630-809 RH TRACK ROLLER SEALED, TRACK 1-2, TOP FORWARD - SLAT 1, REMOVED AND REPLACED RT SLAT TRACK 1-2 UPPER FORWARD SLAT ROLLER IAW AMM 27-81-43-400-801-A01. OPSSDR SWI2025F01924Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 1-2 900 LH - COMPLY WITH TASK CARD 27-530-809 LH TRACK ROLLER SEALED, TRACK 1-2, TOP FORWARD - SLAT 1. REMOVED AND REPLACED THE LH SLAT TRACK 2-1 UPPER FORWARD SEALED ROLLER REF AMM 27-81-43-400-801-A0SDR SWI2025F01923Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 3-2 900 RT - RT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-630-816. REMOVED AND REPLACED LIFE LIMITED RT SIDE ROLLER ASSY'S ON SDR SWI2025F01922Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 3-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-530-816. REMOVED AND REPLACED LT SLAT TRACK 3-2 FORWARD AND AFT, ISDR SWI2025F01921Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 2-2 900 RT - RT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-630-815. REMOVED ANSDR SWI2025F01920Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 2-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WSDR SWI2025F01919Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 1-2 900 RT - RT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-620-804. REMOVED ANDSDR SWI2025F01918Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 1-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-520-804. REMOVED ANDSDR SWI2025F01917Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 2-2 900 RH - COMPLY WITH TASK CARD 27-630-809 RT TRACK ROLLER SEALED, TRACK 2-2, TOP FORWARD - SLAT 2. COMPLIED WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 2-2 900 RH - COMPLIED WITH TASK CARD 2SDR SWI2025F01916Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 2-2 900 LH - COMPLY WITH TASK CARD 27-530-809 LT TRACK ROLLER SEALED, TRACK 2-2, TOP FORWARD - SLAT 2. REMOVED AND REPLACED THE LT SLAT TRACK 2-2 UPPER FORWARD TRACK ROLLER IAW AMM 27-81-43-400-801-A01.SDR SWI2025F01915Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 1-3 900 RH - COMPLY WITH TASK CARD 27-630-809 RH TRACK ROLLER SEALED, TRACK 1-3, TOP FORWARD - SLAT 1 (PN CC670-12272-1). (MRB 27-81-43-718), PART NUMBER: - , SERIAL NUMBER: 15108, POSITION: (C-CHECSDR SWI2025F01914Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: TRACK ROLLER SLAT 1-3 900 LT - COMPLY WITH TASK CARD 27-530-809 LH TRACK ROLLER SEALED, TRACK 1-3, TOP FORWARD - SLAT 1 (PN CC670-12272-1). (MRB 27-81-43-718), PART NUMBER: - , SERIAL NUMBER: 15108, POSITION: REMOVED SDR SWIA202512260620Lintel · wornCOMPLY WITH: 670BA-53-040 - FUSELAGE - CENTER FUSELAGE, PRIMARY STRUCTURE FS280.00 TO FS295.00 - INSPECTION AND REINFORCEMENT OF LINTEL STRINGER 3 OF THE MAIN PASSENGER DOOR REV C PART(S) B COMPLIED WITH: 670BA-53-040 REV-C, DATED 09-20-2012 - FUSELAGE - CESDR SWI2025F01710Stringer · corrodedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA32427-STS EA 30-2016-179 897SK-DTI - S26L HAS CORROSION BTW BS 954 - 969. REPAIRED IAW EA 30-2016-179, REV -, PERFORM NDT LFEC & HFEC PER NDTM PART 1, 51-20-006, EA 30-2016-179, REV A, SEC II DTIR, REPLACED THE STRISDR SWIA202512020620Door Frame · scratchedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA74194-690-53-31-609, SMALL SCRATCH IN BETWEEN FORWARD AND CENTER CARGO DOOR. COMPLIED WITH TEMPORARY REPAIR IAW REO 690-53-31-609. PERM REPAIR DUE AT OR BEFORE 5900 FH FROM INCORPORATION OF REO AT REV --. REPAIRED FRSDR 3EJA300HQ062025Pump · failedWHILE ADDING TAKE OFF POWER WE RECEIVED A MASTER CAUTION WITH R ENG OIL PRESSURE LOW.REMOVED AND REPLACED ENGINE OIL PUMP