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 AALA202512264993Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT-HAND DOOR GIRT BAR FITTINGS REQUIRE ADJUSTMENT. MAINTENANCE ADJUSTED THE GIRT BAR FITTINGS PER AMM 52-13-00.SDR AALA202512260186Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE FLIGHT CREW REPORTING THAT DURING CLIMB OUT, FLIGHT ATTENDANTS REPORTED AN ODOR (DIRTY SOCK SMELL). NO OXYGEN OR EMERGENCY EQUIPMENT USED. THE AIRCRAFT LANDED SAFELY ASDR AALA202512261373Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT-HAND EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPS CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512267292Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED ON LANDING ROLLOUT AT SAN DUE TO THE FLIGHT CREW REPORTING THAT AFTER LANDING AT APPROXIMATELY 60 KNOTS, ECAM MESSAGE AVIONICS SMOKE. NO OTHER INDICATIONS OF HEAT OR FIRE. NO SCENT OF SMOKE IN THE FLIGHT DESDR AALA202512262235Light · no testAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY EXIT LIGHTS ON THE OVERHEAD PANEL NEEDS TO BE RELAMPED. MAINTENANCE REPLACED EMERGENCY EXIT LIGHTS ON THE OVERHEAD PANEL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-18-00.SDR AALA202512262709Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: AFT LEFT-HAND DOOR GIRT BAR FITTINGS REQUIRE ADJUSTMENT. MAINTENANCE ADJUSTED THE GIRT BAR FITTINGS PER AMM 52-13-00.SDR AALA202512269072Striker · brokenAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN WHEN YOU TURN THE KNOB TO THE RIGHT FROM THE INSIDE THE FLIGHT DECK, DOOR SEEMS MISALIGNED. MAINTENANCE FOUND THE FLIGHT DECK DOOR LOWER LATCH BROKEN AND REPLACED THE LOWER LATCH ASSEMBLY PER AMM 52-51-SDR AALA202512269414Pan · bentAIRCRAFT WAS GROUNDED: AFT ENTRY DOOR, EXCESS SLIDE SHOWING, APPEARS SLIDE NEEDS TO BE REPACKED. MAINTENANCE FOUND THE LOWER PAN ON THE AFT ENTRY DOOR BENT CAUSING THE SLIDE TO STICK OUT OF THE COVER EXCESSIVELY. MAINTENANCE REPLACED THE LOWER PAN AND ACCOMPLISDR AALA202512266878Ring · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT ADVISES CREW ON FORWARD SERVICE DOOR THE EXIT SLIDE HAS A WHITE PLASTIC RING THAT HAS PLAY IN IT, ON LEFT SIDE. FLIGHT ATTENDANT CONCERNED SLIDE MAY DEPLOY WHEN DOOR IS OPENED. MAINTENANCE RE-SECURED PLASTIC RING ON SDR AALA202512265490Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR MISSING RED INDICATOR HEAT SHRINK. MAINTENANCE INSTALLED THE HEAT SHRINK TUBING ON THE L1 DOOR GIRT BAR IAW AARD 25-66-00-4.SDR AALA202512266851Snubber · brokenAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND L1 DOOR LOWER SNUBBER BROKEN ON DOOR SIDE. REPLACED SNUBBER AND ACCOMPLISHED A SATISFACTORY OP CHKD PER AMM 52-11-51.SDR GTIA2025122639222Megaphone · inoperativeFWD MEGAPHONE GREEN LIGHT INOP REPORTED BY F/A-REPLACED MEGAPHONE AS PER AMM 25-65-51 MOC 109580SDR DXTA2025122606258Door · malfunctionedMAIN CABIN DOOR HANDLE CANNOT BE MOVED INTO THE CLOSED POSITION. DOOR CANNOT BE CLOSED FROM THE INTERIOR OR EXTERIOR ADJUSTED AFT LATCH PIN IAW AMM 52-10-04. OPS CHECKED GOODSDR SCNA20251226504Brake · overheatedOUTER LEFT MAIN GEAR BRAKE IS SMOKING DURING WALK AROUND. PERFORMED BRAKE INSPECTION REF AMM 32-41-41 NO DEFECTS NOTED OK FOR SERVICESDR SCNA20251226503Lens · deterioratedRIGHT FWD EMERG. EXIT DOOR LIGHT LENS DETERIATED IAW GMM/MTI MDDR #135854.SDR SCNA20251226501Bulb · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED AFT EMERGENCY CEILING BULB REF AMM 33-51-00SDR SCNA20251226500Bulb · inoperativeEMERGENCY LIGHT 10DEF FAILED. REPLACED 10DEF EMERGENCY LIGHT BULB REF AMM 33-51-00.SDR FDEA202512222278Floor Panel · damagedMAIN DECK - THE TOP OF FLOOR PANEL 221DFF IS DAMAGED. FABRICATED NEW FLOOR PANEL 221DFF, MPN: 141T5856-117, LBL 11- LBL 33, STA 285-412 IN REF. TO BOEING DWG 141T5856-117, AND SR67-53-009. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLSDR DALA2025122409404Circuit Board · failedPRESS/DE- DUE TO LOSS OF BOTH PACKS CAUSING PRESSURIZATION LOSS AND OXYGEN MASKS DEPLOYED. REPLACED RT FLOW CONTROL CARD.SDR SWIA2025122400002Steering Sys · faultedSTEERING INOP CAUTION MESSAGE AFTER TAKEOFF. COMPLIED WITH QRH, REQUIRED TOW TO GATE. (FLIGHT 3699 - FILED CLOSED)FOUND RH NLG PROXIMITY SENSOR HARNESS WIRING TO BE INOP. SEE EAML 1779428 FOR REPLACEMENT OF HARNESS. OPS CHECKED NOSE WHEEL STEERING, CHECKED OKSDR KCSA2025122277Door · not closedDOOR F/D OVHD A/T: FOUND F/D OVHD DOOR NOT FULLY SECURED. OPENED & CLOSED OVERHEAD HATCH PER B747-400 AMM 52-21-00. NO DEFECTS NOTED. OK FOR CONTINUED SERVICE.SDR N6WA2025122408Strap · corrodedCORROSION UNDER FWD BELLY FAIRING PANEL 193AR. REMOVED AND REPLACED ATTACH STRAP ON FWD BELLY FAIRING PANEL 193AR IAW CRJ SRM 51-42-13SDR N6WA2025122407Strap · corrodedCORROSION UNDER FWD BELLY FAIRING PANEL 193AL. REMOVED AND REPLACED ATTACH STRAP ON FWD BELLY FAIRING PANEL 193AL IAW SRM 51-42-13SDR JJBA20251224030Battery Pack · inoperativeNUMBER 4 EMERGENCY LIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED THE NR 4 EMERGENCY LIGHT BATTERY PACK. OPS CHECK GOOD.SDR N6WA2025122406Bracket · corrodedRIGHT WING UNDER BURST PANEL BRACKET CORRODED. REMOVED AND REPLACED BRACKET ON RT WING BURST PANEL IAW SRM 51-42-21SDR N6WA2025122405Fitting · corrodedPAX DOOR AFT CLOSING FITTING IS CORRODED. REPAIRED AFT PAX DOOR CLOSING FITTING IAW STS EA 124-2025-117SDR YENA2025122401260Control Unit · failedFLT # 348 LAS-JFK (ETOPS). FCU 2 FAULT. REMOVED AND REPLACED FCU IAW AMM 21-81-12. OPS CHK GOOD. NO DEFECTS NOTED.SDR N6WA2025122404Angle · corrodedCORROSION ON PAX DOOR SILL. REMOVED AND REPLACED CAP ANGLE ON PAX DOOR SILL IAW CRJ SRM 51-42-06.SDR N6WA2025122403Skin · dentedDENT IN LT MIDDLE SKIN PANEL AT BS 202.75 - 220 AT STRINGERS 20-21L. PERFORMED PERMANENT REPAIR OF SKIN PANEL IAW EO-C550-53-112-O.SDR N6WA2025122402Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT ANGLES AT BS 270 - 280. REMOVED AND REPLACED ANGLES ON FLOOR SUPPORT IAW SRM 51-42-06SDR CALA2025122412413Intercostal · crackedE & E BAY, ADJACENT TO CUTOUT DOOR 119BL, RT SIDE, SHIELD PANEL HAS GOUGE. FABRICATED PART IAW PL284N1038. REMOVED, FABRICATED, AND INSTALLED THE TWO PARTS INTERCOSTAL & STIFFNER LOCATED & DRILLED IAW SRM 51-40-05, TREATED, PRIMED IAW SRM 51-20-01 AND INSTALSDR CALA2025122412411Window Frame · crackedRIGHT NR 3 WINDOW FRAME FOUND CRACKED ON HOLES 3 & 4. PERFORMED REPAIR ON THE RT NR 3 WINDOW FRAME IAW EO 250450 REV. P1, P2, P3 AND IR, EA 5310-08195 REV. C, AND ECRA 5310-08750.SDR CALA2025122412408Battery · shortedEMERGENCY EXIT LIGHTS SEAT ROWS 30FED THRU 32FED DO NOT ILLUMINATE. FOUND FLOOR PROXIMITY LIGHT ASSY AT SEAT 31F DISLODGED, R & R FLOOR PROXIMITY LIGHT IAW AMM B737-A-33-51-06-00A-720A-A, NO HELP. REVIEWED THE HEALTH STATUS OF EMERGENCY LIGHT SYS IAW AMM DSDR SWAA2025122354639Skin · crackedEXTERNAL POWER RECEPTACLE DOOR SURROUND STRUCTURE IS CRACKED AT BOTTOM OF OPENING. PERFORMED HFEC OF DAMAGE REMOVAL AND INTERIOR STRUCTURE PER NDT PART 6; 51-00-00 PROCEDURE 23 NO DEFECTS NOTED. ACCOMPLISHED PERMANENT REPAIR PER SRM53-10-15-2R-4, REPAIR 4,SDR SWAA2025122354793Battery · inoperativeFORWARD JUMPSEAT FLASHLIGHT BATTERY DEAD. R & R BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR DALA2025122309391Light · damagedSEAT 18D EMERGENCY LIGHT, FLOOR LIGHT & TRIM DAMAGED. R & R SEAT 18D EMERGENCY ESCAPE PATH LIGHT IAW IPC 33-50. LIGHT OPS GOOD. (7797390)SDR AALA202512232765Bypass Valve · odorAIRCRAFT WAS GROUNDED: BURNT PLASTIC ODOR IN THE CABIN DURING CLIMB. MAINTENANCE REPLACED THE TURBINE BYPASS VALVE 30HH IAW AMM 21-61-53.SDR AALA202512233725Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CHECK DOOR PRESSURE 4R, DISPLAYED ON FA PANEL. MAINTENANCE ACCOMPLISHED SERVICING OF 4R DOOR BOTTLE PER AMM 52-11-14 DOOR BOTTLE PRESSURE NORMAL.SDR SWIA20251223022Warning Message · illuminatedSTEERING INOP CAUTION MESSAGE AFTER TAKEOFF. COMPLIED WITH QRH, REQUIRED TOW TO GATE. (FLIGHT 3699) OPEN.SDR DALA2025122309387Battery Pack · inoperativeAIRCRAFT 3884, EMERGENCY LIGHTS INOPERATIVE FROM ROW 11 - 27. REPLACED THE BATTERY PACKS AT ROW 11 LT & RT, AND ROW 19 LT & RT IAW MM 33-51. (LP 7581140)SDR DALA2025122309386Transition Panel · corrodedAIRCRAFT 3875, FWD CARGO LEFT TRANSITION PANEL FROM BS 500 TO 550L CORRODED. REMOVED AND EVALUATED CORROSION ON FWD CARGO LT TRANSITION ANGLE FOUND DAMAGES BS 500 THROUGH 500LTO BE OUT OF LIMITS. REMOVED AND REPLACED OUT OF LIMITS SECTION IAW SRM 53-0053-2R-5SDR DALA2025122309385Floor Support · corrodedAIRCRAFT 3875, AFT CABIN FLOOR SUPPORT BETWEEN BS 947 AND BS 967, RBL 24 HAS CORROSION. REMOVED AND REPLACED DAMAGE AFT CABIN FLOOR SUPPORT AT RBL24 BETWEEN BS 947 AND BS 967 IAW SRM 51-40-02. (LP 1364257)SDR F3LA202512230338Apu · odorODOR EVENT IN THE DECENT PASSING 8000FT, ODOR ONLY IN-FLIGHT DECK. AIRCRAFT REMOVED FROM SERVICE FOR THIS EVENT. PERFORMED TSM 05-50-000-810-836-A FOUND SOURCE OF FUME TO BE APU. IAW AMM 49-00-00-860-214-A, INSPECTED AND CLEANED AREA NO DEFECTS NOTED. FSDR DALA2025122309384Bottle · low pressureR4 DOOR ASSIST BOTTLE IN YELLOW BAND. SERVICED DOOR BOTTLE PER A330 AMM 52-15. (8007869)SDR DALA2025122309350Power Supply · inoperativeDURING EMERGENCY LIGHTS TEST FOUND MULTIPLE LIGHTS INOP, AND FAULT MESSAGE EPSU (11WL) EMER L. REPLACED EPSU PER REF A321 AMM 33-51-38. (LP 4396068)SDR DALA2025122309349Support · corrodedAIRCRAFT 1002, CORROSION LOWER SILL RH SIDE LOCATED HOLES AT FR 68 AT AFT GALLEY AREA. CORRECTIVE ACTION: PERFORMED PERMANENT REPAIR (ANGLE AND FILLERS) LOC. AT LEVEL FR68RH AT AFT GALLEY ARE AS PER A321 SRM 53-41-14-300-001.SDR FDEA202512232285Floor Support · damagedAFT CARGO COMPARTMENT STRINGER AT B.S. 1260 LBL 10.45 WITH SEVERAL PERFORATIONS (MISDRILLED) AFT CARGO COMPARTMENT STRINGER AT BS.1260 LBL 10.45 WAS REPAIRED IAW B757 SRM 53-00- 53-2R. REPAIR1.SDR FDEA202512222284Crease Beam · corrodedMAIN CABIN. CREASE BEAM. (RH) STA 1200 CORRODED. CORROSION OUT OF LIMITS AT MAIN CARGO COMPARTMENT CREASE BEAM INBOARD CHORD AT STA 1200 RBL 64 WAS REPAIRED IAW B-757 SRM 53-00-13-2RSDR DALA2025122309347Web · corrodedUPPER FUSELAGE, PAX CABIN, RT FR 20 WEB CHANNEL CORRODED. R & R WEB IAW SRM 51-72-11-911-001. (1364464).SDR DALA2025122309346Dummy Rail · corrodedUPPER FUSELAGE, PAX CABIN, RH SIDE FR 16 Y-81 DUMMY RAIL CORRODED. R & R THE DUMMY RAIL IAW SRM 51- 72-11-911-001. (1363951).