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 SWAA2025121739895Support Angle · elongatedELONGATED HOLE TRAILING EDGE SUPPORT ANGLE LOC AT LEVEL ORSS 250 ON THE LT WING. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, AND SRM 51-20-01.SDR SCNA20251209470Floorbeam · crackedCRACKED PASSENGER FLOORBEAM (2 EAS) ON BS 540, BTW RBL /LBL 2 AT BOX AREA. PASSENGER FLOOR SUPPORTS (2 EAS) ON BS 540, BTW RBL - LBL 2 AT BOX AREA WERE REPLACED IAW SRM 51-40-02-0G-0.SDR 3EJA744JS112525Control Valve · failedAFTER NORMAL LANDING FROM RIGHT SIDE APPLIED BRAKES, ANTI SKID LIGHT CAME ON AND BRAKES DID NOT ACTUATE. R & R ANTISKID CONTROL VALVE P/N ON 9912621-3, S/N ON 868, NEW & BLED BRAKE SYSTEM IAWSDR REXA2025120800999Bearing · damagedFOUND LT AILERON SIDE BEARING LUGS LABELED D & E TO BE PREVIOUSLY OVERSIZED. REPAIRED THE LT AILERON SIDE BEARING LUGS LABELED D & E IAW MHIRJ REO 690-57-61-463 REV --.SDR REXA2025120800998Bushing · damagedFOUND LT AILERON SIDE BUSHING LUG -F- PREVIOUSLY OVERSIZED REPAIRED LT AILERON SIDE BUSHING LUG -F- IAW REO 670-57-61-237 REV.SDR SROM2025120479202Tire · separatedDURING TAKEOFF THE NR 1 MAIN LANDING GEAR TIRE TREAD SEPARATED FROM THE TIRE CASING IN SEVERAL LARGE PIECES AND WAS LEFT ON THE RUNWAY. WHEN THE TIRE TREAD SEPARATED IT CAUSED MINOR DAMAGE (DENTS) TO TWO OF THE SHOCK STRUT FAIRINGS REQUIRING THEM TO BE REPLACSDR SWAA2025120339614Skin · damagedFOUND RT WING TRAILING EDGE OTBD MAIN FLAP LOWER TRAILING EDGE COVE SKIN CREASED OVER FASTENER. IAW SRM 57-53-01-0I-3, TABLE 2, ITEM 5 FOR CLARIFICATION. RT WING TRAILING EDGE OTBD MAIN FLAP LOWER TRAILING EDGE COVE SKIN DAMAGE FOUND TO BE OUT OF LIMITS IAW SSDR DALA2025120308836Oil System · low pressureDIV/IFSD- DIVERTED TO LAX DUE TO RIGHT ENGINE OIL PRESSURE LOSS. ENGINE OPERATED AT ZERO OIL PRESSURE. REPLACED NUMBER 2 ENGINE, OPS CHECK NORMAL.(8171678)SDR DALA2025120308826Skin · crackedCRACK FOUND DURING NDT INSPECTION AT FASTENER HOLE NO 3 (SKIN) AND 4 (SKIN). REPAIR IS REQUIRED BEFORE FURTHER FLIGHT. REPAIRED FWD SERVICE DOOR CUTOUT AFT LOWER CORNER HOLE 3 AND 4 IAW B767-300 SRM 53-10-01 (1322843)SDR DALA2025120308825Bear Strap · crackedCRACK FOUND DURING NDT INSPECTION AT FASTENER HOLE NO 3 (SKIN) AND 4 (SKIN+BEAR STRAP). REPAIRED FWD PAX DOOR CUTOUT AFT LOWER CORNER HOLES 3, 4 IAW B767-300 SRM 53-10-01 (1322829)SDR DALA2025120308824Seat Track · corrodedFOUND SEAT TRACK CORROSION AT STA 1307 TO STA 1329 RBL 88.5 REFER TO CPCP TASK 53-646-00. THE SEAT TRACK REWORKED AREA REPAIRED AS PER PRI 630383-14 (1320320)SDR AALA202512020716Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL FORWARD CORNER SHAPE FITTING AT FR 66 AND S23L. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR AALA202512023026Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUT OUT LOWER SILL OUTBOARD UPPER SPLICE AT FR 66 AND S23R. REPLACED SPLICE PER SRM 51-72-11.SDR IPXA2025112536730Skin · crackedSECTION 17 LOWER SKIN SPLICE REPAIR/REPLACEMENT AND INTERNAL STRUCTURE REPAIR. VERIFIED THAT THE DAMAGE TO SECTION 17 DUE TO THE TAIL STRIKE WAS REPAIRED IN ACCORDANCE WITH AIRBUS WORK CARD 7086383 AND AIRBUS REPAIR DRAWINGS R53970076 ISSUE B AND R53970056 ISDR AALA202512024343Shear Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR SHEET BETWEEN FR 68 AND FR 69 AT S23R. REPLACED SHEAR SHEET PER SRM 51-72-11.SDR K11A2025112500360Warning Light · false activationLEADING EDGE FLAPS TRANSIT LIGHT WOULD NOT EXTINGUISH IN FLIGHT. PERFORMED OPS CHECK OF LEADING EDGE FLAP AND SLAT POSITION INDICATING SYSTEM IAW AMM 27-88-00-215-013. OPS CHECK GOOD AT THIS TIME. FAULT CLEARED AIRCRAFT OK FOR SERVICE.SDR CALA2025120211634Floorbeam · corrodedAFT WET AREA FLOOR STRUCTURE WITH CORROSION AT FLOORBEAM UPPER SURFACE STA947.5 LBL50. REPAIRED FLOORBEAM IAW SRM 53-70-51-2R-5, ESR-WI 14-13120 REV IR AND EC/RA 5370-01206.SDR DALA2025120108775None · noneSHIP 9509 ER/A 623425-14AD REV C REQUIRES STAGE 2 DTA APRPOVAL. C/W ER/A 623425-14AD. (1321407)SDR SWAA2025120139530Girt Bar · out of adjustAFT SERVICE DOOR EMERGENCY SLIDE GIRT BAR HANGING TOO LOW. SECURED THE GIRT BAR IAW AMM 25-66-01.SDR SWAA2025120140009Flashlight · no testEMERGENCY FLASHLIGHT IN THE AFT GALLEY, RIGHT SIDE DOESN`T TEST. OK TO CONTINUE PER MEL 25-12-01, SP#1B. R & R THE EMERGENCY FLASHLIGHT AND BATTERY IAW AMM 25-64-00.SDR SWAA2025120139571Tail Cone · damagedNUMBER 3 FLAP TRACK TAIL ONE HAS FOUR PULLED FASTENERS AND ONE MISSING FASTENER. R & R NR 3 TAIL CONE IAW AMM 27-51-18.SDR SWAA2025120140004Trim Motor · failedMAIN ELECTRIC STABILIZER TRIM FAIL IN FLIGHT. R & R STAB TRIM MOTOR IAW AMM 27-41-71.SDR SWAA2025120140026Cover · looseAFT DOOR ON THE CAPTAIN SIDE GIRT BAR SAGGING. RESECURED MANUAL INFLATION HANDLE COVER IAW AMM 25-66-00.SDR DXTA2025120105841Power Supply · faultedEMERGENCY LIGHTS AT SEATS 14, 12, AND ACROSS FROM SEAT 13 ON THE CREDENZA ARE INOP. ARRIVED TO AC AND POWERED ON AS REQUIRED. WE VERIFIED THE DISCREPANCY FOR THE EMER LIGHTS AND FOUND THE ISSUE TO BE ELPS #4. WE ALLOWED TIME TO CHARGE, BUT STILL NO JOY. WORSDR DXTA2025120105842Squat Switch · faultedAFTER OUR TAKEOFF ROLL, WHEN AT THE INDICATION OF POSITIVE RATE OF CLIMB, THE GEAR HANDLE WAS MOVED TO THE GEAR UP POSITION. THOUGH THE HANDLE WAS EASILY MOVED TO THE UP POSITION THE LEFT MAIN, RIGHT MAIN AND NOSE GEAR DID NOT RETRACT. AT APPROXIMATELY 400 FSDR DXTA2025120105844Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 3, 9, & IN ZONE 3 ON THE WALL, FORWARD OF THE DIVAN ARE INOP. POWERED ON AS REQUIRED. VERIFIED DISCREPANCY & NOTED THAT NR 3 ELPS IS MAIN ISSUE. ALLOW ACFT TO CHARGE IT FOR A HOUR, BUT NO JOY. DISCREPANCY STILL STANDS. MCC HAS ALRESDR DXTA2025120105849Warning Message · false activationDOOR PAX SEAL FAIL CYAN CAS COME ON INFLIGHT AROUND FL300. PERFORMED QRH PROCEDURES NO FURTHER ISSUES. RESET CBS MDPS PRESS XDCR AND MDPS VALVE 1. FOLLOWED MAIN-DOOR PRESSURIZED-SEAL SYS OPS TEST. SEAL PRESSURIZED TO 25.8 PSIG & REGULATED ITSELF. NO LEAKS WSDR DXTA2025120105851Unknown · odorAFTER TAKEOFF, WE BOTH HAD A STRONG SMELL OF BURNING OR FUMES. INCLUDING THE PASSENGERS. RETURNED TO THE FIELD WE BELIEVE IT HAS TO DO WITH A REPLACEMENT OF THE HP VALVE. DOUBLE CHECKED HP VALVE INSTALLATION . NO DEFECTS NOTED. PERFORMED GVI OF PNUEMATICS LISDR DXTA2025120105856Spring · brokenMAIN ENTRY DOOR T-HANDLE COVER RETURN SPRING IS BROKEN OR MISSING. GAINED ACCESS TO MED T-HANDLE COVER SPRING AND INSPECTED FOR ANY DEFECTS. FOUND SPRING UNSECURED, RE-1TACHED SPRING TO THE T-HANDLE COVER PIN. OPS CHECK IS GOOD, NO DEFECTS NOTED. WORK ACCOMPSDR IPXA2025120140366Door Seal · tornCREW ENTRY DOOR SEAL TORN (FAA FINDING). TRIM ENTRY DOOR SEAL TO CLEAR DOOR LATCH MECHANISM IAW DWG 232N1643 SH3. OPS CHECKED NORMAL.SDR CALA2025113011592Light · false activationFWD ENTRY DOOR LIGHT ILLUMINATED ON ROTATION. STAYED ON FOR 2 MI N. PRESSURIZATION NORMAL. POWERED UP AC. NO FWD LIGHT ENTRY ON. NO LATCHED MESSAGES, MX LIGHT OUT.SDR DALA2025113008739Structure · damagedINSPECTION ERA 630590-14AD REV ORIGINAL. REPAIR PART AND HORIZONTAL FLANGES FILLET RADII REQUIRE FOLLOW ON INSPECTIONS PRIOR TO 60,130 TFC AND EVERY 16,200 FC, THEREAFTER. ACCOMPLISH FOLLOW ON INSPECTIONS PER ERA 630590-14AD SECTION II PRIOR TO 60,130 TFC AND SDR AALA202511282943Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL LOCATED FR68 RH SIDE AT AFT GALLEY AREA . MAINTENANCE PERFORMED PERMANENT REPAIR LOWER SILL LOCATED FR68 RH SIDE AT LEVEL STRG 23R AFT GALLEY AREA IAW A320 SRM 51-42-11-801 AND A320 SRM 53-41-14-300-001.SDR AALA202511285743Skin · wornAIRCRAFT WAS GROUNDED: REPAIR DOUBLER REMOVED AND REPLACED PER AARD 57-21-11-1.SDR N6WA2025112802Control Cable · frayedELEVATOR AUTO PILOT CONTROL CABLES FRAYED. REMOVED AND REPLACED ELEVATOR CONTROL CABLES IAW CRJ AMM 27-31-00.SDR 2025F00275Windshield · crackedKVNY TO MMSD. ONE HOUR INTO FLIGHT, RIGHT WINDSHIELD EXTERNAL LAYER CRACKED AT 39,000 FT. CREWS DECLARED PAN PAN PAN AND FOLLOWED QRH. FLIGHT RETURNED TO KVNY AND LANDED UNEVENTFUL.SDR AALA202511280829Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK RIGHT HAND CORNER FITTING AT FR 36 AND -Y1292. REPLACED CORNER FITTING PER EA 368568.SDR AALA202511280666Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK LEFT HAND CORNER FITTING AT FR 36 AND +Y1292. REPLACED CORNER FITTING PER EA 368568.SDR CALA2025112811572Fuel Cap · missingFUEL CAP MISSING REF LOG 7076295. OVERWING FUEL CAP M&E 18-2811-3-0011.SDR CALA2025112811570Adiru · faultyFO SPEED AND ALTIMETER BLANK FO 10 SEC. CLIMB CRUISE AND DESCEN T RETRIEVED LST FLT LEG FAULT. FOUND MULTIPLE FAULTS RELATED TO NR 2 ADIRU. PERFORMED ADIRS BITE PER FIM 34-21/801 AND FOUND NO CURRENT FAULT CODES. CHECKED ADIRS LAST FLT FAULTS AND FOUND CODES SDR CALA2025112811545Shear Tie · corrodedAFT CARGO COMPARTMENT AT FR.1620 STRG.28/2 9L SHEAR TIE EXFOLATED AND WEB HAS EVIDENCE OF CORROSION. REMOVED, FABRICATED AND REPLACED NEW SHEAR TIE AFT CARGO COMP. F R1620 STRG 28/29L IAW SRM 51-40-02.SDR CALA2025112711512Skin · within limitsL1 DOOR EXTERNAL SKIN ADJACENT TO UPPER EXT HANDLE HAS DENT. UPON FURTHER INVESTIGATION OF THE L1 DOOR EXTERNAL SKIN, FOUND TO BE WITHIN LIMITS IAW ESFR 2456 WC:139023.SDR CALA2025112711510Deck Plate · corrodedFWD EDGE OF DECK PLATE STA 1681 AS CORROSION IN SEVERAL SPOTS. MAJOR REPAIR. REMOVED AND REPLACE AFT DECK PLATE PO# 536354 PER DRAWING 146N5300 AND SRM 51-41-02.SDR CALA2025112711508Stringer · crackedINSIDE FUEL PANEL 532RB STRINGER U9 HAS A CRACK IN END OF STRINGER AND APPEARS TO END IN FASTENER HOLE. REPAIRED L/W U9 STRINGER END IAW UAL ECRA 5720-03581 REV ORIGINAL USING FASTENER OPTION C AND UAL AVO INT-11172025-0411-1 WITH NO DEVIATIONSSDR CALA2025112711506Blade · damagedNUMBER 1 ENGINE FAN BLADE FAIRING N6 HAD PART OF THE TRAILING EDGE OF THE FAIRING THAT DEPART THE AIRPLANE. THE PART MISSING IS 8 BY 6 INCHES, (24 SQ INCHES) PERFORMED FOD INSPECTION IAW AMM 72-00-00-210-808-N02, THERE IS NO EVIDENCE OF BIRD STRIKE OR CORE INGSDR CALA2025112711504Skin · corrodedNUMBER 1 UPPER STRUT INBD SIDE NEXT T O PRE-COOLER, WALL INNER SKIN SHOWS SIGNS OF CORROSION. REMOVED CORROSION FROM LWR CHORD ORIGINAL MATERIAL 0.190" THICKN ESS AFTER BLENDING 0.172, 0.018, MATERIAL LOSS WITH IN SRM 54-50- 01-1A-1 LIMITS.SDR ASAA2025112562593Power Supply · failedDURING T/C 78233001, EMERGENCY BATTERY PACK CHARGER M1676 FAILED CHECK. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY BATTERY PACK CHARGER M1676 REF AMM 33-51-06/201. OPS CHECK GOOD.SDR YENA2025112601123Igniter · damagedFLT#2116, SFO-JFK. (ETOPS) "DMG FOUND TO LOWER IGNITER; REMOVED AND REPLACED LOWER IGNITER IAW AMM 74-21-01. OPS TEST OK."SDR WX0A2025112632648Lens · damaged(AIRCRAFT NOT GROUNDED) CABIN EMERGENCY LIGHT(EXIT) OVERWING EXIT MARKERS INOP / INSTALLED NEW CABIN EMERGENCY LIGHT LENS COVER IAW AMM 33-51-13-400-001-A. THIS CLEARS NEF 25-01A-07 MDDR 222838"SDR DALA2025112608650Snubber · leakingNUMBER 2L DOOR SNUBBER LEAKING. REPLACED L2 DOOR SNUBBER IAW AMM 52-11-10 SNUBBER WILL BE INSTALLED ON JOB CARD 5211-6005-2L JOB COMPLETE. (1321772)