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 JR2R20251029397Cam · wornAFT CARGO DOOR HANDLE BOX CAMS WORN. REPAIREDSDR FDEA202510292104Light · inoperativeL1 DOOR EMERGENCY EXIT SPOT LIGHT DOES NOT ILLUMINATE. AMM: 33-51-13-04 SERVICED L1 DOOR EMERGENCY LIGHT OPS GOOD OK FOR SVC.SDR FDEA202510292103Windshield · failedIN FLIGHT AT FL 340 OFFICERS FRONT WINDSHIELD SHATTERED. EMERGENCY DECLARED. REMOVED AND INSTALLED FO #1 WINDOW UP TO AND INCLUDING 3.G.(31). AND STEPS 3.G(34)-3.G.(40).SDR FDEA202510292102Floor Panel · damagedFLOOR PANEL #231HF AT LEFT BS 595 TO 675 SURFACE FOUND DAMAGED. DAMAGED FLOOR PANEL #231HF AT CABIN LEFT HAND STATION 595 TO STATION 675 REMOVED AND REPLACED IAW AMM 53-25-04-4. FLOOR PANEL #231HF FABRICATED AS PER DRAWING SRZ-25-005 REVISION R. REPAIR CLASDR UIEA2025102801284Attach Fitting · missingAIRCRAFT EXTERIOR: DURING ACCOMPLISHMENT OF TASK CARD A-53-406-00-00. FOUND LEFT HAND OVER WING EMERGENCY EXIT HINGED DROP-DOWN STEP WITH OUTER STEP SUPPORT CABLES UNATTACHED FROM DOOR DUE TO MISSING ATTACH FITTINGS FROM STEP. MISSING UPON AIRCRAFT ARRIVAL. LTSDR 2025F00252Attach Bracket · misinstalledLH ENGINE FIXED COWL FORWARD LOWER ATTACHMENT BRACKET INSTALLED INCORRECTLY (180 DEGREES/WRONG WAY AROUND).SDR DALA2025102907909Engine · bird ingestionBIRD STRIKE IN #2 ENGINE ON FINAL APPROACH. NO ABNORMAL ENGINE INDICATIONS. ENGINE WAS AT LOW POWER. SMELLED LIKE FOOD COOKING IN OVEN ACCORDING TO FAS. LATER LATER SMELLED LIKE FRIED CHICKEN. PERFORMED AMM 05-51-14. CLEARED ENGINE OF DEBRIS REF A320 AMM 72-00SDR IXXA20251029001Stub Beam · crackedCHORD STUB BEAM STA 903.5,LBL89, WL200 CRACKED.SDR DXTR2025102901Wire Harness · faultedDURING APPROACH WHILE HANDFLYING, THERE HAD TO BE SIGNIFICANT INPUT IN AILERON TO MAINTAIN LEVEL FLIGHT. FUEL INDICATIONS OF BOTH FUEL FLOW, QUANTITY, AND BALANCE SHOWED NORMAL. DURING INSPECTION OF WIRE HARNESS W110 FROM EFCU TO FUSELAGE PASS THROUGH FOUND SDR REXA2026072701114Lug · corrodedWEAR AND CORROSION IN ALL BORE LUGS (R1,R2,R3,R4,R5,R6) AT CENTER HINGE FITTING AND HINGE 4 LUG UPPER OF AILERON WAS FOUND. BORE LUGS R1, R6 & HINGE 4 LUG UPPER WERE CLEANED PER CRJ 900 SRM 51-26-00-001-001-A01 AND NO DAMAGE FOUND. LUGS R3 Y R4 WERE REPAIRED PSDR REXA2026051200559Support · crackedINTERNAL LOWER ANGLE OF EXTERNAL POWER RECEPTACLE SUPPORT STRUCTURE IINTERNAL LOWER ANGLE OF EXTERNAL POWER RECEPTACLE SUPPORT STRUCTURE WAS REPLACED PER SRM 51-42-06-001-001-A01 AND SRM 51-42-10-001-001-A01 TO GAIN ACCESS EXTERNAL AC POWER RECEPTACLE P/N: MS9SDR REXA2026051200549Web · crackedPASSENGER DOOR BELOW TOP STEP WEB IS CRACKED ON AFT SIDE TOP STEP WEB ON AFT SIDE OF PASSENGER DOOR WAS REPAIRED PER SRM 52-11-04-201-006-A01SDR REXA2026051200548Support · crackedCRACK ON MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND RBL 34). MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE RH (FS 797.00 AND RBL 34) WAS REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01SDR REXA2026051200547Hinge · crackedCRACK AT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT WERE REMPLACED PER CRJ-900 SRM 51-42-06-001-001-A01.SDR REXA2026051200546Hinge · crackedCRACK AT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT WERE REMPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR REXA2026051200545Hinge · crackedCRACK AT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT FWD / MIDDLE & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT WERE REMPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR REXA2026051200544Stop · crackedBROKEN STOPPERS 2 EAS OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT STOPPERS 2 EAS OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT WERE REPAIRED PER EA NO. CRJ953-20779 REV. IR AND EA NO. CRJ953-20769 REV. IRSDR REXA2026051200543Stop · crackedBROKEN STOPPERS 2 EAS OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT STOPPERS 2 EAS OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT WERE REPAIRED PER EA NO. CRJ953-20779 REV. IR AND EA NO. CRJ953-20769 REV. IRSDR REXA2026051200542Attach Angle · crackedCRACK ON ATTACHMENT ANGLE INNER SKIN-TO-AFT SIDE PANEL AT PASSENGER DOOR EXTERNAL STRUCTURE ANGLE INNER SKIN-TO-AFT SIDE PANEL AT PASSENGER DOOR EXTERNAL STRUCTURE WAS REPAIRED PER CRJ-900 SRM 52-11-04-201-002-A01SDR IPXA2025120897297Strap · corrodedAPU INLET DUCT HAS EVIDENCE OF CORROSION AROUND NUT PLATES. REMOVED AND REPLACED SUPPORT ANGLES AND STRAP IAW DWGS 148N3152, 148N3141, 148N3138, AND 148N3105 IAW SRM 51 GUIDELINES, IAW GMM REV 12 SECTION 09-08.SDR SWIA2025121200028Floorbeam · corrodedUNDER FLOORBOARD 232BRF RT FLOOBEAM FROM RBL 12 TO OTBD SILL SIGNS OF CORROSION AT BS 333. PERFORMED REPAIR ON THE RT FLOORBEAM IAW AMM 20-70-00, SRM 51-42-21, 51-21-06, REO 670-53-21-2733, REV--(P1) & REO 670-53-21-2733 REV-. PERFORMED INSPECTION.SDR REXA2025121201017Frame · corrodedCORROSION ON FRAME FS 1051.30 AND STRINGERS 23RH-24RH OF FUSELAGE STRUCTURE AT AFT CARGO COMPARMENT. CORROSION ON FRAME FS 1051.30 AND STRINGERS 23RH-24RH OF FUSELAGE STRUCTURE AT AFT CARGO COMPARMENT. WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01, EVALUATSDR SWAA2025120429674Seal Plate · crackedCRACK SEAL PLATE LOCATED ON ACCESS PANEL 434CL ON LT PYLON. REPLACED SEAL PLATE ON ACCESS PANEL 434CL IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02.SDR SWAA2025120429673Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561BB TRAILING EDGE ON THE LT WING. REPAIRED THE ACCESS PANEL 561BB TRAILING EDGE, LT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025120429669Angle · crackedCRACK ANGLE, BS 400, S26L, FWD CARGO BAY, REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7505, SHEET 2, REV B.SDR SWAA2025120129542Support Angle · crackedCRACKED SUPPORT ANGLE, BS 500D, STRINGER 28R IN THE FWD CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, PARAGRAPH 9, & DRAWING 143A7902, SHEET 126, REV A.SDR SWAA2025120129539Stringer · crackedCRACKED STRINGER 23L, BS 540 IN THE FWD CARGO BAY. REPAIRED THE STRINGER IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2025120129388Fitting · damagedELONGATED HOLES ON FITTING, BS 1016. REPLACED THE FITTING IAW SRM 51-10-02, ITEM 9, SRM-51-40-02-0G, AND DWG 148A2230, SHEET 8, REV C.SDR SWAA2025120129127Angle · crackedCRACKED ANGLE, LOCATED BS 500C AT LEVEL S26R IN FWD CARGO COMPARTMENT. THE CRACKED ANGLE WAS RESOLVED ON ANOTHER FAULT TTG8Q015ZPF7.SDR SWAA2025120129664Rib · crackedRIGHT HORIZONTAL STABILIZER NR 6 INSPAR RIB AT STABILIZER STATION 138.70; 3RD VERTICAL STIFFENER IS CRACKED. PERFORMED REPAIR AT HORIZONTAL STABILIZER NO 6 INSPAR RIB STABILIZER STATION 138.70 3RD VERTICAL STIFFENER IAW SRM 55-10-09-2R-4, REPAIR 4.SDR CALA2025112811576Vapor Barrier · crackedLH VAPOR BARRIER BETWEEN LBL 5" - 14" SEVERAL AREA CRACKED. PERFORMED STOP HOLES AT CRACK ENDS ON LT VAPOR BARRIER CRACKS PER SRM 51-10-02-0G-0, CLEANED AREA PER SOPM 20-30-03 & ACCOMPLISHED FIBERGLASS REPAIR PATCH PER SRM 51-10-02-0G-0.SDR SWIA20251126028Slide · damagedR1 EMERGENCY EVACUATION SLIDE IS SHOWING DAMAGE ON BRACKET. (C-CHECK). REPLACED R1 EMERGENCY EVACUATION SLIDE WITH A NEW SLIDE IAW AMM 25-65-01.SDR HNAA2025112500814Seat Track · corrodedCORROSION ON LH OTBD #1 SEAT TRACK. RAR LH OUTB SEAT TRACK #1 IAW EMB 145 AMM 53-01-06.SDR HNAA2025112500813Floor Support · corrodedCORROSION IN GALLEY AREA ON CENTER FWD DIGITAL. ACCOMPLISHED REPAIR OF GALLEY AREA CENTER FWD DIGITAL IAW EMB 145 SRM 53-21-10 ITEM 2 FIGURE 201 SHEET 1.SDR HNAA2025112500812Floor Support · corrodedCORROSION IN GALLEY AREA ON PASSENGER DOOR ENTRY AFT FLOORBOARD SUPPORT. R & R PASSENGER DOOR ENTRY AFT FLOORBOARD SUPPORT IAW EMB 145 SRM 51-40-02SDR HNAA2025112500811Door Sill · corrodedCORROSION ON SERVICE DOOR CENTER SILL. BLENDED CORROSION ON SERVICE DOOR CENTER SILL IAW SRM 51-10-03. UPON FURTHER INVESTIGATION FOUND THE BLENDED AREAS TO BE PREVIOUSLY REPAIRED IAW EMB 145 SRM 53-21-02-RE ITEM 2 FIG. 201. REMAINING THICKNESS OF BLENDED ARESDR HNAA2025112500810Floor Support · corrodedCORROSION ON SERVICE DOOR AFT FLOOR SILL. R & R SERVICE DOOR AFT FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025112500809Gusset · corrodedCORROSION IN GALLEY AREA ON RH DIAMOND GUSSET AT FRAME 22. RAR DIAMOND GUSSET ON RH AT FRAME 22 IAW EMB 145 SRM 51-40-02.SDR HNAA2025112500808Floor Support · corrodedCORROSION IN GALLEY AREA ON LH OTBD NR 1 FLOOR SILL. R & R LT OUTBOARD NR 1 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025112400790Window Post · crackedWINDSHIELD CTR POST CRACKED ON BOTTOM END. R & R CTR POST IAW SRM 53-12-01SDR SWAA2025112029184Floor Panel · corrodedFWD CARGO FLOOR PANEL 120DF HAS SURFACE CORROSION ON RT EDGE. REMOVED PANEL 120DF IAW AMM 25-52-10. INSTALLED FWD CARGO PANEL 120DF IAW AMM 25-52-10. INSTALLED FWD CARGO PANEL 120DF PER AMM 25-52-10.SDR SWAA2025112029386Attach Angle · crackedCRACK FOUND ON BS 663 LT ATTACH ANGLE, LBL 34. REMOVED TANK FASTENERS FROM LBL 34 TO LBL 65. CUT AND REMOVED DAMAGED SECTION OF ATTACH ANGLE IAW SRM 57-10-10-2R-5. CW NDT INSPECTIONS OF HOLES COMMON TO REPAIR IAW PART 6 51-00-00. PROCEDURE 16, AND PERFORMSDR SWAA2025112029387Attach Angle · crackedCRACK FOUND ON BS 663 RT ATTACH ANGLE, RBL 34. REMOVED DAMAGED SECTION OF RT STA 663 ATTACH ANGLE FROM APPROX RBL 24 TO RBL 65. COMPLIED WITH STEP 2, COMPLIED WITH REMAINING FASTENER HOLE INSPECTION AT REPAIR HOLES IAW NDT PART 6 51-00-00, PROCEDURE 16. NO SDR SWAA2025112029497Stiffener · crackedNR 2 ENGINE OTBD FAN COWL 424AR, SHELF STIFFENER CRACKED. REMOVED AND REPLACED STIFFENER IAW SRM 51-40-02.SDR SWAA2025112029146Angle · crackedCRACKED ANGLE, BS 500I, STR 28R IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-40-02, AND DWG 143A7902, SHEET 301, REV A.SDR SWAA2025112029147Angle · crackedCRACK ANGLE LOCATED BS 500I & STR 28L AT FWD CARGO COMPARTMENT. REPLACED THE ANGLE IAW SRM 51-40-02 AND DWG 143A7902, SHEET 301, REV A.SDR 2025FA0000774Cable · chafedDURING AIRCRAFT INSPECTION FOUND THAT THE LEFT ENGINE ALTERNATE AIR CABLE HAD CHAFED INTO THE ENGINE MOUNT REQUIRING IT TO BE SENT FOR REPAIR. THE WAY THE CABLE IS ROUTED AND SECURED FROM THE FACTORY IS WITH ADEL CLAMPS AND SILICONE UNDER THE CABLE. OVER TIME SDR JJBA20251120079Floorbeam · corrodedRH FLOOR BEAM SILL DOUBLER AT FR20, STR 16R HAS CORROSION. FABRICATED DOUBLER. PREPPED, CLEANED, AND APPLIED ALODINE. INSTALLED RH FLOOR BEAM SILL DOUBLER AT FR20, STR 16LSDR HNAA2025111900753Beam · crackedTWO BEAMS FOR SPC SUPPORT CRACKED BTW FRAMES 7-8 NEAR STRINGERS 20L AND 20R. REPLACED THE BEAMS IAW SRM 51-40-02.SDR SWAA2025111829679Rib · crackedCRACK LEADING EDGE RIB LOCATED LE STA 95.96 RT HORIZONTAL STAB. REPLACED RIB AND FASTENERS LOCATED ON LEADING EDGE LE STA 95.96 AT RT HORIZONTAL STABILIZER IAW SRM 51-40-02-0G-0 AND DRAWING 186A1001, SHEET 10, REV A.