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 SWAA2025121244268Fairing · dentedLEFT AFT WING TO BODY FAIRING 194FL, DENTED AND DELAMINATED. DENT MEASURES 4.5 X 3.5 X .100.SDR SWAA2025121250741Seat Back · out of adjustSEAT 13D RECLINING AT OVERWING EXIT ROW. ADJUSTED SEAT HYDRO LOCK IAW CMM 25-22-46.SDR SWAA2025121244289Seat Back · out of adjustSEAT 13D RECLINING AT OVER WING EXIT ROW. ADJUSTED THE SEAT HYDRO LOCK IAW CMM 25-22-46.SDR SWAA2025121250342Flashlight · malfunctionedLEFT AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED BOTH AFT LT FLASHLIGHTS, OPS CHECKED GOOD, NO DISCREPANCY EXISTS. INSTALLED THE FLASHLIGHTS AND RESEALED IAW AMM 25-64-00.SDR SWAA2025121243936Flashlight · malfunctionedLEFT AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED BOTH AFT LT FLASHLIGHTS, OPS CHECKED GOOD, NO DISCREPANCY EXISTS INSTALLED THE FLASHLIGHTS AND RESEALED IAW AMM 25-64-00.SDR SWAA2025121250738Flashlight · malfunctionedR/H AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. OPS CHECKED THE AFT RT FA FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025121243951Flashlight · malfunctionedRIGHT AFT FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. OPS CHECKED AFT RH FA FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025121250368Cover · detachedR1 DOOR EMERGENCY EXIT SLIDE CLEAR COVER CAME OFF. OKAY TO CONTINUE IAW MEL 25-10-01 SP1B. INSTALLED R1 EMERGENCY EXIT SLIDE CLEAR COVER IAW AMM 25-66-00.SDR SWAA2025121243669Slide · out of adjustR1 DOOR EMERGENCY EXIT SLIDE CLEAR COVER CAME OFF. OKAY TO CONTINUE IAW MEL 25-10-01 SP1B. INSTALLED R1 EMERGENCY EXIT SLIDE CLEAR COVER IAW AMM 25-66-00.SDR SWAA2025121243836Slide · low pressureAFT ENTRY DOOR EMERGENCY SLIDE GAUGE READING LOW. REMOVED AND REPLACED AFT ENTRY DOOR SLIDE IAW MT 725-61-06-AE.SDR SWAA2025121250742Lens · out of adjustEMERGENCY EXIT PLACARD FELL OFF, F/O SIDE. EMERG EXIT ROW 12F. INSTALLED THE EXIT LENS COVER IAW SIP.SDR SWAA2025121244293Lens · detachedEMERGENCY EXIT PLACARD FELL OFF, F/O SIDE. EMERGENCY EXIT ROW 12F. INSTALLED THE EXIT LENS COVER IAW SIP.SDR SWAA2025121243768Battery Pack · inoperativeLH EMERGENCY EXIT LIGHTS OVERWING INOPERATIVE. R & R LT BATTERY PACK AT BS 603 IAW AMM 33-51-06. CHECKED GOOD.SDR SWAA2025121243813Lens · looseEMERGENCY LIGHT LENS AT CENTER OF AIRCRAFT CEILING, KNOCKED LOOSE. SECURED THE EMERGENCY LIGHT LENS IAW AMM 33-51-03.SDR SWAA2025121244283Handle · brokenRAMP REPORTS R1 SERVICE DOOR, TOP HANDLE BROKEN OFF WHEN CLOSING DOOR. R & R FWD SERVICE DOOR TOP HANDLE IAW AMM 52-41-31.SDR SWAA2025121250721Fairing · delaminatedLEFT AFT WING TO BODY FAIRING 194FL DENTED AND DELAMINATED. 4 INCHES FROM AFT EDGE AND 20 FROM LOWER EDGE. DENT MEASURES 4.5 X 3.5 X .100. R & R LT AFT WING TO BODY FAIRING PANEL 194FL IAW AMM 53-51-21. APPLIED TOP COAT FINISH TO LT AFT BODY TO WING PANEL SDR SWAA2025121243789Support · crackedWHILE PERFORMING WALK-AROUND, FOUND TWO CRACKS REVEALING HONEY COMB STRUCTURE ON FLAP SUPPORT NR 7, FORWARD ASSY ACCESS PANEL 643AB. PERFORMED INSPECTION IAW EA PROVIDED IN TTG8Q019994P. IAW EA 25-157-03350.SDR SWAA2025121247720Sign · miswiredAFT RT EMERGENCY EXIT LIGHT AT BS 639 IS INOPERATIVE. UPON FURTHER INVESTIGATION; FOUND AFT RT OVERWING EXIT EMERGENCY LIGHT SIDEWALL SIGN CONNECTED TO WIRING FOR OVERWING EXIT DOOR HEATERS. RECONNECTED AFT RT OVERWING EXIT EMERGENCY LIGHT SIDEWALL SIGN AND OSDR SWAA2025121244124Sign · miswiredAFT RT EMERGENCY LIGHT AT BS 639 IS INOPERATIVE. UPON FURTHER INVESTIGATION, FOUND AFT RT OVERWING EXIT EMERGENCY LIGHT SIDEWALL SIGN CONNECTED TO WIRING FOR OVERWING EXIT DOOR HEATERS. RECONNECTED AFT RT OVERWING EXIT EMERGENCY LIGHT SIDEWALL SIGN & OVERWINSDR DALA2025121209102Fan · dirtyAT CRUISE A BUZZING SOUND FOLLOWED BY A BRIEF BURNT PLASTIC SMELL OCCURRED. BOTH SOUND AND SMELL IN THE AFT GALLEY WENT AWAY AFTER ALL GALLEY ELECTRICAL WAS TURNED OFF. FOUND DUSTY FAN INLET GRILL IN AFT GALLEY. NO BUZZING SOUND OR OTHER ISSUE PRESENT AFTER CLSDR DALA2025121209101Longeron · crackedCRACK IN WTB FAIRING LONGERON P/N 53-1111-501 AT LBL 40.0. CRACK SPREAD BETWEEN TWO NUT PLATES ON OUTBOARD SIDE OF LONGERON FORWARD OF FRAME AT FS 973. CRACK MEASURES 6 1/8" LONG BY 1/2 " WIDE. AD RELATED REF WORK CARD 5352-01038-01A. COMPLIED WITH WORK CARD 5SDR DALA2025121209100Longeron · damagedFOUND LONGERON DAMAGED. REMOVED LONGERON PER A220 DWG C02382100 REV A. INSTALLED LONGERON PER A220 DWG C02382100 REV A. ONE FASTENER STILL REQUIRED. (HR 259148) FINISHED INSTALLING LONGERON PER A220 C02382100 REV A. (LP# 1342239)SDR HYIA20251212002Elec Connector · burnedPILOT REPORTED PITOT HEAT INOP. UPON INSPECTION THE PITOT SWITCH & SWITCH CONNECTION WERE FOUND TO BE BURNT. BOTH WERE REPLACED WITH NO ADDITIONAL DEFECTS NOTED.SDR DALA2025121209084Skin · crackedFOUND RT WING NR 10 SLAT FWD END FASTENER HOLE CRACK FROM INBD EDGE 41.5 INCHS. ACCOMPLISHED REPAIR IAW SRM 57-43-01 (1341025)SDR CALA2025121212058Stringer · corrodedCORROSION AT STRINGER SPLICE 28L AT MAIN EE AT APPROX BS 360. REMOVED AND REPLACED STRINGER SPLICE 28L BS 360 IAW SRM 51-40-02-0G-0 AND DWG 140A9101.SDR CALA2025121212056Stringer · crackedFOUND CRACK AT FWD WET AREA STRINGER 15L BETWEEN BS 294.5 & 303.9. ACCOMPLISHED REPAIR OF STRINGER 15L BETWEEN BS 277 AND 294.5 AS PER ECRA 5310-08741 AND SRM 53-00-03-2R-1.SDR I5PA2025121168801Landing Gear · malfunctionedLEFT MAIN GEAR DID NOT RETRACT AFTER TAKEOFF. AIRCRAFT AIR RETURNED BACK TO HNL. MX PERFORMED FIM PROCEDURES WITH MULTIPLE FUNCTION CHECKS. NO DEFECTS NOTED. FUNCTIONAL FLIGHT PERFORMED. LANDING GEAR OPS CHECKED NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR MASA2025120800097Windshield · crackedCAPTAIN`S WINDSCREEN SHATTERED FLT270. R&R CAPTAIN`S WINDSHIELDSDR SWAA2025121143945Battery · no testEMERGENCY FLASHLIGHT AFT GALLEY DOES NOT TEST. R & R AFTER GALLEY EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR DALA2025121109071Web · corroded(LOG 1342006) RIGHT FLOOR SUPPORT WEB BETWEEN BS 986 & 1006 CORRODED. REMOVED DAMAGED WEB, FABRICATED AND INSTALLED A NEW WEB BS 986-1006, RBL 24-52 IAW ER/A 630880-14 PRI REV O.SDR DALA2025121109070Elec Connector · unsecure(LOG 7798839) ON SERVICE CHECK, FOUND 23DEF SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. FOUND CONNECTOR UNDER CARPET LOOSE, SECURED THE CONNECTOR. LIGHT OPS NORMAL IAW AMM 33-51.SDR DALA2025121109069Power Supply · inoperative(LOG 7798842) DURING SERVICE FOUND POWER SUPPLY FOR INTERIOR EMERGENCY OVERWING LIGHTING TO BE INOPERATIVE. R & R POWER SUPPLY IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2025121109068Light · inoperative(LOG 7798838) ON SVC CK, FOUND ROW 17 INTERIOR LOWER OVERWING EXIT LIGHT ON BOTH LT & RT SIDE INOPERATIVE. R & R THE LIGHT ASSY IAW AMM 33-51. OPS CHECKED GOOD.SDR DALA2025121109067Floorbeam · corroded(LOG 1342041) BS 947 FLOORBEAM HAS DEEP CORROSION UNDER LAVATORY FITTING, LBL 24. REMOVED DAMAGED SECTION OF FLOORBEAM, FABRICATED, LOCATED, DRILLED, AND INSTALLED REPAIR PARTS IAW SRM 53-70-51-2R-5 AND SRM 51-40-02.SDR DALA2025121109066Floor Support · corroded(LOG 1342040) DRAIN TUBE FLOOR SUPPORT BETWEEN BS 947 & 967, RBL 50 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT AT RBL 50 BTW BS 947 TO 967 IAW SRM 51-40-02.SDR DALA2025121109065Floor Support · corroded(LOG 1342026) FLOOR SUPPORT BETWEEN BS 947 AND BS 967 AT LBL24 HAS DEEP CORROSION UNDER LAV FITTING. REMOVED AND REPLACED FLOOR SUPPORT AT LBL 24 BTW BS 947 - 967 IAW SRM 51-40-02.SDR DALA2025121109064Web · corroded(LOG 1341997) LEFT FLOOR SUPPORT WEB BETWEEN BS 986 AND 1006 CORRODED. REMOVED DAMAGED FLOOR WEB, FABRICATED AND INSTALLED NEW FLOOR WEB BS 986-1006 LBL 24-52 IAW ER/A 630881-14 PRI REV O.SDR DALA2025121109063Floorbeam · corroded(LOG 1341991) BS 986 FLOORBEAM HAS CORROSION AT FLOORBOARD HOLES FROM LBL 24 TO RBL 52. REMOVED DAMAGE SECTION ON FLOORBEAM BS 986, LBL 18 AND RBL 43, FABRICATED, LOCATED, DRILLED, AND INSTALLED ALL REPAIR PARTS IAW SRM 53-70-51-2R.SDR DALA2025121109072Intercostal · corroded(LOG 1342011) INTERCOSTAL BETWEEN BS 947 - 967 HAS CORROSION AT RBL 24. REMOVED AND REPLACED FLOOR SUPPORT PART 147A566OU3 AT RBL24 BTW BS 947-967 IAW SRM 51-40-02.SDR AALA202512111089Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FRAME FR 68 HAS CRACK AT STRINGER 22L APPROX .520L. MAINTENANCE INSTALLED NEW NESTED FITTING IAW EA 346891BSDR AALA202512116695Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FRAME 68 HAS CRACK DOOR STOP #1LOWER INBD AT BOLT HOLE .880 INCHES LONG. MAINTENANCE ADDED REINFORCEMENT (NESTED ANGLES) REPAIRED PER EAS 346925A.SDR AALA202512113795Door · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR L4 IS DIFFICULT TO OPEN AND CLOSE, APPEARS STUCK. MAINTENANCE ADJUSTED DOOR L4 IAW AMM 52-11-00-710-801.SDR AALA202512110683Idg · inoperativeAIRCRAFT WAS GROUNDED: LOST GEN 2 INFLIGHT. RESET UNSUCCESSFUL. DECESION MADE TO RETURN TO DFW, EMERGENCY DECLARED. AIRCRAFT LANDED OVERWEIGHT WITHOUT INCIDENT. MAINTENANCE REPLACED #2 ENG IDG PER W/C 26L40024001.SDR 4USA2025121100820Strut · low pressureAIRCRAFT TOOK OFF, GEAR RETRACTED, ALL NORMAL. AT ABOUT 40K FT, CAPTAIN HEARD A LOUD THUD & THE NOSE GEAR UNLOCK INDICATION CAME ON. CREW REPORTED RESISTANCE FROM THE NOSE SECTION. THEY DID A QUICK DECENT TO 10K FT & CYCLED THE GEAR. THEY CYCLED DOWN & GOT 3 GSDR DXTA2025121106038Battery Pack · faultedTHE CABIN EMERGENCY LIGHTING ILLUMINATES WHEN THE EMERGENY LIGHT SWITCH IS PLACED TO ARM. TURNED OFF WHEN THE SWITCH IS TURNED OFF. CONFIRMED DISCREPANCY, REVIEWED SL505-33-0005 REV 5 EMER LIGHT T/S & FOUND THAT BOTH BATTERY PACKS ARE CAUSING THE ISSUE CONFSDR CALA2025121112021Skin · dentedDENT ON AFT, LEFT OF NLG DOOR. VERIFIED MEASUREMENTS WITH INSPECTION SHOWING: D= 0.201" X L 6.300" X W= 3.900", JUST AFT OF BS 294.5 & IS OUT OF LIMITS IAW SRM 53-00-01-1A-1. REPAIRED DAMAGED FUSELAGE SKIN FROM BS 277 - 320, RBL 15, STR 25L IAW EC/RA 5310-087SDR CALA2025121012015Power Supply · no testDURING EMERGENCY LIGHTS TEST, AFT PSU EMERGERCY POWER SUPPLY UNIT SHOWED A FAULT. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-38/401, CONFIG 00, TESTED OK.SDR CALA2025121012010Smoke Warning · false activationDURING DESCENT, RECEIVED A SMOKE REST UPPER DOOR 3 NON NORM CHECK..NO SMOKE, PERFORMED ALL TEST & T/S IAW FIM TASK 26-14, TASK 809. R & R OEU BY DOOR 3R, IAW AMM 23-33-02-400-803. OPS CHECKED GOOD. NO FAULT NOTED. NO SMOKE NOR ODOR FOUND IN THE UPPER REST ASDR ASAA2025120862212Light · missingDMI# 406046 EMERGENCY ESCAPE FLOOR PATH STRIP MISSING 6" AT ROW 17AB ( PHOTOLUMINESCENT MARKING SYSTEM ). GROUNDED - YES. INSTALLED EMERGENCY PATH GLOWSTRIP AT 17AB. OPS CHECK GOOD. SECURITY CHECK GOOD. PLACARD REMOVED. MIC SHEET UPDATED.SDR WX0A2025121032661Seal · damaged(AIRCRAFT NOT GROUNDED) FA'S REPORT LOUD SQUEALING/BUZZING NOISE COMING FROM EMERGENCY EXIT DOOR AT 14A. INSPECTED & NOTED DAMAGE TO HATCH SEAL AT 14ABC. REMOVED DAMAGED SEAL & INSTALLED NEW SEAL IAW AMM 52-21-18-960-003-A.