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 IPXA2025092607061Rib · crackedLEFT WING CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK NOTED AT RIB25. CIRCLED IN RED.ACCOMPLISHED THE REPAIR IN ACCORDANCE WITH EO-94890-REQ1 AND VT-MAE EA 300-5750-27-A4108.SDR IPXA2025091499931Flap · corroded***SUPPLEMENTAL SDR*** FAULT - STR, Z600, RH WING, O/B FLAP, UPPER SKIN, O/B SIDE, UNDER STATIC WICK HAS CORROSION. DOT 103-8. ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94994-REQ1 AND VT-MAE EA 300-5754-27-A4128.SDR CALA2025101510115Window Frame · crackedRIGHT NR 3 WINDOW FRAME E-F POST CRACKED AT 5TH LOWER FASTENER HOLE. PERFORMED INTERIM REPAIR TO THE 5TH FASTENER HOLE FROM THE BOTTOM OF THE R3 WINDOW FRAME E-F POST IAW PART 1.SDR CALA2025101510114Window Frame · crackedRH NO. 3 WINDOW FRAME E-F POST CRACKED AT 5TH LOWER FASTENER HOLE - INTERIM REPAIR AT THE REPAIRED AREA OF THE RIGHT HAND #3 WINDOW FRAME E-F POST, REPAIRED AREA OF THE RH #3 WINDOW FRAME E-F POST REF ECRA 5310-08676.SDR IPXA2025091916219Adapter · corrodedEVIDENCE OF CORROSION AROUND SEAT TRACK BY FR 27, Y450 TO Y0, (LT SIDE). REMOVED CORROSION 2EA AREAS AROUND SEATRACK BY FR27, Y450 TO Y0 . INSTALLED NEW PART IAW A300-600, SRM 51-40-21.SDR IPXA2025092916237Seat Track · corrodedEVIDENCE OF CORROSION AROUND SEAT TRACK BY FR 26, Y450 TO Y0, (LH SIDE). FABRICATED NEW PART IAW GMM 09-08.INSTALLED NEW PART IAW SRM 51-40-21.SDR IPXA2025092607301Rib · crackedRIGHT WING CENTER FLAP, TOP SKIN RIB FLANGE, TWO CRACKS NOTED AT RIB 25. ACCOMPLISHED PERMANENT REPAIR IAW EO-94891-REQ1 AND EA 300-5750-27-A4107, REV -.SDR IPXA2025101307330Rib · crackedRIGHT WING CENTER FLAP, TOP SKIN RIB FLANGE, TWO CRACKS NOTED AT RIB 27. ACCOMPLISHED PERMANENT REPAIR IAW EO-94891-REQ1 AND EA 300-5750-27-A4107, REV -.SDR IPXA2025092607320Rib · crackedMAJOR REPAIR, RT WING CENTER FLAP, TOP SKIN RIB FLANGE, TWO CRACKS NOTED AT RIB 26. ACCOMPLISHED PERMANENT REPAIR IAW EO-94891-REQ1 AND EA 300-5750-27-A4107, REV. -.SDR IPXA2025092607221Rib · crackedMAJOR REPAIR, RT WING CENTER FLAP, TOP SKIN RIB FLANGE, TWO CRACKS NOTED AT RIB 13. ACCOMPLISHED PERMANENT REPAIR IAW EO-94891-REQ1 AND EA 300-5750-27-A4107, REV. -.SDR IPXA2025092607255Rib · crackedMAJOR REPAIR. RT WING CENTER FLAP, TOP SKIN RIB FLANGE, ONE CRACK NOTED AT RIB18. ACCOMPLISHED PRMANENT REPAIR IAW EO-94891-REQ1 AND EA 300-5750-27-A4107, REV. -.SDR SWAA2025100607409Access Panel · crackedCRACK ON HOLES ACCESS PANEL 193AR BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCES PANEL 193AR IAW SRM 51-70-05-2R-10 REPAIR 10 .SDR SWAA2025100607408Access Panel · crackedCRACK ON HOLES 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.SDR SWAA2025100307403Handle · deterioratedDETERIORATED DOORWAY HANDLE NUT R/L AT AFT GALLEY AREA 4EA. REPLACED DOORWAY HANDLE NUT R/L AT AFT GALLEY AREA IAW SOPM 20-50-01 REV:39 AND DWG 411A2204 REV N0:A..SDR SWAA2025093007154Floor Panel · pulledFWD FLOOR PANEL 221GF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL 221GF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007148Floor Panel · pulledFWD FLOOR PANEL 222DF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL 222DF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007153Floor Panel · pulledFWD FLOOR PANEL 221FF UPPER SKIN HAS AREAS OF PULLED STRANDS. THE FWD FLOOR PANEL 221FF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL IAW SRM 51-10-02-0G-0, PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007151Floor Panel · pulledFWD FLOOR PANEL 221BF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL 221BF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0, PARA 9.A.A DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007152Floor Panel · pulledFWD FLOOR PANEL 221CF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL 221CF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0, PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007145Floor Panel · pulledFWD FLOOR PANEL 221DF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL 221DF UPPER SKIN WITH AREAS OF PULLED STRANDS WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007146Floor Panel · pulledFWD FLOOR PANEL 221EF UPPER SKIN HAS AN AREA OF PULLED STRANDS. FWD FLOOR PANEL 221EF SKIN DAMAGE HAS BEEN REPAIRED IAW SRM 53-00-50-2R-1-A00939.SDR SWAA2025093007147Floor Panel · pulledFWD FLOOR PANEL 222CF UPPER SKIN HAS AREAS OF PULLED STRANDS. FWD FLOOR PANEL WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G, PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR ASAA2025082261085Rib · crackedLEFT HORIZONTAL STAB RIB NR 2 CRACKED. GROUNDED - YES. REPAIRED LT HORIZONTAL STAB RIB NR 2 IAW SRM 55-10-09-2R-4.SDR ASAA2025082261084Rib · crackedLEFT HORIZONTAL STAB RIB NR 6 IS CRACKED. GROUNDED - YES. REPAIRED THE LT HORIZONTAL STAB RIB NR 6 IAW SRM 55-10-09-2R-4.SDR REXA2025092500880Stringer · corrodedAFT CLEAN AREA, CORROSION ON STRINGER 25R BETWEEN BS 295 - 310. CORROSION ON THE STRINGER WAS EVALUATED OUT LIMITS IAW SRM 53-21-03-101-002-A04. REPLACED IAW SRM 51-42-21-001-001-A01 AND SRM 51-42-06-001-001-A01.SDR REXA2025092500879Stringer · corrodedCORROSION ON STRINGER 26R LOCATED BTW BS 295 - 310. THE STRINGER WAS REPLACED DUE TO EXCESSIVE DAMAGE IAW SRM 51-10-06-001-001-A01, SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-A01, AND SRM 51-42-10-001-001-A01.SDR REXA2025092500878Doubler · crackedCRACK ON DOUBLER ON FWD EQUIPMENT COMPARTMENT INTERNAL STRUCTURE BTW BS 193, S16L, ADG RESTOW PUMP AREA, DOUBLER ON FWD EQUIPMENT COMPARTMENT INTERNAL STRUCTURE BTW FS 193.00 AND STGR 16L REPLACED IAW SRM 53-11-43-201-001-A01.SDR SWI2025F01325Panel · dentedDUE TO BIRDSTRIKE TO LHS HYD BAY FUSELAGE PANEL, FOUND FORWARD DENTED AREA (NO. 1) MEASURES 5.375" L X 3.875" W X 0.375" MAX. DEPTH AND IS LOCATED BETWEEN THE ELECTRICAL BAY DOOR AND HYDRAULIC BAY ACCESS DOOR, JUST FORWARD OF FS193.00.REF. REO-53-11-2169 FOR DSDR SWI2025F01324Skin · crackedUPON DRESS BACK OF AFT DENTED AREA (NR . 2), OPERATOR REPORTS THAT THE SKIN PANEL WAS CRACKED OVER A LENGTH OF APPROX. 1.25" LONG. ADDITIONALLY, OPERATOR REPORTS THE INTERNAL UPPER STRAP(DWG: CC670-34124, 0.050" NOMINAL THK, REF) TO HAVE BEEN DEFORMED.REF. REOSDR SWIA202509240822Skin · dentedDUE TO BIRDSTRIKE TO LT HYD BAY FUSELAGE PANEL, THE AFT DENTED AREA (NR 2) MEASURES 11.00" L X 6.00" W X 1.75" MAX. DEPTH AND IS LOCATED BETWEEN FS193.00 - FS202.75 & BETWEEN STR16L - STR21L.REF. REO-53-11-2169 FOR DAMAGE REPORT. (FLIGHT 1300 - FILED CLOSSDR CALA2025092309155Intercostal · corrodedINTERCOSTAL CORRODED. FABRICATED NEW INTERCOSTAL IAW DWG 147A5762, REV B.SDR IPXA2025091909183Floor Panel · damagedFWD CARGO FLOOR PANEL 131DE HAS EDGE DAMAGE 4". SH 91148554. FABRICATED/ INSTALLED FLOOR PANEL 131DE, P/N B5327052700000 IAW A300 SREO-16407-REQ002 ((APPX C).SDR IPXA2025091916217Floor Panel · puncturedFLOOR PANEL 231XG HAS A PUNCTURE. REPAIRED SMALL SURFACE PUNCTURE I.A.W A300 SREO-42721-REQ001 (APPX A). JOB COMPLETE. REVIEWEDSDR IPXA2025091908647Floor Panel · damagedAFT CARGO FLOOR PANEL 151QF HAS 2 PLACES 5" OF EDGE DAMAGE. SH 91148554 VERIFIED FABRICATION OF FLOOR PANEL 151QF, P/N B5327053100000<BR>IAW A300 SREO-16407-REQ002 ((APPX C) PANEL WILL BE INSTALLED ACCORDING TO CARD NO T3F18E006P978.SDR IPXA2025092016159Plate · brokenLEFT SIDE, BTW FR 38.1 AND FR 38.2 GUSSET PLATE IS BROKEN. INSTALLED NEW GUESSET PLATE L/H SIDE BTW FR 38.1 AND FR 38.2 IAW-SRM 51-40-20. REVIEWEDSDR SWAA2025091907310Bezel · brokenESCAPE HATCH; LEFT SIDE PANEL 833 CLOSING STRAP BEZEL ATTACHED TO DOOR LINER IS BROKEN. SECURED CLOSING STRAP BEZEL TO THE LEFT OVERWING EXIT DOOR 833 PANEL PER SOPM 20-50-12.SDR SWAA2025091907318Strap · unsecureESCAPE HATCH; LEFT SIDE PANEL 833 ESCAPE STRAP RED VELCRO COVER NOT ATTACHED TO DOOR SURROUND FRAME STRUCTURE. SECURED ESCAPE STRAP RED VELCRO COVER TO DOOR SURROUND FRAME STRUCTURE PER SOPM 20-50-12.SDR SWAA2025091907317Strap · out of adjustESCAPE HATCH; RIGHT SIDE PANEL 843 ESCAPE STRAP RED VELCRO COVER NOT ATTACHED TO DOOR SURROUND FRAME STRUCTURE.<[01] SECURED ESCAPE STRAP RED VELCRO COVER TO DOOR SURROUND FRAME STRUCTURE PER SOPM 20-50-12.;[02] VERIFIED SECURED ESCAPE STRAP RED VELCRO COVER TSDR IPXA2025091007301Rib · crackedMAJOR REPAIR. RT WING CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACKS NOTED AT RIB25. CIRCLED IN RED. REVIEWEDSDR IPXA2025091007330Rib · crackedMAJOR REPAIR, RT WING CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACKS NOTED AT RIB27.SDR IPXA2025091907221Rib · crackedMAJOR REPAIR, RT WING CENTER FLAP, TOP SKIN RIB FLANGE, 2 CRACKS NOTED AT RIB13.SDR ASAA2025082260940Web · corrodedFWD CARGO DOOR WEB IS CORRODED IN NUMEROUS PLACES. GROUNDED - YES. CORROSION REMOVED, ORIGINAL THICKNESS .045, MAT LOSS .0175, REMAINING THICKNESS .0275, AREA OUT OF LIMITS PER B737-900ER SRM 53-30-15-1A-1 REMOVED WEB AND INSTALLED IAW SRM 51-40-02 AND DWG 143SDR REXA2025091800870Skin · wornWEAR ON FUSELAGE SKIN BTW FS 913 TO FS 927 STGR 27. FUSELAGE SKIN BTW FS 913 TO FS 927 STGR 27 WAS REPAIRED PER REO 670-53-00-290 REV. F AND INSPECTION REQUIREMENTS FOR 40,000 FLIGHT CYCLES PER SDIR 670-53-00-290SDR SWAA2025091507361Baffle Angle · crackedCRACK FOUND ON BAFFLE FWD CLIP AT BS 400, LBL 25. REMOVED AND REPLACED BAFFLE FWD CLIP AT BS 400, LBL 25 IAW SRM 51-40-02, AND DWG 143A7505 0081, REV -,SDR SWAA2025091507362Baffle · crackedCRACKED BAFFLE AT BS 500A TO 500B, LBL 21, WL 161. REMOVED AND REPLACED THE BAFFLE FROM BS 500A TO 500B, LBL 21 IAW SRM 51-40-02, AND DWG 143A7505 REV -.SDR SWI2025F01314Seat Track · gougedLH LOWER SEAT TRACK FROM FR 73 TO FR 84 HAS MULTIPLE GOUGES (MARKED) (C-CHECK RO 09/14/2025)REMOVED AND REPLACED LH LOWER SEAT TRACK FROM FR 73 TO FR 84 REF EMB 175 SRM 51-40-08. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR SWI2025F01313Seat Track · gougedRH LOWER SEAT TRACK FROM FR73 TO FR 84 HAS GOUGES AT MULTIPLE LOCATIONS (MARKED) (C-CHECK RO 09/14/2025)REMOVED AND REPLACED RH LOWER SEAT TRACK FROM FR73 TO FR 84 REF EMB 175 SRM 51-40-08. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION SDR SWIA2025091500822Shear Tie · corrodedCORROSION BETWEEN STGR 28R - 27R AND FR 90 (C-CHECK RO 09/14/2025)REMOVED AND REPLACED SHEAR CLIP AT FR 90 STGR 28R-27R REF EMB 175 SRM 51-40-08.THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR IPXA2025091549931Skin · corrodedRIGHT WING, OTBD FLAP, UPPER SKIN, O/B SIDE, UNDER STATIC WICK HAS CORROSION. DOT 103-81 VERIFIED STEP #22 OF PRELIMINARY #1, E.A.#300-5754-27-A4128OF. VERIFY SERVICE DIFFICULTY REPORT HAS BEEN INITIATED. (T3F18E007E5EA)SDR IPXA2025091507320Rib · crackedRIGHT WING CENTER FLAP, TOP SKIN RIB FLANGE, HAD 2 CRACKS AT RIB 26. COMPLIED WITH STEP 33 OF EA 300-5750-27-A4107, PRELIMINARY 1.