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 DALA2025092106896Seat Track · corrodedCORROSION OUT LIMIT ON OUTBD SEAT TRACK RH BTW STA 365 TO STA 418, AT CABIN PAX. SEAT TRACK RH ON BTW STA 365 TO STA 418 WAS REPLACED PER B757-300 SRM 51-40-02-0G PAR 7 D. (LP 1209701)SDR DALA2025092106895Deck Plate · corrodedCORROSION ON DECK PLATE (PREVIOUS REPAIR) IN STA 1681 BETWEEN LBL 52 AND LBL 32 AT CPAX. PREVIOUS REPAIR DOUBLER ON DECK PLATE ON STA 1681 BETWEEN LBL 52 AND LBL 32 AT CPAX WAS REPLACED PER B757-300 SRM 53-60-51-2R PROCEDURE 2 REPAIR 2 ALTERNATIVE II. (LP 12SDR 2025F00281Unknown · unknownACCOMPLISHED RFTS-114898 REV.0. DATED 05SEP25, UPLOCK FAULT LOGIC FUNCTIONAL TEST DEVELOPMENT.SDR SWIA202512020920Frame Splice · corrodedPERFORM BS 927 FRAME SPLICE REPAIR DUE TO CORROSION ON WEB FACE BEYOND SRM LIMITS BETWEEN S25L AND S25R. REPLACED FRAME SEGMENT AT BS 927 IAW DWG SH690-37060, REV R, SRM 53-00-06-201-001-A03, SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01 REV 38.SDR VNAA202511250003Doubler · corrodedCORROSION ON DOUBLER OF FUSELAGE SKIN BTW FS 969.00 TO FS 1000. DOUBLER OF FUSELAGE SKIN BTW FS 969.00 TO FS 1000.00 WAS REPLACED PER REO 670-53-00-290 REV -FSDR SWAA2025110316500Scuff Plate · crackedAFT CARGO DOOR FWD CORNER SCUFF PLATE IS CRACKED. RECEIVED NEW AFT CARGO DOOR FWD CORNER SCUFF PLATE ITEM 146A8341-07. IT WILL BE INSTALL ON TASK CARD TTG8Q0157507.SDR SWAA2025110316512Fitting · crackedCRACKED FITTING, BS 559+8, LBL 6, WL 148.5. RECEIVED NEW FITTING. REMOVED AND REPLACED THE FITTING IAW SRM 51-40-02-0G-0, AND AIPC 53-12-11-25 FIG 2.SDR SWAA2025110316718Floorbeam · crackedCRACKED FLOORBEAM, BS 540, LBL 2, WL 208. REMOVED AND INSTALLED A NEW FLOORBEAM IAW SRM 51-40-02 AND DWG 143A0060.SDR SWAA2025110316719Floorbeam · crackedCRACKED FLOORBEAM BS 540, RBL 2, WL 208. REMOVED AND REINSTALLED THE FLOORBEAM IAW SRM 51-40-02 AND DWG 143A0060.SDR SWAA2025103116726Skin · crackedCRACK LOWER SURFACE OF LEADING EDGE SLAT NR 4, NOSE SKIN AT ACTUATOR, AROUND FASTENER AT LT WING. PERFORMED HFEC AND ROTOTEST INSPECTION ON HOLES LOC. LOWER SURFACE OF LEADING EDGE NR 4 SLAT NOSE SKIN AT ACTUATOR & CRACK INDICATION NOT FOUND IAW NDT MANUAL PSDR AALA202510288505Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING LOC. FR 66 PLUS 15 INCH AT LEVEL STR 23R AT AFT GALLEY AREA L=2.11 INCH W=0.595 INCH D=0.005 INCH. MAINTENANCE REPLACED CENTER FITTING LOC. FR66 PLUS 15 INCH AT LEVEL STR23R AFT GALLEY AREA IAW A319 SRM 51SDR HNAA2025102100720Stringer · crackedF072376 STRINGER 6R IS CRACKED AT FRAME 14. RAR STRINGER 6R AT FRAME 14 IAW EMB 145 SRM 51-40-02SDR ASAA2025092061660Stub Beam · gougedL1 DOOR UPPER STUB BEAM GOUGED. GROUNDED - YES. REMOVED AND REPLACED L-1 DOOR UPPER STUB BEAM IAW B737-900 ER SRM 51-40-02. DOT REMOVED.SDR ASAA2025092061659Skin · gougedL2 DOOR INNER SKIN GOUGED AT UPPER HINGE ARM CUTOUT. GROUNDED - YES. REMOVED, FABRICATED AND INSTALLED NEW L-2 DOOR UPPER INNER SKIN IAW BAC DWG 147A6152 REV C.SDR ASAA2025092061658Skin · gougedL2 DOOR INNER SKIN GOUGED AT LOWER HINGE ARM CUTOUT. GROUNDED - YES. REMOVED FABRICATED AND INSTALLED NEW L2 DOOR LOWER INNER SKIN IAW BAC DWG 147A6152 REV C.SDR ASAA2025092061657Stub Beam · gougedL2 DOOR UPPER STUB BEAM GOUGED. GROUNDED - YES. REMOVED GOUGED STUB BEAM IAW B737-900 SRM 51-40-02 AND INSTALLED FABRICATED STUB BEAM P/N: 147A6149-9 IAW B737-900 SRM 51-40-02 AND DWG 147A6149. USED MAT ID: 7050-T7451 PO: 1028336.1.SDR R61A2025101700437Strap · corrodedDURING C-CHECK CF III FR77 STR27R FOUND CORRODED WTB RETAINER STRAP. REMOVED AND REPLACED WTB RETAINER STRAP IAW SRM 51-42-02 AND 51-43-02SDR R61A2025101700436Seal Rest · corrodedDURING HEAVY CHECK AFT PASSENGER DOOR (L2) LOWER SEAL REST BETWEEN FR 85-87 FOUND CORRODED. REMOVED AND REPLACED L2 DOOR SEAL REST IAW SRM 51-41-01SDR R61A2025101700435Doubler · corrodedDURING HEAVY CHECK CF III FR 88-89 STR26R-28R FOUND CORRODED WASTE DOOR. REMOVED AND REPLACED WASTE DOUBLE IAW SRM 51-41-02SDR R61A2025101700434Door · corrodedDURING HEAVY CHECK CF III FR 88-89 STR26R-28R FOUND CORRODED WASTE DOOR. REMOVED AND REPLACED WASTE ACCESS DOOR IAW AMM 53-03-60SDR 3EJA2025101500002Cabin Pressure · faultedAMBER CABIN ALT EICAS MESSAGE ILLUMINATED AT FL 450. CABIN WOULD NOT MAINTAIN A NORMAL CAB ALT IN MAN PRESS AND FULL DOWN RATE. CONDUCTED OP CHECKS OF PRESSURIZATION SYSTEM, IASCS, AND PROVIDED DOWNLOADS FOR EVALUATION TO BOMBARDIER. MAINTENANCE PERFORMED IAWSDR 3EJA202510150001Ahrs · no discrepancyAHRS #1 FAILURE. #1 AHRS SYSTEM RESET, CNDSDR JJBA20251014044Skin · corrodedCORROSION ON HEATED WATER DRAIN BETWEEN FRAMES 60 TO 61 LOWER EXTERNAL FUSELAGE. REMOVED CORROSION BY PERFORMING CUTOUT AND INSTALLING A DOUBLER AT HEATER WATER DRAIN BETWEEN FRAMES 60 AND 61 ON LOWER EXTERNAL FUSELAGE.SDR AALA202510133934Strip · splitAIRCRAFT IN BASE MAINTENANCE: TRAILING EDGE OF RUDDER ON THE LOWER CORNER IS SPLITTING AND HAS A PULLED RIVET. REPAIRED RUDDER APEX STRIP PER SRM 55-41-19-300-004.SDR CALA2025101309989Skin · corrodedPOSIBLE CORROSION ON UPPER SKIN STA 727G TO 727F BTW STR 2L TO 3L. PERFORMED INTERIM REPAIR ON FUSELAGE SKIN AT STA 727F AND STRG 3L TO STRG 4L, ALL WORK PERFORMED IAW EC/RA 5360-02016 REV ORIG AND EO 250327 REV IR.SDR FDEA202509201941Skin · crackedRH CTR FLAP INTERNAL STRUCTURE CRACK AT UPPER RIB 18, STGR-2.8 TO REAR SPAR. ACCOMPLISHED RIB FLANGE REPAIR AT RIB 18, S-2.8~REAR SPAR AND EXTERNAL PLATE REPAIR AT RIB 16~18, REAR SPAR~S-2.1 I.A.W FEDEX EA NO:T6-5750-T0385072 P1, SEQ NO: 1031, REPAIR CLASSDR ASAA2025092061455Baffle · corrodedTHE BAFFLE BETWEEN STA 500G-500H HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED BAFFLE IAW DWG 143A7505 REV- NO SRM LIMITS.SDR ASAA2025092061453Baffle · corrodedTHE BAFFLE BETWEEN STA 500F-500G HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED BAFFLE BETWEEN STA 500F-500G PER BAC DWG 143A7505 REV. B. NO SRM LIMITS.SDR ASAA2025092061451Baffle · corrodedTHE BAFFLE BETWEEN STA 500H-500I HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED BAFFLE IAW DWG 143A7505 REV B NO SRM LIMITS.SDR SWIA2025100900020Rib · crackedAFTER PEEL BACK OF UPPER RT HORIZONTAL SKIN, AN HFEC CONFIRMED CRACK WAS SEEN ON FR 11A UPPER FORWARD FLANGE REMOVED AND REPLACED RT HORIZONTAL STABILIZER RIB 11A. PART REPLACED WITH OEM. NO CHANGE TO WEIGHT AND BALANCE.SDR CALA2025100909831Channel · corrodedAFT CARGO BAY, BS 1300 RT SIDE BRACKET SUPPORT ATTACHED IN THE FRAME FOUND WITH CORROSION. REMOVED AND REPLACED ONE CHANNEL IAW SRM 51-40-02-0G -1, VIA T25/1832218.SDR CALA2025100909830Channel · crackedTWO CRACKS FOUND ON LT WHEEL WELL DOOR SEAL SUPPORT CHANNEL BS 1060, LBL 50. REMOVED AND REPLACED 149N7550-95 VIA T25/831393 IAW SRM 51-40-02 -0G-1 RESTORED SURFACE PROTECTION IAW SRM 51-20-01-0G AND AMM 5 1-21-15.SDR IPXA2025092555955Bracket · crackedAFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE CRACKED AT -Y1456 I/B SIDE-109-23 VWV 91195430.REMOVED AFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE AT Y0, IAW A300-600 SRM 51-40-21. FABRICATED NEW ANGLE, IAW UPS GMM 09-08 AND A300-600F SRM 53-15-18.INSTALLED NEW ANGLSDR IPXA2025092556039Bracket · crackedAFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE CRACKED AT Y1456 O/B SIDE-109-22 VWV 91195430. REMOVED AFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE IAW A300-600 SRM 51-40-21.FABRICATED NEW ANGLE, IAW UPS GMM 09-08 AND A300-600F SRM 53-15-18.INSTALLED NEW ANGLE IAW A3SDR IPXA2025092555869Bracket · crackedAFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE CRACKED AT Y0-109-20 VWV 91195430.REMOVED AFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE AT -Y1456 I/B SIDE, IAW A300-600 SRM 51-40-21.FABRICATED NEW ANGLE IAW UPS GMM 09-08 PARAGRAPH 09.08.01.04 AND A300-600F SRM 53-15-1SDR IPXA2025092556055Bracket · crackedAFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE CRACKED AT -Y1456 O/B SIDE-109-24 VWV 91195430.REMOVED AFT CARGO-AFT REAR BULKHEAD FR54 1EA ANGLE AT -Y1456 O/B SIDE, IAW A300-600 SRM 51-40-21.FABRICATED NEW ANGLE IAW UPS GMM 09-08 PARAGRAPH 09.08.01.04 AND A300-600SDR SWIA202510070920Coupling · leakingRIGHT 14TH DUCT WARNING MESSAGE WHEN CLIMBING THROUGH ABOUT 8000FT. RAN QRH. MESSAGE CLEARED. RETURNED TO ORD. (FLIGHT 5610) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30875407, SEE THE FOLLOWING CPS FOR MX PERFORMED:CP 30882896 FOR REPLACEMENT OF THE RTSDR AALA202510072648Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT AT BS 887, FROM LBL 12 TO RBL 12. REPLACED SUPPORT PER AARD 51-00-05-1.SDR SWAA2025092916642Lens · brokenSIDEWALL PANEL 231YHW EMERGENCY EXIT LIGHT LENS ASSY IS BROKEN. REMOVED AND REPLACED AND PERFORMED GOOD TEST OF SIDEWALL PANEL 231YHW EMERGENCY EXIT LIGHT LENS ASSY IAW AMM 33-51-01-960-802.SDR DALA2025092907036Transition Panel · corroded(LOG 1216177) FWD CARGO RH TRANSITION PANEL CORRODED AROUND NUTPLATES STA 500-500L. REMOVED AND REPLACED FWD CARGO R/H TRANSITION PANEL FROM STA 500 TO STA 500L IAW B737-900 SRM 53-00-53, 51-10-02.SDR AALA202509279225Skin · corrodedAIRCRAFT WAS GROUNDED: AFT LAVATORY VACUUM VENT OUTLET APPEARS TO HAVE CORROSION. MAINTENANCE FERRY TO TLE FOR REPAIR (SEE AALA202509272720) CORROSION ON LOWER FUSELAGE SKIN AROUND AFT LAVATORY VACUUM VENT LOCATED AT BS 917 FROM S21L AND S22L. ACCOMPLISHED TSDR AALA202509275566Oven · faultedAIRCRAFT WAS NOT GROUNDED: LEFT GALLEY OVEN BEEPING AND HOT WHEN NOT ON. COULD SMELL FROM THE FLIGHT DECK. REPLACED FIRST CLASS OVEN NUMBER 1 PER AMM 25-32-03.SDR AALA202509260172Stop Fitting · misalignedAIRCRAFT IN BASE MAINTENANCE: RIGHT FORWARD OVERWING EXIT, AFT UPPER STOP PAD MISALIGNED. REALIGNED AFT UPPER STOP PAD. PER AMM 52-22-00SDR SIMA20250920002Power Supply · inoperativeAFT CEILING PANEL EMERGENCY LIGHT INOPERATIVE. R & R EMERGENCY PWR SUPPLY UNIT (#3) IAW ERJ 175 AMM 33-50-01 OCK GOODSDR AALA202509263934Skin · damagedAIRCRAFT IN BASE MAINTENANCE: TRAILING EDGE OF RUDDER ON THE LOWER CORNER IS SPLITTING AND HAS A PULLED RIVET. (OPEN)SDR AALA202509260416Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 2 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 2 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509267226Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 3 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 3 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509263979Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 1 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 1 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509267322Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 6 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 6 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509263207Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 5 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 5 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.