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 HYIA20251027001Fitting · corrodedDURING MAINTENANCE A SMALL AREA OF SURFACE CORROSION WAS VISUALLY IDENTIFIED ON THE TOP FACE OF THE VERTICAL LEG OF THE 0822550-43 WING ATTACH FITTING (LT LOWER AFT). THIS CORROSION MEASURES APPROXIMATELY 1.5 INCHES LONG, BY .125 INCHES WIDE WITH AN APPROXIMATSDR IPXA2025102735405Container · misinstalledAPG FOUND L-1 DOOR EVACUATION SLIDE CONTAINER NOT INSTALLED PROPPERLY ATA 25-61. OPENSDR UIEA2025102401278Skin · damagedAIRCRAFT STRUCK BY LIGHTNING. LIGHTNING STRIKE DAMAGE FOUND ON R/H INLET COWL 3:00 POSITION(<P>PERFORMED PHASE 1 LIGHTNING STRIKE INSPECTION IAW B767 AMM 05-51. R/H ENGINE COWL DAMAGE FOUND WITHIN LIMITS IAW SRM 54-15-01-1A-1. NO FURTHER DEFECTS NOTED</P>)SDR GTIA2025102739149Knob · inoperativeFWD FA MEGAPHONE VOLUME KNOB INOP-REPLACED FWD MEGAPHONE IAW AMM 25-65-51 OPS CK OK MOC 66906 AP 5183437SDR DALA2025102707890Indication Sys · malfunctionedSHIP 1708 AFT LT DOOR SLIDE LIGHT STAYS ON WITH SLIDE DISARMED. CORRECTIVE ACTION: EXERCISED ARM LIGHT ASSY AT DOOR AND AT MAIN PANEL AT L-1 OPS CKNORMAL MEL PLAC REMOVED NO M PROC ACOK FOR SERVICE (8005982)SDR DALA2025102707888Light · inoperativeSHIP 180 WHITE SEAT MOUNTED EPATH LIGHT INOP AT 49 RIGHT. CORRECTIVE ACTION: PERFORMED OPS CHECK OF SEAT 49B AND 49F EMERGENCY LIGHTS AS PER B767-300 AMM 33-51, OPS CHECK OK. (7923569)SDR DALA2025102707887Indicator · damagedSHIP 1707 SLIDE INDICATOR LIGHT INOP OR DAMAGED / LOCATIONS:601. CORRECTIVE ACTION: REISTALLED 1L DOOR ARMING LIGHT COVER REF B767 AMM 52-71. (1268425)SDR AALA202510270680Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510271159Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT JUMPSEAT 4L FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUES NOTED.SDR AALA202510274921Transceiver · inoperativeAIRCRAFT IN BASE MAINTENANCE: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING THAT THE RADAR NOT WORKING IN AIR. IT SHOWED GROUND CLUTTER BUT NO RADAR RETURN WITH STORMS IN FRONT OF US. RADAR LOOKED PIXILATED LIKE ITSDR AALA202510275870Vent Line · cokedAIRCRAFT WAS NOT GROUNDED: PASSING THROUGH 10K FT, SMELLED AN OILY MUSTY ODOR, AFTER LANDING & AT THE GATE THE ODOR INTENSIFIED. APU TURNED ON AFTER LANDING & ODOR OF OIL/MUSK INCREASED MORE. AFTER OPENING DOOR, ODOR DISSIPATED, BUT REMAINED AFTER DOOR REMAISDR AALA202510279456Door Seal · looseAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO HNL DUE TO THE FLIGHT CREW REPORTING AN EXTREMELY LOUD SQUEAL COMING FROM FORWARD GALLEY DURING CLIMB OUT. IT WAS AUDIBLE AS FAR BACK AS ROW 25 AND BRIEFLY IN THE FLIGHT DECK. THSDR AALA202510272482Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510278016Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510277133Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510273738Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510272427Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR DALA2025102707872Floorbeam · corrodedSHIP 3317 CORROSION WAS FOUND IN THE BULK CARGO COMPARTMENT FLOOR STRUCTURE LONGITUDINAL BEAM AT FR 69, Y=0. CORRECTIVE ACTION: COMPLIED WITH ERA 629815-14. (1269419)SDR DALA2025102707857Circuit Breaker · trippedSHIP 693 SLIDE ARM LIGHT INOP ON ALL DOORS. CORRECTIVE ACTION: FOUND C/B POPPED FOR GIRT BAR IND PUSHED IN NO FAULTS FOUND. (7715284)SDR DALA2025102707856Indicator · faultedSHIP 693 3R DOOR KNUCKLE KNOCKER DOES NOT RETRACT WHEN DOOR IS ARMED. CORRECTIVE ACTION: ADJUSTED KNUCKLE KNOCKER AS NEEDED. OPS NORMAL REF: B757 AMM 25- 66. (1269156)SDR DALA2025102707853Slide · low pressureSHIP 6713 SLIDE OF DOOR R4 GAGE NEEDLE OUT OF GREEN BAND. CORRECTIVE ACTION: R4 SLIDE WAS REMOVED AND REPLACED REF AMDS 2566-9001-4R.SDR DALA2025102707851Charger · inoperativeSHIP 5650 EMERGENCY FLOOR PATH LIGHTS INOP ROW 3-7 D/C. CORRECTIVE ACTION: R/R BATTERY PACK CHARGER (M732) IAW B757 AMM 33-51. OPS CHECK NML. (6583427)SDR DALA2025102707848Seat Track · damagedSHIP 5657 LH SEAT TRACKS BOTH INBD AND OUTBD HAS SCRATCHES AN SMALL GOUGES , JUST AFT OF STA 1100. TAG 83615. CORRECTIVE ACTION: REPAIRED DAMAGED SEAT TRACK STA 1100 L/H I/B IAW BOEING 757-200 SRM 53-00-52-2R-1. SEE CONTINUATION SHEETS FOR ALL WORK ACCOMPLISHESDR DALA2025102707847Seat Track · damagedSHIP 5657 LH SEAT TRACKS BOTH INBD AND OUTBD JUST FWD OF STA 1180 HAS SCRATCHES AN SMALL GOUGE. TAG 83612. CORRECTIVE ACTION: L/H IB SEAT TRACK DAMAGE WAS REMOVED AND FOUND TO BE WITHIN LIMITS WITH .015 MATERIAL LOSS. IAW B757-200 SRM 53-00-52 O/B SEAT TRACK FSDR DALA2025102707835Microphone · inoperativeOBSERVER'S O2 MASK MICROPHONE INOPERATIVE. RESEATED MICROPHONE CONNECTOR ON OBSERVER O2 MASK OPS NORMAL. (7710498).SDR DALA2025102707830Seat Track · corrodedCORROSION SEAT TRACK +Y1292 LOCATED FROM FR12 TO FR24 AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED SEAT TRACK Y1292 LOCATED FROM FR12 TO FR24 AT GALLEY AREA AS PER A319 SRM 51-72-11 AND A319 SRM 51-42-11. (1269662).SDR AALA202510273216Squib · unserviceableAIRCRAFT WAS NOT GROUNDED: UNSERVICEABLE APU FIRE BOTTLE SQUIB IAW W/C 72C10005002 (DOM 03/16). MAINTENANCE REPLACED APU FIRE BOTTLE SQUIB. INSTALLATION TEST GOOD IAW AMM 26-22-02. (DOM 12/16).SDR AALA202510270841Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: ** DOOR 5 RH EMER CEILING LT ( BESIDE MASTER CALL LT ) INOP. **. DOOR 5 RH EMER CEILING LIGHT ( BESIDE MASTER CALL LIGHT ) MAINTENANCE REPLACED BULB AND TESTED NORMAL AS PER AMM 33-51-03 REV 250.SDR AALA202510279661Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: R4 FA FLASHLIGHT INOP. MAINTENANCE REPLACED FA FLASHLIGHT BATTERY IAW AMM 25-64-01. OPS CK GOOD.SDR AALA202510271769Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FWD F/A JUMPSEAT IS INOP, NO RED LIGHT INDICATOR. MAINTENANCE REPLACED BATTERY IAW CMM 25-60-13. OPC GOOD.SDR AALA202510270233Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT INOP AT #3 GALLEY SIDEWALL LOWER RIGHT SIDE. MAINTENANCE REPLACED EMERGENCY ALIGHT ASSY REF AMM 33-51-06.SDR FDEA202510242090Skin · dentedRH HORIZONTAL STAB FRONT SPAR UPPER SURFACE DENT STA 159.248 APPROX FOUND DENT AT UPPER SKIN RH HORIZONTAL STA 159.248 OUT OF LIMITS DIM A= 1.500" Y=0.054" A/Y=27.77 AND REPAIRED IAW B757 SRM 55-10-01-1A TABLE I, NOTE I AND IAW B757 SRM 51-70-10- 2R REP 4SDR FDEA202510242089Skin · dentedRH HORIZONTAL STAB FRONT SPAR UPPER SURFACE HAS A DENT (STA 86.600) FOUND DENT AT UPPER SKIN RH HORIZONTAL STA 86.600, OUT OF LIMITS DIM A=1.500", Y=0.069", A/Y=21.73 AND REPAIRED IAW B757 SRM 55-10-01-1A TABLE I NOTE I AND IAW B757 SRM 51-70-10- 2R REP 4SDR DXTA2025102705435Battery · no testEMERGENCY LOGHTS STAY ON WHEN SWITCHES TO ARMED POSITION EVEN AFTER START. CORRECTIVE ACTION: GAINED ACCESS TO EMER LIGHT BATTERY AND REPLACED IAW EMB505E AMM 33-52-01. EMER LIGHT BATT #1 & #2 INSTALLED CAPACITY CHECK DATED 15 OCT 25. PERFORMED EMER LIGHTS CHESDR DXTA2025102705433Light · inoperativeTOE KICK LIGHTS UNDER SEATS 5 & 8 ARE INOP ON BATTERY POWER ALONE. REPLACED BATTERY PACK. OPS CHECK GOOD. IAW AMM 33-50-06.SDR DXTA2025102705426Battery · faultedWITH THE EMERGENCY LIGHT SWITCH IN THE ARM POSITION THE CABIN EMERGENCY LIGHTING BLINKS ON AND OFF. REMOVED AND REPLACED FORWARD AND AFT BATTERIES WITH REPAIRED UNITS AND COMPILED WITH DEPLETE AND FULL CHARGE PROCEDURE IAW AMM 33-52-01, OPS CHECK GOODSDR DXTA2025102705425Battery Pack · faultyPREFLIGHT - PORTION/ALL OF CABIN EMERGENCY LIGHTING IS INOP. HERE ARE ALL THE CONDITIONS: APU OFF -EMER LTS SWITCH IN ON (MAIN BATTERIES OFF) - ALL EMER LIGHTS FUNCTION EXCEPT THE 3 EXIT SIGNS AROUND MED AND GALLEY READ LIGHT (BULB IS GOOD) -EMER LTS SWITCH ISDR DXTA2025102705424Coalescer Bag · odorFUEL SMELL IN THE COCKPIT. WHEN THE CKPT TEMP CONTROLLER IS INCREASED, THE SMELL BECOMES MORE PRONOUNCE, TO THE EXTENT OF BOTHERING THE EYES AND HEAD. REPLACED COALESCER BAG. OPS CHECK GOOD. IAW AMM 21-51-13SDR DXTA2025102705423Selector Valve · faultedWHILE APPROACHING THE AIRPORT WE GOT A RED CAS GEAR DISAGREE MESSAGE AND A MOMENTARY RED CAS NOSE DOOR OPEN MESSAGE THAT WENT OUT WHILE RUNNING THE GEAR DISAGREE CHECKLIST. HAD UP INDICATIONS FOR THE 3 GEAR. WHILE RUNNING THE QRH FOR GEAR DISAGREE GOT TO WHERSDR SIMA20251024001Light · wornFWD ENTRY AND 1DF/2DF PHOTO LUMINESCENT STRIP LIGHTS WORN RAR FWD ENTRY AND 1DF/2DF PHOTO LUMINESCENT STRIP LIGHTS IAW ERJ 170 AMM 33-50-2/400. NO FURTHER DEFECTS NOTEDSDR CALA2025102710616Isolation Valve · faultedAIR X BLEED FAULT ON CLIMB OUT PFR SHOWS 36-12 AIR X BLEED FAULT W/ CORRELATED MSG'S 36-11-34 BMC 1 OR SOLENOID, 36-12-00 X FEED VALVE 6HV AND 36-12-00 X FEED VALVE 6HV OR CKT. ACP BMC 1 & 2 BITE CHKS GOOD ON THE GRND ALSO OPERATED X BLEED SWITCH AND ALL ECAMSDR CALA2025102710606Coffeemaker · unsecureCM106 FOUND TO BE UNLOCKED AND SLIDING OFF RAIL LOCKED COFFEE MAKER. OPS CK GOOD REF AMM 25-32-01. YSDR CALA2025102710604Coffeemaker · unsecureCM419 FOUND TO BE UNLOCKED AND SLIDING OFF RAIL LOCKED COFFEE MAKER. OPS CK GOOD REF AMM 25-32-01. FLAGGED SDR FOR SAFETYSDR CALA2025102710602Coffeemaker · unsecureCM420 FOUND TO BE UNLOCKED AND SLIDING OFF RAIL LOCKED COFFEE MAKER. OPS CK GOOD REF AMM 25-32-01.SDR CALA2025102710600Seat Track · wornFOUND WEAR MARKS MAIN CABIN SEAT TRACK UPPER CROWN EDGES L/H I/B STA 520 LBL 24.75. INSTALLED REPAIR PARTS BETWEEN STA 520 TO STA 500H & LBL 24.75" REF SRM 53-00-52-2R-4. ACCOMPLISHED INSTALLATION OF REPAIR PARTS BETWEEN STA 520 TO STA 500H & LBL 24.75" RSDR CALA2025102710598Light · brokenSEAT 4D , EMERGENCY PATH LIGHTING (EPL) BROKEN R/R THE PATH LIGHT SEAT 4D AS PER REF AMM 33-51-06. OKAY TO CONTINUE.PARTS USED: 78-3300-3-0098,QTY :1SDR CALA2025102710596Stringer · crackedINSIDE FUEL PANEL 632RB OPENING STRINGER U9 HAS CRACK IN END OF STRINGER AND APPEARS TO END AT LAST FASTENER REQUESTING ENGINEERING ASSISTANCE. SUPPORT TASK NSA EMX N/R 00074. ESFR COMPLETED REPAIRED 49 STRINGER INSIDE PANEL 632RB IAW UAL ECRA 5720-03572 REV ASDR CALA2025102710594Unknown · odorBURNING SMELL COMING FROM AFT GALLEY. NO SMOKE SEEN BUT FUMES A RE STRONG RAN ALL AFT GALLEY APPLIANCES (COFFEEMAKER, OVENS, WARMERS). RAN APU WITH BOTH PACKS ON HIGH. NO SMELL DETECTED. INSPECTED AFT CARGO PIT AND APU COMPARTMENT. NO SMELL DETECTED. FA'SSDR CALA2025102710592Skin · corrodedFOUND CORROSION R-1 DOOR ASSY LOWER GATE EXTERNAL SKIN AREAS WITH CORROSION. REMOVED AND REPLACED R1 DOOR LOWER GATE ASSEMBLY REF. SRM 51-40-02-0G-0 AND DWG 141A6516.SDR CALA2025102710590Unknown · odorODOR PRESENT IN FLIGHT DECK AND CABIN IN THE CLIMB FOR 3-5 MINUT ES UPON ARRIVAL SPOKE WITH CREW, ALL CREW REPORTED VERY FAINT SMELL THAT DISIPATED QUICKLY, HAD CREW FILL OUT SMOKE REPORT. RAN PACKS, OVENS, DID GVI ON ALL SURFACES IN COCKPIT AS WELL AS FWD AND