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 CALA2025093009435Light · detachedEMERGENCY FLOOR LIGHT AT SEAT 44D FALLING DOWN, RESECURED EMERGENCY FLOOR PROXIMITY LIGHT AT SEAT 44D IAW AMM B787-A-33-51-06-00A-720A-A. OPS CHECK GOODSDR CALA2025093009434Battery Pack · dischargedOFAR (M33142) BACKUP POWER SUPPLY BATTERY FOUND LOW CAPACITY. REPLACED OFAR (M33142) BACKUP POWER SUPPLY BATTERY PACK AND INSTALLATION TEST,CO RESULT FOUND NORMA L REF AMM 33-29-12-960-809 REV104.SDR CALA2025093009433Channel · puncturedAFT CARGO BAY ZEE ANGLE LH LOCATED BETWEEN STA. 727H AND 727I HAS BEEN PUNCTURED (REF AAR N/R 99951087) REMOVED AND REPLACED AFT CARGO BAY ZEE ANGLE LH BETWEEN STA. 727H AND 727I PER SRM 51-40-02-0G-0 AND DWG#146A7500.SDR CALA2025093009432Door · inoperativeOVRHD BIN 1F INOP OVERHEAD BIN 1 EF WONT LATCH CLOSED MEL 2528AF REJECTED 2528AF IS FOR THE OVERHEAD BIN STORAGE BOX LOCK, NOT THE OVERHEAD BIN DOOR ITSELF..MEL 2528AL IS FOR THE OVERHEAD STOWAGE BIN DOOR SECURED CLOSED. COVER PLATE/RETAINER BROKEN ALLOWING ACSDR CALA2025100109498Floor Support · corrodedMAIN CABIN AFT WET AREA, CORROSION ON FLOOR SUPPORT BS 986.5+5, LBL 33. EVALUATED AREA. FOUND CORRSION OUT OF LIMITS IAW SRM 51-10-02-0G-0. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SEM 51-40-02-0G-0 AND DWG 147A5700.SDR CALA2025100109496Floor Support · corrodedMAIN CABIN AFT WET AREA CORROSION AT FLOOR SUPPORT, BS 1016, RBL 33. EVALUATED AREA, FOUND CORROSION TO BE OUT OF LIMITS IAW SRM 51-10-02-0G-0. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0 AND DWG 147A5700.SDR CALA2025100109494Attach Angle · crackedLEFT VAPOR BARRIER UPPER ATTACHED ANGLE CRACKED AT LBL 7, BS 663. REMOVED AND FABRICATED A NEW UPPER ATTACH ANGLE IAW SRM 57-10-10-2R-5, FIGURE 202, DETAIL B, SHT 4.SDR CALA2025100109492Floor Support · corrodedMAIN CABIN, BS 312-328 LBL12, FLOOR SUPPORT CORRODED ON UPPER SURFACE. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 51-10-51 7A-1 ORIG. .086 REMOVED .015 REMAINING .065. . INSTALLED AN NEW FLOOR SUPPORT IAW SRM 51-40-02 AND DWG 141ASDR CALA2025100109483Light · faultedEMERGENCY WING EXIT DOOR WALL LIGHT OUT ROW 34ABC. PASSENGER CABIN LIGHTING AND ADVISORY SIGNS OPERATIONAL CHECK. REMOVED AND REPLACED EMERGENCY WING EXIT DOOR WALL LIGHT IAW AMM 25-21-20 OPS CHECK GOOD.SDR KCSA2025100192950Landing Gear · no deployRIGHT WING GEAR FAILED TO EXTEND WITH ALTERNATE GEAR EXTENSION, DECLARED EMERGENCY.SDR SWAA2025093019641Cover · inoperativeRIGHT AFTER SERVICE DOOR EXIT LIGHT COVER INOPERATIVE. INSTALLED NEW COVER REF 33-51-01SDR 2025FA0000672Fork · detachedNOSE FORK SEPARATED FROM NLG AT AN UNKNOWN TIME DURING FLIGHT. AIRCRAFT WAS IN A TRAINING ENVIRONMENT WITH REPETITIVE LANDINGS. REGULAR INSPECTION AND LUBRICATION OF THE FORK AND GEAR AT 100 HOUR INSPECTIONS. SUSPECT FAILURE OF THREADED ROD DUE TO NO PRIOR NOSSDR SWIA202509300029Skin · dentedDUE TO BIRD STRIKE, FOUND DENT ON FWD FUSELAGE LOWER LH SIDE SKIN. THE DENT IS LOCATED BETWEEN FR01 AND FR02, AND BETWEEN STGR 25L AND STGR 26L. IT MEASURES 3.3 INCHES LONG, 2.75 INCHES WIDE, AND 0.077 INCHES DEEP. THERE IS A CREASE AND OIL CANNING PRESENT. (SDR AALA202509304096Engine · vibrationAIRCRAFT WAS GROUNDED: AIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: UPON THROTTLE REDUCTION AT TOP OF DESCENT, ENGINE NUMBER 2 DEVELOPED STRONG VIBRATION. AIRCRAFT EMERGENCY LANDED SAFELY AT RSW. ACCOMPLISHED NR 2 ENGINE RUN FOR 20 MINUTES DUE TO ISDR DALA2025093007103Frame · mechanic errorRIGHT SIDE FRAME C 26.1, HOLES ARE MISS DRILLED AND TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627429-14. (1225016)SDR DALA2025093007102Frame · damagedTOOLING DAMAGE - FWD SIDE OF FRAME 62 @ STR P4. CORRECTIVE ACTION: REPAIRED PER ERA 29063-14 REV. ORIG. (1224966)SDR DALA2025093007101Frame · damagedON FR 62 FWD AND AFT SIDE OF STR BAYS P1 AND P'1 HAVE TOOLING MARKS IN MULTIPLE AREAS. CORRECTIVE ACTION: REPAIRED PER ERA 627429-14. (1224968)SDR DALA2025093007099Frame · damagedTOOLING DAMAGE NOTED AT FR60 BETWEEN STR 1L AND STR 2L AND VIEWED FROM AFT SIDE OF FRAME. REPAIRED PER ERA 629449-14 REV. ORIG. (1224961)SDR IPXA2025093098082Bracket · crackedDURING ACCOMPLISHING OF T.C T3F18E007GZC1 FOUND 1EA HYDRAULIC CASE DRAIN LINES SUPPORT BRACKET CRACKED INSIDE ACCESS PANEL 675AB. REMOVED SUPPORT BRACKET IAW SRM 51-40-21. FABRICATED NEW PPORT BRACKET I.A.W A300-600 SRM 57-51-11.INSTALLED NEW BRACKET IAWSDR YENA2025093000978Unknown · odorFLT#2465, BUF-FLL. STRONG ODOR IN THE REAR OF THE CABIN; ACCOMPLISHED INSPECTION OF APU AND APU COMPARTMENT IAW AMM 49-00-00. NO LEAKS NOTED. ACCOMPLISHED DVI OF FUSELAGE + WHEEL WELLS FOR LEAKS IAW AMM 53-00-00. NO LEAKS NOTED ACCOMPLISHED DVI OF ENG 1 + 2 IASDR AALA202509308492Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: DOOR 1L EXIT SIGN HAS FALLEN OFF. MAINTENANCE RESECURED EXIT LIGHT FWD L1 DOOR. OK FOR SERVICE. REF AMM 25-23-44.SDR AALA202509306783Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE: CABIN EMERGENCY LIGHTING SYSTEM, CIDS FAULT EPSU AFT LEFT BATTERY POWER SUPPLY. MAINTENANCE REPLACED FORWARD LEFT EPSU IAW AMM 33-51-38.SDR AALA202509303680Power Supply · faultyAIRCRAFT IN BASE MAINTENANCE: CABIN EMERGENCY LIGHTING SYSTEM, CIDS FAULT EPSU FWD LEFT BATTERY POWER SUPPLY. MAINTENANCE REPLACED FORWARD LEFT EPSU IAW AMM 33-51-38.SDR AALA202509309281Light · damagedAIRCRAFT WAS GROUNDED: EXIT LIGHT AT 4R DOOR IS DAMAGED. MAINTENANCE REPLACED EXIT LIGHT ASSEMBLY. OPS NORMAL IAW MM 33-50-00.SDR AALA202509307006Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: OUT LIMIT RH AFT DOOR (6MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTENANCE REPLACED AFT AND FWD HINGE FITTINGS ON NLG AFT DOOR RH IAW CMM 52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-802-C01 AND CMM 52-82SDR AALA202509300309Hinge · excess playAIRCRAFT IN BASE MAINTENANCE: OUT LIMIT LH AFT DOOR (6MM) IAW JC 26C71032007 IN NOSE WHEEL WELL. MAINTNENANCE REPLACED AFT AND FWD HINGE FITTINGS ON NLG AFT DOOR LH IAW CMM 52-82-32-000-801-B01; CMM 52-82-32-000-803-C01; CMM 52-82-32-400-802-C01 AND CMM 52-82-SDR SCNA20250930388Pitot Tube · obstructedINDICATED AIRSPEED UNRELIABLE ON PFD. FOLLOWED FIM 31-62 TASK 876 AND FOUND CAPTS PITOT PROBE TO BE BLOCKED REMOVED AND REPLACED CAPTS PITOT PROBE IAW AMM 34-11-01 OPS AND LEAK CK GOOD OK FOR SERVICESDR DALA2025093007086Window Frame · crackedCRACKS FOUND IN LT AND RT FRONT WINDSHIELD FRAMES AT LWR CENTER NODE. COMPLIED WITH ER/A 628400-14. (1225292).SDR DALA2025093007085Seat Track · corrodedUPPER FUSELAGE, PAX CABIN SEAT TRACK -Y765 FROM FR65 TO FR66 WITH CORROSION. REPLACED SEAT TRACK AT -Y765, FROM FR65 TO FR66 IAW ER/A #628887-14. (1224708).SDR DALA2025093007084Floor Support · corrodedUPPER FUSELAGE, PAX CABIN FROM 66 TO FR 68 AT -Y1162 FOOR SUPPORT WITH CORROSION. REPLACED THE FLOOR SUPPORT AT -Y1162, FROM FR66 TO FR68 IAW A319 SRM 51-72-11-911-001. (1224701).SDR QXEA2025093000313Battery Pack · faultedFLIGHT 9743. "EMERG LT BATT FAULT" EICAS MSG ILLUMINATED ON LANDING. REMOVED FROM SERVICE. INTERROGATED CMC, COMPLY WITH ASSOCIATED FIM TASK 33-50-00-810-804A THROUGH STEP 8J. FOR FAULT CODE 33500004UT1. FERRIED AIRCRAFT FOR REPAIRS. PERFORMED OPS TEST OF AFT SDR MASA2025092900080Light · inoperativePHOTO ILLUM STRIP INOP FWD GALLEY AREA. R & R PHOTOILUM STRIP IAW E175 AMM 33-50-21.SDR I5PA2025092968806Switch · inoperativeAPU GENERATOR SWITCH INOPERATIVE. REPLACED APU GENERATOR SWITCH PER AMM.SDR QMLA2025092920096Bypass Valve · faultedTHE NUMBER ONE ENGINE OIL TEMPERATURE EXCEEDED THE LIMIT DURING FLIGHT, INDICATING A READING OF 131 DEGREES CELSIUS. FOLLOWED THE EMERGENCY PROCEDURE AND ATTEMPTED TO INCREASE THE AIRSPEED, BUT DID NOT BRING ENGINE TEMPERATURE DOWN TO NORMAL LIMITS. PLACED ESDR JR2R20250929913Strap · chafed147AL, MID AVIONICS-COMPARTMENT ACCESS DOOR, STRAP IS CHAFED OUT OF LIMITS. REPAIREDSDR GTIA2025092939109A/C Pack · odorWHILE DESCENDING THROUGH 13,000 OBSERVED MUSTY ODOR IN FD, TURNED OFF PACK 1 ODOR DISSIPATED. DESCRIPTION OF ODOR/FUMES: TEMPORARY, MUSTY DRY SMELL. APPARENT CABIN SOURCE: CABIN ITEM. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION.-REF TSM 05-50-00-8SDR SWAA2025092919181Trim Motor · looseELECTRIC STABILIZER TRIM INOP AFTER TAKE OFF. FOUND STABILIZER TRIM MOTOR ELECTRICA CONNECTOR D700 LOOSE. AS PRECAUTION, R&R STABILIZER TRIM MOTOR PER AMM 27-41-71. OPS CHECK GOODSDR JJBA20250929043Floor Support · corrodedCFII, LH SILL #3 BTW FR 29-36 FOUND CORRODED. CFII, LH SILL #2 BTW FR 29-36 BLENDED AND FOUND OUT OF LIMIT. CFII, LH SILL #3 BTW FR 29-36 REMVOED AND REPLACED WITH NEW.SDR DALA2025092907026Power Supply · disconnectedAIRCRAFT 5094, 6X EPSU DISCONNECTED. RE-CONNECTED 6X EPSU IAW A321 AMM 33-51-38-400-001-A. OPERATIONAL CHECK BY BITE CHECK PERFORMED IAW A321AMM33-51-00-710-001-A, PASSED. (LP 6804607)SDR EE4Y2025092923243Frame · crackedDURING THE ACCOMPLISHMENT OF EO737-53-0388_P1 WAS FOUND IN THE LOWER FUSELAGE RH STA 727 FRAME INNER CHORD AND S-18A WEB AT LOWER OPEN FASTENERS HOLE WITH CRACK INDICATION. DUE TO IT, THE PART WAS REPLACED IAW NAC ENGINEERING ORDER #737-53-0403 REV. IR. UNDERJSDR FDEA202509291852Floor Panel · damagedBROKEN FLOOR PANEL 221CFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 221CFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291851Floor Panel · damagedBROKEN FLOOR PANEL 251HFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 251HFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291850Floor Panel · damagedBROKEN FLOOR PANEL 221EFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 231EFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291849Floor Panel · damagedBROKEN FLOOR PANEL 241ZFF, MIAN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 241ZFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291848Floor Panel · damagedBROKEN FLOOR PANEL 252CFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 252CFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291847Floor Panel · damagedBROKEN FLOOR PANEL 251FFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 251FFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291846Floor Panel · damagedBROKEN FLOOR PANEL 251EFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 251EFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291845Floor Panel · damagedBROKEN FLOOR PANEL 252BFF, MAIN DECK CARGO COMPARTMENT. MAIN DECK CARGO COMPARTMENT FLOOR PANEL 252BFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15, 2025.SDR FDEA202509291844Skin · damagedNICK ON SLAT 8 TRAILING EDGE LOWER SKIN AT 42 IN. FROM INB EDGE. SLAT 8 TRAILING EDGE LOWER SKIN AT 42 IN FROM INB EDGE WAS REPAIRED I.A.W. B767 SRM 57- 43-02-2R AND 51-70-10-2R REPAIR 4 FIG 202 SHEET 1 REV 92 APR-15-2025SDR ABXA20250929241Bleed Valve · warning messageON T/O ROLL, (R ENG BLEED VAL) CAUTION MSG APPEARED. ABORTED TAKE-OFF AT 68 KNTS AND RETURNED TO GATE (BTB) AND MTX GROUNDED A/C .MTX DEFERRED RH ENGINE BLEED IAW MEL ABX - 36-11-2-1. AND RETURNED A/C TO SERVICE.