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 AALA202512191465Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT MODULE ON THE SIDE OF SEAT 27C HAS FALLEN OFF. REPLACED FLOOR PROXIMITY LIGHT AT ROW 27. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202512196384Warning Message · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE NEAR TOP OF DECENT AT FL210, #1 ENGINE OIL QUANTITY INDICATED 0, SHUTDOWN NUMBER 1 ENGINE. AIRCRAFT EMERGENCY LANDED SAFELY AT OMA. (OPEN).SDR SWAA2025121953749Flashlight · inoperativeAFT FLIGHT ATT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT AND FLASHLIGHT BATTERY AFT F/A CA?S SIDE INBD IN REF TO AMM 25-64-00. OPS CHECK GOOD MEL CLEARED.SDR SWAA2025121953979Flashlight · dislodgedCOCKPIT FLASHLIGHT WILL NOT TEST. REPOSITIONED COCKPIT FLASHLIGHT IN ITS CRADLE IAW AMM 25-64-00. OPS CHECK IS GOOD.SDR SWAA2025121953741Girt Bar · looseFWD GALLEY FO SIDE HOLDING BRACKET FOR GIRT BAR LOOSE. REMOVED AND REPLACED THE RIVETS FOR THE FWD SERVICE DOOR AFT GIRT BAR RETAINER CLIP IAW SRM 51-40-02.SDR SWAA2025121953744Retainer · brokenAFT R2 DOOR EMERGENCY EXIT DOOR SLIDE GIRT BAR RETAINER CLIP BROKE. REPLACED R2 ESCAPE SLIDE GIRT BAR RETAINER (STOP ASSY) IAW AMM25-66-01SDR SWAA2025121953429Slide · unsecureAFT ENTRY DOOR L2 ESCAPE SLIDE TIE-LADDER NOT SECURED. SECURED AFT ENTRY DOOR L2 SLIDE TIE-LADDER W COTTER PIN IAW AMM 25-66-01.SDR SWAA2025121953430Slide · unsecureAFT GALLEY SERVICE DOOR R2 ESCAPE SLIDE AFT TIE-LADDER NOT SECURED. SECURED THE SERVICE DOOR R2 ESCAPE SLIDE AFT TIE-LADDER W COTTER PIN REF AMM 25-66-01.SDR SWAA2025121953431Girt Bar · unpackedAFT ENTRY DOOR L2 SLIDE GIRT HANGS TOO LOW. REPACKED AFT ENTRY DOOR L2 SLIDE GIRT IAW AMM 25-66-01.SDR SWAA2025121953428Girt Bar · unpackedAFT GALLEY SERVICE DOOR R2 SLIDE GIRT HANGS TOO LOW. REPACKED AFT GALLEY SERVICE DOOR R2 SLIDE GIRT IAW AMM 25-66-01.SDR SWI2025F01831Angle · corrodedCOMPLY WITH REO 670-53-11-745 DATED: 2016-10-28 REV: A GENERIC REPAIR FOR NOSE FUSELAGE CENTER FLOOR ANGLE REPLACEMENT AND DOOR POST AT FS 28.00 ( LBL 11.128 AND RBL 11.128) DUE TO CORROSION FOUND ON THE DOOR POST. (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGSDR SWIA2025121900018Frame · damagedFWD FUSELAGE MACHINED, FRAME BS 610 DAMAGED. THIS HAS BEEN DETERMINED TO BE A MAJOR REPAIR, FORM M-337 AND ST51-00-00-002-SKY-U CARD REQUIRED (FILED OPEN)THIS IS CURRENTLY A WORK IN PROGRESSSDR DALA2025121909266Slide · low pressureSHIP 6806 DURING SERVICE CHECK FOUND D4L SLIDE BELOW PRESSURE. CORRECTIVE ACTION: REMOVED SLIDE 4L PER WORKCARD 2566-9001-4L SAFETY PINS FOR ASSIST BOTTLE INSTALLED. INSTALLED NEW SLIDE PER B757 JIC 2566-9001-4L. RII TASK C/W. (7684726)SDR WX0A2025121932679Flashlight · inoperative(AIRCRAFT NOT GROUNDED) FWD FA FLASHLIGHT NOT FLASHING. REMOVED AND REPLACED FWD IB FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AND CRADLE ASSEMBLY PER CMM 20-60-02. OPS CHECK GOODSDR WX0A2025121932678Fitting · dirty(AIRCRAFT NOT GROUNDED) DURING CONTINUOUS LIGHT CHOP R2 DOOR PRESSURE LIGHT STARTED FLASHING DURING CRUISE. SLIDE ARMED LIGHT OUT ON S.D. SLIDE ARMING LEVER WAS FOUND TO BE APPROX 1/4 INCH FROM BEING FLUSH TO DOOR. LEVER WAS PUSHED FLUSH DOOR SLIDE WENT TO ARMSDR WX0A2025121932677Flashlight · inoperative(AIRCRAFT NOT GROUNDED) FA 2 FLASHLIGHT IS INOP. REMOVED AND REPLACED FLASHLIGHT.SDR WX0A2025121932676Unknown · odor(AIRCRAFT NOT GROUNDED) FWD FA'S REPORT SOCK SMELL FORWARD CABIN DESCENDING THROUGH 10,000 INTO SRQ. RESOLVED ON W/O: 539828 TASKCARD: NR-00001, REF WO 539828, NR 2-7 FOR MAINTENANCE ACTIONS. C/W TC 21-000-003. NO DEFECTS NOTED.SDR JJBA20251219027Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT. OPS CHECK SAT.SDR ABXA20251218344Bleed Valve · defectiveDURING TAXI OUT, LT BLEED ISLN VALVE NOT IN THE COMMANDED POSITION AFTER ENGINE START. A/C RETURNED TO BLOCKS. (BTB). REMOVED & REPLACED LEFT BLEED ISLN VALVE IAW AMM 36-11-04, OPS CHECK OK IAW AMM 36-11-04 AIRCRAFT REMAINS NO ETOPS. AIRCRAFT RETURNED TO SESDR FDEA202512182261Stringer · corrodedBULK AREA BETWEEN STA 1700 TO 1720 STR 23L CORRODED ACCOMPLISHED REPAIR ON STRINGER BTW STA 1685 TO STR 1720 IAW B757 SRM 53-00-03-2R, 51- 40-02-0GSDR AALA202512198419Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: DURING WC 72T20033001 ACCOMPLISHMENT IT WAS FOUND BOTH BACKUP POWER SUPPLY FAULT AT OFAR. MAINTENANCE REPLACED BOTH BACKUP POWER SUPPLY AT OFAR IAW AMM 33-29-12, TEST OK.SDR AALA202512192561Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: DURING WC 72T20033001 ACCOMPLISHMENT IT WAS FOUND BOTH BACKUP POWER SUPPLY FAULT AT OFAR. MAINTENANCE REPLACED BOTH BACKUP POWER SUPPLY AT OFAR IAW AMM 33-29-12, TESTED OK.SDR AALA202512193934Wire Harness · damagedAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHT INOP AT SEAT 24ABC. MAINTENANCE SEAT HARNESS #26-3351-3-0022 PER ESPM 20-33-00, 20-33-30, OP CK NORMAL PER MM 33-51-19.SDR SIMA20251218001Packboard · damagedFOUND L1 DOOR EMERGENCY SLIDE PACKBOARD UPPER TAB BROKEN OFF. IAW AMM 25-65-01/400 FIGURE 402 ITEM G. PAGE 13/37 R & R L1 DOOR EMERGENCY SLIDE IAW AMM 25-65-01. NO DEFECTS NOTED.SDR DALA2025121909259Mount · out of alignmentFORWARD PYLON MOUNT ALIGNMENT FWD HOLE HAS DAMAGE. BLENDED TO REMOVE DAMAGE TO WITHIN ALLOWABLE LIMITS IAW SRM 54-51-18. (1356895).SDR DALA2025121909258Structure · damagedAFT GALLEY LAMINATE IS COSMETICALLY DAMAGED. REPLACED AFT GALLEY LAMINATE PER A319 AMM 25-31. (1357446).SDR DALA2025121909257Structure · damagedFWD GALLEY LAMINATE IS COSMETICALLY DAMAGED. REPLACED GALLEY LAMINATED AMM 25-31. (1357443).SDR DALA2025121909256Roller · deterioratedDETERIORATED ROLLER FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF PASSENGER CREW DOOR 831. REPLACED ROLLER FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF PASSENGER CREW DOOR 831 (4E/A) AS PER FAM AMM52-11-31-000-002-A AND IAW FAM AMM 52-11-31-4SDR DALA2025121909255Roller · wornWORN CRUISE ROLLER INBD FLAP ON RT WING. REPLACED THE CRUISE ROLLER OF INBD FLAP ON RT WING IAW CMM 57- 52-21, TASK 57-52-21-000-805-A01, & TASK 57-52-21-400-803-A01. (1357915).SDR DALA2025121909254Seat Track · corrodedCORRODED SEAT TRACK -Y254, FR 67. REPLACED THE SEAT AND FASTENERS, BTW FR 66 - 68 IAW SRM 51-42-11, AND SRM 51-72-11. (1358084).SDR DALA2025121909253Mount · damagedFORWARD PYLON MOUNT ALIGNMENT AFT HOLE HAS DAMAGE. BLENDED TO REMOVE DAMAGE TO WITHIN LIMITS IAW SRM 54-51-18. (1356909).SDR CALA2025121912271Lamp · inoperativeEMERGENCY LIGHT AT L1 DOOR INOPERATIVE. RELAMPED EMERGENCY SLIDE LAMP AT L1 DOOR IAW AMM 33-51-04-960-801. OPS CHECKED GOOD.SDR CALA2025121912270Fuse · blownALL THREE EMERGENCY EXIT LIGHTS INOPERATIVE AT THE LT OVERWING EXIT. REPLACED THE FUSES IN M1668 POWER SUPPLY 33-51-06-960-804.. EMERGENCY EXIT LIGHTS OP CKS GOOD.SDR CALA2025121912263Beam · crackedR1 SERVICE DOOR HANDLE TORQUE BOX LOWER SUPPORT BEAM CRACKED NEAR TORQUE BOX FWD ATTACH BOLT. R & R LOWER INNER SKIN & LOWER BEAM IAW SRM 51-40-02-0G-0 & DWG 141A6516 AND DWG 141A6535.SDR CALA2025121912261Extinguisher · damagedFLIGHT DECK FIRE EXTINGUISHER PRESSURE GAUGE BROKEN OFF. REMOVED DAMAGE HALON FIRE EXTINGUISHER FROM ACFT, RELOCATED FORWARD HALON FIRE EXTINGUISHER TO FLIGHT DECK. WATER EXTINGUISHER REMAINS IN FWD GALLEY. HALON EXTINGUISHER IN FWD GALLEY COVERED, INOPERSDR CALA2025121912259Seal · missingRIGHT WING INBD AILERON BOTTOM SEAL MISSING.SDR DALA2025121909252Floorbeam · corrodedAFT CABIN BS 986 FLOORBEAM HAS CORROSION AROUND GIRT BAR FITTING HOLE AT LBL 48. EVALUATED AND REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6. RESTORED FINISH TO AREA IAW SRM 51-20-01-0G.SDR GTIA2025121839217Stringer · corrodedCORROSION INTERNAL STRUCTURE STRINGER 40R, FR66 - 69, IN THE AFT CARGO BAY. REPLACED STRINGER 40R IAW SRM 51-72-11-911-001, SRM 51-42-11 A320, SRM 51-24-00, AND DWG D53480030.SDR GTIA2025121839216Buttstrap · corrodedCORROSION ON INTERNAL SKIN STRAP AT FRAME 64, STRINGER 44 IN THE AFT CARGO BAY. PERFORMED A PERMANENT REPAIR ON INTERNAL SKIN BUTT STRAP, FR 64, S42 - 43L IAW EA 53-0090-25 PART 1, AND DWG R53471164.SDR GTIA2025121839215Stringer · corrodedCORROSION ON STRINGER 39R, BTW FR66 TO FR70, IN THE AFT CARGO BAY. REPLACED STRINGER 39R IAW SRM 51-42-11, SRM 51-72-11-911-001, AND DWG D53480030.SDR GTIA2025121839214Stringer · corrodedCORROSION ON STRINGER 44 BTW FR 65 - 70 IN THE AFT CARGO BAY. REPLACED STRINGER 44 IAW SRM 51-72-11-91-001, AND DWG D53480030.SDR GTIA2025121839213Stringer · corrodedCORROSION ON STRINGER 43L BTW FR 65 - 66, IN THE AFT CARGO BAY. REPLACED STRINGER 43L IAW SRM 51-72-11-911-001, AND DWG D53480030.SDR GTIA2025121839212Stringer · corrodedCORROSION ON STRINGER 43R, BTW FR 65 - 70 IN THE AFT CARGO BAY. REPLACED STRINGER 43R IAW SRM 51-72-11-911-001, AND DWG D53480030.SDR GTIA2025121839211Stringer · corrodedCORROSION ON STRINGER 42R, BTW FR 65 TO FR 70 IN AFT CARGO COMPARTMENT. REPLACED STRINGER 42R IAW SRM 51-72-11-911-001, AND DWG D53480030.SDR SWAA2025121853425Web · crackedLEFT WEB FITTING FOUND CRACKED. REMOVED AND REPLACED THE WEB IAW SRM 51-40-02.SDR IXXA121820250001Rub Block · crackedRIGHT WING INBD FLAP T/E FAIRING 671BB HAD A CRACKED RUB BLOCK AT FAIRING AFT ATTACH ARM.SDR 2025FA0000833Thrust Reverser · corrodedCORROSION ON THE INSIDE SURFACE OF LH AND RH ENGINE THRUST REVERSER PIVOT DOORS AND BEAMS. REMOVED CORROSION AND VERIFIED REMAINING MATERIAL THICKNESS TO BE WITHIN TOLERANCE USING ULTRASONIC TESTING. APPLIED TREATMENT, PRIMER, AND TOP COAT AS REQUIRED BY THE MSDR DALA2025121809233Bracket · damagedTOOLING DAMAGE ON BRACKET FWD SIDE OF FRAME 53.3 STR 7 RT. REPLACED BRACKET PER A330 SRM 53-11. (1357382)SDR DALA2025121809230Spar · crackedFOUND A CRACK HOLE ON THE RIGHT OUTER WING REAR SPAR AFT FACE BETWEEN RIBS 4 AND 5, BY ROTATING PROBE. REPAIRED PER ERA 630537-14 REV ORIGINAL. (1356911)SDR DALA2025121809224Transmitter · failed-FCNT/DE- DUE TO FLAP ASYMMETRY ON APPROACH. R & R RT AND LT FLAP TRANSMITTERS, REPLACED PDU SENSOR, FOUND AND REPAIRED BROKEN WIRE AND REPLACED CONNECTOR D1716.