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 AALA202602255840Profile · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 844 RIGHT HAND LOAD TRANSMITTING PROFILE CRACKED. REPLACED LOAD TRANSMITTING PROFILE PER EO5210Y228-001.SDR AALA202602252370Profile · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 833 LEFT HAND LOAD TRANSMITTING PROFILE CRACKED. REPLACED LOAD TRANSMITTING PROFILE PER EO5210Y228-001.SDR AALA202602252068Profile · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 843 RIGHT HAND LOAD TRANSMITTING PROFILE CRACKED. REPLACED LOAD TRANSMITTING PROFILE PER EO5210Y228-001.SDR AALA202602251775Profile · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 834 LEFT HAND LOAD TRANSMITTING PROFILE CRACKED. REPLACED LOAD TRANSMITTING PROFILE PER EO5210Y228-001.SDR SWAA2026022466142Skin · debondedLEFT WING OTBD AFT FLAP INBD AFT CORNER DISBONDED. REMOVED AND REPLACED THE LT WING OTBD AFT FLAP INBD IAW AMM 27-51-22-401.SDR AALA202602201196Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TOP OF INTERCOSTAL FROM BS 330 TO BS 344, AT S23L. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWAA2026021865816Support Angle · crackedCRACK ON SUPPORT ANGLE LOC BTW ORSS 279 TO ORSS 330 TRAILING EDGE LT WING. REPLACED SUPPORT ANGLE LOC BTW ORSS 279 TO ORSS 330 TRAILING EDGE LT WING IAW SRM 51-10-02 ITEM 9, SRM 51-40-02 AND DWG 115A3700, SHEET 81, REV A.SDR SWAA2026021666093Skin Panel · crackedCRACK INDICATION ON HORIZONTAL STAB, RT LOWER SKIN PANEL HSS 193.90, & 20 INCHES FROM FRONT SPAR. CRACK LENGTH 0.400 INCH. PERFORMED A REPAIR THE HORIZONTAL STAB LOWER SKIN IAW SRM 55-10-01-2R-11, REPAIR 11.SDR SWAA2026021666092Skin · crackedCRACK INDICATION ON THE HORIZONTAL STAB, RT LOWER SKIN PANEL, HSS 193.90 AND 20 INCHES FROM FRONT SPAR. CRACK LENGTH 0.400 INCHES.SDR SWAA2026021666094Support Angle · crackedCRACKED SUPPORT ANGLE, ORSS 269, LT WING TE. REPLACED THE SUPPORT ANGLE, IAW SRM 51-10-02, ITEM 9, & SRM 51-40-02. MEASUREMENT OF CRACK: L 0.924 INCH.SDR SWAA2026021666262Support Beam · crackedCRACKED SUPPORT BEAM, ORSS 282, LT WING TE. REPLACED THE SUPPORT BEAM AND FASTENERS IAW SRM 51-40-02-0G-0, DWG 115A3700, SHEET 81, REV-, & DWG:115A3712, SHEET 5, REV-.SDR IPXA2026013048711Longeron · crackedNR 1 PYLON LOWER AFT FAIRING 475AL FWD LONGERON HAS A CRACK AT FWD EDGE. STOP DRILLED CRACK 1.85" AFT OF LONGERON CRACK IAW A300 SRM 54-55-51 TABLE 101 SH 1 (F2). ++INSTALLED REPAIR ANGLE AT UPPER LONGERON USING FASTNERS P/N MS20470DD5-5 B# 0004403526 AND MS20SDR R61A2026021600042Skin · crackedWHILE ON HEAVY CHECK - RH WING SHOWS RELEVANT CRACK INDICATION AT RIB17, STGR 19 RUNOUT.SDR AALA202602167273Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY FWD HINGE FITTING BEARING ON LH MAIN LANDING GEAR DOOR. MAINTENANCE REPLACED FITTING ASSY BY NEW ONE AND DRILLED IAW AIRBUS A320 SRM 51-44-11-801, CMM 52-81-18.SDR R61A2026021600041Shear Tie · corrodedWHILE ON HEAVY CHECK - SHEAR TIE CORRODED AT AFT CARGO FR 75 STRINGER 28R-29R.SDR SWAA2026021265852Stiffener · corrodedCORROSION ON PRESSURE DECK WEB STIFFENER ANGLE, BS 695+7.5, RBL 62 - 68, WL 200. REMOVED AND REPLACED THE STIFFENER ANGLE IAW AMM SRM 51-40-02-0G-0.SDR SWAA2026021265853Stiffener · corrodedCORROSION ON PRESSURE DECK WEB STIFFENER ANGLE, BS 706+2, RBL 60-65, WL 200. REMOVED AND REPLACED THE PRESSURE DECK WEB STIFFENER ANGLE IAW SRM 51-40-02-0G-0.SDR CALA2026021213717Skin · dentedDURING INBOUND WALK AROUND OF AIRCRAFT, NOTED EXCESSIVE EXISTING KNOWN DAMAGE. REMOVED AND REPLACED FWD CARGO DOOR EXTERNAL SKIN IAW SRM 52-30-01-2R-3, SRM 51-40-02-0G-0, AND DWG 143A6110-9.SDR CALA2026021113700Engine · failedRIGHT ENGINE COMPRESSOR STALL ON APPROACH. IAW AMM 72-00-00, REV 106. ON ARRIVAL FOUND NR 2 ENGINE WITH THE LOW PRESSURE COMPRESSOR EXIT FAIRING COMPLETELY DETACHED AND STUCK ON THE BYPASS GUIDE VAINS. IAW AMM 72-00-00 REV106 ALL FAN BLADES TRAILING EDGE SSDR KY7A2026021000038Skin · corrodedCORROSION WAS FOUND AT THE FWD TIP OF THE LH FUSELAGE SKIN. REPAIRED PER EO-53-034SDR AALA202602091020Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #4 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #4 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602093581Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #6 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #6 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602096316Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #4 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #4 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602091603Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #2 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602092092Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #1 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #1 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602091563Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #6 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602094688Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #5 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #5 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602090242Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #5 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #5 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602097829Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #1 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #1 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602093040Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #3 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING #3 ON LH HORIZONTAL STABILIZER I.A.W. AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602099111Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING BEARING #3 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #3 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR DALA2026020800894Generator · leakingPASSING THROUGH 8000 ON ARRIVAL INTO MIA THROTTLES IDLE, SMELLED STRONG ODOR, NO VISIBLE SMOKE, STAYED SAME FOR ARRIVAL, FORWARD FA DID NOT DETECT ANYTHING. FOUND OIL CONTAMINATION ON APU AS RESULT DEFERRED PER MEL 49-10-01A. LATER, FOUND LUG ON APU GENERATOSDR Q5QA20260206001Starter Gen · vibrationTHE PILOT NOTICED AN ENGINE VIBRATION ON DECENT INTO READING REGIONAL AIRPORT. THE #1 STARTER- GENERATOR PART NUMBER A 23085-025, SERIAL NUMBER Y0090 WAS FOUND TO BE THE CAUSE OF THE VIBRATION. THIS STARTER-GENERATOR WAS PREVIOUSLY OVERHAULED AND HAD BEEN IN SSDR SWAA2026020666170Battery Pack · inoperativeALL EMERGENCY LIGHTS COMMON TO M1674 EMERGENCY BATTERY INOPERATIVE. REMOVED & REPLACED AND PERFORMED GOOD TEST OF EMERGENCY BATTERY PACK M1674.IAW AMM 33-51-06-960-805.SDR SWAA2026020666029Battery Pack · inoperativeTHREE EMERGENCY EXIT AISLE LIGHTS AT SEATS ROWS 6 DEF - 14 DEF INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026020666247Battery Pack · inoperativeL2 EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805-NG.SDR IPXA2026020652253Antenna · faultedAIR TURN BACK, TCAS SYSTEM ADVISORY MESSAGE CHECK CMC PRESENT LEG FAULT.FND TCAS LOWER ANTENNA FAIL. REPLACED LOWER TACAS ANTENNA .PFM GOUND TEST PASS.PER AMM34-45-02.SYS BACK TO NML.SDR DALA2026020600850Repair · not enteredTIME LIMITED REPAIR ERA 631329-14AD REV ORIGINAL. WINDSHIELD FRAMING CENTER POST MIRROR FITTING REPAIR IS LIMITED TO 53,909 TFC. ACCOMPLISH ERA 631326-14AD SECTION II PRIOR TO 53,909 TFC. CONTACT LIAISON ENGINEERING FOR FURTHER INSTRUCTIONS. ASSOCIATED AA 531SDR IPXA2026020558217Wire · chafedLEFT FWD ENTRY DOOR EICAS MSG ON PUSHBACK FOUND WIRE ON SWITCH S194 CHAFED. REMOVED AND REPLACED CREW ENTRY DOOR SWITCH S194 IAW B767 AMM 52-71-01 AND SWPM 20-30-12. OPS CHECK GOOD. THIS CLEARS DEFERRAL. REVERSED DMP. PLACARD REMOVEDSDR IPXA2026013158624Pump · failedDIVERSION, CLIMBING THRU FL 300 ALL 4 INNER TANK PUMPS FAILED. DIVERTED TO LOUISVILLE SDF. DMP 28-21-09-1 REVERSED. IAW TECH RECOMMENDATION. R & R RELAY 154QA, 132QA AND 41QA REF ESPM 20-46-50-01. OPPS CHECKED AUTO FUEL FEED SYSTEM IAW AMM 28-21-00-501. SYSTEMSDR ASAA2026013063231Control Valve · faultedDIRTY SOCK ODOR AFTER TAKEOFF. ODOR STAYED THE WHOLE TIME. GROUNDED - YES. PERFORMED TSM 21-52-00-810-810-A, PACK 1 ACM FAULT. RAN APU & FOUND THE NR 1 A/C PACK COMPRESSOR INLET TEMP 57C, OUTLET TEMP 66C NR 2 PACK COMPRESSOR OUTLET TEMP 107C. ACM SUGGESTEDSDR AALA202602055379Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR CALA2026020513597Light · inoperativeLEFT, AFT EMERGENCY LIGHT IS INOPERATIVE. R & R AFT EMERGENCY LIGHT IAW AMM 33-51-06-902-082, OPS CHECKED GOODSDR DALA2026020500825Floorbeam · corrodedMULTIPLE NUT PLATE UNDER CARGO FLOORBEAM INNER TEE FOUND CORRODED IN THE AFT CARGO, BS 1153, RBL 7 - 40. REPLACED THE DAMAGED INNER TEE IAW SRM 51-40-02 (1426917)SDR SWAA2026020366108Slide · partial deployFWD ENTRY DOOR SLIDE PARTIALLY DEPLOYED, ON OPENING. REINSTALLED THE FWD DOOR SLIDE ASSY IAW AMM 25-66-01. CHKD OK.SDR SWAA2026020366013Light · unsecureEMERGENCY LIGHT AT ROW 25D, NEEDS TO BE SECURED. SECURED THE EMERGENCY LIGHT IAW AMM 33-51-03. OPS CHECKED GOOD.SDR SWAA2026020366011Unknown · odorFLIGHT ATTENDANT REPORTED AN UNUSUAL SCENT IN THE AFT GALLEY, POSSIBLY ELECTRICAL, WITH OBSERVED SMOKE. SPOKE WITH AFT FAS, THEY CONFIRMED THE ODOR STARTED WHEN THEY PULLED THE TRASH CANS FOR CABIN SERVICES. THEY WERE ABLE TO ISOLATE THE ODOR WHEN TRASH BAGSDR SWAA2026020366140Lamp · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED THE LAMP AND PERFORMED A GOOD TEST IAW AMM 33-51-04-960-801.SDR SWAA2026020366139Lamp · inoperativeL1 DOOR EMERGENCY EXIT LIGHT PEANUT LIGHT INOPERATIVE. REPLACED THE LAMP AND TESTED GOOD IAW AMM 33-51-01-960-801.SDR DXTA2026020306745Light · inoperativeEMERGENCY EGRESS LIGHTS REMAIN ON THE RIGHT SIDE OF THE FUSELAGE WITH THE BATTERY OFF, PASSENGER SAFETY OFF AND THE EMERGENCY LIGHT SWITCH OFF. INSIDE THE CABIN, TWO EXIT LIGHTS REMAIN ON IN THE REAR OF THE CABIN AND ONE RIGHT SIDE AISLE. LIGHT STAYS ILLUMINAT