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 CALA2025091208862Duct · blownBLEED TRIP OFF LIGHT COMES ON DURING CLIMB LIGHT NO. 2 RESET DONE DUCT PRESS SPLIT RIGHT DUCT 16 PSI LEFT DUCT 40 PSI FOUND E2 PRECOOLER DUCT ASSY. BLOWN OFF REMOVED AND REPLCED E2 PRECOOLER DUCT ASSY. REF: AMM 36-12-01-000-801.PARTS USED: 29-3611-3-0032,QTYSDR CALA2025091208842Window · undertorquedAT APPROXIMATELY 10,000 FT, 230 KNOTS THERE WAS A HISSING SOUND COMING FROM THE LEFT CORNER TO THE MIDDLE OF THE LEFT SIDE OF THE L1 WINDOW PRESSURIZED AC TO A DIFFERENTIAL PRESSURE OF 4, INSPECTED LH #1 WINDOW WITH LIQUID LEAK DETECTOR AND FLUKE IMAGING DECRESDR CALA2025091208841Bracket · looseDOOR 1R RIGHT GIRT BAR BRACKET LOOSE REPLACED LOOSE FLOOR BRACKET REF AMM 25-66-02/201. OPS CHECK GOOD.SDR CALA2025091208839Slide · damagedFOUND OUTSIDE OF SLIDE, NEED TO OPEN SLIDE COVER AND REINSTALL FORM REMOVED AND REINSTALLED SLIDE COVER TO REINSTALL SLIDE RECORD FORM REF AMM 25-66-01-400-801 VERIFIED INSTALLATION OF SLIDE PACK AND COVER ON L1 DOOR IAW AMM 25-66-01-400-801 AND GMM 9-25-05.SDR CALA2025091208837Angle · damagedON THE L/H HORZ BEAM ANGLE. ACCOMPLISH INSPECTION REQUIREMENTS PER PART 2 OF EC/RA 5380-01429 ON OR BEFORE 09 SEPT 2027. ON THE LH REAR SPAR HORIZONTAL BEAM ANGLE ACCOMPLISH REQUIREMENTS PER PART 2 OF EC/RA# 5380-01429.SDR CALA2025091208825Door Frame · crackedRT FWD EMER EXIT DOOR FWD VERT BEAMS CRACKED. REMOVED AND REPLAED RT FWD EMER EXIT DOOR'S FWD VERT DRAIN IAW A 320 SRM 51-42-11/001 AND DRAWINGS D52279010010 AND D52279040004 ESFR #1827.SDR CALA2025091208824Skin · crackedREPAIR AREA AT THE LT SIDE WING FIXED LEADING EDGE UPPER SKIN PA NEL FASTENERS BTW KRAS206.5 TO KRAS220 REF TO EA 5720-02922 REV A OP 001. REPAIRED AREAS AT THE LH WING UPPER FIXED LE SKIN P/N 116A4410-7 IAW ECRA 5741-01665.SDR CALA2025091208823Skin · crackedREPAIR AREA AT THE RH SIDE WING FIXED LEADING EDGE UPPER SKIN PANEL FASTENERS BTW KRAS206.5 TO KRAS220 REF TO EA 5720-02922 REV A OP 002.(1000055151) REPAIRED AREA AT THE RH WING UPPER FIXED LE SKIN P/N 116A4410-8 IAW ECRA 5741-01664SDR CALA2025091208822Structure · corrodedAFT CARGO BETWEEN STA 1460 TO 1480 AND S-2 8R TO S-29R WITH CORROSION IN THE UPPER SURFACE AND LOWER SURFACE. REMOVED AND REPLACED CHORD AT AFT CARGO BETWEEN STA 1460 TO 1480 RBL 12.7 IAW SRM 51-10-02, 51-40-02. WC:132848.SDR CALA2025091208821Floor Support · damagedMAIN CABIN FLOOR SUPPORT BS 947 TO 967 LBL 20 HAS BARE METAL. REMOVED AND REPLACED FLOOR SUPPORT PO 1131023.3 AT STA 947-967 LBL 20 IAW DWG 147A5650 REV - AND SRM 51-40-05.SDR DXTA2025091204907Elec Connector · damagedDURING PREFLIGHT IT WAS DISCOVERED THAT THE EMERGENCY LIGHTING SYSTEM IS INOPERATIVE. CORRECTIVE ACTION: DURING INITIAL INSPECTION AND OPERATION OF THE EMERGENCY LIGHT SYSTEM THE ONLY EMERGENCY LIGHT! INOP FOUND WAS THE CABIN DOORSTEP LIGHT (EXTERIOR AT MAIN ESDR I5PA2025091019304Pressure Switch · faultedRIGHT ENGINE ANIT ICE ON DECENT. R & R RT ENG ANTI ICE LOW PRESS SWITCH PER AMM. OPS CHECK OK.SDR ASAA2025091060806Light · brokenRIGHT OVERWING EMERGENCY EXIT HAS STRING STICKING OUT. GROUNDED - YES. REPAIRED BROKEN OVERWING ESCAPE HATCH LIGHT WIRING REF WDM 33-51-13-1. SECURED WIRE BUNDLE IN CLAMP. OPS NORMAL.SDR COEA2025091109757Support · damagedLEFT ENGINE INBOARD AFT TRUSS SUPPORT DAMAGE. MAINTENANCE INSPECTED AND APPLIED SURFACE TREATMENT PER SRM.SDR COEA2025091108757Bracket · gougedDAMAGE FOUND ON THE LEFT ENGINE INBOARD AFT FIREWALL BEHIND ICE VANE ACT REAR BRACKET ASSY. MAINTENANCE INSPECTED AND APPLIED SURFACE TREATMENT PER SRM.SDR COEA2025091107757Rod End · shearedLEFT ENGINE ICE VANE ACTUATOR AFT CLEVIS SHEARED OFF. REPLACED BROKEN ROD END AND RE-INSTALLED ICE VANE ACTUATOR IAW C408 MM 30-20-00.SDR ELYA09102025005Switch · meltedPITOT HEAT 1 INOP ON THE GROUND DURING PREFLIGHT. DEFERRED PITOT HEAT TO GET IT HOME. MX FOUND PITOT HEAT SWITCH WITH HEAT DAMAGE AROUND PINS 2, 5, AND 6. WITH CORRESPONDING HEAT DAMAGE ON SWITCH CONNECTOR AND WIRING TERMINALS. REPLACED SWITCH AND OPS CHECK GOSDR SWAA2025091113393Girt Bar · inoperativeFORWARD SERVICE DOOR GIRT BAR INOP. REPAIRED FWD SERVICE DOOR GIRT BAR BRACKET RIVET. PER SRM 51-40-02-0G-0.SDR SWAA2025091113783Acm · odorDURING F/O ROLL EXPERIENCED RANCID ODOR FOLLOWED BY EXTREMELY HOT AIR COMING THROUGH THE VENTS, COULD BARELY CONTROL TEMP IN CABIN ON LANDING AND TAXI IN WENT TO PACKS HIGH -CONTINE TO DESCRIPTION AND APU BLEED AND KEPT GETTING LEFT PACK TRIP OFF LIGHT. ACM SDR SWAA2025091113146Tray · incorrectPASSENGER SEAT TRAY TABLE LATCH; IS EMERGENCY ROW LATCH; NEEDS TO BE REPLACE W/ RIGHT ONE @ 17 C PASSENGER SEAT TRAY TABLE LATCH IS EMERGENCY ROW LATCH NEEDS TO BE REPLACE W/ RIGHT ONE @ 17 C<[01] REPLACED TRAY TABLE LATCH AT A17C. REF. CMM 25-21-42.SDR SWAA2025091113784Battery · inoperativeFWD FA FLASHLIGHT INOPERATIVE. R&R BATTERY, OPS NORMAL. PER AMM 25-64-00SDR SWAA2025091113130Slide · looseFWD ENTRY DOOR; VELCRO STRIPS ON THE GIRT ARE NOT ATTACHED TO VELCRO STRIPS ON THE BACKING PAN SHELF<[01] RESECURED FWD ENTRY DOOR SLIDE PROPERLY IN REF WITH AMM 25-66-01.;[02] RESECURED FWD ENTRY DOOR SLIDE PROPERLY IN REF WITH MT 725-61-06.SDR SWAA2025091113140Slide · looseFWD SERVICE DOOR VELCRO STRIPS ON THE GIRT ARE NOT ATTACHED TO VELCRO STRIPS ON THE BACKING PAN SHELF<[01] RESECURED FWD SERVICE DOOR SLIDE PROPERLY IN REF WITH AMM 25-66-01.;[02] RESECURED FWD SERVICE DOOR SLIDE PROPERLY IN REF WITH MT 725-61-06.SDR SWAA2025091113249Girt Bar · out of adjustFORWARD SERVICE DOOR GIRT BAR OUT OF ALIGNMENT IN DISARMED POSITION.ADJUSTED GIRT BAR LOCK TABS AS NEEDED PER MM25-66-02.SDR GTIA2025091139073Unknown · odorDIRTY SOCK SMELL ON TAKE OFF, PACK 1 OFF AND SMELL DISSIPATED. DESCRIPTION OF ODOR/FUMES: PERSISTENT, MUSTY DRY SMELL. APPARENT CABIN SOURCE: UNKNOWN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED. -REF TSM 05-50-00-810-831A . APU VERIFIED NO LEAKS. PRESDR GTIA2025091139072Unknown · odorRECEIVED VERBAL REPORT OF STRONG DIRTY SOCK SMELL IN CABIN DURING CLIMB OUT AND DESCENT FROM DEAD HEADING CABIN CREW AT 7A AND 8A.DURING INBOUND FLIGHT:NKS 2065.INBOUND FLIGHT CREW MADE NO MENTION OF FUME EVENT AND NO WRITE UP WAS ENTERED IN AML. DESCRIPTION OSDR AALA202509111682Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509114870Bottle · 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 AALA202509111156Bottle · low pressureAIRCRAFT WAS GROUNDED: CIDS FAULT DOOR BOTTLE MID L. MAINTENANCE SERVICED LEFT HAND FORWARD EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-20 WHICH RESULTED IN THE FAULTS CLEARING.SDR AALA202509111657Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: THE MESSAGE, CHECK DOOR PRESSURE 4R, IS ANNUNCIATED ON THE CIDS PANEL. MAINTENANCE SERVICED 4R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AMM 52-10-00 WHICH CLEARED THE MESSAGE.SDR AALA202509119584Bottle · low pressureAIRCRAFT WAS GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509119485Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509113682Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509116155Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR FDEA202509101682Floor Panel · damagedMAIN CARGO FLOOR PANEL 242KFF HAS DAMAGE. REPAIRED MAIN DECK FLOORBOARD PANEL # 242KFF, P/N 143T5876-94, AT STA 930- STA 971.75, RBL 33"- RBL 54.75" IN REF. TO SRM 53-00-50-2R REPAIR 1 FIG.201 SHEET 1. THIS IS A MAJOR REPAIR.SDR FDEA202509101681Floor Panel · dentedMAIN CARGO, FLOOR PANEL 242LFA HAS DAMAGE. (PANEL REINSTALL ON SEQ. 114) FABRICATED FLOORPANEL# 242LFA MPN# 145T5876-110 STA 930-980 RBL 54.75-RBL 74.25 IN REF TO BOEING DWG 145T5876-110. SEE JPF FOR ALL WORKSTEPS ACCOMPLISHED. INSTALLATION OF FLOORPANEL 2SDR FDEA202509101680Floorboard · dentedMAIN CARGO, FLOOR PANEL 241AGF HAS DAMADE FABRICATED NEW FLOOR PANEL (PNL 241AGF MPN: 145T5876-113) AT STA 984.95 TO STA 1087 BETWEEN LBL 77.5 AND LBL 77.5 IN REF TO BOEING DWG# 145T5876-113. THIS IS A MAJOR REPAIR. SEE JPF WORK STEPS ACCOMPLISHED. THE INSSDR IPXA2025091116154Pawl · damagedCREW DOOR LATCH PAWL DAMAGED. ++REPLACED THE DOOR PAWL PER AMM 52-12-25, AND 20-00-00. OPS CHECKS GOOD.SDR IPXA2025091109961Door · bindingUNABLE TO SECURE L FWD ENTRY DOOR. MULTIPLE ATTEMPS MADE OPERATED DOOR IAW B767 AMM 52-12-00 OPS CHECK OKSDR DALA2025091106717Bottle · low pressureR2 DOOR ASSIST PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7365122)SDR DALA2025091106716Angle · damagedCABIN FRAME C63 RT OTBD CLIP HAS TOOLING MARKS. REPLACED CLIP PER AIRBUS DRAWING F5398501300400 AND A330 SRM 53-11. (1192133)SDR DALA2025091106715Bottle · low pressureDOOR 1R BOTTLE PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7826130)SDR DALA2025091106712Fitting · crackedSHIP 3157 CRACK INDICATIONS FOUND IN LH AND RH FRONT WINDSHIELDS AND CONTINUITY FTGS AS WELL AS HOLES D1 LH AND RH SIDES. CORRECTIVE ACTION: COMPLIED WITH ER/A 628084-14. (1192691).SDR DALA2025091106711Fitting · crackedCRACK INDICATIONS FOUND IN LH AND RH FRONT WINDSHIELDS AND CONTINUITY FTGS AS WELL AS HOLES D1 LH AND RH SIDES. COMPLIED WITH ER/A 628084-14. (1192669)SDR DALA2025091106710Frame · crackedCRACK INDICATION ON FRAME 16 RH SIDE OPEN FASTENER HOLE H3 IN CROSSBEAM SPLICING AREA. COMPLIED WITH ER/A 628163-14AD. (1192537).SDR DALA2025091106709Frame · crackedCRACK INDICATION ON FRAME 16 RH SIDE OPEN FASTENER HOLE H2 IN CROSSBEAM SPLICING AREA. COMPLIED WITH ER/A 628163-14AD. (1192533).SDR DALA2025091106708Floor Support · corrodedCORROSION FLOOR SUPPORT +Y1162.5 LOCATED AT LEVEL FR68 AT AFT GALLEY AREA. REPLACED FLOOR SUPPORT Y1162.5 AND FASTENERS LOCATED IN FR68 TO FR69 AT AFT GALLEY AREA IAW SRM 51-42-11 AND SRM 51-72 -11. (1191865).SDR AALA202509114298Light · dislodgedAIRCRAFT WAS NOT GROUNDED: 19C EMERGENCY LIGHT LOCATED ON SEAT IS HANGING BY ELECTRICAL WIRE. SECURED 19C EMERGENCY LIGHT. PER AMM 25-21-00.SDR AALA202509114510Door · stickingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULTY TO OPEN, STICKING SLIGHTLY. ADJUSTED LAVATORY-A DOOR LATCH. PER CMM 25-40-62.SDR DXTA2025091104912Pin · out of adjustDOOR WILL NOT LATCH CLOSED. FORWARD PIN AT HALFWAY POINT ON DOOR DOES NOT MOVE WHEN TRYING TO MOVE THE HANDLE. GAINED ACCESS TO THE LATCH PIN AND PERFORMED ADJUSTMENTS AND LUBRICATION FOR THE PIN. PERFORMED OPERATIONAL CHECK GOOD. WORK PERFORMED IAW AMM 52-