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 CALA2026010812792Power Supply · no testCABIN EMERGENCY SYSTEM TEST FAILED, EMERGENCY LIGHTS BATTERY CHARGED FOR 90 MINUTES, A SYSTEM TEST WAS PERFORMED WITH NO CHANGE ON RESULTS. REPLACED FWD EPSU POWER SUPPLY AND BATTERY IAW AMM 33-51-38-401, ACP EPSU CHECK FROM FWD FA PANEL,TESTED GOOD.SDR AALA202601089056Door Frame · bentAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR FRAME IS BENT AND LOOSE AND MAKES DOOR DIFFICULT TO OPEN. (OPEN).SDR AALA202601080074Threshold · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS HARD TO OPEN. SERCURED THRESHOLD, OPERATIONAL CHECK GOOD.SDR AALA202601082731Slide · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR SLIDE PACK FLAP IS NOT LAYING FLAT WHEN GIRT BAR IS IN THE ENGAGED POSITION. REMOVED AND REPLACED R1 DOOR SLIDE ASSEMBLY. PER W/C 0822125001.SDR AALA202601083434Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: JUST AFTER TAKE OFF THE LEFT FORWARD FUEL LOW PRESSURE LIGHT ILLUMINATED AND REMAINED. (OPEN).SDR DALA2026010800191Guard · looseATO APPROX. 94 KNOTS DUE TO FLIGHT DECK DOOR OPENING. RESET DOOR ARM SWITCH AND CONTINUED. SUBSEQUENTLY, FLIGHT DECK DOOR SWITCH GUARD FOUND TO BE LOOSE. REPLACED COCKPIT BOOR SWITCH RED LATCH PER 52-51. (LP 8525212)SDR SWAA2026010859145Pump · failedON TAKEOFF ROLL, NR 1 ENGINE ONLY PRODUCED 80.7% N1 WITH 85% COMMANDED, NR 2 WAS NORMAL. EECS WERE ON. NO CAUTIONS OR WARNINGS. AIRBORNE NR 1 WOULD ONLY PRODUCE 83.3% AT 5000'. WHEN BACK AT THE GATE, NR 1 WOULD NOT SHUT DOWN ON ITS COMMAND TO CUTOFF. IT DIDSDR SWAA2026010859154Relay · failedELECTRIC STAB TRIM FAIL DURING CLIMB OUT, AUTOPILOT WAS NOT ENGAGED. NEITHER CAP OR FO ELECTRIC STAB TRIM WAS OPERATIONAL. MANUAL TRIM OPERATED NORMALLY. R & R R64 STAB TRIM CONTROL RELAY IAW WDM 27-41-12. NO DEFECTS NOTED.SDR SWIA202601080007Engine · failedNUMBER 2 ENGINE FAILED AT CRUISE. HEARD A LOUD POPPING NOISE AND THE GAUGES ALL ROLLED BACK ON THE NUMBER 2. RAN QRC, QRH EMERGENCY AND ABNORMAL PROCEDURES. (FLIGHT 5584) OPENSDR DALA2026010800186Frame · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON FRAME AT P1. REPAIRED PER ERA 631298-14. (1390708)SDR DALA2026010800185Doubler · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON DOUBLER AT P'5. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390706)SDR DALA2026010800184Frame · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON FRAME AT P1. REPAIRED PER ERA 631298-14 REV. ORIG. (1390580)SDR DALA2026010800183Frame · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON FRAME BETWEEN P'1/P'2. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390490)SDR DALA2026010800182Channel · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON CHANNEL LOWER EDGE AT P2. REPAIRED PER ERA 631298-14 REV. ORIG. (1390487)SDR DALA2026010800181Channel · damagedAFT SIDE OF FRAME 60 TOOLING DAMAGE ON STIFFENER CHANNEL OTBD EDGE BETWEEN P1/P2. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390360)SDR DALA2026010800180Frame · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON FUSELAGE SKIN NEXT TO CHANNEL AT P'3. REPAIRED PER ERA 631298-14 REV. ORIG. (1390359)SDR DALA2026010800179Channel · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE IN CHANNEL AT P'3. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390358)SDR DALA2026010800178Channel · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON AND IN CHANNEL AT P'1. REPAIRED PER ERA 631298-14 REV. ORIG. (1390351)SDR DALA2026010800177Bracket · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON BRACKET AT P1. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390344)SDR DALA2026010800176Channel · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON CHANNEL SEVERAL AREAS AT P1. REPAIRED PER ERA 631298-14 REV. ORIG. (1390343)SDR DALA2026010800175Channel · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON AND IN CHANNEL AT P'2. REPAIRED TOOLING DAMAGE PER ERA 631298-14 REV. ORIG. (1390339)SDR DALA2026010800174Skin · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON FUSELAGE SKIN AT P2. REPAIRED PER ERA 631298-14 REV. ORIG. (1390338)SDR DALA2026010800173Frame · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON BETWEEN CHANNEL AT P3. REPAIRED PER ERA 631298-14 REV. ORIG. (1390333)SDR DALA2026010800172Frame · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON FRAME JUST BELOW CHANNEL AT P3. REPAIRED PER ERA 631298-14 REV. ORIG. (1390323)SDR DALA2026010800171Skin · damagedFORWARD SIDE OF FRAME 60 TOOLING DAMAGE ON FUSELAGE SKIN JUST OUTBOARD OF P3. REPAIRED PER ERA 631298-14 REV. ORIG. (1390306)SDR DALA2026010800170Frame · damagedTOOLING DAMAGE AFT SIDE LT FRAME 53.1, STR 7L. REPAIRED PER ERA 631298-14 REV. ORIG. (1390183)SDR DALA2026010800168Bridge · crackedLEFT WING NR 3 FLAP TRACK CARRIAGE ASSY OTBD BRIDGE CRACKED. REMOVED AND REPLACED THE LT WING NR 3 FLAP TRACK CARRIAGE ASSY OTBD BRIDGE IAW AMM 27-54-78. OK FOR SERVICE. (1390089)SDR DALA2026010800167Bridge · crackedFOUND LT WING NR 4 FLAP TRACK CARRIAGE ASSY OTBD BRIDGE CRACKED. REMOVED AND REPLACED LT WING NR 4 FLAP TRACK CARRIAGE ASSY OTBD BRIDGE IAW AMM 27-54-78. OK FOR SERVICE. (1390070)SDR DALA2026010800166Bridge · crackedLEFT WING NR 2 FLAP TRACK CARRIAGE ASSY INBD BRIDGE CRACKED. REMOVED AND REPLACED THE LT WING NR 2 FLAP TRACK CARRIAGE ASSY INBD BRIDGE IAW AMM 27-54-78. OK FOR SERVICE. (1390055)SDR ASAA2026010762726Switch · faultedFA'S REPORT EMERGENCY EXIT LIGHTS. INTERMITTENATLY FLASHING WHEN ACFT IS DESCENDING. GROUNDED - YES. REPLACED EMERGENCY LIGHT SWITCH S1-177 IAW SSM 33-51-0-101. OPS CHECK GOOD. OK TO CONTINUE SERVICE.SDR DALA2026010800161Girt Bar · faultedENGAGEMENT LESS THAN 0.37 IN BTW GIRT BAR SLIDER AND FWD FLOOR FITTING AT L4 DOOR IN PAX CABIN. GIRT BAR WAS REPLACED PER AMDS 2561-01257- 01E AND PER B757-200 AMM 25-66-10. (1390437)SDR AALA202601084563Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER REQUIRES SERVICING.TEMP AT 53 DEGREES FPSI AT1250. MAINTENANCE SERVICED R1 DOOR DAMPER IAW AMM 52-10-00.SDR AALA202601083058Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR EMERGENCY ACCUMULATOR LOW PRESSURE. MAINTENANCE SERVICED L1 DOOR EMERGENCY ACCUMULATOR IAW AMM 52-10-00.SDR AALA202601081959Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY ACCUMULATOR LOW. MAINTENANCE SERVICED R1 DOOR EMERGENCY ACCUMULATOR IAW AMM 52-10-00.SDR AALA202601082048Transducer · faultyAIRCRAFT WAS GROUNDED: INBOARD SLAT SKEW SENSOR 6 INBOARD IS FAILED. DECESION MADE TO RETURN TO DFW, AIRCRAFT WAS NOT OVERWEIGHT AND NO EMERGENCY DECLARED. LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED M2789062 SLAT SKEW SENSOR (TRANSDUCER) 6 INBD IAW AMM 27-8SDR AALA202601083933Power Supply · faultyAIRCRAFT IN BASE MAINTENANCE: INOP EPSU-EMERGENCY POWER SUPPLY UNIT 11WL IN PASSENGER CABIN. MAINTENANCE REPLACED EPSU-EMERGENCY POWER SUPPLY UNIT 11WL IN PASSENGER CABIN IAW A320FAM AMM 33-51-38-000-001-A ANDA320 FAM AMM 33-51-38-400-001-A.SDR ASAA2026010763606Power Supply · dischargedWHILE PERFORMING TC 78233001 , FOUND R1/R2 OUTSIDE AFT DOOR , RH AFT WING , RH AFT UNDER WING , L1 AFT DOOR OUTSIDE , L1 OVERHEAD INSIDE , LH AFT WING , LH AFT UNDER WING , ALL INSIDE WING EXIT DOOR , AND R2 INSIDE SMALL GALLEY LIGHTS INOP BEFORE 15 MINUTES. GSDR IPXA2026010883023Control Unit · faultedAT CRUISE FLT AT FL380. L SIDE WINDOW HAD STARTED TO DELAMINATE THE HEATING ELEMENT. FOLLOWED QRH CHECKLIST & WINDOW WAS EXTREMELY HOT TO TOUCH AND APPROX 5IN AREA IS AFFECTED. REMOVED AND INSTALLED L2 WINDOW IAW AMM 56-11-02/401 UP TO AND INCLUDING STEP C.8. SDR IPXA2026010897482Gauge · failedAIR TURN BACK, NR 1 N1 & EGT GAUGE FAILURE THEN INTERMITTENT OPERATION ENG 1 FAILURE ECAM AND ENG #1 REVERSE UNLOCK ECAM. FMC REVERTED TO ENGINE OUT MODE. REPLACED #1 ENGINE LEFT FAN CASE HARNESS 21W4118 PER AMM 71-51-01/401 DUE TO D4998P LOCKING MECHANISM FAISDR ABXA20260107005Transmitter · defectiveDURING TAXI OUT, RIGHT ELEVATOR INDICATOR IS NOT SHOWING FULL DEFLECTION DURING CONTROL CHECK. AIRCRAFT RETURNED TO BLOCKS (BTB). DEFERRED ELEVATOR INDICATION IN REF WITH MEL 27-08-1. REMOVED AND REPLACED RH ELEVATOR POSITION TRANSMITTER IAW B767 AMM 27-38-SDR 6CBA2026010826001Valve · faultyDURING CRUISE FROM KTEX TO KGPI, THE CREW NOTED THE MAIN/EMERGENCY BRAKE PRESSURE TO BE DROPPING. THE CREW DECIDED TO DIVERT TO KAPA. DURING APPROACH, THE CREW NOTED A MAIN BRAKE FAIL CAS WITH A TRIPPED ECB. THE ECB TRIPPED IMMEDIATELY AFTER THE FIRST ATTEMSDR DXTA2026010806476Door Latch · faultyMAIN DOOR WILL RAISE INTO CLOSED POSITION BUT DOOR HANDLE WILL NOT MOVE TO LOCK THE DOOR. ALSO TRIED CLOSING THE DOOR FROM THE OUTSIDE AND THE OUTER DOOR LATCH WOULD NOT MOVE EITHER. PERFORMED A FULL SHUTDOWN WITH DISCONNECTING BOTH BATTERIES. THE DOOR IS STILSDR FDEA202601070011Unknown · odorUPON APPLICATION OF TAKEOFF POWER, A STRONG SMELL OF WET/DIRTY SOCKS, ASSOCIATED WITH FUMES AND BURNING OF TURBO OIL WAS PRESENT. THE SMELL FADED WITH ALTITUDE AND WAS PRESENT AGAIN AFTER DESCENDING THROUGH 14,000 FEET PERFORMED GVI OF ENG NR 1 & 2, ANSDR SCNA20260108017Light · inoperativeR1 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED FWD ENTRY LIGHT AND REMOVED BATTERY PACK AT M01674 IAW AMM 33-51-06. INSTALLED SERVICEABLE BATTERY PACK AT M01674 IAW AMM 33-51-06. PERFORMED SATISFACTORY OPS CHECK OF FWD BATTERY PACK AND R1 DOOR EMERGENCY SDR SCNA20260108016Light · inoperativeABOVE AISLE EMERGENCY LIGHTS INOP. AT ROW 5, 10, AND 14DEF. REMOVED AND REPLACED BATTERY PACK AT ROW 11 IAW AMM 33-51-06 OPS CHECK GOOD. OK FOR SERVICE.SDR WX0A2026010732696Battery · no test(AIRCRAFT GROUNDED) EPSU BATTERY 10WL FAILED EPSU BATTERY CAPACITY TEST. R & R EPSU BATTERY 10WL IAW AMM 33-51-38-000-002-A / 400-002-A"SDR 2026FA0000006Mount · crackedDURING MINOR PHASE INSPECTIONS, THE RH ENGINE OUTBOARD ENGINE MOUNT P/N: 5951048-2 WAS VISUALLY FOUND TO BE CRACKED. AFTER DEFECT WAS FOUND, ENGINE REMOVAL TOOK PLACE TO INSPECT THE REMAINING TWO ENGINE MOUNTS AND THE FWD. ENGINE TRUSS. NO VISUAL DEFECTS WERE SDR JR2R20260107052Shear Panel · corrodedAFT WET AREA CENTER SHEAR WEB BETWEEN FR86 - FR88 AND RBL11 - LBL11 CORRODED. REPLACED.SDR DALA2026010700153Battery Pack · inoperative(LOG 8501402) R1 DOOR OVERHEAD EMERGENCY EXIT LIGHT + ROWS 1,2,3, + 4 SEAT EMERGENCY EXIT LIGHTS INOP. REPLACED ASSOCIATED EMERGENCY LIGHTS BATTERY PACK PER B737 AMM 33-51. OPS CHECK GOOD.SDR DALA2026010700150Wire · damagedSHIP 3352 33B AISLE EMERGENCY LIGHT INOP. CORRECTIVE ACTION: REPAIRED WIRING PER A330 AMM 33-51. (7920419)