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 DALA2025111708385Girt Bar · damagedSHIP 5803 AA. AD. INITIAL INSPECTION: AFT FLOOR FITTING DOES NOT GET THE MINIMUM ENGAGEMENT DIMENSION FOR THE GIRT BAR SLIDER AT L1 DOOR IN REF. AMDS 2561-01257-01A STEP 14 B. CORRECTIVE ACTION. GIRT BAR 1L, 4L & 4R WERE REPAIR PER PRI 630301-14 REV 1 AND ERA SDR DALA2025111708383Door · corrodedSHIP 5657 MID LAV SERVICE DOOR 121AL HAS CORROSION ON INTERIOR SIDE, BOTTOM EDGE OF PANEL. CORRECTIVE ACTION: BLENDED CORROSION ON RH LAV ACCESS DOOR 121AL, PANEL OUT OF LIMITS PER B757-200 SRM 52-40-01 FIG 101 DETAIL II. REPAIRED DOOR PER PRI 630026-14 REV 2 SDR DALA2025111708381Plate · corrodedSHIP 5803 IN REF NRC 00234: CORROSION OUT OF LIMITS ON SIDE PLATE LT SIDE BTW STA 1390 TO STA 1410 PER B757-300 SRM 53-00-53- 1A PROCEDURE.1 AD.1 FIGURE 101 (SHEET 4 OF 9) NOTE. C DETAIL. 9 38757 NDT MANUAL PART. 4 51-00-10 PROCEDURE 2. CORROSION LEVEL 2. SIDSDR HNAA2025111700739Cabin Pressure · faultedCABIN ALTITUDE WAS AT 300 CABIN RATE DIDNT INCREASE IN CLIMB IN AUTO MODE. PERFORMED FUNCTIONAL TEST OF PRESSURE CONTROL SYSTEM IN AUTOMATIC MODE PER AMM 21-31-00. CHECKED GOOD, NO DEFECTS NOTED AT THIS TIME. CLEAR MEL 21-12-3. PRESS CONTROL AUTO AND MANUSDR AALA202511176812Skin · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON FUSELAGE SKIN AROUND LAVATORY VENT LOCATED AT BS 917, FROM S21L TO S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3.SDR DXTA2025111705702Elec Connector · disconnectedEMERGENCY EXIT SIGN OVER MAIN ENTRANCE DOOR IS NOT WORKING. REMOVED THE EMERGENCY EXIT SIGN OVER MED & FOUND THE ELECTRICAL CONNECTOR WAS JAMMED BETWEEN OVERHEAD PANEL TRIM AND MOUNTING BRACKET. LOOSEN AND RELEASED THE JAMMED LED EMERGENCY LIGHT CONNECTOR, SDR DXTA2025111705710Pump · illuminatedHYD VOLUME LOW CAS MESSAGE DURING FLIGHT. RAN QRH, UNLOADED HYDRAULICS, USED LANDING GEAR BLOWDOWN, AND PULLED EMERGENCY BRAKING HANDLE TO STOP AIRCRAFT ON RUNWAY. CORRECTIVE ACTION: RESET PNEUMATIC OVERRIDE ON THE LANDING GEAR MANIFOLD AND RESET THE EMERGENCYSDR DALA2025111708374Battery Pack · inoperativeEXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE, CAPTS SIDE, FWD OVERWING EXIT. R & R THE M2335 BATTERY PACK IAW AMM 33-51. AS A PRECAUTION, ALSO R & R BATTERY PACK M1694. OP TEST PASSED.SDR DALA2025111708373Battery Pack · no testINTERIOR OVHD EMERGENCY LIGHT EXIT LIGHTS INOPERATIVE AT SEATS 11C & 15C. R & R THE EMERGENCY BATTERY PACKS M2335 AND M1694. OPS NORMAL.SDR JJBA20251117103Oil System · leakingSMOKE ODOR IN COCKPIT & CABIN DURING CRUISE AT FLT LEVEL 220. OPS BOTH PACKS WITH NO FAULTS. FOUND BOTH MUFFLERS TO HAVE TEARS & EVIDENCE OF BURNS. R & R BOTH RECIRC MUFFLERS. PERFORMED OPS CHECK OF PACK SYS. FAULT PERSISTS, RAN PACK 1 & 2 ON BOTH APU & ENGS ISDR CALA2025111711259Smoke Detector · false activationSMOKE ALARM. NO SMOKE NOTICED ALL LAV SMOKE DETECTORS OPS NORMAL, IAW AMM 26-14-00-730-801.SDR CALA2025111711257Power Supply · inoperativeEMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - SEATS 15A,20A,21A EMERGENCY AISLE LIGHT DO NOT ILLUMINATE SLAVED IN NEW POWER SUPPLY ON EMERGENCY EXIT LIGHT BATTERY PACK (M1670) (1673) (M2626) (2503) IAW AMM 33-51-06 NO JOY, OLD POSDR CALA2025111711255Gcu · faultedGENERATOR SOURCE OFF LIGHT, LIGHT COMES ON BUT NO FAULT LIGHT ON GCU ON GEN 2, SOURCE OFF LIGHT. WHILE TESTING AC SYSTEM, GEN & APU MODULE GEN 2 SOURCE OFF LIGHT CAME ON. GEN 1 WAS ON LINE, RESET GEN 2 & SOURCE OFF LIGHT WENT OUT. GCU 2 NOW HAS AN IDG FAULSDR CALA2025111711253Cover · missingROW 20 ABC EMERGENCY EXIT LIGHT AND COVER MISSING. REPLACED MISSING COVER AND EMERGENCY LIGHT IAW AMM TASK 33-51-11-960-801, OPS CHECKED NORMAL REFER TASK 33-51-00-710-801 GOOD TO CONTINUE.SDR CALA2025111711236Circuit Breaker · faultedEMERGENCY EXIT SIGNSILLUMINATED IN CABIN WITH COCKPIT SWITCH INTH E ARMED POSITION PERFORMED CIRCUIT BREAKER RESET. TURNED SEAT BELT SIGN OFF AND TURNED OFF EMERGENCY LIGHTS FROM FLIGHT DECK SWITCH, CABIN EMERGENCY EXIT SIGNS EXTINGUISHED. ARMED EMERGENCY LIGHSDR CALA2025111711235Sign · unsecureOVERHEAD WING EMERGENCY EXIT SIGN IS FALLING OFF THE CEILING. SECURED LIGHT WITH HARDWARE. OPS CHECK EMERGENCY LIGHT REF AMM33-51-01-402. OK FOR SERVICESDR CALA2025111711234Light · no discrepancySELECT EMERGENCY LIGHTS ARE ON WHILE SWITCH IN ARMED POSITION. ACCOMPLISHED EMERGENCY LIGHTS OPS TEST IAW AMM 33-51-00-720-801. OPS TESTED GOOD, ACFT GOOD TO CONTINUE.SDR SCNA20251117440Light · detachedROW 11 ABC SIDE EMERGENCY LIGHT STRIP COMING OFF THE FLOOR. SECURED THE PATH LIGHT STRIP NEAR ROW 11ABC IAW AMM 33-51-15. OPS CHECKED GOOD.SDR SCNA20251117439Retainer · looseL1 DOOR LEFT BRACKET FOR GIRT BAR IS LOOSE. ADJUSTED FORWARD GIRT BAR RETAINER CLIP ON L1 DOOR REF. AMM 25-66-01. OPS CHECKED GOOD.SDR DALA2025111608366Seal · leakingAIRCRAFT 5050, INBOUND FA, REPORTED FUME EVENT ON DECENT AND STATED DIRTY SOCK AND ROTTEN EGG ODOR. CORRECTIVE ACTION: FOUND LEAKING OIL SEEPAGE AT #2 ENG FAN SHAFT SEAL BEHIND SPINNER CONE. REPLACED FAN SHAFT SEAL REF A321 AMM 72-11-01. (LP 8139106)SDR QMLA2025111620114Blade · delaminatedTRIM TAB SECTION ON MRB NR 4 WAS DISCOVERED TO BE DELAMINATED ON POST FLIGHT WALK AROUND. REMOVED AND REPLACED MRB.SDR SWIA2025111476576Hinge · damagedPAX DOOR PIANO HINGE DOOR SIDE AFT LUG AT ROLL PIN HOLE LOCATION FOUND ELONGATED OUT OF LIMITS. INSTALLED NEW PAX DOOR PIANO HINGE ON DOOR SIDE. IAW SRM 52-11-01-201-002-A01, SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. COMPLIED WITH SKY TASK CARDSDR SWIA2025111476567Mount · corrodedFWD INBD MAIN FLOOR MOUNTING BRACKET CORRODED. REMOVED AND REPLACED WITH ONE OF NEW MOUNTING BRACKET. IAW SRM 51-42-21-001-001-A01 AND DWG SH670-32120, REV. D. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY.SDR SWIA2025111476475Hinge · gougedPAX DOOR PIANO HINGE FUSELAGE SIDE AFT LUG LAND IS GOUGE FROM ROLL PIN GREATER THEN 0.080. OUT OF LIMITS REQUIRE REPLACEMENT. REMOVED AND INSTALLED NEW PIANO HINGE ON THE FUSELAGE SIDE. IAW SRM 51-42-21-001-001-A01, SRM 53-21-23-201-007-A01, REVISION 38, &SDR REXA2026052800789Support · crackedCRACK ON RH AFT CORNER AT JB6 SUPPORT OF THE FWD EQUIPMENT COMPARTMENT. JB6 SUPPORT OF THE FWD EQUIPMENT COMPARTMENT WAS REPLACED PER SRM 51-42-06-001-001-A01.SDR SWAA2025111805583Fastener · crackedCENTER TANK RIB CRACKED AT STA 540 25LBL WL 202. BS 540 LBL 25 WL 202. FAULT RESOLVED IN OTHER FAULT SEE TTG8Q018YKSY.SDR VNAA20260511038Seat Track · corrodedRBL 9 SEAT RAIL IS CORRODED BETWEEN FS 485 AND FS 581. INSTALLED NEW SERVICEABLE RBL 9 SEAT RAIL BETWEEN FS 485 AND FS 581 PN SH670-33426-1 IAW CRJ 700 AMM 53-00-49-400-801-A03.SDR VNAA20260511037Seat Track · corrodedRBL 9 SEAT RAIL IS CORRODED BETWEEN FS 349 AND FS 485. INSTALLED RBL 9 SEAT RAIL BETWEEN FS 349 AND FS 485 IAW AMM 53-00-49-400-801-A03.SDR VNAA20260511029Seat Track · corrodedRIGHT SIDE SEAT RAIL AT STGR 15R IS CORRODED BETWEEN FS 485 AND FS 573. INSTALLED SERVICEABLE R/H SIDE SEAT RAIL PN SH670-32234-3 BETWEEN FS 485.00 AND FS 573.00 IAW CRJ 700 AMM 53-00-49-400-801-A03.SDR VNAA20260511002Bracket · corrodedDURING CLEAN-UP OF HARDWARE (FWD FITTING MOUNT) FOUND LWR K-FRAME BRACKET HAS PITTED CORROSION. : REMOVED & REPLACED CORRODED LH LWR K-FRAME BRACKET WITH NEW SERVICEABLE BRACKET (PN CN624-4278-002) IAW CRJ700 AMM 78-36-01-000-801-A01 & 78-36-01-400-801-A01. SDR VNAA20260511001Door Sill · corrodedAFT CARGO DOOR LOWER SILL IS CORRODED. REPAIRED AFT CARGO DOOR LOWER SILL IAW SRM 53-61-23-201-001-A01.SDR VNAA202601180020Bracket · corrodedCORROSION ON SUPPORT LINES WS 38 AT LH TRUNNION AREA WAS FOUND. SUPPORT LINES WS 38 AT LH TRUNNION WAS EVALUATED PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR VNAA202601180014Support Fitting · corrodedCORROSION ON NO. 2 AND 3 HYDRAULIC TUBES-FITTING SUPPORT, AFT OF RIGHT OUTER WING REAR SPAR AT WS24.50. FITTING SUPPORT, AFT OF RIGHT OUTER WING REAR SPAR AT WS24.50 WAS EVALUATE PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACED PER CRJ 900 SRM 51-42-06 001-SDR VNAA202601180009Landing · crackedCRACK ON AFT RH DOOR LANDING AT FS 188.00 (LATCH HOUSING CUT OUT OF ACCESS DOOR 212AR). LATCH HOUSING ON AFT RH DOOR LANDING AT FS 188.00 (CUT OUT OF ACCESS DOOR 212AR) WAS REPLACED PER CRJ 900 SRM 51-42-06-001-001-A01 AND CRJ 900 SRM 51-42-10-001-001-A01SDR VNAA202601180008Rib · crackedCRACKED WING RIB FLS168.07 AT WING TRAILING EDGE STRUCTURE OF RH WING. WING RIB FLS168.07 AT WING TRAILING EDGE STRUCTURE OF RH WING WAS REPAIRED PER REO 690-57-51-492 REV - -SDR VNAA202601180007Floorbeam · corrodedCRACK ON FLOOR BEAM RBL 12.0 BTW FS221.73-FS229.00 AT FWD FUSELAGE INTERNAL STRUCTURE. FLOORBEAM RBL 12.0 BTW FS221.73-FS229.00 AT FWD FUSELAGE INTERNAL STRUCTURE WAS REPAIRED PER REO 690-53-11-2086 REV. - -SDR VNAA202601180006Fitting · corrodedCORROSION ON FITTINGS (2EA) BTW STA FS 280 TO STA FS 295 AND RBL 16 TO RBL 38.AND CORROSION ON FITTINGS (2EA) BTW STA 364 TO STA FS 379 AND LBL 13 TO LBL 40 APPROXIMATELY. FITTINGS (4EAS). BTW STA FS 280 TO STA FS 295 AND RBL 16 TO RBL 38 AND BTW STA 364 TO SSDR VNAA202601180005Seat Track · corrodedCORROSION ON FLOOR SEAT RAILS RBL9; (4E/A) FROM FS581 TO FS977 AT PAX CABIN. CORRECTIVE ACTION: WERE EVALUATED, DUE TO EXCESSIVE DAMAGE ON SEAT RAILS RBL9; (3E/A) FROM FS581 TO FS 847+16 AT PAX CABIN PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACED PER CRJ-9SDR VNAA202601180004Seat Track · corrodedCORROSION ON FLOOR SEAT RAILS LBL9; (1E/A) FROM FS377 TO FS485, (1E/A) FROM FS581 TO FS661+32 AND (3E/A) FROM FS677 TO FS1000 AT PAX CABIN. DUE TO EXCESSIVE DAMAGE ON SEAT RAILS LBL9; (1E/A) FROM FS377 TO FS485, (1E/A) FROM FS581 TO FS661+32 AND (3E/A) FROM FSDR VNAA202601180003Seat Track · corrodedCORROSION ON LH SIDE SEAT RAILS; (5E/A) FROM FS483 TO FS720, (1E/A) FROM FS744 TO FS761, (1E/A) FROM FS785 TO FS852 AND (2E/A) FROM FS847+19 TO FS969 AT PAX CABIN. LH SIDE SEAT RAILS (5E/A) FROM FA483 TO FS720, (1E/A) FROM FS744 TO FS761, (1E/A) FROM FS785 TOSDR VNAA202601180002Seat Track · corrodedCORROSION ON RH SIDE SEAT RAILS; (4E/A) FROM FS379 TO FS661+14, (1E/A) FROM FS744 TO FS761, (1E/A) FROM FS785 TO FS852 AND(2E/A) FROM FS847+19 TO FS969 ATPAX CABIN. CORROSION ON RH SIDE SEAT RAILS; (4E/A) FROM FS379 TO FS661+14, (1E/A) FROM FS744 TO FS761, (1SDR VNAA202601170011Skin · corrodedCORROSION ON INNER SKIN TRAILING EDGE OF LH WING BTW STA BL45 TO STA WS 38, AND CORROSION ON INTERCOSTAL (2EA) OF LH WING T. EDGE BTW STA BL45 TO STA WS 38. CORROSION ON INNER SKIN TRAILING EDGE OF LH WING BTW STA BL45 TO STA WS 38 WAS REPAIRED PER REO 690-57SDR KY72026F00005Control Unit · faultedE2 FIRE LIGHT ON WITH NO FIRE. R&R E2 FIRE DETECTION CONTROL UNIT IAW DO328-300 MM 36-11-00 & 26-11-02SDR SWAA2025122235284Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5 RBL 44 WL 208.1. REPAIRED THE FLOORBEAM IAW EA 25-153-03179-WIP1, EA 25-153-03179-WIP2, EA 25-153-03179-WIP3 AND EA 25-153-03179.SDR SWAA2025122235267Web · corrodedCORROSION SHIELD WEB LOCATED BTW STA 492.4 TO STA 500A STR 26R AND WL 156 AT FWD CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOCATED BTW STA 492.4 TO STA 500A STR 26R AND WL 156 AT FWD CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02 AND DWG 143A0080SDR SWAA2025122247460Intercostal · crackedCRACK ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA. REPAIRED INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA IAW EA 25-153-03173-WIP1 AND EA 25-153-03173.SDR SWAA2025122247462Frame · crackedCRACK FRAME ON BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA. PERFORMED REPAIR ON FRAME ON BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA IAW EA M-22-153-01244.SDR SWAA2025122235372Frame · crackedCRACK FRAME ON BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA. PERFORMED REPAIR ON FRAME ON BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA IAW EA M-22-153-01244.SDR SWAA2025122235341Intercostal · crackedCRACK ON INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA. REPAIRED INTERCOSTAL LOCATED BTW BS 294.5 TO BS 303.9 AT LEVEL STR 16L AT FWD GALLEY AREA IAW EA 25-153-03173-WIP1 AND EA 25-153-03173.SDR SWAA2025122235374Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 193AL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 193AL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-10 REPAIR 10. S