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 FDEA202509251821Skin · cracked01 EACH FASTENER HOLE #15 FOUND CRACK INDICATION DURING OPEN-HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION AT LEFT HAND WING LOWER SKIN ACCESS DOOR CUTOUT BETWEEN STATION XORS= 683.4 AND STATION XORS= 713.6. REPAIR CARRIED OUT AT LEFT HAND WING LOWER SKIN ACSDR FDEA202509251820Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 6-65. X = - 8.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 6-65, 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 TRASDR FDEA202509251819Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1545, X = - 8.5" CROWN FOUND WORN. SEAT TRACK STATION 1545, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMESDR FDEA202509251818Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1601. X = 8.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 1601, X = 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BYSDR FDEA202509251817Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1470. X = 8.5" CROWN FOUND WORN. THE SEAT TRACK CROWN WAS EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT IAW SRM SDR FDEA202509251816Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 5-10, X = - 27.5" CROWN FOUND WORN. SEAT TRACK STATION 5-10, 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 REPAISDR FDEA202509251815Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1299. X = - 47.5" CROWN FOUND WORN. SEAT TRACK STATION 1299, 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 REPAIRESDR FDEA202509251814Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 960. X = 27.5" CROWN FOUND WORN. SEAT TRACK STATION 960, 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 SDR FDEA202509251813Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 775, X = - 47.5" CROWN FOUND WORN. SEAT TRACK STATION 775, X = - 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRSDR FDEA202509251812Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 630. X = - 27.5" CROWN FOUND WORN. SEAT TRACK STATION 630, 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 REPASDR FDEA202509251811Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1130. X = 75.25" CROWN FOUND WORN. SEAT TRACK STATION 1130, 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 REPAIRESDR FDEA202509251810Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 5-10, X = - 8.5" CROWN FOUND WORN. SEAT TRACK STATION 5-10, 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 REPAIREDSDR FDEA202509251809Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 5-33, X = - 8.5" CROWN FOUND WORN. SEAT TRACK STATION 5-33, 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 REPAIRSDR FDEA202509251808Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1045. X = - 8.5" CROWN FOUND WORN. SEAT TRACK STATION 1045, 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 REPAISDR FDEA202509251807Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1019. X = 8.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 1019, 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 RESDR FDEA202509251806Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1045. X = 8.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 1045, X = 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPSDR FDEA202509251805Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1009. X = - 27.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 1009, 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 TSDR FDEA202509251804Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1019. X = - 27.5" CROWN FOUND WORN. CABIN - AT SEAT TRACK STATION 1019, 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 TSDR FDEA202509251803Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1299. X = 47.5" CROWN FOUND WORN. SEAT TRACK STATION 1299, 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 BYSDR FDEA202509251802Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT BS 5-10. X = 47.5" CROWN FOUND WORN. SEAT TRACK CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R, SDR FDEA202509251801Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 5-15, X = 27.5" CROWN FOUND WORN. SEAT TRACK CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT AT EXISTING SPLICES BS SDR FDEA202509251800Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1481. X = 27.5" CROWN FOUND WORN. SEAT TRACK CROWN EVALUATED AND FOUND EXCEEDED LIMIT IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT AT BS 1471 TO EXISTING SSDR FDEA202509251799Seat Track · wornMAIN DECK CARGO COMPARTMENT - SEAT TRACK CROWN FOUND WORN BETWEEN STATION 5-10 X= 47.5. MAIN DECK CARGO COMPARTMENT-SEAT TRACK BETWEEN STATION 5-0 TO STATION 5-10, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD11 SRM 53-00-52-1A FIGURE SDR DALA2025092506995Packing · leakingFUMES EVENT ON FLIGHT DECK AND FWD GALLEY DESCENDING THRU 8000 FT. SWEET CHEMICAL SMELL. FUMES PRESENT THRU ROW 3. CL II MTC SMOKE MSG. REPLACED FAN SHAFT COVER PACKING FOR #1 ENG PER A321 AMM 72-15, NO LEAKS. PERFORMED LEVEL A DECONTAMINATION PER A321 AMM 2SDR 2025FA0000663Valve · failed inspDURING ROUTINE 100 HR INSPECTION FOUND COMPRESSION TO BE 40/80 ON CYLINDER #4 AND INSPECTED FURTHER. FOUND THAT VALVE WAS NOT SEATING PROPERLY. VALVE SEAT WAS BELL MOUTHED, VALVE PUSHES IN AN OUT ON A CURVE RATHER THAN STRAIGHT, WORN ONLY ON ONE SIDE. IMPROPSDR UIEA2025092501244Slide · inoperativeFA OPENED ARMED L4 DOOR SLIDE DID NOT INFLATE. R & R L4 SLIDE IAW AMM 25-66-01. OPS CHECK NORMAL. THIS CLOSES MDDR 238866. PLACARD REMOVED.SDR ABXA20250925239Charger · faultedDURING TAXI OUT, MAIN BATTERY DISCHARGE STATUS MESSAGE ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS. (BTB). MAINTENANCE REMOVED AND REPLACED MAIN BATTERY CHARGER. OPS CHECKED GOOD IAW AMM 24-31-01-4. ACFT RFEMAINS ETOPS 180. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025092506979Housing · detached38H, 50B, & 57B EMERGENCY LIGHT HOUSINGS BROKEN OFF MOUNT. REPLACED ALL 3 HOUSINGS IAW AMM 33-51. OPS NORMAL. (1216488)SDR KCSA202509251170Longeron Fitting · crackedTWO CRACKS WERE FOUND AT RT LONGERON EXTENSION FITTING.SDR JR2R20250925212Gusset · corrodedGUSSET AT FR90, BL0, IS CORRODED. OUT OF LIMITS. REPLACEDSDR KCSA202509251169Longeron Fitting · crackedONE CRACK WAS FOUND AT LT LONGERON EXTENSION FITTING.SDR JR2R20250925271Skin · chafedRIGHT WING LEADING EDGE PANEL BETWEEN RIBS 10 AND 11 IS CHAFED OUT OF LIMITS. REPAIREDSDR JR2R20250925270Skin · chafedLEFT WING LEADING EDGE PANEL BETWEEN RIBS 10 AND 11 HAS A PREVIOUS REPAIR THAT IS CHAFED OUT OF LIMITS. REPAIREDSDR SWIA2025092476137Floor Panel · corrodedTHE LH PRESSURE FLOOR PANEL BETWEEN FS 409+128 AND FS 559 HAS MULTIPLE SPOTS OF CORROSION. REPAIRED LT PRESSURE FLOOR PANEL BETWEEN FS 409+128 AND FS 559 REF REO 601R-53-41-666 REV C DATED 2012-11-06. COMPLIED WITH 51-900-1003-SKY DETAILED VISUAL INSPECT BLENSDR REXA2026052800855Stringer · corrodedCORROSION ON STRINGER 26RH IN STA. FS= 295 TO FS= 310 AT MAIN AVIONICS COMPARTMENT. (E/E) CORROSION ON STRINGER 26RH IN STA. FS= 295 TO FS= 310 AT MAIN AVIONICS COMPARTMENT. (E/E) WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01, EVALUATED OUT OF LIMITS PER CRSDR SWIA2025092475766Strap · crackedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA25822-601R-57-21-2228 952SW OP94-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 25822WHILE C/W SB 601R-57-046, PART B (R/H WING) STEP 4 (B), NDT NOTED 3 FASTENER HOLES WITH CRACKING INDICATIONS AND ONE FASTENER HOLE (AFTSDR NACA2025092400001Insulation · damagedNR 2 ENG IDG WIRING INSULATION DAMAGED IN NUMEROUS AREAS. R & R THE DAMAGED IDG WIRING IAW WDM 24-21-21 AND SWPM 20-30-13, 20-20-12 AND 20-30-11 REFER TO OPS 50003 FOR ADDITIONAL DETAILS AND OP CHECK.SDR SWI2025F01676Floorbeam · corrodedFLOORBEAM AT FS1051.30 BETWEEN RBL27.00 AND RT OTBD FLOOR SILL HAS CORROSION ON TOP EDGE. REMOVED CORROSION FROM FLOOR CROSS BEAM AT FS1051.30 BETWEEN RBL27 AND RT OTBD FLOOR SILL ON TOP EDGE, IAW SRM 51-21-06-001-001-A01, FLOORBEAM WAS OUT OF LIMITS IAW 53-61SDR SWIA2025120100924Floor Support · corrodedFLOOR BEAM LBL27.00 BETWEEN APPROXIMATELY FS977.00 AND FS1088.20 HAS CORROSION AND SCRATCHES IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 11/30/2025)REPAIRED FLOOR BEAM LBL27.00 BETWEEN APPROXIMATELY FS977.00 AND FS1088.20 REF CRJ700 SRM 51-42-06-001-001-A01SDR SWIA2025112400924Cleat · crackedBS 1015, S18 CLEAT APPEARS TO BE CRACKED. INSTALLED NEW CLEAT IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, REVISION 38, AND DWG MM670-36022, REV C. COMPLIED WITH SKYWEST TAK CARD 51-900-1002-SKY.SDR AALA202511179931Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR DOOR FORWARD HINGE FITTING AFT LUG WORN ON THE FORWARD FACE OF THE KEEL BEAM BETWEEN FR 42 AND FR 43, BETWEEN S41L AND S42L. REPLACED HINGE FITTING PER EA 368510.SDR SWIA20251110924Shear Tie · corrodedFRAME FITTING AT FS 310 BETWEEN STGR 19R AND STGR 17R HAS AREA OF CORROSION. REMOVED AND REPLACED FRAME FITTING AT FS 310 BETWEEN STGR 19R AND STGR 17R IAW CRJ 550 SRM 51-42-06 AND 51-42-21.SDR JJBA20251109013Floor Panel · corrodedPANEL 197AB HAS CORROSION ON TAB. REMOVED DAMAGED TAB ON PENAL 197AB AND REPLACED WITH NEWSDR JJBA20251109012Sill Drain · corrodedRH MOP SILL AT FR 54 TO 55, RH, HAS CORROSION, MARKED. INSTALLED NEW FROM STOCK R/H FLOOR SILL(P/N:145-29495-005) AT FR53 TO FR59SDR JJBA20251109011Sill Drain · corrodedRH MOP SILL FWD SECTION AT FR 53 HAS CORROSION, INSTALLED NEW FROM STOCK R/H FLOOR SILL(P/N:145-29495-005) AT FR53 TO FR59SDR JJBA20251109010Bracket · cracked1 EA BRACKET FOR AIR PRESSURE LINES AT FR 51, RH, STR 6R, IS CRACKED, MARKED. REMOVED AND REPLACED 1EA. DISCREPANT BRACKECT ( PN 145-26345-401) @FS 51 STR 16 RSDR SWAA2025110317981Threshold · damagedELONGATED HOLE ON THRESHOLD PANEL. REPLACED THRESHOLD PANEL IAW SRM 51-40-02, AND DWG 146A8340, SHEET 26, REV -.SDR SWAA2025103017807Stub Frame · crackedCRACK INDICATIONS, 2 EA ON STUB FRAME BETWEEN BS 294.5 - 296.5 S8 - 9R. CRACK LENGTH 1.312 IN. AND 1.125 IN. REPLACED THE STUB FRAME IAW SRM 51-40-02.SDR SWAA2025103017806Bear Strap · crackedCRACK INDICATION ON BEAR STRAP FWD GALLEY DOOR AREA, BS 291-294.5, S8 - 9R .CRACK LENGTH 0.187 IN. REPAIRED IAW SRM 53-10-01-2R-6 AND EA M-25-153-01539.SDR SWAA2025103017977Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB LBL 31 STA 663. CRACK LENGTH: 0.200 IN. PERFORMED REPAIR ON THE PRESSURE DECK IAW SRM 53-40-51-2R-2, REPAIR 2.