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 4VAA202601270001Battery Pack · inoperativeDURING INSPECTION, THE EMERGENCY LIGHT BATTERY PACK 15LN FAILED A FUNCTIONAL CHECK. THE BATTERY PACK WAS REPLACED IN ACCORDANCE WITH THE SAAB AMM.SDR DALA2026012800650Battery Pack · inoperativeDURING SVC CHECK, FOUND EMERGENCY LIGHTS AT SEAT ROW 26ABC OUT. REMOVED & REPLACED BATTERY FOR LIGHTS AT SEAT ROW 26ABC IAW AMM 33-51. OPS CHECKED GOOD. (7664290)SDR DALA2026012800649Proximity Sensor · fodON TAKEOFF, DURING ROTATION RECEIVED LT AFT ENTRY DOOR MESSAGE. COMPLIED WITH QRH, PRESSURIZATION SEEMS NORMAL. FOUND DEBRIS NEAR PROX SENSORS CYCLED MULTIPLE TIMES NO CURRENT FAULTS T/S IAW FIM 52-71. (7654528)SDR DALA2026012800648Sensor · dirtyL2 DOOR SLIDE LIGHT DID NOT EXTINGUISH WHEN DISARMED. CLEANED SENSORS & TARGETS, OPS CHECKED IAW AMM 52-11. NO ISSUES NOTED. (7654634)SDR YENA2026012800075Fire Loop · faultedFLT # 123 JFK -LAX (ETOPS). "ENG #2 FIRE LOOP B FAULT ON CLIMB OUT. ( ENGINE FIRE DETECTION SYSTEMS 2) LOOP B ).; ACCOMPLISHED BITE TEST OF # 2 DDU IAW AMM 26-12-15. OPS CHK NORMAL. MCC NOTIFIED A/C OKAY FOR SVC.SDR YENA2026012800074Not Reported · not reportedFLT # 424 LAX-JFK (ETOPS)." CAT II INOP ( CATEGORY IIIB NOT AUTHORIZED ).;PFM CAT III LAND TEST IAW AMM 22-97-00. TEST PASSED. A/C RE-CERTIFIED TO CAT III STATUS. MDDR CLR, MX-4 UPDATED, PLACARD RMVD.SDR HNAA2026012800089Control Valve · faultedSPOILER FAIL AT FL320 WITH SPOILER INDICATING OPEN BUT VISUALLY CHECKED CLOSED, (SPEED BRAKE HANDLE IN CLOSED POSITION), CREW PERFORMED QRH AND PULLED CBS, MSG CLEARED ON LANDING) ACFT ARRIVED TO MX WITH SPOILER INBD FAIL CMC MSG. COMPLIED WITH RIM TASK 27SDR CALA2026012813408Light · detachedEMERGENCY EXIT LIGHT ASSY AT SEAT 22C NEAR AISLE, NEEDS TO BE RE SECURED. BROKEN OFF. ALL LIGHTS WITHIN TWO SEAT ROWS OF OVERWING EXIT DOORS & MID-CABIN EXIT DOORS MUST OPERATE NORMALLY. REMOVED AND REPLACED THE LIGHT ASSY. CHECKED GOOD.SDR CALA2026012813403Wire · brokenSEAT 41G TRIM PIECE FELL OFF WITH BROKEN WIRE. REPLACED THE LIGHT AND INSTALLED THE TRIM PIECE. THE LIGHT OPS CK GOOD IAW AIPC 33-51-05-16.SDR CALA2026012813402Unknown · odorFA REPORTED AN ELECTRICAL ODOR IN THE AFT GALLEY . PILOT IN COMMAND REPORTED. DEBRIEFED CREW, NO HISTORY NOTED & NO ODOR UPON ARRIVAL. COMPLETED DECISION TABLE, FIG 05-50-00-991-01200-A. PERFORMED INSPECTION OF RELATED AFT GALLEY EQUIP IAW TSM 05-50-00-81SDR AALA202601286585Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK RIGHT HAND WING UPPER SKIN TRAILING EDGE AT WING BL 273.30. ACCOMPLISHED REPAIR PER EA 370465B.SDR UATA2420127265305Floorbeam · collapsed- F15 WEB SAGGING UNDERFLOOR - REMOVED FRAME15 TOP CAP AND FABRICATED A NEW CAP FROM 2024 T351 ALUMINUM "T" ANGLE, 0.084 THICK, 38.5 INCHES LONG. STRAIGHTENED OUT THE WEB ON FRAME 15. FABRICATED A DOUBLER FROM 2024 T3, 0.032" THICK MEASURING 38.5" LONG X 3 1/4SDR UATA2420127265304Floorbeam · corrodedF16 TOP CAP CORRODED AT NUT PLATES. REMOVED FRAME 16 TOP CAP AND FABRICATED A NEW CAP FROM 2024 T351 ALUMINUM "T" ANGLE, 0.100 THICK. ETCHED AND ALODINED THE "T" ANGLE AND PRIMED WITH SUPER KOROPON EPOXY PRIMER. INSTALLED THE "T" ANGLE USING MS20470AD-4 AND MSSDR UATA2420127265303Floorbeam · buckledF12 BUCKLED UNDER FLOOR. F12 UNDERFLOOR T ANGLE CENTER CAP - REMOVED DAMAGED T ANGLE. FABRICATED NEW T ANGLE FROM 2024T3 .085" X 1 5/8" X 1" TO SAME SIZE, DESIGN, AND HOLE PATTERN AS PREVIOUSLY INSTALLED. FABRICATED REPAIR DOUBLER 4 1/2"X 39 1/2" ALL NEW PARTSSDR UATA2420127265302Floorbeam · corrodedF11 CAP CORRODED BETWEEN SEAT RAILS. FL 1 UNDERFLOOR T ANGLE CENTER CAP - REMOVED FRAME 11 CAP SPLICE SECTION. FABRICATED NEW CAP SPLICE SECTION FROM 2024T351 0.125" X 1 5/8" X 1" ALUMINUM TO SAME SIZE, DESIGN, AND HOLE PATERN AS PREVIOUSLY INSTALLED. PARTS WESDR UATA2026012765301Fitting · corrodedL F11 REAR UNDER FLOOR FITTING CORRODED BEYOND LIMITS, F11 & F6 UNDERFLOOR FITTING HAVE CORROSION AT NUT PLATES. F6 & F11 JUNCTION BAR FITTINGS FOUND CORRODED. JUNCTION BAR FITTINGS. REMOVED ALL JUNCTION BAR FITTINGS FROM F6 & F11. REMOVED CORROSION UNDER & ASDR UATA2420127265701Hinge Bracket · corrodedRT INBD. FLAP, THE OUTBD. PYLON AIRFRAME SIDE, BOTH OF THE HINGE PLATES HAVE PITTING CORROSION THAT IS BEYOND LIMITS. DRILLED BOTH HINGE PLATES AND THE INBD. AND OUTBD. PYLON SIDE SKINS OFF. FITTED AND INSTALLED NEW SIDE SKINS P/N 212-13202-05-1 (INBD.) AND P/SDR IXXA20260127001Frame · crackedNR 1 PYLON AFT TORQUE BOX OB VERTICAL FRAME CRACKED STA 285.45SDR IPXA2026012791803Warning Message · illuminatedEMERGENCY DECLARED, CABIN ALTITUDE WARNING EICAS ABOVE 100 MSL. ACFT AT FL 210, CABIN ALT 11500. WARNINGS OCCURRED WITH BOTH PACKS RUNNING. THIS ITEM WAS DEFERRED IAW MEL 21-31-1A, VERIFIED MANUAL OPERATION OF OUTFLOW VALVE.SDR IPXA2026012786411Warning Message · illuminatedLEFT FWD ENTRY DOOR EICAS MSG CLIMBING THROUGH 5000 FT. PRESSURIZATION REMAINED NORMAL. DEFERRED PER MEL 52-71-1-1ASDR IPXA2026012785488Power Supply · inoperativeDURING PDC, FOUND EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-51-07. OPS CHECK GOOD.SDR DALA2026012700631Sign · inoperativeR3 DOOR SIGN INOPERATIVE. R & R THE EXIT SIGN IAW AMM 33-51. OPS CHECKED NORMAL. (8449200)SDR DALA2026012700627Seat Track · corrodedSEAT TRACK, AFT CABIN FLOOR, -Y381, FRMS 75 - 79 UPPER SURFACE CORRODED. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421883)SDR DALA2026012700626Seat Track · corrodedSEAT TRACK, AFT CABIN FLOOR OTBD CORRODED, -YA, FR 75 - 76. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421874)SDR DALA2026012700625Seat Track · corrodedSEAT TRACK, AFT GALLEY FLOOR, FRS 80 - 82 -Y450 CORRODED. REPLACED THE SEAT TRACK BTWN FR 75-80 -Y450 IAW SRM 51-72-11-911-001. (1421858)SDR DALA2026012700624Seat Track · corrodedSEAT TRACK, AFT GALLEY, FRS 80 - 82, Y450 FOUND WITH CORROSION. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421830)SDR DALA2026012700623Seat Track · corrodedSEAT TRACK, RT AFT CABIN ADAPTER-LONGITUDINAL BEAM FOUND CORRODED, -YB1, FR 73-73.5. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421820)SDR DALA2026012700622Seat Track · corrodedSEAT TRACK, RT AFT CABIN ADAPTER LONGITUDINAL BEAM FOUND CORRODED, -YC1, FR 73-73.5. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421808)SDR DALA2026012700621Seat Track · corrodedSEAT TRACK, RT AFT CABIN ADAPTER CORRODED, -YB, FRS 71-73. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421787)SDR DALA2026012700620Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE CORRODED AT FR 49-50, -Y450. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421771)SDR DALA2026012700619Seat Track · corrodedRIGHT AFT CABIN SEAT TRACK, -YB1, CORRODED BTWN FRS 73.5 - 74. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421767)SDR DALA2026012700618Seat Track · corrodedMID GALLEY SEAT TRACK, FR 53.3, -Y450 CORRODED. REPLACED DAMAGED SEAT TRACK IAW SRM 51-72-11-911-001. (1421756)SDR DALA2026012700617Seat Track · corrodedAFT CABIN SEAT TRACK -YA FOUND WITH CORROSION AT FR 73-74. REPLACED AT -YA FR73-74 IAW SRM 51-72-11-911-001. (1421740)SDR DALA2026012700616Seat Track · corrodedSEAT TRACK -YB CORRODED, FR 73-74. REPLACED IAW SRM 51-72-11-911-001. (1421647)SDR DALA2026012700615Seat Track · corrodedSEAT TRACK, -YC1 FOUND CORRODED FR 73.5 - 74. REPLACED THE SEAT TRACK IAW SRM 51-72-11-911-001. (1421620)SDR DALA2026012700614Seat Track · corrodedSEAT TRACK AT YB, FR 73 FOUND CORRODED. REPLACED THE DAMAGED SEAT TRACK, YB, FR 73-74 IAW SRM 51-72-11-911-001. (1421603)SDR ABXA20260127029Oil Filter · faultedDURING TAXI OUT RIGHT OIL FILTER MSG APPEARED, ACFT RETURNED TO GATE (BTB) AND MTX GROUNDED ACFT. REMOVED AND REPLACED THE RT ENG OIL FILTER DIFFERENTIAL PRESSURE SWITCH AND SCAV ENGINE OIL FILTER IAW AMM 79-35-01, & 79-21-04. OPS CHECKED GOOD. ACFT RELEASSDR AALA202601272851Cylinder · 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 ABXA20260127028Stringer · corrodedCORROSION,FOUND UPPER AND LOWER SKIN PANEL, AND S-36R STRINGER, STA 1241 TO 1263 . THIS AIRCRAFT WAS RECEIVING A HARD LANDING INSPECTION IN CVG AND BULGED SKIN WAS FOUND AT STA 1253 ALONG S-36R. FURTHER INVESTIGATION REVEALED CORROSION BEYOND THE SRM LIMITS OSDR DALA2026012700611Cover · brokenEMERGENCY LIGHT COVER OVER 1L IS BROKEN. REPLACED LIGHT COVER OVER 1L DOOR PER AIRBUS 321 AMM 33-51. (LP 8567452)SDR UIEA2026012700017Oxygen Mask · unwanted deployDURING SECURE CHECKLIST, SUPERNUMERARY SWITCH INADVERTENTLY SELECTED. REPACKED SUPERNUMERARY O2 MASKS IAW AMM 35-23-17, VERIFIED SUPERNUMERARY O2 PRESSURE 1510 PSI AND SWITCH RESET IAW AMM 35-23-00/501 AND AMM 35-23-00/601.SDR 2026FA0000060Engine · faultedCONFIGURATION ERROR WAS DETECTED IN ESN V12188 (OPERATED BY BAW BRITISH AIRWAYS), THE FIRST STANDARD MOTOR RELEASED POST SB 72-0716. THIS WAS CERTIFIED ON MAY 12, 2025, BEEN INSTALLED A POST SB 72-0716 P/N FOR HPC STAGE 3 BLADE. THE INSTALLED P/N WAS 6C8403 (SSDR SWIA2026012676040Plate · scratchedRIGHT TAT CUTOUT HAS MULTIPLE SCRATCHES AT FS280.00 BETWEEN STGR11R AND STGR12R (C-CHECK RO 05/22/2026)INSTALLED REPLACEMENT TAT PROBE MOUNTING PLATE IN REF WITH CRJ900 SRM 51-42-06-001-001-A01 AND DWG CC670-33015 REV. G. COMPLIED WITH TASK CARD 51-900-1002-SDR DALA2026042002476Spar Web · crackedSPAR WEB CRACKED. PERFORMED CSVE INSPECTION, SPAR WEB DAMAGE REPAIRED, REF. ERA 632073-14 REV. ORG (OUTBOARD FLAP WAS FOUND WITH CRACK DAMAGE TO THE FORWARD SPAR WEB AND FOUR (4) ELONGATED FASTENER HOLES IN THE CARRIAGE FITTING, FORWARD SPAR, WEB, AND RIB ATSDR SWIA2026012675610Latch Catch · crackedPOSSIBLE CRACK ON LEFT TRU LANDING AFT LATCH CATCH. REMOVED AND REPLACED LEFT TRU LANDING. REF. SRM 51-42-06-001-001-A01, REO 670-53-11-2268 REV.- AND DWG CC670-33040 REV. -G SHEET 2.SDR VNAA20260329036Rib · crackedCRACK ON RIB OF LEADING EDGE STA WS 58.00 AT RT WING. RIB OF LEADING EDGE STA WS 58.00 AT RT WING WAS REPAIRED PER REO 690-57-41-240 REV-.SDR VNAA20260329026Seat Track · corrodedCORROSION FOUND ON LH SIDE SEAT RAILS. SEVERAL CORROSIONS AND WEAR FOUND FROM FS669.4 TO FS977. CORROSION AND WEAR FOUND ON LH SIDE SEAT RAILS FROM FS669.4 TO FS977.00 WAS EVALUATED OUT OF LIMITS PER CRJ-900 SRM 53-41-49-101-001-A02, SRM 53-51-49-101-001-A02SDR VNA2026F00006Rib · crackedCRACK ON RIB OF LEADING EDGE STA WS 58.00 AT LH WING. RIB OF LEADING EDGE STA WS 58.00 AT LH WING WAS REPAIRED PER REO 690-57-41-240 REV. - -.SDR VNAA20260304015Seat Track · corrodedCORROSION ON SIDE SEAT TRACK LT FOUR AREAS, RT 4 AREAS. BTW BS 379 AND 669, S15L ANDS15R. REPLACED IAW AMM 53-00-49-400-801-A12.SDR VNAA20260304014Seat Track · corrodedCORROSION ON SIDE SEAT TRACK LT, 6 AREAS, RT 6 AREAS, BTW BS 669.40 AND 977 S15L & S15R. THE SEAT TRACKS WERE CLEANED IAW SRM 51-26-00-001-001-A01, AND DUE TO EXCESSIVE DAMAGE, REPLACED IAW SRM 53-41-49-101-001-A02, SRM 53-51-49-101-001-A02, & AMM 53-00-49-