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 AALA202601057945Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INOP UNIT EPSU POSITION RH SIDE EMERGENCY EXIT AREA AT PASSENGER CABIN. MAINTENANCE REPLACED EMERGENCY POWER SUPPY UNIT (EPSU) POSITION RH EMERGENCYEXIT AREA AT PASSENGER CABIN IAW A320 FAM AMM 33-51-38-000-001-A AND A320 FAM AMMSDR DXTA2026010506406Wing · ground damageJUST AS WE GOT TO THE AIRPORT AND BEFORE WE GOT TO THE PLANE A EXECUJET VAN STRUCK THE LEFT WING OF N341QS AT 8:56. THE DAMAGE TO THE WING SEEMS MINIMAL BUT THE VAN HAS A BIG DENT. CORRECTIVE ACTION: GAINED ACCESS TO THE AIRCRAFT AND INSPECTED THE DAMAGED AREASDR CALA2026010512663Lug · wornLEFT ELEVATOR, INBD ACTUATOR LOCKING LUG WORN. EVALUATED DAMAGE ON LOCKING LUG LT ELEVATOR INB ACTUATOR FOUND TO BE OUT OF LIMITS IAW SRM 55-26-47-300-001. FABRICATED A REPAIR ANGLE IAW SRM 51-27-11-911-001. INSTALLED IAW SRM 55-26-47-300-001.SDR CALA2026010512662Lug · wornLEFT ELEVATOR OTBD ACTUATOR LOCKING LUG WORN. EVALUATED DAMAGE ON LOCKING LUG LT ELEVATOR OTBD ACTUATOR FOUN D TO BE OUT OF LIMITS IAW SRM 55-26-47-300-001. FABRICATED REPAIR ANGLE IAW SRM 51-27-11-911-001, INSTALLED IAW SRM 55-26-47-300-001.SDR CALA2026010512661Unknown · odorSTRONG FUEL ODOR AFT CABIN. PERFORMED FIM TASK 21-00 TASK 830, SMOKE OR FUMES IN CABIN. NO FUMES OR SMOKE FOUND IN CABIN, OK FOR SERVICE. PERFORMED FIM TASK 21-00 TASK 830 SMOKE OR FUMES IN CABIN. NO FUMES OR SMOKE FOUND IN CABIN, OK FOR SERVICE.SDR CALA2026010512660Smoke Detector · false activationLAVATORY D3, SMOKE ALARM WITH NO SIGNS OF SMOKE. ALARM TURNED OFF ON IT`S OWN. NO SMOKE OR ODOR WAS TRACED BY F/A. LOOKED FOR ANYTHING SUSPICIOUS INCLUDING UNDER SINK AND WAS UNABLE TO LOCATE ANYTHING SUSPICIOUS. NO HISTORY FOUND. REF TSM 26-14 TASK 801, SDR CALA2026010512659Oven · smokeOVEN 706 BURN SMELL WITH SMOKE & POPPING NOISE. ERROR CODE 2000, REPLACED OVEN 706 IAW AMM 25-32-00. OPS CHECKED OK. LEAK CHECKED OK.SDR CALA2026010512657Skin · dentedDAMAGE FROM BAGGAGE CART AT FWD CARGO DOOR. BS 440+7 - 440+13.7, S20R-2 - S20R+2.4. DENT IS WITHIN LIMITS IAW SRM 52-30-01-1A-1 SEC 4, PARA B, SUBSECTION (4) FIG 103, ALLOWABLE DAMAGE 1, DETAIL F. DENT IS 7.00 INCHES LONG, 4.250 WIDE, .320 DEEP. NO CRACKS SDR CALA2026010512656Skin · damagedDAMAGE FROM BAGGAGE CART AT RT SIDE OF FUSELAGE. BS 344-2 - 360+3, S20R-1 - S20R+10.5. MEASUREMENTS: HEIGHT: 7.3" WIDTH: 20.75" DEPTH: 0.24". INSPECTED AREA, THE DAMAGE BS 344 -360, S20R - S21R. STR 20R APPEARS TO BE BENT, CAUSING THE ATTACHING CLIPS ON BOTHSDR CALA2026010512655Stringer · bentWHILE INSPECTING EXTERNAL FUSELAGE SKIN DAMAGE FROM STA 344 TO STA 360, FOUND STRINGER 20R BENT FROM STA 344 TO STA 360. REPAIRED STRINGER 20R FROM STA 344 TO STA 360 AS PER SRM 53-00-03-2R-1 TYPE 1 STRINGER, WITH THE DEVIATIONS PROVED IN EC/RA 5310-08761 ANDSDR CALA2026010512654Elec Connector · not seatedEMERGENCY LIGHTS - OPERATIONAL CHECK EMERGENCY LIGHTS OPERATIONAL CHECK - 12A, 2A EPL LIGHT INOP CORRECTION SEAT 12C AND 2C REPLACED 2B EMERGENCY LIGHT REF AMM 33-51-11. CHECK GOOD. SEAT 12C RELAMPED EMERGENCY LIGHT, NO HELP. POSSIBLE WIRE HARNESS INOP REQUSTSDR CALA2026010512653Light · inoperativeAFT OVERHEAD EXIT SIGN IN GALLY AS IT LOWER RIGHT HAND LIGHT INOPERATIVE. REPLACED THE LAMP, NO HELP, CHECKED FUSES IN BATTERY TRAY ALL IN GOOD CONDITION, ALL WIRING FROM HOUSING IN GOOD CONDITION. REQUEST LIGHT ASSY. R & R THE LAMP ASSY IAW AMM 33-51-01, OPSDR CALA2026010512652Structure · contaminatedDUE TO THE AMOUNT OF STANDING WATER AND ICE, INSPECTION OF THE FORWARD BILGE ARE IS NEEDED PER TRM ECRA 2011-01000. PARTICULARY BETWEEN BS 600 & 900. WITH WATER LEAK ORIGINATING BEHIND RT CARGO WALL LINER AT BS 800. SUPPLIED HOT CONDITIONED AIR WITH APU TO THESDR CALA2026010512651Lamp · inoperativeEMERGENCY LIGHTS - OPS TEST WITH THE TEST SWITCH PROCEDURE, FLIGHT COMPARTMENT EMERGENCY DOME LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-09-033-001. CHKD OK.SDR AALA202601050291Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT AT BS 328, RBL 41. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601056048Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBEAM AT BS 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202601050865Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBEAM AT BS 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR IXXA20260104003Skin · chafedREPAIR IS WORN AND GOUGED ON TOP OF THE NR 2 PYLON L/E JUST AFT OF THE INLET COWL AT THE 11 O'CLOCK POS. AFT LOOKING FWD.SDR ABXA20260102001Transfer Sys · faultedDURING TAXI OUT FUEL IN LEFT TANK TRANSFERRED TO CENTER TANK WITHOUT TRANSFER ON. APPROX. 14.5 THOUSAND POUNDS TRANSFERED ON ITS OWN FROM LT TANK TO CNT TANK.A/C RETURNED TO THE GATE (BTB) AND MTX GROUNDED A/C AND TRANSFERRED FUEL FROM CTR TANK TO LT TANK IAW SDR AALA202601044958Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601042359Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE FORWARD LAVATORY SMOKE DETECTION CHIME ALERTED SMOKE WHILE PASSENGER WAS ALLEGEDLY VAPING. THE MID AND AFT RIGHT SMOKE DETECTION CHIME WENT OFF SIMULTANEOUSLY WITH FORWARD LAVATORY BUT NO PASSENGERS WERESDR AALA202601045682Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601042417Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DALA2026010300038Engine · failedDIVERTED TO BWI DUE TO LT ENGINE IFSD. CREW NOTICED HIGH N2 VIBES, DUAL LOOP FAILURE, AND LOW OIL INDICATION. SHUTDOWN ENGINE AND DECLARED EMERGENCY. FOUND METAL IN THE TAIL. REPLACED NR 1 ENGINE. (LP 8103349, 8103348)SDR DALA2026010200035Bottle · low pressure4L CHECK DOOR PRESSURE MESSAGE. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8571222)SDR DALA2026010200033Floor Support · corrodedFLOOR SUPPORT AT -Y 1137.1 FRAME 74 HAS CORROSION ON THE FWD INBD CORNER. REPAIRED PER ERA 631272-14 REV. ORIGINAL. (1381335)SDR DALA2026010200032Seat Track · corrodedSEAT TRACK AT -YB1 BETWEEN FRAME 73 AND 74 IS CORRODED. REPAIRED PER ERA 631283-14 REV. ORIGINAL. (1381334)SDR DALA2026010200031Structure · corrodedCORROSION FOUND UNDER 4L DOOR THRESHOLD PANEL. REPAIRED PER ERA 631276-14 REV. ORIGINAL. (1381332)SDR IPXA2026010224433Handle · out of positionCREW ENTRY DOOR- HANDLE IS MAKING CONTACT WITH PAN AND WORN AT ATTACHMENT TO SLIDING SHAFT ASSY,REF CMM 52-11-08 AND AMM 52-12-01-646-001 DOOR INSPECTION.SDR DALA2026010200009Battery Pack · inoperativeWHILE PERFORMING AMDS WORKCARD 3350-7413, FOUND EMERGENCY LIGHTS AT ROW 18 INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1695 PER B737 AMM 33-51. OPS CHECK GOOD.SDR CALA2026010212586Seal · leakingNUMBER 1 ENG OIL QTY SLOWLY REDUCED TO 0 OVR 90 MINS ALL OTHER ENG IND. NORM AT THIS TIME. CAPT REPORTED THE OIL PRESSURE WAS 92 PSI UPON ENG SHUTDOWN AFTER LANDING CREW REPORTED ENG NR 1 OIL PRESSURE DROPPED DOWN TO 90 PSI. ACP'D ENG NR 1 INSPECT FOUND OIL COSDR QXEA2026010200002Fitting · out of adjustFLIGHT 2217. L2 DOOR ARMING LEVER GETS CAUGHT WHEN TRYING TO DISARM IT. REMOVED FROM SERVICE.TROUBLESHOOTED DOOR PER AMM 52-12-40-700-802-A. FOUND GIRT BAR GETS STUCK IN THE LEFT FLOOR FOOTING. FLOOR FITTING REQUIRES ADJUSTMENT. ADJUSTED LEFT FLOOR FITTING AS SDR FDEA202601020002Light · failedFOUND ON WALK AROUND GALLEY AREA CEILING EMERGENCY LIGHT INOP. ATTEMPTED RELAMPING OF GALLEY AREA CEILING LIGHT. FOUND BULB SIEZED IN LIGHT ASSEMBLY. REMOVED AND REPLACED GALLEY AREA CEILING EMERGENCY LIGHT ASSEMBLY REF ABOVE 777 AMM. OPS CHECK GOOD. SDR AALA202601025835Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR AALA202601026521Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR YENA2026010200002Unknown · odorFLT # 938 SJD-JFK. MAGIC MARKER SMELL IN FLIGHT DECK AND FWD GALLEY , APU BLLED BOTH PACKS ON. ( APU SYSTEM ), AIRCRAFT N2039J OPERATING FLIGHT 938 SJD - JFK REPORTED A CABIN ODOR EVENT. THE FLIGHT CREW REPORTED PACK 1 FUME EVENT ON TAKEOFF, LEVEL 2 DIRTY SOSDR YENA2026010200001Unknown · odorFLT# 745 JFK- PSE. DURING BASE TO FINAL A STRONG SMELL WAS NOTED BY INFLIGHT IN THE CABIN. SMELL DID NO LAST LONG AFTER LANDING.. C/W INFORMATION NOTICE 2017-T015, STEP 1 , ISOLATRED FAULT TO TYPE 10, (AMBIENT AIR) PER TSM 05-50-00-810-085-BTDM 50-50-00-810SDR AALA202601026113Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: EMERGENCY ACCUMULATOR NITROGEN PRESSURE BELOW LIMITS. MAINTENANCE SERVICED EMERGENCY ACCUMULATOR NITROGEN PRESSURE IAW AMM 32-44-11.SDR 2026FA0000000Engine · fodDURING THE TRENT, 700, HP AND IP COMPRESSOR INCOMING BORESCOPE, SANAD DISCOVERED FOD WAS DETECTED INSIDE THE ROTOR PATH; THE FOD IS SUSPECTED TO BE A BORESCOPE TIP. THE FOD WAS FOUND ON THE LINER SURFACE OF THE INTERMEDIATE PRESSURE COMPRESSOR (IPC) STAGE 6 ATSDR WX0A2026030232746Bushing · out of limits(AIRCRAFT GROUNDED) STRONG AIRFRAME VIBRATION FROM 330 KTS - 260 KTS AT FL250. VIBRATION WAS FROM TAIL OF AIRCRAFT ON UP AND DOWN MOTION. / FOUND L/H ELEVATOR HINGE FITTING BUSHINGS 1-5 OUT OF LIMITS PER AMM 27-34-41-200-001-A, BUSHINGS OR ELEVATOR REQUIRES RESDR SWAA2026020357494Floor Panel · pulledFLOOR PANEL 241FF HAD AREAS OF PULLED STRANDS. DUE TO EXTENT OF THE DAMAGE, FABRICATED A NEW 241FF FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2026020357482Floor Panel · pulledFLOOR PANEL 232RF HAD AREAS OF PULLED STRANDS. A REPLACEMENT FLOOR PANEL 232RF FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2026020357483Floor Panel · delaminatedFLOOR PANEL 241AF HAS DELAMINATED PREVIOUS REPAIR. A REPLACEMENT FLOOR PANEL 241AF HAS BEEN FABRICATED IAW SRM 53-00-50-2R-0.SDR SWAA2026020357484Floor Panel · pulledFLOOR PANEL 241DF HAD AREAS OF PULLED STRANDS. FABRICATION OF A NEW 241DF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026020357485Floor Panel · pulledFLOOR PANEL 241EF HAS AREAS OF PULLED STRANDS. DUE TO EXTENT OF THE DAMAGE, FABRICATED A NEW 241EF FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2026020357486Floor Panel · pulledFLOOR PANEL 242CF HAS AREAS OF PULLED STRANDS. FABRICATION OF A NEW 242CF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026020357487Floor Panel · pulledFLOOR PANEL 242DF HAS AREAS OF PULLED STRANDS. FABRICATION OF NEW 242DF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026020357480Access Panel · delaminatedACCESS PANEL 194AL LOWER CORNER IS DELAMINATED. REPAIRED IAW SRM 51-70-05-2R-6-A00737, REPAIR 6.SDR IPXA2026020211187Skin · gougedON ARRIVAL DAMAGE TO SKIN FOUND JUST AFT OF AFT CARGO DOOR. REMOVED STRINGER CLIPS IN COMMON TO REPAIR REF SRM 51-40-02. COMPLETED REPAIR IAW EO-96145.SDR VNAA20260125021Skin · dentedSEVERAL DENTS BTW 4 O'CLOCK TO 7 O'CLOCK EXTERNAL SKIN OF THE LOWER FAN COWL DOOR AT LT ENGINE. SEVERAL DENTS BTW 4 O'CLOCK TO 7 O'CLOCK EXTERNAL SKIN OF LOWER FAN COWL DOOR AT LT ENGINE WERE REPAIRED IAW REO 670-54-14-1012, REV B.