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 AALA202511190417Pump · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING CRUISE NR 2 FUEL TANK AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AND REMAINED ILLUMINATED. VERIFIED NR 2 AFT FUEL BOOST PUMP INOPERATIVE. REMOVED AND REPLACED NR 2 AFT FUEL TANK IMPELLER PUMP MOTOR. PER AMM 28-22-41. OPS CSDR AALA202511130073Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 284.5, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR DALA2025111208300Oil Cap · unsecureNOTICED UNPLEASANT ODOR ON TAXI IN AFTER APU START AND OBSERVED LEAKING DARK FLUID UNDERNEATH APU COMPARTMENT ON SUBSEQUENT WALK AROUND. APU OIL CAP NOT PROPERLY SEATED AND APU AND COMPARTMENT AND AFT FUSELAGE COVERED WITH OIL. THE APU OIL CAP WAS PROPERLY SSDR IPXA2025111187420Door · inoperativeCOCKPIT LIFE RAFT STOWAGE COMPARTMENT DOOR WILL NOT STAY OPEN. FOUND BUSHING LOSE IN PFM BOX. INSTALLED SHOCK STRUT IN COCKPIT LIFE RAFT STOWAGE BOX COMPARTMENT DOOR AS PER B767 AMM 20-11-00 AND IPC 25-62-55. OPS CHECK NORMAL.SDR SWIA202511100003Windshield · crackedRH WINDSHIELD FOUND TO HAVE CRACKS UPON ARRIVAL, REQUIRES REPLACEMENT. REMOVED AND REPLACED RH WINDSHIELD REFERENCING APPLICABLE STEPS OF CRJ550 TASK CARD 56-220-1000-SKY AND CRJ550 AMM 56-11-01.SDR SWAA2025110731543Light · inoperativeSIDEWALL LIGHT AT ROW 15ABC INOPERATIVE. R & R THE SIDEWALL LIGHT IAW AMM 33-51-04, OPS CHECKED GOOD.SDR SWAA2025110731301Fuse · failedEMERGENCY EXIT LIGHTS L01207 AND L01208 DO NOT ILLUMINATE. REMOVED AND REPLACED FUSE IN M1694 AND PERFORMED A GOOD TEST IAW AMM 33-51-06-960-804.SDR DALA2025110708146Sign · detachedSHIP 9550 FA REPORTS EXIT SIGN AT FWD FIRST CLASS CABIN DETACHED. CORRECTIVE ACTION: RESECURED HARDWARE ON EXIT SIGN. (7585210)SDR DALA2025110708138Panel · not reportedFABRICATED PANEL STILL NEEDS LIGHT ASSY INSTALLED. INSTALLED AFT COMPARTMENT LT PER B717 AMM 33-51. OP CHECK NORMAL . OK FOR SVC. (7724261)SDR AALA202511070711Target · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 4L INDICATES BEING ARMED WHILE IT IS NOT. MAINTENANCE FOUND CANNON PLUG 15WV1A WAS NOT FULLY SEATED AND SECURED IT. (AALA202511077273) MAINTENANCE ALSO FOUND TARGET ON PROXIMITY SENSOR TARGET ON 15WV1 WAS LOCKED IN THE FULL NEARSDR AALA202511077273Elec Connector · not seatedAIRCRAFT WAS NOT GROUNDED: DOOR 4L INDICATES BEING ARMED WHILE IT IS NOT. MAINTENANCE FOUND CANNON PLUG 15WV1A WAS NOT FULLY SEATED AND SECURED IT. (AALA202511077273) MAINTENANCE ALSO FOUND TARGET ON PROXIMITY SENSOR TARGET ON 15WV1 WAS LOCKED IN THE FULL NEARSDR UIEA2025110301292Flashlight · inoperativeCAPT FLASHLIGHT INOP. REPLACED CAPT EMERGENCY FLASHLIGHT PER AMM 25-64-01. REF IPC 25-64-51-03.SDR CALA2025110711003Door · damagedPDA 1 RIGHT MLG DOOR AND ATTATCHING HARDWARE DEPARTED AIRCRAFT AFTER MLG NO1 BLOW OUT REF LOGPAGE 6831361 FOR EVENT IMAGES ADDED TO LOGPAGE SDR ADDED TO LOGPAGE SDR CORRECTED CORRECTION TO DISCREPANCY: "LEFT MLG DOOR". NO DEFECTS IDENTIFIED ON RIGHT MLG DOOR SDR DXTA2025110705559Battery Pack · defectiveTWO FORWARD RIGHT EXTERIOR , ONE MAIN CABIN ENTRY, THREE MAIN CABIN OVERHEAD EMER LIGHTS REMAINED INOP AFTER 2 30 MINUTE CHARGE CYCLES. REPLACED BATTERY PACKS. OPS CHECK GOOD. IAW MM 33-50-10SDR DXTA2025110705555Pdu · defectiveREPEAT WRITE-UP. AT FL240 AND APPROXIMATELY 15 MINUTES FROMLAX WE GOT AN AMBER R REV UNLOCKED CAUTION EICAS MESSAGE AND ASSOCIATED EMER STOW UNLK SWITCH LIGHT. RAN THE QRH WITH CAUTION MESSAGES NOT EXTINGUISHING. PER THE QRH RIGHT ENGINE WAS SHUT DOWN AND WE SDR DXTA2025110705556Pdu · defectiveREPEAT WRITE-UP. AT FL240 AND APPROXIMATELY 15 MINUTES FROMLAX WE GOT AN AMBER R REV UNLOCKED CAUTION EICAS MESSAGE AND ASSOCIATED EMER STOW UNLK SWITCH LIGHT. RAN THE QRH WITH CAUTION MESSAGES NOT EXTINGUISHING. PER THE QRH RIGHT ENGINE WAS SHUT DOWN AND WE SDR DXTA2025110705557Battery · failedEMERGENCY LIGHT TURNED ON IN FLIGHT AND WONT EXTINGUISH. REPLACED THE BATTERIES. OPS CHECKED GOOD IAW AMM 33-52-01.SDR SWAA2025110631198Flashlight · no testAIRCRAFT FORWARD GALLEY EMERGENCY FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED IAW AMM 25-64-00-900-806-NG.SDR SWAA2025110631158Flashlight · no testFLASH LIGHT IN AFT RH I/B POSITION LED CHECK FAILED. REMOVED AND REPLACED FLASH LIGHT BATTERY FOR FLASH LIGHT IN AFT RH I/B POSITION IN REF TO AMM 25-64-00; OPS CHECK GOOD AT THIS TIME.SDR SWAA2025110631577Girt Bar · out of adjustFWD SERVICE DOOR SLIDE CLIPS NEED ADJUSTMENT. ADJUSTED GIRT BAR SPRING CLIPS PER MM 25-66-01.SDR SWAA2025110631166Rivet · missingFOUND R1 DOOR RT BOTTOM RIVET MISSING ON GIRT BAR RETAINING CLIP. INSTALLED NEW RIVET ON MISSING R1 DOOR RT BOTTOM CLIP PER SIP.SDR SWAA2025110631204Girt Bar · looseFWD SERVICE DOOR GIRT BAR BRACKET RIVETS LOOSE. OK TO CONTINUE PER TLD EA M-23-125-01839.SDR SWAA2025110631573Sign · detachedEXIT SIGN COVER AT RIGHT OVER WING EXIT FELL OFF. REINSTALLED EMERGENCY EXIT SIGN AT RIGHT OVER WING EXIT IAW AMM 33-51-01.SDR SWAA2025110631261Light · inoperativeSIDEWALL LIGHTS INOPERATIVE FOLLOWING LOCATIONS: ROW 12 & 18 RH SIDE, ROW 14 LT SIDE. REPLACED THE LAMPS 12 AND 18 DEF AND 14 ABC SIDEWALL LIGHTS IAW AMM 33-21-00.SDR COEA2025110612738Panel · crackedNUMBER 2 ENGINE INBD PLENUM PANEL SKIN CRACKED AT AFT END OF TOP STIFFENER. STOP DRILLED CRACK AND COVERED WITH SPEED TAPE IAW DQ428170M2. REPLACED THE PLENUM PANEL IAW MM 6-40-50 REV. 5 AND IPC 54-10-25-01 REV. 10.SDR COEA2025110611738Panel · crackedWO 272105 NR 6 MINOR REPAIR/DISCREPANCY: #1 ENGINE OUTBOARD PLENUM PANEL SKIN CRACKED AT AFT END OF TOP STIFFENER. STOP DRILLED CRACK AND COVERED WITH SPEED TAPE IAW DQ428170M2. REPLACED THE PLENUM PANEL IAW MM 6-40-50 REV. 5 AND IPC 54-10-25-01 REV. 10.SDR COEA2025110610738Panel · crackedWO 272105 NR 5 MINOR: NR 1 ENGINE INBD PLENUM PANEL SKIN CRACKED AT AFT END OF TOP STIFFENER. REPLACED THE PLENUM PANEL IAW C408MM 6-40-50 REV.11SDR F3LA202511060323Throttle · fodTHIRD WRITE-UP THRUST LEVERS STIFF. REQUIRES SO MUCH FORCE TO COME OUT OF REVERSE THAT LEVERS INADVERTENTLY GO TO CLIMB DETENT. PERFORMED ENGINE THROTTLE CONTROL LEVERS TROUBLESHOOT AND ADJUSTED THE MECHANICAL LINKAGE PER AMM 76-11-00-820-044-A ADJUSTMENT WISDR AALA202511066903Pin · damagedAIRCRAFT WAS GROUNDED: L1 DOOR SUPPORT ARM PIN DAMAGED WHERE IT ATTACHES TO THE DAMPER AND EMERGENCY OPERATION CYLINDER. REPLACED PIN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-14.SDR N6WA2025110605Stringer · chafedSTRINGER 7R BETWEEN FS1144-FS1162 HAS CHAFED. REPAIRED THE STRINGER IAW EO-C550-53MR-107-O.SDR N6WA2025110602Floor Support · corrodedCORROSION ON RH FLOOR SILL BETWEEN BS 280 - 319, RBL 27. REMOVED AND REPLACED RH FLOOR SILL IAW SRM 51-42-06.SDR N6WA2025110601Warning Message · illuminatedGEAR DISAGREE WARNING MESSAGE IN FLIGHT. DEFERRED LANDING GEAR RETRACTION IAW MEL 32-30-01 CAT A OCN 70095623. MX PROCEDURES COMPLIED WITH. AUTH BY MXCSDR DALA2025110608090Idg · inoperativeON TAXI IN UPON SHUTDOWN OF ENG NR 2 ENTIRE JET WENT BLACK, GEN 1 DID NOT PICK UP THE LOAD VIA BUS TRANSFER. SWITCH IS IN AUTO POSITION. R/R NBR 1 IDG PER AMM 2411. OPS CKS GOOD.SDR DALA2025110608087Light · inoperativeROW 18 DEF LOWER EMERGENCY EXIT SIGN INOPERATIVE. R & R EXIT LED ASSY IAW MM 33-51. CHECKED OK.SDR CALA2025110610977Skin · crackedCRACK INDICATION AT THE MOST OTBD FASTENER HOLE AT STR 9 ON THE RT WING LOWER SKIN APPROX .75" IN LENGTH AT THE 6 O'CLOCK POSITION LOOKING AFT. REPAIRED RT WING LOWER SKIN IAW REO G25610, REV IR, AND EC/RA 5720-03575. MAJOR REPAIR.SDR CALA2025110610964Fuel Cap · missingFUELER REPORTS FUEL CAP IS MISSING FROM AIRCRAFT. INSTALLED A NEW FUEL CAP IAW AMM 28-25-41.SDR CALA2025110610962Power Supply · no testBATTERY PACK FAILED FUNCTIONAL CHECK, REMOVED AND REPLACED THE M1675 BATTERY PACK AND POWER SUPPLY IAW AMM 33-51-06.SDR CALA2025110610943Unknown · odorJET FUEL ODOR IN AFT GALLEY AREA DURING TAKEOFF AND LANDING. PERFORMED APU DRAIN MAST INSPECTION IN REF AMM 49-16-11. NO FUEL LEAK DETECTED PERFORMED SMOKE OR FUMES IN CABIN CONDITIONAL INSPECTION IN REF AMM 05-51-56. NO FUEL FUMES DETECTED IN CABIN. ENGINE RUSDR CALA2025110610942None · noneF/A REPORTED STRONG FUMES IN CABIN ON TAXI OUT. TRIED ALL COMBINATION OF PACKS, BLEED AIR M & L IAW AMM 05-51-58-910-801-C1, PERFORMED CONDITIONAL INSPECTION, FOUND NO DEFECTS. SUSPECT INJESTION OF ENGINE EXHAUST DUE TO HIGH WINDS. ITEM HAS NO REPORTED HISTOSDR CALA2025110610939Light Sys · no discrepancyEMERGENCY LIGHTS BETWEEN ROW 33 AND 38 LT & RT, NOT WORKING. COMPLETED FULL TEST OF EMERGENCY LIGHT SYSTEM IAW MM DMC-B787-A-33-51-00-07A-343A-A. NO FAULTS FOUND, ALL LIGHTS OPERATING NORMALLY.SDR DALA2025110608082Oxygen Mask · leakingCREW OXYGEN LEAKING AT A RATE OF 41 PSI SINCE LAST SERVICE. R & R THE OBSERVER STOWAGE BOX AND OXYGEN MASK IAW AMM 35-12. (1286068).SDR R61A2025110600489Skin · crackedDISCOVERED LT WING LOWER SKIN CRACKED BETWEEN RIBS 16 & 17, JUST AFT OF FWD SPAR. REPAIRED IAW ETD2025-170-931566, REF VP-047362-2025 NR 2 FOR WORK ACCOMPLISHED.SDR QMLA2025110320111Brake Sys · weakUPON LANDING THERE WASN'T ANY BRAKE PRESSURE.SDR ASAA2025110362084Door · out of adjustFA REPORTS L1 DOOR DIFFICULT TO OPEN AND CLOSE. GROUNDED - YES. ACCOMPLISHED L1 DOOR SYSTEM TEST, VISUAL INSPECTION AND OP'S CHECK REF MM 52-11-00, ALL CHECK GOOD. VERIFIED UPPER GUIDE ARM JAM AND AJUSTER NUT ARE SECURE PER TECH SERVICES REQUEST, REF AMM 52-11SDR CALA2025110510925Fanwheel · seizedENG EGT 941 2 MIN AFTER NORMAL ENG START. LOCKED FOR POSITIVE FIX PER CREW COMMENT, #1 ENGINE STARTED NORMALLY, THEN 2 MINUTES AFTER ENGINE START EGT SPIKED. CREW IMMEDIATELY SHUTDOWN ENGINE. ON VISUAL EXAMINATION, EXHAUST HAS NO DEBRIS, THE FAN DISK IS SSDR CALA2025110510924Retainer · wornFOUND DAMAGE TO PNEU ACCESS PANEL DOOR LATCHES WORN BEYONG LIMITS.PERFORMED STEPS 4A THROUGH 4E IRW SRM 57-10-13-2R-3. PERFORMED STEPS 4F AND 4G HFEC OF CUTOUT AND HFEC HOLE PROBE COMMON TO THE REPAIR AREA. NO FURTHER DEFECTS NOTED REF SRM 57-10-13-2R-3 AND SDR CALA2025110510923Wire · burnedMAINTENANCE MESSAGE 24-13063 POWER BUS AC GND SVCE SEC 1 BUS IN P320 IS NOT POWERED, PERFORMED A COMPLETE GROUND SERVICE BUSS TEST WITH NO ISSUES. PERFORMED TROUBLESHOOTING IAW FIM 2 4-51 TASK 805 REV 105 AND REPLACED WIRE W3241-0010-12 IAW SWP M 20-10-11 RESDR AALA202511058338Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER ACCUMULATOR PRESSURE IS BELOW PS CHK LIMIT. MAINTENANCE SERVICED R2 DOOR DAMPER ACCUMULATOR PRESSURE IAW AMM 52-10-00.SDR AALA202511056306Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER ACCUMULATOR PRESSURE IS BELOW PS CHK LIMIT. MAINTENANCE SERVICED L2 DOOR DAMPER ACCUMULATOR PRESSURE IAW AMM 52-10-00.SDR AALA202511054847Battery · dischargedAIRCRAFT WAS NOT GROUNDED: F/A FLASHLIGHT AT DOOR 1L FLASHES RED. MAINTENANCE REPLACED BATTERY IN F/A FLASHLIGHT AT DOOR 1L IAW AMM 25-64-00.