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 FDEA202507041119Floor Panel · damagedMDC FLOOR PANEL 251QFF WITH HOLE MDC FLOOR PANEL 251QFF WAS REPAIRED I.A.W B767 SRM 53-00-50-2R, FIG 201 SHEET 2, PAR 4.C REV 92 APR-15-2025SDR FDEA202507041118Floor Panel · damagedMDC FLOOR PANEL 241EFF WITH HOLE MDC FLOOR PANEL 241EFF WAS REPAIRED I.A.W B767 SRM 53-00-50-2R, FIG 201 SHEET 2, PAR 4.C REV 92 APR-15-2025SDR FDEA202507041117Floor Panel · damagedMDC FLOOR PANEL 232NFF WITH HOLE MDC FLOOR PANEL 232NFF WAS REPAIRED I.A.W B767 SRM 53-00-50-2R, FIG 201 SHEET 2, PAR 4.C REV 92 APR-15-2025SDR FDEA202507041116Floor Panel · crackedMDC SECTION 45 FLOOR PANEL 241WFF WITH CRACK MDC SECTION 45 FLOOR PANEL 241WFF WAS REPAIRED I.A.W B767 SRM 53-00-50-2R, FIG 201 SHEET 2, PAR 4.B REV 92.0 APR-15-2025.SDR FDEA202507041115Floor Panel · crackedMDC SECTION 45 FLOOR PANEL 241YFF WITH SEVERAL CRACKS MDC SECTION 45 FLOOR PANEL 241YFF, WAS REPAIRED I.A.W B767 SRM 53-00-50-2R, FIG 201 SHEET 2, PAR 4.B REV 92.0 APR-15-2025SDR FDEA202507041114Skin · crackedMFEC INSPECTION OF THE OUTBOARD SLAT NO.10 OUTER SKIN DETECTED 1EA FASTENER WITH TWO CRACKS, APPROXIMATELY 4MM AND 6MM IN LENGTH RESPECTIVELY. RH WING NO.10 SLAT OUTER SKIN CRACK AREA REPAIRED AS PER B777 SRM 57-43-01-2R REPAIR 9 FIG 202 REV47.6 AND EA GSDR FDEA202507041113Skin · bulgedRH WING NO.11 SLAT OUTER SKIN FOUND BULGE AT 28-33 INCH TO OB EDGE. RH WING NO.11 SLAT OUTER SKIN BULGE AREA REPAIRED AS PER B777 SRM 57-43-01-2R REPAIR 9 FIG 202 REV 47.6 AND EA G-5750-T0384008 P1. TITLE : WING - FLIGHT SURFACES - RH WING #11 SLAT OUTER SSDR FDEA202507041112Power Supply · failedEMERGENCY LIGHTING SYSTEM TEST SHOWING "EMERG BAT 1 LO" MSG ,DURING COCKPIT POST FLT CHECK. RELEASED FOR SERVICE PER MEL 33-50-04. EMERG BAT 1 LOW MSG DURING TEST. REPLACED EMERGENCY POWER SUPPLY. OPS CHECKS SATISFACTORY. OK FOR SERVICE.SDR 2025FA0000451Harness · misinstalledWE HAVE BEEN INFORMED OF AN INCORRECT ASSEMBLY CARRIED OUT BY THE ST ON THE HARNESS PN 325-043-503-0, SN YH656967-D. UPON VERIFICATION, WE CONFIRMED THAT THIS EQUIPMENT WAS INSTALLED ON ENGINE RYR 894853, DELIVERED ON JANUARY 24, 2025. A CSC CASE HAS ALSO BEENSDR AALA202507064965Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 3 ELEVATOR ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 3 ON LH HORIZONTAL STABILIZER I.A.W AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507064542Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 2 ELEVATOR ON LH HORIZONTAL STABILIZER). MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 2 ON LH HORIZONTAL STABILIZER I.A.W AMM 55-16-42-000-001- A AND AMM 55-16-42-400-001-A.SDR AALA202507063006Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 1 ELEVATOR ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 1 ON LH HORIZONTAL STABILIZER I.A.W AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507063343Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FA FLASHLIGHT AT AIRCRAFT AFT LEFT INOP. MIANTENANCE REPLACED FLASHLIGHT BATTERY,SDR AALA202507068570Sign · faultedAIRCRAFT WAS NOT GROUNDED: AFT EMERGENCY EXIT LIGHT SIGN PARTIALLY ON. MAINTENANCE REPLACED EMERGENCY EXIT LOCATION SIGNS AT AFT ENTRY DOOR, CENTER AISLE ABOVE AFT LAVATORY IAW AMM 33-51-16, 33-51-17.SDR AALA202507065178Sign · faultedAIRCRAFT WAS NOT GROUNDED: FWD EMERGENCY EXIT LIGHT SIGN PARTIALLY ON. MAINTENANCE REPLACED EMERGENCY EXIT LOCATION SIGN AT FWD ENTRY DOOR, CENTER AISLE ABOVE AFT LAVATORY IAW AMM 33-51-16, 33-51-17.SDR AALA202507063796Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: F/A FLASHLIGHT FOR AFT 2R DOOR JUMPSEAT NOT TESTING. MAINTENANCE REPLACED F/A FLASHLIGHT BATTERY FOR AFT JUMPSEAT AT 2R DOOR IAWAMM 25-64-00.SDR EE4Y2025070422633Skin · damagedDURING THE ACCOMPLISHMENT OF SB190-57-0056, WERE FOUND 5 EXISTING FASTENER HOLES WITH OVERSIZED DIAMETER (LOCATED AT SPAR I AND RIBS 8 AND 9). THIS CONDITION WAS REPORTED TO EMB FOR REPAIR INSTRUCTIONS. THIS CONDITION WAS REPAIRED PER ETD2025-190-922232 AND DOSDR EE4Y2025070422632Lug · corrodedDURING THE ACCOMPLISHMENT OF SB190-57-0056 WING LOWER SKIN REINFORCEMENTS, THE PYLON WASREMOVED FOR ACCESS. DURING THE INSPECTION BEFORE THE PYLON INSTALLATION, WE FOUND THE RH PYLON SUPPORT LUGS (OUTBOARD) WITH BUSHINGS FRETTING. AFTER BUSHING REMOVALFOR REPLSDR EE4Y2025070422631Skin · corrodedDURING THE INSPECTION WAS REPORTED CORROSION DAMAGE AFFECTING THE FUSELAGE SKIN, LOCATED AROUND THE EXISTING HOLE CUT OUT, BETWEEN FRAME 63 AND 64 AND BETWEEN STRINGER 1L AND 2L. SINCE THE CORRODED AREA REQUIRE A SKIN TRIM OUT AND A REPAIR, THE DOUBLER P/N: 19SDR EE4Y2025070422630Skin · damagedDURING THE STRUCTURE INSPECTION, IT WAS FOUND THE CENTER FUSELAGE I – AT FR29+365MM, S-20R+14MM EXTERNAL SKIN WITH LIGHTNING STRIKE. THE DAMAGE WAS REMOVED BY DRILLING A HOLE (Ø3.17MM). PER ERJ 190 SRM 53-21-01 / AD53 IT WAS NOT POSSIBLE TO REPAIR IT, DUE TO TSDR EE4Y2025070422629Bushing · corrodedDURING THE ACCOMPLISHMENT OF SB190-57-0056 WING LOWER SKIN REINFORCEMENTS, THE PYLON WAS REMOVED FOR ACCESS. DURING THE INSPECTION BEFORE THE PYLON INSTALLATION, WE FOUND THE LH PYLON SUPPORT LUGS (INBOARD AND OUTBOARD) WITH BUSHINGS FRETTING. AFTER BUSHING RESDR EE4Y2025070422627Skin · damagedDURING THIS PROCESS, WERE IDENTIFIED ( 1EA) EXISTING FASTENER HOLE WITH OVERSIZED DIAMETER COMMON TO LOWER SKIN, SPAR I, AND RIB 8 AND WITHIN THE AREA COVERED BY THE REF. EMBRAER SB 190-57-0056 AND FAA AD2020-04-16. THIS CONDITION WAS REPORTED TO EMB AND REPAISDR DALA2025070404993Battery Pack · inoperativeAIRCRAFT 3005, 11WB EPSU BATTERY/POWER SUPPLY INOP. CORRECTIVE ACTION: REPLACED THE 11WB EPSU BATTERY AND CHARGER PER A321 AMM 33-51. OPS CHECK GOOD AT THIS TIME. (LP 5113758)SDR ABXA20250704141Engine · warning lightON #2 ENG START WHILE TAXING EGT EXCEEDANCE TO 562 AC RETURNED TO GATE (BTB) AND MTX GROUNDED AC. MTX PERFORMED #2 ENG. START ,EGT FOUND TO BE IN LIMITS. IAW FIM TASK 71-08 FAULT TREE 816. AND MTX RETURNED AC TO SERVICE.SDR 2025FA0000447Hpc · crackedHAESL REPORTED CRACK INDICATION FOUND ON INNER WELD 16 OF HPC STAGE 5-6 DISC AND CONE REAR ROTOR SHAFT (EIPC: 72-41-31-03-250, PART NUMBER: KH19634, S/N: RRDCDD103290) ON ESN 11191 DURING EDDY CURRENT INSPECTION BY OVERSEA VENDOR (DELTA TECHOPS). NO ACCEPTANCSDR SWIA2026030475631Doubler · unknownCOMPLY WITH SCHEDULED MAINTENANCE WIFI PCS/TIMING ANTENNA SDI 700 - COMPLY WITH INSPECTION OF THE PCS/TIMING ANTENNA SDI & DI IAW STC ST02541CH ICA DOCUMENT D12454-20110 SEC 4 (LATEST REVISION) 1. INTERNAL A/C SKIN - DOUBLER OUTER EDGE FASTENER HOLES - SDI2.SDR DALA2026031101700Scuff Plate · corrodedL1 DOOR SCUFF PLATE FASTENER HOLES 15OL, 14OL, 11OL, 5OL, 4OL, 3OL, 2OL, AND 1OL HAVE CORROSION. REMOVED CORROSION, EVALUATED AREA ON FWD PAX DOOR LWR SCUFF PLATE FOUND OUT OF LIMITS IAW A220 ASRPJ51-21-06, J53-21-02. RESTORED FINISH AND ACCOMPLISHED ALL WORK SDR SWIA2025121900703Door Frame · corrodedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA93189-601R-53-61-8212 MXCODEID77004-PR - FRAME FS574.00 AT CARGO DOOR FWD OPENING HAS CORROSION AT APPROX. WL 75.00. BLENDED CORROSION ON FRAME BS 574 AT CARGO DOOR FWD OPENING AT WL 75 IAW SRM 51-21-06 AND COMPLIED WSDR SWIA20250703Intercostal · corrodedPAX DOOR INTERCOSTAL DD7A BS 323 - 327.763 CORRODED. PAX DOOR INTERCOSTAL HAS INTERGRANULAR CORROSION ON ENTIRE LENGTH OF PART. OUT OF LIMITS. REF: REO 670-52-11-010 REV NC 2002-02-25 AND SRM 52-00-00. INSTALLED NEW PAX DOOR INTERCOSTAL IAW SRM 51-42-06-001-SDR SWIA2025090200703Tie Down · damagedCENTER CARGO NET TIE DOWN RING ASSY WITH TWO ANGLES (REF SRM 53-61-43 ITEMS 6 & 8) REMOVED TO F.O.M. WITH REFERENCE TO SRM 51-42-21. (C-CHECK RO 08/29/2025)INSTALLED CENTER CARGO NET TIE DOWN RING ASSY WITH TWO ANGLES (REF SRM 53-61-43 ITEMS 6 & 8) WITH REFERSDR J7SA2025082600451Fce · faultedGND SPLR FAIL CAS ILLUMINATED ON TOUCHDOWN. REPLACED FCE 2. RIGGING AND OPS CHECK GOOD. ALL WORK COMPLETED IAW EMBRAER PHENOM 300 AMM 27-03-01.SDR IPXA2025080750211Adapter · corrodedCORROSION FOUND ON SEAT TRACK (5 LOCATIONS, EACH ONE ON A FRAME) BTW FR21&FR27 -Y65.5 INSTALLED NEW SEAT TRACK ADAPTER, CLS (4E/A) AND NUTPLATES (10E/A) IAW A300-600 SRM 51-40-21.SDR IPXA2025072053158Fitting · crackedCRACK FOUND AT ANGLE-FITTING FR10 Y953 (PN A53612356200) INSTALLED 01 ANGLE FITTING P/N A5361235620000, BCH #0004410795, USING 11 SOLID RIVET IAW SRM 51-40-21 AND SRM 51-21-10SDR IPXA2025071555684Floor Panel · crackedMAIN DECK FLOOR PANEL 232EF IS CRACKED. FABRICATED FLOOR PANEL 232EF IAW SREO-16407-REQ001. PAINTED IAW AMM 25-00-00/801.SDR SWIA2025081800703Angle · damagedREMOVED TWO FASTENERS ON RH PRESSURE FLOOR SILL ANGLE AT FS513.00 AND BETWEEN RBL42.4 - RBL36.0 TO FOM (C-CHECK RO 08/16/2025)COMPLIED WITH REO 601R-53-41-3333 REV-A DATED 2025-07-16 DISPOSITION FOR ALTERNATE FASTENER INSTALLATION TO RH PRESSURE SILL FLOOR ASDR SWAA2025081188085Floor Support · crackedCRACKED FLOORBEAM AT PASSENGER COMPARTMENT BS 540 LBL 2 WL 208. REMOVED AND REPLACED FLOOR SUPPORT PANEL BREAK AT PASSENGER COMPARTMENT BS 540 LBL 2 WL 208 IAW SRM 51-40-02-0G-0 AND AIPC SWA D638A001-SWA-0102.SDR SWAA2025081188094Skin · delaminatedRIGHT WING INBD MAIN FLAP O/B T/E WEDGE IS DELAMINATED. REMOVED AND REPLACED THE RIGHT WING INBD MAIN FLAP O/B T/E WEDGE IAW SOPM 20-50-01.SDR IPXA2025080155352Intercostal · corrodedFS 1037 - FS 1060 LBL 37 THE PAX EXHAUST INTERCOSTAL 149N7559-1 HAS EXFOLIATION ON UPPER FWD SURFACE INSTALLED PAX EXHAUST INTERCOSTAL OF FS 1037-1060 LBL 37 IAW SRM 51-40-02.SDR JGVR20250801001Spar · corrodedBLENDED CORRODED AREAS ON THE LT WING LOWER AFT SPAR CLIP LOCATED IN THE LT MAIN LANDING GEAR WHEEL WELL BEHIND PANEL 730DL, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED AND PRIMED CORRODED AREAS PER NETJETS REQUEST FOR TECHNICAL SERVICESDR SWIA202507300003Pressure Deck · out of positionPRESSURE FLOOR AT BL0.0, R/H SIDE AFT BULKED BEAN AT LOWER SPLICE AND PRESSURE FLOOR, EXISTING PILOT HOLE DOESN'T LINE UP WITH THE EXISTING FULL SIZE HOLE OF THE BULK BEAN. SUBMITTED ENGINEERING. RECEIVED AND COMPLIED WITH REPAIR OF EXISTING UNALIGNED PILOT SDR JJBA20250730108Profile · crackedBOTTOM OF VERT STAB, AFT OF REAR SPAR 3, RH PROFILE CRACKED AT LOWER SECTION. BOTTOM OF VERT STAB AFT OF REAR SPAR 3 RH PROFILE CRACK BLENDED. BOTTOM OF VERT STAB AFT OF REAR SPAR 3 RH AT LOWER SECTION WAS REPAIRED AND INSTALLED.SDR SWAA2025072988004Doubler · corrodedWIFI ANTENNA AREA; EXTERIOR FUSELAGE CROWN SKIN DOUBLER FOUND CORROSION AT STA 727C BTWN STGR 1 AND 2 RH AT SEVERAL FASTENERS. RESOLVE FAULT ON TTG8Q013J793 WHERE EA 25-153-01827.SDR REXA2025072900770Seat Track · corrodedINITIAL INSPECTION:CORROSION (SEVERAL POINTS) ON RH SEAT TRACK RBL 10 BTW FS 349.00 TO 379.00 ALSO CORROSION ON LH SEAT TRACK LBL 10 BTW FS 374.00 TO 409.00 AND LBL 27 BTW FS 364.00 FWD END AT PAX CABIN DUE TO EXCESIVE DAMAGE ON RH SEAT TRACK RBL 10 BTW FS 349SDR REXA2025072900769Angle · corrodedINTIAL INSPECTION: CORROSION ON INTERNAL ANGLE AND BEHIND OF ANGLE AT FWD TOILET SERVICE ACCESS EXTERNAL FUSELAGE CORROSION ON INTERNAL ANGLE AT FWD TOILET SERVICE ACCESS EXTERNAL FUSELAGE WAS REMOVED PER CRJ 900 SRM 51-21-06-001-001-A01 , INTERNAL ANGLE WAS SDR REXA2025072900768Retainer · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND LBL & RBL 34). MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND LBL & RBL 34) WERE REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01 AND AMM 20-21-00-910-8SDR REXA2025072900767Retainer · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH (FS 797.00 AND LBL & RBL 34). MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH (FS 797.00 AND LBL & RBL 34) WERE REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01 AND AMM 20-21-00-910SDR SCNA20250728284Intercostal · wornINITIAL INSPECTION: WEAR ON INTERCOSTAL WEB STA 337 LBL 6.74 AND RBL 15.47 DOOR CUTOUT AT E/E COMPARTMENT. OPENSDR DALA2025072805667None · noneSOFTWARE UPDATE IS REQUIRED AFTER DUAL ENGINE CHANGE. PERFORMED SOFTWARE UPDATE PER ERA 627403-14 REV ORIGINAL SECTION 1 ON #1 ENGINE. #2 ENG STILL REQUIRES SOFTWARE UPDATE. (147906) SOFTWARE UPDATED PER ERA 627403-14 REV A SECTION 1 ON #2 ENG. COMPLIED WITH. SDR CALA2025072806953Door Frame · corrodedFOUND TWO AREA OF INTER-GRANULAR CORROSION, NEXT TOO THE R1 DOOR(INNER-CHORD) REF AAR N/R 9983208 COMPLETED INSTALLATION OF FASTENERS AT INNER CHORD OF R-1 DOOR REF SRM 51-40-02-0G-0, DWG 141A8310. WORK ACCOMPLISHED BY V935074 AND INS-223. ESFR CREATED AND SUBSDR R61A2025072600316Rib · crackedSUSPECTED CRACK LH WING AT RIB 4A. COMPLIED WITH ETD2025-170-924427