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 AALA202512223706Hinge Fitting · excess playAIRCRAFT WAS NOT GROUNDED: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING #6 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #6 ON RH HORIZONTAL STABILIZER IAW A320F AMM 55-16-42-000-001-A AND A320F AMM 55-16-4SDR AALA202512228869Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING # 5 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #5 ON RH HORIZONTAL STABILIZER IAW A320F AMM 55-16-42-000-001-A AND A320F AMM 55-16SDR AALA202512220851Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING # 3 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #3 ON RH HORIZONTAL STABILIZER IAW A320F AMM 55-16-42-000-001-A AND A320F AMM 55-16-SDR AALA202512224381Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING #2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #2 ON RH HORIZONTAL STABILIZER IAW A320F AMM 55-16-42-000-001-A AND A320F AMM 55-16-4SDR AALA202512220658Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING OF THE ELEVATOR HINGE ARM END FITTING #4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #4 ON RH HORIZONTAL STABILIZER IAW A320F AMM 55-16-42-000-001-A AND A320F AMM 55-16-4SDR AALA202512192290Strut · low pressureAIRCRAFT WAS NOT GROUNDED: AFTER TOUCHDOWN DURING MAX BRAKING CHECK AIRCRAFT PULLS SLIGHTLY LEFT. LEFT MAIN GEAR STRUT APPEARS LOW. SERVICED LEFT HAND MAIN LANDING GEAR SHOCK STRUT WITH NITROGEN. PER AMM12-15-31.SDR IPXA2025121940464Stiffener · crackedFLOORBEAM STIFFENER APPROXIMATELY LBL 48 BS 246 HAS CRACK AT UPPER END VERIFIED WITH HFEC. REMOVED CRACKED FLOOR BEAM STIFFENER AT STA 246 & LBL 48 REF SRM 51-40-02. FABRICATED AND INSTALLED (ANGLE) AT FLOOR BEAM STIFFENER STA 246, LBL 48 REF BOEING DRAWING 1SDR AALA202512190633Control Unit · fault messageAIRCRAFT WAS GROUNDED: ACCOUNT MAINTENANCE CENTER TANK PUMP 2 ECAM SYSTEM FAULT. DECESSION MADE TO RETURN TO DFW NO EMERGENCY DECLARED, AND FLIGHT WAS NOT OVERWEIGHT FOR LANDING. AIRCRAFT LANDED WITHOUT INCIDENT AND TAXIED TO GATE UNDER ITS OWN POWER. MAINTENSDR AALA202512194629Control Unit · fault messageAIRCRAFT WAS GROUNDED, ACCOUNT MAINTENANCE CENTER TANK PUMP 2 ECAM SYSTEM FAULT. DECESSION MADE TO RETURN TO DFW NO EMERGENCY DECLARED, AND FLIGHT WAS NOT OVERWEIGHT FOR LANDING. AIRCRAFT LANDED WITHOUT INCIDENT AND TAXIED TO GATE UNDER ITS OWN POWER. MAINTESDR GTIA2025121839206Nut · corrodedREFERENCE T.C. AOT A57N025-25. FOUND CORROSION ON NR 1 ENG PYLON SPIGOT FITTING NUT.SDR GTIA2025121839205Unknown · odorSTRONG ODOR IN CABIN REPORTED BY PAX, THEN F/A'S, PERFORMED INSPECTIONS IAW TSM 05-50-00-810-831-A. OPS CHECKS OF ENGINES, APU, PACKS ACCOMPLISHED, COULD NOT DUPLICATE DISCREPANCY. ECS DECONTAMINATION ACCOMPLISHED PER AMM 21-00-00-615-802. ACFT OK FOR SERVICESDR GTIA2025121839204A/C Pack · contaminatedFUME EVENT, AIRCRAFT WAS DEICED YESTERDAY MAYBE TWICE, PACK 1 IS GIVING OFF A MODERATE DEICE FLUID ODOR REGARDLESS IF ENGINE OR APU IS RUNNING. THE PACK 1 FUMES CHECK LIST WAS PERFORMED, PACK 1 WAS TURN OFF ODOR DISAPPEARED. ODOR WAS ISOLATED TO THE FLIGHSDR GTIA2025121839203Nut · corrodedREFERENCE TC AOT A57N025-25, FOUND CORROSION ON NR 2 PYLON SPIGOT FITTING NUT. R & R PYLON SPIGOT NUT IAW AMM 57-26-12.SDR SWAA2025121852529Fastener · missingL1 DOOR EMERGENCY ESCAPE SLIDE COMPTARTMENT AFT GIRT BAR RETAINER MISSING ONE FASTENER. REPLACED THE MISSING FASTENER ON THE AFT GIRT BAR RETAINER IAW SRM 51-40-02.SDR SWAA2025121852438Lamp · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS EXTERNAL EMERGENCY LIGHT IAW AMM 33-51-04, OPS CHECKED GOOD.SDR SWAA2025121852448Battery Pack · inoperativeLIGHTS ASSOCIATED WITH EMERGENCY BATTERY PACK M1694 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND PERFORMED GOOD OPS TEST IAW 33-51-06-960-805.SDR SWAA2025121852663Battery · no testCREW REPORTS AFT FLASHLIGHT FAILED TO TEST. REPLACED THE FLASHLIGHT BATTERY IAW SIP.SDR U5QA202512180164Motor · inoperativeLOW BRAKE PRESS & ANTI-SKIP INOPERATIVE LIGHTS ILLUMINATED & FLASHED DURING TAXI. BRAKES APPLIED & NO RESPONES DURING TAXI, EMERGENCY BRAKE HANDLE APPLIED TO STOP THE ACFT. R & R BRAKE SYS C/B, BRAKE MOTOR CONTROL RELAY, & BRAKE SYS MOTOR. BRAKE SYS AND ANTSDR ASAA2025121563132Bulb · inoperativeEMERGENCY EVACUATION LIGHTS BEHIND BOTH WINGS WILL NOT ILLUMINATE. GROUNDED - YES. REMOVED AND REPLACED BULBS FOR EMERGENCY EVAL LIGHTS PER B737-800 AMM 33-51-04-960-801.SDR ASAA2025121563103Hinge · dirtyR1 DOOR VERY DIFFICULT TO CLOSE, SHOWED UP TO A/C DOOR HANDLE WAS STOWED AND RIGHT SIDE OF DOOR WAS SHOWING APPROX. 1 INCH GAP. GROUNDED - YES. CLEANED AND INSPECTED R1 DOOR HINGES AND PERFORMED OPS CHECK IAW AMM 52-41-00. DOOR OPERATES NORMALLY. NO FURTHER DESDR ASAA2025121563098Elec Connector · disconnectedINTERIOR EMERGENCY LIGHT ABOVE ROW 4 INOP. GROUNDED - YES. (RESOLVED ON W/O: 2081532 TASKCARD: N/R-00004 ) FOUND LIGHT CONNECTOR NOT CONNECTED. RE-CONNECT LIGHT. OPS CHECK GOOD. THIS CLEAR MEL 33-51-01A. SEAMC FELIX NOTIFIED. PLACARD REMOVED.SDR ASAA2025121563097Power Supply · inoperativeEXTERIOR EMERGENCY LIGHT ADJACENT TO R2 DOOR INOP. GROUNDED - YES. (RESOLVED ON W/O: 2082118 TASKCARD: N/R-00001 ) REPLACED AFT RIGHT EMERGENCY EXIT POWER SUPPLY REF. MM 33-51-06-960-803 & WDM 33-51-14-2 OPENED & CLOSED 1 C/B. NO HELP WITH AFT RH SLIDE LIGHT. SDR KY7A202512180038Hydraulic Line · leakingFLAP ACTUATOR HYDRAULIC LINE LEAK. REMOVED & REPLACED THE FLAP ACTUATOR HYD LINE IAW SA227 MM 27-50-00 WPB AM C/W RTS CHECK.SDR AALA202512184629Pump · warning messageAIRCRAFT WAS GROUNDED: ACCOUNT MAINTENANCE CENTER TANK PUMP 2 ECAM SYSTEM FAULT. DECESSION MADE TO RETURN TO DFW NO EMERGENCY DECLARED, AND FLIGHT WAS NOT OVERWEIGHT FOR LANDING. AIRCRAFT LANDED WITHOUT INCIDENT AND TAXIED TO GATE UNDER ITS OWN POWER. (OPEN)SDR AALA202512181413Window · scratchedAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 842 WINDOW OUTER PANE SCRATCHED. REPLACED PASSENGER / CREW DOOR 842 WINDOW PER AMM 56-31-13.SDR DALA2025121809205Coffeemaker · odorATB - DUE TO REPORT OF A BURNING RUBBER SMELL IN THE AFT. GALLEY. FOUND COFFEE MAKER AT POSITION A508 TO BE THE SOURCE OF THE SMELL. COFFEE MAKER ELECTRICAL CONNECTOR SHOWING SIGNS OF ARCING. DEFERRED COFFEE MAKER TO NEF. 12/18/2025 REPLACED CABLE LOOM A508 SDR DXTA2025121806150Acm · seizedDURING FLIGHT, CREW NOTICED A WHISTLING SOUND AND ODOR ENROUTE. AS FLIGHT PROGRESSED, CREW AND PAX NOTICED SMOKE. WE SWITCHED FROM ENGINES TO APU BLEED AND IT IMPROVED TO NORMAL. AS WE CONTINUED ON APPROACH, THE WHISTLING STARTED AGAIN ON APU AIR. ECS SYSTEM DSDR UIEA2025121501346Actuator · failedGEAR TILT CAUTION AND STATUS MSG'S FOR LH BODY GEAR PRIMARY AND ALT PROX SWITCH TARGET FAIL. FOUND FAILED TILT ACTUATOR. REPLACING ACTUATOR, HYDRAULIC FUSE, AND LINE TO ACTUATOR. LEAK & OPS CHECKS GOOD. NO DEFECTS NOTED IAW AMM 32-13-24,32-31-00, AND 32-13-2SDR CALA2025121812228Light · inoperativeROW 30 IN SEAT EMER LIGHT INOPERATIVE. R & R THE EMERGENCY LIGHT ASSY, OPS CHECKED SATISFACTORY.SDR CALA2025121812227Light · detachedEMERGENCY EXIT PATHWAY LIGHT ON SEAT 31C IS DANGLING AND NOT SECURE. SECURED THE EMERGENCY LIGHT HOUSING AT SEAT 31C, CHKD GOOD.SDR CALA2025121812226Light · brokenEMERGENCY EXIT OATH SEAT MOUNTED LIGHT BROKEN AT SEAT 10C. R & RTHE EMERGENCY LIGHT ASSY. IAW AMM 33-51-11-960-802. OPS CHECKED GOOD.SDR CALA2025121812219Bulb · failedAISLE 23 EMERGECY LIGHT INOPERATIVE. REPLACED THE BULB AT AISLE 23 EMERGENCY AISLE LIGHT IAW AMM 33-51-05. OPS CHECKED GOOD.SDR CALA2025121812218Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROW 1 - ROW 12. R & R EMERGENCY BATTERY AT LOWER RT DADO PANEL AT BULKHEAD SEAT 10F. IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2025121812216Elec Connector · faultedPARKING BREAK LIGHT ILLUMINATES INTERMITENT DURING TAXI WITH BRE AK OFF PERFORMED FIM 32-44 TASK 804 OPS CHECKS GOOD ON PARKING BRAKE AT THIS TIME. CYCLED MLG BRAKES OPS CHECKS GOOD AT THIS TIME. NO DEFECT NOTED. CLEANED PARKING BRAKE ELECTRICAL CONNECTOR PRIOSDR CALA2025121812215Fmc · failedSHORTLY AFTER T/O L FMC FAILURE. ACCOMPLISHED NON-NORMAL. NO HEL P FMC AND DISPLAY UNIT ORDERED TO B29. NO FMC FAULTS AT CURRENT TIME OR IN RECENT HISTORY. ACOMPLISHED FMC OPERATIONAL TEST AND SYSTEM TEST REF AMMS 34-61-00-710-801 AND 34-61-00-730-801. INCLUDISDR CALA2025121812214Motor · faultedSTAB TRIM FAIL LIGHT ON SHORTLY AFTER ROTATION. PERFORMED SPEED TRIM FAIL FAULT HISTORY CHECK ON CHANNEL A & B, BOTH CHANNELS REPORT FAILURE OF COL SW MODULE M1201. REPLACED F.O'S COLUMN CUTOUT SWITCH(M1201)REF MM 27-41-51-400-801. COLUMN CUTOUT SWITCHS TESDR DALA2025121709200Actuator · faultedMISC/DE-DECLARED AN EMERGENCY INTO ATL DUE TO LEFT AND RIGHT MAIN GEAR UNSAFE LIGHTS. REPLACED LANDING GEAR DOOR ACTUATOR. OPS TESTED NORMAL.(5447268)SDR WX0A2025121732673Unknown · odor(AIRCRAFT NOT GROUNDED) FA REPORTS SMELL IN AFT ON DECENT W/BURNING EYES AND STOMACH ACHES. / C/W OIL TYPE SMELL PHASE 1 T/C 21-000-001. NO DISCREPANCIES NOTED AT THIS TIME. TRACKING UNDER M313. (RESOLVED ON W/O: 538895 TASKCARD: NR-00001 ) C/W TC 21-000-002 -SDR WX0A2025121732672Megaphone · inoperative(AIRCRAFT NOT GROUNDED) FWD MEGAPHONE INOPERATIVE. REMOVED AND REPLACED THE FWD MEGAPHONE.SDR WX0A2025121732670Unknown · odor(AIRCRAFT NOT GROUNDED) WET SOCK SMELL DTETECTED BY BOTH PILOTS AND FORWARD FLIGHT ATTENDANTS DESCENDING THROUGH 10,000 FT / REF LP 2105481 FOR WORK PREFORMED COMPLEATED TASK CARD 21-000-002 NO DEFECTS FOUND THIS ACTION CLEARS MEL 49-10-01A MDDR 223906 PLACKASDR AALA202512173888Light · unsecureAIRCRAFT WAS NOT GROUNDED: G7 GALLEY EMERGENCY WALK WAY LIGHTING ASSEMBLY LOOSE. RESECURED G7 EMERGENCY EXIT WALKWAY LIGHTING ASSEMBLY. PER CMM-25-32-08.SDR AALA202512177541Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY LIGHT NOT ILLUMINATING. REMOVED AND REPLACED L2 DOOR SLIDE EMERGENCY LAMP. PER AMM 33-51-04, OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR DALA2025121709193Repair · damagedDAMAGED EXISTING REPAIR HAS TO BE RE-DONE AT FR 27-28, STR 51L TO 53L. RE-WORKED PER ERA 630655-14. (1353137)SDR DXTA2025121706148Switch · looseTHE OVERHEAD EMERGENCY LIGHTS SWITCH MOUNTING IS LOOSE WITH A LOT OF PLAY. CONCERNED IT MAY COME OUT, OR PUSH BACK INTO PANEL AT SOME POINT. CORRECTIVE ACTION: FOUND OVERHEAD EMER LIGHT SWITCH LOOSE. REMOVED OVERHEAD LIGHT PANEL AND GAINED ACCESS TO THE LOOSE SDR YENA2025121701227Computer · faultedFLT 2233 BOS-SFO ( ETOPS). FUEL ACT XFR FAULT QRH APPLIED WITH FUEL IN AFT 1; REMOVED AND REPLACED FQIC (3QT) AS PRECAUTIONARY IAW AMM 28-42-34. OPS CHK GOOD. NO FURTHER DEFECTS NOTED. MDDR 603334 CLEARED MX-4 UPDATED PLACARD REMOVED.SDR AALA202512177857Deu · faultedAIRCRAFT IN BASE MAINTENANCE: DOOR 3L EVACUATION LIGHT ALWAYS ILLUMINATED. MAINTENANCE FOUND A FAULT MESSAGE FOR DECODER / ENCODER UNIT B 300RH4 (DEU) WAS DISPLAYED ON THE FLIGHT ATTENDANTS PANEL AND REPLACED THE DEU PER AMM 23-73-47. A SATISFACTORY OPERATIONASDR YENA2025121701226Control Rod · faultedFLT 967, HPN-PBI. AN EMERGENCY WAS DECLARED AND AIRCRAFT DIVERTED TO JFK, AFTER T/O LAND GR. (NOSE) DOORS NOT CLOSED. RECYCLED. COMPLIED W/ QRH - PROBLEM PERSISTED; REF LP #'S 4145594 (REF TSM 32-31-00-810-859-A REMOVED AND REPLACED LT & RT NLG DOOR CONTROL ROSDR YENA2025121701225Slide Raft · faultedFLT 488, MCO-ORH. DOOR 2 L SLIDE SHOWS DISARMED IN FLIGHT AFTER PRESSURIZATION. ( PASSENGER OR OVER WING DOOR SLIDE/SLIDE RAFTS (WITHOUT PASSENGERS) ); REMOVED AND REPLACED L2 DOOR SLIDE PER AMM 25-62-44. SLIDE ARM LEVER STILL SHOWS DISARMED ON ECAM. SLIDE ARMSDR CALA2025121712203Fitting · out of adjustR4 DOOR, NOT ABLE TO OPEN FROM OUTSIDE & INSIDE WHILE TROUBLESHOOTING, ARMING HANDLE WILL NOT FULLY DISARM. WHEN IN DISARM POSITION GIRT BAR IS NOT FULLY CAPTURED CREATING BINDING PREVENTING DOOR FROM OPENING. DOOR OPENS NORMALLY WHEN GIRT BAR IS NOT ATTACHESDR CALA2025121712189Light · missingFOUND SEAT 51F EMERGENCY LIGHT DAMAGED AND ENCLOSURE PANEL MISSING. CHANGING SDR TO Y. SEAT 51D EMERGENCY LIGHT ASSY WAS FOUND DAMAGED DURING ROUTINE CABIN INSPECTION. EMERGENCY LIGHT ASSY WAS REPLACED AND OPS CHECKED GOOD, PER AMM 33-51-06-00A-720A-A. SEAT 3