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 AALA202602022597Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER TASK CARD 26L30027001.SDR AALA202602028273Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER TASK CARD 26L30027001.SDR AALA202602026995Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER TASK CARD 26L30027001.SDR AALA202602025659Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER TASK CARD 26L30027001.SDR AALA202602021738Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER TASK CARD 26L30027001.SDR AALA202602029873Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 947 BETWEEN LBL 25 AND LBL 51. REPLACED SUPPORT IAW AARD 51-00-05-1.SDR AALA202602027135Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 947 BETWEEN LBL 16 AND LBL 25. REPLACED SUPPORT PER AARD 51-00-05-1.SDR SIMA20260128003Skin · crackedLEFT WING LOWER SKIN, JUST AFT OF SPAR 1 AND INBD OF RIB 17, HAS 1 CRACK AND APPROXIMATELY 6" LONG CRACK, VERIFIED WITH EDDY HFEC, FOUND LEAKING FUEL DURING FUEL LEAK CHECKS, LT WING LOWER SKIN, JUST AFT OF SPAR 1 AND INBD OF RIB 17, HAS 1 CRACK AND APPROXISDR SIMA20260128002Skin · crackedEVIDENCE OF 1 CRACK AND APPROXIMATELY 2 INCHES LONG AT L/H WING LOWER SKIN EXTERIOR, AFT OF SPAR 1-I/B RIB 17. (MAJOR REPAIR). CW ERS-EJ-57MR-1764SDR DALA2026020200758Radio · odorOOD SMELL IN FWD LAV AND EMERG EQUIP DOOR TO RIGHT OF LAV. ODOR LIKE A HOT ELECTRIC MOTOR OR ARMATURE. VERY FAINT ODOR BUT SEVERAL CREW MEMBERS SMELLED IT. FWD LAV AREA. REPLACED PRIMARY RADIO RACK FAN IAW AMM 21-21-01. FAN OPS NORM. ODOR HAS DISSAPATED. (838SDR DALA2026020200754Frame · crackedCRACKED FRAME BS 1037 AND LONGERON 17LT AT PASSENGER CABIN. FRAME BTWN WAS REPAIRED IAW SRM 53-20-07-2R, PROCEDURE 4, REPAIR 4. (1424411)SDR CALA2026020113463Brake Sys · faultedBRAKE INDICATION ADVISORY FAULT IN THE BRAKE SYSTEM, PREVENTING INDICATION OF BRAKE SYSTEM FAULTS. BRAKE SELF TEST INITIATED AT TAKE-OFF, MESSAGE IS LATCHED IF ANY BRAKE CONTROL CHANNEL FAILS SELF TEST. MESSAGE INHIBITED FOR TOUCH & GO CONDITION. DB 31 DCASDR QMLA2026020120009Warning Message · false activationNR 1 FUEL LOW WARNING LIGHT ILLUMINATED DURING CRUISE FLIGHT. TROUBLESHOT AND UNABLE TO DUPLICATE ISSUE.SDR DALA2026013000726Cover · unsecureL3 AFT ENTRY DOOR ARMING LEVER DOES NOT FULLY SLIDE TO ARM POSITION. SECURED LOOSE PROX SENSOR PROTECTIVE COVER AS REQ, DOOR CHKD NML PER AMM 52-11. (8079186)SDR DALA2026013000725Fitting · out of adjustL4 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT INOPERATIVE. REMOVED DOOR BUSTLE TO AID IN INSPECTION OF GIRT BAR. DOOR ARM LIGHT FUNCTIONS NORMAL. ARM/DISARM LINKAGE BINDING. ADJUSTED GRIT BAR FITTING IAW AMM 25-66. SLIDE ARM/DISARMS SMOOTHLY AND SLIDE ARM LIGHT SDR UIEA2026012900020Fitting · wrong partLAVATORY PORTABLE O2 BOTTLE MASK HAS INCORRECT FITTING TO ATTACH TO O2 BOTTLE.(<P>REMOVED & REPLACED O2 MASK ASSY IAW AMM 35-31-00. OPS CHK OK.THIS CLEARS MDDR 246793. </P>)SDR R61A2026012800030Module · faultedSLAT FAIL ON APPROACH. MSG CLEARED WITH QRH. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. PERFORMED AIOP A2 MODULE RESET.SDR AALA202601304246Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: NR 3 LIFE RAFT PRESSURE LOW. INSTALLED SERVICEABLE NUMBER 3 LIFE RAFT. PER AMM 25-64-00.SDR AALA202601308020Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601306773Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601307145Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601307741Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601300584Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601306533Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601303920Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601300996Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601307041Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601307590Hinge Fitting · wornAIRCRAFT WAS GROUNDED: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING WORN. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202601305501Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: BATTERY FOR EMERGENCY POWER SUPPLY UNIT 11WL FAILED BITE TEST PER TASK CARD 26L00005005. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202601307206Linkage · stickingAIRCRAFT WAS NOT GROUNDED: 2L SLIDE LEVER DIFFICULT TO OPERATE. MAINTENANCE REMOVED DEBRIS, CLEANED AND LUBED LINKAGE. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202601303528Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: BATTERY FOR EMERGENCY POWER SUPPLY UNIT 12WL FAILED BITE TEST PER TASK CARD 26L00005005. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR CALA2026013013441Smoke Detector · faultedON DESCENT GOT A LAV SMOKE EICAS AND HORN FROM MID LAV. NO VISIB LE SMOKE OR ODOR PRESENT WHILE REMOVING SMOKE DETECTOR IN MID LAV FOUND ONE SCREW STRIPPED. REQUEST SHEET METAL ASSISTANCE. REMOVED STRIPPED SCREW PER SRM 51-40-02. REMOVED AND REPLACED LAV S SMSDR CALA2026013013440Valve · stuckLAVATORY 4G SINK BOWL FULL OF GREY WATER AND OVERFLOWING, FOWL ODOR THROUGH OUT CABIN. TROUBLESHOT SYS. RESTRICTOR VALVE DEACTIVATED OPEN LOCKED FOR REPAIR UNLOCKING LAV 4G SINK BOWL OPS CHECK GOOD, NO OVERFLOW IAW AMM 38-31-00.SDR CALA2026013013439Engine · low pressureSTRONG BURNING ODOR ORIGINATING FROM FWD GALLEY. PERFORMED & RECIRIC FILTERS REPLACED. NO ODOR, OK TO CONTINUE. CHIME ALERTING RIGHT 5TH STAGE DUCT PRESSURE LOW. RT SIDE HAS BEEN RUNNING SIGNIFICANTLY LOWER THAN THE LTE SINCE JUST BEFORE CHRISTMAS DURING ALLSDR DALA2026012800692Shear Tie · corrodedAFT CARGO SHEAR TIE AT BS 1562, S38 - 39L FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423503)SDR DALA2026012800691Shear Tie · corrodedAFT CARGO ONE SHEAR TIE AT BS 1219, S39L-39R FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423497)SDR DALA2026012800690Shear Tie · corrodedAFT CARGO SHEAR TIE AT BS 1197+154, S39L-39R FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423439)SDR DALA2026012800689Shear Tie · corrodedAFT CARGO SHEAR TIE, BS 1518, S38-39L FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423433)SDR DALA2026012800688Shear Tie · corrodedBULK CARGO SHEAR TIE AT BS 1417, 39L-39R FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 53-00-07. (1423427)SDR DALA2026012800687Shear Tie · corrodedAFT CARGO SHEAR TIE AT BS 1417, S38-39L FOUND CORRODED. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423420)SDR DALA2026012800686Spar Web · crackedDURING REMOVAL OF ACCESS FOR PYLON REMOVAL, FOUND THE PYLON UPER SPAR WEB HYDRAULIC LINE CUTOUT CRACKED ABOUT 0.5" AFT NAC STA 228.19. DAMAGED AREA REPAIRED IAW PRI 631750-14 . (1423385)SDR DXTA2026013006717Link · detachedMCD LIFT ARM HAS COME UNATTACHED FROM DOOR ARM. REINSTALLED CABIN DOOR LIFT LINK. OPS CHECK GOOD. IAW CE-680A AMM 52-15-15.SDR DXTA2026013006712Spoiler Sys · faultedON APPROACH PF OPENED SPEED BRAKES. SPEEDBRAKES DID NOT DEPLOY. WITH ASSOCIATED GRND SPLR FAULT AND SPLR FAULT CAS MESSAGES. ACCOMPLISHED THE QRH PROCEEDURE AND RETURNED TO DEPARTURE AIRPORT. PERFORMED SPOILER OPS CHECK. OPS CHECK GOOD. IAW AMM 45-45-00SDR ASAA2026012863102Arming Lever · fodL1 DOOR ARMING IS DIFFICULT. GROUNDED - YES. CLEANED DEBRIS & LUBRICATED ARMING LEVER AS REQUIRED. OPS CHECK GOOD. OK FOR SVC.SDR SWAA2026012965241Girt Bar · out of adjustFORWARD ENTRY DOOR GIRT BAR REQUIRES ADJUSTMENT. BAR COMES OUT OF ITS HOLDER. REMOVED & INSTALLED THE GIRT BAR IAW AMM 25-66-02. FOUND RETENTION TO BE SATISFACTORY.SDR SWAA2026012965184Rivet · looseR1 DOOR BUSTLE AFT GIRT BAR HOLDER LOOSE.<[01] R & R RIVET IAW SRM 51-40-02;[02] R & R RIVET IAW SRM 51-40-02SDR SWAA2026012965183Rivet · looseL1 DOOR BUSTLE AFT GIRT BAR HOLDER LOOSE. REMOVED & REPLACED RIVET IAW SRM 51-40-02.SDR SWAA2026012964986Smoke Detector · false activationAFT LAVATORY SMOKE ALARM GOING OFF. NO SMOKE OR FIRE. OK TO CONTINUE IAW MEL 26-16-01 SP 3, & SP1B. R & R THE AFT LAVATORY SMOKE DETECTOR IAW AMM 26-14-01.SDR SWAA2026012965683Light · inoperativeSIDEWALL LIGHTT ABOVE LT AFT EMERGENCY EXIT DOOR INOPERATIVE. REPLACED LT AFT OVERWING EXIT LIGHT IAW AMM 33-51-01. OPS CHECKED GOOD.SDR SWAA2026012965071Guard · brokenAFT FA STATION LIGHT PANEL HAS A BROKEN SPRING ON THE EMERGENCY EXIT LIGHT COVER PLATE. R & R THE SWITCH GAURD IAW AMM 31-15-15. INSPECTED IAW CMM REPREF NOT FOUND.