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 AALA202602020159Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS DOOR 2R ARM/DISARM HANDLE LOOSE. MAINTENANCE TIGHTENED 2R ARM/DISARM HANDLE ON EMERGENCY EXIT DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-21-11.SDR AALA202602021381Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202602023277Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD OUTBOARD FLASHLIGHT AT 1L FLIGHT ATTENDANTS JUMPSEAT IS INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-65-00.SDR AALA202602027554Wire · misinstalledAIRCRAFT WAS NOT GROUNDED: EMERGENCY CEILING LIGHT AT SEAT ROW 11 IS INOPERATIVE. MAINTENANCE REINSTALLED EMERGENCY OVERHEAD WIRING LIGHTING AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TSM 33-51-00-810-810-A.SDR AALA202602029443Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. R4 DOOR DAMPER AND EMERGENCY OPS CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPS CYLINDER IAW AMM 52-10-00SDR AALA202602023674Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: LANDING GEAR NOT UPLOCKED AFTER TAKE OFF AROUND 700 FT. FLIGHT CREW FOLLOWED ECAM PROCEDURE & RECYCLED GEAR SUCCESSFULLY. LANDING GEAR DOORS NOT CLOSED ECAM RESET & RECYCLED SUCCESSFULLY PER ECAM. MAINTENANCE FOUND NOSE LANDING GEAR DOORSDR AALA202602028829Fitting · lack of lubeAIRCRAFT WAS NOT GROUNDED. L1 DOOR ARMING LEVER VERY STIFF. MAINTENANCE CLEANED, & LUBRICATED THE L1 DOOR GIRT BAR FLOOR ATTACH POINTS (AALA202601318829) AND THE SLIDE ARMING LEVER CONTROL HANDLE MECHANISM (AALA202602023189) IAW AMM 52-11-22. A SATISFACTORY SDR AALA202602029624Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK LEFT HAND SLIDING WINDOW HANDLE LOOSE. MAINTENANCE SECURED HANDLE AND ACCOMPLISHED A SATISFACTORY OPS CHECKED IAW AMM 56-12-11.SDR YENA2026013000093Control Unit · failedFLT # 2010 LAX-PBI (ETOPS). LIGHT GREEN ARROW, TURB BUTTON ON WX RADAR PANEL INOPERATIVE ( WEATHER RADAR SYSTEMS 4) TURBULENCE DETECTION MODE ).; R & R WXR CONTROL UNIT PER AMM 34-41-12. BITE TEST OK MX-4 UPDATED.SDR YENA2026020200101Warning Message · false activationFLT 417, SFO-JFK (ETOPS). ENGINE 1 REVERSER PRESSURIZED ECAM ( THRUST REVERSER SYSTEMS ). PERFORMED OPS CHECK OF THE THRUST REV WITH MCDU THOUGH EEC CHA 1A AND CHA 1B SIX TIMES NO DEFECTS NOTED OPS CHECK GOOD THIS CLEARS MDDR 607684 MX4 UPDATED PLACARD RESDR DALA2026020200768Seat Track · corrodedTRANSVERSE BEAM BETWEEN -YA AND -YB1 HAS CORROSION ON TOP OTB SURFACE NEAR LAV MOUNT AND IN LAV MOUNT HOLE. SEAT TRACK REPLACED PER A330 SRM 51-72-11-911-001. (1427944)SDR DALA2026020200767Seat Track · corrodedCORROSION ON SEAT TRACK AT -Y1447.8 AND FR 75. SEAT TRACK REPLACED PER SRM 51-72-11-911-001. (1427943)SDR DALA2026020200766Seat Track · corrodedCORROSION WAS FOUND BY 4R LAV SEAT TRACK SECTION -YB1. SEAT TRACK REPLACED PER A330 SRM 51-72-11-911-001. (1427936)SDR DALA2026020200765Seat Track · corrodedCORROSION WAS FOUND BY 4R LAV SEAT TRACK SECTION -YB. SEAT TRACK REPLACED PER A330 SRM 51-72-11-911-001. (1427935)SDR YENA2026020200098Unknown · odorFLT 1057, JFK-AUA. STRONG MAGIC MARKER ODOR DESCENDING THROUGH 11,500 LASTING APPROX 60 SECONDS. COMPLIED WITH INFORMATION NOTICE 2017-T015, STEP 1 ISOLATED FAULT TO TYPE 10, MAGIC MARKER ODOR, PERFORMED ENGINE RUNS AND RAN APU WITH NO ODORS PRESENT PER TSM 05SDR YENA2026020200097Cargo · contaminatedFLT 959, BDL- FLL. N593-FTL-959-BDL-FLL-ODOR EVENT THE PILOT ANNOTATED: ODOR ASSOCIATED WITH FUMES AFTER ENGINE START, TO PWR CLIMB DESCENDING THRU 18,000FT TAXI AND SHUTDOWN. THERE WAS NO PRIOR ODOR EVENTS REPORTED IN THE LAST 30 DAYS. THE ACFT WAS TAKEN OOSDR DALA2026020200763Seal · leakingSHORTLY AFTER TAKEOFF, FA'S IN AFT GALLEY REPORTED FUMES IN THE AFT GALLEY DESCRIBED AS HAVING A DEICE FLUID ODOR AND STRANGE TASTE. FUMES CONFINED TO AFT GALLEY AND DISIPATED WITHIN 5-10 MIN AFTER ONSET. FOUND OIL PUDDLE IN BOTH SPINNERS. REPLACED #1 AND #2SDR 141A2026013000001Coordinator · faultedAFTER TAKING OFF FROM HRO TO FLY TO DFW MY SELF FO NOTICED THE PIC SIDE HEADING COORDINATOR WAS SWINGING ERRATICALLY AND THE RED HEADING FLAG WAS DISPLAYED. AFTER TALKING IT OVER WITH HIM WE MADE THE DECISION TO TURN AROUND TO GO BACK TO HRO SINCE WE WASN’T TOSDR DALA2026020200760Light · inoperativeFOUND ON SVC CHECK - L4 PAX DOOR EMERGENCY LIGHT INOP (EXTERIOR LIGHT ). REMOVED AND REPLACED L4 DOOR LIGHT (151WL41) PER A350 AMM 52-13. OPS CHK GOOD. A/C OK FOR SVC. (LP# 8007799)SDR DALA2026020200759Light · inoperativeFOUND ON SVC CHECK - L1 PAX DOOR EMERGENCY LIGHT INOP (EXTERIOR LIGHT). REMOVED AND REPLACED L1 DOOR LIGHT (151WL11) PER A350 AMM 52-11. OPS CHK GOOD, A/C OK FOR SVC. (LP# 8007798)SDR FDEA202601300108Seat Track · corrodedMCC STA 1280 LBL 58.22 SEAT TRACK WITH CORROSION. REMOVED AND REPLACED THE SEAT TRACK SRA 1180-1420 LBL 58.22 IAW SRM 51-40-02-0G, & DWG 657N3332, REV A.SDR FDEA202601300107Seat Track · corrodedMAIN CARGO COMPARTMENT BS 1620 RBL 58.22 SEAT TRACK WITH CORROSION. REMOVED SEAT TRACK SECTION MAIN CARGO STA 1180-1420 RBL 58.22 IAW B757 SRM 51-40-02-0G TRIMMED, LOCATED AND DRILLED NEW SEAT TRACK IAW B757 SRM 51-40-05-0G AMD BOEING DWG 657N3332 REV A INSDR FDEA202601300106Floor Support · mechanic errorAFT CARGO FLOOR SUPPORT, BS 1465 MISDRILLED HOLES. REMOVED AND REPLACED THE FLOOR SUPPORT, IAW SRM 51-40-02-0G AND SRM 53-60-53-01, FIG 1, DET VII.SDR FDEA202601300105Floor Support · mechanic errorAFT CARGO FLOOR SUPPORT, LBL 7.55 BTW BS 1480 TO 1500 MISDRILLED HOLES REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G AND SRM 53-60-53-0I FIG 1 DET VIISDR FDEA202601300104Skin · delaminatedLEFT WING MAIN INBOARD FLAP LOWER SURFACE HAS SKIN CRACKED. UPON FURTHER EVALUATION ON L/WING MAIN FLAP INBD LOWER SURFACE FOUND DELAMINATION DIM L = 10.5" W=1.7" WITHIN LIMITS TO REPAIR IAW B757 SRM 57-53-01-1A DETAIL I CLEANED AND REMOVED DAMAGE IAW SRM SDR FDEA202601300103Seat Track · corrodedMAIN DECK SEAT TRACK LBL 58.00 FROM 1180 TO STA 900 MULTIPLES SPOTS CORRODEDSDR FDEA202601300102Seat Track · corrodedMCC STA 880 TO 840 LBL 58.22 SEAT TRACK FOUND CORRODED. REMOVED SEAT TRACK SECTION STA 660 TO STA 885 RBL 58.22 M.C.C IAW SRM 51-40-02-0G. TRIMMED, LOCATED AND DRILLED NEW SEAT TRACK SECTION IAW B757 SRM 51-40-05-0G AND BOEING DWG # 657N3332 REV A INSTALLEDSDR FDEA202601300101Seat Track · corrodedMAIN CARGO COMPARTMENT BETWEEN BS 740 AND 860 RBL 58.22 SEAT TRACK WITH CORROSION (03 LOCATION). REMOVED SEAT TRACK SECTION MAIN CABIN BETWEEN STA 660 TO 885 RBL 58.22 IAW B757 SRM 51-40-02-0G, TRIMED, LOCATED AND DRILLED NEW SEAT TRACK SECTION IAW B757 SSDR FDEA202601300100Seat Track · corrodedMAIN DECK SEAT TRACK RBL 58.00 BTW BS 900 - 1180, MULTIPLES SPOTS WITH CORROSION. REMOVED SEAT TRACK SECTION BETWEEN STA 900 TO 1180 RBL 58.0 M.C.C IAW B757 SRM 51-40- 02-0G TRIMMED, LOCATED AND DRILLED NEW SEAT TRAK IAW B757 SRM 51-40-02-0G AND BOEING DWGSDR FDEA202601300099Seat Track · corrodedMAIN DECK SEAT TRACK STA 1205, RBL 58 CORRODED. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-40-02-0G.SDR HNAA2026020200108Control Unit · abnormalSPOILER FAIL AT FL240 AT 310KNTS WITH SPOILER INDICATING OPEN ON EICAS. RAR SPOILER CONTROL UNIT IAW AMM 27-63-01-700-801-A. OPS AND LEAK CHECK GOOD OK FOR SERVICESDR ABXA2026020230045Switch · out of positionDURING TAXI OUT, UPON START ATTEMPT FOR LH / #1 ENG LH ENG VALVE DISCREET + LT ILLUM, DUCT PRESSURE RETURNS TO 0 PSI. AIRCRAFT RETURNED TO BLOCKS (BTB). PUT THE APU BLEED AIR SWITCH TO THE OFF POSITION PER ABX 767 MPM 36-11-04. OPS CHECKED GOOD IAW 71-00-00SDR ABXA2026020230041Shutoff Valve · warning messageLEFT ENG HPSOV EICAS MESSAGE REMAINED ON INTERMITTENT AFTER PROCEDURE WAS DONE A/C DIVERTED TO DEN BECAUSE OF ICEING CONDITIONS AT ORIGINAL DESTINATION IN DEN MTX DEFERRED LH ENGINE HPSOV IAW MEL ABX 36-11-2-2 FOR DEPARTURE AND RETURNED AC TO SERVICE.SDR DALA2026020200755Frame Angle · crackedCRACKED FRAME ANGLES (2 EACH) BS 1022 AND LONGERON 7 RT & LT SIDES AT PASSENGER CABIN. PERMANENT REPAIR IAW PRI 631537-14, REV 1, ERA 631536-14. (1426473)SDR AJXA2026013000041Strut · dischargedAFTER TAKEOFF, THE PILOT ATTEMPTED TO RETRACT THE LANDING GEAR AND THE LAND GEAR DID NOT RETRACT. THE NOSE LANDING GEAR WAS SERVICED. GEAR AND GEAR RETRACTION OPERATIONAL CHECKS PERFORMED AND THE AIRCRAFT WAS RETURNED TO SERVICESDR SCNA20260202049Hydraulic System · overservicedFLIGHT ATTENDANTS NOTICED AN ODOR THROUGH 10,000 FT COMING OIUT OF AIR VENTS. STILL THERE AFTER SHUTDOWN. APPEARS TO BE ELECTRCAL IN NATURE. FOUND HYD QUANITY OVER SERVICED DRAINED. PERFORMED FIM 20-00 TASK 806 NO ODOR IN CABIN ON START UP HAD HYD SMELL IN VSDR DALA2026020200753Circuit Breaker · trippedATB - DUE TO C/B TRIPPED ECAM MSG ALONG WITH FIRE BOTTLE FAULT INDICATION. FOUND CIRCUIT BREAKER FOR FIRE BOTTLE 1/B ENG 1+2 TRIPPED. PERFORMED WIRING CHECKS AT CB (37WE2) WITH NO FAULTS FOUND. REPLACED CIRCUIT BREAKER. OK FOR SERVICE. (8243430)SDR DALA2026020200751Seal · out of positionOXYGEN PANEL LATCH BROKEN, ABOVE AFT GALLEY. LOCKING MECHANISM BROKEN. DOOR WILL NOT STAY SHUT. INSPECTED AFT GALLEY O2 MASK & BOX. FOUND PANEL DUST SEAL INTERFERING WITH O2 DOOR LATCHES. ADJUST SEAL, STOWED O2 MASKS AND LATCHED DOOR IAW AMM 35-21. OKAY FORSDR DALA2026020200742Seat Track · corrodedCORROSION ON SEAT TRACK -Y1292 LOCATED BTW FR 64 TO FR 66. REPLACED THE SEAT TRACK IAW SRM 51-42-11, SRM 51-72-11, DWG 10N01036 ISSUE C, MEASUREMENT OF CORROSION: D=0.0325 INCH. (LP 1428059)SDR CALA2026020213494Idg · faultedLEFT GEN DRIVE EICAS CAME BACK ON & STAYED ON, LT GEN DRIVE DISCONNECT PUSHED IAW QRH FOR MAINTENANCE ACTION. REMOVED NR 1 ENG IDG IAW AMM 24-11-01. ACP IDT INSPECTION OF FEEDER CABLES INSTALLATION, IAW GMM 09-10-05. UNIONS FROM OLD IDG NEED TO BE TRANSFERRSDR CALA2026020213493Shutoff Valve · faultedRIGHT ENG BLEED & RT PACK OFF CAUTION LIGHTS ILLUMINATED AFTER TAKEOFF. UPON ARRIVAL OF AIR RETURN, ACCOMPLISHED AIR SUPPLY BITE MODULE TEST IAW FIM 36-20 FT 804 & RT PRSOV FAULT LIGHT ILLUMINATED. REMOVAL OF RT PRSOV ACCOMPLISHED ON LP 7776435, OPS TESTED SDR CALA2026020213492Controller · faultedCREW ADVISES AUTO PRESS FAIL LIGHT CAME ON AFTER TAKE OFF & MANUAL WOULD NOT OPERATE CORRECTLY. ACP WIRE CHECKS BTWN CPC,CPM & OUTFLOW VALVE, NO DEFECTS FOUND IAW WDM 21-31-23 & WDM 2/1-31-22. R & R AFT OUTFLOW VALVE ASSY IAW AMM 21-31-03, STILL HAS AUTO FASDR CALA2026020213491Adiru · faultedAFTER TAKE OFF, BOTH CA & FO LOST BOTH HEADING AND LATERAL INDICATIONS, FO DATA CAME BACK. ACP DCFS BITE, BPCS, GCU 1 & 2, NO FAULTS. LT ADIRU HAS ENTER HEADING FAULT ON LAST LEG MAIT MESSAGE 34-21009 FIM 34-21 TASK 808 INITIAL EVALUATION SHOWED NO CURRENT SDR CALA2026020213479Battery · dischargedL4 DOOR M33407 BATTERY PACK FOUND INOP. L4 DOOR M33407 BATTERY PACK FOUND INOP. REPLACED BATTERY AND TEST NORMAL. REPLACED L4 DOOR EMERGENCY LIGHT POWER SUPPLY M33407 BATTERY PACK AND PERFORMED NEW BATTERY INSTALLATION TEST, THE TEST RESULT FOUND NORMAL AS PSDR CALA2026020213478Battery · dischargedR1 DOOR EMERGENCY LIGHT POWER SUPPLY M33094 BATTERY PACK FOUND LOW CAPACITY REF HAECO NON-ROUTINE NO.94995751. R1 DOOR EMERGENCY LIGHT POWER SUPPLY M33094 BATTERY PACK FOUND LOW CAPACITY. REPLACED THE BATTERY AND TEST NORMAL.SDR CALA2026020213477Drain · faultedCLEANUP WAS PERFORMED IN THE FWD E&E FROM BS 143.4 - 204.5. PLACED ON DIP PER ECRA 2011-01000 GALLEY SPILL SECTION 2.B. STARTED IN DEPTH CLEAN UP REF ECRA 2011-01000. REMOVED MAIN EQPT CTR FLOOR PANEL REF AIPC 53-01-51-01B ITEM 35. FOUND JUNKS OF ICE ON INSULASDR CALA2026020213476Seat Track · corrodedMAIN DECK SEAT TRACK AT BS .377.7 LBL 45 UPPER SKIN HAS SURFACE CORROSION. R & R THE SEAT TRACK BS 377.7 - 420, LBL 45 IAW SRM 53-10-52-01-1 51-40-05-0G AND 51-40-02-0G. RESTORED AREA PROTECTION AND APPLIED CIC IAW SRM 51-20-01, AND AMM 51-00-59.SDR CALA2026020213475Skin · dentedLEFT FUSELAGE SKIN AT BS 198 ABOVE S-25 +2.0" WAS DENTED. THE DENT IS 3.65" LONG AND 2.5" WIDE AND DEPTH IS 0.065". REPAIRED THE DAMAGED SKIN BETWEEN BS 188 - 203.8, S21L-25L IAW ESR-WI 2024183-19-14589, & EC/RA 5310-08787. PERFORM AN INSPECTION OF THE FUSDR CALA2026020213474Bulb · burned outEMERGENCY LIGHTS - OPERATIONAL TEST WITH THE TEST SWITCH PROCEDURE, L637 EXTERIOR LIGHT AT R4 DOOR FAILED TO ILLUMINATE DURING EMERGENCY LIGHT TEST IAW AMM 33-51-06, REPLACED EXTERIOR 4R LIGHT. OPS NORMAL AT THIS TIME.SDR CALA2026020213473Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT INOP AT RH AFT OVERWING EXIT DOOR RELAMPED, NO HELP. FOUND NO VOLTAGE TO LIGHT ASSY. CHECKED RESISTANCE FROM CONNECTOR 12004 PIN 12 TO CONNECTOR 12018 PIN 1 REF WDM 33-51-14. CHECKS OK. REMOVED AND REPLACED BATTERY POWER SUPPLY AT 27D