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 SWAA2026012658151Floor Support · crackedCABIN FLOOR SUPPORT, BS 537.5, LBL 2 CRACKED. R & R THE FLOOR SUPPORT IAW SRM 51-40-02.SDR VNAA20260125015Fitting · corrodedCORROSION ON MACHINED FITTINGS, FROM BS 517 & 565, AND FROM BS 629 & 661+16 ON CTR DOOR IN FWD CARGO BAY. THE MACHINED FITTINGS WERE EVALUATED OUT OF LIMITS IAW SRM 53-32-58-101-001-A01 AND WERE REPLACED IAW SRM 51-42-10-001-001-A01, SRM 51-42-21-001-001-SDR VNAA20260125009Support · corrodedCRACKS ON AFT DIAPHRAGM, BOTH (LBL17 & RBL17) AT AFT WING TO FUSELAGE FAIRING SUPPORT STRUCTURE. THE AFT WING TO FUSELAGE FAIRING SUPPORT STRUCTURE WAS REPAIRED IAW REO 690-53-82-263 REV -, AND IAW REO 690-53-82-261 REV -.SDR ASAA2026010463865Charger · inoperativeEMERGENCY LIGHTS IN CABIN ARE OUT FROM OVERWING DOORS FORWARD. GROUNDED - YES. OPENED FOUR BATTERY PACK ACCESS PANELS AND REPLACED BATTTERY PACKS OPS CHECK GOOD AND CLOSED ACCESS PANELS IAW B737-900 AMM 33-51-06-960-805. (S/N 138291, 138372, 428810, 428814)SDR SWIA2026010475093Flap Track · wornLEFT FLAP TRACK 1A HAS A THICKNESS REDUCTION OF .023 INCH. REMOVED AND REPLACED THE LT FLAP TRACK 1A IAW AMM 57-54-25.SDR DXTA2026010806439Uplock Switch · faultyUPON GEAR RETRACTION WE RECEIVED A GEAR DISAGREE L CAUTION MSG FOLLOWED BY A ADC SSEC MISCOMPARE. LEFT GEAR INDICATION DISPLAYED AN AMBER DN. FOLLOWED QRH GUIDANCE AND EXTENDED THE GEAR NORMALLY FOR A RETURN LANDING. HISTORY SHOWED LT UPLOCK SWITCH REPLACED 12SDR DXTA2026010806441Actuator · faultyAFTER EXTENDING THE GEAR THE NOSE GEAR GREEN INDICATER DID NOT ILLUMINATE FOLLOWED BY A GEAR DISAGREE N AMBER CAS MESSAGE. THE GEAR FELT AND SOUNDED AS IF IT WAS DOWN AND IT WAS AN INDICATING ISSUE. WE EXECUTED A GO AROUND. ON THE SECOND EXTENSION WE HAD THE SDR ASAA2026010463657Seat Track · damagedFIRST OFFICER'S SEAT AFT INBOARD SEAT TRACK HAS ELONGATED HOLES BEYOND LIMITS. GROUNDED - YES. REMOVED AND REPLACED NEW SEAT TRACK AT FIRST OFFICER SEAT AFT INBOARD AND OPS CHECK GOOD IAW IPECO CMM 83-01-02.SDR ASAA2026010463656Seat Track · damagedCAPTAIN'S SEAT AFT INBD SEAT TRACK HAS ELONGATED HOLES BEYOND LIMITS. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED CAPITAIN SEAT AFT INBOARD SEAT TRAK IAW CMM 53-01-02, AMM 25-11-01-000-801, 25-11-01-400-801 AND 20-50-11-910-801.SDR ASAA2026010463655Power Supply · inoperativeRIGHT OVERWING AND BEHIND THE WING EMERGENCY LIGHTS FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1671 IAW AMM 33-51-06-960-802. OPS CHECKED GOOD.SDR ASAA2026010463654Power Supply · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1677 IAW AMM 33-51-06-960-802. OPS CHECKED GOOD.SDR ASAA2026010463653Battery Pack · no testLEFT OVERWING AFT & BEHIND THE WING EXTERNAL EMERGENCY LIGHT FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1670 IAW AMM 33-51-06-960-802. OPS CHECKED GOOD.SDR ASAA2026010463652Battery Pack · no testEMERGENCY LIGHT AT ROW 17 RIGHT HAND FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M1671 IAW AMM 33-51-06-960-802 ON MIG5 NONROUTINE SA065249. OPS CHECKED GOOD.SDR ASAA2026010463651Battery Pack · no testR1 DOOR EXTERNAL EMERGENCY LIGHT FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK M2816 IAW AMM 33-51-06-960-802. PERFORMED OPS CHECKED GOOD.SDR ASAA2026010463650Battery Pack · no testR2 DOOR EXTERNAL EMERGENCY LIGHT FAILED CAPACITY TEST. GROUNDED - YES. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06-960-802. PERFORMED OPS CHECKED GOOD.SDR AALA202601102269Connector · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SECTION CONNECTION INTERNAL STRUCTURE LOCATED FR66 AT LEVEL STR 23L AT AFT GALLEY AREA. MAINTENANCE REPLACED SECTION CONNECTION INTERNAL STRUCTURE ON FR66 AT LEVEL STR 23L AT AF GALLEY AREA IAW A319 SRM 51-72-11-911-001 AND SDR ASAA2026010463615Skin · crackedLEFT HORIZONTAL STAB LOWER SKIN IS CRACKED AT THE I/B SIDE OF RIB STA 138.70, 9 INCHES AFT OF L/E262A001. GROUNDED - YES. REPAIRED LOWER SKIN IAW SRM 55-10-01-2R-11. CATEGORY B REPAIR INSPECTION REQUIREMENTS INSPECTION THRESHOLD 56,000 TOTAL FLIGHT CYCLES, REPSDR AALA202601092937Window · crazedAIRCRAFT IN BASE MAINTENANCE: WINDOWS ON RIGHT HAND OVERWING EXITS CRAZED AND SCRATCHED. REMOVED AND REPLACED RIGHT HAND FORWARD EXIT DOOR WINDOW. PER AMM 56-22-00.SDR CALA2026010812799Web · gougedEA 5311-01827 REV G, DURING PERFORM EA STEP 2.B FOUND GOUGE IN EXISTING REPAIR AT BS 1640, S14R TO S15R, REMOVED DAMAGED WEB AND REPLACED BY NEW IAW SRM 51-40-02-0G, AND DWG:1 46N8713, REV, P SH 1. REF NRC 139492.SDR CALA2026010712789Wire Harness · damaged34C EMERGENCY PATH LIGHT INOP. ALL OTHER EMERGENCY LIGHTS ARE OPERATIVE. FOUND BAD WIRE BY THE END OF CONNECTOR AT FLOOR COVER. REPLACED EMERGENCY PATH LIGHT AT 34C. NO HELP. FOUND DAMAGED HARNESS FOR EMERGENCY PATH LIGHTING UNDER 34A. ALL OTHER EMERGENCYSDR SWAA2026010858254Oil System · leakingLOST OIL QUANTITY THEN WE LOST OIL PRESSURE ON NR 1 ENG. SHUTDOWN AND LANDED WHITE BOX CAME ON FOR THE OIL QTY AND 20 MINS LATER WENT YELLOW THEN RED ON THE OIL PRESSURE. REMOVED AND REPLACED #1 ENGINE I/A/W MT 771-00-01. REF TTG8Q015T71N FOR ACCOMPLISHMENTSDR DXTA2026010806429Light · malfunctionedWITH EMER LIGHTS IN THE ARM POSITION-NO LIGHTS ILLUMINATE. HOWEVER, EVERY 30 SECONDS OR SO, ALL OF THE EMERGENCY LIGHTS FLASH TEMPORARILY (SEE ATTACHED VIDEO). GAINED ACCESS TO PILOT CONTROL EMERGENCY LIGHTS RELAY (KC005) PN: M83536/15-022L NSN THEN INSTALLESDR DXTA2026010806437Landing Gear · faultedREPEAT WRITE UP AFTER TAKOFF AFTER GEAR RETRACTION A RED CAS MESSAGE NOSE GEAR OPEN GEAR DISAGREE DISPLAYED. WE COMPLETED THE REQUIRED CHECKLISTS AND RETURNED TO A NORMAL LANDING AND TAXI TO PARKING CORRECTIVE ACTION: REMOVED NLG UPLOCK ACTUATOR. TECH AP363666SDR DXTA2026010806442Iru · faultyAPPROXIMATELY 30 MIN AFTER DEPARTURE AND PRIOR TO OCEANIC ENTRY, IRS-FMS DISAGREE AND IRS DIVERTED MESSAGES DISPLAYED IN SCRATCHPAD OF FMS. COMPANY ADVISED NOT TO CONTINUE IF MESSAGES DID NOT CLEAR. MESSAGES CLEARED INITIALLY BUT THEN DISPLAYED AGAIN. CORRECTISDR AALA202601080199Terminal · pulledAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED AISLE EMERGENCY LIGHT DOES NOT ILLUMINATE AT SEAT 8C. MAINTENANCE FOUND SEAT 8C EMERGENCY EXIT LIGHT TERMINAL PULLED FROM CONNECTOR 7261VC3, RETERMINATED CONTACT PER ESPM 20-53-55 AND ACCOMPLISHED A SATISFACTORY OPERATIOSDR DXTA2026010806434Power Supply · faultyWHEN SETTING UP AIRCRAFT THE EMERG LIGHT ON MESSAGE DOESNT INITIALLY COME ON BUT AFTER A FEW MINUTES OF CHARGING THE LIGHT DOES COME ON COMPLETEING THE TEST. IT APPEARS THAT ONE OF THE POWER PACKS MAYBE LOSING THE CHARGE IF IT IS OFF FOR AN EXTENDED. PERIODSDR AALA202601083492Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE AT BS 380 PLUS 6.5 INCHES, AT LBL 13. REPLACED INTERCOSTAL ANGLE PER AARD 51-00-05-1.SDR AALA202601088463Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE AT BS 400 MINUS 6 INCHES, AT RBL 9.5. REPLACED INTERCOSTAL ANGLE PER AARD 51-00-05-1.SDR MASA2026010400105Battery · no testAFT FA FLASHLIGHT NOT BLINKING. REMOVED AND REPLACED BATTERY. OPS CHECKED GOOD.SDR SWAA2026010758008Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK AT ROW 17 ABC AND ROW 11 DEF IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026010758066Battery Pack · inoperativeAFT LT EMERGENCY EXIT LIGHTS INOPERATIVE. R & R AFT LT EMERGENCY EXIT POWER SUPPLY CHARGER ASSY AND BATTERY PACK IAW AMM 33-51-06.SDR SWAA2026010759156Power Supply · inoperativeAFT LT EMERGENCY EXIT LIGHTS INOPERATIVE. R & R AFT LT EMERGENCY EXIT POWER SUPPLY CHARGER ASSY AND BATTERY PACK IAW AMM 33-51-06.SDR SWAA2026010758020Battery Pack · inoperativeOWE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK REF AMM 33-51-06-960-806 AND OPS CHECK GOOD REF AMM 33-51-00-710-801.SDR ASAA2026010463545Light · malfunctionedFA REPORTS LIGHT FLASHING EXIT ROW 16ABC. GROUNDED - YES. (RESOLVED ON W/O: 2084861 TASKCARD: N/R-00001 ) REMOVED AND REPLACED OVERWING LIGHT ASSY IAW AMM 33-21-00-960-805, LOADED SOFTWARE IAW AMM 23-42-03-470-801.PERFORMED EMERGENCY LIGHT OPERATIONAL CHECK IASDR DALA2026010700132Warning Message · illuminatedFCTL- MISSED APPROACH WITH GO AROUND INTO MAD DUE TO LE DISAGREE EICAS MESSAGE. CREW C/W QRH AND LANDED WITHOUT INCIDENT. TS PER FIM AND OPS CK SYS. A/C RTS.(7573844)SDR AALA202601074945Stop Pad · wornAIRCRAFT IN BASE MAINTENANCE: WORN STOP ON AFT SIDE OF FORWARD DOOR LEFT HAND EMERGENCY EXIT OVERWING DOOR. INSTALLED DOORSTOP BEARING PLATE ON LEFT HAND FORWARD DOOR AFT SIDE OVERWING EXIT DOOR. PER AMM 52-22-01.SDR DXTA2026010706430Brake · faultyRIGHT BRAKE WAS GRABBING ON TAXI OUT. BRAKE GRABBED AT DIFFRENT TAXI SPEEDS AND WHEN TURNING TO THE RIGHT AND LEFT. AND GRABBING SOUND CAN BE HEARD. CORRECTIVE ACTION: TAXIED AIRCRAFT ON RAMP, TAXI WAY AND AT MODERATE SPEED ON THE RUNWAY FOR 10 MINUTES. LEFT ASDR DXTA2026010706436Proximity Switch · faultyFLT CREW REPORTED DOOR OPEN CAS, LINXUS SHOWS CABIN DOOR OPEN FAULT ID 2230 AND CHECK DOOR FAULT ID 2265. DOWNLOADED AND REVIEWED ARES DATA TO CONFIRM THE DOOR IN-FRAME AFT PROX SWITCH / SC002 WAS INDICATING DOOR OPEN IN FLT. THE WIRING TO THE PCB HAS CONTSDR DXTA2026010706438Unknown · odorAT 31000' WE NOTICED A FURLING HAZE IN THE CABIN. IT DID NOT SMELL SMOKY BUT RESEMBLED A PROFESSIONAL STERILE SMELL. CALLED FODM AND THE HAZE DISSIPATED. HE CONTACTED MX MGR AND WAS DIRECTED TO DIVERT TO KFLL AS THEY FELT THE DUCTS NEEDED MORE PURGING FROM THSDR DXTA2026010706440Battery · faultyEMERGENCY LIGHTS TURNED ON IN FLIGHT, PULSING ON AND OFF IN RANDOM INTERVALS. UPON LANDING, LIGHTS STAYED ON, BUT WOULD NOT TURN OFF IN THE ARM POSITIONSDR CALA2026010712746Channel · corrodedFWD CARGO LEFT ZEE CHANNEL WAS CORRODED, BS 500A - 500I. R & R FWD CARGO LEFT ZEE CHANNEL IAW SRM 51-40-02-0G-0, AND DWG 143A7500.SDR CALA2026010712745Frame · dentedBULK CARGO, BS 1480, LOWER SIDEWALL, S26 - 27L, FRAME HAD A DENT. ACCOMPLSHED REPAIR IAW EA 757-5360-13-A4239, FIGURE 1 - 7, WITH NO DEVIATIONS IAW EC/RA 5360-02081 ACCOMPLISHED MAJOR REPAIR AND C/W ALL RII STEPS IAW GMM 09-25-05.SDR CALA2026010612722Acm · seizedSHORT FINAL SMELLED SMOK E. AFTER LANDING ECAMS AIR PACK 1 OVERHEAT AND SMOKE DET FAULT. CREW DEBRIEF AND SMOKE. PER CP SMELL WAS DETECTED IN FLIGHT DECK WHICH THEY TOUGHT WAS SOMETHING BURNING IN AN OVEN. LT PACK SHUT DOWN AND FAULT APPEATED. NO SMELL DETESDR 2026FA0000005Wire Harness · chafedANTI-SKID FAILURE ON TAXISDR SWAA2026010658246Battery · inoperativeFWD GALLEY EMERGENCY FLASHLIGHT NOT CHARGING. R & R THE FLASHLIGHT BATTERY IAW AMM 25-64-00-200-801-MAX-01. FLASHLIGHT CHECKED WITH FLASHING OR PUSH TO TEST - LED INDICATOR.SDR SWAA2026010658113Flashlight · out of positionFWD INBD FLASHLIGHT WILL NOT TEST. POSITIONED FWD INBD FLASHLIGHT IN CRADLE IAW AMM 25-64-00, OPS CHECK GOOD.SDR SWAA2026010658127Flashlight · inoperativeAFT CABIN FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT ASSY IAW AMM SIPSDR SWAA2026010658245Flashlight · inoperativeFA REPORTS AFTER GALLEY FIRST OFFICER SIDE FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT IAW AMM 25-64-00SDR SWAA2026010658120Flashlight · inoperativeCREW REPORT FWD FA FLASHLIGHT INOPERATIVE. REPLACED FWD FA FLASHLIGHT BATTERY IAW AMM 25-64-00SDR SWAA2026010658252Slide · unpackedESCAPE SLIDE FWD SERVICE DOOR NEEDS REPACKING. PERFORMED INSPECTION OF FWD GALLEY SERVICE DOOR ESCAPE SLIDE PER AMM 25-66-01. FOUND NO DEFECTS. OK FOR SERVICE.