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 HNAA2026012200069Attach Bracket · crackedCARGO DOOR TORSION BAR AFT ATTACHMENT BRACKET IS CRACKED. RAR CARGO DOOR TORSION BAR AFT ATTACHMENT BRACKET IAW EMB 145 SRM 51-40-02 AND EO1-53-26-0028.SDR HNAA2026012200063Shear Tie · crackedPOSSIBLE CRACK ON SHEAR CLIP AT FRAME 67 BETWEEN STRINGERS 6L-7L. R & R THE SHEAR CLIP AT FRAME 67 BETWEEN STRINGERS 6L-7L. IAW SRM 51-40-02.SDR HNAA2026012200062Seat Track · corrodedRIGHT LOWER SEAT TRACK NR 5 HAD CORROSION IN MULTIPLE AREAS. R & R THE SEAT TRACK IAW AMM 53-01-06.SDR HNAA2026012200058Seat Track · corrodedLEFT UPPER SEAT TRACK NR 1 HAS CORROSION IN MULTIPLE AREAS. R & R THE SEAT TRACK IAW AMM 53-01-06.SDR HNAA2026012200057Seat Track · corrodedRIGHT UPPER SEAT TRACK NR 1 HAD CORROSION IN MULTIPLE AREAS. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 53-01-06.SDR HNAA2026012200056Floorbeam · corrodedCABIN LT FLOORBEAM CORRODED AT FRAME 29. REPAIRED CABIN LT FLOORBEAM IAW ETD2026-145-000133, AND PIEDMONT EO1-53-26-0022.SDR HNAA2026012200055Floorbeam · corrodedCABIN LT FLOORBEAM CORRODED AT FRAME 24. REPAIRED CABIN LT FLOORBEAM AT FRAME 24 IAW ETD2025-145-000131 REV.A AND PIEDMONT EO1-53-26-0016SDR HNAA2026012200054Floorbeam · corrodedCABIN LT NR 2 FLOORBEAM GUSSET CORRODED. R & R CABIN LT NR 2 FLOORBEAM GUSSET IAW SRM 51-40-02.SDR HNAA2026012200053Floor Support · corrodedCENTER FLOOR OMEGA BEAM LT INBD FLANGE BETWEEN FR52/54 HAVE CORROSION. BLENDED OUT CORROSION ON CENTER FLOOR OMEGA BEAM LH INBD FLANGE BETWEEN FRM-52/54 IAW EMB 145 SRM 51-10-03, AND THE BLENDED AREA IS ACCEPTED AS IS IAW ETD2025-145-000124 REV: B AND PIEDMONSDR HNAA2026012100051Support · crackedCARGO DOOR LIFTING MECHANISM UPPER SUPPORT CRACKED AT BTW FR 67-68 STR4R. RAR SUPPORT IAW SRM 51-40-02SDR HNAA2026012000016Support · crackedCARGO DOOR LIFTING MECHANISM SUPPORT CRACKED AT BTW FR61-62 BTW STR4-5R. RAR SUPPORT IAW SRM 51-40-02SDR HNAA2026012000013Support · corrodedRIGHT SILL CORRODED AT BTW FR 71-73. R & R SILL IAW SRM 51-40-02SDR 3EJA202601150003Actuator · failedDURING LANDING DROPPED THE LANDING GEAR AND RECEIVED A RED UNLOCK GEAR LIGHT ASSOCIATED WITH A GREEN LEFT MAIN LANDING GEAR LIGHT THAT DID NOT ILLUMINATE.///////R&R LH MLG ACTUATOR.SDR AALA202601150084Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER AT BS 1016, S25L. REPAIRED STRINGER PER EA 370901.SDR AALA202601159323Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER LOCATED FROM BS 827 TO BS 847, AT S26L. RELACED STRINGER SECTION PER SRM 53-00-03-2R.SDR SWAA2026011451387Frame · crackedBS 312 FRAME IS CRACKED IN THE RADIUS JUST ABOVE THE L1 DOOR CUT OUT. REMOVED THE CRACK DAMAGE IAW SRM 51-10-02-0G-0. ACCOMPLISHED REPAIR EA M-22-153-01244.SDR SWAA2026011451696Stringer · crackedLEFT FWD PAX CABIN BS 295.5, STRINGER 7L CRACKED. REPAIRED IAW SRM 53-00-03-2R-1, EA 25-153-03423-WIP1, AND EA 25-153-03423-WIP2.SDR SWAA2026011451681Attach Angle · crackedCRACKED INTERCOSTAL ATTACH ANGLE, BS 400, LBL 25, WL 155. REMOVED AND REPLACED INTERCOSTAL ATTACH ANGLE IAW SRM 51-40-02, & DWG 143A7505-82.SDR SWAA2026011451678Attach Angle · crackedCRACK ON FCB FWD INTERCOSTAL ATTACH ANGLE AT BS 500C, LBL 24, WL 155. REMOVED AND REPLACED FWD CARGO BAY FWD INTERCOSTAL ATTACH ANGLE IAW SRM 51-40-02-0G-0, & DWG 143A7505, SHEETS 81 & 82.SDR SWAA2026011451682Attach Angle · crackedCRACK ON FCB AFT INTERCOSTAL ATTACHMENT ANGLE AT STA 500C, LBL 24, WL 155. REMOVED AND REPLACED FWD CARGO BAY AFT INTERCOSTAL ATTACH ANGLE IAW SRM 51-40-02 AND DWG 143A7505-82.SDR SWAA2026011451688Threshold Web · corrodedCORROSION ON FWD CARGO BAY SUB THRESHOLD WEB AT BS 451 - 485, RBL 28.5, WL 156. REMOVED AND REPLACED THE FWD CARGO BAY SUB-THRESHOLD WEB IAW SRM 51-40-02 AND DWG 143A8330 REV A.SDR SWAA2026011451692Threshold · corrodedCORROSION ON AFT CARGO BAY SUB THRESHOLD WEB AT BS 787 - 847, RBL 26, WL 160. REMOVED AND REPLACED AFT CARGO BAY THRESHOLD WEB IAW SRM 51-40-02 AND DWG 146A8340 REV-.SDR SWAA2026011451683Sidewall Support · corrodedCORROSION ON FWD CARGO BAY LT AFT BODY TO SIDE WALL SUPPORT BS 489 - 500C, LBL 25, WL 156. REMOVED AND REPLACED THE SIDEWALL SUPPORT FROM BS 489 - 500D, LBL 25, WL 156 IAW SRM 51-40-02-0G-0, SRM 53-00-53-2R-5, DWG 143A7501, & 143A7500.SDR SWAA2026011451684Shield · corrodedCORROSION ON FWD CARGO BAY RT AFT BODY TO SIDE WALL SUPPORT BS 510, RBL 25, WL 156, RT AFT SHIELD. REMOVED AND REPLACED THE AFT SHEILD IAW SRM 51-40-02 & DWG 143A0080 REV-.SDR AALA202601144686Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 807, S26L. REPLACED STRINGER CLIP PER AARD 53-00-01-6.SDR SWAA2026011351693Web · corrodedCORROSION ON ACB UPPER WEB AT BS 827, RBL 65, WL 200. R & R ACB UPPER WEB BS 787 - 847 IAW SRM 51-40-02 & DWG 146A0080, REV A, DWG 146A8111, REV -.AND DWG 146A0083.SDR K2AA2026010900001Fuel Filter · bypassingPILOT REPORTED FUEL BYPASS CAS MESSAGE ON LH ENGINE DURING FLIGHT.SDR SWAA2026010551585Plate · crackedCRACK ON CORRUGATED PLATE LOCATED AT LEVEL ORSS 261 TRAILING EDGE RT WING. REPLACED CORRUGATED PLATE LOCATED AT LEVEL ORSS 261 TRAILING EDGE RT WING IAW SRM 51-10-02 ITEM 9; SRM 51-40-02; DRAWING 115A2001; REV-, SHEET 29.SDR SWAA2026010551586Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT . REPAIRED FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT IAW SRM 53-30-15-2R-1 REPAIR 1; PARAGRAPH 4. B; STEPS (2 AND 4 TO 7). REFER TO BAC 5975.SDR SWAA2026010551717Access Panel · crackedCRACK BLADE ACCESS PANEL 343AT AT RT HORIZONTAL STABILIZER. REPLACED BLADE ON ACCESS PANEL 343AT AT RT HORIZONTAL STABILIZER IAW SRM 51-40-02 AND DWG 186A3101 SHEET 13 REV: C.SDR SIMA20251211003Floor Support · corrodedCORROSION AT FWD WET AREA AFT LEFT SILL AT FR 19, Y-43 (MARKED) (MAJOR REPAIR) (LEVEL 2 CORROSION). REMOVED CORROSION ON FWD LEFT SILL FR 19 Y-43 IAW E-175 SRM 51-10-03. ORIGINAL MATERIAL THICKNESS IS 0.196 DRAWING # 171-13958-003 MATERIAL REMOVED IS .010?. LOSDR SIMA20251211002Seat Track · corrodedRH SEAT TRACK IS CORRODED BETWEEN FRAMES FR84 AND FR85 AND Y+276. (MAJOR REPAIR) (LEVEL 2 CORROSION). AFTER BLENDING RH SEAT TRACK BETWEEN FR84 AND FR85 Y+276 PART IS FOUND TO BE OUT OF ALLOWABLE LIMITS IAW E-175 SRM 53-23-10 AD01 PN 170-86081-005. CUT OUT ANDSDR SIMA20251211004Seat Track · corrodedCORROSION AT FWD WET AREA RIGHT TRACK AT FR 16, Y+12 (MARKED). (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED CORROSION AT FWD WET AREA RIGHT TRACK AT FR 16, Y+12 PER EMB-175 SRM 51-10-03. BLENDED AREA MEASURES (L- =1?, W.5?, H=.032?) AND IS FOUND TO BE OUT OF ALSDR SWAA2026010251588Angle · crackedCRACK ANGLE AT ACCESS PANEL 651GB, RT WING. REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, AND DWG 115A2714, SHEET 14, REV-. MEASUREMENT OF CRACK: L= 0.440.SDR JJBA20251226034Nut · corrodedALL FOUR APU COWLING ATTACH SPHERICAL NUTS RUSTED AND BOLTS ALSO. REMOVAL OF RUST WAS PERFORMED.SDR JJBA20251211033Plate · scratchedNOSE LANDING GEAR WELL WALL RH FOUND WITH SCRATCHES ON PLATE. DIGITAL PLATE WAS REPLACED.SDR AALA202512233945Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT RIGHT HAND BS 537. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202512235544Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT LEFT HAND BS 537. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR ASMF202512210288Warning Light · no discrepancyMAINT LIGHT IS ON 31681100. THE FIM 73-21-00 WAS PERFORMED, ALL CORRECTSDR HNAA2025121900862Shear Tie · crackedSHEAR TIE CRACKED AT FR 58 BTW S15-16L. R & R SHEAR TIE IAW SRM 51-40-02.SDR DALA2025121709180Seal · leakingFAINT DIRTY/ MUSTY ODOR DETECTED FOR 5 MIN ON CLIMB THROUGH FL180 DURING WING A/I TEST. STRONGER ODOR DETECTED ON FLIGHT DECK AND GALLEYS FROM 6000FT TO LANDING IN IMC AND RAIN. FOUND OIL IN #1 AND #2 ENG SPINNER REMOVED/ REPLACED BOTH FAN SHAFT SEALS PER PW 1SDR SWAA2025121651520Skin · delaminatedDUE TO NR 2 TIRE TREAD LOSS; LT INBD MAIN FLAP WAS DELAMINATED IN THE COMPOSITE SECTION, CENTERED 8 FROM I/B EDGE & 5 FWD FROM AFT EDGE, APPROXIMATE DAMAGE SIZE IS 9IN BY 8IN. ACCOMPLISHED EA 25-127-03381; REF TSR #20250010028.SDR AALA202512162484Control Panel · shortedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTED ELECTRICAL SMELL IN THE CABIN AFTER LANDING. ACCOMPLISHED JOB CARD 08L00021001 FOR TROUBLESHOOTING. FOUND BURN MARKS AT FORWARD GALLEY ELECTRICAL CONTROL PANEL. REMOVED AND REPLACED GALLEY 2 OVEN ELECTRICAL CONSDR YENA2025121601220Floorbeam · corrodedDURING HEAVY MAINTENANCE: LEFT FLOOR BEAM LOCATED IN FRONTOF THE PAX DOOR L4 FR 67 HAS CORROSION;SDR YENA2025121601219Stringer · corrodedDURING HEAVY MAINTENANCE: CORROSION ON STGR 43LH, FR65. COMPLETED REPAIR ON STGR 43LH BTW FR64 T0 FR645 IAW EA. 136-2025-018 REV IR ROAF # 81669498/003.2025 #A JETBLUE EC# A25-947-01."SDR YENA2025121601218Web · corrodedDURING HEAVY MAINTENANCE: FLOOR STRUCTURE WEB ON LEFT SIDE AT FR18 CORRODED ( FWD TO L1 DOOR); REMOVED AND REPLACED FLOOR STRUCTURE WEB ON L/H SIDE AT FR18 FWD TO L1 DOOR IAW A321 SRM 51-42-11, SRM 51-44-11 AND AIRBUS DWG # D53114419.SDR YENA2025121601217Floor Support · corrodedDURING HEAVY MAINTENANCE: LH FUSELAGE CABIN FLOOR SUPPORT Y765 CORRODED IN SEVERAL PLACES. REMOVED & REPLACED FLOOR SUPPORT AT FR66-FR70 FUSELAGE Y-765 IAW SRM 51-42-11.SDR YENA2025121601216Floor Support · corrodedDURING HEAVY MAINTENANCE: LEFT FUSELAGE FR 68-70 LBL20 CABIN FLOOR SUPPORT UPPER SURFACE CORRODED SEVERAL PLACES. REMOVED AND REPLACED FLOOR SUPPORT Y512.5 FR67 TO FR70 IAW SRM 51-72-11-911-001.SDR YENA2025121601215Floor Support · corrodedDURING HEAVY MAINTENANCE: RIGHT AFT CABIN FR FR 66-70 FLOOR SUPPORT BEAM -Y765 UPPER FASTENER HOLES CORRODED; 643.. REMOVED AND REPLACED FLOOR STRUCTURE BEAM BETWEEN FR66-FR70 -Y765 IAW A321 SRM 51-42-11.SDR YENA2025121601214Web · corrodedDURING HEAVY MAINTENANCE: CABIN FLOOR STRUCTURE FR21 LH WEB UPPER SKIN WITH CORROSION SPOT. REPLACED CABIN FLOOR STRUCTURE FR21 LT WEB IAW SRM 51-42-11 PAR. 2.