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 7C7A1900010000024Skin · dentedDENT ON FUSELAGE SKIN AT STA 531 BETWEEN STR 28L AND 28RSDR F3LA202508130278Floor Support · corrodedFLOOR SUPPORT Y765 AT FR 66-70 FOUND CORRODED. REPLACEMENT IS REQUIRED IAW SRM 51-72-11 REV 44. FLOOR SUPPORT Y-765 AT FR66-FR67 INSTALLED IAW SRM 51-72-11 REV 44.SDR F3LA202508130277Door Sill · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION OF THE AFT CABIN FLOOR STRUCTURE FOUND CORROSION L2 DOOR SILL BEAM FR-69. PERFORMED REPAIR OF THE L2 DOOR SILL IAW-SRM-53-41-14-300-001 REV 45. MX ACTION IS ACCEPTABLE.SDR F3LA202508130276Door Sill · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION OF THE AFT CABIN FLOOR STRUCTURE FOUND CORROSION R2 DOOR SILL BEAM FR-68. PERFORMED REPAIR OF R2 DOORSILL IAW SRM-53-41-14-300-001 REV 45. MX ACTION IS ACCEPTABLE. /END/.SDR F3LA202508130275Floor Support · crackedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION FOUND CABIN FLOOR SUPPORT Y-1292 CORRODED. REQUIRES REPLACEMENT AS PER SRM 51-72-11 REV 44. FLOOR SUPPORT AT Y-1292 WAS REPLACED AS PER SRM 51-72-11 REV 44. FLOOR SUPPORT AT Y-129SDR JR2R20250813411Panel · chafedRIGHT HAND PYLON PANEL, 429ML, CHAFED IN MULTIPLE NO DAMAGE ALLOWED AREAS, OUT OF LIMITS. REPAIREDSDR AALA202508134689Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR LOWER CHORD VAPOR BARRIER ATTACH ANGLE AT STA 663.75, RBL 12, RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOUND SIDE. REPAIRED PER SRM 57-10-10-2R-5.SDR QR9R2025081300001Gearbox · failedWINDSHIELD WIPER FAILED IN FLIGHT. REMOVED AND REPLACED WIPER MOTOR ASSY IAW AMM 30-40-00, 4-4. MOC COMPLETED OK.SDR IPXA2025081300001Windshield · failedAIR TURNBACK, PASSING 20,000 FEET NOTICED ARCING AND BURNING IN LOWER RIGHT CORNER OF CAPT WINDSCREEN. TURNED OFF HEAT PER QRH. PASSING 24,000 WINDSCREEN SHATTERED. COMPLETED CHECK LIST IN QRH. RETURNED TO RFD.SDR FDEA202508131444Seat Track · wornCABIN-SEAT TRACK AT STATION 5-5, X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-5, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACSDR FDEA202508131443Seat Track · wornSEAT TRACK AT STATION 1289, X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1289, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACKSDR FDEA202508131442Seat Track · wornSEAT TRACK AT STATION 1289, X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1289, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK RSDR FDEA202508131441Seat Track · wornCABIN-SEAT TRACK AT STATION 1279, X= 75.25 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1279, X= 75.25 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SSDR FDEA202508131440Seat Track · wornCABIN-SEAT TRACK AT STATION 1279, X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1279, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508131439Seat Track · wornCABIN-SEAT TRACK AT STATION 1279 X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1279, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEASDR FDEA202508131438Seat Track · wornCABIN-SEAT TRACK AT STATION 1279, X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1279, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEASDR FDEA202508131437Seat Track · wornCABIN-SEAT TRACK AT STATION 1165, X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1165, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508131436Seat Track · wornCABIN-SEAT TRACK AT STATION 1165, X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1165, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508131435Seat Track · wornCABIN-SEAT TRACK AT STATION 1165, X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1165, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508131434Seat Track · wornCABIN-SEAT TRACK AT STATION 1165, X= 47.5 FOUND CROWN WORN. SEAT TRACK AT STATION 1165, X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1165, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGSDR FDEA202508131433Seat Track · wornCABIN-SEAT TRACK AT STATION 1149, X= -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1149, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508131432Seat Track · wornSEAT TRACK AT STATION 1149, X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1149, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRSDR FDEA202508131431Seat Track · wornSEAT TRACK AT STATION 6-4 X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-4, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK SDR FDEA202508131430Seat Track · wornCABIN-SEAT TRACK AT STATION 6-9, X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-9, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508131429Seat Track · wornCABIN-SEAT TRACK AT STATION 6-4, X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-4, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT SDR FDEA202508131428Seat Track · wornSEAT TRACK AT STATION 6-4, X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-4, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK RESDR FDEA202508131427Seat Track · wornCABIN-SEAT TRACK AT STATION 1541, X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1541, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508131426Seat Track · wornCABIN-SEAT TRACK AT STATION 1541 X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1541, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508131425Seat Track · wornCABIN-SEAT TRACK AT STATION 5-5, X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-5, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRASDR FDEA202508131424Seat Track · wornCABIN-SEAT TRACK AT STATION 5-11, X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-11, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEASDR FDEA202508131423Seat Track · wornCABIN-SEAT TRACK AT STATION 5-6, X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-6, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508131422Seat Track · wornCABIN-SEAT TRACK AT STATION 5-5, X= -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-5, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEASDR FDEA202508131421Seat Track · wornCABIN-SEAT TRACK AT STATION 1421, X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1421, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508131418Frame · crackedCENTER WING BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 RH SIDE, FASTENER "C" HOLE FOUND CRACK SIGNAL COMPLIED WITH EA: 6-5710-T0384526 P1. TITLE: WINGS - BASIC WING STRUCTURE - FR47 RH REAR SPAR HOLE C CRACK REPAIR - SB ASDR FDEA202508131417Frame · crackedCENTER BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 LH SIDE, FASTENER "C" HOLE FOUND CRACK SIGNAL COMPLIED WITH EA: 6-5710-T0384530 P1. REPAIRED THE CENTER BOX REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 LH SSDR ABXA20250813175Manifold · crackedON TAXI R ENG HAD VIBRATIONS FROM 2.8 TO 3.3. WHEN ADDING TAXI THRUST VIBRATION INDICTIONS UP NTO 4.9 AND STARTED BEING VARIABLE- VIBRATION FELT IN AIRFRAME. AIRCRAFT RETURNED TO BLOCKS. (BTB). PERFORMED D.V.I OF RT ENG & FOUND UPPER & LOWER LPT COOLING AIR SDR 29EA202508130179Hydraulic System · false indicationC. HYD. SYSTEM EICAS MESSAGESDR YENA2025081300831Warning Message · false activationFLT#778, LAS-BOS. (ETOPS) CLASS AIRBLEED MX MSG ON STATUS PAGE ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED ); TROUBLE & RESET BMC'S PER AMM 36-11-34. OPS CHECK NORMAL. NO FUTHER DEFECSDR CALA2025081307683Not Reported · not reportedRIGHT OFF WING ESCAPE SYSTEM DISARMED IAW AMM REF 25-65-00-042-001. TASK COMPLETED IN ITS ENTIRETY INCLUDING REMOVAL OF LEFT EMERGENCY OFF WING ESCAPE SYS BATTERY CONNECTOR M961. OFF WING ESCAPE SYSTEM RE ARMED AS PER AMM TASK 25-65-00-442-010. VERIFED REARMISDR HNAA2025081300569Condenser · failedAFTER T/O SMOKE IN FLT DECK WITH PACK 1 SELECTED, SMOKE CLEARED WHEN PACK 1 DESELECTED AIR CONDITIONING PACKS R & R HEAT EXCHANGER,CONDENSOR MIXER, AND WATER COLLECTOR. OPS CHECK GOOD WITH APU AND ENGINES PACK 1 SELECTED NO SMOKE IN COCKPIT.SDR SCNA20250813317Unknown · odorMECHANICAL/ELECTRICAL ODOR IN FLIGHTDECK AT CRUISE. PERFORMED FIM 21-00 TASK 806 STEP C, NO FUMES, SMOKE OR ODOR DETECTED, OK FOR SERVICESDR REXA2026052700729Floorbeam · corrodedAFTER FLOOR PANEL SUPPORT ANGLE, CORROSION AT RH CROSSBEAM FS 280.00 RH CROSSBEAM FS280.00 WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND PER CRJ900 SRM 51-42-21-001-001-A01SDR REXA2026052700728Floorbeam · corrodedAFTER FLOOR PANEL SUPPORT ANGLE, CORROSION AT LH CROSSBEAM FS 280.00. CORROSION AT LH CROSSBEAM FS280.00 WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND PER CRJ900 SRM 51-42-21-001-001-A0SDR REXA2026052700725Floorbeam · corrodedAFTER FLOOR PANEL SUPPORT ANGLE, CORROSION AT RH CROSSBEAM FS 280.00 FLOOR PANEL SUPPORT ANGLE (251ALF FLOOR PANEL AREA) WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND PER CRJ900 SRM 51-SDR REXA2026052700720Floorbeam · corrodedAFTER FLOOR PANEL SUPPORT ANGLE, CORROSION AT LH CROSSBEAM FS 280.00. CORROSION AT LH CROSSBEAM FS280.00 WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND PER CRJ900 SRM 51-42-21-001-001-A0SDR SWIA2026020475199Stringer · corrodedSTRINGER 26R HAS CORROSION IN MULTIPLE AREAS BETWEEN BS 469 AND 485. REPLACED THE STRINGER IAW DWG SH670-30006, REV A, SRM 51-42-06-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025081275160Window Post · crackedDURING AUDIT OF 9Y TASK CARD 53-220-504 IT WAS FOUND THE THE RH OUTBOARD WINDOW POST IS CRACKED (C-CHECK RO 02/01/2026)REMOVED AND INSTALLED NEW RH WINDSHIELD POST P/N 601R33223-2 IAW. CRJ 900 SRM 51-42-21-001-001-A01 AND DWG CC670-33055 REV-F. COMPLIED WITHSDR NACA2025082100001Pressure Switch · no testE/E COOLING SYSTEM DIFFERENTIAL PERSSURE SWITCH FAILED FUNCTIONAL CHECK. REMOVED AND REPLACED PRESSURE SWITCH IAW 21-58-29-004-001 AND 21-58-29-404-013. OPS CHECK GOOD.SDR SWIA2025123000812Plate · dentedPAX DOOR FWD STRIKER PLATE DENTED AT STR4L. REPAIRED DAMAGE TO PAX DOOR FWD STRIKER PLATE AT STGR 4L IAW CRJ900 SRM 53-21-23, 51-21-11, 51-25-06, 51-25-16, 51-41-02, 51-42-06, AMM 20-70-00, 52-00-00.SDR SWI2025F01449Floor Support · corrodedUPON REPEAT INSPECTION OF THE L/H FLOOR SILL FOUND ADDITIONAL CORROSION AT, FS 413, FS 480, AND FS 537 ON L/H FLOOR SILL (C-CHECK RO 10/19/2025)REPAIRED CORRSION ON LH FLOOR SILL AT FS 413, FS 480, AND FS 537 IAW REO 601R-53-41-666 REV C DATED 2012-11-06. CO