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 SWAA2026020959200Access Panel · crackedCRACK BLADE ACCESS PANEL 343AT AT RT HORIZONTAL STABI. REPLACED BLADE ON ACCESS PANEL 343AT ON THE RT HORIZONTAL STAB IAW SRM 51-40-02; AND SRM 51-10-02, ITEM 9. MEASUREMENT OF CRACK: L=1.290".SDR SWAA2026020959199Access Panel · crackedCRACK BLADE ACCESS PANEL 333AT AT LT HORIZONTAL STAB. REPLACED BLADE ACCESS PANEL 333AT AT LT HORIZONTAL STAB IAW SRM 51-40-02 AND SRM 51-10-02, ITEM 9.SDR IPXA2026020297850Adapter · corrodedMAJOR REPAIR, CLS ADAPTER CORRODED AT FR 55 Y/0 LT SIDE. ACCOMPLISHED EA 300-5316-27-A4270, PRELIMINARY 1, STEP 13. INSTALLED THE CLS ADAPTER IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96237-REQ1 & VT-MAE EA 300-5316-27-A4270, REV-.SDR IPXA2026020298010Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR 61 Y/0 LT SIDE. ACCOMPLISHED EA 300-5317-27-A4265, REV -, PRELIMINARY 1, STEP 13. INSTALLED THE CLS ADAPTER IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96228-REQ 1 & VT-MAE EA 300-5317-27-A4265, REVSDR IPXA2026020298032Adapter · corrodedMAJOR REPAIR. CLS ADAPTER WITH CORROSION AT FR 62 Y/0 LT SIDE. PERFORMED EA 300-5317-27-A4265 REV -, PRELIMINARY 1, STEP 16. ACCOMPLISHED PERMANENT REPAIR IAW EO-96228-REQ1 & VT-MAE EA 300-5317-27-A4265 REV -.SDR IPXA2026020297886Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR54.2 Y/0 LT SIDE. ACCOMPLISHED EA 300-5316-27-A4266, PRELIMINARY 1, STEP 14. APPLIED CORROSION PREVENTIVE COMPOUND ON AFFECTED AREA IAW SRM 51-23-20 AND EO-2780-REQ001. ACCOMPLISHED PERMANENT REPAIR IAW EO-9623SDR IPXA2026020297834Adapter · corrodedMAJOR REPAIR. CLS ADAPTER WITH CORROSION AT FR57.1 Y/0 RT SIDE. .ACCOMPLISHED EA 300-5316-27-A4266, REV -, PRELIMINARY 1, STEP 13. INSTALLED CLS ADAPTER IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96231-REQ1 AND VT-MAE EA 300-5316-27-A4266.SDR IPXA2026020297968Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR 32 Y/0 L/H SIDE. DOT 06648-08. REMOVED ADAPTER CLS ON FR63 BTW -Y1959 & -Y2462 IAW A300-600 SRM 51-40-21. INSTALLED CLS ADAPTER FR63 -Y1959 -Y2462 IAW A300-600 SRM 51-40-21.SDR IPXA2026020297958Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR 32 Y/0 RT SIDE. ACCOMPLISHED EA 300-5314-27 A4264, PRELIMINARY 1, STEP 13, INSTALLED CLS ADAPTER IAW DRAWING B53774150 AT FR 32 YO RT IAW SRM 51-40-21. ACCOMPLISH PERMANENT REPAIR IAW EO-96227-REQ1 AND VT-MAE SDR IPXA2026020297922Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR 34 Y/0 R/H SIDE. ACCOMPLISHED E.A 300-5314-27 A4264 PRELIMINARY 1 STEP 13 INSTALL CLS ADAPTER IAW DRAWING B53774150 AT FR34 YO RT LOCATIONS IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96227-REQ1 ASDR IPXA2026020298123Adapter · corrodedMAJOR REPAIR, CLS ADAPTER WITH CORROSION AT FR 33 Y/0 R/H SIDE. ACCOMPLISHED E.A 300-5314-27 A4264 PRELIMINARY 1 STEP 13 INSTALL CLS ADAPTER PER DRAWING B53774150 AT FR33 YO RH LOCATINS IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96227-REQ1 ANDSDR IPXA2026020298006Adapter · corrodedMAJOR REPAIR. CLS ADAPTER WITH CORROSION AT FR 28 Y/0 L/H SIDE. ACCOMPLISHED EA#300-5314-27-A4264 PRELIMINARY 1 STEP 9 RESTORE SURFACE AND PAINT SCHEME ACCORDING TO SRM 51-23-10 AND 51-75-10. ACCOMPLISHED PERMANENT REPAIR IAW EO-96227-REQ1 AND VT-MAE EA 3SDR IPXA2026020297992Adapter · corrodedMAJOR REPAIR. CLS ADAPTER WITH CORROSION AT FR 28 Y/0 R/H SIDE. ACCOMPLISHED E.A 300-5314-27 A4264 PRELIMINARY 1 STEP 13 INSTALL CLS ADAPTER PER AIRBUS DRAWING B53774150 AT FR 28 YO RH LOCATINS IAW SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96227SDR IPXA2026020297812Adapter · corrodedMAJOR REPAIR. CLS ADAPTER WITH CORROSION AT FR57.1 Y/0 L/H SIDE. DOT 06648-02. ACCOMPLISHED E.A. 300-5316-27-A4266 REV -, PRELIMINARY 1, STEP 13. INSTALLED CLS ADAPTER IAW A300-600 SRM 51-40-21. ACCOMPLISHED PERMANENT REPAIR IAW EO-96231-REQ1 AND VT-MAE EA 3SDR SWAA2026020659197Crossbeam · crackedCRACK ON CROSSBEAM, BS 540, BTW RBL 24.75 TO RBL 45.5, WL 208.1. REPLACED CROSSBEAM IAW SRM 51-40-02, AND DWG 143A5240, SHEET 13, REV-. CRACK LENTH: 0.581'SDR SWAA2026020659196Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BS 695 BL 0 WL 208 . REPLACED SUPPORT ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, & DWG: 273A9110, SHEET 6, REV A.SDR AALA202602052816Threshold Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUTOUT LOWER THRESHOLD SHEET BETWEEN FR 55A AND FR 59 AT S38R. REPLACED THRESHOLD SHEET PER SRM 51-42-11.SDR IXXA20260205001Bearing · galledGALLING, LIGHT CORROSION AND GOUGE AROUND BEARING FACESDR SWAA2026020359350Support · corrodedCORROSION ON THE AFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE AROUND MULTIPLE NUT PLATE HOLES, BS 727B - 767, LBL 22, WL 156. REMOVED & REPLACED THE FLOOR TO SIDEWALL SUPPORT BTWN BS 727+4 - 847, LBL 22 IAW SRM 51-40-02, & DWG:146A7500, REV A.SDR SWAA2026020359351Support · corrodedCORROSION ON THE AFT CARGO BAY, RT FLOOR TO SIDEWALL SUPPORT PLATE AROUND MULTIPLE NUT PLATE HOLES, BS 727B - 767, RBL 22, WL 156. REMOVED & REPLACED THE FLOOR TO SIDEWALL SUPPORT BTWN BS 727+4 - 767, RBL 22 IAW SRM 51-40-02, DWG 146A7500, REV A.SDR SWAA2026020359184Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727B, S7L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, & DWG 146A1102, SHEET 15, REV -.SDR SWAA2026020359185Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727C, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1103, SHEET 11, REV -.SDR SWAA2026020359186Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727E, S6L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1112, SHEET 09, REV -.SDR IPXA2026013096567Tee Fitting · corrodedTEE FITTING AT BS 1147, RBL 65 SHOWS SIGNS OF LIGHT CORROSION. REMOVED THE DAMAGED TEE FITTING IAW SRM 51-40-02. INSTALLED NEW TEE FITTING P/N: UP-149N7222-69 BETWEEN BS 1147 RBL 65 IAW SRM 51-40-02-OG.SDR IPXA2026013096671Tee Fitting · corrodedTEE FITTING, BS 1037 - 1060, LBL 37, HAD EXFOLIATING CORROSION. REMOVED FLOOR PANEL 198CR AT EXHAUST AREA BTWN BS 1037 TO 1060, RBL 65 TO FACILITATE THE EVALUATION IAW SRM 51-40-02-0G. INSTALLED A NEW TEE FITTING IAW SRM 51-40-02.SDR IPXA2026012880090Spar Web · crackedLEFT WING, LOWER SURFACE, NR 3 SPOILER, INBD SIDE, AFT REAR SPAR WEB DEFORMED. FABRICATED AND DRILLED A NEW WEB IAW SRM 51-40-44, SRM 51-27-11, SRM 51-26-00 AND GMM 09-08-01-04. INSTALLED THE NEW WEB IAW SRM 51-40-21.SDR IPXA2026011997722Adapter · corrodedCLS ADAPTER CORRODED AT FR36 RT, UNDER FLOOR PANEL 242KF. REMOVED THE CLS ADAPTER AT FR36 IAW SRM 51-40-21. INSTALLED A NEW CLS ADAPTER IAW SRM 51-40-21.SDR SCNA202601300047Plate · corrodedCORROSION ON SIDEPLATE RH FROM STA 727 TO STA 947.5 RBL 21 AT AFT CARGO COMPARTMENT. AFT CARGO COMPARTMENT WAS REMOVED PER SRM 51-10-02-0G-0 AND EVALUATED WITHIN LIMITS PER B737-800 SRM 53-00-53-1A-2 ALLOWABLE DAMAGE 2, AND SIDEPLATE RH FROM STA 727D TO 727ISDR IPXA2026012896589Tee Fitting · corrodedTHE OTBD T-FITTING FOR ECS EXHAUST, STA 1037-1060, RBL 60 HAS CORROSION. INSTALLED T-FITTING IN STA 1037-1060, RBL 60 PER B757-200 SRM 51-40-02.SDR SWAA2026012859175Plate · crackedCRACKED CORRUGATED PLATE ORSS 261, RT WING T/E. REPLACED THE CORRUGATED PLATE AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 115A2001, SHEET 29, REV -.SDR SWAA2026012859177Angle · crackedCRACKED ANGLE, ORSS 271, RT WING T/E. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, & DWG 115A2900, SHEET 2, REV E. MEASUREMENT OF CRACK: L= 0.320.SDR SWAA2026012859176Plate · crackedCRACKED CORRUGATED PLATE ORSS 241, RT WING T/E. REPLACED THE CORRUGATED PLATE IAW SRM 51-40-02-0G, & DWG 115A2001, SHEET 30, REV A.SDR SWAA2026012859423Battery Pack · no testFUNCTIONAL CHECKED ALL EMERGENCY LIGHTS. PERFORMED GOOD FUNCTIONAL CHECK ALL EMERGENCY LIGHTS IAW AMM 33-51-00-710-801 EXCEPT FOR THE EMERGENCY EXIT LIGHTS ASSOCIATED WITH THE BATTERY PACK M1695 WHICH WILL BE REPLACED ON TASK CARD TTG8Q019ZEUA.SDR R61A2026012700026Seat Track · corrodedCFIII INBD LH SEAT TRACK CORRODED. CFIII INBD LH SEAT TRACK HAS BEEN REPAIRED IAW ERJ175 SRM 51-41-01, 51-43-01 AND 51-43-02.SDR R61A2026012700024Support Plate · corrodedCFIII FR84-86, LBL15, FOUND CORRODED FLOOR SUPPORT PLATE. CFIII, FR84-86, LBL15, FLOOR SUPPORT PLATE REPLACED IAW ERJ175 SRM 51-43-03.SDR R61A2026012700023Support · corrodedCFIII, LH FLOOR PANEL SUPPORT PLATE AT FR84, LBL35-LBL45 FOUND CORRODED. XFIII, LH FLOOR PANEL SUPPORT PLATE AT FR84, LBL35-LBL45 HAS BEED REPLACED IAW ERJ 175 SRM 51-41-02 AND 51-41-01.SDR R61A2026012700021Floorbeam · corrodedRT FLOORBEAM, FR 84, RBL 35 - RBL 45 FOUND CORRODED. THE FLOORBEAM WAS REPLACED IAW SRM 51-41-02, 51-41-01, AND 51-43-02.SDR R61A2026012700019Floor Support · corrodedRIGHT FLOOR SUPPORT UPPER FLANGE AT FR 88-89, RBL 11 FOUND CORRODED, THE FLOOR SUPPORT WAS REPLACED.SDR SCNA20260127046Plate · corrodedCORRODED SIDEPLATE, BS 400 - 500I, S26R IN THE FWD CARGO COMPARTMENT. REMOVED IAW SRM 51-10-02-0G-0 AND WAS MEASURED AND FOUND WITHIN OF LIMITS IAW SRM 53--00-53-1A-2 AND BTW BS 500A+3 AND 500E +18 REPLACED IAW SRM 51-40--02-0G-0.SDR SCNA20260127044Floor Support · crackedCRACKED FLOOR SUPPORT BTW BS 312 - 328, RBL 29. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-40-02-0G-0.SDR CALA2026012713354Skin · dentedDENT IN FUSELAGE OVER FWD HALF OF FRAME AT BS 259 JUST BELOW RI VET LINE FOR S17R REF AAR N/R 99979657. ACCOMPLISHED REPAIR AT FWD FUSELAGE BS 259 BETWEEN S16R AND S19R IAW SRM 51-40-02-0G-0 AND EC/RA 5310-08767.SDR SCNA20260123041Battery Pack · inoperativeR1 DOOR EMERGENCY EXIT LIGHTS INOP - - REMOVED FWD ENTRY LIGHT AND REMOVED BATTERY PACK AT M01674 IAW AMM 33-51-06. INSTALLED SERVICEABLE BATTERY PACK AT M01674 IAW AMM 33-51-06. PERFORMED SATISFACTORY OPS CHECK OF FWD BATTERY PACK AND R1 DOOR EMERGENCY EXIT LSDR IPXA2026012196338Rub Strip · crackedNUMBER 2 ENGINE O/B T/R WHERE METAL FIRE SEAL MAKES CONTACT HAS A HOLE IN THE CORNER. WEAR ANGLE AND RUBSTRIP O/B T/R REMOVED IAW A300-600F SRM51-40-21. WEAR ANGLE AND RUBSTRIP INSTALLED IAW SRM51-40-21.SDR IPXA2026011389555Skin · crackedLEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE; 3 CRACKS NOTED AT RIB27. CIRCLED IN RED. REAMED DAMAGED SHEARED FASTENER HOLE FROM 0.156" TO 0.187" IAW A300 SRM 51-40-44. OK TO INSTALL REPAIR PARTS GIVEN. COMPLIED WITH STEP 4 E OF E.A.#: 300-5753-27-A4260 PRESDR SCNA20260120038Strut · leakingDUE TO HISTORY OF LEFT MAIN LANDING GEAR STRUT LEAK- PERFORM REPLACEMENT OF THE ACTIVE AND SPARE SEALS IAW AMM 32-11-21-960-802. REMOVED AND REPLACED LT MAIN MANDING GEAR IAW CC 320400100.SDR IPXA2026011389650Skin · crackedLEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE; 3 CRACKS NOTED AT RIB26. ACCOMPLISHED REPAIR IN ACCORDANCE WITH EO-96213-REQ1 AND VT-MAE EA 300-5753-27-A4260, REV. -.SDR ASMF2026011508Pump · faultedEICAS HYD PRESS SYS PRI L, ITEM TRANSFERRED TO MEL 29-31-02 CAT C. ENGINE DRIVE PUMP WAS REPLACED IAW AMM DMC-B787-A-29-11-02-003-520A-ASDR SWAA2026011359319Fuse · failedPASSENGER CABIN LT NR 1 EMERGENCY AISLE LIGHT INOPERATIVE. REPLACED THE FUSE AND PERFORMED A GOOD TEST OF EMERGENCY LIGHTS IAW AMM 33-51-06-960-801, AND WDM 33-51-12.SDR AALA202601136687Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON FRAME WEB AT FR 68 RH STR 22 INNER CAP AT HORIZONTAL WEB. MAINTENANCE REMOVED CRACK HORIZONTAL WEB AND INSTALLED A REINFORCING MODIFICATION REPAIR PER SRM 53-41-12-300-020 AND EA 371338.SDR YENA2026011300027Unknown · odorFLT 8107, MCO-SJU. FA REPORTS PERSISTANT DIRTY SOCK ODOR BETWEEN ROWS 9-19 DIRTY DESCENT. COMPLIED WITH INFO NOTICE 2017-T015M STEP 1 ISOLATED FAULT TO TYPE 10. PERFORMED DVI OF APU AND ENGINES FOR LEAKS AND OIL QTY, RAN PACKS ONE AT A TIME AND NO ODOR NOTED