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 AALA202507219289Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER SURFACE OF INTERCOSTAL FROM BS 312 TO BS 318 AT S25L. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR SWAA2025071682801Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS 259.5 AND S-8L PASSENGER CABIN. REPLACED SUPPORT ANGLE LOCATED BS 259.5 AND S-8L PASSENGER CABIN IAW B737-700 SRM 51-40-02-0G-0;SRM 51-10-02-0G-0, ITEM 9 AND DWG 141A0720 SHEET 46 REV -.SDR REXA2025071500696Step · crackedCRACK WAS FOUND ON AFT/FWD SIDE PANEL BTW TOP-MIDDLE STEPS AT PASSANGER DOOR IN REFERENCE NRC 114 SUMMARY: AFT/FWD SIDE PANEL BTW TOP-MIDDLE STEPS AT PASSANGER DOOR WAS REPAIRED PER CRJ900 SRM 52-11-04-201-004-A01SDR AALA202507149552Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 940, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2025071182767Access Panel · debondedDEBONDED ACCESS PANEL 193CL AT LOWER FUSELAGE. REPAIRED ACCESS PANEL 193CL AT LOWER FUSELAGE IAW SRM 51-70-05-2R-2 REPAIR 2.SDR ASAA2025061759329Web · corrodedAFT CARGO DOOR CUTOUT HAS CORROSION UNDER SCUFFPLATE AREA ON TOPSIDE. GROUNDED - YES. REMOVED LOWER SILL PLATE, BLENDED AREA. ORIG THICKNESS .056 MAT LOSS .018 NEW THICKNESS .038, AREA OUT OF LIMITS PER B737-900 SRM 53-00-01-1A-6. INSTALLED NEW WEB P# 146A8173SDR IPXA2025070873830Doubler · crackedRIGHT WING LE COVE HAS A CRACKED BEADED DOUBLER AT APPROX XOS=740.8 TO XOS=734.75 49-075. CUT OUT DAMAGED BEADED DOUBLER AT RH WING LE AT APPROX STA XORS 633 IAW MD-11 SRM 57-40-02-2R-15 REPAIR 15 DIMENSIONS CUT OUT 12.25" X 6.2".LOCATED AND DRILLED BEADED DOSDR SIMA20250617001Seat Track · corrodedRH LONGITUDINAL SEAT TRACK AT FR84 -7" AND Y= +10.75 HAS CORROSION (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED RH LONGITUDINAL SEAT TRACK AT FR84 -7" AND Y= +10.75 PER EMB 175 SRM 51-10-03, UPON EVALUATION FOUND AREA TO BE IN A NO DAMAGE ALLOWED AREA AND OUT OSDR SIMA20250617002Seat Track · corrodedLH LATERAL SEAT TRACK FROM FR74-FR84 HAS (5) GOUGES, SOME WITH CORROSION. (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED SEAT TRACK FROM FRS-74-84 PER SRM 51-10-03. MEASUREMENTS FOR THE DEEPEST BLEND IS L=1 W=0.4 D=0.020 DEPTH OF 0.020 IS FOUND TO BE OUT OF LIMISDR IPXA2025070771804Seat Track · crackedMAIN CARGO SEAT TRACK CRACKED AT BOTTOM SIDE VEIWED FROM CENTER CARGO STA 1681 LBL 8.5. FABRICATED 2 EA SEAT TRACK SPLICES REPAIR REF SRM 53-00-52-2R-1.FABRICATED 2EA REPAIR SPLICE PLATES REF SRM 53-00-52-2R-1. INSTALLED EWIS AT MAIN CARGO STA 1681 LBL8.5 RESDR SWAA2025070782676Skin · crackedCRACKED INDICATION LOCATED AT BS 767+12.5 STR 1 CHEM-MILL STEP. REPAIRED PER EA 25-153-01606 WITH AN INSPECTION THRESHOLD DEFINED IN 25-153-01606-DTI.SDR SWIA202507030617Warning Message · illuminatedD:R REV UNLOCKED CAUTION MESSAGE APPEARED TWICE IN FLIGHT AFTER TAKEOFF AND WENT AWAY AFTER A COUPLE SECONDS BOTH TIMESC: MEL 78-30-1CAT C DUE ON 06/27/2025NOTE: DUE TO ODI RTF, SMOD APPROVAL IS REQUIRED BEFORE RTS.R REV UNLOCKED CAUTION MESSAGE APPEARED TWICESDR SWI2025F00852Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 83 STGR 27L/28L. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO FR 83 STRG 27L/28L SHEAR CLIP REF EMB SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00851Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 78 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 78 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00850Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 85 STGR 27L/28L. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 85 STGR 27L/28L REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00849Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 89 STGR 27R/28R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 89 STGR 27R/28R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00848Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 77 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 77 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00847Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 75 STGR 28R/29R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 75 STGR 28R/29R. REF: SRM 51-40-08 REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWI2025F00846Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 82 STGR 27R/28R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 82 STGR 27R/28R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00845Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 76 STGR 27L/28L. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 76 STGR 27L/28L. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00844Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 87 STGR 28R/29R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 87 STGR 28R/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00843Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 74 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 74 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00842Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 86 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 86 STGR 27R/28R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00841Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 82 STGR 25R/26R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 82 STGR 25R/26R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00840Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 84 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 84 STGR 27R/28R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00839Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 76 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 76 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00838Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 84 STGR 28R/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 84 STGR 28R/29R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00837Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 82 STGR 28R/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 82 STGR 28R/29R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00836Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 75 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 75 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00835Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 81 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEAR CLIP FR 81 STGR 27R-28R WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR FUSDR SWI2025F00834Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 78 STGR 28L/29L. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 78 STGR 28L/29L. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00833Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 76 STGR 29R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 76 STGR 29R/28R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00832Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 81 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEAR CLIP FR 81 STGR 29L-29R WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART, NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR FSDR SWI2025F00831Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 83 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO FR 83 STRG 27R/28R SHEAR CLIP REF EMB SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00830Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 81 STGR 28R/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEAR CLIP FR 81 STGR 28R-29R WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART, NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR SDR SWI2025F00829Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 79 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 79 STGR 29L/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-4SDR SWI2025F00828Stringer · corrodedCORROSION AT AFT CARGO STRINGER 29R AROUND RIVETS IN BETWEEN FR 76/77. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED STRINGER 29R FR 74-81 WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART, NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR FURTSDR SWI2025F00827Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 88 STGR 27R/28R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 88 STGR 27R/28R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00826Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 85 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 85 STGR 27R/28R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00825Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 87 STGR 27R/28R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 87 STGR 27R/28R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00824Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 84 STGR 29L/29R. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 84 STGR 29L/29R REF SRM 51-40-08. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED. NO CHANGE TO WEIGHT AND BALANCE.SDR SWI2025F00823Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 76 STGR 28L/29L. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 76 STGR 28L/29L. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00822Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 79 STGR 28L/29L. REMOVED AND REPLACED AFT CARGO SHEAR CLIP FR 79 STGR 28L-29L WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART, NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR FURTHER WORK PERFORMED.SDR SWI2025F00821Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 80 STGR 29L/29R. REMOVED AND REPLACED AFT CARGO SHEAR CLIP FR 80 STGR 29L-29R WITH NEW REF. ERJ175 SRM 51-40-08. REPLACED WITH OEM PART, NO CHANGE IN WEIGTH AND BALANCE. SEE CONTINUATION CARD FOR FURTHER WORK PERFORMED.SDR SWI2025F00820Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 86 STGR 27L/28L. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 86 STGR 27L/28L. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWI2025F00819Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 85 STGR 28R/29R. REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 85 STGR 28R/29R. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR SWIA20250617Shear Tie · corrodedCORROSION AT AFT CARGO SHEARCLIP AT FR 86 STGR 28L/29L. (C-CHECK RO 06/30/2025)REMOVED AND REPLACED AFT CARGO SHEARCLIP AT FR 86 STGR 28L/29L. REPLACED WITH OEM PART. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK PERFORMED REF: SRM 51-40-08SDR DALA2025070204955Structure · departedAFTER LANDING IN MSP THAT THEY SAW A PIECE OF METAL FLY OFF OF THE WING. AFTER INSPECTION ON THE GOUND IN MSP, THE FO FOUND THAT A PIECE OF METAL ON THE UNDERSIDE OF THE LEFT WING FLAP BEHIND THE ENGINE IS MISSING. REMOVED LH OUTBD LOWER FLAP REF 737 AMM 27-51SDR SWAA2025070182544Scuff Plate · crackedFORWARD CARGO BAY FORWARD CORNER SCUFF PLATE IS CRACKED. REMOVED CENTER AND FWD CORNER SCUFF PLATE PER AMM 53-11-02. INSTALLED FORWARD CARGO BAY FWD CORNER AND CENTER SCUFF PLATES PER AMM 53-11-02-420-801.SDR SWAA2025070182537Panel · debondedPANEL 195BL OUTER SKIN IS DISBONDED NEAR THE AFT END OF THE PANEL. PANEL 195BL WITH DISBONDED OUTER SKIN WAS REPAIRED IAW SRM 51-70-05-2R-2.