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 DALA2025071005209Support · corrodedAIRCRAFT 3095, CORROSION LOWER SILL LOC. FR 68 RH AT AFT GALLEY AREA (SSI: 534147). PERFOMED PERMANENT REPAIR ON LOWER SILL LOC.FR 68 RH AT LEVEL STR23R AFT GALLEY AREA AS PER A321 SRM 53-41-14-300-001, MEASURE OF CORROSION WAS: P1 L: 0.250 IN, W: 0.100 IN, SDR JR2R20250710794Frame Angle · corrodedCLIP ON FRAME 87 BETWEEN STRINGERS 27R AND 28R IS CORRODED. OUT OF LIMITS. REPLACEDSDR N3XR20250710002Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507100001Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR AALA202507103506Slide · draggingAIRCRAFT WAS NOT GROUNDED: L1 DOOR EMERGENCY SLIDE DRAGGING ON DOOR THRESHOLD WHEN OPENING AND CLOSING DOOR. INSPECTED AND RESECURED VELCRO. PER AMM 25-66-01.SDR JGVR20250710001Spar · corrodedMECHANICALLY BLENDED 1 EA. AREA OF CORROSION ON AFT SPAR, LOWER CLIP OUTBD AREA, IN THE RH MLG WHEEL WELL, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. REPAIRED AREA BY CLEANING, TREATING, AND PRIMING PER NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR JR2R20250710231Doubler · corrodedUPON REMOVALOF AFT WIFI ANTENNA, FOUND CORROSION ON DOUBLER.SDR CALA2025071006429Screw · missingEMERGENCY LIGHTS OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - EMERGENCY LIGHT AT SEAT 31C FOUND DAMAGED REPLACED MISSING HARDWARE, GRD OPS NORMSDR AALA202507108500Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 17ABC EMERGENCY LIGHT, EEPL, WHITE, SEAT MOUNTED, LED INOP. MAINTENANCE REPLACED SEAT 17ABC EMERGENCY LIGHT, EEPL, WHITE, SEAT MOUNTED, LED PER J/C 26L0000500.SDR AALA202507101627Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 16ABC EMERGENCY LIGHT, EEPL, WHITE, SEAT MOUNTED, LED INOP. MAINTENACE REPLACED SEAT 16ABC EMERGENCY LIGHT, EEPL, WHITE, SEAT MOUNTED, LED PER J/C 26L00005005.SDR AALA202507109585Power Supply · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK ESPU SYS TEST FAILED. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY IAW AMM 33-51-38.SDR FDEA202507101169Floor Panel · damagedMAIN DECK FLOOR PANEL 242EFF DAMAGED FABRICATED FLOOR PNL 242EFF ( MPN: 145T5876-100 ) AT STA. 820-930, RBL 11 - RBL 33 AS REQ. REF BOEING DRWNG 145T5876-100. SEE ALL ACCOMPLISHED STEPS IN JPF. THIS IS A MAJOR REPAIR. SEE NR # 152 ON WORK ORDER 90406 FORSDR FDEA202507101168Floor Panel · dentedMAIN DECK FLOOR PANEL 242AFF DAMAGED. MARKED WITH DOTS. FABRICATED NEW FLOOR PANEL 242AFF MPN # 145T5876-98 RBL 11- RBL 33 STA 731.11- 933 IN REF TO BOEING DWG 145T5876-98. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED THIS IS A MAJOR REPAIR. INSTALLATION OF FLOSDR FDEA202507101167Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA 1393 LBL6.5 MAIN DECK CARGO FLOOR FITTING CORROSION AT STA 1393 LBL6.5 REMOVED AND EVALUATED : THE REWORKED AREA AT ZONE "C", THE MAX ALLOWABLE BLEND OUT IS 0.002". THE MAX CLEAN UP DEPTH IS X = 0.033", SDR FDEA202507101166Fitting · corrodedMAIN DECK CARGO FLOOR FITING FOUND CORROSION AT STA1393 RBL6.5. MAIN DECK CARGO FLOOR FITTING CORROSION AT STA 1393 RBL6.5 REMOVED AND EVALUATED : THE REWORKED AREA AT ZONE "C", THE MAX ALLOWABLE BLEND OUT IS 0.002". THE MAX CLEAN UP DEPTH IS X = 0.022", FSDR FDEA202507101165Floor Panel · puncturedMAIN DECK FLOOR PANEL 251BGF MULTIPLE PUNCTURES. FABRICATED NEW FLOOR PANEL 251BGF, MPN: 146T5869-39, RBL 77.50- LBL 86.75, STA 1480-1518 IN REF. TO BOEING DWG 146T5869-39. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLATION OF THIS PASDR FDEA202507101164Floor Panel · damagedMAIN DECK FLOOR PANEL 222CFF HEAVILY DENTED. FABRICATED NEW FLOOR PANEL 2222CFF, MPN: 141T5856-116, RBL 54.75- RBL 77.50, STA 282-412 IN REF. TO BOEING DWG 141T5856-116. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLATION OF THIS PANELSDR 2025FA0000467Support · failed inspIMPELLER TUBE SUPPORT P/N: ITEM # 050B0 2468M46P01 S/N: XAEFW492 CSN: 1A_72310001210, EQUIPMENT NUMBER 6007225146 (CHAPTER 5 MANDATORY INSPECTION REQUIRED AND NOT PERFORMED PER LEAP-1A-05-21-02-01A-281B-C). ENGINE 598807 WAS RETURNED TO BRITISH AIRWAYS AFTESDR IXXA20250710001Skin · crackedR1 DOOR CUTOUT AFT LOWER CORNER IS CRACKED AT 2 HOLES LOCATIONS BOTH ARE THRU SKIN,THE LOWER HOLE IS THROUGH THRU BEAR STRAPSDR JR2R20250710860Access Panel · chafedL/H LOWER WING PLANK AT FUEL ACCESS CUTOUT 521EB DOORLAND SHOWS SIGNS OF CHAFING.SDR DALA2026031101705Scuff Plate · corrodedDOOR LOWER SCUFF PLATE FASTENER HOLES 20OL, 19OL, 18OL AND 16OL HAVE CORROSION. REMOVED CORROSION, EVALUATED AREA ON FWD CARGO DOOR LOWER SCUFF PLATE, FOUND OUT OF LIMITS IAW J51-21-06, J53-21-01. RESTORED FINISH AND ACCOMPLISHED ALL WORK IAW DELTA ERA 627318-SDR SWIA202511030709Door Sill · corrodedPAX DOOR LOWER SILL CORRODED IN MULTIPLE SPOTS (MARKED). (C-CHECK RO 11/01/2025)REMOVED AND INSTALLED NEW KICKPLATE ANGLE IAW CRJ 900 SRM 51-42-06-001-001-A01 AND CRJ 900 SRM 51-42-21-001-001-A01 AND DWG SH670-31810 REV. AE AND COMPLIED WITH TASK CARD 51-900SDR AALA202510213980Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME 16 RH FROM THE THIRD FASTENER HOLE 6 FROM UPPER TO LOWER) OF AFT ROW AND 7 DOORSTOP FITTING LEVEL AT FWD GALLEY AREA L= 0.098IN. MAINTENANCE PERFORMED TIME LIMITED REPAIR (PARTIAL FRAME REPLACEMENT) ON FRSDR NACA2025070900001Plenum · damagedLH AIR CONDITIONING COMPARTMENT PLENUM FOUND PERFORATION. REMOVED AND REPLACED LH AIR CONDITIONING COMPARTMENT PLENUM AS PER 767-300 AMM 21-51-01SDR SCNA20250916376Lap Joint · corrodedLEFT MAIN CARGO COMPARTMENT BS 663.75 TO BS 1016 LWR LAP SEAM HAS CORROSION WITH PAINT PEELING IN VARIOUS LOCATIONS. REMOVE PAINT, EVALUATE, CHECK LIMITS. CHEMICALLY PAINT STRIPPED L/H MAIN CARGO COMPARTMENT EXT FROM STA. 663.75 TO STA 1016 LWR LAP SEAM IAW SDR IPXA2025081943612Skin · damagedCREW DOOR UPPER INNER SKIN HAS BARE METAL EXPOSED. CLEANED AREA AND RESTORED SURFACE PROTECTION IAW A300-600 SRM 51-21-10, SRM 51-75-10 AND AMM 12-21-11.SDR IPXA2025081941352Door · corroded*** SUPPLEMENTAL SDR *** FAULT: STR-ZONE 831- ALL FASTENERS AROUND CREW DOOR EXTERNAL SURFACE CORRODED. JP-110 REVIEWEDSDR SWAA2025081589592Door · crackedLEFT MAIN GEAR CENTER DOOR IS CRACKED, JUST FWD OF FWD HINGE ATTACH POINT. REMOVED AND REINSTALLED LT MLG CENTER DOOR IAW AMM 32-13-11.SDR 3EJA202508150003Elec Connector · not seatedON APPROACH AND GIVEN INSTRUCTION TO SLOW. CONFIGURED THE AIRPLANE FOR FLAPS 15. RECEIVED A STAB MISCOMPARE & DISCONTINUED THE APPROACH. REMOVED, INSPECTED & REINSTALLED PCBS NZ016 AND NZ017. CLEANED AND INSPECTED ELECTRICAL CONNECTOR PF029, RESEATED ELECTRISDR SWAA2025081489485Assist Handle · brokenAFT SERVICE DOOR SURROUND ASSIST HANDLE IS BROKEN.SDR SWAA2025081289822Rib · crackedL/H HORIZONTAL STAB REMOVABLE L/E; 3RD RIB FROM I/B END IS CRACKED. REMOVED AND REPLACED 3RD RIB FROM I/B END OF L/H HORIZONTAL STAB. L/E IAW SRM 51-40-02-0G-0 PARA. 4.SDR SWAA2025081289823Rib · crackedL/H HORIZONTAL STAB REMOVABLE L/E; 4TH RIB FROM I/B END IS CRACKED. REMOVED AND REPLACED 4TH RIB FROM I/B END OF L/H HORIZONTAL STAB. L/E IAW SRM 51-40-02-0G-0 PARA. 4.SDR SWAA2025081289824Rib · crackedL/H HORIZONTAL STAB REMOVABLE L/E; 5TH RIB FROM I/B END IS CRACKED. REMOVED AND REPLACED 5TH RIB FROM I/B END OF L/H HORIZONTAL STAB. L/E IAW SRM 51-40-02-0G-0 PARA. 4.SDR HNAA2025081200561Angle · corrodedF058407 RH ESCAPE HATCH LOWER L ANGLE HAS SURFACE CORROSION AT AFT GROUND PLATE. REMOVED AND REPLACED RH ESCAPE HATCH LOWER "L" ANGLE IAW EMB145 SRM 51-40-02.SDR HNAA2025081200560Floor Support · corrodedF058356 GALLEY FLOOR FWD DIGITAL BETWEEN FR-16/17 NEXT TO PAX DOOR AROUND A NUT-PLATE HOLE HAS CORROSION. REPAIRED CORRODED AREA ON GALLEY FLOOR FWD DIGITAL BETWEEN FR-16/17 NEXT TO PAX DOOR AROUND A NUT-PLATE HOLE IAW PIEDMONT EO1-05-25-0264 AND EMB 145 SRM SDR HNAA2025081200559Floorbeam · corrodedGALLEY FLOOR R/H BEAM DIAMOND GUSSET AT FR-22 HAS CORROSION. REMOVED AND REPLACED GALLEY FLOOR R/H BEAM DIAMOND GUSSET AT FR-22 IAW EMB145 SRM 51-40-02.SDR HNAA2025081200558Floor Support · corrodedF058251 LH OMEGA BEAM IS CORRODED BETWEEN FR33 AND FR34. REMOVED CORROSION ON LH OMEGA BEAM BETWEEN FR33 AND FR34 IAW EMB 145 SRM 51-10-03 AND BLENDED AREA ACCEPTED IAW PIEDMONT EO1-05-25-0264 AND ETD2025-145-925337.SDR HNAA2025081200557Floorbeam · corrodedLH FLOOR CROSSBEAM AT FR 31 HAS CORROSION. RAR LH FLOOR CROSSBEAM AT FR31 IAW EMB 145 SRM 51-40-02SDR HNAA2025081200556Seat Track · corrodedRH LOWER #1 SEAT TRACK HAS CORROSION IN MULTIPLE SPOTS. REMOVED AND REPLACED RH LOWER SEAT TRACK #1 IAW EMB 145 AMM 53-01-06SDR HNAA2025081200555Seat Track · corrodedF058242 RH UPPER #1 SEAT TRACK HAS CORROSION IN MULTIPLE SPOTS. REMOVED AND REPLACED RH UPPER #1 SEAT TRACK IAW EMB 145 AMM 53-01-06SDR HNAA2025081200554Seat Track · corrodedLH UPPER #2 SEAT TRACK HAS CORROSION IN MULTIPLE SPOTS. REMOVED AND REPLACED LH UPPER #2 SEAT TRACK IAW EMB 145 AMM 53-01-06.SDR HNAA2025081200553Floor Support · corrodedLH FLOOR SILL #2 HAS CORROSION IN MULTIPLE SPOTS. BLENDED TO REMOVE CORROSION ON LH FLOOR SILL #2 IAW EMB 145 SRM 51-10-03. RAR THE LH #2 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025081200552Floor Support · corrodedLH FLOOR SILL #3 HAS CORROSION IN MULTIPLE SPOTS. REMOVED AND REPLACED LH FLOOR SILL #3 IAW EMB 145 SRM 51-40-02SDR HNAA2025081200551Seat Track · corrodedF058237 LH UPPER #3 SEAT TRACK HAS PITTING IN MULTIPLE SPOTS. REMOVED PITTED LH UPPER #3 SEAT TRACK AND INSTALLED SERVICEABLE LH UPPER #3 SEAT TRACK IAW EMB 145 AMM 53-01-06.SDR HNAA2025081200550Seat Track · corrodedF058236 LH LOWER #3 SEAT TRACK HAS PITTING IN MULTIPLE SPOTS. REMOVED AND REPLACED L/H LOWER #3 SEAT TRACK IAW EMB 145 AMM 53-01-06.SDR HNAA2025081200549Floor Support · corrodedRH OUTBD FLOOR SILL #2 HAS PITTING IN MULTIPLE SPOTS. BLENDED TO REMOVE PITTING ON RH OUTBD FLOOR SILL #2 IAW EMB 145 SRM 51-10-03 RAR RH FLOOR SILL #2 IAW EMB 145 SRM 51-40-02.SDR IXXA20250809010Limiter · gouged#1 ENGINE, INBD T/R, FWD DEFLECTION LIMITER IS GOUGEDSDR IPXA2025080637021Support · corrodedFAULT- STR- ZONE 100- AFT CARGO FR 58 RH SLOPE STRUCTURE (P/N F539-71534-006-00) IS CORRODED IN 2EA PLACES. 91148554.REMOVED AFT CARGO FR 58 PROFILE BRACKET P/N F539-71534-006-00 IAW A300-600 SRM 51-40-21.RECEIVED NEW SECTION SUPPORT (01EA)P/N F5397153400600 BSDR IPXA2025080637267Support · corrodedFAULT- STR- ZONE 100- FR 57 LH SLOPE STRUCTURE HAS CORROSION IN 1 PLACED MARKED IN RED. 91148554. REMOVED AFT CARGO FR 57 LH PROFILE BRACKET P/N F539-71534-006-00 IAW A300-600 SRM 51-40-21.RECEIVED NEW SECTION SUPPORT (01EA) P/N F5397153400600 BCH# 0004416282.SDR IPXA2025080537837Angle · crackedFAULT: STR-ZONE 400-#1 PYLON-INSIDE 475AL O/B SIDE 7TH FRAME FROM FWD SIDE-LOWER PART OF FRAME BROKEN ANGLE-109-VWV-91195430.FAB BROKEN ANGLE LOCATED AND DRILLED IAW A300-600 SRM.APPLIED TREATED AND PRIMER TO NEW ANGLE WITH P/N#ALODINE1132 BTCH#4381945 QTY: 1E