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 AALA202601200957Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR BOTTOM STRIKER LOCK DOES NOT OPEN WITH THE DOOR HANDLE. IT DOES UNLOCK WITH THE ELECTRICAL SWITCH. MAINTENANCE REPLACED THE FLIGHT DECK DOOR LATCH ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52SDR R61A2026011700008Unknown · vibrationHIGH LOW PRESSURE VIBRATION IN FLIGHT. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. CLEANED AND INSPECTED FORWARD AFT ACCELEROMETERS ON E2.SDR MASA2026011700004Flashlight · inoperativeFA 2 FLASHLIGHT RED LT NOT BLINKING. R&R AFT FLASHLIGHT, OPS CHECK GOODSDR HNAA2026012000010Light · faultedFLIGHT DECK READING LIGHT C/B G8 POPPED WHEN RESET SMOKE SEEN FROM FO'S READING LIGHT FACT 17JAN26 08:42 RIC R AND R'D FO'S FLIGHT DECK READING LIGHT IAW AMM 33-11-03-000-400-801-A PERFORMED OPS CHECK NO VISIBLE SMOKE OR FUMES PRESENT OK FOR SERVICE.SDR YENA2026012000044Unknown · odorFLT # 1877 BOS-SXM. "A/C N979-FLT-1877-BOS-SXM-ODOR EVENT THE PILOT ANNOTATED: MAGIC MARKER ODOR FUME IMMEDIATELY AFTER TAKEOFF ROTATION. LEVEL 2 X BLEED SHUT AND PACK 1 OFF ODOR DISSIPATED. ODOR FUMES NOTICED BY ALL CREW. THE A/C HAD NO PRIOR ODOR EVENT REPORSDR DXTA2026012006584Brake Assy · wornREPEAT WRITE UP, AFTER LANDING AND TAXING IN, RIGHT BRAKE PULSES FULL BRAKE PRESSURE THEN RELEASES ALL PRESSURE. OBVIOUS SMELL OF BRAKE PADS DURING POST FLIGHT. REMOVED RT BRAKE ASSY AND INSTALLED OVERHAULED CONDITION RT BRAKE ASSY IAW AMM 32-45-21. PERFORMEDSDR CALA2026012013110Pressure Switch · faultedLAVS 1L 2L 2R 3LAFT AND 3R WILL NOT FLUSH. REPLACED VACUUM CHECK VALVE IAW AMM 38-32-07. FOUND ALTITUDE SWITCH 38006 BROKEN. REPLACED BOTH ALTITUDE SWITCHES IAW AMM 38-32-07. SIMULATED AIRCRAFT IN AIR MODE, ALL TOILETS OPS NORMALLY.SDR CALA2026012013098Lamp · burned outL2 EMERGENCY SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED L2 EMERGENCY SLIDE LIGHT IAW AMM 33-51-06-962-001-001. OPS CHECKED GOODSDR CALA2026012013096Smoke Detector · false activationSMOKE ALARM WENT OFF IN LAV A. PREFORMED SMOKE DETECTOR CHECK TSM 26-14 TASK 801 NO FAULTS.SDR CALA2026012013094Fuel Cap · missingREFUELING CAP MISSING ON ARRIVALSDR CALA2026011913092Floorbeam · corrodedAFT WET AREA AT BS 986 ,LBL 45 FLOORBEAM HAD CORROSION ON SURFACE AREAS. REMOVED EXFOLIATED EXISTING REPAIR AT AFT WET AREA ON THE FLOOR BEAM UPPER CHORD STA 986.5 LBL 45, FABRICATED AND INSTALLED REPAIR PARTS (-5 ANGLE, -6 ANGLE, -7 STRAP, AND -8 FILLER) ASDR CALA2026011913090Intercostal · corrodedAFT WET AREA INTERCOSTAL AT BS 947.5 - 967, LBL 50 HAD CORROSION ON SURFACE AREAS. REMOVED AND INSTALLED INTERCOSTAL BS 947.5 - 967, LBL-50 IAW SRM 51-40-02-0G-0, STEP 9.B AND DWG 147A5660.SDR CALA2026011913088Support Angle · corrodedFOUND CORROSION FWD CABIN L1 DOOR LOWER SILL SCUFF PLATES SUPPORT ANGLES. REMOVED & INSTALLED A NEW SUPPORT ANGLE AT FWD CABIN L1 DOOR LOWER SILL SCUFF PLATES IAW SRM 51-40-02-0G-0 AND DWG 141A8110.SDR CALA2026011913083Proximity Sensor · faultyMLG DOOR EICAS MESSAGE ON FINAL, BIT PSEU BOX - NO FAULTS (000). DIALED IN CODE 505. STAUS PAGE SHOWS NO MSG'S. IAW FIM 32-09 FAULT TREE 804. DEBREIFED CREW, WHEN CAPT APPLIED FLAPS DOWN GOT GEAR DOOR EICAS MSG. DID A GO AROUND TO CONFIRM GEARS WERE DOWN. SDR CALA2026011913082Wire · exposedFA REPORTS DOOR 2L HAS EXPOSED WIRE FROM SLIDE PACK NO WIRES EXPOSED ON SLIDE PACK DOOR OPERATES NORMALSDR SWIA2026011900007Window Frame · crackedREFERENCE CP 31555100 FOR ORIGINAL DISCREPANCY. CRACK ON LT COCKPIT WINDSHIELD/WINDOW SIDE POST (P/N 601R33223-1) DETERMINED TO BE OUT OF LIMITS AND SIDE POST REQUIRES REPLACEMENT. THIS IS CLASSIFIED AS A MAJOR REPAIR. (FILED OPEN)SDR SWAA2026011962320Battery · inoperativeCABIN MEGAPHONE INOPERATIVE. R & R MEGAPHONE BATTERIES IAW AMM 25-64-00, ACFT OK FOR SERVICESDR SWAA2026011962354Flashlight · no testONE FLASHLIGHT IN AFT GALLEY NOT TESTING CORRECTLY. COMPLETED OPS CHECK ON AFT GALLEY FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026011962439Cover · brokenOVERWING EMERGENCY SIGN COVER BROKEN RIGHT. R & R OVERWING EMERGENCY SIGN COVER BROKEN IAW AMM 33-51-01.SDR ABXA202601197018Escape Reel · defectiveDURING SERVICE CHECK FOUND 4 DESCENT DEVICES IN THE FLIGHT DECK NOT STOWED/PARTIALLY EXTENDED.MTX REMOVED AND REPLACED DEVICE DESCENT #2, #3,#4 AND #5 IAW AMM SUPPLEMENTAL 25-61-03. A/C OK FOR SERVICE.SDR FDEA202601170065Trunnion · fodAFTER LAND IN TUCSON, MAKING A HARD LEFT TURN WITH TILLER, ACFT WOULD NOT TURN. TILLER JAMMED AT 3 INDICES LT OR RT OF CENTER. AMM 32-51-00-5. COMPLIED WITH AMM 32-51-00-5, STEP 3. F. PREPARE FOR TEST OF NLG STEERING SYSTEM, G. TEST OF NLG STEERING SYS H.SDR DXTA2026011906579Pin · faultedMAIN CABIN DOOR LOCKING PINS WILL NOT EXTEND. PIN ON THE FORWARD SIDE OF THE DOOR, LOWEST PIN WHEN DOOR IS CLOSED, IS RECESSED IN AND WILL NOT MOVE WITH HANDLE. FOUND LOWER FWD LATCH PIN STUCK IN RECESSED POSITION. FREE'D LOWER FWD LATCH PIN AND CLEANED/LUBEDSDR DXTA2026011906578Flap System · faultedWHEN SELECTING FLAPS 2, RECEIVED A FLAP FAIL CAS. FLAPS STOPPED JUST BEYOND THE NR 1 POSITION. RAN QRH, & UNSUCCESSFUL WHEN CYCLING FLAPS. PERFORMED SEVERAL OPS CHKS FOR FLAP SYS USING AMM 27-50-00-710 & SYSTEM NEVER FAIL ON ANY STAGE OF OPS CHECKS. CHECSDR DXTA2026011906574Door · obstructedMAIN DOOR IS GETTING HARD TO CLOSE , HALF WAY ON INTERIOR OR EXTERIOR HANDLE EXTRA FORCE IS REQUIRED TO CLOSE HANDLE. GAINED ACCESS TO ACFT AND MAIN CABIN DOOR. UPON INTITIAL OPENING SAW THAT THE CURTAIN MAY HAVE BEEN RESTRICTING THE MED FROM CLOSING SMOOTHLYSDR CALA2026011913075Pin · backed outROW 14 EMERGENCY LIGHT INOPERATIVE. ALL LIGHTS WITHIN TWO SEAT ROWS OF THE TYPE III, EXIT OVERWING EMERGENCY EXIT MUST BE OPERATIVE. FOUND CONNECTOR PINS BACKED OUT, RESECURED PINS, SEAT EPL AT ROW 14 OPS CHECKED GOOD IAW AMM 33-51-11.SDR CALA2026011913073Battery Pack · inoperativeROW 8 THROUGH ROW 14 EMERGENCY AISLE LIGHTS INOP REPLACED EMERGEMMCY LIGHT POWER SUPPLY M2503 AND BATTERY IAW AMM 33-51-06. OPS CHECK GOOD.SDR CALA2026011913071Lamp · inoperativeEMERGENCY LIGHTS, OPS TEST WITH THE TEST SWITCHES PROCEDURE. EMERGENCY AREA LIGHT L33487 INOP IN FWD MID GALLEY CEILING RELAMPED IAW AMM 33-51-03-960-801 OP CK GOOD.SDR CALA2026011913040Smoke Detector · false activationFWD LAV SMOKE ECAM. RESET ON ITS OWN AFTER 5 SECONDS. FA DID NOT SEE OR ODOR ANY SMOKE. PERFORMED SYSTEM TEST IAW 26-17-00-810-804-A, INFO NOTED.SDR DALA2026011800405Blower · faultedVENT BLOWER FAULT DURING TAXI OUT. NOTICED BURNING SMELL WHEN BLOWER FAN WAS REMOVED. REPLACED VENT BLOWER FAN PER AMM 21-26. (LP 6582080, 1406325)SDR ABXA202601187017Pump · faultedDURING TAXI OUT C HYD DEM PUMP PRESSURE WHEN FLAPS ARE IN TRANSITION , ACFT RETURNED TO GATE (BTB) AND MTX GROUNDED ACFT . DEFERRED ADP MTX TRANSFERRED TO DI# 69856 IAW MEL 29-11-3, MBCB 01/27/26, PULLED AND COLLARED C/B, MX PROCEDURES C/W, PLACARD INSTALLEDSDR ABXA20260117015Circuit Breaker · faultedON PUSHBACK, ALL T/O SPEEDS DUMPED AND UNABLE TO SET ANY T/O PWR SETTING ON TMC OR SET A TEMPERATURE A/C RETURNED TO THE GATE AND MTX GROUNDED A/C .MTX RESET CIRCUIT BREAKER IAW B767 AMM 20-60-01. OPS CHECK GOOD. NO FAULT NOTED AT THIS TIME. ACFT REMAINS CASDR 2026FA0000030Fairing · damagedRH INBOARD FLAP FAIRING IMPACT DAMAGESDR 2026FA0000029Mesh · deterioratedLEFT ENGINE INLET MESH DETERIORATIONSDR 2026FA0000028Mesh · deterioratedRIGHT ENGINE INLET MESH DETERIORATIONSDR 2026FA0000027Mesh · deterioratedRIGHT ENGINE INLET MESH DETERIORATION.SDR JR2R20260117017Cam · chafedFWD CARGO DOOR VENT FLAP BOTH FWD AND AFT CAMS CHAFED. REPAIRED PER ETD.SDR JR2R20260117022Cam · chafedAFT CARGO DOOR VENT FLAP BOTH FWD AND AFT CAMS CHAFED. REPAIRED PER ETD.SDR EE4Y2026170123780Attach Fitting · corrodedDURING THE ACCOMPLISHMENT OF THE ALLEGIANT TASK CARD #A32X-05-000-002 ALLEGIANT CUSTOMIZED TASK CARD, THE AFT CARGO DOOR UPPER BEAM FWD ACTUATOR – FWD LUG ATTACH FLANGE WAS FOUND CORRODED. PERFORMED REPAIR ON THE UPPER BEAM FWD AFT CARGO DOOR ACTUATOR- FWD LUSDR AALA202601179384Door System · reads lowAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND AFT RH EMERGENCY DOOR DAMPER SHOWING ARUND700 PSI AT 35 DEGREES F. MAINTENANCE RECHARGED THE CYLINDER BOTTLE PER AMM 52-10-00.SDR VNAA20260511024Skin · damagedPANEL 584FB HAS DAMAGED SCREW HOLE FROM WHAT APPEARS TO BE SOMEONE DRILLING OUT A SCREW. REPAIRED LH I/B FLAP FWD SPAR LOWER FLANGE IAW MHIRJ REO 670-57-52-642 REV-- DATED 2026-01-16.SDR SWIA2026011675709Skin · corrodedFUSELAGE EXTERNAL SKIN AT AFT LAV SERVICING POINT IS CORRODED BETWEEN FS559+80 AND FS559+112 BETWEEN STGR20R AND STGR24R. REPAIRED EXTERNAL SKIN AT AFT LAV SERVICING POINT BETWEEN FS559+80 AND FS559+112 BETWEEN STGR20R AND STGR24R IAW MHIRJ REO 601R-53-51-729SDR SWIA2026041775706Doubler · corrodedFUSELAGE EXTERNAL SKIN DOUBLER AT THE LAV SERVICING POINT IS CORRODED. REPAIRED EXTERNAL SKIN DOUBLER AT LAV SERVICING POINT IAW REO 601R-53-51-729 REV--. COMPLETED TASK CARD 51-900-1003-SKY.SDR SWIA2026030975457Stringer Splice · corrodedCORROSION ON SPLICE STGR 25R BETWEEN FS333.00 - FS349.00 (C-CHECK RO 03/07/2026)REMOVED AND REPLACED BY NEW SPLICE (STGR JOINT) FOR STGR25R BETWEEN FS333.00-FS349.00 REF CRJ 550 SRM 51-42-06-001-001-A01 AND DWG SH670-32420 REV E. COMPLED WITH 51-900-1002-SDR AALA202603068377Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR IPXA2026021042167Rib · crackedMAJOR REPAIR, RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, TWO CRACK INDICATIONS NOTED AT RIB 19. ACCOMPLISH PERMANENT REPAIR IAW EO-96389-REQ1 AND VT-MAE EA 300-5753-27-A4304, REV. -.SDR IPXA2026021042834Rib · crackedMAJOR REPAIR, RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, ONE CRACK INDICATION NOTED AT RIB 18. ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-96389-REQ1 AND VT-MAE EA 300-5753-27-A4304, REV. -.SDR IPXA2026021042071Rib · crackedMAJOR REPAIR, RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, THREE CRACK INDICATIONS NOTED AT RIB 26. REQUIRES FINAL REPAIR STATEMENT AND INSP.SDR IPXA2026021042836Rib · crackedMAJOR REPAIR, RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 17. ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-96389-REQ1 AND VT-MAE EA 300-5753-27-A4304, REV. -.SDR IPXA2026021042144Rib · crackedMAJOR REPAIR, RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACK INDICATION NOTED AT RIB 25. ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-96389-REQ1 AND VT-MAE EA 300-5753-27-A4304, REV-.SDR IPXA2026021041989Rib · crackedMAJOR REPAIR, LEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE, ONE CRACK INDICATION NOTED AT RIB 27. OUT OF SEQUENCE, VERIFIED FROM STEP 17. FABRICATED REPAIR DOUBLER IAW SRM 57-50-00, PARA 4.E, FIG. 205.