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 VNAA202601170007Diaphragm · corrodedCORROSION ON DIAPHRAGM FAIRINGS IN STA FS 797.00 AND RBL/LBL 34 AT RH/LH MLG WHEEL WELL. DIAPHRAGM FAIRINGS IN STA FS 797.00 AND RBL/LBL 34 AT RH/LH MLG WHEEL WELL WERE EVALUATE FOUND TO EXCESSIVE DAMAGE PER CRJ900 SRM 51-10-06-001-001-A01 AND REPLACED PER CSDR VNAA202601170005Support · corrodedCORROSION ON MLG HYDRAULIC LINES SUPPORT PLATES (IN BK, LG EXT, LG RET) AND ON CONNECTORS SUPPORT PLATE (PX33, PX17, PX34, PX19) AT RH/LH WHEEL WELL AREA. MLG HYDRAULIC LINES SUPPORT PLATES (IN BK, LG EXT, LG RET) AND ON CONNECTORS SUPPORT PLATE (PX33, PX17,SDR AALA202601145241Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO R1 ENTRY WAY SILL CHORD (CREASE ANGLE) LOCATED FROM BS 294.5 TO BS 328 AT RBL 57. REPLACED CHORD PER AARD 51-00-05-1.SDR YENA2025111001097Gcu · faultedFLT 1591, JFK-LIR. (ETOPS) CLASS II MAINTENANCE AC GEN ( CLASS II MX MSG - GPCU OR AC GEN ); REMOVED AND REPLACED NR 2 GCU IAW AMM 24-22-34. OPS CHK GOOD NO FAULT MSG PRESENT AT THIS TIME MX-4 UPDATED PLAC REMOVED.SDR SWI2026F00065Floorbeam · cracked2EA.( OUTBOARD AND INBOARD) ANGLES ATTACHING RBL9 FLOOR BEAM TO F.S.280 CROSSBEAM IS CRACKED IN THE UPPER RADIUS. (C-CHECK RO 01/09/2026)REPLACED 2 EACH ANGLES AT FS 280 RBL 9 FLOORBEAM TO CROSSBEAM IAW CRJ 200 SRM 51-42-21SDR SWI2026F00064Floorbeam · crackedANGLE IS CRACKED IN RADIUS ATTACHING OUTBOARD SIDE OF LBL9 FLOOR BEAM TO F.S.280 CROSSBEAM. REMOVED AND REPLACED CRACKED ANGLES (2 EACH), PN 601R31113-57, ON INBD SIDE OF LBL9 IAW CRJ200 SRM 51-42-21 AND 51-40-11. COMPLETED TASK CARD 51-9000-1003-SKY AND ATSDR SWI2026F00063Floorbeam · corrodedF.S.280 J ANGLE IS CORRODED BETWEEN LBL11 AND RBL11 REMOVED AND REPLACED FS280 J ANGLE BETWEEN LBL11 AND RBL 11 IAW CRJ 200 51-42-06,51-42-13, AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE REFERENCE CONTISDR SWI2026F00062Angle · corrodedPASSENGER DOOR FLOOR SILL ANGLE IS CORRODED BETWEEN F.S,310 TO F.S.349. REMOVED AND REPLACED PAX DOOR SILL ATTACH ANGLE IAW CRJ 200 SRM 51-42-02, 51-42-06, 51-42-13, 51-42-21, AND51-45-00SDR SWIA202601120008Frame Splice · corrodedFS 559+112 FRAME SPLICE HAS CORROSION BETWEEN STGR 26R AND 26L REMOVED AND REPLACED FS 559+112 FRAME SPLICE ANGLE P/N 60132217-9 BETWEEN STGR 26R AND 26L IAW CRJ 200 SRM 51-42-06 AND 51-40-11 AND SKY CARD 51-900-1003-SKY. ATTACHED COMPLETED FORM 337. NO WEISDR AALA202512228736Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202512167833Shear 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 SWAA2025121533028Keelbeam · crackedCRACKED KEELBEAM, BS 727 - 727A, S27R, REPAIRED THE KEELBEAM IAW EA 25-153-03151-WIP1, EA 25-153-03151, & SRM 53-60-12-2R-1, REPAIR 1.SDR SWAA2025121533027Support · corrodedCORROSION UPPER MAIN SILL LOCATED BETWEEN BS 794.3 - 847, S18R, WL 200 IN THE CARGO BAY. REPLACED UPPER MAIN SILL IAW SRM 51-40-02-0G-0, DWG 146A8110, SHEET 25, REV A, & DWG 146A8111, SHEET 16, REV -.SDR SWAA2025121546411Stub Frame · crackedCRACK ON LOWER STUB FRAME LOCATED BS 294.5, S17R IN FWD GALLEY AREA. REPLACED LOWER STUB FRAME IAW SRM 51-10-02, ITEM 9, & DWG 141A8370, SHEET 10, REV D.SDR SWAA2025121533026Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 277, STR 10R IN PASSENGER CABIN. REPLACED TIE CLIP IAW SRM 51-10-02-0G-0, STEP 9, SRM 51-40-02-0G-0, AND DWG 141A1110, SHEET 18, REV -.SDR SWAA2025121533025Stub Frame · crackedCRACKED LOWER STUB FRAME, BS 294.5, S17R IN THE FWD GALLEY AREA. REPLACED THE LOWER STUB FRAME IAW SRM 51-10-02, ITEM 9, & DWG 141A8370, SHEET 10, REV D.SDR SWAA2025121233029Support · corrodedCORRODED SUPPORT ZEE, BS 727E - 767, RBL 22, WL 156, IN THE CARGO BAY. REPLACED THE SUPPORT ZEE & FASTENERS IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, & DWG 146A7500, SHEET 13, REV-,SDR SWAA2025121233031Web · corrodedCORRODED SHIELD WEB BETWEEN BS 767 - 794.3, RBL 22, WL 156 IN THE AFT CARGO BAY. REPLACED THE SHIELD WEB & FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 146A0081, SHEET 37, REV-.SDR SWAA2025121233205Strap · corrodedCORRODED STRAP FLOOR SUPPORT LOCATED BETWEEN BS 787 - 794.3, RBL 20, WL 156 IN THE AFT CARGO BAY. TASK CARD WAS DUPLICATED; FOR RESOLUTION SEE TTG8Q018SGUS.SDR SWAA2025121233030Support · corrodedCORRODED SUPPORT ZEE, LOCATED BETWEEN BS 727C - 787, LBL 22, WL156 IN THE AFT CARGO BAY. REPAIRED THE SUPPORT ZEE BS 727 - 847, LBL 22, WL156 IAW SRM 53-00-53-2R-5, REPAIR 5, SRM 51-10-02, ITEM 9, DWG 146A7500, SHEET 113, REV -, & DWG: 146A7502, SHEET 27,SDR SWAA2025121033217Plate · crackedCRACKED CORRUGATED PLATE LOCATED TRAILING EDGE IRSS 216 AT LT WING. MEASUREMENT OF CRACK: L 0.800 INCHES. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE IRSS 216 AT LT WING IAW SRM 51-40-02-0G, SRM 51-10-02-0G, PARAGRAPH 9, AND DWG 115A2713, SHEET 4, REV-.SDR SWAA2025121033218Plate · crackedCRACK CORRUGATED PLATE ON TRAILING EDGE IRSS 216 AT RT WING. REPLACED CORRUGATED PLATE ON TRAILING EDGE IRSS 216, RT WING IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, AND DWG 115A2781, SHEET 2, REV B.SDR SWAA2025121033219Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED TRAILING EDGE IRSS139 RT WING. MEASURE OF CRACK SUPPORT BRACKET IS L:1.664 INCHES, AND NOT FOUND ALLOWABLE DAMAGE, SRM 57-51-02-1A-1. SUPPORT BRACKET MUST BE REPLACED. REPLACED SUPPORT BRACKET LOCATED TRAILING EDGE IRSS 139 RT WSDR VNAA20251204008Hinge Fitting · corrodedCORROSION AND SCRATCHS ON BORE OF LUGS L1, L2, L5 AT CENTER HINGE FITTING LT AILERON.SDR VNAA20251204006Fitting · corrodedCORROSION FLOOR FITTING ON ACCESS 305 (2EA´S) ON WARDROBE. FLOOR FITTING ON ACCESS 305 (2EA´S) ON WARDROBE WAS REMOVED PER CMM 25-33-30SDR VNAA20251204004Fitting · corrodedCORROSION FLOOR FITTING BEHIND ACCESS 108 (1EA) AND (1EA) IN FRONT ACCESS 107 ON GALLEY 1. FLOOR FITTINGS BEHIND ACCESS 108 (1EA) AND IN FRONT ACCESS 107 (1EA) ON GALLEY 1 WERE REPLACED PER SAFRAN CMM 25-33-96SDR SWAA2025120332952Sidewall Support · corrodedAFT CARGO BAY CORROSION ON LT FLOOR TO SIDEWALL SUPPORT AT FASTENER HOLES; BS 727 - 847. REMOVED AND REPLACED SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0 AND DWG 146A7500 REV A.SDR SWAA2025120332951Sidewall Support · corrodedAFT CARGO BAY CORROSION ON RT FLOOR TO SIDEWALL SUPPORT AT FASTENER HOLES, BS 767 - 787. REMOVED AND REPLACED AFT CARGO BAY RT FLOOR TO SIDEWALL IAW SRM 51-40-02 AND DWG 146A0081 REV A.SDR SWAA2025120332954Sidewall Support · corrodedAFT CARGO BAY CORROSION AT FASTENER HOLES ON R/H FLOOR TO SIDEWALL SUPPORT BS 727-767. REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0 AND DWG 146A7500 REV A.SDR AALA202512035003Slider · crackedAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER LOWER SLIDER CRACKED AT UPPER CORNERS LEFT HAND. REMOVED AND REPLACED LEFT HAND LOWER SLIDER. PER AARD 51-00-05-1SDR AALA202512038349Slider · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER UPPER SLIDER ROD ATTACH POINTS WORN LEFT HAND. REPLACED UPPER SLIDER ROD. PER AARD 51-00-05-1.SDR AALA202512032731Rod · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER LOWER SLIDER ROD ATTACH POINTS WORN LEFT HAND. REPLACED SLIDER ROD. PER AARD 51-00-05-1.SDR AALA202512037805Slider · wornAIRCRAFT IN BASE MAINTENANCE: HORIZONTAL STABILIZER UPPER SLIDER WORN AT ROD ATTACH POINTS ON RIGHT HAND. REMOVED AND REPLACED RIGHT HAND UPPER SLIDER. PER AARD 51-00-05-1.SDR AALA202512032518Door 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 SWAA2025120233318Glowstrip · deterioratedDETERIORATED PHOTOLUMINESCENT STRIP AT PASSENGER CABIN (10EA). REPLACED PHOTOLUMINESCENT STRIP IAW AMM 33-51-15-400-802.SDR AALA202512025888Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23L. REPLACED LOWER SILL PER SRM 51-42-11.SDR AALA202512021851Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23L. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR AALA202512029322Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23R. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR AALA202512028233Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING AT FR 67 AND S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202512026178Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500G TO BS 500H. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202512021106Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500F TO BS 500G. REPLACED BAFFLE PER AARD 51-00-05-1SDR SWAA2025112033159Bracket · crackedL/H WING: PANEL 551FB DUAL NUT PLATE BRACKET IS CRACKED. BRACKET IS ON THE FWD EDGE OF PANEL; JUST INBD OF THE GREEN TEE ANGLE. REMOVED AND REPLACED PANEL 551FB DUAL NUT PLATE BRACKET IAW SRM 51-40-02.SDR AALA202511190644Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK DIFFICULT TO OPERATE. CONFIRMED AFT LAVATORY DOOR INOPERATIVE, WILL NEED A NEW DOOR. REMOVED AND REPLACED LAVATORY-D BI-FOLD DOOR. PER CMM 25-40-64.SDR AALA202511170804Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR IPXA2025111372654Skin · gougedWHILE GIVING OK TO INSTALL RT VERTICAL ROOT PANEL 323AR, FOUND GOUGE ON FUSELAGE UNDER PANEL, ACCOMPLISH REPAIR IN ACCORDANCE WITH EO-95674-REQ1 AND VT-MAE EA 300-5319-27-A4225 REV IR.SDR DALA2025111308332Proximity Sensor · dirtyAFT RIGHT ENTRY DOOR GIRT BAR ENGAGEMENT LIGHT INOPERATIVE. CLEANED GIRT BAR PROX SWITCHES AND ADJUSTED SWITCHES IAW AMM 25-66. OPS CHECK OF GIRT BAR ARM LIGHT GOOD. (7581548)SDR SWAA2025111233323Fuse · inoperativeRIGHT OVERWING EMERGENCY LIGHT EXTERNAL INOPERATIVE. REPLACED FUSE ON POWER SUPPLY ASSOCIATED WITH BATTERY M1671 AND PERFORMED GOOD. LIGHT TESTED IAW AMM 33-51-06-960-801.SDR SWAA2025111233322Battery Pack · inoperativeAFT R/H OVERWING EMERGECY LIGHT INOPERATIVE. REPLACED FUSE ON POWER SUPPLY ASSOCIATED WITH BATTERY M1671 AND PERFORMED GOOD AFT RT OVERWING EMERGECY LIGHT L1358 TEST IAW AMM 33-51-06-960-801.SDR SWAA2025111234401Engine · abnormalNR 2 ENGINE GREATELY LAGS #1 ENGINE IN SPOOL UP CAUSING YAW WHEN USING REVERSE IN LANDING. PERFORMED ACCEL CHECK TEST 8 IAW AMM 73-21-00 OPS CHECK GOOD .PERFORMED THRUST LEVER ADJUSTMENT THRUST REVERSER POSITION ADJUSTMENT TEST IAW AMM 73-21-00-700-806-F00. SDR DALA2025111208307Bottle · leakingTHE R1 DOOR RESERVOIR DOOR ASSIST BOTTLE LEAKED OUT WHILE TRYING TO PUT SAFETY PIN IN. REMOVED R1 DOOR ASSIST RESIVOIR BATTLE AND REPLACED IAW A350 AMM 52-11. RII COMPLETE QC5431. A/C OK FOR SVC. (LP# 7161405)