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 HNAA2025112500821Rib · crackedLEFT WING, UPPER SECTION OF RIB 21 IS CRACKED. INSTALLED DOUBLER AND FILLER ON LH WING UPPER SECTION OF RIB 21. IAW EMB 145 SRM 57-20-07-RE, ITEM 4, FIG. 203, DET. C. AND E01-57-25-0425SDR AALA202511246275Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM +Y765 LOC. AT LEVEL FR16 AT FWD GALLEY AREA L=1.144 IN, W=1.005 IN, D= 0.050 IN . MAINTENANCE REPLACED FLOOR BEAM Y765 SECTION BTW FR 12 AND FR 24 AT FWD GALLEY AREA I.A.W. A319 SRM 51-42-11-801, A319 SRM 51-SDR AALA202511218809Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SEAT TRACK +Y1292 LOC. AT LEVEL FR16 AT FWD GALLEY AREA MEASURES OF CORROSION ARE: L=1.598 IN, W=1.117 IN, D= 0.050 IN. MAINTENANCE REPLACED SEAT TRACK Y1292 LOC. BTW FR 12 AND FR 24 AT FWD GALLEY AREA IAW A319 SRM 51-4SDR AALA202511208039Access Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING FUEL TANK ACCESS PANEL 540JB COUNTERSUNK FASTENER HOLES. MAINTENANCE REPLACED LEFT WING FUEL TANK ACCESS PANEL 540JB PER SRM 57-27-11.SDR IPXA2025110357102Floor Support · corrodedWORKING FAULT T3F18E007KJYV LINE 920 STA 879 FLOOR BEAM FOUND CORROSION ON LWR. FWD STRAP ATA-53-05 INSP VERIFIED STEP 16 OUT OF SEQUENCE INSTALLED REPLACEMENT RADIUS FILLER P/N 143N5553-1 PER BOEING DWG. 143N5255 REQUIREMENT AND B757-200PF SRM 51-40-02-0G -0.SDR SWAA2025111830618Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 276 AT RT WING. REPLACED ANGLE TRAILING EDGE LOCATED ORSS 276 AT RT WING IAW SRM 51-40-02. MEASURE CRACK IS:0.996.SDR SWAA2025111830620Angle · crackedCRACK ANGLE TRAILING EDGE LOCATED ORSS 271 LT WING. REPLACED ANGLE AND FASTENERS TRAILING EDGE LOCATED ORSS 271 LT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 115A2930 SHEET 7, REV -.SDR SWAA2025111830409Panel · debondedDEBONDED EXTERNAL SKIN UPPER AREA OF WEDGE PANEL LOC ON INBD MAIN FLAP, LT WING. REPAIRED WEDGE PANEL LOC ON INB MAIN FLAP LT WING IAW B737-700 SRM 57-53-01-2R-7 REPAIR 7.SDR CALA2025111811321Skin · dentedLEFT FWD EXT FUSELAGE, APPROX FR 8,S23L DENTED. EVALUATED DENT BETWEEN FR 9 - 10 LT, DENT IS 3IN AFT OF FR 9 AND 1.37 5IN ABOVE S23L IAW SRM 53-11-11-283-012. DENT IS TYPE 1 AS D=0.025IN, A=1.375IN, D/A = 0.025IN/1.375IN= 0.018IN AND IS LESS THEN 0.100IN. PSDR ASAA2025103162313Intercostal · corrodedAFT CARGO RT INTERCOSTAL STA 747 TO 767 CORRODED. GROUNDED - YES. REMOVED DAMAGE ON AFT CARGO RT INTERCOSTAL AT STA 747 TO 767 REMOVED AND REPLACED INTERCOSTAL IAW SRM 51-40-02-0G-0 AND 51-40-05-0G-0.W= 2 IN O= .032 R= .00 L= 1 IN D= .03.SDR IPXA2025111360264Beam · dentedAFT CARGO DOOR, EDGE BEAM, NEAR BS1400 HAS A DENT. INSTALLED 1 EA NEW AFT CARGO DOOR EDGE BEAM IAW SRM 51-40-02. REPAIR ACCOMPLISHED IAW SRM 51-40-02, SRM 51-40-05, AMM 51-21-15/701 AND IAW AMM TASK 51-41-00-352-013 SUBTASK 51-41-00-952-018.SDR IPXA2025111360256Beam · dentedAFT CARGO DOOR, EDGE BEAM, LOWER AFT CORNER AREA HAS 2EA DENTS. INSTALL 1 EA CORNER ANGLE IAW SRM 51-40-02. REPAIR ACCOMPLISHED IAW SRM 51-40-02, SRM 51-40-05, AMM 51-21-15/701 AND IAW AMM TASK 51-41-00-352-013, SUBTASK 51-41-00-952-018.SDR J7SA2025111000458Fce · faultedCREW RECEIVED SPOILER FAULT ON GEAR RETRACTION. AIRCRAFT LANDED WITHOUT INCIDENT AT PLANNED DESTINATION. REPLACED #2 FCE IAW AMM 27-03-01. RIG AND OPERATIONAL CHECKS GOOD.SDR ASMF202511080300Engine · warning lightENGINE CONTROL LIGHT IS ON DURING ENGINE START ENG#2 732 301 52 // AMM TASK 73-20-00-810-861 PERFORMED, NO DEFECTS NOTEDSDR SWAA2025110730528Light · inoperativeEMERGENCY EXIT LIGHT OUTSIDE L1 DOOR DOES NOT ILLUMINATE. REPLACED AND PERFORMED GOOD INSTALLATION TEST OF THE OUTSIDE L1 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-04-960-801.SDR DALA2025110708137Light · inoperativeRT OVERWING EMERGENCY EXIT LIGHT NOT OPERATIONAL. REMOVED AND REPLACED RIGHT OVERWING EMERGENCY EXIT LIGHT PER B717 AMM 33-51. (8143300)SDR DALA2025110708135Slide · unpackedIN REF. TO AMDS 5211-4001: EMERGENCY SLIDE PACK WAS FOUND UNFOLDED, DOOR L1 WAS REPLACED UNDER AMDS 97-2561-9-0003 AND AMDS 2561- 9004 (1281137)SDR HYIA20251107004Pump · leakingPILOT REPORTED A FUEL SMELL IN THE CABIN. MAINTENANCE INSPECTED AND FOUND THE HEATER FUEL PUMP LEAKING. THE FUEL PUMP WAS REPLACED WITH NO FURTHER DEFECTS NOTED.SDR SWAA2025110630690Slide · unpackedFWD SERVICE DOOR SLIDE NEEDS TO BE REPACKED. REPACKED FSD SLIDER PER MT 725-61-06 FS ON CARD TTG8Q01758XW.SDR SWAA2025110630515Doubler · corrodedFOUND CORROSION ON BS 887 BUTT SPLICE INTERNAL STRAP DOUBLER UNDER FUSELAGE SKIN AFTER ACCOMPLISHING EA 25-153-02998. CORROSION MEASURES 2.50 BY 1.0 . REPAIRED IAW EA 25-153-02998-WIP3 & REF TTG8Q016Q10M.SDR DALA2025110608104Spar · crackedFOUND NO.2 PYLON FWD UPPER SPAR WEB CRACK AT NSTA 221.25 TO NSTA 237.5 FUEL LINE CUTOUT. THE NO.2 PYLON FWD UPPER SPAR WEB CRACK AREA REPAIRED AS PER PRI 629978-14 (1281183)SDR DALA2025110608103Web · crackedSHIP 1813 FOUND RH WING NR 10 SLAT INTERNAL WEB CRACK AT I/B CONTROL ROD FITTING AREA. CORRECTIVE ACTION: THE CRACK WEB ON RH WING NO.10 SLAT AT OSS 719 REPAIRED AS PER PRI 630036-14 (1281189)SDR DALA2025110608095Snubber · out of toleranceSHIP 6820 PIN EXTENCION OUT OF LIMITS ON SNUBBER OF L4 DOOR. CORRECTIVE ACTION: SUMMARY OF NRC 00078 :ROTARY SNUBBER WAS REPLACED BY SERVICIABLE SNUBBER PER B757-200 AMM 52-11-10 ALSO 4L DOOR WAS REMOVED / INSTALLED PER B757-200 AMM 52-11-01. (1282324)SDR AALA202511068756Window · glazedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 843 WINDOW GLAZED. REPLACED WINDOW PER AMM 56-31-25.SDR AALA202511061159Window · glazedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 834 WINDOW GLAZED. REPLACED WINDOW PER AMM 56-31-25.SDR AALA202511068468Window · glazedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 844 WINDOW GLAZED. REPLACED WINDOW PER AMM 56-31-25.SDR AALA202511066482Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #3 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR EVCA202511060001Fuel Cell · contaminatedFUEL SMELL IN CABIN, FOUND RESIDUAL FUEL ON FUEL CELL FROM PREVIOUSLY PERFORMED MAINTENANCE.SDR SWAA2025110530572Power Supply · inoperativeEMERGENCY LIGHT POWER SUPPLY M1695, BS 565, RT INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-06-960-806. TESTED OK.SDR AALA202511056333Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT BY R3 DOOR INOP. MAINTENANCE REPLACED LAMP AT DOOR R3 IAW AMM 33-51-04.SDR AALA202511059565Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: AT R3 DOOR THE OVERHEAD EMERGENCY LIGHT DOES NOT ILLUMINATE DURING OPS CHECK. MAINTENANCE RECHARGED BATTERY OPS CHECK GOOD IAW AMM 33-51-04.SDR AALA202511059748Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: AT L3 DOOR THE OVERHEAD EMERGENCY LIGHT DOES NOT ILLUMINATE DURING OPS CHECK. MAINTENANCE RECHARGED BATTERY OPS CHECK GOOD IAW AMM 33-51-04.SDR AALA202511051986Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CONNECTING PLATE FITTING UPPER HOLE ON RIGHT MAIN LANDING GEAR DOOR HINGE FITTING ON THE KEEL BEAM BETWEEN FR 42 AND FR 43, BETWEEN S41R AND S42R. REPLACED CONNECTING PLATE PER EA 3686507.SDR SWAA2025110430243Seal · crackedRIGHT HORIZONTAL STABILIZER UPPER FORWARD SLIDING SEAL IS CRACKED 2 VERTICALLY ALONG LEADING EDGE. R & R RT HORIZONTAL STABILIZER UPPER FORWARD SLIDING SEAL IAW AMM 53-31-31.SDR DALA2025110408060Bottle · low pressureR2 DOOR ASSIST BOTTLE PSI LOW. REMOVED AND REPLACED THE 2R DOOR DIAPHRAM IN THE PERCUSSION MECHANISM OF THE DOOR DAMPER. (1281639)SDR AALA202511041009Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511043586Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR 3R SHOWS CHECK DOOR PRESSURE ON CIDS PANEL. MAINTENANCE SERVICED THE 3R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00 WHICH CLEARED THE MESSAGE.SDR AALA202511043019Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511045625Wire Harness · defectiveAIRCRAFT WAS NOT GROUNDED: WHITE SEAT MOUNTED EMERGENCY AISLE LIGHT AT ROW 20 ABC IS INOPERATIVE. MAINTENANCE REPLACED WIRING HARNESS FOR SEAT ROW 19ABC / 20 ABC PER AMM 33-51-19 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202511047281Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202511047459Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT GALLEY PANEL IS FLASHING A YELLOW CAUTION LIGHT AT UPPER LEFT CORNER AND ADVISING TO CHECK DOOR PRESSURE. MAINTENANCE SERVICED THE R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00 WHICH CLEARESDR AALA202511043208Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DALA2025110408053Light · inoperativeAIRCRAFT 3014, ROW 28 CEILING EMER LIGHT INOP. CORRECTIVE ACTION: DEFERRED PER 33-50-02D, WILL REPLACE LIGHT ASSEMBLY. (LP 7658667)SDR CALA2025110410855Stringer · crackedSUPPORT TASK: WHILE PERFORMING B737-900ER SRM 57-41-01-2R-7 REPAIR 7 FOR LOOSE FASTENERS AT LH WING FIXED LEADING EDGE, FOUND CRACKED STIFFNER PN# 116A4530-1. REMOVED AND REPLACED STIFFENER PN 116A4530-1 IAW BOEING DWG 116A4008 RV - AND REPLACED 2 RIVETS ON OSDR YENA2025110401082A/C Pack · odorFLT#187, BOS-LAX. "FUME EVENT IN RAIN ON TAKEOFF THROUGH 12000FT. RAN PROCEDURE DISSIPATED WITH PACK 2 OFF AND X BLEED SHUT; COMPLIED WITH INFO NOTICE 2017-T015, SECTION A ISOLATED FAULT TO BE TYPE 10. AMBIENT AIR ODOR PER TSM 05-50-00-810-085B. A/C IS OK FOR SDR YENA2025110401081Unknown · odorFLT#833, MCO-SJU. "MOMENTARY CABIN ODOR DETECTED IN ROW 15; COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION A. ISOLATED FAULT TO TYPE 10 AMBIENT AIR ODOR PER TSM 05-50-810-085-B/TSM 05-50-00-810-085-D. AIRCRAFT IS OK FOR SVC."SDR ASAA2025103161535Relay · failedEXIT SIGNS REMAIN ILLUMNINATED AT ALL TIMES, REGARDLESS OF NO SMOKING SWITCH POSTION. GROUNDED - YES. REMOVED & REPLACED RELAY (8WL) IAW A330 TSM 23-73-71-810-852-A. OPS TEST OF NO SMOKING SW GOOD. EXIT LTS OFF WHEN SWITCH IN OFF POSITION. OK TO CONTINUE.SDR ASAA2025103162029Lens · missingF/A REPORTS L2 DOOR EXIT SIGN COVER MISSING. GROUNDED - YES. INSTALLED NEW L2 DOOR EXIT SIGN COVER. REF 33-51-01.SDR SWAA2025110330559Fan · odorODOR IN CABIN WITH CONDITIONED AIR HOOKED UP. TROUBLESHOT AND FOUND RECIRC FAN INOPERATIVE. OK TO CONTINUE PER MEL MEL 21-31-02. REMOVED & REPLACED THE RECIRC FAN IAW AMM 21-25-02 OPS TEST GOOD.SDR SWAA2025110330712Slide · out of adjustR1 SLIDE STICKING OUT. ADJUSTED THE R1 SLIDE IAW AMM 25-66-00.