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 DALA2026012700601Cusp Web · crackedCRACKED LOWER SURFACE OF LT CUSP WEB, BS 258 - 814. REPAIRED IAW SRM 53-00-55. (1413152)SDR CALA2026012713357Skin · corrodedFOUND RT FWD LOWER SKIN CORRODED AT WING ROOT. PERFORMED REPAIR IAW ECRA 5731-01759, PART 1 ON WCS FWD LWR SKIN PANEL AT BS 54 AT RBL 57,SDR CALA2026012713320Stringer · crackedLEFT WING INTERNAL FUEL TANK UPPER STRINGER U-9 CRACKED BETWEEN RIB 16 AND RIB 17. ACCOMPLISHED PERMANENT REPAIR IAW ECRA 5720-03602 AND REO-G25734.SDR ASAA2026012163913Battery Pack · no testRIGHT OVERWING EMERGENCY LIGHT FAIL CAPACITY CHECKS RXR430X. GROUNDED - YES. REMOVED AND INSTALLED NEW BATTERY PACK IAW AMM 33-51-06-960-802, PERFORMED OPS CHECKED GOOD.SDR SWAA2026012663398Cover · detachedAISLE CEILING EXIT SIGN COVER BETWEEN OVERWING EXIT ROWS, DETACHED. INSTALLED THE COVER IAW AMM 33-51-01.SDR YENA2026012600071Unknown · fumesFLT 1897, BOS-LIR. DURING DESCENT AT 5500 FT F1 CALLED AND DECLARED A MODERATE FUME EVENT WAS OCCURING. WITH ONLY 5 MIN LEFT IN FLIGHT CREW WAS UNABLE TO RUN ODOR ISOLATION CHKLIST. COMPLIED WITH INFORMATION NOTICE 2017-T015. STEPS 1 & 2, IDENTIFIED ODOR TSDR DALA2026012600590Wire · not seatedVALANCE MOUNTED EMERGENCY AISLE LIGHT ABOVE ROW 30ABC INOPERATIVE. RESEATED WIRE SPLICE SM6, IAW WDM 33-51-11. PIN 22 RECEIVING A/C VOLTAGE. INSTALLED NEW BATTERY PACK, IAW AMM 33-51. PERFORMED EMERGENCY LIGHT TEST AND BATTERY CAPACITY CHECK IAW AMM 33-51. ALSDR 2026FA0000055Meter · inoperativeHOBBS METER STOP WORKING.SDR JJBA20260126070Angle · crackedRF 1, CARGO ENTRANCE SUPPORT ANGLE ON POST AT FR 66 AND BTW STR 15L-16L FOUND CRACKED. CARGO ENTRANCE SUPPORT ANGLE ON POST AT FR 66 AND BTW STR 15L-16L REPLACEDSDR JJBA20260126068Bracket · brokenON LEFT PACK VALVE REMOVAL, VALVES POSITION BRACKET FOUND BROKEN. ON LEFT PACK VALVE REMOVAL, VALVES POSITION BRACKET REMOVED AND REPLACEDSDR QMLA2026012420004Elec Connector · disconnectedVERY LOW HEAT IN CABIN & COCKPIT CAUSING MED CREW TO CANCEL PATIENT TRANSPORT. FOUND DISCONNECTED ELECTRICAL CONNECTOR ON HEATING MIXER UNIT.SDR DALA2026012300532A/C Pack · odor(LOG 8525992) NR 1 PACK MADE A HUMMING SOUND & SMELL AND ELECT ODOR. NR 1 PACK LIGHT ILLUMINATED. REMOVED AND REPLACED LT PACK ACM IAW AMM 21-51. OPS CHKD GOOD.SDR SWAA2026012363762Girt Bar · lack of lubeF/AS REPORT THAT FWD GIRT BAR IS DIFFICULT TO ARM. LUBED GIRT BAR BRACKETS FWD SERVICE IAW S.I.P. OPS CHECKS GOOD IAW M/M 25-66-02.SDR QXEA2026012300014Warning Message · illuminatedFLIGHT 2154. CABIN HIGH EICAS WARNING MESSAGE ABOVE 10,500. CREW MASKS WHERE DONED PASSENGER MASKS DID NOT DEPLOY. STOPPED CLIMB AND STARTED DESCENT. DECLARED EMERGENCY. LANDING UNEVENTFUL. LANDED BELOW MAX LANDING WEIGHT. MESSGE EXTNGUISHED BELOW 9800'. REMOSDR P5CA2026012300014Stringer · crackedCRACK DAMAGE ON THE STRINGER S-5L, AT AFT SIDE OF STA 2360.(<P>1. REMOVED AFFECTED FASTENERS TO GET ACCESS IAW SRM 51-40-02-0G-0 REV 47. 2. REPAIR DAMAGE AREA IAW EI NO: T2026A53M-033 REV 1. 3. INSTALLED FASTENERS IAW SRM 51-40-02-0G-0 REV 47 AND DWG NO: 148U2SDR ABXA20260121025Flap System · malfunctionedON SHORT FINAL APPROACH, RECIEVED A TE FLAP ASYM CAUTION MSG SHORTLY AFTER SELECTING FLAPS 30 FOR LANDING. A/C WENT AROUND, INFORMED ATC THAT THEY HAD A FLIGHT CONTROL ISSUE, ACCOMPLISHED THE QRH, AND THEN INFORMED ATC THAT THEY COULD CONTINUE THE APPROACH ANDSDR CALA2026012313234Panel · damagedDURING WALK AROUND, FOUND PANEL ON RT WINGLET MISSING PARTS, PSDR CALA2026012313199Channel · corrodedFWD CARGO BAY, RT ZEE CHANNEL BTW BS 500 AND 500I HAD CORROSION. REPAIRED THE ZEE CHANNEL IAW SRM 53-00-53--2R-6, SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, SRM 51-20-01-0G-0, SRM 51-10-02-0G-0, AMM 20-60-07-913-801, & SOPM 20-41-02.SDR CALA2026012313197Channel · crackedAFT CARGO BAY, LT ZEE CHANNEL POSSIBLE COROSION AND CRACK BTW BS 727B AND 727J. R & R THE LT ZEE CHANNEL BTW BS 727B AND 727J IAW SRM 53-00-53-2R-6, AMM 20-60-07-9913-801, SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, SRM 51-20-01-0G-0, AMM 51-21-SDR CALA2026012313195Frame · deformedAFT CARGO COMPARTMENT STA 1320 RBL 35, FRAM HAS ONE DENT. COMPLIED WITH ECRA 5360-02095 AND VTMAE EA 757-5360-13-A4247 RE V. ACCOMPLSIHED FRAME REPAIR BS 1320 RBL 35.SDR CALA2026012313186Indication Sys · malfunctionedDOOR 4L FLASHES FOR 30-45 SECS AFTER DISARMI NG REPEAT GRIPE COULD NOT DUPLICATE FAULT. CYCLED MULTIPLE TIMES FROM ARM TO DISARM. PERFORMED OPS CHECK IN REFERENCE TO DMC-B787-A-52-11-00-03A-320A-A. OPS CHECK GOOD. NO FAULTS NOTEDSDR CALA2026012313185Mechanism · lack of lubeDOOR 1L ARMING INDICATOR FLASHING LUBED GIRT BAR ARMIN MECHANISM, REF AMM 12-21-20-00A-200A-A, AND 787-52-0013. OPS NORMAL. DMC-B787-A-52-11-00-02A-110A-A.SDR CALA2026012313183Light · malfunctionedLIGHT ON 21F. ALL OTHER INDICATIONS NORMAL. LIGHT IN QUESTION IS 25F SIDEWALL LIGHT, NOT EMERGENCY LIGHT. CYCLED CB FOR RT SIDEWALL LIGHTS. SIDEWALL AND EMERGENCY LIGHT OPERATION NORMAL AND AS COMMANDEDSDR CALA2026012313182Switch · out of positionEMERGENCY LIGHTS ADVISORY FLIGHT DECK EMERGENCY LIGHT SWITCH IS NOT IN THE ARMED POSITION, OR SWITCH IS IN ARMED POSITION AND FLIGHT ATTENDANT EMERGENCY L IGHT SWITCH SELECTED ON, OR THE SYSTEM CONTROLS ARE IN THE ARMED STATE AND THE 115 VAC TO AT LEAST ONE OFSDR CALA2026012313181Elec Connector · disconnectedEMERGENCY LIGHT AT SEAT 23 C INOP FOUND CONNECTOR FOR EMERGENCY LIGHT DISCONNECTED, RECONNECTED CONNECTOR AND PREFORMED OPS CHECK OF EMERGENCY LIGHTS REF AMM 33-51-00. OPS CHECK GOODSDR DXTA2026012306620Uplock Switch · faultyABOUT 10 MINUTES IN TO CRUSE AT FL410 WE FELT A SMALL THUMP AND THE GEAR UNLOCK LIGHT CAME ON. IT REMAINED ON ALL THROUGH CRUSE. WHILE AT CRUSE FELT LIGHT FLUTTER IN RUDDER PEDALS. IN THE DESCET WHILE DESCENDING THROUGH FL280 WE FELT ANOTHER THUMP AND THE UNLOSDR DXTA2026012306625Battery · faultedUPON TAXI DEPARTING MMU FBO WE NOTICED THAT THE EMERGENCY LIGHTS WERE STILL ON AS THE EMER LT SWITCH WAS PLACED IN ARM. WHEN REACHING THE RUN-UP PAD AT MMU THE EMERGENCY LIGHTS BEGAN STROBING CORRECTIVE ACTION: REMOVED AND REPLACED NO.1 & 2 EMERGENCY BATTERIESSDR DXTA2026012306627Unknown · odorDURING DESCENT THROUGH CLOUD LAYERS, ESTIMATING THROUGH 10,000 WITH ANTI-ICE ON FULL, SMELT STRONG CHEMICAL/ELECTRICAL FUMES IN THE CABIN. SMELL CLEARED AFTER TURNING OFF ANTI-ICE. COMPLIED WITH ENVIRONMENTAL CONTROL SYSTEM BLEED DUCT BURN PROCEDURE TASK CASDR DXTA2026012306629Brake · damagedUPON TAXI IN AND SHUT DOWN, LEFT MLG WAS SMOKING. NO HEAVY BRAKES WERE USED FOR LANDING OR TAXI. REMOVED THE LH IB BRAKE ASSY PN 9914655-3 SN D0815 AND INSTALLED AN OVERHAULED BRAKE ASSY PN 9914655-3 SN 0576A. REF: MODEL 680A MAINTENANCE MANUAL (REV 23) 32-4SDR BAGA2026012200001Spinner · leakingCABIN ODOR - RIGHT ENGINE SPINNER COVERED IN OIL, OIL SPLATTER IN COWLING. OIL SMELL IN FLIGHT DECK AND CABIN ON DESCENT AROUND 10K FEET. COMPLIED WITH FIM TASKS IN REFERENCE TO A220 AMM 71-00-00. FOUND NO OIL LEAK, FLUID FOUND TO BE DE-ICING FLUID. NO SMELL SDR SWIA2026012175094Spar · damagedRIGHT WINGLET CLOSING SPAR TIP DAMAGED AND REQUIRES REPLACEMENT. DAMAGE CONSIDERED MAJOR REPAIR PER GMM 3-26. REPLACED RH WINGLET CLOSING SPAR TIP LENSE IN REFERENCE TO SRM 51-42-21 AND 51-42-22SDR DALA2026012200512Frame · damagedFRAME 62, FWD SIDE. TOOLING DAMAGE AT STR 4R. REPAIRED PER ERA 631753-14. (1413263)SDR DALA2026012200510Frame · bentFRAME 62, AFT SIDE. FRAME BENT/DAMAGED BETWEEN STR 2L AND 3L. REPAIRED PER ERA 631753-14. (1413438)SDR DALA2026012200509Frame · damagedFRAME 61, AFT SIDE. DOUBLE DRILLED HOLES IN WEB SHEAR TIE BETWEEN STR 1L AND 2R. REPLACED SHEAR TIE PER ERA 631753-14. (1413404)SDR DALA2026012200508Frame · damagedFRAME 61, AFT SIDE. 3 OPEN HOLES IN FRAME NOT DRILLED THROUGH WEB DOUBLER BETWEEN STR 1L AND 2R. REPLACED FRAME PER ERA 631753-14. (1413397)SDR DALA2026012200507Frame · damagedFRAME 61, AFT SIDE. INBD OF LT COUPLING, HOLE IN FRAME NOT DRILLED IN WEB SHEAR TIE. REPLACED SHEAR TIE PER ERA 631753-14. (1413325)SDR DALA2026012200506Stringer · damagedFRAME 64, AFT SIDE. STR 1L HAS TOOLING DAMAGE IN RADIUS. CORRECTIVE ACTION: REPAIRED PER ERA 631753-14. (1413314)SDR DALA2026012200505Stringer · bentSHIP 3361 FRAME 63, FWD SIDE. STR 2R BENT/DAMAGED. CORRECTIVE ACTION: REPAIRED PER ERA 631753-14. (1413262)SDR DALA2026012200504Stringer · damagedFRAME 62, FWD SIDE. TOOLING DAMAGE AT STR 3R. REPAIRED PER ERA 631753-14. (1413261)SDR DALA2026012200503Stringer · damagedFRAME 60, FWD SIDE, TOOLING DAMAGE INBD RADIUS ON STGR 2L. REPAIRED PER ERA 631753-14. (1413245)SDR DALA2026012200502Stringer · bentFRAME 60, FWD SIDE. STGR 2L BENT FWD OF FRAME. REPAIRED PER ERA 631753-14. (1413240)SDR HNAA2026012200071Controller · abnormalREJECTED TAKE OFF, DEPRESSURIZATION AUTO FAIL. R & R PRESSURIZATION DIGITAL CONTROLLER IAW EMB AMM 21-31-01, OPS CHECK GOOD IAW AMM 21-31-00-700-802-A AIRCRAFT OK FOR SERVICE .SDR ASAA2026012163001Light · detachedEMERGENCY EXIT LIGHT BY ROW 4 FALLING OFF. GROUNDED - YES. REMOVED & REPLACED EMERGENCY EXIT LIGHT. OPS CHECK GOOD. OK FOR SERVICE.SDR GTIA2026012239253A/C Pack · odorAT 6000 MSL ON APPROACH, FLAPS 1, 210 KTS., SMELLED A BITTER, ACID, OILY SMELL IN THE COCKPIT. TURNING OFF PACK 1 IMPROVED THE AIR QUALITY. F/A DID NOT SMELL ANYTHING ABNORMAL. DIFFERENTIAL PRESSURE 2.9 PSI -PER GMM 30.40 ODOR EVENT STAGE 1. APPLIED TSM 05-50SDR DXTA2026012206621Door · no discrepancyMAIN ENTRY DOOR WILL NOT OPEN. HANDLE EXTENDS, VENT DOOR OPENS BUT HANDLE WILL ONLY TURN PART WAY AND THEN STOPS. DOOR DOES NOT RELEASE TO OPEN. PERFORMED MED OPERATIONAL CHECKS NUMEROUS TIMES AND DOOR CHECKED SATISFACTORILY. POWERED UP AIRCRAFT AND VERIFSDR GTIA2026012239252Unknown · odorON DESCENT STRONG METALLIC SMELL-PERFORMED TSM 05-50-00-810-831-A. A(10)(A)2. TYPE 10 ODOR. NO HISTORY OR EVIDENT ODOR PRESENT. AC OK FOR SERVICE. MOC# 111830SDR IPXA2026012213913Starter · faultedDIVERTED RT STARTER CUTOUT (MOMENTARY) ENG FLUX OUT OF LIMITS SHUTDOWN AT FL370 DIVERT TO CYYT STATUS MSGS RENG REV POS, RENG CONTROL, R ENG EEC C1SDR IPXA2026012209313Lock · bindingCREW DOOR OPEN/CLOSING MECHANISM IS HARD TO OPERATE AND LOCK TO CLOSE POSITION. OPENSDR R61A2026011900014Seat Track · corrodedWHILE IN HEAVY CHECK - FOUND CORROSION ON RH INBOARD SEAT TRACK BEAM, FR 13-14.SDR AALA202601226755Accumulator · reads lowAIRCRAFT WAS NOT GROUNDED: R4 DOOR ACCUMULATOR REQUIRES SERVICING. MAINTENANCE SERVICED R4 DOOR ACCUMULATOR IAW AMM 52-10-00.