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 CALA2025071406497Skin · dentedREMOVE AND REPLACE THE AFT CARGO DOOR EXTERNAL SKIN DUE TO EXC ESSIVE DENTS DAMAGE. AFT CARGO DOOR RE-SKINNED IN RFD DURING D CHECK DUE TO EXCESSIVE DENTS. REMOVED & REPLACED THE AFT CARGO DOOR EXTERNAL SKI N IAW B737-800 SRM 52-30-01-2R-3. OK TO CLOSE REMSDR DALA2025071405272Lamp · inoperativeSHIP 0185 2L DOOR SLIDE ARMED INDICATING LIGHT INOP ON FWD FLT ATT PANEL. CORRECTIVE ACTION: RELAMPED ARMED LIGHT ON FLIGHT ATT PANEL FOR DOOR 2 LEFT PER B767-300AMM 33-16. (1073047).SDR DALA2025071405253Frame · dented(LOG 1072894) DENT ON FRAME STA 460 AND BTW S24L TO S25L AT FWD CARGO COMP. DENT ON FRAME STA 460 AND BTW S24L TO S25L AT FWD CARGO WAS REPAIRED PER B737-800 SRM 53-30-07-2R PROCEDURE 2, REPAIR 2.SDR JJBA20250714047Shear Tie · crackedCF2 LH SHEAR CLIP FR 28 BTW STR 15L-16L CRACKED. CF2 LH SHEAR CLIP FR28 BTW STR 15L-16L REMOVED AND REPLACEDSDR MASA2025070900056Warning Message · illuminatedENGINE 2 FUEL LOW PRESSURE EICAS MESSGAE - PLACED ON MEL.SDR AALA202507134572Memory Device · faultedAIRCRAFT WAS GROUNDED: CAPTAIN REPORTED. LEFT AFT CENTER PUMP LOW PRESSURE LIGHT CAME ON WITH PUMP ON. LIGHT WENT OUT WHEN PUMP TURNED OFF. REPLACED UFI (AALA202507136245) AND RAM (AALA202507134572) ASSEMBLY. PER AMM 28-22-99. OPERTIONAL CHECK GOOD.SDR AALA202507133586Flashlight · missingAIRCRAFT IN BASE MAINTENANCE: FORWARD AND AFT FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHTS MISSING. INSTALLED FORWARD (AALA202507134816) AND AFT (AALA202507133586) FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHTS AND PERFORMED SATISFACTORY TEST. PER B737-NG AMM 25-6SDR AALA202507134816Flashlight · missingAIRCRAFT IN BASE MAINTENANCE: FORWARD AND AFT FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHTS MISSING. INSTALLED FORWARD (AALA202507134816) AND AFT (AALA202507133586) FLIGHT ATTANDENT SEAT EMERGENCY FLASHLIGHTS AND PERFORMED SATISFACTORY TEST. PER B737-NG AMM 25-6SDR AALA202507136245Ufi · false indicationAIRCRAFT WAS GROUNDED: CAPTAIN REPORTED. LEFT AFT CENTER PUMP LOW PRESSURE LIGHT CAME ON WITH PUMP ON. LIGHT WENT OUT WHEN PUMP TURNED OFF. REPLACED UFI (AALA202507136245) AND RAM ASSY. (AALA202507134572) PER AMM 28-22-99. OPERTIONAL CHECK GOOD.SDR 4TXA202507120162Blade · out of balanceRIGHT ENGINE HIGH VIBRATION REACHED 4.2 IN CLB. PERFORMED QRH TEST. SIGNIFICANT AMOUNT OF THRUST RETARD TO DROP BELOW ACCEPTABLE LIMITS. REACHED 4.0 IN CRZ @FL 350. FAN BLADE TRIM BALANCING DONE WITH BALANCE SCREW ADDED TO SPINNER CONE AND CORRECTED THE ISSSDR N6WA2025071206Rib · damagedRH RIB AT SLAT STATION 58.41 IS DAMAGED. ACCOMPLISHED REPAIR AND INSTALLED RIB IAW GOJET EO-C550-57MR-011SDR N6WA2025071205Skin · puncturedPUNCTURE HOLE RH FUSELAGE AT FS661-FS677 BETWEEN STGR8R-STGR9R. REPAIRED RH FUSELAGE AT FS661-FS677 BETWEEN STGR8R-STGR9R IAW GOJET EO C550-53MR-079SDR ASAA2025070959352Door · no discrepancyFA SAYS L1 DOOR DIFFICULT TO OPEN AND CLOSE. GROUNDED - YES. VERIFIED L1 DOOR OPEN AND CLOSE AS INTENDED.SDR ASAA2025070959351Guide Arm · out of adjustFA REPORTS L1 DOOR DIFFICULT TO OPEN AND CLOSE. GROUNDED - YES. PERFORMED FWD ENTRY DOOR SYSTEM TEST PER AMM 52-11-00. 4.E.(3) DOOR HANDLE TORQUE TEST, STEP (3)(D) TORQUE IS OUTSIDE OF THE SPECIFIED RANGE. ADJUSTED GUIDE ARM ADJUSTER NUT ONE FLAT EXTENDED AND SDR SWIA2025071100009Acm · smokeCOCKPIT FILLED WITH SMOKE DURING TAXI. SHORTLY AFTER, L PACK FAULT MESSAGE. QRH STOPPED SMOKE FROM CONTINUING. (FLIGHT 5306 - FILED CLOSED)PILOT REPORTED SMOKE IN COCKPIT WITH LITTLE SMOKE IN CABIN. COMPLIED WITH FIM FOR ABNORMAL SMELL REF FIM 21-21-00. ISOLSDR SWAA2025071189307Flashlight · inoperativeFWD FLIGHT ATTENDANT FLASHLIGHT INOP.SDR SWAA2025071189680Light · looseFLOOR PROXIMITY TRACK LOOSE 8DEF. RESECURED PROX TRACK NEAR 8DEF IN REFERENCE TO AMM 33-51-15.SDR SWAA2025071189377Bulkhead Web · crackedWING CENTER RIGHT LOWER WEB HAS A 4.0' CRACK IN THE WEB VAPOR BARRIER LOCATED BETWEEN RBL 25 AND RBL 31.83. COMPLIED WITH EA: M-21-157-00675 (REAR SPAR BS 663 VAPOR BARRIER (WHEEL WELL FWD BULKHEAD) - INTERIM REPAIR).SDR SWAA2025071189378Bulkhead Web · crackedRIGHT LOWER WEB HAS A 7.0' CRACK IN THE WEB VAPOR BARRIER LOCATED BETWEEN RBL 31.83 AND RBL 40.0<[01] COMPLIED WITH EA: M-21-157-00675 REAR SPAR BS 663 VAPOR BARRIER (WHEEL WELL FWD BULKHEAD) - INTERIM REPAIR).SDR SWAA2025071189332Seal · crackedLEFT STABILIZER-TO-BODY UPPER FRONT SPAR SLIDING SEAL CRACKED. REPAIRED LEFT STABILIZER-TO-BODY UPPER FRONT SPAR SLIDING SEAL IAW EA 25-153-01834.SDR SWAA2025071189333Seal · crackedRIGHT STABILIZER-TO-BODY UPPER FRONT SPAR SLIDING SEAL CRACKED. REPAIRED R/H HORIZONTAL STAB FWD UPPER SLIDING SEAL IAW EA 25-153-01834. TIME LIMITED REPAIR.SDR WX0A2025071132499Hinge · worn(AIRCRAFT GROUNDED) REF TC 53-140-003, NOTED LT MLG DOOR FWD HINGE WITH WEAR MARK ON AFT LUG FWD FACE, MEASURING 1.851 - IN L , 0.425 - IN W , 0.022 - IN D . / (RESOLVED ON W/O: 525711 TASKCARD: NR-00002 ) C/W REPAIR OF DAMAGE ON L/H MLG FWD HINGE FITTING PER SDR WX0A2025071132497Megaphone · inoperative(AIRCRAFT NOT GROUNDED) FWD MEGAPHONE INOP. R&R FWD MEGAPHONE AND OPS CHECK GOOD IAW AMM 25-65-51"SDR DALA2025071105234Skin · ground damage(LOG 1072500) FUSELAGE SKIN AND FWD P-DOME CHORD STA 1013 BETWEEN STR 15L & STR 16L GROUND DAMAGE. REPAIRED DAMAGE PER ERA 460585-14.SDR DALA2025071105233Support · worn(LOG 1073089) WEAR ON UPPER SUPPORT OF JACKSCREW (AFT ACCESSORY COMPARTMENT AREA). UPPER SUPPORT OF JACKSCREW AFT ACCESSORY COMPARTMENT AREA WAS REPAIRED PER ER/A 627381-14 REV. ORIGINAL SECTION I PERMANENT REPAIR AND PRI 627381-14 REV.1SDR DALA2025071105232Floorbeam · corroded(LOG 1072736) CORROSION AT FLOOR BEAM STA 986.5 BTW LBL 18 TO LBL 40, PREVIOUS REPAIR BTW LBL 40 TO LBL 50 PAX CABIN. FLOOR BEAM STA 986.5 BTW LBL 18 TO LBL 50 PAX CABIN WERE REPAIRED PER ER/A 464736-14MA REV A.SDR DALA2025071105230Floor Support · corroded(LOG 1071838) CORROSION ON FLOOR STRUCTURE ANGLES (3E/A) BTW STA 260 AND STA 270 BTW LBL 11 AND RBL 11 AT FLIGHT COMPARTMENT. FLOOR STRUCTURE ANGLE (1EA) BTW STA 270 BTW LBL 11 AND RBL 11 WAS REPAIRED PER ER/A 627248-14 REV. ORIGINAL SECTION I: PERMANENT REPAISDR JJBA20250711020Shear Tie · crackedSHEAR TIE CRACKED AT STR 6R AND 7R FRAME 60. REMOVED SHEAR TIE, LOCATED, DRILLED AND INSTALLED NEW PART.SDR JJBA20250711019Shear Tie · crackedSHEAR TIE CRACKED AT STR 6L AND 7L FRAME 60. REMOVED SHEAR TIE, LOCATED, DRILLED AND INSTALLED NEW PART.SDR DALA2025071105221Proximity Sensor · faultedSHIP 3420 DOOR 1R OPEN INDICATION, DURING TAXI OUT EVEN THOUGH DOOR WAS CLOSED. CORRECTIVE ACTION: R/R DOOR 1R PROX SNSR 10MJ LOCKING MECHANISM PER A330 AMM 52-71. (7435118)SDR YENA2025071100720Sign · detachedFLT#2931, SJU-PUJ. "R1 ABOVE DOOR EMERGENCY EXIT SIGN BROKEN / FELL OFF IN FLIGHT; REMOVED AND REPLACED R1 DOOR EXIT LIGHT LENS ALL NORMAL. REF 33-20-00, MX-4 UPDATED."SDR REXA2025071100718Lamp · inoperativeCEILING EMERGENCY LIGHT AT ROW 10 INOP RELAMPED CEILING EMER LIGHT IAW CRJ 900 AMM 33-51-09 OPS CHECK GOODSDR YENA2025071100719Unknown · odorFLT#69, BOS-FLL. "F/A INDICATE MUSTY SMELL FROM ROW 4-13 FAINT SMELL; COMPLIED WITH INFO NOTICE 2017-T015,SECTION B2 IDENTIFIED ODOR TYPE 1 DECON LEVEL 2 IAW AMM TSM 05-50-00-810-831-A"SDR VNAA2025071111102Selector Valve · faultedLANDING GEAR HANDLE PUT IN GEAR DOWN, LANDING GEAR DID NOT MOVE. GEAR DISAGREE RED MASTER WARNING. WRC/QRH CYCLED GEAR WITH NO CHANGE. PERFORMED MANUAL GEAR EXTENSION / REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE IAW CRJ AMM 32-32-10-000/400-801. ALL OPS SDR VNAA2025071111101Tire · blownON TAKE OFF TIRE BLEW, ON GROUND CONFIRMED TREAD MISSING LEFT OB MAIN TIRE / REMOVED AND REPLACED THE #1 MLG TIRE WHEEL ASSEMBLY IAW CRJ900 AMM 32-41-01-000/400-801-A01.SDR DXTA2025071104181Smoke Detector · defectiveREPEAT WRITE-UP, DURING PREFLIGHT AND AFTER BAGGAGE FIRE TEST WAS COMPLETED WE GOT RED BAGGAGE FIRE CAS AND A RED BAGGAGE FIRE PUSH BUTTON ILLUMINATED. APU SHUT DOWN. RAN CHECKLIST BUT DID NOT DISCHARGE FIRE BOTTLE. WENT TO VIZUALLY INSPECT BAGGAGE BAY, NO FISDR DXTA2025071104183Warning Message · false activationBRK FAIL YELLOW CAS ILLUMINATED. UNABLE TO DUPLICATE CAS MESSAGE AT THIS TIME. FDR & CMC DATA WAS ANALYZED BY CONTACT CENTER AND FLEET TACTICAL MANAGER, NO ISSUES FOUND RELATED TO BRK FAIL AMBER CAS. COMPLIED WITH TAXI CHECKS REQUESTED BY FLEET MANAGER, NO DSDR DXTA2025071104184Control Valve · defectiveAPPROX. 5 MINUTES AFTER FINISHING ECS 2 VALVE FAIL QRH, A GRADUAL LOSS OF CABIN PRESSURIZATION STARTED. CABIN ALTITUDE WAS ROUGHLY 3000FT. ROUGHLY 2-3000FPM CLIMB IN THE LOSS OF PRESSURIZATION, RATE READING WAS IN THE RED. THIS OCCURED WHILE AT 280+KTS, ROUGHSDR CALA2025071106476Engine · damagedENG 1 EGT EXCEEDANCE ON TAKEOFF, AHM SHOWS MAX TEMP 636, TOTAL TIME OVER LIMIT 74 SEC OF EXCEEDANCE INFORMATION REF LP 5499926 ENGINE 1 SN 7 HPT 1ST -STAGE BLADES HAVE TRAILING EDGE AIRFOIL BURNING. 2 ADJACENT BLADES HAVE EROSION IN COMBINATION WITH BURNING.NOSDR CALA2025071106474Hose · leakingHYDRAULIC FLUID LEAKING OUT OF HYDRAULIC LINE IN NLG AREA. FOUND INBOARD HYDRAULIC HOSE DAMAGED BEHIND LEFT NOSE LANDING LIGHT. REF PHOTO FOR LINE LOCATION. HOSE PART # AS115-10K0460. REF IPC 32-51-80-05, FIG ITEM 40. SUSPECT HYDRAULIC LEAKING OUT OF RIGID LSDR CALA2025071106473Hose · leakingLOST ALL LEFT SIDE HYD FLUID UPDATING PICS FOUND RIGHT HAND TRUCK POS PRESSURE HOSE LEAKING, REPLACED IAW AMM 32-32-50 AND SYSTEM SERVICED AS PR 12-12-01 LEAK CHECKED AND OP TESTS SATIS.SDR CALA2025071106472Proximity Sensor · faultedOVR HD LEFT GEAR GREEN LIGHT REMAINED ILLUMINATED AFTR TAKEOFF AND WOULD NOT RETRACT INDICATION. PREFORMED PSEU BITE FOUND FAULT CODE 32-61007. REF FIM 32-61 TASK 801 DEPINNED THE SENSOR AND REMOVED OLD SENSOR ROUTED NEW HARNESS AND INSTALLED NEW SENSOR S100SDR CALA2025071106464Drain · leakingLOSING CENTER HYDRAULIC SYSTEM FLUID. CURRENTLY ABOUT 47% LEFT IN RESERVOIR. FOLLOWED FLIGHT MANUAL NON-NORMALS 2.130.8 AND HAVE 2 ACMP & AIR DRIVEN PUMP OFF TO PRESERVE FLUID FOR LANDING. UPON FURTHER INVESTIGATION SEAL ON RETURN SIDE OF C2 CASE DRAIN ASSY SDR CALA2025071106463Skin · dentedACCOMPLISH PERMANENT REPAIR AS PER EC/RA 5360-01922 PART 3 AT SEC 46 FUSELAGE SKIN STA 800 BETWEEN S-25R AND S-27R. ACCOMPLISHED PERMANENT REPAIR CATEGORY B AT FUSELAGE SKIN BETWEEN BSTA 787 AND BSTA 807 AND BETWEEN STR-25R AND STR-27L IAW EC/RA 5331-03170, PSDR CALA2025071106455Slide · misinstalledEXCESS SLIDE MATERIAL HANGING DOWN FROM DOOR 1R. REPACKED SLIDE IAW AMM TASK 25-66-01-000-801 & 25-66-01-400-804. OK TO CONTINUE.SDR CALA2025071106454Hook · out of adjustFWD SERVICE DOOR EMERGENCY SLIDE ACTIVATION BAR NEEDS TENSIONING ADJUSTED GIRT BAR HANGAR J HOOKS PER AMM25-66-01.SDR CALA2025071106453Retainer · out of adjustR1 DOOR GIRT BAR STOW HOOK IS LOOSE ALLOWING BAR TO EASILY SLIP OUT WHEN OPERATING DOOR ADJUSTED R1 GIRT BAR RETAINER HOOK HAS POSITIVE RETENTION IAW 52-11-00SDR SWAA2025071089617Unknown · odorIN RAISE FLIGHT ATTENDANTS NOTICED AN ACRID ELECTRICAL SMELL IN THE AFT GALLEY. NO SMOKE WAS SEEN. SMELL DIMINISHED AFTER 20 MINUTES. INSPECTED CABIN AND AFT GALLEY FOR FUMES & SMOKE IAW AMM 05-51-56. NO DISCREPANCIES NOTED. OK FOR SERVICE.SDR SWAA2025071089958Winglet · crackedCRACK ON LEADING EDGE OF RIGHT SIMITAR WINGLET. CW EA 25-157-01843, SPEED TAPE APPLIED.SDR SWAA2025071089952Flashlight · inoperativeTHREE FLASHLIGHTS IN CABIN INOPERATIVE. OPS CHKD THE THREE FLASHLIGHTS PER AMM 25-64-00 OPS NORMAL.