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 SWAA2025120933039Cargo Track · crackedCRACK TRACK RBL 13.80 ON BS 767 IN THE AFT CARGO COMPARTMENT. PERFORMED REPAIR ON TRACK, RBL 13.80 ON BS 767 AT AFT CARGO COMPARTMENT IAW SRM 53-00-53-2R-3, REPAIR 3; ALTERNATIVE 1 FIGURE 203.SDR SWAA2025120933040Cargo Track · crackedCRACK TRACK RBL 13.80 ON BS 727C IN THE AFT CARGO COMPARTMENT. PERFORMED REPAIR ON TRACK LOC. RBL 13.80 ON BS 727C AT AFT CARGO COMPARTMENT IAW SRM 53-00-53-2R-3 REPAIR 3; ALTERNATIVE 1 FIGURE 203.SDR SWAA2025120832525Floor Panel · pulledAFT FLOOR PANEL 241VF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED NEW FLOOR PANEL 241VF IAW SRM 53-00-50-2R-0 PARA. 1.A NOTE AND DWG 146A5810 0100.SDR SWAA2025120832526Floor Panel · pulledAFT FLOOR PANEL 241WF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED NEW FLOOR PANEL 241WF IAW SRM 53-00-50-2R-0 PARA. 1.A AND DWG 146A5810 0028.SDR SWAA2025120832527Floor Panel · pulledAFT FLOOR PANEL 241XF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 241XF WAS REPAIRED IAW SRM 53-00-50-2R-1.SDR SWAA2025120832530Floor Panel · pulledAFT FLOOR PANEL 242QF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED NEW FLOOR PANEL 242QF IAW SRM 53-00-50-2R-0 PARA. 1.A NOTE AND DWG 146A5810 ID: 0026.SDR SWAA2025120832821Skin · crackedCRACK FOUND AT FED SURROUND STRUCTURE BS 291.5+4, STR 16L. REMOVED AND REPLACED FED SURROUND STRUCTURE BS 291.5+4 S16L, IAW SRM 51-40-02-0G-0 AND DWG 141A8180 REV C.SDR SWAA2025120832820Shield · crackedNR 1 ENGINE INBD FAN COWL OIL DOOR SHIELD HAS A CRACK IN IT. REMOVED AND REPLACED THE CRACKED NR 1 ENGINE INBD FAN COWL OIL DOOR SHIELD IAW SRM 51-40-02-0G-0.SDR CALA2025120811829Rib · crackedRIGHT HORIZONTAL STAB. INSPAR RIB NR 1 HSS 92.7 AT STIFFENER NR 4 EVIDENCE OF CRACK. REPAIRED RT HORIZONTAL STAB INSPAR RIB IAW SRM 55-10-09-2R-4.SDR SWAA2025120332586Scuff Plate · crackedFCB FWD CORNER SCUFF PLATE IS CRACKED. RECEIVED NEW FCB FWD CORNER SCUFF PLATE AND WILL BE INSTALLED ON TC TTG8Q00A5WT6.SDR SWAA2025120332947Scuff Plate · crackedACD FWD CORNER SCUFF PLATE IS CRACKED. REPAIRED ACB FWD CORNER SCUFF PLATE PER SRM 53-60-15-2R-1. TASK CARD COMPLETED.SDR SWAA2025120332826Intercostal · crackedFED INTERCOSTAL FROM BS 294.5 - 303.9, S16L, WL 216 CRACKED. REMOVED AND REPLACED FED INTERCOSTAL IAW SRM 51-40-02 AND DWG 141A8180 REV: C.SDR SWAA2025120332827Rib · crackedSTIFFENER NR 3 AT LT HORIZONTAL STAB (RIB 5) HSS 129.50 CRACKED. REPAIRED THE STIFFENER; IAW SRM 55-10-09-2R-4, HSS 129.5.SDR AALA202512030341Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 68 AND S23R. REPLACED LOWER SLL PER SRM 51-72-11.SDR AALA202512036294Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 68 AND S23L. REPLACED LOWER SLL PER SRM 51-72-11.SDR SWAA2025120132998Floorbeam · crackedDURING OK TO CLOSE, FOUND THE FLOORBEAM CRACKED AT BS 540, RBL 1 - 25. REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G-0, AND DWG 143A0060, REV B;SDR AALA202511280243Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION THRESHOLD SHEET IN AFT CARGO COMPARTMENT MEASURE OF CORROSION ARE: L=10.00INCH W=4.34INCH ,D= 0.050INCH. MAINTENANCE REPLACED THRESHOLD SHEET IN AFT CARGO COMPARTMENT IAW A319 SRM 51-72-11-911-001, DWG D53475500 AND DWSDR SWAA2025112832842Bracket · crackedCRACK BRACKET ANGLE ON BS 500D AT LEVEL STR 28L AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED ON BS 500D AT LEVEL STR 28L AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9 AND DWG 143A7902 SHEET 126 REV.A.SDR SWAA2025112032832Floorbeam · crackedMID CABIN FLOOR EXPANSION JOINT AT BS 540 CRACKED AT FASTENER LOCATION NEAR LBL 1. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-02-0G-0, 51-40-05-0G-0, AND DWG 143A0060, SHEET 64, REV -. APPLIED CIC IAW AMM 51-21-91-620-802.SDR SWAA2025112032831Floorbeam · crackedMID CABIN FLOOR EXPANSION JOINT AT BS 540 CRACKED AT FASTENER LOCATION NEAR RBL 1. REMOVED AND REPLACED THE FLOORBEAM ASSY IAW SRM 51-40-02-0G-0, 51-40-05-0G-0, AND DWG 143A0060, SHEET 64, REV- APPLIED CIC IAW AMM 51-21-91-620-802.SDR AALA202511202998Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR 832 CUT OUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23L. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR JJBA20251120065Skin · corrodedFUSELAGE EXTERNAL LOWER SKIN LH AT FR 61, STR 18L, HAS CORROSION. COMPLIED WITH REAR FUSELAGE I - PERMANENT REINFORCING REPAIR OF SKIN AT FRAME 61 AND STRINGER 18LSDR DXTA2025111005612Brake Assy · malfunctionedON APPROACH AND AFTER SELECTING GEAR DOWN, THE BRK FAIL YELLOW CAS MESSAGE DISPLAYED. WE EXECUTED A GO-AROUND, LEFT THE GEAR DOWN, COORDINATED TRAFFIC PATTERNS WITH ATC AND RAN THE ASSOCIATED QRH. AFTER BURNING FUEL TO REDUCE WEIGHT SOME MORE, WE LANDED AND APSDR AALA202511190261Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER DOOR CUTOUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23R. REPLACED CORNER SHAPE FITING PER SRM 51-72-11.SDR AALA202511197911Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202511196791Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR IPXA2025110768137Pulley · damagedLEFT ENTRY DOOR MAKES GRINDING NOISE WHILE OPENING REMOVED BOTH FWD DRIVE CABLES FROM CABLE DRUM. REMOVED AND REPLACED DAMAGED FWD LWR DRIVE CABLE PER AMM 52-11-03. REMOVED AND REPLACED DAMAGED PULLEYS IN REFERENCE TO AMM 52-11-03. REINSTALLED UPPER FWD DRIVSDR AALA202511188912Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOORBEAM AT FR 20 AND -Y765. REPLACED FLOORBEAM PER SRM 51-72-11.SDR AALA202511180928Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM AT FR 20 AND -Y1292. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR ASAA2025110762312Skin · dentedFUSELAGE SKIN DENT AFT OF STA 867 MARKED WITH RED TAPE REQUIRES RE - EVAULUATION REF L/P 60831633. GROUNDED - YES. FOUND DENT TO BE OUT OF LIMITS PER B737-800 SRM 53-00-01-1A-1 (STA 876) PERFORMED REPAIR PER EA# 800-53EA-29586. FOUND DENT AT STA 867 TO BE IN LSDR ASAA2025110762311Skin · dentedFUSELAGE SKIN DENT L/H SIDE STA 807 + 3.5' 2' ABOVE S-22L GROUNDED - YES. REPAIRED FUSELAGE SKIN AT LH STA 807 + 3.5" ABOVE STR-22L IAW B737-800 SRM 53-00-01-2R-3, REPAIR IS CATERGORY B PERMANET REPAIR WITH INSPECTION THRESHOLD OF 50,000 CYCLES AFTER AIRCRAFT SDR AALA202511170372Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202511178797Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR IPXA2025111755667Fuel Sys · out of balanceAPPEARS TO BE MIGRATING FROM THE RIGHT TO LEFT TANK. STARTED WITH 7.2 IN LEFT TANK 7.5 IN RIGHT, 0.3 IN CENTER. AT TOP OF CLIMB LH TANK 5.8 RIGHT FUEL TANK AT 5.3 CENTER AT 0.5. SEE LOG PG PICTURE. INSTALLED L/H AFT X FEED VALVE ACTUATOR IAW AMM TASK 28-22-12SDR ASAA2025110762224Transition Panel · corrodedRIGHT TRANSITION CORRODED STA 500A TO 500L. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS, INSTALLED REPAIR PARTS AND RESTORED FINISH IAW SRM 53-00-53-2R-5.W=2 O= .040 R= .020 L= 4 D= .020.SDR SWAA2025111233655Panel · crackedLOWER LEFT WING FIXED TRAILING EDGE PANEL AFT OF PANEL 571EB CRACKED WS 688. REPAIRED LOWER LEFT WING FIXED TRAILING EDGE PANEL AFT OF PANEL 571 EB ON FAULT TTG8Q015ULYV AND LOG PAGE 2931319.SDR DALA2025111208308Elec Connector · unsecureCOMFORT PLUS 24,22,20 HJ EMERGENCY EXIT LIGHT INOP. FOUND CONNECTOR LOOSE AT LAST ROW RECONNECTED REST OF SEATS ILLUMINATED. (LP# 8022423)SDR AALA202511127803Stop Fitting · out of adjustAIRCRAFT WAS GROUNDED: ENTRY DOOR EXTREMELY DIFFICULT TO OPERATE FROM THE OUTSIDE. FOUND L1 DOOR, DOOR STOP PINS OUT OF ADJUSTMENT. ADJUSTED AND OPERATIONAL CHECKED GOOD. PER AMM 52-11-00.SDR IPXA2025111053801Floorbeam · corrodedBULK CARGO PIT FR.#66 STRUCTURAL BEAM UNDER LH FLOOR PANEL #161GF HEAVY CORROSION. INSTALLED NUTPLATES AND CROSSBEAM IAW SRM 51-40-21.SDR CALA2025111211155Frame · dentedAFT CARGO BAY BS 1280 BETWEEN STRINGERS 26R TO 27R DENTED. REPAIRED THE FRAME BS 1280 S26R-27R IAW EA 757-5360-13- A4160.SDR CALA2025111211153Frame · dentedBULK CARGO BAY, FRAME HAS A DENT ON LOWER LOBE, BS 1560, LT SIDE, NEAR S26L. REPAIRED BULK CARGO IAW EA 757-5360-13- A4162.SDR CALA2025111211151Bulb · inoperativeR1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP ON THE R1 EXTERIOR EMEREGENCY SLIDE LIGHT, OPS CHECKS GOOD IAW AMM 33-51-04.SDR CALA2025111211149Light · inoperativeSEAT ROW 11 LT EMERGENCY ESCAPE LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSEMBLY AT SEAT ROW 11, OPS CHECKS GOOD IAW AMM 33-51-11-960-802.SDR CALA2025111211147Fitting · corrodedNUMBER 2 PYLON SPIGOT BEARING LOWER FITTING HAS PITTING CORROSION. REMOVED AND REPLACED THE NR 2 PYLON SPIGOT BEARING LOWER FITTING IAW SRM 54-51-12-300-002.SDR CALA2025111211145Sleeve · corrodedNUMBER 2 ENGINE SPIGOT SLEEVE AND ATTACHING NUT HAVE PITTING CORROSION. RECEIVED AND REPLACED ENGINE 2 PYLON SPIGOT SLEEVE AND NUT IAW AMM 57-26-12-400-002-A.SDR CALA2025111111137None · noneETOPS PRE-DEPARTURE SERVICE CHECK REQUIRED. ALL PERSONNAL INVOLVED WITH ACCOMPLISHING THE PDSC MUST HAVE THEIR EMPLOYEE NUMBER E NTERED ON THIS LOG PAGE. COMPLIED WITH ETOPS PREDEPARTURE CHECKS AS REQUIRED. WITHOUT TIRE PRESSURE CHECK DUE TO IRREGULAR OPS PERSDR SWAA2025111132795Girt Bar · out of adjustL1 GIRT BAR NOT LATCHING INTO SLOTS WHEN ENGAGED. ADJUSTED GIRT BAR PER MM 25-66-01 OPS CHECK GOODSDR SWAA2025111132874Attach Bracket · damagedLEFT WING UPPER OTBD MLG SUPPORT BEAM ATTACH BRACKET HAD ELONGATED HOLES. REMOVED AND REPLACED SUPPORT BRACKET PER SRM 51-40-02.SDR SWAA2025111132736Isolator Mount · crackedFWD SERVICE DOOR AFT UPPER SLIDE ISOLATOR MOUNT CRACKED. R & R FWD SERVICE DOOR AFT UPPER SLIDE ISOLATOR MOUNT IAW AMM 52-40-02.SDR SWAA2025111133955Light · inoperativeBLUE STATUS LIGHT INOPERATIVE IN FORWARD GALLEY OVERHEAD, WHEN FLIGHT ATTENDANT CALL BUTTON IS PRESSED. THE LIGHT DOES NOT ILLUMINATE. TROUBLESHOT FWD GALLEY CALL LIGHT SUSPECT RELAY ES410-1538. REMOVED AND REPLACED FWD FLIGHT ATTENDANT EMERGENCY EXIT LIGHT