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 2025FA0000643Servo · contaminatedAIRCRAFT DIED IN RUNUP AREA TWICE. ONCE ON RAMP, ONCE IN RUNUP. FAILED IDLE CHECK. FUEL SERVO WAS REMOVED AND FOUND TO BE CONTAMINATED. REPLACED WITH NEW.SDR HNAA2025091400627Floor Support · corrodedLAV R/H FLOOR SUPPORT IS CORRODED. R&R LAV R/H FLOOR SUPPORT IAW EMB 145 SRM 51-40-02.SDR HNAA2025091100617Seat Track · corrodedLH CENTER SEAT TRACK #2 HAS GOUGES AND CORROSION IN NUMEROUS AREAS ALONG ENTIRE LENGTH. R&R LH ENTER SEAT TRACK #2 IAW EMB 145 AMM 53-01-06.SDR HNAA2025091100614Seat Track · corrodedRH CENTER SEAT TRACK #1 HAS GOUGES AND CORROSION IN NUMEROUS AREAS ALONG ENTIRE LENGTH. R&R RH CENTER SEAT TRACK #1 IAW EMB 145 AMM 53-01-06.SDR HNAA2025091100609Skin · crackedREAR FUSELAGE 2, SKIN AT FR78 AND BETWEEN STGR 6R-7R AROUND A RIVET HEAD HAS A POSSIBLE CRACK. INSTALLED REPAIR BUSHING ON REAR FUSELAGE 2 SKIN AT FR78 AND BTWEEN STGR 6R/7R IAW EMB 145 SRM 53-32-01 STEP 9 (I) AND PIEDMONT EO1-53-25-0385.SDR HNAA2025091100608Skin · crackedREAR FUSELAGE 2 SKIN AT FR77 AND BETWEEN STGR 6R 7R AROUND A RIVET HEAD HAS A POSSIBILITY CRACK. INSTALLED REPAIR BUSHING ON REAR FUSELAGE 2 SKIN AT FR77 AND BETWEEN STGR 6R-7R IAW EMB 145 SRM 53-32-01 STEP 9 (I) AND PIEDMONT EO1-53-25-0285.SDR HNAA2025091100607Skin · crackedREAR FUSELAGE 2, SKIN AT FR77 AND BETWEEN STGR 5R/6R AROUND A RIVET HEAD HAS A POSSIBLE CRACK. INSTALLED REPAIR BUSHING ON REAR FUSELAGE 2, SKIN AT FR77 AND BETWEEN STGR 3R/4R IAW EMB 145 SRM 53-32-01 STEP 9 (I) AND PIEDMONT EO1-53-25-0285.SDR IPXA2025090913704Floorbeam · damagedMAIN DECK-RT SIDE FR51 CROSSBEAM BENT (Y-953 TO Y-450)-109 VWV 91195430 ACCOMPLISHED JOB IAW SREO-75878-REQ001 ((APPX B) TASK CARD:T3F18E007A68T.SDR CALA2025090808603Skin · crackedCRACK FOUND AT LEFT HORIZONTAL STAB LOWER SKIN AT HSS 147.90, INBD ROW. CRACK LENGTH : 1". ACCOMPLISHED PERMANENT REPAIR CATEGORY B AT LT HORIZONTAL STAB LOWER INSPAR SKIN AT HSS 147.90 IAW SRM 55-10-01-2R-11, REPAIR 11 FIGURE 204 DETAIL B.SDR CALA2025090808598Skin · crackedCRACKS FOUND AT RIGHT HORIZONTAL STAB LOWER SKIN AT HSS 175.50, 10" FROM FRONT SPAR, INBB ROW. CRACK LENGTH: 0.343". ACCOMPLISHED PERMANENT REPAIR CATEGORY B IAW SRM 55-10-01-2R-11 REPAIR 11 FIGURE 204 DETAIL B.SDR CALA2025090808561Channel · corrodedFWD CARGO FLOOR STRUCTURE; LT ZEE CHANNEL BS 500C & 500I, DUE TO EXESSIVE CORROSION NEED REMOVE AND REPLACE. REMOVED, LOCATED, DRILLED, COUNTERSINK & INSTALLED LT ZEE CHANNEL IN FWD CARGO FLOOR STRUCTURE BS 500C & 500I IAW SRM 51-00-53-2R-6 51-40-05-0G-0, SSDR R61A2025090500379Floor Support · corrodedDURING HEAVY CHECK FOUND CF I FWD WET AREA FLOOR STRUCTURE FR 19 LBL46 FITTING SUPPORT FOUND CORRODED. REMOVED AND REPLACE SUPORT FITTING IAW SRM 51-43--03SDR R61A2025090500378Support Bracket · corrodedDURING HEAVY CHECK FOUND CF III FR80 STR26R CORRODED SUPPORT BRACKET. REMOVED AND REPLACED SUPPORT BRACKET IAW SRM 51-41-02 AND 51-43-03SDR R61A2025090500377Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR86 STR28R-29R CORRODED SHEAR CLIP. REMOVE AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500376Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR86 STR27R-28R CORRODED SHEAR CLIP. REMOVE AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500375Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR86 STR26R-27R CORRODED SHEAR CLIP. REMOVE AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500374Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR79 STR28L-29L CORRODED SHEAR CLIP. REMOVE AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500373Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR75 STR28L-29L CORRODED SHEAR CLIP. REMOVE AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500372Shear Tie · corrodedDURING HEAVY CHECK FOUND CF III FR88 STR27R -28R SHEAR CLIP CORRODED. REMOVED AND REPLACED SHEAR CLIP IAW SRM 51-41-01AND 51-41-02SDR R61A2025090500371Floor Support · corrodedDURING HEAVY CHECK FOUND CF III FR83-84 LBL40 FLOOR PANEL SUPPORT CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PANEL IAW SRM 51-41-01SDR R61A2025090500370Floor Support · corrodedDURING HEAVY CHECK FOUND CF III FR83-84 RBL40 FLOOR PANEL SUPPORT CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PANEL IAW SRM 51-41-01SDR R61A2025090500369Floor Support · corrodedDURING HEAVY CHECK FOUND CF III FR84 RBL30 FLOOR SPLICE PLATE FOUND CORRODED. REMOVED AND REPLACED FLOOR SPLICE IAW SRM 51-43-03.SDR R61A2025090500368Hinge · corrodedDURING HEAVY CHECK FOUND CF III WASTE ACCESS DOOR HINGE FOUND CORRODED. REMOVED AND REPLACED WASTE ACCESS DOOR HINGE IAW SRM51-41-01 AND 51-41-02SDR DALA2025090406561Repair · crackedLEFT WING, LOWER SURFACE, LOWER FLAP BRACE DOUBLER AT XRS 164 HAS A CRACK IN TIME LIMITED REPAIR. REPAIRED LOWER WING SKIN AND SPAR PER ERA 626343-14AD (1158212).SDR JJBA20250904005Fitting · crackedON BAGGAGE DOOR LIFTING AND LOWERING MECHANISM, FWD AND AFT SUPPORTS FOUND WITH CRACKS. BAGGAGE DOOR LIFTING AND LOWERING MECHANISM REMOVED FOR ACCESS. ON BAGGAGE DOOR LIFTING AND LOWERING MECHANISM FWD SUPPORT ANGLE REMOVED FOR REPLACEMENT. ON BAGGE DOOR LIFTSDR ASAA2025082260441Light · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT ESCAPE LIGHT L7 INOPERATIVE. GROUNDED - YES. REMOVED AND REPLACED AFT RT OVERWING EMERGENCY LIGHT ASSY, OPS CHECK GOOD IAW AMM 33-51-04.SDR SWAA2025090207097Panel · crackedPANEL 521ZB FWD O/B CORNER CRACKED. REPAIRED PER SRM 51-70-05-2R-6-D00323, REPAIR 6.SDR R61A2025090200379Stringer · corrodedAFT CARGO STRINGER 29R AT FR 79-81 IS CORRODED. REPAIRED AFT CARGO STRINGER 29R AT FR79-81 PER ETD2025-170-926612 REV A.SDR CALA2025090208387Skin · dentedUPPER FUSELAGE DENT APROX .5" FWD OF FR 12 & 1" ABOVE STGR 1L. PERFORMED A DOUBLER REPAIR TO EXTERNAL SKIN AT LOCATION OF DAMAGE FR12 STRG 1L IAW SRM 53-11-11-300-054. THIS IS A CATEGORY B REPAIR.SDR 2025FA0000599Servo · contaminatedFUEL SERVO FOUND TO HAVE ENGINE OIL CONTAMINATION.SDR AALA202508298422Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508295702Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 57 AT S38L. REPAIRED STRINGER PER EA 367166.SDR AALA202508298597Tee Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON EMERGENCY EXIT DOOR SLIDE ENCLOUSURE INTERNAL STRUCTURE TEE ANGLE FITTING BETWEEN FR 35.1 AND FR 35.2A AT S28L. REPLACED TEE ANGLE FITTING PER SRM 51-72-11.SDR AALA202508295998Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, FROM RBL 12 TO RBL 36, RIGHT HAND ECS BAY AFT BULKHEAD UPPER INBOUND AND OUTBOUND SIDE. REPAIRED PER SRM 57-10-10-2R-5.SDR ASAA2025082260397Battery · inoperativeEMERGENCY LIGHTS COMMON TO POWER SUPPLY M1694 ARE INOP. GROUNDED - YES. REMOVED AND REPLACED BATTERY IN POWER SUPPLY M1694 IAW AMM 33-51-06-960-805. OPS CHECK GOOD IAW AMM 33-51-06-960-805.SDR CALA2025082808229B-Nut · leakingSMOKE AND FUMES DETECTED IN MID CABIN AREA, DUE TO SMOKE AND FUMES REPORTED IN CABIN. GATE RETURN, CREW REPORTED ELECTRICAL OR RUBBER ODOR & HAZE IN CABIN BETWEEN DOORS 2R AND 3R ON TAXI ACCOMPLISHED AMM 05-51-58-800-801-C3 THROUGH STEP 2(F) OF INITIAL OPSDR I5PA2025082219301Starter · failedAPU STARTER FAILED. R & R APU STARTER PER AMM.SDR ASAA2025082260298Door · lack of lubeFA REPORTS L1 DOOR IS DIFFICULT TO OPEN DOES NOT OPEN SMOOTHLY. GROUNDED - YES. PERFORMED DOOR HANDLE TORQUE TEST PER AMM 52-11-00 OPS CHECK NORMAL CLEANED AND LUBED L1 DOOR AS REQ.SDR SWAA2025082607478Cover · detachedWHITE COVER ON EXIT LIGHT IN AFT GALLEY CAME OFF. RESECURED L2 DOOR EMERGENCY EXIT LIGHT COVER PER AMM 33-51-01.SDR SWAA2025082607233Bulb · inoperativeL2 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED L2 SERVICE DOOR EMERGENCY LIGHT BULB PER AMM 33-51-04. OPS CHECK GOOD.SDR SWAA2025082607230Battery Pack · inoperativeBOTH LT OVERWING EXIT SIGNS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06.SDR SWAA2025082607221Skin · delaminatedTRAILING EDGE LT OTBD AFT FLAP, INBD SIDE, SKIN DELAMINATION ON LOWER SKIN. REMOVED DAMAGE, FABRICATED REPAIR IAW SRM 57-53-01-2R-14, & SRM 51-70-10-2R-4, REPAIR 4, REMOVED OTBD AFT FLAP IB SEAL IAW CMM 57-53-08. INSTALLED REPAIR & BAGGED AND COOKED IASDR SWAA2025082607491Retainer · out of adjustCREW REPORTS GIRT BAR TOO TIGHT IN RETAINER ON FWD ENTRY DOOR, ADJUSTED RETAINER CLIP PER AMM 25-66-01-200-801.SDR SWAA2025082606972Spring · damagedFORWARD SERVICE DOOR'S ESCAPE SLIDE GIRTH BAR'S FORWARD SPRING CLIP IS DAMAGED. R&R GIRT BAR FWD SPRING CLIP IN REF WITH AMM 25-66-01.SDR SWAA2025082607038Handle · looseCABIN L2 DOOR LINER CLOSE ASSIST HANDLE IS LOOSE. RESECURED CABIN L2 DOOR LINER CLOSE ASSIST HANDLE IN REF TO AMM 20-50-11.SDR SWAA2025082607037Handle · looseCABIN R2 DOOR LINER CLOSE ASSIST HANDLE IS LOOSE. RESECURED CABIN R2 DOOR LINER CLOSE ASSIST HANDLE IN REF TO AMM 20-50-11.SDR SWAA2025082608114Web · crackedLH MLG INNER DOOR IS CRACKED AT REAR HINGE ATTACH POINT WEBBING. REMOVED LH MLG INNER DOOR IAW AMM 32-13-11.<BR>OK TO CONTINUE PER CDL 32-10-4. SP1B AUTH # 275284. REMOVED LH MLG INNER DOOR IAW AMM 32-13-11.<BR>OK TO CONTINUE PER CDL 32-10-4.SDR SWAA2025082607495Anti-Skid Valve · faultedANTI SKID LIGHT CAME ON DURING TAKEOFF EXTINGUISHED AFTER RETURNING TO LAND.<[01] COMPLIED WITH IFIM TASK 32-42-00-810-828 ANTISKID/AUTOBRAKE CONTROL UNIT BITE PROCEDURE. NO FAULTS FOUND. PERFORMED RESISTANCE CHECKS OF LT AND RT ALTERNATE ANTI-SKID VALVES ANDSDR AALA202508262464Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: CENTER REAR SPAR RIGHT EXHAUST CUTOUT DOUBLER CRACKED AT BS 663.75. REPLACED DOUBLER PER AARD 51-00-05-1 AND SRM 51-40-02.SDR DALA2025082606338Skin · crackedCRACK ON #1 PYLON SKIN, STARTING ON AFT BOTTOM CORNER OF ACCESS 436BR. REMOVED CRACKED EXISTING #1 ENGINE STRUT SIDE SKIN CUTOUT AT AFT TRAPEZOIDAL ACCESS DOOR REPAIR DOUBLER AND INSTALLED REPLACEMENT REPAIR DOUBLER IAW B767 SRM 54-53-01-2R-7 STEPS 5-17. (11