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 AALA202508261008Sdac · faultedAIRCRAFT WAS NOT GROUNDED: DOOR LEFT AFT EMERGENCY EXIT FLICKERED ON THEN OFF 2 TIMES IN CLIMB OUT THEN EVENTUALLY IN CLIMB STAYED ILLUMINATED. PRESSURIZATION AND CABIN CLIMB RATE NORMAL THROUGHOUT FLIGHT. THE LIGHT INDICATING ARMED IN CABIN NOT ILLUMINATED. SDR AALA202508263546Transmitter · faultedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF DURING CLIMB THE #1 ENGINE OIL QUANTITY INDICATING 2.5 QUARTS AND FLASHING. THE AIRCRAFT LANDED SAFELY AT DFW AND TAXIED TSDR U5QA202508180159Speaker · faultedELECTRICAL FAULT IN AMBER ON GROUND. POWER DOWN RESTART CLEARED FAULT. IN AIR MESSAGE RETURNED & STAYED ON EVEN ON GROUND. HAPPENED MULTIPLE TIMES. AT 43,000 SUDDEN VERY LOUD GARBLED WIND NOISE, WHITE NOISE OR STATIC SOUND HEARD THOUGHT ENTIRE ACFT. VERY SDR SWIA2025082500018Bracket · pulledFOUND PAX DOOR POWER ASSIST MOTOR PULLEY BRACKET PULLING AWAY FROM DOOR STRUCTURE AND TORE SURROUNDING SHEET METAL. (FILED CLOSED)COMPLIED WITH REO 670-52-11-1496 REV -- DATED 2025-8-24SDR DALA2025082506288Window Frame · cracked(LOG 1150740) CRACK ON WINDOW FRAME NO. 3 RH FDW LOWER CORNER AT FLIGHT COMPARTMENT. WINDOW FRAME NO. 3 RH FDW LOWER CORNER WAS REPAIRED PER PRI 628209-14 REV. 0 TO REV. 3 AND ERA 628209-14AD REV. ORIGINAL, SECTION I: PERMANENT REPAIR.SDR CALA2025082508075Floorbeam · corroded(B737-53-3-0737) MAIN CABIN FWD WET AREA LT STA 344 LBL50 FLOOR BEAM HAS CORROSION AT GALLEY FITTING AND TRACK. REPAIRED STA 344 FLOORBEAM PER UAL ECRA 5315-01226.SDR JJBA20250822045Elec Connector · faultedFLAP FAIL, SPS ADVANCED EICAS MESSAGE DISPLAYED AFTER MOVING FLAP HANDLE DURING APPROACH. REMOVED AND REPLACED ELECTRICAL CONNECTOR PLUG P1104. FLAPS OPS CHECK GOOD. PERFORMED FLAP SCREWJACK ACTUATOR LUBRICATION ON ALL FLAP ACTUATORS. PERFORMED FLAP SCREWJACK SDR AALA202508221008Indication Sys · faultedAIRCRAFT WAS NOT GROUNDED: DOOR LEFT AFT EMERGENCY EXIT FLICKERED ON THEN OFF 2 TIMES IN CLIMB OUT THEN EVENTUALLY IN CLIMB STAYED ILLUMINATED. PRESSURIZATION AND CABIN CLIMB RATE NORMAL THROUGHOUT FLIGHT. THE LIGHT INDICATING ARMED IN CABIN NOT ILLUMINATED. SDR AALA202508223709Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 32C PATH LIGHTING MODULE DETACHED AND INOPERATIVE. MAINTENANCE REPLACED ESCAPE PATH LIGHT RACEWAY SHROUD PER AMM 33-51-18.SDR YENA2025082200862Computer · failedFLT # 2288. JFK-AMS. (ETOPS) CLASS 2 STATUS MSG MAINTENANCE SMOKE ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 2) FAULT(S) INDICATED BY SMOKE );MEL 26-00-00B CAT C PLACARD MX 4 MCC HAROON. R/R FWC #2 IRT AMM 31-53-34. OPSDR YENA2025082200861Valve · obstructedFLT # 1326, MBJ-FLL. DURING REMOVAL OF THE OFF WING SLIDE FOUND THE VALVE PIN HOLE IS PARTIALLY BLOCKED. MAKE IT IMPOSSIBLE TO INSTALL THE SAFET PIN ; ACCOMPLISHED CONTROLLED SLIDE DEPLOYMENT REF BD 500-J25-63-00-00AAA- R/H OVERWING.R/R R/H OVERWING SLIDE PACKSDR DALA2025082206258Seat Track · corrodedG2 INBD GALLEY TRACK CORRODED. REPAIRED SEAT TRACK PER B717 SRM 53-20-52 (1150808).SDR DALA2025082206257Door Latch · damagedAFT CARGO DOOR OPENING,- FORWARD EDGE AT DOOR LATCH. REPAIRED IAW SRM 53-20-15-2R (1150939)SDR CALA2025082208031Filter · odorCAPTAIN REPORTS RUBBER SMELL IN THE FLT DECK CAPTAIN REPORTS RUBBER SMELL IN THE FLT DECK DURING TAXI PER TOMC. REMOVED AND REPLACED RECIRCULATION FILTERS IAW 21-21-41-000-001-A. RAN APU AND PACKS NO SMELLS NOTED.SDR CALA2025082208030Unknown · odorUPON ENTERING AIRCRAFT, I NOTICED A FAINT BURNING SMELL. SEVERAL PASSEGERS WERE COMPLAINING ABOUT SMELLING SMOKE AS WELL. SMOKE REPORT HAS BEEN FILLED OUT WITH AS MUCH INFO AS I COULD GET. AFTER COMPLETION OF L/P 5966673, NO FURTHER ABNORMAL SMELL DETECTED.SDR SWAA2025082105677Flashlight · no discrepancyCOCKPIT EMERGENCY FLASHLIGHT DOES NOT TEST. COCKPIT FLASHLIGHT PERFORMED OP CHECK IAW AMM 25-64-00, OPS CHECK GOOD.SDR SWAA2025082105674Flashlight · not seatedNO GREEN LIGHT ON EMERGENCY COCKPIT FLASHLIGHT PUSH TO TEST. REMOVED AND REINSTALLED FLASHLIGHT SO PRONGS LINE UP IAW AMM 25-64-00.SDR SWAA2025082105669Flashlight · not seatedFWD INBD F/A FLASHLIGHT INOPERATIVE. ADJUSTED FWD INBD FA FLASHLIGHT ONTO CHARGING PINS OPS TESTED GOOD IAW AMM 25-64-00.SDR SWAA2025082105699Cradle · fodCAPTAIN EMERGENCY FLASHLIGHT WILL NOT TEST. CLEANED FOD FROM CA'S FLASHLIGHT BATTERY CHARGER IAW SIP. MEL 25-64-02A SP1B CLEARED.SDR SWAA2025082105671Slide · out of positionAFT LH DOOR SLIDE LOWER FLAP OUT OF CASE. REPOSITIONED SLIDE PER MT 725-61-06SDR SWAA2025082105688Slide · partial deployFORWARD SERVICE ENTRY ESCAPE SLIDE PARTIALLY DEPLOYED. REPOSITIONED FWD SERVICE ENTRY ESCAPE SLIDE PER AMM 25-66-01 AND MT 725-61-06.SDR SWAA2025082105574Slide · dislodgedEMERGENCY SLIDE L1 DOOR DROPPED OUT OF THE SLIDE CONTAINER. REINSTALLED FWD ENTRY ESCAPE SLIDE IAW AMM 25-66-01 & MT 725-61-06-FE.SDR SWAA2025082105691Slide · out of adjustL1 SLIDE DRAGGING FLOOR. PERFORMED MT# 725-61-06.SDR SWAA2025082105567Slide · looseL1 DOOR SLIDE IS LOOSE. SECURED THE L1 DOOR SLIDE IAW AMM 25-66-01.SDR SWAA2025082105566Holder · looseFWD SERVICE DOOR GIRT BAR HOLDER IN THE UNARMED BRACKET WILL NOT HOLD THE BAR SECURE. COMPLIED WITH EA M-23-125-01839SDR SWAA2025082105558Slide · dislodgedL1 DOOR SLIDE DISLODGED DUE TO PARTIAL OPENING OF DOOR WITH GIRT BAR STILL INSTALLED. REINSTALLED L1 DOOR SLIDE IAW AMM 25-66-01SDR SWAA2025082105535Guard · stuckEMERGENCY LIGHT COVER STUCK IN ARM POSITION. R & R EMERGENCY LIGHT SWITCH GUARD IAW SIP.SDR SWAA2025082105658Battery · inoperativeTWO EMERGENCY LIGHT BATTERY INOPERATIVE. R & R BATTERY AT 20 ABC AND R & R BATTERY AT AFT GALLEY IAW AMM 33-51-06.SDR SWAA2025082105507Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTING INOPERATIVE. REMOVED AND REPLACED L1 DOOR EMERGENCY LIGHTING BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025082105849Battery Pack · inoperativeRIGHT SIDE EMERGENCY BATTERY PACK M1676 INOPERATIVE. REMOVED AND REPLACED IAW AMM 33-51-06-960-805.SDR SWAA2025082105651Battery Pack · inoperativeAFT SERVICE DOOR INTERIOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT R2 SERVICE DOOR IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR SWAA2025082105520Vapor Barrier · crackedFOUND EIGHT CRACKS ON AFT SIDE OF VAPOR BARRIER IN WHEEL WELL FORWARD SIDE, RBL 32 TO RBL 37, WL 154. SEE TTG8Q014MD18 FOR WORK PERFORMED.SDR SWAA2025082105521Vapor Barrier · crackedFOUND THREE CRACKS ON AFT SIDE OF VAPOR BARRIER. RBL 45 TO RBL 48, WL 157. SEE TTG8Q014MD0A FOR WORK PERFORMED.SDR SWAA2025082105533Lamp · inoperativeTWO EXTERIOR EMERGENCY LIGHTS ON CAPTS SIDE INOPERATIVE. REPLACED THE LAMPS. OPS CHECK GOOD IAW AMM 33-51-04.SDR SWAA2025082105931Retainer · fodFA REPORTS FWD LEFT GIRT BAR DIFFICULT TO ARM & DISARM. CLEANED GIRT BAR RETAINER IAW SIP.SDR DALA2025082106247Winglet · damagedFOUND LIGHTNING STRIKE DAMAGE ON LH WINGLET TIP. BLENDED DAMAGE PER A220-ASRP-57-32-02-01AAA-664A-A.(TJ 538079) COMPLIED WITH HFEC INSPECTION OF THE BLENDED AREA ON THE LH WINGLET TIP-NO DEFECTS OR CRACKS NOTED ON INSPECTION PER A220 ANDTP 51-01-08-01AAA-353A-SDR DALA2025082106245Floor Panel · corrodedAFT SERVICE ENTRY DOOR LOWER FLOOR PANEL CORRODED. REMOVED FLOOR PANEL AFT SERVICE DOOR DAMAGED AND INSTALLED NEW FLOOR PANEL AFT SERVICE DOOR I.A.W A220 AMP BD500-A-AJ53-00-47- 14AAA-720A-A. (LP# 1150576)SDR DALA2025082106238Engine · bird ingestionSHIP 3228 DISC: MULTIPLE BIRD STRIKES ON FINAL APPROACH TO CHS EVIDENCE OF BIRDSTRIKE TO NR 2 ENGINE SMELLS IN CABIN. SMOKE/FUMES QUESTIONARE FORM SUBMITTED. C/A : C/W BIRD STRIKE INSPECTION IAW AMM 05-51 FOUND EVIDENCE OF BIRD STRIKE IN #2 ENGINE. C/W WITH BISDR ABXA20250818183Anti-Skid Sys · faultedON FINAL FOR 10L INTO KORD, GEAR DISAGREE AND TAILSKID EICAS RAN CHECKLIST AFTER GO AROUND. ABORTED APPROACH. (AAP) CAME BACK AFTER CALLING MX CONTROL AND RUNNING QRH. IN ORD, CONFIRMED TAIL SKID DID NOT DEPLOY. ABOUT 10 MINUTES AFTER BLOCK IN THE TAIL SKSDR CALA2025082108016Pressure Switch · faultedLEFT AUTOPILOT WILL NOT ENGAGE AT ALL. LT AUTOPLT WILL ONLY STAY ENG AGED FOR 5 SECS THEN TRIP OFF. FOUND NO CB'S TRIPPED. LAST LEG FAULTS SHOWS TEN FAULT OCCURENCES FOR BOTH CHANNELS. CH A, 22-11822, 22-11208, CH B 22-11535, 22-11822. WHILE ATTEMPTING TOSDR CALA2025082108006Frame · corrodedAFT CARGO COMPARTMENT GOUGES ON UPPER FLANGE BTW STA 887, STGR 2 7L AND STGR 25R. DIP NEEDS TO BE APPLIED. REAPAIRED AFT CARGO COMPARTMENT ON UPPER FLANGE BTW STA 887, STG R 27L AND STGR 25R. WORK DONE IAW SRM 53-60-07-2R-2 AND PERFORMED NDT NO CRACK SIGNASDR CALA2025082107994Warning Message · false activationDOOR FWD CARGO ECAM AFTER LANDING OPEN AND CLOSED FWD CARGO DOOR. INSPECTED PROX SWITCH AND CLEANNED TARGET. NO FAULTS NOTED OPEN AND CLOSED INDICATIONS ARE NROMAL IAW AMM 52-31-00-810-801-A.SDR CALA2025082107993Bracket · looseFA REPORTS R1 DOOR SLIDE BRACKET RIGHT HAND SIDE IS LOOSE ADJUSTED GIRT BAR RETAINER CLIPS, OPS CHECK NORMAL.SDR CALA2025082107992Handle · unsecureLEFT AFT ENTRY DOOR EICAS C THE LEFT AFT ENTRY DOOR IS NOT LATCHED 18000FT ON DESCENT CABIN REMAINED PRESSURIZED DOOR HANDLE MOVED UP. PREFORMED OPS CHECK OF DOOR SENSOR AND FOUND CLEAN OF DEBRIS ALL WERE WORKING AS NORMAL ALSO, CHECK INSIDE DOOR HANDLE WORKSDR CALA2025082107991Lanyard · out of positionUNABLE TO DISARM DOOR 1R FOUND SLIDE LANYARD BINDING WITH GIRT BAR, ADJUSTED LANYARD, DOOR ARMS AND DISARMS NORMAL AT THIS TIME. OPERATED SEVERAL TIMES, OPENED AND CLOSED DOOR SEVERAL TIMES. OK TO CONTINUE.SDR CALA2025082107990Indication Sys · faultedDOOR 1L/R DOOR ARMED INDICATORS SHOW YELLOW INDICATION ARE OK NO FURTHER MAINT NEEDEDSDR CALA2025082107989Strap · out of position20A EMERGENCY EXIT. HOOK AND LOOP WEAK ON DOOR PANEL. FOUND RED STRAP FOR OVER WING HATCH OUT OF IS POCKET AND LAYING ACROSS HOOK AND LOOP. TUCKED RED STRAP BACK INTO IS POCKET. HOOK AND LOOP CAN NOW ENGAGE. OPS CHECKS GOOD.SDR CALA2025082107988Door · leakingPAX REPORTED LOUDER AIR NOISE AT 31D. CONFIRMED BY F/A AND PILOT COMPARE D TO 31A. BOTH EMERGENCY EXIT NO PRESSURIZATION ISSUE REPORTED, GVI OF ALL 4 EMERGENCY EXITS SATIS, FLUSHNESS OF ALL 4 EMERGENCY EXITS ALSO CHECKED SATISSDR CALA2025082107987Cover · damagedDOOR 2R SLIDE COVER DAMAGED. INSPECTED DOOR 2R SLIDE COVER AND SURROUNDING AREA. COULD NOT FIND ANY DISCREPENSIES. REF AMM 25-66-00.SDR ASAA2025081860220Sign · detachedEXIT LABELED SIGN FELL OFF BELOW OUTBOARD FORWARD FLIGHT ATTENDANT SEAT. GROUNDED - YES. RE-INSTALLED EXIT SIGN OK FOR SERVICED PER AMM 33-51-01