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 SWAA2025090408442Floor Panel · peelingMAIN CABIN FLOOR PANEL 231FF HAS PEELING STRANDS. FABRICATED 231FF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND PER BAC DWG 143A5810 SHT 515 REV: A.SDR SWAA2025090408438Floor Panel · peelingMAIN CABIN FLOOR PANEL 232SF HAS PEELING STRANDS. FABRICATED 232SF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR AND PER DWG 144A5810 SHT 258 REV: -. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND BAC DWG 144A5810 SHT 258 REV-.SDR SWAA2025090408445Floor Panel · pulledMAIN CABIN FLOOR PANEL 241DF HAS PEELING STRANDS. FABRICATED 241DF FLOOR PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND SWA TSR-2025007582. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND SWA TSR-2025007582.SDR SWAA2025090408444Floor Panel · peelingMAIN CABIN FLOOR PANEL 241AF HAS PEELING STRANDS. FABRICATED 241AF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND SWA TSR-2025007582. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND SWA TSR-2025007582.SDR SWAA2025090408439Floor Panel · pulledMAIN CABIN FLOOR PANEL 241GF HAS PEELING STRANDS. FABRICATED 241GF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND SWA TSR-2025007582. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND SWA TSR-2025007582.SDR SWAA2025090408440Floor Panel · peelingMAIN CABIN FLOOR PANEL 241MF HAS PEELING STRANDS. FABRICATED 241MF FLOORBOARD PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND SWA TSR-2025007582. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND SWA TSR-202500782.SDR SWAA2025090408441Floor Panel · peelingMAIN CABIN FLOOR PANEL 231RF HAS PEELING STRANDS. FABRICATED 231RF FLOOR PANEL IAW B737-800 SRM 53-00-50-2R-0 GENERAL REPAIR REV 85 AND SWA TSR-2025007582. INSPECTED PER SRM 53-00-50-2R-0-B00275 AND SWA TSR-2025007582.SDR DALA2025090406566Sign · detachedEMERGENCY EXIT SIGN ON CEILING ABOVE ROW 1 DETACHING FROM CEILING. RESECURED EXIT SIGN PER B-717 AMM 33-51. (7354500)SDR DALA2025090406560Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE ABOVE OVER WINGS EXITS. REMOVED AND REPLACED BATTERY PACK B5-121 REF AMM 33-51 (7280198)SDR DALA2025090406559Doubler · crackedCRACK ON DOUBLER BTW STA: XRS164 AND 150.450 AT LT WING. LOWER SURFACE OF LT WING WAS REPAIRED PER ER/A 626343-14AD (1165171)SDR 3EJA20250904002Warning Message · illuminatedDURING CRUISE FLIGHT AT FL400, WE RECEIVED A CAS MESSAGE ”CABIN DOOR. PERFORMED OPERATIONAL AND LEAK CHECKS ON MAIN CABIN DOOR SEAL IAW CESSNA MODEL 560XL AMM 52-10-04, NO DEFECT NOTED. TESTS
GOOD.SDR 3EJA2025090401Fuel Filter · not reportedLH FUEL BYPASS FILTER CAUTION LIGHT ILLUMINATED. CHECKED L/H FUEL FILTER FOR UNUSUAL OR CONTAMINATION NONE FOUND REPLACED FILTER ELEMENT P/N 3102404-01 NSN AND O-RINGS P/N AS3209-138 AND P/N AS3209-212 IAW P&W MM 73-10-05. PERFORMED ENGINE RUN IAW 560XL MM 71-SDR CALA2025090408445Warning Light · false activationEQUIP DOOR ILLUMINTED REPEAT ISSUE. DISCONNECTED WIRES TO DEACTIVATE LIGHT AND VERIFIED EQUIPMENT BAY DOORS ARE CLOSED PER DDP PROCEEDURE *DM* ADDED SW/S197 IN CASE NEEDED. RECOMMEND CHECKING/CLEANING CONNECTIONS AT D10988 AND D10986 REF WDM 52-71-12-1 TO ASSSDR SWIA2025090200826Skin · ground damageRAMP DAMAGE TO RT FWD FUSELAGE BELOW RT WINDOW WHERE STGR 15 AND FR 8 INTERSECT MEASURING 3"L X 2.75"W X 0.122"D. OUT OF LIMITS IN REF TO SRM 53-10-01. (FLIGHT 4124 - FILED CLOSED)FOUND DAMAGE TO BE BELLOW STGR 15 AND FR 8 INTERSECTION ON RH FWD FUSELAGE BELSDR SWAA2025090208481Transmitter · stuckTRAILING EDGE FLAP DISAGREE COMMANDED POSITION WAS 30 FLAPS STUCK BETWEEN25-30<[01] 01 - REMOVED AND REPLACED PER [AMM 27-58-01-401-NG (FLAP POSITION TRANSMITTER - REMOVAL/INSTALLATION - PERMANENT)] OPS CHECK NORMAL. NO FAULTS AT THIS TIME.SDR DALA2025090206508Egt Indication · illuminatedRIGHT ENGINE AUTO SHUTDOWN ON DESCENT WITH EGT EXCEEDANCE. RT ENGINE REPLACED. (LP# 7823306)SDR DALA2025090206491Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT BEAM GALLEY MOUNT NUT PLATE HOLE AT LBL40 BETWEEN FR76 AND FR78. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0193:2060-1007/006 00670 REPAIRED BEAM PER ERA 628436-14 PRI REV 0,1 ANDSDR DALA2025090206490Fitting · corrodedFOUND CORROSION ON FLOOR FITTING AFTER REMOVAL OF FLOOR ANGLE AT FR74 O/B OF LBL 43.5. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0193:2060-1007/008 00672 CORROSION LEVEL 2, LOGBOOK ENTRY REQUIRED. CORROSION CONTASDR DALA2025090206489Seat Track · corrodedFWD CABIN, RH I/B SEAT TRACK, FWD MOST TRACK, HAS EVIDENCE OF CORROSION. REMOVED CORROSION FOUND WITHOUT LIMITS. REMOVED AND REPLACED SEAT TRACK FWD R/H I/B FR20 TO 30 I.A.W. A220 ASRP J53-21-49 ASRP J51-40-11 JS1,42,20 AND JS1-21-06. (L/P# 1165377)SDR ANCF2025082626Panel · faultedPANEL 192DT, STRONG CRACKING NOISE ON THE RIGHT CENTER EMERGENCY EXIT. PANEL 192DT, IAW AMM 53-35-11-40-001-A LOWER SEAL AT PANEL 192DT WAS REPLACED AND PANEL 192DT WAS INSTALLED.SDR CALA2025090108304Floor Support · corrodedFOUND EXFOLIATED CORROSION AT SUPPORT INTERCOSTAL STA 948 LBL 27.25. REMOVED AND INSTALLED NEW INTERCOSTAL AT AFT WET AREA STA 948 LBL 27.25 PER DRAWING 147A5650 AND SRM 51-40-02-0G-0.SDR AALA202508307511Priority Valve · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SYR DUE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF WHEN RAISING LANDING GEAR LEVER A LANDING GEAR NOT UPLOCKED CAUTION APPEARED ON ECAM AND RED UNLOCK LIGHTS ON LANDING GEAR INDSDR AALA202508301319Safety Valve · hotAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SYR DUE TO THE FLIGHT CREW REPORTING THAT AFTER TAKEOFF WHEN RAISING LANDING GEAR LEVER A LANDING GEAR NOT UPLOCKED CAUTION APPEARED ON ECAM AND RED UNLOCK LIGHTS ON LANDING GEAR INDSDR SWAA2025082908184Light · missingCABIN FLOOR LT PHOTOLUMINESCENT STRIP MISSING AT 23C. R & R CABIN FLOOR L/H PHOTOLUMINESCENT STRIP AT 23C IAW AMM 33-51-15.SDR SWAA2025082908392Slide · out of positionFWD SERVICE DOOR SLIDE IS LOOSE HANGING LOW<[01] CHECKED DOOR SLIDE CANVAS TO GIRT BAR . TUCKED IN SLIDE. TO HOOK AND LOOP AS PER AMM 25-66-00SDR SWAA2025082908141Battery Pack · inoperativeTHE EXTERIOR EMERGENCY LIGHT AT THE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED LT AFT EMERGENCY LIGHTING BATTERY PACK AND POWER SUPPLY ASSEMBLY PER M/M 33-51-06.SDR SWAA2025082908383Lamp · inoperativeRT AFT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP RT AFT EMERGENCY OVERWING LIGHT PER AMM 33-51-04. OPS CHECK NORMAL.SDR SWAA2025082908633Lamp · inoperativeAFT CENTER OVERHEAD EMERGENCY EXIT SIGN HAS MULTIPLE BULBS BURNT OUT. RELAMPED AFT CENTER OVERHEAD EMERGENCY EXIT SIGN AND OPS CHECK GOOD IAW SWA B737-800 AMM 33-51-01-960-801.SDR SWAA2025082908309Handle · looseFWD ENTRY DOOR MOUNTED ASSIST HANDLE NEEDS TIGHTENING. TIGHTENED LOOSE FWD ENTRY DOOR MOUNTED ASSIST HANDLES IAW AMM 52-11-31-400-802 STEP 2(D).SDR SWAA2025082908310Handle · looseFWD SERVICE DOOR MOUNTED ASSIST HANDLE NEEDS TIGHTENED. TIGHTENED LOOSE FWD SERVICE DOOR MOUNTED ASSIST HANDLES IAW STEP 2(D).SDR AALA202508297678Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT UNDER FLIGHT ATTENDANT JUMPSEAT AT 2R DOES NOT TEST (RED FLASH WHEN BUTTON PRESSED) AND DOES NOT TURN ON WHEN REMOVED FROMVHOLDER. MAINTENANCE REPLACED EMERGENCY FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORYSDR AALA202508296166Light · shortedAIRCRAFT WAS GROUNDED: DURING MULTIPLE FAULT MESSAGES FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. MAINTENANCE FOUND THE L1 DOOR SLIDE LIGHTING SHORTED, REPLACED THE SLIDE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK 26L0002SDR AALA202508299864Door Latch · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR TOP LATCH WOULD NOT DISENGAGE AFTER ARRIVAL. MAINTENANCE REPLACED CENTER LATCH DOOR MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-21.SDR AALA202508294623Bottle · 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 AALA202508295100Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508291583Bottle · low pressureAIRCRAFT WAS GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508298986Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508290074Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508291837Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508294401Flap System · lockedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO MIA DUE TO THE FLIGHT CREW REPORTING A FLIGHT CONTROL FLAPS LOCKED -ALIGNMENT FAULT DISPLAYED. THE FLIGHT CREW PERFORMED ECAM ACTIONS CHECK LISTS AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENSDR AALA202508290228Handle · looseAIRCRAFT WAS NOT GROUNDED: 3L DOOR DISARM HANDLE IS VERY LOOSE. MAINTENANCE RESECURED ARM/DISARM LEVER PER AMM 52-10-00.SDR DALA2025082906390Generator · leakingDIRTY SOCK ODOR ON DECENT. INITIALY NOTICED AT 12000 FT AND DISSAPATED BY 5000 FT. FOUND LEAK ON APU GENERATOR, COMPLIED WITH T/C 7900-2001 & 0550-2002 AND LEVEL B REMOVAL OF THE CONTAMINATION OF THE ECS. REPLACED APU GENERATOR. (LP 7313472, 7313474)SDR AALA202508295902Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING J/C 26C00025003 FOUND FWD F/A FLASHLIGHTS NEEDS SERVICE. REPLACED FWD FA FLASHLIGHT BATTERY PER J/C 26C00025003.SDR AALA202508292548Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING J/C 26C00025003 FOUND FWD MEGAPHONE NEEDS SERVICE. MAINTENANCE REPLACED FWD MEGAPHONE BATTERY PER J/C 26C00025003.SDR AALA202508297529Emer Light Sys · disconnectedAIRCRAFT WAS NOT GROUNDED: DURING PS CHK FOUND SEAT NO. 22 AND 23 ABC ISLE EMERGENCY LIGHTINOP. MAINTENANCE RESECURED EPL CONNECTOR 7250VC8 FOR SEATS 22ABC AND 23ABC--PER AWM 33-51-08-OPS GOOD PER AMM 33-51-00.SDR AALA202508294326Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING J/C 26C00025003 FOUND AFT MEGAPHONE NEEDS SERVICE. MAINTENANCE REPLACED AFT MEGAPHONE BATTERY PER J/C 26C00025003.SDR AALA202508292933Battery · failedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING J/C 26C00025003 FOUND AFT F/A FLASHLIGHT NEEDS SERVICE. MAINTENANCE REPLACED AFT FA FLASHLIGHT BATTERY PER J/C 26C00025003.SDR AALA202508293112Power Supply · fault messageAIRCRAFT WAS NOT GROUNDED: EPSU SYS TEST FOR PS CHECK SHOWS 13WL FAULT. MAINTENANCE REPLACED EPSU 13WL IAW AMM 33-51-38 OPS CHECK GOOD.SDR CALA2025082908273Apu · odorFOUL ODOR OF FUMES/OIL COMING FROM PACKS WHILE ON BOTH ENG & APU BLEED. ACCOMPLISHED LEVEL A DECONTAMINATION OF ECS WITH APU BLEED IAW AMM 21-00-00-615-802-A. ODOR OF OIL/FUMES PERSISTS. ACCOMPLISHED DECONTAMINATION OF ECS WITH ENGINES 1 & 2. SMELL FADED WITSDR DXTA2025082904731Warning Message · illuminatedFLAP FAIL YELLOW CAS. CYCLED TWICE, SAME INDICATION AT 0. 3RD CYCLE FLAPS FUNCTIONED NORMAL. AFTER LANDING, FLAPS RETRACTED TO 0. POWERED ACFT. NO FAULT MESSAGES. PERFORMED FLAP ACTUATOR OIL LEVEL CHECK, ALL OIL LEVELS CHKED GOOD IAW MM 12-18-00-612-802-A.