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 SWAA2025120127816Floor Panel · damagedFLOOR PANEL 242XF IS SOFT IN THE MIDDLE OF PANEL.<[01] FLOOR PANEL 242XF WITH SOFT AREA IN THE MIDDLE OF PANEL WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF DAMAGE.;[02] VERIFIED CORRECTIVE ACTION 1.SDR HNAA2025120100844Support Bracket · crackedBRACKET SUPPORT CRACKED AT FRAME 68 BETWEEN STRINGERS 15-16L . R & R SUPPORT BRACKET IAW SRM 51-40-02.SDR HNAA2025120100843Shear Tie · crackedSHEAR CLIP CRACKED AT FRAME 61 BETWEEN STRINGERS 6 & 7R. R & R SHEAR CLIP IAW SRM 51-40-02.SDR CALA2025120111601Angle · corrodedFWD CARGO COMPARTMENT LOWER CENTER BULKHEAD ANGLE SUPPORT STA 500L POSSIBLE CORROSION. REMOVED AND REPLACED ANGLE SUPPORT AT FWD CARGO COMPARTMENT LOWER CENTER STA 500L ALL WORK DONE IAW 51-40-02-0G-0 STEP 4 AND 7, SRM-51-40-05-0G-0 STEP4 AND SRM 51-40-08-0G-SDR VGCA20251024009Skin Panel · damagedR/H HORIZONTAL STABILIZER UPPER T/E DAMAGED PANEL 65-20659-24 BETWEEN ELEV. STA. 99.79 AND 173.21SDR VGCA20251024020Frame · puncturedFUSELAGE FRAME INNER CHORD SCREW DAMAGE AT BS 1110 BETWEEN STRINGER 25R AND 28R.SDR VGCA20251024019Frame · puncturedFUSELAGE FRAME INNER CHORD SCREW DAMAGE AT BS 1090 BETWEEN STRINGER 26R AND 28RSDR VGCA20251024018Frame · dentedFUSELAGE FRAME INNER CHORD DENT AT BS 1070 BETWEEN STRINGER 25R AND 29RSDR VGCA20251024017Frame · dentedFUSELAGE FRAME INNER CHORD DENT AT BS 1050 BETWEEN STRINGER 26R AND 28RSDR VGCA20251024016Floorbeam · corrodedFUSELAGE FLOOR STABILIZER BEAM MULTIPLE SPOTS CORROSION AT BL 0 BETWEEN BS 449.94 AND BS 720+9.94SDR VGCA20251024015Frame · gougedFUSELAGE FRAME INNER CHORD GOUGED AT BS 1130 BETWEEN STRINGER 26L AND 28LSDR VGCA20251024014Frame · gougedFUSELAGE FRAME INNER CHORD GOUGED AT BS 1110 BETWEEN STRINGER 26L AND 28LSDR VGCA20251024013Frame · puncturedFUSELAGE FRAME INNER CHORD PUNCTURED AT BS 1090 BETWEEN STRINGER 26L AND 28LSDR VGCA20251024012Skin · dentedFUSELAGE SKIN GOUGE/DENT REPAIRED BELOW MCD BETWEEN BS 460 AND BS 620, AND BETWEEN STRINGER 15L-20LSDR VGCA20251024011Frame · puncturedFUSELAGE FRAME INNER CHORD PUNCTURED AT BS 1070 BETWEEN STRINGER 26L AND 29LSDR VGCA20251024010Shear Tie · corrodedFUSELAGE FRAME BOTTOM CHORD CORROSION DAMAGE AT BS 970 BETWEEN STRINGER 28R AND 29R.SDR VGC2025F00000Frame · corrodedFUSELAGE FRAME BOTTOM CHORD CORROSION DAMAGE AT BS 970 BETWEEN STRINGER 28R AND 29RSDR VGCA202511254009Skin Panel · damagedR/H HORIZONTAL STABILIZER UPPER T/E DAMAGED PANELS 65-20659-24 BETWEEN ELEV. STA. 99.79 AND 173.21 REPAIRED AND INSTALLED I.A.W. V1 AEROSPACE DOC. NO. R24-02464-001, REVISION 6 ,DATE OCTOBER 03.2025SDR VGCA202511254008Skin Panel · damagedRIGHT HORIZONTAL STABILIZER UPPER T/E DAMAGED PANELS 65-20658-24 BETWEEN ELEV. STA. 99.79 AND 173.21 REPAIRED AND INSTALLED IAW. R24-02464-001, REVISION 6 ,DATE OCTOBER 03.2025.SDR VGCA20251024007Beam · corrodedR/H SIDE H-STAB. TRAILING EDGE BEAM UPPER SURFACE CORROSION REPAIRED BY REPLACEMENT OF R/H TRAILING EDGE UPPER BEAM ENTIRE LENGTH BETWEEN ELEVATOR STATION 10 AND ELEVATOR STATION 209.90 I.A.W BOEING DRAWING 65-22987, SHEET 5, REVISION C.SDR VGCA20251024006Floorbeam · corrodedFUSELAGE TRANSVERSE FLOOR BEAM UPPER FLANGE CORROSION DAMAGE AT BS 740 BETWEEN LBL 45 AND LBL 62SDR VGCA20251024005Frame · dentedFUSELAGE FRAME INNER CHORD DENTED AT BS 1050 BETWEEN STRINGER 25L AND 28LSDR VGCA20251024004Frame · crackedFUSELAGE FRAME INNER CHORD CRACK AT BS 660 BETWEEN STRINGER 27L AND 27RSDR VGCA20251024003Frame · crackedFUSELAGE FRAME INNER CHORD CRACK AT BS 640 BETWEEN STRINGER 28L AND 27RSDR VGCA20251024002Frame · dentedFUSELAGE FRAME INNER CHORD DENT AT BS 1148 BETWEEN STRINGER 25R AND 28RSDR VGCA20251024001Frame · dentedFUSELAGE FRAME INNER CHORD DENTS AT BS 1130 BETWEEN STRINGER 24R AND 28RSDR HNAA2025112500826Skin · chafedBAGGAGE DOOR INNER SKIN IS CHAFED 2 PLACES AT PREVIOUSLY BLENDED AREA AT HB3 AND VB2. RAR BAGGAGE DOOR INNER SKIN IAW EMB 145 SRM 51-40-02SDR HNAA2025112500825Profile · corrodedBAGGAGE DOOR LOWER INBOARD PROFILE HAS CORROSION AROUND NUTPLATES. RAR BAGGAGE DOOR LOWER INBOARD PROFILE IAW EMB 145 SRM 51-40-02SDR HNAA2025112500824Skin · crackedFUSELAGE EXTERNAL SKIN HAS POSSIBLE CRACKS AT RIVET ON FR 77 BETWEEN STR 6R/7R. INSTALLED SKIN BUSHING FOR REPAIR OF FUSELAGE EXTERNAL SKIN AT RIVET ON FR 77 BETWEEN STR 6R/7R IAW EMB145 SRM 53-32-01RE, ITEM 9, FIG 213. AND EO1-53-25-0426SDR HNAA2025112500823Drag Angle · crackedVERTICAL STABILIZER LH FWD DRAG ANGLE CRACKED. REMOVED AND REPLACED CRACKED VERTICAL STABILIZER LH FWD DRAG ANGLE IAW EMB145 SRM 51-40-02 AND INFORMATION CONTAINED IN SRM 53-31-01RE, ITEM 11, FIG 219.SDR SWAA2025112027617Vapor Barrier · crackedCRACK (6) ON VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT. REPAIRED VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112028190Intercostal · crackedCRACKED INTERCOSTAL BTW BS 500A - 500B, STRINGER 26R. REPLACED THE WEB - INTERCOSTAL IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025112028195Nut · deterioratedDETERIORATED CAM NUT ON AFT GALLEY SERVICE DOOR HANDLE. REPLACED CAM NUT IAW AMM 52-41-11-400-801, STEP 3.F (5), ITEM (I) THRU 3.F (5), ITEM (N).SDR SWAA2025112028188Angle · crackedCRACK ON ANGLE AFT FACE BS 500H, STRINGER 26R. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7505, SHEET 139, REV-. MEASUREMENT OF CRACK: L: 0.480 INCH.SDR SWAA2025112028189Angle · crackedCRACK ON ANGLE CLIP FWD FACE, BS 500H, STRINGER 26R. REPLACED THE ANGLE CLIP IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7505 SHEET 139, REV-. MEASUREMENT OF THE CRACK: L: 0.345 INCH.SDR SWAA2025112028193Angle · crackedCRACK ON ANGLE CLIP AFT FACE, BS 400 STRINGER 26L. MEASUREMENT OF CRACK IS L: 0.530 INCHES. REPLACED THE ANGLE CLIP IAW SRM 51-40-02-0G, SRM 51-10-02-0G, PARAGRAPH 9, AND DWG 143A7505 SHEET 137, REV-.SDR SWAA2025112028194Angle · crackedCRACK ON ANGLE CLIP FWD FACE, BS 500H, STRINGER 26L. REPLACED THE ANGLE CLIP IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7505, SHEET 139, REV-. MEASUREMENT OF CRACK IS: L: 1.905 INCH.SDR SWAA2025112028191Angle · crackedCRACK GUSSET ANGLE, BS 500I, STRINGER 21L. REPLACED THE GUSSET ANGLE AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 143A7902, SHEET 256, REV B. REJECTED REPLACEMENT DUE TO BAD AND WRONG SEALANT APPLICATION AROUND GUSSET, APPLIED SEALANT ON GUSSSDR SWAA2025112028187Angle · crackedCRACKED GUSSET ANGLE, BS 500I, STRINGER 19R IN THE FWD CARGO BAY. MEASUREMENT OF THE CRACK IS L: 0.9235 INCHES. . REPLACED GUSSET ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG: 143A7902, SHEETS 256 AND 257, REV B.SDR SWAA2025112028192Angle · crackedCRACK ON THE ANGLE LOCATED AFT FACE BS 500H, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEP 9, SRM 51-40-02, AND DWG 143A7505, SHEET 139, REV-.SDR SWAA2025112028186Access Panel · crackedCRACKED SEAL - BLADE ACCESS PANEL 333AB AT LT HORIZONTAL STABILIZER. REPLACED BLADE LOCATED ACCESS PANEL 333AB AT LT HORIZONTAL STABILIZER IAW SRM 51-40-02.SDR JJBA20251120103Angle · crackedRH OVERWING PANEL #194ER, #2 LOWER ANGLE CRACKED AT YA-1085 (RIB 1A). RH OVERWING PANEL #194ER, #2 LOWER ANGLE REMOVED AND REPLACED.SDR JJBA20251120081Sill Drain · corroded"LH MOP SILL AT FR 26, STR 16L, HAS CORROSION. LH MOP SILL AT FR 24 HAS CORROSION AT FWD END. REMOVED AND REPLACED LH MOP SILL AT FR26SDR JJBA20251120067Floor Support · corrodedLH FLOOR SUPPORT AT FR 20, STR 2L, HAS CORROSION. REMOVED AND REPLACED LH FLOOR SUPPORT AT FR20SDR JJBA20251120066Floor Support · corrodedLH FLOOR GUSSET DOUBLER AT FR 16, STR 4L, HAS CORROSION. REMOVED AND REPLACED LH FLOOR GUSSET DOUBLER AT FR16.SDR SWI2025F01538Beam · corrodedAFT WET AREA L/H BEAM AT FR 87/88 HAS CORROSION (C-CHECK RO 11/18/2025)REMOVED AND REPLACED L/H BEAM AFT WET AREA FR 86/89. REF EMB SRM 51-40-08. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED.SDR SWI2025F01537Beam · corrodedAFT WET AREA R/H BEAM AT FR 87/88 HAS CORROSION (C-CHECK RO 11/18/2025)REMOVED AND REPLACED AFT WET AREA R/H BEAM AT FR 87/88. REF EMB SRM 51-40-08. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED.SDR SWI2025F01536Beam · corrodedAFT SERVICE DOOR FWD AND AFT EVACUATION SLIDE FITTING CUTOUT HAS CORROSION. REMOVED AND REPLACED AFT SERVICE DOOR LOWER THRESHOLD BEAM IAW SRM 51-40-08. REPLACED WITH NEW OEM PART.SDR SWIA2025111900024Crossbeam · corrodedFRAME 87 CROSS BEAM CORRODED IN MULTIPLE AREAS. PERFORMED CUTOUT, FILLER, DOUBLER REPAIR ON FRAME 87 CROSS BEAM REF ETD2025-170-931088 AND SRM 53-00-10/REPAIR03P. NO CHANGE TO WEIGHT AND BALANCE.SDR HNAA2025111900758Shear Tie · cracked53-2140 SHEAR TIE CRACKED AT FRAME 61 BTW STRINGERS 6-7L. R & R SHEAR TIE IAW SRM 51-40-02.