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 HNAA2025112100785Battery · inoperativeRH SIDE LWR FWD EMER LIGHT INOP. RAR #200 BATERY CHARGER IAW AMM 33-50-04. OPS CHECK GOODSDR HNAA2025112100784Icu · faultedAFTER T/O EXTREME STATIC ON COMM AND INTERPHONES. ON COMM 1, 2 & 3. STATIC CLEARED ON GROUND. R & R #100 INTEGRATED COMMUNICATIONS UNIT ITW AMM 23-00-01. OPS CHECK GOOD. A/C OK FOR SERVICE AT THIS TIMESDR SIMA20251120001Bulb · blownFA REPORTS AFT FA JUMP SEAT EMERGENCY FLASHLIGHT BULB BLOWN. R & R AFT FA JUMPSEAT EMERGENCY FLASHLIGHT IAW AMM 33-51-00.SDR HNAA2025112100783Steering Sys · out of adjustDURING TAKE OFF ROLL ATTEMPT NWS VEERS LEFT WITHOUT TILLER ENGAGEMENT UNDER 30 KIAS. TAKE OFF REJECTED. PERFORMED TAXI CHECKS, NO DEFECTS NOTED. INSP STEERING ADJUSTMENT IRW AMM 32-50-00 AND FOUND TO BE W/I LIMITS. ACFT GOOD FOR SERVICESDR SCNA20251121448Bracket · looseFWD R1 DOOR GIRT BAR BRACKET LOOSE. TIGHTENED 1R DOOR GIRT BAR HOLDER IAW AMM 25-66-01.SDR UIEA2025112001317Oxygen Box · brokenF/O'S O2 TEST LEVER ON O2 MASK BOX BROKEN. REMOVED & REPLACED F/O O2 MASK STOWAGE BOX IAW AMM 35-11-00/501, AND 35-11-51. OPS & LEAK CHECKED GOOD.SDR UIEA2025111801298Spar Web · crackedCRACK ON LT WING FRONT SPAR WEB NEAR FSSI 660, DURING PERFORMING BOEING SB 747-57A2357. REMOVED THE AFFECTED FASTENER IAW SRM 51-40-02-0G-0, REV 62. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0485601. ACCOMPLISH EI T2025A57M-2406, REV 3. COSDR UIEA2025111801299Beam · corrodedCORROSION- BEAM, LT WING INBD L/E CAVITY LOWER PNL FWD SUPPORT BEAM INNER FACE, ILES 485. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 61. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0462383. MEASURED REWORK AREA LENGTH= 1.2", WSDR UIEA2025111801300Beam · corrodedCORROSION- BEAM, LT WING INBD L/E CAVITY LOWER PANEL FWD SUPPORT BEAM INNER FACE, ILES 600 - ILES 630. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 61. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0462384. MEASURED REWORK AREA LENSDR UIEA2025111801301Beam · corrodedCORROSION- BEAM, LT WING INBD L/E CAVITY LOWER PANEL FWD SUPPORT BEAM INNER FACE, ILES 987. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 61. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0462387. MEASURED REWORK AREA LENGTH= 3.2",SDR UIEA2025111801302Beam · corrodedCORROSION- BEAM, LT WING INBD L/E CAVITY LOWER PNL FWD SUPPORT BEAM INNER FACE, ILES 942. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0 REV 61. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0462386. MEASURED REWORK AREA LENGTH = 1.8", WISDR UIEA2025111801303Beam · corrodedCORROSION- BEAM, LT WING INBD L/E CAVITY LOWER PANEL FWD SUPPORT BEAM INNER FACE, ILES 1040. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 61. PERFORMED NDT INSPECTION, REFER TO JOB CARD ATTACHING SHEET 0462388. MEASURED REWORK AREA LENGTH = 2.9",SDR UIEA2025111801304Beam · corrodedCORRODED BEAM, LT WING OUTBD L/E CAVITY LOWER PNL FWD SUPPORT BEAM INNER FACE, ILES 1377. REMOVED THE AFFECTED FASTENER IAW SRM 51-40-02-0G-0, REV 62. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 62. PERFORMED NDT INSPECTION, REFER TO JOB CARD ASDR UIEA2025111801305Beam · corrodedCORRODED BEAM, LT WING OUTBD L/E CAVITY LOWER PNL FWD SUPPORT BEAM INNER FACE, OLES 1555. REMOVED THE AFFECTED FASTENER IAW SRM 51-40-02-0G-0, REV 62. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0, REV 62. PERFORMED NDT INSPECTION, REFER TO JOB CARD ASDR UIEA2025111801306Angle · corrodedCORRODED ANGLE. BODY GEAR KEEL BOX AREA, BS 1395, BL 0. REMOVED DAMAGED PART IAW SRM 57-40-02-0G-0 REV 61. FABRICATED NEW PART IAW W/S 50760. INSTALLED NEW PART IAW SRM 51-40-02-0G-0, REV 62, AND DWG 65B15069, SHEET 12, REV C. CONDITION CHECK NORMAL AND JOSDR UIEA2025111801307Strap · corrodedCORROSION ON STRAP NEAR UPPER FACE OF LT WING L/E UPPER FIXED PANEL, OLES 1487. REMOVED DAMAGED PART IAW SRM 51-40-02-0G-0 REV 62. INSTALLED NEW PART IAW SRM 51-40-02-0G-0 REV 62 & DWG 65B10636, SHEET 3, REV A, DWG 112U3003, SHEET 1, REV A, DWG 65B10637, SDR UIEA2025111801308Skin · corrodedCORROSION ON LT WING UPPER SKIN LOWER SURFACE AT WS 1538. REMOVED THE AFFECTED FASTENER IAW SRM 51-40-02-0G-0 REV 62. BLENDED OUT THE DAMAGED AREA IAW SRM 51-10-02-0G-0 REV 62. PERFORMED NDT INSPECTION, REFER TO DATA SHEET 11633434-1 & DATA SHEET 11633434-2SDR UIEA2025111801309Rib · corrodedCORROSION ON RIB OF LT WING FIXED TE PANEL SUPPORT AT B.STA 1294, WL 128.57. ACCOMPLISHED EI T2025A57M-2429 REV 1. CHECKED NORMAL.SDR UIEA2025111801310Cowl Door · corrodedCORROSION DAMAGED ON SKIN AND DOUBLER OF NO. 1 ENG LT CORE COWL, BETWEEN NAC STA 22.50 AND NAC STA 230.5 ON AFT SIDE OF PRECOOLER DUCT.(<P>1. ACCOMPLISHED EI NO: T2025A54M-2477 REV 2. 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR UIEA2025111801311Light · no testFOUND THE L1 DOOR MOUNTED EMERGENCY LIGHT ASSY X317 FUNCTIONAL FAIL. REPLACED L1 DOOR MOUNTED EMERGENCY LIGHT ASSY X317 AND PERFORMED INSTALLATION TEST IAW AMM 33-51-06-004-046 AND AMM 33-51-06-404-049 REV 115. THE RESULTS WAS SATISFACTORY.SDR CALA2025112111398Web · crackedMAIN CABIN AFT FLOOR WEB IS CRACKED AT BS 1016, RBL 19. REMOVED AND REPLACED CRACKED FLOOR WEB IAW BAC DWG 147A5700 REV -.SDR CALA2025112111396Seat Track · corrodedCORROSION ON CABIN SEAT TRACK CENTER OF CROWN, LBL 46, BS 1080 - 1180. REMOVED AND REPLACED SEAT TRACK IAW SRM 51-40-02-0G-0.SDR CALA2025112111394Seat Track · corrodedCORROSION ON CABIN SEAT TRACK CENTER OF CROWN RBL 46, BS 1060 - 1180. REMOVED CORROSION IAW AMM 51-00-53-102-054; EVALUATED AS FOLLOW 0. THICKNESS 0.185", MATERIAL LOSS 0.050", MATERIAL REMAINING 0.135", FOUND TO BE WITHIN LIMITS IAW SRM 53-00-5 2-1A-1, FABRISDR CALA2025112111392Power Supply · no testESPU FIN 10WL FAILED ESPU SYSTEM TEST IAW TASK 33-51-00-710-001-A, FAILED ESPU SYSTEM TEST IAW TASK 33-51-00-710-001-A. REPLACED POWER SUPPLY 10WL IAW AMM 31-51-38-000-001-A, ACP EPSU BITE TEST, NO FAULTS.SDR CALA2025112111390Structure · damagedINSTALL LT HORIZONTAL STAB ASSY IAW AMM 27-41-11-400-801. REMOVED LT HORIZONTAL STAB FOR ACCESS IAW AMM 27-41-11-000-401. BEGAN INSTALLATION OF LH HORIZONTAL STAB IAW AMM 27-41-11-400-801 HARD POINTED AFT PINS & TEMP INSTALLED FWD BOLTS INSTALLED AFT SPAR PSDR CALA2025112111383Unknown · odorON ACCOUNT OF A INDISTINGUISHABLE ODOR IN CABIN, INSPECTED DUCTS FOR EVIDENCE OF OIL IAW AMM 36-12-04-200-801. OPENED DUCT IN A/C BAY JUST BEFORE OZONE CONVERTER, NO EVIDENCE OF ANY CONTAMINATION. SHOULD READ OPENED BOTH LT AND RT SIDE DUCTS. PRIOR TO THE OSDR CALA2025112111382Smoke Detector · no discrepancyAFT LAVATORY SMOKE MASTER WARNING. MOMENTARALY. POSSIBLE PAX WITH VAPE, UPON MX ARRIVAL DEBRIEFED BY CAPTAIN AND F/A CREW CONFIRMATION OF PAX IN LAVATORY F AND SMELLED AN MARIJUANA ODOR WHEN EXITING THE LAVATORY. INSPECTED LAVATORY F NO EVIDENCE OF TAMPERINSDR CALA2025112111381Lanyard · out of positionR1 SLIDE LIGHT DOES NOT ILLUMINATE WHEN DOOR IS ARMED. SECURED LOOSE LANYARD. GIRT BAR OPS FREELY. DOOR ARMS AND DISARMS WITH SLIDE LIGHT NORMAL.SDR CALA2025112111380View Port · faultedR4 DOOR DISARMED AT GATE BUT THE YELLOW GIRT BAR IS STILL IN VIEW DOOR R4 ARM DISARM OPS CHECKED OK, DOOR OPEN CLOSE NORMALLY AND COCKPIT IND ALSO NORMAL. VIEW PORT COVER REPLACED.SDR CALA2025112111379Warning Light · false activationAFT ENTRY DOOR LIGHT ON AFTER LANDING. OPERATED AFT ENTRY DOOR HANDLE NUMEROUS TIMES, FOUND INDICATION TO COINCIDE WITH DOOR POSITION AND NO DEFECTS NOTED. INTERIOR HANDLE CLOSES PROPERLY WITH NOTICEABLE DETENT WHEN CLOSED. REF FIM 52-10 TASK 814.SDR DXTA2025112105780Warning Message · illuminatedDOOR PAX SEAL FAIL ANUNCIATOR ILLUMINATED IN FLIGHT. RAN CHECKLIST & RESTRICTED FLIGHT TO AT OR BELOW FL400 IAW CHECKLIST. CONTACTED CRC AND SENT DOWNLOADS. PERFORMED THE RECOMMENDED FIM TASK 5615-36-16-00-810-803-A, WHICH INSTRUCTS ATTEMPTING TO CLEAR THE FSDR DXTA2025112105782Battery · dischargedWE ENTERED THE PLANE AND WERE TESTING THE EMERGENCY LIGHTS AND FOUND SOME INOP. EMERGENCY LIGHT OVERHEAD SEAT NR 7, FLOOR LIGHTING SEAT NR 8, & EMERGENCY EXIT OVER A WING ARE NOT ILLUMINATING. CHARGED THE BATTERY FOR 60 MINS & STILL NO LIGHTS. VERIFIED DISCRSDR SWAA2025112037094Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS OUT MID CABIN. R & R BATTERY PACK AND CHARGER NEAR LT EMERGENCY WINDOW IAW AMM 33-51-06, OPS CHECKED GOOD.SDR SWAA2025112037086Power Supply · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. R & R POWER SUPPLY AT BS 727 LT IAW AMM 33-51-06. OP CHECKED GOOD.SDR SWAA2025112037052Battery Pack · no testPASSENGER CABIN EMERGENCY LIGHTS BATTERY PACKS M1675, M1674, M1673, & M1672 FAILED CAPACITY TEST. R & R THE EMERGENCY LIGHTS BATTERY PACKS IAW AMM 33 51-06.SDR SWAA2025112037147Battery Pack · no testPASSENGER CABIN; EMERGENCY LIGHTS BATTERY PACKS M1675, M1674, M1673, & M1672 FAILED CAPACITY TEST. R & R EMERGENCY LIGHTS BATTERY PACKS IAW AMM 33 51-06.SDR SWAA2025112037148Battery Pack · no testPASSENGER CABIN EMERGENCY LIGHTS BATTERY PACKS M1675, M1674, M1673, & M1672 FAILED CAPACITY TEST. R & R EMERGENCY LIGHTS BATTERY PACKS IAW AMM 33 51-06.SDR SWAA2025112037149Battery Pack · no testPASSENGER CABIN EMERGENCY LIGHTS BATTERY PACKS M1675, M1674, M1673, & M1672 FAILED CAPACITY TEST. R & R EMERGENCY LIGHTS BATTERY PACKS IAW AMM 33 51-06.SDR SWAA2025112036937Isolator Mount · crackedPASSENGER CABIN ESCAPE SLIDE FWD UPPER ISOLATOR CRACKED. R & R PASSENGER CABIN ESCAPE SLIDE FWD UPPER ISOLATOR IAW SRM 51-40-02. INSPECTION C/W R&R PASSENGER CABIN ESCAPE SLIDE FWD UPPER ISOLATOR IAW SRM 51-40-02.SDR SWAA2025112036922Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. RESECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE IAW AMM 20-50-11.SDR SWAA2025112037078Battery Pack · inoperativeAFTER L ENTRY DOOR EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY PACK BATTERY M1673 IAW MM 33-51-06, ALL 3 EMERGENCY LIGHT POWERED BY BATTERY PACK M1673 OPS CHECKED NORMAL.SDR SWAA2025112037079Battery Pack · inoperativeRIGHT ENTRY DOOR INTERIOR AND EXTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. R & R THE BATTERY PACK AT M2816 POSITION PER AMM 33-51-06.SDR SWAA2025112037101Glowstrip · peelingPHOTO ILLUMINESCENT STRIP AT 12DEF PEELING UP. SECURED THE PHOTOLUMINESCENT STRIP AT 12DEF REF AMM 33-51-15.SDR SWAA2025112037108Seal · crackedLEFT HORIZONTAL STABILIZER FWD UPPER SLIDING SEAL CRACKED ALONG FWD TRACK EDGE APPROX 2 INCH IN LENGTH. REMOVED AND REPLACED CRACKED LEFT FWD UPPER HORIZONTAL STABILIZER SLIDING SEAL IAW AMM 53-31-31.SDR SWAA2025112037109Seal · crackedRIGHT HORIZONTAL STABILIZER FWD UPPER SLIDING SEAL CRACKED ALONG FWD TRACK EDGE APPROX 4.5 INCH IN LENGTH. R & R RT HORIZONTAL STAB FWD UPPER SLIDING SEAL. IAW AMM 53-31-31.SDR GTIA2025112039187Megaphone · inoperativeFWD MEGAPHONE INOPERATIVE. REPLACED FWD MEGAPHONE IAW AMM 25-63-00, OPS CHECKED GOOD.SDR JR2R20251120421Splice · corrodedAFT WET AREA, GUSSET/SPLICE AT FR90, BL0, IS CORRODED OUT OF LIMITS. REPLACEDSDR ABXA20251120304Adc · inoperativeDURING CRUISE, LEFT ADC BECAME INOPERATIVE. FOLLOWED QRH, CA SWITCHED TO ADC ALT REMAINDER OF FLIGHT OK. AIRCRAFT DIVERTED TO MIA DUE TO RVSM RESTRICTIONS AND THERE WAS NOT ENOUGH FUEL TO GET TO CVG AT THE LOWER ALTITUDE. LEFT AIR DATA COMPUTER REPLACED IAWSDR 2025FA0000775Crankcase · gougedDURING DISASSEMBLY OF THE ENGINE FOR OVERHAUL DAMAGE WAS FOUND ON THE LEFT CRANKCASE HALF AT EACH OF THE 4 THRU STUD CYLINDER PAD LOCATIONS. THE DAMAGE APPEARS TO BE A GOUGE DISPLACING SOME OF THE ALUMINUM CRANKCASE PAD DOWN INTO EACH OF THE THRU STUD BORE LOCSDR JJBA20251120094Floorbeam · crackedMID FLOOR SUPPORT AT FRAME 20 HAS CRACK. REMOVED AND REPLACED MID FLOOR ANGLE AND ATTACHED SUPPORT AT FR20.