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 DALA2025122909487Light · inoperativeAIRCRAFT 3506, FOUND R2 DOOR EVACUATION LIGHT INOP. REPLACED 2R DOOR EVAC AREA LIGHT ILLUMANT IAW AMM 52-12. OPS CHECK GOOD. (LP 7889867)SDR QXEA2025122900378Screw · looseFLIGHT 2195. RECIRCULATION SMOKE DETECTOR FAILED EICAS MESSAGE. RAN QRH FOR MESSAGE. REMOVED FROM SERVICE. FAULT WAS ACTIVE ON STARTUP F/C 26107300AM2. ON SUBSEQUENT RESTARTS FAULT WAS NOT ACTIVE. C/W FIM 26-16-00-810-801-A ELECTRICAL CHECKS, NDN. CONTINUEDSDR DALA2025122909485Ground Wire · unsecureAIRCRAFT 8334, FOUND ON SVC CHK R2 OVERWING EMERGENCY DOOR LIGHT INOP. PERFORMED WIRE CHK OF EMRGENCY DOOR LIGHT. FOUND GROUND WIRE NOT SECURED TO GROUND STUD. RESECURED GROUND WIRE IAW AWDP 91-33-52. OPS CHK GOOD. (LP 7699323)SDR DALA2025122909470Bottle · low pressureDOOR PRESSURE R2 DOOR LOW ON FAP. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8045714)SDR DALA2025122909466Seat Track · corrodedSEAT TRACK UPPER SURFACE FOUND CORROSION AT FR79 TO FR80, Y794.3. REPLACED SEAT TRACK PER A330 SRM 53-11-00. (1374766)SDR DALA2025122909465Door Frame · crackedFOUND 02 EA CRACKS ON THE FRAME FR61 FRAME FORK AREA, ONE CRACK ON THE FRAME FORK AREA H-1, ANOTHER CRACK ON THE FRAME FORK AREA H-2, AT BEAM 4 IN THE AFT CARGO COMPARTMENT DOOR. CORRECTIVE ACTION: FR 61 FRAME FORK REPLACEMENT AS PER CARD 5230- 01164-08 REV. MSDR DALA2025122909464Door Frame · crackedFOUND TWO CRACKS ON THE FRAME FR61A FRAME FORK AREA, ONE CRACK ON THE FRAME FORK AREA H-1, ANOTHER CRACK ON THE FRAME FORK AREA H-2, AT BEAM 4 IN THE AFT CARGO COMPARTMENT DOOR. CORRECTIVE ACTION: REPLACED FORK PER DELTA WORK CARDS 5230- 01164-08 REV MAY 09 20SDR DALA2025122909463Door Frame · crackedFOUND ONE CRACK ON THE FRAME 63 FRAME FORK AREA H-2 AT BEAM 4 ON THE AFT CARGO DOOR. FR 63 FRAME FORK REPLACEMENT AS PER CARD 5230- 01164-08 REV MAY 09 2025 AND CARD 5230-01164-10 REV AUG 08 2023. (1374581)SDR DALA2025122909462Door Frame · crackedFOUND TWO CRACKS ON THE AFT CARGO DOOR FRAME 63 - FRAME FORK AREA, ONE CRACK ON THE FRAME FORK AREA H-5, ANOTHER CRACK ON THE FRAME FORK AREA H-6. CORRECTIVE ACTION:FR 63 FRAME FORK REPLACEMENT AS PER CARD 5230- 01164-08 REV MAY 09 2025 08:50 AND CARD 5230-011SDR DALA2025122909461Door Frame · crackedFOUND TWO CRACKS ON THE AFT CARGO DOOR FRAME 61A - FRAME FORK AREA, ONE CRACK ON THE FRAME FORK AREA H-5, ANOTHER CRACK ON THE FRAME FORK AREA H-6. CORRECTIVE ACTION: FR 61A FRAME FORK REPLACEMENT AS PER CARD 5230- 01164-08 REV MAY 09 2025 08:50 AND CARD 5230-SDR DALA2025122909460Door Frame · crackedFOUND TWO CRACKS ON THE AFT CARGO DOOR FRAME 61 - FRAME FORK AREA, ONE CRACK ON THE FRAME FORK AREA H-5, ANOTHER CRACK ON THE FRAME FORK AREA H-6. CORRECTIVE ACTION: FR61 FRAME FORK REPLACEMENT AS PER CARD 5230- 01164-08 REV MAY 09 2025 AND CARD 5230-01164-10 SDR 2025F00293Tire · leakingTIRE LEAKING OUT OF THE SIDEWALL.SDR ABXA20251229362Warning Message · illuminatedDURING TAXI OUT, R DUCT LEAK LP 1 STATUS MSG. A/C RETURNED TO THE GATE (BTB) AND MTX GROUNDED A/C. MTX THEN DEFERRED LP 1 DUCT LEAK DETECTION IAW MEL 26-18-1-1-1, MX PROCEDURES C/W, MBCB 01/08/26, PLACARDS INSTALLED.AND RETURNED A/C TO SERVICESDR SCNA20251229510Control Panel · contaminatedEXCESSIVE SNOW CONTAMINATION IN AFT GALLEY BY L2 DOOR CAUSING EMER LIGHTS TO FLICKER AND PA SYS. TO BE INTERMITTENT. R & R AFT FA CONTROL PANEL REF AMM 31-15-21 OPS TEST GOOD.SDR REXA2026073101376Stringer Splice · corrodedCORROSION ON STRINGER SPLICE 21R, BTWN BS 330 TO 336 AT MAIN AVIONICS BAY. THE STRINGER SPLICE 21R BTW BS 330 TO 336 AT MAIN AVIONICS BAY WAS EVALUATED OUT LIMITS IAW SRM 53-21-03-101-006-A04 AND REPLACED IAW SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-ASDR REXA2026073101375Stringer · corrodedCORROSION ON STRINGER 24R, BTWN BS 295 TO 330 AT MAIN AVIONICS COMPARTMENT. CORROSION ON STR 24R BTW BS 295 TO 330 AT MAIN AVIONICS BAY WAS EVALUATED OUT LIMITS IAW SRM 53-21-03-101-002-A04, AND REPLACED IAW SRM 51-42-06-001-001-A01.SDR REXA2026073101368Door Sill · corrodedSILL WITH CORROSION, LOWER PART OF CARGO COMPARTMENT DOOR FRAME AFT DUE TO EXCESS OF DAMAGE LOWER SILL OF CARGO COMPARTMENT DOOR FRAME AFT, WAS REPLACED PER CRJ-900 SRM 53-61-23-201-001-A01, CRJ-900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRM 5SDR REXA2026073101367Intercostal · corrodedCORROSION ON INTERCOSTAL, STR 20RT, BS 310 - 364 IN FWD E/E BAY. THE INTERCOSTAL, WAS EVALUATED OUT OF LIMITS IAW SRM 53-21-23-101-002-A02, & REPLACED IAW SRM 51-42-21-001-001-A01.SDR REXA2026073101366Intercostal · corrodedCORROSION ON INTERCOSTAL STR 20RT, BS 310 - 364, IN THE FWD E/E BAY. CORROSION ON INTERCOSTAL (3EAS), WERE EVALUATED OUT OF LIMITS IAW SRM 53-21-23-101-002-A02, AND REPLACED IAW SRM 51-42-21-001-001-A01.SDR REXA2026073101365Intercostal · corrodedCORROSION ON INTERCOSTAL, STR 20 RT, BS 310 - 364 AT FWD E/E BAY. CORROSION ON INTERCOSTAL, STR 20RT, BS 310 - 364 AT FWD E/E BAY (3EAS), WERE EVALUATED OUT OF LIMITS IAW SRM 53-21-23-101-002-A02, AND WERE REPLACED IAW SRM 51-42-21-001-001-A01.SDR SWIA2025122876590Drag Angle · crackedRT VERTICAL STAB TO FUSELAGE AFT DRAG ANGLE SHOWS POSSIBLE CRACK. REMOVED, CRACKED RIGHT, AFT DRAG ANGLE ON THE VERTICAL STAB, AND INSTALLED SERVICABLE DRAG ANGLE. SRM 51-42-21-001-001-A01 REV 38, SRM 51-42-13-001-001-A01 REV. 38, SRM 51-42-22-001-001-A01 RESDR REXA2026052600678Shear Tie · corrodedCORROSION ON FRAME ANGLE AT INTERNAL FUSELAGE STRUCTURE FS661.00 + 90.00 AND STGR 19RH. FRAME ANGLE AT INTERNAL FUSELAGE STRUCTURE FS661.00 + 90.00 AND STGR 19RH WAS REPAIRED PER EA CRJ953-21186 REV IRSDR REXA2026030900184Stringer · corrodedCORROSION ON STGR 24RH BTW FS333.00 TO FS349.00 AT MAIN AVIONICS COMPARTMENT STGR 24RH BTW FS333.00 TO FS349.00 AT MAIN AVIONICS COMPARTMENT WAS REPAIRED Ï¿½PER CRJ900 SRM 53-00-03-201-001-A02SDR REXA2026030900174Stringer Splice · corrodedCORROSION ON STRINGER SPLICE 24RH BTW FS330.00 TO FS336.00 AT MAIN AVIONICS COMPARTMENT STRINGER SPLICE 24RH BTW FS330.00 TO FS336.00 AT MAIN AVIONICS COMPARTMENT WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 & SRM 51-42-21-001-001-A01SDR REXA2026030900159Stringer · corrodedCORROSION ON STGR 20RH BTW FS349.00 TO FS379.00 AT INTERNAL STRUCTURE OF MAIN AVIONICS COMPARTMENT CORROSION ON STGR 20RH BTW FS349.00 TO FS379.00 AT INTERNAL STRUCTURE OF MAIN AVIONICS COMPARTMENT WAS REPAIRED PER EA NO: CRJ953-20473 REV IRSDR SWAA2026012856337Access Panel · crackedCRACKED ACCESS PANEL 551GB T/E LT WING. REPAIRED THE ACCESS PANEL 551GB IAW SRM 51-70-05-2R-10, REPAIR 10.SDR SWAA2026012856042Skin Panel · crackedCRACK INDICATION FOUND ON LT HORIZONTAL STAB LOWER SKIN PANEL HSS 193.9, RIB AND 8 INCHES FROM REAR SPAR. INBD SIDE OF RIB. CRACK LENGTH: 0.600 INCH.SDR SWAA2026012756041Skin · crackedCRACK INDICATION FOUND ON THE LT HORIZONTAL STAB LOWER SKIN PANEL, HSS 193.9, RIB & 16 INCHES FROM FRONT SPAR. INBD SIDE OF RIB. CRACK LENGTH: 0.900 INCH. REPAIRED THE LT HORIZONTAL STAB LOWER SKIN IAW EA 26-155-00083, AND EA 26-155-00083-WIP1.SDR SWAA2026012756056Lens · brokenBROKEN LENS OF EMERGENCY LIGHT, STRONGHBACK ROW 24-25 RT SIDE. REPLACED THE LENS IAW AMM 33-51-03-960-803, STEP 4.D, ITEM (1) & (2).SDR AALA202601266137Sign · damagedAIRCRAFT IN BASE MAINTENANCE: GALLEY FLOOR EXIT SIGNS DAMAGED. INSTALLED NEW EXIT SIGNS. PER AMM 33-51-01 ALL CHECKED GOODSDR SWIA2026011500228Seat Track · corrodedRT LONGITUDINAL SEAT TRACK FROM FRAME 74 TO FR 84 HAS CORROSION AT FR84. REMOVED AND REPLACED THE SEAT TRACK FROM FRAME 74 TO FR 84 REF SRM 51-40-08.SDR REXA2026011500002Floorbeam · corrodedTHE RT FS 280 FLOORBEAM HAS DEEP CORROSION AND REQUIRES REPLACEMENT. REMOVED BS 280 RT FLOORBEAM IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01, INSTALLED A NEW RT BS 280 FLOORBEAM, IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-SDR SWAA2026011356284Support Bracket · crackedNR 1 ENGINE COOLING TUBE SUPPORT BRACKETS ARE CRACKED AT 03:00; 10:00; AND 09:00. REMOVED NR 1 ENGINE COOLING TUBE SUPPORT BRACKETS IAW SRM 51-40-02-0G-0. INSTALLED REPAIRED NR 1 ENGINE COOLING TUBE SUPPORT BRACKETS (LPTACC) IAW AMM 75-24-03, PARAGRAPH 3, SDR AALA202601136183Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN SEAT TRACK AT FR 16 AND +Y1292. REPLACED SEAT TRACK PER SRM 51-72-11.SDR CALA2026011212868Battery Pack · dischargedEMERGENCY LIGHT BATTERY M1695 HAS LOW VOLTAGE CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1695 AND OPS CHECK GOOD IAW AMM 33-51-06-906-805.SDR CALA2026011212867Battery Pack · inoperativeEMERGENCY LIGHT BATTERY M1670 HAS LOW VOLTAGE CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1670 AND OPS CHECK GOOD IAW AMM 33-51-06-906-805.SDR SWAA2026010956205Battery Pack · inoperativeALL EMERGENCY LIGHTS COMMON TO M1695 EMERGENCY BATTERY PACK INOPERATIVE. REMOVED THE EMERGENCY LIGHT BATTERY PACK M1695 AND INSTALLED SERVICEABLE BATTERY PACK, PERFORMED A GOOD INSTALLATION TEST IAW AMM 33-51-06-960-805.SDR DALA2026010700137Indicator · inoperativeL1 DOOR SLIDE ARMED LIGHT INOP. R/R L1 DOOR ALARM SIGNAL MODULE PER B767-300 AMM 52-73. (7909954)SDR AALA202601058180Engine · stalledAIRCRAFT WAS GROUNDED: RIGHT ENGINE COMPRESSOR SURGE OR STALL PASSING FL 190 CLIMBING MAX EGT 800 DEGREES MAX DURATION 5-6 SECONDS 3 STALLS- 1 BIG AND 2 SMALLON RIGHT ENGINE. DECESION MADE TO RETURN TO DFW EMERGENCY DECLARED AND AIRCRAFT WAS OVERWEIGHT FOR LANSDR AALA202601014814Engine · stalledAIRCRAFT WAS GROUNDED: RIGHT ENGINE COMPRESSOR SURGE OR STALL PASSING FL 190 CLIMBING MAX EGT 800 DEGREES MAX DURATION 5-6 SECONDS 3 STALLS- 1 BIG AND 2 SMALLON RIGHT ENGINE. DECESION MADE TO RETURN TO DFW EMERGENCY DECLARED AND AIRCRAFT WAS OVERWEIGHT FOR LANSDR SWAA2025123156230Battery · inoperativeAFT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED THE AFT FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR AALA202512315410Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 16WL BATTERY FAILED DURING SYSTEM TEST. MAINTENANCE REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202512316254Striker · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN WITH ACCESS CODE TO OPEN. REPLACED ELECTRIC STRIKE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-03.SDR AALA202512319322Pump · low pressureAIRCRAFT WAS NOT GROUNDED: NR 2 FUEL TANK AFT BOOST PUMP LOW PRESSURE LIGHT ILLUMINATED. MAINTENANCE REPLACED BOOST PUMP AND ACCOMPLISHED A SATISFACTORY LEAK / OPERATIONAL CHECK PER AMM 28-22-41.SDR AALA202512312123Spring · brokenAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE FORWARD LEFT DOOR OUTSIDE HANDLE NOT SECURE WHEN CLOSED. HANDLE WAS NOT FLUSH WITH AIRCRAFT FUSELAGE UPON INSPECTION AFTER LANDING. MAINTENANCE FOUND THE L1 DOOR OUTER HANDLE WOULD NOT STOW DUE TO THE INNER SDR AALA202512314256Power Supply · no testAIRCRAFT WAS GROUNDED: SEAT MOUNTED PROXIMITY EMERGENCY LIGHTING INOPERATIVE ON ROWS 26ABC TO 33ABC. REPLACED EMERGENCY POWER SUPPLY UNIT M1672 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06-960-806 WITH NO ISSUES NOTED.SDR AALA202512314613Spring · damagedAIRCRAFT WAS GROUNDED: IN DESCENT FLIGHT #1 FLIGHT ATTENDANT REPORTED SEEING DOOR 1R OUTSIDE HANDLE IN UPRIGHT/UNLOCKED POSITION. THE FLIGHT CREW REPORTED THAT THERE WERE NO OPEN-DOOR INDICATIONS. FIRST OFFICER REPORTS HANDLE WAS IN THE PROPER POSITION DURINGSDR AALA202512318122Pin · looseAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE PIN FROM THE GIRT BAR ON MAIN ENTRY DOOR CAME LOOSE WHEN OPENING DOOR AT GATE. MAINTENANCE REPLACED THE SLIDE ASSEMBLY PER TASK CARD 08L22125001 IN ORDER TO PREVENT ANY ACCIDENTAL DEPLOYMENTS OR OTHER ISSUESSDR AALA202512319447Lens · missingAIRCRAFT WAS NOT GROUNDED: 4L DOOR EXIT LIGHTED SIGN MISSING. MAINTENANCE INSTALLED EXIT SIGN LENS.SDR VNAA2025123111101Sensor · faultedLEFT WING ANTI-ICE CAUTION MESSAGE AND WING ANTI-ICE FAULT. REMOVED AND REPLACED THE LT INBD WING TEMP SENSOR IAW AMM 30-12-06-000/400-801-A01-PSA. OPS CHECKED GOOD.