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 AALA202509268801Stop Fitting · wornAIRCRAFT IN BASE MAINTENANCE: L2 DOOR AFT DOOR FRAME STOP PADS WORN. REMOVED AND REPLACED WORN AFT DOOR FRAME STOP PADS. PER AMM 52-13-01.SDR SWAA2025092615615Handle · looseL1 DOOR LINER ASSIST HANDLE LOOSE. SECURED L1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-11-31.SDR SWAA2025092615611Handle · looseR1 DOOR LINER ASSIST HANDLE LOOSE. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR FDEA202509171833Flap · no discrepancyEXISTING DOUBLER REPAIR FOUND ON RH I/B FLAP LWR SKIN BTW RIB17-18, STGR2.7 - 2.8 COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 TP1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.707, EXISTISDR AALA202509261653Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509269576Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509261563Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR CALA2025092509278Pressure Switch · faultedRIGHT HYDRAULIC SYS EICAS & BRAKE SOURCE EICAS ON, WITH NORMAL SYS QTY & PRESSURE. CREW REPORTS BRAKE SOURCE LIGHT INFLIGHT WITH CORRESPONDING RT HYDRAULIC PRESSURE LIGHT. CREW NEVER NOTICED A RT HYD QTY DROP. TURNING OFF RT SIDE ENGINE PUMPS & RE-ENGAGING SDR ASAA2025091761056Transition Panel · corrodedUPON ACCOMPLISHING GVI IN AFT CARGO FOUND LT TRANSITION TO HAVE CORROSION STA 727D TO 747. GROUNDED - YES. REMVOED CORROSION ON TRANSITION PANEL FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED IAW B737-9MAX SRM 53-00-53-2R-5 W= 2 O= .040 R= .034 L= 3 D= .006.SDR ASAA2025091761055Transition Panel · corrodedUPON ACCOMPLISHING GVI IN AFT CARGO FOUND R/H TRANSITION TO HAVE CORROSION STA 727D TO 747. GROUNDED - YES. REMOVED CORROSION TRANSITION PANEL FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED IAW B737 9MAX SRM 53-00-53-2R-5 W=1" O= .040 R= .032 L= 2" D= .008.SDR JJBA20250924037Rib · crackedAT RT WING TO FUSELAGE WHEEL WELL, AFT RIB CRACKED. AT RH WING TO FUSELAGE WHEEL WELL AFT RIB REMOVED AND INSTALLED.SDR CALA2025092409210Floor Support · crackedCRACKED UPPER INTERCOSTAL STRAP AT FWD CABIN STA. 380 BL 0. REMOVED AND REPLACED UPPER INTERCOSTAL STRAP AT STA 380-400 BL 0 AS PER SRM 51-10-02-0G-0 AND DWG 143A5400. REMOVED AND REPLACED UPPER INTERCOSTAL STRAP AT STA 380-400 BL 0 AS PER SRM 51-10-02-0G-0 ASDR DALA2025092306959Light · sparksFIRST OFFICERS READING LIGHT HAS EXPOSED WIRES THAT CAUSED SPARKING DURING FLIGHT. PLACED ON MEL PER ERA 595933-14TR REV A, ERA APPROVED PER DAL P.S. 900-5-1 NO.4. ERA SECT. 1 C/W, PERMANENT REPAIR REQUIRED W/IN 10 DAYS. PLACARDS INSTALLED. RH MAP LT. CB LOCKESDR DALA2025092206924Floor Panel · damagedFWD CARGO FLOOR PANEL DAMAGED. R & R FWD CARGO FLOOR PANEL IAW A319 AMM 53-25. (1204238).SDR UIEA2025091701239Flashlight · inoperativeSUPERNUMERARY FLASHLIGHT NOT CHARGING. REPLACED L2 FLASHLIGHT IAW AMM 25-64-01. OPS CHK SATIS. THIS CLOSES DMI 238292. PLACARD REMOVED.SDR CALA2025092209115Accelerometer · faultedLEFT ENGINE N3 VIB WENT TO 5.0 /AMBER/ TWICE FL380 .78 REDUCED T HRUST N3 STABLE AT .8 AS PART OF OTHER TROUBLESHOOTING, REPLACEMENT OF THE #1 ENG AVM HAS BEEN CARRIED OUT, REF AMM 77-31-04-404-017, OPERATIONAL CHECK OK.ACCELEROMETER REPLACED, AND OPERATIONAL SDR CALA2025092209114Computer · faultedCENTER TANK FLUCTUATE 0 TO 3000 AUTO FEED FAULT FOB CHANGE WITH CENTERFQIC BITE PER AMM28-42-00-740-001-A NO FAULTS INDICATED. LAST LEG REPORT FOR FQIC CH1& CH2 NO FAILURES. CLASS 3 FAULTS CH1 & CH2 L CONDENSICON 19QT, C CONDENSICON 20QT, L CONSENSICON 19QTSDR CALA2025092209090Bulkhead Web · crackedLEFT HAND UPPER PRESSURE DECK IS CRACKED AT STA 640 AND RBL 35 JUST ABOVE GROUND SPOILER CONTROL VALVE. ADDING PHOTOS OF CRACKED AREA, CRACK IS ON RHS OF AC. COMPLETED REPAIR ACCOMPLISHED IAW SRM 53-40-51-2R-2 PG 1-10 FIG 202. REMOVED AND CUT THE WEB DAMAGESDR 3EJA2025092200052Ahrs · failedAHRS 1 FAILED WHILE CLIMBING THROUGH 400 FT. TROUBLE SHOT SYSTEM. SWAPPED #1 AND #2 ECU AND POWERED AVIONICS. BOTH AHRS POWERED UP AND INITIALIZED AS REQUIRED. NO FAULT FOUND.SDR AALA202509215572Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR, 4 STOP PADS ON AFT DOOR FRAME HAVE EXCESSIVE WEAR. REPLACED THE 4 MIDDLE STOP PADS PER AMM 52-41-01.SDR AALA202509209419Pump · faultedAIRCRAFT WAS NOT GROUNDED: DURING TAKEOFF THE NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. MAIN TANKS WERE FULL AS WE HAD FUEL IN THE CENTER TANK. T/S PERFORMED PER FIM 28-22-00-810-805. CONFIRMED TANK 2 AFT BOOST PUMP GFI RELAY RESET BUTTON NOT OUTSDR AALA202509204956Slide · dislodgedAIRCRAFT WAS GROUNDED: AFTER PARKING, WHILE THEY WERE OPENING THE FORWARD ENTRY DOOR, THE CASING FOR THE EMERGENCY EXIT SLIDE CRACKED OPEN AND WEDGED THE SLIDE AND THE GIRT BAR ON THE GALLEY FLOOR, CAUSING THE DOOR TO BE STUCK ABOUT A QUARTER OPEN. REMOVED ANDSDR AALA202509204392Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY-D DOOR IS STICKING, BINDING AND DIFFICULT TO LOCK AND UNLOCK. LUBRICATED UPPER ROLLER TRACK AND DOOR LOCK MECHINISM, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202509207834Striker · lockedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR AUTO UNLOCK SYSTEM NOT WORKING. REMOVED AND REPLACED COCKPIT DOOR ELECTRIC STRIKER. PER AMM 52-51-03. OPERATIONAL CHECK GOOD.SDR AALA202509206151Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ROW 19ABC LOOSE AND DETACHED. REATTACHED AND SECURED EMERGENCY LIGHT AT ROW 19ABC. PER AMM 33-51-00, EMERGENCY LIGHTS CHECKED NORMAL.SDR AALA202509208103Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: THE L2 DOOR AFT ESCAPE SLIDE LIGHT (L732) INOPERATIVE. RELAMPED L2 DOOR ESCAPE SLIDE LIGHT NO HELP. REPLACED EMERGENCY LIGHTING BATTERY PACK (M1673), PER AMM 33-51-06. EMERGENCY LIGHT SOPS CHECK NORMAL.SDR AALA202509205005Light · dislodgedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THAT SEAT 31C EXIT LIGHT IS HANGING ON FLOOR. REPOSITIONED AND SECURED 31C EMERGENCY LIGHT. PER AMM 33-51-11.SDR AALA202509206484Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY DOOR. PER 52-50-00.SDR SWAA2025091915929Light · looseFWD.GALLEY PHOTOILUMINESCENT EMERG. STRIP LOOSE<[01] RE-SECURED LIGHT STRIP PER AMM 33-51-15.SDR SWAA2025091915619Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT WINDOW LIGHT INOP. REMOVED AND REPLACED LEFT OVERWING EMERGENCY LIGHT LAMP PER AMM 33-21-00-960-801-NG. OPS CHECKED GOOD.SDR SWAA2025091915384Light · damagedPHOTOLUMINESCENT LIGHT STRIP HAS INTERNAL MOISTURE L/H ROW 1<[01] REMOVED AND REPLACED STRIP PER M/M 33-51-15.SDR SWAA2025091915381Battery Pack · failedAFT RT EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025091915380Battery Pack · no testFWD L/H EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025091915617Battery Pack · no testEMERGENCY LIGHT RELATED TO BATTERY PACK (M1673) FAIL TEST. REMOVED AND REPLACED EMERGENCY BATTERY PACK M1673 AND TESTED GOOD PER AMM 33-51-06-960-805.SDR SWAA2025091915549Flashlight · no testAFT FA FLASHLIGHT NOT TESTING<[01] OK TO CONTINUE PER MEL 25-12-01. RESEATED AFT FA FLASHLIGHT REF AMM 25-64-00 OPS CHECK GOOD. THIS CLEARS MEL 25-12-01SDR U5QA202509170160Hydraulic Line · looseRIGHT HYDRAULIC SYSTEM QUANTITY WENT TO ZERO MID-FLGHT AT CRUISE ALTITUDE. WHEN FLAPS EXTENDED FOR LANDING AMBER CAS MESSAGE RT HYD SYS PRESS LOW. USED ALTERNATE FLAP EXTENSION PER QRH. DECLARED EMERGENCY. LANDED NORMAL WITH PARTIAL SPOILERS, ONE REVERSER, ANDSDR AALA202509190492Elec Connector · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LT. AT SEAT 13HGED (L/H AND R/H) IS INOPERABLE. FOUND EMERGENCY LIGHT MAIN SEAT CONNECTOR DAMAGED. MAINTENANCE REPLACED CONNECTOR IAW SWPM 20-61-28.SDR 2025FA0000659Drive Shaft · shearedON 9/17/2025, LEAR 60 N491CP DEPARTED KSNA HEADING TO KSAT WHEN THE CREW NOTICED THE RH ENGINE LOW HYDRAULIC PRESSURE LIGHT COME ON. THE PRESSURE INDICATOR WAS INDICATING NORMAL AND AFTER RUNNING THEIR CHECKLIST THEY WERE CLOSE ENOUGH TO ELP, ATI JET HOME BASESDR CALA2025091909063Girt Bar · fodDOOR 1R NOT ARMING, REMOVED DEBRI BETWEEN GIRT BAR AND FLOOR. PERFORMED OPS CK PER AMM 52-11-00, OPS CK GOODSDR CALA2025091909062Sensor · out of adjustFWD SERVICE DOOR DOOR OPEN LIGHT AND MASTER CAUTION DOORS ON SHO RT FINAL FOUND NO DMG TO FWD SERVICE DOOR OR RELATED SENSOR S194, SENSOR S194 READING "TGT FAR" REF FIM 52-10 TASK 801. ADJUSTED SENSOR S194 TO A GAP OF 117 MILS, SAFETIED THE JAM NUTS, OPS CHECKSDR CALA2025091909061Lock · faultedDOOR FLIGHT LOCK 2L EICAS STATUS #2 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. DB PSEU 2 (R2) DB PSEU 2 (L2) FOUND "PASSENGER ENTRY DOOR 2L ACTUATOR HAS A FAULT", MSGS 52-11300, 52-12080 AND 52-12090. VERIFIED ASSOCIATED PASSDR CALA2025091909056Lamp · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-04-960-801, OPS CHECKED GOOD.SDR CALA2025091909053Light · faultyOVERHEAD HORSESHOE EMERGENCY LIGHT OUT AT SEAT 34ABC ADDED PARTS NEEDED NO PARTS SAT PARTS USED: 99-3351-3-0013,QTY :1 REQUEST MEL 3315A FOR OVERHEAD SEAT AISLE EMERGENCY LIGHT OUT TOMC APPROVED PLACED SEAT OVERHEAD HORSE EMERGENCY LIGHT AT SEAT 34ABC ON MEL 3SDR CALA2025091909049Starter Gen · faultedAPU DROPPED OFF LINE PUT THE GENERATORS OFF, BACK ON, THE APU BUSS STRONG SMOKE ODOR. R & R APU STARTER/GENERATOR IAW AMM TASK 49-41-21-400-801 UP TO STEP H,7. FOUND TERMINAL LUGS FOR WIRING HARNESS WITH BURN DAMAGE. ON INSPECTION OF TERMINAL LUGS, FEEDER SDR CALA2025091909048Unknown · odorWHEN SWITCHING FROM ENG BLEED TO APU BLEED RAW GAS FUMES WAS NOTICED. INSPECTED APU AND ENG FOR FUEL LEAKS, NONE NOTED. HAD SAME CREW RUN BOTH ENG AND APU. PERFORMED SHUTDOWN IN SAME SEQUENCE. NO FUMES DETECTED. NO HISTORY OF FUMES. OK FOR SERVICE...SDR CALA2025091909044Window · failedRIGHT AFT #3 COCKPIT WINDOW SHATTERED. REMOVED AND REPLACED R3 COCKPIT WINDOW AS REQUIRED IAW AMM 56-11-21. AERODYNAMIC SEALANT APPLIED IAW AMM 51-31-01-390-806 STEP C.(2)(C). ACFT PRESSURIZED FOR LEAKS, NO LEAKS NOTED.SDR CALA2025091909043Attach Angle · crackedSTATION 663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT APPROXIMATELY RBL 9.0. REPAIRED CRACKED UPPER ATTACH ANGLE AT STATION 663 VAPOR BARRIER AND RBL 9.0 IAW SRM 57-10-10-2R-5 REPAIR 5 AND ACCOMPLISHED FUEL, LEAK CHECK IAW AMM 28-11-00, LEAK CHECK GOODSDR CALA2025091909042Attach Angle · crackedLEFT BS 663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT APPROXIMATELY LBL 9.0 SUPPORT TASK NSA EMX NR 00064 SFR REPORTING ONLY REPAIRED CRACKED UPPER ATTACH ANGLE AT STATION 663 AND LBL 9.0 IAW SRM 57-10-10-2R-5 REPAIR 5 AND ACCOMPLISHED FUEL LEAK CHECK IASDR UIEA2025090401153Stringer · crackedSTA 2360 AFT SIDE STRINGER 22L SUSPECT CRACKED. STRINGER 22L REPAIRED IAW SRM 53-80-03-2R-3, TR53-153, REV 46. NO FURTHER DEFECTS NOTED.SDR UIEA2025090401154Stringer · crackedSTA 2360 AFT SIDE STRINGER 6R SUSPECTED CRACKED. STRINGER 6R REPAIRED IAW RI-53-80-17718 REV A. NO FURTHER DEFECTS NOTED.