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 SWAA2025092307062Access Panel · crackedCRACK ON ANGLE ACCESS PANEL 834DZ ENTRY DOOR. REPLACED THE ANGLE ACCESS PANEL 834DZ IAW SRM 51-10-02, SRM 51-40-02, AND DWG 411A2119, SHEET 72, REV -. .SDR SWAA2025092307064Floorbeam · crackedAAI: MAIN CABIN - FLOORBEAM HAS CRACK AT STA 540; BL 0 TO RBL 24.75. REPLACED FLOORBEAM IAW SRM 51-40-02, AND SRM 51-10-02-0G-0, PARAGRAPH 9.SDR SWAA2025092207019Attach Angle · crackedCRACK FOUND AT BS 663, RBL 34, ON VAPOR BARRIER ATTACH ANGLE. REMOVED VERTICAL ATTACHED FASTENERS ON RT 663 CHORD IAW SRM 51-40-02. REMOVED FUEL TANK FASTENERS AT BS 663 ON VAPOR BARRIER ATTACH ANGLE RBL 6 TO RBL 43 IAW SRM 51-40-02. REMOVED AND REPLACED SDR SWAA2025092206615Angle · crackedNUMBER 1 ENGINE INBD FAN COWL ANGLE AT AFT SIDE OF OIL SERVICE DOOR OPENING CRACKED AT UPPER CORNER. REMOVED AND REPLACED THE NR 1 ENGINE INBD FAN COWL WEB AT OIL SERVICE DOOR IAW AMM 51-40-02.SDR DALA2025091806846Counter · dentedDENTS WORK DECK GALLEY 1 AT FWD GALLEY AREA. R & R FWD GALLEY WORK DECK REF A319 CMM 25-31-561. (1156491).SDR SWAA2025091507045Fitting · crackedNUMBER 1 PYLON FITTING LOCATED 13 INCH AFT OF AFT ENG MOUNT FITTING IS GOUGED AND CRACKED. REMOVED PYLON FITTING AND PANELS 431CL;431CR; 433AL; 433AR; 431ER;431EL; 433DT 511BT IAW SRM 51-40-02-0G-0, INSTALLED A NEW PYLON FITTING AND PANELS 431CL;431CR; 433ASDR SWI2025F01319Floorbeam · corrodedRT FLOOR BEAM AT FS 17, Y+23, HAS MULTIPLE AREAS OF CORROSION, MARKED. (C-CHECK RO 09/14/2025)REPAIRED CROSSBEAM AT FR 17 Y+23" REF EMB 175 SRM 53-00-10/REPAIR 03P. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR SWI2025F01318Skin · corrodedCORROSION ON INTERNAL SKIN AT STGR 23L-21L FR 88- 89 (C-CHECK RO 09/14/2025)REPAIRED SKIN AT FR 88-89 STGR 21L-23L REF EMB ETD2025-170-926997 REV:/. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. THIS REPAIR IS A TEMP REPAIR AND IS VALID UNTILL AUGUST 21SDR SWI2025F01317Floorbeam · corrodedRH FLOOR BEAM AT FS 14, Y+23, HAS MULTIPLE AREAS OF CORROSION, MARKED. (C-CHECK RO 09/14/2025)REPAIRED CROSSBEAM AT FR 14 Y+23" REF EMB 175 SRM 53-00-10/REPAIR 03P. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR SWI2025F01316Floor Support · corrodedRH FLOOR SUPPORT AT FS 12-19, Y+10, HAS MULTIPLE AREAS OF CORROSION, MARKED. (C-CHECK RO 09/14/2025)REMOVED AND REPLACED R/H SEAT TRASK AT FR 12-20 Y+10.5" REF EMB 175 SRM 51-40-08. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIREDSDR SWI2025F01315Floor Support · corrodedLH FLOOR SUPPORT AT FS 20, Y-10, HAS CORROSION, MARKED. (C-CHECK RO 09/14/2025)REPAIRED L/H SEAT TRACK AT FR20 Y-10" REF EMB 175 SRM 53-10-10/REPAIR 01P. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR SWIA2025091500821Floor Support · corrodedLH FLOOR SUPPORT AT FS 13-15, Y-11, HAS MULTIPLE AREAS OF CORROSION, MARKED. (C-CHECK RO 09/14/2025)REPAIRED L/H SEAT TRACK 2EA AREAS BETWEEN FR 13-15 Y-11"REF EMB 175 SRM 53-10-10/REPAIR 03P.THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTIOSDR 2025FA0000644Servo · contaminatedAIRCRAFT HAD MOMENTARY POWER LOSS/VIBRATION AFTER ADDING FULL POWER ON A TOUCH AND GO. ABORTED TAKEOFF. TOOK AIRCRAFT TO A RUNUP AREA AND CYCLED THE ENGINE FROM POWER IDLE TO FULL POWER MULTIPLE TIMES AND COULD NOT RECREATE THE ISSUE. FUEL SERVO REPLACED.SDR HNAA202509110062Shear Plate · corrodedCORRODED SHEAR CLIP IN CARGO BAY ON FR62 AND BETWEEN STGR 19R/20R. R&R SHEAR CLIP IN CARGO BAY ON FR62 AND BETWEEN STGR 19R/20R IAW EMB SRM 51-40-02.SDR CALA2025091208835Door Sill · corrodedDAMAGE FOUND ON FORWARD ENTRY DOORWAY, LEFT, LOWER AUXILIARY SILL OUTER CHORD BETWEEN STA.299 AND STA.348 AT STR 23L. ACCOMPLISHED REPAIR PER ECRA 5310-08680 DIP REQUIRED PER ECRA5310-08680SDR HNAA2025091100612Floor Support · corrodedLH #3 FLOOR SILL CORRODED IN NUMEROUS AREAS. R&R LH #3 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025091100611Floor Support · corrodedLH #2 FLOOR SILL CORRODED IN NUMEROUS AREAS. R&R LH #3 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025091100606Skin · crackedREAR FUSELAGE 2, SKIN AT FR77 AND BETWEEN STGR 3R/4R AROUND A RIVET HEAD HAS A POSSIBLE CRACK. INSTALLED REPAIR BUSHING ON REAR FUSELAGE 2 SKIN AT FR77 AND BETWEEN STGR 3R/4R IAW EMB 145 SRM 53-32-01 STEP 9 (I) AND PIEDMONT EO1-53-25-0285.SDR HNAA2025091100601Skin · crackedWHILE PERFORMING NDT INSPECTION AT AREA JUST FORWARD OF RUDDER 1, FOUND THAT THE VERTICAL STAB TRAILING EDGE RH SKIN PROFILE JUST ABOVE RUDDER 1 LOWER HINGE FITTING IS CRACKED. INSTALLED REPAIR PARTS ON VERTICAL STAB TRAILING EDGE RH SKIN PROFILE JUST ABOVE RUSDR HNAA2025091000600Support · crackedFOUND CRACK ON BAG DOOR LOWERING MECHANISM SUPPORT AT FR61. R&R BAG DOOR LOWERING MECHANISM SUPPORT AT FR61 IAW EMB 145 SRM 51-40-02.SDR SIMA20250821001Floor Support · corrodedRT FLOOR SUPPORT HAS CORROSION BETWEEN FR86 AND 87 @ Y+276 (LEVEL 2 CORROSION) (MAJOR REPAIR) REMOVED CORROSION FROM RT FLOOR SUPPORT BETWEEN FR 86 AND 87 @ +276MM PER SRM 51-10-03. BLENDED AREA MEASURES L= 1.6", W= 1.5", H= 0.060.? ORIGINAL MATERIAL THICKNESSSDR HNAA2025090900591Door Sill · crackedCARGO DOOR LOWERING MECHANISM AFT SUPPORT LOCATED BETWEEN FR67 AND FR68 HAS A CRACKED BRACKET. R&R CARGO DOOR LOWERING MECHANISM AFT SUPPORT BRACKET BETWEEN FR67 AND FR68 IAW EMB 145 SRM 51-40-02.SDR IPXA2025090493586Bracket · corrodedAFT CARGO COMPARTMENT HAS CRACKED BRACKET AND STRUCTURE AT BS 1681.8. 03-094. REMOVED PLATE ASYY FROM AFT CARGO COMPARTMENT SAT 1681.8 TO FURTER EVALUATE IAW SRM 51-40-02-OG-0. REMOVED 1EA NUT PLATE FROM PLATE ASYY IAW SRM 51-40-02-OG-0. REMOVED 1 EA FLOOR SDR IPXA2025090597004Fitting · gougedRIGHT WING. FLAPS GUIDE ROLLER FITTING HAS CHAFING ON THE LOWER SURFACE.(DM08). ACCOMPLISHED REPAIR PER EO-94899-REQ1 AND VT-SAA EA 757-5750-01-B0560.SDR IXXA20250909006Bracket · cracked#6 SLAT, INSIDE LOWER CLIP HAS CRACKED BRACKET 63" FROM OB EDGESDR IXXA20250909005Bracket · cracked#6 SLAT, INSIDE LOWER CLIP HAS CRACKED BRACKET 52" FROM OB EDGESDR IXXA20250909004Bracket · cracked#6 SLAT, INSIDE LOWER CLIP HAS CRACKED BRACKET 42" FROM OB EDGESDR HNAA2025090800588Skin · crackedREAR FUSELAGE 1 LH UPPER SKIN RIVET AT FR76, STRG 6L IS POSSIBLE CRACKED. INSTALLED REPAIR BUSHING ON REAR FUSELAGE 1LH UPPER SKIN AT FR 76 STRG 6L IAW ETD2025-145-926199 / EO1-53-25-0283.SDR IPXA2025090495838Tee Angle · brokenR/H WING. I/B FLAP HAS BROKEN T-ANGLE SUPPORT LOCATED AT O/B SIDE OF THE FLAP.(DM09) ATA57. INSTALLED TEE-ANGLE SUPPORT AT R/H WING. I/B FLAP. LOCATED AT O/B SIDE OF THE FLAP I.A.W. B757-200PF SRM 51-40-02-0G-0 AND BOEING DWG NO.113N2605.SDR IPXA2025083089022Seat Track · corrodedMAJOR REPAIR, CORROSION ON SEAT TRACK Y0 BTW FR79 AND FR80/82 NEW SEAT TRACK SECTION Y0 BTW FR79-FR80 HAS BEEN INSTALLED IAW SRM 53-10-16 PARAGRAPH 4 PAGE 204 FIGURE 201 AND SRM 51-40-21.SDR DALA2025090406564Spar Cap · crackedLEFT WING REAR SPAR, LOWER CAP, AFT FLANGE CRACKED NEAR XRS = 164. REPAIRED PER ER/A 00-626909. (1156447)SDR IPXA2025090289057Seat Track · corrodedMAJOR REPAIR, CORROSION ON SEAT TRACK Y794.3 BTW FR 79 AND FR 80- 82, NEW SEAT TRACK SECTION WAS INSTALLED IAW SRM 51-40-21 AND SRM 53-10-16 PARAGRAPH 4 FIGURE 201.SDR FDEA202508211582Seat Track · noneEXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y953 BETWEEN FR57 AND FR57.3 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y953 BETWEEN FR57 AND FR57.3 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM53-10-16-201 FIG.SDR FDEA202508211581Seat Track · noneEXISTING REPAIR ON MAIN DECK SEAT TRACK AT -Y953 BETWEEN FR26 AND FR30 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK SEAT TRACK AT -Y953 BETWEEN FR26 AND FR30 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM53-10-16-201 FIG.20SDR SWAA2025082907737Handle · looseASSIST HANDLE IS LOOSE ON G7 GALLEY. SECURED ASSIST HANDLE ON G-7 IAW AMM 25-31-71 & SRM 51-40-02.SDR SWAA2025082907163Handle · looseUPPER AND LOWER ASSIST HANDLES ARE LOOSE ON L1 DOOR LINER. SECURED UPPER AND LOWER DOOR ASSIST HANDLES IAW AMM 52-11-31 & SRM 51-40-02.SDR SWAA2025082907164Handle · looseASSIST HANDLE IS LOOSE ON L2 FWD DOOR SURROUND. SECURED ASSIST HANDLE ON L-2 DOOR FWD SURROUND LINING IAW AMM 25-21-25 & SRM 51-40-02.SDR SWAA2025082907165Handle · looseASSIST HANDLES ARE LOOSE ON R2 DOOR LINER AND R2 FOWARD SURROUND. SECURED R-2 DOOR AND FWD SURROUND ASSIST HANDLES IAW AMM 52-41-31; 25-21-25 & SRM 51-40-02.SDR DALA2025082906393Snubber · out of limitsSHIP 649 R4 DOOR SNUBBER BELOW LIMITS AFTER REMOVED. CORRECTIVE ACTION: REMOVED AND REPLACED THE R4 DOOR ROTARY SNUBBER WITH SERVICEABLE ROTARY SNUBBER IAW B757 AMM 52-11-10, SNUBBER WAS INSTALLED ON NR 184563-0800-0022 THAT HAD THE DOOR AND BODY TORQUE TUBE RSDR 2025FA0000584Bulb · failedAIRCRAFT WAS COMING FOR LANDING ON APPROACH, GEAR WAS EXTENDED BUT NLG DOWN & LOCK INDICATION WAS NOT INDICATING. PILOTS WENT THROUGH THEIR TROUBLESHOOTING CHKLIST, NLG STILL NOT INDICATING. PILOTS CONFIRMED NLG DOWN USING COWLING MIRROR & TOWER FLYBY, PILOT PSDR CALA2025082708188Seat Track · corrodedR/H WET AREA SEAT TRACK -1292 AT FR64-66 IS CORRODED. REMOVED SEAT TRACK, -1292 FR 64-66 IAW A320 SRM 51-42-11/0 01 REV 154 REPLACED BEAM-SEAT TRACK -1292 FR64-66 IAW A320 SRM 5 1-42-11/001 REV 154SDR I5PA2025082168803Apu · inoperativeAPU INOPERATIVE. R & R APU IAW AMM.SDR ASAA2025082160364Control Panel · detachedMASTER CALL LIGHT PANEL IN FWD GALLEY CEILING FELL OFF. GROUNDED - YES. REPLACED MASTER CALL/EXIT SING LIGHT ASSY REF CMM 33-51-01. OPS CHECKS GOOD. INT CLEARD. PLACARD REMOVED.SDR MTNA20250826001Structure · corrodedON PREFLIGHT FOUND CORROSION UNDER CARGO DOOR - PR 254985PR 254998 KIT DOOR STRIP, DOUBLER, SCUPPER DRAIN. AWT TEXTRON DISPOSITION.SDR SWAA2025082607069Battery Pack · inoperativeLEFT OWE EMERGENCY LIGHTS INOPERATIVE. R & R LT OVERWING EMERGENCY LIGHTS BATTERY PACK AND OPS CHECK GOOD IAW AMM 33-51-06-960-805SDR JIKA202508260001Motor · failedPILOT REPORTED THAT ON FINAL APPROACH HE SELECTED GEAR DOWN AND NOTHING HAPPENED. PILOT CYCLED LANDING GEAR SELECTOR SEVERAL TIMES BEFORE RECEIVING A HYDRAULIC LOW WARNING ANNUNCIATOR. PILOT PULLED THE CIRCUIT BREAKER MANUALLY EXTENDED THE LANDING GEAR THEN LASDR DALA2025082606334Angle · corrodedFWD CARGO L/H TRANSITION ANGLE CORRODED FROM STA 500A TO STA 500L. REMOVED AND REPLACED SECTION FROM STA 500F TO STA 500L IAW B737-900 SRM 53-00-53-2R-6.SDR DALA2025082606333Pressure Deck · cracked(LOG 1155124) A.A AD 5714-01004-02 STEP 8 AND 9 2 CRACKS ON PRESSURE DECK WEB (1CRACK BTW STA 663 AND RBL 35 .593 IN AND 2 CRACK RBL 42 .656. PRESSURE DECK WEB WAS REPAIRED PER B737-800 SRM 57-10-10-2R PROCEDURE 3 AND A.A AD 5714-01004-02.SDR DALA2025082606326Spar Cap · crackedLEFT WING REAR SPAR LOWER CAP AFT FLANGE CRACKED NEAR XRS = 164. ACCOMPLISH ER/A 627199-14AD REV D (1156482)SDR WX0A2025082532549Light · no discrepancyEMERGENCY EXIT LIGHTS ILLUMINATED DURING TAXI OVER EXIT DOORS AND GALLEY. PER AMM 33-51-00-00 CONF00 EMERGENCY EXIT LIGHTS ARE ON WITH SWITCH ARMED AND LANDING GEAR EXTENDED. LIGHTS ARE EXTINQUISHED WHEN LANDING GEAR RETRACTS.