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 SWAA2025082207180Flashlight · inoperativeCABIN FWD BOTTOM FLASHLIGHT WILL TEST FWD BOTTOM FLASHLIGHT WILL TEST. CABIN FORWARD BOTTOM FLASHLIGHT OPS CHECK GOOD AND REPLACED BROKEN TAMPER SHIELD REF AMM 25-64-00.SDR SWAA2025082206579Light · inoperativePASSENGER CABIN EMERGENCY FLOOR LIGHTING GLOW STRIP NOT SECURE INBOARD OF FORWARD RIGHT WINDSCREEN. SECURED EMERGENCY FLOOR LIGHTING GLOW STRIP INBOAR OF FORWARD RIGHT WINDSCREEN PER AMM SIP.SDR DALA2025082206276Bonding Plate · corrodedCORROSION BONDING PLATE FLAP TRACK FAIRING 2 (531CB) ON LH WING. REPLACED BONDING PLATE FLAP TRACK FAIRING 2 (531CB) ON LH WING AS PER ER/A 622998-14TR. (1156733)SDR DALA2025082206275Floor Support · corrodedCORRODED FLOOR SUPPORT +Y1162.5 AT FR 68. REPLACED THE FLOOR SUPPORT, FR 68 TO 69 IAW SRM 51-42-11. (1156707)SDR DALA2025082206277Insert · corrodedCORRODED FLOOR PANEL INSERT 261PF AT AFT GALLEY AREA. COMPLIED WITH ER/A 627930-14. (1156589)SDR IPXA2025082287818None · noneSDR FOR EO-85445-JIC1 STEP 137SDR IPXA2025082287809Not Reported · not reportedSDR FOR EO-85445-JIC2 STEP 137SDR IPXA2025082287433Flap System · malfunctionedEMERGENCY DECLARED ON APPROACH, WHEN CONFIG., TE FLAP DISAGREE EICAS MSG. FLAPS @ BETWEEN 0 AND 1 REMOVED AND REPLACED RT FLAP TRANSMITTER PER AMM 27-58-03/401. PERFORMED ADJUSTMENT/TEST PER AMM 27-58-01/501. FLAPS/SLATS OPERATE NORMAL. ACFT OK FOR SERVICE.SDR YEN2025F00007Unknown · odorFLT# 882. UVF-JFK. A CABIN ODOR EVENT. THE FLIGHT CREW REPORTED A FUME / ODOR EVENT AT AROUND 6000 FEET ON DESCENT INTO JFK WITH MODERATE INTENSITY. THE SMELL WAS MOSTLY NOTICED IN THE COCKPIT AND MID CABIN. PACK 1 WAS TURNED OFF AND THE SMELL DISSIPATED IN THSDR YENA2025082200868Unknown · odorFLT# 219. BOS-SAN. APPROX 2:30 INTO FLT AT FL 360 FAS IN AFT GALLEY REPORTED SUDDEN INTENSE ACRID SMELL OF CLEANER/ PINE. 15 MINUTES LATER CA WENT BACKTO INSPECT IT HAS DISAPATED SLIGHTLY CA INSPECTED AFT GALLEY FOR POSSIBLE SOURCES BUT FOUND NONE 15 MINUTES ASDR YENA2025082200867Unknown · odorFLT# 219. BOS-SAN. APPROX 2:30 INTO FLT AT FL 360 FAS IN AFT GALLEY REPORTED SUDDEN INTENSE ACRID SMELL OF CLEANER/ PINE. 15 MINUTES LATER CA WENT BACKTO INSPECT IT HAS DISAPATED SLIGHTLY CA INSPECTED AFT GALLEY FOR POSSIBLE SOURCES BUT FOUND NONE 15 MINUTES ASDR DALA2025082206273Window Frame · cracked(LOG 1155742) FUSELAGE RH NO. 3 FLIGHT COMPARTMENT WINDOW FRAME E-F POST LOWER CORNER CRACKED. REPAIRED PER ERA 628209-14.SDR DALA2025082206272Window Frame · cracked(LOG 1156206) CRACK OF 0.062 IN LENGTH ON NO. 1 RH WINDOW FRAME RADIUS AREA. NO. 1 RH WINDOW FRAME UPPER CORNER WAS REPAIRED PER ERA 619132-14 AD TR REV. A.SDR DALA2025082206271Light · inoperative(LOG 7419396) 11D SEAT MOUNTED LED EMERGENCY LIGHT INOP. R & R LIGHT ASSY IAW B737 AMM 33-51. OK FOR SVC.SDR YENA2025082200866Oil Cooler · failedFLT# 814, FLL-HPN(DIVERTED TO MCO).EXCESSIVE OIL CONSUPTION OBSERVED IN #1 ENGINE .5 QTS EVERY 4 MIN. LANDED 1.5 QTS 7.0 QTS AFTER ENGINE SHUTDOWN. OIL PRESSURE WAS 250-260 PSI; RAR IDG DRIVE SEAL ASSY IAW AMM 72-60-28. OPC GOOD AT THIS TIME NO LEAKS NOTED. RESDR VNAA2025082211102Smoke Detector · false activationUPON REACHING CRUISE ALTITUDE SMOKE ALARM WENT OFF AND CREW RAN QRH. PERFORMED OPERATIONAL TEST OF FWD LAVATORY SMOKE DETECTOR IAW AMM 26-16-00-710-802-A01-PSA. OPS TEST GOOD.SDR DALA2025082206267Indicator · inoperativeL1 DOOR. KNUCKLE KNOCKER NOT FULLY IN ARMED POSITION WHEN DOOR CLOSED. ADJUSTED DOOR KNUCKLE KNOCKER AT 1L. 1L DOOR OPS NORMAL PER B757 -200ER AMM 52-11. (7774015)SDR DALA2025082206266Indicator · inoperativeDOOR ARMED KNUCKLE KNOCKER INOPERATIVE. RETRACTABLE DOOR MECHANISM (KNUCKLE KNOCKER) WAS BINDING ON R4 DOOR INTERIOR LINING, ADJUSTED REF B757 AMM 52-11. OPS CHECK GOOD. (1156172)SDR JJBA20250822048Inverter · faultedEMERGENCY LIGHT ON AFT GALLEY PARTITION INOP. T/S TO FAULTY INVERTER, R&R INVERTER. OP CHECK GOOD, OK FOR CONT SERVICESDR DALA2025082206265Girt Bar · lack of lube4R SLIDE WILL NOT ARM. CLEANED DEBRIS FROM GIRT BAR AND LUBED LINKAGES. OK FOR SERVICE. (7869250)SDR DALA2025082206264Shear Tie · damagedSHIP 3406 TOOLING DAMAGE TO SHEAR TIE ON AFT SIDE OF FR 26.1 OB OF STR 8L. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV. ORIGINAL (1156017)SDR DALA2025082206263Wire Harness · unsecureSEATS 33A/B 52A AND 44J SIDEWALL WIRE HARNESS NOT SECURED. SECURED EMERGENCY ESCAPE PATH WIRING IN RACEWAY PER A330 AMM 25-21. OPS CHECK GOOD. (7294947)SDR DALA2025082206262Oil System · leakingAPU HAS INTERNAL OIL LEAK CAUSING SOME SMELL TO GET IN THE AIR CONDITIONING SYSTEM. REPLACED APU PER A330 AMM 49-01. OPS CHECK GOOD. (1155295)SDR JJBA20250822047Lamp · burned outMCD EXTERNAL EMERG LIGHT INOP. REMOVED AND REINSTALLED MCD EMERG LIGHT. OPS CHECK SAT.SDR FDEA202508211521Indicator · damagedR HYD QTY INDICATES 0.00RF ON THE STATUS PAGE. INSTALLED TEMPORARY PLUG-IN PLACE OF THE BROKEN DIFFERENTIAL PRESSURE INDICATOR. EA H-2902-T0384643 A P1 . COMPLIED C/7438951 EA H-2902-T0384643. CORRECTED OIL TO REFLECT LATEST E.A. H-2902-T0384643 REV A.SDR ABXA202508221184Control Valve · leakingDURIING CRUISE, WHEN WE SELECTED GEAR UP WE GOT A C HYD QTY WHEN SELECTED GEAR DOWN WE LOST THE REST OF OUR C HYD FLUID (C HYD PRESSURE LIGHT ILLUMINATED). EMERGENCY DECLARED. ABORTED APPROACH. FOUND LEFT LEADING EDGE SLAT DRIVE CONTROL VALVE LEAKING. REPLACSDR YENA2025082200865Ecs · contaminatedFLT # 2051. BOS-MCO. LEVEL 2 PERSISTANT ENVIROMENTAL SYSTEM ODOR IN FLIGHT DECK AND FWD CABIN (OBSERVED BY 3 CREWMEMBERS) CAUSING EYE IRRITATION. SMELL SIMILAR TO DIRTY SOCKS. APU AND PACKS ON. NO EXTERNAL AIR CONNECTION.; COMPLIED WITH INFO NOTICE 2017 - T15 SDR UIEA2025082101132Shutoff Valve · faultedBLEED OFF ENG R EICAS WITH APU ALREADY ON DEFERRAL. REPLACED RH ENG HPSOV PER AMM 36-11-07 & IPC 36-11-02-0113. OPS CHECK NORMAL. PERFORMED ENG RUNS & ACCOMPLISHED ENG AIR SUPPLY OPS TEST PER AMM 36-10-00. OPS CHK GOOD. NO FAULTS NOTED. ALSO, R & R PRSOV CONSDR AALA202508228170Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON ANGLE FITTING FOR THE EMERGENCY EXIT DOOR ESCAPE SLIDE ENCLOSURE INTERNAL STRUCTURE BETWEEN FR 35.1 AND FR 35.2A AT S28R. REPLACED ANGLE FITTING PER SRM 51-72-11.SDR AALA202508227399Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS #3 EMERGENCY FLASHLIGHT INOPERATIVE. RMAINTENANCE REPLACED FLASHLIGHT PER AMM 25-65-00.SDR AALA202508224256Slide · damagedAIRCRAFT WAS NOT GROUNDED: DURING A SCHEDULED SLIDE CHANGE FOR THE R4 DOOR, MAINTENANCE FOUND THE REPLACEMENT SLIDE WAS BAD FROM STOCK DUE TO IT BEING DAMAGED. MAINTENANCE ROUTED THE DEFECTIVE SLIDE TO BE REPAIRED AND RE-INSTALLED THE ORIGINAL SLIDE PER TASK CSDR AALA202508227938Handle · looseAIRCRAFT WAS NOT GROUNDED: 2R EXIT DOOR ARM / DISARM HANDLE IS LOOSE AND NEEDS TIGHTENED. MAINTENANCE TIGHTENED ARM DISARM HANDLE PER AMM 52-22-22-0401.SDR YENA2025082200864Transfer Sys · faultedFLT# 073, JFK-EDI. (ETOPS) "AFTER DOORS CLOSED ECAM APPEARED FUEL ACT XFR FAULT ( CAUTION ON ECAM 5) ACT XFR FAULT (ACT) ); PER TSM 28-28-00-810-874-A FUEL DISTRUBUTION OUT AT TIME OF DEFFERAL WAS INCORRECT CAUSING MESSAGE TO APPEAR.FUEL DISTRIBUTION HAS BEENSDR DALA2025082206260Bleed Valve · faultedATO DUE TO ENG THRUST LOSS BLEED CONFIG ECAM MSG WHEN T/O POWER WAS SELECTED. R & R APU BLEED VALVE. OPS CHECK GOOD. (7355668)SDR HNAA2025082200576Smoke Detector · false indicationON TAXI OUT, BAG BAY SMOKE INDICATION. FOLLOWED QRC/QRH AND BLEW BAG BAY FIRE BOTTLES AND RTG. R & R CARGO SMOKE DETECTOR #100 + #200 IAW AMM 26-15-01, OPS CHECK GOOD.. R & R CARGO FIRE EXT BOTTLES HIGH RATE AND METERING IRT AMM 26-23-01 OPS CHECK GOOD AT THSDR CALA2025082208053Power Supply · malfunctionedFWD AND AFT ZONE LH CEILING EMERGENCY LT AND DOOR 4L WERE INOP. REPLACED D1L EMERGENCY LT POWER SUPPLY ASSEMBLY M33424 AND REINSTALL D4L EMERGENCY LT BATTERY PACK M33407 AND CHARGE AND TEST RESULT NORMAL AS PER AMM 33-51-06-960-802 & AMM 33-51-06-960-803 REVSDR CALA2025082208052Pca · faultedREPORTED A SPOILERS EICAS, OVERHEAD LIGHT SHORTLY AFTER TAKEOFF. TROUBLESHOOTING INCLUDED BITE OF SCM 1L AND MEGGER CHECKS ON EXCITATION WIRING TO SPOILERS NR 2 & 11, WITH NO SHORTS FOUND. MAINTENANCE REPLACED THE NR 2 SPOILER PCA. OPS AND LEAK CHECKS SATISSDR CALA2025082208051Heater · burnedSMOKE IN PILOT REST AREA COMING FROM VENT, ALSO IN FOWARD GALLEY PER CREW DEBRIEF, F/A STATED SMOKE COMING FROM PILOT BUNK AREW VENTS, DID NOT SMELL ELECTRICAL PER F/A & PILOT THAT INSPECTED AREA. UPON ARRIVAL TO ACFT NO SMELL, ODOR, OR SMOKE SEEN WHEN DOORSDR CALA2025082208050Strap · corrodedMAIN E&E COMP LEFT, CORROSION AT STRAP BETWEEN BS 294.5 - 312, S22L.SDR CALA2025082208049Unknown · odorOVERWHELMING NOXIOUS FUM ES IN AREA OF CAPTAINS S EAT. SMELLS LI KE LAV CHE MICLE. CAUSED BURNING PERFORMED CONDITIONAL INSPECTION PER AMM 05-51-26. TURNED PACKS OFF AND REMOVED EXTERNAL AIR SOURCE. CLOSED AIRCRAFT L1 DOOR AND CYCLED FWD LAV WITH COCKPIT DOOR SDR CALA2025082208048Light · no testINSTALLATION TEST - DURING EMERG LIGHT OPS CHECK, FOUND LIGHT AT SEAT 52F INOP. REPLACED GROUND PROXIMITY EMERGENCY LIGHT REF AMM 33-51-06, OPS CHECK GOOD. OPS CHECK OF EMERG. LIGHT AT 52F IS GOOD IAW AMM 33-51-06 & W/C WELS WCU BATTERY.SDR CALA2025082208047Lamp · inoperativeEMERGENCY LIGHTS OPS TEST WITH THE TEST SWITCH PROCEDURE, MULTIPLE EMERGENCY EXIT IDENTIFIER SIGNS REQUIRE LAMPS. REPLACED THE LAMPS 23 EA IN VARIOUS LOCATIONS IAW AMM 33-51-01-962-001-002 & 33-51-10-962-040 CK OK.SDR CALA2025082208046Battery · faultedBITE FAULT: EPSU BATTERY EMER R REPLACED EPSU BATTERY AT POSITION BATT. EMER R IAW AMM 33-51-38, OPS TEST GOOD.SDR CALA2025082208045Battery · faultedBITE FAULT: AFT L REPLACED EPSU BATTERY AT POSITION AFT L IAW AMM 33-51-38, OPS TEST GOOD .SDR CALA2025082208042Slide · exposedL1 DOOR SLIDE IS EXPOSED AND DOOR IS DIFFICULT TO ARM REPLACED SLIDE DOOR 1L. REF. AMM 25-66-01-000-801, 25-66-01-400-802, 25-66-01-400-803. ACCOMP RII INSPECTION OF DOOR 1L SLIDE INSTALLATION REF. AMM 25-66-01-000-801.SDR CALA2025082208041None · noneOPEN OVERWING EMERGENCY EXIT DOOR AT ROW 21ABC FOR MAINTENANCE ACCESS. CLOSED OVERWING EMERGENCY EXIT DOOR AT ROW 21ABC IAW AMM 52-22-00. VERIFIED ALL MAINTENANCE SPECIFIC SAFETY PROCEDURES FOLLOWED, VISUALLY INPECTED ALIGNMENT, RIG/ ADJUSTMENT AND OPERATIONASDR CALA2025082208040Slide · no discrepancyR2 DOOR SLIDE PRESSURE IN THE RED. PRESSURE TOO HIGH, INSPECTED SLIDE PRESSURE WITHIN LIMITS ACCORDING TO AMM 25-66-01-200/801 OK FOR SERVICE.SDR SWAA2025082106829Screw · missingRAER ENTRY DOOR ON FIRST OFFICERS SIDE GIRT BAR ATTACHMENT PLATE MISSING SCREW. INSTALLED MISSING SCREW ON DRAIN PLATE IAW SIP.SDR 2025FA0000563Bushing · debondedDURING ANNUAL INSPECTION IT WAS NOTED THAT LEFT MLG HAS DISBONDED BUSHING LINER.SDR 2025FA0000562Bushing · debondedDURING ANNUAL INSPECTION IT WAS NOTED THAT LEFT MLG HAS DISBONDED BUSHING LINER. IT WAS ALSO NOTED THE RIGHT BUSHING BEGINNING TO DISBOND.