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 DALA2025090806619Skin · corrodedER/A 628936-14 REV ORIGINAL, REPAIR FWD VACUUM OUTLET CUTOUT CORROSION. C/W ERA 628936-14. (1185225)SDR DALA2025090806613Bearing · corrodedCORROSION SPHERICAL BEARING OUTBOARD FLAP TRACK 3 LH WING. REPLACED SPHERICAL BEARINGS OUTBOARD FLAP TRACK 3 LH WING AS PER A320- FAM AMM 57-53-21-000-001-A AS PER A320-FAM AMM 57-53-21-400-001. (1185070).SDR DALA2025090806609Seat Track · corrodedCORRODED SEAT TRACK -Y765 LOCATED AT FR 20 AT FWD GALLEY AREA. REPLACED SEAT TRACK -Y765 LOCATED FR 12 TO FR 24 FWD GALLEY AREA AS PER A319 SRM 53-11-15-283-011, A319 SRM 51-42-11 AND A319 SRM 51-44 -11. (1185106).SDR FDEA202509061634Retainer · deformedL1 DOOR EMERGENCY ESCAPE ROPE RETAINER IS DEFORMED. REMOVED AND REPLACED RETAINER AS PER AMM 25-61-04-8. OK FOR CONTINUE.SDR FDEA202509061633Skin · chafedLH WING #5 SLAT HAS GOUGE IN LOWER SKIN AT WING STA 441 NEAR TRAILING EDGE REPAIRED LH WING L/E # 5 SLAT TRAILING EDGE WEDGE AT WS 433.1 IN REF TO 767 SRM 57-43-02- 2R FIG.201 SHEET 2 AND 767 SRM 51-70-10-2R. SEE JPF FOR WORK ACCOMPLISHED.THIS IS A MAJOR RESDR HNAA2025090800587Battery Pack · inoperativeEMERGENCY FLOOR STRIP 2 & 3 DIM AND THE SECOND CEILING EMERGENCY LIGHT IS INOP. R & R EMERGENCY BATTERY 200; FLOOR PROX STRIP 2 &3, OPS CHECKED GOOD. FOUND CONNECTOR PLUG FOR SECOND EMERGGENCY CEILING LIGHT UNPLUGGED; RECONNECTED CONNECTOR AND OPS CHECK GOSDR UIEA2025090401155Rivet · damagedSTA 200 STR 31AL L/H 1 EA RIVET FOUND LIGHTNING STRIKE. STA 200 STR 31AL L/H 1EA RIVET HEAD LIGHTNING STRIKE REPAIRED IAW SRM 53-00-01-2R-9 REPAIR 9 SECTION II STEP 4, BLIND FASTENER REPAIR. THIS REPAIR IS CATEGORY C REPAIR. NO FURTHER DEFECTS NOTED.SDR UIEA2025090401156Rivet · damagedFX - STA 200 STR 23-24A R/H 1EA RIVET FOUND LIGHTNING STRIKE. STA 200 STR 23-24A R/H 1EA RIVET HEAD LIGHTNING STRIKE REPAIRED IAW SRM 53-00-01-2R-9 REPAIR 9 SECTION II STEP 4, BLIND FASTENER REPAIR. THIS REPAIR IS CATEGORY C REPAIR. NO FURTHER DEFECTS NOTED.SDR UIEA2025090401157Rivet · damagedFX - STA 215 STR 31AL L/H 1EA RIVET FOUND LIGHTNING STRIKE STA 21 STR 31AL L/H 1EA RIVET HEAD LIGHTNING STRIKE REPAIRED IAW SRM 53-00-01-2R-9 REPAIR 9 SECTION II STEP 4, BLIND FASTENER REPAIR. THIS REPAIR IS A CATEGORY C REPAIR. NO FURTHER DEFECTS NOTEDSDR UIEA2025090401158Rivet · damagedFX - STA 140-160 STR 24A R/H 1EA RIVET FOUND LIGHTNING STRIKE. FX - STA 140-160 STR 24A RT 1EA RIVET HEAD LIGHTNING STRIKE REPAIRED IAW SRM 53-00-01-2R-9 REPAIR 9 SECTION II STEP 4, BLIND FASTENER REPAIR. THIS REPAIR IS A CATEGORY C REPAIR. NO FURTHER DEFECTSSDR UIEA2025090401159Rivet · damagedFX - STA 160 STR 24A-26 R/H 1EA RIVET FOUND LIGHTNING STRIKE(<P>FX - STA 160 STR 24A-26 R/H 1EA RIVET HEAD LIGHTNING STRIKE REPAIRED IAW SRM 53-00-01-2R-9 REPAIR 9 SECTION II STEP 4, BLIND FASTENER REPAIR. THIS IS A CATEGORY C REPAIR. NO FURTHER DEFECTS NOTED<SDR UIEA2025090501162Panel · tornLEFT WING INBD L/E UPPER (ILES550-ILES630) PANEL FOUND TORN. PERFORMED TIME LIMITED COMPOSITE REPAIR IAW EA-4457A244, PART 1, REV 0. NO FURTHER DEFECTS NOTED.SDR UIEA2025090601168Light · inoperativeLEFT U/D DOOR EMERGENCY LIGHT INOP. REMOVED & REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-57-04. OPS CHECK GOOD. REF AIPC 24-31-00-50B.SDR AALA202509085717Cradle · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT BRACKET AT 2R AFT IS DAMAGED. REPLACED 2R EMERGENCY FLASHLIGHT HOLDER PER AMM 25-64-00. OK FOR SERVICE.SDR AALA202509082923Module · faultedAIRCRAFT WAS GROUNDED: NUMBER 2 AFT PUMP LOW PRESSURE LIGHT DISAGREES WITH PUMP SWITCH POSITION. REPLACED NUMBER 2 FUEL PUMP LOW PRESS SWITCH SWIR071 PER AMM 28-42-11 (AALA202509085404) AND FUEL SYSTEM MODULE P5-2 PER AMM 28-22-43 (AALA202509085404).SDR AALA202509085404Pressure Switch · faultedAIRCRAFT WAS GROUNDED: #2 AFT PUMP LOW PRESSURE LIGHT DISAGREES WITH PUMP SWITCH POSITION. REPLACED #2 FUEL PUMP LOW PRESS SWITCH (SWIR071) PER AMM 28-42-11 (AALA202509085404) AND FUEL SYSTEM MODULE P5-2 PER AMM 28-22-43. (AALA202509085404)SDR AALA202509081643Elec Connector · dirtyAIRCRAFT WAS NOT GROUNDED: RIGHT ENGINE FUEL FILTER BYPASS ANNUNCIATOR ILLUMINATED SHORTLY AFTER TAKEOFF. COMPLETED QRH PROCEDURE AND ENGINE INDICATIONS WERE NORMAL. CONTINUED TO DESTINATION. EVENTUALLY IT EXTINGUISHED. MAINTENANCE CLEANED CONNECTOR TO DIFFERESDR AALA202509084187Door · openAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO UNUSUAL VIBRATIONS FELT ON THE FLOOR AND RUDDER PEDALS AS WELL AS FRONT AND AFT SERVICE GALLEY DURING CLIMB. AIRCRAFT LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. MAINTSDR AALA202509085984Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY LIGHT AT ROW 1 INOPERATIVE. (OPEN)SDR 3J7R2025090800001Light · dimFORWARD EMERGENCY EXIT LIGHT (SHARK LIGHT) UNDER THE RIGHT WING IS EXTREMELY DIM.SDR SCNA20250908364Light · unsecureROW 12 ABC, EMERGENCY PATH LIGHTING IS BUCKLEING ADHEARED EMERGENCY PATH LIGHTING STRIP TO FLOOR REF AMM 33-51-15 OPS CHECK GOODSDR CALA2025090808594Fuse · failedEMERGENCY LIGHTS AT SEAT 22 25 ABC INOP. FOUND BAD FUSE ON EMERGENCY BATTERY M1670. REMOVED AMD REPLACED FUSE ON EMERGENCY BATTERY M1670 REF AMM 33-51-06-960-801. OPS CHECK GOOD.SDR CALA2025090808593Light · no discrepancyEMERGENCY AREA LIGHT DOES NOT TURN OFF 34C AREA LIGHTS WILL NOT TURN OFF ROW 34. PERFORMED OPERATIONAL TEST OF THE EMERGENCY LIGHTS USING FLIGHT DECK AND AFT ATTENDANT SWITCHES. BOTH TIMES ALL LIGHTS CAME ON AND TURNED OFF CORRECTLY REF AMM 33-51-00-710-801SDR CALA2025090808592Light · inoperativeEMERGENCY LIGHTS AT SEAT 22 25 ABC INOP. REMOVED AND REPLACED F/O SEAT SHOULDER RESTRAINT HARNESS IN REF TO AMM 25-11-39. OPS CHECK GOOD.SDR CALA2025090808589Fuse · inoperativeFLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING LIGHTS INOP FROM SEAT 36 TO 39 TOTAL OF 5 ROW. REPLACED FUSE ON M1673 BATTERY PACK CONTROLLER. OPS CHECK NORMAL. ACFT RETURNED TO NORMAL.SDR CALA2025090808587Bulkhead Web · gougedAFTER RADOME HOLD SUPPORT BRACKET REMOVED, FOUND A GOUGE A T BULKHEAD FRONT FACE SKIN BS 200 LBL 15. ACCOMPLISHED REPAIR ON FWD BULKHEAD FRONT FACE SKIN WITH NO DEVI ARIOUS PER VT MAE EA 757-5310-13-A4089 REV- AND EC/RA #5310-0868 9. DIP BY PAGES CREATED PERSDR CALA2025090808570Tru · dirtyACRID/OZONE BURNING SMELL NOTICED BY ALL CREW MEMBERS ON ENTRY TO AIRCRAFT. TRU COVERED IN DUST, PERFORMED AMM 05-51-26-800-801-C1 PART C. COULD NOT SMELL ANYTHING THROUGH OUT CABIN, ONLY SMELLED A LITTLE IN THE FLT DECK AND E&E. INSPECTED FLT DECK AND E&E TSDR CALA2025090808568None · noneODD SMELL NOTICED BY MULTIPLE CREW MOSTLY IN COCKPIT, GLUEY-ISH IN NATURE UPON INSPECTION FOUND SMELL COMING FROM JET BRIDGE /PC AIR. COULD NOT FIND ANY ISSUES WITH ACFT. INSPECTED E&E BAYS, NO DEFECTS NOTED AT THIS TIME.SDR CALA2025090808567Unknown · odorFA REPORTS ELECTRICAL SMELL COMING FROM CENTER LAV. NO ODOR OR SMOKE PRESENT AT THIS TIME. INSPECTED TRASH CAN FOR ANY EVIDENCE, ELECTRICAL OULET, LIGHTING, AND FLUSH MOTOR OPS NORMAL AMM 05-51-26-800-801-C1.SDR CALA2025090808562Fuel Control · leakingUPON APU START CABIN FILLED WITH FUEL VAPOR. SHUTDOWN APU UPON INSP OF APU FOUND FUEL LEAK FROM APU FUEL CONTROL FOUND APU FUEL CONTROL LEAKING. SHUT DOWN APU AND VERIFIED FUEL LEAK STOPS WITH SWITCH OFF AND BOOST PUMPS. REQUESTING MEL FOR APU INOP. DDP COMPLISDR DALA2025090806594Unknown · odorOILY SMELL FROM BLEED AIR WHEN TURNING ON APU BLEED. VISUALLY INSPECTED APU COMPARTMENT AND APU NO DEFECTS FOUND. .SDR I5PA2025090859302Transceiver · inoperativeRIGHT HF INOPERATIVE. R & R RT HF TRANSCEIVER IAW AMM, OPS CHECK NORMAL.SDR DALA2025090806584Floor Support · damagedCORROSION FLOOR SUPPORT +Y765 AT LEVEL FR68 AT AFT GALLEY AREA. REPLACED FLOORBEAM Y765 BTW FR66 TO FR70 AT AFT GALLEY AREA IAW SRM 51-72-11, SRM 51-42-11, & DWG D53472904. (LP 1185125)SDR DALA2026022301274Seat Track · damagedSHIP 199 SEAT TRACK DAMAGE AT ROW 44GF DAMAGED. CORRECTIVE ACTION: REOAIRED AS PER ERA 628629-14 (1183482)SDR SWI2025F01870Floor Support · corrodedAFT BAGGAGE BAY DOOR FLOOR SILL (FS1000 - FS1047) HAS MULTIPLE SPOTS OF CORROSION (MARKED). (C-CHECK RO 12/24/2025)REMOVED AND INSTALLED NEW AFT BAGGAGE BAY DOOR FLOOR SILL REF. DWG MM670-35085 REV. -A, SRM 51-42-06-001-001-A01, SRM 51-42-10-001-001-A01 ANSDR SWIA202512260905Floorbeam · corrodedCORROSION ON RH FLOORBEAM AT APPROXIMATELY FS954 RBL9. REPAIRED RT FLOORBEAM AT BS 954, RBL 9 IAW REO 690-53-51-514, REV--.SDR SWIA202512190905Fitting · crackedFS 460.00 FITTING IS CRACKED ON THE OTBD SIDE OF LBL 9, FLOORBEAM. REMOVED AND INSTALLED SERVICEABLE FITTING AT BS 460 IAW REO 601R-53-41-3353, REV-. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR K11A2025121500363Skin · crackedREPLACED FUSELAGE SKIN AT STA 907 - 1016, S14R - 20R.SDR SWI2025F01786Door Frame · corrodedFOUND CORROSION ON PAX DOOR FRAME 320.00. REMOVED AND INSTALLED NEW PAX DOOR FORMER FS320.00. IAW SRM 51-42-06-001-001-A01. SRM 51-42-21-001-001-A01. AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKED GOOD. COSDR SWI2025F01785Intercostal · corrodedFOUND CORROSION ON PAX DOOR MID INTERCOSTAL DD6. REMOVED AND INSTALLED NEW PAX DOOR MID INTERCOSTAL DD6. IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKSDR SWI2025F01784Frame · corrodedLOWER FRAME FS310 HAS CORROSION BETWEEN STR 26R - STR 26L. REMOVED AND INSTALLED NEW LOWER FRAME SECTOR FS310 FROM STR 25R TO STR 23L IAW SRM 53-00-06-201-006-A01. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TSDR SWI2025F01783Crossbeam · corrodedRIGHT CROSSBEAM AT BS 280 HAS CORROSION. REMOVED RT CROSSBEAM AT BS 280 IAW SRM 51-42-06-001-001-A01, SRM 51-42-22-001-001-A01 AND SRM 51-42-21-001-001-A01.INSTALLED NEW RT CROSSBEAM AT BS 280 IAW SRM 51-42-06-001-001-A01, SRM 51-42-22-001-001-A01, SRM 51-4SDR SWIA2025120800905Floorbeam · corrodedLEFT CROSSBEAM AT FS 280.00 HAS CORROSION. REMOVED LT CROSSBEAM AT FS 280.00 REF SRM 51-42-06-001-001-A01, SRM 51-42-22-001-001-A01 AND SRM 51-42-21-001-001-A01. INSTALLED NEW LT CROSSBEAM AT BS 280 IAW SRM 51-42-06-001-001-A01, SRM 51-42-22-001-001-A01 AND SSDR VNAA202511270001Seat Track · corrodedCORROSION ON LH SIDE SEAT RAILS LBL 45 (STRG 15LH) BTW FS 785TO FS 847, BTW FS 744 TO FS 785, BTW FS 661+16 TO FS 720, BTW FS 661 TO 549 & BTW FS 379 TO 548 AT PASSENGER CABIN. SEAT TRACK BTW FS 881 TO FS 913, BTW FS 661+16 TO FS 720, BTW FS 661 TO 549 & BTW SDR VNAA202511260010Seat Track · corrodedWEAR AND CORROSION ON RH SIDE SEAT RAILS RBL 45 (STGR 15RH) BTW FS 379 TO FS 394, BTW FS 469 TO FS 581, BTW FS 629 TO FS 661, BTW FS 744 TO FS 761 & BTW FS 785 TO FS 797 AT PASSENGER CABIN. RT SIDE SEAT RAILS RBL 45 (STGR 15RH) BTW FS 379 TO FS 394, BTW FS 46SDR VNAA202511260009Seat Track · corrodedCORROSION ON FLOOR SEAT RAILS BTW FS 881 TO FS 913, BTW FS 661+16 TO FS 720, BTW FS 661 TO 549 & BTW FS 379 TO 548 AT LBL 9 PASSENGER CABIN. CORROSION ON FLOOR SEAT RAILS BTW FS 881 TO FS 913, BTW FS 661+16 TO FS 720, BTW FS 661 TO 549 & BTW FS 379 TO 548 ATSDR VNAA202511260008Seat Track · corrodedWEAR AND CORROSION ON FLOOR SEAT RAILS BTW FS 349 TO FS 364, BTW FS 661+46 TO 661+74, BTW FS 720 TO FS 744 & BTW FS 847 TO FS 977 AT RBL 9 PASSENGER CABIN. FLOOR SEAT RAILS BTW FS 349 TO FS 364, BTW FS 661+46 TO 661+74, BTW FS 720 TO FS 744 & BTW FS 847 TO FSDR AALA202511139204Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK MEMBRANE AT FR 36 AND -Y1292. REPAIRED PRESSURE DECK MEMBRANE PER EA 367885.SDR SWIA20251110905Stringer · corrodedSTGR 24R BETWEEN F.S. 333 AND F.S. 347 IS CORRODED. (FILED CLOSED)REMOVED CORROSION ON STRG 24R FS 333 AND FS 347, EVALUATED WORKED AREA FOUND TO BE OUT OF LIMITS,FABRICATED SECTION OF STRINGER 24R FROM FS 333 AND FS 347 FROM B0530020BF STRINGER EXTRUSION, SDR AALA202510311622Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR BEAM COMMON TO VERTICAL STRINGER 2L AT FR 36, AND Y765, CENTER WING BOX FRONT SPAR, FORWARD CARGO COMPARTMENT. REPAIRED FLOOR BEAM PER EA 367962