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 AALA202507216943Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT 16CBA OVERHEAD LIGHT ON EMERGENCY DOOR INOPERATIVE. (OPEN).SDR NACA2025071800001Warning Light · illuminatedLEFT FWD FUEL PRESS LIGHT ILLUMINATED. NO EICAS MESSAGE.SDR ASAA2025071859535Cover · brokenF/A REPORT EXIT COVER IN GALLEY 1 IS BROKEN. GROUNDED - YES. REATTCHED G1 EXIT SIGN COVER AS NECESSARY.SDR DALA2025072105488Stringer · damagedSHIP 3416 FRAME 64 ON 1R STRINGER TOOLING DAMAGE NEXT TO FASTENER.MARKED IN RED. COMPLIED WITH ER/A 627461-14.SDR DALA2025072105489Stringer · damagedSHIP 3416 DAMAGE ON FWD FASTENER HOLE ON I/B FACE OF STRINGER 1R AT FRAME 64. COMPLIED WITH ER/A 627461-14.SDR DALA2025072105486Light · inoperativeSHIP 3436 ON SERVICE FOUND 2R (AFT) MOUNMENT-DIVIDER WALL WITH RED/WHITE EMERGENCY LIGHT INOP. R & R FEEMPS-EDGE MOUNTED LIGHT AT 2R DIVDER WALL. REF 330 AMM 33-15. ESPM 20-48. (7292934).SDR DALA2025072105479Rivet · misinstalledSHIP 3316 FOUND IMPROPERLY INSTALL RIVETS AND HOLE DAMAGE ON STR 3L AT FRAME 61. CORRECTIVE ACTION: COMPLIED WITH ER/A 627856-14. (1092119).SDR AALA202507215038Rvdt · faultedAIRCRAFT WAS GROUNDED: DURING CLIMBOUT ECAM ENG2 COMPRESSOR VANE ANNUNCIATED ACCOMPLISHED ECAM PROCEDURES. ECAM ANNUNCIATED A SECOND TIME AND CLEARED ON ITS OWN. DECESION MADE TO RETURN TO MIA, EMERGENCY WAS DECLARED AND AIRCRAFT LANDED OVERWEIGHT WITHOUT INCDSDR SWI2025F01005Rib · crackedRH WING BAT RIB AT WS14.50 CRACKED ALL THE WAY THROUGH TO THE LIGHTNING/PASS-THROUGH HOLE. CRACK LOCATED APPROXIMATELY 7 INCHES AFT OF THE REAR SPAR. THIS DISCREPANCY IS CONSIDER A MAJOR REPAIR. (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR SWIA2025072100018Window · smokeWHILE IN THE DESCENT, HEARD A NOISE COME FROM THE LOWER PART OF THE CAPTAINS SIDE WINDOW. ALSO OBSERVED A SMALL AMOUNT OF SMOKE COMING FROM THE LOWER ELECTRICAL SUPPLY ATTACHMENT POINT ON THE CAPTAIN€™S SIDE WINDSHIELD. CONFIRMED WITH CA THAT IT WAS THE CA SDR DALA2025072105476Indicator · faultedSHIP 3128 ECAM DR PAGE IND - PASSENGER DRS / CABIN EMERG EXIT - CLSD IND R2. R/R RT FWD SLIDE ARMED IND LIGHT PER A319 52-73. (7281750).SDR DALA2025072105471Support Bracket · corrodedCORROSION ON SAFETY SUPPORT BRACKET ON FWD SLIDE DOOR 841. REMOVED AND INSTALLED SLIDE ON DOOR 841 IAW AMDS CARD 2561-4004.SDR SWAA2025072192771Slide · obscuredFWD SERVICE EMERGENCY DOOR SLIDE DATE UN-READABLE. R&R FWD SERVICE DOOR EMER ESCAPE SLIDE PER 825-PRD-01-01-FSSDR SWAA2025072192500Seat · out of alignmentCABIN SEAT RECLINE NEEDS TO BE INOP AT 11F (EXIT ROW). ADJUSTED SEAT 11F IAW AMM 25-22-00.SDR SWAA2025072192774Slide · dislodgedFWD SERVICE DOOR SLIDE FELL OUT OF HOLDER. REINSTALLED FWD SERVICE DOOR SLIDE.SDR SWAA2025072192498Isolator · crackedAFT ENTRY DOOR FWD UPPER SLIDE ISOLATOR IS CRACKED. R&R AFT ENTRY DOOR FWD UPPER SLIDE ISOLATOR IAW SRM 51-40-02.SDR SWAA2025072192647Battery · inoperativeALL 3 LH OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. R & R LH OVERWING EMERGENCY LIGHT BATTERY IAW AMM 33-51-06.SDR SWAA2025072192999Sign · detachedEMERGENCY EXIT LIGHT MID CABIN FELL OFF. SECURED EMERGENCY EXIT SIGN AT MID CABIN IAW AMM 33-51-01 ;LIGHT OPS CHECK NORMAL.SDR SWAA2025072192481Lamp · inoperativeFWD RH R1 SLIDE EMERGENCY LIGHT INOP. RE-LAMPED FWD RH R1 SLIDE EMERGENCY LIGHT IAW 33-51-04.SDR SWAA2025072192496Bracket · crackedVERTICAL BRACKET CRACKED UNDER FWD INBD CORNER OF PANEL 551AT. REMOVED & REPLACED VERTICAL BRACKET UNDER FWD INBD CORNER OF PANEL 551AT. I.A.W. SRM 51-40-02.SDR YENA2025072100739Slide · unwanted deployFLT#462, SJU-BOS. INADVERTENT SLIDE DEPLOYMENT L3 DOOR; REMOVED AND REPLACED L3 DOOR SLIDE. REF AMM 25-62-47.SDR YENA2025072100738Door · faultedFLT#250, SAV-BOS. (AN EMERGENCY WAS DECLARED) DMC 1B FAIL W/ FOLLOWING MSGS: 73 L/R ENGINE FAULTS, NWS FAULT 21 L/R AIR SYS FAULTS L/R IASC ARING INPUT LOSS 26 FIRE SYS FAULT - A429 INPUT LOSS 27 FLAP FAULT - INPUT REDUN LOSS COCKPIT DOOR FAIL, A/THR FAIL; RESDR GTIA2025072138999A/C Pack · contaminatedSTRONG SOCK SMELL IN CRUISE PACK 1 OFF ISOLATED ODOR. PERSISTENT, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-PERFORMED T/S PROCEDURE IAW TSM 05-50-00-810-831-A. LEVEL A DSDR GTIA2025072138998Ecs · odorREAR AFT FLIGHT ATTENDANT REPORTED POSSIBLE MUSTY ODOR IN AFT GALLEY AND FROM ROW 33 AND BACK-ACCOMPLISHED TSM 05-50-810-831-A PROCEDURES. PER DECISION TABLE FOUND ENG 2 BLEED AND PACK 2 WITH HIGHEST POSSIBLE CAUSES. PERFORMED LEVEL A DECONTAMINATION OF THE ECSDR GTIA2025072138997Vent · inoperativeAIR RETURN FPR: AVIONICS VENT FAULT AND AVIONIC SYS FAULT ( SKIN AIR OUTLET VALVE )-FOR CORRECTIVE ACTION SEE LOG PAGE 3535971-2 OR RIN 17347 . THIS CLOSE DMI 3535968-1 MOC NOTIFIED PLACARD REMOVEDSDR GTIA2025072138996Unknown · odorFA C ON DECENT TO CHS SMELT A BURNING SMELL ON LANDING. FLYING TO BWI ON LANDING AND TAXI SMELT A BURNING CHEMICAL SMELL AGAIN THAT LASTED 10 MIN. -FOLLOWED TSM 05-50-00-810-831-A INSPECTED APU AND BOTH ENG OIL LEVEL. OIL LEVEL GOOD. INSPECTED APU INLET. NO COSDR HALA20250721224Pin · out of limitsETOPS - APU AUTOSHUTDOWN ON TAXI INTO GATE. FOUND STARTER WEAR PIN BEYOND LIMITS. REMOVED AND REPLACED STARTER PER AMM 49-42-51. OPS CHECK GOOD. OK FOR SVC.SDR YENA2025072100736Fcu · failedFLT#1333, BOS-SFO. (ETOPS) APU FAILED TO START IAW A49-00-01A. 3 START ATTEMPTS MADE OAT - 48 FL 360 ( APU SYSTEM A321NEO ETOPS ); REMOVED AND REPLACED APU FCU IRT AMM 49-32-11. OPS CHK SATISFACTORY. THIS CLEARS MDDR #588838. MCC NOTIFIED. MX-4 UPDATED. PLACARSDR AALA202507212128Mechanism · out of adjustAIRCRAFT WAS NOT GROUNDED: L3 DOOR IS DIFFICULT TO ARM. MAINTENANCE LUBRICATED AND ADJUSTED THE ARMING MECHANISM ON THE DOOR PER AMM 52-10-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202507216508Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND DOOR 842 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507217498Handle · looseAIRCRAFT WAS NOT GROUNDED: R2 DOOR ARM, DISARM HANDLE, LEVER IS VERY LOOSE. MAINTENANCE RE TORQUED R2 DOOR: ARM, DISARM HANDLE PER AMM 52-22-22.SDR AALA202507215048Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 4R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507210524Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507218021Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507214043Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT PASSENGER / CREW DOOR 842 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507217357Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY EXIT DOOR 844 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507212652Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND PASSENGER / CREW DOOR 832 DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR JJBA20250721083A/C Pack · seizedSMOKE IN CABIN AND COCKPIT ON DECENT DURING ICING OPERATIONS. PERFORMED PACKS 1 AND 2 OPS/LEAK CHECK WITH APU BLEED AND ENGINE BLEED FOR 30 MINUTES. OPS/LEAK CHECK SAT. NO SMOKE IN THE CABIN AND COCKPIT. INSPECTED AIRCRAFT INTERIOR DUCTS UNDERNEATH FLOOR BOARDSDR WX0A2025072132505Light · malfunctioned(AIRCRAFT GROUNDED) LEFT OVERWING EMERGENCY EXIT SIGNS ARE INOP WITH AC BUSSES OFF. / PERFORMED OPS CK OF EMERGENCY LIGHTS REF AMM 33-51-00-710-007-A. OPS CK GOOD AT THIS TIME. A/C OK FOR SVC / "SDR HNAA2025072100471Transmission · abnormalFLAP LOW SPEED DISPLAYED AFTER TAKE OFF. CW MX PROCEDURE FOR FLAP CHANNEL 2 FACT 20JUL25 06:15 SBY T/S USING FIM 27-51-00-810-801 R&R'D LH FLAP TRANSMISSION BRAKE IAW AMM 27-51-01. OPS CHECK GOODSDR HNAA2024072100470Seal · leakingON CLIMBING THROUGH FL 280 HIGH PITCH SQUEAL STARTED ON FLT DECK DIVERTED TO PHL AND SQUEAL PERSISTED UNTIL BELOW FL 180 FACT 18JUL25 19:37 PHL PRESSURIZED AC IAW AMM 21-31-00 FOUND MAIN PAX DOOR TO BE LEAKING. CLEANED AND LUBED DOOR SEALS. OPS CHECK GOODSDR DALA2025072105451Filter · cloggedSHIP 5021- DIV - RIGHT ENGINE OIL FILTER CLOG MESSAGE AND ODM CHIP COUNT INCREASE. CORRECTIVE ACTION: INSPECTED OIL FILTER AND CHIP DETECTORS, NO TROUBLE FOUND. DEFERRED OIL FILTER CLOG INDICATION TO MEL. LATER, REPLACED NBR 2 ENGINE MAIN OIL FILTER AND OIL DESDR DALA2025072105447Seat Track · corrodedFOUND ON SEAT TRACK AT FR74 LBL43. REMOVED AND REPLACED SEAT TRACK LBL43 FR61 TO FR74 IAW BOMBARDIER DWG#C01342701 REV-G AND A220 ASRP BD500-A-J51-42-20- 00AAA-078A-A. (LP# 1092716)SDR AALA202507214470Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: AFT LH DOOR DAMPER NEEDS TO BE SERVICE. MAINTENANCE SERVICED LH AFT DOOR DAMPER IAW 52-10-00SDR AALA202507210529Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 1 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #1 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507216218Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 2 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #2 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507219753Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 3 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #3 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507217387Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 4 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #4 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507218789Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 5 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #5 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507211099Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 LH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #5 LH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.