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 AALA202510206332Hook · deterioratedAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 841 STAY MECHANISM HOOK WHEN IN THE LOCKED POSITION IS DETERIORATED. REPLACED STAY MECHANISM AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-12.SDR AALA202510206360Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER FROM FORWARD SPAR, LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER AARD 51-00-05-1..SDR SWAA2025101615973Support Angle · crackedCRACK ANGLE - SUPPORT LOCATED BETWEEN BS500I AND STR28R FWD CARGO COMPARTMENT. REPLACED ANGLE SUPPORT AND FASTENERS LOCATED BETWEEN BS500I AND STR28R FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG 143A7902 SHEET 301 REVSDR CALA2025101510112Skin · corrodedPOSIBLE CORROSION ON UPPER SKIN BS 727E BTW STR 3R TO 4R. REPAIRED SKIN, BS 727E S3R TO S4R IAW EC/RA 5360-02015 AND EO 250309 REV. IR, RSDR AALA202510144678Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT-HAND PASSENGER / CREW DOOR CUTOUT LOWER SILL FORWARD CORNER SHAPE FITTING AT FR 66 S23L. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR AALA202510135509Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT-HAND PASSENGER / CREW DOOR CUT OUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23L. REPLACED CORNER SHAPE FITTING PER SMR 51-72-11.SDR AALA202510131127Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 294 AND BS 312 AT LBL 15. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510104147Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 9. REPAIRED ANGLE PER SRM 57-10-10-2R-5 AND AARD 51-00-05-1.SDR SWIA2025F01428Beam · corrodedAFT WET AREA RT BEAM CORRODED AT FR87. REMOVED AND REPLACED AFT WET AREA RT BEAM AT FR 88 IAW SRM 51-40-08. SEE CONTINUATION CARD FOR WORK PERFORMED. THIS REPAIR DOES NOT AFFECT THE WEIGHT AND BALANCE.SDR SWIA2025F01427Beam · corrodedAFT WET AREA LT BEAM AT FR 88 CORRODED. REMOVED AND REPLACED AFT WET AREA LT BEAM AT FR 88 IAW SRM 51-40-08. THIS REPAIR DOES NOT AFFECT THE WEIGHT AND BALANCE.SDR SWIA2025100900018Rib · crackedRIGHT HORIZONTAL STABILIZER HAS SUSPECTED CRACK AT RIB 10A, REMOVED AND REPLACED RH HORIZONTAL STABILIZER AT RIB 10A. PART REPLACED WITH OEM. NO CHANGE OF WEIGHT AND BALANCE. REF: SRM 51-40-08SDR 2025FA0000697Air Box · crackedAIRBOX SEALS DEGRADED OR MISSING. CRACKS DISCOVERED IN AIRBOX ASSEMBLYSDR AALA202510076294Frame Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON APU COMPARTMENT BULKHEAD LOWER FRAME CLIP AT BS 1088, RBL 15. REPLACED FRAME CLIP PER SRM 51-40-02.SDR AALA202510073912Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE LOCATED IN RIGHT HAND ECS BAY AT BS 663, RBL 9. REPAIRED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202510078409Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE K WEB AT BS 986, LBL 32. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202510078807Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) BETWEEN BS 294 AND BS 312 AT LBL 51. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202510073907Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) BETWEEN BS 340 AND BS 360 AT LBL 58. REPLACED INNER CHORD PER AARD 51-00-05-1.SDR AALA202510072358Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED AT BS 328, LBL 53. REPLACED INNER CHORD PER SRM 51-40-02.SDR AALA202510021124Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 6 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510028066Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 6 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 6 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510023351Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 5 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 5 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510020398Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 4 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510026258Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING #5 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING # 5 ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510022866Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 3 ON RH HORIZONTAL STABILIZER MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 3 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510022072Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 2 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510025860Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 1 ON RH HORIZONTAL STABILIZER. MSINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING NO 1 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202510029048Lubrication Unit · leakingAIRCRAFT WAS GROUNDED: IN CRUISE FLIGHT AT FL370, ONE HOUR INTO FLIGHT, FA NOTICED STRONG DIRTY SOCK ODOR IN AFT L LAVATORY. ODOR DISSIPATED AFTER 20 MINUTES. **SUPPLEMENTAL SDR FOR AALA202509229048. MAINTENANCE REPLACED OIL LUBE MODULE IAW AMM 49-91-45.SDR FDEA202509181854Skin · misrepairedEXISTING DOUBLER REPAIR FOUND ON FUSELAGE SKIN BTW FR102~103,STGR 1~2L COMPLIED WITH ATTACHMENT B OF EO:E6-5100-7-5000 D7 PT1,TITLE:STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.707,INSPECTION OF DOUBLERSDR FDEA202509181853Seat Track · misrepairedEXISTING SPLICE REPAIR FOUND ON MDCC SEAT TRACK BTW FR37~38.2,Y953 COMPLIED WITH ATTACHMENT B OF EO:E6-5100-7-5000 D7 PT1,TITLE:STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.707,INSPECTION OF SPLICE REPASDR AALA202509298390Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 78.29. REPLACED RIB PER AARD 51-00-05-1.SDR AALA202509292773Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN BS 328 AND BS 344, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR R61A2025092700415Rib · corrodedDURING HEAVY MAINTENANCE VISIT CORROSION FOUND AT RIB 4A DURING REMOVAL OF FASTNER RH WING AS SEEN THROUGH PANEL 622DB. REMOVED CORROSION FROM HOLE AT RIB 4A BY REAMING AND INSTALLED PERMANENT BUSHING REPAIR REF. ETD2025-170-928020.SDR DALA2025092607012Proximity Sensor · faultedL2 DOOR SLIDE LIGHT INOP. REMOVED AND REPLACED L2 DOOR GIRT BAR PROXIMITY SENSOR IAW AMM 25-66-11. OPS CHECKED NORMAL. (1205119)SDR HNAA2025092600645Door · nickedNICK ON AFT AVIONICS DOOR. REPAIRED IAW EO 1-53-24-0332SDR CALA2025092609313Skin · crackedONE CRACK SIGNAL NOTED L=0.650INCH AT STAB LT SIDE HSS 147.90, LOCATED TO 17INCH FWD FROM REAR SPAR. .PERFORMED PERMANENT REPAIR AT HORIZONTAL STAB LT SIDE HSS 147.90 LOCATED TO 17INCH FWD FROM REAR SPAR, THIS REPAIR IS A CATEGORY 'B" REQUIRE REPETITIVE INSPECSDR DALA2025092507002Door · corrodedCORROSION ON TOILET SERVICE PANEL DOOR FWD CORNER. REMOVED AND REPLACED WASTE SERVICE PANEL DOOR IAW AMP BD500 -A-J52-47-06-05AAA-520A-A AND AMP BD500-A-J52-47-06- 05AAA-720A-A BONDING GOOD. AMP BD500-A-J20-25-01-01AAA-030A-A. (LP# 1210147)SDR REXA2025092300871Fadec · inoperativeAT FL 310 AND WE WERE TOLD TO DESCEND DOWN TO 11,00. WE HAD A R ENGINE FLAME OUT AND LOST OUT R ENGINE, R FADEC FAULT AND L FADEC FAULT STATUS MESSAGE CAME ON. OUR RIGHT ENGINE LIT BACK UP. R/L FADEC FAULT STATUS MSG CAME IN AND OUT ITERMITTENTLY. AFTER WE LANSDR AALA202509231547Shear Plate · elongatedAIRCRAFT IN BASE MAINTENANCE: 12 ELONGATED HOLES FOUND DURING KEEL BEAM REPLACEMENT. MAINTENANCE REPLACED SHEAR PLATE PER SRM & EA 368118.SDR AALA202509239050Shade · stuckAIRCRAFT WAS NOT GROUNDED: 14 F EMERGENCY EXIT WINDOW SHADE WILL NOT OPEN. MAINTENANCE REPLACED 14F EMERGENCY EXIT WINDOW BLIND SHADE IAW AMM 25-23-43.SDR AALA202509238857Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT CONNECTOR UNDER SEATS 23ABC IN P1 POISTION IS DAMAGED. REMOVED AND REPALCED EMERGENCY LIGHT CONNECTOR UNDER SEATS 23ABC IN P1 POSITION. PER SWPM 20-61-28.SDR AALA202509238205Transfer Sys · no discrepancyAIRCRAFT WAS GROUNDED: DURING CRUISE FUEL IN WOULD MOVE INTO THE CENTER TANKS WHILE FUEL PUMPS WERE OFF. NO EVIDENCE OF FUEL MIGRATION AT THIS TIME, NO FAULT FOUND. PER FIM 28-21-00-810-812.SDR CALA2025092309149Warning Message · false activationDOOR FWD ENTRY THE PSEU SYSTEM HAS DETECTED A FAULT IN THE FWD ENTRY DOOR INDICATION SYSTEM. UPON ARRIVAL, MAINT LIGHT OUT. PERFORMED FIM 52-10 TASK 801. CYCLED FWD ENTRY DOOR AND INDICATION NORMAL.SDR AALA202509223255Relay · faultedAIRCRAFT WAS GROUNDED: AIR INTERRUPT FOR THE FOLLOWING: CABIN ALT AUTO L, ASCP PRIMARY CTRL L, WARNING SPEAKER L, STALL WARNING SYSTEM L, WEU CHANNEL L2, WEU CHANNEL L1, PFCS INTERFACE, LSCF PWR SUPPLY 2, LEFT PACKSHOWED INOP. MAIN BAT SHOWED DISCHARGING INTERSDR AALA202509229048Unknown · odorAIRCRAFT WAS GROUNDED: IN CRUISE FLIGHT AT FL370, ONE HOUR INTO FLIGHT, FA NOTICED STRONG DIRTY SOCK ODOR IN AFT L LAVATORY. ODOR DISSIPATED AFTER 20 MINUTES. (OPEN)SDR ASAA2025091861023Light Sys · malfunctionedROW 27 ABC EMERGENCY LIGHTING RANDOMLY ILLUMINATES DURING TAKEOFF AND LANDING. GROUNDED - YES. VERIFIED EMERGENCY LIGHTING OPS NORMAL AFTER SEVERAL CYCLES.SDR ASAA2025092261022Sign · detachedMID-CABIN EXIT SIGN FALLING DOWN. GROUNDED - YES. MID CABIN EXIT SIGN FOR OWE REPOSITIONED & FASTENERS TIGHTENED REF AMM 33-51-01-960-802. OPS CHECKS OF LIGHTING FUNCTION GOOD.SDR SWAA2025092216323Engine · failedNR 2 ENG FAIL ON T/O ROLL. NR 2 ENGINE FAILURE AND RTO AT 100KTS METAL IN THE TAILPIPE. REPLACED NR 2 ENGINE IAW MT 771-00-01 REF TTG8Q00YY43D.SDR SWIA2025092200018Clamp · damagedRIGHT 10TH DUCT WARNING MSG DURING CLIMB AT 3500FT. APPLIED QRH, MSG DISAPPEARED, RETURNED TO KORD WITH NO FURTHER ISSUE. (FLIGHT 5215) SEE CP 30863533 FOR 10TH STAGE LEAK CHECK. SEE CP 30863951 FOR ACM COMPRESSOR INLET DUCT CLAMP REPLACEMENT SEE CP 3086354SDR DXTA2025092205004Spring · defectiveWHILE CLOSING MED THERE WAS AN AUDIBLE NOISE FROM INSIDE THE DOOR AND IT FELL OPEN ON ITS OWN. NOW THE DOOR CANNOT BE CLOSED IT STARTS TO BIND ALMOST AS SOON AS YOU START TO RAISE IT. REMOVED 30 RIVETS ON T BRACKET TO GAIN ACCESS TO COUNTERBALANCE FOR REMOVEDSDR DXTA2025092205009Battery Pack · inoperativeAIRCRAFT PREFLIGHT CHECK OF EMERGENCY LIGHTS TO ARM, NO EXTERIOR OR INTERIOR EMERGENCY LIGHTS ILLUMINATED. SHOULD ALL ILLUMINATE WITH NO MAIN DC POWER. SWITCH TO EMERGENCY LIGHTS ON, ALL EMERGENCY LIGHTS AND PAX SAFETY ILLUMINATED. ALSO WITH POWER ON AND AP