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 JJBA20260126071Attach Fitting · crackedLEFT AILERON, PCA ATTACHMENT FITTING CRACKED. LH AILERON PCA ATTACHMENT FITTING REMOVED. AFTER INVESTIGATION, COMPOSITE STRUCTURE UNDER PCA ATTACHMENT FITTING FOUND DISCONDED AROUND 2 HOLES. LH AILERON ASSEMBLY REPLACEDSDR U2RA2026012600030Battery · inoperativeDURING A-CHECK AT RKSI, WHILE ACCOMPLISHING T/C 33-050-01-01, FOUND 11 EACH EMERGENCY LIGHT INOPERATIVE. BATTERY ASSY P/N: 2013-1A WAS REPLACED AND DOCUMENTED ON SHARP TECHNICS K W.O. MNT004216 / NR-0013. OPERATIONAL CHECK SATISFACTORY.SDR Z3EY202601250001Rotor · damagedDURING ENGINE SHOP VISIT LPT DISASSEMBLY (STAGE 7 ROTOR REMOVAL), THE LPT STAGE 7 AIR SEAL WAS FOUND PARTIALLY LIBERATED.SDR QXEA2026012300015Fuel Tank · leakingFUEL LEAK FORWARD OF LT LANDING GEAR BY HYDRAULIC TUNNEL. REMOVED FROM SERVICE. INSPECTED, FOUND FUEL SEEP LOCATED AT LT MLG WELL, AFT LT SIDE OF FOWARD BULKHEAD, LOWER SIDE COMING FROM SEEM OF SEALANT. REPAIRED THE FUEL LEAK AT AFT SPAR RIB NR 1 LOWER CORNESDR DALA2026012300531Battery Pack · inoperativeVALANCE MOUNTED EMERGENCY AISLE LIGHT ABOVE ROW 30ABC INOPERATIE. R & R EMERGENCY LIGHT BATTERY PACK AND POWER SUPPLY IAW AMM 33-51. OPS CHECKED NORMAL.SDR DALA2026012300525Light · inoperativeEXTERIOR EMERGENCY LIGHTS SYSTEMS. R & R AFT RT LED ASSEMBLY PER AMP 33-55. OPS CK GOOD MEL + PLACARD INSTALLED. (LP# 7904243)SDR DALA2026012300520Power Supply · faultedDURING OPS TEST OF THE EMERGENCY LIGHTS FAULT EPSU UNIT 11WL (REFER TO AMDS CARD 5210-7089-LF (RII)). REMOVED EMERGENCY POWER SUPPLY UNIT EPSU (11WL) UNSERVICEABLE CONDITION IAW AMM 33-51-38-000-001-A AND AS PER A320 FAM AMM33-51-38-400-001- A. TESTED GOOD.SDR SWAA2026012262812Lubrication Unit · faultedNR 1 IDG ON MEL. APU AUTO SHUTDOWN IN FLIGHT. REMOVED AND REPLACED LUBE MODULE IAW AMM 49-91-11.SDR DALA2026012200501Warning Message · no indicationDURING FUNCTIONAL CHECK, RT AFT OVR WING EXIT DOOR FAILED TO DISPLAY ALERT MESSAGE. REPAIRED PER B717 WDM 52-71-00. (1408940)SDR AALA202601226166Bottle · low pressureAIRCRAFT WAS GROUNDED: PASSENGER / CREW DOOR 842 DAMPER AND EMERGENCY OPERATION CYLINDER NEEDS TO BE SERVICED TO LIMITS. MAINTENANCE SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-001-A.SDR AALA202601222331Bottle · low pressureAIRCRAFT WAS GROUNDED: PASSENGER / CREW DOOR 841 DAMPER AND EMERGENCY OPERATION CYLINDER NEEDS TO BE SERVICED TO LIMITS. MAINTENANCE SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-001-A.SDR AALA202601223379Bottle · low pressureAIRCRAFT WAS GROUNDED: LEFT HAND EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER NEEDS TO BE SERVICED TO LIMITS. MAINTENANCE SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00-614-002-A.SDR G1IA2026012219103Downlock Switch · failedLANDING GEAR NOSE WHEEL DOWN LIGHT EXTINGUISHED ON SHORT FINAL IN KENAI. WENT MISSED, CYCLED THE GEAR TWICE, GOT THE LIGHT BACK, WHICH THEN EXTINGUISHED ON SHORT FINAL AGAIN. THEN DECLARED AN EMERGENCY, PERFORMED THE ALTERNATE GEAR EXTENSION CHECKLIST VIA QRH,SDR DALA2026012200480Beam · corrodedAFT FUSELAGE FLOOR STRUCTURE AT FR 66+160 MM AT Y765 MM, LONGITUDINAL BEAM CORRODED. REPLACED LONGITUDINAL BEAM IAW SRM 51-72-11-911-001, REV 155, DWG D53472780, ISSUE H, & DWG D53472815, ISSUE E. (LP: 1409456)SDR CALA2026012213148Skin · crackedEA-5720-02922-001 LEFT WING IB LE SKIN HAS 3 FASTENER HOLES WITH CRACK INDICATIONS, HOLE NO. 12, 13, AND 19. ACCOMPLISHED L/E SKIN REPAIR IAW ECRA 5740-03437 AND AAR ENGINEERING DOC REO-25768.SDR DALA2026012100472Bustle · out of adjustAT DEPARTURE, R2 DOOR WILL NOT ARM. REMOVED SLIDE COVER STRAIGHTENED OUT BUSSEL, INSTALLED COVER. ARMING CHECKED GOOD. (8561622)SDR DALA2026012100469Indicator · faultedL2 KNUCKLE KNOCKER DID NOT EXTEND, ESCAPE SLIDE ARMED CONDITION INDICATORS. ADJUSTED 2L DOOR KNUCKLE KNOCKER, OPS CKS NORM WITH DOOR ARMED. DIS-ARMED DOOR. (1409982)SDR DALA2026012100468Indicator · faultedL1 DOOR KNUCKLE KNOCKER DID NOT EXTEND, ESCAPE SLIDE ARMED CONDITION INDICATORS. ADJUSTED THE KNUCKLE KNOCKER, OPS CKS NORM WITH DOOR ARMED. DIS-ARMED DOOR. (1409980)SDR SWAA2026012162844Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M2335 INOPERATIVE. REPLACED THE BATTERY PACK M2335 IAW AMM 33-51-06-960-805. OPS CHECKED GOOD IAW AMM 33-51-06-960-805.SDR DALA2026012100466Bottle · low pressureCHECK R2 DOOR PRESSURE. SERVICED THE DOOR ASSIST BOTTLE IAW AMM 52-15. OK FOR SERVICE. (8562123)SDR DALA2026012100465Light · detachedEMERGENCY LIGHT BROKEN OFF. SECURED LOOSE HARDWARE AT SEAT 36AB IAW AMM 33-51. OPS CHECKED GOOD. (8562125)SDR DALA2026012100464Bottle · low pressureFLT CREW REPORTED R4 DOOR PRESSURE LOW MESSAGE ON FAP. SERVICED DOOR ASSIST BOTTLE IAW AMM 52-15. OK FOR SERVICE. (8390264)SDR AALA202601219260Circuit Breaker · trippedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: STAB TRIM CIRCUIT BREAKER FOUND POPPED ON CLIMB OUT. AIRCRAFT EMERGENCY LANDED SAFELY AT LAX. CHECKED PER FIM 27-41-00-810-805 RESET AFCS STAB TRIM CIRCUIT BREAKER, PER AMM 27-41-00. PERFORMED STAB TRIMSDR AALA202601215188Sliding Window · lack of lubeAIRCRAFT WAS NOT GROUNDED: CAPTAINS NUMBER 2 WINDOW DOES NOT OPEN PROPERLY. APPLIED LUBRICANT ON WINDOW TRACKS. OPS CHECKED NORMAL. PER AMM 56-12-11.SDR AALA202601218351Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LATCH IS HARD TO OPERATE. LATCH WAS STUCK. LUBRICATED LATCH MECHANISM. OPS CHECK GOOD.SDR AALA202601210099Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN. FAULT CONFIRMED LAVATORY DOOR FRAME LOOSE HARDWARE. RESECURED HARDWARE AND LUBRICATED FRAME TRACK. PER AMM 25-40-14. OPS CHECK GOOD.SDR AALA202601214231Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR HARD TO LOCK AND UNLOCK. ADJUSTED AFT LEFT LAVATORY DOOR LOCK.SDR AALA202601210249Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: AFT CENTER AISLE OVERHEAD EMERGENCY SIGN DISLODGE. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY. PER AMM 33-51-01.SDR DALA2026012100454Fire Bottle · faultedDIVERTED TO SLC DUE TO CARGO BTL FAIL MESSAGE. PERFORMED RESISTANCE CHECKS OF WIRING FROM THE FIDEX TO THE CARGO BOTTLE AND PRESSURE SWITCH, FOUND RESISTANCE FLUCTUATING IN BOTTLE PRESSURE SWITCH WHEN TAPPING ON THE BOTTLE PRESSURE SWITCH, REPLACED LOW-RATE DSDR AALA202601215515Flap System · lockedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED ON APPROACH INTO MIA DUE TO THE FLIGHT CREW REPORTING FLAPS LOCKED ALIGNMENT FAULT WITH THE FLAPS AT 2. THE AIRCRAFT LANDED SAFELY AT MIA AND TAXIED TO THE GATE UNDER ITS OWN POWER. MAINTENANCE REPLACED THE LEFSDR AALA202601214024Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: ON TAKEOFF, PRIOR TO GEAR RETRACTION, NOSE WHEEL HAD EXCESSIVE VIBRATION. MAINTENANCE FOUND EXCESSIVE PLAY ON THE NOSE LANDING GEAR AFT DOOR FORWARD HINGE FITTING AND REPLACED IT PER CMM 52-82-32. A SATISFACTORY OPERATIONAL CHECK WAS ACCSDR AALA202601210796Lever · looseAIRCRAFT WAS NOT GROUNDED: L2 DOOR ARMED LEVER LOOSE. MAINTENANCE RESECURED 2L DOOR SLIDE ARMED LEVER AND ACCOMPLISHED A SATIOSFACTORY OPERATIONAL CHECK PER AMM 52-13-22.SDR AALA202601215415Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601213760Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR HARD TO OPEN. MAINTENANCE LUBED THE FLIGHT DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-11.SDR AALA202601219083Strap · unsecureAIRCRAFT WAS NOT GROUNDED: CATERING REPORTS A STRAP HANGING FROM THE BOTTOM OF REAR DOOR 4L. MAINTENANCE RESECURED SLIDE STRAP.SDR AALA202601215407Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE 4R DOOR IS HARD TO ARM/DISARM. MAINTENANCE LUBED THE ARMING MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM52-13-00.SDR AALA202601212773Battery · no testAIRCRAFT WAS NOT GROUNDED: MEGAPHONE INOPERATIVE. MAINTENANCE REPLACED BATTERIES IN THE MEGAPHONE AND ACCOMPLISHED A SATISFACTORY OPERTIONAL CHECK PER AMM 25-00-00.SDR AALA202601210995Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: WHEN UNLOCKING FLIGHT DECK DOOR FROM FLIGHT DECK AND TURNING THE HANDLE COUNTERCLOCKWISE THE BOLT DOESN'T RETRACT ENOUGH TO OPEN DOOR. IT WORKS NORMALLY WHEN TURNED CLOCKWISE. MAINTENANCE PERFORMED FLIGHT DECK DOOR LATCH MECHANISM ADSDR OEJA202601210001Cabin Pressure · faultedTHE AIRCRAFT WAS PERFORMING A MAINTENANCE FLIGHT AFTER HEAVY CHECHK AND DOEING CLIMB OUT THE CABIN ALTITUED BEGAN TO RAPIDLY CLIMB AND THE CREW RECIEVED A AMBER CASS MESAGE WARNING , CREW DECLARED A EMERGANCY AND RETURNED TO BASESDR DALA2026012100446Latch · brokenL1 DOOR SLIDE COVER LATCH IS BROKEN RT SIDE. LATCH COVERED WITH TAPE PERR ER/A 631834-14. (8449850)SDR DALA2026012100440Skin · crackedHFEC INSPECTION CARRIED OUT ON THE LT FUSELAGE SKIN ,SECTION 48, FOUND TWO CRACKS IN STRINGER 13, BS 1654 - 1678, THE LENGTH OF CRACK IS 0.19 IN AND 0.15 INCH, THE FUSELAGE SKIN CRACK AREA WAS REPAIRED AS PER B767-400 SRM 53-80-01 (1408646)SDR DXTA2026012106601Transducer · faultedREPEAT WRITE UP. AFTER LOWERING MLG, AMBER AUTOBRAKE FAIL CASS MESSAGE ILLUMINATED ACCOMPANIED BY CYAN BRAKE FAULT CASS MESSAGE. MAINT FAULT CODE 3246015HA DISPLAYED IN FMS OF MAINT PAGE. COULD NOT DUPLICATE. NO FAULT MESSAGES ON POWER UP. RAN ENGS & HYD POWESDR DXTA2026012106599Relay · faultedEMERGENCY LIGHT SYS FAILED PREFLIGHT CHK. WITH SWITCH IN ARM, NO LIGHTS ILLUMINATED. EMERG LIGHT SWITCH ON, CABIN DOOR LIGHTS FAILED, AS LIGHT OVER GALLEY WORK AREA FAILED. WHILE MOVING EMERG LIGHT SWITCH, LIGHTS OCCASIONALLY FLICKER VERY BRIEFLY THEN GO OUSDR DXTA2026012106597Door · frozenMAIN DOOR HAVING ISSUES TO OPEN & CLOSE. WILL NOT LATCH COMPLETLY. GREEN FLAG NOT SHOWING. CAS MESS DOOR OPEN. OPENED DOOR, NO DEFECTS. POWERED ACFT & CLOSED DOOR. DOOR CLOSED NORMAL, & DOOR INDICATED CLOSED ON STATUS PAGE. INSPD ALL GREEN DOOR LOCK INDICATORSDR CALA2026012013115Unknown · odorSMOKE ODOR ON ROW 6ABC ONCE ALL ELECT.DEVICES WERE DISCONNECTED IT WENT AWAY. ROW 6ABC NOT APLICABLE FOR THIS AIRCRAFT CONFIGURATION. AS A PRECAUTION, CONNECTED ELECTRICAL DEVICES FOR 20 MINUTES IN ROW 5AB, AND ROW 8ABC OUTLETS TO LOCATE THE DISCREPANCY. NO ODSDR CALA2026012013114Unknown · odorPERSISTANT EXHAUST ODOR FROM TAXI TO CRUISE ONLY IN COCKPIT, GONE AFTER 25 MINUTES IN FLT. RAN APU, NR 1 ENGINE AND NR 2 ENGINE, ALL SEPARATELY FOR 15 MINUTES. COULD NOT DETECT ANY ODOR, IAW FIM 21-00-01/300, COULD NOT FIND ANY EVIDENCE OF LEAKS.SDR WX0A2026012032706Unknown · odor(AIRCRAFT NOT GROUNDED) FROM APPROX 15000 FT TO 1000 FT DIRTY SOCK SMELL IN CABIN ON DESCENT. FLIGHT DECK FO NOTICED SMELL 4,000 TO 1,000 FT. COMPLIED WITH TC A32X-21-000-200. COMPLY WITH TASK CARD 21-000-003 WITHIN 10 CALENDAR DAYS. CW LVL 3 REF TC.SDR WX0A2026012032703Gauge · inoperative(AIRCRAFT NOT GROUNDED) COVER TO R2 SLIDE PACK GAUGE IS INOP / RESECURED COVER ON R2 SLIDEPACK REF AMM 25-62-44-400-803-A"SDR ASAA2026011962923Door · no discrepancyMAIN CABIN DOOR HARD TO OPEN IAW FA. GROUNDED - YES. MAIN CABIN DOOR OPS CHKD OK, NO DEFECTS NOTED, ACFT OK FOR SVC.SDR DALA2026012000437Wire · brokenDIVERTED TO RDU DUE TO ELECTRICAL ODOR IN COCKPIT. DONNED O2 MASKS & DECLARED AN EMERGENCY. FOUND CAPTAIN'S GRIMES LIGHT WITH A BROKEN WIRE. REPLACED GRIMES LIGHT & CABIN RECIRCULATION FILTERS. OPS CHECKED GOOD.