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 SWAA2025081198581Strip · missingSMALL PIECE OF REFLECTIVE STRIP MISSING ON FLOOR BY ROW 16ABC. REPLACED REFLECTIVE STRIP AT 16ABC PER AMM 33-51-15. OPS CHECK GOODSDR SWAA2025081198853Hmu · failedNR 1 ENGINE FAILED UPON EXITING THE RUNWAY. SHUTDOWN ENG IAW QRH. R&R HMU;FUEL PUMP PACKAGE REF 773-11-00; R&R MW03102 HARNESS PER AMM 71-51-03; R&R J10;J6 HARNESS PER AM 73-21-06 R&R EEC PER AMM 73-21-60; OPS CK GOOD. C/W RII STEPS FOR HMU; FUEL PUMP PACKSDR SWAA2025081100402Pump · failedNR 1 ENGINE FAILED UPON EXITING THE RUNWAY. SHUTDOWN ENG IAW QRH. R&R HMU;FUEL PUMP PACKAGE REF 773-11-00; R&R MW03102 HARNESS PER AMM 71-51-03; R&R J10;J6 HARNESS PER AM 73-21-06 R&R EEC PER AMM 73-21-60; OPS CK GOOD. C/W RII STEPS FOR HMU; FUEL PUMP PACKSDR SWAA2025081100403Wire Harness · failedNR 1 ENGINE FAILED UPON EXITING THE RUNWAY. SHUTDOWN ENG IAW QRH. R&R HMU;FUEL PUMP PACKAGE REF 773-11-00; R&R MW03102 HARNESS PER AMM 71-51-03; R&R J10;J6 HARNESS PER AM 73-21-06 R&R EEC PER AMM 73-21-60; OPS CK GOOD. C/W RII STEPS FOR HMU; FUEL PUMP PACKASDR SWAA2025081100404Eec · failedNR 1 ENGINE FAILED UPON EXITING THE RUNWAY. SHUTDOWN ENG IAW QRH<[01] C/W. R&R HMU;FUEL PUMP PACKAGE REF 773-11-00; R&R MW03102 HARNESS PER AMM 71-51-03; R&R J10;J6 HARNESS PER AM 73-21-06 R&R EEC PER AMM 73-21-60; OPS CK GOOD. C/W RII STEPS FOR HMU; FUEL PSDR VGCA20250808013Keelbeam · corrodedKEEL BEAM BREATHER WEB CORRODED AT SEVERAL LOCATIONS ON THE UPPER SURFACE FROM BS740 TO 795 AND LBL13 TO RBL13SDR VGCA20250805012Frame · dentedAFT LOWER FUSELAGE FRAME INNER CHORD DENTED AT BS1110 FROM S-24L TO S-28LSDR VGCA20250805011Frame · puncturedAFT LOWER FUSELAGE FRAME INNER CHORD PUNCTURE AT BS1090 FROM S-24L TO S-28LSDR VGCA20250805010Frame · puncturedFRAME INNER CHORD PUNCTURE AT BS 1090 BETWEEN S26R AND S28R.SDR VGCA20250805009Frame · puncturedAFT LOWER FUSELAGE FRAME INNER CHORD PUNCTURE AT BS1130 FROM S-25L TO S-29L.SDR VGCA20250805008Frame · crackedFT LOWER FUSELAGE FRAME CRACKED AT BS1070 FROM S-26R TO S-28RSDR AALA202508119737Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT A FUEL LEFT TANK PUMP 1 LOW PRESSURE ECAM DISPLAYED DURING CRUISE, FLIGHT CREW TURNED OFF PUMP SWITCH PER ECAM SUPPLEMENTAL GUIDANCE. (OPEN)SDR VGCA20250805007Frame · crackedFORWARD LOWER FUSELAGE FRAME UPPER CHORD CRACKED AT BS700 FROM S-28L TO S-28RSDR VGCA20250805006Skin Panel · corrodedAFT LOWER FUSELAGE SKIN CORROSION FROM BS990-1010 AT S-26LSDR JJBA20250811030Plate · corrodedDIGITAL PLATE BTW FR 15-16 FOUND CORRODED. DIGITAL PLATE BTW FR 15-18 CORRODED AREA THRU AND THRU AND OUT OF LIMIT. DIGITAL PLATE BTW FR 15-18 PERFORMED AREA REPAIRED. CORROSION LEVEL 1.SDR JJBA20250811026Nut · missingRUDDER II, MIDDLE OF LH SKIN, ANCHOR NUT MISSING FOR DEFLECTION TOOL INSTALLATION. AT RUDDER II, MIDDLE OF LH SKIN, ELONGATED SCREW HOLE REPAIR INSTALLED.SDR VGCA20250805005Shear Web · crackedAFT UPPER FUSELAGE FLOOR SHEAR WEB CRACK NEAR BS1166-1176.9 AND RBL8 TO RBL17.87SDR VGCA20250805004Spar · corrodedWING CENTER BOX FRONT SPAR CORRODED IN MULTIPLE PLACES ON VERTICAL AND HORIZONTAL CHORD FLANGES AT BS740 FROM LBL70.5 TO RBL70.5SDR VGCA20250805003Flap Track · crackedCRACK FOUND ON LEFT WING OUTBOARD TRAILING EDGE FLAP, OUTBOARD FLAP TRACK. CRACK WAS IN UPPER FLANGE INBOARD FLANGE.SDR VGCA20250805002Skin Panel · corrodedAFT LOWER FUSELAGE SKIN PANEL CORROSION FROM BS1148-1166 AND S-18L TO S-20L.SDR VGCA20250805001Keelbeam · corrodedCENTER FUSELAGE SECTION RH DELTA BEAM LOWER CHORD CORRODED FROM BS720F-755 AND S-27L TO S-27RSDR FDEA202508051405Profile · crackedMAIN DECK FLOOR STRUCTURE WAS FOUND PROFILE-Z CRACK AT FR80/82,-Y1448. REPLACED THE CRACK PROFILE-Z WITH NEW PART.LOCATE AT MAIN DECK FLOOR FR80/82 - Y1448.I.A.W A300-600F SRM 51-72-10-001 PAGE 2 AND 51-40-21-001 PARA 6 PAGE 7B~PAGE 23.REPAIR CLASSIFIED ASSDR DALA2025081105960Structure · debondedRIGHT WING O/B FLAP INTERNAL STRUCTURE HONEYCOMB DISBONDING AT OTEF STA 190+5 UNDER FLAP PANEL 666MT IB AREA. RT WING O/B FLAP INTERNAL STRUCTURE HONEYCOMB REPAIRED AT OTEF STA 190+5 UNDER FLAP PANEL 666MT IB AREA IAW SRM 57- 53-01-2R-1, SRM51-70-10-2R-4, ANDSDR DALA2025081105959Spar · crackedPERFORMED OHEC INSPECTION OF THE FORWARD UPPER SPAR HIDDEN PORTIONS OF CHORD-CF6-80C STRUT,FOUND 01EA CRACK ON THE INBOARD FASTENER HOLE OF THE WEB AT NSTA221.25. REPAIRED AS PER PRI 581786-14.SDR HEEA202508080001Warning Light · illuminatedDURING CRUISE FLIGHT, IGB CHIP LIGHT ILLUMINATED. LANDED BACK AT DESTINATION PLATFORM.SDR DXTA2025080804489Link · damagedSPADE DOOR GETTING CAUGHT (POSSIBLY ON HOOK) EVERYTIME OPENING THE DOOR. OCCASIONALLY THE DOOR STICKS & WE ARE UNABLE TO OPEN DOOR UNLESS USING MORE FORCE THAN USUAL, CAUSING SPADE DOOR TO BEND ONCE OPENING. ACTUATED DOOR ABOUT 10 TIMES & COULD NOT DUPLICATESDR DALA2025080805943Frame · no discrepancyERA 628217-14, MONITOR INSPECTION LOG REPAIR TO LH FUSELAGE FRAME STA 1560 @ S26L. REF ERA 628217-14. (1127114)SDR DALA2025080805942Snubber · out of toleranceR1 DOOR SNUBER FLUID INDICATOR BELOW MINIMUM. REMOVED AND REPLACED THE R-1 PASSENGER DOOR. SNUBBER ASSY PER B757-200 AMM 52-11.SDR DALA2025080805941Bottle · emptyDOOR 4L ASSIST BOTTLE ZERO PRESSURE. R & R 4L DOOR ASSIST BOTTLE PER B757 AMM 52-11. LEAK CHECK GOOD.SDR DALA2025080805940Frame · gougedALC FRAME AT STA. 1460 IS GOUGED AND DENTED ABOVE S-26L. REPAIRED IAW PRI ER/A 628083 REV 0 AND ER/A 628083-14 AD.SDR YENA2025080800817Engine · odorFLT#8385, BOS-JFK. REF LP # 4339985 ITEM # 1(DIRTY SOCK ODOR AFTER APPLICATION OF T.TO THURST AND DURING DECENT WITH IDLE POWER) DIRTY SOCK SMELL. RAN ENG 1 AND 2. WHILE ENGINES RUNNING ISOLATED L AND R PACKS TO DISCOVER OIL SMELL APPARENT WHILE ON ALONE. SMELSDR AALA202508087164Appu · odorAIRCRAFT WAS GROUNDED: ACRID SMELL IN CABIN DURING CLIMB AND AFTER LANDING WHEN APU BLEED IS TURNED ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** OPEN)SDR AALA202508082657Hinge Pin · seizedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SPOILER #5 OUTBOARD CENTER HINGE PIN SIEZED TO THE SLIDING BUSH. MAINTENANCE REPLACED HINGE PIN PER AMM 27-64-45.SDR CALA2025080807516Fuel Cap · missingDURING WALK AROUMD NOTICE CAP,COUPLING REFUELING UNDERWING MISSING .SDR CALA2025080807492Attach Bracket · corrodedAPU AIR INLET DOOR ASSY FWD ATTACH BRACKET CORRODED. REPAIRED IAW SRM 53-80-15-2R-1, REPAIR 1.SDR CALA2025080807491Support · corrodedRH WING NR 6 TRANSMISSION SUPPORT CORRODED. REPAIRED IAW ECRA 5753-02342, AND EA 757-5753-13-A4035 REV-.SDR UIEA2025080501090Manifold · damagedFLIGHT CREW REPORTED MOMENTARY FIRE WARNING MESSAGE ON EICAS. FOUND DAMAGE TO THE 8TH STAGE MANIFOLD. REPLACED 8TH STAGE MANIFOLD IAW AMM 36-11-01/401 PER 114 & IPC 36-11-05-01B REV 89. PERFORMED NR 2 ENG PNEUMATIC LEAK TEST IAW AMM 71-00-00-705-002-N00. LESDR ASAA2025080559920Cover · missingRIGHT OVERWING FORWARD EXIT LIGHT COVER MISSING. GROUNDED - YES. INSTALLED EMERGENCY LIGHT LENS COVER, RH FWD OVERWING EMERGENCY EXIT DOOR PER AMM 33-51-01. OP TEST NORMAL. SEAMC MARK NOTIFIED.SDR AALA202508079672Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #4 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 4 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508077999Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #5 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #5 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508076169Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #2 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 2 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508077253Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #1 ON LH HORIZONTAL STABILIZER. MSINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 1 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508076933Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #3 ON LH HORIZONTAL STABILIZER. MSINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 3 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508072492Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202508071479Release System · out of rigAIRCRAFT WAS NOT GROUNDED: OVERWING EXIT RIGHT SIDE OF AIRCRAFT IS NOT ARMED. MAINTENANCE ADJ SLIDE RELEASE MEC. PER AMM 52-21-00.SDR GTIA2025080739038A/C Pack · odorDESCENDING THROUGH FL300 WE GOT AN OILY ODOR. ISOLATED TO PACK 1. DESCRIPTION OF ODOR/FUMES: PERSISTENT, OIL/OIL BURNING SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-ITEM CREATED TO ALSDR GTIA2025080739037Compressor · leakingBURNING OIL & HUMID SMELL DURING CLIMB OUT. SMELL WENT AWAY WITH PACK 1 OFF. DESCRIPTION OF ODOR/FUMES: PERSISTENT, OIL/OIL BURNING SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PERFORMSDR GTIA2025080739036Coffeemaker · odorON CLIMBOUT AROUND 20000 FT FA REPORTED MUSTY OLD COUCH SMELL ISOLATED PACK 2 AND SMELL DISSIPATED -PERFORMED TSM 05-50-00-810-831-A PERFORMED LEVEL A DECONTAMINATION OF THE (ECS) COULD NOT DULPICATE SMELL.RAN AEROLYZER, NO SMELL DETECTIED ONLY ODOR DETECTED SDR DALA2025080705916Dampener · no testDID NOT PASS OPS TEST, EMERGENCY DOOR DAMPER ON PASSENGER CREW DOOR 831. REPLACED EMERGENCY DOOR DAMPER ON PASSENGER CREW DOOR 831 IAW FAM AMM 52-11-14-000-001-B AND A320 FAM AMM52-11-14-400- 001-B.SDR DALA2025080705938Sign · detachedEXIT ROW DOOR EXIT SIGN FELL OFF COMPLETELY / INTERIOR. RE-INSTALLED EXIT SIGN AT DOOR R2.