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 IPXA2025082275003Adapter · wornADAPTER AT FR56 Y0 RH HAS CORROSION COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94652-REQ1 AND VT-MAE EA 300-5316-27-A4065 REV. - .SDR IPXA2025082273957Adapter · wornCLS ADAPTER AT FR54.2 Y0 RH HAS WEAR DOT 5612-15 COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94652-REQ1 AND VT-MAE EA 300-5316-27-A4065 REV. - .SDR IPXA2025082274190Adapter · wornCLS ADAPTER AT FR62 Y0 LH HAS WEAR DOT 5612-16 COMPLIED ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94688-REQ1 AND VT-MAE EA 300-5317-27-A4067 REV. - .SDR JJBA20250822051Support · crackedRH PRECOOLER SUPPORT CRACKED R/H PRECOOLER AFT SUPPORT REMOVED AND REPLACED.SDR SWAA2025082192518Support · corrodedCORROSION SUPPORT ZEE AT LEVEL STR 25L AND BTW BS 727 TO 807 WL 156.4. REPLACED SUPPORT ZEE IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, DWG 146A7500, SHEET 85, REV A, DWG 1467502, SHEET 27, REV-, AND DWG 149A8102, SHEET 14, REV-.SDR SWAA2025082192522Channel · elongatedELONGATED HOLE INTERNAL STRUCTURE RAIL CHANNEL LOCATED AT LEVEL BS 794.5 AND RBBL 8.10. PERFORMED PERMANENT REPAIR ON RAIL CHANNEL LOCATED FROM BS 747 TO BS 827 IAW SRM 53-00-53-2R-2 REPAIR 2.SDR SWAA2025082192516Intercostal · corrodedCORROSION WEB - INTERCOSTAL AT LEVEL OF RBL 13.84 AND BTW BS 727A AND 727B AFT CARGO COMPARTMENT. REPLACED WEB-INTERCOSTAL IAW SRM 51-10-02-0G-0, PARAGRAPH 9, AND SRM 51-40-02-0G-0,;DWG 146A7500, SHEET 86, REV ASDR SWAA2025082192519Support · corrodedCORROSION SUPPORT ZEE BTW BS 727 - 767, S25R, WL 156.4, AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE IAW SRM 51-10-02, ITEM 9, AND DWG 146A7500, SHEET 85, REV A, DWG 146A7502, SHEET 26, REV -.SDR IPXA2025081681965Adapter · brokenCLS ADAPTER AT FR34 RH OB IS BROKEN. COMPLIED WITH REMOVE AND REPLACE 1(EA) CLS ADAPTER P/N B53774136204 PER PRODUCTION DRAWING REQUIREMENTS AND A300-600F SRM CHAPTER 51 REQUIREMENTSSDR IPXA2025081681917Adapter · brokenCLS ADAPTER AT FR37 RH OB IS BROKEN. COMPLIED WITH REMOVED AND REPLACE 1(EA) CLS ADAPTER P/N B53774136204 PER PRODUCTION DRAWING REQUIREMENTS AND A300-600F SRM CHAPTER 51 REQUIREMENTSSDR IPXA2025081281580Adapter · crackedCLS ADAPTER AT FR38.1 LH OB IS BROKEN DOT 5612-28 COMPLIED WITH REMOVE AND REPLACE 1(EA) CLS ADAPTER P/N B53774136204 PER PRODUCTION DRAWING REQUIREMENTS AND A300-600F SRM CHAPTER 51 REQUIREMENTSSDR SIMA20250717006Shear Panel · corrodedFR 87-88 CABIN FLOOR STRUCTURE LH SHEAR PANEL IS CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACE FR 87-88 CABIN FLOOR STRUCTURE LH SHEAR PANEL IAW ERJ 170 SRM 51-40-08.SDR SIMA20250717005Shear Panel · corrodedFR 87-88 CABIN FLOOR STRUCTURE RH SHEAR PANEL IS CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACE FR 87-88 CABIN FLOOR STRUCTURE RH SHEAR PANEL IAW ERJ 170 SRM 51-40-08.SDR SWAA2025081892565Support Bracket · crackedCRACKED LOWER O/B PULLEY BRACKET SUPPORT BS 692 LBL 25 WL 203. REMOVED. FABRICATED, AND INSTALLED LOWER O/B PULLEY BRACKET SUPPORT BS 692 LBL 25 WL 203 IAW SRM 51-40-02-0G-0; 51-10-02-0G-0 AND BOEING DWG 273A9110 REV:A; 273A9112 REV H.SDR SIMA20250717003Floor Support · corrodedCABIN FLOOR STRUCTURE FR 84 LH PANEL SUPPORT IS CORRODED. (LEVEL 2 CORROSION). REMOVED AND REPLACED FR 84 LH FLOOR PANEL SUPPORT IAW ERJ 170 SRM 51-40-08.SDR SIMA20250717004Floor Support · corrodedCABIN FLOOR STRUCTURE CENTER RH FLOOR BEAM IS CORRODED BTW FR 85-86. (LEVEL 2 CORROSION). REMOVED AND REPLACED CABIN FLOOR STRUCTURE CENTER RH FLOOR BEAM UPPER SHEET IAW ERJ 170 SRM 51-40-08.SDR SWAA2025081592307Stringer · corrodedCORROSION ON STRINGER; S-28L END SPLICE IN BILGE AREA AFT OF E/E COMPARTMENT DOOR CUTOUT BS350+8 LBL10 WL140.<[01] REMOVED 2 FASTENERS ON REPORTED CORROSION AREA CLEAN AREA; REMOVED PROTECTIVE TREATMENT AND NOT CORROSION FOUND;[02] CORRECTION ITEM 1: REMOVED 2SDR SWAA2025081492536Floorbeam · crackedCRACK FLOOR STRUCTURE BRAKE PANEL BS 540 AND RBL 1 AT PASSENGER CABIN. REPLACED FLOOR STRUCTURE BRAKE PANEL BS 540 AND BTW RBL 0 TO RBL 24.75 PASSENGER CABIN IAW SRM 51-10-02 PRAG 9; SRM 51-40-02 AND DRAWING 143A0060 SHEET: 36 REV: A.SDR SWAA2025081492537Floorbeam · crackedCRACK FLOOR STRUCTURE BRAKE PANEL BS 540 AND LBL 1 AT PASSENGER CABIN. REPLACED FLOOR STRUCTURE BRAKE PANEL LOCATED ON BS 540 AND LBL 1 AT PASSENGER CABIN IAW SRM 51-40-02; AND SRM 51-10-02-0G-0 PARAGRAPH 9.SDR SWAA2025081492290Rib · crackedCRACK ON INSPAR RIB 3 HSS 111.10 AT 38 INCHES FROM FRONT SPAR (STIFFENER 4) RT HORIZONTAL STAB. PERFORMED REPAIRED ON INSPAR RIB 3(STAB STA 111.10) AT 38 INCHES FROM FRONT SPAR RH HORIZONTAL STAB IAW SRM 55-10-09-2R-4 REPAIR 4.SDR SWAA2025081492311Structure · crackedCRACK ON RT WING NR 7 SLAT AT SLAT STATION 322.71. REPAIRED IAW SRM 57-42-01-2R-8.SDR AALA202508133188Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 949, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508130723Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947 RBL 53. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5 AND EA 366810 AND EA 366572.SDR SWAA2025081292284Stringer Clip · crackedCRACKED STRINGER CLIP AT PAX CABIN BS 727B, S7L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0 AND DWG 146A1102 REV -.SDR SWAA2025081292298Access Panel · elongatedELONGATED HOLE ACCESS PANEL 561AB TRAILING EDGE AT LT WING. REPAIRED THE ACCESS PANEL 561AB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025081292291Angle · crackedCRACK ANGLE ON SLAT 6 INBOARD AUXILIARY AT RT WING (1 E/A), REPLACED ANGLE LOCATED ON SLAT 6 INBOARD AUXILIARY AT RT WING IAW SRM 51-40-02 AND DWG 114A5030, SHEET 8, REV C, DUE TO NOT FOUND ALLOWABLE DAMAGE ON SRM 57-42-01.SDR SWAA2025081292545Light · brokenBROKEN PHOTOLUMINESCENT STRIP LH (5EA) AT PASSENGER CABIN. THE REPLACEMENT PHOTOLUMINESCENT STRIP LH (5EA) SEE TTG8Q003KHW1.SDR SWAA2025081292546Light · brokenBROKEN PHOTOLUMINESCENT STRIP RH (5EA) AT PASSENGER CABIN. THE REPLACEMENT PHOTOLUMINESCENT STRIP RH (5EA) SEE TTG8Q003KHW1.SDR SWIA2025081100717Seat Track · gougedRH LATERAL SEAT TRACK HAS MULTIPLE GOUGES AND CORROSION AS MARKED FR 16- FR 20SDR AALA202508118526Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 8 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508116414Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508116233Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508114435Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508112753Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202508118052Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR IXXA20250809002Keelbeam · corrodedLH KEEL BEAM, LOWER FLANGE, CORROSION FOUND TO BE BEYOND ALLOWABLE LIMITS AT STATION 782-786SDR AALA202508079012Attach Fitting · wornAIRCRAFT IN BASE MAINTENANCE: NUMBER 2 TRANSMISSION ATTACH FITTING MOUNTING BOLTS ARE WORN AT TRACK MOUNTS. INSTALLED AND REAMED NUMBER 2 AFT TRACK FORWARD AND AFT TRANSMISSION ATTACH SUPPORT FITTING BUSHINGS. PER SOPM 20-50-03.SDR AALA202508054584Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE FROM BS 380 TO BS 400 AT RBL 10. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508058956Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE FROM BS 380 TO BS 400 AT BL 0. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202508052179Panel · separatedAIRCRAFT IN BASE MAINTENANCE: PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT BS 520, RBL 42 IS SEPARATED. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202508058819Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 500I TO BS 520 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508057585Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CHORD) AROUND LAVATORY MOUNT AT STA 947, LBL 23.5 REPAIRED UPPER CHORD PER SRM 53-70-51 AND EA 366572SDR ASAA2025071759803Transition Panel · corrodedFWD CARGO R/H TRANSITION STA 500C-500D CORRODED. GROUNDED - YES. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS IAW B737-800 SRM 53-00-53-1A-2 REPAIRED TRANISITION IAW B737-800 SRM 53-30-53-01-2.W= 1.00 O= .040 R= .020 L= 4.75 D=.020.SDR ASAA2025071759802Shield · corrodedFWD CARGO R/H AFT SHIELD CORRODED AROUND FASTENER HOLE. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED AFT SHIELD IAW BOEING 737-800 SRM 51-40-02-0G-0W 1" O .032 R .026 L 1" D .006.SDR IPXA2025080183415Skin · crackedRH OUTBOARD ELEVATOR HAS TWO CRACKS AND NUMEROUS LOOSE AND MISSING RIVITS ON UPPER LEADING EDGE. INSTALLED RHOB ELEVATOR IAW AMM 27-31-02-404-016 UP TO STEP 3.H.(2). FINISHED REMAINING STEPS OF AMM 27-31-02-404-016 FOR OUTBOARD ELEVATOR INSTALL.SDR AALA202508014345Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION CENTER FITTING LOCATED BTW FR 66 AND FR 68 AT LEVEL OF STR 23L AFT GALLEY AREA L=1.780 INCH W=0.130 INCH D=0.015 INCH. MAINTENNCE REPLACED CENTER FITTING LOCATED BTW FR66 AND FR68 AT LEVEL OF STR 23L AFT GALLEY AREA IAW SDR AALA202508013327Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 986, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202508017803Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 847 AT S25L, LBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202507319800Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AFT LAVATORY VENT LOCATED AT THE SIDE FUSELAGE BS 920 BETWEEN STR 21L TO 22L. INSTALLED DOUBLER REPAIR ON SKIN. PER EA 366657 AND SRM 51-10-01, FIGURE 2.SDR AALA202507250856Fuel Panel · faultedAIRCRAFT WAS NOT GROUNDED: IN FLIGHT RIGHT AFTER FUEL LOW PRESSURE LIGHT ILLUMINATED STEADY FOR SEVERAL MINUTES AND DID NOT EXTINGUISH. VERIFIED RIGHT AFT BOOST PUMP INOPERATIVE. REMOVED AND REPLACED P5 PANEL ASSEMBLY. PER AMM 28-22-43.