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 FDEA202508161469Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1149, X= 8.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1149 X= 8.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROSDR FDEA202508161468Seat Track · wornCABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 112/6-5 X= 27.5" FOUND CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1129/6-5 X= 27.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 SDR FDEA202508161467Floor Panel · deterioratedMAIN DECK CARGO COMPARTMENT FLOOR PANEL #231EF FOUND DELAMINATED, STATION 495-595. DELAMINATED FLOOR PANEL #231HF AT MAIN DECK CARGO COMPARTMENT STATION 495-575 REMOVED AND REPLACED AS PER AMM 53-21-04-4. FLOOR PANEL #231EF AS PER FEDEX DRAWING SRZ-25-00SDR FDEA202508161466Floor Panel · deterioratedMAIN DECK CARGO COMPARTMENT FLOOR PANEL #231HF FOUND DELAMINATED, STATION 595-675. DELAMINATED FLOOR PANEL #231HF AT MAIN DECK CARGO COMPARTMENT STATION 595-675 REMOVED AND REPLACED AS PER AMM 53-21-04-4. FLOOR PANEL #231HF AS PER FEDEX DRAWING SRZ-25-00SDR FDEA202508161465Former · crackedEXISTING REPAIR AT RIGHT HAND WING FIXED LEADING EDGE COMPARTMENT FORMER STATION XOS 1025.289 (REPLACED FORMER PART NUMBER ARB2920-14 BY FABRICATION) EXISTING REPAIR AT RIGHT HAND WING FIXED LEADING EDGE COMPARTMENT FORMER STATION XOS 1025.289 EVALUATED SDR FDEA202508161464Seat Track · wornCABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= -27.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= -27.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLESDR FDEA202508161463Seat Track · wornCABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= 47.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= 47.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIIT AS PER MD11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DSDR FDEA202508161462Seat Track · wornCABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= 27.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= 27.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DSDR FDEA202508161461Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= 8.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= 8.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROSDR FDEA202508161460Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= -8.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= -8.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CSDR FDEA202508161459Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1069, X= 27.5" CROWN WORN. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1069 X= 27.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1.SDR FDEA202508161458Seat Track · wornCABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280, X= -47.5" CROWN WORN. MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1280 X= -47.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIIT AS PER MD11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1SDR FDEA202508161457Trunnion · crackedDURING HIGH FREQUENCY EDDY CURRENT INSPECTION ON THE LEFT HAND NOSE LANDING GEAR TRUNNION LONGERON SURFACE FOUND CRACK INDICATION APPROXIMATELY 0.25 INCH IN LENGTH AT STATION 583 X=24. LEFT HAND NOSE LANDING GEAR TRUNNION CRACKED LONGERON STATION 583 X=24SDR DXTA2025081804628Brake · faultedRIGHT BRAKE WHEN APPLIED WILL RAPIDLY INCREASE & DECREASE BRAKE PRESSURE CAUSING A VERY JOLTY TAXI. IT IS ESPECIALLY PROMINENT WHEN LIGHT PRESSURE IS ADDED AT LOW TAXI SPEEDS. DOWNLOADED FDR DATA FOR THEM TO REVIEW. BLED BOTH MLG BRAKES & PARKING, EMERGENCY BSDR IPXA2025081811257Rvdt · warning messageDURING AFTER START FLOW PRIOR TO TAXI WITH FLAP LEVER SELECTED TO 10, EICAS DISPLAYED YELLOW €˜X€™ OVER RIGHT INBOARD/OUTBOARD FLAP POS INDICATOR. FLAP POS INDICATOR. LEFT FLAPS INDICATED CORRECTLY REMOVED & REPLACED RIGHT OUTBOARD RVDT TRANSMITTER EQUIP# M7SDR IPXA2025081800044Bumper · missingFOUND CREW ENTRY DOORWAY LINING BUMPER WITH MISSING.SDR IPXA2025081800008Hinge · deformedFOUND THE ENTRY DOOR DOORWAY ARMING LEVER HINGE ASSY WITH DEFORM DAMAGE.SDR 4USA2025081800547Hydraulic Line · chafedCREW REPORTED HYDRAULIC SYSTEM A LOW QUANTITY DURING FLIGHT FROM TEB TO PBI. CREW FOLLOWED CHECKLIST AND LANDED WITHOUT INCIDENT. UPON INSPECTION, FOUND 2 HYDRAULIC LINES ON THE A SIDE COMPARTMENT CHAFFING. FURTHER INSPECTION REVEALED A STANDOFF WHICH KEEP THESDR HNAA2025081800572Unknown · fumesWHILE ON APU BLEED, EXHAUST FUMES NOTED ON AIRCRAFT. CLEARED ON ENGINE BLEED. OPERATED PACKS ON APU BLEED IRT TO AMM TASK 21-20-00-700-801-A. NO EXHAUST SMELL NOTED. CLEAR MEL.SDR HNAA2025081800571Acm · odorBRIEFSMOKE/ODOR IN THE COCKPIT IN FLIGHT. F.A. REPORTED A "POP" NOISE NEAR ROW 12. AIR CONDITIONING PACKS. R&R LT ACM EXUAST DUCT ASSY AND GRATE ASSY IRW EMB AMM 21-51-03 OPS CHECK GD WITH NO DEFECTS NOTED CLEAR MEL 21-15-2SDR AALA202508183647Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN ANGLE LOCATED AT BS 285, S17R, RBL 64. REPLACED ANGLE PER AARD 51-00-05-1.SDR SCNA20250818323Filter · odorDEFECT 802437: VERY PUNDJENT MUSTY SMELL COMING THROUGH THE AIR VENTS ON DECENT AND ONLY ON DESENT RESOLUTION: REMOVED AND REPLACED LEFT & RIGHT RECIRCULATION HEPA FILTERS. REF. 21-25-01-400-801. REMOVED AND REPLACED EQIP COOLING FAN FILTER REF 27-21-01-400-80SDR CALA2025081807878Warning System · false indicationFA REPORTS EMERGENCY EXIT DOOR 2L INDICATES ARMED BUT LOCK INDICATION MISALIGNED ARMED, DISARMED AND REARMED DOOR 2L INSPECTED DOOR NO MISALIGNMENT SHOWN IN LOCK INDICATION. ECAM SHOWS DOOR CLOSED IAW AMM 05-28-30-200-007-ASDR CALA2025081807877Light · detachedMID LAV EMER LIGHT DETACHED. REINSTALLED MID LAV EMERGENCY LIGHT AND ALL OPS GOOD.SDR CALA2025081807876Light · no discrepancySEAT ROW 21ABC REQUIRE CABIN EMERGENCY LIGHT TEST REF AMM 33-51-11-400-001-A. ACCOMPLISHED CABIN EMERGENCY LIGHT TEST REF AMM 33-51-11-400-001-A NORMAL. 21 ABC SEAT POWER CONNECTED EEL OP CHECK GOOD.SDR CALA2025081807875Battery Pack · inoperativeEMERGENCY PATH LIGHTING FROM ROW 32 AFT INOP. CORRECT EPL DRAWING IS BR2013-P-757CO-5 REV F. PER THE BRUCE DRAWING ROWS 32-41 ARE POWERED BY BATTERY PACK / CHARGER M736 LOCATED ABOVE THE G4 AFT GALLEY AND RECEIVES POWER THROUGH PIN 13 OF D78. ALSO, REFERENCE WSDR CALA2025081807874Lamp · inoperativeLEFT SIDE EXTERIOR OVERWING (FORWARD POSITION) EMERGENCY LIGHT INOP RELAMPED REF WDM 33-00-01-1. OPS CHECK GOOD.SDR CALA2025081807865Outlet · odor5EF ELECTRICAL OUTLET INOP. PAX REPORT BURNING ODOR WHEN PLUGGED INTO OUTLET. PERFORMED OPS CHECK PER AMM 23-81-00 ; OPS CHECKED GOODSDR CALA2025081807864Pneumatic System · contaminatedFUMES OR SMOKE IN CABIN PNEUMATIC POWER SUPPLIED BY ENGINE ENGIN E 1 STRONG SMELL OF OIL IN COCKPIT NOT IN CABIN ON TAKEOFF. MASTER C AUTION FLASHED FOR 1 SECOND. SPOKE WITH CREW ON ARRIVAL AND THEY CONFIRMED SMELL WS PRESENT DURING TAKEOFF AND DISSIPATED QUICSDR CALA2025081807863Unknown · odorFLT ATTDNT CREW REST HAS SULFUR ODOR NEAR ENTRY DOOR. CONDITION AIR SUPPLIED WITH COOLING PACK IAW AMM 21-00-00-800-803 REV.104, INSPECTION PERFORMED AT AFT CABIN AREA AROUND FLT ATTEND CREW REST, NO SULFUR OR ELECTRIC ODOR AFTER HALF AN HOUR OF PACK OPS. FOSDR 7C7A2025081600038Access Panel · delaminatedRIGHT UPPER WING ACCESS PANEL 611KT FOUND DELAMINATED.SDR 7C7A2025081600037Hydraulic Line · gougedLEFT NACELLE REVERSE FLOW CHECK CONTROL LINE FOUND GOUGED.SDR 7C7A2025081600036Sign · inoperativeAFT GALLLEY RIGHT SIDE EMERGENCY EXIT SIGN INOPERATIVE, WON'T TURN ON.SDR 7C7A2025081600035Sign · inoperativeL3 DOOR EXIT IND SIGN INOPERATIVE.SDR 7C7A1900010000034Sign · no testR3 DOOR SLIDE LIGHT, O/H EXIT SIGN AND AISLE LIGHT SEATS 13DC, 15DC, 17DC, AND EXIT SIGN INOPERATIVE, NO TEST.SDR 7C7A2025081600033Skin · dentedRIGHT WING NR 6 SLAT TRAILING EDGE UPPER SKIN.SDR 7C7A2025081600032Skin · debondedRIGHT UPPER SURFACE SKIN PATCH DE-BONDED.SDR DALA2026031301754Blade · corrodedENGINE, INBD THRUST REVERSER, LOWER V BLADE SEGMENT HAS MULTIPLE SPOTS OF CORROSION. REMOVED AND REPLACED NO.1 ENGINE I/B T/R LOWER V BLADE SEGMENT PER GRAPW1500BA-A-78-30-00. (LP# 1145500)SDR SWI2025F01684Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM, BS 280, LBL 12, UNDER LT CAP ANGLE. REMOVED AND INSTALLED A NEW FLOORBEAM IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, SRM 51-42-22-001-001-A01 AND DWG CC670-34010, REV -K. COMPLETED SKYWEST TASK CARD 51-900-1002-SKSDR SWI2025F01683Stringer · corrodedSTRINGER 21L HAS CORROSION BETWEEN BS 349 AND 364. REMOVED AND INSTALLED NEW STRINGER 21L SECTION PN SH670-31382-1 FS 333- FS 364 REF CRJ900 SRM 51-42-06-001-001-A01 AND DWG SH670-31350 REV A. COMPLIED WITH SKYWEST SKYCARD 51-900-1002- SKY. NO LEAKS NOTED ,SDR SWI2025F01682Stringer Clip · corrodedCLIP COMMON TO STGR 20R AND FS 319.00 HAS CORROSION. REPLACED CORRODED CLIP COMMON TO STGR 20R AND FS 319 WITH NEW IAW SRM 51-42-06-001-001-A01 AND DWG SH670-31950 REV Y. COMPLIED WITH SKYCARD 51-900-1002-SKY.SDR SWI2025F01681Stringer · corrodedSTRINGER 22L HAS CORROSION BETWEEN BS333 AND 349. REPAIRED THE STRINGER IAW REO 690-53-21-2009, REV-. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025120208015Intercostal · corrodedCORROSION ON INTERCOSTALS AT STRINGER 21L BETWEEN BS 310 & 349. R & R INTERCOSTAL IAW SRM 51-42-06-001-001-A01,AND DWG SH670-31810, REV AE.SDR SWIA20251110815Drain Mast · scratchedAFT DRAIN MAST MATING SURFACE FOUND TO BE SCRATCHED AND SIGNS OF CORROSION (C-CHECK RO 11/07/2025)BLENDED CORROSION DAMAGE TO FUSELAGE SKIN BTW FS1031.00 -FS 1051.30 AND STR27-STR26R, FOUND TO BE WITHIN LIMITS IAW CRJ900 SRM 53-61-01, 51-12-00, MHIRJ REOSDR SCNA20251001391Angle · crackedCRACKED ANGLE ON INTERNAL FIXED LEADING EDGE WS 228 AT RT WING. ANGLE AT INTERNAL FIXED LEADING EDGE WS 228 AT RT WING WAS REPLACED IAW SRM 51-40-02-0G-0.SDR VNAA202509260018Crossbeam · corrodedCORROSION WAS FOUND ON LH CROSSBEAM AT FS 280.00. LH CROSSBEAM AT FS280.00 WAS EVALUATED OUT OF LIMITS PER CRJ700 SRM 53-00-01-101-001-A01 AND WAS REPLACED PER CRJ700 SRM 51-42-06-001-001-A01, SRM 51-42-10-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR VNAA202509260013Frame · corrodedAFTER DUCTS REMOVAL IN REF NRC 00236, CORROSION ON FRAME FS969 BTW STGR 26L TO 26R AT INTERNAL FUSELAGE. FRAME FS969 BTW STGR 26L TO 26R AT INTERNAL FUSELAGE. WAS REPLACED PER CRJ 700 SRM 51-42-06-001-001-A01 . AND SRM 51-42-21-001-001-A01.SDR VNAA202509260010Stringer · wornWEAR ON STGR 8 BTW FS1144 TO FS1162 AT AFT EQUIPMENT BAY. WEAR ON STGR 8 BTW FS1144 TO FS1162 AT AFT EQUIPMENT BAY WAS EVALUATED OUT OF LIMITS PER CRJ-700 SRM 53-61-03-101-004-A01 AND WAS REPAIRED PER CRJ-700 SRM 53-00-03-201-002-A01.SDR VNAA202509260007Hinge Fitting · wornNICKS ON LUGS OF AILERON HINGE 2 (INB/OUTB LUGS) AND HINGE 3 (INB LUG) AT LH WING REAR SPAR. DAMAGED LUGS OF AILERON HINGE 2 (INB/OUTB LUGS) AND HINGE 3 (INB LUG) AT LH WING REAR SPAR WERE REPAIRED PER REO 670-57-51-629 REV - -.SDR SWIA202509250815Shroud · chafedRH AILERON UPPER LEADING EDGE SHROUD IS CHAFED. (C-CHECK RO 09/24/2025)REMOVED AND EVALUATED DAMAGE ON RH AILERON UPPER LEADING EDGE FOUND TO BE OUT OF LIMITS, REF. CRJ-200, SRM 57-60-00-01, REMOVED AND REPLACED BY NEW RH AILERON UPPER LEADING EDGE, REF. DWG