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 SCNA20260105003Lamp · inoperativeAFT L/H EXTERIOR OVERWING EXIT EMERGNECY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT LT EXTERIOR OVERWING EXIT EMERGENCY LIGHT LAMP IAW AMM 33-51-04-960-801. OPS CHECK GOOD AT THIS TIMESDR CALA2026010412640Door · missingUPON ARRIVAL, FOUND THE RIGHT WING THERMAL ANTI-ICING DUCT SEAL DOOR ASSEMBLY MISSING.SDR DALA2026010500053Module · faultedATO, AT 85KTS DUE TO AN F/O AIRSPEED INDICATION ERROR. REPLACED NR 2 PITOT PROBE AIR DATA MODULE. (LP: 8060718)SDR DALA2026010500050Oxygen Bottle · expiredEXPIRED DUE DATE HYDROSTATIC TEST OXYGEN BOTTLE IN FWD CLOSET RH AT PASSENGER CABIN. REPLACED OXYGEN BOTTLE IN FWD CLOSET RH AT PASSENGER CABIN AS PER DWG DELTA AIR LINES 25-5429 REV: E ISSUE DATE: 21-JAN-15 SHEET 9 OF 24 ITEM 31 JOB COMPLETE. (LP: 1385818)SDR JR2R20260104015Floor Support · corrodedEXISTING DOUBLER ON FLOOR SUPPORT AT RBL 11 BETWEEN FRAME 87-88 IS CORRODED OUT OF LIMITS, REPAIRED.SDR DALA2026010400041Unknown · odorFUME EVENT AT GATE, APU ON WITH BLEED ON. SMELLED OF BURNING RUBBER IN FLIGHT DECK AND FRONT GALLEY. PAX ON BOARD. DURATION WAS LESS THAN 30 SEC BEFORE BLEED WAS TURNED OFF.SDR JR2R20260104077Skin · chafedRIGHT HAND WING, FIXED LEADING EDGE OVER PYLON HAS AN EXISTING REPAIR WITH CHAFE MARKS OUT OF LIMITS. REPAIREDSDR JR2R20260104069Skin · chafedLEFT HAND WING, FIXED LEADING EDGE OVER PYLON HAS AN EXISTING REPAIR WITH CHAFE MARKS OUT OF LIMITS. REPAIREDSDR IXXA20260104002Structure · damagedAREA 1 HAS CRACK INDICATION WHILE PERFORMING BS1809.5 HFEC OPEN HOLE SCANS PER ATI-EO-5300-767-07548, SB 767 53A0078 REV 6, FOUND DEFECTIVE HOLE AREA 1 THE LWR AFT HOLE WAS MISSING MATERIAL. REF 8100-9 202512125726-0004, TIN-TIN 25-0256-01CSDR IXXA20260104001Frame · chafedRIGHT WING OTBD FLAP FAIRING 672BB T/E FRAME IS CHAFEDSDR AALA202601044291Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR SWIA2026010375821Intercostal · corrodedPASSENGER DOOR DD6 INTERCOSTAL HAS CORROSION BETWEEN FORMER FS329.76 & FORMER FS338.963. REMOVED AND INSTALLED NEW PAX DOOR DD6 INTERCOSTAL PN 601R318057-1 PER CRJ 200 SRM 51-42-06 AND DWG 601R31902 REV BW. LEAK CHECK GOOD COMPLIED WITH SKYWEST SKY CARD 51-90SDR SWIA2026010375811Floor Support · corrodedFLOOR BEAM AT LBL9 BETWEEN APPROX. FS559 - FS559+20 HAS MULTIPLE SPOTS OF CORROSION (C-CHECK RO 04/17/2026)REPAIRED FLOORBEAM AT LBL9 BETWEEN FS559 AND FS559+20 PER REO 601R-53-41-3389 REV -- DATED 2026-02-09 AND REO 601R-53-00-005 (REV B) DATED 2011-01-06. SDR SWIA2026010375797Former · corrodedPASSENGER DOOR FORMER FS329.41 HAS CORROSION AT MID DD4 INTERCOSTAL REMOVED AND INSTALLED NEW PAX DOOR FS329.41 FORMER PN 601R318088-3 PER SRM 51-42-06 AND DWG 601R31902 REV BW. LEAK CHECK GOODSDR SWIA2026010375796Floor Support · corrodedFLOOR BEAM AT RBL9 BETWEEN APPROX. FS559+80 - FS559+32 HAS MULTIPLE SPOTS OF CORROSION. REPAIRED FLOOR BEAM RBL9 BETWEEN APPROX. FS559.+32 - FS559+80 REF SRM 51-42-34 AND REO 601R-53-51-730 REV--SDR SWIA2026010375792Intercostal · corrodedPASSENGER DOOR MID DD4 INTERCOSTAL HAS CORROSION. REMOVED AND INSTALLED NEW MID DD4 INTERCOSTAL PN 601R318081-13 TO PAX DOOR REF SRM 51-42-06 AND SRM 51-42-21 AND DWG 601R31902 REV BW. LEAK CHECK GOOD.COMPLIED WITH SKY CARD 51-900-1003-SKYSDR COEA2026031002801Stringer · corrodedAFT AVIONICS BAY, FRAMES 45-46 STRINGER 8R HAS LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER ATR72 SRM 530000-300-824-A01 REV. 121.SDR AALA202602091323Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #2 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 SWAA2026020357892Strap · corrodedCORROED STRAP, BTWN BS 847 - 853, RBL 20, WL 155.8. REPLACED THE STRAP AND FASTENERS IAW SRM 51-10-02, ITEM 9, 51-40-02-0G-0, AND DWG 146A0081, SHEET 31, REV -.SDR SWAA2026020358000Frame · crackedCRACKED FRAME, BS 440, BTW S8 - 9R. PERFORMED A PERMANENT REPAIR ON THE FRAME IAW EA 26-153-00093-WIP1, EA 26-153-00093-WIP2, AND SUMMARY 26-153-00093.SDR SWAA2026020358001Shield · corrodedCORRODED SHIELD WEB, BTW BS 492.4 - 500A, RBL 22, WL 152.7, IN THE FWD CARGO BAY, REPLACED THE SHIELD WEB AND FASTENERS IAW SRM 51-40-02, AND DWG 143A0080, SHEET 23, REV-.SDR SWAA2026012957894Frame · crackedCRACKED FRAME, BS 440, S8 - 9L. REPAIRED THE FRAME IAW EA 26-153-00085-WIP1, 26-153-00085-WIP2, & SUMMARY 26-153-00085.SDR SWAA2026012957999Frame · crackedCRACKED FRAME, BS 400, S8 - 9R. REPAIRED THE FRAME IAW 26-153-00066-WIP1, 26-153-00066-WIP2, & SUMMARY 26-153-00066.SDR SWAA2026012957893Frame · crackedCRACKED FRAME, BS 400 S8 - 9L. REPAIRED THE FRAME, BS 400 S7 - 9L IAW EA 26-153-00091-WIP1, 26-153-00091-WIP2, & SUMMARY 26-153-00091.SDR SWAA2026012957886Strap · corrodedCORROSION STRAP LOCATED BETWEEN BS 842 - 847, RBL 20, WL 155.8 IN THE AFT CARGO BAY. REPLACED THE STRAP & FASTENERS IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, & DWG 146A8340, SHEET 24, REV A.SDR SWAA2026012957884Support Angle · corrodedCORROSION ON SUPPORT ANGLE LOCATED BTW BS 767 - 787, RBL 21, WL 156.1 IN THE AFT CARGO COMPARTMENT. REPLACED SUPPORT ANGLE & FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, & DWG 146A8123, SHEET 16, REV-.SDR SWAA2026012957889Shield · corrodedCORROSION SHIELD WEB LOCATED BS 767 - 794, RBL 21 AND WL156 AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 146A0081, SHEET 31, REV -.SDR SWAA2026012857873Crossbeam · crackedCRACKED CROSSBEAM, BS 540, BL 0 - RBL 24.75. REPLACED CROSSBEAM IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A0060, SHEET 36, REV A.SDR SWAA2026012857874Crossbeam · crackedCRACKED CROSSBEAM BS 540, BL 0 - LBL 24.75. REPLACED CROSSBEAM IAW SRM 51-40-02, AND DWG 143A0060, SHEET 36, REV A.SDR SWAA2026012857876Support Angle · crackedCRACKED SUPPORT ANGLE BS 695, RBL 24.75. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 273A9110, SHEET 6, REV A.SDR SWAA2026012857983Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 561CB, T/E, LT WING. REPAIRED THE ACCESS PANEL 561CB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012757877Floor Support · crackedCRACKED FLOOR SUPPORT, OTBD SIDE, BS 695 BL 0. REPLACED FLOOR SUPPORT AND FASTENERS IAW SRM 51-40-02-0G-0, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2026012757879Floor Support · crackedCRACKED FLOOR SUPPORT, BS 695, BL 0. REPLACED THE FLOOR SUPPORT AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 273A9110, SHEET 6, REV A.SDR SWAA2026012757880Floor Support · crackedCRACKED FLOOR SUPPORT OTBD SIDE, BS 695, BL 0. REPLACED FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DRAWING 273A9110, SHEET 6, REV A.SDR IPXA2026011240212Strap · corrodedBS 1787.45, CORROSION ON THE UNDERSIDE OF THE APU DOOR SURROUND STRUCTURE FROM S3 - 6R. INSTALLED A NEW FWD STRAP IAW SRM 51-40-02-0G-0.SDR IPXA2026011740349Tee Fitting · corrodedCORROSION FOUND AT WTB T-FITTING FROM BS 1180 TO 1240 RBL 63 INSTALLED NEW T-FITTING IAW SRM 51-40-02-0G.SDR SWAA2026012657849Seat Track · corrodedPASSENGER CABIN SEAT TRACK CORRODED, RBL 25, BS 380 ON CROWN & WELL, BS 380+14 IN WELL, BS 400+4 IN WELL, BS 400+14 IN WELL, BS 420+4 ON CROWN, BS 440+2 IN WELL, BS 440+13 IN WELL, WL 208. SRM 53-00-52-1A-1 IS APPLICABLE ALLOWABLE DAMAGE. REMOVED CORROSISDR SWAA2026012657685Plate · crackedCRACKED WIGGLE PLATE ASSY, IRSS 199+13, LT WING REAR SPAR. REMOVED THE WIGGLE PLATE IAW SRM 51-40-02-0G-0. RECEIVED A NEW WIGGLE PLATE, AND INSTALLED IAW SRM 51-40-02-0G-0.SDR VNAA202601170008Access Panel · corrodedCORROSION ON ACCESS PANELS 542AZ 542BZ 642AZ AND 642BZ CORRODED ON ACCESS PANELS WERE REMOVED PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE EVALUATED OUT OF LIMITS IAW SRM 53-00-00-101-001-A01 AND ACCESS PANELS 542AZ, 542BZ, 642AZ AND 642BZ WERE REPLACED ANSDR AALA202601151550Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSY AT BS 767, RBL 25. REPLACED SHIELD IAW AARD 51-00-05-1.SDR AALA202601158590Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY BETWEEN BS 500B AND BS 500C AT RBL 22. REPLACED BAFFLE ASSEMBLY PER AARD 51-00-05-1.SDR SWAA2026011458018Panel · crackedFLOOR BRAKE PANEL BS 540, LBL 1, WL 208 CRACKED. REMOVED AND INSTALLED A NEW BRAKE PANEL IAW SRM 51-40-02, AND DWG 143A0060, REV A.SDR SWIA2026011300003Warning Message · illuminatedLEFT REVERSER UNLOCKED IN CLIMB. MEL 78-30-1 CAT: C. : REF FIM 78-30-00 FIG. 103 FOR TROUBLE SHOOTING (FLIGHT 5029) DEFERRED PER MEL 78-30-1 MX ACTION C/W AIRCRAFT OK FOR CONTINUED SERVICE. REFERENCE CP 31495856 AND CP31495864 FOR ALL WORK COMPLETED. DMISDR REXA2025011101087Floorbeam · crackedTHE LH LOWER CORROSION CAP ANGLE PN CC670-34096-2 ON THE RH FS 280 BULKHEAD IS CRACKED. REMOVED FS 280.00 BULKHEAD LH CAP ANGLE IAW CRJ-900 SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01. LOCATED AND DRILLED NEW FS 280.00 LH CAP ANGLE P/N: CC670-34096-2S, SDR DALA2026010900240Seat Track · corrodedFOUND CORROSION ON RT INB SEAT TRACK. REPAIRED SEAT TRACK PER B717 SRM 53-20-52 (1383323)SDR CALA2026010812798Bracket · gougedPOTABLE WATER SERVICE PANEL, HAS 2EA LATCH BRACKETS WITH GOUGES. REPAIRED POTABLE WATER SERVICE PANEL LATCH BRACKETS PER EC/RA# 5 360-02082. REF NRC 139021. INSPECTION APPROVEDSDR G41A2026FA0000007Warning Light · illuminatedON SATURDAY 1/3/2026, N198HB CYO198, DEPARTED KERI HEADING TO KECP. DURING CLIMB, THE PRESSURIZATION SYSTEM DUAL BLEED AIR WARNING LIGHTS ILLUMINATED. THE CAPTAIN DECIDED TO DIVERT/RETURN TO KERI. LOCAL MAINTENANCE WAS CALLED AND ENGINE RUNS WERE COMPLETED FORSDR DALA2026010700156Bag · fireFUMES/FIRE - CREW REPORTED A BURNING SMELL IN CABIN DURING BOARDING. CORRECTIVE ACTION: FOUND PASSENGER BAG ON FIRE IN FWD CARGO. SAME REMOVED. R/R RECIRCULATION FILTERS. (L/P# 7699338)SDR AALA202601073134Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: THE CABIN FLOORBOARD SUPPORT CRACKED AT BS 540 LBL2. INSTALLED NEW ANGLE. PER AARD 51-00-05-1, AIPC 53-42-11-66 AND SRM 51-40-02.SDR AALA202601073559Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOORBOARD SUPPORT CRACKED AT BS 540 RBL 2. INSTALLED NEW ANGLE. PER AARD 51-00-05-1, AIPC 53-42-11-66 AND SRM 51-40-02