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 SWAA2025091707818Floor Panel · peelingMAIN CABIN FLOOR PANEL 231SF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RRTW.SDR SWAA2025091707827Floor Panel · peelingMAIN CABIN FLOOR PANEL 231ZF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSWV.SDR SWAA2025091707836Floor Panel · peelingMAIN CABIN FLOOR PANEL 242CF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RSRB.SDR SWAA2025091707842Floor Panel · peelingMAIN CABIN FLOOR PANEL 241LF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RS4V.SDR SWAA2025091707852Floor Panel · peelingMAIN CABIN FLOOR PANEL 241WF HAS PEELING STRANDS OF FIBER. INSTALLED ON TTG8Q014RST7.SDR 2025FA0000648Autopilot Sys · deactivatedWHEN RETURNING FROM LBX TO LVJ, THE FLIGHT PLAN IN THE G100 CALLED FOR A PRACTICE RNAV 32 APPROACH AT LVJ. WEATHER WAS VFR WITH NO CLOUDS AND LIGHT WINDS. THE AUTOPILOT WAS ACTIVATED IN NAV MODE AFTER COURSE ESTABLISHED. JUST PRIOR TO THE IAF THE APR BUTTON OSDR SWAA2025091607854Floor Panel · peelingMAIN CABIN FLOOR PANEL 241UF HAS PEELING STRANDS OF FIBER. FABRICATED 241UF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A5810 SHT 470 REV:-.SDR SWAA2025091607851Floor Panel · peelingMAIN CABIN FLOOR PANEL 242MF HAS PEELING STRANDS OF FIBER. FABRICATED 242MF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A5810 SHT 465 REV:-SDR SWAA2025091607848Floor Panel · peelingMAIN CABIN FLOOR PANEL 242LF HAS PEELING STRANDS OF FIBER. FABRICATED 242LF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A5810 SHT 459 REV:-.SDR SWAA2025091607847Floor Panel · peelingMAIN CABIN FLOOR PANEL 242KF HAS PEELING STRANDS OF FIBER. FABRICATED 242KF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A5810 SHT 460 REV:-.SDR SWAA2025091607846Floor Panel · peelingMAIN CABIN FLOOR PANEL 242JF HAS PEELING STRANDS OF FIBER. FABRICATED 242JF FLOORBOARD PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A5810 SHT 460 REV:-.SDR SWAA2025091607841Floor Panel · peelingMAIN CABIN FLOOR PANEL 242FF HAS PEELING STRANDS OF FIBER. FABRICATED FLOOR PANEL 242FF IAW SWA SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A510 SHT 453 REV -.SDR SWAA2025091607839Floor Panel · peelingMAIN CABIN FLOOR PANEL 241GF HAS PEELING STRANDS OF FIBER. FABRICATED FLOORBOARD PANEL 24GF IAW SWA SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 146A510 SHT 455 REV -.SDR SWAA2025091607838Floor Panel · peelingMAIN CABIN FLOOR PANEL 241JF HAS PEELING STRANDS OF FIBER. FABRICATED 241JF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG# 146A5810 SHT 453 REV:-.SDR SWAA2025091607817Floor Panel · peelingMAIN CABIN FLOOR PANEL 232LF HAS PEELING STRANDS OF FIBER<[01] FABRICATED FLOOR PANEL 232LF IAW SWA SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 143A5810 SHT 525 REV -.SDR SWAA2025091607849Floor Panel · peelingMAIN CABIN FLOOR PANEL 241SF HAS PEELING STRANDS OF FIBER. FABRICATED 241SF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG# 146A5810 SHT 465 REV:-.SDR SWAA2025091607803Floor Panel · peelingMAIN CABIN FLOOR PANEL 231JF HAS PEELING STRANDS OF FIBER. FABRICATED 231JF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG# 143A5810 SHT 516 REV:-.SDR SWAA2025091607843Floor Panel · peelingMAIN CABIN FLOOR PANEL 241KF HAS PEELING STRANDS OF FIBER. FABRICATED 241KF FLOOR PANEL IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG# 146A5810 SHT 458 REV:-.SDR SWAA2025091607808Floor Panel · peelingMAIN CABIN FLOOR PANEL 231MF HAS PEELING STRANDS OF FIBER. FABRICATED FLOOR PANEL 231MF IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 143A5810 SHT 524 REV -.SDR SWAA2025091607807Floor Panel · peelingMAIN CABIN FLOOR PANEL 232FF HAS PEELING STRANDS OF FIBER. FABRICATED FLOOR PANEL 232FF IAW SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND BAC DWG 143A5810 SHT 516 REV -.SDR SWAA2025091507931Tie Down · corrodedDURING OK TO CLOSE FOUND CORROSION ON FWD WET AREA LAV FITTING STA 312 APPROX LBL 55. REMOVED AND REPLACED TIEDOWN GIRT BAR AT BS 312 LBL 52; WL 208.1 IAW SRM 51-10-02-0G-0; SRM 51-40-02-0G AND DWG 141A5220.SDR HNAA2025091400634Seat Track · corrodedL/H LOWER SEAT TRACK #3 HAS CORROSION IN MULTIPLE AREAS. R&R L/H SEAT TRACK #3 IAW EMB 145 SRM 53-00-11AD AND AMM 53-01-06.SDR HNAA2025091400630Floor Support · corrodedCENTER OMGA BEAM SUPPORT IS CORRODED BETWEEN FR. 52-53. R&R CENTER OMGA BEAM FLLOR SUPPORT BETWEEN FR. 52-53 IAW EMB 145 SRM 51-40-02.SDR HNAA2025091400628Support · corrodedLAV L/H POTABLE WATER CABLE SUPPORT IS CORRODED. R&R LAV L/H POTABLE WATER CABLE SUPPORT IAW EMB 145 SRM 51-40-02.SDR AALA202509114376Handle · detachedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE/RAFT HAS RED PULL HANDLE DETACHING FROM SLIDE. REPLACED SLIDE RAFT ASSEMBLY PER TASK CARD 26C84152006.SDR AALA202509117372Handle · detachedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE HAS RED PULL HANDLE DETACHING FROM SLIDE. REPLACED SLIDE RAFT ASSEMBLY PER TASK CARD 26C83152008.SDR HNAA2025091100610Floor Support · corrodedLH OMEGA BEAM GUSSET HAS PITTING IN NUMEROUS AREAS ALONG ENTIRE LENGTH BTWN FR 23-36. R&R LH OMEGA BEAM GUSSET BETWEEN FR23-36 IAW EMB 145 SRM 51-40-02.SDR R61A2025090900385Fan · faultySTRONG SMELL OF SMOKE IN COCKPIT DURING DESCENT THROUGH 13000 FEET. NO VISUAL SMOKE INDICATION. NO SMOKE SMELL IN THE CABIN. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FIREFIGHTERS DID NOT FIND ABNORMAL HEAT SPOTS. R&R LH RECIRCULATION FAN.SDR AALA202509081503Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 8 INCHES FORWARD OF THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11SDR J7SA2025090400456Fce · faultedDURING CRUISE, JUST PRIOR TO DESCENT, CREW RECEIVED GND SPLR FAIL, PTRIM NORMAL FAIL, AND SPOILER FAULT CAS. AN AMBER ‘X’ ILLUMINATED ON THE PTRIM INDICATOR AND SPOILER INDICATOR. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED FCE NR 2. COMPLETED ELECTRONIC RIGGINSDR 3EJA202509040003Smoke Detector · false activationRED BAGGAGE SMOKE LIGHT ILLUMINATED WHILE DESCENDING FROM 10,000FT. REMOVED NOSE BAGGAGE COMPARTMENT SMOKE DETECTOR AND REPLACED WITH A REPAIRED UNIT. OPS CHECK GOOD. REMOVED AFT BAGGAGE COMPARTMENT SMOKE DETECTOR AND REPLACED WITH A REPAIRED UNIT. OPS CHECK GSDR 2025FA0000617Battery · failedA/C DEPARTED HNL ABOUT 1/2 WAY THRU FLIGHT CREW NOTICED ACRID BURNING ODOR. CREW FIGURED IT WAS A/C BELT SO CONTINUED ON WITHOUT RUNNING THE A/C, SMELL CAME BACK SO CREW TURNED OFF OVERHEAD AIR VENTS. TURNED BACK ON THE AIR VENTS AND SMELL CAME BACK SO CREW DISDR 2025FA0000616Brake Assy · failedWHILE TAXING OUT, RH BRAKE FAILURE. A/C HAD TO BE TOWED OFF TAXIWAY, UPON SPINNING AIRCRAFT WITH TUG PROP STRUCK A GROUND TAXI LIGHTSDR AALA202509026970Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202509029357Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL PLATE AT FR 66 AND S23L. REPLACED SILL PLATE PER SRM 51-72-11.SDR CALA2025090208384Engine · faultyFLIGHT CREW REPORTED AT FLIGHT LEVEL 260 ENGINE 2 WAS HEAR TO HAVE AT LEAST 2 LOUD BANGS FOLLOWED BY THE ENGINE 2 STALL ECAM. FLIGHT ATTENDANTS REPORTED LOUD BANGING AS WELL. EXAMINE ENG 2 EXHAUST AND FOUND METAL PIECES PER TSM 75-30-00-810-828-B WILL REQUIRE SDR DALA2025090206468Door · not seatedAIRCRAFT RETURNED TO ATL DUE TO A CABIN INFLOW MSG. FOUND AFT CARGO DOOR LATCHED BUT NOT SEATED, MAINTENANCE PERFORMED A DETAILED VISUAL INSPECTION AND REPLACED THE AFT CARGO DOOR. OPS AND LEAK CHECK GOOD.(7595084)SDR DALA2025090206465None · noneDTA ER/A 628285-14 SECTION II MONITOR LOG REQUIRES DTA APPROVAL ON OR BEFORE THE NEXT 24 MONTHS AFTER 24-AUG-25. DISCONTINUE REVENUE SERVICE ON OR BEFORE THE NEXT 24 MONTHS AFTER 24-AUG-25 PENDING A DAMAGE TOLERANCE AND FATIGUE REVIEW. ASSOCIATED ER/A 00-628SDR DALA2025083106421Fan · seizedDIV- TO OKC WITH HIGH ENERGY STOP DUE TO ELECTRICAL ODOR IN FLIGHT DECK. ROAD TRIP. C/W HIGH ENERGY STOP INSPECTION. FWD EQUIPMENT COOLING EXHAUST FAN SEIZED. MEL APPLIED.(9870714)SDR DALA2025083106419Light · inoperativeSEAT 42B WHITE EMERGENCY LIGHT INOP. REPLACED BUMPER AND LIGHT ASSY. (7547622)SDR ASAA2025082460418Lens · damagedDURING INSPECTION FOUND EMERGENCY EXIT LENS DAMAGE AT R2 DOOR AFT G4 TRASH COMPARTMENT. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY EXIT LIGHT SSY AT R2 DOOR AFT G4 TRASH COMPARTMENT. OPS CHECKS GOOD IAW B737 AMM 33-51-01-960-802. SRXR430X.SDR CALA2025082908259Skin · corrodedTAIL AREA, APU INLET DOOR FWD SIDE, CUTOUT H AS EVIDENCE OF CORROSION. REPAIRED STRAP FOR THE AUXILIARY POWER UNIT AIR STA 1825.00 BETW EEN STG 3 TO STA 6 R/H IAW B757-200 53-80-15-2R-1.SDR CALA2025082908258Bear Strap · crackedL1 DOOR SUROUND THE 7TH CRITICAL FASTENER HOLE. COUNTING RT TO LT IAW FIGURE -00 2 OF EA5330-04213 REV D, HAD A CRACK INDICATION AT THE BEAR STRAP L AYER. ACCOMPLISHED REPAIR IAW EA 757-5310-A4078 AND EA 5330-04213 REV D. OPERATION 2 & EC/RA # 5330-07569.SDR DALA2025082806374Girt Bar · detachedL-2 DOOR WONT ARM AT DEPARTURE. SLIDING GIRT BAR BLOCK FELL OFF END OF BAR AND WASN'T ENGAGING INTO THE FLOOR FITTING. REINSTALLED. OPS NORMAL, LIGHT KNUCKLE KNOCKER OPS NORMAL REF B757 AMM 52-11. (7047706)SDR DALA2025082806373Bracket · out of adjust2L DOOR WILL NOT ARM AT DEPARTURE. PERFORMED ADJUSTMENT OF GIRT BAR FWD BRACKET REF B757 AMM 52-11. PERFORMED GIRT BAR MECHANISM SYS TEST REF B757 AMM 52-11. ALL CKS GOOD. (1161539)SDR AALA202508281383Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM THE FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11SDR AALA202508284741Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR MISSING RED BAND ON GIRT BAR. REINSTALLED HEAT SHRINK TUBING AT AFT RIGHT HAND DOOR GIRT BAR. PER AARD 25-66-00-4.SDR AALA202508283445Oven · smokeAIRCRAFT WAS NOT GROUNDED: LEFT OVEN IN FORWARD GALLEY STARTS SMOKING WHEN TURNED ON. REMOVED AND REPLACED NUMBER 1 OVEN AT FIRST CLASS GALLEY. PER AMM 25-32-00. OPERATIONAL CHECKS GOOD.SDR CALA2025082808235Unknown · abnormalDURING CLIMB HAD VERTICAL BOUNCING. STARTED AFTER FLAPS UP, STOPPED AT 1ST LE VELOFF, STARTED NXT CL DEBRIEFED CREW THERE WAS CONSTANT VERTICAL BOUNCING DURING CLIMB LESS AT SLOWER SPEED AND GOT WORSE THE FASTER THEY CLIMBED FLAPS UP. CREW TRIED TO ISOLATE SDR CALA2025082808209Pin · installedR4 DOOR; INSTALLED DOOR EMERGENCY SLIDE CYLINDER SAFETY PIN AND EMERGENCY POWER RESERVOIR SAFETY PINS TO FOM. REMOVED SAFETY PINS FROM POWER RESERVIOR AND ESCAPE SLIDE CYLINDER. DOOR R4 HAS BEEN RESTORED TO NORMAL OPERATION. C/W IDT VERIFIED SAFETY PINS REMOV