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 SCNA20250917377Floor Panel · brokenBROKEN FLOOR PANEL 221QF AT W1, PASSENGER CABIN.SDR SWAA2025091614472Handle · looseCREW REPORTS R2 SERVICE DOOR HANDLE LOOSE. ADJUSTED R2 SERVICE DOOR HANDLE PER AMM 20-50-11; AND 52-13-31. DOOR FEELS BETTER PER FLT CREW AND OPERATED AS NORMAL. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR AALA202509168023Heater · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202509163759Relay · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR R61A2025091200391Tire · damagedLEFT INBD TIRE DAMAGED ON TAKEOFF. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED LT INBD TIRE.SDR 2025FA0000647Vartoms · faultedVARTOMS SYSTEM KICKED INTO MANUAL MODE AS ENGINES COULDN'T HOLD TORQUE MATCHING AT THE SPECIFIC POWER SETTING. SYSTEM WAS TROUBLESHOT AND FOUND TO BE WITHIN ALL PARAMETERS. NO DEFECTS NOTED DURING TEST FLIGHTS.SDR AALA202509167734Light · malfunctionedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHTS AND SEAT BELT SIGN & NO PORTABLE DEVICES SIGNS & ALL LIGHTS INCLUDING EMERGENCY LIGHTS COME ON AND START FLASHING WITH SOME SORT OF HIGH PITCH ALARM WITH NO CREW INPUT. CABIN LIGHTS GO TO FULL BRIGHT & CAN NOT BE CONTROLSDR CALA2025091608970Transmitter · unknownIN FLIGHT HYD QTY SLOWLY DECREASING ABOUT 1 % EVERY 2-3 MINS TO 68 %. CREW STATED ACFT DEPARTED WITH 97 % ON A SYS HYDS & 102 ON B SYS. STATED AT 36,000 FT -A- SYS STARTED DROPPING A % EVERY FEW MINS UNTIL AT 68 %. RETURNED TO ORD. WHEN LANDING GEAR EXTENDEDSDR CALA2025091608968Bleed Valve · faultedABORTED TAKEOFF DUE TO ECAMS NOT APPROPRIATE WITH MEL. ACP'D ON L/P 6256763.ENG1 HP VALVE INDICATES OPEN ON BLEED PAGE. ALLOTHER INDICATIONS NORMAL SECURED THE ENGINE 1 HPV CLOSED AND INSTALLED DF STICKER REF MEL 3611S. DM SUGGEST TSM 36-11-00-810-835-A, R &SDR CALA2025091608967Flag · false activationFO PFD DISPLAYING SPD AND ALT FLAGS TESTED RIGHT ADR SYSTEM REF. TO 34-21-00, TESTED GOOD.SDR CALA2025091608966Valve · faultedRTO 50 KTS PULLING LEFT DURING OPS CHECK OF N/W STEERING FOUND WHEN TURNING FULL LEFT METERING VALVE STICKS THEN RETURNS TO CENTER SLOWLY, CAN ALSO HEAR VALVE BYPASSING INTERNALLY. RECOMMEND METERING VALVE R/R. T/S USING FIM 32-51 TASK 810. REMOVED NLG STEERINSDR CALA2025091608964Actuator · faultedDOOR FLIGHT LOCK 4L EICAS STATUS #4 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. COMPLIED WITH MEL 5211E. THIS ITEM HAS MULTIPLE HISTORY. REPLACED R & R FLIGHT LOCK ACTUAOR, REF AMM 52-11-26. OPS CHECK GOOD.SDR CALA2025091608963None · no discrepancyBIRDSTRIKE ON T/O LEFT WINDSCREEN HOT BRAKES FROM RTO 440 DEGREES. ACP BIRDSTRIKE PER AMM 05-51-14-200-803. ACP'D BIRDSTRIKE INSP OF AIRFRAME AND ENGS PER AMM 05-51-14. NO DAMAGE NOTED.SDR CALA2025091608962Bezel · not seated2R DOOR SLIDE ARMINDICATOR BLOCKED BYPACK COVER ON LOWER LOF DOO R AND FLOOR DOOR 2R SLIDE BEZEL FWD LOWER CORNER NOT SEATED PROPERLY OBSRUCTING VIEW OF ARMED INDICATOR DOT ON GIRT BAR. RESEATED SLIDE BEZEL. REF AMM 25-62-44SDR CALA2025091608959Girt Bar · no discrepancyDOOR L2 GIRT BAR HAS A PIECE OF CLOTH THAT DOEST LOOK NORMAL REPOSITIONED SLIDE BUSTLE MATERIAL. OPS CHK IS GOOD. SLIDE REMOVAL NOT NESSASARY.SDR YENA2025091600937Skin · dentedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / SKIN PANEL / FR69-70 AT LEVEL OF STR 20L-22L / DENT - PERMANENT REPAIR; REFERENCES: /1/ AEROMAN EA 53-0052-25 COVER & PART 1-4 /2/ AIRBUS RDAF 81645864/006/2025 ISSUE A /3/ AIRBUS TD/81645864/038/2025 ISSUE SDR YENA2025091600936Skin · damagedDURING HEAVY MAINTENANCE: LIGHTNING STRIKE EXTERNAL SKIN LOC. BTW FR 74 TO FR 75 AND BTW STR 30 R TO STR 31R AT LOWER FUSELAGE; REF AEROMAN WO 2025 191/1 NR 513008. PERFORMED REPAIR AT EXTERNAL SKIN LOC. BTW FR 74 TO FR 75 AND BTW STR 30R TO STR 31R AT LOWER SDR YENA2025091600935Skin · dentedDURING HEAVY MAINTENANCE: DENT EXTERNAL SKIN LOC. BTW FR 71 TO FR72 AND BTW STR 33L TO STR 34 AT LOWER FUSELAGE; (RESOLVED ON W/O: 1377910 TASKCARD: NR-00030) REF AEROMAN WO 2025 191/1 NR 512973 PERFORMED PERMANENT REPAIR ON EXTERNAL SKIN LOC. BTW FR 71 TO FR7SDR DXTA2025091504939Unknown · odorWITH APU RUMNING FOR APPROX 45 MINS. STARTED TO SMELL AN ELECT SMOKE ODOR COMING FROM OVERHEAD PANEL IN COCKPIT. ODOR APPEARED TO BE COMING START SWITCHES. NO SMOKE OBSERVED BUT SMELL WAS GOT STRONGER & FLT ATTENDANT ABLE TO SMELL IT IN GALLEY WHILE SHUTTING SDR P5CA2025091200065Pdu · smokeMAIN DECK CARGO 45R AND 44L PDU SMOKE COMES OUT. R & R PDU 44L & 45R PER AMM 25-57-01. OPS CHK OK. DMI 238051 & 238052.SDR AALA202509158023Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER LIFT OFF, STRONG FUME SMELL WAS PRESENT IN CABIN. IT SMELLED LIKE SOMETHING WAS BURNING BUT NO SMOKE WAS PRESENT. WE COULD NOT DETERMINE THE SOURCE OF THE FUMES. AIRCRAFT AIR INTERRUPTED BACKSDR AALA202509152366Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. THE DOOR WILL INTERMITTENTLY COME OF THE RAIL. FOUND LOOSE SCREW AT TOP OF DOOR, RETORQUED SCREW OPERATIONAL CHECK NORMAL. PER CMM 25-40-64.SDR AALA202509150428Door · jammedAIRCRAFT WAS NOT GROUNDED: TOP OF AFT LAVATORY-D DOOR IS JAMMING MAKING IT HARD TO OPEN AND CLOSE. RESCURED LAVATORY-D DOOR TRACK. PER AMM 25-40-00.SDR AALA202509152572Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN NEAR THE KNEES OF A PASSENGER SEATED IN SEAT 17F HAS A COVER THAT HAS FALLEN OFF. REPLACE EXIT LIGHT ASSEMBLY AT SEAT 17F. PER AMM 33-51-01.SDR SWAA2025091514080Extinguisher · no discrepancyAFT CARGO FIRE ILLUMINATED ON CLIMB OUT FL250 DECLARED EMERGENCY; RETURNED TO DAL. DISCHARGE FIRE BOTTLE IN AFT CARGO. R & R CARGO FIRE EXTINGUISHER BOTTLE AND CARGO ELECTRONIC UNIT(CEU) PER AMM 26-23-01 AND AMM 26-16-02. OPS TEST GOODSDR SWAA2025091514599Electronic Unit · false indicationAFT CARGO FIRE ILLUMINATED ON CLIMB OUT FL250 DECLARED EMERGENCY; RETURNED TO DAL. DISCHARGE FIRE BOTTLE IN AFT CARGO. R&R CARGO FIRE EXTINGUISHER BOTTLE AND CARGO ELECTRONIC UNIT(CEU) IAW AMM 26-23-01 AND AMM 26-16-02. OPS TEST GOODSDR SWAA2025091514082Tire · failedRIGHT NOSE WHEEL TIRE BLEW OUT ON DEPARTURE OUT OF PHX. NO ABNORMAL INDICATIONS OR SMELLS. C/W TIRE TREAD LOSS OR BURST CONDITIONAL INSPECTION IAW AMM 05-51-54. NO OTHER DEFECTS NOTED.SDR SWAA2025091514123Lens · damagedMID-CABIN EMERGENCY EXIT SIGN DAMAGED. INSTALLED LENS IAW MM 33-51-01SDR SWAA2025091514483Flashlight · inoperativeCREW REPORTS AFTER F/A FLASHLIGHT WILL NOT TEST. R & R THE FLASHLIGHT AND BATTERY IAW 25-64-00, OPS CHECK NORMAL.SDR SWAA2025091514788Battery · no testCREW REPORTS AFTER F/A FLASHLIGHT WILL NOT TEST. R & R THE FLASHLIGHT AND BATTERY IAW 25-64-00. OPS CHECK NORMAL.SDR SWAA2025091514121Retainer · looseGIRT BAR BRACKET ON L1 DOOR IS LOOSE. DOES NOT HOLD GIRT BAR SECURELY. ADJUSTED L1 DOOR GIRT BAR RETAINER CLIPS PER S.I.P. OPS CHECK GOOD; GIRT BAR NOW SECURED.SDR SWAA2025091514006Power Supply · inoperativeFWD EMERGENCY EXIT SIGN LT ENTRY DOOR AND OUTSIDE LT EMERGENCY LIGHTS NOT ILLUMINATING. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-802. OPS CHECK GOOD.SDR SWAA2025091514448Glowstrip · loosePHOTOLUMINESCENT STRIP COMMING UP AT ROW 12 FO SIDE. RESECURED STRIP PER AMM 33-51-15. NO DAMAGED NOTED, ACFT OK FOR SVC.SDR SWAA2025091514022Lamp · inoperativeMOST FWD R/H OUTSIDE EMERGENCY LIGHT IS OUT. REPLACED THE LAMPS FWD SERVICE DOOR SLIDE ILLUMINATION IAW AMM 33-51-04, OPS CHECK GOOD.SDR SWAA2025091513853Battery Pack · no testBATTERY PACK M1673 FAILED CAPACITY TEST. R&R BATTERY PACK M1673 IAW AMM 33-51-06.SDR SWAA2025091513854Handle · looseFWD ENTRY DOOR LINER UPPER ASSIST HANDLE IS LOOSE. RESECURED FWD ENTRY DOOR LINER UPPER ASSIST HANDLE IAW AMM 20-50-11.SDR SWAA2025091513855Handle · looseAFT ENTRY DOOR LINER ASSIST HANDLE IS LOOSE. RESECURED AFT ENTRY DOOR LINER ASSIST HANDLE IAW AMM 20-50-11.SDR SWAA2025091513882Lens · damagedL/H OVERWING EXIT AFT LIGHT LENS RETAINER IS DAMAGED. REMOVED AND REPLACED LT OVERWING EXIT LIGHT LENS IAW AMM 33-51-01-960-801 STEPS 2.C.1.A(3) AND 2 C(4).SDR SWAA2025091513883Lens · damagedRIGHT OVERWING EXIT FWD LIGHT LENS RETAINER IS DAMAGED. REMOVED AND REPLACED RT OVERWING EXIT LIGHT LENS IAW AMM 33-51-01-960-801 STEPS 2.C.1.A(3) AND 2.C(4).SDR SWAA2025091513848Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. RT SIDE ROWS 1 - 24; LT SIDE 1 - 14. R & R THE BATTERY PACKS IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWI2025F01312Warning Message · activatedFLAPS FAIL CAUTION MESSAGE IN CRUISE. RAN QRH, LANDED NORMALLY. DESCENT RATE AT TOUCHDOWN 300FPM. (FLIGHT 4728 - FILED CLOSED)RESET AND OPERATED FLAPS 5 FULL CYCLES AND COMPLETED AD 2009-06-12/10 COMPLIANCE FORM OK TO CONTINUE IN SERVICE FOR 10 FLIGHT CYCLESSDR SWIA2025091500012Proximity Switch · faultedPASSENGER DOOR WARNING IN FLIGHT (FLIGHT 3699 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30830514 WITH THE FOLLOWING CORRECTIVE ACTION: "TROUBLESHOT AND FOUND 2 B1 CODES FOR PAX DOOR. B1-046647 AND B1-046649. TROUBLESHOT IN REF TO CRJ 900 FSDR AALA202509157134Proximity Switch · out of rigAIRCRAFT WAS GROUNDED: R2 SLIDE INDICATES INTERMITTENTLY ARMED DURING FLIGHT ON LOWER ECAM. FA SAYS DOOR INDICATES ARMED AT THE DOOR. MAINTENANCE ADJUSTED PROX SWITCH TARGET NUT.SDR AALA202509153958Cover · damagedAIRCRAFT IN BASE MAINTENANCE: LAV - 4F-RC FWD EMERGENCY LIGHT ASSY AND COVER DAMAGED **. LAV 4F-RC FWD EMERGENCY LIGHT ASSY AND COVER REPLACED AND CHECKED FOUND NORMAL AS PER AMM 33-51-05.SDR AALA202509153352Indication Sys · intermittentAIRCRAFT WAS GROUNDED: CABIN 1R DOOR ARMED LIGHT INTERMITTENTLY INFLIGHT ON LOWER ECAM AND AT THE SAME TIME THE DOOR CABIN OVER PRESSURE FLASHING RED ON THE DOOR. (OPEN)SDR DALA2025091506786Retainer · corrodedCORROSION ON TROLLEY RETAINER BLOCK COMPARTMENTS 110 AND 111 OF GALLEY 1 AT FWD GALLEY AREA. COMPLIED WITH ER/A 628362-14. (1195648).SDR YENA2025091500935Slide Raft · unwanted deployFLT#1916, GEO-JFK. "R4 DOOR SLIDE ACCIDENTAL DEPLOYMENT; REMOVED AND REPLACED SLIDE IAW AMM 25-62-44 OPS CHK GOOD."SDR SIMA20250912001Unknown · odorSTRONG SMELL OF SMOKE IN THE COCKPIT FOLLOWED FIM TASK 21-20-00-810-801-A. NO SMOKE SMELL NOTED DURING INSPECTION. TRIAD RELEASED....MOC 341558SDR SIMA20250912002Power Supply · faultedFOUND R 2 SERVICE DOOR EMERGENCY EXIT LOCATOR SIGN INOP TROUBLESHOT PER FIM TASK 33-50-00-810-816-A RAR EMERGENCY BATTERY POWER SUPPLY IAW AMM 33-50-01 OPS CHECK GOODSDR WX0A2025091532563Battery Pack · inoperative(AIRCRAFT NOT GROUNDED) EPSU BATTERY INOP / REMOVED AND REPLACED REF WO522465"