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 CALA2025080807483Slide · not reportedDOOR L-2 SLIDE PACK ASSY REQ R & R. REMOVED AND REPLACED L-2 SLIDE PACK ASSY IAW AMM TASK 25-62-44-400-006-A. COMPLIED WITH RII STEPS FOR INSTALLATION OF L2 SLIDE PACK.SDR SCNA20250808310Flap System · faultedFLIGHT NUMBER 3080. DURING LAND FLAPS WERE STUCK AT 15 AND WOULD NOT RETRACT UP OR EXTEND RAN QRH PROCEDURE TRAILING EDGE FLAP DISAGREE. PERFORMED FIM 27-51 TASK 836, NO DEFECTS NOTED. OPS CHECK GOOD IAW FIM 27-51 TASK 836.SDR 2026FA0000095Filter · mismanufacturedPERFORMING TRANSMISSION OIL AND FILTER CHANGE, MECHANIC NOTED THAT NEW OIL FILTER WOULD NOT INSTALL ON THE FILTER BOSS. WENT THROUGH INVENTORY AND FOUND THAT A TOTAL OF 10 FILTERS FROM OUR STOCK WOULD NOT FIT ON THE FILTER BOSS.SDR SWIA2025080775185Landing · crackedSUSPECTED CRACK IN THE AFT A-BAY LANDING LATCH CUT OUT FOR PANEL 212AR. REMOVED AND REPLACED CRACKED LANDING LATCH CUT OUT FOR PANEL 212AR IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, DWG CC670-33040 REV -G, & REO 670-53-11-2178 REV-, COMPLIED WITSDR SWIA2026020475177Hinge · damagedPAX DOOR PIANO HINGE DOOR SIDE AFT LUG ROLL PIN HOLE IS ELONGATED. INSTALLED NEW PAX DOOR HINGE DOOR SIDE IAW SRM 52-11-01-201-002-A01 STEPS R AND T AND DWG 601R31702 REV. N AND SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. LEAK CHECK GOOD. COMPLIEDSDR SWI2025F01593Fan Cowl · damagedRT UPPER FAN COWL HAS A DAMAGED HOLE (C-CHECK RO 11/22/2025)EVALUATED. MEASURES OF DAMAGE: LENGTH: 0.570", WIDTH: 0.398", DEPTH #1: 0.032" , DEPTH#2: 0.029". NO ALLOWABLE DAMAGE REF CRJ700 SRM 54-14-00-101-001-A01. RECIEVED ENGINEERING INSTRUCTION AND PERFORMSDR SWIA202511240807Handle · damagedAFT CARGO DOOR HANDLE HOUSING HAS SEVERAL AREAS OF IMPACT DAMAGE FROM THE HANDLE (MARKED) (C-CHECK RO 11/22/2025)REMOVED AND INSTALLED NEW AFT CARGO DOOR HANDLE HOUSING REF CRJ700 SRM 51-42-21-001-001-A01 ,DWG#601R35027 REV-AY. LEAK AND OPERATIONAL TESTS GOSDR N6WA2025102301Fan · faultedDISPLAY FAN COOL CAUTION MSG IN FLIGHT. R/R DISPLAY FAN 1 IAW CRJ 550 AMM 21-24-12. OPS CHECK GOODSDR SWI2025F01440Floor Support · corrodedFLOOR BEAM CAP CORRODED FROM FS559+10 TO FS621 LBL27. (C-CHECK RO 10/19/2025)REMOVED AND INSTALLED NEW FABRICATED FLOOR BEAM CAP P/N 601R35031-267 IAW REO 601R-53-51-720 REV -- DATED 2025-08-25 AND TASK CARD 51-900-1003-SKY ATTACHED COMPLETED M-337 NO WEIGHTSDR SWI2025F01439Floor Support · corrodedFLOORBEAM CAP CORRODED FS559 TO FS621 RBL 27. (C-CHECK RO 10/19/2025)REMOVED AND REPLACED TWO FLOOR BEAMS CAPS ONE FROM FS 559+10 TO FS569 IAW MHIRJ REO 601R-53-51-719 REV -- DATED 2025-08-25 OTHER BEAM CAP FROM FS 569 TO FS 610 IAW MHIRJ REO 601R-53-61-837SDR SWI2025F01438Floor Support · corrodedL/H FLOOR SUPPORT CAP AT LBL 9 FROM FS 394 TO FS 409+128 IS CORRODED IN SEVERAL LOCATIONS. )REMOVED AND REPLACED LH FLOOR SUPPORT CAP AT LBL 9 FROM FS 394 TO FS 409+128 IAW CRJ 200 SRM 51-42-21, 51-42-22, AND 51-21-16, 51-42-34, 51-40-11, 51-24-36 AND 51-42-1SDR SWIA2025102000807Floor Support · corroded2 SCREW HOLES FROM FS 409+112 TO 409+128 HAVE CORROSION. (C-CHECK RO 10/19/2025)REPLACED LH FLOORSILL AT FS 409+112 - FS 409+128 IAW CRJ 200 SRM 51-42-06, 51-42-21 AND REO 601R-31-1347 REV -- DATED 2025-09-01. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED SDR AALA202510146811Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23R AT AFT GALLEY AREA, MEASURE OF CRACK IS L= 1.021 IN. MAINTENANCE REPLACED SHEAR SHEAR PLATE STR 23R BETWEEN FR69 AND FR70 AT AFT GALLEY AREA IAW A320 SRM 51-42-11-801, A320 SRM 51-72-11-911-001 AND DWG D5SDR AALA202509294444Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 42L BTW FR58 AND FR 59 IN AFT CARGO COMPARTMENT MEASURE CORROSION ARE L=6.823 INCH W=0.878 INCH D=0.025 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON STRINGER 42L BTW FR58 AND FR 59 IN AFT CARGO COMPARTMENT IASDR AALA202509290845Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 43L LOC BTW FR57 AND FR58 IN AFT CARGO COMPARTMENT L=5.748 INCH W=0.878 INCH D=0.023 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON STRINGER LOC ON STRG 43L BTW FR57 AND FR59 IN AFT CARGO COMPARTMENT IAW A320 SSDR VNAA202509260015Support Channel · damagedELONGATE HOLES ON LOWER CHANNEL FOUND AT RH RUDDER-PEDAL FRONT PIVOT SUPPORT STRUCTURE. LOWER CHANNEL AT RH RUDDER-PEDAL FRONT PIVOT SUPPORT STRUCTURE WAS REPAIRED PER REO 670-53-11-2175 REV.-SDR AALA202509262860Hinge Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON LH MLG DOOR HINGE FITTING . CRACK LEGHT 0.20 0 INCH. MAINTENANCE REPLACED DOOR HINGE FITTING LOCATED ON FR42 LH MLG IAW EA 367463 AND REPAIR DWG R53370500 ISSUE F, A319 SRM 51-42-11-801 AND SRM 51-72-11-9SDR VNAA202509250033Crossbeam · corrodedCORROSION ON CROSS BEAM ON FS1051.30 BTW LBL28 TO LBL39 AT BAGGAGE BAY FLOOR STRUCTURE. CROSS BEAM ON FS1051.30 BTW LBL28 TO LBL39 AT BAGGAGE BAY FLOOR STRUCTURE WAS REPAIRED PER REO 670-53-61-2549 REV -SDR VNAA202509250032Floor Support · corrodedCORROSION ON FLOOR BEAM BTW FS985.00 TO FS1088.20 AND LBL27 AT AFT BAGGAGE BAY FLOOR STRUCTURE. DUE TO NO DAMAGE IS ALLOWED ON FLOOR BEAM BTW FS 1008 TO FS 1080 AND LBL 27 AT AFT BAGGAGE BAY FLOOR STRUCTURE WAS REPLACED PER SRM 53-61-43-101-001-A01 AND SRM 5SDR VNAA202509250031Floor Support · corrodedCORROSION ON FLOOR BEAM BTW FS985.00 TO FS1088.20 AND LBL9 AT AFT BAGGAGE BAY FLOOR STRUCTURE. DUE TO NO DAMAGE IS ALLOWED ON FLOOR BEAM BTW FS 985.00 TO FS 1088.20 AND LBL 9 AT AFT BAGGAGE BAY FLOOR STRUCTURE WAS REPLACED PER CRJ700 SRM 53-61-43-101-001-A01SDR VNAA202509250030Frame · corrodedCORROSION ON FRAME BTW FS909 STGR 26R TO STGR 26L AT INTERNAL FUSELAGE. CORROSION ON FRAME BTW FS909 STGR 26R TO STGR 26L AT INTERNAL FUSELAGE WAS REMOVED PER CRJ-700 SRM 51-21-06-001-001-A01. AND AREA OUT LIMITS PER CRJ-700 SRM 53-00-00-101-001-A01 AND WAS SDR VNAA202509250029Frame · corrodedCORROSION ON FRAME BTW FS 879 STGR 26R TO STGR 26L AT INTERNAL FUSELAGE. CORROSION ON FRAME BTW FS 879 STGR 26R TO STGR 26L AT INTERNAL FUSELAGE WAS EVALUATE OUT OF LIMITS PER CRJ-700 SRM 53-51-06-101-003-A01 AND REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01 SDR VNAA202509250028Static Wick · corrodedCORROSION AT STATIC DICHARGER BASE, ACCESS PANEL 343BR. STATIC DICHARGER BASE ON ACCESS PANEL 343BR WAS REPLACED PER CRJ700 AMM 55-00-28-960-801 (CONFIG A01) AND SRM 51-42-06-001-001-A01SDR VNAA202509250027Frame · corrodedCORROSION ON FRAME BTW FS 863 STGR 26R TO STGR 26L AT INTERNAL FUSELAGE. FRAME BTW FS 863 STGR 21R TO STGR 21L AT INTERNAL FUSELAGE WAS EVALUATED OUT LIMITS PER CRJ-700 SRM 53-00-00-101-001-A01 AND FRAME WAS REPLACED PER CRJ/700 SRM 51-42-21-001-001-A01 AND SDR VNAA202509250026Floor Support · crackedCRACK ON FLOOR BEAM RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE (FLIGHT COMPARTMENT FLOOR STRUCTURE BELOW WL79.50). CRACK ON FLOOR BEAM RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE WAS REPAIRED PER 670-53-1SDR VNAA202509250025Floor Support · corrodedCORROSION ALONG EXTERNAL FACE OF FLOOR SILL BTW FS1000-FS1051.30 AT SURROUND STRUCTURE OF AFT BAGGAGE-BAY DOOR. DUE TO EXCESSIVE CORROSION MUST BE REPLACED PER CRJ 700 SRM 51-21-06-001-001-A01 AND SILL, LOWER BTW FS1000-FS1051.30 AT SURROUND STRUCTURE OF AFTSDR SWAA2025091199282Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY IAW B737-800 SRM 51-40-02; SRM 51-10-02 ITEM 9.SDR SWAA2025091099289Door · corrodedCORROSION ON EXTERNAL SKIN TOILET SERVICE DOOR 145AL AT LOWER FUSELAGE. EVALUATED REWORK AREA LOC. ON EXTERNAL SKIN TOILET SERVICE DOOR 145AL AT LOWER FUSELAGE AND FOUND WITHIN LIMITS IAW SRM 52-40-01-1A-4 ALLOWABLE DAMAGE 4 STEP 4. B ITEM (1) FIGURE 103 DETASDR SWAA2025091099281Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02; SRM 51-10-02 ITEM 9.SDR SWAA2025090899527Floorbeam · corrodedCORROSION ON BS 986 FLOORBEAM PREVIOUS REPAIR -1 STRAP AT NUTPLATE HOLE, LBL 43. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2025090899293Floor Panel · pulledAFT FLOOR PANEL 241YF HAS PULLED STRANDS ON UPPER SURFACE. AFT FLOOR PANEL 241YF UPPER SURFACE WAS REPAIRED IAW SRM 53-00-50-2R-1-A00939.SDR JJBA20250904004Support · corrodedRH SILL BTW FR 41-48 FOUND CORRODED. CF3, RH SILL BTW FR 41-48 IS OUT OF LIMIT. CF3, RH SILL BTW FR 41-48 REMOVED AND INSTALLED.SDR 2025FA0000622Display · failedAFTER DEPARTING GATE, ALL COCKPIT DISPLAYS DEFAULTED TO PFD1, 3 ATTEMPTS TO REBOOT WITH NO LUCK-CREW RETURNED TO GATESDR AALA202509028347Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y1292 FR 66 AT AFT GALLEY AREA, MEASURE OF CORROSION ARE: L= 1.613 INCH W= 1.060 INCH D= 0.040 INCH. MAINTENANCE REPLACED FLOOR BEAM Y1292 BETWEEN FR64 TO FR66 AFT GALLEY AREA LH SIDE IAW A320 SRM 51-72-11-91SDR AALA202509020656Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23L BTW FR69 AND FR70 AT AFT GALLEY AREA. CRACK L= 1.465 IN. MAINTENANCE REPLACED SHEAR PLATE LOC. ON STR 23L BTW FR69 AND FR70 AT AFT GALLEY AREA. IAW A320 SRM 51-42-11-801, SRM 51-72-11-911-001 AND DWG D53SDR AALA202509022440Spigot · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE ON LH PYLON, MEASURES ARE L= 6.310 IN; W= 0.780 IN; D= 0.003 IN. MAINTENANCE REPLACED SPIGOT FITTING RECEPTACLE ON LH PYLON IAW A319 SRM 54-51-12-300-001.SDR 2025FA0000603Servo · contaminatedMOMENTARY ENGINE ROUGHNESS/VIBRATION/LOSS OF POWER. PILOT SQUAWK: PARTIAL LOSS OF ENGINE POWER RIGHT AFTER TAKEOFF, 200-300 RPMS, CAME BACK AFTER A COUPLE SECONDS BUT DID NOT WANT TO CONTINUE FLIGHT. FUEL SERVO REPLACED.SDR 2025FA0000597Servo · contaminatedMOMENTARY ENGINE ROUGHNESS/VIBRATION/ LOSS OF POWER. PILOT REPORTED:"ON TAKEOFF OUT OF LVK AT 600 AGL THE ENGINE LOST TOTAL POWER FOR A MINIMUM OF ONE SECOND. AFTER THE LOSS OF POWER THE ENGINE IMMEDIATELY CAME BACK. I ENTERED THE TRAFFIC PATTERN AND DISCONTINSDR AALA202508279529Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING INBOARD MAIN FLAP OUTBOARD WEDGE DELAMED. REMOVAL AND INSTALLED LEFT HAND INBOARD FLAP WEDGE. PER N/R 615.SDR AALA202508269906Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING PASSENGER CREW DOOR BETWEEN FR16 AND FR20 AT LEVEL STR23R FWD GALLEY AREA MEASURE CORROSION ARE L=0.456 INCH W=0.388 INCH D=0.014 INCH.SDR SWIA2025082500007Skin · dentedHIDDEN DAMAGE FROM RA97165 - DENT FOUND UNDER FORWARD WING TO FUSELAGE FAIRING LOCATED BETWEEN FR29-30 AND STGR 27R-28R (C-CHECK RO 08/26/2025)REMOVED DENT BY CUTTING OUT DAMAGE AND INSTALLING DOUBLERS AT CFI EXTERNAL SKIN BETWEEN FRAMES 29-30, AND STRINGERSDR FDEA202508071530Seat Track · wornMAIN DECK FLOOR STRUCTURE WAS FOUND SEAT TRACK CROWN WORN AT FR28 PLUS 13"~FR28 PLUS 14", Y450. ACCOMPLISHED THE SEAT TRACK SPLICE REPAIR AT MAIN DECK FLOOR SEAT TRACK AT FR26~30,Y450 I.A.W A300-600F SRM 53-10-16-201 PARA.4 FIG201, PAGE203~208. THIS REPAIRSDR FDEA202508071529Seat Track · wornMAIN DECK FLOOR STRUCTURE WAS FOUND SEAT TRACK CROWN WORN AT FR28 PLUS 14", -Y953 ACCOMPLISHED THE SEAT TRACK SPLICE REPAIR AT MAIN DECK FLOOR SEAT TRACK AT FR26~32,- Y953 I.A.W A300-600F SRM 53-10-16-201 PARA.4 FIG201, PAGE203~208. THIS REPAIR IS CLASSIFIED SDR R61A2025082500368Skin · crackedDURING HEAVY CHECK FOUND SUSPECTED CRACK FOUND ON R/H WING UPPER SKIN TRAILING EDGE ON SPOILER #3 MOST I/B HINGE CUTOUT. REPAIRED CRACK IAW ETD 2025-170-9266007 REV. BSDR JJBA20250825054Shear Tie · crackedFR30 BTW STR15-16 SHEAR CLIP CRACKED FR30 BTW STR15-16 SHEAR CLIP REMOVED, FR30 BTW STR15-16 SHEAR CLIP REPLACEDSDR ASAA2025080760271Angle · crackedBAFFLE CLIP CRACKED AT 500H RT FWD SIDE. GROUNDED - YES. REMOVED AND REPLACED BAFFLE CLIP AT 500H RT FWD SIDE IAW SRM 51-40-02-0G-0.SDR REXA2025082200829Lug · damaged"FOUND R/H AILERON SIDE BUSHING LUGS LABELED ""C"" AND ""F"" TO BE PREVIOUSLY OVERSIZED. REAMED R/H AILERON BUSHING LUG LABELED ""F"" TO 2ND OVERSIZE LUG DIAMETER (0.7818"") AND REAMED LUG LABELED ""C"" TO 4TH OVERSIZE DIAMETER (0.8130"") IAW REO 670-57-61-237SDR JJBA20250820046Frame · dentedCF4 ON LT FUSE ON FR 59 BTW STR 2L-3L DENT FOUND AT FLANGE. SPLICE REPAIR ON CENTER FUSE IV FRAME 59 BTW STR 1L-2LSDR AALA202508181746Support Frame · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #4 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31-400-001-A.SDR AALA202508185289Support Frame · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #5 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31-400-001-A.