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 SWI2025F01881Tie Down · corrodedFWD CARGO TIE DOWN MACHINED BRACKET NEAR FS565.00 AND BETWEEN STRINGER 26R AND 27 IS CORRODED. REMOVED AND REPLACED FWD CARGO TIE DOWN MACHINED BRACKET NEAR FS565.00 AND BETWEEN STRINGER 26R AND 27 PER SRMS 51-42-22-001-001-A01, SRM 51-42-21-001-001-A01, SRSDR SWI2025F01880Slat Track · groovedINBD AND OTBD SIDE OF LH SLAT TRACK 3-2 GROOVED. BLENDED AND TREATED INBD AND OTBD SIDE OF LH SLAT TRACK 3-2 PER MHIRJ REO 690-57-42-1327 REV--, DATED 2025-10-17. ALL STEPS OF REO COMPLIED WITH IN THEIR ENTIRETY. SEE CONTINUATION STEPS FOR MORE DETAILS. ALL CSDR SWI2025F01879Slat Track · corrodedINBD SIDE OF LT SLAT TRACK 1-1 HAS CORROSION BLENDED AND TREATED CORROSION ON THE LH SLAT TRACK 1-1 PER MHIRJ REO 690-57-42-1328 REV --. ALL STEPS OF REO COMPLIED WITH IN THEIR ENTIRTY. SEE CONTINUATION STEPS FOR FURTHER DETAILS. ALL CHECKS GOOD.COMPLIED WITH SDR SWI2025F01878Tie Down · corrodedFWD CARGO TIE DOWN MACHINED BRACKET NEAR FS565.00 AND NEAR STRINGER 23L IS CORRODED. (MARKED) (S/N#00844) (C-CHECK RO 12/24/2025)REMOVED AND REPLACED FWD CARGO TIE DOWN MACHINED BRACKET PN SH670-33390-2 NEAR FS565.00 AND NEAR STRINGER 23L PER DWG NO SH690-336SDR SWI2025F01877Hinge Fitting · gougedTHE PAX DOOR PIANO HINGE ON THE DOOR SIDE LAST LUG AROUND SPRING PIN HOLE IS GOUGED. COMPLIED WITH RECEIVED REO 670-52-11-511 REV.-E. TYPE I: DISPOSITION FOR OUTER OF LUGS (GOUGE, CHAFING). BLEND PERFORMED USING A TAPER RATIO 5:1. LUG WALL THICKNESS IS STILSDR SWI2025F01876Slat Track · damagedLEFT WING SLAT TRACK 3-3 UNDERSIDE HAS GROOVES/WEAR. BLENDED AND TREATED THE WEAR/GROOVES ON THE UNDERSIDE OF THE LT WING SLAT TRACK 3-3 IAW REO 690-57-42-1330, REV--. ALL STEPS OF THE REO COMPLIED WITH. SKYCARD 51-900-1002-SKY COMPLIED WITH.SDR SWI2025F01875Slat Track · damagedLEFT WING SLAT TRACK 3-1 UNDERSIDE HAS GROOVES/WEAR. BLENDED AND TREATED THE WEAR/GROOVES ON THE UNDERSIDE OF THE LT WING SLAT TRACK 3-1 IAW REO 690-57-42-1329 REV--. ALL STEPS OF THE REO COMPLIED WITH. . SKYCARD 51-900-1002-SKY COMPLIED WITH.SDR SWI2025F01874Slat Track · damagedLEFT WING SLAT TRACK 1-1 UNDERSIDE HAS GROOVES/WEAR. BLENDED AND TREATED THE WEAR/GROOVES ON THE UNDERSIDE OF THE LT WING SLAT TRACK 1-1 PER REO 690-57-42-1328 REV--. ALL STEPS OF THE REO COMPLIED WITH. SKYCARD 51-900-1002-SKY COMPLIED WITH.SDR SWI2025F01873Bracket · corrodedFWD CARGO TIE DOWN MACHINED BRACKET NEAR FS533.00 AND STRINGER 25L IS CORRODED. REMOVED AND INSTALLED FWD CARGO TIE DOWN MACHINED BRACKET NEAR BS 533 AND STRINGER 25 NEW BRACKET IAW SRM 51-42-21-001-001-A01, SRM 51-42-15-001-001-A01, SRM TASK 51-42-06-001-001SDR SWI2025F01872Stringer Splice · corrodedSTRINGER SPLICE ON 19R BETWEEN FS469.00 AND 485.00 IS CORRODED. (S/N#00850) (C-CHECK RO 12/24/2025)REMOVED AND INSTALLED NEW STRINGER SPLICE ON STGR 19R BETWEEN FS469.00 AND 485.00 PER REF RJ900 SRM 51-42-06-001-001-A01 AND DWG SH670-30006 REV-A. SEE CONTINUASDR SWIA202512260001Stringer · corrodedSTRINGER 21R BETWEEN FS597.00 AND FS 613.00 IS CORRODED. REPAIRED STRINGER 21R BETWEEN FS597.00 AND FS 613.00 REF CRJ900 SRM 53-00-03-201-001-A02 REPAIR S6294 TYPE Z6 STRINGER SPLICES - SOLUTION I - FS280.00 TO FS977.00 FIGURE 53-00-03-995-806, COMPLIED WITH SDR AALA202512248147Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 59 TO FR 60 AND BTW STRG 42L TO STRG 43L IN AFT CARGO COMPARTMENT L= 20.07 IN, W=3.569 IN, D=0.025.SDR AALA202512184955Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 42L LOCATED BTW FR 59 TO FR 60 IN AFT CARGO COMPARTMENT L= 2.474IN W= 0.447IN D= 0.083IN. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON STRINGER 42 L LOCATED BTW FR 59 TO FR 60 IN AFT CARGO COMPARTMENT IAW EASDR AALA202512157352Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA ON FRAME JOINT AREA AT LEVEL OF LOWER TENSION BOLT RH SIDE LENGTH =0.197 INCH APPROX. MAINTENANCE PERFORMED TIME LIMITED REPAIR INSTRUCTIONS (REPLACED FRONT WSDR AALA202512151340Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 43L LOCATED BTW FR 59 TO FR 60 IN AFT CARGO COMPARTMENT L= 0.704 IN, W= 0.584 IN, D= 0.002IN. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON STRINGER 43L LOCATED BTW FR 59-FR 60 IN AFT CARGO COMPARTMENT IAW EA SDR AALA202512120707Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK WINDSHIELD FRAMING LEFT HAND CONTINUITY FITTING CRACKED BETWEEN FR 1 AND FR 4 AT Y0. REPLACED CONTINUITY FITTING PER EA 368108.SDR AALA202512085332Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 59 TO FR 60 AND BTW STRG 41L TO STRG 42L IN AFT CARGO COMPARTMENT.MEASURE CORROSION ARE L=3.432 INCH W=2.122 INCH D=0.002 INCH. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON REAR FUSELAGE ISDR AALA202512089920Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA UPPER RADIO L/H SIDE ADJACENT AT UPPER TENSION BOLT CRACK DIRECTION 2 OCLOCK, CRACK LENGTH =0.188 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR INSTRUCTIONS SDR AALA202512044909Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK CENTER WINDSHIELD FRAMING RIGHT CONTINUITY FITTING CRACKED BETWEEN FR 1 AND FR 4 AT Y0. REPLACED CONTINUITY FITTING PER EA 368108.SDR AALA202512018174Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK WINDSHIELD FRAMING RIGHT HAND WINDOW POST FRAME UPPER ATTACHMENT AT FR 4. REPLACED WINDSHIELD FRAME PER EA 368189.SDR AALA202511282439Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON OPEN FASTENER HOLE LOC.ON WINDSHIELD SIDE POST AT FR.4 LH INTERNAL SIDE OF THE UPPER ATTACHMENT AREA, INTERNAL FI TTING VERTICAL FLANGE MEASURE OF CRACK IS: L: 0.145 INCH. MAINTENANCE ACCOMPLISHED PERMSDR AALA202511288958Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 61 TO FR 62 AND BTW STRG 43R TO STRG 44 IN AFT CARGO COMPARTMENT MEASURES OF CORROSION ARE: L=4.699 IN, W=3.89 IN, D=0.008 IN. MAINTENANCE ACCOMPLISHED INTERIM REPAIR AT LEVEL FR 62 BTW STRG SDR AALA202511289667Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 56 TO FR 57 AND BTW STRG 43L TO STRG 44 IN AFT CARGO COMPARTMENT L= 3.000 IN, W= 2.927 IN, D= 0.003 IN. MAINTENANCE INSTALLED DOUBLER ON SKIN.SDR AALA202511247615Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL SKIN LOCATED BTW FR 58 TO FR 59 AND BTW STRG 42L TO STRG 43L IN AFT CARGO COMPARTMENT MEASURMENT OF CORROSION ARE: L= 1.494 IN, W=0.800IN D=0.002IN. MAINTENANCE REPAIRED SKIN PANEL IAW EA 369173.SDR AALA202511216246Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 42L LOCATED BTW FR 56 TO FR 57 IN AFT CARGO COMPARTMENT MEASURE OF CORROSION ARE: L= 0.685 INCH, W= 0.335 INCH, D= 0.002 INCH. MAINTENANCE PERFORMED REPAIR ON STRINGER 42L. LOC BTW FR 56 TO FR 57 IN AFT CARGO CSDR AALA202511184895Cleat · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL STRUCTURE FR34 AND S42R TO S43R CLEAT IN FWD CARGO COMPARTMENT. L=3.020 INCH W=0.820 INCH D=0.002 INCH. MAINTENANCE REPLACED CLEAT AT FR34 AND S42R TO S43RSDR AALA202511138163Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHEAR TIE AT FR 62 BETWEEN S43R AND S44R. REPLACED SHEAR TIE PER SRM 51-42-11.SDR AALA202510246518Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON CONNECTING FITTING ON MLG AREA RH SIDE L=0.152 INCH. MAINTENNCE ACCOMPLISHED PERMANET REPAIR INSTRUCTION (REPLACED CONNECTING PLATE) LOC BTW FR42 TO FR43 AT LEVEL OF WEB W10 AT MLG AREA ON RH SIDE IAW EA 368105, A320 SRM SDR SWAA2025102314094Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 120.30 AND 27 INCHES FROM FRONT EDGE LT HORIZONTAL STAB.SDR SWAA2025102314093Rib · crackedCRACK INSPAR RIB LOCATED STAB STA120.30 AND 19 INCHES FROM FRONT EDGE LT HORIZONTAL STAB.SDR SWAA2025102214153Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 129.50 AND 34 INCH FROM FRONT EDGE AT RT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR ON INSPAR RIB IAW SRM 55-10-09-2R-5, REPAIR 5, FIG 204, DETAIL A.SDR SWAA2025102114280Handle · deterioratedDETERIORATED NUT ON ASSIST HANDLE FWD ENTRY DOORWAY LINNING CUTOUT AT FWD GALLEY AREA (2EA). REPLACED NUT ON ASSIST HANDLE FWD ENTRY DOORWAY LINNING CUTOUT AT FWD GALLEY AREA (2EA) IAW BOEING SOPM 20-50-01 REV. NO39;[03] REPLACED NUT ON ASSIST HANDLE FWD ENTRSDR SWAA2025102114261Access Panel · delaminatedDELAMINATED ACCESS PANEL 191D BODY FAIRING AT LOWER FUSELAGE. REPAIRED ACCESS PANEL 191D BODY FAIRING AT LOWER FUSELAGE IAW SRM 51-70-04-2R-2 REPAIR 2.SDR SWAA2025102114258Nut Plate · corrodedCORROSION RAIL NUT PLATE LOCATED ORSS282 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT PLATE LOCATED ORSS282 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 112A4402 SHEET: 40 REV: A.SDR SWAA2025102114252Nut Plate · corrodedCORROSION RAIL NUT PLATE LOCATED OFSS449 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT PLATE LOCATED OFSS449 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-10-02 ITEM 9 SRM 51-40-02 AND DWG 112A4402 SHEET 40 REV A.SDR SWAA2025102114263Nut Plate · corrodedCORROSION RAIL NUT PLATE LOCATED OFSS574 INTERNAL CAVITY LEADING EDGE AT LT WING . REPLACED RAIL NUT PLATE LOCATED OFSS574 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9, AND DWG:112A4402 SHEET 41, REV A.SDR SWAA2025102114264Web · crackedCRACK ON WEB LOCATED BTW BS 312 TO BS 328 RBL 31 WL 208.1 AT FWD GALLEY AREA. REPLACED NEW WEB INTERCOSTAL LOCATED BTW BS 312 TO BS 328 RBL 31 WL 208.1 AT FWD GALLEY AREA AND FASTENER IAW. B737-800 SRM 51-10-02-0G-0 SRM 51-40-02-0G AND DRAWING 141A5400 SHEET SDR SWAA2025102114269Floor Support · corrodedCORROSION ON FLOOR SUPPORT LOCATE BTW BS 312 TO BS 328 LBL 12 WL 208.1 AT FWD GALLEY AREA. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02 ITEM 9 AND DWG 141A5400 SHEET 27 REV -.SDR SWAA2025102114270Floor Support · crackedCRACK WEB-INTERCOSTAL LOCATED BTW STA 344 TO STA 360 BL 0 AT FWD GALLEY AREA. REPLACED WEB-INTERCOSTAL LOCATED BTW STA 344 TO STA 360 BL 0 AT FWD GALLEY AREA IAW. B737-800 SRM 51-40-02 AND DRAWING 141A5400 SHEET 32 REV -.SDR SWAA2025102114272Floor Support · crackedCRACK WEB -INTERCOSTAL LOCATED BTW STA 312 TO STA 328 LBL 45 AT FWD GALLEY AREA. REPLACED NEW WEB INTERCOSTAL LOCATED BTW STA 312 TO STA 328 LBL 45 AT FWD GALLEY AREA AND FASTENER IAW. B737-800 SRM 51-10-02-0G-0 ITEM 9; 51-40-02-0G AND DRAWING 141A5400 SHEETSDR SWAA2025102114271Plate · corrodedCORROSION PLATE LOCATED STA 312 LBL 54 AND WL 208.1 AT FWD GALLEY AREA. REPLACED PLATE LOCATED STA 312 LBL 54 AND WL 208.1 AT FWD GALLEY AREA IAW SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9. AND APPLIED TORQUE OF 150 LB-IN IAW SRM 51-40-04-0G-0.SDR SWAA2025102114117Access Panel · crackedCRACK ACCESS PANEL 561CB AT LT WING. REPAIRED ACCESS PANEL 561CB AT LT WING IAW B737-800 SRM 51-70-04-2R-10 REPAIR 10.SDR ASAA2025091261650Plate · corrodedSTA 727L-787. LH FLOOR PLATE WITH CORROSION. GROUNDED - YES. REPAIRED FLOOR PLATE STA 727L-787 IAW B737-900ER SRM 53-00-53-2R-6 AND 51-40-02 PN: BAC1496-377 7075-T62 PO: 1133954.2 REMOVED CORROSION, ORIGINAL THICKNESS IS .040 REMOVED .010, REMAINING THICKNESS SDR ASAA2025091261649Plate · corrodedSTA 727F-727K. LH FLOOR PLATE WITH CORROSION. GROUNDED - YES. REPAIRED FLOOR PLATE STA 727F-727K IAW SRM 53-00-53-2R-6 AND 51-40-02 PN: BAC1496-377 7075-T62 PO:1133954.2. REMOVED CORROSION. ORIGINAL THICKNESS IS .040 REMOVED 100%, NO REMAINING THICKNESS AND WASDR ASAA2025091261648Plate · corrodedSTA 727A-727E. LH FLOOR PLATE WITH CORROSION. GROUNDED - YES. REPAIRED FLOOR PLATE STA 727A-727E IAW SRM 53-00-53-2R-6 AND 51-40-02 PN: BAC1496-377 7075-T62 PO: 1133954.2. REMOVED CORROSION, ORIGINAL THICKNESS IS .040 REMOVED .024, REMAINING THICKNESS IS .016 SDR ASAA2025091261647Plate · corrodedSTA 727-767, RT FLOOR PLATE WITH CORROSION GROUNDED - YES. REMOVED AND REPLACED RT FLOOR PLATE FROM STA 720-760 IAW SRM 51-40-02 AND 53-00-53-2R-5 PN:BAC1496-377 7075-T62 PO: 1133954.1. ORIGINAL THICKNESS .040, REMAINING THICKNESS .024, MAT LOSS .016 AND IS FOSDR SWAA2025102014281Nut · deterioratedDETERIORATED NUT ON ASSIST HANDLES AFT DOORWAY LINING CUTOUT LT AND RT SIDE AT AFT GALLEY AREA (4EA). REPLACED NUT ON ASSIST HANDLES AFT DOORWAY LINING CUTOUT LT AND RT SIDE AT AFT GALLEY AREA (4EA) IAW BOEING SOPM 20-50-01 REV. NO 39.SDR SWAA2025101614265Support Angle · crackedCRACK ON ANGLE - SUPPORT LOCATED BS727B CEILING AREA LH SIDE AFT CARGO COMPARTMENT. INSTALLED REPAIR PARTS AND FASTENER [3] ANGLE (1E/A); [2] SHIM (1E/A) LOCATED BS727B CEILING AREA LH SIDE AFT CARGO COMPARTMENT IAW. B737-800 SRM 51-70-11-2R-0 REPAIR GENERAL SDR IPXA2025091972305Adapter · brokenMAIN CARGO DECK, CLS ADAPTER AT RH SIDE JUST IN FRONT OF REDLINE MARKER NR 1 BROKEN. REMOVED CLS ADAPTER DAMAGE AT THE RT SIDE. FR20 IAW AIRBUS SRM 51-40-21-001. INSTALLED ADAPTER CLS, AT MAIN CARGO DECK, FLOOR STRUCTURE FR20 Y1954. IAW SRM 51-40-21-001.SDR REXA2025101500951Door · crackedFOUND LT FWD OVERWING EMERGENCY EXIT FWD UPPER LUG TO BE CRACKED ALL WORK WAS PERFORMED ON AFT LUG OF THE LT FWD DOOR, LOCATION WAS JUST DOCUMENTED INCORRECTLY. STRIPPED ORGANIC FINISH FROM LT FWD OVERWING EMERGENCY EXIT DOOR FWD UPPER LUG IAW SRM 51-26-01-