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 9WGA2025090954646Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT LH APPROX STA 1173, XCW 112 AT S-22. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT LH CENTER WINGSDR SWAA2025090495378Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS847 TO BS867 UPPER CEILING AREA LBL21 AFT CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL LOCATED BTW BS847 TO BS867 UPPER CEILING AREA LBL21 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 149ASDR SWAA2025090495379Support · crackedCRACK CARGO LINER ANGLE SUPPORT LOCATED STA927 AND RBL 45.5 CEILING AREA AT AFT CARGO COMPARTMENT. REPAIRED CARGO LINER ANGLE SUPPORT LOCATED AT STA927 AND RBL 45.5 CEILING AREA AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-70-11-2R-0.SDR SWAA2025090395393Rib · crackedCRACK INSPAR RIB STA.101.90 TO 30 INCH PLUS FRONT SPAR WEB LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB HSS.101.90 TO 30 INCH PLUS FRONT SPAR WEB LT HORIZONTAL STAB IAW SRM 55-10-09-2R-4, REPAIR 4. MAJOR REPAIR.SDR SWAA2025090395372Floor Support · crackedCRACK FLOOR SUPPORT LOCATED BTW BS277 TO BS294.5 AND BL0 FWD GALLEY AND LAV. REPLACED THE FLOOR SUPPORT BTW BS277 TO BS294.5 AND BL0 FWD GALLEY AND LAV IAW SRM 51-40-02 AND DWG 141A5400; SHEET: 20 AND REV-.SDR SWAA2025090395374Floorbeam · crackedCRACK ON FLOORBEAM LOCATED BS294.5 AND RBL52 FWD GALLEY AND LAV . PERFORMED PERMANENT REPAIR ON FLOORBEAM LOCATED AT BS 294.5; BTW RBL 15 TO RBL 60 IAW SRM 53-10-51-2R-16 REPAIR 16 ALTERNATIVE 2.SDR SWAA2025090395373Support Angle · crackedCRACK ON ANGLE - SUPPORT LOCATED BTW BS303.9 TO BS294.5 AND STR17R FWD GALLEY AND LAVATORY . REPLACED ANGLE - SUPPORT AND FASTENERS LOCATED BTW BS303.9 TO BS294.5 AND STR17R FWD GALLEY AND LAVATORY IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 141A8310 SHEET:SDR CALA2025082908255Web · corrodedCORROSION AT AFT CABIN WET AREA WEB PLATE BETWEEN STA 1030 TO STA 1040 RIGHT SIDE UPPER FLANGE. REMOVED AND REPLACED WEB LOCATED FROM STA 1030 TO STA 1042 AND BL 0" TO RBL 27", AFT WET AREA IAW SRM 51-40-02-0G-0 AND DWG 147A5116.SDR AALA202508267651Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM Y1292 LOCATED FR16 FWD GALLEY AREA MEASURE CORROSION ARE L=2.595 INCH W=1.940 INCH D=0.058 INCH. MAINTENANCE REPLACED FLOOR BEAM Y1292 LOC FR 16 FWD GALLEY AREA IAW A319 SRM 51-72-11-911-001,DWG D53918122 AND SDR 9WGA2025082654645Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT LH APPROX STA 1226, XCW 22.5 AT S-15. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT LH CENTER WINSDR 9WGA2025082654644Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT FRONT SPAR BETWEEN CL AND XCW 8.0. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT FRONT SPAR BETWESDR 9WGA2025082654643Panel · corrodedDURING HEAVY MAINTENANCE CENTER UPPER PANEL CORRODED AT RH APPROX STA 1172, XCW 0.5 AT 5-22. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT RH APPROX STA 1172, XCW 6.5 AT S-22 BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MD-11, MESSSDR 9WGA2025082654642Panel · corrodedDURING HEAVY MAINTENANCE CENTER UPPER PANEL CORRODED AT RH APPROX STA. 1182, XCW 8.5 AT 5-21. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT RH APPROX. STA. 1182, XCW 8.5 AT S-21 BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MD-11 MSDR 9WGA2025082354641Panel · corrodedDURING HEAVY MAINTENANCE CENTER WING UPPER PANEL CORRODED AT L/H APPROX STA 1196, XCW 5.0 AT S-19. AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT L/H CENTER WING USDR 9WGA2025082354640Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT RH APPROX STA. 1205, XCW 4.0 AT S-18. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT RH CENTER WINSDR 9WGA2025082254630Panel · corrodedDURING HEAVY MAINTENANCE CENTER WING UPPER PANEL CORRODED AT LH APPROX STA 1214, XCW 3.0 AT S-17. AFTER FURTHER EVALUATION OF BLENDED AREA AT LH APPROX STA 1214, XCW 3.0 AT S-17, BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MD-11, MESDR 9WGA2025082254629Panel · corrodedDURING HEAVY MAINTENANCE CENTER WING UPPER PANEL CORRODED AT RH AAPROX STA. 1229, XCW 17.5 AT S-15. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT R/H CENTER WING UPSDR 9WGA2025082254628Panel · corrodedDURING HEAVY MAINTENANCE CENTER WING UPPER PANEL CORRODED AT RH APPROX STA. 1229, XCW 34.5 AT S-15. AFTER FURTHER EVALUATION, BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT R/H CENTER WING SDR 9WGA2025082254627Panel · corrodedDURING HEAVY CHECK CENTER WING UPPER PANEL CORRODED AT RH APPROX STA. 1226 XCW 80.5 AT S-15. AFTER FURTHER EVALUATION BOING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT R/H CENTER WING UPPER PANELSDR SWAA2025082195339Wedge · delaminatedRIGHT WING INBD MAIN FLAP; OTBD TRAILING EDGE WEDGE HAS LARGE AREA OF DELAMINATION. REMOVED DAMAGED WEDGE. LOCATED & DRILLED NEW WEDGE IAW SRM 51-40-02.; COMPLIED WITH STEP 1. INSTALLED NEW NUT PLATES IAW SRM 51-40-02. PAINTED LOWER TE WEDGE SURFACE IAW AMSDR AALA202508216383Door Latch · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EXIT LOWER AFT LATCH FITTING, INSERT IS WORN. REMOVED AND INSTALLED A SERVICABLE LOWER AFT LATCH INSERT. PER AMM 52-22-00. OPERATIONAL CHECK IS GOOD.SDR AALA202508219562Door Latch · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT LOWER AFT LATCH FITTING INSERT IS WORN. REMOVED AND INSTALLED A SERVICABLE LOWER AFT LATCH INSERT. PER AMM 52-22-00. OPERATIONAL CHECK IS GOOD.SDR SWAA2025081595038Bulkhead · crackedLEFT SIDE VERTICAL 663 BULKHEAD LOWER VAPOR BARRIER FOUND CRACKED WITH TEMP REPAIR; CUSTOMER REQUEST TO ACCOMPLISH PERMEANT REPAIR. REPAIRED L/H VERTICAL 663 BULKHEAD LOWER VAPOR BARRIER IAW SRM 51-70-04-2R-0 AND SRM 51-70-04-2R-10.SDR 3EJA202508150005Indicator · no indicationON APPROACH, HAD NO GREEN LIGHT, LEFT MAIN GEAR INDICATION. WENT AROUND, TOWER SAID THAT ALL THREE GEAR APPEARED TO BE DOWN. CND. SWUNG GEAR NUMEROUS TIMES.SDR AALA202508134533Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON DOOR FRAME LOC. BTW FR67 AND FR68 AT LEVEL STRG 8R, PASSENGER CABIN, AFT GALLEY AREA. CRACK L=0.538 IN. MAINTENANCE REPLACED DOOR FRAME LOC. BTW FR67 AND FR68 AT LEVEL STRG 8R, PASSENGER CABIN, AFT GALLEY AREA IAW A319 SRSDR AALA202508117518Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T CAP) AT STA 328, RBL 57. REPAIRED UPPER CHORD PER SRM 53-10-51-2R-8 AND EA 366848.SDR JJBA20250811027Floor Support · misrepairedRH OMEGA BEAM REPAIR BTW FR 23-24 WAS NOT DONE PROPERLY. REPAIR AT RH OMEGA BEAM BTW FR 23-24 REMOVED. REPAIR AT RH OMEGA BEAM BTW FR 23-24 REPLACED. OMEGA BEAM SURFACE AT RH BTF 23-24 REPROTECTED.SDR CALA2025081107554Fitting · corrodedNUMBER 1 PYLON SPIGOT BEARING LOWER FITTING HAS CORROSION. R & R THE NR 1 PYLON SPIGOT BEARING LOWER FITTING IAW SRM 54-51-12-300-002.SDR AALA202508093505Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL LOCATED BTW FR 66 TO FR 68 AND STR 23R AFT GALLEY AREA MEASURE CORROSION ARE L=0.375 INCH W=0.220 INCH D=0.050 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON LOWER SILL LOC BTW FR66 TO FR68 AND STGR 23R AFT GSDR AALA202508058803Latch · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT LOWER FORWARD LATCH FITTING INSERT IS WORN. REMOVED AND INSTALLED A SERVICABLE FORWARD LOWER AFT LATCH INSERT ON RIGHT HAND FORWARD ROW EMERGENCY EXIT DOOR. PER AMM 52-22-00.SDR DALA2025080405820Indicator · looseSHIP 5650 L1 DOOR "KNUCKLE KNOCKER" LOOSE. CORRECTIVE ACTION: REMOVED SLIDE BUSTLE AND MID LINER FOR ACCESS AND SAFETY PIN DOOR SLIDE. REMOVED KNUCKLE BUSTER PAN REF B757 AMM 51- 11-20. REMOVED AND REPLACED BOX ASSY. REINSTALLED MIDLINER AND UNPINNED DOOR SLIDSDR AALA202508048108Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, FROM LBL 5 TO LBL 14. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508019065Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON HOLE H1 INSTERCOSTAL FITTING LOC. ON FR 20 LH SIDE AT LEVEL DOOR STOP 7, FWD GALLEY AREA, MEASURE OF CRACK IS L=0.103 IN. MAINTENANCE REPLACED INSTERCOSTAL FITTING LOC. ON FR 20 LH SIDE AT LEVEL DOOR STOP 7, FWD GALLEY ASDR AALA202508017009Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE CRACKS AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727E, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR JJBA20250731130Stringer · corrodedSTRINGER 21R BTW FR 53-54 FOUND CORRODED. S21R BTW FR 53-54 CORROSION BLENDED AND STRINGER FOUND TO BE OUT OF LIMIT. S21R CUTOUT PERFORMED. S21L REPAIR PERFORMED.SDR JJBA20250731127Spar · crackedRIGHT WING FRONT SPAR LOWER FLANGE CRACKED AT ONE HOLE. RT WING FRONT SPAR LOWER FLANGE REPAIRED WITH A DOUBLER.SDR AALA202507316019Smoke Detector · false indicationAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR AALA202507317070Fire Detector · false indicationAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR AALA202507312870Fire Detector · false indicationAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR AALA202507314614Fire Detector · false indicationAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR AALA202507316361Control Unit · false activationAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR AALA202507315282Fire Bottle · no discrepancyAIRCRAFT WAS GROUNDED: FORWARD CARGO FIRE LIGHT ILLUMINATED ON THE GROUND. FIRE WARNING BELL SOUNDED AND THE CARGO FIRE BOTTLE DISCHARGED. REMOVED AND REPLACED CARGO FIRE EXTINGUISHING BOTTLE (AALA202507315282), PER AMM 26-23-01. ALSO REMOVED AND REPLACED CARGSDR CALA2025073107122Sensor · unsecureCARGO DOOR OPEN ECAM ON TAXI OUT. FOUND FWD CARGO DOOR CLOSED INDICATION SWITCH ASSY LOOSE, UNABLE TO TIGHTEN DUE TO DAMAGED HARDWARE, CLOSED DOOR AND VERIFIED FWD CARGO DOOR CLOSED AND LATCHED IAW AMM 52-70-00-040-001-A, R & R THE FWD CARGO DOOR PROXIMITY SDR CALA2025073107117Wireless Unit · faultyELECTRICAL BURNING SMELL FLOM ROW 37 LOCATED ODOR TO AFT WAP OVER AFT GALLEY CEILING. PULLED & COLLARED CB AT P6-5 B-11. CREW WAP POWER. REF WDM 46-13-21-1. COMPLIED WITH MEL. REF AMM 46-13-06 FOR WAP 2 . VERIFIED NO OTHER SYSTEMS AFFECTED. COMPLIED WITH FISDR CALA2025073107111Wire · brokenWHILE PERFORMING EMERGENCY LIGHTING TEST FOUND EMERGENCY CABIN LIGHT AT SEAT 32C NOT ILLUMINATING. REPLACED THE LAMP. NO HELP. FOUND BROKEN WIRE UNDER SEAT TRACK COVER. REQUIRES SPLICE. REPAIRED WIRE WITH ENVIRONMENTAL SPLICE. REF SWP 20-10-13. OPS NORMAL.SDR SWAA2025073195500Anti-Skid Valve · out of limitsANTI-SKID INOP ILLUM ON APPROACH<[01] PERFORMED ALT ANTI-SKID VALVE T/S REF FIM 32-42 TASK 805. FOUND R/H ALT ANTI-SKID VALCE OUT OF RESISTANCE. REMOVED AND REPLACED R/H ANTI-SKID VALVE REF AMM 32-42-31. OPS CHECKED GOOD. NO DEFECTS NOTED.SDR JJBA20250730118Floor Support · corrodedCF1, RH OMEGA BEAM FOUND CORRODED AT FR20 AND AT FR23. AFTER INVESTIGATION, NO CORROSION FOUND AT FR20, ONLY CORROSION FOUND AT FR23. AT CF1 FR23 RH OMEGA BEAM BLENDED OUT OF LIMITS. AT CF1 FR23 CUTOUT MADE ON RH OMEGA BEAM. REPAIR PART FABRICATED. AT CF1 FR2SDR DALA2025073005716Skin · damagedSHIP 3360 STRINGER 3R AND FUSELAGE SKIN REWORK, FR 60-62. REPAIRED PER ERA 627795-14.SDR DALA2025073005715Stringer · damagedSHIP 3360 STRINGER 3L REPAIR, FR 60 - FR 64. INSPECTED AND REPAIRED PER ERA 627504-14. (1105529)SDR CALA2025073007108Wire Harness · disconnectedAISLE LIGHT 3B INOP/RECESSED MEL APPLIED. MX REPORTS THIS IS A SEAT MOUNTED WHITE LIGHT MODULE TYPE. SINGLE. MEL 3351H APPROVED ITEM PLACED ON MEL. REF CMM IPL 25-26-72/F.32: FOUND SEAT LIGHT HARNESS PLUG DISCONNECTED. RECONNECTED HARNESS PLUG. OPS CHECK GOO