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 DALA2025101307494Pin · not seatedDURING INSTALLATION AND RE-ARMING PROCEDURE OF THE L/H OVERWING EMERGENCY EXIT HATCH, LATCH PIN WILL NOT SEAT AND LOCK IN ARMED POSITION. CORRECTIVE ACTION: RE-ARMED ESCAPE SLIDE RELEASE MECHANISM REF A319 AMM 52-21-11-400-001-A. (1247239).SDR DALA2025101307493Screw · damagedPASSENGER DOOR SLIDE DISARMING PIN POUCH DAMAGED/MISSING. R & R POUCH SCREW IAW A319 AMM 25-61. (1248095).SDR IXXA2025F00025Fire Warning · activatedRED FORWARD CARGO FIRE WARNING DURING CLIMB. CREW RETURNED TO DEPARTING STATION AND DECLARED EMERGENCY. AIRCRAFT ARRIVIED WITHOUT INCIDENT AND NO FURTHER PRCAUTIONARY ACTION WAS TAKEN. AIRCRAFT WAS GROUNDED FOR INSPECTION AND MAINTENANCE.SDR DALA2025101307472Ecu · inoperativeFCNT/DE- DECLARED EMERGENCY DUE TO LEADING EDGE FLAP TRANSIT LIGHT. FLAPS LOCKED OUT. PERFORMED FLAPS UP LANDING. PERFORMED FSEU BITE CHECK. FAULT HISTORY FSEU FAIL. REPLACED FSEU ON LOG PAGE 1247184 AND PERFORMED FLAP SYSTEM OPERATIONAL TEST. OPS CHECK GOODSDR 7C7A2025101200043Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHT INOP.SDR DALA2025101307454Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED. STRUCK BY CARRIER IN 504R, CAUSING IT TO DEPLOY. C/A: RESTOWED O2 MASK AT LOCATION 401PER A320 AMM 35-30OK FOR SERVICE. (LP: 1248583)SDR DALA2025101307452Ecs · contaminatedON DECENT AT 2,500FT, CREW DECLARED AN EMERGENCY AND DONNED O2 MASKS DUE TO FUMES IN THE FLIGHT DECK. ARFF INSPECTED A/C ON TAXIWAY WITH NTF. MTC FOUND APU INLET CONTAMINATION WITH OIL. PERFORM LEVEL B ECS DECONTAMINATION. APU PLACED ON MEL FOR CLEANING AND SDR FDEA202510121974Floor Panel · damagedPUNCTURE FLOOR 241FFF, IN UPPER CARGO COMPARTMENT FLOOR 241FFF, IN UPPER CARGO COMPARTMENT WAS REPAIRED IAW B-767, SRM 53-00-50-2R, PAR, 4.B, PAG. 2, FIG. 201, SHEET 2, REV. 92, APR-15-2025.SDR FDEA202510121973Floor Panel · damagedBROKEN FLOOR PANEL 241WFF MDCC. FLOOR PANEL 241WFF MDCC, WAS REPAIRED IAW B-767, SRM 53-00-50-2R, PAR, 4.B, PAG. 2, FIG. 201, SHEET 2, REV. 92, APR-15-2025.SDR FDEA202510121972Spar Cap · corrodedRIGHT WING LOCATED BETWEEN OUTBOARD TRAILING EDGE ISLAND AND RIGHT HAND OUTBOARD AILERON, OUTBOARD TRAILING EDGE LOWER CAP XORS 1048 FOUND CORRODED. CORROSION REMOVED & FOUND EXCEEDED LIMIT IAW SRM 57-00-01-1A ALLOWABLE DAMAGE 1. REAR SPAR LOWER CAP CARRIESDR FDEA202510121971Longeron · wornFUSELAGE: FUSELAGE APPROXIMATEL STATION 583 X= 24 LONGERON SUSPECTED CRACKED. FUSELAGE STATION 583 X= 24 CRACKED LONGERON REMOVED AND REPLACED AS PER MD-11 SRM 51-35-01-0G AND FABRICATED LONGERON PER DOUGLAS DRAWING ACA 3796 REVISION A. REPAIR CLASSIFIEDSDR FDEA202510121970Seat Track · wornCABIN-SEAT TRACK AT STATION 939 X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 939, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRSDR FDEA202510121969Seat Track · wornCABIN-SEAT TRACK AT STATION 999 X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRSDR FDEA202510121968Seat Track · wornSEAT TRACK AT BS 999 X= 47.5, FOUND CROWN WORN. SEAT TRACK CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT FROM EXISTING SPLICE BS 989 TO BS 1049, X=47.5 IAW SRM 53-00SDR DALA2025101307451Winglet · damagedEMERGENCY LIGHT AT SEAT 39B INOPERATIVE. REPLACED LIGHT ASSY AND REPAIRED WIRING PER A330 AMM 33-52. (7491087)SDR CALA2025101309971Cvr · inoperativeCOCKPIT VOICE RECORDER DOES NOT TEST. R & R CVR IAW AMM REF TASK 23-71-11-000-801, OPS CHECK GOOD.SDR CALA2025101309970Lens · missingPROXIMITY LIGHT AT SEAT 12D DAMAGE. CONFIRMED PROXIMITY LIGHT WITHOUT LENS, REMOVED AND REPLACED AS REF DMC-B787-A-33-51-06-00A-520A-A / DMC-B787-A-33-51-06-00A-720A-A, ITEM GOOD FOR SERVICE.SDR CALA2025101309969Elec Connector · brokenAISLE PATHWAY LIGHTING AT SEAT 38C HAS BROKEN WIRE AT CONNECTOR. REPLACED CONNECTOR AT 38C ESPM 20-56-21. REF AMM 33-51-00 VERIFIED OPERATION OF LIGHT.SDR CALA2025101309968Slide · detachedFOUND TO BE UNLOCKED AND SLIDING OFF RACK RESECURED CM419 AND LOCKED LATCH. OPS CK GOOD REF AMM 25-32-01.SDR CALA2025101309936Door · no discrepancyREMOVED RIGHT EMERGENCY EXIT HATCH SEAT 21F REF AMM 52-21-11 REPLACED EMERGENCY EXIT HATCH SEAL AT DOOR 21F REF AMM 52-21-18-960-003-A, NO DEFECTS FOUND. REINSTALLED HATCH AT 21F REF AMM 52-21-11-400-001-A, NO DEFECTS NOTED. PERFORMED CABIN PRESSURIZATION REF SDR AALA202510132156Baffle · not reportedAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN BS 500E AND 500F AT S26R REQUIRES REPLACEMENT. REPLACED BAFFLE PER AARD 51-00-05-1.TLESDR AALA202510135391Baffle · not reportedAIRCRAFT IN BASE MAINTENANCE: EXISTING REPAIR TO FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE BETWEEN BS 500C AND 500D AT S26L REQUIRES REPLACEMENT. REPLACED BAFFLE PER AARD 51-00-05-1.SDR 2026FA0000089Cylinder · fracturedAFER TAKING ON FUEL AT BAF, THE AIRCRAFT DEPARTED FOR 47N. WHILE CLIMBING OUT THROUGH 2500 MSL, THE AIRCRAFT ENGINE SUFFERED CATASTROPHIC FAILURE OF CYLINDER NUMBER 4. THE UPPER SECTION OF THE CYLINDER BARREL SEPERATED FROM THE LOWER SECTION APPROXIMATELY FOURSDR SWI2025F01910Stringer · corrodedCORROSION AT STGR 19RH BETWEEN FS295.00 TO FS310. REPLACED STGR 19RH BETWEEN FS295.00 TO FS310.00 REF REO 690-53-21-2043 REV.-. COMPIED WITH 51-900-1002-SKY. LEAK CHECKED GOOD.SDR SWIA202512261011Stringer · corrodedCORROSION AT STGR 20RH BETWEEN FS 295 TO FS 310. REMOVED AND INSTALLED NEW STGR 20RH BETWEEN FS295.00 TO FS310.00 REF. CRJ900 SRM 51-42-06-001-001-A01 AND BOMBARDIER DWG SH670-31630 REV. K COMPLIED WITH 51-900-1002--SKY. LEAK CHECKS GOODSDR SWIA2025120100011Stringer Splice · corrodedSTRINGER SPLICE 25R, BS 333 CORRODED. REPLACED STRINGER SPLICE IAW DWG SH670-32420, REV E, & SRM 51-42-06-001-001-A01. CHECKED GOOD.SDR R61A2025111500503Skin · dentedJET BRIDGE DAMAGE CAUSED DENT TO LOWER LH FUSELAGE. AIRCRAFT WAS FERRIED TO EAMS BNA. REMOVED AND REPLACED LH FUSELAGE SKIN FR9-12. STGR 8L-19L PER SRM 51-40-08.SDR SWAA2025111223691Nut Plate · corrodedCORROSION ON RAIL NUT PLATES LEADING EDGE LOCATED OFSS449 AT LT WING. REPLACED RAIL NUT PLATES LEADING EDGE LOCATED OFSS449 AT LT WING IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWAA2025111223686Nut Plate · corrodedCORROSION ON RAIL NUTPLATES LOCATED LEADING EDGE OFSS331 AT LT WING. REPLACED RAIL NUTPLATES LOCATED LEADING EDGE OFSS331 AT LT WING IAW B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWAA2025111223761Angle · crackedCRACK ACCESS PANEL 551FB TRAILING EDGE ANGLE AT LT WING. REPLACED ANGLE ON ACCESS PANEL 551FB TRAILING EDGE ANGLE AT LT WING AT LT WING IAW B737-700 SRM 51-10-02; SRM 51-40-02 AND DWG 115A2710 SHEET 9 REV A<BR>MEASURE OF CRACK IS L=0.611.SDR SWAA2025111223688Bracket · crackedCRACK BRACKET LOCATED BS 540 LBL 6 AT AIR CONDITIONING BAY. REPLACED BRACKET LOCATED BS 540 LBL 6 AT AIR CONDITIONING BAY IAW B737-700 SRM 51-10-02-0G-0 PARAGRAPH 9 AND SRM 51-40-02-0G-0.SDR SWAA2025111223689Hinge · corrodedCORROSION HINGE TOILET SERVICE DOOR 145AL AT LOWER FUSELAGE (2 EA). REPLACED HINGE TOILET SERVICE DOOR 145AL (2EA) I.A.W B737-700 SOPM 20-50-01 REV 39 AND DWG 146A7410-6 SHEET 6 REV -.SDR JJBA20251112037Seal · damagedSEAL DAMAGE TO THE LH UPPER AILERON SHROUD. REMOVED AND REPLACED SEAL ON THE LH UPPER AILERON SHROUD .SDR JJBA20251112031Gusset · corrodedRH AFT SERVICE DOOR SIDEWALL GUSSET AT FR 23, STR 6R HAS CORROSION. INSTALLED NEW RH SERVICE DOOR AFT SIDEWALL GUSSET AT FR 23 STR 6RSDR SWAA2025111123678Support Angle · crackedBAFFLE SUPPORT ANGLE ON THE AFT SIDE OF BS 500C, RBL 25, CRACKED. REMOVED AND REPLACED THE BAFFLE SUPPORT ANGLE IAW SRM 51-40-02, AND DWG 143A7505, REV A.SDR SWI2025F01516Slide · unpackedDURING REMOVAL OF AFT SERVICE DOOR EVAC SLIDE, IT WAS FOUND THAT THE LOWER SAFETY PIN WOULD NOT LOCK INTO PLACE, AND SLIDE UNRAVELLED OFF OF BOARD DURING REMOVAL. REMOVED AND REPLACED AFT SERVICE DOOR EVAC SLIDE. REF EMB 175 AMM 25-65-01.SDR SWIA2025110701Rib · crackedSUSPECTED CRACK RT HORIZONTAL STAB RIB 12A UPPER FLANGE BETWEEN FRONT SPAR AND FIRST STRINGER AT AFT RIVET LOCATION. REMOVED AND REPLACED R/H HORIZONTAL STAB RIB 12A. REF SRM 51-40-08 AND ETD2025-170-930708.SDR SWAA2025110623749Strip · crackedACB CAPSTRIP FROM BS727+4 - BS727D+4 LBL22 IS CRACKED. INSTALLED NEW CAPSTRIP ACB ON DISCREPANCY AREA IAW AMM 25-52-10-400-80.SDR CALA2025110410884Skin · corrodedCORROSION AND SMALL HOLE AT LOWER FUSELAGE SKIN AROUND BS 965 B. ACCOMPLISHED REPAIR OF LOWER FUSELAGE SKIN BETWEEN STA 947.5 AND 967 AT STR 27L-27R AS PER SRM 53-00-01-2R-3 AND ECRA 5370-01202,SDR IPXA2025102913554Bracket · crackedNLG WW LH WHEEL GUIDE STRUT UPPER ATTACHED SUPPORT MOUNT IS CRACKED, DOT 55-033. INSTALLED NEW BRACKET-GUIDE STRUT NLG IAW A300-600 SRM 51-40-21. REVIEWEDSDR IPXA2025102812902Floor Support · crackedFAULT-Z120-STR-FLOOR STRUCTURE SUPPORT ANGLES CRACKED L/H, @ FR.38 FWD CARGO JUST BELOW MAIN DECK FLOOR. DOT 85/1095. REMOVED CRACKED SUPPORT ANGLE L/H AT FR.38 I.A.W. A300-600 SRM 51-40-21. ++INSTALLED NEW SUPPORT IAW A300-600 SRM 51-40-21.SDR IPXA2025102812925Floor Support · crackedFAULT-Z120-STR-FLOOR STRUCTURE SUPPORT ANGLES CRACKED R/H, @ FR.38 FWD CARGO JUST BELOW MAIN DECK FLOOR. DOT 85/1096. REMOVED SUPPORT ANGLE R/H AT FR.38 I.A.W. A300-600 SRM 51-40-21. ++INSTALLED NEW SUPPORT IAW A300-600 SRM 51-40-21.SDR SWAA2025102723743Stand Off · crackedLEFT WING PANEL 551FB 90 DEGREE WIRING STAND OFF BRACKET IS CRACKED.<[01] R&R BRACKET REF SRM 51-40-02.;[02] INSPECTED WORK ACCOMPLISHED R&R BRACKET REF SRM 51-40-02.SDR AALA202510279761Lens · missingAIRCRAFT WAS NOT GROUNDED: REAR MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 10D MISSING LENS AND INOP. MAINTENANCE REAR MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 10C IAW AMM 33-51-05 OPS CHECK GOOD.SDR CALA2025102610536Floorbeam · corrodedB737-53-3-0737 MAIN CABIN AFT WET AREA R/H STA 987 RBL43 FRAME HAS CORROSION MARKED. REMOVED DAMAGE ONLY .150 MATERIAL LOSS .040 REMAINING .110 FOUND TO BE OUT OF LIMITS REF SRM 53-70-51-1A-1 FLOORBEAM REPAIRED.SDR CALA2025102610534Floorbeam · corrodedMAIN CABIN AFT WET AREA R/H STA 947 O/B LAV MOUNT, FRAME HAS CORROSION MARKED. REMOVED DAMAGE,HFEC NO DEFECTS NOTE,FABRICATED,LOCATED DRILLED, INSTALLED,AND RESTORED ,COUTINGS REF B737-800 SRM 53-70-51-2R-5 THIS IS A CAT A REPAIR NO FURTHER ACTION REQUIRED.SDR CALA2025102610532Crease Beam · corrodedB737-53-3-0737 MAIN CABIN AFT WET AREA R/H AT R2 DOOR, CREASE BEAM HAS MULTI SPOTS OF CORROSION. REMOVED AND REPLACED MAIN CABIN AFT WET AREA R/H CREASE BEAM AT R2 DOOR IAW B737-800 SRM 51-40-02 & BAC DWG 147A8501 REV:B.SDR AALA202510249828Sleeve · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND PYLON AFT ATTACH FITTING UPPER SLEEVE WORN. REPLACED SLEEVE PER TASK CARD 26C41554028.SDR SWAA2025102123518Angle · corrodedACCOMPLISHES A RII INSPECTION AND DOCUMENTATION OF THE CORROSION MEASUREMENTS ON PSE FOR COMPLETED FAULT TASK TTG8Q01560LY. REPLACED ANGLE LOCATED BTW BS 294.5 TO BS 332.1 RBL 58 WL 208.1 AT FWD GALLEY AREA IAW SRM 51-10-02 ITEM 9 AND DWG 141A8310; SHEET 23;SDR ASAA2025101161652Power Supply · inoperativeEMERGENCY LIGHTS FOR POWER SUPPLY M1670 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY M1670 S/N 35747 REF B737NG AMM 33-51-06-960-806. EMERG LIGHTS OPS CHECKS GOOD REF. B737NG AMM 33-51-06-960-806.