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 SWAA2025072487731Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 578+5' UPPER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT WAS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487732Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 597+2' TO STA 616 LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT WAS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487726Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 685+9' TO STA 706+1' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT WAS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487739Seat Track · corroded(147-113) MAIN CABIN SEAT TRACK LBL 45 STA 639+23' TO STA 663.75+14' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT WAS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487737Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 663.75+1' TO STA 663.75+3' UPPER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT IS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487738Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 639+4' TO STA 639+8' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT IS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487740Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 45 STA 639+7.5' UPPER SIDE OF CROWN HAS EVIDENCE OF CORROSION. FAULT IS RESOLVED ON FAULT TTG8Q013HN6W.SDR SWAA2025072487749Seal · crackedHORIZONTAL STAB PANEL 343AT AFT BODY SEAL CRACKED AND WORN. REPLACED AFT BODY SEAL ON HORIZONTAL STAB PANEL 343AT IAW SRM 51-40-02-0G-0; STEP 9. ATAG A337238; PN 186A3003-40; AIPC REFERENCE 55-10-52.SDR SWAA2025072487746Seal · crackedHORIZONTAL STAB PANEL 333AT AFT BODY SEAL CRACKED AND WORN. REPLACED AFT BODY SEAL ON HORIZONTAL STAB PANEL 333AT IAW SRM 51-40-02-0G-0; STEP 9. IAW AIPC 55-10-52.SDR SWAA2025072487725Seat Track · corrodedMAIN CABIN SEAT TRACK LBL 25, BS 685+8.5 - 706+1 LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. CUT, & REMOVED DAMAGED PART OF THE SEAT TRACK BETWEEN BS 639+17 AND 706+10 LBL 25. INSTALLED A NEW SEAT TRACK REPAIR PART IAW SRM 53-00-52-2R-3.SDR ASAA2025070259621Frame · crackedFUSELAGE BS 500A LEFT IS CRACKED AT THE A/C RAIL SUPPORT BRACKET INBD FASTENER HOLE. GROUNDED - YES. REPAIRED BS 500A LEFT IAW TC AD 2024 1807-700-25-IL FIG 5.SDR IPXA2025072237941Skin · crackedMAJOR REPAIR, LH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACK INDICATION NOTED AT RIB 27. CIRCLED IN RED. ACCOMPLISH REPAIR IN ACCORDANCE WITH EO-94346-REQ1 AND VT-MAE EA 300-5750-27-A4023, REV. -. CAUTION: THE WORK INSTRUCTIONS CONTAINED WITHIN (OR APPROVESDR SWAA2025072287846Attach Angle · crackedCRACKED ATTACH ANGLE AT PASSENGER COMPARTMENT BS 687; RBL 2; WL 208. REMOVED AND REPLACED PASSENGER COMPARTMENT ATTACH ANGLE BS 687; RBL 2; WL 208 IAW SRM 51-40-02-0G-0 AND DEW 273A9110.SDR SWAA2025072287844Web · corrodedMULTIPLE AREAS OF CORROSON ON ACD SUBTHRESHOLD WEB BETWEEN BS792-BS847 RBL24; WL156. REMOVED AND REPLACED ACD SUBTHRESHOLD WEB PER SRM 51-40-02; SRM 51-40-05 AND DWG 146A8340 ID:0028 REV:-.SDR SWAA2025072287504Panel · debondedPANEL 193AR I/B END OF INNER SKIN IS DISBONDED OVER CORE AREA. REPLACED ON OTHER FAULT TTG8Q013H7KJ.SDR SWAA2025072287845Floorbeam · crackedCRACKED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; LBL 2; WL 208. REMOVED AND REPLACE PANEL BREAK AT PASSENGER COMPARTMENT BS 540; LBL 2; WL 208 I.A.W SRM 51-40-02-0G-0.SDR AALA202507218072Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING LH SIDE AFT GALLEY AREA MEASURES OF CORROSION ARE: L= 0.823IN W= 0.291IN D= 0.040IN. MAINTENANCE REPLACED CENTER FITTING LOC. FR 66 TO FR 68 AT LEVEL STRG 23 LH SIDE AFT GALLEY AREA IAW A319 SRM 51-72-11-SDR JJBA20250721074Doubler · corrodedRH OMEGA BEAM AT FR20 FLOOR DOUBLER FOUND CORRODED. AT RH OMEGA BEAM AT FR20 DOUBLER FOUND CORRODED OUT OF LIMITS. DOUBLER REMOVED, DRILLED NEW HOLES FOR NEW DOUBLER. AT RH OMEGA BEAM AT FR20, NEW DOUBLER INSTALLEDSDR JJBA20250721073Floor Support · corrodedRH OMEGA BEAM AT FR 22 FLOOR DOUBLER FOUND CORRODED. AT RH OMEGA BEAM AT FR 22, DOUBLER FOUND CORRODED OUT OF LIMITS. DOUBLER REMOVED, DRILLED NEW HOLES FOR NEW DOUBLER. AT RH OMEGA BEAM AT FR22, NEW DOUBLER INSTALLED.SDR IPXA2025071131150Profile · crackedCRACK AT FR74 HOLE ON PROFILE-Z RH BTW FR72 AND FR75. RT PROFILE-Z FR72-75 REMOVED DUE TO CRACK IAW SRM 51-40-21. FABRICATED NEW PROFILE Z IAW GMM 09.08.01.03 FOLLOWING 4 AND SRM 53-18-18 FIGURE 3 SHEET 2 ITEM 55. INSTALLED NEW PROFILE Z RH FOR STRUCTURE BTSDR CALA2025071706652Strap · corrodedAFT CARGO COMAPRTMENT. AFT CARGO DOOOR SURROUND STRUCTURE STRAP BETWEEN BS 787 AND 847, S25R POSSIBLE CORROSION. REMOVED AND REPLACED STRAP IAW SRM 51-40-02-0G-0 AND DWG 146A8120.SDR IPXA2025071525054Skin · corrodedMAJOR REPAIR, CORROSION-SKIN, AFT CGO COMPT FWD SIDE LWR SKIN, NEAR STA 1081 S-39L~S-39R. ACCOMPLISHED REPAIR I.A.W UPS EO NO:EO-94375-REQ1 REV.1 AND BOEING DWG NO.140T0130 SH.16 REV.C;140T0130 SH.7 REV.C;146T1201 SH.1 REV.H AND 146T3261 SH.3 REV.-.SDR IPXA2025071524693Shaft · corrodedCORROSION AT LH SIDE NO.4 FLAP SUPPORT MECHANISM 6-6 OUTER SHAFT, STEP 3. PERFORM OK TO INSTASLL CHECK SATISFIED & INSTALL NEW LH WING NO.4 FLAP SUPPORT MECHANISM 6-6 OUTER SHAFT & CONDITION CHECK NORMAL. (RII ITEM) CHECKED COMPLETED.SDR IPXA2025071225363Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 OUTBOARD IN BULK CARGO COMPARTMENT LEFT AREA. INSTALL NEW ANGLE I.A.W SRM 51-40-02-0G REV.92 AND BOEING DWG NO: 146T5650 SHEET 5 REV.C.SDR IPXA2025071224874Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 RBL 80 OUTBOARD IN BULK CARGO COMPARTMENT RIGHT AREA. INSTALL NEW ANGLE I.A.W SRM 51-40-02-0G REV.92 AND BOEING DWG NO: 146T5650 SHEET 5 REV.C. INSTALLED DADO PANEL I.A.W AMM 25-59-01-404-019 REV. 145.SDR IPXA2025071224994Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 RBL 80 INBOARD IN BULK CARGO COMPARTMENT RIGHT AREA. I.A.W AMM 25-57-05-004-001 AND AMM 25-58-04-004-010 REV.145 REMOVED MAIN DECK CARGO HANDLING AND G.V.I CONDITION CHECK NORMAL. REMOVED DAMAGE ANGLE I.A.W SRM 51-40-02-0G RESDR IPXA2025071225374Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 INBOARD IN BULK CARGO COMPARTMENT LEFT AREA. INSTALL NEW ANGLE I.A.W SRM 51-40-02-0G REV.92 AND BOEING DWG NO: 146T5650 SHEET 5 REV.C.SDR IPXA2025071521351Channel · corrodedMAJOR REPAIR, CORROSION AT CARGO COMPARTMENT CEILING PANEL SUPPORT BETWEEN STA 1219 AND STA 1351 , RBL 63.5. ACCOMPLISHED CHANNEL REPAIR I.A.W UPS EO NO: EO-94397-REQ1 REV1. 2.INSTALLED NEW WEB AND CHANNEL IAW SRM 51-40-02-0G REV. 92 AND DWG 146T5401 SH 11 SDR IPXA2025071120737Support · brokenMAJOR REPAIR, BROKEN FORWARD CARGO COMPARTMENT CEILING SUPPORT AT STA 610 AND RBL 64.50. COMPLETED STRAP REPAIR IAW EO NR EO-94373-REQ1 REV1.SDR IPXA2025071430904Seat Track · corrodedMAJOR REPAIR FOUND CORROSION AT SEAT TRACK BTW FR 79 AND FR80-82 Y0 ACOMPLISHED, REPAIR SEAT TRACK, P/N A53279239202, PER SRM 53-10-16-201 PARAGRAPH 4 FIGURE 201. REV. 42. CAUTION: THE WORK INSTRUCTIONS CONTAINED WITHIN (OR APPROVED BY) THIS EO CONTAIN RII INSDR SWAA2025071487864Handle · looseL2 DOOR ASSIST HANDLE LOOSE. SECURED L2 DOOR ASSIST HANDLE IAW B737-800 AMM 52-13-31-400-802.SDR IPXA2025071423622Adapter · corrodedFOUND CORROSION AT CLS ADAPTER FR77 -Y1580.5. VERIFIED INSTALLATION.SDR AALA202507147481Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF AFT GALLEY SHEAR WEB AT BS 986, RBL 32. REPAIRED WEB PER EA 366091.SDR AALA202507127891Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: DOOR 3L INDICATING AS DISARMED IN FLIGHT ON THE ECAM DOOR PAGE WITH THE ARMING LEVER IN THE PROPER ARMED POSITION. THIS DOOR WAS CONFIRMED AS INDICATING PROPERLY ARMED PRIOR TO DEPARTURE ON THE GROUND. MAINTENANCE REPLACED THE L3 DSDR SWIA202507110002Stop Fitting · crackedUPON TROUBLESHOOTING HARD TO CLOSE PAX DOOR FOUND FORWARD STOP BRACKET CRACKED. (FILED CLOSED)REMOVED AND REPLACED PAX DOOR FORWARD STOP BRACKET WITH REFERENCE TO SRM 51-42-21. COMPLIED WITH TASK CARD 51-900-1002-SKY. COMPLETED M-337. REFERENCE CHILD CAMP SDR JJBA20250711003Floor Support · crackedFWD AND AFT DIGITAL PLATE JOINT ANGLES FOUND CRACKED AT CENTER OMEGA BEAM INBD AND OUTBD SIDE ON LH OMEGA BEAM INBD SIDE. FWD AND AFT DIGITAL PLATE JOINT ANGLES AT CENTER OMEGA BEAM AND LH OMEGA BEAM JOINT ANGLE REPLACED.SDR AALA202507119437Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663.5, RBL 2. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR JBZA20250710001Elec Connector · arcedDURING FINAL APPROACH TO BASE AN ELECTRICAL SMELL WAS DETECTED COMING FROM THE CENTER CONSOLE TDFM / SKY TRAC PANELS. DURING EVALUATION OF THE SYSTEMS IT WAS DISCOVERED THE CONNECTOR TO THE TDFM WAS THE SOURCE OF THE SMELL. FOUND CONNECTER WITH BROKEN MALE PINSDR DALA2025071005194Elec Connector · disconnectedSHIP 3265 DISC: L-1 DOOR EMERGENCY LIGHT DOES NOT ILLUMINATE. C/A: FOUND CONNECTOR PLUG OFF POWER SUPPLY 10WL. RECONNECTED CANNON PLUG. LIGHT NOW TESTS GOOD PER A320 AMM 33-50. A/C OK FOR SERVICE. (LP: 7157094)SDR UIEA2025070700845Ram Air Turb · unwanted deployRAM AIR TURBINE DEPLOYMENT ON GROUND. C/W RETRACTION OF RAT PER AMM 29-21-00-860-802. NO STATUS MSG. SAFETY WIRED T-HANDLE. NO FURTHER DEFECTS NOTED.SDR DALA2025070805080Controller · faultedSHIP 8141 - ATB - DUE TO ALL LAVATORIES NOT FLUSHING AT ALTITUDE. CORRECTIVE ACTION: REPLACED WASTE SYSTEM CONTROLLER. (LP# 7558246, 1058111, 7558248, 1061771, 7558256)SDR DALA2025070805070Fuel Sys · leakingSHIP 9584 C/W ERA 621136-14AD REV A - RH WING / REAR SPAR LOWER CAP / FUEL LEAK. CORRECTIVE ACTION: C/W ERA 621136-14AD REV A (1058308)SDR DALA2025070805067Pan · crackedSHIP 9509 INITIAL INSPECTION: CRACK ON FWD EDGE INNER AND OUTER PAN DOOR BTW BEAM 1 AT AFT CARGO DOOR COMPARMENT. CORRECTIVE ACTION: FWD EDGE INNER AND OUTER PAN DOOR BTW BEAM 1 AT AFT CARGO DOOR COMPARMENT WERE REPAIRED PER ERA 626981-14 REV. ORIGINAL, SECTIOSDR AALA202507087397Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY AISLE LIGHT AT SEAT 18ABC WILL NOT ILLUMINATE. FOUND CANNON PLUG DISCONNECTED, REONNECTED, PER SWPM 20-60-06. OPERATIONAL CHECK GOOD.SDR AALA202507086850Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER LAVATORY-D DIFFICULT TO OPEN AND CLOSE. ADJUSTED AFT LAVATORY-D LATCH. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202507087563Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: CREW REPORTS DOOR DIFFICULT TO OPEN TO ENTER COCKPIT. LUBRICATED LATCH ASSEMBLY AND ACCOMPLISHED OPERATIONAL. PER AMM 52-51-02.SDR AALA202507084723Wire · disconnectedAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND L2 DOOR EMERGENCY EXIT LIGHT NOT WORKING REMOVED LIGHT ASSEMBLY AND FOUND IT WAS DISCONNECTED. CONNECTED AND REINSTALLED LIGHT ASSEMBLY. PER AMM 33-51-01. PERFORMED OPERATIONAL CHECK AND IT WAS GOOD.SDR AALA202507085307Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, LBL 30. ACCOMPLISHED REPAIR PER AARD 57-10-10-9.SDR ASAA2025070259205Sign · missingEXIT ROW SIGN LOWER 16F MISSING. GROUNDED - YES. INSTALLED NEW EXIT ROW SIGN AT 16F - P/N 207377-1007 REF AMM 33-51-01.SDR ASAA2025070259189Guide Arm · no testFA UNABLE TO CLOSE L1 DOOR MIG-2C #40-0061016 INITIATED, 40-0061017 INITIATED. GROUNDED - YES. REF FWD ENTRY DOOR SYSTEM TEST, AMM TASK 52-11-00-700-804 E3D TORQUE TO OPEN INT HANDLE REQUIRED WAS AT HIGHER END OF ADJUSTABLE LIMITS. SEVERE SQUEAL COMING FROM UP