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 SWAA2025080689845Floorbeam · corrodedCORROSION ON UPPER FLANGE OF BS 986 FLOORBEAM AT RBL 43 NUTPLATE HOLE; WL 208. REPAIRED BS 986 FLOORBEAM UPPER FLANGE RBL 43 IAW SRM 53-70-51-2R-6 REPAIR 6.SDR SWAA2025080689844Floorbeam · damagedELONGATED FASTENER HOLE ON PREVIOUS REPAIR UPPER FLANGE OF BS 986 FLOORBEAM AT LBL 43 NUTPLATE HOLE; WL 208. REMOVED AND REPLACED BS 986 FLOOR BEAM UPPER FLANGE LBL 43 PREVIOUS REPAIR FILLER IAW 53-70-51-2R-6 REPAIR 6.;[02] VERIFIED CORRECTIVE ACTION 1SDR SWIA2025080600709Spring · brokenFWD SERVICE DOOR AFT FLOOR FITTING HAS BROKEN SPRINGS. (GIRT BAR FITTING). REMOVED AND REPLACED FWD SERVICE DOOR AFT FLOOR FITTING FLAP SLIDE SPRING. REF AMM 53-10-25. OPS CHECKS NORMAL.SDR JJBA20250806006Shear Tie · crackedSHEAR CLIP AT FR 73 AND BTW STR 8L-10L FOUND CRACKED. SHEAR CLIP AT FR 73 AND BTW STR 8L-10L REMOVED AND INSTALLEDSDR IPXA2025080138044Attach Angle · crackedNR 1 PYLON-INSIDE 475AL 4TH STIFFENER FROM AFT END ON I/B SIDE HAS UPPER ATTACH ANGLE BROKEN-109-VWV-91195430 VERIFIED INSTALLATION OF NEW ANGLE.SDR DALA2025080405831Unknown · odorSHIP 1020 - DIV - TO ABQ DUE TO REPORT OF A CHEMICAL OR GAS SMELL AT SEAT ROWS 23/24. CORRECTIVE ACTION: NO TROUBLE FOUND. PERFORMED LEVEL A DECONTAMINATION. AIRCRAFT RTS.SDR SWIA202508010709Doubler · corrodedWASTE DOOR CUTOUT INTERNAL DOUBLER CORRODED. REMOVED AND REPLACED WASTE DOOR CUTOUT INTERNAL DOUBLER REF SRM 51-40-08.SDR SWAA2025072989360Insert · damagedPANEL 241ABF AFT GIRT FITTING, AFT FASTENER HOLE 2-PIECE INSERT IS DAMAGED. REMOVED AND REPLACED DAMAGED INSERT FOR AFT GIRT FITTING ON PANEL 241ABF IAW SRM 53-00-50-2R-0 PARA 5B(2); PARA 5S AND DWG 147A5810-88.SDR JJBA20250729106Inlet · damagedRH ENGINE AIR INTAKE, BLENDED SPOT TO BE INVESTIGATED. REPAIR DOUBLER ON RH NACELLE AIR INLET MODULE INNER SKIN.SDR CALA2025072907030Web · damagedFLIGHT COMPARTMENT FLOOR STRUCTURE BETWEEN BS 250-260 LBL 17 TO RBL3 HAS DENT AT MULTIPLE PLACES. REMOVED 2 EACH DAMAGED AREAS BETWEEN STA 250 TO 260 LBL2 AND LBL13 IAW SRM 53-10-51-2R-2, REPAIR 2 SECTION 41 FLOOR WEB FIG 203. INSTALLED REPAIR DOUBLER BETWEEN SDR IPXA2025072442329Strap · corrodedMAJOR REPAIR, CORROSION ON APU INLET FWD NUT PLATE STRAP INSTALLED STRAP P/N: 148N3138-20, BTCH NO. 0004410942 AT APU INLET DOOR SURROUNDING STRUCTURE IAW B757-200PF SRM 51-40-02-0G-0.SDR SWAA2025072489396Shield · corrodedAFT CARGO DOOR CUT OUT STRUCTURE FORWARD SHIELD IS CORRODED AROUND NUT PLATES ON LOWER SIDE. REMOVED AND REPLACED AFT CARGO DOOR CUT OUT STRUCTURE FORWARD SHIELD IAW SRM 51-40-02-0G-0 AND DWG 146A0081 REV A.SDR SWAA2025072489394Panel · delaminatedFORWARD CARGO COMPARTMENT FORWARD BULKHEAD PANEL 121LW LT UPPER CORNER BENT & DELAMINATED. REPLACED ON SHELF IAW SRM 51-10-02-0G-0 STEP 9. REMOVED AND REPLACED IAW SRM 51-10-02-0G-0-A00248.SDR SWAA2025072389395Strap · crackedAFT CARGO FORWARD BULKHEAD STRAP AT BS 727, RBL 24, WL 183, CRACKED. REMOVED STRAP, FABRICATED NEW, & INSTALLED NEW STRAP IAW SRM 51-40-02-0G-0, & DWG 144A2600 REV -, AND DWG 144A2617 REV B.SDR IPXA2025071845628Angle · corrodedAGING FINDING - MAIN DECK FLOOR STRUCTURE LOCATED APPROX STA 1715 RBL 12" AS SEEN FROM THE AFT PIT AFT ELEC BAY IS CORRODED AND EXFOLIATED. AA025 AUDIT C/W. VERIFIED REMOVE AND REPLACE SUPPORT ANGLE REF P/N: 146N5240-21 PER BOEING DWG 146N5240 IAW 757-200PF SRSDR JJBA20250721081Support · corrodedCF3 RH FUSE BTW FR 35-41 SILL CORRODED. CF3, RH SILL BTW FR 35-41 BLENDED AND FOUND OUT OF LIMIT. CF3 RH FUSE BTW FR 35-41 SILL REPLACEDSDR SIMA20250709002Floorbeam · corrodedAFT CARGO BAY HAS CORROSION ON A FLOORBOARD SUPPORT AT FR 74 AND STR 28L-28R. (LEVEL 2 CORROSION). BLENDED CORROSION ON FLOOR BOARD SUPPORT IN AFT CARGO FR 74 STR 28L-28R IAW E-175 SRM 51-10-03 L=.050 W=.050 H= .008 MATERIAL REMOVED .008 FOUND TO BE OUT OF LIMSDR SIMA20250709003Floor Support · corrodedAFT CARGO BAY HAS CORROSION ON A FLOOR PANEL SUPPORT AT FR 75 AT STR 29L-29R. (LEVEL 2 CORROSION). BLENDED CORROSION FROM AFT CARGO L/H BAGGAGE SUPPORT AT FR-75 PER EMB-- E175 SRM 51-10-03 BLENDED AREA MEASURES L=1.100" W=- .600" D=.021" AND WAS FOUND TO BE OUSDR CALA2025072106741Idg · explodedLEFT GEN DRIVE EICAS C THE LT GEN DRIVE HAS LOW OIL PRESSURE OR HIGH OIL TEMPER ATURE WHILE THE ENGINE IS IN OPERATION. LT ENG. C-DUCT OPENING AS AMM 78-31-00 THE FOLLOWING DAMAG ES HAS BEEN OBSERVED AS X GENERAL OVERVIEW: IDG ASSY ALL IDG OI L HOSES APPEARINSDR DALA2025071805433Frame · damagedSHIP 3416 TOOLING DAMAGE FRAME WEB FR 60. S-1L. REPAIRED PER ER/A 627487-14. (1072425)SDR CALA2025071806697Skin · damagedFOUND DAMAGE CREASE AT THE FUSELAGE SKIN BS 807 BTW S27R & 26L. REPAIRED DAMAGE CREASE AT THE FUSELAGE EXTERNAL SKIN STA 807 BTW STRG 27R & STRG 26L IAW EO#250153 REV P1, P2, IR , ECRA 5360-01970.SDR DXTA2025071404176Actuator · faultedAFTER TAKEOFF AND GEAR RETRACTION, HAD A YELLOW X FOR THE NOSE GEAR INDICATION ALONG WITH GEAR DISAGREE N. FOLLOWED QRH WHICH LED TO USING THE EMER GEAR RELEASE HANDLE FOR GEAR EXTENSION. RESULT WAS THREE GREEN INDICATION. PERFORMED FLY-BY AND TOWER CONFIRMSDR SWAA2025071789883Handle · unsecureCR RR L1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-11-31-400-802.SDR SWAA2025071789880Handle · looseCR RR L2 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L2 DOOR ASSIST HANDLE IAW AMM 52-13-31-400-802.SDR SWAA2025071789886Tail Cone · damagedCR VB #3 FLAP FAIRING AFT CONE HAS PULLED FASTENERS<[01] REMOVED AND REPLACED TAILCONE ON #3 FLAP FAIRING IAW B737-800 SRM 51-40-02 AND REF. B737-800 AIPC 27-51-18-01REMOVED AND REPLACED TAILCONE ON #3 FLAP FAIRING IAW B737-800 SRM 51-40-02; B737-800 AMM 20-50SDR AALA202507178073Light · no discrepancyAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ABOVE OVERHEAD BIN 17ABC INOPERATIVE. FAULT CONFIRMED, EMERGENCY AISLE LIGHT INOPERATIVE. OPERATIONAL CHECKED EMERGENCY LIGHT ABOVE OVERHEAD BIN 17ABC, OPERATIONAL CHECK GOOD. PER AMM 33-51-03.SDR DALA2025071705370Sliding Window · arcedSHIP 3275 DISC: CAPT'S SLIDING WINDOW CHORD ARCING. LET "ANTI ICE L WINDOW" ECAM MESSAGE IN FLIGHT. PERFORMED PERMANENT RESTORATION OF CAP LH SLIDING WINDOW ANTI ICE WIRE HARNESS. CK IS GOOD. PLACARD REMOVED. CLOSED DEFERRAL. OK FOR SERVICE.) DISC: CAPT'S SLIDSDR CALA2025071706654Web · corrodedAFT CARGO DOOR SURROUND STRUCTURE MAIN SILL WEB POSSIBLE CORROSION BETWEEN BS 794 & 847. R & R LOWER MAIN SILL WEB ON AFT CARGO IAW SRM 51-40-02-0G-0, SRM 51- 40-05-0G-0, SRM 51-40-08-0G-0, AMM 51-21-41-370-802, AMM 51-2 1-72-370-804, DWG 146A 8340 REV A, &SDR CALA2025071606613Skin · contaminatedLEFT ELEVATOR UPPER SURFACE HAS INDICATION OF WATER INGRESS 27 IN FROM IB EDGE, 23 IN FROM AFT EDGE AND 2 IN IN DIAMETER. REPAIRED LT ELEVATOR UPPER SURFACE IAW SRM 55-20-00-20 0-006-A AND SRM 55-21-11-300-005.SDR CALA2025071606612Intercostal · corrodedUPON REMOVAL OF PROFILE PANEL AFT CARGO, FRS 58-59 FOUND CORROSION ON UPPER FLANGE. REMOVED AND REPLACED INTERCOSTAL PLATE IN AFT CARGO FR 58-FR59 STR 38R IAW A320 SRM 51-42-11/001 51-44-11/001.SDR DXTA2025071604261Hinge · mechanic errorWHILE WORKING TO INSTALL THE LH WING AILERON ON AOG AIRCRAFT N649QS, SOMEHOW THROUGHOUT THE PROCESS IT MANAGED TO SLIP AND DAMAGE THE LH AILERON OUTBOARD HINGE OPENING ON THE TOP SIDE. IT APPEARS THAT THERE IS A CRACK AND THE DAMAGED AREA AROUND THE CRACK IS SDR SWAA2025071589872Battery Pack · failedAFT FLIGHT ATTENDANT SEAT O/B FLASHLIGHT NEEDS NEW BATTERY. REMOVED AND REPLACED BATTERY FROM AFT FLIGHT ATTENDANT SEAT O/B IAW AMM 25-64-00-SWA-807. OPS TEST PASSED. .SDR DALA2025071505314Oxygen Mask · no testSHIP 3168 O2 MASK WILL NOT SOUND DURING TEST. CORRECTIVE ACITON: R/R OBSERVER SEAT O2 STOWAGE BOX IAW A-319 AMM 35-12. (7454926).SDR ASAA2025070959368Tire · damagedRIGHT MAIN OUTBOARD TIRE DAMAGED ON LANDING. GROUNDED - YES. REMOVED AND REPLACED #4 AND #3 MLG WHEEL AND TIRE ASSEMBLY REF AMM 32-45-11-000-801 + AMM 32-45-11-400-801. CAUSED DAMAGE TO RH WING INBD TRAILING EDGE FLAPS AND RH WING FIXED TRAILING EDGE PANEL.SDR JBZA20250714001Elec Connector · looseDURING FLIGHT LEFT ENGINE FIRE WARNING LIGHT ERRATICALLY FLASHES. ELECTED TO PRECAUTIONARY LAND BACK TO BASE. MAINTENACE DISCOVERED LOOSE FIRE DETECTION AMPLIFIER CONNECTOR BACKSHELLSDR SWAA2025071489335Panel · crackedRIGHT WING LOWER MIDSPAN FIXED TRAILING EDGE PANEL 661AB TURN BARREL CRACKED ON SUPPORT ROD<[01] REMOVED AND REPLACED RIGHT WING LOWER MIDSPAN FIXED TRAILING EDGE PANEL 661AB TURN BARREL SUPPORT ROD PER AMM 20-50-11SDR SWAA2025071489410Fitting · looseR2 DOOR AFT GIRT BAR FITTING IS LOOSE. TIGHTENED R2 DOOR AFT GIRT BAR FITTING IAW SOPM 20-50-01 AND PERFORMED A GOOD OPS CHECK IAW AMM 25-66-02-400-801.SDR SWAA2025071489408Handle · looseL1 DOOR ASSIST HANDLE IS LOOSE. TIGHTENED L1 DOOR ASSIST HANDLE I.A.W SOPM 20-50-01.SDR SWAA2025071489420Skin · corrodedCORROSION ON FUSELAGE SKIN FWD EDGE OF STA 887 BUTT JOINT BETWEEN STRINGER S-24R AND S-26R. REMOVED CORROSION ON FUSELAGE BELLY SKIN BLEND FWD OF BS 887; S-24R TO S-26R) FOUND TO BE IN LIMITS PER SRM 51-10-02 AND EA 25-153-01849.SDR AALA202507145778Tire · blownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 MLG TIRE BLEW AS WELL DAMAGING HYDRAULIC LINE WHICH CAUSED THE ENGINE LOW PRESSURE LIGHT TO ILLUMINATE AS WELL. AIRCRAFT EMERGENCY LANDED SAFELY AT AUS. REMOVE AND REPLACED 2 MLG TIRE (AALA20250SDR AALA202507144784Hydraulic Line · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 MLG TIRE BLEW AS WELL DAMAGING HYDRAULIC LINE WHICH CAUSED THE ENGINE LOW PRESSURE LIGHT TO ILLUMINATE AS WELL. AIRCRAFT EMERGENCY LANDED SAFELY AT AUS. REMOVE AND REPLACED 2 MLG TIRE (AALA20250SDR AALA202507148609Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 MLG TIRE BLEW AS WELL DAMAGING HYDRAULIC LINE WHICH CAUSED THE ENGINE LOW PRESSURE LIGHT TO ILLUMINATE AS WELL. AIRCRAFT EMERGENCY LANDED SAFELY AT AUS. REMOVE AND REPLACED 2 MLG TIRE (AALA20250SDR AALA202507141911Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 MLG TIRE BLEW AS WELL DAMAGING HYDRAULIC LINE WHICH CAUSED THE ENGINE LOW PRESSURE LIGHT TO ILLUMINATE AS WELL. AIRCRAFT EMERGENCY LANDED SAFELY AT AUS. REMOVE AND REPLACED 2 MLG TIRE (AALA20250SDR DXTA2025071404185Door · faultedMAIN DOOR BEGINS TO OPEN BUT FAILS TO COMPLETE THE OPENING CYCLE. PERFORMED CABIN DOOR LATCHING/LOCKING SYSTEM AND DOOR WARNING SYSTEM TEST SECTION 3 PER CESSNA 680A MM 52-70-00. NO DEFECTS NOTED, MED OPENS AS ADVERTISEDSDR DXTA2025071404186Monitoring Unit · intermittentWHILE DESCENDING AT 2500 FPM THROUGH FL260 GOT RED CAB ALTITUDE HI CAS & SAW CABIN PRESSURE CLIMBING UP THROUGH 8000 WHILE PUTTING MASK ON. BY COMPLETETION OF BOTH OF US DONNING MASKS & ESTABLISHING COMMUNICATIONS MESSAGE EXTINGUISED AND CABIN PRESSURE RETURNESDR DXTA2025071404187Brake Assy · faultedTHE BRAKES WERE GRABBY DURING TAXI HOWEVER ON LANDING ROLL OUT WE HAD EVEN SMOOTH BRAKING. UPON ENTERING THE RAMP THE LINE AND MX TECHINCIAN AT THE FBO SAW ALOT OF SMOKE COMING FROM THE RIGHT MAIN LANDING GEAR. CORRECTIVE ACTION: REMOVED LEAKING BRAKE ASSY ANSDR DXTA2025071404189Panel · looseINFLIGHT VIBRATION FELT DURING DESCENT PHASES OF FLT AT HIGH SPEEDS AND DESCENT PITCH ATTITUDES ONLY (HIGHEST AROUND 290 & DECREASES UNTIL NEGLIGABLE BELOW 225KNOTS). VIBRATION SEEMS TO CORRELATE WITH SPEED & SEEMS UNRELATED TO ENGINES/ THRUST. IT ONLY OCCURS SDR DXTA2025071404190Door · out of adjustDOOR IS EXTREMELY DIFFICULT TO CLOSE. ACCOMPLISHED CHECK OF THE MAIN-DOOR INTERNAL HANDLE OPENING AND CLOSING FORCES (AMM TASK 52-11-23-720-801-A/500). INTERNAL HANDLE CLOSING FORCE FOUND AT 23.5KGF. MAX TOLERANCE IS 22.LKGF. PERFORMED MAIN DOOR ADJUSTMENT IASDR CALA2025071406499Web · corrodedAFTER FURTHER EVALUATION AT THE AFT CARGO DOOR SURROUND STRUCTUR E MAIN SILL WEB FOUND TO BE OUT OF LIMIT REQUIRE REPLACEMENT (RE F. AAR NR 1000042306) ALL DOCUMENTATION AND SUPPORTING DOCUMENTS ON RFD AAR N/R 1000042306. REMOVED & REPLACED THE AFT CARGO LOWSDR CALA2025071406498Skin · crackedR-2 DOOR, INNER UPPER SKIN, UPPER CENTER LIGHTENING HOLE IS CRACKED. REPAIRED R-2 DOOR INNER UPPER SKIN REFERENCE UNITED EC/RA# 5210-03403.