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 AALA202511126686Door · jammedAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY DOOR LOCK IS JAMMING. VERIFIED LAVATORY- D DOOR IS JAMMING. REMOVE AND REPLACED UPPER TRIM. PER CMM 25-40-64.SDR DALA2025111208298Battery Pack · inoperativeUNDER SEAT EMERGENCY LIGHTS INOP BETWEEN 34FG-43FG. FOUND M9009 POWER SUPPLY @ FAULT. R & R BATTERY M9009 + POWER SUPPLY PER WDM 33-51-31 + AMM 33-51. LIGHTS OPS CHK GOOD. (7673354)SDR DALA2025111208295Skin · crackedCRACK WAS FOUND DURING NDT INSPECTION AT FASTENER NR 3 & 4. REPAIRED FWD SERVICE DOOR CUTOUT AFT LOWER CORNER IAW B767-300 SRM 53-10-01 (1294240)SDR DALA2025111208294Skin · crackedCRACK WAS FOUND DURING NDT INSPECTION AT FASTENER NR. 3 & 4. REPAIR IS REQUIRED PRIOR TO FURTHER FLIGHT. AMOC TO AD 24-05-03. REPAIRED FWD SERVICE DOOR CUTOUT AFT LOWER CORNER IAW B767-300 SRM 53-10-01-2R-1 REPAIR 1 (1294213)SDR DALA2025111208280Strut · dischargedDECLARED EMERGENCY FOR THE FLIGHT DUE TO WEIGHT ON WHEELS FAULT WITH POSSIBLE LOSS OF NOSE WHEEL STEERING. JACKED A/C. FOUND RT STRUT NOT FULLY EXTENDED. SERVICED RT STRUT, OPS CHECK GOOD. (LP# 8002764)SDR KCSA2025110861Trans Rectifier · inoperative100281155: MULTIPLE ELECTRICAL FAILURES. ACTION TAKEN: T/S & FOUND DC 1 DIST P6 C/B POPPED IAW B747 WDM 24-54-12. REMOVED & REINSTALLED #1 TRU IAW B747-400 AMM 24-32-01. MSG CLEARED, OPS CHECK FAILED. 100281156: #1 TRU FAIL. ACTION TAKEN: REMOVED & REPLACED #1SDR CALA2025111211165Frame · dentedFWD CARGO BAY FRAME BS 680, DENTED. REPAIRED FWD CARGO FRAME AT BS 680, S23L IAW EC/RA 757-5330-13 -A4168.SDR CALA2025111211163Structure · corrodedRIGHT PYLON SPIGOT BEARING INNER BORE HAS PITTING CORROSION. R & R NR 2 PYLON SPIGOT BEARING IAW AMM 54-51-41-000- 001-A, AND 54-51-41-400-001-A.SDR CALA2025111211161Panel · crackedL-1 DOOR EXTERNAL SKIN UPPER PLATE FWD CORNER HAS CRACK. R & R THE L1 DOOR EXTERNAL SKIN UPPER PLATE IAW SRM 51-72-11-941-001.SDR CALA2025111211159Angle · crackedL1 DOOR CUTOUT FWD UPPER ANGLE REVEAL CRACKED. REMOVED AND REPLACED THE ANGLE REVEAL IAW SRM 51-40-02-0G-0, & DWG 141A8220.SDR CALA2025111211157Channel · crackedFOUND A CRACK AFT CARGO BAY Z-CHANNEL S26L BETWEEN BS 767 & 787. REMOVED AND REPLACED THE Z CHANNEL S26L BETWEEN BS 767 & 787 IAW ARM 51-40-02-0G-0.SDR SWAA2025111133130Bracket · out of adjustFORWARD SERVICE DOOR GIRT BAR WILL NOT STAY ARMED. ADJUSTED THE BRACKETS IAW SIP.SDR SWAA2025111133364Retainer · out of adjustGIRT BAR LOOSE ON FWD RIGHT DOOR. ADJUSTED THE GIRT BAR RETAINER CLIP IAW AMM 25-66-01.SDR SWAA2025111133143Lamp · inoperativeSIDEWALL LIGHT INOPERATIVE AT RIGHT SIDE EMERGENCY EXIT. REPLACED THE LAMP IN THE RT SIDE OVERWING EMERGENCY LIGHT. OPS CHECKED GOOD IAW AMM 33-51-01.SDR SWAA2025111133362Sign · inoperativeAFT FLIGHT ATTENDANT OVERHEAD CALL LIGHT INOPERATIVE. REMOVED AND REPLACED AFT EXIT SIGN ASSY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2025111133124Sign · missingEXIT SIGN MISSING. REPLACED THE SIGN IAW SIP.SDR BJNA202511110001Charger · faultedDURING TRANSIT CHECK FOUND LH OVERWING EXIT LIGHT TO BE INOP. REMOVED AND REPLACED EMERGENCY BATTERY CHARGER AND BATTERY IAW AMM 33-51-06-960.SDR CALA2025111111113Battery · dischargedESPU BATTERY AFT L FAULT, TROUBLESHOT IAW TSM 33-51-00-810-802-A. SUSPECT BATTERY NEEDS REPLACEMENT. REMOVED AND REPLACED BATTERY 13WL IAW AMM 33-51-38-X00-002-A. OPS CHECKED GOOD.SDR CALA2025111111112Sign · crackedOVERHEAD EMERGENCY EXIT SIGN AT SEAT ROW 25 CRACK. REMOVED AND REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-01-960-802.OPS CHECK GOOD.SDR DALA2025111108260Skin · puncturedPUNCTURE ON LT ELEVATOR LOWER SURFACE BTW STA XHS 108 TO XHS 136. LT ELEVATOR LOWER SURFACE BTW STA XHS 108 TO XHS 136 WAS REPAIRED PER SRM 51-70-13 (1293791)SDR ABXA20251108293Skin · corrodedDURING C-CHECK AT AMES (TPA) CORROSION WAS OBSERVED ON THE RIGHT-WING UPPER SURFACE SKIN PANEL NUMBER 1 ON STA WS 616 , THE DAMAGE WAS REMOVED BY BLENDING AFFECTED AREA PER SRM 51-10-02 WITH MEASURED MATERIAL REMAINING OF 0.133¿ INCHES FROM INITIAL THICKNESS OSDR ABXA20251108292Skin · corrodedDURING C-CHECK AT AMES (TPA) CORROSION WAS OBSERVED ON THE LEFT-WING UPPER SURFACE SKIN PANEL NUMBER 1 AT WS 434 OVER UPPER RIB FLANGE P/N 113T1545-7, THE DAMAGE WAS REMOVED BY BLENDING AFFECTED AREA PER SRM 51-10-02 WITH MEASURED MATERIAL REMAINING OF 0.145¿ SDR DALA2025111108253Light · missingPHOTOLUMINESCENT EMERGENCY PATH MARKING HAS A MISING SECTION NEXT TO SEAT 18ABC. R & R EMERGENCY ESCAPE PATH AT 18ABC REF B737 AMM 33-51SDR FDEA202511082151Flap · damagedPUNCTURE ON LOWER SKIN OF AFT INBOARD TRAILING EDGE FLAP RH WING, APPROX 6.250" OF INBOARD EDGE AND 0.500" OF LOWER EDGE. PUNCTURE ON LOWER SKIN OF AFT INBOARD TRAILING EDGE FLAP RH WING WAS EVALUATED AND WAS REPAIRED IAW B767 SRM 57-53-01-2R FIG. 201 DETASDR JJBA20251111062Elec Connector · inoperativeLH FWD EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. NO FIX. FOUND PIN ON HOUSING BURNT (NPIS). REMOVED AND REPLACED LH EXT EMERGENCY LIGHT ASSEMBLY. NO FIX. FOUND NO VOLTAGE ON CANNON PLUG. REMOVED AND REPALCED FUSE ON #1 EMERGENCY BATTERY SDR SIMA20251108002Battery · inoperativeFLIGHT DECK EMERGENCY LIGHT INOPERATIVE. R & R EMEREGENCY LIGHT POWER UNIT 1 IAW AMM 33-50-01. OPS CHECKED GOOD.SDR SIMA20251108003Light · inoperativeCABIN EMERGENCY LIGHT INOPERATIVE. R & R CABIN EMERGENCY LIGHT ASSY IAW AMM 33-50-13. OPS CHECKED GOODSDR ASAA2025110862179Door · stiffFA REPORTS L1 DOOR DIFFICULT TO OPEN AND HAS POSSIBLE TORN SEAL LOWER RIGHT SIDE OF DOOR. GROUNDED - YES. PERFORMED BVI OF DOOR SEAL NO TORN SEAL OR DEFECTS NOTED. CLEANED DOOR TRACK FOR DEBRIS. PERFORMED OPS CHECK L1 DOOR OPEN & CLOSE IAW AMM 52-11-00 OPS CHESDR SWAA2025111033651Unknown · odorUNIDENTIFIED ODD SMELL AT FWD GALLEY. PERFORMED FUMES IN CABIN CONDITIONAL INSPECTION IAW AMM 05-51-56. NO DEFECTS FOUND.SDR SCNA20251110433Fitting · out of adjustDOOR 1L GIRT BAR HARD TO INSTALL IN FLOOR FITTINGS. - READJUSTED GIRT BAR FITTINGS IAW AMM 25-66-01SDR DALA2025111008211Door Frame · crackedCRACK INDICATION AT HOLE #6 AT THE DOUBLE JOGGLE AREA OF THE FR20LH AROUND THE PASSENGER SERVICE DOOR. COMPLIED WITH ER/A 629422-14AD. (1293811).SDR DALA2025111008193Floor Panel · delaminatedDELAMINATED TOP LAYER FLOOR PANEL 211GF IN COCKPIT. COMPLIED WITH ER/A 629679-14. (1294723).SDR DALA2025111008192Floor Panel · delaminatedDELAMINATED TOP LAYER FLOOR PANEL 212GF IN COCKPIT. COMPLIED WITH ER/A 629679-14. (1294717).SDR DALA2025111008191Floor Panel · delaminatedSHIP 3153 DELAMINATED TOP LAYER FLOOR PANEL 231CF IN PASSENGER CABIN. CORRECTIVE ACTION: COMPLIED WITH ER/A 629679-14. (1294714).SDR DALA2025111008218Transmitter · leakingSHIP 3727 -HYD/DE- DECLARED EMERGENCY DUE TO LEFT ENGINE HYDRAULIC PRESSURE LOW LIGHT ILLUMINATED. FOUND 'A' HYDRAULIC SYSTEM PRESSURE TRANSMITTER ON HYDRAULIC SYSTEM PRESSURE MODULE LEAKING. REPLACED PRESSURE TRANSMITTER. OPS CHECK, LEAK CHECK GOOD.SDR DALA2025111008217Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHT ON (1L) DOOR INOP AND ABOVE CREW DOOR. REMOVED/REPLACED BATTERY PACK M1675. OPS CHECK PASSED REF B737 AMM 33-51 AND WDM B737 33-51-21.SDR DALA2025111008216Battery Pack · no testBATTERY PACKS M1671 AND M1695 FAIL CAPACITY CHECK. REPLACED M1671 AND M1695 EMERGENCY BATTERY PACKS AND PERFORMED GOOD OPS CHECK PER B737 AMM 33-51-06.SDR DXTA2025111005621Battery · inoperativeEMERGENCY LIGHTS FLASHING IN FLIGHT WITH SWITCH IN THE "ARM" OR "ON" POSITION. VERIFIED DISCREPANCY, BATTERIES WOULD NOT CHARQE. REMOVED AND REPALCED EMPERQENCY BATTERIES IAW EMB-505S AMM 33-52-01 . OPERATIONAL TEST SUCESSFUL IAW EMB505S AMM 33-52-00-710-801-ASDR AALA202511100644Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK DIFFICULT TO OPERATE. CONFIRMED AFT LAVATORY DOOR INOPERATIVE, WILL NEED A NEW DOOR. (OPEN).SDR AALA202511101467Hinge · stuckAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STUCK CLOSED. REMOVE AND REPLACED DOOR HINGE. PER CMM 25-40-61.SDR AALA202511105061Cam · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER ENTRY DOOR 4L GIRT BAR BRACKET IS DIFFICULT TO INSTALL AND REMOVE. ADJUSTED 4L ENTRY DOOR GIRT BAR BRACKET. PER AMM 25-66-02.SDR AALA202511103104Oven · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT NOTICED A PLASTIC SMELL IN FORWARD GALLEY. ACCOMPLISHE JOB CARD 09L00021001, FOUND NUMBER 2 OVEN IN FORWARD GALLEY TO BE THE SOURCE OF ODOR. REMOVED AND REPLACED NUMBER 2 OVEN. PER AMM 25-32-03.SDR GTIA2025111039171Unknown · odorAFTER PARKING AT THE GATE LEAD FA REPORTED AIR QUALITY EVENT PRIOR TO LANDING ROW 28. DESCRIPTION OF ODOR/FUMES: TEMPORARY, FUEL SMELL. APPARENT CABIN SOURCE: UNKNOWN. AFT CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PERFORMED TYPE 1 LEVEL A ISDR GTIA2025111039170Unknown · odorFUME EVENT IN CABIN AT FL330. DESCRIPTION OF ODOR/FUMES: TEMPORARY, MUSTY DRY SMELL. APPARENT CABIN SOURCE: UNKNOWN. MID CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-REF TSM 05-50-00-810-813-A PERFORMED DECONTAMINATION TYPE PERFORMED PERFORMED SDR GTIA2025111039169Megaphone · inoperativeREAR MEGAPHONE IS INOP.-R/R AFT MEGAPHONE IAW SPIRIT AIRLINE DRAWING A320 EMER EQUIP REV 7 OPS CHECK OKSDR DALA2025111008185Linkage · lack of lubeFA'S UNABLE TO DISARM L1 ON ARRIVAL. CLEANED AND LUBED LINKAGES AND GIRT BAR. OK FOR SERVICE. (7672293)SDR DALA2025111008177Seal · failedSHIP 3426 LT WING SLAT STEADY BEARING SEAL CAME OUT DURING LUBRICATION. CORRECTIVE ACTION: R/R BEARING PER A330 AMM 27-84-59. OK FOR SERVICE. (1294667)SDR DALA2025111008176Channel · damagedSHIP 3418 2 SPOTS OF TOOLING DAMAGE U-CHANNEL I/B REINFORCEMENT AFT SIDE OF FRAME 60 BETWEEN STRINGERS 1R AND 2R. CORRECTIVE ACTION: REPAIRED PER ER/A 628197-14, REV ORIGINAL. (1294760)SDR DALA2025111008175Frame · damagedFRAME 60 LARGE AMOUNT OF TOOLING DAMAGE. R & R FRAME PER A330 SRM 51-72-11-911-001. (1294493)SDR DALA2025111008174Channel · damagedFRAME 60 AFT SIDE BETWEEN STRINGER 1L AND 2L, LH U-CHANNEL REINFORCEMENT (VERSTAERKUNG) ITEM 54 DRAWING 17F53479820 SHEET 48 HAS TOOLING DAMAGE ON THE BOTTOM O/B SIDE. REPAIRED PER ER/A 628197-14 REV ORIGINAL. (1294491)