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 N6WA2026013002Smoke Detector · defectiveAFT LAV SMOKE DET WARNING IN FLIGHT. REMOVE AND REPLACED SMOKE DETECTOR ASSEMBLY IAW CRJ AMM 26-16-01. PERFORMED OPS CHECK IAW CRJ AMM 26-16-00. OPS CHECK GOOD.SDR N6WA2026013001Light · broken1 CD EMERGENCY LIGHT ASSY BROKEN. R & R THE EMERGENCY LIGHT AT 1CD IAW AMM 33-51-05.SDR SCNA20260130047Light Sys · no testFWD ESCAPE SLIDE LIGHTS L730 (RT) & L731 (LT) FAILED TO ILLUMINATE ON TEST.SDR CALA2026013013454Oven · dirtyPERFORM CONDITIONAL INSP IAW AMM TASK 05-51-58-800-801-C3, ACCOMPLISHED CONDITIONAL INSPECTION IAW AMM 05-51-58-800-801-C3. NO SIGNS OF ARCHING OR BURNING. UPON FURTHER VISUAL AND OPS INSPECTION, FOUND OIL ON BOTTOM INTERIOR OF OVEN AND ON HEATING ELEMENT OFSDR CALA2026013013452Floor Support · crackedMAIN CABIN FLOOR SUPPORT BETWEEN BS 344 & 360 CRACKED ON UPPER ATTACH FLANGE AT APPROX BL 0. R & R THE FLOOR SUPPORT IAW SRM 51-40-02, & DWG 141A5400, REV -.SDR CALA2026013013450Light · damagedEMERGENCY LIGHT, SEAT 10F UNSECURE IN ISLE FURNITURE. CONFIRMED LIGHT ASSY DAMAGED. REPLACED THE EMERGENCY LIGHT IAW DMC-B787-A-33-51-06-00A-520A-A, & DMC-B787-A-33-51-06-00A-720A-A. TESTED OK. ITEM GOOD FOR SERVICE.SDR CALA2026013013448Water Line · burstPOTABLE WATER LINE BURST IN THE AFT CARGO BAY, AFT BULKHEAD. LINE CONNECTS TO POTABLE WATER TANK. FLOOR PANELS REMOVED IAW AMM 25-52-10-000-801, OZONE WATER CART LIQUID SPILL DETERMINED TO BE NON-HAZARDOUS IAW EC/RA 2011-01000, AFFECTED SPILL AREA BS 727+4 - SDR CALA2026013013446Light · damagedFWD LEFT COAT CLOSET (G-7) EMERGENCY EXIT LIGHT DAMAGED AND REMOVED. DWG 3350DD15107, REPLACED THE EMERGENCY LIGHT ASSY ON LT CLOSET DOOR 1L BY SEAT ROW 1B IAW MM33-51-14-960-802, OPS NORMAL.SDR CALA2026013013444Light · damagedEMERGENCY LIGHT SEAT 10F. NOT SECURED IN POLARIS ISLE FURNITURE. CONFIRMED LIGHT ASSY DAMAGED. REPLACED PROXIMITY EMERGENCY LIGHT IAW DMC-B787-A-33-51-06-00A-520A-A/DMC-B787-A-33-51-06-00A-720A-A TEST OK. ITEM GOOD FOR SERVICE.SDR CALA2026013013443Manifold · leakingFA CREW REPORTED STRONG FUEL ODOR ONBOARD AIRCRAFT. FOUND PRIMARY MANIFOLD ASSY LEAKING AT FUEL NOZZLE AT 3 O`CLOCK POS ACFT RT FACING FORWARD. R & R PRIMARY FUEL MANIFOLD IAW AMM 49-31-16, OPS & LEAK CHKD GOOD.SDR CALA2026013013442Unknown · odorODOR OF FUEL AND RUBBER BURNING BEFORE AND AFTER ENGINE START, CONFIGURED AIRCRAFT FOR FLIGHT, CONFIGURATION WITH ALL DOORS CLOSED, ALL PUMPS ON FOR OVER 30MIN, NO ABNORMAL ODORS NOTED, PERFORMED OUTSIDE VISUAL INSPECTION, NO FAULTS NOTED. COULD NOT DUPLICATSDR QMLA012920007Unknown · vibrationACFT LAUNCHED FROM BASE, 13 MIN FLT WAS UNEVENTFUL, GW WAS 2754 & POWER WAS NORMAL. WHEN LIFTING FROM LOW ROOFTOP PAD, ACFT REQUIRED MORE TORQUE THAN EXPECTED TO HOGE, ASSUMPTION WAS HIGHER THAN EXPECTED WEIGHT BUT POST FLT DETAILED ANALYSIS: GW WAS 2778, OATSDR SWAA2026012965699Battery · inoperativeFOUND AFT GALLEY FLIGHT ATTENDANT FLASH LIGHT LED INDICATOR FLASHING RED. INSTALLED A NEW BATTERY ON AFT GALLEY FLIGTH ATTENDANT FLASH LIGHT. OPS CHECKED GOOD. INSTALLED NEW PLACARD IAW AMM 25-64-00.SDR SWAA2026012965618Battery · inoperativeFWD AND AFT GALLEYS EMERGENCY FLASHLIGHTS REQUIRES REPLACEMENT. REPLACED FWD AND AFT GALLEY EMERGENCY FLASHLIGHT BATTERIES AND PLACARDS IAW AMM 25-64-00.SDR SWAA2026012965760Battery · inoperativeAFT GALLEY EMERGENCY FLASHLIGHT HAS A STEADY RED LIGHT INDICATOR. REMOVED & REPLACED AFT GALLEY EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2026012965757Lamp · burned outCAPTAIN`S MASTER CAUTION LIGHT BURNED OUT. REMOVED AND REPLACED THE LAMP IAW AMM 33-11-00.SDR SWAA2026012965750Lamp · damagedFWD ENTRY EMERGENCY EXIT LENS HOUSING & LAMP ASSY FOUND DAMAGED. REMOVED & REPLACED IAW AMM 33-51-01-960-802-NG. OPS TESTED GOOD.SDR SWAA2026012965438Battery Pack · no testLEFT FWD EMERGENCY LIGHTING BATTERY PACK FAILED A CAPACITY CHECK. REMOVED & REPLACED THE BATTERY PACK IAW MM 33-51-06.SDR SWAA2026012965431Battery Pack · no testLEFT AFT EMERGENCY LIGHTING BATTERY PACK FAILED A CAPACITY CHECK. REMOVED & REPLACED THE BATTERY PACK IAW MM 33-51-06.SDR SWAA2026012965430Battery Pack · no testEMERGENCY LIGHTING BATTERY PACK AT RT OVERWING EXIT FAILED A CAPACITY CHECK. REMOVED & REPLACED THE BATTERY PACK IAW MM 33-51-06.SDR SWAA2026012965680Battery Pack · inoperativeAFT ENTRY EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED & REPLACED THE BATTERY PACK M1673 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026012965444Skin · delaminatedRIGHT WING T/E INBD MAIN FLAP DELAMINATED AT THE LOWER TRAILING OTBD EDGE AT APPROXIMATELY WBL 200. ZONE 3. L=9.3 W=7.2.SDR 4VAA202601290002Battery Pack · inoperativeDURING INSPECTION, THE EMERGENCY LIGHT BATTERY PACK 11LN FAILED A FUNCTIONAL CHECK. THE BATTERY PACK WAS REPLACED IN ACCORDANCE WITH THE SAAB AMM.SDR JR2R20260129774Doubler · crackedATG-4 AFT ANTENNA DOUBLER HAS A 4 INCH CRACK. NDT VERIFIED. REPAIRED SKIN.SDR IPXA2026012925317Window · crackedLT FWD WINDOW CRACKED. REMOVED AND REPLACED L1 WINDOW IAW B757 AMM 56-11-01 OPS AND LK CHECKS GOOD AT THIS TIME. PERFORMED RII OF L1 WINDSHIELD ELECTRICAL CONNECTION INSTALL AND TORQUE PER GMM 04-02.SDR IPXA2026012925306Element · burnedLEFT FWD WINDOW LOWER ELEMENT BURN OUT DURING FLIGHT. REPLACEED THE L1 WINDSHIELD. ALSO REPLACED M191 HEAT CONTROL UNIT PRECAUTIONARY PER AMM 30-41-01-004-001. OPS CHECK GOOD. REF BARCODE T3F18E0086B65 FOR RII SIGNOFF OF L1 WINDSHIELD REPLACEMENT.SDR ABXA20260129035Start Valve · faultedON TAXI OUT, LEFT ENGINE EICAS LEFT ENGINE START AND OVERHEAD VALVE LIGHT ILLUMINATED DURING START. ACFT RETURNED TO BLOCKS (BTB). CYCLED START VALVE AND ACCOMPLISHED NR 1 ENGINE START IAW AMM 71-00-00, NO FAULTS NOTED DURING ENGINE START A/C REMAINS NO ETOSDR FDEA202601290098Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 242VFF HAS PUNCTURE DAMAGE. FABRICATED NEW FLOOR PANEL 242VFF, MPN: 145T5874-32, RBL 84.25 - RBL 74.25, STA 984.95-1087 IAW DWG 145T5874-32, AND SR67-53-009. PERFORMED. MAJOR REPAIR.SDR DALA2026012900712Door · fodR4 DOOR SHOWING OPEN. CYCLED DOOR, FOUND FOD. REMOVED FOD, ALL OPS NML PER A330 AMM 52-13. (8449220)SDR YENA2026012900088None · noneFLT 1642/(803), BZE-JFK (JFK-JFK). AFTER SECOND ENG START & SHUTTING DOWN APU. AFT FA CALLED REPORTING THE STRONG ODOR OF FUEL. AFTER 3-5MIN IT WAS STILL PRESENT BUT DISSIPATING. COMPLIED WITH INFORMATION NOTICE 2017-T015,STEP9.ISOLATED FAULT TYPE 10 EXTERNSDR K11A2026012900367Pump · power lossWITH PUMPS ON, FUEL PUMPS TO CENTER TANK LOST OF ELECTRICAL POWER ON CLIMB OUT. PERFORMED AC GENERATION SYSTEM TEST IAW AMM 24-21-00. OPS CHECK PASS WITH NO DEFECTS NOTED. REF BLOCK 2 OF LP 737-004-1877 FOR CENTER TANK FUEL QUANTITY INDICATION ERROR. CENTER TSDR 2026FA0000065Pump · faultyELECTRICAL FUEL BOOST PUMP BYPASS VALVE FAILED IN BYPASS PREVENTING FUEL FROM REACHING ENGINE PREVENTING ENGINE FROM START. PUMP FAILED AFTER 20 MONTHS IN SERVICE. FAILED WITHOUT WARNING OR INDICATION.SDR 2026FA0000064Magneto · failedSLICK MAGNETO (MODEL NR 6350 S/N 15087263) FOLLOWER ARM OF CONTACTOR POINTS BROKE AFTER 76 HOURS SINCE NEW. THE BREAK OCCURRED AT THE BEND ON THE SIDE OF THE SPRINGY METAL FOLLOW ARM. THIS CAUSED THE MAGNETO TO FAIL (DEAD MAG) DURING BEFORE TAKEOFF MAGNETO CHSDR HVUA202605120811Outflow Valve · fodNEARING TOP OF CLIMB THE CABIN CONTINUED A SHALLOW CLIMB PAST THE SCHEDULED CABIN ALTITUDE. IN RESPONSE THE PILOT DONNED HIS OXYGEN MASK AND INSTRUCTED PASSENGERS TO DO THE SAME WHILE HE EXECUTED A NORMAL DESCENT. AN EMERGENCY DESCENT WAS NOT PERFORMED. THE MASDR SWIA2026012875893Floor Support · corrodedFOUND MULTIPLE SPOTS OF CORROSION ON RH PRESSURE FLOOR SILL FROM FS 409.00+128 TO FS 559. BLENDED CORROSION ON THE RH PRESSURE FLOOR SILL ASSY APPROX RBL 36.00 - RBL 42.00 AND BETWEEN FS409.00 +128 AND FS559.00 WITH REFERENCE TO SRM 51-21-06. PERFORMED UT RESDR SWIA2026012875881Floor Support · corrodedFOUND MULTIPLE SPOTS OF CORROSION ON LT PRESSURE FLOOR SUPPORT FROM BS 409+128 - 559. BLENDED CORROSION ON THE LT PRESSURE FLOOR SUPPORT ASSY APPROX LBL 36 - 42 AND BTWN BS 409 +128 & 559 IAW SRM 51-21-06. PERFORMED UT REMAINING THICKNESS MEASUREMENT IAW NDSDR SWIA2026012875774Skin · crackedFOUND CRACKED ON SKIN, HYDRAULIC BAY AT 193.00 SKIN. REMOVED AND REPLACED HYD. BAY AT FS193.00 SKIN. REF. REF. REO 690-53-11-2152 REV. -- . C/W SKYWEST TASK CARD 51-900-1002-SKY STRUCTURAL MAJOR REPAIRMAJOR REPAIR C/PAINT DEFERRED TO SKYWEST AFTER REPAIRS ANSDR SWIA2026012875745Frame · corrodedFWD FACE FRAME AT BS 280 APPROXIMATELY BETWEEN STGR 25L TO 24L HAS CORROSION. REPAIRED FWD FACE FRAME AT FS280 APPROXIMATELY BETWEEN STGR 25L TO 24L PER REO 601R-53-21-3787 REV.-. COMPLIED WITH SKYWEST TASK CARD 51-900-1003.SDR SWIA2026012875732Yoke · gougedORDERED AND RECEIVED RT ENGINE FWD MOUNT YOKE 601370158, S/N ) WITH GOUGES. RECEIVED REO 601R-71-21-082 REV -- DATE 2026-02-23. COMPLIED WITH REO 601R-71-21-082 REV -- DATE 2026-02-23 STEP 1-5. ENSURED BLEND-OUT WAS PERFORMED IAW GENERIC REO 601R-71-21-005 REVSDR SWIA2026012875716Bracket · corrodedSERVICE DOOR INNER STRUCTURE, LOWER FRAME SPLICE BRACKET IS CORRODED. REMOVED AND REPLACED SERVICE DOOR INNER STRUCTURE LOWER FRAME SPLICE BRACKET IAW CRJ 200 SRM 51-42-06 COMPLETED TASK CARD 51-900-1003-SKY.SDR VNAA20260329025Stringer · corrodedCORROSION ON STRINGER 27 AT FS 297 AT AVIONICS COMPARTMENT. STRINGER 27 AT FS 297 AT AVIONICS COMPARTMENT WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR VNAA20260329016Skin · dentedDENTS FOUND ON FUSELAGE SKIN UNDER RH VENTRAL FIN AT FS 1083, FS 1088, FS 1093, AND FS 1095. DENTS ON FUSELAGE SKIN UNDER RH VENTRAL FIN BTW FS1069.75 AND 1162.00 AND STR20R-STR23R WERE REPAIRED PER REO 670-51-00-085 REV. -A, REO 690-53-61-1745 REV. -- AND RESDR VNAA20260329015Skin · corrodedFIVE DENTS FOUND ON FUSELAGE SKIN UNDER VENTRAL FIN AT FS 1082, FS1085, FS 1087, FS1130 AND FS 1179. DENTS ON FUSELAGE SKIN UNDER VENTRAL FIN AT FS 1082.00, FS1085.00, FS 1087.00, FS1130.00 AND FS 1179.00 WERE REPAIRED PER REO 670-51-00-085 REV. -A, REO 690-5SDR VNAA20260329014Floorbeam · corrodedCORROSION WAS FOUND ON CROSSBEAM STA FS=280 LBL 11 AT PASSENGER CABIN. CROSSBEAM STA FS=280 LBL 11 AT PASSENGER CABIN WAS REPAIRED PER REO 690-53-11-2139 REV.--SDR SWIA2026030475411Seat Track · corrodedRIGHT LOWER SEAT TRACK CORRODED ON CROWN AT 7 LOCATIONS BTWN FR 76- 84. REMOVED AND REPLACED THE SEAT TRACK BTWN FR 76-84 IAW SRM 51-40-08.SDR SWIA2026030475410Seat Track · corrodedLEFT LOWER SEAT TRACK CORRODED ON CROWN AT 4 LOCATIONS BETWEEN FR 76 - 82. REMOVED AND REPLACED THE SEAT TRACK, BTWN FR 72-84 Y-10.5" IAW SRM 51-40-08.SDR VNAA20260304026Skin · dentedSEVERAL DENTS ON THE SKIN OF ALONG THE SETTLEMENT AREA VENTRAL FIN LT & RT. THE SKIN WAS REPAIRED IAW REO 670-51-00-085, REV A, REO 690-53-71-104, REV-, REO 690-53-61-1737, REV -, AND REO 690-53-61-1738 REV -.SDR VNAA20260304024Seat Track · corrodedSEAT TRACK CORRODED BS 597 TO 677. REPLACED IAW AMM 53-00-49.SDR ASAA2026012864653Rib · crackedRIGHT HAND HORIZONTAL STABILIZER HAS FOUR CRACKED INSPARS AT STA 92.70. GROUNDED - YES. REPAIRED RIB INSPAR STA 92.70 IAW BOEING 737-800 SRM 55-10-09-02-5 REPAIR 5 & 55-10-09-02-4 REPAIR 4.SDR SWAA2026030365538Scuff Plate · crackedCRACKED SCUFF PLATE IN THE FWD CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1.