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 SWAA2025110324116Access Panel · damagedELONGATED HOLE ON ANGLE LOCATED ACCESS PANEL 651GB RT WING. REPLACED SUPPORT ANGLE LOCATED ON T/E ACCESS PANEL IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02.SDR REXA2025102900969Lamp · inoperative#8 EXTERIOR EMERGENCY LIGHT INOP R/R #8 EXTERIOR EMERGENCY LIGHT LAMP IAW AMM 33-51-15. OPS CHECK GOODSDR SWAA2025102724064Handle · looseASSIST HANDLE ON L2 DOOR LINER LOOSE. SECURED L2 DOOR ASSIST HANDLE IAW AMM 52-13-31.SDR SWAA2025102724068Handle · looseASSIST HANDLE LOOSE FWD. SIDE OF R2 DOOR. SECURED THE R2 DOOR ASSIST HANDLE IAW AMM 52-41-31.SDR SWAA2025102724065Handle · looseR1 DOOR ASSIST HANDLE LOOSE. SECURED THE R1 DOOR ASSIST HANDLE IAW AMM 52-41-31.SDR SWAA2025102724060Filler · brokenGPD LOWER LATCH LANDING HAS FILLER BROKEN OUT. THE DAMAGE WAS REPAIRED PER SRM 53-10-15-2R-4 REPAIR 4 AND EA 25-153-02815.SDR AALA202510246074Coupling · wornAIRCRAFT IN BASE MAINTENANCE: UPPER OUTBOARD SPLICE COUPLING HAS ELONGATED / WORN HOLE AT FR 66 AND S23L. REPLACED SPLICE COUPLING PER SRM 51-42-11.SDR AALA202510247471Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING AT FR 66 AND S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202510236114Skin · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO UPPER FUSELAGE CROWN SKIN AT BS 847, S1. ACCOMPLISHED REPAIR PER SRM 53-00-01-2R-35 AND EA 368897.SDR SWAA2025102124073Skin · delaminatedRT OB AFT FLAP IB END UPPER SURFACE HAS SPOT DELAMINATED. REMOVED AND REPLACED R/H OUTBD AFT FLAP IAW AMM 27-51-22-400-801 - AMM 27-51-22-400-801 -ADJUSTMENT AND OPS CK GOOD.SDR CALA2025102110365Detector · faultedCABIN PRESSURE CABIN DOOR WARNING LIGHTS FRONT/AFT FLASHING ECAM PRESS ZERO. COULD NOT DUPLICATE FAULT, TESTS PASSED, REMOVED AND REPLACED CABIN-PRESSURE DETECTION PRESSURE-SWITCH (FIN 14WN) PER AMM 52-73-12, OPS CHECK GOOD, DOOR FLASHES AND THEN TURNS SDR AALA202510204726Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD AT BS 957, RBL 20. REPLACED SHIELD PER AARD 51-00-05-1.SDR ASAA2025101361578Plate · missingEXIT SIGN LOCATED IN THE CENTER AISLE MID CABIN IS MISSING THE BACKING PLATE. GROUNDED - YES. INSTALLED MISSING BACKING ON EXIT SIGN LOCATED IN THE CENTER AISLE MID CABIN REF IPC 33-51-01-88B THIS CLEARS INT.SDR DALA2025101707594Skin · damagedFASTENERS (45 EA) ON VERTICAL STAB LEADING EDGE PREVIOUS REPAIR STA ZFS =52. CORRECTIVE ACTION: VERTICAL STAB LEADING EDGE REPAIR STA ZFS =52 WERE REMOVE AND INSTALL PER CARD 5530-01048-02 AND DVI WAS PERFORMED ON RH/LH VERTICAL STAB LEADING EDGE STRUCTURE SPLSDR CALA2025101710221Bracket · crackedINSIDE LEFT WING PANEL 551DB, INBD AFT AREA, FOUND ONE BRACKET BENT AND PULLED THROUGH RIVET CAUSING DAMAGE. REMOVED AND INSTALLED FABRICATED BRACKET UNDER LT WING PANEL 551DB, AT INBD AFT AREA IAW SRM 51-40-02-0G-0, DWG 287A9152 REV AA, SRM 51-20-01-0G-0, ASDR CALA2025101710220Throttle · obstructedLARGE SPLIT ON THROTTLE TO TRY TO OBTAIN TO THRUST. ENGINE UNAB LE TO MAKE TAKEOFF POWER PERFORMED TEST 13 (TAKE OFF POWER TEST) IAW MM-71-00-00-715-223 ON NR 2. ALL TEST PASSED. PERFORMED TEST 9 (THRUST LEVER /POWER ANGLE TEST) IAW MM-71-00-00-715-170. TEST SDR CALA2025101309949Oven · smokeAFT GALLEY OVEN 709 HAD WHITE SMOKE OUT OF THE TOP VENTS..TURNED OFF SMOKE REPORT FORM COMPLETED AND SENT TO TOMC.TOMC APPROVAL REQUIRED TO DEFER OVEN 709. TOMC APPROVES NEF 2520AV OVEN 709 DEFERRED PER NEF 2520AV, M-PROCEDURE PERFORMED, PLACARD INSTALLED.SDR SWAA2025101623912Flashlight · not seatedFWD FA FLASHLIGHT OUTBOARD POS WILL TEST. FOUND FLASHLIGHT NOT SEATED PROPERLY. RESEATED FA FLASHLIGHT REF AMM 25-64-00; CHECKED GOOD.SDR GTIA2025101639133Flashlight · inoperativeR4 FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT IAW NKS DRAWING A320 EMER EQUIP. THIS CLEARS DMI, MOC NOTIFIED PLACARD REMOVEDSDR GTIA2025101639132Hinge Fitting · corrodedWEAR ON BUSHINGS OF ELEVATOR RH HINGE FITTING # 6 (2EA), INNER DIAMETER OF INBOARD LUG BORE WAS FOUND OUT OF STANDARD LIMITS RAF-01 3336905-01. REPLACED BUSHINGS (2EA) ON HINGE #6 AT LH ELEVATOR I.A.W. AIRBUS CMM 55-21-15, AIRBUS NTM 51-90-00 AND PMS 01-05-58SDR GTIA2025101639131Bushing · wornWEAR ON BUSHINGS OF ELEVATOR RH HINGE FITTING NUMBER 1 2EA INNER DIAMETER OF INBOARD LUG BORE WAS FOUND OUT OF STANDARD LIMITS RAF-01 3336905-02 GENERATED -REPAIRED O/B LUG AND REPLACED BUSHINGS (2EA) ON HINGE FITTING #6 AT LH ELEVATOR O/B LUG IAW A320 NEO SRMSDR AALA202510165892Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED AISLE EMERGENCY LIGHT DOES NOT ILLUMINATE AT SEAT 8C. MAINTENANCE FOUND BROKEN WIRE IN SEAT HARNESS CABLE AND REPAIRED IT PER ESPM 20-43-11. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202510161995Bottle · leakingAIRCRAFT WAS GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PSI AT 0. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202510167061Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR 4L HAS CHECK DOOR PRESSURE INDICATION ON FLIGHT ATTENDANT PANEL. MAINTENANCE SERVICED 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AMM 52-13-00.SDR AALA202510162262Deu · faultedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE FLIGHT ATTENDANT PANEL DISPLAYS MESSAGES FOR THE 3L AND 3R DOOR PRESSURE TO BE CHECKED. MAINTENANCE FOUND DEU B TO BE FAULTY AND REPLACED IT PER AMM 23-73-47. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHESDR AALA202510163866Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510167085Oven · odorAIRCRAFT WAS NOT GROUNDED: #1 OVEN HAS A STRONG ELECTRICAL SMELL WHEN ON. REPLACED OVEN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-35-19.SDR AALA202510164660Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WOULD NOT OPEN INFLIGHT USING THE D-RING HANDLE. HAD TO USE ALTERNATE OPERATION WITH TOGGLE SWITCH. CENTER STRIKE NOT CLEARING THE PLATE. MAINTENANCE ADJUSTED LATCH MECHANISM PER AMM 52-51-21.SDR DXTA2025101605302Switch · brokenAT 3000 FT, 10 MILES FROM TEB, AN AMBER R REV UNLOCKED APPEARED. WE RAN THE QRH, LIGHT DID NOT EXTINGUISH. AS PER THE QRH, WE SHUT DOWN THE RIGHT ENGINE AND DIVERTED TO EWR. CORRECTIVE ACTION: REMOVED THE DEFECTIVE RH T/R STOW MICRO SWITCH ANO INSTALLED A NEW SDR CALA2025101610187Adr · faultedNAV ADR 1 FAULT LAND VERIFY REQUIRED CYCLED RELATED BREAKERS, RERACKED ADIRU 1 AND PERFORMED BITE TEST OF ADIRU AND IRU TWICE REF AMM 34-13-00-740 AND AMM 34-14-00-740-004 TEST PASSED ON BOTH ATTEMPTS AND TESTED ADIRU 2 AND 3 ALL TESTS PASSED VIEW PICTURES TAKSDR CALA2025101610171Fuel Cap · missingFUEL CAP MISSING. REPLACED FUEL CAP. SECURE FOR FLIGHT.SDR CALA2025101610162Elec Connector · looseEMERGENCY LIGHT OUT AT SEAT 21CBA EMERGENCY LIGHT OUT AT SEAT 21CBA. ALL OTHER LIGHTS FUNCTION CORRECTLY. APPLY MEL 3350B. 3350B APPROVED APPLIED MEL 3350B FOUND EMERGENCY LIGHT AT 21 CBA CONNECTOR LOOSE. RECONNECTED AND SECURED CONNECTOR IAW AMM 20-50-00. OPSSDR DXTA2025101605298Unknown · odorCOCKPIT ODOR. HOLDING SHORT OF THE RUNWAY BOTH PILOTS SMELLED A STRANGE POTENT SMELL. THE SMELL WAS STRONGER FROM THE RIGHT SIDE OF THE COCKPIT AND SMELLED LIKE PLASTIC WAS BURNING. THERE WAS NO SIGN OF SMOKE. PERFORMED FIM 21-20-00-810-801-A TO CHECK FOR ANSDR I5PA2025101375702Ecu · faultyAPU PNEUMATICS INOPERATIVE. R & R APU ECU PER AMM. OPS CHECKED NORMAL.SDR I5PA2025101375701Shutoff Valve · faultyFLT: MGE831, APU FUEL VAL EICAS. R & R APU FUEL SHUTOFF VALVE IAW AMM, OPS CHECK NORMAL.SDR I5PA2025101268801Ecu · faultyFLT: MGE820, APU FAULT, QRH PERFORMED AND RESTART OK. R & R APU ECU IAW AMM, OPS CHECK NORMAL. NO FAULTS ON ECU.SDR SWAA2025101524076Stringer · crackedDURING CONDITIONAL INSPECTION OF THE NR 1 ENGINE LT FAN COWL, FOUND A SECOND 3 INCH CRACK ON NR 4 AFT FAN COWL STRINGER. LEFT FAN COWL DEBUR SHARP EDGES ON CRACK AND LIGHTLY BLEND DOWN ON NR 4 AFT SUBJECT COWL STRINGER IAW EA 25-154-02794. REF TO FAULT# TTGSDR SWAA2025101524028Battery · no testFWD GALLEY EMERGENCY FLASHLIGHT NOT TESTING PROPERLY. R & R THE FWD GALLEY EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025101524223Flashlight · no testAFT GALLEY FO SIDE FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED F/O SIDE FLASHLIGHT IAW MM 25-64-00. OPS CHECKED NORMAL. OK FOR SERVICE.SDR SWAA2025101524296Retainer · out of adjustAIRCRAFT LEFT AFT GIRT BAR IS DIFFICULT TO REMOVE FROM DOOR CRADLE. W/O 107221. ADJUSTED GIRT BAR RETAINING CLIP IAW AMM 25-66-01. OK FOR SERVICE.SDR SWAA2025101524300O-Ring · leakingHYDRAULIC SYSTEM A WENT DOWN TO 58 % IN FLIGHT. LOST 10 % DURING THE LEG. RETURNED TO NORMAL INDICATIONS AFTER LANDING. NOTED FLUID DRIPPING OUT OF HELL HOLE DRAINS AND AREA THICK WITH VAPOR. REPLACED O-RING FROM LEAKING UNION AT ELEVATOR FEEL COMPUTER ASSDR SWAA2025101524283Sign · brokenF/A REPORTED FWD ENTRY EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED THE FWD ENTRY DOOR EXIT ASSY SIGN IAW AMM 33-51-01-960.SDR SWAA2025101524282Cover · brokenFIRST OFFICER`S SIDE OVERWING EXIT LOWER SIGN BROKEN OFF. REMOVED AND REPLACED EXIT ROW LOWER EXIT SIGN RT COVER IAW AMM 33-51-01.SDR SWAA2025101524093Lens · missingEMERGENCY EXIT CEILING LIGHT LENSE ROW 5 MISSING. REPLACED LENSE IAW AMM 33-51-00.SDR SWAA2025101524591Cowling · pulled#2 INLET LOWER SKIN HAS PULLED FASTENERS #2 INLET LOWER SKIN HAS PULLED FASTENERS.<[01] REMOVED AND REPLACED #2 ENGINE NOSE COWL PER AMM 71-11-01SDR WX0A2025101332600Epsu · no test(AIRCRAFT NOT GROUNDED) FAILED OPERATIONAL TEST / REMOVED AND REPLACED EPSU REF WO527812"SDR ASAA2025101361575Battery Pack · inoperativeEMERGENCY LIGHTS FAILED OPS CHECK. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PPACK M267 IAW B737-900 AMM 33-31-06-960-805 OP CHECKS GOOD IAW B737-900 AMM 33-51-00-710-801.SDR FDEA202510132006Power Supply · inoperativeDURING MX PREFLIGHT: COURIOR AREA EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY BATTERY IAW AMM 33-51-14-04. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR FDEA202510131996Power Supply · inoperativeDURING MX PREFLIGHT: COURIOR AREA EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY BATTERY IAW AMM 33-51-14-04. OPS CHECKED GOOD. ACFT OK FOR SERVICE.SDR DALA2025101507525Intake · contaminatedFA'S REPORTED DIRTY SOCK/MUSTY SMELL ODOR THROUGHOUT CABIN FROM TOP OF DESCENT TO TOUCH DOWN. NOTHING DETECTED IN COCKPIT. FOUND INTAKE AREA CONTAMINATED WITH OIL AND EVIDENCE COMING FROM COMPRESSOR. APU TO BE REPLACED. (LP 7781906, 7781907)