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 SWAA2025123055928Lens · missingR2 SERVICE DOOR VERTICAL EXIT/SALIDA VERTICAL LENS COVER MISSING. REPLACED WITH NEW PER M/M SIPSDR DALA2025123009518Light · inoperativeON SVC CHK FOUND L3 DOOR SIDEWALL EXIT EMERGENCY LIGHT INOP. R & R L3 SIDEWALL EXIT LIGHT ASSY REF AMM 33-51. OPS CHK GOOD. (7689624)SDR DALA2025123009516Reservoir · low pressureL1 DOOR ASSIST BOTTLE BELOW SERVICE CHECK LIMITS. R & R L1 EMERGENCY POWER RESERVOIR IAW AMM 52-11-30. (8138794)SDR AALA202512303824Guide · brokenAIRCRAFT WAS GROUNDED: 4L GUST LOCK IS NOT ACTIVATING ACCORDING TO CATERING. MAINTENANCE FOUND GUIDE FOR THE L4 DOOR GUST-LOCK CONTROL MECHANISM BROKEN ALLOWING THE TUBE ASSEMBLY TO SLIP PAST THE ACTUATING LEVER OF THE DOOR STAY MECHANISM. MAINTENANCE REPLACEDSDR AALA202512306466Handle · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED ON APPROACH AT ABOUT 1000FT MSL. FLIGHT ATTENDANT REPORTED AFTER LANDING THE DOOR HANDLE HAD MOVED UP SLIGHTLY. LIGHT EXTINGUISHED AFTER DOOR HANDLE PUSHED DOWN. MAINTENANCE ADJUSTED L1 ENTRY DOOR SENSDR AALA202512306439Bottle · 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 AALA202512301918Terminal · brokenAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETUNED TO DFW DUE TO THE FLIGHT CREW REPORTING THAT THE WINDOW R1 SHATTERED DURING CLIMB. WINDOW HEAT ELEMENT STARTED FLASHING BRIGHT LIGHTS, THE FLIGHT CREW TURNED OFF WINDOW HEAT AND APPROXIMSDR AALA202512300790Target · misalignedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT OVERWING LEFT HAND SIDE INDICATION STATUS MESSAGE DOOR LEFT OVERWING EXIT DISPLAYED. MAINTENANCE REALIGNED DOOR PANEL LATCH COVER TARGET AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-20-00.SDR AALA202512309764Sensor · out of adjustAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED ON APPROACH AT ABOUT 1000FT MSL. FLIGHT ATTENDANT REPORTED AFTER LANDING THE DOOR HANDLE HAD MOVED UP SLIGHTLY. LIGHT EXTINGUISHED AFTER DOOR HANDLE PUSHED DOWN. MAINTENANCE ADJUSTED L1 ENTRY DOOR SENSDR AALA202512308685Lanyard · unsecureAIRCRAFT WAS NOT GROUNDED: A CABLE WITH A COTTER PIN IS HANGING OUT OF THE 1R DOOR SLIDE PACK. MAINTENANCE RESECURED SLIDE COVER LANYARD PER AMM 25-66-01.SDR AALA202512300088Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512302005Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: AFTER ENTRY GIRT BAR LOOSE. MAINTENANCE SECURED GIRT BAR AMM 25-66-01.SDR AALA202512301367Sensor · faultedAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR LIGHT ILLUMINATED DURING CRUISE. MAINTENANCE REPLACED SENSOR S194 AND ACCOMPLISHED A SATISFACTORY OPS CHECK PER AMM 52-71-11.SDR AALA202512300359Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER IAW AMM 52-10-00.SDR AALA202512308105Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR 4USA2026F00000Flap System · fault messageDURING APPROACH INTO KBZN WHILE ATTEMPTING TO LOWER THE FLAPS TO 5 DEGREES, GOT THE "FLAP FAIL" MESSAGE. FLAP SYSTEM INSPECTED AND FOUND BIT CODES 2, 5 & 8 ON FLAP CONTROLLER. ALSO FOUND DEICE FLUID IN LEFT AND RIGHT FLAP COVES. CLEANED BOTH FLAP COVES AND CSDR AALA202512309866Door Latch · failedAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR OPENED ON LANDING. DURING TAXI IN, HEARD THE ELECTRONIC LOCK CLICK AS IT DOES DURING DOOR TEST. MAINTENANCE REPLACED COCKPIT DOOR LOCKING SYSTEM IAW AMM-52 14-51-14.SDR 6CBA2025123025001Cabin Pressure · malfunctionedDURING A ROUTINE FLIGHT FROM KTPA TO KOSU, AT FL270, THE CREW NOTED AN ACF LOW INFLOW CAS FOLLOWED BY THE CABIN NOT MAINTAINING ALTITUDE. AN EMERGENCY WAS DECLARED AND THE CREW DIVERTED TO KLOZ WHERE THEY LANDED SAFELY WITHOUT FURTHER INCIDENT. THE ECS SYSTESDR YENA2025123001312Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 66 RT IN OPEN FASTENER HOLE UPPER INBO ARD AT DOOR STOP FITTING 7 POSITION, CRACK DIRECTION IS 6 OCLOCK, CRAC K DEPTH IS 0.105 INCH APPROX, AT AFT GALLEY AREA (1 EA); REF AEROMAN WO 2025 278/1 NR 2025-622954 SDR YENA2025123001311Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 RH SIDE IN OPEN FASTENER HOLE LOWER INBO ARD AT DOOR STOP FITTING 1 POSITION, CRACKDIRECTION IS 12 OCLOCK, CRA CK DEPTH IS 0.095 INCH APPROX, AT AFT GALLEY AREA (1 EA); (RESOLVED ON W/O: 1409520 TASKCARD: SDR YENA2025123001310Structure · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND IN HOLE C LOCATED IN DOUBLE JOGGLE AREA FR16 LH SIDE. CRACK DIRECTION IS 3 OCLOCK LOOKING OUTBOARD. CRACK DEPTH IS 0. 080 INCHES APROX. CONFIRM CRACK INDICATION USING BOROSCOPE VIEW IAW NTM 51-90-00; (RESOLVED OSDR YENA2025123001309Structure · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND IN HOLE B LOCATED ON DOUBLE JOGGLE AREA FR16 LH SIDE. CRACK DIRECTION IS 3 OCLOCK LOOKING OUTBOARD. CRACK DEPTH IS 0. 120 INCHES APROX. CONFIRM CRACK INDICATION USING BOROSCOPE VIEW IAW NTM 51-90-00; (RESOLVED OSDR YENA2025123001308Structure · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND IN HOLE C LOCATED AT DOUBLE JOGGLE AREA, FR16 R H SIDE. CRACK DIRECTION IS 3 OCLOCK LOOKING OUTBOARD. CRACK DEPTH IS 0 .130 INCHES APROX. CONFIRM CRACK INDICATION USING BOROSCOPE VIEW IAW NTM 51-90-00; (RESOLVEDSDR YENA2025123001307Intercostal · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND IN UPPER INBOARD HOLE LOCATED AT DOOR STOP 7, F R16, LH SIDE. CRACK DIRECTION IS 1 AND 9 OCLOCK LOOKING FWD. CRACK DEP TH IS 0.100 INCHES APPROX; REF AEROMAN NR 2025-622881 WO 2025 278/1 REMOVED AND REPLACED INTSDR YENA2025123001306Support · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL LOC. BTW FR66/FR68 AT LEVEL STR23L AFT GALLEY ARE A (CPCP RELATED); (RESOLVED ON W/O: 1409520 TASKCARD: NR-00043) REF AEROMAN NR 2025-622947 WO 2025 278/1 EMOVED AND REPLACED LOWER SILL LOCATED BTW FR66/FR68 AT LSDR YENA2025123001305Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION SEAT TRACK +Y1162.5 LOC. BTW FR69/70 AFT GALLEY AREA (1 EA) (CPCP RELATED);(RESOLVED ON W/O: 1409520 TASKCARD: NR-00044) REF AEROMAN NR 2025-622946 WO 2025 278/1 REMOVED AND REPLACED SEAT TRACK Y1162.5 LOC BTW FR69/70, IN ASDR YENA2025123001304Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 2 WINDSHIELD CENTER POST LOWER ATTACHMENT C ONTINUITY FITTING RH SIDE, CRACK LENGTH IS 0.200 INCH APPROX, IN COCKP IT (1 EA); REF AEROMAN WO 2025 278/1 NR 2025-622906 PERFORMED REPAIR IAW AEROMAN EA 53-0068-2SDR YENA2025123001303Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 2 WINDSHIELD CENTER POST LOWER ATTACHMENT IN TERNAL AREA, LH SIDE, FROM UPPER TENSION BOLT, CRACK DIRECTION IS 2 OC LOCK, CRACK LENGTH IS 0.105 INCH APPROX, IN COCKPIT (1 EA); RESOLVED ON W/O: 1409520 TASKCARSDR YENA2025123001302Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 2 WINDSHIELD CENTER POST LOWER ATTACHMENT IN TERNAL AREA, LOWER INBOARD CORNER, LH SIDE, CRACK LENGTH IS 0.230 INCH APPROX, IN COCKPIT (1 EA); (RESOLVED ON W/O: 1409520 TASKCARD: NR-00050) REF AEROMAN WO 2025SDR YENA2025123001301Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 2 WINDSHIELD CENTER POST LOWER ATTACHMENT IN TERNAL AREA, LOWER INBOARD CORNER, RHSIDE, CRACK LENGTH IS 0.080 INCH APPROX, IN COCKPIT (1 EA); REF AEROMAN WO 2025 278/1 NR 2025-622907 PERFORM PERMANENT REPAIRSDR YENA2025123001300Skin · dentedDURING HEAVY MAINTENANCE: DENT EXTERNAL SKIN LOC. FR10 TO FR11 BTW STR2R TO STR3R ON UPPER FUSELAGE; (RESOLVED ON W/O: 1409520 TASKCARD: NR-00048) REF AEROMAN WO 2025 278/1 NR 2025-622588 EVALUATED DENT LOC. FR10 TO FR11 BTW STR2R TO STR3R ON UPPER FUSELAGE ASDR YENA2025123001299Stringer · corrodedDURING HEAVY MAINTENANCE: CORRODED STR 32, FR 58 LH SIDE ON AFT CARGO COMPARTMENT; REF AEROMAN W.0 2025 278/1 N.R. 2025-622963 **PERFORMED PERMANENT REPAIR LOCATED ON STR32, AT LEVEL FR58, LH SIDE IN AFT CARGO COMPARTMENT I.A.W. A320 SRM 53-00-13-300-001; THISDR YENA2025123001298Frame · crackedDURING HEAVY MAINTENANCE, CRACK INDICATION FOUND AT OPEN FASTENER HOLE, ZONE 1 VERTICAL STRINGER RADIUS Ñ4 IN CENTER FUSELAGE ON FRAME 36. CRACK DEPTH 0.095 INCH. CRACK DIRECTION 12 OCLOCK VIEW FWD TO AFT; REF AEROMAN NR 2025-623139 WO 2025 278/1 CCOMPLISHEDSDR YENA2025123001297Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND AT OPEN FASTENER HOLE LOC. ZONE 2 VERTICAL STRINGER RADIUS Ñ4 IN CENTER FUSELAGE ON FRAME 36. CRACK DEPTH 0.115 INCH . CRACK DIRECTION 11 AND 12 OCLOCK VIEW FWD TO AFT; REF AEROMAN NR 2025-623135 WO 2025 278/1 CSDR YENA2025123001296Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND AT OPEN FASTENER HOLE LOC. ZONE 2 VERTICAL STRINGER RADIUS Ñ2 IN CENTER FUSELAGE ON FRAME36. CRACK DEPTH 0.118 INCH . CRACK DIRECTION 12 OCLOCK VIEW FWD TO AFT; REF AEROMAN NR 2025-623119 WO 2025 278/1 ACCOMPLISSDR YENA2025123001295Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND AT OPEN FASTENER HOLE LOC. ZONE 1 VERTICAL STRINGER RADIUS Ñ2 IN CENTER FUSELAGE ON FRAME 36. CRACK DEPTH 0.108 INCH . CRACK DIRECTION 12 OCLOCK VIEW FWD TO AFT; REF AEROMAN NR 2025-623122 WO 2025 278/1 CCOMPLISSDR YENA2025123001294Pressure Deck · crackedDURING HEAVY MAINTENANCE, CRACK INDICATION FOUND AT FASTENER HOLE, LOCATED AT PRESSURE DECK MEMBRANE TO CENTER BOX AREA, ON FR 36, Y1292 + 9 INCHES TO OTBD, LT SIDE, CRACK DIRECTION IS 12 OCLOCK LOOKING AFT, CRACK DEPTH IS 0.089 INCH REF AEROMAN NR 2025-62326SDR YENA2025123001293Pressure Deck · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MEMBRANE TO ENTER BOX AREA, ON FR36 AND -Y1292 PLUS 6 INCHES TO OUTBOARD, RH SIDE, CRACK DIRECTION IS 1 OCLOCK LOOKING AFT, CRACK DEPTH IS 0.115 INCH; REF AEROMAN NR 202SDR YENA2025123001292Pressure Deck · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MEMBR ANE TO CENTER BOX AREA, ON FR36AND Y1292 PLUS 4 INCHES TO OUTBOA RD, LH SIDE, CRACK DIRECTION IS 12 OCLOCK LOOKING AFT, CRACKK DEPTH IS 0.184 INCH; REF AEROMAN NR SDR YENA2025123001291Pressure Deck · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MEMBR ANE TO CENTER WING BOX AREA, ON FR36 AND Y1292 PLUS 5 INCHES TO OUTBOA RD, LH SIDE, CRACK DIRECTION IS 12 OCLOCK LOOKING AFT, CRACK DEPTH IS 0.119 INCH; REF AEROMASDR YENA2025123001290Pressure Deck · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MEMBR ANE TO CENTER WING BOX AREA, ON FR3 AND -Y1292 PLUS 2 INCHES TO OUTBO ARD, RH SIDE, CRACK DIRECTION IS 12 OCLOCK LOOKING AFT, CRACK DEPTH IS 0.109 INCH; REF AEROMASDR YENA2025123001289Skin · corrodedDURING HEAVY MAINTENANCE: CORROSION INTERNAL SKIN LOC BTW FR65 TO FR 66, STRINGER 31RH ON AFT C ARGO COMPARTMENT; REF AEROMAN NR 2025-623339 WO 2025 278/1 PERFORMED REPAIR ON EXTERNAL SKIN BTW FR65 TO FR 66 , STRINGER 31RH IAW EA#53-0077-25 PART 1-3, EA COVER SDR YENA2025123001288Stringer · corrodedDURING HEAVY MAINTENANCE: CORROSION STRINGER 31RH LOC BTW FR65 TO FR 66 ON AFT CARGO COMPARTMENT (CPCP FINDING); REF AEROMAN WORK ORDER 2025 278/1 NR 2025-623177 REMOVED AND REPLACED STRINGER 31R LOCATED BTW FRAME 64 TO FRAME 67 IN AFT CARGO COMPARTMENT I.A.W.SDR YENA2025123001287Door Sill · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL DOOR LOC AFT POSITION ON BULK CARGO COMPARTMENT ( CPCP FINDING); REF AEROMAN WO 2025 278/1 NR 2025-623038 REMOVED AND REPLACED DOOR SILL BEAM LOCATED BTW FR60 THRU FR62, AT LEVEL STR38R, IN BULK CARGO COMPARTMENT SDR YENA2025123001286Dummy Rail · corrodedDURING HEAVY MAINTENANCE: CORROSION RAIL DUMMY Y503.2 LOC. BTW FR12/FR16 FWD GALLEY AREA (1 EA) (CPCP FINDING); REF AEROMAN WO #2025-278/1 NR # 2025-623108 REMOVED AND REPLACED NEW RAIL DUMMY (FLOOR BEAM) Y503.2 LOC. BTW FR12/FR16 FWD GALLEY AREA I.A.W A320 SSDR YENA2025123001285Seat Track · corrodedDURING HEAVY MAINTENANCE: "CORROSION FLOOR BEAM +Y1292 LOC. BTW FR12/FR24 AT FWD GALLEY AREA (1 EA) (CPCP FINDING); REF AEROMAN WO # 2025-278/1 NR# 2025-623109 REMOVED AND REPLACED FLOOR BEAM Y1292 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA IAW A320 SRM 51-11-1SDR YENA2025123001284Seat Track · corrodedDURING HEAVY MAINTENANCE: CORROSION FLOOR BEAM +Y765 LOC. BTW FR12/FR24 AT FWD GALLEY AREA (1 E A) (CPCP FINDING); REF AEROMAN WO # 2025-278/1 NR # 2025-623113 REMOVED AND REPLACED FLOOR BEAM Y765 LOC. BTW FR12 AND FR24 AT FWD GALLEY AREA IAW A320 SRM 51-42-11SDR YENA2025123001283Window Frame · crackedDURING HEAVY MAINTENANCE: FUSELAGE / NOSE FWD FUSELAGE / WINDSHIELD FRAME / CENTER POST LOWER NODE AREA & CONTINUITY FITTING RH/LH SIDE / CRACKS - PERMANENT REPAIR; REFERENCES: /1/ AEROMAN EA 53-0068-25 (COVER + PARTS 1-6) /2/ AIRBUS DOSSIER 81677616 /3/ AIRBUSDR YENA2025123001282Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / LOWER SKIN PANEL / FR64-FR65 BETWEEN STGR43L-STGR44 / CORROSION AND ELONGATED HOLE - TIME LIMITED REPAIR; REFERENCES: /1/ AEM EA 53-0094-25 (COVER + PARTS 1-4) /2/ AIRBUS DOSSIER 81702291 /3/ AIRBUS RDAF 817SDR YENA2025123001281Pressure Panel · crackedDURING HEAVY MAINTENANCE: FUSELAGE / CENTER FUSELAGE / FR 36 LH & RH SIDES / PRESSURE PANEL / CRACK DAMAGES AT MULTIPLE HOLES – TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0071-25 REV. 0 (COVER + PARTS 1-11) /2/ AIRBUS RDAF 81680593/005/2025#A /3/ AIRBU