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 FDEA202508011349Floor Panel · dentedSEVERAL DENTS ON FLOOR PANEL 251PFF FLOOR PANEL 251PFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4.B FIG.201 (SHEET 2) REV. 92 APR 15,2025SDR AALA202508040937Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN LIGHT AT L3 DOOR INOP. MAINTENANCE REPLACED EMERGENCY EXIT SIGN ASSY AT THE L3 DOOR IAW AMM 33-51-16 OPS CHECKS SATISFACTORY.SDR AALA202508043666Blades · dirtyAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL & CLIMB STRONG SMELL OF A MUSKY ODOR (DIRTY SOCK) CONFIRMED BY FA'S. LASTED ABOUT 10 MINUTES. MAINTENANCE FOUND EXCESSIVR GREASE ON #1 ENGINE FAN BLADES, CLEANED FAN BLADES AND GUIDE VANES IAW AMM 70-00-00.SDR DALA2025080405815Fan · failed(LOG 7456172) AFTER PARKING FA'S IN REAR OF A/C REPORT AN EGG/SULFUR ODOR IN THE CABIN. PACKS WOULD NOT COOL BELOW 82 DURING FLIGHT. FLT ATTEND REPORTS NOTICED ODOR ON TAKEOFF + LANDING ONLY. CONFIRMED ODOR TO BE FROM LEFT RECIC FAN. R&R LEFT FAN. RAN ENGS TO SDR DALA2025080405812Channel · corrodedCORROSION ON ZEE CHANNEL RBL 34 FROM STA 986-1016 ON FLOOR STRUCTURE AT PAX CABIN. ZEE CHANNEL RBL 34 FROM BS 986-1016 ON FLOOR STRUCTURE AT PAX CABIN WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR CALA2025080407251Actuator · faultedENG 1 COMPRESSOR VANE. CHA/CHB VSV ACT/HC/EEC1 FOUND WITH FAULT ACRONYM OF SVATK, REF TSM'S 75-30-00-810-843-A AND 75-30-00-810-845, PERFORMED TSM 75-30-00-810-805B FOUND ENGINE 1 VSV BOTH CHANNELS DEFECTED. REMOVED AND REPLACED ENGINE 1 VSV REF AMM 75-32-SDR CALA2025080407245Floorbeam · corrodedCORROSION AT AFT CABIN WET AREA FLOOR BEAM STA 947.5 UPPER FLANGE FROM LBL 25 TO RBL 11. ACCOMPLISHED FLOOR BEAM REPAIR AT BS 947.5 IAW SRM 53-70-51-2R-5 AND ECRA 5370-01188.SDR CALA2025080407244Sign · detachedDOOR 1L EMERGENCY EXIT SIGN FELL OFF RESECURED EMERGENCY EXIT LIGHT LENS COVER AT DOOR 1L REF AMM 33-51-01-402-030. ADDED SDR DATASDR CALA2025080407243Light · detachedSAFETY LIGHT SEAT 1F POPPED OUT. INSTALLED GROUND PROXIMITY LIGHT IN REF AMM 33-51-06-00A-520A-A. OPS CHECKED GOOD. OK FOR SERVICE.SDR CALA2025080407242Rib · gougedMULTIPLE GOUGES FOUND ON VERTICAL FIN L/E FIXED RIB LE HSS 1007.65). REMOVED AND REPLACED VERTICAL FIN L/E FIXED RIB IAW SRM 51-40-02-0G-0 AND DWG 176A3002.SDR CALA2025080407241Profile · corrodedLH FR 35 BULKHEAD LOWER PROFILE CORRODED STR 35-38L. REMOVED AND REPLACED PROFILE PANEL AT FWD CARGO FR 35, S35-38L IAW SRM 51-42-11-00.SDR CALA2025080407240Seat Track · corrodedMAIN CABIN, GOUGE AT SEAT TRACK CROWN TOP BS 520, RBL 45.50. COMPLETED INSTALLATION OF SEAT TRACK AND CHANNEL BS 520, RBL 45.50 IAW SRM 51-40-02-0G-0 SRM-53-00-52-2R-4 DWG 143A5400.SDR CALA2025080407239Battery Pack · no testL4 DOOR M33407 EMERGENCY POWER SUPPLY BATTERY PACK FOUND MALFUNC TIONED. REPLACED L4 DOOR M33407 EMERGENCY POWER SUPPLY BATTERY PACK AND PERFORMED NEW BATTERY PACK TEST. OPS NORMAL IAW AMM 33-51-06-96 0-802 REV 104.SDR DALA2025080405801Light · brokenFOUND EMERGENCY LIGHT HOUSING BROKEN OF SEAT 24DEF. R & R SEAT 24FED EMERGENCY LIGHT HOUSING IN REF TO A320 CMM 25-23- 51. OPS CHECK NML. OK FOR SVC.SDR AALA202508034048Proximity Sensor · false indicationAIRCRAFT WAS GROUNDED: ERRONEOUS EMERENCY EXIT DOOR OPEN INDICATIONS ON ECAM TRIGGERED CABIN LIGHTS FLASHING. FLIGHT CREW ALSO REPORTED THAT THE WHITE SLIDE ARM INDICATOR LIGHT DID ILLUMINATE- MEL STATES INDICATION SHOULD NOT BE PRESENT. MAINTENANCE REPLACED PSDR AALA202508036777Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: DOOR LEFT AFT EMERGENCY EXIT ECAM ON TAKEOFF ROLL. THE FLIGHT CREW REJECTED TAKEOFF BELOW 80 KNOTS. MAINTENANCE CONFIRMED L3 DOOR OPEN INDICATES INTERMITTENTLY ON ECAM CAUSING FLIGHTR ATTENDANT CALL LIGHTS TO FLICKER. MAINTENANCE RESDR AALA202508039903Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER TASK CARD 26L000005005.SDR AALA202508036138Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: MOMENTARY LAVATORY SMOKE WARNING ECAM AT CRUISE FL350. FLIGHT ATTENDANT COULD NOT IDENTIFY SOURCE OR ACTUAL SMOKE. MAINTENANCE ACCOMPLISHED MCDU TEST AND GROUND SCAN DETECTED NO FAULTS.SDR AALA202508035329Handle · looseAIRCRAFT WAS NOT GROUNDED: 2R DOOR ARMING LEVER IS LOOSE. MAINTENANCE SECURED ARMING LEVER / HANDLE AS REQUIRED.SDR DALA2025080205800Spinner · leakingFUME EVENT ON TAKE OFF FROM SDQ - TOGA T/O APU ON OFF RWY 18. AT ABOUT LIFT OFF A STRONG FUEL FUME/OIL SMELL WAS EVIDENT. CLEAN A/C CONFIGURATION AND SHUT DOWN APU. ONCE APU BLEED WAS SWITCHED OFF FUMES DIMINISHED CREW OXYGEN (O2) MASK USE. FUMES DID NOT RETURSDR AALA202508029488Light · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT AT 4DEF DOES NOT ILLUMINATE. MAINTENANCE REPLACED LIGHT ASSEMBLY AT SEAT 14 ABC/DEF, IAW AMM 33-51-18.SDR 2025FA0000533Fork · crackedUPON INSPECTION AND CLEANING OF THE ABI 3413-01K TAIL WHEEL FORK ASSY, A CRACK WAS DISCOVERED. PHOTOS UPON REQUEST.SDR UIEA2025080101075Oxygen Bottle · not reportedAFT CENTER PORTABLE O2 BOTTLE REQ REPLACEMENT(<P>REMOVED AND REPLACED PORTABLE O2 BOTTLE IAW B767 AMM 35-31-01. OPS & LK CHK OK. NO FURTHER DEFECTS.</P>)SDR UIEA2025070600841Rib · crackedRHW T/E I/B AILERON L/H I/B ATTACH HINGE RIB UPPER T/E FLANGE FOUND CRACKED AS MARKED.(<P>RHW T/E I/B AILERON L/H I/B ATTACH HINGE RIB UPPER T/E FLANGE REPAIRED IAW RI-57-20-17700 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600842Rib · crackedLHW T/E I/B AILERON R/H HINGE ATTACH R/H RIB UPPER FLANGE FOUND CRACKED.(<P>HW T/E I/B AILERON R/H HINGE ATTACH R/H RIB UPPER FLANGE REPAIRED I.A.W RI-57-20-17699 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000897Flap · damaged#7 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000898Flap · damaged#8 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000899Flap · damaged#19 V/C FLAP LSA DAMAGED.(<P>PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000900Flap · damaged#20 V/C FLAP LSA DAMAGED. PERFORMED REPAIR AT LSA DAMAGE AREA IAW CMM 57-55-42 REPAIR 17-1. NO FURTHER DEFECTS NOTED.SDR UIEA2025071400948Rib · crackedRHW R/H O/B AILERON ATTACH HINGE L/H AFT SPAR RIB (691JB) FLANGE FOUND CRACKED AS MARKED.(<P>RHW R/H O/B AILERON ATTACH HINGE L/H AFT SPAR RIB (691JB) FLANGE FOUND CRACKED AREA REPAIRED IAW RI-57-51-17702 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071400950Stringer · crackedM/D STA 879 AND STA 882 S7L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 879 AND STA 882 S7L STRINGER AREA CRACK REPAIRED IAW 747-8F SRM 53-20-03 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071400951Stringer · crackedM/D STA 880-890 S8L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 880-890 S8L STRINGER CRACKED AREA REPAIRED AS PER EO 4853A131 1 & 2 B747-8F SRM 53-20-03 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071500952Stringer · crackedM/D - STA 2180 FWD AND AFT, S-10L STRINGER FOUND CRACKED.(<P>M/D - STA 2180 FWD AND AFT, S-10L STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071600959Rib · crackedRHW T/E I/B AILERON L/H O/B ATTACH HINGE RIB UPPER T/E FLANGE FOUND CRACKED AS MARKED.(<P>RHW T/E I/B AILERON L/H O/B ATTACH HINGE RIB UPPER T/E FLANGE CRACKED AREA REPAIRED IAW RI-57-20-17701 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700965Stringer · crackedM/D - STA 2180 AFT AND FWD, S-12L STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-12L STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700967Stringer · crackedM/D - STA 2180 FWD AND AFT, S-10R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 FWD AND AFT, S-10R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700968Stringer · crackedM/D - STA 2180 AFT AND FWD, S-11R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-11R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 AL 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700969Stringer · crackedM/D - STA 2180 AFT AND FWD, S-12R STRINGER FOUND CRACKED.(<P>M/D - STA 2180 AFT AND FWD, S-12R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-3 ALTERNATIVE 4 FIG 205 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071700970Stringer · crackedM/D STA 919 S8L STRINGER AREA FOUND CRACK AS PER EO 4853A131 1 & 2.(<P>M/D STA 919 S8L STRINGER AREA CRACKED AREA REPAIRED IAW B747-8F SRM 53-20-03-2R-1 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800973Stringer · crackedM/D STA 850-862 S10L STRINGER AREA FOUND SEVERAL CRACKS AS PER EO 4853A131 1 & 2.(<P>M/D STA 850-862 S10L STRINGER CRACKED AREAS REPAIRED IAW B747-8F SRM 53-20-03-2R-1 REPAIR 1 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800974Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 7R SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 7R CRACKED AREA REPAIRED I.A.W RI-53-81-17714 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071800975Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 1R SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 1R CRACKED AREA REPAIRED IAW RI-53-81-17713 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072000981Stringer · crackedEMP - STA 2598 FWD FACE STRINGER 7L SUSPECT CRACKED.(<P>EMP - STA 2598 FWD FACE STRINGER 7L CRACKED AREA REPAIRED IAW RI-53-81-17707 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072000982Stringer · crackedM/D - STA 1960 AFT, S-8R STRINGER FOUND CRACKED.(<P>M/D - STA 1960 AFT, S-8R STRINGER CRACKED AREA REPAIRED IAW SRM 53-60-03-2R-4 ALTERNATIVE 3 FIG 204 REV.46. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100984Fairing · crackedLONGERON BOX FAIRING FOUND CRACK.(<P>PERFORMED REPAIR AT CRACKED AREA AS PER RI-53-40-17743 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100985Channel · crackedHORIZONTAL STAB. T/E AFT SUPPORT WEDGE U CHANNEL FOUND CRACK.(<P>REPLACED U CHANNEL AS PER RI-55-10-17723 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100986Stringer · cracked2 EA CRACKS WERE FOUND ON STRINGER I/B SIDE AT FWD OF BS2360 STR 1R AREA.(<P>CRACKS ON STRINGER I/B SIDE AT FWD OF BS2360 STR 1R AREA REPAIRED IAW RI-53-61-17705 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100987Stringer · cracked2 EA CRACKS WERE FOUND ON STRINGER UPPER SIDE AT FWD OF BS 2360 STR 7R AREA.(<P>2 EA CRACKS ON STRINGER UPPER SIDE AT FWD OF BS 2360 STR 7R AREA REPAIRED IAW B747-8F SRM 53-60-03-2R-8 REPAIR 8 TR53-149. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100988Stringer · crackedCRACKS WERE FOUND ON STRINGER I/B AND O/B SIDE AT FWD OF BS 2360 STR 2R AREA.(<P>CRACKS ON STRINGER I/B AND O/B SIDE AT FWD OF BS 2360 STR 2R AREA WERE REPAIRED IAW RI-53-61-17706 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025072100990Stringer · cracked2 EA CRACK WERE FOUND ON STRINGER O/B SIDE AT FWD OF BS 2360 STR 2L AREA.(<P>2 EA CRACKS ON STRINGER O/B SIDE AT FWD OF BS 2360 STR 2L AREA WERE REPAIRED IAW RI-53-61-17703 REV.A. NO FURTHER DEFECTS NOTED.</P>)