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 SWI2025F01570Slat Track · wornRH WING SLAT TRACK 1-3 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2195 REV-- DATED 2025-09-12PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK AT THIS MOMENTCOMPSDR SWIA202511240825Slat Track · wornLH WING SLAT TRACK 1-3 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2198 REV-- DATED 2025-09-12. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27-900-1009-SKYSDR IPXA2025092648850Hinge · crackedPIANO HINGE HOLE 14F CRACK NOTED IN ALUMINUM LAYERS. REAMED HOLE 14F TO .261" IAW SRM 51-40-44. COMPLIED WITH EA 300-5236-27-A4122 REV-, STEP 19, PRELIMINARY 2. INSTALLED FASTENER AT HOLE 14F. RECEIVED FINAL DRAFT OF EA 300-5236-27-A4122 ACCOMPLISHED STEPS 1-2SDR IPXA2025092651025Frame · crackedCRACK INDICATION NOTED AT CENTER WING BOX CENTER SPAR AT FR44 CUTOUT DOUBLER RUN OUT RH ON I/B TOP HOLE. PERFORMED REAM HOLE 2 OVER (0.277) IN CENTER WING BOX SPAR AT FR 44 CUT-OUT DOUBLER RUN OUT RT ON INBD TOP HOLE PER SRM 51-40-40. ACCOMPLISSHED STEP 9 ONSDR AALA202510067794Bearing · migratedAIRCRAFT IN BASE MAINTENANCE: MIGRATED BEARING FWD FITTING LOC. MAIN DOOR RH SIDE IN MAIN WHEEL WELL. MAINTENANCE REPLACED HINGE FITTING ASSY OF RH MLG DOOR IAW AIRBUS CMM 52-81-18, A319 SRM 51-44-11-801, A319 SRM 51-21-11-801, PMS 01-05-26AND NTM 51-90-00.SDR SWAA2025100107937Scuff Plate · crackedAFT ENTRY DOOR SCUFF PLATE IS CRACKED. REPAIRED AFT ENTRY DOOR SCUFF PLATE IAW B737-7 SRM 53-70-15-2R-1.SDR SWAA2025100108062Sill Drain · corrodedCORROSION ON FED MOPSILL AT BS294.5+9 LBL55; WL208<[01] REMOVED AND REPLACED FED MOPSILL P/N 654A0004-1073 BS270 TO BS360 LBL63 WL208 IAW SRM 51-40-02 AND DWG 141A8110 REV E.;[02] VERIFIED CORRECTIVE ACTIONSDR SWAA2025100108213Attach Angle · corrodedMULTIPLE AREAS OF CORROSION ON FED INNER MOPSILL ATTACH ANGLE FROM BS312+10-BS328+7 LBL56; WL208<[01] REMOVED AND INSTALLED NEW INNER MOPSILL ATTACH ANGLE ON FED; PER SRM 51-40-02 AND DWG 141A8110; ID: 0011; REV: -SDR SWAA2025100108056Scuff Plate · crackedFSD SCUFF PLATE CRACKED. REPAIRED IAW SRM 53-10-15-2R-2.SDR SWAA2025100108061Floor Support · crackedCRACKED ON INTERCOSTAL FROM BS328-BS344, LBL45, WL 208. REMOVED AND REPLACED INTERCOSTAL FROM BS 328 - 344, LBL45, WL 208 IAW SRM 51-40-02 AND DWG 141A5400 0044, REV -.SDR SWAA2025093008212Flange · damagedELONGATED NUTPLATE FASTENER HOLE ON FWD SIDE OF BS 312 FLANGE AT LBL 38, WL 208. REPAIRED BS 312 FLANGE AT LBL 38 IAW SRM 53-00-51-2R-1.SDR SWAA2025093008063Doubler · corrodedCORROSION FOUND ON EXTERNAL FUSELAGE SKIN AT ROW 44 DOUBLER NUMEROUS AREAS FROM BS 727B TO 767 STRINGERS 4L - 4R. REPAIRED IAW EA 25-153-02333 WITH AN INSPECTION THRESHOLD, PROGRAM DEFINED IN 25-153-02333-INSP.SDR SWAA2025093008210Fitting · corrodedORROSION ON GIRT BAR FITTING AT BS344, LBL 55, WL 208. VERIFIED APPLICABILITY WAS NOT FOUND ALLOWABLE DAMAGE IN SRM, PART MUST BE REPLACED IAW SRM 51-10-02 STEP 9.C. REMOVED AND INSTALLED NEW GIRT BAR FITTING AT BS344, LBL55, WL208; PER SRM 51-40-02 AND DWGSDR SWAA2025093008211Fitting · corrodedCORROSION ON GIRT BAR FITTING AT BS312 LBL52; WL208<[01] VERIFIED APPLICABILITY; NOT FOUND ALLOWABLE DAMAGE IN SRM; PART MUST BE REPLACED IAW SRM 51-10-02 STEP 9.C. REMOVED AND INSTALLED NEW GIRT BAR FITTING AT BS312; LBL52; WL208; PER SRM 51-40-02 AND DWG 14SDR 9WGA2025092654680Spar · corrodedDURING HEAVY MAINTENANCE, RT OUTER WING LOWER REAR SPAR HAS CORROSION AT APPROX XORS-552. CLEANED AREA FROM DIRT AND DEBRIS AT RH WING LOWER REAR SPAR AT APPROX. XORS 552 IAW MD-11 AMM 12-26-02 AND SRM 51-21-01, AFTER FURTHER EVALUATION NO CORROSION NOTED AT SDR SWAA2025092408045Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE HAS CRACK AT APPROXIMATELY RBL 9. REPLACED THE ATTACH ANGLE IAW SRM 51-40-02 & DWG 111A1000.SDR SWAA2025092408046Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE CRACKED AT APPROXIMATELY RBL 34. REMOVED THE ATTACH ANGLE IAW SRM 51-40-02. C/W HOLE PROBE INSP IAW NDT 51-00-00, PART 6, PROC. 16. MATCH DRILLED AND DEMURRED A NEW ATTACH ANGLE IAW SRM 51-40-05. INSTALLED THE NEW ATTACSDR IPXA2025091850638Bracket · cracked-EXT TAIL-L/H SIDE WHERE FUSELAGE AND TAIL MEET-ANGLE CRACKED FOR UPPER APRON(333AT)-109 VWV 91195430. INSTALLED L/H HORIZONTAL STABILIZER LEADING EDGE 331AB IAW A300-600 AMM 55-12-11/401. REVIEWEDSDR R61A2025091700409Sign · inoperativeDURING C-CHECK MAINTENANCE FOUND FWD SERVICE DOOR R/H EXIT IDENTIFIER INOP. REMOVED AND REPLACED R/H EXIT IDENTIFIER IAW AMM 33-50-15SDR R61A2025091700408Skin · dentedDURING C-CHECK MAINTENANCE FOUND FWD FUSELAGE. EXTERNAL SKIN FOUND WITH 3 DENTS BETWEEN FR 09-FR12 AND STGR 18L -19L. REMOVED AND REPLACE SKIN PANEL BETWEEN FR 09-FR12 AND STGR 18L -19L IAW SRM 51-40-08SDR K11A2025091800342Floor Support · corrodedFLOOR SUPPORT IN FWD PIT AT STA 485 LBL 18.2 CORRODEDSDR SWAA2025091707928Floor Panel · peelingMAIN CABIN FLOOR PANEL 241TF HAS PEELING STRANDS OF FIBER. INSTALLED NEW FLOOR PANEL.SDR SWAA2025091707929Floor Panel · peelingMAIN CABIN FLOOR PANEL 241MF HAS PEELING STRANDS OF FIBER.SDR ASAA2025082560923Support · corrodedFWD CARGO COMPARTMENT AFT LEFT BULKHEAD SUPPORT STRUCTURE HAS CORROSION. GROUNDED - YES. REMOVED CORROSION FROM FWD PIT AFT L/H SIDE BULKHEAD SUPPORT IAW B737-900 SRM 53-30-08-1A-1, 100% MATERIAL LOSS AND FOUND TO BE OUT OF LIMITS IAW B737-900 SRM 53-30-08-1A-SDR SWIA2025091500825Seat Track · gougedPASSENGER CABIN LH INBOARD SEAT TRACK SEGMENT FR 74-84 HAS GOUGE DAMAGE NEAR FR 81,82,83 AND PAINT DAMAGE ALONG UPPER SURFACE ENTIRE LENGTH. (C-CHECK RO 09/12/2025)REMOVED AND REPLACED PASSENGER CABIN LH INBOARD SEAT TRACK SEGMENT FR 74-84 REF SRM 51-40-08. SDR CALA2025091508884Window Frame · crackedFOUND DAMAGE CRACK AT THE R3 WINDOW FRAME POST HOLE 5, REF TO EA 5310-08195 REV C OP 004. (REF AAR NR 1000043323). ACCOMPLISHED REPAIR OF HOLE # 5 AT THE RH # 3 WINDOW FRAME POST IAW ECRA #:5310-08676.SDR SWAA2025091208093Bulkhead · crackedB.S. 663 LOWER COMPOSITE BULKHEAD IS CRACKED AT LBL 15; WL 167. BS 663 LOWER COMPOSITE BULKHEAD IS CRACKED AT LBL 15; WL 167; WAS REPAIRED IAW SRM 51-70-04-2R-10.SDR HNAA2025091100604Skin · crackedLH REAR FUSELAGE 2 UPPER SKIN RIVET ON FR80 BETWEEN STR 6L-7L HAS A POSSIBLE CRACK. INSTALLED REPAIR BUSHING ON LH REAR FUSELAGE 2 UPPER SKIN AT FR80 BETWEEN STGR 6L-7L IAW EMB 145 SRM 53-32-01 REF STEP 9 AND PIEDMONT EO1-53-25-0291.SDR AALA202509093653Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #6 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #6 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509090515Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #5 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #5 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509099203Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #4 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #4 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509094768Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #3 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #3 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509093009Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #2 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #2 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509092807Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #1 ON RH HORIZON STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #1 ON RH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509090078Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #6 ON LH HORIZON TAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR AALA202509093877Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #3 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #3 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509092617Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #1 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #1 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509099251Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #4 ON LH HORIZON TAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #4 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509084756Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER IN SPAR RIB, AT STABILIZER STA 92.70, AT THIRD STIFFENER AFT OF THE FORWARD SPAR. REPLACED RIB PER AARD 51-00-05-1.SDR AALA202509088505Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 184.7, 8 INCHES FROM THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11SDR AALA202509085916Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER IN SPAR RIB, AT STABILIZER STA 92.70, AT SECOND STIFFENER AFT OF THE FORWARD SPAR. REPLACED RIB PER AARD 51-00-05-1.SDR REXA2025090800850Rod · out of adjustPAX DOOR INNER HANDLE FORCE REQUIRED TO OPEN EXCEEDS MAXIMUM ALLOWABLE FORCE. (33LBF MEASURED, 16LBF ALLOWED). ADJUSTED PRESSURE VENT FLAP SPRING ROD ASSEMBLY AND LATCH MECHANISM UPPER PUSH ROD ITEM 90 OF AMM IAW CRJ 900 AMM 52-11-15-820-801 (A01) AND 52-11-0SDR R61A202509050038Rib · damagedSYS HYD 2 PRESSURE LINE WALL FITTING PASS THROUGH CHAFED AND ELONGATED OTBD OF RIB 4A ON TRAILING EDGE, REPAIRED BY REAMING HOLE AND INSTALLED REPAIR BUSHING. SRM 57-50-05/REPAIR01.SDR AALA202509054826Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #5 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #5 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A. AND AMM 55-16-42-400-001-A.SDR SWAA2025090408067Doubler · crackedEGPR DOOR LOWER CUTOUT SURROUND DOUBLER IS CRACKED. ACCOMPLISHED REPAIR ON EGPR DOOR LOWER CUTOUT SURROUND DOUBLER IAW B737-800 SRM 53-10-15-2R-4. INSPECTED PER [SRM 53-10-15-2R-4-B00449, REPAIR 4.SDR DALA2025090406558Skin · dented(4R) OUTER SKIN, BOTTOM EDGE FOUND DENTED. COMPLIED WITH ERA 501981-14 REV. B. (1163409)SDR 2DYA202508130003Battery Pack · no testM1209 E. BATTERY FAILED CAPACITY TEST. REF. WO # 7010-0009-2025 NR 0157SDR 2DYA202508130002Battery · no testM736 AND M1210 E. BATTERY FAILED CAPACITY TEST .REF. WO# 7101-0009-2025 NR#'S 0158 0159.SDR HEEA202509030001Computer · inoperativeDEPARTING HMALA ON CLIMB TO ALTITUDE, AP REDUNDANCY CAUTION LIGHT ILLUMINATED. FOUND THAT AP2 WAS INOPERATIVE AND WOULD NOT RESET.SDR GTIA2025090239056Skin · damagedPERMANENT REPAIR EXTERNAL SKIN LOCATED LOCATED BTW FR 69 TO FR 70 AT LEVEL STR 30R T O STR 33R RAF-01 3625188-02 GENERATED -PERFORMED PERMANENT REPAIR OF FUSELAGE SKIN AROUND THE AFT LAVATORY VENT OUTLET SKIN BTW FR.69 TO FR.70 AT LEVEL STR 31R TO STR 32R AT