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 DALA2025102907915Stringer · damagedSHIP 3413 TOOLING DAMAGE ON STRINGER P'2 JUST FORWARD OF FORWARD SIDE OF 63. CORRECTIVE ACTION: REPAIRED PER ERA 628200-14. (1276803)SDR DALA2025102907914Skin · damagedSHIP 3413 TOOLING DAMAGE ON SKIN BETWEEN FRAMES 60 AND 61 INBOARD OF P1. CORRECTIVE ACTION: REPAIRED PER ERA 628200-14. (1276798)SDR DALA2025102907913Skin · damagedSHIP 3413 TOOLING MARKS ON UPPER FUSELAGE SKIN FORWARD SIDE OF 63 BETWEEN P'1 AND P'2. CORRECTIVE ACTION: REPAIRED PER ERA 628200-14 REV ORIG. (1276598)SDR DALA2025102907910Structure · damagedFOUND LAMINATE DAMAGED IN AFT GALLEY. REPLACED LAMINATE PER A319 AMM 25-31. (1276137).SDR REXA2025102900971Bushing · damagedLEFT WING SIDE AILERON BUSHING LUGS ON HINGE NR 2 (INBD & OTBD) (LABELED C & D) ARE PREVIOUSLY OVERSIZED. ENGINEERING IS REQUIRED. THE LUG LABELED C CURRENTLY INTERNALLY MEASURES (0.9060) & THE LUG LABELED D MEASURES (0.9061). REPAIRED LT WING SIDE AILERON LUSDR AALA202510292890Fuel Sys · out of balanceAIRCRAFT WAS GROUNDED: 4000 POUND FUEL IMBALANCE AT THE TOP OF DESCENT AFTER 10HRS OF FLIGHT. (OPEN).SDR AALA202510297189Anti-Skid Sys · faultedAIRCRAFT WAS NOT GROUNDED: ANTI-SKID INOPERATIVE ON TOUCHDOWN AUTO-BRAKE DISARMED AND ANTI-SKIP INOPERATIVE LIGHT ILLUMINATED. ACCOMPLISHED BITE OF AACU FOUND FAULT FOR XDCR3. OPEN.SDR AALA202510292804Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR LOCK IS VERY DIFFICULT TO OPERATE. LUBED LEFT AFT LAVATORY DOOR. OPERATIONAL CHECKED GOOD.SDR DXTA2025102905488Battery Pack · no testWHEN TESTING EMER LIGHTS IN ARMED IT TOOK TWO CHARGES TO PASS THE TEST. QRH WAS RAN. CORRECTIVE ACTION: REPLACED BATTERY PACK. OPS CHECK GOOD. IAW AMM 33-50-06SDR UIEA2025102801282Fire Warning · false activationCREW REPORTED DURING CRUISE, CARGO FIRE MAIN DECK ZONE 11 EICAS MSG. FOUND MESSAGE 26330/26331 NOT ACTIVE. CREW CONFIRMED NO ACTUAL SMOKE/FIRE ON MAIN DECK. CARGO CONSISTS OF FLOWERS. SMOKE DETECTOR TEST PASSED PER AMM 26-14-01. NO FURTHER DEFECTS NOTEDSDR AALA202510299123Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AVIONICS COMPARTMENT RACK 80VU LEFT HAND LOWER LATERAL FITTING WORN / BURRED. REPLACED FITTING PER EA 367583.SDR AALA202510297585Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AVIONICS COMPARTMENT RACK 80VU RIGHT HAND LOWER LATERAL FITTING WORN / BURRED. REPLACED FITTING PER EA 367583.SDR AALA202510296999Attach Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLIGHT DECK WINDSHIELD FRAME SIDE POST UPPER ATTACHMENT FITTING FASTENER HOLE, AT FR 4 RIGHT. REPLACED FITTING PER SRM 51-72-11.SDR AALA202510290137Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME WEB HORIZONTAL FLANGE AT FR 68 AND S22R. REPAIRED FRAME PER EA 367547.SDR AALA202510295469Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR DALA2025102907908None · noneER/A 567055-14 REV E ISSUED TO ACCOMPLISH REPEAT INSPECTIONS AT HOLES #3-#6 ON FR16 LHS DOUBLE JOGGLE AREA. FOLLOW ON INSPECTIONS ARE REQUIRED. ACCOMPLISH ER/A 567055-14 REV E SECTION IX REPEAT INSPECTIONS AT HOLES #3-#6 ON FR16 LHS EVERY 6,800FC FOLLOWING THESDR SCNA20251029415Girt Bar · incorrectFORWARD ENTRY DOOR ESCAPE SLIDE GIRT IS NOT CORRECTLY TUCKED IN WITH HOOK AND LOOP TO PAN. REPOSITIONED GIRT WITH IN THE CASE AND REATTACHED TO HOOK AND LOOP. REINSTALLED SLIDE ON L1 DOOR REF AMM 25-66-01 RII ACOMPLISHED ON REPACKING AND REINSTALLTION OF L1 SLSDR CALA2025102910712Light · brokenEMERGENCY LIGHT AT SEAT 28 C, BROKEN. REMOVED AND REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-51-11-960-802SDR CALA2025102910680Fuse · no testEMERGENCY LIGHTING SYSTEM OPS CHECK IAW B737-33-3-0235, EMERGENCY AISLE LIGHTS AT SEAT ROWS 29DEF AND 34DEF INOPERATIVE. REMOVED AND REPLACED FUSE OF EMERGENCY EXIT LIGHT BATTERY PACK M3379 IAW AMM 33-51-06-960-804 AND WDM 33-51-13-6.1. OPS CHKD NORMAL.SDR CALA2025102910678Unknown · odorAFTER ARRIVAL & GND AIR CONNECTED, SMOKE ODOR NOTICED IN AFT CABIN. CONCURRED WITH RAMP, REMOVED GND AIR FROM AND DETECTED SOME ODOR. DEBRIEFED BOTH INBD AND OUTBD CAPTAINS, NO ODOR OR SMELL NOTED. REF FIM 21-00 TASK 830. STARTED AND APPLIED APU AIR, RAN BOTHSDR UIEA2025102501280Wire · damagedLH OVERWING EMERGENCY WINDOW EXIT WIRES TO PLUG WERE FOUND DAMAGED WHEN WINDOW WAS REMOVED FOR INSPECTION.(<P>VISUALLY INSPECTED WIRES ON LH OVERWING EMERGENCY WINDOW EXIT, FOUND THE OUTER JACKET OF INSULATION OF TWO WIRES HAVE DAMAGED. REPAIRED INSULATION OF SDR DALA2025102807899Light · damagedSHIP 3305 33H & 58H EMER LIGHT HOUSING DAMAGED UNDER SEAT. REPLACED HOUSING PER A330 AMM 33-51. OK FOR SERVICE. (7921595)SDR DALA2025102807898Skin · gougedSHIP 3429 GOUGE AT AFT CARGO DOOR OPENING SKIN FWD EDGE. REPAIRED PER A330 SRM 53-41-11-283-022. OK FOR SERVICE. (6685150)SDR FDEA202510282101Controller · failedCAC MANF DECAY CK AT FL380. FOLLOWING THE CHECK, LEVEL 1 AVNCS FAN OVRD, AIR SYS 3 OFF, AND AIR SYS 2 OFF. REMOVED AND REPLACED ENVIRONMENTAL SYSTEM CONTROLLER, ADJUSTMENT/TEST PASSED PER ABOVE REFERENCES. REMOVED AND REPLACED ENVIRONMENTAL SYSTEM CONTROLSDR AALA202601146352Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT OTBD LAVATORY MOUNT, LOCATED AT BS 947.5, AT RBL 54. REPAIRED TEE IAW SRM 53-70-51-2R-5.SDR AALA202512307580Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL AREA EMERGENCY EXIT DOOR 834 AFT TRANSMITTING PROFILE IN PASSENGER CABIN (REPLACED UPPER SEGMENT DUE TO EO 5210Y228-001 REQUIREMENT). MAINTENANCE ACCOMPLISHED REPLACEMENT EMERGENCY EXIT DOOR 834 UPPER LOAD TRANSMITTSDR AALA202512303639Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL AREA EMERGENCY EXIT DOOR 834 AFT TRANSMITTING PROFILE IN PASSENGER CABIN, CRACK L= 1.050IN. MAINTENANCE ACCOMPLISHED REPLACEMENT EMERGENCY EXIT DOOR 834 AFT LOAD TRANSMITTING PROFILE IN PASSENGER CABIN I.A.W EO-5210SDR AALA202512301108Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL AREA EMERGENCY EXIT DOOR 834 ON FWD LOAD TRANSMITTING PROFILE IN PASSENGER CABIN, CRACK L = 1.050IN. MAINTENANCE ACCOMPLISHED REPLACEMENT EMERGENCY EXIT DOOR 834 FWD LOAD TRANSMITTING PROFILE IN PASSENGER CABIN I.A.SDR AALA202512302563Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 844 AFT LOAD TRANSMITTING PROFIL IN PASSENGER CABIN (REPLACED UPPER SEGMENT DUE TO EO 5210Y228-001 REQUIREMENT). MAINTENANCE ACCOMPLISHED REPLACEMENT EXIT DOOR 844 UPPER LOAD TRANSMITTING PROFILE LOC. INSDR AALA202512304627Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 844 AFT LOAD TRANSMITTING PROFILE IN PASSENGER CABIN, CRACK L= 1.050IN. MAINTENANCE ACCOMPLISHED REPLACEMENT EXIT DOOR 844 AFT LOAD TRANSMITTING PROFILE LOC. IN PASSENGER CABIN I.A.W EO-5210Y228-001.SDR AALA202512306863Profile · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EMERGENCY EXIT DOOR 844 AFT LOAD TRANSMITTING PROFIL IN PASSENGER CABIN (REPLACED FWD SEGMENT DUE TO EO 5210Y228-001 REQUIREMENT). ACCOMPLISHED REPLACEMENT EXIT DOOR 844 FWD LOAD TRANSMITTING PROFILE LOC. IN PASSENGER CABINSDR SCNA20251028414SGirt Bar · incorrectFORWARD ENTRY DOOR ESCAPE SLIDE GIRT IS NOT CORRECTLY TUCKED IN WITH HOOK AND LOOP TO PAN. REMOVED L1 DOOR ESCAPE SLIDE REF: AMM 25-66-01 OPENED SLIDE PACK AND RE-SECURED HOOK AND LOOP TO SLIDE.CLOSED SLIDE PACK AND INSTALLED L1 DOOR SLIDE PACK ON AIRCRAFT. SDR IPXA2025121485445Channel · corrodedRIGHT MLG WHEEL WELL DOOR CUT OUT OTBD, FWD EDGE SUPPORT CHANNEL HAD EVIDENCE OF CORROSION, APPROX BTW BS 1063 & 1097, LOCATED AND DRILLED RT MLG WW SUPPORT CHANNEL IAW SRM 51-40-05-0G-0 AND SRM 51-40-06-0G-0. OK TO INSTALL NUTPLTES.SDR SWI2025F01863Bulkhead Web · gougedFOUND FS 280.00 RH BULKHEAD CHANNEL GOUGED BETWEEN WL 91.70 & WL 97.80 AND AT RBL 11.05 (C-CHECK RO 12/19/2025)COMPLIED WITH REO 601R-53-11-4035 REV-- 2025-12-07 AND REPAIRED DAMAGE TOFS 280.00 RH BULKHEAD CHANNEL BETWEEN WL 91.70 & WL 97.80 AND AT RBL 11.0.SDR SWIA202512221027Bulkhead Web · damagedFOUND FS 280.00 RH BULKHEAD WEB DAMAGED BETWEEN WL 91.70 & WL 97.80 AND AT RBL 11.05. COMPLIED WITH REO 601R-53-11-4035 REV-- 2025-12-07 AND REPAIRED DAMAGE TO FS 280.00 RH BULKHEAD WEB DAMAGED BETWEEN WL 91.70 & WL 97.80 AND AT RBL 11.05. REFERENCE CP 31122SDR REXA2025121201025Doubler · corrodedCORROSION ON FUSELAGE INTERNAL STRUCTURE ANTENNA DOUBLER BTW FS295.00 / FS310.00 AND STGR 26L / STGR26R AT MAIN AVIONICS COMPARTMENT. CORROSION ON FUSELAGE INTERNAL STRUCTURE ANTENNA DOUBLER BTW FS 295.00 / 310.00 AND STGR26L / STGR 26R AT MAIN AVIONICS COMPASDR REXA2025121201023Seat Track · corrodedCORROSION AND SCRATCHES ON FLOOR SEAT RAIL 9RBL (8 E/AS) AND ON FLOOR SEAT RAIL 9LBL (4 E/AS) ALSO ON FLOOR SEAT RAIL 27LBL BTW FS 969 TO FS 985 AT FLOOR STRUCTURE OF PASSENGER CABIN FLOOR SEAT RAIL 9RBL (5 E/AS ON FS 379 TO 485, FS 485 TO 581, FS 708 TO 7SDR REXA2025121201016Rib · crackedCRACK ON MACHINED RIB OF LEADING EDGE SS27.16 AT RIGHT WING. CRACK ON MACHINED RIB OF LEADING EDGE SS27.16 AT RIGHT WING WAS REPAIRED PER REO 690-57-41-569 REV - -SDR VNAA20251204013Fitting · wornWEAR ON FLAP FITTING AND PLATE SUPPORT OF "FLAP STUB FAIRING" 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING). DUE TO EXCESSIVE DAMAGE ON FLAP FITTING AND PLATE SUPPORT OF "FLAP STUB FAIRING" 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING) WESDR VNAA20251204011Drag Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD/AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM DATUM. CORRECTIVE ACTION: CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT FWD/AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% RESDR CALA2025120311707Web · crackedLT WING REAR SPAR UNDERNEATH FIXED PNL BTW SPOILER 5 & 6 FWD SIDE OF AFT PLATE SHOWS A POSSIBLE CRACK. REMOVED AND REPLACED WEB ASSY AT LT WING REAR SPAR UNDERNEATH FIXED PNL BTW SPOILER 5 & 6 FWD SIDE OF AFT IAW B737-800 SRM 51-40-02-0G-0 AND AIPC 57-50-00-SDR SWAA2025120129129Support · corrodedCORROSION SUPPORT ZEE LOCATED BS 500A TO BS 500D, LBL 24 AND WL156 AT FWD CARGO COMPARTMENT. REPLACED SUPPORT ZEE AND FASTENERS LOCATED BS 480 TO BS 500D, LBL24 AND WL156 AT FWD CARGO COMPARTMENT IAW SRM 51-40-02, SRM 51-10-02 ITEM 9, SRM 53-00-53-2R-6, REPSDR SWAA2025120129121Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 727B TO BS 767, RBL22 AND WL156 AT AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOCATED BTW BS 727B TO BS 767, RBL22 AND WL156 AT AFT CARGO COMPARTMENT IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 146A7500 SHEET 85 REVSDR SWAA2025120129120Shield · corrodedCORRODED SHIELD BETWEEN BS 767 - 787, RBL 22, WL 156. REPLACED WITH A NEW SHIELD IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 146A0081, SHEET 31, REV -.SDR SWAA2025120129119Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 727C - 807, LBL 22, WL156 IN THE AFT CARGO BAY. REPLACED SUPPORT ZEE IAW SRM 51-40-02; SRM 51-10-02, PARAGRAPH 9, SRM 53-00-53-2R-6, REPAIR 6, PARAGRAPH 4, AND DRAWING 146A7500, SHEET 85, REV A.SDR SWAA2025120129116Support Channel · crackedCRACKED SUPPORT CHANNEL, BS 727, STRINGER 27R IN THE AFT CARGO BAY. REPLACED THE SUPPORT CHANNEL IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 144A2600, SHEET 566, REV - .SDR SWAA2025120129201Frame · crackedCRACKED FRAME BS 312 LBL 33 WL 282 ABOVE FWD ENTRY DOOR UPPER SILL WEB. REPAIRED IAW SRM 22-153-01244.SDR SWAA2025120129117Cargo Track · crackedCRACKED TRACK RBBL 13.84, BS 727E. PERFORMED PERMANENT REPAIR ON TRACK, BS 727D+12 AND BS 727E+8. IAW SRM 53-00-53-2R-3, REPAIR 3, PARAGRAPH 4.SDR SWAA2025120129014Pin · corrodedCORROSION ON THE PIN ATTACHED TO THE REAR RT STABILIZER LOWER POSITION. REPLACED PIN IAW AMM 27-41-11-000-801, AND 27-41-11-401-801.SDR SWAA2025120129112Angle · crackedCRACKED ANGLE, BS 907 PLUS 7 INCHES, S26R. REPLACED THE ANGLE IAW SRM 51-10-02, PARAGRAPH 9, AND DRAWING 147A7221, SHEET 24, REV -.