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 CALA2025071406503Wire Splice · damagedPROCEDURE - AFTER DOING CABIN EMERGENCY LIGHTING TEST, FAULT INDICATED EPSU INT LOAD EMER L. EMERGENCY LIGHTS INOP FROM SEAT ROW 26- 28. BITE TEST EMER L PWR SUPPLY, SHOWED SHORT IN LIGHTING SYSTEM. AT ROW 27ABC, FOUND DAMAGED SPLICE AT FLOOR-TO-SEAT CONNECTORSDR YENA2025071400726Unknown · odorFLT#205, EWR-FLL. INFLIGHT REPORTED SLIGHT ODOR OF FUEL DURING TRANSITION FROM CRUISE TO DECENT; COMPLIED WITH INFO NOTICE 2017-T015, SECTION A ISOLATED FUALT TO TYPE 10-SUSPECT CUSTOMER WAS USING VIC'S IN ROW 3-4-PER TSM 05-50-00-810-085-B/TSM 05-50-00-810-08SDR DXTA2025071404208Engine · faultedDURING CRUISE AT FL430 WITH RAT OF -39 RECEIVED AN AMBER ENG CNTRL FAULT L CAS MESSAGE. ALONG WITH THIS CAS MESSAGE WE RECEIVED THE R ENG. THE ENG CNTRL FAULT QRH PROCEDURE (U1) COMPLETED. PROCEDURE INDICATED TO LAND AND CONTINUED TO DESTINATION. DURING DESCESDR DXTA2025071404214Battery Pack · faultedDURING FLT, EMERGENCY LIGHTS REMAINED ILLUMINATED & DID NOT TURN OFF AS EXPECTED. VERIFIED SWITCH POSITION & CYCLED THE EMERGENCY LIGHT SWITCH. LIGHT REMAINED ON THROUGHOUT DURATION OF FLT. APPLIED POWER WITH A GPU. OPS THE EMERGENCY LIGHTS SWITCH NOTING THATSDR DALA2025071405279Sign · detachedSHIP 0179 EXIT PLACARD ON PULL OUT SEAT NEEDS TO BE RE-SECURED. CORRECTIVE ACTION: RE-SECURED OF EXIT SIGN COVER BY PULL OUT SEAT AS REQ. AS PER B767 AMM 33-51. (7469483).SDR DALA2025071405271Starter Gen · inoperative(LOG 7444640) FUMES AND SMOKE DETECTED. A/C WAS ON APU PWR/AIR AND APU PWR DROPPED AS SMOKE WAS DETECTED. REMOVED AND REPLACED APU STARTER GENERATOR PER B737 AMM 49-41. OPS CHECK GOOD. REMOVED AND REPLACED RE-CIRC FILTERS.SDR DALA2025071405270Intercostal · corroded(LOG 1077077) RH SIDE PLATE, CORROSION FOUND ON INTERCOSTAL FROM STA 500B TO 500C, S-25R AT FWD CARGO COMPARTMENT. INTERCOSTAL FROM STA 500B TO 500C, S-25R AT FWD CARGO COMPARTMENT WERE REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025071405269Stringer · damaged(LOG 1077068) DURING CLIP REMOVAL ELONGATED HOLE WAS FOUND ON STR SL25 STA 999 AT LOWER HALF FUSELAGE. REPAIRED PER B737-800 SRM 53-00-03-2R PROCEDURE 1 REPAIR 1.SDR DALA2025071405268Fuel Tank · damaged(LOG 1077055) A.A.5100-01856-03A STEP 2 AREA 12: "CONFIRM DT EVALUATION FOR POSSIBLE FCS REPAIR" ON RH BODY RIB STA 545 AND RBL 70.85 AT CENTER FUEL TANK. REPAIR ON RH BODY RIB STA 545 AND RBL 70.85 AT CENTER FUEL TANK WAS INSPECTED PER ERA 627280-14 REV. ORIGSDR DALA2025071405267Pressure Deck · cracked(LOG 1076483) A.A. / A.D. CRACKS 2(EA)ON LH SIDE PRESSURE DECK WEB STA 663.0 BTW LBL 25.0/LBL 30.0 OF 0.600 IN (LENGTH) AND LBL 40.0/LB L45.0 OF 0.300 IN. LH SIDE PRESSURE DECK WEB STA 663.0 BTW LBL14 TO LBL50 WAS REPAIRED PER B737-800 SRM 57-10-10-2R REPAIR 3SDR DALA2025071405266Fuse · failed(LOG 7484406) ON SERVICE CHECK, FOUND EMERGENCY EXIT LIGHTS ABOVE AISLE AT ROWS 2C AND 4C INOP. FOUND F4 FUSE BAD AT POWER SUPPLY M1674. REPLACED F4 FUSE PER B737 AMM 33-51. OPS CHECK GOOD.SDR DALA2025071405265Fastener · missing(LOG 1075731) MISSING ONE ROW OF FASTENERS ON ANGLE AND S14 (BTW RIB 16 & 17) IAW DRAWING APB 737-8360 AT LH WING. ONE ROW OF FASTENERS ON ANGLE AND S14 (BTW RIB 16 & 17) IAW DRAWING APB 737-8360-9 AT LH WING WERE PERFORMED PER V.A 102068 (WORK CARD 5732-01015SDR DALA2025071405264Fastener · loose(LOG 1075724) LOOSE_ FASTENER ON SKIN_ AND ELONGATED HOLES ON UPPER SURFACE OF TRAILING EDGE BTW WS=278.50 ALSO WS=228.25 TO 204.25 AT RH WING. SKIN UPPER SURFACE OF TRAILING EDGE BTW WS =228.25 TO 204.25 AT RH WING WAS REPAIRED PER ER/A 627456-14.SDR DALA2025071405263Rail · corroded(LOG 1075683) CORROSION ON OUT OF LIMITS RAIL SUPPORTS OF BILGE AREA BTW STA 727D-727E, STA 767-787 RBL 3, 8 LBL 3. RAIL SUPPORTS OF BILGE AREA BTW STA 727D-727E, STA 767-787 RBL 3, 8 LBL 3 WERE REPAIRED PER B737-800 SRM 53-00-53-2R PROCEDURE 2, REPAIR 2.SDR DALA2025071405262Window Frame · cracked(LOG 1075452) CRACK OF 0.250" ON INNER CORNER RADIUS OF NO 1 LH WINDOW FRAME. CORNER RADIUS OF NO. 1 LH WINDOW FRAME WAS REPAIRED PER ERA 619132-14ADTR REV A.SDR IXXA20250711029Unknown · odorBURNING RUBBER SMELL ON APPROACH AND TAXI IN. GENERAL VISUAL INSPECTION OF E/E AND FORWARD CARGO COMPARTMENT IAW B767 AMM 05-41-01 NOTED NO FAULTS. RAN BOTH LEFT AND RIGHT PACKS IAW B767 AMM 21-00-00, NO SMELL REPORTED.SDR FDEA202507111183Battery Pack · failedDURING PRE DEPARTURE CHECK FOUNDED LH DOOR 1 EMERLIGHT U/S. AMM: 33-51-06-2-0 R&R'D LH BATTERY PACK IAW AMM 33-51-06-2-0. SYSTEM OK.A/C OK FOR SERVICE.SDR FDEA202507111182Seat Track · corrodedCORROSION NOTED ON THE SEAT TRACK BASE AT LH STA 1200-1240 I/B OF FLOOR PNL 251 MCF. REMOVED AND REPLACED SEAT TRACK AT L/H STA 1180 TO 1240 LBL 45.50 IAW SRM 51-40-02 AND SRM 53-60-52-01. MAJOR REPAIR.SDR HNAA2025071400468Inverter · abnormalDURING CLIMB TO 10,000 FEET LOUD WHINING NOISE FROM INSTRUMENT PANEL. P/C C/B F-5 . C/W MNT PROCEDURE. FWD ELEC COMP BAY RECIRC FAN. R&R RECIRC FAN #2 INVERTER IAW AMM 21-26-03. OPS CHECK GOOD IAW AMM 21-26-00. A/C OK FOR SERVICE AT THIS TIME. CLEAR MEL 21SDR KCSA2025071137Lock · faultedUPPER DECK FLIGHT LOCK. PERFORMED ADJUSTMENT TEST IAW AMM 52-23-00. NO DEFECTS NOTED.SDR I5PA2025071168803Pilot Valve · faultedRIGHT HS PILOT FAILED PNEUMATIC HEALTH CHECK. R & R RH HS PILOT PER AMM. PERFORMED HEALTH CHECK. OPS CHK OK.SDR I5PA2025071168802Shutoff Valve · faultedRIGHT HPSOV FAILED PNEUMATIC HEALTH CHECK. R & R RH HPSOV PER AMM. PERFORMED HEALTH CHECK. OPS CHK OK.SDR DALA2025071305251Seal · leakingAIRCRAFT 5030, FA REPORTED DIRTY SOCK SMELL IN FWD HALF OF CABIN ENTIRE DESCENT. CORRECTIVE ACTION: FOUND ENG1 FAN SHAFT COVER LEAK. REPLACED #1 FAN SHAFT SEAL PERT AMM 75-12, AND RECIRCULATION FILTERS. LEAK CHECK OK. (LP 7094074)SDR MASA2025071100058Light · inoperativePHOTOILLUMINESCENT STRIPS 1C-2C -, 29 INOP - PLACED ON MEL.SDR DALA2025071205248Slide · no testAIRCRAFT 9551, SLIDE FAILED DEPLOYMENT TEST PER AMDS WORK CARD 2561-9003 FORCAST# 95-0525-8-0131. CORRECTIVE ACTION: SLIDE FAILED TO DEPLOY DUE TO A BROKEN CABLE P/N 2919845. REPLACED KEVLAR TAIL CONE CABLE REF B717 AMDS WORKCARD 2561-9003. (LP 7297639)SDR N6WA2025071203Skin · corrodedCORROSION ON INTERNAL FUSELAGE SKIN AT FS394.00-FS409.00 BETWEEN STGR26L-STGR27L. REMOVED AND RESTORED FINISH OF INTERNAL FUSELAGE BETWEEN STGR26L-STGR27L AT FS394-FS409 IAW STS EA 129-2025-129SDR N6WA2025071202Skin · corrodedCORROSION ON FUSELAGE INTERNAL SKIN AT FS394-FS409 AND BL0. REMOVED AND RESTORED FINISH OF INTERNAL FUSELAGE SKIN AT FS394-FS409 AND BL0 IAW STS EA 129-2025-129SDR N6WA2025071201Skin · corrodedCORROSION ON INTERNAL FUSELAGE BETWEEN STGR26-STGR27 AT FS394-FS409. REMOVED AND RESTORED FINISH OF INTERNAL FUSELAGE BETWEEN STGR26-STGR27 AT FS394-FS409 IAW STS EA 129-2025-129SDR AALA202507125415Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 11WL DURING CIDS BITE TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 11WL (AALA202507126190) AND BATTERY (AALA202507125415) PER AMM 33-51-38. A SATISFACTORY OPERATIONAL CHECK WAS ACSDR AALA202507126190Power Supply · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 11WL DURING CIDS BITE TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 11WL (AALA202507126190) AND BATTERY (AALA202507125415) PER AMM 33-51-38. A SATISFACTORY OPERATIONAL CHECK WAS ACSDR FDEA202507111181Floorboard · dentedPANEL 221CFF HEAVILY DENTED. REPAIRED FLOOR PANEL 221CFF (MPN:141T5856-105) AT STA 285 - STA 412, LBL11 - RBL11 IN REF TO B767 SRM 53-00-50-2R, FIG 201, REPAIR 1, SHEET 2. THIS IS A MAJOR REPAIR. SEE JPF FOR ALL ACCOMPLISHED STEPS. FOR REMOVAL AND INSTALLASDR DALA2025071105224Pan · crackedAIRCRAFT 9572, DURING HCK AT QRO, WHILE PERFORMING A FORWARD LOWER CARGO DOOR INSPECTION PER WC. 5231-2005, THREE (3 QTY) CRACKS WERE FOUND AFFECTING THE FWD CARGO DOOR INNER & OUTER PANS AT THE AFT EDGE BETWEEN STOPS 1 & 2. ADDITIONALLY, AFTER REMOVAL OF THE SDR IPXA2025071170051Unknown · noiseLOUD NOISE SHORTLY AFTER LIFT OFF STARTED AT A LOW FREQUENCY THEN SLOWLY INCREASED IN PITCH, SOUNDED LIKE AN ENGINE SLOWLY REVING TO REDLINE. NOISE ENDED @ 5000€™. SUSPECT CREW ENTRY DOOR SEAL PRESSURIZED AIRCRAFT PER MM 21-30-00, NO LEAKS OR KOOKY NOISES NOSDR IPXA2025071167979Valve · faultedAT FL380 UNABLE TO CONTROL UPPER DECK TEMP€™S. THIS WAS APPROX 1.5 HRS INTO FLIGHT AFTER TALKING WITH MX, DISPATCH AND 5ME, DIVERT BACK TO ANC WAS DECIDED. REMOVED AND REPLACED IASC #1. UPDATED AND VERIFIED SOFTWARE AS PER DASH 8 MATRIX REF AMM 36-10-01-470-8SDR JJBA20250711039Support · crackedCF1 BTW FR 15-16 AND BTW 7R-9R SUPPORT ASSY CRACKED. CF1 BTW FR 15-16 INBD BTW STR 7R-9R SUPPORT ASSY REMOVED AND REPLACEDSDR JGVR20250711002Skin · corrodedREPAIRED 5 CORRODED AREAS ON LH HORIZONTAL STAB UPPER AND LOWER SKINS FORWARD OF PANEL 351A AND REPAIRED 3 CORRODED AREAS ON RH HORIZONTAL STAB UPPER SKIN FORWARD OF PANEL 352AC BY MECHANICALLY BLENDING AREAS, PERFORMING NDT AND REPORTING FOR REPAIR DISPOSITIOSDR JGVR20250711001Skin · corrodedREPAIRED CORRODED AREAS OF THE LH & RH HORIZONTAL STABILIZER LOWER TRAILING EDGE SKINS BY MECHANICALLY BLENDING AREAS, PERFORMING NDT AND REPORTING FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED AREA PER NETJETS REQUEST FOR TECHNICAL SUPPORT REPORT.SDR QR9R2025071100001Display · failedDURING FLIGHT, FLI DEGRADE ON LANE 1. LANE 1 FAILED. REMOVE AND REPLACED VEMD V2006 NVG; MOC SUCCESSFULLY COMPLETED IAW AMM 31-60-00, 4-2.SDR JJBA20250711013Seat Track · corrodedRH SIDE SEAT RAIL AT APPROXIMATELY FRAME 50 IS CORRODED. REMOVED CORROSION ON RH SIDE SEAT RAIL AT APPROX FRAME 50 FOUND TO BE OUT OF LIMITS. REMOVED, LOCATED, DRILLED AND INSTALLED NEW PART.SDR JR2R20250711789Shear Tie · corrodedSHEAR TIE CORRODED AT FR88 BETWEEN STR27R AND STR28R. REPLACEDSDR JR2R20250711791Shear Tie · corrodedSHEAR TIE CORRODED AT FR88 BETWEEN STR29R AND STR29L. REPLACEDSDR JR2R20250711803Shear Tie · corrodedSHEAR TIE CORRODED AT FR88 BETWEEN STR26R AND STR27R. REPLACEDSDR FDEA202507111180Floor Panel · dentedMAIN DECK FLOOR PANEL 241XFF PUNCTURED. MARKED WITH DOTS REPAIRED DAMAGED AREA ON TOPSKIN OF FLOOR PANEL 241XFF MPN# 145T5876-103 LBL 33- LBL 54.75. STA 984.95-1114.82 IN REF TO B767 SRM 53-00-50-2R FIG 201 SHEET 2 REPAIR 1. SEE JPF FOR ALL WORK STEPS ACCOSDR FDEA202507111179Floor Panel · dentedMAIN DECK FLOOR PANEL 231EFF PUNCTURED. MARKED WITH DOTS REPAIRED DAMAGED 1.5" AREA ON TOPSKIN OF FLOOR PANEL 231EFF MPN# 143T5876-63 LBL 77.5- LBL 77.5. STA 412-480 IN REF TO B767 SRM 53-00-50-2R FIG 201 SHEET 2 REPAIR 1. SEE JPF FOR ALL WORK STEPS ACCOMLSDR FDEA202507111178Skin · crackedUT AND HFEC OPEN HOLE INSPECTION FOUND TWO CRACKS IN LH WING #5 HOLE. THE LH WING UPPER SKIN #5 HOLE TWO CRACKS REPAIRED AS PER B777 SRM51-20-07-0G REV:47.6 AND EA G-5730-T0384072 P1, TITLE:WING-PLATES AND SKINS-LH WING UPPER SKIN CRACK REPAIR IN RIB BAYSDR FDEA202507111177Floor Support · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA1434 RBL40. MAIN DECK CARGO FLOOR FITTING CORROSION AT STA1434 RBL40 REMOVED AND EVALUATED: THE REWORKED AREA AT ZONE "B", THE MAX ALLOWABLE BLEND OUT IS 0.030", THE MAX CLEAN UP DEPTH IS X=0.092", FOUND SDR FDEA202507111176Floorboard · damagedN76/ PANEL 221DFF HEAVILY DENTED MARK WITH DOT. FABRITCATED NEW MAIN DECK FLOORBOARD FOR PANEL 221DFF IN REF BOEING DWG 141T5856- 117. MAJOR REPAIRSDR FDEA202507111175Floor Panel · damagedMAIN DECK FLOOR PANEL 231AFF MULTIPLE PUNCTURES.MARKED WITH DOTS. REPAIRED TO DAMAGE AREAS ON PANEL 231 AFF PER SRM 53-00-50-1A,FIG 101,SHEET 1 AND 2.SDR FDEA202507111174Longeron · chafedFORWARD CARGO BAY FUSELAGE AFT LOWER EXTERIOR EXISTING REPAIR AT BS 1002 TO 1013, LONGERON 39R TO 42R FOUND CHAFE ALONG BS 1002 EDGE. CHAFE AT FWD CARGO BAY FUSELAGE AFT LOWER EXTERIOR EXISTING REPAIR AT BS 1002 TO 1013, LONGERON 39R TO 42R REPAIRED IAW EA 1-5SDR FDEA202507111173Longeron · crackedUPON TRIMOFF NOSE LANDING GEAR RIGHT HAND TRUNNION HOLE FOUND LONGERON CRACK 0.5 STATION 585. X = -24.000. CRACKED LONGERON 0.5 AT NOSE LANDING GEAR RIGHT HAND TRUNNION FITTING HOLE AT STATION 585, X = -24.000 REMOVED AND REPLACED PER MD-11 SRM 51-31-01-