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 AALA202601151370Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727D AND BS 727E, AT LBL 24. REPLACED TRANSITION PANEL IAW AARD 51-00-05-1.SDR AALA202601159716Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727G TO BS 767, AT RBL 24. REPLACED TRANSITION PANEL IAW SRM 51-40-02.SDR AALA202601150290Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSY BETWEEN BS 767 AND BS 787, AT RBL 24. REPLACED SHIELD IAW AARD 51-00-05-1.SDR NACA2025123000001Actuator · failedAPU FUEL SHUT OFF VALVE FAILED AN OPS CHECK. APU FIRE SWITCH CHECK, DOES NOT CLOSE OR OPEN ELECTRICALLY. R & R THE APU SHUT OFF VALVE ACTUATOR IAW AMM 28-25-00-004-032, & AMM 28-25-02-404-008 STEPS 3.G. (3) - 3.G (8). PERFORMED APU FUEL FEED SYS TEST. TESSDR AALA202601130153Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LT AFT OVERWING EXIT DOOR FWD UPPER STOP PAD ROTATED OUT OF POSITION. REPOSITIONED THE STOP PAD IAW AMM 52-22-01.SDR AALA202601132045Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT FWD OVERWING EXIT DOOR AFT STOP PAD ROTATED. REPOSITIONED RT FWD OVERWING EXIT DOOR AFT STOP IAW AMM 52-22-01.SDR IXXA20260112001Channel · corrodedCORROSION ON THE INSIDE OF THE U CHANNEL THAT SUPPORTS THE HYD ISOLATION VALVE, LOCATED ON THE BACK WALL IN THE LEFT WHEEL WELL STA 1180SDR CALA2026010912823Battery Pack · dischargedEMERGENCY LIGHT BATTERY M1672 HAS LOW VOLTAGE CHARGE. REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY M1672 AND OPS CHECK GOOD IAW AMM 33-51-06-960-805.SDR AALA202601085676Stop Fitting · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO AFT ENTRY DOOR SURROUND FORWARD UPPER STOP FITTING AT BS 957, S8L. REPLACED STOP FITTING PER AARD 51-00-05-1.SDR SWIA20260107230Pump · failedFUEL 1 LO LEVEL WARNING MESSAGE DURING FLIGHT. QRH COMPLIED WITH AND DIVERSION REQUIRED. (FLIGHT 3102) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31453918. TROUBLESHOOT FUEL 1 LO LEVEL WARNING MESSAGE IN REFERENCE TO ERJ175 FIM 28-44-00. PERFORMED OPS TESDR DALA2026010700135Pawl · damagedUNABLE TO ARM 1R DOOR. REPLACED R1 DOOR INTERLOCK PAWL. CKS OK PER B767-300 TASK 52-11 (8139770)SDR DALA2026010700121Scdu · shortedPAX AT 1 AB SPILLED WATER ON FLOOR RESULTING IN TV SCREENS SHORTING OUT . POPPING NOISES AND SLIGHT ELECTICAL ODOR DETECTED AND DISSIPATED. CORRECTIVE ACTION: R &R SPM 1A, R&R SCD 1A. FNF MONITORS AT SEATS 1AB OPS CHK NML IAW B757 AMM 23-32-08 DOC #1000543. (8SDR AALA202601070181Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: FUSELAGE SKIN CORROSION AT BS 887 AND S26L TO S26R. REWORKED THE AREA. PER SRM 53-00-0-1A-1.SDR CALA2026010712741Floor Support · corrodedMAIN CABIN BS 294-312 RBL-13 HAS CORROSION ON FLOOR SUPPORT. REMOVED AND REPLACED CORRODED FLOOR SUPPORT IAW DWG 141A5600, REV N, AND SRM 51-40-02.SDR CALA2026010712740Skin · dentedLEFT WING, NR 4 SLAT LEADING EDGE HAS 2 DENTS. REPAIRED THE LT WING NR 4 SLAT LEADING EDGE IAW SRM 51-70-10-2R-2.SDR AALA202601067520Terminal · dirtyAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY EXIT LIGHT BY AFT LEFT HAND DOOR (L2) IS INOPERATIVE. CLEANED EWIS AFT ESCAPE SLIDE LIGHT L732 TERMINAL LUG, PER B737-NG SWPM 20-30-00 AND B737-NG SWPM 20-10-04. PERFORMED SATISFACTORY OPERATIONAL CHECK, PER B73SDR AALA202601063608Wire · shortedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WILL NOT UNLOCK OR LOCK AFTER CODE IS ENTERED.MID LATCH INDICATING FAULT. MAINTENANCE TROUBLESHOT IAW TSM 52-51-00-810-801-A AND FOUND WIRE NUMBER 7803-20 CONNECTING TO B ON SPLICE 7118VS IAW AWM 52-51-02 SHIELD SHORSDR AALA202601063235Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23L LOCATED AT FR69 TO FR70 AT AFT GALLEY AREA. MAINTENANCE REPLACED SHEAR PLATE STR 23L LOCATED FR69 TO FR70 AT AFT GALLEY AREA IAW A320 SRM 51-72-11-911 AND DWG D53474180.SDR SWAA2026010556651Megaphone · inoperativeAFT MEGAPHONE INOPERATIVE. R & R AFT MEGAPHONE IAW AMM 25-64-00SDR SWAA2026010556684Battery · inoperativeFLIGHT DECK FLASHLIGHT LED INCIDATOR FLASHED RED DURING PUSH-TO-TEST. REMOVED AND REPLACED FLIGHT DECK FLASHLIGHT BATTERY PACK IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2026010557035Circuit Breaker · brokenCIRCUIT BREAKER P6-11 A9 BROKEN. CABIN EMER LIGHTS. REMOVED AND REPLACED CIRCUIT BREAKER P6-11 A9 IAW AMM 20-60-05.SDR SWAA2026010556733Sign · dislodgedEMERGENCY EXIT SIGN IN CENTER AISLE DISLODGED. SECURED AISLE EMERGENCY EXIT SIGN IAW AMM 33-51-00.SDR SWAA2026010556648Lens · missingEMERGENCY LIGHT LENS ON CEILING PANEL ABOVE ROW 21 DEF MISSING. INSTALLED NEW EMERGENCY LIGHT LENS IAW AMM 33-51-03.SDR DALA2026010500064None · noneTRACKING FOR ACCOMPLISHMENT OF ER/A 615647-14AD. ACCOMPLISHMENT OF ER/A 615647-14A (1377242)SDR EVCA2026010500001Pump · failedHYDRAULIC SYSTEM FAILURESDR ANCF2026010523041Sensor · faultedNLG STEERING FAULT DURING FLIGHT - FOLLOWING TSM 32-51-00-810-812-A REV. 75 WAS PERFORMED CHECK AND CLEANING IN THE ELECTRICAL CONNECTOR OF STEERING FEEDBACK MONITOR SENSOR (4GC) AND
ELECTRICAL CONNECTOR OF STEERING FEEDBACK CONTROL CHANNEL (3GC) IAW ESPM 20SDR CALA2026010412648Skin · corrodedFOUND EXFOLIATED CORROSION AT STA 540 CENTER WING LOWER SKIN FROM SPAR BETWEEN S-22R & 23R. ACCOMPLISHED REPAIR AT WING CENTER SECTION LOWER SKIN BS 540 BETWEEN S22R AND 23R ESR-WI 3-13294 AND ECRA 5710-02953,SDR DALA2026010500052Brake Assy · malfunctionedON LANDING ROLL AND TAXI-IN SIGNIFICANT PLAY IN LEFT BRAKE PEDAL IN BOTH CA & FO CONTROLS, LEADING TO SIGNIFICANT ASYMMETRICAL BRAKING & BRAKE TEMP RISE. INSPECTED BRAKES IAW AMM 32-42-27. SUSPECT HIGH GROUND WIND CAUSING DIFF. BRAKING. NO FAULTS & NO 10DAY SDR DALA2026010500051Oxygen Mask · unwanted deployDURING POWER TRANSFER FROM GPU TO APU, A FEW OXYGEN MASK FELL ON THE REAR OF THE AIRCRAFT. RESTOWED OXYGEN MASK IN RT AFT GALLEY. REF AMM 35-21. (LP: 8031298)SDR AALA202601057670Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294.5, AT S17R AND RBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWIA2026010200030Windshield · crackedFO SIDE FORWARD WINDSCREEN CRACKED (DURING TAXI IN) SPANNING WHOLE WIND SCREEN AT BOTTOM CAUSING SMOKE WHEN HEAT IS ON. (TURNED HEAT OFF). (FLIGHT 5799) REFERENCE CP 31455889 FOR REMOVAL OF THE FO WINDSHIELD. INSTALLED FO WINDSHIELD WITH REFERENCE TO AMM 56-SDR SWI2026F00000Warning Message · illuminatedFUEL 1 LO LEVEL WARNING MESSAGE DURING FLIGHT. QRH COMPLIED WITH AND DIVERSION REQUIRED. (FLIGHT 3102) OPEN.SDR GTIA2026010239232Hinge Fitting · corroded"WEAR FIXED BUSHINGS (4EA) ON CENTER HINGE FITTING REAR SPAR OF SPOILER #5 LH WING, RAF-01 3529483-01 GENERATED. REPAIRED CENTER HINGE FITTING O/B SIDE O/B LUG REAR SPAR OF SPOILER #5 AND REPLACED BUSHINGS (4EA) ON L/H WING I.A.W. A320 SRM 51-21-11, A320 SRM SDR GTIA2026010239231Flashlight · inoperativeR2 JUMPSEAT FLASHLIGHT INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R&R R2 JUMPSEAT FLASHLIGHT IAW AMM 25-60-00 THIS CLEARS MDDR 125158 PLACARD REMOVED OPS CHECK GOOD DMI LOG UPDATEDSDR CALA2026010212629Fuel Cap · missingFUELER REPORTED MISSING FUEL CAP ON ARRIVAL. REMOVED AND REPLACED FUEL CAP REF AMM 28-25-41-000-001/400-005SDR CALA2026010212598Skin · buckledRESKIN AFT PIT DOOR. REMOVED AND REPLACED OUTER SKIN IAW DWG 146A6110 REV C, SRM 52-30-01-2R-3, REPAIR 3, AND CMM 52-13-14.SDR CALA2026010212597Skin · buckledRESKIN FWD CARGO DOOR. REMOVED AND REPLACED OUTER SKIN IAW DWG 143A6110 REV D, SRM 52-30-01-2R-3 REPAIR 3, AND CMM 52-31-15.SDR CALA2026010212596Floor Support · corrodedMAIN CABIN BS 312-328, RBL 13 HAS CORROSION ON FLOOR SUPPORT. REMOVED AND REPLACED FLOOR SUPPORT AT BS 312-328, RBL 11 IAW SRM 51-40-02 AND DWG 141A5400, REV-.SDR DXTA2026010206365Actuator · faultedUPON BRINGING THE GEAR UP ON TAKEOFF, WE GOT A GEAR DISAGREE AMBER CAS MESSAGE. LEFT MAIN GEAR STAYED DOWN. NOSE AND RIGHT MAIN GEAR WENT UP. ACCOMPLISHED THE GEAR DISAGREE QRH. R & R LT STAY ACTUATOR IAW AMM 32-32-07. R &R LT BRACE ATTACH PIN IAW AMM 32-32-0SDR DXTA2026010206369Battery Pack · faultedCABIN EMER LIGHTS ILLUMINATED IN FLIGHT WITH THE EMER LT SWITCH IN THE ARM POSITION. PERFORMED ENERGENCY LIGHTING OPS CHECK CONFIRMED DISCREPANCY, EMERGENCY LIGHTS STAY ON WITH SWITCH IN ARM, COMPLIED WITH FIM, FOUND NR 2 BATTERY PACK AT FAULT, . R & R FWD ESDR DXTA2026010206375Uplock Switch · faultedUPON SELECTING GEAR DOWN, RECEIVED AN AMBER GEAR DISAGREE L, AND THE GEAR INDICATION SHOWED A BLACK BOX WITH AN AMBER X. THE QRH WAS COMPLETED, TO INCLUDE BLOWING THE GEAR DOWN AND PULLING THE UPLOCK HANDLE IN THE LAV. THERE WAS NO CHANGE IN THE LEFT GEAR INDISDR DXTA2026010206381Battery Pack · faultedALL EMER LIGHTS IN CABIN FLICKERING. REPEAT WRITE UP. REMOVED AND REPLACED NR 1 & 2 EMERGENCY BATTERY PACK AND PERFORMED OPS CHKD IAW AMM 33-52-01. OPS CHKD GOOD.SDR DXTA2026010206366Warning Message · illuminatedAFTER ENGINE START EMER LIGHT NOT ARM CAS MESSAGE ANNUNCIATED. GROUND START RESET UNSUCCESSFUL.SDR DXTA2026010206379Battery · trippedWITH BOTH BATTERIES DISCONNECTED, EMERGENCY LIGHTS IN OFF POSITION AND AFTER PRESSING 5G SWITCH, MAIN CABIN DOOR EXIT LIGHT, SEAT #3 EMERGENCY LIGHT, AND BOTH WING INSPECTION LIGHTS REMAIN ON RESET TRIPPED #2 EMERGENCY LIGHT BATTERY PACK INERTIA SWITCH. PERFORSDR FDEA202512302298Skin · delaminatedRH OUTBD FLAP HAD A DENT/IMPACT DAMAGE WITH AREA OF DELAM ON THE LEADING EDGE OF THE FLAP AT APPROX WS STA 741.0 REPAIRED RH WING OUTBD FLAP TRAILING EDGE NOSE SKIN L/E PNL (MPN: 113T3112-402) AT WS STA.741.0 (MARKED AREA) IN REF. TO 767 SRM 57-53-01-2R SDR AALA202601024463Bottle · low pressureAIRCRAFT WAS GROUNDED: AFTER DOORS CLOSED AND SLIDES ARMED, L1 DOOR SHOWS RED ON CIDS PANEL WITH CHECK DOOR PRESSURE ALERT. MAINTENANCE SERVICED THE L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601029461Striker · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN WHEN CLOSED AND UNLOCKED. MAINTENANCE CLEANED, LUBRICATED DOOR LATCH STRIKER ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00 WITH NO ISSUES NOTED.SDR AALA202601021132Door · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN FROM OUTSIDE. MAINTENANCE CLEANED AND LUBRICATED FLIGHT DECK DOOR. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR AALA202601022967Life Vest · not openedAIRCRAFT WAS NOT GROUNDED: LIFE VEST AT 19A HAS BEEN OPENED. MAINTENANCE REPLACED LIFE VEST IN SEAT 19A PER AFMM 20.25.70.SDR AALA202601024125Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND EMERGENCY EXT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.