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 FDEA202509081864Skin · contaminatedRIGHT ELEVATOR UPPER SURFACE 1EA POS FOUND FLUID, AS MARKED (#6 AT RIB20(ER16) SIZE:234MM X 60MM) REPAIRED RH ELEVATOR UPPER SURFACE 1EA POS FLUID(#6 AT RIB20(ER16)) PER A300-600F SRM55-21-12-201 PARA.5.J & SRM51-77-12-201 & EA 6-5520-T0385132 P1. EA TITLESDR FDEA202509081863Skin · contaminatedLEFT ELEVATOR LWR SURFACE 1EA POS FOUND FLUID, #5 AT RIB14 ER10 SIZE:85MMX55MM. REPAIRED LH ELEVATOR LWR SURFACE 1EA POS FLUID (#5 AT RIB14 (ER10)) PER SRM55-21-12-201 PARA.5.J & SRM51-77-12-201 & EA 6-5520-T0385133 P1. EA TITLE: STABILIZERS - ELEVATORS SDR FDEA202509081862Skin · contaminatedLH ELEVATOR UPPER SURFACE 4EA POS FOUND FLUID, AS MARKED (#1 AT RIB20(ER16) SIZE:48MMX35MM, #2 AT RIB 16 (ER13) SIZE: 87MMX67MM, #3 AT RIB 15 (ER10-ER13 )SIZE:70MMX62MM, #4 AT RIB 9(ER6-ER7 ) SIZE:95MMX80MM) REPAIRED LH ELEVATOR UPPER SURFACE 4EA POS FLUIDSDR IPXA2025091867493Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 1960 S-11R (LEVEL1) (REPAIR).PERFORMED SRM 53-60-03-2R-4 REV.46/TR:53-155 AND EGAT WORK SHEET NO.50697 STEPS 1-43.PERFORMED EO-95137-REQ1 REV.1 AND EI NO.F2025A53M-2072 REV.0 AND EGAT WORK SHEET NO.50697SDR SWAA2025092913574Skin · pulledPULLED THROUGH FASTENERS AT 10 O CLOCK POSITION RIGHT INLET COWL OUTER LIPSKIN (MARKED)<[01] NEW / SERVICEABLE INLET COWL P/N: 314M2100503. S/N: 4308001 WILL BE REPLACED IN FAULT TTG8Q0156HRJ;[02] VERIFIED CORRECTIVE ACTION 1SDR R61A2025092800421Seal Rest · corrodedFWD CARGO DOOR LOWER CUTOUT FWD CORNER SEAL REST CORRODED. MX REPLACED SEAL REST PN 170-66803-403 IAW SRM 51-40-08.SDR R61A2025092800420Seal Rest · corrodedFWD CARGO DOOR LOWER CUTOUT, AFT CORNER SEAL REST CORRODED. MX REPLACED SEAL REST PN 170-66803-404 IAW SRM 51-40-08SDR R61A2025092800419Hinge · corrodedCF3 WASTE ACCESS DOOR HINGE FOUND CORRODED. MX REPLACED HINGE PN 4324015 IAW SRM 51-41-02.SDR R61A2025092800418Seal Rest · corrodedFWD CARGO DOOR LOWER CUT OUT MIDDLE SEAL REST FOUND CORRODED. MX REPLACED SEAL REST IAW ERJ 175 SRM 51-40-08.PN 170-66804-403SDR SWAA2025092612577Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT. REPAIRED THE FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-60-15-2R-1 REPAIR 1 AND BAC 5975.SDR SWAA2025092612579Threshold · crackedCRACK THRESHOLD AT FWD CARGO COMPARTMENT. REPLACED THRESHOLD AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G ITEM 9; SCUFF PLATE WILL BE INSTALLED ON TTG8Q014X931 AND TTG8Q00SFVBA.SDR AALA202509268562Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON UPPER BOLT AT AFT ATTACH FITTING ON LT PYLON L=0.017 INCH, W=0.033, INCH AND D=0.011 INCH. MAINTENANCE REPLACED BOLT.SDR SWIA2025F01345Spring · brokenAFT PAX DOOR AFT SLIDE FITTING SPRING IS BROKEN (C-CHECK RO 09/24/2025)REMOVED AND REPLACED AFT PAX DOOR AFT SLIDE FITTING SPRING. REF AMM 53-23-01SDR SWIA2025F01344Backboard · crackedFWD PAX DOOR EVACUATION SLIDE COMPOSITE BACKING CRACKED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED FWD PAX DOOR EVACUATION SLIDE. REF AMM 25-65-01 TW TC2-7520 DUE 5-6-26SDR SWIA2025F01343Seat Track · corrodedPAX CABIN FWD WET AREA FLOOR STRUCTURE CORROSION ON RH I/B SEAT TRACK BETWEEN FR 17-18 AS MARKED (C-CHECK RO 09/24/2025)PERFORMED REPAIR ON PAX CABIN FWD WET AREA FLOOR STRUCTURE RH I/B SEAT TRACK AT FR17. REF ETD2025-170-928047 AND SRM 53-23-10/REPAIR 04P.SDR IPXA2025092567592Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-16L. ACCOMPLISHED REPAIR I.A.W UPS EO-95206-REQ1 REV.1 AND EGAT EI NO NO.F2025A53M-2015 REV.2. VERIFY REPAIR IS ACCOMPLISHED PER GMM 04.02.01.15.SDR IPXA2025092567578Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-15L. PERFORM EO-95204-REQ1 REV.1 AND EI NO.F2025A53M-2012 REV.2. VERIFY REPAIR IS ACCOMPLISHED PER GMM 04.02.01.15 REQUIREMENTS.SDR N3XR202509250003Pump · inoperativeTHE RIGHT ENGINE WILL NOT START AFTER 2 ATTEMPTS. FUEL PUMP PN-D64-9028-11-01-MOD FAILED. IT WAS REPLACEDSDR N3XR202509250002Pump · inoperativeDURING THE RUN UP, THE LEFT ECU B FAILED, AND THE ENGINE TURNED OFF. RESTARTED THE ENGINE, LEFT ECU B FAIL REMAINED.SDR SWIA2025F01342Girt Bar · brokenFORWARD SERVICE DOOR. FORWARD GIRT BAR FLOOR FITTING FLAP SLIDE SPRING HAS 1 BROKEN OFF TAB. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED FLAP SPRING ON FORWARD SERVICE DOOR FWD FLOOR FITTING REF AMM 53-10-25SDR SWIA2025F01341Stringer · corrodedSTGR 19R CORRODED FR 88-89 (C-CHECK RO 09/24/2025)PERFORMED DOUBLER REPAIR ON STGR 19R BETWEEN FR 88-91 REF ETD2025-170-928028 RESTORED SURFACE PROTECTION, REF SRM 51-23-04 (PO:327590), 51-23-05 (PO#335208 (PRIMER), SRM 51-23-06 (PO#324061 (G46) CPM 51-25-00 SDR SWIA2025F01340Shear Tie · corrodedSHEAR CLIP FR88 SRGR 27R-28R CORRODED (C-CHECK RO 09/24/2025)REMOVED AND REPLACED SHEAR CLIP FR88 SRGR 27R-28R RESTORED SURFACE PROTECTION, REF SRM 51-23-04 (PO:327590), 51-23-05 (PO#335208 (PRIMER), SRM 51-23-06 (PO#324061 (G46) CPM 51-25-00 (PO:331184). NO SDR SWIA202509240008Seat Track · corrodedLH INBOARD SEAT TRACK CORRODED BETWEEN FRAMES 19 & 20. (C-CHECK RO 09/24/2025)PERFORMED DOUBLER REPAIR ON LH INBD SEAT TRACK BETWEEN FRAMES 19-20 REF ETD2025-170-928026-ASDR IPXA2025092467530Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2180 S-13R. PERFORM EO-95204-REQ1 REV.1 AND EI NO.F2025A53M-2025 REV.1. VERIFY REPAIR IS ACCOMPLISHED PER GMM 04.02.01.15SDR CALA2025092409207Skin · corrodedUPPER FUSELAGE, VERT STABILIZER FUSE CORRODED FWD OF VERT STAB AT FR 69 BETWEEN STR AD STR 2R. PERFORMED DOUBLER REPAIR IAW SRM 53-41-11-300-037.SDR IPXA2025092367676Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2360 S-11L REPAIRED I.A.W SWPM 20-10-11 , 20-10-12 REV.89 INSTALLED WIRE BUNDLE SUPPORT CLAMPS AT MAIN DECK STA 2350 BETWEEN S-9L TO S-13L AND CONDITION CHECK NORMAL. PERFORM EO-95193-REQ1 REV.1 AND EI NO.F2025A53M-2048 REV.1.SDR AALA202509226421Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN SEAT TRACK BETWEEN FR 47 AND FR 47.5 AT +Y1292. REPLACED SEAT TRACK PER SRM 51-72-11.SDR IPXA2025092167607Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2180 S-18L (LEVEL1) (REPAIR) INSPECTION COMPLETED FOR EGAT WORK SHEET NO.50700 STEP 30 - RESPECTIVELY PART MARK THE REPAIR PARTS. RII COMPLETED FOR EGAT WORK SHEET NO.50700 STEP 31.SDR IPXA2025092267448Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-21L (LEVEL1) (REPAIR). FABRICATED REPAIR SPLICE I.A.W. EGAT WORK SHEET NO. 50694 STEP 14 (SRM 53-60-03-2R-12 REV.46/TR:53-160)PERFORMED THE HEAT TREATMENT FROM 7075-O TO T62 CONDITION I.A.W. EGAT WORK SHEET NO.:50SDR IPXA2025092267623Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-20L (LEVEL1) (REPAIR).FABRICATED REPAIR SPLICE I.A.W. EGAT WORK SHEET NO. 50695 STEP 14 (SRM 53-60-03-2R-12 REV.46/TR:53-160).PERFORMED THE HEAT TREATMENT FROM 7075-O TO T62 CONDITION I.A.W. EGAT WORK SHEET NO.:50SDR IPXA2025092267652Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-22L (LEVEL1) (REPAIR)FABRICATED REPAIR SPLICE I.A.W. EGAT WORK SHEET NO. 50696 STEP 14 (SRM 53-60-03-2R-12 REV.46/TR:53-160).PERFORMED THE HEAT TREATMENT FROM 7075-O TO T62 CONDITION I.A.W. EGAT WORK SHEET NO.:506SDR IPXA2025092267421Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 1960 S-10R (LEVEL1) (REPAIR). PERFORMED SRM 53-60-03-2R-4 REV.46/TR:53-155 AND EGAT WORK SHEET NO.50698 STEPS 1-43. PERFORMED EO-95172-REQ1 REV.1 & EI NO.F2025A53M-2097 REV.0 AND EGAT WORK SHEET NO.50698.SDR IPXA2025091075594Floor Panel · damagedFAULT: APG / Z100 / DURING MAIN WHELL WELL INSPECTION FOR HYDRAULIC SYSTEM LEAK CHECKS A FLOOR PANEL (P/N: A2551027700100) FOUND SOFT AND DELAMINATED INSTALLED MAIN WHELL WELL FLOOR PANEL (P/N: A2551027700100) IAW AMM 53-15-31/401SDR IXXA20250918001Baffle · puncturedFUEL TANK BAFFLE PANEL 134DZ WAS PUNCTURED ON THE HONEYCOMB FACE. REPAIR WAS ACCOMPLISHED PER FVCI EO#25168-6 REV. 1R B767-300 SRM 51-70-10-2R-2.SDR SWAA2025091612627Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 232HF HAS DELAMINATION ON TOP SURFACE. FABRICATED FLOOR PANEL 232HF IAW DWG 143A5810 SHEET 521 AND SRM 53-00-50-2R-0.SDR SWAA2025091612628Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 232SF HAS DELAMINATION ON TOP SURFACE. RECEIVED A NEW FLOOR PANEL FOR MAIN CABIN FLOOR PANEL 232SF IAW AIPC 53-21-00-42A.SDR SWAA2025091612536Seal · crackedNOSE RADOME BOOT HAS CRACKING<[01] REMOVED AND REPLACED RADOME PROTECTIVE BOOT IAW AMM 53-52-00;[02] VERIFIED THE FOLLOWING:<BR>REMOVED AND REPLACED RADOME PROTECTIVE BOOT IAW AMM 53-52-00SDR AALA202509159970Safety Wire · missingAIRCRAFT WAS GROUNDED: FORWARD RIGHT EMERGENCY EXIT HAS A SAFETY WIRE CABLE WITH A COTTER PIN THAT IS DISCONNECTED. FOUND LADDER TIE DAMAGED AND SAFETY PIN MISSING, INSTALLED LADDER TIE (AALA202509157606) AND SAFETY PIN (AALA202509159970) AT R1 DOOR SLIDE. PERSDR AALA202509157606Tie · damagedAIRCRAFT WAS GROUNDED: FORWARD RIGHT EMERGENCY EXIT HAS A SAFETY WIRE CABLE WITH A COTTER PIN THAT IS DISCONNECTED. FOUND LADDER TIE DAMAGED AND SAFETY PIN MISSING, INSTALLED LADDER TIE (AALA202509157606) AND SAFETY PIN (AALA202509159970) AT R1 DOOR SLIDE. PERSDR AALA202509150138Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT PASSENGER DOOR, GIRT BAR FLOOR FITTINGS NEED TO BE ADJUSTED DUE TO ARM LEVER DOES NOT SIT FLUSH WHEN IN THE ARMED POSITION AND THE LEVER HAS A SPONGY FEEL, ADJUSTED GIRT BAR LOWER FITTINGS AND ACCOMPLISHED A SATISFACSDR AALA202509151227Battery · no testAIRCRAFT IN BASE MAINTENANCE: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR MERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR MASA2025090800072Bleed Air Sys · failedBLEED 1 FAIL IN FLIGHT - RETURN TO FIELD. PLACED ON MELSDR DALA2025091206742Warning Message · false activationATB- DUE TO (AIR L BLEED LEAK) MESSAGE. PERFORMED HIGH POWER ENGINE RUN AND INSPECTED WING AND PYLON DUCTING WITH NO LEAKS FOUND. REPLACED BOMU (BLEED AND OVERHEAT MONITORING UNIT). (LP# 7575136, 7575137)SDR FDEA202509081692Web · no discrepancyEXISTING REPAIR ON MAIN DECK CARGO UNDER FLOOR WEB FR47 BETWEEN Y0 AND Y450 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK CARGO UNDER FLOOR WEB BETWEEN Y0 AND Y450 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM 53-15-15-201SDR FDEA202509081690Web · not reportedEXISTING REPAIR ON MAIN DECK CARGO UNDER FLOOR WEB FR47 BETWEEN Y0 AND -Y450 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK CARGO UNDER FLOOR WEB BETWEEN Y0 AND -Y450 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM 53-15-15-20SDR CALA2025091208840Controller · faultedFLAP/SLAT CONTROL 1 EICAS STATUS HIGH LIFT CONTROL LANE #1 HAS A FAULT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 2728841. REMOVED LEFT OPBC IAW AMM 23-93-01-000-801 INSTALLED NEW OPBC LEFT IAW AMM 23-93-01-400-801 UPTO STEP 3.G. INSTALLATION TESTSDR SWAA2025091112462Battery · no testFWD INBD FA FLASHLIGHT WILL NOT TEST. REPLACED FWD INBD FA FLASHLIGHT BATTERY PER AMM 25-64-00. TEST GOOD.SDR SWAA2025091112695Retainer · looseFWD BOARDING DOOR EVACUATION SLIDE RETAINING CLIP IS LOOSE. SECURED CLIP ON FWD ENTRY DOOR REF S.I.P.SDR SWAA2025091112677Slide · out of positionR2 DOOR GIRT BAR FELL OFF. REPOSITIONED FORWARD SERVICE DOOR SLIDE IAW MT 725-61-06.SDR SWAA2025091112841Slide · out of toleranceR-1 DOOR SLIDE PN SA3307-9 PRESSURE BOTTLE GAUGE IS IN THE RED BAND. REMOVED AND REPLACED R-1 DOOR SLIDE ON TASKCARD TTG8Q0151G8M MT 725-61-06 IAW B737-800 AMM 25-66-01-401-NG.;[02] REMOVED AND REPLACED R-1 DOOR SLIDE ON TASKCARD TTG8Q0151G8M MT 725-61-06 IA