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 DXTA2026013006707Bleed Air Sys · contaminatedWHEN TRANSFERRING BLEEDS FROM ENGINES TO APU, A FOUL ODOR IS PRESENT FOR A SHORT TIME. CLEANED OIL IN BLEED AIR SYS AND AC PACK. OPS CHECK GOOD.SDR DXTA2026013006703Cable · out of adjustREPEAT WRITEUP. DURING PREFLIGHT, MAIN ENTRANCE DOOR WILL NOT RELEASE WHEN YOU PULL PRECATCH HANDLE. THERE APPEARS TO BE NO FRICTION AT ALL WHEN YOU PULL PRECATCH HANDLE. PERFORMED CABLE ADJUSTMENT. OPS CHECK GOOD. IAW AMM 52-10-01.SDR SWAA2026012964972Coffeemaker · odorFIRST OFFICER`S SIDE AFT COFFEEMAKER HAD A BAD ODOR. R & R THE AFT OTBD COFFEEMAKER IAW AMM 25-30-01. OPS CHECKED GOOD.SDR SWAA2026012964575Battery · inoperativeONE FWD FA FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM 25-64-00, OPS CHECKED GOOD.SDR SWAA2026012964597Megaphone · damagedMEGAPHONE DAMAGED. REPLACED THE MEGAPHONE IAW SIP.SDR SWAA2026012964857Battery Pack · corrodedAFT GALLEY MEGAPHONE BATTERY PACK CORRODED. REPLACED AFT GALLEY MEGAPHONE IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026012964923Flashlight · inoperativePORTABLE FLASHLIGHT IN THE AFT RT GALLEY INOPERATIVE. REPLACED THE FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026012965235Slide · dislodgedAFT ENTRY L2 DOOR SLIDE DISLODGED. REMOVED & REPLACED IAW AMM 25-66-01-400-801-NG.SDR SWAA2026012964839Smoke Detector · false activationFWD LAVATORY SMOKE DETECTOR ACTIVATED NUMEROUS TIMES ON DESCENT, NO VISIBLE SMOKE, FIRE OF FUMES PRESENT. THE DETECTOR WAS RESET EACH TIME. OK TO CONTINUE IAW MEL 26-16-01 SP1, & SP3. R & R THE FWD LAVATORY SMOKE DETECTOR. OPS CHECKED GOOD IAW AMM 26-14-SDR SWAA2026012964966Smoke Detector · false activationFWD LAVATORY SMOKE DETECTOR ACTIVATED IN CLIMB & DESCENT. RESET BOTH TIMES. NO EVIDENE OF SMOKE OR ODOR. OK TO CONT PER MEL 26-16-01, SP1B, AND SP3. R & R THE SMOKE DETECTOR IAW AMM 26-14-01, OPS CHECKED GOOD.SDR SWAA2026012964883Cover · missingFIRST OFFICER`S SIDE EMERGENCY EXIT DOOR LOWER EMERGENCY LIGHT COVER MISSING. INSTALLED COVER IAW AMM 33-51-00.SDR SWAA2026012964862Lamp · inoperativeRIGHT EMERGENCY LIGHT FWD OF AFT CARGO DOOR, INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-03. OPS CHECKED GOOD.SDR SWAA2026012964832Battery Pack · inoperativeLEFT AFT EMERGENCY ESCAPE LIGHTS INOPERATIVE. REMOVED & REPLACED THE M1670 BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026012964827Power Supply · inoperativeCEILING EMERGENCY EGRESS LIGHTS INOPERATIVE, SEAT ROWS 23 ABC, 19 ABC, 15 ABC. REMOVED & REPLACED THE POWER SUPPLY & BATTERY PACK IAW AMM 33-51-06.SDR SWAA2026012965762Power Supply · inoperativeCEILING EMERGENCY EGRESS LIGHTS INOPERATIVE, SEAT ROWS 23 ABC, 19 ABC, & 15 ABC. REMOVED & REPLACED THE POWER SUPPLY, & BATTERY PACK IAW AMM 33-51-06.SDR SWAA2026012964965Cover · detachedDURING PREFLIGHT, OVERHEAD EXIT LIGHT FOUND DETACHED FROM ITS MOUNT. ATTACHED THE EXIT COVER IAW AMM 33-51-01.SDR SWAA2026012964801Charger · inoperativeEMERGENCY LIGHT AFT OF LT WING WAS INOPERATIVE. R & R LT EMERGENCY LIGHTING BATTERY CHARGER AT ROW 20 IAW MM 33-51-06.SDR SWAA2026012964723Lens · chippedEMERGENCY EXIT LIGHT LENS CHIPPED AT SEAT ROW 8 ABC. R & R THE EMERGENCY LIGHT LENS COVER IAW AMM 33-51-03.SDR SWAA2026012964903Sill Drain · odorHORRIBLE SULFUR ODOR COMING FROM FWD FLOOR DRAINS ON EACH SIDE OF AFT GALLEY. THE ODOR WAS INTERMITTENT WHILE ACFT OPERATING. ONE FLT ATTENDANT GAGED. FLOOR DRAINS ON FLOOR ON FAR SIDE OF GALLEY NEXT TO GIRT BARS. PERFORMED AFT SILL DRAIN FLOAT VALVE CLEANSDR GTIA2026012939261Floor Support · corrodedCORROSION FLOOR BEAM -Y1292 LOCATED FR.12 TO FR. 24 AT FWD GALLEY AREA. RAF-01 6007467-01 CREATED.-REMOVED AND REPLACED -Y1292 BETWEEN FR.12 TO FR.24 AT FWD GALLEY AREA IAW SRM 51-72-11 SRM 51-42-11 DWG D53135205, D53212367 AND D533136085SDR YENA2026012900085Door Frame · ground damageDURING HEAVY MAINTENANCE: FWD CARGO DOOR HIT BY BAG LOADER. DAMAGE FOUND TO DOOR JAM UPPER CORNERS AND CARGO BAY DOOR LOWER AFT CORNER; REF AVIANOR WO# JB-3139-AOG-01. NR# 3003. CARRIED OUT DVI OF FWD CARGO DOOR, SURROUND AND ATTACHMENTS, HINGE FITTINGS AND DOSDR DXTA2026012906706Battery · faultedEMERGENCY LIGHTS TURNED ON DURING THE FLIGHT IN THE ARMED POSITION. LATER IN THE FLIGHT, THE EMERGENCY LIGHTS STARTED FLICKERING. REPLACED BATTERIES. OPS CHECKED GOOD. IAW AMM 33-52-01.SDR DXTA2026012906704Battery Pack · faultedTHE EMERGENCY LIGHTS DO NOT FUNCTION WITH THE SWITCH IN THE ON POSITION AND NO OTHER ELECTRICAL POWER ON THE AIRCRAFT. THE EMER LIGHTS DO OPERATE NORMALLY WITH MAIN DC POWER IN BOTH THE ARM OR ON POSITION. REPLACED BATTERIES. OPS CHECKED GOOD. IAW AMM 33-50SDR CALA2026012913431Warning Message · false activationHYD GEN VAL STATUS MESSAGE FOUND C/B RT AC BUS SENSE P11-6 AND CB L AC BUSS SENSE P11-3 PULLED AND COLLARED. RESET CBS RAN HMG TEST REF AMM24-25-01-424-005. TEST PASSED AND NO ACTIVE STATUS MESSAGES.SDR CALA2026012913430Trim System · warning messageL2 STAB FAILURE AFTER TO STAB TRIM MSG WAS LATCHED, FIM 27-40-F1-11A-421A, FIM 27-40-F1-03A-421A. RUN 27 PRIMARY FLIGHT CONTROL STS TEST HORZ STAB. COULD NOT DUPLICATE FAULT. IF MSG DOSE NOT DISPLAY THERE WAS A INTERMMITTENT FAULT. TEST PASSED.SDR CALA2026012913423Light · inoperativeEMERGENCY LIGHT BENEATH SEAT 36C INOPERATIVE. REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY REF AMM 33-51-11 OPS CHECKED GOOD.SDR CALA2026012913422Oil System · leakingAPU FIRE AT GATE AFTER OIL SVC RAN APU TO VERIFY NO SIGNS OF OIL OR FUEL LEAKS REF FIM 49-10341. MECHANIC SAW SIGN OF OIL LEAK WHICH CAUGHT FIRE. C/W APU INSPECTION IAW AMM 49-11-00-04G-311A UPDATED. APU INSP NOTED, NEEDS TO BE C/W REF ASSOCIATED LP 7737965SDR CALA2026012913421Blades · shingledRIGHT N1 VIBRATION OF 5.0 OR HIGHER WITH NOTICABLE VIBRATION. DEBRIEFED CREW. STATED N1 VIBE WAS AT 5.0 THROUGHOUT CRUISE. VIBE DECREASED WHEN POWER ADDED TO ABOUT 3.0 & INCREASED BACK TO AROUND 5.0 WHEN POWER REMOVED. CREW STATED VIBRATION NOTICEBLE PHYSICALSDR DALA2026012900705Oil System · leakingFUMES AFTER LANDING. MODERATE INTENSITY PRESENT IN FLT DECK & FWD CABIN APU ON BLEED OFF. C/W W/C 0550-2002. AFTER NR 1 ENGINE & APU INSPECTION FOUND OIL POOLING AT BOTTOM OF APU GENERATOR AND SIGNS OF DE-ICING FLUID IN APU BAY. IAW MCC REQUEST PERFORMED A LSDR DALA2026012900704Apu · odorDIRTY SOCK SMELL WHEN APU BLEED SELECTED ON. SEE MD-ODI LOG 1420595 FOR WORK PERFORMED AND CORRECTIVE ACTION. (LP: 8035639)SDR DALA2026012900703Unknown · odorDIRTY SOCK ODOR VERY BAD IN CABIN. REF MD-ODI LOG 1420595 AND A/C LOG 8035642. VERIFIED P-TRACK READINGS 6000 DURING ENG RUN AND PACKS OPS FOLLOWING EXTENDED RUNS FOR BOTH. NO FURTHER ODOR NOTED. OK FOR SVC. (LP: 8035645)SDR I5PA2026012768802Starter · faultyAPU FAULT. R & R APU STARTER IAW AMM 49-41-01. OPS CHECKED NORMAL.SDR QMLA2026012720006Sensor · inoperativeNUMBER 2 ENGINE OVSP FAIL DID NOT EXTINGUISH.SDR DALA2026012800696Unknown · odorTRANSIENT SWEET ODOR DURING CLIMBOUT FROM ALB. NO DEICING PERFORMED ON ACFT. SEE MD LOG 1421309 FOR CORRECTIVE ACTION. (LP: 6877290)SDR SWIA2026012775099Actuator · failedFLAPS FAIL CAUTION AT FLAPS 20 COMING INTO ORD (FLIGHT 5402) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31611749. SEE CP 31611779 FOR FLAP FAIL AD SEE CP 31612902 FOR LT FLAP DRIVE LINE TORQUE CHECKED. SEE CP 31612918 FOR REPLACEMENT OF LT FLAP ACTUATOR NSDR AALA202601286222Fuel Sys · faultyAIRCRAFT WAS GROUNDED: LEFT AFT MAIN LOW PRESSURE FUEL LIGHT DOES NOT ILLUMINATE WHEN SWITCH IS TURNED OFF. REMOVED AND REPLACED FUEL SYSTEM MODULE. OPS AND LEAK CHECK GOOD. PER AMM 28-22-43.SDR AALA202601288098Light · missingAIRCRAFT WAS NOT GROUNDED: 11C UNDER SEAT EMERGENCY LIGHT DAMAGED AND MISSING BULB. RELAMPED AND OPS CHECK GOOD. PER AMM 33-51-01.SDR AALA202601287499Connector · inoperativeAIRCRAFT IN BASE MAINTENANCE: SEAT 4BA EMERGENCY FLOOR LIGHTS INOPERATIVE. RESECURED SEAT 4BA EMERGENCY FLOOR LIGHT CONNECTIONS, OPS CHECK GOOD. PER AMM 33-51-11.SDR AALA202601281959Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: SEAT 3AB EMERGENCY FLOOR PROXIMITY LIGHTS FORWARD AND AFT ARE INOPERATIVE RESECURED CONNECTIONS, OPS CHECK GOOD. PER AMM 33-51-11.SDR IPXA2026012892144Window · scratchedMULTI SCRATCHES ON OUTSIDE L2 WINDOW, HARD TO SEE THOUGH NIGHT GLARE. R & R THE L2 WINDOW ASSY IAW AMM 56-11-02-004-001 UP TO STEP D-4.SDR DALA2026012800665Filter · cloggedDURING DESENT AT OR NEAR IDLE POWER THROUGH 12000-10000FT, THERE WAS A CHEMICAL ODOR IN THE COCKPIT. FOUND RECIRC FAN FILTERS COGGLED. R & R THE CABIN RECIRC FILTERS IAW AMM 21-25. NO ODORS PRESENT. OK FOR SERVICE.SDR DALA2026012800663Transmitter · out of adjustPERFORMED GO AROUND & DECLARED AN EMERGENCY DUE TO LEADING EDGE FLAP TRANSIT LIGHT AND TRAILING EDGE FLAPS WOULD NOT GO TO 30. RESET & LANDED, FLAPS 15. PERFORMED FSEU BITE CHECK. NO FAULTS FOUND. PERFORMED LT & RT FLAP POSITION TRANSMITTER ADJUSTMENT IAW AMMSDR DALA2026012800667Battery Pack · inoperativeDURING SVC CHECK, FOUND EMERGENCY DOOR R2 WITH INOPERATIVE EMERGENCY LIGHTS. R & R POWER SUPPLY BATTERY PACK IAW AMM 33-51-06, OPS CHECKED GOOD. OK FOR SVC.SDR AALA202601280787Damper Plate · abnormalAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 832 DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DAMPING FUNCTIONAL TEST. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202601280887Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601283795Cylinder · abnormalAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 842 DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DAMPING FUNCTIONAL TEST. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202601286634Brake Assy · contaminatedAIRCRAFT WAS NOT GROUNDED: DURING TAKEOFF ROLL, LEFT MAIN BREAKS FELT SLIGHTLY GRABBING AND A BRAKE HOT ECAM AFTER TAKE OFF. THE FLIGHT CREW COMPLETED ECAM PROCEDURES. MAINTENANCE ACCOMPLISHED BLEEDING OF THE #1 AND #2 BRAKE PER AMM 32-42-00. A SATISFACTORY TASDR DALA2026012800658Control Cable · frozenRT MLG DOOR WILL NOT OPERATE. FOUND CABLE FROM HANDLE TO DOOR RELEASE FROZEN. R & R CABLE OPS CK GOOD. A/C OK FOR SERVICE. (8450233)SDR DALA2026012800651Fastener · wrong partFRAME 37.3 RT ITEM 0 HAS CHERRY MAX RIVET INSTALLED WHICH IS INCORRECT. CORRECTED PER ERA 631753-14 REV ORIGINAL. (1422412)SDR ABXA20260127030Warning Message · illuminatedDURING TAXI OUT, LEFT ENGINE EICAS, LEFT ENGINE START AND OVERHEAD VALVE LIGHT ILLUMINATED DURING START. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED IAW B767 MEL 80-00-2-1. MBCB 02-06-2026. PLACARD INSTALLED, MAINTENANCE PROCEDURE C/W. A/C REM