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 AALA202601239344Dampener · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT-HAND EMERGENCY EXIT DOOR (845) DAMPER AND EMERGENCY OPERATION CYLINDER BELOW LIMITS. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601231935Bracket · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT AT L1 DOOR WILL NOT TEST. REPLACED FLASHLIGHT (AALA202601236518) AND HOLDER / BRACKET ASSEMBLY (AALA202601231935) PER AMM 25-65-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR AALA202601232346Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT AT R4 DOOR WILL NOT TEST. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202601236518Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT AT L1 DOOR WILL NOT TEST. REPLACED FLASHLIGHT (AALA202601236518) AND HOLDER / BRACKET ASSEMBLY (AALA202601231935) PER AMM 25-65-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR AALA202601239305Cylinder Damper · low pressureAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANTS PANEL DISPLAYS MESSAGE TO CHECK DOOR PRESSURE. NO INDICATION IN FLIGHT DECK. MAINTENANCE SERVICED THE L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601232119Failsafe · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FAILSAFE STRAP RUNNING UNDER KICK FITTING AT STA 663.75, S18R. REPAIRED FAILSAFE PER EA 370951.SDR REXA2026073101361Stringer Splice · corrodedCORROSION ON JOINT PIECE STRG23 RH (1EA) REMOVE AND INSTALL OF NEW JOINT PIECE STRG 23 (1EA) WAS ATTENDED ON NRC292, EVALUATED OUT LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01, DRILLED PER CRJ 900 SRM 51-40-11-001-001-A01 AND PAINTED PER CRJ 900 SRM 51-21-11-SDR SWIA2026012276628Stringer · corrodedSIGNS OF CORROSION ON STGR 26R AT F.S.1047.0, JUST FORWARD AND TO THE RIGHT OF THE POTABLE WATER TANK. REMOVED AND REPLACED REPAIR SPLICE, REPAIR FILLER, REPAIR DOUBLER, AND INTERCOSTAL BETWEEN FS 1047 AND FS 1069 BETWEEN STRINGERS 24L AND 26R IAW SRM 53-00-0SDR SWIA2026012276087Stringer · corrodedCORROSION ON STGR25R AFT OF FS1031.00 (C-CHECK RO 05/22/2026)REPLACED AFFECTED STRINGER WITH NEW STRINGER IN REF WITH CRJ900 SRM 51-42-06-001-001-A01,CRJ900 SRM 51-42-21-001-001-A01 AND DWG MM670-35007 REV.W. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002SDR SWIA2026012276070Door Frame · corrodedMAIN AVIONICS BAY DOOR LAND PITTED AND WITH FRETTING DAMAGE ALL AROUND. REMOVED DAMAGE ALL AROUND MAIN AVIONICS BAY DOOR LAND PER REF SRM 51-21-06-001-001-A01, AVIONICS BAY DOOR LAND IS WITHIN LIMITS PER REO 690-53-21-032, REV --. SEE CONTINUATION CARD FOR DESDR SWIA2026012276068Frame · corrodedCORROSION ON FS1000.00 FRAME FLANGE AT STGR26R-25R. REMOVED REPORTED CORROSION ON FS1000 FRAME ATTACHING FLANGE BETWEEN STGRS 26R-25R PER REF CRJ 900 SRM 51-21-06-001-001-A1, FOUND OUT OF LIMITS PER REF CRJ 900 SRM 53-61-06-101-003-A02. REPAIRED DAMAGED FRAMESDR SWIA2026012276065Stringer Splice · corrodedCORROSION ON STGR19R AT FS477.40 BEHIND UNDERFLOOR RISER DUCT. REPLACED STRINGER SPLICE AT STR19R FS477.40 BEHIND UNDERFLOOR RISER DUCT. REF DWG# SH690-30006 REV: C AND SRM 51-42-06-001-001-A01 REV:38 . COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY. PSDR SWIA2026012276057Support · corrodedCORROISON ON BACKUP, SILL (STGR 21L, FS333.00 TOFS349.00) REPLACED BACKUP, SILL (STGR 21L, FS333.00 TOFS349.00) REF. SRM 51-42-06-001-001-A01 AND DWG# SH670-31810 REV: AE. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2026012276054Frame · corrodedCORROSION ON BS 969 FRAME AFT SIDE AT STRINGER 23R. INSTALLED NEW FRAME AT BS 969 FRAME FROM STRINGERS 20L - 20R IAW DWG SH690-37060, REV AC, SRM 51-40-06-001-001-A01, AND SRM 51-42-21-001-001-A01. COMPLIED WITH ALL STEPS OF OF TASK CARD 51-900-1002-SKY. PRESSDR SWIA2026012276050Structure · corrodedBACKUP, SILL, STRINGER 21L, BS 310 TO 333 HAS CORROSION. REPLACED BACKUP, SILL STRINGER 21L, BS 310 TO 333 IAW SRM 51-42-06-001-001-A01 AND DWG SH670-31810, REV AE. COMPLIED WITH ALL STEPS OF TASK CARD, 51-900-1002-SKY. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2026012276045Stringer · corrodedJUST AFT OF FS 597.0 AT STR 19R STRINGER HAS CORROSION. INSTALLED NEW STRINGER SECTION FROM FS477 TO FS621 STGR 19R IN REF WITH SRM 53-00-03-201-001-A02, DWG SH690-33101 REV M. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY . PRESSURE CHECKED GOOD.SDR 2A6R2026052675601Deck Plate · dentedDURING 500-HOUR INSPECTION, A DENT WAS DISCOVERED ON THE R/H SIDE OF THE TRANSMISSION DECK (P/N: L533M1017295). THE MAXIMUM DEPTH IS APPROXIMATELY 0.022" WITH A MAXIMUM DIAMETER OF 0.8. AN APPROXIMATE LOCATION OF THE DAMAGE IS AT STA. 4600MM, W.L. 2465MM, AND SDR VNAA20260511032Seat Track · corrodedLH SIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 785 AND FS 863. INSTALLED NEW LH SIDE SEAT RAIL AT STGR 15L BETWEEN FS 785 AND FS 863 PN SH670-36260-5 IAW CRJ 700 AMM 53-00-49-400-801-A03SDR VNAA2026041500002Sleeve · chafedLH MLG IB PISTON AXLE HAS CHIPPED METAL AT EDGE OF BRAKE UNIT ASSEMBLY BEARING SURFACE.SDR VNAA20260329002Angle · corrodedCORROSION ON KICKPLATE ANGLE BTW FS310.0 TO FS 349.0 (DOOR SILL AREA) AT PASSENGER DOOR SURROUND STRUCTURE. KICKPLATE ANGLE BTW FS310.0 TO FS 349.0 (DOOR SILL AREA) AT PASSENGER DOOR SURROUND STRUCTURE WAS REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR VNAA20260329001Angle · corrodedCORROSION ON MID CAP ANGLE BTW FS310.0 TO FS 349.0 (DOOR SILL AREA) AT PASSENGER DOOR SURROUND STRUCTURE. MID CAP ANGLE BTW FS310.0 TO FS 349.0 (DOOR SILL AREA) AT PASSENGER DOOR SURROUND STRUCTURE WAS REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01.SDR AALA202603177427Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOWER SILL AT LEVEL FRAME 68RH SIDE AFT GALLEY AREA, MEASURES ARE L=3.345 INCH; W= 1.029 INCH; D=0.022 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR LOC. ON LOWER SILL FLANGE CUTOUT AT LEVEL FRAME 68RH SIDE AFT GALLEY ARESDR SCNA20260310119Channel · damagedAFT CARGO LH AND RH SIDES STA 727I HAS OVERSIZED HOLES AT ZEE CHANNEL - - C\W EA 26002 REV IR FUSELAGE / FRAME WEB IB CHORD / AT BSTA 787 / BTW S-25L & S-26L / OVERSIZED HOLES FAS#4686SDR SCNA20260310118Channel · damagedAFT CARGO LH AND RH SIDES STA 727J FRAME HAS OVERSIZED HOLES AT ZEE CHANNEL -- C\W EA 26001 REV IR FUSELAGE / FRAME WEB IB CHORD / AT BSTA 747 / BTW S25L & S-26L AND BTW S-25R & S-26R / OVERSIZED HOLES
FAS#4686SDR SCNA20260310117Frame · damagedAFT CARGO LH AND RH SIDES STA 767 FRAME HAS OVERSIZED HOLES AT ZEE CHANNEL - - REMOVED AND REINSTALLED AFT CARGO FLOOR PANELS IAW B737 AMM 25-52-10 FAS#4686SDR SCNA20260310116Frame · damagedFAS#4686 AFT CARGO RH SIDE STA 727H FRAME HAS OVERSIZED HOLE AT ZEE CHANNELS. C\W EA 26009 REV IR FUSELAGE / FRAME WEB IB CHORD / AT BSTA 727I / BTW LH AND RH S-25 & S-26 / OVERSIZED HOLES FAS#4686SDR IPXA2026021832434Seat Track · corrodedMAJOR REPAIR, MAIN DECK FLOOR STRUCTURE ON FR 80/82 AT Y1137.1 SEAT TRACK HAS CORROSION DOT 115-054. ATTACH CASS AUDIT FORMSDR VNAA20260304002Hinge Fitting · corrodedCORROSION ON HINGE FITTING AND HINGE ARM AT ACCESS PANEL 196ER WAS REMOVED PER SRM 51-21-06-001-A01 EVAL WITHIN LIMITS BUT REPLACEDSDR VNAA20260304001Drag Angle · crackedCRACK ON VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT LH DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00) DRAG ANGLE WAS REPAIRED PER SRM 55-31-00-201-001-A01SDR HNAA2026030400186Frame · damaged00097 AFT CARGO FRAME 64 RH, STR 8R, HAS DAMAGE, COMPLIED WITH PERMANENT REPAIR TO AFT CARGO 1EA FR 64 R/H STR 8R PER ETD 2025-145-002400 REV.:/ AND EO1-53-26-0084.SDR HNAA2026030400185Access Panel · crackedTAIL CONE / OIL SERVICE ACCESS PANEL / CRACKED ACCESS PANEL AREA / AT HINGE. COMPLIED WITH PERMENANT REPAIR OF THE APU COWLING OIL SERVICE DOOR CUTOUT MOLDING PER PIEDMONT AIRLINES ESR P/111585 REV: 12JULY22, AND EMB 145 SRM 53-32-23-RE ITEM 3 FIGURE 202, ANDSDR SCNA20260227105Channel · damagedAFT CARGO LT AND RT SIDES BS 747 FRAME HAS OVERSIZED HOLES AT ZEE CHANNEL.SDR SWAA2026022363845Fitting · looseAFT SERVICE DOOR AFT SLIDE GIRT BAR FITTING LOOSE. REMOVED AND REPLACED 2EA FASTENERS AFT SERVICE DOOR AFT SLIDE GIRT BAR FITTING IAW SRM 51-40-02.SDR SWAA2026022363866Light · damagedLAVATORY A EXIT CEILING LOWER LIGHT DAMAGED. REMOVED FWD ENTRY LOWERED CEILING. REMOVED AND REPLACED LAVATORY A EXIT LIGHT ASSY IAW AMM 33-51-01-960-802. OPS CHECK GOOD IAW AMM 33-51-00-710-801. REINSTALLED THE CEILING CLOSEOUT PANEL IAW AMM 25-21-71-400-8SDR AALA202602202825Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FRAME AT BS 230 AND S23L. REPLACED FRAME PER AARD 51-00-05-1.SDR AALA202602205732Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FRAME AT BS 356 AND S23L. REPLACED FRAME PER AARD 51-00-05-1.SDR AALA202602202015Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AUXILIARY DOOR SILL OUTER CHORD BETWEEN BS 310 AND BS 352 ALONG S23L. REPLACED CHORD PER EA 372019.SDR AALA202602202605Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL BETWEEN BS 310 AND BS 340 ALONG S23L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR CALA2026021913903Frame · crackedVISUAL INDICATION OF CRACK IN CABIN FRAME AT BS 380 BTWN S8 - 9R, INBD OVERHEAD BIN ATTACH BRACKET FASTENER. REPAIRED THE DAMAGE IN THE FRAME IAW ECRA 5310-07665.SDR SWAA2026021863556Floor Support · crackedCRACKED FLOOR SUPPORT, BS 380 - 400, LBL 15, WL208.1. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, AND DWG 143A5400, SHEET 182, & 184, REV-.SDR SWAA2026021863555Floor Support · crackedCRACKED FLOOR SUPPORT BTW BS 380 - 400, BL 0, WL 208.1. REPLACED FLOOR SUPPORT IAW SRM 51-10-02-0G-0, ITEM 9, & DWG 143A5400, SHEET 182, & 184, REV-.SDR SWAA2026021863961Access Panel · damagedELONGATE HOLES ON ACCESS PANEL 193AR BODY FAIRING, LOWER FUSELAGE. REPAIRED THE ACCESS PANEL 193AR IAW SRM 51-70-05-2R-9, REPAIR 9.SDR SWAA2026021863962Access Panel · damagedELONGATE HOLES ON ACCESS PANEL 193AL ON THE BODY FAIRING AT LOWER FUSELAGE. REPAIRED ACCESS PANEL 193AL BODY FAIRING IAW SRM 51-70-05-2R-9, REPAIR 9.SDR ASAA2026012264384Rib · crackedR/H HORIZONTAL STAB RIB 182A5304 AT STAB STA 129.50 HAS MULTIPLE CRACKS. GROUNDED - YES. REPAIRED R/H HORIZONTAL STAB RIB 182A5304 AT STA 129.50 IAW B737800 SRM 55-10-09-2R-4 + 55-10-09-2R-5.SDR ASAA2026012264383Rib · crackedL/H HORIZONTAL STAB RIB 182A5304 AT STAB STA 129.50 HAS MULTIPLE CRACKS. GROUNDED - YES. REPAIRED L/H HPRIZONTAL STAB RIB 182A5304 ST STAB STA 129.50 IAW B737-800 SRM 55-10-09-2R-4.SDR CALA2026021813852Flap Track · wornFLAP TRACK NR 7 HAS WEAR ON THE UPPER RAIL. REPAIRED THE FLAP TRACK UPPER RAIL IAW SRM 57-53-02-2R-10, REP 10, (REPAIR IS A CATEGORY B) INSPECTION REQUIREMENTS IAW STEP 5 TABLE 202 . ALL WORK CAPTURED ON AAR N/R 1000065135. REPLACED THE NR 7 FLAP TRACK ASSDR SWAA2026021163584Angle · crackedCRACKED ANGLE, ORSS 271, RT WING T/E. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2930, SHEET 8, REV -.SDR SWAA2026021163587Plate · crackedCRACKED CORRUGATED PLATE, ORSS 261, LT WING T/E. REPLACED THE CORRUGATED PLATE IAW SRM 51-40-02, AND DWG 115A2001, SHEET 29, REV-. CRACK LENGTH: 0.830'.SDR SWAA2026021163588Angle · crackedCRACKED ANGLE, T/E ORSS 271, LT WING. REPLACED THE ANGLE ON LT WING IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 115A2930, REV-, SHEET 7.SDR SWAA2026021163583Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE ORSS 241, RT WING. REPLACED THE CORRUGATED PLATE T/E ORSS 241, RT WING AND FASTENER IAW SRM 51-40-02, & DWG 115A2001, SHEET 30, REV A, AND SRM 51-10-02, ITEM 9.