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 AALA202510020305Screw · deterioratedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED, DOOR STOP SCREW AT POSITION 2 AFT MERGENCY EXIT DOOR 833 IN PASSENGER CABIN. MSINTENANCE REPLACED DOOR STOP SCREW AT POSITION 2 AFT EMERGENCY EXIT DOOR 833 IN PASSENGER CABIN I.A.W AMM 52-22-31-000-001-A AND AMM 52SDR AALA202509304854Pump · unknownAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD FUEL PUMP DOES NOT ILLUMINATE LOW PRESSURE WHEN TURNED OFF. CONFIRMED FAULT ON FORWARD LEFT HAND FUEL PUMP C/B PULLED AND COLLARD. TROUBLESHOT PER FIM 28-22-00-810-806 RAN OPERATIONAL CHECK OF LEFT FORWARD BOOST PUMP ANSDR DALA2025093007122Slat Track · damagedRIGHT WING SLAT TRACK #10 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216490)SDR DALA2025093007121Slat Track · damagedRIGHT WING SLAT TRACK #8 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216489)SDR DALA2025093007120Slat Track · damagedRIGHT WING SLAT TRACK #7 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216487)SDR DALA2025093007119Slat Track · damagedRIGHT WING SLAT TRACK #6 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216486)SDR DALA2025093007118Slat Track · damagedRIGHT WING SLAT TRACK NR 5 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216484)SDR DALA2025093007117Slat Track · damagedRIGHT WING SLAT TRACK #3 REQUIRES NDT TO BLENDED AREA. PERFORMED NDT INSPECTION PER ANDTP BD500-AJ51-10-02-00AAA-352A-A OR ANDTP BD500-AJ51-01-20-01AAA-353A-A TO BLENDED AREAS AND CHECK FOR SIGNS OF CRACKS. (1216480)SDR DALA2025093007111Panel · delaminatedLEFT OVERWING EMERGENCY EXIT DOOR SLIDE PANEL TE NUT PLATE MOUNTING SURFACE (DELAMINATED). REMOVED AND REPLACED OWEED SLIDE PER AMDS 2563-4002. (1217547)SDR DALA2025093007107Scuff Plate · corrodedSCUFF PLATE FASTENER HOLE ON FWD SERVICE DOOR, 14OL, 12OL, 11OL, 10OL, 9OL, 7OL, 6OL, 5OL, AND 4OL, HAVE EVIDENCE OF CORROSION. REMOVED CORROSION ON FWD SERVICE DOOR SCUFF PLATE AREA, FOUND OUT OF LIMITS IAW A220 ASRP J51-21-06, J53-21-05. RESTORE FINISH ANDSDR IPXA2025093038715Scavenge Pump · malfunctioned30 MIN OF FLIGHT, 0.5 OF FUEL FROM RIGHT TANK TRANSFERRING TO CENTER TANK. NO CROSSFEED WAS USED. LT TANK SCAVENGE PUMP BEGAN PULLING CTR TANK FUEL AT 60% WHICH CAUSED 1500 LB IMBALANCE AT 1HR MARK. RT DEFUEL VALVE BODY OPS CHECK GOOD IAW AMM 28-26-01-790-80SDR DALA2025093007089Floorbeam · corroded(LOG 1218233) CORROSION ON FLOOR STRUCTURE (PREVIOUS REPAIR) OF STA 986.5 BTW RBL45 TO LBL45 (UPPER AND LOWER SURFACE) AT W2. FLOOR STRUCTURE (T-CHORD) OF STA 986.5 BTW RBL45 TO LBL45 (UPPER AND LOWER SURFACE) AT W2 WAS REPAIRED PER ER/A 585014-14 REV ORIGINALSDR YENA2025093000981Hinge Fitting · corrodedDURING HEAVY MAINTENANCE: AFTER REMOVED BEARING CORROSION WAS FOUND ON HINGE ARM FITTING Ñ3 VERTICAL STABILIZER; REMOVED AND REPLACED #3 VERTICAL STABILISER FITTING ALL WORK DONE BY O. FLORES 8621011 AND QC RII. C. PORTILLO # 230. ALL WORK EMBODIED ON AEROMAN SDR YENA2025093000980Bearing · corrodedDURING HEAVY MAINTENANCE: AFTER REMOVED BEARING CORROSION WAS FOUND ON HINGE ARM FITTING Ñ4 VERTICAL STABILIZER; REMOVED AND REPLACED HINGE ARM FITTING 4 AND FASTENERS ON VERTICAL STABILIZER I.A.W A320 SRM 55-36-42-300-008 STEP 2.A AND A320 SRM 51-72-11 AND DWSDR YENA2025093000979Hinge Arm · corrodedDURING HEAVY MAINTENANCE: AFTER REMOVED BEARING CORROSION WAS FOUND ON HINGE ARM FITTING Ñ1 VERTICAL STABILIZER; (RESOLVED ON W/O: 1401080 TASKCARD: NR-00014) REMOVED AND REPLACED HINGE ARM FITTING 1 AND FASTENERS ON VERTICAL STABILIZER I.A.W A320 SRM 55-36-42SDR ASAA2025092561122Lens · detachedEXIT SIGN DETATCHED AT 17A. GROUNDED - YES. REMOVED AND REPLACED EXIT SIGN LENS PER AMM 33-51-01-960-802.SDR GTIA2025092939101Bushing · corrodedAFTER BUSHINGS REMOVAL CORROSION WAS FOUND ON INNER BORE HINGE FITTING Ñ3 AT RH ELEVATOR (2EA) RAF 3589623-01 CREATED-REPAIRED BOTH BORES AND REPLACED BUSHINGS (2 EA) ON HINGE FITTING #3 AT RH ELEVATOR IAW SRM 55-26-41-300-004 THIS REPAIR IS CATEGORY B INSPECTSDR GTIA2025092939100Bushing · corrodedAFTER BUSHINGS REMOVAL CORROSION WAS FOUND ON INNER BORE HINGE FITTING Ñ4 OB LUG AT RH ELEVATOR (1 EA) RAF 3589622-02 CREATED -REPAIRED BOTH BORES AND REPLACED BUSHING (1 E/A) ON HINGE FITTING #4 OUTBOARD LUG AT RH ELEVATOR IAW SRM 55-26-41-300-005 THIS REPAIRSDR GTIA2025092939099Bushing · corrodedAFTER BUSHINGS REMOVAL CORROSION WAS FOUND ON INNER BORE HINGE FITTING Ñ6 AT RH ELEVATOR (2EA). RAF 3589622-01 CREATED-REPAIRED BOTH BORES AND REPLACED BUSHINGS (2 E/A) ON HINGE FITTING #6 AT RH ELEVATOR IAW SRM 55-26-41-300-006 THIS REPAIR IS CATEGORY B INSPESDR GTIA2025092939098Bushing · corrodedAFTER BUSHING REMOVAL CORROSION WAS FOUND ON INNER BORE HINGE FITTING #1, 2, AND 3 AT LH ELEVATOR RAF 3589621-02 CREATED SEE APPENDIX 3589621-02-REPAIRED BOTH BORES AND REPLACED BUSHINGS (2 EA) ON HINGE FITTING #1,2 AND 3 AT LH ELEVATOR IAW SRM 55-26-41-300-00SDR GTIA2025092939097Skin Panel · crackedCRACK INDICATION FOUND IN FASTENER HOLE (LOWER INBOARD POSITION) LOCATED AT FR 68 DOOR STOP FITTING 1 RH SIDE. RAF 3589624-01 GENERATED -PERFORMED REPAIR ON FASTENER HOLE (LOWER INBOARD POSITION) LOCATED AT FR.68 DOOR STOP FITTING #1 RH SIDE SRM 53-41-12-300-0SDR GTIA2025092939096Skin Panel · crackedCRACK INDICATION FOUND IN FASTENER HOLE ( LOWER INBOARD POSTION) LOCATED AT FR 68 DOOR STOP FITTING 6 LT SIDE. RAF 3589623-02 GENERATED -PERFORMED REPAIR ON FASTENER HOLE (LOWER INBOARD POSITION) LOCATED AT FR.68 DOOR STOP FITTING #6 LH SIDE IAW SRM 53-41-12-3SDR AALA202509297558Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND AROUND FASTENER HOLE ON FWD FACE AT FRAME 35, LOCATED 1 INCH BELOW TO STRINGER 30L, CRACK LENGTH: 0.125 INCH. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR INSTRUCTIONS FOR REINFORCEMENT REPAIR IN FR35 AT LEVSDR SWAA2025092918364Fuse · faultedEMERGENCY EXIT INDICATOR LIGHT ON AFT OVERWING EXIT DOOR LEFT AND RIGHT (LOWER LIGHT) ARE INOPERATIVE. TROUBLESHOT THE AFT OVERWING EXIT LIGHTS TO A FAULTY FUSE F2 ON M1695 BATTERY PACK IAW WDM 33-51-21. REPLACED M1695 F2 FUSE & TESTED IAW AMM 33-51-06-960-8SDR IPXA2025092946537Apu · odorWITH APU ON - TURNING ON FIRST PACK WE ARE HAVING HEAVY OIL SMELL FUMES IN COCKPIT. TS PERFORMED FOR OIL SMELL FUMES IN THE COCKPIT IAW FIM 21-00-21/201 REV 146. OIL SMELL FUMES NOT OBSERVED. AIR CONDITIONING SYSTEM OPERATIONAL TEST PERFORMED WITH APU BLEED IASDR DALA2025092907048Lens · damagedEMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. CORRECTIVE ACTION: SWAPPED EXIT SIGN LENS AS REQUIRED. OK FOR SVC. (1216500)SDR DALA2025092907045Spring · inoperativeSHIP 194 GAS SPRING DOESN'T WORK ON 841 FWD RIGHT PASSENGER DOOR. CORRECTIVE ACTION: REMOVED AND INSTALLED NEW GAS SPRING ON 841 FWD R/H PASSENGER DOOR IAW B767 AMM 25-66-03-004-053 AND IAW B767 AMM 25-66-03 (1219866)SDR DALA2025092907043Window · arcedSHIP 1809 FLT DECK LH NO.1 WINDOW FOUND ARCING. CORRECTIVE ACTION: REMOVED AND REPLACED FLT DECK LH NO.1 WINDOW AS PER B767-400, AMM 56-11-01 (1217262)SDR DALA2025092907040Stringer · corroded(LOG 1217532) CORROSION ON STGR 24LH BTW STA 877 TO STA 897 AT AFT CARGO COMPARTMENT. STGR 24LH BTW STA 877 TO STA 897 AT AFT CARGO COMPARTMENT WAS REPAIRED PER B737-800 SRM 53-00-03-2R PROCEDURE1 REPAIR 1.SDR DALA2025092907039Fitting · corroded(LOG 1217510) STA 344 L/H GIRT BAR FITTING Z BRACKET HAS CORROSION. REMOVED AND REPLACED L/H SIDE TIEDOWN FITTING AT STA 344 IAW B737-900 SRM 51-40-02-0G.SDR DALA2025092907038Skin · damaged(LOG 1216613) LIGHTNING STRIKE DAMAGE ON EXTERNAL FUSELAGE SKIN BS708, S-6L. LIGHTNING STRIKE DAMAGE ON EXTERNAL FUSELAGE SKIN BS708 S-6L WAS REPAIRED IAW ER/A 629393-14AD REV ORIGINAL.SDR DALA2025092907037Floor Support · corroded(LOG 1216598) CORROSION ON FLOOR SUPPORTS (2EAS) BTW STA 947 TO STA 967 OF RBL 47 AND LBL47 (UPPER AND LOWER SURFACE) AT W2. FLOOR SUPPORTS (2EAS) BTW STA 947 TO STA 967 OF RBL 47 AND LBL47 (UPPER AND LOWER SURFACE) AT W2 WERE REPLACED PER B737-800 SRM 51-40-0SDR DALA2025092907049Battery Pack · no test(LOG 7267187) DURING SVC CHK FOUND EMER LIGHTS AT ROW 18-21 RH INOP. R/R EMER BATT M1695 PER B737 AMM 33-51. OPS CHECK GOOD.SDR DXTA2025092905097Case · odorAT FL390, HAD AN ODOR THAT SMELLED LIKE HOT PLASTIC. AFTER ISOLATING SEVERAL THINGS & ODOR WENT AWAY AFTER TURNING OFF ENTRANCE/GALLEY HEATER & CHILLER ON GALLEY CMS SCREEN. RAN AVIONICS EQUIPMENT, & ATTEMPTED TO NOTICE ODORS AROUND AVIONICS COOLING FANS, PRSDR DXTA2025092905093Battery Pack · faultedALL EMER LIGHTS AND SIGNS FLASH WHEN IN FLIGHT AND ON GROUND. REPEAT WRITE UP CORRECTIVE ACTION: FOLLOWED EMB CONTACT CENTER RECOMMENDATION AND C/W SL505-33-0005-REV.05 DURING STEP 9 OF FIM 33-50-00-810-802-A FOUND AN ERROR IN THE MANUAL. CONFIRMED WITH EMB THSDR DXTA2025092905092Contactor · faultedDURING POWER UP CHECKS ON PREFLIGHT, RED SMOKE AVIONICS BAY CAS MESSAGE AND AUDIO CAME ON. AFTER PERFORMING THE SMART OPS PROCEDURE FOR AN ASSOCIATED ELEC SYS FAULT MESSAGE THE CAS MESSAGE CLEARED. AFTER ENGINE START THE SAME RED SMOKE AVIONICS BAY CAS MESSAGESDR DXTA2025092905090Elec Connector · dirtyDURING INSTRUMENT APPROACH, DURING MLG EXTENSION, LT MLG WAS A YELLOW X & GEAR DISAGREE L CAS MESSEGE APPEARED. DID A MISSED APPROACH, RAISED MLG & CLIMBED TO HOLDING PATTERN & RAN CHECK LIST. LOWERED HANDLE. UPON LOWERING MLG HANDLE, ALL 3 MLG HAD A GREENSDR KCSA2025092549Actuator · unserviceableDOOR UPPER DECK FLIGHT LOCK CAUTION MESSAGE. TRANSFERRED TO DMI LIST NUMBER 100272910 IAW KA B747-400 MEL 52-23-3-2. CAT C. DUE 10-5-25. PLACARDS INSTALLED. : REFERENCE DMI 100272910. REMOVED AND REPLACED RIGHT HAND UPPER DECK DOOR LOCK ACTUATOR IAW KA B7SDR CALA2025092909391Idg · faultyELEC IDG 1 LO OIL PR AT50 KNOTS. COMPLIED WITH MEL 2420E, PRIOR TO CLEARING THIS MEL AND RESTORING THE INOP IDG TO SERVICE PYLON MOUNTED IDG CONNECTORS MUST BE VISUALL INSPECTED FOR ARCING CONDITIONS REF AMM 24-21-43-210-048C1 AND AD 2011-19-01-R1. NO HISTOSDR CALA2025092909390Control Module · faultedAFTER TO ALL FWD GALLEY OVENS AND CHILLERS INOP. AFT R COFFEPOT INOP OPERATED GALLEY OVENS/CHILLERS FOR APPROX 25 MIN AT HIGH PWR UNABLE TO DUP. PLEASE CHECK KVA SETTING OF FWD ELCU PER NAT DRAWING N0542-D73 WD 25-31-11, PINS 11 & 14 ARE JUMPERED. IF NO DEFECTSDR CALA2025092909370Battery Pack · no testPASSENGER CABIN EMERGENCY LIGHTS BATTERY AT M1673 FAILS BATTERY CAPACITY CHECK. REMOVED AND INSTALLED NEW BATTERY PACK M1673 IAW B737 AMM 33-51-06-960-805 TEST GOOD.SDR CALA2025092909369Spar · corrodedINTERGRANULAR CORROSION RT WING IB FRONT SPAR AT BOOST PUMP LOWER GROUND WIRE ATTACHMENT AREA. RT WING IB FRONT SPAR AT BOOST PUMP LOWER GROUND WIRE ATTACHMENT FOUND OUT OF LIMITS , PERFORMED REPAIR ON AREAS IAW AAR ESR-WI 13-12798 AND ECRA 5720-03564.SDR CALA2025092909368Contactor · missingAPU CRANK CONTACTOR U/S ON FIT. APU CRANK CONTACTOR FOUND TO BE MISSING END STOP CAUSING CONTACTS TO BE MADE, NOTICED AFTER UNCOMMANDED APU START ON APU BATTERY CONNECTION. DEFECTIVE ON FIT APU CONTACTOR REPLACED AS PER AMM TASK 49-41-05-404-005. APU CRANK CSDR CALA2025092909367Skin · crackedLEFT APU DOOR 315AL CENTER EXTERIOR SKIN EDGE GOUGED. REPAIRED LT APU ACCESS DOOR EXTERNAL SKIN BETWEEN STA 1922.329 A ND STA 1929.266 BL 0.00 IAW EC/RA#5240-02156.SDR CALA2025092909366Skin · delaminatedUPON EXTERNAL WALKAROUND FOUND OUTBD RIGHT TRAILING EDGE FLAP DELAMINATED. INSPECTED FLAP TRACKS AND HDWR, STARTED INSTALLATION OF R/H OUTBOARD AFT FLAP REF AMM 27-51-22-400-801 STEPS 3G THRU 3H (4)-(F) VERIFIED R/H OUTBD AFT FLAP INSTALLATION STEPS 3G-3H(4SDR CALA2025092909357Sticker · detached2L SLIDE ARMING DOOR STICKER COMING LOOSE REPLACED ARM/DISARM DOOR STICKER AT DOOR 2L. PARTS USED: 26-1132-3-0077, QTY :1 26-1132-3-0147, QTY :1SDR CALA2025092909356Bottle · low pressurePRESSURE GAUGE ON DOOR SLIDE AT DOOR 1R IS ON THE BORDER OF RED/ GREEN. NEEDLE IS NO MORE THAN NEEDLE WIDTH TO RIGHT OF GO BAND REF AMM TASK 25-66-01-200-801SDR CALA2025092909348Light · malfunctionedEMERGGENCY LIGHTS ON DOOR 2L ILLUMINATED RED IN FLT AND ON GROUND. RESET AFT, ACCOMPLISHED OPS CHECK, GOOD IAW AMM 23-42-03.SDR CALA2025092909347Light · detachedSEAT 11C EMERGENCY EXIT LIGHT HANGING DOWN FOUND EMERGENCY LIGHT HANGING AT SEAT 11C. REMOVED AND REPLACED THE EXIT LIGHT AT SEAT 11C. OPS CHECKED NORMAL AT THIS TIME. OK TO CONTINUE FOR SERVICE.SDR CALA2025092809341Unknown · odorSUDDEN STRANGE ODOR IN CABIN SMELL NOTICED WHILE APU AND PACKS RUNNING. TIMING OF SMELL COINCIDED WITH RAMP OPENING FWD CARGO PITS AND POSITIONING LOADER. VERIFIED WITH CAPTAIN AND CREW SMELL WAS SIMILIAR TO LOADER EXHAUST SMELL ENTERED FORWARD ELECTRONICS BAY