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 2026FA0000031Doubler · corrodedDURING INSTALLATION OF DOUBLER PER DWG 371-53-11-C3164, CORROSION WAS DETECTED ON THE OUTER FLANGE OF FRAME BS 390 BETWEEN STR 19R AND 20R.SDR SWIA2026011776629Hinge · gougedPAX DOOR PIANO HINGE HAS MULTIPLE LUGS WITH GOUGES DOWN ENTIRE LENGTH FUSELAGE SIDE. BLENDED AND REMOVED DAMAGE ON PAX DOOR HINGE LUGS IAW REO 670-53-21-582, REV -F, SRM 51-21-11, 51-25-06, 51-25-16, & AMM 52-11-00.SDR REXA2026052700706Packer · corrodedAFTER FWD WASTE LAVATORY SERVICE PANEL DOOR REMOVAL, CORROSION ON PACKERS (2EAS) WERE FOUND PACKERS (2EAS) WERE REPLACED ON FWD WASTE LAVATORY SERVICE PANEL DOOR PER CRJ900 SRM 51-10-06-001-001-A01 AND INSTALLED WITH NRC 00030.SDR REXA2026052700705Hinge · corrodedSECONDARY NRC FROM RC 900-32-710-902Ï¿½: AFTER HARDWARE REMOVAL, CORROSION ON LH/RH FITTING, NLG W/W AREA WAS FOUND LH/RH FITTING, NLG W/W WERE REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR VNAA20260511009Door Frame · corrodedCOCKPIT DOOR POST IS CORRODED AT LBL 11 W.L.72.5. REPAIRED LBL 11 COCKPIT DOOR POST IAW BOMBARDIER GREO 670-53-11-745 REV -A DATED 2016-10-28.SDR VNAA20260508015Fitting · gougedRIGHT AILERON HINGE FITTING NO. 3 (WING SIDE) IS GOUGED ON THE LOWER SIDE. REPAIRED RH AILERON HINGE FITTING#3 AT WS323.058 IAW MHIRJ REO 670-57-51-677 REV -.SDR VNAA20260508013Fitting · crackedLEFT FLAP HINGE BOX AFT MOUNTING FITTING AT WS 54.55 (WING SIDE) HAS GOUGES ON THE I/B LUG. REPAIRED INBD FLAP HINGE BOX ATTACHMENT, AFT HINGE FITTING AT WS54.55 LHS IAW MHIRJ REO 670-57-21-1101 REV -- DATED 2026-01-07.SDR SWIA2026011775820Hinge Fitting · gougedRIGHT WING FWD HINGE BOX FITTING AT WS127.25 GOUGED. REPAIRED RT WING FWD HINGE BOX FITTING AT WS127 PER REO 601R-57-21-4040 REV -. COMPLETED SKYWEST TASK CARD 51-900-1003-SKY.SDR AALA202604086109Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 L BTW FR69 AND FR70 AT AFT GALLEY AREA. LENGTH OF CRACK IS IS: 1.00 IN. MAINTENANCE REPLACED SHEAR PLATE LOCATED ON STR 23 LH BTW FR 69 TO FR 70 AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801, A319 SRM 51-7SDR SWIA2026011775651Skin · corrodedUPON REMOVAL OF AFT DRAIN MAST, FOUND CORROSION ON EXTERNAL SKIN BETWEEN BS 1031 - BS 1047 AND STR 27 - STR 26R. COMPLIED WITH REO 670-53-61-2664 REV -.SDR AALA202603314736Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23R BTW FR 69 TO FR 70 AT AFT GALLEY AREA. L: 1.05 INCH. MAINTENANCE REPLACED SHEAR PLATE LOCATED ON STR 23 BTW FR69 TO FR70 AT AFT GALLEY AREA I.A.W. SRM 51-42-11-801, SRM 51-72-11-911-001 AND DWG D534741SDR REXA2026030900205Seal · crackedBROKEN SEAL NEXT TO ACCESS PANEL 591JB UPPER, LH WING BROKEN SEAL NEXT TO ACCESS PANEL 591JB UPPER, LH WING WAS REPLACED PER CRJ 900 SRM 51-42-10-001-001-A07SDR VNAA20260303016Rib · crackedCRACKED MACHINED WING RIB, LEADING EDGE SS58.41, RT WING. THE RIB WAS REPAIRED IAW REO 690-57-41-240, REV -.SDR VNAA20260303011Seat Track · corrodedTWO CORRODED SEAT TRACK SECTIONS, LBL 9, BS 581 - 677 IN THE PAX CABIN. THE SEAT TRACK SECTIONS WERE EVALUATED OUT OF LIMITS IAW SRM 53-31-49-101-001-A02, AND WERE REPLACED IAW SRM 53-00-49, CONFIG. A12.SDR VNAA20260303010Seat Track · corrodedCORRODED TWO SEAT TRACK SECTIONS , BS 364 - 485, & BS 581 - 677, RBL 9 IN THE PAX CABIN. THE SEAT TRACKS WERE EVALUATED AND FOUND OUT OF LIMITS IAW SRM 53-21-49-101-001-A01, SRM 53-31-49-101-001-A02, AND SRM 53-41-49-101-001-A02, REPLACED IAW AMM 53-00-49.SDR VNAA20260303009Fitting · corrodedCORROSION ON FOUR MACHINED FITTINGS IN THE FWD, CTR CARGO BAY. THE FOUR MACHINED FITTINGS WERE EVALUATED TO EXCESSIVE CORROSION IAW SRM 51-10-06-001-001-A01 AND REPLACED IAW SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-A01, AND SRM 51-42-10-001-001-A01.SDR VNAA20260303005Hinge · corrodedCORROSION ON THE HINGE OF ACCESS PANEL 832ET OF PASSENGER DOOR. THE HINGE WAS REPLACED ON STEP PANEL 832ET IAW SRM 51-41-02-001-001-A01.SDR SWIA2026022575326Spigot · corrodedPOSSIBLE SIGNS OF CORROSION FOUND AROUND THE BOLT HOLES OF THE PAX DOOR AFT SPIGOT ASSEMBLY. (C-CHECK RO 02/22/2026)COMPLIED WITH REO 670-53-21-2786 REV "--" DATED 2026-01-23 REPAIR FOR CORROSION DAMAGE TO PAX DOOR UPPER LINTEL BETWEEN FS333.00-FS343.13 AT STSDR AALA202602238901Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR SWAA2026021862377Support · corrodedCORRODED SUPPORT ZEE, BS 500C - 500I, LBL 22, WL 156. PERFORMED A PERMANENT REPAIR ON THE SUPPORT ZEE IAW SRM 53-00-53-2R-5, REPAIR 5, & EA M-22-153-01550.SDR SWAA2026021862335Plate · crackedCRACKED SEAL PLATE ACCESS PANEL 431AT ON LT PYLON (1 EA). MEASUREMENT OF CRACK: L: 0.988 INCH. REPLACED THE SEAL PLATE ON ACCESS PANEL 431AT LT PYLON IAW SRM 51-40-02, AND SRM 51-10-02, STEP 9, NO ADDITIONAL DAMAGE.SDR SWAA2026021862336Access Panel · crackedCRACK BLADE ACCESS PANEL 333AT AT LT HORIZONTAL STAB. REPLACED BLADE ACCESS PANEL 333AT AT LT HORIZONTAL STAB IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02. EASUREMENT OF CRACKS: L:0.295 INCHES.SDR SWAA2026021762196Lens · brokenOVERHEAD STOWAGE BIN EMERGENCY EXIT LIGHT LENS BROKEN, RT SIDE IN PASSENGER CABIN (8 EA). REPLACED THE EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-03-960-801, STEP 2.D,(3)(A)(C).SDR SWAA2026021762204Light · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (10 EA). REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHT IAW AMM 33-51-15-400-802.SDR SWAA2026021762205Lens · brokenOVERHEAD STOWAGE BIN EMERGENCY LIGHT LENS BROKEN, LT SIDE AT PASSENGER CABIN (9 EA). REPLACED THE EMERGENCY LIGHT LENS IAW AMM 33-51-03-960-801, STEP 2.D.(3)(A)(C).SDR IXXA20260217008Door · dentedDENT NOTED AT I/B EDGE OF APU COMPARTMENT DOOR 315R 3.5 INCH FROM DOOR L/E. WO 014380 NRC 412SDR IXXA20260217006Access Door · dentedDENT NOTED AT I/B EDGE OF APU COMPARTMENT DOOR 315L 12.5 INCH FROM DOOR L/E. XTREME AVIATION WO 014380 NRC 408SDR IXXA20260217004Door · dentedDENT NOTED AT I/B EDGE OF APU COMPARTMENT DOOR 11 INCH FROM DOOR L/E. XTREME AVIATION WO 014380 NRC 409SDR IXXA20260217002Door · dentedDENT NOTED AT INBD EDGE OF APU COMPARTMENT DOOR 315R 28" AFT OF DOOR L/E. WO 014380 NRC 405SDR AALA202602168564Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON FRAME AT FR 68 LEFT-HAND SIDE DOOR STOP 1 LOWER INBOARD HOLE. REPAIRED FRAME PER SRM 53-41-12-300-011SDR HNAA2026021600134Shear Tie · crackedSHEAR TIE AT FR 58 BETWEEN S15 -16L CRACKED. R & R SHEAR TIE IAW SRM 51-40-02.SDR HNAA2026021600127Floor Support · corrodedCORROSION ON RT OTBD NR 3 FLOOR SILL. REMOVED AND REPLACED RT OTBD NR 3 FLOOR SILL IAW SRM 51-40-02.SDR HNAA2026021600126Floor Support · corrodedCORROSION ON LT OTBD NR 2 FLOOR SILL. R & R LT OTBD NR 2 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2026021600125Floor Support · corrodedCORROSION ON RT OTBD NR 2 FLOOR SILL. R & R RT NR 2 FLOOR SILL IAW SRM 51-40-02.SDR SWIA2026021375240Rib · crackedSUSPECTED CRACK RT HORIZONTAL RIB 11A FORWARD UPPER FLANGE AT AFT RIVET HOLE. REMOVED AND RELACED THE RT HORIZONTAL RIB 11A ON THE RT HORIZONTAL. IAW SRM 51-40-08. PERFORMED.TASK CARD 27-31-05-001-SKY-U,SDR SWIA2026021375239Skin · crackedHFEC CONFIRMED CRACK RT LOWER SKIN JUST FORWARD OF RT LANDING GEAR WHEEL WELL CUT OUT AT RIB 3. PERFORMED CRACK REPAIR AT RIB 3 JUST FORWARD OF LANDING GEAR CUTOUT ON RIGHT WING LOWER SKIN IAW ETD2026-170-001158. REPAIR PARTS WEIGHED LESS THAN 2.5 LBS, NO WEISDR AALA202602139020Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT BS 947, RBL 26. REPAIRED UPPER TEE IAW SRM 53-70-51-2R-5.SDR SWAA2026021362382Angle · crackedCRACKED ANGLE BRACKET, BTW BS 540 - 560, LBL 7. REPLACED THE ANGLE BRACKET IAW SRM 51-10-02-0G, ITEM 9, AND DWG 212A1116, SHEET 1, REV - . MEASUREMENT OF CRACK: L: 0.782 INCH.SDR SWAA2026021362388Nut Plate · crackedCRACKED RAIL NUT PLATES, INTERNAL CAVITY LEADING EDGE LOCATED OFSS 577, LT WING. REPLACED RAIL NUT PLATES AND FASTENERS IAW SRM 51-40-02, AND DWG 112A4402, SHEET 14, REV -. MEASUREMENT OF CRACK: 0.438 INCH.SDR SWAA2026021362387Nut Plate · crackedCRACK RAIL NUT PLATES INTERNAL CAVITY LEADING EDGE LOCATED OFSS 734, RT WING. REPLACED THE RAIL NUT PLATES AND FASTENERS IAW SRM 51-40-02-0G-0, AND DWG 112A4402, SHEET 14, REV-.SDR CALA2026021313750Web · corrodedFOUND EXCESSIVE CORROSION ON THE AFT CARGO MAIN SILL WEB, BTW BS 794 & 847. REMOVED, LOCATED, DRILLED, COUNTERSINK, APPLIED ALODINE, PRIMER, INSTALLED NUTPLATES, & INSTALLED A NEW MAIN SILL WEB IAW SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, AMM 51-21-41-370-802, 5SDR SWAA2026021262182Rib · crackedCRACK ON THE INBD SIDE, LOWER CHORD INSPAR RIB HSS 120.30 IN THE RT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON THE RIB IAW SRM 55-10-09-2R-5, REPAIR 5, FIGURE 205.SDR SWAA2026021262386Nut Plate · crackedCRACKED RAIL NUT PLATES, INTERNAL CAVITY OF THE LEADING EDGE, OFSS449, LT WING. REPLACED THE NUT PLATES & FASTENERS IAW SRM 51-40-02, & DWG 112A4402, SHEET 40, REV A.SDR SWAA2026021262383Bracket · crackedCRACKED BRACKET, BTWN BS 540 - 560, RBL 7. REPLACED THE BRACKET IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 212A1116, SHEET 1, REV -.SDR SWAA2026021262385Angle · crackedCRACKED ANGLE, BS 663, RBL 8 IN THE AIR CONDITIONING BAY. REPLACED THE REPAIR ANGLE, BS 663, RBL 5 - RBL 30 IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, SRM 57-10-10-2R-5, REPAIR 5, DWG 111A10000, SHEET: 202, REV -, & MPM 52.1.1.1.SDR SWAA2026021262340Web · corrodedCORROSION WEB INTERNAL CAVITY LEADING EDGE LOCATED OFSS276, RT WING. PERFORMED PERMANENT REPAIR ON WEB IN THE INTERNAL CAVITY LEADING EDGE IAW SRM 51-70-11-2R-0, REPAIR GENERAL, PARAGRAPH 4.SDR JJBA20260211006Shear Tie · corrodedFRAME 54, STR 20 - 21R SHEAR TIE HAS SURFACE CORROSION. INSTALLED NEW SHEAR TIE.SDR AALA202602094109Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT BS 947, LBL 52. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202602090629Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BULK CARGO COMPARTMENT SHEAR CLIP AT FR 65 BETWEEN S44 AND S43R. REPLACED SHEAR CLIP PER SRM 51-42-11.SDR SWAA2026020562430Threshold Web · corrodedCORROSION ON AFT CARGO BAY SUB WEB THRESHOLD AT BS 794 - 847, RBL 25, WL 155. REMOVED AND REPLACED AFT CARGO BAY SUB-THRESHOLD WEB IAW SRM 51-40-02, AND DWG 146A8120, REV A.