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 FDEA202507211283Floor Panel · crackedDENT WITH CRACK ON FLOOR PANEL 252DFF AT MDC SEC 46 FLOOR PANEL 252DFF MDC SEC 46 WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202507211282Floor Panel · crackedPUNCTURE ON FLOOR PANEL 241ZFF AT MDC SEC 45 FLOOR PANEL 241ZFF MDC SEC 45 WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR SCNA20250722268Unknown · odorCREW REPORTS STRANGE SMELL IN CABIN - PERFORMED FIM TASK 21-00 TASK 806 NO DEFECTS NOTED AT THIS TIME REV 06/15/2025SDR DALA2025072205490Indicator · inoperativeSHIP 198 SLIDE INDICATOR LIGHT INOP OR DAMAGED / LOCATIONS:601. SYSTEM CHECK IAW B767 AMM 52-71-00, TEST SATIS (1096892)SDR CALA2025072206841Switch · looseEMER LIGHT SWITCH ASSEMBLY LOOSE. ADJUSTED EMERGENCY LIGHT SWITCH ASSEMBLE REF AMM TASK 33-51-08-004-002;ASSY SECURE.SDR DALA2025072105480Access Panel · brokenSHIP 3353 DOOR 2R ACCESS PANEL BROKEN/STICKING. SECURED SLIDE LEVER ACCESS PANEL AT 2R. OK FOR SVC PER A330 AMM 52-12.SDR DALA2025072105477Fairing · puncturedBELLY PANEL 191AB PUNCTURED ALONG FWD EDGE INLINE WITH DRAINMAST. COMPLIED WITH ER/A 628017-14.SDR DALA2025072105473Lens · detachedSHIP 3130 SEVERAL OF THE EMERGENCY EXIT SIGN LENSES FELL OFF THE HOUSING ASSY. COMPLIED WITH ER/A 610817-14MT.SDR SWAA2025072193511Slide · unlacedR1 DOOR SLIDE UNRAVELED. C/W MT 725-61-06 INSTALLED ORIGINAL SLIDE P/N & S/N. C/W INSPECTION & CHECK AMM 25-66-01. LATCH DISPLACED ONLY.SDR 2025FA0000509Frame · crackedA CRACK WAS FOUND ON THE LUG FOR DOOR STRUT ARM ON THE 7411351-8 SURROUND FRAME. ACCOMPLISHED FR-680A-139-15365 REV - DATED: 25-JUN-2025 - FIELD REPAIR - CRACK, FUSELAGE, AFT DOOR SURROUND FRAME, DOOR STRUT DRIVE ARM ATTACH.SDR IPXA2025072131163Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT AND L9801 DOME EMERGENCY LIGHT INOP T/S ACCOMPLISHED IAW IAI WDM 33-51-13 AND FOUND M736 PWR SUPPLY INOP. R & R M736 IAW AMM 33-51-07-401 REV 145.SDR IPXA2025072127726Lens · brokenLAV COMPT EMER LIGHT LENS BROKEN INSTALLED NEW LIGHT LENS IAW AMM 33-51-21/401.SDR GTIA2025072139005Cradle · faultedF/A REPORT R4 FLASHLIGHT HOLDER INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R/R R4 JUMPSEAT FLASHLIGHT IAW CMM 25-60-13. OPS CHECK GOOD. THIS CLEARS DMI # 3606145-1. PLACARD REMOVED. MOC NOTIFIED.SDR GTIA2025072139004Battery · faultedDURING SERVICE CHECK AFS GROUND SCAN FOUND EPSU BATTERY FAULT-R/R 11WL EPSU BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR GTIA2025072139003Ecs · odorDIRTY SOCKS / ODOR REPORTED BY FLIGHT ATTENDENTS ON CLIMB OUT . AIR QUALITY FORM FILLED OUT WITH INFO . PRESISTENT, DIRTY SOCKS SMELL. APPARENT SOURCE: UNKNOWN. FWD CABIN. NO VISBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PERFORM TSM 05-50-00-810-831-A ASDR AALA202507210878Lever · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED THE HANDLE ON THE ARMING LEVER ON THE 1R DOOR IS FUNCTIONAL BUT LOOSE. MAINTENANCE TIGHTENED LOOSE THROUGH BOLT AND NUT OF ARM PLATE ON DOOR ARMING LEVER PER AMM 25-23-46.SDR JJBA20250721079Angle · crackedCRACK ON LH WING TO BODY FAIRING LOWER ANGLE #2 AT FR 47. LOWER ANGLE #2 AT LH WING TO BODY FAIRING, FR 47 REMOVED. ANCHOR NUTS ON ANGLE REMOVED. HOLES TRANSFERRED ON NEW ANGLE. ANCHOR NUTS REINSTALLED. NEW ANGLE INSTALLED AND SEALED. SURFACE REPROTECTED.SDR JJBA20250721072Floor Support · corrodedLH OB FLOORSILL FROM FRAME 53 TO 65 IS CORRODED. REMOVED CORROSION LH OB FLOORSILL FROM FRAME 53 TO 59. TREATED AND PRIMED LH OB FLOORSILL FROM FRAME 53 TO 59. LH OB FLOOR SILL BETWEEN FRAME 59 AND 61 CORRODED BEYOND LIMITS. REMOVED FLOOR SILL, LOCATED, DRILLESDR QR9R2025072100002Recorder · faultyDURING INSPECTION, CVFDR CONTROL PANEL HAD CVR AND FDR LIGHTS ON AND WOULD NOT EXTINGUISH (SUBBED KNOWN GOOD CVFDR IN, AND LIGHTS WENT OUT). REMOVED AND REPLACED CVFDR IAW AMM 31-32-10, 4-1; MOC OK.SDR QR9R2025072100001Recorder · intermittentCVR AND FDR LIGHTS INTERMITTENTLY ILLUMINATED ON CVFDR CONTROL PANEL. REMOVED AND REPLACED FA5001 CVFDR IAW AMM 31-32-10, 4-1; MOC SUCCESSFULLY COMPLETED.SDR REXA2025072100748Stringer · corrodedCORROSION WAS FOUND AROUND THE RIVETS ON STRINGER 22R BETWEEN FS 280 AND FS 295. REMOVED CORRODED STRINGER 22R FROM F.S.280 TO F.S.333 AND INSTALLED NEW SERVICABLE STRINGER P/N SH670-31210-2U IAW CRJ 700 SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR FDEA202507211280Actuator · failedPER FTAM PG 4-31 ALTERNATE LANDING GEAR EXTEND . WHILE ACTIVATING THE ALT GEAR EXTEND SWITCH, THE ALT GEAR FAILED TO EXTEND. FLIGHT TEST LANDING GEAR ALTERNATE SYSTEM WAS TESTED, BOTH TEST WERE SATISFACTORY IAW AMM 32- 32-00-705-001 AND AMM 32-35-00-7SDR FDEA202507211279Longeron Splice · crackedLOWER CENTER CARGO BAY RT TUNNEL AREA LONGERON SPLICE FOUND CRACKED BETWEEN BS 5-113 - 1541 L35R. LONGERON 35 RT REMOVED & REPLACED WITH FABRICATED SPLICE IAW SRM 51-33-01-0G. SPLICE FABRICATED IAW DRAWING A5A7114 REVISION J. REPAIR CLASSIFIED AS MAJOR IAWSDR SWIA2025120900720Floor Support · corrodedLBL 9 FLOOR SUPPORT IS CORRODED BETWEEN BS 863 AND 879 ON THE UPPER INBD FLANGE. REMOVED CORROSION BY BLENDING IAW REO 670-53-51-353, REV -. COMPLETED TASK CARD 51-900-1002- SKY.SDR SWI2025F01479Roller · failed inspR/H SLAT TRACK 3-2 SIDE ROLLERS AT FWD I/B, FWD O/B, AFT I/B AND AFT O/B FAILED INSPECTION. (S/N 00774) (C-CHECK RO 11/01/2025)REPLACED R/H SLAT TRACK 3-2 SIDE ROLLERS AT FWD I/B, FWD O/B, AFT I/B AND AFT O/B REF CRJ 900 AMM 27-81-44-400 -803-A01 ,REF CRJ9SDR SWI2025F01478Roller · failed inspR/H SLAT TRACK 2-2 SIDE ROLLERS AT FWD O/B AND AFT O/B FAILED INSPECTION. (S/N 00773) (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED NEW SIDE ROLLERS PN: CC670-12027-3 1(EA) AND PN: CC670-12048-3 1(EA) REF CRJ900 AMM 27-81-44-400-802-A01,REF CRJ900 AMM 27-81-SDR SWI2025F01477Roller · failed inspR/H SLAT TRACK 1-2 SIDE ROLLERS AT FWD I/B AND AFT I/B FAILED INSPECTION. (S/N 00772) (C-CHECK RO 11/01/2025)REPLACED R/H SLAT TRACK 1-2 SIDE ROLLERS AT FWD I/B AND AFT I/B REF CRJ900 AMM 27-81-44-400-801-A01 , REF CRJ900 AMM 27-81-44-000-801-A01 TUC8616 CASDR SWIA2025110300720Floor Support · crackedLBL12.00 FLOORBEAM COCKPIT HAS CRACK. BETWEEN FS270 AND FS280. TRANS #30519326 (C-CHECK RO 11/01/2025)REPARED LBL12.00 FLOORBEAM COCKPIT REF CRJ900 SRM 53-11-43-201-003-A01. SEE CONTNINUE CARD FOR MORE DETAILS. COMPLIED WITH TASK CARD 51-900-1002-SKY AND FOSDR AALA202510037808Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL UPPER SURFACE AT LEVEL RIB 5. REPAIRED SKIN PANEL PER EA 367391.SDR K11A2025091800344Stringer · corrodedEVIDENCE OF CORROSION ON STRINGER 21R AT STA 890.SDR IPXA2025081425004Profile · crackedMAJOR REPAIR, MAIN DECK FLOOR STRUCTURE AT FRAME 79, -Y1580.5 HAS A CRACK THROUGH FASTENER HOLE COMPLIED WITH EO-94650-REQ1 AND VT-MAE EA 300-5318-27-A4086, REV. -.SDR IPXA2025090625333Support · brokenFR 75, BTW Y1221.2 AND Y1580.5, CLS ADAPTER WITH CORROSION. INSTALLED ADAPTER CLS AT THE MDC, FR 75 BTW Y1221.2 AND Y1580.5. I.A.W AIRBUS SRM 51-40-21-001.SDR IPXA2025081524090Seat Track · corrodedMAJOR REPAIR. MAIN DECK FLOOR STRUCTURE BETWEEN FRAME 79-80 AT Y0 HAS CORROSION. COMPLIED WITH REPAIR SEAT TRACK, IAW SRM 53-10-16-201 PARAGRAPH 4 FIGURE 201 (REV. 42).SDR SWAA2025090393433Lens · brokenBROKEN LENS EMERGENCY EXIT LIGHT (WITH ARROW) AT EMERGENCY EXIT HATCH RH SIDE PASSENGER CABIN (2EA). REPLACED LENS EMERGENCY EXIT LIGHT (WITH ARROW) AT EMERGENCY EXIT HATCH RH SIDE PASSENGER CABIN (2EA IAW B737-700 AMM 33-51-01-960-802 STEP 3.C.(10).SDR SWAA2025090393429Skin · crackedCRACK LOWER SKIN AROUND ACTUATOR AREA LEADING EDGE SLAT 4 AT LT WING. PERFORMED PERMANENT REPAIR LOC ON LOWER SKIN AROUND ACTUATOR AREA LEADING EDGE SLAT 4 AT LT WING IAW SRM 57-42-01-2R-8 REPAIR 8.SDR SWAA2025090393428Skin · crackedCRACK LOWER SKIN AROUND ACTUATOR AREA LEADING EDGE SLAT 5 AT RT WING. PERFORMED PERMANENT REPAIR LOCATED LOWER SKIN AROUND ACTUATOR AREA LEADING EDGE SLAT 5 AT RT WING IAW SRM 57-42-01-2R-8 REPAIR 8.SDR IPXA2025082800037Profile · crackedMAJOR REPAIR, MDC, BTW FR 78 AND FR 79, Y2127.5, Z PROFILE WITH CRACK COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94651-REQ1 AND VT-MAE EA 300-5318-27-A4088, REV. -.SDR SWAA2025082793413Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 51 WL 208.1. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 51 WL 208.1 IAW SRM 51-40-02; SRM 51-10-02 ITEM 9; DWG 143A5400 SHEET 142 REV - AND DWG 143A5400 SHEET 138 REV -.SDR SWAA2025082793411Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 41 WL 208.1. REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 41 WL 208.1 IAW SRM 51-40-02 SRM 51-10-02 ITEM 9, DWG 143A5400 SHEET 142, REV - AND DWG 143A5400 SHEET 138 REV -.SDR SWAA2025082793412Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 13 WL 208.1. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 13 WL 208.1 IAW SRM 51-40-02; SRM 51-10-02, ITEM 9; DWG 143A5400 SHEET 142 REV - AND DWG 143A5400 SHEET 138 REV -.SDR SWAA2025082793416Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 LBL 44 WL 208.1 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR LOCATED ON BS 986.5 LBL 43 AND WL 208.1 AT AFT GALLEY AREA IAW SRM 53-70-51-2R-6 REPAIR 6 AND SRM 51-20-01-0G-0.<BR>SEE INDIVIDUALSDR SWAA2025082793414Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 RBL 44 WL 208.1 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR LOCATED ON BS 986.5 RBL 43 AND WL 208.1 AT AFT GALLEY AREA IAW SRM 53-70-51-2R-6 REPAIR 6 AND SRM 51-20-01-0G-0.SDR SWIA2025082500720Attach Fitting · corrodedL/H ELEVATOR ATTACH FITTING LOCATED ON ELEVATOR L/E AT RIB# 13 WAS FOUND TO HAVE PITTING ON THE INNER SURFACE. THIS CONDITION WILL REQUIRE A FITTING CHANGE. (C-CHECK RO 8/21/2025) REMOVED & INSTALLED NEW #3 L/H ELEVATOR HINGE FITTING (PN AV670-24136-009SDR IPXA2025081824990Floorbeam · crackedMDC FLOOR, FR 80, BTW Y1221.2 AND Y1580.5, AFT FLOOR STRUCTURE WITH CRACK. INSTALLED PROFILE T AT FR80 Y1221.2 APPLIED IAW A300-600, SRM 51-40-21.SDR AALA202508183403Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO INTERCOSTAL LOCATED AT BS 320, FROM S22L TO S23L. REPLACED INTERCOSTAL PER EA 366700.SDR IPXA2025081545004Floor Support · crackedMAIN DECK FLOOR STRUCTURE AT FRAME 79, -Y1580.5 HAS A CRACK THROUGH FASTENER HOLE OUT OF SEQUENCE PRELIMINARY 1 STEP#12 E.A.#. 300-5318-27-A4086 OK TO INSTALL GIVENSDR SWAA2025081493375Web · corrodedCORROSION WEB LOWER SILL LOCATED BETWEEN BS 440 - 492.4 AND RBL 26, WL 156 AT FWD CARGO COMPARTMENT. REPLACED WEB LOWER SILL AND FASTENERS LOCATED BETWEEN STA440 TO STA492.4 AND RBL26 WL156 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 AND SRM 51-10-02-0SDR SWAA2025081493373Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED IRSS 141 AT RT WING. REPLACED ANGLE TRAILING EDGE LOCATED IRSS 141 AT RT WING IAW SRM 51-40-02 AND SRM 51-10-02 PARAGRAPH 9. MEASURED OF CRACK IS L: 1.631.SDR SWAA2025081293401Angle · corrodedCORROSION ON ANGLE LOCATED BS 794.3 BETWEEN STR 22R AND STR 23R AT AFT CARGO COMPARTMENT. REPLACED ANGLE LOCATED BS 794.3 BETWEEN STR 22R AND STR 23R AT AFT CARGO COMPARTMENT IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9, AND DWG 284A0341, SHEET 3 REV-.SDR AALA202508119603Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 440 TO BS 500I AT S26L. REPLACED TRANSITION PANEL AARD 51-00-05-1.