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 SWAA2025082604869Strip · corrodedAFT CARGO FLOOR PANEL CAP STRIPS FOR FLOOR PANELS 140AF;140BF;140CF; AND 140DF ALL HAVE AREAS OF LOWER SURFACE CORROSION. (PHOTOS ATTACHED)<[01] OBTAINED AND INSTALLED CAP STRIPS FLOOR PANEL PER AMM 50-10-04;[02] C/W INSPECTION.SDR IPXA202508261209Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 INBOARD IN BULK CARGO COMPARTMENT LEFT AREA. (REPLACE) ATTACHMENT ARE UPLOADED.SDR IPXA202508261758Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 OUTBOARD IN BULK CARGO COMPARTMENT LEFT AREA. (REPLACE) PAPER CHECK OK.SDR IPXA202508261719Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 RBL 80 OUTBOARD IN BULK CARGO COMPARTMENT RIGHT AREA. (REPLACE) PAPER CHECK OK.SDR CALA2025082608136Flange · crackedFRAME 68 AT S22R FLANGE HAS CRACK INDICATION IN RADIUS JUST ABOVE LWR INBD STOP BOLT. INTERIM REPAIR HAS BEEN ACCOMPLISHED IAW PART 1 OF ECRA 5341-01503 WITHOUT DEVIATIONS. REPAIR PART HORIZONTAL FLANGE AND INNER CAP FILLET RADIUS PER PART 2A OF THE LATEST RSDR DALA2025082606331Oxygen Mask · unwanted deployDURING TAKEOFF, OXYGEN MASKED DROPPED DOWN MID CLIMB. PLACED AFT GALLEY O2 MODULE ON MEL 35-21-01D M PROCEDURES C/W PLACARD INSTALLED AC OK FOR SVC. REMOVED AND REPLACED EMERGENCY OXYGEN CONTAINER OVER L1 DOOR PER A320 AMM 35-21. OPERATIONAL TEST GOOD. M PROSDR IPXA2025082300630Plate · corrodedCORRODED PLATE, AFT WING TO BODY LOWER KEELBEAM AFT SECTION. INSTALLED NEW PLATE IAW SRM 51-40-02-0G REV 93, & DWG 145T8610, SHT 9, REV D & 145T8610, SHT 13, REV B.SDR IPXA2025082501844Bumper · missingFOUND CREW ENTRY DOORWAY LINING BUMPER WITH MISSING. INSTALLED THE BUMPER IAW DWG 411T2036, SHEET 1, REV H & PSDL 411T2240, SHEET DL, REV A.SDR DALA2025082506285Anti-Ice Valve · faultedDIV - TO SLC DUE TO ENG 1. ANTI-ICE CLOSED MESSAGE. COULD NOT CONTINUE DUE TO ICING CONDITIONS IN FLIGHT. DEFERRED ENG 1 ANTI-ICE SYSTEM PER MEL. LATER, REPLACED UPPER ANTI-ICE VALVE ON NBR 1 ENGINE. (LP 7493380)SDR CALA2025082508074Strap · corrodedAFT CARGO DOOR CUTOUT CORROSION AT FLOOR SUPPORT STRAP FASTENER HOLES BETWEEN STA 787-827 RBL 19" . REMOVED AND REPLACED AFT CARGO DOOR CUTOUT FLOOR SUPPORT STRAP FROM STA 787 TO 827 RBL 19" PER REF SRM 51-40-02-0G-0 AND DWG 146A8120.SDR DALA2025082206252Not Reported · no discrepancyWORKING REP CK RH MLG DOOR KEEL BEAM . C/W REP CK PER ER/A 621720-14 (9858048)SDR ABXA202508216185Battery · dischargedDURIING FLIGHT, LOW BATTERY CHIRP ON LAV SMOKE DETECTOR. MAINTENANCE REPLACED LAV SMOKE DETECTOR BATTERY IAW AMM SUPP 26-12-00. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR CALA2025082108005Stiffener · crackedPOSSIBLE CRACK ON INBD LWR SIDE OF NR 3 STIFFENER IN LT HORIZONTAL STAB, HSS 129.50. REPAIRED INBD LWR SIDE OF NR 3 STIFFENER IN L/H SIDE HORIZONTAL ST AB, STA 129.50 ALL WORK DONE IAW SRM 55-10-09-2R-4, SRM 51-40-02-0G-0 & PERFORMED NDT NO CRACK SIGNAL NOTEDSDR CALA2025082108004Skin · dentedCOMPLETE RE-SKIN OF AFT CARGO DOOR ASSEMBLY TO CLEAR ALL DENT DMG DEFERRALS. (REF AAR RFD NR 1000045301) ESFR INFORMATION ENTERED REMOVED AND REPLACED AFT CARGO DOOR EXTERNAL SKIN IAW B737-800 S RM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, SRM 51-2 SDR DALA2025082006225Power Supply · inoperativeEXTERIOR EMERGENCY LIGHTS SYSTEMS - OVERWING EMERGENCY LIGHTS LT OVERWING EMERGENCY LIGHT FAULT ON CMS. LT OWED LT REPLACED (2X), EPSU REPLACED (3X). SKYWISE REPORTING FAULT 3351F0006. EPSU 3 INTERNAL FAULT. INTERROGATE OMS, DOCUMENT AND RECORD FINDINGS. PERFOSDR DALA2025082006224Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK RBL 22 FR 74. REMOVED DAMAGED SEAT TRACK FROM PASSENGER CABIN RBL 22 BETWEEN FR 62 TO FR 74 AND REPLACED PER A220 ASRP BD500-A-J51-42-21- 00AAA-078A-A AND BOMBARDIER PL C01342701 REV-G. (LP# 1146804)SDR DALA2025082006223Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK RBL 44 BETWEEN FR20 TO FR22. REMOVED DAMAGED SEAT TRACK ON PASSENGER CABIN AT RBL 44 FROM FR 20 TO FR 30 AND REPLACED PER A220 ASRP BD500-A-J51-42-21-00AAA- 078A-A AND BOMBARDIER PL C02312600 REV-E. (LP# 1146767)SDR AALA202508203891Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: 2L DOOR LEFT OVERWING EXIT CAUTION MESSAGE. (OPEN)SDR CALA2025082007970Skin · wrinkledAFT CARGO DOOR EXTERIOR SKIN REQUIRES RESKIN. REMOVED AND REPLACED AFT CARGO DOOR SKIN PN: 146A6112-2 IAW SRM 52-30-01-2R-3 SRM 51-40-02 AND DWG 146A6112.SDR CALA2025082007957Collar · failed2L RIGHT GIRTH BAR COLAR IS COMING APART. RESECURED GIRT BAR COLLAR COVER, OPS CHECKS ARE GOOD. ACFT GOOD TO CONTINUE.SDR CALA2025082007956Bracket · looseSLIDE COVER BRACKET ON FWD RIGHT DOOR IS LOOSE. INSPECTED FWD RIGHT SLIDE COVER ATTACH POINTS, GIRT BAR CLIPS AND HOUSING SECURITY. NO DEFECTS NOTED OK FOR SERVICE. INSPECTED FWD RIGHT SLIDE COVER ATTACH POINTS, GIRT BAR CLIPS AND HOUSING SECURITY. NO DEFESDR CALA2025082007955Girt Bar · no discrepancyDOOR 1R GIRT BAR HAS ALOT OF SAG. DOOR 1R GIRT BAR HAS NO CHAFFING, OPS CHECK GOOD IAW AMM 25-66-01-200-802SDR CALA2025082007954Girt Bar · out of limitsDOOR 2R SLIDE IS TOUCHING CABIN FLOOR VERFIED WHEN WE TRIED TO CLOSE R2 DOOR THE SLIDE TOUCHING THE DOOR EDGE AND UNABLE TO CLOSE THE DOOR. REMOVED R2 DOOR SLIDE AND RESECURED GIRT MATERIAL. REINSTALLED AND CHECKED FOR CLEARANCE. NO HELP STILL THE DOOR SLIDE SDR CALA2025082007953Gauge · obstructed2L DOOR RAFT/SLIDE MOVE INSTRUCTIONS FALLING AND BEGINING TO BLOCK SLIDE, PRESSURE GAUGE REMOVED SLIDE COVER ON 2L DOOR REF AMM 25-66-01-014-006. INSTRUCTIONS PAPER REMOVED FROM RAFT/SLIDE PRESSURE GUAGE. GUAGE UNOBSTRUCTED AND FUNCTIONS NORMALLY. RE-INSTALLSDR CALA2025082007952Gate · out of adjustAFT ENT DOOR CAUTION MSG IN DESCENT. FAS CONFIRMED DOOR HANDLE LOOSE REPEAT WRITEUP. LEFT AFT DOOR REQUIRES ADJUSTMENT & PROX SENSOR ADJUSTMENT PER FIM FAULT CODE 52 90 04 41 CHECKED FOR PROPER L4 DOOR INDICATION IN FLIGHT DECK, DOOR INDICATES PROPERLY ON OVERSDR CALA2025082007951Slide · no discrepancyMAIN DOOR SLIDE HAS EXCESS MATERIAL EXPOSED. INSPECT DOOR SLIDE FOUND MATERIAL FROM SLIDE WITHIN LIMITS AS PER AMM 25-66-01SDR CALA2025082007950Bottle · no discrepancyDOOR 3L SLIDE PRESSURE HIGH PRESSURE INDICATOR NEEDLE IS IN THE GO BAND (GREEN) REF AMM DMC-B787-A-25-66-01-02B-300C-A.SDR CALA2025082007949Indicator · no discrepancyAFT CARGO DOOR GREEN LATCH INDICATORS ARE NOT VISIBLE. INSPECTED LATCHES FOR ALL GREEN INDICATIONS, ALL ARE GREEN OK TO CONTINUE. ASDR CALA2025082007948Cover · detached20A EMERGENCY EXIT DOOR HANDLE COVER KEEPS FALLING OFF DOOR SECURED EMERGENCY EXIT DOOR DECORATIVE HANDLE COVER AT POSITION 20 A. DOES NOT INTERFER WITH EMERGENCY DOOR HANDLE OPERATION. NO OTHER DEFECTS NOTED.SDR CALA2025082007947Slide · no discrepancyEXCESSIVE AMOUNT OF SLIDE MATERIAL OUTSIDE OF HOUSING AT 1R WITHIN LIMITS, LESS THAN 12 INCHES OUT OF PACK. AMM25-66-01SDR CALA2025082007946Cover · unsecure21ABC DOOR HANDLE COVER CAME OFF SECURED DOOR HANDLE COVER FOR EMERGENCY EXIT DOOR AT 21ABC AS REQ.SDR CALA2025082007945Slide · no discrepancy2L DOOR SHOWS EXCESS SLIDE MATERIAL. DOOR 2 LEFT EXCESS SLIDE MATERIAL WITHINLIMITS REF AMM 25-66-01-400-803.SDR CALA2025082007944Bottle · no discrepancyFWD SLIDE GAUGE ON BORDER OF GREEN/RED NEEDLE IS AT FAR END OF GREEN BAND AND WITHIN LIMITS REF AMM 25-66-01-200-801. OK FOR SERVICE.SDR CALA2025082007943Bottle · low pressureSLIDE PRESSURE 2L AND2R ARE LOW BOTH PRESSURES IN THE TOP OF GREEN BAND OK FOR SERVICE.SDR CALA2025082007942Bottle · low pressureDOOR 2R SLIDE PRESS NOT IN THE GREEN INSPECTED PER AMM 25-66-99-702-001. PRESSURE OK TO CONTINUE.SDR AALA202508195650Door · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS HARD TO OPEN AND CLOSE. RESECURED FORWARD LAVATORY DOOR LATCH HANDLE. PER CMM 25-48-48. OPERATIONAL CHECK GOOD.SDR AALA202508198280Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR FOR L2 DOOR DIFFICULT TO RELEASE. LUBRICATED GIRT BAR AS REQUIRED.SDR SWAA2025081904839Battery · not reportedFORWARD MEGAPHONE REQUIRES BATTERY CHANGE. REMOVED AND REPLACED FORWARD MEGAPHONE BATTERIES IAW AMM 25-64-00.SDR SWAA2025081904840Battery · not reportedAFT MEGAPHONE REQUIRES BATTERY CHANGE. REMOVED AND REPLACED AFT MEGAPHONE BATTERIES PER AMM 25-64-00.SDR AALA202508193277Slide Raft · bulgedAIRCRAFT IN BASE MAINTENANCE. R1 DOOR SLIDE CONTACTING FUSELAGE, REQUIRES SLIDE CHANGE. MAINTENANCE REMOVED AND REPLACED R1 DOOR SLIDE IAW JC 26L00025011 R1. OPS CHECK GOOD.SDR AALA202508192452Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: L1 EPSU BATT FAULT. MAINTENANCE REMOVED AND REPLACED L1 ESPU BATT IAW AMM 33-51-38 OPS CHECK GOOD.SDR AALA202508196201Wire · damagedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT SEAT 27 ABC INOP. MAINTENANCE ACCOMPLISHED WIRING REPAIR SEAT 27ABC EMERGENCY LIGHT REF AWM 33-51-08 OPS.SDR AALA202508197496Bottle · reads lowAIRCRAFT WAS NOT GROUNDED: L2 DOOR BOTTLE LOW PRESSURE. MAINTENANCE SERVICED DOOR BOTTLE IAW AMM 52-10-00.SDR AALA202508192059Terminal · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT ON SEAT 5H IS INOPERATIVE. MAINTENANCE REPAIRED TERMINAL END IAW SWPM 20-30-00.SDR AALA202508190332Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT BATTERY PACK FAIL TEST FWD L (10WL). MAINTENANCE REPLACED EPSU BATTERY, BITE TEST OK.IAW AMM 33-51-38.SDR AALA202508199136Power Supply · no testAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT BATTERY PACK FAIL TEST EMR R (12WL). MAINTENANCE REPLACED EPSU BATTERY, BITE TEST OK.IAW AMM 33-51-38SDR DALA2025081906207Interlock · brokenATB, RETURN TO JFK DUE TO GEAR DISAGREE AND GEAR DOOR MESSAGES AFTER GEAR RETRACT. C/W OW LANDING INSP. FOUND LMLG DOOR MTC ACCESS PANEL INTERLOCK MECHANISM OUT OF ADJ AND LT MAIN LANDING GEAR DOOR SAFETY PIN INSTALLED. REPAIRED AND ADJUSTED INTERLOCK MECHANSDR DALA2025081906204Lens · brokenEMERGENCY SLIDE LIGHT BEHIND LEFT WING APPEARS TO HAVE A BROKEN/ MISSING LENS. R/R THE LEFT EMERGENCY LIGHT LENS PER B767-300 AMM 33-51. OPS CHECK GOOD. OK FOR SERVICE (7865963)SDR DALA2025081906198Slider · faulted1L DOOR ESCAPE SLIDE LIGHT WILL NOT ILLUMINATE WITH GIRFTBAR ENGAGED. ADJUSTED 1L DOOR GIRT BAR SLIDERS REF B757 AMM 25-66. RELUBED DOOR FITTINGS . OPS CHECK GOOD, MEL AND PLACARDS REMOVED.SDR YENA2025081900849Squib · failedFLT #2102, FLL-JFK. APU "DISCHARGE" LIGHT ON ( APU SYSTEM ); ITEM PLACED ON MEL 49-10-01A DUE TO APU DISCHARGE LIGHT BEING ON. VERIFIED BOTTLE WAS NOT DISCHARGED MCC NOTIFIED. MX-4 UPDATED A/C OK FOR CONT SVC.R+R APU FIRE BOTTLE IAW AMM 26-22-41 MX-4 UPDATED P