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 SWAA2026011460223Bulb · burned outAFT LOWERED CEILING EXIT SIGN HAS BURNT OUT BULB ON THE RT SIDE. REMOVED AND REPLACED AFT LOWERED CEILING EXIT SIGN RT MOST OTBD BULB IAW AMM 33-51-01-960-801 AND AIPC 33-51-01-50D. PERFORMED OPS CHECK, OPS CHECK IS GOOD.SDR SWIA202601140001Stop Fitting · crackedMCD UPPER FORWARD STOP BRACKET AT THE 11 O'CLOCK POSITION IS CRACKED. REMOVED AND REPLACED MCD UPPER FORWARD STOP BRACKET AT THE 11 O'CLOCK POSITION IN REFERENCE TO CRJ200 SRM 51-42-21. COMPLIED WITH TASK CARD 51-900-1003-SKY AND COMPLETED M-337.SDR ASAA2026011162827Indicator · failedLANDING GEAR POSITION INDICATING POPPED AFTER T/O. ATB. GROUNDED - YES. REMOVED AND REPLACED NOSE LANDING GEAR POSITION INDICATOR CAP PER FIM 32-60 TASK 803. RTS PASSED. OK FOR SERVICE. OPS TEST OF THE LANDING GEAR POSITION INDICATOR PASSED PER 32-61-06-700-80SDR DALA2026011400344Filter · odorATB- PERFORMED AN AIR TURN BACK DUE TO ODOR IN THE CABIN AFTER TAKEOFF. TROUBLESHOT PER MSI WORKCARDS. FOUND EVIDENCE OF DE-ICE FLUID IN BOTH ENGINE INLETS. PERFORMED ECS DUCT DECONTAMINATION AND REPLACED RECIRC FILTERS. PERFORMED ENG RUNS NO ODORS PRESENT. SDR IPXA2026011154938Warning Message · illuminatedEMERGENCY DECLARED. CARGO DOOR INDICATION EICAS ITEM PLACED ON MEL 52-71-1-2 ACCOMPLISHED DMP AND PLACARD INSTALLEDSDR CALA2026011412962Hmu · faultedN1 ON ENG 1 DIDNT SPOOL UP, PERFORMED EEC BITE, TEST PASSED WITH NO FAULTS. ONLY FAULT SHOWING WAS 10 FLT CYCLES HPT ACC. PERFORMED ENG ACCELERATION CHECK IAW AMM 71-00-00-700-824-F00, FOUND NR 1 ENG SLOW TO SPOOL AS COMPARED TO NR 2 ENG. TOOK BOTH THOTTLES SDR CALA2026011412941Acm · seizedLEFT PACK LIGHT ILLUM AFTER LANDING. RAN QRC & LIGHT STILL ON. LT PACK LIGHT COMES ON WHEN LT PACK IS RUNNING. LT PACK LIGHT EXTINGUISHED, ECS PACK LITE IS OFF WHEN SWITCH IS OFF, RESET PACK LIGHT & RAN LT PACK, WHILE RUNNING, BURNING ODOR IN FLT DECK, 5SDR LR7A2026011103800Skin · crackedDURING SCHEDULED INSPECTION, FOUND CRACK ON THE RT OTBD FLAP LOWER SKIN. REPAIRED IAW SMP 583 51-140-12, & MEA 382-57-26-002. LP#59025SDR SWAA2026011360360Flashlight · inoperativeCAPTAIN`S COCKPIT FLASHLIGHT INOPERATIVE. R & R CAPTAIN`S FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026011360354Light · inoperativeCAPTAIN`S SIDE EMERGENCY EXIT LIGHT IS INOPERATIVE. PERFORMED AN OPS TEST OF EMERGENCY LIGHTS IAW AMM 33-51-00. OPS TESTED GOOD.SDR SWAA2026011360345Battery Pack · inoperativeL2 DOOR INTERNAL AND EXTERNAL EMERGENCY LIGHTS INOP. REMOVED AND REPLACED L2 DOOR EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR DALA2026011300323Battery · inoperativeON SERVICE CHECK, FOUND LT OVERWING SLIDE EXIT LIGHTS, FWD OVERWING DOOR "EXIT", AND ROWS 25-28ABC EMERGENCY EXIT LIGHTS INOP. R/R BATTERY M11383, OPS NML B757 AMM 35-51. (4750211)SDR DALA2026011300321Snubber · out of toleranceOUT OF LIMITS EXTENSION PIN ON SNUBBER AT R2 DOOR. ROTARY SNUBBER AT R2 DOOR WAS REPLACED PER B757-200 AMM 52-11-10 // AMM 52-11-01. (1397325)SDR AALA202601137921Sign · dislodgedAIRCRAFT WAS NOT GROUNDED, L1 DOOR EXIT SIGN DISLODGED. REINSTALLED EXIT SIGN IAW AMM 33-51-00.SDR AALA202601133793Bracket · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON DOOR 1R BRACKET IS LOOSE. SECURED GIRT BAR ON R1 DOOR. PER AMM 25-66-01.SDR AALA202601130879Bulb · burned outAIRCRAFT WAS GROUNDED, FLIGHT ATTENDANTS REPORTED AN ODOR SMELLING LIKE BURNING WIRE COMING FROM THE AFT LEFT GALLEY. BELIEVED TO BE ORIGINATING FROM THE PLASTIC COVER ON THE NO SMOKING AND SEAT BELT SIGN ABOVE BIN 525. DURING TROUBLE SHOOTING JC 08L00021001SDR AALA202601130272Handle · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK IS STIFF AND DIFFICULT FOR PASSENGERS TO OPERATE. LUBED DOOR HANDLE. OPS CHECKED GOOD.SDR DALA2026011300316Flag · missingL1 DOOR ARM FLAG AT DOOR MISSING. INSTALLED 1L DOOR ARMED FLAG IAW AMM 52-73. OPS CHK NML (7910487)SDR WX0A2026011332699Battery · faulted(AIRCRAFT NOT GROUNDED) F.A. FLASHLIGHT #2 NOT BLINKING. / REPLACED AFT LH FA FLASHLIGHT BATTERY REF. CMM 25-60-02. OPS CHECK GOOD"SDR WX0A2026011332698Latch · broken(AIRCRAFT NOT GROUNDED) FOUND AFT RH DOOR SLIDE COVER MISSING LENS AND LATCH BROKEN. REMOVED AND REPLACED AFT RT DOOR SLIDE COVER IAW AMM 25-62-44-400-802-A. THIS CLEARS NEF 25-1A-4C CTRL 225320. INOP PLACARD REMOVED.SDR WX0A2026011332697Unknown · odor(AIRCRAFT NOT GROUNDED) AFT FA SMELLED DIRTY SOCK SMELL AT TOP OD DECENT (FL370) THE SMELL LASTED ABOUT 5 MINUTES THEN DISSAPATED / PERFORMED T/C 21-000-001 APU DEFERRED REF AML# 2064038 M313 TO PERFORM LEVEL 2 REF AML# 2064039 A/C OK FOR SERVICED. REF MEL 49-SDR DALA2026011300308Proximity Sensor · faultedDOOR RT AFT CABIN ILLUMINATED. ADJUSTED PROX SENSORS PER A330 AMM 52-71-11-820-801-A. OK FOR SERVICE. (1397071)SDR AALA202601131315Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601133684Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601134895Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601137552Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601130303Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601134093Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR YENA2026011300033Unknown · odorFLT 1199 LGA- MCO. STRONG CABIN ODOR ROW 17 AND BACK BELOW 10,000 FEET AND DESCENDING ENG'S AT IDLE AND APU OFF. COMPLIED WITH INFORMATION NOTICE 2017-T015, STEP 1. ISOLATED FAULT TO TYPE 10. DECONTAMINATION LEVEL A WAS ACCOMPLISHED PER AMM 21-00-00-615-802-SDR YENA2026011300032Unknown · odorFLT 161 BOS-SJU. INFLIGHT SMELLED FUMES (DIRTY SOCK) AT 3000FT IN DECENT ROWS 7 & AFT CABIN. COMPLIED W/ ODOR REMOVAL PROCEDURE FROM FCOM1 UPON DEPLANING, MID CABIN FA SMELLS BURNING NEAR 3R DOOR.; COMPLIED WITH INFORMATION NOTICE 2017-T015, STEP 1. ISOLATED SDR CALA2026011312921Floorbeam · corrodedAFT WET AREA AT BS 947.5, LBL 20 TO LBL 23. FLOORBEAM HAS CORROSION ON SURFACE AREAS. REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-40-02-0G-0 AND DWG 147A5650.SDR CALA2026011312920Window Post · crackedFOUND A CRACK AT THE L3 WINDOW FRAME POST AT HOLE NR 3 DIRECTION 3 O'CLOCK POSITION IAW EA 5310-08195, REV C. PERFORMED REPAIR TO THE L3 WINDOW FRAME E-F POST IAW EC/RA 5310-08765.SDR SCNA20260113026Anchor Nut · damagedDAMAGE ANCHOR NUT 1EA OF SUPPORT OF SLIDE ON INTERNAL STRUCTURE OF AFT ENTRY DOOR . NUT 1EA OF SUPPORT OF SLIDE ON INTERNAL STRUCTURE OF AFT ENTRY DOOR WAS REPLACED IAW SRM 51-40-02-0G-0SDR DXTA2026011306507Outflow Valve · faultyON DEPARTURE CABIN WAS NOT PRESSURIZING AND THE RATE OF CLIMB INDICATOR WAS MIRRORING THE AIRCRAFTS VERTICAL SPEED. WE TRIED MANUAL PRESS AND THE CHERRY PICKER WITH NO SUCCESS. MASKS DID NOT DEPLOY WE NEVER EXCEEDED 6000' AND WE WERE UNDER MAX LANDING WEIGHT FSDR DXTA2026011306521Hand Rail · out of adjustMAIN ENTRANCE DOOR HANDRAIL IS HITTING THE DOOR AND CAUSING DAMAGE WHEN DOOR IS CLOSED. WHEN DOOR IS OPEN, HANDRAIL IS LOWER THAN NORMAL. HANDRAIL IS ONE OR TWO GEAR COGS OFF FROM BEING IN THE RIGHT POSITION. REMOVED LOWER HAND RAIL GEAR AND REPLACED WITH ASDR YENA2026011300024Relay · faultedFLT 1107, JFK-LHR (ETOPS). AIR BLEED MX MAINTENANCE MESSAGE AFTER PUSHBACK, I MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1, FAULTS INDICATED BY AIR BLEED.; (RESOLVED ON W/O: 1469094 TASKCARD: NR-00001 ) C/W TSM 36-11-00-810-993 SDR AALA202601129996Computer · failedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: TERRAIN FAILED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED (GPWC)-GROUND PROXIMITY WARNING COMPUTER. PER AMM 34-46-01. OPERATIONAL CHECK GOOD.SDR AALA202601121362Flt Controls · malfunctionedAIRCRAFT WAS GROUNDED, AN EMERGENCY WAS NOT DECLARED DUE TO: FLIGHT CONTROL SYSTEM-B LOW PRESSURE INDICATION LIGHT CAME ON DURING CLIMB OUT. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT AUS. PERFORMED CHECK OF FLIGHT CONTROL SYSTEM-B LOW PRESSURE LIGSDR DALA2026011200297Door · inflt separationFOUND ON ARRIVAL - HIGH PRESS PNEUMATIC ACCESS DOOR DEPARTED A/C CAUSING DAMAGE TO FUSELAGE IN 2 LOCATIONS. CORRECTIVE ACTION: DAMAGE IS OUT OF LIMITS PER B757 SRM 52-40-02-1A PROC. 2. COMPLIED WITH ERA 631645-14 REV ORIGINAL SECTION 1. TIME LIMITED REPAIR. RESDR DALA2026011200296Oil System · leakingSMKE/FUME- ON TAXI OUT CREW REPORTED FLIGHT DECK FILLED WITH NOTICEABLE HAZE AND SMOKE. FOUND APU OIL LEAK AT GEN SEAL AND OIL QTY XMTR. REPLACED GEN AND XMTR SEAL. INSPECTED APU BLEED DUCT AND PACK HEAT EXCHANGERS FOR CONTAMINATION, NONE FOUND. CHECKED CABINSDR SWIA2026011200001Stop Fitting · crackedMCD UPPER FORWARD STOP BRACKET AT THE 11 O'CLOCK POSITION IS CRACKED. OPENSDR SWAA2026011260344Unknown · odorF/A REPORTED ELECTRICAL BURNING ODOR ROWS 7-11 FOR 30 MINUTES IN FLIGHT, NO VISIBLE SMOKE. PERFORMED CONDITIONAL INSPECTION IAW AMM 05-51-56. NO FAULTS FOUND ACFT OK FOR SERVICE.SDR SWAA2026011260498Pump · faultedNUMBERR 1 ELEC HYD PUMP OVERHEAT LIGHT ILLUMINATED. PERFORMED QRH STEPS. APPROX 30 MINUTES LATER PILOTS NOTICED DROP WITH NR 1 HYD QTY OF 1% EVERY 15 SECOND AND PRESSURE DECREASING . LANDING NORMAL. R & R NR 1 ENG EDP PER AMM 29-11-11. R & R NR 1 ENG CASE SDR SWAA2026011260528Filter · faultedNUMBER 1 ELEC HYD PUMP OVERHEAT LIGHT ILLUMINATED. PERFORMED QRH STEPS. APPROX 30 MINUTES LATER PILOTS NOTICED DROP WITH NR 1 HYD QTY OF 1% EVERY 15 SECOND AND PRESSURE DECREASING. LANDING NORMAL, R & R NR 1 ENG EDP IAW AMM 29-11-11. R & R NR 1 ENG CASE DSDR SWAA2026011260358Lens · missingFORWARD FACING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED FWD EMERGENCY EXIT LENS IAW SIP.SDR DALA2026011200288Bottle · low pressureR4 DOOR PRESSURE MESSAGE. SERVICED DOOR ASSIST BOTTLE IAW AMM 52-15. (7978162)SDR DALA2026011200270Bracket · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON BRACKET NUMEROUS AREAS/ OUTBOARD LEG DEFORMED P'4. REPAIRED PER ERA 631298-14. (1396580)SDR DALA2026011200269Bracket · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE 3 PLACES ON BRACKET AT P4. REPAIRED IAW ERA 631298-14. (1396575)SDR DALA2026011200268Lug · corrodedCORROSION WAS FOUND ON THE RT WING RIB 6 FITTING, FORWARD LUG. REPAIRED IAW ERA 631097-14. (1397256)SDR DALA2026011200267Lug · corrodedCORROSION WAS FOUND ON THE RT WING RIB 6 FITTING FORWARD LUG. REPAIRED IAW ERA 631097-14. (1397247)