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 DALA2025071705391Skin · dentedSHIP 3130 DENT EXTERNAL SKIN LOCATED AT FR 66 LEVEL STR 42L AT LOWER FUSELAGE. COMPLIED ER/A 627650-14AD. (1088326).SDR QMLA2025071520073Unknown · odorWHILE IN FLIGHT, CREW NOTICED A BURNING SMELL IN THE CABIN, SIMILAR TO AN ELECTRICAL SHORTAGE. IT HAPPENED TWICE DURING FLIGHT. THE SMELL CAME AND LEFT. UPON LANDING, THE PILOT NOTICED THE AM/EX CIRCUIT BREAKER POPPED. THERE WAS NO
IMMEDIATE EVIDENCE OF ANY BSDR 2025FA0000507Mount · crackedDURING ENGINE OVERHAUL AND ANNUAL INSPECTION, THE R/H LOWER ENGINE MOUNT WAS FOUND CRACKED. THIS WAS HIDDEN UNTIL THE ENGINE MOUNT WAS REMOVED. RECOMMEND THAT MECHANICS VISUALLY INSPECT THE LOWER ENGINE MOUNT AREA WHERE IT AFFIXES TO THE FIREWAL, WITH A BORESCSDR AALA202507176374Power Supply · inoperativeAIRCRAFT WAS GROUNDED: DURING PERIODIC SERVICE CHECK FOUND RT WING EMERGENCY EXIT LIGHT INOP. MAINTENANCE REPLACED RIGHT WING EPSU EMERGENCY EXIT LIGHT AND EMERGENCY BATTERY POWER UNIT IAW AMM 33-51-38.SDR DALA2025071705386Leaf Spring · faultedSHIP 651 AA. AD IN REFERENCE TO AMDS 2560-01492-0101 STEP 2: LEAF SPRINGS OF GIRT BARS ON DOORS L1, R1, L2, R2, L4 AND R4 NOT HOLD ON GIRT BAR SLIDER. LEAF SPRINGS OF GIRT BARS ON DOORS L1, R1, L2, R2, L4 AND R4 WERE REPLACED PER CMM 25-66-14 REPAIR 2-1 AND SDR GTIA2025071738994Wire · brokenF.Q. REPORTS THAT MEGAPHONE HAS A BROKEN WIRE-R/R FWD MEGAPHONE PER A/C DRAWINGS A321-EMEREQUIP. OPS CK OKSDR DALA2025071705384Pan · crackedAIRCRAFT 9572, DURING HCK AT QRO, WHILE PERFORMING A FORWARD LOWER CARGO DOOR INSPECTION PER WC 5231-2005, FIVE (5 QTY) CRACKS WERE FOUND AFFECTING THE FWD CARGO DOOR AT LOWER INNER AND OUTER PAN BETWEEN STA Y=389 AND Y=408 AS FOLLOWS: TWO (2 QTY) CRACKS AT INSDR DALA2025071705383Pan · crackedAIRCRAFT 9572, DURING HCK AT QRO, WHILE PERFORMING AN AFT LOWER CARGO DOOR INSPECTION PER WC 5231-2004, THREE (3 QTY) CRACKS WERE FOUND AFFECTING THE AFT CARGO DOOR INNER PAN FWD EDGE AT STOP #2. ADDITIONALLY, AN EXISTING REPAIR WAS FOUND INSTALLED AT THE FWD SDR IPXA2025071765144Unknown · odorFLIGHT CREW REPORTED BURNING SMELL IN CKPTFROM 1205-1209 ON CLIMB WENT AWAY CREW REPORTED THAT THEY CHECKED OVEN AND MAIN DECK AND COULD NOT FIND ANYTHING. CHECKED CMC FOR FAULTS AND EQUIPMENT COOLING FAULTS. NO FAULTS FOUND. DURING PS-1 CHECKED E/E AND REST OSDR QR9R2025071700001Sensor · out of limitsNUMBER 1 GCU WOULD NOT HOLD AMPERAGE WITHIN LIMITS. REPLACED NR 1 CURRENT SENSOR IAW AMM 24-30-00,4-6. OPERATIONAL CHECK GOOD IAW AMM 24-30-00, 5-2.SDR KCSA202507171116Longeron Fitting · crackedR/H LONGERON EXTENSION FITTING FOUND TO HAVE CRACKED. END OF CRACK MARKED.SDR MTNA20250717001Skin · crackedON PREFLIGHT, PILOT LOWERED FLAPS AND FOUND LIGHT IN FLAP COVE, UPON FURTHER INSPECTION MECHANIC FOUND CRACK ON UPPER WING SKIN MEASURING 4"X4"X4".SDR DALA2025071705373Seat Track · corrodedAIRCRAFT 3095, CORROSION SEAT TRACK +Y1292 LOC. FR 66 AT AFT GALLEY AREA (SSI: 534147). REPLACED SEAT TRACK Y1292 AND FASTENERS LOC FR64 TO FR66 IN AFT GALLEY AREA AS PER A321 SRM 51-72-11 AND A321 SRM 51-42-11, DWG: D53478310.SDR KCSA202507171115Longeron Fitting · crackedLEFT LONGERON EXTENSION FITTING HAS CRACK INDICATION.SDR N3XR202507170462Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND THE RIGHT CORNER BETWEEN RIVET HOLESSDR N3XR202507140897Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507140468Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR N3XR202507140453Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR JR2R20250717683Skin · chafedRIGHT HAND WING LEADING EDGE PANEL, ABOVE PYLON, IS CHAFED OUT OF LIMITS. REPAIREDSDR MAS2025F00004Skin · chafedLEFT HAND WING LEADING EDGE PANEL, ABOVE PYLON, IS CHAFED OUT OF LIMITS. REPAIREDSDR JR2R20250717682Skin · chafedRIGHT HAND WING LEADING EDGE PANEL, ABOVE PYLON, IS CHAFED OUT OF LIMITS. REPAIREDSDR ABXA20250717162Warning Flag · activatedDURING TAXI OUT, RA FLAG ON THE F/O'S SIDE. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED RIGHT RA IAW MEL 34-33-1-2A-1. ACFT RELEASED TO CAT II OPERATIONAL. PLACARD INSTALLED REF ITEM 2 MBCB 07/27/25. A/C RELEASED TO SERVICE.SDR AALA202507174286Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR FDEA202507171229Doubler · crackedLEFT HAND WING - FIXED LEADING EDGE LOWER DOUBLER FOUND CRACK ABOUT 1 INCH AT STATION XOS 995. LEFT HAND WING FIXED LEADING EDGE LOWER CRACKED DOUBLER AT STATION XOS 995 REPAIR CARRIED OUT AS PER MD-11 SRM 57-40-03-2R FIGURE 201 REPAIR 1. REPAIR CLASSIFIEDSDR FDEA202507171228Skin · crackedDURING HIGH FREQUENCY EDDY CURRENT OPEN-HOLE INSPECTION AT RT WING LOWER SKIN ACCESS DOOR CUTOUT BETWEEN XORS=683.4 AND XORS=713.6 FOUND FASTENER HOLES NUMBER 6 AND NUMBER 13 WITH CRACK INDICATION. RIGHT HAND WING LOWER SKIN ACCESS DOOR CUTOUT BETWEEN STATIOSDR FDEA202507171227Web · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION ON RIGHT HAND NOSE LANDING GEAR TRUNNION WEB APPROXIMATELY STATION 583 EXISTING TRIMMED OUT AREA FOUND CRACK APPROXIMATELY 0.15 INCH. RIGHT HAND NOSE LANDING GEAR TRUNNION WEB AT STATION 583 CRACK AREA CARRIED OUT RSDR FDEA202507171226Seat Track · chafedAGING AIRCRAFT - EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 5-0 TO STATION 5-64 X = 47.5 LEFT HAND SIDE EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 5-0 TO STATION 5-64 X = 47.5 LEFT HSDR FDEA202507171225Seat Track · chafedAGING AIRCRAFT - EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1129 / 6-100 TO STATION 1189 X = -47.5 RIGHT HAND SIDE EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1129 / 6-100 TO STATION SDR KCSA202507171114Skin · damagedLWR FUSELAGE SKIN STA 1780 NEAR S-47R HAS MARKED SKIN DAMAGE.SDR KCSA202507171113Escape Reel · broken#1 EMERGENCY DESCENT DEVICE DAMAGED/ SEAL BROKENSDR JR2R20250717711Crossbeam · corrodedFR90 CROSSBEAM AT APPROX LBL24 -LBL26 CORRODED. REWORKSDR KCSA202507171112Skin · damagedNOSE CARGO DOOR STA 178 RBL 7, STR 46R HAS MARKED LIGHTNING STRIKE DAMAGE.SDR 2025FA0000505Skin Panel · crackedIDENTICAL LEFT AND RIGHT SIDE AFT FUSELAGE SKIN CRACKS FOUND ON ANNUAL INSPECTION. EACH VERTICAL CRACK IS 1 1/2 INCH IN LENGTH AND IS LOCATED 1 1/2 INCH FORWARD OF STATION +222 BULKHEAD PN. 62443-00. AT THE LOWER OF TWO STRINGERS FOR SIDE SKIN ASSEMBLIES LEFT SDR KCSA202507171111Skin · crackedPOSSIBLE CRACK ON R/H FUSELAGE AT APPROX STA 2360 STRINGER 17RSDR KCSA202507171110Fitting · crackedL/H LBL 11.33 INTERCOSTAL LUG FITTING AT STA 1000 HAS CRACK INDICATIONSDR 2025FA0000504Nut · no indicationOLD (EXISTING) FOUND ON ENGINES AND NEW LPT SLOTTED NUTS RECEIVED FOUND WITH NO PART NUMBERS ENGRAVED.SDR SWIA202512090716Antenna · corrodedADF ANTENNA HAS CORROSION AROUND FASTENER HOLES. REPAIRED AREA AROUND ADF ANTENNA FASTENER HOLES IAW REO 670-53-31-1065 REV -. INSTALLED 4EA LOCK FASTENERS IAW SRM 51-42-21-001-001-A01, REV 38.SDR SWI2025F01523Slat Track · damagedRH SLAT TRACK 3-1 HAS AREAS WITH SIGNS OF PITTING ON THE UPPER SURFACE (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO RH SLAT TRACK 3-1 UPPER SURFACE IAW CRJ900 SRM 51-12-00 AND REO 690-57-42-1279 REV-- DATE 2025-08-15. NDT PERFORMED.SDR SWIA20251110716Slat Track · damagedRIGHT SLAT TRACK 2-3 HAS AREAS WITH SIGNS OF PITTING ON UPPER SURFACE (C-CHECK RO 11/07/2025)REPAIRED DAMAGED RH SLAT TRACK 2-3 UPPER SURFACE IAW CRJ900 SRM 51-12-00 AND REO 690-57-42-1274 REV-- DATE 2025-08-11.SDR SWI2025F01522Slat Track · damagedRH SLAT TRACK 2-1 HAS AREAS WITH SIGNS OF PITTING ON UPPER SURFACE (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO RH SLAT TRACK 2-1 UPPER SURFACE IAW CRJ900 SRM 51-12-00 AND REO 690-57-42-1281 REV-- DATE 2025-08-19. NDT PERFORMED .SDR SWI2025F01521Slat Track · damagedRH SLAT TRACK 1-1 HAS AREAS WITH SIGNS OF PITTING ON UPPER SURFACE (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO RH SLAT TRACK 1-1 UPPER SURFACE IAW CRJ900 SRM 51-12-00 AND REO 690-57-42-1277 REV-- DATE 2025-08-15. NDT PERFORMED.SDR SWI2025F01520Slat Track · damagedRH SLAT TRACK 2-2 HAS AREAS WITH SIGNS OF PITTING ON UPPER AND LOWER SURFACES (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO RH SLAT TRACK 2-2 UPPER AND LOWER SURFACE IAW CRJ900 SRM 51-12-00, MHIRJ REO 690-57-42-1280 REV-P1 DATE 2025-08-22, REV-- DATE 2025-10-03. NSDR SWI2025F01484Hinge · chafed( MX 30497653 ) UPON VISUAL INSPECTION OF PAX DOOR PIANO HINGE FUSELAGE SIDE, FOUND MULTIPLE CHAFES MARKS ON LUG LANDS AND LUGS. (C-CHECK RO 11/01/2025)REPAIRED F PAX DOOR PIANO HINGE FUSELAGE SIDE ORIGINAL THICKNESS 0.134" IAW DWG SH670-31876 REV G REMOVED TSDR SWIA20251103716Stand Off · crackedL/H UPPER TRANSCOWL INBD "A" BRACKET STANDOFF IS CRACKED (C-CHECK RO 11/01/2025)REMOVED CRACKED INBD "A" BRACKET STANDOFF AND INSTALLED 1 EA NEW "A" BRACKET STANDOFF P/N CN624-2082-201 ON L/H UPPER TRANSCOWL REF MHIRJ GREO #670-54-21-971 REV (-B) 2023-11-28 SDR SWI2025F01483Hinge · scratched(MX 30497765) DURING VISUAL INSPECTION OF PAX DOOR PIANO FUSELAGE DOOR SIDE FOUND MULTIPLE SCRATCHES AND CHAFES ON INBOARD HINGE FLANGE AND LUGS (C-CHECK RO 11/01/2025)REPAIRED PAX DOOR PIANO FUSELAGE DOOR SIDE PAX DOOR PIANO HINGE LUGS MINIMUM MATERIAL WALSDR NACA2025071600003Packing · leakingFOUND APU OIL QTY TRANSMITTER PACKING LEAK. REMOVED AND REPLACED APU OIL QTY TRANSMITTER PACKING PER 767-300 AMM 49-49-04SDR CNMA2025090001Case · corrodedDURING C CHECK, CORROSION WAS FOUND ON THE NR 2 ENGINE FWD AND AFT CASE AROUND THE EXTERIOR AND INTERIOR SKIN. IT WAS FOUND TO BE OUT OF REPAIRABLE LIMITS FOR THE FWD FAN CASE PER AMM 72-32-00 AND OUT OF FLYABLE LIMITS PER AMM 72-00-00. THE ENGINE WAS REMOVED SDR IPXA2025081455436Vertical Support · crackedAFT CARGO FR 54 VERTICAL SUPPORT AT Y953 RH IS CRACKED INSTALLED VERTICAL SUPPORT AT AFT CARGO FR 54 Y953 RH APPLIED IAW A300-600, SRM 51-40-21.SDR IPXA2025081455420Support · crackedAFT CARGO FR 54 VERTICAL SUPPORT AT Y953 LH IS CRACKED INSTALLED VERTICAL SUPPORT AT AFT CARGO FR 54 Y953 LH APPLIED IAW A300-600, SRM 51-40-21.SDR IPXA2025081455411Support · crackedAFT CARGO FR 54 VERTICAL SUPPORT AT Y-1959 IS CRACKED INSTALLED VERTICAL SUPPORT AT AFT CARGO FR 54 Y-1959 APPLIED IAW A300-600, SRM 51-40-21.