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 SWAA2025120233844Seal Plate · crackedCRACKED SEAL, PLATE ACCESS PANEL 333AT AT LT HORIZONTAL STAB. REPLACED THE SEAL-PLATE LOCATED ACCESS PANEL 333AT AT LT HORIZONTAL STAB IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02, AND DWG 186A3005, SHEET 1, REV B.SDR AALA202511258407Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511256039Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511251726Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR 3EJA2025112500002Cable · twistedAFT CABLE FOR ALTERNATE GEAR DOWN FOUND MANGLED DURING INSPECTION OF ALTERNATE GEAR DOWN HANDLE NOT LOCKING IN PLACE.SDR 3EJA2025112500001Cable · twistedCABLE FOUND TWISTED AND MANGLED DURING INSPECTION OF ALTERNATE GEAR DOWN HANDLE NOT LOCKING IN PLACE.SDR AALA202511245594Window · crazedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD EMERGENCY EXIT WINDOW L18 IS CRAZED. REMOVED AND REPLACED EMERGENCY EXIT WINDOW. PER AMM 56-22-00.SDR 3EJA2025112400010Bulb · failedSELECTED THE GEAR DOWN. AN INDICATION OF GREEN NOSE LIGHT AND GREEN LEFT HAND LIGHT WERE OBSERVED. AN INDICATION OF AN EXTINGUISHED RIGHT HAND/EXTINGUISHED GEAR UNLOCKED INDICATION WAS ALSO OBSERVED.SDR JJBA20251120089Rib · damagedRIGHT HAND MIDDLE LEADING EDGE DAMAGED ON REMOVAL AND HAS DAMAGE ON INBOARD EDGE. REMOVED AND REPLACED RH MIDDLE LEADING EDGE INBD RIB.SDR AALA202511202764Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511206346Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511208443Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511199950Bottle · low pressureAIRCRAFT WAS GROUNDED: AFT LEFT ENTRY DOOR EMERGENCY ASSIST BOTTLE IS BELOW PRESSURE. SERVICED AFT LEFT ENTRY DOOR EMERGENCY ASSIST BOTTLE IAW AMM 52-10-00.SDR WX0A2025111732636Door Sill · corroded(AIRCRAFT NOT GROUNDED) (DISCREPANCY NOTED DURING AIRCRAFT HEAVY MX VISIT) (MAJOR REPAIR) NRC 2000-0046: SM (1042-20) REAR FUSELAGE, FR 66 RH, STGR 23, DOOR SILL, CORROSION FOUND AROUND NUT PLATE HOLE / REAR FUSELAGE, FR 66 RH, STGR 23, DOOR SILL PERMANENTLY RSDR CALA2025111711237Channel · crackedCRACKED AFT CARGO COMPARTMENT ZEE CHANNEL, S26R, BS 727I. REMOVED AND REPLACED THE AFT CARGO BAY ZEE CHANNEL IAW SRM 51-40-02-0G-0.SDR MASA2025111000093Flashlight · no testCAPTAIN FLASHLIGHT LED NOT FLASHING / REPOSITIONED CAPTAIN FLASHLIGHT. OPS CHECK GOOD.SDR MASA2025111000092Glowstrip · missingPLACED ON MEL/ R+R PHOTOLUMIN STRIP.SDR AALA202511149084Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR FORWARD HINGE FITTING BEARING LOOSE AND WORN. MAINTENANCE REPLACED HINGE PLATE FITTING PER CMM 52-81-18.SDR DALA2025111408347Servo Control · faultedATO - AT 60 KNOTS DUE TO F/CTL AIL SERVO FAULT ECAM WARNING. RIGHT GREEN AILERON SERVOCONTROL (33CE2) PLACED ON MEL. REPLACED RIGHT INBOARD AILERON ACTUATOR. (LP 7734854)SDR CVGA20251114002Switch · faultyFLAP ASYM LIGHT CAME ON AFTER SELECTING FLAPS 20 POSITION. FAULT COULD NOT BE DUPLICATED UPON ARRIVAL TO AIRCRAFT. MCC ELECTED TO REPLACE THE FLAP FOLLOW UP SWITCH. REMOVED FLAP FOLLOW UP SWITCH P/N 45AS61015-23 S/N 08A432AND INSTALLED AN OVERHAULED FLAP FOLLOSDR QXEA2025111400342Clamp · deterioratedON PRE FLIGHT WALKAROUND, CREW REPORTS HYD LINES SUPPORT BLOCK CLAMP IS DETERIORATED. (LH WHEEL WELL). REMOVED FROM SERVICE. INSPECTED BLOCK CLAMP, (P/N # 170-09131-901, IPC REF 29-10-15-41, ITEM 300) FOUND TO BE SATURATED WITH FUEL. FOUND FUEL SEEP. REF TANK SDR QXEA2025111400341Battery · dischargedFLIGHT 2178. FLIGHT CREW REPORTS FORWARD EMERGENCY LIGHTS INOP. REMOVED FROM SERVICE. CHARGED EMERGENCY LIGHTS BATTERY REFERENCE FIM 33-50-00. EMERGENCY LIGHTS OPERATING NORMALLY AFTER RE-CHARGE. AIRCRAFT OK FOR SERVICE. NO PARTS REPLACED.SDR SIMA202511140001Battery · no testCEILING PANEL AT ROW 9 HAS EMERGENCY LIGHT THAT FAILED TO LIGHT UP DURING OPS CHECK. FOUND EMERGENCY LIGHT AT ROW 9 INOPERATIVE. R & R EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01 OPS CHECKED GOODSDR CALA2025111411210Fitting · crackedUPON REMOVAL FOUND SECONDARY FINDING NR 2 HINGE ARM LOWER SANDWHICH FITTING CRACKED. REMOVED AND REPLACED NR 2 HINGE ARM FITTING IAW SRM 55-36-42-300-003 NO FURTHER ACTION REQUIRED.SDR CALA2025111411208Controller · faultedCABIN PRES WARNING AT FL390. PILOTS STATED THEY SAW A FLUCTUATION OF 2500 FT BUT FELT NO PRESSURE IN EARS.CPC 2 TOOK OVER RIGHT AFTER CPC 1 FAIL. PERFORMED CPC1 OPS CHECK SEVERAL TIMES WITH NO FAILURES. IAW AMM TASK 21-31-34-400-001-A,SDR SWAA2025111333568Light · faultedF/O SIDE AFT EMERGENCY EXIT SIDEWALL LIGHT, FLICKERING. REMOVED AND REPLACED RH AFT OVERWING EMERGENCY EXIT LIGHT WINDOW LIGHT IAW AMM 33-21-00.SDR SWAA2025111333793Battery Pack · no testEMERGENCY LIGHTS ASSOCIATED OF BATTERY PACK M1672 FAILED TEST. REMOVED EMERGENCY BATTERY PACK M1672 AND INSTALLED SERVICEABLE BATTERY PACK AND PERFORMED GOOD INSTALLATION TEST PER AMM 33-51-06-960-802.SDR AALA202511130896Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202511131574Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKD AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR DALA2025111308328Skin · dentedER/A 630449-14 REV ORIGINAL: FUSELAGE SKIN, BS 760, S14L - S15L, DENTED AND GOUGED. REPAIRED IAW ERA 630449-14. (1298266)SDR DXTA2025111105645Contactor · faultedREPEAT WRITE UP ON APPROACH TO LANDING IN KYIP WE RECEIVED GEN 1 OFF BUS YELLOW CAS ACCOMPANIED BY SHED BUS OFF. PLACED GEN 1 SWITCH IN OFF POSITION PER QRH DUE TO THE SHORT DURATION OF FLIGHT REMAINING. PLEASE NOTE THAT N1 FOR THE SAME RESPECTIVE THROTTLE POSSDR CALA2025111311176Radome · damagedLARGE BANG CLIMBING TRU 8000 NO ABNORMALITIES CREW REPORTS A LOUD BANG AT 8,000 FT WITH NO OTHER ABNORMAL ISSUES. CREW ALSO REPORTS NO OVERWEIGHT OR HARD LANDING. UPON ARRIVAL BACK TO IAD, DISCOVERED A LARGE BIRDSTRIKE ON THE UPPER LT SIDE OF NOSE RADOME AREA.SDR ASAA2025111062228Battery Pack · no testDURING TASK CARD 78233001, BATTERY PACKS M1675, M1670, M1671, M1672, M1673, M1695, M1694, FAILED, AND CHARGER M2626 FAILED. GROUNDED - YES. REPLACED BATTERY PACKS M1675, M1670, M1671, M1672, M1673, M1695, M1694, AND CHARGER M2626 WITH BATTERY. REF AMM 33-51-06SDR SWAA2025111233396Flashlight · inoperativeRH AFT IB EMERGENCY FLASHLIGHT INOPERATIVE. R & R THE BATTERY AS REQ. PER AMM 25-64-00.SDR SWAA2025111233662Bustle · loosePROVO REPORTS R1 DOOR SLIDE BUSTLE LOOSE. SECURED LOOSE BUSTLE PER SIPSDR SWAA2025111233554Seat · out of limitsEXIT ROW SEAT 14B RECLINES WHEN IT SHOULDNT. ADJUSTED HYDRO LOC ON SEAT REF AMM 25-22-00SDR SWAA2025111233540Glowstrip · peelingROWS 12/13 CAPTAIN SIDE PHOTOLUMINESCENT STRIP PEELING OFF. REINSERTED ROW 12/13 CAPT SIDE FLOOR PHOTOLUMINSCENT COLOR FILTER STRIP IAW AMM 33-51-15.SDR SWIA2025111201Windshield · crackedRIGHT WINDSHIELD OUTER LAYER CRACKED. NO PRESSURIZATION CHANGE. (FLIGHT 4935) REMOVED AND REPLACED RT WINDSHIELD IAW AMM 56-11-01. NO DEFECTS NOTED, ACFT OK FOR CONTINUED SERVICE.SDR AALA202511120008Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFTER EMERGENCY MEGAPHONE INOPERATIVE. REMOVE AND REPLACED THE AFT EMERGENCY MEGAPHONE. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202511124246Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT ON OVERWING EXIT ROW 16FED DOES NOT ILLUMINATE. REPLACED RIGHT HAND OVER WING EMERGENCY LIGHT POWER SUPPLY M1695. PER AMM 33-51-06.SDR AALA202511122901Locking Cam · inoperativeAIRCRAFT WAS NOT GROUNDED: 2R GIRT BAR DIFFICULT ARM AND DISARM. ADJUSTED 2L DOOR GIRTBAR RETAINER CLIP. PER AMM 25-66-01. OPS CHECKED GOOD.SDR AALA202511126997Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICE R4 DOOR ASSIST IAW AMM 52-20-00.SDR DALA2025111208299Cover · detachedEMERGENCY EXIT SIGN COVER CAME OFF AT OVERWING SEAT 21G. RESECURED AS REQUIRED. (7971972)SDR DALA2025111208297Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING LOCATIONS:605. READJUSTED EMERGENCY HANDLE COVER CLAMP AS NECESSARY. OK FOR SVC. (1296424)SDR DALA2025111208278Skin · corrodedEVIDENCE OF CORROSION FOUND ON LWR FUSELAGE SKIN BETWEEN FR34 AND FR35 JUST AFT OF DRAIN BETWEEN S36L AND S36R. REMOVED CORROSION ON LWR FUSELAGE SKIN FR34-FR35, S36L-S36R, NO DAMAGE PERMITTED IN THIS AREA IAW A220 ASRP J51-21-06, J53-31-01 . RESTORED FINISH ASDR FDEA202511102154Skin · crackedTAIL ENGINE INTAKE DUCT LEADING EDGE FOUND MULTIPLE CRACKS. #2 ENGINE NOSE COWL REMOVED AND REPLACED AS PER AMM 54-22-01-04, CARRIED OUT NOSE COWL ANTI-ICE SYSTEM FUNCTIONAL TEST AS PER AMM 30-22-00-700-804, FOUND SATISFACTORY. REPAIR CLASSIFIED AS MINOR ASDR CALA2025111211167Eec · faultedREJECTED TAKE OFF FOR ENG FAILURE INDICATION FOLLOWD BY ENG FAIL AND EEC FAIL IAW FIM 77-11 TASK 805 P2 AND P5 ON EPCS PAGE. CHECKED SIMILAR LEAKAGE CHECK FOR BOTH LINES CO WITH NO FINDING. REPLACED THE EEC IAW AMM 73-21-04-400-801, EEC SOFTWARE CONFIGURASDR CALA2025111111136None · no discrepancyFWD CABIN CALL LIGHT ON OVERHEAD PANEL NOT LIGHTING UP WHEN CALLED, ALSO NO EICAS CABIN CALL RESET FLIGHT ATTENDANCE PHONE L1 DOOR LIGHT, AND EICAS MESSAGE IN FLIGHT DECK OPERATE CORRECTLY IAW AMM 23-19-00NSDR CALA2025111111135Slide · no discrepancySLIDE IS NOT DETACHING FROM DOOR. FA CONCERNED ABOUT SMALL GAP BETWEEN SLIDE PACK ASSY AND THE DOOR. VERIFIED SCREW TIGHTNESS ON SLIDE PACK COVER ASSY TO DOOR REF AMM TASK 25-66-01-400-803. NO FURTHER DEFECTS NOTED AT THIS TIME. OK TO CONTINUE SERVICE AT THIS SDR CALA2025111111134Bottle · low pressureSLIDE PRESSURE GUAGE AT DOOR 2L LOW. INSPECTED DOOR 2L ESCAPE SLIDE PRESSURE GUAGE, NEEDLE IS IN THE GREEN BAND REF AMM 25-66-02. PIC ATTACHED.