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 SCNA20250731292Oven · dirtyAFT OVENS NEED CLEANING.CREATE SMOKE WHEN USED SET OFF FIRE ALARM. REPLACED AFT OVENS INSERTS REF AMM 25-31-02SDR SCNA20250731291Carpet · unsecureWEATHER STRIP IN AFT GALLEY IN FRONT OF THE LAV IS LIFTING AND BECOMING A TRIPPING HAZARDTAPED DOWN CARPET TRANSITION REF AMM 25-27-15. A/C OK FOR SVCSDR AALA202508019046Sensor · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO CLT DUE TO THE FLIGHT CREW REPORTING THAT THE FLIGHT DECK AIR TEMP ROSE OVER 100 DEGREES F WITH WARM AIR BLOWING FROM VENT. THE AIRCRAFT LANDED SAFELY AT CLT WITHOUT INCIDENT. MAINTESDR AALA202508014332Sensor · defectiveAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO CLT DUE TO THE FLIGHT CREW REPORTING THAT THE FLIGHT DECK AIR TEMP ROSE OVER 100 DEGREES F WITH WARM AIR BLOWING FROM VENT. THE AIRCRAFT LANDED SAFELY AT CLT WITHOUT INCIDENT. MAINTESDR AALA202508012781Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR CALA2025080107209Control Servo · leakingHYD Y ENG 2 PUMP LOW PRESSURE. REF GMM 04-20-16, PTU INOPERATIVE, CARGO DOOR INOPERATIVE, Y ELECT PUMP INOPERATIVE, Y ENG 2 PUMP INOPERATIVE, INSTALLLED NR 4. SPOILER SERVO CONTROL IAW AMM 27-64-52-400-003-A. OPS & LEAK CHK GOOD. OK TO RETURN TO SERVICE.SDR CALA2025080107208Floorbeam · corrodedAFT WET AREA. EXFOLIATION CORROSION AT SEVERAL SPOTS ON FLOOR BEAM UPPER SURFACE BS 986.5 RBL7 TROUGHT RBL47. REMOVED AND REPLACED EXISTING REPAIR T - CHORD AT STA 986.5 RBL 8 TO RBL 50 REF SRM 53-70-51-2R-4 AND SRM 51-40-02-0G-0.SDR CALA2025080107207Rib · crackedRIGHT HORZONTAL STAB LEADING EDGE RIB NR 5 CRACKED. REMOVED AND REPLACED RIB NR 5 AT RT HORIZONTAL STAB LEADING EDGE IAW SRM 51-40-02-0G AND DWG 186A1305.SDR CALA2025080107206Hmu · faultedOBSERVER ON GND REPORTED STREAM FROM LT WING. FUEL -3. 5 LT SIDE ON LDG. AT ARRIVAL FOUND ENGINE ONE FUEL LEAK OUT OF LIMITS ON THE VSV DRAIN. SUSPECTED HYDRO MECHANICAL UNIT ISSUE, REMOVAL & INSTALLATION CARRIED OUT IAW AMM TASK 73-21-14-000-805-G02, TASK 73SDR CALA2025080107205Battery Pack · expiredRECORDER INDEPENDENT POWER SUPPLY BATTERY (RIPS) INSPECTION. RIPS BATTERY MFG DATE WAS 052019. BATTERY IS BEYOND 5 YEAR SERVICE LIMIT AND MUST BE REPLACED. REMOVED AND REPLACED THE RIPS BATTERY UNIT IAW AMM TASK 23-71-22. OPS TEST WAS GOOD.SDR CALA2025080107204Fuel Cap · missingDURING WALK AROUND FOUND FUEL CAP MISSING. INSTALLED NEW FUEL CAP IAW AMM TASK 28-25-41-400-005-A.SDR CALA2025080107198Life Vest · misinstalledCLEANERS NOTED MULTIPLE LIFE VESTS PACKED AND SEALED WITHOUT STRAP ACCESSIBLE AT SEATS 8B 11A 21A 27F 30E OPENED, CHECKED AND RESEALED LIFE VEST COMPTS WITH STRAPS ROUTED OUT OF BOX REF AMM 25-64-04-211-801.SDR CALA2025080107196Chiller · misinstalledFUMES IN CABIN. GALLEY SUSPECTED ORIGIN. FLIGHT CREW ACCOMPLISHED SMOKE/ODOUR COND INSPECTION IAW AMM 05-51-58-800-801-CE UP TO 2AF INCLUDE FULL POWER RUNS. ALL OPS AND INDICATIONS NORMAL, WITH NO SMOKE OR ODOUR NOTED. AS PRECAUTION ALL FORWARD AND CENTER OVSDR CALA2025073107182Filter · unknownCARRY OUT GVI OF UPPER RECIRCULATION FAN AND ITS AIR FILTER FOR ANY SIGNS OF DAMAGE OR UNUSUAL SMELL. GVI OF UPPER RECIRCULATION FAN CARRIED OUT WHILE FAN IS OPERATING. NO ELECTRICAL OR UNUSUAL SMELLS NOTED. RECIRCULATION FAN OPERATES SATISFACTORY. FWD UPPER SDR CALA2025073107181Unknown · odorAFTER ENG START, SELECTED PACKS ON HAD STRONG FUME ODORS IN BACK OF CABIN, REPORTED BY THE AFT CABIN AREA FLIGHT ATTENDANTS THAT WAS A FUEL ODOR AFTER ENG START FOR ABOUT 5 MINS UNTIL IT CLEAR OUT OF CABIN. REPORTED ONLY HAVING THIS ISSUE OUT OF LHR. VERIFISDR CALA2025073107179Lamp · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK, LEFT OVERWING EXIT AFT EMERGENCY LIGHT INOP. RELAMPED LEFT OVERWING EXIT AFT EMERGENCY LIGHT IAW AMM 33-51-04-960-801. OPS NORMAL. OK TO CONTINUE.SDR CALA2025073107178Charger · inoperativeCABIN EMERGENCY LIGHTS WILL NOT TURN ON IN FIRST CLASS CHECKED EMERGENCY LIGHTING BATTERY M1676 M1675 AND M1674, AND M2503. FOUND M2503 BROKEN. REPLACED BATTERY AND CHARGER. NO HELP. ALSO REPLACED M1676 BATTERY AND CHARGER. NO HELP. REFERENCE: 33-51-21-106, FSDR CALA2025073107176Tire · delaminatedNUMBER 2 TIRE TREAD DETACHED DURING TAKEOFF ROLL OUT OF ORD. ALL MISSING TREAD WAS FOUND ON ORD RUNWAY.SDR AALA202507311094Pin · out of adjustAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY EXIT UPPER HATCH PIN ON THE FLIGHT DECK DOOR IS STUCK OUT. IT WILL NOT SLIDE BACK IN. READJUSTED AND LUBRICATED LATCH. PER AMM 52-51-08. OPERATIONAL CHECK GOOD.SDR JJBA20250731129Doubler · corrodedCF4, EXTERNAL POTABLE WATER DRAIN DOUBLER BTW FR 57-58 AND STR 19R-20R FOUND CORRODED. CF4 EXTERNAL POTABLE WATER DRAIN DOUBLER BTW FR 57-58 AND STR 19R-20R REMOVED FOR ACCESS, CORROSION BLENDED WITHIN LIMIT. AFTER INVESTIGATION, INTERNAL SKIN BTW FR 57-59 ANSDR JJBA20250731128Skin · damagedSCREWS HOLES ELONGATED ON BOTH STARKE SPLICE SKIN. STARKE SPLICE SKIN (2X) FABRICATED.SDR SWAA2025073197051Tire · deflatedSEVERE AIRCRAFT VIBRATION UPON LANDING ON RUNWAY 30. UPON INSPECTION BY EMERG. VEHICLE TRUCKS THEY DISCOVERED THE NR 3 TIRE WAS DEFLATED. TEMP OF NR 3 TIRE WAS SLIGHTLY ELEVATED BUT SAFE. AIRCRAFT WAS EVENTUALLY TOWED TO THE GATE BY RAMP AGENTS. REMOVED ANSDR GTIA2025073139027Epsu · inoperativeDURING BITE CHECK OF EPSU'SFOR THE SERVICE CHECK, 11WL BATTERY FAILED. R & R 11WL EPSU BATTERY IAW AMM 33-51-38, OPS TEST GOODSDR IXXA20250731002Skin · corroded2 SMALL AREAS OF CORROSION ON LEFT WING UPPER SURFACE AT 444.50.SDR IXXA20250731001Skin · corrodedCORROSION ON LEFT WING SURFACE LEADING EDGE UPPER SKIN.SDR DALA2025073105752Stringer · mechanic errorNEED TO RE-WORK VIASAT, S-4R FWD OF FR62 / EXTRA FASTENER HOLE. REPAIRED PER ERA 627490-14. (1116739)SDR DALA2025073105749Tiller · faultedNWS STILL STICKY NO TILLER ACTION LESS THAN 10 DEGREES, BEYOND 10 DEGREES TILLER JERKS , F/O TILLER WORKS APPROPRIATELY. R & R CAPT`S N.W HANDWHEEL STEERING UNIT IAW AMM 32-51,OPS CK NORMAL, OK FOR SVC.SDR QR9R2025073100001Actuator · no testAP1/YAW TRIM FAILED ON AP TEST DURING START RUN-UP. A TEST FLIGHT EVAL REVEALED AP1 AND TRIM APPEAR ON CAD, "Y" APPEARS ON PFDS, AND "YAWTRI PFTINH" APPEARS ON VEMD SYSTEM STATUS PAGE AFTER AUTO PILOT TEST FAILS. REMOVED AND REPLACED YAW TRIM ACTUATOR; TEST FLSDR 2025FA0000532Windshield · fracturedLANCAIR IV-P, WHILE IN PRESSURIZED CRUISE FLIGHT AT 15,500' MSL AND 245KTS, A LARGE PORTION OF THE WINDSHIELD FRACTURED AND SEPARATED FROM THE AIRCRAFT. AN IMMEDIATE DEPRESSURIZATION OCCURRED, RESULTING IN AN EMERGENCY LANDING. VISUAL INSPECTION REVEALED NO SDR FDEA202507311346Transmission · faultedTE FLAP DISAGREE CAUTION. COMPLIED WITH QRH. WITH FLAPS SELECTED TO 25, FLAPS WOULD NOT MOVE PAST 20. ALTN FLAPS SELECTOR USED TO SET FLAPS TO 25. EMERGENCY DECLARED. AMM: 27-51-06-4 WORKED IN CONJUNCTION WITH TSI 27-50-2326, REMOVED AND REPLACED #5 FLAP TSDR FDEA202507311345Fitting · not reportedDETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR ACTUATOR BEARING FITTINGS AT FRAME 23 & 24. COMPLIED WITH EO 6-5230-E0378588 B P5. REPLACED THE MAIN DECK CARGO DOOR ACTUATOR BEARING FITTINGS AT FRAME 23 AND 24. THIS IS CATEGORY B REPAIR. FOLLOW UP INSSDR FDEA202507311344Skin · crackedFUSELAGE EXTERIOR SKIN APPROXIMATE X= 18.955 LEFT HAND STATION 475, FORWARD OF NOSE LANDING GEAR FORWARD DOOR FOUND CRACKED. CRACKED SKIN AT FUSELAGE EXTERIOR APPROXIMATE X= 18.955 LEFT HAND STATION 475 FORWARD OF NOSE LANDING GEAR FORWARD DOOR REPAIRED ASSDR BJNA202507310001Light · inoperativeDURING SURVICE CHECK FOUND RH OVERWING FWD EMERGENCY LIGHT OUT. R & R RH OVERWING FWD EMERGENCY LIGHT IAW 33-51-04-960-801. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR SCNA20250731289Switch · crew errorFORWARD LAV. EMERGENCY LIGHT INOP. THE NO SMOKE/FASTEN SEAT BELT LIGHT SWITCH WAS IN THE OFF POS. FWD LAV. PER AMM 33-25-00SDR SCNA20250731288Retainer · out of adjustL1 GIRT BAR VERY LOOSE. ADJUSTED GIRT BAR RETENTION CLIPS AT L-1 POS. PER AMM 25-66-00SDR CALA2025073107115Battery Pack · dischargedEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. RT AFT LWR EXTERIOR EMEGENCY LIGHT INOP. REPLACED M1670 BATTERY PACK POWER SUPPLY REF AMM 33-51-06. OPS CHECK GOOD AT THIS TIME.SDR SWIA2025073075193Stand Off · crackedLEFT UPPER TRANSCOWL INBD -A- BRACKET STAND OFF CRACKED. REMOVED CRACKED STAND OFF FROM LT UPPER TRANSCOWL AND INSTALLED ONE NEW STAND OFF ON LT UPPER TRANSCOWL IAW GREO 670-54-21-971, REV B, STEPS 1-3. COMPLIED WITH SKY CARD 51-900-1002-SKY.SDR SWIA2025073075184Stand Off · crackedLEFT LOWER TRANSCOWL INBD -A- BRACKET STAND OFF IS CRACKED. STAND OFF REPAIRED IAW REO 670-54-21-971, REV B. COMPLIED WIT 51-900-1002-SKY.SDR SWI2025F01810Skin · dentedFUSELAGE SKIN HAS PROTRUDING DENTS AT FS 299 BETWEEN STRS 20R AND 21R. REPAIRED FUSELAGE SKIN FS299 STGR 20R-21R IAW REO# 670-53-21-2667 REV - AND SRM 51-23-00-001-001-A01 REV 38SDR SWIA202512090730Intercostal · corrodedPAX DOOR AFT DD5 INTERCOSTAL FOUND TO BE CORRODED, REQUIRES REPLACEMENT. REPLACED THE PAX DOOR AFT DD5 INTERCOSTAL IAW SRM 51-42-06-001-001-A01, AND 51-40-11-01-001-001-A01, REV 38.SDR JJBA20251111058Access Panel · corrodedLH WING FUEL ACCESS PANELS AND CLAMP RINGS: 541EB, 541AB, 531BB, 531DB, 531AB, 541CB, 541DB, 551AB, 541BB, 531CB, 155BZ, AND 155CZ HAVE CORROSION AND FRETTING DAMAGE (PITTING). BLENDED OUT CORROSION AND PITTING FOUND ON FUEL ACCESS PANEL FLANGES. PANELS 541EBSDR SWIA2025110400730Track · brokenLEFT ENGINE TRANS COWL TRACK LOWER NYLON INSERT SCREW BROKEN AND HAVE GOUGE AND HOLE ELONGATED. REPAIRED HOLES FOR NYLON ATTACH SCREWS ON LH ENGINE LOWER TRANSCOWL IAW SRM 54-21-00 AND REO 670-78-30-921 REV-B DATE 2014-07-02.SDR SWIA2025110300730Floor Support · crackedLH FLOOR SUPPORT ANGLE AT LBL12.00 BETWEEN FS 260.00 - 280.00 HAS CRACK #30576663 (C-CHECK RO 11/01/2025)REMOVED AND REPLACED LH FLOOR SUPPORT ANGLE AT LBL 12.0 , BETWEEN FS 260- FS 280 WITH NEW PN CC670-33199-3 AND LH FLOOR GUSSET AT LBL 12.0 , FS 280 WISDR SWIA2025102000730Skin · chafedL/H WING, LOWER WING PLANK HAS CHAFE DAMAGE FROM CONTACT WITH FLAP FAIRING 586AB. (C-CHECK RO 10/19/2025)REPAIRED LH WING LOWER PLANK CHAFE DAMAGE FROM CONTACT WIT FLAP FARIING 586AB IAW REO 601R-57-21-3961 REV--, DATED 2025-08-06 COMPLETED TASK CARD 51-900-SDR VNAA20251016005Plate · corrodedCORROSION ON PYLON LOWER PLATE AT STA FS=1108 AT LH PYLON. CORROSION ON PYLON LOWER PLATE AT STA FS=1108 AT LH PYLON WAS EVALUATED EXCESIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ 900 SRM-51-42-13-001-001-A01SDR AALA202510084915Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK CENTER WINDSHIELD FRAMING LEFT HAND CONTINUITY FITTING CRACKED BETWEEN FR 1 AND FR 2 AT Y0. REPLACED CONTINUITY FITTING PER EA 366931.SDR SWIA2025100700030Floor Support · corrodedCOCKPIT FLOORBOARD 221ALF FORWARD SUPPORT ANGLE HAS CORROSION. (C-CHECK RO 10/06/2025) REMOVED AND REPLACED THE FORWARD SUPPORT INTERCOSTAL ANGLE (P/N 600-33110-667) AT COCKPIT FLOORBOARD 221ALF REF REO 601R-53-11-4012 REV--, DATED 2025-08-22, REO 601R-53-11-SDR AALA202509265046Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE, CRACK INDICATION FOUND ON WINDSHIELD FRAME LOWER ATTACHMENT AREA INTERNAL SIDE. LOCATED ON LOWER RADIUS LH SIDE IN COCKPIT. CRACK LENGTH=0.400 INCH. MAINTENANCE PERFORMED TIME LIMIT REPAIR, REPAIR ON CENTER POST LT AND RT SIDE SDR SWIA2025F01370Hinge Fitting · gougedLH HORIZONTAL STAB OUTBOARD HINGE FITTING GOUGED ON LOWER SIDE (MARKED RED) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGE TO SMOOTH CONTOUR AT PLATE MOUNTED ON L/H HORIZONTAL STAB. O/B HINGE FITTING. REF. CRJ200 SRM 51-12-00. COMPLIED WITH STEPS 1-5 OF REO 601R-5SDR SWIA2025F01369Mount · dentedAFT CARGO DOOR FWD TRACK MOUNTING STRUCTURE HAS DENTS IN THE I/B ANGLE. (MARKED) (S/N#00567) (C-CHECK RO 09/24/2025)REMOVED AND REPLACED NEW ANGLE AT AFT CARGO DOOR FWD TRACK MOUNTING STRUCTURE REF CRJ200 SRM 51-42-06-00 AND DWG# 601R35050 REV-AC M-337 AND SK