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 DALA2025102007662Fitting · damagedRING ATTACHMENT FASTENER HOLES AT BTW FR53.7-FR53.8 AND STR 2R - STR4R IMPROPER. CORRECTED PER ERA 620877-14 REV.B. (1259633)SDR AALA202510209384Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT GALLEY EMERGENCY FLASHLIGHT NEEDS REPLACING. MAINTENANCE REPLACED AFT GALLEY OUTBOARD EMERGENCY FLASHLIGHT AND CHECKS GOOD REF AMM 25-65-00.SDR GTIA2025102039141Unknown · odorFUME EVENT REPORTED BY FLT ATTENDANTS.-PERFORMED OIL SERVICING IN ENG #1 WITHIN LIMITS IAW AMM 79-00-00. PERFORMED INSP OF THE ENG #1 FAN BLADES AND INLET FOR ANY SIGNS OF WETNESS IAW AMM 79-00-00. NO SIGNS OF WETNESS AT THIS TIME. PERFORMED ENG #1 IDEL RUN ANSDR GTIA2025102039140Flashlight · inoperativeFWD FA EMER FLASHLIGHT INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R/R FWD FA EMER FLASH LIGHT PER NKS A321 CEO EMER EQUIP THIS CLEARS DMI 3519271-1 PLACARD REMOVED MOC NOTIFIED LOG UPDATEDSDR GTIA2025102039139Unknown · odorNUMEROUS FUME ISSUES PREVIOUSLY REPORTED BY ATL MAINTENANCE. OIL RESIDUE/BURNING SMELL STRONG ON APPROACH AND TAXI IN FLL. CAME FROM ENG 1. SOURCE UNKNOWN. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.--SDR GTIA2025102039138A/C Pack · odorFUME EVENT ON DESCENT ISOLATED TO PACK 1-PERFORMED TSM 05-50-00-810 NO ODOR NOTED AT THIS TIME AC OK FOR SERVICE ALL SOURCES OF BLEED OPERATED AND ISOLATED NO SMELL NOTED OK FOR SVCSDR DALA2025102007639Structure · damagedFOUND AFT GALLEY LAMINATE COSMETICALLY DAMAGED. R & R AFT GALLEY HAND SANITIZER LAMINATE PER A319 AMM 25-31. (1260239).SDR DALA2025102007638Structure · damagedFOUND FWD GALLEY LAMINATE COSMETICALLY DAMAGED. R & R FWD GALLEY HAND SANITIZER MOUNT LAMINATE PER A319 AMM 25-31. (1260236).SDR AALA202510200578Light · brokenAIRCRAFT WAS NOT GROUNDED: 12C EMERGENCY LIGHT BROKEN. REMOVE AND REPLACED EMERGENCY LIGHT PATH ASSEMBLY AT SEAT 12C. PER CMM 25-23-67. OPERATIONAL CHECK GOOD.SDR ABXA20251019275Smoke Goggles · crackedDURING INSPECTION, MAINTENANCE FOUND SMOKE GOGGLE CRACKED AT SUPERNUMERARY MID SEAT. REMOVED AND REPLACED SMOKE GOGGLE AT SUPERNUMERARY MID SEAT PER REF. AMM 25-64-00. AIRCRAFT RETURNED TO SERVICE.SDR AALA202510201286Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, FROM RBL 5 TO RBL 15. (RIGHT HAND INBOARD ECS BAY.) REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510201118Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND AFT LAVATORY VENT LOCATED AT BS 917, BETWEEN S21L AND S22L. ACCOMPLISHED SKIN REPAIR PER SRM 53-70-01-2R-3.SDR DXTA2025102005366Wire Harness · defectiveDURING PREFLIGHT FOUND MAIN CABIN DOOR VERY HARD TO OPEN WHEN STARTED UP APU GOT CABIN DOOR OPEN CAS RAN QRH WAS UNABLE TO CLEAR .REPEAT WRITE UP CORRECTIVE ACTION: REPLACED THE CABIN DOOR THRESHOLD HARNESS. PERFORMED CABIN DOOR RESET PROCEDURE. IAW CE-680A AMSDR DXTA2025102005373Pushrod · lack of lubeMAIN DOOR WONT LATCH. RESET PROCEDURE DOES NOT WORK. LUBRICATED PUSHED ROD DECAL ASSEMBLY IA W CE680A AMM 24-00-00 AND USED CE-680A IPC 52-10-10.OPS CHECK GOOD.SDR 2025FA0000726Wire · chafedPILOT REPORTED TR CHIP CT ON WARNING UNIT DURING STARTUP. FLIGHT WAS THEN ABORTED. MX FOUND A CHAFED WIRE ON THE TAIL SECTION THAT CAUSED CONTINUITY TEST TO FAIL. WIRE WAS REPAIRED AND AIRCRAFT WENT BACK IN SERVICE.SDR E0YA2025FA0000081Engine · failedNUMBER 1 ENGINE FAILURE AT FL150. CREW HEARD A BANG, AIRCRAFT YAWED, ENGINE ROLLBACK, NO THRUST AVAILABLE, ITT STARTED TO RISE AND CREW SHUTDOWN. DIVERTED AND LANDED WITHOUT FURTHER ISSUE.SDR FDEA202510192054Skin · ground damageLOADER MADE CONTACT WITH ACFT AFT OF FWD LOWER CARGO DOOR. APROX 3-4 INCH GOUGE IN FUSELAGE. FINAL EA AND FORM 8100-9 HAS BEEN RECIEVED, REPAIR HAS BEEN PERFORMED & INSPECTED IN ABOVE SIGN-OFF IN REF TO EA G-5300-T0385380 PART 1.SDR FDEA202510192053Skin · crackedAFT CARGO COMPARTMENT DOOR UPPER INNER SKIN 2EA CRACKS WERE FOUND AT FR61 - FR62 COMPLIED WITH EA 6-5230-T0385399 P1. TITLE: DOORS - CARGO DOOR/HYD SYS - AFT CARGO DOOR INNER SKINS AND ACTUATOR FITTING AT FR61A - CRACKS, PERMANENT REPAIR. REPAIRED AFT CARGSDR FDEA202510192052Fitting · crackedAFT CARGO COMPARTMENT DOOR ACTUATOR FITTING CRACKEDSDR IXXA20251019001Skin Panel · delaminatedBONDED PANEL ON RIGHT SIDE OF VERTICAL STAB DELAMINTED AT FSS.295SDR ABXA20251019274Battery · faultedDURING TAXI ,APU BATTERY, NO STBY STATUS MESSAGE DISPLAYED. ADVISED BY MTC TO RETURN TO PARKING (BTB). MTX GROUNDED ACFT AND REMOVED AND REPLACED APU BATTERY IAW AMM 24-31-04 AND REMOVED AND REPLACED APU BATTERY CHARGER IAW AMM 24-31-04. OPS CHECK GOOD. ACFSDR SWAA2025102005584Compensator · leakingSUSPECTED FUEL LEAK. ALSO FUEL IMBALANCE RT SIDE FIRST THEN LEFT SIDE. 5.8 AT GATE IN JAX. SUPPOSED TO LAND WITH 6.6 IN MCO. ALSO HAD 6.3 AT GATE IN JAX. IT NOW STATES 5.7? (6.6). NH 30 DAYS. HANGAR REQUEST RECORD #4196<[01] ACCOMPLISHED GVI OF MAIN WING AND CSDR SWAA2025102025701Processor · leakingSUSPECTED FUEL LEAK. ALSO FUEL IMBALANCE RT SIDE FIRST THEN LEFT SIDE. 5.8 AT GATE IN JAX. SUPPOSED TO LAND WITH 6.6 IN MCO. ALSO HAD 6.3 AT GATE IN JAX. IT NOW STATES 5.7 (6.6). NH 30 DAYS. ACCOMPD GVI OF MAIN WING & CENTER TANKS PER AMM 28-11-00; NO LEAKSSDR AALA202601159193Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 967 TO BS 986.5 AT RBL 17. REPLACED INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA202601151511Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM AT BS 967, RBL44. REPAIRED FLOORBEAM IAW EA 369387.SDR AALA202601142879Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR LOWER CUT OUT INNER CHORD (CREASE ANGLE) LOCATED BETWEEN BS 947 AND BS 986.5, AT RBL 45. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202601147590Floor Support · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947, RBL 16. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601140515Floor Support · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947 AND BS 967 AT RBL 54. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601148805Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE CAP AT BS 986, LBL 42. REPAIRED UPPER TEE IAW SRM 53-70-51-2R-4.SDR AALA202601144543Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO SEAL SUPPORT INTERCOSTAL ON AFT PRESSURE BULKHEAD AT BS 1016, FROM LBL 8 TO LBL 30. REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND EA 369993.SDR AALA202601145337Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT BS 986, LBL 31. REPAIRED UPPER TEE IAW SRM 53-70-51-2R-4.SDR SWIA2026011300018Skin · chafedRIGHT INBOARD FLAP LOWER SKIN HAS CHAFING DAMAGE AT THE INBOARD AND OUTBOARD HINGE ARM LOCATIONS FROM CONTACT WITH THE CANOE FAIRINGS. COMPLIED WITH REPAIR OF FLAP IAW REO 690-57-52-559 REV-- AND SRM 57-52-01-201-005-A01. REMOVED AND INSTALLED INNER HINGE ARMSDR SIMA20251018002Light · damagedRH EMERGENCY PHOTOLUMINESCENT LIGHT STRIPS DAMAGED COMPLETE: INSTALLED SERVICEABLE RH EMERGENCY PHOTOLUMINESCENT LIGHT STRIPS IAW AMM 33-50-21SDR SIMA20251018001Floorbeam · corrodedRIGHT FLOORBEAM BETWEEN WALL AND CENTER SEAT TRACK BEAM AT FR84 CORRODED (MAJOR REPAIR). REPAIREDTHE FLOORBEAM IAW ERS-EJ-53MR- 5301.SDR SCNA20251022403SCover · brokenBROKEN COVER OF EXIT EMERGENCY LIGHT OF DOOR R1 & R2. COVERS OF EXIT EMERGENCY LIGHT OF DOOR R1 & R2 WERE REPLACED PER B737-800 AMM 33-51-01, TEST OK.SDR SWIA2025121901018Spar · damagedLEFT AILERON AFT SPAR MOST OUTBOARD BORES ARE OVERSIZED. REPAIRED R/H AILERON AFT SPAR MOST OTBD AND INBD BORE ON WING IAW GREO 601R-57-51-015 REV NC.SDR IPXA2025120741156Skin · puncturedMAJOR REPAIR, DURING CLEAN UP , PUNCTURED INNER FLAP LOWER SKIN INFO SENT TO ENGINEERING ALL STEPS OF EO-95467-REQ4 COMPLETED. THIS IS A PERMANENT REPAIR. THIS DEFERRAL IS NOW CLOSED.SDR AALA202511287314Bottle · defectiveAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 834 DAMPER AND EMERGENCY OPERATION CYLINDER PERCUSION MECHANISM KNURLED SCREW DOES NOT OPERATE CORRECTLY. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14.SDR SWAA2025112625600Light · burned outBURNED SEGMENT WINDOW EMERGENCY LIGHT ON DOOR 833 AT PASSENGER CABIN. REPLACED WINDOW EMERGENCY LIGHT ON DOOR 833 AT PASSENGER CABIN IAW AMM 33-21-00-960-805. PERFORMED OPS TEST. TESTED OK.SDR SWIA202511240180Stringer · damagedWHILE PERFORMING REPAIR ON ELECTRICAL BAY FLOOR AT FS193.00 FOUND STGR.16R HAS ELONGATED HOLES. INSTALLED NEW STR. 16R AT FS193.00 REF CRJ700 SRM 51-42-06-001-001-A01 AND DWG#CC670-33030 REV-B. COMPLIED WITH REO 670-53-11-2201 REV -A DATE 2025-10-30 ALTERNATE SDR SWAA2025112025574Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED BS 867 BTW STR 2R TO STR 3R AT PASSENGER CABIN. REPLACED SUPPORT BRACKET LOCATED BS 867 BTW STR 2R TO STR 3R AT PASSENGER CABIN AND FASTENERS IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02 AND DWG: 146A7901 SHEET: 66 REV ASDR SWAA2025112025586Rib · crackedCRACK INSPAR RIB 120.30 LOCATED 19 INCHES FROM FRONT SPAR LT HORIZONTAL STAB. REPAIRED INSPAR RIB 120.30 LOCATED 19 INCHES FROM FRONT SPAR LT HORIZONTAL STAB IAW SRM 55-10-09-2R-5, REPAIR 5.SDR SWAA2025112025580Rib · crackedCRACKED INSPAR RIB 120.30 LOCATED 36 INCHES FROM FRONT SPAR LT HORIZONTAL STAB. REPAIRED INSPAR RIB 120.30 LOCATED 36 INCHES FROM FRONT SPAR LT HORIZONTAL STAB IAW SRM 55-10-09-2R-5 REPAIR 5.SDR SWAA2025112025597Strap · corrodedCORROSION ON OUTER WING LEADING EDGE LOWER ATTACH STRAP AT OSS 65 RT WING. OBTAINED OK TO INSTALL NUT PLATE ON OUTER WING LEADING EDGE LOWER ATTACH STRAP LOC AT OSS 65 ON RT WING. REPAIRED RH WING - O/B FIXED LEADING EDGE - ATTACH STRAP OUTBOARD - BETWEEN SDR SWAA2025111925577Web · corrodedCORROSION WEB SHIELD LOCATED BTW BS 847 - 867, RBL 22, WL 156. REPLACED WEB SHIELD IAW SRM 51-10-02-0G-0, ITEM 9, DWG 146A0081, SHEET 37, REV-.SDR SWAA2025111925572Nut Plate · crackedCRACK ON RAIL NUT PLATES INTERNAL CAVITY LEADING EDGE LOCATED OFSS569 AT RT WING. REPLACED RAIL NUT PLATES INTERNAL CAVITY LEADING EDGE LOCATED OFSS569 AT RT WING. IAW B737-700 SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG 112A4402 SHEET: 14 REV: - MEASSDR SWAA2025111025528Floorbeam · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA695 AND LBL24.75 PASSENGER CABIN. REPLACED ANGLE FLOOR STRUCTURE LOCATED STA695 AND LBL24.75 PASSENGER CABIN IAW SRM 51-10-02 ITEM 9 AND SRM 51-40-02; DWG 273A9110 SHEET 6 REV: A.SDR SWAA2025111025529Floorbeam · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA695 AND RBL24.75. REPLACED ANGLE FLOOR STRUCTURE LOCATED STA695 AND RBL24.75 PASSENGER CABIN IAW SRM 51-10-02 ITEM 9 AND SRM 51-40-02 DWG 273A9110 SHEET 6 REV: A.SDR SWAA2025111025490Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 271 LT WING. REPLACED ANGLE AND FASTENERS ON TRAILING EDGE LOCATED ORSS 271 LT WING IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 115A2930 SHEET 7 REV - .SDR SWAA2025110725530Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED BS 695, BL0 . REPLACED THE ANGLE IAW SRM 51-40-02, AND DWG 273A9110, SHEET 6, REV A.