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 DALA2025070805171Warning Message · false activationSHIP 1807 RECIEVED MASTER WARNING WITH TAKEOFF CONFIGURATION WARNING. SAW FLAPS EICAS BUT FLAPS WERE SECURED AT 15 DETENT. CORRECTIVE ACTION: R/R FSPM M839 REF. B767/400 AMM 27-58. (6704694).SDR 2025FA0000459Skin · corrodedCORROSION WAS FOUND ON THE LOWER FUSELAGE SKIN NEAR FS 779 NEAR STR 22L & 23L, NOMINAL THICKNESS 0.060 IN, MINIMUM 0.035 IN. MATERIAL TYPE 2024-T42 PER AMS-QQ-A-250''5.SDR DALA2025070805116Clamp · detachedLOG (7328864) SHIP 3831 -PRESS/DE- DECLARED EMERGENCY DUE TO LOSS OF RIGHT BLEED ON CLIMB FOLLOWED BY PRESSURIZATION ISSUES. DESCENDED TO 19K AND CONTINUED TO DESTINATION. FOUND LEFT PACK DUCT CLAMP BETWEEN ACM AND REHEATER OFF. RESECURED SAME. RIGHT ENGINE BSDR DALA2025070805101Sidewall Panel · damagedSHIP 663 IN REF TO: NRC 00052: AFTER REMOVAL HIDDEN DAMAGE ON SIDEWALL PANELS, WAS FOUND, DENT ON PREVIOUS REPAIR OF FRAME 1300 BTW STGRS 25R AND 26R IN AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00151: DENT ON PREVIOUS REPAIR OF FRAME 1300 BTW SSDR DALA2025070805100Wedge · debondedSHIP 651 DISBOND OF 4.500 IN X 1.500 IN WAS FOUND ON LE SLAT 4 TRAILING EDGE WEDGE, LOWER SKIN OSS 329.5 AT LH WING. CORRECTIVE ACTION: SUMMARY OF NRC 00013: LE SLAT 4 TRAILING EDGE WEDGE, LOWER SKIN OSS 329.5 AT LH WING WAS REPAIRED PER B757-200 S.R.M 51-70-1SDR ABXA20250708143Warning Message · illuminatedPER MXC REQUEST VERIFY LOCK POSITION IN MCD , A/C RETURNED TO THE GATE AND GROUNDED BY MTX, MTX THEN VERIFIED LOCK RBL:33, LBL:33 +LBL:11 PREVIOUSLY INSTALLED IN STA.756.45, RELOCATED TO STA.755.45 IAW BCF CMM 25-51-70. ALL LOCKS SECURED. AND RETURNED A/C TO SSDR IPXA2025070814759Weu · faulted**ATB** FIRE BELL SOUNDED ON ROTATION NO MASTER WARNING LIGHTS OR ANY OTHER FIRE INDICATIONS RTB AS A PRECAUTION. R&R BELL CHIME WARNING CARD PER 31-51-04. OPS CHECK GOODSDR 2025FA0000458Alternator · inoperativeALTERNATOR FAILED IN FLIGHT CAUSING AN UNSCHEDULED LANDING AT HERITAGE AVIATION IN BURLINGTON, VT. ALTERNATOR WAS A FAIRLY NEW INSTALLATION ACCORDING TO CUSTOMER.SDR DALA2025070805081Engine · leakingSHIP 8131 RETURNED TO SEA DUE TO DIRTY SOCK SMELL IN COCKPIT AND CABIN. CORRECTIVE ACTION: C/W W/C 0550-2001 & DETERMINED SOURCE TO BE #1 ENGINE. C/W W/C 0550-6001 AND W/C 0550-2003. FOUND NO EVIDENCE OF OIL CONTAMINATION. BOTH RECIRCULATION FILTERS REPLACED. SDR AALA202507083777Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR AALA202507083516Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR AALA202507081837Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR AALA202507082564Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR AALA202507085095Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR AALA202507085610Bolt · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE FITTING BOLT WORN. REPLACED BOLT PER AMM 55-16-42.SDR 2025FA0000457Piston · crackedHIGH OIL CONSUMPTION REPORTED. BORESCOPE INSPECTION REVEALED PISTON DAMAGE. CYLINDER REMOVED AND FOUND PISTON CRACKED AND SEPARATED IN HALF. INSPECTION OF ENGINE INTERIOR REVEALED SUSPICIOUS PISTON ON OPPOSING CYLINDER. REMOVED CYLINDER AND FOUND CRACK FORMINGSDR AALA202507089544Power Supply · faultedAIRCRAFT WAS GROUNDED: ROW 26ABC SEAT MOUNTED EMERGENCY LIGHT IS INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT (11WL) IAW AMM 33-51-38.SDR AALA202507086244Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR EMERGENCY ASSIST ACCUMULATOR REQUIRES SERVICING. MAINTENANCE SERVICED EMERGENCY DOOR ACCUMULATOR IAW AMM 52-10-00.SDR AALA202507089505Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY ASSIST ACCUMULATOR REQUIRES SERVICING. MAINTENANCE SERVICED EMERGENCY DOOR ACCUMULATOR IAW AMM 52-10-00.SDR 2025FA0000456Skin · crackedFIXED COWL SKIN HAS TWO SECTIONS OF TORN AND CURLED SKIN AROUND FRONT MOUNT BEAM.SDR KCSA202507081109Frame · gougedR/H ELEVATOR STA 231 HAS GOUGE ON THE COUNTER BALANCE FRAMESDR FDEA202507081140Trunnion · crackedNOSE LANDING GEAR RIGHT TRUNNION FITTING AREA AT BS 583 FOUND CRACKED. CRACK AT NOSE LANDING GEAR RT TRUNNION FITTING AREA BS 583 REPAIRED IAW EA 1-5310-T0384071. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA202507081139Seat Track · wornCABIN-SEAT TRACK AT STATION 879 X = -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 879, 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 FDEA202507081138Seat Track · wornCABIN-SEAT TRACK AT STATION 840 X = -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 840, 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 FDEA202507081137Seat Track · wornCABIN-SEAT TRACK AT STATION 810 X = 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 810, 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 TRSDR FDEA202507081136Seat Track · wornCABIN-SEAT TRACK AT STATION 999 X = 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, 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 SDR FDEA202507081135Seat Track · wornCABIN-SEAT TRACK AT STATION 6-10 X = 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-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 REPAIRED BY SECTIONAL SEASDR FDEA202507081134Seat Track · wornCABIN-SEAT TRACK AT STATION 6-10 X = 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-10, 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 FDEA202507081133Seat Track · wornCABIN-SEAT TRACK AT STATION 6-10 X = -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-10, 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 SSDR FDEA202507081132Seat Track · wornCABIN-SEAT TRACK AT STATION 6-10 X = -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-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 REPAIRED BY SECTIONAL SEASDR 2025FA0000455Blade · departedFAA DISCOVERED CONDITION DURING ACCIDENT INVESTIGATION. PIC REPORTED IN-FLIGHT PROPELLER BLADE SEPARATION DURING CRUISE FLIGHT CAUSING VIOLENT BUFFETING AND VIBRATION; RESULTING IN POWER LOSS AND ENGINE STOPPAGE. PILOT EXECUTED AN OFF-FIELD LANDING WHICH CASDR DALA2026040102131None · noneAIRCRAFT 5053, REMOVED RIGHT ELEVATOR FOR HORIZONTAL STAB, WHILE IN STORAGE AT VCV THE HORIZONTAL STABILIZER WAS REMOVED FROM AC 5053 AND INSTALLED ON ANOTHER AIRCRAFT. PN D5518000200000 WHICH WAS REMOVED FROM A/C 5053 IS CURRENTLY OUT OF PRODUCTION, SO PN D55SDR DALA2026040102130None · noneREMOVED LEFT ELEVATOR FOR HORIZONTAL STAB REMOVAL, WHILE IN STORAGE AT VCV THE HORIZONTAL STABILIZER WAS REMOVED FROM ACFT AND INSTALLED ON ANOTHER AIRCRAFT. WHICH WAS REMOVED FROM A/C 5053 IS CURRENTLY OUT OF PRODUCTION, SO PN D5518000800052 HTP ASSY-EQUIPPEDSDR REXA2025100200899Drag Angle · crackedR/H AFT DRAG ANGLE IS CRACKED. REMOVED UNSERVICEABLE RH AFT DRAG ANGLE P/N:AV670-21186-004. IAW CRJ900 SRM 51-42-13-001-001-A01,SRM 51-42-21-001-001-A01 AND SRM 51-42-22-001-001-A01. LOCATED AND DRILLED NEW SERVICEABLE RH AFT DRAG ANGLE PN# AV670-21186-004 ISDR SCNA20250930389Fairing · crackedCRACK SUPPORT OF SETTLEMENT AREA OF PANEL 191AR AT BODY-FAIRING. - RESOLUTION: EMP 283816 - SUPPORT OF SETTLEMENT AREA OF PANEL 191AR AT BODY-FAIRING WAS REPLACED PER B737-800 SRM 51-40-02-0G-0SDR NACA2025070700005Shutoff Valve · no testFOUND RH ENGINE PRSOV HEALTH CHECK FAIL. REMOVED AND REPLACED #2 ENGINE PRSOV AND CARRIED OUT TEST AS PER 767-300 AMM 36-11-09SDR NACA2025070700004Sleeve · leakingRH HEAT EXCHANGER SLEEVE FOUND AIR LEAKAGE. REMOVED AND REPLACED RH AFT AIR CONDITIONER SURFACE BODY CROSS OVER DUCT SLEEVE SEAL AS PER AMM 36-11-00SDR GRTA20250910001Stiffener · crackedWHILE PERFORMING THE AFT PRESSURE BULKHEAD INSPECTION FOUND A CRACK AT THE # 5 ZEE STIFFENER FROM THE TOP OF THE BULHEAD ON THE FWD SIDE OF THE BULKHEAD THE CRACK STARTS 2.1 INCHES FROM THE OUTBD R/H SIDE AND RUNS HORIZONTALY 21 INCHES JUST UNDER THE RIVET LISDR REXA2025082500830Stringer · corrodedSTGR 23L IS CORRODED AT FS 581 TO FS 597 (MARKED WITH RED TAPE) REPAIRED STR 23L IAW ENDEAVOR AIR EA CRJ753-19988 REV IR DATED 8-14-25SDR SIMA20250707001Glowstrip · inoperativeNUMBER 1 & 3 RT GLOWSTRIP WILL NOT GLOW.: REPLACED THE NR 3 RT GLOWSTRIP IAW AMM 33-50-21.SDR 3EJA8202508150001Shutoff Valve · failedON TAKEOFF RUNWAY 14L, REACHED TAKEOFF POWER DETENT, FELT A SMALL LURCH OF IN RUDDER PEDALS. MASTER CAUTION ILLUMINATED. REMOVED AND REPLACED RUDDER BIAS SHUT OFF VALVESDR SWAA2025081289061Skin · pulledL/H ENGINE INLET COWL BARREL SKIN HAS A PULLED THROUGH FASTENER AT 10:00 O'CLOCK POSITION.NR 1 ENGINE INLET COWL WAS REMOVED AND REPLACED ON CARD 7111-E-17062-NG. FAULT WAS ATTACHED TO R/O AND WILL BE CORRECTED WHEN INLET COWL GETS MODIFIED.SDR HNAA2025081200565Shear Tie · crackedF057576 CABIN SHEAR CLIP IS CRACKED AT FR-61 BETWEEN STR 6L/7L. REMOVED AND REPLACED CABIN SHEAR CLIP AT FR-61 BETWEEN STR 6L/7L IAW EMB145 SRM 51-40-02.SDR HNAA2025081200564Shear Tie · crackedF057577 CABIN SHEAR CLIP IS CRACKED AT FR-61 BETWEEN STR 6R/7R. REMOVED AND REPLACED CABIN SHEAR CLIP AT FR-61 BETWEEN STR 6R/7R IAW EMB145 SRM 51-40-02.SDR HNAA2025081200548Seat Track · corrodedLH UPPER SEAT TRACK #5 IS GOUGED AND CORRODED IN NUMEROUS AREAS ALONG ENTIRE LENGTH ON INSIDE AND OUTSIDE OF TRACK. RAR LH UPPER SEAT TRACK #5 IAW EMB 145 AMM 53-01-06SDR SWAA2025081188945Seat Track · crackedCAPTAIN'S SEAT TRACK'S WORN; CRACKED & CORRODED<[01] REMOVED AND REPLACED CAPTAIN'S SEAT TRACK'S PER AMM 25-11-11-400-801<BR>CAL:DATE:03/2025<BR>DUE:03/2026<BR>ID:ATS2842;[02] VERIFIED CORRECTIVE ACTION #1SDR SWAA2025081188944Seat Track · crackedF/O'S SEAT TRACK'S WORN; CRACKED & CORRODED<[01] REOMVED AND REPLACED F/O'S SEAT TRACK'S PER AMM 25-11-11-400-801<BR>CAL:DATE:08/2024<BR>DUE:08/2025<BR>ID:ATS2328.;[02] COMPLETE.;[03] UPDATED MEASUREMENTS TABLE.SDR JJBA20250806009Nut · corrodedRH SILL BTW FR 60-61 FOUND CORRODED. CORRODED ANCHOR NUT REMOVED ON RH SILL BTW FR 60-61. CORRODED RH SILL BTW FR 60-61 FOUND OUT OF LIMITS. CORRODED RH SILL BTW FR 60-61 REMOVED AND REPLACED.SDR IPXA2025080607418Floor Support · brokenMDC FLOOR STRUCTURE REINFORCEMENT SUPPORT CRACKED BTWN FR 38 AND FR 38.1 AT -Y2127.5. INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-21 WITH FASTENERS AND SEALANT.SDR REXA2025080600784Angle · damagedPAX DOOR AFT SUPPORT ANGLE FOUND EXTRA HOLE FROM PREVIOUS REPAIR REQUIRE REPLACEMENT LOCATED AND DRILLED NEW SERVICEABLE PAX DOOR AFT SUPPORT ANGLE P/N#601R318732-3 IAW CRJ-700 SRM TASK 51-40-11-001-001-A01. REFERENCE HN00249365 FOR INSTALLATION