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 YENA2025062300645Bleed Valve · failedFLT#73, JFK-EDI. (ETOPS). ENG 2 BLEED FAULT DURING DESCENT AT APPROX 16000'. ( HIGH PRESSURE VALVES (HPV) ). REMOVED AND REPLACED #2 ENG HP VALVE IAW AMM 36-11-86. OPS CHK GOOD. MX-4 UPDATED. PLACARD REMOVED. ENGINE: IAE, PW1133GAJM.SDR GTIA2025062338967Slide · deployedFLIGHT CREW DEPLOYED L1 DOOR SLIDE ( PASSENGER OR OVER WING DOOR SLIDE/SLIDE RAFTS (WITHOUT PASSENGERS) )--SDR YENA2025062300644Warning Message · illuminatedFLT#1726, LAX-JFK. (ETOPS). 'CLASS III AIR BLEED MSG ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED ). PER TSM 36-22-00-810-836-A REPLACED CERAMIC AT 36HF. HARD FAULT CLEARED. BMC 1 AND 2SDR WX0A2025062332472Gasket · leaking(AIRCRAFT NOT GROUNDED) FA'S REPORT ON DESCENT THE DIRTY SOCKS SMELL IN THE AFT GALLEY/CABIN STARTED AT 18000 FOR 10 MIN AND DISSIPATED BEFORE LANDING / (RESOLVED ON W/O: 524910 TASKCARD: NR-00001 ) COMPLETED TASK CARD 21-000-002. NO SMELL DETECTED. FOUND OILSDR 2025FA0000419Hose Connector · leakingDURING A 72 MONTH SCHEDULED MAINTENANCE INPUT AT BOMBARDIER SERVICES (UK) LTD AT BIGGIN HILL AIRPORT, UNDER WO 283560 - TASK REQUIRED TO PERFORM FUNCTIONAL CHECK OF THE OXYGEN PASSENGER REGULATOR UNIT IAW BD700-AJ35-21-01-00AAA-340-B-A. TEST FAILED AND OXYGEN SDR EVCA20250623001Pump · failedHYDRAULIC FAILURESDR IPXA2025062367750Battery Pack · no testCAPT EMERG FLASHLIGHT FLASHING RED AT TEST. FLASHLIGHT BATTERY REPLACED IAW AMM 25-60-60-960-801 REV.47. OPERATIONAL TEST OF CAPT FLASHLIGHT PERFORMED IAW AMM 25-60-60-710-801 REV.47. FOUND SATIS.SDR IPXA2025062368744Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 1960 S-11R, LEVEL 1. OKAY TO WORK.SDR IPXA2025062370033Accumulator · low pressureAFTER TAKEOFF GREEY SYS HYD LOW PRESSURE ECAM AIRCRAFT WAS VIBRATING LANDING GEAR WOULD NOT RETRACT FOLLOWED ECAM PROC AND ATB TO SDF. REMOVED AND REPLACED GREEN HYDRAULIC ACCUMULATOR REF AMM 29-11-56/0401 OPS CHK GOOD. C/W LANDING GEAR NORMAL EXTENSION AND SDR DALA2025062304663Switch · faultedDIV - INTO BOS DUE TO (L) AFT DOOR OPEN INDICATION AT CRUISE. DEACTIVATED DOOR INDICATION AND FWD TO MEL. CONTINUE IN SERVICE. THEN R/R PSCU PER A330 AMM 52-71. OK FOR SERVICE.SDR FDEA202506231027Power Supply · failedWHILE WORKING WRI 05-25/1837, ASPSU TEST SHOWED BATTERY 1 FAULT. AMM: 52-73-18-04 REMOVED AND REPLACED ASPSU EMERGENCY POWER SUPPLY BATTERY 1( AERO DESIGN, INC., PN: AD-3214-31, SN: 246253). OPS CHECK GOOD. OK FOR SERVICE.SDR FDEA202506231026Support Angle · crackedAFT FUSELAGE - LOWER TORQUE BOX UPPER PANEL ON LOWER SURFACE AT ACTUATOR SUPPORT ANGLES AREA CRACKED (1.125") AT STATION 2122.881 X = -10. CRACK (1.125 ) AT STATION 2122.881 X = -10, AFT FUSELAGE - LOWER TORQUE BOX UPPER PANEL ON LOWER SURFACE AT ACTUATOR SDR 2025FA0000417Support Beam · corrodedVISUAL EXFOILIATING CORROSION FOUND OF LH ENGINE PYLON SUPPORT BEAM AT SCHEDULED AIRCRAFT INSPECTION. .75 INCH L BY .50 INCH W, .012 INCH DEEP. CORRECTIVE ACTION IS DAMAGED AREA WAS REMOVED AND INSTALLED DOUBLER. WORK PERFORMED IN REFERENCE TO LEARJET INC./ODSDR 2025FA0000416Relay · burnedLATAM AIRCRAFT VISIT FOR HEAVY MAINTENANCE. DURING THE MAINTENANCE, THE PRODUCTION PERSONNEL REPORTED THAT INSIDE P33 PANEL FOUND SIGN OF BURN ON ONE OF THE STUDS OF MAIN CARGO DOOR LATCH RELAY K2218.SDR JR2R20250623808Shear Tie · corrodedAFT CARGO SHEAR TIE AT FR76 BETWEEN STRINGER 28L AND 29L IS CORRODED OUT OF LIMITS. REPAIREDSDR CALA2025062305791Seal · leakingCAPT SIDE WINDOW SEAL MAKING LOUD NOISE DURING CLIMB OUT. WINDOW CLSD BUT WOULD NOT SEAL FOUND WHITE RUBBER SWITCH CAP IN CAPTAIN SLIDING WINDOW TRACK AND GREASE AROUND FORWARD SEAL OF SLIDING WINDOW. REMOVED CAP AND CLEANED SLIDING WINDOW SEAL OF DEBRIS AND GSDR CALA2025062305789Dau · faultyELEC AC BUSS 1 FAULT FOLL OWED BY NUMEROUS ECAMS EVEN THE SYSTEM S APPEARED NORMAL PFR CONSIDER ADDING TSM 24-50-00-810-806-A FOR TSHOOTING. INLCUDES POSSIBLE CORROLATION OF ELEC AC BUSS 1 FAULT AND SDAC. PER TSM24-50-00-810-806-A, REPLACED SDAC2, REF MM31-55SDR CALA2025062305782O-Ring · leakingG HYD RSVR LO LV ECAM - TOMC KROWN UPDATED MAA CODE FIX USING VENDOR MAA SCREEN PLEASE CONTACT TOMC BEFORE COMMENCING ANY WORK. ISOLATE LEAK SOURCE. ISOLATE LEAK SOURCE. FOUND UNION O-RING DAMAGED ON THE PTU-MANIFOLD GREEN, (1113GM). REPLACED "O" RING, LEAKSDR CALA2025062305781Window · arcedWINDOW 2 BEGAN ARCING EXTERIOR PANE R2 CRACKED AND DAMAGED THIS IS FOR R1 WINDOW R&R. UPDATING M&L TO REFLECT (35MH AND 22GT) ACP E-LOTO, REMOVED 2 EACH EFIS PANELS REF AMM31-62-12-000-801, REMOVED DFCS CONTROL PANEL REF AMM22-11-34-000-801, REMOVED RH WINSHEISDR SIMA20250622003Skin · gougedRH & LH WING FIXED L/E SKIN IS GOUGED UPPER SIDE BETWEEN SLAT 2 ; 3 AND 4. (MAJOR REPAIR) REPAIRED RH & LH WING FIXED LEADING EDGE SKIN BETWEEN SLAT 2; 3 AND 4 AND # IAW ERS-EJ-57MR-1718SDR SWAA2025072984484Handle · deterioratedDETERIORATED LINING ENTRY DOOR NUT ASSIST HANDLE AT FWD GALLEY AREA (4 EA). REPLACED LINING ENTRY DOOR NUT ASSIST HANDLE AT FWD GALLEY AREA (4 EA) IAW AMM 52-11-31-400-802 STEP 3. G. ITEM. (2).SDR SWAA2025072984483Handle · deterioratedDETERIORATED ENTRY DOORWAY LINING NUT ASSIST HANDLE AT FWD GALLEY AREA (2 EA). REPLACED ENTRY DOORWAY LINING NUT ASSIST HANDLE AT FWD GALLEY AREA (2 EA) IAW AMM 25-21-31-420-802 STEP 3.B.(6).SDR SWAA2025072984488Handle · deterioratedDETERIORATED ENTRY DOOR LINING ASSIST HANDLE NUT AT AFT GALLEY AREA (2 EA). REPLACED ENTRY DOOR LINING ASSIST HANDLE NUT AT AFT GALLEY AREA IAW AMM 52-13-31-400-802 STEP 3.G (2).SDR SWAA2025072984491Handle · deterioratedDETERIORATED ENTRY DOOR DOORWAY ASSIST HANDLE NUT AT AFT GALLEY AREA (2 EA) . REPLACED ENTRY DOOR DOORWAY ASSIST HANDLE NUT AT AFT GALLEY AREA IAW AMM 25-21-25-420-801 STEP 3.B (5).SDR SWAA2025072984489Handle · deterioratedDETERIORATED SERVICE DOOR LINING ASSIST HANDLE NUT AT AFT GALLEY AREA (2 EA). REPLACED SERVICE DOOR LINING ASSIST HANDLE NUT AT AFT GALLEY AREA IAW B737-700 AMM 52-41-31-400-802 STEP 3.F (2) .SDR SWAA2025072984490Handle · deterioratedDETERIORATED SERVICE DOOR DOORWAY ASSIST HANDLE NUT AT AFT GALLEY AREA (2 EA). REPLACED SERVICE DOOR DOORWAY ASSIST HANDLE NUT AT AFT GALLEY AREA (2 EA) IAW B737-700 AMM 25-21-25-420-801 STEP 3.B.(5).SDR SWAA2025072984478Rib · crackedCRACK ON RIB LOCATED LE STA 95.96 ACCESS PANEL 341B AT RT HORIZONTAL STABILIZER. REPLACED RIB LOCATED LE STA 95.96 ACCESS PANEL 341B AT RT HORIZONTAL STABILIZER IAW SRM 51-10-02 ITEM 9 AND SRM 51-40-02.SDR IPXA2025071758007Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180 S13L. PERFORM EO-94472-REQ1 REV.1 AND EI F2025A53M-1299 REV.1 2.SDR IPXA2025071757968Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180 S14L. PERFORM EO-94496-REQ1 REV.1 AND EI NO.F2025A53M-1312 REV.1 2.SDR ASAA2025062259656Cargo Track · crackedAFT PIT, RH CARGO TRACK HAS CRACKS AT STA 727I, 727H, AND 727E. GROUNDED - YES. REMOVED DAMAGE RH CARGO TRACK FROM THE AFT PIT STA 727 TO STA 747 +10 AND FABRICATED/REPLACED WITH NEW RH CARGO TRACK FROM STA 727 TO STA 747 +10 IAW B737-800 SRM 53-00-53-2R-3.SDR ASAA2025062259641Frame · crackedFUSELAGE BS 400 RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REAPIRED BS 400 RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259620Frame · crackedREPAIRED BS 480 LEFT IS CRACKED AT THE AC RAILSUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 480 LEFT IAW TC AD 2024 1807-700-25-1L FIG 5.SDR ASAA2025062259619Frame · crackedFUSELAGE BS 747 RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 747 RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259618Frame · crackedFUSELAGE BS 500C RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 500 RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259617Frame · crackedREPAIRED BS 440 RIGHT IAW TC AD 2024 1807-700 25-1R FIG C. GROUNDED - YES. REPAIRED F.S.440 RIGHT IAW TC AD 2024 1807-700-25-1R FIG 6.SDR ASAA2025062259616Frame · crackedFUSELAGE BS 727D LEFT IS CRACKED AT THE A/C RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 727D LEFT IAW TC. AD 2024 1807-700-25-IL FIG 5.SDR ASAA2025062259614Frame · crackedFUSELAGE BS 440 LEFT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 440 LEFT IAW TC AD20241807-700-25-1L FIG 5.SDR ASAA2025062259613Frame · crackedFUSELAGE BS 727B LEFT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 727B LEFT IAW TC AD20241807-700-25-1L FIG 5.SDR ASAA2025062259611Frame · crackedFUSELAGE BS 867 LEFT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 867 LEFT IAW TC AD20241807-700-25-1L FIG 5.SDR ASAA2025062259610Frame · crackedFUSELAGE BS 400 LEFT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 400 LEFT IAW TC AD20241807-700-25-1L FIG 5.SDR ASAA2025062259609Frame · crackedFUSELAGE BS 500A RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET I/B FASTENER HOLE. GROUNDED - YES. REPAIRED BS 500A RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259608Frame · crackedREPAIRED BS 380 RIGHT IAW TC AD2024 1807-700-25-1R FIG 6. GROUNDED - YES.SDR ASAA2025062259607Frame · crackedFUSELAGE BS 787 RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 787 RIGHT IAW TC AD 2024 1807-700-25-1R FIG 6.SDR ASAA2025062259606Frame · crackedFUSELAGE BS 907 LEFT IS CRACKED AT THE AC RAIL SUPPORT BRACKET I/B FASTENER HOLE. GROUNDED - YES. REPAIRED BS 907 LEFT I.A.W. TC AD 20241807-70025-IL FIG 11.SDR ASAA2025062259605Frame · crackedFUSELAGE F.S. 520 LEFT CRACKED AT THE AC RAIL SUPPORT BRACKET I/B FASTENER HOLE. GROUNDED - YES. REPAIRED F.S. 520 LEFT I.A.W. TC AD 2024-1807-700-25 IL FIG 5.SDR ASAA2025062259604Frame · crackedREPAIRED BS 907 RIGHT IAW TC AD 20241807-700-25-1R FIG 12. GROUNDED - YES. REPAIRED BS 907 RIGHT IAW TC AD2024 1807-700-25-1R.SDR ASAA2025062259603Frame · crackedFUSELAGE BS 727B RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 727B RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259602Support Bracket · crackedFUSELAGE BS 827 RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 827 RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR ASAA2025062259601Support Bracket · crackedFUSELAGE BS 480 RIGHT IS CRACKED AT THE AC RAIL SUPPORT BRACKET I/B FASTENER HOLE. GROUNDED - YES. REPAIRED BS 480 RIGHT IAW TC AD20241807-700-25-1R FIG 6.SDR IPXA2025072157902Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 2180 S16L. PERFORM EO-94474-REQ1, REV 1, AND EI F2025A53M-1498, REV 1.