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 QR9R2025082100001Actuator · failedABORTED TAKEOFF DUE TO TAIL ROTOR PEDALS HAVE EXCESSIVE FREEPLAY AT IDLE AND WITH ENGINES NOT RUNNING. TROUBLESHOOTING REVEALED YAW TRIM ACTUATOR WAS GRINDING. REMOVED AND REPLACED YAW TRIM ACTUATOR IAW AMM 67-14-00, 4-1. TEST FLIGHT SUCCESSFULLY COMPLETED IAWSDR DALA2025082106241Cover · missingARMED LIGHT COVER IS MISSING FROM 2 RIGHT AFT DOOR. REPLACED COVER PER A319 AMM 52-73. OPS CK GOOD. (1155245)SDR AALA202508219012Light · detachedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTING EMERGENCY LIGHT HANGING DOWN FROM SEAT ROW 30C. REATTACHED AND SECURED EMERGENCY LIGHT COVER. OPERATIONAL CHECK GOOD. PER AMM 33-50-00.SDR 2025FA0000561Beam · corrodedFS 669.759 BEAM BAGGAGE DOOR CORROSIONSDR KCSA202508211145Trunnion · corrodedLEFT WING GEAR TRUNNION SUPPORT FITTING I/B HAS CORROSIONSDR KCSA202508211144Attach Bracket · crackedLT HORIZONTAL STAB OUTBD FRAME ATTACH BRACKET AT APPROX ELEV STA 552 CRACKEDSDR KCSA202508211143Web · crackedR/H I/B ELEVATOR MOST I/B WEB CRACKEDSDR KCSA202508211142Support Bracket · crackedE/E COMPARTMENT FLOOR SUPPORT BRACKET AT STA 400 LBL 15 CRACKEDSDR KCSA202508211141Attach Bracket · crackedRT HORIZONTAL STAB OUTBD FRAME ATTACH BRACKET AT ELEV STA 560 CRACKEDSDR KCSA202508211140Attach Bracket · crackedLT HORIZONTAL STAB OUTBD FRAME ATTACH BRACKET AT APPROX ELEV STA 560 CRACKEDSDR KCSA202508211139Floor Support · crackedE/E BAY FLOOR SILL CRACKED AT STA 400 BL 0SDR 2026FA0000153Attach Fitting · crackedLEFT WING FORWARD SPAR, OUTBOARD UPPER AFT-FACING WING ATTACH FITTING WAS FOUND TO BE CRACKED WITHIN GEAR WELL. THE PART IS SHOWN IN THE 421C IPC, SECTION 03-50, PAGE 16, ITEM 6. THE CRACK MEASURES ROUGHLY 5-1/8" AND RUNS HORIZONTALLY ACROSS SEVEN RIVET HOLES.SDR SWIA2025082075376Hinge Fitting · gougedPAX DOOR FUSELAGE SIDE HINGE AFT LUG LANDING HAS A SMALL GOUGE FROM HINGE PIN RETAINER PIN CONTACT/WEAR. PERFORMED REPAIR OF PAX DOOR FUSELAGE SIDE HINGE AFT LUG LANDING WITH REFERENCE TO REO 670-53-21-582 REV "-G" DATED 2024-02-18 TYPE IV: DISPOSITION FOR SDR SWIA2025082075373Doubler · gougedTWO SMALL SCREW GOUGES ON A DOUBLER AT STGR 27 BETWEEN BS 969 AND 985 ON THE EXTERIOR OF THE AIRCRAFT. COMPLIED WITH REO 670-53-61-352, REV A. REPAIRED THE FUSELAGE SKIN AT BS 977 AND STR 27 BY REMOVING AND REPLACING A NEW SERVICEABLE DOUBLER. MAJOR REPAIR.SDR SWIA2025123000820Cross Bar · chafedAFT CARGO DOOR, UPPER CROSS BAR BETWEEN THE TWO TRACKS, HAS CHAFING INTO THE STRUCTURE WHERE THE DOOR SUPPORT CABLES TRAVEL ACROSS. PERFORMED REPAIR AT AFT CARGO DOOR UPPER CROSS BAR AT FS 1000.00 AND FS 1047.00 IAW CRJ 900 SRM 53-61-58, 51-21-11, 51-25-06, SDR SWI2025F01707Intercostal · corrodedINTERCOSTAL S26L BETWEEN BS 881 AND 897.7 HAD CORROSION ON WEB. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-42-06-001-001-A01, AND DWG SH690-37060, REV R.SDR SWI2025F01706Cleat · corrodedCLEAT COMMON TO BS 881 AND INTERCOSTAL, S26L HAS CORROSION. BLENDED CORROSION AND FOUND OUT OF LIMITS. REPLACED WITH A NEW CLEAT IAW SRM 51-42-06-001-001-A01 & DWG SH690-37060, REV AC. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01705Web · corrodedRIGHT LOWER WEB AT BS 280 HAD INTERGRANULAR CORROSION. REMOVED AND REPLACED WITH A NEW WEB. IAW SRM 53-11-10-201-004-A01. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY.SDR SWIA202512020820Frame · corrodedFRAME BS 881 ON AFT WEB FACE AND BOTTOM ATTACH FLANGE FROM S26L TO S26R HAD CORROSION. REMOVED AND INSTALLED NEW LOWER FLANGE REPAIR ANGLE IAW SRM 53-00-06-201-001-A01, FIGURE 53-00-06-991-869, REPAIR STEPS 6A. E, A-K.SDR IPXA2025111678023Skin · damagedLIGHTNING STRIKES DAMAGE ON RIGHT WING INBD AILERON OTBD TRAILING EDGE. MEASURES APPROX. 1.125? LENGTH. COMPLETED ALL STEPS OF EO-94805-REQ3. THIS REPAIR IS PERMANENT.SDR SWI2025F01446Skin · corrodedCORROSION AROUND WING PLANK OF ACCESS 540BB (C-CHECK RO 10/19/2025)REMOVED CORROSION FROM 540BB LANDING IAW REO 601R-57-21-030 REV. L, DATED 2014-02-05 AND REO 601R-57-21-3969 REV -- DATED 2025-8-26. ATTACHED COMPLETED FORM 337 AND TASK CARD 51-900-1003-SKYSDR SWIA2025102000820Access Panel · corrodedCORROSION FOUND ON PANEL 640BB FUEL TANK ACCESS PANEL LANDING. (C-CHECK RO 10/19/2025)REMOVED CORROSION FROM 640BB LANDING IAW REO 601R-57-21-030 REV. L, DATED 2014-02-05 AND REO 601R-57-21-3968 REV -- DATED 2025-8-25. ATTACHED COMPLETED FORM 337 AND TASK CASDR IPXA2025092062049Skin · crackedRIGHT WING T/E UPPER FIXED PANEL FWD OF NR 4 SPOILER IS CRACKED. INSTALLED NEW PART SKIN IN RT WING T/E UPPER FIXED PANEL FWD OF NR 4 SPOILER IAW SRM 51-40-21, SRM 57-51-12 AND SRM 51-57-10.SDR IPXA2025092062020Skin · crackedRIGHT WING T/E UPPER FIXED PANEL FWD OF NR 5 SPOILER IS CRACKED. INSTALLED NEW PART SKIN IN RT WING T/E UPPER FIXED PANEL FWD OF NR 5 SPOILER IAW SRM 51-40-21, SRM 57-51-12 AND SRM 51-72-10.SDR HNAA2025100300671Skin · crackedF066756 REAR FUSELAGE EXTERNAL SKIN HAS POSSIBLE CRACK AT FR 77 BETWEEN STGR 6R / 7R. ACCOMPLISHED BUSHING REPAIR ON REAR FUSELAGE EXTERNAL SKIN AT FR 77 BETWEEN STGR 6R /7R IAW EO1-53-25-0351 AND EMB-145 SRM 53-32-01 RE, ITEM 9, FIGURE 213, SHEETS 1-3.SDR ASAA2025082061212Skin · crackedLEFT HORIZONTAL STAB LOWER SKIN IS CRACKED ON THE I/B SIDE OF STA 147.90 APPROX 8 INCHES FROM REAR SPAR.262A001. GROUNDED - YES. REPAIRED LEFT HORIZ STAB LWR SKIN AT STA 147 IAW B737-800 SRM 55-10-01-2R-11, THIS IS A CAT B REPAIR WITH A THRESHOLD AT 56,000 FLISDR SWAA2025093006350Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAS AREAS OF PULLED STRANDS. DUE TO THE EXTENT OF DAMAGE. REPLACED FLOOR PANEL 241AF WITH NEW PANEL IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-21-00-42A ITEM 75.SDR SWAA2025093006346Floor Panel · pulledFLOOR PANEL 231YF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPLACEMENT 231YF FLOORBOARD WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025093006498Pressure Deck · crackedCRACK NOTED ON RT HORIZONTAL PRESSURE DECK WEB EDGE OF STIFFENER BS 663+10, RBL 41.5, L: 0.4'. INSTALLED A REPAIRBS 663- BS 706; RBL 24.5- RBL 45. WL 204 IAW SRM 53-40-51-2R-2, REPAIR 2, FIGURE 202.SDR SWAA2025093006351Floor Panel · pulledFLOOR PANEL 242AF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED FLOOR PANEL 242AF IAW SRM 53-00-50-2R-0 AND DWG 144A5810 0189.SDR SWAA2025093006347Floor Panel · pulledFLOOR PANEL 231ZF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPLACEMENT 231ZF FLOOR PANEL WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025093006353Floor Panel · pulledFLOOR PANEL 241BF UPPER SKIN HAS AREAS OF PULLED STRANDS. DUE TO EXTENT OF THE DAMAGE NEW 241BF FLOOR PANEL WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025093006349Floor Panel · pulledFLOOR PANEL 232SF UPPER SKIN HAS AREAS OF PULLED STRANDS. DUE TO EXTENT OF THE DAMAGE NEW 232SF FLOOR PANEL WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025092906671Angle · crackedCRACK ANGLE - CLIP LOCATED BS500F RBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED BS500F RBL24 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9 AND DWG 143A7505 SHEET 109 REV. -.SDR SWAA2025092906672Angle · crackedCRACK ANGLE - CLIP LOCATED BS500G FWD POSITION RBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE-CLIP AND LOCATED BS500G FWD POSITION RBL24 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7505 SHEET 108 REV: -.SDR SWAA2025092906680Angle · crackedCRACK ANGLE - CLIP LOCATED BS500G AFT POSITION RBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE-CLIP LOCATED BS500G AFT POSITION RBL24 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7505 SHEET 108 REV: -.SDR SWAA2025092906681Angle · crackedCRACK ANGLE - CLIP LOCATED BS500H FWD POSITION RBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE-CLIP AND LOCATED BS500H FWD POSITION RBL24 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7505 SHEET 108 REV: -.SDR SWAA2025092906682Angle · crackedCRACK ANGLE - CLIP LOCATED BS500H AFT POSITION RBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOCATED BS500H AFT POSITION RBL24 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9 AND DWG 143A7505 SHEET 109 REV. -.SDR SWAA2025092906674Support Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED BS500I LBL25 WL156 AT FWD CARGO COMPARTMENT. REMOVED AND EVALUATED REWORKED AREA ON ANGLE-SUPPORT LOCATED BS500I LBL 25 WL156 AT FWD CARGO COMPARTMENT AND FOUND WITHIN LIMITS IAW SRM 53-30-08-1A-1 ALLOWABLE DAMAGE 1 PARAGRAPHSDR SWAA2025092906684Angle · crackedCRACK ANGLE - CLIP LOCATED BS500H LBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP AND FASTENERS LOCATED BS500H LBL24 AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND SRM 51-10-02 PARAGRAPH 9 AND DWG # 143A7505 SHEET 110 REV: -.SDR SWAA2025092606489Access Panel · crackedCRACK ON BLADE LOCATED ACCESS PANEL 333AT AT LT HORIZONTAL STABILIZER. REPLACED BLADE LOCATED ACCESS PANEL 333AT AT LT HORIZONTAL STABILIZER IAW SRM 51-40-02.SDR ASAA2025082061087Cargo Track · corrodedAFT CARGO RH CARGO TRACK HAS SCRIBE MARKS AROUND CARGO TIEDOWNS AND AREAS OF CORROSION NEAR STA 787. GROUNDED - YES. REPAIR AFT CARGO RH CARGO TRACK IAW SRM 53-00-53-2R-3 W= 1.5" O= .070" R= .045" L= 4" D= .025".SDR ASAA2025082061083Support · corrodedFWD CARGO AFT BULKHEAD RT SIDE LOWER SUPPORT HAS CORROSION AND BARE METAL. GROUNDED - YES. REMOVED AND REMPLACED FWD CARGO AFT BULK HEAD RH SIDE LOWER SUPPORT IAW SRM 51-40-02-0G-0W= 1 O= .071 R= .041 L= 2 D =.030.SDR ASAA2025082061081Skin · crackedRIGHT HORIZONTAL STAB LOWER SKIN IS CRACKED ON THE INBD SIDE OF HSS 129.560 APPROX 24 INCHES FROM FRONT SPAR. GROUNDED - YES. REPAIRED RT HORIZONTAL STAB LOWER SKIN AT STA 129 IAW SRM 55-10-01-2R-11. THIS IS A CAT B REPAIR, WITH A THRESHOLD INSPECTION AT 56,00SDR ASAA2025082061080Cargo Track · crackedAFT CARGO RT CARGO TRACK CRACKED AT STA 727G AND 727J. GROUNDED - YES. REPAIRED AFT CARGO R/H CARGO TRACK AT STA 727G AND 727J IAW B737-800 SRM 53-00-53-2R-3.SDR ASAA2025082061079Skin · crackedRIGHT HORIZONTAL STAB LOWER SKIN IS CRACKED ON THE I/B SIDE OF STA 138.70 APPROX 9 INCHES FROM FRONT SPAR. GROUNDED - YES. REPAIRED RIGHT HORIZONTAL STAB SKIN AT STA 138.70 APPROX 9 INCHES FROM FRONT SPAR IAW B737-800 SRM 55-10-01-2R-11. THIS IS A CAT B REPAIRSDR SWAA2025092406676Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500C & 500I, LBL 24, WL 156 IN FWD CARGO BAY. FAULT RESOLVED ON OTHER FAULT TTG8Q014P2RJ.SDR SWAA2025092406666Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500A - 500D, RBL 24, WL 156 IN FWD CARGO BAY. FAULT RESOLVED ON OTHER FAULT TTG8Q014P4WJ.SDR SWAA2025092406677Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500F - 500I, RBL 24, WL 156 IN FWD CARGO BAY. THE DAMAGE WAS REPAIRED IAW SRM 53-00-53-2R-5, REPAIR 5, AND EA M-22-153-01550 ON SUPPORT ZEESDR SWAA2025092406668Support · damagedELONGATED HOLE ON SUPPORT ZEE LOCATED BTW BS 480 TO BS 500 LBL24 AT FWD CARGO BAY. THE DAMAGE WAS REPAIRED IAW SRM 53-00-53-2R-5, REPAIR 5, AND EA M-22-153-01550. ON SUPPORT ZEE.