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 SWAA2025110330366Light · dimLEFT EMERGENCY EXIT LIGHT IS DIM ABOVE HATCH. R & R THE OVERWING SIDEWALL LIGHT AND LENS PER AMM 33-51-03.SDR SWAA2025110331272Light · dimLEFT EMERGENCY EXIT LIGHT IS DIM ABOVE HATCH. R & R THE OVERWING SIDEWALL LIGHT AND LENS PER AMM 33-51-03.SDR SWAA2025110330365Light · inoperativeRIGHT EMERGENCY EXIT LIGHT IS INOP ABOVE HATCH. R & R THE OVERWING SIDEWALL LIGHT AND LENS IAW AMM 33-51-03.SDR SWAA2025110331273Light · inoperativeRIGHT EMERGENCY EXIT LIGHT IS INOP ABOVE HATCH. R & R OVERWING SIDEWALL LIGHT AND LENS IAW AMM 33-51-03.SDR SWAA2025110330434Wire Harness · disconnectedR1 DOOR, EMERGENCY EXIT SIGN WILL NOT ILLUMINATE. REMOVED AND REPLACED M1675 POWER SUPPLY IAW AMM 33-51-06. NO HELP. REMOVED AND REPLACED M1675 BATTERY IAW AMM 33-51-06. NO HELP. REINSTALLED ORIGINAL BATTERY IAW AMM 33-51-06. FOUND FWD SERVICE DOOR EMERGENSDR SWAA2025110330711Tab · brokenOVERWING EXIT SIGN, FIRST OFFICER`S SIDE, FELL OFF FOUND THE OVERWING CENTER AISLE EXIT LIGHT LENS MOUNTING TAB BROKEN. COMPLIED WITH EA M-24-133-00396.SDR SWAA2025110330315Sign · unsecureAFT GALLEY CEILING EXIT SIGN NEEDS TO BE SECURED. SECURED SCREWS IAW AMM 33-51-01-201-NG.SDR SWAA2025110330548Ring · engagedGIRT BAR FORWARD SERVICE DOOR LOOSE. INSTALLED GIRT BAR STOP RELEASE RING IAW AMM 25-66-01. OPS CHECKED GOOD.SDR AALA202511035881Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DONT PASS TEST DAMPING FUNCTION AND EMERGENCY OPERATION CYLINDER IN PASSENGER CREW DOOR 831 AT FWD GALLEY AREA. MAINTENANCE REMOVED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER.SDR AALA202511039221Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-D DOOR IS STICKING WHEN OPENED AND CLOSED. LUBRICATED DOOR LOCK.SDR AALA202511032395Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LOCK ON FORWARD LAVATORY DOOR IS DIFFICULT TO LOCK AND UNLOCK. LUBED FORWARD LAVATORY LOCK. OPERATIONAL CHECK GOOD.SDR AALA202511032583Handle · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. TIGHTENED DOOR HANDLE.SDR AALA202511035433Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND FLIGHT ATTENDANT SEAT OUTBOARD FLASHLIGHT BRACKET GREEN LIGHT WILL NOT TURN ON. REMOVED AND REPLACED FLASHLIGHT MOUNTING BRACKET. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202511039076Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR. PER CMM 25-40-58.SDR AALA202511031928Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT ENTRY DOOR LEFT GIRT BAR HARD TO DISARM. ADJUSTED L2 DOOR GIRT BAR HOOKS. PER AMM 25-66-01. OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202511038050Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: LEFT AFT FUEL PUMP DOES NOT ILLUMINATE LOW PRESSURE IN THE OFF POSITION. REMOVED AND REPLACED LEFT AFT FUEL PUMP LOW PRESSURE SWITCH. PER MM 28-42-11. OPERATIONAL AND LEAK CHECKS GOOD.SDR AALA202511037432Sign · unsecureAIRCRAFT WAS NOT GROUNDED: 27C EXIT SIGN WILL NOT STAY ON. RESECURED SEAT 27C FLOOR PROXIMITY LIGHT. PER AMM 33-51-11.SDR AALA202511038694Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT ROW LIGHT DETACHED FROM CEILING. RESECURED EMERGENCY EXITS LIGHT BRACKET. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR DALA2025110308037Guard · detachedL1 ENTRY DOOR SLIDE ARMING LEVER GUARD DETACHED. SECURED SLIDE ARMING LEVER GUARD. (7724576)SDR DALA2025110308038Wire · pinchedDIV/DE- TO ORD DUE BURNING RUBBER ODOR AT 32DEF. REMOVED AND REPLACED PSU. FOUND WIRE PINCHED UNDER SEAT 32D, WIRE CAPPED AND STOWED REF ERA 623343-14TR REV ORG.SDR DALA2025110308033Angle · corrodedCORROSION ON ANGLE STA 1020 TO 1040 RBL 65 AT WINGBOX. SUMMARY OF NRC 00511. CORROSION LEVEL 2. ANGLE STA 1020 TO 1040 RBL 65 AT WINGBOX WAS REPLACED PER B757-300 SRM 53-00-13-2R PROCEDURE 2 REPAIR 2. (1282343)SDR DALA2025110308032Fitting · out of adjustA.A 2561-01257-01B STEP 14.B M NIMUM ENGAGEMENT BELOW OF 0.37 INCH AT FORWARD FLOOR FITTING ON GIRT BAR OF R1 DOOR. SUMMARY OF NRC 00021: R1 GIRT BAR ENGAGE TESTS WERE PERFORMED PER AMDS 2561-01257-01B FROM STEP 10 TO STEP 14. TESTS WERE SATISFACTORY. (12819SDR DALA2025110308031Fitting · out of adjustA.A 2561-01257-01D STEP 12B. / 14.B MINIMUM ENGAGEMENT BELOW OF 0.37 INCH AT FORWARD AND AFT FLOOR FITTING ON GIRT BAR OF R2 DOOR. SUMMARY OF NRC 00022: R2 GIRT BAR ENGAGE TESTS WERE PERFORMED PER AMDS 2561-01257-01D FROM STEP 10 TO STEP 14. TESTS WERE SATISSDR WX0A2025110332621Megaphone · inoperative(AIRCRAFT NOT GROUNDED) AFT MEGAPHONE INOP. REMOVED AND REPLACED AFT MEGAPHONE IAW AMM 25-65-51-710-002-A, OPS CHECK GOOD."SDR ABXA20251031288Speed Brake · faultedDURING LANDING, AUTO DEPLOYMENT SPEED BRAKE ON THE GROUND INOP, NO LIGHTS OR EICAS MESSAGES. DEFERRED AUTO SPEEDBRAKE IAW MEL 27-62-1-1. CLEANED DEBRIS FROM SPEED BRAKE NO BACK CLUTCH ASSEMBLY. AUTO SPEED BRAKES CHECK GOOD PER B767 AMM 27-62-00. DI & PLACARDSDR ABXA20251031284Window · crackedDURING CRUISE, NOTICED R1 WINDOW ELECTRICAL ARC FOLLOWED BY R FWD WINDOW CAUTION MSG FOLLOWED BY SPIDER WEB CRACKING IN R1 WINDOW. EMERGENCY DECLARED. AIR TURN BACK TO CVG. REMOVED AND REPLACED R1 WINDOW ITEM CONTROLLER IAW B767 AMM 30-41-01. OPS CK GOOD. SDR DALA2025110308020Sign · detachedSHIP 3325 2L EXIT HOUSING SIGN HANGING BY ONE SIDE. CORRECTIVE ACTION: REMOVED AND REPLACED EXIT LOCATION SIGN HOUSING PER A330 AMM 33- 51. OPS GOOD. (7680198)SDR DALA2025110308016Frame · damagedSHIP 3418 5 COUNTER SINKS HAVE CHATTERED COUNTER SINKS AND 3 OUT OF THE 5 HOLES ARE EXTRA HOLES THAT ARE NOT ON THE DRAWING. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11-00. (1281584)SDR IXXA20251031070Escape Rope · unsecureCAPTAIN'S ESCAPE ROPE DOOR WILL NOT LATCH. OPERATIONAL CHECK OF CAPTAIN'S ESCAPE ROPE COVER IN ACCORDANCE WITH B767 AIRCARFT MAINTENANCE MANUAL 25-60-00 NOTED NO FAULTS.SDR IPXA2025110352856Door · inoperativeL FWD ENTRY DOOR INDICATED OPEN WHEN IT IS CLOSED AND LOCKED ENTRY DOOR CLOSED SENSOR AND VISUAL WIRING INSPECTED FOR DAMAGES. NO FINDINGS. ENTRY DOOR CLOSED SENSOR FOR CORRECT ADJUSTMENT VERIFIED I.A.W. AMM 52-51-00-825-141 REV. 146. CREW ENTRY DOOR OPERATED SDR IXXA20251031069Escape Reel · unraveledNR 4 DESCENT DEVICE FOUND UNRAVELED INSIDE STORAGE BOX. PLACED ON DEFERRAL 67494 MINIMUM EQUIPMENT LIST 25-61-01-01 CATEGORY C. DUE 10 NOVEMBER 2025. REMOVED AND REPLACED #4 DESCENT DEVICE IN ACCORDANCE WITH B767 AIRCRAFT MAINTENANCE MANUAL 25-61-04. DEFERRAL SDR CVGA20251103001Flap System · failedFLAPS FAILED AT 5° ON APPROACH INTO KLAS. DECLARED EMERGENCY. REMOVED FAILED FLAP CONTROLLER AND INSTALLED A TESTED FLAP CONTROLLER IAW CE-750 AMM 27-51-00. OPS CHECK GOOD. NO DEFECTS NOTED. PN OFF/ON 6718328-1 SN OFF: 301 SN ON 117.SDR FDEA202510312119Skin · delaminatedDELAMINATION IN LEADING EDGE 8 INCHES FROM THE RIGHT SIDE FACE, OUTBOARD FLAP, LEFT WING LEFT, WING OUTBOARD FLAP LEADING EDGE, 8 INCHES FROM THE RIGHT SIDE FACE WAS REPAIRED IAW B767 SRM 57-53-01-2R REPAIR 1 FIG. 201 SHEET 5 TABLE I AND B767 SRM 51-70-03-SDR FDEA202510312118Floor Panel · damagedDEGRADED PREVIOUS REWORK ON MAIN DECK FLOOR ACCESS PANEL 222 AFF. FLOOR PANEL 222 AFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV. 93 AUG 15,2025SDR DALA2025110308009Fairing · damagedRIGHT BELLY FAIRING #192KB HAS COMPOSITE DAMAGE. COMPLIED WITH ER/A 597056-14. (1281022).SDR DALA2025110308008Stop Pad · wornWEAR ON PASSENGER CREW DOOR 842 STOP PAD FWD POSITION 2 - 4 AND A FT POSITION 1 - 2 - 4 IN PASSENGER CABIN. REPLACED PASSENGER CREW DOOR 842 STOP PAD FWD POSITION 2-4 AND AFT POSITION 1-2-4 IN PASSENGER CABIN (5 EA) AS PER A320 FAM AMM 52-13-31-000-002-A ANDSDR DALA2025110308003Plate · crackedCRACK INTERNAL STRUCTURE PLATE LOCATED BTW FR 68 TO FR 69 AND LEVEL S TR 23L AT AFT GALLEY AREA. REPLACED PLATE AND FASTENERS LOCATED BTW FR 68 TO FR 69 AND LEVEL STR 23L AT AFT GALLEY AREA AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1282414).SDR DALA2025110308002Pin · brokenSHIP 3153 BROKEN PIN ON CONECTOR ON OFFWING SLIDE LH. CORRECTIVE ACTION: R/R OFFWING ESCAPE SLIDE LH SIDE IAW AMDS CARD 2562-4001. (1282257).SDR DALA2025110308001Floorbeam · corrodedCORROSION FLOOR STRUCTURE BEAM LOCATED AT FR 20 AND -Y 765 FWD GALLE Y AREA. REPLACED FLOOR BEAM -Y 765 AND FASTENERS AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1281862).SDR GTIA2025110339164Flashlight · no testL2 FA FLASHLIGHT NOT TESTING.-R/R FA FLASHLIGHT IAW CMM 25-60-13SDR UIEA2025110301291Oven · smokeOVEN NR 2 RIGHT GIVES A LOT OF SMOKE. OVEN OPS CHK OK IAW AMM 25-32-00</P>)SDR SIMA20251031001Seat Track · corrodedCORROSION FOUND AT AFT SEAT TRACK AT FR 84-85, Y-10. (MAJOR REPAIR) (LEVEL 2 CORROSION) BLENDED CORROSION ON AFT LH SEAT TRACK AT FR84-85 AND Y= -10? PER EMB 175 SRM 51-10-03. BLENDED AREA MEASURES (L: 3.5? W: .50? D: .023?) AND IS FOUND TO BE OUT OF ALLOWABLESDR SIMA20251031002Glowstrip · fadedEMERGENCY PHOTOLUMINESCENT STRIP AT 1A-2A SERVERLY FADED RAR EMERGENCY PHOTOLUMINESCENT STRIP AT 1A-2A IAW ERJ 170 AMM 33-50-21/400 OPS CHK GOOD NO DEFECTS NOTEDSDR DXTA2025110305510Nut · looseMAIN CABIN DOOR DIFFICULT TO CLOSE, HANDLE BINDS AND CATCHES ON CLOSING. DIFFICULT TO OPEN AS WELL. PINS MOVE FREELY WHEN DOOR IS OPEN. NOTICED THAT THE PRECATCH RESET SHAFT HANDLE WAS SPINNING AND LOOSE. THIS SEEMS TO AFFECT WITH THE DOOR HANDLE BINDING. ACSDR DXTA2025110305512Battery Pack · defectiveEMERGENCY LIGHTS ARE STAYING ILLUMINATED IN THE ARM POSITION. REPLACED BATTERIES. OPS CHECK GOOD. IAW AMM 33-52-01/400SDR DXTA2025110305525Starter Gen · faultedGEN 1 OFF BUS YELLOW CAS IN FLIGHT WITH ASSOCIATED VIBRATION. RAN CHECKLIST AND EVENTUALLY SHUT DOWN LEFT ENGINE PER QRH. PERFORMED UNEVENTFUL ONE ENGINE INOPERATIVE LANDING AND SHUT DOWN OPERATING ENGINE. CORRECTIVE ACTION: REMOVED STARTER PN: 400SG180Q-6 SN SDR R61A2025110300488Skin · crackedFOUND RH WING LOWER SKIN CRACKED BETWEEN RIB 16 AND 17 JUST AFT OF FWD SPAR. REPAIRED IAW ETD2025-170-931337 ALSO REF VP-044599-2025 N/R 1 FOR WORK ACCOMPLISHED.SDR DXTA2025110305507Battery Pack · no testFAILED EMERGENCY LIGHTS TEST. SEAT SIX AND SEAT EIGHT TOE KICK LIGHTS DID NOT TURN ON. OVERHEAD LIGHT ON DEVON AND SEAT 7 DID NOT TURN ON. PERFORMED EMERGENCY LIGHTS FAIL QRH CHECKLIST AND PREFORMED TWO 30 MINUTE CHARGING CYCLES. DUE TO FAILED EMERGENCY LIGHTSDR DXTA2025110305508Striker · out of adjustREPEAT WRITEUP. DOOR HANDLE WILL NOT CLOSE ON MAIN CABIN DOOR. PERFORMED ADJUSTMENT OF THE LATCH STRIKER. OPS CHECKED THE CABIN DOOR WITH IAW AMM 52-10-00. NO DEFECT NOTED.SDR CALA2025110310852Girt Bar · out of adjustL4 DOOR WILL NOT ARM, GIRT BAR WAS CLEANED ON FLOOR AND ADJUSTED MECHANISM IAW AMM 25-66-00. OPS CHECKED ARMED-DISARMED LEVER, DOOR SLIDE WAS SATISFACTORY. OK TO CONTINUE.