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 3EJA202601150002Uplock Switch · out of rigGEAR SELECTED UP. GEAR WOULD NOT RETRACT….STILL HAD 3 GREEN, NO RED. SUCCESSFULLY RIGGED NLG UPLOCK SWITCH, OPERATIONAL CHECK GOODSDR AALA202601155196Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHEAR TIE AT BS 967, AT S25L. REPLACED SHEAR TIE PER AARD 51-00-05-1.SDR AALA202601153868Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER LOCATED FROM BS 907 TO BS 927, AT S26L. REPLACED STRINGER PER SRM 53-00-03-2R.SDR AALA202601159726Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO FLOOR SUPPORT AT BS 907, LBL 30. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1SDR AALA202601157238Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER LOCATED FROM BS 847 TO BS 867, AT S26L. REPAIRED STRINGER IAW SRM 53-00-03-2R.SDR AALA202601151739Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SHEAR TIE AT BS 947, LBL 1. REPLACED SHEAR TIE PER AARD 51-00-05-01.SDR SWAA2026011450886Stringer Clip · crackedCRACKED STRINGER CLIP 7L, BS 727E. REPLACED THE STRINGER CLIP IAW SRM 51-40-02, AND DWG 146A1103-1.SDR SWAA2026011450888Stringer Clip · crackedCRACKED STRINGER CLIP 5L, BS 747. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-05-0G-0, AND DWG 146A1131, REV-.SDR SWAA2026011450884Stringer Clip · crackedCRACKED STR CLIP 7L, BS 727C. REMOVED STRINGER CLIP IAW SRM 51-40-02.SDR SWAA2026011450885Stringer Clip · crackedCRACKED STRINGER CLIP 8L. BS 727C. REPLACED THE STRINGER CLIP IAW SRM 51-40-02, AND DWG 146A1103-1.SDR SWAA2026011450887Stringer Clip · crackedCRACKED STRINGER CLIP 5L, BS 727E. REPLACED THE STRINGER CLIP IAW SRM 51-40-02, AND DWG 146A1103-1.SDR AALA202601149701Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 967, S25L. REPLACED STRINGER CLIP PER AARD 53-00-01-6.SDR AALA202601148986Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 967, S24L. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA202601145542Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 987, S27L. REPLACED STRINGER CLIP PER AARD 53-00-01-6.SDR AALA202601145349Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 907, S25L. REPLACED STRINGER CLIP PER AARD 53-00-01-6.SDR SWAA2026010847625Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE CRACKED AROUND RIVET RBL 36; O/B SIDE OF SILICONE FLEX. ALODINED AND PRIMED ANY BARE METAL SURFACES TO THE REPAIR AREA AND PARTS IAW SRM 51-20-01; AND SOPM 20-41-02 SRM 57-10-10-2R-5; EA-M-24-157-02340, AND EA-M-25-157-00244.SDR ASAA2025120963576Crossbeam · crackedAT PASSENGER COMPARTMENT CENTER BOX STA.540 CROSSBEAM AT RBL.0 CRACKED (MARKED). GROUNDED - YES. REMOVED AND REPLACED CROSSBEAM IAW B737-900ER SRM 51-40-02-0G-0.SDR ASAA2025120963575Floorbeam · crackedAT PASSENGER COMPARTMENT CENTER BOX BS 540 FLOORBEAM AT LBL.0 CRACKED (MARKED). GROUNDED - YES. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-02-0G-0.SDR ASAA2025120963498Attach Angle · crackedA/C BAY VAPOR BARRIER L/H ATTACH ANGLE CRACKED. GROUNDED - YES. REPAIRED VAPOR BARRIER L/H ATTACH ANGLE IAW B737-900 SRM 57-10-10-2R-5.SDR ASAA2025120963497Attach Angle · crackedA/C BAY VAPOR BARRIER RT ATTACH ANGLE CRACKED. GROUNDED - YES. REPAIRED VAPOR BARRIER RT ATTACH ANGLE IAW B737-900 SRM 57-10-10-2R-5.SDR SWAA2026010550961Rib · crackedCRACK INSPAR RIB 129.50 LOCATED AT 27 INCHES OF FRONT SPAR AT LT HORIZONTAL STAB. PERFORMED PERMANENT REPAIR LOCATED ON INSPAR RIB STAB BS 129.50 AND 17 INCHES OF REAR SPAR AT LT HORIZONTAL STABILIZER. IAW SRM 51-40-02 SRM 55-10-09-2R-5. REPAIR 5.SDR SWAA2026010550956Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT. REPAIRED AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT I.A.W. B737-700 SRM 53-30-15-2R-1 REPAIR 1; PARAGRAPH 4. B; STEPS (2 AND 4 TO 7).SDR SWAA2026010548370Support Angle · crackedCRACKED SUPPORT ANGLE LOCATED FWD FACE BS 695 BL 0 WL 208.1 . REPLACED SUPPORT ANGLE AND FASTENERS LOCATED FWD FACE BS 695 BL 0 WL 208.1 AT PASSENGER CABIN I.A.W SRM 51-10-02 ITEM 9 AND DWG 273A9110 SHEET 6 REV -.SDR SWAA2026010548376Floorbeam · crackedCRACKED FLOORBEAM BS 540 BTW BL 0 TO RBL 24.75 WL 208.1. REPLACED IAW SRM 51-40-02; SRM 51-10-02, ITEM 9, AND DWG 143A0060, SHEET 36, REV A.SDR SIMA2026010509001Door · gougedSSI 53-23-21-002. GOUGED OUT (MATERIAL LOSS) AT AFT PASSENGER-DOOR (L2) COMMAND-RAMP ON THE FUSELAGE (AFT SIDE). REMOVED GOUGE FROM AFT PASSENGER-DOOR AFT COMMAND-RAMP (INFERIOR FLANGE) PER EMB-175 SRM 51-10-03. BLENDED AREA MEASURES H=0.059? W=0.086?. ORIGINASDR SWAA2026010248407Rib · crackedCRACKED LEADING EDGE RIB ACCESS PANEL 331B, LE STA 114.55, LT HORIZONTAL STAB. REPLACED THE RIB IAW SRM 51-40-02 AND DWG 186A1305 SHEET 1 REV A; 1186A1001 SHEET 11 REV A. MEASUREMENT OF CRACK:0.285 INCH.SDR SWAA2026010248406Rib · crackedCRACK LEADING EDGE RIB ACCESS PANEL 331B. LE STA 95.96 AT LT HORIZONTAL STAB. REPLACED THE RIB IAW SRM 51-40-02-0G, AND DWG 186A1303, SHEET 1, REV A.SDR SWAA2025122947265Angle · crackedLEFT WING UPPER TRAILING EDGE ANGLE CRACKED, INBD OF MID SPAN DEFLECTION RIB. REMOVED THE CRACKED ANGLE IAW SRM 51-40-02. LOCATED, DRILLED, AND DEBURRED REPLACEMENT ANGLE IAW SRM 51-40-05.SDR SWAA2025122947817Skin · crackedRIGHT WING, NR 7 SLAT NOSE SKIN HAS POSSIBLE CRACK AT ACTUATOR RIB ATTACH POINT. REPAIRED THE CRACKS ON NR 7 SLAT NOSE SKIN IAW SRM 57-42-01-2R-8, REPAIR 8.SDR SWAA2025122947815Skin · crackedRIGHT WING, NR 8 SLAT NOSE SKIN HAD A POSSIBLE CRACK AT ACTUATOR RIB ATTACH POINT. REPAIRED THE CRACKS ON NR 8 SLAT NOSE SKIN IAW SRM 57-42-01-2R-8, REPAIR 8.SDR ASAA2025120963315Transition Panel · corrodedFWD CARGO L/H TRANSITION CORRODED STA 500H. GROUNDED - YES. REMOVED CORROSION IAW B737-900ER SRM 53-00-53-1A-2 REMOVED AND REPLACED TRANSITION PANEL SECTION IAW B737-900ER SRM 53-00-53-2R-5W: .5" O: .040" R: .033" L: 3" D: .007".SDR ASAA2025120963313Transition Panel · crackedFWD CARGO L/H TRANSITION BS 500B PUNCTURED. GROUNDED - YES. REMOVED DAMAGE IAW SRM 53-00-53-1A-2 REMOVED AND REPLACED TRANSITION PANEL DAMAGE SECTION IAW SRM 53-00-53-2R-5.SDR QXEA2025122300373Seat Track · corrodedRIGHT INBD SEAT TRACK CORRODED BETWEEN FRAMES 83 & 84. REMOVED CORROSION AND DETERMINED TO BE OUT OF ALLOWABLE LIMITS IAW ETD 2022-170-022163. REPAIRS MADE TO RT INBD SEAT TRACK IAW SRM P2 53-00-10-02-01.SDR QXEA2025122300372Seat Track · corrodedLEFT INBD SEAT TRACK CORRODED FROM FRAMES 83 - 84. REMOVED CORROSION DETERMINED TO BE OUT OF SERVICEABLE LIMITS. REPAIRED DAMAGED AREA IAW SRM P2 53-00-10-02-01.SDR AALA202512209762Girt Bar · wornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE GIRT CHAFE PATCH WORN AND FRAYED. REPLACED SLIDE PER JOB CARD 08L22125001.SDR AALA202512195164Window · scratchedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PASSENGER CABIN WINDOW AT ROW 20 AFT EMERGENCY EXIT OUTER WINDOW PANE HAS SCRATCHES. INSTALL RIGHT HAND AFT OVER WING EXIT DOOR LINER. PER AMM 52-22-51.SDR DALA2025121909243Skin · damagedSECTION 48 AT BS 1735, WL 200 RT SKIN FOUND AN ABRASION. DAMAGED AREA REPAIRED IAW SRM 53-80-70. (1342752)SDR DALA2025121909242Skin · damagedLEFT FUSELAGE SKIN AT BS 1730, WL 200 FOUND AN ABRASION. DAMAGED AREA REPAIRED IAW SRM 53-80-70. (1342749)SDR DALA2025121909241Skin · damagedSECTION 48 AT BS 1735, WL 200 LT SKIN FOUND AN ABRASION. DAMAGED AREA REPAIRED IAW SRM 53-80-70. (1342740)SDR DALA2025121909240Skin · damagedRT FUSELAGE SKIN AT BS 1730 WL 200 FOUND AN ABRASION. DAMAGED AREA REPAIRED IAW SRM 53-80-70 (1342733)SDR SWAA2025121844050Angle · crackedLEFT WING UPPER TRAILING EDGE ANGLE FOUND CRACKED, INBD OF MID SPAN DEFLECTION RIB. REMOVED THE CRACKED ANGLE IAW SRM 51-40-02.SDR SWAA2025121750837Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1668 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK M1668 IAW AMM 33-51-06-960-805, PERFORMED A GOOD TEST.SDR SWAA2025121649075Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 241GF DELAMINATED. REMOVED AND REPLACED THE FLOOR PANEL IAW AMM 53-21-00-401-NG.SDR SWAA2025121649074Floor Panel · delaminatedMAIN CABIN FLOOR PANEL 241RF DELAMINATED. REMOVED AND REPLACED IAW AMM 53-21-00-401-NG.SDR AALA202512162853Striker · dirtyAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR LOCK STICKS CLOSED. REMOVED STICKY DIRT FROM LATCH FLOOR STRIKE PLATE, DOOR AND DOOR LATCH OPERATED SEVERAL TIMES NO DEFECTS NOTED. PER CMM 25-40-64.SDR ASAA2025120963013Rib · crackedINSIDE RT HORIZONTAL STAB, RIB AT HSS 92.7 HAS 2 CRACKS (MARKED IN RED). GROUNDED - YES. REPAIRED THE RT HORIZ STAB, RIB AT HSS 92.7 (2EA) USING PN:BAC1505-100962 7075-T73511 PO:1137296.2 AND PN:BAC1490-2793 7075-T62 PO:1137296.1 IAW SRM 55-10-09-2R-4. REMOVESDR ASAA2025120962985Battery · inoperativeEMERGENCY LIGHT BATTERY PACK ON POWER SUPPLY M1670 AT SEAT ROW 22DEF REQUIRES REPLACEMENT. GROUNDED - YES. REMOVED AND REPLACED AND PERFORMED OPS CHECK ON EMERGENCY LIGHT BATTERY PACK AT SEAT ROW 22DEF IAW AMM 33-51-06. OPS CHECK GOOD.SDR ASAA2025120962977Handle · no discrepancyR1 DOOR OUTSIDE HANDLE WILL NOT OPEN DOOR. GROUNDED - YES. OPENED R1 DOOR IAW AMM 52-41-00 NO DEFECTS NOTED CLOSED R1 DOOR OPS CK GOOD SEAMC PETER NOTIFIED.SDR SWAA2025121544175End Plug · missingAFT GALLEY R2 SLIDE COVER CENTER BUMPER STRIP MISSING END CAP. REPLACED AFT GALLEY R2 SLIDE COVER CENTER BUMPER STRIP END CAP IAW AMM 25-66-01.SDR SWAA2025121548850Strip · missingAFT GALLEY R2 SLIDE COVER CENTER BUMPER STRIP MISSING END CAP. REPLACED AFT GALLEY R2 SLIDE COVER CENTER BUMPER STRIP END CAP IAW AMM 25-66-01.