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 SWIA202511281004Beam · damagedDAMAGE WAS CAUSED TO THE FWD BULKHEAD BEAM AT RBL9, FS 693.00, NEW BULKHEAD BEAM WILL BE REQUIRE REPLACEMENT. FWD BULKHEAD BEAM AT RBL9 FS693, PN SH670-35885-6 REPLACED WITH NEW IAW SRM CRJ 700 51-42-21-001-001-A01, SRM CRJ 700 51-42-06-001-001-A01 AND SB 6SDR SWAA2025111221467Stiffener · crackedCRACK ON VERTICAL STIFFENER BS 540 AND LBL 24.97 BULKHEAD AREA FWD CARGO COMPARTMENT. REPLACED VERTICAL STIFFENER BS 540 AND LBL 24.97 BULKHEAD AREA FWD CARGO COMPARTMENT IAW SRM 51-10-02, SRM 51-40-02, AND DRAWING 111A2001, SHEET 76, 77, 78 REV- AND DRAWINGSDR SWAA2025111221100Stiffener · crackedCUSTOMER REQUEST: PERFORM DETAIL VISUAL INSPECTION ON BS 540 BULKHEAD VERTICAL STIFFENERS BTW RBL 54.60 TO LBL 54.60 AT FWD CARGO COMPARTMENT. PERFORMED DETAILED VISUAL INSPECTION ON BS 540 BULKHEAD VERTICAL STIFFENERS BTW RBL 54.60 TO LBL 54.60 AT FWD CARGO CSDR JJBA20251112041Strap · crackedCRACK ALONGSIDE FASTENER HOLE IN PANEL 194ER UPPER RETAINING STRAP AT FRAME 48. REMOVED DAMAGED STRAP AND INSTALLED NEW UPPER RETAINING STRAP FOR PANEL 194ER AT FRAME 48.SDR JJBA20251112028Floorbeam · corrodedMID FLOOR BEAM AT FR 61, STR 1R HAS CORROSION. REMOVED DAMAGED GUSSET AND INSTALLED NEW MID FLOOR BEAM GUSSET PLATE AT FR61SDR JJBA20251112027Floorbeam · corrodedRH FLOOR BEAM AT FR 61, STR 4R HAS CORROSION. REMOVED AND REPLACED GUSSET PLATE AT FR 61 STR 4RSDR VNAA20251111006Fairing · damaged1075FH PERM REPAIR - SPEED TAPE APPLIED - RH PYLON TRAILING EDGE FAIRING LOWER PANEL DAMAGE WITHIN 1075 FLIGHT HOURS AFTER SECTION I, ACCOMPLISH A PERMANENT REPAIR AT DISCREPANT AREA IN ACCORDANCE WITH APPROVED PROCEDURES OR REPLACE PART. RH PYLON TRAILING ESDR VNAA20251111005Web · dentedCRACK ON UPPER WEB OF ADG COMPARTMENT BELOW OF SETTLEMENT AREA OF ADG PUMP. CRACK ON UPPER WEB OF ADG COMPARTMENT BELOW OF SETTLEMENT AREA OF ADG PUMP WAS REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01SDR VNAA20251110008Intercostal · corrodedCORROSION ON INTERCOSTALS (3 EAS) IN STA. FS= 349 TO FS= 364 NEAR STGR 27 AT MAIN AVIONICS COMPARTMENT. CORROSION ON INTERCOSTAL STGR 26 RH AND FS 364.00 TO FS 349.00 WAS REMOVED PER CRJ 900 SRM 51-21-06-001-001-A01 EVALUATE WITHIN OF LIMITS PER CRJ900 SRM 5SDR VNAA20251110007Hinge · damagedDISCREPANCY:IN REF TO TRFKE00EQGHW. PERM REPAIR - PASSENGER DOOR SURROUND STRUCTURE - HINGE REPLACEMENT REPLACE THE PASSENGER DOOR HINGE IN ACCORDANCE WITH CRJ900 SRM TASK 53-21-23-201-007-A01. // ENGINEERING COMMENTS: THIS IS A PERMANENT REPAIR, HINGE REPLACESDR JJBA20251110021Gusset · corrodedCORROSION AT FRAME 20 STR 21R. REMOVED AND REPLACED GUSSET AT FR 18 TO FR 24SDR JJBA20251110019Floor Support · wornBARE METAL. LOCATION: CABIN UNDER FLOOR PANEL 231HF. REMOVED AND REPLACED FLOOR SILL AT FR 24.SDR SWAA2025110521416Handle · deterioratedDETERIORATED HANDLE BOX HARDWARE, FWD SERVICE DOOR. REPLACED HANDLE BOX HARDWARE IAW AMM 52-41-11-400-801, STEP 3.F, 2J,SDR SWAA2025110421441Angle · deformedDEFORMED ANGLE RBL20.6 STA1096 WL 249.61 HORIZONTAL BEAM LOWER. RII ITEMS COMPLIED WITH ON 25-153-02689-WIP1-WIP4. NO RII REQUIREMENTS ON 25-153-01768-WIP1. REMOVED AND REPLACE ANGLE IAW EA 25-153-02689.SDR SWAA2025110421439Stiffener · deformedDEFORMED STIFFENER BS 1096, RBL 10 - 30.6, WL 249.61 HORIZONTAL BEAM LOWER. REMOVED AND REPLACED THE STIFFENER IAW SRM 51-40-02-0G-0 AND EA 25-153-02689, FIGURE 3, SHEET 1.SDR SWAA2025110321440Stiffener · deformedDEFORMED STIFFENER BS 1088, RBL 15 TO RBL 29, WL 249.61. HORIZONTAL BEAM LOWER. REFER TO FAULT TTG8Q015D0QP WHERE EA 25-153-02689 WAS ADDED AS A SUBTASK..SDR SWAA2025110321438Angle · deformedDEFORMED ANGLE, RBL 20.6, BS 1088 - 1096, WL 249.61, HORIZONTAL BEAM LOWER. REMOVED AND REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, AND EA 25-153-02689, FIGURE 3, SHEET 1.SDR CALA2025103010756Skin · damagedAFTER FURTHER EVALUATION, LIGHTNING STRIKE FOUND TO BE OUT LIMI TS REQUIRE REPAIR ON FUSELAGE SKIN BTW STA 380 TO STA 400 AND S- -5R TO S-6R. PERFORMED REPAIR ON FUSELAGE SKIN BTW STA 380 TO STA 400 AND S- -5R TO S-6R IAW SRM 53-00-01-2R-3, THIS REPAIR IS A SDR IPXA2025102988759Web · crackedAFT CARGO COMPARTMENT WEB AT FR54, Y1959 CRACKED. REMOVED THE WEB AT FR54, Y1959 IAW SRM 51-40-21. INSTALLED NEW WEB ANGLE AT FR54 Y1959 LH SIDE.SDR IPXA2025102988782Angle · crackedAFT CARGO COMPARTMENT WEB AT FR54, Y953 LH CRACKED. REMOVED AFT CARGO COMPARTMENT WEB AT FR54, Y953 LT IAW SRM 51-40-21. INSTALLED NEW WEB ANGLE AT FR54 7953 LH SIDE.SDR AALA202510306647Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 951, RBL 32. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202510304795Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 767 AND BS 787 AT LBL 20. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR SWAA2025102821481Floor Panel · pulledFLOOR PANEL 242BF HAS UPPER SURFACE DENTED AND PULLED FIBERS. REPAIRED FLOOR PANEL 242BF UPPER SURFACE IAW SRM 53-00-50-2R-2, SRM 53-00-50-2R-0, REPAIR GENERAL, AND EA M 25-153-02385.SDR SWAA2025102821482Floor Panel · damagedFLOOR PANEL 242AF HAS UPPER SURFACE DENTED AND PULLED FIBERS. REPAIRED THE FLOOR PANEL 242AF UPPER SURFACE IAW SRM 53-00-50-2R-2; SRM 53-00-50-2R-0, REPAIR GENERAL, AND EA M 25-153-02385.SDR AALA202510283227Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947.5, LBL 24. REPLACED UPPER CHORD PER SRM 53-70-51-2R-4.SDR SWAA2025102721477Floorbeam · crackedCRACKED BRAKE PANEL FLOORBEAM LOCATED BS 540, BL 0 TO RBL 24.75 AT PASSENGER CABIN REPLACED FLOORBEAM AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A0060, SHEET 36, REV A.SDR SWAA2025102721110Support Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA695 AND RBL24.75 PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED ON FLOOR STRUCTURE AT STA695 AND RBL24.75 PASSENGER CABIN IAW SRM 51-40-02-0G-0, DWG 273A9111, SHEET 6, REV A, AND DWG 111A6000, SHEET 178, RSDR SWAA2025102721479Tail Cone · delaminatedDELAMINATED TAIL CONE ON EXTERNAL SKIN. REPAIRED TAIL CONE ON EXTERNAL SKIN IAW SRM 51-70-04-2R-1 REPAIR 1.SDR SWAA2025102721485Floor Panel · pulledFLOOR PANEL 241BF HAS UPPER SURFACE DENTS AND PULLED FIBERS. REPAIRED FLOOR PANEL 241BF UPPER SURFACE IAW SRM 53-00-50-2R-2, SRM 53-00-50-2R-0, REPAIR GENERAL AND EA M-25-153-02385.SDR SWAA2025102721486Floor Panel · dentedFLOOR PANEL 241AF HAS UPPER SURFACE DENTS AND PULLED FIBERS. REPAIRED FLOOR PANEL 241AF UPPER SURFACE IAW SRM 53-00-50-2R-2; SRM 53-00-50-2R-0 REPAIR GENERAL AND EA M-25-153-02385.SDR AALA202510239005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E PLUS 10 INCHES, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202510235857Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500F, LBL 24 REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202510238494Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500G TO BS 500H AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202510235058Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500E TO BS 500F PLUS 3 INCHES, AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202510236350Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500C, RBL 24 REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202510232793Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 927, RBL 25. REPLACED UPPER CHORD PER SRM 53-70-51-2R-4.SDR AALA202510238217Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510236385Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 958, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510239023Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947 AND BS 967 AT LBL 24. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-5.SDR NACA2025100400002Screen · damagedNR 1 FAN EXIT CASE BLEED AIR DUCT, BLEED SCREENS 8 EA FROM UPPER DUCTS ARE BROKEN / MISSING. REMOVE AND REPLACE 6 EA SCREENS ON #1 ENG ESN 724378 IAW AMM 72-00-00-416-342-N00 REMAINING 2 EA UPPER SCREENS FOUND TO BE IN SERVICEABLE CONDITION IAW AMM TASK 75-3SDR NACA2025100400001Sense Line · chafedSTATIC PRESSURE SENSE LINE TUBE CHAFED ON #2 ENG. INBD FAN COWL. REMOVED AND REPLACED STATIC PRESSURE SENSE LINE TUBE ON #2 ENG INBD FAN COWL. LEAK TEST AND STATIC TEST GOOD IAW B767 AMM 71-00-02-844-002-N00 STEP 2 AMM 71-00-02-844-077-N00 STEP 7 AMM 71-00-SDR IPXA2025101787567Tie Clip · corrodedCORRODED STRUCTURE FOUND AT BS 680, AFT SIDE OF FLOOR FRAME AT RIGHT SIDE OUTBD SEAT TRACK AS SEEN FROM THE FWD LOWER CARGO PIT. REMOVED CLIP ON AT STA 680, AFT SIDE OF FLOOR FRAME AT RIGHT SIDE OUTBD SEAT TRACK AS SEEN FROM THE FWD LOWER CARGO PIT. IAW SRM 5SDR SCNA20251020392Light · no testDURING OPS CHECK OF THE EMERGENCY LIGHTS, FWD CEILING EMERG LIGHT DONT TURN ON. OPEN.SDR R61A2025101700463Frame · corrodedDURING C-CHECK AFT CARGO COMPARTMENT FR 76 BETWEEN STR 29R-28R FOUND CORROSION ON FRAME. REPAIRED FRAME 76 IAW EMB ETD 2025-170-929751SDR SWAA2025101621333Angle · debondedAFT CARGO L/H FLOOR TRANSITION ANGLE FROM STA 727E TO STA 727G DISBONDED NUTPLATES (QTY.7). INSTALLED BONDED NUTPLATES ON AFT CARGO LT FLOOR TRANSITION ANGLE FROM STA 727E TO STA 727G (QTY.7) PER SRM 51-40-10.SDR SWAA2025101621334Transition Panel · debondedAFT CARGO LEFT FLOOR TRANSITION ANGLE FROM STA 727I TO STA 747 DISBONDED NUTPLATES (QTY.10). INSTALLED BONDED NUTPLATES ON AFT CARGO LT FLOOR TRANSITION ANGLE FROM STA 727I TO STA 747 PER SRM 51-40-10.SDR SWAA2025101621335Angle · debondedAFT CARGO R/H FLOOR TRANSITION ANGLE FROM STA 727G TO STA 727I DISBONDED NUTPLATES (QTY.10). INSTALLED BONDED NUTPLATES ON AFT CARGO R/H FLOOR TRANSITION ANGLE FROM STA 727G TO STA 727I PER SRM 51-40-10.SDR SWAA2025101621327Angle · debondedAFT CARGO R/H FLOOR TRANSITION ANGLE FROM STA 727I TO STA 747 DISBONDED NUTPLATES (QTY.10). INSTALLED BONDED NUTPLATES ON AFT CARGO R/H FLOOR TRANSITION ANGLE FROM STA 727I TO STA 747 IAW SRM 51-40-10. PUSH TEST PASSED IAW SRM 51-40-10.SDR IPXA2025101589962Elec Connector · faultedRIGHT SIDE WINDOW EICAS DID NOT RESET. REPLACED POWER PLUG TERMINALS FOR J8 PER SWPM 20-30-12. WINDOW HEAT OPS CHECK GOOD PER AMM 30-41-00. THIS CLEARS THIS MEL. PLACARD REMOVED. DMP REVERSED. TERMINALS INSTALLED & TORQUED PER AMM 56-11-02. VERIFIED INSTALL OFSDR DALA2025101407519None · noneDTA ER/A 542233-14 REV D REPAIR MONITOR LOG REQUIRES DTA APPROVAL ON OR BEFORE THE NEXT 24 MONTHS AFTER 04-OCT-25. C/W ER/A 542233-14. (1245089)