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 SWAA2026020362164Access Panel · delaminatedDELAMINATED ACCESS PANEL 431DR ON THE LT PYLON. REPAIRED THE ACCESS PANEL IAW SRM 51-70-04-2R-10, REPAIR 10.SDR ASAA2026011664081Support · corrodedFWD CARGO AFT BULKHEAD LOWER SUPPORT AT BS 500D WAS CORRODED. GROUNDED - YES. UPON FURTHER EVALUATION FOUND TO HAVE 100% MATERIAL LOSS. R & R THE SUPPORT IAW SRM 51-40-02-OG-OW: 1.25 O: .073 R: 0.00 L: 2.75 D: .073.SDR CALA2026020313533Skin · crackedRIGHT HORIZONTAL STAB LOWER SKIN. HSS 138.70, TWO CRACK SIGNALS NOTED, CRACK NR 1 L= 1.075" TO 9.500 INCH FWD FROM AFT SPAR, CRACK NR 2 L=1.122" TO 17.300 INCH FWD FROM AFT SPAR. (REF. NR 3502714-2000-0060) PERFORMED PERMANENT REPAIR AT RT HORIZONTAL STAB LSDR AALA202602029860Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM TEE AT BS 947, LBL 51. REPAIRED UPPER TEE IAW SRM 53-70-51-2R-5 AND EA 371524.SDR R61A2026020200017Skin · crackedHEAVY CHECK - CRACK ON RH WING LEADING EDGE AT SLAT TRACK #4. PERFORMED CUTOUT AND INSTALLED DOUBLER REPAIR PER ETD 2026-170-000933 REV ASDR AALA202601300716Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PRINCIPLE 7.SDR AALA202601301156Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23L. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 REPAIR PRINCIPLE 7.SDR AALA202601302791Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM-SEAT TRACK AT FR 21 AND -Y1292. REPLACED BEAM-SEAT TRACK PER SRM 51-72-11.SDR AALA202601277815Clamp · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, S26L FORWARD SIDE. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA202601276072Clamp · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, S26L AFT SIDE. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR DALA2026012200494Battery Pack · inoperativeNUMEROUSE EMERGENCY CEILING LIGHTS INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK B5-231 AND OPS CHECKED GOOD IAW BN717 AMM 33-21. (8406044)SDR DALA2026012200492Skin · crackedCRACK INTERNAL SKIN ON TOP FWD EDGE AT FWD ENTRY DOOR. INTERNAL SKIN ON TOP FWD EDGE AT FWD ENTRY DOOR WAS REPAIRED PER B717-200 S.R.M. 52-10-02 (1404734)SDR DALA2026012200491Dampener · failedTEST OR PASSENGER DOOR DAMPENER CYLINDER 831 DID NOT PASS. REMOVED DOOR DAMPENER IN UNSERVICEABLE CONDITION ON PASSENGER DOOR 831 IAW AMM 52-11- 14-000-001-B, STEP 3.B, D & STEP 4. (LP: 1405368)SDR DALA2026012200490Selector Valve · faultedBRAKES, AUTO BRAKE FAULT A SECOND TIME. LOST NORMAL BRAKING. HAD TO USE ACT BRAKING. DURING BRAKING THE ACFT JOLTED FWD. LOST BRAKES FOR 1-2 SECS, GRABBING AGAIN. DID NOT PULL TO EITHER SIDE. TROUBLESHOT IAW TSM 32-42-00-810-849-A. WHEN ACFT ARRIVED AT GATESDR DALA2026012200481Window Frame · crackedDURING M2 & WHILE ACCOMPLISHING EM 5311-01226-01, CRACKS WERE FOUND IN LT & RT FRONT WINDSHIELD FRAMES, LWR CTR NODE AREA. PER SECTION DTE OF 630808-14 THE REPAIR OF SECTION I IS LIMITED TO 30,600 FC FROM SECTION I.SDR QXEA2026012100012Warning Message · false activationON ADDING T/O POWER EICAS MESSAGE FUEL FEED 2 FAULT ILLUMINATED. ABORTED TAKEOFF. PERFORMED AOM RESET AOM 3.8.25 PER MX CNTL 1083261 MESSAGE CLEARED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR AALA202601214561Door · lack of lubeAIRCRAFT WAS NOT GROUNDED, FORWARD LAVATORY DOOR STICKS, DIFFICULT TO OPEN. LUBED HINGE SCREWED IN SEVERAL LOOSE SCREWS DOOR. OPS CHECK NORMAL. IAW AMM 52-00-00.SDR DALA2026012100450Skin · delaminatedVERTICAL STABILIZER RT SKIN PANEL AT VSS 245- VSS 270, BETWEEN AUX SPAR & FRONT SPAR FOUND DELEMINATED. DAMAGED AREA REPAIRED IAW ER/A 631646-14. (1404064)SDR DALA2026012000435Panel · damagedPIECE MISSING ON LOWER LT STAB INBD WHERE STAB MATCH ELEVATOR. INSTALLED MISSING PANEL ON LWR LT HORIZONTAL STAB IAW IPC 27-41-11-08. (LP 8069261)SDR ASAA2026011663794Unknown · odorSTINKY SOCK ODOR IN FLIGHT DECK - ODOR IS STRONGER ON THE GROUND. GROUNDED - YES. ON DEFERRAL.SDR SWAA2026012062157Seat Back · loosePASSENGER SEAT ROWS 11 DEF, SEAT BACK LOOSE. TIGHTENED THE SEAT BACK IAW CMM 25-21-45, REV 6, STEP 3.Y.(6).SDR SWAA2026012062162Seat Back · loosePASSENGER SEAT ROWS 11 BC, SEAT BACK LOOSE. TIGHTENED THE SEAT BACKS IAW CMM 25-21-45, REV.6, STEP 3.Y.SDR SWAA2026012062159Cover · out of adjustPAX CABIN AFT RT DOOR SLIDE LOWER COVER RUBBING AGAINST WITH THE DOOR SCUFF PLATE AT CLOSE POSITION. INSTALLED CORRECTLY PAX CABIN AFT RT DOOR SLIDE LOWER COVER IAW AMM-25-66-01-000-802, AND MT 725-61-06.SDR SWAA2026012062150Assist Handle · loosePAX CABIN FWD ENTRY DOOR ASSIST HANDLE LOOSE. TIGHTENED PAX CABIN FWD ENTRY DOOR ASSISTANT HANDLE IAW AMM 52-11-31-400-802, STEP 3 G(2).SDR DALA2026012000426Receptacle · faultedAUDIBLE POP AND SPARKS WHEN GROUND POWER CONNECTED. BURNING ODOR SMELLED IN FLIGHT DECK. GROUND POWER PROMPTLY REMOVED. PERFORMED ELECTRICAL CHECK OF K114. PHASES A AND B BOTH SHORTED FROM INPUT TO OUTPUT. R & R CONTACTOR K114 IAW AMM 24-41. R & R EXTERNSDR DALA2026012000424Plate · out of adjustL2 DOOR HARD TO CLOSE. FOUND SERRATED PLATE FOR GUIDE ARM LOOSE AND HAD SLID FWD. ADJUSTED SERRATED PLATE AND SECURED. IAW AMM 52-11-04-402 -037. L2 DOOR OPENS AND CLOSES NORMAL. (1404973)SDR IPXA2026012040144Button · stickingDOOR 1L SLIDE ARMED PUSH BUTTON (FUNCTIONAL TEST) STICKS IN DEPRESSED POSITION. ++CLEANED L1 DOOR SLIDE ARMED TEST PUSH BUTTON I/A/W ESPM 20-55-50-02 OPS CK GOOD.SDR IPXA2026012041694Unknown · odorIN DESCENT, BOTH PACKS ON AND ENGINE & WING ANTI ICE ON, AIR FLOW THRU DUCTS WAS VERY LOUD. PACK FLOW INDICATION ON ECAM, BOTH AMBER AND LOW FLOW POSITION. CONDITIONED AIR SMELLED HOT. BOTH TAKEOFF AND LANDING. PERFORMED OPS TEST OF PACKS IAW AMM 21-51-00. NO SDR AALA202601206359Wire Harness · defectiveAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE SEAT ROWS 14 AND 15. REPLACED EMERGENCY LIGHT WIRE HARNESS AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUES NOTED.SDR AALA202601209203Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: AFTER TAKEOFF ENGINE 2 FUEL FILTER CLOG MESSAGE DISPLAYED. MAINTENANCE REPLACED # 2 ENGINE FUEL FILTER AND ACCOMPLISHED A SATISFACTORY LEAK / OPERATION AL CHECK PER TASK CARD 26L40073015.SDR AALA202601204417Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CIDS PANEL SHOWING CAUTION WITH BOTH RED LIGHTS ILLUMINATED. MAINTENANCE DETERMIINED THE CIDS FAULTS WERE DUE TO THE R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE BEING LOW. MAINTENANCE SERVICED THE R2 DOOR DAMPER AND EMERSDR AALA202601203856Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS R2 DOOR ARMING LEVER / HANDLE IS LOOSE. MAINTENANCE RESECURED LOOSE ARMING LEVER / HANDLE ON THE R2 DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-23-47.SDR AALA202601201916Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1R DOOR SHOWING YELLOW CHECK DOOR PRESSURE. MAINTENANCE SERVICED 1R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-00-1A.SDR AALA202601204993Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 4L CHECK DOOR PRESSURE ON FLIGHT ATTENDANTS PANEL. MAINTENANCE SERVICED 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AMM 25-62-44.SDR AALA202601201164Bottle · leakingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED THAT THE 2L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER IS SHOWING LOW PRESSURE. MAINTENANCE REPLACED THE 2L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14.SDR AALA202601207463Bottle · low pressureAIRCRAFT WAS GROUNDED: AFTER FLIGHT ATTENDANTS ARMED THE DOORS FOR DEPARTURE THE FLIGHT ATTENDANTS PANEL IS NOT SHOWING THE 2L DOOR ARMED AND THE MESSAGE CHECK DOOR PRESSURE IS DISPLAYED. MAINTENANCE SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMSDR VNAA2026012011201Windshield · crackedENROUTE TO CVG THE CREW SAW A CRACK IN THE WINDSHIELD AND GOT A WINDSHIELD HEAT CAUTION MESSAGE. REMOVED AND REPLACED RH WINDSHIELD IAW CRJ-900 AMM 56-11-01-000/400-801-A01-PSA. COMPLETED FINIAL TORQUE CHECK, SEALED AND COMPLETED OPS CHECK (OPS CHECK GOOD)SDR HNAA2026012000012Inverter · faultedCABIN EMERGENCY FLOOR STRIPS NOT ILLUMINATING FROM ROWS 3 TO 7. R & R EMERGENCY LIGHT DC/AC INVERTER 3 IRT AMM 3-50-11-000/400-801-A OPS CHECK GOOD OK FOR SERVICESDR HNAA2026012000011Light · abnormalRH OVER WING EMERGENCY LIGHT INOP. R&R EMERGENCY LIGHT ASSY IAW AMM 33-50-07.SDR KY7A202301200138Downlock Switch · dirtyON APPROACH CYCLED GEAR 3 TIMES FOR NOSE GEAR GREEN. CLEANED & LUBRICATED DOWN LOCK SWITCHES, PERFORMED 15 GEAR SWINGS IAW MM 32-00-00 OPS CHECK GOOD C/W RTS CHECKSSDR YEN2026F00000Unknown · odorFLT # 2276 FLL-FLL. "VERY STRONG ODOR AFTER STARTING R/H ENGINE IN BOTH CABIN AND FLIGHT DECK. ODOR HAS THE SMELL OF FISH AND PAINT.; REFERENNCE LOGPAGE 4368957 ITEM#2 FOR ACCOMPLISHED OF FIM TASK J21-22-00-04AAA-A23A-A FUMES OR SMOKE EVENTS. REFERENCE LOGPAGESDR CALA2026012013109Idg · faultedLEFT DRIVE LIGHT ON AT CRUISE, DRIVE MAS DISCONNECTED WITH CHECKLIST, REMOVED AND REPLACED IDG ON ENG NR 1 IAW AMM 24-11-01-424-002.SDR SWI2026F00078Acm · fumesFUMES DURING FLIGHT AFTER SWAPPING BLEEDS FROM APU TO ENGINES. FUMES RESOLVED WHEN LEFT PACK WAS SHUT OFF. (FLIGHT 5117)PERFORMED FIM TASK 21-21-0 PERFORMED OPERATION CHECK OF BOTH LEFT AND RIGHT PACKS PER 21-51-00, ISOLATED BLEED SOURCE AND PERFORMED OPERATSDR SWIA2026011900006Trim Switch · faultedSTAB TRIM RUNAWAY NOSE DOWN JUST AFTER TAKEOFF. PREFORMED QRC, THEN QRH. LANDED FLAPS 20. (FLIGHT 6262) B1-007955 THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 31555299 WITH THE FOLLOWING CORRECTIVE ACTION: REFER TO CP 31556697 FOR CORRECTIVE ACTION OF FIRSSDR SWAA2026011961926Seat · out of adjustPASSENGER CABIN EMERGENCY EXIT ROW SEAT 14B RECLINES. LOCKED OUT 14B SEAT RECLINE IAW CMM 25-21-42SDR SWAA2026011962060Flashlight · out of adjust3 AFT GALLEY FLASHLIGHTS WILL NOT TEST. FOUND 3 AFT GALLEY FLASHLIGHTS SEATED INCORRECTLY. READJUSTED TO PROPER POSITIONING IAW SIP. THE FLASHLIGHT TESTED, OP CHECK GOOD.SDR SWAA2026011962053Bracket · no testFWD GALLEY INBD EMERGENCY FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED FWD GALLEY INBD EMERGENCY FLASHLIGHT BRACKET ASSY IAW AMM 25-64-00. FLASH LIGHT STILL DOES NOT TEST. BATTERY NOT IN STOCK. OK TO CONTINUE PER MEL 25-64-02A SP1B, REMOVED AND REPLACEDSDR SWAA2026011962828Battery · no testFWD GALLEY I/B EMERGENCY FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED FWD GALLEY INBD EMERGENCY FLASHLIGHT BRACKET ASSY IAW AMM 25-64-00. FLASHLIGHT STILL DOES NOT TEST. BATTERY NOT IN STOCK. OK TO CONTINUE PER MEL 25-64-02A SP1B, REMOVED AND REPLACED FSDR SWAA2026011962106Hook · looseL1 DOOR FWD GIRT BAR RETAINING CLAMP LOOSE. ADJUSTED L1 DOOR SLIDE STOWAGE BOX GIRT BAR STOW HOOK IAW AMM 25-66-00.SDR SWAA2026011962015Power Supply · inoperativeDURING PFC, FOUND MID CABIN OVERHEAD EXIT LOCATOR SIGN LIGHT L1070 INOPERATIVE. CHECKED POWER AT L1070 CONNECTOR D15242. NO POWER FOUND. SUSPECT A BAD FUSE INSIDE POWER SUPPLY. R & R M1695 POWER SUPPLY AT ROW 13F IAW AMM 33-51-06. OPS CHECKED GOOD.