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 VNAA20260329006Support · crackedCRACK ON FWD INBD CORNER OF JB6 SUPPORT PLATE AT FWD EQUIPMENT COMPARTMENT. FWD INBD CORNER OF JB6 SUPPORT PLATE AT FWD EQUIPMENT COMPARTMENT WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR VNAA20260329005Web · crackedCRACK ON WEB RH SIDE FS193 AT FWD EQUIPMENT COMPARTMENT. WEB RH SIDE FS193 AT FWD EQUIPMENT WAS REPAIRED PER CRJ 900 SRM 53-11-43-201-001-A01.SDR VNAA20260329004Support Angle · crackedCRACK ON ANGLES (2E/A) AND SUPPORT BRACKET OF UPPER MLG BRAKE HYD ACCUMULATOR FWD SIDE AT NOSE HYD COMPARTMENT. ANGLES (2E/A) AND SUPPORT BRACKET OF UPPER MLG BRAKE HYD ACCUMULATOR FWD SIDE AT NOSE HYD COMPARTMENT WEERE REPLACED PER CRJ-900 SRM 51-42-06-001-SDR VNAA20260329003Rub Strip · corrodedCORROSION ON RUBSTRIP FS364.0 TO FS 394.0, STGR25 LH TO STGR25 RH AT MAIN AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE. RUBSTRIPS (2 EAS) FS379.0 TO FS 394.0, STGR25 LH TO STGR25 RH WERE REPAIRED PER REO 690-53-21-044 REV. -- AND RUBSTRIPS (2 EAS) FS364.0 TO SDR SWIA202603275594Stiffener · crackedPAX DOOR AFT WEB POWER ASSIST MOTOR STIFFENER FOUND TO BE CRACK. REMOVED, DRILLED UP AND INSTALLED NEW PAX DOOR STIFFENER ON THE AFT WEB IAW SRM 51-40-11 AND 51-42-06.SDR SWIA2026012375590Bracket · elongatedPAX DOOR INTERCOSTAL DD4 AFT BRACKET FOUND TO HAVE ELONGATED HOLE FROM PREVIOUS REPAIR. REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD4 AFT BRACKET IAW SRM 51-40-11, & 51-42-06.SDR IPXA2026022053589Seat Track · corrodedMAJOR REPAIR, MAIN DECK CARGO FLOOR PANEL 231 RJ LOWER LH FWD SKIN HAS CORROSION . INSTALLED SEAT TRACK AT FR28 AND Y1456 LH, I.A.W. A300-600 SRM-53-10-16 AND A300-600 SRM 51-40-21.SDR 2026FA0000198Impulse Coupling · destroyedPILOT REPORT OF FLUCTUATING RPM'S WHILE IN CRUISE FLIGHT, PLUS OR MINUS 400RPM. DURING GROUND RUN FOR TROUBLESHOOTING, RH MAGNETO MAG DROP WAS EXCESSIVE. FURTHER ATTEMPTS AT CLEARING PLUGS, ETC, TO THEN RECHECK RH MAGNETO DROP RESULTED IN COMPLETE ENGINE SHUT SDR 3EJA20260318002Bypass Valve · failedCABIN TEMPERATURE UNCONTROLLABLE. R&R LOW LIMIT BYPASS VALVESDR REXA2026030900186Angle · crackedCRACK ON FLOOR SUPPORT BTW FS278.00 TO FS280.00 AT RBL12 FLOOR SUPPORT BTW FS278.00 TO FS280.00 AT RBL12 WAS FABRICATED PER EA NO: CRJ953-20566 REV. AND REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND CRJ-900 SRM 51-42-21-001-001-A01SDR IPXA2026022453622Floor Panel · corrodedMAJOR REPAIR. MAIN DECK CARGO FLOOR PANEL 231 BH LOWER LH FWD SKIN HAS CORROSION . 89-012 REJECT- THIS IS A MAJOR REPAIR- NO CASS REPORT, SUBTASK UPS FAULT REQUIRES SIGNOFF.SDR HNAA2026030400187Floor Support · crackedAFT WET AREA OB FLOOR SILL AT FR 60 RH, HAS A CRACK. REMOVED AND REPLACED THE AFT WET AREA 1 EA OUTBD FLOOR SILL AT FR 60 PER EMB 145 SRM 51-40-02-PR.SDR HNAA2026030400169Floor Support · corrodedFWD WET AREA RT OMEGA BEAM AT FR 23 CORRODED. REMOVED AND REPLACED THE RT OMEGA BEAM, FR 18 - 23 IAW SRM 51-40-02-PR.SDR HNAA2026030400168Floor Support · corrodedFWD WET AREA FLOOR SUPPORT AFT OF SERVICE DOOR CORRODED. REMOVED AND REPLACED THE AFT FLOOR SUPPORT FROM FR 22 - 23 IAW SRM 51-40-02-PR.SDR HNAA2026030400167Floorbeam · corrodedAFT WET AREA FLOORBEAM, FR 58 CORRODED. INSTALLED A NEW FLOORBEAM IAW SRM 51-40-02, SECTION 3.SDR HNAA2026030400166Door Sill · corrodedCORROSION ON THE MAIN DOOR SILL BTW FR 20 - 22. R & R THE DOOR SILL IAW SRM 51-40-02.SDR IPXA2026022652366Bracket · crackedNR 2 PYLON, INBD SIDE AT RIB 8, BRACKET CRACKED. REMOVED BRACKET I.A.W. A300-600 SRM 51-40-21. INSTALLED BRACKET I.A.W. A300-600 SRM 51-40-21.SDR IPXA2026021552275Bracket · crackedNR 2 PYLON, AFT FAIRING LOWER SURFACE, OTBD BRACKET CRACKED. THE BRACKET WAS REMOVED IAW SRM 51-40-21 & INSTALLED IAW SRM 51-40-21.SDR IPXA2026021552250Bracket · crackedNR 2 PYLON, AFT FAIRING LOWER SURFACE, INBD BRACKET CRACKED. THE BRACKET WAS R & R IAW SRM 51-40-21.SDR SWAA2026022364092Floor Panel · pulledCABIN FLOOR PANEL 231YF HAS PULLED STRANDS. FABRICATED A NEW 231YF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026022364090Floor Panel · pulledCABIN FLOOR PANEL 231ZF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0, DUE TO THE EXTENT OF ALL OF THE DAMAGE.SDR SWAA2026022364094Floor Panel · pulledCABIN FLOOR PANEL 241AF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2026022364095Floor Panel · pulledCABIN FLOOR PANEL 241BF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0, AND DWG:144A5810 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2026022364096Floor Panel · pulledCABIN FLOOR PANEL 242AF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2026022364098Floor Panel · pulledCABIN FLOOR PANEL 241DF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2026022364099Floor Panel · pulledCABIN FLOOR PANEL 241EF HAS PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0, AND BDWG:144A5810, DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2026022364097Floor Panel · pulledCABIN FLOOR PANEL 242CF HAS PULLED STRANDS. THE FLOOR PANEL 242CF WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL DUE TO AMOUNT OF ALL DAMAGE IAW SRM 53-00-50-2R-0, & DWG 144A5810 ID:0125.SDR SWAA2026022364100Floor Panel · pulledCABIN FLOOR PANEL 242DF HAS PULLED STRANDS. THE FLOOR SUPPORT REPLACED WITH A NEWLY FABRICATED FLOOR PANEL DUE TO AMOUNT OF ALL DAMAGE IAW SRM 53-00-50-2R-0, & DWG 144A5810 ID:0123.SDR SWAA2026022364091Floor Panel · pulledCABIN FLOOR PANEL 231XF HAS PULLED STRANDS. FABRICATION OF NEW 231XF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026022363923Scuff Plate · crackedAFT CARGO BAY AFT CORNER THRESHOLD IS CRACKED. AFT CARGO BAY AFT CORNER SCUFF PLATE REPAIRED IAW SRM 53-60-15-2R-1.SDR ASAA2026012364092Seat Track · corrodedMAIN CABIN RBL 45.50 STARTING AT STA. 767+4 INCHES THROUGH STA. 827+8 INCHES SEAT TRACK HAS CORROSION.NOTE: CORROSION LEVEL 1 & NOT MAJOR REPAIR --> NOT SDR (REF: GPM SECTION 16.1) GROUNDED - YES. REMOVED CORROSION ON MAIN CABIN SEAT TRACK AT STA. 767+4" TOSDR ASAA2026012364091Seat Track · corrodedMAIN CABIN, LBL 45.50, 727I + 14 INCHES, SEAT TRACK CORRODED. CORROSION LEVEL 1 & NOT MAJOR REPAIR GROUNDED - YES. REMOVED CORROSION ON THE SEAT TRACK BS 727I + 14", LBL 45.50. ORIGINAL MATL. THICKNESS ON BOTTOM OF TRACK IS .230", REMOVED .027", REMAINISDR IPXA2026021750516Floor Panel · damagedMAJOR REPAIR, AFT CARGO FLOOR PANEL 151UF EDGES DAMAGED. VERIFIED FABRICATION OF PANEL 151UF IS COMPLETED.SDR IPXA2026021750574Floor Panel · damagedMAJOR REPAIR, AFT CARGO FLOOR PANEL 151NG EDGES DAMAGED. VERIFIED FABRICATION OF PANEL 151NG IS COMPLETED.SDR IPXA2026021751305Panel · damagedMAJOR REPAIR, AFT CARGO PANEL 152RF EDGE DAMAGED. VERIFIED FABRICATION OF PANEL 152RF IS COMPLETED.SDR R61A2026021600044Seat Track · gougedWHLE ON HEAVY CHECK - FWD WET AREA R/H SEAT TRACK SEGMENT FR 12/22 WAS FOUND GOUGEDSDR IPXA2026012743275Floor Support · corrodedFLOOR SUPPORT ANGLE AT APPROX STA 1715 OUTBOARD L/H SIDE, IS CORRODED JUST FWD OF AFT PRESSURE BULKHEAD. DOT AA023. STR ATA 51-00 REMOVED DAMAGED FLOOR SUPPORT ANGLE FROM APPROX STA 1715 OUTBOARD L/H SIDE JUST FWD OF AFT PRESSURE BULKHEAD REF. B757-200PF SRM 5SDR AALA202602118718Attach Angle · crackedAIRCRAFT WAS NOT GROUNDED: UPON REMOVAL OF LEFT HAND HEAT EXCHANGER FOUND VAPOR BARRIER INBOARD UPPER ATTACH ANGLE CRACKED. REPAIRED VAPOR BARRIER INBOARD UPPER ATTACH ANGLE IN LEFT HAND ECS BAY. PER B737-NG SRM 57-10-10-2R PROCEDURE 5 REPAIR 5.SDR JJBA20260211016Frame · corrodedCORROSION ON THE LEFT SILL FRAMES 41-47. REMOVED AND REPLACED FILL AT FR 41-47.SDR JJBA20260211015Shear Tie · corrodedAFT WET AREA FRAME SHEAR TIE AT FR 61, RT STR 20R, HAS CORROSION. REMOVED AND REPLACED SHEAR TIE.SDR JJBA20260211013Stringer Splice · corrodedAFT WET AREA STRINGER SPLICE AND FASTENERS BETWEEN FR 60 AND 61, STR 21R, HAS CORROSION. REMOVED AND REPLACED AFT WET AREA STRINGER SPLICE AND FASTENERS BETWEEN FR60 AND 61 STR 21RSDR JJBA20260211009Stringer Splice · corrodedAFT WET AREA STRINGER SPLICE AND FASTENERS BETWEEN FR 60 AND 61, STR 21L, CORRODED. REMOVED AND REPLACED AFT WET AREA STRINGER SPLICE AND FASTENERS BETWEEN FR 60 AND 61 STR 21LSDR JJBA20260211005Support Frame · corrodedCORROSION ON THE LT SILL FRAME 35-41. REMOVED AND REPLACED WITH NEW LT SILL FRAME 35-41.SDR CALA2026020913627Panel · corrodedLAV SERVICE PAN SHOWS EVIDENCE OF CORROSIONREMOVED LAV ACCESS PANELS 141QW, 141PW, AND AND 141MW FOR LAV REPAIR. REMOVED LAV SERVICE DOOR AND HINGES, BAGGED AND TAGGED HARDWARE. CLEANED FUSELAGE SKIN IN PREP FOR MARKING STRINGER AND FRAME LOCATIONS. REMOVED INSDR AALA202602064116Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2026020564192Support Bracket · crackedAFT CARGO BAY SUPPORT BRACKET, BS 867, LBL 13, WL 155 CRACKED. REMOVED AND REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02, AND DWG 149A8109, REV B.SDR CALA2026020413543Stringer · not reportedEA2500-13122 REV ORIGINAL OPS 011 BETWEEN BS 727K AND 727L RT SIDE STRINGER 5R WAP#3 AND GROUND CLIP INTERFERES WITH THE INTERCOSTAL INSTALLATION REQUESTING ENGINEERING ASSISTANCE. SUPPORT TASK EMX N/R 00134. ACCOMPLISHED UAL ECRA 4435-04722 REV ORIGINAL AND SDR CALA2026020413542Bracket · noneGROUND BRACKET AT BS 559 RT SIDE REQUIRES RELOCATION DUE TO GROUND CLIP BEING DISPLACED AND FASTENER HOLES PLUGGED ON UNITED ECRA 2500-16427 REV ORIGINAL FOR EA 2500-13122 REV ORIGINAL OPS 09 REQUESTING ENGINEERING ASSISTANCE FOR RELOCATION DIMENSIONS AND LOCASDR CALA2026020413541Bracket · noneGROUND BRACKET AT BS 500 RT SIDE, REQUIRES RELOCATION DUE TO BRACKET BEING DISPLACED AND FASTENER HOLES PLUGGED ON ECRA 2500-16427, REV ORIGINAL FOR EA 2500-13122 REV ORIGINAL OPS 007 REQUESTING ENGINEERING ASSISTANCE FOR RELOCATION DIMENSIONS AND LOCATION ON SDR DALA2026020300795Proximity Sensor · faultedRIGHT AFT DOOR SHOWING OPEN WHEN IT IS CLOSED. R & R BOTH PROXIMITY SENSORS (22MJ) (24MJ) IAW AMMM 52-71, OPS CHECKED GOOD. (1415962)