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 ASAA2025092561670Seat Track · corrodedSEAT TRACK AT RBL 60.70 MULTIPLE AREAS OF CORROSION STA 480 TO 520. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A+-1, REMOVED TRACK, FABRICATED, LOCATED, DRILLED & INSTALLED IAW B737-700 SRM 51-40-02 & SRM 51-40-05W= 1.SDR ASAA2025092561669Seat Track · corrodedSEAT TRACK AT RBL 60.70 MULTIPLE AREAS OF CORROSION STA 540 TO 627.5. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED IAW B737-700 SRM 51-40-02-0G-0W: 1" O: .146 R: .121 L: 1" D: .025.SDR ASAA2025092561668Seat Track · corrodedSEAT TRACK AT LBL 24.75 MULTIPLE AREAS OF CORROSION STA 400 TO 480. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS REMOVED AND REPLACED SEAT TRACK IAW BOEING 737-700 SRM 51-40-02-0G-0W: 1" O: .146 R: .123 L: 4" D: .023.SDR ASAA2025092561666Seat Track · corrodedSEAT TRACK AT LBL 24.75 MULTIPLE AREAS OF CORROSION STA 480 TO 520. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .188 R: 141 L: 4" D: .043.SDR ASAA2025092561665Seat Track · corrodedSEAT TRACK AT LBL 24.50 MULTIPLE AREAS OF CORROSION STA 727B TO 887. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .189" R: .146" L: 4" D: .043.SDR ASAA2025092561664Seat Track · corrodedSEAT TRACK AT LBL 24.75 MULTIPLE AREAS OF CORROSION STA 887 TO 1016. GROUNDED - YES. REMOVED CORROSION ON SEAT TRACK STA 887-1016 LBL 24.75 AND FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1 AND REMOVED AND REPLACED IAW B737-700 SRM 51-40-02-0G-0W- 2SDR ASAA2025092561663Seat Track · corrodedSEAT TRACK AT LBL 24.75 MULTIPLE AREAS OF CORROSION STA 887 TO 1016. GROUNDED - YES. REMOVED CORROSION ON SEAT TRACK STA 887-1016 LBL 24.75 AND FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1 AND REMOVED AND REPLACED IAW B737-700 SRM 51-40-02-0G-0W- 2SDR SWIA20250925Seat Track · corrodedLH LONGITUDINAL SEATTRACK AT FR80-4" AND Y= -10.75" HAS CORROSION (C-CHECK RO 10/17/2025)REMOVED AND REPLACED L/H LOGITUDINAL SEAT TRACK AT FR 76-85 Y-10.75" REF EMB 175 SRM 51-40-08. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRSDR IPXA2025101631355Floor Panel · damagedFAULT: INT-200- MCC FLOORBOARD 232SG HAS DAMAGE. 33-035. FLOOR PANEL 232SG FAB COMPLETED IAW SREO-16407-REQ001 FLOOR PANEL MATERIAL P/N 5024N400001SS-G B/N 0004055277 QTY-1 TOP INSERTS P/N G2001B-3P B/N 0004418941 QTY-50 BOTTOM INSERTS P/N PG2002B-3S B/N 0004SDR IPXA2025101631583Floor Panel · damagedFAULT: INT-200- MCC FLOORBOARD 232WG HAS AN OVERSIZE SCREW HOLE. 33-038. FLOOR PANEL 232WG FAB COMPLETED IAW SREO-16407-REQ001 FLOOR PANEL MATERIAL P/N 5024N400001SS-G B/N 0004055277 QTY-1 TOP INSERTS P/N G2001B-3P B/N 0004418941 QTY-50 BOTTOM INSERTS P/N PGSDR IPXA2025101539416Bracket · crackedFAULT-STR-ZONE 300. VERTICAL STAB, FIN TO FUSELAGE FAIRING AREA, LH #2 UPPER PANEL SUPPORT BRACKET (1EA) BROKEN. REMOVED THE BROKE UPPER BRACKET AT 300. VERTICAL STAB, FIN TO FUSELAGE FAIRING AREA, LH IAW A300-600 SRM 51-40-21 IT. ++INSTALLED SUPPORT BRACKESDR R61A2025101700467Skin · corrodedDURING C-CHECK FWD FUSELAGE EXTERNAL SKIN BETWEEN FR-10-11 STR 17L - 18L FOUND TOLLING MARKS AND DENT AROUND FASTENERS. REPAIRED IAW ETD 2025-170-929153SDR R61A2025101700462Shear Tie · corrodedDURING C-CHECK FWD FUSELAGE SHEAR CLIP AT FR 20 BETWEEN BL-0 AND 28R FOUND CORRODED. REMOVED AND REPLACED SHEAQR CLIP IAW SRM 51-41-02SDR R61A2025101700461Shear Tie · corrodedDURING C-CHECK FWD FUSELAGE SHEAR CLIP AT FR17 BETWEEN STR26R-27R FOUND CORRODED. REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-41-02SDR IPXA2025101339189Bracket · crackedVERTICAL STAB, FIN TO FUSELAGE FAIRING AREA, RH #3 PANEL SUPPORT BRACKET (1EA) BROKEN. REMOVED SUPPORT BRACKET (1EA)I.A.W A300-600 SRM 51-40-21. ++INSTALLED NEW PART IAW A300-600 SRM 51-40-21. RIVET P/N CR3213-4-06, BATCH #0004279158, QTY 2EASDR ASAA2025092561573Seat Track · corrodedSEAT TRACK AT RBL 60.40 MULTIPLE AREAS OF CORROSION STA 627.5 TO 663 GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0W: 2 O: .230 R: .185 L: 4 D: .045.SDR SWAA2025101618314Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS500G TO BS500H AT LBL 21 AT FWD CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BTW BS500G TO BS500H AT LBL 21 AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7505 SHEET: 123SDR ASAA2025092561570Seat Track · corrodedSEAT TRACK AT RBL 24.75 MULTIPLE AREAS OF CORROSION STA 887 TP 1016. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .230 R: .205 L: 4" D: .025.SDR ASAA2025092561569Seat Track · corrodedSEAT TRACK AT LBL 45.50 MULTIPLE AREAS OF CORROSION STA 905 TO 1016. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1. REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0W: 3.00" OT: .145" RT: .117" L: 3.50SDR ASAA2025092561568Seat Track · corrodedSEAT TRACK AT BL 0 MULTIPLE AREAS OF CORROSION STA 827 TO 905. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED CARGO SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .146 R: .111 L: 3" D: .035.SDR ASAA2025092561567Seat Track · corrodedSEAT TRACK AT BL 0 MULTIPLE AREAS OF CORROSION STA 887 TO 1016. GROUNDED - YES. REMOVED CORROSION ON SEAT TRACK BL 0 STA 907-1016 AND FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1 AND REMOVED AND REPLACED SEAT TRACK BL 0 STA 907-1016 IAW B737-700 SRSDR ASAA2025092561566Seat Track · corrodedSEAT TRACK AT BL 0 MULTIPLE AREAS OF CORROSION STA 727B TO 827. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT LIMITS IAW B737-700 SRM 53-00-52-1A-1 & REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0W= 2" O= .230" R= .162 L= 3" D= .068.SDR ASAA2025092561565Seat Track · corrodedSEAT TRACK AT RBL 45.50 MULTIPLE AREAS OF CORROSION STA 480 TO 520. GROUNDED - YES. REMOVED SEAT TRACK CORROSION, FOUND TO BE OUT OF LIMITS AND REMOVED AND REPLACED, RESTORED FINISH IAW B737-700 SRM 53-00-52-1A-1W- 1IN O-.230 R- .173 L- 2IN D- .057.SDR ASAA2025092561564Seat Track · corrodedSEAT TRACK AT RBL 24.75 MULTIPLE AREAS OF CORROSION STA 540 TO 727B. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK AT RBL 24.75, STA 540 TO 727B IAW B737-700 SRM 53-00-52-1A-1 SRM51-40-02-0G-0W: 1.500" O: 0.146" R: SDR ASAA2025092561563Seat Track · corrodedSEAT TRACK AT LBL 45.50 MULTIPLE AREAS OF CORROSION STA 540 TO 727B. GROUNDED - YES. REPLACED SEAT TRACK AT LBL 45.50 BTW STA 540 TO 727B IAW B737-700 SRM 51-40-02-0G-0. TOOLING USED FOR TORQUE SCREWS P/N: TORQUE WRENCH AAR535964 DUE DAT 07/31/26. REMOVED CORRSDR ASAA2025092561562Seat Track · corrodedSEAT TRACK AT RBL 60.40 MULTIPLE AREAS OF CORROSION STA 663 TO 727B+10. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0W: 2 O: .230 R: .172 L: 4 D: .058.SDR ASAA2025092561561Seat Track · corrodedSEAT TRACK AT RBL 45.50 MULTIPLE AREAS OF CORROSION STA 520 TO 540. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0F-0 & SRM 51-40-05-0G-0 AND AMM 20-50-11-910-801W: 2" O: .188 R: .163 L: 3" SDR ASAA2025092561560Seat Track · corrodedSEAT TRACK AT RBL 42.50 MULTIPLE AREAS OF CORROSION STA 727B TO 887. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .230 R: .175 L: 4: D: .055.SDR ASAA2025092561559Seat Track · corrodedSEAT TRACK AT RBL 24.50 MULTIPLE AREAS OF CORROSION STA 727B TO 887. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 & 51-40-05-0G-0W: 2" O: .230 R: .188 L: 3" D: .042.SDR ASAA2025092561557Seat Track · corrodedSEAT TRACK AT LBL 45.50 MULTIPLE AREAS OF CORROSION STA 480 TO 520. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0W= .750 O= .590 R= .548 L= 7.50 D= .042.SDR IPXA2025101046481Adapter · brokenMDC, LH SIDE, FLOOR AREA, THROUGH PANEL 241YK, BTWN FR38.1 TO 38.2 HAS CLS ADAPTER BROKEN (BY CORROSION). REMOVED 02 EA CLS ADAPTER LOCATED IN FR38.1 AND FR38.2. IAW SRM 51-40-21. IAW STEP 9. INSTALLED 02 EA CLS ADAPTERS. IAW SRM 51-40-21.SDR IPXA2025101031266Floorboard · brokenMCC FLOOR BOARD 231MJ IS BROKEN. 33-033. FLOOR BOARD 231MJ FABRICATION COMPLETE IAW SREO-16407-REQ 001 INSERT QUANTITY 40 INSERT, EDGE FILL, KIT INSERT GLUE. MAJOR.SDR IPXA2025100931224Floor Panel · damagedMCC FWD FLOORBOARD 221CG HAS FWD EDGE DAMAGE. 33-032. FLOOR PANEL FABRICATION COMPLETE IAW SREO-16407-REQ001.SDR IPXA2025100236550Angle · crackedFR 80, BTW -Y1137.1 AND -Y1580.5, Z ANGLE WITH CRACK.REMOVED AND REPLACED PROFILE-T P/N A53988140120100 BATCH 0004429452, AT MDC, FR 80, BTW -Y1137.1 AND -Y1580.5, IAW A300-600 SRM 51-40-21SDR IPXA2025100638930Fitting · crackedMAIN DECK FLOOR STRUCTURE, FR 10, -Y1456, FITTING PICK-UP WITH CRACK.REMOVED FITTING IN MAIN DECK FLOOR STRUCTURE, FR 10, -Y1456. IAW AIRBUS A300-600 SRM 51-40-21.FABRICATED, LOCATED AND DRILL NEW FITTING PICK-UP P/N: 2024-T3 .063, BATCH: 0004410262 IAWAIRBUSASDR 2025FA0000695Drain Valve · openFOUND PITOT/STATIC PORT DRAIN ABLE TO GET STUCK IN OPEN POSITION IF PRESSED WITH A SIDE LOAD. AIRCRAFT DEPARTED WITH DRAIN STUCK AND DID NOT RECEIVE AIRSPEED INDICATION.SDR IPXA2025100346608Support · crackedMDC, LH SIDE, FLOOR AREA, FR38.1 TO FR38.2 HAS CROSS WEB (DOG BONE) BROKEN. DOT 103-39.REMOVED SUPPORT CROOS WEB (DOG BONE) LOCATED AT Z200, MDC, LH SIDE, FLOOR AREA, FR38.1 TO FR38.2 IAW A300-600 SRM 51-40-21.RECEIVED NEW CROSS WEB (DOG BONE) IAW A300-600 SRMSDR SWAA2025100722152Hmu · failedNUMBER 1 ENGINE ROLLED BACK/FAILED ON TAXI OUT. R & R NR 1 ENGINE HMU PER AMM 73-21-10. OPS AND LEAK CHECK GOOD.SDR AALA202510077980Air Filter · contaminatedAIRCRAFT WAS GROUNDED: DURING TAKEOFF OUT OF DCA THERE WAS A VERY STRONG DIRTY, MUSTY, AND OILY SMELL THROUGH OUT THE ENTIRE AIRCRAFT. **SUPPLEMENTAL REPORT FOR (AALA202509268985): REMOVED AND REPLACED NUMBER 1 ENGINE. PER JOBCARD 08L40072003. REMOVE AND REPLASDR AALA202510073847Air Filter · contaminatedAIRCRAFT WAS GROUNDED: DURING TAKEOFF OUT OF DCA THERE WAS A VERY STRONG DIRTY, MUSTY, AND OILY SMELL THROUGH OUT THE ENTIRE AIRCRAFT. **SUPPLEMENTAL REPORT FOR (AALA202509268985): REMOVED AND REPLACED NUMBER 1 ENGINE. PER JOBCARD 08L40072003. REMOVE AND REPLASDR AALA202510076932Engine · odorAIRCRAFT WAS GROUNDED: DURING TAKEOFF OUT OF DCA THERE WAS A VERY STRONG DIRTY, MUSTY, AND OILY SMELL THROUGH OUT THE ENTIRE AIRCRAFT. REMOVED AND REPLACED NUMBER 1 ENGINE. PER JOBCARD 08L40072003. REMOVE AND REPLACED LEFT (AALA202510070691) AND RIGHT (AALA2SDR AALA202510061636Light · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 10C EMERGENCY PATH LIGHT FIXTURE DANGLING FROM ELECTRIC WIRE. VERIFIED SEAT 10C EMERGENCY PATH LIGHT FIXTURE INOPERATIVE. SECURED EMERGENCY LIGHT HOUSING AS REQUIRED. OPERATIONAL CHECKS GOOD. PER AMM 33-51-00-710-801.SDR UATA2025100605301Fairing · crackedFOUND CRACK IN RH WING TO FUSELAGE FAIRING AT FRAME F5. (SEE AOT-C212-53-0001 FOR DETAILS). REPAIRED CRACK DAMAGE AND REINFORCED F5 RH BY INSTALLATION OF SB KIT SB212530055K01. SEE 337 DATED 09/25/2025. FOR FURTHER DETAILS.SDR IPXA2025100431410Stiffener · crackedRIGHT MAIN DECK DOG BONE IS LOOSE BETWEEN FR 37-38. REPLACED DOG BONE BETWEEN FR 37-38 IAW SRM 51-40-21.SDR IPXA2025100431378Stiffener · crackedRIGHT MAIN DECK DOGBONE BROKEN AT FR 38.1 - 38.2. REPLACED DOG BONE BETWEEN FR 38.1 - 38.2 IAW SRM 51-40-21.SDR REXA2025100600908Bracket · corrodedFRAME AT F.S. 1051.30 IS CORRODED AT STGR 17L UPON FURTHER INVESTIGATION, FOUND THAT THE CORROSION IS ON PN MM670-34112-015 BRACKET ATTACHED TO FRAME 1051. THERE IS NOT CURRENTLY VISIBLE CORROSION ON FRAME 1051 AT STGR 17L, BUT ONCE THE BRACKET IS REMOVED THE SDR AALA202510028843Screw · deterioratedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED, DOOR STOP SCREWS AT POSITION 3 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN. MAINTENANCE REPLACED DOOR STOP SCREWS AT POSITION 3 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN I.A.W AMM 52-22-31-000-001-A AND ASDR AALA202510029601Screw · deterioratedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED, DOOR STOP SCREWS AT POSITION 4 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN. MAINTENANCE REPLACED DOOR STOP SCREWS AT POSITION 4 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN I.A.W AMM 52-22-31-000-001-A AND ASDR AALA202510027996Screw · deterioratedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED, DOOR STOP SCREWS AT POSITION 5 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN. MAINTENANCE REPLACED DOOR STOP SCREWS AT POSITION 5 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN I.A.W AMM 52-22-31-000-001-A AND ASDR AALA202510025751Screw · deterioratedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED, DOOR STOP SCREWS AT POSITION 6 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN. MAINTENANCE REPLACED DOOR STOP SCREWS AT POSITION 6 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN I.A.W AMM 52-22-31-000-001-A AND A