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 FDEA202509271992Rib · wornDAMAGE NOTED AROUND THE LWR BORE HOLE ON THE OUTBD SIDE OF THE OUTBD JACK RIB AT R6 SPLR ACCOMPLISHED THE REPAIR WITH BUSH, REINFORCING PLATE AND PACKING PLATE AT RH WING #6 SPOILER O/B JACK RIB LOWER BORE SP1X 40.425 I.A.W EA NO: T6-5740-T0385130 P1, SEQ1SDR SWIA2025101300927Door · damagedNOSE GEAR FIXED REAR DOOR IS NOT FULLY SECURED AND IS MAKING CONTACT WITH REAR TORQUE LINK SCISSORS. LOUD THUD FELT AND HEARD WHEN EXTENDING LANDING GEAR ON APPROACH. (FLIGHT 5237) UPON INSPECTION FOUND DAMAGE TO THE AFT NLG DOOR AS WELL AS DAMAGE TO NLG GESDR CALA2025101309942Skin · bulgedFOUND BULDGE IN THE SKIN ALONG WITH PULLED RIVET HEADS ON STRINGER 26L BETWEEN STA 360-380. AFTER FURTHER INSPECTION, FOUND CORROSION BETWEEN STRINGER & SKIN AT THE STRINGER SPLICE. REMOVED STRINGER 26L IAW SRM 51-40-02 & AVO719-25-09-26-01. REMOVED STRINGSDR CALA2025101309941Skin · corrodedSKIN BULGED AROUND RIVETS LWR AFT CORNER OF LAV SERVICE PANEL. REMOVED LOCK FASTENERS ON LOWER AFT AND FWD OF LAV SERVICE PANEL IAW SRM 51-40-02. REMOVED LAV SERVICE PANEL IAW SRM 51-40-02. REMOVED CORROSION ON LOWER AFT CORNER OF LAV SERVICE DOOR CUTOUT ON SDR AALA202510137663Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROOION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT OUTBOARD LAVATORY MOUNT, AT BS 949, RBL 55. REPLACED INTERCOSTAL PER AARD 51-00-05-1SDR AALA202510135633Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (CAP) AT BS 947, LBL 8. REPAIRED FLOOR BEAM CHORD PER SRM 53-00-51-2R-1.SDR IPXA2025100665445Support Bracket · corrodedACCESS DOOR 313AL LH AND RH LATCH STOPS AT THE CUT-OUT 4EA SUPPORT BRACKETS ARE CORRODED. REMOVED 2EA SUPPORTS AND 4 ANGLES IN ACCESS DOOR 313AL I.A.W. B757-200PF SRM 51-40-02-0G.INSTALLED 4 EA SUPPORT BRACKETS IAW SRM 51-40-02.REINSTALLED 2 EA STOP SUPPORTSDR SWAA2025100718627Strip · corrodedFWD CARGO CAP STRIPS HAVE NUMEROUS AREAS OF CORROSION. CLEANED FWD CARGO CAP STRIPS PER AMM 50-10-00. FOUND CORROSION LIMITED TO CAPSTRIP PART# 453A1611-16. PROCURED SERVICEABLE REPLACEMENT CAPSTRIP FROM STOCK. CAPSTRIPS TO BE INSTALLED ON TASK TTG8Q015F392.SDR AALA202510071718Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE CAP LOCATED AT BS 947.5, LBL 24 . REPAIRED UPPER TEE CAP PER SRM 53-70-51-2R-5.SDR DALA2025100707315Elec Connector · not seatedSHIP 1603 SEAT 42A/B EMER. LIGHT IN SEAT INOP. CORRECTIVE ACTION: RESEATED CONNECTOR FOR EMERGENCY LIGHT - OPS OK. (7082319)SDR AALA202510077573Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR CALA2025100609637Web · corrodedAFT CARGO DOOR CUTOUT SURROUND STRUCTURE, NEXT TO THE FORWARD EDGE, FOUND CORROSION ON UPPER SURFACE. REMOVED AND REPLACED AFT CARGO DOOR CUTOUT SURROUND SILL(WEB) STA 807 TO 847 RBL 22 PER SRM 51-40-02-0G-0 AND DWG#146A8120.SDR ASAA2025092761250Seat Track · damagedAFTER FITHER INSPECTION CAPTAIN SEAT TRACK IS DAMAGED (AFT I/B). SRXR430X. GROUNDED - YES. REMOVED AND REPLACED CAPITAN AFT I/B SEAT TRACK IAW IPECO CMM 53-01-02. SRXR430X.SDR SWAA2025100318855Battery Pack · no testEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1675 FAIL TEST. REMOVED AND REPLACED POWER SUPPLY - BATTERY PACK M1675 AND PERFORMED GOOD OPERATIONAL TEST PER AMM 33-51-06-960-805. CLOSE CARD.SDR AALA202510024602Skin · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN SKIN BS 116 AND STR 5-21R. COMPLIED WITH REPAIR, PER SRM 53-80-01-2R REPAIR 5 AND PER AARD 51-40-00-5.SDR AALA202510024399Stop Pad · out of adjustAIRCRAFT IN BASE MAINTENANCE: LEFT FORWARD OVERWING EXIT AFT UPPER STOP FITTING STOP PAD ROTATED 180 DEGREES OUT POSITION. ADJUSTED LEFT HAND FORWARD OVERWING EXIT AFT UPPER STOP FITTING STOP PAD. PER AMM 52-22-00.SDR AALA202510029232Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT AFT OVERWING EXIT AFT UPPER STOP FITTING STOP PAD ROTATED 180 DEGREES OUT OF POST. ADJUSTED LEFT HAND AFT OVERWING EXIT AFT UPPER STOP FITTING STOP PAD. PER AMM 52-22-00.SDR DALA2025100207157Scuff Plate · corrodedFWD PAX DOOR SCUFF PLATE FASTENER HOLES 50L, 60L, 70L, 80L, 90L, 100L, 110L, AND 120L HAVE EVIDENCE OF CORROSION. REMOVED CORROSION ON FWD PAS DOOR HOLES 50L, 20L, 60L, 70L, 80L , 90L, 100L, 110L, AND 120L FOUND OUT OF LIMITS IAW A220 ASRP J51--21-25. PERFORMESDR DALA2025100207155Scuff Plate · corrodedAFT CARGO DOOR SCUFF PLATE FASTENER LOWER HOLES # 4OL, 9OL AND UPPER HOLES # 16OL, 18OL, 20OL HAS SIGNS OF CORROSION IN COUNTER SINK. REMOVED CORROSION ON AFT CARGO DOOR SCUFF PLATE AREA, FOUND OUT OF LIMITS IAW A220 ASRP J51-21-06, J53-61-01. RESTORE FINISH, SDR DALA2025100207154Scuff Plate · corrodedAFT CARGO DOOR LOWER SCUFF PLATE FASTENER HOLES 20L, 30L, 40L, 50L, 60L, 70L, 80L, 90L, 100L, 110L, HAVE EVIDENCE OF CORROSION. REMOVED CORROSION ON AFT CARGO DOOR LOWER SCUFF PLATE AREA, FOUND OUT OF LIMITS IAW A220 ASRP J51-61-06, J53-21-01. RESTORED FINISH SDR DALA2025100207153Door Sill · corrodedFWD CARGO DOOR LOWER SILL HAS EVIDENCE OF CORROSION. REMOVED CORROSION ON FWD CARGO DOOR LWR SILL, FOUND OUT OF LIMITS IAW ASRP J51-21-06, J53-21-25. RESTORE FINISH, PERFORMED ALL WORK IAW ERA 629095-14. ASSOCIATED ER/A 14-629095 ADDED FOR AC 8124. (LP# 12213SDR DALA2025100207152Support Strut · corrodedFWD CARGO DOOR, LOWER SILL, FWD AND AFT SUPPORT STRUTS HAVE EVIDENCE OF CORROSION. REMOVED CORROSION ON FWD CARGO DOOR LWR SILL, FOUND OUT OF LIMITS IAW ASRP J51-21--06 & J53-21-25 RESTORED FINISH PREFORMED ALL WORK IAW ERA 629138-14. ASSOCIATED ER/A 14-62913SDR DALA2025100207151Scuff Plate · corrodedFWD PAX DOOR SCUFF PLATE FASTENER HOLE NR 80L HAS SIGNS OF CORROSION IN COUNTER SINK. REMOVED CORROSION ON FWD PAX DOOR HOLE NR 80L, FOUND OUT OF LIMITS IAW ASRP 51-21--06 & 53-21-25 PREFORMED WORK I& RESTORED FINISH & PRIMED IAW ERA 629281-14. ASSOCIATED SDR DALA2025100207150Scuff Plate · corrodedAFT SERVICE DOOR SCUFF PLATE FASTENER HOLE NR 60L HAS SIGNS OF CORROSION IN COUNTER SINK. REMOVED CORROSION ON AFT SERVICE DOOR SCUFF PLATE FASTENER HOLE NR 60, FOUND OUT OF LIMITS IAW ASRP 51-21--06 & 53-61-01 PREFORMED WORK I& RESTORED FINISH IAW ERA 629154-SDR DALA2025100207149Scuff Plate · corrodedAFT SERVICE DOOR SCUFF PLATE FASTENER HOLES 10L, 20L, 30L, 50L, 60L, 70L, 100L, AND 140L HAVE EVIDENCE OF CORROSION. REMOVED CORROSION ON ON THE SCUFF PLATE FASTENER HOLES 10L, 20L, 30L, 50L, 60L, 70L, 100L, AND 140L. FOUND OUT OF LIMITS IAW ASRP J21--53-61SDR DALA2025100207164Scuff Plate · corrodedAFT PAX DOOR SCUFF PLATE FASTENER HOLE NR 110L HAS SIGNS OF CORROSION IN COUNTER SINK. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW ASRP 51-21-06 & 53-61-01. PERFORMED WORK AND RESTORED FINISH IAW ERA 629725-14. ASSOCIATED ER/A 14-629725 ADDED FOR AC 8124. (SDR R61A2025100200424Keelbeam · damagedDURING ANIMAL EXTRACTION STUB LOWER SKIN RIB 1 AND KEEL BEAM RIB 12 WAS DAMAGED. REPAIRED IAW EMB ETD2025-170-929260 ALSO REF VP-041853-2025 N/R 3,4 FOR WORK ACCOMPLISHED.SDR SWAA2025100118830Handle · looseR-1 DOOR ASSIST HANDLE BY G-1 IS LOOSE. TIGHTENED R-1 DOOR ASSIST HANDLE BY G-1 IAW SOPM 20-50-01.SDR SWAA2025100118818Flashlight · inoperativeFWD F/A FLASHLIGHT INOPERATIVE AND SEAL BROKEN. REMOVED AND REPLACED FWD FLIGHT ATTENDANT FLASHLIGHT AND SEALED IAW AMM 25-64-00.SDR CVGA20251001001Flap System · failedFLAPS FAIL EICAS MSG AFTER T.O. FLAPS INDICATING 3 DEG. EMERGENCY DECLARED. COMPLIED WITH PERFORMING FLAP RESET PROCEDURE. PERFORMED OPS CHECK, CHECKED GOOD AT THIS TIME ON GROUND. WORK DONE IAW CL300AMM TASK 27-51-05.SDR BJNA202510010001Charger · inoperativeDURING SERVICE CHECK, FOUND INTERIOR EMERGENCY AERA LIGHT AT ROW 23ABC AND 26ABC INOP. R & R EMERGENCY LIGHT AT ROW 23ABC AND 26ABC IAW AMM 33-51-03-960-801. NO HELP. INSTALLED OLD LAMP BACK. SUSPECT AREA LIGHT ASSEMBLY FAULT. PLACING ITEM ON MEL 33-15-01 CSDR CALA2025093009446Warning Message · false activationTE FLAPS DISAGREE CAUTION MSG FSEU 1 LAST LEG HAD FAULT 305 - INTERMITTENT, FSEU 2 HAD FAULT 327. PERFORMED FIM 27-51 TREE 805, BITE TEST GOOD, NO EXISTING FAULTS. MSG CLEARED. CYCLED FLAPS THROUGH FULL TRAVEL MULTIPLE TIMES, FLAPS OPERATED NORMALLY.SDR CALA2025093009445Anti-Ice Valve · faultedCOWL ANTI-ICE NR 2 ENG ILLUMINATED AT FL390. QRH FOLLOWED. LIGHT STILL ON. ON ARRIVAL OVERHEAD FAULT LIGHT FOR E2 ANTI-ICE VALVE EXTINGUISHED. IAW AMM 30-21-11/401 REPLACED COWL ANTI ICE VALVE AS PRECAUTION. ENGINE IDLE LEAK CHECK GOOD. BONDING TEST GOOD ATSDR CALA2025093009426Tire · bulgedNR 3 MLG TIRE FOUND BEYOND AMM LIMITS. MUST BE REPLACED PRIOR TO T HE NEXT FLIGHT. RAMP REPORT: NR 3 TIRE HAS A LARGE BULGE AT THE 6 O'OCLOCK POSITION. WILL NEED REPLACEMENT REPLACED #3 MLG TIRE REF. AMM 32-41-11-400-006-A.SDR CALA2025093009424Battery · dischargedEMERGENCY POWER ASSIST SYSTEM (EPAS) 9 VOLT BACK-UP BATTERY INSTALLATION. INSTALLED SLIDE SAFETY PINS (2EA) FOR MAINTENANCE INSTALLED SAFETY PINS AT DOOR L1 SLIDE. REMOVED AND STORED DOOR SLIDE SAFETY PINS (2EA) FROM L1 DOOR SLIDE. C/W IDT, VERIFIED SLIDE SASDR CALA2025100109490Seat Track · corrodedMAIN CABIN RT, BETWEEN FRS 20-21, SEAT TRACK Y-1292 WAS CORRODED. SEAT TRACK REMOVED & REPLACED IAW SRM 51-42-11/001 & 51-72-11-911-002.SDR CALA2025100109488Floor Support · corrodedCABIN FLOOR SUPPORT -Y765 CORRODED AT FR 67. REMOVED THE FLOOR SUPPORT, -Y765 FR67-70 IAW SRM 51-42-11/001, REV 154, REPLACED THE FLOOR SUPPORT, -Y765, FR67-70 IAW SRM 51-72-11/0 01, REV 154.SDR CALA2025100109486Tee Angle · crackedRIGHT AFT ANGLE CRACKED. REMOVED TEE ANGLE ON FR41-42 KEEL BEAM IAW SRM 51-42-11/001 REV.154 AND EA 5331-01718 REV.DSDR ASAA2025092761168Pin · missingL1 DOOR WILL NOT OPEN. GROUNDED - YES. FOUND L1 DOOR WOULD STICK/SEIZE AT COCKED POSITION WHILE ATTEMPTING TO OPEN DOOR. FORCED DOOR OPEN & FOUND GUIDE ARM RADIUS LINK LOWER HARDWARE MISSING. PERFORMED CONDITIONAL INSP REF AMM 05-51-59-200-801. PERFORMED FWD ESDR SWAA2025093018896Probe · failedAPPROXIMATELY 5 MINUTES AFTER TAKE OFF. WE OBSERVED #1 EGT GAGE SOLID AMBER. WITH APPROXIMATELY 915 INDICATED. WE REDUCED THRUST ON THAT ENGINE; AND INDICATIONS RETURNED TO NORMAL. EXCEEDANCE LASTED APPROX 10 SECONDS.<[01] T/S WITH FIM 71-06-804; EEC NO FAULTSSDR SWAA2025093019673Wire Harness · shortedAPPROXIMATELY 5 MINUTES AFTER TAKE OFF. OBSERVED NR 1 EGT GUAGE SOLID AMBER. WITH APPROXIMATELY 915 INDICATED. REDUCED THRUST ON THAT ENGINE AND INDICATIONS RETURNED TO NORMAL. EXCEEDANCE LASTED APPROX 10 SECONDS. T/S WITH FIM 71-06-804; EEC NO FAULTS; PNEUSDR SWAA2025093018831Girt Bar · out of adjustAFT SERVICE DOOR SLIDE GIRT/ BAR NEEDS ADJUSTMENT. ADJUSTED ASD SLIDE GIRT/BAR PER AMM 25-66-02-400-801 STEP 3(D). PERFORMED GOOD INSTALLATION TEST PER AMM 25-66-02-400-801 STEP 3(E).SDR SWAA2025093018587Lamp · inoperativeR1 EXIT LIGHT HAS 1 LED OUT. REMOVED AND REPLACED R1 EXIT LIGHT LED IAW AMM 33-51-01-960-801. OPS CHECK GOOD.SDR SWAA2025093018589Lamp · inoperativeRIGHT OVERWING LOWER EXIT LIGHT HAS 1 LED OUT. REMOVED AND REPLACED THE RT OVERWING LOWER EXIT LIGHT LED IAW AMM 33-51-01-960-801. OPS CHECK GOOD.SDR AALA202509300037Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS JAMMED. ADJUST LAVATORY-D DOOR. PER AMM 52-50-00.SDR AALA202509303711Tape · detachedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS RED TAPE BROKEN OFF ON THE GIRT BAR THATS ON THE AFT SERVICE DOOR. INSTALLED RED HEAT SHRINK TUBE ON AFT GIRT BAR. PER AARD 25-66-00-4.SDR AALA202509300343Indicator · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CABIN PRESSURIZATION WOULD NOT PRESSURIZE DURING CLIMB. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. PERFORMED BITE TESTS TO BOTH CABIN PRESSURE CONTROL 1 AND 2 NO FAULTS NOTED PER AMM 21-3SDR AALA202509309848Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND OVERWING FORWARD EMERGENCY LIGHT INOPERATIVE. RELAMPED RIGHT HAND OVERWING FORWARD EMERGENCY LIGHT. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202509300686Sill Drain · cloggedAIRCRAFT WAS NOT GROUNDED: STRONG SMELL OF ROTTEN EGGS IN FORWARD GALLEY INTERMITTENT THROUGHOUT THE FLIGHT. ACCOMPLISHED J/C 09L00021001. FOUND SMELL TO BE COMING FROM L1 DOOR FLOOR SILL DRAIN VENTS. DRAIN IS COMPLETELY CLOGGED AT THE FLOAT VALVE. REMOVED ANDSDR AALA202509296111Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS. ADJUSTED LAVATORY-E DOOR. PER CMM 25-40-65.