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 ASAA2025101161651Power Supply · inoperativeEMERGENCY LIGHTS FOR POWER SUPPLY M2335 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY M2335 S/N 9266 REF B737NG AMM 33-51-06-960-806 EMERG LIGHTS OPS CHECKS GOOD REF B737NG AMM 33-51-06-960-806.SDR AALA202510209104Relay · inoperativeAIRCRAFT WAS GROUNDED: ON CLIMB OUT WE OBSERVED FUEL IMBALANCE AMBER ALERT ON RIGHT WING TANK IN EXCESS OF 1,000 POUNDS AND INCREASING RAPIDLY WITH ALL PUMPS CONFIGURED PROPERLY. VERIFIED RIGHT CENTER BOOST PUMP INOPERATIVE CAUSING FUEL IMBALANCE ON CLIMB OUT.SDR AALA202510205986Relay · faultyAIRCRAFT WAS GROUNDED: ON CLIMB OUT WE OBSERVED FUEL IMBALANCE AMBER ALERT ON RIGHT WING TANK IN EXCESS OF 1,000 POUNDS AND INCREASING RAPIDLY WITH ALL PUMPS CONFIGURED PROPERLY. VERIFIED RIGHT CENTER BOOST PUMP INOPERATIVE CAUSING FUEL IMBALANCE ON CLIMB OUT.SDR AALA202510201055Fuel Tank · leakingAIRCRAFT IN BASE MAINTENANCE: FUEL CENTER TANK SHOWS LEAK FROM LEFT MIDDLE SIDE OF THE KEEL BEAM AREA. DESEALED, CLEANED AND RESEALED INTERNAL CENTER TANK AT FORWARD SIDE OF RIB 6. FROM LEFT WING RIB 1 TO RIGHT WING RIB 1. PERFORMED SATISFACTORY LEAK CHECK, SDR ASMF202510180274Pump · warning messageCANCELLED FLIGHT, FUEL PUMP CENTER L, LEFT OVERRIDE, JETTISON PUMP PRESSURE SIGNAL SHOWS LOW FUEL PRESSURE. MSG 28-17505 & FUEL PUMP CENTER RT OVERRIDE, JETTISON PUMP PRESSURE SIGNAL SHOWS LOW FUEL PRESSURE MSG 28-17506, 28-17912, 28-17914, & 28-17916SDR ASMF2025101800275Wire Harness · faultedCANCELLED FLIGHT-ANTISKID EICAS ALERT MESSAGE IS SHOWN AFTER TAKE OFF. BRAKE CONTROL HARNESS FOR WHEEL 3-7 AND 4-8 WERE REPLACED IAW DMC-B787-A-32-42-15-01A.SDR SIMA20251011002Unknown · odorABNORMAL BOUNCE DURING TAKE OFF AND SUBSEQUENT SMELL OF RUBBER IN THE FLIGHT DECK AFTER TAKE OFF. EMERGENCY DECLARED. CONDITION CANNOT BE DUPLICATED ON TAXI CHECK, NO ABNORMALITY NOTED. PERFORMED GVI ON LH AND RH LANDING GEAR SHOCK STRUCT IAW ERJ 170 AMM 32-10SDR CALA2025101710219Rib · crackedRIGHT HORIZONTAL STAB RIB 7, 3RD STIFFINER BACK HAS A CRACK OA BASE,IB SIDE. ACCOMPLISHED REPAIR OF RT HORIZONTAL STAB NR 7 RIB AT NR 3 STIFFENER IAW SRM 55-10-09-2R-4,SDR CALA2025101710218Frame · corrodedMAIN CABIN AFT WET AREA LT BS 987 LBL43, FRAME HAS CORROSION. REMOVED DAMAGE, HFEC NO DEFECTS NOTED, FABRICATED, LOCATED, DRILLED, INSTALLED REPAIR, AND RESTORED COATINGS REF SRM 53-70-51-2R-4, THIS IS A CAT A REPAIR. NO FURTHER ACTION REQUIRED.SDR R61A2025101600433Skin · crackedRH WING LOWER SKIN CRACKED BETWEEN RIB 4 AND RIB 5 AT SPAR 2. REPAIRED IAW EMB ETD2025-170-930134 ALSO REF VP-043813-2025 N/R #2 FOR WORK ACCOMPLISHED.SDR HALA20251015052Accumulator · blownBRAKE PRESSURE LOW PULLING UP TO THE GATE. FOUND LT BRAKE ACCUMULATOR BLOWN. REMOVED AND REPLACED LT BRAKE ACCUMULATOR IAW AMM 32-44-01, OPS & LEAK CHECKED GOOD. OK FOR SERVICE.SDR DALA2025101507547Seat Track · corrodedFOUND CABIN SEAT TRACKS SURFACE CORROSION AT STA 1373 LBL 88.5. REMOVED THE CORROSION AND MEASURED THE REWORKED AREA: THE DEPTH OF CLEANUP ON TOP OF TRACK IS 0.036">0.020". FOUND OUT OF LIMITS AS PER B767-400 SRM 53-00-52. (1245738)SDR DALA2025101507546Seat Track · corrodedFOUND CABIN SEAT TRACKS SURFACE CORROSION BETWEEN STA 402 AND STA 447 RBL 88. DVI CARRIED OUT AND FOUND A CRACK CAUSED BY CORROSION. TRIMMED OUT THE SEAT TRACK AT STA 511 RBL 88. ACCOMPLISHED THE REPAIR AS PER B767-400 SRM 53-00-52 (1245714)SDR IXXA2025101501Floor Support · corrodedCORROSION WAS FOUND ON A FORWARD CARGO BALLMAT FLOOR SUPPORT FITTING AT APPROXIMATELY STA 566 COMMON TO THE FITTING OF NUTPLATE STRAP. LOCATED, DRILLED AND INSTALLED NEW FORWARD CARGO SUPPORT IN ACCORDANCE WITH B767 SRM 51-40-02 AND B767 SRM 51-40-05.SDR HNAA2025101400698Light · inoperativeOVHD EMERGENCY LIGHT AT ROW 11 INOPERATIVE. R & R EMERGENCY LIGHT ASSY ON SIDEWALL AT ROW 12 IAW AMM 33-50-14. OPS CK GOODSDR CALA2025101510132Autopilot Sys · faultedSTABILIZER OUT OF TRIM LIGHT LIGHT. ON DEBREIF PILOT ON AIR RETURN. AUTOPILOT A, CAUSED OUT OF TRIM & COLLUM BUMP WHEN ENGAGED. PERFORMED TEST & FOUND ELEV SENSOR SUGGESTED REPLACEMENT. AUTOPILOT B IS OPS. PLACED AUTOPILOT A ON MEL IAW 2201A. INSTALLED SDR HALA20251014317Acm · damagedETOPS - AIR R WING LEAK. FOUND AIR CYCLE MACHINE DAMAGED REMOVED ACM IAW A321 AMM 21-52-21. INSTALLED NEW ACM PER A321 AMM 21-52-21 NO LEAKS NOTED NO ECAM FAULTS NOTED CHKS OK.SDR ASAA2025101161538Warning Light · illuminatedON DEPARTURE RED NOSE GEAR LIGHT ILLUMINATED AFTER GEAR RETRACTION WHEN GEAR LEVER WAS MOVED FROM UP TO OFF. GEAR LEVER WAS RETURNED TO UP AND ALL GEAR LIGHTS EXTINGUISHED. WHEN THE NOSE GEAR LIGHT WAS ILLUMINATED INCREASED WIND NOISE COULD BE HEARD FROM THE NSDR SWAA2025101423667Slide · partial deployFWD ENTRY DOOR SLIDE PARTIALLY DEPLOYED. REINSTALLED FWD ENTRY DOOR SLIDE IAW MT 725-61-06. AC OK FOR SERVICE.SDR SWAA2025101423843Girt Bar · out of adjustF/A REPORTS REAR PROVO DOOR L-2 SLIGHTLY HANGING OUT OF SHROUD. ADJUSTED GIRT BAR ASSY. FOR SECURED POSITION. OK FOR CONT. SERVICE REF.25-66-01 AMMSDR SWAA2025101423852Fire Warning · false activationFIRE WARNING LIGHT ON AT ENG SHUT DOWN & APU SHUT DOWN W/ NO AUDIO. PERFORMED FIRE AND OVERHEAT DETECTION SYSTEM TEST IAW AMM 26-10-00. CHECKED FOR FAULTS IN ONBD MAINT. NO ACTIVE OR HISTORICAL FAULTS FOUND. SYSTEM OPS CK GOOD.SDR SWAA2025101423610Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERTIVE. REMOVED AND REPLACED L2 SLIDE EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR SWAA2025101423670Light · inoperativeAIRCRAFT RIGHT OVERWING EXIT LIGHT INOP AT 12DEF; & 20 DEF ALSO INOP. OK TO CONTINUE PER MEL 33-2-03. SP-1B. PERFORMED OPS TEST OF EMERGENCY LIGHTS OPS TEST GOOD PER AMM 33-51-00.SDR SWAA2025101423496Handle · loosePAX CABIN FWD ENTRY DOOR UPPER ASSISTANT HANDLE LOOSE. INSTALLED CORRECTLY ASSISTAND HANDLE UPPER FWD ENTRY DOOR PAX CABIN IAW BOEING SOPM 20-50-01 REV.39.SDR AALA202510140443Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 13WL FAILS FUNCTIONAL CHECK. MAINTENANCE REPLACED THE BATTERY FOR EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510147833Spring · brokenAIRCRAFT WAS GROUNDED: L1 DOOR PROXIMITY SENSOR 11WV1 TARGET SENSOR HOOK SPRINGS BROKEN WHICH RESULTED IN THE DOOR CONSTANTLY INDICATING CLOSED REGARDLESS OF THE DOOR POSITION. MAINTENANCE REPLACED SPRINGS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK SDR AALA202510141280Light · no testAIRCRAFT WAS NOT GROUNDED: ROW 22ABC SEAT EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LIGHT PER AMM 33-51-19.SDR AALA202510140957Coffeemaker · sparksAIRCRAFT WAS NOT GROUNDED: SPARKS OBSERVED COMING OUT OF AFT GALLEY #4 COFFEE MAKER, CIRCUIT BREAKER TO #4 COFFEE MAKER WAS PULLED. NO FURTHER ISSUES OBSERVED AFTER PULLING CIRCUIT BREAKER. MAINTENANCE REPLACED THE COFFEMAKER AND ACCOMPLISHED A SATISFACTORY OPSDR AALA202510142089Spring · brokenAIRCRAFT WAS GROUNDED: L1 DOOR PROXIMITY SENSOR 11WV1 TARGET SENSOR HOOK SPRINGS BROKEN WHICH RESULTED IN THE DOOR CONSTANTLY INDICATING CLOSED REGARDLESS OF THE DOOR POSITION. MAINTENANCE REPLACED SPRINGS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER SDR AALA202510146796Bottle · leakingAIRCRAFT WAS GROUNDED: THE L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER HAS REQUIRED MULTIPLE SERVICINGS DUE TO LOW PRESSURE. MAINTENANCE REPLACED THE L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14,SDR AALA202510143535Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS CIDS LIGHT ON. MAINTENANCE SERVICED L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00, WHICH CLEARED THE FAULT LIGHT.SDR AALA202510145748Hinge 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 AALA202510142430Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. MAINTENANCE REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510141983Hinge 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 AALA202510142996Hinge 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 AALA202510147985Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 12WL FAILS FUNCTIONAL CHECK. MAINTENANCE REPLACED THE BATTERY FOR EMERGENCY POWER SUPPLY UNIT 12WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510147947Hinge 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 AALA202510144016Hinge 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 AALA202510148394Hinge 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 AALA202510140653Fitting · lack of lubeAIRCRAFT WAS NOT GROUNDED: 4R ARMING MECHANISM BROKE. WHEN DISARMING DOOR ON GROUND, FLIGHT ATTENDANT HEARD A POPPING SOUND. UNABLE TO RE-ARM DOOR. MAINTENANCE CLEANED AND LUBRICATED GIRT BAR CONNECTIONS PER AMM 52-22-18. A SATISFACTORY OPERATIONAL CHECK OF SDR AALA202510146377Handle · looseAIRCRAFT WAS NOT GROUNDED: 2L ARMED HANDLE IS VERY LOOSE. MAINTENANCE SECURED HANDLE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM TASK 52-22-22.SDR DALA2025101407506Wire · brokenON SVC CK FOUNT EXIT SIGN @ 20L INOP. REPLACED BATTERY PER B737 AMM 33-51. OP CKS GOOD. FOUND BROKEN WIRE AND REPAIRED IAW B737 SWPM CHAPTER 20. "SUPPLEMENTAL INFORMATION" INCORRECT DESCRIPTION INFO SENT FIRST TIME. IN SEAT EMERGENCY LIGHT AT SEAT 32DEF INOP. SDR DALA2025101407510Battery · inoperativeON SVC CK FOUNT EXIT SIGN @ 20L INOP. REPLACED BATTERY PER B737 AMM 33-51. OP CKS GOOD.SDR N6WA2025101403Floorbeam · corrodedCORROSION ON FLOOR PANEL ANGLE SUPPORT IN COCKPIT AT 280 BEAM. REMOVED AND REPLACED FLOOR PANEL ANGLE SUPPORT AT 280 IAW CRJ SRM 51-42-06SDR AALA202510147710Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EPSU EMERG L BATTERY FAULT. MAINTENANCE REPLACED EPSU EMERG L BATTERY IAW AMM 33-51-38.SDR AALA202510149761Lens · missingAIRCRAFT WAS NOT GROUNDED: REAR MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 10D MISSING LENS AND INOP.SDR AALA202510147223Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT LIGHTS AT 24ABC AND 25 ABC INOP. MAINTENANCE FOUND ESPU CONNECTOR AT SEAT 24ABC AND 25ABC DISCONNECTED. RECONNECTED IAW ESPM 20-44-10.SDR AALA202510140384Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 11C EMERGENCY PATH LIGHT NEEDS RELAMP. MAINTENANCE INSTALLED LAMP EMERGENCY PATH LIGHT ROW 11 C IAW CMM B/E AEROSPACE 25-40-07 ASSEMBLY STEP 3.A(1) ITEM (B), (C).SDR DXTA2025101405282Elec Connector · incorrectAFTER LANDING AND SHUTTING DOWN REGARDLESS OF THE EMERGENCY LIGHT SWITCH POSITION THE RED EMERGENCY LIGHT UNDER SEAT 4R STAYS ON. UPON INITIAL POWER UP WE WERE UNABLE TO DUPLICATE FAULT. DURING OP CHECK OF EMERGENCY LIGHTS FOUND SEAT 4R TO FAIL TEST. AFTER FSDR YENA2025101401027Fire Loop · faultedFLT#816, SFO-JFK. (ETOPS) "PFR SHOWS ENGINE 1 FIRE LOOP A FAULT ( ENGINE FIRE DETECTION SYSTEMS 1) LOOP A ). REMOVED NAD REPLACED ENG1 LOOP A FOWARD FIRE/OVERHEAT DETECTOR ( FIN 4002WD1) PER AMM 26-12-17 OPSCHK NORMAL. THIS CLEARS MDDR 596990 MX4 UPDATED PLA