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 SWAA2026020462536Scuff Plate · crackedFWD CARGO DOOR AFT CORNER SCUFF PLATE CRACKED. THE SCUFF PLATE WAS REPAIRED IAW SRM 53-30-15-2R-1.SDR SWAA2026020462424Support · corrodedCORROSION ON AFT CARGO BAY BULKHEAD CENTER PANEL LOWER SUPPORT AT BS 947, LBL 21 - RBL 21, WL 155. REMOVED AND REPLACED ACB AFT BULKHEAD LOWER SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 149A8117, REV -.SDR SWAA2026020462425Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT AT BS 887 - 947, RBL 21, WL 155. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02, & DWG 147A7500, REV-.SDR SWAA2026020462427Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT AT BS 727A - 827, LBL 21, WL 155. REMOVED AND REPLACED ACB FLOOR TO SIDEWALL SUPPORT ANGLE IAW SRM 51-40-02-0G-0 AND DWG 146A7500, REV -.SDR SWAA2026020462426Shield · corrodedCORROSION ON AFT CARGO BAY SHIELD SUPPORT AT BS 847 - 867, RBL 21, WL 155. REMOVED AND REPLACED THE ACB SHIELD IAW SRM 51-40-02-0G-0, AND DWG 146A0081, REV-.SDR SWAA2026020462428Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT AT BS 727A - 767, RBL 21, WL 155. REMOVED AND REPLACED THE FLOOR TO SIDEWALL SUPPORT LOT 1632871-1 FROM BS 727 - 767, RBL 21, WL 155 IAW SRM 51-40-02-0G-0, & DWG 146A7500, REV -.SDR SWAA2026020462429Support · corrodedCORROSION ON AFT CARGO BAY SHIELD SUPPORT AT BS 767 - 794, RBL 21, WL 155. R & R AFT CARGO BAY SHIELD SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 146A0081, REV-.SDR AALA202602034885Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 67 AND FR 68 AT S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202602023764Hinge 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 AALA202602027805Hinge 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 AALA202602021811Hinge 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 AALA202602023297Hinge 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 AALA202602023592Hinge 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 AALA202601270632Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500F AND BS 500G AT RBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR CALA2026012713319Channel · corrodedFWD CARGO BAY, LT ZEE CHANNEL BTW BS 400 - 500C, POSSIBLE CORROSION. R & R THE ZEE CHANNEL IAW SRM 51-40-02-0G-0, STEPS 4 & 7, SRM 53-00-53-2R-6, STEP 4, FIG 202, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0 , SRM 51-20-01-0G-0, & SOPM 20-41-02.SDR SWIA2026012675070Window Post · crackedCRACK ON LT COCKPIT WINDSHIELD POST DETERMINED TO BE OUT OF LIMITS AND SIDE POST REQUIRES REPLACEMENT. MAJOR REPAIR. COMPLIED WITH MAJOR REPAIR FOR CRACK IDENTIFIED ON LT COCKPIT WINDOW POST, COMPLIED WITH STRUCTRUAL MAJOR REPAIR, TASK CARD 51-900-1002-SKY SDR CALA2026012313189Floor Support · corrodedAFT WET AREA FLOOR SUPPORT STA 947+5 LBL 27 TO LBL 50 APROX. P#147A5676-5 FOUND CORROSION ON SURFACE AREAS. REMOVED & INSTALLED NEW FLOOR SUPPORT BETWEEN LBL-27 TO LBL-50 STA 947+5" REF B737-800 SRM 51-40-02-0G-0 AND DWG#147A5650.SDR DALA2026012200499Skin · gougedFUSELAGE SKIN STA 148.55 LONGERON 19L TO 20L GOUGE DAMAGE. C/W ERA 626451-14 (1406347)SDR DALA2026012200497Uplock Sensor · faultedPERFORMED GO AROUND DUE TO RIGHT MLG UNSAFE INDICATION WHEN GEAR EXTENDED FOR LANDING. INDICATION RETURNED TO NORMAL AIRCRAFT LANDED SAFELY. CORRECTIVE ACTION: FOUND RIGHT MLG UPLOCK SENSOR OUT OF ADJUSTMENT. ADJUSTED SAME. SERVICED RIGHT MLG STRUT PER MCC REQSDR DALA2026012200496Fadec · faultedFLIGHT CREW DIVERTED TO ATL DUE TO RIGHT ENGINE FADEC ALTERNATE MODE CAUSING FLIGHT TO BE REMOVED FROM CAT 1/2/3 AND RVSM. REMOVED AND REPLACED RIGHT ENGINE P20/T20 PROBE AND EEC.(7905400)SDR DALA2026012200482Slide · low pressureRIGHT FWD DERVICE DOOR SLIDE HAS LOW PRESSURE. REMOVED AND REPLACED RIGHT FORWARD DOOR SLIDE IAW AMDS TC 2561-4004-RF. (LP: 9141074)SDR CALA2026012213146Frame Splice · crackedAFT CARGO FR 61 LEFT FRAME SPLICE SECTION CRACKED BETWEEN STR 34L & 36L. REMOVED AND REPLACED THE LT FRAME SPLICE SECTION.SDR CALA2026012213144Panel · crackedAFT CARGO, LEFT PROFILE PANEL FROM FR 59 - 63 CRACKED AT STRINGER 35L, IAW AAR LCQ 9296225/36225. REPLACED, AND INSTALLED AFT CARGO BAY PROFILE PANEL IAW SRM 51-42-11-001, SRM 51-44-11-001.SDR AALA202601212735Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR ACCUMULATOR REQUIRES SERVICING. ACCUMULATOR IS READING 1300 PSI AT 26F. MAINTENANCE SERVICED R1 DOOR ACCUMULATOR IAW AMM 52-10-00.SDR AALA202601210165Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR ACCUMULATOR REQUIRES SERVICING. ACCUMULATOR IS READING 1200 PSI AT 26F. MAINTENANCE R2 DOOR ACCUMULATOR WAS SERVICED. IAW AMM 52-10-00.SDR AALA202601218777Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: ON CLIMBOUT AROUND 1200' AS THRUST WAS REDUCING, MASTER CAUTIONAND FUEL BYPASS LIGHT ILLUMINATED ON NUMBER 2 ENGINE OCCURRED. REMOVE AND REPLACED FUEL FILTERS ON BOTH ENGINES (AALA202601218683) (AALA202601219379). PER JOBCARD 08L40073004SDR AALA202601219379Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: ON CLIMBOUT AROUND 1200' AS THRUST WAS REDUCING, MASTER CAUTIONAND FUEL BYPASS LIGHT ILLUMINATED ON NUMBER 2 ENGINE OCCURRED. REMOVE AND REPLACED FUEL FILTERS ON BOTH ENGINES (AALA202601218683) (AALA202601219379). PER JOBCARD 08L40073004SDR AALA202601218683Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: ON CLIMBOUT AROUND 1200' AS THRUST WAS REDUCING, MASTER CAUTIONAND FUEL BYPASS LIGHT ILLUMINATED ON NUMBER 2 ENGINE OCCURRED. REMOVE AND REPLACED FUEL FILTERS ON BOTH ENGINES (AALA202601218683) (AALA202601219379). PER JOBCARD 08L40073004SDR AALA202601212026Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY DOOR IS HARD TO OPEN. ADJUSTED LEFT LAVATORY DOOR. OPS CHECK GOOD. PER AMM 25-40-14.SDR AALA202601219839Boot · damagedAIRCRAFT WAS GROUNDED, AIRCRAFT REPEAT EVENT. LOUD THUMP HEARD FROM NOSE GEAR COMPARTMENT RIGHT AFTER TAKEOFF AND ANOTHER LARGE THUMP AND SOUND ABOUT A MINUTE LATER. THEN WHEN WE LOWERED GEAR, THE LGCIU 2 FAILED. DECESION MADE TO RETURN TO DFW AIRCRAFT LANSDR AALA202601214657Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE, EMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M33094 FAILED 72C20033010 FUNCTIONAL CHECK. EMERGENCY LIGHT BATTERY PACK. OPS CHECK REQUIRED AFTER BATTERIES ARE FULLY CHARGED, OPS CHECK GOOD IAW AMM 33-51-06.SDR AALA202601213189Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE, EMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M33407 FAILED 72C20033010 FUNCTIONAL CHECK. EMERGENCY LIGHT BATTERY PACK. OPS CHECK REQUIRED AFTER BATTERIES ARE FULLY CHARGED. OPS CHECK GOOD IAW AMM 33-51-06.SDR 2026FA0000050Shutoff Valve · failedLIQUID OXYGEN SHUTOFF VALVE GOT HOT AND MALFUNCTIONED. CAUSING LOSS OF LIQUID OXYGEN TO PATIENT.SDR YENA2026012100058Unknown · odorFLT # 808 STT-SJU. "F/A REPORTS LEVEL 2 FUME EVENT. INFLIGHT BOTH FWD & AFT REPORTED STRONG GLUE/ DIRTY SOCKS SMELL DURING FLIGHT.; FOLLOWED INFO NOTICE 2017-T015M. NO LEAK NOTED ON A/C BELLY OR APU COMPARTMENT NO, PREVIOUS HISTORY ON LEST 30 DAYS. ISOLATED FASDR REXA2026012100018Bulb · burned outEMERGENCY FLOOD LIGHT AT PAX DOOR HAS BULB BURNT OUT R/R BULB OPC GOOD IAW CRJ900 AMM 33-51-00SDR AALA202601215916Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT BAFFLE LOCATED AT BS 947, S25R. REPLACED BAFFLE PER AARD 51-00-05-1..SDR CALA2026012113126Hinge · damagedLEFT ENGINE THRUST REVERSER BLOCKER DOOR DAMAGED. BLOCKER DOOR BROKE AT HINGE. BOTH HINGES AT FORWARD EDGE OF DUCT BROKE. REMOVED AND REPLACED NR 1 ENGINE INBOARD THRUST REVERSER.SDR DALA2026012000438Roller · faultedATO- APPROX. 80 KNOTS DUE TO RIGHT THRUST REVERSER INDICATION. FORWARD REVERSER TO MEL 78-00-01. REPLACED RT SLEEVE STOW SENSOR ROLLER. (LP 8089900)SDR AALA202601206070Slide · low pressureAIRCRAFT WAS GROUNDED: DOOR 1R ESCAPE SLIDE WITH LOW PRESSURE FOR PS CHK. REMOVED AND REPLACED R1 DOOR SLIDE IAW W/C 7280025001.SDR SWAA2026012062319Megaphone · malfunctionedAFT GALLEY MEGAPHONE SOUNDS A TONE WHEN NOT IN USE. REINSTALLED ALARM PLUG PIN AS REQUIRED IAW AMM 25-64-00. OPS CHKS NORMAL.SDR DALA2026012000425Frame · damagedDTE, ERA 631344-14, AFT CARGO COMPARTMENT FRAME BS 1540, BTW S28R & S29R CORRODED, MONITOR INSPECTION LOG REPAIR TO FUSELAGE FRAME AT BS 1540 BETWEEN STRINGERS 27-30R. REF ERA 631344-14. (1406876)SDR DALA2026012000420Bushing · missingNUMBER 2 ENGINE PYLON BULKHEAD, AFT ENGINE MOUNT FORWARD SHEAR PIN BUSHING NOT INSTALLED. PERFORMED FPI ON AFT ENGINE MOUNT FORWARD SHEAR PIN BORE REF. SOPM 20-20-02 & DAL P.S. 900-6-3 NO.2, REAMED FORWARD SHEAR PIN BORE TO .9535" IAW SRM 54-51-02- 2R-2. PERSDR AALA202601207426Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38 WITH NO FAULTS NOTED.SDR AALA202601208088Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601209679Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 12WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38 WITH NO FAULTS NOTED.SDR AALA202601208390Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601207147Warning Message · false activationAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING AN AFT CARGO DOOR OPEN INDICATION ON ECAM DISPLAYED AFTER TAKEOFF DURING CLIMBOUT AT ABOUT 1000 FEET. THE AIRCRAFT LANDED SAFELY AT DFW AND TSDR AALA202601202603Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR LOCKING MECHANISM STICKS. DOOR IS DIFFICULT TO BOTH CLOSE AND OPEN. MAINTENANCE CLEANED AND APPLIED LUBRICANTS TO DOOR LATCH PER AMM 52-51-00.SDR AALA202601200322Elec Connector · defectiveAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS AT SEAT ROWS 13ABC AND 14ABC ARE INOPERATIVE. MAINTENANCE REPLACED CONNECTOR UNDER SEAT 14ABC AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM PER AMM 33-51-05 WITH NO ISSUES NOTED.SDR AALA202601205526Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.