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 IXXA20260106002Skin · chafedNR 1 PYLON UPPER SKIN IS CHAFED AT OTBD SIDE AT FAN COWL AND T/R SEAM.SDR VNAA2026010611102Unknown · odorCHA OPS REPORTS A BURN/ELECTRICAL SMELL IN FLIGHT DECK OF 552. BATT STILL ON / COMPLIED WITH FIM 21-21-00-810-806-A01. COULD NOT REPLICATE BURN SMELL. OPS CHECK GOOD AT THIS TIMESDR FDEA202601050005Skin · crackedLEFT AFT FUSELAGE BS 1459-1461 (02EA) FASTENERS AFT OF BUTT SEAM BS 1459 ABOVE STR 20 AND DOUBLER THAT HAVE (02) POSSIBLE CRACKS INDICATION UNDER FASTENERS RUNNING PARALLEL OF THE DOUBLER DURING NDT HFEC INSPECTION COMPLIED WITH EA # F5330-T0385962 TITTLESDR HNAA2026010600005Control Unit · failedNR 1 THRUST REVERSER DISAGREE MESSAGE ON TAKE OFF ROLL. CREW ABORTED TAKEOFF APPROX 40 KNOTS. FOUND NR 1 ENG T/R ICU VALVE FAILED ON CMC. R & R NR 1 ICU IAW AMM 78-33-01-00/400-801-A. LEAK CHECK GOOD. OPS CHECK GOOD. NO DEFECTS AT THIS TIME.SDR SCNA20260106013Battery Pack · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE. R & R M1671 BATTERY PACK IAW AMM 33-51-06. EMERGENCY LIGHT OPS CHECKED GOOD IAW AMM 33-51-00.SDR SCNA20260106012Battery Pack · inoperativeRIGHT AFT SIDE/WING EMERGENCY LIGHT FOR OVERWING DOOR INOPERTAIVE. R & R M1671 BATTERY PACK IAW AMM 33-51-06. EMERGENCY LIGHT OPS CHECKS GOOD IAW AMM 33-51-00.SDR SCNA20260106011Battery Pack · inoperativeROW 21 AISLE EMERGENCY EXIT LIGHT INOP AND LENS MISSING. COVE BULLNOSE PARTIALLY REMOVED TO GAIN ACCESS AT ROW 21 IAW AMM 25-21-71. REMOVED ROW 21 AISLE EMER. LIGHT ASSY & OPS CHECKED GOOD. REINSTALLED ROW 21 LIGHT ASSY IAW AMM 33-51-03. REINSTALLED COVE BSDR SCNA20260106010Battery Pack · inoperativeROW 17 AISLE EMERGENCY EXIT LIGHT INOP AND LENS MISSING. COVE BULLNOSE PARTIALLY REMOVED TO GAIN ACCESS AT ROW 17 REF AMM 25-21-71. REMOVED ROW 17 AISLE EMER. LIGHT ASSY & OPS CHECKED GOOD. LIGHT POSITION. REINSTALLED ROW 17 LIGHT ASSY REF AMM 33-51-03. RESDR CALA2026010612704Lens · detachedVERIFIED MISSING 2EA FLOOR PROXIMITY LIGHT ON AISLE OF THE SEAT 11D. INSTALLED 2EA NEW FLOOR PROXIMITY LIGHT AT POSITION 11D. GOOD FOR FLIGHT. REF.:AMM 33-51-06.SDR CALA2026010612703Skin · dentedREPLACE FWD CARGO DOOR EXTERNAL SKIN, REMOVED AND REPLACED FWD CARGO DOOR EXTERNAL SKIN PER SRM 51-40-02-0G-0 AND DWG#143A6110.SDR CALA2026010612702Skin · dentedREPLACE AFT CARGO DOOR EXTERNAL SKIN. REMOVED AND REPLACED AFT CARGO DOOR EXTERNAL SKIN PER SRM 51-40-02-0G-0 AND DWG#143A6110.SDR CALA2026010612701Power Supply · inoperativeOPERATIONAL TEST FND DOOR NO.4 R/H M33409 BATTERY PACK INOP. POWER SUPPLY REPLACED AND TESTED NORMAL IAW AMM 33-51-06-960-803 REV.105SDR CALA2026010612692Battery · faultedEPSU BATTERY FWD L FAULT OF EMERGENCY LIGHTING SYSYTEM. BATT FAULT ATA 33-51-38 REMOVED AND REPLACED FORWARD LEFT BATTERY OF THE EMERGENCY POWER SUPPLY UNIT (EPSU) AMM 33-31-38, OPS CHECK OK.SDR CALA2026010612690Unknown · odorDIRTY SOCK SMELL FL290 EPR 1.19 N1 74 PERCENT N2 83 PERCENT PERFORMED INSPECTION FOR ODOR EVENT REF AMM 05-50-00-810-831-A. TYPE 10 MISC. DETERMEMDED TO BE MOST LICKLEY, CHECKED PACK INLETS AND E & E COMPARTMENTS NO EVIDANCE OF ANY DEFECTS AT THIS TIME. SCENTSDR YENA2026010500013Bypass Valve · failedFLT 1189 JFK -SAN (ETOPS). AIR PACK 1 REG FAULT ECAM DURING CRUISE QRH REFERENCED ( ECAM INDICATION 3) ON BLEED PAGE A, PACK OUTLET TEMPERATURE. REMOVED AND REPLACED BYPASS VALVE WITH IAW AMM 21-61-53 OPS CHKD GOOD.SDR R61A2026010500002Floorbeam · corrodedEVALUATED 14EA SPOT OF CORROSION ON COCKPIT COPILOT'S FLOOR DOUBLER AS MARKED AND REMOVED DAMAGE BY BLENDING. DEEPEST MEASURED(LOCATED BETWEEN FR 9-8): L=6.1", W=1", MATERIAL LOSS= 0.015", ORIGINAL THICKNESS= 0.040", MAX. ALLOWABLE MATERIAL LOSS= 0.008"(20%), SDR GTIA2025010539238Megaphone · inoperativeFA REPORTS FWD MEGAPHONE INOPERATIVE. R & R FWD MEGAPHONE IAW AMM 25-65-51.SDR WX0A2026010532693Megaphone · inoperative(AIRCRAFT NOT GROUNDED) AFT MEGA PHONE SIREN FUNCTION INOP. / REMOVED AND REPLACED AFT MEGA PHONE W/REF TO AMM 25-64-00-710-801, OPERATIONAL TEST GOOD. "SDR DALA2026010500085Bottle · low pressureR2 DOOR ASSIST PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8148794)SDR DALA2026010500084Frame · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON DOUBLER NEXT TO OPEN HOLE @P'4. REPAIRED PER ERA 631298-14 REV. ORIG. (1386452)SDR DALA2026010500083Frame · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME LOWER EDGE @P'1. REPAIRED PER ERA 631298-14 REV. ORIG. (1386446)SDR DALA2026010500082Frame · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON FRAME @P'2. REPAIRED PER ERA 631298-14 REV. ORIG. (1386444)SDR DALA2026010500078Skin · gougedLOWER FUSELAGE EXTERNAL SKIN FOUND SEVERAL GOUGE MARKS AT BETWEEN FR54-55, STGR 45L-49L. REPAIRED PER SRM 53-41-11-205-002. (1386230)SDR DALA2026010500076Frame · damagedFORWARD SIDE OF FRAME 61 TOOLING DAMAGE ON FRAME LOWER EDGE STRINGER 1. REPAIRED PER ERA 631298-14 REV. ORIG. (1386448)SDR GTIA2025010539239Megaphone · inoperativeAFT CABIN MEGAPHONE DOES NOT TRANSMITT. R & R AFT CABIN MEGAPHONE IAW AMM 25-65-51 OPS CHECK GOODSDR R61A2026010500001Skin · damagedWHILE IN HEAVY CHECK. FOUND LIGHTNING STRIKE DAMAGE ON FUSELAGE SKIN BETWEEN FR 1-2 AND STGR 2L-2RSDR AALA202601053486Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR SUPPORT AT FR 16 AND LBL 41. REPLACED FLOOR SUPPORT PER SRM 51-72-11.SDR AALA202601051490Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT-HAND AFT EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR JR2R20260105956Panel · chafedRIGHT PYLON PANEL, 429ML, HAS 3 CHAFED AREAS OUT OF LIMITS. REPAIREDSDR JR2R20260105962Panel · chafedRIGHT PYLON PANEL, 419ML, HAS 4 CHAFED AREAS OUT OF LIMITS. REPAIREDSDR JR2R20260105953Panel · chafedRIGHT HAND PYLON PANEL, 429NR, HAS 2 CHAFED AREAS OUT OF LIMITS. REPAIREDSDR SWIA2026010475894Skin · corrodedCORROSION ON INTERNAL FUSELAGE AT F.S589.00 AND STR24L.CORROSION ON INTERNAL FUSELAGE AT FS 589.00 AND STR24L IDENTIFIED AT FS589.00 FRAME FLANGE BETWEEN AND WEB BETWEEN STR24L-STR23L ALONG WITH STR24L FLANGE. REMOVED FASTENERS IAW SRM 51-42-06 AND BLENDED COSDR SWIA2026010475785Fitting · corrodedFORWARD JACK FITTING LH AND RH INTERCOSTALS CORRODED . REPAIRED FWD JACK FITTING INTERCOSTAL FLANGES PER REO 601R-53-11-4050 REV --SDR SWIA2026010475661Bulkhead Web · corrodedRIGHT BS 280 WEB AND ASSOCIATED FASTENERS CORRODED. LOWER FS280 WEB FOUND TO BE HEAVILY CORRODED AND OUT OF ALLOWABLE LIMITS IAW SRM 53-00-00-101-001-A01. REMOVED RT BS 280 CAP ANGLE TO FOM IAW SRM 51-42-06-001-001-A01, AND SRM 51-42-13-001-001-A01. REMOVED ASDR SWIA2026040375647Bulkhead · corrodedLEFT BS 280 WEB & ASSOCIATED FASTENERS CORRODED. REMOVED AFFECTED FASTENERS FROM THE CAP ANGLE. REMOVED 5 SOLID RIVET, 1 CHERRYMAX, AND 1 VISU-LOK IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, AND SRM 51-42-22-001-001-A01. REMOVE CORROSION FROM LTSDR IXX2026F00003Bezel · crackedVIEWPORT WINDOW PRIZM ASSEMBLY R1 P/N 141T6665-1 CRACKEDSDR SWIA202603275595Skin · dentedLEFT INBD FLAP HAS 1 DENT, MID CHORD AT APPROX. F.L.S. 75.00. REPAIRED THE LT INBD FLAP MID CHORD AT APPROX FLS 75.00 IAW REO 601R-57-52-678, REV C.SDR SWIA2026031175507Skin · dentedAFT FUSELAGE BELOW CARGO DOOR CUT OUT, JUST AFT OF BS 605 BELOW WL 73.50 DENTED. PLOT, MAP, AND EVALUATE DAMAGE IF WITHIN ACCEPTABLE LIMITS OR REWORKED, ELIMINATE ALL EVIDENCE USING STANDARD ACFT PRACTICES. COMPLIED WITH REO 601R-53-61-8479.SDR SWAA2026020358007Angle · crackedCRACKED ANGLE, BS 500C FWD OF STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7505, SHEET 82, REV -.SDR SWAA2026020358003Nut Plate · corrodedCORROSION ON THE INTERNAL CAVITY, FRONT SPAR OTBD RAIL NUT PLATE OFSS 460, LT WING. REPLACED RAIL NUT-PLATE IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DWG 112A4402, SHEET 13, REV -.SDR SWAA2026020360964Isolation Mount · debondedDEBONDED ISOLATOR MOUNT, BS 540, S10 - 11R. THE ISOLATOR MOUNT WAS BONDED IAW DWG 144A2201, SHEET 7, REV B.SDR SWAA2026020358004Nut Plate · crackedCRACKED INTERNAL CAVITY FRONT SPAR OTBD RAIL NUT PLATE LT WING OFSS 332. REPLACED RAIL NUT PLATE IAW SRM 51-40-02, AND DWG 112A4402, SHEET 13, REV -.SDR SWAA2026020358006Nut Plate · crackedCRACKED INTERNAL CAVITY, FRONT SPAR OTBD RAIL NUT PLATE, RT WING OFSS 594. REPLACED RAIL NUT PLATE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 112A4402, SHEET 14, REV-. .SDR VNAA202602020001Seat Track · corrodedAFTER REMOVAL OF FITTING OF FWD LAVATORY A DETAILED VISUAL INSPECTION WAS PERFORMED IAW NDTM 52-2100 AND CORROSION WAS FOUND ON SEAT TRACK RBL 9 FS349-477. DUE TO EXCESSIVE DAMAGE, SEAT TRACK ON RBL 9 FS 349.00 TO FS 477.00, WAS REPLACED PER SRM 53-21-49-101SDR IPXA2026011949089Floor Support · crackedFWD CARGO COMPT-LT FWD SIDE OF FR21 UNDER OTBD BALL MAT HAS CRACKED INTERCOSTAL ON AFT END. REMOVED INTERCOSTAL WITH CRACK AT FWD CARGO COMPARTMENT LT SIDE FWD BETWEEN FR20 AND FR21 IAW A300-600 SRM 51-40-21. INTERCOSTAL AND CLIPS INSTALLED IAW SRM 51-72-10,SDR IPXA2026012644037Skin · delaminatedMAJOR REPAIR. APU COMPARTMENT LT SIDEWALL INNER SKIN WAS DELAMINATED APPROX 8"X10" AREA BETWEEN BS 1918 AND 1941 17 INCHES ABOVE THE LWR FRAME. VERIFIED COMPLETION OF REPAIR IS A CATEGORY A REPAIR. NO FURTHER ACTION REQUIRED.SDR IPXA2026012643865Skin · dentedMAJOR REPAIR, APU COMPARTMENT RT SIDEWALL INNER SKIN HAS DENTED & CRACKED BETWEEN BS 1918 AND 1941 APPROX 26 INCHES ABOVE THE LWR FRAME. VERIFIED REPAIR IS A CATEGORY A REPAIR. NO FUTHER ACTION IS REQUIRED.SDR IPXA2026012843933Skin · delaminatedMAJOR REPAIR, COMPOSITE APU COMPARTMENT: APU COMPARTMENT INNER SKIN INCLUDING OUTER SKIN HAS DELAMINATION BETWEEN BS 1918 & 1941 17 INCHES ABOVE THE LWR FRAME APPROX. 8"X10" AREA. VERIFIED REPAIR IS A CATEGORY A REPAIR, NO FUTHER ACTION REQUIRED.SDR SWAA2026012757979Angle · crackedCRACKED ANGLE ON ACCCESS PANEL 834DZ OF THE ENTRY DOOR. REPLACED THE ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 411A2119, SHEET 72, REV-. MEASUREMENT OF CRACK: L=0.453 INCH.SDR SWAA2026012757980Angle · crackedCRACKED ANGLE OF ACCESS PANEL 844DZ OF DOOR GALLEY AT AFT GALLEY AREA. REPLACED THE ACCESS PANEL ANGLE ON GALLEY DOOR AREA DUE TO NO FOUND ALLOWABLE DAMAGE FOR CRACK IAW SRM 52-10-02-1A-4, SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 411A2119, SHEET 71, REV-.