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 SWAA2025093018991Circuit Breaker · trippedEMERGENCY LIGHTS CIRCUIT BREAKER P18-3 B10 TRIPPED. CONFIRMED M1672 FAILED.SDR SWAA2025093018905Battery Pack · inoperativeAFT RT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED AFT RT EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2025093019113Wire · exposedMAIN CABIN, RT FWD OVERWING EXIT SIGN HAS WIRE EXPOSED. ADJUSTED MAIN CABIN RT FWD OVERWING EXIT SIGN IAW AMM 25-21-46-400-801.SDR AALA202509307020Engine · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF N1 HAD A 7 PERCENT SPLIT AND ENGINE SHUTDOWN ON IT`S OWN. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. (OPEN).SDR AALA202509304610Processor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB OUT GOT A FUEL IMBALANCE INDICATION WITH APPROXIMATELY 1500LB BETWEEN LEFT AND RIGHT TANKS. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. PERFORMED FQIS BITE TEST, NO INFLIGHT FAULTSDR AALA202509309881Socket · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT INOPERATIVE BEHIND LEFT AFT OVERWING EMERGENCY EXIT. R & R SOCKET AND CONTACT AT EXTERIOR EMERGENCY LIGHT PER AMM 33-51-04, NO FIX. CHECKED LIGHT TERMINALS FOR VOLTAGE PER WDM 33-51-13, NO VOLTAGE PRESENT. FUSDR AALA202509308604Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY FLASHLIGHT AT AFT GALLEY INOPERATIVE. REMOVE AND REPLACED EMERGENCY FALSHLIGHT AT AFT GALLEY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202509306399Elec Connector · no testAIRCRAFT WAS GROUNDED: EMERGENCY PROXIMITY LIGHT FROM SEAT ROW 29 TO 33ABC INOPERATIVE. REMOVED AND REPLACED SEAT-TO-SEAT CABLE CONNECTOR BENEATH SEAT 27L. PER SWPM 20-61-28. EMERGENCY LIGHTS OPERATIONAL CHECK GOOD.SDR DALA2025093007104Skin · corrodedSHIP 3318 FUSELAGE SKIN / FR 74 TO FR 75 / S-40L TO S-42L / WATER WASTE VENT / CORROSION. CORRECTIVE ACTION: COMPLIED WITH ERA 629544-14 REV ORIGINAL. (7074981)SDR DALA2025093007098Vent · corrodedCORROSION ON LAV VENT BEYOND SRM LIMITS. REPAIRED PER ERA 629544-14 REV ORIGINAL. (7074980)SDR DALA2025093007091Skin · damagedSHIP 3318 DAMAGE ON FUSELAGE SKIN AT FR74 TO FR75/S-40L TO S- 42L WASTEWATER VENT. CORRECTIVE ACTION: REPAIRED PER ERA 629544-14 REV ORIGINAL. (1222800)SDR DALA2025093007088Battery · inoperativeDURING SVC CHECK FOUND ROWS 46-49 EMERGENCY EGRESS LIGHTS INOP. R & R BATTERY AND CHARGER M737 PER B757 AMM 33-51. OP CHECK GOOD. (7862922)SDR AALA202509300340Elec Connector · looseAIRCRAFT WAS GROUNDED: EMERGENCY WALK WAY PATH LIGHT INOP AT ROW 5HD. MAINTENANCE FOUND PIN LOOSE AT HARNESS DISCONNECT D6002P FROM PWR SUPPLY. REINSTALLED PIN. OPS CK GOOD OK FOR SERVICE REF B777 WDM 33-51-58 PAGE 2C SHEET 1.SDR AALA202509306051Shade · stuckAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE AT EMERGENCY EXIT SEAT 11A WON'T OPEN FULLY. MAINTENANCE REPLACED WINDOW SHADE FUNNEL ASSY.SDR DALA2025093007087Striker · inoperativeMID DOOR RELEASE STRIKER INOP. PERFORMED OPS CK PER A319 AMM 52-51. NO FAULTS AND NO HISTORY.(7588166).SDR DXTA2025093005128Light · malfunctionedDURING FIRST FLIGHT PREFLIGHT, THE EMERGENCY LIGHTS WOULD NOT ILLUMINATE PROPERLY. THE MAIN CABIN DOOR LIGHTS FAILED. THE OVER GALLEY LIGHT FAILED. THE LIGHT IN THE FIRST SET OF CLUB SEATS FAILED AND ALL THE FLOOR LEVEL EMERGENCY LIGHTING FAILED. PERFORMESDR DXTA2025093005126Unknown · odorA/C AOG 9/27 FOR OVERWHELMING SMELL RELATED TO LAV. ON THE NEXT DAY, CAME TO A/C AND LAV WAS GOOD WITH NEW FLUID (NO SMELL). AFTER ENGINE START SMELL RETURNED ABRUPTLY. WENT BACK TO LAV AND SMELLED THE LAV (NO FOUL SMELL). THEN SMELLED ODOR COMING FROM REAR BUSDR DXTA2025093005125Elec Connector · not seatedLEFT FRONT FLOOR AISLE EMERGENCY LIGHTS INOPERATIVE. GAINED ACCESS TO FORWARD AISLE EMERGENCY LIGHT, AND LOCATED CONNECTOR. FOUND CONNECTOR PIN NOT SEATED IN CONNECTOR. RESEATED PIN, AND VERIFIED SECURITY AND OPERATION. OPS CHECK GOOD. RETURNED AIRCRAFT TO OSDR I5PA2025093019306Exciter · inoperativeLEFT ENGINE IGNITION SYSTEM 1 INOPERATIVE. REPLACED LEFT ENGINE IGNITION SYSTEM 1 EXCITER.SDR I5PA2025092819305Fire Loop · faultedLEFT ENGINE FIRE LOOP 2 STATUS MESSAGE. REPLACED LEFT ENGINE FIRE LOOP PER AMMSDR AALA202509299081Latch · brokenAIRCRAFT WAS GROUNDED: NUMBER 2 SLIDING WINDOW HOLD OPEN LATCH BROKEN. REMOVED CAPTAIN NUMBER 2 SLIDING WINDOW AND REPAIRED HOLD OPEN LATCH. PER AMM 56-12-11.SDR AALA202509293540Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: MAIN ENTRY SLIDE PARTIALLY FALLEN OUT OF HOUSING. ADJUSTED THE L1 DOOR SLIDE FOLD ADJACENT TO THE GIRT BAR. PER AMM25-66-01.SDR AALA202509296039Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE FORWARD FLASHLIGHT CHARGER DOES NOT BLINK TO TEST. REPLACED CHARGING MOUNTING BRACKET. PER 25-64-00-200-802.SDR DALA2025092907074Floor Panel · delaminatedDELAMINATED FLOOR PANEL 231FF IN PASSENGER CABIN. COMPLIED WITH ER/A 628624-14. (1223263).SDR DALA2025092907073Floor Panel · delaminatedDELAMINATED FLOOR PANEL 232FF IN PASSENGER CABIN. COMPLIED WITH ER/A 628624-14. (1223255).SDR DALA2025092907072Floor Panel · delaminatedDELAMINATED FLOOR PANEL 221PF AT FWD GALLEY AREA. COMPLIED WITH ER/A 628624-14. (1223257).SDR DALA2025092907071Floor Panel · delaminatedDELAMINATED FLOOR PANEL 222EF AT FWD GALLEY AREA. COMPLIED WITH ER/A 628624-14. (1223246).SDR DALA2025092907070Floor Panel · delaminatedDELAMINATED FLOOR PANEL 222CF AT FWD GALLEY AREA. COMPLIED WITH ER/A 628624-14. (1223252).SDR DALA2025092907069Floor Panel · delaminatedDELAMINATED FLOOR PANEL 221EF AT FWD GALLEY AREA. COMPLIED WITH ER/A 628624-14. (1223219).SDR GTIA2025092939108Unknown · odorAT 3000 AGL ON ILS FLT ATTENDANT REPORTED ODOR DESCRIBED AS DIRTY SOCKS PER ELIMINATION ODOR PROCEDURE PACK 2 OFF X BLEED SHUT. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS/MOLDY SMELL. APPARENT CABIN SOURCE: UNKNOWN. AFT CABIN AND MID CABIN. NO VISIBLE SSDR SWIA2025F01398Receptacle · brokenOVERHEAD PANEL FELL OFF AIRCRAFT DURING FLIGHT (FLIGHT 5805) INSPECTED AND FOUND CEILING PANEL RECEPTACLE FOR ROWS 14/15 WORN OUT AND CEILING PANEL LATCH UNABLE TO PROPERLY SECURE. REMOVED AND REPLACED AFT CEILING PANEL RECEPTACLE WITH SERVICEABLE UNIT. INSTSDR SWIA2025F01397Unknown · odorON PREFLIGHT, WALKING THRU CABIN NOTICED STRONG SMELL OF ELECTRICAL BURNING ODOR. (FLIGHT 6375 - FILED OPEN)SDR SWIA2025F01396Rib · crackedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA99994-REO 601R-55-11-792 REV-- DATED 5/24/25 MXCODEID110694-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 99994CRACK ON A NUTPLATE HOLE ON THE LH H-STAB RIB NO. 9 SPLICE (DWG: 600-23037 AL ALY ALCD 2024-T3, 0.032" NOM THSDR SWIA2025F01395Stringer · corrodedSTRINGER 21L IS CORRODED BETWEEN FS437.00 & FS453.00. (FILED OPEN)SDR SWIA2025092900028Stringer · chafedCHAFING FOUND UNDER FUSELAGE SKIN ON STRG 27, FS 977.00 TO 989.00. (FILED OPEN)SDR QXEA2025092900311Engine · vibrationPULSING VIBRATION FELT THROUGH RUDDER PEDALS ON GROUND AT IDLE AND STOPPED WITH PARKING BRAKE ENGAGED,VIBRATION CONTINUED WHILE AIRCRAFT WAS AT A STOP WITH BRAKES HELD. VIBRATION GOES AWAY WITH ADVANCE OF THROTTLES AND MOVEMENT.HIGHEST ENGINE VIBE WAS # 1 HP ASDR AALA202509296616Carpet · peelingAIRCRAFT WAS NOT GROUNDED: 3L EXIT ROW CARPET PEELING AND BUNCHED UP. MAINTENANCE ACCOMPLISHED INSTALLATION OF THE TEXTILE FLOOR COVERING ROW 24 ABC IAW AMM 25-28-41-400-001-A OK FOR SERVICE.SDR AALA202509296525Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING N4 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 4 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509293773Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING N3 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 3 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509293561Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING N2 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 2 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509298810Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING N1 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 1 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202509296900Hinge Fitting · excess playEXCESSIVE PLAY FWD BEARING MAIN DOOR ON LH MAIN LANDING GEAR. MAINTENANCE REPLACED HINGE FITTING ASSY OF RH MLG DOOR IAW AIRBUS CMM 52-81-18, A319 SRM 51-44-11-801, A319 SRM 51-21-11-801 PMS 01-05-26 AND NTM 51-90-00.SDR AALA202509290513Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EPSU BATTERY TEST FAILED ON RH EMERGENCY 12WL POS. MAINTENANCE REPLACED EPSU BATTERY RH EMERGENCY 12WL PER AMM 33-51-38.SDR AALA202509295798Light · damagedAIRCRAFT WAS NOT GROUNDED: FOUND EMERG. LT ASSY ON FWD GALLEY AREA L/H CLOSET, LF EXTERIORWALL DAMAGED. MAINTENANCE REPLACED EMERG. LIGHT ASSY. IAW AMM 33-50-00.SDR AALA202509293575Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1R DOOR ASSIST. CHECK DOOR PRESSURE ON FAP. MAINTENANCE SERVICED R1 CABIN DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR ABXA20250928242Smoke Detector · no testDURING C-4 CHECK IN OSCALA, MI., MAINTENANCE FOUND AFT LOWER CARGO SMOKE DETECTOR ZONE FIALED LEAK CHECK. REMOVED AND REPLACED TUBE ASSY, TEE HOSE, AND SILICON HOSE IAW BOEING PROPRIETARY BAC5014 REV (L) 10JUNE2024 STEP 8.3.3. LEAK CHECK GOOD IAW IAI B767-300SDR FDEA202509281843Deu · failedAT CRUISE FL370 GOT MULTIPLE CAUTIONS: LEVEL1 SELECT PACK 1 OFF, WITH MULTIPLE ELECTRICAL LEVEL1 DC TIE 3 OFF AND BUS R EMER DC OFF, ALSO LEVEL 0 GLY EXT POWER ON, THE ELECTRICAL ISSUES TRIGGERED A LEVEL2 FLAP DISAG WITH LEFT INBOARD FLAP INDICATING 22 DSDR HNAA2025092900651Acm · smokeSMOKE IN FLIGHT DECK AT CRUISE. SUSPECT PACK #1'S ACM TO BE INOP CAUSING SMOKE TO UNIT IN FLIGHT DECK. AIR COND PACK ELECTRO/MECH N600-N649. FACT 29SEP25 05:36 MDT FOUND ACM TURBINE RUBBING. R & R NR 100 ACM IRT AMM 21-51-03. R & R NR 100 HEAT EXCHANSDR CALA2025092909389Light · inoperativeEMERGENCY CEILING LIGHT ABOVE 7L INOPERATIVE. EMERGENCY CEILING LIGHT ABOVE 7L REPLACED AS PER AMM 33-51-04/401. LIGHT TEST OK.SDR CALA2025092909355Power Supply · inoperativeR2 DOOR EMERGENCY LIGHTS INOP REPLACED R2 DOOR EMERGENCY LIGHTS BATTERY PACK AND POWER SUPPLY POSITION M1672 PER AMM 33-51-06, OPS CHECK GOOD, NO DEFECTS NOTED AT THIS TIME, A/C OK TO CONTINUE.