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 CALA2025120711818Unknown · odorFAS REPORTED SMOKE ODOR NEAR 1ST CLASS WALL. COMPLETED CONDITIONAL INSPECTION FOR SMOKE ODOR IN 1ST CLASS AREA IAW AMM 05-51-26-800-801-C1, NO FAULT NOTED.SDR DALA2025120608923Transducer · faultedATB DUE TO ENG 2 A.ICE ECAM WARNING, CANNOT CONTINUE IN ICING. REPLACED UPPER VALVE (4010DN), LOWER VALVE (4011DN), AND TRANSDUCER (4003DN). (LP 7887202)SDR N6WA2025120601Lever · inoperativeLH OVERWING EMERGENCY EXIT DOOR FAILED OPS CHECK, DOOR INDICATION INOP. REMOVED AND REPLACED LH EMERG. EXIT DOOR INDICATOR LEVER IAW CRJ AMM 52-30-10. OPS CHECK GOODSDR QMLA2025120420122Windshield · crackedUPON LANDING, A CRACK WAS FORMED AND WAS DISCOVERED LATERALLY ON THE RT WINDSCREEN THAT WENT FROM THE LT EDGE ALMOST TO THE RT EDGE.SDR AALA202512059023Battery Pack · no testAIRCRAFT WAS GROUNDED: EMERGENCY AISLE FLOOR PATH LIGHTING REMAINS ILLUMINATED FROM ROWS 24 TO 30. FOUND WCU 27 INOPERATIVE CORRELATED WITH MMSG 33-12127. ACCOMPLISHED FIM 33-50-F1-P0A-421A. REMOVE AND REPLACED WCU (AALA202512058858) AND WBU (AALA202512059023)SDR AALA202512052363Heater · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: TEMP PROBE LIGHT WITH MASTER CAUTION ILLUMINATED AT LIFTOFF AND REMAINED ON THROUGH REMAINDER OF FLIGHT. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOMPLISHED FIM TASK 30-31-00-810-SDR AALA202512056028Cover · detachedAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER AT 1L NEEDS TO BE RE ATTACHED. EXIT SIGN COVER ATTACHED IAW AMM 33-51-01.SDR AALA202512052756Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE DETECTOR IN FORWARD LAVATORY GOING OFF RANDOMLY. REMOVED AND REPLACED FORWARD LAVATORY SMOKE DETECTOR, OPS CHECK GOOD IAW AMM 26-14-01.SDR AALA202512052095Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT DOES NOT ILLUMINATE WITH PUMP TURNED OFF. INSPECTED AND CLEANED RIGHT HAND AFT FUEL BOOST PUMP PRESSURE SWITCH ELECTRICAL CONNECTOR, OPS TESTED GOOD IAW AMM 28-42-11.SDR AALA202512059058Sign · missingAIRCRAFT WAS NOT GROUNDED: MID CABIN CEILING MOUNTED EMERGENCY EXIT SIGN MISSING. INSTALLED NEW EXIT SIGN ON MID CABIN CEILING MOUNTED EMERGENCY. PER MM 33-51-01.SDR AALA202512059518Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS EMERGENCY FLASHLIGHT INOPERATIVE FORWARD JUMPSEAT. REMOVE AND REPLACED FLASHLIGHT. PER AMM 25-64-00-200-803.SDR AALA202512051107Light · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT 3L, 3R, AND AFT REMAIN ON. PERFORMED CHECK AND FOUND HIGH RESISTENACE ON PIN 2 OD DM3351WG07P01. REPLACED LEFT HAND SEAT TRACK COVER #28D, 29D, 30D, 31D AND 32D. PER AMM 25-25-02. WIRING SHAKE TEST GOOD, LIGHTSDR AALA202512058858Controller · no testAIRCRAFT WAS GROUNDED: EMERGENCY AISLE FLOOR PATH LIGHTING REMAINS ILLUMINATED FROM ROWS 24 TO 30. FOUND WCU 27 INOPERATIVE CORRELATED WITH MMSG 33-12127. ACCOMPLISHED FIM 33-50-F1-P0A-421A. REMOVE AND REPLACED WCU (AALA202512058858) AND WBU (AALA202512059023)SDR ASAA2025120462841Elec Connector · damagedWHILE ACCOMPLISHING T/C 800-33FCD-29647-1 FOUND D12452 & D12464 PLUGS HAD BROKEN LATCH RETAINERS. GROUNDED - YES. REPLACED D12452 & D12464 PLUGS (CONNECTORS) WDM 33-51-13 SWPM 20-61-28. E LIGHT TESTS PASS.SDR ASAA2025120462138Control Unit · faultedL4 DOOR EMERGANCY LIGHT FAULT MESSAGE IN CMCF. GROUNDED - YES. REMOVED AND REPLACED 4L DOOR WELS CONTROL UNIT PER AMM 33-51-07-01A0720A. OPS CHECK GOOD, NO FAULTS IN CMCF.SDR QXEA2025120500361Unknown · leakingFOUND FUEL LEAKING FROM NR 2 ENGINE DRAIN MAST. REMOVED FROM SERVICE. RAN NR 2 ENGINE, LEAK DETERMINED TO BE OUT OF LIMITS IAW MCN E720036-01. REQUIRES FURTHER TROUBLESHOOTING. C/W T/C E175-75-32-01-000/400-801-A. OPS TEST GOOD. NFDN. COULD NOT DUPLICATE LEAK.SDR SWIA2025120500004Processor · faultedAVNX MAY 1 FAIL CLIMBING OUT OF SEA. (FLIGHT 4068) INTERROGATED CMC FOUND FAULT CODE 45452143CMC AVNX MAU 1A FAIL. TROUBLESHOOT PER ERJ FIM 45-45-00-810-939-A. PERFORMED MAU1 NIC1 MODULE RESET TEST. TEST PASSED. PERFORMED ENG 1 & ENG 2 START SUCCESSFULLY NSDR SIMA202512054001Bleed Air Sys · faultedBLEED 2 FAIL AT ALTITUDE. MSG EVENTUALLY CLEARED VIA QRH PROCEDURE INFO TO MTX. INFO NOTED TO MTX MOC 230070. PENDING CORRECTIVE ACTIONSDR J7SA2025120500464Fce · faultedWHILE DOING THE FLIGHT CONTROL CHECK AFTER STARTUP, GND SPOILER FAIL CAS. REPLACED FCE #2 IAW EMB 505 AMM TASK 27-03-01-400-801. RIGGING AND OPS CHECK SATISFACTORY AT THIS TIME.SDR WX0A2025120532660Battery Pack · faulted(AIRCRAFT NOT GROUNDED) EPSU BATTERY FAULT. REMOVED AND REPLACED EPSU REF WO537555"SDR WX0A2025120532659Light · no test(AIRCRAFT NOT GROUNDED) DURINNG CABIN EMERGENCY LIGHTING CHECK, BATTERY CAPACITY FOUND EPSU FWD LT, DEU-B FAULT. PERFORMED TSM 33-51-00-810-830-A, EXHAUSTED TSM & FAULT REMAINED. REMOVED & REINSTALLED L1 & R1 DOOR SLIDES DURING TSHOOTING IAW AMM 25-62-44-00SDR IPXA2025120562383Door · faultedPASSENGER ENTRY DOOR DOES NOT CLOSE FLUSH WHEN CLOSED. COULD NOT DUPLICATE FAULT, HANDLE MECHANISM OPS CHECK GOOD IAW AMM 52-11-13SDR ABXA202512054318Valve · faultedDURING TAXI OUT, AFT CABIN TEMP MESSAGE APPEARED BEFORE ENG START. AIRCRAFT RETURNED TO GATE (BTB). MAINTENANCE DEFERRED AFT ZONE TEMP MOD TRIM VALVE IAW ABX B767 MEL 21-61-1-2. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025120508921Battery Pack · inoperativeDURING SVC CHK FOUND EMERGENCY LIGHTS IN AISLE 13, 14, 15, 16, 19, 20, 23, 24, 30, 31, 32, 36 AND 37 DO NOT TURN ON. REPLACED 11WL BATTERY PER A321 AMM 33-51. (LP 8149558)SDR DALA2025120508922O-Ring · leakingF/AS NOTED WET/DIRTY/PAINT SMELL IN FRONT AND AFT OF CABIN DURING DESCENT & LANDING BOTH FLIGHTS. NOTHING NOTED IN COCKPIT. ENGINE RUN CONFIRMED SMELL EVIDENCE OF OIL BEHIND SPINNER. REPLACED NBR 1 ENGINE FAN SHAFT COVER O'RING. (LP 8118618)SDR DALA2025120508919Unknown · odorRETURNED TO STL DUE TO BURNT OIL SMELL AT 300FT AFTER GEAR RETRACTION. UNABLE TO DUPLICATE ODOR AT GATE RUNNING APU OR ENGINES. GATHERING PARTS AND P-TRACK FROM CARGO TO BEGIN FURTHER EVALUATION. FOUND GLYCOL IN RAM AIR INLET. REPLACED COALESCER BAGS AND DUCSDR DALA2025120508899Girt Bar · fodR1 DOOR WILL NOT ARM. CLEANED AND RESET GIRT BAR. REF B757 AMM 25-66. OPS CK GOOD. (7693732)SDR DALA2025120508893Drag Fitting · gougedA.D.//A.A. DAMAGES WERE FOUND ON OPEN HOLES AT RH ENG DRAG FTG AS FOLLOW; HOLE #11 GOUGE ON FITTING 11 O CLOCK POSITION, HOLE #13 CORROSION ON SKIN & FITTING, HOLE #14 GOUGE ON FITTING 11 O CLOCK POSITION, HOLE #15 GOUGE ON FITTING 12 O CLOCK POSITION, HOLE #1SDR DALA2025120508892Door Sill · corrodedAFT CARGO LOWER SILL CHORD WEB IS CORRODED AT B STA 1440, BETWEEN S-27R AND S-28R. AFT LWR CORNER OF DOOR CUT OUT. REMOVED & REPLACED WEB AT STA 1440 BETWEEN STR 27R & 28R IAW B757 SRM 51-40-02 SECTION 7. (1335167)SDR AALA202512050800Power Supply · no testAIRCRAFT WAS GROUNDED: FORWARD LEFT EMERGENCY POWER SUPPLY UNIT FAILED OPERATIONAL TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202512059766Speaker · no testAIRCRAFT IN BASE MAINTENANCE: STATION 3 HAS NO ALARM NOISE, THE VISIONAL ALERT WORKS BUT NO AURAL WARNING. MAINTENANCE REPLACED THE LOUDSPEAKER PER AMM 23-73-51 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY EVACUATION SIGNALING SYSTEM PER SDR AALA202512055598Speaker · no testAIRCRAFT IN BASE MAINTENANCE: STATION 2 HAS NO ALARM NOISE, THE VISIONAL ALERT WORKS BUT NO AURAL WARNING. MAINTENANCE REPLACED THE LOUDSPEAKER PER AMM 23-73-51 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY EVACUATION SIGNALING SYSTEM PER SDR AALA202512051418Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512058020Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT JUMPSEAT 4L FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-60-00.SDR AALA202512053599Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512053134Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512052028Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DXTA2025120505967Light · inoperativeFORWARD EMERGENCY OVERWING LIGHT INOP WHEN CHECKING EMER LIGHTS ON THE GROUND. CORRECTIVE ACTION: REMOVED AND REPLACED FWD EMERGENCY OVWING LIGHT ASSY IAW MM 33-50-00. OPS CHECK GOOD.SDR DXTA2025120505972Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS NOT WORKING. INTERIOR RIGHT SIDE OF AIRCRAFT ON FLOOR LIGHTING BOTH EXTERIOR OVER WING EMERGENCY LIGHTS NOT WORKING. DEBRIEFED THE CREW EARLIER, AND UPON POWER-UP, WE FOUND THAT ELPS 2 WAS NOT ILLUMINATING THE DESCRIBED EMERGENCY SDR DXTA2025120505973Light · inoperativeLOWER EMERGENCY EXIT SIGN LIGHT DOES NOT ILLUMINATE TECHS GOT ONISTE AND VERIFIED THAT THE AFT EMER LIGHT WAS INOP. TECHS THEN SWAPPED THE AFT EMER LIGHT TO THE FWD AND FAULT DID NOT FOLLOW. WE THEN PUT EVERYTHING INTO NORMAL CONFIGURATION AND ALL LIGHTS ARE SDR FDEA202512042219Lamp · inoperativeEMERGENCY LIGHT OVERHEAD DOOR 1L INOPERATIVE. REPLACED THE LAMP OF EMERGENCY AREA LIGHT OVERHEAD DOOR 1L REF AMM 33-51-03-2 , TEST NORMAL. A/C OK TO CONTINUE.SDR DALA2025120508884Spinner · leakingFUMES EVENT IN AFT GALLEY WITH STINKY SOCK SMELL BEGINNING AT TOP OF DESCENT WHEN THROTTLES PULLED TO IDLE. FUMES LASTED FOR 10 MINS & WENT AWAY WHEN THROTTTLES WERE INCREASE FOR APPROACH NO FUMES IN FIRST CLASS OR FLIGHT DECK SMOKE & FUMES. FOUND OIL WETTINSDR DALA2025120508883Light · missingSEAT ROW 11DEF MISSING EMER PATHWAY LIGHT. REPLACED 11DEF EMER LIGHT ASSY PER B737 AMM 33-51 - CKS OK.SDR DALA2025120508880Stringer · failed inspGAP BETWEEN STRINGER 18AL WEB AND BS 727 INNER CHORD FOUND TO BE GREATER THAN 0.006". REPAIRED BY INSTALLING SHIM PER FORECAST CARD 38-0553-8-0154 WORK CARD 5311-01251-02A.SDR DALA2025120508879Window Frame · corrodedCORROSION ON ON CAPTAINS NR 3 WINDOW FRAME EXTERIOR FWD EDGE. INSTALLED A NEW NR 3 WINDOW FRAME IAW DWG 141A8800, REV D, AND SRM 51-40-02-0G.SDR SCNA20251205461Girt Bar · out of positionGIRT BAR, DOOR L1 STUCK IN UNARMED POSITION. REPOSITIONED THE GIRT BAR ON L1 DOOR OK FOR SERVICE IAW AMM 25-66-02SDR SCNA20251205460Slide · dislodgedUPON OPENING L1 DOOR, L1 SLIDE FELL, DID NOT DEPLOY FOUND LOWER LATCH DISENGANGED. RESECURED L1 SLIDE PER AMM 25-66-01. INSPECTED & OK FOR SERVICE.SDR 3J7R2025120500001Power Supply · inoperativeEXIT SIGN ON FWD BULKHEAD IN THE CABIN ABOVE SEAT 1 INOPERATIVE.SDR CALA2025120511811Floorbeam · corrodedAFT FLOORBEAM, FRAME 68 LT CORRODED. AFT FLOORBEAM REMOVED & REPLACED IAW SRM 51-4 2-11.SDR CALA2025120511809Seat Track · corrodedY-765 LT FR 64-70 SEAT TRACK CORRODED OUT OF LIMITS AT FR68. REMOVED & REPLACED THE SEAT TRACK IAW SRM 51-72 -11-911.