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 REXA2025111900990Angle · corrodedFS 280 FWD J ANGLE IS CORRODED. REMOVED UNSERVICEABLE F.S. 280 FWD J ANGLE AND INSTALLED A SERVICEABLE F.S. 280 FWD J ANGLE IAW SRM 51-42-21-001-001-A01, 51-42-06-001-001-A01, AND 51-40-001-001-A01.SDR 3M3A13040017Actuator · malfunctionedPILOT REPORTED CYCLIC JERKED LEFT WHILE IN FORWARD FLIGHT AND FELT AS IF TRIM WAS IN FULL LEFT POSITION. UPON INITIAL INSPECTION OF AIRCRAFT PERFORMED A FUNCTIONAL CHECK OF TRIM ACTUATORS. CONFIRMED TRIM MOTOR TO BE CORRECTLY CORRESPONDING TO INPUTS MADE TO CYSDR CALA2025111011081Floor Support · corrodedFOUND CORROSION ON FWD WET AREA LEFT INNER CHORD (L1 DOOR) BETWEEN BS 274 TO 368. REMOVED AND REPLACED FWD WET AREA LEFT INNER CHORD BETWEEN BS 274 TO 368 IAW SRM 51-40-02 STEP 4 AND 7, SRM 51-40-05 AND SRM 51-40-08.SDR IPXA2025110562627Fairing · crackedAFT FAIRING 485AL HAS A CRACK AT AFT I/B SIDE. PERFORMED WELDING AT CRACKED AREA AT AFT FAIRING 485AL AT AFT I/B SIDE. IAW SRM 54-55-51 AMS 4921 RED. VERIFIED PERFORED WELDING AT CRACKED AREA AT AFT FAIRING 485AL AT AFT I/B SIDE. IAW SRM 54-55-51 AMS 4921.SDR IPXA2025110656340Beam · crackedA 0.3125 INCH CRACK WAS FOUND ON THE BEAM AT THE FORWARD-LOWER CORNER OF THE L1 DOOR. IAW AMM 52-11-01-404-018, REV 59. INSTALLED L1 DOOR. CONDITION CHECK NORMAL.SDR AALA202511069793Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511069457Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511060621Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511064294Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511062921Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511060857Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511069870Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511067278Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202511061442Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR REXA2025110600980Drag Angle · crackedLEFT AFT DRAG ANGLE APPEARS CRACKED. REMOVED SURFACE FINISH IAW SRM 51-26-01-001-001-A01 & TS012487A. ON FURTHER EVALUATION FOUND LT AFT DRAG ANGLE TO BE CRACKED & REQUIRES REPAIR OR REPLACED. REMOVED DAMAGED LT AFT DRAG ANGLE IAW SRM 51-42-13-001-001-A01. SSDR REXA2025110600979Drag Angle · crackedLEFT FWD DRAG ANGLE APPEARS TO BE CRACKED. INSTALLED REPAIR PARTS ON LT FWD DRAG ANGLE AND COMPLIED WITH ALL STEPS OF CRJ900 SRM 55-31-00-201-001-A01SDR MASA2025102600091Actuator · inoperativeFLAP FAIL TO RETRACK DURING TAKEOFF/ R & R ACTUATOR R4, C/W MECHANICAL AND ELECTRICAL RIGGING.SDR ASAA2025102661567Handle · fodR1 DOOR WILL NOT DISARM FROM INSIDE THE CABIN. GROUNDED - YES. CLEANED DEBRIS AND PERFORMED R1 DOOR ARM / DISARM. OPS CHECKED IAW AIRBUS AMM 52-71-00-710-802-A. OPS CHECKED GOOD. AIRCRAFT OK FOR SERVICE.SDR AALA202511041848Oven · odorAIRCRAFT WAS NOT GROUNDED: BURNING PLASTIC SMELL REPORTED AFTER TAKE OFF IN THE FORWARD GALLEY AREA. ACCOMPLISHED SOF JC 78L00021001 FOUND FORWARD GALLEY OVEN 1B TO BE THE SOURCE OF BURNING PLASTIC SMELL. REMOVED AND REPLACED OVEN 1B, PER CMM 25-35-14SDR U2RA2025110200025Spar · crackedDURING A-CHECK INSPECTION AT SHARP TK LOCATED IN RKSI, A CRACK INDICATION WAS DETECTED AT THE INBOARD UPPER HOLE OF THE HORIZONTAL STABILIZER REAR SPAR UPPER CHORD AT RBL 43.5 BY OPEN-HOLE HFEC. OVERSIZED HOLE AND FREEZE PLUG INSTALLATION PERFORMED IAW BOEINGSDR DALA2025103107996Cover · missingROW 17 EMERGENCY EXIT COVER MISSING. INSTALLED EMERGENCY LIGHT COVER REF B737 AMM 33-51. (LP 7371785)SDR HNAA2025102700727Switch · illuminatedE1 TR DISAGREE ON T/O ROLL AT 40 KNOTS. C/W MAINT PROCEDURES. E1 TR DEACTIVATED. ENG 1 OR 2 REV DISAGREE MESSAGES. T/S IRW FIM TASK 78-30-00-810-809-A PROBABLE CAUSE T/R STOW SWITCH. R&R STOW SWITCH IAW AMM 78-34-01. OPS CHECK GOOD. CLEAR MEL 78-2. A/C OK FOSDR CALA2025103110768Wire · pulledSEAT MOUNTED EMERGENCY LIGHT AT SEAT 10C INOPERATIVE. R & R THE FLOOR PROXIMITY EMERGENCY LIGHT ASSY IAW AMM 33-51-11. DID NOT FIX. FOUND WIRING PULLED OUT FROM COVER AND EXPOSED TO PASSENGERS FEET AT ROW 10 ABC. BLACK WIRE PULLED OUT OF CONNECTER. VERIFIESDR CALA2025103010753Warning Message · illuminatedREJECT JUST PRIOR TO 100 KNOTS, FORWARD DOOR, ACCOMPLISHED CONDITIONAL INSP. FOR HIGH ENERGY STOP DUE TO REJECTED T/O. NO STRUCTURAL DAMAGE FOUND TO ALL MLG, ALL TIRES BOTH ENG. COMPONENTS AND FUSELAGE AND WING STRUCTURE IAW AMM 05-51-07-210-801. BOTH MLGSDR CALA2025103010720Slide · unraveledFOUND 2LH MED DOOR SLIDE SAFETY LACE LOOSE, AND UNRAVELING. NEED TO REPLACE DOOR SLIDE. CORRECTION. LOG SHOULD READ: GIRT BAR SEPERATED FROM SLIDE. LACING INTACT. REMOVED AND REPLACED L2 DOOR SLIDE REF AMM 25-66-01. VERIFIED DOOR 2L SLIDE INSTALL. RII REF GMSDR CALA2025103010719Door · no discrepancyFA REPORTS DOOR 2R KEEPS MOVING UP INFLT PRESSURERIZATION WAS NORMAL. PERFORMED GVI OF DOOR 2R ROLLER CAMS, LATCH ROLLERS AND DOOR INDICATION SENSOR FOR WITNESS MARKS OR CONTACT WEAR. NO DEFECTS FOUND. REF FIM 52-10 TASK 815. DOOR OPENS AND CLOSES NORMALLY, ISDR CALA2025103010718Sensor · false activationDOOR WARNING ANNUNCIATOR IS ON FWD ENTRY ILLUMINATED ON DESCENT AROUND 6000 FT. FA PUSHE D HANDLE DOWN VI A CHECKL IST. LIGHT EXTIGUISHED. COULD NOT DUPLICATE FAULT REQUEST MEL 5203E ON FWD ENTRY DOOR. MEL 5203E TOMC REJECTING FOR MORE T/S. AMM 52-11-00-820-8SDR AALA202510302433Door · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT SAYS MAIN CABIN DOOR IS DIFFICULT TO OPEN. READJUSTED L1 DOOR. PER 52-11-21-400-802.SDR AALA202510304348Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 ENGINE SHUT DOWN IN FLIGHT DUE TO LOSS OF OIL QUANTITY THEN LOSS OF OIL PRESSURE. AIRCRAFT EMERGENCY LANDED SAFELY AT CLT. REMOVED AND REPLACED NUMBER 2 ENGINE. PER J/C 08L40072003. ALL OPERATIOSDR AALA202510306318Elec Connector · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ALL LAVATORIES NOT FUNCTIONING AT ALL, PASSENGER WASTE BUILD UP IN TOILET POSSIBLE OVERFLOW. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. LAVATORY CONNECTOR FOUND DAMAGED. REMOVE AND REPLACED CONNECTORSDR AALA202510301848Oven · contaminatedAIRCRAFT WAS NOT GROUNDED: BURNING PLASTIC SMELL REPORTED AFTER TAKE OFF IN THE FORWARD GALLEY AREA. ACCOMPLISHED SOF JC 78L00021001 FOUND FORWARD GALLEY OVEN 1B TO BE THE SOURCE OF BURNING PLASTIC SMELL. (OPEN).SDR DXTA2025103005456Service Door · openDURING CLIMB OUT THE WHITE EXTERNAL DOOR OPEN CAS MESSAGE ILLUMINATED. ON THE POST FLIGHT WE DISCOVERED THE LAVATORY SERVICE DOOR WAS MISSINGSDR U5QA202510260161Pseu · failedAIRPLANE IS TRANSITIONING FROM AIR TO GROUND MODE TRIGGERING MULTIPLE CAS MESSAGES. WOW FAIL TO START. MX C/A: R&R PSEU, FUNCTIONAL CHECKS GOOD, NO DEFECTS NOTED.SDR SWAA2025102928779Strap · brokenR2 SAFETY STRAP BROKEN. REPLACED R 2 DOOR SAFETY STRAP PER SIP AND AMM 52-41-31SDR SWAA2025102928679Battery · dischargedCOCKPIT EMERGENCY FLASHLIGHT LOW BATTERY. R & R COCKPIT EMERGENCY FLASHLIGHT BATTERY PER AMM 25-64-00SDR SWAA2025102928662Fastener · missingR1 GIRT BAR FASTENER TLD. INSTALLED FASTENER IN GIRT BAR ATTACHMENT PER AMM 25-66-01 AND SRM 51-40-02SDR SWAA2025102928657Girt Bar · unsecureFWD SERVICE DOOR GIRT BAR BRACKET ON DOOR LOOSE. REPLACED BROKEN RIVET ON FWD SERVICE DOOR GIRT BAR CLIP REF AMM 25-66-01 AND AMM 70-43-11. OPS CHECK GOOD.SDR SWAA2025102928665Battery Pack · inoperativeAFT RIGHT R2 DOOR EMERGENCY EXIT LIGHTS ARE INOP. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-802-MAX.SDR SWAA2025102928659Battery Pack · inoperativeAFT CABIN EMERGENCY ISLE LIGHTS INOPERATIVE. R&R AFT CABIN LT EMERGENCY LIGHT BATTERY PACK PER AMM 33-51-06; OPS CHECK OKSDR SWAA2025102928678Light · inoperativeFWD SERVICE DOOR EMERGENCY SLIDE LIGHT INOP. REMOVED AND REPLACED FWD SERVICE DOOR EMERGENCY SLIDE LIGHT IAW AMM 33-51-04SDR DALA2025102907932Frame · corrodedWING TO BODY FAIRING FRAME 48, BOTH LEFT AND RIGHT FRAMES SHOW SIGNS OF CORROSION AND ELONGATED FASTENER HOLES. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 053-0001:5352-01038-09 /001 00626. REMOVED AND REPLACED FRAME REF A220 ASRP 53-82-55. (LP# 1272016)SDR AALA202510291862Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510292770Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510297992Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DALA2025102907930Skin · gougedSHIP 3317 GOUGES WERE FOUND ON THE FUSELAGE SKIN FROM FR 54 TO FR 55, STR 47R TO DTR 50R AT THE WING TO BODY FAIRING INTERFACE. CORRECTIVE ACTION: REPAIRED PER ERA 629754-14 REV ORIG. (1273092)SDR DXTA2025102905465Brake Assy · faultedBRAKES SHUDDERING AND GRABBING WHILE TAXIING, PERFORMED BRAKE AND EMERGENCY PARKING BRAKE SYSTEM BLEED. OPS CHECK GOOD. IAW AMM CH 32-40-00SDR CALA2025102910716Sensor · faultedCHIME ALERTED LEFT ENGINE BLEED TEMP NEARING BLEED TRIP OFF, DURING CRUISE AND DESCENT. THE BLEED REPORT CAPTURED THAT THE PRE-COOLER OUTLET TEMPERATURE REACHED AS HIGH AS 490 °F, RESULTING IN A LOW BLEED DUCT PRESSURE OUTPUT OF 17 PSI. (SYSTEM HAS GONE INTO SDR CALA2025102910715Blade · bird ingestionBIRD STRIKE ON T/O AIRFRAME AND ENG VIB RIGHT ENG APPEARS TO H AVE BLADE DAMAGE. PERFORMED AIRFRAME AND ENGINE BIRD STRIKE INSPECTIONS IAW AMM 05-51-14-200-803-A AND AMM 72-00-00-200-010-A. NO AIRFRAME DAMAGE WAS NOTED. NOTED ENGINE DAMAGE LIMITED TO A SISDR CALA2025102910714Radome · delaminatedPILOT REPORTED BIRDSTRIKE DURING TAKE OFF. COMPLIED WITH BIRD STRIKE INSPECTION IAW AMM 05-51-14. FOUND EVIDENCE OF BIRD ON BELLY PANEL 191BB AND RT WING ROOT. NO DAMAGE NOTED AND DEBRIES CLEANED. RADOME DAMAGED DURING BIRD STRIKE INSPECTION, FOUND A 15X15INSDR CALA2025102910681Slide · no discrepancyBOTH AFT ENTRY DOORS SLIDE PRESSURE GAUGES NOT IN GREEN BAND DOOR 2L, NEEDLE IS WITHIN TOLERANCE. DOOR 2R IS 2 WIDTH NEEDLES ABOVE. GO CONDITION IAW AMM 25-66-99-702-001 (D) IN SERVICE, OBSERVE THE RELATIVE POSITION OF THE NEEDLE TO THE BACKGROUND COLOR. IF