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 SWAA2025081905305Bulb · inoperativeEMERGENCY LIGHT AT ROW 4 A, B, C INOPERATIVE. REMOVED AND REPLACED BULB FOR EMERGENCY LIGHT IAW SIP AND OPS CHECKED GOOD IAW AMM 33-51-00.SDR SWAA2025081905308Megaphone · inoperativeFWD MEGAPHONE INOPERATIVE. REMOVED AND REPLACED FWD MEGAPHONE IAW AMM 25-64-00. OPS CHECK GOOD.SDR AALA202508190359Sliding Window · out of positionAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: R2 WINDOW SHWOING DAYLIGHT AND IS EXTREMELY LOUD. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. FOUND R2 WINDOW UPPER ROLLER OUT OF TRACK. INSPECTED WINDOW SEAL, ROLLS AND TRACK, PER AMM 56-SDR AALA202508196316Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LEADING EDGE FLAPS WERE RAISED BUT THE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED, RECYCLE FLAPS DID NOT HELP. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAX. (OPEN).SDR DALA2025081906197Battery Pack · no testSHIP 693 ON SVC CHK FOUND M732 BATTERY PACK EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: R/R M732 BATTERY AND CHARGER IAW B757 AMM 33-51. OPS CHK GOOD. (7475970)SDR DALA2025081906196Battery Pack · no testDURING SVC CHECK FOUND RH AFT EMERGENCY DOOR EXIT SIGN AND AISLE LIGHTS FOR ROWS 39 + 40 DEF OUT. R/R BATTERY PACK M11082 PER B757 AMM 33-51. OPS CHECK GOOD. (7321335)SDR VNAA2025081911102Warning Message · illuminatedL ENG ITT WENT TO 966°C ON T/O WHILE IN TOGA FULL THRUST TO CLIMB TO LOWER ITT. / PERFORMED ENGINE WASH WITH CLEANING SOLUTION FOR PERFORMANCE IAW AMM 72-00-00-100-803-A01-PSA. ITT WITHIN LIMITS.SDR VNAA2025081911101Driver Unit · failedDUAL MFD FAILURE IN FLIGHT. / REMOVED AND REPLACED LAMP DRIVER UNIT IAW AMM 31-41-07-000/400-801 (CONFIG A01). OPS CHECK GOOD. REMOVED AND REPLACED THE MFD 1 IAW AMM 31-61-01-000/400-801-A01. OPS CHECK GOOD.SDR DALA2025081906184Skin · dentedDENT DAMAGE TO THE FUSELAGE SKIN SUSTAINED IN BOS. THE DENTED AREA EXISTS BETWEEN STA 891-902 AND BETWEEN STRINGERS 26L TO 27L. MAINTENANCE REPAIRED DAMAGE PER ERA 628536-14.SDR DALA2025081906183Battery Pack · no testMULTIPLE EMERGENCY LIGHTS INOP NEAR FWD GALLEY LH SIDE. REMOVED AND REPLACED BATTERY PACK EQUIP NUMBER M1675 PER B737 AMM 33-51 AND WDM 33-51-12.SDR DXTA2025081904632Battery Pack · no testDURING PREFLIGHT FOUND EMERGENCY LIGHT UNDER SEAT 5, SEAT 8 AND OVER SEAT 7 TO BE INOP. PERFORMED CHARGING PROCEDURE IN QRH AND LIGHTS REMAINED INOP. REMOVED FAULTY #3 EMERGENCY BATTERY PACK & INSTALLED REPAIRED BATTERY PACK IAW CE-680A MM CHAP 33-50-06. PERFOSDR DXTA2025081904636Battery Pack · no testEMER LIGHTS WOULD NOT TURN ON IN THE "ARM" POSITION. WE RAN THE CHARGING PROCEDURE IN THE QRH AND THEY THEN OPS CHECKED GOOD. WE DID A SHORT FLIGHT AND CHECKED THEM AGAIN AND THEY DID NOT ILLUMINATE. RAN THE CHARGING PROCEDURE AGAIN AND THEY DID NOT SDR SWAA2025081905406Slide · dislodgedFWD ENTRY DOOR EMERGENCY SLIDE CAME LOOSE OUT OF BUSTLE.<[01] REPACK FWD ENTRY DOOR ESCAPE SLIDE REF. AMM 25-66-01 AND MT 725-61-06 REM/INSTLSDR CALA2025081907938Control Unit · faultedDURING OPS CHK FOR EMERGENCY LIGHT, FOUND NO FLOOR PROXIMITY LIGHTS COME ON SEAT 11D, 12D, 11F, 12F. REMOVED AND REPLACED WELS CONTROL UNIT (WCU 24) IAW AMM A-33-51-07-01A-720A-A. REQUIRES SOFTWARE INSTALLATION STEP 1.D.SDR CALA2025081907936Pcb · faultedR OVHT DET STATUS MSG FOLLOWED BY R ENG OVHT CAUTION. COMPLIED W ITH QRH. WENT AWAY WITH IDLE DEBRIEFED FLIGHT CREW, ADVANCED THROTTLES AT LANDING, MSG DID NOT REAPPEAR. HAS HISTORY REF LP 5883831. PERFORMED FLOWCHART 26-11 FAULT TREE 803. VERIFIED NO PRESSURESDR CALA2025081907934Window · leakingLOUD WIND NOISE OBSERVED AFTER TAKEOFF. GOT LOUDER WITH INCREAS ED AIRSPEED. AS REPORTED VERBAL BY FLT-CREW NOISE CAMING FROM THE NOSE FUSELA GE. PERFORMED RADOME INSPECTION ALL OK. PERFORMED FWD FUSELAGE I NSPECTION ALL OK. PERFORMED PIPE CONDITIONING IN THE SDR CALA2025081907929Skin · dentedSHARP DENT ON LOWER CENTER OF EMPANNAGE APPROXIMATELY 10 INCHES FWD OF THE APU AIR INLET STRUCTURE. PERFORMED SKIN REPAIR IAW A320 SRM 53-51-11-300-082 REPAIR REQUI RES REINSPECT AT 60,000 FC / 120,000 FH FROM TIME OF ADL/REPAIR EMBODIMENT SUBSEQUENT INSPECTSDR CALA2025081907927Channel · corrodedFWD CARGO COMP CORROSION AT ZEE CHANNEL BETWEEN STA 500A-500D LBL 21" REF AAR N/R 97524861 INSTALLED FWD CARGO COMP ZEE CHANNEL BETWEEN STA 500A-500D LBL 21" PER SRM 51-40-02-0G-0 AND DWG# 143A7500. INSTALLED FWD CARGO COMP ZEE CHANNEL BETWEEN STA 500A-500D SDR HALA20250818046Placard · damagedFUSELAGE AFT L EMERGENCY EXIT PLACARD DAMAGED. REMOVED DAMAGED AFT L EMERGENCY EXIT PLACARD, INSTALLED NEW EMERGENCY EXIT PLACARD. OK FOR SERVICE.SDR HALA20250818045Landing Gear · malfunctionedGEAR FREE FALL FAILED. PERFORMED AMM 32-32-01OPERATIONAL TEST OF ALTERNATE LANGING GEAR EXTENSION CONTROL MECHANISM. OPS CHECK GOOD.SDR HALA20250818253Transfer Sys · faultedETOPS - BTB ON TAXI OUT ECAM FUEL AFT XFR FAULT. REMOVED & REPLACED LEFT INNER TANK INLET VALVE ACTUATOR PER AMM 28-26-53/400. OPS CHECK GOOD. OK FOR SVC.SDR HALA20250818251Warning Light · illuminatedETOPS - ENGINE 1 OIL CHIP DETECT. PERFORMED DETAILED INSPECTION OF EMCD PER AMM 79-00-00-200-822-A. ACCEPTABLE LIMITS FOR ONE FLAKE COLLECTED. REMOVED AND CLEANED EMCD PER AMM 79-22-46. REPLACED SCAVENGE FILTER PER AMM 79-22-45. OPS AND LEAK CHK GOOD, OK FOR SSDR HALA20250818249Generator · faultedETOPS - ELEC GEN 1 FAULT- AT CRUISE DID NOT RESET. REMOVED & REPLACED #1 IDG PER AMM 24-21-51. OPS CHECK IS GOOD. OKAY TO CONTINUE.SDR DALA2025081806167Indication Sys · faultedR1 DOOR SHOWS ARMED AT THE DOOR BUT NOT ON ECAM PASSENGER DOORS NOT ARMED INDICATION. PERFOMRED OPS TEST OF DOOR R1 ARMING LEVER OPS CHECK GOOD SHOWS SLIDE EVERYTIME ARMED WIGGLED HARNESS NO CHANGE. NO HIST. OK FOR SVC. (6914282)SDR HNAA2025081800575Light · inoperativeROWS 8/9 AND 10/11 EMERGENCY LIGHT FLOOR PROXIMITY STRIPS INOPERATIVE. R&R #400 FLOOR PROXIMITY LIGHT IRT AMM 33-50-12 R&R#5 EMERGENCY LIGHT AC/DC INVERTER IRT AMM 33-50-11 PN ON 1013194 FLOOR PROX LIGHT PN OFF 6636-7 FLOOR PROX LIGHT PN ON 1330312 AC/DC INVSDR WX0A2025081832545Battery Pack · faulted(AIRCRAFT NOT GROUNDED) EPSU BATTERY FAULT / REMOVED AND REPLACED EPSU BATTERIES, REF WO528858"SDR AALA202508181717Proximity Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: IN FLIGHT DOOR 4R SHOWS SLIDE UNARMED. FLIGHT ATTENDANT VISUALLY CHECKED HANDLE AND STATED IT IS NOT FLUSH AND WILL NOT STAY TO A DOWN AND LOCKED POSITION. MAINTENANCE FOUND THE R4 DOOR SLIDE BUSTLE STRAPS LOOSE AND SECURED THEM (ASDR AALA202508186805Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: AFTER SPEAKING WITH INBOUND CREW. FLIGHT ATTENDANTS REPORT 4R DOOR ARMED LEVER MOVES UP ABOUT ONE INCH ONCE AIRCRAFT IS PRESSURIZED ABOVE ABOUT 10,000. CAN BE PUSHED BACK DOWN, BUT MOVES BACK SLOWLY OUT OF NORMAL POSITION AGAIN. MAINTENSDR AALA202508188368Fitting · stickingAIRCRAFT WAS GROUNDED: AFTER SPEAKING WITH INBOUND CREW. FLIGHT ATTENDANTS REPORT 4R DOOR ARMED LEVER MOVES UP ABOUT ONE INCH ONCE AIRCRAFT IS PRESSURIZED ABOVE ABOUT 10,000. CAN BE PUSHED BACK DOWN, BUT MOVES BACK SLOWLY OUT OF NORMAL POSITION AGAIN. MAINTENSDR AALA202508185586Strap · looseAIRCRAFT WAS NOT GROUNDED: IN FLIGHT DOOR 4R SHOWS SLIDE UNARMED. FLIGHT ATTENDANT VISUALLY CHECKED HANDLE AND STATED IT IS NOT FLUSH AND WILL NOT STAY TO A DOWN AND LOCKED POSITION. MAINTENANCE FOUND THE R4 DOOR SLIDE BUSTLE STRAPS LOOSE AND SECURED THEM (ASDR AALA202508180930Strap · looseAIRCRAFT WAS GROUNDED: AFTER SPEAKING WITH INBOUND CREW. FLIGHT ATTENDANTS REPORT 4R DOOR ARMED LEVER MOVES UP ABOUT ONE INCH ONCE AIRCRAFT IS PRESSURIZED ABOVE ABOUT 10,000. CAN BE PUSHED BACK DOWN, BUT MOVES BACK SLOWLY OUT OF NORMAL POSITION AGAIN. MAINTENSDR AALA202508180007Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: DURING CLIMB SMOKE LAVATORY SMOKE ON ECAM LASTED APPROXIMATELY 15 SECONDS BEFORE CLEARING. FLIGHT ATTENDANTS INVESTIGATED ALL LAVATORIES AND FOUND NO EVIDENCE OF SMOKE. MAINTENANCE ACCOMPLISHED LAVATORY SMOKE DETECTION SYSTEM OPERATISDR AALA202508187187Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 13WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508186505Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 11WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508189964Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED CHECK DOOR PRESSURE MESSAGE BOTTLE PRESSURE IN YELLOW. MAINTENANCE SERVICED R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14, WHICH CLEARED THE MESSAGE.SDR AALA202508181923Adiru · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO BOS DUE TO THE FLIGHT CREW REPORTING THAT ON INITIAL CLIMB OUT GOT NAV FM/GPS POS DISAGREE. CAPTAIN SIDE NAV LOOKED NORMAL; FO SIDE NAV WAS MALFUNCTIONING. STOPPED CLIMB TO ASSESS, TSDR AALA202508185518Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER TASK CARD 26L00005005.SDR AALA202508187221Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER TASK CARD 26L00005005.SDR AALA202508189614Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER TASK CARD 26L00005005.SDR AALA202508181293Pin · wornAIRCRAFT IN BASE MAINTENANCE: #1 ENGINE AFT MOUNT INBOARD SIDE CROSS BEAM ATTACHMENT SHEAR PIN INNER SURFACE WORN. REPLACED SHEAR PIN PER AMM 71-22-11.SDR AALA202508181600Bottle · low pressureAIRCRAFT WAS GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR FDEA202508171491Escape Rope · dislodgedESCAPE ROPE FROM MAIN ENTRY DOOR DISLODGED FROM FRAME AMM 25 61-02-2 ESCAPE ROPE REPOSITIONED IN YOUR PLACE A/C OK FOR SVC.SDR FDEA202508171490Seat Track · wornSEAT TRACK AT STATION 695 TO STATION 735, X= 75.25 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 695 TO STATION 735, X= 75.25WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPSDR FDEA202508171489Seat Track · crackedSEAT TRACK AT STATION 1581, X= -8.5 FOUND CROWN CRACKED. CABIN-AT SEAT TRACK STATION 1581, X= -8.5 CRACKED CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508171484Skin · dentedLEFT OTBD FLAP LWR SURFACE FROM IB TO OB 40 INCHES CORSS TE TO LE 12 INCHES FOUND ONE DENT. REPAIRED LH OB FLAP LWR SURFACE DENT AT OTEF STA 73 AS PER B777 SRM 57-53-01-2R REPAIR 2 AND SRM 51-70-04-2R REPAIR 1 REV 47.6 AND EA: G-5750-T0384564 PI, TITLE: WISDR FDEA202508171483Skin · dentedLEFT OTBD FLAP LWR SURFACE FROM OB TO IB 93 INCHES CORSS TE TO LE 4 INCHES FOUND ONE DENT. REPAIRED LH OB FLAP LWR SURFACE DENT AT OTEF STA 434 AS PER B777 SRM 57-53-01-2R REPAIR 2 AND SRM 51-70-04-2R REPAIR 1 REV 47.6 AND EA: G-5750-T0384564 PI, TITLE: WISDR FDEA202508171482Skin · dentedFOUND RHW T/E O/B FLAP LOWER SURFACE 01 EA DENT AT THE CROSS OTEF 428 AND T/E 4 INCHES. REPAIRED RHW T/E O/B FLAP LOWER SURFACE 01 EA DENT AT OTEF STA 428 AS PER B777 SRM 57-53-01-2R REPAIR 2 AND SRM 51-70-04-2R REPAIR 1 REV 47.6 AND EA:G-5750-T0384565 P1SDR FDEA202508171481Skin · dentedFOUND RHW T/E O/B FLAP LOWER SURFACE 01EA DENT AT THE CROSS OTEF 127 AND T/E 01 INCHES. REPAIRED RHW T/E O/B FLAP LOWER SURFACE 01EA DENT AT OTEF STA 127 AS PER B777 SRM 57- 53-01-2R REPAIR 2 AND SRM 51-70-04-2R REPAIR 1 REV 47.6 AND EA: G-5750-T0384565 P1 , SDR FDEA202508171480Floor Panel · crackedMAIN DECK CARGO FLOOR PANEL P/N: 152W8302-33 FOUND CRACKED AT STA 1010 LBL 85 - LBL 113. MAIN DECK CARGO FLOOR PANEL P/N:152W8302-33 CRACKED AT STA 1010 LBL 85 -LBL 113. DAMAGE SIZE:(1) L=3.4"; (2) L=2.8"; (3) L=2.2" DAMAGE OUT OF ALLOWABLE LIMIT AS PER B7SDR FDEA202508171479Floor Panel · crackedMAIN DECK CARGO FLOOR PANEL P/N: 152W8302-34 FOUND CRACKED AT STA 1010 RBL 85. MAIN DECK CARGO FLOOR PANEL P/N:152W8302-34 CRACKED AT STA 1010 RBL 85. DAMAGE SIZE: L=2.8", DAMAGE OUT OF ALLOWABLE LIMIT AS PER B777 SRM 53-00-50-1A ALLOWABLE DAMAGE 1 FIGURE