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 AALA202508113967Printer · failedAIRCRAFT WAS NOT GROUNDED: IN FLIGHT SLIGHT ODOR OF BURNING RUBBER, FLIGHT CREW FOUND ACARS PRINTER INOPERATIVE MESSAGE. NO JAMS FOUND, PRINTER STOPPED WORKING. MAINTENANCE REPLACED THE ACARS PRINTER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 31SDR AALA202508111631Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, LBL 23. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202508114199Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 540, RBL 23. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR JJBA20250811033Skin · dented2 DENTS ON LH CENTER FUSE I SKIN, BTW FR 19-20 AND BTW STR 12L-13L. REPAIR DOUBLER ON LH CENTER FUSE I SKIN, BTW FR 19-20 AND BTW STR 11L-13LSDR CALA2025081107558Pressure Deck · dentedFLIGHT DECK FLOOR HAS DENTS BETWEEN BS 251.5 AND BS 259.5 AND BETWEEN LBL-12 AND RBL-12. REMOVED DAMAGE, ACCOMPLISHED HFEC AND GVI WITH NO DEFECTS NOTED, ACCOMPLISHED INSURANCE CUT, FABRICATED REPAIR PARTS, RESTORED COATINGS AND INSTALLED AND TOP COAT REF HAESDR NACA2025080600002Control Panel · failedFUEL SYSTEM CONTROL PANEL HAS BROKEN KORRY LIGHT. REMOVED AND REPLACED FUEL MANAGEMENT PANEL REF 767-300 AMM 28-22-17 OPS CHECK GOOD.SDR NACA2025080600001Pump · failedLEFT FWD BOOST PUMP DID NOT COME ON WITH SWITCH IN ON POSITION. REMOVED AND REPLACED LH FWD BOOST PUMP REF 767 AMM 28-22-03 OPS CHECK GOOD.SDR DXTA2025080604492Elec Connector · looseTHE LAV FLOOR EMER LIGHT IS INTERMITTENT AND FLICKERS ON AND OFF. ACCESSED AIRCRAFT AND POWERED UP VIA APU. POWERED ON EMERGENCY LIGHTS AND ALL LIGHTS WORKING PROPERPLY INCLUDING LAV FLOOR LIGHTING, WHILE LIGHTS WERE POWERED ON, TAPPED ON TOILET SEAT AND TOILSDR DXTA2025080804502Door · no discrepancyMAIN CABIN DOOR BECOMING VERY DIFFICULT TO LATCH CLOSED. ARRIVED TO THE A/C IN ATTEMPT TO DUPLICATE THE FAULT, CONNECTED THE A/C BATTERIES, CLOSED THE MED FROM THE OUTSIDE WITH EASE. OPENED THE MED, CLOSED FROM INSIDE THE A/C WITH EASE AS WELL. CLEANED AND LUBSDR DALA2025080805950Rod · cockedFLT ATT ADVISE L AFT ENTRY DOOR HANDLE POPPED UP ONCE AIRBORNE. NO EICAS UNTIL AT ALTITUDE. QRH C/W. PRESSURE REMAINED GOOD THROUGHOUT FLIGHT. FOUND FOD IN GIRT BAR BETWEEN LOCK & SLOT. REMOVED FOD. ADJUSTED COCKING ROD IAW AMM 52-11. LUBED GIRT BAR & LATCH SDR DALA2025080805944Skin · damagedTHE EXTERIOR SKIN REPAIR HAS EDGE DAMAGE, AT THE FWD LOWER CORNER OF THE ALC DOOR. #19486. REMOVED DAMAGED EXTERIOR SKIN REPAIR AND REPAIRED FWD LOWER CORNER OF THE ALC DOOR PER ER/A 628081-14.SDR YENA2025080800818Oil System · leakingFLT#257, BOS-BZN. APU OILY ODOR / DIRTY SOCKS AFTER GATE ARRIVAL MILD ODOR IN FLIGHT DECK STRONG ODOR IN AFT CABIN IN GALLEY; COMPLIED WITH INFO NOTICE 2017-T015L SECTION B ISOLATED FAULT TO TYEP 1 EVIDENCE OF OIL LEAK IN APU INLET AREA PER TSM 05-50-00-810-0SDR AALA202508086227Detector · abnormalAIRCRAFT WAS GROUNDED: DOOR LEFT OVER WING EXIT ON ECAM. MAINTENANCE FOUND PROXIMITY SENSORS 31WN1 (AALA202508085712) AND 32WN1 (AALA202508086227) GAPS WERE OUT OF TOLERANCE AND ADJUSTED THEM PER AMM 52-71-00-820-805-A. A SATISFACTORY OPERATIONAL CHECK WAS ACCSDR AALA202508085712Detector · out of adjustAIRCRAFT WAS GROUNDED: DOOR LEFT OVER WING EXIT ON ECAM. MAINTENANCE FOUND PROXIMITY SENSORS 31WN1 (AALA202508085712) AND 32WN1 (AALA202508086227) GAPS WERE OUT OF TOLERANCE AND ADJUSTED THEM PER AMM 52-71-00-820-805-A. A SATISFACTORY OPERATIONAL CHECK WAS ACCSDR AALA202508084723Slide · abnormalAIRCRAFT IN BASE MAINTENANCE: AN OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM POWER SUPPLY UNITS PER AMM 33-51-00 PRODUCED THE FOLLOWING CLASS 1 MAINTENANCE MESSAGES: ESCAPE SLIDE LT/ EPSU (10WL) FWD L, EMER LT/ EPSU (10WL) FWD L, EXIT SIGNS/ EPSU (10WLSDR AALA202508084932Stop Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: R1 SERVICE DOOR LOWER FORWARD DOOR STOP PLATE CRACKED. REPLACED DOOR STOP PLATE PER AMM 52-41-01SDR AALA202508082483Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME WEB HORIZONTAL FLANGE RADIUS AT FR 68 AND S22R. REPAIRED FRAME PER EA 365516A.SDR AALA202508086629Circuit Breaker · closedAIRCRAFT WAS NOT GROUNDED: ON CLIMB OUT FROM KEUG THE AIRCRAFT WOULD NOT PRESSURIZE CORRECTLY. AIRCRAFT WAS PARTIALLY PRESSURIZED WITH DIFFERENTIAL PRESSURE OF APPROXIMATELY 3 DELTA P. THE CABIN ALTITUDE WAS RISING RAPIDLY. CABIN ALTITUDE MAXED AT 11,400 FEETSDR AALA202508087754Apu · odorAIRCRAFT WAS GROUNDED: STRONG MUSTY ODOR COMING FROM THE PACKS ON THE GROUND AND IN THE AIR. MX VERIFIED APU SOURCE, PLACED ON MEL. (OPEN)SDR CALA2025080807493Wire Harness · damagedREMOVE ALL EEPL WIRING FROM CABIN AND EVALUATE CONDITION, CONFORMITY AND SECURITY. SUPPORT TASK NSA EMX N/R 00022. DURING EEPL WIRING EVALUATION, FOUND EEPL SECTION FOR SEAT ROWS 23ABC TO 26ABC DAMAGED REQUIRING REPLACEMENT. REMOVED AND REPLACED DAMAGED EEPSDR CALA2025080807481Lock · brokenESCAPE SLIDE INSTALL. FOUND SLIDE LOCK BROKEN ON SLIDE INSTALLATION INSTALLED NEW LATCH REF AMM 25-66-00.SDR CALA2025080807480Lock · looseDOOR 1L GIRT BAR LOCK NEEDS TIGHTENED UPDATED MAA CODE FIX USING VENDOR MAA SCREEN PLEASE CONTACT TOMC BEFORE COMMENCING ANY WORK. MAC METER INITIATED FOR WITH VENDOR ID V952440 MAC RELATED WORK ORDER 000000003145719 AND PRTR HILBERN, CONNOR (V952440) FOUNSDR CALA2025080807479Sensor · out of limitsAFT SERVICE DOOR CAUTION LIGHT CAME ON AT 4000 FT ON APPROACH E XTINGUISHED BEFORE LDG OPENED AND CLOSED DOOR TO SEE IF SEATING PROPERLY AND NO DEFECTS NOTED. PERFORMED AFT SERVICE DOOR SENSOR INDICATION TEST AND DOOR SENSOR WAS OUT OF LIMITS AND REQUIRES ADJUSDR CALA2025080807478Indicator · inoperativeTEST FLIGHT DISCREPANCY, DOOR 4R ARMED INDICATOR FLAPPER STICKS AND DOES NOT SHOW ARMED W ITH DOOR ARMED. REPOSITIONED MID LINING TO MAKE CLEARANCE SO THAT INDICATOR FLAPPER CAN PROTRUDE THRU MID-LINER TO INDICATE SLIDE ARM. REF AMM 52-11-02-904-007.SDR CALA2025080807477Stop · faultedREMOVED GIRT BAR STOP RELEASE. INSTALLED FWD RELEASE STOP ASSEMBLY ON ESCAPE SLIDE GIRT BAR AT DOOR 1L. ALSO APPLIED RED TAPE, REF AMM 25-66-01-000-804.SDR CALA2025080807475Arm Rest · detachedARM REST ON EMERGENCY EXIT DOOR 21F FELL OFF LOCATED IN FLIGHT D ECK REPLACED ARMREST.SDR CALA2025080807474Cover · missing20A EMERGENCY EXIT DOOR HANDLE NEEDS CLOSED SLIDE ARM/DISARM COVER MISSING ON EXIT DOOR ON SEAT ROW 20 A ITEM ALREADY IS PLACED ON DEFERRAL. INOP STICKER APPLIED. REF LP 5627473SDR CALA2025080807472Filter · dirtySTARTING AT 7000 FT, STRONG ODOR FROM PACK, SMELLS LIKE WET SOCKS. PILOT REPORT A FUME LIKE PACK OIL SMELL ONLY ON DECENT BELOW 10,000 FT SO STRONG,PILOT FELT LIKE PASSING OUT. SMELL ONLY IN COCKPIT & ONLY ON DECENT, FWD CARGO PIT AFT WALL LT SIDE REMOVED FOSDR JJBA20250808015Mount · corrodedCORROSION FOUND ON RAT 2 ANTENNAE MOUNT, BETWEEN FRAMES 65 AND 66. REPAIRED CORROSION FOUND UNDER RAT 2 ANTENNA MOUNT ON REAR FUSELAGE LOWER SKIN BETWEEN FR 65 AND 66.SDR AALA202508087650Latch · inoperativeAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN WITH DOOR HANDLE FROM INSIDE OF FLIGHT DECK UNLESS FLIGHT DECK ELECTRONIC SWITCH IS HELD IN UNLOCK POSITION. FLIGHT CREW REPORTED THAT IT FEELS LIKE MECHANISM IS BROKE FROM HANDLE TO UPPER LOCK. MAINTENANCSDR AALA202508084030Smoke Detector · false indicationAIRCRAFT WAS NOT GROUNDED: INTERMITTENT SMOKE LAVATORY SMOKE ECAM ILLUMINATED DURING CRUISE FOR AFT MID LAVATORY. MAINTENANCE REPLACED LAVATORY L SMOKE DETECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 26-17-15,SDR AALA202508082270Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 11WL DURING EMERGENCY LIGHTING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508086958Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 10WL DURING EMERGENCY LIGHTING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508082127Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 14WL DURING EMERGENCY LIGHTING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR SCNA20250808305Pin · missingL1 GUST LOCK GUIDE ARM PIN AND HARDWARE MISSING INSTALLED GUIDE ARM PIN AND HARDWARE AS REQUIRED PER AMM 52-11-21 OK FOR SERVICE .SDR AALA202508071694Slide Raft · reads lowAIRCRAFT WAS GROUNDED: 2L DOOR PRESSURE GAUGE IS SHOWING IN THE RED. MAINTENANCE REPLACED L2 DOOR SLIDE IAW J/C 26L00025010.SDR AALA202508073393Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AREA EMERGENCY LIGHT INOP DOOR 3R. MAINTENANCE REPLACED R3 DOOR AREA EMERGENCY LIGHT IAW AMM 33-51-03. OPS CK OK.SDR AALA202508075004Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FA EMERGENCY FLASHLIGHT AT AFT GALLEY CENTER LEFT SEAT INOP. MAINTENANCE REPLACED FA EMERGENCY FLASHLIGHT AT AFT GALLEY CENTER LEFT SEAT IAW AMM 25-64-01.SDR DALA2025080705918Oxygen Mask · inoperativePRIMARY OBSERVERS SLIDING SEAT - SEAT UNUSABLE O2 MASK INOPERATIVE. REMOVED AND REPLACED RT OBSERVER'S O2 MASK STOWAGE BOX IAW A319 AMM 35-12.SDR DALA2025080705917Retainer · crackedAFT COMPLEX GALLEY COMPARTMENT UPPER AREA RIGHT TROLLEY CENTER RETAINER BLOCK CRACKED. R/R AFT COMPLEX GALLERY COMPARMENT UPPER AREA RIGHT TROLLEY CENTER RETAINER BLOCK IAW WC 2530- 01591-04D.SDR DALA2025080705915Strap · deterioratedDETERIORATED DITCHING STRAP O/H BIN ROW 14CBA AT PASSENGER CABIN. REPLACED DITCHING STRAP O/H BIN ROW 14CBA AT PASSENGER CABIN IAW AMDS CARD 2560-2425.SDR DALA2025080705914Support Fitting · corrodedRIGHT WING FLAP TRACK FAIRNG 633CB ROD SUPPORT FITTING WITH CORROSION. REPLACED SUPPORT FITTING IAW A319 SRM 51-72- 11-911-001.SDR IPXA2025080729838Fce · faultedAIR TURN BACK, LE SLAT DISAGREE. PERFORMED FSEU BITE PER FIM 27-51 FT 809. FOUND EXISTING FAULT MSG: LVR RVDT 2 MISRIG WITH FAULT CODE 27-51023. ALSO PREVIOUS LEG FAULT 0. FOUND MSG: LE SLATS SEE FIM WITH FAULT CODE: 27-81045. PERFORMED POSITION RVDT #2 (MSDR IPXA2028080700149Strut · corrodedSUSPECTED CORROSION RH MLG UPPER STRUT BODY - APPROX 14€? X 0.75€? TOTAL AREA BLENDED CORROSION AREAS IAW CMM 20-10-01 STEP 2.F AND 2.H. PITTING STILL REMAINS. MAPPED AND SENT DAMAGE PHOTOS TO ENGINEERING OF PITTED AREAS AND ATTACHED TO FAULT. PITTED AREAS SDR IPXA2025080632499Battery · inoperativeEMERGENCY LIGHT BATTERY 1 LOW. REVERSED DMP 33-50-4 AS REQUIRED. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY IAW A.M.M. 33-51-01-000-802/400-802. PERFORMED OPERATIONAL TEST AS PER TASK# 33-51-01-700-802 AND FOUND SATISFACTORY. THIS CLEARS DEFERRAL [TSDR SCNA20250807303Power Supply · inoperativeROW 20 AND 22 DEF EMERGENCY ISLE LIGHTS INOPERAITVE. INTERIOR EMERGENCY EXIT LIGHTING SYSTEM; EMERGENCY AISLE LIGHTS. REMOVED AND REPLACED POWER SUPPLY M1671 REF AMM 33-51-06, OPS CHECK GOOD THIS CLEARS MEL.SDR DALA2025080705932Shutoff Valve · faultedATB DUE TO "LEFT BLEED FAIL" WITH LEFT BLEED ON MEL. REPLACED LEFT PRESSURE REGULATING SHUT OFF VALVE (PRSOV).SDR YENA2025080700812Slide Raft · deployedFLT#1930, SDQ-BOS. "AFT LEFT SLIDE BLOWN AND DEPLOYED. ( PASSENGER OR OVER WING DOOR SLIDE/SLIDE RAFTS (WITHOUT PASSENGERS) ); REPLACED DIAPHRAGM ON DOOR AFT LH DAMPER REF 52-10-00-610-001-A SEE DEFECT # 4288324 FOR SLIDE REPLACEMENT THIS CLEARS MDDR # 590860 SDR FDEA202508061381Frame · damagedDURING REPAIR INSPECTION, REF WRI 53-10/5099, FOUND DAMAGE TO FRAME AT FR. STA. 374L@X= 38. INSTALLED SKIN DOUBLER, TRIPLER AND FILLER REF MD11 SRM 53-00-01-2R. E. A. 1-5330-T0384438 PT1 AND PT2 .FUSELAGE- PLATES & SKINS- SKI AND FRAME REPAIR AT STA 374, SDR FDEA202508061380Floor Panel · puncturedMDC FLOOR PANEL 241AFF WITH PUNCTURE MDC FLOOR PANEL 241AFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG. 201 SHEET 2 REV. 92 APR 15,2025