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 REXA2026052800826Support Plate · corroded"CORROSION ON HYDRAULIC SUPPORT PLATES(2E/A) ALSO CORROSION ON SEVERAL WASHERS AT 40 RBL/LBL IN THE WHEEL WELL AREA. CORROSION ON HYDRAULIC SUPPORT PLATES(2E/A AT 40 RBL/LBL IN THE WHEEL WELL AREA WAS REMOVED AND EVALUATED IN LH SUPPORT ORIGINAL THICKNESS IS: SDR SWIA202512010001Hinge · chafedAFTER REMOVAL OF THE PAX DOOR NOTED THE PAX DOOR HINGE TO HAVE CHAFES ON ALL LUG LANDINGS. REMOVED DAMAGE AT PAX DOOR HINGE ON ALL LUG LANDINGS IAW SRM 51-12-00-001-001-A01, AND FOUND TO BE WITHIN LIMITS PER SRM 53-21-23-201-010-A01.SDR VNAA202511270009Hinge Fitting · corrodedCORROSION ON FITTING CLOSING FWD AT SURROUND PASSENGER DOOR WAS FOUND. CORROSION ON FITTING CLOSING FWD AT SURROUND PASSENGER DOOR WAS EVALUATED EXCESSIVE DAMAGE PER CRJ-700 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ700 SRM 51-42-06-001-001-A01, SRM 51-42SDR SWAA2025111119879Floor Panel · pulledFLOOR PANEL 241DF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 241DF WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR VNAA20251111004Skin · dentedDENT ON UPPER FORWARD CORE COWL OF RH ENGINE. DENT ON UPPER FORWARD CORE COWL OF RH ENGINE WAS REPAIRED PER REO 690-54-23-515 REV --SDR VNAA20251111003Door · wornWEAR ON ARM GUIDE SEVERAL PLACES ON FWD AND AFT SIDES OF FWD AND MIDDLE BAGGAGE BAY DOORS. ARM GUIDE SEVERAL PLACES ON FWD AND AFT SIDES OF FWD AND MIDDLE BAGGAGE BAY DOORS WAS REPAIRED PER REO 690-52-35-600 REV -- AND PER REO 690-52-35-599 REV. -- AND PER SDR VNAA20251111002Skin · nickedSEVERAL NICKS ON LOWER SKIN OF LH INBOARD FLAP FLS 15.00 TO FLS 65.5 AT LH WING. NICKS ON LOWER SKIN OF LT INBOARD FLAP FLS 48.00 TO FLS 65.5 AT LH WING WERE BLEND OUT PER SRM 51-12-00-001-001-A01 AND EVALUATED WITHIN OF LIMITS PER SRM 57-52-01-101-001-A01 ASDR JJBA20251110018Floorbeam · corrodedSURFACE CORROSION LOCATION: FLOOR BEAM, UNDER PANEL 231HF ZONE 140-142. REMOVED DAMAGED LH FLOOR SILL FROM FR 19-23 AND INSTALLED NEW FLOOR SILL.SDR SWAA2025110719870Floor Panel · pulledFLOOR PANEL 231XF UPPER SKIN HAS AREAS OF PULLED STRANDS. FABRICATED A NEW 231XF FLOOR PANEL. REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938, REPAIR GENERAL.SDR SWAA2025110619878Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 241AF WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025110619871Floor Panel · pulledFLOOR PANEL 232RF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 232RF WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025110619877Floor Panel · pulledFLOOR PANEL 232SF UPPER SKIN HAS AREAS OF PULLED STRANDS. A NEW FLOOR PANEL 232SF WAS FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2025110619876Floor Panel · debondedFLOOR PANEL 231ZF UPPER SKIN HAS LARGE DEBOND NEAR AFT EDGE OF PANEL. FABRICATION OF NEW 231ZF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938.SDR SWAA2025110619872Floor Panel · debondedFLOOR PANEL 241BF UPPER SKIN HAS LARGE DISBOND NEAR CENTER OF PANEL. FABRICATED A NEW 241BF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938, REPAIR GENERAL.SDR SWAA2025110619881Floor Panel · debondedFLOOR PANEL 242AF UPPER SKIN HAS LARGE DISBONDED NEAR CENTER OF PANEL.. FABRICATION OF NEW 242AF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938, REPAIR GENERAL.SDR SWAA2025110520293Nut Plate · crackedCRACK OUTBOARD FRONT SPAR RAIL NUT PLATE OFSS 573 AT LT WING. REPLACED RAIL NUT PLATE LOCATED OUTBOARD FRONT SPAR OFSS 573 AT LT WING IAW B737-800 SRM 51-40-02-0G; SRM 51-10-02-0G-0 ITEM 9 AND DWG 112A4402 SHEET: 41 REV: A. MEASUREMENT OF CRACK IS L: 0.392 ISDR SWAA2025110520295Nut Plate · crackedCRACK OUTBOARD FRONT SPAR RAIL NUT PLATE OFSS 491 AT LT WING. REPLACED RAIL NUT PLATE LOCATED OUTBOARD FRONT SPAR OFSS 491 AT LT WING IAW B737-800 SRM 51-40-02-0G; SRM 51-10-02-0G-0 ITEM 9 AND DWG 112A4402 SHEET: 40 REV: A. MEASUREMENT OF CRACK IS L: 0.254 ISDR SWAA2025110520187Tie Clip · crackedCRACK TIE CLIP FRAME ON BS 277 AND STR10R AT FWD GALLEY AREA. REPLACED TIE CLIP LOCATED ON BS 277 AND STR 10R AT FWD GALLEY AREA. IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 ; DWG: 141A1150 SHEET: 55 REV - .SDR SWAA2025110520296Nut Plate · crackedCRACK OTBD FRONT SPAR RAIL NUT PLATE OFSS 333 AT LT WING. REPLACED THE NUT PLATE LOCATED OTBD FRONT SPAR OFSS 333 IAW SRM 51-40-02-0G; SRM 51-10-02-0G-0, ITEM 9, AND DWG 112A4402 SHEET: 40 REV: A. MEASUREMENT OF CRACK L: 0.232.SDR SWAA2025110520292Nut Plate · crackedCRACK ON RAIL NUT PLATE FRONT SPAR OFSS 604 AT LT WING. REPLACED THE NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 112A4402, SHEET 41, REV A.SDR SWAA2025110520294Nut Plate · crackedCRACK OUTBOARD FRONT SPAR RAIL NUT PLATE OFSS 506 AT LT WING. REPLACED RAIL NUT PLATE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G, & DWG 112A4402, SHEET 40, REV A. MEASUREMENT OF CRACK IS L: 0.168 INCHES.SDR AALA202511058208Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM AT FR 16 AND +Y1292. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR AALA202511059306Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM AT FR16 AND +Y765. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR SWIA2025100401Skin · dentedONE DENTED AREA ON RT TOP FUSELAGE SKIN, DWG 601R33010. AND ONE DEFORMED AREA ON BS 241.60 FRAME. BETWEEN BS 233.276 - 241.60 BETWEEN BL 0.0 - RBL11.16. REF REO 601R-53-11-4021. REPAIRED DENTED AREA ON RT TOP FUSELAGE SKIN IAW REO 601R-53-11-4022, REV-. COSDR HKGA202510041001Fitting · chafedLOSS OF GREEN HYDRAULIC SYSTEM PRESSURE, RESULTING IN EMERGENCY PROCEDURES. EMERGENCY DECLARED AND GEAR WERE EXTENDED AND LOCKED. SMOKE APPEARED IN COCKPIT OF GEAR WAS DOWN AND LOCKED. INSPECTED AIRCRAFT AN FOUND ENGINE DRIVEN PUMP PRESSURE LINE ELBOW FITTING SDR SIMA20251001002Skin · gougedLH WING FIXED LEADING EDGE UPPER SKIN BETWEEN SLATS 3/4 IS GOUGED. (MAJOR REPAIR). RAR LH WING FIXED LEADING EDGE UPPER SKIN BETWEEN SLATS 3/4 IAW ERJ 175 SRM 51-40-08SDR AALA202510319628Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN SEAT TRACK AT FR 20 AND -Y254. REPLACED SEAT TRACK PER SRM 51-42-11.SDR SWAA2025103020341Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 297 AT RT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 297 AT RT WING IAW SRM 51-10-02 ITEM 9 SRM 51-40-02 AND DWG 115A3712 SHEET 7REV A AND DWG 115A3700 SHEET 41 REV - .SDR AALA202510302167Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT WING NO.2 SLAT INBOARD UPPER CORNER CRACKED. MAINTENANCE EVALUATED AND REPAIRED SLAT PER SRM 57-40-00 AND SRM 51-75-12.SDR IPXA2025102734451Floor Support · crackedMAIN CABIN COMPARTMENT BS 880-900, RBL 70, FLOOR SUPPORT CRACKED. ACCOMPLISHED REPAIR IAW EO-95420-REQ1 AND VT-MAE EA 757-5330-27-A4177.SDR SWIA2025102900001Doubler · corrodedWASTE SERVICE DOOR CUTOUT INTERNAL DOUBLER CORRODED AT HINGE POINT AREA (C-CHECK RO 10/28/2025)REMOVED AND REPLACED WASTE SERVICE DOOR CUTOUT INTERNAL DOUBLER, REF EMB SRM 51-40-08SDR SWAA2025102720184Battery Pack · inoperativeLT & RT OVER-WING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACKS M1694 AND M1695 IAW AMM 33-51-06-960-805-NG, OPS TESTED NORMAL.SDR AALA202510260057Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD LOWER LOBE RAIL ASSEMBLY AT BS 5001, RBL 25. INSTALLED REPAIR ANGLE PER SRM 51-40-02 AND EA 368853.SDR SWAA2025102420281Door · crackedRIGHT MLG CENTER DOOR IS CRACKED. RT CENTER DOOR WAS NOT REPLACED; IT WAS REPAIRED AND REINSTALLED AS DOCUMENTED IN STATEMENT 2.SDR SWI2025F01458Flap Track · out of limitsRH AFT FLAP TRACK 2A OB HAS A WIDTH REDUCTION OF 1.4 MM THAT IS OUT OF LIMITS (C-CHECK RO 10/23/2025)REMOVED AND REPLACED RH AFT FLAP TRACK 2A OB. REF AMB 175 AMM 57-54-25. ASSET# TC1-604, CDD 3-6-26. TC2-10241, CDD 3-20-26.SDR SWIA202510240001Flap Track · out of limitsRH FLAP TRACK 2 IB MAIN HAS A WIDTH REDUCTION OF 1.06MM THAT IS OUT OF LIMITS (C-CHECK RO 10/23/2025)REMOVED AND REPLACED RH FLAP TRACK 2 IB MAIN. REF AMB 175 AMM 57-54-23. ASSET# TC1-604, CDD 3-6-26. TC2-10241, CDD 3-20-26.SDR IPXA2025102339051Shear Web · corrodedMAIN CABIN COMPARTMENT STA 1180-1200 RBL 70-75 WEB HAS CORROSION. REMOVED MAIN CABIN COMPARTMENT STA 1180-1200 RBL 70-75 WEB IAW SRM 51-40-02. INSTALLED DOUBLER IAW SRM 51-70-13-0G-0. INSTALLED WEB FROM MAIN CABIN COMPARTMENT BS 1180-1200, RBL 70-75 IAW SRM 5SDR AALA202510232010Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE Z ANGLE AT STA 986 PLUS 6 INCHES, AT LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR SWAA2025102119961Lens · crackedCABIN CEILING COVE PANEL EMERGENCY LIGHT LENS CRACKED 27ABC. REPLACED EAL LIGHT ASSY AT 27ABC PER AMM 33-51-03.SDR SWIA2025102000001Bolt · corrodedFWD PAX DOOR EMERGENCY EVACUATION SLIDE ANCHOR BOLTS CORRODED (C-CHECK RO 10/19/2025)REMOVED AND REPLACED FWD PAX DOOR EMERGENCY EVACUATION SLIDE ANCHOR BOLTS. REF ERJ175 AMM 20-10-01. TW ID# TC1-458, CAL DUE 7-17-26SDR SWAA2025102020310Attach Angle · crackedBS 663 VAPOR BARRIER FOUND ATTACH ANGLE CRACKED AT LBL9. REPAIRED PER SRM 53-10-10-2R-5 REPAIR-5.SDR SWAA2025102020308Attach Angle · crackedBS 663 VAPOR BARRIER FOUND ATTACH ANGLE CRACKED AT RBL 34 APPROX. ATTACH ANGLE CRACKED AT RBL 34 APPROX. WAS REPAIRED BY REPLACEMENT ON TASK CARD TTG8Q015GJUC; IAW SRM 51-10-02-0G-0; PAR 9.SDR SWAA2025102020309Attach Angle · crackedBS 663 VAPOR BARRIER FOUND ATTACH ANGLE CRACKED AT RBL9 APPROX. MARKED<[01] REMOVED AND REPLACED VAPOR BARRIER UPPER ATTACH ANGLE AT BS 663 IAW SRM 51-40-02; DGW: 111A100 ID:0359 REV: - AND DWG:111A1000 ID: 0361 REV: B;[02] VERIFIED COMPLETION CORRECTIVE ACTIOSDR AALA202510201127Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD AT BS 440 RBL 24.5. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510202233Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CHORD) LOCATED AT BS 947, LBL 50. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202510204390Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD FROM BS 498 TO BS 500 PLUS 14 INCHES, AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510200949Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 456 TO BS 491 AT RBL 31. REPLACED WEB PER AARD 51-00-05-1.SDR SWIA2025101700001Shear Tie · mechanic errorDURING STARLINK MOD SHEAR CLIP AT FR 32 STR 1R-2R HAS 4 INCORRECTLY PLACED HOLES IN IT. (C-CHECK RO 10/16/2025)REMOVED AND REPLACED SHEAR CLIP AT FR 32 STR 1R-2R REF: SRM 51-40-08 (P.O# 325561). REPLACED WITH OEM PART NO CHANGE TO WEIGHT AND BALANCE NOTEDSDR IPXA2025100941015Support Angle · corrodedTAIL CONE BELOW APU EXHAUST DUCT, SUPPORT ANGLE HAS CORROSION. REMOVED CORRODED SUPPORT ANGLE AT ZONE.TAIL CONE BELOW APU EXHAUST DUCT IAW B757-200 SRM 51-40-02. ++INSTALLED NEW ANGLE FROM TAIL CONE BELOW APU EXHAUST DUCT, SUPPORT IAW B757-200 SRM 51-40-02-0SDR SIMA20251001001Shear Tie · corrodedSSI 53-10-016 ? FORWARD FUSELAGE SHEAR CLIP AT FR 16 BETWEEN STGR 28L-28R CORRODED (LEVEL 2 CORROSION) REMOVED AND REPLACED SHEAR CLIP ON FORWARD FUSELAGE AT FR 16 BETWEEN STGR 28L / 28R IAW ERJ 170 SRM 51-40-08.