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 SWAA2025090397240Bracket · crackedCRACK ON FWD BRACKET ON PANEL 844DZ AT AFT GALLEY SERVICE DOOR. REPLACED FWD BRACKET AND FASTENERS ON PANEL 844DZ AT AFT GALLEY SERVICE DOOR IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 411A2129 SHEET 71 REV -. MEASURE OF CRACK IS: 0.211.SDR SWAA2025090397241Bracket · crackedCRACK ON AFT BRACKET ON PANEL 844DZ AT AFT GALLEY SERVICE DOOR. REPLACED AFT BRACKET AND FASTENERS LOC. ON PANEL 844DZ AT AFT GALLEY SERVICE DOOR I.A.W B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 411A2129 SHEET 71 REV -. MEASURE OF CRACK IS: 0.396.SDR IPXA2025083018631Stringer · crackedMAJOR REPAIR, STRINGER CRACK, FWD SIDE OF BS 1960, S14L. ACCOMPLISHED REPAIR IAW UPS EO-94934-REQ 1, REV 1 AND EI F2025A53M-1722, REV 2.SDR IPXA2025090318377Stringer · crackedMAJOR REPAIR, STRINGER CRACK, FWD AND AFT SIDE OF BS 1960, S11L. PERFORMED EO-94878-REQ1, REV 2, & EI F2025A53M-1842 REV 0, & EGAT WORK SHEET 50607.SDR IPXA2025090125093Pressure Panel · corrodedMAJOR REPAIR. MAIN CABIN AT CENTER WING L/H TUNNEL AT THE PRESSURE PANEL HAS CORROSION. ATA 36-14 CENTER WING UPPER AFT SKIN CORROSION REPAIR BTWN XCW=101.850 AND XCW=110 AT REAR SPAR ACCOMPLISHED IN ACCORDANCE WITH UPS EO-94951-REQ1 REVISION 1 AND VT SAA EASDR FDEA202507311605Fitting · damagedREPLACE MAIN DECK CARGO DOOR ACTUATOR BEARING FITTING AT FRAME 23 PER EO NO:E6- 5230-E0378588 B P5 ACCOMPLISHED THE REPLACEMENT OF BEARING FITTING AT MAIN DECK CARGO DOOR FR23, LONGN1~LONGN3. I.A.W FEDEX EO NO:E6-5230-E0378588 B P5, SEQ NO:1101, TITLE:DOOSDR IPXA2025082718719Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 1960, S24R. PERFORM EO-94933-REQ1, REV 1, AND EI.F2025A53M-1824, REV 1.SDR IPXA2025082723386Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 1140 S-18R (LEVEL2) (REPAIR). ACCOMPLISHED REPAIR I.A.W EO-94923-REQ1 REV.1 AND EGAT EI NO.F2025A53M-1822 REV.1.SDR IPXA2025082621953Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 1960, S15R. PERFORMED EO-94897-REQ 1, REV 1, AND EI F2025A53M-1796, REV 1.SDR IPXA2025082018347Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S10L. PERFORMED EO-94838-REQ 1, REV 1, EI.F2025A53M-1746, REV 0, & EGAT WORK SHEET 50606.SDR IPXA2025081818790Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S19R. REPAIRED DAMAGE AREA IAW EO-94836-REQ 1, REV 2, EGAT EI F2025A53M-1807, REV 0, AND EGAT WORK SHEET 50608.SDR IPXA2025082221928Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S11R. PERFORMED EO-94879-REQ 1, REV 1, EI F2025A53M-1843, REV 0, AND EGAT WORK SHEET 50623.SDR IPXA2025081818515Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S12L. PERFORM EO-94883-REQ 1, REV 1, EI F2025A53M-1805, REV 0, AND EGAT WORK SHEET 50605.SDR AALA202508270326Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ECS BAY HORIZONTAL ANGLE ON AFT BULKHEAD (VAPOR BARRIER) AT BS 663 IS CRACKED AT ATTACH FASTENERS IN COMMON WITH INBOARD VERTICAL KEEL BEAM ANGLE. INSTALLED NEW HORIZONTAL STIFFENER. PER AARD 51-00-05-1, BOEING DWG 111ASDR AALA202508262719Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING AT STR23L AND BTW FR66 TO FR68 AFT GALLEY AREA MEASURE CORROSION ARE L=1.756 INCH W=0.601 INCH D=0.043 INCH. MAINTENANCE REPLACED CENTER FITTING ON LOWER SILL LOC. BTW FR66 TO FR68 STR 23LH AFT GALLEY AREASDR IPXA2025081616076Doubler · crackedDURING PERFORM EO-26856-JIC001 FOUND FASTENER HOLE CRACK AT STA 740 R/H SIDE. REPAIR DAMAGE AREA IAW UPS EO-94857-REQ1 REV.1 2.SDR R61A2025082000359Seat Track · corrodedFWD PAX FLOOR STRUCTURE RH IB SEAT TRACK CORRODED. MX REPLACED IAW SRM 51-41-02, 51-43-02.SDR R61A2025082000355Web · corrodedFORWARD PAX FLOOR STRUCTURE RT FLOOR SHEAR WEB CORRODED. MX REPLACED SILL IAW SRM 51-41-02, 51-43-04.SDR AALA202508201945Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: REPLACE HINGE ARM END FITTING ELEVATOR #6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING ELEVATOR #6 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508200331Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: REPLACE HINGE ARM END FITTING ELEVATOR #4 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING ELEVATOR #4 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508205651Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #3 ON LH HORIZONTAL STABILIZER. MSINTENANCE REPLACED HINGE ARM END FITTING ELEVATOR #3 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508208794Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: REPLACE HINGE ARM END FITTING ELEVATOR #2 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING ELEVATOR #2 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202508206125Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #1 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING ELEVATOR #1 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR SWI2025F01089Bushing · damagedREMOVED THE RH AILERON #3 HINGE ASSEMBLY TO F.O.M. (C-CHECK RO 08/16/2025)COMPLIED WITH REO 601R-57-51-015 REV: NC DATED: AUG-09-1995 AND REO 601R-27-15-001 REV: A DATED: 09-08-95 BY REAMING AND INSTALLING OVERSIZED BUSHINGS AT THE WING TRAILING EDGE RH AILERSDR SWIA2025081800731Hinge Fitting · damagedREMOVED THE RH AILERON #2 HINGE ASSEMBLY TO F.O.M. (C-CHECK RO 08/16/2025)COMPLIED WITH REO 601R-57-51-015 REV: NC DATED: AUG-09-1995 AND REO 601R-27-15-001 REV: A DATED: 09-08-95 BY REAMING AND INSTALLING OVERSIZED BUSHINGS AT THE WING TRAILING EDGE RH AISDR AALA202508184721Cleat · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON FORWARD CARGO COMPARTMENT CLEAT AT FR 35.2 BETWEEN S 39R AND S40R. REPLACED THE CLEAT IAW SRM 51-72-11.SDR IPXA2025081716209Stringer · crackedMAJOR REPAIR, STRINGER CRACK, FWD SIDE OF BS 2360, S7R. REPAIRED DAMAGE AREA IAW SRM 53-60-03-2R-8 REV.46/TR:53-149, EGAT WORK SHEET 50612, EO EO-94715-REQ 1, REV 1, AND EGAT EI F2025A53M-1792 REV 0.SDR IPXA2025081821951Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S10R. PERFORMED EO-94877-REQ 1, REV 1, EI F2025A53M-1804, REV 0, & EGAT WORK SHEET 50622.SDR IPXA2025081818864Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S12R. PERFORMED EO-94840-REQ 1, REV 1, EI F2025A53M-1806, REV 0, AND EGAT WORK SHEET 50609.SDR REXA2025081800818Support · crackedREPLACE AFT MOUNT SUPPORT WITH PREVIUSLY CRACK AFT MOUNT SUPPORT WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01, SB 670BA-28-038 REV. B AND EO # R28007A REV. 3SDR AALA202508189668Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED AT BS 980, LBL 47. REPLACED CHORD PER AARD 51-00-05-1.SDR IPXA2025081516159Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 2360, S9L. PERFORMED EO-94716-REQ 1, REV 1, EI F2025A53M-1777, REV 0, AND EGAT WORK SHEET 50611.SDR IPXA2025081524093Pressure Panel · corrodedMAIN CABIN AT CENTER WING L/H TUNNEL AT THE PRESSURE PANEL HAS CORROSION. VERIFIED STEP 7 C/W IAW UPS RII GMM 04-02.SDR 3EJA202508150009Warning Light · illuminatedAT INITIAL TAKEOFF/CLIMB OUT AND MOVING THE GEAR HANDLE UP, THE RED UNLOCK LIGHT REMAINED ILLUMINATED. AT FRA WE BROUGHT THE FLAPS UP AND SOON AFTER GOT A STAB MIS COMPARE AND HYD PRESSURE LIGHT ILLUMINATE. PERFORMED GEAR SWINGS AND OTHER OPERATIONAL TESTS CNSDR ASAA2025073160070Web · corrodedAFT CARGO DOOR CUTOUT, SUB SCUFF PLATE STRUCTURE HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION AT AFT CARGO DOOR CUTOUT WEB, FOUND TO BE OUT OF LIMITS. ORIGINAL MAT. THICKNESS IS .050, MAT. LOSS .008, MAT. REMAINING IS .042 IAW B737-900ER SRM 53-60SDR AALA202508130934Chiller · failedAIRCRAFT WAS NOT GROUNDED: AFTER GALLEY CHILLER POWER CYCLING ON AND OFF AND NOT COOLING; FLIGHT ATTENDANTS SUSPECTED SLIGHT ELECTRICAL SMELL AND TURNED OFF CHILLER AND LEFT IT OFF. NO SMOKE OR PERSISTENT SMELL WAS REPORTED. MAINTENANCE REPLACED CHILLER AND ASDR AALA202508121600Vapor Barrier · tornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AIR CONDITIONING BAY WHEEL WELL VAPOR BARRIER. REPAIR MATERIAL ON AFT SIDE OF VAPOR BARRIER IS DISBONDED AND TORN. REMOVED DISBONDED AND TORN REPAIR MATERIAL ON AFT SIDE OF VAPOR BARRIER. INSTALLED NEW REPAIR. PER AARDSDR SWAA2025081197274Skin · debondedRIGHT WING INBD AFT FLAP OUTER SURFACE IS DISBONDED 4' FROM I/B SIDE AND 8' FROM T/E. INBOARD AFT FLAP INSTALLATION COMPLETE IAW AMM 27-51-12-400-801. REMOVED AND REPLACED R/W I/B AFT FLAP AND ADJUSTMENTS ACCOMPLISHED SATISFACTORY IAW AMM 27-51-12-000-801 AND SDR AALA202508118430Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED FORWARD GIRT BAR TIEDOWN AT BS 312, LBL 54. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202508117456Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 58. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR IXXA20250809008Fuel Panel · puncturedCENTER TANK FUEL PANEL 134FZ WAS PUNCTURED. REPAIR WAS ACCOMPLISHED PER FVCI EO# 25143-9 REV. A & B767-300 GRM 51-70-10-2R-2 REPAIR 2SDR JJBA20250808019Shear Tie · crackedSHEAR CLIP AT FR 68 AND BTW STR 6L-9L FOUND CRACKED. AT FR68 AND BTW STR 6L-9L SHEAR CLIP REMOVED AND INSTALLED.SDR CALA2025080807489Structure · corrodedAFT WET AREA. EXFOLIATION CORROSION ON SEVERAL SPOTS OF RT INNER CHORD BETWEEN BS 947.5 -1006. REMOVED AND REPLACED INNER CHORD AT RT AFT WET AREA BETWEEN STA 890 TO STA 1006 PER SRM 51-40-02-0G-0, 51-40-03-0G-0 AND DWGS 147A8501, 147A0004.SDR AALA202508070309Casting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR HANDLE CASTING FROM BS 300 TO BS 328. REPLACED CASTING PER SRM 52-10-02-0G.SDR AALA202508063158Support Bracket · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FLAP INTERCONNECT STRUT HAS EVIDENCE OF CORROSION AND GOUGING ON AFT SIDE OF INNER CYLINDER ALONG WITH WITH EXCESSIVE PLAY DUE TO THE ATTACHMENT / SUPPORT BRACKET BEING WORN FOR THE INTERCONNECTING STRUT. REPLACED INTESDR AALA202508065348Strut · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FLAP INTERCONNECT STRUT HAS EVIDENCE OF CORROSION AND GOUGING ON AFT SIDE OF INNER CYLINDER ALONG WITH WITH EXCESSIVE PLAY DUE TO THE ATTACHMENT / SUPPORT BRACKET BEING WORN FOR THE INTERCONNECTING STRUT. REPLACED INTESDR AALA202508066645Hinge · damagedAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY-E DOOR IS DIFFICULT TO OPEN AND CLOSE. REMOVED AND REPLACED DOOR HINGE. PER CMM 25-40-65.SDR DALA2025080505881Pinion Gear · corrodedLEFT PINION NR 4 TEETH, NR 1 & 2 HAD EVIDENCE OF CORROSION, LOWER SURFACE & PREVIOUS REWORK IAW ER/A 622578-14AD, REV A. LIAISON ENGINEERING REQUIRED BEFORE FURTHER FLIGHT . COMPLIED WITH ERA 622578-14AD, REV B, SEC 2, & 4. PRI 622578-14AD, REV 0 MATCHES.SDR DALA2025080505880Power Supply · faultedEMERGENCY LIGHTS FAULT, LT OVERWING EED DOOR FAULT ON CMS PANEL. REMOVED CEILING PANEL FOR EPSU 3 & 4. REPLACED EPSU 3 IAW AMP 33-51-01. FAULT CODE 3351F0006 PRESENT ON OMS CURRENT FAULTS. EMERGENCY LIGHTS OPS NORMAL BUT FAULT STILL PRESENT ON CMS. BATTERSDR DALA2025080505879Skin · corrodedLOWER FWD WTBF AT LWR FUSELAGE 6 INCHES AFT OF DRAIN FRAMES 34 - 35, S36R - 36L HAD SIGNS OF CORROSION. REMOVED CORROSION ON LOWER SKIN, FOUND OUT OF LIMITS IAW ASRP J51-21-06, J53-31-01. PERFORMED SKIN REPAIR IAW ERA 627451-14 REV ORIGINAL ASSOCIATED ER/A 1