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 SWAA2025070182661Skin · delaminatedRIGHT WING O/B AFT FLAP HAS DELAMINATION ON I/B LOWER SIDE<[01] CHANGED STEP STATUS ON STEPS 2 & 3 TO [PARTIAL];[02] REMOVED; REPLACED AND ADJUSTED THE RT WING O/B AFT FLAPS IAW AMM 27-51-22-000-801; AMM 27-51-22-400-801; AMM 27-51-28-000-802; AMM 27-51-28-400SDR SWAA2025070182816Skin · delaminatedLT WING O/B AFT FLAP I/B AFT END IS DELAMINATED. CHANGED STEP STATUS ON STEPS 2 & 3 TO [PARTIAL] REMOVED; REPLACED AND ADJUSTED THE LT WING O/B AFT FLAP IAW AMM 27-51-22-000-801; AMM 27-51-22-400-801; AMM 27-51-28-000-802; AMM 27-51-28-400-802;[03] VERIFIEDSDR REXA2025062600698Support Angle · crackedCRACK IN FWD SUPPORTS ANGLES (2EA) AT UPPER ACUMULATOR ON NOSE HYD COMPARTMENT WAS FOUND. FWD SUPPORTS ANGLES (2EA) AT UPPER ACUMULATOR ON NOSE HYD COMPARTMENT WERE REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01SDR REXA2025062600697Diaphragm · crackedCRACK ON WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17 CRACK ON WING TO FUSELAGE AFT FAIRING SUPPORT STRUCTURE AT FS849, LBL17 WAS REPAIRED PER EA NO. CRJ953-19412 REV. IRSDR REXA2025062600694Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (SDR DALA2025062504752None · noneDTA ER/A 626583-14 SECTION II MONITOR LOG REQUIRES DTA APPROVAL. CORRECTIVE ACTION: C.W ERA 626583.SDR AALA202506241341Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT LEFT HAND SIDEWALL SUPPORT ANGLE HAS CRACKED LOWER ATTACH CLIP AT STA 867. REMOVED AND REPLACED AFT CARGO COMPARTMENT LEFT HAND SIDEWALL SUPPORT ANGLE LOWER ATTACH CLIP. PER B737-NG-SRM 51-40-02.SDR AALA202506247421Attach Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PYLON OUTBOARD FORWARD ATTACHMENT FITTING FOR THE THRUST REVERSER, BEARING WORN AT PYLON RIB 1. REPLACED FITTING PER AMM 54-57-17.SDR AALA202506249702Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 312 AND BS 328 AT RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506242808Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 272 AND BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202506238865Relay · failedAIRCRAFT WAS NOT GROUNDED: AFTER ENGINE STARTED WITH BOTH CENTER PUMP FUEL SWITCHES IN THE ON POSITION, THE RIGHT CENTER FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. PRIMED PUMP 28-22-41. REPLACED R55 CONTROL RELAY (AALA202506238865) AND K9901 INPUT RELAY ( AALA2SDR AALA202506239921Relay · failedAIRCRAFT WAS NOT GROUNDED: AFTER ENGINE STARTED WITH BOTH CENTER PUMP FUEL SWITCHES IN THE ON POSITION, THE RIGHT CENTER FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. PRIMED PUMP 28-22-41. REPLACED R55 CONTROL RELAY (AALA202506238865) AND K9901 INPUT RELAY ( AALA2SDR AALA202506230465Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: AFTER ENGINE STARTED WITH BOTH CENTER PUMP FUEL SWITCHES IN THE ON POSITION, THE RIGHT CENTER FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED. PRIMED PUMP 28-22-41. REPLACED R55 CONTROL RELAY (AALA202506238865) AND K9901 INPUT RELAY ( AALA2SDR SWIA2025062300017Shutoff Valve · warning messagePARK BRAKE SOV CAUTION MESSAGE IN FLIGHT. HIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30333364 WITH THE FOLLOWING CORRECTIVE ACTION: "SEE CP 30333368 FOR WORK PERFORMED AND PARTS INFO"SDR SWAA2025062382930Check Valve · inoperative@APPROX FL190 CABIN ALT ALERT SOUNDED IMMEDIATELY STARTED DECENT TO 10000 FT. CABIN MASKS AUTO DEPLOYED WHILE CREW DOWNING OXYGEN. COMPLETED DECENT W/ QRC & QRH PROCEDURES AND RETURNED TO ORIGIN JAX<[01] DURING INITIAL PACK CONFIDENCE CHECK FOUND GROUND AIR COSDR SWAA2025062382902Cabin Air Sys · odorEXPERIENCED STRONG ELECTRICAL BURNING ODOR UPON LANDING AND TAXIING TO GATE. NO VISIBLE SMOKE. <[01] CW COND. INSP PER AMM 05-51-56. NO ABNORMAL SMELLS NOTED.SDR AALA202506236106Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED KEEL BEAM RIGHT HAND SIDE LOWER HOLES OF PLATE CONNECTING IN MAIN WHEEL WELL AT FR 42 AND X18992.7. REPLACED PLATE PER SRM 651-72-11.SDR DALA2025062304678Warning Light · false activationSHIP 0185 ENTRY DOORS ANNUNCIATOR ON IN THE FLIGHT DECK. CORRECTIVE ACTION: LUBED TRACK SURFACES, READJUSTED BUSTLE, AND READJUSTED MOVEABLE OVERHEAD PANEL IAW B767 AMM 25-66. (7561209).SDR DALA2025062304677Warning Light · false activationSHIP 0185 DOOR 2R SLIDE LIGHT FLASHING. CORRECTIVE ACTION: LUBED TRACK SURFACES, READJUSTED BUSTLE, AND READJUSTED MOVEABLE OVERHEAD PANEL IAW B767 AMM 25-66. (7561208).SDR JJBA20250623016Lamp · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK FAILED. SUSPECT BAD HOUSING. REMOVED AND REPLACED LIGHT ASSEMBLY HOUSING. OPS CHECK SAT.SDR JJBA20250623015Sign · inoperativeEXIT LOCATING SIGN MID CEILING FWD INOPERATIVE. REMOVED AND REPLACED EXIT LOCATING SIGN FWD SIDE MID CEILING. OPS CHECK SAT.SDR AALA202506232213Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500H AND BS 500G AT LBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202506234160Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G, LBL 26. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202506232800Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H, LBL 26. REPLACED CLIP PER AARD 51-00-05-1.SDR R61A2025062300262Skin · dentedFWD FUSELAGE DENTED AND GOUGED BETWEEN FRA 19-20 AND STR14R-15R. REPLACED SHEAR CLIP AT FRA 19 AND BETWEEN STR 14R-15R IAW EMB 170/175 SRM 51-41-01 AND 51-41-02 ALSO REF ETD2025-170-923116 AND VP-025441-2025 FOR WORK ACCOMPLISHED.SDR DALA2025062004654Indicator · unsecureSHIP 0195 SLIDE INDICATOR LIGHT INOP OR DAMAGED. CORRECTIVE ACTION: SECURED LIGHT ASSY. B767 AMM 52-71. (1029076).SDR DALA2025062004648Proximity Sensor · faultedDECLARED EMERGENCY DUE TO LANDING GEAR NOT EXTENDING AFTER SELECTOR HANDLE WAS MOVED DOWN. SYSTEM WAS FAULTING THE RH GEAR DOOR OPEN PROX SENSOR. ALT. GEAR EXTENSION PERFORMED. CORRECTIVE ACTION: DEFERRED GEAR RETRACTION SYSTEM PER MEL. AIRCRAFT WILL POSITION SDR YENA2025062000638Unknown · odorFLT#524, LAX-JFK. JUST PRIOR TO LANDING INFLIGHT REPORTED A BURNING SMELL IN THE CABIN FWD AND AFT. LASTED APPROX. 1 MINUTE NO SMELL NOTED IN COCKPIT; COMPLIED WITH INFO NOTICE 2017-T015, SECTION A, ISOLATED FAULT TO TYPE 10, CABIN ITEMS PER TSM 05-50-00-810-0SDR SWAA2025062082682Slide · low pressureFA REPORTS AFT SERVICE DOOR SLIDE PRESSURE OUT OF RANGE <[01]. 02 - INSPECTED PER [AMM 25-66-01-200-801-NG (ESCAPE SLIDE PACK INFLATION CYLINDER CHECK - PERMANENT)] FOUND AFT ENTER DOOR SLIDE TO BE WITHIN 1 NEEDLE WIDTH OF GREEN BAND AND IS WITHIN NORMAL RANGESDR SWAA2025062082697Light · intermittentEMERGENCY EXIT LIGHT IS FLASHING LIKE A STROBE. OK TO CONTINUE PER MEL 33-21-01A SP1B. AUTHORIZATION # 262072SDR DALA2025062004646Brake · fault messageBRAKE ON MESSAGE ON IN FLIGHT. PARK BRAKE FAIL MESSAGE IN FLIGHT. PERFORMED TROUBLESHOOTING AND REPAIR REFERENCE LOG 1026603 FOR R /R #3 EMCU. FAULT IS CLEARED. OMS BDCU1 AND 1 SHOW NO PRESSURE. FAULT IS CLEARED. M PROCEDURES REVERSED. PLACARDS REMOVED. OK FORSDR DALA2025062004645Bracket · out of limitsR/H AILERON ANTI-MIGRATION BRACKETS CLEARANCE TOLERANCES OUT OF LIMITS. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 000-0004:2715-4001-RH/003 00541 ADJUSTED R/H AILERON ANTI-MIGRATION BRACKETS CLEARANCE REF A220 AMP 27SDR 4DPA2025061700001Line · obstructedCREW REPORTED- AFTER TAKE-OFF FROM PBI FO’S AIRSPEED INCREASED WITH ALTITUDE AND AT 4000MSL ACTIVATED THE HIGH SPEED WARNING. THE CA & STANDBY AIRSPEED INDICATED NORMALLY. RETURNED FOR LANDING AT PBI, DURING DESCENT THE FO’S AIRSPEED DECREASED TO ZERO ON FINALSDR WX0A2025062032467Apu · leaking(AIRCRAFT NOT GROUNDED) DIRTY SOCK ODOR REPORTED FROM BOTH FWD FA'S AS SOON AS DOOR OPENED. FOUND LUBE MODULE FILTER LEAKING, APU COOLING FAN LEAKING. SAW POSSIBLE LEAK OF FCU BEFORE APU RUN, BAGGED FCU & RAN, FOUND NO VISUAL LEAK. CONFIRMED LEAKS AFTER RUN. DSDR HEEA202506200001Adc · inoperative#2 ADC FAILED IN FLIGHT.SDR DALA2025062004643Hydraulic Line · leakingSHIP 6715 -MISC/DE- DUE TO LOSS OF LEFT HYD QUANTITY. CORRECTIVE ACTION: SECURED PRESSURE LINE ON LEFT ENGINE PRESSURE AND CASE DRAIN MODULE.SDR DALA2025062004639Girt Bar · fodSHIP 687 CABIN CREW COULD NOT DISARM 3L DOOR. CORRECTIVE ACTION: FOUND DEBRIS UNDER GIRT BAR AT AFT SIDE OF DOOR 4L. CLEARED AND CYCLED REF B757 AMM 52-11. OPS CHECKS GOOD. (7400950)SDR UIEA2025061700785Oil System · leakingOIL QUANTITY ON RIGHT ENGINE DROPPED TO 8 QUARTS.(<P>ALL ITEMS FOR ACTION TAKEN TO CORRECT IAW B767 AMM 79-21 & 79-31. LP 1219035 M9: SERVICED #1 ENG 4 QTS & SERVICED #2 ENG 8 QTS IAW B767 AMM 12-15-03. NO FURTHER DEFECTS NOTED.</P>)SDR IXXA20250620023Battery Pack · inoperativeSUBSEQUENT TO SCHEDULED INSPECTIONS AND MAINTENANCE, LINE MAINTENANCE REPORTED INTERIOR EMERGENCY LIGHTS-RIGHT M11558 BATTERY PACK WILL NOT CHARGE. POWER SUPPLY BATTERY AND BATTERY CHARGER ASSEMBLY REMOVED AND REPLACED IAW BOEING 767-300 AIRCRAFT MAINTENANCSDR AALA202506209829Vapor Barrier · crackedSUPPLEMENTAL REPORT FOR AALA202506179829: QC REVIEWED AND DETERMINED THE WRONG AIRCRAFT (807NN) WAS IDENTIFIED. SECTIONS 1 AND 3 HAVE BEEN UPDATED WITH CORRECT AIRCRAFT INFORMATION FOR 850NN. AIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPARSDR DXTA2025062003932Shutoff Valve · faultedWHEN STARTING ENGINES WITH APU RUNNING, APU BLEED AIR OFF, HEAVY SMELL OF JET EXHAUST IN CABIN AND COCKPIT. CREW NOTICED THAT WHEN THE APU BLEED AIR KNOB WAS SELECTED OFF, THE WHITE APU BLD VALUE CLOSED CAS MESSAGE NEVER APPEARED. REPLACED APU BLEED AIR SHUTSDR DXTA2025062003931Control Handle · faultedUPON GEAR EXTENSION, RECEIVED AMBER GEAR DISAGREE L-R-C, HANDLE FELT DEAD, NO RESISTANCE OR FEEDBACK. RECYCLED HANDLE TWICE AND GEAR CAME DOWN NORMAL WITH THREE GREEN INDICATED. CORRECTIVE ACTION: GAINED ACCESS AND REMOVED R/H LANDING GEAR/WOW PCB P/N; 676815SDR ASAA2025061758853Transition Panel · corrodedAFT CARGO L/H TRANSITION F.S. 727+4-727D+10 CORRODED. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-53-1A-2. REPAIRED TRANSITION IAW B737-700 SRM 51-40-05-0G-0W= 1.00 O= .040 R= .035 L= 2.75 D= .005.SDR CALA2025061905722Skin · dentedUPON WALKAROUND FOUND MULTIPLE DENTS AFT OF L1 DOOR INSIDE RVSM CRITICAL AREA APPROX. AT STA 380.REMOVED DAMAGED NICKS AND GOUGES REF SRM 53-30-01-1A-1 PAR 4. DAMAGED AREA AT STA 380 AND BETWEEN STR 16L - 17L. CLEAN UP AREA MEASURED 4" X 3.5" X .125. REF SRM 5SDR CALA2025061905721Panel · missingFOUND MISSING PANEL 443BR ON ENGINE #2 RIGHT NACELLE STRUT. REMOVED AND REPLACED 443BR ON ENG #2 NACELLE STRUT AS PER MM 54-53-01-004-001-001.SDR CALA2025061905717Lamp · burned outEXTERIOR EMERGENCY LIGHT AFT OF 2R DOOR INOP. INOP LIGHT IS AT RT AFT SERVICE DOOR, NOT DOOR 2R. RELAMPED EXTERIOR SLIDE LIGHT AT RT AFT SERVICE DOOR REF AMM TASK 33-51-06-962-001-001.SDR CALA2025061905716Skin · dentedDENT ON FUSE. STA 625 (APPROX) HAS NEW DIA M. THAN RECORDED ON INCOMMING DMG. REPAIRED FUSE.SKIN STA 610-635 PER UAL EC/RA II 5330-07543 AND V TMAE EA 757-5330-13-A3952 REV- FAA 8100-9 ATTACHED. RII VERIFIED.SDR CALA2025061905714Unknown · odorFA REPORTS PLASTIC BURNING SMELL IN AFT CABIN DURING DESCENT INSPECTED AFT GALLEY AREA. NO SMELLS NOTED. INSPECTED ALL OVENS AND COFFEE MAKERS, NO SMELLS OR ISSUES NOTED. NO HISTORY. REF MM 25-33-00 ADD EMP: U414325SDR CALA2025061905713Actuator · faultedFOUND APU INLET ACTUATOR OPERATING INTERMITTANT WITH NO HARD FAULTS. INSPECTED AREA AND FOUND BURNT WIRE OR OVERHEAT SMELL COMING FROM ACTUATOR. REMOVED APU AIR INLET DOOR ACTUATO. REF: AMM 49-15-31-000-801. ACTUATOR P/N OFF: 734-07530-03. S/ N 2057 STARTED TOSDR CALA2025061905712Controller · faultedWINDOW HEAT OVERHEAT LIGHT LIGHT ON L FWD R FWD WINDOW HEAT OVT LIGHT ON. SMELLED ELECTRICAL SMELL TURNED OFF. SMELL GONE ON PILOT DEBRIEF CONFIRMED ONLY CAPT WINDSHIELD OVERHEAT. ELEC SMELL DISSAPATED QUICK AFTER TURNING OFF. GIVING CREW FORM 46-6020 SMOKE IN