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 AALA202508152259Damper Plate · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT PASSENGER / CREW DOOR 832 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE BELOW LIMITS. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-001-A.SDR AALA202508156338Damper Plate · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT PASSENGER / CREW DOOR 842 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE BELOW LIMITS. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-001-A.SDR DXTA2025081504613Fuel Sys · out of balanceTHE FUEL QUANTITY INDICATED ON RIGHT GAUGE WAS SHOWING A COUPLE THOUSAND POUNDS MORE THAN IT ACTUALLY HAD. THE RESULT WAS INACCURATE FUEL TRANSFERRING LEADING TO FUEL IMBALANCE. THIS HAPPENED FOR 2 HOURS AND THEN RETURNED BACK TO NORMAL INDICATIONS. TROUBLESDR DXTA2025081504615Battery · inoperativeDURING PRE FLIGHT FOUND NUMEROUS EMERGENCY LIGHTS OUT. TRIED CHARGING BATTERY PACK TWICE FOR THIRTY MINUTES EACH TIME WITH NO SUCCESS. NR 2 BATTERY PACK ON THE EMERGENCY LIGHTNING SYSTEM IS NOT HOLDING A CHARGE. EXTERIOR EMERGENCY LIGHTS ARE CONSIDERED INOPERASDR DXTA2025081504618Transducer · out of adjustAIRCRAFT PULLS TO THE LEFT WHILE TAXING. CONSTANT RIGHT TILLER OR RUDDER IS REQUIRED. AIRCRAFT PULLS HARDER TO THE LEFT WHEN MODERATE BRAKING IS APPLIED. PERFORMED RIGGING CHECK OF ROTARY VARIABLE TRANSDUCER & FOUND RVT OUT OF LIMITS, PERFORMED RIGGING OFSDR IPXA2025081500252Support Angle · cracked-CRACK-CLIP, NO.1 ENG IDG/OIL COOLER SENING TUBE SUPPORT CLIP OK TO WORKSDR IPXA202508154241Pawl · wornTHE PAWL BEHIND THE CREW ENTRY DOOR HANDLE HAS WEAR DAMAGE OK TO WORKSDR 7C7A2025081500031Fairing · damagedEVIDENCE OF DAMAGE AT EDGE OF CANOE PANEL 672HB.SDR LR7A2025081503777Bulkhead Web · crackedDURING SCHEDULED A-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND FS93 LOWER BULKHEAD WEB CRACKED . / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-17. NR# 0043.SDR LR7A2025081503776Bulkhead Web · crackedDURING SCHEDULED A-1 CHECK UNDER JOB CARD HA1201, FOUND FS880 BULKHEAD WEB CRACKED . / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-17. NR# 3766.SDR LR7A2025081503775Bulkhead Web · crackedDURING ULTRASONIC SPECIAL NDI INSP IAW LOCKHEED SERVICE FLO CS1370999, FOUND FS93 CANTED BULKHEAD CRACKING IN THE WEB. DOCUMENTED ON STEDAS NDT RPT PLA-049-2025AT TAT 57,776 TAC35,498, LP# 55164. AFTER FERRY FLIGHT TO A SUITABLE MRO FACILITY. / REPAIR BY REPLSDR 2025F00184Switch · stuckDURING TAKEOFF FROM BLUE GRASS AIRPORT (KLEX), THE PILOT REPORTED THAT UPON RETRACTING THE LANDING GEAR, THE LANDING GEAR LEVER RED UNSAFE LIGHT ILLUMINATED, ACCOMPANIED BY AN AURAL GEAR WARNING. THE PILOT EXTENDED THE LANDING GEAR, WHICH RESULTED IN THREE DOWSDR SIMA20250815001Bypass Valve · failedPACK 1 OFF MSG DISPLAYED INITIALLY AT FL290 CLIMBING 300. CABIN ALT CONTINUED TO CLIMB TO 7000FT. STAYED OFF DURING EMG DESCENT UNTIL 13000 FT. ALT STABILIZED REACHING TEN. PACK 1 OFF OCCURRED TWICE MORE AT 10000 AND 2000 FT. EACH TIME CABIN CLIMBED. EMERGENCYSDR JJBA20250815035Lamp · inoperativeLH LATERAL WTF FAIRING EMERGENCY LIGHT OUT. REMOVED AND REPLACED LAMP. OPS CHECK GOODSDR FDEA202508151455Power Supply · inoperativeCOURIER AREA CENTER EMERGENCY LIGHT WITH R1 DOOR EXTERIOR SLIDE LIGHT AND R1 EXIT LIGHT INOP. AMM: 33-51-07-2 REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY IAW ABOVE REF. OPS CHK SERVICEABLE. OK TO CONTINUE.SDR FDEA202508151454Monitor · expiredCO2 MONITOR (S/N AREJ-2218) CALIBRATION CYCLE EXPIRED. REMOVED AND REPLACED CO2 MONITOR WITH EXPIRED CALIBRATION CYCLE.SDR FDEA202508151453Skin · worn#7 SLAT OUTER SKIN TRAILING EDGE FASTENER HOLE AT ISS 184 FOUND WORN. LH WING #7 SLAT OUTER SKIN TRAILING EDGE AT ISS 184 WORN FASTENER HOLE REPAIRED AS PER B777 SRM 57-43-01-2R REPAIR 6 FIG 203 REV 47.6 AND EA G-5750-T0384537 A P1, TITLE: WING - FLIGHT SDR 7C7A1900010000030Skin · damagedRIGHT WINGTIP HAS LIGHTING STRIKE.SDR 7C7A1900010000029Skin · dentedDENT ON FUSELAGE SKIN STA 846 BETWEEN S-4L AND S-5L.SDR REXA2026052700724Fitting · corrodedCORROSION ON SETTLEMENT FITTING OF ENTRANCE COMPARTMENT (1EA)AND GALLEY 1 (1EA) (FLOOR STRUCTURE AREA). DUE TO EXCESIVE CORROSION ON SETTLEMENT FITTING OF ENTRANCE COMPARTMENT (1EA) AND GALLEY 1 (1EA) (FLOOR STRUCTURE AREA) WERE REPLACED PER CRJ900 SRM 53-21-SDR REXA2026052700723Fitting · corrodedCORROSION ON SETTLEMENT FITTING OF ENTRANCE COMPARTMENT (1EA)AND GALLEY 1 (1EA) (FLOOR STRUCTURE AREA). DUE TO EXCESIVE CORROSION ON SETTLEMENT FITTING OF ENTRANCE COMPARTMENT (1EA) AND GALLEY 1 (1EA) (FLOOR STRUCTURE AREA) WERE REPLACED PER CRJ900 SRM 53-21-SDR REXA2026052700712Hinge · brokenBROKEN HINGE ON UPPER STAIR PANEL OF THE PASSENGER DOOR HINGE ON ACCESS PANEL 832 ET WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR SWIA2025123000814Block · chafedANTI YAW STEADY BLOCK OF THE H-STAB ANTI YAW STEADY FITTING HAS CHAFING. REMOVED AND REPLACED DAMAGED STEADY BLOCK AND STEADY FITTING AT HORIZONTAL STABILIZER IAW SRM 51-40-11, 51-21-11, 51-25-06, 51-42-21, 51-12-00, & AMM 27-40-00, DWG AV670-21010.SDR SWIA202512020814Door Sill · corrodedAFT CARGO FLOOR SILL ANGLE IS CORRODED IN SEVERAL AREAS. INSTALLED NEW AFT CARGO FLOOR SILL IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG MM670-35085 REV-L.COMPLETED SKYWEST TASK CARD 51-900-1002-SKY.SDR CALA2025111011061Oxygen Gen · misinstalledSEAT 26ABC PSU O2 GENERATOR FOUND TO HAVE A SHIPPING PIN INSTALL. REMOVED SHIPPING PIN AND INSTALLED SAFETY PIN IAW AMM TASK 35-22-11-000-811-001.SDR VNAA202509260012Fitting · corrodedAFTER REMOVAL OF CROSSBEAM, CORROSION WAS FOUND ON FLOOR FITTING BTW INTERCOSTAL RBL 15 - RBL 17 AND BTW FS 280 -295. DUE TO EXCESSIVE DAMAGE ON FLOOR FITTING BTW INTERCOSTAL RBL 15 - RBL 17 AND BTW FS 280 -295 WAS FOUND OUT OF LIMITS PER CRJ700 SRM 53-00-00-SDR VNAA202509260011Hinge Fitting · damagedSTANDARD BUSHING FITS FREELY BORE LUG L5 CENTER HINGE AT LH AILERON ASSY. BORE LUG L5 CENTER HINGE AT LH AILERON ASSY WAS REPAIRED PER REO 670-57-61-237 REV. - -SDR VNAA202509260008Hinge Fitting · corrodedCORROSION ON BORE LUGS: L1 AND L2 CENTER HINGE 2 AT LH AILERON ASSY. BORE LUGS: L1 AND L2 CENTER HINGE 2 AT LH AILERON ASSY WERE REPAIRED PER REO 670-57-61-237 REV. - -SDR VNAA202509260006Bushing · wornAFTER REMOVAL BUSHINGS, WEAR ON OUTBOARD FACE OF LUGS R5, R6 OF CENTER HINGE FITTING AT RH AILERON. WEAR ON OUTBOARD FACE OF LUGS R5, R6 OF CENTER HINGE FITTING AT RH AILERON. WERE REPAIRED PER REO. 670-57-61-237 REV - -SDR VNAA202509260005Hinge Fitting · corrodedCORROSION ON BORE LUG # R1, R2, R4, R5, R6 OF CENTER HINGE FITTING AT RH AILERON. BORE LUG # R1, AND R4, WERE CLEANED PER CRJ700 SRM 51-26-00-001-001-A01, NO CORROSION WAS FOUND AND BORE LUG # R2, R5 AND R6 OF CENTER HINGE FITTING AT RH AILERON WERE REPAIRED SDR VNAA202509260004Hinge Fitting · corrodedCORROSION ON NLG DOOR INTERNAL HOLES OF HINGE FITTINGS (2EAS) LH/RH AT FUSELAGE STRUCTURE WAS FOUND. CORROSION ON NLG DOOR INTERNAL HOLES OF HINGE FITTINGS (2EAS) LH/RH AT FUSELAGE STRUCTURE WERE EVALUATED OUT OF LIMITS PER CRJ-900 SRM 51-10-06-001-001-A01 ANSDR VNAA202509250018Skin · corrodedCORROSION ON SETTLEMENT AREA OF ACCESS 832FL, 832EL, 832DL, 832CL, 832BL, 832AL, 832AR, AT PASSENGER DOOR. SETTLEMENT AREA ON ACCESS PANELS 832EL, 832DL, 832CL, 832BL, 832AL, 832AR WERE BLEND OUT, MEASURED WITHIN LIMITS PER CRJ-700 SRM 52-11-01-101-001-A01, 5SDR SWAA2025092304685Support Angle · corrodedCORROSION SUPPORT ANGLE BS 500D BETWEEN STRINGERS 26L TO 26R, IN FWD CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 52-40-02, SRM 51-10-02, STEP 9, AND DWG 143A9481, SHEET 14, REV-.SDR SWAA2025092304683Angle · crackedCRACK ANGLE LOCATED BS 827 AT LEVEL STR 25R AFT CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, AND DWG 146A8120, SHEET 37, REV -; DWG 146A0081, SHEET 38, REV -.SDR SWAA2025092304688Angle · crackedCRACK ANGLE LOCATED BS 807, S25R IN AFT CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, AND DWG 146A8120, SHEET 37, REV -, AND DWG 146A0081, SHEET 38, REV -.SDR SWAA2025092304681Support Angle · corrodedCORROED SUPPORT ANGLE, BS 767 - 787, S25R IN CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, DWG 146A0081, SHEET 37, REV -, AND DWG: 146A8123, SHEET 16, REV -.SDR SWAA2025092304689Support Bracket · crackedCRACK SUPPORT BRACKET. BS 947.5, STRINGER 26L IN AFT CARGO BAY. EVALUATED DAMAGE AND NOT FOUND ALLOWABLE DAMAGE FOR CRACK. MEASUREMENT: L= 2.350, IAW SRM . REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02, AND DWG 149A8103, SHEET 7, REV A.SDR SWAA2025092204680Intercostal · corrodedCORROSION WEB - INTERCOSTAL LOCATED BS767 TO BS787 AT LEVEL STR25R AFT CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BS767 TO BS787 AT LEVEL STR25R AFT CARGO COMPARTMENT IAW SRM 51-40-02 AND DRAWING 146A0081; SHEET 37. REV-.SDR SWAA2025091604283Floor Panel · pulledFLOOR PANEL 241FF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED A NEW 241FF FLOOR PANEL IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025091504281Floor Panel · pulledFWD FLOOR PANEL 222CF UPPER SKIN HAS AN AREA OF PULLED STRANDS NEAR FWD EDGE. REPAIRED THE FWD FLOOR PANEL 222CF IAW SRM 53-00-50-2R-1.SDR HNAA2025091000598Repair · incorrectRH ELEVATOR EXTERIOR UPPER SKIN #2 HINGE CUTOUT REPAIR DOUBLER HAS NO REPAIR INFORMATION. C/W PERMANENT REPAIR ON THE RH ELEVATOR UPPER SKIN #2 HINGE CUTOUT IAW ETD2025-145-925991 REV B AND EO1-55-25-0272.SDR HNAA2025091000597Repair · incorrectLH ELEVATOR ACCESS PANEL 335HB CUTOUT INTERNAL REPAIR COUBLER HAS NO REPAIR INFORMATION. ACCOMPLISHED PERMANENT REINFORCING REPAIR ON LH ELEVATOR ACCESS PANEL 335HB CUTOUT IAW ETD2025-145-925992 REV-A AND PIEDMONTEO1-55-25-0271.SDR SIMA20250814002Rod · gougedLH DV WINDOW BOTTOM ROD HAS GOUGE (MAJOR REPAIR) BLENDED GOUGED AREA ON LH DV WINDOW BOTTOM ROD PER EMB-175 SRM 51-10-03. BLENDED AREA MEASURES (L=1.4?, W=.3?, H=.017?). DIAMETER REMAINING IS .692? AND IS FOUND TO BE OUT OF ALLOWABLE LIMITS PER EMB-175 AMM MPPSDR SWAA2025090904478Floor Support · crackedCRACKED ON FLOOR SUPPORT BS 312 - 328, LBL45, WL208.1. REMOVED, LOCATED, DRILLED, AND INSTALLED THE FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-40-05, AND DWG 141A5400, REV-.SDR SWAA2025090804488Floor Support · corrodedCORROSION ANGLE FLOOR STRUCTURE ON BS 716 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN. REPLACED ANGLE FLOOR STRUCTURE ON BS 716 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 AND DWG 144A7730 SHEET 7 REV -.SDR SWAA2025090804739Angle · corrodedCORROSION ANGLE LOCATED BS716 RBL64 WL203.1 AT PASSENGER CABIN. REPLACED ANGLE AND FASTENERS LOCATED BS716 RBL64 WL203.1 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02 AND DWG 144A7730 SHEET 8 REV:-.SDR SWAA2025090804737Floorbeam · crackedCRACK FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW BL 0 TO RBL 24.75 AT PASSENGER CABIN. REPLACED FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW BL 0 TO RBL 24.75 AT PASSENGER CABIN IAW SRM 51-40-02 AND DWG 143A0060 SHEET 36 REV. A DUE TO NOT FOUND ALLOWABLE DAMAGE OSDR SWAA2025090804738Floorbeam · crackedCRACK FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW BL 0 TO LBL 24.75 AT PASSENGER CABIN. REPLACED FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW BL 0 TO LBL 24.75 AT PASSENGER CABIN IAW SRM 51-10-02; SRM 51-40-2 AND DWG:143A0060 SHEET: 36 REV A DUE TO NOT FOUND ALLOSDR SWAA2025090804743Floorbeam · crackedCRACK FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW LBL 24.75 TO LBL 45.50 AT PASSENGER CABIN. REPLACED FLOOR STRUCTURE BREAK PANEL ON BS 540 BTW LBL 24.75 TO LBL 45.50 AT PASSENGER CABIN I.A.W. B737-700 SRM 51-40-02 AND DWG 143A0060 SHEET 36 REV. A DUE TO NOT FSDR SWAA2025090804490Floor Support · corrodedCORROSION ANGLE FLOOR STRUCTURE ON BS 685 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN. REPLACED ANGLE AND FASTENERS LOCATED ON FLOOR STRUCTURE ON BS 685 AT LEVEL STR 18L AND LBL 64 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0 AND DWG 144A7730, SHEET 9, REV-.