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 DALA2025100207182Frame · damagedSHIP 3407 FUSELAGE / FR 30, S-5R / FRAME / TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626190-14. (1229271)SDR DALA2025100207181Skin · damagedSHIP 3321 / FUSELAGE / SKIN / AFT OF FR 61 / BETWEEN P2 AND P3 / NEEDS PERMANENT REPAIR. CORRECTIVE ACTION: PERMANENT REPAIR PER ERA 629144-14. (1228894)SDR DALA2025100207180Skin · crackedSHIP 3321 VIASAT / AFT ANTENNA STAND-OFF DOUBLER / FUSELAGE SKIN / FR 64/ CRACKS AND DOUBLE DRILLED FASTENER HOLES. CORRECTIVE ACTION: REPAIRED PER ERA 629146-14. (1228744)SDR DALA2025100207179Frame · damagedSHIP 3321 TOOLING DAMAGE ON FR60-64 LH. CORRECTIVE ACTION: REPAIRED PER ERA 627429-14 REV. (1229280)SDR DALA2025100207178Frame · damagedSHIP 3321 TOOLING DAMAGE FR 60-64 LH AND RH. CORRECTIVE ACTION: COMPLIED WITH ERA 627429-14. (1229272)SDR DALA2025100207177Skin · misrepairedSHIP 3321 FOUND 2EA MIS-LOCATED AND PARTIALLY PLUGGED HOLES THROUGH THE A/C SKIN AND ANTENNA ATTACH FITTING DOUBLER BETWEEN FR62-63 AND STR 1R-2R. CORRECTIVE ACTION: REPAIRED PER ERA 629016-14 REV. ORIG. (1229340)SDR DALA2025100207176Frame · misrepairedSHIP 3321 WHILE WORKING NON-ROUTINE 178 LOCATED MISS-DRILLS AND MULTIPLE PLUG FASTENERS UNDERNEATH VIASAT DOUBLER LOCATED @ FRAME C64 STR1L. CORRECTIVE ACTION: REPAIRED PER ERA 629146-14 REV ORIG. (1229326)SDR DALA2025100207175Frame · crackedSHIP 3321 CRACKS ON FRAME 64. CORRECTIVE ACTION: REPAIRED PER ERA 629146-14 REV. ORIG. (1229323)SDR DALA2025100207174Skin · damagedSHIP 3321 FUSELAGE / SKIN / FR 62 - FR 63 / P'1 - P'2 / VIASAT MOD / MISLOCATED FASTENER HOLES. CORRECTIVE ACTION: REPAIRED PER ERA 629016-14. (1228573)SDR DALA2025100207173Seat Track · corrodedSHIP 3317 CABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.8 TO FR53.9, Y450. CORRECTIVE ACTION: REPAIRED BETWEEN FR53.8 AND FR55, Y450 PER A330 SRM 53-31-15-300-001. (1228409)SDR IPXA2025100241817Warning Message · illuminatedAIR TURNBACK. AFTER TAKEOFF WHILE RETRACTING FLAPS FROM F5 TO F1 WE RECEIVED C HYD QTY ABD STATUS PAGE SHOWED QUANTITY DECREASINGSDR DXTA2025100205172Door · faultedMAIN CABIN DOOR DOES NOT FREEFALL OPEN. UNUSUALLY STRONG FORCE IS REQUIRED TO OPEN THE DOOR FROM INSIDE OR OUTSIDE. UNUSUALLY STRONG FORCE IS REQUIRED TO MOVE THE DOOR HANDLE FROM THE OPEN OR CLOSED POSITION AS WELL. CORRECTIVE ACTION: PERFORMED CABIN DOOR HESDR DALA2025100207172Floor Support · corrodedSHIP 5801 CORROSION ON FLOOR STRINGER (UPPER AND LOWER SIDES) RBL. 7.55 BTW STA 1365 TO 1395 AT AFTER CARGO COMPARTMENT (C2). CORRECTIVE ACTION: SUMMARY OF NRC 00519. CORROSION LEVEL 2. FLOOR STRINGER (UPPER AND LOWER SIDES) RBL. 7.55 BTW STA 1365 TO 1395 AT ASDR AALA202510024284Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT AFT SEAT ON THE LEFT OUTBOARD SIDE REQUIRES NEW BATTERY. REMOVE AND REPLACED FLASHLIGHT. PER JOB CARD 09C00005001.SDR AALA202510020342Door · jammedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY DOOR ON AFT RIGHT SIDE JAMS AT TOP OF FRAME. RETIGHT LOOSE SCREW AT AFT RIGHT SIDE LAVATORY DOOR TOP FRAME. PER AMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202510028051Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS HARD TO OPEN AND CLOSE. LUBED COCKPIT DOOR LATCH ASSEMBLY. PER FIM 52-50-00-810-802. OPERATIONAL CHECK GOOD.SDR DALA2025100207171Battery Pack · no test(LOG 7574128) FOUND FIRS CLASS, FWD ENTRY DOORS, AND COCKPIT DOME EMERGENCY LIGHTS INOP. R/R BOTH FWD EMERGENCY LIGHT BATTERY PACKS. TEST OK. PER B737 AMM 33-51.SDR AALA202510026523Diaphragm · leakingAIRCRAFT WAS NOT GROUNDED: FOUND DOOR ASSIST PRESSURE AT 0 PSI.MAINTENANCE REPLACED FWD LH DOOR DIAPHRAGM IN THE PERCUSSION MECHANISM OF THE DOOR DAMPER AND EMERGENCY OPERATION CYLINDER OF THE PASSENGER/CREWDOORS IAW WITH AMM 52-10-00.SDR AALA202510024479Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R/H AFT PASSENGER DOOR DAMPER ACT LOW. MAINTENANCE SERVICED R/H AFT ENTRY DOOR DAMPER ACT. IAW W/C 26T20005001.SDR N6WA2025100206Seat Track · corrodedCORROSION ON RH SEAT TRACK BETWEEN FS480.00-FS690.00. REMOVED AND REPLACED RH SEAT TRACK BETWEEN FS480.00-690.00 IAW CRJ SRM 51-41-02SDR N6WA2025100205Seat Track · corrodedCORROSION ON LH SEAT TRACK LBL27 BETWEEN FS480.00-FS560.00. REMOVED AND REPLACED SEAT TRACK AT LBL27 BETWEEN FS480.00-FS560.00 IAW CRJ SRM 51-41-02SDR N6WA2025100204Seat Track · corrodedCORROSION ON LH SEAT TRACK LBL09 BETWEEN FS480.00-FS690.00. REMOVED AND REPLACED LH SEAT TRACK AT LBL09 BETWEEN FS480.00-FS690.00 IAW CRJ SRM 51-41-02SDR N6WA2025100203Seat Track · corrodedCORROSION ON RH SEAT TRACK BETWEEN FS340.00-FS460.00. REMOVED AND REPLACED RH SEAT TRACK BETWEEN FS340.00-FS460.00 IAW CRJ SRM 51-41-02SDR N6WA2025100202Seat Track · corrodedCORROSION ON LH SEAT TRACK LBL09 BETWEEN FS340.00-FS460.00. REMOVED AND REPLACED LH SEAT TRACK AT LBL09 BETWEEN FS340.00-FS460.00 IAW SRJ SRM 51-41-02SDR N6WA2025100201Seat Track · corrodedCORROSION ON LH SEAT TRACK LBL27 BETWEEN FS380.00-FS460.00. REMOVED AND REPLACED LH SEAT TRACK AT LBL27 BETWEEN FS380.00-FS460.00 IAW CRJ SRM 51-41-02SDR QXEA2025100200314Transducer · malfunctionedFLIGHT 2364. A-I ENG 1 FAIL CAUTION AT CRUISE. NO ECS SELECTED ON TAKEOFF. RAN CHECKLIST. DID NOT RESOLVE. RETURNED TO FIELD AND ACCOMPLISHED UNEVENTFUL LANDING. REMOVED FROM SERVICE. VERIFIED FAULT ON EICAS. FAULT CODE 30210004011 ACTIVE. PERFORMED FIM TASK SDR YENA2025100200990Igniter · wornFLT#687, BOS-LAX. (ETOPS) ENGINE IGN 1 B FAULT ( IGNITION SYSTEMS B) SYSTEM B ); FOUND L ENG IGN-B IGNITER PLUG FULLY WORN OUT. REMOVED AND REPLACED L ENG IGNITER PLUG-B PER EMM 74-21-01. OPS CK'D SATIS & ITEM OK FOR SVC AT THIS TIMESDR JJBA20251002001Battery · dislodgedLEFT EXTERNAL FWD EMERGENCY LIGHT INOPERATIVE. FOUND EMERGENCY BATTERY 1 HAS FALLEN OFF OF ASSEMBLY. REINSTALLED THAT EMERGENCY BATTERY. OPS CHECK SAT.SDR DXTA2025100205174Seal · out of positionTWICE THE MAIN DOOR FAILED TO CLOSE FROM THE OUTSIDE, AND TWICE FAILED TO OPEN NORMALLY FROM THE OUTSIDE. WHILE CLOSING IT APPEARS TO BE FLUSH BUT THE LOCKING HANDLE WOULD NOT STOW. THE DOOR WAS CYCLED DOWN AND WORKED NORMALLY. WHILE OPENING, THE HANDLE WAS PUSDR DXTA2025100205169Door · lack of lubeMAIN DOOR LATCH TAKES A LOT OF PRESSURE TO PUSH DOWN INTO LOCKED POSITION. LUBRICATED MAIN CABIN DOOR. OPS CHECK GOOD. IAW CE-680A MM 12·20-40SDR AALA202510022735Cover · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS IN RIGHT HAND HORIZONTAL STABILIZER HINGE COVER LOCATED AT ELEVATOR STATION 39.02. REPAIRED CRACKS PER SRM 55-20-01-2R-4.SDR DALA2025100207147Valve · faultedDIVERTED INTO MAD DUE TO DUAL BLEED FAULT. REPAIRED LEAK IN SENSE LINE AND REPLACED OVER PRESSURE VALVE. OPS AND LEAK CHECKED GOOD. OK FOR SERVICE. (7491375)SDR DALA2025100107146Filter · odorPRONOUNCED DIRTY SOCK ODOR THROUGH OUT FLIGHT BOTH WITH APU & WITHOUT. R & R BOTH RECIRCULATION FILTERS PER A319 AMM 21-21-82. (7588178).SDR DALA2025100107145Unknown · odorTHE COCKPIT HAD AN INTENSE PLASTICY BAD ODOR. T/S SMOKE & FUMES IN COCKPIT OF APU PER STEPS OF AMM 49-00-00- 200-812-A. NO FINDINGS AND REPORTED AS LEVEL A. ACCOMPLISHED LEVEL A DECONTEMINATION PER WORKCARD 2100-2007. (7597562).SDR DALA2025100107142Structure · damagedFWD GALLEY LAMINATE IS COSMETICALLY DAMAGED. REPLACED FWD GALLEY LAMINATE PER A319 AMM 25-31. (1228214).SDR YENA2025100100989Battery · failedFLT#591, BOS-TPA. "DURING CHECK OF EMERGENCY BATTERY CABIN IAW AMP TASK 335100-03-1 FWD L BATT FAULT FOUND; REMOVED AND REPLACED L FWD BATT 10WL IAW AMM 33-51-38 CKD GOOD."SDR YENA2025100100988Battery · failedFLT#591, BOS-TPA. "EMERGENCY EXIT SIGNS AIRCRAFT RIGHT REMAINED ON ENTIRE FLIGHT AND AIRCRAFT RIGHT WAS OFF ENTIRE FLIGHT; ED TSM 33-51-00-810-837A PERFORMED EPSU OPS BITE CK IAW AMM 33-51-00 FOUND 11WL BATT FAULT DURING BITE(L EMERG EXIT BATT) R&R 11WL BATSDR HNAA2025100100653Mixer Box · odorAFTER T/O, CREW REPORTS STRONG BURNING SMELL, MORE RUBBBER THAN ELECTRICAL. RAR CONDENSER/ MIXER OPS CHECK GOOD.SDR DALA2025100107137Packing · leakingCREW REPORTED ODOR IN FLIGHT DECK ON DECENT AND EMERGENCY DECLARED. O2 MASK DONNED. 1 FLIGHT ATTENDANT REPORTED FEELING LIGHTHEADED. FOUND OIL BEHIND BOTH SPINNERS, REPLACED BOTH ENGINE FAN SHAFT COVER PACKING AND FOAM WASHED BOTH ENGINES PER AMDS WORK CARD SDR DALA2025100107128Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR36 TO FR37, -Y450. REPAIRED BETWEEN FR36 AND FR37, -Y450 PER A330 SRM 53-21-15-300-002. (1228157)SDR DALA2025100107127Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.2 TO FR53.3, -Y2462. REPAIRED BETWEEN FR53.2 AND FR53.4, -Y2462 PER A330 SRM 53-31-15-300-001. (1228134)SDR DALA2025100107126Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR37 TO FR37.1, Y1959. REPAIRED BETWEEN FR37 AND FR37.4, Y1959 PER A330 SRM 53-21-15-300-002. (1228120)SDR DALA2025100107125Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR37 TO FR37.1, Y-450. REPAIRED BETWEEN FR37 AND FR37.1, Y-450 PER A330 SRM 53-21-15-300-002. (1228094)SDR DALA2025100107124Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR36, Y1959. REPAIRED BETWEEN FR32 AND FR37, Y1959 PER A330 SRM 53-21-15-300-002. (1228065)SDR DALA2025100107130Bracket · damagedTOOLING DAMAGE ON BRKT FWD SIDE OF FRAME 62 BTWN STR P'2 AND P'3. REPLACED BRACKET IAW AIRBUS DRAWING F5347982002400 AND SRM 53-11. (1228062)SDR ESPA202510010675Engine · fireTRANSPORTING PASSENGERS FROM KNTD TO KNSI. ONCE THE ACFT BEGAN CLIMBING TO CRUISE ALTITUDE, CAPT & 1ST OFFICER NOTICED SIGNS OF A LT ENGINE FAILURE & RESPONDED TO AN ENGINE FAILURE. FA1 NOTIFIED CAPT OF THE ENG FIRE, & CAPT ATTEMPTED TO PUT OUT THE FIRE WHILESDR FDEA202510011868Floorboard · dentedMIAN CARGO AT APPROX. STA 285 TO 412 & LBL11 TO RBL11, FLOORBOAD 221CFF ABOVE SURFACE SKIN HAS MINOR INDENTATION (MARKED) FABRICATED NEW FLOOR PANEL (PNL 221CFF MPN: 145T5856-105) AT STA 285 TO STA 412 BETWEEN RBL 11 AND LBL 11 IN REF TO BOEING DWG# 145T58SDR FDEA202510011867Floor Panel · dentedMIAN CARGO AT APPROX. STA 285 TO 412 & RBL33 TO RBL11, FLOORBOAD 222AFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) FABRICATED FLOORPANEL 222AFF MPN# 141T5856-107 RBL 11- RBL 33 STA 285-412 IN REF TO BOEING DWG 141T5856-107. SEE JPF FOR ALL WORKSTEPS ACOMPSDR FDEA202510011866Floor Panel · dentedMIAN CARGO AT APPROX. STA 285 TO 412 & LBL33 TO LBL11, FLOORBOAD 221DFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) FABRICATED FLOORPANEL 221DFF MPN# 141T5856-117 LBL 11-LBL 33 STA 285-400 IN REF TO BOEING DWG 141T5856-117. SEE JPF FOR ALL WORKSTEPS ACCOMPSDR FDEA202510011861Spar Cap · corrodedLEFT WING - TRAILING EDGE REAR SPAR LOWER CAP UPPER SURFACE AT STATION XORS 1003 FOUND CORROSION AFTER REMOVAL OF ACCESS PANEL. LEFT WING TRAILING EDGE REAR SPAR LOWER CAP UPPER SURFACE AT STATION XORS 1003 CORROSION REMOVED AND FOUND EXCEEDED LIMIT AS P