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 AALA202512108231Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 EMERGENCY EXIT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512105675Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DALA2025121008997Engine · odorDESCENDING THROUGH 9,000FT COCKPIT HAD A DIRTY SOCK ODOR FA, REPORTED THE SMELL ONCE ON THE GROUND. REPLACED NR 1 ENGINE. (LP 8118652,1341436)SDR DALA2025121008996Power Supply · inoperativeDURING SERVICE FOUND MULTIPLE SEAT MOUNTED EMERGENCY LIGHTS TO BE INOPERATIVE. REPLACED EPSU IAW A321 AMM 33-51, OPS CHECK GOOD. (LP 8083578)SDR YENA2025121001190Unknown · odorFLT 821, BOS-PBI. STRONG ODOR IN CABIN PASSING 110000 FT ; ACCOMPLISHED FIM TASK J 21-22-00-04AAA- 423 NO CONTAMINATION FOUND OPERARATED ISOLALTED APU - ENG 1 ENG 2 NO ODOR OR FUMES DETECTED.SDR YENA2025121001189Unknown · odorFLT 1153, JFK-PBI. STRONG ODOR EVENT DURING APPROACH PRESENT IN CABIN AND COCKPIT,. LASTED ABOUT 4 MINUTES. SMELLED LIKE CHEMICAL OR NAIL POLISH SCENT; COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION B2. IDENTIFIED ODOR AS TYPE 10 (MISC, SMOKE OR FUME) DESDR YENA2025121001188Unknown · odorFLT 1827, EWR-MCO. INFLIGHT CREW REPORTS AN ODOR THRU OUT ON FINAL DESCENT. ODOR ALL THRU CABIN BUT NOBODY REPORTS FEELING ILL LEVEL ONE; COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION A, ISOLATED FAULT TO TYPE 10, DESCENT THROUGH CLOUDS, PER TSM 05-50-00SDR CALA2025121011998Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1670 FAILED CAPACITY CHECK. REPLACED M1670 BATTERY PACK IAW AMM 33-51-06-960-806.SDR CALA2025121011996Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1674 FAILED CAPACITY CHECK. REMOVED AND REPLACED M1674 BATTERY PACK IAW AMM 33-51-06-960-805. OP CHECKED GOOD.SDR CALA2025121011994Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1675 FAILED CAPACITY CHECK. REMOVED AND REPLACED M1675 BATTERY PACK IAW AMM 33-51-06-960-805. OPS CHECK GOOD.SDR CALA2025121011992Floor Support · crackedMAIN CABIN FLOOR SUPPORT UPPER FLOORBOARD ATTACH FLANGE IS CRACKED IN MULTIPLE LOCATIONS BETWEEN BS 380 & 400, BL 0. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02 & DWG 143A5400 REV -.SDR JGVR20251209003Skin · scratchedBLENDED SCRATCHES ON THE LT & RT LEADING EDGES, PERFORMED NDT AND PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. VERIFIED NO BLENDS EXCEEDED THICKNESS MATERIAL LOSS EXCEEDING 5% AND POLISHED PER REQUEST FOR TECHNICAL SERVICES REPORT.SDR JJBA20251209022Fuse · inoperativeBOTH OVERWING AFT EXTERNAL EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED F1 FUSE ON NR 4 BATTERY CHARGER. OPS CHECK GOOD.SDR JJBA20251209021Flashlight Assy · inoperativeFWD FA EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FWD FA EMERGENCY FLASHLIGHT. OPS CHECK SAT.SDR ABXA2025129323Smoke Detector · no testDURING CREW PRE-FLIGHT, CARGO FIRE DETECTION LIGHT B5 ILLUMINATED YELLOW. STAYS YELLOW DURING FIRE TEST. WAS NOT (YELLOW). ILLUMINATED DURING GROUND TEST. MAINTENANCE REMOVED AND REPLACED CARGO LOWER 5B SMOKE DETECTOR ASSY PER AMM 26-16-01. OPS CHECK OK. A/SDR JGVR20251209002Skin · corrodedMECHANICALLY BLENDED CORRODED AREA ON LOWER AFT RT WING SKIN, INBOARD OF FLAP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED AND PRIMED AREAS IAW REQUEST FOR TECHNICAL SERVICES REPORT.SDR JGVR20251209001Drag Angle · corrodedBLENDED AREAS OF CORROSION ON THE LOWER AFT DRAG ANGLE, LEFT WING INBD OF FLAP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. REPLACED BLENDED FASTENERS WITH NEW, CLEANED, TREATED AND PRIMED AREAS PER REQUEST FOR TECHNICAL SERVICES REPORT.SDR DALA2025120908979Coffeemaker · odorAFT GALLEY PORT COFFEE MAKER EMITTING BURNT ELECTRICAL SMELLS WHEN ON. F/A TURNED OFF AND SMELL STOPPED. INSPECTED BOTH COFFEE MAKERS (508&509). NOT ABLE TO REPLICATE SMELL. COMPLETED W/C 0550-2002 NOGO ODI SMOKE AND FUMES. FWD BOTH 508 & 509 COFFEE MAKERS TOSDR KCSA202512091237Power Supply · inoperativeEMERGENCY LIGHTS L5734 STA 498, L1382 STA 360, L5604 STA 470 WONT TURN ON.SDR DALA2025120908977Battery Pack · no testEMERGENCY LIGHTS TEST FAULTS 11WL. REPLACED BATTERY PACK AT ESPU 11WL PER A321 AMM 33-51. OPS CHECK GOOD. (LP 4493692)SDR DALA2025120908971Lug · corrodedCORROSION ON LT MLG RIB 6 AFT. ACCOMPLISHED REPAIR ON LT WING MLG RIB 6 FITTING FWD LUG IAW ER/A 630453-14AD REV ORIGINAL. (1342763)SDR DALA2025120908970Lug · corrodedLEFT MLG RIB 6 FWD LUG BORE CORRODED. REPAIRED PER ERA 630453-14AD REV ORIGINAL. (1342726)SDR AALA202512098442Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CHECK DOOR PRESSURE ON CIDS PANEL DISPLAYS BY 2L AND PRESSURE LIGHT FLASHES ON DOOR. MAINTENANCE SERVICED THE L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR KCSA202512091236Skin · corrodedCORROSION FOUND ON FUEL CTR TANK ON UPPER SKIN MAIN W/W UPPER SURFACE MAIN DECK STA 1241 LBL 2SDR FDEA202512092225Battery Pack · no testCOURIER COMPARTMENT EXIT DOORS EMERGENCY LIGHTS NOT TESTING. RELEASED FOR SERVICE PER MEL 33-51-05-01. COURIER COMPARTMENT INTERIOR EMERGENCY LIGHTS, DOORS EXIT SIGN INOPERATIVE. NO JUMPSEATERS ALLOWED TO OCCUPY THE COURIER AREA. EMERGENCY LIGHT TEST SSDR KCSA202512091235Reservoir · dischargedEMERGENCY POWER RESEVOIR DISCHARGED (LH)SDR CALA2025120911931Lamp · inoperativeLAV T, FWD EMERGENCY EXIT PROX LIGHT INOPERATIVE. REPLACED THE LAMP IN THE EMERGENCY PROX LIGHT ON LAV T IAW AMM 33-51-14, OPS CHECKED GOOD.SDR JR2R20251209775Trunnion · chafedNOSE LANDING GEAR TRUNNION BORE HAS EVIDENCE OF DAMAGE. BLEND DAMAGED AREA.SDR BJNA202512090001Unknown · vaporDURING DESCENT BELOW 18,000 FT TO ABOUT 5000FT STRONG SMOKE SMELL WITH LIGHT VAPOR IN FLIGHT DECK. PERFORMED FIM TASK 21-00 TASK 806, SMOKE AND FUMES IN THE CABIN FAULTS ISOLATION, NO FUMES OR SMOKE APPEAR, ACFT OK FOR SERVICE.SDR RU3A2025120900814Unknown · odorON 09 DECEMBER 2025, WAS PERFORMING FLIGHT INSPECTION MANEUVERS WHEN THE CREW BECAME AWARE OF A STRONG ODOR OF ELECTRICAL SMOKE IN THE COCKPIT. AN EMERGENCY WAS DECLARED WITH BOSTON TRACON AND AN EMERGENCY LANDING WAS PERFORMED ON RUNWAY 27. AIRPORT RESCUE ANSDR SWIA2025120877442Frame · corrodedFUSELAGE FRAME FS295 BETWEEN STR 25R - 26R HAD CORROSION, NDT ACCOMPLISHED, INSPECTION IAW MRM INTRODUCTION OF THE FRAME AROUND EACH FASTENER ON THE REPAIRED FLANGE REF STS EA 15-2013-029 REV A. OPENED DISCREPANT HOLES IN ENTIRE STACK UP AT BS 295, STR 2SDR SWIA2025120877406Skin · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE WIFI PCSTIMING ANTENNA SDI 700 - COMPLY WITH INSPECTION OF THE PCSTIMING ANTENNA SDI DI IAW STC ST02541CH ICA DOCUMENT D12454-20110 SEC 4 LATEST REVISION 1 INTERNAL AC SKIN - DOUBLER OUTER EDGE FASTENER HOLES - SDI2 INTSDR CALA2026090119135Bulkhead Web · crackedVERTICAL PRESSURE WEB CRACKED BTWN LBL 31.53 & 40. REPAIRED AREA IAW SRM 57-10-10-2R-3, & SRM 51-40-02-0G-0.SDR SWIA2025120876572Rib · crackedRT WING BATTERY RIB IS CRACKED AT WS 14.50. INSTALLED NEW RT WING BATTERY RIB AT WS 14.50 . IAW SRM 51-42-21-001-001-A01, SRM 51-42-22-001-001-A01. AND DWG CC690-10610, REV. D. .SEE CONTINUE CARD FOR DETAILSCOMPLIED WITH TASK CARD 51-900-1002.SDR REXA2026052700759Hinge · chafedWEAR ON PIANO HINGE FUSELAGE SIDE AT PASSENGER DOOR. WEAR ON PIANO HINGE FUSELAGE SIDE AT PASSENGER DOOR WAS BLEND OUT CRJ-900 SRM 51-12-00-001-001-A01 AND EVALUTED OU OFF LIMITS PER CRJ-900 SRM 53-21-23-201-010-A01 AND PIANO HINGE WAS REPLACED PER CRJ900 SRM SDR SWIA2025120875767Pressure Blkhd · crackedBS 409+128, RBL 27 PRESSURE BULKHEAD POST, POSSIBLE CRACK AT BOTTOM INBD AFT RADIUS. REPAIRED THE CRACK AS PER REO 601R-53-41-056 REV -F. LEAK CHECKED GOODSDR SWIA2025120875751Rib · crackedRIGHT MLG WHEEL WELL BATTERY RIB AT WS.48.3 HAS POSSIBLE CRACK ON FWD AND AFT END. REMOVED AND REPLACED CRACKED BATTERY RIB IN THE RT MLG WHEEL WELL IAW DWG 600-10204 REV M AND SRM 51-42-21. COMPLIED WITH 51-900-1003 SKY.SDR SWIA2025120875733Rib · crackedLEFT MLG WHEEL WELL BATTERY RIB AT WS.48.3 HAS POSSIBLE CRACK ON FWD OB END. REPAIRED THE LT BATTERY RIB WEB AT WS48.3. REO 601R-57-21-4030 REV --, COMPLIED WITH SKYWEST TASK CARD 51-900-1003-SKY.SDR SWIA2025120875731Pressure Blkhd · crackedFS409.00+128 LBL 18 PRESSURE BULKHEAD POST, POSSIBLE CRACK AT BOTTOM OUTBD AFT RADIUS. REPLACED FS409.00+128 LBL 18 PRESSURE BULKHEAD POST IAW SRM 51-42-06 & REO 601R-53-41-889 REV -D. LEAK CHECK GOOD. COMPLIED WITH SKYWEST TASK CARD 51-900-1003-SKY.SDR SWIA2025120875162Frame · corrodedFS 379 HAS CORROSION PRESENT ON AFT SIDE AT APPROXIMATELY STR 23R. (C-CHECK RO 02/01/2026)FRAME AT FS 379 HAS INTERGRANULAR CORROSION AND IS EXFOLIATED WITH 100% MATERIAL LOSS IS FOUND TO BE OUT OF LIMITS REPLACE PART. REMOVED AND INSTALLED NEW FRAME FS 379.RSDR AALA202601279923Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #3 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202601276145Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON NR 2 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202601271473Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT WING AILERON #1 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202601270376Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #2 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR AALA202601276612Support Frame · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT WING AILERON #1 HINGE SUPPORT FRAME HAS EXCESSIVE PLAY. REPLACED SUPPORT FRAME PER AMM 57-51-31.SDR VNAA20260125004Landing · crackedADG LANDING DOOR CRACK WITHIN 1438 FLIGHT HOURS AFTER SECTION I, ACCOMPLISH A PERMANENT REPAIR AT DISCREPANT AREA IAW APPROVED PROCEDURES OR REPLACE PART. UPPER DOOR LANDING WAS REPLACED IAW SRM 51-42-21-001-001-A01, AND SRM 51-42-06-001-001-A01.SDR VNAA20260125002Skin · dentedDENT DAMAGE TO INBD LOWER WING T/E SKIN BETWEEN WS 14.500 AND WS 50.000, THE WING TE SKIN BETWEEN WAS REPLACED IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, SRM
51-42-13-001-001-A01 & AT FITTING ASSY WAS REPAIRED IAW EA 5750-2026-0060, REV--.SDR HNAA2026012200061Cap · corrodedRIGHT INBD FLAP INBD END CAP CORRODED AROUND NUT PATES HOLES. R & R RT INBD FLAP INBD END CAP IAW SRM 51-40-02.SDR CALA2026011913084Transition Panel · corrodedBULK CARGO, FLOOR AREA, BS 1520 , RT TRANSITION PANEL LOWER SURFACE HAS CORROSION. PERFORMED REPAIR AT TRANSITION PANEL BS 1520 TO 1640 IAW SRM 53-00-53-2R-2.SDR SWAA2026011944088Wire · disconnectedG4 EXIT LIGHT WIRE CONNECTORS FOUND PULLED OUT. WIRES L1191 TERMINATED IAW WDM 33-51-22 & SWPM 20-61-00; GOOD OPS CHECK OF EMER EXIT LT AT G4 PERFORMED IAW AMM 33-51-00-710-801.