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 DALA2025112608649Snubber · leakingSHIP 6813 NUMBER 4R DOOR SNUBBER LEAKING. CORRECTIVE ACTION: REPLACED R4 DOOR SNUBBER IAW B757 AMM 52-11-10 TO BE INSTALLED ON JC 186950-0800-0066 STEP 6. JOB COMPLETE. (1321145)SDR IPXA2025112636097Flap System · inoperativeTE FLAPS DISAGREE POSITIONING FLAPS 1 ON LANDING C/W FIM 27-51 FT 814. MSG CLEARED NO FUALTS NOTED. OPS CK REF AMM 27-51-00. NO MSG. OK TO CONTINUE.SDR IPXA2025112640366Door Seal · tornCREW ENTRY DOOR SEAL TORN.SDR AALA202511265913Adiru · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO CLT DUE TO AN AIR DATA FAULT MESSAGE. THE AIRCRAFT LANDED SAFELY AT CLT AND TAXIED TO THE GATE UNDER ITS OWN POWER. MAINTENANCE REPLACED THE NR 2 AIR DATA INERTIAL REFERENCE UNIT (ADSDR AALA202511266843Power Supply · no testAIRCRAFT WAS NOT GROUNDED: 335100 BAT/EPSU FAULT FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511267463Power Supply · no testAIRCRAFT WAS NOT GROUNDED: 335100 BAT/EPSU FAULT FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DALA2025112608637Frame · damagedTOOLING DAMAGE ON FRAME 63 AFT SIDE BETWEEN P2 AND P'2 - SEVEN LOCATIONS. REPAIRED DAMAGE PER ERA 628248-14 REV ORIG. (1321489)SDR DALA2025112608636Fastener · damagedFASTENER HEAD AND BRACKET HAVE TOOLING MARKS ON FWD SIDE OF FRAME C26 AND P'5(RT). CORRECTIVE ACTION: REPAIRED PER ERA 628248-14 REV ORIGINAL. (1320973)SDR DALA2025112608644Access Panel · corrodedLEFT WING TANK, ACCESS PANEL 540KB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON LT WING FUEL TANK ACCESS PANEL # 540KB IAW A319 SRM 51-72-11-911-001. (1321290).SDR DALA2025112608643Access Panel · corrodedLEFT WING ACCESS PANEL #540QB WITH ELONGATED HOLE. REPLACED ON LT WING FUEL TANK ACCESS PANEL #540QB IAW A319 SRM 51-72-11-911-001. (1321286).SDR DALA2025112608642Access Panel · corrodedLEFT WING TANK, ACCESS PANEL 540LB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. REPLACED ON L/H WING FUEL TANK ACCESS PANEL # 540LB IAW A319 SRM 51-72-11-911-001. (1321276).SDR DALA2025112608641Access Panel · corrodedLEFT WING TANK, ACCESS PANEL 540JB WITH BOLT HOLES WITH CORROSION IN SEVERAL PLACES. CORRECTIVE ACTION: REPLACED ON L/H WING FUEL TANK ACCESS PANEL # 540JB IAW A319 SRM TASK 51-72-11-911-001. (1321268).SDR DALA2025112608640Seat Track · corrodedPASSENGER CABIN FLOOR STRUCTURE LH I/B SEAT TRACK BETWEEN FR 65 AND FR 66 WITH CORROSION. COMPLIED WITH ER/A 630188-14. (1321201).SDR DALA2025112608639Seat Track · corrodedPASSENGER CABIN FLOOR STRUCTURE RH O/B SEAT TRACKS BETWEEN FR 65 AND FR 66 WITH CORROSION. COMPLIED WITH ER/A 630188-14. (1321186).SDR DALA2025112608638Seat Track · corrodedPASSENGER CABIN FLOOR STRUCTURE RH I/B SEAT TRACKS BETWEEN FR 65 AND FR 66 WITH CORROSION. CORRECTIVE ACTION: COMPLIED WITH ER/A 630188-14. (1321173).SDR AALA202511269960Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: FOUND L1 DOOR HALF OPEN WITH SLIDE ARMED. LATCH ASSEMBLY PULLED FROM COVER ANS SLIDE HALF OUT. REMOVED AND REPLACED L1 DOOR SLIDE. PER 08L22125001.SDR AALA202511262617Cover · detachedAIRCRAFT WAS NOT GROUNDED: RIGHT SIDE AFT GALLEY EXIT SIGN COVER IS DETACHED. RESECURED RIGHT AFT GALLEY, EXIT SIGN COVER. PER AMM 33-51-01.SDR AALA202511269534Battery · degradedAIRCRAFT IN BASE MAINTENANCE: WELS BATTERY #4 DEGRADED. MAINTENANCE REPLACED WITH A NEW WELS BATTERY.SDR AALA202511269830Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 CABIN DOOR SLIDE ACCUMULATOR PRESSURE LOW. MAINTENANCE SERVICED R1 DOOR DAMPER TO CORRECT SPECIFICATION PER AMM 52-10-00.SDR DXTA2025112605839Battery Pack · failedARM LIGHT TEST FAIL MULTIPLE TIMES, TRIED UNSUCCESSFUL RECHARGE PROCEDURE. REPLACED BATTERY PACKS. OPS CHECK GOOD. IAW CESSNA CE-680A AMM 33-50-06SDR FDEA202511252206Light · malfunctionedEMERGENCY LIGHTS AT R1 ARE NOT ILLUMINATED NOW WHEN DOOR IS ARMED. AMM: 33-51-00-5 MEL: 52-11-05-02. PERFORMED EMERGENCY LIGHTS TEST IAW AMM 33-51-00-5 REV MAY 09/2025 AND SATS. ACFT OK FOR SERVICE PREVIOUSLY EMERGENCY LIGHTS WERE ON WITH DOOR CLOSED, 52-1SDR FDEA202511252205Floor Panel · dentedMAIN CARGO COMP. STA 285 TO STA 412 & RBL54.75 TO RBL77.5 ABOVE FLOOR PANEL 222CFF SURFACE SKIN HAS INDENTATION MARKS. FABRICATED NEW FLOOR PANEL 222CFF, MPN: 141T5856-116, RBL 54.75- RBL 77.50, STA 285-412 IN REF. TO BOEING DWG 141T5856-116. SEE JPF FOR ASDR CALA2025112611486Lamp · inoperativeLEFT GROUND ILLUMINATION EMERGENCY EXIT LIGHT AT BS 727F INOPERATIVE. RELAMPED LT SLIDE EMERGENCY LIGHT AT BS 727F IAW 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2025112611484Battery · faultedFWD L EPSU BATTERY FAULT ON FAP. REPLACED FWD L BATTERY IAW AMM 33-51-38-000-002-A. OPS CHECKED NORMAL.SDR N6WA2025112602Lamp · inoperativeROW 15 EMERGENCY LIGHT INOPERATIVE. RELAMPED ROW 15 EMERGENCY LIGHT IAW AMM 33-51-09. OPS CHECKED GOOD.SDR 2A6D20251125001Crossbeam · chafedVARIOUS DAMAGES AT THE AFT LANDING GEAR LOCATION, THE FIRST DAMAGE (#1) IS AT THE AFT LANDING GEAR CROSS BEAM SHIM (P/N: 350A214344.20) IN THE FORM OF CHAFING. THE CHAFE DAMAGE IS POSSIBLE DUE TO WEAR IN THE SHIM (P/N: 350A410064.20) BETWEEN THE AFT LANDING GESDR DALA2025112508621Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR37, Y450. REPAIRED PER SRM 53-21-15-300-002. (1320720)SDR DALA2025112508620Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74, -Y450. REPAIRED PER SRM 53-00-15-283-001. (1320715)SDR DALA2025112508619Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR50 TO FR51, -Y450. REPAIRED PER SRM 53-31-15-283-001. (1320709)SDR DALA2025112508618Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR63 TO FR64, -Y450. REPAIRED PER SRM 53-00-15-283-001. (1320653)SDR DALA2025112508617Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR37.1, -Y450. REPAIRED PER SRM 53-21-15-300-002. (1320634)SDR DALA2025112508616Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.1 TO FR53.2, Y450. REPAIRED PER SRM 53-31-15-300-001. (1320623)SDR DALA2025112508615Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.2, -Y450. REPAIRED PER SRM 53-31-15-283-001. (1320608)SDR DALA2025112508614Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR52 TO FR53, -Y450. REPAIRED PER SRM 53-31-15-300-001. (1320587)SDR DALA2025112508613Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR35, Y1456. REPAIRED PER A330 SRM 53-21-15-300-002. (1320544)SDR DALA2025112508612Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.1 TO FR53.2, Y2462. REPAIRED PER SRM 53-31-15-300-001. (1320524)SDR DALA2025112508611Seat Track · corrodedCABIN SEAT TRACK LONGERON UPPER SURFACE FOUND CORROSION AT FR33 TO FR34, -Y2462. REPAIRED PER A330 SRM 53-00-15-283-001. (1320516)SDR DALA2025112508610Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73-FR74, Y450. REPAIRED PER A330 SRM 53-41-15-300-002. (1320505)SDR DALA2025112508609Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.3, Y2462. REPAIRED PER A330 SRM 53-31-15-300-001. (1320493)SDR DALA2025112508608Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.3 TO FR53.4, -Y2055.5. REPAIRED PER SRM 53-31-15-300-001. (1320485)SDR DALA2025112508607Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR 37.3 TO 37.4, Y2462. REPAIRED PER SRM 53-21-15-300-002. (1320476)SDR DALA2025112508606Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR33 TO FR34, Y1959. REPAIRED PER SRM 53-00-15-283-001. (1320470)SDR DALA2025112508605Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR53.1 TO FR53.2, -Y2462. REPAIRED PER A330 SRM 53-31-15-283-001. (1320399)SDR DALA2025112508604Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR35 TO FR36, Y953. REPAIRED PER A330 SRM 53-00-15-283-001. (1320397)SDR QR9R2025112500001Transmitter · failedDURING ENG #1 START, MM INDICATION BEGAN TO MOVE PAST 77% REACHING THE MM EXCEEDANCE ONCE THE ENG REACHED IDLE. A TEST FLIGHT EVAL FOUND DURING TWO CONSECUTIVE STARTS OF #1 ENG; MAST MOMENT GAVE 3-4 AND 2 ERRONEOUS DEVIATIONS ABOVE 90%. ADDITIONAL 2 DEVIATIONSSDR AALA202511252221Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FUSELAGE SKIN ADJACENT TO AFT LAVATORY SERVICE PANEL, LOCATED AT BS 847, S25L. REPAIRED SKIN PER EA 369756.SDR JJBA20251125110Battery Pack · inoperativeEMERGENCY LIGHT #2 BPS INOPERATIVE. REMOVED AND REPLACED #2 BPS. OPS CHECK GOOD.SDR 2025FA0000785Engine · faultedPURPOSE OF OCCURRENCE REPORT : SAFRAN AIRCRAFT ENGINES VILLAROCHE SHOP RECEIVED A NOTIFICATION FROM ITS SUBCONTRACTOR, REGARDING A NON-CONFORMANCE DUE TO AN INCORRECT CONFIGURATION EXPORTED ON A SHOP MODULE INSTALLED ON AN EXPORTED ENGINE. THE LEAP-1A SHOP MODSDR UIEA2025112501323Switch · faultedRUDDER TRIM SWITCH WOULD NOT MOVE TRIM IN FLIGHT(<P>PERFORMED OPERATIONAL TEST OF RUDDER TRIM SYSTEM, ALL CHECKS OK & SWITCH OPERATION CHECKED GOOD PER AMM 27-21-00. NO FAULTS NOTED. RAN TEST OF SWITCH NUMEROUS TIMES. ALL CHECK OK PER FIM 27-21</P>)SDR ABXA20251125308Elec Connector · unsecureDURING FLIGHT, ALL MAIN CARGO DECK B LOOP SMOKE DETECTOR LIGHTS INDICATING AMBER. RESET CONNECTOR ON CARGO CONTROL FIRE PANEL. ALL LIGHTS OPERATED NORMAL. FIRE TEST OPS NORMAL PER AMM 26-14-00. AIRCRAFT RETURNED TO SERVICE.