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 VNAA20251015078Intercostal · dentedPAX DOOR INTERCOSTAL FOWARD DD5 WAS FOUND TO BE DENTED AND BULGED. REMOVED AND REPLACED INTERCOSTAL I.A.W. MHIRJ REO 670-52-11-1459 REV.-.SDR VNAA20251015077Intercostal · corrodedFOUND PAX DOOR DD1 AFT INTERCOSTAL TO BE CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW CRJ 700 SRM 51-42-06-001-001-A01.SDR VNA2025F00039Floor Support · corrodedDISCREPANCY: LBL 27 FLOOR BEAM IS CORRODED FROM FS 1000 TO FS 1015. CORRECTIVE ACTION: REPAIRED FLOOR BEAM IAW CRJ-700 SRM 53-00-41-201-001-A01. MM670-35302-005SDR VNAA20251015076Cleat · corrodedAV SUPPORT CLEAT ON STR21R AT FS333.00 IS SEVERELY CORRODED. REMOVED AND REPLACED SUPPORT CLEAT IAW CRJ-700 SRM'S 51-42-06-001-001-A01, 51-42-21-001-001-A01, AND 51-40-11-001-001-A01.SDR HNAA2025101700706Light · inoperativePOSITION 8 EMERGENCY FLOOR PROX LIGHT INOP. RAR FLOOR PROX LIGHT IAW AMM33-50-12SDR FDEA202510172042Floor Panel · damagedPUNCTURE FLOOR 241AFF, IN UPPER CARGO COMPARTMENT. FLOOR 241AFF, IN UPPER CARGO COMPARTMENT WAS REPAIRED IAW B-767, SRM 53-00-50-2R PAR. 4.B, PAG. 2, FIG 201, SHEET 2, REV. 92, APR-15-2025.SDR FDEA202510172041Floor Panel · crackedCRACK ON SKIN OF FLOOR PANEL 242TFA, MAIN CARGO COMPARTMENT FLOOR PANEL 242TFA, MAIN CARGO COMPARTMENT WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202510172040Floor Panel · crackedBROKEN MAIN DECK PANEL 241AGF MAIN DECK PANEL 241AGF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR15,2025SDR FDEA202510172039Floor Panel · crackedBROKEN AT AFT EDGE OF FLOOR PANEL 241YFA FLOOR PANEL 241YFA WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202510172038Floorbeam · corrodedFWD CARGO COMPARTMENT FLOOR SUPPORT BEAM CORRODED AT FR29 Y-1470 REPAIRED THE FWD CARGO COMPARTMENT CORRODED FLOOR SUPPORT BEAM AT FR29 Y-1470 PER A300-600 SRM53-10-15-201 FIGURE 207 AND EA: 6-5321-T0385349 P1. TITLE: FUSELAGE - CARGO COMP FLOOR - FWD CARSDR FDEA202510172037Roller Track · corrodedFWD CARGO COMPARTMENT LOADING SYS TRACK CORRODED AT FR38.1 - FR38.2 Y140 REPAIRED THE FWD CARGO COMPARTMENT CORRODED LOADING SYS TRACK AT FR38.1 - FR38.2 Y140 PER A300-600 SRM53-10-15-201 FIG.203. THIS IS CAT A REPAIR, MAJOR REPAIR IAW GMM6-2-100.SDR JGVR20251017003Spar · corrodedBLENDED AREA OF CORROSION LOCATED ON THE LT AFT WING SPAR LOWER WEB AT THE EMERGENCY BRAKE CARRY THROUGH FITTING HOLES, LOCATED IN THE LT MAIN LANDING GEAR WHEEL WELL , PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED BLENDED ARESDR JGVR20251017002Spar Cap · corrodedBLENDED AREA OF CORROSION LOCATED INSIDE LH MAIN GEAR WELL BAY ON THE AFT LOWER SPAR CAP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED BLENDED AREA PER NETJETS REQUEST FOR TECHNICAL DISPOSITION REPORT.SDR JGVR20251017001Spar · corrodedBLENDED AREA OF CORROSION LOCATED INSIDE RIGHT MAIN GEAR WELL BAY 720DR ON THE LOWER AFT SPAR CAP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED, AND PRIMED BLENDED AREA PER TECHNICAL DISPOSITION REPORT.SDR CALA2025101710228Frame · not reportedFRAME WEB REPAIR AT STA 780 PLUS 20 BETWEEN S 8R-9R.SDR CALA2025101710227Light · inoperativeFOUND SEAT 44D & 54D EMER LT INOP. SEAT 44D EMER LIGHT ASSY REPLACED.LIGHT CHECK SATIS.RESTORED TO ORIGINAL CONFIG. SEAT 54D EMERGENCY LIGHT ASSY REPLCED IAW B787-A-33-51-06-00A-520A-A/720A-A. OPS CHECK PASSED.SDR CALA2025101710211Oven · odorFRONT GALLEY OVEN 204 TURND OFF DUE TO SMOKE AND ODOR. REPLACED GALLEY OVEN WITH SERVICEABLE ONE IAW AMM 25-34-00. OPS CHECKED GOOD, NO SMOKE PRESENT.SDR JR2R20251017239Seat Track · corrodedSEAT TRACK CORRODED AT RBL10 BETWEEN FR17 AND FR18. REPLACED.SDR SWIA2025101675773Skin · chafedAFT FUSELAGE SKIN CHAFED AT FS920 STR27. REPAIRED AFT FUSELAGE SKIN AT FS920 STR27 IN REF TO REO 670-53-00-290 REV. -F AND REO 690-53-00-649 REV. -. COMPLIED WITH TASK CARD 51-900-1002-SKY. PRESSURIZATION LEAK CHECKED GOOD.SDR SWIA2026022705382Floorbeam · crackedLEFT COCKPIT CENTER FLOOR PANEL LANDING/ANGLE NEAR BS 280 & LBL 11.128 AND AT WL 72.10 IS CRACKED. REMOVED AND REPLACED THE LT COCKPIT CENTER FLOOR PANEL LANDING/ANGLE NEAR BS 280 & LBL 11.128 AND AT WL 72.10 IAW SRM 51-42-06.SDR SWIA2025101675370Floorbeam · crackedRIGHT COCKPIT CENTER FLOOR PANEL LANDING/ANGLE NEAR FS 280.00 & RBL 11.128 AND AT WL 72.10 IS CRACKED. REMOVED AND REPLACED THE RH COCKPIT CENTER FLOOR PANEL LANDING/ANGLE NEAR FS 280.00 & RBL 11.128 AND AT WL 72.10 IN REFERENCE WITH THE SRM 51-42-06.SDR SCNA20251021399SBattery Pack · no testR1 EXIT SIGNS AND SLIDE LIGHT EMERGENCY LIGHTS DO NOT COME ON DURING TEST. REMOVED, REPLACED AND PERFORMED SATISFACTORY OPS CHECK AT BATTERY PACK FOR R1EXIT SIGN AND SLIDE EMERGENCY LIGHT IAW B737AMM 33-51-06SDR SWIA20251226016Rib · crackedRIGHT LWR TRANSCOWL HAS CRACKED LATCH FAIRING ATTACHMENT RIB. REPAIRED TRANSCOWL TO REO 690-54-21-605, REV -. COMPLIED WITH 51-900-1002-SKY.SDR SWIA20251201016Plate · damagedCOMPLY WITH REO 670-53-22-099, SPLICE REPAIR TO MTG PLATE BETWEEN BS 319 - 333, RT. COMPLIED WITH SPLICE REPAIR TO MTG PLATE BETWEEN IAW REO 670-53-22-099 REV-. ALL CHECKED GOOD.SDR CALA2025112811575Skin · corrodedLOWER FUSELAGE SKIN EXTERNAL STA 540 BL 0" BULGE EVIDENCE OF CORROSION. ACCOMPLISHED REPAIR AT LOWER FUSELAGE SKIN PANEL STA 500H TO 540 BETWEEN STR 27L TO STR 27R IAW ECRA 5330-07635.SDR JJBA20251120105Stringer Splice · corrodedPROFILE SPLICE FOUND WITH CORROSION IN BATHROOM UNDER FLOOR AREA LOCATION FR 60-61 (STA X=20793.0) STGR 17L. REMOVED AND REPLACED STGR SPLICE 17L BETWEEN FR 60-61SDR HNAA2025112000759Floor Support · corrodedCABIN LT FLOOR GUSSET BETWEEN FR 52 / 59 CORRODED. R & R CABIN LT FLOOR GUSSET BETWEEN FR 52 / 59 IAW EMB145 SRM 51-40-02, 51-40-08, & 51-40-09.SDR SWAA2025111924965Angle · crackedCRACKED SLAT 1 INBD AUXILIARY TRACK OTBD ANGLE AT LT WING. REPLACED SLAT 1 INBD AUXILIARY TRACK OTBD ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 114A5010, SHEET 16, REV A, AND AMM 27-81-00-820-803, STEP 4. CLEARANCE CHECK OK. MEASUREMENTSDR SWAA2025111924966Angle · crackedCRACK SLAT 6 INBD AUXILIARY TRACK INBD ANGLE AT RT WING. REPLACED ANGLE LOCATED ON SLAT 6 INBD AUXILIARY TRACK INBD SIDE AT RT WING IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG: 114A5030, SHEET 16, REV -.SDR SWAA2025111924786Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT. REPAIRED FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT I.A.W. B737-700 SRM 53-60-15-2R-1 REPAIR 1, PARAGRAPH 4. B, STEPS 2 AND 4 - 7, FIGURE 203. REFER TO BAC 5975.SDR SWAA2025111924967Slat Track · crackedCRACK SLAT 3 INBD AUXILIARY TRACK I/B ANGLE AT LT WING. REPLACED SLAT 3 INBD AUXILIARY TRACK INBD ANGLE AT LT WING IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 114A5030, SHEET 8, REV C. MEASUREMENT OF CRACK IS L: 1.719 INCHES.SDR SWAA2025111925076Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 277 AT LEVEL STR 10R AT FWD GALLEY AREA. REPLACED TIE CLIP LOCATED BS 277 AT LEVEL STR 10R AT FWD GALLEY AREA. IAW SRM 51-10-02-0G-0, ITEM 9, DWG 141A1110, SHEET 18 REV - AND DWG 141A8380, SHEET 21, REV -.SDR SWAA2025111925080Stub Frame · crackedCRACK ON STUB FRAME LOCATED BTW BS 294.5 TO BS 296.5 BTW STR 8R TO STR 9R AT FWD GALLEY AREA. REPLACED STUB FRAME LOCATED BTW BS 294.5 TO BS 296.5 BTW STR 8R TO STR 9R AT FWD GALLEY AREA IAW SRM 51-40-02, AND DWG 141A8370, SHEET 9, REV D.SDR IPXA2025110693835Stringer · crackedMAJOR REPAIR - STRINGER CRACKED, FWD SIDE OF BS 2360, S5L.SDR IPXA2025111106150Cargo Track · crackedFWD CARGO COMPARTMENT. CEILING AREA, SEAT TRACK HAS CRACK LOCATED BETWEEN STA859 AND 879, RBL 75. INSTALLED SEAT TRACK SECTION AT MAIN CABIN BS 859 - 879 RBL 75 IAW SRM 53-00-52-2R-1. ACCOMPLISHED REPAIR IAW SRM 53-00-52-2R-1, REPAIR 1, REV 72.SDR IPXA2025110790349Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2360 AT S-4L. ACCOMPLISHED REPAIR I.A.W UPS EO-95726-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2500 REV.1.SDR IPXA2025110790378Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2360 AT S-5L. ACCOMPLISHED REPAIR I.A.W UPS EO-95764-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2507 REV.2.SDR IPXA2025110790411Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2360 AT S-6L. ACCOMPLISHED REPAIR I.A.W UPS EO-95738-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2516 REV.1.SDR IPXA2025110790459Stringer · crackedSTRINGER CRACK, AFT SIDE BETWEEN STA 2360 AND STA 2397 AT S-5R. ACCOMPLISHED REPAIR I.A.W UPS EO-95766-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2529 REV.2.SDR IPXA2025110790484Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 2360 AT S-6R. ACCOMPLISHED REPAIR I.A.W EO-95633-REQ1 REV.1 AND SRM 53-60-03-2R-8 TR: 53-157 AND EGAT WORK SHEET NO.50784 AND EGAT EI NO. F2025A53M-2578 REV.0SDR ASAA2025101662098Frame · corrodedAFT CARGO, STA 947.5, CORROSION NOTED ON UPPER SURFACE OF LH SIDE LOWER FRAME ON RADIUS EDGE AND UNDER FLOOR SUPPORT. DOT VISIBLE WITH MIRROR LOOKING THROUGH THE AFT BULKHEAD OPENING ON LOWER LH CORNER. GROUNDED - YES. REPAIRED FRAME 847 LBL 10 IAW ALASAK EA 7SDR SWAA2025110624950Floor Panel · crackedCRACK FLOOR PANEL 140CF AT AFT CARGO COMPARTMENT. REPLACED THE FLOOR PANEL 140CF IN THE AFT CARGO COMPARTMEN IAW SRM 51-10-02 ITEM 9 AND DWG 453A2610, SHEET 9, REV E.SDR AALA202511062215Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025110590126Stringer · crackedSTRINGER CRACKED, FWD SIDE OF STA 2180 S-16L. ACCOMPLISHED REPAIR I.A.W UPS EO-95728-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2499 REV.1.SDR IPXA2025110590156Stringer · crackedSTRINGER CRACK, FWD AND SIDE OF STA 2180 S-13L. ACCOMPLISHED REPAIR I.A.W UPS EO-95763-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2488 REV.1.SDR IPXA2025110590144Stringer · crackedSTRINGER CRACK, AFT SIDE OF STA 740 S-40L ACCOMPLISHED REPAIR I.A.W UPS EO-95759-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2421 REV.1.SDR IPXA2025110406631Support Bracket · brokenFWD CARGO COMPARTMENT CEILING STRUCTURE SUPPORT BRACKET BROKEN APPROX BTW STA 979 AND STA 999, X=-103, ID STICKER NUM. (085-067). CUT OUT DAMAGE AREA AT FWD CARGO COMPARTMENT CEILING STRUCTURE SUPPORT BRACKET APPROX BTW STA 979 AND STA 999, X=-103 IAW MD-11 SRSDR IPXA2025110405938Profile · brokenLEFT FRAME 82 THE CORNER ANGLE IS BROKEN. REMOVED PROFILE -T P/N: A53981401200 AT ZONE 200 L/H FR 82 I.A.W. A300-600 SRM 51-40-21. INSTALLED NEW PROFILE Z AT LH FR 82 IAW A300 SRM 51-40 21.SDR IPXA2025110593791Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2360 AT S-6R (LEVEL 2). (REPAIR) RII COMPLETED FOR EGAT WORK SHEET NO.50784 STEP 30.SDR IPXA2025110590166Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2180 S-15L ACCOMPLISHED REPAIR I.A.W UPS EO-95723-REQ1 REV.1 AND EGAT EI NO.F2025A53M-2497 REV.2.