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 AALA202508019016Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 727G TO BS 727H AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508012053Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 727I TO BS 747 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202508014716Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE ZEE ASSEMBLY FROM BS 747 TO BS 767 AT S25R. REPLACED ZEE ASSEMBLY PER AARD 51-00-05-1.SDR AALA202507316943Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 16CBA OVERHEAD LIGHT ON EMERGENCY DOOR INOPERATIVE. REMOVED AND REPLACED SIDEWALL LIGHT AT 4AB. PER AMM 33-21-00. OPERATIONAL CHECK GOOD.SDR CALA2025073107125Stiffener · crackedRIGHT HORIZONTAL STAB FRONT SPAR HSS 101.90, VERTICAL STIFFENER NR 2 CRACKED AT LOWER TRANSITION RADIUS. INSTALLED ALL REPAIR PARTS AT RT HORIZONTAL STAB FRONT SPAR HSS 101.90 VERTICAL STIFFENER NR 2 IAW SRM 55-10-09-2R-4, REPAIR 4, & SRM 51-40-02-0G-0.SDR ASAA2025071859738Beam · crackedR1 DOOR, LOWER MACHINE FRAME BELOW HANDLE BOX CRACKED. GROUNDED - YES. REMOVED THE R1 DOOR NR 4 BEAM AND REPLACED WITH NEW IAW SRM 51-40-02-0G-0.SDR U5QA202507180158Dump Valve · leakingLEFT HYDRAULIC SYSTEM INDICATING A FLUID LEAK DURING FLIGHT. FOUND DUMP VALVE STILL OPEN FROM PREVIOUS EMERGENCY EXTENSION, FOUND HYDRAULIC LEAK COMING FROM RT NOSE VENT FOR EMERGENCY PNEUMATIC EXTENSION LINES. CLOSED DUMP VALVE & SEATED SHUTTLE VALVES IAW ASDR AALA202507299614Reservoir · low pressureAIRCRAFT WAS NOT GROUNDED: WHEN ARMING DOOR 3L, THE #1 FLIGHT ATTENDANTS INFORMATION SCREEN SHOWS, SLIDE PRESSURE LOW. **SUPPLEMENTAL REPORT FOR AALA202507229614: MAINTENANCE REPLACED THE L3 DOOR ESCAPE SLIDE INFLATION RESERVOIR AND ACCOMPLISHED A SATISFACTORYSDR JJBA20250729105Door Sill · corrodedCF3 RH FUSE BTW FR 41-48 SILL CORRODED. CF3 RH FUSE BTW FR 41-48 SILL BLENDED AND FOUND OUT OF LIMIT. CF3 RH FUSE BTW FR41-48 SILL REMOVED AND REPLACEDSDR 2025FA0000529Filter · meltedPRESSURIZED MAGNETO AIR SOURCE FILTER MELTED/DEFORMED AFTER ONLY 79H AFTER INSTALLATION. BLOCKAGE OF AIR TO MAGNETO CAUSED LEFT MAGNETO FAILURE, WHICH WAS ALSO JUST 79H AFTER REPLACEMENT. PROBLEM SEEMS TO OCCUR FREQUENTLY WITH THAT FILTER INSTALLATION IN SR22 SDR SWAA2025072892749Handle · looseL1 DOOR LINER ASSIST HANDLES LOOSE (BOTH UPPR AND LWR). SECURED UPPER AND LOWER ASSIST HANDLES ON L-1 DOOR IAW AMM 52-11-31-400-802 STEP 3G2.SDR SWAA2025072892748Handle · looseL2 DOOR LINER ASSIST HANDLE LOOSE. SECURED ASSIST HANDLE ON L-2 DOOR IAW B737-800 AMM 52-13-31-400-802 STEP 3G2. VERIFIED SECURED ASSIST HANDLE ON L-2 DOOR IAW AMM 52-13-31-400-802 STEP 3G2.SDR AALA202507284677Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 767 AT S25R, RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR U5QA202507180157Hinge · unsecureNOSE GEAR DOOR UNLOCK CAS AT 11000FT AT 280 KTS B3-007497 AND B3-007493. MX C/A: R&R RH & LH NLG FWD DOOR HINGE BOLTS WITH NEW. C/W SUCCESSFUL RH & LH NLG DOOR PROX SWITCH RIGGING, SWUNG GEAR SEVERAL TIMES WITH SATISFACTORY RESULTS IAW CL-300 AMM 32-22-00, 32SDR CALA2025072406865Skin · dentedCUSTOMER REQUEST - REPLACE AFT CARGO DOOR EXTERNAL SKIN. REMOVED AND REPLACED AFT CARGO DOOR SKIN IAW SRM 52-30-01-2R-3, AND DWG 146A6110.SDR CALA2025072406864Rib · crackedRIGHT HORIZONTAL STAB RIB HSS 92.70, STIFFENER NR 1 CRACKED AT LOWER TRANSITION RADIUS. ACCOMPLISHED REPAIR AT RT HORIZ STAB RIB HSS 92.70, STIFFENER NR 1 IAW SRM 55-10-09-2R-5.SDR SWAA2025072392792Baffle · crackedFWD CARGO BS 500A - 500B, LBL 25 BAFFLE IS CRACKED. R & R BAFFLE IAW DWG 143A7505 REV -, & SRM 51-40-02-0G-0.SDR SWAA2025072392793Baffle · damagedFWD CARGO BS 500 - 500A, LBL 25 BAFFLE. AFT FASTENER HOLE IS ELONGATED WITH NO ED. R & R BAFFLE BS 500 - 500A, LBL 25 IAW SRM 51-40-02-0G-0.SDR DALA2025072305534Engine · fireSHIP 1812 - ATB- -IFSD- LEFT ENGINE FIRE ON TAKEOFF, PERFORMED ENGINE IFSD. CORRECTIVE ACTION: FOUND SEVERE DAMAGE TO THRUST REVERES AND CORE COWLS. ENGINE CHANGE AND REPAIRS IN PROGRESS.SDR YENA2025072300750Cargo · odorFLT#22, PBI-BOS. "JET SMELLS LIKE DEAD TUNA. SMELLED ALL DAY. COMING FROM THE VENTS; FOUND FISH RESIDUE IN FWD CARGO. COMPLIED WITH INFORMATION NOTICE 2017-T015 SECTION A. ISOLATED FAULT TO TYPE 10 FISH ODOR IN FWD CARGO PER TSM 05-50-00-810-085-B. CLEANED CARSDR DALA2025072305521Bottle · low pressureSHIP 3270 DISC: L1 PAX DOOR ASSIST BOTTLE PSI LOW. SERVICED L1 PAX DOOR ASSIST BOTTLE PER A320 AMM 52-10. SERVICED TO 1700 PSI. NO LEAKS NOTED. (LP: 7298088)SDR ASAA2025071859575Lens · detachedROW 18/17 EXIT ROW LENS FELL FROM CEILING. GROUNDED - YES. REINSTALLED ROW 18/17 OVERHEAD EXIT SIGN LENS REF. AMM 33-51-01. OK FOR SERVICE.SDR DALA2025072205517Stop Fitting · deterioratedSHIP 3155 DETERIORATED DOOR STOP 3,4,5 AFT SIDE AND 2,3,4 FWD SIDE OF THE PASSENGER CREW DOOR 831. CORRECTIVE ACTION: REPLACED DOOR STOP 3,4,5 AFT SIDE AND 2,3,4 FWD SIDE OF THE PASSENGER CREW DOOR 831 AS PER A320 FAM AMM 52-11-31-000-002-A. (1093007).SDR SWAA2025072292604Connector · disconnectedEMERGENCY LIGHT AT SEAT 17 FED AND 18 FED FOUND INOPERATIVE. UPON FUTHER INVESTIGATION FIND AISLE EMERGENCY LIGHT AT SEAT ROW 17-18 FED NOT CONNECTED CONNECTORS D14830/D14816; RECONNECTED LIGHT CONNECTORS AND PERFORMED GOOD TEST PER AMM 33-51-00-720-801.SDR SWAA2025072293004Unknown · odorFLIGHT ATT. REPORT SMOKE SMELL IN CABIN. CONDITIONAL INSPECTION ACCOMPLISHED IAW AMM 05-51-56. PERFORMED IFIM TASK 21-00-00-810-830. NO DEFECTS FOUND.SDR DALA2025072205513Engine · unknownSHIP 3502 - RTB - DUE TO PASSENGER AT SEAT 20J NOTICED SMOKE COMING FROM THE BOTTOM OF THE #2 ENGINE AND ADVISED THE FA. THE FA CONTACTED THE FLIGHT DECK AND THE TAKEOFF WAS REJECTED. PERFORMED GVI AND RAN #2 ENGINE FOR 5 MINS. CONFIRMED NO SMOKE FROM EXHAUSSDR DALA2025072205504Skin · corroded(LOG 1092450) DURING HCK AT QRO, WHILE PERFORMING LOWER FUSELAGE AND NOSE LANDING GEAR INSPECTION PER WC 5300-2422, CORROSION WERE FOUND AFFECTING THE FUSELAGE AIRPHONE ANTENNA AREA BETWEEN STA 747 AND STA 767, AND BETWEEN S-27R TO S-27L, COMMON TO THE SKIN & SDR DALA2025072205503Fuse · failed(LOG 7361486) DURING SVC FOUND AFT LH AND RT OVERWINGS EMERGENCY EXIT LIGHT INOP. BAD FUSE AT BATTERY PACKA AT M01695.REPLACE FUSE PER WDM 33-51. OPS CK NORMAL.SDR DALA2025072205502Channel · corroded(LOG 1093112) CORROSION_ON LH ZEE CHANNEL SIDEPLATE AT FLOOR STRUCTURE BTW STA 727-847 AND LBL 21 AT AFT CARGO COMPARTMENT. SIDE PLATE ON LH FLOOR STRUCTURE BTW STA 727F TO 777 AND LBL 21 WAS REPLACED PER B737- 800 SRM 51-40-02-0G. SIDEPLATE AT FLOOR STRUCTURESDR DALA2025072205501Web · corroded(LOG 1092841) CORROSION_ON UPPER/LOWER SKIN ON RH FLOOR SHIELD BTW STA 767-793 AT AFT CARGO COMPARTMENT. NEW SHIELD ON BTW STA 767-793 AT AFT CARGO COMPARTMENT P/N 146A8127-3 WAS FABRICATE DWG 146A8127 REV. C AND WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025072205500Floorbeam · corroded(LOG 1092303) MAIN CABIN WET AREA HAS CORROSION ON UPPER SURFACE AND ON PREVIOUS REPAIRS STA 986.5 FROM RBL 30- RBL 43. ACCOMPLISH REPAIR AT MAIN CABIN AFT WET AREA FLOOR BEAM FROM RBL 60 TO LBL 60 IAW B 737 SRM 53-70-51-2R PROC 4.SDR DALA2025072205499Intercostal · corroded(LOG 1092249) AFT CARGO COMPARTMENT UNDER VACUUM WASTE COMPARMENT STA 867 TO 847 LBL 25 HAS CORROSION. REMOVED AND REPLACED AFT CARGO INTERCOSTAL UNDER VACUUM WASTE COMPT STA 847-867 LBL 25 IAW B 737 SRM 51-40-02.SDR KY7A2025072200038Control Unit · failedFLAP LOW SPEED MESSAGE IN FLIGHT. FLAP FAILED WHEN PUTTING FLAPS DOWN. REPLACED FLAP ELECTRONIC CONTROL UNIT. IAW 27-53-02 OGC.SDR UIEA2025071800972Elec Connector · disconnectedELEC DRIVE 1 ADVISARY MESSAGE. DRIVE DISCONNECTED IAW QRH. FOUND #1 ENG CONNECTOR D85125 ON FIREWALL DISCONNECT. AW0317 INTERNALLY SHORTED ON 9 WIRES. REMOVED AND REPLACED CONNECTOR D85125 IAW SWPM 20-63-13. REMOVED AND REPLACED CONNECTOR D8417J IAW SWPM 20-SDR VNAA2025072211102Skin · puncturedPUNCTURE DAMAGE FOUND ON AFT FUSELAGE BETWEEN FS1031 AND FS1051 AND STGR 20 AND STGR 21 FOLLOWING SERVICE CART CONTACT / ALL WORK PERFORMED BY CRUCIAL UNDER W/O # 216.1.1. REPAIRED RH SIDE OF FUSELAGE IAW REO # 670-53-61-2526. NO DEFECTS AT THIS TIME.SDR VNAA2025072211101Actuator · failedFLAPS FAIL ON TAKE OFF. COMPLETED INSTALL OF LH #3 FLAP ACTUATOR IAW CRJ 900 AMM 27-52-09-400-803 AND LH #4 FLAP ACTUATOR IAW AMM 27-52-09-400-804. OPS CHECK GOOD.SDR AALA202507224215Thrust Link · wornAIRCRAFT IN BASE MAINTENANCE: NR 1 ENGINE FORWARD MOUNT OUTBOARD THRUST LINK CHAFED / WORN. REPLACED THRUST LINK PER AMM 71-21-12-400-001-A.SDR AALA202507229614Slide · low pressureAIRCRAFT WAS NOT GROUNDED: WHEN ARMING DOOR 3L, THE #1 FLIGHT ATTENDANTS INFORMATION SCREEN SHOWS, SLIDE PRESSURE LOW. (OPEN)SDR AALA202507221867Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ENGINE AFT MOUNT INBOARD LINK UPPER INNER PIN SHOWS GOUGE AND PITTING MARKS. REPLACED PIN PER TASK CARD 26C45071001.SDR AALA202507224531Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ENGINE AFT MOUNT CENTER LINK UPPER INNER PIN SHOWS GOUGE MARKS AND PITTING. REPLACED PIN PER TASK CARD 26C45071001.SDR DXTA2025072204296Pcb · faultedELEC EMER L CAS MESSAGE IN FLIGHT. CORRECTIVE ACTION: SWAPPED POSITIONS OF LH AND RH PCB. OPS CHECK GOOD. IAW AMM 24-60-11SDR DXTA2025072204292Uplock Switch · defectiveLEFT MAIN GEAR HAS YELLOW X WHEN EXTENDED. RAN CHECKLIST AND GEAR STILL DOES NOT SHOW DOWN AND LOCKED. CORRECTIVE ACTION: REPLACED LH MLG UPLOCK SWITCH OPS CHECK GOOD IAW CE680A AMM 32-32-25SDR DXTA2025072204291Adc · defectiveIN LEVEL FLIGHT AT 6000 FT GEAR & FLAPS UP SPEED 250 KTS. WE GOT AN AMBER ALT BOX MESSAGE ON BOTH PFD'S AND AN EFIS MISCOMPARE ICAS MESSAGE. LEFT ALT (6000) RIGHT ALT (5850) STBY ALT (5800) RAN QRH AVNC 02-5 EFIS MISCOMPARE B3 CODE TO FOLLOW B3-007890 NO ADC-2SDR CALA2025072206840Access Door · missingPDA 1 ENG #2 OIL SERVICING DOOR MISSING ON ARRIVAL. PRESUME PANEL DEPARTED FROM AC LOGPAGES 5605104, 5605196 ASSOCIATED WITH THIS LOGPAGE... INSTALLED NEW OIL SERVICING DOOR ON ENG #2 REF AMM 71-11-04-038-075-R00.SDR AALA202507210805Emer Light Sys · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT SIGN ON SIDEWALL AT 16A HAS FALLEN OFF. RESECURED PER FIM 33-50-00-810-801.SDR AALA202507217156Life Vest · openAIRCRAFT WAS NOT GROUNDED: LIFE VEST AT FLIGHT ATTANDENT AFT SERVICE DOOR JUMP SEAT SEAL OPENED. REMOVED AND REPLACED 4R FLIGHT ATTANDENT JUMPSEAT LIFE VEST. PER CMM DBF200.SDR AALA202507210905Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTS THAT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBEDDOOR. PER GPM 17-11-4.SDR AALA202507210408Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS JAMMED. LUBED AFT LEFT LAVATORY DOOR.SDR AALA202507211342Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: ONE EMERGENCY EXIT BULB INOPERATIVE AT AFT EMERGENCY EXIT DOOR AT ROW 16ABC. REMOVED AND REPLACED LEFT HAND FORWARD OVER WING EMERGENCY EXIT LIGHT. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202507217366Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: TWO EMERGENCY EXIT BULBS INOPERATIVE AT FORWARD OF EMERGENCY EXIT DOOR AT ROW 16ABC. REMOVED AND REPLACED EMERGENCY EXIT LIGITHING PANEL. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.