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 DXTA2025070304103Yoke · out of adjustCAPTAIN CONTROL YOKE: IN THE AIR WHEN THE YOKE IS CENTERED, THE AIRPLANE WILL TURN TO THE LEFT. WHEN THE AIRPLANE IS CENTERED THE YOKE IS OFF TO THE RIGHT. THERE IS A SPLIT BETWEEN THE LEFT AND RIGHT YOKE. THE LEFT YOKE IS OPERATING NORMALLY. FOUND LEFT YOKE TSDR WX0A2025070232480Epsu · no test(AIRCRAFT NOT GROUNDED) DURING TASK CARD A32X-335100-03-1-001, ESPU BAT CAP TEST FAULTING BATTERIES 10WL AND 12WL REMOVED & REPLACED EPSU'S IAW AMM 33-51-38-000-001-A & AMM 33-51-38-400-001-A.SDR YENA2025070200673Control Unit · failedFLT#1908, CDG-JFK. "L2 TSI – HIGH LEVEL SENSOR FAULT DUE TO AVIATAR REPORTING THE FOLLOWING FAULT FUEL ACT AFT 1 HI LVL IAW TSM 28-46-00-810-873-A. IF NO FAULTS ARE FOUND, REPLACE AUXILIARY LEVEL SENSING CONTROL UNIT (ALSCU) (60QJ) PER AMM 28-46-35. C/W ALL GMSDR YENA2025070200672Unknown · odorFLT#1318, JFK-BOS. "ON TAKEOFF ROLL AND CLIMB OUT HAD A STRONG DIRTY SOCK SMELL IN THE FLIGHT DECK RAN ISOLATION CHECK LIST SMELL / ODOR DISSIPATED CLIMBING THRU FL 250; ACCOMPLISHED FIM TASK BD500-A-J21-22-00-00AAA-423A-A A EXT VISUAL WALK AROUND AND OPS CHK SDR IPXA2025070294419Fire Detector · false activationFIRE WHEEL WELL WARNING ON GROUND. FOUND WHEEL WELL FIRE CARD YLPA024 NOT PROPERLY FITTED. REMOVED, REINSTALLED AND TESTED WHEEL WELL FIRE CARD PER AMM 26-17-00 PB 501 REV 47. TEST PASS.<BR>RUN ALL PACKS FOR 10 MINUTES PER AMM 21-51-00 PB 501 REV 47. NO FAULT SDR AALA202507020782Control Valve · faultedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAX DUE TO THE FLIGHT CREW REPORTING AN ENGINE #2 TIP CONTROL FAULT ECAM MESSAGE DURING CLIMBOUT WHICH ALERTED APPROXIMATLEY 8 TIMES. THE AIRCRAFT LANDED SAFELY AT LAX WITHOUT FUSDR YENA2025070200669Warning Message · false activationFLT#523, JFK-LAX. (ETOPS) 'ENG 2 IP VALVE CLOSED. ECAM AIR BLEED FAULT; UNABLE TO DUPLICATE FAULT. PERFORMED MULTIPLE ENGINE RUNS, ALL BLEED VALVES OPERATE NORMAL, ALL PARAMETERS NORMAL PER AMM 71-00-00-860-823-A.'SDR JJBA20250702026Lamp · inoperativeEXIT ROW 18A OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXIT ROW 18A OVERHEAD EMERGENCY LIGHT. OPS CHECK SAT.SDR DXTA2025070204096Static Wick · brokenDURING TOW OF N541QS THE THIRD STATIC WICK FROM THE WINGTIP OF THE LEFT WING MADE CONTACT WITH THE RIGHT LEADING EDGE OF N959QS AND BROKE OFF. CORRECTIVE ACTION; VISUALLY INSPECTED LEFT WING TRAILING EDGE. THE ONLY DAMAGE APPEARS TO BE A BROKEN STATIC WICK. RESDR DXTA2025070204099Shutoff Valve · defectiveOUTBOARD BREAKS FAIL CAS DURING PARKING AT THE RAMP WITH ENGINES RUNNING AND HYDRAULIC SYSTEM ON AND NORMAL PRESSURE. REPLACED OB BRAKE SHUT OFF VALVE IAW CL350 AMM 32-43-25. OPERATIONAL TEST CARRIED OUT SERVICEABLE.SDR CALA2025070206152Arming Lever · fodDOOR 2L WAS DIFFICULT TO DISARM. DOOR L2 SLIDE ARMING MECHANISM INSPECTED DEBRIS CLEARED FROM THE LOWER FITTING. DOOR ARMING NORMALLY UPON SEVERAL ATTEMPTS. AIRCRAFT FIT FOR FLIGHTSDR CALA2025070206147Lamp · inoperativeEMERGENCY EXIT LIGHTS "NOT ARMED" LIGHT NOT ILLUMINATING RELAMPED AS REQUIRED, OPS CHECK GOOD PER AMM 33-12-00-710-001-A.SDR CALA2025070206146Fuse · openEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - FOUND SLIDE OVERWING LIGHT AND SLIDE LIGHT INOPERATIVE AND NEEDS FUSES. COMPLIED WITH. REF FIM 33-50/801 REMOVED AND REPLACED POWER SUPPLY FUSES, RT AFT, & RT FWD IAW AMM 33-51-06-960-804 WDM 33SDR CALA2025070206145Girt Bar · out of adjustEMER EXIT 1R GIRT BAR IS LOOSE. ADJUSTED GIRT BAR MATERIAL IAW AMM 25-66-01.SDR HALA20250701203Controller · faultedETOPS - IN FLIGHT, COCKPIT TEMP 56F WITH CONTROLLER AT 12:00 POSITION PERFORMED ZONE CONTROL RESET, NO HELP COCKPIT TEMP 52F WITH CONTROLLER FULL HOT. REMOVED & REPLACED ZONE CONTROLLER PE AMM 21-63-34/400. ECS SYSTEM TEST PASSED. OK FOR SVC.SDR DALA2025070104947Frame · dentedSHIP 663 IN REF TO: NRC 00052: AFTER REMOVAL SIDEWALL PANELS: DENT ON FRAME 1560 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT. FRAME 1560 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT WAS REPAIRED PER B757-200 SRM 53-00-07-2R PROCEDURE 5 REPAIR 5. (105612SDR DALA2025070104946Frame · dentedSHIP 6711 DENT ON FRAME BTW FUS STA 1540 AND STRG 25LH AT AFT CARGO COMPARTMENT. FRAME BTW FUS STA 1540 AND STRG 25LH AT AFT CARGO COMPARTMENT WAS REPAIRED PER B757-200 SRM 53-00-07-2R PROCEDURE 5 REPAIR 5 FIG 201 DETAIL II. (1055383)SDR DALA2025070104945Frame · dentedSHIP 6711 DENT ON FRAME BTW FUS STA 1540 AND STRG 25LH AT AFT CARGO COMPARTMENT. FRAME BTW FUS STA 1540 AND STRG 25LH AT AFT CARGO COMPARTMENT WAS REPAIRED PER B757-200 SRM 53-00-07-2R PROCEDURE 5 REPAIR 5 FIG 201 DETAIL II. (1055374)SDR DALA2025070104943Frame · dentedSHIP 663 IN REF TO: NRC 00052: AFTER REMOVAL SIDEWALL PANELS: DENT ON FRAME 1560 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00154: FRAME 1560 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT WAS REPAIRED PER B757-200 SRM 53SDR SWAA2025070186719Control Module · failedAUTO FAIL LIGHT CAME ON AT FL370. RAN QRH. COULD NOT CONTROL PRESSURIZATION IN MANUAL. REMOVED AND REPLACED PER AMM 21-31-02-401-NG (CABIN PRESSURE CONTROL MODULE - REMOVAL/INSTALLATION - PERMANENT)SDR SWAA2025070186835Tailpipe · fire#2 ENGINE TAILPIPE FIRE REPORTED. EXTINGUISHED AFTER SHUTDOWN. NO ABNORMAL ENGINE INDICATIONS<[01] INSPECTED #2 ENGINE IN REF TO AMM 71-00-00-800-803-F00. NO OIL PUDDLING. FLAME ARRESTOR HONEYCOMB NOT DAMAGED. A/C OK FOR SERVICESDR DALA2025070104941Uplock · damagedSHIP 3265 EICAM L/G DOOR NOT CLOSED AFTER T/O MESSAGE CLEARED UP ON ITS OWN, AT ABOUT 3000FT AGL MAINTENACE CONTACTED INITIAL PAR. COMPLETED INDUCTANCE CHECK OF PROX SENSOR 30GA & 31GA REF A320 AMM 32-31-73-820-008A. R/R PROX SENSOR 30GA AND 31GA REF A320 AMMSDR DALA2025070104938Gasket · leakingSHIP 3273 PRIOR TO BOARDING, NOTICED DIRTY SOCK ODOR IN CABIN. SMELL WENT AWAY WITH APU BLEED CLOSED. CLEANED APU AIR INTAKE & COMPARTMENT PER WORK CARD 4916-2001( 671052) C/W AMDS WORKCARD 4900-2001. FOUND OIL PUMP GASKET IN POOR CONDITION, R&R GASKET PER ASDR DALA2025070104937Wire · pulledSHIP 3268 DISC: EMERGENCY CLEAR PATHWAY LIGHT AT ROW 32DEF INOP. C/A: FOUND WIRES FOR ROW 32DEF ESCAPE PATHWAY LIGHTING PULLED FROM ITS SPLICE UNDER THE SEAT TRACK COVERS BEHIND ROW 33DEF. REPLACED SPLICE AND CRIMPED NEW CONTACTS REF. A320 ESPM 20-43-13 . OPS SDR DALA2025070104936Battery Pack · inoperativeSHIP 1820 SEAT 50GF THRU 56GF EMER LIGHT INOP CORRECTIVE ACTION: REMOVED AND REPLACED BATTERY PACK OF POWER SUPPLY M734. OPS CHECK GOOD .REF B767 AMM 33-51-07 (1054145)SDR DALA2025070104935Sensor · out of adjustSHIP 3162 AFTER TAKE OFF AFT CARGO DOOR CAUTION MESSAGE. CORRECTIVE ACTION: ADJUSTED 32WV SENSOR REF A319 AMM 52- 71. (7216970).SDR DALA2025070104932Access Panel · crackedSHIP 3169 CRACK ACCESS PANEL 322AL LEADING EDGE ON VERTICAL STABILIZER. CORRECTIVE ACTION: COMPLIED WITH ER/A 627102-14. (1055140).SDR DALA2025070104931Access Panel · crackedSHIP 3169 CRACK ACCESS PANEL 322BL LEADING EDGE ON VERTICAL STABILIZER. CORERCTIVE ACTION: COMPLIED WITH ER/A 627100-14. (1055104).SDR SIMA20250630002Motor · failedDURING SHORT FINAL CA WIPER GOT STUCK, POSSIBLE BURNING SMELL. CMH PERFORMED WORKSCOPE AND DID NOT DETECT ANY BURNING OR OTHER ODORS. RAR WINDSHIELD WIPER MOTOR UNIT IAW AMM 30-41-01/400. RAR WIPER BLADE IAW AMM 30-41-04/400. NO DEFECTS NOTED. OPS CHECKS GOOD.SDR IPXA2025063094419Fire Warning · false indicationFIRE WHEEL WELL WARNING ON GROUND FIRE TEST ACCOMPLISHED IAW AMM 26-10-00-501 REV.47, TEST PASSED, BUT WHEEL WELL FIRE EICAS COMES BACK AFTER TEST, EICAS BRAKE TEMP INDICATION IS AVAIL, WHEEL WEEL FIRE DETECTION SYSTEM DEF IAW MEL 26-17-1A REV.14, DMP ACCOMPLISDR IPXA2025070185694Crash Axe · corrodedFOUND MAIN CARGO DECK CRASH AXE RUSTY. R&R MCD CRASH AXE IAW AMM 25-60-00.SDR IPXA2025070185943Floor Panel · dentedMAJOR REPAIR, FOUND MAIN DECK CARGO FLOOR PANEL DENT AT PANEL NR 232NFF. IAW AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND PERFORM G.V.I CHECK RESULT WAS NORMAL. IAW AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL SESDR IPXA2025070186019Floor Panel · crackedMAJOR REPAIR, FOUND MAIN DECK CARGO FLOOR PANEL CRACK AT PANEL NR 232BFF. IAW AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND PERFORM G.V.I CHECK RESULT WAS NORMAL. IAW AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL SEALASDR IPXA2025070185937Floor Panel · crackedMAJOR REPAIR, FOUND MAIN DECK CARGO FLOOR PANEL CRACK AT NR 251XFF I.A.W AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL AND PERFORM G.V.I CHECK RESULT WAS NORMAL. 2.I.A.W AMM 53-01-06-000-801 REV.145 REMOVE MAIN DECK CARGO FLOOR PANEL SEALANSDR IPXA2025070198049Warning Light · false activationFUEL CONFIGURATION ANNUNCIATOR LIGHT ILLUMINATED AFTER REACHING CRUISE AT 36000€™ DUE TO AN IMBALANCE BETWEEN LEFT MAIN AND RT MAIN TANK.(RT TANK LOWER THAN LEFT BY 1,900LBS). ++ALL MAIN & CTR PUMPS WERE T/SHOOT PER FIM 28-41-FAULT TREE854, NO FAULT FOUND. A/SDR AALA202507017427Elec Connector · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 16F EXIT LIGHT FLICKERING. SECURED CONNECTION AT 16F SIDEWALL LIGHT AND OPERATIONAL CHECK IS GOOD. PER AMM 33-20-00.SDR AALA202507018080Fitting · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT SERVICE DOOR GIRT BAR IS TOO TIGHT TO REMOVE AND INSERT. LUBRICATED GIRT BAR SLIDE PACK SPRING STOW FITTING. OPERATION CHECKED NORMAL. PER MM 25-66-01.SDR DALA2025070104925Frame · damagedSHIP 3406 AFT SIDE OF FR62 UPPER EDGE HAS TOOLING DAMAGE BETWEEN STRINGERS 3R + 4R, 2 SPOTS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-73-11. (1055783)SDR DALA2025070104924Frame · damagedSHIP 3406 AFT SIDE OF FR62 HAS 2 SPOTS OF TOOLING DAMAGE AT TOP OF FRAME BETWEEN STRINGERS 1L ND 2L. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-73-11. (1055769)SDR DALA2025070104923Frame · damagedSHIP 3406 AFT FACE OF FR61 AT STR 4L 4EA AREAS OF TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV 0. (1055793)SDR QXEA2025070100271Light · looseEMERGENCY FLOOR LIGHTING STRIP MISSING NEAR 6B. REMOVED FROM SERVICE. RESECURRED LIGHTING STRIP. NO DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR DALA2025070104885Floorbeam · corroded(LOG 1055538) CORROSION WAS FOUND BELOW FITTING ON BEAM (UPPER FLANGE) OF BS947.5 BTW RBL 54 AT W2. BEAM OF BS947.5 BTW RBL 54 AT W2 WAS REPAIRED PER B737-800 SRM 53-70-51-2R REPAIR 5.SDR KCSA2025063034Handle · out of positionENGINE-INDICATING AND CREW-ALERTING SYSTEM: DOOR FLIGHT DECK OVERHEAD PRESSURE NORMAL. UPON FURTHER INVESTIGATION FOUND HANDLE NOT FULLY IN CLOSED POSITION. OPENED AND CLOSED DOOR IAW B747-400 AMM 52-21-00 OPERATIONAL CHECK GOOD NO DEFECTS NOTED NO FURTHER ACSDR DALA2025070104880Web · corrodedSHIP 9500 AFT CARGO DOOR THRESHOLD WEB CORRODED SEVERAL LOCATIONS AT UPPER AND LOWER SURFACES. CORRECTIVE ACTION: REMOVED AND REPLACED WEB PER B717 DWG 5910158 (1055786)SDR DALA2025070104879Eec · faultedSHIP 9505 -ATB- DUE TO LEFT ENGINE NOT MAKING EPR ON CLIMB OUT. CORRECTIVE ACTION: REPLACE EEC, FUEL FLOW TRANSMITTER, AND FMU. NO HELP, REPLACED FUEL PUMP AND FILTER. OPS CHECK NORMAL.(7479280)SDR DALA2025070104876Not Entered · no discrepancy9500 REPETITIVE INSP PER SECT II. OF ERA 627055-14 REV A. CORRECTIVE ACTION: ACCOMPLISH SECTION II: REPETITIVE INSPECTIONS EVERY EIGHT THOUSAND (8,000) FLIGHT CYCLES FROM ACCOMPLISHMENT OF SECTION I: PERMANENT REPAIR PER ER/A 627055-14 REV A. (1055040)SDR DALA2025070104875Hinge Fitting · corrodedSHIP 9572 DURING HCK AT QRO, CORROSION WAS NOTED ON THE LH INBD T/R FWD FLAP HINGE FITTING, XW 251. CORRECTIVE ACTION: ER/A REVISION REQUIRED TO INCORPORATE DTE IS REQUIRED WITHIN 24 MONTHS FROM 24JUN2025. IF ER/A REVISION IS NOT ACCOMPLISHED BY 23JUN2027, REMSDR REXA2025070100704Battery Pack · no testWHEN EMERGENCY LIGHTS SELECTED ON, EXT LIGHTS DO NOT TURN ON AND INT LIGHTS GO FROM DIM TO OFF. R & R PS43 ESPU BATTERY PACK IAW J/C 33-900-701 NO ISSUES NOTED, AIRCRAFT GOOD FOR SVC.SDR AALA202507010782Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAX DUE TO THE FLIGHT CREW REPORTING AN ENGINE #2 TIP CONTROL FAULT ECAM MESSAGE DURING CLIMBOUT WHICH ALERTED APPROXIMATLEY 8 TIMES. THE AIRCRAFT LANDED SAFELY AT LAX WITHOUT FUSDR AALA202507013111Lever · looseAIRCRAFT WAS NOT GROUNDED: ARMING LEVER 2L IS LOOSE. MAINTENANCE TIGHTENED BOLT ON INNER ARMING LEVER AT 2L PER AMM 52-10-00.