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 DALA2025081106001Structure · damagedG5/AFT COMPLEX GALLEY WORK TOP PANEL DAMAGED AND LOWER FRONT TRIM WITH LOOSE SCREWS. REPLACED UPPER FUSELAGE G5/AFT COMPLEX GALLEY WORK TOP PANEL IAW CMM 25-31-546X-01001-720A-C.SDR DALA2025081106000Skin · dentedEXTERNAL LOWER FUSELAGE AT 28MM FWD OF FR 6, 98MM ABOVE LT STGR, SKIN DENTED. COMPLIED WITH ER/A 627408-14.SDR DALA2025081105995Keelbeam · corrodedLOWER FUSELAGE KEEL BEAM AREA AT FR 36 STRG 42 LH VERTICAL WEB WITH CORROSION. COMPLIED WTH ER/A 627710-14.SDR DALA2025081105994Skin · corrodedCENTER TANK, TOP SKIN, UPPER SURFACE, FR40 TO FR41 BETWEEN STIFFENER 13 AND 14, AT Y+1305 SKIN WITH CORROSION. COMPLIED WITH ER/A 627561-14.SDR DALA2025081105993Skin · dentedEXTERNAL UPPER FUSELAGE AT FR25, 42MM BELOW STGR13R SKIN WITH DENT. COMPLIED WITH ER/A 627770-14.SDR SWAA2025081199949Fire Detector · false activationWHEEL WELL FIRE LIGHT AT THE HOLD SHORT JUST BEFORE TAKEOFF.LIGHT REMAINED ON. CRASH FIRE AND RESCUE VERIFIED NO INDICATIONS OF FIRE OR SMOKE WITH ENGINES SHUT DOWN. STARTED ENGINE 2 AND RETURNED TO GATE FIRE WARNING VERBAL. ALARM SET OFF EACH TIME ELECTRICAL SDR GTIA2025081139041Megaphone · inoperativeCREW REPORTS MEGAPHONE INOPERATIVE. R & R THE MEGAPHONE IAW AMM 25-65-51.SDR AALA202508117635Proximity Sensor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF AND FLAPS COMING UP, LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED BITE ON FSEU FOUND F4 PROXIMITY SENSOR MX MESSAGESDR IPXA2025080978295Lens · unserviceableFL DK EMERGENCY EXIT LIGHT A FEW LENS FOUND U/S. U/S LENS REPLACED BY SERVICEABLE IAW AMM 33-51-01-402-030 REV 145.SDR AALA202508117152Track · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STUCK AND WILL NOT OPEN. ACCOMPLISHED LAVATORY-D REPOSITION DOOR ON TRACKS. OPERATIONAL CHECK GOOD. PER CMM 25-40-59SDR AALA202508117452Shutoff Valve · failedAIRCRAFT WAS GROUNDED: PACKS BEGAN TO PULSE WHAT SEEMED LIKE BETWEEN HIGH FLOW AND LOW FLOW, VERY LOUDLY. PULSING CONTINUED AT VARIOUS THRUST SETTINGS. A QUICK PASSING BURNING ELECTRIC SMELL WAS PRESENT, ODOR CLEARED WITHIN 30 SECONDS. MAINTENANCE MESSAGE 36-SDR DALA2025081105991Slat System · faultedSHIP 3569 -DE- DUE TO (SLAT 1&2) FAULT WHEN EXTENDING FLAPS TO 1. CORRECTIVE ACTION: PERFORMED SLAT SYSTEM 1 AND 2 TEST, WTB ENGAGEMENT TEST WITH NO FAULTS FOUND. REPLACED SFCC (SLAT FLAT CONTROL COMPUTER). (LP# 7863258)SDR VNAA2025081111102Unknown · odorBURNING SMELL OBERSEVRED IN THE FLIGHTDECK WHILE AIRPLANE WAS COLD AND DARK WITH GROUND POWER ATTACHED TO AIRPLANE BUT NOT AVAIL. BOTH PACKS OFF. RECRIC FANS ON. LOW PRESSURE AIR NOT ATTACHED. / T/S PER FIM 21-21-00-810-806-A01. NO ABNORMAL SMELL/SMOKE IN COCSDR VNAA2025081111101Smoke Detector · false activationCAPTAIN SAW A SMOKE IN THE AFT LAV MESSAGE POPPED UP. PERFORMED OPS CHECK OF AFT LAV SMOKE DETECTOR IAW AMM 26-16-00-710-801-A01-PSA. OPS CHECK GOOD.SDR DALA2025081105986Latch · not seatedSHIP 9560-ATB- AIRCRAFT RETURNED TO CLT DUE TO A CABIN INFLOW MSG. CORRECTIVE ACTION: FOUND AFT CARGO DOOR LATCHED BUT NOT SEATED, RESECURED DOOR AND PERFORMED A FUSELAGE LEAK TEST, AFT CARGO DOOR PROX SENSORS TESTED NORMAL. A/C RETURNED TO SERVICE.(7731932)SDR DALA2025081105985Compressor · stalledSHIP 9505 GOING THRU 10,000 ON CLIMBOUT WE GOT COMPRESSOR STALL TGT HAD AN X OFF AND ON. CORECTIVE ACTION: EPLACED HARNESS PER B717 AMM 77-21. REPLACED ALL 6 TGT PROBES PER B717 AMM 77-21. (7417510)SDR AALA202508112534Arming Lever · stickingAIRCRAFT WAS NOT GROUNDED: L4 SLIDE ARM/DISARM HANDLE AND INDICATOR REPORTED STICKY BY FLIGHT ATTENDANT. MAINTENANCE CLEANED AND LUBRICATED BOTTOM DOOR MECHANISM PER AMM 52-10-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR 3EJA2025080110001Switch · failedCLIMBING OUT THROUGH ABOUT FL230, RIGHT SIDE THRUST REVERSER “UNLOCK” ANNUNCIATOR ILLUMINATED.SDR DALA2025081105983Tailpipe · fireSHIP 8324 - FIRE - WHILE PARKING AT GATE THE GROUND CREW NOTIFIED THE COCKPIT OF THE #1 ENGINE TAILPIPE FIRE. NO INDICATION IN COCKPIT OF FIRE. CREW DISCHARGED BOTH ENGINE FIRE BOTTLES WITH NO SUCCESS. FIRE DEPARTMENT USED PORTABLE NONCORROSIVE AGENT AND PUT OSDR DALA2025081105980Module · faultedSHIP 8103 - MISC - DUE TO DECLARED EMERGENCY FOR "DMC 1B FAIL" MESSAGE WITH VARIOUS ADVISORY MESSAGES. CORRECTIVE ACTION: REPLACED POWER PRODUCING MODULE 1B. (LP# 7294202)SDR DALA2025081105976Floor Support · corroded(LOG 1133072) INTERCOSTAL BETWEEN STA 947 AND 967 AT LBL 16 CORRODED. REMOVED & REPLACED INTERCOSTAL BETWEEN STA. 947 & 967 LBL 16 IAW B737-900 SRM 51-40-02-0G.SDR DALA2025081105975Floor Support · corroded(LOG 1133042) DRAIN TUBE INTERCOSTAL BETWEEN STA 947 AND 967 AT LBL36 CORRODED. REMOVED & REPLACED INTERCOSTAL BETWEEN STA. 974 & 967 LBL36 IAW B737-900 SRM 51-40-02-0G.SDR DALA2025081105974Floor Support · corroded(LOG 1132978) CORROSION ON INTERCOSTAL (1 E/A) STA 460 TO 480 LH SIDE. INTERCOSTAL (1 E/A) STA 460 TO 480 LH SIDE WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025081105973Floor Support · corroded(LOG 1132616) DRAIN TUBE INTERCOSTAL BETWEEN STA 947 AND 967 AT RBL 36 CORRODED. REMOVED & REPLACED INTERCOSTAL BETWEEN STA 947 AND 967 AT RBL 36 IAW B737-900 SRM 51-40-02-0G.SDR DALA2025081105971Elec Connector · damaged(LOG 7056962) SEAT 32 EXIT AISLE LIGHT INOP. REPLACED CONNECTOR ON PSU END IAW B737 SWPM 20-42-01 OP'S CHECKED GOOD.SDR DALA2025081105969Frame · ground damage(LOG 1131559) REMOVED FRAME 188; LOWER LOBE, DUE TO IMPACT DAMAGE. INSTALLED FOR ALIGNMENT REF B737 DRAWING 141A1501 (RJD 471692). REMOVED WEB AND LOWER CHORD, DEBURRED AND PRIMED ALL BARE METAL . COMPLETED INSTALLATION OF FRAME 188 LOWER LOBE PER BOEING 737 DSDR DALA2025081105977Floorbeam · corroded(LOG 1133059) STA 947 FLOOR BEAM HAS LIGHT CORROSION AROUND HILOCK HOLE AT LBL 12. PERFORMED CUT-OUT REPAIR ON THE FLOOR BEAM AT STA. 947 LBL 12 IAW B737-900 SRM 53-70-51-1A-1.SDR DXTA2025081104525Power Supply · no testDURING PREFLIGHT CHECK IF THE EMERGENCY LIGHTS, NO EMER LIGHTS IN STATUS EUCAS ILLUMINATED. WE RAN THE APU TO CHARGE THE BATTIERS PER MAINTENANCE REQUEST FOR MORE THAN INE HOUR WITH NO STATUS CHANGE. A FULL POWER CYCLE WAS ALSO ACCOMPISHED WITH SIMILAR RESULTSSDR DXTA2025081104532Battery · no testDURING BOTH ENGINE STARTS, THE EMER LT NOT ARM AMBER EICAS BRIEFLY ILLUMINATED. SWITCH IN ARM POSITION. EICAS EXTINGUISHED AFTER EACH START. AT FL430 ALL INTERIOR EMERGENCY LIGHTS ILLUMINATED. THE SWITCH IN ARM POSITION. NO EICAS MESSAGE PRESENT. CYCLSDR BAGA2025081100004Shutoff Valve · failedOIL ODOR IN FWD CABIN. R & R RT ENGINE BAV & ENGINE BUFFER AIR SHUTOFF VALVE. OPS CHECKED GOOD. NO MEDICAL ATTENTION NEEDED FOR PAX OR CREW. EMERGENCY WAS DECLARED.SDR AALA202508111338Oil System · leakingAIRCRAFT WAS GROUNDED: OIL ODOR CAN BE SMELLED THROUGHOUT CABIN AND COCKPIT. MAINTENANCE FOUND OIL LEAKING FROM APU DRAIN MAST REF MIC 1418556. ACCOMPLISHED WC/ 26L00021001 . CONFIRMED ODOR WAS FROM APU. BOTH ENGINE BLEEDS FOUND ODORLESS. APU DEFERED PER MIC 1SDR AALA202508112239Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: DUE PSCK FOUND FLASHLIGHT CHARGING SYSTEM MOUNTING BRACKET DETERIORATED AT MDCR. MAINTENANCE REPLACED FLASHLIGHT CHARGING SYSTEM AND BATTERY IAW AMM 25-64-01.SDR SCNA20250811312Slide · no discrepancyL2 DOOR SLIDE NOT IN HOUSING PROPERLY CHAIN CONNECTING FABRIC IS OVERLY TIGHT. INSPECTED AND CHECKED L2 DOOR SLIDE TASK # 25-66-01-200-802 NO DEFECTS FOUND AC FOR SERVICESDR SCNA20250811311Lamp · inoperativeWORKL2 DOOR EXTERIOR EMERGENCY LIGHT INOP - RESOLUTION: R+R'D L2 EXT EMERGENCY LIGHT LAMP. OPS CHECK GOOD. REF: AMM 33-51-00.SDR CALA2025081107566Dome Nut · brokenBROKEN DOME NUTS IN FWD PIT FROM BS 690 TO 730 L/H SIDE AT MAIN CABIN FLOOR LEVEL. ECRA 5330-07581 AND EA757-5330 -13-A4304 ACCOMPLISHED.SDR CALA2025081107565Web · corrodedFWD CARGO THRESHOLD WEB HAS SPOTS OF CORROSION. REMOVED AND REPLACED THRESHOLD WEB AT FWD CARGO COMPT PER REF SRM 51-40-02-0G-0 AND DWG# 143A8120.SDR CALA2025081107564Skin · dentedLEFT WING OTBD FLAP, LEADING EDGE, GOUGED AT INBD SIDE. ACCOMPLISHED REPAIR COMMON TO LT WING OTBD FLAP LEADING EDGE IAW EA 757-5753-13AH-031 PRELIM 1,2 ALL STEPS ACCOMPLISHED AND REINSTALLED PANEL ACCESS IAW SRM 51-40-02-0G T95354 ACCOMPLISHED/C/W UAL ECRA SDR CALA2025081107563Elec Connector · crackedEMERGENCY LIGHTS O/H BIN AISLE LIGHT CONNECTOR D11334 AT APPROX STA 727C+13 L IS CRACKED. REPLACED PLUG D11334 IAW BSWPM 20-61-28. EMERGENCY LIGHTS OPS CHK GOOD IAW AMM 33-51-00-710-801.SDR CALA2025081107562Lamp · failedEMERGENCY BIN OVERHEAD LIGHT AT SEAT DEF32 INOP REMOVED AND REPLACED BIN OVERHEAD EMERGENCY LAMP AT SEAT 32 DEF IAW AMM 33-51-03. OPS CHECKED GOOD.SDR CALA2025081107561Slide · deployedDOOR 2R WAS INADVERTENTLY OPENED IN THE ARMED POSITION. R & R DOOR 2 SLIDE IAW AMM 25-62-44. TEST SATISFACTORY, INSPECTED ASSITS BOTTLE AND SAFETY AND REPOSITION, CIDS TEST ACCOMPLIED ALL PINS REMOVED IAW GMM 09-25-05.SDR CALA2025081107553Bustle · looseESCAPE SLIDE PACK BUSTLE LOOSE DOOR 2L FOUND DOOR 2L ESCAPE SLIDE BUSTLE SECURED CORRECTLY. NO DEFECTS NOTED AT THIS TIME. REF. 25-66-01SDR CALA2025081107552Slide · unsecureEMERGENCY EXIT SLIDE FWD SERVICE DOOR IS VISIBLE ON BOTTOM PORTION OF CONTAINER, R1 DOOR SLIDE REPACKED RESPECTIVE MATERIAL IAW AMM 25-66-01.SDR CALA2025081107549Actuator · faultedTHREE UNCOMMANDED RIGHT ROLL INPUTS MADE WHILE ON COMMAND A AUTO PILOT. THE FIRST HAPPENED THRU CHECKED DFCS BITE NO FAULTS NOTED, ALSO CHECKED SMYD COMPUTERS ALSO NO FAULTS NOTED. TEC SUPPORT RECOMMENDS AUTO PILOT A AILERON ACTUATOR REPLACEMENT REMOVED AND RSDR CALA2025081107546Bottle · low pressureDOOR 2R SLIDE PRESSURE BELOW GREEN ARC. AFTER DETAILS INSPECTION FOUND PRESSURE INDICATOR NEEDLE SLIDE DOOR 2R WITHIN LIMITS AS PER AMM:25-66-98-206-001.CHECK GOOD.SDR CALA2025081107545Tape · failedR2 DOOR PANEL COVER, TAPE LOSING ITS STICK AND FALLING OFF. SECURED PANEL ON INSIDE HANDLE OF DOOR 2R.SDR CALA2025081107544Slide · unsecure1R DOOR SLIDE HAS EXCESSIVE AMOUNT OF FABRIC HANGING LOOSE TUCKED EXCESSIVE FABRIC AT 1R DOOR SLIDE INTO BUSSLE. OPS CHECK GOOD. SLIDE OPENS AND CLOSE FREELY. REF AMM. 25-66-00.SDR CALA2025081107543Cover · detachedCLEANERS REPORT EMERGENCY EXIT DOOR HANDLE COVER AT SEAT 20F HAS FALLEN OFF. COVER SECURED AS REQUIRED OKAY FOR SERVICE.SDR CALA2025081107533Light · detachedEMERGENCY EXIT PATH LIGHTING HAS COME LOOSE 34C. SECURED EXIT LIGHT HOUSING WITH FASTENERS IN PLACE. OPS CHECK OF EXIT LIGHTING GOOD IAW AMM 33-51-00-710-801.SDR CALA2025081107532Lens · detachedROW 20 EMERGENCY EXIT AISLE LIGHT FELL OFF. REATTACHED RED LENS TO SEAT 20A. NO DAMAGE NOTED, OK FOR SERVICE.SDR CALA2025081107531Light · faultedCABIN EMERGENCY LIGHTING TEST RESULTS WITH FAULT EPSU EXT LOAD EMER R. REPLACED RT AFT EMERGENCY OVERWING LIGHT ASSY IAW AMM 33-51-15-400-001-A, OPS TESTED GOOD.