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 SWAA2026020662522Sidewall Support · corrodedCORROSION ON FWD CARGO BAY, LT AFT BODY TO SIDEWALL SUPPORT BS 492 - 500D, LBL 25, WL 156. DAMAGED FLOOR TO SIDEWALL SUPPORT FOUND OUT OF LIMITS. REMOVED AND INSTALLED A NEW FLOOR TO SIDEWALL SUPPORT BS 400 - 500D, LBL 25, WL 156 IAW SRM 51-40-02-0G-0, & DWSDR SWAA2026020662525Sidewall Support · corrodedCORROSION ON FWD CARGO BAY, RT AFT BODY TO SIDE WALL SUPPORT BS 492 - 500A, RBL 25, WL 156. REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 143A7500, REV -;SDR SWAA2026020662526Threshold Web · corrodedCORROSION ON FWD CARGO BAY SUB THRESHOLD WEB, BS 447 - 478, RBL 28.5, WL 156. REMOVED AND REPLACED THE THRESHOLD WEB IAW SRM 51-40-02-0G-0, AND DWG:143A8330, REV A.SDR SWAA2026020662524Attach Angle · crackedCRACKED FWD CARGO BAY AFT INTERCOSTAL ATTACH ANGLE AT AFT SIDE BS 500C, LBL 25, WL 154. REMOVED AND REPLACED THE ATTACH ANGLE IAW SRM 51-40-02-0G-0, AND DWG 143A7505, REV A..SDR SWAA2026020662528Baffle · crackedCRACK ON FCB UNDER LT AFT BODY TO SIDE WALL SUPPORT, BS 500C, LBL 25, WL 154. REMOVED AND REPLACED BAFFLE BS 500B - 500C, LBL 25, WL 154 IAW SRM 51-40-02-0G-0, AND DWG 143A7505, REV A..SDR SWAA2026020662529Threshold Web · corrodedCORROSION ON ACB SUB THRESHOLD WEB AT BS 795 - 846, RBL 18 - 28, WL 160. REMOVED AND REPLACED THE SUB THRESHOLD WEB IAW SRM 51-40-02-0G-0, AND DWG 146A8340, REV -.SDR SWAA2026020662530Sidewall Support · corrodedCORROSION ON ACB RT BODY TO SIDE WALL SUPPORT AT BS 752 - 787, RBL 22, WL 156. REMOVED AND REPLACED THE RT SHIELD FWD OF ACB BS 767 - 794, RBL 22, WL 156 IAW SRM 51-40-02-0G-0, AND DWG 146A0081, REV A.SDR SWAA2026020662531Sidewall Support · corrodedCORROSION ON ACB LT BODY TO SIDE WALL SUPPORT, BS 732 - 798, LBL 22, WL 158. REMOVED AND REPLACED ACB LT FLOOR TO SIDEWALL SUPPORT, BS 727 - 847, LBL22, WL 158 IAW SRM 51-40-02-0G-0, & DWG 146A7500, REV -.SDR SWAA2026020662533Support Angle · corrodedCORROSION ON AFT CARGO BAY BODY TO AFT BULKHEAD SUPPORT ANGLE, BS 947, LBL 9 - RBL 9, WL 179. REMOVED AND REPLACED ACB AFT BULKHEAD LOWER SUPPORT ANGLE BS 947, LBL 8 TO RBL 22, WL 179 IAW SRM 51-40-02-0G-0, DWG 146A7500, REV -, AND AIPC 53-11-51-01.SDR SWAA2026020662535Floorbeam · corrodedCORRODED CABIN FLOORBEAM AT BS 986.5, RBL 47, WL 208. REPAIRED IAW SRM 53-70-51-2R-6-A00995,REPAIR 6, SECTION 47.SDR SWAA2026020562696Crossbeam · crackedCRACKED CROSSBEAM ATTACH ANGLE IN THE PASSENGER CABIN, BS 540, LBL 2, WL 208. REMOVED AND REPLACED CROSSBEAM ANGLE, BS 540, LBL 1 - LBL 25, WL 208 IAW SRM 51-40-02-0G-0, AND DWG 143A0060, REV A.SDR SWAA2026020462697Crossbeam · crackedCRACKED CROSSBEAM TEE ANGLE IN THE PASSENGER CABIN, BS 540, LBL 27, WL 208. REMOVED AND REPLACED CROSSBEAM TEE ANGLE, BS 540, LBL 25 - LBL 45, WL 208 IAW SRM 51-40-02-0G-0, AND DWG 143A0060 REV A.SDR SWAA2026020462695Crossbeam · crackedCRACKED CROSSBEAM TEE ANGLE, BS 540, RBL 2, WL 208. REMOVED AND REPLACED THE FLOOR PANEL CROSSBEAM TEE ANGLE FROM BS 540; RBL 1 - RBL 25, WL 208 IAW SRM 51-40-02-0G-0 AND DWG 143A0060, REV A.SDR SWAA2026020462537Floorbeam · corrodedCORROSION ON ACB FLOORBEAM TEE ASSY AT BS 727D+6. REMOVED AND REPLACED ACB FLOORBEAM TEE ASSY IAW DWG 146A7500, REV- & SRM 51-40-02.SDR AALA202602041206Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202602043522Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR SWIA2026011875072Stay · faultedRECEIVED MLG DISAGREE MESSAGE AFTER TAKEOFF; RAN QRH, MLG SHOWING A DISAGREE OF LT MLG DURING RETRACTION PHASE, QRH CALL FOR CYCLING GEAR. MESSAGE CLEARED AFTER EXTENDING GEAR, SHOWING 3 GREEN IN DOWN & LOCKED POSITION. RETURNED TO FIELD. (FLIGHT 4669) PERFSDR SWAA2026012962518Bulb · blownEMERGENCY EXIT SIGN MOUNTED ON AFT WALL OF FORWARD LAVATORY HAS ONE BULB THAT DOES NOT ILLUMINATE. REMOVED & REPLACED BLOWN LAMP FOR EMERGENCY EXIT SIGN & PERFORMED GOOD OPS TESTED IAW AMM 33-51-01-960-801.SDR CALA2026012913427Hydraulic System · low pressureECAM HYD G SYS LO PR W/ PTU FAULT LIGHT ALL SYSTEM OPS NORMAL ON ARRIVAL TO ACFT FOUND GREEN HYD PSI INDICATION AT 1800 PSI WITH SYSTEM OFF. GREEN HYD LEAK MEASUREMENT SWITCH WAS SELECTED. TURNED OFF LEAK MEASUREMENT SWITCH. ALL INDICATIONS RETURNED TO NORMASDR SWAA2026012862521Fuse · inoperativeAISLE EMERGENCY LIGHT DIRECTLY OVER RT SIDE FWD OVERWING EXIT DOES NOT ILLUMINATE R & R THE FUSES 1 & 4 FOR EMERGENCY LIGHT BATTERY PACK M1676 AND PERFORMED GOOD OPS TEST IAW AMM 33-51-06-960-804.SDR AALA202601280508Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601284389Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601284015Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR DALA2026012700645Fire Bottle · failedDIVERTED TO DFW DUE TO CARGO BTL FAIL MESSAGE. REPLACED THE LOW-RATE DISCHARGE (LRD) FIRE EXTINGUISHING BOTTLE 1. (LP# 8025421)SDR ASAA2026011863956Skin · corrodedEXTERIOR FUSELAGE SKIN SHOWED SIGNS OF CORROSION AROUND TOILET VENT ABOVE LAV SERVICING PANEL. GROUNDED - YES. ACCOMPLISHED REPAIR 3, SECTION 47 FUSELAGE SKIN REPAIR AT BS 917, BTWN S21-22L. INSTALLED A DOUBLER, TRIPLER, FILLER & RESTORED PROTECTIVE FINISHESSDR AALA202601256727Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: SEAT 4H AFT EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND CONNECTOR TO SEAT 4H AFT EMERGENCY LIGHT LOOSE. SECURED CONNECTOR AND PERFORMED INSTALLATION TEST IAW AMM 33-51.06.SDR AALA202601252055Elec Connector · looseAIRCRAFT IN BASE MAINTENANCE: SEAT 10D AISLE EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND SEAT TO SEAT CONNECTOR D2 LOOSE IAW CMM 25-25-71.SDR SCNA20260123040Strut · dischargedON WALK AROUND NOSE LG STRUT FOUND FULLY COMPRESSED. PRECEIDING FLIGHT (3055) CREW HAD ISSUE WITH NOSE LG DISAGREE INDICATION, CREW RUN NNC WHICH FIXED AN ISSUE AND LANDED SUCCESS FULLY. TS 31882 SERVICED NOSE STRUT WITH N2 TO SERVICEABLE PRESSURE/EXTENSIOSDR REXA2026012300022Battery · inoperativeSEVERAL OVHD INTERIOR EMERGENCY LIGHTS ARE INOP. DETERMINED THAT THE EMERGENCY LIGHT BATTERY SN:79574 HAS EXTREMELY LOW VOLTAGE. REPLACED BATTERY ASSY. PN:AD2013-1A WITH SN:20563; IAW CRJ-900 ESPM 20-00-02 AND AMM 33-51-17. OPS TEST GOOD IAW CRJ-900 AMM 33-5SDR DALA2026012200500Cable · corrodedFOUND CABLE 129F CORRODED. REF AMDS CARD 2000-9000-04 REMOVED AND REPLACED CABLE (1408307)SDR AALA202601221921Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: RT SIDE OF PLANE G6 GALLEY EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-05-960-801.SDR DALA2026012100470Indicator · obstructedESCAPE SLIDE ARMED CONDITION INDICATORS. L2 KNOCKLE KNOCKER INOPERATIVE. KNUCKLE KNOCKER CAUGHT UP ON DOOR LINER. CLEANED AND ADJUSTED KNOCKER IAW AMM 52-11. KNOCKER WORKS GOOD. (1407722)SDR AALA202601213112Accumulator · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ACCUMULATOR NEEDS SERVICING. R1 DOOR ACCUMULATOR SERVICED. IAW AMM 52-10-00.SDR AALA202601217978Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT AT SEAT ROW 4AC INOPERATIVE. RESEATED CONNECTER FOR EMERGENCY HARNESS AT SEAT 4AC. OPS CHECKS GOOD. PER AMM 33-51-00.SDR AALA202601218944Control Panel · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKE OFF WEATHER RADAR INDICATED WEATHER FAIL. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. REMOVED AND REPLACED WEATHER RADAR CONTROL PANEL. PER AMM 34-43-91.SDR AALA202601219255Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS HARD TO OPEN AND CLOSE. LUBED AFT LEFT LAVATORY DOOR. OPS CHECK GOOD. PER CMM 25-23-67.SDR YENA2026012100060Slide Raft · failedFLT 123, WHILE IN MAINTENANCE L1 DOOR WILL NOT ARM. REMOVED AND INSTALLED L1 DOOR ESCAPE SLIDE ASSY IAW AMM 25-62-44. TESTED OK.SDR AALA202601212057Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 68 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001, REPAIR PRINCIPLE #5.SDR YENA2026012100059Unknown · odorFLT # 1941 BOS-SRQ ."FLIGHT ATTENTANTS REPORTED SCENT COMING OUT OF CABIN VENTS IN FRONT AND BACK DURING LANDING ROLLOUT.; PERFORMED TROUBLE SHOOTING REFERENCE A220 BD500-A-J21-00-00AAA-423A-A.UNABLE TO DUPLICATE ODOR,NO DEFECTS NOTEDSDR DALA2026012100452Door Frame · crackedOPEN HOLE HFEC INSPECTION CARRIED OUT ON THE ALL FASTENER HOLES (5EA) AT THE FWD SERVICE DOOR CUTOUT AFT LOWER CONNER. FOUND A CRACK IN THE NR 3 AND NR 4 FASTENER HOLE. DAMAGED AREA REPAIRED PER ER/A631544-14A. (1407307)SDR DALA2026012100451Door Frame · crackedOPEN HOLE HFEC INSPECTION CARRIED OUT ON THE ALL FASTENER HOLES (5EA) AT THE FWD ENTRY DOOR CUTOUT AFT LOWER CONNER. FOUND CRACKED IN THE NR 3 AND NR 4 FASTENER HOLE. DAMAGED AREA REPAIRED IAW ER/A631543-14AD (1407282).SDR YENA2026012100057Light · inoperativeDURING HEAVY MAINTENANCE: INOP EMERGENCY OVERWING LIGHT FORWARD ACCESS PANEL 191DT LOCATION WING TO FUSELAGE FAIRING; REFERENCE AEROMAN W.O. 2025 465/1 NR 2025-741307 ** REMOVED EMERGENCY OVERWING LIGHTS (61WL) IAW AMM 33-51-15-000-001-A. AND REPLACED EMERGENCSDR YENA2026012100056Light · inoperativeDURING HEAVY MAINTENANCE: INOP EMERGENCY OVERWING LIGHT FORWARD ACCESS PANEL 192DT LOCATION WING TO FUSELAGE FAIRING; REFERENCE AEROMAN W.O. 2025 465/1 NR 2025-NR2025-741308 * EMOVED EMERGENCY OVERWING LIGTHS (60WL) IAW AMM 33-51-15-000-001-A AND REPLACED EMESDR YENA2026012100055Fillet · corrodedDURING HEAVY MAINTENANCE: PYLONS / LH PYLON / PYLON TO WING CENTER FILLETS / INBD STRIP RIB 7A AND RIB 10A / CORROSION – PERMANENT REPAIR; REFERENCES: /1/ STS EA 160-2025-011 REV IR /2/ AIRBUS RDAF 81708156/003/2025#A /3/ REPAIR INSTRUCTIONS TD/81708156/012/20SDR YENA2026012100054Fillet · crackedDURING HEAVY MAINTENANCE: PYLONS / LH PYLON / PYLON TO WING CENTER FILLETS / OUTBD STRIP RIB 7A AND RIB 10A / CRACK AND CORROSION – PERMANENT REPAIR; REFERENCES: /1/ STS EA 160-2026-001 REV IR /2/ AIRBUS RDAF 81708168/003/2025#A /3/ REPAIR INSTRUCTIONS TD/8170SDR YENA2026012100053Panel · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / NOSE FWD FUSELAGE / NLG COMPARTMENT REINFORCEMENT DOUBLER AT FR16-17 AND Y+250 / CORROSION - PERMANENT REPAIR; REFERENCES: /1/ AEM EA 53-0089-25 REV 0 (COVER AND PARTS 1 - 5) /2/ AIRBUS RDAF 81702470/003/2025#A /3/ REPAIR ISDR YENA2026012100052Pressure Deck · crackedDURING HEAVY MAINTENANCE: FUSELAGE / CENTER FUSELAGE / PRESSURE DECK PANEL / FR36 RHS / ATTACHMENT HOLES / CRACKS – TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0085-25 REV. 0 (COVER + PARTS 1-8) /2/ AIRBUS DOSSIER 81696490 /3/ AIRBUS RDAF 81696490/003/2SDR YENA2026012100051Frame · damagedDURING HEAVY MAINTENANCE: WINGS / CENTER WING BOX / FRONT SPAR VERTICAL STRINGERS & HORIZONTAL FLOOR BEAMS / @ LEVEL OF FR36 & Y-1292, Y-765, Y-254, Y+254, Y+765 & Y+1292 / CRACKS - PERMANENT REPAIR; REFERENCES: /1/ AEROMAN EA 57-0117-25 REV. 0 (COVER + PARTS SDR YENA2026012100050Skin · corrodedDURING HEAVY MAINTENANCE: FUSELAGE / REAR FUSELAGE / FR 65-66 & STR31R / INNER SKIN / CORROSION DAMAGE - TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0077-25 REV. 1 (COVER + PARTS 1-3) /2/ AIRBUS RDAF 81680476/005/2025 ISSUE B /3/ AIRBUS TD/81680476/037/SDR YENA2026012100049Pressure Panel · damagedDURING HEAVY MAINTENANCE: FUSELAGE / CENTER FUSELAGE / FR 36 LH & RH SIDES / PRESSURE PANEL / CRACK DAMAGES AT MULTIPLE HOLES – TIME LIMITED REPAIR; REFERENCES: /1/ AEROMAN EA 53-0071-25 REV. 0 (COVER + PARTS 1-11) /2/ AIRBUS RDAF 81680593/005/2025#A /3/ AIRBU