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 SWAA2025120334106Attach Angle · crackedCRACKED ATTACH ANGLE AT FCB BS 500C, FWD SIDE, RBL 25, WL 154. REMOVED AND REPLACED THE ATTACH ANGLE IAW SRM 51-40-02, AND DWG 143A7505, REV D.SDR SWAA2025120334109Attach Angle · crackedCRACKED ATTACH ANGLE AT FCB BS 500B, FWD SIDE, RBL 25, WL 154. REMOVED AND REPLACED THE ATTACH ANGLE IAW SRM 51-40-05, AND DWG 143A7505, REV B.SDR SWAA2025120334110Attach Angle · crackedCRACKED ATTACH ANGLE AT FCB BS 400, LBL 25, WL 154. REMOVED AND REPLACED THE ATTACH ANGLE IAW SRM 51-40-02, & DWG 143A75050012 REV -.SDR SWAA2025120335209Wire · pulledFOUND WIRES W3142-476-20 AND W3142-474-20 PULLED FROM GROUND BLOCK BS 986 LT. TERMINATED WIRES W3142-476-20 AND W3142-474-20 & INSTALLED ON GB3814 IAW SWPM 20-90-15, WDM 33-26-11, & 33-51-14.SDR SWAA2025120334104Support · crackedRIGHT WING TO BODY FORMER SUPPORT CRACKED JUST INBD OF FIXED L/E BS 500D, S19R, ACCESS PANEL 191FR. REMOVED AND REPLACED THE WING TO BODY FORMER SUPPORT IAW SRM 51-40-02, AND DWG: 116A3010 REV -.SDR AALA202512039318Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK BRACKET ANGLE AT BELLY FAIRING AT LEVEL OF BS 1035 RIGHT HAND SIDE AT LOWER FUSELAGE. REPLACED BRACKET ASSEMBLY. PER B777 AMM 28-11-00-300-802 STEP F(8), B777-200 SRM 51-40-02-0G AND DRAWING 112W4301 (SHEET 17) REV A.SDR ASAA2025111162732Floor Panel · damagedCABIN FWD WET AREA FLOOR PANEL 141A5810-767 HAS EDGE DAMAGE & CORRODED INSERTS. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR TO CABIN FWD WET AREA FLOOR PANEL 141A5810-767 IAW SRM 53-00-50-2R-1 & 53-00-50-2R-0.SDR ASAA2025111162731Floor Panel · delaminatedCABIN FLOOR PANEL 144A5810-126 HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR OF CABIN FLOOR PANEL 144A5810-126 DELAMINATION IAW -SRM-53-00-50-2R-1 AND SRM-53-00-50-2R-0.SDR ASAA2025111162730Floor Panel · delaminatedCABIN AFT WET AREA FLOOR PANEL 147A5810-109 HAS DELAMINATION & CORRODED INSERTS. GROUNDED - YES. ACCOMPLISHED PERMANENT CLASS A REPAIR OF DELAMINATED UPPER FACE SHEET AND CORRODED INSERT ON MAIN CABIN AFT WET AREA FLOOR PANEL 147A5810-109 IAW ASA B737-900 SRM SDR ASAA2025111162729Floor Panel · delaminatedCABIN AFT WET AREA FLOOR PANEL 147A5810-445 HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT CLASS A REPAIR OF DELAMINATION ON UPPER FACE SHEET OF MAIN CABIN AFT WET AREA FLOOR PANEL 147A5810-445 IAW SRM 53-00-50-2R-0 AND REPAIR 1.SDR SWAA2025120234036Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE IRSS232 AT RT WING. REPLACED CORRUGATED PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2001, SHEET 29, REV - . CRACK LENGTH: 1.007.SDR SWAA2025120234037Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED TRAILING EDGE ORSS273 INTERNAL AREA AT RT WING. REPLACED SUPPORT BRACKET IAW SRM 51-10-02-0G-0 ITEM 9, SRM 51-40-02, AND DWG 115A2930, SHEET 7, REV -. MEASUREMENT OF CRACK: 0.772.SDR SWAA2025120234038Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT RT WING. REPLACED CORRUGATED PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2714, SHEET 13, REV A. CRACK LENGTH: 0.930.SDR SWAA2025120234039Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE ORSS261 AT RT WING. REPLACED THE CORRUGATED PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2001, SHEET 29, REV - . CRACK LENGTH IS: 0.890.SDR SWAA2025120234034Access Panel · elongatedELONGATED HOLE ACCESS PANEL 661BB TRAILING EDGE RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025120234040Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED TRAILING EDGE ORSS273 EXTERNAL AREA AT RT WING. REPLACED SUPPORT ANGLE LOCATED TRAILING EDGE ORSS273 EXTERNAL AREA AT RT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWAA2025120234042Sill Drain · missingMISSING DOOR CUTOUT DRAIN RETAINER UPPER SILL AT FWD CARGO COMPARTMENT. REPLACED DRAIN RETAINER ON DOOR COUT AUT UPPER SILL AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9. REPLACED DRAIN RETAINER ON DOOR COUT AUT UPPER SILL AT FWD CARGO COMPARTMENT IAW SRSDR SWAA2025120134400Fitting · crackedRIB FITTING IS CRACKED AT STAB BL 281.81 RH SIDE. PERFOMED REPAIR IAW SRM 55-10-90-2R-1-A01330, REPAIR 1.SDR SIMA20251111001Shear Tie · corrodedSHEAR CLIP CORRODED AT FR 87 STR 22L AND 23L. (LEVEL 2 CORROSION). SHEAR CLP CORRODED AT FR 87 STR 22L AND 23L. REMOVED AND REPLACED SHEAR CLIP AT FR 87 BETWEEN STR 22L AND 23L IAW ERJ 175 SRM 51-40-08.SDR AALA202511260523Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 320, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202511266094Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 336, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202511263622Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR ASAA2025111162587Floor Panel · delaminatedCABIN FLOOR PANEL HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR OF CABIN FLOOR PANEL 144A5810-126 DELAMINATION IAW SRM-53-00-50-2R-1 AND SRM-53-00-50-2R-0.SDR ASAA2025111162586Floor Panel · delaminatedCABIN FLOOR PANEL 144A5810-127 HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR OF CABIN FLOOR PANEL 144A5810-127 DELAMINATION IAW SRM-53-00-50-2R-1 AND SRM-53-00-50-2R-0.SDR ASAA2025111162585Floor Panel · delaminatedCABIN FWD WET AREA FLOOR PANEL 141A5810-454 HAS DELAMINATION & CORRODED INSERTS. GROUNDED - YES. ACCOMPLISHED PERMANENT CLASS A REPAIR OF DELAMINATION ON UPPER FACE SHEET AND CORRODED INSERTS ON MAIN CABIN AFT WET AREA FLOOR PANEL 141A5810-454 IAW SRM 53-00-50SDR ASAA2025111162584Floor Panel · delaminatedCABIN AFT WET AREA FLOOR PANEL HAS DELAMINATION. GROUNDED - YES. ACCOMPLISHED PERMANENT CLASS A REPAIR OF DELAMINATED FACE SHEET ON MAIN CABIN AFT WET AREA FLOOR PANEL 147A5810-447 IAW ASA B737-900 SRM 53-00-50-2R-0 AND REPAIR 1.SDR ASAA2025111162583Web · corrodedAFT CARGO PIT THRESHOLD WEB HAS CORROSION. GROUNDED - YES. EVALUATED AFT CARGO THRESHOLD WEB, ORIGINAL THICKNESS .045, REMOVED .024, REMAINING .021, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15-1A-1 REMOVED DAMAGED THRESHOLD WEB IAW SRM 51-40-02 LOCATED AND DRILSDR ASAA2025111162562Transition Panel · corrodedAFT CARGO PIT LT TRANSITION PANEL BS 727 - 847 HAS CORROSION. GROUNDED - YES. REMOVED CORROSION ORIGINAL MATERIAL 0.040, REMOVED 0.040, REMANINING 0.000, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED DAMAGED TRANSITION PANEL, FABRICATED NEW REPAIRSDR ASAA2025111162561Support · corrodedFWD CARGO PIT, AFT BULKHEAD SUPPORT LOWER RAIL STA 500I HAS CORROSION. GROUNDED - YES. EVALUATED ORIG THICK=.071", REMOVED .071, REMAINING .000 100% MAT LOSS FOUND TO BE OUT OF LIMITS IAW SRM 53-30-08-1A-1. REMOVED DAMAGED RAIL, LOCATED & DRILLED NEW RAIL INSSDR ASAA2025111162560Transition Panel · corrodedFWD CARGO PIT RT TRANSITION PANEL STA 500A - STA 500I HAS CORROSION. GROUNDED - YES. REMOVED CORROSION, ORIGINAL THICKNESS IS .040 REMOVED .040, REMAINING THICKNESS .000 FOUND TO BE OUT OF LIMITS DUE TO 100% MATERIAL LOST. IAW SRM 53-00-53-1A-2. REMOVED DAMAGESDR JJBA20251125095Window Frame · corrodedFOUND CORROSION AROUND MULTIPLE SCREW HOLES BY THE RH DV WINDOW FRAME. RECEIVED NEW OUTER FRAME HALF FOR RH DV WINDOW, LOCATED AND DRILLED NEW HALF FOR INSULATION.SDR AALA202511245665Roller Guide · crackedAIRCRAFT IN BASE MAINTENANCE: L2 DOOR FORWARD ENTRY DOOR CENTER GUIDE ROLLER IS CRACKED. REMOVED AND REPLACED L2 DOOR, CENTER GUIDE ROLLER AND ADJUSTMENT VERIFICATION COMPLETED. PER SRM 51-40-02 AND AMM 52-13-00-820.SDR SWIA2025112400011Window · damagedR1 WINDOW HAS A LIGHTNING STRIKE. REMOVED AND REPLACED R1 WINDOW DOUBLER IAW SRM 51-40-08.SDR AALA202511244680Condenser · damagedAIRCRAFT WAS GROUNDED: F/A'S REPORT STRONG ODOR (DIRTY SOCK) STARTING ON DECENT THROUGHOUT REMAINDER OF FLIGHT. MAINTENANCE FOUND LT PACK CONDENSER DAMAGE. REMOVED AND REPLACED L/H PACK CONDENSER IAW AMM 21-52-32.SDR CALA2025112411418Channel · corrodedAFT CARGO COMPARTMENT LT ZEE CHANNEL BTW BS 727 AND BS 727F HA HAS CORROSION NEEDS TO BE REPLACED. REPAIRED AND CLEAN AREA AT LT ZEE CHANNEL AFT CARGO COMPARTMENT BTW BS 727 AND BS 727F IAW SRM 51-40-02-0G-0 AND SRM 53-00-53-2R-6, FIG 203 AND SRM 51-40-02-0GSDR SWAA2025112034118Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231UF HAS FIBERS MISSING AND PULLING LOOSE IN MULTIPLE AREAS ON UPPER SURFACE. REPAIRED PASSENGER CABIN FLOOR PANEL 231 UF UPPER SURFACE IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERAL.SDR SWAA2025112033729Girt Bar · out of adjustAFT ENTRY DOOR SLIDE GIRT BAR CURTAIN CATCHES LOWER THRESHOLD DURING CLOSE. REPOSITIONED GIRT BAR CURTAIN IAW AMM 25-66-01.SDR SWAA2025111934047Filler · missingEGPR DOOR CUTOUT REPAIR FILLER MISSING<[01] FABRICATED AND INSTALLED NEW FILLER FOR EXISTING REPAIR ON EGPR ACCESS DOOR SURROUND DOUBLER LOWER LANDING IAW SRM 53-10-15-2R-4. VERIFIED FABRICATED AND INSTALLED NEW FILLER FOR EXISTING REPAIR ON EGPR ACCESS DOOR SDR AALA202511194351Wire Harness · faultedAIRCRAFT WAS GROUNDED: DURING CRUISE FUEL QUANTITIES INDICATOR BEGAN RAPIDLY DECREASING. REMOVE AND REPLACED OF FQIS WIRE HARNESS. PER AMM 28-41-44-40-801. PANEL LEAK CHECK GOOD, PER AMM 28-11-00-400-801.SDR UIEA2025111001295Tire · failed#8 MLG BLEW OUT TOWER REPORTED SMOKE & TIRE DEBRIS ON RUNWAY. R & R NR 8 MWA IAW AMM 32-45-01 & IPC 32-45-03-02. C/W BLOWN TIRE CHAP 5 INSP IAW AMM 05-51-25. R & R NR 7 MWA IAW AMM 32-45-01. R & R NLG STEERING CYLINDER IAW AMM 32-53-11. OPS CHKD NORMAL. NO SDR AALA202511184680Unknown · odorAIRCRAFT WAS GROUNDED: F/A'S REPORT STRONG ODOR (DIRTY SOCK) STARTING ON DECENT THROUGHOUT REMAINDER OF FLIGHT. (OPEN)SDR SWAA2025111734265Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1669, DID NOT ILLUMINATE. REPLACED POWER SUPPLY BATTERY PACK M1669 ASSOCIATED WITH EMERGENCY LIGHTS AND PERFORMED GOOD TEST PER AMM 33-51-06-960-805. MAINTENANCE COMPLETED.SDR DALA2025111708397Light · inoperativeEMERGENCY ESCAPE PATHWAY LIGHT AT 23HJ INOPERATIVE. DEFER TO MEL 33-50-07A. PLACARD INSTALLED. (LP# 8042309)SDR CALA2025111611224Oil System · leakingFLT DECK CREW REST SMOKE ALARM ACTIVATED DUE TO PACK. ACCOMPLISHED FIM TASK 21-00 TASK 808. WITH APU AIR, RAN LT PACK ONLY, AFTER A MIN SMELLED WET DOG/SOUR MILK ODOR, THEN SAME PREVIOUS SMOKE DETECTED MESSAGES POPPED UP, TURNED OFF LT PACK. USED GROUND CONSDR R61A2025111100492Windshield · crackedFO OUTER WINDSCREEN CRACKED AT FL350. ON GOING VISIBLE ELECTRICITY FLOWING AROUND CRACKS. WINDSHIELD OVERHEAT EICAS MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED R/H COCKPIT WINDSHIELD.SDR SWIA2025111400001Windshield · arcedCA SIDE OUTER WINDSCREEN ARCING THEN SHATTERED WHEN WINDSHIELD HEAT WAS TURNED OFF (FLIGHT 4908 - FILED CLOSED) REPLACED CA SIDE WINDOW IN REF TO AMM 56-12-01-400-801, SEE ATTACHED TASK CARD 56-220-1000-SKY. WINDOW HEAT AND PRESSURIZATION CHECK GOOD.SDR CALA2025111411216Inlet Door · corroded(SDR)(B757-MP-2000-53-1-0026) THROUGH ACCESS PANEL 311AL APU INL ET DOOR LOWER STRAP BETWEEN 1787 TO 1825 WITH EXFOLIATION DOT 07 -024. REF NR 134577. SFR REPORTING ONLY FABRICATED APU INLET DOOR STRAP IAW SRM 53-80-15-2R. REPLACED NE W INLET DOOR APU STRAP IASDR CALA2025111411214Skin · debondedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, UPPER SKIN DEBONDED AREAS NOTED, AREA NR 1 L=1.25 INCH W=1 INCH, AREA NR 2 L=1 INCH W=1 INCH.. CLEANED, PREPPED, PERFORMED THE PERMANENT REPAIR AND RESTORED FINISHED ON RT WING OTBD AFT FLAP UPPER SKIN IAW SRM 57-53SDR CALA2025111411212Attach Angle · crackedVAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT STATION 663 LT SIDE AT APPROXIMATELY LBL 9.0. REPAIRED VAPOR BARRIER UPPER ATTACH ANGLE AT STATION 663 AND LBL 9.0 IAW SRM 57-10-10-2R-5.SDR ASAA2025111162280Guide Arm · out of adjustL1 DOOR WILL NOT CLOSE. GROUNDED - YES. FOUND GUIDE ARM OUT OF ADJUSTMENT. ADJUSTED GUIDE ARM. UPPER FWD CRANK FOUND CONTACTING RECEIVER REF LOG PAGE 61181938 FOR GOUGED CRANK. CLEARANCE CHECK GOOD AND OPS CHECK GOOD. REF AMM 52-11-00-820-801.