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 FDEA202601140038Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 242VFF FLOOR PANEL 242VFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 (SHEET 2) REV 93 AUG 15/2025SDR FDEA202601140037Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 241AFF FLOOR PANEL 241AFF WAS REPAIRED IAW SRM 53-00-50-2R PAR 4-B FIG 201 (SHEET 2) REV 93 AUG 15/2025SDR FDEA202601140036Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 242HFF FLOOR PANEL 242HFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 (SHEET 2) REV 93.SDR FDEA202601140035Lamp · inoperativeFOUND ON PREFLIGHT, EMERGENCY LIGHT ABOVE DOOR R1 INOPERATIVE. AMM: 33-51-03-2 REMOVED AND REPLACED R1 DOOR AREA EMERGENCY LIGHT LAMP AND THEN OP'S CHECKED NORMAL IAW AMM 33-51-03-2.SDR CALA2026011512976Girt Bar · not seatedGIRT BAR FELL ON THE FLOOR AS DOOR 1L WAS CLOSING, SLIDE RAFT APPEARS LOOSE. FOUND GIRT BAR AT DOOR 1L NOT STOWED, INSPECTED DOOR 1L ESCAPE SLIDE FOUND TO BE OK NOT LOOSE. SUSPECT GIRT BAR WAS NOT STOWED PROPERLY. STOWED GIRT BAR REF AMM 25-66-00 DOOR CLOSSDR CALA2026011512974Battery Pack · no testEMERGENCY LIGHT BATTERY PACKS, M1674 FAILED FUNCTIONAL CHECK. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1674, IAW AMM 33-51-06-960-806. TEST CHECKS GOOD.SDR CALA2026011512973Lamp · inoperativeEMERGENCY PATH LIGHT AT ROW 32ABC INOPERATIVE. REMOVED AND REPLACED FLOOR PROXIMITY LAMP AT ROW 32ABC. FLOOR PROXIMITY LIGHT OPS CHK GOOD. REF. AMM 33-51-11-960-801.SDR CALA2026011412969Unknown · odorON TAKEOFF HEAVY DIRTY SOCK ODOR IN FLIGHT DECK UNTIL CLIMB THRUST. CABIN REPORTED NO ODOR ON DEBRIEF CREW. CAPTAIN CONFIRMS ODOR STARTED ON TAXI AND DISAPPEARED AFTER TAKEOFF. CAPTAIN SUSPECT ODOR COMING OUT OF THE LT PACK. NO ODOR IN CABIN. CONFIRMED ENGISDR ABXA20260114011Lever · fodON TAXI OUT, HAD STEERING ISSUES. AIRCRAFT RETURNED TO BLOCKS (BTB). CLEANED DEBRIS FROM NOSE STEERING BYPASS LEVER. LEVER NOW HAS FULL TRAVEL. OP'S CHECKS GOOD IAW AMM 32-51-00. AIRCRAFT RETURNED TO SERVICE.SDR BJNA202601150001Bleed Valve · leakingON DESCENT THROUGH LOWER ALTITUDES BELOW 12,000 FT CABIN HAS STRONG ENGINE OIL/ WET SOCK SMELL. PERFORMED FIM FOR SMOKE/FUMES IN CABIN IAW FIM 21-00 TASK 806 UP TO STEP F. (F). OIL SMELL ON HAPPENS WHEN RIGHT ENGINE BLEED IS THE SUPPLY FOR PNEUMATIC/PACK SYSTSDR 2026F00003Frame · crackedRIGHT FRAME 5 CRACK FOUND DURING INSPECTIONS.SDR DALA2026011400338Engine · failedIFSD- DIVERSION TO MCI DUE TO RIGHT ENGINE FAILURE AND IFSD. ENGINE CHANGE REQUIRED DUE TO METAL IN THE TAILPIPE. REPLACED NBR 2 ENGINE. (LP 8168908, 1384104)SDR JJBA20260114031Seal · tornRIGHT ENGINE PYLON UPPER FAIRING HAS SEAL TORN. REMOVED AND REPLACED SEAL ON RH ENGINE PYLON UPPER FAIRING.SDR JJBA20260114027Floor Support · corrodedFWD WET AREA RH FLOOR GUSSET HAS CORROSION AT FR 22. REMOVED AND REPLACED FWD WET AREA RH FLOOR GUSSET.SDR DALA2026011400334Skin · damagedFUSELAGE SKIN AND STRINGER 3R AT FR 61, FR 62 DAMAGED HOLES AND TOOLING DAMAGE. REPAIRED PER ERA 627795-14 REV A. (1400862)SDR FDEA202601140034Repair · no discrepancyEXISTING REPAIR ON MDCC FLOOR SUPPORT AT -Y1959 BETWEEN FR12A AND FR18 REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MDCC FLOOR SUPPORT AT -Y1959 BETWEEN FR12A AND FR18 WAS EVALUATED AND FOUND IN CONFORMITY WITH DWG: A53612213 (ISSUE: G00). ESDR FDEA202601140033Repair · no discrepancyEXISTING REPAIR ON MDCC FLOOR SUPPORT AT Y0 BETWEEN FR11 AND FR19 REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MDCC FLOOR SUPPORT AT Y0 BETWEEN FR11 AND FR19 WAS EVALUATED AND FOUND IN CONFORMITY WITH DWG: A53612213 (ISSUE: G00). EO: 6-5100-SDR FDEA202601140032Repair · no discrepancyEXISITING REPAIR ON MDCC FLOOR SUPPORT AT Y450 BETWEEN FR11 AND FR15A REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MDCC FLOOR SUPPORT AT Y450 BETWEEN FR11 AND FR15A WAS EVALUATED AND FOUND IN CONFORMITY WITH DWG:A53612213 (ISSUE: G00). EO: 6-SDR FDEA202601140030Skin · crackedDURING PERFORMANCE OF WORK CARD:EG-5710-E0376285E P12 STEP 3.B. & STEP 5.A.(2), FOUND ONE CRACK ON THE RT UPPER WING SKIN FASTENER NR 5. REPAIRED IAW SRM 51-40-05-0G FIGURE 4 TABLE C, SRM 51-40-02-0G FIGURE 12, SRM 51-40-04-0G FIGURE 2 TABLE A, REV 51.0 SDR FDEA202601140029Skin · crackedDURING PERFORM WORK CARD:EG-5710-E0376285E P11 STEP 3.B.& STEP 5.A.(2) THEN FOUND TWO CRACKS ON THE LT UPPER WING SKIN FASTENER 5. REPAIRED IAW SRM 51-40-05-0G FIGURE 4 TABLE C, SRM 51-40-02-0G FIGURE 12, SRM 51-40-04-0G FIGURE 2 TABLE A, REV 51.0 AND EA GSDR YENA2026011400036Warning Message · illuminatedFLT # 2009 JFK-JFK (ETOPS). "REJECTED TAKE OFF APPROXIMATELY 60 KIAS DUE TO AIR -R WING LEAK.; REMOVED & REPLACED 1EA. BLEED AIR DUCY LOCATED TOP CENTER #2 ENGINE PYLON IAW MM 36-11-48-400-803-A. IDLE LEAK CHECK NORMAL. NO LEAKS. ACCOMPLISHED POWER ASSURANCE TSDR AALA202601140709Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-06.SDR AALA202601140431Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER IAW AMM 52-22-06.SDR DALA2026062303733Skin · corrodedERA 620866 REVISED TO REV A. SECTION I ISSUED FOR CORROSION TO AFT FUSELAGE SKIN SURROUND WASTE SERVICE CUTOUT. FOLLOW ON ACTION REQUIRED. ACCOMPLISH SECTION IV WITHIN 2 FC OF LOG PAGE CREATION. SECTION II REQUIRED EVERY 1000 FH THEREAFTER UNTIL SECTION III. SSDR YENA2026011400035Transmitter · faultedFLT 034, CDG -BOS (ETOPS). NR 2 ENG OIL SENSOR ON 19.5 ON GROUND OUT OF PARIS THEN ONE HOUR INTO THE FLIGHT DROPPED TO 12 THEN CLIMB TO 13 THEN ON LANDING WENT TO 20.5. SO 19.5 ON THE GROUND IN PARIS THEN 20.5 ON THE GROUND IN BOS ( OIL QUANTITY INDICATIONS SDR SWIA2026011375891Retainer · gougedCARGO DOOR UPPER AFT SEAL RETAINER GOUGED. REMOVED AND REPLACED THE CARGO DOOR UPPER AFT SEAL RETAINER IN REFERENCE WITH THE SRM 51-42-06. COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR SWIA2026011375890Skin · gougedCARGO DOOR OUTER SKIN HAS GOUGE LOWER FWD CORNER. BLENDED GOUGE ON CARGO DOOR OUTER SKIN, LOWER FWD CORNER WITH REFERENCE TO REO 601R-52-31-445 REV--. REFERENCE CP 31591872 FOR EDDY CURRENT INSPECTION. PERFORMED UT THICKNESS MEASUREMENT OF BLEND WITH REFERSDR SWIA2026011375612Drag Angle · crackedVERTICAL STAB. LH SIDE AFT DRAG ANGLE HAS POSSIBLE CRACKED. REPLACED VERTICAL STAB. LH SIDE AFT DRAG ANGLE REF CRJ700 51-42-21-001-001-A01, CRJ700 51-42-13-001-001-A01 AND CRJ700 SRM 51-42-22-001-001-A01 AND DWG BA670-35002 REV: F. COMPLIED WITH 51-900-1002-SSDR SWIA2026011375607Vane · chafedLT INBD FLAP VANE, LEADING EDGE CHAFED AT MULTIPLE SPOTS. R & R LT INBD FLAP VANE LEADING EDGE WITH NEW IAW SRM 51-42-10-001-001-A01, & DWG CC670-14010 REV -F.SDR SWIA2026030975474Attach Angle · crackedTORQUE BOX BL9R OUTBOARD ATTACH ANGLE TOO THE 280.00 BEAM IS CRACKED AT THE TOP IN THE RADIUS. MARKED IN RED. (C-CHECK RO 03/07/2026)INSTALLED NEW RH OUTBOARD ATTACH ANGLE AT RBL9 FS 280.00 REF CRJ550 SRM 51-42-21-001-001-A01 AND DWG CC670-34010 REV -K. COMSDR SWIA2026030975473Floorbeam · corrodedFS280.00 BEAM TOP OF THE UPPER FLANGE ON THE AFT SIDE OF THE 280.00 BEAN IS CORRODED FROM APPROXIMATLY BL12L - BL12R. (C-CHECK RO 03/07/2026)REPLACED BY NEW ONE CROSSBEAM OF BULKHEAD FS280.00 LEFT HAND SIDE REF. DWG CC670-34010 REV. -K, CRJ550 SRM 51-42-06-001SDR SWIA2026030975464Floor Support · corrodedFS485.00 - AFT OF FS565.00 LBL 9 FLOOR BEAM CAP CORRODED IN SEVERAL AREAS (MARKED) (C-CHECK RO 03/07/2026) INSTALLED NEW FLOORBEAM SECTION FABRICATED WITH ALL NEW REPAIR PARTS FABRICATED AT APPROX. FS 485 - FS 565, LBL 9, REF. DWG SH670-32120 REV. -D, DWG SHSDR SWIA2026030975461Doubler · corrodedANTENNA DOUBLER IS CORRODED FS310.00 - 319.00 STGR27. (C-CHECK RO 03/07/2026)INSTALLED NEW TCAS ANTENNA CHANNEL P/N SH670-32364-7, AT FS310-FS319, STGR 27, REF. CRJ700 SRM 51-42-20-001-001-A01, CRJ700 SRM 51-42-06-001-001-A01 AND DWG SH670-30023 REV G, COMPLSDR SWIA2026030975458Floorbeam · crackedCOCKPIT RIGHT HAND FLOOR BEAM, BL9R, IS CRACKED IN THE VERTICAL RADIUS AT THE FS280.00 BEAM. (C-CHECK RO 03/07/2026)INSTALLED NEW COCKPIT FLOOR BEAM SECTION AND PREVIOUS REPAIR PARTS (FOUND ON GOOD CONDITION) ON RBL9 FS 280.00 REF CRJ550 SRM 53-11-43-201-003-SDR SWIA2026011375452Stringer · corrodedSTRINGER 25R HAS TWO AREAS OF CORROSION FS295.00 - 319.00. MARKED IN RED. (C-CHECK RO 03/07/2026)REPAIRED AREA AT STRINGER 25R BETWEEN FS 295- FS319, CONDITION IS STRUCTURALLY ACCEPTABLE, REF. REO 670-53-21-2793 REV -- DATE 2026-01-22, COMPLED WITH 51-900-SDR SWIA2026030975439Angle · corrodedAVIONICS BAY FLOORBOARD MOUNTING ANGLE ON THE AFT SIDE OF FRAME FS280.00 HAS CORROSION AROUND THE 3 HOLES FOR THE FLOOR BOARD SCREWS. MARKED IN RED. (C-CHECK RO 03/07/2026)REMOVED AND INSTALLED NEW ANGLE CC670-34256-3 IN A-BAY FLOORBOARD MOUNTING ANGLE ON THSDR REXA2026030900212Fitting · wornWEAR ON FLAP FITTING AND PLATE SUPPORT OF FLAP STUB FAIRING 171DL AND 172DR AT RH/LH WING TRAILING EDGE. FLAP FITTING (2EAS) OF FLAP STUB FAIRING 171DL AND 172DR AT RT & LT WING TRAILING EDGE WERE REPLACED PER CRJ900 SRM 51-41-02-001-001-A01, CRJ900 SRM 51-42-SDR REXA2026030900203Retainer · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND RBL 34) BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND RBL 34) WAS REPLACED PER CRJ 900 SRM 51-41-02-001-001-A01SDR REXA2026030900202Drag Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM WAS REPAIRED PER CRSDR SWAA2026021860763Light · burned outBURNED OUT OVERWING EXIT LIGHT, ROW 14 RIGHT. REPLACED THE LIGHT IAW AMM 33-21-00-960-805, STEP 10.A. - 10.C.(11), EXCEPT 10.C.(4)(D) AND 10.C.(5)(D). TESTED OK.SDR SWAA2026021860771Light · burned outBURNED OUT OVERWING EXIT LIGHT ROW 14 LEFT. REPLACED THE LIGHT IAW AMM 33-21-00-960-805, STEP 10.A. - 10.C.(11) EXCEPT 10.C.(4)(D) AND 10.C.(5)(D). PERFORMED A TEST, TESTED OK.SDR SWAA2026021860967Lens · brokenBROKEN EMERGENCY LIGHT LENS. REPLACED THE LENS IAW AMM 33-51-03-960-803, STEP 4.D.(1)(2).SDR SWIA2026011375064Frame · mechanic errorMISDRILLED HOLE ON THE REAR SPAR FRAME SECTOR FS797.00, AT LBL36. (FILED CLOSED)PERFORMED ALL STEPS PER REO 670-53-41-789 REV -- DATE 2026 JAN 23. NO OTHER DISCREPENCIES FOUND AT THIS TIME. SEE NDT REPORT ATTACHED.SDR SCNA20260217087Door Sill · corrodedCORROSION ON WEB LOWER MAIN SILL AT FWD CARGO DOOR CUTOUT BTW STA 440 TO STA 492SDR HNAA2026021600130Spar · crackedRIGHT WING SPAR I LOWER FLANGE CRACKED AT RIB 9. PERFORMED PERMANENT REPAIR ON RT WING SPAR 1 LOWER FLANGE AT RIB 9 IAW SRM 57-20-05RE ITEM 3, ETD 2026-145-000769 AND PDT EO# EO1-57-26-0052.SDR AALA202602165319Hinge Arm · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ELEVATOR HINGE 4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED SUPPORT ANGLE ELEVATOR HINGE #4 LOC ON RH HORIZONTAL STABILIZER IAW A319 SRM 51-42-11-801 AND DWG D55182732.SDR SWAA2026021361129Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561BB, LT WING. REPAIRED ACCESS PANEL 561BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026021361132Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661BB, RT WING. REPAIRED ACCESS PANEL 661BB IAW SRM 51-70-04-2R-9, REPAIR 9.SDR SWAA2026021260970Frame · crackedCRACKED FRAME, BS 259.5, S8 - 9R IN THE FLIGHT DECK. PERFORMED A REPAIR, CAT B ON THE FRAME BS 259.5 BTWN STR 6 - 11R IAW EA 26-153-00146-WIP1. & EA 26-153-00146.SDR SWAA2026021260968Rib · crackedCRACKED INSPAR RIB, HSS 120.30 AND 10 INCHES FROM REAR SPAR IN THE RT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR OF THE RIB IAW SRM 55-10-09-2R-4, REPAIR 4, FIGURE 202.