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 N6WA2025112003Floor Support · corrodedFLOOR SILL AT FS280-FS319.7 RH HAS CORROSION. REMOVED AND REPLACED RH FLOOR SILL AT FS280-FS319.7 IAW CRJ SRM 51-42-06SDR N6WA2025112002Web · corrodedCORROSION ON LH LOWER WEB AT FS280. REMOVE AND REPLACED LH LOWER WEB AT FS280 IAW CRJ SRM 51-42-06SDR YENA2025112001114Unknown · odorFLT#149, JFK-GND. "STRONG MAGIC MARKER SMELL DESCENDING THROUGH 14800 SMELL DISAPATED AFTER 2 MIN SMELL NOTICEABLE IN COCKPIT AND AFT GALLEY; COMPLIED WITH INFO NOTICE 2017-T015 SECTION A ISOLATED FAULT TO TYPE 10 TRANSIENT ODOR WAS EXPERIENCE FOR A SHORT TIMESDR CALA2025112011374Lavatory · faultedALL A/C LEFT LAVS INCLUDING 3L CENTER LAVS STOPPED WORKING FOUND ALL LAVS ON LEFT SIDE, INCLUDING 3L CENTER LAVS TO BE OPERATING NORMALLY. FOUND LAV H CLOGGED WITH LARGE AMOUNTS OF PAPER TOWELS AND TOLIET PAPER JAMMED IN TOLIET BOWL. REMOVED AND CLEARED CLOG.SDR CALA2025112011363Angle · crackedRIGHT WING TRAILING EDGE, 1 EACH ANGLE CRACKED APPROX. AT WS 270 (APPROX. 8 INCHES I/B OF THE FITTING) REMOVED AND REPLACED ANGLE FITTING PART NO. AAR PO: 1124531.1 IAW BAC DWG 1152930 REV:-, IPC 57-50-00-25. B737-800 SRM 51-40-02-0G-0 AND 51-40-04-0G-0 AT R/SDR CALA2025112011358Mechanism · out of adjustL2 BOARDING DOOR WILL NOT CLOSE KNUCKLE KNOCKER HANGS UP. OTHERWISE DOOR 2L OPERATES AND SLIDE ARMS NORMALLY. REQUEST MEL. DDP COMPLIED WITH. MEL APPROVED FOR KNUCKLE KNOCKER HANGS UP HANGS UP AT DOOR 2L. PLACED IN MEL. *DM* SEE AMM TASK 52-11-20-825-001 & 52-SDR CALA2025112011357Sensor · out of toleranceL1 DOOR INDICATED OPEN DURING CLIMB 5 TIMES. NOT FLICKERING. ON STEADY. NORMAL PRESSURE. HANDLE CL FOUND S199 OUT OF TOLERANCE. ADJUSTED SENSOR TO 21 MILS. LIGHT AND PSEU OPS CHECK GOOD. REF: AMM TASK 52-71-11-820-801.SDR CALA2025112011356Warning Message · false activationCABIN PRESSURE EXCEEDED ON ENGINE SHUTDOWN PRIOR TO OPENING L1 REQUEST DEFERAL APPROVED FOR MEL 5270AF FOUND NO FAULT ON POST FLT DEFERED PER MEL *DM* REF TSM 52-73-00-810-801-C FOR INITIAL T/S. TROUBLESHOT PER TSM 52-73-00-810-801-C, PERFORMED OPS CHECK OF CSDR CALA2025112011355Slide · no discrepancyL1 DOOR SLIDE PACK SEEMS LIKE IT IS HANGING LOW. LIKE TO HAVE MAINT M AKE SURE IT IS OKAY. L1 DOOR SLIDE PACK Z FOLD IS WITHIN LIMITS REF AMM 25-66-01-400-803 ADD EMP: U027741,351445SDR DALA2025111908478Door Frame · fodL3 DOOR WILL NOT ARM. INSPECTED L3 DOOR AND JAM. CLEANED OUT DEBRIS ON JAMB FRAME. OPERATE L3 DOOR AND CLOSED AND ARMED DOOR. OPS CHK GOOD. (7161976)SDR DALA2025111908477Lock · fodAFTER CLOSING 2L MAIN DOOR COULD NOT ARM DOOR FOR DEPARTURE. DOOR ARMING HANDLE APPEARS TO BR JAMMED. REMOVED DEBRIS FROM FWD ARMING LOCK AND REPOSITIONED D= RING . DOOR NOW OPS AND ARMS NORMAL. (7023452)SDR DALA2025111908474Girt Bar · fodR1 DOOR WOULD NOT ARM PRIOR TO PUSHBACK. REMOVED DEBRIS FROM GIRT BAR PROX SWITCH. (8116170)SDR DALA2025111908473Snubber · out of toleranceIN REFERENCE TO STEP 4B (2), LENGTH OF PIN EXTENSION ON THE ROTARY SNUBBER IS NOT CORRECT ON DOOR 1L. ROTARY SNUBBER ON 1L DOOR WAS REPLACED PER AMM 52-11-10. (1310586)SDR DALA2025111908472Deck Plate · corrodedCORROSION OUT OF LIMITS IN REF. TO NRC 00396: CORROSION ON DECK PLATE STA 1681 RBL 13 CABIN FLOOR STRUCTURE AREA IS OUT OF LIMITS PER B757-200 SRM 53-60-51-1A PROCEDURE 2 ALLOWABLE DAMAGE 2, STEP 4 TABLE 2. CORROSION LEVEL 2: DECK PLATE STA 1681 RBL 13 CABIN SDR DALA2025111908471Deck Plate · corrodedCORROSION OUT OF LIMITS IN REF. TO NRC 00396: CORROSION ON DECK PLATE STA 1717 LBL 36 CABIN FLOOR STRUCTURE AREA IS OUT OF LIMITS PER B757-200 SRM 53-60-51-1A PROCEDURE 2 ALLOWABLE DAMAGE 2, STEP 4 TABLE 2. CORROSION LEVEL 2: DECK PLATE STA 1717 LBL 36 CABISDR DALA2025111908470Link · galledNR 1 PYLON DRAG LINK FITTING HOLE 1 HAS GALLING IN HOLE. #1 PYLON DRAG LINK FITTING NO. 1 FASTENER HOLE DISCREPANCY HAS BEEN COMPLIED WITH PER ERA 584851-14AD REV F REMOVED AND INSTALLED IB DRAG FITTING AND REMOVED + INSTALLED NEW SERVICABLE OB DRAG FITTING SDR SWAA2025111936367Flashlight · failedAFT GALLEY EMERGENCY RT INBD FLASHLIGHT NOT TESTING. R & R FLASHLIGHT BATTERY IAW AMM 25-64-00. TESTED OK.SDR SWAA2025111936501Megaphone · no discrepancyFWD MEGAPHONE WEAK. OPS CHECKED FWD MEGAPHONE IAW 25-64-00, OPS CKD NORMAL. OK TO CONTINUE.SDR SWAA2025111936308Girt Bar · unpackedR1 DOOR ESCAPE SLIDE GIRT UNPACKED. REPACKED R1 DOOR ESCAPE SLIDE GIRT IAW AMM 25-66-01.SDR SWAA2025111936314Girt Bar · unpackedL1 DOOR ESCAPE SLIDE GIRT, REPACK REQUIRED. REPACKED L1 DOOR ESCAPE SLIDE GIRT IAW AMM 25-66-01.SDR SWAA2025111936795Slide · dislodgedFWD ENTRY SLIDE FALLING OUT OF CASE. REPOSITIONED L1 DOOR SLIDE AS REQUIRED PER TASK CARD 725-61-06. AIRCRAFT OK FOR SERVICE.SDR SWAA2025111936392Lamp · inoperativeAFT SERVICE DOOR EMERGENCY SLIDE LIGHT INOPERATIVE. REPLACED THE LAMPED AFT SERVICE DOOR EMERGENCY SLIDE LIGHT PER AMM 33-51-04. OPS CHECKS GOOD.SDR SWAA2025111936878Engine · damagedON CLIMBOUT; MULTIPLE BIRD STRIKES. ALL ENGINE INDICATIONS REMAINED NORMAL. RETURNED TO THE DEPARTURER AIRPORT FOR NORMAL LANDING. C/W BIRD STRIKE INSP PER AMM 05-51-18. REFERENCE NEXT LOGPAGE 3053793 FOR DAMAGE FOUNDSDR SWAA2025111936366Lamp · inoperativeLOWER EMERGENCY LIGHT LH SIDE AFT OF FLAP IS INOPERATIVE. REMOVED AND REPLACED LH FUSELAGE LOWER EMERGENCY SLIDE LIGHT LAMP IN ACCORDANCE WITH 33-51-04. OPERATIONAL CHECK IS SATISFACTORY AND NO DEFECTS NOTED.SDR SWI2025F01535Windshield · failedFO WINDSHIELD SHATTERED AT FL340, RAN QRH, NO LOSS OF CABIN PRESSURE. DIVERTED TO DEN LANDED WITH NO OTHER ISSUES (FLIGHT 6203 - FILED OPEN)SDR SWIA2025111900008Skin · dentedREF AML# 1751235: UPON INSPECTION FOUND: 3-OFF AREAS OF DENT DAMAGE TO LT FUSELAGE SKIN PANEL (DWG: MM670-35146, 0.080€? ±0.005€? NOMINAL PAD UP THK, 0.050€? ±0.005€? & 0.060€? ±0.005€? CHEM-MILLED POCKET THICKNESS, REF) BETWEEN FS1015.00 -FS1047.00 ASDR WX0A2025111932640Battery Pack · no test(AIRCRAFT NOT GROUNDED) EPSU (12WL)(13WL) FAILED DURING EPSU BAT CAP TEST. REMOVED AND REPLACED EPSU 12WL AND 13WL REF AMM 33-51-38-400/000-001-A"SDR DALA2025111908464Stringer Fitting · corrodedAFT CARGO P/R: STRINGER END FITTING MARKED FS1053 28R IS CORRODED. REPLACED AFT END FITTING LONGERON 28R PER B717 DWG 5910228 (1310506)SDR DALA2025111908463Longeron Splice · corrodedAFT CARGO BAY BS 1002 L25R END SPLICE CORRODED. REPLACED LONGERON 25R AND FWD END FITTING REF: DACDWG 5919707-521 (1310504)SDR DALA2025111908460Landing Gear · malfunctionedLANDING GEAR DID NOT DEPLOY ALL RED INDICATIONS NO FAULT MESSAGES DISPLAYED. AFTER GO AROUND GEAR DEPLOYED NORMAL ON 2ND ATTEMPT. GEAR HANDLE FULL DOWN HYD PRESS NML, NML DOOR INDICATIONS NO FAULTS ON PSEU BITE IAW B717 FIM 32-60. (8154976)SDR DALA2025111908458Skin · dentedDENT WAS FOUND ON LH WING PANEL 2 UPPER SURFACE AT RIB 22 AND STR 16LH. COMPLIED WITH ER/A 629925-14. (1310683).SDR DALA2025111908456Seat Track · corrodedPASSENGER AFT UTILITY AREA AT -Y=765 BETWEEN FR67+60MM AND FR68 SEAT TRACKWITH CORROSION. REPLACED WITH NEW SEAT TRACK IAW A319 SRM TASK 51-72-11-911-001 PAR 2.A AND A319 SRM 53-41-14-03A. (1310203).SDR DALA2025111908455Seat Track · corrodedPASSENGER CABIN FLOOR STRUCTURE RH O/B SEAT TRACK BETWEEN FR 20 AND FR 21 WITH CORROSION. REPLACED SEAT TRACK RH/ O/B IAW A319 SRM TASK 51-72-11-911-001. (1310334).SDR DALA2025111908459Seat Track · corrodedPASSENGER CABIN FLOOR STRUCTURE RH I/B SEAT TRACK BETWEEN FR 20 AND FR 21 WITH CORROSION. CORRECTIVE ACTION: REPLACED SEAT TRACK IAW A319 SRM TASK 51-72- 11-911-001. (1310230).SDR AALA202511194057Bulb · burned outAIRCRAFT WAS NOT GROUNDED: CEILING EMERGENCY LIGHT OUT AT SEAT 9A. MAINTENANCE RELAMPED CEILING LIGHT EMER LIGHT AT 9A IAW AMM 33-51-03. OPS CHECK GOOD AT THIS TIME.SDR AALA202511199808Actuator · leakingAIRCRAFT WAS GROUNDED: LAV SMOKE DETECTOR WENT OFF AND CABIN FILLED WITH A LIGHT HAZE. SMOKE DISCAPATED AS WE HEADED TO THE GATE. UPON ENGINE #2 INSPECTION MAINTENANCE FOUND UPPER OUTBOARD THRUST REVERSER ACTUATOR LEAKING AND SUSPECTED IT AS SOURCE FOR ODORS. SDR AALA202511198673Wire · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY ESCAPE PATH LIGHT ON SEAT 9H IS INOPERATIVE. MAINTENANCE REPAIRED BROKEN WIRE AND TERMINAL. REPLACED TERMINAL IAW AMM 20-11-02. OPS TEST PASS ON SEAT 9HSDR AALA202511196019Battery · dischargedAIRCRAFT WAS NOT GROUNDED: AFT CREW REST FLASHIGHT INOP. MAINTENANCE FLASHLIGHT BATTERY REPLACED IAW AMM 25-64-01.SDR AALA202511195005Slide · faultedAIRCRAFT WAS GROUNDED: DOOR 1R SLIDE WILL NOT ARM. DIFFICULT TO MOVE SLIDE HANDLE. REPLACED SLIDE ASSY 1R DOOR PER JOBCARD 26L00025011.SDR DALA2025111908445Frame · unknownFRAME 63, STR 5R WAP 6 FWD RT MISSING. CORRECTED PER ERA 628197-14 REV ORIGINAL. (1310583)SDR DALA2025111908444Skin · gougedFOUND 3 GOUGES BELOW AFT CARGO DOOR ON STRINGER 46R, FRAMES 60A, 61, 61A. REWORKED DAMAGED AREAS PER A330 NEO SRM 53-42-11-283-022. (7971596)SDR AALA202511197470Probe · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: TEMPERATURE PROBE LIGHT ILLUMINATED AFTER TAKEOFF. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED TOTAL AIR TEMPERATURE PROBE. PER AMM 34-21-06. OPERATIONAL CHECKED GSDR AALA202511194260Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS UNDER THE FORWARD FLIGHT ATTENDANT JUMP SEAT ARE INOPERATIVE. REMOVED AND REPLACED BOTH (AALA202511197246), (AALA202511194260) EMERGENCY FLASHLIGHTS AT FORWARD FLIGHT ATTENDANTS SEATS. OPERATIONAL TEST NORMAL. PER AMSDR AALA202511192311Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR EMERGENCY EXIT SIGN FELL OFF. REINSTALLED EXIT SIGN AT L1 DOOR. PER AMM 25-00-00.SDR AALA202511197246Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: BOTH FLASHLIGHTS UNDER THE FORWARD FLIGHT ATTENDANT JUMP SEAT ARE INOPERATIVE. REMOVED AND REPLACED BOTH (AALA202511197246), (AALA202511194260) EMERGENCY FLASHLIGHTS AT FORWARD FLIGHT ATTENDANTS SEATS. OPERATIONAL TEST NORMAL. PER ASDR AALA202511198217Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR VERY HARD TO OPEN. LUBED DOOR. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202511194401A/C Pack · contaminatedAIRCRAFT WAS GROUNDED: ENTIRE AIRCRAFT SMELLED LIKE DIRTY SOCKS. ODOR DISSIPATED ABOUT10 MINUTES AFTER TAKEOFF. ODOR WAS STRONGEST IN THE EXIT ROWS IN THE MAIN CABIN. ODOR REAPPEARED WHEN DESCENDING THROUGH 10000FT AND STAYED UNTIL AC PACK SHUTOFF AFTER PARKINSDR DALA2025111908454Angle · corrodedFWD CARGO R/H TRANSITION ANGLE HAS CORROSION FROM STA 490 TO STA 500A. REMOVED AND REPLACED FWD CARGO R/H TRANSITION ANGLE FROM STA 490 TO STA 500A IAW B737-9 SRM 51-40-05 AND SRM 51-40-02.SDR DALA2025111908453Shield · corrodedAFT CARGO RT TRANSITION ANGLE CORRODED STA 767 TO 787+ 8. REMOVED AND REPLACED SHIELD IAW B737-900 SRM 51-40-02.SDR IXXA20251118076Pouch · tornUPPER EMERGENCY ESCAPE HARNESS POUCH TORN. TIME LIMITED ITEM 67991 INITIATED. DUE 04 MARCH 2026. REMOVED AND REPLACED UPPER EMERGENCY ESCAPE HARNESS POUCH IAW SRM 51-40-02. DEFERRAL 67991 CLEARED.