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 SWAA2026011961373Battery · inoperativeCOCKPIT FLASHLIGHT INOPERATIVE. R & R COCKPIT EMERGENCY FLASHLIGHT BATTERY IAW AMMM 25-64-00. OK FOR SERVICE.SDR SWAA2026011961385Hook · looseFWD ENTRY GIRT BAR SLIDE FWD HOOK LOOSE. INSTALLED FASTENER ON FWD ENTRY GIRT BAR HOOK IAW SRM 51-40-02.SDR SWAA2026011961108Light · no testAFT RIGHT CABIN M1672 EMERGENCY EXIT LIGHTS FAIL 15 MINUTE CAPACITY CHECK. REMOVED AND REPLACED IAW AMM 33-51-06-960-805-NG.SDR SWAA2026011961107Battery Pack · no testAFT LEFT CABIN M1673 EMERGENCY EXIT LIGHTS FAIL 15 MINUTE CAPACITY CHECK. REMOVED AND REPLACED IAW AMM 33-51-06-960-805-NG.SDR SWAA2026011961092Fairing · crackedLEFT WING FWD FLAP TRACK SUPPORT FAIRING #2 IS CRACKED PANEL #543AB<[01] REPLACED FWD FAIRING PER AMM 27-51-28SDR JJBA20260119038Lamp · inoperativeCOCKPIT AND ROW 3 CEILING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LAMP AND ROW 3 AISLE EMERGENCY LAMP. OPS CHECK SAT.SDR JJBA20250119037Elec Connector · looseGALLEY EMERGENCY EXIT SIGN INOPERATIVE. UPON INSPECTION, FOUND LOOSE CONNECTION AT GALLEY EXIT SIGN ABOVE SERVICE DOOR. REPAIRED CONNECTION. OPS CHECK SAT.SDR CALA2026011913049Skin · corrodedFUSELAGE SKIN INTERNAL BETWEEN BS 879 - 900 BLIGE CENTER LINE HAS CORROSION (EXFOLIATED). REPAIR ACCOMPLISHED IAW ECRA 5330-07683. MAJOR REPAIR. PERFORMED A REPAIR IAW VT MAE 757-5330-13-A4231, ATTACHED TO EC/RA AS FIGURE 1 THROUGH 35 WITH NO DEVIATIONS IAW SDR QXEA2026011800010Pump · leakingFUEL DRIPPING FROM LOWER COWL OF NR 1 ENGINE. REMOVED FROM SERVICE. OPENED AND CLOSED NR 1 FAN COWLS IAW E175 AMM 71-13-00-910-801-/802A. OPENED & CLOSED LATCHES ON NR 1 THRUST REVERSER IAW AMM 78-30-01-910-801/802A. PERFORMED GVI OF VISIBLE AREA. NOTED FUEL CSDR DALA2026011700390Window Frame · crackedDURING M2 AND WHILE ACCOMPLISHING EM 5311-01226-01 CRACKS FOUND IN LT & RT FRONT WINDSHIELD FRAMES LWR CTR NODE AREA. *DTE* PER SECTION DTE OF 630808-14 THE REPAIR OF SECTION I IS LIMITED TO 30,600 FC FROM SECTION I (6JAN26). ADDITIONAL ENG'G AUTHORIZATION RESDR GTIA2026011539249Epsu · faultedDURING SLIDE PACK CHANGE, FOUND 12WL EPSU FAULTING-R&R 12WL EPSU , OPS CHECK GOOD PER AMM 33-51-00SDR SWAA2026011661137Battery Pack · inoperativeEMERGENCY LIGHTS INOP AT ROW 20 DEF. R&R EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECK OK.SDR SWAA2026011661136Battery Pack · inoperativeEMERGENCY LIGHTS INOP AFT GALLEY RH SIDE. R & R EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED OK.SDR SWAA2026011661721Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT FWD SERVICE DOOR NEAR FLOOR. REPLACED EXIT LIGHT LENS REF AMM 33-51-01SDR WX0A2026011632701Flashlight · no test(AIRCRAFT NOT GROUNDED) F/A L1 JUMPSEAT FLASHLIGHT WILL NOT FLASH DURING TEST. R & R L1 F/A FLASHLIGHT BATTERY IAW AMM 25-65-00. THIS CLOSES MEL 25-60-08-A AND MDDR# 225485. OPS CHECK GOOD. PLACARD REMOVED"SDR DALA2026011600377Skin · crackedREFERENCE ER/A 617297-14 - FUSELAGE / SKIN / STA 1037, L-14L / CRACKS. CORRECTIVE ACTION: REPAIRED PER ER/A 14-617297. (1401870)SDR CALA2026011613005Lubrication · odorBURNING ODOR THRU ENTIRE CABIN. OVENS AND COFFEEMAKERS OFF. DISSIPATED EVENTUALY BUT SLIGHT ACRID ODOR. PERFORMED ENGINE RUN IAW AMM 71-00-00 WITH PACKS ON. NO ODOR DETECTED. SUSPECT ODOR CAME FROM BLADE LUBRICATION DONE THE NIGHT PRIOR TO FLIGHT. NO FURTHESDR CALA2026011612993Filter · dirtyON OPENING POWER FOR TAKEOFF GOT SMOKE IN COCKPIT MOMENTARILY. INSPECTED ENTIRE AIRCRAFT IAW AMM 05-51-26 NO DEFECTS NOTED AT THIS TIME PERFORMED HIGH POWER ENGINE RUNS IAW AMM 71-00-00 NO EVIDENCE OF A SMOKE ODOR . R & R BOTH HEPA FILTERS REF 21-25-01.SDR CALA2026011612992Spar · corrodedVERTICAL STAB RT SIDE OTBD REAR SPAR FITTING VSS 1088 HAS A MIGRATING SHIM FROM BETWEEN THE BULKHEAD FITTING AND THE SPAR FITTING. REMOVED MIGRATED LAMINATED SHIM AND REPLACED WITH SOLID SHIMS IAW DWG 170A1610, REV G, AND AMM 55-30-00.SDR CALA2026011612991Channel · corrodedAFT CARGO BAY RT ZEE CHANNEL BTW BS 727C - 767 POSSIBLE CORROSION. REPLACED THE ZEE CHANNEL, RT ZEE CHANNEL BTW BS 727C - 767 IAW SRM 51-10-02-0G-0, PARA 14, B (3), & PARA 15 A (6), (A), SRM 51-40-02-0G-0, SRM 53-00-53-2R-6, TABLE 201, ITEM 1, SRM 51-40-05-0GSDR CALA2026011612990Attach Angle · crackedCENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.75 AND APPROX LBL 9. REPAIR ACCOMPLISHED IAW SRM 57-10-10-2R-5, REPAIR 5, FIGURE 201-202. NO DIPS REQUIRED.SDR SWAA2026011561784Hydrolock · faultedSEAT BACK 16C WILL NOT STAY IN UPRIGHT POSITION. R & R SEAT 16C HYDROLOCK ACTUATOR IAW AMM 25-22-00. OPS CHECKED NORMAL.SDR DALA2026011500365Stop Fitting · damagedREPAIR PERFORMED ON FR 68 LT AT DOOR STOP FITTING NR 1 IAW ERA 631655-14, AND SRM 53-41-12-300-011. IAW SRM 53-41-12-205-010, REPEAT INSPECTIONS ARE REQUIRED. ACCOMPLISH ER/A 631655-14 SECTION II WITHIN 19,700FC FROM 21JUN25 (30,878FC). ASSOCIATED ER/A 00-6316SDR DALA2026011500364Seat Track · corrodedUPPER FUSELAGE PAX CABIN FLOOR STRUCTURE SEAT TRACK LOCATED AT FR 20 -Y1292 WITH CORROSION. REPLACED SEAT TRACK AT UPPER FUSELAGE FR20 - Y1292 IAW SRM 51-72-11-911-001 REV 155, & DRAWING D53112812 ISSUE E, D53110920 ISSUE E00, D53110984 ISSUE B AND D53918122 SDR DALA2026011500363Seat Track · corrodedUPPER FUSELAGE, PAX CABIN FWD ENTRY AREA, SEAT TRACK +Y765 LOCATED AT FRAME 20 WITH CORROSION. REPLACED SEAT TRACK AT FR20 +Y765 IAW A319 SRM 51-72-11-911-001 REV 155, AND DRAWING D53112812 ISSUE E, D53110920 ISSUE E00 AND ISSUE D AND D53110984 ISSUE B. (LP: SDR DALA2026011500362Seat Track · corrodedUPPER FUSELAGE, PAX CABIN FWD ENTRY AREA, SEAT TRACK -Y765 LOCATED AT FRAME 20 WITH CORROSION. REPLACED SEAT TRACK AT FR20 -Y765 IAW SRM 51-72-11-911-001, REV: 155. AND AIRBUS DRAWING D531 12812 ISSUE E, D531 10984 ISSUE B, D5311 10920 ISSUE E00 AND D539 18SDR DALA2026011500361Access Panel · corrodedTAIL CONE ACCESS PANEL NUMBER 317AL INTERNAL ANGLES WITH CORROSION. REPLACED TAIL CONE ACCESS PANEL 317AL INTERNAL ANGLES (2EA) IAW SRM 51-72-11-911-001 PARAG 2C REV 155, AND AIPC 53-58-04-05B SHEET 1 & 2 DETAIL H & J, REV 133.01, AND AIRBUS REFERENCE DWG D92SDR AALA202601150217Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STAB HAS A CRACK IN THE LOWER SKIN ALONG THE RIB AT STAB BS 120.3. INSTALLED REPAIR IAW SRM 55-10-01-2R, REPAIR 11, ON TLE BOW 1217826 ON NR 42.SDR ASAA2026011462871Eec · faultedAIR TURNBACK, ENG 1 FADEC OVHT. COMPLETED ECAM ACTION SHUTDOWN NR 1 ENGINE. GROUNDED - YES. [EUPB COOLING AIR DUCTS /EEC (E1-4000KS)] MMSG SHOWN IN PFR, REF TSM 75-21-00-810-833.PREVIOUSLY ACCOMPLISHED WORK, PERFORM AMM 75-21-49-200-801 TO INSPECT THE COOLSDR GTIA2026011539246Megaphone · inoperativeMEGAPHONE INOPERATIVE. R & R THE MEGAPHONE IAW SPIRIT AIRLINES NKS320-SPACEFLEX-EQ.SDR AALA202601158488Cradle · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THE FORWARD EMERGENCY FLASHLIGHT IS NOT CHARGING (L1 DOOR). REMOVED AND REPLACED FLASHLIGHT (AALA202601157509) AND FLASHLIGHT CHARGING BASE (AALA202601154947). PER AMM 25-64-00. OPS CHECK NORMAL.SDR AALA202601157590Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THE FORWARD EMERGENCY FLASHLIGHT IS NOT CHARGING (L1 DOOR). REMOVED AND REPLACED FLASHLIGHT (AALA202601157509) AND FLASHLIGHT CHARGING BASE (AALA202601154947). PER AMM 25-64-00. OPS CHECK NORMAL.SDR AALA202601157359Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXIT LIGHT AT ROW 16F HAS AN INOPERATIVE BULB. REMOVED AND INSTALLED NEW LIGHT BULBS IN EXIT LIGHT AT ROW 16F. PER AMM 33-51-01. OPS CHECK GOOD.SDR AALA202601150759Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT AT AFT SERVICE DOOR RIGHT SIDE MISSING. INSTALLED EXIT LIGHT AT AFT SERVICE DOOR RIGHT SIDE. PER AMM 33-51-00. OPS CHECK GOOD.SDR AALA202601151081Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: MEGAPHONE INOPERATIVE. REMOVED AND REPLACED MEGAPHONE. PER AMM 25-64-00. OPS CHECK GOOD.SDR AALA202601153759Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT HAND OUTBOARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT LEFT HAND FLIGHT ATTENDANT FLASHLIGHT. PER AMM 25-64-00. OPS CHECK GOOD.SDR IPXA2026011546798Indicator · no testON PREFLIGHT, L1 RED WARNING LIGHT DOES NOT ILLUMINATE WHEN TESTED. BUZZER DOES SOUND. DEFERRED AS PER MEL 52-73-01-1. PLACARD INSTALLED. NO DMP REQ.SDR IPXA2026011504578Door · bindingCABIN ENTRY DOOR LOCK LATCH LEVER STICKS/STICKY. DIFFICULT TO LOCK. C/W INSPECTION/TEST OF CREW ENTRY DOOR SECONDARY CAPTURE LEVER 52-12-00-735-137. NO FAULTS FOUND.SDR COEA2026011501956Trim Switch · faultedREPOSITION FLIGHT 201, PHX-SMF: AIR TURNBACK FULL RIGHT RUDDER TRIM AND ADDITIONAL RIGHT RUDDER REQUIRED TO MAINTAIN STRAIGHT FLIGHT. RETURNED AIRCRAFT TO PHX. NO EMERGENCY WAS DECLARED. CORRECTIVE ACTION: MAINTENANCE INSPECTED RUDDER TRIM RIGGING. FOUND TRSDR DALA2026011500347Wire · detached(LOG 8432328) EMERGENCY LIGHTS INOPERATIVE AT LT OVERWING DOOR (INTERIOR AND EXTERIOR) AND LT AFT FUSELAGE. FOUND POWER WIRE ON LIGHT ASSY AT INSIDE EXIT SIGN UNSOLDERED. SOLDERED IAW BSWPM 20-40. FOUND ELECTRICAL CONNECTOR D12036 UNPLUGGED BEHIND SIDEWALL ASDR DALA2026011500346Battery Pack · no test(LOG 8042854) DURING SVC CHECK FOUND EMERGENCY LIGHTS INOP AT ROWS 29-32. R & R EMERGENCY LIGHT BATTERY PACK IAW B737 AMM 33-51. OPS CHECK NORMAL.SDR AALA202601153179Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 14WL AND ACCOMPLISHED A SATISFACTORY OPS CHECK PER AMM 33-51-38.SDR AALA202601159871Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601154744Bottle · low pressureAIRCRAFT WAS GROUNDED: AFTER FLIGHT ATTENDANTS ARMED THE DOORS FOR DEPARTURE, THE FLIGHT ATTENDANTS PANEL INDICATED THE 2L IS NOT SHOWING ARMED AND THE MESSAGE CHECK DOOR PRESSURE IS DISPLAYED. MAINTENANCE SERVICED THE 2L DOOR DAMPER AND EMERGENCY OPERATION CYSDR AALA202601150693Lever · looseAIRCRAFT WAS NOT GROUNDED: DOOR 2R ARMING LEVER IS LOOSE. MAINTENANCE SECURED ARMING LEVER PER AMM 52-22-00.SDR AALA202601158507Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601150182Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT ROW 15 IS INOPERATIVE. MAINTENANCE RECONNECTED LOOSE CONNECTION FOR THE EMERGENCY SEAT MOUNTED LIGHT AND ACCOMPLISHED A SATISFACTTORY OPERATIONAL CHECK PER CMM 25-26-09.SDR AALA202601156415Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE LAVATORY ECAM AND MASTER WARNING WAS ON FOR APPROXIMATELY 2 SECONDS AND THEN CLEARED. PERSON IN LAVATORY WAS QUESTIONED ABOUT SMOKING OR VAPING. NOTHING WAS EVIDENT OR SMELLED BY FLIGHT ATTENDANTS. NO FURTHER SMOKE INCIDENTSSDR DALA2026011500345Oxygen Box · faultedEMERGENCY OXYGEN CONTAINER AT DOOR 4RT WILL NOT STAY CLOSED. REPLACED EMERGENCY OXYGEN CONTAINER AT 4RT REF A330 AMM 35-21. OPS CHECK GOOD. (1401341)SDR FDEA202601140039Skin Panel · damagedLIGHTNING STRIKE ON UPPER SKIN BTWN B STA 903.5 - 933 AND S-1R AND S-2R. THE LIGHTNING STRIKE AT UPPER SKIN BETWEEN STA 903.5 - 933 AND STG-1R AND STG-2R. WAS REPAIRED IAW SRM 53-00-01-2R REPAIR 1 REV 93 AUG 15/2025