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 DALA2025081506115Receptacle · corrodedCORROSION BORE SPIGOT FITTING RECEPTACLE ON LT PYLON. REPLACED SPIGOT FITTING RECEPTACLE ON LH PYLON AS PER A319 SRM 51-74-00, AS PER A319 SRM 54-51-12-283-001, AS PER A319 SRM 51- 44-11-801 AND AS PER A319 SRM 54-51-12-300-001.SDR DALA2025081506114Skin · corrodedLEFT WING TOP SKIN PANEL 2 LOWER SURFACE, TRAILING EDGE, OVERHANG AREA AT RIB 10 CORRODED. COMPLIED WITH ER/A 627460-14AD.SDR DALA2025081506113Skin · corrodedLEFT WING TOP SKIN PANEL 2 LOWER SURFACE, TRAILING EDGE, OVERHANG AREA AT RIB 14 CORRODED. COMPLIED WITH ER/A 627460-14AD.SDR DALA2025081506129Bushing · excess playLEFT WING NR 3 SPOILER WITH PLAY,IT HAS 1.77 MM. REPLACED BEARINGS SLEEVES AND BUSHINGS AT LH WING SPOILER #3 AND CENTER HINGE BRACKET IAW CMM 57-72-21 AND SRM 57-72- 12.SDR DALA2025081506128Sleeve · excess playRIGHT WING NR 2 SPOILER WITH PLAY,IT HAS 1.50 MM. CORRECTIVE ACTION: REPLACED BEARINGS SLEEVES AND BUSHINGS AT RH WING SPOILER NR 2 AND CENTER HINGE BRACKET IAW A319 CMM 57-72-21 AND A319 SRM 57-72- 12.SDR DALA2025081506127Bushing · excess playLEFT WING NR 2 SPOILER WITH PLAY, IT HAS 1.52 MM. REPLACED BAEARINGS SLEEVES AND BUSHINGS AT LT WING SPOILER NR 2 AND CENTER HINGE BRACKET IAW CMM 57-72-21 AND SRM 57- 72-12.SDR YENA2025081500841Unknown · odorFLT#1929, BOS-SDQ. F/A REPORTS CABIN ODOR MX 270 FILLED OUT AND REPORTED TO MCC; C/W INFO NOTICE 2017 -T0151 SEE B1 ISOLATED TO TYPE 10 . INSPECTED APU AND ENGINES WITH NO LEAKS NOTED. NO ODOR PRESENT WITH EITHER APU OR ENGINE BLEED. ALSO VERIFIED OIL SERVICE SDR SWIA2025081500014Smoke Detector · warning messageCREW REPORTS 2 LAV SMOKE TOILET IN CRUISE 32000 (FLIGHT 5070 - FILED OPEN)SDR SWAA2025081504794Flashlight · no testOUTBOARD FLASHLIGHT WONT TEST. R & R THE BATTERY TO FWD OTBD FLASHLIGHT IAW SIP, OPS CHECKED GOOD.SDR SWAA2025081504800Battery · disconnectedAFT FA FLASHLIGHT INOPERATIVE. FOUND BATTERY DISCONNECTED. RECONNECTED BATTERY AND OPS CHECKED GOOD IAW AMM 33-55-00.SDR YENA2025081400840Fire Loop · faultedFLT#1023, JFK-LAX. (ETOPS) ENG 1 LOOP A FAULT ( ENGINE FIRE DETECTION SYSTEMS 1) LOOP A ); REMOVED AND REPLACED FIRE LOOP A CORE IAW AMM 26-12-17 OPS CHK GOOF MX-4 UPDATED PLACRD REMOVED MDDR CLEARED.SDR ASAA2025081546105Cover · unsecureR2 DOOR EMERGENCY LIGHT FELL OFF. GROUNDED - YES. REINSTALLED R2 DOOR EMERGENCY LIGHT LAMP COVER & AMM 33-51-01.SDR AALA202508159828Damper Plate · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT PANEL INDICATES 2R DOOR PRESSURE LOW. MAINTENANCE SERVICED 2R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508157362Track · stickingAIRCRAFT WAS NOT GROUNDED: 4L NOT INDICATING ARMED. MAINTENANCE CLEANED / LUBED TRACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-70-00 WITH NO FAULTS NOTED.SDR AALA202508157501Deu · fault messageAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT CIDS PANEL SHOWS CHECK SLIDE PRESSURE AT 3R DOOR INDICATION. MAINTENANCE ACCOMPLISHED A GROUND SCAN ON CIDS 1 AND NOTED A DEU-B 300RH6 FAULT. MAINTENANCE REPLACED DEU-B 300RH6 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL SDR AALA202508155809Damper Plate · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202508154314Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR DXTA2025081504601Door Seal · leakingON DEPARTURE ALL THINGS WERE NORMAL. AT APPROXIMATELY 6000 FEET WE HEARD A LOUD RUSH OF AIR SIMILAR TO AN EXPLOSIVE DECOMPRESSION COMING FROM THE DOOR. NO CAS MESSAGES WERE NOTED. WE LEVELED AT 7000 FEET AND RETURNED TO TETERBORO. REMOVED PASSENGER DOOR SEALSDR DXTA2025081504605Warning Light · illuminatedRED AUTO THROTTLE HOLD FAIL CAS CAME ON AT 30KTS ON TAKEOFF AND THE AUTO THROTTLES WERE REDUCING POWER AS THIS OCCURRED. PERFORMED TWO SETS OF OPS CHECKS SUCCESSFULY AND SENT AN ARES DOWNLOAD TO MCC AND TEXTRON. MCC ELECTED TO KEEP ORIGINAL A/T INSTALLED DUESDR DXTA2025081504607Steering Unit · malfunctionedUPON GEAR RETRACTION DURING CLIMB OUT, THE NOSE LANDING GEAR TOOK AN EXCESSIVELY LONG TIME TO RETRACT AND RESULTED IN A TEMPORARY NOSE GEAR DISAGREE CAS MESSAGE, AS WELL AS THE WHITE HASH MARKS ON GEAR INDICATOR. NOSE GEAR DID EVENTUALLY COME UP WITHOUT FURTHESDR DXTA2025081504609Pressure Switch · faultedAT ABOUT 5000FT AFTER TAKEOFF THE FUEL BOOST PUMP ON YELLOW CAS MASSAGE CAME ON. COMPLETED QRH AND LANDED AS SOON AS PRATICAL. RT ENG FUEL PRESSURE SWITCH, RT ENG FUEL PRESSURE SWITCH, RT ENGINE FUEL BOOST PUMP CP, RT ENGINE FUEL BOOST PUMP CP. RT ENGINE FUSDR DXTA2025081504610Float · inoperativeON CLIMB OUT WE RECEIVED A LO FUEL LEVEL L LIGHT. WE RAN THE QRH WHICH SAID TO TURN ON THE BOOST PUMP AND LAND AS SOON AS POSSIBLE. BOTH FUEL LEVELS APPEARED CORRECT BASED ON THE FUEL ADDED AT THE FBO. NO LEAKS NOTED. TAXIED AIRCRAFT TO BURN THE FUEL PER MCC'SDR DXTA2025081504612Door · out of adjustENTRY DOOR IS DIFFICULT TO OPEN. HAD TO CYCLE IT COUPLE TIMES TO GET AMBER DOOR OPEN LIGHT OUT CORRECTIVE ACTION: FOUND DOOR TOO FAR FORWARD IN FRAME (0.050 FWD AND 0.200 AFT). ADJUSTED DOOR AFT TO 0.125" FWD CLEARANCE AND 0.125" AFT CLEARANCE. PERFORMED MULSDR DALA2025081506112Sign · faultedEMERGENCY EXIT SIGN IN FLIGHT DECK OBSRV ENTRY DOOR STAYS ON IN ARMED POSITION. ROBBED EMERGENCY EXIT SIGN ASSY FROM A/C 1817. REPLACED SIGN REF B767 AMM 33-57. OK FOR SVC (7547054)SDR DALA2025081506111None · noneSHIP 1817 ROBBED PORTABLE EXIT SIGN AS SERVICABLE FOR A/C 1604. CORRECTIVE ACTION: INSTALLED PORTABLE EXIT SIGN REF B767 AMM 33-51 (7547804)SDR DALA2025081506109Brake · fireFIRE/BRAKE- #3 BRAKE FIRE ON GATE ARRIVAL. RIGHT MLG AXLE SHOWS SIGNS OF HEAT DAMAGE. REPLACED RIGHT MLG AXLE, #3 BRAKE AND WHEEL ASSEMBLY. OPS CHECKS GOOD.SDR DALA2025081506108Heater · fod(LOG 7779814) FA REPORTED FUEL AND ELECTRICAL SMELL IN THE MID TO AFT CABING AND AFT GALLEY. BOTH PACKS WERE IN AUTO AND CLIMB POWER WAS SET. DISSIPATED IN LESS THAN 5 MINUTES PER FA. INSPECTED AFT GALLEY HEATER AND FOUND IT CONTAMINATED WITH DEBRIS AND FAN NOSDR DALA2025081506107Angle · corrodedCORROSION ON LONGITUDINAL ANGLE FROM STA 312 TO STA 323.7 AND STRG S-23L AT E/E COMPARTMENT. LONGITUDINAL ANGLE FROM STA 312 TO STA 323.7 AND STRG S-23L AT E/E COMPARTMENT WAS REPAIRED PER ERA 628115-14 REV. ORIGINALSDR IPXA2025081565432Duct · crackedCRACK- DUCT, NR 1 ENG LPT ACC MANIFOLD 6:00 POS. OK TO WORKSDR DALA2025081506105Indicator · dirtySHIP 678 2R DOOR WILL NOT DISARM PROPERLY. CORRECTIVE ACTION: FOUND KNUCKLE KNOCKER STICKING ON DOOR COVER. CLEANED AREA AROUND KNUCKLE KNOCKER NOW CKS GOOD. (7107059)SDR DALA2025081506104Pushrod · out of adjustSLIDE INDICATOR LIGHT INOP OR DAMAGED. FOUND GIRT NOT ENGAGED WITH SLIDE ARMED. FOUND FWD GIRT BAR PUSH ROD OUT OF ADJUSTMENT. ADJUSTTED L4 DOOR FWD GIRT BAR PUSH ROD IAW B757 AMM 52-11. RII CW. (1143301)SDR FDEA202508141452Skin · damagedPUNCTURE ON LEADING EDGE OF OUTBOARD FLAP AT RH WING, AT 72" FROM IMBOARD EDGE. LEADING EDGE OF OUTBOARD FLAP AT RH WING, AT 72" FROM OUTBOARD EDGE WAS REPAIRED I.A.W. B-767, SRM 57-53-01-2R, FIG 201, TABLE I AND SRM 51-70-03-0G, PAR. 5.A, REV. 92, APR-15- SDR FDEA202508141451Skin · delaminatedDELAMINATION ON LEADING EDGE OF OUTBOARD FLAP AT RH WING, AT 135" FROM OUTBOARD EDGE. LEADING EDGE OF OUTBOARD FLAP AT RH WING, AT 135" FROM OUTBOARD EDGE WAS REPAIRED I.A.W. B-767, SRM 57-53-01-2R, FIG 201, TABLE I AND SRM 51-70-03-0G, PAR. 5.A, REV. 92, SDR FDEA202508141450Control Cable · damagedNOSE WHEEL STEERING PULLS SIGNIFICANTLY TO THE RIGHT. EXTREMELY NOTICEABLE ON LANDING. INSTALLED R/H NOSE WHEEL FOLLOW UP CABLE. ADJUSTED NOSE STEERING FOLLOW-UP CABLES 211A/B AND 212A/B. PERFORMED TEST ON STEERING CONTROL RANGE OF TRAVEL WITH SYSTEM CHSDR AALA202508153361Shade · stuckAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE AT EMERGENCY EXIT ROW 14 AIRCRAFT RIGHT STUCK. MAINTENANCE LOOOSENED WINDOW SHADE CABIN ROW 14 RH.SDR AALA202508158865Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: WHILE PREFORMING PS CHECK FOUND R1 DOOR EMERGENCY CYLINDER ACCUMULATOR BELOW LIMITS. MAINTENANCE CHARGED CYLINDER ACCUMLATOR IAW AMM 52-10-00.SDR UIEA2025081401123Audio Panel · odorSTRONG SMELL OF BURNING WIRE IN COCKPIT DURING PREFLIGHT. PERFORMED SMOKE OR FUME IN CABIN INSPECTION IAW FIM 21-00TASK 810. FOUND F/O CONTROL AUDIO PANEL BAD WITH ODOR. R/R PANEL IAW AMM 23-51-11. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME. HAPPENED ON GRSDR EE4Y2025081422875Battery · no testDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-335100-03-1-001 WHEN PERFORMED CABIN EMERGENCY LIGHTNING THE OPERATIONAL TEST OF EPSU BATTERY CAPACITY NOT CONFIRM TEST OK. REPLACED PAX CABIN EPSU BATTERIES IAW A320 TASK 33-51-38-000-002-A AND TASK 33-51-38-40SDR EE4Y2025081422874Skin · damagedDURING ACCOMPLISHMENT OF THE TASK A32X-ZL-151-01-1-001 SECONDARY FINDING WHEN PERFORMED WORK NR1-8 FOUND AFT CARGO COMPARTMENT DOOR PRESSURE SEAL TORN AND INNER SKIN CRACKED AT UPPER FWD CORNER AREA. REPAIRED AFT CARGO COMPARTMENT DOOR INNER SKIN AT UPPER FWD SDR 2025FA0000544Skin · crackedCRACK IN THE SKIN ON LEFT SIDE OF RUDDER EXTENDING APPROXIMATELY 2.5" FROM THE RIVET LINE JUST BELOW THE TRIM TAB. CRACK EXTENDS DOWNWARD AND AFT.SDR JR2R20250814673Attach Fitting · chafedFLOOR BOARD ATTACH FITTING ON FRAME 18 AT LBL 30 IS CORRODED OUT OF LIMTS. REPLACEDSDR SWAA2025081404361Hook And Loop · unsecureFWD ENTRY DOOR SLIDE GIRT REQUIRES ADJUSTMENT, HOOK AND LOOP NOT SECURE. RESECURED HOOK AND LOOP STRIP IAW SIP.SDR SWAA2025081404354Hook And Loop · unsecureFWD SERVICE DOOR SLIDE GIRT REQUIRES ADJUSTMENT, HOOK AND LOOP STRIP NOT SECURE. ADJUSTED SLIDE GIRT AND SECURED HOOK AND LOOP STRIP IAW SIP.SDR SWAA2025081404149Skirt · debondedPASSENGER CABIN AFT SERVICE DOOR ESCAPE SLIDE SKIRT RUBBER DISBONDED AND FRAYED<[01] R&R PASSENGER CABIN AFT SERVICE DOOR ESCAPE SLIDE IAW AMM 25-66-01. REF.#TTG8Q00PLDJQ FOR PARTS INFO.;[02] INSPECTION C/W R&R PASSENGER CABIN AFT SERVICE DOOR ESCAPE SLIDE IAWSDR SWAA2025081404179Girt Bar · out of adjustFWD SERVICE DOOR SLIDE GIRT BAR REQUIRES REPLACEMENT. R & R FWD SERVICE DOOR ESCAPE SLIDE GIRT BAR IAW AMM 25-66-01.SDR SWAA2025081404392Lamp · inoperativeR2 DOOR EMERGENCY LIGHT INOP. RELAMPED R2 DOOR EMERGENCY LIGHT BULB IAW AMM 33-51-04. OPS CHECK GOOD.SDR SWAA2025081404441Flashlight Assy · no testAFT GALLEY FLASHLIGHT NOT TESTING. OK TO CONTINUE PER MEL 25-64-02A. EMERGENCY FLASHLIGHT HOLDERS, FLASHLIGHTS. WITH SP 1B AND AUTHORIZATION NUMBER 274071. R & R AFT GALLEY FLASH LIGHT BRACKET IAW AMM 25-64-00, AND OPS CHECK GOOD.SDR SWAA2025081404505Girt Bar · no discrepancyFA STATES FWD SERVICE DOOR GIRT BAR STUCK IN STOW POS ON DOOR. PULLED GIRT BAR FROM STOWED POSITION. NO DEFECTS NOTED. REF MM 25-66-00SDR SWAA2025081404167Power Supply · inoperativeEMERGENCY EXIT LIGHT AFT OF L1 ENTRY DOOR IS INOPERATIVE. REMOVED AND REPLACED L/H FWD EMERGENCY LIGHTING POWER SUPPLY CHARGER ASSY PER M/M 33-51-06.SDR QR9R2025081400001Actuator · failedACTUATOR WARNING ILLUMINATED IN FLIGHT. YAW TRIM FAILED IN FLIGHT. REMOVED AND REPLACED SEMA ACTUATOR IAW AMM 67-20-00, 4-14; TEST FLIGHT EVAL SUCCESSFULLY COMPLETED. NO FAULTS NOTED.