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 CALA2025073107121Unknown · odorELECTRICAL BURNING SMELL THROUGHOUT CABIN AT DECENT. WENT AWAY O N ITS OWN AFTER FEW MIN. REF FIM 21-00 TASK 806. INSPECTED CABIN IFE EQUIPMENT, NO DEFECTS NOTED. RAN BOTH ENGINES AND PACKS, NO ABNORMAL SMELLS DETECTED. ACFT OK TO CONT.SDR CALA2025073107119Unknown · odorFA REPORT SMELL OF DIRTY FEET OR VINAGER IN AFT CABIN. PERFORMED VISUAL INSPECTION OF AFT CABIN & GALLEY, CHECKED CARGO BAYS, AND OPERATED LT & RT PACKS. NO EVIDENCE OF SPILLS AND NO ODORS FROM LT & RT PACKS. AIRCRAFT OK TO CONTINUE SERVICE. REF AMM TASK 0SDR CALA2025073107116Transceiver · failedRADIO TRANSMIT ON ICAS OBSERVED NO AUDIO FROM HF RIGHT. CREW REQUESTED MAINTENANCE UPON ARRIVAL. WHILE EICAS MESSAGE WAS PRESENT CREW REPORTED ELECTRICAL SMELL IN COCKPIT IN THE VECINITY OF THE CENTER CONTROL STAND NEAR AUDIO CONTROL PANELS. WHEN MESSAGE WENTSDR CALA2025073107114Connector · mispinnedEMERGENCY LIGHTS OPS CHECK. RT, AFT OVERWING INTERIOR EMERGENCY LIGHT INOPERATIVE FROM FLT DECK OR AFT ATTENDANTS PANEL. COMES ON WITH WINDOW LIGHT SWITCH AT FWD ATTENDANT PANEL. WINDOW LIGHT AT 21FED OPERATES WITH CABIN LIGHT ON FULL BRIGHT. DOES NOT OPERASDR HNAA2025073100474Dau · failedAT 33000 FEET UNTIL 20000 ELECTRICAL BURNING FUMES CAUSING LIGHT HEADEDNESS IN FLIGHT DECK. INSPECTED AND FOUND NR 200 DAU INOPERATIVE. R & R NR 200 DAU IAW AMM 31-41-01-000-801-A AND 31-41-01-400-801-A. OPS CHECK GOOD. NO SMELLS NOTED AT THIS TIME. OK FOR SSDR MASA2025072200060Sensor · failedLG WOW SYS FAIL - RETURN TO FIELD - FOUND STRUT TO REQUIRE SERVICING, WOW SENSORS AND TARGETS WERE NOT LINED UP DUE TO LOW NLG STRUT N2.SDR SWAA2025073096647Trim System · faultedSTAB TRIM INOPERATIVE. PERFORMED STAB TRIM MOTOR A/P TEST IAW AMM 22-11-81-710-801, AS WELL AS STAB TRIM MOTOR TEST IAW AMM 27-41-71-700-801. BOTH TESTS CHECKED GOOD.SDR IXXA20250730003Skin · crackedCRACK INDICATION IN THE 2ND HOLE FROM THE BOTTOM AT FORWARD ENTRY DOOR LOWER AFT CORNER, SKIN LAYERSDR IXXA20250730002Skin · crackedCRACK INDICATION IN THE 2ND HOLE FROM THE BOTTOM AT FORWARD SERVICE DOOR LOWER AFT CORNER, SKIN LAYERSDR HNAA2025073000473Hot Water Pot · odorELECTRICAL BURNING SMELL FROM HOT JUG AREA OF GALLEY. INSPECTED & FOUND OUTER CONNECTOR DETERIATED. R & R HOTJUG CONNECTOR IRT SB145-25-202. HOTJUG MISSING INSTALLED HOTJUG.OPS CHECK GOOD.OK FOR SERVICE AT THIS TIME.SDR UIEA2025073001068Battery · faultedDURING DAILY CHECK, FOUND LT EMERGENCY ESCAPE SQUIB TEST BAD. REMOVED AND REPLACED LT EMERGENCY OFF WING BATTERY IAW AMM 25-65-17-404-008-001 & AIPC 25-67-17-10A. OPS CHK GOOD.SDR IXXA20250730001Support Fitting · crackedLH FWD WTB AFT OF ACCESS 191AL PANEL SUPPORT FITTING IS CRACKEDSDR DALA2025073005718Bottle · low pressureSHIP 3410 DOOR PRESSURE INDICATOR ILLUMINATED AT 4L. SERVICED DOOR BOTTLE PER A330 AMM 52-15. (1114108)SDR AALA202507302316Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT AISLE EMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 11, 12 AND 13. MAINTENANCE FOUND CANNON PLUG FOR EMERGENCY LIGHTS ON ROWS 11-13 DISCONNECTED, MAINTENANCE RECONNECTED CANNON PLUG AND ACCOMPLISHED A SATISFACTORY OPERATIOSDR CALA2025073007107Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK M2335 REQUIRES REPLACEMENT. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M2335 IAW AMM 33-51-06. PERFORMED EMERGENCY LIGHTS-OPERATIONAL TEST IAW AMM 33-51-00-710-801. OPS CHECK GOOD/TEST PASSED.SDR FDEA202507301342Skin · dentedRIGHT HORIZONTAL STAB. UPPER SKIN WITH DENT BETWEEN STAB STA 104.248 AND STA 152.248 AND BETWEEN FRONT . SPAR AND AUX SPAR. EVALUATED DENT ON RH HORIZONTAL STAB UPPER SKIN BETWEEN STAB STA 104.248 - 152.248 AND BETWEEN FRONT SPAR & AUX SPAR FOUND THE FOLLWSDR FDEA202507301341Floor Panel · damagedMAIN CARGO COMP. AT APROX STA. 350 & RBL54.75 TO RBL77.5 FLOORBOARD PANEL 222CFF SURFACE SKIN HAS INDENTATIONS (MARKED) FABRICATED NEW FLOOR PANEL 222CFF, MPN:141T5856-166, RBL 77.5 RBL 54.75, STATION 285-412 IN REF TO BOEING DWG 141T5856-116. SEE JPF FORSDR FDEA202507301340Power Unit · faultedEMER PWR TST FAIL LEVEL 1 ALERT ILLUMINATED. PER QRH, TURNED EMER PWR SWITCH OFF AND WAITED FOR BAT CHARGING MESSAGE TO GO OUT, THEN TURNED EMER PWR SWITCH ON AND ALL APPEARED NORMAL, UNTIL APU PWR DROPPED OFFLINE AGAIN AND EMER PWR ON LEVEL 1 ALERT ILLUMSDR FDEA202507301339Control Valve · faultedON SELECTING FLAPS 25 AT ABOUT 155 KIAS, T/E LIGHT ILLUMINATED & EICAS DISPLAYED MESSAGE TE FLAP DISAGREE. RAN QRH FOR T/E FLAP DISAGREE & LANDED 20 FLAPS USING ALTER SYS IAW QRH. EMERGENCY DECLARED. PERFORMED GVI OF RH IB XMSSN DRAINED & REFILLED FLUID IAWSDR SWIA2025072975148Stand Off · crackedL/H UPPER TRANSCOWL INBD "A" BRACKET STANDOFF IS CRACKED (C-CHECK RO 02/01/2026)REMOVED CRACKED INBD "A" BRACKET STANDOFF FROM L/H UPPER TRANSCOW AND INSTALLED 1 EA NEW INBD "A" BRACKET STANDOFF (WAS P/N CN624-2082-201, IS NOW P/N CN624-2082-S1401) ON L/H SDR SWIA2025072975147Rivet · shearedLEFT LWR TRANSCOWL ZEE STIFFENER RIVETS ARE SHEARED. LT LWR TRANSCOWL ZEE STIFFENER HAS BEEN RE-INSTALLED REF REO# 690-54-21-586, REV --, DATED 8/18/25. SEE CONTINUATION SHEET FOR DETAILS. COMPLIED W/SKYCARD 51-900-1002-SKY.SDR SWIA2025072975131Stiffener · looseR/H LWR TRANSCOWL Z STIFFENER RIVETS ARE SHEARED (C-CHECK RO 02/01/2026)REPLACED SHEARED RIVETS ON THE Z STIFFENER AND REPAIRED UNDERLYING CRACKS IN THE INNER PERFORATED SKIN ON THE R/H LOWER TRANSCOWL REF MHIRJ REO #690-54-21-582 REV (--) 2025-08-04 STEPS 1-SDR SWIA2025072975130Latch · chafedR/H UPPER TRANSCOWL INNER COAMING IS CHAFED @ FWD LATCH (C-CHECK RO 02/01/2026)REPAIRED R/H UPPER TRANSCOWL, REF. REO 690-54-21-583, REV. --, 2025-08-14, ALL STEPS COMPLIED WITH. COMPLIED WITH M-337 AND SKYCARD 51-900-1002-SKYSDR SWIA2025072975129Stand Off · crackedRIGHT UPPER TRANSCOWL INBD "A" BRACKET STANDOFF IS CRACKED (C-CHECK RO 02/01/2026)REMOVED AND REPLACED I/B STAND-OFF ANGLE P/N CN624-2082-201 ON R/H UPPER TRANSCOWL, REF. REO 670-54-21-971, REV. B, 2023-11-28. COMPLIED WITH MAJOR REPAIR M-337 AND SKY CARD 51SDR SWI2025F01819Frame · no discrepancySTRUCTURES ACCESS FOR STRINGER 23R BETWEEN BS 333 TO 379. REMOVED AND REINSTALLED FRAME AT BS 333 STRINGER 25R IAW SRM 53-00-06-201-006-A01, 51-42-21-001-001-A01, AND 51-42-06-001-001-A01, REV 38SDR SWIA2025120900729Former · corrodedPAX DOOR FORMER,FS329.41, BETWEEN DD5 AND DD6 FOUND BE CORRODED REQUIRE REPLACEMENT (C-CHECK RO 12/09/2025)INSTALLED PAX DOOR NEW SERVICEABLE FORMER PN 601R318078-3 AT FS 329.41 IAW CRJ 550 SRM 51-42-06-001-001-A01 AND 51-40-11-001-001-A01 REV 38 JUL 25/202SDR SWIA20250729Stringer · corrodedCORROSION FOUND UNDER BRACKET ON STR 20R, 6 INCHES AFT OF FS280. REMOVED AND REPLACED DAMAGED STR SECTION FROM FS 280 TO FS 300 STR 20R.PEFORMED ANGLE SPLICE REPAIR AT FS 300 STR 20 IN REF TO CRJ 900 SRM 53-00-03-201-001-A01 FIG. 53-00-03--95-806 SOLUTION 1.CSDR JJBA20251024077Frame · crackedZONE 231 FOUND CRACK AT FRAME 20. REMOVED AND REPLACED STRINGER 3L-SHEAR CLIP FITTING AT FRAME 20.SDR JJBA20251024072Door Frame · corrodedZONE 132, 232, AND 234 FOUND CORROSION AT THE RH SILL SERVICE DOOR AT FRAMES 20 AND 22. REMOVED AND REPLACED RH SILL SERVICE DOOR LOWER FRAME BETWEEN FRAME 20 AND 22.SDR AALA202510144463Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON CORNER FITTING LOCATED AT PRESSURE DECK MENBRANE ON FR36 LH SIDE, CRACK DEPTH IS 0.147 INCH. MAINTENANCE REPLACED CORNER FITTING LOC. AT PRESSURE DECK MENBRANE ON FR36 LH SIDE IAW A319 SRM 51-42-11-801 AND DWG D57130101.SDR REXA2025100600907Splice Angle · corrodedUPON REMOVAL OF BOTH LATCH PIN INTERCOSTALS AT STGR 27 FOUND CORROSION ON ATTACHED FLANGE OF FS364 BL0. REMOVED AND REPLACED BROKEN SPLICE (SP124) (P/N: M81714/12-20D-2) (P/N: M39029/1-101) IAW CRJ 700 ESPM 20-44-09 AND IAW CRJ 700 ESPM 20-16-43, OPERATIONAL SDR 9WGA2025092354669Panel · corrodedCENTER WING UPPER PANEL CORRODED AT RH APPROX STA 1229, XCW 96.0 AT S-15. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT RH CENTER WING UPPER PANEL APPROX STA 1229, XCW 96.SDR 9WGA2025092354668Panel · corrodedDURING HEAVY MAINTENANCE CENTER UPPER PANEL CORRODED AT RH APPROX STA 1233, XCW 76.5 AT S-14. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT RH APPROX STA 1233, XCW 76.5 AT S-14, BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MD-11, MSDR 9WGA2025092354667Panel · corrodedCENTER UPPER PANEL CORRODED AT LH APPROX STA 1205, XCW 7.0 S-18. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT LH APPROX STA 1205, XCW 7.0 AT S-18, BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MD-11, MESSAGE: WGN-WGN-25-0035-4C. SDR 9WGA2025090954650Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT RH APPROX STA 1229, XCW 96.0 AT S-15. AFTER FURTHER EVALUATION BOEING CERTIFIED THE BLENDED OUT AREA AS A PERMANENT REPAIR AND BEEN COMPLETED WITH ALL THE REQUESTED PROVISIONS AT RH CENTER WINSDR 9WGA2025090954649Panel · corrodedDURING HEAVY MAINTENANCE CHECK CENTER WING UPPER PANEL CORRODED AT RH APPROX STA 1233, XCW 76.5 AT S-14. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT RH APPROX STA 1233, XCW 76.5 AT S-14, BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR ISDR 9WGA2025090954648Panel · corrodedDURING HEAVY MAINTENENACE CHECK CENTER WING UPPER PANEL CORRDODED AT LH APPROX STA 1205, XCW 7.0 S-18. AFTER FURTHER EVALUATION OF BLENDED OUT AREA AT LH APPROX STA 1205, XCW 7.0AT S-18, BOEING FOUND BLENDED OUT LOCATION ACCEPTABLE AS A PERMANENT REPAIR IAW MSDR IPXA2025090573177Battery · malfunctionedREMOVE EMERGENCY LIGHT BATTERY 3 EA FOR PREVENT BATTERY DISCHARGER. IAW AMM 33-51-04-900-803 REV.48, REPLACED EMERGENCY LIGHT BATTERY M5170. IAW AMM 33-51-04-900-803 REV.48 PERFORMED EMERGENCY LIGHT BATTERY INSTALLATION TEST, RESULT WAS SATISFACTORY.SDR SWAA2025090496345Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS440 TO BS500 LBL24 WL156 AT FWD CARGO COMPARTMENT. REPLACED SUPPORT ZEE AND FASTENERS LOCATED BTW BS400 TO BS500D LBL24 WL156 AT FWD CARGO COMPARTMENT I.A.W SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 143A7500; SHEET 71; RESDR SWAA2025090496529Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS500 TO BS500A LBL24 AT FWD CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL LOCATED BTW BS500 TO BS500A LBL24 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7505; SHEET 81; REV -.SDR SWAA2025090496531Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS500A TO BS500D RBL24 WL156 AT FWD CARGO COMPARTMENT. REPLACED SUPPORT ZEE AND FASTENERS LOCATED BTW BS500A TO BS500D RBL24 WL156 AT FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 143A7500; SHEESDR SWAA2025090396347Bracket · crackedCRACK SUPPORT BRACKET ON PNEUMATIC DUCT BS 540 AND LBL 6 AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET ON PNEUMATIC DUCT BS 540 AND LBL 6 AIR CONDITIONING BAY IAW B737-700 DWG 212A1101-1E REV:- AND SRM 51-40-02-0G-0 AND MEASURE CRACK IS 1.150.SDR SWAA2025090396530Web · corrodedCORROSION WEB LOCATED BTW BS500 TO BS500A RBL24 WL156 AT FWD CARGO COMPARTMENT. REPLACED WEB LOCATED BTW BS500 TO BS500A RBL24 WL156 AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, AND DWG 143A0080 SHEET:23 REV - .SDR SWAA2025090396346Angle · crackedCRACKED ANGLE LOCATED BS400 LBL24 AT FWD CARGO COMPARTMENT. REPLACED ANGLE LOCATED BS400 LBL24 AT FWD CARGO COMPARTMENT IAW SRM 51-10-02 ITEM 9 AND INSTALLED FASTENERS IAW SRM 51-40-02 AND DRAWING # 143A7505; SHEET 81; REV -.SDR FDEA202507291604Fitting · crackedTHE MDCD BEARING FITTING AT FR24 WAS FOUND CRACK ACCOMPLISHED THE REPLACEMENT OF BEARING FITTING AT MAIN DECK CARGO DOOR FR24, LONGN 1 ~ LONGN 3. I.A.W FEDEX EO NO:E6-5230-E0378588B P5, SEQ NO:1101, TITLE:DOORS - CARGO DOOR /HYD SYS -DETAILED VISUAL INSPSDR 2025FA0000592Bushing · looseRIGHT MAIN GEAR ATTACH BUSHING P/N 0541202-4 LINER BECAME DISBONDED CREATING PLAY IN THE GEAR LEG. THIS AIRCRAFT IS OUTSIDE THE S.N. RANGE OF SEL-32-08 YET HAS THE SAME PROBLEM.SDR IPXA2025082973323Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 1740, S42L. PERFORM EO-94931-REQ1 REV.1 AND EI NO.F2025A53M-1810 REV.1 2. JOB COMPLETED.SDR REXA2025082900843Frame · corrodedFRAME BS 319.70 LT IS CORRODED BETWEEN S20L AND S21L. REMOVED FRAME IAW SRM 51-42-06-001-001-A01. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01, ORIGINAL THICKNESS 0.050", REMAINING THICKNESS 0.036" DAMAGE IS OUT OF LIMITS, FRAME REQUIRES REPLACEMENT. DRILSDR IPXA2025082873361Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180, S35R. PERFORM EO-94926-REQ1 REV.1 AND EI F2025A53M-1729, REV.2 2.SDR REXA2025082200827Angle · corrodedAFT BELLY FAIRNG SUPPORT STRUCTURE F.S.881 IS CORRODED AT STGR 27. REMOVED CORROSION FROM AFT BELLY FAIRNG SUPPORT STRUCTURE BS 881 AT S27 IAW SRM 51-21-06-001-001-A01 PER SRM 53-82-55-101-001-A02 ANGLE IS OUT OF LIMITS ON MULTIPLE ELEMENTS & REQUIRES ENGINEER