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 AALA202601153423Light · no testAIRCRAFT WAS NOT GROUNDED: SEAT 14 ABC EMERGENCY LIGHT FOUND INOPERATIVE DURING EMERGENCY LIGHT TEST. (OPEN).SDR AALA202601153886Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: ISLE OVERHEAD EMERGENCY EXIT LIGHTS AT MID LOCATION HAVE MULTIPLE INOP BULBS. MAINTENANCE REPLACED THE MID LIGHT BULBS IAW AMM 33-51-16.SDR AALA202601159844Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: ISLE OVERHEAD EMERGENCY EXIT LIGHTS AT FORWARD LOCATION HAVE MULTIPLE INOP BULBS. FORWARD FACING SIGN. MAINTENANCE REPLACED THE FORWARD LIGHT BULTS IAW AMM 33-51-16.SDR AALA202601154343Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: NLG SHOCK FAULT ON CLIMB. DECESION MADE TO RETURN TO ORD, NO EMERGENCY DECLARED AND AIRCRFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NLG PROX SENSOR TARGETS FOR PROX SENSORS 24GA AND 25GA OUT OF ADJUSTMENT AND REPLACED NLG PROX SENSORSSDR AALA202601150679Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR OVERHEAD EMERGENCY LIGHT BULB OUT. MAINTENANCE REPLACED LIGHT BULB IAW AMM 33-51-11.SDR AALA202601152197Epsu · no testAIRCRAFT IN BASE MAINTENANCE: UNIT FAULT EPSU-EMERGENCY POWER SUPPLY UNIT ON POSITION EMERGENCY EXIT RH SIDE. MAINTENANCE REPLACED UNIT FAULT EPSU-EMERGENCY POWER SUPPLY UNIT ON POSITION EMERGENCY EXIT RH SIDE IAW A320 AMM 33-51-38-000-001-A, AMM A320 33-51-38SDR AALA202601153841Acm · seizedAIRCRAFT WAS GROUNDED: IN FLIGHT JUST AFTER T/O, FA AT 3R HEARD LOUD BANG AND SMELLED BURNING ELECTRICAL SMELL. QRH FOR SMOKE AND FUME COMPLETED. DECESION MADE TO RETURN TO JFK. EMERGENCY DECLARE AND AIRCRAFT LANDED OVERWEIGHT WITHOUT INCIDENT. MAITNENANCE REPSDR AALA202601150103Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM #1 ELEVATOR ON LH HORIZONTAL STABILIZER. REPLACED HINGE ARM #1 ELEVATOR ON LH HORIZONTAL STABILIZER IAW A320 FAM AMM 55-16-42-000-001-A AND IAW A320 FAM AMM 55-16-42-400-001-A.SDR AALA202601150352Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: ISLE OVERHEAD EMERGENCY EXIT LIGHTS AT AFT LOCATION HAVE MULTIPLE INOP BULBS. AFT FACING SIGN. MAINTENANCE REPLACED THE AFT LIGHT BULBS IAW AMM 33-51-16.SDR AALA202601156877Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSY BETWEEN BS 500C AND BS 500D AT RBL 26. REPLACED BAFFLE ASSY IAW AARD 51-00-05-1.SDR AALA202601158126Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STAB RIB, THIRD STIFFENER BACK FROM FRONT SPAR, LOCATED AT STAB STA 166.30, REPAIRED RIB IAW SRM 55-10-09-2R-4.SDR DALA2026011500349Trunnion · corrodedCOMPLIED WITH PRI 631159-14 REV 0,1,2,3 AND 4 RT WING / MLG FWD TRUNNION SUPPORT FITTING / LOWER BORE CORROSION TO REPLACE FITTING. REPLACED FITTING PER ERA 631159-14 AD REV ORIG. (7802302)SDR DALA2026011500348Wedge · debondedTWO DISBONDS (1.- 1.75IN X 1.5IN, 2.- 1.5IN X 1.3IN) AT OSS 383 UPPER SURFACE, LE SLAT 4 TRAILING EDGE WEDGE. UPPER SURFACE, LE SLAT 4 TRAILING EDGE WEDGE WAS REPAIRED PER B757-200 SRM 51-70-10-2R PROCEDURE REPAIR GENERAL WITH REFERENCE TO B757-200 SRM 57-43SDR CALA2026011512972Window Frame · crackedL3 WINDOW FRAME, 5TH HOLE UP FROM BOTTEM CRACKED. PERFORMED REPAIR ON L3 WINDOW FRAME IAW EO 250467 REV. P1, EO 250467 REV. P2, EO 250467 REV. P2 RED LINE, EO 250467 REV. IR AND EC/RA 5310-08766.SDR CALA2026011412970Lamp · inoperativeEXTERIOR EMERGENCY LIGHT AT DOOR L2 INOP - EMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - RELAMPED EXTERIOR L2 DOOR EMERGENCY LIGHT.REF AMM 33-51-04-960-801. OP'S CHECKED GOOD.PARTS USED: 99-3351-3-0014, QTY :1SDR CALA2026011412968None · noneBIRD STRIKE AT ROTATION NO ABNORMAL ENG INDICATI SLIGHT SMELL IN FWD CABI N M&L UPDATE PERFORMED BIRDSTRIKE INSPECTION RAN PACKS NO SMELL 05-51-18 NO DAMAGE NOTHING ABNORMALSDR DXTA2026011506537Hand Rail · damagedMAIN PASSENGER DOOR RAILING STUCK IN THE UP POSITION. DOOR CAN'T CLOSE. REMOVED DAMAGED HANDRAIL (P/N 1005210201-001 S/N E12) AND HANDRAIL FITTING. INSTALLED NEW CUSTOMER SUPPLIED HANDRAIL (P/N 1005210201-001 S/N T2PL6D00DKNBV) AND HANDRAIL FITTING. WORK PERSDR AALA202601155760Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE AT BS 663.5, LBL 37. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202601141613Bulb · missingAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHTS R1 DOOR HAS SEVERAL MISSING BULBS. RELAMPED EMERGENCY LIGHT AT R1 DOOR PER AMM 33-51-26 & 33-50-00.SDR SWAA2026011461278Starter · faultedNR 2 ENGINE POSSIBLE HUNG START. NO LIGHT OFF. N2 AT APROX 20%. SMOKE OBSERVED BY GROUND CREW. NO SMOKE IN CABIN. GROUND CREW INFORMED PILOTS THAT SMOKE DISIPATED. NO OTHER ABNORMAL INDICATIONS OR ENG FIRE LIGHT OBSERVED IN COCKPIT. ENG START LEVER NR 2 NEVESDR SWI2026F00077Engine · malfunctionedNUMBER 1 ENGINE STUCK AT 70% N1 WITH THRUST LEVER AT IDLE. ENGINE 1 INDICATED MCT DURING THIS TIME. NO CAUTION MESSAGE, NO WARNING MESSAGE. WE CYCLED THE THRUST LEVER BY MOVING IT FORWARD AND BACK TO UNBIND THE THRUST LEVER CABLE. I DID NOT FEEL ANY BINDING ORSDR SWI2026F00076Warning Message · illuminatedANTI ICE DUCT WARNING ON CLIMB OUT OF DEN. QHR CLEARED THE MSG AND WE DIDN`T NEED TO USE THE ANTI ICE AFTER THAT. (FLIGHT 5366) OPENSDR SWIA2026011400003Frame · mechanic errorMISDRILLED HOLE ON THE REAR SPAR FRAME SECTOR FS797.00, AT LBL36. (OPEN)SDR ASAA2026011363744Battery Pack · no testWHILE PERFORMING T.C. #78233001, BATT PACKS FAILED EMERGENCY LIGHTS FUNC TEST. GROUNDED - YES. REMOVED AND REPLACED BATT PACKS X3 AT L1, R2, AND LH AFT MID CABIN POS, IAW AMM 33-51-06-960-805. NEW UNITS FROM STOCK CHECKS GOOD. ALSO, RELAMPED FWD AND AFT GALLEYSDR JJBA20250114036Shear Tie · crackedRF1, SHEAR CLIP ON FR62 BTW STR 6R-8R FOUND CRACKED. RF1, SHEAR CLIP ON FR62 BTW STR 6R-8R REMOVED AND REPLACED.SDR DALA2026011400337Power Supply · failed17WL EPSU FAILED (L/H OVERWING) ROWS 25, 26, 22-17, 15-13, 3, 4 EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: REPLACED 17WL IAW A321 AMM 33-51. OPS CHECK GOOD. (LP 7014872)SDR JJBA20260114033Mount · corrodedRADIO ALTIMETER #2 FORWARD MOUNT HAS CORROSION. REMOVED AND REPLACED RAT #2 EXTERNAL ANTENNA MOUNT AND NEW RAT #2 INTERNAL ANTENNA MOUNT.SDR JJBA20260114029Support · crackedRIGHT MLG WHEEL WELL AFT VERTICAL SUPPORT IS CRACKED AT OB UPPER CORNER. COMPLIED WITH REPAIR TO RIGHT MLH WHEEL WELL AFT VERITCAL SUPPORT.SDR IPXA2026011477249Flap System · faultedFLAP/SLAT ELEC STATUS MESSAGE TRAILING EDGE FLAPS DISAGREE EICAS RAN CHECK LIST LANDED FLAP 20*. ACCOMPLISHED ADJUSTMENT OF FLAP SYSTEM IAW AMM 27-51-00-825-007.REMOVED AND REPLACED FLAP POSITION INDICATOR IAW AMM 27-58-02-004-001 DUE TO A FAULTY (L) NEEDLE SDR JJBA20260114028Gusset · corrodedFWD WET AREA 1EA LT OMEGA BEAM GUSSET HAS CORROSION FROM FR 18 TO FR 23, HAS CORROSION. REMOVED AND REPLACED FWD WET ARE LH OMEGA BEAM GUSSETSDR DALA2026011400336Proximity Sensor · dirtyL2 DOOR INDICATION INOPERATIVE. SHOWS OPEN WHEN DOOR IS CLOSED. CLEANED PROX MECHANISM PER A339 AMM 52-71-11. OK FOR SERVICE. (8207440)SDR DALA2026011400335Skin · damagedFUSELAGE SKIN AND STRINGER 3R AT FR 61, FR 62 DAMAGED HOLES AND TOOLING DAMAGE. CORRECTED PER ERA 627795-14 REV A. (1400731)SDR DALA2026011400333Stringer · damagedSTRINGER 2R AT FR 61, FR 62, FR 63, FR 64 TOOLING DAMAGE AND DAMAGED HOLES. CORRECTED PER ERA 631409-14. (1400422)SDR DALA2026011400332Stringer · damagedSTRINGER 2L AT FR 60, FR 62, FR 63, FR 64 TOOLING DAMAGE AND DAMAGED HOLES. CORRECTED PER ERA 631408-14. (1400327)SDR DALA2026011400331Stringer · damagedSTRINGER 1R AT FR 62, FR 63 AND FR 64 TOOLING DAMAGE AND ELONGATED HOLES. REPAIRED PER ERA 631405-14. (1400310)SDR DALA2026011400330Stringer · damagedSTRINGER 1L AT FR 62, FR 63 AND FR 64 TOOLING DAMAGE AND ELONGATED HOLES. REPAIRED PER ERA 631407-14. (1400286)SDR DALA2026011400329Stringer · damagedCOLLECTOR CARD FOR ALL DISCREPANCIES ON STR 1R FROM FR 60-64 IN THE VIASAT MOD AREA. ALL AREAS REPAIRED PER ERA 631405-14 REV ORIGINAL. (1400773)SDR DALA2026011400328Inspection · noneAS PART OF THE CONTINUED EFFORT PER CASS # TOP/7201-25 TO SURVEY EACH A330 AIRCRAFT. SURVEYED AND REPAIRED AC 3312 PER ERA 628335-14. (1400768)SDR DALA2026011400327Inspection · noneTOP/7201-25 TO SURVEY EACH A330 AIRCRAFT ACCOMPLISHED BY LAUNCH MAINTENANCE IN MSP, ER/A 628335-14 HAS BEEN CREATED TO NOW SURVEY A/C 3312. SURVEYED AND REPAIRED. (1400760)SDR AALA202601140298Elec Connector · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAP GAGE SHOWED FLAP ASYMMETRICINDICATION, CYCLED HANDLE BUT NO MOVMENT ON THE GAGE. AIRCRAFT EMERGENCY LANDED SAFELY AT ORD. REMOVE AND REPLACED NUMBER 5 INBOARD FLAP INBOARD SKEW SENSOSDR AALA202601144384Oven · smokeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB ELECTRICAL SMOKE ODOR NOTICE IN FLIGHTDECK AND CABIN. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. ACCOMPLISHED W/C 08L00021001. FOUND NUMBER 2 OVEN OMITTING ELECTRICAL ODOR. RSDR AALA202601142239Sensor · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAP GAGE SHOWED FLAP ASYMMETRICINDICATION, CYCLED HANDLE BUT NO MOVMENT ON THE GAGE. AIRCRAFT EMERGENCY LANDED SAFELY AT ORD. REMOVE AND REPLACED NUMBER 5 INBOARD FLAP INBOARD SKEW SENSOSDR REXA2025011401094Bulkhead Web · corrodedCORROSION FOUND ON BS 280 RT BULKHEAD LOWER WEB. REPAIRED FS 280.00 R/H LOWER WEB IAW SRM 53-11-10-201-004-A01.SDR REXA2025011401093Bulkhead Web · corrodedCORROSION FOUND ON BS 280 LT BULKHEAD LOWER WEB. INSTALLED BS 280 LT CAP ANGLE IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, AND SRM 51-42-22-001-001-A01. FABRICATED, LOCATED AND DRILLED NEW REPAIR PARTS, LHS LOWER WEB, AND LT BUTTSTRAP, IAW SRM 53SDR FDEA202601130031Thrust Bracket · damagedEXISTING REPAIR ON FUSELAGE MAIN DECK CARGO COMPARTMENT FR 26 - FR 27 THRUST BRACKET WEB BETWEEN -Y450 AND -Y953 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON FUSELAGE MAIN DECK CARGO COMPARTMENT FR26-FR27 THRUST BRACKET WEB BETWEEN -Y450 AND -SDR FDEA202601130028Engine · contaminatedACRID FUME DETECTED DURING INITIAL TAKE OFF DISSSIPATED ON LANDING. REF TSI 79-01/6870 FOR T/S WORK PERFORMED. SUSPECT NR 1 ENGINE BLEED DUCTING STILL CONTAMINATED FROM PREVIOUS ENGINE. PERFORMED AIR CONDITIONING SYSTEM OIL SMOKE/FUMES CONTAMINATION REMOVAL SDR SIMA20260113001Handle · lack of lubeR2 DOOR HANDLE HARD TO MOVE. CLEANED AND LUBED R2 PAX DOOR HANDLE IAW AMM 12-29-00. OPEN AND CLOSE GOOD .SDR YENA2026011400037Unknown · odorFLT 2023, BOS- STI. ABNORMAL FUEL SMELL FROM AFT GALLEY TO ROW 21 DURING LANDING. APU WAS STARTED 1 MIN PRIOR TO LANDING. COMPLIED WITH INFO NOTICE 2017-T015 SECTION B ODOR IDENTIFIED AS TYPE 10 MISC LEVEL 1 PER TSM 05-50-00-810-805-B.SDR CALA2026011412943Unknown · odorFLIGHT ATTENDANTS AND PILOTS REPORTED ELECTRICAL ODOR FROM ROWS 1 THROUGH 29. ODOR QUICKLY DISAPATED. PERFORMED CONDITIONAL INSPECTION IAW AMM TASK 05-51-26-800-801-C1, NO DEFECTS NOTED, NO PRESENT ODOR. SUSPECT POSSIBLE PASSENGER PED AT FAULT.SDR AALA202601142037Actuator Valve · inoperativeAIRCRAFT WAS NOT GROUNDED: FUEL CENTER LEFT TRANSFER FAULT ECAM AFTER TAKEOFF. FLIGHT CREW EXECUTED ECAM PROCEDURE BUT THE LEFT CENTER PUMP STILL DID NOT WORK. MAINTENANCE REPLACED THE CENTER TANK PUMP ACTUATOR VALVE 11QL AND ACCOMPLISHED A SATISFACTORY OPERAT