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 SWAA2026021260969Rib · crackedCRACKED INSPAR RIB, HSS 111.10 AND 28 INCHES FROM FRONT SPAR IN THE LT HORIZONTAL STAB. REPAIRED THE RIB LOCATED IAW SRM 55-10-09-2R-4, REPAIR 4.SDR SIMA20260113002Floor Support · corrodedCORROSION ON INTERCOSTAL AFT OF FR90 Y+ 10.748" (MAJOR REPAIR) REMOVED CORRODED AREA ON INTERCOSTAL BTW FR90 &FR91 +10.748" PER EMB-175 SRM 51-10-03. BLENDED AREA MEASURES L=1.4", W=0.7" D=0.- 009". THE ORIGINAL MATERIAL THICKNESS IS 0.040" PER EMB-175 SRMI SDR ASAA2026011364093Rib · crackedLEFT HORIZONTAL STAB AT APPROX HSS 120.6 INTERNAL VERTICAL STIFFNER ON RIB 3RD ONE LOOKING AFT IS CRACKED. GROUNDED - YES. REPAIRED THE RIB STIFFNER IAW SRM 55-10-09-2R-4. REMOVED & INSTALLED IAW SRM 51-40-02 AND AMM 51-31-00.SDR R61A2026020200018Skin · crackedWHILE ON HEAVY CHECK, A CRACK WAS FOUND ON LT WING LEADING EDGE AT SLAT TRACK NR 4.SDR R61A2026020200016Skin · crackedHEAVY CHECK - CRACK ON LT WING LEADING EDGE AT SLAT TRACK #5. PERFORMED CUTOUT AND INSTALLED DOUBLER REPAIR PER ETD2026-170-000858 REV ASDR JJBA20260130051Stringer · corrodedCORROSION AT STR 16L BETWEEN FRAMES 25-26. REMOVED AND REPLACED WITH NEW FROM STOCK LH FLOOR SILL FROM FR 23 TO FR 29SDR AALA202601302022Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202601308709Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202601305400Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202601307424Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202601307271Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202601300952Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR J7SA2026012800471Fce · unserviceableYELLOW X NOTED DURING PITCH TRIM MOVEMENT IN PRIMARY. REPLACED NR 2 FCE IAW AMM 27-03-01.SDR AALA202601278783Stringer · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STRINGER CLIP AT BS 500I, S26R. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202601277258Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663, RBL 23. REPAIRED ANGLE PER SRM 57-10-10-2R-5 AND AARD 51-00-05-1.SDR AALA202601276973Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB AT STABILIZER STA 175.5, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202601223388Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: SEAT 14 ABC EMERGENCY LIGHT FOUND INOPERATIVE DURING EMERGENCY LIGHT TEST. **SUPPLEMENTAL REPORT FOR (AALA202601153423) SUBMITTED 01/15/2026 BY DFW: TROUBLESHOT FOUND SEAT 14ABC EMERGENCY LIGHT UNDER SEAT CONNECTOR LOOSE. RESECURED CSDR AALA202601215439Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE, PERFORMED A REPAIR ON STRINGER 43L BETWEEN FR33 TO FR34 FWD CARGO COMPARTMENT TO ACCOMPLISH EA 370487. MAINTENANCE REWORKED FASTNER HOLES IAW EA 370487.SDR AALA202601219215Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE, PERFORMED A REPAIR ON STRINGER 44 BTW FR33 TO FR34, FWD CARGO BAY. MAINTENANCE REWORKED FASTNER HOLES IAW EA 370487.SDR DALA2026012100443Switch · intermittentL1 DOOR SLIDE INDICATION INTERMITTENT. R & R ARMED INDICATOR SWITCH AT DOOR 1L IAW AMM 52 -73.SDR DALA2026012100442Switch · faultedR2 ARM LIGHT INDICATION ON FWD FA PANEL INOPERATIVE. REPLACED R2 DOOR ARM SWITCH ON FAP. IAW AMM 52-73. (7192896)SDR SWI2026F00086Fuel Control · brokenNUMBER 1 ENGINE STUCK AT 70% N1 WITH THRUST LEVER AT IDLE. ENGINE 1 INDICATED MCT DURING THIS TIME. NO CAUTION MESSAGE, NO WARNING MESSAGE. WE CYCLED THE THRUST LEVER BY MOVING IT FORWARD AND BACK TO UNBIND THE THRUST LEVER CABLE. I DID NOT FEEL ANY BINDING ORSDR SWIA2026012000013Overheat Loop · faultedANTI ICE DUCT WARNING ON CLIMB OUT OF DEN. QHR CLEARED THE MSG AND WE DIDN€™T NEED TO USE THE ANTI ICE AFTER THAT. (FLIGHT 5366) INTERROGATED MDC AND FOUND B1 CODES 007309 (L WING LOOP B) AND 007180 (L BLEED LOOP A). TROUBLESHOT L BLEED LOOP A PER FIM 36-2SDR SWAA2026012060690Elec Connector · brokenBROKEN AISLE LIGHT ELECTRICAL CONNECTOR AT BS 500I. REMOVED AND REPLACED THE ELECTRICAL CONNECTOR D14694 AT BS 500 IAW SWPM 20-63-02, WDM 33-51-12. FUNCTIONAL TESTED GOOD.SDR AALA202601209065Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER BETWEEN FR 33 AND FR 34 AT S42L IN THE FORWARD CARGO COMPARTMENT. REPAIRED STRINGER PER EA 370487 AND SRM 53-21-13-300-018.SDR CALA2026011913081Light · faultedCHRONIC LVL 1 HIST OF FLT DECK ENTRY LIGHT NOT WORKING CORRECTLY. EXHAUSTED FIM 33-22 TASK 809. CLEARANCE BETWEEN SWITCH SENSORS IS WITHIN LIMITS. LIGHT IS CURRENTLY ON. REF SDS 33-22-00-005, ENGINES HAVE TO BE RUNNING FOR LIGHT TO GO OFF WHEN FLIGHT DECK DOOSDR SWAA2026011960728Battery Pack · no testTHE EMERGENCY LIGHTING BATTERY PACK AT THE RT OVERWING EXIT FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-06.SDR SWAA2026011960726Battery Pack · no testTHE AFT RT EMERGENCY LIGHTING BATTERY PACK FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK IAW MM 33-51-06.SDR QXEA2026011800011Fadec · malfunctionedFLIGHT 2088. ENG 1, NO DISPATCH AND ENG 1 FADEC FAULT APPEARED UPON EXITING RUNWAY AFTER LANDING. REMOVED FROM SERVICE. FAULT CODE 73216117E1B POSTED IN CMC CIRCUIT BREAKER FADEC 1A PULLED AND RESET. REPLACED LT ENGINE FADEC IAW AMM 73-21-01-000-801-A AND 73-SDR DXTA2026011706535Wire Harness · damagedNOSE GEAR UNSAFE LIGHT. : DURING GEAR EXTENSION, CREW OBSERVED THE NLG INITIALLY EXTENDED NORMALLY & DISPLAYED A GEAR UNSAFE INDICATION. CREW COMPLETED CHECKLIST & DIVERTED TO KLIT. PRIOR TO LANDING, CREW MANUALLY EXTENDED MLG, RECEIVING 3 GREEN/DOWN & LOCKED SDR DALA2026011700397Light · detachedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED, INOPERATIVE. LOCATION: 20D. LIGHT ASSEMBLY DETACHED, HANGING FROM SEAT. R &R REPLACED 20D LIGHT ASSY HOUSING AND OPS TEST GOOD ALL WORK DONE IAW AMM 33-20. (LP: 1399329)SDR DALA2026011700392Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:28D. SEAT BUSSEL THAT HOLDS LIGHT NEEDS TO BE REPAIRED & REPLACED. FWD (28D) EMERGENCY FLR LIGHT TO MEL 33-50-03A. MCC CONTACTED. CREW PLACARD INSTALLED. R & R DAMAGED HOUSING REF A319 AMM 25-21 OK FSDR DALA2026011700391Latch · brokenO2 MASK LATCH 27DEF BROKEN AND 26DEF BROKEN. FWD TO MEL 35- 21-01A (M) PROC C/W. PLACARD INSTALLED. WAS ABLE TO RESET O2 MASK PSU PANEL PER A319 AMM 35-21. OK FOR SVC. PLACARDS REMOVED. OK FOR SVC. (LP: 8008578)SDR ASAA2026011363762Light · detachedEMERGENCY LIGHTS DETACHED AT ROW 11 ACFT RIGHT. GROUNDED - YES. SECURED PATHWAY LIGHTING.SDR SWAA2026011660914Flashlight · inoperativeFWD LOWER F/A FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED IAW AMM 25-64-00-SWA-807-NG-01.SDR SWAA2026011660852Battery Pack · inoperativeRT OVERWING AREA EMERGENCY LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK FOR POWER SUPPLY M1669 IAW AMM 33-51-06, ALL EMERGENCY LIGHTS OPERATIONAL.SDR SWAA2026011660929Light · inoperativeR2 DOOR EMEREGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMPS R2 DOOR EMEREGENCY EXIT LIGHT IAW AMM 33-51-04.SDR SWAA2026011660931Connector · disconnectedWHILE REPLACING EMERGENCY LIGHT ASSYS ABOVE AND FWD OF R1 DOOR FOUND CONNECTORS D11072 AND D40042 DISCONNECTED. RECONNECTED CONNECTORS AND PERFORMED OPS CHECK; TESTED GOOD.SDR SWAA2026011660877Light · inoperativeR1 EMERGENCY EXIT LIGHT ASSEMBLIES FORWARD OF DOOR AND ABOVE DOOR WILL NOT ILLUMINATE. R & R BOTH LIGHT ASSEMBLIES IAW AMM 33-51-01.SDR SWAA2026011660996Cover · missingEMERGENCY LIGHT COVER AT 2D MISSING. REPLACED LIGHT COVER IAW AMM 33-51-00SDR SWAA2026011660966Light · failedAFT RIGHT OVERWING EMERGENCY LIGHT DOES NOT TURN WHITE WHEN TURNED ON. REMOVED & REPLACED AND PERFORMED GOOD OPS CHECK OF RIGHT OVERWING EXIT LIGHT ASSEMBLY IAW AMM 33-21-00-960-802.SDR SWAA2026011660703Handle · looseAFT ENTRY DOOR L2 ASSIST HANDLE LOOSE. SECURED AFT ENTRY DOOR L2 ASSIST HANDLE IAW AMM 52-13-31.SDR DALA2026011600375Battery Pack · inoperativeMULTIPULE EMERGANCY LIGHT OUT IN CABIN. R & R BATTERY PACK AT LOCATION B5-120 PER B717 AMM 33-51 OPS CHECK GOOD. (7804385)SDR DALA2026011600374Skin · crackedCRACK ON SKIN FUSELAGE BTW L15R, BS 037 AT AFT FUSELAGE AREA. DAMAGED FUSELAGE AREA WAS REPAIRED PER PRI 631355-14 REV. (1399353)SDR CALA2026011613012Structure · corrodedETOPS PREDEPARTURE SERVICE CHECK (PDSC) PROCEDURE. AFT WASTE SYS VACUUM BLOWER VENT PORT HAS AREA OF BUBBLING PAINT WITH UNDERLYING CORROSION. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01-1A-1, DETAILS A FOR EDGE DAMAGE EXCEEDING THE ALLOWABLE .190" AND DETASDR AALA202601158391Door Latch · bindingAIRCRAFT IN BASE MAINTENANCE: R2 DOOR LATCH WORN AND BINDING, FAILED LATCH RELEASE TEST. REMOVE AND REPLACED R2 DOOR LATCH. PER 08L22125001 R2 TASK 26-28.SDR DALA2026011500350Elbow · cloggedDIVERTED TO HND DUE TO FOUR OUT OF EIGHT LAVATORIES INOPERATIVE. FOUND PAPER TOWELS AND DIAPER CLOG AT WASTE TANK ELBOW. REMOVED CLOG. (LP# 8122462)SDR AALA202601152157Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: R1 SERVICE DOOR IS NOT CLOSING PROPERLY. LARGE GAP AROUND DOOR FRAME. ADJUSTED GUIDE ARM ON UPPER LEFT SIDE OF DOOR. PER AMM TASK 52-41-00. OPS CHECK GOOD.SDR AALA202601155676Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LATCH IS DIFFICULT TO OPEN. LUBED DOOR LATCH.SDR AALA202601153878Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR ON LEFT SIDE IS STUCK AND THE GUST LOCK WAS VERY DIFFICULT TO UNLOCK. LUBRICATED GIRT BAR GUST LOCK. OPS CHEEK NORMAL.