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 AALA202507287526Door · bindingAIRCRAFT WAS GROUNDED: FORWARD LAVATORY ENTRY DOOR HARD TO OPEN IT AND CLOSE IT. REPLACED FORWARD LAVATORY DOOR HINGE. PER CMM 25-40-61. OPERATIONAL CHECK GOOD.SDR AALA202507289547Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 16F OVERWING EXIT EMERGENCY LED LIGHT INOPERATIVE AT ROW 16F. REMOVE AND REPLACED LIGHT ASSEMBLY. PER AMM 33-12-00. OPERATIONAL CHECK GOOD.SDR AALA202507287071Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN FLASHLIGHT INOPERATIVE. REPLACED BATTERIES FOR EMERGENCY FLASHLIGHT. OPERATIONAL CHECK GOOD.SDR AALA202507288577Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT AT L2 DOOR IS INOPERATIVE. RELAMPED L2 DOOR EXTERIOR EMERGEMCY LIGHT. OPERATIONAL CHECK GOOD. PER AMM 33-51-04.SDR AALA202507280997Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS R2 EMERGENCY EXIT DOOR ARM HANDLE IS LOOSE. MAINTENANCE TIGHTENED SLIDE ARMING HANDLE PER AMM 52-22-21.SDR AALA202507288132Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT ROW 13 NOT WORKING. MAINTENANCE FOUND PIN B AT CONNECTOR 7261VC3 HAD A BROKEN WIRE. REPINNED WIRE PER SWPM28-49-21 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202507284911Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT ROW 12 NOT WORKING. MAINTENANCE FOUND PIN B AT CONNECTOR 7261VC3 HAD A BROKEN WIRE. REPINNED WIRE PER SWPM28-49-21 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202507284954Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT ROW 11 NOT WORKING. MAINTENANCE FOUND PIN B AT CONNECTOR 7261VC3 HAD A BROKEN WIRE. REPINNED WIRE PER SWPM28-49-21 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR GTIA2025072839021Unknown · odorFA'S REPORT THE SMELL OF BURNT RUBBER IN ROWS 4 + 5 ON DESCENT-INFO: FOUND NO DAMAGE OR SMELL.IAW AMM 05-20-00.NO FURTHER MAINTENANCE REQUIRED.A/C OK FOR CONT SVC.SDR WX0A2025072832519Printer · smoke(AIRCRAFT NOT GROUNDED) ELECTRICAL BURNING SMELL IN DESCENT. NOTICED SMOKE EMANATING FROM PRINTER. OPENED PRINTER TO FIND SOURCE. NO FLAME DETECTED. DONNED 02 MAKS. NO EMERGENCY DECLARED DUE TO NO INCREASE INTENSTIY. / REMOVED AND REPLACED PRINTER IAW AMM 31-3SDR WX0A2025072832517Megaphone · no discrepancy(AIRCRAFT NOT GROUNDED) FWD MEGAPHONE INOP DOESNT CHIRP DURING TEST / PERFORMED OPERATIONAL CHECK OF MICROPHONE PER AMM 25-65-51-710-002-A. OPS CHECK GOOD. A/C OK FOR SERVICE."SDR WX0A2025072832514Battery · inoperative(AIRCRAFT NOT GROUNDED) FWD FLIGHT ATTENDENT FLASHLIGHT IN INOP / REPLACED BATTERY ON FLASHLIGHT AND PERFORMED OPS CHECK. NO DEFECTS WERE FOUND REF CMM 25-60-02"SDR YENA2025072800777Condenser · faultedFLT#1058, AUA-JFK. STRONG CHEMICAL ODOR EXPERIENCED BY INFLIGHT CREW UPON ARRIVAL AND INTENSIFIED AFTER LANDING. ( PACKS ); REF LOG PAGE # 4318901 ITEM # 2 (REMOVED AND REPLACED PACK # 1 CONDENSER IAW AMM 21-52-32 REF L/P 4318902 ITEM # 1 FOR OPS CHK/LEAK CHK)SDR DALA2025072805671Filter · odorSHIP 3128 PUNGENT MELTED CRAYON SMELL ASSUMED (WITH APU BLEED. APU HAD 3+ MIN WARMUP BEFORE BLEED APPLICATION). CORRECTIVE ACTION: HANGED BOTH OZONE FILTERS & RECIRCULATION FILTERS. WORKED J/C 2100-2005. COMPLETED J/C 4900-2001. (7281788).SDR DALA2025072805670Skin · damagedSHIP 3119 FWD FUSELAGE DAMAGE FR 1-4. CORRECTIVE ACTION: COMPLIED WITH ER/A 628044-14. (1108228).SDR DALA2025072805654Support · mechanic errorSHIP 3415 F62 3R SUPPORT HAS MISDRILLED HOLES. CORRECTIVE ACTION: REPAIRED PER ERA 628013-14 REV ORIG. (1108210)SDR DALA2025072805653Frame · mechanic errorSHIP 3416 MISSED DRILLED HOLE ON BACKSIDE OF FRAME 61 BETWEEN STRINGERS 1L AND 2L. CORRECTIVE ACTION: REPAIRED PER ERA 627491-14 REV ORIG. (1109827)SDR YENA2025072800770Unknown · odorFLT#287, BOS-LAX. STRONG ODOR IN COCKPIT DURING APPROACH. POWER IDLE AT 2500' & CAME THROUGH A LAYER OF CLOUDS. MASK IN COCKPIT USED. BLEEDS, PACKS TURNED OFF RIGHT AWAY; PERFORMED T/S PER TSM 24-00-00-810-823. NO ELECTRICAL BURNING SMELL OR FUMES FOUND IN CASDR DALA2025072805619O-Ring · leakingAIRCRAFT 5005, ODOR IN CABIN & COCKPIT MORE PREVALENT AFTER APU BLEED FLIGHT ATTENDANT DESCRIBED AS " METALLIC". CORRECTIVE ACTION: FOUND LEAK COMING FROM INPUT LINE OFF OF OIL COOLER. REPLACED O-RING SEALS PER A321 AMM 49-91. PERFORMED LEVEL B REMOVAL OF ECS SDR DALA2025072805618Tail Cone · ground damageAIRCRAFT 3060, WHILE BEING TOWED TO THE GATE IN PNS, THE SUBJECT A321 TAIL CONE (P/N D0007000510000) WAS DAMAGED WHEN THE LH ELEVATOR ON AIRCRAFT 3060 CONTACTED AN ADJACENT BUILDING. THE TAIL CONE SKIN WAS DENTED, DAMAGING THE UNDERLYING STRUCTURE IN THE AREA SDR DALA2025072805617Lens · damagedSHIP 5642 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:603 - ADDITIONAL LOCATIONS 604 - ONE EXIT SIGN IS TAPED AND THE OTHER FELL OFF, RHE SIGN IS ALSO BROKEN.SDR DALA2025072805616Skin · unknownSHIP 651 REPAIR TO RH WING UPPER SKIN COMMON TO DRAG FITTING ATTACHMENT REQUIRES SUPPLEMENTAL INSPECTIONS PER ERA 627493-14AD. CORRECTIVE ACTION: REF ERA 627493-14AD.SDR DALA2025072805615Drag Fitting · corrodedSHIP 651 A.D // A.A. DAMAGES WERE FOUND ON OPEN HOLES AT RH ENG DRAG FTG CLAMP-UP & DRAG BRACE AS FOLLOW: CORROSION IN DRAG FITTING HOLE #4 ON SKIN AND FITTING (6-8 HRS POSITION). SCRATCHES IN DRAG FITTING HOLE #5 AROUND THE FITTING. IN REF: CARD 5720-01100-04SDR JJBA20250728091Sign · inoperativeEXIT ROW OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SIGN. NO DEFECTS NOTED.SDR REXA2025072800762Stringer · corrodedSTRINGER AT 20R IS CORRODED BETWEEN FS 364.00 AND 409.00. INSTALLED NEW STGR20R PN:SH670-31405-2S BETWEEN FS364 - FS477 IAW CRJ700 SRM 51-42-06-001-001-A01SDR REXA2025072800761Floorbeam · corrodedR/H F.S. 280 BEAM CAP IS CORRODED BETWEEN BL0 TO RBL9. REPAIRED FS 280 CROSSBEAM IAW MHIRJ GREO 670-53-11-579, REV -B, DATED 2013/05/01 AND 51-42-06-001-001-A01, 51-42-21-001-001-A01.SDR AALA202507281834Wire · brokenAIRCRAFT WAS GROUNDED: SEAT-MOUNTED EMERGENCY LIGHTS AT SEAT 24ABC AND 25ABC DO NOT COME ON WHILE DOING EMERGENCY LIGHTS TEST ON PS CHECK. MAINTENANCE FOUND TWO BROKEN WIRES ON SIDEWALL MOUNTED ELECTRICAL CONNECTOR BETWEEN SEATS 24ABC AND 25ABC. CRIMPED CONTACSDR AALA202507285020Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 EMERGENCY EXIT DOOR ILLUMINATED SIGN HAS MULTIPLE BULBS INOP. MAINTENANCE REPLACED MULTIPLE BULBS FOR R1 DOOR EMERGENCY LIGHT EXIT SIGN IAW AMM 33-51-17.SDR AALA202507280796Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 13 OVERHEAD EMERGENCY EXIT ILLUMINATED SIGN HAS MULTIPLE BULBS INOP. MAINTENANCE REPLACED MULTIPLE BULBS FOR OVERHEAD EMERGENCY LIGHT EXIT SIGN AT ROW 13 IAW AMM 33-51-17.SDR UIEA2025072301008Lamp · inoperativeR5 DOOR JAM EMERGENCY EXIT LIGHT INOP. REPLACED R5 DOOR JAM EMERGENCY EXIT LIGHT IAW AMM 33-51-05-962-031. TEST GOOD.SDR UIEA2025072401014Lamp · inoperativeL2 DOOR EMERGENCY EXIT SIGN HAS MULTIPLE INOPS LIGHTS. REPLACED MULTIPLE LAMPS FOR THE L2 DOOR EXIT SIGN IAW B747-400 AMM 33-51-12-962-170. TEST GOOD.SDR UIEA2025072401015Lamp · inoperativeL1 DOOR EMERGENCY EXIT SIGN HAS MULTIPLE INOP LIGHTS. REPLACED MULTIPLE LAMPS FOR L1 DOOR EMERGENCY EXIT SIGN IAW B747-400 AMM 33-51-12-962-170. TEST GOOD.SDR UIEA2025072401016Lamp · inoperativeR1 DOOR EMERGENCY EXIT SIGN HAS MULTIPLE INOP LIGHTS. REPLACED MULTIPLE R1 DOOR EMERGENCY EXIT SIGN LAMPS IAW B747-400 AMM 33-51-12-962-170. TEST GOOD.SDR CALA2025072806984Power Supply · no testPROCEDURE - TEST FAILED WITH MSG "EPSU COMM FWD L" SEE PIC ABOVE SHOULD READ EMERGENCY LIGHTING TEST PROCEDURE- PERFORMED TSM 33-51-00, FOUND EPSU COMM FWD LEFT FAULT. TESTED EPSU 10WL REF STEP 4B-1A NO EPSU LED'S CAME ON. REPLACED EPSU 10WL REF AMM 33-51-38.SDR CALA2025072806983Light · brokenEMERGENCY PROX LIGHT LAV T MOST AFT CRACKED. REMOVED AND REPLACED PROX LIGHT LAV T REF AMM 33-51-14 OPS CHECK GOOD AT THIS TIME.SDR CALA2025072806982Flashlight · inoperativeFLASHLIGHT (PASSENGER CABIN) INOPERATIVE 4R REQUEST TO DEFER FLASHLIGHT AT DOOR 4R AS PER MEL 2564B OK TO PLACE ON MEL. FLASHLIGHT IS INOP AND FLASHES RED. MEL COMPLIED WITH RAISED SDR FOR FLASHLIGHT BEING INOP AT DOOR 4R. R/R FLASHLIGHT ASSEMBLY AT 4R. OPSSDR CALA2025072806981Power Supply · faultedEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. RH AFT EMERGENCY LIGHTS WILL NOT STAY ON DURING TEST. REMOVED AND REPLACED RH (DR-R2) AFT EMERGENCY LIGHT POWER SUPPLY PER AMM 33-51-06. OPS TEST NORMAL. OKAY FOR SERVICE.SDR CALA2025072806949Wire Harness · faultedSEAT 2B AFT WHITE EMERGENCY PATH LIGHT INOP. REQ NEW HARNESS ASSY, P/N BR9624-80, M&E 29-3350-3-0026. R & R SEATS 2A & 2B EMERGENCY PATHWAY LIGHTS HARNESS ASSY. EMERGENCY LIGHTS OPS CHK OK IAW AMM 33-51-11. PARTS USED: 29-3350-3-0026,QTY :1SDR CALA2025072806943Unknown · odorSUSPECTED BURNING RUBBE RY SMELL IN COCKPIT WHEN PACK 1 ON PACK TEMP 165 PACK 1 OFF SMELL LESS PILOT REPORTED PACK TEMP ON #1 165 PACK #2 115 RAN PACK ON BOTH ENG BLEED AIR AND APU BLEED FOUND TO BE OPERATING NORMAL PACK 1 WAS 165 PACK # 2 155 NO BURNING SMELLSDR CALA2025072806942Oven · odorPERFORM CABIN CONDITIONAL CABIN INSPECTION DUE PLASTIC SMELL MID GALLEY OVEN AS PER AMM TASK 05-51-58-910-801-C1, PERFORMED CONDITIONAL CABIN INSPECTION AND DETERMINED THE PLASTIC SMELL CAME FROM MID GALLEY OVEN. OVEN CB HAS BEEN PULLED AND COLLARED. OVEN PLACSDR DXTA2025072804377Power Supply · defectiveAFTER ENGINE START, ALL CABIN EMERGENCY SIGNS AND LIGHTS WERE ILLUMINATED WITH THE EMER LIGHT SWITCH IN ARM POSITION. REPLACED DEFECTIVE NR 1 EMERGENCY POWER SUPPLY WITH CUSTOMER SUPPLIED "TESTED" POWER SUPPLY. REPLACED DEFECTIVE NR 2 EMERGENCY POWER SUPPLY WSDR SWIA2025072675146Stop Fitting · crackedRT FWD EMER EXIT DOOR, UPPER STOP ON THE DOOR, POSSIBLE CRACK IN THE DOOR FRAME (MARKED) (C-CHECK RO 02/01/2026)REPAIRED CRACK ON RH FORWARD EMERGENCY DOOR EXIT UPPER DOOR STOP IAW REO 670-52-21-103 REV. -- DATED 2024-11-06. COMPLIED WITH ALL STEPS OF REO 670SDR SWIA2025072675128Stop Fitting · crackedLH AFT EMER EXIT DOOR, UPPER STOP ON THE DOOR, POSSIBLE CRACK IN THE DOOR FRAME (MARKED) (C-CHECK RO 02/01/2026)FLUORESCENT PENETRANT INSPECTED PER REF CRJ900 NDTM 51-20-008-230-A01. NDT FAILED. ENDS OF CRACK MARKED FOR REPAIR. SEE ATTACHED NDT-11REPAIRED CRSDR SWIA2025072675126Stop Fitting · crackedRH AFT EMER EXIT DOOR, UPPER STOP ON THE DOOR, POSSIBLE CRACK IN THE DOOR FRAME (MARKED) (C-CHECK RO 02/01/2026)REPAIRED CRACK ON AFT RH EMERGENCY EXIT DOOR UPPER DOOR STOP IAW REO 670-52-21-103 REV -- 2024-11-06. COMPLIED WITH ALL STEPS OF REO 670-52-21-103SDR SWIA2025110300726Stand Off · crackedL/H UPPER TRANSCOWL OUTBD "A" BRACKET STANDOFF CRACKED. (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED NEW L/H UPPER TRANSCOWL O/B "A" BRACKET (PN CN624-2082-201) REF REO# 670-54-21-971, REV B, DATED 11/28/23.,OPS TEST OF TRANSCOWL LATCHES GOOD.COMPLIED WITH 51SDR JJBA20251024079Web · crackedRH MLG BAY AFT WEB CRACKED AT SPAR III LOWER OB CORNER. REMOVED AND REPLACED RH MLG BAY AFT WEB AT SPAR III LOWER OB CORNERSDR AALA202510218930Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MENBRANE TO CENTER WING BOX AREA, ON FR36, Y1523 LH SIDE, LOWER FUSELAGE. (CRACK L: 0.098 INCH). MAINTENANCE PERFORMED TIME LIMITED REPAIR ON (HOLE L100) PRESSURE DESDR VNAA20251015010Bracket · corrodedCORROSION ON BRACKET LH, NLG AFT DOOR GUIDE AT NLG DOOR WAS FOUND. BRACKET LH, NLG AFT DOOR GUIDE AT NLG DOOR WAS FOUND WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR AALA202509293730Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: DEBONDED IB FLAP EXISTING REPAIR ON LH WING MEASURE OF DISBOND IS L=18.0IN W=12.0IN. MAINTENANCE PERFORMED PERMANENT REPAIR ON IB FLAP TRAILING EDGE LH WING IAW EA NO. 367092.SDR SWIA2025F01383Frame · corrodedCORROSION NOTED ON FRAME FS333.0 BETWEEN STGR 22R-23R AT FWD FACE (C-CHECK RO 09/24/2025)REMOVED CORRODED FRAME SECTION FS333 BETWEEN STGR 23R AND 18R. REF. CRJ200 SRM 51-42-06 AND SRM 51-42-21 AND INSTALLED NEW FRAME SECTION FS333 BETWEEN STGR 23R AND 18R.