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 DALA2025101507523Skin · dentedLOWER FUSELAGE SKIN DENTED BETEWEEN FRAME 35.3 AND FRAME 35.4 STGR 44 AND 43L. EVALUATED AND REPAIRED FUSELAGE SKIN DENTED AREA LOCATED BETWEEN FR35.3 AND 35.4 STGR 44 AND 43L IAW A321-200 SRM 53-21-11-283-022 AND 53-21-11-300-036, REPAIR CAT B. (LP 1250149)SDR HNAA2025101500699Wire · brokenEMERGENCY LIGHT STRIP A ROW 1A WIRES ARE BROKEN ON AIRCRAFT SIDE FACT 13OCT25 07:28 ROA INSTALLED NEW CONNECTOR MALE AND SUCKET PER SWPM 20-21-00 PN ON 48-7190 PN ON M39029-32-248SDR HNAA2025101500698Light · brokenEMERGENCY LIGHT STRIP AT ROW 2A IS BROKEN. R & R FLOOR PROXIMITY LIGHT STRIP IAW AMM 35-50-12 PN ON 1013196 PN OFF 1013196SDR CALA2025101510127Pump · faultedNUMBER 2 ENG DRIVEN HYD PUMP LOW PRESSURE, FOLLOWED BY LOSS OF SYSTEM B WHEN STARTED SERVICING B SYS RESERVOIR. FOUND HYD FLUID COMING OUT OF DRAIN MAST NR 2 ENG. REMOVED NR2 ENG HYD PUMP IAW AMM 29-11-11 UP TO ITEM G (10). CONTINUED INSTALLATION OF ENG 2 SDR CALA2025101510126Battery Pack · inoperativeFIRST CLASS SEATS EMERGENCY PATH LIGHTS ARE INOPERATIVE. REMOVED UNSERVICEABLE BATTERY PACK AND REPLACED WITH SERVICEABLE BATTERY PACK AT POWER SUPPLY M1674 IAW AMM 33-51-06. OPS CHECK GOOD IAW AMM 33-51-00.SDR CALA2025101510125Eec · faultedLEFT ENGINE HUNG UP AT LOW POWER SETTING AND WOULD NOT INCREASE ON FINAL ON FINAL, DURING THROTTLE LEVER MOVEMENTS. THROTTLES PULLED BACK & LT ENG N1 DID NOT INCREASE WITH THROTTLE LEVER INPUT, PARTIAL RPM LOSS. EPR DID SHOW THE COMMAND BAR TARGET, BUT NOSDR CALA2025101510104Proximity Switch · faultedFWD ENTRY DOOR LIGHT CAME ON DURING TAKEOFF, EXTINGUISHED ON ITS OWN. PSEU FORWARD ENTRY DOOR SENSOR IS TARGET FAR DURING TAKEOFF, REF FIM 52-20 TASK 80, VERIFIED PROPER RIGGING OF SWITCH S199, IS ADJUSTED LOWER THAN 0.140 AT 0.105. NO HISTORY, INTERMITTENT.SDR CALA2025101510102None · no discrepancyON ROLL OUT, WENT THROUGH FLOW CHECK OF BIRDS ON RT SIDE, PERFORMED DVI PHASE 1 INSPECTION OF AIRCRAFT IAW MM 05-51-14. INSPECTED RADOME AND WX RADAR WITH NO SIGNS OF DELAMINATION, OR DAMAGE. VERFIED WITH FLIGHT CREW WRITE UP WAS PRECAUTIONARY. FLIGHT CREW OSDR HALA20251014318Engine · oil consumptionETOPS - #2 ENG HAS A HIGH OIL CONSUMPTION RATE OVER 0.42 PPH. PERFORM TSM 79-31-00-810-832-A. FOUND EVIDANCE OF FUEL ODOR FROM FOHE OIL. OIL SAMPLE SAVED. REPALCED FOHE PER AMM 79-21-41. PERFORMED TEST 5 ON ENG #2 PER AMM 71-00-00-702-832-A. OPS CHECK CONT HPRSDR GTIA2025101439131Frame · gougedGOUGE FOUND ON FRAME 44 BETWEEN STRINGERS 5R & 6R. RAF-01 3415102-1-REPAIRED SURFACE DAMAGE OF FRAME 44 AFT FACE BETWEEN STRINGER 5R & 6R PER SPIRIT EA 5341-24140. REF AERSALE WORKORDER #004522 CARD #32124 AND RAF-01 3415102-1SDR ASAA2025101361550Light · brokenOVERWING LT FWD, INTERIOR EMERGENCY LIGHT ASSY BROKEN. GROUNDED - YES. REMOVED & REPLACED OVERWING LH FWD, INTERIOR EMERGENCY LIGHT ASSY REF AMM 33-51-01, OPS CKS GD.SDR SWAA2025101424089Water Heater · smokeAFT LAV CAPTAIN SIDE HAS ELECTRICAL SMELL AND VISIBLE SMOKE<[01] PERFORMED CONDITIONAL INSPECTION IAW AMM 05-51-56 AND IFIM 21-00-00-810-830 AND FOUND AFT LH LAV WATER HEATER SIGN/ EVIDENCE OF ELECTRICAL SMEELL. R&R AFT LT LAV WATER HEATER IAW AMM 38-13-01. SDR SCNA202510140007Slide · dislodgedCATERING OPENED L2 WITH SLID ARMED AND PULLED SLIDE OUT OF HOUSING. DID NOT INFLATE - REMOVED AND REPLACED L2 DOOR SLIDE PER AMM 25-66-1SDR DXTA2025101405303Door · lack of lubeON SHUTDOWN, DOOR FAILED TO FULLY ENGAGE/CLOSE. TRIED RESET PROCEDURE. CLOSED BUT LATCH WON'T ENGAGE. OPEN MED AND INSPECTED. CLEANED AND LUBED PINS AS NEEDED. OPERATED DOOR BOTH OUTSIDE AND INSIDE WITH NO DISCREPANCIES NOTED. NO CAS MSG AND DOOR OPERATESSDR SPAA202510131001Battery Pack · inoperativeEMERGENCY FLASHLIGHT IN FORWARD GALLEY LED NOT BLINKING. R&R FLASHLIGHT BATTTERY PER AMM 25-64-06.SDR IXXA20251013065Latch · faultedCREW REPORTED RIGHT SIDE EMERGENCY EXIT WINDOW EXTERNAL LATCH WILL NOT STAY LATCHED. ADJUSTED RIGHT SIDE WINDOW EMERGENCY EXIT EXTERNAL HANDLE SPRING PIN IN ACCORDANCE WITH IAI SUPPLEMENTAL MAINTENANCE MANUAL B767 56-11-04. OPERATIONAL CHECK GOOD.SDR YENA2025101401036Support · corrodedDURING HEAVY MAINTENANCE: CORROSION LOWER SILL LOC. FR68 AT LEVEL STR 23L AT AT GALLEY AREA. PERFORMED PERMANENT REPAIR ON LOWER SILL LOCATED AT LEVEL OF FR68 AND STRG 23L AT AFT GALLEY AREA IAW A321 SRM 53-41-14-300-001 STEP 2.A FIGURE 001 (SHEET 1, SHEET 3SDR QXEA2025101400319Switch · failedDURING TASK CARD E175-26-22-09-720-801-A FUNCTIONAL TEST OF THE APU FIRE EXTINGUISHING SWITCH HARDWARE, THE TEST FAILED. REMOVED FIRE PANEL IAW AMM 26-20-01-000-801-A, REPLACED THE APU FIRE SWITCH IAW SPWM 20-33-01, REINSTALLED FIRE PANEL IAW AMM 26-20-01-400-SDR AALA202510147624Slide · unwanted deployAIRCRAFT WAS GROUNDED: L1 DOOR SLIDE DEPLOYMENT AT GATE UPON DOOR OPENING. REMOVED AND REPLACED 1L DOOR SLIDE. PER JC 09L20025004.SDR FDEA202510131976Skin · gougedLEFT WING, #5 SLAT UPPER T/E BOTTOM SURFACE GOUGED APPROXIMATELY L.E.S. 500. REPAIRED LEFT WING #5 SLAT UPPER T/E WEDGE BOTTOM SURFACE APPROXIMATELY L.E.S. 500 IN REF. TO 767 SRM 57-43-02-2R, PG 1-2 DETAIL 1 & 2, 767 SRM 51-70-10-2R THIS IS A MAJOR REPAIRSDR ABXA20251013267Skin · corrodedTHIS AIRCRAFT IS CURRENTLY UNDERGOING AN A-CHK IN CVG, AND MAINTENANCE FOUND THE RIGHT WING UPPER T/E PANEL AT W.STA 433 TO BE BULGED UP WHERE IT ATTACHES TO THE T/E OF THE WING SKIN. AFTER THE PANEL WAS REMOVED, CORROSION WAS FOUND ON THE T/E OF WING SKIN PANSDR DALA2025101407516Handle · brokenSHIP 696 R1 ENTRY DOOR HANDLE BROKEN. CORRECTIVE ACTION: INSTALLED DOOR HANDLE AS REQUIRED. (7400449)SDR DALA2025101407513Plate · corrodedCORROSION ON SIDE PLATE RH BSTA=1310 TO BSTA= 1380, IS OUT OF LIMITS PER B757-200 SRM 53-00-53-1A PROCEDURE 1 ALLOWABLE DAMAGE 1, FIG. 101, NOTE C , DETAIL V, AND B757 NDT MANUAL PART 4, 51-00-10, PROCEDURE 2. RH SIDE PLATE BTW STA= 1310 TO BSTA=1380 WAS REPLSDR HNAA2025101400699Light · inoperativeEMERGENCY EXIT OVHD LIGHT AT ROW 11 INOPERATIVE. R & R EMERGENCY EXIT LIGHT ASSY ON SIDEWALL AT ROW 12 IAW AMM 33-50-14. OPS CK GOODSDR YENA2025101401034Filter · odorFLT#190, SAN-JFK. "INFLIGHT ADVISED REACHING TO GATE OF AN ODOR EVENT DESCENDING THROUGH 20,000 FT PLATIC BURNING DIRTY SOCK SMELL IN AFT JUMPSEAT. ALSO SMELLED IN ROW 8 JUMOSEAT BUT TO LESSER EXTENT ROW 8 ADVISED ODOR AS WELL BUT MORE FAINT; PERFORMED LEVEL ASDR YENA2025101401033Fcu · leakingFLT 189, JFK-SAN. DESCENDING THROUGH 9000 FT ON ARRIVAL, FLIGHT ATTENDANT IN AFT GALLEY REPORTED FUMES (DIRTY SOCK SMELL). NO SMELL REPORTED IN FORWARD GALLEY. FOUND FCU LEAKING, R & R IAW AMM 49-32-11, LEVEL A DECON IAW AMM 21-00-00,SDR DALA2025101407508Wire · brokenBROKEN WIRES TO EMERGENCY LIGHT @ ROW 18 DEF. INSPECTED WIRING AND FOUND DAMAGED SPLICE R & R SPLICE PER B737 SWPM-20-10. OPS CHK NORMAL.SDR DALA2025101407511Fuse · failedRED EMERGENCY LIGHTS INOP AT ROW 16,17,18 DEF. T/S PER FIM B737-33-50-00-810-801 FOUND FUSE F1 READING OPEN ON METER R/R FUSE PER B737 AMM-33-51. OPS CK GOOD.SDR YENA2025101401032Unknown · odorFLT#394, DEN-BOS. "LEVEL 1 ODOR DESCENDING THROUGH APPROXIMATELY FL250. ODOR WAS DETECTED DESCENDING THROUGH CLOUDS AND PRECIPITATION ( APU SYSTEM ); ACCOMPLISHED OPS CHK OF APU BLEED IAW AMM 49-51-00. OPS CHK NORMAL. NO ODOR DETECTED. A/C OK TO CONT SVC. MDDRSDR SIMA20251013004Light · inoperativePHOTOLUMINESCENT STRIP LIGHT INOP AT ROW 4A. RAR PHOTOLUMINESCENT STRIP LIGHT AT ROW 4A IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA20251013001Light · inoperativePHOTOLUMINESCENT STRIP LIGHT INOP AT ROW 1DF. R & R PHOTOLUMINESCENT STRIP LIGHT AT ROW 1DF IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA20251013002Light · inoperativePHOTOLUMINESCENT STRIP LIGHT INOP AT ROW 21AC. R & R PHOTOLUMINESCENT STRIP LIGHT AT ROW 21AC IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA20251013003Light · inoperativePASSENGER ENTRYWAY PHOTOLUMINESCENT STRIP LIGHT INOP. RAR PASSENGER ENTRYWAY PHOTOLUMINESCENT STRIP LIGHT IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR N6WA2025101405Fitting · corrodedFWD INTERNAL JACK FITTING CORRODED. REMOVED AND REPLACED FWD JACK FITTING IAW CRJ SRM 51-42-21 AND SRM 51-42-06SDR YENA2025101401031Fire Loop · faultedFLT#2260, MAD-BOS. (ETOPS) "ENG 1 FIRE LOOP A FAULT DURING PREFLIGHT ( ENGINE FIRE DETECTION SYSTEMS 1) LOOP A ); T/S PER TSM 26-12-00-810-803-A NO DEFECTS FOUND. FAUTL HAS NOT HIT IN FLIGHT PER PREVIOUS EGS + AVIATAR. AS PRECAUTIONARY REMOVED AND REPLACED FDUSDR N6WA2025101404Angle · corrodedCORROSION ON SERVICE DOOR LOWER SILL ANGLE INBD AND OTBD SIDE. REMOVED AND REPLACED SILL STRIKER ANGLE AT SERVICE DOOR IAW CRJ SRM 51-42-06SDR YENA2025101401030Control Unit · faultedFLT 1333, BOS-SFO. (ETOPS) CLASS II MSG MAINTENANCE MSG FUEL AT GATE; (RESOLVED ON W/O: 1449175 TASKCARD: NR-00001) AVIATAR RELATED MSGS POINT TO FIN 7QJ. REMOVED AND REPLACED FLSCU @ 7QJ AS PRECAUTIONARY T/S. OPS TEST GOOD IAW AMM 28-46-34. MDDR CLEAR. MX-4 SDR YENA2025101401029Warning Message · false activationFLT#188, LAX-BOS. (ETOPS) AC GEN CLASS II ( CLASS II MX MSG - GPCU OR AC GEN ); FOLLWED TSM 24-22-00-810-832A BITE TESTS PASSED NO ACTIVE MSGS MDDR CLEAR MX-4 UPDATED.SDR REXA2025101400918Lug · crackedRH FWD EMERGENCY EXIT FOUND UPPER FWD LUG TO BE CRACKED REPAIRED RH FWD EMERGENCY EXIT DOOR S/N SB0596 IAW GREO 670-52-21-103 REV -- DATED: 2024-11-06.SDR N6WA2025101402Fitting · corrodedFWD LH JACK FITTING CORRODED. REMOVE AND REPLACED JACK FITTING IAW CRJ SRM 51-42-06 AND SRM 51-42-21SDR N6WA2025101401Floorbeam · corrodedFLOOR BOARD ATTACHED BRACKET AT FS280.00 HAS CORROSION. REMOVED AND REPLACED FLOORBOARD ATTACHED BRACKET AT FS280.00 IAW CRJ SRM 51-42-21SDR 2025F00243Fire Detector · failedDISCREPANCY: FIRE DET 2 FAIL.SDR 2025F00242Warning Light · illuminatedLANDING GEAR NOSE DOWN NOSE GEAR RED LIGHT ILLUMINATED PIN RETRACTED PROCEEDED AS QRH NOSE GEAR LIGHT WENT GREEN AND LANDED WITH NO ISSUES. AIRCRAFT FAIRY FIGHT FROM HAVANA CUBA TO MIAMI MAIN BASE. FOUND NOSE GEAR PROXIMITY SENSOR UP/DOWN LOCK CONNECTOR LOOSSDR 2025FA0000710Fire Detector · failedDISCREPANCY: FIRE DET 2 FAIL.SDR DALA2025101407498Retainer · corrodedSHIP 3124 G5 GALLEY HAS DELAMINATION REPORTED IN TROLLEY RETAINER BLOCK COMPARTMENT 510, 511, AND 512 ON EMPOWER NR 327, 328, AND 329. CORRECTIVE ACTION: REPLACED PER ERA 629680-14. (1249884)SDR DALA2025101407497Door · no discrepancyPASSENGER SAID THE LEFT EMERGENCY EXIT DOOR WAS LEAKING. INSPECTED AREA & FOUND NO DAMAGE PER A319 AMM 52-22.NO PRESSURIZATION ISSUES REPORTED.NO 30DAYS HISTORY.MCC NOTIFIED.OK FOR SVC. (7536882)SDR YENA2025101401024Windshield · no discrepancyFLT#277, FLL-SFO. (AN EMERGENCY WAS DECLARED AND THE AIRCRAFT PERFORMED AN AIR TURNBACK TO FLL) "BIRD STRIKE ON RIGHT SIDE OF FIRST OFFICERS WINDSHIELD ABOUT 4000 FEET; PERFORMED DVI FOR BIRD STRIKE. NO DAMAGE NOTED. CLEANED THE AREA OF AIRCRAFT WHERE BIRD BSDR CALA2025101410075Spar · crackedNO.2 PYLON UPPER FWD SPAR DOUBLER HAS CRACKED AT R/H SKIN. GENER ATED BY V919150 ON HAECO LCQ NR 9298226/40226. ESFR INFORMATION UPDATE REPAIR AREA ON #2 PYLON UPPER FWD SPAR DOUBLER AT RT SKIN IAW A3 20 SRM 54-52-12-300-036. ACMP BY V901914SDR CALA2025101410074Channel · crackedMAIN CABIN, AFTER REMOVED DOME N UTS FLOOR STRUCTURE, FOUND T-CHANNEL WITH A CRACK AT FR1180 LBL 0. REMOVED FLOOR PANEL SUPORT FROM FR1190 LBL 0 MAIN CABIN IAW SRM 51-40-02 FABRICATED LOCATED AND DRILLED NEW SUPPORT IAW SRM 51-40-03-OG-0 AND DWG 144N8006 APPLSDR CALA2025101410073Light · brokenESCAPE PATH LIGHTING UNIT LOCATED AT SEAT 22C HAS BEEN BROKEN OFF. ADDING PICTURE. R&R'D EPL LIGH ASSY AT SEAT 22C AND REPLACED SOCKETS ON HARNESS FOR EPL AT 22C. OPS CHK GOOD. REF CMM 25-22-69-4411 AND SWPM 20-00-00.