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 DALA2025102207725Bonding Strap · corrodedSHIP 3153 CORROSION BONDING STRAP ACCESS PANEL 633CB ON RH WING. CORRECTIVE ACTION: COMPLIED WITH ER/A 622998-14TR. (12364351).SDR DALA2025102207724Bonding Strap · corrodedCORROSION BONDING STRIP FLAP TRACK FAIRING 3 (532CB) ON LH WING. COMPLIED WITH ER/A 622998-14TR. (1264336).SDR DALA2025102207723Bonding Strap · corrodedCORROSION ON LATERAL BONDING STRIP FLAP TRACK FAIRING 531CB ON LH WING. COMPLIED WITH ER/A 622998-14TR. (1264332).SDR DALA2025102207722Fairing · debondedDEBONDED FAIRING 632CB BONDING STRAP ON RT WING. COMPLIED WITH ER/A 622998-14TR. (1264321).SDR DALA2025102207721Bonding Strap · corrodedCORROSION BONDING STRIP FLAP TRACK FAIRING 2 (631CB) ON RH WING. COMPLIED WITH ER/A 622998-14TR. (1264312).SDR DALA2025102207720Bonding Strap · corrodedCORROSION BONDING STRIP FLAP TRACK FAIRING 2 (631CB) ON RT WING. COMPLIED WITH ER/A 622998-14TR. (1264291).SDR HNAA2025102200722Battery · inoperativeCIELING AT ROW 5 AND MAIN DOOR, ALONG WITH MAIN DOOR EMERGENCY LIGHTS INOP. R & R BATTERY NR 1 IAW AMM 33-50-04.SDR DALA2025102207710Not Reported · crackedA CRACK WAS FOUND AT HOLE 263 RH. REPAIRED PER ERA 629510-14. (1264152)SDR DALA2025102207709Not Reported · crackedCRACK WAS FOUND AT HOLE 260 RT. REPAIRED PER ERA 629510-14. (1264149)SDR 2025FA0000727Egt Indication · intermittentUPON 7TH TAKEOFF FOR PATTERN WORK, CYLINDER # 4 EGT ROSE IN THE RED, STUDENT PILOT INSTANTLY REDUCED POWER TO IDLE AND TAKE OFF WAS ABORTED, TESTED IN RUN UP AREA AND COULD NOT REPLICATE. MAINTENANCE DOWNLOADED ECU FAULT LOGS AND REPLACED #4 EGT PROBE WITH NEWSDR FDEA202510212056Battery Pack · inoperativeON PRE-DAPARTURE CHECK FOUND EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED R/H EMERGENCY LIGHT BATTERY ASSY IAW AMM 33-51-07-2. OPERATIONAL CHECK OK. A/C OK FOR SERVICE.SDR QR9R2025102100001Module · damagedTHE MOD 05 ASSEMBLY WAS RECEIVED FROM SUPPLY UNSERVICEABLE DUE TO DAMAGED DOWEL PIN.SDR EE4Y2025102123356Wire Harness · damagedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-200435-01-1-002, SECONDARY FINDING DURING REMOVAL OF WIRE BUNDLE SUPPORT AT ENGINE 2, FOUND SUPPORT ATTACH HOLES OVERSIZED (2EA) AT ENGINE FLANGE B1 (BOLT HOLE LOCATION 79 AND 80).REPAIRED ENGINE 2 FLANGE B1 (BOSDR 2025F00248Housing · corrodedREPAIR CORROSION IN NLG HOUSING TUNNEL PER TEXTRON FIELD REPAIR FR-680A-0043-15554. REPAIRED CORROSION IN NLG HOUSING TUNNEL BY REPLACING PANELS PN: 7411212-3, 7411212-4, AND OVER-SIZING HOLE IN TOP SKIN 7411212-9 FROM A BJ4 FASTENER TO A BJ5 FASTENER IAW TEXTSDR 2025F00247Thrust Reverser · corrodedDURING INSPECTION OF THE LH TR NOTED MULTIPLE SPOTS OF CORROSION ON THE INSIDE SIDES OF THE UPPER BUCKET. MECHANICALLY BLENDED 13 EA. AREAS OF CORROSION ON THE LH THRUST REVERSER UPPER DOOR, INBD AND OUTBD AREAS IAW CE680A SRM 51-10-01 AND SRM 51-70-03. AFTER SDR 2025F00246Fitting · corrodedWHILE PERFORMING TASK 57-10-00-222 FOUND THAT LH EMERGENCY BRAKE CARRY THROUGH CORRODED AROUND FITTING. DISCONNECTED EXISTING LT MLG EMERGENCY BRAKE PNEUMATIC LINE AND REMOVED EXISTING CARRY-THROUGH FITTING ON RIB LOCATED AT W.S. 37.00 FOR ACCESS. BLENDED 1 EASDR EE4Y2025102123355Window Frame · damagedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-531135-03-1-001, UPPER FUSELAGE LH WINDSHIELD SIDE POST AT FR4 UPPER ATTACHMENT INTERNAL SIDE FWD INBOARD HOLE WITH CRACK INDICATION DUE TO ITS OVALITY.AIRBUS WAS CONTACTED FOR REPAIR INSTRUCTIONS. AIRBUS PROVIDSDR EE4Y2025102123354Door Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGAINT TASK A32X-53-260-002, UPPER FUSELAGE AFT PASSENGER CREW DOOR FR66 RH AT DOOR STOP FITTING # 1 LOWER INBOARD FASTENER HOLE WITH CRACK INDICATION WAS FOUND. PERFORMED REPAIR LOCATED AT UPPER FUSELAGE AFT PASSENGER CREW DOORSDR EE4Y2025102123353Door Frame · crackedDURING ACCOMPLISHMENT THE ALLEGIANT TASK A32X-53-260-003, UPPER FUSELAGE AFT PASSENGER CREW DOOR FR60 LH AT DOOR STOP FITTING # 1 LOWER INBOARD FASTENER HOLE WITH CRACK INDICATION WAS FOUND.PERFORMED REPAIR AT UPPER FUSELAGE AFT PASSENGER /CREW DOOR FR68 LH ATSDR DALA2025102107680Elec Connector · damagedEMERGENCY PATH LIGHT SEAT 43J INOPERATIVE. REPAIRED CONNECTOR PER A330 AMM 33-51. OK FOR SERVICE. (7979274)SDR DALA2025102107678Not Reported · corrodedBULK CARGO SECTION LONGITUDINAL CORROSION AT Y480 FR68-FR69. REPLACED PER A330 SRM 51-72-11-911-001. (1263316)SDR DALA2025102107677Not Reported · corrodedBULK CARGO SECTION LONGITUDINAL CORROSION AT Y0 FR69. REPLACED PER A330 SRM 51-72-11-911-001. (1263309)SDR DALA2026101905730Skin · damagedDAMAGE TOLERANCE EVALUATION (DTE) REQUIRED. ERA 629805-14 SECTION I ACCOMPLISHED IN MSP DURING CHK. FOLLOW ON ACTION IS REQUIRED ON FUSELAGE SKIN AT FR26, STR. 21L-STR. 22L. ERA 629805-14 SECTION I REPAIR IS ACCEPTABLE FOR 12 MONTHS FROM 17OCT2025 PENDING DTE SDR DALA2026091105092Seat Track · corrodedREMOVED AND INSTALLED SEAT TRACK PER A220 ASRP 51-77-00- 000AAA-028A-1. 001-0585:5300-2016/002 00428 REMOVED AND INSTALLED SEAT TRACK PER A220 ASRP 51-77-00-000AAA-028A-1 LOG 1262558 CORROSION LEVEL CHANGED FROM: N TO: 2. (LP# 1262558; AIRCRAFT WAS GROUNDED)SDR AALA202601142899Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT STA 328, RBL 46. REPAIRED UPPER TEE PER SRM 53-10-51-2R-8 ALTERNATVIE 3 AND EA 369583.SDR SWIA2026010500020Frame · corrodedFRAME AT BS 605 AND BETWEEN S20L-18L HAS SEVERAL CORROSION AND CRACKED AT S18L. REMOVED AND REPLACED BY NEW FRAME SECTION AT BS 605 BETWEEN S20L-S18L AND WL 73 REF. DWG 601R36026 REV. AF, SRM 51-42-06 AND SRM 51-42-21, REV. 39. COMPLIED WITH TASK CARD 51-90SDR SCNA20251022404SSlide · dislodgedL1 SLIDE DETACHED ( MAIN CABIN EXIT/SLIDE L-1 DOOR SLIDE INOPERATIVE OR MISSING PROVIDED R1 OPERATES NORMALLY. ) RESCURED L1 DOOR GIRT BAR CDLIP IAW AMM 25-66-01 THIS CLEARS MDDR#134608 PLACARDES REMOVEDSDR REXA2025121201015Diaphragm · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH (FS 797.00 AND LBL & RBL 34) MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH (FS 797.00 AND LBL & RBL 34) WERE REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01SDR REXA2025121201009Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00. CRACK ON ELECTRICAL BAY FLOOR WEB RIGHT SIDE (BELOW ADG SUPPORT DOUBLER) FS193.00. WAS REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01SDR REXA2025121201008Diaphragm · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND LBL & RBL 34) MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND LBL & RBL 34) WERE REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01SDR EXFA2025FA0000730Warning Message · false activationUPON REDUCING POWER FOR DESCENT FLIGHT CREW NOTICED HYDRAULIC LOW PRESSURE LIGHTS ON. COULD NOT DUPLICATE ON THE GROUND.SDR SWAA2025120126136Skin · crackedCRACK LEADING EDGE LOCATED SLAT 2 LOWER SURFACE AROUND ACTUATOR RIB AT LT WING. PERFORMED PERMANENT REPAIR ON LEADING EDGE LOCATED SLAT 2 LOWER SURFACE AROUND ACTUATOR RIB AT LT WING IAW SRM 57-42, 01-2R-8, REPAIR 8, PARAGRAPH 4, ALTERNATIVE 1.SDR SWAA2025112626183Support Angle · crackedCRACK ON CARGO LINER SUPPORT ANGLE LOCATED BS 727B LBL49 AT AFT CARGO COMPARTMENT. PERFORMED PERMANENT REPAIR LOCATED ON CARGO LINER SUPPORT ANGLE LOCATED BS 727B LBL49 AT AFT CARGO COMPARTMENT IAW SRM 51-70-11-2R-0.SDR SWAA2025112026188Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 LBL44 WL 208.1 AT AFT GALLEY AREA. PERFORMED PERMANENT REPAIR PART STRAP, ANGLE AND FILLER ON FLOORBEAM LOCATED BS 986.5, LBL 44, WL 208.1 AT AFT GALLEY AREA IAW SRM 51-40-02, AND SRM 53-70-51-2R-6, REPAIR 6.SDR ASAA2025102062320Angle · corrodedAPU COMPARTMENT LT SIDE HAS CORROSION ON OUTER SIDE. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW BOEING SRM 53-80-13-1A-2. REMVOE & REPLACED ANGLE IAW BOEING SRM 51-40-02-0G-0. W= .850" O= .063 R= .017 L= 48.0" D= .046.SDR ASAA2025102062318Shield · corrodedAFT CARGO FWD SHIELD CORRODED STA 787 TO 767. GROUNDED - YES. REMOVED DAMAGE WITH SURFACE BLEND FOUND TO BE OUT OF LIMITS REMOVED AND REPLACED AFT CARGO FWD SHIELD I.A.W. B737-900 SRM 51-40-02-0G-0. W= 1 O= .050 R= .035 L= 1 D=.015.SDR ASAA2025102062317Transition Panel · corrodedAFT CARGO LT TRANSITION CORRODED STA 827 TO 727A. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 FROM STA 827 TO 727A FABRICATED, LOCATED AND INSTALLED DRILLED NEW TRANSITION PANEL IAW SRM 53-00-53-2R-5 FROM STA 827 TO 727A. W=SDR ASAA2025102062316Transition Panel · corrodedAFT CARGO LT TRANSITION CORRODED STA 827 TO 727A. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 FROM STA 827 TO 727A FABRICATED, LOCATED AND INSTALLED DRILLED NEW TRANSITION PANEL IAW SRM 53-00-53-2R-5 FROM STA 827 TO 727A. W=SDR ASAA2025102062315Cargo Track · crackedAFT CARGO TRACK CRACKED BS 727I RBL 15. GROUNDED - YES. REPAIRED CARGO TRACK STA 727I IAW SRM 53-00-53-2R-3.SDR ASAA2025102062220Transition Panel · corrodedAFT CARGO R/H TRANSITION CORRODED STA 767 TO 727A GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW B737-900ER SRM 53-00-53-1A-2 FROM STA 827 TO 727A FABRICATED, LOCATED AND INSTALLED DRILLED NEW TRANSITION PANEL IAW B737-900ER SRM 53-00-53-2R-5 FROSDR AALA202511136589Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOORBEAM AT FR 16 AND -Y254. REPLACED THE FLOORBEAM PER SRM 51-42-11.SDR ASAA2025102062222Transition Panel · corrodedAFT CARGO RT TRANSITION PANEL CORRODED BS 767 TO 727A. GROUNDED - YES. REMOVED CORROSION ON THE TRANSITION PANEL AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2, FABRICATED LOCATED, DRILLED AND INSTALLED A NEW TRANSITION PANEL IAW SRM 53-00-53-2R-5. W= 3SDR ASAA2025102062221Transition Panel · corrodedAFT CARGO RT TRANSITION PANEL CORRODED BS 767 - 727A. GROUNDED - YES. REMOVED CORROSION ON AFT CARGO RT TRANSITION PANEL AT STA 727A - 767. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 FABRICATED LOCATED, DRILLED & INSTALLED A NEW RT TRANSITION PANEL IAW SSDR JJBA20251112038Structure · crackedZONE 500 RACK, AFT CARGO DOOR INTERNAL AFT LOWER CORNER HAS A CRACK. REPAIRED CRACK ON AFT CARGO DOOR INTERNAL AFT LOWER CORNER BY CUTTING OUT CRACKED AREA AND INSTALLING A DOUBLER AND FILLER.SDR JJBA20251112029Winglet · corrodedUPON REMOVAL OF TOP STATIC DISCHARGER BASE ON LH WINGLET FOUND CORROSION AND MATERIAL MISSING. REMOVED AND REPLACED WINGLET ON RACK.SDR SWAA2025111025803Angle · crackedCRACK ANGLE TRAILING EDGE ORSS 271 AT RT WING. REPLACED ANGLE TRAILING EDGE ORSS 271 AT RT WING IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 115A2930 SHEET 8 REV -.SDR SWAA2025111026076Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE ORSS 261 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE ORSS 261 AT LT WING IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 115A2001 SHEET: 29 REV-.SDR SWAA2025111025799Angle · crackedCRACK ANGLE TRAILING EDGE ORSS 281 AT RT WING. REPLACED ANGLE TRAILING EDGE ORSS 281 AT RT WING IAW SRM 51-40-02 ; SRM 51-10-02 PARAGRAPH 9 AND DWG 115A6200 SHEET:10 REV -.SDR SWI2025F01517Trunnion · damagedDURING REPLACEMENT OF THE LH MLGTRUNNION AN UNDOCUMENTED FREEZE PLUG REPAIR WAS FOUND AT 1-OFF FASTENER LOCATION ON UPPER AFT WING PLANK. (FILED CLOSED)FABRICATED 1 EA. CSK FREEZE PLUG USING 7075-T7351, PO #20153681. REF. REO 601R-57-21-3981 REV --(P1) DATED SDR FXTA2025111000001Transducer · failedON TAKE OFF RIGHT ENGINE LOSS TORQUE INDICATION.